[Home] [Help]
101: Following changes have been -
102: (i) Changed the cursor - c_receipt_cenvat_dtl.
103: Added in Input parameter - cp_organization_type.
104: Select for the column online_claim_flag is changed from online_claim_flag to
105: decode(cp_organization_type, 'M', online_claim_flag, jai_constants.yes)
106: (ii) While opening the cursor c_receipt_cenvat_dtl, passed the additional parameter
107: r_trx.organization_type
108: (iii) In the If condition after lv_statement_id := 27, added the condition -
109: and r_trx.organization_type = 'M'
216: 1) In the procedure - process_transaction, moved the cursor - c_trx, before calling validate_transaction
217: 2) In the procedure - process_transaction, Variables - lv_process_vat_flag, lv_process_vat_message are
218: assigned value before calling validate_transaction
219: 3) In the procedure - validate_transaction, added the following condition -
220: "if p_process_vat_flag = jai_constants.successful THEN
221: goto end_of_vat_validation;
222: end if;"
223:
224: Column process_vat_flag changed to process_vat_status (jai_rcv_transactions).
428: IS
429: SELECT 1
430: FROM JAI_RCV_LINE_TAXES a , jai_regime_tax_types_v b
431: WHERE shipment_line_id = cp_shipment_line_id AND
432: b.regime_code= jai_constants.vat_regime
433: and b.tax_type = a.tax_type ;
434:
435: ln_vat_exists NUMBER ;
436: -- ended, Ramananda for bug # 4519719
501: ) VALUES (
502: r_trx.transaction_id, r_trx.shipment_line_id, ln_cenvat_amount, 0, 0,
503: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,
504: fnd_global.user_id, fnd_global.login_id,
505: r_excise_invoice_no.online_claim_flag, -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. nvl(r_base_trx.online_claim_flag, jai_constants.no),
506: jai_constants.no
507: );
508:
509: -- Vijay Shankar for Bug#3940588 EDUCATION CESS
502: r_trx.transaction_id, r_trx.shipment_line_id, ln_cenvat_amount, 0, 0,
503: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,
504: fnd_global.user_id, fnd_global.login_id,
505: r_excise_invoice_no.online_claim_flag, -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. nvl(r_base_trx.online_claim_flag, jai_constants.no),
506: jai_constants.no
507: );
508:
509: -- Vijay Shankar for Bug#3940588 EDUCATION CESS
510: IF r_tax.excise_edu_cess <> 0 THEN
508:
509: -- Vijay Shankar for Bug#3940588 EDUCATION CESS
510: IF r_tax.excise_edu_cess <> 0 THEN
511: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
512: p_source_register => jai_constants.reg_receipt_cenvat,
513: p_source_register_id => r_trx.transaction_id,
514: p_tax_type => jai_constants.tax_type_exc_edu_cess,
515: p_credit => r_tax.excise_edu_cess,
516: p_debit => null,
510: IF r_tax.excise_edu_cess <> 0 THEN
511: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
512: p_source_register => jai_constants.reg_receipt_cenvat,
513: p_source_register_id => r_trx.transaction_id,
514: p_tax_type => jai_constants.tax_type_exc_edu_cess,
515: p_credit => r_tax.excise_edu_cess,
516: p_debit => null,
517: p_process_status => p_process_status,
518: p_process_message => p_process_message
524: END IF;
525: /*Added by kunkumar for forward porting bug#5989740, start*/
526: IF r_tax.sh_exc_edu_cess <> 0 THEN
527: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
528: p_source_register => jai_constants.reg_receipt_cenvat,
529: p_source_register_id => r_trx.transaction_id,
530: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
531: p_credit => r_tax.sh_exc_edu_cess,
532: p_debit => null,
526: IF r_tax.sh_exc_edu_cess <> 0 THEN
527: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
528: p_source_register => jai_constants.reg_receipt_cenvat,
529: p_source_register_id => r_trx.transaction_id,
530: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
531: p_credit => r_tax.sh_exc_edu_cess,
532: p_debit => null,
533: p_process_status => p_process_status,
534: p_process_message => p_process_message
540: END IF;
541:
542: IF r_tax.sh_cvd_edu_cess <> 0 THEN
543: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
544: p_source_register => jai_constants.reg_receipt_cenvat,
545: p_source_register_id => r_trx.transaction_id,
546: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
547: p_credit => r_tax.sh_cvd_edu_cess,
548: p_debit => null,
542: IF r_tax.sh_cvd_edu_cess <> 0 THEN
543: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
544: p_source_register => jai_constants.reg_receipt_cenvat,
545: p_source_register_id => r_trx.transaction_id,
546: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
547: p_credit => r_tax.sh_cvd_edu_cess,
548: p_debit => null,
549: p_process_status => p_process_status,
550: p_process_message => p_process_message
559:
560:
561: IF r_tax.cvd_edu_cess <> 0 THEN
562: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
563: p_source_register => jai_constants.reg_receipt_cenvat,
564: p_source_register_id => r_trx.transaction_id,
565: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
566: p_credit => r_tax.cvd_edu_cess,
567: p_debit => null,
561: IF r_tax.cvd_edu_cess <> 0 THEN
562: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
563: p_source_register => jai_constants.reg_receipt_cenvat,
564: p_source_register_id => r_trx.transaction_id,
565: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
566: p_credit => r_tax.cvd_edu_cess,
567: p_debit => null,
568: p_process_status => p_process_status,
569: p_process_message => p_process_message
585: jai_rcv_rgm_claims_pkg.insert_rcv_lines(
586: p_shipment_header_id => null,
587: p_shipment_line_id => p_shipment_line_id,
588: p_transaction_id => p_transaction_id,
589: p_regime_code => jai_constants.vat_regime
590: , p_process_status => p_process_status,
591: p_process_message => p_process_message,
592: p_simulate_flag => p_simulate_flag
593: );
591: p_process_message => p_process_message,
592: p_simulate_flag => p_simulate_flag
593: );
594:
595: IF p_process_status <> jai_constants.successful THEN
596: p_process_status := 'E';
597: RETURN;
598: END IF;
599: END IF ;
710: p_process_status => p_process_status,
711: p_process_message => p_process_message
712: );
713:
714: if p_process_status in (jai_constants.unexpected_error) then
715: p_process_status := 'E';
716: return;
717: end if;
718: end if;
831: and shipment_line_id = cp_shipment_line_id
832: -- and cenvat_rg_flag <> ('P','X') -- pending for parent receive claim
833: -- and cenvat_rg_flag IN ('N', 'X', 'P', 'XT')
834: and attribute1 = jai_rcv_deliver_rtr_pkg.cenvat_costed_flag
835: and (attribute2 IS NULL or attribute2 <> jai_constants.yes)
836: FOR UPDATE OF cenvat_rg_status, cenvat_rg_message
837: order by shipment_line_id, transaction_id;
838:
839: CURSOR c_trxs_to_be_claimed IS
962: p_simulate_flag => p_simulate_flag,
963: p_codepath => lv_codepath,
964: p_process_special_reason => lv_process_special_reason,
965: p_process_special_qty => ln_qty_to_claim,
966: p_excise_processing_reqd => jai_constants.yes, --File.Sql.35 Cbabu
967: p_vat_processing_reqd => jai_constants.yes --File.Sql.35 Cbabu
968: );
969:
970: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
963: p_codepath => lv_codepath,
964: p_process_special_reason => lv_process_special_reason,
965: p_process_special_qty => ln_qty_to_claim,
966: p_excise_processing_reqd => jai_constants.yes, --File.Sql.35 Cbabu
967: p_vat_processing_reqd => jai_constants.yes --File.Sql.35 Cbabu
968: );
969:
970: lv_codepath := jai_general_pkg.plot_codepath(10, lv_codepath);
971:
1086: p_simulate => p_simulate_flag,
1087: p_codepath => lv_codepath,
1088: p_process_status => lv_process_flag,
1089: p_process_message => lv_process_message,
1090: p_process_special_source => jai_constants.cenvat_noclaim,
1091: p_process_special_amount => ln_process_special_amount
1092: );
1093:
1094: IF p_process_flag IN ('E', 'X') THEN
1160: AND upper(tax_type) IN ('EXCISE',
1161: 'ADDL. EXCISE',
1162: 'OTHER EXCISE',
1163: 'CVD',
1164: jai_constants.tax_type_add_cvd,
1165: -- Modified by SACSETHI Bug# 5228046
1166: -- Forward porting the change in 11i bug 5365523
1167: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
1168: jai_constants.tax_type_exc_edu_cess,
1164: jai_constants.tax_type_add_cvd,
1165: -- Modified by SACSETHI Bug# 5228046
1166: -- Forward porting the change in 11i bug 5365523
1167: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
1168: jai_constants.tax_type_exc_edu_cess,
1169: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess,
1170: jai_constants.tax_type_sh_cvd_edu_cess) -- By kunkumar for bug 5989740
1171: AND modvat_flag ='Y';
1172:
1165: -- Modified by SACSETHI Bug# 5228046
1166: -- Forward porting the change in 11i bug 5365523
1167: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
1168: jai_constants.tax_type_exc_edu_cess,
1169: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess,
1170: jai_constants.tax_type_sh_cvd_edu_cess) -- By kunkumar for bug 5989740
1171: AND modvat_flag ='Y';
1172:
1173: lv_codepath := jai_general_pkg.plot_codepath(27.1, lv_codepath);
1166: -- Forward porting the change in 11i bug 5365523
1167: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
1168: jai_constants.tax_type_exc_edu_cess,
1169: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess,
1170: jai_constants.tax_type_sh_cvd_edu_cess) -- By kunkumar for bug 5989740
1171: AND modvat_flag ='Y';
1172:
1173: lv_codepath := jai_general_pkg.plot_codepath(27.1, lv_codepath);
1174:
1176:
1177: << next_record >>
1178:
1179: If lv_common_err_mesg IS NOT NULL
1180: OR lv_cenvat_rg_flag IN ('E', jai_constants.unexpected_error, jai_constants.expected_error)
1181: THEN
1182:
1183: lv_codepath := jai_general_pkg.plot_codepath(28, lv_codepath);
1184: ROLLBACK TO start_deferred_claim;
1207:
1208: END LOOP;
1209:
1210: IF ln_errored_cnt > 0 THEN
1211: p_process_flag := jai_constants.unexpected_error;
1212: p_process_message := 'Errored Record Count:'||ln_errored_cnt;
1213: fnd_file.put_line(fnd_file.log, 'DeferredClaimError Cnt>0:'||p_process_message);
1214: END IF;
1215:
1335: OR
1336: ( process_status IS NULL OR process_status IN ('N', 'E','P') OR cenvat_rg_status IN ('N', 'E','P')
1337: -- following condition added by Vijay Shankar for Bug#4250236(4245089). VAT Implementation
1338: OR -- process_vat_status IN ('N', 'E', 'P') this condition is modified as below for DFF elimination. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1339: process_vat_status IN ('N', 'E', 'P', jai_constants.unexpected_error, jai_constants.expected_error)
1340: -- Vijay Shankar for Bug#3940588 RECEIPTS DEPLUG
1341: -- This is no more required because 2nd 50% Claim is handled seperately through deferred Claim procedure
1342: -- However process_transaction still uses cenvat_claimed_ptg flag to process 2nd 50% Claim
1343: -- OR cenvat_claimed_ptg = 50
1498: OR
1499: ( process_status IS NULL
1500: OR process_status IN ('N', 'E','P')
1501: OR cenvat_rg_status IN ('N', 'E','P')
1502: OR process_vat_status IN ('N', 'E', 'P', jai_constants.unexpected_error, jai_constants.expected_error)
1503: )
1504: )
1505: AND (
1506: ( p_transaction_from IS NULL AND p_transaction_to IS NULL)
1541: OR
1542: ( process_status IS NULL
1543: OR process_status IN ('N', 'E','P')
1544: OR cenvat_rg_status IN ('N', 'E','P')
1545: OR process_vat_status IN ('N', 'E', 'P', jai_constants.unexpected_error, jai_constants.expected_error)
1546: )
1547: )
1548: AND (
1549: ( p_transaction_from IS NULL AND p_transaction_to IS NULL)
1586: OR
1587: ( process_status IS NULL
1588: OR process_status IN ('N', 'E','P')
1589: OR cenvat_rg_status IN ('N', 'E','P')
1590: OR process_vat_status IN ('N', 'E', 'P', jai_constants.unexpected_error, jai_constants.expected_error)
1591: )
1592: )
1593: AND (
1594: ( p_transaction_from IS NULL AND p_transaction_to IS NULL)
1629: OR
1630: ( process_status IS NULL
1631: OR process_status IN ('N', 'E','P')
1632: OR cenvat_rg_status IN ('N', 'E','P')
1633: OR process_vat_status IN ('N', 'E', 'P', jai_constants.unexpected_error, jai_constants.expected_error)
1634: )
1635: )
1636: AND receipt_num IS NOT NULL
1637: AND (p_transaction_id IS NULL OR transaction_id = p_transaction_id)
1790: p_process_message => lv_process_message
1791: );
1792:
1793: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
1794: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
1795: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
1796: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
1797: retcode := jai_constants.request_warning;
1798: END IF;
1793: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
1794: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
1795: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
1796: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
1797: retcode := jai_constants.request_warning;
1798: END IF;
1799:
1800: GOTO end_of_batch;
1801:
1805: WHEN OTHERS THEN
1806: ROLLBACK;
1807: FND_file.put_line(fnd_file.log, 'Error Message:'||SQLERRM);
1808: /*dbms_output.put_line('MainProc-DeferredClaim:Err:'||SQLERRM);*/
1809: retcode := jai_constants.request_error;
1810: RETURN;
1811: END;
1812: /******************** END OF DEFERRED CLAIM **************/
1813:
1885: IF lv_process_flag = 'E' THEN
1886: ROLLBACK;
1887: FND_FILE.put_line( FND_FILE.log, '*** POPULATE_DETAILS Error ***:'||lv_process_message);
1888: errbuf := lv_process_message;
1889: retcode := jai_constants.request_error;
1890: RETURN;
1891: ELSIF p_commit_switch = 'Y' THEN
1892: -- first commit to save all the populated details of JAI_RCV_TRANSACTIONS
1893: COMMIT;
1944: p_common_err_mesg => lv_common_err_mesg,
1945: p_called_from => p_called_from,
1946: p_simulate_flag => p_simulate_flag,
1947: p_codepath => lv_codepath,
1948: p_excise_processing_reqd => jai_constants.yes, --File.Sql.35 Cbabu
1949: p_vat_processing_reqd => jai_constants.yes --File.Sql.35 Cbabu
1950: );
1951:
1952: OPEN c_trx(trx.transaction_id);
1945: p_called_from => p_called_from,
1946: p_simulate_flag => p_simulate_flag,
1947: p_codepath => lv_codepath,
1948: p_excise_processing_reqd => jai_constants.yes, --File.Sql.35 Cbabu
1949: p_vat_processing_reqd => jai_constants.yes --File.Sql.35 Cbabu
1950: );
1951:
1952: OPEN c_trx(trx.transaction_id);
1953: FETCH c_trx INTO r_trx_after_processing;
1975: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1976: );
1977:
1978: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */
1979: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_trx_after_processing.process_vat_status <> jai_constants.successful THEN
1980: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) then
1981: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||trx.transaction_id
1982: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
1983: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
1976: );
1977:
1978: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */
1979: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_trx_after_processing.process_vat_status <> jai_constants.successful THEN
1980: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) then
1981: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||trx.transaction_id
1982: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
1983: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
1984: );
2124: a.PROCESS_VAT_STATUS, a.process_vat_message
2125: , a.attribute1 excise_invoice_action, a.attribute2 vat_invoice_action,
2126: nvl(b.receipt_excise_rate,0) receipt_excise_rate,
2127: nvl(b.rtv_excise_rate, nvl(b.receipt_excise_rate, 0)) rtv_excise_rate,
2128: decode( b.excise_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_excise_in_batch,
2129: decode( b.vat_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_vat_in_batch
2130: from JAI_RCV_TRANSACTIONS a, jai_rcv_rtv_batch_trxs b
2131: where a.transaction_id = b.transaction_id
2132: and (pn_min_transaction_id is null or a.transaction_id >= pn_min_transaction_id)
2125: , a.attribute1 excise_invoice_action, a.attribute2 vat_invoice_action,
2126: nvl(b.receipt_excise_rate,0) receipt_excise_rate,
2127: nvl(b.rtv_excise_rate, nvl(b.receipt_excise_rate, 0)) rtv_excise_rate,
2128: decode( b.excise_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_excise_in_batch,
2129: decode( b.vat_batch_num, cpn_batch_num, jai_constants.yes, jai_constants.no) process_vat_in_batch
2130: from JAI_RCV_TRANSACTIONS a, jai_rcv_rtv_batch_trxs b
2131: where a.transaction_id = b.transaction_id
2132: and (pn_min_transaction_id is null or a.transaction_id >= pn_min_transaction_id)
2133: and (pn_max_transaction_id is null or a.transaction_id <= pn_max_transaction_id)
2231: lv_statement_id := '4';
2232: lv_same_invoice_no_flag := null;
2233: lv_same_invoice_no_flag :=
2234: jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
2235: pv_regime_code => jai_constants.vat_regime,
2236: pv_organization_type => jai_constants.orgn_type_io,
2237: pn_organization_id => ln_organization_id,
2238: pn_location_id => ln_location_id,
2239: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
2232: lv_same_invoice_no_flag := null;
2233: lv_same_invoice_no_flag :=
2234: jai_cmn_rgm_recording_pkg.get_rgm_attribute_value(
2235: pv_regime_code => jai_constants.vat_regime,
2236: pv_organization_type => jai_constants.orgn_type_io,
2237: pn_organization_id => ln_organization_id,
2238: pn_location_id => ln_location_id,
2239: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
2240: pv_attribute_type_code => NULL,
2235: pv_regime_code => jai_constants.vat_regime,
2236: pv_organization_type => jai_constants.orgn_type_io,
2237: pn_organization_id => ln_organization_id,
2238: pn_location_id => ln_location_id,
2239: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
2240: pv_attribute_type_code => NULL,
2241: pv_attribute_code => jai_constants.attr_code_same_inv_no -- 'SAME_INVOICE_NO'
2242: );
2243:
2237: pn_organization_id => ln_organization_id,
2238: pn_location_id => ln_location_id,
2239: pv_registration_type => jai_constants.regn_type_others, --'OTHERS',
2240: pv_attribute_type_code => NULL,
2241: pv_attribute_code => jai_constants.attr_code_same_inv_no -- 'SAME_INVOICE_NO'
2242: );
2243:
2244: lv_statement_id := '5';
2245: lv_same_invoice_no_flag := nvl(lv_same_invoice_no_flag, jai_constants.no);
2241: pv_attribute_code => jai_constants.attr_code_same_inv_no -- 'SAME_INVOICE_NO'
2242: );
2243:
2244: lv_statement_id := '5';
2245: lv_same_invoice_no_flag := nvl(lv_same_invoice_no_flag, jai_constants.no);
2246: lv_gen_excise_invoice_no := null;
2247: ld_gen_excise_invoice_date := null;
2248: lv_gen_vat_invoice_no := null;
2249: ld_gen_vat_invoice_date := null;
2266: if rtv_rec.excise_batch_num = pn_batch_num and rtv_rec.excise_invoice_no is null
2267: and rtv_rec.excise_invoice_action = INV_GEN_STATUS_GENERATE
2268: then
2269: lv_statement_id := '7';
2270: if lv_same_invoice_no_flag = jai_constants.yes then
2271: lv_statement_id := '8';
2272: lv_excise_invoice_no := rtv_rec.vat_invoice_no;
2273: ld_excise_invoice_date := rtv_rec.vat_invoice_date;
2274: end if;
2312: if rtv_rec.vat_batch_num = pn_batch_num and rtv_rec.vat_invoice_no is null
2313: and rtv_rec.vat_invoice_action = INV_GEN_STATUS_GENERATE
2314: then
2315: lv_statement_id := '16';
2316: if lv_same_invoice_no_flag = jai_constants.yes then
2317: lv_statement_id := '17';
2318: lv_vat_invoice_no := lv_excise_invoice_no;
2319: ld_vat_invoice_date := ld_excise_invoice_date;
2320: end if;
2326:
2327: if lv_vat_invoice_no is null then
2328:
2329: lv_statement_id := '19';
2330: open c_regime_id(jai_constants.vat_regime);
2331: fetch c_regime_id into ln_regime_id;
2332: close c_regime_id;
2333:
2334: lv_statement_id := '20';
2345: p_process_msg => lv_process_message
2346: );
2347:
2348: lv_statement_id := '21';
2349: if lv_process_flag in (jai_constants.expected_error, jai_constants.unexpected_error) then
2350: fnd_file.put_line(fnd_file.log, 'VAT Inv Gen Error. Params- RgmId:'||ln_regime_id
2351: ||', OrgnId:'||ln_organization_id ||', LocId:'||ln_location_id
2352: ||', InvDate:'||ld_gen_vat_invoice_date||', TrxId:'|| rtv_rec.transaction_id );
2353: fnd_file.put_line(fnd_file.log, 'ErrorCode:'||lv_process_flag
2422: lv_vat_inv_gen_action := rtv_rec.vat_invoice_action;
2423: end if;
2424: end if;
2425:
2426: if rtv_rec.process_excise_in_batch = jai_constants.yes and ln_excise_batch_group_id is null then
2427: lv_statement_id := '26.1';
2428: insert_rtv_batch_group(
2429: pn_batch_group_id => ln_excise_batch_group_id,
2430: pn_batch_num => pn_batch_num,
2427: lv_statement_id := '26.1';
2428: insert_rtv_batch_group(
2429: pn_batch_group_id => ln_excise_batch_group_id,
2430: pn_batch_num => pn_batch_num,
2431: pv_regime_code => jai_constants.excise_regime,
2432: pn_organization_id => ln_organization_id,
2433: pn_location_id => ln_location_id,
2434: pn_vendor_id => ln_vendor_id,
2435: pn_vendor_site_id => ln_vendor_site_id,
2438: pv_process_status => lv_process_flag,
2439: pv_process_message => lv_process_message
2440: );
2441:
2442: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then
2443: RAISE_APPLICATION_ERROR( 20015, 'Error in Excise insert_rtv_batch_group. MSG:'||lv_process_message);
2444: end if;
2445: end if;
2446:
2443: RAISE_APPLICATION_ERROR( 20015, 'Error in Excise insert_rtv_batch_group. MSG:'||lv_process_message);
2444: end if;
2445: end if;
2446:
2447: if rtv_rec.process_vat_in_batch = jai_constants.yes and ln_vat_batch_group_id is null then
2448: lv_statement_id := '26.2';
2449: insert_rtv_batch_group(
2450: pn_batch_group_id => ln_vat_batch_group_id,
2451: pn_batch_num => pn_batch_num,
2448: lv_statement_id := '26.2';
2449: insert_rtv_batch_group(
2450: pn_batch_group_id => ln_vat_batch_group_id,
2451: pn_batch_num => pn_batch_num,
2452: pv_regime_code => jai_constants.vat_regime,
2453: pn_organization_id => ln_organization_id,
2454: pn_location_id => ln_location_id,
2455: pn_vendor_id => ln_vendor_id,
2456: pn_vendor_site_id => ln_vendor_site_id,
2459: pv_process_status => lv_process_flag,
2460: pv_process_message => lv_process_message
2461: );
2462:
2463: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then
2464: RAISE_APPLICATION_ERROR( 20015, 'Error in Excise insert_rtv_batch_group. MSG:'||lv_process_message);
2465: end if;
2466: end if;
2467:
2464: RAISE_APPLICATION_ERROR( 20015, 'Error in Excise insert_rtv_batch_group. MSG:'||lv_process_message);
2465: end if;
2466: end if;
2467:
2468: if rtv_rec.process_excise_in_batch = jai_constants.yes
2469: or rtv_rec.process_vat_in_batch = jai_constants.yes
2470: then
2471: update jai_rcv_rtv_batch_trxs
2472: set excise_batch_group_id = decode(rtv_rec.process_excise_in_batch, jai_constants.yes, ln_excise_batch_group_id),
2465: end if;
2466: end if;
2467:
2468: if rtv_rec.process_excise_in_batch = jai_constants.yes
2469: or rtv_rec.process_vat_in_batch = jai_constants.yes
2470: then
2471: update jai_rcv_rtv_batch_trxs
2472: set excise_batch_group_id = decode(rtv_rec.process_excise_in_batch, jai_constants.yes, ln_excise_batch_group_id),
2473: vat_batch_group_id = decode(rtv_rec.process_vat_in_batch, jai_constants.yes, ln_vat_batch_group_id)
2468: if rtv_rec.process_excise_in_batch = jai_constants.yes
2469: or rtv_rec.process_vat_in_batch = jai_constants.yes
2470: then
2471: update jai_rcv_rtv_batch_trxs
2472: set excise_batch_group_id = decode(rtv_rec.process_excise_in_batch, jai_constants.yes, ln_excise_batch_group_id),
2473: vat_batch_group_id = decode(rtv_rec.process_vat_in_batch, jai_constants.yes, ln_vat_batch_group_id)
2474: where transaction_id = rtv_rec.transaction_id;
2475: end if;
2476:
2469: or rtv_rec.process_vat_in_batch = jai_constants.yes
2470: then
2471: update jai_rcv_rtv_batch_trxs
2472: set excise_batch_group_id = decode(rtv_rec.process_excise_in_batch, jai_constants.yes, ln_excise_batch_group_id),
2473: vat_batch_group_id = decode(rtv_rec.process_vat_in_batch, jai_constants.yes, ln_vat_batch_group_id)
2474: where transaction_id = rtv_rec.transaction_id;
2475: end if;
2476:
2477: lv_statement_id := '27';
2482: lv_cenvat_rg_message := rtv_rec.cenvat_rg_message;
2483: lv_common_err_mesg := null;
2484: lb_err_flag := false;
2485:
2486: if rtv_rec.process_excise_in_batch = jai_constants.yes
2487: and rtv_rec.excise_invoice_action = INV_GEN_STATUS_GENERATE
2488: then
2489: lv_excise_processing_reqd := jai_constants.yes;
2490: else
2485:
2486: if rtv_rec.process_excise_in_batch = jai_constants.yes
2487: and rtv_rec.excise_invoice_action = INV_GEN_STATUS_GENERATE
2488: then
2489: lv_excise_processing_reqd := jai_constants.yes;
2490: else
2491: lv_excise_processing_reqd := jai_constants.no;
2492: end if;
2493:
2487: and rtv_rec.excise_invoice_action = INV_GEN_STATUS_GENERATE
2488: then
2489: lv_excise_processing_reqd := jai_constants.yes;
2490: else
2491: lv_excise_processing_reqd := jai_constants.no;
2492: end if;
2493:
2494: if rtv_rec.process_vat_in_batch = jai_constants.yes
2495: and rtv_rec.vat_invoice_action in (INV_GEN_STATUS_GENERATE, INV_GEN_STATUS_INV_NA)
2490: else
2491: lv_excise_processing_reqd := jai_constants.no;
2492: end if;
2493:
2494: if rtv_rec.process_vat_in_batch = jai_constants.yes
2495: and rtv_rec.vat_invoice_action in (INV_GEN_STATUS_GENERATE, INV_GEN_STATUS_INV_NA)
2496: and rtv_rec.process_vat_status <> jai_constants.successful
2497: then
2498: lv_vat_processing_reqd := jai_constants.yes;
2492: end if;
2493:
2494: if rtv_rec.process_vat_in_batch = jai_constants.yes
2495: and rtv_rec.vat_invoice_action in (INV_GEN_STATUS_GENERATE, INV_GEN_STATUS_INV_NA)
2496: and rtv_rec.process_vat_status <> jai_constants.successful
2497: then
2498: lv_vat_processing_reqd := jai_constants.yes;
2499: else
2500: lv_vat_processing_reqd := jai_constants.no;
2494: if rtv_rec.process_vat_in_batch = jai_constants.yes
2495: and rtv_rec.vat_invoice_action in (INV_GEN_STATUS_GENERATE, INV_GEN_STATUS_INV_NA)
2496: and rtv_rec.process_vat_status <> jai_constants.successful
2497: then
2498: lv_vat_processing_reqd := jai_constants.yes;
2499: else
2500: lv_vat_processing_reqd := jai_constants.no;
2501: end if;
2502:
2496: and rtv_rec.process_vat_status <> jai_constants.successful
2497: then
2498: lv_vat_processing_reqd := jai_constants.yes;
2499: else
2500: lv_vat_processing_reqd := jai_constants.no;
2501: end if;
2502:
2503: /* call to process the transactions */
2504: process_transaction(
2546: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
2547: );
2548: lb_err_flag := true;
2549: goto end_of_trx;
2550: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) THEN
2551: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||rtv_rec.transaction_id
2552: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
2553: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
2554: );
2575: -- retcode := 1;
2576: END IF;
2577:
2578: /* following procedure call is a replacement for SSI functinoality of JAINRTVN. This is created due to DFF removal */
2579: if lv_excise_processing_reqd = jai_constants.yes and rtv_rec.receipt_excise_rate <> rtv_rec.rtv_excise_rate then
2580: jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(
2581: pn_transaction_id => rtv_rec.transaction_id,
2582: pv_codepath => lv_codepath,
2583: pv_process_status => lv_ssi_cenvat_rg_flag,
2600: lv_statement_id := '32';
2601: /* Following code is a replacement for removal of ja_in_create_rcv_57f4_trg trigger
2602: as part of RTV DFF Elimination */
2603: -- if r_trx.attribute1 = INV_GEN_STATUS_INV_GENERATED then
2604: if lv_excise_processing_reqd = jai_constants.yes then
2605: jai_po_osp_pkg.create_rcv_57f4(
2606: p_transaction_id => rtv_rec.transaction_id,
2607: p_process_status => lv_process_flag,
2608: p_process_message => lv_process_message
2609: );
2610: end if;
2611:
2612: lv_statement_id := '33';
2613: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then
2614: FND_FILE.put_line(FND_FILE.log, 'Error in Call to jai_po_osp_pkg.create_rcv_57f4. Mesg:'||lv_process_message);
2615: lv_process_flag := 'E';
2616: lb_err_flag := true;
2617: goto end_of_trx;
2633: lv_common_err_mesg := null;
2634: lv_codepath := '';
2635: end loop;
2636:
2637: if pv_commit_switch = jai_constants.yes then
2638: COMMIT;
2639: -- ROLLBACK;
2640: end if;
2641:
2641:
2642: EXCEPTION
2643: WHEN OTHERS THEN
2644: ROLLBACK;
2645: pv_retcode := jai_constants.request_error;
2646: pv_errbuf := 'Error(StmtId:'||lv_statement_id||')-'||SQLERRM;
2647: FND_FILE.put_line( FND_FILE.log, pv_errbuf);
2648: -- FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
2649: end process_rtv;
2662: -- following parameters introduced for second claim of receive transaction
2663: p_process_special_reason IN VARCHAR2 DEFAULT NULL,
2664: p_process_special_qty IN NUMBER DEFAULT NULL,
2665: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.*/
2666: p_excise_processing_reqd IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT jai_constants.yes,
2667: p_vat_processing_reqd IN VARCHAR2 --File.Sql.35 Cbabu DEFAULT jai_constants.yes
2668: ) IS
2669:
2670: --added by ssawant
2663: p_process_special_reason IN VARCHAR2 DEFAULT NULL,
2664: p_process_special_qty IN NUMBER DEFAULT NULL,
2665: /*Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.*/
2666: p_excise_processing_reqd IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT jai_constants.yes,
2667: p_vat_processing_reqd IN VARCHAR2 --File.Sql.35 Cbabu DEFAULT jai_constants.yes
2668: ) IS
2669:
2670: --added by ssawant
2671: CURSOR c_base_trx(cp_transaction_id IN NUMBER) IS
2923: /* RG/Cenvat Works only incase if its not a Simulation. Because simulation is not implemented for CENVAT Part */
2924: IF p_simulate_flag = 'N'
2925: AND ( -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_cenvat_rg_flag IN ('N', 'E')
2926: -- condition modified as part of DFF Elimination. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2927: ( p_excise_processing_reqd = jai_constants.yes -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2928: AND p_cenvat_rg_flag IN ('N', 'E')
2929: AND (r_trx.transaction_type <> 'RETURN TO VENDOR'
2930: OR (r_trx.transaction_type = 'RETURN TO VENDOR' and p_called_from = CALLED_FROM_JAITIGRTV) -- nvl(r_trx.attribute1,'XXX')<> INV_GEN_STATUS_PENDING)
2931: )
2987:
2988: /* Start of VAT Execution. Vijay Shankar for Bug#4250236(4245089) */
2989: IF p_simulate_flag = 'N'
2990: AND -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. lv_process_vat_flag IN ('N', 'E')
2991: ( p_vat_processing_reqd = jai_constants.yes -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2992: AND lv_process_vat_flag IN ('N', 'E', jai_constants.expected_error, jai_constants.unexpected_error)
2993: AND (r_trx.transaction_type <> 'RETURN TO VENDOR'
2994: OR (r_trx.transaction_type = 'RETURN TO VENDOR' and p_called_from = CALLED_FROM_JAITIGRTV)
2995: )
2988: /* Start of VAT Execution. Vijay Shankar for Bug#4250236(4245089) */
2989: IF p_simulate_flag = 'N'
2990: AND -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. lv_process_vat_flag IN ('N', 'E')
2991: ( p_vat_processing_reqd = jai_constants.yes -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
2992: AND lv_process_vat_flag IN ('N', 'E', jai_constants.expected_error, jai_constants.unexpected_error)
2993: AND (r_trx.transaction_type <> 'RETURN TO VENDOR'
2994: OR (r_trx.transaction_type = 'RETURN TO VENDOR' and p_called_from = CALLED_FROM_JAITIGRTV)
2995: )
2996: )
3017:
3018: lv_execution_point := 'END_PROCESS_VAT';
3019:
3020: lv_statement_id := '12';
3021: IF lv_process_vat_flag = jai_constants.successful THEN
3022: lv_process_vat_message := 'Successful';
3023: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath);
3024: ELSIF lv_process_vat_flag <> jai_constants.successful THEN
3025: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);
3020: lv_statement_id := '12';
3021: IF lv_process_vat_flag = jai_constants.successful THEN
3022: lv_process_vat_message := 'Successful';
3023: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath);
3024: ELSIF lv_process_vat_flag <> jai_constants.successful THEN
3025: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);
3026: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath);
3027: ROLLBACK TO process_vat_flag;
3028: ELSE
3160: AND vendor_id <> (SELECT vendor_id
3161: FROM rcv_shipment_headers
3162: WHERE shipment_header_id = cp_shipment_header_id
3163: )
3164: AND upper(tax_type) NOT IN (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) --('TDS', 'MODVAT RECOVERY')
3165: AND tax_amount > 0 ;
3166: -- End, Vijay Shankar for Bug#3940588
3167: /*
3168: || srjayara bug 5064235 -- forward porting for bug# 5054114
3433: ln_tax_amount := get_trxn_tax_amount(
3434: p_transaction_id => p_transaction_id,
3435: p_shipment_line_id => r_base_trx.shipment_line_id,
3436: p_curr_conv_rate => r_base_trx.currency_conversion_rate,
3437: p_return_in_inr_curr => jai_constants.yes --File.Sql.35 Cbabu
3438: );
3439:
3440: ln_cenvat_amount := get_trxn_cenvat_amount(
3441: p_transaction_id => p_transaction_id,
3590: sum( decode(upper(tax_type), 'EXCISE', 1,
3591: 'ADDL. EXCISE', 1,
3592: 'OTHER EXCISE', 1,
3593: 'CVD', 1,
3594: jai_constants.tax_type_add_cvd,1,
3595: -- Modified by SACSETHI Bug# 5228046
3596: -- Forward porting the change in 11i bug 5365523
3597: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3598: jai_constants.tax_type_exc_edu_cess,1,
3594: jai_constants.tax_type_add_cvd,1,
3595: -- Modified by SACSETHI Bug# 5228046
3596: -- Forward porting the change in 11i bug 5365523
3597: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3598: jai_constants.tax_type_exc_edu_cess,1,
3599: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
3600: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3601: ) excise_cnt
3602: FROM JAI_RCV_LINE_TAXES
3595: -- Modified by SACSETHI Bug# 5228046
3596: -- Forward porting the change in 11i bug 5365523
3597: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3598: jai_constants.tax_type_exc_edu_cess,1,
3599: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
3600: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3601: ) excise_cnt
3602: FROM JAI_RCV_LINE_TAXES
3603: WHERE shipment_line_id = cp_shipment_line_id
3596: -- Forward porting the change in 11i bug 5365523
3597: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3598: jai_constants.tax_type_exc_edu_cess,1,
3599: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
3600: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3601: ) excise_cnt
3602: FROM JAI_RCV_LINE_TAXES
3603: WHERE shipment_line_id = cp_shipment_line_id
3604: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery); --('TDS', 'MODVAT RECOVERY')
3600: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3601: ) excise_cnt
3602: FROM JAI_RCV_LINE_TAXES
3603: WHERE shipment_line_id = cp_shipment_line_id
3604: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery); --('TDS', 'MODVAT RECOVERY')
3605:
3606: CURSOR c_excise_tax_count(cp_shipment_line_id JAI_RCV_TRANSACTIONS.shipment_line_id%type) is
3607: SELECT count(1)
3608: FROM JAI_RCV_LINE_TAXES
3607: SELECT count(1)
3608: FROM JAI_RCV_LINE_TAXES
3609: WHERE shipment_line_id = cp_shipment_line_id
3610: -- AND tax_type NOT IN ('TDS','Modvat Recovery')
3611: AND modvat_flag = jai_constants.yes
3612: AND upper(tax_type) IN ( 'EXCISE',
3613: 'ADDL. EXCISE',
3614: 'OTHER EXCISE',
3615: 'CVD',
3612: AND upper(tax_type) IN ( 'EXCISE',
3613: 'ADDL. EXCISE',
3614: 'OTHER EXCISE',
3615: 'CVD',
3616: jai_constants.tax_type_add_cvd ,
3617: -- Modified by SACSETHI Bug# 5228046
3618: -- Forward porting the change in 11i bug 5365523
3619: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3620: jai_constants.tax_type_exc_edu_cess,
3616: jai_constants.tax_type_add_cvd ,
3617: -- Modified by SACSETHI Bug# 5228046
3618: -- Forward porting the change in 11i bug 5365523
3619: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3620: jai_constants.tax_type_exc_edu_cess,
3621: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
3622: jai_constants.tax_type_sh_cvd_edu_cess);--Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3623:
3624:
3617: -- Modified by SACSETHI Bug# 5228046
3618: -- Forward porting the change in 11i bug 5365523
3619: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3620: jai_constants.tax_type_exc_edu_cess,
3621: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
3622: jai_constants.tax_type_sh_cvd_edu_cess);--Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3623:
3624:
3625: ln_recoverable_vat_tax_cnt NUMBER;
3618: -- Forward porting the change in 11i bug 5365523
3619: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
3620: jai_constants.tax_type_exc_edu_cess,
3621: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
3622: jai_constants.tax_type_sh_cvd_edu_cess);--Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
3623:
3624:
3625: ln_recoverable_vat_tax_cnt NUMBER;
3626: CURSOR c_recoverable_vat_tax_cnt(cp_shipment_line_id number, cp_regime_code varchar2) is
3626: CURSOR c_recoverable_vat_tax_cnt(cp_shipment_line_id number, cp_regime_code varchar2) is
3627: SELECT count(1)
3628: FROM JAI_RCV_LINE_TAXES
3629: WHERE shipment_line_id = cp_shipment_line_id
3630: AND modvat_flag = jai_constants.yes
3631: AND tax_type IN
3632: ( select tax_type from jai_regime_tax_types_v /*modified this to use View as part of OPM changes */
3633: where regime_code = cp_regime_code
3634: );
3668: AND organization_id = cp_organization_id
3669: AND transaction_source_num = 18;
3670:
3671: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER, cp_organization_type IN VARCHAR2) IS
3672: SELECT decode(cp_organization_type, 'M', online_claim_flag, jai_constants.yes) online_claim_flag, -- Changed by Vijay Shankar for Bug #4172424
3673: cenvat_claimed_ptg, cenvat_claimed_amt, unclaim_cenvat_flag, cenvat_amount
3674: FROM JAI_RCV_CENVAT_CLAIMS
3675: WHERE transaction_id = cp_transaction_id;
3676:
4296:
4297: /* 4 Start of PROCESS_VAT_FLAG Validation */
4298:
4299: --added the below by Ramananda for Bug#4519697
4300: if p_process_vat_flag = jai_constants.successful THEN
4301: goto end_of_vat_validation;
4302: end if;
4303:
4304: /* following condition added as part of DFF elimination. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
4301: goto end_of_vat_validation;
4302: end if;
4303:
4304: /* following condition added as part of DFF elimination. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
4305: if r_trx.process_vat_status in (jai_constants.yes, 'X', 'O') then
4306: lv_codepath := jai_general_pkg.plot_codepath(42.0, lv_codepath);
4307: goto end_of_vat_validation;
4308: end if;
4309:
4321: p_process_vat_message := 'VAT Processing not required for this Transaction Type';
4322: GOTO end_of_vat_validation;
4323: END IF;
4324:
4325: OPEN c_recoverable_vat_tax_cnt(r_trx.shipment_line_id, jai_constants.vat_regime);
4326: FETCH c_recoverable_vat_tax_cnt INTO ln_recoverable_vat_tax_cnt;
4327: CLOSE c_recoverable_vat_tax_cnt;
4328:
4329: IF ln_recoverable_vat_tax_cnt = 0 THEN
4464: SELECT count(1)
4465: FROM JAI_RCV_LINE_TAXES
4466: WHERE shipment_line_id = cp_shipment_line_id
4467: -- CVD is Not Considered, because in ISO scenario CVD is not supported.
4468: AND upper(tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_sh_exc_edu_cess); --Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4469:
4470: CURSOR c_organization_info(cp_organization_id number) IS
4471: SELECT nvl(trading, 'N') trading, nvl(manufacturing, 'N') manufacturing
4472: , nvl(excise_in_rg23d, 'N') excise_in_rg23d -- Vijay Shankar for Bug#4171469
4669: AND upper(a.tax_type) IN ( 'EXCISE',
4670: 'ADDL. EXCISE',
4671: 'OTHER EXCISE',
4672: 'CVD',
4673: jai_constants.tax_type_add_cvd,
4674: -- Modified by SACSETHI Bug# 5228046
4675: -- Forward porting the change in 11i bug 5365523
4676: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
4677: jai_constants.tax_type_exc_edu_cess,
4673: jai_constants.tax_type_add_cvd,
4674: -- Modified by SACSETHI Bug# 5228046
4675: -- Forward porting the change in 11i bug 5365523
4676: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
4677: jai_constants.tax_type_exc_edu_cess,
4678: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
4679: jai_constants.tax_type_sh_cvd_edu_cess) --Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4680: AND (cp_organization_type = 'T' OR (cp_organization_type <> 'T' AND a.modvat_flag = 'Y') );
4681:
4674: -- Modified by SACSETHI Bug# 5228046
4675: -- Forward porting the change in 11i bug 5365523
4676: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
4677: jai_constants.tax_type_exc_edu_cess,
4678: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
4679: jai_constants.tax_type_sh_cvd_edu_cess) --Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4680: AND (cp_organization_type = 'T' OR (cp_organization_type <> 'T' AND a.modvat_flag = 'Y') );
4681:
4682: ln_manufacturing_cenvat_amount NUMBER;
4675: -- Forward porting the change in 11i bug 5365523
4676: -- (Additional CVD Enhancement) as part of the R12 bug 5228046
4677: jai_constants.tax_type_exc_edu_cess,
4678: jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess,
4679: jai_constants.tax_type_sh_cvd_edu_cess) --Added by kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4680: AND (cp_organization_type = 'T' OR (cp_organization_type <> 'T' AND a.modvat_flag = 'Y') );
4681:
4682: ln_manufacturing_cenvat_amount NUMBER;
4683: ln_trading_cenvat_amount NUMBER;