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 503: ln_other_cenvat_amt, 0, sysdate, fnd_global.user_id, sysdate,

499: online_claim_flag,
500: vendor_changed_flag
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: );

Line 504: fnd_global.user_id, fnd_global.login_id,

500: vendor_changed_flag
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:

Line 698: last_update_login = fnd_global.login_id,

694: other_cenvat_amt = nvl(ln_cenvat_amount, other_cenvat_amt),
695: cenvat_claimed_ptg = nvl(ln_cenvat_claimed_ptg, 100),
696: cenvat_sequence = nvl(cenvat_sequence ,0) + 1, -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
697: last_update_date = sysdate,
698: last_update_login = fnd_global.login_id,
699: last_updated_by = fnd_global.user_id
700: WHERE transaction_id = r_trx.tax_transaction_id;
701: END IF;
702:

Line 699: last_updated_by = fnd_global.user_id

695: cenvat_claimed_ptg = nvl(ln_cenvat_claimed_ptg, 100),
696: cenvat_sequence = nvl(cenvat_sequence ,0) + 1, -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
697: last_update_date = sysdate,
698: last_update_login = fnd_global.login_id,
699: last_updated_by = fnd_global.user_id
700: WHERE transaction_id = r_trx.tax_transaction_id;
701: END IF;
702:
703: /* 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 730: --last_updated_by = fnd_global.user_id

726: UPDATE JAI_RCV_CENVAT_CLAIMS
727: SET non_bonded_delivery_flag = 'Y',
728: cenvat_claimed_ptg = 100
729: --last_update_date = sysdate,
730: --last_updated_by = fnd_global.user_id
731: WHERE transaction_id = p_transaction_id;
732: END IF;
733:
734: END IF;

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

973: IF lv_common_err_mesg IS NOT NULL THEN
974: -- A common error occured. So, Whole Processing for Transaction should be stopped
975: ROLLBACK TO start_deferred_claim;
976: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||r_trx.transaction_id
977: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
978: );
979: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
980:
981: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN

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

980:
981: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
982: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
983: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
984: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
985: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
986: );
987: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
988: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message

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

981: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
982: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
983: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
984: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
985: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
986: );
987: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
988: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
989: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );

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

984: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
985: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
986: );
987: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
988: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
989: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );
990: */
991: ELSIF lv_process_flag IN ('E') THEN
992: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);

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

985: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
986: );
987: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
988: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
989: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );
990: */
991: ELSIF lv_process_flag IN ('E') THEN
992: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
993: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id

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

990: */
991: ELSIF lv_process_flag IN ('E') THEN
992: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
993: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
994: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
995: );
996: /*dbms_output.put_line('*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
997: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );
998: */

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

993: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
994: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
995: );
996: /*dbms_output.put_line('*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
997: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );
998: */
999: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1000: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
1001: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id

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

998: */
999: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1000: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
1001: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1002: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1003: );
1004: /*dbms_output.put_line('*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1005: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1006: );*/

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

1001: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1002: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1003: );
1004: /*dbms_output.put_line('*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1005: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1006: );*/
1007: END IF;
1008:
1009: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN

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

1008:
1009: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1010: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
1011: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id
1012: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1013: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1014: );
1015: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1016: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message

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

1009: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1010: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
1011: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id
1012: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1013: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1014: );
1015: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1016: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1017: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);

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

1012: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1013: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1014: );
1015: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1016: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1017: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);
1018: */
1019: ELSIF lv_process_flag IN ('X') THEN
1020: lv_codepath := jai_general_pkg.plot_codepath(16, lv_codepath);

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

1013: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1014: );
1015: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id
1016: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1017: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);
1018: */
1019: ELSIF lv_process_flag IN ('X') THEN
1020: lv_codepath := jai_general_pkg.plot_codepath(16, lv_codepath);
1021: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

Line 1149: last_update_login = fnd_global.login_id,

1145: unclaim_cenvat_flag ='Y',
1146: unclaim_cenvat_date = trunc(sysdate),
1147: unclaimed_cenvat_amount = temp_rec.unclaimed_cenvat_amount,
1148: last_update_date = sysdate,
1149: last_update_login = fnd_global.login_id,
1150: last_updated_by = fnd_global.user_id
1151: WHERE transaction_id = temp_rec.transaction_id;
1152:
1153: -- By doing this future transactions will be taken care not to see Excise taxes as Recoverable

Line 1150: last_updated_by = fnd_global.user_id

1146: unclaim_cenvat_date = trunc(sysdate),
1147: unclaimed_cenvat_amount = temp_rec.unclaimed_cenvat_amount,
1148: last_update_date = sysdate,
1149: last_update_login = fnd_global.login_id,
1150: last_updated_by = fnd_global.user_id
1151: WHERE transaction_id = temp_rec.transaction_id;
1152:
1153: -- By doing this future transactions will be taken care not to see Excise taxes as Recoverable
1154: UPDATE JAI_RCV_LINE_TAXES

Line 1157: last_updated_by = fnd_global.user_id,

1153: -- By doing this future transactions will be taken care not to see Excise taxes as Recoverable
1154: UPDATE JAI_RCV_LINE_TAXES
1155: SET modvat_flag ='N',
1156: last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id
1159: WHERE shipment_line_id = temp_rec.shipment_line_id
1160: AND upper(tax_type) IN ('EXCISE',
1161: 'ADDL. EXCISE',

Line 1158: last_update_login = fnd_global.login_id

1154: UPDATE JAI_RCV_LINE_TAXES
1155: SET modvat_flag ='N',
1156: last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id
1159: WHERE shipment_line_id = temp_rec.shipment_line_id
1160: AND upper(tax_type) IN ('EXCISE',
1161: 'ADDL. EXCISE',
1162: 'OTHER EXCISE',

Line 1825: last_update_login = fnd_global.login_id,

1821:
1822: UPDATE JAI_RCV_LINES a
1823: SET tax_modified_flag = 'N',
1824: last_update_date = SYSDATE,
1825: last_update_login = fnd_global.login_id,
1826: last_updated_by = fnd_global.user_id
1827: WHERE shipment_header_id = p_shipment_header_id
1828: AND tax_modified_flag IN ('Y', 'X')
1829: -- This condition will take not to update tax modified flag incase localization table is not populated

Line 1826: last_updated_by = fnd_global.user_id

1822: UPDATE JAI_RCV_LINES a
1823: SET tax_modified_flag = 'N',
1824: last_update_date = SYSDATE,
1825: last_update_login = fnd_global.login_id,
1826: last_updated_by = fnd_global.user_id
1827: WHERE shipment_header_id = p_shipment_header_id
1828: AND tax_modified_flag IN ('Y', 'X')
1829: -- This condition will take not to update tax modified flag incase localization table is not populated
1830: -- eg.Incase of Unordered Receipt, Until MATCH happens we should not update the tax_modified_flag to 'Y'

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

1957: IF lv_common_err_mesg IS NOT NULL THEN
1958: -- A common error occured. So, Whole Processing for Transaction should be stopped
1959: ROLLBACK TO process_trxn;
1960: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||trx.transaction_id
1961: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
1962: );
1963: retcode := 1;
1964: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1965: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id

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

1962: );
1963: retcode := 1;
1964: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1965: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id
1966: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1967: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1968: );
1969: ELSIF lv_process_flag IN ('E') THEN
1970: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id

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

1963: retcode := 1;
1964: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1965: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id
1966: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1967: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1968: );
1969: ELSIF lv_process_flag IN ('E') THEN
1970: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
1971: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message

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

1967: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1968: );
1969: ELSIF lv_process_flag IN ('E') THEN
1970: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
1971: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
1972: );
1973: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1974: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id
1975: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

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

1971: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
1972: );
1973: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1974: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id
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

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

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: );
1985: END IF;
1986:

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

1986:
1987: -- Start, 3927371
1988: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1989: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id
1990: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1991: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1992: );
1993: ELSIF lv_process_flag IN ('X') THEN
1994: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

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

1987: -- Start, 3927371
1988: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1989: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id
1990: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1991: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1992: );
1993: ELSIF lv_process_flag IN ('X') THEN
1994: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
1995: ELSIF lv_cenvat_rg_flag IN ('X') THEN

Line 2089: ln_user_id := fnd_global.user_id;

2085: ln_login_id NUMBER;
2086:
2087: BEGIN
2088:
2089: ln_user_id := fnd_global.user_id;
2090: ln_login_id := fnd_global.user_id;
2091:
2092: INSERT INTO jai_rcv_rtv_batch_grps(
2093: batch_group_id,

Line 2090: ln_login_id := fnd_global.user_id;

2086:
2087: BEGIN
2088:
2089: ln_user_id := fnd_global.user_id;
2090: ln_login_id := fnd_global.user_id;
2091:
2092: INSERT INTO jai_rcv_rtv_batch_grps(
2093: batch_group_id,
2094: batch_num, regime_code, organization_id, location_id,

Line 2390: last_updated_by = fnd_global.user_id

2386: set excise_invoice_no = lv_excise_invoice_no,
2387: excise_invoice_date = ld_excise_invoice_date,
2388: --attribute3 = pn_batch_num,
2389: last_update_date = sysdate,
2390: last_updated_by = fnd_global.user_id
2391: where current of c_rtv_trxs;
2392:
2393: lv_statement_id := '25';
2394: INSERT INTO JAI_RCV_RTV_DTLS(

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

2397: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2398: ) VALUES (
2399: rtv_rec.transaction_id, rtv_rec.parent_transaction_id, rtv_rec.shipment_line_id,
2400: lv_excise_invoice_no, ld_excise_invoice_date, NULL,
2401: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.login_id
2402: );
2403:
2404: lv_excise_inv_gen_action := INV_GEN_STATUS_INV_GENERATED;
2405: else

Line 2418: last_updated_by = fnd_global.user_id

2414: set vat_invoice_no = lv_vat_invoice_no,
2415: vat_invoice_date = ld_vat_invoice_date,
2416: --attribute4 = pn_batch_num,
2417: last_update_date = sysdate,
2418: last_updated_by = fnd_global.user_id
2419: where current of c_rtv_trxs;
2420: lv_vat_inv_gen_action := INV_GEN_STATUS_INV_GENERATED;
2421: else
2422: lv_vat_inv_gen_action := rtv_rec.vat_invoice_action;

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

2522:
2523: lv_statement_id := '29';
2524: IF lv_common_err_mesg IS NOT NULL THEN
2525: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||rtv_rec.transaction_id
2526: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2527: );
2528: lb_err_flag := true;
2529: goto end_of_trx;
2530: -- lv_err_mesg := lv_common_err_mesg;

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

2529: goto end_of_trx;
2530: -- lv_err_mesg := lv_common_err_mesg;
2531: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2532: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2533: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2534: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2535: );
2536: lb_err_flag := true;
2537: goto end_of_trx;

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

2530: -- lv_err_mesg := lv_common_err_mesg;
2531: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2532: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2533: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2534: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2535: );
2536: lb_err_flag := true;
2537: goto end_of_trx;
2538: ELSIF lv_process_flag IN ('E') THEN

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

2536: lb_err_flag := true;
2537: goto end_of_trx;
2538: ELSIF lv_process_flag IN ('E') THEN
2539: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2540: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2541: );
2542: lb_err_flag := true;
2543: goto end_of_trx;
2544: ELSIF lv_cenvat_rg_flag IN ('E') THEN

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

2542: lb_err_flag := true;
2543: goto end_of_trx;
2544: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2545: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||rtv_rec.transaction_id
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

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

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: );
2555: lb_err_flag := true;
2556: goto end_of_trx;

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

2558:
2559: lv_statement_id := '30';
2560: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2561: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id
2562: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2563: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2564: );
2565: ELSIF lv_process_flag IN ('X') THEN
2566: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

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

2559: lv_statement_id := '30';
2560: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2561: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id
2562: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2563: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2564: );
2565: ELSIF lv_process_flag IN ('X') THEN
2566: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2567: ELSIF lv_cenvat_rg_flag IN ('X') THEN