[Home] [Help]
152: 21. 13-Jan-2006 Bug 4943949 Added by Lakshmi Gopalsami 120.13
153: Issue:
154: ------
155: Wrong number of arguments while trying to validate
156: the standard invoice. This is due to the parameter
157: P_FUNDS_RETURN_CODE added by base in ap_approval_pkg.
158:
159: Fix:
160: ----
249: Fix : Avoided calling the get_rnded_value function for the vendor credit memo in case of foreign currency. also took care to convert hte INR value of tax to
250: foreign currency only after the rounding is completed for the INR tax amount by calling the get_rnded_value function.
251:
252: 35. 09-Dec-2009 Bgowrava for Bug#9186263, File version 120.16.12000000.24, 120.26.12010000.16, 120.43
253: Issue : INVOICE DATE ON RTN STANDARD INVOICE SHOULD BE GL DATE OF PREPAYMENT APPLICATION
254: Fix : Modified the value passed to the parameter invoice_date to ld_acoounting_date instead of the invoice date of the base invoice.
255:
256:
257: 36. 13-Jan-2010 Xiao for Bug#7154864
313: 44. 14-Jan-2010 Jia For Bug#7431371, related 11i bug#7419533
314: Issue: FINANCIALS FOR INDIA -TDS NOT WORKING IN CASE OF MULTIPLE DISTRIBUTIONS
315: Fixed:
316: 1) Modified the code in process get_prepay_invoice_amt.
317: Handled the case where a prepayment that is getting applied on the standard invoice had a 0% TDS
318: tax atttached, in which case the TDS on the standard invoice should deduct TDS on difference of
319: std invoice amount and prepayment invoice amount.
320: 2) Modified the code in process process_tds_at_inv_validate.
321: Added code in process_tds_at_inv_validate to apply the prepayment amount increamently
314: Issue: FINANCIALS FOR INDIA -TDS NOT WORKING IN CASE OF MULTIPLE DISTRIBUTIONS
315: Fixed:
316: 1) Modified the code in process get_prepay_invoice_amt.
317: Handled the case where a prepayment that is getting applied on the standard invoice had a 0% TDS
318: tax atttached, in which case the TDS on the standard invoice should deduct TDS on difference of
319: std invoice amount and prepayment invoice amount.
320: 2) Modified the code in process process_tds_at_inv_validate.
321: Added code in process_tds_at_inv_validate to apply the prepayment amount increamently
322: in all the distribution lines, till there is sufficient amount left in prepayment to be applied.
320: 2) Modified the code in process process_tds_at_inv_validate.
321: Added code in process_tds_at_inv_validate to apply the prepayment amount increamently
322: in all the distribution lines, till there is sufficient amount left in prepayment to be applied.
323: Once the prepayment amount is completely applied, TDS or WCt or ESSI invoices get created on the
324: remaining standard invoice amount based on the TDS, WCT or ESSi tax respectively attached.
325:
326: 45. 14-Jan-2010 Jia For FP Bug#7312295
327: Issue: This is a forward port bug for the Bug#7252683.
328: Cancellation of the invoice breaching the surcharge threhsold does not cancel the surcharge invoice
366:
367: Bug 8431516 (Forward Port of 7626202)
368: -------------------------------------
369: RTN invoice would be generated to negate the effect of TDS invoice created for a prepayment, when the prepayment
370: is applied to a standard invoice.
371:
372: 49. 30-Jun-2010 Bug 9759709
373: Issue: Wrong Liability Account is fetched for the TDS CM. If the Liability account is different from the
374: Liability account from Supplier Setup, then the account from Setup is fetched.
371:
372: 49. 30-Jun-2010 Bug 9759709
373: Issue: Wrong Liability Account is fetched for the TDS CM. If the Liability account is different from the
374: Liability account from Supplier Setup, then the account from Setup is fetched.
375: Fix: Fetched the Liability Account from Standard Invoice.
376:
377: 50. 22-Nov-2010 Bug# 10315928 by amandali
378: Description:R12 : ETDS FVU CHANGES AS NOTIFIED ON 09-OCT-2010 WRT NEW VERSION OF VALIDATION
379: Fix: Invoice Validation should fail if PAN is any of 'PANAPPLIED' or 'PANNOTAVBL' or 'PANINVALID'
410: Fix: Added the condtion nvl(consider_amt_for_tds, 'Y') = 'Y' in al the statements involving jai_ap_tds_inv_taxes table
411: in process_tds_at_inv_validate procedure to pick invoices for tds invoice generation.
412:
413: 57. 14-Oct-2011 amandali for bug 13070779
414: Description:Wrong taxable amount shown for prepayment application on unvalidated standard invoice.
415: Fix:Commented out the assignment of pn_taxable_amount to ln_invoice_Amount as it is having the total invoice amount and not the net amount.
416:
417: 58. 02-FEB-2012 mmurtuza for bug 13561970
418: Description: Threshold rollback functionality is not working properly.
441: Description:Wrong threshold transition amount when an invoice has both TDS and WCT taxes attached.
442: Fix: Added section type condition in cursor c_default_tax_id in procedure process_threshold_transition
443:
444: 64. 28-Feb-2013 mmurtuza for bug 16016037
445: Description: UNABLE TO APPLY PREPAYMENTS TO THE STANDARD INVOICES
446: Fix: Commented the condition of p_match_status_flag before checking for Holds in procedure status_update_chk_validate
447:
448: 65. 12-Mar-2013 mmurtuza for bug 16435622
449: Description: INDIA - TDS PAYMENT REVIEW DOES NOT RESTRICT THE DATA BASED ON SECTION CODE
2165:
2166: /* Invoice Numbers, type for the invoice pair that is being created */
2167: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then
2168:
2169: /* Standard invoice to TDS authority, Credit memo to supplier */
2170:
2171: lv_invoice_to_tds_type := 'STANDARD';
2172: lv_invoice_to_vendor_type := 'CREDIT';
2173: /*Bug 7410219 - Modified Invoice Number as per Section*/
2167: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then
2168:
2169: /* Standard invoice to TDS authority, Credit memo to supplier */
2170:
2171: lv_invoice_to_tds_type := 'STANDARD';
2172: lv_invoice_to_vendor_type := 'CREDIT';
2173: /*Bug 7410219 - Modified Invoice Number as per Section*/
2174: lv_invoice_to_tds_num := lv_invoice_num ||'-'||lv_section_name||'-SI-'||lv_ja_in_ap_inv_id;
2175: lv_invoice_to_vendor_num := lv_invoice_num ||'-'||lv_section_name||'-CM-'||lv_ja_in_ap_inv_id;
2178: ln_invoice_to_vendor_amount := (-1) * ln_tax_amount;
2179:
2180: elsif pv_tds_event = 'PREPAYMENT APPLICATION' OR pv_tds_event like 'THRESHOLD ROLLBACK%' then --Added by Sanjikum for Bug#5131075(4718907)
2181:
2182: /* Credit memo to TDS authority, Standard invoice to supplier */
2183: if pv_invoice_num_prepay_apply is not null then
2184: lv_invoice_num := substr(pv_invoice_num_prepay_apply, 1, 30);
2185: end if;
2186:
2184: lv_invoice_num := substr(pv_invoice_num_prepay_apply, 1, 30);
2185: end if;
2186:
2187: lv_invoice_to_tds_type := 'CREDIT';
2188: lv_invoice_to_vendor_type := 'STANDARD';
2189: /*Bug 7410219 - Modified Invoice Number as per Section*/
2190: lv_invoice_to_tds_num := lv_invoice_num ||'-RTN-'||lv_section_name||'-CM-'||lv_ja_in_ap_inv_id;
2191: lv_invoice_to_vendor_num := lv_invoice_num ||'-RTN-'||lv_section_name||'-SI-'||lv_ja_in_ap_inv_id;
2192:
2194: ln_invoice_to_vendor_amount := ln_tax_amount;
2195:
2196: elsif pv_tds_event = 'PREPAYMENT UNAPPLICATION' then
2197:
2198: /* Standard invoice to TDS authority, Credit memo to supplier */
2199: lv_invoice_to_tds_type := 'STANDARD';
2200: lv_invoice_to_vendor_type := 'CREDIT';
2201:
2202: if pv_invoice_num_to_tds_apply is not null then
2195:
2196: elsif pv_tds_event = 'PREPAYMENT UNAPPLICATION' then
2197:
2198: /* Standard invoice to TDS authority, Credit memo to supplier */
2199: lv_invoice_to_tds_type := 'STANDARD';
2200: lv_invoice_to_vendor_type := 'CREDIT';
2201:
2202: if pv_invoice_num_to_tds_apply is not null then
2203: lv_invoice_to_tds_num := 'CAN/' || substr(pv_invoice_num_to_tds_apply, 1, 45);
2217: ln_invoice_to_vendor_amount := (-1) * ln_tax_amount;
2218:
2219: elsif pv_tds_event = 'INVOICE CANCEL' then
2220:
2221: /* No invoice to TDS authority, Standard invoice to supplier */
2222:
2223: lv_invoice_to_tds_num := null;
2224:
2225: if pv_invoice_num_to_vendor_can is not null then
2229: lv_invoice_to_vendor_num := lv_invoice_num||'-CAN-'||lv_section_name||'-SI-'||lv_ja_in_ap_inv_id;
2230: end if;
2231:
2232: lv_invoice_to_tds_type := null;
2233: lv_invoice_to_vendor_type := 'STANDARD';
2234:
2235: ln_invoice_to_tds_amount := null;
2236: ln_invoice_to_vendor_amount := ln_tax_amount;
2237:
2237:
2238: /*START, Bgowrava for Bug#8254510*/
2239: elsif ( pv_tds_event = 'SURCHARGE_CALCULATE') then
2240:
2241: /* Standard invoice to TDS authority, Credit memo to supplier */
2242:
2243: lv_invoice_to_tds_type := 'STANDARD';
2244: lv_invoice_to_vendor_type := 'CREDIT';
2245:
2239: elsif ( pv_tds_event = 'SURCHARGE_CALCULATE') then
2240:
2241: /* Standard invoice to TDS authority, Credit memo to supplier */
2242:
2243: lv_invoice_to_tds_type := 'STANDARD';
2244: lv_invoice_to_vendor_type := 'CREDIT';
2245:
2246: lv_invoice_to_tds_num := lv_invoice_num ||'-SUR-SI-'||lv_ja_in_ap_inv_id;
2247: lv_invoice_to_vendor_num := lv_invoice_num ||'-SUR-CM-'||lv_ja_in_ap_inv_id;
2458: end if;
2459:
2460: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
2461:
2462: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
2463: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
2464: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default
2465: from setup*/
2466: if (r_ap_invoices_all.accts_pay_code_combination_id is not NULL) then