[Home] [Help]
1: PACKAGE BODY jai_rcv_excise_processing_pkg AS
2: /* $Header: jai_rcv_exc_prc.plb 120.22.12010000.4 2009/01/19 12:52:24 vumaasha ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename:
118: ) RETURN TAX_BREAKUP IS
119:
120: r_tax TAX_BREAKUP;
121: ln_factor NUMBER;
122: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_apportioned_tax';
123:
124: BEGIN
125:
126: if p_factor IS NULL or p_factor = 0 then
172: FROM JAI_RCV_CENVAT_CLAIMS
173: WHERE transaction_id = cp_transaction_id;
174:
175: r_receipt_cenvat_dtl c_receipt_cenvat_dtl%ROWTYPE;
176: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_changed_vendor_dtls';
177:
178: BEGIN
179:
180: OPEN c_receipt_cenvat_dtl(p_receive_trx_id);
207: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
208:
209: ln_trx_qty_for_2nd_claim NUMBER;
210: ln_trx_equivalent_of_receive NUMBER;
211: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.post_cenvat_processor';
212:
213: BEGIN
214:
215: OPEN c_trx(p_transaction_id);
292: END post_cenvat_processor;
293:
294: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
295: PROCEDURE update_RTV_Diff_value
296: (pr_base_trx IN jai_rcv_excise_processing_pkg.c_base_trx%ROWTYPE,
297: pr_tax IN jai_rcv_excise_processing_pkg.c_trx%ROWTYPE,
298: pr_diff_tax IN TAX_BREAKUP,
299: p_source_reg IN VARCHAR2 ,
300: p_register_entry_type IN VARCHAR2 ,
293:
294: /* Start of bug 5365346. Created by Lakshmi Gopalsami */
295: PROCEDURE update_RTV_Diff_value
296: (pr_base_trx IN jai_rcv_excise_processing_pkg.c_base_trx%ROWTYPE,
297: pr_tax IN jai_rcv_excise_processing_pkg.c_trx%ROWTYPE,
298: pr_diff_tax IN TAX_BREAKUP,
299: p_source_reg IN VARCHAR2 ,
300: p_register_entry_type IN VARCHAR2 ,
301: p_register_id IN OUT NOCOPY NUMBER,
336:
337: BEGIN
338:
339: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath,
340: 'jai_rcv_excise_processing_pkg.update_RTV_Diff_value', 'START');
341:
342:
343: lv_statement_id := '1';
344: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath);
792: ln_total_cenvat NUMBER;
793: ln_total_cenvat_rounded NUMBER;
794: ln_rounded_amt NUMBER;
795:
796: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.do_cenvat_rounding';
797: BEGIN
798:
799: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.do_cenvat_rounding. Basic->'||pr_tax.basic_excise
800: ||', Additional->'||pr_tax.addl_excise
966:
967: BEGIN
968:
969: /*----------------------------------------------------------------------------------------------------------------------------
970: CHANGE HISTORY for FILENAME: jai_rcv_excise_processing_pkg.sql
971: S.No dd/mm/yyyy Author and Details
972: ------------------------------------------------------------------------------------------------------------------------------
973: 1 26/07/2004 Vijay Shankar for Bug# 3496408, Version:115.0
974: This Package is coded for Corrections Enhancement to invoke CENVAT and RG related insert APIs for PO Functionality.
1103: lv_procedure_name := 'CENVAT_RG_PKG.process_transaction';
1104: ln_amount_factor := 1;
1105:
1106: -- this is to identify the path in SQL TRACE file if any problem occured
1107: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1108:
1109: if lb_rg_debug then
1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1106: -- this is to identify the path in SQL TRACE file if any problem occured
1107: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1108:
1109: if lb_rg_debug then
1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1112: end if;
1113:
1114: lv_statement_id := '0';
1107: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1108:
1109: if lb_rg_debug then
1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1112: end if;
1113:
1114: lv_statement_id := '0';
1115: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.process_trx', 'START'); /* 1 */
1112: end if;
1113:
1114: lv_statement_id := '0';
1115: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.process_trx', 'START'); /* 1 */
1116: FND_FILE.put_line( FND_FILE.log, '***** Start of jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
1117:
1118: lv_statement_id := '1';
1119: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1120: OPEN c_trx(p_transaction_id);
1168: );
1169:
1170: -- Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
1171: -- following should be executed only incase of RECEIVE (or) MATCH transactions and that too for 2nd claim
1172: IF p_process_special_reason = jai_rcv_excise_processing_pkg.second_50ptg_claim THEN
1173: /* Bug 6800251. Added by Lakshmi Gopalsami
1174: * Get the total RTV qty and proportion it against the receipt qty.
1175: * The tax breakup should happen for the remaining quantity so that
1176: * half of the amount can be used for 2nd claim.
1190: -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1191: END IF;
1192:
1193: if lb_rg_debug then
1194: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1195: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1196: end if;
1197:
1198: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on
1191: END IF;
1192:
1193: if lb_rg_debug then
1194: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1195: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1196: end if;
1197:
1198: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on
1199: -- Transaction UOMs, Quantities of Parent RECEIVE and present trxn an
1820: p_process_message := 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id;
1821: END IF;
1822:
1823: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath, null, 'END'); /* 26 */
1824: FND_FILE.put_line( FND_FILE.log, '----- END, jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
1825:
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: p_process_status := 'E';
2534: ln_other_tax_debit := pr_tax.excise_edu_cess;
2535: ELSE
2536: ln_other_tax_credit := pr_tax.excise_edu_cess;
2537: END IF;
2538: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2539: p_source_register => jai_constants.reg_rg23d,
2540: p_source_register_id => p_register_id,
2541: p_tax_type => jai_constants.tax_type_exc_edu_cess,
2542: p_credit => ln_other_tax_credit,
2554: ln_other_tax_debit := pr_tax.cvd_edu_cess;
2555: ELSE
2556: ln_other_tax_credit := pr_tax.cvd_edu_cess;
2557: END IF;
2558: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2559: p_source_register => jai_constants.reg_rg23d,
2560: p_source_register_id => p_register_id,
2561: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
2562: p_credit => ln_other_tax_credit,
2576: ELSE
2577: ln_other_tax_credit := pr_tax.sh_exc_edu_cess;
2578: END IF;
2579:
2580: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2581: p_source_register => jai_constants.reg_rg23d,
2582: p_source_register_id => p_register_id,
2583: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
2584: p_credit => ln_other_tax_credit,
2596: ln_other_tax_debit := pr_tax.sh_cvd_edu_cess;
2597: ELSE
2598: ln_other_tax_credit := pr_tax.sh_cvd_edu_cess;
2599: END IF;
2600: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2601: p_source_register => jai_constants.reg_rg23d,
2602: p_source_register_id => p_register_id,
2603: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
2604: p_credit => ln_other_tax_credit,
2869: ln_other_tax_debit := pr_tax.excise_edu_cess;
2870: ELSE
2871: ln_other_tax_credit := pr_tax.excise_edu_cess;
2872: END IF;
2873: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2874: p_source_register => lv_source_register,
2875: p_source_register_id => p_register_id,
2876: p_tax_type => jai_constants.tax_type_exc_edu_cess,
2877: p_credit => ln_other_tax_credit,
2888: ln_other_tax_debit := pr_tax.cvd_edu_cess;
2889: ELSE
2890: ln_other_tax_credit := pr_tax.cvd_edu_cess;
2891: END IF;
2892: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2893: p_source_register => lv_source_register,
2894: p_source_register_id => p_register_id,
2895: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
2896: p_credit => ln_other_tax_credit,
2907: ln_other_tax_debit := pr_tax.sh_exc_edu_cess;
2908: ELSE
2909: ln_other_tax_credit := pr_tax.sh_exc_edu_cess;
2910: END IF;
2911: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2912: p_source_register => lv_source_register,
2913: p_source_register_id => p_register_id,
2914: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
2915: p_credit => ln_other_tax_credit,
2926: ln_other_tax_debit := pr_tax.sh_cvd_edu_cess;
2927: ELSE
2928: ln_other_tax_credit := pr_tax.sh_cvd_edu_cess;
2929: END IF;
2930: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2931: p_source_register => lv_source_register,
2932: p_source_register_id => p_register_id,
2933: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
2934: p_credit => ln_other_tax_credit,
3110: ln_other_tax_debit := pr_tax.excise_edu_cess;
3111: ELSE
3112: ln_other_tax_credit := pr_tax.excise_edu_cess;
3113: END IF;
3114: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3115: p_source_register => jai_constants.reg_pla,
3116: p_source_register_id => p_register_id,
3117: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3118: p_credit => ln_other_tax_credit,
3129: ln_other_tax_debit := pr_tax.cvd_edu_cess;
3130: ELSE
3131: ln_other_tax_credit := pr_tax.cvd_edu_cess;
3132: END IF;
3133: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3134: p_source_register => jai_constants.reg_pla,
3135: p_source_register_id => p_register_id,
3136: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3137: p_credit => ln_other_tax_credit,
3150: ELSE
3151: ln_other_tax_credit := nvl(pr_tax.sh_exc_edu_cess,0);
3152: END IF;
3153:
3154: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3155: p_source_register => jai_constants.reg_pla,
3156: p_source_register_id => p_register_id,
3157: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3158: p_credit => ln_other_tax_credit,
3169: ln_other_tax_debit := nvl(pr_tax.sh_cvd_edu_cess,0);
3170: ELSE
3171: ln_other_tax_credit := nvl(pr_tax.sh_cvd_edu_cess,0);
3172: END IF;
3173: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3174: p_source_register => jai_constants.reg_pla,
3175: p_source_register_id => p_register_id,
3176: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3177: p_credit => ln_other_tax_credit,
3696: P_ENTERED_CR => ln_credit,
3697: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3698: P_ACCOUNTING_DATE => lv_accounting_date,
3699: P_REFERENCE_10 => lv_reference10,
3700: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3701: P_REFERENCE_24 => 'rcv_transactions',
3702: P_REFERENCE_25 => 'transaction_id',
3703: P_REFERENCE_26 => to_char(p_transaction_id),
3704: P_DESTINATION => 'G',
3737: P_ENTERED_CR => ln_edu_cess_credit,
3738: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3739: P_ACCOUNTING_DATE => lv_accounting_date,
3740: P_REFERENCE_10 => lv_reference10,
3741: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3742: P_REFERENCE_24 => 'rcv_transactions',
3743: P_REFERENCE_25 => 'transaction_id',
3744: P_REFERENCE_26 => to_char(p_transaction_id),
3745: P_DESTINATION => 'G',
3822: P_ENTERED_CR => ln_balancing_credit,
3823: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3824: P_ACCOUNTING_DATE => lv_accounting_date,
3825: P_REFERENCE_10 => lv_reference10,
3826: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3827: P_REFERENCE_24 => 'rcv_transactions',
3828: P_REFERENCE_25 => 'transaction_id',
3829: P_REFERENCE_26 => to_char(p_transaction_id),
3830: P_DESTINATION => 'G',
3865: P_ENTERED_CR => ln_edu_cess_balancing_credit,
3866: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3867: P_ACCOUNTING_DATE => lv_accounting_date,
3868: P_REFERENCE_10 => lv_reference10,
3869: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3870: P_REFERENCE_24 => 'rcv_transactions',
3871: P_REFERENCE_25 => 'transaction_id',
3872: P_REFERENCE_26 => to_char(p_transaction_id),
3873: P_DESTINATION => 'G',
3910: P_ENTERED_CR => ln_sh_edu_cess_balancin_credit,
3911: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
3912: P_ACCOUNTING_DATE => lv_accounting_date,
3913: P_REFERENCE_10 => lv_reference10,
3914: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
3915: P_REFERENCE_24 => 'rcv_transactions',
3916: P_REFERENCE_25 => 'transaction_id',
3917: P_REFERENCE_26 => to_char(p_transaction_id),
3918: P_DESTINATION => 'G',
4160: P_ENTERED_CR => ln_credit,
4161: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4162: P_ACCOUNTING_DATE => lv_accounting_date,
4163: P_REFERENCE_10 => lv_reference10,
4164: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4165: P_REFERENCE_24 => 'rcv_transactions',
4166: P_REFERENCE_25 => 'transaction_id',
4167: P_REFERENCE_26 => to_char(p_transaction_id),
4168: P_DESTINATION => 'G',
4203: P_ENTERED_CR => ln_edu_cess_credit,
4204: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4205: P_ACCOUNTING_DATE => lv_accounting_date,
4206: P_REFERENCE_10 => lv_reference10,
4207: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4208: P_REFERENCE_24 => 'rcv_transactions',
4209: P_REFERENCE_25 => 'transaction_id',
4210: P_REFERENCE_26 => to_char(p_transaction_id),
4211: P_DESTINATION => 'G',
4245: P_ENTERED_CR => ln_sh_edu_cess_credit,
4246: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4247: P_ACCOUNTING_DATE => lv_accounting_date,
4248: P_REFERENCE_10 => lv_reference10,
4249: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4250: P_REFERENCE_24 => 'rcv_transactions',
4251: P_REFERENCE_25 => 'transaction_id',
4252: P_REFERENCE_26 => to_char(p_transaction_id),
4253: P_DESTINATION => 'G',
4291: P_ENTERED_CR => ln_balancing_credit,
4292: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4293: P_ACCOUNTING_DATE => lv_accounting_date,
4294: P_REFERENCE_10 => lv_reference10,
4295: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4296: P_REFERENCE_24 => 'rcv_transactions',
4297: P_REFERENCE_25 => 'transaction_id',
4298: P_REFERENCE_26 => to_char(p_transaction_id),
4299: P_DESTINATION => 'G',
4334: P_ENTERED_CR => ln_bal_edu_cess_credit,
4335: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4336: P_ACCOUNTING_DATE => lv_accounting_date,
4337: P_REFERENCE_10 => lv_reference10,
4338: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4339: P_REFERENCE_24 => 'rcv_transactions',
4340: P_REFERENCE_25 => 'transaction_id',
4341: P_REFERENCE_26 => to_char(p_transaction_id),
4342: P_DESTINATION => 'G',
4377: P_ENTERED_CR => ln_sh_bal_edu_cess_credit,
4378: P_CURRENCY_CODE => jai_rcv_trx_processing_pkg.gv_func_curr,
4379: P_ACCOUNTING_DATE => lv_accounting_date,
4380: P_REFERENCE_10 => lv_reference10,
4381: P_REFERENCE_23 => 'jai_rcv_excise_processing_pkg.accounting_entries',
4382: P_REFERENCE_24 => 'rcv_transactions',
4383: P_REFERENCE_25 => 'transaction_id',
4384: P_REFERENCE_26 => to_char(p_transaction_id),
4385: P_DESTINATION => 'G',
4771: FROM JAI_RCV_CENVAT_CLAIMS
4772: WHERE shipment_line_id = cp_shipment_line_id;
4773:
4774: ln_cenvat_claimed_ptg NUMBER;
4775: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_receive_claimed_ptg';
4776:
4777: --ln_ancestor_receive_trxn_id JAI_RCV_TRANSACTIONS.transaction_id%TYPE;
4778:
4779: BEGIN
4816: ln_curr_conv NUMBER;
4817: ln_mod_problem_amt NUMBER;
4818: ln_nonmod_problem_amt NUMBER;
4819: ln_apportion_factor NUMBER;
4820: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_tax_amount_breakup';
4821:
4822: BEGIN
4823: /* This procedure returns excise amounts as per transaction quantity
4824: If p_breakup_type is RG23D, then total tax amount should be added to excise amount instead of taking
5030: p_process_status OUT NOCOPY VARCHAR2,
5031: p_process_message OUT NOCOPY VARCHAR2
5032: ) IS
5033: ln_source_type NUMBER(2);
5034: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.other_cenvat_rg_recording';
5035: BEGIN
5036:
5037: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5038: ln_source_type := jai_constants.reg_rg23_2_code;
5074:
5075: lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
5076: ln_receive_claimed_ptg NUMBER;
5077: lv_message VARCHAR2(200);
5078: lv_object_name varchar2(200) := 'jai_rcv_excise_processing_pkg.dervice_cgin_scenario';
5079:
5080: BEGIN
5081:
5082: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.cgin_scenario' , 'START'); /* 1 */
5647: lv_accounting_date DATE;
5648: lv_acct_nature JAI_RCV_JOURNAL_ENTRIES.acct_nature%TYPE;
5649: lv_acct_type JAI_RCV_JOURNAL_ENTRIES.acct_type%TYPE;
5650:
5651: r_diff_tax jai_rcv_excise_processing_pkg.TAX_BREAKUP;
5652: r_rtv_dtls c_rtv_dtls%ROWTYPE;
5653:
5654: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
5655: ln_excise_cess_rate NUMBER;
5680: r_base_trx c_base_trx%ROWTYPE;
5681: begin
5682:
5683: lv_statement_id := '1';
5684: pv_codepath := jai_general_pkg.plot_codepath(1, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'START');
5685: lv_simulate_flag := jai_constants.no;
5686: lv_register_entry_type := jai_rcv_excise_processing_pkg.cenvat_debit;
5687:
5688: open c_trx(pn_transaction_id);
5682:
5683: lv_statement_id := '1';
5684: pv_codepath := jai_general_pkg.plot_codepath(1, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'START');
5685: lv_simulate_flag := jai_constants.no;
5686: lv_register_entry_type := jai_rcv_excise_processing_pkg.cenvat_debit;
5687:
5688: open c_trx(pn_transaction_id);
5689: fetch c_trx into r_trx;
5690: close c_trx;
5739: --added by csahoo for bug#6078460, end
5740:
5741: lv_statement_id := '3';
5742: /* Start Register Entry */
5743: jai_rcv_excise_processing_pkg.derive_duty_registers(
5744: p_organization_id => r_trx.organization_id,
5745: p_location_id => r_trx.location_id,
5746: p_item_class => r_trx.item_class,
5747: pr_tax => r_diff_tax,
5762: pv_codepath := jai_general_pkg.plot_codepath(17, pv_codepath);
5763:
5764: lv_reference_num := 'CENVAT-SSI';
5765: /*
5766: jai_rcv_excise_processing_pkg.rg23_part_ii_entry(
5767: p_transaction_id => r_trx.transaction_id,
5768: pr_tax => r_diff_tax,
5769: p_part_i_register_id => null,
5770: p_register_entry_type => lv_register_entry_type,
5803: lv_statement_id := '7';
5804: pv_codepath := jai_general_pkg.plot_codepath(17.1, pv_codepath);
5805: /* Bug 5365346. Added by Lakshmi Gopalsami
5806: Commented the call to pla entry and added
5807: jai_rcv_excise_processing_pkg.pla_entry(
5808: p_transaction_id => r_trx.transaction_id,
5809: pr_tax => r_diff_tax,
5810: p_register_entry_type => lv_register_entry_type,
5811: p_register_id => ln_part_ii_register_id,
5910: if r_trx.transaction_type = 'CORRECT' THEN
5911: lv_reference10 := lv_reference10 || ' of '||r_trx.parent_transaction_type;
5912: end if;
5913:
5914: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
5915: ln_debit_amt := null;
5916: ln_credit_amt := r_diff_tax.basic_excise;
5917: ln_balancing_debit_amt := r_diff_tax.basic_excise;
5918: ln_balancing_credit_amt := null;
5928: jai_rcv_accounting_pkg.process_transaction(
5929: p_transaction_id => r_trx.transaction_id,
5930: p_acct_type => lv_acct_type,
5931: p_acct_nature => lv_acct_nature,
5932: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
5933: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
5934:
5935: p_code_combination_id => ln_ccid,
5936: p_entered_dr => ln_debit_amt,
5929: p_transaction_id => r_trx.transaction_id,
5930: p_acct_type => lv_acct_type,
5931: p_acct_nature => lv_acct_nature,
5932: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
5933: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
5934:
5935: p_code_combination_id => ln_ccid,
5936: p_entered_dr => ln_debit_amt,
5937: p_entered_cr => ln_credit_amt,
5938:
5939: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5940: p_accounting_date => lv_accounting_date,
5941: p_reference_10 => lv_reference10,
5942: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5943: p_reference_24 => lv_reference24, --'rcv_transactions',
5944: p_reference_25 => lv_reference25, --'transaction_id',
5945: p_reference_26 => lv_reference26, --
5946: p_destination => 'G',
5962: jai_rcv_accounting_pkg.process_transaction(
5963: p_transaction_id => r_trx.transaction_id,
5964: p_acct_type => lv_acct_type,
5965: p_acct_nature => lv_acct_nature,
5966: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
5967: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
5968:
5969: p_code_combination_id => ln_balancing_ccid,
5970: p_entered_dr => ln_balancing_debit_amt,
5963: p_transaction_id => r_trx.transaction_id,
5964: p_acct_type => lv_acct_type,
5965: p_acct_nature => lv_acct_nature,
5966: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
5967: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
5968:
5969: p_code_combination_id => ln_balancing_ccid,
5970: p_entered_dr => ln_balancing_debit_amt,
5971: p_entered_cr => ln_balancing_credit_amt,
5972:
5973: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
5974: p_accounting_date => lv_accounting_date,
5975: p_reference_10 => lv_reference10,
5976: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
5977: p_reference_24 => lv_reference24, --'rcv_transactions',
5978: p_reference_25 => lv_reference25, --'transaction_id',
5979: p_reference_26 => lv_reference26, --
5980: p_destination => 'G',
5997: lv_statement_id := '24';
5998: lv_acct_nature := 'CENVAT-EDUCESS-SSI';
5999: ln_ccid := ln_excise_cess_accnt_id;
6000:
6001: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
6002: ln_debit_amt := null;
6003: ln_credit_amt := r_diff_tax.excise_edu_cess;
6004: ln_balancing_debit_amt := r_diff_tax.excise_edu_cess;
6005: ln_balancing_credit_amt := null;
6015: jai_rcv_accounting_pkg.process_transaction(
6016: p_transaction_id => r_trx.transaction_id,
6017: p_acct_type => lv_acct_type,
6018: p_acct_nature => lv_acct_nature,
6019: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6020: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6021:
6022: p_code_combination_id => ln_ccid,
6023: p_entered_dr => ln_debit_amt,
6016: p_transaction_id => r_trx.transaction_id,
6017: p_acct_type => lv_acct_type,
6018: p_acct_nature => lv_acct_nature,
6019: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6020: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6021:
6022: p_code_combination_id => ln_ccid,
6023: p_entered_dr => ln_debit_amt,
6024: p_entered_cr => ln_credit_amt,
6025:
6026: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6027: p_accounting_date => lv_accounting_date,
6028: p_reference_10 => lv_reference10,
6029: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6030: p_reference_24 => lv_reference24, --'rcv_transactions',
6031: p_reference_25 => lv_reference25, --'transaction_id',
6032: p_reference_26 => lv_reference26, --
6033: p_destination => 'G',
6049: jai_rcv_accounting_pkg.process_transaction(
6050: p_transaction_id => r_trx.transaction_id,
6051: p_acct_type => lv_acct_type,
6052: p_acct_nature => lv_acct_nature,
6053: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6054: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6055:
6056: p_code_combination_id => ln_balancing_ccid,
6057: p_entered_dr => ln_balancing_debit_amt,
6050: p_transaction_id => r_trx.transaction_id,
6051: p_acct_type => lv_acct_type,
6052: p_acct_nature => lv_acct_nature,
6053: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6054: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6055:
6056: p_code_combination_id => ln_balancing_ccid,
6057: p_entered_dr => ln_balancing_debit_amt,
6058: p_entered_cr => ln_balancing_credit_amt,
6059:
6060: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6061: p_accounting_date => lv_accounting_date,
6062: p_reference_10 => lv_reference10,
6063: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6064: p_reference_24 => lv_reference24, --'rcv_transactions',
6065: p_reference_25 => lv_reference25, --'transaction_id',
6066: p_reference_26 => lv_reference26, --
6067: p_destination => 'G',
6087: lv_statement_id := '29';
6088: lv_acct_nature := 'CENVAT-SH-EDUCESS-SSI';
6089: ln_ccid := ln_excise_sh_cess_accnt_id;
6090:
6091: if lv_register_entry_type = jai_rcv_excise_processing_pkg.CENVAT_DEBIT then
6092: ln_debit_amt := null;
6093: ln_credit_amt := r_diff_tax.sh_exc_edu_cess;
6094: ln_balancing_debit_amt := r_diff_tax.sh_exc_edu_cess;
6095: ln_balancing_credit_amt := null;
6105: jai_rcv_accounting_pkg.process_transaction(
6106: p_transaction_id => r_trx.transaction_id,
6107: p_acct_type => lv_acct_type,
6108: p_acct_nature => lv_acct_nature,
6109: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6110: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6111:
6112: p_code_combination_id => ln_ccid,
6113: p_entered_dr => ln_debit_amt,
6106: p_transaction_id => r_trx.transaction_id,
6107: p_acct_type => lv_acct_type,
6108: p_acct_nature => lv_acct_nature,
6109: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6110: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6111:
6112: p_code_combination_id => ln_ccid,
6113: p_entered_dr => ln_debit_amt,
6114: p_entered_cr => ln_credit_amt,
6115:
6116: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6117: p_accounting_date => lv_accounting_date,
6118: p_reference_10 => lv_reference10,
6119: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6120: p_reference_24 => lv_reference24, --'rcv_transactions',
6121: p_reference_25 => lv_reference25, --'transaction_id',
6122: p_reference_26 => lv_reference26, --
6123: p_destination => 'G',
6139: jai_rcv_accounting_pkg.process_transaction(
6140: p_transaction_id => r_trx.transaction_id,
6141: p_acct_type => lv_acct_type,
6142: p_acct_nature => lv_acct_nature,
6143: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6144: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6145:
6146: p_code_combination_id => ln_balancing_ccid,
6147: p_entered_dr => ln_balancing_debit_amt,
6140: p_transaction_id => r_trx.transaction_id,
6141: p_acct_type => lv_acct_type,
6142: p_acct_nature => lv_acct_nature,
6143: p_source_name => jai_rcv_excise_processing_pkg.gv_source_name,
6144: p_category_name => jai_rcv_excise_processing_pkg.gv_category_name,
6145:
6146: p_code_combination_id => ln_balancing_ccid,
6147: p_entered_dr => ln_balancing_debit_amt,
6148: p_entered_cr => ln_balancing_credit_amt,
6149:
6150: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
6151: p_accounting_date => lv_accounting_date,
6152: p_reference_10 => lv_reference10,
6153: p_reference_23 => lv_reference23, --'jai_rcv_excise_processing_pkg.accounting_entries',
6154: p_reference_24 => lv_reference24, --'rcv_transactions',
6155: p_reference_25 => lv_reference25, --'transaction_id',
6156: p_reference_26 => lv_reference26, --
6157: p_destination => 'G',
6175:
6176: lv_statement_id := '29';
6177: pv_process_status := jai_constants.yes;
6178: <
6179: pv_codepath := jai_general_pkg.plot_codepath(75, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6180:
6181: exception
6182: when others then
6183: pv_process_status := 'E';
6180:
6181: exception
6182: when others then
6183: pv_process_status := 'E';
6184: pv_process_message := 'Unexpected error in jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(StmtId:'
6185: ||lv_statement_id||'). ErrMsg:'||SQLERRM;
6186: pv_codepath := jai_general_pkg.plot_codepath(999, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6187:
6188: end rtv_processing_for_ssi;
6182: when others then
6183: pv_process_status := 'E';
6184: pv_process_message := 'Unexpected error in jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(StmtId:'
6185: ||lv_statement_id||'). ErrMsg:'||SQLERRM;
6186: pv_codepath := jai_general_pkg.plot_codepath(999, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6187:
6188: end rtv_processing_for_ssi;
6189:
6190: END jai_rcv_excise_processing_pkg;
6186: pv_codepath := jai_general_pkg.plot_codepath(999, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6187:
6188: end rtv_processing_for_ssi;
6189:
6190: END jai_rcv_excise_processing_pkg;