APPS.CSI_TRANSACTION_LINES_PVT dependencies on FND_LOG

Line 11: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

7: -- End of comments
8:
9: procedure debug(p_message in varchar2) is
10: begin
11: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12: --csi_t_gen_utility_pvt.add(p_message);
13: fnd_log.string(fnd_log.level_statement,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines' ,p_message);
14: END IF;
15: end debug;

Line 13: fnd_log.string(fnd_log.level_statement,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines' ,p_message);

9: procedure debug(p_message in varchar2) is
10: begin
11: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12: --csi_t_gen_utility_pvt.add(p_message);
13: fnd_log.string(fnd_log.level_statement,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines' ,p_message);
14: END IF;
15: end debug;
16:
17:

Line 139: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

135:
136: end if;
137: l_end_timestamp := SYSTIMESTAMP;
138:
139: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
140:
141: --debug('Timing information for order line '||l_line_id_tbl(i)||': '|| (SYSDATE - l_start_date)*(60*60*24) || ' seconds.');
142: debug('Timing information for order line '||l_line_id_tbl(i)||' using Timestamp: '||TO_CHAR(l_end_timestamp - l_start_timestamp));
143:

Line 172: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

168: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', null);
169: debug('END CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);
170:
171: /* commenting as timing information was introduced for prototyping purpose only
172: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN
173: INSERT INTO csi_batch_processing_times
174: (worker_id, start_date, end_date,creation_date,created_by,last_update_date,last_updated_by)
175: VALUES
176: (p_batch_id, l_worker_start_date, sysdate,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

Line 190: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level THEN

186: l_error_rec.inv_material_transaction_id := null;
187: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
188:
189: WHEN OTHERS THEN
190: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level THEN
191: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines', 'WHEN OTHERS: ' ||SQLERRM);
192: END IF;
193:
194:

Line 191: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines', 'WHEN OTHERS: ' ||SQLERRM);

187: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
188:
189: WHEN OTHERS THEN
190: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level THEN
191: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_lines_pvt.process_txn_lines', 'WHEN OTHERS: ' ||SQLERRM);
192: END IF;
193:
194:
195: ROLLBACK TO process_txn_lines;