DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_HISTORY_PKG dependencies on RCV_ERROR_PKG

Line 64: x_return_status := rcv_error_pkg.g_ret_sts_success;

60: asn_debug.put_line('Entity number is '||p_txns_history_Rec.entity_number);
61: asn_debug.put_line('Transaction status is '||p_txns_history_Rec.transaction_status);
62: END IF;
63:
64: x_return_status := rcv_error_pkg.g_ret_sts_success;
65: l_xml_document_id := P_xml_document_id;
66:
67: IF (g_asn_debug = 'Y') THEN
68: asn_debug.put_line('l_xml_document_id is '|| to_char(l_xml_document_id));

Line 371: x_return_status := rcv_error_pkg.g_ret_sts_error;

367: END IF;
368: ELSE
369:
370: -- Not Null checks failed. Return Error
371: x_return_status := rcv_error_pkg.g_ret_sts_error;
372:
373: END IF; -- if p_txns_history_rec columns are not null
374:
375: IF (g_asn_debug = 'Y') THEN

Line 381: x_return_status := rcv_error_pkg.g_ret_sts_error;

377: END IF;
378:
379: EXCEPTION
380: WHEN invalid_status THEN
381: x_return_status := rcv_error_pkg.g_ret_sts_error;
382: IF (g_asn_debug = 'Y') THEN
383: asn_debug.put_line('invalid_status exception has occured.');
384: END IF;
385: WHEN invalid_action THEN

Line 386: x_return_status := rcv_error_pkg.g_ret_sts_error;

382: IF (g_asn_debug = 'Y') THEN
383: asn_debug.put_line('invalid_status exception has occured.');
384: END IF;
385: WHEN invalid_action THEN
386: x_return_status := rcv_error_pkg.g_ret_sts_error;
387: IF (g_asn_debug = 'Y') THEN
388: asn_debug.put_line('invalid_action exception has occured.');
389: END IF;
390: WHEN invalid_entity_type THEN

Line 391: x_return_status := rcv_error_pkg.g_ret_sts_error;

387: IF (g_asn_debug = 'Y') THEN
388: asn_debug.put_line('invalid_action exception has occured.');
389: END IF;
390: WHEN invalid_entity_type THEN
391: x_return_status := rcv_error_pkg.g_ret_sts_error;
392: IF (g_asn_debug = 'Y') THEN
393: asn_debug.put_line('invalid_entity_type exception has occured.');
394: END IF;
395: WHEN invalid_direction THEN

Line 396: x_return_status := rcv_error_pkg.g_ret_sts_error;

392: IF (g_asn_debug = 'Y') THEN
393: asn_debug.put_line('invalid_entity_type exception has occured.');
394: END IF;
395: WHEN invalid_direction THEN
396: x_return_status := rcv_error_pkg.g_ret_sts_error;
397: IF (g_asn_debug = 'Y') THEN
398: asn_debug.put_line('invalid_direction exception has occured.');
399: END IF;
400: WHEN invalid_document_type THEN

Line 401: x_return_status := rcv_error_pkg.g_ret_sts_error;

397: IF (g_asn_debug = 'Y') THEN
398: asn_debug.put_line('invalid_direction exception has occured.');
399: END IF;
400: WHEN invalid_document_type THEN
401: x_return_status := rcv_error_pkg.g_ret_sts_error;
402: IF (g_asn_debug = 'Y') THEN
403: asn_debug.put_line('invalid_document_type exception has occured.');
404: END IF;
405: WHEN Others THEN

Line 406: x_return_status := rcv_error_pkg.g_ret_sts_error;

402: IF (g_asn_debug = 'Y') THEN
403: asn_debug.put_line('invalid_document_type exception has occured.');
404: END IF;
405: WHEN Others THEN
406: x_return_status := rcv_error_pkg.g_ret_sts_error;
407: IF (g_asn_debug = 'Y') THEN
408: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
409: END IF;
410:

Line 470: x_return_status := rcv_error_pkg.g_ret_sts_success;

466: IF (g_asn_debug = 'Y') THEN
467: asn_debug.put_line('Entering Get_Txns_History');
468: END IF;
469:
470: x_return_status := rcv_error_pkg.g_ret_sts_success;
471:
472: OPEN txns_history_cur;
473: FETCH txns_history_cur INTO p_txns_history_rec;
474:

Line 492: x_return_status := rcv_error_pkg.g_ret_sts_error;

488: IF(txns_history_cur%ISOPEN) THEN
489: CLOSE txns_history_cur;
490: END IF;
491:
492: x_return_status := rcv_error_pkg.g_ret_sts_error;
493: IF (g_asn_debug = 'Y') THEN
494: asn_debug.put_line('no_record_found exception has occured.');
495: END IF;
496:

Line 498: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;

494: asn_debug.put_line('no_record_found exception has occured.');
495: END IF;
496:
497: WHEN Others THEN
498: x_return_status := rcv_error_pkg.g_ret_sts_unexp_error;
499: IF (g_asn_debug = 'Y') THEN
500: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
501: END IF;
502: END Get_Txns_History;