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

Line 338: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436

334:
335: if tax_rec.modvat_flag = 'Y'
336: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
337: 'ADDITIONAL_CVD', 'TDS', 'MODVAT RECOVERY',
338: jai_constants.tax_type_exc_edu_cess, jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436
339:
340: then
341:
342:

Line 349: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436

345:
346: elsif tax_rec.modvat_flag = 'Y'
347: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
348: 'ADDITIONAL_CVD',
349: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436
350:
351: then
352:
353:

Line 363: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436

359: and lv_item_excisable = 'Y'
360: and lv_organization_type = 'T'
361: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
362: 'ADDITIONAL_CVD',
363: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
364:
365:
366: jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436
367:

Line 366: jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436

362: 'ADDITIONAL_CVD',
363: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
364:
365:
366: jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_cvd_edu_cess) --Added higher education cess by kundan kumar for bug#5907436
367:
368: then
369:
370: lv_tax_modvat_flag := 'Y';

Line 384: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436

380:
381: if lv_tax_modvat_flag = 'Y'
382: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
383: 'ADDITIONAL_CVD',
384: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
385:
386: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
387:
388: jai_constants.tax_type_cvd_edu_cess)

Line 386: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436

382: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
383: 'ADDITIONAL_CVD',
384: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
385:
386: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
387:
388: jai_constants.tax_type_cvd_edu_cess)
389: then
390:

Line 388: jai_constants.tax_type_cvd_edu_cess)

384: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
385:
386: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
387:
388: jai_constants.tax_type_cvd_edu_cess)
389: then
390:
391:
392: ln_recoverable_amt :=

Line 401: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436

397:
398: elsif lv_tax_modvat_flag = 'Y'
399: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
400: 'ADDITIONAL_CVD',
401: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
402:
403: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
404:
405: jai_constants.tax_type_cvd_edu_cess)

Line 403: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436

399: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
400: 'ADDITIONAL_CVD',
401: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
402:
403: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
404:
405: jai_constants.tax_type_cvd_edu_cess)
406: then
407:

Line 405: jai_constants.tax_type_cvd_edu_cess)

401: jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
402:
403: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
404:
405: jai_constants.tax_type_cvd_edu_cess)
406: then
407:
408: ln_recoverable_amt :=
409: round( tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor, ln_precision);

Line 487: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,

483: CURSOR excise_cur(trx_temp_id number) IS
484: SELECT SUM(decode(tax_type, 'Excise', round(tax_amt), 0)) exc,
485: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
486: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
487: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
488: sum(decode(tax_type, jai_constants.tax_type_sh_exc_edu_cess, round(tax_amt), 0)) other_sh_cess --Added higher education cess constants by vkaranam for bug#5907436
489: FROM jai_cmn_document_taxes tax,
490: jai_mtl_trxs trx
491: WHERE tax.source_doc_line_id = trx.transaction_temp_id

Line 488: sum(decode(tax_type, jai_constants.tax_type_sh_exc_edu_cess, round(tax_amt), 0)) other_sh_cess --Added higher education cess constants by vkaranam for bug#5907436

484: SELECT SUM(decode(tax_type, 'Excise', round(tax_amt), 0)) exc,
485: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
486: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
487: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
488: sum(decode(tax_type, jai_constants.tax_type_sh_exc_edu_cess, round(tax_amt), 0)) other_sh_cess --Added higher education cess constants by vkaranam for bug#5907436
489: FROM jai_cmn_document_taxes tax,
490: jai_mtl_trxs trx
491: WHERE tax.source_doc_line_id = trx.transaction_temp_id
492: AND trx.transaction_header_id = tax.source_doc_id

Line 783: p_tax_type => jai_constants.tax_type_exc_edu_cess,

779:
780: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
781: p_source_name => 'RG23D',
782: p_source_id => l_register_id,
783: p_tax_type => jai_constants.tax_type_exc_edu_cess,
784: debit_amt => NULL,
785: credit_amt => ln_cess_amount,
786: p_process_flag => p_process_status,
787: p_process_msg => p_process_message

Line 801: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,

797:
798: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
799: p_source_name => 'RG23D',
800: p_source_id => l_register_id,
801: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
802: debit_amt => NULL,
803: credit_amt => ln_other_sh_cess,
804: p_process_flag => p_process_status,
805: p_process_msg => p_process_message

Line 911: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,

