DBA Data[Home] [Help]

APPS.INV_ONHAND_BALANCE dependencies on RCV_ERROR_PKG

Line 48: x_return_status := rcv_error_pkg.g_ret_sts_success;

44: inv_trx_util_pub.TRACE('transaction_id is ' || P_txn_hist_record.transaction_id, 'INV_ONHAND_BALANCE', 9);
45: inv_trx_util_pub.TRACE('transaction_status is ' || P_txn_hist_record.transaction_status, 'INV_ONHAND_BALANCE', 9);
46: end if;
47:
48: x_return_status := rcv_error_pkg.g_ret_sts_success;
49:
50: l_txn_hist_record := P_txn_hist_record;
51: l_xml_document_id := P_xml_document_id;
52:

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

228: inv_trx_util_pub.TRACE('l_txns_id is '||l_txns_id, 'INV_ONHAND_BALANCE', 9);
229: inv_trx_util_pub.TRACE('l_return_status is '||To_Char(l_Return_Status), 'INV_ONHAND_BALANCE', 9);
230: end if;
231:
232: IF ( l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
233: if (g_debug = 1) then
234: inv_trx_util_pub.TRACE('Raise_Event.l_Return_Status is '|| l_Return_Status, 'INV_ONHAND_BALANCE', 9);
235: end if;
236: RAISE update_history;

Line 265: x_return_status := rcv_error_pkg.g_ret_sts_error;

261: end if;
262:
263: EXCEPTION
264: WHEN invalid_event_name THEN
265: x_return_status := rcv_error_pkg.g_ret_sts_error;
266: if (g_debug = 1) then
267: inv_trx_util_pub.TRACE('invalid_event_name exception has occured.', 'INV_ONHAND_BALANCE', 9);
268: end if;
269:

Line 271: x_return_status := rcv_error_pkg.g_ret_sts_error;

267: inv_trx_util_pub.TRACE('invalid_event_name exception has occured.', 'INV_ONHAND_BALANCE', 9);
268: end if;
269:
270: WHEN update_history THEN
271: x_return_status := rcv_error_pkg.g_ret_sts_error;
272: if (g_debug = 1) then
273: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_ONHAND_BALANCE', 9);
274: end if;
275:

Line 277: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;

273: inv_trx_util_pub.TRACE('update_history exception has occured.', 'INV_ONHAND_BALANCE', 9);
274: end if;
275:
276: WHEN OTHERS THEN
277: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
278:
279: if (g_debug = 1) then
280: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
281: end if;

Line 321: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

317: inv_trx_util_pub.TRACE('p_xml_document_id is ' || p_xml_document_id, 'INV_ONHAND_BALANCE', 9);
318:
319: END IF;
320:
321: X_Return_Status := rcv_error_pkg.g_ret_sts_success;
322: l_xml_document_id := P_xml_document_id;
323:
324: IF ( P_Entity_TYPE <> 'INVMOQD' ) THEN
325: RAISE invalid_entity_type;

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

397: inv_trx_util_pub.TRACE('Exiting Send_Onhand_Document', 'INV_ONHAND_BALANCE', 9);
398:
399: END IF;
400:
401: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
402: RAISE raise_event_error;
403: END IF;
404:
405: EXCEPTION

Line 408: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

404:
405: EXCEPTION
406:
407: WHEN invalid_entity_type THEN
408: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
409: IF (g_debug = 1) THEN
410: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_ONHAND_BALANCE', 9);
411: END IF;
412:

Line 414: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

410: inv_trx_util_pub.TRACE('invalid_entity_type exception has occured', 'INV_ONHAND_BALANCE', 9);
411: END IF;
412:
413: WHEN invalid_action_type THEN
414: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
415: IF (g_debug = 1) THEN
416: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_ONHAND_BALANCE', 9);
417: END IF;
418:

Line 420: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

416: inv_trx_util_pub.TRACE('invalid_action_type exception has occured', 'INV_ONHAND_BALANCE', 9);
417: END IF;
418:
419: WHEN invalid_doc_type THEN
420: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
421: IF (g_debug = 1) THEN
422: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_ONHAND_BALANCE', 9);
423: END IF;
424:

Line 426: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

422: inv_trx_util_pub.TRACE('invalid_doc_type exception has occured', 'INV_ONHAND_BALANCE', 9);
423: END IF;
424:
425: WHEN raise_event_error THEN
426: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
427: IF (g_debug = 1) THEN
428: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
429: END IF;
430:

Line 432: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

428: inv_trx_util_pub.TRACE('raise_event_error exception has occured, error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
429: END IF;
430:
431: WHEN OTHERS THEN
432: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
433: IF (g_debug = 1) THEN
434: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_ONHAND_BALANCE', 9);
435: END IF;
436:

Line 601: if l_return_status <> rcv_error_pkg.g_ret_sts_success then

597: inv_trx_util_pub.TRACE('Send_Onhand_Document.l_return_status is ' || l_return_status, 'INV_ONHAND_BALANCE', 9);
598: inv_trx_util_pub.TRACE('Exiting Send_Document call', 'INV_ONHAND_BALANCE', 9);
599: end if;
600:
601: if l_return_status <> rcv_error_pkg.g_ret_sts_success then
602: l_ret :=fnd_concurrent.set_completion_status('ERROR', 'Error');
603: end if;
604:
605: COMMIT;