DBA Data[Home] [Help]

APPS.XNP_CSIRMAFL_U dependencies on CSI_T_GEN_UTILITY_PVT

Line 221: csi_t_gen_utility_pvt.build_file_name(

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

Line 223: csi_t_gen_utility_pvt.add(' ');

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;

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

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;

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

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;

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

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,

Line 247: csi_t_gen_utility_pvt.build_file_name(

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

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

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;

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

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(

Line 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

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

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

Line 261: csi_t_gen_utility_pvt.build_file_name(

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

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

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;