DBA Data[Home] [Help]

APPS.RCV_OPSM_DLV_BE_PKG dependencies on RCV_ERROR_PKG

Line 538: x_return_status := rcv_error_pkg.G_RET_STS_SUCCESS;

534:
535:
536:
537:
538: x_return_status := rcv_error_pkg.G_RET_STS_SUCCESS;
539: l_msg_data:='Data Fetched Into Table Type';
540: x_msg_data:=l_msg_data;
541:
542: p_out_rmaheader_info :=l_headerinfo_tab;

Line 551: x_return_status :=rcv_error_pkg.g_ret_sts_error;

547:
548: EXCEPTION
549: WHEN NO_DATA_FOUND THEN
550: asn_debug.put_line(l_module_name||'No Data Found.Oracle error message is '|| substr(SQLERRM,1,200),fnd_log.level_error);
551: x_return_status :=rcv_error_pkg.g_ret_sts_error;
552: l_msg_data:='NO DATA FOUND -ERROR';
553: x_msg_data:=l_msg_data;
554:
555: WHEN OTHERS THEN

Line 559: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;

555: WHEN OTHERS THEN
556: IF g_asn_debug <>'Y' THEN
557: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
558: END IF;
559: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;
560: l_msg_data := SQLERRM ||' at RCV_OPSM_DLV_BE_PKG.RCV_OPSM_DLV_EVENT';
561: x_msg_data := l_msg_data;
562:
563: END RCV_OPSM_DLV_EVENT;

Line 648: x_return_status:=rcv_error_pkg.g_ret_sts_error;

644: EXCEPTION
645: WHEN NO_DATA_FOUND THEN
646: l_count:=0;
647: p_opsmexist:='N';
648: x_return_status:=rcv_error_pkg.g_ret_sts_error;
649: l_msg_data:='NO DATA FOUND';
650: x_msg_data:=l_msg_data;
651: WHEN OTHERS THEN
652: l_count:=0;

Line 654: x_return_status :=rcv_error_pkg.g_ret_sts_unexp_error;

650: x_msg_data:=l_msg_data;
651: WHEN OTHERS THEN
652: l_count:=0;
653: p_opsmexist:='N';
654: x_return_status :=rcv_error_pkg.g_ret_sts_unexp_error;
655: l_msg_data:='UNEXPECTED ERROR';
656: x_msg_data:=l_msg_data;
657: END;
658:

Line 681: x_return_status := rcv_error_pkg.G_RET_STS_SUCCESS;

677: END IF;
678: END IF;
679:
680:
681: x_return_status := rcv_error_pkg.G_RET_STS_SUCCESS;
682:
683: EXCEPTION
684: WHEN OTHERS THEN
685: l_count:=0;

Line 693: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;

689: asn_debug.put_line(l_module_name||'OPSM INTEGRATED EXIST'||p_opsmexist);
690: asn_debug.put_line(l_module_name||'Unexpected error has occured. Oracle error message is '||substr(SQLERRM,1,200)||fnd_log.level_error);
691: END IF;
692:
693: x_return_status := rcv_error_pkg.G_RET_STS_UNEXP_ERROR;
694:
695: l_msg_data := SQLERRM ||' at RCV_OPSM_DLV_BE_PKG.RCV_OPSM_CHECK';
696: x_msg_data := l_msg_data;
697: END RCV_OPSM_CHECK;