211: 27. 22/06/2007 Bug# 6119216, File Version 120.20
212: Issue: RTN DOCS ARE NOT GENERATED ON APPLICATION OF PREPAYMENT INVOICE
213: Fix:
214: 1. Changed where clause of the cursor c_check_not_validate.
215: 2. Changed import_and_approve procedure, here a call to fnd_request.submit_request was passing
216: p_invoice_id instead of lv_group_id
217:
218: 28. 11/01/2008 Changes done by nprashar for bug # 6720018.
219: Issue# APAC:PEN:R12:INDIA LOCALIZATION VALIDATING FUNCTION OF TDS INVOICE NOT WORKING.
2121:
2122:
2123: /* Invoke payables open interface */
2124:
2125: lb_result := fnd_request.set_mode(true);
2126:
2127: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for bug#4584221
2128:
2129: ln_import_request_id :=
2126:
2127: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for bug#4584221
2128:
2129: ln_import_request_id :=
2130: fnd_request.submit_request
2131: (
2132: 'SQLAP',
2133: 'APXIIMPT',
2134: 'Import TDS invoices - ' || lower(p_tds_event),
2184:
2185:
2186: /* Control comes here only when Pre-approved TDS invoice is setup for the vendor,
2187: we need to invoke the request for approval */
2188: lb_result := fnd_request.set_mode(true);
2189:
2190: ln_approve_request_id :=
2191: fnd_request.submit_request
2192: (
2187: we need to invoke the request for approval */
2188: lb_result := fnd_request.set_mode(true);
2189:
2190: ln_approve_request_id :=
2191: fnd_request.submit_request
2192: (
2193: 'JA',
2194: 'JAITDSA',
2195: 'Approval Of TDS Invoices ',