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

Line 129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

125: l_fetched BOOLEAN := FALSE;
126: l_temp VARCHAR2(1);
127:
128:
129: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
130: l_api_name CONSTANT VARCHAR2(30) := 'check_parties';
131: l_api_version CONSTANT NUMBER := 1.0;
132:
133: i NUMBER := 0;

Line 158: WHEN OKC_API.G_EXCEPTION_ERROR THEN

154: x_return_status := 'S';
155: RETURN l_fetched;
156:
157: EXCEPTION
158: WHEN OKC_API.G_EXCEPTION_ERROR THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
160: p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 159: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

155: RETURN l_fetched;
156:
157: EXCEPTION
158: WHEN OKC_API.G_EXCEPTION_ERROR THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
160: p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
163: x_msg_count => x_msg_count,

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

158: WHEN OKC_API.G_EXCEPTION_ERROR THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
160: p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data,
165: p_api_type => G_API_TYPE);
166:

Line 167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data,
165: p_api_type => G_API_TYPE);
166:
167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
169: p_api_name => l_api_name,
170: p_pkg_name => G_PKG_NAME,
171: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 168: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

164: x_msg_data => x_msg_data,
165: p_api_type => G_API_TYPE);
166:
167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
169: p_api_name => l_api_name,
170: p_pkg_name => G_PKG_NAME,
171: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
172: x_msg_count => x_msg_count,

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

167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
168: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
169: p_api_name => l_api_name,
170: p_pkg_name => G_PKG_NAME,
171: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,
174: p_api_type => G_API_TYPE);
175:

Line 177: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

173: x_msg_data => x_msg_data,
174: p_api_type => G_API_TYPE);
175:
176: WHEN OTHERS THEN
177: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
178: p_api_name => l_api_name,
179: p_pkg_name => G_PKG_NAME,
180: p_exc_name => 'OTHERS',
181: x_msg_count => x_msg_count,

Line 208: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

204:
205: l_fetched BOOLEAN := FALSE;
206: l_lse_id NUMBER;
207:
208: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
209: l_api_name CONSTANT VARCHAR2(30) := 'check_parties';
210: l_api_version CONSTANT NUMBER := 1.0;
211:
212: BEGIN

Line 224: WHEN OKC_API.G_EXCEPTION_ERROR THEN

220:
221: RETURN l_lse_id;
222:
223: EXCEPTION
224: WHEN OKC_API.G_EXCEPTION_ERROR THEN
225: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
226: p_api_name => l_api_name,
227: p_pkg_name => G_PKG_NAME,
228: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 225: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

221: RETURN l_lse_id;
222:
223: EXCEPTION
224: WHEN OKC_API.G_EXCEPTION_ERROR THEN
225: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
226: p_api_name => l_api_name,
227: p_pkg_name => G_PKG_NAME,
228: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
229: x_msg_count => x_msg_count,

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

224: WHEN OKC_API.G_EXCEPTION_ERROR THEN
225: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
226: p_api_name => l_api_name,
227: p_pkg_name => G_PKG_NAME,
228: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data,
231: p_api_type => G_API_TYPE);
232:

Line 233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data,
231: p_api_type => G_API_TYPE);
232:
233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
234: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => G_PKG_NAME,
237: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 234: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

230: x_msg_data => x_msg_data,
231: p_api_type => G_API_TYPE);
232:
233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
234: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => G_PKG_NAME,
237: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
238: x_msg_count => x_msg_count,

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

233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
234: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
235: p_api_name => l_api_name,
236: p_pkg_name => G_PKG_NAME,
237: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
238: x_msg_count => x_msg_count,
239: x_msg_data => x_msg_data,
240: p_api_type => G_API_TYPE);
241:

Line 243: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

239: x_msg_data => x_msg_data,
240: p_api_type => G_API_TYPE);
241:
242: WHEN OTHERS THEN
243: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
244: p_api_name => l_api_name,
245: p_pkg_name => G_PKG_NAME,
246: p_exc_name => 'OTHERS',
247: x_msg_count => x_msg_count,

Line 280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

276: l_currency_code VARCHAR2(15);
277: l_org_id VARCHAR2(15);
278: l_end_date DATE;
279:
280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
281: l_api_name CONSTANT VARCHAR2(30) := 'GET_HEADER_DETAILS';
282: l_api_version CONSTANT NUMBER := 1.0;
283:
284: BEGIN

Line 299: WHEN OKC_API.G_EXCEPTION_ERROR THEN

295: x_return_status := 'S';
296:
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:
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 338: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

334: x_msg_data OUT NOCOPY VARCHAR2,
335: p_inv_tbl IN inv_tbl_type) IS
336:
337:
338: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
339: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_INVESTOR';
340: l_api_version CONSTANT NUMBER := 1.0;
341:
342: i NUMBER := 0;

Line 349: x_return_status := OKC_API.G_RET_STS_SUCCESS;

