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_CL_COLLECTION dependencies on MSC_CL_WIP_ODS_LOAD

Line 1487: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;

1483: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
1484: where instance_id = v_instance_id;
1485: commit;
1486:
1487: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;
1488:
1489:
1490: ELSIF pTASKNUM= TASK_MDS_DEMAND THEN
1491:

Line 1513: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');

1509: ELSIF pTASKNUM= TASK_WIP_COMP_DEMAND THEN
1510:
1511: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1512: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1513: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1515: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
1516: ELSE
1517: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_WIP_COMP_DEMAND');

Line 1515: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

1511: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1512: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1513: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1515: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
1516: ELSE
1517: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_WIP_COMP_DEMAND');
1518: RAISE SUPPLIES_LOAD_FAIL;
1519: END IF;

Line 1537: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');

1533: ELSIF pTASKNUM= TASK_RES_REQ THEN
1534:
1535: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1536: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1537: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
1538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1539: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
1540: ELSE
1541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. TASK_RES_REQ');

Line 1539: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

1535: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1536: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1537: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
1538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1539: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
1540: ELSE
1541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. TASK_RES_REQ');
1542: RAISE SUPPLIES_LOAD_FAIL;
1543: END IF;

Line 1550: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');

1546:
1547: IF ((v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (v_exchange_mode = MSC_UTIL.SYS_YES)) THEN
1548:
1549: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1550: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1552: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
1553: ELSE
1554: NULL;

Line 1552: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;

1548:
1549: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1550: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
1551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1552: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
1553: ELSE
1554: NULL;
1555: END IF;
1556:

Line 1891: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');

1887: /* ds change start */
1888: ELSIF pTASKNUM= TASK_RES_INST_REQ THEN
1889: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1890: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1891: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1893: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;
1894: ELSE
1895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_RES_INST_REQ');

Line 1893: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

1889: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1890: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1891: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
1892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1893: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;
1894: ELSE
1895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_RES_INST_REQ');
1896: RAISE SUPPLIES_LOAD_FAIL;
1897: END IF;

Line 2568: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');

2564: ELSIF pTASKNUM = PTASK_WIP_RES_REQ THEN
2565:
2566: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2567: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2568: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
2569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2570: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
2571: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
2572: ELSE

Line 2570: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

2566: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2567: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2568: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
2569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2570: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
2571: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
2572: ELSE
2573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. PTASK_WIP_RES_REQ');
2574: RAISE SUPPLIES_LOAD_FAIL;

Line 2571: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;

2567: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2568: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
2569: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2570: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
2571: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
2572: ELSE
2573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. PTASK_WIP_RES_REQ');
2574: RAISE SUPPLIES_LOAD_FAIL;
2575: END IF;

Line 2592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');

2588: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.udmd_sn_flag <>MSC_UTIL.SYS_TGT))
2589: ) ))) THEN
2590: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2591: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling LOAD_WIP_DEMAND From PTASK_WIP_DEMAND -- Either WIP is Targetted ');
2595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2596: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

Line 2596: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

2592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
2593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling LOAD_WIP_DEMAND From PTASK_WIP_DEMAND -- Either WIP is Targetted ');
2595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2596: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
2597: ELSE
2598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.LOAD_WIP_DEMAND');
2599: RAISE SUPPLIES_LOAD_FAIL;
2600: END IF;

Line 2652: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');

2648:
2649: IF (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) THEN
2650: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2651: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2652: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
2653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2654: v_is_incremental_refresh := TRUE;
2655: v_exchange_mode := MSC_UTIL.SYS_NO;
2656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_WIP_DEMAND From PTASK_ODS_DEMAND');

Line 2657: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

2653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2654: v_is_incremental_refresh := TRUE;
2655: v_exchange_mode := MSC_UTIL.SYS_NO;
2656: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_WIP_DEMAND From PTASK_ODS_DEMAND');
2657: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
2658: ELSE
2659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.LOAD_WIP_DEMAND');
2660: RAISE SUPPLIES_LOAD_FAIL;
2661: END IF;

Line 2736: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');

2732:
2733:
2734: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2735: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2736: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
2737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2738: v_is_incremental_refresh := TRUE;
2739: v_exchange_mode := MSC_UTIL.SYS_NO;
2740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_RES_REQ From PTASK_ODS_RES_REQ');

Line 2741: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

2737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2738: v_is_incremental_refresh := TRUE;
2739: v_exchange_mode := MSC_UTIL.SYS_NO;
2740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_RES_REQ From PTASK_ODS_RES_REQ');
2741: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;
2742: ELSE
2743: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.LOAD_RES_REQ');
2744: RAISE SUPPLIES_LOAD_FAIL;
2745: END IF;

Line 2748: /* AFTER HANDLING OTHER res req INCREMENTAL PERFORM THE MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ */

2744: RAISE SUPPLIES_LOAD_FAIL;
2745: END IF;
2746:
2747:
2748: /* AFTER HANDLING OTHER res req INCREMENTAL PERFORM THE MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ */
2749: /* --------------------------------------------------------------------
2750:
2751: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2752: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');

Line 2752: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');

2748: /* AFTER HANDLING OTHER res req INCREMENTAL PERFORM THE MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ */
2749: /* --------------------------------------------------------------------
2750:
2751: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2752: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
2753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ From PTASK_ODS_RES_REQ ');
2755: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ; */
2756:

Line 2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ From PTASK_ODS_RES_REQ ');

2750:
2751: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2752: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
2753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ From PTASK_ODS_RES_REQ ');
2755: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ; */
2756:
2757:
2758:

Line 2755: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ; */

2751: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2752: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
2753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ From PTASK_ODS_RES_REQ ');
2755: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ; */
2756:
2757:
2758:
2759: END IF;

Line 2764: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');

2760:
2761: elsif (v_is_partial_refresh) THEN -- Targeted collections
2762:
2763: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2764: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
2765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2766: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
2767: -- Load res req information from ODS table into the temp table.
2768:

Line 2766: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;

2762:
2763: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2764: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ');
2765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2766: MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
2767: -- Load res req information from ODS table into the temp table.
2768:
2769: end if;
2770:

Line 2929: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;

2925: END IF;
2926:
2927: END IF;
2928:
2929: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;
2930:
2931: END IF;
2932:
2933: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after job_details.');

Line 3157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');

3153: /*ds change start */
3154: ELSIF pTASKNUM = PTASK_RES_INST_REQ THEN
3155: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3156: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
3158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3159: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;
3160: ELSE
3161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.PTASK_RES_INST_REQ');

Line 3159: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

3155: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3156: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
3158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3159: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;
3160: ELSE
3161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.PTASK_RES_INST_REQ');
3162: RAISE SUPPLIES_LOAD_FAIL;
3163: END IF;

Line 3336: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;

3332: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3333: 'Loading of Supplies failed.PTASK_EAM_FORECAST_RR');
3334: RAISE SUPPLIES_LOAD_FAIL;
3335: END IF;
3336: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
3337: END IF;
3338:
3339: ELSIF ( pTASKNUM= PTASK_VISITS ) THEN
3340: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

Line 3441: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;

3437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3438: 'Loading of Supplies failed.PTASK_CMRO_FORECAST_RR');
3439: RAISE SUPPLIES_LOAD_FAIL;
3440: END IF;
3441: --MSC_CL_WIP_ODS_LOAD.LOAD_ODS_RES_REQ;
3442: END IF;
3443:
3444: ELSIF ( pTASKNUM= PTASK_CMRO_SUPP_RESRV ) THEN
3445: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER