875: /*
876: || check for action in trigger and pass the same to the procedure
877: */
878: IF INSERTING THEN
879: lv_action := jai_constants.inserting ;
880: ELSIF UPDATING THEN
881: lv_action := jai_constants.updating ;
882: ELSIF DELETING THEN
883: lv_action := jai_constants.deleting ;
877: */
878: IF INSERTING THEN
879: lv_action := jai_constants.inserting ;
880: ELSIF UPDATING THEN
881: lv_action := jai_constants.updating ;
882: ELSIF DELETING THEN
883: lv_action := jai_constants.deleting ;
884: END IF ;
885:
879: lv_action := jai_constants.inserting ;
880: ELSIF UPDATING THEN
881: lv_action := jai_constants.updating ;
882: ELSIF DELETING THEN
883: lv_action := jai_constants.deleting ;
884: END IF ;
885:
886: /*START, mmurtuza for Bug#13602572*/
887: if updating then
907: pv_return_code => lv_return_code ,
908: pv_return_message => lv_return_message
909: );
910:
911: IF lv_return_code <> jai_constants.successful then
912: RAISE le_error;
913: END IF;
914:
915: END IF ;
923: pv_return_code => lv_return_code ,
924: pv_return_message => lv_return_message
925: );
926:
927: IF lv_return_code <> jai_constants.successful then
928: RAISE le_error;
929: END IF;
930:
931: /*Bug 9626284 - Stop Validation if Standalone AP Invoice does not have Organization or Location Information*/
954: pv_return_code => lv_return_code ,
955: pv_return_message => lv_return_message
956: );
957:
958: IF lv_return_code <> jai_constants.successful then
959: RAISE le_error;
960: END IF;
961:
962: END IF ;