42: X_implementation_date);
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_RTG_ITEM_REVISIONS',
47: stmt_num => 1000,
48: message_name => 'ENG_ENUBRT_ERROR',
49: token => SQLERRM);
50:
132:
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_REVISIONS',
137: stmt_num => 1001,
138: message_name => 'ENG_ENUBRT_ERROR',
139: token => SQLERRM);
140:
960: and T.ORGANIZATION_ID = X_master_org
961: and T.LANGUAGE = L.LANGUAGE_CODE );
962: EXCEPTION
963: WHEN OTHERS THEN
964: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SYSTEM_ITEMS',
965: stmt_num => 1002,
966: message_name => 'ENG_ENUBRT_ERROR',
967: token => SQLERRM);
968:
1012: AND ORGANIZATION_ID = X_org_id;
1013:
1014: EXCEPTION
1015: WHEN OTHERS THEN
1016: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_CATEGORIES',
1017: stmt_num => 1003,
1018: message_name => 'ENG_ENUBRT_ERROR',
1019: token => SQLERRM);
1020:
1066: WHERE INVENTORY_ITEM_ID = X_eng_item_id;
1067:
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_DESCR_ELEMENT_VALUES',
1071: stmt_num => 1004,
1072: message_name => 'ENG_ENUBRT_ERROR',
1073: token => SQLERRM);
1074:
1121: AND ORGANIZATION_ID = X_org_id;
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_RELATED_ITEMS',
1126: stmt_num => 1005,
1127: message_name => 'ENG_ENUBRT_ERROR',
1128: token => SQLERRM);
1129:
1256: AND ORGANIZATION_ID = X_org_id;
1257:
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ITEM_COSTS',
1261: stmt_num => 1006,
1262: message_name => 'ENG_ENUBRT_ERROR',
1263: token => SQLERRM);
1264:
1377: AND ORGANIZATION_ID = X_org_id;
1378:
1379: EXCEPTION
1380: WHEN OTHERS THEN
1381: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ITEM_COST_DETAILS',
1382: stmt_num => 1007,
1383: message_name => 'ENG_ENUBRT_ERROR',
1384: token => SQLERRM);
1385:
1490: AND ORGANIZATION_ID = X_master_org;-- Bug:3264573 X_org_id;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_ITEM_SUB_INVENTORIES',
1495: stmt_num => 1008,
1496: message_name => 'ENG_ENUBRT_ERROR',
1497: token => SQLERRM);
1498:
1547: AND ORGANIZATION_ID = X_master_org; --Bug:3264573 X_org_id;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_SECONDARY_LOCATORS',
1552: stmt_num => 1009,
1553: message_name => 'ENG_ENUBRT_ERROR',
1554: token => SQLERRM);
1555:
1708: AND ORGANIZATION_ID = X_org_id;
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_MTL_PENDING_ITEM_STATUS',
1713: stmt_num => 1011,
1714: message_name => 'ENG_ENUBRT_ERROR',
1715: token => SQLERRM);
1716:
1777: AND ORGANIZATION_ID = X_org_id;
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',
1782: stmt_num => 1012,
1783: message_name => 'ENG_ENUBRT_ERROR',
1784: token => SQLERRM);
1785:
1832: AND ORGANIZATION_ID = X_org_id;
1833:
1834: EXCEPTION
1835: WHEN OTHERS THEN
1836: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_ELEMENTAL_COSTS',
1837: stmt_num => 1013,
1838: message_name => 'ENG_ENUBRT_ERROR',
1839: token => SQLERRM);
1840: