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_PKG dependencies on JAI_AP_IDA_TRIGGER_PKG

Line 1: PACKAGE BODY JAI_AP_IDA_TRIGGER_PKG AS

1: PACKAGE BODY JAI_AP_IDA_TRIGGER_PKG AS
2: /* $Header: jai_ap_ida_t.plb 120.48.12020000.9 2013/03/08 11:13:31 vkaranam ship $ */
3: /*
4: REM +======================================================================+
5: REM NAME ARUID_T1

Line 358: Modified the jai_ap_ida_trigger_pkg.process_ipv (cursor get_rcv_tax_amt).

354: Hence the receipt tax amount retrieved is null ,due to which ERV tax amount
355: is null and the accounting didnt happen for the ERV line
356:
357: fix :
358: Modified the jai_ap_ida_trigger_pkg.process_ipv (cursor get_rcv_tax_amt).
359: also for receipt exchange rate is fetched from rcv_transactions instead
360: of PO document.
361:
362: 18. 6-FEB-2012 Xin Modified for Bug 13540555

Line 1291: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside call to process_ipv');

1287:
1288: BEGIN
1289: ln_user_id := fnd_global.user_id;
1290: ln_login_id := fnd_global.login_id;
1291: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside call to process_ipv');
1292: if pr_new.line_type_lookup_code ='IPV'
1293: then
1294: for jai_rec in get_loc_tax(pr_new.invoice_id,pr_new.related_id)
1295: loop

Line 1297: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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 );

1293: then
1294: for jai_rec in get_loc_tax(pr_new.invoice_id,pr_new.related_id)
1295: loop
1296:
1297: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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 );
1298: ln_invline_amt :=0;
1299: ln_tax_variance_amt:=0;
1300: ln_base_variance_amt := nvl(pr_new.amount,0);
1301: ln_distribution_lineno :=0;

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

1310:
1311: --start additions for bug#13422310 ,29dec
1312: v_apportn_factor_for_item_line:=null;
1313: ln_src_tax_amt:=null;
1314: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv SHIPMENT line id '||jai_rec.shipment_line_id||' line_location_id '||jai_rec.line_location_id);
1315: --if jai_rec.shipment_line_id is not null 13618731
1316: if jai_rec.rcv_transaction_id is not null
1317: then
1318: open get_rcv_tax_amt(jai_rec.rcv_transaction_id ,jai_rec.tax_id);--13618731

Line 1326: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);

1322: open get_po_tax_amt(jai_rec.line_location_id ,jai_rec.tax_id);
1323: fetch get_po_tax_amt into ln_src_tax_amt;
1324: close get_po_tax_amt;
1325: end if;
1326: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1327: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
1328: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
1329: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
1330: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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 1329: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);

1325: end if;
1326: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1327: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
1328: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
1329: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
1330: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1331: --calculate the tax variance amount
1332: --ipv_tax_variance_amt := invoice amount-po_amount ;
1333:

Line 1330: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);

1326: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1327: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number,'QUANTITY');
1328: ln_src_tax_amt := nvl(ln_src_tax_amt,0)*v_apportn_factor_for_item_line; --30dec
1329: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_src_tax_amt after apportiong '||ln_src_tax_amt);
1330: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1331: --calculate the tax variance amount
1332: --ipv_tax_variance_amt := invoice amount-po_amount ;
1333:
1334: --ln_tax_variance_amt :=ln_base_variance_amt *nvl(jai_rec.tax_amount,0)/ln_invline_amt ; commented on 29dec for bug#13422310

Line 1338: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_tax_variance_amt '||ln_tax_variance_amt);

1334: --ln_tax_variance_amt :=ln_base_variance_amt *nvl(jai_rec.tax_amount,0)/ln_invline_amt ; commented on 29dec for bug#13422310
1335: -- ln_tax_variance_amt := ln_src_tax_amt-nvl(jai_rec.tax_amount,0); 30 dec
1336: ln_tax_variance_amt := nvl(jai_rec.tax_amount,0)-ln_src_tax_amt; --13422310 ,30dec
1337:
1338: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_tax_variance_amt '||ln_tax_variance_amt);
1339: --end additions for bug#13422310 ,29dec
1340: if nvl(ln_tax_variance_amt,0)<>0
1341: then
1342:

Line 1346: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');

1342:
1343: open c_get_invoice_distribution;
1344: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
1345: close c_get_invoice_distribution;
1346: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');
1347: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
1348: fetch get_dist_no into ln_distribution_lineno;
1349: close get_dist_no;
1350: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);

Line 1350: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);

1346: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');
1347: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
1348: fetch get_dist_no into ln_distribution_lineno;
1349: close get_dist_no;
1350: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv ln_distribution_lineno '||ln_distribution_lineno);
1351: open get_tax_name(jai_rec.tax_id);
1352: fetch get_tax_name into lv_tax_name;
1353: close get_tax_name;
1354:

Line 1471: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');

1467:
1468: open c_get_invoice_distribution;
1469: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
1470: close c_get_invoice_distribution;
1471: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');
1472:
1473:
1474:
1475: open c_get_accrual_acct (pr_new.invoice_id,jai_rec.parent_invoice_distribution_id);

Line 1606: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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 );

1602: ln_po_exchrate := 0;
1603: ln_invoice_rate :=0;
1604: ln_distribution_lineno :=0;
1605:
1606: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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 );
1607: OPEN get_invoice_rate(pr_new.invoice_id);
1608: fetch get_invoice_rate into ln_invoice_rate;
1609: close get_invoice_rate;
1610:

Line 1614: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);

1610:
1611: OPEN get_po_rate(jai_rec.po_header_id);
1612: fetch get_po_rate into ln_po_exchrate;
1613: close get_po_rate;
1614: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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);
1615:
1616: --calculate the tax exchange variance amount
1617: --exchange_rate_variance_amount := taxamount_in_usd *(Invoice_exchange_rate-po_exchange_rate);
1618: /*issue mentioned by the ct:

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

1647: --added for bug#13618731
1648: OPEN get_rcv_rate(jai_rec.rcv_transaction_id);
1649: fetch get_rcv_rate into ln_po_exchrate;
1650: close get_rcv_rate;
1651: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','receipt exchange rate '||ln_po_exchrate||' receipt tax amount '||ln_src_tax_amt);--13618731
1652:
1653: elsif jai_rec.line_location_id is not null then
1654: open get_po_tax_amt(jai_rec.line_location_id ,jai_rec.tax_id);
1655: fetch get_po_tax_amt into ln_src_tax_amt;

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

1657:
1658: OPEN get_po_rate(jai_rec.po_header_id);
1659: fetch get_po_rate into ln_po_exchrate;
1660: close get_po_rate;
1661: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','po exchange rate '||ln_po_exchrate||' po tax amount '||ln_src_tax_amt);--13618731
1662: end if;
1663: --end bug#13422310 ,30dec
1664: --Start additions for bug#13422310 ,18dec
1665: v_apportn_factor_for_item_line := jai_ap_utils_pkg.get_apportion_factor(pr_new.invoice_id,pr_new.invoice_line_number, 'QUANTITY');

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

1668:
1669: --ln_tax_excvariance_amt :=nvl(jai_rec.tax_amount,0) *(nvl(ln_invoice_rate,0)-nvl(ln_po_exchrate,0)); 18dec
1670: ln_tax_excvariance_amt :=nvl(ln_po_amount,0) *(nvl(ln_invoice_rate,0)-nvl(ln_po_exchrate,0));--18dec
1671: --start changes for 13422310 --14dec
1672: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV nvl(jai_rec.tax_amount,0) '||nvl(jai_rec.tax_amount,0)||' ln_tax_excvariance_amt '||ln_tax_excvariance_amt);
1673: if nvl(ln_tax_excvariance_amt,0)<>0
1674: then
1675:
1676: ln_xrate_gain_ccid :=null;

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

1686: else
1687: ln_erv_ccid := ln_xrate_loss_ccid;
1688: end if;
1689:
1690: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
1691: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
1692: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
1693: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
1694:

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

1687: ln_erv_ccid := ln_xrate_loss_ccid;
1688: end if;
1689:
1690: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
1691: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
1692: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
1693: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
1694:
1695: --end changes for 13422310 --14dec

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

1688: end if;
1689:
1690: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
1691: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
1692: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
1693: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
1694:
1695: --end changes for 13422310 --14dec
1696: open c_get_invoice_distribution;

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

1689:
1690: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange gain ccid '||ln_xrate_gain_ccid);
1691: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange loss ccid '||ln_xrate_loss_ccid);
1692: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV CCID Derived is '||ln_erv_ccid);
1693: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV exchange_rate_variance_amount '||ln_tax_excvariance_amt);
1694:
1695: --end changes for 13422310 --14dec
1696: open c_get_invoice_distribution;
1697: fetch c_get_invoice_distribution into ln_invoice_distribution_id;

Line 1699: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV BEFORE get_dist_no ');

1695: --end changes for 13422310 --14dec
1696: open c_get_invoice_distribution;
1697: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
1698: close c_get_invoice_distribution;
1699: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV BEFORE get_dist_no ');
1700: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
1701: fetch get_dist_no into ln_distribution_lineno;
1702: close get_dist_no;
1703:

Line 1704: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV ln_distribution_lineno ' ||ln_distribution_lineno);

1700: open get_dist_no(pr_new.invoice_id,jai_rec.invoice_line_number);
1701: fetch get_dist_no into ln_distribution_lineno;
1702: close get_dist_no;
1703:
1704: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV ln_distribution_lineno ' ||ln_distribution_lineno);
1705:
1706: open get_tax_name(jai_rec.tax_id);
1707: fetch get_tax_name into lv_tax_name;
1708: close get_tax_name;

Line 1826: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');

1822:
1823: open c_get_invoice_distribution;
1824: fetch c_get_invoice_distribution into ln_invoice_distribution_id;
1825: close c_get_invoice_distribution;
1826: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ipv before get_dist_no ');
1827:
1828:
1829:
1830: open c_get_accrual_acct (pr_new.invoice_id,jai_rec.parent_invoice_distribution_id);

Line 1946: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV after update');

1942:
1943:
1944: commit;
1945:
1946: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','inside ERV after update');
1947:
1948: end if;--if nvl(ln_tax_variance_amt,0)<>0
1949:
1950: end loop;

Line 2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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'));

2096: A for distributions that have been tested and validated,
2097: S for distributions that have been selected for validation
2098: */
2099:
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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'));
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
2102: if pv_action = jai_constants.inserting
2103: 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'))
2104: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )

Line 2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);

2097: S for distributions that have been selected for validation
2098: */
2099:
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_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'));
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','pr_new.line_type_lookup_code '||pr_new.line_type_lookup_code);
2102: if pv_action = jai_constants.inserting
2103: 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'))
2104: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
2105: then

Line 2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','before call to process_ipv');

2102: if pv_action = jai_constants.inserting
2103: 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'))
2104: AND ( pr_new.line_type_lookup_code ='IPV' or pr_new.line_type_lookup_code ='ERV' )
2105: then
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_ida_trigger_pkg.briud','before call to process_ipv');
2107: process_ipv;
2108: end if;
2109:
2110: --end additions for bug#13422310

Line 2614: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||

2610: exception
2611: when others then
2612: --raise_application_error(-20010, 'Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : ' || sqlerrm);
2613: Pv_return_code := jai_constants.unexpected_error;
2614: Pv_return_message := 'Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1 ' ||
2615: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
2616:
2617: END BRIUD_T1 ;
2618:

Line 2619: END JAI_AP_IDA_TRIGGER_PKG ;

2615: 'Error on ap_invoice_distributions_all : ' || substr(sqlerrm,1,1900);
2616:
2617: END BRIUD_T1 ;
2618:
2619: END JAI_AP_IDA_TRIGGER_PKG ;