APPS.PV_QA_CHECK_PVT dependencies on OKC_API

Line 22: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

18: x_qa_return_status OUT NOCOPY VARCHAR2,
19: x_msg_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_2000)
20: --x_err_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100)
21: IS
22: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
23: l_api_name CONSTANT VARCHAR2(30) := 'execute_qa_check_list';
24: l_api_type CONSTANT VARCHAR2(5) := '_PVT';
25: l_api_version CONSTANT NUMBER := 1.0;
26: l_qa_result_tbl OKC_TERMS_QA_GRP.qa_result_tbl_type;

Line 73: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

69: --p_qa_terms_only => null
70: );
71:
72:
73: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: raise OKC_API.G_EXCEPTION_ERROR;
77: END IF;

Line 74: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

70: );
71:
72:
73: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: raise OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:

Line 75: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

71:
72:
73: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: raise OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:
79: IF (x_qa_return_status = OKC_TERMS_QA_GRP.G_QA_STS_ERROR or x_qa_return_status = OKC_TERMS_QA_GRP.G_QA_STS_WARNING) THEN

Line 76: raise OKC_API.G_EXCEPTION_ERROR;

72:
73: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
74: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
75: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
76: raise OKC_API.G_EXCEPTION_ERROR;
77: END IF;
78:
79: IF (x_qa_return_status = OKC_TERMS_QA_GRP.G_QA_STS_ERROR or x_qa_return_status = OKC_TERMS_QA_GRP.G_QA_STS_WARNING) THEN
80:

Line 94: WHEN OKC_API.G_EXCEPTION_ERROR THEN

90: END IF;
91:
92: EXCEPTION
93:
94: WHEN OKC_API.G_EXCEPTION_ERROR THEN
95: x_return_status := OKC_API.HANDLE_EXCEPTIONS( l_api_name
96: ,G_PKG_NAME
97: ,'OKC_API.G_RET_STS_ERROR'
98: ,x_msg_count

Line 95: x_return_status := OKC_API.HANDLE_EXCEPTIONS( l_api_name

91:
92: EXCEPTION
93:
94: WHEN OKC_API.G_EXCEPTION_ERROR THEN
95: x_return_status := OKC_API.HANDLE_EXCEPTIONS( l_api_name
96: ,G_PKG_NAME
97: ,'OKC_API.G_RET_STS_ERROR'
98: ,x_msg_count
99: ,x_msg_data

Line 97: ,'OKC_API.G_RET_STS_ERROR'

93:
94: WHEN OKC_API.G_EXCEPTION_ERROR THEN
95: x_return_status := OKC_API.HANDLE_EXCEPTIONS( l_api_name
96: ,G_PKG_NAME
97: ,'OKC_API.G_RET_STS_ERROR'
98: ,x_msg_count
99: ,x_msg_data
100: ,l_api_type);
101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

97: ,'OKC_API.G_RET_STS_ERROR'
98: ,x_msg_count
99: ,x_msg_data
100: ,l_api_type);
101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
102: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name
103: ,G_PKG_NAME
104: ,'OKC_API.G_RET_STS_UNEXP_ERROR'
105: ,x_msg_count

Line 102: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name

98: ,x_msg_count
99: ,x_msg_data
100: ,l_api_type);
101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
102: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name
103: ,G_PKG_NAME
104: ,'OKC_API.G_RET_STS_UNEXP_ERROR'
105: ,x_msg_count
106: ,x_msg_data

Line 104: ,'OKC_API.G_RET_STS_UNEXP_ERROR'

100: ,l_api_type);
101: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
102: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name
103: ,G_PKG_NAME
104: ,'OKC_API.G_RET_STS_UNEXP_ERROR'
105: ,x_msg_count
106: ,x_msg_data
107: ,l_api_type);
108: WHEN OTHERS THEN

Line 109: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name

105: ,x_msg_count
106: ,x_msg_data
107: ,l_api_type);
108: WHEN OTHERS THEN
109: x_return_status :=OKC_API.HANDLE_EXCEPTIONS( l_api_name
110: ,G_PKG_NAME
111: ,'OTHERS'
112: ,x_msg_count
113: ,x_msg_data