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

Line 45: MSC_WS_COMMON.VALIDATE_USER_RESP(l_val_result, userId, responsibilityId);

41: BEGIN
42: error_tracking_num := 1010;
43:
44: -- validate and initialize apps
45: MSC_WS_COMMON.VALIDATE_USER_RESP(l_val_result, userId, responsibilityId);
46:
47: IF (l_val_result <> 'OK') THEN
48: processId := -1;
49: status := l_val_result;

Line 105: 'Y' ,MSC_WS_COMMON.SYS_YES, MSC_WS_COMMON.SYS_NO)

101: error_tracking_num := 1040;
102: -- expected values are Y and N , if it is Y then converted to SYS_YES ,others to SYS_NO
103: BEGIN
104: SELECT DECODE(launchSnapshot,
105: 'Y' ,MSC_WS_COMMON.SYS_YES, MSC_WS_COMMON.SYS_NO)
106: INTO l_val_launchSnapshot
107: FROM DUAL;
108:
109: END;

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

117: FROM MFG_LOOKUPS
118: WHERE lookup_type = 'SYS_YES_NO'
119: AND ((lookup_code = 1 AND l_val_launchSnapshot = 1) OR
120: (l_val_launchSnapshot = 2))
121: AND lookup_code = decode(launchPlanner, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no);
122: EXCEPTION
123: WHEN no_data_found THEN
124: processid := -1;
125: status := 'INVALID_LAUNCH_PLANNER';

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

128:
129: error_tracking_num := 1055;
130:
131: BEGIN
132: SELECT decode(archiveCurrVersPlan, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no)
133: INTO l_val_archivePlan
134: FROM dual;
135:
136: END;

Line 138: l_val_netchange := msc_ws_common.sys_no;

134: FROM dual;
135:
136: END;
137: -- netchange hidden parameter always set to the value 2, which is sys_no
138: l_val_netchange := msc_ws_common.sys_no;
139:
140:
141:
142: -- populating PLAN_TYPE_DUMMY hidden parameter

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

180: INTO l_val_releaseReschedules
181: FROM MFG_LOOKUPS
182: WHERE lookup_type='SYS_YES_NO'
183: AND (NVL(l_val_production,2)=1 or lookup_code=2)
184: AND lookup_code = decode(releaseReschedules,'Y',msc_ws_common.sys_yes, msc_ws_common.sys_no);
185: EXCEPTION
186: WHEN no_data_found THEN
187: processid := -1;
188: status := 'INVALID_RELEASE_RESCHEDULES';

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

247: error_tracking_num number;
248: l_SecutirtGroupId NUMBER;
249: BEGIN
250: error_tracking_num :=2010;
251: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
252: IF (l_String <> 'OK') THEN
253: Status := l_String;
254: RETURN;
255: END IF;

Line 259: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);

255: END IF;
256:
257:
258: error_tracking_num :=2030;
259: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);
260: IF (l_String <> 'OK') THEN
261: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCDP', l_SecutirtGroupId);
262: IF (l_String <> 'OK') THEN
263: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_DRP',l_SecutirtGroupId);

Line 261: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCDP', l_SecutirtGroupId);

257:
258: error_tracking_num :=2030;
259: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);
260: IF (l_String <> 'OK') THEN
261: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCDP', l_SecutirtGroupId);
262: IF (l_String <> 'OK') THEN
263: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_DRP',l_SecutirtGroupId);
264: IF (l_String <> 'OK') THEN
265: Status := l_String;

Line 263: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_DRP',l_SecutirtGroupId);

259: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);
260: IF (l_String <> 'OK') THEN
261: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCDP', l_SecutirtGroupId);
262: IF (l_String <> 'OK') THEN
263: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_DRP',l_SecutirtGroupId);
264: IF (l_String <> 'OK') THEN
265: Status := l_String;
266: RETURN;
267: END IF;

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

306:
307: BEGIN
308: req_id := REQTBLTYP();
309: error_tracking_num :=2010;
310: msc_ws_common.validate_user_resp(l_val_result, userid, responsibilityid);
311:
312: IF(l_val_result <> 'OK') THEN
313: status := l_val_result;
314: RETURN;

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

395: l_SecutirtGroupId NUMBER;
396: BEGIN
397: req_id := REQTBLTYP();
398: error_tracking_num :=2010;
399: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
400: IF (l_String <> 'OK') THEN
401: Status := l_String;
402: RETURN;
403: END IF;

