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_SUPPLY_ODS_LOAD

Line 388: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD

384: RETURN FALSE;
385: END PURGE_STAGING;
386:
387:
388: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD
389: through bug5952569 */
390:
391: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD
392: through bug5952569 */

Line 396: /* procedure create_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD

392: through bug5952569 */
393:
394: /* ds change chaneg end */
395:
396: /* procedure create_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD
397: through bug5952569 */
398: /* procedure drop_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD
399: through bug5952569 */
400:

Line 398: /* procedure drop_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD

394: /* ds change chaneg end */
395:
396: /* procedure create_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD
397: through bug5952569 */
398: /* procedure drop_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_ODS_LOAD
399: through bug5952569 */
400:
401: /* function drop_demands_tmp_ind has been moved to package MSC_CL_DEMAND_ODS_LOAD
402: (bug5952569) */

Line 1424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');

1420: where instance_id = v_instance_id;
1421: commit;
1422:
1423: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
1425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1426: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
1427:
1428: IF v_is_complete_refresh AND v_exchange_mode=MSC_UTIL.SYS_NO THEN

Line 1426: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

1422:
1423: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
1425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1426: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
1427:
1428: IF v_is_complete_refresh AND v_exchange_mode=MSC_UTIL.SYS_NO THEN
1429: -- DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', v_instance_id, -1);
1430: -- DELETE_MSC_TABLE( 'MSC_DEMANDS', v_instance_id, -1 );

Line 1447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

1443: IF ((v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (v_exchange_mode = MSC_UTIL.SYS_YES)) THEN
1444: --(irrelevant now)For Continious (as in execute_partial_task before calling LOAD_SUPPLY in Continious collections
1445: -- exchange mode is set no) and incremental collections exchange_mode will be NO.The only left case is Complete collections.
1446: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
1448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1449: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1450:
1451: END IF;

Line 1449: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

1445: -- exchange mode is set no) and incremental collections exchange_mode will be NO.The only left case is Complete collections.
1446: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1447: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
1448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1449: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1450:
1451: END IF;
1452:
1453: update msc_apps_instances

Line 1463: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1459:
1460:
1461: ELSIF pTASKNUM= TASK_MDS_DEMAND THEN
1462:
1463: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1464: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1465: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
1466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1467: MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND;

Line 1482: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1478: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
1479:
1480: ELSIF pTASKNUM= TASK_WIP_COMP_DEMAND THEN
1481:
1482: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
1485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1486: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

Line 1506: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1502: END IF;
1503:
1504: ELSIF pTASKNUM= TASK_RES_REQ THEN
1505:
1506: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1507: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
1509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1510: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

Line 1570: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1566: -- LOAD_RESOURCE;
1567:
1568: ELSIF pTASKNUM= TASK_SALES_ORDER THEN
1569:
1570: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1571: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
1573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1574: MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER;

Line 1848: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1844:
1845: END IF;
1846: /* ds change start */
1847: ELSIF pTASKNUM= TASK_RES_INST_REQ THEN
1848: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1849: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1850: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1852: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

Line 1899: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');

1895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
1896: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
1897:
1898: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1899: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
1901: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
1902:
1903: ELSIF pTASKNUM= TASK_CURRENCY_CONVERSION THEN ---- for bug # 6469722

Line 1901: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;

1897:
1898: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1899: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
1900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
1901: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
1902:
1903: ELSIF pTASKNUM= TASK_CURRENCY_CONVERSION THEN ---- for bug # 6469722
1904: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1905: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');

Line 1924: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1920: ELSIF pTASKNUM= TASK_IRO_DEMAND THEN -- Changed For bug 5909379 SRP Additions
1921:
1922:
1923:
1924: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1925: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1926: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND;');
1927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1928: -- LOG_MESSAGE(FND_MESSAGE.GET);

Line 1938: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1934: ELSIF pTASKNUM= TASK_ERO_DEMAND THEN -- Changed For bug 5935273 SRP Additions
1935:
1936:
1937:
1938: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1939: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1940: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND;');
1941: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1942: --LOG_MESSAGE(FND_MESSAGE.GET);

Line 2246: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2242: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or
2243: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
2244: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2245:
2246: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2247: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2248: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2250: 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');

Line 2269: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2265: END IF;
2266:
2267: ELSIF pTASKNUM = PTASK_WIP_RES_REQ THEN
2268:
2269: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2270: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2271: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ');
2272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2273: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

Line 2292: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2288: (v_coll_prec.mds_flag = MSC_UTIL.SYS_YES and v_coll_prec.mds_sn_flag <>MSC_UTIL.SYS_TGT)) AND
2289: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO or
2290: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.udmd_sn_flag <>MSC_UTIL.SYS_TGT))
2291: ) ))) THEN
2292: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2293: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2294: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling LOAD_WIP_DEMAND From PTASK_WIP_DEMAND -- Either WIP is Targetted ');

Line 2352: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2348: MSC_CL_DEMAND_ODS_LOAD.LOAD_ITEM_FORECASTS;
2349: END IF;
2350:
2351: IF (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES and v_coll_prec.wip_sn_flag = MSC_UTIL.SYS_INCR) THEN
2352: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2353: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2354: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND');
2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2356: v_is_incremental_refresh := TRUE;

Line 2375: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2371: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or
2372: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
2373: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2374:
2375: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2376: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2377: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_DEMAND');
2378: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2379: v_is_incremental_refresh := TRUE;

Line 2454: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');

2450: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_INCR) or
2451: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR) then
2452:
2453: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2454: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2456: v_exchange_mode := MSC_UTIL.SYS_NO;
2457: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2458: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

Line 2457: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

2453: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2454: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2456: v_exchange_mode := MSC_UTIL.SYS_NO;
2457: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2458: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2460: end if;
2461:

Line 2458: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

2454: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2456: v_exchange_mode := MSC_UTIL.SYS_NO;
2457: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2458: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2460: end if;
2461:
2462: -- now call load_staging_supply and load_ods_supply

Line 2459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

2455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2456: v_exchange_mode := MSC_UTIL.SYS_NO;
2457: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2458: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2460: end if;
2461:
2462: -- now call load_staging_supply and load_ods_supply
2463: -- to collect the supply entities that are collected in

Line 2476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');

2472: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT) then
2473: -- Load Supply information from staging tables
2474: -- into the temp table.
2475: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2479: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');

Line 2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');

2474: -- into the temp table.
2475: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2479: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2481: -- Load Supply information from ODS table
2482: -- into the temp table.

Line 2479: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

2475: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2479: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2481: -- Load Supply information from ODS table
2482: -- into the temp table.
2483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');

2476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2479: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2481: -- Load Supply information from ODS table
2482: -- into the temp table.
2483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

Line 2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

2480: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2481: -- Load Supply information from ODS table
2482: -- into the temp table.
2483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');

Line 2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');

2482: -- into the temp table.
2483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2489:
2490: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

Line 2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

2483: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2489:
2490: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');

Line 2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');

2484: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2485: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2489:
2490: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2492: ELSE

Line 2490: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2487: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2489:
2490: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2492: ELSE
2493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
2494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');

Line 2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');

2499:
2500: end if; --- any one of the Supplies will be done Targeted
2501:
2502: ELSIF (v_is_incremental_refresh) then
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

Line 2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');

2501:
2502: ELSIF (v_is_incremental_refresh) then
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2508: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

Line 2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2508: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2510: ELSE ---- Targeted Collections
2511: -- Load Supply information from staging tables

Line 2508: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

2504: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2508: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2510: ELSE ---- Targeted Collections
2511: -- Load Supply information from staging tables
2512: -- into the temp table.

Line 2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

2505: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2507: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2508: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2510: ELSE ---- Targeted Collections
2511: -- Load Supply information from staging tables
2512: -- into the temp table.
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

Line 2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2510: ELSE ---- Targeted Collections
2511: -- Load Supply information from staging tables
2512: -- into the temp table.
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2514: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2515: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2517: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

Line 2515: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');

2511: -- Load Supply information from staging tables
2512: -- into the temp table.
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2514: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2515: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2517: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2518: -- Load Supply information from ODS table
2519: -- into the temp table.

Line 2517: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2514: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2515: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2516: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2517: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2518: -- Load Supply information from ODS table
2519: -- into the temp table.
2520: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2521: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

Line 2521: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

2517: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2518: -- Load Supply information from ODS table
2519: -- into the temp table.
2520: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2521: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2523: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2524:
2525: /*added by raraghav*/

Line 2523: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

2519: -- into the temp table.
2520: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2521: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2523: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2524:
2525: /*added by raraghav*/
2526:
2527: /* analyze msc_supplies here */

Line 2534: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

2530: --=============================================
2531: -- NCP:
2532: -- Create index in case of Partial refresh only
2533: -- ============================================
2534: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2535: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2536: ELSE
2537: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
2538: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');

Line 2590: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2586: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
2587: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES) ) THEN
2588:
2589: -- If any of the supply flags are enabled then wait for supplies to get finished
2590: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Calling MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER_2 ...');
2592: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2593: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_DEMAND_ODS_LOAD.LOAD_SALES_ORDER');
2594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2801: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2797: END IF;
2798:
2799: /*ds change start */
2800: ELSIF pTASKNUM = PTASK_RES_INST_REQ THEN
2801: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2802: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2803: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ');
2804: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2805: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

Line 2868: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');

2864: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
2865: MSC_CL_DEMAND_ODS_LOAD.LOAD_PAYBACK_DEMANDS;
2866:
2867: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2868: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
2870: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
2871:
2872: ELSIF pTASKNUM= PTASK_DELIVERY_DETAILS THEN

Line 2870: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;

2866:
2867: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2868: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES');
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
2870: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
2871:
2872: ELSIF pTASKNUM= PTASK_DELIVERY_DETAILS THEN
2873: IF (v_apps_ver >= MSC_UTIL.G_APPS120) THEN
2874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2894: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2890: END IF;
2891:
2892: ELSIF pTASKNUM= PTASK_IRO_DEMAND THEN
2893: IF NOT(v_is_cont_refresh) THEN
2894: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2895: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2896: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND');
2897: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2898: MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND;

Line 2903: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2899: END IF;
2900: END IF;
2901: ELSIF pTASKNUM= PTASK_ERO_DEMAND THEN
2902: IF NOT(v_is_cont_refresh) THEN
2903: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2904: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2905: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND');
2906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2907: MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND;

Line 4165: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

4161: WHERE mai.INSTANCE_ID= v_instance_id;
4162: commit;
4163:
4164: IF (v_is_complete_refresh) THEN
4165: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
4166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index Dropping on Temp Supplies table successful.');
4167: ELSE
4168: ROLLBACK;
4169: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

Line 4278: 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

4274: END IF;
4275: END IF;
4276: /* ds change end */
4277: IF (v_is_complete_refresh) THEN
4278: 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
4279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index Dropping on Temp Tables successful.');
4280: ELSE
4281: ROLLBACK;
4282: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the Indexes on Temp Tables.' );

Line 5860: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

5856: or (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES )
5857: or (v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES )
5858: or (v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES )
5859: or (v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES )) then
5860: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
5861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
5862: ELSE
5863: ROLLBACK;
5864: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

Line 5972: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

5968: (v_coll_prec.oh_flag = MSC_UTIL.SYS_YES and v_coll_prec.oh_sn_flag = MSC_UTIL.SYS_TGT) or
5969: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
5970: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_TGT)
5971: ) then
5972: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
5973: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
5974: ELSE
5975: ROLLBACK;
5976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

Line 5993: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

5989: or (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES )
5990: or (v_coll_prec.internal_repair_flag = MSC_UTIL.SYS_YES )
5991: or (v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES )
5992: or (v_coll_prec.payback_demand_supply_flag = SYS_YES)) then
5993: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
5994: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
5995: ELSE
5996: ROLLBACK;
5997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );