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_ITEM_ODS_LOAD

Line 1574: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');

1570:
1571: ELSIF pTASKNUM= TASK_ITEM THEN
1572:
1573: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1574: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1576: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
1577:
1578: /* as Supplier capacity is depenedent on item call load_supplier capacity

Line 1576: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;

1572:
1573: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1574: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1576: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
1577:
1578: /* as Supplier capacity is depenedent on item call load_supplier capacity
1579: after load_item (support for net change of ASL)*/
1580:

Line 1582: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');

1578: /* as Supplier capacity is depenedent on item call load_supplier capacity
1579: after load_item (support for net change of ASL)*/
1580:
1581: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1582: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
1583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1584: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1585:
1586: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1584: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

1580:
1581: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1582: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
1583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1584: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1585:
1586: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1587: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

Line 1594: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');

1590:
1591: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN
1592:
1593: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1594: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
1595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1596: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
1597:
1598: ELSIF pTASKNUM= TASK_RESOURCE THEN

Line 1596: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;

1592:
1593: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1594: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
1595: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1596: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
1597:
1598: ELSIF pTASKNUM= TASK_RESOURCE THEN
1599:
1600: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');

1693:
1694: ELSIF pTASKNUM= TASK_CATEGORY THEN
1695:
1696: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
1698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1699: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
1700:
1701: ELSIF pTASKNUM= TASK_BOM_COMPONENTS THEN

Line 1699: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;

1695:
1696: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1697: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
1698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1699: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
1700:
1701: ELSIF pTASKNUM= TASK_BOM_COMPONENTS THEN
1702:
1703: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1871: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');

1867:
1868: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN
1869:
1870: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1871: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
1872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1873: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
1874:
1875: END IF;

Line 1873: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;

1869:
1870: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1871: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
1872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1873: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
1874:
1875: END IF;
1876:
1877: ELSIF pTASKNUM= TASK_TRIP THEN

Line 2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');

2359:
2360: IF pTASKNUM= PTASK_SUPPLIER_CAPACITY THEN
2361: IF(prec.item_flag=MSC_UTIL.SYS_NO) THEN
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2364: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2365: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2366: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2367: END IF ;

Line 2365: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

2361: IF(prec.item_flag=MSC_UTIL.SYS_NO) THEN
2362: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2363: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2364: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2365: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2366: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2367: END IF ;
2368:
2369: ELSIF pTASKNUM= PTASK_ITEM THEN

Line 2372: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');

2368:
2369: ELSIF pTASKNUM= PTASK_ITEM THEN
2370:
2371: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2372: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
2373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2374: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
2375:
2376: /* for bug 5233688 */

Line 2374: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;

2370:
2371: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2372: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
2373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2374: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
2375:
2376: /* for bug 5233688 */
2377: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2378: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');

2375:
2376: /* for bug 5233688 */
2377: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2378: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2381: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2382: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2383: END IF ;

Line 2381: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

2377: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2378: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2381: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2382: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2383: END IF ;
2384:
2385: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN

Line 2388: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');

2384:
2385: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN
2386:
2387: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2388: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
2389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2390: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
2391:
2392: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN

Line 2390: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;

2386:
2387: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2388: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
2389: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2390: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
2391:
2392: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN
2393:
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');

2391:
2392: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN
2393:
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
2396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2397: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
2398:
2399: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN

Line 2397: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;

2393:
2394: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2395: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
2396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2397: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
2398:
2399: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN
2400:
2401: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

Line 3115: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');

3111: ELSIF pTASKNUM = PTASK_ITEM_SUBSTITUTES THEN
3112:
3113: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3114: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3115: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3117: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
3118: END IF;
3119:

Line 3117: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;

3113: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
3114: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3115: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
3116: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3117: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
3118: END IF;
3119:
3120: ELSIF pTASKNUM= PTASK_ITEM_CUSTOMERS THEN
3121:

Line 4952: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;

4948: END IF;
4949: END IF;
4950:
4951: IF ( v_coll_prec.item_flag = MSC_UTIL.SYS_YES or v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN
4952: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;
4953: END IF;
4954:
4955: IF (v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
4956: IF ( v_coll_prec.eam_info_flag = MSC_UTIL.SYS_YES OR v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN

Line 6899: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;

6895:
6896: END IF;
6897:
6898: IF ( v_coll_prec.item_flag = MSC_UTIL.SYS_YES or v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN
6899: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;
6900: END IF;
6901:
6902: IF (v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' ) THEN
6903:

Line 7558: /* After Splitting GENERATE_ITEM_KEYS is placed in MSC_CL_ITEM_ODS_LOAD package . This is a wrapper for the same.*/

7554: pSTART_DATE ) ;
7555:
7556:
7557: END COMPUTE_RES_AVAIL;
7558: /* After Splitting GENERATE_ITEM_KEYS is placed in MSC_CL_ITEM_ODS_LOAD package . This is a wrapper for the same.*/
7559:
7560: PROCEDURE GENERATE_ITEM_KEYS (
7561: ERRBUF OUT NOCOPY VARCHAR2,
7562: RETCODE OUT NOCOPY NUMBER,

Line 7566: MSC_CL_ITEM_ODS_LOAD.GENERATE_ITEM_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);

7562: RETCODE OUT NOCOPY NUMBER,
7563: pINSTANCE_ID IN NUMBER) IS
7564: BEGIN
7565:
7566: MSC_CL_ITEM_ODS_LOAD.GENERATE_ITEM_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);
7567:
7568: END GENERATE_ITEM_KEYS;
7569:
7570: PROCEDURE GENERATE_TRADING_PARTNER_KEYS (ERRBUF OUT NOCOPY VARCHAR2,