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_AP_MATCH_TAX_PKG

Line 1: PACKAGE BODY jai_ap_match_tax_pkg

1: PACKAGE BODY jai_ap_match_tax_pkg
2: /* $Header: jai_ap_match_tax.plb 120.34.12010000.4 2008/12/10 13:09:07 bgowrava ship $ */
3: AS
4:
5: /* Bug 5401111. Added by Lakshmi Gopalsami

Line 131: FILE NAME : jai_ap_match_tax_pkg.process_batch_p.sql

127:
128:
129:
130: /* ------------------------------------------------------------------------------------------------------------------------
131: FILE NAME : jai_ap_match_tax_pkg.process_batch_p.sql
132: CHANGE HISTORY:
133: S.No DATE Author AND Details
134: ---------------------------------------------------------------------------------------------------------------------------
135: 1 05-may-2002 Aparajita, Created this procedure. bug # 2359737 (enhancement for ti)

Line 212: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');

208: ------------------------------------------------------------------------------------------------------------------------ */
209: BEGIN
210:
211:
212: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');
213:
214: -- this cursor picks up the invoice lines from the temporary table but does not pick up such invoices which have
215: -- error_flag set to 'Y' for any of it's distribution lines.
216:

Line 339: jai_ap_match_tax_pkg.process_batch_record

335: -- for each record call distribution matching procedure to process the invoice.
336: -- invoice has not hit error for earlier lines if any.
337:
338:
339: jai_ap_match_tax_pkg.process_batch_record
340: (
341: v_errbuf,
342: c_rec.invoice_id,
343: c_rec.invoice_line_number,

Line 370: v_error_mesg := 'Error from called unit jai_ap_match_tax_pkg.process_batch_record, ';

366:
367: IF ( v_errbuf IS NOT NULL) THEN
368:
369: -- Called unit has returned error.
370: v_error_mesg := 'Error from called unit jai_ap_match_tax_pkg.process_batch_record, ';
371: RAISE error_from_called_unit;
372:
373: END IF; -- error return from distribution matching
374:

Line 381: -- the exception condition is not because of returned error from jai_ap_match_tax_pkg.process_batch_record.

377:
378: WHEN OTHERS THEN
379:
380: IF v_error_mesg IS NULL THEN
381: -- the exception condition is not because of returned error from jai_ap_match_tax_pkg.process_batch_record.
382: v_errbuf := SQLERRM;
383: v_error_mesg := 'Error in loop(not jai_ap_match_tax_pkg.process_batch_record), ';
384: END IF;
385:

Line 383: v_error_mesg := 'Error in loop(not jai_ap_match_tax_pkg.process_batch_record), ';

379:
380: IF v_error_mesg IS NULL THEN
381: -- the exception condition is not because of returned error from jai_ap_match_tax_pkg.process_batch_record.
382: v_errbuf := SQLERRM;
383: v_error_mesg := 'Error in loop(not jai_ap_match_tax_pkg.process_batch_record), ';
384: END IF;
385:
386: ROLLBACK;
387:

Line 438: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');

434:
435: END IF;
436:
437:
438: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
439:
440: EXCEPTION
441:
442: WHEN OTHERS THEN

Line 459: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');

455: WHERE ROWID = v_rowid;
456:
457: COMMIT;
458:
459: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
460: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
461: RETURN;
462:
463: END process_batch;

Line 1172: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_online procedure)''

1168: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
1169: p_key_value => :a,
1170: p_key_value_list => NULL,
1171: p_calling_sequence =>
1172: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_online procedure)''
1173: ); END;';
1174:
1175: -- Vijay Shankar for bug#3461030
1176: EXECUTE IMMEDIATE v_mrc_string USING p_invoice_distribution_id;

Line 1203: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_online procedure)''

1199: p_table_name => ''AP_INVOICES_ALL'',
1200: p_key_value => :a,
1201: p_key_value_list => NULL,
1202: p_calling_sequence =>
1203: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_online procedure)''
1204: ); END;';
1205:
1206: -- Vijay Shankar for bug#3461030
1207: EXECUTE IMMEDIATE v_mrc_string USING inv_id;

Line 1313: FILENAME: ja_in_jai_ap_match_tax_pkg.process_online_p.sql

1309:
1310: BEGIN
1311:
1312: /*------------------------------------------------------------------------------------------
1313: FILENAME: ja_in_jai_ap_match_tax_pkg.process_online_p.sql
1314: CHANGE HISTORY:
1315: S.No Date Author and Details
1316: 1. 20-mar-01 Subbu and Pavan for AP to FA issue added
1317: insert statemnt for temp table JAI_CMN_FA_INV_DIST_ALL

Line 1770: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');

1766:
1767: ------------------------------------------------------------------------------------------------------- */
1768:
1769:
1770: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');
1771:
1772: OPEN get_ven_info(inv_id);
1773: FETCH get_ven_info INTO get_ven_info_rec;
1774: CLOSE get_ven_info;

Line 5637: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');

5633:
5634: END IF; -- p_rematch = 'RCV_MATCHING'
5635:
5636:
5637: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');
5638:
5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: ERRBUF := SQLERRM;

Line 5643: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');

5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: ERRBUF := SQLERRM;
5642: RETCODE := 2;
5643: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
5644: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
5645: END process_online;
5646:
5647: PROCEDURE process_batch_record (

Line 6184: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_batch_record procedure)''

6180: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
6181: p_key_value => :a,
6182: p_key_value_list => NULL,
6183: p_calling_sequence =>
6184: ''India Local Tax line as Miscellaneous distribution line (jai_ap_match_tax_pkg.process_batch_record procedure)''
6185: ); END;';
6186:
6187: -- Vijay Shankar for bug#3461030
6188: EXECUTE IMMEDIATE v_mrc_string USING p_invoice_distribution_id;

Line 6215: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_batch_record procedure)''

6211: p_table_name => ''AP_INVOICES_ALL'',
6212: p_key_value => :a,
6213: p_key_value_list => NULL,
6214: p_calling_sequence =>
6215: ''India Local Tax amount added to invoice header (jai_ap_match_tax_pkg.process_batch_record procedure)''
6216: ); END;';
6217:
6218: -- Vijay Shankar for bug#3461030
6219: EXECUTE IMMEDIATE v_mrc_string USING inv_id;

Line 6239: CHANGE HISTORY: FILENAME: jai_ap_match_tax_pkg.process_batch_record_p.sql

6235:
6236: BEGIN
6237:
6238: /*------------------------------------------------------------------------------------------------------
6239: CHANGE HISTORY: FILENAME: jai_ap_match_tax_pkg.process_batch_record_p.sql
6240: S.No dd/mm/yyyy Author and Details
6241: ----------------------------------------------------------------------------------------------------------
6242: 1. 23/05/2002 Aparajita for bug # 2359737 Version# 614.1
6243: this procedure is extracted from jai_ap_match_tax_pkg.process_online and contains

Line 6243: this procedure is extracted from jai_ap_match_tax_pkg.process_online and contains

6239: CHANGE HISTORY: FILENAME: jai_ap_match_tax_pkg.process_batch_record_p.sql
6240: S.No dd/mm/yyyy Author and Details
6241: ----------------------------------------------------------------------------------------------------------
6242: 1. 23/05/2002 Aparajita for bug # 2359737 Version# 614.1
6243: this procedure is extracted from jai_ap_match_tax_pkg.process_online and contains
6244: only the pay on receipt functionality which will be now used by the
6245: concurrent for pay on receipt which will call this procedure.
6246:
6247: 2. 21/06/2002 Aparajita for bug # 2428264 Version# 614.2

Line 6276: the code that is added was copied from jai_ap_match_tax_pkg.process_online code with

6272:
6273: 6. 15/11/2002 cbabu for bug # 2665306, Version# 615.4
6274: Added the code when rcv_tran_id is NULL.
6275:
6276: the code that is added was copied from jai_ap_match_tax_pkg.process_online code with
6277: p_rematch = 'PO_MATCHING' Now the taxes for ERS invoice will be defaulted
6278: here and header amount is updated if the invoice is created for the first
6279: time. If any reversal is happened for distribution lines, then invoice
6280: header amount is not modified.