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_WS_SRP dependencies on MSC_WS_COMMON

Line 49: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);

45: BEGIN
46: error_tracking_num := 1010;
47:
48: -- validate and initialize apps
49: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
50:
51: IF(l_val_result <> 'OK') THEN
52: processid := -1;
53: status := l_val_result;

Line 135: AND lookup_code = decode(launchplanner, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);

131: FROM MFG_LOOKUPS
132: WHERE lookup_type = 'SYS_YES_NO'
133: AND ((lookup_code = 1 AND l_val_launchsnapshot in (1,3,4)) OR
134: (l_val_launchsnapshot = 2))
135: AND lookup_code = decode(launchplanner, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);
136:
137: EXCEPTION
138: WHEN no_data_found THEN
139: processid := -1;

Line 147: SELECT decode(archiveCurrVersPlan, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no)

143:
144: error_tracking_num := 1055;
145:
146: BEGIN
147: SELECT decode(archiveCurrVersPlan, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no)
148: INTO l_val_archivePlan
149: FROM dual;
150:
151: END;

Line 197: AND lookup_code = decode(releasereschedules,'Y',msc_ws_common.sys_yes, msc_ws_common.sys_no);

193: INTO l_val_releasereschedules
194: FROM MFG_LOOKUPS
195: WHERE lookup_type='SYS_YES_NO'
196: AND (NVL(l_val_production,2)=1 or lookup_code=2)
197: AND lookup_code = decode(releasereschedules,'Y',msc_ws_common.sys_yes, msc_ws_common.sys_no);
198: EXCEPTION
199: WHEN no_data_found THEN
200: processid := -1;
201: status := 'INVALID_RELEASE_RESCHEDULES';

Line 212: AND lookup_code = decode(generateForecast, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);

208: FROM MFG_LOOKUPS
209: where lookup_type = 'SYS_YES_NO'
210: AND ( (l_val_launchplanner = 1 and lookup_code in (1,2) ) OR
211: (l_val_launchplanner = 2 and lookup_code in (1) ) )
212: AND lookup_code = decode(generateForecast, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);
213:
214: EXCEPTION WHEN no_data_found THEN
215: processid := -1;
216: status := 'INVALID_GENERATE_FORECAST';

Line 222: SELECT to_number(decode(snapstaticentities, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))

218: END;
219: error_tracking_num := 1080;
220: -- snapstaticentities, netchange, can be either Y or N, converted to 1 or 2
221: BEGIN
222: SELECT to_number(decode(snapstaticentities, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
223: INTO l_val_snapstaticentities
224: FROM dual;
225:
226: SELECT to_number(decode(netchange, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))

Line 226: SELECT to_number(decode(netchange, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))

222: SELECT to_number(decode(snapstaticentities, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
223: INTO l_val_snapstaticentities
224: FROM dual;
225:
226: SELECT to_number(decode(netchange, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no))
227: INTO l_val_netchange
228: FROM dual;
229: END;
230:

Line 296: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

292: error_tracking_num number;
293: l_SecutirtGroupId NUMBER;
294: BEGIN
295: error_tracking_num :=2010;
296: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
297: IF (l_String <> 'OK') THEN
298: Status := l_String;
299: RETURN;
300: END IF;

Line 304: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP',l_SecutirtGroupId);

300: END IF;
301:
302: error_tracking_num :=2030;
303:
304: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP',l_SecutirtGroupId);
305: IF (l_String <> 'OK') THEN
306: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRP', l_SecutirtGroupId);
307: IF (l_String <> 'OK') THEN
308: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRP',l_SecutirtGroupId);

Line 306: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRP', l_SecutirtGroupId);

302: error_tracking_num :=2030;
303:
304: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP',l_SecutirtGroupId);
305: IF (l_String <> 'OK') THEN
306: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRP', l_SecutirtGroupId);
307: IF (l_String <> 'OK') THEN
308: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRP',l_SecutirtGroupId);
309: IF (l_String <> 'OK') THEN
310: Status := l_String;

Line 308: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRP',l_SecutirtGroupId);

304: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP',l_SecutirtGroupId);
305: IF (l_String <> 'OK') THEN
306: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRP', l_SecutirtGroupId);
307: IF (l_String <> 'OK') THEN
308: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRP',l_SecutirtGroupId);
309: IF (l_String <> 'OK') THEN
310: Status := l_String;
311: RETURN;
312: END IF;

Line 357: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);

353:
354: BEGIN
355: req_id := REQTBLTYP();
356: error_tracking_num :=2010;
357: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
358:
359: IF(l_val_result <> 'OK') THEN
360: status := l_val_result;
361: RETURN;

Line 448: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

444: l_SecutirtGroupId NUMBER;
445: BEGIN
446: req_id := REQTBLTYP();
447: error_tracking_num :=2010;
448: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
449: IF (l_String <> 'OK') THEN
450: Status := l_String;
451: RETURN;
452: END IF;

Line 455: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP', l_SecutirtGroupId);

451: RETURN;
452: END IF;
453:
454: error_tracking_num :=2030;
455: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRP', l_SecutirtGroupId);
456: IF (l_String <> 'OK') THEN
457: Status := l_String;
458: RETURN;
459: END IF;

Line 482: -- 00201 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID

478: --
479: -- Un-handled exceptions generate error tokens in the
480: -- format of ERROR_UNEXPECTED_#####.
481: -- The possible values are:
482: -- 00201 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
483: -- 00202 - SET_SRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
484: -- 00203 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
485: -- 00204 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_DMD_SCH_ID
486: -- 00205 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)

Line 484: -- 00203 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID

480: -- format of ERROR_UNEXPECTED_#####.
481: -- The possible values are:
482: -- 00201 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
483: -- 00202 - SET_SRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
484: -- 00203 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
485: -- 00204 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_DMD_SCH_ID
486: -- 00205 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)
487: -- 00206 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_RET_FCST_ID
488: -- 00207 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG

Line 488: -- 00207 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG

484: -- 00203 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
485: -- 00204 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_DMD_SCH_ID
486: -- 00205 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)
487: -- 00206 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_RET_FCST_ID
488: -- 00207 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
489: -- 00208 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
490: -- 00209 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_SUP_SCHS/VALIDATE_L_SUP_SCH_ID
491: -- 00210 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
492: -- 00211 - SET_SRP_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS

Line 491: -- 00210 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES

487: -- 00206 - SET_SRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_RET_FCST_ID
488: -- 00207 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
489: -- 00208 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
490: -- 00209 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_SUP_SCHS/VALIDATE_L_SUP_SCH_ID
491: -- 00210 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
492: -- 00211 - SET_SRP_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS
493: -- 00212 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
494: -- 00213 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_G_MAN_FCST
495: -- 00214 - SET_SRP_PLAN_OPTIONS/INSERT_OR_UPDATE_ALL_SCHS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS

Line 493: -- 00212 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/MSC_WS_COMMON.INSERT_ALL_SCHEDULES

489: -- 00208 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
490: -- 00209 - SET_SRP_PLAN_OPTIONS/VALIDATE_LOC_SUP_SCHS/VALIDATE_L_SUP_SCH_ID
491: -- 00210 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
492: -- 00211 - SET_SRP_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS
493: -- 00212 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
494: -- 00213 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_G_MAN_FCST
495: -- 00214 - SET_SRP_PLAN_OPTIONS/INSERT_OR_UPDATE_ALL_SCHS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
496: -- =============================================================
497:

Line 495: -- 00214 - SET_SRP_PLAN_OPTIONS/INSERT_OR_UPDATE_ALL_SCHS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS

491: -- 00210 - SET_SRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
492: -- 00211 - SET_SRP_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS
493: -- 00212 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
494: -- 00213 - SET_SRP_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_G_MAN_FCST
495: -- 00214 - SET_SRP_PLAN_OPTIONS/INSERT_OR_UPDATE_ALL_SCHS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
496: -- =============================================================
497:
498:
499: -- =============================================================

Line 603: l_String := MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID(SchTable(I).DmdSchId, PlanName);

599: FOR I IN SchTable.first..SchTable.last
600: LOOP
601: -- validate demand schedule id
602: BEGIN
603: l_String := MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID(SchTable(I).DmdSchId, PlanName);
604: IF (l_String <> 'OK') THEN
605: RETURN l_String;
606: END IF;
607: EXCEPTION WHEN others THEN

