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_ROUTING_ODS_LOAD dependencies on MSC_ROUTING_OPERATIONS

Line 1520: lv_tbl:= 'MSC_ROUTING_OPERATIONS';

1516:
1517: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1518: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1519: ELSE
1520: lv_tbl:= 'MSC_ROUTING_OPERATIONS';
1521: END IF;
1522:
1523: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1524: -- We want to delete all BOM related data and get new stuff

Line 1525: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1521: END IF;
1522:
1523: IF MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh THEN
1524: -- We want to delete all BOM related data and get new stuff
1525: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1526:
1527: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1528: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);

1525: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1526:
1527: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1528: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1530: ELSE
1531: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1532: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1533: END IF;

Line 1532: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1528: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1);
1530: ELSE
1531: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1532: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTING_OPERATIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1533: END IF;
1534: END IF;
1535:
1536: BEGIN

Line 1621: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1617:
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1619: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1620: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1621: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1623:
1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1625: RAISE;

Line 1631: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1627: ELSE
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1629: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1630: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1631: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1632: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1633:
1634: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1635:

Line 1722: DELETE MSC_ROUTING_OPERATIONS

1718:
1719: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1720: FOR c_rec IN c5_d LOOP
1721:
1722: DELETE MSC_ROUTING_OPERATIONS
1723: WHERE PLAN_ID= -1
1724: AND ROUTING_SEQUENCE_ID= NVL(c_rec.ROUTING_SEQUENCE_ID,ROUTING_SEQUENCE_ID)
1725: AND OPERATION_SEQUENCE_ID= NVL(c_rec.OPERATION_SEQUENCE_ID,OPERATION_SEQUENCE_ID)
1726: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line 1738: UPDATE MSC_ROUTING_OPERATIONS

1734:
1735: BEGIN
1736:
1737: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1738: UPDATE MSC_ROUTING_OPERATIONS
1739: SET
1740: OPERATION_SEQ_NUM= c_rec.OPERATION_SEQ_NUM,
1741: OPERATION_DESCRIPTION= c_rec.OPERATION_DESCRIPTION,
1742: EFFECTIVITY_DATE= c_rec.EFFECTIVITY_DATE,

Line 1824: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1820:
1821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1822: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1823: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1824: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1825: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1826:
1827: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1828: RAISE;

Line 1836: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');

1832:
1833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1834: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1835: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING_OPERATIONS');
1836: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTING_OPERATIONS');
1837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1838:
1839: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1840: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 1871: ||' SELECT * from MSC_ROUTING_OPERATIONS'

1867: lv_tbl:= 'ROUTING_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
1868:
1869: lv_sql_stmt:=
1870: 'INSERT INTO '||lv_tbl
1871: ||' SELECT * from MSC_ROUTING_OPERATIONS'
1872: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1873: ||' AND plan_id = -1 '
1874: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1875:

Line 1886: 'MSC_ROUTING_OPERATIONS',

1882:
1883: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1884: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1885: lv_retcode,
1886: 'MSC_ROUTING_OPERATIONS',
1887: MSC_CL_COLLECTION.v_instance_code,
1888: MSC_UTIL.G_WARNING
1889: );
1890: