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