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:
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;
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:
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:
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;
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;
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
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:
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:
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:
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:
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:
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;