DBA Data[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 446: MTL_INTERFACE_ERRORS

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

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

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

Line 928: INSERT INTO mtl_interface_errors

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

Line 1009: MTL_INTERFACE_ERRORS

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

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

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

Line 1207: INSERT INTO mtl_interface_errors

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

Line 1286: MTL_INTERFACE_ERRORS

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

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

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

Line 1483: INSERT INTO mtl_interface_errors

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

Line 1562: MTL_INTERFACE_ERRORS

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

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

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

Line 1754: INSERT INTO mtl_interface_errors

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

Line 1833: MTL_INTERFACE_ERRORS

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

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

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

Line 1968: INSERT INTO MTL_INTERFACE_ERRORS

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