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_ITEM_ODS_LOAD dependencies on MSC_ITEM_CATEGORIES

Line 1119: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);

1115: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1116: -- We want to delete all CATEGORY related data and get new stuff.
1117:
1118: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
1119: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1120:
1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1123: ELSE

Line 1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);

1118: if (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO) then
1119: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1120:
1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1123: ELSE
1124: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL,v_sub_str);
1126: END IF;

Line 1125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL,v_sub_str);

1121: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1122: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);
1123: ELSE
1124: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1125: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL,v_sub_str);
1126: END IF;
1127: end if;
1128:
1129: END IF;

Line 1134: lv_tbl:= 'MSC_ITEM_CATEGORIES';

1130:
1131: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1132: lv_tbl:= 'ITEM_CATEGORIES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
1133: ELSE
1134: lv_tbl:= 'MSC_ITEM_CATEGORIES';
1135: END IF;
1136:
1137: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1138:

Line 1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1196: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1197: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1198: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1202: RAISE;

Line 1208: DELETE FROM MSC_ITEM_CATEGORIES

1204: END;
1205: ELSE
1206: FOR c_rec IN c1_d LOOP
1207:
1208: DELETE FROM MSC_ITEM_CATEGORIES
1209: WHERE ORGANIZATION_ID= c_rec.ORGANIZATION_ID
1210: AND INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID
1211: AND CATEGORY_SET_ID= c_rec.CATEGORY_SET_ID
1212: AND SR_CATEGORY_ID= c_rec.SR_CATEGORY_ID

Line 1305: UPDATE MSC_ITEM_CATEGORIES

1301: BEGIN
1302:
1303: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1304:
1305: UPDATE MSC_ITEM_CATEGORIES
1306: SET
1307: CATEGORY_NAME = lb_category_name(j),
1308: DESCRIPTION = lb_description(j),
1309: DISABLE_DATE = lb_disable_date(j),

Line 1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1367:
1368: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1369: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1370: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1371: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1373:
1374: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1375: RAISE;

Line 1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');

1380:
1381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1383: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CATEGORY');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ITEM_CATEGORIES');
1385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1386:
1387: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1388: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');

Line 1424: ||' SELECT * from MSC_ITEM_CATEGORIES'

1420: lv_tbl:= 'ITEM_CATEGORIES_'||MSC_CL_COLLECTION.v_INSTANCE_CODE;
1421:
1422: lv_sql_stmt:=
1423: 'INSERT INTO '||lv_tbl
1424: ||' SELECT * from MSC_ITEM_CATEGORIES'
1425: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1426: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1427:
1428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

Line 1438: 'MSC_ITEM_CATEGORIES',

1434:
1435: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1436: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1437: lv_retcode,
1438: 'MSC_ITEM_CATEGORIES',
1439: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1440: MSC_UTIL.G_ERROR
1441: );
1442: