DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_MATCH_TAX_PKG

Line 1: PACKAGE BODY jai_ar_match_tax_pkg

1: PACKAGE BODY jai_ar_match_tax_pkg
2: /* $Header: jai_ar_match_tax.plb 120.19.12010000.3 2009/02/06 12:38:22 jmeena ship $ */
3: AS
4:
5: gv_projects_invoices constant varchar2(30) := 'PROJECTS INVOICES'; /* bug#6012570 (5876390) */

Line 6: GV_MODULE_PREFIX CONSTANT VARCHAR2(30) := 'jai_ar_match_tax_pkg'; -- -- Added by Jia Li on tax inclusive computation on 2007/11/30

2: /* $Header: jai_ar_match_tax.plb 120.19.12010000.3 2009/02/06 12:38:22 jmeena ship $ */
3: AS
4:
5: gv_projects_invoices constant varchar2(30) := 'PROJECTS INVOICES'; /* bug#6012570 (5876390) */
6: GV_MODULE_PREFIX CONSTANT VARCHAR2(30) := 'jai_ar_match_tax_pkg'; -- -- Added by Jia Li on tax inclusive computation on 2007/11/30
7:
8:
9: PROCEDURE process_batch (
10: ERRBUF OUT NOCOPY VARCHAR2,

Line 146: This version of the file is dependent on the file jai_ar_match_tax_pkg.process_from_order_line version (115.1) due to the additions of a new parameter p_org_id.

142: Fix:-
143: This fix has been done in the procedure ja_ar_rec_process_validate.val_revrec_records called from procedure ja_in_ra_order_lines_insert.
144:
145: Dependency Due to this Bug:-
146: This version of the file is dependent on the file jai_ar_match_tax_pkg.process_from_order_line version (115.1) due to the additions of a new parameter p_org_id.
147: It is also dependent on ja_in_ar_rec_prc_val_b.pls (115.0),ja_in_ar_rec_prc_val_s.pls (115.0) as jai_ar_match_tax_pkg.process_from_order_line version (115.1) calls
148: ja_ar_rec_process_validate.val_revrec_records(115.0).
149:
150: 11. 08-Jun-2005 Version 116.2 jai_ar_match_tax -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names

Line 147: It is also dependent on ja_in_ar_rec_prc_val_b.pls (115.0),ja_in_ar_rec_prc_val_s.pls (115.0) as jai_ar_match_tax_pkg.process_from_order_line version (115.1) calls

143: This fix has been done in the procedure ja_ar_rec_process_validate.val_revrec_records called from procedure ja_in_ra_order_lines_insert.
144:
145: Dependency Due to this Bug:-
146: This version of the file is dependent on the file jai_ar_match_tax_pkg.process_from_order_line version (115.1) due to the additions of a new parameter p_org_id.
147: It is also dependent on ja_in_ar_rec_prc_val_b.pls (115.0),ja_in_ar_rec_prc_val_s.pls (115.0) as jai_ar_match_tax_pkg.process_from_order_line version (115.1) calls
148: ja_ar_rec_process_validate.val_revrec_records(115.0).
149:
150: 11. 08-Jun-2005 Version 116.2 jai_ar_match_tax -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
151: as required for CASE COMPLAINCE.

Line 233: jai_ar_match_tax_pkg.process_batch

229:
230: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
231: Current Version Current Bug Dependent Files Version Author Date Remarks
232: Of File On Bug/Patchset Dependent On
233: jai_ar_match_tax_pkg.process_batch
234: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
235: 115.2 3839560 IN60105D2 jai_ar_match_tax_pkg.process_from_order_line 115.1 Aiyer 21/10/2004 New parameter p_org_id added
236: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
237: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004

Line 235: 115.2 3839560 IN60105D2 jai_ar_match_tax_pkg.process_from_order_line 115.1 Aiyer 21/10/2004 New parameter p_org_id added

231: Current Version Current Bug Dependent Files Version Author Date Remarks
232: Of File On Bug/Patchset Dependent On
233: jai_ar_match_tax_pkg.process_batch
234: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
235: 115.2 3839560 IN60105D2 jai_ar_match_tax_pkg.process_from_order_line 115.1 Aiyer 21/10/2004 New parameter p_org_id added
236: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
237: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
238: ja_ar_rec_process_validate.val_revrec_records
239: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

Line 236: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls

232: Of File On Bug/Patchset Dependent On
233: jai_ar_match_tax_pkg.process_batch
234: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
235: 115.2 3839560 IN60105D2 jai_ar_match_tax_pkg.process_from_order_line 115.1 Aiyer 21/10/2004 New parameter p_org_id added
236: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
237: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
238: ja_ar_rec_process_validate.val_revrec_records
239: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
240: /* Bug 5243532. Added by Lakshmi Gopalsami

Line 246: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');

242: v_org_id := FND_PROFILE.VALUE('ORG_ID');
243: */
244: lv_debug := nvl(p_debug,'N');
245: lv_debug := 'Y';
246: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');
247:
248: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
249: /*commented by kunkumar for bug# 6066813 Start
250: 6012570 (5876390) -- Revoked the comments for 6012570*/

Line 309: jai_ar_match_tax_pkg.process_from_order_line(

305: BEGIN
306:
307: var_cust_trx_id := temp_rec.customer_trx_id;
308:
309: jai_ar_match_tax_pkg.process_from_order_line(
310: temp_rec.customer_trx_id,
311: lv_debug ,
312: lv_process_status ,
313: lv_process_message

Line 340: Error has Occured in the jai_ar_match_tax_pkg.process_from_order_line procedure .

336:
337: IF lv_process_message IS NOT NULL THEN
338:
339: /*
340: Error has Occured in the jai_ar_match_tax_pkg.process_from_order_line procedure .
341: Rollback all inserts , updates , deletes which have happened in
342: the procedure and update the temp_lines_insert procedure
343: setting the error flag to 'R' and err_mesg to ERRBUF
344: */

Line 346: var_error_mesg := 'Error from called unit jai_ar_match_tax_pkg.process_from_order_line';

342: the procedure and update the temp_lines_insert procedure
343: setting the error flag to 'R' and err_mesg to ERRBUF
344: */
345:
346: var_error_mesg := 'Error from called unit jai_ar_match_tax_pkg.process_from_order_line';
347: RAISE error_from_called_unit;
348:
349: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30, Begin
350: -- TD17-Changed Account Inclusive taxes in AR separately

Line 388: var_error_mesg := errbuf || 'Error in loop (not in jai_ar_match_tax_pkg.process_from_order_line procedure) ';

384: WHEN OTHERS THEN
385: IF var_error_mesg IS NULL THEN
386: -- the exception condition is not because of returned error from inner procedure
387: errbuf := substr(SQLERRM,1,200);
388: var_error_mesg := errbuf || 'Error in loop (not in jai_ar_match_tax_pkg.process_from_order_line procedure) ';
389: END IF;
390:
391: ROLLBACK;
392:

Line 421: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');

417: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
418: END IF;
419:
420: COMMIT;
421: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');
422: EXCEPTION
423: WHEN OTHERS THEN
424: ROLLBACK;
425:

Line 2574: FILENAME: jai_ar_match_tax_pkg.process_manual_invoice.sql

2570: BEGIN --MAIN BLOCK BEGIN
2571:
2572:
2573: /*------------------------------------------------------------------------------------------
2574: FILENAME: jai_ar_match_tax_pkg.process_manual_invoice.sql
2575:
2576: CHANGE HISTORY:
2577:
2578: S.No Date Author and Details

Line 3747: END jai_ar_match_tax_pkg;

3743:
3744: END acct_inclu_taxes;
3745: -- Added by Jia Li on tax inclusive computation on 2007/11/30, End
3746:
3747: END jai_ar_match_tax_pkg;