APPS.OKC_INST_CND_PUB dependencies on OKC_API

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

15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_instcnd_inp_rec IN INSTCND_INP_REC) IS
18: l_api_name CONSTANT VARCHAR2(30) := 'inst_condition';
19: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: BEGIN
21: -- Call start activity to create savepoint ,check compatibility
22: -- and initialize the message list
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 23: l_return_status := OKC_API.START_ACTIVITY(l_api_name

19: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: BEGIN
21: -- Call start activity to create savepoint ,check compatibility
22: -- and initialize the message list
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name
24: ,p_init_msg_list
25: ,'_PUB'
26: ,x_return_status
27: );

Line 29: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

25: ,'_PUB'
26: ,x_return_status
27: );
28: -- Check if activity started successfully
29: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
30: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
32: RAISE OKC_API.G_EXCEPTION_ERROR;
33: END IF;

Line 30: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

26: ,x_return_status
27: );
28: -- Check if activity started successfully
29: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
30: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
32: RAISE OKC_API.G_EXCEPTION_ERROR;
33: END IF;
34:

Line 31: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

27: );
28: -- Check if activity started successfully
29: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
30: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
32: RAISE OKC_API.G_EXCEPTION_ERROR;
33: END IF;
34:
35: -- Instantiate the condition, call process api

Line 32: RAISE OKC_API.G_EXCEPTION_ERROR;

28: -- Check if activity started successfully
29: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
30: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
31: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
32: RAISE OKC_API.G_EXCEPTION_ERROR;
33: END IF;
34:
35: -- Instantiate the condition, call process api
36: okc_inst_cnd_pvt.inst_condition(

Line 44: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

40: x_msg_count => x_msg_count,
41: x_msg_data => x_msg_data,
42: p_instcnd_inp_rec => p_instcnd_inp_rec);
43:
44: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 47: WHEN OKC_API.G_EXCEPTION_ERROR THEN

43:
44: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: ( l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',

Line 48: x_return_status := OKC_API.HANDLE_EXCEPTIONS

44: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
45:
46: EXCEPTION
47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: ( l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,

Line 51: 'OKC_API.G_RET_STS_ERROR',

47: WHEN OKC_API.G_EXCEPTION_ERROR THEN
48: x_return_status := OKC_API.HANDLE_EXCEPTIONS
49: ( l_api_name,
50: G_PKG_NAME,
51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

51: 'OKC_API.G_RET_STS_ERROR',
52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: ( l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 56: x_return_status := OKC_API.HANDLE_EXCEPTIONS

52: x_msg_count,
53: x_msg_data,
54: '_PUB');
55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: ( l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',
60: x_msg_count,

Line 59: 'OKC_API.G_RET_STS_UNEXP_ERROR',

55: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: ( l_api_name,
58: G_PKG_NAME,
59: 'OKC_API.G_RET_STS_UNEXP_ERROR',
60: x_msg_count,
61: x_msg_data,
62: '_PUB');
63: -- notify caller of an unexpected error

Line 64: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

60: x_msg_count,
61: x_msg_data,
62: '_PUB');
63: -- notify caller of an unexpected error
64: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
65: WHEN OTHERS THEN
66: x_return_status := OKC_API.HANDLE_EXCEPTIONS
67: ( l_api_name,
68: G_PKG_NAME,

Line 66: x_return_status := OKC_API.HANDLE_EXCEPTIONS

62: '_PUB');
63: -- notify caller of an unexpected error
64: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
65: WHEN OTHERS THEN
66: x_return_status := OKC_API.HANDLE_EXCEPTIONS
67: ( l_api_name,
68: G_PKG_NAME,
69: 'OTHERS',
70: x_msg_count,