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_INVENTORY_ADJUSTMENT dependencies on INV_TRX_UTIL_PUB

Line 36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);

32:
33: BEGIN
34:
35: if (g_debug = 1) then
36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);
38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);
39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);

Line 37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);

33: BEGIN
34:
35: if (g_debug = 1) then
36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);
38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);
39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);
41: end if;

Line 38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);

34:
35: if (g_debug = 1) then
36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);
38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);
39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);
41: end if;
42:

Line 39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);

35: if (g_debug = 1) then
36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);
38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);
39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);
41: end if;
42:
43:

Line 40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);

36: inv_trx_util_pub.TRACE('Entering send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
37: inv_trx_util_pub.TRACE('p_org_id is '||p_org_id, 'INV_INVENTORY_ADJUSTMENT', 9);
38: inv_trx_util_pub.TRACE('p_client_code is '||p_client_code, 'INV_INVENTORY_ADJUSTMENT', 9);
39: inv_trx_util_pub.TRACE('p_xml_doc_id is ' ||p_xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
40: inv_trx_util_pub.TRACE('p_trx_type is ' ||p_trx_type, 'INV_INVENTORY_ADJUSTMENT', 9);
41: end if;
42:
43:
44: x_errbuf := 'Success';

Line 68: inv_trx_util_pub.TRACE('l_txn_type_id is ' || l_txn_type_id, 'INV_INVENTORY_ADJUSTMENT', 9);

64:
65: END IF;
66:
67: if (g_debug = 1) then
68: inv_trx_util_pub.TRACE('l_txn_type_id is ' || l_txn_type_id, 'INV_INVENTORY_ADJUSTMENT', 9);
69: end if;
70:
71: -- trx_date_from := FND_DATE.Canonical_To_Date(p_trx_date_from);
72: -- trx_date_to := FND_DATE.Canonical_To_Date(p_trx_date_to);

Line 77: inv_trx_util_pub.TRACE('transaction date range is not provided.', 'INV_INVENTORY_ADJUSTMENT', 9);

73:
74:
75: IF (p_trx_date_from IS NULL) or (p_trx_date_to IS NULL) THEN
76: if (g_debug = 1) then
77: inv_trx_util_pub.TRACE('transaction date range is not provided.', 'INV_INVENTORY_ADJUSTMENT', 9);
78: end if;
79:
80: x_errbuf := 'Transaction date range is not provided.';
81: x_retcode := 2;

Line 94: inv_trx_util_pub.TRACE('From Trxn Date is ' ||trx_date_from, 'INV_INVENTORY_ADJUSTMENT', 9);

90: trx_date_from := trunc(trx_date_from);
91: trx_date_to := trunc(trx_date_to);
92:
93: if (g_debug = 1) then
94: inv_trx_util_pub.TRACE('From Trxn Date is ' ||trx_date_from, 'INV_INVENTORY_ADJUSTMENT', 9);
95: inv_trx_util_pub.TRACE('To Trxn Date ' || trx_date_to, 'INV_INVENTORY_ADJUSTMENT', 9);
96: inv_trx_util_pub.TRACE('xml_doc_id is '||xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
97: end if;
98:

Line 95: inv_trx_util_pub.TRACE('To Trxn Date ' || trx_date_to, 'INV_INVENTORY_ADJUSTMENT', 9);

91: trx_date_to := trunc(trx_date_to);
92:
93: if (g_debug = 1) then
94: inv_trx_util_pub.TRACE('From Trxn Date is ' ||trx_date_from, 'INV_INVENTORY_ADJUSTMENT', 9);
95: inv_trx_util_pub.TRACE('To Trxn Date ' || trx_date_to, 'INV_INVENTORY_ADJUSTMENT', 9);
96: inv_trx_util_pub.TRACE('xml_doc_id is '||xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
97: end if;
98:
99:

Line 96: inv_trx_util_pub.TRACE('xml_doc_id is '||xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);

92:
93: if (g_debug = 1) then
94: inv_trx_util_pub.TRACE('From Trxn Date is ' ||trx_date_from, 'INV_INVENTORY_ADJUSTMENT', 9);
95: inv_trx_util_pub.TRACE('To Trxn Date ' || trx_date_to, 'INV_INVENTORY_ADJUSTMENT', 9);
96: inv_trx_util_pub.TRACE('xml_doc_id is '||xml_doc_id, 'INV_INVENTORY_ADJUSTMENT', 9);
97: end if;
98:
99:
100: l_event_name := 'oracle.apps.inv.standalone.adjo';

Line 108: inv_trx_util_pub.TRACE('l_entity_id is ' || l_entity_id, 'INV_INVENTORY_ADJUSTMENT', 9);

104: from dual;
105:
106:
107: if (g_debug = 1) then
108: inv_trx_util_pub.TRACE('l_entity_id is ' || l_entity_id, 'INV_INVENTORY_ADJUSTMENT', 9);
109: end if;
110:
111: IF ( p_client_code is not null ) THEN
112:

Line 114: inv_trx_util_pub.TRACE('Client code is not null', 'INV_INVENTORY_ADJUSTMENT', 9);

110:
111: IF ( p_client_code is not null ) THEN
112:
113: if (g_debug = 1) then
114: inv_trx_util_pub.TRACE('Client code is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
115: end if;
116:
117: IF (p_xml_doc_id is null) THEN
118:

Line 120: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);

116:
117: IF (p_xml_doc_id is null) THEN
118:
119: if (g_debug = 1) then
120: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
122: end if;
123:
124: insert into mtl_adjustment_sync_temp

Line 121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

117: IF (p_xml_doc_id is null) THEN
118:
119: if (g_debug = 1) then
120: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
121: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
122: end if;
123:
124: insert into mtl_adjustment_sync_temp
125: (TRANSACTION_NUMBER,

Line 201: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);

197: AND transaction_date >= trx_date_from
198: AND transaction_date < trx_date_to + 1; -- Added 1 as the input dates are truncated.
199:
200: if (g_debug = 1) then
201: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);
202: end if;
203:
204: ELSE
205:

Line 207: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);

203:
204: ELSE
205:
206: if (g_debug = 1) then
207: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
209: end if;
210:
211: insert into mtl_adjustment_sync_temp

Line 208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

204: ELSE
205:
206: if (g_debug = 1) then
207: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
208: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
209: end if;
210:
211: insert into mtl_adjustment_sync_temp
212: (TRANSACTION_NUMBER,

Line 290: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);

286: --AND transaction_date >= trx_date_from
287: --AND transaction_date < trx_date_to + 1;
288:
289: if (g_debug = 1) then
290: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);
291: end if;
292:
293: END IF;
294:

Line 298: inv_trx_util_pub.TRACE('Client code is null', 'INV_INVENTORY_ADJUSTMENT', 9);

294:
295: ELSE
296:
297: if (g_debug = 1) then
298: inv_trx_util_pub.TRACE('Client code is null', 'INV_INVENTORY_ADJUSTMENT', 9);
299: end if;
300:
301: IF (p_xml_doc_id is null) THEN
302:

Line 304: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);

300:
301: IF (p_xml_doc_id is null) THEN
302:
303: if (g_debug = 1) then
304: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
306: end if;
307:
308: insert into mtl_adjustment_sync_temp

Line 305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

301: IF (p_xml_doc_id is null) THEN
302:
303: if (g_debug = 1) then
304: inv_trx_util_pub.TRACE('xml_doc_id is null', 'INV_INVENTORY_ADJUSTMENT', 9);
305: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
306: end if;
307:
308: insert into mtl_adjustment_sync_temp
309: (TRANSACTION_NUMBER,

Line 384: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);

380: AND transaction_date >= trx_date_from
381: AND transaction_date < trx_date_to + 1;
382:
383: if (g_debug = 1) then
384: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);
385: end if;
386:
387: ELSE
388:

Line 390: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);

386:
387: ELSE
388:
389: if (g_debug = 1) then
390: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
392: end if;
393:
394: insert into mtl_adjustment_sync_temp

Line 391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);

387: ELSE
388:
389: if (g_debug = 1) then
390: inv_trx_util_pub.TRACE('xml_doc_id is not null', 'INV_INVENTORY_ADJUSTMENT', 9);
391: inv_trx_util_pub.TRACE('Inserting into mtl_adjustment_sync_temp', 'INV_INVENTORY_ADJUSTMENT', 9);
392: end if;
393:
394: insert into mtl_adjustment_sync_temp
395: (TRANSACTION_NUMBER,

Line 472: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);

468: --AND transaction_date >= trx_date_from
469: --AND transaction_date < trx_date_to + 1;
470:
471: if (g_debug = 1) then
472: inv_trx_util_pub.TRACE('no of rows inserted: '||SQL%ROWCOUNT, 'INV_INVENTORY_ADJUSTMENT', 9);
473: end if;
474:
475: END IF;
476:

Line 485: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to P', 'INV_INVENTORY_ADJUSTMENT', 9);

481: IF (xml_doc_id is null) THEN
482:
483:
484: if (g_debug = 1) then
485: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to P', 'INV_INVENTORY_ADJUSTMENT', 9);
486: end if;
487:
488: UPDATE mtl_material_transactions
489: SET transaction_extracted = 'P'

Line 515: inv_trx_util_pub.TRACE('Send_Document.l_return_status is ' || l_return_status, 'INV_INVENTORY_ADJUSTMENT', 9);

511: p_xml_document_id => xml_doc_id,
512: x_return_status => l_return_status);
513:
514: if (g_debug = 1) then
515: inv_trx_util_pub.TRACE('Send_Document.l_return_status is ' || l_return_status, 'INV_INVENTORY_ADJUSTMENT', 9);
516: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_INVENTORY_ADJUSTMENT', 9);
517: end if;
518:
519: IF (l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN

Line 516: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_INVENTORY_ADJUSTMENT', 9);

512: x_return_status => l_return_status);
513:
514: if (g_debug = 1) then
515: inv_trx_util_pub.TRACE('Send_Document.l_return_status is ' || l_return_status, 'INV_INVENTORY_ADJUSTMENT', 9);
516: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_INVENTORY_ADJUSTMENT', 9);
517: end if;
518:
519: IF (l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN
520:

Line 524: inv_trx_util_pub.TRACE('send_document failed', 'INV_INVENTORY_ADJUSTMENT', 9);

520:
521: IF (xml_doc_id is null) THEN
522:
523: if (g_debug = 1) then
524: inv_trx_util_pub.TRACE('send_document failed', 'INV_INVENTORY_ADJUSTMENT', 9);
525: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to null', 'INV_INVENTORY_ADJUSTMENT', 9);
526: end if;
527:
528: UPDATE mtl_material_transactions

Line 525: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to null', 'INV_INVENTORY_ADJUSTMENT', 9);

521: IF (xml_doc_id is null) THEN
522:
523: if (g_debug = 1) then
524: inv_trx_util_pub.TRACE('send_document failed', 'INV_INVENTORY_ADJUSTMENT', 9);
525: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to null', 'INV_INVENTORY_ADJUSTMENT', 9);
526: end if;
527:
528: UPDATE mtl_material_transactions
529: SET transaction_extracted = null,

Line 548: inv_trx_util_pub.TRACE('Exit Loop', 'INV_INVENTORY_ADJUSTMENT', 9);

544: END IF;
545:
546:
547: if (g_debug = 1) then
548: inv_trx_util_pub.TRACE('Exit Loop', 'INV_INVENTORY_ADJUSTMENT', 9);
549: inv_trx_util_pub.TRACE('Exiting send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
550: end if;
551:
552: COMMIT;

Line 549: inv_trx_util_pub.TRACE('Exiting send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);

545:
546:
547: if (g_debug = 1) then
548: inv_trx_util_pub.TRACE('Exit Loop', 'INV_INVENTORY_ADJUSTMENT', 9);
549: inv_trx_util_pub.TRACE('Exiting send_adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
550: end if;
551:
552: COMMIT;
553:

Line 558: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in Send_Adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);

554: EXCEPTION
555: WHEN OTHERS THEN
556:
557: if (g_debug = 1) then
558: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in Send_Adjustment', 'INV_INVENTORY_ADJUSTMENT', 9);
559: end if;
560: ROLLBACK;
561:
562: if(l_entity_id is not null) then

Line 578: inv_trx_util_pub.TRACE('deleting the temp table for entity_id: '||p_entity_id, 'INV_INVENTORY_ADJUSTMENT', 9);

574:
575: if (p_entity_id is not null) then
576:
577: if (g_debug = 1) then
578: inv_trx_util_pub.TRACE('deleting the temp table for entity_id: '||p_entity_id, 'INV_INVENTORY_ADJUSTMENT', 9);
579: end if;
580:
581: delete from mtl_adjustment_sync_temp
582: where entity_id = p_entity_id;

Line 592: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in delete_temp_table', 'INV_INVENTORY_ADJUSTMENT', 9);

588: EXCEPTION
589:
590: WHEN OTHERS THEN
591: if (g_debug = 1) then
592: inv_trx_util_pub.TRACE('Exception : '||sqlerrm||' occurred in delete_temp_table', 'INV_INVENTORY_ADJUSTMENT', 9);
593: end if;
594: ROLLBACK;
595:
596: END delete_temp_table;