[Home] [Help]
1: PACKAGE BODY jai_ar_match_tax_pkg
2: /* $Header: jai_ar_match_tax.plb 120.71.12020000.5 2013/03/18 07:53:38 qimeng ship $ */
3: AS
4: --+=======================================================================+
5: --| Copyright (c) 1998 Oracle Corporation |
172: --| |
173: --+======================================================================*/
174:
175: gv_projects_invoices constant varchar2(30) := 'PROJECTS INVOICES'; /* bug#6012570 (5876390) */
176: GV_MODULE_PREFIX CONSTANT VARCHAR2(30) := 'jai_ar_match_tax_pkg'; -- -- Added by Jia Li on tax inclusive computation on 2007/11/30
177:
178:
179: PROCEDURE process_batch (
180: ERRBUF OUT NOCOPY VARCHAR2,
468: Fix:-
469: 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.
470:
471: Dependency Due to this Bug:-
472: 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.
473: 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
474: ja_ar_rec_process_validate.val_revrec_records(115.0).
475:
476: 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
469: 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.
470:
471: Dependency Due to this Bug:-
472: 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.
473: 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
474: ja_ar_rec_process_validate.val_revrec_records(115.0).
475:
476: 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
477: as required for CASE COMPLAINCE.
576: fine for the base amount. But the same is not happening for the tax amount.
577:
578: Hence the incorrect invoice balance issue.
579:
580: The procedure jai_ar_match_tax_pkg.process_from_order_line
581: is responsible for populating the IL taxes in base AR table. Here we do not
582: check if a cash receipt is already applied to the invoice. The code just
583: directly applies the tax amount of the credit memo to the invoice. it does
584: not unapply the tax amount of the cash receipt applied before. Thats the
626:
627: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
628: Current Version Current Bug Dependent Files Version Author Date --|arks
629: Of File On Bug/Patchset Dependent On
630: jai_ar_match_tax_pkg.process_batch
631: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
632: 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
633: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
634: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
628: Current Version Current Bug Dependent Files Version Author Date --|arks
629: Of File On Bug/Patchset Dependent On
630: jai_ar_match_tax_pkg.process_batch
631: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
632: 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
633: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
634: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
635: ja_ar_rec_process_validate.val_revrec_records
636: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
629: Of File On Bug/Patchset Dependent On
630: jai_ar_match_tax_pkg.process_batch
631: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
632: 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
633: ja_in_ar_rec_prc_val_s.pls 115.0 Aiyer 21/10/2004 jai_ar_match_tax_pkg.process_from_order_line calls
634: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
635: ja_ar_rec_process_validate.val_revrec_records
636: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
637: /* Bug 5243532. Added by Lakshmi Gopalsami
639: v_org_id := FND_PROFILE.VALUE('ORG_ID');
640: */
641: lv_debug := nvl(p_debug,'N');
642: lv_debug := 'Y';
643: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');
644:
645: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
646: /*commented by kunkumar for bug# 6066813 Start
647: 6012570 (5876390) -- Revoked the comments for 6012570*/
702: BEGIN
703:
704: var_cust_trx_id := temp_rec.customer_trx_id;
705:
706: jai_ar_match_tax_pkg.process_from_order_line(
707: temp_rec.customer_trx_id,
708: lv_debug ,
709: lv_process_status ,
710: lv_process_message
733:
734: IF lv_process_message IS NOT NULL THEN
735:
736: /*
737: Error has Occured in the jai_ar_match_tax_pkg.process_from_order_line procedure .
738: Rollback all inserts , updates , deletes which have happened in
739: the procedure and update the temp_lines_insert procedure
740: setting the error flag to 'R' and err_mesg to ERRBUF
741: */
739: the procedure and update the temp_lines_insert procedure
740: setting the error flag to 'R' and err_mesg to ERRBUF
741: */
742:
743: var_error_mesg := 'Error from called unit jai_ar_match_tax_pkg.process_from_order_line';
744: RAISE error_from_called_unit;
745:
746: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30, Begin
747: -- TD17-Changed Account Inclusive taxes in AR separately
783: WHEN OTHERS THEN
784: IF var_error_mesg IS NULL THEN
785: -- the exception condition is not because of returned error from inner procedure
786: errbuf := substr(SQLERRM,1,200);
787: var_error_mesg := errbuf || 'Error in loop (not in jai_ar_match_tax_pkg.process_from_order_line procedure) ';
788: END IF;
789:
790: ROLLBACK;
791:
979: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
980: END IF;
981:
982: COMMIT;
983: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');
984: EXCEPTION
985: WHEN OTHERS THEN
986: ROLLBACK;
987:
3554: BEGIN --MAIN BLOCK BEGIN
3555:
3556:
3557: /*------------------------------------------------------------------------------------------
3558: FILENAME: jai_ar_match_tax_pkg.process_manual_invoice.sql
3559:
3560: CHANGE HISTORY:
3561:
3562: S.No Date Author and Details
5490: -- TD named "TDD_122_FIN_JAI_Service_Tax_on_Advanced_Receipt.doc" has been referenced
5491: --
5492: --
5493: -- CALL FROM
5494: -- JAI_AR_MATCH_TAX_PKG.display_vat_invoice_number
5495: --
5496: --
5497: --
5498: -- CHANGE HISTORY:
5679: -- TD named "VAT Invoice Number on AR Invoice Technical Design.doc" has been
5680: -- referenced in the section 6.1
5681: --
5682: -- CALL FROM
5683: -- JAI_AR_MATCH_TAX_PKG.process_batch
5684: -- JAI_AR_TRX.update_excise_invoice_no
5685: -- JAI_AR_TRX.update_reference
5686: --
5687: -- CHANGE HISTORY:
5716: lv_st_inv_number);
5717: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
5718: END display_vat_invoice_no;
5719:
5720: END jai_ar_match_tax_pkg;