eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_COLLECTION dependencies on MSC_CL_WIP_ODS_LOAD

Line 1458: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;

1454: set SUPPLIES_LOAD_FLAG = G_JOB_DONE
1455: where instance_id = v_instance_id;
1456: commit;
1457:
1458: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;
1459:
1460:
1461: ELSIF pTASKNUM= TASK_MDS_DEMAND THEN
1462:

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

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;
1487: ELSE
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_WIP_COMP_DEMAND');

Line 1486: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

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;
1487: ELSE
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_WIP_COMP_DEMAND');
1489: RAISE SUPPLIES_LOAD_FAIL;
1490: END IF;

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

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;
1511: ELSE
1512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. TASK_RES_REQ');

Line 1510: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

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;
1511: ELSE
1512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. TASK_RES_REQ');
1513: RAISE SUPPLIES_LOAD_FAIL;
1514: END IF;

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

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;
1853: ELSE
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_RES_INST_REQ');

Line 1852: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

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;
1853: ELSE
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed.TASK_RES_INST_REQ');
1855: RAISE SUPPLIES_LOAD_FAIL;
1856: END IF;

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

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;
2274: ELSE
2275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. PTASK_WIP_RES_REQ');

Line 2273: MSC_CL_WIP_ODS_LOAD.LOAD_RES_REQ;

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;
2274: ELSE
2275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Loading of Supplies failed. PTASK_WIP_RES_REQ');
2276: RAISE SUPPLIES_LOAD_FAIL;
2277: END IF;

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

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 ');
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2298: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

Line 2298: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;

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 ');
2297: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'or all the demands are incremental or None in this run. ');
2298: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
2299: ELSE
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.LOAD_WIP_DEMAND');
2301: RAISE SUPPLIES_LOAD_FAIL;
2302: END IF;

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

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;
2357: v_exchange_mode := MSC_UTIL.SYS_NO;
2358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_WIP_DEMAND From PTASK_ODS_DEMAND');

Line 2359: 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;
2357: v_exchange_mode := MSC_UTIL.SYS_NO;
2358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Calling Incremental LOAD_WIP_DEMAND From PTASK_ODS_DEMAND');
2359: MSC_CL_WIP_ODS_LOAD.LOAD_WIP_DEMAND;
2360: ELSE
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.LOAD_WIP_DEMAND');
2362: RAISE SUPPLIES_LOAD_FAIL;
2363: END IF;

Line 2575: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;

2571: END IF;
2572:
2573: END IF;
2574:
2575: MSC_CL_WIP_ODS_LOAD.LOAD_JOB_DETAILS;
2576:
2577: END IF;
2578:
2579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'after job_details.');

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

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;
2806: ELSE
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.PTASK_RES_INST_REQ');

Line 2805: MSC_CL_WIP_ODS_LOAD.LOAD_RES_INST_REQ;

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;
2806: ELSE
2807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Loading of Supplies failed.PTASK_RES_INST_REQ');
2808: RAISE SUPPLIES_LOAD_FAIL;
2809: END IF;