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

Line 38: MSC_WS_COMMON.VALIDATE_USER_RESP(l_result, userId, responsibilityId);

34:
35: -- ------------------------------------
36: -- validate and initialize apps
37: -- ------------------------------------
38: MSC_WS_COMMON.VALIDATE_USER_RESP(l_result, userId, responsibilityId);
39:
40: IF (l_result <> 'OK') THEN
41: processId := -1;
42: status := l_result;

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

96:
97: l_error_tracking_num:= 3035;
98:
99: BEGIN
100: SELECT decode(archiveCurrVersPlan, 'Y', msc_ws_common.sys_yes, msc_ws_common.sys_no)
101: INTO l_val_archivePlan
102: FROM dual;
103:
104: END;

Line 159: to_char(msc_ws_common.sys_yes), -- launch snapshot, argument 3, set to Yes always

155: NULL, -- start_time
156: FALSE, -- sub_request
157: l_plan_name, -- plan name, argument 1
158: planId, -- plan name hidden, argument 2
159: to_char(msc_ws_common.sys_yes), -- launch snapshot, argument 3, set to Yes always
160: to_char(msc_ws_common.sys_yes), -- launch planner, argument 4, set to Yes always
161: to_char(msc_ws_common.sys_no), -- netchange, argument 5, set to No always
162: fnd_date.date_to_chardate(anchorDate), -- anchor date, argument 6
163: l_val_archivePlan,

Line 160: to_char(msc_ws_common.sys_yes), -- launch planner, argument 4, set to Yes always

156: FALSE, -- sub_request
157: l_plan_name, -- plan name, argument 1
158: planId, -- plan name hidden, argument 2
159: to_char(msc_ws_common.sys_yes), -- launch snapshot, argument 3, set to Yes always
160: to_char(msc_ws_common.sys_yes), -- launch planner, argument 4, set to Yes always
161: to_char(msc_ws_common.sys_no), -- netchange, argument 5, set to No always
162: fnd_date.date_to_chardate(anchorDate), -- anchor date, argument 6
163: l_val_archivePlan,
164: l_inventory_atp_flag, -- plan type dummy, argument 7

Line 161: to_char(msc_ws_common.sys_no), -- netchange, argument 5, set to No always

157: l_plan_name, -- plan name, argument 1
158: planId, -- plan name hidden, argument 2
159: to_char(msc_ws_common.sys_yes), -- launch snapshot, argument 3, set to Yes always
160: to_char(msc_ws_common.sys_yes), -- launch planner, argument 4, set to Yes always
161: to_char(msc_ws_common.sys_no), -- netchange, argument 5, set to No always
162: fnd_date.date_to_chardate(anchorDate), -- anchor date, argument 6
163: l_val_archivePlan,
164: l_inventory_atp_flag, -- plan type dummy, argument 7
165: l_24x7_purge, -- msc 24x7, argument 8

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

200: error_tracking_num number;
201: l_SecutirtGroupId NUMBER;
202: BEGIN
203: error_tracking_num :=2010;
204: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
205: IF (l_String <> 'OK') THEN
206: Status := l_String;
207: RETURN;
208: END IF;

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

208: END IF;
209:
210: error_tracking_num :=2030;
211:
212: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRO',l_SecutirtGroupId);
213: IF (l_String <> 'OK') THEN
214: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRO', l_SecutirtGroupId);
215: IF (l_String <> 'OK') THEN
216: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRO',l_SecutirtGroupId);

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

210: error_tracking_num :=2030;
211:
212: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRO',l_SecutirtGroupId);
213: IF (l_String <> 'OK') THEN
214: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRO', l_SecutirtGroupId);
215: IF (l_String <> 'OK') THEN
216: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRO',l_SecutirtGroupId);
217: IF (l_String <> 'OK') THEN
218: Status := l_String;

Line 216: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRO',l_SecutirtGroupId);

212: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFNSCW-SRO',l_SecutirtGroupId);
213: IF (l_String <> 'OK') THEN
214: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPCMN-SRO', l_SecutirtGroupId);
215: IF (l_String <> 'OK') THEN
216: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSC_ORG_FNDRSRUN_LAUNCH_SRO',l_SecutirtGroupId);
217: IF (l_String <> 'OK') THEN
218: Status := l_String;
219: RETURN;
220: END IF;

Line 246: -- 00303 - SET_IO_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID

242: -- format of ERROR_UNEXPECTED_#####.
243: -- The possible values are:
244: -- 00301 - SET_IO_PLAN_OPTIONS/VALIDATE_PLAN_ID
245: -- 00302 - SET_IO_PLAN_OPTIONS/VALIDATE_PLAN_TYPE
246: -- 00303 - SET_IO_PLAN_OPTIONS/MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID
247: -- 00304 - SET_IO_PLAN_OPTIONS/VALIDATE_SER_LVL_SET_ID
248: -- 00305 - SET_IO_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_DMD_SCH_ID
249: -- 00306 - SET_IO_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)
250: -- - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)

Line 254: -- 00309 - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG

250: -- - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_CONSUM_LVL (goe)
251: -- 00307 - SET_IO_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_CONSUM_LVL (item)
252: -- - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_CONSUM_LVL (item)
253: -- -- 00308 - SET_IO_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_VARIABILITY/VALIDATE_G_VARIABILITY_ID
254: -- 00309 - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
255: -- 00310 - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
256: -- 00311 - SET_IO_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
257: -- 00312 - SET_IO_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS
258: -- 00313 - SET_IO_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_GLB_DMD_SCHEDULE

Line 256: -- 00311 - SET_IO_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES

252: -- - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_CONSUM_LVL (item)
253: -- -- 00308 - SET_IO_PLAN_OPTIONS/VALIDATE_GLB_DMD_SCHS/VALIDATE_G_VARIABILITY/VALIDATE_G_VARIABILITY_ID
254: -- 00309 - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG
255: -- 00310 - SET_IO_PLAN_OPTIONS/VALIDATE_LOC_DMD_SCHS/VALIDATE_L_DMD_SCH_ID
256: -- 00311 - SET_IO_PLAN_OPTIONS/MSC_WS_COMMON.PURGE_ALL_SCHEDULES
257: -- 00312 - SET_IO_PLAN_OPTIONS/UPDATE_PLAN_OPTIONS
258: -- 00313 - SET_IO_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_GLB_DMD_SCHEDULE
259: -- SET_IO_PLAN_OPTIONS/INSERT_OR_UPDATE_ALL_SCHS/INSERT_GLB_DMD_SCHEDULE
260: -- 00314 - SET_IO_PLAN_OPTIONS/INSERT_ALL_SCHEDULES/INSERT_LOC_DMD_SCHEDULE

Line 419: -- MSC_WS_COMMON. ASCP has its own in MSC_WS_ASCP.

415:
416: -- =============================================================
417: -- Desc: Validate the ship to consumption level. This function is
418: -- used by IO only. DRP and SRP have their own function in
419: -- MSC_WS_COMMON. ASCP has its own in MSC_WS_ASCP.
420: -- Input:
421: -- ShipTo Ship to consumption level.
422: -- SchId Demand schedule id.
423: --

Line 665: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAll) = MSC_UTIL.SYS_NO THEN

661: l_Probability NUMBER;
662: BEGIN
663: SchTbl := MscIDmdSchVarTbl();
664: SchTbl.DELETE;
665: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAll) = MSC_UTIL.SYS_NO THEN
666: BEGIN
667: OPEN schedule_c(PlanId);
668: LOOP
669: FETCH schedule_c into l_InsId, l_SchedId, l_VarType, l_Probability;

Line 864: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAll) = MSC_UTIL.SYS_NO THEN

860: l_Probability NUMBER;
861: BEGIN
862: SchTbl := MscIDmdSchVarTbl();
863: SchTbl.DELETE;
864: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAll) = MSC_UTIL.SYS_NO THEN
865: BEGIN
866: OPEN schedule_c(PlanId, ScenarioSetId);
867: LOOP
868: FETCH schedule_c into l_InsId, l_OrgId, l_SchedId, l_VarType, l_Probability;

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

1167: FOR I IN SchTable.first..SchTable.last
1168: LOOP
1169: -- validate organization id
1170: BEGIN
1171: l_ReturnString := MSC_WS_COMMON.PLAN_CONTAINS_THIS_ORG(l_OrgInsId, SchTable(I).OrgId, PlanId);
1172: IF (l_ReturnString <> 'OK') THEN
1173: -- overwrite the error token here.
1174: l_ReturnString := 'INVALID_LOCALDMDSCHS_ORGID';
1175: RETURN l_ReturnString;

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

1635: g_IGlbDmdSchTbl := MscIGlbIODmdSchTbl();
1636: g_ILocDmdSchTbl := MscILocIODmdSchTbl();
1637:
1638: -- check user id and responsibility
1639: MSC_WS_COMMON.VALIDATE_USER_RESP(l_String, UserId, ResponsibilityId);
1640: IF (l_String <> 'OK') THEN
1641: Status := l_String;
1642: RETURN;
1643: END IF;

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

1642: RETURN;
1643: END IF;
1644:
1645: -- check plan id
1646: -- l_String := MSC_WS_COMMON.VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
1647: l_String := VALIDATE_PLAN_ID(l_OrgId, l_InsId, l_PlanName, PlanId);
1648: IF (l_String <> 'OK') THEN
1649: Status := l_String;
1650: RETURN;

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

1659:
1660:
1661: -- validate item simulation set id
1662: BEGIN
1663: l_String := MSC_WS_COMMON.VALIDATE_SIMULATION_SET_ID(ItemSimulationSetId);
1664: IF (l_String <> 'OK') THEN
1665: Status := l_String;
1666: RETURN;
1667: END IF;

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

1693: END IF;
1694:
1695: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
1696: -- local demand schedule and local supply schedules
1697: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1698: BEGIN
1699: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
1700: EXCEPTION WHEN others THEN
1701: g_ErrorCode := 'ERROR_UNEXPECTED_00011';

Line 1699: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);

1695: -- if PurgeAllSchsFlag is set, purge all global demand schedules,
1696: -- local demand schedule and local supply schedules
1697: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1698: BEGIN
1699: MSC_WS_COMMON.PURGE_ALL_SCHEDULES(PlanId);
1700: EXCEPTION WHEN others THEN
1701: g_ErrorCode := 'ERROR_UNEXPECTED_00011';
1702: raise;
1703: END;

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

1706: -- update item simulation set and overwrite
1707: UPDATE_PLAN_OPTIONS(PlanId, ItemSimulationSetId, ServiceLvlSetId);
1708:
1709: -- set all global/local demand/supply schedules
1710: IF MSC_WS_COMMON.BOOL_TO_NUMBER(PurgeAllSchsFlag) = MSC_UTIL.SYS_YES THEN
1711: l_String := INSERT_ALL_SCHEDULES(PlanId, l_InsId, UserId);
1712: ELSE
1713: l_String := INSERT_OR_UPDATE_ALL_SCHS(PlanId, l_InsId, UserId);
1714: END IF;

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

1753: error_tracking_num number;
1754: l_SecutirtGroupId NUMBER;
1755: BEGIN
1756: error_tracking_num :=2010;
1757: MSC_WS_COMMON.GET_PERMISSION_IDS(l_String, userid, respid, l_SecutirtGroupId, UserName, RespName, RespApplName, SecurityGroupName, Language);
1758: IF (l_String <> 'OK') THEN
1759: Status := l_String;
1760: RETURN;
1761: END IF;

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

1760: RETURN;
1761: END IF;
1762:
1763: error_tracking_num :=2030;
1764: MSC_WS_COMMON.VALIDATE_USER_RESP_FUNC(l_String, userid, respid, 'MSCFPPMR-SRO',l_SecutirtGroupId);
1765: IF (l_String <> 'OK') THEN
1766: Status := l_String;
1767: RETURN;
1768: END IF;