Andyblg's Blog

August 23, 2012

run concurrent program twice with different layout r12

Filed under: ebs — andyblg @ 13:59
Tags: ,

Task:

using one xml data definition and several layout of report and generate it in one step by main concurrent program

Plan:

1) create data definition (XXAND10_1)

2) create two template with different content (XXAND10_1 and XXAND10_2) but based on one data definition

3) create concurrent for working (merging) with data definition and template (XXAND10_1)

4) create main concurrent which will run one concurrent with different template

Go…..
Step 1:

Step 2:

Step 3:

Step 4:

procedure conc_twice(errbuf              out varchar2,
retcode             out varchar2)
is
v_request_id   number;
xml_layout boolean;
begin

xml_layout := FND_REQUEST.ADD_LAYOUT('FND','XXAND10_1','en','US','RTF');
v_request_id := fnd_request.submit_request('FND','XXAND10_1','Template 1',NULL,FALSE, null);

if v_request_id > 0 then
fnd_file.put_line(fnd_file.log,'XXAND10_1 with Template 1 - successfully submitted.');
commit;
else
fnd_file.put_line(fnd_file.log,'XXAND10_1 with Template 1 - not submitted.');
rollback;
end if;

xml_layout := FND_REQUEST.ADD_LAYOUT('FND','XXAND10_2','en','US','RTF');
v_request_id := fnd_request.submit_request('FND','XXAND10_1','Template 2',NULL,FALSE, null);

if v_request_id > 0 then
fnd_file.put_line(fnd_file.log,'XXAND10_1 with Template 2 - successfully submitted.');
commit;
else
fnd_file.put_line(fnd_file.log,'XXAND10_1 with Template 2 - not submitted.');
rollback;
end if;

end;

Add XXAND10 concurrent program to reguest group

Test:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
XXAND10_1 with Template 1 - successfully submitted.
XXAND10_1 with Template 2 - successfully submitted.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Advertisements

1 Comment »

  1. Hello! Would you mind if I share your blog with my zynga group?
    There’s a lot of people that I think would really enjoy your content.
    Please let me know. Thank you

    Comment by business travel expenses — December 3, 2014 @ 00:55 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: