DBA Data[Home] [Help]

APPS.MSC_CL_COLLECTION dependencies on MSC_CL_AHL_ODS_LOAD

Line 2032: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');

2028: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2029: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2030: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2031: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2032: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2034: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;
2035: END IF;
2036: ELSIF ( pTASKNUM= TASK_WO_ATTRIBUTES ) THEN

Line 2034: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;

2030: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2031: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2032: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2034: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;
2035: END IF;
2036: ELSIF ( pTASKNUM= TASK_WO_ATTRIBUTES ) THEN
2037: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2038: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN

Line 2043: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES');

2039:
2040: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2043: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2045: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;
2046: ELSE
2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2045: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;

2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2043: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2045: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;
2046: ELSE
2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2048: 'Loading of Supplies failed.TASK_WO_ATTRIBUTES');
2049: RAISE SUPPLIES_LOAD_FAIL;

Line 2060: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');

2056:
2057: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2058: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2059: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2060: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2062: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
2063: ELSE
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2062: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

2058: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2059: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2060: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2062: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
2063: ELSE
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2065: 'Loading of Supplies failed.TASK_WO_TASK_HIERARCHY');
2066: RAISE SUPPLIES_LOAD_FAIL;

Line 2077: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');

2073:
2074: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2075: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2076: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2077: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2079: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;
2080: ELSE
2081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2079: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;

2075: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2076: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2077: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2079: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;
2080: ELSE
2081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2082: 'Loading of Supplies failed.TASK_WO_OPERATION_REL');
2083: RAISE SUPPLIES_LOAD_FAIL;

Line 2092: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');

2088: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2089: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2090: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2091: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2092: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');
2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2094: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;
2095: END IF;
2096: ELSIF ( pTASKNUM= TASK_WO_SUB_COMP ) THEN

Line 2094: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;

2090: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2091: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2092: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');
2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2094: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;
2095: END IF;
2096: ELSIF ( pTASKNUM= TASK_WO_SUB_COMP ) THEN
2097: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2098: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN

Line 2102: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');

2098: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2099: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2100: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2101: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2102: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2104: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;
2105: ELSE
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2104: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;

2100: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2101: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2102: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2104: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;
2105: ELSE
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2107: 'Loading of Supplies failed.TASK_WO_SUB_COMP');
2108: END IF;

Line 2116: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');

2112: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2113: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2114: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2115: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2116: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');
2117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2118: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;
2119:
2120: END IF;

Line 2118: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;

2114: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2115: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2116: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');
2117: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2118: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;
2119:
2120: END IF;
2121: ELSIF ( pTASKNUM= TASK_CMRO_FORECAST_DEMANDS ) THEN
2122: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 2128: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');

2124:
2125: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2126: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2127: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2128: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
2129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2130: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;
2131: ELSE
2132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2130: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;

2126: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2127: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2128: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
2129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2130: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;
2131: ELSE
2132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2133: 'Loading of Supplies failed.LOAD_CMRO_FORECAST_DEMANDS ');
2134: RAISE SUPPLIES_LOAD_FAIL;

Line 2161: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');

2157:
2158: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2159: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2160: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2161: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
2162: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2163: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;
2164: ELSE
2165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2163: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;

2159: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2160: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2161: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
2162: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2163: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;
2164: ELSE
2165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2166: 'Loading of Supplies failed.TASK_CMRO_FORECAST_RR');
2167: RAISE SUPPLIES_LOAD_FAIL;

Line 2192: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');

2188: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2189: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2190: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2191: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2192: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2194: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;
2195: END IF;
2196: /* usaf*/

Line 2194: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;

2190: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2191: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2192: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');
2193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2194: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;
2195: END IF;
2196: /* usaf*/
2197:
2198: ELSIF ( pTASKNUM= TASK_CMRO_CLOSED_WO ) THEN

Line 2204: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');

2200: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2201: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2202: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2203: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2204: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2206: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'b4 ods proc call - closed WO');
2207: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;
2208: END IF;

Line 2207: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;

2203: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2204: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');
2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2206: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'b4 ods proc call - closed WO');
2207: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;
2208: END IF;
2209:
2210: ELSIF ( pTASKNUM= TASK_OSP_SUPPLY ) THEN
2211: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'in task osp supply');

Line 3344: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');

3340: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3341: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3342: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3343: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3344: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');
3345: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3346: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;
3347: END IF;
3348:

Line 3346: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;

3342: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3343: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3344: 'MSC_CL_AHL_ODS_LOAD.TASK_VISITS');
3345: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3346: MSC_CL_AHL_ODS_LOAD.LOAD_VISITS;
3347: END IF;
3348:
3349: ELSIF ( pTASKNUM= PTASK_WO_ATTRIBUTES ) THEN
3350: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3354: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES ');

3350: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3351: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3352: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3353: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3354: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES ');
3355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3356: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;
3357: END IF;
3358:

Line 3356: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;

3352: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3353: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3354: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES ');
3355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3356: MSC_CL_AHL_ODS_LOAD.LOAD_WO_ATTRIBUTES ;
3357: END IF;
3358:
3359: ELSIF ( pTASKNUM= PTASK_WO_TASK_HIERARCHY ) THEN
3360: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3364: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');

3360: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3361: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3363: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3364: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3366: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3367: END IF;
3368:

Line 3366: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;

3362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3363: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3364: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');
3365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3366: MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY;
3367: END IF;
3368:
3369: ELSIF ( pTASKNUM= PTASK_WO_OPERATION_REL ) THEN
3370: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3374: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');

3370: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3371: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3372: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3373: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3374: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');
3375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3376: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;
3377: END IF;
3378:

Line 3376: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;

3372: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3373: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3374: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');
3375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3376: MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL ;
3377: END IF;
3378:
3379: ELSIF ( pTASKNUM= PTASK_WORK_BREAKDOWN_STRUCT ) THEN
3380: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3384: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');

3380: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3381: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3382: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3383: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3384: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');
3385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3386: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;
3387: END IF;
3388:

Line 3386: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;

3382: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3383: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3384: 'MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT');
3385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3386: MSC_CL_AHL_ODS_LOAD.LOAD_WORK_BREAKDOWN_STRUCT;
3387: END IF;
3388:
3389: ELSIF ( pTASKNUM= PTASK_WO_SUB_COMP ) THEN
3390: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3394: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');

3390: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3391: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3394: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3396: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;
3397: END IF;
3398:

Line 3396: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;

3392: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3393: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3394: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');
3395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3396: MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP;
3397: END IF;
3398:
3399: ELSIF ( pTASKNUM= PTASK_WO_MILESTONES ) THEN
3400: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3404: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');

3400: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3401: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3402: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3403: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3404: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');
3405: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3406: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;
3407: END IF;
3408:

Line 3406: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;

3402: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3403: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3404: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES');
3405: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3406: MSC_CL_AHL_ODS_LOAD.LOAD_WO_MILESTONES;
3407: END IF;
3408:
3409: ELSIF ( pTASKNUM= PTASK_CMRO_FORECAST_DEMANDS ) THEN
3410: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3416: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');

3412:
3413: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3414: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3415: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3416: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
3417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3418: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;
3419: ELSE
3420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 3418: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;

3414: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3415: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3416: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
3417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3418: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ;
3419: ELSE
3420: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3421: 'Loading of Supplies failed.PTASK_CMRO_FORECAST_DEMANDS');
3422: RAISE SUPPLIES_LOAD_FAIL;

Line 3433: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');

3429:
3430: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3431: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3432: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3433: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
3434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3435: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;
3436: ELSE
3437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 3435: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;

3431: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3432: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3433: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
3434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3435: MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ;
3436: ELSE
3437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3438: 'Loading of Supplies failed.PTASK_CMRO_FORECAST_RR');
3439: RAISE SUPPLIES_LOAD_FAIL;

Line 3449: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');

3445: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3446: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3447: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3448: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3449: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');
3450: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3451: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;
3452: END IF;
3453: /* usaf*/

Line 3451: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;

3447: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3448: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3449: 'MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ');
3450: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3451: MSC_CL_AHL_ODS_LOAD.LOAD_SUPPLY_RESERVATIONS ;
3452: END IF;
3453: /* usaf*/
3454:
3455: ELSIF ( pTASKNUM= PTASK_CMRO_CLOSED_WO ) THEN

Line 3461: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');

3457: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3458: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'b4 call in BAB');
3459: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3460: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3461: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');
3462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3463: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;
3464: END IF;
3465:

Line 3463: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;

3459: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3460: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3461: 'MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS');
3462: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3463: MSC_CL_AHL_ODS_LOAD.LOAD_CLOSED_CMRO_WOS;
3464: END IF;
3465:
3466: ELSIF ( pTASKNUM= PTASK_OSP_SUPPLY ) THEN
3467: MSC_UTIL.LOG_MSG (MSC_UTIL.G_D_STATUS,'in task osp supply');