556: /*
557: || check for action in trigger and pass the same to the procedure
558: */
559: IF INSERTING THEN
560: lv_action := jai_constants.inserting ;
561: ELSIF UPDATING THEN
562: lv_action := jai_constants.updating ;
563: ELSIF DELETING THEN
564: lv_action := jai_constants.deleting ;
558: */
559: IF INSERTING THEN
560: lv_action := jai_constants.inserting ;
561: ELSIF UPDATING THEN
562: lv_action := jai_constants.updating ;
563: ELSIF DELETING THEN
564: lv_action := jai_constants.deleting ;
565: END IF ;
566:
560: lv_action := jai_constants.inserting ;
561: ELSIF UPDATING THEN
562: lv_action := jai_constants.updating ;
563: ELSIF DELETING THEN
564: lv_action := jai_constants.deleting ;
565: END IF ;
566:
567: /*START, mmurtuza for Bug#13602572*/
568: if updating then
588: pv_return_code => lv_return_code ,
589: pv_return_message => lv_return_message
590: );
591:
592: IF lv_return_code <> jai_constants.successful then
593: RAISE le_error;
594: END IF;
595:
596: END IF ;
604: pv_return_code => lv_return_code ,
605: pv_return_message => lv_return_message
606: );
607:
608: IF lv_return_code <> jai_constants.successful then
609: RAISE le_error;
610: END IF;
611:
612: -- Added by Jia Li for inclusive tax on 2007/12/26, Begin
619: , xv_process_message => lv_return_message
620: );
621: END IF;
622:
623: IF lv_return_code <> jai_constants.successful
624: THEN
625: RAISE le_error;
626: END IF;
627: ----------------------------------------------------------
638: pv_return_code => lv_return_code ,
639: pv_return_message => lv_return_message
640: );
641:
642: IF lv_return_code <> jai_constants.successful then
643: RAISE le_error;
644: END IF;
645:
646: END IF ;