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_LLA_UTIL_PVT dependencies on OKC_API

Line 84: x_return_status := OKC_API.G_RET_STS_SUCCESS;

80: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
81:
82: BEGIN
83:
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: -- call START_ACTIVITY to create savepoint, check compatibility
86: -- and initialize message list
87: x_return_status := OKC_API.START_ACTIVITY(
88: p_api_name => l_api_name,

Line 87: x_return_status := OKC_API.START_ACTIVITY(

83:
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: -- call START_ACTIVITY to create savepoint, check compatibility
86: -- and initialize message list
87: x_return_status := OKC_API.START_ACTIVITY(
88: p_api_name => l_api_name,
89: p_pkg_name => G_PKG_NAME,
90: p_init_msg_list => p_init_msg_list,
91: l_api_version => l_api_version,

Line 97: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

93: p_api_type => G_API_TYPE,
94: x_return_status => x_return_status);
95:
96: -- check if activity started successfully
97: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
100: RAISE OKC_API.G_EXCEPTION_ERROR;
101: END IF;

Line 98: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

94: x_return_status => x_return_status);
95:
96: -- check if activity started successfully
97: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
100: RAISE OKC_API.G_EXCEPTION_ERROR;
101: END IF;
102:

Line 99: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

95:
96: -- check if activity started successfully
97: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
100: RAISE OKC_API.G_EXCEPTION_ERROR;
101: END IF;
102:
103:

Line 100: RAISE OKC_API.G_EXCEPTION_ERROR;

96: -- check if activity started successfully
97: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
100: RAISE OKC_API.G_EXCEPTION_ERROR;
101: END IF;
102:
103:
104: x_amount := OKL_ACCOUNTING_UTIL.cc_round_format_amount(p_amount => TO_NUMBER(get_number(p_amount)),

Line 112: WHEN OKC_API.G_EXCEPTION_ERROR THEN

108: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
109: x_msg_data => x_msg_data);
110:
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
114: p_api_name => l_api_name,
115: p_pkg_name => G_PKG_NAME,
116: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 113: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

109: x_msg_data => x_msg_data);
110:
111: EXCEPTION
112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
114: p_api_name => l_api_name,
115: p_pkg_name => G_PKG_NAME,
116: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
117: x_msg_count => x_msg_count,

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

112: WHEN OKC_API.G_EXCEPTION_ERROR THEN
113: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
114: p_api_name => l_api_name,
115: p_pkg_name => G_PKG_NAME,
116: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
117: x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data,
119: p_api_type => G_API_TYPE);
120:

Line 121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

117: x_msg_count => x_msg_count,
118: x_msg_data => x_msg_data,
119: p_api_type => G_API_TYPE);
120:
121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
123: p_api_name => l_api_name,
124: p_pkg_name => G_PKG_NAME,
125: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 122: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

118: x_msg_data => x_msg_data,
119: p_api_type => G_API_TYPE);
120:
121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
123: p_api_name => l_api_name,
124: p_pkg_name => G_PKG_NAME,
125: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
126: x_msg_count => x_msg_count,

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

121: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
122: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
123: p_api_name => l_api_name,
124: p_pkg_name => G_PKG_NAME,
125: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
126: x_msg_count => x_msg_count,
127: x_msg_data => x_msg_data,
128: p_api_type => G_API_TYPE);
129:

Line 131: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

127: x_msg_data => x_msg_data,
128: p_api_type => G_API_TYPE);
129:
130: WHEN OTHERS THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
132: p_api_name => l_api_name,
133: p_pkg_name => G_PKG_NAME,
134: p_exc_name => 'OTHERS',
135: x_msg_count => x_msg_count,

Line 160: x_return_status := OKC_API.G_RET_STS_SUCCESS;