907: jai_cmn_rg_others_pkg.insert_row(
908: P_SOURCE_TYPE => 1 ,
909: P_SOURCE_NAME => lv_source_name ,
910: P_SOURCE_ID => l_register_id_ii ,
911: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,
912: DEBIT_AMT =>null ,
913: CREDIT_AMT =>ln_other_sh_cess ,
914: P_PROCESS_FLAG =>l_process_status ,
915: P_PROCESS_MSG =>l_process_message

Line 958: --regime varchar2(100):=jai_constants.vat_regime;

954: lv_process_message VARCHAR2(1000);
955: v_source_name VARCHAR2(100) := 'Register India' ; -- bug 6487405
956: v_category_name VARCHAR2(100) := 'VAT India' ; -- bug 6487405
957:
958: --regime varchar2(100):=jai_constants.vat_regime;
959: CURSOR c_regime_cur IS
960: SELECT regime_id
961: FROM jai_rgm_definitions
962: WHERE regime_code = 'VAT';

Line 1008: AND jrr.regime_code = jai_constants.vat_regime

1004: AND jmt.transaction_header_id=jcdt.source_doc_id
1005: AND jmt.transaction_temp_id=jcdt.source_doc_line_id
1006: AND jcdt.tax_id=jtc.tax_id
1007: AND jtc.tax_type= jrg.attribute_code -- bug 6436781
1008: AND jrr.regime_code = jai_constants.vat_regime
1009: AND jrg.regime_id = jrr.regime_id
1010: AND jrg.registration_type = 'TAX_TYPES'
1011: AND upper(jrg.attribute_code) <> 'VAT REVERSAL'
1012: GROUP BY jtc.tax_type,

Line 1039: lv_account_name := jai_constants.recovery;

1035: end if;
1036: END LOOP;
1037: --added this if condition for performance issue
1038: if nvl(ln_rgm_cnt,0) = 0 then
1039: lv_account_name := jai_constants.recovery;
1040: stmt_name:='Getting the interim recovery amount';
1041: ln_interim_recovery_account :=
1042: jai_cmn_rgm_recording_pkg.get_account(
1043: p_regime_id => ln_regime_id,

Line 1044: p_organization_type => jai_constants.orgn_type_io,

1040: stmt_name:='Getting the interim recovery amount';
1041: ln_interim_recovery_account :=
1042: jai_cmn_rgm_recording_pkg.get_account(
1043: p_regime_id => ln_regime_id,
1044: p_organization_type => jai_constants.orgn_type_io,
1045: p_organization_id => p_organization_id,
1046: p_location_id => p_location_id,
1047: p_tax_type => rec_claims.tax_type,
1048: p_account_name => jai_constants.recovery_interim);

Line 1048: p_account_name => jai_constants.recovery_interim);

1044: p_organization_type => jai_constants.orgn_type_io,
1045: p_organization_id => p_organization_id,
1046: p_location_id => p_location_id,
1047: p_tax_type => rec_claims.tax_type,
1048: p_account_name => jai_constants.recovery_interim);
1049: IF ln_interim_recovery_account IS NULL THEN
1050: p_process_status := jai_constants.expected_error;
1051: p_process_message := 'Interim recovery Account not defined in VAT Setup';
1052: RETURN;

Line 1050: p_process_status := jai_constants.expected_error;

1046: p_location_id => p_location_id,
1047: p_tax_type => rec_claims.tax_type,
1048: p_account_name => jai_constants.recovery_interim);
1049: IF ln_interim_recovery_account IS NULL THEN
1050: p_process_status := jai_constants.expected_error;
1051: p_process_message := 'Interim recovery Account not defined in VAT Setup';
1052: RETURN;
1053: END IF;
1054: stmt_name:='Getting the code combination id';

Line 1058: p_organization_type => jai_constants.orgn_type_io,

1054: stmt_name:='Getting the code combination id';
1055: ln_code_combination_id :=
1056: jai_cmn_rgm_recording_pkg.get_account(
1057: p_regime_id => ln_regime_id,
1058: p_organization_type => jai_constants.orgn_type_io,
1059: p_organization_id => p_organization_id,
1060: p_location_id => p_location_id,
1061: p_tax_type => rec_claims.tax_type,
1062: p_account_name => jai_constants.recovery);

Line 1062: p_account_name => jai_constants.recovery);

1058: p_organization_type => jai_constants.orgn_type_io,
1059: p_organization_id => p_organization_id,
1060: p_location_id => p_location_id,
1061: p_tax_type => rec_claims.tax_type,
1062: p_account_name => jai_constants.recovery);
1063: IF ln_code_combination_id IS NULL THEN
1064: p_process_status := jai_constants.expected_error;
1065: p_process_message := 'Recovery Account not defined in VAT Setup';
1066: RETURN;

Line 1064: p_process_status := jai_constants.expected_error;

1060: p_location_id => p_location_id,
1061: p_tax_type => rec_claims.tax_type,
1062: p_account_name => jai_constants.recovery);
1063: IF ln_code_combination_id IS NULL THEN
1064: p_process_status := jai_constants.expected_error;
1065: p_process_message := 'Recovery Account not defined in VAT Setup';
1066: RETURN;
1067: END IF;
1068: ln_entered_dr := NULL;

Line 1079: pv_organization_type => jai_constants.orgn_type_io,

1075: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
1076: pn_repository_id => ln_repository_id,
1077: pn_regime_id => ln_regime_id,
1078: pv_tax_type => rec_claims.tax_type,
1079: pv_organization_type => jai_constants.orgn_type_io,
1080: pn_organization_id => p_organization_id,
1081: pn_location_id => p_location_id,
1082: pv_source => jai_constants.source_rcv,
1083: pv_source_trx_type => lv_source_trx_type,

Line 1082: pv_source => jai_constants.source_rcv,

1078: pv_tax_type => rec_claims.tax_type,
1079: pv_organization_type => jai_constants.orgn_type_io,
1080: pn_organization_id => p_organization_id,
1081: pn_location_id => p_location_id,
1082: pv_source => jai_constants.source_rcv,
1083: pv_source_trx_type => lv_source_trx_type,
1084: pv_source_table_name => table_rcv_transactions,
1085: pn_source_id => p_transaction_temp_id,
1086: pd_transaction_date => trunc(sysdate),

Line 1113: IF lv_process_status <> jai_constants.successful THEN

1109: pv_trx_reference5 => NULL
1110: --------------------------------------------------
1111: --Added by Bo Li for bug9305067 2010-4-14 END
1112: );
1113: IF lv_process_status <> jai_constants.successful THEN
1114: p_process_status := lv_process_status;
1115: p_process_message := lv_process_message;
1116: RETURN;
1117: END IF;

Line 1147: pv_organization_type => jai_constants.orgn_type_io,

1143: stmt_name:='calling do vat accounting procedure for credit';
1144: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1145: pn_regime_id => ln_regime_id,
1146: pn_repository_id => ln_repository_id,
1147: pv_organization_type => jai_constants.orgn_type_io,
1148: pn_organization_id => p_organization_id,
1149: pd_accounting_date => trunc(sysdate),
1150: pd_transaction_date => trunc(sysdate),
1151: pn_credit_amount => ln_entered_cr,

Line 1159: pv_source => jai_constants.source_rcv,

1155: pv_called_from => NULL,
1156: pv_process_flag => lv_process_status,
1157: pv_process_message => lv_process_message,
1158: pv_tax_type => rec_claims.tax_type,
1159: pv_source => jai_constants.source_rcv,
1160: pv_source_trx_type => lv_source_trx_type,
1161: pv_source_table_name => table_rcv_transactions,
1162: pn_source_id => p_transaction_temp_id,
1163: pv_reference_name => NULL,

Line 1173: pv_organization_type => jai_constants.orgn_type_io,

1169: stmt_name:='calling do vat accounting procedure for debit';
1170: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1171: pn_regime_id => ln_regime_id,
1172: pn_repository_id => ln_repository_id,
1173: pv_organization_type => jai_constants.orgn_type_io,
1174: pn_organization_id => p_organization_id,
1175: pd_accounting_date => trunc(sysdate),
1176: pd_transaction_date => trunc(sysdate),
1177: pn_credit_amount => ln_entered_cr,

Line 1185: pv_source => jai_constants.source_rcv,

1181: pv_called_from => NULL,
1182: pv_process_flag => lv_process_status,
1183: pv_process_message => lv_process_message,
1184: pv_tax_type => rec_claims.tax_type,
1185: pv_source => jai_constants.source_rcv,
1186: pv_source_trx_type => lv_source_trx_type,
1187: pv_source_table_name => table_rcv_transactions,
1188: pn_source_id => p_transaction_temp_id,
1189: pv_reference_name => NULL,

Line 1517: jai_constants.tax_type_exc_edu_cess, 5,jai_constants.tax_type_sh_exc_edu_cess,6, /changed taxtype_val to 6 for sh_cess by vkaranam for bug #5907436/--Added higher education cess by kundan kumar for bug#5907436

1513: DECODE(aa.regime_code, 'VAT', 4, DECODE( UPPER( A.Tax_Type ),
1514: 'EXCISE', 1,
1515: 'ADDL. EXCISE', 1,
1516: 'OTHER EXCISE', 1,
1517: jai_constants.tax_type_exc_edu_cess, 5,jai_constants.tax_type_sh_exc_edu_cess,6, /*changed taxtype_val to 6 for sh_cess by vkaranam for bug #5907436*/--Added higher education cess by kundan kumar for bug#5907436
1518:
1519: 'TDS', 2, 0)) tax_type_val,
1520: A.Tax_Amt tax_amount,
1521: b.tax_account_id ,

Line 2399: p_organization_type => jai_constants.orgn_type_io,

2395: t_gl_entries(rec).amount := main_rec.tax_amount;
2396: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2397: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2398: p_regime_id => l_regime_id,
2399: p_organization_type => jai_constants.orgn_type_io,
2400: p_organization_id => r_mtl_trx_info.from_organization,
2401: p_location_id => ln_from_loc_id,
2402: p_tax_type => main_rec.tax_type,
2403: p_account_name => jai_constants.liability_interim

Line 2403: p_account_name => jai_constants.liability_interim

2399: p_organization_type => jai_constants.orgn_type_io,
2400: p_organization_id => r_mtl_trx_info.from_organization,
2401: p_location_id => ln_from_loc_id,
2402: p_tax_type => main_rec.tax_type,
2403: p_account_name => jai_constants.liability_interim
2404: );
2405: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2406: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2407: p_regime_id => l_regime_id,

Line 2408: p_organization_type => jai_constants.orgn_type_io,

2404: );
2405: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2406: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2407: p_regime_id => l_regime_id,
2408: p_organization_type => jai_constants.orgn_type_io,
2409: p_organization_id => r_mtl_trx_info.from_organization,
2410: p_location_id => ln_from_loc_id,
2411: p_tax_type => main_rec.tax_type,
2412: p_account_name => jai_constants.liability

Line 2412: p_account_name => jai_constants.liability

2408: p_organization_type => jai_constants.orgn_type_io,
2409: p_organization_id => r_mtl_trx_info.from_organization,
2410: p_location_id => ln_from_loc_id,
2411: p_tax_type => main_rec.tax_type,
2412: p_account_name => jai_constants.liability
2413: ) ;
2414: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2415: t_gl_entries(rec).organization_code := l_from_org_cd;
2416:

Line 2436: -- p_organization_type => jai_constants.orgn_type_io,

2432: */
2433: -- t_gl_entries(rec).amount := main_rec.tax_amount;
2434: -- t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2435: -- p_regime_id => l_regime_id,
2436: -- p_organization_type => jai_constants.orgn_type_io,
2437: -- p_organization_id => r_mtl_trx_info.from_organization,
2438: -- p_location_id => ln_from_loc_id,
2439: -- p_tax_type => main_rec.tax_type,
2440: -- p_account_name => 'EXPENSE'

Line 2445: -- p_organization_type => jai_constants.orgn_type_io,

2441: -- );
2442:
2443: -- t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2444: -- p_regime_id => l_regime_id,
2445: -- p_organization_type => jai_constants.orgn_type_io,
2446: -- p_organization_id => r_mtl_trx_info.from_organization,
2447: -- p_location_id => ln_from_loc_id,
2448: -- p_tax_type => main_rec.tax_type,
2449: -- p_account_name => 'RECOVERY'

Line 2475: p_organization_type => jai_constants.orgn_type_io,

2471: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2472: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2473: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2474: p_regime_id => l_regime_id,
2475: p_organization_type => jai_constants.orgn_type_io,
2476: p_organization_id => r_mtl_trx_info.from_organization,
2477: p_location_id => ln_from_loc_id,
2478: p_tax_type => main_rec.tax_type,
2479: p_account_name => jai_constants.liability_interim

Line 2479: p_account_name => jai_constants.liability_interim

2475: p_organization_type => jai_constants.orgn_type_io,
2476: p_organization_id => r_mtl_trx_info.from_organization,
2477: p_location_id => ln_from_loc_id,
2478: p_tax_type => main_rec.tax_type,
2479: p_account_name => jai_constants.liability_interim
2480: );
2481: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2482: t_gl_entries(rec).organization_code := l_from_org_cd;
2483: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2516: p_organization_type => jai_constants.orgn_type_io,

2512: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2513: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2514: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2515: p_regime_id => l_regime_id,
2516: p_organization_type => jai_constants.orgn_type_io,
2517: p_organization_id => r_mtl_trx_info.from_organization,
2518: p_location_id => ln_from_loc_id,
2519: p_tax_type => main_rec.tax_type,
2520: p_account_name => jai_constants.liability_interim

Line 2520: p_account_name => jai_constants.liability_interim

2516: p_organization_type => jai_constants.orgn_type_io,
2517: p_organization_id => r_mtl_trx_info.from_organization,
2518: p_location_id => ln_from_loc_id,
2519: p_tax_type => main_rec.tax_type,
2520: p_account_name => jai_constants.liability_interim
2521: );
2522: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2523: t_gl_entries(rec).organization_code := l_from_org_cd;
2524: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2544: p_organization_type => jai_constants.orgn_type_io,

2540: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2541: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2542: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2543: p_regime_id => l_regime_id,
2544: p_organization_type => jai_constants.orgn_type_io,
2545: p_organization_id => r_mtl_trx_info.from_organization,
2546: p_location_id => ln_from_loc_id,
2547: p_tax_type => main_rec.tax_type,
2548: p_account_name => jai_constants.liability_interim

Line 2548: p_account_name => jai_constants.liability_interim

2544: p_organization_type => jai_constants.orgn_type_io,
2545: p_organization_id => r_mtl_trx_info.from_organization,
2546: p_location_id => ln_from_loc_id,
2547: p_tax_type => main_rec.tax_type,
2548: p_account_name => jai_constants.liability_interim
2549: );
2550: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2551: t_gl_entries(rec).organization_code := l_from_org_cd;
2552: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2583: p_organization_type => jai_constants.orgn_type_io,

2579: -- starts here code for VAT
2580: t_gl_entries(rec).amount := main_rec.tax_amount;
2581: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2582: p_regime_id => l_regime_id,
2583: p_organization_type => jai_constants.orgn_type_io,
2584: p_organization_id => r_mtl_trx_info.to_organization,
2585: p_location_id => r_mtl_trx_info.location_id,
2586: p_tax_type => main_rec.tax_type,
2587: p_account_name => jai_constants.recovery_interim

Line 2587: p_account_name => jai_constants.recovery_interim

2583: p_organization_type => jai_constants.orgn_type_io,
2584: p_organization_id => r_mtl_trx_info.to_organization,
2585: p_location_id => r_mtl_trx_info.location_id,
2586: p_tax_type => main_rec.tax_type,
2587: p_account_name => jai_constants.recovery_interim
2588: );
2589: IF t_gl_entries(rec).debit_account IS NULL THEN
2590: p_process_status := 'E';
2591: p_process_message := 'Interim Recovery Account is not defined for ' || main_rec.tax_type;

Line 2608: p_organization_type => jai_constants.orgn_type_io,

2604:
2605: t_gl_entries(rec).amount := main_rec.tax_amount;
2606: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2607: p_regime_id => l_regime_id,
2608: p_organization_type => jai_constants.orgn_type_io,
2609: p_organization_id => r_mtl_trx_info.to_organization,
2610: p_location_id => r_mtl_trx_info.location_id,
2611: p_tax_type => main_rec.tax_type,
2612: p_account_name => jai_constants.recovery

Line 2612: p_account_name => jai_constants.recovery

2608: p_organization_type => jai_constants.orgn_type_io,
2609: p_organization_id => r_mtl_trx_info.to_organization,
2610: p_location_id => r_mtl_trx_info.location_id,
2611: p_tax_type => main_rec.tax_type,
2612: p_account_name => jai_constants.recovery
2613: );
2614:
2615: IF t_gl_entries(rec).debit_account IS NULL THEN
2616: p_process_status := 'E';

Line 2622: p_organization_type => jai_constants.orgn_type_io,

2618: RETURN;
2619: END IF;
2620: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2621: p_regime_id => l_regime_id,
2622: p_organization_type => jai_constants.orgn_type_io,
2623: p_organization_id => r_mtl_trx_info.to_organization,
2624: p_location_id => r_mtl_trx_info.location_id,
2625: p_tax_type => main_rec.tax_type,
2626: p_account_name => jai_constants.recovery_interim

Line 2626: p_account_name => jai_constants.recovery_interim

2622: p_organization_type => jai_constants.orgn_type_io,
2623: p_organization_id => r_mtl_trx_info.to_organization,
2624: p_location_id => r_mtl_trx_info.location_id,
2625: p_tax_type => main_rec.tax_type,
2626: p_account_name => jai_constants.recovery_interim
2627: );
2628: IF t_gl_entries(rec).credit_account IS NULL THEN
2629: p_process_status := 'E';
2630: p_process_message := 'Interim Recovery Account not defined for ' || main_rec.tax_type;

Line 2704: p_organization_type => jai_constants.orgn_type_io,

2700: */
2701: t_gl_entries(rec).amount := main_rec.tax_amount;
2702: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2703: p_regime_id => l_regime_id,
2704: p_organization_type => jai_constants.orgn_type_io,
2705: p_organization_id => r_mtl_trx_info.from_organization,
2706: p_location_id => ln_from_loc_id,
2707: p_tax_type => main_rec.tax_type,
2708: p_account_name => 'EXPENSE'

Line 2713: p_organization_type => jai_constants.orgn_type_io,

2709: );
2710:
2711: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2712: p_regime_id => l_regime_id,
2713: p_organization_type => jai_constants.orgn_type_io,
2714: p_organization_id => r_mtl_trx_info.from_organization,
2715: p_location_id => ln_from_loc_id,
2716: p_tax_type => main_rec.tax_type,
2717: p_account_name => 'RECOVERY'

Line 2777: p_organization_type => jai_constants.orgn_type_io,

2773: */
2774: t_gl_entries(rec).amount := main_rec.tax_amount;
2775: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2776: p_regime_id => l_regime_id,
2777: p_organization_type => jai_constants.orgn_type_io,
2778: p_organization_id => r_mtl_trx_info.from_organization,
2779: p_location_id => ln_from_loc_id,
2780: p_tax_type => main_rec.tax_type,
2781: p_account_name => 'EXPENSE'

Line 2786: p_organization_type => jai_constants.orgn_type_io,

2782: );
2783:
2784: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2785: p_regime_id => l_regime_id,
2786: p_organization_type => jai_constants.orgn_type_io,
2787: p_organization_id => r_mtl_trx_info.from_organization,
2788: p_location_id => ln_from_loc_id,
2789: p_tax_type => main_rec.tax_type,
2790: p_account_name => 'RECOVERY'

Line 4710: lv_account_name := jai_constants.recovery;

4706: BEGIN
4707: OPEN c_regime_cur;
4708: FETCH c_regime_cur into ln_regime_id;
4709: CLOSE c_regime_cur;
4710: lv_account_name := jai_constants.recovery;
4711: stmt_name:='Getting the interim recovery amount';
4712: ln_interim_recovery_account :=
4713: jai_cmn_rgm_recording_pkg.get_account(
4714: p_regime_id => ln_regime_id,

Line 4715: p_organization_type => jai_constants.orgn_type_io,

4711: stmt_name:='Getting the interim recovery amount';
4712: ln_interim_recovery_account :=
4713: jai_cmn_rgm_recording_pkg.get_account(
4714: p_regime_id => ln_regime_id,
4715: p_organization_type => jai_constants.orgn_type_io,
4716: p_organization_id => p_organization_id,
4717: p_location_id => p_location_id,
4718: p_tax_type => p_tax_type,
4719: p_account_name => jai_constants.recovery_interim);

Line 4719: p_account_name => jai_constants.recovery_interim);

4715: p_organization_type => jai_constants.orgn_type_io,
4716: p_organization_id => p_organization_id,
4717: p_location_id => p_location_id,
4718: p_tax_type => p_tax_type,
4719: p_account_name => jai_constants.recovery_interim);
4720: IF ln_interim_recovery_account IS NULL THEN
4721: p_process_status := jai_constants.expected_error;
4722: p_process_message := 'Interim recovery Account not defined in VAT Setup';
4723: RETURN;

Line 4721: p_process_status := jai_constants.expected_error;

4717: p_location_id => p_location_id,
4718: p_tax_type => p_tax_type,
4719: p_account_name => jai_constants.recovery_interim);
4720: IF ln_interim_recovery_account IS NULL THEN
4721: p_process_status := jai_constants.expected_error;
4722: p_process_message := 'Interim recovery Account not defined in VAT Setup';
4723: RETURN;
4724: END IF;
4725: stmt_name:='Getting the code combination id';

Line 4729: p_organization_type => jai_constants.orgn_type_io,

4725: stmt_name:='Getting the code combination id';
4726: ln_code_combination_id :=
4727: jai_cmn_rgm_recording_pkg.get_account(
4728: p_regime_id => ln_regime_id,
4729: p_organization_type => jai_constants.orgn_type_io,
4730: p_organization_id => p_organization_id,
4731: p_location_id => p_location_id,
4732: p_tax_type => p_tax_type,
4733: p_account_name => jai_constants.recovery);

Line 4733: p_account_name => jai_constants.recovery);

4729: p_organization_type => jai_constants.orgn_type_io,
4730: p_organization_id => p_organization_id,
4731: p_location_id => p_location_id,
4732: p_tax_type => p_tax_type,
4733: p_account_name => jai_constants.recovery);
4734: IF ln_code_combination_id IS NULL THEN
4735: p_process_status := jai_constants.expected_error;
4736: p_process_message := 'Recovery Account not defined in VAT Setup';
4737: RETURN;

Line 4735: p_process_status := jai_constants.expected_error;

4731: p_location_id => p_location_id,
4732: p_tax_type => p_tax_type,
4733: p_account_name => jai_constants.recovery);
4734: IF ln_code_combination_id IS NULL THEN
4735: p_process_status := jai_constants.expected_error;
4736: p_process_message := 'Recovery Account not defined in VAT Setup';
4737: RETURN;
4738: END IF;
4739: ln_entered_cr:=p_amount;

Line 4745: pv_organization_type => jai_constants.orgn_type_io,

4741: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
4742: pn_repository_id => ln_repository_id,
4743: pn_regime_id => ln_regime_id,
4744: pv_tax_type => p_tax_type,
4745: pv_organization_type => jai_constants.orgn_type_io,
4746: pn_organization_id => p_organization_id,
4747: pn_location_id => p_location_id,
4748: pv_source => jai_constants.source_rcv,
4749: pv_source_trx_type => lv_source_trx_type,

Line 4748: pv_source => jai_constants.source_rcv,

4744: pv_tax_type => p_tax_type,
4745: pv_organization_type => jai_constants.orgn_type_io,
4746: pn_organization_id => p_organization_id,
4747: pn_location_id => p_location_id,
4748: pv_source => jai_constants.source_rcv,
4749: pv_source_trx_type => lv_source_trx_type,
4750: pv_source_table_name => table_rcv_transactions,
4751: pn_source_id => p_transaction_id,
4752: pd_transaction_date => trunc(sysdate),

Line 4779: IF lv_process_status <> jai_constants.successful THEN

4775: pv_trx_reference5 => NULL
4776: --------------------------------------------------
4777: --Added by Bo Li for bug9305067 2010-4-14 END
4778: );
4779: IF lv_process_status <> jai_constants.successful THEN
4780: p_process_status := lv_process_status;
4781: p_process_message := lv_process_message;
4782: RETURN;
4783: END IF;

Line 4789: if lv_process_status<> jai_constants.successful THEN

4785: process_vat_claim_acctg(
4786: ln_repository_id ,
4787: lv_procesS_status,
4788: lv_process_message);
4789: if lv_process_status<> jai_constants.successful THEN
4790: app_exception.raise_exception;
4791: end if;
4792:
4793:

Line 4861: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate) tax_amount, --Removed Round condition by Bgowrava for Bug#8414075

4857:
4858: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4859: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4860: IS
4861: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate) tax_amount, --Removed Round condition by Bgowrava for Bug#8414075
4862: a.tax_type,
4863: a.tax_id,
4864: NVL(b.rounding_factor,0) rounding_factor,
4865: c.qty_received

Line 4873: where regime_code = jai_constants.vat_regime

4869: WHERE a.shipment_line_id =c.shipment_line_id
4870: AND a.shipment_line_id = cp_shipment_line_id
4871: AND a.tax_type IN ( select tax_type
4872: from jai_regime_tax_types_v
4873: where regime_code = jai_constants.vat_regime
4874: )
4875: AND a.tax_id = b.tax_id
4876: AND a.modvat_flag = 'Y'
4877: AND NVL(a.tax_amount,0) <> 0;

Line 4887: AND regime_code=jai_constants.vat_regime;

4883: WHERE shipment_line_id = cp_shipment_line_id
4884: AND receipt_num=p_receipt_num
4885: and organization_id=p_organization_id
4886: and inventory_item_id=p_inventory_item_id
4887: AND regime_code=jai_constants.vat_regime;
4888:
4889: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
4890: IS
4891: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no

Line 4945: p_process_status := jai_constants.successful;

4941:
4942:
4943: BEGIN
4944:
4945: p_process_status := jai_constants.successful;
4946: p_process_message := NULL;
4947:
4948: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
4949: LOOP

Line 4976: IF lv_process_flag <> jai_constants.successful THEN

4972: p_schedule_id => ln_schedule_id,
4973: p_process_flag => lv_process_flag,
4974: p_process_msg => lv_process_msg);
4975:
4976: IF lv_process_flag <> jai_constants.successful THEN
4977:
4978: DELETE jai_rgm_trm_schedules_t
4979: WHERE schedule_id = ln_schedule_id;
4980:

Line 5049: jai_constants.vat_regime,

5045: (ln_claim_schedule_id,
5046: r_term.rcv_rgm_line_id,
5047: rec_lines.shipment_header_id,
5048: rec_lines.shipment_line_id,
5049: jai_constants.vat_regime,
5050: rec_txns.tax_transaction_id,
5051: rec_txns.transaction_type,
5052: rec_txns.transaction_id,
5053: rec_txns.parent_transaction_type,

Line 5101: if lv_process_flag<> jai_constants.successful THEN

5097: ln_schedule_id ,
5098: lv_process_flag ,
5099: lv_process_msg );
5100:
5101: if lv_process_flag<> jai_constants.successful THEN
5102: app_exception.raise_exception;
5103: end if;
5104:
5105: DELETE jai_rgm_trm_schedules_t

Line 5178: lv_currency_code := jai_constants.func_curr;

5174: lv_reference_10 := 'VAT claim accounting';
5175: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';
5176: lv_reference_24 := 'jai_rgm_trx_records';
5177: lv_reference_26 := 'repository_id';
5178: lv_currency_code := jai_constants.func_curr;
5179: ld_accounting_date := TRUNC(SYSDATE);
5180: lv_destination := 'G';
5181:
5182: sqlstmt := 'opening cur_claims cursor';

Line 5195: p_organization_type => jai_constants.orgn_type_io,

5191:
5192: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
5193: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
5194: p_regime_id => ln_regime_id,
5195: p_organization_type => jai_constants.orgn_type_io,
5196: p_organization_id => rec_claims.organization_id,
5197: p_location_id => rec_claims.location_id,
5198: p_tax_type => rec_claims.tax_type,
5199: p_account_name => jai_constants.recovery_interim);

Line 5199: p_account_name => jai_constants.recovery_interim);

5195: p_organization_type => jai_constants.orgn_type_io,
5196: p_organization_id => rec_claims.organization_id,
5197: p_location_id => rec_claims.location_id,
5198: p_tax_type => rec_claims.tax_type,
5199: p_account_name => jai_constants.recovery_interim);
5200:
5201: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
5202: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
5203: p_regime_id => ln_regime_id,

Line 5204: p_organization_type => jai_constants.orgn_type_io,

5200:
5201: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
5202: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
5203: p_regime_id => ln_regime_id,
5204: p_organization_type => jai_constants.orgn_type_io,
5205: p_organization_id => rec_claims.organization_id,
5206: p_location_id => rec_claims.location_id,
5207: p_tax_type => rec_claims.tax_type,
5208: p_account_name => jai_constants.recovery);

Line 5208: p_account_name => jai_constants.recovery);

5204: p_organization_type => jai_constants.orgn_type_io,
5205: p_organization_id => rec_claims.organization_id,
5206: p_location_id => rec_claims.location_id,
5207: p_tax_type => rec_claims.tax_type,
5208: p_account_name => jai_constants.recovery);
5209:
5210:
5211: ln_entered_dr := rec_claims.credit_amount;
5212: ln_entered_cr := NULL;

Line 5238: p_reference_name => jai_constants.repository_name,

5234: p_simulate_flag => 'N',
5235: p_codepath => lv_code_path,
5236: p_process_message => lv_process_message,
5237: p_process_status => lv_process_status,
5238: p_reference_name => jai_constants.repository_name,
5239: p_reference_id => p_repository_id);
5240:
5241: IF lv_process_status <> jai_constants.successful THEN
5242: p_process_status := lv_process_status;

Line 5241: IF lv_process_status <> jai_constants.successful THEN

5237: p_process_status => lv_process_status,
5238: p_reference_name => jai_constants.repository_name,
5239: p_reference_id => p_repository_id);
5240:
5241: IF lv_process_status <> jai_constants.successful THEN
5242: p_process_status := lv_process_status;
5243: p_process_message := lv_process_message;
5244: RETURN;
5245: END IF;

Line 5273: p_reference_name => jai_constants.repository_name,

5269: p_simulate_flag => 'N',
5270: p_codepath => lv_code_path,
5271: p_process_message => lv_process_message,
5272: p_process_status => lv_process_status,
5273: p_reference_name => jai_constants.repository_name,
5274: p_reference_id => p_repository_id);
5275:
5276: IF lv_process_status <> jai_constants.successful THEN
5277: p_process_status := lv_process_status;

Line 5276: IF lv_process_status <> jai_constants.successful THEN

5272: p_process_status => lv_process_status,
5273: p_reference_name => jai_constants.repository_name,
5274: p_reference_id => p_repository_id);
5275:
5276: IF lv_process_status <> jai_constants.successful THEN
5277: p_process_status := lv_process_status;
5278: p_process_message := lv_process_message;
5279: RETURN;
5280: END IF;

Line 5283: p_process_status := jai_constants.successful;

5279: RETURN;
5280: END IF;
5281: END IF;
5282:
5283: p_process_status := jai_constants.successful;
5284: EXCEPTION
5285: WHEN OTHERS THEN
5286: p_process_status := jai_constants.unexpected_error;
5287: p_process_message := 'SQL error while calling '||sqlstmt||' :'||SQLCODE||' : '||SQLERRM;

Line 5286: p_process_status := jai_constants.unexpected_error;

5282:
5283: p_process_status := jai_constants.successful;
5284: EXCEPTION
5285: WHEN OTHERS THEN
5286: p_process_status := jai_constants.unexpected_error;
5287: p_process_message := 'SQL error while calling '||sqlstmt||' :'||SQLCODE||' : '||SQLERRM;
5288: END process_vat_claim_acctg;
5289:
5290: PROCEDURE delete_trx(p_transaction_header_id IN NUMBER,