17: -- End of comments
18:
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;
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
221: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',Current_Error_Code);
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
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