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 65: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);

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

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

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

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

63: BEGIN
64: IF (l_debug = 1) THEN
65: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
66: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
67: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
68: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
69: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
70: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
71: END IF;

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

64: IF (l_debug = 1) THEN
65: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
66: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
67: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
68: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
69: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
70: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
71: END IF;
72:

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

65: inv_trx_util_pub.TRACE('p_organization_id = '|| p_organization_id);
66: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
67: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
68: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
69: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
70: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
71: END IF;
72:
73: OPEN mo_lines;

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

66: inv_trx_util_pub.TRACE('p_mo_type_id = '|| p_mo_type_id);
67: inv_trx_util_pub.TRACE('p_purge_name ='|| p_purge_name);
68: inv_trx_util_pub.TRACE('p_date_from='|| p_date_from);
69: inv_trx_util_pub.TRACE('p_date_to='|| p_date_to);
70: inv_trx_util_pub.TRACE('p_mol_pc='|| p_mol_pc);
71: END IF;
72:
73: OPEN mo_lines;
74:

Line 270: inv_trx_util_pub.TRACE('txn_source_id : '|| mo_line.txn_source_id);

266: -- Bug 7421347
267: -- We have to purge move orders for which the job status is closed.
268: -- We now look at the different entity types like Discrete, lot based, Flow and Repetitive Schedules,
269: If (l_debug = 1) then
270: inv_trx_util_pub.TRACE('txn_source_id : '|| mo_line.txn_source_id);
271: inv_trx_util_pub.TRACE('organization_id : '|| mo_line.organization_id);
272: end if;
273:
274: Begin

Line 271: inv_trx_util_pub.TRACE('organization_id : '|| mo_line.organization_id);

267: -- We have to purge move orders for which the job status is closed.
268: -- We now look at the different entity types like Discrete, lot based, Flow and Repetitive Schedules,
269: If (l_debug = 1) then
270: inv_trx_util_pub.TRACE('txn_source_id : '|| mo_line.txn_source_id);
271: inv_trx_util_pub.TRACE('organization_id : '|| mo_line.organization_id);
272: end if;
273:
274: Begin
275: select entity_type

Line 283: inv_trx_util_pub.TRACE('other exc.when getting entity_type setting can_delete as 0 '|| sqlerrm);

279: and organization_id = mo_line.organization_id;
280: Exception
281: when others then
282: if (l_debug = 1) then
283: inv_trx_util_pub.TRACE('other exc.when getting entity_type setting can_delete as 0 '|| sqlerrm);
284: end if;
285: l_entity_type := 0;
286: can_delete := 1;
287: End;

Line 290: inv_trx_util_pub.TRACE('WIP Entity Type = '|| l_entity_type);

286: can_delete := 1;
287: End;
288:
289: if (l_debug = 1) then
290: inv_trx_util_pub.TRACE('WIP Entity Type = '|| l_entity_type);
291: end if;
292:
293: IF (l_entity_type in (3,7,8)) THEN
294: Begin

Line 304: inv_trx_util_pub.TRACE('other exc. when l_entity_type in (3,7,8) setting can_delete as 0 '|| sqlerrm);

300: and status_type <> 12;
301: Exception
302: when others then
303: if (l_debug = 1) then
304: inv_trx_util_pub.TRACE('other exc. when l_entity_type in (3,7,8) setting can_delete as 0 '|| sqlerrm);
305: end if;
306: can_delete := 1;
307: End;
308:

Line 323: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 2 setting can_delete as 0 '|| sqlerrm);

319: and status_type <> 5;
320: Exception
321: when others then
322: if (l_debug = 1) then
323: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 2 setting can_delete as 0 '|| sqlerrm);
324: end if;
325: can_delete := 1;
326: End;
327:

Line 339: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 4 setting can_delete as 0 '|| sqlerrm);

335: and status <> 2;
336: Exception
337: when others then
338: if (l_debug = 1) then
339: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 4 setting can_delete as 0 '|| sqlerrm);
340: end if;
341: can_delete := 1;
342: End;
343: ELSIF (l_entity_type = 6) THEN --bug12767095 purge EAM work order

Line 354: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 6 setting can_delete as 0 '|| sqlerrm);

350: AND status_type not in (12,7);--closed or cancelled
351: Exception
352: when others then
353: if (l_debug = 1) then
354: inv_trx_util_pub.TRACE('other exc. when l_entity_type = 6 setting can_delete as 0 '|| sqlerrm);
355: end if;
356: can_delete := 1;
357: End;--end bug12767095
358:

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

375: END IF;
376: END IF;
377:
378: IF (can_delete = 1) THEN
379: -- inv_trx_util_pub.TRACE('DELETED lines---mo_line.line_id= ' ||mo_line.line_id ,'INVMOPG',9);
380: DELETE FROM mtl_txn_request_lines
381: WHERE line_id = mo_line.line_id;
382:
383: can_delete := 0;

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

394:
395: IF (SQL%FOUND) THEN
396: l_count := l_count + 1;
397: can_delete := 0;
398: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' ||l_prev_header_id ,'INVMOPG',9);
399: END IF;
400: END IF;
401:
402: IF (l_count >= p_mol_pc) THEN

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

417: IF (SQL%FOUND) THEN
418: -- Bug 7421347 l_count to be used to count the number of lines deleted, not for header
419: --l_count := l_count + 1;
420: can_delete := 0;
421: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' || mo_line.header_id ,'INVMOPG',9);
422: END IF;
423:
424: IF (l_debug = 1) THEN
425: inv_trx_util_pub.TRACE(l_count || 'Rows Purged ', 'INVMOPG', 9);

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

421: --inv_trx_util_pub.TRACE('DELETED Headers mo_line.header_id= ' || mo_line.header_id ,'INVMOPG',9);
422: END IF;
423:
424: IF (l_debug = 1) THEN
425: inv_trx_util_pub.TRACE(l_count || 'Rows Purged ', 'INVMOPG', 9);
426: END IF;
427:
428: INSERT INTO mtl_purge_header
429: (

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

468: WHEN fnd_api.g_exc_error THEN
469: error := SQLERRM;
470:
471: IF (l_debug = 1) THEN
472: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
473: END IF;
474:
475: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
476: x_retcode := retcode_error;

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

478: WHEN fnd_api.g_exc_unexpected_error THEN
479: error := SQLERRM;
480:
481: IF (l_debug = 1) THEN
482: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
483: END IF;
484:
485: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
486: x_retcode := retcode_error;

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

488: WHEN OTHERS THEN
489: error := SQLERRM;
490:
491: IF (l_debug = 1) THEN
492: inv_trx_util_pub.TRACE('The Error Is '|| error, 'INVMOPG', 9);
493: END IF;
494:
495: l_ret_msg := fnd_concurrent.set_completion_status('ERROR', 'ERROR');
496: x_retcode := retcode_error;