eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_CSIINTIS_U dependencies on CSI_T_GEN_UTILITY_PVT

Line 249: csi_t_gen_utility_pvt.build_file_name(

245: l_return_status varchar2(1);
246: dpl_error exception;
247: BEGIN
248: savepoint dpl_sp;
249: csi_t_gen_utility_pvt.build_file_name(
250: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
251: csi_t_gen_utility_pvt.add(' ');
252: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
253: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);

Line 251: csi_t_gen_utility_pvt.add(' ');

247: BEGIN
248: savepoint dpl_sp;
249: csi_t_gen_utility_pvt.build_file_name(
250: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
251: csi_t_gen_utility_pvt.add(' ');
252: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
253: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
254: l_error_rec.source_type := l_txn_type;
255: l_error_rec.transaction_type_id := l_txn_type_id;

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

248: savepoint dpl_sp;
249: csi_t_gen_utility_pvt.build_file_name(
250: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
251: csi_t_gen_utility_pvt.add(' ');
252: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
253: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
254: l_error_rec.source_type := l_txn_type;
255: l_error_rec.transaction_type_id := l_txn_type_id;
256: l_error_rec.message_id := p_msg_header.message_id;

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

249: csi_t_gen_utility_pvt.build_file_name(
250: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
251: csi_t_gen_utility_pvt.add(' ');
252: csi_t_gen_utility_pvt.add('START '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
253: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
254: l_error_rec.source_type := l_txn_type;
255: l_error_rec.transaction_type_id := l_txn_type_id;
256: l_error_rec.message_id := p_msg_header.message_id;
257: l_error_rec.message_string := p_msg_text;

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

262: RAISE dpl_error;
263: END IF;
264: l_error_rec.inv_material_transaction_id := l_txn_id;
265: l_error_rec.source_id := l_txn_id;
266: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_txn_id);
267: csi_inv_txnstub_pkg.execute_trx_dpl(
268: p_transaction_type => l_txn_type,
269: p_transaction_id => l_txn_id,
270: x_trx_return_status => l_return_status,

Line 275: csi_t_gen_utility_pvt.build_file_name(

271: x_trx_error_rec => l_error_rec);
272: IF l_return_status <> fnd_api.g_ret_sts_success THEN
273: RAISE dpl_error;
274: END IF;
275: csi_t_gen_utility_pvt.build_file_name(
276: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
277: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
278: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
279: EXCEPTION

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

273: RAISE dpl_error;
274: END IF;
275: csi_t_gen_utility_pvt.build_file_name(
276: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
277: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
278: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
279: EXCEPTION
280: WHEN dpl_error THEN
281: rollback to dpl_sp;

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

274: END IF;
275: csi_t_gen_utility_pvt.build_file_name(
276: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
277: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' completed Successfully.');
278: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
279: EXCEPTION
280: WHEN dpl_error THEN
281: rollback to dpl_sp;
282: csi_t_gen_utility_pvt.build_file_name(

Line 282: csi_t_gen_utility_pvt.build_file_name(

278: csi_t_gen_utility_pvt.add('END '||l_txn_type||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
279: EXCEPTION
280: WHEN dpl_error THEN
281: rollback to dpl_sp;
282: csi_t_gen_utility_pvt.build_file_name(
283: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
284: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
285: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
286: WHEN others THEN

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

280: WHEN dpl_error THEN
281: rollback to dpl_sp;
282: csi_t_gen_utility_pvt.build_file_name(
283: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
284: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
285: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
286: WHEN others THEN
287: rollback to dpl_sp;
288: l_error_rec.error_text := substr(sqlerrm, 1, 540);

Line 289: csi_t_gen_utility_pvt.build_file_name(

285: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
286: WHEN others THEN
287: rollback to dpl_sp;
288: l_error_rec.error_text := substr(sqlerrm, 1, 540);
289: csi_t_gen_utility_pvt.build_file_name(
290: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
291: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
292: IF l_txn_id is not null THEN
293: csi_inv_trxs_pkg.log_csi_error(l_error_rec);

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

287: rollback to dpl_sp;
288: l_error_rec.error_text := substr(sqlerrm, 1, 540);
289: csi_t_gen_utility_pvt.build_file_name(
290: p_file_segment1 => 'csi', p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
291: csi_t_gen_utility_pvt.add(' Transaction '||l_txn_id||' failed. '||l_error_rec.error_text);
292: IF l_txn_id is not null THEN
293: csi_inv_trxs_pkg.log_csi_error(l_error_rec);
294: ELSE
295: RAISE;