DBA Data[Home] [Help]

APPS.MSC_SUPPLY_PKG dependencies on MSC_PHUB_UTIL

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

61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
65: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
66:
67:
68: l_stmt_id :=5;
69: select trunc(mp.curr_start_date),trunc(mp.curr_cutoff_date)

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

792: when no_data_found then
793:
794: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
795: retcode :=2;
796: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
797:
798: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
799: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
800: l_api_name,

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

804:
805: when dup_val_on_index then
806: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
807: retcode :=2;
808: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||SQLCODE||' -ERROR- '||SQLERRM;
809: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
811: l_api_name,
812: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);

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

814:
815: when others then
816: --dbms_output.put_line('exception '||SQLCODE||', '||SQLERRM);
817: retcode :=2;
818: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
819: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
820: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
821: l_api_name,
822: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);

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

1112: commit;
1113:
1114: exception
1115: when dup_val_on_index then
1116: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_DUPLICATE_DATA')||
1117: SQLCODE||' -ERROR- '||SQLERRM;
1118: retcode := 2;
1119: --dbms_output.put_line(errbuf);
1120: when others then

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

1117: SQLCODE||' -ERROR- '||SQLERRM;
1118: retcode := 2;
1119: --dbms_output.put_line(errbuf);
1120: when others then
1121: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_POPULATE_ERROR')||
1122: SQLCODE||' -ERROR- '||SQLERRM;
1123: retcode := 2;
1124: --dbms_output.put_line(errbuf);
1125:

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

1159: end loop;
1160: exception
1161: when others then
1162: retcode :=2;
1163: errbuf := msc_phub_util.get_planning_hub_message('MSC_HUB_PURGE_ERROR')||SQLCODE||' -ERROR- '||SQLERRM;
1164: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1165: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
1166: l_api_name,
1167: to_char(SQLCODE) || ':' || SQLERRM || ' in stmt_id=' || l_stmt_id);