[Home] [Help]
237:
238: 22. 20-AUG-2009 JMEENA for bug#8302581
239: Modified procedure do_rma_accounting and added code to debit the Liability account and credit Interim Liabality
240: account for the Non Recoverable Item In RMA order having VAT taxes.
241: Called procedure jai_cmn_rgm_recording_pkg.insert_vat_repository_entry to insert records in the jai_rgm_trx_records
242: table to reverse the VAT settlement entries for the non recoverable Items in the RMA Order.
243: 23. 05-may-2010 vkaranam for bug#9662961
244: Issue:
245: RTV accounting entries for VAT is hitting the final recovery account due to which the VAT settlement
258: Description: Following errors encountered by autobuild when compiling the package jai_rcv_rgm_claims_pkg.
259: 1. wrong number or types of arguments in call to insert_vat_repository_entry
260: 2. 'TEMP_REC'.'SHIPMENT_LINE_ID': invalid identifier
261: Fix:
262: 1. Corrected the parameters in the call to the procedure jai_cmn_rgm_recording_pkg.insert_vat_repository_entry.
263: 2. Made the correction in the procedure process_no_claim. Made it in sync with the 12.1 code.
264: 25. 28sep12 vkaranam for bug#14061440
265: Issue:VAT claim accounting is happening on the sysdate for the backdated receipt.
266: fix:
972: END IF;
973:
974: -- even if there is no VAT, then the data goes into this table
975: /*bduvarag Bug 5899383 start*/
976: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
977: pv_regime_code => jai_constants.vat_regime,
978: pv_organization_type => jai_constants.orgn_type_io,
979: pn_organization_id => r_trx.organization_id,
980: pn_location_id => ln_location_id,
1998: vat_invoice_date = rec_claims.invoice_date
1999: WHERE transaction_id = r_vat_invoice.transaction_id;
2000: END IF;
2001: /*bduvarag Bug 5899383 start*/
2002: lv_default_invoice_setup := jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
2003: pv_regime_code => jai_constants.vat_regime,
2004: pv_organization_type => jai_constants.orgn_type_io,
2005: pn_organization_id => rec_claims.organization_id,
2006: pn_location_id => rec_claims.location_id,
2058: lv_currency_code := jai_constants.func_curr;
2059:
2060: --for Balancing Accountid for register entry
2061: ln_interim_recovery_account :=
2062: jai_cmn_rgm_recording_pkg.get_account(
2063: p_regime_id => r_regime.regime_id,
2064: p_organization_type => jai_constants.orgn_type_io,
2065: p_organization_id => rec_claims.organization_id,
2066: p_location_id => rec_claims.location_id,
2073: RETURN;
2074: END IF;
2075:
2076: ln_code_combination_id :=
2077: jai_cmn_rgm_recording_pkg.get_account(
2078: p_regime_id => r_regime.regime_id,
2079: p_organization_type => jai_constants.orgn_type_io,
2080: p_organization_id => rec_claims.organization_id,
2081: p_location_id => rec_claims.location_id,
2131: fnd_file.put_line(fnd_file.log, 'Before Passing the Repository Entry');
2132: END IF;
2133:
2134: IF NVL(ln_entered_cr,0) <> 0 OR NVL(ln_entered_dr,0) <> 0 THEN --Added for Bug#4950914
2135: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
2136: pn_repository_id => ln_repository_id,
2137: pn_regime_id => r_regime.regime_id,
2138: pv_tax_type => rec_claims.tax_type,
2139: pv_organization_type => jai_constants.orgn_type_io,
2228:
2229: /*
2230: -- Cr Vat Interim
2231: ln_code_combination_id :=
2232: jai_cmn_rgm_recording_pkg.get_account(
2233: p_regime_id => r_regime.regime_id,
2234: p_organization_type => jai_constants.orgn_type_io,
2235: p_organization_id => rec_claims.organization_id,
2236: p_location_id => rec_claims.location_id,
2689: END IF;
2690:
2691: --CR VAT Interrim
2692: ln_code_combination_id :=
2693: jai_cmn_rgm_recording_pkg.get_account(
2694: p_regime_id => r_regime.regime_id,
2695: p_organization_type => jai_constants.orgn_type_io,
2696: p_organization_id => r_receive_transaction.organization_id,
2697: p_location_id => r_receive_transaction.location_id,
3159: CLOSE c_total_reversal_amount;
3160:
3161: ln_statement_id := 102.2;
3162: ln_rec_ccid :=
3163: jai_cmn_rgm_recording_pkg.get_account(
3164: p_regime_id => r_regime.regime_id,
3165: p_organization_type => jai_constants.orgn_type_io,
3166: p_organization_id => rec_taxes.organization_id,
3167: p_location_id => rec_taxes.location_id,
3175: END IF;
3176:
3177: ln_statement_id := 102.3;
3178: ln_int_ccid :=
3179: jai_cmn_rgm_recording_pkg.get_account(
3180: p_regime_id => r_regime.regime_id,
3181: p_organization_type => jai_constants.orgn_type_io,
3182: p_organization_id => rec_taxes.organization_id,
3183: p_location_id => rec_taxes.location_id,
3192:
3193: --vkaranam for 9662961
3194: ln_statement_id := 102.4;
3195: ln_lib_ccid :=
3196: jai_cmn_rgm_recording_pkg.get_account(
3197: p_regime_id => r_regime.regime_id,
3198: p_organization_type => jai_constants.orgn_type_io,
3199: p_organization_id => rec_taxes.organization_id,
3200: p_location_id => rec_taxes.location_id,
3369: END IF;
3370:
3371: ln_statement_id := 105;
3372: IF NVL(ln_entered_dr,0) <> 0 OR NVL(ln_entered_cr,0) <> 0 THEN --Added for Bug#4950914
3373: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
3374: pn_repository_id => ln_repository_id,
3375: pn_regime_id => r_regime.regime_id,
3376: pv_tax_type => rec_taxes.tax_type,
3377: pv_organization_type => jai_constants.orgn_type_io,
3437: ln_statement_id := 108;
3438: /* if condition added by Vijay */
3439: IF NVL(r_total_reversal_amount.installment_amount,0) <> 0 THEN
3440:
3441: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
3442: pn_repository_id => ln_repository_id,
3443: pn_regime_id => r_regime.regime_id,
3444: pv_tax_type => rec_taxes.tax_type,
3445: pv_organization_type => jai_constants.orgn_type_io,
3474: pv_trx_reference4 => NULL,
3475: pv_trx_reference5 => NULL
3476: -------------------------------------------------
3477: --Added by Bo Li for bug9305067 2010-4-14 END
3478: );/*Bug 11880460 abezgam Changed the parameters from pv_attribute% to pv_tax_reference% as per precedure definition in jai_cmn_rgm_recording_pkg*/
3479:
3480: ln_statement_id := 109;
3481: IF gv_debug THEN
3482: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3667: END IF;
3668: -- End bug#8302581
3669: fnd_file.put_line(fnd_file.log, 'lv_account_name:'||lv_account_name||'jai_constants.recovery_interim:'|| jai_constants.recovery_interim);
3670: ln_debit_ccid :=
3671: jai_cmn_rgm_recording_pkg.get_account(
3672: p_regime_id => r_regime.regime_id,
3673: p_organization_type => jai_constants.orgn_type_io,
3674: p_organization_id => r_trx.organization_id,
3675: p_location_id => r_trx.location_id,
3719: END IF;
3720: END IF;
3721: --CR Interim Liability
3722: ln_credit_ccid :=
3723: jai_cmn_rgm_recording_pkg.get_account(
3724: p_regime_id => r_regime.regime_id,
3725: p_organization_type => jai_constants.orgn_type_io,
3726: p_organization_id => r_trx.organization_id,
3727: p_location_id => r_trx.location_id,
3776: ln_entered_cr:= NULL ;
3777: ln_entered_dr:= ln_entered_cr*-1;
3778: END IF;
3779:
3780: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
3781: pn_repository_id => ln_repository_id,
3782: pn_regime_id => r_regime.regime_id,
3783: pv_tax_type => rec_tax.tax_type,
3784: pv_organization_type => jai_constants.orgn_type_io,
3813: pv_trx_reference4 => NULL,
3814: pv_trx_reference5 => NULL
3815: ----------------------------------------------
3816: --Added by Bo Li for bug9305067 2010-4-14 END
3817: );/*Bug 11880460 Changed the parameters from pv_attribute% to pv_tax_reference% as per precedure definition in jai_cmn_rgm_recording_pkg*/
3818:
3819: IF lv_process_status <> jai_constants.successful THEN
3820: p_process_status := lv_process_status;
3821: p_process_message := lv_process_message;