Declare
l_request_id number(10);
begin
l_request_id:= FND_REQUEST.SUBMIT_REQUEST ('PO',
'USERSLIST',
'Test Program',
'',
'',
1500,
1600,
'EMAIL_ADDRESS');
Commit;
if l_request_id != 0 then
Fnd_File.Put_line(Fnd_file.log,'Program succesfullt submitteed');
else
Fnd_File.Put_line(Fnd_file.log,'Program Not succesfull submitteed There are some errors');
End If;
Exception
when others then
Fnd_File.Put_line(Fnd_file.log,'Exception raised at the time of submission');
End;
Form Triggers
==============
Declare
l_request_id number(10);
begin
l_request_id:= FND_REQUEST.SUBMIT_REQUEST ('PO',
'USERSLIST',
'Test Program',
'',
'',
1500,
1600,
'EMAIL_ADDRESS',
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','',''
'','','','','','','','','','');
Commit;
if l_request_id != 0 then
Fnd_File.Put_line(Fnd_file.log,'Program succesfullt submitteed');
else
Fnd_File.Put_line(Fnd_file.log,'Program Not succesfull submitteed There are some errors');
End If;
Exception
when others then
Fnd_File.Put_line(Fnd_file.log,'Exception raised at the time of submission');
End;
Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Tuesday, June 21, 2011
PL/SQL,SQL,Reports Triggers
Subscribe to:
Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
No comments:
Post a Comment