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_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 813: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,

809: SET credit = credit + ln_other_tax_credit,
810: debit = debit + ln_other_tax_debit,
811: opening_balance = opening_balance,
812: closing_balance = closing_balance + ln_ex_cess_diff
813: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
814: decode(lv_register_type,
815: jai_constants.register_type_a,
816: jai_constants.reg_rg23a_2,
817: jai_constants.reg_rg23c_2

Line 815: jai_constants.register_type_a,

811: opening_balance = opening_balance,
812: closing_balance = closing_balance + ln_ex_cess_diff
813: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
814: decode(lv_register_type,
815: jai_constants.register_type_a,
816: jai_constants.reg_rg23a_2,
817: jai_constants.reg_rg23c_2
818: )
819: )

Line 816: jai_constants.reg_rg23a_2,

812: closing_balance = closing_balance + ln_ex_cess_diff
813: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
814: decode(lv_register_type,
815: jai_constants.register_type_a,
816: jai_constants.reg_rg23a_2,
817: jai_constants.reg_rg23c_2
818: )
819: )
820: AND source_register_id = p_register_id

Line 817: jai_constants.reg_rg23c_2

813: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
814: decode(lv_register_type,
815: jai_constants.register_type_a,
816: jai_constants.reg_rg23a_2,
817: jai_constants.reg_rg23c_2
818: )
819: )
820: AND source_register_id = p_register_id
821: AND tax_type = jai_constants.tax_type_exc_edu_cess;

Line 821: AND tax_type = jai_constants.tax_type_exc_edu_cess;

817: jai_constants.reg_rg23c_2
818: )
819: )
820: AND source_register_id = p_register_id
821: AND tax_type = jai_constants.tax_type_exc_edu_cess;
822: END IF; /* Excise cess*/
823:
824: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
825:

Line 841: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,

837: SET credit = credit + ln_other_tax_credit,
838: debit = debit + ln_other_tax_debit,
839: opening_balance = opening_balance,
840: closing_balance = closing_balance + ln_cvd_cess_diff
841: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
842: decode(lv_register_type,
843: jai_constants.register_type_a,
844: jai_constants.reg_rg23a_2,
845: jai_constants.reg_rg23c_2

Line 843: jai_constants.register_type_a,

839: opening_balance = opening_balance,
840: closing_balance = closing_balance + ln_cvd_cess_diff
841: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
842: decode(lv_register_type,
843: jai_constants.register_type_a,
844: jai_constants.reg_rg23a_2,
845: jai_constants.reg_rg23c_2
846: )
847: )

Line 844: jai_constants.reg_rg23a_2,

840: closing_balance = closing_balance + ln_cvd_cess_diff
841: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
842: decode(lv_register_type,
843: jai_constants.register_type_a,
844: jai_constants.reg_rg23a_2,
845: jai_constants.reg_rg23c_2
846: )
847: )
848: AND source_register_id = p_register_id

Line 845: jai_constants.reg_rg23c_2

841: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
842: decode(lv_register_type,
843: jai_constants.register_type_a,
844: jai_constants.reg_rg23a_2,
845: jai_constants.reg_rg23c_2
846: )
847: )
848: AND source_register_id = p_register_id
849: AND tax_type = jai_constants.tax_type_cvd_edu_cess;

Line 849: AND tax_type = jai_constants.tax_type_cvd_edu_cess;

845: jai_constants.reg_rg23c_2
846: )
847: )
848: AND source_register_id = p_register_id
849: AND tax_type = jai_constants.tax_type_cvd_edu_cess;
850: END IF; /* CVD Cess */
851:
852: --For Excise SH Edu cess
853: IF pr_diff_tax.sh_exc_edu_cess <> 0 THEN

Line 868: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,

864: SET credit = credit + ln_other_tax_credit,
865: debit = debit + ln_other_tax_debit,
866: opening_balance = opening_balance,
867: closing_balance = closing_balance + ln_ex_sh_cess_diff
868: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
869: decode(lv_register_type,
870: jai_constants.register_type_a,
871: jai_constants.reg_rg23a_2,
872: jai_constants.reg_rg23c_2

Line 870: jai_constants.register_type_a,

866: opening_balance = opening_balance,
867: closing_balance = closing_balance + ln_ex_sh_cess_diff
868: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
869: decode(lv_register_type,
870: jai_constants.register_type_a,
871: jai_constants.reg_rg23a_2,
872: jai_constants.reg_rg23c_2
873: )
874: )

Line 871: jai_constants.reg_rg23a_2,

867: closing_balance = closing_balance + ln_ex_sh_cess_diff
868: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
869: decode(lv_register_type,
870: jai_constants.register_type_a,
871: jai_constants.reg_rg23a_2,
872: jai_constants.reg_rg23c_2
873: )
874: )
875: AND source_register_id = p_register_id

Line 872: jai_constants.reg_rg23c_2

868: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
869: decode(lv_register_type,
870: jai_constants.register_type_a,
871: jai_constants.reg_rg23a_2,
872: jai_constants.reg_rg23c_2
873: )
874: )
875: AND source_register_id = p_register_id
876: AND tax_type = jai_constants.tax_type_sh_exc_edu_cess;

Line 876: AND tax_type = jai_constants.tax_type_sh_exc_edu_cess;

872: jai_constants.reg_rg23c_2
873: )
874: )
875: AND source_register_id = p_register_id
876: AND tax_type = jai_constants.tax_type_sh_exc_edu_cess;
877: END IF; /* Excise SH cess*/
878:
879: --For CVD SH cess
880: IF pr_diff_tax.sh_cvd_edu_cess <> 0 THEN

Line 895: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,

891: SET credit = credit + ln_other_tax_credit,
892: debit = debit + ln_other_tax_debit,
893: opening_balance = opening_balance,
894: closing_balance = closing_balance + ln_cvd_sh_cess_diff
895: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
896: decode(lv_register_type,
897: jai_constants.register_type_a,
898: jai_constants.reg_rg23a_2,
899: jai_constants.reg_rg23c_2

Line 897: jai_constants.register_type_a,

893: opening_balance = opening_balance,
894: closing_balance = closing_balance + ln_cvd_sh_cess_diff
895: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
896: decode(lv_register_type,
897: jai_constants.register_type_a,
898: jai_constants.reg_rg23a_2,
899: jai_constants.reg_rg23c_2
900: )
901: )

Line 898: jai_constants.reg_rg23a_2,

894: closing_balance = closing_balance + ln_cvd_sh_cess_diff
895: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
896: decode(lv_register_type,
897: jai_constants.register_type_a,
898: jai_constants.reg_rg23a_2,
899: jai_constants.reg_rg23c_2
900: )
901: )
902: AND source_register_id = p_register_id

Line 899: jai_constants.reg_rg23c_2

895: WHERE source_register = decode(p_source_reg,'PLA', jai_constants.reg_pla,
896: decode(lv_register_type,
897: jai_constants.register_type_a,
898: jai_constants.reg_rg23a_2,
899: jai_constants.reg_rg23c_2
900: )
901: )
902: AND source_register_id = p_register_id
903: AND tax_type = jai_constants.tax_type_sh_cvd_edu_cess;

Line 903: AND tax_type = jai_constants.tax_type_sh_cvd_edu_cess;

899: jai_constants.reg_rg23c_2
900: )
901: )
902: AND source_register_id = p_register_id
903: AND tax_type = jai_constants.tax_type_sh_cvd_edu_cess;
904: END IF; /* CVD SH Cess */
905:
906: EXCEPTION
907: WHEN OTHERS THEN

Line 1725: OR lv_cenvat_register_type IN (jai_constants.register_type_a, jai_constants.register_type_c)

1721: lv_edu_cess_register_type := NULL;
1722: END IF;
1723:
1724: IF (lv_cenvat_register_type IS NULL AND lv_edu_cess_register_type IS NULL)
1725: OR lv_cenvat_register_type IN (jai_constants.register_type_a, jai_constants.register_type_c)
1726: THEN
1727:
1728: lv_statement_id := '13';
1729: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);

Line 1777: ELSIF lv_cenvat_register_type = jai_constants.register_type_pla THEN

1773: END IF;
1774:
1775: END IF;
1776:
1777: ELSIF lv_cenvat_register_type = jai_constants.register_type_pla THEN
1778:
1779: lv_statement_id := '13.2';
1780: p_codepath := jai_general_pkg.plot_codepath(17.1, p_codepath);
1781: pla_entry(

Line 2535: AND tax_type IN (jai_constants.tax_type_excise,

2531: CURSOR c_tax_rate(cp_shipment_line_id IN NUMBER) IS
2532: SELECT tax_rate
2533: FROM JAI_RCV_LINE_TAXES
2534: WHERE shipment_line_id = cp_shipment_line_id
2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,
2538: jai_constants.tax_type_cvd,
2539: jai_constants.tax_type_add_cvd)

Line 2536: jai_constants.tax_type_exc_additional,

2532: SELECT tax_rate
2533: FROM JAI_RCV_LINE_TAXES
2534: WHERE shipment_line_id = cp_shipment_line_id
2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,
2538: jai_constants.tax_type_cvd,
2539: jai_constants.tax_type_add_cvd)
2540: --AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD')

Line 2537: jai_constants.tax_type_exc_other,

2533: FROM JAI_RCV_LINE_TAXES
2534: WHERE shipment_line_id = cp_shipment_line_id
2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,
2538: jai_constants.tax_type_cvd,
2539: jai_constants.tax_type_add_cvd)
2540: --AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD')
2541: -- we need not include the CESS here, because the rate should correspond to actual tax instead of cess

Line 2538: jai_constants.tax_type_cvd,

2534: WHERE shipment_line_id = cp_shipment_line_id
2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,
2538: jai_constants.tax_type_cvd,
2539: jai_constants.tax_type_add_cvd)
2540: --AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD')
2541: -- we need not include the CESS here, because the rate should correspond to actual tax instead of cess
2542: ORDER BY tax_line_no;

Line 2539: jai_constants.tax_type_add_cvd)

2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,
2538: jai_constants.tax_type_cvd,
2539: jai_constants.tax_type_add_cvd)
2540: --AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD')
2541: -- we need not include the CESS here, because the rate should correspond to actual tax instead of cess
2542: ORDER BY tax_line_no;
2543:

Line 2773: p_source_register => jai_constants.reg_rg23d,

2769: ELSE
2770: ln_other_tax_credit := pr_tax.excise_edu_cess;
2771: END IF;
2772: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2773: p_source_register => jai_constants.reg_rg23d,
2774: p_source_register_id => p_register_id,
2775: p_tax_type => jai_constants.tax_type_exc_edu_cess,
2776: p_credit => ln_other_tax_credit,
2777: p_debit => ln_other_tax_debit,

Line 2775: p_tax_type => jai_constants.tax_type_exc_edu_cess,

2771: END IF;
2772: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2773: p_source_register => jai_constants.reg_rg23d,
2774: p_source_register_id => p_register_id,
2775: p_tax_type => jai_constants.tax_type_exc_edu_cess,
2776: p_credit => ln_other_tax_credit,
2777: p_debit => ln_other_tax_debit,
2778: p_process_status => p_process_status,
2779: p_process_message => p_process_message

Line 2793: p_source_register => jai_constants.reg_rg23d,

2789: ELSE
2790: ln_other_tax_credit := pr_tax.cvd_edu_cess;
2791: END IF;
2792: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2793: p_source_register => jai_constants.reg_rg23d,
2794: p_source_register_id => p_register_id,
2795: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
2796: p_credit => ln_other_tax_credit,
2797: p_debit => ln_other_tax_debit,

Line 2795: p_tax_type => jai_constants.tax_type_cvd_edu_cess,

2791: END IF;
2792: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2793: p_source_register => jai_constants.reg_rg23d,
2794: p_source_register_id => p_register_id,
2795: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
2796: p_credit => ln_other_tax_credit,
2797: p_debit => ln_other_tax_debit,
2798: p_process_status => p_process_status,
2799: p_process_message => p_process_message

Line 2815: p_source_register => jai_constants.reg_rg23d,

2811: ln_other_tax_credit := pr_tax.sh_exc_edu_cess;
2812: END IF;
2813:
2814: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2815: p_source_register => jai_constants.reg_rg23d,
2816: p_source_register_id => p_register_id,
2817: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
2818: p_credit => ln_other_tax_credit,
2819: p_debit => ln_other_tax_debit,

Line 2817: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,

2813:
2814: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2815: p_source_register => jai_constants.reg_rg23d,
2816: p_source_register_id => p_register_id,
2817: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
2818: p_credit => ln_other_tax_credit,
2819: p_debit => ln_other_tax_debit,
2820: p_process_status => p_process_status,
2821: p_process_message => p_process_message

Line 2835: p_source_register => jai_constants.reg_rg23d,

2831: ELSE
2832: ln_other_tax_credit := pr_tax.sh_cvd_edu_cess;
2833: END IF;
2834: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2835: p_source_register => jai_constants.reg_rg23d,
2836: p_source_register_id => p_register_id,
2837: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
2838: p_credit => ln_other_tax_credit,
2839: p_debit => ln_other_tax_debit,

Line 2837: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,

2833: END IF;
2834: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
2835: p_source_register => jai_constants.reg_rg23d,
2836: p_source_register_id => p_register_id,
2837: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
2838: p_credit => ln_other_tax_credit,
2839: p_debit => ln_other_tax_debit,
2840: p_process_status => p_process_status,
2841: p_process_message => p_process_message

Line 3114: if lv_register_type = jai_constants.register_type_a then

3110: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23ac_ii_pkg.insert_row');
3111: end if;
3112:
3113: lv_register_type := jai_general_pkg.get_rg_register_type(r_trx.item_class);
3114: if lv_register_type = jai_constants.register_type_a then
3115: lv_source_register := jai_constants.reg_rg23a_2;
3116: else
3117: lv_source_register := jai_constants.reg_rg23c_2;
3118: end if;

Line 3115: lv_source_register := jai_constants.reg_rg23a_2;

3111: end if;
3112:
3113: lv_register_type := jai_general_pkg.get_rg_register_type(r_trx.item_class);
3114: if lv_register_type = jai_constants.register_type_a then
3115: lv_source_register := jai_constants.reg_rg23a_2;
3116: else
3117: lv_source_register := jai_constants.reg_rg23c_2;
3118: end if;
3119:

Line 3117: lv_source_register := jai_constants.reg_rg23c_2;

3113: lv_register_type := jai_general_pkg.get_rg_register_type(r_trx.item_class);
3114: if lv_register_type = jai_constants.register_type_a then
3115: lv_source_register := jai_constants.reg_rg23a_2;
3116: else
3117: lv_source_register := jai_constants.reg_rg23c_2;
3118: end if;
3119:
3120: lv_statement_id := '5';
3121: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

Line 3172: p_tax_type => jai_constants.tax_type_exc_edu_cess,

3168: END IF;
3169: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3170: p_source_register => lv_source_register,
3171: p_source_register_id => p_register_id,
3172: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3173: p_credit => ln_other_tax_credit,
3174: p_debit => ln_other_tax_debit,
3175: p_process_status => p_process_status,
3176: p_process_message => p_process_message

Line 3197: p_tax_type => jai_constants.tax_type_cvd_edu_cess,

3193: END IF;
3194: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3195: p_source_register => lv_source_register,
3196: p_source_register_id => p_register_id,
3197: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3198: p_credit => ln_other_tax_credit,
3199: p_debit => ln_other_tax_debit,
3200: p_process_status => p_process_status,
3201: p_process_message => p_process_message

Line 3216: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,

3212: END IF;
3213: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3214: p_source_register => lv_source_register,
3215: p_source_register_id => p_register_id,
3216: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3217: p_credit => ln_other_tax_credit,
3218: p_debit => ln_other_tax_debit,
3219: p_process_status => p_process_status,
3220: p_process_message => p_process_message

Line 3241: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,

3237: END IF;
3238: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3239: p_source_register => lv_source_register,
3240: p_source_register_id => p_register_id,
3241: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3242: p_credit => ln_other_tax_credit,
3243: p_debit => ln_other_tax_debit,
3244: p_process_status => p_process_status,
3245: p_process_message => p_process_message

Line 3443: p_source_register => jai_constants.reg_pla,

3439: ELSE
3440: ln_other_tax_credit := pr_tax.excise_edu_cess;
3441: END IF;
3442: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3443: p_source_register => jai_constants.reg_pla,
3444: p_source_register_id => p_register_id,
3445: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3446: p_credit => ln_other_tax_credit,
3447: p_debit => ln_other_tax_debit,

Line 3445: p_tax_type => jai_constants.tax_type_exc_edu_cess,

3441: END IF;
3442: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3443: p_source_register => jai_constants.reg_pla,
3444: p_source_register_id => p_register_id,
3445: p_tax_type => jai_constants.tax_type_exc_edu_cess,
3446: p_credit => ln_other_tax_credit,
3447: p_debit => ln_other_tax_debit,
3448: p_process_status => p_process_status,
3449: p_process_message => p_process_message

Line 3468: p_source_register => jai_constants.reg_pla,

3464: ELSE
3465: ln_other_tax_credit := pr_tax.cvd_edu_cess;
3466: END IF;
3467: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3468: p_source_register => jai_constants.reg_pla,
3469: p_source_register_id => p_register_id,
3470: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3471: p_credit => ln_other_tax_credit,
3472: p_debit => ln_other_tax_debit,

Line 3470: p_tax_type => jai_constants.tax_type_cvd_edu_cess,

3466: END IF;
3467: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3468: p_source_register => jai_constants.reg_pla,
3469: p_source_register_id => p_register_id,
3470: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
3471: p_credit => ln_other_tax_credit,
3472: p_debit => ln_other_tax_debit,
3473: p_process_status => p_process_status,
3474: p_process_message => p_process_message

Line 3489: p_source_register => jai_constants.reg_pla,

3485: ln_other_tax_credit := nvl(pr_tax.sh_exc_edu_cess,0);
3486: END IF;
3487:
3488: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3489: p_source_register => jai_constants.reg_pla,
3490: p_source_register_id => p_register_id,
3491: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3492: p_credit => ln_other_tax_credit,
3493: p_debit => ln_other_tax_debit,

Line 3491: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,

3487:
3488: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3489: p_source_register => jai_constants.reg_pla,
3490: p_source_register_id => p_register_id,
3491: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
3492: p_credit => ln_other_tax_credit,
3493: p_debit => ln_other_tax_debit,
3494: p_process_status => p_process_status,
3495: p_process_message => p_process_message

Line 3514: p_source_register => jai_constants.reg_pla,

3510: ELSE
3511: ln_other_tax_credit := nvl(pr_tax.sh_cvd_edu_cess,0);
3512: END IF;
3513: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3514: p_source_register => jai_constants.reg_pla,
3515: p_source_register_id => p_register_id,
3516: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3517: p_credit => ln_other_tax_credit,
3518: p_debit => ln_other_tax_debit,

Line 3516: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,

3512: END IF;
3513: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
3514: p_source_register => jai_constants.reg_pla,
3515: p_source_register_id => p_register_id,
3516: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
3517: p_credit => ln_other_tax_credit,
3518: p_debit => ln_other_tax_debit,
3519: p_process_status => p_process_status,
3520: p_process_message => p_process_message

Line 4917: jai_constants.tax_type_add_cvd,1,

4913: sum( decode(upper(tax_type), 'EXCISE', 1,
4914: 'ADDL. EXCISE', 1,
4915: 'OTHER EXCISE', 1,
4916: 'CVD', 1,
4917: jai_constants.tax_type_add_cvd,1,
4918: jai_constants.tax_type_exc_edu_cess,1,
4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt

Line 4918: jai_constants.tax_type_exc_edu_cess,1,

4914: 'ADDL. EXCISE', 1,
4915: 'OTHER EXCISE', 1,
4916: 'CVD', 1,
4917: jai_constants.tax_type_add_cvd,1,
4918: jai_constants.tax_type_exc_edu_cess,1,
4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt
4922: FROM JAI_RCV_LINE_TAXES

Line 4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,

4915: 'OTHER EXCISE', 1,
4916: 'CVD', 1,
4917: jai_constants.tax_type_add_cvd,1,
4918: jai_constants.tax_type_exc_edu_cess,1,
4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt
4922: FROM JAI_RCV_LINE_TAXES
4923: WHERE shipment_line_id = cp_shipment_line_id

Line 4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS

4916: 'CVD', 1,
4917: jai_constants.tax_type_add_cvd,1,
4918: jai_constants.tax_type_exc_edu_cess,1,
4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt
4922: FROM JAI_RCV_LINE_TAXES
4923: WHERE shipment_line_id = cp_shipment_line_id
4924: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery);

Line 4924: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery);

4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt
4922: FROM JAI_RCV_LINE_TAXES
4923: WHERE shipment_line_id = cp_shipment_line_id
4924: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery);
4925:
4926: r_taxes c_taxes%ROWTYPE;
4927:
4928: BEGIN

Line 4978: ELSIF r_base_trx.source_document_code IN ( jai_constants.source_po,lv_source_req ) THEN /* added by aiyer for the bug 5378630 */

4974: /* End of bug 5378630 */
4975: lv_validation_message := 'RMA Type Not supported';
4976:
4977: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_base_trx.attr_cat = 'India Receipt' THEN
4978: ELSIF r_base_trx.source_document_code IN ( jai_constants.source_po,lv_source_req ) THEN /* added by aiyer for the bug 5378630 */
4979: IF r_trx.organization_type = 'M' AND r_trx.item_class IN ('FGIN', 'FGEX')
4980: and r_base_trx.source_document_code NOT IN ('REQ','INVENTORY') THEN /* 6030615 - interorg */ --added 'REQ' for bug #13514510
4981: lv_validation_message := 'Item Class not supported for Manufacturing Transactions';
4982:

Line 5271: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess THEN

5267: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
5268: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5269:
5270: -- Start, Vijay Shankar for Bug#3940588
5271: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess THEN
5272: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5273:
5274: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess THEN
5275: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);

Line 5274: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess THEN

5270: -- Start, Vijay Shankar for Bug#3940588
5271: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess THEN
5272: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5273:
5274: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess THEN
5275: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5276: -- End, Vijay Shankar for Bug#3940588
5277: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5278: --start

Line 5279: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess THEN

5275: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5276: -- End, Vijay Shankar for Bug#3940588
5277: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5278: --start
5279: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess THEN
5280: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5281:
5282: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess THEN
5283: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);

Line 5282: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess THEN

5278: --start
5279: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess THEN
5280: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5281:
5282: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess THEN
5283: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5284:
5285: --end bug #5989740*/
5286:

Line 5287: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd THEN

5283: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5284:
5285: --end bug #5989740*/
5286:
5287: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd THEN
5288: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
5289: pr_tax.addl_cvd := pr_tax.addl_cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5290: --Added by Wenqiong for the bug12645490 on 22/06/2011 begin.
5291: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN

Line 5291: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN

5287: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd THEN
5288: p_codepath := jai_general_pkg.plot_codepath(7.1, p_codepath); /* 7.1 */
5289: pr_tax.addl_cvd := pr_tax.addl_cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5290: --Added by Wenqiong for the bug12645490 on 22/06/2011 begin.
5291: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN
5292: pr_tax.any_other_boe_1 := pr_tax.any_other_boe_1 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5293: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN
5294: pr_tax.any_other_boe_2 := pr_tax.any_other_boe_2 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN

Line 5293: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN

5289: pr_tax.addl_cvd := pr_tax.addl_cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5290: --Added by Wenqiong for the bug12645490 on 22/06/2011 begin.
5291: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN
5292: pr_tax.any_other_boe_1 := pr_tax.any_other_boe_1 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5293: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN
5294: pr_tax.any_other_boe_2 := pr_tax.any_other_boe_2 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN
5296: pr_tax.any_other_boe_3 := pr_tax.any_other_boe_3 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5297: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN

Line 5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN

5291: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN
5292: pr_tax.any_other_boe_1 := pr_tax.any_other_boe_1 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5293: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN
5294: pr_tax.any_other_boe_2 := pr_tax.any_other_boe_2 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN
5296: pr_tax.any_other_boe_3 := pr_tax.any_other_boe_3 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5297: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN
5298: pr_tax.any_other_boe_4 := pr_tax.any_other_boe_4 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5299: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN

Line 5297: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN

5293: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN
5294: pr_tax.any_other_boe_2 := pr_tax.any_other_boe_2 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN
5296: pr_tax.any_other_boe_3 := pr_tax.any_other_boe_3 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5297: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN
5298: pr_tax.any_other_boe_4 := pr_tax.any_other_boe_4 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5299: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN
5300: pr_tax.any_other_boe_5 := pr_tax.any_other_boe_5 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5301: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.

Line 5299: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN

5295: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN
5296: pr_tax.any_other_boe_3 := pr_tax.any_other_boe_3 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5297: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN
5298: pr_tax.any_other_boe_4 := pr_tax.any_other_boe_4 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5299: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN
5300: pr_tax.any_other_boe_5 := pr_tax.any_other_boe_5 + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5301: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.
5302: ELSE
5303: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 5316: jai_constants.tax_type_exc_edu_cess,

5312: 'OTHER EXCISE', 'CVD',
5313: -- Bug 5143906. Added by Lakshmi Gopalsami
5314: -- Included Addl. CVD
5315: 'ADDITIONAL_CVD',
5316: jai_constants.tax_type_exc_edu_cess,
5317: jai_constants.tax_type_cvd_edu_cess,
5318: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,

Line 5317: jai_constants.tax_type_cvd_edu_cess,

5313: -- Bug 5143906. Added by Lakshmi Gopalsami
5314: -- Included Addl. CVD
5315: 'ADDITIONAL_CVD',
5316: jai_constants.tax_type_exc_edu_cess,
5317: jai_constants.tax_type_cvd_edu_cess,
5318: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.

Line 5319: jai_constants.tax_type_sh_cvd_edu_cess,

5315: 'ADDITIONAL_CVD',
5316: jai_constants.tax_type_exc_edu_cess,
5317: jai_constants.tax_type_cvd_edu_cess,
5318: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,

Line 5320: jai_constants.tax_type_sh_exc_edu_cess,

5316: jai_constants.tax_type_exc_edu_cess,
5317: jai_constants.tax_type_cvd_edu_cess,
5318: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,

Line 5322: jai_constants.tax_type_boe_other1,

5318: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,
5325: jai_constants.tax_type_boe_other4,
5326: jai_constants.tax_type_boe_other5

Line 5323: jai_constants.tax_type_boe_other2,

5319: jai_constants.tax_type_sh_cvd_edu_cess,
5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,
5325: jai_constants.tax_type_boe_other4,
5326: jai_constants.tax_type_boe_other5
5327: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.

Line 5324: jai_constants.tax_type_boe_other3,

5320: jai_constants.tax_type_sh_exc_edu_cess,
5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,
5325: jai_constants.tax_type_boe_other4,
5326: jai_constants.tax_type_boe_other5
5327: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.
5328: )

Line 5325: jai_constants.tax_type_boe_other4,

5321: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,
5325: jai_constants.tax_type_boe_other4,
5326: jai_constants.tax_type_boe_other5
5327: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.
5328: )
5329: THEN

Line 5326: jai_constants.tax_type_boe_other5

5322: jai_constants.tax_type_boe_other1,
5323: jai_constants.tax_type_boe_other2,
5324: jai_constants.tax_type_boe_other3,
5325: jai_constants.tax_type_boe_other4,
5326: jai_constants.tax_type_boe_other5
5327: --Added by Wenqiong for the bug12645490 on 22/06/2011 End.
5328: )
5329: THEN
5330:

Line 5400: ELSIF tax_rec.tax_type IN ( jai_constants.tax_type_add_cvd) THEN

5396:
5397:
5398: -- Date 04/06/2007 by sacsethi for bug 6109941
5399: -- Code review from bug 5228046
5400: ELSIF tax_rec.tax_type IN ( jai_constants.tax_type_add_cvd) THEN
5401: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath); /* 14 */
5402: pr_tax.addl_cvd := pr_tax.addl_cvd
5403: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5404: --12817175

Line 5418: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess THEN

5414:
5415:
5416: -------------------------------------------------
5417: -- Start, Vijay Shankar for Bug#3940588
5418: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess THEN
5419: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess +
5420: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5421: --12817175
5422: If TAX_REC.inclusive_tax_flag='Y'

Line 5433: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess THEN

5429: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5430: end if;
5431:
5432:
5433: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess THEN
5434: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess
5435: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5436: --12817175
5437: If TAX_REC.inclusive_tax_flag='Y'

Line 5451: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess THEN

5447:
5448: -- End, Vijay Shankar for Bug#3940588
5449: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5450: --start
5451: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess THEN
5452:
5453: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0)+
5454: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5455: --12817175

Line 5467: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess THEN

5463: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5464: end if;
5465:
5466:
5467: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess THEN
5468:
5469: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0)+
5470: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5471: --12817175

Line 5485: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN

5481:
5482:
5483: --end ,for bug #5989740
5484: --Added by Wenqiong for the bug12645490 on 22/06/2011 Begin.
5485: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other1 THEN
5486:
5487: pr_tax.any_other_boe_1 := nvl(pr_tax.any_other_boe_1,0)+
5488: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5489: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 5491: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN

5487: pr_tax.any_other_boe_1 := nvl(pr_tax.any_other_boe_1,0)+
5488: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5489: pr_tax.non_cenvat := pr_tax.non_cenvat
5490: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5491: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other2 THEN
5492:
5493: pr_tax.any_other_boe_2 := nvl(pr_tax.any_other_boe_2,0)+
5494: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5495: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 5497: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN

5493: pr_tax.any_other_boe_2 := nvl(pr_tax.any_other_boe_2,0)+
5494: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5495: pr_tax.non_cenvat := pr_tax.non_cenvat
5496: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5497: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other3 THEN
5498:
5499: pr_tax.any_other_boe_3 := nvl(pr_tax.any_other_boe_3,0)+
5500: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5501: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 5503: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN

5499: pr_tax.any_other_boe_3 := nvl(pr_tax.any_other_boe_3,0)+
5500: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5501: pr_tax.non_cenvat := pr_tax.non_cenvat
5502: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5503: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other4 THEN
5504:
5505: pr_tax.any_other_boe_4 := nvl(pr_tax.any_other_boe_4,0)+
5506: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5507: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 5509: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN

5505: pr_tax.any_other_boe_4 := nvl(pr_tax.any_other_boe_4,0)+
5506: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5507: pr_tax.non_cenvat := pr_tax.non_cenvat
5508: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5509: ELSIF tax_rec.tax_type = jai_constants.tax_type_boe_other5 THEN
5510:
5511: pr_tax.any_other_boe_5 := nvl(pr_tax.any_other_boe_5,0)+
5512: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
5513: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN

5566: ln_source_type NUMBER(2);
5567: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.other_cenvat_rg_recording';
5568: BEGIN
5569:
5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN

Line 5571: ln_source_type := jai_constants.reg_rg23_2_code;

5567: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.other_cenvat_rg_recording';
5568: BEGIN
5569:
5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;

Line 5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN

5568: BEGIN
5569:
5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN

Line 5573: ln_source_type := jai_constants.reg_rg23d_code;

5569:
5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;

Line 5574: ELSIF p_source_register = jai_constants.reg_pla THEN

5570: IF p_source_register IN (jai_constants.reg_rg23a_2, jai_constants.reg_rg23c_2) THEN
5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5578: END IF;

Line 5575: ln_source_type := jai_constants.reg_pla_code;

5571: ln_source_type := jai_constants.reg_rg23_2_code;
5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5578: END IF;
5579:

Line 5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN

5572: ELSIF p_source_register = jai_constants.reg_rg23d THEN
5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5578: END IF;
5579:
5580: INSERT INTO JAI_CMN_RG_OTHERS(

Line 5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;

5573: ln_source_type := jai_constants.reg_rg23d_code;
5574: ELSIF p_source_register = jai_constants.reg_pla THEN
5575: ln_source_type := jai_constants.reg_pla_code;
5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5578: END IF;
5579:
5580: INSERT INTO JAI_CMN_RG_OTHERS(
5581: rg_other_id, source_type, source_register,

Line 5833: lv_pref1_register := jai_constants.register_type_pla;

5829: FETCH c_orgn_info INTO r_orgn_info;
5830: CLOSE c_orgn_info;
5831:
5832: IF r_orgn_info.pref_pla = 1 THEN
5833: lv_pref1_register := jai_constants.register_type_pla;
5834: lv_cess_pref1_register := jai_constants.reg_pla;
5835:
5836: IF p_item_class IN ('CGIN','CGEX') THEN
5837: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);

Line 5834: lv_cess_pref1_register := jai_constants.reg_pla;

5830: CLOSE c_orgn_info;
5831:
5832: IF r_orgn_info.pref_pla = 1 THEN
5833: lv_pref1_register := jai_constants.register_type_pla;
5834: lv_cess_pref1_register := jai_constants.reg_pla;
5835:
5836: IF p_item_class IN ('CGIN','CGEX') THEN
5837: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
5838: lv_pref2_register := jai_constants.register_type_c;

Line 5838: lv_pref2_register := jai_constants.register_type_c;

5834: lv_cess_pref1_register := jai_constants.reg_pla;
5835:
5836: IF p_item_class IN ('CGIN','CGEX') THEN
5837: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
5838: lv_pref2_register := jai_constants.register_type_c;
5839: lv_cess_pref2_register := jai_constants.reg_rg23c;
5840: ELSE
5841: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);
5842: lv_pref2_register := jai_constants.register_type_a;

Line 5839: lv_cess_pref2_register := jai_constants.reg_rg23c;

5835:
5836: IF p_item_class IN ('CGIN','CGEX') THEN
5837: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
5838: lv_pref2_register := jai_constants.register_type_c;
5839: lv_cess_pref2_register := jai_constants.reg_rg23c;
5840: ELSE
5841: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);
5842: lv_pref2_register := jai_constants.register_type_a;
5843: lv_cess_pref2_register := jai_constants.reg_rg23a;

Line 5842: lv_pref2_register := jai_constants.register_type_a;

5838: lv_pref2_register := jai_constants.register_type_c;
5839: lv_cess_pref2_register := jai_constants.reg_rg23c;
5840: ELSE
5841: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);
5842: lv_pref2_register := jai_constants.register_type_a;
5843: lv_cess_pref2_register := jai_constants.reg_rg23a;
5844: END IF;
5845:
5846: ELSE -- IF r_orgn_info.pref_rg23a = 1 THEN

Line 5843: lv_cess_pref2_register := jai_constants.reg_rg23a;

5839: lv_cess_pref2_register := jai_constants.reg_rg23c;
5840: ELSE
5841: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);
5842: lv_pref2_register := jai_constants.register_type_a;
5843: lv_cess_pref2_register := jai_constants.reg_rg23a;
5844: END IF;
5845:
5846: ELSE -- IF r_orgn_info.pref_rg23a = 1 THEN
5847:

Line 5850: lv_pref1_register := jai_constants.register_type_c;

5846: ELSE -- IF r_orgn_info.pref_rg23a = 1 THEN
5847:
5848: IF p_item_class IN ('CGIN','CGEX') THEN
5849: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);
5850: lv_pref1_register := jai_constants.register_type_c;
5851: lv_cess_pref1_register := jai_constants.reg_rg23c;
5852: ELSE
5853: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
5854: lv_pref1_register := jai_constants.register_type_a;

Line 5851: lv_cess_pref1_register := jai_constants.reg_rg23c;

5847:
5848: IF p_item_class IN ('CGIN','CGEX') THEN
5849: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);
5850: lv_pref1_register := jai_constants.register_type_c;
5851: lv_cess_pref1_register := jai_constants.reg_rg23c;
5852: ELSE
5853: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
5854: lv_pref1_register := jai_constants.register_type_a;
5855: lv_cess_pref1_register := jai_constants.reg_rg23a;

Line 5854: lv_pref1_register := jai_constants.register_type_a;

