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 215: 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

211:
212: if tax_rec.modvat_flag = 'Y'
213: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
214: 'ADDITIONAL_CVD', 'TDS', 'MODVAT RECOVERY',
215: 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
216:
217: then
218:
219:

Line 226: 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

222:
223: elsif tax_rec.modvat_flag = 'Y'
224: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
225: 'ADDITIONAL_CVD',
226: 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
227:
228: then
229:
230:

Line 240: 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

236: and lv_item_excisable = 'Y'
237: and lv_organization_type = 'T'
238: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
239: 'ADDITIONAL_CVD',
240: 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
241:
242:
243: 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
244:

Line 243: 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

239: 'ADDITIONAL_CVD',
240: 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
241:
242:
243: 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
244:
245: then
246:
247: lv_tax_modvat_flag := 'Y';

Line 261: 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

257:
258: if lv_tax_modvat_flag = 'Y'
259: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
260: 'ADDITIONAL_CVD',
261: 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
262:
263: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
264:
265: jai_constants.tax_type_cvd_edu_cess)

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

259: and upper(tax_rec.tax_type) IN ( 'EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
260: 'ADDITIONAL_CVD',
261: 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
262:
263: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
264:
265: jai_constants.tax_type_cvd_edu_cess)
266: then
267:

Line 265: jai_constants.tax_type_cvd_edu_cess)

261: 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
262:
263: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
264:
265: jai_constants.tax_type_cvd_edu_cess)
266: then
267:
268:
269: ln_recoverable_amt :=

Line 278: 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

274:
275: elsif lv_tax_modvat_flag = 'Y'
276: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
277: 'ADDITIONAL_CVD',
278: 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
279:
280: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
281:
282: jai_constants.tax_type_cvd_edu_cess)

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

276: and upper(tax_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
277: 'ADDITIONAL_CVD',
278: 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
279:
280: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
281:
282: jai_constants.tax_type_cvd_edu_cess)
283: then
284:

Line 282: jai_constants.tax_type_cvd_edu_cess)

278: 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
279:
280: jai_constants.tax_type_sh_cvd_edu_cess, --Added higher education cess by kundan kumar for bug#5907436
281:
282: jai_constants.tax_type_cvd_edu_cess)
283: then
284:
285: ln_recoverable_amt :=
286: round( tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_conv_factor, ln_precision);

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

360: CURSOR excise_cur(trx_temp_id number) IS
361: SELECT SUM(decode(tax_type, 'Excise', round(tax_amt), 0)) exc,
362: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
363: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
364: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
365: 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
366: FROM jai_cmn_document_taxes tax,
367: jai_mtl_trxs trx
368: WHERE tax.source_doc_line_id = trx.transaction_temp_id

Line 365: 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

361: SELECT SUM(decode(tax_type, 'Excise', round(tax_amt), 0)) exc,
362: SUM(decode(tax_type, 'Addl. Excise', round(tax_amt), 0)) additional_ed,
363: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
364: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
365: 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
366: FROM jai_cmn_document_taxes tax,
367: jai_mtl_trxs trx
368: WHERE tax.source_doc_line_id = trx.transaction_temp_id
369: AND trx.transaction_header_id = tax.source_doc_id

Line 660: p_tax_type => jai_constants.tax_type_exc_edu_cess,

656:
657: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
658: p_source_name => 'RG23D',
659: p_source_id => l_register_id,
660: p_tax_type => jai_constants.tax_type_exc_edu_cess,
661: debit_amt => NULL,
662: credit_amt => ln_cess_amount,
663: p_process_flag => p_process_status,
664: p_process_msg => p_process_message

Line 678: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,

674:
675: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
676: p_source_name => 'RG23D',
677: p_source_id => l_register_id,
678: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
679: debit_amt => NULL,
680: credit_amt => ln_other_sh_cess,
681: p_process_flag => p_process_status,
682: p_process_msg => p_process_message

Line 788: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,

784: jai_cmn_rg_others_pkg.insert_row(
785: P_SOURCE_TYPE => 1 ,
786: P_SOURCE_NAME => lv_source_name ,
787: P_SOURCE_ID => l_register_id_ii ,
788: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,
789: DEBIT_AMT =>null ,
790: CREDIT_AMT =>ln_other_sh_cess ,
791: P_PROCESS_FLAG =>l_process_status ,
792: P_PROCESS_MSG =>l_process_message

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

831: lv_process_message VARCHAR2(1000);
832: v_source_name VARCHAR2(100) := 'Register India' ; -- bug 6487405
833: v_category_name VARCHAR2(100) := 'VAT India' ; -- bug 6487405
834:
835: --regime varchar2(100):=jai_constants.vat_regime;
836: CURSOR c_regime_cur IS
837: SELECT regime_id
838: FROM jai_rgm_definitions
839: WHERE regime_code = 'VAT';

Line 885: AND jrr.regime_code = jai_constants.vat_regime

881: AND jmt.transaction_header_id=jcdt.source_doc_id
882: AND jmt.transaction_temp_id=jcdt.source_doc_line_id
883: AND jcdt.tax_id=jtc.tax_id
884: AND jtc.tax_type= jrg.attribute_code -- bug 6436781
885: AND jrr.regime_code = jai_constants.vat_regime
886: AND jrg.regime_id = jrr.regime_id
887: AND jrg.registration_type = 'TAX_TYPES'
888: AND upper(jrg.attribute_code) <> 'VAT REVERSAL'
889: GROUP BY jtc.tax_type,

Line 916: lv_account_name := jai_constants.recovery;

912: end if;
913: END LOOP;
914: --added this if condition for performance issue
915: if nvl(ln_rgm_cnt,0) = 0 then
916: lv_account_name := jai_constants.recovery;
917: stmt_name:='Getting the interim recovery amount';
918: ln_interim_recovery_account :=
919: jai_cmn_rgm_recording_pkg.get_account(
920: p_regime_id => ln_regime_id,

Line 921: p_organization_type => jai_constants.orgn_type_io,

917: stmt_name:='Getting the interim recovery amount';
918: ln_interim_recovery_account :=
919: jai_cmn_rgm_recording_pkg.get_account(
920: p_regime_id => ln_regime_id,
921: p_organization_type => jai_constants.orgn_type_io,
922: p_organization_id => p_organization_id,
923: p_location_id => p_location_id,
924: p_tax_type => rec_claims.tax_type,
925: p_account_name => jai_constants.recovery_interim);

Line 925: p_account_name => jai_constants.recovery_interim);

921: p_organization_type => jai_constants.orgn_type_io,
922: p_organization_id => p_organization_id,
923: p_location_id => p_location_id,
924: p_tax_type => rec_claims.tax_type,
925: p_account_name => jai_constants.recovery_interim);
926: IF ln_interim_recovery_account IS NULL THEN
927: p_process_status := jai_constants.expected_error;
928: p_process_message := 'Interim recovery Account not defined in VAT Setup';
929: RETURN;

Line 927: p_process_status := jai_constants.expected_error;

923: p_location_id => p_location_id,
924: p_tax_type => rec_claims.tax_type,
925: p_account_name => jai_constants.recovery_interim);
926: IF ln_interim_recovery_account IS NULL THEN
927: p_process_status := jai_constants.expected_error;
928: p_process_message := 'Interim recovery Account not defined in VAT Setup';
929: RETURN;
930: END IF;
931: stmt_name:='Getting the code combination id';

Line 935: p_organization_type => jai_constants.orgn_type_io,

931: stmt_name:='Getting the code combination id';
932: ln_code_combination_id :=
933: jai_cmn_rgm_recording_pkg.get_account(
934: p_regime_id => ln_regime_id,
935: p_organization_type => jai_constants.orgn_type_io,
936: p_organization_id => p_organization_id,
937: p_location_id => p_location_id,
938: p_tax_type => rec_claims.tax_type,
939: p_account_name => jai_constants.recovery);

Line 939: p_account_name => jai_constants.recovery);

935: p_organization_type => jai_constants.orgn_type_io,
936: p_organization_id => p_organization_id,
937: p_location_id => p_location_id,
938: p_tax_type => rec_claims.tax_type,
939: p_account_name => jai_constants.recovery);
940: IF ln_code_combination_id IS NULL THEN
941: p_process_status := jai_constants.expected_error;
942: p_process_message := 'Recovery Account not defined in VAT Setup';
943: RETURN;

Line 941: p_process_status := jai_constants.expected_error;

937: p_location_id => p_location_id,
938: p_tax_type => rec_claims.tax_type,
939: p_account_name => jai_constants.recovery);
940: IF ln_code_combination_id IS NULL THEN
941: p_process_status := jai_constants.expected_error;
942: p_process_message := 'Recovery Account not defined in VAT Setup';
943: RETURN;
944: END IF;
945: ln_entered_dr := NULL;

Line 956: pv_organization_type => jai_constants.orgn_type_io,

952: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
953: pn_repository_id => ln_repository_id,
954: pn_regime_id => ln_regime_id,
955: pv_tax_type => rec_claims.tax_type,
956: pv_organization_type => jai_constants.orgn_type_io,
957: pn_organization_id => p_organization_id,
958: pn_location_id => p_location_id,
959: pv_source => jai_constants.source_rcv,
960: pv_source_trx_type => lv_source_trx_type,

Line 959: pv_source => jai_constants.source_rcv,

955: pv_tax_type => rec_claims.tax_type,
956: pv_organization_type => jai_constants.orgn_type_io,
957: pn_organization_id => p_organization_id,
958: pn_location_id => p_location_id,
959: pv_source => jai_constants.source_rcv,
960: pv_source_trx_type => lv_source_trx_type,
961: pv_source_table_name => table_rcv_transactions,
962: pn_source_id => p_transaction_temp_id,
963: pd_transaction_date => trunc(sysdate),

Line 985: IF lv_process_status <> jai_constants.successful THEN

981: pv_attribute2 => NULL,
982: pv_attribute3 => NULL,
983: pv_attribute4 => NULL,
984: pv_attribute5 => NULL);
985: IF lv_process_status <> jai_constants.successful THEN
986: p_process_status := lv_process_status;
987: p_process_message := lv_process_message;
988: RETURN;
989: END IF;

Line 1019: pv_organization_type => jai_constants.orgn_type_io,

1015: stmt_name:='calling do vat accounting procedure for credit';
1016: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1017: pn_regime_id => ln_regime_id,
1018: pn_repository_id => ln_repository_id,
1019: pv_organization_type => jai_constants.orgn_type_io,
1020: pn_organization_id => p_organization_id,
1021: pd_accounting_date => trunc(sysdate),
1022: pd_transaction_date => trunc(sysdate),
1023: pn_credit_amount => ln_entered_cr,

Line 1031: pv_source => jai_constants.source_rcv,

1027: pv_called_from => NULL,
1028: pv_process_flag => lv_process_status,
1029: pv_process_message => lv_process_message,
1030: pv_tax_type => rec_claims.tax_type,
1031: pv_source => jai_constants.source_rcv,
1032: pv_source_trx_type => lv_source_trx_type,
1033: pv_source_table_name => table_rcv_transactions,
1034: pn_source_id => p_transaction_temp_id,
1035: pv_reference_name => NULL,

Line 1045: pv_organization_type => jai_constants.orgn_type_io,

1041: stmt_name:='calling do vat accounting procedure for debit';
1042: jai_cmn_rgm_recording_pkg.do_vat_accounting(
1043: pn_regime_id => ln_regime_id,
1044: pn_repository_id => ln_repository_id,
1045: pv_organization_type => jai_constants.orgn_type_io,
1046: pn_organization_id => p_organization_id,
1047: pd_accounting_date => trunc(sysdate),
1048: pd_transaction_date => trunc(sysdate),
1049: pn_credit_amount => ln_entered_cr,

Line 1057: pv_source => jai_constants.source_rcv,

1053: pv_called_from => NULL,
1054: pv_process_flag => lv_process_status,
1055: pv_process_message => lv_process_message,
1056: pv_tax_type => rec_claims.tax_type,
1057: pv_source => jai_constants.source_rcv,
1058: pv_source_trx_type => lv_source_trx_type,
1059: pv_source_table_name => table_rcv_transactions,
1060: pn_source_id => p_transaction_temp_id,
1061: pv_reference_name => NULL,

Line 1389: 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

1385: DECODE(aa.regime_code, 'VAT', 4, DECODE( UPPER( A.Tax_Type ),
1386: 'EXCISE', 1,
1387: 'ADDL. EXCISE', 1,
1388: 'OTHER EXCISE', 1,
1389: 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
1390:
1391: 'TDS', 2, 0)) tax_type_val,
1392: A.Tax_Amt tax_amount,
1393: b.tax_account_id ,

Line 2235: p_organization_type => jai_constants.orgn_type_io,

2231: t_gl_entries(rec).amount := main_rec.tax_amount;
2232: stmt_name := 'Calling:4 jai_cmn_rgm_recording_pkg.get_account()';
2233: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2234: p_regime_id => l_regime_id,
2235: p_organization_type => jai_constants.orgn_type_io,
2236: p_organization_id => r_mtl_trx_info.from_organization,
2237: p_location_id => ln_from_loc_id,
2238: p_tax_type => main_rec.tax_type,
2239: p_account_name => jai_constants.liability_interim

Line 2239: p_account_name => jai_constants.liability_interim

2235: p_organization_type => jai_constants.orgn_type_io,
2236: p_organization_id => r_mtl_trx_info.from_organization,
2237: p_location_id => ln_from_loc_id,
2238: p_tax_type => main_rec.tax_type,
2239: p_account_name => jai_constants.liability_interim
2240: );
2241: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2242: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2243: p_regime_id => l_regime_id,

Line 2244: p_organization_type => jai_constants.orgn_type_io,

