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_DEMAND_ODS_LOAD

Line 307: package MSC_CL_DEMAND_ODS_LOAD */

303:
304:
305:
306: /* removed LINK_SUPP_SO_DEMAND_EXT for bug5952569 and placed in
307: package MSC_CL_DEMAND_ODS_LOAD */
308: -- ******************************
309:
310: /* removed LINK_SUPP_SO_DEMAND_110 for bug5952569 and placed in
311: package MSC_CL_DEMAND_ODS_LOAD */

Line 311: package MSC_CL_DEMAND_ODS_LOAD */

307: package MSC_CL_DEMAND_ODS_LOAD */
308: -- ******************************
309:
310: /* removed LINK_SUPP_SO_DEMAND_110 for bug5952569 and placed in
311: package MSC_CL_DEMAND_ODS_LOAD */
312:
313: /* removed LINK_SUPP_SO_DEMAND_11I2 for bug5952569 and placed in
314: package MSC_CL_DEMAND_ODS_LOAD */
315:

Line 314: package MSC_CL_DEMAND_ODS_LOAD */

310: /* removed LINK_SUPP_SO_DEMAND_110 for bug5952569 and placed in
311: package MSC_CL_DEMAND_ODS_LOAD */
312:
313: /* removed LINK_SUPP_SO_DEMAND_11I2 for bug5952569 and placed in
314: package MSC_CL_DEMAND_ODS_LOAD */
315:
316:
317:
318: FUNCTION PURGE_STAGING (pINSTANCE_ID in number)

Line 409: /* function drop_demands_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD

405: through bug5952569 */
406: /* procedure drop_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD
407: through bug5952569 */
408:
409: /* function drop_demands_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD
410: (bug5952569) */
411:
412: /* function drop_sales_orders_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD
413: (bug5952569) */

