DBA Data[Home] [Help]

APPS.INVPVLM3 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 118: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

114: msii.EXPIRATION_ACTION_CODE ,
115: msii.MATURITY_DAYS ,
116: msii.HOLD_DAYS
117: /* End Bug 3713912 */
118: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
119: where ((msii.organization_id = org_id) or
120: (all_Org = 1))
121: and msii.process_flag = 2
122: and msii.organization_id = mp.organization_id

Line 244: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';

240: /* End Bug 3713912 */
241:
242: begin
243:
244: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
245:
246: /* set the attribute level variables to be used when validating a child's item
247: ** level attributes against the master org's attribute value. this is done
248: ** outside the loop so that it is only done once for all the records

Line 551: 'MTL_SYSTEM_ITEMS_INTERFACE',

547: request_id,
548: cr.TRANSACTION_ID,
549: error_msg,
550: 'MASTER_CHILD_7A',
551: 'MTL_SYSTEM_ITEMS_INTERFACE',
552: 'INV_IOI_MASTER_CHILD_7A',
553: err_text);
554: If dumm_status < 0 then
555: raise LOGGING_ERR ;

Line 557: update mtl_system_items_interface msii

553: err_text);
554: If dumm_status < 0 then
555: raise LOGGING_ERR ;
556: End if;
557: update mtl_system_items_interface msii
558: set process_flag = 3
559: where msii.transaction_id = cr.transaction_id;
560:
561: end; /* MASTER_CHILD_7A */

Line 590: 'MTL_SYSTEM_ITEMS_INTERFACE',

586: request_id,
587: cr.TRANSACTION_ID,
588: error_msg,
589: 'MASTER_CHILD_7B',
590: 'MTL_SYSTEM_ITEMS_INTERFACE',
591: 'INV_IOI_MASTER_CHILD_7B',
592: err_text);
593: If dumm_status < 0 then
594: raise LOGGING_ERR ;

Line 596: update mtl_system_items_interface msii

592: err_text);
593: If dumm_status < 0 then
594: raise LOGGING_ERR ;
595: End if;
596: update mtl_system_items_interface msii
597: set process_flag = 3
598: where msii.transaction_id = cr.transaction_id;
599:
600: end; /* MASTER_CHILD_7B */

Line 629: 'MTL_SYSTEM_ITEMS_INTERFACE',

625: request_id,
626: cr.TRANSACTION_ID,
627: error_msg,
628: 'MASTER_CHILD_7C',
629: 'MTL_SYSTEM_ITEMS_INTERFACE',
630: 'INV_IOI_MASTER_CHILD_7C',
631: err_text);
632: If dumm_status < 0 then
633: raise LOGGING_ERR ;

Line 635: update mtl_system_items_interface msii

631: err_text);
632: If dumm_status < 0 then
633: raise LOGGING_ERR ;
634: End if;
635: update mtl_system_items_interface msii
636: set process_flag = 3
637: where msii.transaction_id = cr.transaction_id;
638:
639: end; /* MASTER_CHILD_7C */

Line 668: 'MTL_SYSTEM_ITEMS_INTERFACE',

664: request_id,
665: cr.TRANSACTION_ID,
666: error_msg,
667: 'MASTER_CHILD_7D',
668: 'MTL_SYSTEM_ITEMS_INTERFACE',
669: 'INV_IOI_MASTER_CHILD_7D',
670: err_text);
671: If dumm_status < 0 then
672: raise LOGGING_ERR ;

Line 674: update mtl_system_items_interface msii

670: err_text);
671: If dumm_status < 0 then
672: raise LOGGING_ERR ;
673: End if;
674: update mtl_system_items_interface msii
675: set process_flag = 3
676: where msii.transaction_id = cr.transaction_id;
677:
678: end; /* MASTER_CHILD_7D */

Line 708: 'MTL_SYSTEM_ITEMS_INTERFACE',

704: request_id,
705: cr.TRANSACTION_ID,
706: error_msg,
707: 'MASTER_CHILD_7E',
708: 'MTL_SYSTEM_ITEMS_INTERFACE',
709: 'INV_IOI_MASTER_CHILD_7E',
710: err_text);
711: If dumm_status < 0 then
712: raise LOGGING_ERR ;

Line 714: update mtl_system_items_interface msii

710: err_text);
711: If dumm_status < 0 then
712: raise LOGGING_ERR ;
713: End if;
714: update mtl_system_items_interface msii
715: set process_flag = 3
716: where msii.transaction_id = cr.transaction_id;
717:
718: end; /* MASTER_CHILD_7E */

Line 741: 'MTL_SYSTEM_ITEMS_INTERFACE',

737: request_id,
738: cr.TRANSACTION_ID,
739: error_msg,
740: 'MASTER_CHILD_7F',
741: 'MTL_SYSTEM_ITEMS_INTERFACE',
742: 'INV_IOI_MASTER_CHILD_7F',
743: err_text);
744: If dumm_status < 0 then
745: raise LOGGING_ERR ;

Line 747: update mtl_system_items_interface msii

743: err_text);
744: If dumm_status < 0 then
745: raise LOGGING_ERR ;
746: End if;
747: update mtl_system_items_interface msii
748: set process_flag = 3
749: where msii.transaction_id = cr.transaction_id;
750:
751: end; /* MASTER_CHILD_7F */

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'MASTER_CHILD_7G',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IOI_MASTER_CHILD_7G',
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_7G */

Line 823: 'MTL_SYSTEM_ITEMS_INTERFACE',

819: request_id,
820: cr.TRANSACTION_ID,
821: error_msg,
822: 'MASTER_CHILD_7G',
823: 'MTL_SYSTEM_ITEMS_INTERFACE',
824: 'INV_IOI_MASTER_CHILD_7H',
825: err_text);
826: If dumm_status < 0 then
827: raise LOGGING_ERR ;

Line 829: update mtl_system_items_interface msii

825: err_text);
826: If dumm_status < 0 then
827: raise LOGGING_ERR ;
828: End if;
829: update mtl_system_items_interface msii
830: set process_flag = 3
831: where msii.transaction_id = cr.transaction_id;
832:
833: end; /* MASTER_CHILD_7H */

Line 866: 'MTL_SYSTEM_ITEMS_INTERFACE',

862: request_id,
863: cr.TRANSACTION_ID,
864: error_msg,
865: 'MASTER_CHILD_7I',
866: 'MTL_SYSTEM_ITEMS_INTERFACE',
867: 'INV_IOI_MASTER_CHILD_7I',
868: err_text);
869: If dumm_status < 0 then
870: raise LOGGING_ERR ;

Line 872: update mtl_system_items_interface msii

868: err_text);
869: If dumm_status < 0 then
870: raise LOGGING_ERR ;
871: End if;
872: update mtl_system_items_interface msii
873: set process_flag = 3
874: where msii.transaction_id = cr.transaction_id;
875:
876: end; /* MASTER_CHILD_7I */

Line 906: 'MTL_SYSTEM_ITEMS_INTERFACE',

902: request_id,
903: cr.TRANSACTION_ID,
904: error_msg,
905: 'MASTER_CHILD_7J',
906: 'MTL_SYSTEM_ITEMS_INTERFACE',
907: 'INV_IOI_MASTER_CHILD_7J',
908: err_text);
909: If dumm_status < 0 then
910: raise LOGGING_ERR ;

Line 912: update mtl_system_items_interface msii

908: err_text);
909: If dumm_status < 0 then
910: raise LOGGING_ERR ;
911: End if;
912: update mtl_system_items_interface msii
913: set process_flag = 3
914: where msii.transaction_id = cr.transaction_id;
915:
916: end; /* MASTER_CHILD_7J */

Line 936: 'MTL_SYSTEM_ITEMS_INTERFACE',

932: request_id,
933: trans_id,
934: err_text,
935: 'MASTER_CHILD_7',
936: 'MTL_SYSTEM_ITEMS_INTERFACE',
937: 'BOM_OP_VALIDATION_ERR',
938: err_text);
939: return(status);
940: when OTHERS then