DBA Data[Home] [Help]

APPS.INVPVLM2 dependencies on MTL_SYSTEM_ITEMS

Line 130: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

126: ,msii.REPAIR_LEADTIME
127: ,msii.REPAIR_PROGRAM
128: ,msii.REPAIR_YIELD
129: ,msii.PREPOSITION_POINT
130: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
131: where ((msii.organization_id = org_id) or
132: (all_Org = 1))
133: and msii.process_flag = 2
134: and msii.organization_id = mp.organization_id

Line 592: from mtl_system_items msi

588:
589: begin /* MASTER_CHILD_4A */
590:
591: select inventory_item_id into msicount
592: from mtl_system_items msi
593: where msi.inventory_item_id = cr.III
594: and msi.organization_id = cr.MORGID
595: and decode(A_START_AUTO_LOT_NUMBER,X_TRUE,nvl(cr.START_AUTO_LOT_NUMBER,-1),nvl(msi.START_AUTO_LOT_NUMBER,-1))=nvl(msi.START_AUTO_LOT_NUMBER,-1)
596: and decode(A_LOT_CONTROL_CODE,X_TRUE,nvl(cr.LOT_CONTROL_CODE,-1),nvl(msi.LOT_CONTROL_CODE,-1))=nvl(msi.LOT_CONTROL_CODE,-1)

Line 615: 'MTL_SYSTEM_ITEMS_INTERFACE',

611: request_id,
612: cr.TRANSACTION_ID,
613: error_msg,
614: 'MASTER_CHILD_4A',
615: 'MTL_SYSTEM_ITEMS_INTERFACE',
616: 'INV_IOI_MASTER_CHILD_4A',
617: err_text);
618: If dumm_status < 0 Then
619: raise LOGGING_ERR ;

Line 621: update mtl_system_items_interface msii

617: err_text);
618: If dumm_status < 0 Then
619: raise LOGGING_ERR ;
620: End if ;
621: update mtl_system_items_interface msii
622: set process_flag = 3
623: where msii.transaction_id = cr.transaction_id;
624:
625: end; /* MASTER_CHILD_4A */

Line 631: from mtl_system_items msi

627:
628: begin /* MASTER_CHILD_4B */
629:
630: select inventory_item_id into msicount
631: from mtl_system_items msi
632: where msi.inventory_item_id = cr.III
633: and msi.organization_id = cr.MORGID
634: and decode(A_SOURCE_TYPE,X_TRUE,nvl(cr.SOURCE_TYPE,-1),nvl(msi.SOURCE_TYPE,-1))=nvl(msi.SOURCE_TYPE,-1)
635: and decode(A_SOURCE_ORGANIZATION_ID,X_TRUE,nvl(cr.SOURCE_ORGANIZATION_ID,-1),nvl(msi.SOURCE_ORGANIZATION_ID,-1))=nvl(msi.SOURCE_ORGANIZATION_ID,-1)

Line 655: 'MTL_SYSTEM_ITEMS_INTERFACE',

651: request_id,
652: cr.TRANSACTION_ID,
653: error_msg,
654: 'MASTER_CHILD_4B',
655: 'MTL_SYSTEM_ITEMS_INTERFACE',
656: 'INV_IOI_MASTER_CHILD_4B',
657: err_text);
658: If dumm_status < 0 Then
659: raise LOGGING_ERR ;

Line 661: update mtl_system_items_interface msii

657: err_text);
658: If dumm_status < 0 Then
659: raise LOGGING_ERR ;
660: End if ;
661: update mtl_system_items_interface msii
662: set process_flag = 3
663: where msii.transaction_id = cr.transaction_id;
664:
665: end; /* MASTER_CHILD_4B */

Line 671: from mtl_system_items msi

667:
668: begin /* MASTER_CHILD_4C */
669:
670: select inventory_item_id into msicount
671: from mtl_system_items msi
672: where msi.inventory_item_id = cr.III
673: and msi.organization_id = cr.MORGID
674: and decode(A_VOLUME_UOM_CODE,X_TRUE,nvl(cr.VOLUME_UOM_CODE,-1),nvl(msi.VOLUME_UOM_CODE,-1))=nvl(msi.VOLUME_UOM_CODE,-1)
675: and decode(A_UNIT_VOLUME,X_TRUE,nvl(cr.UNIT_VOLUME,-1),nvl(msi.UNIT_VOLUME,-1))=nvl(msi.UNIT_VOLUME,-1)

Line 694: 'MTL_SYSTEM_ITEMS_INTERFACE',

690: request_id,
691: cr.TRANSACTION_ID,
692: error_msg,
693: 'MASTER_CHILD_4C',
694: 'MTL_SYSTEM_ITEMS_INTERFACE',
695: 'INV_IOI_MASTER_CHILD_4C',
696: err_text);
697: If dumm_status < 0 Then
698: raise LOGGING_ERR ;

Line 700: update mtl_system_items_interface msii

696: err_text);
697: If dumm_status < 0 Then
698: raise LOGGING_ERR ;
699: End if ;
700: update mtl_system_items_interface msii
701: set process_flag = 3
702: where msii.transaction_id = cr.transaction_id;
703:
704: end; /* MASTER_CHILD_4C */

Line 710: from mtl_system_items msi

706:
707: begin /* MASTER_CHILD_4D */
708:
709: select inventory_item_id into msicount
710: from mtl_system_items msi
711: where msi.inventory_item_id = cr.III
712: and msi.organization_id = cr.MORGID
713: and decode(A_DEMAND_TIME_FENCE_CODE,X_TRUE,nvl(cr.DEMAND_TIME_FENCE_CODE,-1),nvl(msi.DEMAND_TIME_FENCE_CODE,-1))=nvl(msi.DEMAND_TIME_FENCE_CODE,-1)
714: and decode(A_LEAD_TIME_LOT_SIZE,X_TRUE,nvl(cr.LEAD_TIME_LOT_SIZE,-1),nvl(msi.LEAD_TIME_LOT_SIZE,-1))=nvl(msi.LEAD_TIME_LOT_SIZE,-1)

Line 734: 'MTL_SYSTEM_ITEMS_INTERFACE',

730: request_id,
731: cr.TRANSACTION_ID,
732: error_msg,
733: 'MASTER_CHILD_4D',
734: 'MTL_SYSTEM_ITEMS_INTERFACE',
735: 'INV_IOI_MASTER_CHILD_4D',
736: err_text);
737: If dumm_status < 0 Then
738: raise LOGGING_ERR ;

Line 740: update mtl_system_items_interface msii

736: err_text);
737: If dumm_status < 0 Then
738: raise LOGGING_ERR ;
739: End if ;
740: update mtl_system_items_interface msii
741: set process_flag = 3
742: where msii.transaction_id = cr.transaction_id;
743:
744: end; /* MASTER_CHILD_4D */

Line 750: from mtl_system_items msi

746:
747: begin /* MASTER_CHILD_4E */
748:
749: select inventory_item_id into msicount
750: from mtl_system_items msi
751: where msi.inventory_item_id = cr.III
752: and msi.organization_id = cr.MORGID
753: and decode(A_CUMULATIVE_TOTAL_LEAD_TIME,X_TRUE,nvl(cr.CUMULATIVE_TOTAL_LEAD_TIME,-1),nvl(msi.CUMULATIVE_TOTAL_LEAD_TIME,-1))=nvl(msi.CUMULATIVE_TOTAL_LEAD_TIME,-1)
754: and decode(A_PLANNING_TIME_FENCE_DAYS,X_TRUE,nvl(cr.PLANNING_TIME_FENCE_DAYS,-1),nvl(msi.PLANNING_TIME_FENCE_DAYS,-1))=nvl(msi.PLANNING_TIME_FENCE_DAYS,-1)

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'MASTER_CHILD_4E',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IOI_MASTER_CHILD_4E',
775: err_text);
776: If dumm_status < 0 Then
777: raise LOGGING_ERR ;

Line 779: update mtl_system_items_interface msii

775: err_text);
776: If dumm_status < 0 Then
777: raise LOGGING_ERR ;
778: End if ;
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_4E */

Line 789: from mtl_system_items msi

785:
786: begin /* MASTER_CHILD_4F */
787:
788: select inventory_item_id into msicount
789: from mtl_system_items msi
790: where msi.inventory_item_id = cr.III
791: and msi.organization_id = cr.MORGID
792: and decode(A_PICK_COMPONENTS_FLAG,X_TRUE,nvl(cr.PICK_COMPONENTS_FLAG,-1),nvl(msi.PICK_COMPONENTS_FLAG,-1))=nvl(msi.PICK_COMPONENTS_FLAG,-1)
793: and decode(A_REPLENISH_TO_ORDER_FLAG,X_TRUE,nvl(cr.REPLENISH_TO_ORDER_FLAG,-1),nvl(msi.REPLENISH_TO_ORDER_FLAG,-1))=nvl(msi.REPLENISH_TO_ORDER_FLAG,-1)

Line 813: 'MTL_SYSTEM_ITEMS_INTERFACE',

809: request_id,
810: cr.TRANSACTION_ID,
811: error_msg,
812: 'MASTER_CHILD_4F',
813: 'MTL_SYSTEM_ITEMS_INTERFACE',
814: 'INV_IOI_MASTER_CHILD_4F',
815: err_text);
816: If dumm_status < 0 Then
817: raise LOGGING_ERR ;

Line 819: update mtl_system_items_interface msii

815: err_text);
816: If dumm_status < 0 Then
817: raise LOGGING_ERR ;
818: End if ;
819: update mtl_system_items_interface msii
820: set process_flag = 3
821: where msii.transaction_id = cr.transaction_id;
822:
823: end; /* MASTER_CHILD_4F */

Line 829: from mtl_system_items msi

825:
826: begin /* MASTER_CHILD_4G */
827:
828: select inventory_item_id into msicount
829: from mtl_system_items msi
830: where msi.inventory_item_id = cr.III
831: and msi.organization_id = cr.MORGID
832: and decode(A_WIP_SUPPLY_TYPE,X_TRUE,nvl(cr.WIP_SUPPLY_TYPE,-1),nvl(msi.WIP_SUPPLY_TYPE,-1))=nvl(msi.WIP_SUPPLY_TYPE,-1)
833: and decode(A_WIP_SUPPLY_SUBINVENTORY,X_TRUE,nvl(cr.WIP_SUPPLY_SUBINVENTORY,-1),nvl(msi.WIP_SUPPLY_SUBINVENTORY,-1))=nvl(msi.WIP_SUPPLY_SUBINVENTORY,-1)

Line 854: 'MTL_SYSTEM_ITEMS_INTERFACE',

850: request_id,
851: cr.TRANSACTION_ID,
852: error_msg,
853: 'MASTER_CHILD_4G',
854: 'MTL_SYSTEM_ITEMS_INTERFACE',
855: 'INV_IOI_MASTER_CHILD_4G',
856: err_text);
857: If dumm_status < 0 Then
858: raise LOGGING_ERR ;

Line 860: update mtl_system_items_interface msii

856: err_text);
857: If dumm_status < 0 Then
858: raise LOGGING_ERR ;
859: End if ;
860: update mtl_system_items_interface msii
861: set process_flag = 3
862: where msii.transaction_id = cr.transaction_id;
863:
864: end; /* MASTER_CHILD_4G */

Line 870: from mtl_system_items msi

866:
867: begin /* MASTER_CHILD_4H */
868:
869: select inventory_item_id into msicount
870: from mtl_system_items msi
871: where msi.inventory_item_id = cr.III
872: and msi.organization_id = cr.MORGID
873: and decode(A_DEFAULT_INCLUDE_IN_ROLLUP_F,X_TRUE,nvl(cr.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,-1),nvl(msi.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,-1))=nvl(msi.DEFAULT_INCLUDE_IN_ROLLUP_FLAG,-1)
874: and decode(A_INVENTORY_ITEM_STATUS_CODE,X_TRUE,nvl(cr.INVENTORY_ITEM_STATUS_CODE,-1),nvl(msi.INVENTORY_ITEM_STATUS_CODE,-1))=nvl(msi.INVENTORY_ITEM_STATUS_CODE,-1)

Line 894: 'MTL_SYSTEM_ITEMS_INTERFACE',

890: request_id,
891: cr.TRANSACTION_ID,
892: error_msg,
893: 'MASTER_CHILD_4H',
894: 'MTL_SYSTEM_ITEMS_INTERFACE',
895: 'INV_IOI_MASTER_CHILD_4H',
896: err_text);
897: If dumm_status < 0 Then
898: raise LOGGING_ERR ;

Line 900: update mtl_system_items_interface msii

896: err_text);
897: If dumm_status < 0 Then
898: raise LOGGING_ERR ;
899: End if ;
900: update mtl_system_items_interface msii
901: set process_flag = 3
902: where msii.transaction_id = cr.transaction_id;
903:
904: end; /* MASTER_CHILD_4H */

Line 911: from mtl_system_items msi

907:
908: begin /* MASTER_CHILD_4I */
909:
910: select inventory_item_id into msicount
911: from mtl_system_items msi
912: where msi.inventory_item_id = cr.III
913: and msi.organization_id = cr.MORGID
914: and decode(A_POSTPROCESSING_LEAD_TIME,X_TRUE,nvl(cr.POSTPROCESSING_LEAD_TIME,-1),nvl(msi.POSTPROCESSING_LEAD_TIME,-1))=nvl(msi.POSTPROCESSING_LEAD_TIME,-1)
915: and decode(A_PREPROCESSING_LEAD_TIME,X_TRUE,nvl(cr.PREPROCESSING_LEAD_TIME,-1),nvl(msi.PREPROCESSING_LEAD_TIME,-1))=nvl(msi.PREPROCESSING_LEAD_TIME,-1)

Line 934: 'MTL_SYSTEM_ITEMS_INTERFACE',

930: request_id,
931: cr.TRANSACTION_ID,
932: error_msg,
933: 'MASTER_CHILD_4I',
934: 'MTL_SYSTEM_ITEMS_INTERFACE',
935: 'INV_IOI_MASTER_CHILD_4I',
936: err_text);
937: If dumm_status < 0 Then
938: raise LOGGING_ERR ;

Line 940: update mtl_system_items_interface msii

936: err_text);
937: If dumm_status < 0 Then
938: raise LOGGING_ERR ;
939: End if ;
940: update mtl_system_items_interface msii
941: set process_flag = 3
942: where msii.transaction_id = cr.transaction_id;
943:
944: end; /* MASTER_CHILD_4I */

Line 949: from mtl_system_items msi

945:
946: begin /* MASTER_CHILD_4J */
947:
948: select inventory_item_id into msicount
949: from mtl_system_items msi
950: where msi.inventory_item_id = cr.III
951: and msi.organization_id = cr.MORGID
952: and decode(A_MAX_MINMAX_QUANTITY,X_TRUE,nvl(cr.MAX_MINMAX_QUANTITY,-1),nvl(msi.MAX_MINMAX_QUANTITY,-1))=nvl(msi.MAX_MINMAX_QUANTITY,-1)
953: and decode(A_MINIMUM_ORDER_QUANTITY,X_TRUE,nvl(cr.MINIMUM_ORDER_QUANTITY,-1),nvl(msi.MINIMUM_ORDER_QUANTITY,-1))=nvl(msi.MINIMUM_ORDER_QUANTITY,-1)

Line 972: 'MTL_SYSTEM_ITEMS_INTERFACE',

968: request_id,
969: cr.TRANSACTION_ID,
970: error_msg,
971: 'MASTER_CHILD_4J',
972: 'MTL_SYSTEM_ITEMS_INTERFACE',
973: 'INV_IOI_MASTER_CHILD_4J',
974: err_text);
975: If dumm_status < 0 Then
976: raise LOGGING_ERR ;

Line 978: update mtl_system_items_interface msii

974: err_text);
975: If dumm_status < 0 Then
976: raise LOGGING_ERR ;
977: End if ;
978: update mtl_system_items_interface msii
979: set process_flag = 3
980: where msii.transaction_id = cr.transaction_id;
981:
982: end; /* MASTER_CHILD_4J */

Line 989: from mtl_system_items msi

985:
986: begin /* MASTER_CHILD_4K */
987:
988: select inventory_item_id into msicount
989: from mtl_system_items msi
990: where msi.inventory_item_id = cr.III
991: and msi.organization_id = cr.MORGID
992: and decode(A_RESERVABLE_TYPE,X_TRUE,nvl(cr.RESERVABLE_TYPE,-1),nvl(msi.RESERVABLE_TYPE,-1))=nvl(msi.RESERVABLE_TYPE,-1)
993: and decode(A_POSITIVE_MEASUREMENT_ERROR,X_TRUE,nvl(cr.POSITIVE_MEASUREMENT_ERROR,-1),nvl(msi.POSITIVE_MEASUREMENT_ERROR,-1))=nvl(msi.POSITIVE_MEASUREMENT_ERROR,-1)

Line 1013: 'MTL_SYSTEM_ITEMS_INTERFACE',

1009: request_id,
1010: cr.TRANSACTION_ID,
1011: error_msg,
1012: 'MASTER_CHILD_4K',
1013: 'MTL_SYSTEM_ITEMS_INTERFACE',
1014: 'INV_IOI_MASTER_CHILD_4K',
1015: err_text);
1016: If dumm_status < 0 Then
1017: raise LOGGING_ERR ;

Line 1019: update mtl_system_items_interface msii

1015: err_text);
1016: If dumm_status < 0 Then
1017: raise LOGGING_ERR ;
1018: End if ;
1019: update mtl_system_items_interface msii
1020: set process_flag = 3
1021: where msii.transaction_id = cr.transaction_id;
1022:
1023: end; /* MASTER_CHILD_4K */

Line 1028: from mtl_system_items msi

1024:
1025: begin /* MASTER_CHILD_4L */
1026:
1027: select inventory_item_id into msicount
1028: from mtl_system_items msi
1029: where msi.inventory_item_id = cr.III
1030: and msi.organization_id = cr.MORGID
1031: and decode(A_AUTO_CREATED_CONFIG_FLAG,X_TRUE,nvl(cr.AUTO_CREATED_CONFIG_FLAG,-1),nvl(msi.AUTO_CREATED_CONFIG_FLAG,-1))=nvl(msi.AUTO_CREATED_CONFIG_FLAG,-1)
1032: and decode(A_CYCLE_COUNT_ENABLED_FLAG,X_TRUE,nvl(cr.CYCLE_COUNT_ENABLED_FLAG,-1),nvl(msi.CYCLE_COUNT_ENABLED_FLAG,-1))=nvl(msi.CYCLE_COUNT_ENABLED_FLAG,-1)

Line 1052: 'MTL_SYSTEM_ITEMS_INTERFACE',

1048: request_id,
1049: cr.TRANSACTION_ID,
1050: error_msg,
1051: 'MASTER_CHILD_4L',
1052: 'MTL_SYSTEM_ITEMS_INTERFACE',
1053: 'INV_IOI_MASTER_CHILD_4L',
1054: err_text);
1055: If dumm_status < 0 Then
1056: raise LOGGING_ERR ;

Line 1058: update mtl_system_items_interface msii

1054: err_text);
1055: If dumm_status < 0 Then
1056: raise LOGGING_ERR ;
1057: End if ;
1058: update mtl_system_items_interface msii
1059: set process_flag = 3
1060: where msii.transaction_id = cr.transaction_id;
1061:
1062: end; /* MASTER_CHILD_4L */

Line 1066: from mtl_system_items msi

1062: end; /* MASTER_CHILD_4L */
1063: begin /* MASTER_CHILD_4M Added as part of 11.5.9*/
1064:
1065: select inventory_item_id into msicount
1066: from mtl_system_items msi
1067: where msi.inventory_item_id = cr.III
1068: and msi.organization_id = cr.MORGID
1069: and decode(A_LOT_SUBSTITUTION_ENABLED,X_TRUE,nvl(cr.LOT_SUBSTITUTION_ENABLED,-1),nvl(msi.LOT_SUBSTITUTION_ENABLED,-1))=nvl(msi.LOT_SUBSTITUTION_ENABLED,-1)
1070: and decode(A_MINIMUM_LICENSE_QUANTITY,X_TRUE,nvl(cr.MINIMUM_LICENSE_QUANTITY,-1),nvl(msi.MINIMUM_LICENSE_QUANTITY,-1))=nvl(msi.MINIMUM_LICENSE_QUANTITY,-1)

Line 1086: 'MTL_SYSTEM_ITEMS_INTERFACE',

1082: request_id,
1083: cr.TRANSACTION_ID,
1084: error_msg,
1085: 'MASTER_CHILD_4M',
1086: 'MTL_SYSTEM_ITEMS_INTERFACE',
1087: 'INV_IOI_MASTER_CHILD_4M',
1088: err_text);
1089: If dumm_status < 0 Then
1090: raise LOGGING_ERR ;

