APPS.CSI_TRANSACTION_IMPORT_PVT dependencies on CSI_TRANSACTION_IMPORT_PVT

Line 1: PACKAGE BODY CSI_TRANSACTION_IMPORT_PVT as

1: PACKAGE BODY CSI_TRANSACTION_IMPORT_PVT as
2: /* $Header: CSIVTXPB.pls 120.0.12000000.2 2007/07/11 17:03:00 ngoutam noship $*/
3:
4: -- Start of comments
5: -- API name : PROCESS_TRANSACTION_ROWS

Line 23: fnd_log.string(fnd_log.level_statement, 'csi.plsql.csi_transaction_import_pvt.process_transaction_rows',p_message);

19: procedure debug(p_message in varchar2) is
20: begin
21: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
22: --csi_t_gen_utility_pvt.add(p_message);
23: fnd_log.string(fnd_log.level_statement, 'csi.plsql.csi_transaction_import_pvt.process_transaction_rows',p_message);
24: END IF;
25: end debug;
26:
27: FUNCTION group_rows(p_num_workers in number) RETURN NUMBER IS

Line 131: debug('BEGIN CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows');

127: ;
128:
129: BEGIN
130:
131: debug('BEGIN CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows');
132:
133: if (p_max_worker_number < 1) then
134: l_max_worker_number := 1;
135: else

Line 173: debug(' No Rows to Process..Exiting CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows ');

169: l_batch_lower_limit := group_rows(l_num_workers);
170: debug('Function Group_Rows returns with value '||l_batch_lower_limit);
171:
172: if (l_batch_lower_limit = 0) then
173: debug(' No Rows to Process..Exiting CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows ');
174: return;
175: end if;
176:
177: for cur_batch in worker_batch_cur(l_num_workers,l_batch_lower_limit) loop

Line 217: debug('END CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows');

213: and processed_flag = 0;
214:
215: end loop;
216:
217: debug('END CSI_TRANSACTION_IMPORT_PVT.process_transaction_rows');
218: COMMIT;
219: RETCODE := 'Success';
220:
221: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);

Line 226: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_import_pvt.process_transaction_rows', 'WHEN OTHERS: ' ||SQLERRM);

222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level THEN
226: fnd_log.string(fnd_log.level_unexpected,'csi.plsql.csi_transaction_import_pvt.process_transaction_rows', 'WHEN OTHERS: ' ||SQLERRM);
227: END IF;
228:
229: update csi_batch_txn_lines
230: set batch_id = -1,last_update_date = sysdate,last_updated_by = fnd_global.user_id

Line 238: END CSI_TRANSACTION_IMPORT_PVT;

234: RAISE;
235:
236: END PROCESS_TRANSACTION_ROWS;
237:
238: END CSI_TRANSACTION_IMPORT_PVT;
239: