40:
41:
42: -- call START_ACTIVITY to create savepoint, check compatibility
43: -- and initialize message list
44: x_return_status := OKC_API.START_ACTIVITY(
45: p_api_name => l_api_name,
46: p_pkg_name => G_PKG_NAME,
47: p_init_msg_list => p_init_msg_list,
48: l_api_version => l_api_version,
50: p_api_type => G_API_TYPE,
51: x_return_status => x_return_status);
52:
53: -- check if activity started successfully
54: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
55: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
57: raise OKC_API.G_EXCEPTION_ERROR;
58: END IF;
51: x_return_status => x_return_status);
52:
53: -- check if activity started successfully
54: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
55: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
57: raise OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59:
52:
53: -- check if activity started successfully
54: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
55: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
57: raise OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59:
60: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
53: -- check if activity started successfully
54: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
55: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
56: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
57: raise OKC_API.G_EXCEPTION_ERROR;
58: END IF;
59:
60: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
61: okl_service_integration_pvt.create_link_service_line(
70: p_supplier_id => p_supplier_id,
71: x_okl_service_line_id => x_okl_service_line_id
72: );
73:
74: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
75: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
77: raise OKC_API.G_EXCEPTION_ERROR;
78: END IF;
71: x_okl_service_line_id => x_okl_service_line_id
72: );
73:
74: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
75: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
77: raise OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:
72: );
73:
74: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
75: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
77: raise OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:
80: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
73:
74: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
75: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
76: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
77: raise OKC_API.G_EXCEPTION_ERROR;
78: END IF;
79:
80: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
81:
83: x_msg_data => x_msg_data);
84:
85: EXCEPTION
86:
87: when OKC_API.G_EXCEPTION_ERROR then
88: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
89: p_api_name => l_api_name,
90: p_pkg_name => G_PKG_NAME,
91: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
84:
85: EXCEPTION
86:
87: when OKC_API.G_EXCEPTION_ERROR then
88: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
89: p_api_name => l_api_name,
90: p_pkg_name => G_PKG_NAME,
91: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
92: x_msg_count => x_msg_count,
87: when OKC_API.G_EXCEPTION_ERROR then
88: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
89: p_api_name => l_api_name,
90: p_pkg_name => G_PKG_NAME,
91: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
92: x_msg_count => x_msg_count,
93: x_msg_data => x_msg_data,
94: p_api_type => G_API_TYPE);
95:
92: x_msg_count => x_msg_count,
93: x_msg_data => x_msg_data,
94: p_api_type => G_API_TYPE);
95:
96: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
98: p_api_name => l_api_name,
99: p_pkg_name => G_PKG_NAME,
100: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
93: x_msg_data => x_msg_data,
94: p_api_type => G_API_TYPE);
95:
96: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
98: p_api_name => l_api_name,
99: p_pkg_name => G_PKG_NAME,
100: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
101: x_msg_count => x_msg_count,
96: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
97: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
98: p_api_name => l_api_name,
99: p_pkg_name => G_PKG_NAME,
100: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
101: x_msg_count => x_msg_count,
102: x_msg_data => x_msg_data,
103: p_api_type => G_API_TYPE);
104:
102: x_msg_data => x_msg_data,
103: p_api_type => G_API_TYPE);
104:
105: when OTHERS then
106: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
107: p_api_name => l_api_name,
108: p_pkg_name => G_PKG_NAME,
109: p_exc_name => 'OTHERS',
110: x_msg_count => x_msg_count,
141: BEGIN -- main process begins here
142:
143: -- call START_ACTIVITY to create savepoint, check compatibility
144: -- and initialize message list
145: x_return_status := OKC_API.START_ACTIVITY(
146: p_api_name => l_api_name,
147: p_pkg_name => G_PKG_NAME,
148: p_init_msg_list => p_init_msg_list,
149: l_api_version => l_api_version,
151: p_api_type => G_API_TYPE,
152: x_return_status => x_return_status);
153:
154: -- check if activity started successfully
155: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
156: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
157: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
158: raise OKC_API.G_EXCEPTION_ERROR;
159: END IF;
152: x_return_status => x_return_status);
153:
154: -- check if activity started successfully
155: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
156: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
157: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
158: raise OKC_API.G_EXCEPTION_ERROR;
159: END IF;
160:
153:
154: -- check if activity started successfully
155: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
156: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
157: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
158: raise OKC_API.G_EXCEPTION_ERROR;
159: END IF;
160:
161: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
154: -- check if activity started successfully
155: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
156: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
157: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
158: raise OKC_API.G_EXCEPTION_ERROR;
159: END IF;
160:
161: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
162:
172: p_supplier_id => p_supplier_id,
173: x_okl_service_line_id => x_okl_service_line_id
174: );
175:
176: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
177: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
178: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
179: raise OKC_API.G_EXCEPTION_ERROR;
180: END IF;
173: x_okl_service_line_id => x_okl_service_line_id
174: );
175:
176: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
177: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
178: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
179: raise OKC_API.G_EXCEPTION_ERROR;
180: END IF;
181:
174: );
175:
176: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
177: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
178: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
179: raise OKC_API.G_EXCEPTION_ERROR;
180: END IF;
181:
182: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
175:
176: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
177: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
178: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
179: raise OKC_API.G_EXCEPTION_ERROR;
180: END IF;
181:
182: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
183:
185: x_msg_data => x_msg_data);
186:
187: EXCEPTION
188:
189: when OKC_API.G_EXCEPTION_ERROR then
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
191: p_api_name => l_api_name,
192: p_pkg_name => G_PKG_NAME,
193: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
186:
187: EXCEPTION
188:
189: when OKC_API.G_EXCEPTION_ERROR then
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
191: p_api_name => l_api_name,
192: p_pkg_name => G_PKG_NAME,
193: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
194: x_msg_count => x_msg_count,
189: when OKC_API.G_EXCEPTION_ERROR then
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
191: p_api_name => l_api_name,
192: p_pkg_name => G_PKG_NAME,
193: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
194: x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data,
196: p_api_type => G_API_TYPE);
197:
194: x_msg_count => x_msg_count,
195: x_msg_data => x_msg_data,
196: p_api_type => G_API_TYPE);
197:
198: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
199: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
200: p_api_name => l_api_name,
201: p_pkg_name => G_PKG_NAME,
202: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
195: x_msg_data => x_msg_data,
196: p_api_type => G_API_TYPE);
197:
198: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
199: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
200: p_api_name => l_api_name,
201: p_pkg_name => G_PKG_NAME,
202: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
203: x_msg_count => x_msg_count,
198: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
199: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
200: p_api_name => l_api_name,
201: p_pkg_name => G_PKG_NAME,
202: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
203: x_msg_count => x_msg_count,
204: x_msg_data => x_msg_data,
205: p_api_type => G_API_TYPE);
206:
204: x_msg_data => x_msg_data,
205: p_api_type => G_API_TYPE);
206:
207: when OTHERS then
208: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
209: p_api_name => l_api_name,
210: p_pkg_name => G_PKG_NAME,
211: p_exc_name => 'OTHERS',
212: x_msg_count => x_msg_count,
244: BEGIN
245:
246: -- call START_ACTIVITY to create savepoint, check compatibility
247: -- and initialize message list
248: x_return_status := OKC_API.START_ACTIVITY(
249: p_api_name => l_api_name,
250: p_pkg_name => G_PKG_NAME,
251: p_init_msg_list => p_init_msg_list,
252: l_api_version => l_api_version,
254: p_api_type => G_API_TYPE,
255: x_return_status => x_return_status);
256:
257: -- check if activity started successfully
258: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
259: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
261: raise OKC_API.G_EXCEPTION_ERROR;
262: END IF;
255: x_return_status => x_return_status);
256:
257: -- check if activity started successfully
258: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
259: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
261: raise OKC_API.G_EXCEPTION_ERROR;
262: END IF;
263:
256:
257: -- check if activity started successfully
258: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
259: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
261: raise OKC_API.G_EXCEPTION_ERROR;
262: END IF;
263:
264: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
257: -- check if activity started successfully
258: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
259: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
260: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
261: raise OKC_API.G_EXCEPTION_ERROR;
262: END IF;
263:
264: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
265:
274: p_okl_service_line_id => p_okl_service_line_id,
275: p_oks_service_line_id => p_oks_service_line_id
276: );
277:
278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
279: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
281: raise OKC_API.G_EXCEPTION_ERROR;
282: END IF;
275: p_oks_service_line_id => p_oks_service_line_id
276: );
277:
278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
279: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
281: raise OKC_API.G_EXCEPTION_ERROR;
282: END IF;
283:
276: );
277:
278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
279: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
281: raise OKC_API.G_EXCEPTION_ERROR;
282: END IF;
283:
284: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
277:
278: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
279: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
280: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
281: raise OKC_API.G_EXCEPTION_ERROR;
282: END IF;
283:
284: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
285:
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);
288:
289: EXCEPTION
290: when OKC_API.G_EXCEPTION_ERROR then
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
292: p_api_name => l_api_name,
293: p_pkg_name => G_PKG_NAME,
294: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
287: x_msg_data => x_msg_data);
288:
289: EXCEPTION
290: when OKC_API.G_EXCEPTION_ERROR then
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
292: p_api_name => l_api_name,
293: p_pkg_name => G_PKG_NAME,
294: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
295: x_msg_count => x_msg_count,
290: when OKC_API.G_EXCEPTION_ERROR then
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
292: p_api_name => l_api_name,
293: p_pkg_name => G_PKG_NAME,
294: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
295: x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data,
297: p_api_type => G_API_TYPE);
298:
295: x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data,
297: p_api_type => G_API_TYPE);
298:
299: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
301: p_api_name => l_api_name,
302: p_pkg_name => G_PKG_NAME,
303: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
296: x_msg_data => x_msg_data,
297: p_api_type => G_API_TYPE);
298:
299: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
301: p_api_name => l_api_name,
302: p_pkg_name => G_PKG_NAME,
303: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
304: x_msg_count => x_msg_count,
299: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
300: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
301: p_api_name => l_api_name,
302: p_pkg_name => G_PKG_NAME,
303: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307:
305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307:
308: when OTHERS then
309: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
310: p_api_name => l_api_name,
311: p_pkg_name => G_PKG_NAME,
312: p_exc_name => 'OTHERS',
313: x_msg_count => x_msg_count,
339: l_api_version CONSTANT NUMBER := 1;
340:
341: BEGIN -- main process begins here
342:
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;
344: -- call START_ACTIVITY to create savepoint, check compatibility
345: -- and initialize message list
346: x_return_status := OKC_API.START_ACTIVITY(
347: p_api_name => l_api_name,
342:
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;
344: -- call START_ACTIVITY to create savepoint, check compatibility
345: -- and initialize message list
346: x_return_status := OKC_API.START_ACTIVITY(
347: p_api_name => l_api_name,
348: p_pkg_name => G_PKG_NAME,
349: p_init_msg_list => p_init_msg_list,
350: l_api_version => l_api_version,
352: p_api_type => G_API_TYPE,
353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: END IF;
353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:
354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
363:
370: p_clev_rec => p_clev_rec,
371: p_klev_rec => p_klev_rec
372: );
373:
374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
371: p_klev_rec => p_klev_rec
372: );
373:
374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
372: );
373:
374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
373:
374: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
375: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
377: raise OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
381:
382: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data);
384:
385: EXCEPTION
386: when OKC_API.G_EXCEPTION_ERROR then
387: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
388: p_api_name => l_api_name,
389: p_pkg_name => G_PKG_NAME,
390: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
383: x_msg_data => x_msg_data);
384:
385: EXCEPTION
386: when OKC_API.G_EXCEPTION_ERROR then
387: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
388: p_api_name => l_api_name,
389: p_pkg_name => G_PKG_NAME,
390: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
391: x_msg_count => x_msg_count,
386: when OKC_API.G_EXCEPTION_ERROR then
387: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
388: p_api_name => l_api_name,
389: p_pkg_name => G_PKG_NAME,
390: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data,
393: p_api_type => G_API_TYPE);
394:
391: x_msg_count => x_msg_count,
392: x_msg_data => x_msg_data,
393: p_api_type => G_API_TYPE);
394:
395: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
396: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
392: x_msg_data => x_msg_data,
393: p_api_type => G_API_TYPE);
394:
395: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
396: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
400: x_msg_count => x_msg_count,
395: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
396: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
397: p_api_name => l_api_name,
398: p_pkg_name => G_PKG_NAME,
399: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
400: x_msg_count => x_msg_count,
401: x_msg_data => x_msg_data,
402: p_api_type => G_API_TYPE);
403:
401: x_msg_data => x_msg_data,
402: p_api_type => G_API_TYPE);
403:
404: when OTHERS then
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
406: p_api_name => l_api_name,
407: p_pkg_name => G_PKG_NAME,
408: p_exc_name => 'OTHERS',
409: x_msg_count => x_msg_count,
441: l_api_version CONSTANT NUMBER := 1;
442:
443: BEGIN -- main process begins here
444:
445: x_return_status := OKC_API.G_RET_STS_SUCCESS;
446: -- call START_ACTIVITY to create savepoint, check compatibility
447: -- and initialize message list
448: x_return_status := OKC_API.START_ACTIVITY(
449: p_api_name => l_api_name,
444:
445: x_return_status := OKC_API.G_RET_STS_SUCCESS;
446: -- call START_ACTIVITY to create savepoint, check compatibility
447: -- and initialize message list
448: x_return_status := OKC_API.START_ACTIVITY(
449: p_api_name => l_api_name,
450: p_pkg_name => G_PKG_NAME,
451: p_init_msg_list => p_init_msg_list,
452: l_api_version => l_api_version,
454: p_api_type => G_API_TYPE,
455: x_return_status => x_return_status);
456:
457: -- check if activity started successfully
458: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
459: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
461: raise OKC_API.G_EXCEPTION_ERROR;
462: END IF;
455: x_return_status => x_return_status);
456:
457: -- check if activity started successfully
458: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
459: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
461: raise OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463:
456:
457: -- check if activity started successfully
458: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
459: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
461: raise OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463:
464: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
457: -- check if activity started successfully
458: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
459: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
460: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
461: raise OKC_API.G_EXCEPTION_ERROR;
462: END IF;
463:
464: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
465:
477: p_klev_rec => p_klev_rec,
478: x_okl_service_line_id => x_okl_service_line_id
479: );
480:
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
478: x_okl_service_line_id => x_okl_service_line_id
479: );
480:
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:
479: );
480:
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
480:
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
488:
489: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data);
491:
492: EXCEPTION
493: when OKC_API.G_EXCEPTION_ERROR then
494: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => G_PKG_NAME,
497: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
490: x_msg_data => x_msg_data);
491:
492: EXCEPTION
493: when OKC_API.G_EXCEPTION_ERROR then
494: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => G_PKG_NAME,
497: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
498: x_msg_count => x_msg_count,
493: when OKC_API.G_EXCEPTION_ERROR then
494: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
495: p_api_name => l_api_name,
496: p_pkg_name => G_PKG_NAME,
497: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501:
498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501:
502: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
503: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
504: p_api_name => l_api_name,
505: p_pkg_name => G_PKG_NAME,
506: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
499: x_msg_data => x_msg_data,
500: p_api_type => G_API_TYPE);
501:
502: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
503: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
504: p_api_name => l_api_name,
505: p_pkg_name => G_PKG_NAME,
506: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
507: x_msg_count => x_msg_count,
502: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
503: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
504: p_api_name => l_api_name,
505: p_pkg_name => G_PKG_NAME,
506: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data,
509: p_api_type => G_API_TYPE);
510:
508: x_msg_data => x_msg_data,
509: p_api_type => G_API_TYPE);
510:
511: when OTHERS then
512: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
513: p_api_name => l_api_name,
514: p_pkg_name => G_PKG_NAME,
515: p_exc_name => 'OTHERS',
516: x_msg_count => x_msg_count,
548: BEGIN
549:
550: -- call START_ACTIVITY to create savepoint, check compatibility
551: -- and initialize message list
552: x_return_status := OKC_API.START_ACTIVITY(
553: p_api_name => l_api_name,
554: p_pkg_name => G_PKG_NAME,
555: p_init_msg_list => p_init_msg_list,
556: l_api_version => l_api_version,
558: p_api_type => G_API_TYPE,
559: x_return_status => x_return_status);
560:
561: -- check if activity started successfully
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
565: raise OKC_API.G_EXCEPTION_ERROR;
566: END IF;
559: x_return_status => x_return_status);
560:
561: -- check if activity started successfully
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
565: raise OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
560:
561: -- check if activity started successfully
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
565: raise OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
561: -- check if activity started successfully
562: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
564: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
565: raise OKC_API.G_EXCEPTION_ERROR;
566: END IF;
567:
568: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
569: okl_service_integration_pvt.check_service_link(
575: p_lease_contract_id => p_lease_contract_id,
576: x_service_contract_id => x_service_contract_id
577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
580: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
582: raise OKC_API.G_EXCEPTION_ERROR;
583: END IF;
576: x_service_contract_id => x_service_contract_id
577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
580: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
582: raise OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
577: );
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
580: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
582: raise OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
578:
579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
580: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
582: raise OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
586:
587: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
588: x_msg_data => x_msg_data);
589:
590: EXCEPTION
591: when OKC_API.G_EXCEPTION_ERROR then
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
593: p_api_name => l_api_name,
594: p_pkg_name => G_PKG_NAME,
595: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
588: x_msg_data => x_msg_data);
589:
590: EXCEPTION
591: when OKC_API.G_EXCEPTION_ERROR then
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
593: p_api_name => l_api_name,
594: p_pkg_name => G_PKG_NAME,
595: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
596: x_msg_count => x_msg_count,
591: when OKC_API.G_EXCEPTION_ERROR then
592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
593: p_api_name => l_api_name,
594: p_pkg_name => G_PKG_NAME,
595: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
596: x_msg_count => x_msg_count,
597: x_msg_data => x_msg_data,
598: p_api_type => G_API_TYPE);
599:
596: x_msg_count => x_msg_count,
597: x_msg_data => x_msg_data,
598: p_api_type => G_API_TYPE);
599:
600: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
601: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
602: p_api_name => l_api_name,
603: p_pkg_name => G_PKG_NAME,
604: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
597: x_msg_data => x_msg_data,
598: p_api_type => G_API_TYPE);
599:
600: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
601: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
602: p_api_name => l_api_name,
603: p_pkg_name => G_PKG_NAME,
604: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
605: x_msg_count => x_msg_count,
600: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
601: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
602: p_api_name => l_api_name,
603: p_pkg_name => G_PKG_NAME,
604: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
605: x_msg_count => x_msg_count,
606: x_msg_data => x_msg_data,
607: p_api_type => G_API_TYPE);
608:
606: x_msg_data => x_msg_data,
607: p_api_type => G_API_TYPE);
608:
609: when OTHERS then
610: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
611: p_api_name => l_api_name,
612: p_pkg_name => G_PKG_NAME,
613: p_exc_name => 'OTHERS',
614: x_msg_count => x_msg_count,
644: BEGIN
645:
646: -- call START_ACTIVITY to create savepoint, check compatibility
647: -- and initialize message list
648: x_return_status := OKC_API.START_ACTIVITY(
649: p_api_name => l_api_name,
650: p_pkg_name => G_PKG_NAME,
651: p_init_msg_list => p_init_msg_list,
652: l_api_version => l_api_version,
654: p_api_type => G_API_TYPE,
655: x_return_status => x_return_status);
656:
657: -- check if activity started successfully
658: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
659: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
661: raise OKC_API.G_EXCEPTION_ERROR;
662: END IF;
655: x_return_status => x_return_status);
656:
657: -- check if activity started successfully
658: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
659: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
661: raise OKC_API.G_EXCEPTION_ERROR;
662: END IF;
663:
656:
657: -- check if activity started successfully
658: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
659: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
661: raise OKC_API.G_EXCEPTION_ERROR;
662: END IF;
663:
664: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
657: -- check if activity started successfully
658: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
659: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
660: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
661: raise OKC_API.G_EXCEPTION_ERROR;
662: END IF;
663:
664: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
665: okl_service_integration_pvt.get_service_link_line(
672: x_link_line_tbl => x_link_line_tbl,
673: x_service_contract_id => x_service_contract_id
674: );
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
677: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
679: raise OKC_API.G_EXCEPTION_ERROR;
680: END IF;
673: x_service_contract_id => x_service_contract_id
674: );
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
677: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
679: raise OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:
674: );
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
677: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
679: raise OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
677: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
679: raise OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
683:
684: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
685: x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
685: x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
693: x_msg_count => x_msg_count,
688: when OKC_API.G_EXCEPTION_ERROR then
689: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
690: p_api_name => l_api_name,
691: p_pkg_name => G_PKG_NAME,
692: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,
695: p_api_type => G_API_TYPE);
696:
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data,
695: p_api_type => G_API_TYPE);
696:
697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => G_PKG_NAME,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
694: x_msg_data => x_msg_data,
695: p_api_type => G_API_TYPE);
696:
697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => G_PKG_NAME,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
702: x_msg_count => x_msg_count,
697: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
698: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
699: p_api_name => l_api_name,
700: p_pkg_name => G_PKG_NAME,
701: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data,
704: p_api_type => G_API_TYPE);
705:
703: x_msg_data => x_msg_data,
704: p_api_type => G_API_TYPE);
705:
706: when OTHERS then
707: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
708: p_api_name => l_api_name,
709: p_pkg_name => G_PKG_NAME,
710: p_exc_name => 'OTHERS',
711: x_msg_count => x_msg_count,
725: -- Called By:
726: ------------------------------------------------------------------------------
727: PROCEDURE create_cov_asset_line(
728: p_api_version IN NUMBER,
729: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
730: x_return_status OUT NOCOPY VARCHAR2,
731: x_msg_count OUT NOCOPY NUMBER,
732: x_msg_data OUT NOCOPY VARCHAR2,
733: p_clev_tbl IN clev_tbl_type,
744:
745:
746: BEGIN -- main process begins here
747:
748: x_return_status := OKC_API.G_RET_STS_SUCCESS;
749: -- call START_ACTIVITY to create savepoint, check compatibility
750: -- and initialize message list
751: x_return_status := OKC_API.START_ACTIVITY(
752: p_api_name => l_api_name,
747:
748: x_return_status := OKC_API.G_RET_STS_SUCCESS;
749: -- call START_ACTIVITY to create savepoint, check compatibility
750: -- and initialize message list
751: x_return_status := OKC_API.START_ACTIVITY(
752: p_api_name => l_api_name,
753: p_pkg_name => G_PKG_NAME,
754: p_init_msg_list => p_init_msg_list,
755: l_api_version => l_api_version,
757: p_api_type => G_API_TYPE,
758: x_return_status => x_return_status);
759:
760: -- check if activity started successfully
761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
762: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
764: raise OKC_API.G_EXCEPTION_ERROR;
765: END IF;
758: x_return_status => x_return_status);
759:
760: -- check if activity started successfully
761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
762: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
764: raise OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:
759:
760: -- check if activity started successfully
761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
762: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
764: raise OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:
767: OKL_SERVICE_INTEGRATION_PVT.CREATE_COV_ASSET_LINE (
760: -- check if activity started successfully
761: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
762: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
764: raise OKC_API.G_EXCEPTION_ERROR;
765: END IF;
766:
767: OKL_SERVICE_INTEGRATION_PVT.CREATE_COV_ASSET_LINE (
768: p_api_version => p_api_version,
778: x_klev_tbl => x_klev_tbl,
779: x_cimv_tbl => x_cimv_tbl
780: );
781:
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
783: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
785: raise OKC_API.G_EXCEPTION_ERROR;
786: END IF;
779: x_cimv_tbl => x_cimv_tbl
780: );
781:
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
783: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
785: raise OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
780: );
781:
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
783: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
785: raise OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
788: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
781:
782: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
783: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
785: raise OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
788: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
789: x_msg_data => x_msg_data);
788: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
789: x_msg_data => x_msg_data);
790:
791: EXCEPTION
792: when OKC_API.G_EXCEPTION_ERROR then
793: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
794: p_api_name => l_api_name,
795: p_pkg_name => G_PKG_NAME,
796: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
789: x_msg_data => x_msg_data);
790:
791: EXCEPTION
792: when OKC_API.G_EXCEPTION_ERROR then
793: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
794: p_api_name => l_api_name,
795: p_pkg_name => G_PKG_NAME,
796: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
797: x_msg_count => x_msg_count,
792: when OKC_API.G_EXCEPTION_ERROR then
793: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
794: p_api_name => l_api_name,
795: p_pkg_name => G_PKG_NAME,
796: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
797: x_msg_count => x_msg_count,
798: x_msg_data => x_msg_data,
799: p_api_type => G_API_TYPE);
800:
797: x_msg_count => x_msg_count,
798: x_msg_data => x_msg_data,
799: p_api_type => G_API_TYPE);
800:
801: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
802: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
803: p_api_name => l_api_name,
804: p_pkg_name => G_PKG_NAME,
805: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
798: x_msg_data => x_msg_data,
799: p_api_type => G_API_TYPE);
800:
801: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
802: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
803: p_api_name => l_api_name,
804: p_pkg_name => G_PKG_NAME,
805: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
806: x_msg_count => x_msg_count,
801: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
802: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
803: p_api_name => l_api_name,
804: p_pkg_name => G_PKG_NAME,
805: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
806: x_msg_count => x_msg_count,
807: x_msg_data => x_msg_data,
808: p_api_type => G_API_TYPE);
809:
807: x_msg_data => x_msg_data,
808: p_api_type => G_API_TYPE);
809:
810: when OTHERS then
811: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
812: p_api_name => l_api_name,
813: p_pkg_name => G_PKG_NAME,
814: p_exc_name => 'OTHERS',
815: x_msg_count => x_msg_count,
828: -- Called By:
829: ------------------------------------------------------------------------------
830: PROCEDURE update_cov_asset_line(
831: p_api_version IN NUMBER,
832: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
833: x_return_status OUT NOCOPY VARCHAR2,
834: x_msg_count OUT NOCOPY NUMBER,
835: x_msg_data OUT NOCOPY VARCHAR2,
836: p_clev_tbl IN clev_tbl_type,
847:
848:
849: BEGIN -- main process begins here
850:
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- call START_ACTIVITY to create savepoint, check compatibility
853: -- and initialize message list
854: x_return_status := OKC_API.START_ACTIVITY(
855: p_api_name => l_api_name,
850:
851: x_return_status := OKC_API.G_RET_STS_SUCCESS;
852: -- call START_ACTIVITY to create savepoint, check compatibility
853: -- and initialize message list
854: x_return_status := OKC_API.START_ACTIVITY(
855: p_api_name => l_api_name,
856: p_pkg_name => G_PKG_NAME,
857: p_init_msg_list => p_init_msg_list,
858: l_api_version => l_api_version,
860: p_api_type => G_API_TYPE,
861: x_return_status => x_return_status);
862:
863: -- check if activity started successfully
864: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
865: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
867: raise OKC_API.G_EXCEPTION_ERROR;
868: END IF;
861: x_return_status => x_return_status);
862:
863: -- check if activity started successfully
864: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
865: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
867: raise OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869:
862:
863: -- check if activity started successfully
864: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
865: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
867: raise OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869:
870: OKL_SERVICE_INTEGRATION_PVT.UPDATE_COV_ASSET_LINE (
863: -- check if activity started successfully
864: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
865: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
867: raise OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869:
870: OKL_SERVICE_INTEGRATION_PVT.UPDATE_COV_ASSET_LINE (
871: p_api_version => p_api_version,
881: x_klev_tbl => x_klev_tbl,
882: x_cimv_tbl => x_cimv_tbl
883: );
884:
885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: END IF;
882: x_cimv_tbl => x_cimv_tbl
883: );
884:
885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
883: );
884:
885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
884:
885: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
886: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
891: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
893:
894: EXCEPTION
895: when OKC_API.G_EXCEPTION_ERROR then
896: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
897: p_api_name => l_api_name,
898: p_pkg_name => G_PKG_NAME,
899: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
892: x_msg_data => x_msg_data);
893:
894: EXCEPTION
895: when OKC_API.G_EXCEPTION_ERROR then
896: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
897: p_api_name => l_api_name,
898: p_pkg_name => G_PKG_NAME,
899: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
900: x_msg_count => x_msg_count,
895: when OKC_API.G_EXCEPTION_ERROR then
896: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
897: p_api_name => l_api_name,
898: p_pkg_name => G_PKG_NAME,
899: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
900: x_msg_count => x_msg_count,
901: x_msg_data => x_msg_data,
902: p_api_type => G_API_TYPE);
903:
900: x_msg_count => x_msg_count,
901: x_msg_data => x_msg_data,
902: p_api_type => G_API_TYPE);
903:
904: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
905: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => G_PKG_NAME,
908: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
901: x_msg_data => x_msg_data,
902: p_api_type => G_API_TYPE);
903:
904: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
905: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => G_PKG_NAME,
908: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
909: x_msg_count => x_msg_count,
904: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
905: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => G_PKG_NAME,
908: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data,
911: p_api_type => G_API_TYPE);
912:
910: x_msg_data => x_msg_data,
911: p_api_type => G_API_TYPE);
912:
913: when OTHERS then
914: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
915: p_api_name => l_api_name,
916: p_pkg_name => G_PKG_NAME,
917: p_exc_name => 'OTHERS',
918: x_msg_count => x_msg_count,
932: -- Called By:
933: ------------------------------------------------------------------------------
934: PROCEDURE initiate_service_booking(
935: p_api_version IN NUMBER,
936: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
937: x_return_status OUT NOCOPY VARCHAR2,
938: x_msg_count OUT NOCOPY NUMBER,
939: x_msg_data OUT NOCOPY VARCHAR2,
940: p_okl_chr_id IN OKC_K_HEADERS_B.ID%TYPE
944: l_api_version CONSTANT NUMBER := 1;
945:
946: BEGIN
947:
948: x_return_status := OKC_API.G_RET_STS_SUCCESS;
949:
950: -- call START_ACTIVITY to create savepoint, check compatibility
951: -- and initialize message list
952: x_return_status := OKC_API.START_ACTIVITY(
948: x_return_status := OKC_API.G_RET_STS_SUCCESS;
949:
950: -- call START_ACTIVITY to create savepoint, check compatibility
951: -- and initialize message list
952: x_return_status := OKC_API.START_ACTIVITY(
953: p_api_name => l_api_name,
954: p_pkg_name => G_PKG_NAME,
955: p_init_msg_list => p_init_msg_list,
956: l_api_version => l_api_version,
958: p_api_type => G_API_TYPE,
959: x_return_status => x_return_status);
960:
961: -- check if activity started successfully
962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
963: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
965: raise OKC_API.G_EXCEPTION_ERROR;
966: END IF;
959: x_return_status => x_return_status);
960:
961: -- check if activity started successfully
962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
963: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
965: raise OKC_API.G_EXCEPTION_ERROR;
966: END IF;
967: --************************************************
960:
961: -- check if activity started successfully
962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
963: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
965: raise OKC_API.G_EXCEPTION_ERROR;
966: END IF;
967: --************************************************
968:
961: -- check if activity started successfully
962: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
963: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
964: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
965: raise OKC_API.G_EXCEPTION_ERROR;
966: END IF;
967: --************************************************
968:
969: okl_service_integration_pvt.initiate_service_booking(
974: x_msg_data => x_msg_data,
975: p_okl_chr_id => p_okl_chr_id
976: );
977:
978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
979: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
981: raise OKC_API.G_EXCEPTION_ERROR;
982: END IF;
975: p_okl_chr_id => p_okl_chr_id
976: );
977:
978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
979: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
981: raise OKC_API.G_EXCEPTION_ERROR;
982: END IF;
983:
976: );
977:
978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
979: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
981: raise OKC_API.G_EXCEPTION_ERROR;
982: END IF;
983:
984: --************************************************
977:
978: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
979: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
980: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
981: raise OKC_API.G_EXCEPTION_ERROR;
982: END IF;
983:
984: --************************************************
985:
986: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data);
988:
989: EXCEPTION
990: when OKC_API.G_EXCEPTION_ERROR then
991: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
992: p_api_name => l_api_name,
993: p_pkg_name => G_PKG_NAME,
994: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
987: x_msg_data => x_msg_data);
988:
989: EXCEPTION
990: when OKC_API.G_EXCEPTION_ERROR then
991: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
992: p_api_name => l_api_name,
993: p_pkg_name => G_PKG_NAME,
994: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
995: x_msg_count => x_msg_count,
990: when OKC_API.G_EXCEPTION_ERROR then
991: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
992: p_api_name => l_api_name,
993: p_pkg_name => G_PKG_NAME,
994: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
995: x_msg_count => x_msg_count,
996: x_msg_data => x_msg_data,
997: p_api_type => G_API_TYPE);
998:
995: x_msg_count => x_msg_count,
996: x_msg_data => x_msg_data,
997: p_api_type => G_API_TYPE);
998:
999: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1000: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1001: p_api_name => l_api_name,
1002: p_pkg_name => G_PKG_NAME,
1003: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
996: x_msg_data => x_msg_data,
997: p_api_type => G_API_TYPE);
998:
999: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1000: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1001: p_api_name => l_api_name,
1002: p_pkg_name => G_PKG_NAME,
1003: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1004: x_msg_count => x_msg_count,
999: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1000: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1001: p_api_name => l_api_name,
1002: p_pkg_name => G_PKG_NAME,
1003: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1004: x_msg_count => x_msg_count,
1005: x_msg_data => x_msg_data,
1006: p_api_type => G_API_TYPE);
1007:
1005: x_msg_data => x_msg_data,
1006: p_api_type => G_API_TYPE);
1007:
1008: when OTHERS then
1009: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1010: p_api_name => l_api_name,
1011: p_pkg_name => G_PKG_NAME,
1012: p_exc_name => 'OTHERS',
1013: x_msg_count => x_msg_count,