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 396: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD

392: RETURN FALSE;
393: END PURGE_STAGING;
394:
395:
396: /* procedure IS_SUPPLIES_LOAD_DONE has been moved to package MSC_CL_SUPPLY_ODS_LOAD
397: through bug5952569 */
398:
399: /* procedure LINK_SUPPLY_TOP_LINK_IDhas been moved to package MSC_CL_SETUP_ODS_LOAD
400: through bug5952569 */

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

400: through bug5952569 */
401:
402: /* ds change chaneg end */
403:
404: /* procedure create_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_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:

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

402: /* ds change chaneg end */
403:
404: /* procedure create_supplies_tmp_ind has been moved to package MSC_CL_SUPPLY_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) */

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

1438: where instance_id = v_instance_id;
1439: commit;
1440:
1441: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1442: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
1443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1444: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
1445:
1446: IF v_is_complete_refresh AND v_exchange_mode=MSC_UTIL.SYS_NO THEN

Line 1444: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

1440:
1441: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1442: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
1443: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1444: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
1445:
1446: IF v_is_complete_refresh AND v_exchange_mode=MSC_UTIL.SYS_NO THEN
1447: -- DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', v_instance_id, -1);
1448: -- DELETE_MSC_TABLE( 'MSC_DEMANDS', v_instance_id, -1 );

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

1472: IF ((v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (v_exchange_mode = MSC_UTIL.SYS_YES)) THEN
1473: --(irrelevant now)For Continious (as in execute_partial_task before calling LOAD_SUPPLY in Continious collections
1474: -- exchange mode is set no) and incremental collections exchange_mode will be NO.The only left case is Complete collections.
1475: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1478: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1479:
1480: END IF;

Line 1478: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

1474: -- exchange mode is set no) and incremental collections exchange_mode will be NO.The only left case is Complete collections.
1475: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1476: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1478: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
1479:
1480: END IF;
1481:
1482: update msc_apps_instances

Line 1492: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1488:
1489:
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;

Line 1511: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

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
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;

Line 1535: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1531: END IF;
1532:
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;

Line 1611: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1607: -- LOAD_RESOURCE;
1608:
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;

Line 1889: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1885:
1886: END IF;
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;

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

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);
1942: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
1943:
1944: ELSIF pTASKNUM= TASK_CURRENCY_CONVERSION THEN ---- for bug # 6469722

Line 1942: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;

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);
1942: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
1943:
1944: ELSIF pTASKNUM= TASK_CURRENCY_CONVERSION THEN ---- for bug # 6469722
1945: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1946: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_OTHER_ODS_LOAD.LOAD_CURRENCY_CONVERSION');

Line 1965: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1961: ELSIF pTASKNUM= TASK_IRO_DEMAND THEN -- Changed For bug 5909379 SRP Additions
1962:
1963:
1964:
1965: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1966: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1967: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND;');
1968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1969: -- LOG_MESSAGE(FND_MESSAGE.GET);

Line 1979: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

1975: ELSIF pTASKNUM= TASK_ERO_DEMAND THEN -- Changed For bug 5935273 SRP Additions
1976:
1977:
1978:
1979: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
1980: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1981: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND;');
1982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1983: --LOG_MESSAGE(FND_MESSAGE.GET);

Line 2017: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2013: ELSIF ( pTASKNUM= TASK_EAM_FORECAST ) THEN
2014: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2015: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2016:
2017: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2019: 'Loading of Eam forecasts done');
2020: ELSE
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2040: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2036: ELSIF ( pTASKNUM= TASK_WO_ATTRIBUTES ) THEN
2037: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2038: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2039:
2040: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2043: 'MSC_CL_AHL_ODS_LOAD.TASK_WO_ATTRIBUTES');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2057: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2053: ELSIF ( pTASKNUM= TASK_WO_TASK_HIERARCHY ) THEN
2054: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2055: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2056:
2057: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2058: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2059: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2060: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_TASK_HIERARCHY');
2061: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2074: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2070: ELSIF ( pTASKNUM= TASK_WO_OPERATION_REL ) THEN
2071: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2072: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2073:
2074: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2075: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2076: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2077: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_OPERATION_REL');
2078: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2099: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2095: END IF;
2096: ELSIF ( pTASKNUM= TASK_WO_SUB_COMP ) THEN
2097: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2098: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2099: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2100: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2101: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2102: 'MSC_CL_AHL_ODS_LOAD.LOAD_WO_SUB_COMP');
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2125: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2121: ELSIF ( pTASKNUM= TASK_CMRO_FORECAST_DEMANDS ) THEN
2122: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2123: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2124:
2125: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2126: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2127: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2128: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
2129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2142: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2138: ELSIF ( pTASKNUM= TASK_EAM_FORECAST_DEMANDS ) THEN
2139: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2140: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2141:
2142: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2143: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2144: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2145: 'MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECAST_DEMANDS ');
2146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2158: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2154: ELSIF ( pTASKNUM= TASK_CMRO_FORECAST_RR ) THEN
2155: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2156: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2157:
2158: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2159: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2160: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2161: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
2162: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2175: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2171: ELSIF ( pTASKNUM= TASK_EAM_FORECAST_RR ) THEN
2172: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2173: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2174:
2175: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2176: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2177: FND_MESSAGE.SET_TOKEN('PROCEDURE',
2178: 'MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECAST_RR ');
2179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 2216: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2212:
2213: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
2214: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
2215:
2216: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
2217: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
2218: 'Loading of OSP supplies done');
2219: ELSE
2220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 2543: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2539: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or
2540: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
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');

Line 2566: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2562: END IF;
2563:
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;

Line 2590: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2586: (v_coll_prec.mds_flag = MSC_UTIL.SYS_YES and v_coll_prec.mds_sn_flag <>MSC_UTIL.SYS_TGT)) AND
2587: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_NO or
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 ');

Line 2650: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

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
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;

Line 2673: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2669: (v_coll_prec.wip_flag = MSC_UTIL.SYS_YES) or
2670: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
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;

Line 2734: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2730: (v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES) or
2731: (v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES) ) THEN
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;

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

2800: (v_coll_prec.user_supply_demand_flag = MSC_UTIL.SYS_YES and v_coll_prec.usup_sn_flag = MSC_UTIL.SYS_INCR)
2801: then
2802:
2803: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2806: v_exchange_mode := MSC_UTIL.SYS_NO;
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2808: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

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

2803: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2806: v_exchange_mode := MSC_UTIL.SYS_NO;
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2808: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2810: end if;
2811:

Line 2808: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

2804: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2806: v_exchange_mode := MSC_UTIL.SYS_NO;
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2808: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2810: end if;
2811:
2812: -- now call load_staging_supply and load_ods_supply

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

2805: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2806: v_exchange_mode := MSC_UTIL.SYS_NO;
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2808: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2810: end if;
2811:
2812: -- now call load_staging_supply and load_ods_supply
2813: -- to collect the supply entities that are collected in

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

2826: (v_coll_prec.osp_supply = MSC_UTIL.SYS_YES) ) then
2827: -- Load Supply information from staging tables
2828: -- into the temp table.
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2833: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');

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

2828: -- into the temp table.
2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2833: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2835: -- Load Supply information from ODS table
2836: -- into the temp table.

Line 2833: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

2829: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2833: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2835: -- Load Supply information from ODS table
2836: -- into the temp table.
2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2832: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: before MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2833: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2835: -- Load Supply information from ODS table
2836: -- into the temp table.
2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

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

2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY ');
2835: -- Load Supply information from ODS table
2836: -- into the temp table.
2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');

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

2836: -- into the temp table.
2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2843:
2844: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

Line 2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2843:
2844: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');

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

2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2839: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2843:
2844: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2846: ELSE

Line 2844: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: befor MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2841: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2842: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY: after MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY ');
2843:
2844: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2845: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2846: ELSE
2847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
2848: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');

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

2853:
2854: end if; --- any one of the Supplies will be done Targeted
2855:
2856: ELSIF (v_is_incremental_refresh) then
2857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2858: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2861: 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 2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');

2855:
2856: ELSIF (v_is_incremental_refresh) then
2857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2858: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2862: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2863: 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 2861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');

2857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'ds debug: v_is_incremental_refresh MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2858: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2862: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2864: ELSE ---- Targeted Collections
2865: -- Load Supply information from staging tables

Line 2862: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;

2858: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2862: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2864: ELSE ---- Targeted Collections
2865: -- Load Supply information from staging tables
2866: -- into the temp table.

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

2859: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY');
2860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2861: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh before MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2862: MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY;
2863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2864: ELSE ---- Targeted Collections
2865: -- Load Supply information from staging tables
2866: -- into the temp table.
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

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

2863: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'PTASK_SUPPLY:v_is_incremental_refresh after MSC_CL_SUPPLY_ODS_LOAD.LOAD_SUPPLY ');
2864: ELSE ---- Targeted Collections
2865: -- Load Supply information from staging tables
2866: -- into the temp table.
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2868: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2870: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2871: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

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

2865: -- Load Supply information from staging tables
2866: -- into the temp table.
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2868: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2870: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2871: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2872: -- Load Supply information from ODS table
2873: -- into the temp table.

Line 2871: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;

2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'ds debug: Targetted MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2868: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2869: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY');
2870: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2871: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2872: -- Load Supply information from ODS table
2873: -- into the temp table.
2874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2875: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');

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

2871: MSC_CL_SUPPLY_ODS_LOAD.LOAD_STAGING_SUPPLY;
2872: -- Load Supply information from ODS table
2873: -- into the temp table.
2874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2875: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2876: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2877: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2878:
2879: /*added by raraghav*/

Line 2877: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;

2873: -- into the temp table.
2874: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2875: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY');
2876: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2877: MSC_CL_SUPPLY_ODS_LOAD.LOAD_ODS_SUPPLY;
2878:
2879: /*added by raraghav*/
2880:
2881: /* analyze msc_supplies here */