156: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
157:
158: BEGIN
159:
160: x_return_status := OKC_API.G_RET_STS_SUCCESS;
161: -- call START_ACTIVITY to create savepoint, check compatibility
162: -- and initialize message list
163: x_return_status := OKC_API.START_ACTIVITY(
164: p_api_name => l_api_name,

Line 163: x_return_status := OKC_API.START_ACTIVITY(

159:
160: x_return_status := OKC_API.G_RET_STS_SUCCESS;
161: -- call START_ACTIVITY to create savepoint, check compatibility
162: -- and initialize message list
163: x_return_status := OKC_API.START_ACTIVITY(
164: p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_init_msg_list => p_init_msg_list,
167: l_api_version => l_api_version,

Line 173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

169: p_api_type => G_API_TYPE,
170: x_return_status => x_return_status);
171:
172: -- check if activity started successfully
173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_ERROR;
177: END IF;

Line 174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

170: x_return_status => x_return_status);
171:
172: -- check if activity started successfully
173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_ERROR;
177: END IF;
178:

Line 175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

171:
172: -- check if activity started successfully
173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179:

Line 176: RAISE OKC_API.G_EXCEPTION_ERROR;

172: -- check if activity started successfully
173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
176: RAISE OKC_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179:
180: x_amount := OKL_ACCOUNTING_UTIL.cc_round_format_amount(p_amount => TO_NUMBER(get_number(p_amount)),

Line 188: WHEN OKC_API.G_EXCEPTION_ERROR THEN

184: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data);
186:
187: EXCEPTION
188: WHEN OKC_API.G_EXCEPTION_ERROR THEN
189: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
190: p_api_name => l_api_name,
191: p_pkg_name => G_PKG_NAME,
192: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 189: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

185: x_msg_data => x_msg_data);
186:
187: EXCEPTION
188: WHEN OKC_API.G_EXCEPTION_ERROR THEN
189: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
190: p_api_name => l_api_name,
191: p_pkg_name => G_PKG_NAME,
192: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
193: x_msg_count => x_msg_count,

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

188: WHEN OKC_API.G_EXCEPTION_ERROR THEN
189: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
190: p_api_name => l_api_name,
191: p_pkg_name => G_PKG_NAME,
192: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
193: x_msg_count => x_msg_count,
194: x_msg_data => x_msg_data,
195: p_api_type => G_API_TYPE);
196:

Line 197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

193: x_msg_count => x_msg_count,
194: x_msg_data => x_msg_data,
195: p_api_type => G_API_TYPE);
196:
197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
199: p_api_name => l_api_name,
200: p_pkg_name => G_PKG_NAME,
201: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 198: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

194: x_msg_data => x_msg_data,
195: p_api_type => G_API_TYPE);
196:
197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
199: p_api_name => l_api_name,
200: p_pkg_name => G_PKG_NAME,
201: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
202: x_msg_count => x_msg_count,

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

197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
199: p_api_name => l_api_name,
200: p_pkg_name => G_PKG_NAME,
201: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
202: x_msg_count => x_msg_count,
203: x_msg_data => x_msg_data,
204: p_api_type => G_API_TYPE);
205:

Line 207: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

203: x_msg_data => x_msg_data,
204: p_api_type => G_API_TYPE);
205:
206: WHEN OTHERS THEN
207: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
208: p_api_name => l_api_name,
209: p_pkg_name => G_PKG_NAME,
210: p_exc_name => 'OTHERS',
211: x_msg_count => x_msg_count,

Line 236: x_return_status := OKC_API.G_RET_STS_SUCCESS;

232: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
233:
234: BEGIN
235:
236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
237: -- call START_ACTIVITY to create savepoint, check compatibility
238: -- and initialize message list
239: x_return_status := OKC_API.START_ACTIVITY(
240: p_api_name => l_api_name,

Line 239: x_return_status := OKC_API.START_ACTIVITY(

235:
236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
237: -- call START_ACTIVITY to create savepoint, check compatibility
238: -- and initialize message list
239: x_return_status := OKC_API.START_ACTIVITY(
240: p_api_name => l_api_name,
241: p_pkg_name => G_PKG_NAME,
242: p_init_msg_list => p_init_msg_list,
243: l_api_version => l_api_version,

Line 249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

245: p_api_type => G_API_TYPE,
246: x_return_status => x_return_status);
247:
248: -- check if activity started successfully
249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_ERROR;
253: END IF;

Line 250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

246: x_return_status => x_return_status);
247:
248: -- check if activity started successfully
249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_ERROR;
253: END IF;
254:

Line 251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

247:
248: -- check if activity started successfully
249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_ERROR;
253: END IF;
254:
255: x_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(

Line 252: RAISE OKC_API.G_EXCEPTION_ERROR;

248: -- check if activity started successfully
249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
252: RAISE OKC_API.G_EXCEPTION_ERROR;
253: END IF;
254:
255: x_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(
256: p_amount => TO_NUMBER(get_number(p_amount)),

Line 264: WHEN OKC_API.G_EXCEPTION_ERROR THEN

260: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data);
262:
263: EXCEPTION
264: WHEN OKC_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => G_PKG_NAME,
268: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 265: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

261: x_msg_data => x_msg_data);
262:
263: EXCEPTION
264: WHEN OKC_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => G_PKG_NAME,
268: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
269: x_msg_count => x_msg_count,

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

264: WHEN OKC_API.G_EXCEPTION_ERROR THEN
265: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => G_PKG_NAME,
268: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data,
271: p_api_type => G_API_TYPE);
272:

Line 273: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data,
271: p_api_type => G_API_TYPE);
272:
273: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
274: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => G_PKG_NAME,
277: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 274: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

270: x_msg_data => x_msg_data,
271: p_api_type => G_API_TYPE);
272:
273: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
274: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => G_PKG_NAME,
277: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
278: x_msg_count => x_msg_count,

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

273: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
274: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
275: p_api_name => l_api_name,
276: p_pkg_name => G_PKG_NAME,
277: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data,
280: p_api_type => G_API_TYPE);
281:

Line 283: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

279: x_msg_data => x_msg_data,
280: p_api_type => G_API_TYPE);
281:
282: WHEN OTHERS THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
284: p_api_name => l_api_name,
285: p_pkg_name => G_PKG_NAME,
286: p_exc_name => 'OTHERS',
287: x_msg_count => x_msg_count,

Line 312: x_return_status := OKC_API.G_RET_STS_SUCCESS;

308: l_api_version CONSTANT VARCHAR2(30) := p_api_version;
309:
310: BEGIN
311:
312: x_return_status := OKC_API.G_RET_STS_SUCCESS;
313: -- call START_ACTIVITY to create savepoint, check compatibility
314: -- and initialize message list
315: x_return_status := OKC_API.START_ACTIVITY(
316: p_api_name => l_api_name,

Line 315: x_return_status := OKC_API.START_ACTIVITY(

311:
312: x_return_status := OKC_API.G_RET_STS_SUCCESS;
313: -- call START_ACTIVITY to create savepoint, check compatibility
314: -- and initialize message list
315: x_return_status := OKC_API.START_ACTIVITY(
316: p_api_name => l_api_name,
317: p_pkg_name => G_PKG_NAME,
318: p_init_msg_list => p_init_msg_list,
319: l_api_version => l_api_version,

Line 325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

321: p_api_type => G_API_TYPE,
322: x_return_status => x_return_status);
323:
324: -- check if activity started successfully
325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;

Line 326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

322: x_return_status => x_return_status);
323:
324: -- check if activity started successfully
325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:

Line 327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

323:
324: -- check if activity started successfully
325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331:

Line 328: RAISE OKC_API.G_EXCEPTION_ERROR;

324: -- check if activity started successfully
325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
328: RAISE OKC_API.G_EXCEPTION_ERROR;
329: END IF;
330:
331:
332: x_amount := OKL_ACCOUNTING_UTIL.cross_currency_round_amount(

Line 341: WHEN OKC_API.G_EXCEPTION_ERROR THEN

337: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
338: x_msg_data => x_msg_data);
339:
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
343: p_api_name => l_api_name,
344: p_pkg_name => G_PKG_NAME,
345: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 342: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

338: x_msg_data => x_msg_data);
339:
340: EXCEPTION
341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
343: p_api_name => l_api_name,
344: p_pkg_name => G_PKG_NAME,
345: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count => x_msg_count,

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

341: WHEN OKC_API.G_EXCEPTION_ERROR THEN
342: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
343: p_api_name => l_api_name,
344: p_pkg_name => G_PKG_NAME,
345: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count => x_msg_count,
347: x_msg_data => x_msg_data,
348: p_api_type => G_API_TYPE);
349:

Line 350: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

346: x_msg_count => x_msg_count,
347: x_msg_data => x_msg_data,
348: p_api_type => G_API_TYPE);
349:
350: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
351: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 351: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

347: x_msg_data => x_msg_data,
348: p_api_type => G_API_TYPE);
349:
350: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
351: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
355: x_msg_count => x_msg_count,

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

350: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
351: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: p_api_type => G_API_TYPE);
358:

Line 360: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

356: x_msg_data => x_msg_data,
357: p_api_type => G_API_TYPE);
358:
359: WHEN OTHERS THEN
360: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
361: p_api_name => l_api_name,
362: p_pkg_name => G_PKG_NAME,
363: p_exc_name => 'OTHERS',
364: x_msg_count => x_msg_count,