5850: lv_pref1_register := jai_constants.register_type_c;
5851: lv_cess_pref1_register := jai_constants.reg_rg23c;
5852: ELSE
5853: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
5854: lv_pref1_register := jai_constants.register_type_a;
5855: lv_cess_pref1_register := jai_constants.reg_rg23a;
5856: END IF;
5857:
5858: lv_pref2_register := jai_constants.register_type_pla;

Line 5855: lv_cess_pref1_register := jai_constants.reg_rg23a;

5851: lv_cess_pref1_register := jai_constants.reg_rg23c;
5852: ELSE
5853: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
5854: lv_pref1_register := jai_constants.register_type_a;
5855: lv_cess_pref1_register := jai_constants.reg_rg23a;
5856: END IF;
5857:
5858: lv_pref2_register := jai_constants.register_type_pla;
5859: lv_cess_pref2_register := jai_constants.reg_pla;

Line 5858: lv_pref2_register := jai_constants.register_type_pla;

5854: lv_pref1_register := jai_constants.register_type_a;
5855: lv_cess_pref1_register := jai_constants.reg_rg23a;
5856: END IF;
5857:
5858: lv_pref2_register := jai_constants.register_type_pla;
5859: lv_cess_pref2_register := jai_constants.reg_pla;
5860:
5861: END IF;
5862:

Line 5859: lv_cess_pref2_register := jai_constants.reg_pla;

5855: lv_cess_pref1_register := jai_constants.reg_rg23a;
5856: END IF;
5857:
5858: lv_pref2_register := jai_constants.register_type_pla;
5859: lv_cess_pref2_register := jai_constants.reg_pla;
5860:
5861: END IF;
5862:
5863: IF lb_rg_debug THEN

Line 5874: IF lv_pref1_register = jai_constants.register_type_pla

5870: ||', AllowNegative:'||r_orgn_info.allow_negative_pla);
5871: */
5872: END IF;
5873:
5874: IF lv_pref1_register = jai_constants.register_type_pla
5875: AND r_orgn_info.allow_negative_pla = jai_constants.yes
5876: THEN
5877: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
5878: p_cenvat_register_type := jai_constants.register_type_pla;

Line 5875: AND r_orgn_info.allow_negative_pla = jai_constants.yes

5871: */
5872: END IF;
5873:
5874: IF lv_pref1_register = jai_constants.register_type_pla
5875: AND r_orgn_info.allow_negative_pla = jai_constants.yes
5876: THEN
5877: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
5878: p_cenvat_register_type := jai_constants.register_type_pla;
5879: GOTO end_of_procedure;

Line 5878: p_cenvat_register_type := jai_constants.register_type_pla;

5874: IF lv_pref1_register = jai_constants.register_type_pla
5875: AND r_orgn_info.allow_negative_pla = jai_constants.yes
5876: THEN
5877: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
5878: p_cenvat_register_type := jai_constants.register_type_pla;
5879: GOTO end_of_procedure;
5880: END IF;
5881: --added for bug#9854329, start
5882: IF (p_transaction_type = 'RETURN TO VENDOR' AND nvl(r_orgn_info.CENVAT_CR_REVRSL_FLAG,'N') = 'N') THEN

Line 5906: IF lv_process_flag = jai_constants.unexpected_error THEN

5902: p_process_flag => lv_process_flag,
5903: p_process_message => lv_process_message
5904: );
5905:
5906: IF lv_process_flag = jai_constants.unexpected_error THEN
5907: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
5908: p_process_flag := 'E';
5909: p_process_message := lv_process_message;
5910: GOTO end_of_procedure;

Line 5912: ELSIF lv_process_flag = jai_constants.expected_error THEN

5908: p_process_flag := 'E';
5909: p_process_message := lv_process_message;
5910: GOTO end_of_procedure;
5911:
5912: ELSIF lv_process_flag = jai_constants.expected_error THEN
5913: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
5914:
5915: ELSIF lv_process_flag = jai_constants.successful THEN
5916:

Line 5915: ELSIF lv_process_flag = jai_constants.successful THEN

5911:
5912: ELSIF lv_process_flag = jai_constants.expected_error THEN
5913: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
5914:
5915: ELSIF lv_process_flag = jai_constants.successful THEN
5916:
5917: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
5918: IF pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess <> 0 THEN /* This if condition and its else added by ssumaith - bug# 4187859*/
5919:

Line 5937: IF lv_process_flag = jai_constants.unexpected_error THEN

5933: p_process_flag => lv_process_flag,
5934: p_process_message => lv_process_message
5935: );
5936:
5937: IF lv_process_flag = jai_constants.unexpected_error THEN
5938: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath);
5939: p_process_flag := 'E';
5940: p_process_message := lv_process_message;
5941: GOTO end_of_procedure;

Line 5943: ELSIF lv_process_flag = jai_constants.expected_error THEN

5939: p_process_flag := 'E';
5940: p_process_message := lv_process_message;
5941: GOTO end_of_procedure;
5942:
5943: ELSIF lv_process_flag = jai_constants.expected_error THEN
5944: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath);
5945: ELSIF lv_process_flag = jai_constants.successful THEN
5946: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath);
5947: p_cenvat_register_type := lv_pref1_register;

Line 5945: ELSIF lv_process_flag = jai_constants.successful THEN

5941: GOTO end_of_procedure;
5942:
5943: ELSIF lv_process_flag = jai_constants.expected_error THEN
5944: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath);
5945: ELSIF lv_process_flag = jai_constants.successful THEN
5946: p_codepath := jai_general_pkg.plot_codepath(14, p_codepath);
5947: p_cenvat_register_type := lv_pref1_register;
5948: GOTO end_of_procedure;
5949: END IF;

Line 5970: IF lv_process_flag = jai_constants.unexpected_error THEN

5966: p_process_flag => lv_process_flag,
5967: p_process_message => lv_process_message
5968: );
5969:
5970: IF lv_process_flag = jai_constants.unexpected_error THEN
5971: p_codepath := jai_general_pkg.plot_codepath(14.1, p_codepath);
5972: p_process_flag := 'E';
5973: p_process_message := lv_process_message;
5974: GOTO end_of_procedure;

Line 5976: ELSIF lv_process_flag = jai_constants.expected_error THEN

5972: p_process_flag := 'E';
5973: p_process_message := lv_process_message;
5974: GOTO end_of_procedure;
5975:
5976: ELSIF lv_process_flag = jai_constants.expected_error THEN
5977: p_codepath := jai_general_pkg.plot_codepath(14.2, p_codepath);
5978: ELSIF lv_process_flag = jai_constants.successful THEN
5979: p_codepath := jai_general_pkg.plot_codepath(14.3, p_codepath);
5980: p_cenvat_register_type := lv_pref1_register;

Line 5978: ELSIF lv_process_flag = jai_constants.successful THEN

5974: GOTO end_of_procedure;
5975:
5976: ELSIF lv_process_flag = jai_constants.expected_error THEN
5977: p_codepath := jai_general_pkg.plot_codepath(14.2, p_codepath);
5978: ELSIF lv_process_flag = jai_constants.successful THEN
5979: p_codepath := jai_general_pkg.plot_codepath(14.3, p_codepath);
5980: p_cenvat_register_type := lv_pref1_register;
5981: GOTO end_of_procedure;
5982: END IF;

Line 5986: lv_process_flag := jai_constants.successful;

5982: END IF;
5983: --end bug #5989740
5984:
5985: ELSE
5986: lv_process_flag := jai_constants.successful;
5987: p_cenvat_register_type := lv_pref1_register; --added for bug#9854329
5988: lv_process_message := NULL;
5989: goto end_of_procedure;
5990: END IF;

Line 5993: IF lv_pref2_register = jai_constants.register_type_pla

5989: goto end_of_procedure;
5990: END IF;
5991: END IF;
5992:
5993: IF lv_pref2_register = jai_constants.register_type_pla
5994: AND r_orgn_info.allow_negative_pla = jai_constants.yes
5995: THEN
5996: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath);
5997: p_cenvat_register_type := lv_pref2_register;

Line 5994: AND r_orgn_info.allow_negative_pla = jai_constants.yes

5990: END IF;
5991: END IF;
5992:
5993: IF lv_pref2_register = jai_constants.register_type_pla
5994: AND r_orgn_info.allow_negative_pla = jai_constants.yes
5995: THEN
5996: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath);
5997: p_cenvat_register_type := lv_pref2_register;
5998: GOTO end_of_procedure;

Line 6024: IF lv_process_flag = jai_constants.unexpected_error THEN

6020: p_process_flag => lv_process_flag,
6021: p_process_message => lv_process_message
6022: );
6023:
6024: IF lv_process_flag = jai_constants.unexpected_error THEN
6025: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
6026: p_process_flag := 'E';
6027: p_process_message := lv_process_message;
6028: GOTO end_of_procedure;

Line 6030: ELSIF lv_process_flag = jai_constants.expected_error THEN

6026: p_process_flag := 'E';
6027: p_process_message := lv_process_message;
6028: GOTO end_of_procedure;
6029:
6030: ELSIF lv_process_flag = jai_constants.expected_error THEN
6031: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath);
6032: p_process_flag := 'E';
6033: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6034: GOTO end_of_procedure;

Line 6036: ELSIF lv_process_flag = jai_constants.successful THEN

6032: p_process_flag := 'E';
6033: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6034: GOTO end_of_procedure;
6035:
6036: ELSIF lv_process_flag = jai_constants.successful THEN
6037:
6038: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath);
6039:
6040: IF pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess <> 0 THEN /* This if condition and its else added by ssumaith - bug# 4187859*/

Line 6057: IF lv_process_flag = jai_constants.unexpected_error THEN

6053: p_trx_amount => ln_trx_amount, --added for bug#9854329
6054: p_process_flag => lv_process_flag,
6055: p_process_message => lv_process_message
6056: );
6057: IF lv_process_flag = jai_constants.unexpected_error THEN
6058: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath);
6059: p_process_flag := 'E';
6060: p_process_message := lv_process_message;
6061: GOTO end_of_procedure;

Line 6063: ELSIF lv_process_flag = jai_constants.expected_error THEN

6059: p_process_flag := 'E';
6060: p_process_message := lv_process_message;
6061: GOTO end_of_procedure;
6062:
6063: ELSIF lv_process_flag = jai_constants.expected_error THEN
6064: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath);
6065: p_process_flag := 'E';
6066: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6067: GOTO end_of_procedure;

Line 6069: ELSIF lv_process_flag = jai_constants.successful THEN

6065: p_process_flag := 'E';
6066: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6067: GOTO end_of_procedure;
6068:
6069: ELSIF lv_process_flag = jai_constants.successful THEN
6070: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath);
6071: p_cenvat_register_type := lv_pref2_register;
6072: GOTO end_of_procedure;
6073: END IF;

Line 6094: IF lv_process_flag = jai_constants.unexpected_error THEN

6090: p_process_flag => lv_process_flag,
6091: p_process_message => lv_process_message
6092: );
6093:
6094: IF lv_process_flag = jai_constants.unexpected_error THEN
6095: p_codepath := jai_general_pkg.plot_codepath(22.1, p_codepath);
6096: p_process_flag := 'E';
6097: p_process_message := lv_process_message;
6098: GOTO end_of_procedure;

Line 6100: ELSIF lv_process_flag = jai_constants.expected_error THEN

6096: p_process_flag := 'E';
6097: p_process_message := lv_process_message;
6098: GOTO end_of_procedure;
6099:
6100: ELSIF lv_process_flag = jai_constants.expected_error THEN
6101: p_codepath := jai_general_pkg.plot_codepath(22.2, p_codepath);
6102: p_process_flag := 'E';
6103: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6104: GOTO end_of_procedure;

Line 6106: ELSIF lv_process_flag = jai_constants.successful THEN

6102: p_process_flag := 'E';
6103: p_process_message := 'Sufficient Balances are not available in both '||lv_pref1_register||' and '||lv_pref2_register||' registers';
6104: GOTO end_of_procedure;
6105:
6106: ELSIF lv_process_flag = jai_constants.successful THEN
6107: p_codepath := jai_general_pkg.plot_codepath(22.3, p_codepath);
6108: p_cenvat_register_type := lv_pref2_register;
6109: GOTO end_of_procedure;
6110: END IF;

Line 6116: lv_process_flag := jai_constants.successful;

6112: --end bug #5989740
6113:
6114:
6115: ELSE
6116: lv_process_flag := jai_constants.successful;
6117: p_cenvat_register_type := lv_pref2_register; -- added for bug#9854329
6118: lv_process_message := NULL;
6119: goto end_of_procedure;
6120: END IF;

Line 6148: jai_constants.register_type_pla, pla_balance,

6144: ) IS
6145:
6146: CURSOR c_orgn_balances(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
6147: SELECT decode( cp_register_type,
6148: jai_constants.register_type_pla, pla_balance,
6149: jai_constants.register_type_a, rg23a_balance,
6150: jai_constants.register_type_c, rg23c_balance
6151: )
6152: FROM JAI_CMN_RG_BALANCES

Line 6149: jai_constants.register_type_a, rg23a_balance,

6145:
6146: CURSOR c_orgn_balances(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
6147: SELECT decode( cp_register_type,
6148: jai_constants.register_type_pla, pla_balance,
6149: jai_constants.register_type_a, rg23a_balance,
6150: jai_constants.register_type_c, rg23c_balance
6151: )
6152: FROM JAI_CMN_RG_BALANCES
6153: WHERE organization_id = cp_organization_id

Line 6150: jai_constants.register_type_c, rg23c_balance

6146: CURSOR c_orgn_balances(cp_organization_id IN NUMBER, cp_location_id IN NUMBER, cp_register_type IN VARCHAR2) IS
6147: SELECT decode( cp_register_type,
6148: jai_constants.register_type_pla, pla_balance,
6149: jai_constants.register_type_a, rg23a_balance,
6150: jai_constants.register_type_c, rg23c_balance
6151: )
6152: FROM JAI_CMN_RG_BALANCES
6153: WHERE organization_id = cp_organization_id
6154: AND location_id = cp_location_id;

Line 6165: p_process_flag := jai_constants.expected_error;

6161: FETCH c_orgn_balances INTO ln_current_balance;
6162: CLOSE c_orgn_balances;
6163:
6164: IF ( nvl(ln_current_balance,0) - nvl(p_transaction_amount,0)) < 0 THEN
6165: p_process_flag := jai_constants.expected_error;
6166: p_process_message := 'Sufficient Balances are not available in '''||p_register_type||''' register';
6167: ELSE
6168: p_process_flag := jai_constants.successful;
6169: END IF;

Line 6168: p_process_flag := jai_constants.successful;

6164: IF ( nvl(ln_current_balance,0) - nvl(p_transaction_amount,0)) < 0 THEN
6165: p_process_flag := jai_constants.expected_error;
6166: p_process_message := 'Sufficient Balances are not available in '''||p_register_type||''' register';
6167: ELSE
6168: p_process_flag := jai_constants.successful;
6169: END IF;
6170:
6171: END check_cenvat_balances;
6172:

Line 6192: and ( a.tax_type = jai_constants.tax_type_exc_edu_cess

6188: select a.tax_rate, b.tax_account_id, a.tax_id
6189: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
6190: where a.shipment_line_id = cp_shipment_line_id
6191: and a.tax_id = b.tax_id
6192: and ( a.tax_type = jai_constants.tax_type_exc_edu_cess
6193: -- following is to take care of Initial solution(Year2004) for Excise Cess func.
6194: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type) --'EXCISE - CESS') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
6195: --or (a.tax_type = 'Other' and b.stform_type = 'EXCISE - CESS')
6196: );

Line 6194: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type) --'EXCISE - CESS') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

6190: where a.shipment_line_id = cp_shipment_line_id
6191: and a.tax_id = b.tax_id
6192: and ( a.tax_type = jai_constants.tax_type_exc_edu_cess
6193: -- following is to take care of Initial solution(Year2004) for Excise Cess func.
6194: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type) --'EXCISE - CESS') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
6195: --or (a.tax_type = 'Other' and b.stform_type = 'EXCISE - CESS')
6196: );
6197:
6198: --added by csahoo for bug#6078460

Line 6204: and ( a.tax_type = jai_constants.tax_type_sh_exc_edu_cess

6200: select a.tax_rate, b.tax_account_id, a.tax_id
6201: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
6202: where a.shipment_line_id = cp_shipment_line_id
6203: and a.tax_id = b.tax_id
6204: and ( a.tax_type = jai_constants.tax_type_sh_exc_edu_cess
6205: -- following is to take care of Initial solution(Year2004) for Excise sh Cess func.
6206: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type)
6207: );
6208:

Line 6206: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type)

6202: where a.shipment_line_id = cp_shipment_line_id
6203: and a.tax_id = b.tax_id
6204: and ( a.tax_type = jai_constants.tax_type_sh_exc_edu_cess
6205: -- following is to take care of Initial solution(Year2004) for Excise sh Cess func.
6206: or (a.tax_type = jai_constants.tax_type_other and b.stform_type = lv_stform_type)
6207: );
6208:
6209: cursor c_po_dist_accrual_accnt_id(cp_transaction_id in number) is
6210: select accrual_account_id

Line 6271: lv_simulate_flag := jai_constants.no;

6267: begin
6268:
6269: lv_statement_id := '1';
6270: pv_codepath := jai_general_pkg.plot_codepath(1, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'START');
6271: lv_simulate_flag := jai_constants.no;
6272: lv_register_entry_type := jai_rcv_excise_processing_pkg.cenvat_debit;
6273:
6274: open c_trx(pn_transaction_id);
6275: fetch c_trx into r_trx;

Line 6346: if lv_cenvat_register_type IN (jai_constants.register_type_a, jai_constants.register_type_c) then

6342: if pv_process_status = 'E' then
6343: GOTO end_of_procedure;
6344: end if;
6345:
6346: if lv_cenvat_register_type IN (jai_constants.register_type_a, jai_constants.register_type_c) then
6347:
6348: lv_statement_id := '5';
6349: pv_codepath := jai_general_pkg.plot_codepath(17, pv_codepath);
6350:

Line 6389: elsif lv_cenvat_register_type = jai_constants.register_type_pla THEN

6385: GOTO end_of_procedure;
6386: END IF;
6387: lv_reference_name := 'JAI_CMN_RG_23AC_II_TRXS';
6388: ln_reference_id := ln_part_ii_register_id;
6389: elsif lv_cenvat_register_type = jai_constants.register_type_pla THEN
6390: lv_statement_id := '7';
6391: pv_codepath := jai_general_pkg.plot_codepath(17.1, pv_codepath);
6392: /* Bug 5365346. Added by Lakshmi Gopalsami
6393: Commented the call to pla entry and added

Line 6442: if lv_cenvat_register_type = jai_constants.register_type_a then

6438: open c_orgn_info(r_trx.organization_id, r_trx.location_id);
6439: fetch c_orgn_info into r_orgn_info;
6440: close c_orgn_info;
6441:
6442: if lv_cenvat_register_type = jai_constants.register_type_a then
6443: lv_statement_id := '11';
6444: ln_ccid := r_orgn_info.modvat_rm_account_id;
6445: elsif lv_cenvat_register_type = jai_constants.register_type_c then
6446: lv_statement_id := '12';

Line 6445: elsif lv_cenvat_register_type = jai_constants.register_type_c then

6441:
6442: if lv_cenvat_register_type = jai_constants.register_type_a then
6443: lv_statement_id := '11';
6444: ln_ccid := r_orgn_info.modvat_rm_account_id;
6445: elsif lv_cenvat_register_type = jai_constants.register_type_c then
6446: lv_statement_id := '12';
6447: ln_ccid := r_orgn_info.modvat_cg_account_id;
6448: elsif lv_cenvat_register_type = jai_constants.register_type_pla then
6449: lv_statement_id := '13';

Line 6448: elsif lv_cenvat_register_type = jai_constants.register_type_pla then

6444: ln_ccid := r_orgn_info.modvat_rm_account_id;
6445: elsif lv_cenvat_register_type = jai_constants.register_type_c then
6446: lv_statement_id := '12';
6447: ln_ccid := r_orgn_info.modvat_cg_account_id;
6448: elsif lv_cenvat_register_type = jai_constants.register_type_pla then
6449: lv_statement_id := '13';
6450: ln_ccid := r_orgn_info.modvat_pla_account_id;
6451: end if;
6452:

Line 6460: if r_orgn_info.rtv_account_flag = jai_constants.yes then

6456: pv_process_message := 'Modvat '||lv_cenvat_register_type||' account in Organization Setup doesnot exist';
6457: GOTO end_of_procedure;
6458: end if;
6459:
6460: if r_orgn_info.rtv_account_flag = jai_constants.yes then
6461: ln_balancing_ccid := r_orgn_info.rtv_expense_account_id;
6462: if ln_balancing_ccid is null then
6463: null;
6464: end if;

Line 6465: elsif r_orgn_info.rtv_account_flag = jai_constants.no then

6461: ln_balancing_ccid := r_orgn_info.rtv_expense_account_id;
6462: if ln_balancing_ccid is null then
6463: null;
6464: end if;
6465: elsif r_orgn_info.rtv_account_flag = jai_constants.no then
6466:
6467: open c_po_dist_accrual_accnt_id(r_trx.transaction_id);
6468: fetch c_po_dist_accrual_accnt_id into ln_balancing_ccid;
6469: close c_po_dist_accrual_accnt_id;

Line 6764: pv_process_status := jai_constants.yes;

6760:
6761: -- added by csahoo for bug#6078460, end
6762:
6763: lv_statement_id := '29';
6764: pv_process_status := jai_constants.yes;
6765: <>
6766: pv_codepath := jai_general_pkg.plot_codepath(75, pv_codepath, 'jai_rcv_excise_processing_pkg.rtv_processing_for_ssi', 'END');
6767:
6768: exception