Line 407: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);

403: END IF;
404:
405: error_tracking_num :=2030;
406:
407: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNDRP',l_SecutirtGroupId);
408: IF (l_String <> 'OK') THEN
409: Status := l_String;
410: RETURN;
411: END IF;

Line 433: -- 00101 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID

429: --
430: -- Un-handled exceptions generate error tokens in the
431: -- format of ERROR_UNEXPECTED_#####.
432: -- The possible values are:
433: -- 00101 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
434: -- 00102 - SET_DRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)

Line 435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID

431: -- format of ERROR_UNEXPECTED_#####.
432: -- The possible values are:
433: -- 00101 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
434: -- 00102 - SET_DRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG

Line 436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID

432: -- The possible values are:
433: -- 00101 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
434: -- 00102 - SET_DRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS

Line 437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)

433: -- 00101 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_PLAN_ID
434: -- 00102 - SET_DRP_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES

Line 439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG

435: -- 00103 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES

Line 440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS

436: -- 00104 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID
437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS

Line 441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES

437: -- 00105 - SET_DRP_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/MSC_WS_COMMON.VALIDATE_CONSUM_LVL (goe / item)
438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
445: -- =============================================================

Line 442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS

438: -- 00106 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
445: -- =============================================================
446:

Line 443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES

439: -- 00107 - SET_DRP_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
445: -- =============================================================
446:
447: -- =============================================================

Line 444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS

440: -- 00108 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS
441: -- 00109 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
442: -- 00110 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.UPDATE_PLAN_OPTIONS
443: -- 00111 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_ALL_SCHEDULES
444: -- 00112 - SET_DRP_PLAN_OPTIONS/MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS
445: -- =============================================================
446:
447: -- =============================================================
448: -- Desc: Validate plan id, copy the where clause from LAUNCH_DRP_BATCH

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

547: FOR I IN SchTable.first..SchTable.last
548: LOOP
549: -- validate demand schedule id
550: BEGIN
551: l_String := MSC_WS_COMMON.VALIDATE_G_DMD_SCH_ID(SchTable(I).DmdSchId, PlanName);
552: IF (l_String <> 'OK') THEN
553: RETURN l_String;
554: END IF;
555: EXCEPTION WHEN others THEN

