eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on FND_FILE

Line 44: fnd_file.put_line(fnd_file.log,'FROM Date is taken from the Last Run Date of the Concurrent Program');

40: FND_CONCURRENT_PROGRAMS prg where req.concurrent_program_id = prg.concurrent_program_id
41: and prg.concurrent_program_name = 'POSSUPPUBJOB' and actual_completion_date is not null
42: order by actual_completion_date desc) where rownum=1;
43: l_to_date := SYSDATE;
44: fnd_file.put_line(fnd_file.log,'FROM Date is taken from the Last Run Date of the Concurrent Program');
45: END IF;
46: END IF;
47: ELSE
48: -- HOURS parameter is not null

Line 51: fnd_file.put_line(fnd_file.log,'HOURS parameter is Not Null: Fetching all the Parties modified within '||p_hours||' hour(s)');

47: ELSE
48: -- HOURS parameter is not null
49: l_from_date := SYSDATE - p_hours / 24;
50: l_to_date := SYSDATE;
51: fnd_file.put_line(fnd_file.log,'HOURS parameter is Not Null: Fetching all the Parties modified within '||p_hours||' hour(s)');
52: END IF;
53:
54: l_from_date := to_date(to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
55: l_to_date := to_date(to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');

Line 57: fnd_file.put_line(fnd_file.log,'Parameters passed to the Program are as below:');

53:
54: l_from_date := to_date(to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
55: l_to_date := to_date(to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
56:
57: fnd_file.put_line(fnd_file.log,'Parameters passed to the Program are as below:');
58: fnd_file.put_line(fnd_file.log,'-----------------------------------------------');
59: fnd_file.put_line(fnd_file.log,'FROM DATE:'||to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'));
60: fnd_file.put_line(fnd_file.log,'TO DATE:'||to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'));
61:

Line 58: fnd_file.put_line(fnd_file.log,'-----------------------------------------------');

54: l_from_date := to_date(to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
55: l_to_date := to_date(to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
56:
57: fnd_file.put_line(fnd_file.log,'Parameters passed to the Program are as below:');
58: fnd_file.put_line(fnd_file.log,'-----------------------------------------------');
59: fnd_file.put_line(fnd_file.log,'FROM DATE:'||to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'));
60: fnd_file.put_line(fnd_file.log,'TO DATE:'||to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'));
61:
62: -- Begin Bug 13833924/12765249

Line 59: fnd_file.put_line(fnd_file.log,'FROM DATE:'||to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'));

55: l_to_date := to_date(to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'),'MM/DD/YYYY HH24:MI:SS');
56:
57: fnd_file.put_line(fnd_file.log,'Parameters passed to the Program are as below:');
58: fnd_file.put_line(fnd_file.log,'-----------------------------------------------');
59: fnd_file.put_line(fnd_file.log,'FROM DATE:'||to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'));
60: fnd_file.put_line(fnd_file.log,'TO DATE:'||to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'));
61:
62: -- Begin Bug 13833924/12765249
63: SELECT party_id

Line 60: fnd_file.put_line(fnd_file.log,'TO DATE:'||to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'));

56:
57: fnd_file.put_line(fnd_file.log,'Parameters passed to the Program are as below:');
58: fnd_file.put_line(fnd_file.log,'-----------------------------------------------');
59: fnd_file.put_line(fnd_file.log,'FROM DATE:'||to_char(l_from_date,'MM/DD/YYYY HH24:MI:SS'));
60: fnd_file.put_line(fnd_file.log,'TO DATE:'||to_char(l_to_date,'MM/DD/YYYY HH24:MI:SS'));
61:
62: -- Begin Bug 13833924/12765249
63: SELECT party_id
64: BULK COLLECT

Line 173: fnd_file.put_line(fnd_file.log,'Total Number of Published Parties: Count:'||partyid_list.count);

169: -- End Bug 13833924/12765249
170:
171: if partyid_list.count>0 then
172:
173: fnd_file.put_line(fnd_file.log,'Total Number of Published Parties: Count:'||partyid_list.count);
174: p_publication_event_id := get_curr_supp_pub_event_id;
175: fnd_file.put_line(fnd_file.log,'Publication event Id:'||p_publication_event_id);
176: --Calling the Supplier Publish Package
177: pos_supp_pub_raise_event_pkg.get_bo_and_insert(partyid_list,

Line 175: fnd_file.put_line(fnd_file.log,'Publication event Id:'||p_publication_event_id);

171: if partyid_list.count>0 then
172:
173: fnd_file.put_line(fnd_file.log,'Total Number of Published Parties: Count:'||partyid_list.count);
174: p_publication_event_id := get_curr_supp_pub_event_id;
175: fnd_file.put_line(fnd_file.log,'Publication event Id:'||p_publication_event_id);
176: --Calling the Supplier Publish Package
177: pos_supp_pub_raise_event_pkg.get_bo_and_insert(partyid_list,
178: p_publication_event_id,
179: p_published_by,

Line 185: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');

181:
182: --Calling the workflow section to raise the workflow event
183: l_event_key := pos_supp_pub_raise_event_pkg.raise_publish_supplier_event(p_publication_event_id);
184: else
185: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
186: fnd_file.put_line(fnd_file.log,'MESSAGE:** No Party IDs are available to Publish in the given date range **');
187: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
188:
189: end if;

Line 186: fnd_file.put_line(fnd_file.log,'MESSAGE: No Party IDs are available to Publish in the given date range ');

182: --Calling the workflow section to raise the workflow event
183: l_event_key := pos_supp_pub_raise_event_pkg.raise_publish_supplier_event(p_publication_event_id);
184: else
185: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
186: fnd_file.put_line(fnd_file.log,'MESSAGE:** No Party IDs are available to Publish in the given date range **');
187: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
188:
189: end if;
190:

Line 187: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');

183: l_event_key := pos_supp_pub_raise_event_pkg.raise_publish_supplier_event(p_publication_event_id);
184: else
185: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
186: fnd_file.put_line(fnd_file.log,'MESSAGE:** No Party IDs are available to Publish in the given date range **');
187: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------------------------------');
188:
189: end if;
190:
191: EXCEPTION

Line 193: fnd_file.put_line(fnd_file.log,'EXCEPTION :' || SQLCODE ||'Error Message :'|| SQLERRM);

189: end if;
190:
191: EXCEPTION
192: WHEN OTHERS THEN
193: fnd_file.put_line(fnd_file.log,'EXCEPTION :' || SQLCODE ||'Error Message :'|| SQLERRM);
194:
195: END publish_supp_event_job;
196: ----------------------------------------------
197: FUNCTION get_curr_supp_pub_event_id RETURN NUMBER IS