APPS.OKS_ENTITLEMENTS_PUB dependencies on OKC_API

Line 21: l_return_status := OKC_API.G_RET_STS_SUCCESS;

17: l_return_status Varchar2(1);
18: l_api_name CONSTANT VARCHAR2(30) := 'check_coverage_times';
19: --l_api_version CONSTANT NUMBER := 1.0;
20: BEGIN
21: l_return_status := OKC_API.G_RET_STS_SUCCESS;
22:
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name
24: ,p_init_msg_list
25: ,'_PUB'

Line 23: l_return_status := OKC_API.START_ACTIVITY(l_api_name

19: --l_api_version CONSTANT NUMBER := 1.0;
20: BEGIN
21: l_return_status := OKC_API.G_RET_STS_SUCCESS;
22:
23: l_return_status := OKC_API.START_ACTIVITY(l_api_name
24: ,p_init_msg_list
25: ,'_PUB'
26: ,x_return_status
27: );

Line 28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

24: ,p_init_msg_list
25: ,'_PUB'
26: ,x_return_status
27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;

Line 29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

26: ,x_return_status
27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;
33:
34: OKS_ENTITLEMENTS_PVT.check_coverage_times

Line 31: RAISE OKC_API.G_EXCEPTION_ERROR;

27: );
28: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
29: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
31: RAISE OKC_API.G_EXCEPTION_ERROR;
32: END IF;
33:
34: OKS_ENTITLEMENTS_PVT.check_coverage_times
35: (p_api_version

Line 47: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

43: ,x_msg_count
44: ,x_msg_data
45: ,x_covered_yn);
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_msg_data
45: ,x_covered_yn);
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: ,x_covered_yn);
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_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_data);
54:

Line 53: OKC_API.END_ACTIVITY(x_msg_count,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_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_data);
54:
55: EXCEPTION
56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: '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_data);
54:
55: EXCEPTION
56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,

Line 60: 'OKC_API.G_RET_STS_ERROR',

56: WHEN OKC_API.G_EXCEPTION_ERROR THEN
57: x_return_status := OKC_API.HANDLE_EXCEPTIONS
58: (l_api_name,
59: G_PKG_NAME,
60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

60: 'OKC_API.G_RET_STS_ERROR',
61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name,
67: G_PKG_NAME,
68: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 65: x_return_status := OKC_API.HANDLE_EXCEPTIONS

61: x_msg_count,
62: x_msg_data,
63: '_PUB');
64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name,
67: G_PKG_NAME,
68: 'OKC_API.G_RET_STS_UNEXP_ERROR',
69: x_msg_count,

Line 68: 'OKC_API.G_RET_STS_UNEXP_ERROR',

64: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name,
67: G_PKG_NAME,
68: 'OKC_API.G_RET_STS_UNEXP_ERROR',
69: x_msg_count,
70: x_msg_data,
71: '_PUB');
72: WHEN OTHERS THEN

Line 73: x_return_status := OKC_API.HANDLE_EXCEPTIONS

69: x_msg_count,
70: x_msg_data,
71: '_PUB');
72: WHEN OTHERS THEN
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (l_api_name,
75: G_PKG_NAME,
76: 'OTHERS',
77: x_msg_count,

Line 107: l_return_status := OKC_API.G_RET_STS_SUCCESS;

103: l_return_status Varchar2(1);
104: l_api_name CONSTANT VARCHAR2(30) := 'check_reaction_times';
105: --l_api_version CONSTANT NUMBER := 1.0;
106: BEGIN
107: l_return_status := OKC_API.G_RET_STS_SUCCESS;
108:
109: l_return_status := OKC_API.START_ACTIVITY(l_api_name
110: ,p_init_msg_list
111: ,'_PUB'

Line 109: l_return_status := OKC_API.START_ACTIVITY(l_api_name

105: --l_api_version CONSTANT NUMBER := 1.0;
106: BEGIN
107: l_return_status := OKC_API.G_RET_STS_SUCCESS;
108:
109: l_return_status := OKC_API.START_ACTIVITY(l_api_name
110: ,p_init_msg_list
111: ,'_PUB'
112: ,x_return_status
113: );

Line 114: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

110: ,p_init_msg_list
111: ,'_PUB'
112: ,x_return_status
113: );
114: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;

Line 115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

111: ,'_PUB'
112: ,x_return_status
113: );
114: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;
119: /*vgujarat - modified for access hour ER 9675504*/

Line 116: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

112: ,x_return_status
113: );
114: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;
119: /*vgujarat - modified for access hour ER 9675504*/
120: OKS_ENTITLEMENTS_PVT.check_reaction_times

Line 117: RAISE OKC_API.G_EXCEPTION_ERROR;

113: );
114: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
117: RAISE OKC_API.G_EXCEPTION_ERROR;
118: END IF;
119: /*vgujarat - modified for access hour ER 9675504*/
120: OKS_ENTITLEMENTS_PVT.check_reaction_times
121: (p_api_version

Line 139: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

135: ,P_cust_id
136: ,P_cust_site_id
137: ,P_cust_loc_id);
138:
139: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;

Line 140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

136: ,P_cust_site_id
137: ,P_cust_loc_id);
138:
139: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:

Line 141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

137: ,P_cust_loc_id);
138:
139: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 142: RAISE OKC_API.G_EXCEPTION_ERROR;

138:
139: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
146:

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

141: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
142: RAISE OKC_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
146:
147: EXCEPTION
148: WHEN OKC_API.G_EXCEPTION_ERROR THEN
149: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 148: WHEN OKC_API.G_EXCEPTION_ERROR THEN

144:
145: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
146:
147: EXCEPTION
148: WHEN OKC_API.G_EXCEPTION_ERROR THEN
149: x_return_status := OKC_API.HANDLE_EXCEPTIONS
150: (l_api_name,
151: G_PKG_NAME,
152: 'OKC_API.G_RET_STS_ERROR',

Line 149: x_return_status := OKC_API.HANDLE_EXCEPTIONS

145: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
146:
147: EXCEPTION
148: WHEN OKC_API.G_EXCEPTION_ERROR THEN
149: x_return_status := OKC_API.HANDLE_EXCEPTIONS
150: (l_api_name,
151: G_PKG_NAME,
152: 'OKC_API.G_RET_STS_ERROR',
153: x_msg_count,

Line 152: 'OKC_API.G_RET_STS_ERROR',

148: WHEN OKC_API.G_EXCEPTION_ERROR THEN
149: x_return_status := OKC_API.HANDLE_EXCEPTIONS
150: (l_api_name,
151: G_PKG_NAME,
152: 'OKC_API.G_RET_STS_ERROR',
153: x_msg_count,
154: x_msg_data,
155: '_PUB');
156: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 156: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

152: 'OKC_API.G_RET_STS_ERROR',
153: x_msg_count,
154: x_msg_data,
155: '_PUB');
156: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
157: x_return_status := OKC_API.HANDLE_EXCEPTIONS
158: (l_api_name,
159: G_PKG_NAME,
160: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 157: x_return_status := OKC_API.HANDLE_EXCEPTIONS

153: x_msg_count,
154: x_msg_data,
155: '_PUB');
156: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
157: x_return_status := OKC_API.HANDLE_EXCEPTIONS
158: (l_api_name,
159: G_PKG_NAME,
160: 'OKC_API.G_RET_STS_UNEXP_ERROR',
161: x_msg_count,

Line 160: 'OKC_API.G_RET_STS_UNEXP_ERROR',

156: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
157: x_return_status := OKC_API.HANDLE_EXCEPTIONS
158: (l_api_name,
159: G_PKG_NAME,
160: 'OKC_API.G_RET_STS_UNEXP_ERROR',
161: x_msg_count,
162: x_msg_data,
163: '_PUB');
164: WHEN OTHERS THEN

Line 165: x_return_status := OKC_API.HANDLE_EXCEPTIONS

161: x_msg_count,
162: x_msg_data,
163: '_PUB');
164: WHEN OTHERS THEN
165: x_return_status := OKC_API.HANDLE_EXCEPTIONS
166: (l_api_name,
167: G_PKG_NAME,
168: 'OTHERS',
169: x_msg_count,

Line 189: l_return_status := OKC_API.G_RET_STS_SUCCESS;

185: l_api_name CONSTANT VARCHAR2(30) := 'get_all_contracts';
186: --l_api_version CONSTANT NUMBER := 1.0;
187: BEGIN
188:
189: l_return_status := OKC_API.G_RET_STS_SUCCESS;
190:
191: l_return_status := OKC_API.START_ACTIVITY(l_api_name
192: ,p_init_msg_list
193: ,'_PUB'

Line 191: l_return_status := OKC_API.START_ACTIVITY(l_api_name

187: BEGIN
188:
189: l_return_status := OKC_API.G_RET_STS_SUCCESS;
190:
191: l_return_status := OKC_API.START_ACTIVITY(l_api_name
192: ,p_init_msg_list
193: ,'_PUB'
194: ,x_return_status
195: );

Line 196: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

192: ,p_init_msg_list
193: ,'_PUB'
194: ,x_return_status
195: );
196: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
199: RAISE OKC_API.G_EXCEPTION_ERROR;
200: END IF;

Line 197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

193: ,'_PUB'
194: ,x_return_status
195: );
196: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
199: RAISE OKC_API.G_EXCEPTION_ERROR;
200: END IF;
201:

Line 198: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

194: ,x_return_status
195: );
196: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
199: RAISE OKC_API.G_EXCEPTION_ERROR;
200: END IF;
201:
202: OKS_ENTITLEMENTS_PVT.get_all_contracts

Line 199: RAISE OKC_API.G_EXCEPTION_ERROR;

195: );
196: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
199: RAISE OKC_API.G_EXCEPTION_ERROR;
200: END IF;
201:
202: OKS_ENTITLEMENTS_PVT.get_all_contracts
203: (p_api_version

Line 211: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

207: ,x_msg_count
208: ,x_msg_data
209: ,x_all_contracts);
210:
211: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
214: RAISE OKC_API.G_EXCEPTION_ERROR;
215: END IF;

Line 212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

208: ,x_msg_data
209: ,x_all_contracts);
210:
211: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
214: RAISE OKC_API.G_EXCEPTION_ERROR;
215: END IF;
216:

Line 213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

209: ,x_all_contracts);
210:
211: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
214: RAISE OKC_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 214: RAISE OKC_API.G_EXCEPTION_ERROR;

210:
211: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
212: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
214: RAISE OKC_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
218:

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

213: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
214: RAISE OKC_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
218:
219: EXCEPTION
220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
221: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 220: WHEN OKC_API.G_EXCEPTION_ERROR THEN

216:
217: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
218:
219: EXCEPTION
220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
222: (l_api_name,
223: G_PKG_NAME,
224: 'OKC_API.G_RET_STS_ERROR',

Line 221: x_return_status := OKC_API.HANDLE_EXCEPTIONS

217: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
218:
219: EXCEPTION
220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
222: (l_api_name,
223: G_PKG_NAME,
224: 'OKC_API.G_RET_STS_ERROR',
225: x_msg_count,

Line 224: 'OKC_API.G_RET_STS_ERROR',

220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
221: x_return_status := OKC_API.HANDLE_EXCEPTIONS
222: (l_api_name,
223: G_PKG_NAME,
224: 'OKC_API.G_RET_STS_ERROR',
225: x_msg_count,
226: x_msg_data,
227: '_PUB');
228: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 228: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

224: 'OKC_API.G_RET_STS_ERROR',
225: x_msg_count,
226: x_msg_data,
227: '_PUB');
228: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
230: (l_api_name,
231: G_PKG_NAME,
232: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 229: x_return_status := OKC_API.HANDLE_EXCEPTIONS

225: x_msg_count,
226: x_msg_data,
227: '_PUB');
228: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
230: (l_api_name,
231: G_PKG_NAME,
232: 'OKC_API.G_RET_STS_UNEXP_ERROR',
233: x_msg_count,

Line 232: 'OKC_API.G_RET_STS_UNEXP_ERROR',

228: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
230: (l_api_name,
231: G_PKG_NAME,
232: 'OKC_API.G_RET_STS_UNEXP_ERROR',
233: x_msg_count,
234: x_msg_data,
235: '_PUB');
236: WHEN OTHERS THEN

Line 237: x_return_status := OKC_API.HANDLE_EXCEPTIONS

233: x_msg_count,
234: x_msg_data,
235: '_PUB');
236: WHEN OTHERS THEN
237: x_return_status := OKC_API.HANDLE_EXCEPTIONS
238: (l_api_name,
239: G_PKG_NAME,
240: 'OTHERS',
241: x_msg_count,

Line 260: l_return_status := OKC_API.G_RET_STS_SUCCESS;

256: l_return_status Varchar2(1);
257: l_api_name CONSTANT VARCHAR2(30) := 'get_contract_details';
258: --l_api_version CONSTANT NUMBER := 1.0;
259: BEGIN
260: l_return_status := OKC_API.G_RET_STS_SUCCESS;
261:
262: l_return_status := OKC_API.START_ACTIVITY(l_api_name
263: ,p_init_msg_list
264: ,'_PUB'

Line 262: l_return_status := OKC_API.START_ACTIVITY(l_api_name

258: --l_api_version CONSTANT NUMBER := 1.0;
259: BEGIN
260: l_return_status := OKC_API.G_RET_STS_SUCCESS;
261:
262: l_return_status := OKC_API.START_ACTIVITY(l_api_name
263: ,p_init_msg_list
264: ,'_PUB'
265: ,x_return_status
266: );

Line 267: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

263: ,p_init_msg_list
264: ,'_PUB'
265: ,x_return_status
266: );
267: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
270: RAISE OKC_API.G_EXCEPTION_ERROR;
271: END IF;

Line 268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

264: ,'_PUB'
265: ,x_return_status
266: );
267: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
270: RAISE OKC_API.G_EXCEPTION_ERROR;
271: END IF;
272:

Line 269: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

265: ,x_return_status
266: );
267: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
270: RAISE OKC_API.G_EXCEPTION_ERROR;
271: END IF;
272:
273: OKS_ENTITLEMENTS_PVT.get_contract_details

Line 270: RAISE OKC_API.G_EXCEPTION_ERROR;

266: );
267: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
270: RAISE OKC_API.G_EXCEPTION_ERROR;
271: END IF;
272:
273: OKS_ENTITLEMENTS_PVT.get_contract_details
274: (p_api_version

Line 282: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

278: ,x_msg_count
279: ,x_msg_data
280: ,x_all_lines);
281:
282: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
285: RAISE OKC_API.G_EXCEPTION_ERROR;
286: END IF;

Line 283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

279: ,x_msg_data
280: ,x_all_lines);
281:
282: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
285: RAISE OKC_API.G_EXCEPTION_ERROR;
286: END IF;
287:

Line 284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

280: ,x_all_lines);
281:
282: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
285: RAISE OKC_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 285: RAISE OKC_API.G_EXCEPTION_ERROR;

281:
282: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
285: RAISE OKC_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
289:

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

284: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
285: RAISE OKC_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
289:
290: EXCEPTION
291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 291: WHEN OKC_API.G_EXCEPTION_ERROR THEN

287:
288: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
289:
290: EXCEPTION
291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_ERROR',

Line 292: x_return_status := OKC_API.HANDLE_EXCEPTIONS

288: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
289:
290: EXCEPTION
291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_ERROR',
296: x_msg_count,

Line 295: 'OKC_API.G_RET_STS_ERROR',

291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (l_api_name,
294: G_PKG_NAME,
295: 'OKC_API.G_RET_STS_ERROR',
296: x_msg_count,
297: x_msg_data,
298: '_PUB');
299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

295: 'OKC_API.G_RET_STS_ERROR',
296: x_msg_count,
297: x_msg_data,
298: '_PUB');
299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
301: (l_api_name,
302: G_PKG_NAME,
303: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 300: x_return_status := OKC_API.HANDLE_EXCEPTIONS

296: x_msg_count,
297: x_msg_data,
298: '_PUB');
299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
301: (l_api_name,
302: G_PKG_NAME,
303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
304: x_msg_count,

Line 303: 'OKC_API.G_RET_STS_UNEXP_ERROR',

299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
301: (l_api_name,
302: G_PKG_NAME,
303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
304: x_msg_count,
305: x_msg_data,
306: '_PUB');
307: WHEN OTHERS THEN

Line 308: x_return_status := OKC_API.HANDLE_EXCEPTIONS

304: x_msg_count,
305: x_msg_data,
306: '_PUB');
307: WHEN OTHERS THEN
308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
309: (l_api_name,
310: G_PKG_NAME,
311: 'OTHERS',
312: x_msg_count,

Line 331: l_return_status := OKC_API.G_RET_STS_SUCCESS;

327: l_return_status Varchar2(1);
328: l_api_name CONSTANT VARCHAR2(30) := 'get_coverage_levels';
329: --l_api_version CONSTANT NUMBER := 1.0;
330: BEGIN
331: l_return_status := OKC_API.G_RET_STS_SUCCESS;
332:
333: l_return_status := OKC_API.START_ACTIVITY(l_api_name
334: ,p_init_msg_list
335: ,'_PUB'

Line 333: l_return_status := OKC_API.START_ACTIVITY(l_api_name

329: --l_api_version CONSTANT NUMBER := 1.0;
330: BEGIN
331: l_return_status := OKC_API.G_RET_STS_SUCCESS;
332:
333: l_return_status := OKC_API.START_ACTIVITY(l_api_name
334: ,p_init_msg_list
335: ,'_PUB'
336: ,x_return_status
337: );

Line 338: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

334: ,p_init_msg_list
335: ,'_PUB'
336: ,x_return_status
337: );
338: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
341: RAISE OKC_API.G_EXCEPTION_ERROR;
342: END IF;

Line 339: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

335: ,'_PUB'
336: ,x_return_status
337: );
338: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
341: RAISE OKC_API.G_EXCEPTION_ERROR;
342: END IF;
343:

Line 340: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

336: ,x_return_status
337: );
338: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
341: RAISE OKC_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: OKS_ENTITLEMENTS_PVT.get_coverage_levels

Line 341: RAISE OKC_API.G_EXCEPTION_ERROR;

337: );
338: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
341: RAISE OKC_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: OKS_ENTITLEMENTS_PVT.get_coverage_levels
345: (p_api_version

Line 354: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

350: ,x_msg_data
351: ,x_covered_levels);
352:
353:
354: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;

Line 355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

351: ,x_covered_levels);
352:
353:
354: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;
359:

Line 356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

352:
353:
354: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;
359:
360: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 357: RAISE OKC_API.G_EXCEPTION_ERROR;

353:
354: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
355: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;
359:
360: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
361:

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

356: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
357: RAISE OKC_API.G_EXCEPTION_ERROR;
358: END IF;
359:
360: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
361:
362: EXCEPTION
363: WHEN OKC_API.G_EXCEPTION_ERROR THEN
364: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 363: WHEN OKC_API.G_EXCEPTION_ERROR THEN

359:
360: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
361:
362: EXCEPTION
363: WHEN OKC_API.G_EXCEPTION_ERROR THEN
364: x_return_status := OKC_API.HANDLE_EXCEPTIONS
365: (l_api_name,
366: G_PKG_NAME,
367: 'OKC_API.G_RET_STS_ERROR',

Line 364: x_return_status := OKC_API.HANDLE_EXCEPTIONS

360: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
361:
362: EXCEPTION
363: WHEN OKC_API.G_EXCEPTION_ERROR THEN
364: x_return_status := OKC_API.HANDLE_EXCEPTIONS
365: (l_api_name,
366: G_PKG_NAME,
367: 'OKC_API.G_RET_STS_ERROR',
368: x_msg_count,

Line 367: 'OKC_API.G_RET_STS_ERROR',

363: WHEN OKC_API.G_EXCEPTION_ERROR THEN
364: x_return_status := OKC_API.HANDLE_EXCEPTIONS
365: (l_api_name,
366: G_PKG_NAME,
367: 'OKC_API.G_RET_STS_ERROR',
368: x_msg_count,
369: x_msg_data,
370: '_PUB');
371: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 371: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

367: 'OKC_API.G_RET_STS_ERROR',
368: x_msg_count,
369: x_msg_data,
370: '_PUB');
371: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
372: x_return_status := OKC_API.HANDLE_EXCEPTIONS
373: (l_api_name,
374: G_PKG_NAME,
375: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 372: x_return_status := OKC_API.HANDLE_EXCEPTIONS

368: x_msg_count,
369: x_msg_data,
370: '_PUB');
371: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
372: x_return_status := OKC_API.HANDLE_EXCEPTIONS
373: (l_api_name,
374: G_PKG_NAME,
375: 'OKC_API.G_RET_STS_UNEXP_ERROR',
376: x_msg_count,

Line 375: 'OKC_API.G_RET_STS_UNEXP_ERROR',

371: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
372: x_return_status := OKC_API.HANDLE_EXCEPTIONS
373: (l_api_name,
374: G_PKG_NAME,
375: 'OKC_API.G_RET_STS_UNEXP_ERROR',
376: x_msg_count,
377: x_msg_data,
378: '_PUB');
379: WHEN OTHERS THEN

Line 380: x_return_status := OKC_API.HANDLE_EXCEPTIONS

376: x_msg_count,
377: x_msg_data,
378: '_PUB');
379: WHEN OTHERS THEN
380: x_return_status := OKC_API.HANDLE_EXCEPTIONS
381: (l_api_name,
382: G_PKG_NAME,
383: 'OTHERS',
384: x_msg_count,

Line 402: l_return_status := OKC_API.G_RET_STS_SUCCESS;

398: IS
399: l_return_status Varchar2(1);
400: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
401: BEGIN
402: l_return_status := OKC_API.G_RET_STS_SUCCESS;
403:
404: l_return_status := OKC_API.START_ACTIVITY(l_api_name
405: ,p_init_msg_list
406: ,'_PUB'

Line 404: l_return_status := OKC_API.START_ACTIVITY(l_api_name

400: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
401: BEGIN
402: l_return_status := OKC_API.G_RET_STS_SUCCESS;
403:
404: l_return_status := OKC_API.START_ACTIVITY(l_api_name
405: ,p_init_msg_list
406: ,'_PUB'
407: ,x_return_status
408: );

Line 409: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

405: ,p_init_msg_list
406: ,'_PUB'
407: ,x_return_status
408: );
409: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
412: RAISE OKC_API.G_EXCEPTION_ERROR;
413: END IF;

Line 410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

406: ,'_PUB'
407: ,x_return_status
408: );
409: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
412: RAISE OKC_API.G_EXCEPTION_ERROR;
413: END IF;
414:

Line 411: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

407: ,x_return_status
408: );
409: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
412: RAISE OKC_API.G_EXCEPTION_ERROR;
413: END IF;
414:
415: OKS_ENTITLEMENTS_PVT.get_contracts

Line 412: RAISE OKC_API.G_EXCEPTION_ERROR;

408: );
409: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
412: RAISE OKC_API.G_EXCEPTION_ERROR;
413: END IF;
414:
415: OKS_ENTITLEMENTS_PVT.get_contracts
416: (p_api_version

Line 425: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

421: ,x_msg_data
422: ,x_ent_contracts);
423:
424:
425: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;

Line 426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

422: ,x_ent_contracts);
423:
424:
425: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430:

Line 427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

423:
424:
425: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430:
431: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 428: RAISE OKC_API.G_EXCEPTION_ERROR;

424:
425: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
426: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430:
431: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
432:

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

427: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
428: RAISE OKC_API.G_EXCEPTION_ERROR;
429: END IF;
430:
431: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
432:
433: EXCEPTION
434: WHEN OKC_API.G_EXCEPTION_ERROR THEN
435: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 434: WHEN OKC_API.G_EXCEPTION_ERROR THEN

430:
431: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
432:
433: EXCEPTION
434: WHEN OKC_API.G_EXCEPTION_ERROR THEN
435: x_return_status := OKC_API.HANDLE_EXCEPTIONS
436: (l_api_name,
437: G_PKG_NAME,
438: 'OKC_API.G_RET_STS_ERROR',

Line 435: x_return_status := OKC_API.HANDLE_EXCEPTIONS

431: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
432:
433: EXCEPTION
434: WHEN OKC_API.G_EXCEPTION_ERROR THEN
435: x_return_status := OKC_API.HANDLE_EXCEPTIONS
436: (l_api_name,
437: G_PKG_NAME,
438: 'OKC_API.G_RET_STS_ERROR',
439: x_msg_count,

Line 438: 'OKC_API.G_RET_STS_ERROR',

434: WHEN OKC_API.G_EXCEPTION_ERROR THEN
435: x_return_status := OKC_API.HANDLE_EXCEPTIONS
436: (l_api_name,
437: G_PKG_NAME,
438: 'OKC_API.G_RET_STS_ERROR',
439: x_msg_count,
440: x_msg_data,
441: '_PUB');
442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

438: 'OKC_API.G_RET_STS_ERROR',
439: x_msg_count,
440: x_msg_data,
441: '_PUB');
442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (l_api_name,
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 443: x_return_status := OKC_API.HANDLE_EXCEPTIONS

439: x_msg_count,
440: x_msg_data,
441: '_PUB');
442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (l_api_name,
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',
447: x_msg_count,

Line 446: 'OKC_API.G_RET_STS_UNEXP_ERROR',

442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (l_api_name,
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',
447: x_msg_count,
448: x_msg_data,
449: '_PUB');
450: WHEN OTHERS THEN

Line 451: x_return_status := OKC_API.HANDLE_EXCEPTIONS

447: x_msg_count,
448: x_msg_data,
449: '_PUB');
450: WHEN OTHERS THEN
451: x_return_status := OKC_API.HANDLE_EXCEPTIONS
452: (l_api_name,
453: G_PKG_NAME,
454: 'OTHERS',
455: x_msg_count,

Line 473: l_return_status := OKC_API.G_RET_STS_SUCCESS;

469: IS
470: l_return_status Varchar2(1);
471: l_api_name CONSTANT VARCHAR2(30) := 'get_contacts';
472: BEGIN
473: l_return_status := OKC_API.G_RET_STS_SUCCESS;
474:
475: l_return_status := OKC_API.START_ACTIVITY(l_api_name
476: ,p_init_msg_list
477: ,'_PUB'

Line 475: l_return_status := OKC_API.START_ACTIVITY(l_api_name

471: l_api_name CONSTANT VARCHAR2(30) := 'get_contacts';
472: BEGIN
473: l_return_status := OKC_API.G_RET_STS_SUCCESS;
474:
475: l_return_status := OKC_API.START_ACTIVITY(l_api_name
476: ,p_init_msg_list
477: ,'_PUB'
478: ,x_return_status
479: );

Line 480: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

476: ,p_init_msg_list
477: ,'_PUB'
478: ,x_return_status
479: );
480: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;

Line 481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

477: ,'_PUB'
478: ,x_return_status
479: );
480: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485:

Line 482: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

478: ,x_return_status
479: );
480: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485:
486: OKS_ENTITLEMENTS_PVT.get_contacts

Line 483: RAISE OKC_API.G_EXCEPTION_ERROR;

479: );
480: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
482: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
483: RAISE OKC_API.G_EXCEPTION_ERROR;
484: END IF;
485:
486: OKS_ENTITLEMENTS_PVT.get_contacts
487: (p_api_version

Line 496: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

492: ,x_msg_count
493: ,x_msg_data
494: ,x_ent_contacts);
495:
496: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
499: RAISE OKC_API.G_EXCEPTION_ERROR;
500: END IF;

Line 497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

493: ,x_msg_data
494: ,x_ent_contacts);
495:
496: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
499: RAISE OKC_API.G_EXCEPTION_ERROR;
500: END IF;
501:

Line 498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

494: ,x_ent_contacts);
495:
496: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
499: RAISE OKC_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 499: RAISE OKC_API.G_EXCEPTION_ERROR;

495:
496: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
499: RAISE OKC_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
503:

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

498: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
499: RAISE OKC_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
503:
504: EXCEPTION
505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
506: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 505: WHEN OKC_API.G_EXCEPTION_ERROR THEN

501:
502: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
503:
504: EXCEPTION
505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
506: x_return_status := OKC_API.HANDLE_EXCEPTIONS
507: (l_api_name,
508: G_PKG_NAME,
509: 'OKC_API.G_RET_STS_ERROR',

Line 506: x_return_status := OKC_API.HANDLE_EXCEPTIONS

502: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
503:
504: EXCEPTION
505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
506: x_return_status := OKC_API.HANDLE_EXCEPTIONS
507: (l_api_name,
508: G_PKG_NAME,
509: 'OKC_API.G_RET_STS_ERROR',
510: x_msg_count,

Line 509: 'OKC_API.G_RET_STS_ERROR',

505: WHEN OKC_API.G_EXCEPTION_ERROR THEN
506: x_return_status := OKC_API.HANDLE_EXCEPTIONS
507: (l_api_name,
508: G_PKG_NAME,
509: 'OKC_API.G_RET_STS_ERROR',
510: x_msg_count,
511: x_msg_data,
512: '_PUB');
513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

509: 'OKC_API.G_RET_STS_ERROR',
510: x_msg_count,
511: x_msg_data,
512: '_PUB');
513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
514: x_return_status := OKC_API.HANDLE_EXCEPTIONS
515: (l_api_name,
516: G_PKG_NAME,
517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 514: x_return_status := OKC_API.HANDLE_EXCEPTIONS

510: x_msg_count,
511: x_msg_data,
512: '_PUB');
513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
514: x_return_status := OKC_API.HANDLE_EXCEPTIONS
515: (l_api_name,
516: G_PKG_NAME,
517: 'OKC_API.G_RET_STS_UNEXP_ERROR',
518: x_msg_count,

Line 517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
514: x_return_status := OKC_API.HANDLE_EXCEPTIONS
515: (l_api_name,
516: G_PKG_NAME,
517: 'OKC_API.G_RET_STS_UNEXP_ERROR',
518: x_msg_count,
519: x_msg_data,
520: '_PUB');
521: WHEN OTHERS THEN

Line 522: x_return_status := OKC_API.HANDLE_EXCEPTIONS

518: x_msg_count,
519: x_msg_data,
520: '_PUB');
521: WHEN OTHERS THEN
522: x_return_status := OKC_API.HANDLE_EXCEPTIONS
523: (l_api_name,
524: G_PKG_NAME,
525: 'OTHERS',
526: x_msg_count,

Line 545: l_return_status := OKC_API.G_RET_STS_SUCCESS;

541: IS
542: l_return_status Varchar2(1);
543: l_api_name CONSTANT VARCHAR2(30) := 'get_preffered_engineers';
544: BEGIN
545: l_return_status := OKC_API.G_RET_STS_SUCCESS;
546:
547: l_return_status := OKC_API.START_ACTIVITY(l_api_name
548: ,p_init_msg_list
549: ,'_PUB'

Line 547: l_return_status := OKC_API.START_ACTIVITY(l_api_name

543: l_api_name CONSTANT VARCHAR2(30) := 'get_preffered_engineers';
544: BEGIN
545: l_return_status := OKC_API.G_RET_STS_SUCCESS;
546:
547: l_return_status := OKC_API.START_ACTIVITY(l_api_name
548: ,p_init_msg_list
549: ,'_PUB'
550: ,x_return_status
551: );

Line 552: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

548: ,p_init_msg_list
549: ,'_PUB'
550: ,x_return_status
551: );
552: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
555: RAISE OKC_API.G_EXCEPTION_ERROR;
556: END IF;

Line 553: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

549: ,'_PUB'
550: ,x_return_status
551: );
552: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
555: RAISE OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:

Line 554: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

550: ,x_return_status
551: );
552: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
555: RAISE OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: OKS_ENTITLEMENTS_PVT.get_preferred_engineers

Line 555: RAISE OKC_API.G_EXCEPTION_ERROR;

551: );
552: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
553: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
555: RAISE OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: OKS_ENTITLEMENTS_PVT.get_preferred_engineers
559: (p_api_version

Line 569: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

565: ,x_msg_count
566: ,x_msg_data
567: ,x_prf_engineers);
568:
569: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: END IF;

Line 570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

566: ,x_msg_data
567: ,x_prf_engineers);
568:
569: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: END IF;
574:

Line 571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

567: ,x_prf_engineers);
568:
569: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 572: RAISE OKC_API.G_EXCEPTION_ERROR;

568:
569: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
576:

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

571: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: END IF;
574:
575: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
576:
577: EXCEPTION
578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
579: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 578: WHEN OKC_API.G_EXCEPTION_ERROR THEN

574:
575: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
576:
577: EXCEPTION
578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
580: (l_api_name,
581: G_PKG_NAME,
582: 'OKC_API.G_RET_STS_ERROR',

Line 579: x_return_status := OKC_API.HANDLE_EXCEPTIONS

575: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
576:
577: EXCEPTION
578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
580: (l_api_name,
581: G_PKG_NAME,
582: 'OKC_API.G_RET_STS_ERROR',
583: x_msg_count,

Line 582: 'OKC_API.G_RET_STS_ERROR',

578: WHEN OKC_API.G_EXCEPTION_ERROR THEN
579: x_return_status := OKC_API.HANDLE_EXCEPTIONS
580: (l_api_name,
581: G_PKG_NAME,
582: 'OKC_API.G_RET_STS_ERROR',
583: x_msg_count,
584: x_msg_data,
585: '_PUB');
586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

582: 'OKC_API.G_RET_STS_ERROR',
583: x_msg_count,
584: x_msg_data,
585: '_PUB');
586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
588: (l_api_name,
589: G_PKG_NAME,
590: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 587: x_return_status := OKC_API.HANDLE_EXCEPTIONS

583: x_msg_count,
584: x_msg_data,
585: '_PUB');
586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
588: (l_api_name,
589: G_PKG_NAME,
590: 'OKC_API.G_RET_STS_UNEXP_ERROR',
591: x_msg_count,

Line 590: 'OKC_API.G_RET_STS_UNEXP_ERROR',

586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
588: (l_api_name,
589: G_PKG_NAME,
590: 'OKC_API.G_RET_STS_UNEXP_ERROR',
591: x_msg_count,
592: x_msg_data,
593: '_PUB');
594: WHEN OTHERS THEN

Line 595: x_return_status := OKC_API.HANDLE_EXCEPTIONS

591: x_msg_count,
592: x_msg_data,
593: '_PUB');
594: WHEN OTHERS THEN
595: x_return_status := OKC_API.HANDLE_EXCEPTIONS
596: (l_api_name,
597: G_PKG_NAME,
598: 'OTHERS',
599: x_msg_count,

Line 616: l_return_status := OKC_API.G_RET_STS_SUCCESS;

612: IS
613: l_return_status Varchar2(1);
614: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
615: BEGIN
616: l_return_status := OKC_API.G_RET_STS_SUCCESS;
617:
618: l_return_status := OKC_API.START_ACTIVITY(l_api_name
619: ,p_init_msg_list
620: ,'_PUB'

Line 618: l_return_status := OKC_API.START_ACTIVITY(l_api_name

614: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
615: BEGIN
616: l_return_status := OKC_API.G_RET_STS_SUCCESS;
617:
618: l_return_status := OKC_API.START_ACTIVITY(l_api_name
619: ,p_init_msg_list
620: ,'_PUB'
621: ,x_return_status
622: );

Line 623: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

619: ,p_init_msg_list
620: ,'_PUB'
621: ,x_return_status
622: );
623: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;

Line 624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

620: ,'_PUB'
621: ,x_return_status
622: );
623: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:

Line 625: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

621: ,x_return_status
622: );
623: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: OKS_ENTITLEMENTS_PVT.get_contracts

Line 626: RAISE OKC_API.G_EXCEPTION_ERROR;

622: );
623: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: OKS_ENTITLEMENTS_PVT.get_contracts
630: (p_api_version

Line 639: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

635: ,x_msg_data
636: ,x_ent_contracts);
637:
638:
639: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
642: RAISE OKC_API.G_EXCEPTION_ERROR;
643: END IF;

Line 640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

636: ,x_ent_contracts);
637:
638:
639: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
642: RAISE OKC_API.G_EXCEPTION_ERROR;
643: END IF;
644:

Line 641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

637:
638:
639: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
642: RAISE OKC_API.G_EXCEPTION_ERROR;
643: END IF;
644:
645: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 642: RAISE OKC_API.G_EXCEPTION_ERROR;

638:
639: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
642: RAISE OKC_API.G_EXCEPTION_ERROR;
643: END IF;
644:
645: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
646:

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

641: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
642: RAISE OKC_API.G_EXCEPTION_ERROR;
643: END IF;
644:
645: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
646:
647: EXCEPTION
648: WHEN OKC_API.G_EXCEPTION_ERROR THEN
649: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 648: WHEN OKC_API.G_EXCEPTION_ERROR THEN

644:
645: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
646:
647: EXCEPTION
648: WHEN OKC_API.G_EXCEPTION_ERROR THEN
649: x_return_status := OKC_API.HANDLE_EXCEPTIONS
650: (l_api_name,
651: G_PKG_NAME,
652: 'OKC_API.G_RET_STS_ERROR',

Line 649: x_return_status := OKC_API.HANDLE_EXCEPTIONS

645: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
646:
647: EXCEPTION
648: WHEN OKC_API.G_EXCEPTION_ERROR THEN
649: x_return_status := OKC_API.HANDLE_EXCEPTIONS
650: (l_api_name,
651: G_PKG_NAME,
652: 'OKC_API.G_RET_STS_ERROR',
653: x_msg_count,

Line 652: 'OKC_API.G_RET_STS_ERROR',

648: WHEN OKC_API.G_EXCEPTION_ERROR THEN
649: x_return_status := OKC_API.HANDLE_EXCEPTIONS
650: (l_api_name,
651: G_PKG_NAME,
652: 'OKC_API.G_RET_STS_ERROR',
653: x_msg_count,
654: x_msg_data,
655: '_PUB');
656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

652: 'OKC_API.G_RET_STS_ERROR',
653: x_msg_count,
654: x_msg_data,
655: '_PUB');
656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
658: (l_api_name,
659: G_PKG_NAME,
660: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 657: x_return_status := OKC_API.HANDLE_EXCEPTIONS

653: x_msg_count,
654: x_msg_data,
655: '_PUB');
656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
658: (l_api_name,
659: G_PKG_NAME,
660: 'OKC_API.G_RET_STS_UNEXP_ERROR',
661: x_msg_count,

Line 660: 'OKC_API.G_RET_STS_UNEXP_ERROR',

656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
658: (l_api_name,
659: G_PKG_NAME,
660: 'OKC_API.G_RET_STS_UNEXP_ERROR',
661: x_msg_count,
662: x_msg_data,
663: '_PUB');
664: WHEN OTHERS THEN

Line 665: x_return_status := OKC_API.HANDLE_EXCEPTIONS

661: x_msg_count,
662: x_msg_data,
663: '_PUB');
664: WHEN OTHERS THEN
665: x_return_status := OKC_API.HANDLE_EXCEPTIONS
666: (l_api_name,
667: G_PKG_NAME,
668: 'OTHERS',
669: x_msg_count,

Line 687: l_return_status := OKC_API.G_RET_STS_SUCCESS;

683: IS
684: l_return_status Varchar2(1);
685: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
686: BEGIN
687: l_return_status := OKC_API.G_RET_STS_SUCCESS;
688:
689: l_return_status := OKC_API.START_ACTIVITY(l_api_name
690: ,p_init_msg_list
691: ,'_PUB'

Line 689: l_return_status := OKC_API.START_ACTIVITY(l_api_name

685: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
686: BEGIN
687: l_return_status := OKC_API.G_RET_STS_SUCCESS;
688:
689: l_return_status := OKC_API.START_ACTIVITY(l_api_name
690: ,p_init_msg_list
691: ,'_PUB'
692: ,x_return_status
693: );

Line 694: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

690: ,p_init_msg_list
691: ,'_PUB'
692: ,x_return_status
693: );
694: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;

Line 695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

691: ,'_PUB'
692: ,x_return_status
693: );
694: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699:

Line 696: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

692: ,x_return_status
693: );
694: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699:
700: OKS_ENTITLEMENTS_PVT.get_contracts

Line 697: RAISE OKC_API.G_EXCEPTION_ERROR;

693: );
694: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
696: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
697: RAISE OKC_API.G_EXCEPTION_ERROR;
698: END IF;
699:
700: OKS_ENTITLEMENTS_PVT.get_contracts
701: (p_api_version

Line 710: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

706: ,x_msg_data
707: ,x_ent_contracts);
708:
709:
710: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;

Line 711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

707: ,x_ent_contracts);
708:
709:
710: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;
715:

Line 712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

708:
709:
710: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 713: RAISE OKC_API.G_EXCEPTION_ERROR;

709:
710: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
717:

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

712: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
717:
718: EXCEPTION
719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 719: WHEN OKC_API.G_EXCEPTION_ERROR THEN

715:
716: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
717:
718: EXCEPTION
719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (l_api_name,
722: G_PKG_NAME,
723: 'OKC_API.G_RET_STS_ERROR',

Line 720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

716: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
717:
718: EXCEPTION
719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (l_api_name,
722: G_PKG_NAME,
723: 'OKC_API.G_RET_STS_ERROR',
724: x_msg_count,

Line 723: 'OKC_API.G_RET_STS_ERROR',

719: WHEN OKC_API.G_EXCEPTION_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (l_api_name,
722: G_PKG_NAME,
723: 'OKC_API.G_RET_STS_ERROR',
724: x_msg_count,
725: x_msg_data,
726: '_PUB');
727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

723: 'OKC_API.G_RET_STS_ERROR',
724: x_msg_count,
725: x_msg_data,
726: '_PUB');
727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 728: x_return_status := OKC_API.HANDLE_EXCEPTIONS

724: x_msg_count,
725: x_msg_data,
726: '_PUB');
727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count,

Line 731: 'OKC_API.G_RET_STS_UNEXP_ERROR',

727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
729: (l_api_name,
730: G_PKG_NAME,
731: 'OKC_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count,
733: x_msg_data,
734: '_PUB');
735: WHEN OTHERS THEN

Line 736: x_return_status := OKC_API.HANDLE_EXCEPTIONS

732: x_msg_count,
733: x_msg_data,
734: '_PUB');
735: WHEN OTHERS THEN
736: x_return_status := OKC_API.HANDLE_EXCEPTIONS
737: (l_api_name,
738: G_PKG_NAME,
739: 'OTHERS',
740: x_msg_count,

Line 762: l_return_status := OKC_API.G_RET_STS_SUCCESS;

758: l_api_name CONSTANT VARCHAR2(30) := 'get_react_resolve_by_time';
759: --l_api_version CONSTANT NUMBER := 1.0;
760:
761: BEGIN
762: l_return_status := OKC_API.G_RET_STS_SUCCESS;
763:
764: l_return_status := OKC_API.START_ACTIVITY(l_api_name
765: ,p_init_msg_list
766: ,'_PUB'

Line 764: l_return_status := OKC_API.START_ACTIVITY(l_api_name

760:
761: BEGIN
762: l_return_status := OKC_API.G_RET_STS_SUCCESS;
763:
764: l_return_status := OKC_API.START_ACTIVITY(l_api_name
765: ,p_init_msg_list
766: ,'_PUB'
767: ,x_return_status
768: );

Line 769: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

765: ,p_init_msg_list
766: ,'_PUB'
767: ,x_return_status
768: );
769: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;

Line 770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

766: ,'_PUB'
767: ,x_return_status
768: );
769: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:

Line 771: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

767: ,x_return_status
768: );
769: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:
775: OKS_ENTITLEMENTS_PVT.get_react_resolve_by_time

Line 772: RAISE OKC_API.G_EXCEPTION_ERROR;

768: );
769: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
771: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
772: RAISE OKC_API.G_EXCEPTION_ERROR;
773: END IF;
774:
775: OKS_ENTITLEMENTS_PVT.get_react_resolve_by_time
776: (p_api_version => p_api_version

Line 786: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

782: ,x_react_rec => x_react_rec
783: ,x_resolve_rec => x_resolve_rec
784: );
785:
786: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
789: RAISE OKC_API.G_EXCEPTION_ERROR;
790: END IF;

Line 787: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

783: ,x_resolve_rec => x_resolve_rec
784: );
785:
786: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
789: RAISE OKC_API.G_EXCEPTION_ERROR;
790: END IF;
791:

Line 788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

784: );
785:
786: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
789: RAISE OKC_API.G_EXCEPTION_ERROR;
790: END IF;
791:
792: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 789: RAISE OKC_API.G_EXCEPTION_ERROR;

785:
786: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
789: RAISE OKC_API.G_EXCEPTION_ERROR;
790: END IF;
791:
792: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
793:

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

