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.

[Home] [Help]

APPS.BOM_RTG_OI_UTIL dependencies on MTL_INTERFACE_ERRORS

Line 41: MTL_INTERFACE_ERRORS

37: REQUIRES
38:
39: MODIFIES
40: BOM_OP_ROUTINGS_INTERFACE
41: MTL_INTERFACE_ERRORS
42: RETURNS
43: 0 if successful
44: SQLCODE if unsuccessful
45: NOTES

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

349: COMMIT;
350: stmt_num := 12;
351:
352: /* Update the interface records with process_flag 3 and insert into
353: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/
354:
355: msg_name1 := 'BOM_ORG_ID_MISSING';
356: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
357: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 362: INSERT INTO MTL_INTERFACE_ERRORS

358: msg_text1 := FND_MESSAGE.GET;
359: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
360: msg_text2 := FND_MESSAGE.GET;
361:
362: INSERT INTO MTL_INTERFACE_ERRORS
363: (
364: TRANSACTION_ID,
365: UNIQUE_ID,
366: ORGANIZATION_ID,

Line 444: MTL_INTERFACE_ERRORS

440: REQUIRES
441:
442: MODIFIES
443: BOM_OP_SEQUENCES_INTERFACE
444: MTL_INTERFACE_ERRORS
445: RETURNS
446: 0 if successful
447: SQLCODE if unsuccessful
448: NOTES

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

914:
915: stmt_num := 11;
916:
917: /* Update the interface records with process_flag 3 and insert into
918: mtl_interface_errors if Item_number or Organization_code is missing*/
919:
920: msg_name1 := 'BOM_ORG_ID_MISSING';
921: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
922: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 926: INSERT INTO mtl_interface_errors

922: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
923: msg_text1 := FND_MESSAGE.GET;
924: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
925: msg_text2 := FND_MESSAGE.GET;
926: INSERT INTO mtl_interface_errors
927: (
928: TRANSACTION_ID,
929: UNIQUE_ID,
930: ORGANIZATION_ID,

Line 1007: MTL_INTERFACE_ERRORS

1003: REQUIRES
1004:
1005: MODIFIES
1006: BOM_OP_RESOURCES_INTERFACE
1007: MTL_INTERFACE_ERRORS
1008: RETURNS
1009: 0 if successful
1010: SQLCODE if unsuccessful
1011: NOTES

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

1193: COMMIT;
1194:
1195: stmt_num := 8;
1196: /* Update the interface records with process_flag 3 and insert into
1197: mtl_interface_errors if Item_number or Organization_code is missing*/
1198:
1199: msg_name1 := 'BOM_ORG_ID_MISSING';
1200: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
1201: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 1205: INSERT INTO mtl_interface_errors

1201: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1202: msg_text1 := FND_MESSAGE.GET;
1203: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1204: msg_text2 := FND_MESSAGE.GET;
1205: INSERT INTO mtl_interface_errors
1206: (
1207: TRANSACTION_ID,
1208: UNIQUE_ID,
1209: ORGANIZATION_ID,

Line 1284: MTL_INTERFACE_ERRORS

1280: REQUIRES
1281:
1282: MODIFIES
1283: BOM_SUB_OP_RESOURCES_INTERFACE
1284: MTL_INTERFACE_ERRORS
1285: RETURNS
1286: 0 if successful
1287: SQLCODE if unsuccessful
1288: NOTES

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

1469:
1470: COMMIT;
1471: stmt_num := 8;
1472: /* Update the interface records with process_flag 3 and insert into
1473: mtl_interface_errors if Item_number or Organization_code is missing*/
1474:
1475: msg_name1 := 'BOM_ORG_ID_MISSING';
1476: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
1477: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 1481: INSERT INTO mtl_interface_errors

1477: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1478: msg_text1 := FND_MESSAGE.GET;
1479: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1480: msg_text2 := FND_MESSAGE.GET;
1481: INSERT INTO mtl_interface_errors
1482: (
1483: TRANSACTION_ID,
1484: UNIQUE_ID,
1485: ORGANIZATION_ID,

Line 1560: MTL_INTERFACE_ERRORS

1556: REQUIRES
1557:
1558: MODIFIES
1559: BOM_OP_NETWORKS_INTERFACE
1560: MTL_INTERFACE_ERRORS
1561: RETURNS
1562: 0 if successful
1563: SQLCODE if unsuccessful
1564: NOTES

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

1740: COMMIT;
1741:
1742: stmt_num := 7;
1743: /* Update the interface records with process_flag 3 and insert into
1744: mtl_interface_errors if Item_number or Organization_code is missing*/
1745:
1746: msg_name1 := 'BOM_ORG_ID_MISSING';
1747: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
1748: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 1752: INSERT INTO mtl_interface_errors

1748: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');
1749: msg_text1 := FND_MESSAGE.GET;
1750: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1751: msg_text2 := FND_MESSAGE.GET;
1752: INSERT INTO mtl_interface_errors
1753: (
1754: TRANSACTION_ID,
1755: UNIQUE_ID,
1756: ORGANIZATION_ID,

Line 1831: MTL_INTERFACE_ERRORS

1827: REQUIRES
1828:
1829: MODIFIES
1830: MTL_RTG_ITEM_REVS_INTERFACE
1831: MTL_INTERFACE_ERRORS
1832: RETURNS
1833: 0 if successful
1834: SQLCODE if unsuccessful
1835: NOTES

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

1953: COMMIT;
1954: stmt_num := 5;
1955:
1956: /* Update the interface records with process_flag 3 and insert into
1957: MTL_INTERFACE_ERRORS if Item number or Organization_code is missing*/
1958:
1959: msg_name1 := 'BOM_ORG_ID_MISSING';
1960: msg_name2 := 'BOM_ASSY_ITEM_MISSING';
1961: FND_MESSAGE.SET_NAME('BOM', 'BOM_ORG_ID_MISSING');

Line 1966: INSERT INTO MTL_INTERFACE_ERRORS

1962: msg_text1 := FND_MESSAGE.GET;
1963: FND_MESSAGE.SET_NAME('BOM', 'BOM_ASSY_ITEM_MISSING');
1964: msg_text2 := FND_MESSAGE.GET;
1965:
1966: INSERT INTO MTL_INTERFACE_ERRORS
1967: (
1968: TRANSACTION_ID,
1969: UNIQUE_ID,
1970: ORGANIZATION_ID,