1064: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1065: ) -- APS+CP or CP
1066: ) THEN
1067: BEGIN
1068: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Launching SCEM engine');
1069: MSC_X_CP_FLOW.Start_SCEM_Engine_WF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_CP_FLOW.Start_SCEM_Engine_WF');
1068: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Launching SCEM engine');
1069: MSC_X_CP_FLOW.Start_SCEM_Engine_WF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_CP_FLOW.Start_SCEM_Engine_WF');
1073: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1074: END;
1075: END IF;
1076:
1069: MSC_X_CP_FLOW.Start_SCEM_Engine_WF;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_CP_FLOW.Start_SCEM_Engine_WF');
1073: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1074: END;
1075: END IF;
1076:
1077: IF (NVL(p_retcode, G_SUCCESS) > G_CONC_STATUS) THEN
1080:
1081: -- add exception handler
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in msc_sce_pub_supply_commit_pkg.publish_supply_commits');
1085: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1086: p_errbuf := sqlerrm;
1087: p_retcode := G_ERROR;
1088:
1081: -- add exception handler
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in msc_sce_pub_supply_commit_pkg.publish_supply_commits');
1085: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1086: p_errbuf := sqlerrm;
1087: p_retcode := G_ERROR;
1088:
1089: END publish_supply_commits;
1209: end loop;
1210:
1211: -- added exception handler
1212: EXCEPTION WHEN OTHERS THEN
1213: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in msc_sce_pub_supply_commit_pkg.get_optional_info');
1214: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1215: G_CONC_STATUS := G_WARNING;
1216:
1217: END get_optional_info;
1210:
1211: -- added exception handler
1212: EXCEPTION WHEN OTHERS THEN
1213: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in msc_sce_pub_supply_commit_pkg.get_optional_info');
1214: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1215: G_CONC_STATUS := G_WARNING;
1216:
1217: END get_optional_info;
1218: