549: /*
550: || check for action in trigger and pass the same to the procedure
551: */
552: IF INSERTING THEN
553: lv_action := jai_constants.inserting ;
554: ELSIF UPDATING THEN
555: lv_action := jai_constants.updating ;
556: ELSIF DELETING THEN
557: lv_action := jai_constants.deleting ;
551: */
552: IF INSERTING THEN
553: lv_action := jai_constants.inserting ;
554: ELSIF UPDATING THEN
555: lv_action := jai_constants.updating ;
556: ELSIF DELETING THEN
557: lv_action := jai_constants.deleting ;
558: END IF ;
559:
553: lv_action := jai_constants.inserting ;
554: ELSIF UPDATING THEN
555: lv_action := jai_constants.updating ;
556: ELSIF DELETING THEN
557: lv_action := jai_constants.deleting ;
558: END IF ;
559:
560: IF INSERTING THEN
561:
566: pv_return_code => lv_return_code ,
567: pv_return_message => lv_return_message
568: );
569:
570: IF lv_return_code <> jai_constants.successful then
571: RAISE le_error;
572: END IF;
573:
574: END IF ;
582: pv_return_code => lv_return_code ,
583: pv_return_message => lv_return_message
584: );
585:
586: IF lv_return_code <> jai_constants.successful then
587: RAISE le_error;
588: END IF;
589:
590: -- Added by Jia Li for inclusive tax on 2007/12/26, Begin
597: , xv_process_message => lv_return_message
598: );
599: END IF;
600:
601: IF lv_return_code <> jai_constants.successful
602: THEN
603: RAISE le_error;
604: END IF;
605: ----------------------------------------------------------
616: pv_return_code => lv_return_code ,
617: pv_return_message => lv_return_message
618: );
619:
620: IF lv_return_code <> jai_constants.successful then
621: RAISE le_error;
622: END IF;
623:
624: END IF ;