2240: );
2241: stmt_name := 'Calling:3 jai_cmn_rgm_recording_pkg.get_account()';
2242: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2243: p_regime_id => l_regime_id,
2244: p_organization_type => jai_constants.orgn_type_io,
2245: p_organization_id => r_mtl_trx_info.from_organization,
2246: p_location_id => ln_from_loc_id,
2247: p_tax_type => main_rec.tax_type,
2248: p_account_name => jai_constants.liability

Line 2248: p_account_name => jai_constants.liability

2244: p_organization_type => jai_constants.orgn_type_io,
2245: p_organization_id => r_mtl_trx_info.from_organization,
2246: p_location_id => ln_from_loc_id,
2247: p_tax_type => main_rec.tax_type,
2248: p_account_name => jai_constants.liability
2249: ) ;
2250: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2251: t_gl_entries(rec).organization_code := l_from_org_cd;
2252:

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

2268: */
2269: -- t_gl_entries(rec).amount := main_rec.tax_amount;
2270: -- t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2271: -- p_regime_id => l_regime_id,
2272: -- p_organization_type => jai_constants.orgn_type_io,
2273: -- p_organization_id => r_mtl_trx_info.from_organization,
2274: -- p_location_id => ln_from_loc_id,
2275: -- p_tax_type => main_rec.tax_type,
2276: -- p_account_name => 'EXPENSE'

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

2277: -- );
2278:
2279: -- t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2280: -- p_regime_id => l_regime_id,
2281: -- p_organization_type => jai_constants.orgn_type_io,
2282: -- p_organization_id => r_mtl_trx_info.from_organization,
2283: -- p_location_id => ln_from_loc_id,
2284: -- p_tax_type => main_rec.tax_type,
2285: -- p_account_name => 'RECOVERY'

Line 2311: p_organization_type => jai_constants.orgn_type_io,

2307: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2308: stmt_name := 'Calling:2 jai_cmn_rgm_recording_pkg.get_account()';
2309: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2310: p_regime_id => l_regime_id,
2311: p_organization_type => jai_constants.orgn_type_io,
2312: p_organization_id => r_mtl_trx_info.from_organization,
2313: p_location_id => ln_from_loc_id,
2314: p_tax_type => main_rec.tax_type,
2315: p_account_name => jai_constants.liability_interim

Line 2315: p_account_name => jai_constants.liability_interim

2311: p_organization_type => jai_constants.orgn_type_io,
2312: p_organization_id => r_mtl_trx_info.from_organization,
2313: p_location_id => ln_from_loc_id,
2314: p_tax_type => main_rec.tax_type,
2315: p_account_name => jai_constants.liability_interim
2316: );
2317: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2318: t_gl_entries(rec).organization_code := l_from_org_cd;
2319: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2352: p_organization_type => jai_constants.orgn_type_io,

2348: t_gl_entries(rec).debit_account := r_get_interorg_params.intransit_inv_account;
2349: stmt_name := 'Calling:1 jai_cmn_rgm_recording_pkg.get_account()';
2350: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2351: p_regime_id => l_regime_id,
2352: p_organization_type => jai_constants.orgn_type_io,
2353: p_organization_id => r_mtl_trx_info.from_organization,
2354: p_location_id => ln_from_loc_id,
2355: p_tax_type => main_rec.tax_type,
2356: p_account_name => jai_constants.liability_interim

Line 2356: p_account_name => jai_constants.liability_interim

2352: p_organization_type => jai_constants.orgn_type_io,
2353: p_organization_id => r_mtl_trx_info.from_organization,
2354: p_location_id => ln_from_loc_id,
2355: p_tax_type => main_rec.tax_type,
2356: p_account_name => jai_constants.liability_interim
2357: );
2358: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2359: t_gl_entries(rec).organization_code := l_from_org_cd;
2360: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2380: p_organization_type => jai_constants.orgn_type_io,

2376: t_gl_entries(rec).debit_account := r_get_interorg_params.interorg_receivables_account;
2377: stmt_name := 'Calling jai_cmn_rgm_recording_pkg.get_account()';
2378: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2379: p_regime_id => l_regime_id,
2380: p_organization_type => jai_constants.orgn_type_io,
2381: p_organization_id => r_mtl_trx_info.from_organization,
2382: p_location_id => ln_from_loc_id,
2383: p_tax_type => main_rec.tax_type,
2384: p_account_name => jai_constants.liability_interim

Line 2384: p_account_name => jai_constants.liability_interim

2380: p_organization_type => jai_constants.orgn_type_io,
2381: p_organization_id => r_mtl_trx_info.from_organization,
2382: p_location_id => ln_from_loc_id,
2383: p_tax_type => main_rec.tax_type,
2384: p_account_name => jai_constants.liability_interim
2385: );
2386: t_gl_entries(rec).organization_id := r_mtl_trx_info.from_organization;
2387: t_gl_entries(rec).organization_code := l_from_org_cd;
2388: IF t_gl_entries(rec).debit_account IS NULL THEN

Line 2419: p_organization_type => jai_constants.orgn_type_io,

2415: -- starts here code for VAT
2416: t_gl_entries(rec).amount := main_rec.tax_amount;
2417: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2418: p_regime_id => l_regime_id,
2419: p_organization_type => jai_constants.orgn_type_io,
2420: p_organization_id => r_mtl_trx_info.to_organization,
2421: p_location_id => r_mtl_trx_info.location_id,
2422: p_tax_type => main_rec.tax_type,
2423: p_account_name => jai_constants.recovery_interim

Line 2423: p_account_name => jai_constants.recovery_interim

2419: p_organization_type => jai_constants.orgn_type_io,
2420: p_organization_id => r_mtl_trx_info.to_organization,
2421: p_location_id => r_mtl_trx_info.location_id,
2422: p_tax_type => main_rec.tax_type,
2423: p_account_name => jai_constants.recovery_interim
2424: );
2425: IF t_gl_entries(rec).debit_account IS NULL THEN
2426: p_process_status := 'E';
2427: p_process_message := 'Interim Recovery Account is not defined for ' || main_rec.tax_type;

Line 2444: p_organization_type => jai_constants.orgn_type_io,

2440:
2441: t_gl_entries(rec).amount := main_rec.tax_amount;
2442: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2443: p_regime_id => l_regime_id,
2444: p_organization_type => jai_constants.orgn_type_io,
2445: p_organization_id => r_mtl_trx_info.to_organization,
2446: p_location_id => r_mtl_trx_info.location_id,
2447: p_tax_type => main_rec.tax_type,
2448: p_account_name => jai_constants.recovery

Line 2448: p_account_name => jai_constants.recovery

2444: p_organization_type => jai_constants.orgn_type_io,
2445: p_organization_id => r_mtl_trx_info.to_organization,
2446: p_location_id => r_mtl_trx_info.location_id,
2447: p_tax_type => main_rec.tax_type,
2448: p_account_name => jai_constants.recovery
2449: );
2450:
2451: IF t_gl_entries(rec).debit_account IS NULL THEN
2452: p_process_status := 'E';

Line 2458: p_organization_type => jai_constants.orgn_type_io,

2454: RETURN;
2455: END IF;
2456: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2457: p_regime_id => l_regime_id,
2458: p_organization_type => jai_constants.orgn_type_io,
2459: p_organization_id => r_mtl_trx_info.to_organization,
2460: p_location_id => r_mtl_trx_info.location_id,
2461: p_tax_type => main_rec.tax_type,
2462: p_account_name => jai_constants.recovery_interim

Line 2462: p_account_name => jai_constants.recovery_interim

2458: p_organization_type => jai_constants.orgn_type_io,
2459: p_organization_id => r_mtl_trx_info.to_organization,
2460: p_location_id => r_mtl_trx_info.location_id,
2461: p_tax_type => main_rec.tax_type,
2462: p_account_name => jai_constants.recovery_interim
2463: );
2464: IF t_gl_entries(rec).credit_account IS NULL THEN
2465: p_process_status := 'E';
2466: p_process_message := 'Interim Recovery Account not defined for ' || main_rec.tax_type;

Line 2540: p_organization_type => jai_constants.orgn_type_io,

2536: */
2537: t_gl_entries(rec).amount := main_rec.tax_amount;
2538: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2539: p_regime_id => l_regime_id,
2540: p_organization_type => jai_constants.orgn_type_io,
2541: p_organization_id => r_mtl_trx_info.from_organization,
2542: p_location_id => ln_from_loc_id,
2543: p_tax_type => main_rec.tax_type,
2544: p_account_name => 'EXPENSE'

Line 2549: p_organization_type => jai_constants.orgn_type_io,

2545: );
2546:
2547: t_gl_entries(rec).credit_account := jai_cmn_rgm_recording_pkg.get_account(
2548: p_regime_id => l_regime_id,
2549: p_organization_type => jai_constants.orgn_type_io,
2550: p_organization_id => r_mtl_trx_info.from_organization,
2551: p_location_id => ln_from_loc_id,
2552: p_tax_type => main_rec.tax_type,
2553: p_account_name => 'RECOVERY'

Line 2613: p_organization_type => jai_constants.orgn_type_io,

2609: */
2610: t_gl_entries(rec).amount := main_rec.tax_amount;
2611: t_gl_entries(rec).debit_account := jai_cmn_rgm_recording_pkg.get_account(
2612: p_regime_id => l_regime_id,
2613: p_organization_type => jai_constants.orgn_type_io,
2614: p_organization_id => r_mtl_trx_info.from_organization,
2615: p_location_id => ln_from_loc_id,
2616: p_tax_type => main_rec.tax_type,
2617: p_account_name => 'EXPENSE'

Line 2622: p_organization_type => jai_constants.orgn_type_io,

2618: );
2619:
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.from_organization,
2624: p_location_id => ln_from_loc_id,
2625: p_tax_type => main_rec.tax_type,
2626: p_account_name => 'RECOVERY'

Line 4270: lv_account_name := jai_constants.recovery;

4266: BEGIN
4267: OPEN c_regime_cur;
4268: FETCH c_regime_cur into ln_regime_id;
4269: CLOSE c_regime_cur;
4270: lv_account_name := jai_constants.recovery;
4271: stmt_name:='Getting the interim recovery amount';
4272: ln_interim_recovery_account :=
4273: jai_cmn_rgm_recording_pkg.get_account(
4274: p_regime_id => ln_regime_id,

Line 4275: p_organization_type => jai_constants.orgn_type_io,

4271: stmt_name:='Getting the interim recovery amount';
4272: ln_interim_recovery_account :=
4273: jai_cmn_rgm_recording_pkg.get_account(
4274: p_regime_id => ln_regime_id,
4275: p_organization_type => jai_constants.orgn_type_io,
4276: p_organization_id => p_organization_id,
4277: p_location_id => p_location_id,
4278: p_tax_type => p_tax_type,
4279: p_account_name => jai_constants.recovery_interim);

Line 4279: p_account_name => jai_constants.recovery_interim);

4275: p_organization_type => jai_constants.orgn_type_io,
4276: p_organization_id => p_organization_id,
4277: p_location_id => p_location_id,
4278: p_tax_type => p_tax_type,
4279: p_account_name => jai_constants.recovery_interim);
4280: IF ln_interim_recovery_account IS NULL THEN
4281: p_process_status := jai_constants.expected_error;
4282: p_process_message := 'Interim recovery Account not defined in VAT Setup';
4283: RETURN;

Line 4281: p_process_status := jai_constants.expected_error;

4277: p_location_id => p_location_id,
4278: p_tax_type => p_tax_type,
4279: p_account_name => jai_constants.recovery_interim);
4280: IF ln_interim_recovery_account IS NULL THEN
4281: p_process_status := jai_constants.expected_error;
4282: p_process_message := 'Interim recovery Account not defined in VAT Setup';
4283: RETURN;
4284: END IF;
4285: stmt_name:='Getting the code combination id';

Line 4289: p_organization_type => jai_constants.orgn_type_io,

4285: stmt_name:='Getting the code combination id';
4286: ln_code_combination_id :=
4287: jai_cmn_rgm_recording_pkg.get_account(
4288: p_regime_id => ln_regime_id,
4289: p_organization_type => jai_constants.orgn_type_io,
4290: p_organization_id => p_organization_id,
4291: p_location_id => p_location_id,
4292: p_tax_type => p_tax_type,
4293: p_account_name => jai_constants.recovery);

Line 4293: p_account_name => jai_constants.recovery);

4289: p_organization_type => jai_constants.orgn_type_io,
4290: p_organization_id => p_organization_id,
4291: p_location_id => p_location_id,
4292: p_tax_type => p_tax_type,
4293: p_account_name => jai_constants.recovery);
4294: IF ln_code_combination_id IS NULL THEN
4295: p_process_status := jai_constants.expected_error;
4296: p_process_message := 'Recovery Account not defined in VAT Setup';
4297: RETURN;

Line 4295: p_process_status := jai_constants.expected_error;

4291: p_location_id => p_location_id,
4292: p_tax_type => p_tax_type,
4293: p_account_name => jai_constants.recovery);
4294: IF ln_code_combination_id IS NULL THEN
4295: p_process_status := jai_constants.expected_error;
4296: p_process_message := 'Recovery Account not defined in VAT Setup';
4297: RETURN;
4298: END IF;
4299: ln_entered_cr:=p_amount;

Line 4305: pv_organization_type => jai_constants.orgn_type_io,

4301: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(
4302: pn_repository_id => ln_repository_id,
4303: pn_regime_id => ln_regime_id,
4304: pv_tax_type => p_tax_type,
4305: pv_organization_type => jai_constants.orgn_type_io,
4306: pn_organization_id => p_organization_id,
4307: pn_location_id => p_location_id,
4308: pv_source => jai_constants.source_rcv,
4309: pv_source_trx_type => lv_source_trx_type,

Line 4308: pv_source => jai_constants.source_rcv,

4304: pv_tax_type => p_tax_type,
4305: pv_organization_type => jai_constants.orgn_type_io,
4306: pn_organization_id => p_organization_id,
4307: pn_location_id => p_location_id,
4308: pv_source => jai_constants.source_rcv,
4309: pv_source_trx_type => lv_source_trx_type,
4310: pv_source_table_name => table_rcv_transactions,
4311: pn_source_id => p_transaction_id,
4312: pd_transaction_date => trunc(sysdate),

Line 4334: IF lv_process_status <> jai_constants.successful THEN

4330: pv_attribute2 => NULL,
4331: pv_attribute3 => NULL,
4332: pv_attribute4 => NULL,
4333: pv_attribute5 => NULL);
4334: IF lv_process_status <> jai_constants.successful THEN
4335: p_process_status := lv_process_status;
4336: p_process_message := lv_process_message;
4337: RETURN;
4338: END IF;

Line 4344: if lv_process_status<> jai_constants.successful THEN

4340: process_vat_claim_acctg(
4341: ln_repository_id ,
4342: lv_procesS_status,
4343: lv_process_message);
4344: if lv_process_status<> jai_constants.successful THEN
4345: app_exception.raise_exception;
4346: end if;
4347:
4348:

Line 4417: DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),

4413: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4414: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4415: IS
4416: SELECT ROUND(
4417: DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
4418: NVL(b.rounding_factor, 0)
4419: ) tax_amount,
4420: a.tax_type,
4421: a.tax_id,

Line 4431: where regime_code = jai_constants.vat_regime

4427: WHERE a.shipment_line_id =c.shipment_line_id
4428: AND a.shipment_line_id = cp_shipment_line_id
4429: AND a.tax_type IN ( select tax_type
4430: from jai_regime_tax_types_v
4431: where regime_code = jai_constants.vat_regime
4432: )
4433: AND a.tax_id = b.tax_id
4434: AND a.modvat_flag = 'Y'
4435: AND NVL(a.tax_amount,0) <> 0;

Line 4445: AND regime_code=jai_constants.vat_regime;

4441: WHERE shipment_line_id = cp_shipment_line_id
4442: AND receipt_num=p_receipt_num
4443: and organization_id=p_organization_id
4444: and inventory_item_id=p_inventory_item_id
4445: AND regime_code=jai_constants.vat_regime;
4446:
4447: CURSOR cur_sum_schedules(cp_schedule_id IN NUMBER)
4448: IS
4449: SELECT SUM(installment_amount) total_installment_amount, MAX(installment_no) max_installment_no

Line 4503: p_process_status := jai_constants.successful;

4499:
4500:
4501: BEGIN
4502:
4503: p_process_status := jai_constants.successful;
4504: p_process_message := NULL;
4505:
4506: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
4507: LOOP

Line 4533: IF lv_process_flag <> jai_constants.successful THEN

4529: p_schedule_id => ln_schedule_id,
4530: p_process_flag => lv_process_flag,
4531: p_process_msg => lv_process_msg);
4532:
4533: IF lv_process_flag <> jai_constants.successful THEN
4534:
4535: DELETE jai_rgm_trm_schedules_t
4536: WHERE schedule_id = ln_schedule_id;
4537:

Line 4606: jai_constants.vat_regime,

4602: (ln_claim_schedule_id,
4603: r_term.rcv_rgm_line_id,
4604: rec_lines.shipment_header_id,
4605: rec_lines.shipment_line_id,
4606: jai_constants.vat_regime,
4607: rec_txns.tax_transaction_id,
4608: rec_txns.transaction_type,
4609: rec_txns.transaction_id,
4610: rec_txns.parent_transaction_type,

Line 4658: if lv_process_flag<> jai_constants.successful THEN

4654: ln_schedule_id ,
4655: lv_process_flag ,
4656: lv_process_msg );
4657:
4658: if lv_process_flag<> jai_constants.successful THEN
4659: app_exception.raise_exception;
4660: end if;
4661:
4662: DELETE jai_rgm_trm_schedules_t

Line 4735: lv_currency_code := jai_constants.func_curr;

4731: lv_reference_10 := 'VAT claim accounting';
4732: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';
4733: lv_reference_24 := 'jai_rgm_trx_records';
4734: lv_reference_26 := 'repository_id';
4735: lv_currency_code := jai_constants.func_curr;
4736: ld_accounting_date := TRUNC(SYSDATE);
4737: lv_destination := 'G';
4738:
4739: sqlstmt := 'opening cur_claims cursor';

Line 4752: p_organization_type => jai_constants.orgn_type_io,

4748:
4749: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for interim recovery account';
4750: ln_debit_ac := jai_cmn_rgm_recording_pkg.get_account(
4751: p_regime_id => ln_regime_id,
4752: p_organization_type => jai_constants.orgn_type_io,
4753: p_organization_id => rec_claims.organization_id,
4754: p_location_id => rec_claims.location_id,
4755: p_tax_type => rec_claims.tax_type,
4756: p_account_name => jai_constants.recovery_interim);

Line 4756: p_account_name => jai_constants.recovery_interim);

4752: p_organization_type => jai_constants.orgn_type_io,
4753: p_organization_id => rec_claims.organization_id,
4754: p_location_id => rec_claims.location_id,
4755: p_tax_type => rec_claims.tax_type,
4756: p_account_name => jai_constants.recovery_interim);
4757:
4758: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
4759: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
4760: p_regime_id => ln_regime_id,

Line 4761: p_organization_type => jai_constants.orgn_type_io,

4757:
4758: sqlstmt := 'jai_cmn_rgm_recording_pkg.get_account for recovery account';
4759: ln_credit_ac := jai_cmn_rgm_recording_pkg.get_account(
4760: p_regime_id => ln_regime_id,
4761: p_organization_type => jai_constants.orgn_type_io,
4762: p_organization_id => rec_claims.organization_id,
4763: p_location_id => rec_claims.location_id,
4764: p_tax_type => rec_claims.tax_type,
4765: p_account_name => jai_constants.recovery);

Line 4765: p_account_name => jai_constants.recovery);

4761: p_organization_type => jai_constants.orgn_type_io,
4762: p_organization_id => rec_claims.organization_id,
4763: p_location_id => rec_claims.location_id,
4764: p_tax_type => rec_claims.tax_type,
4765: p_account_name => jai_constants.recovery);
4766:
4767:
4768: ln_entered_dr := rec_claims.credit_amount;
4769: ln_entered_cr := NULL;

Line 4795: p_reference_name => jai_constants.repository_name,

4791: p_simulate_flag => 'N',
4792: p_codepath => lv_code_path,
4793: p_process_message => lv_process_message,
4794: p_process_status => lv_process_status,
4795: p_reference_name => jai_constants.repository_name,
4796: p_reference_id => p_repository_id);
4797:
4798: IF lv_process_status <> jai_constants.successful THEN
4799: p_process_status := lv_process_status;

Line 4798: IF lv_process_status <> jai_constants.successful THEN

4794: p_process_status => lv_process_status,
4795: p_reference_name => jai_constants.repository_name,
4796: p_reference_id => p_repository_id);
4797:
4798: IF lv_process_status <> jai_constants.successful THEN
4799: p_process_status := lv_process_status;
4800: p_process_message := lv_process_message;
4801: RETURN;
4802: END IF;

Line 4830: p_reference_name => jai_constants.repository_name,

4826: p_simulate_flag => 'N',
4827: p_codepath => lv_code_path,
4828: p_process_message => lv_process_message,
4829: p_process_status => lv_process_status,
4830: p_reference_name => jai_constants.repository_name,
4831: p_reference_id => p_repository_id);
4832:
4833: IF lv_process_status <> jai_constants.successful THEN
4834: p_process_status := lv_process_status;

Line 4833: IF lv_process_status <> jai_constants.successful THEN

4829: p_process_status => lv_process_status,
4830: p_reference_name => jai_constants.repository_name,
4831: p_reference_id => p_repository_id);
4832:
4833: IF lv_process_status <> jai_constants.successful THEN
4834: p_process_status := lv_process_status;
4835: p_process_message := lv_process_message;
4836: RETURN;
4837: END IF;

Line 4840: p_process_status := jai_constants.successful;

4836: RETURN;
4837: END IF;
4838: END IF;
4839:
4840: p_process_status := jai_constants.successful;
4841: EXCEPTION
4842: WHEN OTHERS THEN
4843: p_process_status := jai_constants.unexpected_error;
4844: p_process_message := 'SQL error while calling '||sqlstmt||' :'||SQLCODE||' : '||SQLERRM;

Line 4843: p_process_status := jai_constants.unexpected_error;

4839:
4840: p_process_status := jai_constants.successful;
4841: EXCEPTION
4842: WHEN OTHERS THEN
4843: p_process_status := jai_constants.unexpected_error;
4844: p_process_message := 'SQL error while calling '||sqlstmt||' :'||SQLCODE||' : '||SQLERRM;
4845: END process_vat_claim_acctg;
4846:
4847: PROCEDURE delete_trx(p_transaction_header_id IN NUMBER,