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 275: fnd_message.set_name('MSC', 'MSC_PART_UNDEFINED_SCHEMA');

271:
272: if (fnd_installation.get_app_info('FND',
273: dummy1, dummy2, l_applsys_schema) = false) then
274: retcode := -1;
275: fnd_message.set_name('MSC', 'MSC_PART_UNDEFINED_SCHEMA');
276: errbuf := fnd_message.get;
277: raise e_manage_partitions;
278: end if;
279:

Line 276: errbuf := fnd_message.get;

272: if (fnd_installation.get_app_info('FND',
273: dummy1, dummy2, l_applsys_schema) = false) then
274: retcode := -1;
275: fnd_message.set_name('MSC', 'MSC_PART_UNDEFINED_SCHEMA');
276: errbuf := fnd_message.get;
277: raise e_manage_partitions;
278: end if;
279:
280: for i in 1..p_tables.count loop

Line 501: fnd_message.set_name('MSC', 'MSC_APCC_DBLINK_E01');

497:
498: exception
499: when others then
500: msc_phub_util.log('msc_phub_pkg.remote_context_sql.exception: '||sqlerrm);
501: fnd_message.set_name('MSC', 'MSC_APCC_DBLINK_E01');
502: fnd_message.set_token('DBLINK', p_dblink);
503: msc_phub_util.log(fnd_message.get);
504: raise;
505: end remote_context_sql;

Line 502: fnd_message.set_token('DBLINK', p_dblink);

498: exception
499: when others then
500: msc_phub_util.log('msc_phub_pkg.remote_context_sql.exception: '||sqlerrm);
501: fnd_message.set_name('MSC', 'MSC_APCC_DBLINK_E01');
502: fnd_message.set_token('DBLINK', p_dblink);
503: msc_phub_util.log(fnd_message.get);
504: raise;
505: end remote_context_sql;
506:

Line 503: msc_phub_util.log(fnd_message.get);

499: when others then
500: msc_phub_util.log('msc_phub_pkg.remote_context_sql.exception: '||sqlerrm);
501: fnd_message.set_name('MSC', 'MSC_APCC_DBLINK_E01');
502: fnd_message.set_token('DBLINK', p_dblink);
503: msc_phub_util.log(fnd_message.get);
504: raise;
505: end remote_context_sql;
506:
507: procedure publish_to_central_apcc(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 567: fnd_message.set_name('MSC', 'MSC_APCC_REMOTE_CONFIRM');

563: to_char(l_pi.plan_start_date), to_char(l_pi.plan_cutoff_date);
564:
565: commit;
566:
567: fnd_message.set_name('MSC', 'MSC_APCC_REMOTE_CONFIRM');
568: fnd_message.set_token('DBLINK', p_dblink);
569: fnd_message.set_token('REQ_ID', l_request_id);
570: msc_phub_util.log(fnd_message.get);
571:

Line 568: fnd_message.set_token('DBLINK', p_dblink);

564:
565: commit;
566:
567: fnd_message.set_name('MSC', 'MSC_APCC_REMOTE_CONFIRM');
568: fnd_message.set_token('DBLINK', p_dblink);
569: fnd_message.set_token('REQ_ID', l_request_id);
570: msc_phub_util.log(fnd_message.get);
571:
572: exception

Line 569: fnd_message.set_token('REQ_ID', l_request_id);

565: commit;
566:
567: fnd_message.set_name('MSC', 'MSC_APCC_REMOTE_CONFIRM');
568: fnd_message.set_token('DBLINK', p_dblink);
569: fnd_message.set_token('REQ_ID', l_request_id);
570: msc_phub_util.log(fnd_message.get);
571:
572: exception
573: when others then

Line 570: msc_phub_util.log(fnd_message.get);

566:
567: fnd_message.set_name('MSC', 'MSC_APCC_REMOTE_CONFIRM');
568: fnd_message.set_token('DBLINK', p_dblink);
569: fnd_message.set_token('REQ_ID', l_request_id);
570: msc_phub_util.log(fnd_message.get);
571:
572: exception
573: when others then
574: if (retcode = 0) then

Line 637: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_STARTS'));

633: msc_phub_util.init_log;
634: retcode := 0;
635: errbuf := null;
636:
637: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_STARTS'));
638: execute immediate 'alter session set ddl_lock_timeout=18000';
639:
640: msc_phub_util.log('msc_phub_pkg.populate_details_fn('||
641: p_plan_id||','||

Line 654: errbuf := fnd_message.get_string('MSC', 'MSC_APCC_INVALID_PROFILE');

650:
651: -- check_apcc_setup
652: if (check_apcc_setup = 2) then
653: retcode := -1;
654: errbuf := fnd_message.get_string('MSC', 'MSC_APCC_INVALID_PROFILE');
655: msc_phub_util.log(errbuf);
656: raise e_populate_details;
657: end if;
658:

Line 703: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E01');

699: and archive_flag=1
700: and local_archive_flag=2;
701:
702: if (l_n > 0) then
703: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E01');
704: retcode := -1;
705: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;
706: msc_phub_util.log(errbuf);
707: raise e_populate_details;

Line 705: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;

701:
702: if (l_n > 0) then
703: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E01');
704: retcode := -1;
705: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;
706: msc_phub_util.log(errbuf);
707: raise e_populate_details;
708: end if;
709:

Line 718: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E03');

714: and archive_flag=1
715: and plan_type<>l_pi.plan_type
716: and rownum=1;
717:
718: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E03');
719: fnd_message.set_token('PLAN', l_pi.plan_name);
720: fnd_message.set_token('PLAN_TYPE', get_plan_type_meaning(l_plan_type));
721: retcode := -1;
722: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;

Line 719: fnd_message.set_token('PLAN', l_pi.plan_name);

715: and plan_type<>l_pi.plan_type
716: and rownum=1;
717:
718: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E03');
719: fnd_message.set_token('PLAN', l_pi.plan_name);
720: fnd_message.set_token('PLAN_TYPE', get_plan_type_meaning(l_plan_type));
721: retcode := -1;
722: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;
723: msc_phub_util.log(errbuf);

Line 720: fnd_message.set_token('PLAN_TYPE', get_plan_type_meaning(l_plan_type));

716: and rownum=1;
717:
718: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E03');
719: fnd_message.set_token('PLAN', l_pi.plan_name);
720: fnd_message.set_token('PLAN_TYPE', get_plan_type_meaning(l_plan_type));
721: retcode := -1;
722: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;
723: msc_phub_util.log(errbuf);
724: raise e_populate_details;

Line 722: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;

718: fnd_message.set_name('MSC', 'MSC_APCC_PLAN_INFO_E03');
719: fnd_message.set_token('PLAN', l_pi.plan_name);
720: fnd_message.set_token('PLAN_TYPE', get_plan_type_meaning(l_plan_type));
721: retcode := -1;
722: errbuf := 'msc_phub_pkg.populate_details_fn: '||fnd_message.get;
723: msc_phub_util.log(errbuf);
724: raise e_populate_details;
725: exception
726: when others then

Line 793: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_ENDS'));

789: end if;
790:
791: end if;
792:
793: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_ENDS'));
794: return l_plan_run_id;
795:
796: exception
797: when others then

Line 916: msc_phub_util.log(fnd_message.get_string('MSC', 'MSC_APCC_INVALID_PROFILE'));

912: end if;
913:
914: -- check_apcc_setup
915: if (check_apcc_setup = 2) then
916: msc_phub_util.log(fnd_message.get_string('MSC', 'MSC_APCC_INVALID_PROFILE'));
917: return;
918: end if;
919:
920: check_migrate(errbuf, retcode);

Line 1330: fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED') planner_code,

1326: null max_minmax_quantity,
1327: null min_minmax_quantity,
1328: null minimum_order_quantity,
1329: null mrp_planning_code,
1330: fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED') planner_code,
1331: null planning_make_buy_code,
1332: null postprocessing_lead_time,
1333: null preprocessing_lead_time,
1334: null purchasing_enabled_flag,

Line 1419: fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED') planner_code,

1415: null max_minmax_quantity,
1416: null min_minmax_quantity,
1417: null minimum_order_quantity,
1418: null mrp_planning_code,
1419: fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED') planner_code,
1420: null planning_make_buy_code,
1421: null postprocessing_lead_time,
1422: null preprocessing_lead_time,
1423: null purchasing_enabled_flag,

Line 1526: nvl(i.planner_code, fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED')) planner_code,

1522: i.minimum_order_quantity,
1523: i.mrp_planning_code,
1524: /* bug 9919442 - if no planner code set to 'Unassigned' */
1525: /* i.planner_code, */
1526: nvl(i.planner_code, fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED')) planner_code,
1527: i.planning_make_buy_code,
1528: i.postprocessing_lead_time,
1529: i.preprocessing_lead_time,
1530: i.purchasing_enabled_flag,

Line 1773: nvl(d.planner_code, fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED')) planner_code,

1769: d.minimum_order_quantity,
1770: d.mrp_planning_code,
1771: /* bug 9919442 - if no planner code set to 'Unassigned' */
1772: /* d.planner_code, */
1773: nvl(d.planner_code, fnd_message.get_string('MSC','MSC_HUB_UNASSIGNED')) planner_code,
1774: d.planning_make_buy_code,
1775: d.postprocessing_lead_time,
1776: d.preprocessing_lead_time,
1777: d.purchasing_enabled_flag,

Line 1831: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_STARTS'));

1827: --set the conc program ret values to success
1828: retcode := 0;
1829: errbuf := null;
1830:
1831: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_STARTS'));
1832:
1833: msc_phub_util.log('msc_phub_pkg.populate_ods_details('||
1834: p_sr_instance_id||','||p_refresh_mode||')');
1835:

Line 2008: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_ENDS'));

2004: commit;
2005: end if;
2006: finalize_plan_run(-1, l_plan_run_id, sys_no, sys_yes, l_return_status, sys_yes);
2007:
2008: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_POPULATE_ENDS'));
2009: end populate_ods_details;
2010:
2011: procedure clean_up_customer_keys
2012: is