Line 2888: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

2884: --=============================================
2885: -- NCP:
2886: -- Create index in case of Partial refresh only
2887: -- ============================================
2888: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2889: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index creation on Temp Supplies table successful.');
2890: ELSE
2891: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
2892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');

Line 2944: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

2940: (v_coll_prec.supplier_response_flag = MSC_UTIL.SYS_YES) or
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);

Line 3155: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3151: END IF;
3152:
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;

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

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);
3225: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
3226:
3227: ELSIF pTASKNUM= PTASK_DELIVERY_DETAILS THEN

Line 3225: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;

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);
3225: MSC_CL_SUPPLY_ODS_LOAD.LOAD_PAYBACK_SUPPLIES;
3226:
3227: ELSIF pTASKNUM= PTASK_DELIVERY_DETAILS THEN
3228: IF (v_apps_ver >= MSC_UTIL.G_APPS120) THEN
3229: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3249: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3245: END IF;
3246:
3247: ELSIF pTASKNUM= PTASK_IRO_DEMAND THEN
3248: IF NOT(v_is_cont_refresh) THEN
3249: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3250: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3251: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND');
3252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3253: MSC_CL_RPO_ODS_LOAD.LOAD_IRO_DEMAND;

Line 3258: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3254: END IF;
3255: END IF;
3256: ELSIF pTASKNUM= PTASK_ERO_DEMAND THEN
3257: IF NOT(v_is_cont_refresh) THEN
3258: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3259: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3260: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND');
3261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3262: MSC_CL_RPO_ODS_LOAD.LOAD_ERO_DEMAND;

Line 3295: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3291: ELSIF ( pTASKNUM= PTASK_EAM_FORECAST ) THEN
3292: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3293: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3294:
3295: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3297: 'Loading of Eam forecasts done');
3298: ELSE
3299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 3309: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3305: ELSIF ( pTASKNUM= PTASK_EAM_FORECAST_DEMANDS ) THEN
3306: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3307: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3308:
3309: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3310: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3311: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3312: 'MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECAST_DEMANDS ');
3313: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 3325: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3321: ELSIF ( pTASKNUM= PTASK_EAM_FORECAST_RR ) THEN
3322: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3323: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3324:
3325: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3326: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3327: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3328: 'MSC_CL_EAM_ODS_LOAD.LOAD_EAM_FORECAST_RR ');
3329: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 3413: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3409: ELSIF ( pTASKNUM= PTASK_CMRO_FORECAST_DEMANDS ) THEN
3410: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3411: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3412:
3413: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3414: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3415: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3416: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_DEMANDS ');
3417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 3430: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3426: ELSIF ( pTASKNUM= PTASK_CMRO_FORECAST_RR ) THEN
3427: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3428: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3429:
3430: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3431: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3432: FND_MESSAGE.SET_TOKEN('PROCEDURE',
3433: 'MSC_CL_AHL_ODS_LOAD.LOAD_CMRO_FORECAST_RR ');
3434: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 3472: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN

3468:
3469: IF ( v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
3470: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
3471:
3472: IF MSC_CL_SUPPLY_ODS_LOAD.IS_SUPPLIES_LOAD_DONE THEN
3473: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
3474: 'Loading of OSP supplies done');
3475: ELSE
3476: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

Line 4791: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

4787: WHERE mai.INSTANCE_ID= v_instance_id;
4788: commit;
4789:
4790: IF (v_is_complete_refresh) THEN
4791: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
4792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index Dropping on Temp Supplies table successful.');
4793: ELSE
4794: ROLLBACK;
4795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

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 6656: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

6652: or (v_coll_prec.external_repair_flag = MSC_UTIL.SYS_YES )
6653: or (v_coll_prec.payback_demand_supply_flag = MSC_UTIL.SYS_YES )
6654: or (v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
6655: or (v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)) then
6656: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
6657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
6658: ELSE
6659: ROLLBACK;
6660: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

Line 6760: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

6756: (v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES) or
6757: (v_coll_prec.cmro_closed_wo = MSC_UTIL.SYS_YES) or
6758: (v_coll_prec.osp_supply = MSC_UTIL.SYS_YES)
6759: ) then
6760: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
6761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
6762: ELSE
6763: ROLLBACK;
6764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );

Line 6785: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN

6781: or (v_coll_prec.eam_forecasts_flag = MSC_UTIL.SYS_YES)
6782: or (v_coll_prec.cmro_forecasts_flag = MSC_UTIL.SYS_YES)
6783: or (v_coll_prec.cmro_closed_wo = MSC_UTIL.SYS_YES)
6784: or (v_coll_prec.osp_supply = MSC_UTIL.SYS_YES)) then
6785: IF MSC_CL_SUPPLY_ODS_LOAD.drop_supplies_tmp_ind THEN
6786: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ' Successfully Dropped the temp Index on Supplies table.' );
6787: ELSE
6788: ROLLBACK;
6789: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Failed in Dropping the temp Index on Supplies table.' );