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_FILE

Line 671: FND_FILE.put_line(FND_FILE.log, '^Trx Post Processor');

667:
668: BEGIN
669:
670:
671: FND_FILE.put_line(FND_FILE.log, '^Trx Post Processor');
672:
673: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'receipt_transactions_pkg.trx_post_proc', 'START');
674:
675: OPEN c_trx(p_transaction_id);

Line 788: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );

784: OPEN c_check_57F4_for_po;
785: FETCH c_check_57F4_for_po INTO ln_line_id;
786: IF c_check_57F4_for_po%NOTFOUND THEN
787: ln_ret_value := 'NO';
788: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );
789: ELSE
790: ln_ret_value := 'YES';
791: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );
792: END IF ;

Line 791: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );

787: ln_ret_value := 'NO';
788: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );
789: ELSE
790: ln_ret_value := 'YES';
791: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );
792: END IF ;
793: CLOSE c_check_57F4_for_po;
794: RETURN ln_ret_value;
795: END check_57f4_transaction;

Line 894: FND_FILE.put_line(FND_FILE.log, 'trx_id:'||temp_rec.transaction_id||', flag:'||temp_rec.process_flag);

890:
891: SAVEPOINT start_deferred_claim;
892:
893: IF lb_debug THEN
894: FND_FILE.put_line(FND_FILE.log, 'trx_id:'||temp_rec.transaction_id||', flag:'||temp_rec.process_flag);
895: END IF;
896:
897: IF temp_rec.process_flag = 'M' THEN
898:

Line 976: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||r_trx.transaction_id

972: -- flag value 'X' is removed from the following ELSIF conditions because it is not an ERROR Status. MYXZ
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:

Line 983: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * Transaction_id:'||r_trx.transaction_id

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

Line 993: FND_FILE.put_line(FND_FILE.log, '* PROCESS ERROR * Transaction_id:'||r_trx.transaction_id

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
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 );

Line 1001: FND_FILE.put_line(FND_FILE.log, '* CENVAT 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
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

Line 1011: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id

1007: END IF;
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

Line 1021: FND_FILE.put_line(FND_FILE.log, 'Process Message(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);
1022: /*dbms_output.put_line('M: Err4:'||lv_process_message);*/
1023: ELSIF lv_cenvat_rg_flag IN ('X') THEN
1024: lv_codepath := jai_general_pkg.plot_codepath(17, lv_codepath);
1025: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

Line 1025: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

1021: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
1022: /*dbms_output.put_line('M: Err4:'||lv_process_message);*/
1023: ELSIF lv_cenvat_rg_flag IN ('X') THEN
1024: lv_codepath := jai_general_pkg.plot_codepath(17, lv_codepath);
1025: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
1026: /*dbms_output.put_line('M: Err3:'||lv_cenvat_rg_message);*/
1027: END IF;
1028:
1029: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN

Line 1033: fnd_file.put_line(fnd_file.log, 'M: Err5:'||p_process_message);

1029: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN
1030: lv_codepath := jai_general_pkg.plot_codepath(18, lv_codepath);
1031: p_process_flag := lv_cenvat_rg_flag;
1032: p_process_message := lv_cenvat_rg_message;
1033: fnd_file.put_line(fnd_file.log, 'M: Err5:'||p_process_message);
1034: END IF;
1035:
1036: -- UNCLAIM PROCESSING
1037: -- following Unclaim Processing will not happen for

Line 1096: FND_FILE.put_line(FND_FILE.log, 'Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');

1092: );
1093:
1094: IF p_process_flag IN ('E', 'X') THEN
1095: lv_codepath := jai_general_pkg.plot_codepath(23, lv_codepath);
1096: FND_FILE.put_line(FND_FILE.log, 'Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');
1097: /*dbms_output.put_line('Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');*/
1098: --p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
1099: ROLLBACK TO start_unclaim;
1100: -- following is to take care that if one transaction of RECEIVE childs fail, then loop should not

Line 1107: FND_FILE.put_line(FND_FILE.log, 'Unclaim#PRC_FLG#'||p_process_flag);

1103: ElSIF p_process_flag = 'Y' THEN
1104: --p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
1105: p_process_message := 'Successful';
1106: ELSE
1107: FND_FILE.put_line(FND_FILE.log, 'Unclaim#PRC_FLG#'||p_process_flag);
1108: --p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
1109: /*dbms_output.put_line('Unclaim#PRC_FLG#'||p_process_flag);*/
1110: END IF;
1111:

Line 1205: fnd_file.put_line(fnd_file.log, 'Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);

1201:
1202: END IF;
1203:
1204: lv_codepath := jai_general_pkg.plot_codepath(30, lv_codepath);
1205: fnd_file.put_line(fnd_file.log, 'Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);
1206: /*dbms_output.put_line('Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);*/
1207:
1208: END LOOP;
1209:

Line 1213: fnd_file.put_line(fnd_file.log, 'DeferredClaimError Cnt>0:'||p_process_message);

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:
1216: EXCEPTION
1217: WHEN OTHERS THEN

Line 1220: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);

1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: ROLLBACK TO start_deferred_claim;
1219: p_process_flag := 'E';
1220: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);
1221: p_process_message := 'Processed Count:'||ln_processed_cnt||', Errored Cnt:'||ln_errored_cnt||'. Error Message:'||SQLERRM;
1222: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);
1223: END process_deferred_cenvat_claim;
1224:

Line 1222: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);

1218: ROLLBACK TO start_deferred_claim;
1219: p_process_flag := 'E';
1220: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);
1221: p_process_message := 'Processed Count:'||ln_processed_cnt||', Errored Cnt:'||ln_errored_cnt||'. Error Message:'||SQLERRM;
1222: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);
1223: END process_deferred_cenvat_claim;
1224:
1225:
1226: /*============================== MAIN PROCEDURE ==============================*/

Line 1691: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

1687: dev_status => lv_dev_status,
1688: message => lv_message) ;
1689:
1690: IF not ln_req_status THEN
1691: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
1692: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
1693: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');
1694: RETURN ;
1695: END IF ;

Line 1693: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');

1689:
1690: IF not ln_req_status THEN
1691: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
1692: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
1693: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');
1694: RETURN ;
1695: END IF ;
1696: END IF ;
1697:

Line 1700: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

1696: END IF ;
1697:
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
1701: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
1702: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');
1703: RETURN ;
1704: END;

Line 1702: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');

1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
1701: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
1702: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');
1703: RETURN ;
1704: END;
1705:
1706:

Line 1728: FND_FILE.put_line(FND_FILE.log, SQLERRM) ;

1724: END LOOP ;
1725: END IF ;
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: FND_FILE.put_line(FND_FILE.log, SQLERRM) ;
1729: RETURN ;
1730: END;
1731:
1732: --ended, CSahoo for Bug 5344225

Line 1734: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );

1730: END;
1731:
1732: --ended, CSahoo for Bug 5344225
1733:
1734: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );
1735:
1736: lv_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
1737: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)
1738: ||', TrxFrom->'||nvl(p_transaction_from, to_date('1-01-1700', 'dd-mm-yyyy'))

Line 1737: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)

1733:
1734: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );
1735:
1736: lv_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
1737: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)
1738: ||', TrxFrom->'||nvl(p_transaction_from, to_date('1-01-1700', 'dd-mm-yyyy'))
1739: ||', Trxto->'||nvl(p_transaction_to, to_date('1-01-1700', 'dd-mm-yyyy'))
1740: ||', TrxType->'||nvl(p_transaction_type, 'XXX')
1741: ||', RecptNum->'||nvl(p_receipt_num, 'ABCD')

Line 1764: FND_FILE.put_line(FND_FILE.log, 'TraceFile Name = '||lower(lv_dbname)||'_ora_'||lv_spid||'.trc');

1760: OPEN c_get_dbname;
1761: FETCH c_get_dbname INTO lv_dbname;
1762: CLOSE c_get_dbname;
1763:
1764: FND_FILE.put_line(FND_FILE.log, 'TraceFile Name = '||lower(lv_dbname)||'_ora_'||lv_spid||'.trc');
1765:
1766: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
1767:
1768: END IF;

Line 1771: FND_FILE.put_line(FND_FILE.log, '%%%Problem in Trace Generation%%%');

1767:
1768: END IF;
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: FND_FILE.put_line(FND_FILE.log, '%%%Problem in Trace Generation%%%');
1772: END;
1773:
1774: /*----------------------------- START of Business Logic ----------------------*/
1775:

Line 1784: FND_FILE.put_line( FND_FILE.log, '~ Start of Deferred Claim ~. Batch:'||ln_batch_id);

1780:
1781: -- value contained in p_shipment_header_id when called from JAINMVAT is batch_id of Claim/Unclaim
1782: ln_batch_id := p_shipment_header_id;
1783:
1784: FND_FILE.put_line( FND_FILE.log, '~~~~~ Start of Deferred Claim ~~~~~. Batch:'||ln_batch_id);
1785: process_deferred_cenvat_claim(
1786: p_batch_id => ln_batch_id,
1787: p_called_from => p_called_from,
1788: p_simulate_flag => p_simulate_flag,

Line 1793: FND_FILE.put_line( FND_FILE.log, '~ End of Deferred Claim ~');

1789: p_process_flag => lv_process_flag,
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;

Line 1795: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err 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;
1799:

Line 1796: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);

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;
1799:
1800: GOTO end_of_batch;

Line 1807: FND_file.put_line(fnd_file.log, 'Error Message:'||SQLERRM);

1803:
1804: EXCEPTION
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;

Line 1817: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);

1813:
1814: -- Start, Vijay Shankar for Bug#3940588
1815: -- Following has to be executed as and when it is submitted from Receipts Localization form
1816: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
1817: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
1818:
1819: IF p_called_from = 'JAINPORE' THEN
1820: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
1821:

Line 1820: FND_FILE.put_line( FND_FILE.log, '~ Updating JAI_RCV_LINES.tax_modified_flag to N ~');

1816: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
1817: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
1818:
1819: IF p_called_from = 'JAINPORE' THEN
1820: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
1821:
1822: UPDATE JAI_RCV_LINES a
1823: SET tax_modified_flag = 'N',
1824: last_update_date = SYSDATE,

Line 1841: FND_FILE.put_line( FND_FILE.log, '~ Start Populate Details ~');

1837: END IF;
1838: -- End, Vijay Shankar for Bug#3940588
1839:
1840:
1841: FND_FILE.put_line( FND_FILE.log, '~~~~~ Start Populate Details ~~~~~');
1842: -- populate_details should be called only once and that too when the trxn is processed for the first time
1843:
1844: ja_in_populate_details ; -- added by Sanjikum for bug#4929410
1845:

Line 1852: FND_FILE.put_line( FND_FILE.log, 'Recpt:'||trx.receipt_num||', TrxId:'||trx.transaction_id);

1848: FOR trx IN (SELECT * FROM JAI_RTP_POPULATE_T ORDER BY receipt_num, transaction_id) LOOP
1849: -- SAVEPOINT start_trx_population;
1850: lv_codepath := '';
1851:
1852: FND_FILE.put_line( FND_FILE.log, 'Recpt:'||trx.receipt_num||', TrxId:'||trx.transaction_id);
1853: populate_details(
1854: p_transaction_id => trx.transaction_id,
1855: p_process_status => lv_process_flag,
1856: p_process_message => lv_process_message,

Line 1887: FND_FILE.put_line( FND_FILE.log, '* POPULATE_DETAILS Error *:'||lv_process_message);

1883:
1884: -- IF UPPER(p_called_from) <> 'APPLICATION' THEN
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

Line 1910: FND_FILE.put_line(FND_FILE.log, '+++ Start of ReceiptNo, Transaction_id:'||trx.receipt_num||','||trx.transaction_id

1906: lv_common_err_mesg := null;
1907: lv_codepath := '';
1908: r_trx_after_processing := null;
1909:
1910: FND_FILE.put_line(FND_FILE.log, '+++ Start of ReceiptNo, Transaction_id:'||trx.receipt_num||','||trx.transaction_id
1911: ||', trxn_type:'||trx.transaction_type
1912: ||', parent_trxn_type:'||trx.parent_transaction_type
1913: ||', process_status:'||trx.process_flag
1914: ||', cenvat_rg_status:'||trx.cenvat_rg_flag

Line 1960: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||trx.transaction_id

1956: -- 'X' flag is removed from the following ELSIF conditions because it is not an ERROR Status. MYXZ
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

Line 1965: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * 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
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

Line 1970: FND_FILE.put_line(FND_FILE.log, '* PROCESS 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
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

Line 1974: FND_FILE.put_line(FND_FILE.log, '* CENVAT ERROR * Transaction_id:'||trx.transaction_id

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
1976: );
1977:
1978: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */

Line 1981: FND_FILE.put_line(FND_FILE.log, '* VAT Message * Transaction_id:'||trx.transaction_id

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

Line 1989: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id

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

Line 1994: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

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
1996: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
1997: END IF;
1998:

Line 1996: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(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
1996: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
1997: END IF;
1998:
1999: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN
2000: retcode := 1;

Line 2018: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);

2014: -- End, Vijay Shankar for Bug#3940588
2015:
2016: if lv_process_flag = 'E' then
2017: ROLLBACK TO process_trxn;
2018: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);
2019: end if;
2020:
2021: IF p_simulate_flag = 'Y' THEN
2022: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);

Line 2022: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);

2018: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);
2019: end if;
2020:
2021: IF p_simulate_flag = 'Y' THEN
2022: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);
2023: ELSE
2024: UPDATE JAI_RCV_TRANSACTIONS
2025: SET codepath = lv_codepath
2026: --WHERE rowid = trx.row_id

Line 2048: FND_FILE.put_line( FND_FILE.log, 'Rolled Back Processing in RECEIPT_TRANSACTIONS_PKG.process_batch: Error->'||SQLERRM);

2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: ROLLBACK TO process_trxn;
2048: FND_FILE.put_line( FND_FILE.log, 'Rolled Back Processing in RECEIPT_TRANSACTIONS_PKG.process_batch: Error->'||SQLERRM);
2049: retcode := 1;
2050: END;
2051:
2052: END LOOP;

Line 2065: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);

2061: /* added by Vijay Shankar for Bug#3940588 */
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: ROLLBACK;
2065: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);
2066: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
2067: RAISE;
2068: END process_batch;
2069:

Line 2066: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);

2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: ROLLBACK;
2065: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);
2066: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
2067: RAISE;
2068: END process_batch;
2069:
2070: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */

Line 2195: fnd_file.put_line(fnd_file.log, 'Input Params. pn_batch_num:'||pn_batch_num

2191: begin
2192:
2193: lv_statement_id := '0';
2194: if lb_debug then
2195: fnd_file.put_line(fnd_file.log, 'Input Params. pn_batch_num:'||pn_batch_num
2196: ||', pn_min_transaction_id:'||pn_min_transaction_id
2197: ||', pn_max_transaction_id:'||pn_max_transaction_id
2198: ||', pv_called_from:'||pv_called_from
2199: ||', pv_commit_switch:'||pv_commit_switch

Line 2257: fnd_file.put_line(fnd_file.log, '~~~ ReceiptNum:'||rtv_rec.receipt_num||', TrxId:'||rtv_rec.transaction_id

2253: end if;
2254:
2255: lv_statement_id := '5.1';
2256: if lb_debug then
2257: fnd_file.put_line(fnd_file.log, '~~~ ReceiptNum:'||rtv_rec.receipt_num||', TrxId:'||rtv_rec.transaction_id
2258: ||', SameFlg:'||lv_same_invoice_no_flag
2259: ||', ExBatch:'||rtv_rec.excise_batch_num ||', VatBatch:'||rtv_rec.vat_batch_num
2260: ||', ExAct:'||rtv_rec.excise_invoice_action ||', VatAct:'||rtv_rec.vat_invoice_action
2261: );

Line 2350: fnd_file.put_line(fnd_file.log, 'VAT Inv Gen Error. Params- RgmId:'||ln_regime_id

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
2354: ||', ErrMsg:'||lv_process_message);

Line 2353: fnd_file.put_line(fnd_file.log, 'ErrorCode:'||lv_process_flag

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
2354: ||', ErrMsg:'||lv_process_message);
2355: raise_application_error( -20112, 'VAT Inv Gen Error. Code:'||lv_process_flag
2356: ||', MSG:'||lv_process_message);
2357: end if;

Line 2375: fnd_file.put_line(fnd_file.log, '~~~ ExInvNo:'||lv_excise_invoicE_no ||', ld_excise_invoice_Date:'||ld_excise_invoice_date

2371: /* End. VAT Inv. Gen. */
2372:
2373: lv_statement_id := '23.1';
2374: if lb_debug then
2375: fnd_file.put_line(fnd_file.log, '~~~ ExInvNo:'||lv_excise_invoicE_no ||', ld_excise_invoice_Date:'||ld_excise_invoice_date
2376: ||', VatInvNo:'||lv_vat_invoice_no ||', ld_vat_invoice_Date:'||ld_vat_invoice_date
2377: );
2378: end if;
2379:

Line 2525: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||rtv_rec.transaction_id

2521: CLOSE c_trx;
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;

Line 2532: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * Transaction_id:'||rtv_rec.transaction_id

2528: lb_err_flag := true;
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;

Line 2539: FND_FILE.put_line(FND_FILE.log, '* PROCESS ERROR * Transaction_id:'||rtv_rec.transaction_id

2535: );
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;

Line 2545: FND_FILE.put_line(FND_FILE.log, '* CENVAT ERROR * Transaction_id:'||rtv_rec.transaction_id

2541: );
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;

Line 2551: FND_FILE.put_line(FND_FILE.log, '* VAT Message * Transaction_id:'||rtv_rec.transaction_id

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

Line 2561: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id

2557: END IF;
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

Line 2566: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

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
2568: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2569: END IF;
2570:

Line 2568: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(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
2568: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2569: END IF;
2570:
2571: lv_statement_id := '31';
2572: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN

Line 2614: FND_FILE.put_line(FND_FILE.log, 'Error in Call to jai_po_osp_pkg.create_rcv_57f4. Mesg:'||lv_process_message);

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;
2618: end if;

Line 2628: fnd_file.put_line( fnd_file.log, 'ErrCodepath:'||lv_codepath);

2624: WHERE current of c_rtv_trxs;
2625:
2626: <>
2627: if lb_err_flag then
2628: fnd_file.put_line( fnd_file.log, 'ErrCodepath:'||lv_codepath);
2629: raise_application_error( -20012, 'Error during RTV Processing. Look at the log for details');
2630: end if;
2631:
2632: ln_processed_cnt := ln_processed_cnt + 1;

Line 2647: FND_FILE.put_line( FND_FILE.log, pv_errbuf);

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;
2650:
2651:

Line 2648: -- FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);

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;
2650:
2651:
2652: PROCEDURE process_transaction(

Line 2707: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')

2703:
2704: -- this is to identify the path in SQL TRACE file if any problem occured
2705: SELECT to_char(sysdate,'dd/mm/yyyy hh24:mi:ss')||'-jirt_pkg.process_transaction-'||p_transaction_id INTO lv_temp FROM DUAL;
2706:
2707: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')
2708: ||', PrcSpecialReason:'||p_process_special_reason||', PrcSplQty:'||p_process_special_qty
2709: );
2710:
2711: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'receipt_transactions_pkg.process_transaction', 'START');

Line 2764: FND_FILE.put_line(FND_FILE.log, lv_object_code||'Localization doesnot support this transaction type');

2760:
2761: -- "MATCH" included by Vijay Shankar for Bug#3940588
2762: IF lv_transaction_type NOT IN ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'MATCH' ) THEN
2763: -- Localization donot support these transactions. So, Pls return back
2764: FND_FILE.put_line(FND_FILE.log, lv_object_code||'Localization doesnot support this transaction type');
2765: RETURN;
2766: END IF;
2767:
2768: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);

Line 2808: FND_FILE.put_line( FND_FILE.log, '1 No Codepath ');

2804: p_process_message => p_process_message
2805: );
2806:
2807: ELSE
2808: FND_FILE.put_line( FND_FILE.log, '1****** No Codepath ******');
2809: END IF;
2810:
2811: lv_execution_point := 'END_PROCESS_FLAG';
2812:

Line 2815: FND_FILE.put_line(FND_FILE.log, 'PRC_FLG_Error: RollingBack to process_trxn_flag');

2811: lv_execution_point := 'END_PROCESS_FLAG';
2812:
2813: lv_statement_id := '6';
2814: IF p_process_flag IN ('E', 'X') THEN
2815: FND_FILE.put_line(FND_FILE.log, 'PRC_FLG_Error: RollingBack to process_trxn_flag');
2816: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
2817: ROLLBACK TO process_trxn_flag;
2818: ElSIF p_process_flag = 'Y' THEN
2819: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);

Line 2822: FND_FILE.put_line(FND_FILE.log, '1#PRC_FLG#'||p_process_flag);

2818: ElSIF p_process_flag = 'Y' THEN
2819: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
2820: p_process_message := 'Successful';
2821: ELSE
2822: FND_FILE.put_line(FND_FILE.log, '1#PRC_FLG#'||p_process_flag);
2823: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
2824: END IF;
2825:
2826: END IF;

Line 2828: FND_FILE.put_line(FND_FILE.log, '2#PRC_FLG#'||p_process_flag);

2824: END IF;
2825:
2826: END IF;
2827:
2828: FND_FILE.put_line(FND_FILE.log, '2#PRC_FLG#'||p_process_flag);
2829: ------------ End of PROCESS_FLAG Execution ----------
2830:
2831: lv_statement_id := '7';
2832: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;

Line 2833: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);

2829: ------------ End of PROCESS_FLAG Execution ----------
2830:
2831: lv_statement_id := '7';
2832: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;
2833: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);
2834: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);
2835:
2836: /*bgowrava for forward porting Bug#5756676..start*/
2837: IF lv_online_qty_flag = 'Y' THEN

Line 2834: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);

2830:
2831: lv_statement_id := '7';
2832: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;
2833: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);
2834: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);
2835:
2836: /*bgowrava for forward porting Bug#5756676..start*/
2837: IF lv_online_qty_flag = 'Y' THEN
2838:

Line 2843: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg_i_entry');

2839: SAVEPOINT process_online_qty;
2840:
2841: IF r_base_trx.attr_cat = 'India RMA Receipt' AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX') THEN
2842:
2843: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg_i_entry');
2844:
2845: /*bug 7662347*/
2846: IF lv_transaction_type = 'RETURN TO VENDOR' THEN
2847: lv_qty_register_entry_type := 'Dr';

Line 2863: FND_FILE.put_line(FND_FILE.log, 'ln_part_i_register_id:'||ln_part_i_register_id);

2859: p_simulate_flag => p_simulate_flag,
2860: p_codepath => p_codepath
2861: );
2862:
2863: FND_FILE.put_line(FND_FILE.log, 'ln_part_i_register_id:'||ln_part_i_register_id);
2864:
2865: ELSIF r_trx.item_class IN ('RMIN', 'RMEX', 'CCIN', 'CCEX', 'CGIN', 'CGEX') THEN
2866:
2867: lv_register_type := jai_general_pkg.get_rg_register_type( p_item_class => r_trx.item_class);

Line 2869: FND_FILE.put_line(FND_FILE.log, 'Register Type:'||lv_register_type);

2865: ELSIF r_trx.item_class IN ('RMIN', 'RMEX', 'CCIN', 'CCEX', 'CGIN', 'CGEX') THEN
2866:
2867: lv_register_type := jai_general_pkg.get_rg_register_type( p_item_class => r_trx.item_class);
2868:
2869: FND_FILE.put_line(FND_FILE.log, 'Register Type:'||lv_register_type);
2870:
2871: -- to determine the way in which CGIN Items are Processed
2872: IF lv_register_type = 'C' THEN
2873: jai_rcv_excise_processing_pkg.derive_cgin_scenario(

Line 2881: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);

2877: p_process_message => lv_process_message,
2878: p_codepath => p_codepath
2879: );
2880:
2881: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);
2882: END IF;
2883: -- RG23 Part I Entry is already made during first Claim, in case of CGIN Items
2884: -- So no need of another entry during Second 50% Claim of CENVAT
2885: IF nvl(lv_cgin_code, 'XXX') <> 'REGULAR-HALF' THEN

Line 2887: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg23_part_i_entry');

2883: -- RG23 Part I Entry is already made during first Claim, in case of CGIN Items
2884: -- So no need of another entry during Second 50% Claim of CENVAT
2885: IF nvl(lv_cgin_code, 'XXX') <> 'REGULAR-HALF' THEN
2886:
2887: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg23_part_i_entry');
2888:
2889: /*bug 7662347*/
2890: IF lv_transaction_type = 'RETURN TO VENDOR' THEN
2891: lv_qty_register_entry_type := 'Dr';

Line 2910: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');

2906:
2907: --lv_qty_register := 'RG23';
2908:
2909: ELSE
2910: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');
2911: END IF;
2912:
2913: END IF;
2914:

Line 2962: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Transaction type Not supported for cenvat Entries');

2958: p_process_special_qty => p_process_special_qty
2959: );
2960:
2961: ELSE
2962: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Transaction type Not supported for cenvat Entries');
2963: END IF;
2964:
2965: lv_execution_point := 'END_CENVAT_FLAG';
2966:

Line 2969: FND_FILE.put_line(FND_FILE.log, 'CEN_FLG_Error: RollingBack to process_cenvat_rg_flag');

2965: lv_execution_point := 'END_CENVAT_FLAG';
2966:
2967: lv_statement_id := '9';
2968: IF p_cenvat_rg_flag IN ('E', 'X') THEN
2969: FND_FILE.put_line(FND_FILE.log, 'CEN_FLG_Error: RollingBack to process_cenvat_rg_flag');
2970: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
2971: ROLLBACK TO process_cenvat_rg_flag;
2972: ElSIF p_cenvat_rg_flag = 'Y' THEN
2973: p_cenvat_rg_message := 'Successful';

Line 2976: FND_FILE.put_line(FND_FILE.log, '1#CENVAT_FLG#'||p_cenvat_rg_flag);

2972: ElSIF p_cenvat_rg_flag = 'Y' THEN
2973: p_cenvat_rg_message := 'Successful';
2974: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
2975: ELSE
2976: FND_FILE.put_line(FND_FILE.log, '1#CENVAT_FLG#'||p_cenvat_rg_flag);
2977: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath);
2978: END IF;
2979:
2980: END IF;

Line 2982: FND_FILE.put_line(FND_FILE.log, '2#CENVAT_FLG#'||p_cenvat_rg_flag);

2978: END IF;
2979:
2980: END IF;
2981:
2982: FND_FILE.put_line(FND_FILE.log, '2#CENVAT_FLG#'||p_cenvat_rg_flag);
2983: /* End of CENVAT_RG_FLAG Execution */
2984:
2985: lv_statement_id := '10';
2986: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath);

Line 3015: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Trxn not supported for VAT processing');

3011: p_process_message => lv_process_vat_message
3012: );
3013:
3014: ELSE
3015: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Trxn not supported for VAT processing');
3016: END IF;
3017:
3018: lv_execution_point := 'END_PROCESS_VAT';
3019:

Line 3025: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);

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
3029: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);

Line 3029: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);

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
3029: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);
3030: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
3031: END IF;
3032:
3033: END IF;

Line 3035: FND_FILE.put_line(FND_FILE.log, '2#PrcVatFlg#'||lv_process_vat_flag);

3031: END IF;
3032:
3033: END IF;
3034:
3035: FND_FILE.put_line(FND_FILE.log, '2#PrcVatFlg#'||lv_process_vat_flag);
3036: /* End of VAT Execution */
3037:
3038: lv_statement_id := '14';
3039: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath);

Line 3060: FND_FILE.put_line(FND_FILE.log, '$End of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss'));

3056:
3057: END IF;
3058: <>
3059:
3060: FND_FILE.put_line(FND_FILE.log, '$End of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss'));
3061:
3062: p_codepath := jai_general_pkg.plot_codepath(99, p_codepath, null, 'END');
3063:
3064: EXCEPTION

Line 3067: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_common_err_mesg);

3063:
3064: EXCEPTION
3065: WHEN OTHERS THEN
3066: p_common_err_mesg := 'RECEIPT_TRANSACTIONS_PKG.process_transaction(StmtId:'||lv_statement_id||'). Error:'||SQLERRM;
3067: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_common_err_mesg);
3068: IF p_process_flag <> 'Y' THEN
3069: p_process_flag := 'E';
3070: p_process_message := p_common_err_mesg;
3071: ELSIF p_cenvat_rg_flag <> 'Y' THEN

Line 3221: FND_FILE.put_line(FND_FILE.log, '^ POPULATE_DETAILS');

3217:
3218: BEGIN
3219:
3220: IF lb_debug THEN
3221: FND_FILE.put_line(FND_FILE.log, '^ POPULATE_DETAILS');
3222: END IF;
3223:
3224: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'populate_details', 'START');
3225:

Line 3472: FND_FILE.put_line(FND_FILE.log, '... RecNum:'||r_shp_hdr_dtls.receipt_num ||',p_cenvat_amount:'||ln_cenvat_amount );

3468: END IF;
3469: -- End, added by Vijay Shankar for Bug#3940588
3470:
3471: IF lb_debug THEN
3472: FND_FILE.put_line(FND_FILE.log, '... RecNum:'||r_shp_hdr_dtls.receipt_num ||',p_cenvat_amount:'||ln_cenvat_amount );
3473: END IF;
3474:
3475: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
3476: jai_rcv_transactions_pkg.update_row(

Line 3522: FND_FILE.put_line(FND_FILE.log, '$ POPULATE_DETAILS');

3518:
3519: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath, 'populate_details', 'END');
3520:
3521: IF lb_debug THEN
3522: FND_FILE.put_line(FND_FILE.log, '$ POPULATE_DETAILS');
3523: END IF;
3524:
3525: /* Added by Ramananda for bug#4407165 */
3526: EXCEPTION

Line 3715: FND_FILE.put_line(FND_FILE.log, '^VALIDATE_TRANSACTION. Prc_Flag->'||p_process_flag||', Cen_Flag->'||p_cenvat_rg_flag);

3711: lv_codepath := '';
3712:
3713: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'cenvat_rg_pkg.validate_trx', 'START');
3714: IF lb_debug THEN
3715: FND_FILE.put_line(FND_FILE.log, '^VALIDATE_TRANSACTION. Prc_Flag->'||p_process_flag||', Cen_Flag->'||p_cenvat_rg_flag);
3716: END IF;
3717:
3718: IF p_process_flag IS NULL THEN
3719: p_process_message := NULL;

Line 3766: --FND_FILE.put_line(fnd_file.log, 'Shp_lineId:'||r_trx.shipment_line_id||', Cnt:'||SQL%ROWCOUNT

3762: OPEN c_receipt_line_dtls(r_trx.shipment_line_id);
3763: FETCH c_receipt_line_dtls into r_receipt_line;
3764: CLOSE c_receipt_line_dtls;
3765:
3766: --FND_FILE.put_line(fnd_file.log, 'Shp_lineId:'||r_trx.shipment_line_id||', Cnt:'||SQL%ROWCOUNT
3767: -- ||', Cnt:'||SQL%ROWCOUNT||', exNo:'||r_receipt_line.excise_invoice_no);
3768:
3769: lv_statement_id := '4';
3770: /* Fetch the Tax count */

Line 3804: FND_file.put_line( fnd_file.log, 'Quantity Update Event:'||lv_qty_upd_event);

3800: FETCH cur_qty_setup INTO lv_qty_upd_event;
3801: END IF;
3802: CLOSE cur_qty_setup;
3803:
3804: FND_file.put_line( fnd_file.log, 'Quantity Update Event:'||lv_qty_upd_event);
3805:
3806: OPEN cur_item_excise_flag(r_trx.organization_id,r_trx.inventory_item_id );
3807: FETCH cur_item_excise_flag INTO lv_excise_flag;
3808: CLOSE cur_item_excise_flag;

Line 3810: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);

