eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MASS_REBOOK_PUB dependencies on OKC_API

Line 23: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 40: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 50: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 51: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 52: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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: --

Line 53: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 71: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 72: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 73: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 74: raise OKC_API.G_EXCEPTION_ERROR;

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);

Line 84: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 85: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 93: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 94: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 103: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 146: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 156: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 158: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 159: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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:

Line 182: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 193: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 202: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 203: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 212: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 253: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 264: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 266: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 285: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 286: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 287: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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:

Line 288: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 299: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 300: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 308: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 309: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 318: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 335: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 350: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 360: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 361: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 362: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 363: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 375: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 376: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 377: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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:

Line 378: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 389: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 390: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 398: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 399: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 408: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 443: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 454: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 456: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 469: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 471: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 472: raise OKC_API.G_EXCEPTION_ERROR;

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);

Line 482: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 483: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 491: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 492: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 501: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 535: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 545: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 546: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 547: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 548: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 560: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 561: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 562: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 563: raise OKC_API.G_EXCEPTION_ERROR;

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);

Line 573: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 582: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 592: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,