APPS.OKL_CURE_REQ_AMT_PUB dependencies on OKC_API

Line 21: x_return_status := OKC_API.START_ACTIVITY(

17: l_cure_req_tbl cure_req_tbl_type := p_cure_req_tbl;
18:
19: BEGIN
20:
21: x_return_status := OKC_API.START_ACTIVITY(
22: p_api_name => l_api_name,
23: p_pkg_name => g_pkg_name,
24: p_init_msg_list => p_init_msg_list,
25: l_api_version => l_api_version,

Line 31: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

27: p_api_type => g_api_type,
28: x_return_status => x_return_status);
29:
30: -- check if activity started successfully
31: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
34: raise OKC_API.G_EXCEPTION_ERROR;
35: End If;

Line 32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

28: x_return_status => x_return_status);
29:
30: -- check if activity started successfully
31: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
34: raise OKC_API.G_EXCEPTION_ERROR;
35: End If;
36:

Line 33: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

29:
30: -- check if activity started successfully
31: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
34: raise OKC_API.G_EXCEPTION_ERROR;
35: End If;
36:
37: OKL_CURE_REQ_AMT_PVT.update_cure_request(

Line 34: raise OKC_API.G_EXCEPTION_ERROR;

30: -- check if activity started successfully
31: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
34: raise OKC_API.G_EXCEPTION_ERROR;
35: End If;
36:
37: OKL_CURE_REQ_AMT_PVT.update_cure_request(
38: p_api_version => p_api_version,

Line 47: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

43: p_cure_req_tbl => l_cure_req_tbl,
44: x_cure_req_tbl => x_cure_req_tbl
45: );
46:
47: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
48: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
50: raise OKC_API.G_EXCEPTION_ERROR;
51: End If;

Line 48: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

44: x_cure_req_tbl => x_cure_req_tbl
45: );
46:
47: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
48: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
50: raise OKC_API.G_EXCEPTION_ERROR;
51: End If;
52:

Line 49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

45: );
46:
47: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
48: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
50: raise OKC_API.G_EXCEPTION_ERROR;
51: End If;
52:
53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 50: raise OKC_API.G_EXCEPTION_ERROR;

46:
47: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
48: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
50: raise OKC_API.G_EXCEPTION_ERROR;
51: End If;
52:
53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
54:

Line 53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

49: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
50: raise OKC_API.G_EXCEPTION_ERROR;
51: End If;
52:
53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
54:
55: EXCEPTION
56: when OKC_API.G_EXCEPTION_ERROR then
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 56: when OKC_API.G_EXCEPTION_ERROR then

52:
53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
54:
55: EXCEPTION
56: when OKC_API.G_EXCEPTION_ERROR then
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
58: p_api_name => l_api_name,
59: p_pkg_name => g_pkg_name,
60: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 57: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

53: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
54:
55: EXCEPTION
56: when OKC_API.G_EXCEPTION_ERROR then
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
58: p_api_name => l_api_name,
59: p_pkg_name => g_pkg_name,
60: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count => x_msg_count,

Line 60: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

56: when OKC_API.G_EXCEPTION_ERROR then
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
58: p_api_name => l_api_name,
59: p_pkg_name => g_pkg_name,
60: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count => x_msg_count,
62: x_msg_data => x_msg_data,
63: p_api_type => g_api_type);
64:

Line 65: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

61: x_msg_count => x_msg_count,
62: x_msg_data => x_msg_data,
63: p_api_type => g_api_type);
64:
65: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
66: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
67: p_api_name => l_api_name,
68: p_pkg_name => g_pkg_name,
69: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 66: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

62: x_msg_data => x_msg_data,
63: p_api_type => g_api_type);
64:
65: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
66: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
67: p_api_name => l_api_name,
68: p_pkg_name => g_pkg_name,
69: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
70: x_msg_count => x_msg_count,

Line 69: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

65: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
66: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
67: p_api_name => l_api_name,
68: p_pkg_name => g_pkg_name,
69: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
70: x_msg_count => x_msg_count,
71: x_msg_data => x_msg_data,
72: p_api_type => g_api_type);
73:

Line 75: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

71: x_msg_data => x_msg_data,
72: p_api_type => g_api_type);
73:
74: when OTHERS then
75: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
76: p_api_name => l_api_name,
77: p_pkg_name => g_pkg_name,
78: p_exc_name => 'OTHERS',
79: x_msg_count => x_msg_count,

Line 102: x_return_status := OKC_API.START_ACTIVITY(

98: l_cure_report_id number := p_cure_report_id;
99:
100: BEGIN
101:
102: x_return_status := OKC_API.START_ACTIVITY(
103: p_api_name => l_api_name,
104: p_pkg_name => g_pkg_name,
105: p_init_msg_list => p_init_msg_list,
106: l_api_version => l_api_version,

Line 112: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

108: p_api_type => g_api_type,
109: x_return_status => x_return_status);
110:
111: -- check if activity started successfully
112: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
115: raise OKC_API.G_EXCEPTION_ERROR;
116: End If;

Line 113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

109: x_return_status => x_return_status);
110:
111: -- check if activity started successfully
112: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
115: raise OKC_API.G_EXCEPTION_ERROR;
116: End If;
117:

Line 114: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

110:
111: -- check if activity started successfully
112: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
115: raise OKC_API.G_EXCEPTION_ERROR;
116: End If;
117:
118: OKL_CURE_REQ_AMT_PVT.update_cure_request(

Line 115: raise OKC_API.G_EXCEPTION_ERROR;

111: -- check if activity started successfully
112: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
113: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
115: raise OKC_API.G_EXCEPTION_ERROR;
116: End If;
117:
118: OKL_CURE_REQ_AMT_PVT.update_cure_request(
119: p_api_version => p_api_version,

Line 128: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

124: p_vendor_id => l_vendor_id,
125: p_cure_report_id => l_cure_report_id
126: );
127:
128: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
129: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
131: raise OKC_API.G_EXCEPTION_ERROR;
132: End If;

Line 129: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

125: p_cure_report_id => l_cure_report_id
126: );
127:
128: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
129: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
131: raise OKC_API.G_EXCEPTION_ERROR;
132: End If;
133:

Line 130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

126: );
127:
128: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
129: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
131: raise OKC_API.G_EXCEPTION_ERROR;
132: End If;
133:
134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 131: raise OKC_API.G_EXCEPTION_ERROR;

127:
128: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
129: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
131: raise OKC_API.G_EXCEPTION_ERROR;
132: End If;
133:
134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
135:

Line 134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

130: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
131: raise OKC_API.G_EXCEPTION_ERROR;
132: End If;
133:
134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
135:
136: EXCEPTION
137: when OKC_API.G_EXCEPTION_ERROR then
138: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 137: when OKC_API.G_EXCEPTION_ERROR then

133:
134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
135:
136: EXCEPTION
137: when OKC_API.G_EXCEPTION_ERROR then
138: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => g_pkg_name,
141: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 138: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

134: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
135:
136: EXCEPTION
137: when OKC_API.G_EXCEPTION_ERROR then
138: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => g_pkg_name,
141: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
142: x_msg_count => x_msg_count,

Line 141: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

137: when OKC_API.G_EXCEPTION_ERROR then
138: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
139: p_api_name => l_api_name,
140: p_pkg_name => g_pkg_name,
141: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,
144: p_api_type => g_api_type);
145:

Line 146: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,
144: p_api_type => g_api_type);
145:
146: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
147: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
148: p_api_name => l_api_name,
149: p_pkg_name => g_pkg_name,
150: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 147: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

143: x_msg_data => x_msg_data,
144: p_api_type => g_api_type);
145:
146: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
147: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
148: p_api_name => l_api_name,
149: p_pkg_name => g_pkg_name,
150: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
151: x_msg_count => x_msg_count,

Line 150: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

146: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
147: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
148: p_api_name => l_api_name,
149: p_pkg_name => g_pkg_name,
150: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
151: x_msg_count => x_msg_count,
152: x_msg_data => x_msg_data,
153: p_api_type => g_api_type);
154:

Line 156: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

152: x_msg_data => x_msg_data,
153: p_api_type => g_api_type);
154:
155: when OTHERS then
156: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
157: p_api_name => l_api_name,
158: p_pkg_name => g_pkg_name,
159: p_exc_name => 'OTHERS',
160: x_msg_count => x_msg_count,