19: -- Called by:
20: ------------------------------------------------------------------------------
21: PROCEDURE build_and_get_contracts(
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
36:
37: BEGIN
38: -- call START_ACTIVITY to create savepoint, check compatibility
39: -- and initialize message list
40: x_return_status := OKC_API.START_ACTIVITY(
41: p_api_name => l_api_name,
42: p_pkg_name => G_PKG_NAME,
43: p_init_msg_list => p_init_msg_list,
44: l_api_version => l_api_version,
46: p_api_type => G_API_TYPE,
47: x_return_status => x_return_status);
48:
49: -- check if activity started successfully
50: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
51: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
53: raise OKC_API.G_EXCEPTION_ERROR;
54: END IF;
47: x_return_status => x_return_status);
48:
49: -- check if activity started successfully
50: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
51: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
53: raise OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:
48:
49: -- check if activity started successfully
50: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
51: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
53: raise OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:
56: --
49: -- check if activity started successfully
50: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
51: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
52: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
53: raise OKC_API.G_EXCEPTION_ERROR;
54: END IF;
55:
56: --
57: -- Get Statement from Selection criteria
67: x_mstv_tbl => x_mstv_tbl,
68: x_rbk_count => x_rbk_count
69: );
70:
71: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: END IF;
68: x_rbk_count => x_rbk_count
69: );
70:
71: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: END IF;
76:
69: );
70:
71: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
70:
71: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
74: raise OKC_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data);
80:
81: RETURN;
82:
83: EXCEPTION
84: when OKC_API.G_EXCEPTION_ERROR then
85: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
86: p_api_name => l_api_name,
87: p_pkg_name => G_PKG_NAME,
88: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
81: RETURN;
82:
83: EXCEPTION
84: when OKC_API.G_EXCEPTION_ERROR then
85: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
86: p_api_name => l_api_name,
87: p_pkg_name => G_PKG_NAME,
88: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
89: x_msg_count => x_msg_count,
84: when OKC_API.G_EXCEPTION_ERROR then
85: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
86: p_api_name => l_api_name,
87: p_pkg_name => G_PKG_NAME,
88: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
89: x_msg_count => x_msg_count,
90: x_msg_data => x_msg_data,
91: p_api_type => G_API_TYPE);
92:
89: x_msg_count => x_msg_count,
90: x_msg_data => x_msg_data,
91: p_api_type => G_API_TYPE);
92:
93: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
94: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
95: p_api_name => l_api_name,
96: p_pkg_name => G_PKG_NAME,
97: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
90: x_msg_data => x_msg_data,
91: p_api_type => G_API_TYPE);
92:
93: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
94: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
95: p_api_name => l_api_name,
96: p_pkg_name => G_PKG_NAME,
97: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
98: x_msg_count => x_msg_count,
93: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
94: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
95: p_api_name => l_api_name,
96: p_pkg_name => G_PKG_NAME,
97: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
98: x_msg_count => x_msg_count,
99: x_msg_data => x_msg_data,
100: p_api_type => G_API_TYPE);
101:
99: x_msg_data => x_msg_data,
100: p_api_type => G_API_TYPE);
101:
102: when OTHERS then
103: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
104: p_api_name => l_api_name,
105: p_pkg_name => G_PKG_NAME,
106: p_exc_name => 'OTHERS',
107: x_msg_count => x_msg_count,
119: ------------------------------------------------------------------------------
120:
121: PROCEDURE apply_mass_rebook(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_rbk_tbl IN rbk_tbl_type,
142: BEGIN
143:
144: -- call START_ACTIVITY to create savepoint, check compatibility
145: -- and initialize message list
146: x_return_status := OKC_API.START_ACTIVITY(
147: p_api_name => l_api_name,
148: p_pkg_name => G_PKG_NAME,
149: p_init_msg_list => p_init_msg_list,
150: l_api_version => l_api_version,
152: p_api_type => G_API_TYPE,
153: x_return_status => x_return_status);
154:
155: -- check if activity started successfully
156: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
159: raise OKC_API.G_EXCEPTION_ERROR;
160: END IF;
153: x_return_status => x_return_status);
154:
155: -- check if activity started successfully
156: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
159: raise OKC_API.G_EXCEPTION_ERROR;
160: END IF;
161:
154:
155: -- check if activity started successfully
156: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
159: raise OKC_API.G_EXCEPTION_ERROR;
160: END IF;
161:
162: okl_mass_rebook_pvt.apply_mass_rebook(
155: -- check if activity started successfully
156: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
158: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
159: raise OKC_API.G_EXCEPTION_ERROR;
160: END IF;
161:
162: okl_mass_rebook_pvt.apply_mass_rebook(
163: p_api_version => p_api_version,
175: p_strm_lalevl_tbl => p_strm_lalevl_tbl,
176: x_stream_trx_tbl => x_stream_trx_tbl
177: );
178:
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
176: x_stream_trx_tbl => x_stream_trx_tbl
177: );
178:
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184:
177: );
178:
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184:
185:
178:
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184:
185:
186: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
189:
190: RETURN;
191:
192: EXCEPTION
193: when OKC_API.G_EXCEPTION_ERROR then
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
195: p_api_name => l_api_name,
196: p_pkg_name => G_PKG_NAME,
197: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
190: RETURN;
191:
192: EXCEPTION
193: when OKC_API.G_EXCEPTION_ERROR then
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
195: p_api_name => l_api_name,
196: p_pkg_name => G_PKG_NAME,
197: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
198: x_msg_count => x_msg_count,
193: when OKC_API.G_EXCEPTION_ERROR then
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
195: p_api_name => l_api_name,
196: p_pkg_name => G_PKG_NAME,
197: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
198: x_msg_count => x_msg_count,
199: x_msg_data => x_msg_data,
200: p_api_type => G_API_TYPE);
201:
198: x_msg_count => x_msg_count,
199: x_msg_data => x_msg_data,
200: p_api_type => G_API_TYPE);
201:
202: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
204: p_api_name => l_api_name,
205: p_pkg_name => G_PKG_NAME,
206: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
199: x_msg_data => x_msg_data,
200: p_api_type => G_API_TYPE);
201:
202: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
204: p_api_name => l_api_name,
205: p_pkg_name => G_PKG_NAME,
206: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
207: x_msg_count => x_msg_count,
202: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
203: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
204: p_api_name => l_api_name,
205: p_pkg_name => G_PKG_NAME,
206: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
207: x_msg_count => x_msg_count,
208: x_msg_data => x_msg_data,
209: p_api_type => G_API_TYPE);
210:
208: x_msg_data => x_msg_data,
209: p_api_type => G_API_TYPE);
210:
211: when OTHERS then
212: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
213: p_api_name => l_api_name,
214: p_pkg_name => G_PKG_NAME,
215: p_exc_name => 'OTHERS',
216: x_msg_count => x_msg_count,
227: ------------------------------------------------------------------------------
228:
229: PROCEDURE apply_mass_rebook(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_rbk_tbl IN rbk_tbl_type,
249: BEGIN
250:
251: -- call START_ACTIVITY to create savepoint, check compatibility
252: -- and initialize message list
253: x_return_status := OKC_API.START_ACTIVITY(
254: p_api_name => l_api_name,
255: p_pkg_name => G_PKG_NAME,
256: p_init_msg_list => p_init_msg_list,
257: l_api_version => l_api_version,
259: p_api_type => G_API_TYPE,
260: x_return_status => x_return_status);
261:
262: -- check if activity started successfully
263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
264: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
266: raise OKC_API.G_EXCEPTION_ERROR;
267: END IF;
260: x_return_status => x_return_status);
261:
262: -- check if activity started successfully
263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
264: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
266: raise OKC_API.G_EXCEPTION_ERROR;
267: END IF;
268:
261:
262: -- check if activity started successfully
263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
264: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
266: raise OKC_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: okl_mass_rebook_pvt.apply_mass_rebook(
262: -- check if activity started successfully
263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
264: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
266: raise OKC_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: okl_mass_rebook_pvt.apply_mass_rebook(
270: p_api_version => p_api_version,
281: p_residual_value => p_residual_value,
282: p_strm_lalevl_tbl => p_strm_lalevl_tbl
283: );
284:
285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
288: raise OKC_API.G_EXCEPTION_ERROR;
289: END IF;
282: p_strm_lalevl_tbl => p_strm_lalevl_tbl
283: );
284:
285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
288: raise OKC_API.G_EXCEPTION_ERROR;
289: END IF;
290:
283: );
284:
285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
288: raise OKC_API.G_EXCEPTION_ERROR;
289: END IF;
290:
291:
284:
285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
288: raise OKC_API.G_EXCEPTION_ERROR;
289: END IF;
290:
291:
292: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
295:
296: RETURN;
297:
298: EXCEPTION
299: when OKC_API.G_EXCEPTION_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_ERROR',
296: RETURN;
297:
298: EXCEPTION
299: when OKC_API.G_EXCEPTION_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_ERROR',
304: x_msg_count => x_msg_count,
299: when OKC_API.G_EXCEPTION_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_ERROR',
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307:
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307:
308: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR 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 => 'OKC_API.G_RET_STS_UNEXP_ERROR',
305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307:
308: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR 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 => 'OKC_API.G_RET_STS_UNEXP_ERROR',
313: x_msg_count => x_msg_count,
308: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR 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 => 'OKC_API.G_RET_STS_UNEXP_ERROR',
313: x_msg_count => x_msg_count,
314: x_msg_data => x_msg_data,
315: p_api_type => G_API_TYPE);
316:
314: x_msg_data => x_msg_data,
315: p_api_type => G_API_TYPE);
316:
317: when OTHERS then
318: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
319: p_api_name => l_api_name,
320: p_pkg_name => G_PKG_NAME,
321: p_exc_name => 'OTHERS',
322: x_msg_count => x_msg_count,
331: -- Called by:
332: ------------------------------------------------------------------------------
333: PROCEDURE process_mass_rebook(
334: p_api_version IN NUMBER,
335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,
339: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
346: BEGIN
347:
348: -- call START_ACTIVITY to create savepoint, check compatibility
349: -- and initialize message list
350: x_return_status := OKC_API.START_ACTIVITY(
351: p_api_name => l_api_name,
352: p_pkg_name => G_PKG_NAME,
353: p_init_msg_list => p_init_msg_list,
354: l_api_version => l_api_version,
356: p_api_type => G_API_TYPE,
357: x_return_status => x_return_status);
358:
359: -- check if activity started successfully
360: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
361: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
362: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
363: raise OKC_API.G_EXCEPTION_ERROR;
364: END IF;
357: x_return_status => x_return_status);
358:
359: -- check if activity started successfully
360: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
361: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
362: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
363: raise OKC_API.G_EXCEPTION_ERROR;
364: END IF;
365:
358:
359: -- check if activity started successfully
360: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
361: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
362: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
363: raise OKC_API.G_EXCEPTION_ERROR;
364: END IF;
365:
366: okl_mass_rebook_pvt.process_mass_rebook(
359: -- check if activity started successfully
360: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
361: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
362: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
363: raise OKC_API.G_EXCEPTION_ERROR;
364: END IF;
365:
366: okl_mass_rebook_pvt.process_mass_rebook(
367: p_api_version => p_api_version,
371: x_msg_data => x_msg_data,
372: p_request_name => p_request_name
373: );
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
376: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
378: raise OKC_API.G_EXCEPTION_ERROR;
379: END IF;
372: p_request_name => p_request_name
373: );
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
376: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
378: raise OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380:
373: );
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
376: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
378: raise OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381:
374:
375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
376: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
378: raise OKC_API.G_EXCEPTION_ERROR;
379: END IF;
380:
381:
382: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
385:
386: RETURN;
387:
388: EXCEPTION
389: when OKC_API.G_EXCEPTION_ERROR then
390: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => G_PKG_NAME,
393: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
386: RETURN;
387:
388: EXCEPTION
389: when OKC_API.G_EXCEPTION_ERROR then
390: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => G_PKG_NAME,
393: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
394: x_msg_count => x_msg_count,
389: when OKC_API.G_EXCEPTION_ERROR then
390: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
391: p_api_name => l_api_name,
392: p_pkg_name => G_PKG_NAME,
393: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
394: x_msg_count => x_msg_count,
395: x_msg_data => x_msg_data,
396: p_api_type => G_API_TYPE);
397:
394: x_msg_count => x_msg_count,
395: x_msg_data => x_msg_data,
396: p_api_type => G_API_TYPE);
397:
398: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
399: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
400: p_api_name => l_api_name,
401: p_pkg_name => G_PKG_NAME,
402: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
395: x_msg_data => x_msg_data,
396: p_api_type => G_API_TYPE);
397:
398: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
399: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
400: p_api_name => l_api_name,
401: p_pkg_name => G_PKG_NAME,
402: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
403: x_msg_count => x_msg_count,
398: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
399: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
400: p_api_name => l_api_name,
401: p_pkg_name => G_PKG_NAME,
402: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
403: x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data,
405: p_api_type => G_API_TYPE);
406:
404: x_msg_data => x_msg_data,
405: p_api_type => G_API_TYPE);
406:
407: when OTHERS then
408: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
409: p_api_name => l_api_name,
410: p_pkg_name => G_PKG_NAME,
411: p_exc_name => 'OTHERS',
412: x_msg_count => x_msg_count,
423: -- Called by:
424: ------------------------------------------------------------------------------
425: PROCEDURE update_mass_rbk_contract(
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
428: x_return_status OUT NOCOPY VARCHAR2,
429: x_msg_count OUT NOCOPY NUMBER,
430: x_msg_data OUT NOCOPY VARCHAR2,
431: p_mstv_tbl IN MSTV_TBL_TYPE,
439: BEGIN
440:
441: -- call START_ACTIVITY to create savepoint, check compatibility
442: -- and initialize message list
443: x_return_status := OKC_API.START_ACTIVITY(
444: p_api_name => l_api_name,
445: p_pkg_name => G_PKG_NAME,
446: p_init_msg_list => p_init_msg_list,
447: l_api_version => l_api_version,
449: p_api_type => G_API_TYPE,
450: x_return_status => x_return_status);
451:
452: -- check if activity started successfully
453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
454: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
456: raise OKC_API.G_EXCEPTION_ERROR;
457: END IF;
450: x_return_status => x_return_status);
451:
452: -- check if activity started successfully
453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
454: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
456: raise OKC_API.G_EXCEPTION_ERROR;
457: END IF;
458:
451:
452: -- check if activity started successfully
453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
454: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
456: raise OKC_API.G_EXCEPTION_ERROR;
457: END IF;
458:
459: okl_mass_rebook_pvt.update_mass_rbk_contract(
452: -- check if activity started successfully
453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
454: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
456: raise OKC_API.G_EXCEPTION_ERROR;
457: END IF;
458:
459: okl_mass_rebook_pvt.update_mass_rbk_contract(
460: p_api_version => p_api_version,
465: p_mstv_tbl => p_mstv_tbl,
466: x_mstv_tbl => x_mstv_tbl
467: );
468:
469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
472: raise OKC_API.G_EXCEPTION_ERROR;
473: END IF;
466: x_mstv_tbl => x_mstv_tbl
467: );
468:
469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
472: raise OKC_API.G_EXCEPTION_ERROR;
473: END IF;
474:
467: );
468:
469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
472: raise OKC_API.G_EXCEPTION_ERROR;
473: END IF;
474:
475: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
468:
469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
472: raise OKC_API.G_EXCEPTION_ERROR;
473: END IF;
474:
475: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data);
478:
479: RETURN;
480:
481: EXCEPTION
482: when OKC_API.G_EXCEPTION_ERROR then
483: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
484: p_api_name => l_api_name,
485: p_pkg_name => G_PKG_NAME,
486: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
479: RETURN;
480:
481: EXCEPTION
482: when OKC_API.G_EXCEPTION_ERROR then
483: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
484: p_api_name => l_api_name,
485: p_pkg_name => G_PKG_NAME,
486: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
487: x_msg_count => x_msg_count,
482: when OKC_API.G_EXCEPTION_ERROR then
483: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
484: p_api_name => l_api_name,
485: p_pkg_name => G_PKG_NAME,
486: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
487: x_msg_count => x_msg_count,
488: x_msg_data => x_msg_data,
489: p_api_type => G_API_TYPE);
490:
487: x_msg_count => x_msg_count,
488: x_msg_data => x_msg_data,
489: p_api_type => G_API_TYPE);
490:
491: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
492: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
493: p_api_name => l_api_name,
494: p_pkg_name => G_PKG_NAME,
495: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
488: x_msg_data => x_msg_data,
489: p_api_type => G_API_TYPE);
490:
491: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
492: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
493: p_api_name => l_api_name,
494: p_pkg_name => G_PKG_NAME,
495: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
496: x_msg_count => x_msg_count,
491: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
492: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
493: p_api_name => l_api_name,
494: p_pkg_name => G_PKG_NAME,
495: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
496: x_msg_count => x_msg_count,
497: x_msg_data => x_msg_data,
498: p_api_type => G_API_TYPE);
499:
497: x_msg_data => x_msg_data,
498: p_api_type => G_API_TYPE);
499:
500: when OTHERS then
501: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
502: p_api_name => l_api_name,
503: p_pkg_name => G_PKG_NAME,
504: p_exc_name => 'OTHERS',
505: x_msg_count => x_msg_count,
531: BEGIN
532:
533: -- call START_ACTIVITY to create savepoint, check compatibility
534: -- and initialize message list
535: x_return_status := OKC_API.START_ACTIVITY(
536: p_api_name => l_api_name,
537: p_pkg_name => G_PKG_NAME,
538: p_init_msg_list => p_init_msg_list,
539: l_api_version => l_api_version,
541: p_api_type => G_API_TYPE,
542: x_return_status => x_return_status);
543:
544: -- check if activity started successfully
545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
546: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
548: raise OKC_API.G_EXCEPTION_ERROR;
549: END IF;
542: x_return_status => x_return_status);
543:
544: -- check if activity started successfully
545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
546: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
548: raise OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:
543:
544: -- check if activity started successfully
545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
546: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
548: raise OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:
551: okl_mass_rebook_pvt.mass_rebook_after_yield(
544: -- check if activity started successfully
545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
546: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
548: raise OKC_API.G_EXCEPTION_ERROR;
549: END IF;
550:
551: okl_mass_rebook_pvt.mass_rebook_after_yield(
552: p_api_version => p_api_version,
556: x_msg_data => x_msg_data,
557: p_chr_id => p_chr_id
558: );
559:
560: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
561: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
563: raise OKC_API.G_EXCEPTION_ERROR;
564: END IF;
557: p_chr_id => p_chr_id
558: );
559:
560: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
561: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
563: raise OKC_API.G_EXCEPTION_ERROR;
564: END IF;
565:
558: );
559:
560: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
561: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
563: raise OKC_API.G_EXCEPTION_ERROR;
564: END IF;
565:
566: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
559:
560: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
561: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
563: raise OKC_API.G_EXCEPTION_ERROR;
564: END IF;
565:
566: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data);
569:
570: RETURN;
571:
572: EXCEPTION
573: when OKC_API.G_EXCEPTION_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => G_PKG_NAME,
577: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
570: RETURN;
571:
572: EXCEPTION
573: when OKC_API.G_EXCEPTION_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => G_PKG_NAME,
577: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
578: x_msg_count => x_msg_count,
573: when OKC_API.G_EXCEPTION_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => G_PKG_NAME,
577: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,
580: p_api_type => G_API_TYPE);
581:
578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,
580: p_api_type => G_API_TYPE);
581:
582: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
584: p_api_name => l_api_name,
585: p_pkg_name => G_PKG_NAME,
586: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
579: x_msg_data => x_msg_data,
580: p_api_type => G_API_TYPE);
581:
582: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
584: p_api_name => l_api_name,
585: p_pkg_name => G_PKG_NAME,
586: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
587: x_msg_count => x_msg_count,
582: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
584: p_api_name => l_api_name,
585: p_pkg_name => G_PKG_NAME,
586: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
587: x_msg_count => x_msg_count,
588: x_msg_data => x_msg_data,
589: p_api_type => G_API_TYPE);
590:
588: x_msg_data => x_msg_data,
589: p_api_type => G_API_TYPE);
590:
591: when OTHERS 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 => 'OTHERS',
596: x_msg_count => x_msg_count,