DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_INTERFACE_PUB dependencies on OKC_API

Line 9: l_init_msg_list VARCHAR2(1) := OKC_API.G_TRUE;

5: ret_code OUT NOCOPY NUMBER) IS
6: l_return_status VARCHAR2(1);
7: l_msg_count NUMBER;
8: l_msg_data VARCHAR2(2000);
9: l_init_msg_list VARCHAR2(1) := OKC_API.G_TRUE;
10: l_api_version CONSTANT NUMBER := 1;
11: l_api_name VARCHAR2(30) := 'TERMINATION_INTERFACE';
12: BEGIN
13: OKL_AM_TERMNT_INTERFACE_PVT.termination_interface(p_api_version => l_api_version

Line 21: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

17: ,x_return_status => l_return_status
18: ,err_buf => err_buf
19: ,ret_code => ret_code);
20:
21: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
22: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
24: RAISE OKC_API.G_EXCEPTION_ERROR;
25: END IF;

Line 22: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

18: ,err_buf => err_buf
19: ,ret_code => ret_code);
20:
21: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
22: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
24: RAISE OKC_API.G_EXCEPTION_ERROR;
25: END IF;
26:

Line 23: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

19: ,ret_code => ret_code);
20:
21: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
22: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
24: RAISE OKC_API.G_EXCEPTION_ERROR;
25: END IF;
26:
27: EXCEPTION

Line 24: RAISE OKC_API.G_EXCEPTION_ERROR;

20:
21: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
22: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
23: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
24: RAISE OKC_API.G_EXCEPTION_ERROR;
25: END IF;
26:
27: EXCEPTION
28: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 28: WHEN OKC_API.G_EXCEPTION_ERROR THEN

24: RAISE OKC_API.G_EXCEPTION_ERROR;
25: END IF;
26:
27: EXCEPTION
28: WHEN OKC_API.G_EXCEPTION_ERROR THEN
29: l_return_status := OKC_API.HANDLE_EXCEPTIONS(l_api_name,
30: G_PKG_NAME,
31: 'OKC_API.G_RET_STS_ERROR',
32: l_msg_count,

Line 29: l_return_status := OKC_API.HANDLE_EXCEPTIONS(l_api_name,

25: END IF;
26:
27: EXCEPTION
28: WHEN OKC_API.G_EXCEPTION_ERROR THEN
29: l_return_status := OKC_API.HANDLE_EXCEPTIONS(l_api_name,
30: G_PKG_NAME,
31: 'OKC_API.G_RET_STS_ERROR',
32: l_msg_count,
33: l_msg_data,

Line 31: 'OKC_API.G_RET_STS_ERROR',

27: EXCEPTION
28: WHEN OKC_API.G_EXCEPTION_ERROR THEN
29: l_return_status := OKC_API.HANDLE_EXCEPTIONS(l_api_name,
30: G_PKG_NAME,
31: 'OKC_API.G_RET_STS_ERROR',
32: l_msg_count,
33: l_msg_data,
34: '_PVT');
35: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 35: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

31: 'OKC_API.G_RET_STS_ERROR',
32: l_msg_count,
33: l_msg_data,
34: '_PVT');
35: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
36: l_return_status :=OKC_API.HANDLE_EXCEPTIONS(l_api_name,
37: G_PKG_NAME,
38: 'OKC_API.G_RET_STS_UNEXP_ERROR',
39: l_msg_count,

Line 36: l_return_status :=OKC_API.HANDLE_EXCEPTIONS(l_api_name,

32: l_msg_count,
33: l_msg_data,
34: '_PVT');
35: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
36: l_return_status :=OKC_API.HANDLE_EXCEPTIONS(l_api_name,
37: G_PKG_NAME,
38: 'OKC_API.G_RET_STS_UNEXP_ERROR',
39: l_msg_count,
40: l_msg_data,

Line 38: 'OKC_API.G_RET_STS_UNEXP_ERROR',

34: '_PVT');
35: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
36: l_return_status :=OKC_API.HANDLE_EXCEPTIONS(l_api_name,
37: G_PKG_NAME,
38: 'OKC_API.G_RET_STS_UNEXP_ERROR',
39: l_msg_count,
40: l_msg_data,
41: '_PVT');
42: WHEN OTHERS THEN

Line 43: OKC_API.set_message(p_app_name => g_app_name,

39: l_msg_count,
40: l_msg_data,
41: '_PVT');
42: WHEN OTHERS THEN
43: OKC_API.set_message(p_app_name => g_app_name,
44: p_msg_name => g_unexpected_error,
45: p_token1 => g_sqlcode_token,
46: p_token1_value => sqlcode,
47: p_token2 => g_sqlerrm_token,