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

Line 389: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

385: r_ja_in_deliver_trx.cenvat_costed_flag, 'Y', --Modified by Bo Li for bug9305067 replace the attribute2 with cenvat_costed_flag
386: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
387: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
388: , 'ADDITIONAL_CVD', 'N'
389: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
390: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
391: , a.modvat_flag)
392: , a.modvat_flag
393: ),

Line 390: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

386: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
387: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
388: , 'ADDITIONAL_CVD', 'N'
389: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
390: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
391: , a.modvat_flag)
392: , a.modvat_flag
393: ),
394: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)),

Line 403: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

399: r_ja_in_deliver_trx.cenvat_costed_flag, 'Y',--Modified by Bo Li for bug9305067 replace the attribute2 with cenvat_costed_flag
400: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
401: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
402: , 'ADDITIONAL_CVD', 'N'
403: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
404: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
405: , a.modvat_flag)
406: , a.modvat_flag
407: ),

Line 404: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

400: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
401: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
402: , 'ADDITIONAL_CVD', 'N'
403: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
404: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
405: , a.modvat_flag)
406: , a.modvat_flag
407: ),
408: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)

Line 424: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

420: r_ja_in_deliver_trx.cenvat_costed_flag, 'Y',--Modified by Bo Li for bug9305067 replace the attribute2 with cenvat_costed_flag
421: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
422: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
423: , 'ADDITIONAL_CVD', 'N'
424: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
425: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
426: , a.modvat_flag)
427: , a.modvat_flag
428: ),

Line 425: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

421: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
422: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
423: , 'ADDITIONAL_CVD', 'N'
424: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
425: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
426: , a.modvat_flag)
427: , a.modvat_flag
428: ),
429: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100))

Line 439: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

435: r_ja_in_deliver_trx.cenvat_costed_flag, 'Y',--Modified by Bo Li for bug9305067 replace the attribute2 with cenvat_costed_flag
436: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
437: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
438: , 'ADDITIONAL_CVD', 'N'
439: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
440: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
441: , a.modvat_flag)
442: , a.modvat_flag
443: ),

Line 440: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

436: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
437: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
438: , 'ADDITIONAL_CVD', 'N'
439: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
440: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
441: , a.modvat_flag)
442: , a.modvat_flag
443: ),
444: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)

Line 653: if lv_process_flag <> jai_constants.SUCCESSFUL then

649: , p_xface_id => p_xface_id
650: , p_process_flag => lv_process_flag
651: , p_process_message => lv_process_message
652: );
653: if lv_process_flag <> jai_constants.SUCCESSFUL then
654: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_process_flag='||lv_process_flag ||',Message='||lv_process_message);
655: return;
656: end if;
657: /** Deregister procedure and return*/

Line 821: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

817: cp_attribute2, 'Y',
818: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
819: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
820: , 'ADDITIONAL_CVD', 'N'
821: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
822: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
823: , a.modvat_flag)
824: , a.modvat_flag
825: ),

Line 822: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

818: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
819: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
820: , 'ADDITIONAL_CVD', 'N'
821: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
822: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
823: , a.modvat_flag)
824: , a.modvat_flag
825: ),
826: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)),

Line 835: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

831: cp_attribute2, 'Y',
832: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
833: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
834: , 'ADDITIONAL_CVD', 'N'
835: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
836: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
837: , a.modvat_flag)
838: , a.modvat_flag
839: ),

Line 836: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

832: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
833: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
834: , 'ADDITIONAL_CVD', 'N'
835: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
836: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
837: , a.modvat_flag)
838: , a.modvat_flag
839: ),
840: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)

Line 854: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

850: cp_attribute2, 'Y',
851: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
852: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
853: , 'ADDITIONAL_CVD', 'N'
854: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
855: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
856: , a.modvat_flag)
857: , a.modvat_flag
858: ),

Line 855: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

851: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
852: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
853: , 'ADDITIONAL_CVD', 'N'
854: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
855: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
856: , a.modvat_flag)
857: , a.modvat_flag
858: ),
859: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100))

Line 869: , jai_constants.tax_type_sh_exc_edu_cess, 'N'

865: cp_attribute2, 'Y',
866: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
867: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
868: , 'ADDITIONAL_CVD', 'N'
869: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
870: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
871: , a.modvat_flag)
872: , a.modvat_flag
873: ),

Line 870: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'

866: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
867: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
868: , 'ADDITIONAL_CVD', 'N'
869: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
870: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
871: , a.modvat_flag)
872: , a.modvat_flag
873: ),
874: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)

Line 1770: p_process_flag := jai_constants.UNEXPECTED_ERROR;

1766: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
1767:
1768: exception
1769: when others then
1770: p_process_flag := jai_constants.UNEXPECTED_ERROR;
1771: p_process_message := sqlerrm;
1772: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1773: jai_cmn_debug_contexts_pkg.print_stack;
1774:

Line 1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,

1978: where ((cp_tax_type = 'VAT' AND tax_type in ( select tax_type
1979: from jai_regime_tax_types_v
1980: where regime_code = 'VAT'))
1981: OR
1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,
1983: jai_constants.tax_type_exc_additional,
1984: jai_constants.tax_type_exc_other,
1985: jai_constants.tax_type_exc_edu_cess,
1986: jai_constants.tax_type_sh_exc_edu_cess

Line 1983: jai_constants.tax_type_exc_additional,

1979: from jai_regime_tax_types_v
1980: where regime_code = 'VAT'))
1981: OR
1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,
1983: jai_constants.tax_type_exc_additional,
1984: jai_constants.tax_type_exc_other,
1985: jai_constants.tax_type_exc_edu_cess,
1986: jai_constants.tax_type_sh_exc_edu_cess
1987: )))

Line 1984: jai_constants.tax_type_exc_other,

1980: where regime_code = 'VAT'))
1981: OR
1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,
1983: jai_constants.tax_type_exc_additional,
1984: jai_constants.tax_type_exc_other,
1985: jai_constants.tax_type_exc_edu_cess,
1986: jai_constants.tax_type_sh_exc_edu_cess
1987: )))
1988: and transaction_id = cp_transaction_id;

Line 1985: jai_constants.tax_type_exc_edu_cess,

1981: OR
1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,
1983: jai_constants.tax_type_exc_additional,
1984: jai_constants.tax_type_exc_other,
1985: jai_constants.tax_type_exc_edu_cess,
1986: jai_constants.tax_type_sh_exc_edu_cess
1987: )))
1988: and transaction_id = cp_transaction_id;
1989:

Line 1986: jai_constants.tax_type_sh_exc_edu_cess

1982: (cp_tax_type = 'EXCISE' AND tax_type in (jai_constants.tax_type_excise,
1983: jai_constants.tax_type_exc_additional,
1984: jai_constants.tax_type_exc_other,
1985: jai_constants.tax_type_exc_edu_cess,
1986: jai_constants.tax_type_sh_exc_edu_cess
1987: )))
1988: and transaction_id = cp_transaction_id;
1989:
1990: CURSOR cur_get_deliver_trx (cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

Line 2028: p_process_flag := jai_constants.successful;

2024: ---------------------------------------------------------------------------
2025: -- Added by Jia for FP Bug#9863751, End
2026:
2027: BEGIN
2028: p_process_flag := jai_constants.successful;
2029: p_process_message := NULL;
2030:
2031: IF p_tax_type = 'VAT' THEN
2032: OPEN cur_get_process_flag(p_transaction_id);

Line 2264: p_process_flag := jai_constants.unexpected_error;

2260: END LOOP;
2261:
2262: EXCEPTION
2263: WHEN OTHERS THEN
2264: p_process_flag := jai_constants.unexpected_error;
2265: p_process_message := SUBSTR(SQLERRM,1,200);
2266: END update_interface_cost_tax;
2267: ----------------------------------------------------------------------------------------------------------------
2268: -- Added by Jia for FP Bug#8805693, End