217: l_return_status varchar2(1);
218: dpl_error exception;
219: BEGIN
220: savepoint dpl_sp;
221: csi_t_gen_utility_pvt.build_file_name(
222: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
223: csi_t_gen_utility_pvt.add(' ');
224: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
225: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
219: BEGIN
220: savepoint dpl_sp;
221: csi_t_gen_utility_pvt.build_file_name(
222: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
223: csi_t_gen_utility_pvt.add(' ');
224: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
225: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
226: l_error_rec.source_type := l_txn_type;
227: l_error_rec.transaction_type_id := l_txn_type_id;
220: savepoint dpl_sp;
221: csi_t_gen_utility_pvt.build_file_name(
222: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
223: csi_t_gen_utility_pvt.add(' ');
224: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
225: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
226: l_error_rec.source_type := l_txn_type;
227: l_error_rec.transaction_type_id := l_txn_type_id;
228: l_error_rec.message_id := p_msg_header.message_id;
221: csi_t_gen_utility_pvt.build_file_name(
222: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
223: csi_t_gen_utility_pvt.add(' ');
224: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
225: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
226: l_error_rec.source_type := l_txn_type;
227: l_error_rec.transaction_type_id := l_txn_type_id;
228: l_error_rec.message_id := p_msg_header.message_id;
229: l_error_rec.message_string := p_msg_text;
234: RAISE dpl_error;
235: END IF;
236: --l_error_rec.inv_material_transaction_id := l_txn_id; commented for bug 2865384
237: l_error_rec.source_id := l_txn_id;
238: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_txn_id);
239: csi_inv_txnstub_pkg.execute_trx_dpl(
240: p_transaction_type => l_txn_type,
241: p_transaction_id => l_txn_id,
242: x_trx_return_status => l_return_status,
243: x_trx_error_rec => l_error_rec);
244: IF l_return_status <> fnd_api.g_ret_sts_success THEN
245: RAISE dpl_error;
246: END IF;
247: csi_t_gen_utility_pvt.build_file_name(
248: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
249: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
250: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
251: EXCEPTION
245: RAISE dpl_error;
246: END IF;
247: csi_t_gen_utility_pvt.build_file_name(
248: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
249: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
250: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
251: EXCEPTION
252: WHEN dpl_error THEN
253: rollback to dpl_sp;
246: END IF;
247: csi_t_gen_utility_pvt.build_file_name(
248: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
249: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
250: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
251: EXCEPTION
252: WHEN dpl_error THEN
253: rollback to dpl_sp;
254: csi_t_gen_utility_pvt.build_file_name(
250: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
251: EXCEPTION
252: WHEN dpl_error THEN
253: rollback to dpl_sp;
254: csi_t_gen_utility_pvt.build_file_name(
255: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
256: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
257: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
258: WHEN others THEN
252: WHEN dpl_error THEN
253: rollback to dpl_sp;
254: csi_t_gen_utility_pvt.build_file_name(
255: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
256: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
257: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
258: WHEN others THEN
259: rollback to dpl_sp;
260: l_error_rec.error_text := substr(sqlerrm, 1, 540);
257: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
258: WHEN others THEN
259: rollback to dpl_sp;
260: l_error_rec.error_text := substr(sqlerrm, 1, 540);
261: csi_t_gen_utility_pvt.build_file_name(
262: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
263: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. ' ||l_error_rec.error_text);
264: IF l_txn_id is not null THEN
265: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
259: rollback to dpl_sp;
260: l_error_rec.error_text := substr(sqlerrm, 1, 540);
261: csi_t_gen_utility_pvt.build_file_name(
262: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
263: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. ' ||l_error_rec.error_text);
264: IF l_txn_id is not null THEN
265: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
266: ELSE
267: RAISE;