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

Line 440: IF (l_pamv_rec.adj_mat_id = okl_api.g_miss_num) THEN

436: l_pamv_rec okl_pamv_rec := p_pamv_rec;
437:
438: BEGIN
439:
440: IF (l_pamv_rec.adj_mat_id = okl_api.g_miss_num) THEN
441: l_pamv_rec.adj_mat_id := NULL;
442: END IF;
443:
444: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN

Line 444: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN

440: IF (l_pamv_rec.adj_mat_id = okl_api.g_miss_num) THEN
441: l_pamv_rec.adj_mat_id := NULL;
442: END IF;
443:
444: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN
445: l_pamv_rec.adj_mat_name := NULL;
446: END IF;
447:
448: IF (l_pamv_rec.object_version_number = okl_api.g_miss_num) THEN

Line 448: IF (l_pamv_rec.object_version_number = okl_api.g_miss_num) THEN

444: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN
445: l_pamv_rec.adj_mat_name := NULL;
446: END IF;
447:
448: IF (l_pamv_rec.object_version_number = okl_api.g_miss_num) THEN
449: l_pamv_rec.object_version_number := NULL;
450: END IF;
451:
452: IF (l_pamv_rec.org_id = okl_api.g_miss_num) THEN

Line 452: IF (l_pamv_rec.org_id = okl_api.g_miss_num) THEN

448: IF (l_pamv_rec.object_version_number = okl_api.g_miss_num) THEN
449: l_pamv_rec.object_version_number := NULL;
450: END IF;
451:
452: IF (l_pamv_rec.org_id = okl_api.g_miss_num) THEN
453: l_pamv_rec.org_id := NULL;
454: END IF;
455:
456: IF (l_pamv_rec.currency_code = okl_api.g_miss_char) THEN

Line 456: IF (l_pamv_rec.currency_code = okl_api.g_miss_char) THEN

452: IF (l_pamv_rec.org_id = okl_api.g_miss_num) THEN
453: l_pamv_rec.org_id := NULL;
454: END IF;
455:
456: IF (l_pamv_rec.currency_code = okl_api.g_miss_char) THEN
457: l_pamv_rec.currency_code := NULL;
458: END IF;
459:
460: IF (l_pamv_rec.adj_mat_type_code = okl_api.g_miss_char) THEN

Line 460: IF (l_pamv_rec.adj_mat_type_code = okl_api.g_miss_char) THEN

456: IF (l_pamv_rec.currency_code = okl_api.g_miss_char) THEN
457: l_pamv_rec.currency_code := NULL;
458: END IF;
459:
460: IF (l_pamv_rec.adj_mat_type_code = okl_api.g_miss_char) THEN
461: l_pamv_rec.adj_mat_type_code := NULL;
462: END IF;
463:
464: IF (l_pamv_rec.orig_adj_mat_id = okl_api.g_miss_num) THEN

Line 464: IF (l_pamv_rec.orig_adj_mat_id = okl_api.g_miss_num) THEN

460: IF (l_pamv_rec.adj_mat_type_code = okl_api.g_miss_char) THEN
461: l_pamv_rec.adj_mat_type_code := NULL;
462: END IF;
463:
464: IF (l_pamv_rec.orig_adj_mat_id = okl_api.g_miss_num) THEN
465: l_pamv_rec.orig_adj_mat_id := NULL;
466: END IF;
467:
468: IF (l_pamv_rec.sts_code = okl_api.g_miss_char) THEN

Line 468: IF (l_pamv_rec.sts_code = okl_api.g_miss_char) THEN

464: IF (l_pamv_rec.orig_adj_mat_id = okl_api.g_miss_num) THEN
465: l_pamv_rec.orig_adj_mat_id := NULL;
466: END IF;
467:
468: IF (l_pamv_rec.sts_code = okl_api.g_miss_char) THEN
469: l_pamv_rec.sts_code := NULL;
470: END IF;
471:
472: IF (l_pamv_rec.effective_from_date = okl_api.g_miss_date) THEN

Line 472: IF (l_pamv_rec.effective_from_date = okl_api.g_miss_date) THEN

468: IF (l_pamv_rec.sts_code = okl_api.g_miss_char) THEN
469: l_pamv_rec.sts_code := NULL;
470: END IF;
471:
472: IF (l_pamv_rec.effective_from_date = okl_api.g_miss_date) THEN
473: l_pamv_rec.effective_from_date := NULL;
474: END IF;
475:
476: IF (l_pamv_rec.effective_to_date = okl_api.g_miss_date) THEN

Line 476: IF (l_pamv_rec.effective_to_date = okl_api.g_miss_date) THEN

472: IF (l_pamv_rec.effective_from_date = okl_api.g_miss_date) THEN
473: l_pamv_rec.effective_from_date := NULL;
474: END IF;
475:
476: IF (l_pamv_rec.effective_to_date = okl_api.g_miss_date) THEN
477: l_pamv_rec.effective_to_date := NULL;
478: END IF;
479:
480: IF (l_pamv_rec.attribute_category = okl_api.g_miss_char) THEN

Line 480: IF (l_pamv_rec.attribute_category = okl_api.g_miss_char) THEN

476: IF (l_pamv_rec.effective_to_date = okl_api.g_miss_date) THEN
477: l_pamv_rec.effective_to_date := NULL;
478: END IF;
479:
480: IF (l_pamv_rec.attribute_category = okl_api.g_miss_char) THEN
481: l_pamv_rec.attribute_category := NULL;
482: END IF;
483:
484: IF (l_pamv_rec.attribute1 = okl_api.g_miss_char) THEN

Line 484: IF (l_pamv_rec.attribute1 = okl_api.g_miss_char) THEN

480: IF (l_pamv_rec.attribute_category = okl_api.g_miss_char) THEN
481: l_pamv_rec.attribute_category := NULL;
482: END IF;
483:
484: IF (l_pamv_rec.attribute1 = okl_api.g_miss_char) THEN
485: l_pamv_rec.attribute1 := NULL;
486: END IF;
487:
488: IF (l_pamv_rec.attribute2 = okl_api.g_miss_char) THEN

Line 488: IF (l_pamv_rec.attribute2 = okl_api.g_miss_char) THEN

484: IF (l_pamv_rec.attribute1 = okl_api.g_miss_char) THEN
485: l_pamv_rec.attribute1 := NULL;
486: END IF;
487:
488: IF (l_pamv_rec.attribute2 = okl_api.g_miss_char) THEN
489: l_pamv_rec.attribute2 := NULL;
490: END IF;
491:
492: IF (l_pamv_rec.attribute3 = okl_api.g_miss_char) THEN

Line 492: IF (l_pamv_rec.attribute3 = okl_api.g_miss_char) THEN

488: IF (l_pamv_rec.attribute2 = okl_api.g_miss_char) THEN
489: l_pamv_rec.attribute2 := NULL;
490: END IF;
491:
492: IF (l_pamv_rec.attribute3 = okl_api.g_miss_char) THEN
493: l_pamv_rec.attribute3 := NULL;
494: END IF;
495:
496: IF (l_pamv_rec.attribute4 = okl_api.g_miss_char) THEN

Line 496: IF (l_pamv_rec.attribute4 = okl_api.g_miss_char) THEN

492: IF (l_pamv_rec.attribute3 = okl_api.g_miss_char) THEN
493: l_pamv_rec.attribute3 := NULL;
494: END IF;
495:
496: IF (l_pamv_rec.attribute4 = okl_api.g_miss_char) THEN
497: l_pamv_rec.attribute4 := NULL;
498: END IF;
499:
500: IF (l_pamv_rec.attribute5 = okl_api.g_miss_char) THEN

Line 500: IF (l_pamv_rec.attribute5 = okl_api.g_miss_char) THEN

496: IF (l_pamv_rec.attribute4 = okl_api.g_miss_char) THEN
497: l_pamv_rec.attribute4 := NULL;
498: END IF;
499:
500: IF (l_pamv_rec.attribute5 = okl_api.g_miss_char) THEN
501: l_pamv_rec.attribute5 := NULL;
502: END IF;
503:
504: IF (l_pamv_rec.attribute6 = okl_api.g_miss_char) THEN

Line 504: IF (l_pamv_rec.attribute6 = okl_api.g_miss_char) THEN

500: IF (l_pamv_rec.attribute5 = okl_api.g_miss_char) THEN
501: l_pamv_rec.attribute5 := NULL;
502: END IF;
503:
504: IF (l_pamv_rec.attribute6 = okl_api.g_miss_char) THEN
505: l_pamv_rec.attribute6 := NULL;
506: END IF;
507:
508: IF (l_pamv_rec.attribute7 = okl_api.g_miss_char) THEN

Line 508: IF (l_pamv_rec.attribute7 = okl_api.g_miss_char) THEN

504: IF (l_pamv_rec.attribute6 = okl_api.g_miss_char) THEN
505: l_pamv_rec.attribute6 := NULL;
506: END IF;
507:
508: IF (l_pamv_rec.attribute7 = okl_api.g_miss_char) THEN
509: l_pamv_rec.attribute7 := NULL;
510: END IF;
511:
512: IF (l_pamv_rec.attribute8 = okl_api.g_miss_char) THEN

Line 512: IF (l_pamv_rec.attribute8 = okl_api.g_miss_char) THEN

508: IF (l_pamv_rec.attribute7 = okl_api.g_miss_char) THEN
509: l_pamv_rec.attribute7 := NULL;
510: END IF;
511:
512: IF (l_pamv_rec.attribute8 = okl_api.g_miss_char) THEN
513: l_pamv_rec.attribute8 := NULL;
514: END IF;
515:
516: IF (l_pamv_rec.attribute9 = okl_api.g_miss_char) THEN

Line 516: IF (l_pamv_rec.attribute9 = okl_api.g_miss_char) THEN

512: IF (l_pamv_rec.attribute8 = okl_api.g_miss_char) THEN
513: l_pamv_rec.attribute8 := NULL;
514: END IF;
515:
516: IF (l_pamv_rec.attribute9 = okl_api.g_miss_char) THEN
517: l_pamv_rec.attribute9 := NULL;
518: END IF;
519:
520: IF (l_pamv_rec.attribute10 = okl_api.g_miss_char) THEN

Line 520: IF (l_pamv_rec.attribute10 = okl_api.g_miss_char) THEN

516: IF (l_pamv_rec.attribute9 = okl_api.g_miss_char) THEN
517: l_pamv_rec.attribute9 := NULL;
518: END IF;
519:
520: IF (l_pamv_rec.attribute10 = okl_api.g_miss_char) THEN
521: l_pamv_rec.attribute10 := NULL;
522: END IF;
523:
524: IF (l_pamv_rec.attribute11 = okl_api.g_miss_char) THEN

Line 524: IF (l_pamv_rec.attribute11 = okl_api.g_miss_char) THEN

520: IF (l_pamv_rec.attribute10 = okl_api.g_miss_char) THEN
521: l_pamv_rec.attribute10 := NULL;
522: END IF;
523:
524: IF (l_pamv_rec.attribute11 = okl_api.g_miss_char) THEN
525: l_pamv_rec.attribute11 := NULL;
526: END IF;
527:
528: IF (l_pamv_rec.attribute12 = okl_api.g_miss_char) THEN

Line 528: IF (l_pamv_rec.attribute12 = okl_api.g_miss_char) THEN

524: IF (l_pamv_rec.attribute11 = okl_api.g_miss_char) THEN
525: l_pamv_rec.attribute11 := NULL;
526: END IF;
527:
528: IF (l_pamv_rec.attribute12 = okl_api.g_miss_char) THEN
529: l_pamv_rec.attribute12 := NULL;
530: END IF;
531:
532: IF (l_pamv_rec.attribute13 = okl_api.g_miss_char) THEN

Line 532: IF (l_pamv_rec.attribute13 = okl_api.g_miss_char) THEN

528: IF (l_pamv_rec.attribute12 = okl_api.g_miss_char) THEN
529: l_pamv_rec.attribute12 := NULL;
530: END IF;
531:
532: IF (l_pamv_rec.attribute13 = okl_api.g_miss_char) THEN
533: l_pamv_rec.attribute13 := NULL;
534: END IF;
535:
536: IF (l_pamv_rec.attribute14 = okl_api.g_miss_char) THEN

Line 536: IF (l_pamv_rec.attribute14 = okl_api.g_miss_char) THEN

532: IF (l_pamv_rec.attribute13 = okl_api.g_miss_char) THEN
533: l_pamv_rec.attribute13 := NULL;
534: END IF;
535:
536: IF (l_pamv_rec.attribute14 = okl_api.g_miss_char) THEN
537: l_pamv_rec.attribute14 := NULL;
538: END IF;
539:
540: IF (l_pamv_rec.attribute15 = okl_api.g_miss_char) THEN

Line 540: IF (l_pamv_rec.attribute15 = okl_api.g_miss_char) THEN

536: IF (l_pamv_rec.attribute14 = okl_api.g_miss_char) THEN
537: l_pamv_rec.attribute14 := NULL;
538: END IF;
539:
540: IF (l_pamv_rec.attribute15 = okl_api.g_miss_char) THEN
541: l_pamv_rec.attribute15 := NULL;
542: END IF;
543:
544: IF (l_pamv_rec.created_by = okl_api.g_miss_num) THEN

Line 544: IF (l_pamv_rec.created_by = okl_api.g_miss_num) THEN

540: IF (l_pamv_rec.attribute15 = okl_api.g_miss_char) THEN
541: l_pamv_rec.attribute15 := NULL;
542: END IF;
543:
544: IF (l_pamv_rec.created_by = okl_api.g_miss_num) THEN
545: l_pamv_rec.created_by := NULL;
546: END IF;
547:
548: IF (l_pamv_rec.creation_date = okl_api.g_miss_date) THEN

Line 548: IF (l_pamv_rec.creation_date = okl_api.g_miss_date) THEN

544: IF (l_pamv_rec.created_by = okl_api.g_miss_num) THEN
545: l_pamv_rec.created_by := NULL;
546: END IF;
547:
548: IF (l_pamv_rec.creation_date = okl_api.g_miss_date) THEN
549: l_pamv_rec.creation_date := NULL;
550: END IF;
551:
552: IF (l_pamv_rec.last_updated_by = okl_api.g_miss_num) THEN

Line 552: IF (l_pamv_rec.last_updated_by = okl_api.g_miss_num) THEN

548: IF (l_pamv_rec.creation_date = okl_api.g_miss_date) THEN
549: l_pamv_rec.creation_date := NULL;
550: END IF;
551:
552: IF (l_pamv_rec.last_updated_by = okl_api.g_miss_num) THEN
553: l_pamv_rec.last_updated_by := NULL;
554: END IF;
555:
556: IF (l_pamv_rec.last_update_date = okl_api.g_miss_date) THEN

Line 556: IF (l_pamv_rec.last_update_date = okl_api.g_miss_date) THEN

552: IF (l_pamv_rec.last_updated_by = okl_api.g_miss_num) THEN
553: l_pamv_rec.last_updated_by := NULL;
554: END IF;
555:
556: IF (l_pamv_rec.last_update_date = okl_api.g_miss_date) THEN
557: l_pamv_rec.last_update_date := NULL;
558: END IF;
559:
560: IF (l_pamv_rec.last_update_login = okl_api.g_miss_num) THEN

Line 560: IF (l_pamv_rec.last_update_login = okl_api.g_miss_num) THEN

556: IF (l_pamv_rec.last_update_date = okl_api.g_miss_date) THEN
557: l_pamv_rec.last_update_date := NULL;
558: END IF;
559:
560: IF (l_pamv_rec.last_update_login = okl_api.g_miss_num) THEN
561: l_pamv_rec.last_update_login := NULL;
562: END IF;
563:
564: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN

Line 564: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN

560: IF (l_pamv_rec.last_update_login = okl_api.g_miss_num) THEN
561: l_pamv_rec.last_update_login := NULL;
562: END IF;
563:
564: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN
565: l_pamv_rec.adj_mat_name := NULL;
566: END IF;
567:
568: IF (l_pamv_rec.adj_mat_desc = okl_api.g_miss_char) THEN

Line 568: IF (l_pamv_rec.adj_mat_desc = okl_api.g_miss_char) THEN

564: IF (l_pamv_rec.adj_mat_name = okl_api.g_miss_char) THEN
565: l_pamv_rec.adj_mat_name := NULL;
566: END IF;
567:
568: IF (l_pamv_rec.adj_mat_desc = okl_api.g_miss_char) THEN
569: l_pamv_rec.adj_mat_desc := NULL;
570: END IF;
571: RETURN(l_pamv_rec);
572: END null_out_defaults;

Line 603: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

599: FROM okl_fe_adj_mat_all_b
600: WHERE adj_mat_id = p_pamb_rec.adj_mat_id;
601: l_api_version CONSTANT NUMBER := 1;
602: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
603: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
604: l_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
605: lc_object_version_number okl_fe_resi_cat_all_b.object_version_number%TYPE;
606: l_row_notfound BOOLEAN := false;
607: lc_row_notfound BOOLEAN := false;

Line 610: l_return_status := okl_api.start_activity(l_api_name

606: l_row_notfound BOOLEAN := false;
607: lc_row_notfound BOOLEAN := false;
608:
609: BEGIN
610: l_return_status := okl_api.start_activity(l_api_name
611: ,p_init_msg_list
612: ,'_PVT'
613: ,x_return_status);
614:

Line 615: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

611: ,p_init_msg_list
612: ,'_PVT'
613: ,x_return_status);
614:
615: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
616: RAISE okl_api.g_exception_unexpected_error;
617: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
618: RAISE okl_api.g_exception_error;
619: END IF;

Line 616: RAISE okl_api.g_exception_unexpected_error;

612: ,'_PVT'
613: ,x_return_status);
614:
615: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
616: RAISE okl_api.g_exception_unexpected_error;
617: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
618: RAISE okl_api.g_exception_error;
619: END IF;
620:

Line 617: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

613: ,x_return_status);
614:
615: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
616: RAISE okl_api.g_exception_unexpected_error;
617: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
618: RAISE okl_api.g_exception_error;
619: END IF;
620:
621: BEGIN

Line 618: RAISE okl_api.g_exception_error;

614:
615: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
616: RAISE okl_api.g_exception_unexpected_error;
617: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
618: RAISE okl_api.g_exception_error;
619: END IF;
620:
621: BEGIN
622: OPEN lock_csr(p_pamb_rec);

Line 632: okl_api.set_message(g_fnd_app

628:
629: IF (lock_csr%ISOPEN) THEN
630: CLOSE lock_csr;
631: END IF;
632: okl_api.set_message(g_fnd_app
633: ,g_form_unable_to_reserve_rec);
634: RAISE app_exceptions.record_lock_exception;
635: END;
636:

Line 645: okl_api.set_message(g_fnd_app

641: CLOSE lchk_csr;
642: END IF;
643:
644: IF (lc_row_notfound) THEN
645: okl_api.set_message(g_fnd_app
646: ,g_form_record_deleted);
647: RAISE okl_api.g_exception_error;
648: ELSIF lc_object_version_number > p_pamb_rec.object_version_number THEN
649: okl_api.set_message(g_fnd_app

Line 647: RAISE okl_api.g_exception_error;

643:
644: IF (lc_row_notfound) THEN
645: okl_api.set_message(g_fnd_app
646: ,g_form_record_deleted);
647: RAISE okl_api.g_exception_error;
648: ELSIF lc_object_version_number > p_pamb_rec.object_version_number THEN
649: okl_api.set_message(g_fnd_app
650: ,g_form_record_changed);
651: RAISE okl_api.g_exception_error;

Line 649: okl_api.set_message(g_fnd_app

645: okl_api.set_message(g_fnd_app
646: ,g_form_record_deleted);
647: RAISE okl_api.g_exception_error;
648: ELSIF lc_object_version_number > p_pamb_rec.object_version_number THEN
649: okl_api.set_message(g_fnd_app
650: ,g_form_record_changed);
651: RAISE okl_api.g_exception_error;
652: ELSIF lc_object_version_number <> p_pamb_rec.object_version_number THEN
653: okl_api.set_message(g_fnd_app

Line 651: RAISE okl_api.g_exception_error;

647: RAISE okl_api.g_exception_error;
648: ELSIF lc_object_version_number > p_pamb_rec.object_version_number THEN
649: okl_api.set_message(g_fnd_app
650: ,g_form_record_changed);
651: RAISE okl_api.g_exception_error;
652: ELSIF lc_object_version_number <> p_pamb_rec.object_version_number THEN
653: okl_api.set_message(g_fnd_app
654: ,g_form_record_changed);
655: RAISE okl_api.g_exception_error;

Line 653: okl_api.set_message(g_fnd_app

649: okl_api.set_message(g_fnd_app
650: ,g_form_record_changed);
651: RAISE okl_api.g_exception_error;
652: ELSIF lc_object_version_number <> p_pamb_rec.object_version_number THEN
653: okl_api.set_message(g_fnd_app
654: ,g_form_record_changed);
655: RAISE okl_api.g_exception_error;
656: ELSIF lc_object_version_number = - 1 THEN
657: okl_api.set_message(g_app_name

Line 655: RAISE okl_api.g_exception_error;

651: RAISE okl_api.g_exception_error;
652: ELSIF lc_object_version_number <> p_pamb_rec.object_version_number THEN
653: okl_api.set_message(g_fnd_app
654: ,g_form_record_changed);
655: RAISE okl_api.g_exception_error;
656: ELSIF lc_object_version_number = - 1 THEN
657: okl_api.set_message(g_app_name
658: ,g_record_logically_deleted);
659: RAISE okl_api.g_exception_error;

Line 657: okl_api.set_message(g_app_name

653: okl_api.set_message(g_fnd_app
654: ,g_form_record_changed);
655: RAISE okl_api.g_exception_error;
656: ELSIF lc_object_version_number = - 1 THEN
657: okl_api.set_message(g_app_name
658: ,g_record_logically_deleted);
659: RAISE okl_api.g_exception_error;
660: END IF;
661: okl_api.end_activity(x_msg_count

Line 659: RAISE okl_api.g_exception_error;

655: RAISE okl_api.g_exception_error;
656: ELSIF lc_object_version_number = - 1 THEN
657: okl_api.set_message(g_app_name
658: ,g_record_logically_deleted);
659: RAISE okl_api.g_exception_error;
660: END IF;
661: okl_api.end_activity(x_msg_count
662: ,x_msg_data);
663: EXCEPTION

Line 661: okl_api.end_activity(x_msg_count

657: okl_api.set_message(g_app_name
658: ,g_record_logically_deleted);
659: RAISE okl_api.g_exception_error;
660: END IF;
661: okl_api.end_activity(x_msg_count
662: ,x_msg_data);
663: EXCEPTION
664: WHEN g_exception_halt_validation THEN
665: x_return_status := okl_api.handle_exceptions(l_api_name

Line 665: x_return_status := okl_api.handle_exceptions(l_api_name

661: okl_api.end_activity(x_msg_count
662: ,x_msg_data);
663: EXCEPTION
664: WHEN g_exception_halt_validation THEN
665: x_return_status := okl_api.handle_exceptions(l_api_name
666: ,g_pkg_name
667: ,'OKL_API.G_RET_STS_ERROR'
668: ,x_msg_count
669: ,x_msg_data

Line 667: ,'OKL_API.G_RET_STS_ERROR'

663: EXCEPTION
664: WHEN g_exception_halt_validation THEN
665: x_return_status := okl_api.handle_exceptions(l_api_name
666: ,g_pkg_name
667: ,'OKL_API.G_RET_STS_ERROR'
668: ,x_msg_count
669: ,x_msg_data
670: ,'_PVT');
671: WHEN okl_api.g_exception_error THEN

Line 671: WHEN okl_api.g_exception_error THEN

667: ,'OKL_API.G_RET_STS_ERROR'
668: ,x_msg_count
669: ,x_msg_data
670: ,'_PVT');
671: WHEN okl_api.g_exception_error THEN
672: x_return_status := okl_api.handle_exceptions(l_api_name
673: ,g_pkg_name
674: ,'OKL_API.G_RET_STS_ERROR'
675: ,x_msg_count

Line 672: x_return_status := okl_api.handle_exceptions(l_api_name

668: ,x_msg_count
669: ,x_msg_data
670: ,'_PVT');
671: WHEN okl_api.g_exception_error THEN
672: x_return_status := okl_api.handle_exceptions(l_api_name
673: ,g_pkg_name
674: ,'OKL_API.G_RET_STS_ERROR'
675: ,x_msg_count
676: ,x_msg_data

Line 674: ,'OKL_API.G_RET_STS_ERROR'

670: ,'_PVT');
671: WHEN okl_api.g_exception_error THEN
672: x_return_status := okl_api.handle_exceptions(l_api_name
673: ,g_pkg_name
674: ,'OKL_API.G_RET_STS_ERROR'
675: ,x_msg_count
676: ,x_msg_data
677: ,'_PVT');
678: WHEN okl_api.g_exception_unexpected_error THEN

Line 678: WHEN okl_api.g_exception_unexpected_error THEN

674: ,'OKL_API.G_RET_STS_ERROR'
675: ,x_msg_count
676: ,x_msg_data
677: ,'_PVT');
678: WHEN okl_api.g_exception_unexpected_error THEN
679: x_return_status := okl_api.handle_exceptions(l_api_name
680: ,g_pkg_name
681: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
682: ,x_msg_count

Line 679: x_return_status := okl_api.handle_exceptions(l_api_name

675: ,x_msg_count
676: ,x_msg_data
677: ,'_PVT');
678: WHEN okl_api.g_exception_unexpected_error THEN
679: x_return_status := okl_api.handle_exceptions(l_api_name
680: ,g_pkg_name
681: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
682: ,x_msg_count
683: ,x_msg_data

Line 681: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

677: ,'_PVT');
678: WHEN okl_api.g_exception_unexpected_error THEN
679: x_return_status := okl_api.handle_exceptions(l_api_name
680: ,g_pkg_name
681: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
682: ,x_msg_count
683: ,x_msg_data
684: ,'_PVT');
685: WHEN OTHERS THEN

Line 686: x_return_status := okl_api.handle_exceptions(l_api_name

682: ,x_msg_count
683: ,x_msg_data
684: ,'_PVT');
685: WHEN OTHERS THEN
686: x_return_status := okl_api.handle_exceptions(l_api_name
687: ,g_pkg_name
688: ,'OTHERS'
689: ,x_msg_count
690: ,x_msg_data

Line 714: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

710: WHERE adj_mat_id = p_pamtl_rec.adj_mat_id
711: FOR UPDATE NOWAIT;
712: l_api_version CONSTANT NUMBER := 1;
713: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
714: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
715: l_lock_var lock_csr%ROWTYPE;
716: l_row_notfound BOOLEAN := false;
717: lc_row_notfound BOOLEAN := false;
718:

Line 720: l_return_status := okl_api.start_activity(l_api_name

716: l_row_notfound BOOLEAN := false;
717: lc_row_notfound BOOLEAN := false;
718:
719: BEGIN
720: l_return_status := okl_api.start_activity(l_api_name
721: ,p_init_msg_list
722: ,'_PVT'
723: ,x_return_status);
724:

Line 725: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

721: ,p_init_msg_list
722: ,'_PVT'
723: ,x_return_status);
724:
725: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
726: RAISE okl_api.g_exception_unexpected_error;
727: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: END IF;

Line 726: RAISE okl_api.g_exception_unexpected_error;

722: ,'_PVT'
723: ,x_return_status);
724:
725: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
726: RAISE okl_api.g_exception_unexpected_error;
727: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: END IF;
730:

Line 727: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

723: ,x_return_status);
724:
725: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
726: RAISE okl_api.g_exception_unexpected_error;
727: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: END IF;
730:
731: BEGIN

Line 728: RAISE okl_api.g_exception_error;

724:
725: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
726: RAISE okl_api.g_exception_unexpected_error;
727: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
728: RAISE okl_api.g_exception_error;
729: END IF;
730:
731: BEGIN
732: OPEN lock_csr(p_pamtl_rec);

Line 742: okl_api.set_message(g_fnd_app

738:
739: IF (lock_csr%ISOPEN) THEN
740: CLOSE lock_csr;
741: END IF;
742: okl_api.set_message(g_fnd_app
743: ,g_form_unable_to_reserve_rec);
744: RAISE app_exceptions.record_lock_exception;
745: END;
746:

Line 748: okl_api.set_message(g_fnd_app

744: RAISE app_exceptions.record_lock_exception;
745: END;
746:
747: IF (l_row_notfound) THEN
748: okl_api.set_message(g_fnd_app
749: ,g_form_record_deleted);
750: RAISE okl_api.g_exception_error;
751: END IF;
752: okl_api.end_activity(x_msg_count

Line 750: RAISE okl_api.g_exception_error;

746:
747: IF (l_row_notfound) THEN
748: okl_api.set_message(g_fnd_app
749: ,g_form_record_deleted);
750: RAISE okl_api.g_exception_error;
751: END IF;
752: okl_api.end_activity(x_msg_count
753: ,x_msg_data);
754: EXCEPTION

Line 752: okl_api.end_activity(x_msg_count

748: okl_api.set_message(g_fnd_app
749: ,g_form_record_deleted);
750: RAISE okl_api.g_exception_error;
751: END IF;
752: okl_api.end_activity(x_msg_count
753: ,x_msg_data);
754: EXCEPTION
755: WHEN g_exception_halt_validation THEN
756: x_return_status := okl_api.handle_exceptions(l_api_name

Line 756: x_return_status := okl_api.handle_exceptions(l_api_name

752: okl_api.end_activity(x_msg_count
753: ,x_msg_data);
754: EXCEPTION
755: WHEN g_exception_halt_validation THEN
756: x_return_status := okl_api.handle_exceptions(l_api_name
757: ,g_pkg_name
758: ,'OKL_API.G_RET_STS_ERROR'
759: ,x_msg_count
760: ,x_msg_data

Line 758: ,'OKL_API.G_RET_STS_ERROR'

754: EXCEPTION
755: WHEN g_exception_halt_validation THEN
756: x_return_status := okl_api.handle_exceptions(l_api_name
757: ,g_pkg_name
758: ,'OKL_API.G_RET_STS_ERROR'
759: ,x_msg_count
760: ,x_msg_data
761: ,'_PVT');
762: WHEN okl_api.g_exception_error THEN

Line 762: WHEN okl_api.g_exception_error THEN

758: ,'OKL_API.G_RET_STS_ERROR'
759: ,x_msg_count
760: ,x_msg_data
761: ,'_PVT');
762: WHEN okl_api.g_exception_error THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name
765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count

Line 763: x_return_status := okl_api.handle_exceptions(l_api_name

759: ,x_msg_count
760: ,x_msg_data
761: ,'_PVT');
762: WHEN okl_api.g_exception_error THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name
765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data

Line 765: ,'OKL_API.G_RET_STS_ERROR'

761: ,'_PVT');
762: WHEN okl_api.g_exception_error THEN
763: x_return_status := okl_api.handle_exceptions(l_api_name
764: ,g_pkg_name
765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_unexpected_error THEN

Line 769: WHEN okl_api.g_exception_unexpected_error THEN

765: ,'OKL_API.G_RET_STS_ERROR'
766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
773: ,x_msg_count

Line 770: x_return_status := okl_api.handle_exceptions(l_api_name

766: ,x_msg_count
767: ,x_msg_data
768: ,'_PVT');
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
773: ,x_msg_count
774: ,x_msg_data

Line 772: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

768: ,'_PVT');
769: WHEN okl_api.g_exception_unexpected_error THEN
770: x_return_status := okl_api.handle_exceptions(l_api_name
771: ,g_pkg_name
772: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
773: ,x_msg_count
774: ,x_msg_data
775: ,'_PVT');
776: WHEN OTHERS THEN

Line 777: x_return_status := okl_api.handle_exceptions(l_api_name

773: ,x_msg_count
774: ,x_msg_data
775: ,'_PVT');
776: WHEN OTHERS THEN
777: x_return_status := okl_api.handle_exceptions(l_api_name
778: ,g_pkg_name
779: ,'OTHERS'
780: ,x_msg_count
781: ,x_msg_data

Line 797: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

793: ,x_msg_data OUT NOCOPY VARCHAR2
794: ,p_pamv_rec IN okl_pamv_rec) IS
795: l_api_version CONSTANT NUMBER := 1;
796: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
797: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
798: l_pamb_rec okl_pamb_rec;
799: l_pamtl_rec okl_pamtl_rec;
800:
801: BEGIN

Line 802: l_return_status := okl_api.start_activity(l_api_name

798: l_pamb_rec okl_pamb_rec;
799: l_pamtl_rec okl_pamtl_rec;
800:
801: BEGIN
802: l_return_status := okl_api.start_activity(l_api_name
803: ,g_pkg_name
804: ,p_init_msg_list
805: ,l_api_version
806: ,p_api_version

Line 810: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

806: ,p_api_version
807: ,'_PVT'
808: ,x_return_status);
809:
810: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
811: RAISE okl_api.g_exception_unexpected_error;
812: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
813: RAISE okl_api.g_exception_error;
814: END IF;

Line 811: RAISE okl_api.g_exception_unexpected_error;

807: ,'_PVT'
808: ,x_return_status);
809:
810: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
811: RAISE okl_api.g_exception_unexpected_error;
812: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
813: RAISE okl_api.g_exception_error;
814: END IF;
815:

Line 812: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

808: ,x_return_status);
809:
810: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
811: RAISE okl_api.g_exception_unexpected_error;
812: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
813: RAISE okl_api.g_exception_error;
814: END IF;
815:
816: --------------------------------------

Line 813: RAISE okl_api.g_exception_error;

809:
810: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
811: RAISE okl_api.g_exception_unexpected_error;
812: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
813: RAISE okl_api.g_exception_error;
814: END IF;
815:
816: --------------------------------------
817: -- Move VIEW record to "Child" records

Line 835: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

831: ,x_msg_count
832: ,x_msg_data
833: ,l_pamb_rec);
834:
835: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
836: RAISE okl_api.g_exception_unexpected_error;
837: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
838: RAISE okl_api.g_exception_error;
839: END IF;

Line 836: RAISE okl_api.g_exception_unexpected_error;

832: ,x_msg_data
833: ,l_pamb_rec);
834:
835: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
836: RAISE okl_api.g_exception_unexpected_error;
837: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
838: RAISE okl_api.g_exception_error;
839: END IF;
840: lock_row(p_init_msg_list

Line 837: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

833: ,l_pamb_rec);
834:
835: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
836: RAISE okl_api.g_exception_unexpected_error;
837: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
838: RAISE okl_api.g_exception_error;
839: END IF;
840: lock_row(p_init_msg_list
841: ,x_return_status

Line 838: RAISE okl_api.g_exception_error;

834:
835: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
836: RAISE okl_api.g_exception_unexpected_error;
837: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
838: RAISE okl_api.g_exception_error;
839: END IF;
840: lock_row(p_init_msg_list
841: ,x_return_status
842: ,x_msg_count

Line 846: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

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

Line 847: RAISE okl_api.g_exception_unexpected_error;

843: ,x_msg_data
844: ,l_pamtl_rec);
845:
846: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
847: RAISE okl_api.g_exception_unexpected_error;
848: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
849: RAISE okl_api.g_exception_error;
850: END IF;
851: okl_api.end_activity(x_msg_count

Line 848: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

844: ,l_pamtl_rec);
845:
846: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
847: RAISE okl_api.g_exception_unexpected_error;
848: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
849: RAISE okl_api.g_exception_error;
850: END IF;
851: okl_api.end_activity(x_msg_count
852: ,x_msg_data);

Line 849: RAISE okl_api.g_exception_error;

845:
846: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
847: RAISE okl_api.g_exception_unexpected_error;
848: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
849: RAISE okl_api.g_exception_error;
850: END IF;
851: okl_api.end_activity(x_msg_count
852: ,x_msg_data);
853: EXCEPTION

Line 851: okl_api.end_activity(x_msg_count

847: RAISE okl_api.g_exception_unexpected_error;
848: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
849: RAISE okl_api.g_exception_error;
850: END IF;
851: okl_api.end_activity(x_msg_count
852: ,x_msg_data);
853: EXCEPTION
854: WHEN g_exception_halt_validation THEN
855: x_return_status := okl_api.handle_exceptions(l_api_name

Line 855: x_return_status := okl_api.handle_exceptions(l_api_name

851: okl_api.end_activity(x_msg_count
852: ,x_msg_data);
853: EXCEPTION
854: WHEN g_exception_halt_validation THEN
855: x_return_status := okl_api.handle_exceptions(l_api_name
856: ,g_pkg_name
857: ,'OKL_API.G_RET_STS_ERROR'
858: ,x_msg_count
859: ,x_msg_data

Line 857: ,'OKL_API.G_RET_STS_ERROR'

853: EXCEPTION
854: WHEN g_exception_halt_validation THEN
855: x_return_status := okl_api.handle_exceptions(l_api_name
856: ,g_pkg_name
857: ,'OKL_API.G_RET_STS_ERROR'
858: ,x_msg_count
859: ,x_msg_data
860: ,'_PVT');
861: WHEN okl_api.g_exception_error THEN

Line 861: WHEN okl_api.g_exception_error THEN

857: ,'OKL_API.G_RET_STS_ERROR'
858: ,x_msg_count
859: ,x_msg_data
860: ,'_PVT');
861: WHEN okl_api.g_exception_error THEN
862: x_return_status := okl_api.handle_exceptions(l_api_name
863: ,g_pkg_name
864: ,'OKL_API.G_RET_STS_ERROR'
865: ,x_msg_count

Line 862: x_return_status := okl_api.handle_exceptions(l_api_name

858: ,x_msg_count
859: ,x_msg_data
860: ,'_PVT');
861: WHEN okl_api.g_exception_error THEN
862: x_return_status := okl_api.handle_exceptions(l_api_name
863: ,g_pkg_name
864: ,'OKL_API.G_RET_STS_ERROR'
865: ,x_msg_count
866: ,x_msg_data

Line 864: ,'OKL_API.G_RET_STS_ERROR'

860: ,'_PVT');
861: WHEN okl_api.g_exception_error THEN
862: x_return_status := okl_api.handle_exceptions(l_api_name
863: ,g_pkg_name
864: ,'OKL_API.G_RET_STS_ERROR'
865: ,x_msg_count
866: ,x_msg_data
867: ,'_PVT');
868: WHEN okl_api.g_exception_unexpected_error THEN

Line 868: WHEN okl_api.g_exception_unexpected_error THEN

864: ,'OKL_API.G_RET_STS_ERROR'
865: ,x_msg_count
866: ,x_msg_data
867: ,'_PVT');
868: WHEN okl_api.g_exception_unexpected_error THEN
869: x_return_status := okl_api.handle_exceptions(l_api_name
870: ,g_pkg_name
871: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
872: ,x_msg_count

Line 869: x_return_status := okl_api.handle_exceptions(l_api_name

865: ,x_msg_count
866: ,x_msg_data
867: ,'_PVT');
868: WHEN okl_api.g_exception_unexpected_error THEN
869: x_return_status := okl_api.handle_exceptions(l_api_name
870: ,g_pkg_name
871: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
872: ,x_msg_count
873: ,x_msg_data

Line 871: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

867: ,'_PVT');
868: WHEN okl_api.g_exception_unexpected_error THEN
869: x_return_status := okl_api.handle_exceptions(l_api_name
870: ,g_pkg_name
871: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
872: ,x_msg_count
873: ,x_msg_data
874: ,'_PVT');
875: WHEN OTHERS THEN

Line 876: x_return_status := okl_api.handle_exceptions(l_api_name

872: ,x_msg_count
873: ,x_msg_data
874: ,'_PVT');
875: WHEN OTHERS THEN
876: x_return_status := okl_api.handle_exceptions(l_api_name
877: ,g_pkg_name
878: ,'OTHERS'
879: ,x_msg_count
880: ,x_msg_data

Line 896: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

892: ,x_msg_data OUT NOCOPY VARCHAR2
893: ,p_pamv_tbl IN okl_pamv_tbl) IS
894: l_api_version CONSTANT NUMBER := 1;
895: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
896: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
897:
898: -- Begin Post-Generation Change
899: -- overall error status
900:

Line 901: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

897:
898: -- Begin Post-Generation Change
899: -- overall error status
900:
901: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
902:
903: -- End Post-Generation Change
904:
905: i NUMBER := 0;

Line 908: okl_api.init_msg_list(p_init_msg_list);

904:
905: i NUMBER := 0;
906:
907: BEGIN
908: okl_api.init_msg_list(p_init_msg_list);
909:
910: -- Make sure PL/SQL table has records in it before passing
911:
912: IF (p_pamv_tbl.COUNT > 0) THEN

Line 917: ,p_init_msg_list => okl_api.g_false

913: i := p_pamv_tbl.FIRST;
914:
915: LOOP
916: lock_row(p_api_version => p_api_version
917: ,p_init_msg_list => okl_api.g_false
918: ,x_return_status => x_return_status
919: ,x_msg_count => x_msg_count
920: ,x_msg_data => x_msg_data
921: ,p_pamv_rec => p_pamv_tbl(i));

Line 926: IF x_return_status <> okl_api.g_ret_sts_success THEN

922:
923: -- Begin Post-Generation Change
924: -- store the highest degree of error
925:
926: IF x_return_status <> okl_api.g_ret_sts_success THEN
927: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
928: l_overall_status := x_return_status;
929: END IF;
930: END IF;

Line 927: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

923: -- Begin Post-Generation Change
924: -- store the highest degree of error
925:
926: IF x_return_status <> okl_api.g_ret_sts_success THEN
927: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
928: l_overall_status := x_return_status;
929: END IF;
930: END IF;
931:

Line 949: x_return_status := okl_api.handle_exceptions(l_api_name

945: END IF;
946:
947: EXCEPTION
948: WHEN g_exception_halt_validation THEN
949: x_return_status := okl_api.handle_exceptions(l_api_name
950: ,g_pkg_name
951: ,'OKL_API.G_RET_STS_ERROR'
952: ,x_msg_count
953: ,x_msg_data

Line 951: ,'OKL_API.G_RET_STS_ERROR'

947: EXCEPTION
948: WHEN g_exception_halt_validation THEN
949: x_return_status := okl_api.handle_exceptions(l_api_name
950: ,g_pkg_name
951: ,'OKL_API.G_RET_STS_ERROR'
952: ,x_msg_count
953: ,x_msg_data
954: ,'_PVT');
955: WHEN okl_api.g_exception_error THEN

Line 955: WHEN okl_api.g_exception_error THEN

951: ,'OKL_API.G_RET_STS_ERROR'
952: ,x_msg_count
953: ,x_msg_data
954: ,'_PVT');
955: WHEN okl_api.g_exception_error THEN
956: x_return_status := okl_api.handle_exceptions(l_api_name
957: ,g_pkg_name
958: ,'OKL_API.G_RET_STS_ERROR'
959: ,x_msg_count

Line 956: x_return_status := okl_api.handle_exceptions(l_api_name

952: ,x_msg_count
953: ,x_msg_data
954: ,'_PVT');
955: WHEN okl_api.g_exception_error THEN
956: x_return_status := okl_api.handle_exceptions(l_api_name
957: ,g_pkg_name
958: ,'OKL_API.G_RET_STS_ERROR'
959: ,x_msg_count
960: ,x_msg_data

Line 958: ,'OKL_API.G_RET_STS_ERROR'

954: ,'_PVT');
955: WHEN okl_api.g_exception_error THEN
956: x_return_status := okl_api.handle_exceptions(l_api_name
957: ,g_pkg_name
958: ,'OKL_API.G_RET_STS_ERROR'
959: ,x_msg_count
960: ,x_msg_data
961: ,'_PVT');
962: WHEN okl_api.g_exception_unexpected_error THEN

Line 962: WHEN okl_api.g_exception_unexpected_error THEN

958: ,'OKL_API.G_RET_STS_ERROR'
959: ,x_msg_count
960: ,x_msg_data
961: ,'_PVT');
962: WHEN okl_api.g_exception_unexpected_error THEN
963: x_return_status := okl_api.handle_exceptions(l_api_name
964: ,g_pkg_name
965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
966: ,x_msg_count

Line 963: x_return_status := okl_api.handle_exceptions(l_api_name

959: ,x_msg_count
960: ,x_msg_data
961: ,'_PVT');
962: WHEN okl_api.g_exception_unexpected_error THEN
963: x_return_status := okl_api.handle_exceptions(l_api_name
964: ,g_pkg_name
965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
966: ,x_msg_count
967: ,x_msg_data

Line 965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

961: ,'_PVT');
962: WHEN okl_api.g_exception_unexpected_error THEN
963: x_return_status := okl_api.handle_exceptions(l_api_name
964: ,g_pkg_name
965: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
966: ,x_msg_count
967: ,x_msg_data
968: ,'_PVT');
969: WHEN OTHERS THEN

Line 970: x_return_status := okl_api.handle_exceptions(l_api_name

966: ,x_msg_count
967: ,x_msg_data
968: ,'_PVT');
969: WHEN OTHERS THEN
970: x_return_status := okl_api.handle_exceptions(l_api_name
971: ,g_pkg_name
972: ,'OTHERS'
973: ,x_msg_count
974: ,x_msg_data

Line 989: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

985:
986: -- validation of Adjusment Matrix Id
987:
988: FUNCTION validate_adj_mat_id(p_adj_mat_id IN NUMBER) RETURN VARCHAR2 IS
989: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
990:
991: BEGIN
992:
993: -- ADJ_MAT_ID is a required field

Line 995: IF (p_adj_mat_id IS NULL OR p_adj_mat_id = okl_api.g_miss_num) THEN

991: BEGIN
992:
993: -- ADJ_MAT_ID is a required field
994:
995: IF (p_adj_mat_id IS NULL OR p_adj_mat_id = okl_api.g_miss_num) THEN
996: okl_api.set_message(p_app_name => g_app_name
997: ,p_msg_name => g_required_value
998: ,p_token1 => g_col_name_token
999: ,p_token1_value => 'ADJ_MAT_ID');

Line 996: okl_api.set_message(p_app_name => g_app_name

992:
993: -- ADJ_MAT_ID is a required field
994:
995: IF (p_adj_mat_id IS NULL OR p_adj_mat_id = okl_api.g_miss_num) THEN
996: okl_api.set_message(p_app_name => g_app_name
997: ,p_msg_name => g_required_value
998: ,p_token1 => g_col_name_token
999: ,p_token1_value => 'ADJ_MAT_ID');
1000:

Line 1003: l_return_status := okl_api.g_ret_sts_error;

999: ,p_token1_value => 'ADJ_MAT_ID');
1000:
1001: -- notify caller of an error
1002:
1003: l_return_status := okl_api.g_ret_sts_error;
1004:
1005: -- halt further validation of this column
1006:
1007: RAISE g_exception_halt_validation;

Line 1020: okl_api.set_message(p_app_name => g_app_name

1016: WHEN OTHERS THEN
1017:
1018: -- store SQL error message on message stack for caller
1019:
1020: okl_api.set_message(p_app_name => g_app_name
1021: ,p_msg_name => g_unexpected_error
1022: ,p_token1 => g_sqlcode_token
1023: ,p_token1_value => sqlcode
1024: ,p_token2 => g_sqlerrm_token

Line 1029: l_return_status := okl_api.g_ret_sts_unexp_error;

1025: ,p_token2_value => sqlerrm);
1026:
1027: -- notify caller of an UNEXPECTED error
1028:
1029: l_return_status := okl_api.g_ret_sts_unexp_error;
1030: RETURN(l_return_status);
1031: END validate_adj_mat_id;
1032:
1033: -- Validation of the org Id

Line 1036: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1032:
1033: -- Validation of the org Id
1034:
1035: FUNCTION validate_org_id(p_org_id IN NUMBER) RETURN VARCHAR2 IS
1036: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1037:
1038: BEGIN
1039:
1040: -- data is required

Line 1042: IF (p_org_id IS NULL) OR (p_org_id = okl_api.g_miss_num) THEN

1038: BEGIN
1039:
1040: -- data is required
1041:
1042: IF (p_org_id IS NULL) OR (p_org_id = okl_api.g_miss_num) THEN
1043: okl_api.set_message(p_app_name => g_app_name
1044: ,p_msg_name => g_required_value
1045: ,p_token1 => g_col_name_token
1046: ,p_token1_value => 'org_id');

Line 1043: okl_api.set_message(p_app_name => g_app_name

1039:
1040: -- data is required
1041:
1042: IF (p_org_id IS NULL) OR (p_org_id = okl_api.g_miss_num) THEN
1043: okl_api.set_message(p_app_name => g_app_name
1044: ,p_msg_name => g_required_value
1045: ,p_token1 => g_col_name_token
1046: ,p_token1_value => 'org_id');
1047: x_return_status := okl_api.g_ret_sts_error;

Line 1047: x_return_status := okl_api.g_ret_sts_error;

1043: okl_api.set_message(p_app_name => g_app_name
1044: ,p_msg_name => g_required_value
1045: ,p_token1 => g_col_name_token
1046: ,p_token1_value => 'org_id');
1047: x_return_status := okl_api.g_ret_sts_error;
1048:
1049: -- halt further validation of this column
1050:
1051: RAISE g_exception_halt_validation;

Line 1058: IF (x_return_status = okl_api.g_ret_sts_error) THEN

1054: -- check org id validity using the generic function okl_util.check_org_id()
1055:
1056: x_return_status := okl_util.check_org_id(TO_CHAR(p_org_id));
1057:
1058: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1059: okl_api.set_message(p_app_name => g_app_name
1060: ,p_msg_name => g_invalid_value
1061: ,p_token1 => g_col_name_token
1062: ,p_token1_value => 'org_id');

Line 1059: okl_api.set_message(p_app_name => g_app_name

1055:
1056: x_return_status := okl_util.check_org_id(TO_CHAR(p_org_id));
1057:
1058: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1059: okl_api.set_message(p_app_name => g_app_name
1060: ,p_msg_name => g_invalid_value
1061: ,p_token1 => g_col_name_token
1062: ,p_token1_value => 'org_id');
1063:

Line 1067: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1063:
1064: -- notify caller of an error
1065:
1066: RAISE g_exception_halt_validation;
1067: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1068:
1069: -- notify caller of an error
1070:
1071: RAISE g_exception_halt_validation;

Line 1084: okl_api.set_message(p_app_name => g_app_name

1080: WHEN OTHERS THEN
1081:
1082: -- store SQL error message on message stack for caller
1083:
1084: okl_api.set_message(p_app_name => g_app_name
1085: ,p_msg_name => g_unexpected_error
1086: ,p_token1 => g_sqlcode_token
1087: ,p_token1_value => sqlcode
1088: ,p_token2 => g_sqlerrm_token

Line 1093: x_return_status := okl_api.g_ret_sts_unexp_error;

1089: ,p_token2_value => sqlerrm);
1090:
1091: -- notify caller of an UNEXPECTED error
1092:
1093: x_return_status := okl_api.g_ret_sts_unexp_error;
1094: RETURN(x_return_status);
1095: END validate_org_id;
1096:
1097: -- Validation of the currency code

Line 1103: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1099: FUNCTION validate_currency_code(p_currency_code IN VARCHAR2) RETURN VARCHAR2 IS
1100:
1101: -- initialize the return status
1102:
1103: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1104:
1105: BEGIN
1106:
1107: -- data is required

Line 1109: IF (p_currency_code IS NULL) OR (p_currency_code = okl_api.g_miss_char) THEN

1105: BEGIN
1106:
1107: -- data is required
1108:
1109: IF (p_currency_code IS NULL) OR (p_currency_code = okl_api.g_miss_char) THEN
1110: okl_api.set_message(p_app_name => g_app_name
1111: ,p_msg_name => g_required_value
1112: ,p_token1 => g_col_name_token
1113: ,p_token1_value => 'currency_code');

Line 1110: okl_api.set_message(p_app_name => g_app_name

1106:
1107: -- data is required
1108:
1109: IF (p_currency_code IS NULL) OR (p_currency_code = okl_api.g_miss_char) THEN
1110: okl_api.set_message(p_app_name => g_app_name
1111: ,p_msg_name => g_required_value
1112: ,p_token1 => g_col_name_token
1113: ,p_token1_value => 'currency_code');
1114:

Line 1124: IF (x_return_status <> okl_api.g_true) THEN

1120: -- check from currency values using the generic okl_util.validate_currency_code
1121:
1122: x_return_status := okl_accounting_util.validate_currency_code(p_currency_code);
1123:
1124: IF (x_return_status <> okl_api.g_true) THEN
1125: okl_api.set_message(p_app_name => g_app_name
1126: ,p_msg_name => g_invalid_value
1127: ,p_token1 => g_col_name_token
1128: ,p_token1_value => 'currency_code');

Line 1125: okl_api.set_message(p_app_name => g_app_name

1121:
1122: x_return_status := okl_accounting_util.validate_currency_code(p_currency_code);
1123:
1124: IF (x_return_status <> okl_api.g_true) THEN
1125: okl_api.set_message(p_app_name => g_app_name
1126: ,p_msg_name => g_invalid_value
1127: ,p_token1 => g_col_name_token
1128: ,p_token1_value => 'currency_code');
1129:

Line 1137: x_return_status := okl_api.g_ret_sts_error;

1133: END IF;
1134: RETURN(x_return_status);
1135: EXCEPTION
1136: WHEN g_exception_halt_validation THEN
1137: x_return_status := okl_api.g_ret_sts_error;
1138: RETURN(x_return_status);
1139: WHEN OTHERS THEN
1140:
1141: -- store SQL error message on message stack for caller

Line 1143: okl_api.set_message(p_app_name => g_app_name

1139: WHEN OTHERS THEN
1140:
1141: -- store SQL error message on message stack for caller
1142:
1143: okl_api.set_message(p_app_name => g_app_name
1144: ,p_msg_name => g_unexpected_error
1145: ,p_token1 => g_sqlcode_token
1146: ,p_token1_value => sqlcode
1147: ,p_token2 => g_sqlerrm_token

Line 1152: x_return_status := okl_api.g_ret_sts_unexp_error;

1148: ,p_token2_value => sqlerrm);
1149:
1150: -- notify caller of an UNEXPECTED error
1151:
1152: x_return_status := okl_api.g_ret_sts_unexp_error;
1153: RETURN(x_return_status);
1154: END validate_currency_code;
1155:
1156: FUNCTION validate_adj_mat_type_code(p_adj_mat_type_code IN VARCHAR2) RETURN VARCHAR2 IS

Line 1157: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1153: RETURN(x_return_status);
1154: END validate_currency_code;
1155:
1156: FUNCTION validate_adj_mat_type_code(p_adj_mat_type_code IN VARCHAR2) RETURN VARCHAR2 IS
1157: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1158:
1159: BEGIN
1160:
1161: IF (p_adj_mat_type_code IS NULL) OR (p_adj_mat_type_code = okl_api.g_miss_char) THEN

Line 1161: IF (p_adj_mat_type_code IS NULL) OR (p_adj_mat_type_code = okl_api.g_miss_char) THEN

1157: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1158:
1159: BEGIN
1160:
1161: IF (p_adj_mat_type_code IS NULL) OR (p_adj_mat_type_code = okl_api.g_miss_char) THEN
1162: okl_api.set_message(p_app_name => g_app_name
1163: ,p_msg_name => g_required_value
1164: ,p_token1 => g_col_name_token
1165: ,p_token1_value => 'ADJ_MAT_TYPE_CODE');

Line 1162: okl_api.set_message(p_app_name => g_app_name

1158:
1159: BEGIN
1160:
1161: IF (p_adj_mat_type_code IS NULL) OR (p_adj_mat_type_code = okl_api.g_miss_char) THEN
1162: okl_api.set_message(p_app_name => g_app_name
1163: ,p_msg_name => g_required_value
1164: ,p_token1 => g_col_name_token
1165: ,p_token1_value => 'ADJ_MAT_TYPE_CODE');
1166:

Line 1169: x_return_status := okl_api.g_ret_sts_error;

1165: ,p_token1_value => 'ADJ_MAT_TYPE_CODE');
1166:
1167: -- notify caller of an error
1168:
1169: x_return_status := okl_api.g_ret_sts_error;
1170:
1171: -- halt further validation of this column
1172:
1173: RAISE g_exception_halt_validation;

Line 1181: IF (x_return_status = okl_api.g_ret_sts_error) THEN

1177:
1178: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ADJ_MAT_TYPES'
1179: ,p_lookup_code => p_adj_mat_type_code);
1180:
1181: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1182: okl_api.set_message(p_app_name => g_app_name
1183: ,p_msg_name => g_invalid_value
1184: ,p_token1 => g_col_name_token
1185: ,p_token1_value => 'ADJ_MAT_TYPE_CODE'); -- notify caller of an error

Line 1182: okl_api.set_message(p_app_name => g_app_name

1178: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_ADJ_MAT_TYPES'
1179: ,p_lookup_code => p_adj_mat_type_code);
1180:
1181: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1182: okl_api.set_message(p_app_name => g_app_name
1183: ,p_msg_name => g_invalid_value
1184: ,p_token1 => g_col_name_token
1185: ,p_token1_value => 'ADJ_MAT_TYPE_CODE'); -- notify caller of an error
1186: RAISE g_exception_halt_validation;

Line 1187: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1183: ,p_msg_name => g_invalid_value
1184: ,p_token1 => g_col_name_token
1185: ,p_token1_value => 'ADJ_MAT_TYPE_CODE'); -- notify caller of an error
1186: RAISE g_exception_halt_validation;
1187: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1188:
1189: -- notify caller of an error
1190:
1191: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 1191: x_return_status := okl_api.g_ret_sts_unexp_error;

1187: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1188:
1189: -- notify caller of an error
1190:
1191: x_return_status := okl_api.g_ret_sts_unexp_error;
1192: RAISE g_exception_halt_validation;
1193: END IF;
1194: RETURN(x_return_status);
1195: EXCEPTION

Line 1206: okl_api.set_message(p_app_name => g_app_name

1202: WHEN OTHERS THEN
1203:
1204: -- store SQL error message on message stack for caller
1205:
1206: okl_api.set_message(p_app_name => g_app_name
1207: ,p_msg_name => g_unexpected_error
1208: ,p_token1 => g_sqlcode_token
1209: ,p_token1_value => sqlcode
1210: ,p_token2 => g_sqlerrm_token

Line 1215: x_return_status := okl_api.g_ret_sts_unexp_error;

1211: ,p_token2_value => sqlerrm);
1212:
1213: -- notify caller of an UNEXPECTED error
1214:
1215: x_return_status := okl_api.g_ret_sts_unexp_error;
1216: RETURN(x_return_status);
1217: END validate_adj_mat_type_code;
1218:
1219: FUNCTION validate_orig_adj_mat_id(p_orig_adj_mat_id IN NUMBER) RETURN VARCHAR2 IS

Line 1220: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1216: RETURN(x_return_status);
1217: END validate_adj_mat_type_code;
1218:
1219: FUNCTION validate_orig_adj_mat_id(p_orig_adj_mat_id IN NUMBER) RETURN VARCHAR2 IS
1220: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1221:
1222: CURSOR adj_matrix_exists_csr IS
1223: SELECT 'x'
1224: FROM okl_fe_adj_mat_all_b

Line 1230: IF (p_orig_adj_mat_id IS NOT NULL AND p_orig_adj_mat_id <> okl_api.g_miss_num) THEN

1226: l_dummy_var VARCHAR2(1) := '?';
1227:
1228: BEGIN
1229:
1230: IF (p_orig_adj_mat_id IS NOT NULL AND p_orig_adj_mat_id <> okl_api.g_miss_num) THEN
1231: OPEN adj_matrix_exists_csr;
1232: FETCH adj_matrix_exists_csr INTO l_dummy_var ;
1233: CLOSE adj_matrix_exists_csr;
1234:

Line 1238: okl_api.set_message(p_app_name => g_app_name

1234:
1235: -- if l_dummy_var is still set to default, data was not found
1236:
1237: IF (l_dummy_var = '?') THEN
1238: okl_api.set_message(p_app_name => g_app_name
1239: ,p_msg_name => g_invalid_value
1240: ,p_token1 => g_col_name_token
1241: ,p_token1_value => 'ORIG_ADJ_MAT_ID');
1242:

Line 1245: x_return_status := okl_api.g_ret_sts_error;

1241: ,p_token1_value => 'ORIG_ADJ_MAT_ID');
1242:
1243: -- notify caller of an error
1244:
1245: x_return_status := okl_api.g_ret_sts_error;
1246: RAISE g_exception_halt_validation;
1247: END IF;
1248: END IF;
1249: RETURN x_return_status;

Line 1261: okl_api.set_message(p_app_name => g_app_name

1257: WHEN OTHERS THEN
1258:
1259: -- store SQL error message on message stack for caller
1260:
1261: okl_api.set_message(p_app_name => g_app_name
1262: ,p_msg_name => g_unexpected_error
1263: ,p_token1 => g_sqlcode_token
1264: ,p_token1_value => sqlcode
1265: ,p_token2 => g_sqlerrm_token

Line 1270: x_return_status := okl_api.g_ret_sts_unexp_error;

1266: ,p_token2_value => sqlerrm);
1267:
1268: -- notify caller of an UNEXPECTED error
1269:
1270: x_return_status := okl_api.g_ret_sts_unexp_error;
1271:
1272: -- verify that cursor was closed
1273:
1274: IF adj_matrix_exists_csr%ISOPEN THEN

Line 1284: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1280: FUNCTION validate_sts_code(p_sts_code IN VARCHAR2) RETURN VARCHAR2 IS
1281:
1282: --initialize the Return Status
1283:
1284: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1285:
1286: BEGIN
1287:
1288: -- Column is mandatory

Line 1290: IF (p_sts_code IS NULL OR p_sts_code = okl_api.g_miss_char) THEN

1286: BEGIN
1287:
1288: -- Column is mandatory
1289:
1290: IF (p_sts_code IS NULL OR p_sts_code = okl_api.g_miss_char) THEN
1291: okl_api.set_message(p_app_name => g_app_name
1292: ,p_msg_name => g_required_value
1293: ,p_token1 => g_col_name_token
1294: ,p_token1_value => 'sts_code');

Line 1291: okl_api.set_message(p_app_name => g_app_name

1287:
1288: -- Column is mandatory
1289:
1290: IF (p_sts_code IS NULL OR p_sts_code = okl_api.g_miss_char) THEN
1291: okl_api.set_message(p_app_name => g_app_name
1292: ,p_msg_name => g_required_value
1293: ,p_token1 => g_col_name_token
1294: ,p_token1_value => 'sts_code');
1295:

Line 1298: x_return_status := okl_api.g_ret_sts_error;

1294: ,p_token1_value => 'sts_code');
1295:
1296: -- notify caller of an error
1297:
1298: x_return_status := okl_api.g_ret_sts_error;
1299: RAISE g_exception_halt_validation;
1300: END IF;
1301:
1302: -- Lookup Code Validation

Line 1307: IF (x_return_status = okl_api.g_ret_sts_error) THEN

1303:
1304: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
1305: ,p_lookup_code => p_sts_code);
1306:
1307: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1308: okl_api.set_message(p_app_name => g_app_name
1309: ,p_msg_name => g_invalid_value
1310: ,p_token1 => g_col_name_token
1311: ,p_token1_value => 'sts_code'); -- notify caller of an error

Line 1308: okl_api.set_message(p_app_name => g_app_name

1304: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
1305: ,p_lookup_code => p_sts_code);
1306:
1307: IF (x_return_status = okl_api.g_ret_sts_error) THEN
1308: okl_api.set_message(p_app_name => g_app_name
1309: ,p_msg_name => g_invalid_value
1310: ,p_token1 => g_col_name_token
1311: ,p_token1_value => 'sts_code'); -- notify caller of an error
1312: RAISE g_exception_halt_validation;

Line 1313: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1309: ,p_msg_name => g_invalid_value
1310: ,p_token1 => g_col_name_token
1311: ,p_token1_value => 'sts_code'); -- notify caller of an error
1312: RAISE g_exception_halt_validation;
1313: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1314:
1315: -- notify caller of an error
1316:
1317: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 1317: x_return_status := okl_api.g_ret_sts_unexp_error;

1313: ELSIF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1314:
1315: -- notify caller of an error
1316:
1317: x_return_status := okl_api.g_ret_sts_unexp_error;
1318: RAISE g_exception_halt_validation;
1319: END IF;
1320: RETURN x_return_status;
1321: EXCEPTION

Line 1332: okl_api.set_message(p_app_name => g_app_name

1328: WHEN OTHERS THEN
1329:
1330: -- store SQL error message on message stack for caller
1331:
1332: okl_api.set_message(p_app_name => g_app_name
1333: ,p_msg_name => g_unexpected_error
1334: ,p_token1 => g_sqlcode_token
1335: ,p_token1_value => sqlcode
1336: ,p_token2 => g_sqlerrm_token

Line 1341: x_return_status := okl_api.g_ret_sts_unexp_error;

1337: ,p_token2_value => sqlerrm);
1338:
1339: -- notify caller of an UNEXPECTED error
1340:
1341: x_return_status := okl_api.g_ret_sts_unexp_error;
1342: RETURN x_return_status;
1343: END validate_sts_code;
1344:
1345: FUNCTION validate_effective_from_date(p_effective_from_date IN DATE) RETURN VARCHAR2 IS

Line 1349: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1345: FUNCTION validate_effective_from_date(p_effective_from_date IN DATE) RETURN VARCHAR2 IS
1346:
1347: -- initialize the return status
1348:
1349: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1350:
1351: BEGIN
1352:
1353: IF (p_effective_from_date IS NULL OR p_effective_from_date = okl_api.g_miss_date) THEN

Line 1353: IF (p_effective_from_date IS NULL OR p_effective_from_date = okl_api.g_miss_date) THEN

1349: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1350:
1351: BEGIN
1352:
1353: IF (p_effective_from_date IS NULL OR p_effective_from_date = okl_api.g_miss_date) THEN
1354: okl_api.set_message(p_app_name => g_app_name
1355: ,p_msg_name => g_required_value
1356: ,p_token1 => g_col_name_token
1357: ,p_token1_value => 'EFFECTIVE_FROM_DATE');

Line 1354: okl_api.set_message(p_app_name => g_app_name

1350:
1351: BEGIN
1352:
1353: IF (p_effective_from_date IS NULL OR p_effective_from_date = okl_api.g_miss_date) THEN
1354: okl_api.set_message(p_app_name => g_app_name
1355: ,p_msg_name => g_required_value
1356: ,p_token1 => g_col_name_token
1357: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
1358:

Line 1361: x_return_status := okl_api.g_ret_sts_error;

1357: ,p_token1_value => 'EFFECTIVE_FROM_DATE');
1358:
1359: -- notify caller of an error
1360:
1361: x_return_status := okl_api.g_ret_sts_error;
1362: RAISE g_exception_halt_validation;
1363: END IF;
1364: RETURN x_return_status;
1365: EXCEPTION

Line 1376: okl_api.set_message(p_app_name => g_app_name

1372: WHEN OTHERS THEN
1373:
1374: -- store SQL error message on message stack for caller
1375:
1376: okl_api.set_message(p_app_name => g_app_name
1377: ,p_msg_name => g_unexpected_error
1378: ,p_token1 => g_sqlcode_token
1379: ,p_token1_value => sqlcode
1380: ,p_token2 => g_sqlerrm_token

Line 1385: x_return_status := okl_api.g_ret_sts_unexp_error;

1381: ,p_token2_value => sqlerrm);
1382:
1383: -- notify caller of an UNEXPECTED error
1384:
1385: x_return_status := okl_api.g_ret_sts_unexp_error;
1386: RETURN x_return_status;
1387: END validate_effective_from_date;
1388:
1389: FUNCTION validate_attributes(p_pamv_rec IN okl_pamv_rec) RETURN VARCHAR2 IS

Line 1390: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1386: RETURN x_return_status;
1387: END validate_effective_from_date;
1388:
1389: FUNCTION validate_attributes(p_pamv_rec IN okl_pamv_rec) RETURN VARCHAR2 IS
1390: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1391: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1392:
1393: BEGIN
1394:

Line 1391: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1387: END validate_effective_from_date;
1388:
1389: FUNCTION validate_attributes(p_pamv_rec IN okl_pamv_rec) RETURN VARCHAR2 IS
1390: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1391: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1392:
1393: BEGIN
1394:
1395: -- validate the adjustment matrix id

Line 1401: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1397: l_return_status := validate_adj_mat_id(p_pamv_rec.adj_mat_id);
1398:
1399: -- store the highest degree of error
1400:
1401: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1402: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1403: x_return_status := l_return_status;
1404: END IF;
1405: END IF;

Line 1402: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1398:
1399: -- store the highest degree of error
1400:
1401: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1402: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1403: x_return_status := l_return_status;
1404: END IF;
1405: END IF;
1406:

Line 1413: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1409: l_return_status := validate_org_id(p_pamv_rec.org_id);
1410:
1411: -- store the highest degree of error
1412:
1413: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1414: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1415: x_return_status := l_return_status;
1416: END IF;
1417: END IF;

Line 1414: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1410:
1411: -- store the highest degree of error
1412:
1413: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1414: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1415: x_return_status := l_return_status;
1416: END IF;
1417: END IF;
1418:

Line 1425: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1421: l_return_status := validate_currency_code(p_pamv_rec.currency_code);
1422:
1423: -- store the highest degree of error
1424:
1425: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1426: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1427: x_return_status := l_return_status;
1428: END IF;
1429: END IF;

Line 1426: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1422:
1423: -- store the highest degree of error
1424:
1425: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1426: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1427: x_return_status := l_return_status;
1428: END IF;
1429: END IF;
1430:

Line 1437: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1433: l_return_status := validate_adj_mat_type_code(p_pamv_rec.adj_mat_type_code);
1434:
1435: -- store the highest degree of error
1436:
1437: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1438: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1439: x_return_status := l_return_status;
1440: END IF;
1441: END IF;

Line 1438: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1434:
1435: -- store the highest degree of error
1436:
1437: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1438: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1439: x_return_status := l_return_status;
1440: END IF;
1441: END IF;
1442:

Line 1449: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1445: l_return_status := validate_orig_adj_mat_id(p_pamv_rec.orig_adj_mat_id);
1446:
1447: -- store the highest degree of error
1448:
1449: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1450: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1451: x_return_status := l_return_status;
1452: END IF;
1453: END IF;

Line 1450: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1446:
1447: -- store the highest degree of error
1448:
1449: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1450: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1451: x_return_status := l_return_status;
1452: END IF;
1453: END IF;
1454:

Line 1461: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1457: l_return_status := validate_sts_code(p_pamv_rec.sts_code);
1458:
1459: -- store the highest degree of error
1460:
1461: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1462: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1463: x_return_status := l_return_status;
1464: END IF;
1465: END IF;

Line 1462: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1458:
1459: -- store the highest degree of error
1460:
1461: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1462: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1463: x_return_status := l_return_status;
1464: END IF;
1465: END IF;
1466:

Line 1473: IF (l_return_status <> okl_api.g_ret_sts_success) THEN

1469: l_return_status := validate_effective_from_date(p_pamv_rec.effective_from_date);
1470:
1471: -- store the highest degree of error
1472:
1473: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1474: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1475: x_return_status := l_return_status;
1476: END IF;
1477: END IF;

Line 1474: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN

1470:
1471: -- store the highest degree of error
1472:
1473: IF (l_return_status <> okl_api.g_ret_sts_success) THEN
1474: IF (x_return_status <> okl_api.g_ret_sts_unexp_error) THEN
1475: x_return_status := l_return_status;
1476: END IF;
1477: END IF;
1478: RETURN(x_return_status);

Line 1482: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1478: RETURN(x_return_status);
1479: END validate_attributes;
1480:
1481: FUNCTION validate_record(p_pamv_rec IN okl_pamv_rec) RETURN VARCHAR2 IS
1482: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1483: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1484:
1485: BEGIN
1486:

Line 1483: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1479: END validate_attributes;
1480:
1481: FUNCTION validate_record(p_pamv_rec IN okl_pamv_rec) RETURN VARCHAR2 IS
1482: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1483: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1484:
1485: BEGIN
1486:
1487: IF (p_pamv_rec.effective_to_date IS NOT NULL) THEN

Line 1489: okl_api.set_message(p_app_name => g_app_name

1485: BEGIN
1486:
1487: IF (p_pamv_rec.effective_to_date IS NOT NULL) THEN
1488: IF (p_pamv_rec.effective_from_date > p_pamv_rec.effective_to_date) THEN
1489: okl_api.set_message(p_app_name => g_app_name
1490: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1491: x_return_status := okl_api.g_ret_sts_error;
1492: END IF;
1493: END IF;

Line 1491: x_return_status := okl_api.g_ret_sts_error;

1487: IF (p_pamv_rec.effective_to_date IS NOT NULL) THEN
1488: IF (p_pamv_rec.effective_from_date > p_pamv_rec.effective_to_date) THEN
1489: okl_api.set_message(p_app_name => g_app_name
1490: ,p_msg_name => 'OKL_INVALID_EFFECTIVE_TO');
1491: x_return_status := okl_api.g_ret_sts_error;
1492: END IF;
1493: END IF;
1494: RETURN x_return_status;
1495: EXCEPTION

Line 1498: x_return_status := okl_api.g_ret_sts_error;

1494: RETURN x_return_status;
1495: EXCEPTION
1496: WHEN g_exception_halt_validation THEN
1497: NULL;
1498: x_return_status := okl_api.g_ret_sts_error;
1499: RETURN x_return_status;
1500: WHEN OTHERS THEN
1501:
1502: -- store SQL error message on message stack for caller

Line 1504: okl_api.set_message(p_app_name => g_app_name

1500: WHEN OTHERS THEN
1501:
1502: -- store SQL error message on message stack for caller
1503:
1504: okl_api.set_message(p_app_name => g_app_name
1505: ,p_msg_name => g_unexpected_error
1506: ,p_token1 => g_sqlcode_token
1507: ,p_token1_value => sqlcode
1508: ,p_token2 => g_sqlerrm_token

Line 1513: x_return_status := okl_api.g_ret_sts_error;

1509: ,p_token2_value => sqlerrm);
1510:
1511: -- notify caller of an UNEXPECTED error
1512:
1513: x_return_status := okl_api.g_ret_sts_error;
1514: RETURN(x_return_status);
1515: END validate_record;
1516:
1517: --------------------------------------------------------------------------------

Line 1522: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1518: -- Procedure insert_row_b
1519: --------------------------------------------------------------------------------
1520:
1521: PROCEDURE insert_row(p_api_version IN NUMBER
1522: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1523: ,x_return_status OUT NOCOPY VARCHAR2
1524: ,x_msg_count OUT NOCOPY NUMBER
1525: ,x_msg_data OUT NOCOPY VARCHAR2
1526: ,p_pamb_rec IN okl_pamb_rec

Line 1530: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1526: ,p_pamb_rec IN okl_pamb_rec
1527: ,x_pamb_rec OUT NOCOPY okl_pamb_rec) IS
1528: l_api_version CONSTANT NUMBER := 1;
1529: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1530: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1531: l_pamb_rec okl_pamb_rec := p_pamb_rec;
1532:
1533: FUNCTION set_attributes(p_pamb_rec IN okl_pamb_rec
1534: ,x_pamb_rec OUT NOCOPY okl_pamb_rec) RETURN VARCHAR2 IS

Line 1535: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1531: l_pamb_rec okl_pamb_rec := p_pamb_rec;
1532:
1533: FUNCTION set_attributes(p_pamb_rec IN okl_pamb_rec
1534: ,x_pamb_rec OUT NOCOPY okl_pamb_rec) RETURN VARCHAR2 IS
1535: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1536:
1537: BEGIN
1538: x_pamb_rec := p_pamb_rec;
1539: RETURN(l_return_status);

Line 1543: l_return_status := okl_api.start_activity(l_api_name

1539: RETURN(l_return_status);
1540: END set_attributes;
1541:
1542: BEGIN
1543: l_return_status := okl_api.start_activity(l_api_name
1544: ,g_pkg_name
1545: ,p_init_msg_list
1546: ,l_api_version
1547: ,p_api_version

Line 1551: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1547: ,p_api_version
1548: ,'_PVT'
1549: ,x_return_status);
1550:
1551: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1552: RAISE okl_api.g_exception_unexpected_error;
1553: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1554: RAISE okl_api.g_exception_error;
1555: END IF;

Line 1552: RAISE okl_api.g_exception_unexpected_error;

1548: ,'_PVT'
1549: ,x_return_status);
1550:
1551: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1552: RAISE okl_api.g_exception_unexpected_error;
1553: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1554: RAISE okl_api.g_exception_error;
1555: END IF;
1556:

Line 1553: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1549: ,x_return_status);
1550:
1551: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1552: RAISE okl_api.g_exception_unexpected_error;
1553: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1554: RAISE okl_api.g_exception_error;
1555: END IF;
1556:
1557: --Setting Item Attributes

Line 1554: RAISE okl_api.g_exception_error;

1550:
1551: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1552: RAISE okl_api.g_exception_unexpected_error;
1553: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1554: RAISE okl_api.g_exception_error;
1555: END IF;
1556:
1557: --Setting Item Attributes
1558:

Line 1562: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1558:
1559: l_return_status := set_attributes(p_pamb_rec
1560: ,l_pamb_rec);
1561:
1562: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1563: RAISE okl_api.g_exception_unexpected_error;
1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1565: RAISE okl_api.g_exception_error;
1566: END IF;

Line 1563: RAISE okl_api.g_exception_unexpected_error;

1559: l_return_status := set_attributes(p_pamb_rec
1560: ,l_pamb_rec);
1561:
1562: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1563: RAISE okl_api.g_exception_unexpected_error;
1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1565: RAISE okl_api.g_exception_error;
1566: END IF;
1567:

Line 1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1560: ,l_pamb_rec);
1561:
1562: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1563: RAISE okl_api.g_exception_unexpected_error;
1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1565: RAISE okl_api.g_exception_error;
1566: END IF;
1567:
1568: INSERT INTO okl_fe_adj_mat_all_b

Line 1565: RAISE okl_api.g_exception_error;

1561:
1562: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1563: RAISE okl_api.g_exception_unexpected_error;
1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1565: RAISE okl_api.g_exception_error;
1566: END IF;
1567:
1568: INSERT INTO okl_fe_adj_mat_all_b
1569: (adj_mat_id

Line 1635: okl_api.end_activity(x_msg_count

1631:
1632: --Set OUT Values
1633:
1634: x_pamb_rec := l_pamb_rec;
1635: okl_api.end_activity(x_msg_count
1636: ,x_msg_data);
1637: EXCEPTION
1638: WHEN g_exception_halt_validation THEN
1639:

Line 1643: WHEN okl_api.g_exception_error THEN

1639:
1640: -- No action necessary. Validation can continue to next attribute/column
1641:
1642: NULL;
1643: WHEN okl_api.g_exception_error THEN
1644: x_return_status := okl_api.handle_exceptions(l_api_name
1645: ,g_pkg_name
1646: ,'OKL_API.G_RET_STS_ERROR'
1647: ,x_msg_count

Line 1644: x_return_status := okl_api.handle_exceptions(l_api_name

1640: -- No action necessary. Validation can continue to next attribute/column
1641:
1642: NULL;
1643: WHEN okl_api.g_exception_error THEN
1644: x_return_status := okl_api.handle_exceptions(l_api_name
1645: ,g_pkg_name
1646: ,'OKL_API.G_RET_STS_ERROR'
1647: ,x_msg_count
1648: ,x_msg_data

Line 1646: ,'OKL_API.G_RET_STS_ERROR'

1642: NULL;
1643: WHEN okl_api.g_exception_error THEN
1644: x_return_status := okl_api.handle_exceptions(l_api_name
1645: ,g_pkg_name
1646: ,'OKL_API.G_RET_STS_ERROR'
1647: ,x_msg_count
1648: ,x_msg_data
1649: ,'_PVT');
1650: WHEN okl_api.g_exception_unexpected_error THEN

Line 1650: WHEN okl_api.g_exception_unexpected_error THEN

1646: ,'OKL_API.G_RET_STS_ERROR'
1647: ,x_msg_count
1648: ,x_msg_data
1649: ,'_PVT');
1650: WHEN okl_api.g_exception_unexpected_error THEN
1651: x_return_status := okl_api.handle_exceptions(l_api_name
1652: ,g_pkg_name
1653: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1654: ,x_msg_count

Line 1651: x_return_status := okl_api.handle_exceptions(l_api_name

1647: ,x_msg_count
1648: ,x_msg_data
1649: ,'_PVT');
1650: WHEN okl_api.g_exception_unexpected_error THEN
1651: x_return_status := okl_api.handle_exceptions(l_api_name
1652: ,g_pkg_name
1653: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1654: ,x_msg_count
1655: ,x_msg_data

Line 1653: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1649: ,'_PVT');
1650: WHEN okl_api.g_exception_unexpected_error THEN
1651: x_return_status := okl_api.handle_exceptions(l_api_name
1652: ,g_pkg_name
1653: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1654: ,x_msg_count
1655: ,x_msg_data
1656: ,'_PVT');
1657: WHEN OTHERS THEN

Line 1658: x_return_status := okl_api.handle_exceptions(l_api_name

1654: ,x_msg_count
1655: ,x_msg_data
1656: ,'_PVT');
1657: WHEN OTHERS THEN
1658: x_return_status := okl_api.handle_exceptions(l_api_name
1659: ,g_pkg_name
1660: ,'OTHERS'
1661: ,x_msg_count
1662: ,x_msg_data

Line 1671: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1667: -- Procedure insert_row_tl
1668: --------------------------------------------------------------------------------
1669:
1670: PROCEDURE insert_row(p_api_version IN NUMBER
1671: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1672: ,x_return_status OUT NOCOPY VARCHAR2
1673: ,x_msg_count OUT NOCOPY NUMBER
1674: ,x_msg_data OUT NOCOPY VARCHAR2
1675: ,p_pamtl_rec IN okl_pamtl_rec

Line 1679: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1675: ,p_pamtl_rec IN okl_pamtl_rec
1676: ,x_pamtl_rec OUT NOCOPY okl_pamtl_rec) IS
1677: l_api_version CONSTANT NUMBER := 1;
1678: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1679: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1680: l_pamtl_rec okl_pamtl_rec := p_pamtl_rec;
1681:
1682: CURSOR get_languages IS
1683: SELECT *

Line 1689: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1685: WHERE installed_flag IN('I', 'B');
1686:
1687: FUNCTION set_attributes(p_pamtl_rec IN okl_pamtl_rec
1688: ,x_pamtl_rec OUT NOCOPY okl_pamtl_rec) RETURN VARCHAR2 IS
1689: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1690:
1691: BEGIN
1692: x_pamtl_rec := p_pamtl_rec;
1693: x_pamtl_rec.language := USERENV('LANG');

Line 1700: l_return_status := okl_api.start_activity(l_api_name

1696: RETURN(l_return_status);
1697: END set_attributes;
1698:
1699: BEGIN
1700: l_return_status := okl_api.start_activity(l_api_name
1701: ,g_pkg_name
1702: ,p_init_msg_list
1703: ,l_api_version
1704: ,p_api_version

Line 1708: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1704: ,p_api_version
1705: ,'_PVT'
1706: ,x_return_status);
1707:
1708: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1709: RAISE okl_api.g_exception_unexpected_error;
1710: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1711: RAISE okl_api.g_exception_error;
1712: END IF;

Line 1709: RAISE okl_api.g_exception_unexpected_error;

1705: ,'_PVT'
1706: ,x_return_status);
1707:
1708: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1709: RAISE okl_api.g_exception_unexpected_error;
1710: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1711: RAISE okl_api.g_exception_error;
1712: END IF;
1713:

Line 1710: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1706: ,x_return_status);
1707:
1708: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1709: RAISE okl_api.g_exception_unexpected_error;
1710: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1711: RAISE okl_api.g_exception_error;
1712: END IF;
1713:
1714: --Setting Item Attributes

Line 1711: RAISE okl_api.g_exception_error;

1707:
1708: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1709: RAISE okl_api.g_exception_unexpected_error;
1710: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1711: RAISE okl_api.g_exception_error;
1712: END IF;
1713:
1714: --Setting Item Attributes
1715:

Line 1719: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1715:
1716: l_return_status := set_attributes(p_pamtl_rec
1717: ,l_pamtl_rec);
1718:
1719: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1720: RAISE okl_api.g_exception_unexpected_error;
1721: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1722: RAISE okl_api.g_exception_error;
1723: END IF;

Line 1720: RAISE okl_api.g_exception_unexpected_error;

1716: l_return_status := set_attributes(p_pamtl_rec
1717: ,l_pamtl_rec);
1718:
1719: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1720: RAISE okl_api.g_exception_unexpected_error;
1721: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1722: RAISE okl_api.g_exception_error;
1723: END IF;
1724:

Line 1721: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1717: ,l_pamtl_rec);
1718:
1719: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1720: RAISE okl_api.g_exception_unexpected_error;
1721: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1722: RAISE okl_api.g_exception_error;
1723: END IF;
1724:
1725: FOR l_lang_rec IN get_languages LOOP

Line 1722: RAISE okl_api.g_exception_error;

1718:
1719: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1720: RAISE okl_api.g_exception_unexpected_error;
1721: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1722: RAISE okl_api.g_exception_error;
1723: END IF;
1724:
1725: FOR l_lang_rec IN get_languages LOOP
1726: l_pamtl_rec.language := l_lang_rec.language_code;

Line 1755: okl_api.end_activity(x_msg_count

1751:
1752: --Set OUT Values
1753:
1754: x_pamtl_rec := l_pamtl_rec;
1755: okl_api.end_activity(x_msg_count
1756: ,x_msg_data);
1757: EXCEPTION
1758: WHEN g_exception_halt_validation THEN
1759:

Line 1763: WHEN okl_api.g_exception_error THEN

1759:
1760: -- No action necessary. Validation can continue to next attribute/column
1761:
1762: NULL;
1763: WHEN okl_api.g_exception_error THEN
1764: x_return_status := okl_api.handle_exceptions(l_api_name
1765: ,g_pkg_name
1766: ,'OKL_API.G_RET_STS_ERROR'
1767: ,x_msg_count

Line 1764: x_return_status := okl_api.handle_exceptions(l_api_name

1760: -- No action necessary. Validation can continue to next attribute/column
1761:
1762: NULL;
1763: WHEN okl_api.g_exception_error THEN
1764: x_return_status := okl_api.handle_exceptions(l_api_name
1765: ,g_pkg_name
1766: ,'OKL_API.G_RET_STS_ERROR'
1767: ,x_msg_count
1768: ,x_msg_data

Line 1766: ,'OKL_API.G_RET_STS_ERROR'

1762: NULL;
1763: WHEN okl_api.g_exception_error THEN
1764: x_return_status := okl_api.handle_exceptions(l_api_name
1765: ,g_pkg_name
1766: ,'OKL_API.G_RET_STS_ERROR'
1767: ,x_msg_count
1768: ,x_msg_data
1769: ,'_PVT');
1770: WHEN okl_api.g_exception_unexpected_error THEN

Line 1770: WHEN okl_api.g_exception_unexpected_error THEN

1766: ,'OKL_API.G_RET_STS_ERROR'
1767: ,x_msg_count
1768: ,x_msg_data
1769: ,'_PVT');
1770: WHEN okl_api.g_exception_unexpected_error THEN
1771: x_return_status := okl_api.handle_exceptions(l_api_name
1772: ,g_pkg_name
1773: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1774: ,x_msg_count

Line 1771: x_return_status := okl_api.handle_exceptions(l_api_name

1767: ,x_msg_count
1768: ,x_msg_data
1769: ,'_PVT');
1770: WHEN okl_api.g_exception_unexpected_error THEN
1771: x_return_status := okl_api.handle_exceptions(l_api_name
1772: ,g_pkg_name
1773: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1774: ,x_msg_count
1775: ,x_msg_data

Line 1773: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1769: ,'_PVT');
1770: WHEN okl_api.g_exception_unexpected_error THEN
1771: x_return_status := okl_api.handle_exceptions(l_api_name
1772: ,g_pkg_name
1773: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1774: ,x_msg_count
1775: ,x_msg_data
1776: ,'_PVT');
1777: WHEN OTHERS THEN

Line 1778: x_return_status := okl_api.handle_exceptions(l_api_name

1774: ,x_msg_count
1775: ,x_msg_data
1776: ,'_PVT');
1777: WHEN OTHERS THEN
1778: x_return_status := okl_api.handle_exceptions(l_api_name
1779: ,g_pkg_name
1780: ,'OTHERS'
1781: ,x_msg_count
1782: ,x_msg_data

Line 1791: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1787: -- Procedure insert_row_v
1788: --------------------------------------------------------------------------------
1789:
1790: PROCEDURE insert_row(p_api_version IN NUMBER
1791: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1792: ,x_return_status OUT NOCOPY VARCHAR2
1793: ,x_msg_count OUT NOCOPY NUMBER
1794: ,x_msg_data OUT NOCOPY VARCHAR2
1795: ,p_pamv_rec IN okl_pamv_rec

Line 1799: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1795: ,p_pamv_rec IN okl_pamv_rec
1796: ,x_pamv_rec OUT NOCOPY okl_pamv_rec) IS
1797: l_api_version CONSTANT NUMBER := 1;
1798: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
1799: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1800: l_pamv_rec okl_pamv_rec;
1801: l_def_pamv_rec okl_pamv_rec;
1802: l_pamb_rec okl_pamb_rec;
1803: lx_pamb_rec okl_pamb_rec;

Line 1821: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1817: END fill_who_columns;
1818:
1819: FUNCTION set_attributes(p_pamv_rec IN okl_pamv_rec
1820: ,x_pamv_rec OUT NOCOPY okl_pamv_rec) RETURN VARCHAR2 IS
1821: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1822:
1823: BEGIN
1824: x_pamv_rec := p_pamv_rec;
1825: x_pamv_rec.object_version_number := 1;

Line 1831: l_return_status := okl_api.start_activity(l_api_name

1827: RETURN(l_return_status);
1828: END set_attributes;
1829:
1830: BEGIN
1831: l_return_status := okl_api.start_activity(l_api_name
1832: ,g_pkg_name
1833: ,p_init_msg_list
1834: ,l_api_version
1835: ,p_api_version

Line 1839: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1835: ,p_api_version
1836: ,'_PVT'
1837: ,x_return_status);
1838:
1839: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1840: RAISE okl_api.g_exception_unexpected_error;
1841: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1842: RAISE okl_api.g_exception_error;
1843: END IF;

Line 1840: RAISE okl_api.g_exception_unexpected_error;

1836: ,'_PVT'
1837: ,x_return_status);
1838:
1839: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1840: RAISE okl_api.g_exception_unexpected_error;
1841: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1842: RAISE okl_api.g_exception_error;
1843: END IF;
1844: l_pamv_rec := null_out_defaults(p_pamv_rec);

Line 1841: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1837: ,x_return_status);
1838:
1839: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1840: RAISE okl_api.g_exception_unexpected_error;
1841: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1842: RAISE okl_api.g_exception_error;
1843: END IF;
1844: l_pamv_rec := null_out_defaults(p_pamv_rec);
1845:

Line 1842: RAISE okl_api.g_exception_error;

1838:
1839: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1840: RAISE okl_api.g_exception_unexpected_error;
1841: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1842: RAISE okl_api.g_exception_error;
1843: END IF;
1844: l_pamv_rec := null_out_defaults(p_pamv_rec);
1845:
1846: -- Set Primary key value

Line 1855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1851:
1852: l_return_status := set_attributes(l_pamv_rec
1853: ,l_def_pamv_rec);
1854:
1855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1856: RAISE okl_api.g_exception_unexpected_error;
1857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1858: RAISE okl_api.g_exception_error;
1859: END IF;

Line 1856: RAISE okl_api.g_exception_unexpected_error;

1852: l_return_status := set_attributes(l_pamv_rec
1853: ,l_def_pamv_rec);
1854:
1855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1856: RAISE okl_api.g_exception_unexpected_error;
1857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1858: RAISE okl_api.g_exception_error;
1859: END IF;
1860: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);

Line 1857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1853: ,l_def_pamv_rec);
1854:
1855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1856: RAISE okl_api.g_exception_unexpected_error;
1857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1858: RAISE okl_api.g_exception_error;
1859: END IF;
1860: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
1861: l_return_status := validate_attributes(l_def_pamv_rec);

Line 1858: RAISE okl_api.g_exception_error;

1854:
1855: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1856: RAISE okl_api.g_exception_unexpected_error;
1857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1858: RAISE okl_api.g_exception_error;
1859: END IF;
1860: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
1861: l_return_status := validate_attributes(l_def_pamv_rec);
1862:

Line 1863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1859: END IF;
1860: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
1861: l_return_status := validate_attributes(l_def_pamv_rec);
1862:
1863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1864: RAISE okl_api.g_exception_unexpected_error;
1865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1866: RAISE okl_api.g_exception_error;
1867: END IF;

Line 1864: RAISE okl_api.g_exception_unexpected_error;

1860: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
1861: l_return_status := validate_attributes(l_def_pamv_rec);
1862:
1863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1864: RAISE okl_api.g_exception_unexpected_error;
1865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1866: RAISE okl_api.g_exception_error;
1867: END IF;
1868: l_return_status := validate_record(l_def_pamv_rec);

Line 1865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1861: l_return_status := validate_attributes(l_def_pamv_rec);
1862:
1863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1864: RAISE okl_api.g_exception_unexpected_error;
1865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1866: RAISE okl_api.g_exception_error;
1867: END IF;
1868: l_return_status := validate_record(l_def_pamv_rec);
1869:

Line 1866: RAISE okl_api.g_exception_error;

1862:
1863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1864: RAISE okl_api.g_exception_unexpected_error;
1865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1866: RAISE okl_api.g_exception_error;
1867: END IF;
1868: l_return_status := validate_record(l_def_pamv_rec);
1869:
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1866: RAISE okl_api.g_exception_error;
1867: END IF;
1868: l_return_status := validate_record(l_def_pamv_rec);
1869:
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;

Line 1871: RAISE okl_api.g_exception_unexpected_error;

1867: END IF;
1868: l_return_status := validate_record(l_def_pamv_rec);
1869:
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: migrate(l_def_pamv_rec

Line 1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1868: l_return_status := validate_record(l_def_pamv_rec);
1869:
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: migrate(l_def_pamv_rec
1876: ,l_pamb_rec);

Line 1873: RAISE okl_api.g_exception_error;

1869:
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: migrate(l_def_pamv_rec
1876: ,l_pamb_rec);
1877: migrate(l_def_pamv_rec

Line 1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1883: ,x_msg_data
1884: ,l_pamb_rec
1885: ,lx_pamb_rec);
1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okl_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okl_api.g_exception_error;
1891: END IF;

Line 1888: RAISE okl_api.g_exception_unexpected_error;

1884: ,l_pamb_rec
1885: ,lx_pamb_rec);
1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okl_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okl_api.g_exception_error;
1891: END IF;
1892: migrate(lx_pamb_rec

Line 1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1885: ,lx_pamb_rec);
1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okl_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okl_api.g_exception_error;
1891: END IF;
1892: migrate(lx_pamb_rec
1893: ,l_def_pamv_rec);

Line 1890: RAISE okl_api.g_exception_error;

1886:
1887: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1888: RAISE okl_api.g_exception_unexpected_error;
1889: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1890: RAISE okl_api.g_exception_error;
1891: END IF;
1892: migrate(lx_pamb_rec
1893: ,l_def_pamv_rec);
1894: insert_row(p_api_version

Line 1902: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1898: ,x_msg_data
1899: ,l_pamtl_rec
1900: ,lx_pamtl_rec);
1901:
1902: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1903: RAISE okl_api.g_exception_unexpected_error;
1904: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1905: RAISE okl_api.g_exception_error;
1906: END IF;

Line 1903: RAISE okl_api.g_exception_unexpected_error;

1899: ,l_pamtl_rec
1900: ,lx_pamtl_rec);
1901:
1902: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1903: RAISE okl_api.g_exception_unexpected_error;
1904: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1905: RAISE okl_api.g_exception_error;
1906: END IF;
1907: migrate(lx_pamtl_rec

Line 1904: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1900: ,lx_pamtl_rec);
1901:
1902: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1903: RAISE okl_api.g_exception_unexpected_error;
1904: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1905: RAISE okl_api.g_exception_error;
1906: END IF;
1907: migrate(lx_pamtl_rec
1908: ,l_def_pamv_rec);

Line 1905: RAISE okl_api.g_exception_error;

1901:
1902: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1903: RAISE okl_api.g_exception_unexpected_error;
1904: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1905: RAISE okl_api.g_exception_error;
1906: END IF;
1907: migrate(lx_pamtl_rec
1908: ,l_def_pamv_rec);
1909:

Line 1913: okl_api.end_activity(x_msg_count

1909:
1910: --Set OUT Values
1911:
1912: x_pamv_rec := l_def_pamv_rec;
1913: okl_api.end_activity(x_msg_count
1914: ,x_msg_data);
1915: EXCEPTION
1916: WHEN g_exception_halt_validation THEN
1917:

Line 1921: WHEN okl_api.g_exception_error THEN

1917:
1918: -- No action necessary. Validation can continue to next attribute/column
1919:
1920: NULL;
1921: WHEN okl_api.g_exception_error THEN
1922: x_return_status := okl_api.handle_exceptions(l_api_name
1923: ,g_pkg_name
1924: ,'OKL_API.G_RET_STS_ERROR'
1925: ,x_msg_count

Line 1922: x_return_status := okl_api.handle_exceptions(l_api_name

1918: -- No action necessary. Validation can continue to next attribute/column
1919:
1920: NULL;
1921: WHEN okl_api.g_exception_error THEN
1922: x_return_status := okl_api.handle_exceptions(l_api_name
1923: ,g_pkg_name
1924: ,'OKL_API.G_RET_STS_ERROR'
1925: ,x_msg_count
1926: ,x_msg_data

Line 1924: ,'OKL_API.G_RET_STS_ERROR'

1920: NULL;
1921: WHEN okl_api.g_exception_error THEN
1922: x_return_status := okl_api.handle_exceptions(l_api_name
1923: ,g_pkg_name
1924: ,'OKL_API.G_RET_STS_ERROR'
1925: ,x_msg_count
1926: ,x_msg_data
1927: ,'_PVT');
1928: WHEN okl_api.g_exception_unexpected_error THEN

Line 1928: WHEN okl_api.g_exception_unexpected_error THEN

1924: ,'OKL_API.G_RET_STS_ERROR'
1925: ,x_msg_count
1926: ,x_msg_data
1927: ,'_PVT');
1928: WHEN okl_api.g_exception_unexpected_error THEN
1929: x_return_status := okl_api.handle_exceptions(l_api_name
1930: ,g_pkg_name
1931: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1932: ,x_msg_count

Line 1929: x_return_status := okl_api.handle_exceptions(l_api_name

1925: ,x_msg_count
1926: ,x_msg_data
1927: ,'_PVT');
1928: WHEN okl_api.g_exception_unexpected_error THEN
1929: x_return_status := okl_api.handle_exceptions(l_api_name
1930: ,g_pkg_name
1931: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1932: ,x_msg_count
1933: ,x_msg_data

Line 1931: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1927: ,'_PVT');
1928: WHEN okl_api.g_exception_unexpected_error THEN
1929: x_return_status := okl_api.handle_exceptions(l_api_name
1930: ,g_pkg_name
1931: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1932: ,x_msg_count
1933: ,x_msg_data
1934: ,'_PVT');
1935: WHEN OTHERS THEN

Line 1936: x_return_status := okl_api.handle_exceptions(l_api_name

1932: ,x_msg_count
1933: ,x_msg_data
1934: ,'_PVT');
1935: WHEN OTHERS THEN
1936: x_return_status := okl_api.handle_exceptions(l_api_name
1937: ,g_pkg_name
1938: ,'OTHERS'
1939: ,x_msg_count
1940: ,x_msg_data

Line 1949: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

1945: -- Procedure insert_row_tbl
1946: --------------------------------------------------------------------------------
1947:
1948: PROCEDURE insert_row(p_api_version IN NUMBER
1949: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
1950: ,x_return_status OUT NOCOPY VARCHAR2
1951: ,x_msg_count OUT NOCOPY NUMBER
1952: ,x_msg_data OUT NOCOPY VARCHAR2
1953: ,p_pamv_tbl IN okl_pamv_tbl

Line 1957: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1953: ,p_pamv_tbl IN okl_pamv_tbl
1954: ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl) IS
1955: l_api_version CONSTANT NUMBER := 1;
1956: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
1957: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1958: i NUMBER := 0;
1959: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1960:
1961: BEGIN

Line 1959: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

1955: l_api_version CONSTANT NUMBER := 1;
1956: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
1957: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1958: i NUMBER := 0;
1959: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1960:
1961: BEGIN
1962: okl_api.init_msg_list(p_init_msg_list);
1963:

Line 1962: okl_api.init_msg_list(p_init_msg_list);

1958: i NUMBER := 0;
1959: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1960:
1961: BEGIN
1962: okl_api.init_msg_list(p_init_msg_list);
1963:
1964: -- Make sure PL/SQL table has records in it before passing
1965:
1966: IF (p_pamv_tbl.COUNT > 0) THEN

Line 1971: ,p_init_msg_list => okl_api.g_false

1967: i := p_pamv_tbl.FIRST;
1968:
1969: LOOP
1970: insert_row(p_api_version => p_api_version
1971: ,p_init_msg_list => okl_api.g_false
1972: ,x_return_status => x_return_status
1973: ,x_msg_count => x_msg_count
1974: ,x_msg_data => x_msg_data
1975: ,p_pamv_rec => p_pamv_tbl(i)

Line 1977: IF x_return_status <> okl_api.g_ret_sts_success THEN

1973: ,x_msg_count => x_msg_count
1974: ,x_msg_data => x_msg_data
1975: ,p_pamv_rec => p_pamv_tbl(i)
1976: ,x_pamv_rec => x_pamv_tbl(i));
1977: IF x_return_status <> okl_api.g_ret_sts_success THEN
1978: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1979: l_overall_status := x_return_status;
1980: END IF;
1981: END IF;

Line 1978: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

1974: ,x_msg_data => x_msg_data
1975: ,p_pamv_rec => p_pamv_tbl(i)
1976: ,x_pamv_rec => x_pamv_tbl(i));
1977: IF x_return_status <> okl_api.g_ret_sts_success THEN
1978: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
1979: l_overall_status := x_return_status;
1980: END IF;
1981: END IF;
1982: EXIT WHEN(i = p_pamv_tbl.LAST);

Line 1994: WHEN okl_api.g_exception_error THEN

1990:
1991: -- No action necessary. Validation can continue to next attribute/column
1992:
1993: NULL;
1994: WHEN okl_api.g_exception_error THEN
1995: x_return_status := okl_api.handle_exceptions(l_api_name
1996: ,g_pkg_name
1997: ,'OKL_API.G_RET_STS_ERROR'
1998: ,x_msg_count

Line 1995: x_return_status := okl_api.handle_exceptions(l_api_name

1991: -- No action necessary. Validation can continue to next attribute/column
1992:
1993: NULL;
1994: WHEN okl_api.g_exception_error THEN
1995: x_return_status := okl_api.handle_exceptions(l_api_name
1996: ,g_pkg_name
1997: ,'OKL_API.G_RET_STS_ERROR'
1998: ,x_msg_count
1999: ,x_msg_data

Line 1997: ,'OKL_API.G_RET_STS_ERROR'

1993: NULL;
1994: WHEN okl_api.g_exception_error THEN
1995: x_return_status := okl_api.handle_exceptions(l_api_name
1996: ,g_pkg_name
1997: ,'OKL_API.G_RET_STS_ERROR'
1998: ,x_msg_count
1999: ,x_msg_data
2000: ,'_PVT');
2001: WHEN okl_api.g_exception_unexpected_error THEN

Line 2001: WHEN okl_api.g_exception_unexpected_error THEN

1997: ,'OKL_API.G_RET_STS_ERROR'
1998: ,x_msg_count
1999: ,x_msg_data
2000: ,'_PVT');
2001: WHEN okl_api.g_exception_unexpected_error THEN
2002: x_return_status := okl_api.handle_exceptions(l_api_name
2003: ,g_pkg_name
2004: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2005: ,x_msg_count

Line 2002: x_return_status := okl_api.handle_exceptions(l_api_name

1998: ,x_msg_count
1999: ,x_msg_data
2000: ,'_PVT');
2001: WHEN okl_api.g_exception_unexpected_error THEN
2002: x_return_status := okl_api.handle_exceptions(l_api_name
2003: ,g_pkg_name
2004: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2005: ,x_msg_count
2006: ,x_msg_data

Line 2004: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2000: ,'_PVT');
2001: WHEN okl_api.g_exception_unexpected_error THEN
2002: x_return_status := okl_api.handle_exceptions(l_api_name
2003: ,g_pkg_name
2004: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2005: ,x_msg_count
2006: ,x_msg_data
2007: ,'_PVT');
2008: WHEN OTHERS THEN

Line 2009: x_return_status := okl_api.handle_exceptions(l_api_name

2005: ,x_msg_count
2006: ,x_msg_data
2007: ,'_PVT');
2008: WHEN OTHERS THEN
2009: x_return_status := okl_api.handle_exceptions(l_api_name
2010: ,g_pkg_name
2011: ,'OTHERS'
2012: ,x_msg_count
2013: ,x_msg_data

Line 2022: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2018: -- Procedure update_row_b
2019: --------------------------------------------------------------------------------
2020:
2021: PROCEDURE update_row(p_api_version IN NUMBER
2022: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2023: ,x_return_status OUT NOCOPY VARCHAR2
2024: ,x_msg_count OUT NOCOPY NUMBER
2025: ,x_msg_data OUT NOCOPY VARCHAR2
2026: ,p_pamb_rec IN okl_pamb_rec

Line 2030: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2026: ,p_pamb_rec IN okl_pamb_rec
2027: ,x_pamb_rec OUT NOCOPY okl_pamb_rec) IS
2028: l_api_version CONSTANT NUMBER := 1;
2029: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2030: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2031: l_pamb_rec okl_pamb_rec := p_pamb_rec;
2032: l_def_pamb_rec okl_pamb_rec;
2033: l_row_notfound BOOLEAN := true;
2034:

Line 2037: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2033: l_row_notfound BOOLEAN := true;
2034:
2035: FUNCTION set_attributes(p_pamb_rec IN okl_pamb_rec
2036: ,x_pamb_rec OUT NOCOPY okl_pamb_rec) RETURN VARCHAR2 IS
2037: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2038:
2039: BEGIN
2040: x_pamb_rec := p_pamb_rec;
2041: RETURN(l_return_status);

Line 2045: l_return_status := okl_api.start_activity(l_api_name

2041: RETURN(l_return_status);
2042: END set_attributes;
2043:
2044: BEGIN
2045: l_return_status := okl_api.start_activity(l_api_name
2046: ,g_pkg_name
2047: ,p_init_msg_list
2048: ,l_api_version
2049: ,p_api_version

Line 2053: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2049: ,p_api_version
2050: ,'_PVT'
2051: ,x_return_status);
2052:
2053: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2054: RAISE okl_api.g_exception_unexpected_error;
2055: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2056: RAISE okl_api.g_exception_error;
2057: END IF;

Line 2054: RAISE okl_api.g_exception_unexpected_error;

2050: ,'_PVT'
2051: ,x_return_status);
2052:
2053: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2054: RAISE okl_api.g_exception_unexpected_error;
2055: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2056: RAISE okl_api.g_exception_error;
2057: END IF;
2058:

Line 2055: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2051: ,x_return_status);
2052:
2053: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2054: RAISE okl_api.g_exception_unexpected_error;
2055: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2056: RAISE okl_api.g_exception_error;
2057: END IF;
2058:
2059: --Setting Item Attributes

Line 2056: RAISE okl_api.g_exception_error;

2052:
2053: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2054: RAISE okl_api.g_exception_unexpected_error;
2055: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2056: RAISE okl_api.g_exception_error;
2057: END IF;
2058:
2059: --Setting Item Attributes
2060:

Line 2064: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2060:
2061: l_return_status := set_attributes(p_pamb_rec
2062: ,l_def_pamb_rec);
2063:
2064: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2065: RAISE okl_api.g_exception_unexpected_error;
2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2067: RAISE okl_api.g_exception_error;
2068: END IF;

Line 2065: RAISE okl_api.g_exception_unexpected_error;

2061: l_return_status := set_attributes(p_pamb_rec
2062: ,l_def_pamb_rec);
2063:
2064: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2065: RAISE okl_api.g_exception_unexpected_error;
2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2067: RAISE okl_api.g_exception_error;
2068: END IF;
2069:

Line 2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2062: ,l_def_pamb_rec);
2063:
2064: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2065: RAISE okl_api.g_exception_unexpected_error;
2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2067: RAISE okl_api.g_exception_error;
2068: END IF;
2069:
2070: UPDATE okl_fe_adj_mat_all_b

Line 2067: RAISE okl_api.g_exception_error;

2063:
2064: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2065: RAISE okl_api.g_exception_unexpected_error;
2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2067: RAISE okl_api.g_exception_error;
2068: END IF;
2069:
2070: UPDATE okl_fe_adj_mat_all_b
2071: SET adj_mat_id = l_def_pamb_rec.adj_mat_id

Line 2107: okl_api.end_activity(x_msg_count

2103:
2104: --Set OUT Values
2105:
2106: x_pamb_rec := l_pamb_rec;
2107: okl_api.end_activity(x_msg_count
2108: ,x_msg_data);
2109: EXCEPTION
2110: WHEN g_exception_halt_validation THEN
2111:

Line 2115: WHEN okl_api.g_exception_error THEN

2111:
2112: -- No action necessary. Validation can continue to next attribute/column
2113:
2114: NULL;
2115: WHEN okl_api.g_exception_error THEN
2116: x_return_status := okl_api.handle_exceptions(l_api_name
2117: ,g_pkg_name
2118: ,'OKL_API.G_RET_STS_ERROR'
2119: ,x_msg_count

Line 2116: x_return_status := okl_api.handle_exceptions(l_api_name

2112: -- No action necessary. Validation can continue to next attribute/column
2113:
2114: NULL;
2115: WHEN okl_api.g_exception_error THEN
2116: x_return_status := okl_api.handle_exceptions(l_api_name
2117: ,g_pkg_name
2118: ,'OKL_API.G_RET_STS_ERROR'
2119: ,x_msg_count
2120: ,x_msg_data

Line 2118: ,'OKL_API.G_RET_STS_ERROR'

2114: NULL;
2115: WHEN okl_api.g_exception_error THEN
2116: x_return_status := okl_api.handle_exceptions(l_api_name
2117: ,g_pkg_name
2118: ,'OKL_API.G_RET_STS_ERROR'
2119: ,x_msg_count
2120: ,x_msg_data
2121: ,'_PVT');
2122: WHEN okl_api.g_exception_unexpected_error THEN

Line 2122: WHEN okl_api.g_exception_unexpected_error THEN

2118: ,'OKL_API.G_RET_STS_ERROR'
2119: ,x_msg_count
2120: ,x_msg_data
2121: ,'_PVT');
2122: WHEN okl_api.g_exception_unexpected_error THEN
2123: x_return_status := okl_api.handle_exceptions(l_api_name
2124: ,g_pkg_name
2125: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2126: ,x_msg_count

Line 2123: x_return_status := okl_api.handle_exceptions(l_api_name

2119: ,x_msg_count
2120: ,x_msg_data
2121: ,'_PVT');
2122: WHEN okl_api.g_exception_unexpected_error THEN
2123: x_return_status := okl_api.handle_exceptions(l_api_name
2124: ,g_pkg_name
2125: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2126: ,x_msg_count
2127: ,x_msg_data

Line 2125: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2121: ,'_PVT');
2122: WHEN okl_api.g_exception_unexpected_error THEN
2123: x_return_status := okl_api.handle_exceptions(l_api_name
2124: ,g_pkg_name
2125: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2126: ,x_msg_count
2127: ,x_msg_data
2128: ,'_PVT');
2129: WHEN OTHERS THEN

Line 2130: x_return_status := okl_api.handle_exceptions(l_api_name

2126: ,x_msg_count
2127: ,x_msg_data
2128: ,'_PVT');
2129: WHEN OTHERS THEN
2130: x_return_status := okl_api.handle_exceptions(l_api_name
2131: ,g_pkg_name
2132: ,'OTHERS'
2133: ,x_msg_count
2134: ,x_msg_data

Line 2143: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2139: -- Procedure update_row_tl
2140: --------------------------------------------------------------------------------
2141:
2142: PROCEDURE update_row(p_api_version IN NUMBER
2143: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2144: ,x_return_status OUT NOCOPY VARCHAR2
2145: ,x_msg_count OUT NOCOPY NUMBER
2146: ,x_msg_data OUT NOCOPY VARCHAR2
2147: ,p_pamtl_rec IN okl_pamtl_rec

Line 2151: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2147: ,p_pamtl_rec IN okl_pamtl_rec
2148: ,x_pamtl_rec OUT NOCOPY okl_pamtl_rec) IS
2149: l_api_version CONSTANT NUMBER := 1;
2150: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2151: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2152: l_pamtl_rec okl_pamtl_rec := p_pamtl_rec;
2153: l_def_pamtl_rec okl_pamtl_rec;
2154: l_row_notfound BOOLEAN := true;
2155:

Line 2158: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2154: l_row_notfound BOOLEAN := true;
2155:
2156: FUNCTION set_attributes(p_pamtl_rec IN okl_pamtl_rec
2157: ,x_pamtl_rec OUT NOCOPY okl_pamtl_rec) RETURN VARCHAR2 IS
2158: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2159:
2160: BEGIN
2161: x_pamtl_rec := p_pamtl_rec;
2162: x_pamtl_rec.language := USERENV('LANG');

Line 2169: l_return_status := okl_api.start_activity(l_api_name

2165: RETURN(l_return_status);
2166: END set_attributes;
2167:
2168: BEGIN
2169: l_return_status := okl_api.start_activity(l_api_name
2170: ,g_pkg_name
2171: ,p_init_msg_list
2172: ,l_api_version
2173: ,p_api_version

Line 2177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2173: ,p_api_version
2174: ,'_PVT'
2175: ,x_return_status);
2176:
2177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2178: RAISE okl_api.g_exception_unexpected_error;
2179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2180: RAISE okl_api.g_exception_error;
2181: END IF;

Line 2178: RAISE okl_api.g_exception_unexpected_error;

2174: ,'_PVT'
2175: ,x_return_status);
2176:
2177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2178: RAISE okl_api.g_exception_unexpected_error;
2179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2180: RAISE okl_api.g_exception_error;
2181: END IF;
2182:

Line 2179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2175: ,x_return_status);
2176:
2177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2178: RAISE okl_api.g_exception_unexpected_error;
2179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2180: RAISE okl_api.g_exception_error;
2181: END IF;
2182:
2183: --Setting Item Attributes

Line 2180: RAISE okl_api.g_exception_error;

2176:
2177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2178: RAISE okl_api.g_exception_unexpected_error;
2179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2180: RAISE okl_api.g_exception_error;
2181: END IF;
2182:
2183: --Setting Item Attributes
2184:

Line 2188: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2184:
2185: l_return_status := set_attributes(p_pamtl_rec
2186: ,l_def_pamtl_rec);
2187:
2188: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2189: RAISE okl_api.g_exception_unexpected_error;
2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2191: RAISE okl_api.g_exception_error;
2192: END IF;

Line 2189: RAISE okl_api.g_exception_unexpected_error;

2185: l_return_status := set_attributes(p_pamtl_rec
2186: ,l_def_pamtl_rec);
2187:
2188: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2189: RAISE okl_api.g_exception_unexpected_error;
2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2191: RAISE okl_api.g_exception_error;
2192: END IF;
2193:

Line 2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2186: ,l_def_pamtl_rec);
2187:
2188: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2189: RAISE okl_api.g_exception_unexpected_error;
2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2191: RAISE okl_api.g_exception_error;
2192: END IF;
2193:
2194: UPDATE okl_fe_adj_mat_all_tl

Line 2191: RAISE okl_api.g_exception_error;

2187:
2188: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2189: RAISE okl_api.g_exception_unexpected_error;
2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2191: RAISE okl_api.g_exception_error;
2192: END IF;
2193:
2194: UPDATE okl_fe_adj_mat_all_tl
2195: SET adj_mat_id = l_def_pamtl_rec.adj_mat_id

Line 2216: okl_api.end_activity(x_msg_count

2212:
2213: --Set OUT Values
2214:
2215: x_pamtl_rec := l_pamtl_rec;
2216: okl_api.end_activity(x_msg_count
2217: ,x_msg_data);
2218: EXCEPTION
2219: WHEN g_exception_halt_validation THEN
2220:

Line 2224: WHEN okl_api.g_exception_error THEN

2220:
2221: -- No action necessary. Validation can continue to next attribute/column
2222:
2223: NULL;
2224: WHEN okl_api.g_exception_error THEN
2225: x_return_status := okl_api.handle_exceptions(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count

Line 2225: x_return_status := okl_api.handle_exceptions(l_api_name

2221: -- No action necessary. Validation can continue to next attribute/column
2222:
2223: NULL;
2224: WHEN okl_api.g_exception_error THEN
2225: x_return_status := okl_api.handle_exceptions(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data

Line 2227: ,'OKL_API.G_RET_STS_ERROR'

2223: NULL;
2224: WHEN okl_api.g_exception_error THEN
2225: x_return_status := okl_api.handle_exceptions(l_api_name
2226: ,g_pkg_name
2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN okl_api.g_exception_unexpected_error THEN

Line 2231: WHEN okl_api.g_exception_unexpected_error THEN

2227: ,'OKL_API.G_RET_STS_ERROR'
2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN okl_api.g_exception_unexpected_error THEN
2232: x_return_status := okl_api.handle_exceptions(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count

Line 2232: x_return_status := okl_api.handle_exceptions(l_api_name

2228: ,x_msg_count
2229: ,x_msg_data
2230: ,'_PVT');
2231: WHEN okl_api.g_exception_unexpected_error THEN
2232: x_return_status := okl_api.handle_exceptions(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count
2236: ,x_msg_data

Line 2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2230: ,'_PVT');
2231: WHEN okl_api.g_exception_unexpected_error THEN
2232: x_return_status := okl_api.handle_exceptions(l_api_name
2233: ,g_pkg_name
2234: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2235: ,x_msg_count
2236: ,x_msg_data
2237: ,'_PVT');
2238: WHEN OTHERS THEN

Line 2239: x_return_status := okl_api.handle_exceptions(l_api_name

2235: ,x_msg_count
2236: ,x_msg_data
2237: ,'_PVT');
2238: WHEN OTHERS THEN
2239: x_return_status := okl_api.handle_exceptions(l_api_name
2240: ,g_pkg_name
2241: ,'OTHERS'
2242: ,x_msg_count
2243: ,x_msg_data

Line 2252: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2248: -- Procedure insert_row_v
2249: --------------------------------------------------------------------------------
2250:
2251: PROCEDURE update_row(p_api_version IN NUMBER
2252: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2253: ,x_return_status OUT NOCOPY VARCHAR2
2254: ,x_msg_count OUT NOCOPY NUMBER
2255: ,x_msg_data OUT NOCOPY VARCHAR2
2256: ,p_pamv_rec IN okl_pamv_rec

Line 2260: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2256: ,p_pamv_rec IN okl_pamv_rec
2257: ,x_pamv_rec OUT NOCOPY okl_pamv_rec) IS
2258: l_api_version CONSTANT NUMBER := 1;
2259: l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
2260: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2261: l_pamv_rec okl_pamv_rec := p_pamv_rec;
2262: l_def_pamv_rec okl_pamv_rec;
2263: lx_pamv_rec okl_pamv_rec;
2264: l_pamb_rec okl_pamb_rec;

Line 2283: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2279: FUNCTION populate_new_record(p_pamv_rec IN okl_pamv_rec
2280: ,x_pamv_rec OUT NOCOPY okl_pamv_rec) RETURN VARCHAR2 IS
2281: l_pamv_rec okl_pamv_rec;
2282: l_row_notfound BOOLEAN := true;
2283: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2284:
2285: BEGIN
2286: x_pamv_rec := p_pamv_rec;
2287:

Line 2294: l_return_status := okl_api.g_ret_sts_unexp_error;

2290: l_pamv_rec := get_rec(p_pamv_rec
2291: ,l_row_notfound);
2292:
2293: IF (l_row_notfound) THEN
2294: l_return_status := okl_api.g_ret_sts_unexp_error;
2295: END IF;
2296:
2297: IF (x_pamv_rec.adj_mat_id IS NULL) THEN
2298: x_pamv_rec.adj_mat_id := l_pamv_rec.adj_mat_id;

Line 2429: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2425: END populate_new_record;
2426:
2427: FUNCTION set_attributes(p_pamv_rec IN okl_pamv_rec
2428: ,x_pamv_rec OUT NOCOPY okl_pamv_rec) RETURN VARCHAR2 IS
2429: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2430:
2431: BEGIN
2432: x_pamv_rec := p_pamv_rec;
2433: RETURN(l_return_status);

Line 2437: l_return_status := okl_api.start_activity(l_api_name

2433: RETURN(l_return_status);
2434: END set_attributes;
2435:
2436: BEGIN
2437: l_return_status := okl_api.start_activity(l_api_name
2438: ,g_pkg_name
2439: ,p_init_msg_list
2440: ,l_api_version
2441: ,p_api_version

Line 2445: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2441: ,p_api_version
2442: ,'_PVT'
2443: ,x_return_status);
2444:
2445: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2446: RAISE okl_api.g_exception_unexpected_error;
2447: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2448: RAISE okl_api.g_exception_error;
2449: END IF;

Line 2446: RAISE okl_api.g_exception_unexpected_error;

2442: ,'_PVT'
2443: ,x_return_status);
2444:
2445: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2446: RAISE okl_api.g_exception_unexpected_error;
2447: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2448: RAISE okl_api.g_exception_error;
2449: END IF;
2450:

Line 2447: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2443: ,x_return_status);
2444:
2445: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2446: RAISE okl_api.g_exception_unexpected_error;
2447: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2448: RAISE okl_api.g_exception_error;
2449: END IF;
2450:
2451: --Setting Item Attributes

Line 2448: RAISE okl_api.g_exception_error;

2444:
2445: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2446: RAISE okl_api.g_exception_unexpected_error;
2447: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2448: RAISE okl_api.g_exception_error;
2449: END IF;
2450:
2451: --Setting Item Attributes
2452:

Line 2456: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2452:
2453: l_return_status := set_attributes(l_pamv_rec
2454: ,lx_pamv_rec);
2455:
2456: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2457: RAISE okl_api.g_exception_unexpected_error;
2458: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2459: RAISE okl_api.g_exception_error;
2460: END IF;

Line 2457: RAISE okl_api.g_exception_unexpected_error;

2453: l_return_status := set_attributes(l_pamv_rec
2454: ,lx_pamv_rec);
2455:
2456: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2457: RAISE okl_api.g_exception_unexpected_error;
2458: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2459: RAISE okl_api.g_exception_error;
2460: END IF;
2461: l_return_status := populate_new_record(lx_pamv_rec

Line 2458: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2454: ,lx_pamv_rec);
2455:
2456: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2457: RAISE okl_api.g_exception_unexpected_error;
2458: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2459: RAISE okl_api.g_exception_error;
2460: END IF;
2461: l_return_status := populate_new_record(lx_pamv_rec
2462: ,l_def_pamv_rec);

Line 2459: RAISE okl_api.g_exception_error;

2455:
2456: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2457: RAISE okl_api.g_exception_unexpected_error;
2458: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2459: RAISE okl_api.g_exception_error;
2460: END IF;
2461: l_return_status := populate_new_record(lx_pamv_rec
2462: ,l_def_pamv_rec);
2463:

Line 2464: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2460: END IF;
2461: l_return_status := populate_new_record(lx_pamv_rec
2462: ,l_def_pamv_rec);
2463:
2464: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2465: RAISE okl_api.g_exception_unexpected_error;
2466: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2467: RAISE okl_api.g_exception_error;
2468: END IF;

Line 2465: RAISE okl_api.g_exception_unexpected_error;

2461: l_return_status := populate_new_record(lx_pamv_rec
2462: ,l_def_pamv_rec);
2463:
2464: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2465: RAISE okl_api.g_exception_unexpected_error;
2466: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2467: RAISE okl_api.g_exception_error;
2468: END IF;
2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);

Line 2466: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2462: ,l_def_pamv_rec);
2463:
2464: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2465: RAISE okl_api.g_exception_unexpected_error;
2466: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2467: RAISE okl_api.g_exception_error;
2468: END IF;
2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);
2470:

Line 2467: RAISE okl_api.g_exception_error;

2463:
2464: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2465: RAISE okl_api.g_exception_unexpected_error;
2466: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2467: RAISE okl_api.g_exception_error;
2468: END IF;
2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);
2470:
2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2467: RAISE okl_api.g_exception_error;
2468: END IF;
2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);
2470:
2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2472: RAISE okl_api.g_exception_unexpected_error;
2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2474: RAISE okl_api.g_exception_error;
2475: END IF;

Line 2472: RAISE okl_api.g_exception_unexpected_error;

2468: END IF;
2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);
2470:
2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2472: RAISE okl_api.g_exception_unexpected_error;
2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2474: RAISE okl_api.g_exception_error;
2475: END IF;
2476: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);

Line 2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2469: l_def_pamv_rec := null_out_defaults(l_def_pamv_rec);
2470:
2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2472: RAISE okl_api.g_exception_unexpected_error;
2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2474: RAISE okl_api.g_exception_error;
2475: END IF;
2476: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
2477: l_return_status := validate_attributes(l_def_pamv_rec);

Line 2474: RAISE okl_api.g_exception_error;

2470:
2471: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2472: RAISE okl_api.g_exception_unexpected_error;
2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2474: RAISE okl_api.g_exception_error;
2475: END IF;
2476: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
2477: l_return_status := validate_attributes(l_def_pamv_rec);
2478:

Line 2479: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2475: END IF;
2476: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
2477: l_return_status := validate_attributes(l_def_pamv_rec);
2478:
2479: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2480: RAISE okl_api.g_exception_unexpected_error;
2481: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2482: RAISE okl_api.g_exception_error;
2483: END IF;

Line 2480: RAISE okl_api.g_exception_unexpected_error;

2476: l_def_pamv_rec := fill_who_columns(l_def_pamv_rec);
2477: l_return_status := validate_attributes(l_def_pamv_rec);
2478:
2479: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2480: RAISE okl_api.g_exception_unexpected_error;
2481: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2482: RAISE okl_api.g_exception_error;
2483: END IF;
2484: l_return_status := validate_record(l_def_pamv_rec);

Line 2481: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2477: l_return_status := validate_attributes(l_def_pamv_rec);
2478:
2479: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2480: RAISE okl_api.g_exception_unexpected_error;
2481: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2482: RAISE okl_api.g_exception_error;
2483: END IF;
2484: l_return_status := validate_record(l_def_pamv_rec);
2485:

Line 2482: RAISE okl_api.g_exception_error;

2478:
2479: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2480: RAISE okl_api.g_exception_unexpected_error;
2481: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2482: RAISE okl_api.g_exception_error;
2483: END IF;
2484: l_return_status := validate_record(l_def_pamv_rec);
2485:
2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2482: RAISE okl_api.g_exception_error;
2483: END IF;
2484: l_return_status := validate_record(l_def_pamv_rec);
2485:
2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2487: RAISE okl_api.g_exception_unexpected_error;
2488: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2489: RAISE okl_api.g_exception_error;
2490: END IF;

Line 2487: RAISE okl_api.g_exception_unexpected_error;

2483: END IF;
2484: l_return_status := validate_record(l_def_pamv_rec);
2485:
2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2487: RAISE okl_api.g_exception_unexpected_error;
2488: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2489: RAISE okl_api.g_exception_error;
2490: END IF;
2491:

Line 2488: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2484: l_return_status := validate_record(l_def_pamv_rec);
2485:
2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2487: RAISE okl_api.g_exception_unexpected_error;
2488: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2489: RAISE okl_api.g_exception_error;
2490: END IF;
2491:
2492: --lock the row

Line 2489: RAISE okl_api.g_exception_error;

2485:
2486: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2487: RAISE okl_api.g_exception_unexpected_error;
2488: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2489: RAISE okl_api.g_exception_error;
2490: END IF;
2491:
2492: --lock the row
2493:

Line 2495: ,p_init_msg_list => okl_api.g_false

2491:
2492: --lock the row
2493:
2494: lock_row(p_api_version => l_api_version
2495: ,p_init_msg_list => okl_api.g_false
2496: ,x_return_status => l_return_status
2497: ,x_msg_count => x_msg_count
2498: ,x_msg_data => x_msg_data
2499: ,p_pamv_rec => l_def_pamv_rec);

Line 2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2497: ,x_msg_count => x_msg_count
2498: ,x_msg_data => x_msg_data
2499: ,p_pamv_rec => l_def_pamv_rec);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;

Line 2502: RAISE okl_api.g_exception_unexpected_error;

2498: ,x_msg_data => x_msg_data
2499: ,p_pamv_rec => l_def_pamv_rec);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506: migrate(l_def_pamv_rec

Line 2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2499: ,p_pamv_rec => l_def_pamv_rec);
2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506: migrate(l_def_pamv_rec
2507: ,l_pamb_rec);

Line 2504: RAISE okl_api.g_exception_error;

2500:
2501: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2502: RAISE okl_api.g_exception_unexpected_error;
2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506: migrate(l_def_pamv_rec
2507: ,l_pamb_rec);
2508: migrate(l_def_pamv_rec

Line 2518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2514: ,x_msg_data
2515: ,l_pamb_rec
2516: ,lx_pamb_rec);
2517:
2518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2519: RAISE okl_api.g_exception_unexpected_error;
2520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2521: RAISE okl_api.g_exception_error;
2522: END IF;

Line 2519: RAISE okl_api.g_exception_unexpected_error;

2515: ,l_pamb_rec
2516: ,lx_pamb_rec);
2517:
2518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2519: RAISE okl_api.g_exception_unexpected_error;
2520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2521: RAISE okl_api.g_exception_error;
2522: END IF;
2523: migrate(lx_pamb_rec

Line 2520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2516: ,lx_pamb_rec);
2517:
2518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2519: RAISE okl_api.g_exception_unexpected_error;
2520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2521: RAISE okl_api.g_exception_error;
2522: END IF;
2523: migrate(lx_pamb_rec
2524: ,l_def_pamv_rec);

Line 2521: RAISE okl_api.g_exception_error;

2517:
2518: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2519: RAISE okl_api.g_exception_unexpected_error;
2520: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2521: RAISE okl_api.g_exception_error;
2522: END IF;
2523: migrate(lx_pamb_rec
2524: ,l_def_pamv_rec);
2525: update_row(p_api_version

Line 2533: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2529: ,x_msg_data
2530: ,l_pamtl_rec
2531: ,lx_pamtl_rec);
2532:
2533: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2534: RAISE okl_api.g_exception_unexpected_error;
2535: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2536: RAISE okl_api.g_exception_error;
2537: END IF;

Line 2534: RAISE okl_api.g_exception_unexpected_error;

2530: ,l_pamtl_rec
2531: ,lx_pamtl_rec);
2532:
2533: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2534: RAISE okl_api.g_exception_unexpected_error;
2535: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2536: RAISE okl_api.g_exception_error;
2537: END IF;
2538: migrate(lx_pamtl_rec

Line 2535: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2531: ,lx_pamtl_rec);
2532:
2533: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2534: RAISE okl_api.g_exception_unexpected_error;
2535: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2536: RAISE okl_api.g_exception_error;
2537: END IF;
2538: migrate(lx_pamtl_rec
2539: ,l_def_pamv_rec);

Line 2536: RAISE okl_api.g_exception_error;

2532:
2533: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2534: RAISE okl_api.g_exception_unexpected_error;
2535: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2536: RAISE okl_api.g_exception_error;
2537: END IF;
2538: migrate(lx_pamtl_rec
2539: ,l_def_pamv_rec);
2540:

Line 2544: okl_api.end_activity(x_msg_count

2540:
2541: --Set OUT Values
2542:
2543: x_pamv_rec := l_def_pamv_rec;
2544: okl_api.end_activity(x_msg_count
2545: ,x_msg_data);
2546: EXCEPTION
2547: WHEN g_exception_halt_validation THEN
2548:

Line 2552: WHEN okl_api.g_exception_error THEN

2548:
2549: -- No action necessary. Validation can continue to next attribute/column
2550:
2551: NULL;
2552: WHEN okl_api.g_exception_error THEN
2553: x_return_status := okl_api.handle_exceptions(l_api_name
2554: ,g_pkg_name
2555: ,'OKL_API.G_RET_STS_ERROR'
2556: ,x_msg_count

Line 2553: x_return_status := okl_api.handle_exceptions(l_api_name

2549: -- No action necessary. Validation can continue to next attribute/column
2550:
2551: NULL;
2552: WHEN okl_api.g_exception_error THEN
2553: x_return_status := okl_api.handle_exceptions(l_api_name
2554: ,g_pkg_name
2555: ,'OKL_API.G_RET_STS_ERROR'
2556: ,x_msg_count
2557: ,x_msg_data

Line 2555: ,'OKL_API.G_RET_STS_ERROR'

2551: NULL;
2552: WHEN okl_api.g_exception_error THEN
2553: x_return_status := okl_api.handle_exceptions(l_api_name
2554: ,g_pkg_name
2555: ,'OKL_API.G_RET_STS_ERROR'
2556: ,x_msg_count
2557: ,x_msg_data
2558: ,'_PVT');
2559: WHEN okl_api.g_exception_unexpected_error THEN

Line 2559: WHEN okl_api.g_exception_unexpected_error THEN

2555: ,'OKL_API.G_RET_STS_ERROR'
2556: ,x_msg_count
2557: ,x_msg_data
2558: ,'_PVT');
2559: WHEN okl_api.g_exception_unexpected_error THEN
2560: x_return_status := okl_api.handle_exceptions(l_api_name
2561: ,g_pkg_name
2562: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2563: ,x_msg_count

Line 2560: x_return_status := okl_api.handle_exceptions(l_api_name

2556: ,x_msg_count
2557: ,x_msg_data
2558: ,'_PVT');
2559: WHEN okl_api.g_exception_unexpected_error THEN
2560: x_return_status := okl_api.handle_exceptions(l_api_name
2561: ,g_pkg_name
2562: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2563: ,x_msg_count
2564: ,x_msg_data

Line 2562: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2558: ,'_PVT');
2559: WHEN okl_api.g_exception_unexpected_error THEN
2560: x_return_status := okl_api.handle_exceptions(l_api_name
2561: ,g_pkg_name
2562: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2563: ,x_msg_count
2564: ,x_msg_data
2565: ,'_PVT');
2566: WHEN OTHERS THEN

Line 2567: x_return_status := okl_api.handle_exceptions(l_api_name

2563: ,x_msg_count
2564: ,x_msg_data
2565: ,'_PVT');
2566: WHEN OTHERS THEN
2567: x_return_status := okl_api.handle_exceptions(l_api_name
2568: ,g_pkg_name
2569: ,'OTHERS'
2570: ,x_msg_count
2571: ,x_msg_data

Line 2580: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2576: -- Procedure insert_row_tbl
2577: --------------------------------------------------------------------------------
2578:
2579: PROCEDURE update_row(p_api_version IN NUMBER
2580: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2581: ,x_return_status OUT NOCOPY VARCHAR2
2582: ,x_msg_count OUT NOCOPY NUMBER
2583: ,x_msg_data OUT NOCOPY VARCHAR2
2584: ,p_pamv_tbl IN okl_pamv_tbl

Line 2588: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2584: ,p_pamv_tbl IN okl_pamv_tbl
2585: ,x_pamv_tbl OUT NOCOPY okl_pamv_tbl) IS
2586: l_api_version CONSTANT NUMBER := 1;
2587: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2588: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2589: i NUMBER := 0;
2590: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2591:
2592: BEGIN

Line 2590: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2586: l_api_version CONSTANT NUMBER := 1;
2587: l_api_name CONSTANT VARCHAR2(30) := 'v_update_row';
2588: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2589: i NUMBER := 0;
2590: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2591:
2592: BEGIN
2593: okl_api.init_msg_list(p_init_msg_list);
2594:

Line 2593: okl_api.init_msg_list(p_init_msg_list);

2589: i NUMBER := 0;
2590: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2591:
2592: BEGIN
2593: okl_api.init_msg_list(p_init_msg_list);
2594:
2595: -- Make sure PL/SQL table has records in it before passing
2596:
2597: IF (p_pamv_tbl.COUNT > 0) THEN

Line 2602: ,p_init_msg_list => okl_api.g_false

2598: i := p_pamv_tbl.FIRST;
2599:
2600: LOOP
2601: update_row(p_api_version => p_api_version
2602: ,p_init_msg_list => okl_api.g_false
2603: ,x_return_status => x_return_status
2604: ,x_msg_count => x_msg_count
2605: ,x_msg_data => x_msg_data
2606: ,p_pamv_rec => p_pamv_tbl(i)

Line 2608: IF x_return_status <> okl_api.g_ret_sts_success THEN

2604: ,x_msg_count => x_msg_count
2605: ,x_msg_data => x_msg_data
2606: ,p_pamv_rec => p_pamv_tbl(i)
2607: ,x_pamv_rec => x_pamv_tbl(i));
2608: IF x_return_status <> okl_api.g_ret_sts_success THEN
2609: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2610: l_overall_status := x_return_status;
2611: END IF;
2612: END IF;

Line 2609: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

2605: ,x_msg_data => x_msg_data
2606: ,p_pamv_rec => p_pamv_tbl(i)
2607: ,x_pamv_rec => x_pamv_tbl(i));
2608: IF x_return_status <> okl_api.g_ret_sts_success THEN
2609: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2610: l_overall_status := x_return_status;
2611: END IF;
2612: END IF;
2613: EXIT WHEN(i = p_pamv_tbl.LAST);

Line 2625: WHEN okl_api.g_exception_error THEN

2621:
2622: -- No action necessary. Validation can continue to next attribute/column
2623:
2624: NULL;
2625: WHEN okl_api.g_exception_error THEN
2626: x_return_status := okl_api.handle_exceptions(l_api_name
2627: ,g_pkg_name
2628: ,'OKL_API.G_RET_STS_ERROR'
2629: ,x_msg_count

Line 2626: x_return_status := okl_api.handle_exceptions(l_api_name

2622: -- No action necessary. Validation can continue to next attribute/column
2623:
2624: NULL;
2625: WHEN okl_api.g_exception_error THEN
2626: x_return_status := okl_api.handle_exceptions(l_api_name
2627: ,g_pkg_name
2628: ,'OKL_API.G_RET_STS_ERROR'
2629: ,x_msg_count
2630: ,x_msg_data

Line 2628: ,'OKL_API.G_RET_STS_ERROR'

2624: NULL;
2625: WHEN okl_api.g_exception_error THEN
2626: x_return_status := okl_api.handle_exceptions(l_api_name
2627: ,g_pkg_name
2628: ,'OKL_API.G_RET_STS_ERROR'
2629: ,x_msg_count
2630: ,x_msg_data
2631: ,'_PVT');
2632: WHEN okl_api.g_exception_unexpected_error THEN

Line 2632: WHEN okl_api.g_exception_unexpected_error THEN

2628: ,'OKL_API.G_RET_STS_ERROR'
2629: ,x_msg_count
2630: ,x_msg_data
2631: ,'_PVT');
2632: WHEN okl_api.g_exception_unexpected_error THEN
2633: x_return_status := okl_api.handle_exceptions(l_api_name
2634: ,g_pkg_name
2635: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2636: ,x_msg_count

Line 2633: x_return_status := okl_api.handle_exceptions(l_api_name

2629: ,x_msg_count
2630: ,x_msg_data
2631: ,'_PVT');
2632: WHEN okl_api.g_exception_unexpected_error THEN
2633: x_return_status := okl_api.handle_exceptions(l_api_name
2634: ,g_pkg_name
2635: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2636: ,x_msg_count
2637: ,x_msg_data

Line 2635: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2631: ,'_PVT');
2632: WHEN okl_api.g_exception_unexpected_error THEN
2633: x_return_status := okl_api.handle_exceptions(l_api_name
2634: ,g_pkg_name
2635: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2636: ,x_msg_count
2637: ,x_msg_data
2638: ,'_PVT');
2639: WHEN OTHERS THEN

Line 2640: x_return_status := okl_api.handle_exceptions(l_api_name

2636: ,x_msg_count
2637: ,x_msg_data
2638: ,'_PVT');
2639: WHEN OTHERS THEN
2640: x_return_status := okl_api.handle_exceptions(l_api_name
2641: ,g_pkg_name
2642: ,'OTHERS'
2643: ,x_msg_count
2644: ,x_msg_data

Line 2653: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2649: -- Procedure delete_row_b
2650: --------------------------------------------------------------------------------
2651:
2652: PROCEDURE delete_row(p_api_version IN NUMBER
2653: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2654: ,x_return_status OUT NOCOPY VARCHAR2
2655: ,x_msg_count OUT NOCOPY NUMBER
2656: ,x_msg_data OUT NOCOPY VARCHAR2
2657: ,p_pamb_rec IN okl_pamb_rec) IS

Line 2660: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2656: ,x_msg_data OUT NOCOPY VARCHAR2
2657: ,p_pamb_rec IN okl_pamb_rec) IS
2658: l_api_version CONSTANT NUMBER := 1;
2659: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2660: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2661: l_pamb_rec okl_pamb_rec := p_pamb_rec;
2662: l_row_notfound BOOLEAN := true;
2663:
2664: BEGIN

Line 2665: l_return_status := okl_api.start_activity(l_api_name

2661: l_pamb_rec okl_pamb_rec := p_pamb_rec;
2662: l_row_notfound BOOLEAN := true;
2663:
2664: BEGIN
2665: l_return_status := okl_api.start_activity(l_api_name
2666: ,g_pkg_name
2667: ,p_init_msg_list
2668: ,l_api_version
2669: ,p_api_version

Line 2673: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2669: ,p_api_version
2670: ,'_PVT'
2671: ,x_return_status);
2672:
2673: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2674: RAISE okl_api.g_exception_unexpected_error;
2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2676: RAISE okl_api.g_exception_error;
2677: END IF;

Line 2674: RAISE okl_api.g_exception_unexpected_error;

2670: ,'_PVT'
2671: ,x_return_status);
2672:
2673: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2674: RAISE okl_api.g_exception_unexpected_error;
2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2676: RAISE okl_api.g_exception_error;
2677: END IF;
2678:

Line 2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2671: ,x_return_status);
2672:
2673: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2674: RAISE okl_api.g_exception_unexpected_error;
2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2676: RAISE okl_api.g_exception_error;
2677: END IF;
2678:
2679: DELETE FROM okl_fe_adj_mat_all_b

Line 2676: RAISE okl_api.g_exception_error;

2672:
2673: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2674: RAISE okl_api.g_exception_unexpected_error;
2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2676: RAISE okl_api.g_exception_error;
2677: END IF;
2678:
2679: DELETE FROM okl_fe_adj_mat_all_b
2680: WHERE adj_mat_id = l_pamb_rec.adj_mat_id;

Line 2688: WHEN okl_api.g_exception_error THEN

2684:
2685: -- No action necessary. Validation can continue to next attribute/column
2686:
2687: NULL;
2688: WHEN okl_api.g_exception_error THEN
2689: x_return_status := okl_api.handle_exceptions(l_api_name
2690: ,g_pkg_name
2691: ,'OKL_API.G_RET_STS_ERROR'
2692: ,x_msg_count

Line 2689: x_return_status := okl_api.handle_exceptions(l_api_name

2685: -- No action necessary. Validation can continue to next attribute/column
2686:
2687: NULL;
2688: WHEN okl_api.g_exception_error THEN
2689: x_return_status := okl_api.handle_exceptions(l_api_name
2690: ,g_pkg_name
2691: ,'OKL_API.G_RET_STS_ERROR'
2692: ,x_msg_count
2693: ,x_msg_data

Line 2691: ,'OKL_API.G_RET_STS_ERROR'

2687: NULL;
2688: WHEN okl_api.g_exception_error THEN
2689: x_return_status := okl_api.handle_exceptions(l_api_name
2690: ,g_pkg_name
2691: ,'OKL_API.G_RET_STS_ERROR'
2692: ,x_msg_count
2693: ,x_msg_data
2694: ,'_PVT');
2695: WHEN okl_api.g_exception_unexpected_error THEN

Line 2695: WHEN okl_api.g_exception_unexpected_error THEN

2691: ,'OKL_API.G_RET_STS_ERROR'
2692: ,x_msg_count
2693: ,x_msg_data
2694: ,'_PVT');
2695: WHEN okl_api.g_exception_unexpected_error THEN
2696: x_return_status := okl_api.handle_exceptions(l_api_name
2697: ,g_pkg_name
2698: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2699: ,x_msg_count

Line 2696: x_return_status := okl_api.handle_exceptions(l_api_name

2692: ,x_msg_count
2693: ,x_msg_data
2694: ,'_PVT');
2695: WHEN okl_api.g_exception_unexpected_error THEN
2696: x_return_status := okl_api.handle_exceptions(l_api_name
2697: ,g_pkg_name
2698: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2699: ,x_msg_count
2700: ,x_msg_data

Line 2698: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2694: ,'_PVT');
2695: WHEN okl_api.g_exception_unexpected_error THEN
2696: x_return_status := okl_api.handle_exceptions(l_api_name
2697: ,g_pkg_name
2698: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2699: ,x_msg_count
2700: ,x_msg_data
2701: ,'_PVT');
2702: WHEN OTHERS THEN

Line 2703: x_return_status := okl_api.handle_exceptions(l_api_name

2699: ,x_msg_count
2700: ,x_msg_data
2701: ,'_PVT');
2702: WHEN OTHERS THEN
2703: x_return_status := okl_api.handle_exceptions(l_api_name
2704: ,g_pkg_name
2705: ,'OTHERS'
2706: ,x_msg_count
2707: ,x_msg_data

Line 2716: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2712: -- Procedure delete_row_tl
2713: --------------------------------------------------------------------------------
2714:
2715: PROCEDURE delete_row(p_api_version IN NUMBER
2716: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2717: ,x_return_status OUT NOCOPY VARCHAR2
2718: ,x_msg_count OUT NOCOPY NUMBER
2719: ,x_msg_data OUT NOCOPY VARCHAR2
2720: ,p_pamtl_rec IN okl_pamtl_rec) IS

Line 2723: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2719: ,x_msg_data OUT NOCOPY VARCHAR2
2720: ,p_pamtl_rec IN okl_pamtl_rec) IS
2721: l_api_version CONSTANT NUMBER := 1;
2722: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
2723: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2724: l_pamtl_rec okl_pamtl_rec := p_pamtl_rec;
2725: l_row_notfound BOOLEAN := true;
2726:
2727: FUNCTION set_attributes(p_pamtl_rec IN okl_pamtl_rec

Line 2729: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2725: l_row_notfound BOOLEAN := true;
2726:
2727: FUNCTION set_attributes(p_pamtl_rec IN okl_pamtl_rec
2728: ,x_pamtl_rec OUT NOCOPY okl_pamtl_rec) RETURN VARCHAR2 IS
2729: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2730:
2731: BEGIN
2732: x_pamtl_rec := p_pamtl_rec;
2733: x_pamtl_rec.language := USERENV('LANG');

Line 2739: l_return_status := okl_api.start_activity(l_api_name

2735: RETURN(l_return_status);
2736: END set_attributes;
2737:
2738: BEGIN
2739: l_return_status := okl_api.start_activity(l_api_name
2740: ,g_pkg_name
2741: ,p_init_msg_list
2742: ,l_api_version
2743: ,p_api_version

Line 2747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2743: ,p_api_version
2744: ,'_PVT'
2745: ,x_return_status);
2746:
2747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2748: RAISE okl_api.g_exception_unexpected_error;
2749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2750: RAISE okl_api.g_exception_error;
2751: END IF;

Line 2748: RAISE okl_api.g_exception_unexpected_error;

2744: ,'_PVT'
2745: ,x_return_status);
2746:
2747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2748: RAISE okl_api.g_exception_unexpected_error;
2749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2750: RAISE okl_api.g_exception_error;
2751: END IF;
2752:

Line 2749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2745: ,x_return_status);
2746:
2747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2748: RAISE okl_api.g_exception_unexpected_error;
2749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2750: RAISE okl_api.g_exception_error;
2751: END IF;
2752:
2753: --Setting Item Attributes

Line 2750: RAISE okl_api.g_exception_error;

2746:
2747: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2748: RAISE okl_api.g_exception_unexpected_error;
2749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2750: RAISE okl_api.g_exception_error;
2751: END IF;
2752:
2753: --Setting Item Attributes
2754:

Line 2758: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2754:
2755: l_return_status := set_attributes(p_pamtl_rec
2756: ,l_pamtl_rec);
2757:
2758: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2759: RAISE okl_api.g_exception_unexpected_error;
2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2761: RAISE okl_api.g_exception_error;
2762: END IF;

Line 2759: RAISE okl_api.g_exception_unexpected_error;

2755: l_return_status := set_attributes(p_pamtl_rec
2756: ,l_pamtl_rec);
2757:
2758: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2759: RAISE okl_api.g_exception_unexpected_error;
2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2761: RAISE okl_api.g_exception_error;
2762: END IF;
2763:

Line 2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2756: ,l_pamtl_rec);
2757:
2758: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2759: RAISE okl_api.g_exception_unexpected_error;
2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2761: RAISE okl_api.g_exception_error;
2762: END IF;
2763:
2764: DELETE FROM okl_fe_adj_mat_all_tl

Line 2761: RAISE okl_api.g_exception_error;

2757:
2758: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2759: RAISE okl_api.g_exception_unexpected_error;
2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2761: RAISE okl_api.g_exception_error;
2762: END IF;
2763:
2764: DELETE FROM okl_fe_adj_mat_all_tl
2765: WHERE adj_mat_id = l_pamtl_rec.adj_mat_id;

Line 2773: WHEN okl_api.g_exception_error THEN

2769:
2770: -- No action necessary. Validation can continue to next attribute/column
2771:
2772: NULL;
2773: WHEN okl_api.g_exception_error THEN
2774: x_return_status := okl_api.handle_exceptions(l_api_name
2775: ,g_pkg_name
2776: ,'OKL_API.G_RET_STS_ERROR'
2777: ,x_msg_count

Line 2774: x_return_status := okl_api.handle_exceptions(l_api_name

2770: -- No action necessary. Validation can continue to next attribute/column
2771:
2772: NULL;
2773: WHEN okl_api.g_exception_error THEN
2774: x_return_status := okl_api.handle_exceptions(l_api_name
2775: ,g_pkg_name
2776: ,'OKL_API.G_RET_STS_ERROR'
2777: ,x_msg_count
2778: ,x_msg_data

Line 2776: ,'OKL_API.G_RET_STS_ERROR'

2772: NULL;
2773: WHEN okl_api.g_exception_error THEN
2774: x_return_status := okl_api.handle_exceptions(l_api_name
2775: ,g_pkg_name
2776: ,'OKL_API.G_RET_STS_ERROR'
2777: ,x_msg_count
2778: ,x_msg_data
2779: ,'_PVT');
2780: WHEN okl_api.g_exception_unexpected_error THEN

Line 2780: WHEN okl_api.g_exception_unexpected_error THEN

2776: ,'OKL_API.G_RET_STS_ERROR'
2777: ,x_msg_count
2778: ,x_msg_data
2779: ,'_PVT');
2780: WHEN okl_api.g_exception_unexpected_error THEN
2781: x_return_status := okl_api.handle_exceptions(l_api_name
2782: ,g_pkg_name
2783: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2784: ,x_msg_count

Line 2781: x_return_status := okl_api.handle_exceptions(l_api_name

2777: ,x_msg_count
2778: ,x_msg_data
2779: ,'_PVT');
2780: WHEN okl_api.g_exception_unexpected_error THEN
2781: x_return_status := okl_api.handle_exceptions(l_api_name
2782: ,g_pkg_name
2783: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2784: ,x_msg_count
2785: ,x_msg_data

Line 2783: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2779: ,'_PVT');
2780: WHEN okl_api.g_exception_unexpected_error THEN
2781: x_return_status := okl_api.handle_exceptions(l_api_name
2782: ,g_pkg_name
2783: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2784: ,x_msg_count
2785: ,x_msg_data
2786: ,'_PVT');
2787: WHEN OTHERS THEN

Line 2788: x_return_status := okl_api.handle_exceptions(l_api_name

2784: ,x_msg_count
2785: ,x_msg_data
2786: ,'_PVT');
2787: WHEN OTHERS THEN
2788: x_return_status := okl_api.handle_exceptions(l_api_name
2789: ,g_pkg_name
2790: ,'OTHERS'
2791: ,x_msg_count
2792: ,x_msg_data

Line 2801: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2797: -- Procedure delete_row_v
2798: --------------------------------------------------------------------------------
2799:
2800: PROCEDURE delete_row(p_api_version IN NUMBER
2801: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2802: ,x_return_status OUT NOCOPY VARCHAR2
2803: ,x_msg_count OUT NOCOPY NUMBER
2804: ,x_msg_data OUT NOCOPY VARCHAR2
2805: ,p_pamv_rec IN okl_pamv_rec) IS

Line 2808: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2804: ,x_msg_data OUT NOCOPY VARCHAR2
2805: ,p_pamv_rec IN okl_pamv_rec) IS
2806: l_api_version CONSTANT NUMBER := 1;
2807: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
2808: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2809: l_pamv_rec okl_pamv_rec := p_pamv_rec;
2810: l_pamb_rec okl_pamb_rec;
2811: l_pamtl_rec okl_pamtl_rec;
2812:

Line 2814: l_return_status := okl_api.start_activity(l_api_name

2810: l_pamb_rec okl_pamb_rec;
2811: l_pamtl_rec okl_pamtl_rec;
2812:
2813: BEGIN
2814: l_return_status := okl_api.start_activity(l_api_name
2815: ,g_pkg_name
2816: ,p_init_msg_list
2817: ,l_api_version
2818: ,p_api_version

Line 2822: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2818: ,p_api_version
2819: ,'_PVT'
2820: ,x_return_status);
2821:
2822: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2823: RAISE okl_api.g_exception_unexpected_error;
2824: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2825: RAISE okl_api.g_exception_error;
2826: END IF;

Line 2823: RAISE okl_api.g_exception_unexpected_error;

2819: ,'_PVT'
2820: ,x_return_status);
2821:
2822: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2823: RAISE okl_api.g_exception_unexpected_error;
2824: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2825: RAISE okl_api.g_exception_error;
2826: END IF;
2827: migrate(l_pamv_rec

Line 2824: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2820: ,x_return_status);
2821:
2822: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2823: RAISE okl_api.g_exception_unexpected_error;
2824: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2825: RAISE okl_api.g_exception_error;
2826: END IF;
2827: migrate(l_pamv_rec
2828: ,l_pamb_rec);

Line 2825: RAISE okl_api.g_exception_error;

2821:
2822: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2823: RAISE okl_api.g_exception_unexpected_error;
2824: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2825: RAISE okl_api.g_exception_error;
2826: END IF;
2827: migrate(l_pamv_rec
2828: ,l_pamb_rec);
2829: migrate(l_pamv_rec

Line 2838: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2834: ,x_msg_count
2835: ,x_msg_data
2836: ,l_pamb_rec);
2837:
2838: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2839: RAISE okl_api.g_exception_unexpected_error;
2840: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2841: RAISE okl_api.g_exception_error;
2842: END IF;

Line 2839: RAISE okl_api.g_exception_unexpected_error;

2835: ,x_msg_data
2836: ,l_pamb_rec);
2837:
2838: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2839: RAISE okl_api.g_exception_unexpected_error;
2840: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2841: RAISE okl_api.g_exception_error;
2842: END IF;
2843: delete_row(p_api_version

Line 2840: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2836: ,l_pamb_rec);
2837:
2838: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2839: RAISE okl_api.g_exception_unexpected_error;
2840: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2841: RAISE okl_api.g_exception_error;
2842: END IF;
2843: delete_row(p_api_version
2844: ,p_init_msg_list

Line 2841: RAISE okl_api.g_exception_error;

2837:
2838: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2839: RAISE okl_api.g_exception_unexpected_error;
2840: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2841: RAISE okl_api.g_exception_error;
2842: END IF;
2843: delete_row(p_api_version
2844: ,p_init_msg_list
2845: ,x_return_status

Line 2850: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2846: ,x_msg_count
2847: ,x_msg_data
2848: ,l_pamtl_rec);
2849:
2850: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2851: RAISE okl_api.g_exception_unexpected_error;
2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2853: RAISE okl_api.g_exception_error;
2854: END IF;

Line 2851: RAISE okl_api.g_exception_unexpected_error;

2847: ,x_msg_data
2848: ,l_pamtl_rec);
2849:
2850: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2851: RAISE okl_api.g_exception_unexpected_error;
2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2853: RAISE okl_api.g_exception_error;
2854: END IF;
2855: okl_api.end_activity(x_msg_count

Line 2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2848: ,l_pamtl_rec);
2849:
2850: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2851: RAISE okl_api.g_exception_unexpected_error;
2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2853: RAISE okl_api.g_exception_error;
2854: END IF;
2855: okl_api.end_activity(x_msg_count
2856: ,x_msg_data);

Line 2853: RAISE okl_api.g_exception_error;

2849:
2850: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2851: RAISE okl_api.g_exception_unexpected_error;
2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2853: RAISE okl_api.g_exception_error;
2854: END IF;
2855: okl_api.end_activity(x_msg_count
2856: ,x_msg_data);
2857: EXCEPTION

Line 2855: okl_api.end_activity(x_msg_count

2851: RAISE okl_api.g_exception_unexpected_error;
2852: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2853: RAISE okl_api.g_exception_error;
2854: END IF;
2855: okl_api.end_activity(x_msg_count
2856: ,x_msg_data);
2857: EXCEPTION
2858: WHEN g_exception_halt_validation THEN
2859:

Line 2863: WHEN okl_api.g_exception_error THEN

2859:
2860: -- No action necessary. Validation can continue to next attribute/column
2861:
2862: NULL;
2863: WHEN okl_api.g_exception_error THEN
2864: x_return_status := okl_api.handle_exceptions(l_api_name
2865: ,g_pkg_name
2866: ,'OKL_API.G_RET_STS_ERROR'
2867: ,x_msg_count

Line 2864: x_return_status := okl_api.handle_exceptions(l_api_name

2860: -- No action necessary. Validation can continue to next attribute/column
2861:
2862: NULL;
2863: WHEN okl_api.g_exception_error THEN
2864: x_return_status := okl_api.handle_exceptions(l_api_name
2865: ,g_pkg_name
2866: ,'OKL_API.G_RET_STS_ERROR'
2867: ,x_msg_count
2868: ,x_msg_data

Line 2866: ,'OKL_API.G_RET_STS_ERROR'

2862: NULL;
2863: WHEN okl_api.g_exception_error THEN
2864: x_return_status := okl_api.handle_exceptions(l_api_name
2865: ,g_pkg_name
2866: ,'OKL_API.G_RET_STS_ERROR'
2867: ,x_msg_count
2868: ,x_msg_data
2869: ,'_PVT');
2870: WHEN okl_api.g_exception_unexpected_error THEN

Line 2870: WHEN okl_api.g_exception_unexpected_error THEN

2866: ,'OKL_API.G_RET_STS_ERROR'
2867: ,x_msg_count
2868: ,x_msg_data
2869: ,'_PVT');
2870: WHEN okl_api.g_exception_unexpected_error THEN
2871: x_return_status := okl_api.handle_exceptions(l_api_name
2872: ,g_pkg_name
2873: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2874: ,x_msg_count

Line 2871: x_return_status := okl_api.handle_exceptions(l_api_name

2867: ,x_msg_count
2868: ,x_msg_data
2869: ,'_PVT');
2870: WHEN okl_api.g_exception_unexpected_error THEN
2871: x_return_status := okl_api.handle_exceptions(l_api_name
2872: ,g_pkg_name
2873: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2874: ,x_msg_count
2875: ,x_msg_data

Line 2873: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2869: ,'_PVT');
2870: WHEN okl_api.g_exception_unexpected_error THEN
2871: x_return_status := okl_api.handle_exceptions(l_api_name
2872: ,g_pkg_name
2873: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2874: ,x_msg_count
2875: ,x_msg_data
2876: ,'_PVT');
2877: WHEN OTHERS THEN

Line 2878: x_return_status := okl_api.handle_exceptions(l_api_name

2874: ,x_msg_count
2875: ,x_msg_data
2876: ,'_PVT');
2877: WHEN OTHERS THEN
2878: x_return_status := okl_api.handle_exceptions(l_api_name
2879: ,g_pkg_name
2880: ,'OTHERS'
2881: ,x_msg_count
2882: ,x_msg_data

Line 2891: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2887: -- Procedure delete_row_tbl
2888: --------------------------------------------------------------------------------
2889:
2890: PROCEDURE delete_row(p_api_version IN NUMBER
2891: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2892: ,x_return_status OUT NOCOPY VARCHAR2
2893: ,x_msg_count OUT NOCOPY NUMBER
2894: ,x_msg_data OUT NOCOPY VARCHAR2
2895: ,p_pamv_tbl IN okl_pamv_tbl) IS

Line 2898: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2894: ,x_msg_data OUT NOCOPY VARCHAR2
2895: ,p_pamv_tbl IN okl_pamv_tbl) IS
2896: l_api_version CONSTANT NUMBER := 1;
2897: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
2898: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2899: i NUMBER := 0;
2900: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2901:
2902: BEGIN

Line 2900: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;

2896: l_api_version CONSTANT NUMBER := 1;
2897: l_api_name CONSTANT VARCHAR2(30) := 'v_delete_row';
2898: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2899: i NUMBER := 0;
2900: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2901:
2902: BEGIN
2903: okl_api.init_msg_list(p_init_msg_list);
2904:

Line 2903: okl_api.init_msg_list(p_init_msg_list);

2899: i NUMBER := 0;
2900: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
2901:
2902: BEGIN
2903: okl_api.init_msg_list(p_init_msg_list);
2904:
2905: -- Make sure PL/SQL table has records in it before passing
2906:
2907: IF (p_pamv_tbl.COUNT > 0) THEN

Line 2912: ,p_init_msg_list => okl_api.g_false

2908: i := p_pamv_tbl.FIRST;
2909:
2910: LOOP
2911: delete_row(p_api_version => p_api_version
2912: ,p_init_msg_list => okl_api.g_false
2913: ,x_return_status => x_return_status
2914: ,x_msg_count => x_msg_count
2915: ,x_msg_data => x_msg_data
2916: ,p_pamv_rec => p_pamv_tbl(i));

Line 2917: IF x_return_status <> okl_api.g_ret_sts_success THEN

2913: ,x_return_status => x_return_status
2914: ,x_msg_count => x_msg_count
2915: ,x_msg_data => x_msg_data
2916: ,p_pamv_rec => p_pamv_tbl(i));
2917: IF x_return_status <> okl_api.g_ret_sts_success THEN
2918: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2919: l_overall_status := x_return_status;
2920: END IF;
2921: END IF;

Line 2918: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN

2914: ,x_msg_count => x_msg_count
2915: ,x_msg_data => x_msg_data
2916: ,p_pamv_rec => p_pamv_tbl(i));
2917: IF x_return_status <> okl_api.g_ret_sts_success THEN
2918: IF l_overall_status <> okl_api.g_ret_sts_unexp_error THEN
2919: l_overall_status := x_return_status;
2920: END IF;
2921: END IF;
2922: EXIT WHEN(i = p_pamv_tbl.LAST);

Line 2934: WHEN okl_api.g_exception_error THEN

2930:
2931: -- No action necessary. Validation can continue to next attribute/column
2932:
2933: NULL;
2934: WHEN okl_api.g_exception_error THEN
2935: x_return_status := okl_api.handle_exceptions(l_api_name
2936: ,g_pkg_name
2937: ,'OKL_API.G_RET_STS_ERROR'
2938: ,x_msg_count

Line 2935: x_return_status := okl_api.handle_exceptions(l_api_name

2931: -- No action necessary. Validation can continue to next attribute/column
2932:
2933: NULL;
2934: WHEN okl_api.g_exception_error THEN
2935: x_return_status := okl_api.handle_exceptions(l_api_name
2936: ,g_pkg_name
2937: ,'OKL_API.G_RET_STS_ERROR'
2938: ,x_msg_count
2939: ,x_msg_data

Line 2937: ,'OKL_API.G_RET_STS_ERROR'

2933: NULL;
2934: WHEN okl_api.g_exception_error THEN
2935: x_return_status := okl_api.handle_exceptions(l_api_name
2936: ,g_pkg_name
2937: ,'OKL_API.G_RET_STS_ERROR'
2938: ,x_msg_count
2939: ,x_msg_data
2940: ,'_PVT');
2941: WHEN okl_api.g_exception_unexpected_error THEN

Line 2941: WHEN okl_api.g_exception_unexpected_error THEN

2937: ,'OKL_API.G_RET_STS_ERROR'
2938: ,x_msg_count
2939: ,x_msg_data
2940: ,'_PVT');
2941: WHEN okl_api.g_exception_unexpected_error THEN
2942: x_return_status := okl_api.handle_exceptions(l_api_name
2943: ,g_pkg_name
2944: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2945: ,x_msg_count

Line 2942: x_return_status := okl_api.handle_exceptions(l_api_name

2938: ,x_msg_count
2939: ,x_msg_data
2940: ,'_PVT');
2941: WHEN okl_api.g_exception_unexpected_error THEN
2942: x_return_status := okl_api.handle_exceptions(l_api_name
2943: ,g_pkg_name
2944: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2945: ,x_msg_count
2946: ,x_msg_data

Line 2944: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2940: ,'_PVT');
2941: WHEN okl_api.g_exception_unexpected_error THEN
2942: x_return_status := okl_api.handle_exceptions(l_api_name
2943: ,g_pkg_name
2944: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2945: ,x_msg_count
2946: ,x_msg_data
2947: ,'_PVT');
2948: WHEN OTHERS THEN

Line 2949: x_return_status := okl_api.handle_exceptions(l_api_name

2945: ,x_msg_count
2946: ,x_msg_data
2947: ,'_PVT');
2948: WHEN OTHERS THEN
2949: x_return_status := okl_api.handle_exceptions(l_api_name
2950: ,g_pkg_name
2951: ,'OTHERS'
2952: ,x_msg_count
2953: ,x_msg_data