DBA Data[Home] [Help]

APPS.XNP_CSISOFUL_U dependencies on CSI_T_GEN_UTILITY_PVT

Line 220: csi_t_gen_utility_pvt.build_file_name(

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);

Line 222: csi_t_gen_utility_pvt.add(' ');

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;

Line 223: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

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;

Line 224: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);

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;

Line 237: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_txn_id);

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,

Line 246: csi_t_gen_utility_pvt.build_file_name(

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

Line 248: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');

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(

Line 249: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

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'));

Line 252: csi_t_gen_utility_pvt.build_file_name(

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

Line 254: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);

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(

Line 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);

Line 260: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);

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;