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 1122: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ITEM_CATEGORIES', MSC_CL_COLLECTION.v_instance_id, NULL);

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

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

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

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

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

Line 1137: lv_tbl:= 'MSC_ITEM_CATEGORIES';

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

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

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

Line 1211: DELETE FROM MSC_ITEM_CATEGORIES

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

Line 1308: UPDATE MSC_ITEM_CATEGORIES

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

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

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

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

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

Line 1427: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_ITEM_CATEGORIES'

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

Line 1441: 'MSC_ITEM_CATEGORIES',

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