[Home] [Help]
66: are changed between RECEIVE and other receiving transactions
67: - TRANSACTION_PROPROCESSOR : when Called for all RECEIVE and MATCH transactions, this does initial processing of
68: shipment line which will be used for all receiving transactions. Also this is place for other transactions also
69: where in initial processing has to happen for any transaction before going ahead for actual processing.
70: This inserts data into JAI_RCV_CENVAT_CLAIMS, JAI_CMN_RG_OTHERS tables for Cenvat and Cess Amounts
71: - TRANSACTION_POSTPROCESSOR : Does the post processing logic like updating some quantity columns at shipment
72: line level for DELIVER, RTR, RTV and related CORRECTs
73: - Increased the filtering condition for transactions processing by adding p_shipment_header_id and p_shipment_line_id
74: parameters to PROCESS_BATCH procedure
644:
645: IF r_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
646:
647: select count(1) into ln_dup_chk
648: from JAI_RCV_CENVAT_CLAIMS
649: where transaction_id = r_trx.transaction_id;
650:
651: IF ln_dup_chk > 0 THEN
652: return;
689: CLOSE c_excise_invoice_no;
690:
691: -- even if there is no excise, then the data goes into this table. previous code doesnt insert data into this table
692: -- if excise taxes are not present for a line
693: INSERT INTO JAI_RCV_CENVAT_CLAIMS(
694: transaction_id, shipment_line_id, cenvat_amount, cenvat_claimed_ptg, cenvat_sequence,
695: other_cenvat_amt, other_cenvat_claimed_amt, creation_date, created_by, last_update_date,
696: last_updated_by, last_update_login,
697: online_claim_flag,
888: ln_cenvat_amount := 0;
889: ln_cenvat_claimed_ptg := 0;
890: END IF;
891:
892: FND_FILE.put_line(FND_FILE.log, '2. updating JAI_RCV_CENVAT_CLAIMS cenvat amounts');
893:
894: UPDATE JAI_RCV_CENVAT_CLAIMS
895: SET cenvat_amount = nvl(ln_cenvat_amount, cenvat_amount),
896: other_cenvat_amt = nvl(ln_cenvat_amount, other_cenvat_amt),
890: END IF;
891:
892: FND_FILE.put_line(FND_FILE.log, '2. updating JAI_RCV_CENVAT_CLAIMS cenvat amounts');
893:
894: UPDATE JAI_RCV_CENVAT_CLAIMS
895: SET cenvat_amount = nvl(ln_cenvat_amount, cenvat_amount),
896: other_cenvat_amt = nvl(ln_cenvat_amount, other_cenvat_amt),
897: cenvat_claimed_ptg = nvl(ln_cenvat_claimed_ptg, 100),
898: cenvat_sequence = nvl(cenvat_sequence ,0) + 1, -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
920: end if;
921: */
922: end if;
923:
924: FND_FILE.put_line(FND_FILE.log, '3. before updating JAI_RCV_CENVAT_CLAIMS');
925:
926: --Uncommented and added for bug #14308585
927: IF r_trx.transaction_type = 'DELIVER' THEN
928:
925:
926: --Uncommented and added for bug #14308585
927: IF r_trx.transaction_type = 'DELIVER' THEN
928:
929: FND_FILE.put_line(FND_FILE.log, '4. updating JAI_RCV_CENVAT_CLAIMS, r_trx.loc_subinv_type : '||r_trx.loc_subinv_type);
930: -- meaning non bonded
931: IF r_trx.loc_subinv_type = 'N' THEN
932:
933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);
929: FND_FILE.put_line(FND_FILE.log, '4. updating JAI_RCV_CENVAT_CLAIMS, r_trx.loc_subinv_type : '||r_trx.loc_subinv_type);
930: -- meaning non bonded
931: IF r_trx.loc_subinv_type = 'N' THEN
932:
933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);
934:
935: UPDATE JAI_RCV_CENVAT_CLAIMS
936: SET non_bonded_delivery_flag = 'Y',
937: cenvat_claimed_ptg = 100,
931: IF r_trx.loc_subinv_type = 'N' THEN
932:
933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);
934:
935: UPDATE JAI_RCV_CENVAT_CLAIMS
936: SET non_bonded_delivery_flag = 'Y',
937: cenvat_claimed_ptg = 100,
938: last_update_date = sysdate
939: WHERE shipment_line_id = r_trx.shipment_line_id ;
1059: ORDER BY transaction_id;
1060:
1061: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER) IS
1062: SELECT cenvat_claimed_ptg, quantity_for_2nd_claim
1063: FROM JAI_RCV_CENVAT_CLAIMS
1064: WHERE transaction_id = cp_transaction_id;
1065:
1066: r_receipt_cenvat_dtl c_receipt_cenvat_dtl%ROWTYPE;
1067: lv_2nd_claim_flag VARCHAR2(1);
1064: WHERE transaction_id = cp_transaction_id;
1065:
1066: r_receipt_cenvat_dtl c_receipt_cenvat_dtl%ROWTYPE;
1067: lv_2nd_claim_flag VARCHAR2(1);
1068: ln_qty_to_claim JAI_RCV_CENVAT_CLAIMS.quantity_for_2nd_claim%TYPE;
1069: lv_process_special_reason VARCHAR2(50);
1070: ln_process_special_amount NUMBER;
1071:
1072:
1148: -- second claim case
1149: ELSIF r_receipt_cenvat_dtl.cenvat_claimed_ptg < 100 THEN
1150:
1151: lv_codepath := jai_general_pkg.plot_codepath(6, lv_codepath);
1152: -- 2nd Claim should be done only to the tune of JAI_RCV_CENVAT_CLAIMS.
1153: lv_2nd_claim_flag := 'Y';
1154:
1155: ELSE
1156: lv_codepath := jai_general_pkg.plot_codepath(7, lv_codepath);
1437: AND CENVAT_RG_STATUS = 'P' -- waiting for receipt line claim
1438: );
1439:
1440: /* Shall take the help of support to implement the unclaim functionality */
1441: UPDATE JAI_RCV_CENVAT_CLAIMS
1442: SET cenvat_amount = 0,
1443: other_cenvat_amt = 0,
1444: cenvat_sequence = cenvat_sequence + 1,
1445: unclaim_cenvat_flag ='Y',
2161:
2162: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
2163: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
2164: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
2165: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
2166: retcode := jai_constants.request_warning;
2167: END IF;
2168:
2169: GOTO end_of_batch;
4158:
4159: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER, cp_organization_type IN VARCHAR2) IS
4160: SELECT decode(cp_organization_type, 'M', online_claim_flag, jai_constants.yes) online_claim_flag, -- Changed by Vijay Shankar for Bug #4172424
4161: cenvat_claimed_ptg, cenvat_claimed_amt, unclaim_cenvat_flag, cenvat_amount
4162: FROM JAI_RCV_CENVAT_CLAIMS
4163: WHERE transaction_id = cp_transaction_id;
4164:
4165: /*following cursor added for bug 8538155 (FP for bug 8466620)*/
4166: cursor c_get_dest(p_line_location_id number, p_distribution_id number) is