Line 562: l_String := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(

558: END;
559:
560: -- validate ship to consumption level
561: BEGIN
562: l_String := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(
563: SchTable(I).ShipToConsumptionLvl,
564: SchTable(I).DmdSchId);
565: IF (l_String <> 'OK') THEN
566: RETURN 'INVALID_GLOBALDMDSCHS_SHP_TO_CONSUMPTION_LVL';

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

715: FOR I IN SchTable.first..SchTable.last
716: LOOP
717: -- validate organization id
718: BEGIN
719: l_ReturnString := MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG(l_OrgInsId, SchTable(I).OrgId, PlanId);
720: IF (l_ReturnString <> 'OK') THEN
721: -- overwrite the error token here.
722: l_ReturnString := 'INVALID_LOCALDMDSCHS_ORGID';
723: RETURN l_ReturnString;

Line 751: l_ReturnString := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(

747: IF SchTable(I).ShipToConsumptionLvl IS NULL THEN
748: RETURN 'INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL';
749: END IF;
750: l_ShipTo := SchTable(I).ShipToConsumptionLvl;
751: l_ReturnString := MSC_WS_COMMON.VALIDATE_CONSUM_LVL(
752: SchTable(I).ShipToConsumptionLvl,
753: SchTable(I).DmdSchId);
754: IF (l_ReturnString <> 'OK') THEN
755: RETURN 'INVALID_LOCALDMDSCHS_SHP_TO_CONSUMPTION_LVL';

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

865: g_ILocDmdSchTbl := MscILocDmdSchTbl();
866: g_ILocSupSchTbl := MscILocSupSchTbl();
867:
868: -- check user id and responsibility
869: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
870: IF (l_String <> 'OK') THEN
871: Status := l_String;
872: RETURN;
873: END IF;

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

872: RETURN;
873: END IF;
874:
875: -- check plan id
876: -- l_String := MSC_WS_COMMON.VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
877: l_String := VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
878: IF (l_String <> 'OK') THEN
879: Status := l_String;
880: RETURN;

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

888: END IF;
889:
890: -- validate item simulation set id
891: BEGIN
892: l_String := MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID(ItemSimulationSetId);
893: IF (l_String <> 'OK') THEN
894: Status := l_String;
895: RETURN;
896: END IF;

Line 902: l_Overwrite := MSC_WS_COMMON.CONVERT_OVERWRITE(Overwrite);

898: g_ErrorCode := 'ERROR_UNEXPECTED_00103';
899: raise;
900: END;
901:
902: l_Overwrite := MSC_WS_COMMON.CONVERT_OVERWRITE(Overwrite);
903:
904:
905: -- validate global demand schedules
906: l_String := VALIDATE_GLB_DMD_SCHS(GlobalDmdSchs, l_PlanName);

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

917: END IF;
918:
919: -- validate local supply schedules
920: BEGIN
921: l_String := MSC_WS_COMMON.VALIDATE_LOC_SUP_SCHS(g_ILocSupSchTbl, LocalSupSchs, PlanId, l_PlanName);
922: IF (l_String <> 'OK') THEN
923: Status := l_String;
924: RETURN;
925: END IF;

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

929: END;
930:
931: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
932: -- local demand schedule and local supply schedules
933: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
934: BEGIN
935: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
936: EXCEPTION WHEN others THEN
937: g_ErrorCode := 'ERROR_UNEXPECTED_00109';

Line 935: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);

931: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
932: -- local demand schedule and local supply schedules
933: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
934: BEGIN
935: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
936: EXCEPTION WHEN others THEN
937: g_ErrorCode := 'ERROR_UNEXPECTED_00109';
938: raise;
939: END;

Line 944: MSC_WS_COMMON.UPDATE_PLAN_OPTIONS(PlanId, ItemSimulationSetId, l_Overwrite);

940: END IF;
941:
942: -- update item simulation set and overwrite
943: BEGIN
944: MSC_WS_COMMON.UPDATE_PLAN_OPTIONS(PlanId, ItemSimulationSetId, l_Overwrite);
945: EXCEPTION WHEN others THEN
946: g_ErrorCode := 'ERROR_UNEXPECTED_00110';
947: raise;
948: END;

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

947: raise;
948: END;
949:
950: -- set all global/local demand/supply schedules
951: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
952: BEGIN
953: l_String := MSC_WS_COMMON.INSERT_ALL_SCHEDULES(
954: PlanId, l_InsId, UserId,
955: g_IGlbDmdSchTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);

Line 953: l_String := MSC_WS_COMMON.INSERT_ALL_SCHEDULES(

949:
950: -- set all global/local demand/supply schedules
951: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
952: BEGIN
953: l_String := MSC_WS_COMMON.INSERT_ALL_SCHEDULES(
954: PlanId, l_InsId, UserId,
955: g_IGlbDmdSchTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);
956: EXCEPTION WHEN others THEN
957: g_ErrorCode := 'ERROR_UNEXPECTED_00111';

Line 962: l_String := MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS(

958: raise;
959: END;
960: ELSE
961: BEGIN
962: l_String := MSC_WS_COMMON.INSERT_OR_UPDATE_ALL_SCHS(
963: PlanId, l_InsId, UserId,
964: g_IGlbDmdSchTbl, g_ILocDmdSchTbl, g_ILocSupSchTbl);
965: EXCEPTION WHEN others THEN
966: g_ErrorCode := 'ERROR_UNEXPECTED_00112';

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

1006: error_tracking_num number;
1007: l_SecutirtGroupId NUMBER;
1008: BEGIN
1009: error_tracking_num :=2010;
1010: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1011: IF (l_String <> 'OK') THEN
1012: Status := l_String;
1013: RETURN;
1014: END IF;

Line 1017: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPDRP',l_SecutirtGroupId);

1013: RETURN;
1014: END IF;
1015:
1016: error_tracking_num :=2030;
1017: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPDRP',l_SecutirtGroupId);
1018: -- MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MRPFPPMRSDRP',l_SecutirtGroupId);
1019: IF (l_String <> 'OK') THEN
1020: Status := l_String;
1021: RETURN;

Line 1018: -- MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MRPFPPMRSDRP',l_SecutirtGroupId);

1014: END IF;
1015:
1016: error_tracking_num :=2030;
1017: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPDRP',l_SecutirtGroupId);
1018: -- MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MRPFPPMRSDRP',l_SecutirtGroupId);
1019: IF (l_String <> 'OK') THEN
1020: Status := l_String;
1021: RETURN;
1022: END IF;