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

Line 141: x_return_status := okc_api.g_ret_sts_error;

137: ,p_token1_value => 'END_OF_TERM_ID');
138:
139: -- notify caller of an error
140:
141: x_return_status := okc_api.g_ret_sts_error;
142: RAISE g_exception_halt_validation;
143: END IF;
144: OPEN pos_exists_csr;
145: FETCH pos_exists_csr INTO l_dummy_var ;

Line 158: x_return_status := okc_api.g_ret_sts_error;

154: ,p_token1_value => 'end_of_term_id');
155:
156: -- notify caller of an error
157:
158: x_return_status := okc_api.g_ret_sts_error;
159: RAISE g_exception_halt_validation;
160: END IF;
161:
162: EXCEPTION

Line 173: okc_api.set_message(p_app_name => g_app_name

169: WHEN OTHERS THEN
170:
171: -- store SQL error message on message stack for caller
172:
173: okc_api.set_message(p_app_name => g_app_name
174: ,p_msg_name => g_unexpected_error
175: ,p_token1 => g_sqlcode_token
176: ,p_token1_value => sqlcode
177: ,p_token2 => g_sqlerrm_token

Line 182: x_return_status := okc_api.g_ret_sts_unexp_error;

178: ,p_token2_value => sqlerrm);
179:
180: -- notify caller of an UNEXPECTED error
181:
182: x_return_status := okc_api.g_ret_sts_unexp_error;
183:
184: -- verify that cursor was closed
185:
186: IF pos_exists_csr%ISOPEN THEN

Line 224: okc_api.set_message(p_app_name => g_app_name

220: WHEN OTHERS THEN
221:
222: -- store SQL error message on message stack for caller
223:
224: okc_api.set_message(p_app_name => g_app_name
225: ,p_msg_name => g_unexpected_error
226: ,p_token1 => g_sqlcode_token
227: ,p_token1_value => sqlcode
228: ,p_token2 => g_sqlerrm_token

Line 233: x_return_status := okc_api.g_ret_sts_unexp_error;

229: ,p_token2_value => sqlerrm);
230:
231: -- notify caller of an UNEXPECTED error
232:
233: x_return_status := okc_api.g_ret_sts_unexp_error;
234: END validate_effective_from_date;
235:
236: PROCEDURE validate_sts_code(x_return_status OUT NOCOPY VARCHAR2
237: ,p_eve_rec IN okl_eve_rec) IS

Line 264: IF (x_return_status = okc_api.g_ret_sts_error) THEN

260:
261: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
262: ,p_lookup_code => p_eve_rec.sts_code);
263:
264: IF (x_return_status = okc_api.g_ret_sts_error) THEN
265: okc_api.set_message(p_app_name => g_app_name
266: ,p_msg_name => g_invalid_value
267: ,p_token1 => g_col_name_token
268: ,p_token1_value => 'sts_code'); -- notify caller of an error

Line 265: okc_api.set_message(p_app_name => g_app_name

261: x_return_status := okl_util.check_lookup_code(p_lookup_type => 'OKL_PRC_STATUS'
262: ,p_lookup_code => p_eve_rec.sts_code);
263:
264: IF (x_return_status = okc_api.g_ret_sts_error) THEN
265: okc_api.set_message(p_app_name => g_app_name
266: ,p_msg_name => g_invalid_value
267: ,p_token1 => g_col_name_token
268: ,p_token1_value => 'sts_code'); -- notify caller of an error
269: RAISE g_exception_halt_validation;

Line 270: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

266: ,p_msg_name => g_invalid_value
267: ,p_token1 => g_col_name_token
268: ,p_token1_value => 'sts_code'); -- notify caller of an error
269: RAISE g_exception_halt_validation;
270: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
271:
272: -- notify caller of an error
273:
274: x_return_status := okc_api.g_ret_sts_unexp_error;

Line 274: x_return_status := okc_api.g_ret_sts_unexp_error;

270: ELSIF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
271:
272: -- notify caller of an error
273:
274: x_return_status := okc_api.g_ret_sts_unexp_error;
275: RAISE g_exception_halt_validation;
276: END IF;
277:
278: EXCEPTION

Line 289: okc_api.set_message(p_app_name => g_app_name

285: WHEN OTHERS THEN
286:
287: -- store SQL error message on message stack for caller
288:
289: okc_api.set_message(p_app_name => g_app_name
290: ,p_msg_name => g_unexpected_error
291: ,p_token1 => g_sqlcode_token
292: ,p_token1_value => sqlcode
293: ,p_token2 => g_sqlerrm_token

Line 298: x_return_status := okc_api.g_ret_sts_unexp_error;

294: ,p_token2_value => sqlerrm);
295:
296: -- notify caller of an UNEXPECTED error
297:
298: x_return_status := okc_api.g_ret_sts_unexp_error;
299: END validate_sts_code;
300:
301: --------------------------------------------------------------------------------
302: -- Procedure get_rec for OKL_FE_EO_TERM_VERS

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

511: RETURN(okc_p_util.raw_to_number(sys_guid()));
512: END get_seq_id;
513:
514: FUNCTION validate_attributes(p_eve_rec IN okl_eve_rec) RETURN VARCHAR2 IS
515: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
516: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
517:
518: BEGIN
519:

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

578: RETURN(x_return_status);
579: END validate_attributes;
580:
581: FUNCTION validate_record(p_eve_rec IN okl_eve_rec) RETURN VARCHAR2 IS
582: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
583: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
584:
585: BEGIN
586: IF (p_eve_rec.effective_to_date IS NOT NULL) THEN

Line 749: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

745: -- Procedure insert_row
746: --------------------------------------------------------------------------------
747:
748: PROCEDURE insert_row(p_api_version IN NUMBER
749: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
750: ,x_return_status OUT NOCOPY VARCHAR2
751: ,x_msg_count OUT NOCOPY NUMBER
752: ,x_msg_data OUT NOCOPY VARCHAR2
753: ,p_eve_rec IN okl_eve_rec

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

771: END fill_who_columns;
772:
773: FUNCTION set_attributes(p_eve_rec IN okl_eve_rec
774: ,x_eve_rec OUT NOCOPY okl_eve_rec) RETURN VARCHAR2 IS
775: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
776:
777: BEGIN
778: x_eve_rec := p_eve_rec;
779: x_eve_rec.object_version_number := 1;

Line 784: l_return_status := okc_api.start_activity(l_api_name

780: RETURN(l_return_status);
781: END set_attributes;
782:
783: BEGIN
784: l_return_status := okc_api.start_activity(l_api_name
785: ,g_pkg_name
786: ,p_init_msg_list
787: ,l_api_version
788: ,p_api_version

Line 793: RAISE okc_api.g_exception_unexpected_error;

789: ,'_PVT'
790: ,x_return_status);
791:
792: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
793: RAISE okc_api.g_exception_unexpected_error;
794: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
795: RAISE okc_api.g_exception_error;
796: END IF;
797: l_return_status := set_attributes(p_eve_rec

Line 795: RAISE okc_api.g_exception_error;

791:
792: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
793: RAISE okc_api.g_exception_unexpected_error;
794: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
795: RAISE okc_api.g_exception_error;
796: END IF;
797: l_return_status := set_attributes(p_eve_rec
798: ,l_eve_rec);
799:

Line 801: RAISE okc_api.g_exception_unexpected_error;

797: l_return_status := set_attributes(p_eve_rec
798: ,l_eve_rec);
799:
800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
801: RAISE okc_api.g_exception_unexpected_error;
802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
803: RAISE okc_api.g_exception_error;
804: END IF;
805: l_eve_rec := null_out_defaults(l_eve_rec);

Line 803: RAISE okc_api.g_exception_error;

799:
800: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
801: RAISE okc_api.g_exception_unexpected_error;
802: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
803: RAISE okc_api.g_exception_error;
804: END IF;
805: l_eve_rec := null_out_defaults(l_eve_rec);
806:
807: -- Set Primary key value

Line 817: RAISE okc_api.g_exception_unexpected_error;

813: l_return_status := set_attributes(l_eve_rec
814: ,l_def_eve_rec);
815:
816: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
817: RAISE okc_api.g_exception_unexpected_error;
818: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
819: RAISE okc_api.g_exception_error;
820: END IF;
821: l_def_eve_rec := fill_who_columns(l_def_eve_rec);

Line 819: RAISE okc_api.g_exception_error;

815:
816: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
817: RAISE okc_api.g_exception_unexpected_error;
818: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
819: RAISE okc_api.g_exception_error;
820: END IF;
821: l_def_eve_rec := fill_who_columns(l_def_eve_rec);
822: l_return_status := validate_attributes(l_def_eve_rec);
823:

Line 825: RAISE okc_api.g_exception_unexpected_error;

821: l_def_eve_rec := fill_who_columns(l_def_eve_rec);
822: l_return_status := validate_attributes(l_def_eve_rec);
823:
824: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
825: RAISE okc_api.g_exception_unexpected_error;
826: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
827: RAISE okc_api.g_exception_error;
828: END IF;
829: l_return_status := validate_record(l_def_eve_rec);

Line 827: RAISE okc_api.g_exception_error;

823:
824: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
825: RAISE okc_api.g_exception_unexpected_error;
826: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
827: RAISE okc_api.g_exception_error;
828: END IF;
829: l_return_status := validate_record(l_def_eve_rec);
830:
831: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 832: RAISE okc_api.g_exception_unexpected_error;

828: END IF;
829: l_return_status := validate_record(l_def_eve_rec);
830:
831: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
832: RAISE okc_api.g_exception_unexpected_error;
833: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
834: RAISE okc_api.g_exception_error;
835: END IF;
836:

Line 834: RAISE okc_api.g_exception_error;

830:
831: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
832: RAISE okc_api.g_exception_unexpected_error;
833: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
834: RAISE okc_api.g_exception_error;
835: END IF;
836:
837: INSERT INTO okl_fe_eo_term_vers
838: (end_of_term_ver_id

Line 896: RAISE okc_api.g_exception_unexpected_error;

892: ,l_def_eve_rec.last_update_date
893: ,l_def_eve_rec.last_update_login);
894:
895: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
896: RAISE okc_api.g_exception_unexpected_error;
897: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
898: RAISE okc_api.g_exception_error;
899: END IF;
900:

Line 898: RAISE okc_api.g_exception_error;

894:
895: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
896: RAISE okc_api.g_exception_unexpected_error;
897: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
898: RAISE okc_api.g_exception_error;
899: END IF;
900:
901: --Set OUT Values
902:

Line 904: okc_api.end_activity(x_msg_count

900:
901: --Set OUT Values
902:
903: x_eve_rec := l_def_eve_rec;
904: okc_api.end_activity(x_msg_count
905: ,x_msg_data);
906: EXCEPTION
907: WHEN g_exception_halt_validation THEN
908:

Line 912: WHEN okc_api.g_exception_error THEN

908:
909: -- No action necessary. Validation can continue to next attribute/column
910:
911: NULL;
912: WHEN okc_api.g_exception_error THEN
913: x_return_status := okl_api.handle_exceptions(l_api_name
914: ,g_pkg_name
915: ,'OKL_API.G_RET_STS_ERROR'
916: ,x_msg_count

Line 919: WHEN okc_api.g_exception_unexpected_error THEN

915: ,'OKL_API.G_RET_STS_ERROR'
916: ,x_msg_count
917: ,x_msg_data
918: ,'_PVT');
919: WHEN okc_api.g_exception_unexpected_error THEN
920: x_return_status := okl_api.handle_exceptions(l_api_name
921: ,g_pkg_name
922: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
923: ,x_msg_count

Line 940: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

936: -- Procedure insert_row_tbl
937: --------------------------------------------------------------------------------
938:
939: PROCEDURE insert_row(p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
941: ,x_return_status OUT NOCOPY VARCHAR2
942: ,x_msg_count OUT NOCOPY NUMBER
943: ,x_msg_data OUT NOCOPY VARCHAR2
944: ,p_eve_tbl IN okl_eve_tbl

Line 953: okc_api.init_msg_list(p_init_msg_list);

949: i NUMBER := 0;
950: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
951:
952: BEGIN
953: okc_api.init_msg_list(p_init_msg_list);
954:
955: -- Make sure PL/SQL table has records in it before passing
956:
957: IF (p_eve_tbl.COUNT > 0) THEN

Line 962: ,p_init_msg_list => okc_api.g_false

958: i := p_eve_tbl.FIRST;
959:
960: LOOP
961: insert_row(p_api_version => p_api_version
962: ,p_init_msg_list => okc_api.g_false
963: ,x_return_status => x_return_status
964: ,x_msg_count => x_msg_count
965: ,x_msg_data => x_msg_data
966: ,p_eve_rec => p_eve_tbl(i)

Line 968: IF x_return_status <> okc_api.g_ret_sts_success THEN

964: ,x_msg_count => x_msg_count
965: ,x_msg_data => x_msg_data
966: ,p_eve_rec => p_eve_tbl(i)
967: ,x_eve_rec => x_eve_tbl(i));
968: IF x_return_status <> okc_api.g_ret_sts_success THEN
969: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
970: l_overall_status := x_return_status;
971: END IF;
972: END IF;

Line 969: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

965: ,x_msg_data => x_msg_data
966: ,p_eve_rec => p_eve_tbl(i)
967: ,x_eve_rec => x_eve_tbl(i));
968: IF x_return_status <> okc_api.g_ret_sts_success THEN
969: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
970: l_overall_status := x_return_status;
971: END IF;
972: END IF;
973: EXIT WHEN(i = p_eve_tbl.LAST);

Line 985: WHEN okc_api.g_exception_error THEN

981:
982: -- No action necessary. Validation can continue to next attribute/column
983:
984: NULL;
985: WHEN okc_api.g_exception_error THEN
986: x_return_status := okl_api.handle_exceptions(l_api_name
987: ,g_pkg_name
988: ,'OKL_API.G_RET_STS_ERROR'
989: ,x_msg_count

Line 992: WHEN okc_api.g_exception_unexpected_error THEN

988: ,'OKL_API.G_RET_STS_ERROR'
989: ,x_msg_count
990: ,x_msg_data
991: ,'_PVT');
992: WHEN okc_api.g_exception_unexpected_error THEN
993: x_return_status := okl_api.handle_exceptions(l_api_name
994: ,g_pkg_name
995: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
996: ,x_msg_count

Line 1013: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1009: -- Procedure update_row
1010: --------------------------------------------------------------------------------
1011:
1012: PROCEDURE update_row(p_api_version IN NUMBER
1013: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1014: ,x_return_status OUT NOCOPY VARCHAR2
1015: ,x_msg_count OUT NOCOPY NUMBER
1016: ,x_msg_data OUT NOCOPY VARCHAR2
1017: ,p_eve_rec IN okl_eve_rec

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

1166: END populate_new_record;
1167:
1168: FUNCTION set_attributes(p_eve_rec IN okl_eve_rec
1169: ,x_eve_rec OUT NOCOPY okl_eve_rec) RETURN VARCHAR2 IS
1170: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1171:
1172: BEGIN
1173: x_eve_rec := p_eve_rec;
1174: RETURN(l_return_status);

Line 1178: l_return_status := okc_api.start_activity(l_api_name

1174: RETURN(l_return_status);
1175: END set_attributes;
1176:
1177: BEGIN
1178: l_return_status := okc_api.start_activity(l_api_name
1179: ,g_pkg_name
1180: ,p_init_msg_list
1181: ,l_api_version
1182: ,p_api_version

Line 1187: RAISE okc_api.g_exception_unexpected_error;

1183: ,'_PVT'
1184: ,x_return_status);
1185:
1186: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1187: RAISE okc_api.g_exception_unexpected_error;
1188: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1189: RAISE okc_api.g_exception_error;
1190: END IF;
1191:

Line 1189: RAISE okc_api.g_exception_error;

1185:
1186: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1187: RAISE okc_api.g_exception_unexpected_error;
1188: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1189: RAISE okc_api.g_exception_error;
1190: END IF;
1191:
1192: --Setting Item Attributes
1193:

Line 1198: RAISE okc_api.g_exception_unexpected_error;

1194: l_return_status := set_attributes(l_eve_rec
1195: ,lx_eve_rec);
1196:
1197: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1198: RAISE okc_api.g_exception_unexpected_error;
1199: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1200: RAISE okc_api.g_exception_error;
1201: END IF;
1202: l_return_status := populate_new_record(lx_eve_rec

Line 1200: RAISE okc_api.g_exception_error;

1196:
1197: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1198: RAISE okc_api.g_exception_unexpected_error;
1199: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1200: RAISE okc_api.g_exception_error;
1201: END IF;
1202: l_return_status := populate_new_record(lx_eve_rec
1203: ,l_def_eve_rec);
1204:

Line 1206: RAISE okc_api.g_exception_unexpected_error;

1202: l_return_status := populate_new_record(lx_eve_rec
1203: ,l_def_eve_rec);
1204:
1205: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1206: RAISE okc_api.g_exception_unexpected_error;
1207: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1208: RAISE okc_api.g_exception_error;
1209: END IF;
1210: l_def_eve_rec := null_out_defaults(l_def_eve_rec);

Line 1208: RAISE okc_api.g_exception_error;

1204:
1205: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1206: RAISE okc_api.g_exception_unexpected_error;
1207: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1208: RAISE okc_api.g_exception_error;
1209: END IF;
1210: l_def_eve_rec := null_out_defaults(l_def_eve_rec);
1211:
1212: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 1221: RAISE okc_api.g_exception_unexpected_error;

1217: l_def_eve_rec := fill_who_columns(l_def_eve_rec);
1218: l_return_status := validate_attributes(l_def_eve_rec);
1219:
1220: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1221: RAISE okc_api.g_exception_unexpected_error;
1222: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1223: RAISE okc_api.g_exception_error;
1224: END IF;
1225: l_return_status := validate_record(l_def_eve_rec);

Line 1223: RAISE okc_api.g_exception_error;

1219:
1220: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1221: RAISE okc_api.g_exception_unexpected_error;
1222: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1223: RAISE okc_api.g_exception_error;
1224: END IF;
1225: l_return_status := validate_record(l_def_eve_rec);
1226:
1227: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 1228: RAISE okc_api.g_exception_unexpected_error;

1224: END IF;
1225: l_return_status := validate_record(l_def_eve_rec);
1226:
1227: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1228: RAISE okc_api.g_exception_unexpected_error;
1229: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1230: RAISE okc_api.g_exception_error;
1231: END IF;
1232:

Line 1230: RAISE okc_api.g_exception_error;

1226:
1227: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1228: RAISE okc_api.g_exception_unexpected_error;
1229: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1230: RAISE okc_api.g_exception_error;
1231: END IF;
1232:
1233: -- Lock the row before updating
1234:

Line 1280: RAISE okc_api.g_exception_unexpected_error;

1276: ,last_update_login = l_def_eve_rec.last_update_login
1277: WHERE end_of_term_ver_id = l_def_eve_rec.end_of_term_ver_id;
1278:
1279: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1280: RAISE okc_api.g_exception_unexpected_error;
1281: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1282: RAISE okc_api.g_exception_error;
1283: END IF;
1284:

Line 1282: RAISE okc_api.g_exception_error;

1278:
1279: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1280: RAISE okc_api.g_exception_unexpected_error;
1281: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1282: RAISE okc_api.g_exception_error;
1283: END IF;
1284:
1285: --Set OUT Values
1286:

Line 1288: okc_api.end_activity(x_msg_count

1284:
1285: --Set OUT Values
1286:
1287: x_eve_rec := l_def_eve_rec;
1288: okc_api.end_activity(x_msg_count
1289: ,x_msg_data);
1290: EXCEPTION
1291: WHEN g_exception_halt_validation THEN
1292:

Line 1296: WHEN okc_api.g_exception_error THEN

1292:
1293: -- No action necessary. Validation can continue to next attribute/column
1294:
1295: NULL;
1296: WHEN okc_api.g_exception_error THEN
1297: x_return_status := okl_api.handle_exceptions(l_api_name
1298: ,g_pkg_name
1299: ,'OKL_API.G_RET_STS_ERROR'
1300: ,x_msg_count

Line 1303: WHEN okc_api.g_exception_unexpected_error THEN

1299: ,'OKL_API.G_RET_STS_ERROR'
1300: ,x_msg_count
1301: ,x_msg_data
1302: ,'_PVT');
1303: WHEN okc_api.g_exception_unexpected_error THEN
1304: x_return_status := okl_api.handle_exceptions(l_api_name
1305: ,g_pkg_name
1306: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1307: ,x_msg_count

Line 1324: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1320: -- Procedure insert_row_tbl
1321: --------------------------------------------------------------------------------
1322:
1323: PROCEDURE update_row(p_api_version IN NUMBER
1324: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1325: ,x_return_status OUT NOCOPY VARCHAR2
1326: ,x_msg_count OUT NOCOPY NUMBER
1327: ,x_msg_data OUT NOCOPY VARCHAR2
1328: ,p_eve_tbl IN okl_eve_tbl

Line 1346: ,p_init_msg_list => okc_api.g_false

1342: i := p_eve_tbl.FIRST;
1343:
1344: LOOP
1345: update_row(p_api_version => p_api_version
1346: ,p_init_msg_list => okc_api.g_false
1347: ,x_return_status => x_return_status
1348: ,x_msg_count => x_msg_count
1349: ,x_msg_data => x_msg_data
1350: ,p_eve_rec => p_eve_tbl(i)

Line 1352: IF x_return_status <> okc_api.g_ret_sts_success THEN

1348: ,x_msg_count => x_msg_count
1349: ,x_msg_data => x_msg_data
1350: ,p_eve_rec => p_eve_tbl(i)
1351: ,x_eve_rec => x_eve_tbl(i));
1352: IF x_return_status <> okc_api.g_ret_sts_success THEN
1353: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1354: l_overall_status := x_return_status;
1355: END IF;
1356: END IF;

Line 1353: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1349: ,x_msg_data => x_msg_data
1350: ,p_eve_rec => p_eve_tbl(i)
1351: ,x_eve_rec => x_eve_tbl(i));
1352: IF x_return_status <> okc_api.g_ret_sts_success THEN
1353: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1354: l_overall_status := x_return_status;
1355: END IF;
1356: END IF;
1357: EXIT WHEN(i = p_eve_tbl.LAST);

Line 1369: WHEN okc_api.g_exception_error THEN

1365:
1366: -- No action necessary. Validation can continue to next attribute/column
1367:
1368: NULL;
1369: WHEN okc_api.g_exception_error THEN
1370: x_return_status := okl_api.handle_exceptions(l_api_name
1371: ,g_pkg_name
1372: ,'OKL_API.G_RET_STS_ERROR'
1373: ,x_msg_count

Line 1376: WHEN okc_api.g_exception_unexpected_error THEN

1372: ,'OKL_API.G_RET_STS_ERROR'
1373: ,x_msg_count
1374: ,x_msg_data
1375: ,'_PVT');
1376: WHEN okc_api.g_exception_unexpected_error THEN
1377: x_return_status := okl_api.handle_exceptions(l_api_name
1378: ,g_pkg_name
1379: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1380: ,x_msg_count

Line 1397: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1393: -- Procedure delete_row_v
1394: --------------------------------------------------------------------------------
1395:
1396: PROCEDURE delete_row(p_api_version IN NUMBER
1397: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1398: ,x_return_status OUT NOCOPY VARCHAR2
1399: ,x_msg_count OUT NOCOPY NUMBER
1400: ,x_msg_data OUT NOCOPY VARCHAR2
1401: ,p_eve_rec IN okl_eve_rec) IS

Line 1408: l_return_status := okc_api.start_activity(l_api_name

1404: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1405: l_eve_rec okl_eve_rec := p_eve_rec;
1406:
1407: BEGIN
1408: l_return_status := okc_api.start_activity(l_api_name
1409: ,g_pkg_name
1410: ,p_init_msg_list
1411: ,l_api_version
1412: ,p_api_version

Line 1417: RAISE okc_api.g_exception_unexpected_error;

1413: ,'_PVT'
1414: ,x_return_status);
1415:
1416: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1417: RAISE okc_api.g_exception_unexpected_error;
1418: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1419: RAISE okc_api.g_exception_error;
1420: END IF;
1421:

Line 1419: RAISE okc_api.g_exception_error;

1415:
1416: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1417: RAISE okc_api.g_exception_unexpected_error;
1418: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1419: RAISE okc_api.g_exception_error;
1420: END IF;
1421:
1422: DELETE FROM okl_fe_eo_term_vers
1423: WHERE end_of_term_ver_id = l_eve_rec.end_of_term_ver_id;

Line 1426: RAISE okc_api.g_exception_unexpected_error;

1422: DELETE FROM okl_fe_eo_term_vers
1423: WHERE end_of_term_ver_id = l_eve_rec.end_of_term_ver_id;
1424:
1425: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okc_api.g_exception_unexpected_error;
1427: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okc_api.g_exception_error;
1429: END IF;
1430: okc_api.end_activity(x_msg_count

Line 1428: RAISE okc_api.g_exception_error;

1424:
1425: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okc_api.g_exception_unexpected_error;
1427: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okc_api.g_exception_error;
1429: END IF;
1430: okc_api.end_activity(x_msg_count
1431: ,x_msg_data);
1432: EXCEPTION

Line 1430: okc_api.end_activity(x_msg_count

1426: RAISE okc_api.g_exception_unexpected_error;
1427: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1428: RAISE okc_api.g_exception_error;
1429: END IF;
1430: okc_api.end_activity(x_msg_count
1431: ,x_msg_data);
1432: EXCEPTION
1433: WHEN g_exception_halt_validation THEN
1434:

Line 1438: WHEN okc_api.g_exception_error THEN

1434:
1435: -- No action necessary. Validation can continue to next attribute/column
1436:
1437: NULL;
1438: WHEN okc_api.g_exception_error THEN
1439: x_return_status := okl_api.handle_exceptions(l_api_name
1440: ,g_pkg_name
1441: ,'OKL_API.G_RET_STS_ERROR'
1442: ,x_msg_count

Line 1445: WHEN okc_api.g_exception_unexpected_error THEN

1441: ,'OKL_API.G_RET_STS_ERROR'
1442: ,x_msg_count
1443: ,x_msg_data
1444: ,'_PVT');
1445: WHEN okc_api.g_exception_unexpected_error THEN
1446: x_return_status := okl_api.handle_exceptions(l_api_name
1447: ,g_pkg_name
1448: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1449: ,x_msg_count

Line 1466: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1462: -- Procedure delete_row_tbl
1463: --------------------------------------------------------------------------------
1464:
1465: PROCEDURE delete_row(p_api_version IN NUMBER
1466: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1467: ,x_return_status OUT NOCOPY VARCHAR2
1468: ,x_msg_count OUT NOCOPY NUMBER
1469: ,x_msg_data OUT NOCOPY VARCHAR2
1470: ,p_eve_tbl IN okl_eve_tbl) IS

Line 1478: okc_api.init_msg_list(p_init_msg_list);

1474: i NUMBER := 0;
1475: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1476:
1477: BEGIN
1478: okc_api.init_msg_list(p_init_msg_list);
1479:
1480: -- Make sure PL/SQL table has records in it before passing
1481:
1482: IF (p_eve_tbl.COUNT > 0) THEN

Line 1487: ,p_init_msg_list => okc_api.g_false

1483: i := p_eve_tbl.FIRST;
1484:
1485: LOOP
1486: delete_row(p_api_version => p_api_version
1487: ,p_init_msg_list => okc_api.g_false
1488: ,x_return_status => x_return_status
1489: ,x_msg_count => x_msg_count
1490: ,x_msg_data => x_msg_data
1491: ,p_eve_rec => p_eve_tbl(i));

Line 1492: IF x_return_status <> okc_api.g_ret_sts_success THEN

1488: ,x_return_status => x_return_status
1489: ,x_msg_count => x_msg_count
1490: ,x_msg_data => x_msg_data
1491: ,p_eve_rec => p_eve_tbl(i));
1492: IF x_return_status <> okc_api.g_ret_sts_success THEN
1493: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1494: l_overall_status := x_return_status;
1495: END IF;
1496: END IF;

Line 1493: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1489: ,x_msg_count => x_msg_count
1490: ,x_msg_data => x_msg_data
1491: ,p_eve_rec => p_eve_tbl(i));
1492: IF x_return_status <> okc_api.g_ret_sts_success THEN
1493: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1494: l_overall_status := x_return_status;
1495: END IF;
1496: END IF;
1497: EXIT WHEN(i = p_eve_tbl.LAST);

Line 1509: WHEN okc_api.g_exception_error THEN

1505:
1506: -- No action necessary. Validation can continue to next attribute/column
1507:
1508: NULL;
1509: WHEN okc_api.g_exception_error THEN
1510: x_return_status := okl_api.handle_exceptions(l_api_name
1511: ,g_pkg_name
1512: ,'OKL_API.G_RET_STS_ERROR'
1513: ,x_msg_count

Line 1516: WHEN okc_api.g_exception_unexpected_error THEN

1512: ,'OKL_API.G_RET_STS_ERROR'
1513: ,x_msg_count
1514: ,x_msg_data
1515: ,'_PVT');
1516: WHEN okc_api.g_exception_unexpected_error THEN
1517: x_return_status := okl_api.handle_exceptions(l_api_name
1518: ,g_pkg_name
1519: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1520: ,x_msg_count