733: /*
734: || check for action in trigger and pass the same to the procedure
735: */
736: IF inserting THEN
737: lv_action := jai_constants.inserting ;
738: ELSIF updating THEN
739: lv_action := jai_constants.updating ;
740: ELSIF deleting THEN
741: lv_action := jai_constants.deleting ;
735: */
736: IF inserting THEN
737: lv_action := jai_constants.inserting ;
738: ELSIF updating THEN
739: lv_action := jai_constants.updating ;
740: ELSIF deleting THEN
741: lv_action := jai_constants.deleting ;
742: END IF ;
743:
737: lv_action := jai_constants.inserting ;
738: ELSIF updating THEN
739: lv_action := jai_constants.updating ;
740: ELSIF deleting THEN
741: lv_action := jai_constants.deleting ;
742: END IF ;
743:
744: IF updating THEN
745:
757: , pv_action => lv_action
758: , pv_return_code => lv_return_code
759: , pv_return_message => lv_return_message
760: );
761: IF lv_return_code <> jai_constants.successful
762: THEN
763: RAISE le_error;
764: END IF; -- lv_return_code <> jai_constants.successful
765:
760: );
761: IF lv_return_code <> jai_constants.successful
762: THEN
763: RAISE le_error;
764: END IF; -- lv_return_code <> jai_constants.successful
765:
766: -- added by zhiwei.xin for Trigger Replacement bug#15968958 on 20-Dec-2012 begin
767: JAI_OM_TAX_PROCESSING_PKG.ORDER_LINE_VALIDATION( p_rec_old => t_old_rec
768: , p_rec_new => t_new_rec
769: , p_action => lv_action
770: , px_return_code => lv_return_code
771: , px_return_message => lv_return_message
772: );
773: IF lv_return_code <> jai_constants.successful
774: THEN
775: RAISE le_error;
776: END IF;
777: -- added by zhiwei.xin for Trigger Replacement bug#15968958 on 20-Dec-2012 end.
789: pv_return_code => lv_return_code ,
790: pv_return_message => lv_return_message
791: );
792:
793: IF lv_return_code <> jai_constants.successful then
794: RAISE le_error;
795: END IF;
796:
797: END IF ;