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.MSC_PHUB_PKG dependencies on FND_REQUEST

Line 273: l_req_id := fnd_request.submit_request('MSC','MSCHUB1',NULL,

269: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
270: fnd_message.set_token('TABLE_NAME', 'Exceptions');
271: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
272: --msc_exception_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
273: l_req_id := fnd_request.submit_request('MSC','MSCHUB1',NULL,
274: null, false, p_plan_id, p_plan_run_id);
275: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
276: fnd_message.set_token('TABLE_NAME', 'Exceptions');
277: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 289: l_req_id := fnd_request.submit_request('MSC','MSCHUB2',NULL,

285: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
286: fnd_message.set_token('TABLE_NAME', 'Resources');
287: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
288: --msc_resource_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
289: l_req_id := fnd_request.submit_request('MSC','MSCHUB2',NULL,
290: null, false, p_plan_id, p_plan_run_id);
291: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
292: fnd_message.set_token('TABLE_NAME', 'Resources');
293: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 305: l_req_id := fnd_request.submit_request('MSC','MSCHUB3',NULL,

301: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
302: fnd_message.set_token('TABLE_NAME', 'Suppliers');
303: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
304: --msc_supplier_pkg.populate_details(errbuf, retcode, p_plan_id,p_plan_run_id);
305: l_req_id := fnd_request.submit_request('MSC','MSCHUB3',NULL,
306: null, false, p_plan_id, p_plan_run_id);
307: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
308: fnd_message.set_token('TABLE_NAME', 'Suppliers');
309: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 321: l_req_id := fnd_request.submit_request('MSC','MSCHUB4',NULL,

317: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
318: fnd_message.set_token('TABLE_NAME', 'Supplies');
319: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
320: --msc_supply_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
321: l_req_id := fnd_request.submit_request('MSC','MSCHUB4',NULL,
322: null, false, p_plan_id, p_plan_run_id);
323: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
324: fnd_message.set_token('TABLE_NAME', 'Supplies');
325: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 337: l_req_id := fnd_request.submit_request('MSC','MSCHUB5',NULL,

333: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
334: fnd_message.set_token('TABLE_NAME', 'Demands');
335: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
336: --msc_demand_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
337: l_req_id := fnd_request.submit_request('MSC','MSCHUB5',NULL,
338: null, false, p_plan_id, p_plan_run_id);
339: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
340: fnd_message.set_token('TABLE_NAME', 'Demands');
341: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 353: l_req_id := fnd_request.submit_request('MSC','MSCHUB6',NULL,

349: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
350: fnd_message.set_token('TABLE_NAME', 'Item');
351: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
352: --msc_item_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
353: l_req_id := fnd_request.submit_request('MSC','MSCHUB6',NULL,
354: null, false, p_plan_id, p_plan_run_id);
355: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
356: fnd_message.set_token('TABLE_NAME', 'Item');
357: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

Line 679: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_purge_plan_run_id);

675: open c_prior_plan_run;
676: fetch c_prior_plan_run into l_purge_plan_run_id;
677: close c_prior_plan_run;
678: --purge_details(l_purge_errbuf, l_purge_retcode, g_plan_id, l_purge_plan_run_id);
679: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_purge_plan_run_id);
680: commit;
681:
682: msc_wait_for_request(l_purge_req_id, l_max_wait_time, l_out_status);
683: if ( l_out_status = sys_no ) then

Line 742: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_plan_run_id);

738: errbuf := 'Error while populating the fact tables. purging this plan summary. ';
739: println(errbuf);
740:
741: --purge_details(l_purge_errbuf, l_purge_retcode, g_plan_id, l_plan_run_id);
742: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_plan_run_id);
743: commit;
744: end if;
745: end if; --}
746:

Line 943: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_purge_plan_run_id);

939: fetch c_prior_plan_run into l_purge_plan_run_id;
940: close c_prior_plan_run;
941:
942: --purge_details(l_purge_errbuf, l_purge_retcode, g_plan_id, l_purge_plan_run_id);
943: l_purge_req_id := fnd_request.submit_request('MSC','MSCHUBP',NULL, NULL, FALSE, g_plan_id, l_purge_plan_run_id);
944: commit;
945:
946: msc_wait_for_request(l_purge_req_id, l_max_wait_time, l_out_status);
947: if ( l_out_status = sys_no ) then