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

Line 123: x_return_status := okc_api.g_ret_sts_error;

119: okl_api.set_message(p_app_name => g_app_name
120: ,p_msg_name => g_required_value
121: ,p_token1 => g_col_name_token
122: ,p_token1_value => 'END_OF_TERM_VER_ID'); -- notify caller of an error
123: x_return_status := okc_api.g_ret_sts_error;
124: RAISE g_exception_halt_validation;
125: END IF;
126: OPEN po_ver_exists_csr;
127: FETCH po_ver_exists_csr INTO l_dummy_var ;

Line 135: x_return_status := okc_api.g_ret_sts_error;

131: okl_api.set_message(p_app_name => g_app_name
132: ,p_msg_name => g_invalid_value
133: ,p_token1 => g_col_name_token
134: ,p_token1_value => 'END_OF_TERM_VER_ID'); -- notify caller of an error
135: x_return_status := okc_api.g_ret_sts_error;
136: RAISE g_exception_halt_validation;
137: END IF;
138:
139: EXCEPTION

Line 147: okc_api.set_message(p_app_name => g_app_name

143: -- with the next column
144:
145: NULL;
146: WHEN OTHERS THEN -- store SQL error message on message stack for caller
147: okc_api.set_message(p_app_name => g_app_name
148: ,p_msg_name => g_unexpected_error
149: ,p_token1 => g_sqlcode_token
150: ,p_token1_value => sqlcode
151: ,p_token2 => g_sqlerrm_token

Line 153: x_return_status := okc_api.g_ret_sts_unexp_error; -- verify that cursor was closed

149: ,p_token1 => g_sqlcode_token
150: ,p_token1_value => sqlcode
151: ,p_token2 => g_sqlerrm_token
152: ,p_token2_value => sqlerrm); -- notify caller of an UNEXPECTED error
153: x_return_status := okc_api.g_ret_sts_unexp_error; -- verify that cursor was closed
154:
155: IF po_ver_exists_csr%ISOPEN THEN
156: CLOSE po_ver_exists_csr;
157: END IF;

Line 360: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

356: RETURN(okc_p_util.raw_to_number(sys_guid()));
357: END get_seq_id;
358:
359: FUNCTION validate_attributes(p_etv_rec IN okl_etv_rec) RETURN VARCHAR2 IS
360: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
361: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
362:
363: BEGIN -- validate the id
364: validate_end_of_term_value_id(x_return_status => l_return_status

Line 400: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

396: RETURN(x_return_status);
397: END validate_attributes;
398:
399: FUNCTION validate_record(p_etv_rec IN okl_etv_rec) RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
401: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
402:
403: BEGIN
404: RETURN(x_return_status);

Line 556: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

552: -- Procedure insert_row
553: --------------------------------------------------------------------------------
554:
555: PROCEDURE insert_row(p_api_version IN NUMBER
556: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
557: ,x_return_status OUT NOCOPY VARCHAR2
558: ,x_msg_count OUT NOCOPY NUMBER
559: ,x_msg_data OUT NOCOPY VARCHAR2
560: ,p_etv_rec IN okl_etv_rec

Line 582: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

578: END fill_who_columns;
579:
580: FUNCTION set_attributes(p_etv_rec IN okl_etv_rec
581: ,x_etv_rec OUT NOCOPY okl_etv_rec) RETURN VARCHAR2 IS
582: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
583:
584: BEGIN
585: x_etv_rec := p_etv_rec;
586: x_etv_rec.object_version_number := 1;

Line 591: l_return_status := okc_api.start_activity(l_api_name

587: RETURN(l_return_status);
588: END set_attributes;
589:
590: BEGIN
591: l_return_status := okc_api.start_activity(l_api_name
592: ,g_pkg_name
593: ,p_init_msg_list
594: ,l_api_version
595: ,p_api_version

Line 600: RAISE okc_api.g_exception_unexpected_error;

596: ,'_PVT'
597: ,x_return_status);
598:
599: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
600: RAISE okc_api.g_exception_unexpected_error;
601: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
602: RAISE okc_api.g_exception_error;
603: END IF;
604: l_etv_rec := null_out_defaults(p_etv_rec); -- Set Primary key value

Line 602: RAISE okc_api.g_exception_error;

598:
599: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
600: RAISE okc_api.g_exception_unexpected_error;
601: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
602: RAISE okc_api.g_exception_error;
603: END IF;
604: l_etv_rec := null_out_defaults(p_etv_rec); -- Set Primary key value
605: l_etv_rec.end_of_term_value_id := get_seq_id; --Setting Item Attributes
606: l_return_status := set_attributes(l_etv_rec

Line 610: RAISE okc_api.g_exception_unexpected_error;

606: l_return_status := set_attributes(l_etv_rec
607: ,l_def_pvl_rec);
608:
609: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
610: RAISE okc_api.g_exception_unexpected_error;
611: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
612: RAISE okc_api.g_exception_error;
613: END IF;
614: l_def_pvl_rec := fill_who_columns(l_def_pvl_rec);

Line 612: RAISE okc_api.g_exception_error;

608:
609: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
610: RAISE okc_api.g_exception_unexpected_error;
611: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
612: RAISE okc_api.g_exception_error;
613: END IF;
614: l_def_pvl_rec := fill_who_columns(l_def_pvl_rec);
615: l_return_status := validate_attributes(l_def_pvl_rec);
616:

Line 618: RAISE okc_api.g_exception_unexpected_error;

614: l_def_pvl_rec := fill_who_columns(l_def_pvl_rec);
615: l_return_status := validate_attributes(l_def_pvl_rec);
616:
617: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
618: RAISE okc_api.g_exception_unexpected_error;
619: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
620: RAISE okc_api.g_exception_error;
621: END IF;
622: l_return_status := validate_record(l_def_pvl_rec);

Line 620: RAISE okc_api.g_exception_error;

616:
617: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
618: RAISE okc_api.g_exception_unexpected_error;
619: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
620: RAISE okc_api.g_exception_error;
621: END IF;
622: l_return_status := validate_record(l_def_pvl_rec);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 625: RAISE okc_api.g_exception_unexpected_error;

621: END IF;
622: l_return_status := validate_record(l_def_pvl_rec);
623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okc_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okc_api.g_exception_error;
628: END IF;
629:

Line 627: RAISE okc_api.g_exception_error;

623:
624: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
625: RAISE okc_api.g_exception_unexpected_error;
626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okc_api.g_exception_error;
628: END IF;
629:
630: INSERT INTO okl_fe_eo_term_values
631: (end_of_term_value_id

Line 685: RAISE okc_api.g_exception_unexpected_error;

681: ,l_def_pvl_rec.last_update_date
682: ,l_def_pvl_rec.last_update_login);
683:
684: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
685: RAISE okc_api.g_exception_unexpected_error;
686: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
687: RAISE okc_api.g_exception_error;
688: END IF; --Set OUT Values
689: x_etv_rec := l_def_pvl_rec;

Line 687: RAISE okc_api.g_exception_error;

683:
684: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
685: RAISE okc_api.g_exception_unexpected_error;
686: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
687: RAISE okc_api.g_exception_error;
688: END IF; --Set OUT Values
689: x_etv_rec := l_def_pvl_rec;
690: okc_api.end_activity(x_msg_count
691: ,x_msg_data);

Line 690: okc_api.end_activity(x_msg_count

686: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
687: RAISE okc_api.g_exception_error;
688: END IF; --Set OUT Values
689: x_etv_rec := l_def_pvl_rec;
690: okc_api.end_activity(x_msg_count
691: ,x_msg_data);
692: EXCEPTION
693: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
694: NULL;

Line 695: WHEN okc_api.g_exception_error THEN

691: ,x_msg_data);
692: EXCEPTION
693: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
694: NULL;
695: WHEN okc_api.g_exception_error THEN
696: x_return_status := okl_api.handle_exceptions(l_api_name
697: ,g_pkg_name
698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count

Line 702: WHEN okc_api.g_exception_unexpected_error THEN

698: ,'OKL_API.G_RET_STS_ERROR'
699: ,x_msg_count
700: ,x_msg_data
701: ,'_PVT');
702: WHEN okc_api.g_exception_unexpected_error THEN
703: x_return_status := okl_api.handle_exceptions(l_api_name
704: ,g_pkg_name
705: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
706: ,x_msg_count

Line 723: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

719: -- Procedure insert_row_tbl
720: --------------------------------------------------------------------------------
721:
722: PROCEDURE insert_row(p_api_version IN NUMBER
723: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
724: ,x_return_status OUT NOCOPY VARCHAR2
725: ,x_msg_count OUT NOCOPY NUMBER
726: ,x_msg_data OUT NOCOPY VARCHAR2
727: ,p_etv_tbl IN okl_etv_tbl

Line 736: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing

732: i NUMBER := 0;
733: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
734:
735: BEGIN
736: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
737:
738: IF (p_etv_tbl.COUNT > 0) THEN
739: i := p_etv_tbl.FIRST;
740:

Line 743: ,p_init_msg_list => okc_api.g_false

739: i := p_etv_tbl.FIRST;
740:
741: LOOP
742: insert_row(p_api_version => p_api_version
743: ,p_init_msg_list => okc_api.g_false
744: ,x_return_status => x_return_status
745: ,x_msg_count => x_msg_count
746: ,x_msg_data => x_msg_data
747: ,p_etv_rec => p_etv_tbl(i)

Line 749: IF x_return_status <> okc_api.g_ret_sts_success THEN

745: ,x_msg_count => x_msg_count
746: ,x_msg_data => x_msg_data
747: ,p_etv_rec => p_etv_tbl(i)
748: ,x_etv_rec => x_etv_tbl(i));
749: IF x_return_status <> okc_api.g_ret_sts_success THEN
750: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
751: l_overall_status := x_return_status;
752: END IF;
753: END IF;

Line 750: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

746: ,x_msg_data => x_msg_data
747: ,p_etv_rec => p_etv_tbl(i)
748: ,x_etv_rec => x_etv_tbl(i));
749: IF x_return_status <> okc_api.g_ret_sts_success THEN
750: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
751: l_overall_status := x_return_status;
752: END IF;
753: END IF;
754: EXIT WHEN(i = p_etv_tbl.LAST);

Line 763: WHEN okc_api.g_exception_error THEN

759:
760: EXCEPTION
761: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
762: NULL;
763: WHEN okc_api.g_exception_error THEN
764: x_return_status := okl_api.handle_exceptions(l_api_name
765: ,g_pkg_name
766: ,'OKL_API.G_RET_STS_ERROR'
767: ,x_msg_count

Line 770: WHEN okc_api.g_exception_unexpected_error THEN

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

Line 791: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

787: -- Procedure update_row
788: --------------------------------------------------------------------------------
789:
790: PROCEDURE update_row(p_api_version IN NUMBER
791: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER
794: ,x_msg_data OUT NOCOPY VARCHAR2
795: ,p_etv_rec IN okl_etv_rec

Line 937: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

933: END populate_new_record;
934:
935: FUNCTION set_attributes(p_etv_rec IN okl_etv_rec
936: ,x_etv_rec OUT NOCOPY okl_etv_rec) RETURN VARCHAR2 IS
937: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
938:
939: BEGIN
940: x_etv_rec := p_etv_rec;
941: RETURN(l_return_status);

Line 945: l_return_status := okc_api.start_activity(l_api_name

941: RETURN(l_return_status);
942: END set_attributes;
943:
944: BEGIN
945: l_return_status := okc_api.start_activity(l_api_name
946: ,g_pkg_name
947: ,p_init_msg_list
948: ,l_api_version
949: ,p_api_version

Line 954: RAISE okc_api.g_exception_unexpected_error;

950: ,'_PVT'
951: ,x_return_status);
952:
953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
954: RAISE okc_api.g_exception_unexpected_error;
955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
956: RAISE okc_api.g_exception_error;
957: END IF; --Setting Item Attributes
958: l_return_status := set_attributes(l_etv_rec

Line 956: RAISE okc_api.g_exception_error;

952:
953: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
954: RAISE okc_api.g_exception_unexpected_error;
955: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
956: RAISE okc_api.g_exception_error;
957: END IF; --Setting Item Attributes
958: l_return_status := set_attributes(l_etv_rec
959: ,lx_etv_rec);
960:

Line 962: RAISE okc_api.g_exception_unexpected_error;

958: l_return_status := set_attributes(l_etv_rec
959: ,lx_etv_rec);
960:
961: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
962: RAISE okc_api.g_exception_unexpected_error;
963: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
964: RAISE okc_api.g_exception_error;
965: END IF;
966: l_return_status := populate_new_record(lx_etv_rec

Line 964: RAISE okc_api.g_exception_error;

960:
961: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
962: RAISE okc_api.g_exception_unexpected_error;
963: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
964: RAISE okc_api.g_exception_error;
965: END IF;
966: l_return_status := populate_new_record(lx_etv_rec
967: ,l_def_etv_rec);
968:

Line 970: RAISE okc_api.g_exception_unexpected_error;

966: l_return_status := populate_new_record(lx_etv_rec
967: ,l_def_etv_rec);
968:
969: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
970: RAISE okc_api.g_exception_unexpected_error;
971: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
972: RAISE okc_api.g_exception_error;
973: END IF;
974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);

Line 972: RAISE okc_api.g_exception_error;

968:
969: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
970: RAISE okc_api.g_exception_unexpected_error;
971: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
972: RAISE okc_api.g_exception_error;
973: END IF;
974: l_def_etv_rec := null_out_defaults(l_def_etv_rec);
975:
976: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 985: RAISE okc_api.g_exception_unexpected_error;

981: l_def_etv_rec := fill_who_columns(l_def_etv_rec);
982: l_return_status := validate_attributes(l_def_etv_rec);
983:
984: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
985: RAISE okc_api.g_exception_unexpected_error;
986: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
987: RAISE okc_api.g_exception_error;
988: END IF;
989: l_return_status := validate_record(l_def_etv_rec);

Line 987: RAISE okc_api.g_exception_error;

983:
984: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
985: RAISE okc_api.g_exception_unexpected_error;
986: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
987: RAISE okc_api.g_exception_error;
988: END IF;
989: l_return_status := validate_record(l_def_etv_rec);
990:
991: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 992: RAISE okc_api.g_exception_unexpected_error;

988: END IF;
989: l_return_status := validate_record(l_def_etv_rec);
990:
991: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
992: RAISE okc_api.g_exception_unexpected_error;
993: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
994: RAISE okc_api.g_exception_error;
995: END IF; -- Lock the row before updating
996: lock_row(p_api_version => g_api_version

Line 994: RAISE okc_api.g_exception_error;

990:
991: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
992: RAISE okc_api.g_exception_unexpected_error;
993: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
994: RAISE okc_api.g_exception_error;
995: END IF; -- Lock the row before updating
996: lock_row(p_api_version => g_api_version
997: ,p_init_msg_list => g_false
998: ,x_return_status => l_return_status

Line 1039: RAISE okc_api.g_exception_unexpected_error;

1035: ,last_update_login = l_def_etv_rec.last_update_login
1036: WHERE end_of_term_value_id = l_def_etv_rec.end_of_term_value_id;
1037:
1038: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1039: RAISE okc_api.g_exception_unexpected_error;
1040: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1041: RAISE okc_api.g_exception_error;
1042: END IF; --Set OUT Values
1043: x_etv_rec := l_def_etv_rec;

Line 1041: RAISE okc_api.g_exception_error;

1037:
1038: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1039: RAISE okc_api.g_exception_unexpected_error;
1040: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1041: RAISE okc_api.g_exception_error;
1042: END IF; --Set OUT Values
1043: x_etv_rec := l_def_etv_rec;
1044: okc_api.end_activity(x_msg_count
1045: ,x_msg_data);

Line 1044: okc_api.end_activity(x_msg_count

1040: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1041: RAISE okc_api.g_exception_error;
1042: END IF; --Set OUT Values
1043: x_etv_rec := l_def_etv_rec;
1044: okc_api.end_activity(x_msg_count
1045: ,x_msg_data);
1046: EXCEPTION
1047: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1048: NULL;

Line 1049: WHEN okc_api.g_exception_error THEN

1045: ,x_msg_data);
1046: EXCEPTION
1047: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1048: NULL;
1049: WHEN okc_api.g_exception_error THEN
1050: x_return_status := okl_api.handle_exceptions(l_api_name
1051: ,g_pkg_name
1052: ,'OKL_API.G_RET_STS_ERROR'
1053: ,x_msg_count

Line 1056: WHEN okc_api.g_exception_unexpected_error THEN

1052: ,'OKL_API.G_RET_STS_ERROR'
1053: ,x_msg_count
1054: ,x_msg_data
1055: ,'_PVT');
1056: WHEN okc_api.g_exception_unexpected_error THEN
1057: x_return_status := okl_api.handle_exceptions(l_api_name
1058: ,g_pkg_name
1059: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1060: ,x_msg_count

Line 1077: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1073: -- Procedure insert_row_tbl
1074: --------------------------------------------------------------------------------
1075:
1076: PROCEDURE update_row(p_api_version IN NUMBER
1077: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1078: ,x_return_status OUT NOCOPY VARCHAR2
1079: ,x_msg_count OUT NOCOPY NUMBER
1080: ,x_msg_data OUT NOCOPY VARCHAR2
1081: ,p_etv_tbl IN okl_etv_tbl

Line 1090: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing

1086: i NUMBER := 0;
1087: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1088:
1089: BEGIN
1090: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
1091:
1092: IF (p_etv_tbl.COUNT > 0) THEN
1093: i := p_etv_tbl.FIRST;
1094:

Line 1097: ,p_init_msg_list => okc_api.g_false

1093: i := p_etv_tbl.FIRST;
1094:
1095: LOOP
1096: update_row(p_api_version => p_api_version
1097: ,p_init_msg_list => okc_api.g_false
1098: ,x_return_status => x_return_status
1099: ,x_msg_count => x_msg_count
1100: ,x_msg_data => x_msg_data
1101: ,p_etv_rec => p_etv_tbl(i)

Line 1103: IF x_return_status <> okc_api.g_ret_sts_success THEN

1099: ,x_msg_count => x_msg_count
1100: ,x_msg_data => x_msg_data
1101: ,p_etv_rec => p_etv_tbl(i)
1102: ,x_etv_rec => x_etv_tbl(i));
1103: IF x_return_status <> okc_api.g_ret_sts_success THEN
1104: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1105: l_overall_status := x_return_status;
1106: END IF;
1107: END IF;

Line 1104: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1100: ,x_msg_data => x_msg_data
1101: ,p_etv_rec => p_etv_tbl(i)
1102: ,x_etv_rec => x_etv_tbl(i));
1103: IF x_return_status <> okc_api.g_ret_sts_success THEN
1104: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1105: l_overall_status := x_return_status;
1106: END IF;
1107: END IF;
1108: EXIT WHEN(i = p_etv_tbl.LAST);

Line 1117: WHEN okc_api.g_exception_error THEN

1113:
1114: EXCEPTION
1115: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1116: NULL;
1117: WHEN okc_api.g_exception_error THEN
1118: x_return_status := okl_api.handle_exceptions(l_api_name
1119: ,g_pkg_name
1120: ,'OKL_API.G_RET_STS_ERROR'
1121: ,x_msg_count

Line 1124: WHEN okc_api.g_exception_unexpected_error THEN

1120: ,'OKL_API.G_RET_STS_ERROR'
1121: ,x_msg_count
1122: ,x_msg_data
1123: ,'_PVT');
1124: WHEN okc_api.g_exception_unexpected_error THEN
1125: x_return_status := okl_api.handle_exceptions(l_api_name
1126: ,g_pkg_name
1127: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1128: ,x_msg_count

Line 1145: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1141: -- Procedure delete_row
1142: --------------------------------------------------------------------------------
1143:
1144: PROCEDURE delete_row(p_api_version IN NUMBER
1145: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1146: ,x_return_status OUT NOCOPY VARCHAR2
1147: ,x_msg_count OUT NOCOPY NUMBER
1148: ,x_msg_data OUT NOCOPY VARCHAR2
1149: ,p_etv_rec IN okl_etv_rec) IS

Line 1156: l_return_status := okc_api.start_activity(l_api_name

1152: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1153: l_etv_rec okl_etv_rec := p_etv_rec;
1154:
1155: BEGIN
1156: l_return_status := okc_api.start_activity(l_api_name
1157: ,g_pkg_name
1158: ,p_init_msg_list
1159: ,l_api_version
1160: ,p_api_version

Line 1165: RAISE okc_api.g_exception_unexpected_error;

1161: ,'_PVT'
1162: ,x_return_status);
1163:
1164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1165: RAISE okc_api.g_exception_unexpected_error;
1166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1167: RAISE okc_api.g_exception_error;
1168: END IF;
1169:

Line 1167: RAISE okc_api.g_exception_error;

1163:
1164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1165: RAISE okc_api.g_exception_unexpected_error;
1166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1167: RAISE okc_api.g_exception_error;
1168: END IF;
1169:
1170: DELETE FROM okl_fe_eo_term_values
1171: WHERE end_of_term_value_id = l_etv_rec.end_of_term_value_id;

Line 1174: RAISE okc_api.g_exception_unexpected_error;

1170: DELETE FROM okl_fe_eo_term_values
1171: WHERE end_of_term_value_id = l_etv_rec.end_of_term_value_id;
1172:
1173: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1174: RAISE okc_api.g_exception_unexpected_error;
1175: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1176: RAISE okc_api.g_exception_error;
1177: END IF;
1178: okc_api.end_activity(x_msg_count

Line 1176: RAISE okc_api.g_exception_error;

1172:
1173: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1174: RAISE okc_api.g_exception_unexpected_error;
1175: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1176: RAISE okc_api.g_exception_error;
1177: END IF;
1178: okc_api.end_activity(x_msg_count
1179: ,x_msg_data);
1180: EXCEPTION

Line 1178: okc_api.end_activity(x_msg_count

1174: RAISE okc_api.g_exception_unexpected_error;
1175: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1176: RAISE okc_api.g_exception_error;
1177: END IF;
1178: okc_api.end_activity(x_msg_count
1179: ,x_msg_data);
1180: EXCEPTION
1181: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1182: NULL;

Line 1183: WHEN okc_api.g_exception_error THEN

1179: ,x_msg_data);
1180: EXCEPTION
1181: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1182: NULL;
1183: WHEN okc_api.g_exception_error THEN
1184: x_return_status := okl_api.handle_exceptions(l_api_name
1185: ,g_pkg_name
1186: ,'OKL_API.G_RET_STS_ERROR'
1187: ,x_msg_count

Line 1190: WHEN okc_api.g_exception_unexpected_error THEN

1186: ,'OKL_API.G_RET_STS_ERROR'
1187: ,x_msg_count
1188: ,x_msg_data
1189: ,'_PVT');
1190: WHEN okc_api.g_exception_unexpected_error THEN
1191: x_return_status := okl_api.handle_exceptions(l_api_name
1192: ,g_pkg_name
1193: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1194: ,x_msg_count

Line 1211: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1207: -- Procedure delete_row_tbl
1208: --------------------------------------------------------------------------------
1209:
1210: PROCEDURE delete_row(p_api_version IN NUMBER
1211: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1212: ,x_return_status OUT NOCOPY VARCHAR2
1213: ,x_msg_count OUT NOCOPY NUMBER
1214: ,x_msg_data OUT NOCOPY VARCHAR2
1215: ,p_etv_tbl IN okl_etv_tbl) IS

Line 1223: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing

1219: i NUMBER := 0;
1220: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1221:
1222: BEGIN
1223: okc_api.init_msg_list(p_init_msg_list); -- Make sure PL/SQL table has records in it before passing
1224:
1225: IF (p_etv_tbl.COUNT > 0) THEN
1226: i := p_etv_tbl.FIRST;
1227:

Line 1230: ,p_init_msg_list => okc_api.g_false

1226: i := p_etv_tbl.FIRST;
1227:
1228: LOOP
1229: delete_row(p_api_version => p_api_version
1230: ,p_init_msg_list => okc_api.g_false
1231: ,x_return_status => x_return_status
1232: ,x_msg_count => x_msg_count
1233: ,x_msg_data => x_msg_data
1234: ,p_etv_rec => p_etv_tbl(i));

Line 1235: IF x_return_status <> okc_api.g_ret_sts_success THEN

1231: ,x_return_status => x_return_status
1232: ,x_msg_count => x_msg_count
1233: ,x_msg_data => x_msg_data
1234: ,p_etv_rec => p_etv_tbl(i));
1235: IF x_return_status <> okc_api.g_ret_sts_success THEN
1236: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1237: l_overall_status := x_return_status;
1238: END IF;
1239: END IF;

Line 1236: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1232: ,x_msg_count => x_msg_count
1233: ,x_msg_data => x_msg_data
1234: ,p_etv_rec => p_etv_tbl(i));
1235: IF x_return_status <> okc_api.g_ret_sts_success THEN
1236: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1237: l_overall_status := x_return_status;
1238: END IF;
1239: END IF;
1240: EXIT WHEN(i = p_etv_tbl.LAST);

Line 1249: WHEN okc_api.g_exception_error THEN

1245:
1246: EXCEPTION
1247: WHEN g_exception_halt_validation THEN -- No action necessary. Validation can continue to next attribute/column
1248: NULL;
1249: WHEN okc_api.g_exception_error THEN
1250: x_return_status := okl_api.handle_exceptions(l_api_name
1251: ,g_pkg_name
1252: ,'OKL_API.G_RET_STS_ERROR'
1253: ,x_msg_count

Line 1256: WHEN okc_api.g_exception_unexpected_error THEN

1252: ,'OKL_API.G_RET_STS_ERROR'
1253: ,x_msg_count
1254: ,x_msg_data
1255: ,'_PVT');
1256: WHEN okc_api.g_exception_unexpected_error THEN
1257: x_return_status := okl_api.handle_exceptions(l_api_name
1258: ,g_pkg_name
1259: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1260: ,x_msg_count