Line 614: l_String := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(

610: END;
611:
612: -- validate ship to consumption level
613: BEGIN
614: l_String := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(
615: SchTable(I).ShipToConsumptionLvl,
616: SchTable(I).DmdSchId);
617: IF (l_String <> 'OK') THEN
618: RETURN 'INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL';

Line 849: l_ReturnString := MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG(l_OrgInsId, SchTable(I).OrgId, PlanId);

845: FOR I IN SchTable.first..SchTable.last
846: LOOP
847: -- validate organization id
848: BEGIN
849: l_ReturnString := MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG(l_OrgInsId, SchTable(I).OrgId, PlanId);
850: IF (l_ReturnString <> 'OK') THEN
851: -- overwrite the error token here.
852: l_ReturnString := 'INVALID_LOCALDMDSCHS_ORGID';
853: RETURN l_ReturnString;

Line 880: l_ReturnString := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(

876: IF l_DesigType = 7 THEN
877: IF SchTable(I).ShipToConsumptionLvl IS NULL THEN
878: RETURN 'INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL';
879: END IF;
880: l_ReturnString := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(
881: SchTable(I).ShipToConsumptionLvl,
882: SchTable(I).DmdSchId);
883: IF (l_ReturnString <> 'OK') THEN
884: RETURN 'INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL';

Line 1020: l_ReturnString:= MSC_WS_COMMON.INSERT_ALL_SCHEDULES(

1016: BEGIN
1017: -- insert all global demand schedules, local
1018: -- demand schedules and local supply schedules
1019: BEGIN
1020: l_ReturnString:= MSC_WS_COMMON.INSERT_ALL_SCHEDULES(
1021: PlanId, InsId, UserId,
1022: g_IGlbDmdSchTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);
1023: IF (l_ReturnString <> 'OK') THEN
1024: RETURN l_ReturnString;

Line 1077: l_ReturnString := MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS(

1073: BEGIN
1074: -- insert/update all global demand schedules, local
1075: -- demand schedules and local supply schedules
1076: BEGIN
1077: l_ReturnString := MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS(
1078: PlanId, InsId, UserId,
1079: g_IGlbDmdSchTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);
1080: IF (l_ReturnString <> 'OK') THEN
1081: RETURN l_ReturnString;

Line 1217: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);

1213: g_ILocSupSchTbl := MscILocSupSchTbl();
1214:
1215:
1216: -- check user id and responsibility
1217: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
1218: IF (l_String <> 'OK') THEN
1219: Status := l_String;
1220: RETURN;
1221: END IF;

Line 1224: -- l_String := MSC_WS_COMMON.VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);

1220: RETURN;
1221: END IF;
1222:
1223: -- check plan id
1224: -- l_String := MSC_WS_COMMON.VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
1225: l_String := VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
1226: IF (l_String <> 'OK') THEN
1227: Status := l_String;
1228: RETURN;

Line 1240: l_String := MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID(ItemSimulationSetId);

1236: END IF;
1237:
1238: -- validate item simulation set id
1239: BEGIN
1240: l_String := MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID(ItemSimulationSetId);
1241: IF (l_String <> 'OK') THEN
1242: Status := l_String;
1243: RETURN;
1244: END IF;

Line 1250: l_OverwriteSup := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteSup);

1246: g_ErrorCode := 'ERROR_UNEXPECTED_00203';
1247: raise;
1248: END;
1249:
1250: l_OverwriteSup := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteSup);
1251: l_OverwriteManualFcst := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteManualFcst);
1252:
1253: -- validate global demand schedules
1254: l_String := VALIDATE_GLB_DMD_SCHS(GlobalDmdSchs, l_PlanName);

Line 1251: l_OverwriteManualFcst := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteManualFcst);

1247: raise;
1248: END;
1249:
1250: l_OverwriteSup := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteSup);
1251: l_OverwriteManualFcst := MSC_WS_COMMON.CONVERT_OVERWRITE(OverwriteManualFcst);
1252:
1253: -- validate global demand schedules
1254: l_String := VALIDATE_GLB_DMD_SCHS(GlobalDmdSchs, l_PlanName);
1255: IF (l_String <> 'OK') THEN

Line 1276: l_String := MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS(g_ILocSupSchTbl, LocalSupSchs, PlanId, l_PlanName);

1272: END IF;
1273:
1274: -- validate local supply schedules
1275: BEGIN
1276: l_String := MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS(g_ILocSupSchTbl, LocalSupSchs, PlanId, l_PlanName);
1277: IF (l_String <> 'OK') THEN
1278: Status := l_String;
1279: RETURN;
1280: END IF;

Line 1288: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN

1284: END;
1285:
1286: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
1287: -- local demand schedule and local supply schedules
1288: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1289: BEGIN
1290: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
1291: EXCEPTION WHEN others THEN
1292: g_ErrorCode := 'ERROR_UNEXPECTED_00210';

Line 1290: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);

1286: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
1287: -- local demand schedule and local supply schedules
1288: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1289: BEGIN
1290: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
1291: EXCEPTION WHEN others THEN
1292: g_ErrorCode := 'ERROR_UNEXPECTED_00210';
1293: raise;
1294: END;

Line 1305: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN

1301: RETURN;
1302: END IF;
1303:
1304: -- set all global/local demand/supply schedules
1305: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1306: l_String := INSERT_ALL_SCHEDULES(
1307: PlanId, l_InsId, UserId,
1308: g_IGlbDmdSchTbl, g_IGlbRetFcstTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);
1309: ELSE

Line 1355: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);

1351: error_tracking_num number;
1352: l_SecutirtGroupId NUMBER;
1353: BEGIN
1354: error_tracking_num :=2010;
1355: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1356: IF (l_String <> 'OK') THEN
1357: Status := l_String;
1358: RETURN;
1359: END IF;

Line 1362: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPPMR-SRP',l_SecutirtGroupId);

1358: RETURN;
1359: END IF;
1360:
1361: error_tracking_num :=2030;
1362: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPPMR-SRP',l_SecutirtGroupId);
1363: IF (l_String <> 'OK') THEN
1364: Status := l_String;
1365: RETURN;
1366: END IF;