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_TRANSACTIONS_HISTORY_PKG dependencies on INV_TRANSACTIONS_HISTORY_PKG

Line 1: PACKAGE BODY inv_transactions_history_pkg as

1: PACKAGE BODY inv_transactions_history_pkg as
2: /* $Header: INVTXHSB.pls 120.0.12010000.5 2010/04/09 21:00:41 kdong noship $ */
3:
4: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_TRANSACTIONS_HISTORY_PKG';

3:
4: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_TRANSACTIONS_HISTORY_PKG';
8: --
9:
10: PROCEDURE Create_Update_Txns_History(
11: p_txns_history_rec IN OUT NOCOPY Txns_History_Record_Type,

Line 59: inv_trx_util_pub.TRACE('Entering Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

55:
56: BEGIN
57:
58: if (g_debug = 1) then
59: inv_trx_util_pub.TRACE('Entering Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
60: inv_trx_util_pub.TRACE('Entity Type is '||p_txns_history_Rec.entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
61: inv_trx_util_pub.TRACE('Entity number is '||p_txns_history_Rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
62: inv_trx_util_pub.TRACE('Transaction status is '||p_txns_history_Rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
63: end if;

Line 60: inv_trx_util_pub.TRACE('Entity Type is '||p_txns_history_Rec.entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

56: BEGIN
57:
58: if (g_debug = 1) then
59: inv_trx_util_pub.TRACE('Entering Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
60: inv_trx_util_pub.TRACE('Entity Type is '||p_txns_history_Rec.entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
61: inv_trx_util_pub.TRACE('Entity number is '||p_txns_history_Rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
62: inv_trx_util_pub.TRACE('Transaction status is '||p_txns_history_Rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
63: end if;
64:

Line 61: inv_trx_util_pub.TRACE('Entity number is '||p_txns_history_Rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

57:
58: if (g_debug = 1) then
59: inv_trx_util_pub.TRACE('Entering Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
60: inv_trx_util_pub.TRACE('Entity Type is '||p_txns_history_Rec.entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
61: inv_trx_util_pub.TRACE('Entity number is '||p_txns_history_Rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
62: inv_trx_util_pub.TRACE('Transaction status is '||p_txns_history_Rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
63: end if;
64:
65: x_return_status := rcv_error_pkg.g_ret_sts_success;

Line 62: inv_trx_util_pub.TRACE('Transaction status is '||p_txns_history_Rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

58: if (g_debug = 1) then
59: inv_trx_util_pub.TRACE('Entering Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
60: inv_trx_util_pub.TRACE('Entity Type is '||p_txns_history_Rec.entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
61: inv_trx_util_pub.TRACE('Entity number is '||p_txns_history_Rec.entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
62: inv_trx_util_pub.TRACE('Transaction status is '||p_txns_history_Rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
63: end if;
64:
65: x_return_status := rcv_error_pkg.g_ret_sts_success;
66: l_xml_document_id := P_xml_document_id;

Line 104: inv_trx_util_pub.TRACE('Opening txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

100:
101: -- Check if a record already exists
102:
103: if (g_debug = 1) then
104: inv_trx_util_pub.TRACE('Opening txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
105: end if;
106:
107: OPEN txn_cur;
108:

Line 110: inv_trx_util_pub.TRACE('Fetching txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

106:
107: OPEN txn_cur;
108:
109: if (g_debug = 1) then
110: inv_trx_util_pub.TRACE('Fetching txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
111: end if;
112:
113: FETCH txn_cur INTO l_transaction_id,l_transaction_status;
114:

Line 131: inv_trx_util_pub.TRACE('Transaction ID is '|| x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

127: INTO x_transaction_id
128: FROM dual;
129:
130: if (g_debug = 1) then
131: inv_trx_util_pub.TRACE('Transaction ID is '|| x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
133: end if;
134:
135: INSERT INTO MTL_TXNS_HISTORY(

Line 132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

128: FROM dual;
129:
130: if (g_debug = 1) then
131: inv_trx_util_pub.TRACE('Transaction ID is '|| x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
133: end if;
134:
135: INSERT INTO MTL_TXNS_HISTORY(
136: TRANSACTION_ID,

Line 222: inv_trx_util_pub.TRACE('Record inserted into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

218:
219: x_txns_id := x_transaction_id;
220:
221: if (g_debug = 1) then
222: inv_trx_util_pub.TRACE('Record inserted into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
223: inv_trx_util_pub.TRACE('x_transaction_id is '||x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
224: end if;
225:
226: ELSE

Line 223: inv_trx_util_pub.TRACE('x_transaction_id is '||x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

219: x_txns_id := x_transaction_id;
220:
221: if (g_debug = 1) then
222: inv_trx_util_pub.TRACE('Record inserted into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
223: inv_trx_util_pub.TRACE('x_transaction_id is '||x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
224: end if;
225:
226: ELSE
227:

Line 229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

225:
226: ELSE
227:
228: if (g_debug = 1) then
229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
233: end if;

Line 230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

226: ELSE
227:
228: if (g_debug = 1) then
229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
233: end if;
234:

Line 231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

227:
228: if (g_debug = 1) then
229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
233: end if;
234:
235: -- Record already exists. So Need to Update

Line 232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

228: if (g_debug = 1) then
229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
233: end if;
234:
235: -- Record already exists. So Need to Update
236: -- Before Update Check for validity of status

Line 247: inv_trx_util_pub.TRACE('Updating MTL_XML_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

243:
244: END IF; -- if l_transaction_status checks
245:
246: if (g_debug = 1) then
247: inv_trx_util_pub.TRACE('Updating MTL_XML_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
248: end if;
249:
250: UPDATE MTL_TXNS_HISTORY
251: SET entity_number = p_txns_history_rec.entity_number,

Line 284: inv_trx_util_pub.TRACE('MTL_TXNS_HISTORY record updated', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

280: attribute15 = p_txns_history_rec.ATTRIBUTE15
281: WHERE transaction_id = l_transaction_id;
282:
283: if (g_debug = 1) then
284: inv_trx_util_pub.TRACE('MTL_TXNS_HISTORY record updated', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
285: end if;
286:
287: if p_txns_history_rec.document_type ='ADJ' then --added for onhand
288: select count(*)

Line 294: inv_trx_util_pub.TRACE('temp table count: '||l_dummy, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

290: from mtl_adjustment_sync_temp
291: where entity_id = p_txns_history_rec.entity_number;
292:
293: if (g_debug = 1) then
294: inv_trx_util_pub.TRACE('temp table count: '||l_dummy, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
295: end if;
296:
297: UPDATE mtl_material_transactions
298: SET transaction_extracted = 'Y',

Line 307: inv_trx_util_pub.TRACE('No of rows in MMT updated: '||SQL%ROWCOUNT, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

303: from mtl_adjustment_sync_temp
304: where entity_id = p_txns_history_rec.entity_number);
305:
306: if (g_debug = 1) then
307: inv_trx_util_pub.TRACE('No of rows in MMT updated: '||SQL%ROWCOUNT, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
308: end if;
309:
310: if (g_debug = 1) then
311: inv_trx_util_pub.TRACE('MMT updated, now delete the temp table', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 311: inv_trx_util_pub.TRACE('MMT updated, now delete the temp table', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

307: inv_trx_util_pub.TRACE('No of rows in MMT updated: '||SQL%ROWCOUNT, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
308: end if;
309:
310: if (g_debug = 1) then
311: inv_trx_util_pub.TRACE('MMT updated, now delete the temp table', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
312: end if;
313:
314: INV_INVENTORY_ADJUSTMENT.delete_temp_table(p_txns_history_rec.entity_number);
315:

Line 323: inv_trx_util_pub.TRACE('Closing txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

319: IF(txn_cur%ISOPEN) THEN
320: CLOSE txn_cur;
321:
322: if (g_debug = 1) then
323: inv_trx_util_pub.TRACE('Closing txn_cur', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
324: end if;
325:
326: END IF;
327: ELSE

Line 335: inv_trx_util_pub.TRACE('Exiting Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

331:
332: END IF; -- if p_txns_history_rec columns are not null
333:
334: if (g_debug = 1) then
335: inv_trx_util_pub.TRACE('Exiting Create_Update_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
336: end if;
337:
338: EXCEPTION
339: WHEN invalid_status THEN

Line 342: inv_trx_util_pub.TRACE('invalid_status exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

338: EXCEPTION
339: WHEN invalid_status THEN
340: x_return_status := rcv_error_pkg.g_ret_sts_error;
341: if (g_debug = 1) then
342: inv_trx_util_pub.TRACE('invalid_status exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
343: end if;
344: WHEN invalid_action THEN
345: x_return_status := rcv_error_pkg.g_ret_sts_error;
346: if (g_debug = 1) then

Line 347: inv_trx_util_pub.TRACE('invalid_action exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

343: end if;
344: WHEN invalid_action THEN
345: x_return_status := rcv_error_pkg.g_ret_sts_error;
346: if (g_debug = 1) then
347: inv_trx_util_pub.TRACE('invalid_action exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
348: end if;
349: WHEN invalid_entity_type THEN
350: x_return_status := rcv_error_pkg.g_ret_sts_error;
351: if (g_debug = 1) then

Line 352: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

348: end if;
349: WHEN invalid_entity_type THEN
350: x_return_status := rcv_error_pkg.g_ret_sts_error;
351: if (g_debug = 1) then
352: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
353: end if;
354: WHEN invalid_direction THEN
355: x_return_status := rcv_error_pkg.g_ret_sts_error;
356: if (g_debug = 1) then

Line 357: inv_trx_util_pub.TRACE('invalid_direction exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

353: end if;
354: WHEN invalid_direction THEN
355: x_return_status := rcv_error_pkg.g_ret_sts_error;
356: if (g_debug = 1) then
357: inv_trx_util_pub.TRACE('invalid_direction exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
358: end if;
359: WHEN invalid_document_type THEN
360: x_return_status := rcv_error_pkg.g_ret_sts_error;
361: if (g_debug = 1) then

Line 362: inv_trx_util_pub.TRACE('invalid_document_type exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

358: end if;
359: WHEN invalid_document_type THEN
360: x_return_status := rcv_error_pkg.g_ret_sts_error;
361: if (g_debug = 1) then
362: inv_trx_util_pub.TRACE('invalid_document_type exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
363: end if;
364: WHEN Others THEN
365: x_return_status := rcv_error_pkg.g_ret_sts_error;
366: if (g_debug = 1) then

Line 367: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

363: end if;
364: WHEN Others THEN
365: x_return_status := rcv_error_pkg.g_ret_sts_error;
366: if (g_debug = 1) then
367: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
368: end if;
369:
370: END Create_Update_Txns_History;
371:

Line 429: inv_trx_util_pub.TRACE('Entering Get_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

425:
426: BEGIN
427:
428: if (g_debug = 1) then
429: inv_trx_util_pub.TRACE('Entering Get_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
430: end if;
431:
432: x_return_status := rcv_error_pkg.g_ret_sts_success;
433:

Line 444: inv_trx_util_pub.TRACE('Exiting Get_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

440:
441: CLOSE txns_history_cur;
442:
443: if (g_debug = 1) then
444: inv_trx_util_pub.TRACE('Exiting Get_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
445: end if;
446:
447: EXCEPTION
448: WHEN no_record_found THEN

Line 456: inv_trx_util_pub.TRACE('no_record_found exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

452: END IF;
453:
454: x_return_status := rcv_error_pkg.g_ret_sts_error;
455: if (g_debug = 1) then
456: inv_trx_util_pub.TRACE('no_record_found exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
457: end if;
458:
459: WHEN Others THEN
460: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;

Line 462: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

458:
459: WHEN Others THEN
460: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
461: if (g_debug = 1) then
462: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
463: end if;
464: END Get_Txns_History;
465:
466: /* should be deleted, if not needed.

Line 505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

501:
502: BEGIN
503:
504: if (g_debug = 1) then
505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

502: BEGIN
503:
504: if (g_debug = 1) then
505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

503:
504: if (g_debug = 1) then
505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

504: if (g_debug = 1) then
505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

505: inv_trx_util_pub.TRACE('Entering Create_Txns_History', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

506: inv_trx_util_pub.TRACE('Transaction ID is '||p_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

507: inv_trx_util_pub.TRACE('document Type is '||p_document_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

508: inv_trx_util_pub.TRACE('Doc Direction is '||p_document_direction, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

509: inv_trx_util_pub.TRACE('Doc number is '||p_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

510: inv_trx_util_pub.TRACE('Orig doc num is '||p_orig_document_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

511: inv_trx_util_pub.TRACE('Entity Type is '||p_entity_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

512: inv_trx_util_pub.TRACE('Entity number is '||p_entity_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

513: inv_trx_util_pub.TRACE('Trading Partner id is '||p_trading_partner_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

514: inv_trx_util_pub.TRACE('Action type is '||p_action_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
522: end if;

Line 519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

515: inv_trx_util_pub.TRACE('Transaction status is '||p_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
522: end if;
523:

Line 520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

516: inv_trx_util_pub.TRACE('ECX Message ID is '||p_ecx_message_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
522: end if;
523:
524: x_return_status := rcv_error_pkg.g_ret_sts_success;

Line 521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

517: inv_trx_util_pub.TRACE('Event Name is '||p_event_name, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
518: inv_trx_util_pub.TRACE('Event Key is '||p_event_key, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
519: inv_trx_util_pub.TRACE('Item Type is '||p_item_type, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
520: inv_trx_util_pub.TRACE('In. control num is '||p_internal_control_number, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
521: inv_trx_util_pub.TRACE('Document Revision is '||p_document_revision, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
522: end if;
523:
524: x_return_status := rcv_error_pkg.g_ret_sts_success;
525:

Line 550: inv_trx_util_pub.TRACE('l_return_status is '||l_return_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

546: x_txns_id => l_txn_id,
547: x_return_status => l_return_status);
548:
549: if (g_debug = 1) then
550: inv_trx_util_pub.TRACE('l_return_status is '||l_return_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
551: end if;
552:
553: IF(l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN
554: raise create_update_failed;

Line 561: inv_trx_util_pub.TRACE('create_update_failed exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

557: EXCEPTION
558: WHEN create_update_failed THEN
559: x_return_status := rcv_error_pkg.g_ret_sts_error;
560: if (g_debug = 1) then
561: inv_trx_util_pub.TRACE('create_update_failed exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
562: end if;
563: WHEN Others THEN
564: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
565: if (g_debug = 1) then

Line 566: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

562: end if;
563: WHEN Others THEN
564: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
565: if (g_debug = 1) then
566: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
567: end if;
568: END Create_Txns_History;
569:
570: */

Line 572: END INV_TRANSACTIONS_HISTORY_PKG;

568: END Create_Txns_History;
569:
570: */
571:
572: END INV_TRANSACTIONS_HISTORY_PKG;