APPS.JAI_AR_RCTLA_ARIUD_T1 dependencies on JAI_CONSTANTS

Line 96: AND created_from = jai_constants.created_fr_ar_invoice_api; /* 'AR_INVOICE_API' */

92: FROM
93: ra_customer_trx_all
94: WHERE
95: customer_trx_id = cp_customer_trx_id
96: AND created_from = jai_constants.created_fr_ar_invoice_api; /* 'AR_INVOICE_API' */
97:
98: ln_exists NUMBER(2) ;
99:
100:

Line 498: lv_action := jai_constants.inserting ;

494: /*
495: || check for action in trigger and pass the same to the procedure
496: */
497: IF INSERTING THEN
498: lv_action := jai_constants.inserting ;
499: ELSIF UPDATING THEN
500: lv_action := jai_constants.updating ;
501: ELSIF DELETING THEN
502: lv_action := jai_constants.deleting ;

Line 500: lv_action := jai_constants.updating ;

496: */
497: IF INSERTING THEN
498: lv_action := jai_constants.inserting ;
499: ELSIF UPDATING THEN
500: lv_action := jai_constants.updating ;
501: ELSIF DELETING THEN
502: lv_action := jai_constants.deleting ;
503: END IF ;
504:

Line 502: lv_action := jai_constants.deleting ;

498: lv_action := jai_constants.inserting ;
499: ELSIF UPDATING THEN
500: lv_action := jai_constants.updating ;
501: ELSIF DELETING THEN
502: lv_action := jai_constants.deleting ;
503: END IF ;
504:
505: IF INSERTING THEN
506:

Line 526: if lv_return_code in (jai_constants.expected_error, jai_constants.unexpected_error) then

522: , pv_err_msg => lv_return_message
523: , pv_err_flg => lv_return_code
524: );
525:
526: if lv_return_code in (jai_constants.expected_error, jai_constants.unexpected_error) then
527: raise le_error ;
528: end if;
529:
530: else

Line 544: IF lv_return_code <> jai_constants.successful then

540: pv_return_code => lv_return_code ,
541: pv_return_message => lv_return_message
542: );
543:
544: IF lv_return_code <> jai_constants.successful then
545: RAISE le_error;
546: END IF;
547:
548: END IF ;

Line 564: IF lv_return_code <> jai_constants.successful then

560: pv_return_code => lv_return_code ,
561: pv_return_message => lv_return_message
562: );
563:
564: IF lv_return_code <> jai_constants.successful then
565: RAISE le_error;
566: END IF;
567:
568: END IF ;

Line 580: IF lv_return_code <> jai_constants.successful then

576: pv_return_code => lv_return_code ,
577: pv_return_message => lv_return_message
578: );
579:
580: IF lv_return_code <> jai_constants.successful then
581: RAISE le_error;
582: END IF;
583:
584: END IF ;

Line 596: IF lv_return_code <> jai_constants.successful then

592: pv_return_code => lv_return_code ,
593: pv_return_message => lv_return_message
594: );
595:
596: IF lv_return_code <> jai_constants.successful then
597: RAISE le_error;
598: END IF;
599:
600: END IF ;

Line 615: IF lv_return_code <> jai_constants.successful then

611: pv_action => lv_action ,
612: pv_return_code => lv_return_code ,
613: pv_return_message => lv_return_message
614: );
615: IF lv_return_code <> jai_constants.successful then
616: RAISE le_error;
617: END IF;
618: END IF ;
619: -----------------------------------------------------------------------------------------------

Line 637: IF lv_return_code <> jai_constants.successful then

633: pv_return_code => lv_return_code ,
634: pv_return_message => lv_return_message
635: );
636:
637: IF lv_return_code <> jai_constants.successful then
638: RAISE le_error;
639: END IF;
640:
641: END IF ;

Line 658: IF lv_return_code <> jai_constants.successful then

654: pv_return_code => lv_return_code ,
655: pv_return_message => lv_return_message
656: );
657:
658: IF lv_return_code <> jai_constants.successful then
659: RAISE le_error;
660: END IF;
661:
662: END IF ;

Line 674: IF lv_return_code <> jai_constants.successful then

670: pv_return_code => lv_return_code ,
671: pv_return_message => lv_return_message
672: );
673:
674: IF lv_return_code <> jai_constants.successful then
675: RAISE le_error;
676: END IF;
677:
678: END IF ;

Line 694: IF lv_return_code <> jai_constants.successful then

690: pv_return_code => lv_return_code ,
691: pv_return_message => lv_return_message
692: );
693:
694: IF lv_return_code <> jai_constants.successful then
695: RAISE le_error;
696: END IF;
697:
698: END IF ;