[Home] [Help]
1: PACKAGE BODY jai_ap_match_tax_pkg
2: /* $Header: jai_ap_match_tax.plb 120.67.12020000.5 2013/03/08 08:52:48 anupgupt ship $ */
3: AS
4:
5: /* Bug 5401111. Added by Lakshmi Gopalsami
137:
138:
139:
140: /* ------------------------------------------------------------------------------------------------------------------------
141: FILE NAME : jai_ap_match_tax_pkg.process_batch_p.sql
142: CHANGE HISTORY:
143: S.No DATE Author AND Details
144: ---------------------------------------------------------------------------------------------------------------------------
145: 1 05-may-2002 Aparajita, Created this procedure. bug # 2359737 (enhancement for ti)
251: ------------------------------------------------------------------------------------------------------------------------ */
252: BEGIN
253:
254:
255: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');
256:
257: -- this cursor picks up the invoice lines from the temporary table but does not pick up such invoices which have
258: -- error_flag set to 'Y' for any of it's distribution lines.
259:
378: -- for each record call distribution matching procedure to process the invoice.
379: -- invoice has not hit error for earlier lines if any.
380:
381:
382: jai_ap_match_tax_pkg.process_batch_record
383: (
384: v_errbuf,
385: c_rec.invoice_id,
386: c_rec.invoice_line_number,
409:
410: IF ( v_errbuf IS NOT NULL) THEN
411:
412: -- Called unit has returned error.
413: v_error_mesg := 'Error from called unit jai_ap_match_tax_pkg.process_batch_record, ';
414: RAISE error_from_called_unit;
415:
416: END IF; -- error return from distribution matching
417:
420:
421: WHEN OTHERS THEN
422:
423: IF v_error_mesg IS NULL THEN
424: -- the exception condition is not because of returned error from jai_ap_match_tax_pkg.process_batch_record.
425: v_errbuf := SQLERRM;
426: v_error_mesg := 'Error in loop(not jai_ap_match_tax_pkg.process_batch_record), ';
427: END IF;
428:
422:
423: IF v_error_mesg IS NULL THEN
424: -- the exception condition is not because of returned error from jai_ap_match_tax_pkg.process_batch_record.
425: v_errbuf := SQLERRM;
426: v_error_mesg := 'Error in loop(not jai_ap_match_tax_pkg.process_batch_record), ';
427: END IF;
428:
429: ROLLBACK;
430:
477:
478: END IF;
479:
480:
481: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
482:
483: EXCEPTION
484:
485: WHEN OTHERS THEN
498: WHERE ROWID = v_rowid;
499:
500: COMMIT;
501:
502: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
503: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
504: RETURN;
505:
506: END process_batch;
1487: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
1488: p_key_value => :a,
1489: p_key_value_list => NULL,
1490: p_calling_sequence =>
1491: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_online procedure)''
1492: ); END;';
1493:
1494: -- Vijay Shankar for bug#3461030
1495: EXECUTE IMMEDIATE v_mrc_string USING p_invoice_distribution_id;
1518: p_table_name => ''AP_INVOICES_ALL'',
1519: p_key_value => :a,
1520: p_key_value_list => NULL,
1521: p_calling_sequence =>
1522: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_online procedure)''
1523: ); END;';
1524:
1525: -- Vijay Shankar for bug#3461030
1526: EXECUTE IMMEDIATE v_mrc_string USING inv_id;
1636:
1637: BEGIN
1638:
1639: /*------------------------------------------------------------------------------------------
1640: FILENAME: ja_in_jai_ap_match_tax_pkg.process_online_p.sql
1641: CHANGE HISTORY:
1642: S.No Date Author and Details
1643: 1. 20-mar-01 Subbu and Pavan for AP to FA issue added
1644: insert statemnt for temp table JAI_CMN_FA_INV_DIST_ALL
2106:
2107: ------------------------------------------------------------------------------------------------------- */
2108:
2109:
2110: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');
2111:
2112: OPEN get_ven_info(inv_id);
2113: FETCH get_ven_info INTO get_ven_info_rec;
2114: CLOSE get_ven_info;
7183: ----------------------------------------------------------------------
7184: -- Added by Qiong for reverse charge bug#16001407, End
7185:
7186: <
7187: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');
7188: EXCEPTION
7189: WHEN OTHERS THEN
7190: ERRBUF := SQLERRM;
7191: RETCODE := 2;
7188: EXCEPTION
7189: WHEN OTHERS THEN
7190: ERRBUF := SQLERRM;
7191: RETCODE := 2;
7192: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
7193: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
7194: END process_online;
7195:
7196: PROCEDURE process_batch_record (
7734: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
7735: p_key_value => :a,
7736: p_key_value_list => NULL,
7737: p_calling_sequence =>
7738: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_batch_record procedure)''
7739: ); END;';
7740:
7741: -- Vijay Shankar for bug#3461030
7742: EXECUTE IMMEDIATE v_mrc_string USING p_invoice_distribution_id;
7765: p_table_name => ''AP_INVOICES_ALL'',
7766: p_key_value => :a,
7767: p_key_value_list => NULL,
7768: p_calling_sequence =>
7769: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_batch_record procedure)''
7770: ); END;';
7771:
7772: -- Vijay Shankar for bug#3461030
7773: EXECUTE IMMEDIATE v_mrc_string USING inv_id;
7789:
7790: BEGIN
7791:
7792: /*------------------------------------------------------------------------------------------------------
7793: CHANGE HISTORY: FILENAME: jai_ap_match_tax_pkg.process_batch_record_p.sql
7794: S.No dd/mm/yyyy Author and Details
7795: ----------------------------------------------------------------------------------------------------------
7796: 1. 23/05/2002 Aparajita for bug # 2359737 Version# 614.1
7797: this procedure is extracted from jai_ap_match_tax_pkg.process_online and contains
7793: CHANGE HISTORY: FILENAME: jai_ap_match_tax_pkg.process_batch_record_p.sql
7794: S.No dd/mm/yyyy Author and Details
7795: ----------------------------------------------------------------------------------------------------------
7796: 1. 23/05/2002 Aparajita for bug # 2359737 Version# 614.1
7797: this procedure is extracted from jai_ap_match_tax_pkg.process_online and contains
7798: only the pay on receipt functionality which will be now used by the
7799: concurrent for pay on receipt which will call this procedure.
7800:
7801: 2. 21/06/2002 Aparajita for bug # 2428264 Version# 614.2
7826:
7827: 6. 15/11/2002 cbabu for bug # 2665306, Version# 615.4
7828: Added the code when rcv_tran_id is NULL.
7829:
7830: the code that is added was copied from jai_ap_match_tax_pkg.process_online code with
7831: p_rematch = 'PO_MATCHING' Now the taxes for ERS invoice will be defaulted
7832: here and header amount is updated if the invoice is created for the first
7833: time. If any reversal is happened for distribution lines, then invoice
7834: header amount is not modified.