DBA Data[Home] [Help]

APPS.INV_TRANSACTIONS_HISTORY_PKG dependencies on RCV_ERROR_PKG

Line 65: x_return_status := rcv_error_pkg.g_ret_sts_success;

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;
67:
68: -- First check for null values
69: IF (

Line 330: x_return_status := rcv_error_pkg.g_ret_sts_error;

326: END IF;
327: ELSE
328:
329: -- Not Null checks failed. Return Error
330: x_return_status := rcv_error_pkg.g_ret_sts_error;
331:
332: END IF; -- if p_txns_history_rec columns are not null
333:
334: if (g_debug = 1) then

Line 340: x_return_status := rcv_error_pkg.g_ret_sts_error;

336: end if;
337:
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

Line 345: 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
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

Line 350: 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
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

Line 355: 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
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

Line 360: 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
362: inv_trx_util_pub.TRACE('invalid_document_type exception has occured.', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
363: end if;
364: WHEN Others THEN

Line 365: 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
367: inv_trx_util_pub.TRACE('Unexpected error has occured. Oracle error message is '|| SQLERRM, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
368: end if;
369:

Line 432: x_return_status := rcv_error_pkg.g_ret_sts_success;

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:
434: OPEN txns_history_cur;
435: FETCH txns_history_cur INTO p_txns_history_rec;
436:

Line 454: x_return_status := rcv_error_pkg.g_ret_sts_error;

450: IF(txns_history_cur%ISOPEN) THEN
451: CLOSE txns_history_cur;
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:

Line 460: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;

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

Line 524: x_return_status := rcv_error_pkg.g_ret_sts_success;

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:
526: l_txn_hist_rec.transaction_id := p_transaction_id;
527: l_txn_hist_rec.document_type := p_document_type;
528: l_txn_hist_rec.document_direction := p_document_direction;

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

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;
555: END IF;
556:
557: EXCEPTION

Line 559: x_return_status := rcv_error_pkg.g_ret_sts_error;

555: END IF;
556:
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

Line 564: x_return_status := rcv_error_pkg.g_ret_sts_unexp_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
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;