Line 1092: update mtl_system_items_interface msii

1088: err_text);
1089: If dumm_status < 0 Then
1090: raise LOGGING_ERR ;
1091: End if ;
1092: update mtl_system_items_interface msii
1093: set process_flag = 3
1094: where msii.transaction_id = cr.transaction_id;
1095:
1096: end; /* MASTER_CHILD_4M */

Line 1100: from mtl_system_items msi

1096: end; /* MASTER_CHILD_4M */
1097: begin /* MASTER_CHILD_4N Added as part of R12*/
1098:
1099: select inventory_item_id into msicount
1100: from mtl_system_items msi
1101: where msi.inventory_item_id = cr.III
1102: and msi.organization_id = cr.MORGID
1103: and decode(A_OUTSOURCED_ASSEMBLY,X_TRUE,nvl(cr.OUTSOURCED_ASSEMBLY,-1),nvl(msi.OUTSOURCED_ASSEMBLY,-1))=nvl(msi.OUTSOURCED_ASSEMBLY,-1)
1104: and decode(A_SUBCONTRACTING_COMPONENT,X_TRUE,nvl(cr.SUBCONTRACTING_COMPONENT,-1),nvl(msi.SUBCONTRACTING_COMPONENT,-1))=nvl(msi.SUBCONTRACTING_COMPONENT,-1)

Line 1118: 'MTL_SYSTEM_ITEMS_INTERFACE',

1114: request_id,
1115: cr.TRANSACTION_ID,
1116: error_msg,
1117: 'MASTER_CHILD_4M',
1118: 'MTL_SYSTEM_ITEMS_INTERFACE',
1119: 'INV_IOI_MASTER_CHILD_4N',
1120: err_text);
1121: If dumm_status < 0 Then
1122: raise LOGGING_ERR ;

Line 1124: update mtl_system_items_interface msii

1120: err_text);
1121: If dumm_status < 0 Then
1122: raise LOGGING_ERR ;
1123: End if ;
1124: update mtl_system_items_interface msii
1125: set process_flag = 3
1126: where msii.transaction_id = cr.transaction_id;
1127:
1128: end; /* MASTER_CHILD_4N */

Line 1132: from mtl_system_items msi

1128: end; /* MASTER_CHILD_4N */
1129: begin /* MASTER_CHILD_4O Added as part of R12*/
1130:
1131: select inventory_item_id into msicount
1132: from mtl_system_items msi
1133: where msi.inventory_item_id = cr.III
1134: and msi.organization_id = cr.MORGID
1135: and decode(A_REPAIR_LEADTIME,X_TRUE,nvl(cr.REPAIR_LEADTIME,-1),nvl(msi.REPAIR_LEADTIME,-1))=nvl(msi.REPAIR_LEADTIME,-1)
1136: and decode(A_REPAIR_PROGRAM,X_TRUE,nvl(cr.REPAIR_PROGRAM,-1),nvl(msi.REPAIR_PROGRAM,-1))=nvl(msi.REPAIR_PROGRAM,-1)

Line 1151: 'MTL_SYSTEM_ITEMS_INTERFACE',

1147: request_id,
1148: cr.TRANSACTION_ID,
1149: error_msg,
1150: 'MASTER_CHILD_4M',
1151: 'MTL_SYSTEM_ITEMS_INTERFACE',
1152: 'INV_IOI_MASTER_CHILD_4O',
1153: err_text);
1154: If dumm_status < 0 Then
1155: raise LOGGING_ERR ;

Line 1157: update mtl_system_items_interface msii

1153: err_text);
1154: If dumm_status < 0 Then
1155: raise LOGGING_ERR ;
1156: End if ;
1157: update mtl_system_items_interface msii
1158: set process_flag = 3
1159: where msii.transaction_id = cr.transaction_id;
1160:
1161: end; /* MASTER_CHILD_40 */

Line 1183: 'MTL_SYSTEM_ITEMS_INTERFACE',

1179: request_id,
1180: trans_id,
1181: err_text,
1182: 'MASTER_CHILD_4',
1183: 'MTL_SYSTEM_ITEMS_INTERFACE',
1184: 'BOM_OP_VALIDATION_ERR',
1185: err_text);
1186:
1187: return(status);