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

Line 159: WHEN okl_api.g_exception_error THEN

155: WHERE lrtv.id = p_id;
156: x_return_status := g_ret_sts_success;
157: RETURN l_lrtv_rec;
158: EXCEPTION
159: WHEN okl_api.g_exception_error THEN
160: x_return_status := g_ret_sts_error;
161: WHEN okl_api.g_exception_unexpected_error THEN
162: x_return_status := g_ret_sts_unexp_error;
163: WHEN OTHERS THEN

Line 161: WHEN okl_api.g_exception_unexpected_error THEN

157: RETURN l_lrtv_rec;
158: EXCEPTION
159: WHEN okl_api.g_exception_error THEN
160: x_return_status := g_ret_sts_error;
161: WHEN okl_api.g_exception_unexpected_error THEN
162: x_return_status := g_ret_sts_unexp_error;
163: WHEN OTHERS THEN
164: okl_api.set_message(p_app_name => g_app_name
165: ,p_msg_name => g_db_error

Line 164: okl_api.set_message(p_app_name => g_app_name

160: x_return_status := g_ret_sts_error;
161: WHEN okl_api.g_exception_unexpected_error THEN
162: x_return_status := g_ret_sts_unexp_error;
163: WHEN OTHERS THEN
164: okl_api.set_message(p_app_name => g_app_name
165: ,p_msg_name => g_db_error
166: ,p_token1 => g_prog_name_token
167: ,p_token1_value => l_api_name
168: ,p_token2 => g_sqlcode_token

Line 354: okl_api.set_message(p_app_name => g_app_name

350:
351: BEGIN
352:
353: IF p_id IS NULL THEN
354: okl_api.set_message(p_app_name => g_app_name
355: ,p_msg_name => g_required_value
356: ,p_token1 => g_col_name_token
357: ,p_token1_value => 'id');
358: RAISE okl_api.g_exception_error;

Line 358: RAISE okl_api.g_exception_error;

354: okl_api.set_message(p_app_name => g_app_name
355: ,p_msg_name => g_required_value
356: ,p_token1 => g_col_name_token
357: ,p_token1_value => 'id');
358: RAISE okl_api.g_exception_error;
359: END IF;
360: x_return_status := g_ret_sts_success;
361: EXCEPTION
362: WHEN okl_api.g_exception_error THEN

Line 362: WHEN okl_api.g_exception_error THEN

358: RAISE okl_api.g_exception_error;
359: END IF;
360: x_return_status := g_ret_sts_success;
361: EXCEPTION
362: WHEN okl_api.g_exception_error THEN
363: x_return_status := g_ret_sts_error;
364: WHEN okl_api.g_exception_unexpected_error THEN
365: x_return_status := g_ret_sts_unexp_error;
366: WHEN OTHERS THEN

Line 364: WHEN okl_api.g_exception_unexpected_error THEN

360: x_return_status := g_ret_sts_success;
361: EXCEPTION
362: WHEN okl_api.g_exception_error THEN
363: x_return_status := g_ret_sts_error;
364: WHEN okl_api.g_exception_unexpected_error THEN
365: x_return_status := g_ret_sts_unexp_error;
366: WHEN OTHERS THEN
367: okl_api.set_message(p_app_name => g_app_name
368: ,p_msg_name => g_db_error

Line 367: okl_api.set_message(p_app_name => g_app_name

363: x_return_status := g_ret_sts_error;
364: WHEN okl_api.g_exception_unexpected_error THEN
365: x_return_status := g_ret_sts_unexp_error;
366: WHEN OTHERS THEN
367: okl_api.set_message(p_app_name => g_app_name
368: ,p_msg_name => g_db_error
369: ,p_token1 => g_prog_name_token
370: ,p_token1_value => l_api_name
371: ,p_token2 => g_sqlcode_token

Line 385: okl_api.set_message(p_app_name => g_app_name

381:
382: BEGIN
383:
384: IF (p_object_version_number IS NULL) OR (p_object_version_number = g_miss_num) THEN
385: okl_api.set_message(p_app_name => g_app_name
386: ,p_msg_name => g_required_value
387: ,p_token1 => g_col_name_token
388: ,p_token1_value => 'object_version_number');
389: RAISE okl_api.g_exception_error;

Line 389: RAISE okl_api.g_exception_error;

385: okl_api.set_message(p_app_name => g_app_name
386: ,p_msg_name => g_required_value
387: ,p_token1 => g_col_name_token
388: ,p_token1_value => 'object_version_number');
389: RAISE okl_api.g_exception_error;
390: END IF;
391: x_return_status := g_ret_sts_success;
392: EXCEPTION
393: WHEN okl_api.g_exception_error THEN

Line 393: WHEN okl_api.g_exception_error THEN

389: RAISE okl_api.g_exception_error;
390: END IF;
391: x_return_status := g_ret_sts_success;
392: EXCEPTION
393: WHEN okl_api.g_exception_error THEN
394: x_return_status := g_ret_sts_error;
395: WHEN okl_api.g_exception_unexpected_error THEN
396: x_return_status := g_ret_sts_unexp_error;
397: WHEN OTHERS THEN

Line 395: WHEN okl_api.g_exception_unexpected_error THEN

391: x_return_status := g_ret_sts_success;
392: EXCEPTION
393: WHEN okl_api.g_exception_error THEN
394: x_return_status := g_ret_sts_error;
395: WHEN okl_api.g_exception_unexpected_error THEN
396: x_return_status := g_ret_sts_unexp_error;
397: WHEN OTHERS THEN
398: okl_api.set_message(p_app_name => g_app_name
399: ,p_msg_name => g_db_error

Line 398: okl_api.set_message(p_app_name => g_app_name

394: x_return_status := g_ret_sts_error;
395: WHEN okl_api.g_exception_unexpected_error THEN
396: x_return_status := g_ret_sts_unexp_error;
397: WHEN OTHERS THEN
398: okl_api.set_message(p_app_name => g_app_name
399: ,p_msg_name => g_db_error
400: ,p_token1 => g_prog_name_token
401: ,p_token1_value => l_api_name
402: ,p_token2 => g_sqlcode_token

Line 420: okl_api.set_message(p_app_name => g_app_name

416:
417: BEGIN
418:
419: IF p_rate IS NULL THEN
420: okl_api.set_message(p_app_name => g_app_name
421: ,p_msg_name => g_required_value
422: ,p_token1 => g_col_name_token
423: ,p_token1_value => 'rate');
424: RAISE okl_api.g_exception_error;

Line 424: RAISE okl_api.g_exception_error;

420: okl_api.set_message(p_app_name => g_app_name
421: ,p_msg_name => g_required_value
422: ,p_token1 => g_col_name_token
423: ,p_token1_value => 'rate');
424: RAISE okl_api.g_exception_error;
425: END IF;
426: x_return_status := g_ret_sts_success;
427: EXCEPTION
428: WHEN okl_api.g_exception_error THEN

Line 428: WHEN okl_api.g_exception_error THEN

424: RAISE okl_api.g_exception_error;
425: END IF;
426: x_return_status := g_ret_sts_success;
427: EXCEPTION
428: WHEN okl_api.g_exception_error THEN
429: x_return_status := g_ret_sts_error;
430: WHEN okl_api.g_exception_unexpected_error THEN
431: x_return_status := g_ret_sts_unexp_error;
432: WHEN OTHERS THEN

Line 430: WHEN okl_api.g_exception_unexpected_error THEN

426: x_return_status := g_ret_sts_success;
427: EXCEPTION
428: WHEN okl_api.g_exception_error THEN
429: x_return_status := g_ret_sts_error;
430: WHEN okl_api.g_exception_unexpected_error THEN
431: x_return_status := g_ret_sts_unexp_error;
432: WHEN OTHERS THEN
433: okl_api.set_message(p_app_name => g_app_name
434: ,p_msg_name => g_db_error

Line 433: okl_api.set_message(p_app_name => g_app_name

429: x_return_status := g_ret_sts_error;
430: WHEN okl_api.g_exception_unexpected_error THEN
431: x_return_status := g_ret_sts_unexp_error;
432: WHEN OTHERS THEN
433: okl_api.set_message(p_app_name => g_app_name
434: ,p_msg_name => g_db_error
435: ,p_token1 => g_prog_name_token
436: ,p_token1_value => l_api_name
437: ,p_token2 => g_sqlcode_token

Line 461: okl_api.set_message(p_app_name => g_app_name

457:
458: BEGIN
459:
460: IF p_arrears_yn IS NULL THEN
461: okl_api.set_message(p_app_name => g_app_name
462: ,p_msg_name => g_required_value
463: ,p_token1 => g_col_name_token
464: ,p_token1_value => 'arrears_yn');
465: RAISE okl_api.g_exception_error;

Line 465: RAISE okl_api.g_exception_error;

461: okl_api.set_message(p_app_name => g_app_name
462: ,p_msg_name => g_required_value
463: ,p_token1 => g_col_name_token
464: ,p_token1_value => 'arrears_yn');
465: RAISE okl_api.g_exception_error;
466: END IF;
467: OPEN c_yes_no;
468: FETCH c_yes_no INTO l_dummy ;
469: CLOSE c_yes_no;

Line 472: okl_api.set_message(p_app_name => g_app_name

468: FETCH c_yes_no INTO l_dummy ;
469: CLOSE c_yes_no;
470:
471: IF l_dummy IS NULL THEN
472: okl_api.set_message(p_app_name => g_app_name
473: ,p_msg_name => g_invalid_value
474: ,p_token1 => g_col_name_token
475: ,p_token1_value => 'arrears_yn');
476: RAISE okl_api.g_exception_error;

Line 476: RAISE okl_api.g_exception_error;

472: okl_api.set_message(p_app_name => g_app_name
473: ,p_msg_name => g_invalid_value
474: ,p_token1 => g_col_name_token
475: ,p_token1_value => 'arrears_yn');
476: RAISE okl_api.g_exception_error;
477: END IF;
478: x_return_status := g_ret_sts_success;
479: EXCEPTION
480: WHEN okl_api.g_exception_error THEN

Line 480: WHEN okl_api.g_exception_error THEN

476: RAISE okl_api.g_exception_error;
477: END IF;
478: x_return_status := g_ret_sts_success;
479: EXCEPTION
480: WHEN okl_api.g_exception_error THEN
481: x_return_status := g_ret_sts_error;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := g_ret_sts_unexp_error;
484: WHEN OTHERS THEN

Line 482: WHEN okl_api.g_exception_unexpected_error THEN

478: x_return_status := g_ret_sts_success;
479: EXCEPTION
480: WHEN okl_api.g_exception_error THEN
481: x_return_status := g_ret_sts_error;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := g_ret_sts_unexp_error;
484: WHEN OTHERS THEN
485: okl_api.set_message(p_app_name => g_app_name
486: ,p_msg_name => g_db_error

Line 485: okl_api.set_message(p_app_name => g_app_name

481: x_return_status := g_ret_sts_error;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := g_ret_sts_unexp_error;
484: WHEN OTHERS THEN
485: okl_api.set_message(p_app_name => g_app_name
486: ,p_msg_name => g_db_error
487: ,p_token1 => g_prog_name_token
488: ,p_token1_value => l_api_name
489: ,p_token2 => g_sqlcode_token

Line 513: okl_api.set_message(p_app_name => g_app_name

509:
510: BEGIN
511:
512: IF p_frq_code IS NULL THEN
513: okl_api.set_message(p_app_name => g_app_name
514: ,p_msg_name => g_required_value
515: ,p_token1 => g_col_name_token
516: ,p_token1_value => 'frq_code');
517: RAISE okl_api.g_exception_error;

Line 517: RAISE okl_api.g_exception_error;

513: okl_api.set_message(p_app_name => g_app_name
514: ,p_msg_name => g_required_value
515: ,p_token1 => g_col_name_token
516: ,p_token1_value => 'frq_code');
517: RAISE okl_api.g_exception_error;
518: END IF;
519: OPEN c_frq_code;
520: FETCH c_frq_code INTO l_dummy ;
521: CLOSE c_frq_code;

Line 524: okl_api.set_message(p_app_name => g_app_name

520: FETCH c_frq_code INTO l_dummy ;
521: CLOSE c_frq_code;
522:
523: IF l_dummy IS NULL THEN
524: okl_api.set_message(p_app_name => g_app_name
525: ,p_msg_name => g_invalid_value
526: ,p_token1 => g_col_name_token
527: ,p_token1_value => 'frq_code');
528: RAISE okl_api.g_exception_error;

Line 528: RAISE okl_api.g_exception_error;

524: okl_api.set_message(p_app_name => g_app_name
525: ,p_msg_name => g_invalid_value
526: ,p_token1 => g_col_name_token
527: ,p_token1_value => 'frq_code');
528: RAISE okl_api.g_exception_error;
529: END IF;
530: x_return_status := g_ret_sts_success;
531: EXCEPTION
532: WHEN okl_api.g_exception_error THEN

Line 532: WHEN okl_api.g_exception_error THEN

528: RAISE okl_api.g_exception_error;
529: END IF;
530: x_return_status := g_ret_sts_success;
531: EXCEPTION
532: WHEN okl_api.g_exception_error THEN
533: x_return_status := g_ret_sts_error;
534: WHEN okl_api.g_exception_unexpected_error THEN
535: x_return_status := g_ret_sts_unexp_error;
536: WHEN OTHERS THEN

Line 534: WHEN okl_api.g_exception_unexpected_error THEN

530: x_return_status := g_ret_sts_success;
531: EXCEPTION
532: WHEN okl_api.g_exception_error THEN
533: x_return_status := g_ret_sts_error;
534: WHEN okl_api.g_exception_unexpected_error THEN
535: x_return_status := g_ret_sts_unexp_error;
536: WHEN OTHERS THEN
537: okl_api.set_message(p_app_name => g_app_name
538: ,p_msg_name => g_db_error

Line 537: okl_api.set_message(p_app_name => g_app_name

533: x_return_status := g_ret_sts_error;
534: WHEN okl_api.g_exception_unexpected_error THEN
535: x_return_status := g_ret_sts_unexp_error;
536: WHEN OTHERS THEN
537: okl_api.set_message(p_app_name => g_app_name
538: ,p_msg_name => g_db_error
539: ,p_token1 => g_prog_name_token
540: ,p_token1_value => l_api_name
541: ,p_token2 => g_sqlcode_token

Line 559: okl_api.set_message(p_app_name => g_app_name

555:
556: BEGIN
557:
558: IF p_name IS NULL THEN
559: okl_api.set_message(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'name');
563: RAISE okl_api.g_exception_error;

Line 563: RAISE okl_api.g_exception_error;

559: okl_api.set_message(p_app_name => g_app_name
560: ,p_msg_name => g_required_value
561: ,p_token1 => g_col_name_token
562: ,p_token1_value => 'name');
563: RAISE okl_api.g_exception_error;
564: END IF;
565: x_return_status := g_ret_sts_success;
566: EXCEPTION
567: WHEN okl_api.g_exception_error THEN

Line 567: WHEN okl_api.g_exception_error THEN

563: RAISE okl_api.g_exception_error;
564: END IF;
565: x_return_status := g_ret_sts_success;
566: EXCEPTION
567: WHEN okl_api.g_exception_error THEN
568: x_return_status := g_ret_sts_error;
569: WHEN okl_api.g_exception_unexpected_error THEN
570: x_return_status := g_ret_sts_unexp_error;
571: WHEN OTHERS THEN

Line 569: WHEN okl_api.g_exception_unexpected_error THEN

565: x_return_status := g_ret_sts_success;
566: EXCEPTION
567: WHEN okl_api.g_exception_error THEN
568: x_return_status := g_ret_sts_error;
569: WHEN okl_api.g_exception_unexpected_error THEN
570: x_return_status := g_ret_sts_unexp_error;
571: WHEN OTHERS THEN
572: okl_api.set_message(p_app_name => g_app_name
573: ,p_msg_name => g_db_error

Line 572: okl_api.set_message(p_app_name => g_app_name

568: x_return_status := g_ret_sts_error;
569: WHEN okl_api.g_exception_unexpected_error THEN
570: x_return_status := g_ret_sts_unexp_error;
571: WHEN OTHERS THEN
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 600: okl_api.set_message(p_app_name => g_app_name

596:
597: BEGIN
598:
599: IF p_type_code IS NULL THEN
600: okl_api.set_message(p_app_name => g_app_name
601: ,p_msg_name => g_required_value
602: ,p_token1 => g_col_name_token
603: ,p_token1_value => 'LRS_TYPE_CODE');
604: RAISE okl_api.g_exception_error;

Line 604: RAISE okl_api.g_exception_error;

600: okl_api.set_message(p_app_name => g_app_name
601: ,p_msg_name => g_required_value
602: ,p_token1 => g_col_name_token
603: ,p_token1_value => 'LRS_TYPE_CODE');
604: RAISE okl_api.g_exception_error;
605: END IF;
606: OPEN c_type_code;
607: FETCH c_type_code INTO l_dummy ;
608: CLOSE c_type_code;

Line 611: okl_api.set_message(p_app_name => g_app_name

607: FETCH c_type_code INTO l_dummy ;
608: CLOSE c_type_code;
609:
610: IF l_dummy = '?' THEN
611: okl_api.set_message(p_app_name => g_app_name
612: ,p_msg_name => g_invalid_value
613: ,p_token1 => g_col_name_token
614: ,p_token1_value => 'LRS_TYPE_CODE');
615: RAISE okl_api.g_exception_error;

Line 615: RAISE okl_api.g_exception_error;

611: okl_api.set_message(p_app_name => g_app_name
612: ,p_msg_name => g_invalid_value
613: ,p_token1 => g_col_name_token
614: ,p_token1_value => 'LRS_TYPE_CODE');
615: RAISE okl_api.g_exception_error;
616: END IF;
617: x_return_status := g_ret_sts_success;
618: EXCEPTION
619: WHEN okl_api.g_exception_error THEN

Line 619: WHEN okl_api.g_exception_error THEN

615: RAISE okl_api.g_exception_error;
616: END IF;
617: x_return_status := g_ret_sts_success;
618: EXCEPTION
619: WHEN okl_api.g_exception_error THEN
620: x_return_status := g_ret_sts_error;
621: WHEN okl_api.g_exception_unexpected_error THEN
622: x_return_status := g_ret_sts_unexp_error;
623: WHEN OTHERS THEN

Line 621: WHEN okl_api.g_exception_unexpected_error THEN

617: x_return_status := g_ret_sts_success;
618: EXCEPTION
619: WHEN okl_api.g_exception_error THEN
620: x_return_status := g_ret_sts_error;
621: WHEN okl_api.g_exception_unexpected_error THEN
622: x_return_status := g_ret_sts_unexp_error;
623: WHEN OTHERS THEN
624: okl_api.set_message(p_app_name => g_app_name
625: ,p_msg_name => g_db_error

Line 624: okl_api.set_message(p_app_name => g_app_name

620: x_return_status := g_ret_sts_error;
621: WHEN okl_api.g_exception_unexpected_error THEN
622: x_return_status := g_ret_sts_unexp_error;
623: WHEN OTHERS THEN
624: okl_api.set_message(p_app_name => g_app_name
625: ,p_msg_name => g_db_error
626: ,p_token1 => g_prog_name_token
627: ,p_token1_value => l_api_name
628: ,p_token2 => g_sqlcode_token

Line 652: okl_api.set_message(p_app_name => g_app_name

648:
649: BEGIN
650:
651: IF p_sts_code IS NULL THEN
652: okl_api.set_message(p_app_name => g_app_name
653: ,p_msg_name => g_required_value
654: ,p_token1 => g_col_name_token
655: ,p_token1_value => 'STS_CODE');
656: RAISE okl_api.g_exception_error;

Line 656: RAISE okl_api.g_exception_error;

652: okl_api.set_message(p_app_name => g_app_name
653: ,p_msg_name => g_required_value
654: ,p_token1 => g_col_name_token
655: ,p_token1_value => 'STS_CODE');
656: RAISE okl_api.g_exception_error;
657: END IF;
658: OPEN c_sts_code;
659: FETCH c_sts_code INTO l_dummy ;
660: CLOSE c_sts_code;

Line 663: okl_api.set_message(p_app_name => g_app_name

659: FETCH c_sts_code INTO l_dummy ;
660: CLOSE c_sts_code;
661:
662: IF l_dummy IS NULL THEN
663: okl_api.set_message(p_app_name => g_app_name
664: ,p_msg_name => g_invalid_value
665: ,p_token1 => g_col_name_token
666: ,p_token1_value => 'STS_CODE');
667: RAISE okl_api.g_exception_error;

Line 667: RAISE okl_api.g_exception_error;

663: okl_api.set_message(p_app_name => g_app_name
664: ,p_msg_name => g_invalid_value
665: ,p_token1 => g_col_name_token
666: ,p_token1_value => 'STS_CODE');
667: RAISE okl_api.g_exception_error;
668: END IF;
669: x_return_status := g_ret_sts_success;
670: EXCEPTION
671: WHEN okl_api.g_exception_error THEN

Line 671: WHEN okl_api.g_exception_error THEN

667: RAISE okl_api.g_exception_error;
668: END IF;
669: x_return_status := g_ret_sts_success;
670: EXCEPTION
671: WHEN okl_api.g_exception_error THEN
672: x_return_status := g_ret_sts_error;
673: WHEN okl_api.g_exception_unexpected_error THEN
674: x_return_status := g_ret_sts_unexp_error;
675: WHEN OTHERS THEN

Line 673: WHEN okl_api.g_exception_unexpected_error THEN

669: x_return_status := g_ret_sts_success;
670: EXCEPTION
671: WHEN okl_api.g_exception_error THEN
672: x_return_status := g_ret_sts_error;
673: WHEN okl_api.g_exception_unexpected_error THEN
674: x_return_status := g_ret_sts_unexp_error;
675: WHEN OTHERS THEN
676: okl_api.set_message(p_app_name => g_app_name
677: ,p_msg_name => g_db_error

Line 676: okl_api.set_message(p_app_name => g_app_name

672: x_return_status := g_ret_sts_error;
673: WHEN okl_api.g_exception_unexpected_error THEN
674: x_return_status := g_ret_sts_unexp_error;
675: WHEN OTHERS THEN
676: okl_api.set_message(p_app_name => g_app_name
677: ,p_msg_name => g_db_error
678: ,p_token1 => g_prog_name_token
679: ,p_token1_value => l_api_name
680: ,p_token2 => g_sqlcode_token

Line 699: IF (l_return_status = okl_api.g_ret_sts_error) THEN

695:
696: BEGIN
697: l_return_status := okl_util.check_org_id(p_org_id, 'N');
698:
699: IF (l_return_status = okl_api.g_ret_sts_error) THEN
700: okl_api.set_message(p_app_name => g_app_name
701: ,p_msg_name => g_invalid_value
702: ,p_token1 => g_col_name_token
703: ,p_token1_value => 'org_id');

Line 700: okl_api.set_message(p_app_name => g_app_name

696: BEGIN
697: l_return_status := okl_util.check_org_id(p_org_id, 'N');
698:
699: IF (l_return_status = okl_api.g_ret_sts_error) THEN
700: okl_api.set_message(p_app_name => g_app_name
701: ,p_msg_name => g_invalid_value
702: ,p_token1 => g_col_name_token
703: ,p_token1_value => 'org_id');
704: RAISE okl_api.g_exception_error;

Line 704: RAISE okl_api.g_exception_error;

700: okl_api.set_message(p_app_name => g_app_name
701: ,p_msg_name => g_invalid_value
702: ,p_token1 => g_col_name_token
703: ,p_token1_value => 'org_id');
704: RAISE okl_api.g_exception_error;
705: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
706:
707: RAISE okl_api.g_exception_unexpected_error;
708: END IF;

Line 705: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

701: ,p_msg_name => g_invalid_value
702: ,p_token1 => g_col_name_token
703: ,p_token1_value => 'org_id');
704: RAISE okl_api.g_exception_error;
705: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
706:
707: RAISE okl_api.g_exception_unexpected_error;
708: END IF;
709: x_return_status := g_ret_sts_success;

Line 707: RAISE okl_api.g_exception_unexpected_error;

703: ,p_token1_value => 'org_id');
704: RAISE okl_api.g_exception_error;
705: ELSIF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
706:
707: RAISE okl_api.g_exception_unexpected_error;
708: END IF;
709: x_return_status := g_ret_sts_success;
710: EXCEPTION
711: WHEN okl_api.g_exception_error THEN

Line 711: WHEN okl_api.g_exception_error THEN

707: RAISE okl_api.g_exception_unexpected_error;
708: END IF;
709: x_return_status := g_ret_sts_success;
710: EXCEPTION
711: WHEN okl_api.g_exception_error THEN
712: x_return_status := g_ret_sts_error;
713: WHEN okl_api.g_exception_unexpected_error THEN
714: x_return_status := g_ret_sts_unexp_error;
715: WHEN OTHERS THEN

Line 713: WHEN okl_api.g_exception_unexpected_error THEN

709: x_return_status := g_ret_sts_success;
710: EXCEPTION
711: WHEN okl_api.g_exception_error THEN
712: x_return_status := g_ret_sts_error;
713: WHEN okl_api.g_exception_unexpected_error THEN
714: x_return_status := g_ret_sts_unexp_error;
715: WHEN OTHERS THEN
716: okl_api.set_message(p_app_name => g_app_name
717: ,p_msg_name => g_db_error

Line 716: okl_api.set_message(p_app_name => g_app_name

712: x_return_status := g_ret_sts_error;
713: WHEN okl_api.g_exception_unexpected_error THEN
714: x_return_status := g_ret_sts_unexp_error;
715: WHEN OTHERS THEN
716: okl_api.set_message(p_app_name => g_app_name
717: ,p_msg_name => g_db_error
718: ,p_token1 => g_prog_name_token
719: ,p_token1_value => l_api_name
720: ,p_token2 => g_sqlcode_token

Line 744: okl_api.set_message(p_app_name => g_app_name

740:
741: BEGIN
742:
743: IF p_end_of_term_id IS NULL THEN
744: okl_api.set_message(p_app_name => g_app_name
745: ,p_msg_name => g_required_value
746: ,p_token1 => g_col_name_token
747: ,p_token1_value => 'END_OF_TERM_ID');
748: RAISE okl_api.g_exception_error;

Line 748: RAISE okl_api.g_exception_error;

744: okl_api.set_message(p_app_name => g_app_name
745: ,p_msg_name => g_required_value
746: ,p_token1 => g_col_name_token
747: ,p_token1_value => 'END_OF_TERM_ID');
748: RAISE okl_api.g_exception_error;
749: END IF;
750: OPEN c_end_of_term_id;
751: FETCH c_end_of_term_id INTO l_dummy ;
752: CLOSE c_end_of_term_id;

Line 755: okl_api.set_message(p_app_name => okl_api.g_app_name

751: FETCH c_end_of_term_id INTO l_dummy ;
752: CLOSE c_end_of_term_id;
753:
754: IF l_dummy = '?' THEN
755: okl_api.set_message(p_app_name => okl_api.g_app_name
756: ,p_msg_name => 'OKC_NO_PARENT_RECORD'
757: ,p_token1 => okl_api.g_col_name_token
758: ,p_token1_value => 'END_OF_TERM_ID'
759: ,p_token2 => okl_api.g_child_table_token

Line 757: ,p_token1 => okl_api.g_col_name_token

753:
754: IF l_dummy = '?' THEN
755: okl_api.set_message(p_app_name => okl_api.g_app_name
756: ,p_msg_name => 'OKC_NO_PARENT_RECORD'
757: ,p_token1 => okl_api.g_col_name_token
758: ,p_token1_value => 'END_OF_TERM_ID'
759: ,p_token2 => okl_api.g_child_table_token
760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
761: ,p_token3 => okl_api.g_parent_table_token

Line 759: ,p_token2 => okl_api.g_child_table_token

755: okl_api.set_message(p_app_name => okl_api.g_app_name
756: ,p_msg_name => 'OKC_NO_PARENT_RECORD'
757: ,p_token1 => okl_api.g_col_name_token
758: ,p_token1_value => 'END_OF_TERM_ID'
759: ,p_token2 => okl_api.g_child_table_token
760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
761: ,p_token3 => okl_api.g_parent_table_token
762: ,p_token3_value => 'OKL_FE_EO_TERMS_V');
763: RAISE okl_api.g_exception_error;

Line 761: ,p_token3 => okl_api.g_parent_table_token

757: ,p_token1 => okl_api.g_col_name_token
758: ,p_token1_value => 'END_OF_TERM_ID'
759: ,p_token2 => okl_api.g_child_table_token
760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
761: ,p_token3 => okl_api.g_parent_table_token
762: ,p_token3_value => 'OKL_FE_EO_TERMS_V');
763: RAISE okl_api.g_exception_error;
764: END IF;
765: x_return_status := g_ret_sts_success;

Line 763: RAISE okl_api.g_exception_error;

759: ,p_token2 => okl_api.g_child_table_token
760: ,p_token2_value => 'OKL_LS_RT_FCTR_SETS_B'
761: ,p_token3 => okl_api.g_parent_table_token
762: ,p_token3_value => 'OKL_FE_EO_TERMS_V');
763: RAISE okl_api.g_exception_error;
764: END IF;
765: x_return_status := g_ret_sts_success;
766: EXCEPTION
767: WHEN okl_api.g_exception_error THEN

Line 767: WHEN okl_api.g_exception_error THEN

763: RAISE okl_api.g_exception_error;
764: END IF;
765: x_return_status := g_ret_sts_success;
766: EXCEPTION
767: WHEN okl_api.g_exception_error THEN
768: x_return_status := g_ret_sts_error;
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := g_ret_sts_unexp_error;
771: WHEN OTHERS THEN

Line 769: WHEN okl_api.g_exception_unexpected_error THEN

765: x_return_status := g_ret_sts_success;
766: EXCEPTION
767: WHEN okl_api.g_exception_error THEN
768: x_return_status := g_ret_sts_error;
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := g_ret_sts_unexp_error;
771: WHEN OTHERS THEN
772: okl_api.set_message(p_app_name => g_app_name
773: ,p_msg_name => g_db_error

Line 772: okl_api.set_message(p_app_name => g_app_name

768: x_return_status := g_ret_sts_error;
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := g_ret_sts_unexp_error;
771: WHEN OTHERS THEN
772: okl_api.set_message(p_app_name => g_app_name
773: ,p_msg_name => g_db_error
774: ,p_token1 => g_prog_name_token
775: ,p_token1_value => l_api_name
776: ,p_token2 => g_sqlcode_token

Line 794: okl_api.set_message(p_app_name => g_app_name

790:
791: BEGIN
792:
793: IF p_currency_code IS NULL THEN
794: okl_api.set_message(p_app_name => g_app_name
795: ,p_msg_name => g_required_value
796: ,p_token1 => g_col_name_token
797: ,p_token1_value => 'currency_code');
798: RAISE okl_api.g_exception_error;

Line 798: RAISE okl_api.g_exception_error;

794: okl_api.set_message(p_app_name => g_app_name
795: ,p_msg_name => g_required_value
796: ,p_token1 => g_col_name_token
797: ,p_token1_value => 'currency_code');
798: RAISE okl_api.g_exception_error;
799: END IF;
800: x_return_status := g_ret_sts_success;
801: EXCEPTION
802: WHEN okl_api.g_exception_error THEN

Line 802: WHEN okl_api.g_exception_error THEN

798: RAISE okl_api.g_exception_error;
799: END IF;
800: x_return_status := g_ret_sts_success;
801: EXCEPTION
802: WHEN okl_api.g_exception_error THEN
803: x_return_status := g_ret_sts_error;
804: WHEN okl_api.g_exception_unexpected_error THEN
805: x_return_status := g_ret_sts_unexp_error;
806: WHEN OTHERS THEN

Line 804: WHEN okl_api.g_exception_unexpected_error THEN

800: x_return_status := g_ret_sts_success;
801: EXCEPTION
802: WHEN okl_api.g_exception_error THEN
803: x_return_status := g_ret_sts_error;
804: WHEN okl_api.g_exception_unexpected_error THEN
805: x_return_status := g_ret_sts_unexp_error;
806: WHEN OTHERS THEN
807: okl_api.set_message(p_app_name => g_app_name
808: ,p_msg_name => g_db_error

Line 807: okl_api.set_message(p_app_name => g_app_name

803: x_return_status := g_ret_sts_error;
804: WHEN okl_api.g_exception_unexpected_error THEN
805: x_return_status := g_ret_sts_unexp_error;
806: WHEN OTHERS THEN
807: okl_api.set_message(p_app_name => g_app_name
808: ,p_msg_name => g_db_error
809: ,p_token1 => g_prog_name_token
810: ,p_token1_value => l_api_name
811: ,p_token2 => g_sqlcode_token

Line 833: RAISE okl_api.g_exception_error;

829:
830: validate_id(x_return_status, p_lrtv_rec.id);
831:
832: IF x_return_status = g_ret_sts_error THEN
833: RAISE okl_api.g_exception_error;
834: ELSIF x_return_status = g_ret_sts_unexp_error THEN
835: RAISE okl_api.g_exception_unexpected_error;
836: END IF;
837:

Line 835: RAISE okl_api.g_exception_unexpected_error;

831:
832: IF x_return_status = g_ret_sts_error THEN
833: RAISE okl_api.g_exception_error;
834: ELSIF x_return_status = g_ret_sts_unexp_error THEN
835: RAISE okl_api.g_exception_unexpected_error;
836: END IF;
837:
838: --
839:

Line 844: RAISE okl_api.g_exception_error;

840: validate_object_version_number(x_return_status
841: ,p_lrtv_rec.object_version_number);
842:
843: IF x_return_status = g_ret_sts_error THEN
844: RAISE okl_api.g_exception_error;
845: ELSIF x_return_status = g_ret_sts_unexp_error THEN
846: RAISE okl_api.g_exception_unexpected_error;
847: END IF;
848:

Line 846: RAISE okl_api.g_exception_unexpected_error;

842:
843: IF x_return_status = g_ret_sts_error THEN
844: RAISE okl_api.g_exception_error;
845: ELSIF x_return_status = g_ret_sts_unexp_error THEN
846: RAISE okl_api.g_exception_unexpected_error;
847: END IF;
848:
849: validate_frq_code(x_return_status, p_lrtv_rec.frq_code);
850:

Line 852: RAISE okl_api.g_exception_error;

848:
849: validate_frq_code(x_return_status, p_lrtv_rec.frq_code);
850:
851: IF x_return_status = g_ret_sts_error THEN
852: RAISE okl_api.g_exception_error;
853: ELSIF x_return_status = g_ret_sts_unexp_error THEN
854: RAISE okl_api.g_exception_unexpected_error;
855: END IF;
856:

Line 854: RAISE okl_api.g_exception_unexpected_error;

850:
851: IF x_return_status = g_ret_sts_error THEN
852: RAISE okl_api.g_exception_error;
853: ELSIF x_return_status = g_ret_sts_unexp_error THEN
854: RAISE okl_api.g_exception_unexpected_error;
855: END IF;
856:
857: validate_name(x_return_status, p_lrtv_rec.name);
858:

Line 860: RAISE okl_api.g_exception_error;

856:
857: validate_name(x_return_status, p_lrtv_rec.name);
858:
859: IF x_return_status = g_ret_sts_error THEN
860: RAISE okl_api.g_exception_error;
861: ELSIF x_return_status = g_ret_sts_unexp_error THEN
862: RAISE okl_api.g_exception_unexpected_error;
863: END IF;
864:

Line 862: RAISE okl_api.g_exception_unexpected_error;

858:
859: IF x_return_status = g_ret_sts_error THEN
860: RAISE okl_api.g_exception_error;
861: ELSIF x_return_status = g_ret_sts_unexp_error THEN
862: RAISE okl_api.g_exception_unexpected_error;
863: END IF;
864:
865: validate_sts_code(x_return_status, p_lrtv_rec.sts_code);
866:

Line 868: RAISE okl_api.g_exception_error;

864:
865: validate_sts_code(x_return_status, p_lrtv_rec.sts_code);
866:
867: IF x_return_status = g_ret_sts_error THEN
868: RAISE okl_api.g_exception_error;
869: ELSIF x_return_status = g_ret_sts_unexp_error THEN
870: RAISE okl_api.g_exception_unexpected_error;
871: END IF;
872: validate_lrs_type_code(x_return_status, p_lrtv_rec.lrs_type_code);

Line 870: RAISE okl_api.g_exception_unexpected_error;

866:
867: IF x_return_status = g_ret_sts_error THEN
868: RAISE okl_api.g_exception_error;
869: ELSIF x_return_status = g_ret_sts_unexp_error THEN
870: RAISE okl_api.g_exception_unexpected_error;
871: END IF;
872: validate_lrs_type_code(x_return_status, p_lrtv_rec.lrs_type_code);
873:
874: IF x_return_status = g_ret_sts_error THEN

Line 875: RAISE okl_api.g_exception_error;

871: END IF;
872: validate_lrs_type_code(x_return_status, p_lrtv_rec.lrs_type_code);
873:
874: IF x_return_status = g_ret_sts_error THEN
875: RAISE okl_api.g_exception_error;
876: ELSIF x_return_status = g_ret_sts_unexp_error THEN
877: RAISE okl_api.g_exception_unexpected_error;
878: END IF;
879:

Line 877: RAISE okl_api.g_exception_unexpected_error;

873:
874: IF x_return_status = g_ret_sts_error THEN
875: RAISE okl_api.g_exception_error;
876: ELSIF x_return_status = g_ret_sts_unexp_error THEN
877: RAISE okl_api.g_exception_unexpected_error;
878: END IF;
879:
880: validate_org_id(x_return_status, p_lrtv_rec.org_id);
881:

Line 883: RAISE okl_api.g_exception_error;

879:
880: validate_org_id(x_return_status, p_lrtv_rec.org_id);
881:
882: IF x_return_status = g_ret_sts_error THEN
883: RAISE okl_api.g_exception_error;
884: ELSIF x_return_status = g_ret_sts_unexp_error THEN
885: RAISE okl_api.g_exception_unexpected_error;
886: END IF;
887: validate_end_of_term_id(x_return_status, p_lrtv_rec.end_of_term_id);

Line 885: RAISE okl_api.g_exception_unexpected_error;

881:
882: IF x_return_status = g_ret_sts_error THEN
883: RAISE okl_api.g_exception_error;
884: ELSIF x_return_status = g_ret_sts_unexp_error THEN
885: RAISE okl_api.g_exception_unexpected_error;
886: END IF;
887: validate_end_of_term_id(x_return_status, p_lrtv_rec.end_of_term_id);
888:
889: IF x_return_status = g_ret_sts_error THEN

Line 890: RAISE okl_api.g_exception_error;

886: END IF;
887: validate_end_of_term_id(x_return_status, p_lrtv_rec.end_of_term_id);
888:
889: IF x_return_status = g_ret_sts_error THEN
890: RAISE okl_api.g_exception_error;
891: ELSIF x_return_status = g_ret_sts_unexp_error THEN
892: RAISE okl_api.g_exception_unexpected_error;
893: END IF;
894:

Line 892: RAISE okl_api.g_exception_unexpected_error;

888:
889: IF x_return_status = g_ret_sts_error THEN
890: RAISE okl_api.g_exception_error;
891: ELSIF x_return_status = g_ret_sts_unexp_error THEN
892: RAISE okl_api.g_exception_unexpected_error;
893: END IF;
894:
895: validate_currency_code(x_return_status, p_lrtv_rec.currency_code);
896:

Line 898: RAISE okl_api.g_exception_error;

894:
895: validate_currency_code(x_return_status, p_lrtv_rec.currency_code);
896:
897: IF x_return_status = g_ret_sts_error THEN
898: RAISE okl_api.g_exception_error;
899: ELSIF x_return_status = g_ret_sts_unexp_error THEN
900: RAISE okl_api.g_exception_unexpected_error;
901: END IF;
902:

Line 900: RAISE okl_api.g_exception_unexpected_error;

896:
897: IF x_return_status = g_ret_sts_error THEN
898: RAISE okl_api.g_exception_error;
899: ELSIF x_return_status = g_ret_sts_unexp_error THEN
900: RAISE okl_api.g_exception_unexpected_error;
901: END IF;
902:
903: RETURN g_ret_sts_success;
904: EXCEPTION

Line 905: WHEN okl_api.g_exception_error THEN

901: END IF;
902:
903: RETURN g_ret_sts_success;
904: EXCEPTION
905: WHEN okl_api.g_exception_error THEN
906: RETURN g_ret_sts_error;
907: WHEN okl_api.g_exception_unexpected_error THEN
908: RETURN g_ret_sts_unexp_error;
909: WHEN OTHERS THEN

Line 907: WHEN okl_api.g_exception_unexpected_error THEN

903: RETURN g_ret_sts_success;
904: EXCEPTION
905: WHEN okl_api.g_exception_error THEN
906: RETURN g_ret_sts_error;
907: WHEN okl_api.g_exception_unexpected_error THEN
908: RETURN g_ret_sts_unexp_error;
909: WHEN OTHERS THEN
910: okl_api.set_message(p_app_name => g_app_name
911: ,p_msg_name => g_db_error

Line 910: okl_api.set_message(p_app_name => g_app_name

906: RETURN g_ret_sts_error;
907: WHEN okl_api.g_exception_unexpected_error THEN
908: RETURN g_ret_sts_unexp_error;
909: WHEN OTHERS THEN
910: okl_api.set_message(p_app_name => g_app_name
911: ,p_msg_name => g_db_error
912: ,p_token1 => g_prog_name_token
913: ,p_token1_value => l_api_name
914: ,p_token2 => g_sqlcode_token

Line 931: WHEN okl_api.g_exception_error THEN

927:
928: BEGIN
929: RETURN g_ret_sts_success;
930: EXCEPTION
931: WHEN okl_api.g_exception_error THEN
932: RETURN g_ret_sts_error;
933: WHEN okl_api.g_exception_unexpected_error THEN
934: RETURN g_ret_sts_unexp_error;
935: WHEN OTHERS THEN

Line 933: WHEN okl_api.g_exception_unexpected_error THEN

929: RETURN g_ret_sts_success;
930: EXCEPTION
931: WHEN okl_api.g_exception_error THEN
932: RETURN g_ret_sts_error;
933: WHEN okl_api.g_exception_unexpected_error THEN
934: RETURN g_ret_sts_unexp_error;
935: WHEN OTHERS THEN
936: okl_api.set_message(p_app_name => g_app_name
937: ,p_msg_name => g_db_error

Line 936: okl_api.set_message(p_app_name => g_app_name

932: RETURN g_ret_sts_error;
933: WHEN okl_api.g_exception_unexpected_error THEN
934: RETURN g_ret_sts_unexp_error;
935: WHEN OTHERS THEN
936: okl_api.set_message(p_app_name => g_app_name
937: ,p_msg_name => g_db_error
938: ,p_token1 => g_prog_name_token
939: ,p_token1_value => l_api_name
940: ,p_token2 => g_sqlcode_token

Line 1029: RAISE okl_api.g_exception_unexpected_error;

1025: BEGIN
1026: l_return_status := validate_attributes(p_lrtv_rec);
1027:
1028: IF (l_return_status = g_ret_sts_unexp_error) THEN
1029: RAISE okl_api.g_exception_unexpected_error;
1030: ELSIF (l_return_status = g_ret_sts_error) THEN
1031: RAISE okl_api.g_exception_error;
1032: END IF;
1033: l_return_status := validate_record(p_lrtv_rec);

Line 1031: RAISE okl_api.g_exception_error;

1027:
1028: IF (l_return_status = g_ret_sts_unexp_error) THEN
1029: RAISE okl_api.g_exception_unexpected_error;
1030: ELSIF (l_return_status = g_ret_sts_error) THEN
1031: RAISE okl_api.g_exception_error;
1032: END IF;
1033: l_return_status := validate_record(p_lrtv_rec);
1034:
1035: IF (l_return_status = g_ret_sts_unexp_error) THEN

Line 1036: RAISE okl_api.g_exception_unexpected_error;

1032: END IF;
1033: l_return_status := validate_record(p_lrtv_rec);
1034:
1035: IF (l_return_status = g_ret_sts_unexp_error) THEN
1036: RAISE okl_api.g_exception_unexpected_error;
1037: ELSIF (l_return_status = g_ret_sts_error) THEN
1038: RAISE okl_api.g_exception_error;
1039: END IF;
1040:

Line 1038: RAISE okl_api.g_exception_error;

1034:
1035: IF (l_return_status = g_ret_sts_unexp_error) THEN
1036: RAISE okl_api.g_exception_unexpected_error;
1037: ELSIF (l_return_status = g_ret_sts_error) THEN
1038: RAISE okl_api.g_exception_error;
1039: END IF;
1040:
1041: EXCEPTION
1042: WHEN okl_api.g_exception_error THEN

Line 1042: WHEN okl_api.g_exception_error THEN

1038: RAISE okl_api.g_exception_error;
1039: END IF;
1040:
1041: EXCEPTION
1042: WHEN okl_api.g_exception_error THEN
1043: x_return_status := g_ret_sts_error;
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := g_ret_sts_unexp_error;
1046: WHEN OTHERS THEN

Line 1044: WHEN okl_api.g_exception_unexpected_error THEN

1040:
1041: EXCEPTION
1042: WHEN okl_api.g_exception_error THEN
1043: x_return_status := g_ret_sts_error;
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := g_ret_sts_unexp_error;
1046: WHEN OTHERS THEN
1047: okl_api.set_message(p_app_name => g_app_name
1048: ,p_msg_name => g_db_error

Line 1047: okl_api.set_message(p_app_name => g_app_name

1043: x_return_status := g_ret_sts_error;
1044: WHEN okl_api.g_exception_unexpected_error THEN
1045: x_return_status := g_ret_sts_unexp_error;
1046: WHEN OTHERS THEN
1047: okl_api.set_message(p_app_name => g_app_name
1048: ,p_msg_name => g_db_error
1049: ,p_token1 => g_prog_name_token
1050: ,p_token1_value => l_api_name
1051: ,p_token2 => g_sqlcode_token

Line 1086: RAISE okl_api.g_exception_error;

1082: ,x_msg_count => x_msg_count
1083: ,x_msg_data => x_msg_data
1084: ,p_lrtv_rec => p_lrtv_tbl(i));
1085: IF l_return_status = g_ret_sts_error THEN
1086: RAISE okl_api.g_exception_error;
1087: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: END IF;
1090: EXIT WHEN i = p_lrtv_tbl.LAST;

Line 1088: RAISE okl_api.g_exception_unexpected_error;

1084: ,p_lrtv_rec => p_lrtv_tbl(i));
1085: IF l_return_status = g_ret_sts_error THEN
1086: RAISE okl_api.g_exception_error;
1087: ELSIF l_return_status = g_ret_sts_unexp_error THEN
1088: RAISE okl_api.g_exception_unexpected_error;
1089: END IF;
1090: EXIT WHEN i = p_lrtv_tbl.LAST;
1091: i := p_lrtv_tbl.next(i);
1092: END IF;

Line 1098: WHEN okl_api.g_exception_error THEN

1094:
1095: END IF;
1096: x_return_status := l_return_status;
1097: EXCEPTION
1098: WHEN okl_api.g_exception_error THEN
1099: x_return_status := g_ret_sts_error;
1100: WHEN okl_api.g_exception_unexpected_error THEN
1101: x_return_status := g_ret_sts_unexp_error;
1102: WHEN OTHERS THEN

Line 1100: WHEN okl_api.g_exception_unexpected_error THEN

1096: x_return_status := l_return_status;
1097: EXCEPTION
1098: WHEN okl_api.g_exception_error THEN
1099: x_return_status := g_ret_sts_error;
1100: WHEN okl_api.g_exception_unexpected_error THEN
1101: x_return_status := g_ret_sts_unexp_error;
1102: WHEN OTHERS THEN
1103: okl_api.set_message(p_app_name => g_app_name
1104: ,p_msg_name => g_db_error

Line 1103: okl_api.set_message(p_app_name => g_app_name

1099: x_return_status := g_ret_sts_error;
1100: WHEN okl_api.g_exception_unexpected_error THEN
1101: x_return_status := g_ret_sts_unexp_error;
1102: WHEN OTHERS THEN
1103: okl_api.set_message(p_app_name => g_app_name
1104: ,p_msg_name => g_db_error
1105: ,p_token1 => g_prog_name_token
1106: ,p_token1_value => l_api_name
1107: ,p_token2 => g_sqlcode_token

Line 1202: WHEN okl_api.g_exception_error THEN

1198: ,l_lrt_rec.end_of_term_id
1199: ,l_lrt_rec.orig_rate_set_id);
1200: x_return_status := g_ret_sts_success;
1201: EXCEPTION
1202: WHEN okl_api.g_exception_error THEN
1203: x_return_status := g_ret_sts_error;
1204: WHEN okl_api.g_exception_unexpected_error THEN
1205: x_return_status := g_ret_sts_unexp_error;
1206: WHEN OTHERS THEN

Line 1204: WHEN okl_api.g_exception_unexpected_error THEN

1200: x_return_status := g_ret_sts_success;
1201: EXCEPTION
1202: WHEN okl_api.g_exception_error THEN
1203: x_return_status := g_ret_sts_error;
1204: WHEN okl_api.g_exception_unexpected_error THEN
1205: x_return_status := g_ret_sts_unexp_error;
1206: WHEN OTHERS THEN
1207: okl_api.set_message(p_app_name => g_app_name
1208: ,p_msg_name => g_db_error

Line 1207: okl_api.set_message(p_app_name => g_app_name

1203: x_return_status := g_ret_sts_error;
1204: WHEN okl_api.g_exception_unexpected_error THEN
1205: x_return_status := g_ret_sts_unexp_error;
1206: WHEN OTHERS THEN
1207: okl_api.set_message(p_app_name => g_app_name
1208: ,p_msg_name => g_db_error
1209: ,p_token1 => g_prog_name_token
1210: ,p_token1_value => l_api_name
1211: ,p_token2 => g_sqlcode_token

Line 1272: okl_api.set_message(p_app_name => g_app_name

1268:
1269: END LOOP;
1270:
1271: IF l_miss_flag = 'Y' THEN
1272: okl_api.set_message(p_app_name => g_app_name
1273: ,p_msg_name => 'OKL_LANG_NOT_INSTALLED'
1274: ,p_token1 => 'LANG_CODE'
1275: ,p_token1_value => userenv('LANG'));
1276: END IF;

Line 1279: WHEN okl_api.g_exception_error THEN

1275: ,p_token1_value => userenv('LANG'));
1276: END IF;
1277: x_return_status := g_ret_sts_success;
1278: EXCEPTION
1279: WHEN okl_api.g_exception_error THEN
1280: x_return_status := g_ret_sts_error;
1281: WHEN okl_api.g_exception_unexpected_error THEN
1282: x_return_status := g_ret_sts_unexp_error;
1283: WHEN OTHERS THEN

Line 1281: WHEN okl_api.g_exception_unexpected_error THEN

1277: x_return_status := g_ret_sts_success;
1278: EXCEPTION
1279: WHEN okl_api.g_exception_error THEN
1280: x_return_status := g_ret_sts_error;
1281: WHEN okl_api.g_exception_unexpected_error THEN
1282: x_return_status := g_ret_sts_unexp_error;
1283: WHEN OTHERS THEN
1284: okl_api.set_message(p_app_name => g_app_name
1285: ,p_msg_name => g_db_error

Line 1284: okl_api.set_message(p_app_name => g_app_name

1280: x_return_status := g_ret_sts_error;
1281: WHEN okl_api.g_exception_unexpected_error THEN
1282: x_return_status := g_ret_sts_unexp_error;
1283: WHEN OTHERS THEN
1284: okl_api.set_message(p_app_name => g_app_name
1285: ,p_msg_name => g_db_error
1286: ,p_token1 => g_prog_name_token
1287: ,p_token1_value => l_api_name
1288: ,p_token2 => g_sqlcode_token

Line 1332: RAISE okl_api.g_exception_unexpected_error;

1328: l_lrtv_rec.arrears_yn := 'NA';
1329: l_return_status := validate_attributes(l_lrtv_rec);
1330:
1331: IF (l_return_status = g_ret_sts_unexp_error) THEN
1332: RAISE okl_api.g_exception_unexpected_error;
1333: ELSIF (l_return_status = g_ret_sts_error) THEN
1334: RAISE okl_api.g_exception_error;
1335: END IF;
1336:

Line 1334: RAISE okl_api.g_exception_error;

1330:
1331: IF (l_return_status = g_ret_sts_unexp_error) THEN
1332: RAISE okl_api.g_exception_unexpected_error;
1333: ELSIF (l_return_status = g_ret_sts_error) THEN
1334: RAISE okl_api.g_exception_error;
1335: END IF;
1336:
1337: l_return_status := validate_record(l_lrtv_rec);
1338:

Line 1340: RAISE okl_api.g_exception_unexpected_error;

1336:
1337: l_return_status := validate_record(l_lrtv_rec);
1338:
1339: IF (l_return_status = g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344: migrate(l_lrtv_rec, l_lrt_rec);

Line 1342: RAISE okl_api.g_exception_error;

1338:
1339: IF (l_return_status = g_ret_sts_unexp_error) THEN
1340: RAISE okl_api.g_exception_unexpected_error;
1341: ELSIF (l_return_status = g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344: migrate(l_lrtv_rec, l_lrt_rec);
1345: migrate(l_lrtv_rec, l_lrttl_rec);
1346: insert_row(x_return_status => l_return_status

Line 1350: RAISE okl_api.g_exception_unexpected_error;

1346: insert_row(x_return_status => l_return_status
1347: ,p_lrt_rec => l_lrt_rec);
1348:
1349: IF (l_return_status = g_ret_sts_unexp_error) THEN
1350: RAISE okl_api.g_exception_unexpected_error;
1351: ELSIF (l_return_status = g_ret_sts_error) THEN
1352: RAISE okl_api.g_exception_error;
1353: END IF;
1354: insert_row(x_return_status => l_return_status

Line 1352: RAISE okl_api.g_exception_error;

1348:
1349: IF (l_return_status = g_ret_sts_unexp_error) THEN
1350: RAISE okl_api.g_exception_unexpected_error;
1351: ELSIF (l_return_status = g_ret_sts_error) THEN
1352: RAISE okl_api.g_exception_error;
1353: END IF;
1354: insert_row(x_return_status => l_return_status
1355: ,p_lrttl_rec => l_lrttl_rec);
1356:

Line 1358: RAISE okl_api.g_exception_unexpected_error;

1354: insert_row(x_return_status => l_return_status
1355: ,p_lrttl_rec => l_lrttl_rec);
1356:
1357: IF (l_return_status = g_ret_sts_unexp_error) THEN
1358: RAISE okl_api.g_exception_unexpected_error;
1359: ELSIF (l_return_status = g_ret_sts_error) THEN
1360: RAISE okl_api.g_exception_error;
1361: END IF;
1362: x_lrtv_rec := l_lrtv_rec;

Line 1360: RAISE okl_api.g_exception_error;

1356:
1357: IF (l_return_status = g_ret_sts_unexp_error) THEN
1358: RAISE okl_api.g_exception_unexpected_error;
1359: ELSIF (l_return_status = g_ret_sts_error) THEN
1360: RAISE okl_api.g_exception_error;
1361: END IF;
1362: x_lrtv_rec := l_lrtv_rec;
1363: x_return_status := l_return_status;
1364: EXCEPTION

Line 1365: WHEN okl_api.g_exception_error THEN

1361: END IF;
1362: x_lrtv_rec := l_lrtv_rec;
1363: x_return_status := l_return_status;
1364: EXCEPTION
1365: WHEN okl_api.g_exception_error THEN
1366: x_return_status := g_ret_sts_error;
1367: WHEN okl_api.g_exception_unexpected_error THEN
1368: x_return_status := g_ret_sts_unexp_error;
1369: WHEN OTHERS THEN

Line 1367: WHEN okl_api.g_exception_unexpected_error THEN

1363: x_return_status := l_return_status;
1364: EXCEPTION
1365: WHEN okl_api.g_exception_error THEN
1366: x_return_status := g_ret_sts_error;
1367: WHEN okl_api.g_exception_unexpected_error THEN
1368: x_return_status := g_ret_sts_unexp_error;
1369: WHEN OTHERS THEN
1370: okl_api.set_message(p_app_name => g_app_name
1371: ,p_msg_name => g_db_error

Line 1370: okl_api.set_message(p_app_name => g_app_name

1366: x_return_status := g_ret_sts_error;
1367: WHEN okl_api.g_exception_unexpected_error THEN
1368: x_return_status := g_ret_sts_unexp_error;
1369: WHEN OTHERS THEN
1370: okl_api.set_message(p_app_name => g_app_name
1371: ,p_msg_name => g_db_error
1372: ,p_token1 => g_prog_name_token
1373: ,p_token1_value => l_api_name
1374: ,p_token2 => g_sqlcode_token

Line 1411: RAISE okl_api.g_exception_unexpected_error;

1407: ,x_msg_data => x_msg_data
1408: ,p_lrtv_rec => p_lrtv_tbl(i)
1409: ,x_lrtv_rec => x_lrtv_tbl(i));
1410: IF l_return_status = g_ret_sts_unexp_error THEN
1411: RAISE okl_api.g_exception_unexpected_error;
1412: ELSIF l_return_status = g_ret_sts_error THEN
1413: RAISE okl_api.g_exception_error;
1414: END IF;
1415: EXIT WHEN(i = p_lrtv_tbl.LAST);

Line 1413: RAISE okl_api.g_exception_error;

1409: ,x_lrtv_rec => x_lrtv_tbl(i));
1410: IF l_return_status = g_ret_sts_unexp_error THEN
1411: RAISE okl_api.g_exception_unexpected_error;
1412: ELSIF l_return_status = g_ret_sts_error THEN
1413: RAISE okl_api.g_exception_error;
1414: END IF;
1415: EXIT WHEN(i = p_lrtv_tbl.LAST);
1416: i := p_lrtv_tbl.next(i);
1417: END IF;

Line 1423: WHEN okl_api.g_exception_error THEN

1419:
1420: END IF;
1421: x_return_status := g_ret_sts_success;
1422: EXCEPTION
1423: WHEN okl_api.g_exception_error THEN
1424: x_return_status := g_ret_sts_error;
1425: WHEN okl_api.g_exception_unexpected_error THEN
1426: x_return_status := g_ret_sts_unexp_error;
1427: WHEN OTHERS THEN

Line 1425: WHEN okl_api.g_exception_unexpected_error THEN

1421: x_return_status := g_ret_sts_success;
1422: EXCEPTION
1423: WHEN okl_api.g_exception_error THEN
1424: x_return_status := g_ret_sts_error;
1425: WHEN okl_api.g_exception_unexpected_error THEN
1426: x_return_status := g_ret_sts_unexp_error;
1427: WHEN OTHERS THEN
1428: okl_api.set_message(p_app_name => g_app_name
1429: ,p_msg_name => g_db_error

Line 1428: okl_api.set_message(p_app_name => g_app_name

1424: x_return_status := g_ret_sts_error;
1425: WHEN okl_api.g_exception_unexpected_error THEN
1426: x_return_status := g_ret_sts_unexp_error;
1427: WHEN OTHERS THEN
1428: okl_api.set_message(p_app_name => g_app_name
1429: ,p_msg_name => g_db_error
1430: ,p_token1 => g_prog_name_token
1431: ,p_token1_value => l_api_name
1432: ,p_token2 => g_sqlcode_token

Line 1493: RAISE okl_api.g_exception_error;

1489: END IF;
1490:
1491: IF (lc_row_notfound) THEN
1492: okc_api.set_message(g_fnd_app, g_form_record_deleted);
1493: RAISE okl_api.g_exception_error;
1494: ELSIF lc_object_version_number > p_lrt_rec.object_version_number THEN
1495: okc_api.set_message(g_fnd_app, g_form_record_changed);
1496: RAISE okl_api.g_exception_error;
1497: ELSIF lc_object_version_number <> p_lrt_rec.object_version_number THEN

Line 1496: RAISE okl_api.g_exception_error;

1492: okc_api.set_message(g_fnd_app, g_form_record_deleted);
1493: RAISE okl_api.g_exception_error;
1494: ELSIF lc_object_version_number > p_lrt_rec.object_version_number THEN
1495: okc_api.set_message(g_fnd_app, g_form_record_changed);
1496: RAISE okl_api.g_exception_error;
1497: ELSIF lc_object_version_number <> p_lrt_rec.object_version_number THEN
1498: okc_api.set_message(g_fnd_app, g_form_record_changed);
1499: RAISE okl_api.g_exception_error;
1500: ELSIF lc_object_version_number = - 1 THEN

Line 1499: RAISE okl_api.g_exception_error;

1495: okc_api.set_message(g_fnd_app, g_form_record_changed);
1496: RAISE okl_api.g_exception_error;
1497: ELSIF lc_object_version_number <> p_lrt_rec.object_version_number THEN
1498: okc_api.set_message(g_fnd_app, g_form_record_changed);
1499: RAISE okl_api.g_exception_error;
1500: ELSIF lc_object_version_number = - 1 THEN
1501: okc_api.set_message(g_app_name, g_record_logically_deleted);
1502: RAISE okl_api.g_exception_error;
1503: END IF;

Line 1502: RAISE okl_api.g_exception_error;

1498: okc_api.set_message(g_fnd_app, g_form_record_changed);
1499: RAISE okl_api.g_exception_error;
1500: ELSIF lc_object_version_number = - 1 THEN
1501: okc_api.set_message(g_app_name, g_record_logically_deleted);
1502: RAISE okl_api.g_exception_error;
1503: END IF;
1504: x_return_status := l_return_status;
1505: EXCEPTION
1506: WHEN okl_api.g_exception_error THEN

Line 1506: WHEN okl_api.g_exception_error THEN

1502: RAISE okl_api.g_exception_error;
1503: END IF;
1504: x_return_status := l_return_status;
1505: EXCEPTION
1506: WHEN okl_api.g_exception_error THEN
1507: x_return_status := g_ret_sts_error;
1508: WHEN okl_api.g_exception_unexpected_error THEN
1509: x_return_status := g_ret_sts_unexp_error;
1510: WHEN OTHERS THEN

Line 1508: WHEN okl_api.g_exception_unexpected_error THEN

1504: x_return_status := l_return_status;
1505: EXCEPTION
1506: WHEN okl_api.g_exception_error THEN
1507: x_return_status := g_ret_sts_error;
1508: WHEN okl_api.g_exception_unexpected_error THEN
1509: x_return_status := g_ret_sts_unexp_error;
1510: WHEN OTHERS THEN
1511: okl_api.set_message(p_app_name => g_app_name
1512: ,p_msg_name => g_db_error

Line 1511: okl_api.set_message(p_app_name => g_app_name

1507: x_return_status := g_ret_sts_error;
1508: WHEN okl_api.g_exception_unexpected_error THEN
1509: x_return_status := g_ret_sts_unexp_error;
1510: WHEN OTHERS THEN
1511: okl_api.set_message(p_app_name => g_app_name
1512: ,p_msg_name => g_db_error
1513: ,p_token1 => g_prog_name_token
1514: ,p_token1_value => l_api_name
1515: ,p_token2 => g_sqlcode_token

Line 1556: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);

1552:
1553: IF (lock_csr%ISOPEN) THEN
1554: CLOSE lock_csr;
1555: END IF;
1556: okl_api.set_message(g_fnd_app, g_form_unable_to_reserve_rec);
1557: RAISE app_exceptions.record_lock_exception;
1558: END;
1559:
1560: IF l_row_notfound THEN

Line 1561: okl_api.set_message(g_fnd_app, g_form_record_deleted);

1557: RAISE app_exceptions.record_lock_exception;
1558: END;
1559:
1560: IF l_row_notfound THEN
1561: okl_api.set_message(g_fnd_app, g_form_record_deleted);
1562: RAISE okl_api.g_exception_error;
1563: END IF;
1564: x_return_status := l_return_status;
1565: EXCEPTION

Line 1562: RAISE okl_api.g_exception_error;

1558: END;
1559:
1560: IF l_row_notfound THEN
1561: okl_api.set_message(g_fnd_app, g_form_record_deleted);
1562: RAISE okl_api.g_exception_error;
1563: END IF;
1564: x_return_status := l_return_status;
1565: EXCEPTION
1566: WHEN okl_api.g_exception_error THEN

Line 1566: WHEN okl_api.g_exception_error THEN

1562: RAISE okl_api.g_exception_error;
1563: END IF;
1564: x_return_status := l_return_status;
1565: EXCEPTION
1566: WHEN okl_api.g_exception_error THEN
1567: x_return_status := g_ret_sts_error;
1568: WHEN okl_api.g_exception_unexpected_error THEN
1569: x_return_status := g_ret_sts_unexp_error;
1570: WHEN OTHERS THEN

Line 1568: WHEN okl_api.g_exception_unexpected_error THEN

1564: x_return_status := l_return_status;
1565: EXCEPTION
1566: WHEN okl_api.g_exception_error THEN
1567: x_return_status := g_ret_sts_error;
1568: WHEN okl_api.g_exception_unexpected_error THEN
1569: x_return_status := g_ret_sts_unexp_error;
1570: WHEN OTHERS THEN
1571: okl_api.set_message(p_app_name => g_app_name
1572: ,p_msg_name => g_db_error

Line 1571: okl_api.set_message(p_app_name => g_app_name

1567: x_return_status := g_ret_sts_error;
1568: WHEN okl_api.g_exception_unexpected_error THEN
1569: x_return_status := g_ret_sts_unexp_error;
1570: WHEN OTHERS THEN
1571: okl_api.set_message(p_app_name => g_app_name
1572: ,p_msg_name => g_db_error
1573: ,p_token1 => g_prog_name_token
1574: ,p_token1_value => l_api_name
1575: ,p_token2 => g_sqlcode_token

Line 1604: RAISE okl_api.g_exception_unexpected_error;

1600: lock_row(x_return_status => l_return_status
1601: ,p_lrt_rec => l_lrt_rec);
1602:
1603: IF (l_return_status = g_ret_sts_unexp_error) THEN
1604: RAISE okl_api.g_exception_unexpected_error;
1605: ELSIF (l_return_status = g_ret_sts_error) THEN
1606: RAISE okl_api.g_exception_error;
1607: END IF;
1608: lock_row(x_return_status => l_return_status

Line 1606: RAISE okl_api.g_exception_error;

1602:
1603: IF (l_return_status = g_ret_sts_unexp_error) THEN
1604: RAISE okl_api.g_exception_unexpected_error;
1605: ELSIF (l_return_status = g_ret_sts_error) THEN
1606: RAISE okl_api.g_exception_error;
1607: END IF;
1608: lock_row(x_return_status => l_return_status
1609: ,p_lrttl_rec => l_lrttl_rec);
1610:

Line 1612: RAISE okl_api.g_exception_unexpected_error;

1608: lock_row(x_return_status => l_return_status
1609: ,p_lrttl_rec => l_lrttl_rec);
1610:
1611: IF (l_return_status = g_ret_sts_unexp_error) THEN
1612: RAISE okl_api.g_exception_unexpected_error;
1613: ELSIF (l_return_status = g_ret_sts_error) THEN
1614: RAISE okl_api.g_exception_error;
1615: END IF;
1616: x_return_status := l_return_status;

Line 1614: RAISE okl_api.g_exception_error;

1610:
1611: IF (l_return_status = g_ret_sts_unexp_error) THEN
1612: RAISE okl_api.g_exception_unexpected_error;
1613: ELSIF (l_return_status = g_ret_sts_error) THEN
1614: RAISE okl_api.g_exception_error;
1615: END IF;
1616: x_return_status := l_return_status;
1617: EXCEPTION
1618: WHEN okl_api.g_exception_error THEN

Line 1618: WHEN okl_api.g_exception_error THEN

1614: RAISE okl_api.g_exception_error;
1615: END IF;
1616: x_return_status := l_return_status;
1617: EXCEPTION
1618: WHEN okl_api.g_exception_error THEN
1619: x_return_status := g_ret_sts_error;
1620: WHEN okl_api.g_exception_unexpected_error THEN
1621: x_return_status := g_ret_sts_unexp_error;
1622: WHEN OTHERS THEN

Line 1620: WHEN okl_api.g_exception_unexpected_error THEN

1616: x_return_status := l_return_status;
1617: EXCEPTION
1618: WHEN okl_api.g_exception_error THEN
1619: x_return_status := g_ret_sts_error;
1620: WHEN okl_api.g_exception_unexpected_error THEN
1621: x_return_status := g_ret_sts_unexp_error;
1622: WHEN OTHERS THEN
1623: okl_api.set_message(p_app_name => g_app_name
1624: ,p_msg_name => g_db_error

Line 1623: okl_api.set_message(p_app_name => g_app_name

1619: x_return_status := g_ret_sts_error;
1620: WHEN okl_api.g_exception_unexpected_error THEN
1621: x_return_status := g_ret_sts_unexp_error;
1622: WHEN OTHERS THEN
1623: okl_api.set_message(p_app_name => g_app_name
1624: ,p_msg_name => g_db_error
1625: ,p_token1 => g_prog_name_token
1626: ,p_token1_value => l_api_name
1627: ,p_token2 => g_sqlcode_token

Line 1662: RAISE okl_api.g_exception_unexpected_error;

1658: ,x_msg_count => x_msg_count
1659: ,x_msg_data => x_msg_data
1660: ,p_lrtv_rec => p_lrtv_tbl(i));
1661: IF l_return_status = g_ret_sts_unexp_error THEN
1662: RAISE okl_api.g_exception_unexpected_error;
1663: ELSIF l_return_status = g_ret_sts_error THEN
1664: RAISE okl_api.g_exception_error;
1665: END IF;
1666: EXIT WHEN(i = p_lrtv_tbl.LAST);

Line 1664: RAISE okl_api.g_exception_error;

1660: ,p_lrtv_rec => p_lrtv_tbl(i));
1661: IF l_return_status = g_ret_sts_unexp_error THEN
1662: RAISE okl_api.g_exception_unexpected_error;
1663: ELSIF l_return_status = g_ret_sts_error THEN
1664: RAISE okl_api.g_exception_error;
1665: END IF;
1666: EXIT WHEN(i = p_lrtv_tbl.LAST);
1667: i := p_lrtv_tbl.next(i);
1668: END IF;

Line 1674: WHEN okl_api.g_exception_error THEN

1670:
1671: END IF;
1672: x_return_status := l_return_status;
1673: EXCEPTION
1674: WHEN okl_api.g_exception_error THEN
1675: x_return_status := g_ret_sts_error;
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := g_ret_sts_unexp_error;
1678: WHEN OTHERS THEN

Line 1676: WHEN okl_api.g_exception_unexpected_error THEN

1672: x_return_status := l_return_status;
1673: EXCEPTION
1674: WHEN okl_api.g_exception_error THEN
1675: x_return_status := g_ret_sts_error;
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := g_ret_sts_unexp_error;
1678: WHEN OTHERS THEN
1679: okl_api.set_message(p_app_name => g_app_name
1680: ,p_msg_name => g_db_error

Line 1679: okl_api.set_message(p_app_name => g_app_name

1675: x_return_status := g_ret_sts_error;
1676: WHEN okl_api.g_exception_unexpected_error THEN
1677: x_return_status := g_ret_sts_unexp_error;
1678: WHEN OTHERS THEN
1679: okl_api.set_message(p_app_name => g_app_name
1680: ,p_msg_name => g_db_error
1681: ,p_token1 => g_prog_name_token
1682: ,p_token1_value => l_api_name
1683: ,p_token2 => g_sqlcode_token

Line 1740: WHEN okl_api.g_exception_error THEN

1736: ,orig_rate_set_id = p_lrt_rec.orig_rate_set_id
1737: WHERE id = p_lrt_rec.id;
1738: x_return_status := g_ret_sts_success;
1739: EXCEPTION
1740: WHEN okl_api.g_exception_error THEN
1741: x_return_status := g_ret_sts_error;
1742: WHEN okl_api.g_exception_unexpected_error THEN
1743: x_return_status := g_ret_sts_unexp_error;
1744: WHEN OTHERS THEN

Line 1742: WHEN okl_api.g_exception_unexpected_error THEN

1738: x_return_status := g_ret_sts_success;
1739: EXCEPTION
1740: WHEN okl_api.g_exception_error THEN
1741: x_return_status := g_ret_sts_error;
1742: WHEN okl_api.g_exception_unexpected_error THEN
1743: x_return_status := g_ret_sts_unexp_error;
1744: WHEN OTHERS THEN
1745: okl_api.set_message(p_app_name => g_app_name
1746: ,p_msg_name => g_db_error

Line 1745: okl_api.set_message(p_app_name => g_app_name

1741: x_return_status := g_ret_sts_error;
1742: WHEN okl_api.g_exception_unexpected_error THEN
1743: x_return_status := g_ret_sts_unexp_error;
1744: WHEN OTHERS THEN
1745: okl_api.set_message(p_app_name => g_app_name
1746: ,p_msg_name => g_db_error
1747: ,p_token1 => g_prog_name_token
1748: ,p_token1_value => l_api_name
1749: ,p_token2 => g_sqlcode_token

Line 1782: okl_api.set_message(p_app_name => g_app_name

1778: FETCH c_lang_setup INTO l_lang_setup ;
1779: CLOSE c_lang_setup;
1780:
1781: IF l_lang_setup = 'N' THEN
1782: okl_api.set_message(p_app_name => g_app_name
1783: ,p_msg_name => 'OKL_LANG_NOT_INSTALLED'
1784: ,p_token1 => 'LANG_CODE'
1785: ,p_token1_value => userenv('LANG'));
1786: END IF;

Line 1836: WHEN okl_api.g_exception_error THEN

1832: SET sfwt_flag = 'N'
1833: WHERE id = p_lrttl_rec.id AND source_lang = language;
1834: x_return_status := g_ret_sts_success;
1835: EXCEPTION
1836: WHEN okl_api.g_exception_error THEN
1837: x_return_status := g_ret_sts_error;
1838: WHEN okl_api.g_exception_unexpected_error THEN
1839: x_return_status := g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN

Line 1838: WHEN okl_api.g_exception_unexpected_error THEN

1834: x_return_status := g_ret_sts_success;
1835: EXCEPTION
1836: WHEN okl_api.g_exception_error THEN
1837: x_return_status := g_ret_sts_error;
1838: WHEN okl_api.g_exception_unexpected_error THEN
1839: x_return_status := g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: okl_api.set_message(p_app_name => g_app_name
1842: ,p_msg_name => g_db_error

Line 1841: okl_api.set_message(p_app_name => g_app_name

1837: x_return_status := g_ret_sts_error;
1838: WHEN okl_api.g_exception_unexpected_error THEN
1839: x_return_status := g_ret_sts_unexp_error;
1840: WHEN OTHERS THEN
1841: okl_api.set_message(p_app_name => g_app_name
1842: ,p_msg_name => g_db_error
1843: ,p_token1 => g_prog_name_token
1844: ,p_token1_value => l_api_name
1845: ,p_token2 => g_sqlcode_token

Line 1892: RAISE okl_api.g_exception_unexpected_error;

1888: x_lrtv_rec := p_lrtv_rec;
1889: l_db_lrtv_rec := get_rec(p_lrtv_rec.id, l_return_status);
1890:
1891: IF l_return_status = g_ret_sts_unexp_error THEN
1892: RAISE okl_api.g_exception_unexpected_error;
1893: ELSIF l_return_status = g_ret_sts_error THEN
1894: RAISE okl_api.g_exception_error;
1895: END IF;
1896:

Line 1894: RAISE okl_api.g_exception_error;

1890:
1891: IF l_return_status = g_ret_sts_unexp_error THEN
1892: RAISE okl_api.g_exception_unexpected_error;
1893: ELSIF l_return_status = g_ret_sts_error THEN
1894: RAISE okl_api.g_exception_error;
1895: END IF;
1896:
1897: -- Do NOT default the following 4 standard attributes from the DB
1898: -- object_version_number

Line 2042: WHEN okl_api.g_exception_error THEN

2038:
2039:
2040: RETURN l_return_status;
2041: EXCEPTION
2042: WHEN okl_api.g_exception_error THEN
2043: x_return_status := g_ret_sts_error;
2044: WHEN okl_api.g_exception_unexpected_error THEN
2045: x_return_status := g_ret_sts_unexp_error;
2046: WHEN OTHERS THEN

Line 2044: WHEN okl_api.g_exception_unexpected_error THEN

2040: RETURN l_return_status;
2041: EXCEPTION
2042: WHEN okl_api.g_exception_error THEN
2043: x_return_status := g_ret_sts_error;
2044: WHEN okl_api.g_exception_unexpected_error THEN
2045: x_return_status := g_ret_sts_unexp_error;
2046: WHEN OTHERS THEN
2047: okl_api.set_message(p_app_name => g_app_name
2048: ,p_msg_name => g_db_error

Line 2047: okl_api.set_message(p_app_name => g_app_name

2043: x_return_status := g_ret_sts_error;
2044: WHEN okl_api.g_exception_unexpected_error THEN
2045: x_return_status := g_ret_sts_unexp_error;
2046: WHEN OTHERS THEN
2047: okl_api.set_message(p_app_name => g_app_name
2048: ,p_msg_name => g_db_error
2049: ,p_token1 => g_prog_name_token
2050: ,p_token1_value => l_api_name
2051: ,p_token2 => g_sqlcode_token

Line 2062: RAISE okl_api.g_exception_unexpected_error;

2058: BEGIN
2059: l_return_status := populate_new_record(p_lrtv_rec, l_lrtv_rec);
2060:
2061: IF (l_return_status = g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;
2066:

Line 2064: RAISE okl_api.g_exception_error;

2060:
2061: IF (l_return_status = g_ret_sts_unexp_error) THEN
2062: RAISE okl_api.g_exception_unexpected_error;
2063: ELSIF (l_return_status = g_ret_sts_error) THEN
2064: RAISE okl_api.g_exception_error;
2065: END IF;
2066:
2067: --null out g miss values
2068:

Line 2078: RAISE okl_api.g_exception_unexpected_error;

2074: l_lrtv_rec.last_update_login := fnd_global.login_id;
2075: l_return_status := validate_attributes(l_lrtv_rec);
2076:
2077: IF (l_return_status = g_ret_sts_unexp_error) THEN
2078: RAISE okl_api.g_exception_unexpected_error;
2079: ELSIF (l_return_status = g_ret_sts_error) THEN
2080: RAISE okl_api.g_exception_error;
2081: END IF;
2082: l_return_status := validate_record(l_lrtv_rec);

Line 2080: RAISE okl_api.g_exception_error;

2076:
2077: IF (l_return_status = g_ret_sts_unexp_error) THEN
2078: RAISE okl_api.g_exception_unexpected_error;
2079: ELSIF (l_return_status = g_ret_sts_error) THEN
2080: RAISE okl_api.g_exception_error;
2081: END IF;
2082: l_return_status := validate_record(l_lrtv_rec);
2083:
2084: IF (l_return_status = g_ret_sts_unexp_error) THEN

Line 2085: RAISE okl_api.g_exception_unexpected_error;

2081: END IF;
2082: l_return_status := validate_record(l_lrtv_rec);
2083:
2084: IF (l_return_status = g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (l_return_status = g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;
2089:

Line 2087: RAISE okl_api.g_exception_error;

2083:
2084: IF (l_return_status = g_ret_sts_unexp_error) THEN
2085: RAISE okl_api.g_exception_unexpected_error;
2086: ELSIF (l_return_status = g_ret_sts_error) THEN
2087: RAISE okl_api.g_exception_error;
2088: END IF;
2089:
2090: lock_row(p_api_version => g_api_version
2091: ,p_init_msg_list => g_false

Line 2098: RAISE okl_api.g_exception_unexpected_error;

2094: ,x_msg_data => x_msg_data
2095: ,p_lrtv_rec => l_lrtv_rec);
2096:
2097: IF (l_return_status = g_ret_sts_unexp_error) THEN
2098: RAISE okl_api.g_exception_unexpected_error;
2099: ELSIF (l_return_status = g_ret_sts_error) THEN
2100: RAISE okl_api.g_exception_error;
2101: END IF;
2102: migrate(l_lrtv_rec, l_lrt_rec);

Line 2100: RAISE okl_api.g_exception_error;

2096:
2097: IF (l_return_status = g_ret_sts_unexp_error) THEN
2098: RAISE okl_api.g_exception_unexpected_error;
2099: ELSIF (l_return_status = g_ret_sts_error) THEN
2100: RAISE okl_api.g_exception_error;
2101: END IF;
2102: migrate(l_lrtv_rec, l_lrt_rec);
2103: migrate(l_lrtv_rec, l_lrttl_rec);
2104: update_row(x_return_status => l_return_status

Line 2108: RAISE okl_api.g_exception_unexpected_error;

2104: update_row(x_return_status => l_return_status
2105: ,p_lrt_rec => l_lrt_rec);
2106:
2107: IF (l_return_status = g_ret_sts_unexp_error) THEN
2108: RAISE okl_api.g_exception_unexpected_error;
2109: ELSIF (l_return_status = g_ret_sts_error) THEN
2110: RAISE okl_api.g_exception_error;
2111: END IF;
2112:

Line 2110: RAISE okl_api.g_exception_error;

2106:
2107: IF (l_return_status = g_ret_sts_unexp_error) THEN
2108: RAISE okl_api.g_exception_unexpected_error;
2109: ELSIF (l_return_status = g_ret_sts_error) THEN
2110: RAISE okl_api.g_exception_error;
2111: END IF;
2112:
2113: update_row(x_return_status => l_return_status
2114: ,p_lrttl_rec => l_lrttl_rec);

Line 2117: RAISE okl_api.g_exception_unexpected_error;

2113: update_row(x_return_status => l_return_status
2114: ,p_lrttl_rec => l_lrttl_rec);
2115:
2116: IF (l_return_status = g_ret_sts_unexp_error) THEN
2117: RAISE okl_api.g_exception_unexpected_error;
2118: ELSIF (l_return_status = g_ret_sts_error) THEN
2119: RAISE okl_api.g_exception_error;
2120: END IF;
2121: x_return_status := l_return_status;

Line 2119: RAISE okl_api.g_exception_error;

2115:
2116: IF (l_return_status = g_ret_sts_unexp_error) THEN
2117: RAISE okl_api.g_exception_unexpected_error;
2118: ELSIF (l_return_status = g_ret_sts_error) THEN
2119: RAISE okl_api.g_exception_error;
2120: END IF;
2121: x_return_status := l_return_status;
2122: x_lrtv_rec := l_lrtv_rec;
2123: EXCEPTION

Line 2124: WHEN okl_api.g_exception_error THEN

2120: END IF;
2121: x_return_status := l_return_status;
2122: x_lrtv_rec := l_lrtv_rec;
2123: EXCEPTION
2124: WHEN okl_api.g_exception_error THEN
2125: x_return_status := g_ret_sts_error;
2126: WHEN okl_api.g_exception_unexpected_error THEN
2127: x_return_status := g_ret_sts_unexp_error;
2128: WHEN OTHERS THEN

Line 2126: WHEN okl_api.g_exception_unexpected_error THEN

2122: x_lrtv_rec := l_lrtv_rec;
2123: EXCEPTION
2124: WHEN okl_api.g_exception_error THEN
2125: x_return_status := g_ret_sts_error;
2126: WHEN okl_api.g_exception_unexpected_error THEN
2127: x_return_status := g_ret_sts_unexp_error;
2128: WHEN OTHERS THEN
2129: okl_api.set_message(p_app_name => g_app_name
2130: ,p_msg_name => g_db_error

Line 2129: okl_api.set_message(p_app_name => g_app_name

2125: x_return_status := g_ret_sts_error;
2126: WHEN okl_api.g_exception_unexpected_error THEN
2127: x_return_status := g_ret_sts_unexp_error;
2128: WHEN OTHERS THEN
2129: okl_api.set_message(p_app_name => g_app_name
2130: ,p_msg_name => g_db_error
2131: ,p_token1 => g_prog_name_token
2132: ,p_token1_value => l_api_name
2133: ,p_token2 => g_sqlcode_token

Line 2170: RAISE okl_api.g_exception_unexpected_error;

2166: ,x_msg_data => x_msg_data
2167: ,p_lrtv_rec => p_lrtv_tbl(i)
2168: ,x_lrtv_rec => x_lrtv_tbl(i));
2169: IF l_return_status = g_ret_sts_unexp_error THEN
2170: RAISE okl_api.g_exception_unexpected_error;
2171: ELSIF l_return_status = g_ret_sts_error THEN
2172: RAISE okl_api.g_exception_error;
2173: END IF;
2174: EXIT WHEN(i = p_lrtv_tbl.LAST);

Line 2172: RAISE okl_api.g_exception_error;

2168: ,x_lrtv_rec => x_lrtv_tbl(i));
2169: IF l_return_status = g_ret_sts_unexp_error THEN
2170: RAISE okl_api.g_exception_unexpected_error;
2171: ELSIF l_return_status = g_ret_sts_error THEN
2172: RAISE okl_api.g_exception_error;
2173: END IF;
2174: EXIT WHEN(i = p_lrtv_tbl.LAST);
2175: i := p_lrtv_tbl.next(i);
2176: END IF;

Line 2182: WHEN okl_api.g_exception_error THEN

2178:
2179: END IF;
2180: x_return_status := l_return_status;
2181: EXCEPTION
2182: WHEN okl_api.g_exception_error THEN
2183: x_return_status := g_ret_sts_error;
2184: WHEN okl_api.g_exception_unexpected_error THEN
2185: x_return_status := g_ret_sts_unexp_error;
2186: WHEN OTHERS THEN

Line 2184: WHEN okl_api.g_exception_unexpected_error THEN

2180: x_return_status := l_return_status;
2181: EXCEPTION
2182: WHEN okl_api.g_exception_error THEN
2183: x_return_status := g_ret_sts_error;
2184: WHEN okl_api.g_exception_unexpected_error THEN
2185: x_return_status := g_ret_sts_unexp_error;
2186: WHEN OTHERS THEN
2187: okl_api.set_message(p_app_name => g_app_name
2188: ,p_msg_name => g_db_error

Line 2187: okl_api.set_message(p_app_name => g_app_name

2183: x_return_status := g_ret_sts_error;
2184: WHEN okl_api.g_exception_unexpected_error THEN
2185: x_return_status := g_ret_sts_unexp_error;
2186: WHEN OTHERS THEN
2187: okl_api.set_message(p_app_name => g_app_name
2188: ,p_msg_name => g_db_error
2189: ,p_token1 => g_prog_name_token
2190: ,p_token1_value => l_api_name
2191: ,p_token2 => g_sqlcode_token

Line 2218: WHEN okl_api.g_exception_error THEN

2214: DELETE FROM okl_ls_rt_fctr_sets_b
2215: WHERE id = p_lrt_rec.id;
2216: x_return_status := g_ret_sts_success;
2217: EXCEPTION
2218: WHEN okl_api.g_exception_error THEN
2219: x_return_status := g_ret_sts_error;
2220: WHEN okl_api.g_exception_unexpected_error THEN
2221: x_return_status := g_ret_sts_unexp_error;
2222: WHEN OTHERS THEN

Line 2220: WHEN okl_api.g_exception_unexpected_error THEN

2216: x_return_status := g_ret_sts_success;
2217: EXCEPTION
2218: WHEN okl_api.g_exception_error THEN
2219: x_return_status := g_ret_sts_error;
2220: WHEN okl_api.g_exception_unexpected_error THEN
2221: x_return_status := g_ret_sts_unexp_error;
2222: WHEN OTHERS THEN
2223: okl_api.set_message(p_app_name => g_app_name
2224: ,p_msg_name => g_db_error

Line 2223: okl_api.set_message(p_app_name => g_app_name

2219: x_return_status := g_ret_sts_error;
2220: WHEN okl_api.g_exception_unexpected_error THEN
2221: x_return_status := g_ret_sts_unexp_error;
2222: WHEN OTHERS THEN
2223: okl_api.set_message(p_app_name => g_app_name
2224: ,p_msg_name => g_db_error
2225: ,p_token1 => g_prog_name_token
2226: ,p_token1_value => l_api_name
2227: ,p_token2 => g_sqlcode_token

Line 2251: WHEN okl_api.g_exception_error THEN

2247: DELETE FROM okl_ls_rt_fctr_sets_tl
2248: WHERE id = p_lrttl_rec.id;
2249: x_return_status := g_ret_sts_success;
2250: EXCEPTION
2251: WHEN okl_api.g_exception_error THEN
2252: x_return_status := g_ret_sts_error;
2253: WHEN okl_api.g_exception_unexpected_error THEN
2254: x_return_status := g_ret_sts_unexp_error;
2255: WHEN OTHERS THEN

Line 2253: WHEN okl_api.g_exception_unexpected_error THEN

2249: x_return_status := g_ret_sts_success;
2250: EXCEPTION
2251: WHEN okl_api.g_exception_error THEN
2252: x_return_status := g_ret_sts_error;
2253: WHEN okl_api.g_exception_unexpected_error THEN
2254: x_return_status := g_ret_sts_unexp_error;
2255: WHEN OTHERS THEN
2256: okl_api.set_message(p_app_name => g_app_name
2257: ,p_msg_name => g_db_error

Line 2256: okl_api.set_message(p_app_name => g_app_name

2252: x_return_status := g_ret_sts_error;
2253: WHEN okl_api.g_exception_unexpected_error THEN
2254: x_return_status := g_ret_sts_unexp_error;
2255: WHEN OTHERS THEN
2256: okl_api.set_message(p_app_name => g_app_name
2257: ,p_msg_name => g_db_error
2258: ,p_token1 => g_prog_name_token
2259: ,p_token1_value => l_api_name
2260: ,p_token2 => g_sqlcode_token

Line 2293: RAISE okl_api.g_exception_unexpected_error;

2289: ,x_msg_data
2290: ,l_lrttl_rec);
2291:
2292: IF (l_return_status = g_ret_sts_unexp_error) THEN
2293: RAISE okl_api.g_exception_unexpected_error;
2294: ELSIF (l_return_status = g_ret_sts_error) THEN
2295: RAISE okl_api.g_exception_error;
2296: END IF;
2297: delete_row(p_init_msg_list

Line 2295: RAISE okl_api.g_exception_error;

2291:
2292: IF (l_return_status = g_ret_sts_unexp_error) THEN
2293: RAISE okl_api.g_exception_unexpected_error;
2294: ELSIF (l_return_status = g_ret_sts_error) THEN
2295: RAISE okl_api.g_exception_error;
2296: END IF;
2297: delete_row(p_init_msg_list
2298: ,l_return_status
2299: ,x_msg_count

Line 2304: RAISE okl_api.g_exception_unexpected_error;

2300: ,x_msg_data
2301: ,l_lrt_rec);
2302:
2303: IF (l_return_status = g_ret_sts_unexp_error) THEN
2304: RAISE okl_api.g_exception_unexpected_error;
2305: ELSIF (l_return_status = g_ret_sts_error) THEN
2306: RAISE okl_api.g_exception_error;
2307: END IF;
2308: x_return_status := l_return_status;

Line 2306: RAISE okl_api.g_exception_error;

2302:
2303: IF (l_return_status = g_ret_sts_unexp_error) THEN
2304: RAISE okl_api.g_exception_unexpected_error;
2305: ELSIF (l_return_status = g_ret_sts_error) THEN
2306: RAISE okl_api.g_exception_error;
2307: END IF;
2308: x_return_status := l_return_status;
2309: EXCEPTION
2310: WHEN okl_api.g_exception_error THEN

Line 2310: WHEN okl_api.g_exception_error THEN

2306: RAISE okl_api.g_exception_error;
2307: END IF;
2308: x_return_status := l_return_status;
2309: EXCEPTION
2310: WHEN okl_api.g_exception_error THEN
2311: x_return_status := g_ret_sts_error;
2312: WHEN okl_api.g_exception_unexpected_error THEN
2313: x_return_status := g_ret_sts_unexp_error;
2314: WHEN OTHERS THEN

Line 2312: WHEN okl_api.g_exception_unexpected_error THEN

2308: x_return_status := l_return_status;
2309: EXCEPTION
2310: WHEN okl_api.g_exception_error THEN
2311: x_return_status := g_ret_sts_error;
2312: WHEN okl_api.g_exception_unexpected_error THEN
2313: x_return_status := g_ret_sts_unexp_error;
2314: WHEN OTHERS THEN
2315: okl_api.set_message(p_app_name => g_app_name
2316: ,p_msg_name => g_db_error

Line 2315: okl_api.set_message(p_app_name => g_app_name

2311: x_return_status := g_ret_sts_error;
2312: WHEN okl_api.g_exception_unexpected_error THEN
2313: x_return_status := g_ret_sts_unexp_error;
2314: WHEN OTHERS THEN
2315: okl_api.set_message(p_app_name => g_app_name
2316: ,p_msg_name => g_db_error
2317: ,p_token1 => g_prog_name_token
2318: ,p_token1_value => l_api_name
2319: ,p_token2 => g_sqlcode_token

Line 2354: RAISE okl_api.g_exception_unexpected_error;

2350: ,x_msg_count => x_msg_count
2351: ,x_msg_data => x_msg_data
2352: ,p_lrtv_rec => p_lrtv_tbl(i));
2353: IF l_return_status = g_ret_sts_unexp_error THEN
2354: RAISE okl_api.g_exception_unexpected_error;
2355: ELSIF l_return_status = g_ret_sts_error THEN
2356: RAISE okl_api.g_exception_error;
2357: END IF;
2358: EXIT WHEN(i = p_lrtv_tbl.LAST);

Line 2356: RAISE okl_api.g_exception_error;

2352: ,p_lrtv_rec => p_lrtv_tbl(i));
2353: IF l_return_status = g_ret_sts_unexp_error THEN
2354: RAISE okl_api.g_exception_unexpected_error;
2355: ELSIF l_return_status = g_ret_sts_error THEN
2356: RAISE okl_api.g_exception_error;
2357: END IF;
2358: EXIT WHEN(i = p_lrtv_tbl.LAST);
2359: i := p_lrtv_tbl.next(i);
2360: END IF;

Line 2366: WHEN okl_api.g_exception_error THEN

2362:
2363: END IF;
2364: x_return_status := l_return_status;
2365: EXCEPTION
2366: WHEN okl_api.g_exception_error THEN
2367: x_return_status := g_ret_sts_error;
2368: WHEN okl_api.g_exception_unexpected_error THEN
2369: x_return_status := g_ret_sts_unexp_error;
2370: WHEN OTHERS THEN

Line 2368: WHEN okl_api.g_exception_unexpected_error THEN

2364: x_return_status := l_return_status;
2365: EXCEPTION
2366: WHEN okl_api.g_exception_error THEN
2367: x_return_status := g_ret_sts_error;
2368: WHEN okl_api.g_exception_unexpected_error THEN
2369: x_return_status := g_ret_sts_unexp_error;
2370: WHEN OTHERS THEN
2371: okl_api.set_message(p_app_name => g_app_name
2372: ,p_msg_name => g_db_error

Line 2371: okl_api.set_message(p_app_name => g_app_name

2367: x_return_status := g_ret_sts_error;
2368: WHEN okl_api.g_exception_unexpected_error THEN
2369: x_return_status := g_ret_sts_unexp_error;
2370: WHEN OTHERS THEN
2371: okl_api.set_message(p_app_name => g_app_name
2372: ,p_msg_name => g_db_error
2373: ,p_token1 => g_prog_name_token
2374: ,p_token1_value => l_api_name
2375: ,p_token2 => g_sqlcode_token