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_RCV_TRX_PROCESSING_PKG dependencies on FND_GLOBAL

Line 701: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,

697: online_claim_flag,
698: vendor_changed_flag
699: ) VALUES (
700: r_trx.transaction_id, r_trx.shipment_line_id, ln_cenvat_amount, 0, 0,
701: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,
702: fnd_global.user_id, fnd_global.login_id,
703: 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),
704: jai_constants.no
705: );

Line 702: fnd_global.user_id, fnd_global.login_id,

698: vendor_changed_flag
699: ) VALUES (
700: r_trx.transaction_id, r_trx.shipment_line_id, ln_cenvat_amount, 0, 0,
701: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,
702: fnd_global.user_id, fnd_global.login_id,
703: 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),
704: jai_constants.no
705: );
706:

Line 900: last_update_login = fnd_global.login_id,

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.
899: last_update_date = sysdate,
900: last_update_login = fnd_global.login_id,
901: last_updated_by = fnd_global.user_id
902: WHERE transaction_id = r_trx.tax_transaction_id;
903: END IF;
904:

Line 901: last_updated_by = fnd_global.user_id

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.
899: last_update_date = sysdate,
900: last_update_login = fnd_global.login_id,
901: last_updated_by = fnd_global.user_id
902: WHERE transaction_id = r_trx.tax_transaction_id;
903: END IF;
904:
905: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.. Following code is a replacement for removal of ja_in_create_rcv_57f4_trg trigger

Line 1206: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg

1202: IF lv_common_err_mesg IS NOT NULL THEN
1203: -- A common error occured. So, Whole Processing for Transaction should be stopped
1204: ROLLBACK TO start_deferred_claim;
1205: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||r_trx.transaction_id
1206: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
1207: );
1208: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
1209:
1210: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN

Line 1213: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

1209:
1210: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1211: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
1212: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1213: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1215: );
1216: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1217: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

Line 1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message

1210: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1211: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
1212: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1213: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1215: );
1216: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1217: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1218: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );

Line 1217: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

1213: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1215: );
1216: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1217: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1218: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );
1219: */
1220: ELSIF lv_process_flag IN ('E') THEN
1221: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);

Line 1218: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );

1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1215: );
1216: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1217: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1218: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );
1219: */
1220: ELSIF lv_process_flag IN ('E') THEN
1221: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
1222: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id

Line 1223: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message

1219: */
1220: ELSIF lv_process_flag IN ('E') THEN
1221: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
1222: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1223: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
1224: );
1225: /*dbms_output.put_line('*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1226: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );
1227: */

Line 1226: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );

1222: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1223: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
1224: );
1225: /*dbms_output.put_line('*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1226: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );
1227: */
1228: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1229: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
1230: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id

Line 1231: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

1227: */
1228: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1229: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
1230: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1231: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1232: );
1233: /*dbms_output.put_line('*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1234: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1235: );*/

Line 1234: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

1230: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1231: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1232: );
1233: /*dbms_output.put_line('*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1234: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1235: );*/
1236: END IF;
1237:
1238: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN

Line 1241: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

1237:
1238: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1239: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
1240: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id
1241: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1243: );
1244: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1245: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

Line 1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message

1238: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1239: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
1240: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id
1241: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1243: );
1244: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1245: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1246: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);

Line 1245: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

1241: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1243: );
1244: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1245: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1246: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);
1247: */
1248: ELSIF lv_process_flag IN ('X') THEN
1249: lv_codepath := jai_general_pkg.plot_codepath(16, lv_codepath);

Line 1246: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);

1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1243: );
1244: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1245: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1246: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);
1247: */
1248: ELSIF lv_process_flag IN ('X') THEN
1249: lv_codepath := jai_general_pkg.plot_codepath(16, lv_codepath);
1250: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

Line 1449: last_update_login = fnd_global.login_id,

1445: unclaim_cenvat_flag ='Y',
1446: unclaim_cenvat_date = trunc(sysdate),
1447: unclaimed_cenvat_amount = temp_rec.unclaimed_cenvat_amount,
1448: last_update_date = sysdate,
1449: last_update_login = fnd_global.login_id,
1450: last_updated_by = fnd_global.user_id
1451: WHERE transaction_id = temp_rec.transaction_id;
1452:
1453: /*Bug 8648138 - Unclaimed excise amount should be available for re-transfer to FA from AP, if the transfer

Line 1450: last_updated_by = fnd_global.user_id

1446: unclaim_cenvat_date = trunc(sysdate),
1447: unclaimed_cenvat_amount = temp_rec.unclaimed_cenvat_amount,
1448: last_update_date = sysdate,
1449: last_update_login = fnd_global.login_id,
1450: last_updated_by = fnd_global.user_id
1451: WHERE transaction_id = temp_rec.transaction_id;
1452:
1453: /*Bug 8648138 - Unclaimed excise amount should be available for re-transfer to FA from AP, if the transfer
1454: is done before unclaim*/

Line 1499: last_updated_by = fnd_global.user_id,

1495: -- By doing this future transactions will be taken care not to see Excise taxes as Recoverable
1496: UPDATE JAI_RCV_LINE_TAXES
1497: SET modvat_flag ='N',
1498: last_update_date = sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
1501: WHERE shipment_line_id = temp_rec.shipment_line_id
1502: AND upper(tax_type) IN ('EXCISE',
1503: 'ADDL. EXCISE',

Line 1500: last_update_login = fnd_global.login_id

1496: UPDATE JAI_RCV_LINE_TAXES
1497: SET modvat_flag ='N',
1498: last_update_date = sysdate,
1499: last_updated_by = fnd_global.user_id,
1500: last_update_login = fnd_global.login_id
1501: WHERE shipment_line_id = temp_rec.shipment_line_id
1502: AND upper(tax_type) IN ('EXCISE',
1503: 'ADDL. EXCISE',
1504: 'OTHER EXCISE',

Line 2194: last_update_login = fnd_global.login_id,

2190:
2191: UPDATE JAI_RCV_LINES a
2192: SET tax_modified_flag = 'N',
2193: last_update_date = SYSDATE,
2194: last_update_login = fnd_global.login_id,
2195: last_updated_by = fnd_global.user_id
2196: WHERE shipment_header_id = p_shipment_header_id
2197: AND tax_modified_flag IN ('Y', 'X')
2198: -- This condition will take not to update tax modified flag incase localization table is not populated

Line 2195: last_updated_by = fnd_global.user_id

2191: UPDATE JAI_RCV_LINES a
2192: SET tax_modified_flag = 'N',
2193: last_update_date = SYSDATE,
2194: last_update_login = fnd_global.login_id,
2195: last_updated_by = fnd_global.user_id
2196: WHERE shipment_header_id = p_shipment_header_id
2197: AND tax_modified_flag IN ('Y', 'X')
2198: -- This condition will take not to update tax modified flag incase localization table is not populated
2199: -- eg.Incase of Unordered Receipt, Until MATCH happens we should not update the tax_modified_flag to 'Y'

Line 2369: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg

2365: IF lv_common_err_mesg IS NOT NULL THEN
2366: -- A common error occured. So, Whole Processing for Transaction should be stopped
2367: ROLLBACK TO process_trxn;
2368: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||trx.transaction_id
2369: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2370: );
2371: retcode := 1;
2372: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2373: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id

Line 2374: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

2370: );
2371: retcode := 1;
2372: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2373: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id
2374: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2376: );
2377: ELSIF lv_process_flag IN ('E') THEN
2378: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id

Line 2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message

2371: retcode := 1;
2372: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2373: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id
2374: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2376: );
2377: ELSIF lv_process_flag IN ('E') THEN
2378: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message

Line 2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message

2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2376: );
2377: ELSIF lv_process_flag IN ('E') THEN
2378: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2380: );
2381: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2382: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id
2383: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

Line 2383: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2380: );
2381: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2382: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id
2383: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
2384: );
2385:
2386: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */
2387: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_trx_after_processing.process_vat_status <> jai_constants.successful THEN

Line 2390: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status

2386: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */
2387: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_trx_after_processing.process_vat_status <> jai_constants.successful THEN
2388: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) then
2389: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||trx.transaction_id
2390: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
2391: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
2392: );
2393: END IF;
2394:

Line 2398: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

2394:
2395: -- Start, 3927371
2396: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2397: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id
2398: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2399: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2400: );
2401: ELSIF lv_process_flag IN ('X') THEN
2402: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

Line 2399: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message

2395: -- Start, 3927371
2396: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2397: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id
2398: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2399: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2400: );
2401: ELSIF lv_process_flag IN ('X') THEN
2402: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2403: ELSIF lv_cenvat_rg_flag IN ('X') THEN

Line 2497: ln_user_id := fnd_global.user_id;

2493: ln_login_id NUMBER;
2494:
2495: BEGIN
2496:
2497: ln_user_id := fnd_global.user_id;
2498: ln_login_id := fnd_global.user_id;
2499:
2500: INSERT INTO jai_rcv_rtv_batch_grps(
2501: batch_group_id,

Line 2498: ln_login_id := fnd_global.user_id;

2494:
2495: BEGIN
2496:
2497: ln_user_id := fnd_global.user_id;
2498: ln_login_id := fnd_global.user_id;
2499:
2500: INSERT INTO jai_rcv_rtv_batch_grps(
2501: batch_group_id,
2502: batch_num, regime_code, organization_id, location_id,

Line 2806: last_updated_by = fnd_global.user_id

2802: set excise_invoice_no = lv_excise_invoice_no,
2803: excise_invoice_date = ld_excise_invoice_date,
2804: --attribute3 = pn_batch_num,
2805: last_update_date = sysdate,
2806: last_updated_by = fnd_global.user_id
2807: where current of c_rtv_trxs;
2808:
2809: lv_statement_id := '25';
2810: INSERT INTO JAI_RCV_RTV_DTLS(

Line 2817: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id

2813: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2814: ) VALUES (
2815: rtv_rec.transaction_id, rtv_rec.parent_transaction_id, rtv_rec.shipment_line_id,
2816: lv_excise_invoice_no, ld_excise_invoice_date, NULL,
2817: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
2818: );
2819:
2820: lv_excise_inv_gen_action := INV_GEN_STATUS_INV_GENERATED;
2821: else

Line 2834: last_updated_by = fnd_global.user_id

2830: set vat_invoice_no = lv_vat_invoice_no,
2831: vat_invoice_date = ld_vat_invoice_date,
2832: --attribute4 = pn_batch_num,
2833: last_update_date = sysdate,
2834: last_updated_by = fnd_global.user_id
2835: where current of c_rtv_trxs;
2836: lv_vat_inv_gen_action := INV_GEN_STATUS_INV_GENERATED;
2837: else
2838: lv_vat_inv_gen_action := rtv_rec.vat_invoice_action;

Line 2944: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg

2940:
2941: lv_statement_id := '29';
2942: IF lv_common_err_mesg IS NOT NULL THEN
2943: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||rtv_rec.transaction_id
2944: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2945: );
2946: lb_err_flag := true;
2947: goto end_of_trx;
2948: -- lv_err_mesg := lv_common_err_mesg;

Line 2951: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

2947: goto end_of_trx;
2948: -- lv_err_mesg := lv_common_err_mesg;
2949: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2950: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2951: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2952: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2953: );
2954: lb_err_flag := true;
2955: goto end_of_trx;

Line 2952: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message

2948: -- lv_err_mesg := lv_common_err_mesg;
2949: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2950: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2951: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2952: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2953: );
2954: lb_err_flag := true;
2955: goto end_of_trx;
2956: ELSIF lv_process_flag IN ('E') THEN

Line 2958: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message

2954: lb_err_flag := true;
2955: goto end_of_trx;
2956: ELSIF lv_process_flag IN ('E') THEN
2957: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2958: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2959: );
2960: lb_err_flag := true;
2961: goto end_of_trx;
2962: ELSIF lv_cenvat_rg_flag IN ('E') THEN

Line 2964: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

2960: lb_err_flag := true;
2961: goto end_of_trx;
2962: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2963: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||rtv_rec.transaction_id
2964: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
2965: );
2966: lb_err_flag := true;
2967: goto end_of_trx;
2968: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) THEN

Line 2970: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status

2966: lb_err_flag := true;
2967: goto end_of_trx;
2968: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) THEN
2969: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||rtv_rec.transaction_id
2970: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
2971: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
2972: );
2973: lb_err_flag := true;
2974: goto end_of_trx;

Line 2980: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

2976:
2977: lv_statement_id := '30';
2978: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2979: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id
2980: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2981: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2982: );
2983: ELSIF lv_process_flag IN ('X') THEN
2984: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

Line 2981: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message

2977: lv_statement_id := '30';
2978: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2979: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id
2980: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2981: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2982: );
2983: ELSIF lv_process_flag IN ('X') THEN
2984: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2985: ELSIF lv_cenvat_rg_flag IN ('X') THEN