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_UTIL2 dependencies on RCV_ERROR_PKG

Line 42: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

38: if (g_debug = 1) then
39: inv_trx_util_pub.TRACE('l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
40: end if;
41:
42: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
43: raise update_history;
44: ELSE
45: resultout := 'COMPLETE:SUCCESS';
46: if (g_debug = 1) then

Line 105: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

101: if (g_debug = 1) then
102: inv_trx_util_pub.TRACE('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
103: end if;
104:
105: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
106: raise update_history;
107: ELSE
108: resultout := 'COMPLETE:SUCCESS';
109: if (g_debug = 1) then

Line 209: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

205: end if;
206:
207: l_txns_history_rec.transaction_status := p_transaction_status;
208:
209: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
210: raise update_history;
211: END IF;
212:
213: INV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txns_history_rec,

Line 223: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

219: if (g_debug = 1) then
220: inv_trx_util_pub.TRACE('Update_Txn_History.x_return_status is '||x_return_status, 'INV_TRANSACTIONS_UTIL2', 9);
221: end if;
222:
223: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
224: raise update_history;
225: ELSE
226: COMMIT;
227: END IF;

Line 242: x_return_status := rcv_error_pkg.g_ret_sts_error;

238: where event_name = p_item_type
239: and event_key = p_item_key
240: and transaction_status = 'IP';
241:
242: x_return_status := rcv_error_pkg.g_ret_sts_error;
243: if (g_debug = 1) then
244: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
245: end if;
246: ROLLBACK;

Line 255: x_return_status := rcv_error_pkg.g_ret_sts_error;

251: where event_name = p_item_type
252: and event_key = p_item_key
253: and transaction_status = 'IP';
254:
255: x_return_status := rcv_error_pkg.g_ret_sts_error;
256: if (g_debug = 1) then
257: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
258: end if;
259: ROLLBACK;

Line 299: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

295: inv_trx_util_pub.TRACE('Client Code is '|| P_client_code, 'INV_TRANSACTIONS_UTIL2', 9);
296: inv_trx_util_pub.TRACE('XML Document ID is '|| to_char(p_xml_document_id), 'INV_TRANSACTIONS_UTIL2', 9);
297: end if;
298:
299: X_Return_Status := rcv_error_pkg.g_ret_sts_success;
300:
301: IF ( P_Entity_TYPE <> 'INVADJ' ) THEN
302: RAISE invalid_entity_type;
303: ELSIF ( P_Action_TYPE <> 'A' ) THEN

Line 376: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN

372: inv_trx_util_pub.TRACE('send_inventory_adjustment.l_Return_Status is '||l_Return_Status, 'INV_TRANSACTIONS_UTIL2', 9);
373: inv_trx_util_pub.TRACE('Exiting send_inventory_adjustment', 'INV_TRANSACTIONS_UTIL2', 9);
374: end if;
375:
376: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
377: RAISE raise_event_error;
378: END IF;
379:
380: EXCEPTION

Line 383: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

379:
380: EXCEPTION
381:
382: WHEN invalid_entity_type THEN
383: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
384: if (g_debug = 1) then
385: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
386: end if;
387:

Line 389: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

385: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
386: end if;
387:
388: WHEN invalid_action_type THEN
389: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
390: if (g_debug = 1) then
391: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
392: end if;
393:

Line 395: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

391: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
392: end if;
393:
394: WHEN invalid_doc_type THEN
395: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
396: if (g_debug = 1) then
397: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
398: end if;
399:

Line 401: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

397: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_TRANSACTIONS_UTIL2', 9);
398: end if;
399:
400: WHEN raise_event_error THEN
401: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
402: if (g_debug = 1) then
403: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
404: end if;
405:

Line 407: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

403: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
404: end if;
405:
406: WHEN OTHERS THEN
407: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
408: if (g_debug = 1) then
409: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
410: end if;
411:

Line 457: x_return_status := rcv_error_pkg.g_ret_sts_error;

453:
454: EXCEPTION
455:
456: WHEN invalid_doc_type THEN
457: x_return_status := rcv_error_pkg.g_ret_sts_error;
458:
459: if (g_debug = 1) then
460: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
461: end if;

Line 464: x_return_status := rcv_error_pkg.g_ret_sts_error;

460: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured.', 'INV_TRANSACTIONS_UTIL2', 9);
461: end if;
462:
463: WHEN OTHERS THEN
464: x_return_status := rcv_error_pkg.g_ret_sts_error;
465:
466: if (g_debug = 1) then
467: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_UTIL2', 9);
468: end if;