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

Line 102: x_return_status := okc_api.g_ret_sts_error;

98: ,p_token1_value => 'organization_id');
99:
100: -- notify caller of an error
101:
102: x_return_status := okc_api.g_ret_sts_error;
103: RAISE g_exception_halt_validation;
104: END IF;
105: END IF;
106:

Line 118: okc_api.set_message(p_app_name => g_app_name

114: WHEN OTHERS THEN
115:
116: -- store SQL error message on message stack for caller
117:
118: okc_api.set_message(p_app_name => g_app_name
119: ,p_msg_name => g_unexpected_error
120: ,p_token1 => g_sqlcode_token
121: ,p_token1_value => sqlcode
122: ,p_token2 => g_sqlerrm_token

Line 127: x_return_status := okc_api.g_ret_sts_unexp_error;

123: ,p_token2_value => sqlerrm);
124:
125: -- notify caller of an UNEXPECTED error
126:
127: x_return_status := okc_api.g_ret_sts_unexp_error;
128:
129: -- verify that cursor was closed
130:
131: IF org_exists_csr%ISOPEN THEN

Line 169: x_return_status := okc_api.g_ret_sts_error;

165: ,p_token1_value => 'inventory_item_id');
166:
167: -- notify caller of an error
168:
169: x_return_status := okc_api.g_ret_sts_error;
170: RAISE g_exception_halt_validation;
171: END IF;
172: END IF;
173:

Line 185: okc_api.set_message(p_app_name => g_app_name

181: WHEN OTHERS THEN
182:
183: -- store SQL error message on message stack for caller
184:
185: okc_api.set_message(p_app_name => g_app_name
186: ,p_msg_name => g_unexpected_error
187: ,p_token1 => g_sqlcode_token
188: ,p_token1_value => sqlcode
189: ,p_token2 => g_sqlerrm_token

Line 194: x_return_status := okc_api.g_ret_sts_unexp_error;

190: ,p_token2_value => sqlerrm);
191:
192: -- notify caller of an UNEXPECTED error
193:
194: x_return_status := okc_api.g_ret_sts_unexp_error;
195:
196: -- verify that cursor was closed
197:
198: IF item_exists_csr%ISOPEN THEN

Line 236: x_return_status := okc_api.g_ret_sts_error;

232: ,p_token1_value => 'resi_category_set_id');
233:
234: -- notify caller of an error
235:
236: x_return_status := okc_api.g_ret_sts_error;
237: RAISE g_exception_halt_validation;
238: END IF;
239: END IF;
240:

Line 252: okc_api.set_message(p_app_name => g_app_name

248: WHEN OTHERS THEN
249:
250: -- store SQL error message on message stack for caller
251:
252: okc_api.set_message(p_app_name => g_app_name
253: ,p_msg_name => g_unexpected_error
254: ,p_token1 => g_sqlcode_token
255: ,p_token1_value => sqlcode
256: ,p_token2 => g_sqlerrm_token

Line 261: x_return_status := okc_api.g_ret_sts_unexp_error;

257: ,p_token2_value => sqlerrm);
258:
259: -- notify caller of an UNEXPECTED error
260:
261: x_return_status := okc_api.g_ret_sts_unexp_error;
262:
263: -- verify that cursor was closed
264:
265: IF rcs_exists_csr%ISOPEN THEN

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

491: RETURN(okc_p_util.raw_to_number(sys_guid()));
492: END get_seq_id;
493:
494: FUNCTION validate_attributes(p_eto_rec IN okl_eto_rec) RETURN VARCHAR2 IS
495: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
496: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
497:
498: BEGIN
499:

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

559: RETURN(x_return_status);
560: END validate_attributes;
561:
562: FUNCTION validate_record(p_eto_rec IN okl_eto_rec) RETURN VARCHAR2 IS
563: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
564: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
565:
566: BEGIN
567: RETURN(x_return_status);

Line 723: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

719: -- Procedure insert_row
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_eto_rec IN okl_eto_rec

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

745: END fill_who_columns;
746:
747: FUNCTION set_attributes(p_eto_rec IN okl_eto_rec
748: ,x_eto_rec OUT NOCOPY okl_eto_rec) RETURN VARCHAR2 IS
749: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
750:
751: BEGIN
752: x_eto_rec := p_eto_rec;
753: x_eto_rec.object_version_number := 1;

Line 758: l_return_status := okc_api.start_activity(l_api_name

754: RETURN(l_return_status);
755: END set_attributes;
756:
757: BEGIN
758: l_return_status := okc_api.start_activity(l_api_name
759: ,g_pkg_name
760: ,p_init_msg_list
761: ,l_api_version
762: ,p_api_version

Line 767: RAISE okc_api.g_exception_unexpected_error;

763: ,'_PVT'
764: ,x_return_status);
765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okc_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okc_api.g_exception_error;
770: END IF;
771: l_eto_rec := null_out_defaults(p_eto_rec);

Line 769: RAISE okc_api.g_exception_error;

765:
766: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
767: RAISE okc_api.g_exception_unexpected_error;
768: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
769: RAISE okc_api.g_exception_error;
770: END IF;
771: l_eto_rec := null_out_defaults(p_eto_rec);
772:
773: -- Set Primary key value

Line 783: RAISE okc_api.g_exception_unexpected_error;

779: l_return_status := set_attributes(l_eto_rec
780: ,l_def_eto_rec);
781:
782: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
783: RAISE okc_api.g_exception_unexpected_error;
784: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
785: RAISE okc_api.g_exception_error;
786: END IF;
787: l_def_eto_rec := fill_who_columns(l_def_eto_rec);

Line 785: RAISE okc_api.g_exception_error;

781:
782: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
783: RAISE okc_api.g_exception_unexpected_error;
784: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
785: RAISE okc_api.g_exception_error;
786: END IF;
787: l_def_eto_rec := fill_who_columns(l_def_eto_rec);
788: l_return_status := validate_attributes(l_def_eto_rec);
789:

Line 791: RAISE okc_api.g_exception_unexpected_error;

787: l_def_eto_rec := fill_who_columns(l_def_eto_rec);
788: l_return_status := validate_attributes(l_def_eto_rec);
789:
790: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
791: RAISE okc_api.g_exception_unexpected_error;
792: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
793: RAISE okc_api.g_exception_error;
794: END IF;
795: l_return_status := validate_record(l_def_eto_rec);

Line 793: RAISE okc_api.g_exception_error;

789:
790: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
791: RAISE okc_api.g_exception_unexpected_error;
792: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
793: RAISE okc_api.g_exception_error;
794: END IF;
795: l_return_status := validate_record(l_def_eto_rec);
796:
797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 798: RAISE okc_api.g_exception_unexpected_error;

794: END IF;
795: l_return_status := validate_record(l_def_eto_rec);
796:
797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
798: RAISE okc_api.g_exception_unexpected_error;
799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
800: RAISE okc_api.g_exception_error;
801: END IF;
802:

Line 800: RAISE okc_api.g_exception_error;

796:
797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
798: RAISE okc_api.g_exception_unexpected_error;
799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
800: RAISE okc_api.g_exception_error;
801: END IF;
802:
803: INSERT INTO okl_fe_eo_term_objects
804: (end_of_term_obj_id

Line 864: RAISE okc_api.g_exception_unexpected_error;

860: ,l_def_eto_rec.last_update_date
861: ,l_def_eto_rec.last_update_login);
862:
863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
864: RAISE okc_api.g_exception_unexpected_error;
865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okc_api.g_exception_error;
867: END IF;
868:

Line 866: RAISE okc_api.g_exception_error;

862:
863: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
864: RAISE okc_api.g_exception_unexpected_error;
865: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
866: RAISE okc_api.g_exception_error;
867: END IF;
868:
869: --Set OUT Values
870:

Line 872: okc_api.end_activity(x_msg_count

868:
869: --Set OUT Values
870:
871: x_eto_rec := l_def_eto_rec;
872: okc_api.end_activity(x_msg_count
873: ,x_msg_data);
874: EXCEPTION
875: WHEN g_exception_halt_validation THEN
876:

Line 880: WHEN okc_api.g_exception_error THEN

876:
877: -- No action necessary. Validation can continue to next attribute/column
878:
879: NULL;
880: WHEN okc_api.g_exception_error THEN
881: x_return_status := okl_api.handle_exceptions(l_api_name
882: ,g_pkg_name
883: ,'OKL_API.G_RET_STS_ERROR'
884: ,x_msg_count

Line 887: WHEN okc_api.g_exception_unexpected_error THEN

883: ,'OKL_API.G_RET_STS_ERROR'
884: ,x_msg_count
885: ,x_msg_data
886: ,'_PVT');
887: WHEN okc_api.g_exception_unexpected_error THEN
888: x_return_status := okl_api.handle_exceptions(l_api_name
889: ,g_pkg_name
890: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
891: ,x_msg_count

Line 908: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

904: -- Procedure insert_row_tbl
905: --------------------------------------------------------------------------------
906:
907: PROCEDURE insert_row(p_api_version IN NUMBER
908: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
909: ,x_return_status OUT NOCOPY VARCHAR2
910: ,x_msg_count OUT NOCOPY NUMBER
911: ,x_msg_data OUT NOCOPY VARCHAR2
912: ,p_eto_tbl IN okl_eto_tbl

Line 921: okc_api.init_msg_list(p_init_msg_list);

917: i NUMBER := 0;
918: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
919:
920: BEGIN
921: okc_api.init_msg_list(p_init_msg_list);
922:
923: -- Make sure PL/SQL table has records in it before passing
924:
925: IF (p_eto_tbl.COUNT > 0) THEN

Line 930: ,p_init_msg_list => okc_api.g_false

926: i := p_eto_tbl.FIRST;
927:
928: LOOP
929: insert_row(p_api_version => p_api_version
930: ,p_init_msg_list => okc_api.g_false
931: ,x_return_status => x_return_status
932: ,x_msg_count => x_msg_count
933: ,x_msg_data => x_msg_data
934: ,p_eto_rec => p_eto_tbl(i)

Line 936: IF x_return_status <> okc_api.g_ret_sts_success THEN

932: ,x_msg_count => x_msg_count
933: ,x_msg_data => x_msg_data
934: ,p_eto_rec => p_eto_tbl(i)
935: ,x_eto_rec => x_eto_tbl(i));
936: IF x_return_status <> okc_api.g_ret_sts_success THEN
937: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
938: l_overall_status := x_return_status;
939: END IF;
940: END IF;

Line 937: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

933: ,x_msg_data => x_msg_data
934: ,p_eto_rec => p_eto_tbl(i)
935: ,x_eto_rec => x_eto_tbl(i));
936: IF x_return_status <> okc_api.g_ret_sts_success THEN
937: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
938: l_overall_status := x_return_status;
939: END IF;
940: END IF;
941: EXIT WHEN(i = p_eto_tbl.LAST);

Line 953: WHEN okc_api.g_exception_error THEN

949:
950: -- No action necessary. Validation can continue to next attribute/column
951:
952: NULL;
953: WHEN okc_api.g_exception_error THEN
954: x_return_status := okl_api.handle_exceptions(l_api_name
955: ,g_pkg_name
956: ,'OKL_API.G_RET_STS_ERROR'
957: ,x_msg_count

Line 960: WHEN okc_api.g_exception_unexpected_error THEN

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

Line 981: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

977: -- Procedure update_row
978: --------------------------------------------------------------------------------
979:
980: PROCEDURE update_row(p_api_version IN NUMBER
981: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
982: ,x_return_status OUT NOCOPY VARCHAR2
983: ,x_msg_count OUT NOCOPY NUMBER
984: ,x_msg_data OUT NOCOPY VARCHAR2
985: ,p_eto_rec IN okl_eto_rec

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

1138: END populate_new_record;
1139:
1140: FUNCTION set_attributes(p_eto_rec IN okl_eto_rec
1141: ,x_eto_rec OUT NOCOPY okl_eto_rec) RETURN VARCHAR2 IS
1142: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
1143:
1144: BEGIN
1145: x_eto_rec := p_eto_rec;
1146: RETURN(l_return_status);

Line 1150: l_return_status := okc_api.start_activity(l_api_name

1146: RETURN(l_return_status);
1147: END set_attributes;
1148:
1149: BEGIN
1150: l_return_status := okc_api.start_activity(l_api_name
1151: ,g_pkg_name
1152: ,p_init_msg_list
1153: ,l_api_version
1154: ,p_api_version

Line 1159: RAISE okc_api.g_exception_unexpected_error;

1155: ,'_PVT'
1156: ,x_return_status);
1157:
1158: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1159: RAISE okc_api.g_exception_unexpected_error;
1160: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1161: RAISE okc_api.g_exception_error;
1162: END IF;
1163:

Line 1161: RAISE okc_api.g_exception_error;

1157:
1158: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1159: RAISE okc_api.g_exception_unexpected_error;
1160: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1161: RAISE okc_api.g_exception_error;
1162: END IF;
1163:
1164: --Setting Item Attributes
1165:

Line 1170: RAISE okc_api.g_exception_unexpected_error;

1166: l_return_status := set_attributes(l_eto_rec
1167: ,lx_eto_rec);
1168:
1169: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1170: RAISE okc_api.g_exception_unexpected_error;
1171: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1172: RAISE okc_api.g_exception_error;
1173: END IF;
1174: l_return_status := populate_new_record(lx_eto_rec

Line 1172: RAISE okc_api.g_exception_error;

1168:
1169: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1170: RAISE okc_api.g_exception_unexpected_error;
1171: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1172: RAISE okc_api.g_exception_error;
1173: END IF;
1174: l_return_status := populate_new_record(lx_eto_rec
1175: ,l_def_eto_rec);
1176:

Line 1178: RAISE okc_api.g_exception_unexpected_error;

1174: l_return_status := populate_new_record(lx_eto_rec
1175: ,l_def_eto_rec);
1176:
1177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1178: RAISE okc_api.g_exception_unexpected_error;
1179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1180: RAISE okc_api.g_exception_error;
1181: END IF;
1182: l_def_eto_rec := null_out_defaults(l_def_eto_rec);

Line 1180: RAISE okc_api.g_exception_error;

1176:
1177: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1178: RAISE okc_api.g_exception_unexpected_error;
1179: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1180: RAISE okc_api.g_exception_error;
1181: END IF;
1182: l_def_eto_rec := null_out_defaults(l_def_eto_rec);
1183:
1184: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 1193: RAISE okc_api.g_exception_unexpected_error;

1189: l_def_eto_rec := fill_who_columns(l_def_eto_rec);
1190: l_return_status := validate_attributes(l_def_eto_rec);
1191:
1192: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1193: RAISE okc_api.g_exception_unexpected_error;
1194: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1195: RAISE okc_api.g_exception_error;
1196: END IF;
1197: l_return_status := validate_record(l_def_eto_rec);

Line 1195: RAISE okc_api.g_exception_error;

1191:
1192: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1193: RAISE okc_api.g_exception_unexpected_error;
1194: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1195: RAISE okc_api.g_exception_error;
1196: END IF;
1197: l_return_status := validate_record(l_def_eto_rec);
1198:
1199: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

Line 1200: RAISE okc_api.g_exception_unexpected_error;

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

Line 1202: RAISE okc_api.g_exception_error;

1198:
1199: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1200: RAISE okc_api.g_exception_unexpected_error;
1201: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1202: RAISE okc_api.g_exception_error;
1203: END IF;
1204:
1205: -- Lock the row before updating
1206:

Line 1253: RAISE okc_api.g_exception_unexpected_error;

1249: ,last_update_login = l_def_eto_rec.last_update_login
1250: WHERE end_of_term_obj_id = l_def_eto_rec.end_of_term_obj_id;
1251:
1252: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1253: RAISE okc_api.g_exception_unexpected_error;
1254: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1255: RAISE okc_api.g_exception_error;
1256: END IF;
1257:

Line 1255: RAISE okc_api.g_exception_error;

1251:
1252: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1253: RAISE okc_api.g_exception_unexpected_error;
1254: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1255: RAISE okc_api.g_exception_error;
1256: END IF;
1257:
1258: --Set OUT Values
1259:

Line 1261: okc_api.end_activity(x_msg_count

1257:
1258: --Set OUT Values
1259:
1260: x_eto_rec := l_def_eto_rec;
1261: okc_api.end_activity(x_msg_count
1262: ,x_msg_data);
1263: EXCEPTION
1264: WHEN g_exception_halt_validation THEN
1265:

Line 1269: WHEN okc_api.g_exception_error THEN

1265:
1266: -- No action necessary. Validation can continue to next attribute/column
1267:
1268: NULL;
1269: WHEN okc_api.g_exception_error THEN
1270: x_return_status := okl_api.handle_exceptions(l_api_name
1271: ,g_pkg_name
1272: ,'OKL_API.G_RET_STS_ERROR'
1273: ,x_msg_count

Line 1276: WHEN okc_api.g_exception_unexpected_error THEN

1272: ,'OKL_API.G_RET_STS_ERROR'
1273: ,x_msg_count
1274: ,x_msg_data
1275: ,'_PVT');
1276: WHEN okc_api.g_exception_unexpected_error THEN
1277: x_return_status := okl_api.handle_exceptions(l_api_name
1278: ,g_pkg_name
1279: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1280: ,x_msg_count

Line 1297: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1293: -- Procedure insert_row_tbl
1294: --------------------------------------------------------------------------------
1295:
1296: PROCEDURE update_row(p_api_version IN NUMBER
1297: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1298: ,x_return_status OUT NOCOPY VARCHAR2
1299: ,x_msg_count OUT NOCOPY NUMBER
1300: ,x_msg_data OUT NOCOPY VARCHAR2
1301: ,p_eto_tbl IN okl_eto_tbl

Line 1310: okc_api.init_msg_list(p_init_msg_list);

1306: i NUMBER := 0;
1307: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1308:
1309: BEGIN
1310: okc_api.init_msg_list(p_init_msg_list);
1311:
1312: -- Make sure PL/SQL table has records in it before passing
1313:
1314: IF (p_eto_tbl.COUNT > 0) THEN

Line 1319: ,p_init_msg_list => okc_api.g_false

1315: i := p_eto_tbl.FIRST;
1316:
1317: LOOP
1318: update_row(p_api_version => p_api_version
1319: ,p_init_msg_list => okc_api.g_false
1320: ,x_return_status => x_return_status
1321: ,x_msg_count => x_msg_count
1322: ,x_msg_data => x_msg_data
1323: ,p_eto_rec => p_eto_tbl(i)

Line 1325: IF x_return_status <> okc_api.g_ret_sts_success THEN

1321: ,x_msg_count => x_msg_count
1322: ,x_msg_data => x_msg_data
1323: ,p_eto_rec => p_eto_tbl(i)
1324: ,x_eto_rec => x_eto_tbl(i));
1325: IF x_return_status <> okc_api.g_ret_sts_success THEN
1326: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1327: l_overall_status := x_return_status;
1328: END IF;
1329: END IF;

Line 1326: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1322: ,x_msg_data => x_msg_data
1323: ,p_eto_rec => p_eto_tbl(i)
1324: ,x_eto_rec => x_eto_tbl(i));
1325: IF x_return_status <> okc_api.g_ret_sts_success THEN
1326: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1327: l_overall_status := x_return_status;
1328: END IF;
1329: END IF;
1330: EXIT WHEN(i = p_eto_tbl.LAST);

Line 1342: WHEN okc_api.g_exception_error THEN

1338:
1339: -- No action necessary. Validation can continue to next attribute/column
1340:
1341: NULL;
1342: WHEN okc_api.g_exception_error THEN
1343: x_return_status := okl_api.handle_exceptions(l_api_name
1344: ,g_pkg_name
1345: ,'OKL_API.G_RET_STS_ERROR'
1346: ,x_msg_count

Line 1349: WHEN okc_api.g_exception_unexpected_error THEN

1345: ,'OKL_API.G_RET_STS_ERROR'
1346: ,x_msg_count
1347: ,x_msg_data
1348: ,'_PVT');
1349: WHEN okc_api.g_exception_unexpected_error THEN
1350: x_return_status := okl_api.handle_exceptions(l_api_name
1351: ,g_pkg_name
1352: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1353: ,x_msg_count

Line 1370: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1366: -- Procedure delete_row
1367: --------------------------------------------------------------------------------
1368:
1369: PROCEDURE delete_row(p_api_version IN NUMBER
1370: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1371: ,x_return_status OUT NOCOPY VARCHAR2
1372: ,x_msg_count OUT NOCOPY NUMBER
1373: ,x_msg_data OUT NOCOPY VARCHAR2
1374: ,p_eto_rec IN okl_eto_rec) IS

Line 1381: l_return_status := okc_api.start_activity(l_api_name

1377: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1378: l_eto_rec okl_eto_rec := p_eto_rec;
1379:
1380: BEGIN
1381: l_return_status := okc_api.start_activity(l_api_name
1382: ,g_pkg_name
1383: ,p_init_msg_list
1384: ,l_api_version
1385: ,p_api_version

Line 1390: RAISE okc_api.g_exception_unexpected_error;

1386: ,'_PVT'
1387: ,x_return_status);
1388:
1389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1390: RAISE okc_api.g_exception_unexpected_error;
1391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1392: RAISE okc_api.g_exception_error;
1393: END IF;
1394:

Line 1392: RAISE okc_api.g_exception_error;

1388:
1389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1390: RAISE okc_api.g_exception_unexpected_error;
1391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1392: RAISE okc_api.g_exception_error;
1393: END IF;
1394:
1395: DELETE FROM okl_fe_eo_term_objects
1396: WHERE end_of_term_obj_id = l_eto_rec.end_of_term_obj_id;

Line 1399: RAISE okc_api.g_exception_unexpected_error;

1395: DELETE FROM okl_fe_eo_term_objects
1396: WHERE end_of_term_obj_id = l_eto_rec.end_of_term_obj_id;
1397:
1398: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1399: RAISE okc_api.g_exception_unexpected_error;
1400: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1401: RAISE okc_api.g_exception_error;
1402: END IF;
1403: okc_api.end_activity(x_msg_count

Line 1401: RAISE okc_api.g_exception_error;

1397:
1398: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1399: RAISE okc_api.g_exception_unexpected_error;
1400: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1401: RAISE okc_api.g_exception_error;
1402: END IF;
1403: okc_api.end_activity(x_msg_count
1404: ,x_msg_data);
1405: EXCEPTION

Line 1403: okc_api.end_activity(x_msg_count

1399: RAISE okc_api.g_exception_unexpected_error;
1400: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1401: RAISE okc_api.g_exception_error;
1402: END IF;
1403: okc_api.end_activity(x_msg_count
1404: ,x_msg_data);
1405: EXCEPTION
1406: WHEN g_exception_halt_validation THEN
1407:

Line 1411: WHEN okc_api.g_exception_error THEN

1407:
1408: -- No action necessary. Validation can continue to next attribute/column
1409:
1410: NULL;
1411: WHEN okc_api.g_exception_error THEN
1412: x_return_status := okl_api.handle_exceptions(l_api_name
1413: ,g_pkg_name
1414: ,'OKL_API.G_RET_STS_ERROR'
1415: ,x_msg_count

Line 1418: WHEN okc_api.g_exception_unexpected_error THEN

1414: ,'OKL_API.G_RET_STS_ERROR'
1415: ,x_msg_count
1416: ,x_msg_data
1417: ,'_PVT');
1418: WHEN okc_api.g_exception_unexpected_error THEN
1419: x_return_status := okl_api.handle_exceptions(l_api_name
1420: ,g_pkg_name
1421: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1422: ,x_msg_count

Line 1439: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false

1435: -- Procedure delete_row_tbl
1436: --------------------------------------------------------------------------------
1437:
1438: PROCEDURE delete_row(p_api_version IN NUMBER
1439: ,p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false
1440: ,x_return_status OUT NOCOPY VARCHAR2
1441: ,x_msg_count OUT NOCOPY NUMBER
1442: ,x_msg_data OUT NOCOPY VARCHAR2
1443: ,p_eto_tbl IN okl_eto_tbl) IS

Line 1451: okc_api.init_msg_list(p_init_msg_list);

1447: i NUMBER := 0;
1448: l_overall_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1449:
1450: BEGIN
1451: okc_api.init_msg_list(p_init_msg_list);
1452:
1453: -- Make sure PL/SQL table has records in it before passing
1454:
1455: IF (p_eto_tbl.COUNT > 0) THEN

Line 1460: ,p_init_msg_list => okc_api.g_false

1456: i := p_eto_tbl.FIRST;
1457:
1458: LOOP
1459: delete_row(p_api_version => p_api_version
1460: ,p_init_msg_list => okc_api.g_false
1461: ,x_return_status => x_return_status
1462: ,x_msg_count => x_msg_count
1463: ,x_msg_data => x_msg_data
1464: ,p_eto_rec => p_eto_tbl(i));

Line 1465: IF x_return_status <> okc_api.g_ret_sts_success THEN

1461: ,x_return_status => x_return_status
1462: ,x_msg_count => x_msg_count
1463: ,x_msg_data => x_msg_data
1464: ,p_eto_rec => p_eto_tbl(i));
1465: IF x_return_status <> okc_api.g_ret_sts_success THEN
1466: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1467: l_overall_status := x_return_status;
1468: END IF;
1469: END IF;

Line 1466: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN

1462: ,x_msg_count => x_msg_count
1463: ,x_msg_data => x_msg_data
1464: ,p_eto_rec => p_eto_tbl(i));
1465: IF x_return_status <> okc_api.g_ret_sts_success THEN
1466: IF l_overall_status <> okc_api.g_ret_sts_unexp_error THEN
1467: l_overall_status := x_return_status;
1468: END IF;
1469: END IF;
1470: EXIT WHEN(i = p_eto_tbl.LAST);

Line 1482: WHEN okc_api.g_exception_error THEN

1478:
1479: -- No action necessary. Validation can continue to next attribute/column
1480:
1481: NULL;
1482: WHEN okc_api.g_exception_error THEN
1483: x_return_status := okl_api.handle_exceptions(l_api_name
1484: ,g_pkg_name
1485: ,'OKL_API.G_RET_STS_ERROR'
1486: ,x_msg_count

Line 1489: WHEN okc_api.g_exception_unexpected_error THEN

1485: ,'OKL_API.G_RET_STS_ERROR'
1486: ,x_msg_count
1487: ,x_msg_data
1488: ,'_PVT');
1489: WHEN okc_api.g_exception_unexpected_error THEN
1490: x_return_status := okl_api.handle_exceptions(l_api_name
1491: ,g_pkg_name
1492: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1493: ,x_msg_count