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.INV_MO_PURGE dependencies on INV_TRX_UTIL_PUB

Line 61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);

57:
58: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
59: BEGIN
60: IF (l_debug = 1) THEN
61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);

Line 62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);

58: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
59: BEGIN
60: IF (l_debug = 1) THEN
61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);

Line 63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);

59: BEGIN
60: IF (l_debug = 1) THEN
61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
67: END IF;

Line 64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);

60: IF (l_debug = 1) THEN
61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
67: END IF;
68:

Line 65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);

61: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
67: END IF;
68:
69: OPEN mo_lines;

Line 66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);

62: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
63: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
64: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
65: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
66: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
67: END IF;
68:
69: OPEN mo_lines;
70:

Line 280: -- inv_trx_util_pub.TRACE('DELETED lines---mo_line.line_id= ' ||mo_line.line_id ,'INVMOPG',9);

276: END IF;
277: END IF;
278:
279: IF (can_delete = 1) THEN
280: -- inv_trx_util_pub.TRACE('DELETED lines---mo_line.line_id= ' ||mo_line.line_id ,'INVMOPG',9);
281: DELETE FROM mtl_txn_request_lines
282: WHERE line_id = mo_line.line_id;
283:
284: can_delete := 0;

Line 299: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' ||l_prev_header_id ,'INVMOPG',9);

295:
296: IF (SQL%FOUND) THEN
297: l_count := l_count + 1;
298: can_delete := 0;
299: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' ||l_prev_header_id ,'INVMOPG',9);
300: END IF;
301: END IF;
302:
303: IF (l_count >= p_mol_pc) THEN

Line 321: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' || mo_line.header_id ,'INVMOPG',9);

317:
318: IF (SQL%FOUND) THEN
319: l_count := l_count + 1;
320: can_delete := 0;
321: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' || mo_line.header_id ,'INVMOPG',9);
322: END IF;
323:
324: IF (l_debug = 1) THEN
325: inv_trx_util_pub.TRACE(l_count || 'Rows Purged ', 'INVMOPG', 9);

Line 325: inv_trx_util_pub.TRACE(l_count || 'Rows Purged ', 'INVMOPG', 9);

321: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' || mo_line.header_id ,'INVMOPG',9);
322: END IF;
323:
324: IF (l_debug = 1) THEN
325: inv_trx_util_pub.TRACE(l_count || 'Rows Purged ', 'INVMOPG', 9);
326: END IF;
327:
328: INSERT INTO mtl_purge_header
329: (

Line 372: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);

368: WHEN fnd_api.g_exc_error THEN
369: error := SQLERRM;
370:
371: IF (l_debug = 1) THEN
372: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
373: END IF;
374:
375: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
376: x_retcode := retcode_error;

Line 382: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);

378: WHEN fnd_api.g_exc_unexpected_error THEN
379: error := SQLERRM;
380:
381: IF (l_debug = 1) THEN
382: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
383: END IF;
384:
385: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
386: x_retcode := retcode_error;

Line 392: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);

388: WHEN OTHERS THEN
389: error := SQLERRM;
390:
391: IF (l_debug = 1) THEN
392: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
393: END IF;
394:
395: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
396: x_retcode := retcode_error;