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
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
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,
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;
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,
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;
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,
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;
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
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
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,
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;
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;
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
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,
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;
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,
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;
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*/
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
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;
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');
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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,
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;
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,
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;
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*/
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
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:
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');