APPS.CSI_TRANSACTION_LINES_PVT dependencies on CSI_TRANSACTION_LINES_PVT

Line 1: PACKAGE BODY CSI_TRANSACTION_LINES_PVT as

1: PACKAGE BODY CSI_TRANSACTION_LINES_PVT as
2: /* $Header: CSIVTLWB.pls 120.0.12000000.2 2007/07/11 16:32:16 ngoutam noship $ */
3: -- Start of comments
4:
5: -- HISTORY

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 62: debug('BEGIN CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);

58:
59: l_worker_start_date := SYSDATE;
60: l_request_id := FND_GLOBAL.conc_request_id;
61:
62: debug('BEGIN CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);
63:
64: -- mark the rows as being processed by worker
65: update CSI_BATCH_TXN_LINES
66: set processed_flag = 2,last_update_date = sysdate,last_updated_by = fnd_global.user_id

Line 133: debug('Error! Transaction type ' || l_transaction_type_tbl(i) || ' is not supported by CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines');

129: AND order_line_id = l_line_id_tbl(i);
130:
131: END IF;
132: else
133: debug('Error! Transaction type ' || l_transaction_type_tbl(i) || ' is not supported by CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines');
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135:
136: end if;
137: l_end_timestamp := SYSTIMESTAMP;

Line 169: debug('END CSI_TRANSACTION_LINES_PVT.Process_Txn_Lines, Batch : '||p_batch_id);

165:
166: end if;
167:
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

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;

Line 205: END CSI_TRANSACTION_LINES_PVT;

201: commit;
202: RAISE;
203: END process_txn_lines;
204:
205: END CSI_TRANSACTION_LINES_PVT;