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_CSIMSISU_U dependencies on CSI_T_GEN_UTILITY_PVT

Line 253: l_debug NUMBER := csi_t_gen_utility_pvt.g_debug_level;

249: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
250: l_msg_count NUMBER;
251: l_msg_data VARCHAR2(2000);
252: l_txn_error_id NUMBER;
253: l_debug NUMBER := csi_t_gen_utility_pvt.g_debug_level;
254: e_dpl_error EXCEPTION;
255: l_date date;
256: BEGIN
257: l_trx_return_status := l_fnd_success;

Line 260: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',

256: BEGIN
257: l_trx_return_status := l_fnd_success;
258: l_trx_error_message := NULL;
259: IF (l_debug > 0) THEN
260: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',
261: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
262: END IF;
263: csi_t_gen_utility_pvt.add(' ');
264: csi_t_gen_utility_pvt.add('CSIMSISU'||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

Line 263: csi_t_gen_utility_pvt.add(' ');

259: IF (l_debug > 0) THEN
260: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',
261: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
262: END IF;
263: csi_t_gen_utility_pvt.add(' ');
264: csi_t_gen_utility_pvt.add('CSIMSISU'||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
265: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
266: savepoint one;
267: xnp_xml_utils.decode(p_msg_text => p_msg_text,p_tag => 'MTL_TRANSACTION_ID',x_value => l_mtl_trx_rec.mtl_transaction_id);

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

260: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',
261: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
262: END IF;
263: csi_t_gen_utility_pvt.add(' ');
264: csi_t_gen_utility_pvt.add('CSIMSISU'||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
265: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
266: savepoint one;
267: xnp_xml_utils.decode(p_msg_text => p_msg_text,p_tag => 'MTL_TRANSACTION_ID',x_value => l_mtl_trx_rec.mtl_transaction_id);
268: IF l_mtl_trx_rec.mtl_transaction_id is null THEN

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

261: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
262: END IF;
263: csi_t_gen_utility_pvt.add(' ');
264: csi_t_gen_utility_pvt.add('CSIMSISU'||'-'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
265: csi_t_gen_utility_pvt.add(' XML String: '||p_msg_text);
266: savepoint one;
267: xnp_xml_utils.decode(p_msg_text => p_msg_text,p_tag => 'MTL_TRANSACTION_ID',x_value => l_mtl_trx_rec.mtl_transaction_id);
268: IF l_mtl_trx_rec.mtl_transaction_id is null THEN
269: fnd_message.set_name('CSI','CSI_DECODE_MGS_ERROR');

Line 275: csi_t_gen_utility_pvt.add(' Inv Transaction ID was NULL so raising Error');

271: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
272: l_trx_error_rec.error_text := fnd_message.get;
273: l_trx_error_rec.transaction_type_id := 116;
274: l_trx_error_rec.source_type := 'CSIMSISU';
275: csi_t_gen_utility_pvt.add(' Inv Transaction ID was NULL so raising Error');
276: RAISE e_dpl_error;
277: END IF;
278: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_mtl_trx_rec.mtl_transaction_id);
279: csi_inv_txnstub_pkg.execute_trx_dpl('CSIMSISU',

Line 278: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_mtl_trx_rec.mtl_transaction_id);

274: l_trx_error_rec.source_type := 'CSIMSISU';
275: csi_t_gen_utility_pvt.add(' Inv Transaction ID was NULL so raising Error');
276: RAISE e_dpl_error;
277: END IF;
278: csi_t_gen_utility_pvt.add(' Invoking Trans: '||l_mtl_trx_rec.mtl_transaction_id);
279: csi_inv_txnstub_pkg.execute_trx_dpl('CSIMSISU',
280: l_mtl_trx_rec.mtl_transaction_id,
281: l_trx_return_status,
282: l_trx_error_rec);

Line 287: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',

283: IF NOT l_trx_return_status = l_fnd_success THEN
284: RAISE e_dpl_error;
285: END IF;
286: IF (l_debug > 0) THEN
287: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',
288: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
289: END IF;
290: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed Successfully');
291: EXCEPTION

Line 290: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed Successfully');

286: IF (l_debug > 0) THEN
287: csi_t_gen_utility_pvt.build_file_name(p_file_segment1 => 'csi',
288: p_file_segment2 => to_char(sysdate,'DDMONYYYY'));
289: END IF;
290: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed Successfully');
291: EXCEPTION
292: WHEN e_dpl_error THEN
293: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
294: l_trx_error_rec.message_id := p_msg_header.message_id;

Line 293: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);

289: END IF;
290: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed Successfully');
291: EXCEPTION
292: WHEN e_dpl_error THEN
293: csi_t_gen_utility_pvt.add(' Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
294: l_trx_error_rec.message_id := p_msg_header.message_id;
295: l_trx_error_rec.message_string := p_msg_text;
296: l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
297: l_trx_error_rec.processed_flag := csi_inv_trxs_pkg.g_txn_error;

Line 302: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);

298: rollback to one;
299: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
300: WHEN others THEN
301: IF l_mtl_trx_rec.mtl_transaction_id IS NOT NULL THEN
302: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error'||l_trx_error_rec.error_text);
303: l_trx_error_rec.message_id := p_msg_header.message_id;
304: l_trx_error_rec.message_string := p_msg_text;
305: l_trx_error_rec.error_text := SQLERRM;
306: l_trx_error_rec.transaction_type_id := 116;

Line 313: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error - passing out to calling XNP Program'||l_trx_error_rec.error_text);

309: l_trx_error_rec.inv_material_transaction_id := l_trx_error_rec.source_id;
310: rollback to one;
311: csi_inv_trxs_pkg.log_csi_error(l_trx_error_rec);
312: ELSE
313: csi_t_gen_utility_pvt.add('Transaction '||l_mtl_trx_rec.mtl_transaction_id||' completed with error - passing out to calling XNP Program'||l_trx_error_rec.error_text);
314: raise;
315: END IF;
316: END;
317: END ;