eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_AP_IDA_TRIGGER_DTC_PKG

Line 1: PACKAGE BODY JAI_AP_IDA_TRIGGER_DTC_PKG AS

1: PACKAGE BODY JAI_AP_IDA_TRIGGER_DTC_PKG AS
2: /* $Header: jai_ap_ida_dtc_t.plb 120.0.12020000.2 2013/03/19 00:21:58 vkaranam noship $ */
3: /*
4: REM +======================================================================+
5: REM NAME BRIUD_DTC_T1

Line 428: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside call to process_ipv');

424:
425: BEGIN
426: ln_user_id := fnd_global.user_id;
427: ln_login_id := fnd_global.login_id;
428: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside call to process_ipv');
429: if pr_new.line_type_lookup_code ='IPV'
430: then
431: for jai_rec in get_loc_tax(pr_new.invoice_id,pr_new.related_id)
432: loop

Line 434: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv pr_new.invoice_id '||pr_new.invoice_id||'pr_new.related_id '||pr_new.related_id||'pr_new.invoice_line_number '||pr_new.invoice_line_number );

430: then
431: for jai_rec in get_loc_tax(pr_new.invoice_id,pr_new.related_id)
432: loop
433:
434: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv pr_new.invoice_id '||pr_new.invoice_id||'pr_new.related_id '||pr_new.related_id||'pr_new.invoice_line_number '||pr_new.invoice_line_number );
435: ln_invline_amt :=0;
436: ln_tax_variance_amt:=0;
437: ln_base_variance_amt := nvl(pr_new.amount,0);
438: ln_distribution_lineno :=0;

Line 451: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv SHIPMENT line id '||jai_rec.shipment_line_id||' line_location_id '||jai_rec.line_location_id);

447:
448: --start additions for bug#13422310 ,29dec
449: v_apportn_factor_for_item_line:=null;
450: ln_src_tax_amt:=null;
451: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv SHIPMENT line id '||jai_rec.shipment_line_id||' line_location_id '||jai_rec.line_location_id);
452: --if jai_rec.shipment_line_id is not null 13618731
453: if jai_rec.rcv_transaction_id is not null
454: then
455: open get_rcv_tax_amt(jai_rec.rcv_transaction_id ,jai_rec.tax_id);--13618731

Line 463: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt before apportiong '||ln_src_tax_amt|| ' v_apportn_factor_for_item_line '||v_apportn_factor_for_item_line);

459: open get_po_tax_amt(jai_rec.line_location_id ,jai_rec.tax_id);
460: fetch get_po_tax_amt into ln_src_tax_amt;
461: close get_po_tax_amt;
462: end if;
463: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt before apportiong '||ln_src_tax_amt|| ' v_apportn_factor_for_item_line '||v_apportn_factor_for_item_line);
464: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
465: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
466: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
467: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_base_variance_amt '||ln_base_variance_amt||' nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||'ln_invline_amt '||ln_invline_amt);

Line 466: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);

462: end if;
463: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt before apportiong '||ln_src_tax_amt|| ' v_apportn_factor_for_item_line '||v_apportn_factor_for_item_line);
464: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
465: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
466: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
467: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_base_variance_amt '||ln_base_variance_amt||' nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||'ln_invline_amt '||ln_invline_amt);
468: --calculate the tax variance amount
469: --ipv_tax_variance_amt := invoice amount-po_amount ;
470:

Line 467: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_base_variance_amt '||ln_base_variance_amt||' nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||'ln_invline_amt '||ln_invline_amt);

463: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt before apportiong '||ln_src_tax_amt|| ' v_apportn_factor_for_item_line '||v_apportn_factor_for_item_line);
464: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
465: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
466: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
467: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_base_variance_amt '||ln_base_variance_amt||' nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||'ln_invline_amt '||ln_invline_amt);
468: --calculate the tax variance amount
469: --ipv_tax_variance_amt := invoice amount-po_amount ;
470:
471: --ln_tax_variance_amt :=ln_base_variance_amt *nvl(jai_rec.tax_amount,0)/ln_invline_amt ; commented on 29dec for bug#13422310

Line 475: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_tax_variance_amt '||ln_tax_variance_amt);

471: --ln_tax_variance_amt :=ln_base_variance_amt *nvl(jai_rec.tax_amount,0)/ln_invline_amt ; commented on 29dec for bug#13422310
472: -- ln_tax_variance_amt := ln_src_tax_amt-nvl(jai_rec.tax_amount,0); 30 dec
473: ln_tax_variance_amt := nvl(jai_rec.tax_amount,0)-ln_src_tax_amt; --13422310 ,30dec
474:
475: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_tax_variance_amt '||ln_tax_variance_amt);
476: --end additions for bug#13422310 ,29dec
477: if nvl(ln_tax_variance_amt,0)<>0
478: then
479:

Line 483: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv before get_dist_no ');

479:
480: open c_get_invoice_distribution;
481: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
482: close c_get_invoice_distribution;
483: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv before get_dist_no ');
484: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
485: fetch get_dist_no into ln_distribution_lineno;
486: close get_dist_no;
487: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);

Line 487: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);

483: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv before get_dist_no ');
484: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
485: fetch get_dist_no into ln_distribution_lineno;
486: close get_dist_no;
487: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);
488: open get_tax_name(jai_rec.tax_id);
489: fetch get_tax_name into lv_tax_name;
490: close get_tax_name;
491:

Line 743: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV pr_new.invoice_id '||pr_new.invoice_id||'pr_new.related_id '||pr_new.related_id||'pr_new.invoice_line_number '||pr_new.invoice_line_number );

739: ln_po_exchrate := 0;
740: ln_invoice_rate :=0;
741: ln_distribution_lineno :=0;
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV pr_new.invoice_id '||pr_new.invoice_id||'pr_new.related_id '||pr_new.related_id||'pr_new.invoice_line_number '||pr_new.invoice_line_number );
744: OPEN get_invoice_rate(pr_new.invoice_id);
745: fetch get_invoice_rate into ln_invoice_rate;
746: close get_invoice_rate;
747: /*moved the call inside the if rcv_transaction_id is null condition*

Line 751: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV ln_invoice_rate '||ln_invoice_rate||' jai_rec.po_header_id '||jai_rec.po_header_id||' ln_po_exchrate '||ln_po_exchrate);

747: /*moved the call inside the if rcv_transaction_id is null condition*
748: OPEN get_po_rate(jai_rec.po_header_id);
749: fetch get_po_rate into ln_po_exchrate;
750: close get_po_rate;*/
751: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV ln_invoice_rate '||ln_invoice_rate||' jai_rec.po_header_id '||jai_rec.po_header_id||' ln_po_exchrate '||ln_po_exchrate);
752:
753: --calculate the tax exchange variance amount
754: --exchange_rate_variance_amount := taxamount_in_usd *(Invoice_exchange_rate-po_exchange_rate);
755: /*issue mentioned by the ct:

Line 788: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','receipt exchange rate '||ln_po_exchrate||' receipt tax amount '||ln_src_tax_amt);--13618731

784: --added for bug#13618731
785: OPEN get_rcv_rate(jai_rec.rcv_transaction_id);
786: fetch get_rcv_rate into ln_po_exchrate;
787: close get_rcv_rate;
788: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','receipt exchange rate '||ln_po_exchrate||' receipt tax amount '||ln_src_tax_amt);--13618731
789:
790: elsif jai_rec.line_location_id is not null then
791: open get_po_tax_amt(jai_rec.line_location_id ,jai_rec.tax_id);
792: fetch get_po_tax_amt into ln_src_tax_amt;

Line 798: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','po exchange rate '||ln_po_exchrate||' po tax amount '||ln_src_tax_amt);--13618731

794:
795: OPEN get_po_rate(jai_rec.po_header_id);
796: fetch get_po_rate into ln_po_exchrate;
797: close get_po_rate;
798: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','po exchange rate '||ln_po_exchrate||' po tax amount '||ln_src_tax_amt);--13618731
799: end if;
800: --end bug#13422310 ,30dec
801: --Start additions for bug#13422310 ,18dec
802: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number, 'QUANTITY');

Line 809: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||' ln_tax_excvariance_amt '||ln_tax_excvariance_amt);

805:
806: --ln_tax_excvariance_amt :=nvl(jai_rec.tax_amount,0) *(nvl(ln_invoice_rate,0)-nvl(ln_po_exchrate,0)); 18dec
807: ln_tax_excvariance_amt :=nvl(ln_po_amount,0) *(nvl(ln_invoice_rate,0)-nvl(ln_po_exchrate,0));--18dec
808: --start changes for 13422310 --14dec
809: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||' ln_tax_excvariance_amt '||ln_tax_excvariance_amt);
810: if nvl(ln_tax_excvariance_amt,0)<>0
811: then
812:
813: ln_xrate_gain_ccid :=null;

Line 827: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);

823: else
824: ln_erv_ccid := ln_xrate_loss_ccid;
825: end if;
826:
827: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
828: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
829: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
830: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
831:

Line 828: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);

824: ln_erv_ccid := ln_xrate_loss_ccid;
825: end if;
826:
827: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
828: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
829: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
830: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
831:
832: --end changes for 13422310 --14dec

Line 829: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);

825: end if;
826:
827: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
828: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
829: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
830: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
831:
832: --end changes for 13422310 --14dec
833: open c_get_invoice_distribution;

Line 830: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);

826:
827: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
828: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
829: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
830: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
831:
832: --end changes for 13422310 --14dec
833: open c_get_invoice_distribution;
834: fetch c_get_invoice_distribution into ln_invoice_distribution_id;

Line 836: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV BEFORE get_dist_no ');

832: --end changes for 13422310 --14dec
833: open c_get_invoice_distribution;
834: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
835: close c_get_invoice_distribution;
836: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV BEFORE get_dist_no ');
837: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
838: fetch get_dist_no into ln_distribution_lineno;
839: close get_dist_no;
840:

Line 841: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV ln_distribution_lineno ' ||ln_distribution_lineno);

837: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
838: fetch get_dist_no into ln_distribution_lineno;
839: close get_dist_no;
840:
841: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','inside ERV ln_distribution_lineno ' ||ln_distribution_lineno);
842:
843: open get_tax_name(jai_rec.tax_id);
844: fetch get_tax_name into lv_tax_name;
845: close get_tax_name;

Line 1273: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud',' pv_action '||pv_action||' nvl(pr_old.match_status_flag,Q) '||nvl(pr_old.match_status_flag,'Q')||' nvl(pr_new.match_status_flag,Q) '||nvl(pr_new.match_status_flag,'Q'));

1269: A for distributions that have been tested and validated,
1270: S for distributions that have been selected for validation
1271: */
1272:
1273: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud',' pv_action '||pv_action||' nvl(pr_old.match_status_flag,Q) '||nvl(pr_old.match_status_flag,'Q')||' nvl(pr_new.match_status_flag,Q) '||nvl(pr_new.match_status_flag,'Q'));
1274: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
1275: if pv_action = jai_constants.inserting
1276: AND ( nvl(pr_old.match_status_flag,'Q')<> nvl(pr_new.match_status_flag,'Q') and nvl(pr_new.match_status_flag,'Q') IN ('N'))
1277: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )

Line 1274: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);

1270: S for distributions that have been selected for validation
1271: */
1272:
1273: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud',' pv_action '||pv_action||' nvl(pr_old.match_status_flag,Q) '||nvl(pr_old.match_status_flag,'Q')||' nvl(pr_new.match_status_flag,Q) '||nvl(pr_new.match_status_flag,'Q'));
1274: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
1275: if pv_action = jai_constants.inserting
1276: AND ( nvl(pr_old.match_status_flag,'Q')<> nvl(pr_new.match_status_flag,'Q') and nvl(pr_new.match_status_flag,'Q') IN ('N'))
1277: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
1278: then

Line 1279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','before call to process_ipv');

1275: if pv_action = jai_constants.inserting
1276: AND ( nvl(pr_old.match_status_flag,'Q')<> nvl(pr_new.match_status_flag,'Q') and nvl(pr_new.match_status_flag,'Q') IN ('N'))
1277: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
1278: then
1279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_dtc_pkg.briud','before call to process_ipv');
1280: process_ipv;
1281: end if;
1282:
1283: --end additions for bug#13422310

Line 1815: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 ' ||

1811: exception
1812: when others then
1813: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
1814: Pv_return_code := jai_constants.unexpected_error;
1815: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 ' ||
1816: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
1817:
1818: END BRIUD_DTC_T1 ;
1819:

Line 1820: END JAI_AP_IDA_TRIGGER_DTC_PKG ;

1816: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
1817:
1818: END BRIUD_DTC_T1 ;
1819:
1820: END JAI_AP_IDA_TRIGGER_DTC_PKG ;