Oracle Forms

Hi All,


I want to achieve the following through form personalization.

The requirement is to submit a concurrent program on clicking a Menu item.
Say Tools -> Submit Test Program. After the concurrent Program is sumbitted the Request Id should be Displayed as a message to the user.

I was able to sumbit the required concurrent program by using Action Type BuiltIn and BuiltIn Type Execute A Procedure.

The problem I face is I coulnt display the request id as a message .

The Code that I used is

='DECLARE
X_REQUEST_ID NUMBER;
BEGIN
X_REQUEST_ID :=fnd_request.submit_request( APPLICATION => ''AR'',
PROGRAM => 'XXX_TEST'',
DESCRIPTION => '''',
START_TIME =>'''',
SUB_REQUEST => FALSE);'||
:GLOBAL.X_REQ_ID||':=X_REQUEST_ID;
commit;
END'


Couldnt assign the request id to global variable.

The global variable value is used in message Action Type to display the value to user.

Is any other workaround posible?

Thanks,
Priya.