345:
346: BEGIN
347:
348: -- dbms_output.put_line('begin ');
349: x_return_status := OKC_API.G_RET_STS_SUCCESS;
350: -- call START_ACTIVITY to create savepoint, check compatibility
351: -- and initialize message list
352: x_return_status := OKC_API.START_ACTIVITY(
353: p_api_name => l_api_name,

Line 352: x_return_status := OKC_API.START_ACTIVITY(

348: -- dbms_output.put_line('begin ');
349: x_return_status := OKC_API.G_RET_STS_SUCCESS;
350: -- call START_ACTIVITY to create savepoint, check compatibility
351: -- and initialize message list
352: x_return_status := OKC_API.START_ACTIVITY(
353: p_api_name => l_api_name,
354: p_pkg_name => G_PKG_NAME,
355: p_init_msg_list => p_init_msg_list,
356: l_api_version => l_api_version,

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

358: p_api_type => G_API_TYPE,
359: x_return_status => x_return_status);
360:
361: -- check if activity started successfully
362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_ERROR;
366: END IF;

Line 363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

359: x_return_status => x_return_status);
360:
361: -- check if activity started successfully
362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_ERROR;
366: END IF;
367:

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

360:
361: -- check if activity started successfully
362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_ERROR;
366: END IF;
367:
368:

Line 365: RAISE OKC_API.G_EXCEPTION_ERROR;

361: -- check if activity started successfully
362: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
363: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
364: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
365: RAISE OKC_API.G_EXCEPTION_ERROR;
366: END IF;
367:
368:
369: LOOP

Line 376: p_inv_tbl(i).cpl_object1_id1 = OKC_API.G_MISS_CHAR) THEN

372: --dbms_output.put_line('begin 1');
373:
374: IF(p_inv_tbl(i).cpl_object1_id1 IS NULL OR
375: p_inv_tbl(i).cpl_object1_id1 = '' OR
376: p_inv_tbl(i).cpl_object1_id1 = OKC_API.G_MISS_CHAR) THEN
377:
378: x_return_status := OKC_API.g_ret_sts_error;
379: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
380: p_region_code => G_AK_REGION_NAME,

Line 378: x_return_status := OKC_API.g_ret_sts_error;

374: IF(p_inv_tbl(i).cpl_object1_id1 IS NULL OR
375: p_inv_tbl(i).cpl_object1_id1 = '' OR
376: p_inv_tbl(i).cpl_object1_id1 = OKC_API.G_MISS_CHAR) THEN
377:
378: x_return_status := OKC_API.g_ret_sts_error;
379: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
380: p_region_code => G_AK_REGION_NAME,
381: p_attribute_code => 'OKL_LA_SEC_INVESTOR');
382: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 382: OKC_API.SET_MESSAGE( p_app_name => g_app_name

378: x_return_status := OKC_API.g_ret_sts_error;
379: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
380: p_region_code => G_AK_REGION_NAME,
381: p_attribute_code => 'OKL_LA_SEC_INVESTOR');
382: OKC_API.SET_MESSAGE( p_app_name => g_app_name
383: , p_msg_name => 'OKL_REQUIRED_VALUE'
384: , p_token1 => 'COL_NAME'
385: , p_token1_value => l_ak_prompt
386: );

Line 388: RAISE OKC_API.G_EXCEPTION_ERROR;

384: , p_token1 => 'COL_NAME'
385: , p_token1_value => l_ak_prompt
386: );
387:
388: RAISE OKC_API.G_EXCEPTION_ERROR;
389: END IF;
390:
391: --dbms_output.put_line('begin 2');
392:

Line 395: p_inv_tbl(i).kle_amount = OKC_API.G_MISS_NUM) THEN

391: --dbms_output.put_line('begin 2');
392:
393: IF(p_inv_tbl(i).kle_amount IS NULL OR
394: p_inv_tbl(i).kle_amount = '' OR
395: p_inv_tbl(i).kle_amount = OKC_API.G_MISS_NUM) THEN
396:
397: x_return_status := OKC_API.g_ret_sts_error;
398: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
399: p_region_code => G_AK_REGION_NAME,

Line 397: x_return_status := OKC_API.g_ret_sts_error;

393: IF(p_inv_tbl(i).kle_amount IS NULL OR
394: p_inv_tbl(i).kle_amount = '' OR
395: p_inv_tbl(i).kle_amount = OKC_API.G_MISS_NUM) THEN
396:
397: x_return_status := OKC_API.g_ret_sts_error;
398: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
399: p_region_code => G_AK_REGION_NAME,
400: p_attribute_code => 'OKL_LA_SEC_AMT_STAKE');
401: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 401: OKC_API.SET_MESSAGE( p_app_name => g_app_name

397: x_return_status := OKC_API.g_ret_sts_error;
398: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
399: p_region_code => G_AK_REGION_NAME,
400: p_attribute_code => 'OKL_LA_SEC_AMT_STAKE');
401: OKC_API.SET_MESSAGE( p_app_name => g_app_name
402: , p_msg_name => 'OKL_REQUIRED_VALUE'
403: , p_token1 => 'COL_NAME'
404: , p_token1_value => l_ak_prompt
405: );

Line 406: RAISE OKC_API.G_EXCEPTION_ERROR;

402: , p_msg_name => 'OKL_REQUIRED_VALUE'
403: , p_token1 => 'COL_NAME'
404: , p_token1_value => l_ak_prompt
405: );
406: RAISE OKC_API.G_EXCEPTION_ERROR;
407: END IF;
408:
409: --dbms_output.put_line('begin 3');
410: IF(p_inv_tbl(i).start_date IS NULL OR

Line 412: p_inv_tbl(i).start_date = OKC_API.G_MISS_DATE) THEN

408:
409: --dbms_output.put_line('begin 3');
410: IF(p_inv_tbl(i).start_date IS NULL OR
411: p_inv_tbl(i).start_date = '' OR
412: p_inv_tbl(i).start_date = OKC_API.G_MISS_DATE) THEN
413:
414: x_return_status := OKC_API.g_ret_sts_error;
415: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
416: p_region_code => G_AK_REGION_NAME,

Line 414: x_return_status := OKC_API.g_ret_sts_error;

410: IF(p_inv_tbl(i).start_date IS NULL OR
411: p_inv_tbl(i).start_date = '' OR
412: p_inv_tbl(i).start_date = OKC_API.G_MISS_DATE) THEN
413:
414: x_return_status := OKC_API.g_ret_sts_error;
415: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
416: p_region_code => G_AK_REGION_NAME,
417: p_attribute_code => 'OKL_LA_SEC_INV_DATE');
418:

Line 419: OKC_API.SET_MESSAGE( p_app_name => g_app_name

415: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
416: p_region_code => G_AK_REGION_NAME,
417: p_attribute_code => 'OKL_LA_SEC_INV_DATE');
418:
419: OKC_API.SET_MESSAGE( p_app_name => g_app_name
420: , p_msg_name => 'OKL_REQUIRED_VALUE'
421: , p_token1 => 'COL_NAME'
422: , p_token1_value => l_ak_prompt
423: );

Line 424: RAISE OKC_API.G_EXCEPTION_ERROR;

420: , p_msg_name => 'OKL_REQUIRED_VALUE'
421: , p_token1 => 'COL_NAME'
422: , p_token1_value => l_ak_prompt
423: );
424: RAISE OKC_API.G_EXCEPTION_ERROR;
425: END IF;
426:
427: IF(p_inv_tbl(i).PAY_INVESTOR_FREQUENCY IS NULL OR
428: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = '' OR

Line 429: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = OKC_API.G_MISS_CHAR) THEN

425: END IF;
426:
427: IF(p_inv_tbl(i).PAY_INVESTOR_FREQUENCY IS NULL OR
428: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = '' OR
429: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = OKC_API.G_MISS_CHAR) THEN
430:
431: x_return_status := OKC_API.g_ret_sts_error;
432: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
433: p_region_code => G_AK_REGION_NAME,

Line 431: x_return_status := OKC_API.g_ret_sts_error;

427: IF(p_inv_tbl(i).PAY_INVESTOR_FREQUENCY IS NULL OR
428: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = '' OR
429: p_inv_tbl(i).PAY_INVESTOR_FREQUENCY = OKC_API.G_MISS_CHAR) THEN
430:
431: x_return_status := OKC_API.g_ret_sts_error;
432: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
433: p_region_code => G_AK_REGION_NAME,
434: p_attribute_code => 'OKL_LA_SEC_PAY_FREQ');
435: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 435: OKC_API.SET_MESSAGE( p_app_name => g_app_name

431: x_return_status := OKC_API.g_ret_sts_error;
432: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
433: p_region_code => G_AK_REGION_NAME,
434: p_attribute_code => 'OKL_LA_SEC_PAY_FREQ');
435: OKC_API.SET_MESSAGE( p_app_name => g_app_name
436: , p_msg_name => 'OKL_REQUIRED_VALUE'
437: , p_token1 => 'COL_NAME'
438: , p_token1_value => l_ak_prompt
439: );

Line 440: RAISE OKC_API.G_EXCEPTION_ERROR;

436: , p_msg_name => 'OKL_REQUIRED_VALUE'
437: , p_token1 => 'COL_NAME'
438: , p_token1_value => l_ak_prompt
439: );
440: RAISE OKC_API.G_EXCEPTION_ERROR;
441: END IF;
442:
443: IF(p_inv_tbl(i).date_pay_investor_start IS NULL OR
444: p_inv_tbl(i).date_pay_investor_start = '' OR

Line 445: p_inv_tbl(i).date_pay_investor_start = OKC_API.G_MISS_DATE) THEN

441: END IF;
442:
443: IF(p_inv_tbl(i).date_pay_investor_start IS NULL OR
444: p_inv_tbl(i).date_pay_investor_start = '' OR
445: p_inv_tbl(i).date_pay_investor_start = OKC_API.G_MISS_DATE) THEN
446:
447: x_return_status := OKC_API.g_ret_sts_error;
448: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
449: p_region_code => G_AK_REGION_NAME,

Line 447: x_return_status := OKC_API.g_ret_sts_error;

443: IF(p_inv_tbl(i).date_pay_investor_start IS NULL OR
444: p_inv_tbl(i).date_pay_investor_start = '' OR
445: p_inv_tbl(i).date_pay_investor_start = OKC_API.G_MISS_DATE) THEN
446:
447: x_return_status := OKC_API.g_ret_sts_error;
448: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
449: p_region_code => G_AK_REGION_NAME,
450: p_attribute_code => 'OKL_LA_SEC_PAY_START');
451: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 451: OKC_API.SET_MESSAGE( p_app_name => g_app_name

447: x_return_status := OKC_API.g_ret_sts_error;
448: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
449: p_region_code => G_AK_REGION_NAME,
450: p_attribute_code => 'OKL_LA_SEC_PAY_START');
451: OKC_API.SET_MESSAGE( p_app_name => g_app_name
452: , p_msg_name => 'OKL_REQUIRED_VALUE'
453: , p_token1 => 'COL_NAME'
454: , p_token1_value => l_ak_prompt
455: );

Line 456: RAISE OKC_API.G_EXCEPTION_ERROR;

452: , p_msg_name => 'OKL_REQUIRED_VALUE'
453: , p_token1 => 'COL_NAME'
454: , p_token1_value => l_ak_prompt
455: );
456: RAISE OKC_API.G_EXCEPTION_ERROR;
457: -- mvasudev, 02/06/2004
458: ELSIF p_inv_tbl(i).date_pay_investor_start < p_inv_tbl(i).start_date
459: THEN
460: x_return_status := OKC_API.g_ret_sts_error;

Line 460: x_return_status := OKC_API.g_ret_sts_error;

456: RAISE OKC_API.G_EXCEPTION_ERROR;
457: -- mvasudev, 02/06/2004
458: ELSIF p_inv_tbl(i).date_pay_investor_start < p_inv_tbl(i).start_date
459: THEN
460: x_return_status := OKC_API.g_ret_sts_error;
461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME
462: ,p_msg_name => 'OKL_SEC_INVALID_PAYOUT_DATE');
463: RAISE OKC_API.G_EXCEPTION_ERROR;
464: END IF;

Line 461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME

457: -- mvasudev, 02/06/2004
458: ELSIF p_inv_tbl(i).date_pay_investor_start < p_inv_tbl(i).start_date
459: THEN
460: x_return_status := OKC_API.g_ret_sts_error;
461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME
462: ,p_msg_name => 'OKL_SEC_INVALID_PAYOUT_DATE');
463: RAISE OKC_API.G_EXCEPTION_ERROR;
464: END IF;
465:

Line 463: RAISE OKC_API.G_EXCEPTION_ERROR;

459: THEN
460: x_return_status := OKC_API.g_ret_sts_error;
461: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME
462: ,p_msg_name => 'OKL_SEC_INVALID_PAYOUT_DATE');
463: RAISE OKC_API.G_EXCEPTION_ERROR;
464: END IF;
465:
466: IF(p_inv_tbl(i).PAY_INVESTOR_EVENT IS NULL OR
467: p_inv_tbl(i).PAY_INVESTOR_EVENT = '' OR

Line 468: p_inv_tbl(i).PAY_INVESTOR_EVENT = OKC_API.G_MISS_CHAR) THEN

464: END IF;
465:
466: IF(p_inv_tbl(i).PAY_INVESTOR_EVENT IS NULL OR
467: p_inv_tbl(i).PAY_INVESTOR_EVENT = '' OR
468: p_inv_tbl(i).PAY_INVESTOR_EVENT = OKC_API.G_MISS_CHAR) THEN
469:
470: x_return_status := OKC_API.g_ret_sts_error;
471: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
472: p_region_code => G_AK_REGION_NAME,

Line 470: x_return_status := OKC_API.g_ret_sts_error;

466: IF(p_inv_tbl(i).PAY_INVESTOR_EVENT IS NULL OR
467: p_inv_tbl(i).PAY_INVESTOR_EVENT = '' OR
468: p_inv_tbl(i).PAY_INVESTOR_EVENT = OKC_API.G_MISS_CHAR) THEN
469:
470: x_return_status := OKC_API.g_ret_sts_error;
471: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
472: p_region_code => G_AK_REGION_NAME,
473: p_attribute_code => 'OKL_LA_SEC_PAY_EVENT');
474: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 474: OKC_API.SET_MESSAGE( p_app_name => g_app_name

470: x_return_status := OKC_API.g_ret_sts_error;
471: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
472: p_region_code => G_AK_REGION_NAME,
473: p_attribute_code => 'OKL_LA_SEC_PAY_EVENT');
474: OKC_API.SET_MESSAGE( p_app_name => g_app_name
475: , p_msg_name => 'OKL_REQUIRED_VALUE'
476: , p_token1 => 'COL_NAME'
477: , p_token1_value => l_ak_prompt
478: );

Line 479: RAISE OKC_API.G_EXCEPTION_ERROR;

475: , p_msg_name => 'OKL_REQUIRED_VALUE'
476: , p_token1 => 'COL_NAME'
477: , p_token1_value => l_ak_prompt
478: );
479: RAISE OKC_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482:
483: IF(p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS IS NULL OR

Line 485: p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS = OKC_API.G_MISS_NUM) THEN

481:
482:
483: IF(p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS IS NULL OR
484: p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS = '' OR
485: p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS = OKC_API.G_MISS_NUM) THEN
486:
487: x_return_status := OKC_API.g_ret_sts_error;
488: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
489: p_region_code => G_AK_REGION_NAME,

Line 487: x_return_status := OKC_API.g_ret_sts_error;

483: IF(p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS IS NULL OR
484: p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS = '' OR
485: p_inv_tbl(i).PAY_INVESTOR_REMITTANCE_DAYS = OKC_API.G_MISS_NUM) THEN
486:
487: x_return_status := OKC_API.g_ret_sts_error;
488: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
489: p_region_code => G_AK_REGION_NAME,
490: p_attribute_code => 'OKL_LA_SEC_REMIT');
491: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 491: OKC_API.SET_MESSAGE( p_app_name => g_app_name

487: x_return_status := OKC_API.g_ret_sts_error;
488: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
489: p_region_code => G_AK_REGION_NAME,
490: p_attribute_code => 'OKL_LA_SEC_REMIT');
491: OKC_API.SET_MESSAGE( p_app_name => g_app_name
492: , p_msg_name => 'OKL_REQUIRED_VALUE'
493: , p_token1 => 'COL_NAME'
494: , p_token1_value => l_ak_prompt
495: );

Line 496: RAISE OKC_API.G_EXCEPTION_ERROR;

492: , p_msg_name => 'OKL_REQUIRED_VALUE'
493: , p_token1 => 'COL_NAME'
494: , p_token1_value => l_ak_prompt
495: );
496: RAISE OKC_API.G_EXCEPTION_ERROR;
497: END IF;
498:
499: IF(p_inv_tbl(i).BILL_TO_SITE_USE_ID IS NULL OR
500: p_inv_tbl(i).BILL_TO_SITE_USE_ID = '' OR

Line 501: p_inv_tbl(i).BILL_TO_SITE_USE_ID = OKC_API.G_MISS_NUM) THEN

497: END IF;
498:
499: IF(p_inv_tbl(i).BILL_TO_SITE_USE_ID IS NULL OR
500: p_inv_tbl(i).BILL_TO_SITE_USE_ID = '' OR
501: p_inv_tbl(i).BILL_TO_SITE_USE_ID = OKC_API.G_MISS_NUM) THEN
502:
503: x_return_status := OKC_API.g_ret_sts_error;
504: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
505: p_region_code => G_AK_REGION_NAME,

Line 503: x_return_status := OKC_API.g_ret_sts_error;

499: IF(p_inv_tbl(i).BILL_TO_SITE_USE_ID IS NULL OR
500: p_inv_tbl(i).BILL_TO_SITE_USE_ID = '' OR
501: p_inv_tbl(i).BILL_TO_SITE_USE_ID = OKC_API.G_MISS_NUM) THEN
502:
503: x_return_status := OKC_API.g_ret_sts_error;
504: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
505: p_region_code => G_AK_REGION_NAME,
506: p_attribute_code => 'OKL_LA_SEC_INV_BILL_TO');
507:

Line 508: OKC_API.SET_MESSAGE( p_app_name => g_app_name

504: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
505: p_region_code => G_AK_REGION_NAME,
506: p_attribute_code => 'OKL_LA_SEC_INV_BILL_TO');
507:
508: OKC_API.SET_MESSAGE( p_app_name => g_app_name
509: , p_msg_name => 'OKL_REQUIRED_VALUE'
510: , p_token1 => 'COL_NAME'
511: , p_token1_value => l_ak_prompt
512: );

Line 513: RAISE OKC_API.G_EXCEPTION_ERROR;

509: , p_msg_name => 'OKL_REQUIRED_VALUE'
510: , p_token1 => 'COL_NAME'
511: , p_token1_value => l_ak_prompt
512: );
513: RAISE OKC_API.G_EXCEPTION_ERROR;
514: END IF;
515:
516: IF(p_inv_tbl(i).CUST_ACCT_ID IS NULL OR
517: p_inv_tbl(i).CUST_ACCT_ID = '' OR

Line 518: p_inv_tbl(i).CUST_ACCT_ID = OKC_API.G_MISS_NUM) THEN

514: END IF;
515:
516: IF(p_inv_tbl(i).CUST_ACCT_ID IS NULL OR
517: p_inv_tbl(i).CUST_ACCT_ID = '' OR
518: p_inv_tbl(i).CUST_ACCT_ID = OKC_API.G_MISS_NUM) THEN
519:
520: x_return_status := OKC_API.g_ret_sts_error;
521: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
522: p_region_code => G_AK_REGION_NAME,

Line 520: x_return_status := OKC_API.g_ret_sts_error;

516: IF(p_inv_tbl(i).CUST_ACCT_ID IS NULL OR
517: p_inv_tbl(i).CUST_ACCT_ID = '' OR
518: p_inv_tbl(i).CUST_ACCT_ID = OKC_API.G_MISS_NUM) THEN
519:
520: x_return_status := OKC_API.g_ret_sts_error;
521: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
522: p_region_code => G_AK_REGION_NAME,
523: p_attribute_code => 'OKL_LA_SEC_INV_CUST_ACCOUNT');
524:

Line 525: OKC_API.SET_MESSAGE( p_app_name => g_app_name

521: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
522: p_region_code => G_AK_REGION_NAME,
523: p_attribute_code => 'OKL_LA_SEC_INV_CUST_ACCOUNT');
524:
525: OKC_API.SET_MESSAGE( p_app_name => g_app_name
526: , p_msg_name => 'OKL_REQUIRED_VALUE'
527: , p_token1 => 'COL_NAME'
528: , p_token1_value => l_ak_prompt
529: );

Line 530: RAISE OKC_API.G_EXCEPTION_ERROR;

526: , p_msg_name => 'OKL_REQUIRED_VALUE'
527: , p_token1 => 'COL_NAME'
528: , p_token1_value => l_ak_prompt
529: );
530: RAISE OKC_API.G_EXCEPTION_ERROR;
531: END IF;
532:
533: EXIT WHEN (i >= p_inv_tbl.last);
534: END LOOP;

Line 542: WHEN OKC_API.G_EXCEPTION_ERROR THEN

538: x_msg_data => x_msg_data);
539:
540:
541: EXCEPTION
542: WHEN OKC_API.G_EXCEPTION_ERROR THEN
543: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
544: p_api_name => l_api_name,
545: p_pkg_name => G_PKG_NAME,
546: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 543: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

539:
540:
541: EXCEPTION
542: WHEN OKC_API.G_EXCEPTION_ERROR THEN
543: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
544: p_api_name => l_api_name,
545: p_pkg_name => G_PKG_NAME,
546: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
547: x_msg_count => x_msg_count,

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

542: WHEN OKC_API.G_EXCEPTION_ERROR THEN
543: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
544: p_api_name => l_api_name,
545: p_pkg_name => G_PKG_NAME,
546: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
547: x_msg_count => x_msg_count,
548: x_msg_data => x_msg_data,
549: p_api_type => G_API_TYPE);
550:

Line 551: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

547: x_msg_count => x_msg_count,
548: x_msg_data => x_msg_data,
549: p_api_type => G_API_TYPE);
550:
551: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
553: p_api_name => l_api_name,
554: p_pkg_name => G_PKG_NAME,
555: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 552: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

548: x_msg_data => x_msg_data,
549: p_api_type => G_API_TYPE);
550:
551: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
553: p_api_name => l_api_name,
554: p_pkg_name => G_PKG_NAME,
555: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
556: x_msg_count => x_msg_count,

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

551: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
552: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
553: p_api_name => l_api_name,
554: p_pkg_name => G_PKG_NAME,
555: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
556: x_msg_count => x_msg_count,
557: x_msg_data => x_msg_data,
558: p_api_type => G_API_TYPE);
559:

Line 561: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

557: x_msg_data => x_msg_data,
558: p_api_type => G_API_TYPE);
559:
560: WHEN OTHERS THEN
561: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
562: p_api_name => l_api_name,
563: p_pkg_name => G_PKG_NAME,
564: p_exc_name => 'OTHERS',
565: x_msg_count => x_msg_count,

Line 594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

590:
591:
592: l_inv_rec inv_rec_type;
593:
594: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
595: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_PARTY';
596: l_api_version CONSTANT NUMBER := 1.0;
597:
598: i NUMBER := 0;

Line 610: x_return_status := OKC_API.G_RET_STS_SUCCESS;

606:
607: BEGIN
608:
609: --dbms_output.put_line('begin .......... ..');
610: x_return_status := OKC_API.G_RET_STS_SUCCESS;
611: -- call START_ACTIVITY to create savepoint, check compatibility
612: -- and initialize message list
613: x_return_status := OKC_API.START_ACTIVITY(
614: p_api_name => l_api_name,

Line 613: x_return_status := OKC_API.START_ACTIVITY(

609: --dbms_output.put_line('begin .......... ..');
610: x_return_status := OKC_API.G_RET_STS_SUCCESS;
611: -- call START_ACTIVITY to create savepoint, check compatibility
612: -- and initialize message list
613: x_return_status := OKC_API.START_ACTIVITY(
614: p_api_name => l_api_name,
615: p_pkg_name => G_PKG_NAME,
616: p_init_msg_list => p_init_msg_list,
617: l_api_version => l_api_version,

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

619: p_api_type => G_API_TYPE,
620: x_return_status => x_return_status);
621:
622: -- check if activity started successfully
623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;

Line 624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

620: x_return_status => x_return_status);
621:
622: -- check if activity started successfully
623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:

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

621:
622: -- check if activity started successfully
623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: --delete from okl_sec_temp;

Line 626: RAISE OKC_API.G_EXCEPTION_ERROR;

622: -- check if activity started successfully
623: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
624: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
625: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
626: RAISE OKC_API.G_EXCEPTION_ERROR;
627: END IF;
628:
629: --delete from okl_sec_temp;
630:

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

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

Line 640: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 642: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,
652: p_lty_code => G_TOPLINE_LTY_CODE);
653:
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;

Line 655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

651: x_msg_data => x_msg_data,
652: p_lty_code => G_TOPLINE_LTY_CODE);
653:
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659:

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

652: p_lty_code => G_TOPLINE_LTY_CODE);
653:
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: IF(p_inv_tbl.COUNT > 0) THEN

Line 657: RAISE OKC_API.G_EXCEPTION_ERROR;

653:
654: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: IF(p_inv_tbl.COUNT > 0) THEN
661:

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

669: x_currency_code => lx_currency_code,
670: x_org_id => lx_org_id,
671: x_end_date => lx_end_date);
672:
673: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
676: RAISE OKC_API.G_EXCEPTION_ERROR;
677: END IF;

Line 674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

670: x_org_id => lx_org_id,
671: x_end_date => lx_end_date);
672:
673: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
676: RAISE OKC_API.G_EXCEPTION_ERROR;
677: END IF;
678:

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

671: x_end_date => lx_end_date);
672:
673: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
676: RAISE OKC_API.G_EXCEPTION_ERROR;
677: END IF;
678:
679: --dbms_output.put_line('lx_currency_code '||lx_currency_code);

Line 676: RAISE OKC_API.G_EXCEPTION_ERROR;

672:
673: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
676: RAISE OKC_API.G_EXCEPTION_ERROR;
677: END IF;
678:
679: --dbms_output.put_line('lx_currency_code '||lx_currency_code);
680: --dbms_output.put_line('lx_end_date '||lx_end_date);

Line 715: x_return_status := OKC_API.g_ret_sts_error;

711:
712: --dbms_output.put_line('l_count '||l_count);
713:
714: IF(l_exists) THEN
715: x_return_status := OKC_API.g_ret_sts_error;
716: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
717: p_region_code => G_AK_REGION_NAME,
718: p_attribute_code => 'OKL_LA_SEC_INVESTOR');
719: OKC_API.SET_MESSAGE( p_app_name => g_app_name

Line 719: OKC_API.SET_MESSAGE( p_app_name => g_app_name

715: x_return_status := OKC_API.g_ret_sts_error;
716: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
717: p_region_code => G_AK_REGION_NAME,
718: p_attribute_code => 'OKL_LA_SEC_INVESTOR');
719: OKC_API.SET_MESSAGE( p_app_name => g_app_name
720: , p_msg_name => 'OKL_DUP_PARTY'
721: , p_token1 => 'COL_NAME'
722: , p_token1_value => l_ak_prompt
723: );

Line 724: RAISE OKC_API.G_EXCEPTION_ERROR;

720: , p_msg_name => 'OKL_DUP_PARTY'
721: , p_token1 => 'COL_NAME'
722: , p_token1_value => l_ak_prompt
723: );
724: RAISE OKC_API.G_EXCEPTION_ERROR;
725: END IF;
726:
727:
728: l_clev_rec.dnz_chr_id := l_cplv_rec.dnz_chr_id;

Line 811: WHEN OKC_API.G_EXCEPTION_ERROR THEN

807: x_msg_data => x_msg_data);
808:
809:
810: EXCEPTION
811: WHEN OKC_API.G_EXCEPTION_ERROR THEN
812: -- insert into okl_sec_temp values (751, 'here ');
813: --COMMIT;
814: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
815: p_api_name => l_api_name,

Line 814: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

810: EXCEPTION
811: WHEN OKC_API.G_EXCEPTION_ERROR THEN
812: -- insert into okl_sec_temp values (751, 'here ');
813: --COMMIT;
814: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
815: p_api_name => l_api_name,
816: p_pkg_name => G_PKG_NAME,
817: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
818: x_msg_count => x_msg_count,

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

813: --COMMIT;
814: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
815: p_api_name => l_api_name,
816: p_pkg_name => G_PKG_NAME,
817: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
818: x_msg_count => x_msg_count,
819: x_msg_data => x_msg_data,
820: p_api_type => G_API_TYPE);
821:

Line 822: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

818: x_msg_count => x_msg_count,
819: x_msg_data => x_msg_data,
820: p_api_type => G_API_TYPE);
821:
822: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
823: -- COMMIT;
824: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
825: p_api_name => l_api_name,
826: p_pkg_name => G_PKG_NAME,

Line 824: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

820: p_api_type => G_API_TYPE);
821:
822: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
823: -- COMMIT;
824: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
825: p_api_name => l_api_name,
826: p_pkg_name => G_PKG_NAME,
827: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
828: x_msg_count => x_msg_count,

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

823: -- COMMIT;
824: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
825: p_api_name => l_api_name,
826: p_pkg_name => G_PKG_NAME,
827: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
828: x_msg_count => x_msg_count,
829: x_msg_data => x_msg_data,
830: p_api_type => G_API_TYPE);
831:

Line 834: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

830: p_api_type => G_API_TYPE);
831:
832: WHEN OTHERS THEN
833: -- COMMIT;
834: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
835: p_api_name => l_api_name,
836: p_pkg_name => G_PKG_NAME,
837: p_exc_name => 'OTHERS',
838: x_msg_count => x_msg_count,

Line 878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

874: l_pol_id NUMBER;
875:
876: l_inv_rec inv_rec_type;
877:
878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
879: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_PARTY';
880: l_api_version CONSTANT NUMBER := 1.0;
881:
882: i NUMBER := 0;

Line 896: x_return_status := OKC_API.G_RET_STS_SUCCESS;

892:
893: BEGIN
894:
895:
896: x_return_status := OKC_API.G_RET_STS_SUCCESS;
897: -- call START_ACTIVITY to create savepoint, check compatibility
898: -- and initialize message list
899: x_return_status := OKC_API.START_ACTIVITY(
900: p_api_name => l_api_name,

Line 899: x_return_status := OKC_API.START_ACTIVITY(

895:
896: x_return_status := OKC_API.G_RET_STS_SUCCESS;
897: -- call START_ACTIVITY to create savepoint, check compatibility
898: -- and initialize message list
899: x_return_status := OKC_API.START_ACTIVITY(
900: p_api_name => l_api_name,
901: p_pkg_name => G_PKG_NAME,
902: p_init_msg_list => p_init_msg_list,
903: l_api_version => l_api_version,

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

905: p_api_type => G_API_TYPE,
906: x_return_status => x_return_status);
907:
908: -- check if activity started successfully
909: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;

Line 910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

906: x_return_status => x_return_status);
907:
908: -- check if activity started successfully
909: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:

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

907:
908: -- check if activity started successfully
909: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: validate_investor(

Line 912: RAISE OKC_API.G_EXCEPTION_ERROR;

908: -- check if activity started successfully
909: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
911: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
912: RAISE OKC_API.G_EXCEPTION_ERROR;
913: END IF;
914:
915: validate_investor(
916: p_api_version => p_api_version,

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

919: x_msg_count => x_msg_count,
920: x_msg_data => x_msg_data,
921: p_inv_tbl => p_inv_tbl);
922:
923: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
926: RAISE OKC_API.G_EXCEPTION_ERROR;
927: END IF;

Line 924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

920: x_msg_data => x_msg_data,
921: p_inv_tbl => p_inv_tbl);
922:
923: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
926: RAISE OKC_API.G_EXCEPTION_ERROR;
927: END IF;
928:

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

921: p_inv_tbl => p_inv_tbl);
922:
923: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
926: RAISE OKC_API.G_EXCEPTION_ERROR;
927: END IF;
928:
929: -- insert into okl_sec_temp values ('u-1 ',0, lx_currency_code, lx_org_id, '');

Line 926: RAISE OKC_API.G_EXCEPTION_ERROR;

922:
923: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
926: RAISE OKC_API.G_EXCEPTION_ERROR;
927: END IF;
928:
929: -- insert into okl_sec_temp values ('u-1 ',0, lx_currency_code, lx_org_id, '');
930:

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

940: x_end_date => lx_end_date);
941:
942: -- insert into okl_sec_temp values ('u-2 ',0, lx_currency_code, lx_org_id, '');
943:
944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;

Line 945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

941:
942: -- insert into okl_sec_temp values ('u-2 ',0, lx_currency_code, lx_org_id, '');
943:
944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949:

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

942: -- insert into okl_sec_temp values ('u-2 ',0, lx_currency_code, lx_org_id, '');
943:
944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949:
950: -- insert into okl_sec_temp values ('u-3 ',0, lx_currency_code, lx_org_id, to_char(l_klev_rec.AMOUNT));

Line 947: RAISE OKC_API.G_EXCEPTION_ERROR;

943:
944: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949:
950: -- insert into okl_sec_temp values ('u-3 ',0, lx_currency_code, lx_org_id, to_char(l_klev_rec.AMOUNT));
951: LOOP

Line 1049: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1045: x_msg_data => x_msg_data);
1046:
1047:
1048: EXCEPTION
1049: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1050: -- commit;
1051: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1052: p_api_name => l_api_name,
1053: p_pkg_name => G_PKG_NAME,

Line 1051: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1047:
1048: EXCEPTION
1049: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1050: -- commit;
1051: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1052: p_api_name => l_api_name,
1053: p_pkg_name => G_PKG_NAME,
1054: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1055: x_msg_count => x_msg_count,

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

1050: -- commit;
1051: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1052: p_api_name => l_api_name,
1053: p_pkg_name => G_PKG_NAME,
1054: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1055: x_msg_count => x_msg_count,
1056: x_msg_data => x_msg_data,
1057: p_api_type => G_API_TYPE);
1058:

Line 1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1055: x_msg_count => x_msg_count,
1056: x_msg_data => x_msg_data,
1057: p_api_type => G_API_TYPE);
1058:
1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1060: -- commit;
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1062: p_api_name => l_api_name,
1063: p_pkg_name => G_PKG_NAME,

Line 1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1057: p_api_type => G_API_TYPE);
1058:
1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1060: -- commit;
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1062: p_api_name => l_api_name,
1063: p_pkg_name => G_PKG_NAME,
1064: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1065: x_msg_count => x_msg_count,

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

1060: -- commit;
1061: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1062: p_api_name => l_api_name,
1063: p_pkg_name => G_PKG_NAME,
1064: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1065: x_msg_count => x_msg_count,
1066: x_msg_data => x_msg_data,
1067: p_api_type => G_API_TYPE);
1068:

Line 1071: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1067: p_api_type => G_API_TYPE);
1068:
1069: WHEN OTHERS THEN
1070: -- commit;
1071: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1072: p_api_name => l_api_name,
1073: p_pkg_name => G_PKG_NAME,
1074: p_exc_name => 'OTHERS',
1075: x_msg_count => x_msg_count,

Line 1094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1090:
1091: l_clev_rec clev_rec_type;
1092: l_klev_rec klev_rec_type;
1093:
1094: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1095: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_PARTY';
1096: l_api_version CONSTANT NUMBER := 1.0;
1097:
1098: i NUMBER := 0;

Line 1128: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1124: -- gboomina Bug 6814331 - End
1125:
1126: BEGIN
1127:
1128: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1129: -- call START_ACTIVITY to create savepoint, check compatibility
1130: -- and initialize message list
1131: x_return_status := OKC_API.START_ACTIVITY(
1132: p_api_name => l_api_name,

Line 1131: x_return_status := OKC_API.START_ACTIVITY(

1127:
1128: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1129: -- call START_ACTIVITY to create savepoint, check compatibility
1130: -- and initialize message list
1131: x_return_status := OKC_API.START_ACTIVITY(
1132: p_api_name => l_api_name,
1133: p_pkg_name => G_PKG_NAME,
1134: p_init_msg_list => p_init_msg_list,
1135: l_api_version => l_api_version,

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

1137: p_api_type => G_API_TYPE,
1138: x_return_status => x_return_status);
1139:
1140: -- check if activity started successfully
1141: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_ERROR;
1145: END IF;

Line 1142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1138: x_return_status => x_return_status);
1139:
1140: -- check if activity started successfully
1141: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:

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

1139:
1140: -- check if activity started successfully
1141: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: LOOP

Line 1144: RAISE OKC_API.G_EXCEPTION_ERROR;

1140: -- check if activity started successfully
1141: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1144: RAISE OKC_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: LOOP
1148: i := i + 1;

Line 1200: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1196: x_msg_data => x_msg_data);
1197:
1198:
1199: EXCEPTION
1200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1202: p_api_name => l_api_name,
1203: p_pkg_name => G_PKG_NAME,
1204: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1197:
1198:
1199: EXCEPTION
1200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1202: p_api_name => l_api_name,
1203: p_pkg_name => G_PKG_NAME,
1204: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1205: x_msg_count => x_msg_count,

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

1200: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1202: p_api_name => l_api_name,
1203: p_pkg_name => G_PKG_NAME,
1204: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1205: x_msg_count => x_msg_count,
1206: x_msg_data => x_msg_data,
1207: p_api_type => G_API_TYPE);
1208:

Line 1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1205: x_msg_count => x_msg_count,
1206: x_msg_data => x_msg_data,
1207: p_api_type => G_API_TYPE);
1208:
1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1211: p_api_name => l_api_name,
1212: p_pkg_name => G_PKG_NAME,
1213: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1206: x_msg_data => x_msg_data,
1207: p_api_type => G_API_TYPE);
1208:
1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1211: p_api_name => l_api_name,
1212: p_pkg_name => G_PKG_NAME,
1213: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1214: x_msg_count => x_msg_count,

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

1209: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1210: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1211: p_api_name => l_api_name,
1212: p_pkg_name => G_PKG_NAME,
1213: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1214: x_msg_count => x_msg_count,
1215: x_msg_data => x_msg_data,
1216: p_api_type => G_API_TYPE);
1217:

Line 1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1215: x_msg_data => x_msg_data,
1216: p_api_type => G_API_TYPE);
1217:
1218: WHEN OTHERS THEN
1219: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1220: p_api_name => l_api_name,
1221: p_pkg_name => G_PKG_NAME,
1222: p_exc_name => 'OTHERS',
1223: x_msg_count => x_msg_count,