3806: OPEN cur_item_excise_flag(r_trx.organization_id,r_trx.inventory_item_id );
3807: FETCH cur_item_excise_flag INTO lv_excise_flag;
3808: CLOSE cur_item_excise_flag;
3809:
3810: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
3811: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
3812:
3813: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
3814:

Line 3811: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);

3807: FETCH cur_item_excise_flag INTO lv_excise_flag;
3808: CLOSE cur_item_excise_flag;
3809:
3810: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
3811: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
3812:
3813: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
3814:
3815: IF r_trx.organization_type = MFG_ORGN THEN

Line 3813: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);

3809:
3810: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
3811: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
3812:
3813: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
3814:
3815: IF r_trx.organization_type = MFG_ORGN THEN
3816:
3817: IF ( ( nvl(lv_qty_upd_event,'X') = 'RECEIVE' AND lv_transaction_type in ('RECEIVE','MATCH') AND nvl(r_trx.quantity_register_flag,'N') = 'N' )

Line 3823: FND_file.put_line( fnd_file.log, 'Quantity Register would be hit independent of Amount register');

3819: ) THEN
3820:
3821: lv_online_qty_flag := 'Y';
3822:
3823: FND_file.put_line( fnd_file.log, 'Quantity Register would be hit independent of Amount register');
3824:
3825: END IF;
3826:
3827: END IF;

Line 3939: FND_file.put_line( fnd_file.log, '54321 ttype:'||r_trx.transaction_type||',exno:'||r_receipt_line.excise_invoice_no

3935: goto end_of_cenvat_flag_validation;
3936: END IF;
3937:
3938: -- following condition is false if the call to this procedure happened from JAINMVAT (i.e deferred Claim Scree)
3939: FND_file.put_line( fnd_file.log, '54321 ttype:'||r_trx.transaction_type||',exno:'||r_receipt_line.excise_invoice_no
3940: ||',exda:'||r_receipt_line.excise_invoice_date||',onClFlg:'||r_receipt_cenvat_dtl.online_claim_flag
3941: ||',CenAmt:'||r_receipt_cenvat_dtl.cenvat_amount||',calFrm:'||p_called_from);
3942:
3943: lv_statement_id := '15';

Line 4409: fnd_file.put_line(FND_FILE.LOG, ' transaction id ' || p_transaction_id);

4405: | Check whether 57F4 transaction has been created for PO
4406: | before updating Excise invoice action. If so we need to set
4407: | the value to 'PENDING' instead of 'NOT_APPLICABLE
4408: */
4409: fnd_file.put_line(FND_FILE.LOG, ' transaction id ' || p_transaction_id);
4410:
4411: IF ( Check_57F4_transaction( p_transaction_id ) = 'YES' ) THEN
4412: lv_excise_inv_gen_action := INV_GEN_STATUS_PENDING;
4413: END IF ;

Line 4429: FND_FILE.put_line( fnd_file.log, '$ VALIDATE_TRANSACTION PrcFlg:'||p_process_flag||', Msg:'||p_process_message

4425: lv_statement_id := '49';
4426: p_codepath := jai_general_pkg.plot_codepath(lv_codepath||',49', p_codepath, 'cenvat_rg_pkg.validate_trx', 'END');
4427: -- p_codepath := substr(p_codepath||lv_codepath, 1, 2000);
4428:
4429: FND_FILE.put_line( fnd_file.log, '$ VALIDATE_TRANSACTION PrcFlg:'||p_process_flag||', Msg:'||p_process_message
4430: ||', CenvatRgFlg:'||p_cenvat_rg_flag ||', Msg:'||p_cenvat_rg_message
4431: ||', PrcVatFlg:'||p_process_vat_flag ||', Msg:'||p_process_vat_message
4432: ||', localPath:'||lv_codepath
4433: );

Line 4439: FND_FILE.put_line( fnd_file.log, 'Error in '||p_process_message||'. localErrorPath:'||lv_codepath );

4435: EXCEPTION
4436: when others then
4437: p_process_flag := 'E';
4438: p_process_message := 'RECEIPT_TRANSACTION_PKG.Validate_transaction:'||SQLERRM||', Statement_id:'||lv_statement_id;
4439: FND_FILE.put_line( fnd_file.log, 'Error in '||p_process_message||'. localErrorPath:'||lv_codepath );
4440: p_codepath := jai_general_pkg.plot_codepath(lv_codepath||',-999', p_codepath, 'cenvat_rg_pkg.validate_trx', 'END');
4441:
4442: END validate_transaction;
4443: