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.BOM_OPEN_INTERFACE_UTL dependencies on MTL_INTERFACE_ERRORS

Line 33: MTL_INTERFACE_ERRORS

29: REQUIRES
30:
31: MODIFIES
32: BOM_BILL_OF_MTLS_INTERFACE
33: MTL_INTERFACE_ERRORS
34: RETURNS
35: 0 if successful
36: SQLCODE if unsuccessful
37: NOTES

Line 416: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/

412: COMMIT;
413: stmt_num := 11;
414:
415: /* Update the interface records with process_flag 3 and insert into
416: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/
417:
418: l_sysdate := SYSDATE;
419: msg_name1 := 'BOM_ORG_ID_MISSING';
420: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 426: INSERT INTO MTL_INTERFACE_ERRORS

422: msg_text1 := FND_MESSAGE.GET;
423: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
424: msg_text2 := FND_MESSAGE.GET;
425:
426: INSERT INTO MTL_INTERFACE_ERRORS
427: (
428: TRANSACTION_ID,
429: UNIQUE_ID,
430: ORGANIZATION_ID,

Line 510: MTL_INTERFACE_ERRORS

506: REQUIRES
507:
508: MODIFIES
509: BOM_INVENTORY_COMPS_INTERFACE
510: MTL_INTERFACE_ERRORS
511: RETURNS
512: 0 if successful
513: SQLCODE if unsuccessful
514: NOTES

Line 996: mtl_interface_errors if Item_number or Organization_code is missing*/

992:
993: stmt_num := 11;
994:
995: /* Update the interface records with process_flag 3 and insert into
996: mtl_interface_errors if Item_number or Organization_code is missing*/
997:
998: l_sysdate := SYSDATE;
999: msg_name1 := 'BOM_ORG_ID_MISSING';
1000: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 1005: INSERT INTO mtl_interface_errors

1001: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1002: msg_text1 := FND_MESSAGE.GET;
1003: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1004: msg_text2 := FND_MESSAGE.GET;
1005: INSERT INTO mtl_interface_errors
1006: (
1007: TRANSACTION_ID,
1008: UNIQUE_ID,
1009: ORGANIZATION_ID,

Line 1091: MTL_INTERFACE_ERRORS

1087: REQUIRES
1088:
1089: MODIFIES
1090: BOM_REF_DESGS_INTERFACE
1091: MTL_INTERFACE_ERRORS
1092: RETURNS
1093: 0 if successful
1094: SQLCODE if unsuccessful
1095: NOTES

Line 1280: mtl_interface_errors if Item_number or Organization_code is missing*/

1276: COMMIT;
1277:
1278: stmt_num := 8;
1279: /* Update the interface records with process_flag 3 and insert into
1280: mtl_interface_errors if Item_number or Organization_code is missing*/
1281:
1282: l_sysdate := SYSDATE;
1283: msg_name1 := 'BOM_ORG_ID_MISSING';
1284: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 1289: INSERT INTO mtl_interface_errors

1285: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1286: msg_text1 := FND_MESSAGE.GET;
1287: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1288: msg_text2 := FND_MESSAGE.GET;
1289: INSERT INTO mtl_interface_errors
1290: (
1291: TRANSACTION_ID,
1292: UNIQUE_ID,
1293: ORGANIZATION_ID,

Line 1370: MTL_INTERFACE_ERRORS

1366: REQUIRES
1367:
1368: MODIFIES
1369: BOM_SUB_COMPS_INTERFACE
1370: MTL_INTERFACE_ERRORS
1371: RETURNS
1372: 0 if successful
1373: SQLCODE if unsuccessful
1374: NOTES

Line 1606: mtl_interface_errors if Item_number or Organization_code is missing*/

1602:
1603: COMMIT;
1604: stmt_num := 10;
1605: /* Update the interface records with process_flag 3 and insert into
1606: mtl_interface_errors if Item_number or Organization_code is missing*/
1607:
1608: l_sysdate := SYSDATE;
1609: msg_name1 := 'BOM_ORG_ID_MISSING';
1610: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 1615: INSERT INTO mtl_interface_errors

1611: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1612: msg_text1 := FND_MESSAGE.GET;
1613: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1614: msg_text2 := FND_MESSAGE.GET;
1615: INSERT INTO mtl_interface_errors
1616: (
1617: TRANSACTION_ID,
1618: UNIQUE_ID,
1619: ORGANIZATION_ID,

Line 1697: MTL_INTERFACE_ERRORS

1693: REQUIRES
1694:
1695: MODIFIES
1696: BOM_COMPONENT_OPS_INTERFACE
1697: MTL_INTERFACE_ERRORS
1698: RETURNS
1699: 0 if successful
1700: SQLCODE if unsuccessful
1701: NOTES

Line 1880: mtl_interface_errors if Item_number or Organization_code is missing*/

1876: COMMIT;
1877:
1878: stmt_num := 9;
1879: /* Update the interface records with process_flag 3 and insert into
1880: mtl_interface_errors if Item_number or Organization_code is missing*/
1881:
1882: l_sysdate := SYSDATE;
1883: msg_name1 := 'BOM_ORG_ID_MISSING';
1884: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 1889: INSERT INTO mtl_interface_errors

1885: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1886: msg_text1 := FND_MESSAGE.GET;
1887: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1888: msg_text2 := FND_MESSAGE.GET;
1889: INSERT INTO mtl_interface_errors
1890: (
1891: TRANSACTION_ID,
1892: UNIQUE_ID,
1893: ORGANIZATION_ID,

Line 2060: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/

2056: COMMIT;
2057: stmt_num := 6;
2058:
2059: /* Update the interface records with process_flag 3 and insert into
2060: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/
2061:
2062: l_sysdate := SYSDATE;
2063: msg_name1 := 'BOM_ORG_ID_MISSING';
2064: msg_name2 := 'BOM_ASSY_ITEM_MISSING';

Line 2070: INSERT INTO MTL_INTERFACE_ERRORS

2066: msg_text1 := FND_MESSAGE.GET;
2067: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
2068: msg_text2 := FND_MESSAGE.GET;
2069:
2070: INSERT INTO MTL_INTERFACE_ERRORS
2071: (
2072: TRANSACTION_ID,
2073: UNIQUE_ID,
2074: ORGANIZATION_ID,