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

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

44: -- Local Variables
45: --
46: l_api_name CONSTANT VARCHAR2(30) := 'FIND_ERROR_SEGMENT';
47: l_api_version CONSTANT NUMBER := 1.0;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49:
50: l_flexfield fnd_dflex.dflex_r;
51: l_flexinfo fnd_dflex.dflex_dr;
52: l_global_context fnd_dflex.context_r;

Line 193: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

189: -- ----------------------------------------------------------------------------
190: --
191: PROCEDURE validate_desc_flex
192: (p_api_version IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
194: ,x_return_status OUT NOCOPY VARCHAR2
195: ,x_msg_count OUT NOCOPY NUMBER
196: ,x_msg_data OUT NOCOPY VARCHAR2
197: ,p_appl_short_name IN VARCHAR2

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

202: IS
203: --
204: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_DESC_FLEX';
205: l_api_version CONSTANT NUMBER := 1.0;
206: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
207: --
208: l_attr_set seg_info_tbl_type;
209: l_attr_set_cnt binary_integer;
210: l_segment_set seg_info_tbl_type;

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

277: IS
278: --
279: l_api_name CONSTANT VARCHAR2(30) := 'GET_NON_EXIST_ROWS';
280: l_api_version CONSTANT NUMBER := 1.0;
281: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
282: --
283: l_tbl1_row seg_info_rec_type;
284: --
285: l_tbl1_count binary_integer;

Line 358: l_return_status := OKL_API.START_ACTIVITY(

354:
355: -- call START_ACTIVITY to create savepoint, check compatibility
356: -- and initialize message list
357:
358: l_return_status := OKL_API.START_ACTIVITY(
359: p_api_name => l_api_name,
360: p_pkg_name => g_pkg_name,
361: p_init_msg_list => p_init_msg_list,
362: l_api_version => l_api_version,

Line 368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

364: p_api_type => g_api_type,
365: x_return_status => x_return_status);
366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;

Line 369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

365: x_return_status => x_return_status);
366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:

Line 370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

366:
367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:
374: l_attr_set_cnt := 0;

Line 371: raise OKL_API.G_EXCEPTION_ERROR;

367: -- check if activity started successfully
368: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
369: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
371: raise OKL_API.G_EXCEPTION_ERROR;
372: End If;
373:
374: l_attr_set_cnt := 0;
375:

Line 523: OKL_API.SET_MESSAGE

519: p_form_left_prompt => l_flex_seg_error_prompt,
520: p_table_name => l_table_name
521: );
522:
523: OKL_API.SET_MESSAGE
524: (p_app_name => G_APP_NAME
525: ,p_msg_name => 'OKL_DESC_FLEX_ERROR'
526: ,p_token1 => 'DESC_FLEX_MSG'
527: ,p_token1_value => FND_FLEX_DESCVAL.error_message

Line 537: RAISE OKL_API.G_EXCEPTION_ERROR;

533: ,p_token4_value => p_descflex_name
534: ,p_token5 => 'CONTEXT_VALUE'
535: ,p_token5_value => p_segment_values_rec.attribute_category);
536:
537: RAISE OKL_API.G_EXCEPTION_ERROR;
538: --
539: end if; -- FND_FLEX_DESCVAL.validate_desccols
540: --
541: -- Build the segment set

Line 596: OKL_API.SET_MESSAGE

592: flexfield_name => p_descflex_name,
593: flexfield => l_flexfield,
594: flexinfo => l_flexinfo);
595:
596: OKL_API.SET_MESSAGE
597: (p_app_name => G_APP_NAME
598: ,p_msg_name => 'OKL_NON_EXIST_SEG_NAME'
599: ,p_token1 => 'SEGMENT'
600: ,p_token1_value => l_ne_column_name

Line 610: RAISE OKL_API.G_EXCEPTION_ERROR;

606: ,p_token4_value => p_descflex_name
607: ,p_token5 => 'CONTEXT_VALUE'
608: ,p_token5_value => p_segment_values_rec.attribute_category);
609:
610: RAISE OKL_API.G_EXCEPTION_ERROR;
611: --
612: end if;
613: --
614: end loop;

Line 617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

613: --
614: end loop;
615: end if;
616:
617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);
619:
620: EXCEPTION
621: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 621: WHEN OKL_API.G_EXCEPTION_ERROR THEN

617: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data);
619:
620: EXCEPTION
621: WHEN OKL_API.G_EXCEPTION_ERROR THEN
622: x_return_status := OKL_API.HANDLE_EXCEPTIONS
623: (l_api_name,
624: G_PKG_NAME,
625: 'OKL_API.G_RET_STS_ERROR',

Line 622: x_return_status := OKL_API.HANDLE_EXCEPTIONS

618: x_msg_data => x_msg_data);
619:
620: EXCEPTION
621: WHEN OKL_API.G_EXCEPTION_ERROR THEN
622: x_return_status := OKL_API.HANDLE_EXCEPTIONS
623: (l_api_name,
624: G_PKG_NAME,
625: 'OKL_API.G_RET_STS_ERROR',
626: x_msg_count,

Line 625: 'OKL_API.G_RET_STS_ERROR',

621: WHEN OKL_API.G_EXCEPTION_ERROR THEN
622: x_return_status := OKL_API.HANDLE_EXCEPTIONS
623: (l_api_name,
624: G_PKG_NAME,
625: 'OKL_API.G_RET_STS_ERROR',
626: x_msg_count,
627: x_msg_data,
628: '_PVT');
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

625: 'OKL_API.G_RET_STS_ERROR',
626: x_msg_count,
627: x_msg_data,
628: '_PVT');
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (l_api_name,
632: G_PKG_NAME,
633: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

626: x_msg_count,
627: x_msg_data,
628: '_PVT');
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (l_api_name,
632: G_PKG_NAME,
633: 'OKL_API.G_RET_STS_UNEXP_ERROR',
634: x_msg_count,

Line 633: 'OKL_API.G_RET_STS_UNEXP_ERROR',

629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (l_api_name,
632: G_PKG_NAME,
633: 'OKL_API.G_RET_STS_UNEXP_ERROR',
634: x_msg_count,
635: x_msg_data,
636: '_PVT');
637: WHEN OTHERS THEN

Line 638: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

634: x_msg_count,
635: x_msg_data,
636: '_PVT');
637: WHEN OTHERS THEN
638: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
639: (l_api_name,
640: G_PKG_NAME,
641: 'OTHERS',
642: x_msg_count,

Line 654: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

650: -- ----------------------------------------------------------------------------
651: --
652: PROCEDURE update_contract_add_info
653: (p_api_version IN NUMBER
654: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
655: ,x_return_status OUT NOCOPY VARCHAR2
656: ,x_msg_count OUT NOCOPY NUMBER
657: ,x_msg_data OUT NOCOPY VARCHAR2
658: ,p_chr_id IN NUMBER

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

661: IS
662: --
663: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_ADD_INFO';
664: l_api_version CONSTANT NUMBER := 1.0;
665: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
666: --
667:
668: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
669: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 678: l_return_status := OKL_API.START_ACTIVITY(

674:
675: -- call START_ACTIVITY to create savepoint, check compatibility
676: -- and initialize message list
677:
678: l_return_status := OKL_API.START_ACTIVITY(
679: p_api_name => l_api_name,
680: p_pkg_name => g_pkg_name,
681: p_init_msg_list => p_init_msg_list,
682: l_api_version => l_api_version,

Line 688: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

684: p_api_type => g_api_type,
685: x_return_status => x_return_status);
686:
687: -- check if activity started successfully
688: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
689: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
691: raise OKL_API.G_EXCEPTION_ERROR;
692: End If;

Line 689: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

685: x_return_status => x_return_status);
686:
687: -- check if activity started successfully
688: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
689: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
691: raise OKL_API.G_EXCEPTION_ERROR;
692: End If;
693:

Line 690: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

686:
687: -- check if activity started successfully
688: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
689: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
691: raise OKL_API.G_EXCEPTION_ERROR;
692: End If;
693:
694: lp_chrv_rec.id := p_chr_id;

Line 691: raise OKL_API.G_EXCEPTION_ERROR;

687: -- check if activity started successfully
688: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
689: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
691: raise OKL_API.G_EXCEPTION_ERROR;
692: End If;
693:
694: lp_chrv_rec.id := p_chr_id;
695: lp_khrv_rec.id := p_chr_id;

Line 728: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

724: p_khrv_rec => lp_khrv_rec,
725: x_chrv_rec => lx_chrv_rec,
726: x_khrv_rec => lx_khrv_rec);
727:
728: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
731: RAISE OKL_API.G_EXCEPTION_ERROR;
732: END IF;

Line 729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

725: x_chrv_rec => lx_chrv_rec,
726: x_khrv_rec => lx_khrv_rec);
727:
728: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
731: RAISE OKL_API.G_EXCEPTION_ERROR;
732: END IF;
733:

Line 730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

726: x_khrv_rec => lx_khrv_rec);
727:
728: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
731: RAISE OKL_API.G_EXCEPTION_ERROR;
732: END IF;
733:
734: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 731: RAISE OKL_API.G_EXCEPTION_ERROR;

727:
728: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
731: RAISE OKL_API.G_EXCEPTION_ERROR;
732: END IF;
733:
734: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
735: x_msg_data => x_msg_data);

Line 734: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

730: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
731: RAISE OKL_API.G_EXCEPTION_ERROR;
732: END IF;
733:
734: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
735: x_msg_data => x_msg_data);
736:
737: EXCEPTION
738: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 738: WHEN OKL_API.G_EXCEPTION_ERROR THEN

734: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
735: x_msg_data => x_msg_data);
736:
737: EXCEPTION
738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
740: (l_api_name,
741: G_PKG_NAME,
742: 'OKL_API.G_RET_STS_ERROR',

Line 739: x_return_status := OKL_API.HANDLE_EXCEPTIONS

735: x_msg_data => x_msg_data);
736:
737: EXCEPTION
738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
740: (l_api_name,
741: G_PKG_NAME,
742: 'OKL_API.G_RET_STS_ERROR',
743: x_msg_count,

Line 742: 'OKL_API.G_RET_STS_ERROR',

738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
739: x_return_status := OKL_API.HANDLE_EXCEPTIONS
740: (l_api_name,
741: G_PKG_NAME,
742: 'OKL_API.G_RET_STS_ERROR',
743: x_msg_count,
744: x_msg_data,
745: '_PVT');
746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

742: 'OKL_API.G_RET_STS_ERROR',
743: x_msg_count,
744: x_msg_data,
745: '_PVT');
746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
747: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
748: (l_api_name,
749: G_PKG_NAME,
750: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 747: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

743: x_msg_count,
744: x_msg_data,
745: '_PVT');
746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
747: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
748: (l_api_name,
749: G_PKG_NAME,
750: 'OKL_API.G_RET_STS_UNEXP_ERROR',
751: x_msg_count,

Line 750: 'OKL_API.G_RET_STS_UNEXP_ERROR',

746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
747: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
748: (l_api_name,
749: G_PKG_NAME,
750: 'OKL_API.G_RET_STS_UNEXP_ERROR',
751: x_msg_count,
752: x_msg_data,
753: '_PVT');
754: WHEN OTHERS THEN

Line 755: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

751: x_msg_count,
752: x_msg_data,
753: '_PVT');
754: WHEN OTHERS THEN
755: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
756: (l_api_name,
757: G_PKG_NAME,
758: 'OTHERS',
759: x_msg_count,

Line 771: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

767: -- ----------------------------------------------------------------------------
768: --
769: PROCEDURE update_line_add_info
770: (p_api_version IN NUMBER
771: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
772: ,x_return_status OUT NOCOPY VARCHAR2
773: ,x_msg_count OUT NOCOPY NUMBER
774: ,x_msg_data OUT NOCOPY VARCHAR2
775: ,p_cle_id IN NUMBER

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

778: IS
779: --
780: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LINE_ADD_INFO';
781: l_api_version CONSTANT NUMBER := 1.0;
782: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
783: --
784:
785: lp_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
786: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 795: l_return_status := OKL_API.START_ACTIVITY(

791:
792: -- call START_ACTIVITY to create savepoint, check compatibility
793: -- and initialize message list
794:
795: l_return_status := OKL_API.START_ACTIVITY(
796: p_api_name => l_api_name,
797: p_pkg_name => g_pkg_name,
798: p_init_msg_list => p_init_msg_list,
799: l_api_version => l_api_version,

Line 805: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

801: p_api_type => g_api_type,
802: x_return_status => x_return_status);
803:
804: -- check if activity started successfully
805: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
806: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
808: raise OKL_API.G_EXCEPTION_ERROR;
809: End If;

Line 806: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

802: x_return_status => x_return_status);
803:
804: -- check if activity started successfully
805: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
806: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
808: raise OKL_API.G_EXCEPTION_ERROR;
809: End If;
810:

Line 807: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

803:
804: -- check if activity started successfully
805: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
806: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
808: raise OKL_API.G_EXCEPTION_ERROR;
809: End If;
810:
811: --Bug# 4959361

Line 808: raise OKL_API.G_EXCEPTION_ERROR;

804: -- check if activity started successfully
805: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
806: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
808: raise OKL_API.G_EXCEPTION_ERROR;
809: End If;
810:
811: --Bug# 4959361
812: OKL_LLA_UTIL_PVT.check_line_update_allowed

Line 820: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

816: x_msg_count => x_msg_count,
817: x_msg_data => x_msg_data,
818: p_cle_id => p_cle_id);
819:
820: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
822: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_ERROR;
824: END IF;

Line 821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

817: x_msg_data => x_msg_data,
818: p_cle_id => p_cle_id);
819:
820: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
822: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_ERROR;
824: END IF;
825: --Bug# 4959361

Line 822: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

818: p_cle_id => p_cle_id);
819:
820: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
822: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_ERROR;
824: END IF;
825: --Bug# 4959361
826:

Line 823: RAISE OKL_API.G_EXCEPTION_ERROR;

819:
820: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
822: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_ERROR;
824: END IF;
825: --Bug# 4959361
826:
827: lp_clev_rec.id := p_cle_id;

Line 860: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

856: p_klev_rec => lp_klev_rec,
857: x_clev_rec => lx_clev_rec,
858: x_klev_rec => lx_klev_rec);
859:
860: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_ERROR;
864: END IF;

Line 861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

857: x_clev_rec => lx_clev_rec,
858: x_klev_rec => lx_klev_rec);
859:
860: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_ERROR;
864: END IF;
865:

Line 862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

858: x_klev_rec => lx_klev_rec);
859:
860: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_ERROR;
864: END IF;
865:
866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 863: RAISE OKL_API.G_EXCEPTION_ERROR;

859:
860: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
861: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_ERROR;
864: END IF;
865:
866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
867: x_msg_data => x_msg_data);

Line 866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_ERROR;
864: END IF;
865:
866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
867: x_msg_data => x_msg_data);
868:
869: EXCEPTION
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 870: WHEN OKL_API.G_EXCEPTION_ERROR THEN

866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
867: x_msg_data => x_msg_data);
868:
869: EXCEPTION
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: x_return_status := OKL_API.HANDLE_EXCEPTIONS
872: (l_api_name,
873: G_PKG_NAME,
874: 'OKL_API.G_RET_STS_ERROR',

Line 871: x_return_status := OKL_API.HANDLE_EXCEPTIONS

867: x_msg_data => x_msg_data);
868:
869: EXCEPTION
870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: x_return_status := OKL_API.HANDLE_EXCEPTIONS
872: (l_api_name,
873: G_PKG_NAME,
874: 'OKL_API.G_RET_STS_ERROR',
875: x_msg_count,

Line 874: 'OKL_API.G_RET_STS_ERROR',

870: WHEN OKL_API.G_EXCEPTION_ERROR THEN
871: x_return_status := OKL_API.HANDLE_EXCEPTIONS
872: (l_api_name,
873: G_PKG_NAME,
874: 'OKL_API.G_RET_STS_ERROR',
875: x_msg_count,
876: x_msg_data,
877: '_PVT');
878: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 878: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

874: 'OKL_API.G_RET_STS_ERROR',
875: x_msg_count,
876: x_msg_data,
877: '_PVT');
878: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
879: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
880: (l_api_name,
881: G_PKG_NAME,
882: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 879: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

875: x_msg_count,
876: x_msg_data,
877: '_PVT');
878: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
879: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
880: (l_api_name,
881: G_PKG_NAME,
882: 'OKL_API.G_RET_STS_UNEXP_ERROR',
883: x_msg_count,

Line 882: 'OKL_API.G_RET_STS_UNEXP_ERROR',

878: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
879: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
880: (l_api_name,
881: G_PKG_NAME,
882: 'OKL_API.G_RET_STS_UNEXP_ERROR',
883: x_msg_count,
884: x_msg_data,
885: '_PVT');
886: WHEN OTHERS THEN

Line 887: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

883: x_msg_count,
884: x_msg_data,
885: '_PVT');
886: WHEN OTHERS THEN
887: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
888: (l_api_name,
889: G_PKG_NAME,
890: 'OTHERS',
891: x_msg_count,