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_MATCH_TAX_PKG dependencies on JAI_CMN_UTILS_PKG

Line 2131: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside procedure process online');

2127: -- end added by bug#3206083
2128:
2129: ln_user_id := fnd_global.user_id;
2130: ln_login_id := fnd_global.login_id;
2131: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside procedure process online');
2132: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id is '||inv_id);
2133: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line number is '||pn_invoice_line_number);
2134:
2135: Open get_discard_info (inv_id); --Added by nprashar for bug # 12832424

Line 2132: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id is '||inv_id);

2128:
2129: ln_user_id := fnd_global.user_id;
2130: ln_login_id := fnd_global.login_id;
2131: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside procedure process online');
2132: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id is '||inv_id);
2133: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line number is '||pn_invoice_line_number);
2134:
2135: Open get_discard_info (inv_id); --Added by nprashar for bug # 12832424
2136: Fetch get_discard_info into lv_discard_flag;

Line 2133: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line number is '||pn_invoice_line_number);

2129: ln_user_id := fnd_global.user_id;
2130: ln_login_id := fnd_global.login_id;
2131: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside procedure process online');
2132: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id is '||inv_id);
2133: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line number is '||pn_invoice_line_number);
2134:
2135: Open get_discard_info (inv_id); --Added by nprashar for bug # 12832424
2136: Fetch get_discard_info into lv_discard_flag;
2137: Close get_discard_info;

Line 2143: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of disacrd flag is'||lv_discard_flag);

2139: Open c_get_ap_invoice_src (inv_id); --Added by nprashar for bug # 12832424 to check value of source
2140: Fetch c_get_ap_invoice_src into ln_source;
2141: Close c_get_ap_invoice_src;
2142:
2143: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of disacrd flag is'||lv_discard_flag);
2144:
2145: If lv_discard_flag = 'Y' and ln_source <> 'ERS' then -- Main code starts for bug # 12832424
2146: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside condition of the discard flag');
2147: For ident_rec in c_match_tax_lines ( inv_id)

Line 2146: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside condition of the discard flag');

2142:
2143: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of disacrd flag is'||lv_discard_flag);
2144:
2145: If lv_discard_flag = 'Y' and ln_source <> 'ERS' then -- Main code starts for bug # 12832424
2146: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside condition of the discard flag');
2147: For ident_rec in c_match_tax_lines ( inv_id)
2148: Loop
2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);

Line 2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');

2145: If lv_discard_flag = 'Y' and ln_source <> 'ERS' then -- Main code starts for bug # 12832424
2146: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside condition of the discard flag');
2147: For ident_rec in c_match_tax_lines ( inv_id)
2148: Loop
2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);

Line 2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);

2146: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Inside condition of the discard flag');
2147: For ident_rec in c_match_tax_lines ( inv_id)
2148: Loop
2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2154:

Line 2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);

2147: For ident_rec in c_match_tax_lines ( inv_id)
2148: Loop
2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2154:
2155: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;

Line 2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);

2148: Loop
2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2154:
2155: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;
2156:

Line 2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);

2149: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Working on the follwoing tax lines');
2150: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2154:
2155: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;
2156:
2157: For ins_reverse_dist_lines in c_inv_dist_tax_lines ( ident_rec.invoice_id, ident_rec.invoice_distribution_id)

Line 2159: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going inside Loop of reversal');

2155: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;
2156:
2157: For ins_reverse_dist_lines in c_inv_dist_tax_lines ( ident_rec.invoice_id, ident_rec.invoice_distribution_id)
2158: Loop
2159: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going inside Loop of reversal');
2160: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2161: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2162:
2163:

Line 2160: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);

2156:
2157: For ins_reverse_dist_lines in c_inv_dist_tax_lines ( ident_rec.invoice_id, ident_rec.invoice_distribution_id)
2158: Loop
2159: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going inside Loop of reversal');
2160: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2161: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2162:
2163:
2164: ln_invoice_distribution_no := ins_reverse_dist_lines.distribution_line_number + 1;

Line 2161: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);

2157: For ins_reverse_dist_lines in c_inv_dist_tax_lines ( ident_rec.invoice_id, ident_rec.invoice_distribution_id)
2158: Loop
2159: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going inside Loop of reversal');
2160: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_id'||ident_rec.invoice_id);
2161: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2162:
2163:
2164: ln_invoice_distribution_no := ins_reverse_dist_lines.distribution_line_number + 1;
2165:

Line 2281: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','processed line numbebr'||ident_rec.invoice_line_number);

2277: Where invoice_id = ident_rec.invoice_id
2278: and line_number = ident_rec.invoice_line_number
2279: and line_type_lookup_code = 'MISCELLANEOUS';
2280:
2281: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','processed line numbebr'||ident_rec.invoice_line_number);
2282:
2283: Commit;
2284: End Loop;
2285: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going to end of program'); --Added by nprashar for bug# 13446095

Line 2285: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going to end of program'); --Added by nprashar for bug# 13446095

2281: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','processed line numbebr'||ident_rec.invoice_line_number);
2282:
2283: Commit;
2284: End Loop;
2285: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going to end of program'); --Added by nprashar for bug# 13446095
2286: goto end_of_program ; --code should be exited from this point, as further processing is not required --Added by nprashar for bug # 13446095
2287: Elsif lv_discard_flag = 'Y' and ln_source = 'ERS' Then
2288: For ins_reverse_dist_lines_ers in c_inv_dist_tax_lines_ers ( inv_id , po_dist_id)
2289: Loop

Line 2407: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going to end of program');

2403: and line_type_lookup_code = 'MISCELLANEOUS';
2404:
2405: Commit;
2406: End Loop;
2407: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going to end of program');
2408: goto end_of_program ; --code should be exited from this point, as further processing is not required
2409: End If;
2410:
2411: