Home » Applications » Oracle Fusion Apps & E-Business Suite » fnd_request.submit_request (Oracle forms/Apps)
fnd_request.submit_request [message #482810] Mon, 15 November 2010 23:48 Go to next message
adit102
Messages: 9
Registered: November 2010
Junior Member
I have PLSQL procedure as concurrent program and I want to submit this request on button click in a form. I have written following code in WHEN-BUTTON-PRESSED trigger of the button

declare
l_request_id number;
begin
l_request_id := fnd_request.submit_request('CCMS Custom Application','XXEMP_REP',NULL,NULL,FALSE,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL)return number;
end;

This code returns error as
Encountered symbol 'RETURN' when expecting one of the following
.(&%+=...at in is mod and or like between || multiset member SUBMULTISET_
Is there any problem with the syntax?

Kindly help.

Aditya
  • Attachment: Trigger.txt
    (Size: 0.84KB, Downloaded 1515 times)
Re: fnd_request.submit_request [message #482812 is a reply to message #482810] Tue, 16 November 2010 00:04 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A missing semicolon (at least, that's obvious):

NULL,
NULL)return number;
end;

Should be
NULL,
NULL);

return number;

end;
Re: fnd_request.submit_request [message #482818 is a reply to message #482812] Tue, 16 November 2010 00:34 Go to previous messageGo to next message
adit102
Messages: 9
Registered: November 2010
Junior Member
Hi,

Thanks for the 'semicolon'.
These are that changes did in my code

NULL,
NULL);

return;
end;

It has compiled nicely. Now I already have a concurrent prog registered to a reponsibility, but on clicking the button nothings happening.

THanks

Aditya
Re: fnd_request.submit_request [message #482826 is a reply to message #482818] Tue, 16 November 2010 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's beyond my knowledge, sorry - I don't use Oracle Apps. However, as we do have experts here, I hope your question will be answered as soon as possible.
Re: fnd_request.submit_request [message #482832 is a reply to message #482826] Tue, 16 November 2010 01:48 Go to previous messageGo to next message
adit102
Messages: 9
Registered: November 2010
Junior Member
Ok,
No problem...
Thanks for the help... Smile
Re: fnd_request.submit_request [message #482865 is a reply to message #482832] Tue, 16 November 2010 08:40 Go to previous messageGo to next message
ShivarajRajappan
Messages: 2
Registered: November 2010
Location: Hyderabad, India
Junior Member
Make sure that you are committing the transaction somewhere. The FND API does not commit itself. So, you need to take care of that in your routine.

- Shivaraj
Re: fnd_request.submit_request [message #512312 is a reply to message #482865] Sat, 18 June 2011 13:55 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

ya i have used commit.but there is no action.request not submitted.
Re: fnd_request.submit_request [message #516716 is a reply to message #512312] Wed, 20 July 2011 04:29 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Still having issues?

By
Vamsi
Re: fnd_request.submit_request [message #517072 is a reply to message #516716] Fri, 22 July 2011 06:16 Go to previous message
vishalk
Messages: 33
Registered: October 2010
Member

use
fnd_global.apps_initialize()

before submitting a request.
Previous Topic: customer email address
Next Topic: How to pass parameter not insequence to apps oracle reports
Goto Forum:
  


Current Time: Mon Dec 23 09:22:35 CST 2024