136: , msii.CREATE_SUPPLY_FLAG
137: , msii.SUBSTITUTION_WINDOW_CODE
138: , msii.SUBSTITUTION_WINDOW_DAYS
139: FROM
140: MTL_SYSTEM_ITEMS_INTERFACE msii
141: , MTL_PARAMETERS mp
142: WHERE
143: ( (msii.organization_id = org_id) OR (all_Org = 1) )
144: AND msii.process_flag = 2
683: request_id,
684: cr.TRANSACTION_ID,
685: error_msg,
686: 'MASTER_CHILD_1A',
687: 'MTL_SYSTEM_ITEMS_INTERFACE',
688: 'INV_IOI_MASTER_CHILD_1A',
689: err_text);
690: If dumm_status < 0 then
691: raise LOGGING_ERR ;
689: err_text);
690: If dumm_status < 0 then
691: raise LOGGING_ERR ;
692: End If;
693: update mtl_system_items_interface msii
694: set process_flag = 3
695: where msii.transaction_id = cr.transaction_id;
696:
697: end; /* MASTER_CHILD_1A */
719: request_id,
720: cr.TRANSACTION_ID,
721: error_msg,
722: 'MASTER_CHILD_1C',
723: 'MTL_SYSTEM_ITEMS_INTERFACE',
724: 'INV_IOI_MASTER_CHILD_1C',
725: err_text);
726: If dumm_status < 0 then
727: raise LOGGING_ERR ;
725: err_text);
726: If dumm_status < 0 then
727: raise LOGGING_ERR ;
728: End If;
729: update mtl_system_items_interface msii
730: set process_flag = 3
731: where msii.transaction_id = cr.transaction_id;
732:
733: end; /* MASTER_CHILD_1C */
767: request_id,
768: cr.TRANSACTION_ID,
769: error_msg,
770: 'MASTER_CHILD_1B',
771: 'MTL_SYSTEM_ITEMS_INTERFACE',
772: 'INV_IOI_MASTER_CHILD_1B',
773: err_text);
774:
775: If dumm_status < 0 then
775: If dumm_status < 0 then
776: raise LOGGING_ERR ;
777: End If;
778:
779: update mtl_system_items_interface msii
780: set process_flag = 3
781: where msii.transaction_id = cr.transaction_id;
782:
783: end; /* MASTER_CHILD_1B */
813: request_id,
814: cr.TRANSACTION_ID,
815: error_msg,
816: 'MASTER_CHILD_1D',
817: 'MTL_SYSTEM_ITEMS_INTERFACE',
818: 'INV_IOI_MASTER_CHILD_1D',
819: err_text);
820: If dumm_status < 0 then
821: raise LOGGING_ERR ;
819: err_text);
820: If dumm_status < 0 then
821: raise LOGGING_ERR ;
822: End If;
823: update mtl_system_items_interface msii
824: set process_flag = 3
825: where msii.transaction_id = cr.transaction_id;
826:
827: end; /* MASTER_CHILD_1D */
853: request_id,
854: cr.TRANSACTION_ID,
855: error_msg,
856: 'MASTER_CHILD_1E',
857: 'MTL_SYSTEM_ITEMS_INTERFACE',
858: 'INV_IOI_MASTER_CHILD_1E',
859: err_text);
860: If dumm_status < 0 then
861: raise LOGGING_ERR ;
859: err_text);
860: If dumm_status < 0 then
861: raise LOGGING_ERR ;
862: End If;
863: update mtl_system_items_interface msii
864: set process_flag = 3
865: where msii.transaction_id = cr.transaction_id;
866:
867: end; /* MASTER_CHILD_1E */
889: request_id,
890: cr.TRANSACTION_ID,
891: error_msg,
892: 'MASTER_CHILD_1F',
893: 'MTL_SYSTEM_ITEMS_INTERFACE',
894: 'INV_IOI_MASTER_CHILD_1F',
895: err_text);
896: If dumm_status < 0 then
897: raise LOGGING_ERR ;
895: err_text);
896: If dumm_status < 0 then
897: raise LOGGING_ERR ;
898: End If;
899: update mtl_system_items_interface msii
900: set process_flag = 3
901: where msii.transaction_id = cr.transaction_id;
902:
903: end; /* MASTER_CHILD_1F */
933: request_id,
934: cr.TRANSACTION_ID,
935: error_msg,
936: 'MASTER_CHILD_1G',
937: 'MTL_SYSTEM_ITEMS_INTERFACE',
938: 'INV_IOI_MASTER_CHILD_1G',
939: err_text);
940: If dumm_status < 0 then
941: raise LOGGING_ERR ;
939: err_text);
940: If dumm_status < 0 then
941: raise LOGGING_ERR ;
942: End If;
943: update mtl_system_items_interface msii
944: set process_flag = 3
945: where msii.transaction_id = cr.transaction_id;
946:
947: end; /* MASTER_CHILD_1G */
987: request_id,
988: cr.TRANSACTION_ID,
989: error_msg,
990: 'MASTER_CHILD_1HA',
991: 'MTL_SYSTEM_ITEMS_INTERFACE',
992: 'INV_IOI_MASTER_CHILD_1HA',
993: err_text );
994:
995: IF dumm_status < 0 THEN
995: IF dumm_status < 0 THEN
996: raise LOGGING_ERR ;
997: END IF;
998:
999: update mtl_system_items_interface msii
1000: set process_flag = 3
1001: where msii.transaction_id = cr.transaction_id;
1002:
1003: END; /* MASTER_CHILD_1HA */
1047: request_id,
1048: cr.TRANSACTION_ID,
1049: error_msg,
1050: 'MASTER_CHILD_1HB',
1051: 'MTL_SYSTEM_ITEMS_INTERFACE',
1052: 'INV_IOI_MASTER_CHILD_1HB',
1053: err_text );
1054:
1055: IF dumm_status < 0 THEN
1055: IF dumm_status < 0 THEN
1056: raise LOGGING_ERR ;
1057: END IF;
1058:
1059: update mtl_system_items_interface msii
1060: set process_flag = 3
1061: where msii.transaction_id = cr.transaction_id;
1062:
1063: END; /* MASTER_CHILD_1HB */
1107: request_id,
1108: cr.TRANSACTION_ID,
1109: error_msg,
1110: 'MASTER_CHILD_1HC',
1111: 'MTL_SYSTEM_ITEMS_INTERFACE',
1112: 'INV_IOI_MASTER_CHILD_1HC',
1113: err_text );
1114:
1115: IF dumm_status < 0 THEN
1115: IF dumm_status < 0 THEN
1116: raise LOGGING_ERR ;
1117: END IF;
1118:
1119: update mtl_system_items_interface msii
1120: set process_flag = 3
1121: where msii.transaction_id = cr.transaction_id;
1122:
1123: END; /* MASTER_CHILD_1HC */
1168: request_id,
1169: cr.TRANSACTION_ID,
1170: error_msg,
1171: 'MASTER_CHILD_1HD',
1172: 'MTL_SYSTEM_ITEMS_INTERFACE',
1173: 'INV_IOI_MASTER_CHILD_1HD',
1174: err_text );
1175:
1176: IF dumm_status < 0 THEN
1176: IF dumm_status < 0 THEN
1177: raise LOGGING_ERR ;
1178: END IF;
1179:
1180: update mtl_system_items_interface msii
1181: set process_flag = 3
1182: where msii.transaction_id = cr.transaction_id;
1183:
1184: END; /* MASTER_CHILD_1HD */
1238: request_id,
1239: cr.TRANSACTION_ID,
1240: error_msg,
1241: 'MASTER_CHILD_1IA',
1242: 'MTL_SYSTEM_ITEMS_INTERFACE',
1243: 'INV_IOI_MASTER_CHILD_1IA',
1244: err_text );
1245:
1246: IF dumm_status < 0 THEN
1246: IF dumm_status < 0 THEN
1247: raise LOGGING_ERR ;
1248: END IF;
1249:
1250: update mtl_system_items_interface msii
1251: set process_flag = 3
1252: where msii.transaction_id = cr.transaction_id;
1253:
1254: END; /* MASTER_CHILD_1IA */
1294: request_id,
1295: cr.TRANSACTION_ID,
1296: error_msg,
1297: 'MASTER_CHILD_1IB',
1298: 'MTL_SYSTEM_ITEMS_INTERFACE',
1299: 'INV_IOI_MASTER_CHILD_1IB',
1300: err_text );
1301:
1302: IF dumm_status < 0 THEN
1302: IF dumm_status < 0 THEN
1303: raise LOGGING_ERR ;
1304: END IF;
1305:
1306: update mtl_system_items_interface msii
1307: set process_flag = 3
1308: where msii.transaction_id = cr.transaction_id;
1309:
1310: END; /* MASTER_CHILD_1IB */
1344: request_id,
1345: cr.TRANSACTION_ID,
1346: error_msg,
1347: 'MASTER_CHILD_1IC',
1348: 'MTL_SYSTEM_ITEMS_INTERFACE',
1349: 'INV_IOI_MASTER_CHILD_1IC',
1350: err_text );
1351:
1352: IF dumm_status < 0 THEN
1352: IF dumm_status < 0 THEN
1353: raise LOGGING_ERR ;
1354: END IF;
1355:
1356: update mtl_system_items_interface msii
1357: set process_flag = 3
1358: where msii.transaction_id = cr.transaction_id;
1359:
1360: END; /* MASTER_CHILD_1Ic */
1444: request_id,
1445: cr.TRANSACTION_ID,
1446: error_msg,
1447: 'MASTER_CHILD_1J',
1448: 'MTL_SYSTEM_ITEMS_INTERFACE',
1449: 'INV_IOI_MASTER_CHILD_1J',
1450: err_text );
1451:
1452: IF dumm_status < 0 THEN
1452: IF dumm_status < 0 THEN
1453: raise LOGGING_ERR;
1454: END IF;
1455:
1456: update mtl_system_items_interface msii
1457: set process_flag = 3
1458: where msii.transaction_id = cr.transaction_id;
1459:
1460: END; /* MASTER_CHILD_1J */
1525: request_id,
1526: cr.TRANSACTION_ID,
1527: error_msg,
1528: 'MASTER_CHILD_1K',
1529: 'MTL_SYSTEM_ITEMS_INTERFACE',
1530: 'INV_IOI_MASTER_CHILD_1K',
1531: err_text );
1532:
1533: IF dumm_status < 0 THEN
1533: IF dumm_status < 0 THEN
1534: raise LOGGING_ERR;
1535: END IF;
1536:
1537: update mtl_system_items_interface msii
1538: set process_flag = 3
1539: where msii.transaction_id = cr.transaction_id;
1540:
1541: END; /* MASTER_CHILD_1K */
1559: request_id,
1560: trans_id,
1561: err_text,
1562: 'MASTER_CHILD_1',
1563: 'MTL_SYSTEM_ITEMS_INTERFACE',
1564: 'BOM_OP_VALIDATION_ERR',
1565: err_text);
1566: return(status);
1567: