DBA Data[Home] [Help]

APPS.MSC_SNO_PKG dependencies on MSC_PHUB_UTIL

Line 18: l_plan_type number := msc_phub_util.get_plan_type(p_plan_id);

14: l_user_login_id number := fnd_global.login_id;
15:
16: l_qid_vmi_item number := 0;
17: l_plan_constrained number := 0;
18: l_plan_type number := msc_phub_util.get_plan_type(p_plan_id);
19:
20: planned_order constant integer := 5;
21: purchase_order constant integer := 1;
22: purchase_req constant integer := 2;

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

883:
884: exception
885: when dup_val_on_index then
886: --dbms_output.put_line('wei: dup_val_on_index');
887: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
888: SQLCODE||' -ERROR- '||SQLERRM;
889: retcode := 2;
890:
891: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

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

894:
895:
896: when others then
897: --dbms_output.put_line('wei: others');
898: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
899: SQLCODE||' -ERROR- '||SQLERRM;
900: retcode := 2;
901:
902: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then