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_MESSAGE

Line 261: fnd_message.set_name('MSC', 'MSC_HUB_GREG_CAL_ERROR');

257: println('populating msc_calendar_dtl ends');
258: exception
259: when others then
260: p_return_status := -3;
261: fnd_message.set_name('MSC', 'MSC_HUB_GREG_CAL_ERROR');
262: println(fnd_message.get||' - '||SQLERRM);
263: end flush_greg_calendar;
264:
265: function submit_exceptions_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 262: println(fnd_message.get||' - '||SQLERRM);

258: exception
259: when others then
260: p_return_status := -3;
261: fnd_message.set_name('MSC', 'MSC_HUB_GREG_CAL_ERROR');
262: println(fnd_message.get||' - '||SQLERRM);
263: end flush_greg_calendar;
264:
265: function submit_exceptions_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
266: p_plan_id number, p_plan_run_id number) return number is

Line 269: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

265: function submit_exceptions_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
266: p_plan_id number, p_plan_run_id number) return number is
267: l_req_id number := 0;
268: begin
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,

Line 270: fnd_message.set_token('TABLE_NAME', 'Exceptions');

266: p_plan_id number, p_plan_run_id number) return number is
267: l_req_id number := 0;
268: begin
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);

Line 271: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

267: l_req_id number := 0;
268: begin
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');

Line 275: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
278: return l_req_id;
279: end submit_exceptions_f;

Line 276: fnd_message.set_token('TABLE_NAME', 'Exceptions');

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);
278: return l_req_id;
279: end submit_exceptions_f;
280:

Line 277: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
278: return l_req_id;
279: end submit_exceptions_f;
280:
281: function submit_resources_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 285: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

281: function submit_resources_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
282: p_plan_id number, p_plan_run_id number) return number is
283: l_req_id number := 0;
284: begin
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,

Line 286: fnd_message.set_token('TABLE_NAME', 'Resources');

282: p_plan_id number, p_plan_run_id number) return number is
283: l_req_id number := 0;
284: begin
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);

Line 287: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

283: l_req_id number := 0;
284: begin
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');

Line 291: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
294: return l_req_id;
295: end submit_resources_f;

Line 292: fnd_message.set_token('TABLE_NAME', 'Resources');

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);
294: return l_req_id;
295: end submit_resources_f;
296:

Line 293: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
294: return l_req_id;
295: end submit_resources_f;
296:
297: function submit_suppliers_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 301: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

297: function submit_suppliers_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
298: p_plan_id number, p_plan_run_id number) return number is
299: l_req_id number := 0;
300: begin
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,

Line 302: fnd_message.set_token('TABLE_NAME', 'Suppliers');

298: p_plan_id number, p_plan_run_id number) return number is
299: l_req_id number := 0;
300: begin
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);

Line 303: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

299: l_req_id number := 0;
300: begin
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');

Line 307: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
310: return l_req_id;
311: end submit_suppliers_f;

Line 308: fnd_message.set_token('TABLE_NAME', 'Suppliers');

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);
310: return l_req_id;
311: end submit_suppliers_f;
312:

Line 309: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
310: return l_req_id;
311: end submit_suppliers_f;
312:
313: function submit_supplies_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 317: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

313: function submit_supplies_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
314: p_plan_id number, p_plan_run_id number) return number is
315: l_req_id number := 0;
316: begin
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,

Line 318: fnd_message.set_token('TABLE_NAME', 'Supplies');

314: p_plan_id number, p_plan_run_id number) return number is
315: l_req_id number := 0;
316: begin
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);

Line 319: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

315: l_req_id number := 0;
316: begin
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');

Line 323: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
326: return l_req_id;
327: end submit_supplies_f;

Line 324: fnd_message.set_token('TABLE_NAME', 'Supplies');

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);
326: return l_req_id;
327: end submit_supplies_f;
328:

Line 325: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
326: return l_req_id;
327: end submit_supplies_f;
328:
329: function submit_demands_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 333: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

329: function submit_demands_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
330: p_plan_id number, p_plan_run_id number) return number is
331: l_req_id number := 0;
332: begin
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,

Line 334: fnd_message.set_token('TABLE_NAME', 'Demands');

330: p_plan_id number, p_plan_run_id number) return number is
331: l_req_id number := 0;
332: begin
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);

Line 335: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

331: l_req_id number := 0;
332: begin
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');

Line 339: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
342: return l_req_id;
343: end submit_demands_f;

Line 340: fnd_message.set_token('TABLE_NAME', 'Demands');

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);
342: return l_req_id;
343: end submit_demands_f;
344:

Line 341: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
342: return l_req_id;
343: end submit_demands_f;
344:
345: function submit_items_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 349: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

345: function submit_items_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
346: p_plan_id number, p_plan_run_id number) return number is
347: l_req_id number := 0;
348: begin
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,

Line 350: fnd_message.set_token('TABLE_NAME', 'Item');

346: p_plan_id number, p_plan_run_id number) return number is
347: l_req_id number := 0;
348: begin
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);

Line 351: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

347: l_req_id number := 0;
348: begin
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');

Line 355: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

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);
358: return l_req_id;
359: end submit_items_f;

Line 356: fnd_message.set_token('TABLE_NAME', 'Item');

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);
358: return l_req_id;
359: end submit_items_f;
360:

Line 357: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

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);
358: return l_req_id;
359: end submit_items_f;
360:
361: function submit_demantra_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 366: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');

362: p_plan_id number, p_plan_run_id number) return number is
363: l_req_id number := 0;
364: begin
365: println('submit_demantra_f('||p_plan_id||', '||p_plan_run_id||')');
366: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

Line 367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');

363: l_req_id number := 0;
364: begin
365: println('submit_demantra_f('||p_plan_id||', '||p_plan_run_id||')');
366: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');

Line 368: println(fnd_message.get);

364: begin
365: println('submit_demantra_f('||p_plan_id||', '||p_plan_run_id||')');
366: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
372: println(fnd_message.get);

Line 370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');

366: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS_1');
367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
372: println(fnd_message.get);
373: return l_req_id;
374: end submit_demantra_f;

Line 371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');

367: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
372: println(fnd_message.get);
373: return l_req_id;
374: end submit_demantra_f;
375:

Line 372: println(fnd_message.get);

368: println(fnd_message.get);
369: msc_demantra_pkg.populate_details(errbuf, retcode, p_plan_id, p_plan_run_id);
370: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS_1');
371: fnd_message.set_token('TABLE_NAME', 'Demantra Plan');
372: println(fnd_message.get);
373: return l_req_id;
374: end submit_demantra_f;
375:
376: procedure msc_wait_for_request(p_request_id in number,

Line 510: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');

506:
507: begin
508: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
509: retcode := FND_API.G_RET_STS_ERROR;
510: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
511: errbuf := fnd_message.get;
512: println(errbuf);
513: return retcode;
514: end if;

Line 511: errbuf := fnd_message.get;

507: begin
508: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
509: retcode := FND_API.G_RET_STS_ERROR;
510: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
511: errbuf := fnd_message.get;
512: println(errbuf);
513: return retcode;
514: end if;
515:

Line 665: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');

661: begin
662: retcode := 0;
663: errbuf := NULL;
664:
665: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');
666: println(fnd_message.get);
667:
668: g_plan_id := p_plan_id;
669:

Line 666: println(fnd_message.get);

662: retcode := 0;
663: errbuf := NULL;
664:
665: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');
666: println(fnd_message.get);
667:
668: g_plan_id := p_plan_id;
669:
670: if ( p_archive_flag in (-1,1) ) then

Line 768: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');

764: --errbuf := l_purge_errbuf;
765: --retcode := l_purge_retcode;
766: --end if;
767:
768: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');
769: println(fnd_message.get);
770: end populate_details;
771:
772: procedure purge_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 769: println(fnd_message.get);

765: --retcode := l_purge_retcode;
766: --end if;
767:
768: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');
769: println(fnd_message.get);
770: end populate_details;
771:
772: procedure purge_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
773: p_plan_id number, p_plan_run_id number) is

Line 787: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');

783: retcode := 0;
784: errbuf := NULL;
785: g_plan_id := p_plan_id;
786:
787: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');
788: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
789:
790: for r_plan_runs in c_plan_runs
791: loop

Line 788: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

784: errbuf := NULL;
785: g_plan_id := p_plan_id;
786:
787: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');
788: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
789:
790: for r_plan_runs in c_plan_runs
791: loop
792: l_part_retval := manage_partitions(r_plan_runs.plan_run_id, 2);

Line 821: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');

817: msc_item_pkg.purge_details(errbuf, retcode, p_plan_id, p_plan_run_id);
818: commit;
819: */
820:
821: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');
822: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
823:
824: --MSC_HUB_PURGE_ERROR
825: end purge_details;

Line 822: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);

818: commit;
819: */
820:
821: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');
822: println(to_char(sysdate,'YYYY/MM/DD:HH24:MI:SS') || ' ' || fnd_message.get);
823:
824: --MSC_HUB_PURGE_ERROR
825: end purge_details;
826:

Line 930: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');

926: retcode := 0;
927: errbuf := null;
928: g_plan_id := p_scenario_id;
929:
930: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');
931: println(fnd_message.get);
932:
933: if ( p_archive_flag in (-1,1) ) then
934: -- archive the plan

Line 931: println(fnd_message.get);

927: errbuf := null;
928: g_plan_id := p_scenario_id;
929:
930: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_STARTS');
931: println(fnd_message.get);
932:
933: if ( p_archive_flag in (-1,1) ) then
934: -- archive the plan
935: null;

Line 990: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');

986: and plan_run_id = l_plan_run_id;
987:
988: commit;
989:
990: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');
991: println(fnd_message.get);
992: end populate_demantra_details;
993:
994: procedure purge_demantra_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 991: println(fnd_message.get);

987:
988: commit;
989:
990: fnd_message.set_name('MSC', 'MSC_HUB_POPULATE_ENDS');
991: println(fnd_message.get);
992: end populate_demantra_details;
993:
994: procedure purge_demantra_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,
995: p_scenario_id number, p_plan_run_id number) is

Line 1000: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');

996: begin
997: retcode := 0;
998: errbuf := null;
999:
1000: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');
1001: println(fnd_message.get);
1002:
1003: msc_phub_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1004: -- msc_demantra_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);

Line 1001: println(fnd_message.get);

997: retcode := 0;
998: errbuf := null;
999:
1000: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_STARTS');
1001: println(fnd_message.get);
1002:
1003: msc_phub_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1004: -- msc_demantra_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1005:

Line 1006: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');

1002:
1003: msc_phub_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1004: -- msc_demantra_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1005:
1006: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');
1007: println(fnd_message.get);
1008:
1009: end purge_demantra_details;
1010:

Line 1007: println(fnd_message.get);

1003: msc_phub_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1004: -- msc_demantra_pkg.purge_details(errbuf, retcode, p_scenario_id, p_plan_run_id);
1005:
1006: fnd_message.set_name('MSC', 'MSC_HUB_PURGE_ENDS');
1007: println(fnd_message.get);
1008:
1009: end purge_demantra_details;
1010:
1011: procedure populate_sno_details(errbuf out nocopy varchar2, retcode out nocopy varchar2,