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_SUPPLIER_PKG dependencies on MSC_PHUB_UTIL

Line 85: l_plan_constrained := msc_phub_util.is_plan_constrained(p_plan_id);

81: errbuf := null;
82:
83:
84: --select CURR_PLAN_TYPE into g_plan_type from msc_plans where plan_id = p_plan_id;
85: l_plan_constrained := msc_phub_util.is_plan_constrained(p_plan_id);
86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:
89: l_stmt_id:=10;

Line 86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);

82:
83:
84: --select CURR_PLAN_TYPE into g_plan_type from msc_plans where plan_id = p_plan_id;
85: l_plan_constrained := msc_phub_util.is_plan_constrained(p_plan_id);
86: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
87: --dbms_output.put_line('populate_details '||p_plan_id||', '||p_plan_run_id||', '||l_plan_type);
88:
89: l_stmt_id:=10;
90: select msc_hub_query_s.nextval into l_qid_req from dual;

Line 660: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;

656:
657: exception
658: when dup_val_on_index then
659: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
660: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
661: retcode := 2;
662: when others then
663: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
664: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

Line 664: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

660: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
661: retcode := 2;
662: when others then
663: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
664: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
665: retcode := 2;
666: end populate_details;
667:
668: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,

Line 825: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||

821: commit;
822:
823: exception
824: when dup_val_on_index then
825: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
826: SQLCODE||' -ERROR- '||SQLERRM;
827: retcode := 2;
828: --dbms_output.put_line(errbuf);
829: when others then

Line 830: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||

826: SQLCODE||' -ERROR- '||SQLERRM;
827: retcode := 2;
828: --dbms_output.put_line(errbuf);
829: when others then
830: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
831: SQLCODE||' -ERROR- '||SQLERRM;
832: retcode := 2;
833: --dbms_output.put_line(errbuf);
834:

Line 851: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;

847:
848: commit;
849: exception
850: when others then
851: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
852: retcode := 2;
853: end purge_details;
854: end msc_supplier_pkg;