DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 401: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

397: );
398:
399: if nvl(lv_process_flag, 'N') = 'E' then
400: raise_application_error(-20007,
401: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
402: end if;
403:
404: else
405: /* Bug 5640993 FP of 5553489. Added by JMEENA

Line 429: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

425: );
426:
427: if nvl(lv_process_flag, 'N') = 'E' then
428: raise_application_error(-20008,
429: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
430: end if;
431: END IF ; --End of bug#5640993
432:
433: end if; --Transactions in new regime

Line 453: be populated in the attribute columns of ap_invoice_distributions_all table

449:
450: 2. 11/05/2005 rchandan for bug#4333488. Version 116.1
451: The Invoice Distribution DFF is eliminated and a new global DFF is used to
452: maintain the functionality. From now the TDS tax, WCT tax and ESSI will not
453: be populated in the attribute columns of ap_invoice_distributions_all table
454: instead these will be populated in the global attribute columns. So the code changes are
455: made accordingly.
456:
457: 3. 24/05/2005 Ramananda for bug# 4388958 File Version: 116.1

Line 609: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

605: );
606:
607: if nvl(lv_process_flag, 'N') = 'E' then
608: /* raise_application_error(-20004,
609: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
610: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
611: end if;
612:
613:

Line 610: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;

606:
607: if nvl(lv_process_flag, 'N') = 'E' then
608: /* raise_application_error(-20004,
609: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
610: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_codepath ; return ;
611: end if;
612:
613:
614: if pr_new.global_attribute1 is null and ln_final_tds_tax_id is not null then /*rchandan for bug#4333488*/

Line 664: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

660: );
661:
662: if nvl(lv_process_flag, 'N') = 'E' then
663: /* raise_application_error(-20005,
664: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
665: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
666: end if;
667:
668: if lv_is_invoice_validated = 'Y' then

Line 665: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

661:
662: if nvl(lv_process_flag, 'N') = 'E' then
663: /* raise_application_error(-20005,
664: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
665: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
666: end if;
667:
668: if lv_is_invoice_validated = 'Y' then
669:

Line 690: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

686: );
687:
688: if nvl(lv_process_flag, 'N') = 'E' then
689: /* raise_application_error(-20006,
690: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
691: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
692: end if;
693:
694: end if; --moved this from below for Bug#7433241

Line 691: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

687:
688: if nvl(lv_process_flag, 'N') = 'E' then
689: /* raise_application_error(-20006,
690: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
691: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
692: end if;
693:
694: end if; --moved this from below for Bug#7433241
695:

Line 777: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

773: );
774:
775: if nvl(lv_process_flag, 'N') = 'E' then
776: raise_application_error(-20005,
777: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
778: end if;
779:
780: IF lv_is_invoice_validated = 'N' THEN
781: RETURN;

Line 837: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

833: );
834:
835: if nvl(lv_process_flag, 'N') = 'E' then
836: -- raise_application_error(-20007,
837: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
838: pv_return_code := jai_constants.expected_error ;
839: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
840: return ;
841: end if;

Line 839: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

835: if nvl(lv_process_flag, 'N') = 'E' then
836: -- raise_application_error(-20007,
837: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
838: pv_return_code := jai_constants.expected_error ;
839: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
840: return ;
841: end if;
842:
843: else

Line 864: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);

860: );
861:
862: if nvl(lv_process_flag, 'N') = 'E' then
863: --raise_application_error(-20008,
864: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
865: pv_return_code := jai_constants.expected_error ;
866: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
867: return ;
868: end if;

Line 866: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;

862: if nvl(lv_process_flag, 'N') = 'E' then
863: --raise_application_error(-20008,
864: --'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message);
865: pv_return_code := jai_constants.expected_error ;
866: pv_return_message := 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ;
867: return ;
868: end if;
869:
870:

Line 909: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=

905: );
906:
907: if nvl(lv_process_flag, 'N') = 'E' then
908: /* raise_application_error(-20009,
909: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
910: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
911: end if;
912:
913: end if; /* Deleting */

Line 910: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;

906:
907: if nvl(lv_process_flag, 'N') = 'E' then
908: /* raise_application_error(-20009,
909: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message :=
910: 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || lv_process_message ; return ;
911: end if;
912:
913: end if; /* Deleting */
914:

Line 918: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);

914:
915:
916: exception
917: when others then
918: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
919: Pv_return_code := jai_constants.unexpected_error;
920: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||
921: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
922:

Line 921: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);

917: when others then
918: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
919: Pv_return_code := jai_constants.unexpected_error;
920: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||
921: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
922:
923: END BRIUD_T1 ;
924:
925: END JAI_AP_IDA_TRIGGER_PKG ;