Normally we use FND_REQUEST.SUBMIT_REQUEST to submit
a concurrent program using PL/SQL.
If we use FND_REQUEST.SUBMIT_REQUEST to submit a RTF report related concurrent program that time we get the below error:
Error: No completion options were requested.
PL/SQL script completed normally but output not created in RTF format.
**ADD_LAYOUT procedure should be called only when there is a layout associated to a concurrent program
We can attach a layout to the concurrent request by using another procedure ADD_LAYOUT which belongs to the same package FND_REQUEST.
For Example: This example shows – how to use ADD_LAYOUT in PL/SQL:
Step 1) Add FND_REQUEST.ADD_LAYOUT
lb_layout BOOLEAN;
apps.fnd_global.apps_initialize(ln_user_id, ln_resp_id, ln_application_id);
**Use Apps Initialize
lb_layout :=
apps.fnd_request.add_layout
(template_appl_name =>
'INV' --> Data Template application
short name
,template_code => 'INVMO' --> Data Template short name (code)
,template_language =>
'en' --> Data Template language
,template_territory => 'US' --> Data Template
territory
,output_format => 'RTF' --> Data Template output format.
);
Step 2) Add FND_REQUEST.SUBMIT_REQUEST
ln_request_id :=
apps.fnd_request.submit_request
(application
=> 'INV' --> Application Short Name
,program => 'INVMO' --> Program Short Name
,description => NULL --> Program Description
,start_time => NULL
,sub_request => FALSE
,argument1 => ln_organization_id --> 1st parameter value
,argument2 =>
lc_move_order_num --> 2nd parameter
value
,argument3 => lc_move_order_num --> 3rd parameter value
);
Step 3) Create
concurrent program for above PL/SQL script and execute the concurrent program.