Line 412: /* function drop_sales_orders_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD

408:
409: /* function drop_demands_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD
410: (bug5952569) */
411:
412: /* function drop_sales_orders_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD
413: (bug5952569) */
414:
415: --****************************
416: PROCEDURE LOG_MESSAGE(pSOURCE IN NUMBER,

Line 784: /* function LINK_PARENT_SALES_ORDERS has been moved to package MSC_CL_DEMAND_ODS_LOAD

780: WHEN OTHERS THEN
781: RETURN FALSE;
782: END is_msctbl_partitioned;
783:
784: /* function LINK_PARENT_SALES_ORDERS has been moved to package MSC_CL_DEMAND_ODS_LOAD
785: through bug5952569 */
786:
787: /* function LINK_PARENT_SALES_ORDERS_MDS has been moved to package MSC_CL_DEMAND_ODS_LOAD
788: through bug5952569 */

Line 787: /* function LINK_PARENT_SALES_ORDERS_MDS has been moved to package MSC_CL_DEMAND_ODS_LOAD

783:
784: /* function LINK_PARENT_SALES_ORDERS has been moved to package MSC_CL_DEMAND_ODS_LOAD
785: through bug5952569 */
786:
787: /* function LINK_PARENT_SALES_ORDERS_MDS has been moved to package MSC_CL_DEMAND_ODS_LOAD
788: through bug5952569 */
789:
790:
791:

Line 1494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

1490: ELSIF pTASKNUM= TASK_MDS_DEMAND THEN
1491:
1492: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1493: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
1495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1496: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
1497: ELSE
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_MDS_DEMAND');

Line 1496: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

1492: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1493: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
1495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1496: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
1497: ELSE
1498: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_MDS_DEMAND');
1499: RAISE SUPPLIES_LOAD_FAIL;
1500: END IF;

Line 1505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS');

1501:
1502: ELSIF pTASKNUM= TASK_ITEM_FORECASTS THEN
1503:
1504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS');
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1507: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
1508:
1509: ELSIF pTASKNUM= TASK_WIP_COMP_DEMAND THEN

Line 1507: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;

1503:
1504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS');
1506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1507: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
1508:
1509: ELSIF pTASKNUM= TASK_WIP_COMP_DEMAND THEN
1510:
1511: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

Line 1526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');

1522:
1523: IF ((v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (v_exchange_mode = MSC_UTIL.SYS_YES)) THEN
1524:
1525: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1528: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
1529: ELSE
1530: NULL;

Line 1528: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;

1524:
1525: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1526: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
1527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1528: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
1529: ELSE
1530: NULL;
1531: END IF;
1532:

Line 1613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');

1609: ELSIF pTASKNUM= TASK_SALES_ORDER THEN
1610:
1611: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1612: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
1614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1615: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
1616:
1617: IF (v_is_complete_refresh = TRUE and v_is_so_complete_refresh = FALSE) THEN

Line 1615: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

1611: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1612: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
1614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1615: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
1616:
1617: IF (v_is_complete_refresh = TRUE and v_is_so_complete_refresh = FALSE) THEN
1618: IF (v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
1619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');

Line 1621: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');

1617: IF (v_is_complete_refresh = TRUE and v_is_so_complete_refresh = FALSE) THEN
1618: IF (v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
1619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
1620: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1621: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1623: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
1624: -- Calling the Linking of external Sales orders for the fix 2353397 --
1625: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

Line 1623: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;

1619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
1620: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1621: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1623: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
1624: -- Calling the Linking of external Sales orders for the fix 2353397 --
1625: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
1626: ELSIF (v_apps_ver = MSC_UTIL.G_APPS110) THEN
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');

Line 1625: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

1621: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1623: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
1624: -- Calling the Linking of external Sales orders for the fix 2353397 --
1625: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
1626: ELSIF (v_apps_ver = MSC_UTIL.G_APPS110) THEN
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');
1628: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');

Line 1629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');

1625: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
1626: ELSIF (v_apps_ver = MSC_UTIL.G_APPS110) THEN
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');
1628: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1631: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;
1632: END IF;
1633: END IF;

Line 1631: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;

1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');
1628: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
1629: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');
1630: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1631: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;
1632: END IF;
1633: END IF;
1634:
1635: ELSE

Line 1650: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');

1646:
1647: ELSIF pTASKNUM= TASK_HARD_RESERVATION THEN
1648:
1649: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1650: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');
1651: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1652: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;
1653:
1654: ELSIF pTASKNUM= TASK_SOURCING THEN

Line 1652: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;

1648:
1649: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1650: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');
1651: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1652: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;
1653:
1654: ELSIF pTASKNUM= TASK_SOURCING THEN
1655:
1656: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1935: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');

1931: MSC_CL_OTHER_ODS_LOAD.LOAD_FISCAL_CALENDAR;
1932:
1933: ELSIF pTASKNUM= TASK_PAYBACK_DEMAND_SUPPLY THEN
1934: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1935: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');
1936: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
1937: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
1938:
1939: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1937: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;

1933: ELSIF pTASKNUM= TASK_PAYBACK_DEMAND_SUPPLY THEN
1934: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1935: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');
1936: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
1937: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
1938:
1939: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1940: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
1941: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);

Line 2496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');

2492:
2493: ELSIF pTASKNUM= PTASK_HARD_RESERVATION THEN
2494:
2495: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2498: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;
2499:
2500: ELSIF pTASKNUM= PTASK_SOURCING THEN

Line 2498: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;

2494:
2495: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2496: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION');
2497: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2498: MSC_CL_DEMAND_ODS_LOAD.LOAD_HARD_RESERVATION;
2499:
2500: ELSIF pTASKNUM= PTASK_SOURCING THEN
2501:
2502: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2545: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

2541: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2542:
2543: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2544: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2545: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2546: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_MDS_DEMAND -- Either MDS Is targetted');
2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2549: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

Line 2547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_MDS_DEMAND -- Either MDS Is targetted');

2543: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2544: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2545: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2546: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_MDS_DEMAND -- Either MDS Is targetted');
2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2549: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2550: ELSE
2551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.mps etc');

Line 2549: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

2545: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2546: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_MDS_DEMAND -- Either MDS Is targetted');
2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2549: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2550: ELSE
2551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.mps etc');
2552: RAISE SUPPLIES_LOAD_FAIL;
2553: END IF;

Line 2557: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

2553: END IF;
2554:
2555: ELSE
2556: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2557: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2558: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2559: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2560: END IF;
2561:

Line 2559: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

2555: ELSE
2556: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2557: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2558: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2559: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2560: END IF;
2561:
2562: END IF;
2563:

Line 2622: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;

2618: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECAST');
2619: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling LOAD_ITEM_FORECAST From PTASK_FORECAST_DEMAND-- Either forecast id Targetted ');
2621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2622: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
2623:
2624: END IF;
2625:
2626:

Line 2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS From PTASK_ODS_DEMAND');

2641: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ITEM_FORECAST');
2642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2643: v_is_incremental_refresh := TRUE;
2644: v_exchange_mode := MSC_UTIL.SYS_NO;
2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS From PTASK_ODS_DEMAND');
2646: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
2647: END IF;
2648:
2649: IF (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) THEN

Line 2646: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;

2642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2643: v_is_incremental_refresh := TRUE;
2644: v_exchange_mode := MSC_UTIL.SYS_NO;
2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS From PTASK_ODS_DEMAND');
2646: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
2647: END IF;
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

Line 2675: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

2671: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2672:
2673: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2674: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2675: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2676: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2677: v_is_incremental_refresh := TRUE;
2678: v_exchange_mode := MSC_UTIL.SYS_NO;
2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND');

Line 2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND');

2675: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2676: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2677: v_is_incremental_refresh := TRUE;
2678: v_exchange_mode := MSC_UTIL.SYS_NO;
2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND');
2680: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2681: ELSE
2682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' Loading of Supplies failed MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2683: RAISE SUPPLIES_LOAD_FAIL;

Line 2680: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

2676: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2677: v_is_incremental_refresh := TRUE;
2678: v_exchange_mode := MSC_UTIL.SYS_NO;
2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND');
2680: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2681: ELSE
2682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' Loading of Supplies failed MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2683: RAISE SUPPLIES_LOAD_FAIL;
2684: END IF;

Line 2682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' Loading of Supplies failed MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

2678: v_exchange_mode := MSC_UTIL.SYS_NO;
2679: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND');
2680: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2681: ELSE
2682: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ' Loading of Supplies failed MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2683: RAISE SUPPLIES_LOAD_FAIL;
2684: END IF;
2685:
2686: ELSE --- all the supplies flag are no

Line 2688: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');

2684: END IF;
2685:
2686: ELSE --- all the supplies flag are no
2687: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2688: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2690: v_is_incremental_refresh := TRUE;
2691: v_exchange_mode := MSC_UTIL.SYS_NO;
2692: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND -- No Supplies are Collected in this run');

Line 2692: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND -- No Supplies are Collected in this run');

2688: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2690: v_is_incremental_refresh := TRUE;
2691: v_exchange_mode := MSC_UTIL.SYS_NO;
2692: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND -- No Supplies are Collected in this run');
2693: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2694: END IF; ---any supply flag is yes
2695:
2696: END IF;

Line 2693: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

2689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2690: v_is_incremental_refresh := TRUE;
2691: v_exchange_mode := MSC_UTIL.SYS_NO;
2692: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND From PTASK_ODS_DEMAND -- No Supplies are Collected in this run');
2693: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;
2694: END IF; ---any supply flag is yes
2695:
2696: END IF;
2697:

Line 2700: /* AFTER HANDLING OTHER DEMANDS INCREMENTAL PERFORM THE MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND */

2696: END IF;
2697:
2698:
2699:
2700: /* AFTER HANDLING OTHER DEMANDS INCREMENTAL PERFORM THE MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND */
2701: /* -------------------------------------------------------------------- */
2702:
2703: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');

Line 2704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');

2700: /* AFTER HANDLING OTHER DEMANDS INCREMENTAL PERFORM THE MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND */
2701: /* -------------------------------------------------------------------- */
2702:
2703: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
2705: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND From PTASK_ODS_DEMAND -- One of the Demands is Targetted in this run');
2707: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
2708:

Line 2706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND From PTASK_ODS_DEMAND -- One of the Demands is Targetted in this run');

2702:
2703: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
2705: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND From PTASK_ODS_DEMAND -- One of the Demands is Targetted in this run');
2707: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
2708:
2709:
2710:

Line 2707: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;

2703: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2704: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
2705: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND From PTASK_ODS_DEMAND -- One of the Demands is Targetted in this run');
2707: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
2708:
2709:
2710:
2711: END IF; -- Is any Demand Targetted in Continous

Line 2716: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');

2712:
2713: elsif (v_is_partial_refresh) THEN -- Targeted collections
2714:
2715: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2716: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2718: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
2719: -- Load Demand information from ODS table into
2720: -- the temp table.

Line 2718: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;

2714:
2715: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2716: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND');
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2718: MSC_CL_DEMAND_ODS_LOAD.LOAD_ODS_DEMAND;
2719: -- Load Demand information from ODS table into
2720: -- the temp table.
2721:
2722: end if;

Line 2945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');

2941: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2942:
2943: -- If any of the supply flags are enabled then wait for supplies to get finished
2944: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2946: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2949: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

Line 2947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');

2943: -- If any of the supply flags are enabled then wait for supplies to get finished
2944: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2946: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2949: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
2950: ELSE
2951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');

Line 2949: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

2945: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2946: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2949: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
2950: ELSE
2951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2952: RAISE SUPPLIES_LOAD_FAIL;
2953: END IF;

Line 2951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');

2947: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2949: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
2950: ELSE
2951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2952: RAISE SUPPLIES_LOAD_FAIL;
2953: END IF;
2954:
2955: ELSE -- no need to wait for supplies

Line 2956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');

2952: RAISE SUPPLIES_LOAD_FAIL;
2953: END IF;
2954:
2955: ELSE -- no need to wait for supplies
2956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2957: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2960: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

Line 2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');

2954:
2955: ELSE -- no need to wait for supplies
2956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2957: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2960: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
2961: END IF;
2962:

Line 2960: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

2956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2957: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2958: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2960: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;
2961: END IF;
2962:
2963: IF ( v_is_so_incremental_refresh ) THEN
2964: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN

Line 2968: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');

2964: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
2965:
2966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
2967: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2968: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
2969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2970: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
2971: -- Calling the Linking of external Sales orders for the fix 2353397 --
2972: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

Line 2970: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;

2966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
2967: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2968: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
2969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2970: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
2971: -- Calling the Linking of external Sales orders for the fix 2353397 --
2972: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
2973:
2974: ELSIF ( v_apps_ver = MSC_UTIL.G_APPS110) THEN

Line 2972: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

2968: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
2969: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2970: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
2971: -- Calling the Linking of external Sales orders for the fix 2353397 --
2972: -- MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
2973:
2974: ELSIF ( v_apps_ver = MSC_UTIL.G_APPS110) THEN
2975:
2976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');

Line 2978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');

2974: ELSIF ( v_apps_ver = MSC_UTIL.G_APPS110) THEN
2975:
2976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');
2977: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');
2979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2980: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;
2981: END IF;
2982: END IF;

Line 2980: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;

2976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 110 source ...');
2977: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2978: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110');
2979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2980: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_110;
2981: END IF;
2982: END IF;
2983:
2984: ELSIF pTASKNUM= PTASK_NET_RESOURCE_AVAIL THEN

Line 3029: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');

3025:
3026: ELSIF pTASKNUM= PTASK_DESIGNATOR THEN
3027:
3028: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3029: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
3030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3031: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
3032:
3033: ELSIF pTASKNUM= PTASK_BIS_PFMC_MEASURES THEN

Line 3031: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;

3027:
3028: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3029: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
3030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3031: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
3032:
3033: ELSIF pTASKNUM= PTASK_BIS_PFMC_MEASURES THEN
3034:
3035: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN

Line 3218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');

3214: END IF;
3215: ELSIF pTASKNUM= PTASK_PAYBACK_DEMAND_SUPPLY THEN --bug 5861050
3216:
3217: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');
3219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
3220: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
3221:
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3220: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;

3216:
3217: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3218: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS');
3219: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
3220: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
3221:
3222: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3223: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
3224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);

Line 4447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');

4443:
4444: /* load schedule to provide schedule designator information */
4445:
4446: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
4448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4449: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
4450:
4451: COMMIT;

Line 4449: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;

4445:
4446: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
4448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4449: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
4450:
4451: COMMIT;
4452:
4453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');

Line 4453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');

4449: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
4450:
4451: COMMIT;
4452:
4453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
4454: /* load forecast designators */
4455:
4456: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4457: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');

Line 4457: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');

4453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
4454: /* load forecast designators */
4455:
4456: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4457: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');
4458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4459: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;
4460:
4461: COMMIT;

Line 4459: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;

4455:
4456: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4457: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');
4458: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4459: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;
4460:
4461: COMMIT;
4462:
4463: /* USAF load eam-CMRO designators */

Line 4470: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');

4466: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
4467:
4468: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4469: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4470: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');
4471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4472: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;
4473: COMMIT;
4474:

Line 4472: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;

4468: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4469: FND_MESSAGE.SET_TOKEN('PROCEDURE',
4470: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');
4471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4472: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;
4473: COMMIT;
4474:
4475: END IF;
4476:

Line 4885: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN

4881:
4882: IF v_apps_ver >= MSC_UTIL.G_APPS115 THEN --Version
4883: /* call the function to link the Demand_id and Parent_id in MSC_DEMANDS for 11i Source instance */
4884:
4885: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
4886: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
4887: ELSE
4888: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error in Linking Sales order line in MDS to its parent Sales order......');
4889: RETCODE := MSC_UTIL.G_WARNING;

Line 4904: IF (MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind and MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind and MSC_CL_DEMAND_ODS_LOAD.drop_sales_orders_tmp_ind) THEN

4900: END IF;
4901: END IF;
4902: /* ds change end */
4903: IF (v_is_complete_refresh) THEN
4904: IF (MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind and MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind and MSC_CL_DEMAND_ODS_LOAD.drop_sales_orders_tmp_ind) THEN
4905: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index Dropping on Temp Tables successful.');
4906: ELSE
4907: ROLLBACK;
4908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the Indexes on Temp Tables.' );

Line 4942: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');

4938: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
4939: BEGIN
4940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
4941: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4942: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');
4943: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4944: -- Calling the Linking of external Sales orders for the fix 2353397 --
4945: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
4946: END;

Line 4945: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

4941: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4942: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');
4943: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4944: -- Calling the Linking of external Sales orders for the fix 2353397 --
4945: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
4946: END;
4947:
4948: END IF;
4949: END IF;

Line 5803: /* procedure LOAD_ODS_DEMAND has been moved to package MSC_CL_DEMAND_ODS_LOAD

5799:
5800: END Q_PARTIAL_TASK;
5801:
5802:
5803: /* procedure LOAD_ODS_DEMAND has been moved to package MSC_CL_DEMAND_ODS_LOAD
5804: through bug5952569 */
5805:
5806:
5807:

Line 6243: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');

6239: v_is_partial_refresh := FALSE;
6240: end if;
6241:
6242: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6243: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
6244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6245: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
6246:
6247: COMMIT;

Line 6245: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;

6241:
6242: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6243: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR');
6244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6245: MSC_CL_DEMAND_ODS_LOAD.LOAD_DESIGNATOR;
6246:
6247: COMMIT;
6248:
6249: END IF;

Line 6262: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');

6258: v_is_partial_refresh := FALSE;
6259: end if;
6260:
6261: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6262: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');
6263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6264: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;
6265:
6266: END IF;

Line 6264: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;

6260:
6261: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6262: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS');
6263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6264: MSC_CL_DEMAND_ODS_LOAD.LOAD_FORECASTS;
6265:
6266: END IF;
6267:
6268: /* USAF load eam-CMRO designators */

Line 6275: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');

6271: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
6272:
6273: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6274: FND_MESSAGE.SET_TOKEN('PROCEDURE',
6275: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');
6276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6277: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;
6278: COMMIT;
6279:

Line 6277: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;

6273: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6274: FND_MESSAGE.SET_TOKEN('PROCEDURE',
6275: 'MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS');
6276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6277: MSC_CL_DEMAND_ODS_LOAD.LOAD_CMRO_EAM_FORECASTS ;
6278: COMMIT;
6279:
6280: END IF;
6281:

Line 6641: * MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2 uses this temp

6637: WHERE mai.INSTANCE_ID= v_instance_id;
6638: commit;
6639: /*
6640: * Commented out for bug 13084110 (Forward port for bug 13023757)
6641: * MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2 uses this temp
6642: * index. They are dropped after the call to this procedure below.
6643:
6644:
6645: IF (v_is_partial_refresh) AND

Line 6815: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN

6811: (v_is_cont_refresh AND v_coll_prec.mds_sn_flag = MSC_UTIL.SYS_TGT) THEN -- in auto collcns if mds is targeted
6812:
6813: v_exchange_mode := MSC_UTIL.SYS_YES;
6814:
6815: IF MSC_CL_DEMAND_ODS_LOAD.LINK_PARENT_SALES_ORDERS_MDS THEN
6816: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Linking of Sales Order line in MDS to its Parent Sales orders is successful.....');
6817: ELSE
6818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');
6819: RETCODE := MSC_UTIL.G_WARNING;

Line 6822: IF MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind THEN

6818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error in Linking Sales order line in MDS to its parent Sales order......');
6819: RETCODE := MSC_UTIL.G_WARNING;
6820: END IF;
6821:
6822: IF MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind THEN
6823: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Demands table.' );
6824: ELSE
6825: ROLLBACK;
6826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Demands table.' );

Line 6830: END IF; ---- call to MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind

6826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Demands table.' );
6827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
6828:
6829: RETCODE := MSC_UTIL.G_ERROR;
6830: END IF; ---- call to MSC_CL_DEMAND_ODS_LOAD.drop_demands_tmp_ind
6831:
6832: END IF;
6833: END IF;
6834:

Line 6837: IF MSC_CL_DEMAND_ODS_LOAD.drop_sales_orders_tmp_ind THEN

6833: END IF;
6834:
6835: IF (v_coll_prec.sales_order_flag = MSC_UTIL.SYS_YES) THEN
6836: IF (v_is_partial_refresh) OR (v_is_cont_refresh and v_coll_prec.so_sn_flag = MSC_UTIL.SYS_TGT) then
6837: IF MSC_CL_DEMAND_ODS_LOAD.drop_sales_orders_tmp_ind THEN
6838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Sales Orders table.' );
6839: ELSE
6840: ROLLBACK;
6841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Sales Orders table.' );

Line 6874: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');

6870: v_coll_prec.sales_order_flag =MSC_UTIL.SYS_NO) THEN
6871: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
6872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
6873: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6874: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
6875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6876: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
6877: END IF;
6878: END IF;

Line 6876: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;

6872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
6873: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
6874: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2');
6875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6876: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_11I2;
6877: END IF;
6878: END IF;
6879:
6880: IF v_exchange_mode= MSC_UTIL.SYS_YES THEN

Line 6920: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');

6916: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
6917: BEGIN
6918: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling Linking of Sales Order for 11i source ...');
6919: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6920: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');
6921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6922: -- Calling the Linking of external Sales orders for the fix 2353397 --
6923: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
6924: END;

Line 6923: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;

6919: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6920: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT');
6921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6922: -- Calling the Linking of external Sales orders for the fix 2353397 --
6923: MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT;
6924: END;
6925:
6926: END IF;
6927: END IF;