SQL & PL/SQL

Hi,

Thanks for your help as always ....

I have a build a pl/sql report in oracle apps.
When i ran the report for 'American English' with date as a parameter the report is running fine.
But the same when i ran for 'Brazilian Portuguese' it is erroring out.
I found that the issue is because of the date , which is different from English to Portuguese.
As an example , the month 'FEB' is in English but the same is 'FEV' in Portuguese

I tried to alter the session when the report is running for 'Brazil' but sit goes in vain.
Below is way i try to handle the condition.
IF L_BOOK_TYPE = 'BRAZIL' THEN
execute immediate 'alter session set nls_language=Brazilian Portuguese';
end if;

Please give an assistance on this.