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 1533: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');

1529:
1530: ELSIF pTASKNUM= TASK_ITEM THEN
1531:
1532: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1533: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
1534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1535: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
1536:
1537: /* as Supplier capacity is depenedent on item call load_supplier capacity

Line 1535: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;

1531:
1532: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1533: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
1534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1535: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
1536:
1537: /* as Supplier capacity is depenedent on item call load_supplier capacity
1538: after load_item (support for net change of ASL)*/
1539:

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

1537: /* as Supplier capacity is depenedent on item call load_supplier capacity
1538: after load_item (support for net change of ASL)*/
1539:
1540: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1541: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
1542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1543: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1544:
1545: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

Line 1543: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

1539:
1540: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1541: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
1542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1543: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
1544:
1545: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1546: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT');
1547: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);

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

1549:
1550: ELSIF pTASKNUM= TASK_ABC_CLASSES THEN
1551:
1552: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1553: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
1554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1555: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
1556:
1557: ELSIF pTASKNUM= TASK_RESOURCE THEN

Line 1555: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;

1551:
1552: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1553: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
1554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1555: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
1556:
1557: ELSIF pTASKNUM= TASK_RESOURCE THEN
1558:
1559: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

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

1652:
1653: ELSIF pTASKNUM= TASK_CATEGORY THEN
1654:
1655: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1656: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
1657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1658: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
1659:
1660: ELSIF pTASKNUM= TASK_BOM_COMPONENTS THEN

Line 1658: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;

1654:
1655: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1656: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
1657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1658: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
1659:
1660: ELSIF pTASKNUM= TASK_BOM_COMPONENTS THEN
1661:
1662: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

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

1826:
1827: IF (v_apps_ver >= MSC_UTIL.G_APPS115) OR v_is_legacy_refresh THEN
1828:
1829: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1832: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
1833:
1834: END IF;

Line 1832: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;

1828:
1829: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1830: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
1831: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1832: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
1833:
1834: END IF;
1835:
1836: ELSIF pTASKNUM= TASK_TRIP THEN

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

2062:
2063: IF pTASKNUM= PTASK_SUPPLIER_CAPACITY THEN
2064: IF(prec.item_flag=MSC_UTIL.SYS_NO) THEN
2065: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2068: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2069: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2070: END IF ;

Line 2068: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

2064: IF(prec.item_flag=MSC_UTIL.SYS_NO) THEN
2065: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2066: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2068: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2069: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2070: END IF ;
2071:
2072: ELSIF pTASKNUM= PTASK_ITEM THEN

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

2071:
2072: ELSIF pTASKNUM= PTASK_ITEM THEN
2073:
2074: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2075: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2077: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
2078:
2079: /* for bug 5233688 */

Line 2077: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;

2073:
2074: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2075: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM');
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2077: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM;
2078:
2079: /* for bug 5233688 */
2080: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2081: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2078:
2079: /* for bug 5233688 */
2080: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2081: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2084: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2085: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2086: END IF ;

Line 2084: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;

2080: IF(prec.app_supp_cap_flag=MSC_UTIL.SYS_YES or prec.app_supp_cap_flag=MSC_UTIL.ASL_YES_RETAIN_CP) THEN
2081: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY');
2083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2084: MSC_CL_ITEM_ODS_LOAD.LOAD_SUPPLIER_CAPACITY;
2085: MSC_CL_SETUP_ODS_LOAD.CLEAN_LIAB_AGREEMENT ;
2086: END IF ;
2087:
2088: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN

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

2087:
2088: ELSIF pTASKNUM= PTASK_ABC_CLASSES THEN
2089:
2090: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2091: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2093: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
2094:
2095: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN

Line 2093: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;

2089:
2090: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2091: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES');
2092: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2093: MSC_CL_ITEM_ODS_LOAD.LOAD_ABC_CLASSES;
2094:
2095: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN
2096:
2097: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2094:
2095: ELSIF pTASKNUM= PTASK_CATEGORY_ITEM THEN
2096:
2097: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2098: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2100: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
2101:
2102: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN

Line 2100: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;

2096:
2097: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2098: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY');
2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2100: MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY;
2101:
2102: ELSIF pTASKNUM= PTASK_TRADING_PARTNER THEN
2103:
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');

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

2757: ELSIF pTASKNUM = PTASK_ITEM_SUBSTITUTES THEN
2758:
2759: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
2760: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2761: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
2762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2763: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
2764: END IF;
2765:

Line 2763: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;

2759: IF v_apps_ver <> MSC_UTIL.G_APPS107 THEN
2760: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2761: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES');
2762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2763: MSC_CL_ITEM_ODS_LOAD.LOAD_ITEM_SUBSTITUTES;
2764: END IF;
2765:
2766: ELSIF pTASKNUM= PTASK_ITEM_CUSTOMERS THEN
2767:

Line 4323: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;

4319: END IF;
4320: END IF;
4321:
4322: IF ( v_coll_prec.item_flag = MSC_UTIL.SYS_YES or v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN
4323: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;
4324: END IF;
4325:
4326: UPDATE MSC_APPS_INSTANCES
4327: SET so_tbl_status= MSC_UTIL.SYS_YES

Line 6088: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;

6084: END IF;
6085: END IF;
6086:
6087: IF ( v_coll_prec.item_flag = MSC_UTIL.SYS_YES or v_coll_prec.bom_flag = MSC_UTIL.SYS_YES ) THEN
6088: MSC_CL_ITEM_ODS_LOAD.UPDATE_LEADTIME;
6089: END IF;
6090:
6091: IF (v_req_ext_po_so_linking) Then
6092: IF ( v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN

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

6679: pSTART_DATE ) ;
6680:
6681:
6682: END COMPUTE_RES_AVAIL;
6683: /* After Splitting GENERATE_ITEM_KEYS is placed in MSC_CL_ITEM_ODS_LOAD package . This is a wrapper for the same.*/
6684:
6685: PROCEDURE GENERATE_ITEM_KEYS (
6686: ERRBUF OUT NOCOPY VARCHAR2,
6687: RETCODE OUT NOCOPY NUMBER,

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

6687: RETCODE OUT NOCOPY NUMBER,
6688: pINSTANCE_ID IN NUMBER) IS
6689: BEGIN
6690:
6691: MSC_CL_ITEM_ODS_LOAD.GENERATE_ITEM_KEYS (ERRBUF,RETCODE,pINSTANCE_ID);
6692:
6693: END GENERATE_ITEM_KEYS;
6694:
6695: PROCEDURE GENERATE_TRADING_PARTNER_KEYS (ERRBUF OUT NOCOPY VARCHAR2,