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_ICP_PVT dependencies on OKL_API

Line 91: WHEN OKL_API.G_EXCEPTION_ERROR THEN

87: RETURN l_icpv_rec;
88:
89: EXCEPTION
90:
91: WHEN OKL_API.G_EXCEPTION_ERROR THEN
92:
93: x_return_status := G_RET_STS_ERROR;
94:
95: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 95: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

91: WHEN OKL_API.G_EXCEPTION_ERROR THEN
92:
93: x_return_status := G_RET_STS_ERROR;
94:
95: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
96:
97: x_return_status := G_RET_STS_UNEXP_ERROR;
98:
99: WHEN OTHERS THEN

Line 101: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

97: x_return_status := G_RET_STS_UNEXP_ERROR;
98:
99: WHEN OTHERS THEN
100:
101: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
102: p_msg_name => G_DB_ERROR,
103: p_token1 => G_PROG_NAME_TOKEN,
104: p_token1_value => l_api_name,
105: p_token2 => G_SQLCODE_TOKEN,

Line 237: OKL_API.set_message(p_app_name => G_APP_NAME,

233: BEGIN
234:
235: IF p_id IS NULL THEN
236:
237: OKL_API.set_message(p_app_name => G_APP_NAME,
238: p_msg_name => G_REQUIRED_VALUE,
239: p_token1 => G_COL_NAME_TOKEN,
240: p_token1_value => 'id');
241:

Line 242: RAISE OKL_API.G_EXCEPTION_ERROR;

238: p_msg_name => G_REQUIRED_VALUE,
239: p_token1 => G_COL_NAME_TOKEN,
240: p_token1_value => 'id');
241:
242: RAISE OKL_API.G_EXCEPTION_ERROR;
243:
244: END IF;
245:
246: x_return_status := G_RET_STS_SUCCESS;

Line 250: WHEN OKL_API.G_EXCEPTION_ERROR THEN

246: x_return_status := G_RET_STS_SUCCESS;
247:
248: EXCEPTION
249:
250: WHEN OKL_API.G_EXCEPTION_ERROR THEN
251:
252: x_return_status := G_RET_STS_ERROR;
253:
254: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 254: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

250: WHEN OKL_API.G_EXCEPTION_ERROR THEN
251:
252: x_return_status := G_RET_STS_ERROR;
253:
254: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
255:
256: x_return_status := G_RET_STS_UNEXP_ERROR;
257:
258: WHEN OTHERS THEN

Line 260: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

256: x_return_status := G_RET_STS_UNEXP_ERROR;
257:
258: WHEN OTHERS THEN
259:
260: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
261: p_msg_name => G_DB_ERROR,
262: p_token1 => G_PROG_NAME_TOKEN,
263: p_token1_value => l_api_name,
264: p_token2 => G_SQLCODE_TOKEN,

Line 283: OKL_API.set_message(p_app_name => G_APP_NAME,

279: BEGIN
280:
281: IF (p_object_version_number IS NULL) OR (p_object_version_number = G_MISS_NUM) THEN
282:
283: OKL_API.set_message(p_app_name => G_APP_NAME,
284: p_msg_name => G_REQUIRED_VALUE,
285: p_token1 => G_COL_NAME_TOKEN,
286: p_token1_value => 'object_version_number');
287:

Line 288: RAISE OKL_API.G_EXCEPTION_ERROR;

284: p_msg_name => G_REQUIRED_VALUE,
285: p_token1 => G_COL_NAME_TOKEN,
286: p_token1_value => 'object_version_number');
287:
288: RAISE OKL_API.G_EXCEPTION_ERROR;
289:
290: END IF;
291:
292: x_return_status := G_RET_STS_SUCCESS;

Line 296: WHEN OKL_API.G_EXCEPTION_ERROR THEN

292: x_return_status := G_RET_STS_SUCCESS;
293:
294: EXCEPTION
295:
296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
297:
298: x_return_status := G_RET_STS_ERROR;
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
297:
298: x_return_status := G_RET_STS_ERROR;
299:
300: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
301:
302: x_return_status := G_RET_STS_UNEXP_ERROR;
303:
304: WHEN OTHERS THEN

Line 306: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

302: x_return_status := G_RET_STS_UNEXP_ERROR;
303:
304: WHEN OTHERS THEN
305:
306: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
307: p_msg_name => G_DB_ERROR,
308: p_token1 => G_PROG_NAME_TOKEN,
309: p_token1_value => l_api_name,
310: p_token2 => G_SQLCODE_TOKEN,

Line 332: OKL_API.set_message(p_app_name => G_APP_NAME,

328: BEGIN
329:
330: IF p_cat_id1 IS NULL THEN
331:
332: OKL_API.set_message(p_app_name => G_APP_NAME,
333: p_msg_name => G_REQUIRED_VALUE,
334: p_token1 => G_COL_NAME_TOKEN,
335: p_token1_value => 'cat_id1');
336:

Line 337: RAISE OKL_API.G_EXCEPTION_ERROR;

333: p_msg_name => G_REQUIRED_VALUE,
334: p_token1 => G_COL_NAME_TOKEN,
335: p_token1_value => 'cat_id1');
336:
337: RAISE OKL_API.G_EXCEPTION_ERROR;
338:
339: END IF;
340:
341: x_return_status := G_RET_STS_SUCCESS;

Line 345: WHEN OKL_API.G_EXCEPTION_ERROR THEN

341: x_return_status := G_RET_STS_SUCCESS;
342:
343: EXCEPTION
344:
345: WHEN OKL_API.G_EXCEPTION_ERROR THEN
346:
347: x_return_status := G_RET_STS_ERROR;
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

345: WHEN OKL_API.G_EXCEPTION_ERROR THEN
346:
347: x_return_status := G_RET_STS_ERROR;
348:
349: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350:
351: x_return_status := G_RET_STS_UNEXP_ERROR;
352:
353: WHEN OTHERS THEN

Line 355: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

351: x_return_status := G_RET_STS_UNEXP_ERROR;
352:
353: WHEN OTHERS THEN
354:
355: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
356: p_msg_name => G_DB_ERROR,
357: p_token1 => G_PROG_NAME_TOKEN,
358: p_token1_value => l_api_name,
359: p_token2 => G_SQLCODE_TOKEN,

Line 381: OKL_API.set_message(p_app_name => G_APP_NAME,

377: BEGIN
378:
379: IF p_cat_id2 IS NULL THEN
380:
381: OKL_API.set_message(p_app_name => G_APP_NAME,
382: p_msg_name => G_REQUIRED_VALUE,
383: p_token1 => G_COL_NAME_TOKEN,
384: p_token1_value => 'cat_id2');
385:

Line 386: RAISE OKL_API.G_EXCEPTION_ERROR;

382: p_msg_name => G_REQUIRED_VALUE,
383: p_token1 => G_COL_NAME_TOKEN,
384: p_token1_value => 'cat_id2');
385:
386: RAISE OKL_API.G_EXCEPTION_ERROR;
387:
388: END IF;
389:
390: x_return_status := G_RET_STS_SUCCESS;

Line 394: WHEN OKL_API.G_EXCEPTION_ERROR THEN

390: x_return_status := G_RET_STS_SUCCESS;
391:
392: EXCEPTION
393:
394: WHEN OKL_API.G_EXCEPTION_ERROR THEN
395:
396: x_return_status := G_RET_STS_ERROR;
397:
398: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 398: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

394: WHEN OKL_API.G_EXCEPTION_ERROR THEN
395:
396: x_return_status := G_RET_STS_ERROR;
397:
398: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
399:
400: x_return_status := G_RET_STS_UNEXP_ERROR;
401:
402: WHEN OTHERS THEN

Line 404: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

400: x_return_status := G_RET_STS_UNEXP_ERROR;
401:
402: WHEN OTHERS THEN
403:
404: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
405: p_msg_name => G_DB_ERROR,
406: p_token1 => G_PROG_NAME_TOKEN,
407: p_token1_value => l_api_name,
408: p_token2 => G_SQLCODE_TOKEN,

Line 430: OKL_API.set_message(p_app_name => G_APP_NAME,

426: BEGIN
427:
428: IF p_term_in_months IS NULL THEN
429:
430: OKL_API.set_message(p_app_name => G_APP_NAME,
431: p_msg_name => G_REQUIRED_VALUE,
432: p_token1 => G_COL_NAME_TOKEN,
433: p_token1_value => 'term_in_months');
434:

Line 435: RAISE OKL_API.G_EXCEPTION_ERROR;

431: p_msg_name => G_REQUIRED_VALUE,
432: p_token1 => G_COL_NAME_TOKEN,
433: p_token1_value => 'term_in_months');
434:
435: RAISE OKL_API.G_EXCEPTION_ERROR;
436:
437: END IF;
438:
439: IF p_term_in_months <= 0 THEN

Line 441: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM');

437: END IF;
438:
439: IF p_term_in_months <= 0 THEN
440:
441: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM');
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443:
444: END IF;
445:

Line 442: RAISE OKL_API.G_EXCEPTION_ERROR;

438:
439: IF p_term_in_months <= 0 THEN
440:
441: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM');
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443:
444: END IF;
445:
446: IF TRUNC(p_term_in_months) <> p_term_in_months THEN

Line 448: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM2');

444: END IF;
445:
446: IF TRUNC(p_term_in_months) <> p_term_in_months THEN
447:
448: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM2');
449: RAISE OKL_API.G_EXCEPTION_ERROR;
450:
451: END IF;
452:

Line 449: RAISE OKL_API.G_EXCEPTION_ERROR;

445:
446: IF TRUNC(p_term_in_months) <> p_term_in_months THEN
447:
448: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_TERM2');
449: RAISE OKL_API.G_EXCEPTION_ERROR;
450:
451: END IF;
452:
453: x_return_status := G_RET_STS_SUCCESS;

Line 457: WHEN OKL_API.G_EXCEPTION_ERROR THEN

453: x_return_status := G_RET_STS_SUCCESS;
454:
455: EXCEPTION
456:
457: WHEN OKL_API.G_EXCEPTION_ERROR THEN
458:
459: x_return_status := G_RET_STS_ERROR;
460:
461: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 461: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

457: WHEN OKL_API.G_EXCEPTION_ERROR THEN
458:
459: x_return_status := G_RET_STS_ERROR;
460:
461: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
462:
463: x_return_status := G_RET_STS_UNEXP_ERROR;
464:
465: WHEN OTHERS THEN

Line 467: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

463: x_return_status := G_RET_STS_UNEXP_ERROR;
464:
465: WHEN OTHERS THEN
466:
467: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
468: p_msg_name => G_DB_ERROR,
469: p_token1 => G_PROG_NAME_TOKEN,
470: p_token1_value => l_api_name,
471: p_token2 => G_SQLCODE_TOKEN,

Line 493: OKL_API.set_message(p_app_name => G_APP_NAME,

489: BEGIN
490:
491: IF p_residual_value_percent IS NULL THEN
492:
493: OKL_API.set_message(p_app_name => G_APP_NAME,
494: p_msg_name => G_REQUIRED_VALUE,
495: p_token1 => G_COL_NAME_TOKEN,
496: p_token1_value => 'residual_value_percent');
497:

Line 498: RAISE OKL_API.G_EXCEPTION_ERROR;

494: p_msg_name => G_REQUIRED_VALUE,
495: p_token1 => G_COL_NAME_TOKEN,
496: p_token1_value => 'residual_value_percent');
497:
498: RAISE OKL_API.G_EXCEPTION_ERROR;
499:
500: END IF;
501:
502: IF p_residual_value_percent < 0 OR p_residual_value_percent >= 100 THEN

Line 504: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_RV');

500: END IF;
501:
502: IF p_residual_value_percent < 0 OR p_residual_value_percent >= 100 THEN
503:
504: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_RV');
505: RAISE OKL_API.G_EXCEPTION_ERROR;
506:
507: END IF;
508:

Line 505: RAISE OKL_API.G_EXCEPTION_ERROR;

501:
502: IF p_residual_value_percent < 0 OR p_residual_value_percent >= 100 THEN
503:
504: OKL_API.set_message(OKL_API.G_APP_NAME, 'OKL_INVALID_RV');
505: RAISE OKL_API.G_EXCEPTION_ERROR;
506:
507: END IF;
508:
509: x_return_status := G_RET_STS_SUCCESS;

Line 513: WHEN OKL_API.G_EXCEPTION_ERROR THEN

509: x_return_status := G_RET_STS_SUCCESS;
510:
511: EXCEPTION
512:
513: WHEN OKL_API.G_EXCEPTION_ERROR THEN
514:
515: x_return_status := G_RET_STS_ERROR;
516:
517: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 517: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

513: WHEN OKL_API.G_EXCEPTION_ERROR THEN
514:
515: x_return_status := G_RET_STS_ERROR;
516:
517: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
518:
519: x_return_status := G_RET_STS_UNEXP_ERROR;
520:
521: WHEN OTHERS THEN

Line 523: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

519: x_return_status := G_RET_STS_UNEXP_ERROR;
520:
521: WHEN OTHERS THEN
522:
523: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
524: p_msg_name => G_DB_ERROR,
525: p_token1 => G_PROG_NAME_TOKEN,
526: p_token1_value => l_api_name,
527: p_token2 => G_SQLCODE_TOKEN,

Line 548: OKL_API.set_message(p_app_name => G_APP_NAME,

544: BEGIN
545:
546: IF p_item_residual_id IS NULL THEN
547:
548: OKL_API.set_message(p_app_name => G_APP_NAME,
549: p_msg_name => G_REQUIRED_VALUE,
550: p_token1 => G_COL_NAME_TOKEN,
551: p_token1_value => 'item_residual_id');
552:

Line 553: RAISE OKL_API.G_EXCEPTION_ERROR;

549: p_msg_name => G_REQUIRED_VALUE,
550: p_token1 => G_COL_NAME_TOKEN,
551: p_token1_value => 'item_residual_id');
552:
553: RAISE OKL_API.G_EXCEPTION_ERROR;
554:
555: END IF;
556:
557:

Line 562: WHEN OKL_API.G_EXCEPTION_ERROR THEN

558: x_return_status := G_RET_STS_SUCCESS;
559:
560: EXCEPTION
561:
562: WHEN OKL_API.G_EXCEPTION_ERROR THEN
563:
564: x_return_status := G_RET_STS_ERROR;
565:
566: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 566: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

562: WHEN OKL_API.G_EXCEPTION_ERROR THEN
563:
564: x_return_status := G_RET_STS_ERROR;
565:
566: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
567:
568: x_return_status := G_RET_STS_UNEXP_ERROR;
569:
570: WHEN OTHERS THEN

Line 572: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

568: x_return_status := G_RET_STS_UNEXP_ERROR;
569:
570: WHEN OTHERS THEN
571:
572: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
573: p_msg_name => G_DB_ERROR,
574: p_token1 => G_PROG_NAME_TOKEN,
575: p_token1_value => l_api_name,
576: p_token2 => G_SQLCODE_TOKEN,

Line 592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

588: PROCEDURE validate_sts_code (x_return_status OUT NOCOPY VARCHAR2,
589: p_sts_code IN VARCHAR2) IS
590:
591: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_sts_code';
592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
593: BEGIN
594:
595: IF p_sts_code IS NULL THEN
596: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 596: OKL_API.set_message(p_app_name => G_APP_NAME,

592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
593: BEGIN
594:
595: IF p_sts_code IS NULL THEN
596: OKL_API.set_message(p_app_name => G_APP_NAME,
597: p_msg_name => G_REQUIRED_VALUE,
598: p_token1 => G_COL_NAME_TOKEN,
599: p_token1_value => 'sts_code');
600: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 600: RAISE OKL_API.G_EXCEPTION_ERROR;

596: OKL_API.set_message(p_app_name => G_APP_NAME,
597: p_msg_name => G_REQUIRED_VALUE,
598: p_token1 => G_COL_NAME_TOKEN,
599: p_token1_value => 'sts_code');
600: RAISE OKL_API.G_EXCEPTION_ERROR;
601: END IF;
602: l_return_status := OKL_UTIL.check_lookup_code(
603: p_lookup_type => 'OKL_PRC_STATUS',
604: p_lookup_code => p_sts_code);

Line 611: raise OKL_API.G_EXCEPTION_ERROR;

607: p_msg_name => g_invalid_value,
608: p_token1 => g_col_name_token,
609: p_token1_value => 'sts_code');
610: -- notify caller of an error
611: raise OKL_API.G_EXCEPTION_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
613: -- notify caller of an error
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;

Line 614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

610: -- notify caller of an error
611: raise OKL_API.G_EXCEPTION_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
613: -- notify caller of an error
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:
617: x_return_status := G_RET_STS_SUCCESS;
618:

Line 621: WHEN OKL_API.G_EXCEPTION_ERROR THEN

617: x_return_status := G_RET_STS_SUCCESS;
618:
619: EXCEPTION
620:
621: WHEN OKL_API.G_EXCEPTION_ERROR THEN
622:
623: x_return_status := G_RET_STS_ERROR;
624:
625: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 625: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

621: WHEN OKL_API.G_EXCEPTION_ERROR THEN
622:
623: x_return_status := G_RET_STS_ERROR;
624:
625: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
626:
627: x_return_status := G_RET_STS_UNEXP_ERROR;
628:
629: WHEN OTHERS THEN

Line 631: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

627: x_return_status := G_RET_STS_UNEXP_ERROR;
628:
629: WHEN OTHERS THEN
630:
631: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
632: p_msg_name => G_DB_ERROR,
633: p_token1 => G_PROG_NAME_TOKEN,
634: p_token1_value => l_api_name,
635: p_token2 => G_SQLCODE_TOKEN,

Line 656: OKL_API.set_message(p_app_name => G_APP_NAME,

652: BEGIN
653:
654: IF p_version_number IS NULL THEN
655:
656: OKL_API.set_message(p_app_name => G_APP_NAME,
657: p_msg_name => G_REQUIRED_VALUE,
658: p_token1 => G_COL_NAME_TOKEN,
659: p_token1_value => 'version_number');
660:

Line 661: RAISE OKL_API.G_EXCEPTION_ERROR;

657: p_msg_name => G_REQUIRED_VALUE,
658: p_token1 => G_COL_NAME_TOKEN,
659: p_token1_value => 'version_number');
660:
661: RAISE OKL_API.G_EXCEPTION_ERROR;
662:
663: END IF;
664:
665:

Line 670: WHEN OKL_API.G_EXCEPTION_ERROR THEN

666: x_return_status := G_RET_STS_SUCCESS;
667:
668: EXCEPTION
669:
670: WHEN OKL_API.G_EXCEPTION_ERROR THEN
671:
672: x_return_status := G_RET_STS_ERROR;
673:
674: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 674: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

670: WHEN OKL_API.G_EXCEPTION_ERROR THEN
671:
672: x_return_status := G_RET_STS_ERROR;
673:
674: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
675:
676: x_return_status := G_RET_STS_UNEXP_ERROR;
677:
678: WHEN OTHERS THEN

Line 680: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

676: x_return_status := G_RET_STS_UNEXP_ERROR;
677:
678: WHEN OTHERS THEN
679:
680: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
681: p_msg_name => G_DB_ERROR,
682: p_token1 => G_PROG_NAME_TOKEN,
683: p_token1_value => l_api_name,
684: p_token2 => G_SQLCODE_TOKEN,

Line 710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

706:
707: validate_id(l_return_status, p_icpv_rec.id);
708:
709: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714:

Line 712: RAISE OKL_API.G_EXCEPTION_ERROR;

708:
709: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714:
715: -- ***
716: -- object_version_number

Line 722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

718:
719: validate_object_version_number (l_return_status, p_icpv_rec.object_version_number);
720:
721: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726: /* smadhava - Pricing Enhancements - Modified - Start */

Line 724: RAISE OKL_API.G_EXCEPTION_ERROR;

720:
721: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726: /* smadhava - Pricing Enhancements - Modified - Start */
727: /*
728: Commenting the validations for cat_id1, cat_id2, term_in_months and residual_value_percent

Line 739: RAISE OKL_API.G_EXCEPTION_ERROR;

735: -- ***
736: /*
737: validate_cat_id1(l_return_status, p_icpv_rec.cat_id1);
738: IF l_return_status = G_RET_STS_ERROR THEN
739: RAISE OKL_API.G_EXCEPTION_ERROR;
740: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: END IF;
743: */

Line 741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

737: validate_cat_id1(l_return_status, p_icpv_rec.cat_id1);
738: IF l_return_status = G_RET_STS_ERROR THEN
739: RAISE OKL_API.G_EXCEPTION_ERROR;
740: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: END IF;
743: */
744: -- ***
745: -- cat_id2

Line 750: RAISE OKL_API.G_EXCEPTION_ERROR;

746: -- ***
747: /*
748: validate_cat_id2(l_return_status, p_icpv_rec.cat_id2);
749: IF l_return_status = G_RET_STS_ERROR THEN
750: RAISE OKL_API.G_EXCEPTION_ERROR;
751: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
753: END IF;
754: */

Line 752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

748: validate_cat_id2(l_return_status, p_icpv_rec.cat_id2);
749: IF l_return_status = G_RET_STS_ERROR THEN
750: RAISE OKL_API.G_EXCEPTION_ERROR;
751: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
752: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
753: END IF;
754: */
755: -- ***
756: -- term_in_months

Line 762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

758: /*
759: validate_term_in_months(l_return_status, p_icpv_rec.term_in_months);
760:
761: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
764: RAISE OKL_API.G_EXCEPTION_ERROR;
765: END IF;
766: */

Line 764: RAISE OKL_API.G_EXCEPTION_ERROR;

760:
761: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
764: RAISE OKL_API.G_EXCEPTION_ERROR;
765: END IF;
766: */
767: -- ***
768: -- residual_value_percent

Line 774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

770: /*
771: validate_rv_percent (l_return_status, p_icpv_rec.residual_value_percent);
772:
773: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778: */

Line 776: RAISE OKL_API.G_EXCEPTION_ERROR;

772:
773: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
776: RAISE OKL_API.G_EXCEPTION_ERROR;
777: END IF;
778: */
779: /* smadhava - Pricing Enhancements - Modified - End */
780:

Line 789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

785:
786: validate_item_residual_id(l_return_status, p_icpv_rec.item_residual_id);
787:
788: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
791: RAISE OKL_API.G_EXCEPTION_ERROR;
792: END IF;
793:

Line 791: RAISE OKL_API.G_EXCEPTION_ERROR;

787:
788: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
790: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
791: RAISE OKL_API.G_EXCEPTION_ERROR;
792: END IF;
793:
794: -- ***
795: -- sts_code

Line 801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

797:
798: validate_sts_code(l_return_status, p_icpv_rec.sts_code);
799:
800: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:

Line 803: RAISE OKL_API.G_EXCEPTION_ERROR;

799:
800: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806: -- ***
807: -- version_number

Line 812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

808: -- ***
809: validate_version_number(l_return_status, p_icpv_rec.version_number);
810:
811: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;
816: /* smadhava - Pricing Enhancements - Added - End */

Line 814: RAISE OKL_API.G_EXCEPTION_ERROR;

810:
811: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
813: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_ERROR;
815: END IF;
816: /* smadhava - Pricing Enhancements - Added - End */
817:
818: RETURN G_RET_STS_SUCCESS;

Line 822: WHEN OKL_API.G_EXCEPTION_ERROR THEN

818: RETURN G_RET_STS_SUCCESS;
819:
820: EXCEPTION
821:
822: WHEN OKL_API.G_EXCEPTION_ERROR THEN
823:
824: RETURN G_RET_STS_ERROR;
825:
826: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 826: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

822: WHEN OKL_API.G_EXCEPTION_ERROR THEN
823:
824: RETURN G_RET_STS_ERROR;
825:
826: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
827:
828: RETURN G_RET_STS_UNEXP_ERROR;
829:
830: WHEN OTHERS THEN

Line 832: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

828: RETURN G_RET_STS_UNEXP_ERROR;
829:
830: WHEN OTHERS THEN
831:
832: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
833: p_msg_name => G_DB_ERROR,
834: p_token1 => G_PROG_NAME_TOKEN,
835: p_token1_value => l_api_name,
836: p_token2 => G_SQLCODE_TOKEN,

Line 881: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

877:
878: /* The if condition is modified to check only the effective from date */
879: -- IF p_icpv_rec.end_date IS NOT NULL AND p_icpv_rec.start_date IS NULL THEN
880: IF p_icpv_rec.start_date IS NULL THEN
881: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
882: p_msg_name => 'OKL_REQUIRED_EFFECTIVE_FROM');
883:
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885:

Line 884: RAISE OKL_API.G_EXCEPTION_ERROR;

880: IF p_icpv_rec.start_date IS NULL THEN
881: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
882: p_msg_name => 'OKL_REQUIRED_EFFECTIVE_FROM');
883:
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885:
886: END IF;
887:
888: IF p_icpv_rec.end_date IS NOT NULL AND p_icpv_rec.end_date <> G_MISS_DATE AND p_icpv_rec.end_date < p_icpv_rec.start_date THEN

Line 890: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

886: END IF;
887:
888: IF p_icpv_rec.end_date IS NOT NULL AND p_icpv_rec.end_date <> G_MISS_DATE AND p_icpv_rec.end_date < p_icpv_rec.start_date THEN
889:
890: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
891: p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
892:
893: RAISE OKL_API.G_EXCEPTION_ERROR;
894:

Line 893: RAISE OKL_API.G_EXCEPTION_ERROR;

889:
890: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
891: p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
892:
893: RAISE OKL_API.G_EXCEPTION_ERROR;
894:
895: END IF;
896: /* smadhava - Pricing Enhancements - Added - End */
897:

Line 920: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

916: IF l_uk_rec.end_date IS NULL THEN
917:
918: IF (p_icpv_rec.end_date >= l_uk_rec.start_date) OR (p_icpv_rec.end_date IS NULL) THEN
919:
920: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
921: p_msg_name => 'OKL_ITMRV_EXISTS',
922: p_token1 => 'ITEM_DESC',
923: p_token1_value => l_item_desc,
924: p_token2 => 'TERM',

Line 927: RAISE OKL_API.G_EXCEPTION_ERROR;

923: p_token1_value => l_item_desc,
924: p_token2 => 'TERM',
925: p_token2_value => p_icpv_rec.term_in_months);
926:
927: RAISE OKL_API.G_EXCEPTION_ERROR;
928:
929: END IF;
930:
931: END IF;

Line 938: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

934: IF l_uk_rec.end_date IS NOT NULL THEN
935:
936: IF p_icpv_rec.end_date BETWEEN l_uk_rec.start_date AND l_uk_rec.end_date THEN
937:
938: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
939: p_msg_name => 'OKL_ITMRV_EXISTS',
940: p_token1 => 'ITEM_DESC',
941: p_token1_value => l_item_desc,
942: p_token2 => 'TERM',

Line 945: RAISE OKL_API.G_EXCEPTION_ERROR;

941: p_token1_value => l_item_desc,
942: p_token2 => 'TERM',
943: p_token2_value => p_icpv_rec.term_in_months);
944:
945: RAISE OKL_API.G_EXCEPTION_ERROR;
946:
947: END IF;
948:
949: IF p_icpv_rec.start_date <= l_uk_rec.end_date AND p_icpv_rec.end_date IS NULL THEN

Line 951: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

947: END IF;
948:
949: IF p_icpv_rec.start_date <= l_uk_rec.end_date AND p_icpv_rec.end_date IS NULL THEN
950:
951: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
952: p_msg_name => 'OKL_ITMRV_EXISTS',
953: p_token1 => 'ITEM_DESC',
954: p_token1_value => l_item_desc,
955: p_token2 => 'TERM',

Line 958: RAISE OKL_API.G_EXCEPTION_ERROR;

954: p_token1_value => l_item_desc,
955: p_token2 => 'TERM',
956: p_token2_value => p_icpv_rec.term_in_months);
957:
958: RAISE OKL_API.G_EXCEPTION_ERROR;
959:
960: END IF;
961:
962: END IF;

Line 974: WHEN OKL_API.G_EXCEPTION_ERROR THEN

970: RETURN G_RET_STS_SUCCESS;
971:
972: EXCEPTION
973:
974: WHEN OKL_API.G_EXCEPTION_ERROR THEN
975:
976: RETURN G_RET_STS_ERROR;
977:
978: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 978: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

974: WHEN OKL_API.G_EXCEPTION_ERROR THEN
975:
976: RETURN G_RET_STS_ERROR;
977:
978: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
979:
980: RETURN G_RET_STS_UNEXP_ERROR;
981:
982: WHEN OTHERS THEN

Line 984: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

980: RETURN G_RET_STS_UNEXP_ERROR;
981:
982: WHEN OTHERS THEN
983:
984: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
985: p_msg_name => G_DB_ERROR,
986: p_token1 => G_PROG_NAME_TOKEN,
987: p_token1_value => l_api_name,
988: p_token2 => G_SQLCODE_TOKEN,

Line 1018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1014:
1015: l_return_status := validate_attributes(p_icpv_rec);
1016:
1017: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1020: RAISE OKL_API.G_EXCEPTION_ERROR;
1021: END IF;
1022:

Line 1020: RAISE OKL_API.G_EXCEPTION_ERROR;

1016:
1017: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1020: RAISE OKL_API.G_EXCEPTION_ERROR;
1021: END IF;
1022:
1023: l_return_status := validate_record(p_icpv_rec);
1024:

Line 1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1022:
1023: l_return_status := validate_record(p_icpv_rec);
1024:
1025: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030:

Line 1028: RAISE OKL_API.G_EXCEPTION_ERROR;

1024:
1025: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1028: RAISE OKL_API.G_EXCEPTION_ERROR;
1029: END IF;
1030:
1031: EXCEPTION
1032:

Line 1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1029: END IF;
1030:
1031: EXCEPTION
1032:
1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1034:
1035: x_return_status := G_RET_STS_ERROR;
1036:
1037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1033: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1034:
1035: x_return_status := G_RET_STS_ERROR;
1036:
1037: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1038:
1039: x_return_status := G_RET_STS_UNEXP_ERROR;
1040:
1041: WHEN OTHERS THEN

Line 1043: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1039: x_return_status := G_RET_STS_UNEXP_ERROR;
1040:
1041: WHEN OTHERS THEN
1042:
1043: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1044: p_msg_name => G_DB_ERROR,
1045: p_token1 => G_PROG_NAME_TOKEN,
1046: p_token1_value => l_api_name,
1047: p_token2 => G_SQLCODE_TOKEN,

Line 1090: RAISE OKL_API.G_EXCEPTION_ERROR;

1086: x_msg_data => x_msg_data,
1087: p_icpv_rec => p_icpv_tbl(i));
1088:
1089: IF l_return_status = G_RET_STS_ERROR THEN
1090: RAISE OKL_API.G_EXCEPTION_ERROR;
1091: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: END IF;
1094:

Line 1092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1088:
1089: IF l_return_status = G_RET_STS_ERROR THEN
1090: RAISE OKL_API.G_EXCEPTION_ERROR;
1091: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1092: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1093: END IF;
1094:
1095: EXIT WHEN i = p_icpv_tbl.LAST;
1096: i := p_icpv_tbl.NEXT(i);

Line 1108: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1104: x_return_status := l_return_status;
1105:
1106: EXCEPTION
1107:
1108: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1109:
1110: x_return_status := G_RET_STS_ERROR;
1111:
1112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1108: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1109:
1110: x_return_status := G_RET_STS_ERROR;
1111:
1112: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1113:
1114: x_return_status := G_RET_STS_UNEXP_ERROR;
1115:
1116: WHEN OTHERS THEN

Line 1118: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1114: x_return_status := G_RET_STS_UNEXP_ERROR;
1115:
1116: WHEN OTHERS THEN
1117:
1118: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1119: p_msg_name => G_DB_ERROR,
1120: p_token1 => G_PROG_NAME_TOKEN,
1121: p_token1_value => l_api_name,
1122: p_token2 => G_SQLCODE_TOKEN,

Line 1163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1159: l_icpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1160:
1161: l_return_status := validate_attributes(l_icpv_rec);
1162: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1165: RAISE OKL_API.G_EXCEPTION_ERROR;
1166: END IF;
1167: l_return_status := validate_record(l_icpv_rec);

Line 1165: RAISE OKL_API.G_EXCEPTION_ERROR;

1161: l_return_status := validate_attributes(l_icpv_rec);
1162: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1164: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1165: RAISE OKL_API.G_EXCEPTION_ERROR;
1166: END IF;
1167: l_return_status := validate_record(l_icpv_rec);
1168:
1169: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1166: END IF;
1167: l_return_status := validate_record(l_icpv_rec);
1168:
1169: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: /* smadhava - Pricing Enhancements - Modified- Start */

Line 1172: RAISE OKL_API.G_EXCEPTION_ERROR;

1168:
1169: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: /* smadhava - Pricing Enhancements - Modified- Start */
1175: INSERT INTO OKL_ITM_CAT_RV_PRCS(
1176: id,

Line 1246: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1242: x_icpv_rec := l_icpv_rec;
1243: x_return_status := l_return_status;
1244: EXCEPTION
1245:
1246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1247:
1248: x_return_status := G_RET_STS_ERROR;
1249:
1250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1247:
1248: x_return_status := G_RET_STS_ERROR;
1249:
1250: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1251:
1252: x_return_status := G_RET_STS_UNEXP_ERROR;
1253:
1254: WHEN OTHERS THEN

Line 1256: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1252: x_return_status := G_RET_STS_UNEXP_ERROR;
1253:
1254: WHEN OTHERS THEN
1255:
1256: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1257: p_msg_name => G_DB_ERROR,
1258: p_token1 => G_PROG_NAME_TOKEN,
1259: p_token1_value => l_api_name,
1260: p_token2 => G_SQLCODE_TOKEN,

Line 1302: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1298: p_icpv_rec => p_icpv_tbl(i),
1299: x_icpv_rec => x_icpv_tbl(i));
1300:
1301: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1302: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1303: ELSIF l_return_status = G_RET_STS_ERROR THEN
1304: RAISE OKL_API.G_EXCEPTION_ERROR;
1305: END IF;
1306:

Line 1304: RAISE OKL_API.G_EXCEPTION_ERROR;

1300:
1301: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1302: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1303: ELSIF l_return_status = G_RET_STS_ERROR THEN
1304: RAISE OKL_API.G_EXCEPTION_ERROR;
1305: END IF;
1306:
1307: EXIT WHEN (i = p_icpv_tbl.LAST);
1308: i := p_icpv_tbl.NEXT(i);

Line 1320: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1316: x_return_status := G_RET_STS_SUCCESS;
1317:
1318: EXCEPTION
1319:
1320: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1321:
1322: x_return_status := G_RET_STS_ERROR;
1323:
1324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1320: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1321:
1322: x_return_status := G_RET_STS_ERROR;
1323:
1324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1325:
1326: x_return_status := G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN

Line 1330: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1326: x_return_status := G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN
1329:
1330: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1331: p_msg_name => G_DB_ERROR,
1332: p_token1 => G_PROG_NAME_TOKEN,
1333: p_token1_value => l_api_name,
1334: p_token2 => G_SQLCODE_TOKEN,

Line 1373: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;

1369: SELECT OBJECT_VERSION_NUMBER
1370: FROM OKL_ITM_CAT_RV_PRCS
1371: WHERE ID = p_icpv_rec.id;
1372:
1373: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1374: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1375: lc_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1376: l_row_notfound BOOLEAN := FALSE;
1377: lc_row_notfound BOOLEAN := FALSE;

Line 1419: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1415: x_return_status := l_return_status;
1416:
1417: EXCEPTION
1418:
1419: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1420:
1421: x_return_status := G_RET_STS_ERROR;
1422:
1423: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1423: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1419: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1420:
1421: x_return_status := G_RET_STS_ERROR;
1422:
1423: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1424:
1425: x_return_status := G_RET_STS_UNEXP_ERROR;
1426:
1427: WHEN OTHERS THEN

Line 1429: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1425: x_return_status := G_RET_STS_UNEXP_ERROR;
1426:
1427: WHEN OTHERS THEN
1428:
1429: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1430: p_msg_name => G_DB_ERROR,
1431: p_token1 => G_PROG_NAME_TOKEN,
1432: p_token1_value => l_api_name,
1433: p_token2 => G_SQLCODE_TOKEN,

Line 1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1472: x_msg_data => x_msg_data,
1473: p_icpv_rec => p_icpv_tbl(i));
1474:
1475: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = G_RET_STS_ERROR THEN
1478: RAISE OKL_API.G_EXCEPTION_ERROR;
1479: END IF;
1480:

Line 1478: RAISE OKL_API.G_EXCEPTION_ERROR;

1474:
1475: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = G_RET_STS_ERROR THEN
1478: RAISE OKL_API.G_EXCEPTION_ERROR;
1479: END IF;
1480:
1481: EXIT WHEN (i = p_icpv_tbl.LAST);
1482: i := p_icpv_tbl.NEXT(i);

Line 1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1490: x_return_status := l_return_status;
1491:
1492: EXCEPTION
1493:
1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1495:
1496: x_return_status := G_RET_STS_ERROR;
1497:
1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1495:
1496: x_return_status := G_RET_STS_ERROR;
1497:
1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1499:
1500: x_return_status := G_RET_STS_UNEXP_ERROR;
1501:
1502: WHEN OTHERS THEN

Line 1504: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1500: x_return_status := G_RET_STS_UNEXP_ERROR;
1501:
1502: WHEN OTHERS THEN
1503:
1504: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1505: p_msg_name => G_DB_ERROR,
1506: p_token1 => G_PROG_NAME_TOKEN,
1507: p_token1_value => l_api_name,
1508: p_token2 => G_SQLCODE_TOKEN,

Line 1552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1548:
1549: l_db_icpv_rec := get_rec(p_icpv_rec.id, l_return_status);
1550:
1551: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1553: ELSIF l_return_status = G_RET_STS_ERROR THEN
1554: RAISE OKL_API.G_EXCEPTION_ERROR;
1555: END IF;
1556:

Line 1554: RAISE OKL_API.G_EXCEPTION_ERROR;

1550:
1551: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1553: ELSIF l_return_status = G_RET_STS_ERROR THEN
1554: RAISE OKL_API.G_EXCEPTION_ERROR;
1555: END IF;
1556:
1557: -- Do NOT default the following 4 standard attributes from the DB
1558: -- object_version_number

Line 1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1647: RETURN l_return_status;
1648:
1649: EXCEPTION
1650:
1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1652:
1653: x_return_status := G_RET_STS_ERROR;
1654:
1655: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1655: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1652:
1653: x_return_status := G_RET_STS_ERROR;
1654:
1655: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1656:
1657: x_return_status := G_RET_STS_UNEXP_ERROR;
1658:
1659: WHEN OTHERS THEN

Line 1661: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1657: x_return_status := G_RET_STS_UNEXP_ERROR;
1658:
1659: WHEN OTHERS THEN
1660:
1661: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1662: p_msg_name => G_DB_ERROR,
1663: p_token1 => G_PROG_NAME_TOKEN,
1664: p_token1_value => l_api_name,
1665: p_token2 => G_SQLCODE_TOKEN,

Line 1678: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1674: BEGIN
1675: l_return_status := populate_new_record(p_icpv_rec, l_icpv_rec);
1676:
1677: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1678: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1679: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1680: RAISE OKL_API.G_EXCEPTION_ERROR;
1681: END IF;
1682:

Line 1680: RAISE OKL_API.G_EXCEPTION_ERROR;

1676:
1677: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1678: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1679: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1680: RAISE OKL_API.G_EXCEPTION_ERROR;
1681: END IF;
1682:
1683: l_icpv_rec := null_out_defaults(l_icpv_rec);
1684:

Line 1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1688:
1689: l_return_status := validate_attributes(l_icpv_rec);
1690:
1691: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;
1696:

Line 1694: RAISE OKL_API.G_EXCEPTION_ERROR;

1690:
1691: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;
1696:
1697: l_return_status := validate_record(l_icpv_rec);
1698:

Line 1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1696:
1697: l_return_status := validate_record(l_icpv_rec);
1698:
1699: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:

Line 1702: RAISE OKL_API.G_EXCEPTION_ERROR;

1698:
1699: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:
1705: lock_row(p_api_version => G_API_VERSION,
1706: p_init_msg_list => G_FALSE,

Line 1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1709: x_msg_data => x_msg_data,
1710: p_icpv_rec => l_icpv_rec);
1711:
1712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1715: RAISE OKL_API.G_EXCEPTION_ERROR;
1716: END IF;
1717: /* smadhava - Pricing Enhancements - Modified - Start */

Line 1715: RAISE OKL_API.G_EXCEPTION_ERROR;

1711:
1712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1715: RAISE OKL_API.G_EXCEPTION_ERROR;
1716: END IF;
1717: /* smadhava - Pricing Enhancements - Modified - Start */
1718: UPDATE OKL_ITM_CAT_RV_PRCS
1719: SET OBJECT_VERSION_NUMBER = l_icpv_rec.object_version_number+1,

Line 1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1753: x_return_status := l_return_status;
1754:
1755: EXCEPTION
1756:
1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1758:
1759: x_return_status := G_RET_STS_ERROR;
1760:
1761: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1761: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1758:
1759: x_return_status := G_RET_STS_ERROR;
1760:
1761: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1762:
1763: x_return_status := G_RET_STS_UNEXP_ERROR;
1764:
1765: WHEN OTHERS THEN

Line 1767: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1763: x_return_status := G_RET_STS_UNEXP_ERROR;
1764:
1765: WHEN OTHERS THEN
1766:
1767: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1768: p_msg_name => G_DB_ERROR,
1769: p_token1 => G_PROG_NAME_TOKEN,
1770: p_token1_value => l_api_name,
1771: p_token2 => G_SQLCODE_TOKEN,

Line 1815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1811: p_icpv_rec => p_icpv_tbl(i),
1812: x_icpv_rec => x_icpv_tbl(i));
1813:
1814: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = G_RET_STS_ERROR THEN
1817: RAISE OKL_API.G_EXCEPTION_ERROR;
1818: END IF;
1819:

Line 1817: RAISE OKL_API.G_EXCEPTION_ERROR;

1813:
1814: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = G_RET_STS_ERROR THEN
1817: RAISE OKL_API.G_EXCEPTION_ERROR;
1818: END IF;
1819:
1820: EXIT WHEN (i = p_icpv_tbl.LAST);
1821: i := p_icpv_tbl.NEXT(i);

Line 1833: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1829: x_return_status := l_return_status;
1830:
1831: EXCEPTION
1832:
1833: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1834:
1835: x_return_status := G_RET_STS_ERROR;
1836:
1837: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1837: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1833: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1834:
1835: x_return_status := G_RET_STS_ERROR;
1836:
1837: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1838:
1839: x_return_status := G_RET_STS_UNEXP_ERROR;
1840:
1841: WHEN OTHERS THEN

Line 1843: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1839: x_return_status := G_RET_STS_UNEXP_ERROR;
1840:
1841: WHEN OTHERS THEN
1842:
1843: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1844: p_msg_name => G_DB_ERROR,
1845: p_token1 => G_PROG_NAME_TOKEN,
1846: p_token1_value => l_api_name,
1847: p_token2 => G_SQLCODE_TOKEN,

Line 1878: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1874: x_return_status := G_RET_STS_SUCCESS;
1875:
1876: EXCEPTION
1877:
1878: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1879:
1880: x_return_status := G_RET_STS_ERROR;
1881:
1882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1878: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1879:
1880: x_return_status := G_RET_STS_ERROR;
1881:
1882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1883:
1884: x_return_status := G_RET_STS_UNEXP_ERROR;
1885:
1886: WHEN OTHERS THEN

Line 1888: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1884: x_return_status := G_RET_STS_UNEXP_ERROR;
1885:
1886: WHEN OTHERS THEN
1887:
1888: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1889: p_msg_name => G_DB_ERROR,
1890: p_token1 => G_PROG_NAME_TOKEN,
1891: p_token1_value => l_api_name,
1892: p_token2 => G_SQLCODE_TOKEN,

Line 1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1930: x_msg_data => x_msg_data,
1931: p_icpv_rec => p_icpv_tbl(i));
1932:
1933: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = G_RET_STS_ERROR THEN
1936: RAISE OKL_API.G_EXCEPTION_ERROR;
1937: END IF;
1938:

Line 1936: RAISE OKL_API.G_EXCEPTION_ERROR;

1932:
1933: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1935: ELSIF l_return_status = G_RET_STS_ERROR THEN
1936: RAISE OKL_API.G_EXCEPTION_ERROR;
1937: END IF;
1938:
1939: EXIT WHEN (i = p_icpv_tbl.LAST);
1940: i := p_icpv_tbl.NEXT(i);

Line 1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1948: x_return_status := l_return_status;
1949:
1950: EXCEPTION
1951:
1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1953:
1954: x_return_status := G_RET_STS_ERROR;
1955:
1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1953:
1954: x_return_status := G_RET_STS_ERROR;
1955:
1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1957:
1958: x_return_status := G_RET_STS_UNEXP_ERROR;
1959:
1960: WHEN OTHERS THEN

Line 1962: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1958: x_return_status := G_RET_STS_UNEXP_ERROR;
1959:
1960: WHEN OTHERS THEN
1961:
1962: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1963: p_msg_name => G_DB_ERROR,
1964: p_token1 => G_PROG_NAME_TOKEN,
1965: p_token1_value => l_api_name,
1966: p_token2 => G_SQLCODE_TOKEN,