788: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
789: RAISE OKC_API.G_EXCEPTION_ERROR;
790: END IF;
791:
792: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
793:
794: EXCEPTION
795: WHEN OKC_API.G_EXCEPTION_ERROR THEN
796: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 795: WHEN OKC_API.G_EXCEPTION_ERROR THEN

791:
792: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
793:
794: EXCEPTION
795: WHEN OKC_API.G_EXCEPTION_ERROR THEN
796: x_return_status := OKC_API.HANDLE_EXCEPTIONS
797: (l_api_name,
798: G_PKG_NAME,
799: 'OKC_API.G_RET_STS_ERROR',

Line 796: x_return_status := OKC_API.HANDLE_EXCEPTIONS

792: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
793:
794: EXCEPTION
795: WHEN OKC_API.G_EXCEPTION_ERROR THEN
796: x_return_status := OKC_API.HANDLE_EXCEPTIONS
797: (l_api_name,
798: G_PKG_NAME,
799: 'OKC_API.G_RET_STS_ERROR',
800: x_msg_count,

Line 799: 'OKC_API.G_RET_STS_ERROR',

795: WHEN OKC_API.G_EXCEPTION_ERROR THEN
796: x_return_status := OKC_API.HANDLE_EXCEPTIONS
797: (l_api_name,
798: G_PKG_NAME,
799: 'OKC_API.G_RET_STS_ERROR',
800: x_msg_count,
801: x_msg_data,
802: '_PUB');
803: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 803: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

799: 'OKC_API.G_RET_STS_ERROR',
800: x_msg_count,
801: x_msg_data,
802: '_PUB');
803: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
804: x_return_status := OKC_API.HANDLE_EXCEPTIONS
805: (l_api_name,
806: G_PKG_NAME,
807: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 804: x_return_status := OKC_API.HANDLE_EXCEPTIONS

800: x_msg_count,
801: x_msg_data,
802: '_PUB');
803: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
804: x_return_status := OKC_API.HANDLE_EXCEPTIONS
805: (l_api_name,
806: G_PKG_NAME,
807: 'OKC_API.G_RET_STS_UNEXP_ERROR',
808: x_msg_count,

Line 807: 'OKC_API.G_RET_STS_UNEXP_ERROR',

803: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
804: x_return_status := OKC_API.HANDLE_EXCEPTIONS
805: (l_api_name,
806: G_PKG_NAME,
807: 'OKC_API.G_RET_STS_UNEXP_ERROR',
808: x_msg_count,
809: x_msg_data,
810: '_PUB');
811: WHEN OTHERS THEN

Line 812: x_return_status := OKC_API.HANDLE_EXCEPTIONS

808: x_msg_count,
809: x_msg_data,
810: '_PUB');
811: WHEN OTHERS THEN
812: x_return_status := OKC_API.HANDLE_EXCEPTIONS
813: (l_api_name,
814: G_PKG_NAME,
815: 'OTHERS',
816: x_msg_count,

Line 836: l_return_status := OKC_API.G_RET_STS_SUCCESS;

832: IS
833: l_return_status Varchar2(1);
834: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
835: BEGIN
836: l_return_status := OKC_API.G_RET_STS_SUCCESS;
837:
838: l_return_status := OKC_API.START_ACTIVITY(l_api_name
839: ,p_init_msg_list
840: ,'_PUB'

Line 838: l_return_status := OKC_API.START_ACTIVITY(l_api_name

834: l_api_name CONSTANT VARCHAR2(30) := 'get_contracts';
835: BEGIN
836: l_return_status := OKC_API.G_RET_STS_SUCCESS;
837:
838: l_return_status := OKC_API.START_ACTIVITY(l_api_name
839: ,p_init_msg_list
840: ,'_PUB'
841: ,x_return_status
842: );

Line 843: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

839: ,p_init_msg_list
840: ,'_PUB'
841: ,x_return_status
842: );
843: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
846: RAISE OKC_API.G_EXCEPTION_ERROR;
847: END IF;

Line 844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

840: ,'_PUB'
841: ,x_return_status
842: );
843: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
846: RAISE OKC_API.G_EXCEPTION_ERROR;
847: END IF;
848:

Line 845: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

841: ,x_return_status
842: );
843: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
846: RAISE OKC_API.G_EXCEPTION_ERROR;
847: END IF;
848:
849: OKS_ENTITLEMENTS_PVT.get_contracts

Line 846: RAISE OKC_API.G_EXCEPTION_ERROR;

842: );
843: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
846: RAISE OKC_API.G_EXCEPTION_ERROR;
847: END IF;
848:
849: OKS_ENTITLEMENTS_PVT.get_contracts
850: (P_API_Version => P_API_Version

Line 859: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

855: ,X_Msg_Data => X_Msg_Data
856: ,X_Ent_Contracts => X_Ent_Contracts);
857:
858:
859: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
860: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;

Line 860: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

856: ,X_Ent_Contracts => X_Ent_Contracts);
857:
858:
859: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
860: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:

Line 861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

857:
858:
859: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
860: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 862: RAISE OKC_API.G_EXCEPTION_ERROR;

858:
859: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
860: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
866:

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

861: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
866:
867: EXCEPTION
868: WHEN OKC_API.G_EXCEPTION_ERROR THEN
869: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 868: WHEN OKC_API.G_EXCEPTION_ERROR THEN

864:
865: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
866:
867: EXCEPTION
868: WHEN OKC_API.G_EXCEPTION_ERROR THEN
869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
870: (l_api_name,
871: G_PKG_NAME,
872: 'OKC_API.G_RET_STS_ERROR',

Line 869: x_return_status := OKC_API.HANDLE_EXCEPTIONS

865: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
866:
867: EXCEPTION
868: WHEN OKC_API.G_EXCEPTION_ERROR THEN
869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
870: (l_api_name,
871: G_PKG_NAME,
872: 'OKC_API.G_RET_STS_ERROR',
873: x_msg_count,

Line 872: 'OKC_API.G_RET_STS_ERROR',

868: WHEN OKC_API.G_EXCEPTION_ERROR THEN
869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
870: (l_api_name,
871: G_PKG_NAME,
872: 'OKC_API.G_RET_STS_ERROR',
873: x_msg_count,
874: x_msg_data,
875: '_PUB');
876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

872: 'OKC_API.G_RET_STS_ERROR',
873: x_msg_count,
874: x_msg_data,
875: '_PUB');
876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (l_api_name,
879: G_PKG_NAME,
880: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 877: x_return_status := OKC_API.HANDLE_EXCEPTIONS

873: x_msg_count,
874: x_msg_data,
875: '_PUB');
876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (l_api_name,
879: G_PKG_NAME,
880: 'OKC_API.G_RET_STS_UNEXP_ERROR',
881: x_msg_count,

Line 880: 'OKC_API.G_RET_STS_UNEXP_ERROR',

876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (l_api_name,
879: G_PKG_NAME,
880: 'OKC_API.G_RET_STS_UNEXP_ERROR',
881: x_msg_count,
882: x_msg_data,
883: '_PUB');
884: WHEN OTHERS THEN

Line 885: x_return_status := OKC_API.HANDLE_EXCEPTIONS

881: x_msg_count,
882: x_msg_data,
883: '_PUB');
884: WHEN OTHERS THEN
885: x_return_status := OKC_API.HANDLE_EXCEPTIONS
886: (l_api_name,
887: G_PKG_NAME,
888: 'OTHERS',
889: x_msg_count,

Line 911: l_return_status := OKC_API.G_RET_STS_SUCCESS;

907: l_return_status Varchar2(1);
908: l_api_name CONSTANT VARCHAR2(30) := 'get_react_resolve_by_time';
909:
910: BEGIN
911: l_return_status := OKC_API.G_RET_STS_SUCCESS;
912:
913: l_return_status := OKC_API.START_ACTIVITY(l_api_name
914: ,p_init_msg_list
915: ,'_PUB'

Line 913: l_return_status := OKC_API.START_ACTIVITY(l_api_name

909:
910: BEGIN
911: l_return_status := OKC_API.G_RET_STS_SUCCESS;
912:
913: l_return_status := OKC_API.START_ACTIVITY(l_api_name
914: ,p_init_msg_list
915: ,'_PUB'
916: ,x_return_status);
917:

Line 918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

914: ,p_init_msg_list
915: ,'_PUB'
916: ,x_return_status);
917:
918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
921: RAISE OKC_API.G_EXCEPTION_ERROR;
922: END IF;

Line 919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

915: ,'_PUB'
916: ,x_return_status);
917:
918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
921: RAISE OKC_API.G_EXCEPTION_ERROR;
922: END IF;
923:

Line 920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

916: ,x_return_status);
917:
918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
921: RAISE OKC_API.G_EXCEPTION_ERROR;
922: END IF;
923:
924: OKS_ENTITLEMENTS_PVT.Get_Coverage_Type

Line 921: RAISE OKC_API.G_EXCEPTION_ERROR;

917:
918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
921: RAISE OKC_API.G_EXCEPTION_ERROR;
922: END IF;
923:
924: OKS_ENTITLEMENTS_PVT.Get_Coverage_Type
925: (P_API_Version => p_api_version

Line 933: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

929: ,X_Msg_Count => x_msg_count
930: ,X_Msg_Data => x_msg_data
931: ,X_Coverage_Type => X_Coverage_Type);
932:
933: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
936: RAISE OKC_API.G_EXCEPTION_ERROR;
937: END IF;

Line 934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

930: ,X_Msg_Data => x_msg_data
931: ,X_Coverage_Type => X_Coverage_Type);
932:
933: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
936: RAISE OKC_API.G_EXCEPTION_ERROR;
937: END IF;
938:

Line 935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

931: ,X_Coverage_Type => X_Coverage_Type);
932:
933: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
936: RAISE OKC_API.G_EXCEPTION_ERROR;
937: END IF;
938:
939: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 936: RAISE OKC_API.G_EXCEPTION_ERROR;

932:
933: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
936: RAISE OKC_API.G_EXCEPTION_ERROR;
937: END IF;
938:
939: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
940:

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

935: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
936: RAISE OKC_API.G_EXCEPTION_ERROR;
937: END IF;
938:
939: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
940:
941: EXCEPTION
942:
943: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 943: WHEN OKC_API.G_EXCEPTION_ERROR THEN

939: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
940:
941: EXCEPTION
942:
943: WHEN OKC_API.G_EXCEPTION_ERROR THEN
944:
945: x_return_status := OKC_API.HANDLE_EXCEPTIONS
946: (l_api_name,
947: G_PKG_NAME,

Line 945: x_return_status := OKC_API.HANDLE_EXCEPTIONS

941: EXCEPTION
942:
943: WHEN OKC_API.G_EXCEPTION_ERROR THEN
944:
945: x_return_status := OKC_API.HANDLE_EXCEPTIONS
946: (l_api_name,
947: G_PKG_NAME,
948: 'OKC_API.G_RET_STS_ERROR',
949: x_msg_count,

Line 948: 'OKC_API.G_RET_STS_ERROR',

944:
945: x_return_status := OKC_API.HANDLE_EXCEPTIONS
946: (l_api_name,
947: G_PKG_NAME,
948: 'OKC_API.G_RET_STS_ERROR',
949: x_msg_count,
950: x_msg_data,
951: '_PUB');
952:

Line 953: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

949: x_msg_count,
950: x_msg_data,
951: '_PUB');
952:
953: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
954:
955: x_return_status := OKC_API.HANDLE_EXCEPTIONS
956: (l_api_name,
957: G_PKG_NAME,

Line 955: x_return_status := OKC_API.HANDLE_EXCEPTIONS

951: '_PUB');
952:
953: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
954:
955: x_return_status := OKC_API.HANDLE_EXCEPTIONS
956: (l_api_name,
957: G_PKG_NAME,
958: 'OKC_API.G_RET_STS_UNEXP_ERROR',
959: x_msg_count,

Line 958: 'OKC_API.G_RET_STS_UNEXP_ERROR',

954:
955: x_return_status := OKC_API.HANDLE_EXCEPTIONS
956: (l_api_name,
957: G_PKG_NAME,
958: 'OKC_API.G_RET_STS_UNEXP_ERROR',
959: x_msg_count,
960: x_msg_data,
961: '_PUB');
962:

Line 965: x_return_status := OKC_API.HANDLE_EXCEPTIONS

961: '_PUB');
962:
963: WHEN OTHERS THEN
964:
965: x_return_status := OKC_API.HANDLE_EXCEPTIONS
966: (l_api_name,
967: G_PKG_NAME,
968: 'OTHERS',
969: x_msg_count,

Line 997: l_return_status := OKC_API.G_RET_STS_SUCCESS;

993: l_api_name CONSTANT VARCHAR2(30) := 'Get_HighImp_CP_Contract';
994:
995: BEGIN
996:
997: l_return_status := OKC_API.G_RET_STS_SUCCESS;
998:
999: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1000: ,p_init_msg_list
1001: ,'_PUB'

Line 999: l_return_status := OKC_API.START_ACTIVITY(l_api_name

995: BEGIN
996:
997: l_return_status := OKC_API.G_RET_STS_SUCCESS;
998:
999: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1000: ,p_init_msg_list
1001: ,'_PUB'
1002: ,x_return_status);
1003:

Line 1004: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1000: ,p_init_msg_list
1001: ,'_PUB'
1002: ,x_return_status);
1003:
1004: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1007: RAISE OKC_API.G_EXCEPTION_ERROR;
1008: END IF;

Line 1005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1001: ,'_PUB'
1002: ,x_return_status);
1003:
1004: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1007: RAISE OKC_API.G_EXCEPTION_ERROR;
1008: END IF;
1009:

Line 1006: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1002: ,x_return_status);
1003:
1004: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1007: RAISE OKC_API.G_EXCEPTION_ERROR;
1008: END IF;
1009:
1010:

Line 1007: RAISE OKC_API.G_EXCEPTION_ERROR;

1003:
1004: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1006: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1007: RAISE OKC_API.G_EXCEPTION_ERROR;
1008: END IF;
1009:
1010:
1011:

Line 1021: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1017: ,X_Msg_Count => x_msg_count
1018: ,X_Msg_Data => x_msg_data
1019: ,X_Importance_Lvl => X_Importance_Lvl);
1020:
1021: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1022: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1024: RAISE OKC_API.G_EXCEPTION_ERROR;
1025: END IF;

Line 1022: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1018: ,X_Msg_Data => x_msg_data
1019: ,X_Importance_Lvl => X_Importance_Lvl);
1020:
1021: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1022: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1024: RAISE OKC_API.G_EXCEPTION_ERROR;
1025: END IF;
1026:

Line 1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1019: ,X_Importance_Lvl => X_Importance_Lvl);
1020:
1021: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1022: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1024: RAISE OKC_API.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1024: RAISE OKC_API.G_EXCEPTION_ERROR;

1020:
1021: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1022: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1024: RAISE OKC_API.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1028:

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

1023: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1024: RAISE OKC_API.G_EXCEPTION_ERROR;
1025: END IF;
1026:
1027: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1028:
1029: EXCEPTION
1030:
1031: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1031: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1027: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1028:
1029: EXCEPTION
1030:
1031: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1032:
1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1034: (l_api_name,
1035: G_PKG_NAME,

Line 1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1029: EXCEPTION
1030:
1031: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1032:
1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1034: (l_api_name,
1035: G_PKG_NAME,
1036: 'OKC_API.G_RET_STS_ERROR',
1037: x_msg_count,

Line 1036: 'OKC_API.G_RET_STS_ERROR',

1032:
1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1034: (l_api_name,
1035: G_PKG_NAME,
1036: 'OKC_API.G_RET_STS_ERROR',
1037: x_msg_count,
1038: x_msg_data,
1039: '_PUB');
1040:

Line 1041: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1037: x_msg_count,
1038: x_msg_data,
1039: '_PUB');
1040:
1041: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1042:
1043: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1044: (l_api_name,
1045: G_PKG_NAME,

Line 1043: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1039: '_PUB');
1040:
1041: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1042:
1043: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1044: (l_api_name,
1045: G_PKG_NAME,
1046: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1047: x_msg_count,

Line 1046: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1042:
1043: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1044: (l_api_name,
1045: G_PKG_NAME,
1046: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1047: x_msg_count,
1048: x_msg_data,
1049: '_PUB');
1050:

Line 1053: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1049: '_PUB');
1050:
1051: WHEN OTHERS THEN
1052:
1053: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1054: (l_api_name,
1055: G_PKG_NAME,
1056: 'OTHERS',
1057: x_msg_count,

Line 1089: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1085: lx_csi VARCHAR2(1);
1086:
1087: BEGIN
1088:
1089: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1090: lx_csi := 'F';
1091:
1092:
1093: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 1093: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1089: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1090: lx_csi := 'F';
1091:
1092:
1093: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1094: ,p_init_msg_list
1095: ,'_PUB'
1096: ,x_return_status);
1097:

Line 1098: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1094: ,p_init_msg_list
1095: ,'_PUB'
1096: ,x_return_status);
1097:
1098: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;

Line 1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1095: ,'_PUB'
1096: ,x_return_status);
1097:
1098: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103:

Line 1100: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1096: ,x_return_status);
1097:
1098: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103:
1104:

Line 1101: RAISE OKC_API.G_EXCEPTION_ERROR;

1097:
1098: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103:
1104:
1105: OKS_ENTITLEMENTS_PVT.OKS_VALIDATE_SYSTEM(P_API_Version => p_api_version

Line 1115: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1111: ,X_Msg_Count => x_msg_count
1112: ,X_Msg_Data => x_msg_data
1113: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1114:
1115: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: END IF;

Line 1116: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1112: ,X_Msg_Data => x_msg_data
1113: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1114:
1115: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: END IF;
1120:

Line 1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1113: ,X_SYSTEM_VALID => X_SYSTEM_VALID);
1114:
1115: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: END IF;
1120:
1121: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1118: RAISE OKC_API.G_EXCEPTION_ERROR;

1114:
1115: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1116: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: END IF;
1120:
1121: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1122: --return lx_csi;

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

1117: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1118: RAISE OKC_API.G_EXCEPTION_ERROR;
1119: END IF;
1120:
1121: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1122: --return lx_csi;
1123:
1124: EXCEPTION
1125:

Line 1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1122: --return lx_csi;
1123:
1124: EXCEPTION
1125:
1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1127:
1128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1129: (l_api_name,
1130: G_PKG_NAME,

Line 1128: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1124: EXCEPTION
1125:
1126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1127:
1128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1129: (l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_ERROR',
1132: x_msg_count,

Line 1131: 'OKC_API.G_RET_STS_ERROR',

1127:
1128: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1129: (l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_ERROR',
1132: x_msg_count,
1133: x_msg_data,
1134: '_PUB');
1135: -- return lx_csi;

Line 1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1132: x_msg_count,
1133: x_msg_data,
1134: '_PUB');
1135: -- return lx_csi;
1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137:
1138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1139: (l_api_name,
1140: G_PKG_NAME,

Line 1138: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1134: '_PUB');
1135: -- return lx_csi;
1136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1137:
1138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1139: (l_api_name,
1140: G_PKG_NAME,
1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1142: x_msg_count,

Line 1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1137:
1138: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1139: (l_api_name,
1140: G_PKG_NAME,
1141: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1142: x_msg_count,
1143: x_msg_data,
1144: '_PUB');
1145: -- return lx_csi;

Line 1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1144: '_PUB');
1145: -- return lx_csi;
1146: WHEN OTHERS THEN
1147:
1148: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1149: (l_api_name,
1150: G_PKG_NAME,
1151: 'OTHERS',
1152: x_msg_count,

Line 1176: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1172: IS
1173: l_return_status Varchar2(1);
1174: l_api_name CONSTANT VARCHAR2(30) := 'Default_Contline_System';
1175: BEGIN
1176: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1177:
1178: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1179: ,p_init_msg_list
1180: ,'_PUB'

Line 1178: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1174: l_api_name CONSTANT VARCHAR2(30) := 'Default_Contline_System';
1175: BEGIN
1176: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1177:
1178: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1179: ,p_init_msg_list
1180: ,'_PUB'
1181: ,x_return_status
1182: );

Line 1184: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1180: ,'_PUB'
1181: ,x_return_status
1182: );
1183:
1184: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;

Line 1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1181: ,x_return_status
1182: );
1183:
1184: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189:

Line 1186: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1182: );
1183:
1184: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189:
1190: OKS_ENTITLEMENTS_PVT.Default_Contline_System

Line 1187: RAISE OKC_API.G_EXCEPTION_ERROR;

1183:
1184: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189:
1190: OKS_ENTITLEMENTS_PVT.Default_Contline_System
1191: (P_API_Version => p_api_version

Line 1201: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1197: ,X_Msg_Data => x_msg_data
1198: ,X_Ent_Contracts => X_Ent_Contracts);
1199:
1200:
1201: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;

Line 1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1198: ,X_Ent_Contracts => X_Ent_Contracts);
1199:
1200:
1201: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:

Line 1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1199:
1200:
1201: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:
1207: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1204: RAISE OKC_API.G_EXCEPTION_ERROR;

1200:
1201: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1202: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:
1207: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1208:

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

1203: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1204: RAISE OKC_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:
1207: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1208:
1209: EXCEPTION
1210: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1211: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1210: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1206:
1207: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1208:
1209: EXCEPTION
1210: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1212: (l_api_name,
1213: G_PKG_NAME,
1214: 'OKC_API.G_RET_STS_ERROR',

Line 1211: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1207: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1208:
1209: EXCEPTION
1210: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1212: (l_api_name,
1213: G_PKG_NAME,
1214: 'OKC_API.G_RET_STS_ERROR',
1215: x_msg_count,

Line 1214: 'OKC_API.G_RET_STS_ERROR',

1210: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1211: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1212: (l_api_name,
1213: G_PKG_NAME,
1214: 'OKC_API.G_RET_STS_ERROR',
1215: x_msg_count,
1216: x_msg_data,
1217: '_PUB');
1218: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1218: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1214: 'OKC_API.G_RET_STS_ERROR',
1215: x_msg_count,
1216: x_msg_data,
1217: '_PUB');
1218: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1220: (l_api_name,
1221: G_PKG_NAME,
1222: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1215: x_msg_count,
1216: x_msg_data,
1217: '_PUB');
1218: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1220: (l_api_name,
1221: G_PKG_NAME,
1222: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1223: x_msg_count,

Line 1222: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1218: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1220: (l_api_name,
1221: G_PKG_NAME,
1222: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1223: x_msg_count,
1224: x_msg_data,
1225: '_PUB');
1226: WHEN OTHERS THEN

Line 1227: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1223: x_msg_count,
1224: x_msg_data,
1225: '_PUB');
1226: WHEN OTHERS THEN
1227: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1228: (l_api_name,
1229: G_PKG_NAME,
1230: 'OTHERS',
1231: x_msg_count,

Line 1248: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1244: IS
1245: l_return_status Varchar2(1);
1246: l_api_name CONSTANT VARCHAR2(30) := 'Get_cov_txn_groups';
1247: BEGIN
1248: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1249:
1250: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1251: ,p_init_msg_list
1252: ,'_PUB'

Line 1250: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1246: l_api_name CONSTANT VARCHAR2(30) := 'Get_cov_txn_groups';
1247: BEGIN
1248: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1249:
1250: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1251: ,p_init_msg_list
1252: ,'_PUB'
1253: ,x_return_status
1254: );

Line 1256: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1252: ,'_PUB'
1253: ,x_return_status
1254: );
1255:
1256: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1259: RAISE OKC_API.G_EXCEPTION_ERROR;
1260: END IF;

Line 1257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1253: ,x_return_status
1254: );
1255:
1256: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1259: RAISE OKC_API.G_EXCEPTION_ERROR;
1260: END IF;
1261:

Line 1258: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1254: );
1255:
1256: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1259: RAISE OKC_API.G_EXCEPTION_ERROR;
1260: END IF;
1261:
1262:

Line 1259: RAISE OKC_API.G_EXCEPTION_ERROR;

1255:
1256: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1257: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1259: RAISE OKC_API.G_EXCEPTION_ERROR;
1260: END IF;
1261:
1262:
1263: OKS_ENTITLEMENTS_PVT.Get_cov_txn_groups

Line 1273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1269: ,x_msg_data => x_msg_data
1270: ,x_cov_txn_grp_lines => x_cov_txn_grp_lines);
1271:
1272:
1273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;

Line 1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1270: ,x_cov_txn_grp_lines => x_cov_txn_grp_lines);
1271:
1272:
1273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278:

Line 1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1271:
1272:
1273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278:
1279: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1276: RAISE OKC_API.G_EXCEPTION_ERROR;

1272:
1273: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278:
1279: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1280:

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

1275: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278:
1279: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1280:
1281: EXCEPTION
1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1278:
1279: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1280:
1281: EXCEPTION
1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (l_api_name,
1285: G_PKG_NAME,
1286: 'OKC_API.G_RET_STS_ERROR',

Line 1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1279: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1280:
1281: EXCEPTION
1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (l_api_name,
1285: G_PKG_NAME,
1286: 'OKC_API.G_RET_STS_ERROR',
1287: x_msg_count,

Line 1286: 'OKC_API.G_RET_STS_ERROR',

1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (l_api_name,
1285: G_PKG_NAME,
1286: 'OKC_API.G_RET_STS_ERROR',
1287: x_msg_count,
1288: x_msg_data,
1289: '_PUB');
1290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1286: 'OKC_API.G_RET_STS_ERROR',
1287: x_msg_count,
1288: x_msg_data,
1289: '_PUB');
1290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1292: (l_api_name,
1293: G_PKG_NAME,
1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1291: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1287: x_msg_count,
1288: x_msg_data,
1289: '_PUB');
1290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1292: (l_api_name,
1293: G_PKG_NAME,
1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1295: x_msg_count,

Line 1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1292: (l_api_name,
1293: G_PKG_NAME,
1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1295: x_msg_count,
1296: x_msg_data,
1297: '_PUB');
1298: WHEN OTHERS THEN

Line 1299: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1295: x_msg_count,
1296: x_msg_data,
1297: '_PUB');
1298: WHEN OTHERS THEN
1299: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1300: (l_api_name,
1301: G_PKG_NAME,
1302: 'OTHERS',
1303: x_msg_count,

Line 1323: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1319: IS
1320: l_return_status Varchar2(1);
1321: l_api_name CONSTANT VARCHAR2(30) := 'Get_txn_billing_types';
1322: BEGIN
1323: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1324:
1325: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1326: ,p_init_msg_list
1327: ,'_PUB'

Line 1325: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1321: l_api_name CONSTANT VARCHAR2(30) := 'Get_txn_billing_types';
1322: BEGIN
1323: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1324:
1325: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1326: ,p_init_msg_list
1327: ,'_PUB'
1328: ,x_return_status
1329: );

Line 1331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1327: ,'_PUB'
1328: ,x_return_status
1329: );
1330:
1331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;

Line 1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1328: ,x_return_status
1329: );
1330:
1331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336:

Line 1333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1329: );
1330:
1331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336:
1337:

Line 1334: RAISE OKC_API.G_EXCEPTION_ERROR;

1330:
1331: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1332: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1333: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1334: RAISE OKC_API.G_EXCEPTION_ERROR;
1335: END IF;
1336:
1337:
1338: OKS_ENTITLEMENTS_PVT.Get_txn_billing_types

Line 1350: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1346: ,x_txn_bill_types => x_txn_bill_types
1347: ,x_txn_bill_rates => x_txn_bill_rates);
1348:
1349:
1350: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1353: RAISE OKC_API.G_EXCEPTION_ERROR;
1354: END IF;

Line 1351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1347: ,x_txn_bill_rates => x_txn_bill_rates);
1348:
1349:
1350: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1353: RAISE OKC_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:

Line 1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1348:
1349:
1350: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1353: RAISE OKC_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:
1356: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1353: RAISE OKC_API.G_EXCEPTION_ERROR;

1349:
1350: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1351: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1353: RAISE OKC_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:
1356: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1357:

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

1352: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1353: RAISE OKC_API.G_EXCEPTION_ERROR;
1354: END IF;
1355:
1356: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1357:
1358: EXCEPTION
1359: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1360: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1359: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1355:
1356: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1357:
1358: EXCEPTION
1359: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1360: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1361: (l_api_name,
1362: G_PKG_NAME,
1363: 'OKC_API.G_RET_STS_ERROR',

Line 1360: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1356: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1357:
1358: EXCEPTION
1359: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1360: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1361: (l_api_name,
1362: G_PKG_NAME,
1363: 'OKC_API.G_RET_STS_ERROR',
1364: x_msg_count,

Line 1363: 'OKC_API.G_RET_STS_ERROR',

1359: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1360: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1361: (l_api_name,
1362: G_PKG_NAME,
1363: 'OKC_API.G_RET_STS_ERROR',
1364: x_msg_count,
1365: x_msg_data,
1366: '_PUB');
1367: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1367: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1363: 'OKC_API.G_RET_STS_ERROR',
1364: x_msg_count,
1365: x_msg_data,
1366: '_PUB');
1367: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1368: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1369: (l_api_name,
1370: G_PKG_NAME,
1371: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1368: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1364: x_msg_count,
1365: x_msg_data,
1366: '_PUB');
1367: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1368: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1369: (l_api_name,
1370: G_PKG_NAME,
1371: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1372: x_msg_count,

Line 1371: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1367: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1368: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1369: (l_api_name,
1370: G_PKG_NAME,
1371: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1372: x_msg_count,
1373: x_msg_data,
1374: '_PUB');
1375: WHEN OTHERS THEN

Line 1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1372: x_msg_count,
1373: x_msg_data,
1374: '_PUB');
1375: WHEN OTHERS THEN
1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1377: (l_api_name,
1378: G_PKG_NAME,
1379: 'OTHERS',
1380: x_msg_count,

Line 1400: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1396: l_return_status Varchar2(1);
1397: l_api_name CONSTANT VARCHAR2(30) := 'search_contracts';
1398:
1399: BEGIN
1400: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1401:
1402: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1403: ,p_init_msg_list
1404: ,'_PUB'

Line 1402: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1398:
1399: BEGIN
1400: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1401:
1402: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1403: ,p_init_msg_list
1404: ,'_PUB'
1405: ,x_return_status
1406: );

Line 1407: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1403: ,p_init_msg_list
1404: ,'_PUB'
1405: ,x_return_status
1406: );
1407: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1410: RAISE OKC_API.G_EXCEPTION_ERROR;
1411: END IF;

Line 1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1404: ,'_PUB'
1405: ,x_return_status
1406: );
1407: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1410: RAISE OKC_API.G_EXCEPTION_ERROR;
1411: END IF;
1412:

Line 1409: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1405: ,x_return_status
1406: );
1407: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1410: RAISE OKC_API.G_EXCEPTION_ERROR;
1411: END IF;
1412:
1413: OKS_ENTITLEMENTS_PVT.search_contracts

Line 1410: RAISE OKC_API.G_EXCEPTION_ERROR;

1406: );
1407: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1410: RAISE OKC_API.G_EXCEPTION_ERROR;
1411: END IF;
1412:
1413: OKS_ENTITLEMENTS_PVT.search_contracts
1414: (p_api_version

Line 1423: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1419: ,x_msg_count
1420: ,x_msg_data
1421: ,x_contract_tbl);
1422:
1423: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1426: RAISE OKC_API.G_EXCEPTION_ERROR;
1427: END IF;

Line 1424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1420: ,x_msg_data
1421: ,x_contract_tbl);
1422:
1423: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1426: RAISE OKC_API.G_EXCEPTION_ERROR;
1427: END IF;
1428:

Line 1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1421: ,x_contract_tbl);
1422:
1423: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1426: RAISE OKC_API.G_EXCEPTION_ERROR;
1427: END IF;
1428:
1429: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1426: RAISE OKC_API.G_EXCEPTION_ERROR;

1422:
1423: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1424: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1426: RAISE OKC_API.G_EXCEPTION_ERROR;
1427: END IF;
1428:
1429: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1430:

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

1425: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1426: RAISE OKC_API.G_EXCEPTION_ERROR;
1427: END IF;
1428:
1429: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1430:
1431: EXCEPTION
1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1428:
1429: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1430:
1431: EXCEPTION
1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1434: (l_api_name,
1435: G_PKG_NAME,
1436: 'OKC_API.G_RET_STS_ERROR',

Line 1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1429: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1430:
1431: EXCEPTION
1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1434: (l_api_name,
1435: G_PKG_NAME,
1436: 'OKC_API.G_RET_STS_ERROR',
1437: x_msg_count,

Line 1436: 'OKC_API.G_RET_STS_ERROR',

1432: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1433: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1434: (l_api_name,
1435: G_PKG_NAME,
1436: 'OKC_API.G_RET_STS_ERROR',
1437: x_msg_count,
1438: x_msg_data,
1439: '_PUB');
1440: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1440: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1436: 'OKC_API.G_RET_STS_ERROR',
1437: x_msg_count,
1438: x_msg_data,
1439: '_PUB');
1440: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1441: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1442: (l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1441: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1437: x_msg_count,
1438: x_msg_data,
1439: '_PUB');
1440: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1441: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1442: (l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1445: x_msg_count,

Line 1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1440: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1441: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1442: (l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1445: x_msg_count,
1446: x_msg_data,
1447: '_PUB');
1448: WHEN OTHERS THEN

Line 1449: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1445: x_msg_count,
1446: x_msg_data,
1447: '_PUB');
1448: WHEN OTHERS THEN
1449: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1450: (l_api_name,
1451: G_PKG_NAME,
1452: 'OTHERS',
1453: x_msg_count,

Line 1474: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1470: l_return_status Varchar2(1);
1471: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contracts_Expiration';
1472:
1473: BEGIN
1474: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1475:
1476: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1477: ,p_init_msg_list
1478: ,'_PUB'

Line 1476: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1472:
1473: BEGIN
1474: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1475:
1476: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1477: ,p_init_msg_list
1478: ,'_PUB'
1479: ,x_return_status
1480: );

Line 1481: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1477: ,p_init_msg_list
1478: ,'_PUB'
1479: ,x_return_status
1480: );
1481: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1484: RAISE OKC_API.G_EXCEPTION_ERROR;
1485: END IF;

Line 1482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1478: ,'_PUB'
1479: ,x_return_status
1480: );
1481: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1484: RAISE OKC_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:

Line 1483: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1479: ,x_return_status
1480: );
1481: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1484: RAISE OKC_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:
1487: OKS_ENTITLEMENTS_PVT.Get_Contracts_Expiration

Line 1484: RAISE OKC_API.G_EXCEPTION_ERROR;

1480: );
1481: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1484: RAISE OKC_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:
1487: OKS_ENTITLEMENTS_PVT.Get_Contracts_Expiration
1488: (p_api_version

Line 1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1495: ,x_Contract_Grace_Period
1496: ,x_Contract_Grace_Duration);
1497:
1498:
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;

Line 1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1496: ,x_Contract_Grace_Duration);
1497:
1498:
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504:

Line 1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1497:
1498:
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504:
1505: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1502: RAISE OKC_API.G_EXCEPTION_ERROR;

1498:
1499: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504:
1505: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1506:

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

1501: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1502: RAISE OKC_API.G_EXCEPTION_ERROR;
1503: END IF;
1504:
1505: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1506:
1507: EXCEPTION
1508: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1508: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1504:
1505: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1506:
1507: EXCEPTION
1508: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1510: (l_api_name,
1511: G_PKG_NAME,
1512: 'OKC_API.G_RET_STS_ERROR',

Line 1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1505: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1506:
1507: EXCEPTION
1508: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1510: (l_api_name,
1511: G_PKG_NAME,
1512: 'OKC_API.G_RET_STS_ERROR',
1513: x_msg_count,

Line 1512: 'OKC_API.G_RET_STS_ERROR',

1508: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1509: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1510: (l_api_name,
1511: G_PKG_NAME,
1512: 'OKC_API.G_RET_STS_ERROR',
1513: x_msg_count,
1514: x_msg_data,
1515: '_PUB');
1516: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1516: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1512: 'OKC_API.G_RET_STS_ERROR',
1513: x_msg_count,
1514: x_msg_data,
1515: '_PUB');
1516: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1517: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1518: (l_api_name,
1519: G_PKG_NAME,
1520: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1517: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1513: x_msg_count,
1514: x_msg_data,
1515: '_PUB');
1516: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1517: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1518: (l_api_name,
1519: G_PKG_NAME,
1520: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1521: x_msg_count,

Line 1520: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1516: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1517: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1518: (l_api_name,
1519: G_PKG_NAME,
1520: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1521: x_msg_count,
1522: x_msg_data,
1523: '_PUB');
1524: WHEN OTHERS THEN

Line 1525: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1521: x_msg_count,
1522: x_msg_data,
1523: '_PUB');
1524: WHEN OTHERS THEN
1525: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1526: (l_api_name,
1527: G_PKG_NAME,
1528: 'OTHERS',
1529: x_msg_count,

Line 1555: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1551: l_return_status Varchar2(1);
1552: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
1553:
1554: BEGIN
1555: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1556:
1557: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1558: ,p_init_msg_list
1559: ,'_PUB'

Line 1557: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1553:
1554: BEGIN
1555: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1556:
1557: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1558: ,p_init_msg_list
1559: ,'_PUB'
1560: ,x_return_status
1561: );

Line 1562: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1558: ,p_init_msg_list
1559: ,'_PUB'
1560: ,x_return_status
1561: );
1562: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1564: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1565: RAISE OKC_API.G_EXCEPTION_ERROR;
1566: END IF;

Line 1563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1559: ,'_PUB'
1560: ,x_return_status
1561: );
1562: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1564: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1565: RAISE OKC_API.G_EXCEPTION_ERROR;
1566: END IF;
1567:

Line 1564: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1560: ,x_return_status
1561: );
1562: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1564: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1565: RAISE OKC_API.G_EXCEPTION_ERROR;
1566: END IF;
1567:
1568: OKS_ENTITLEMENTS_PVT.VALIDATE_CONTRACT_LINE(p_api_version

Line 1565: RAISE OKC_API.G_EXCEPTION_ERROR;

1561: );
1562: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1564: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1565: RAISE OKC_API.G_EXCEPTION_ERROR;
1566: END IF;
1567:
1568: OKS_ENTITLEMENTS_PVT.VALIDATE_CONTRACT_LINE(p_api_version
1569: ,p_init_msg_list

Line 1582: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1578: ,x_covlevel_tbl_out
1579: ,x_combination_valid );
1580:
1581:
1582: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1585: RAISE OKC_API.G_EXCEPTION_ERROR;
1586: END IF;

Line 1583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1579: ,x_combination_valid );
1580:
1581:
1582: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1585: RAISE OKC_API.G_EXCEPTION_ERROR;
1586: END IF;
1587:

Line 1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1580:
1581:
1582: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1585: RAISE OKC_API.G_EXCEPTION_ERROR;
1586: END IF;
1587:
1588: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1585: RAISE OKC_API.G_EXCEPTION_ERROR;

1581:
1582: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1585: RAISE OKC_API.G_EXCEPTION_ERROR;
1586: END IF;
1587:
1588: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1589:

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

1584: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1585: RAISE OKC_API.G_EXCEPTION_ERROR;
1586: END IF;
1587:
1588: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1589:
1590:
1591: EXCEPTION
1592: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1592: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1588: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1589:
1590:
1591: EXCEPTION
1592: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1593: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1594: (l_api_name,
1595: G_PKG_NAME,
1596: 'OKC_API.G_RET_STS_ERROR',

Line 1593: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1589:
1590:
1591: EXCEPTION
1592: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1593: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1594: (l_api_name,
1595: G_PKG_NAME,
1596: 'OKC_API.G_RET_STS_ERROR',
1597: x_msg_count,

Line 1596: 'OKC_API.G_RET_STS_ERROR',

1592: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1593: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1594: (l_api_name,
1595: G_PKG_NAME,
1596: 'OKC_API.G_RET_STS_ERROR',
1597: x_msg_count,
1598: x_msg_data,
1599: '_PUB');
1600: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1600: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1596: 'OKC_API.G_RET_STS_ERROR',
1597: x_msg_count,
1598: x_msg_data,
1599: '_PUB');
1600: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1601: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1602: (l_api_name,
1603: G_PKG_NAME,
1604: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1601: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1597: x_msg_count,
1598: x_msg_data,
1599: '_PUB');
1600: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1601: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1602: (l_api_name,
1603: G_PKG_NAME,
1604: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1605: x_msg_count,

Line 1604: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1600: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1601: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1602: (l_api_name,
1603: G_PKG_NAME,
1604: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1605: x_msg_count,
1606: x_msg_data,
1607: '_PUB');
1608: WHEN OTHERS THEN

Line 1609: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1605: x_msg_count,
1606: x_msg_data,
1607: '_PUB');
1608: WHEN OTHERS THEN
1609: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1610: (l_api_name,
1611: G_PKG_NAME,
1612: 'OTHERS',
1613: x_msg_count,

Line 1637: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1633: l_api_name CONSTANT VARCHAR2(30) := 'Search_Contract_Lines';
1634:
1635: BEGIN
1636:
1637: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1638:
1639: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1640: ,p_init_msg_list
1641: ,'_PUB'

Line 1639: l_return_status := OKC_API.START_ACTIVITY(l_api_name

1635: BEGIN
1636:
1637: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1638:
1639: l_return_status := OKC_API.START_ACTIVITY(l_api_name
1640: ,p_init_msg_list
1641: ,'_PUB'
1642: ,x_return_status
1643: );

Line 1644: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1640: ,p_init_msg_list
1641: ,'_PUB'
1642: ,x_return_status
1643: );
1644: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;

Line 1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1641: ,'_PUB'
1642: ,x_return_status
1643: );
1644: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649:

Line 1646: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1642: ,x_return_status
1643: );
1644: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649:
1650: OKS_ENTITLEMENTS_PVT.Search_Contract_lines

Line 1647: RAISE OKC_API.G_EXCEPTION_ERROR;

1643: );
1644: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649:
1650: OKS_ENTITLEMENTS_PVT.Search_Contract_lines
1651: ( p_api_version,

Line 1662: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1658: x_msg_data,
1659: x_contract_tbl);
1660:
1661:
1662: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1665: RAISE OKC_API.G_EXCEPTION_ERROR;
1666: END IF;

Line 1663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1659: x_contract_tbl);
1660:
1661:
1662: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1665: RAISE OKC_API.G_EXCEPTION_ERROR;
1666: END IF;
1667:

Line 1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN

1660:
1661:
1662: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1665: RAISE OKC_API.G_EXCEPTION_ERROR;
1666: END IF;
1667:
1668: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);

Line 1665: RAISE OKC_API.G_EXCEPTION_ERROR;

1661:
1662: IF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1665: RAISE OKC_API.G_EXCEPTION_ERROR;
1666: END IF;
1667:
1668: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1669:

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

1664: ELSIF x_return_status = OKC_API.G_RET_STS_ERROR THEN
1665: RAISE OKC_API.G_EXCEPTION_ERROR;
1666: END IF;
1667:
1668: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1669:
1670:
1671: EXCEPTION
1672: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1672: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1668: OKC_API.END_ACTIVITY(x_msg_count,x_msg_data);
1669:
1670:
1671: EXCEPTION
1672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1674: (l_api_name,
1675: G_PKG_NAME,
1676: 'OKC_API.G_RET_STS_ERROR',

Line 1673: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1669:
1670:
1671: EXCEPTION
1672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1674: (l_api_name,
1675: G_PKG_NAME,
1676: 'OKC_API.G_RET_STS_ERROR',
1677: x_msg_count,

Line 1676: 'OKC_API.G_RET_STS_ERROR',

1672: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1673: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1674: (l_api_name,
1675: G_PKG_NAME,
1676: 'OKC_API.G_RET_STS_ERROR',
1677: x_msg_count,
1678: x_msg_data,
1679: '_PUB');
1680: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1680: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1676: 'OKC_API.G_RET_STS_ERROR',
1677: x_msg_count,
1678: x_msg_data,
1679: '_PUB');
1680: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1682: (l_api_name,
1683: G_PKG_NAME,
1684: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1681: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1677: x_msg_count,
1678: x_msg_data,
1679: '_PUB');
1680: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1682: (l_api_name,
1683: G_PKG_NAME,
1684: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1685: x_msg_count,

Line 1684: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1680: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1681: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1682: (l_api_name,
1683: G_PKG_NAME,
1684: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1685: x_msg_count,
1686: x_msg_data,
1687: '_PUB');
1688: WHEN OTHERS THEN

Line 1689: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1685: x_msg_count,
1686: x_msg_data,
1687: '_PUB');
1688: WHEN OTHERS THEN
1689: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1690: (l_api_name,
1691: G_PKG_NAME,
1692: 'OTHERS',
1693: x_msg_count,