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

Line 265: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

261: EXCEPTION
262:
263: WHEN OTHERS THEN
264:
265: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
266: p_msg_name => G_DB_ERROR,
267: p_token1 => G_PROG_NAME_TOKEN,
268: p_token1_value => l_prog_name,
269: p_token2 => G_SQLCODE_TOKEN,

Line 285: OKL_API.set_message(p_app_name => G_APP_NAME,

281: ------------------------
282: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
283: BEGIN
284: IF p_id IS NULL THEN
285: OKL_API.set_message(p_app_name => G_APP_NAME,
286: p_msg_name => G_COL_ERROR,
287: p_token1 => G_COL_NAME_TOKEN,
288: p_token1_value => 'id',
289: p_token2 => G_PKG_NAME_TOKEN,

Line 291: RAISE OKL_API.G_EXCEPTION_ERROR;

287: p_token1 => G_COL_NAME_TOKEN,
288: p_token1_value => 'id',
289: p_token2 => G_PKG_NAME_TOKEN,
290: p_token2_value => G_PKG_NAME);
291: RAISE OKL_API.G_EXCEPTION_ERROR;
292: END IF;
293: x_return_status := G_RET_STS_SUCCESS;
294: END validate_id;
295:

Line 303: OKL_API.set_message(p_app_name => G_APP_NAME,

299: -------------------------------------------
300: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
301: BEGIN
302: IF p_object_version_number IS NULL THEN
303: OKL_API.set_message(p_app_name => G_APP_NAME,
304: p_msg_name => G_COL_ERROR,
305: p_token1 => G_COL_NAME_TOKEN,
306: p_token1_value => 'object_version_number',
307: p_token2 => G_PKG_NAME_TOKEN,

Line 309: RAISE OKL_API.G_EXCEPTION_ERROR;

305: p_token1 => G_COL_NAME_TOKEN,
306: p_token1_value => 'object_version_number',
307: p_token2 => G_PKG_NAME_TOKEN,
308: p_token2_value => G_PKG_NAME);
309: RAISE OKL_API.G_EXCEPTION_ERROR;
310: END IF;
311: x_return_status := G_RET_STS_SUCCESS;
312: END validate_object_version_number;
313:

Line 321: OKL_API.set_message(p_app_name => G_APP_NAME,

317: --------------------------------------
318: PROCEDURE validate_source_line_type (x_return_status OUT NOCOPY VARCHAR2, p_source_line_type IN VARCHAR2) IS
319: BEGIN
320: IF p_source_line_type IS NULL THEN
321: OKL_API.set_message(p_app_name => G_APP_NAME,
322: p_msg_name => G_COL_ERROR,
323: p_token1 => G_COL_NAME_TOKEN,
324: p_token1_value => 'source_line_type',
325: p_token2 => G_PKG_NAME_TOKEN,

Line 327: RAISE OKL_API.G_EXCEPTION_ERROR;

323: p_token1 => G_COL_NAME_TOKEN,
324: p_token1_value => 'source_line_type',
325: p_token2 => G_PKG_NAME_TOKEN,
326: p_token2_value => G_PKG_NAME);
327: RAISE OKL_API.G_EXCEPTION_ERROR;
328: END IF;
329: x_return_status := G_RET_STS_SUCCESS;
330: END validate_source_line_type;
331:

Line 339: OKL_API.set_message(p_app_name => G_APP_NAME,

335: --------------------------------------
336: PROCEDURE validate_source_line_id (x_return_status OUT NOCOPY VARCHAR2, p_source_line_id IN NUMBER) IS
337: BEGIN
338: IF p_source_line_id IS NULL THEN
339: OKL_API.set_message(p_app_name => G_APP_NAME,
340: p_msg_name => G_COL_ERROR,
341: p_token1 => G_COL_NAME_TOKEN,
342: p_token1_value => 'source_line_id',
343: p_token2 => G_PKG_NAME_TOKEN,

Line 345: RAISE OKL_API.G_EXCEPTION_ERROR;

341: p_token1 => G_COL_NAME_TOKEN,
342: p_token1_value => 'source_line_id',
343: p_token2 => G_PKG_NAME_TOKEN,
344: p_token2_value => G_PKG_NAME);
345: RAISE OKL_API.G_EXCEPTION_ERROR;
346: END IF;
347: x_return_status := G_RET_STS_SUCCESS;
348: END validate_source_line_id;
349:

Line 357: OKL_API.set_message(p_app_name => G_APP_NAME,

353: --------------------------------------
354: PROCEDURE validate_related_line_type (x_return_status OUT NOCOPY VARCHAR2, p_related_line_type IN VARCHAR2) IS
355: BEGIN
356: IF p_related_line_type IS NULL THEN
357: OKL_API.set_message(p_app_name => G_APP_NAME,
358: p_msg_name => G_COL_ERROR,
359: p_token1 => G_COL_NAME_TOKEN,
360: p_token1_value => 'related_line_type',
361: p_token2 => G_PKG_NAME_TOKEN,

Line 363: RAISE OKL_API.G_EXCEPTION_ERROR;

359: p_token1 => G_COL_NAME_TOKEN,
360: p_token1_value => 'related_line_type',
361: p_token2 => G_PKG_NAME_TOKEN,
362: p_token2_value => G_PKG_NAME);
363: RAISE OKL_API.G_EXCEPTION_ERROR;
364: END IF;
365: x_return_status := G_RET_STS_SUCCESS;
366: END validate_related_line_type;
367:

Line 375: OKL_API.set_message(p_app_name => G_APP_NAME,

371: --------------------------------------
372: PROCEDURE validate_related_line_id (x_return_status OUT NOCOPY VARCHAR2, p_related_line_id IN NUMBER) IS
373: BEGIN
374: IF p_related_line_id IS NULL THEN
375: OKL_API.set_message(p_app_name => G_APP_NAME,
376: p_msg_name => G_COL_ERROR,
377: p_token1 => G_COL_NAME_TOKEN,
378: p_token1_value => 'related_line_id',
379: p_token2 => G_PKG_NAME_TOKEN,

Line 381: RAISE OKL_API.G_EXCEPTION_ERROR;

377: p_token1 => G_COL_NAME_TOKEN,
378: p_token1_value => 'related_line_id',
379: p_token2 => G_PKG_NAME_TOKEN,
380: p_token2_value => G_PKG_NAME);
381: RAISE OKL_API.G_EXCEPTION_ERROR;
382: END IF;
383: x_return_status := G_RET_STS_SUCCESS;
384: END validate_related_line_id;
385:

Line 595: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

591: EXCEPTION
592:
593: WHEN OTHERS THEN
594:
595: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
596: p_msg_name => G_DB_ERROR,
597: p_token1 => G_PROG_NAME_TOKEN,
598: p_token1_value => l_prog_name,
599: p_token2 => G_SQLCODE_TOKEN,

Line 670: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

666: EXCEPTION
667:
668: WHEN OTHERS THEN
669:
670: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
671: p_msg_name => G_DB_ERROR,
672: p_token1 => G_PROG_NAME_TOKEN,
673: p_token1_value => l_prog_name,
674: p_token2 => G_SQLCODE_TOKEN,

Line 713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

709:
710: l_return_status := validate_attributes(l_lrev_rec);
711:
712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
715: RAISE OKL_API.G_EXCEPTION_ERROR;
716: END IF;
717:

Line 715: RAISE OKL_API.G_EXCEPTION_ERROR;

711:
712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
715: RAISE OKL_API.G_EXCEPTION_ERROR;
716: END IF;
717:
718: l_return_status := validate_record(l_lrev_rec);
719:

Line 721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

717:
718: l_return_status := validate_record(l_lrev_rec);
719:
720: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
722: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
723: RAISE OKL_API.G_EXCEPTION_ERROR;
724: END IF;
725:

Line 723: RAISE OKL_API.G_EXCEPTION_ERROR;

719:
720: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
722: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
723: RAISE OKL_API.G_EXCEPTION_ERROR;
724: END IF;
725:
726: migrate (l_lrev_rec, l_lre_rec);
727: migrate (l_lrev_rec, l_lretl_rec);

Line 732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

728:
729: insert_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);
730:
731: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736:

Line 734: RAISE OKL_API.G_EXCEPTION_ERROR;

730:
731: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736:
737: insert_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
738:

Line 740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

736:
737: insert_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
738:
739: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744:

Line 742: RAISE OKL_API.G_EXCEPTION_ERROR;

738:
739: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744:
745: x_lrev_rec := l_lrev_rec;
746: x_return_status := l_return_status;

Line 750: WHEN OKL_API.G_EXCEPTION_ERROR THEN

746: x_return_status := l_return_status;
747:
748: EXCEPTION
749:
750: WHEN OKL_API.G_EXCEPTION_ERROR THEN
751:
752: x_return_status := G_RET_STS_ERROR;
753:
754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

750: WHEN OKL_API.G_EXCEPTION_ERROR THEN
751:
752: x_return_status := G_RET_STS_ERROR;
753:
754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
755:
756: x_return_status := G_RET_STS_UNEXP_ERROR;
757:
758: WHEN OTHERS THEN

Line 760: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

756: x_return_status := G_RET_STS_UNEXP_ERROR;
757:
758: WHEN OTHERS THEN
759:
760: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
761: p_msg_name => G_DB_ERROR,
762: p_token1 => G_PROG_NAME_TOKEN,
763: p_token1_value => l_prog_name,
764: p_token2 => G_SQLCODE_TOKEN,

Line 803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

799: p_lrev_rec => p_lrev_rec,
800: x_lrev_rec => x_lrev_rec);
801:
802: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF l_return_status = G_RET_STS_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_ERROR;
806: END IF;
807:

Line 805: RAISE OKL_API.G_EXCEPTION_ERROR;

801:
802: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
803: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF l_return_status = G_RET_STS_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_ERROR;
806: END IF;
807:
808: x_return_status := l_return_status;
809:

Line 812: WHEN OKL_API.G_EXCEPTION_ERROR THEN

808: x_return_status := l_return_status;
809:
810: EXCEPTION
811:
812: WHEN OKL_API.G_EXCEPTION_ERROR THEN
813:
814: x_return_status := G_RET_STS_ERROR;
815:
816: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 816: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

812: WHEN OKL_API.G_EXCEPTION_ERROR THEN
813:
814: x_return_status := G_RET_STS_ERROR;
815:
816: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
817:
818: x_return_status := G_RET_STS_UNEXP_ERROR;
819:
820: WHEN OTHERS THEN

Line 822: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

818: x_return_status := G_RET_STS_UNEXP_ERROR;
819:
820: WHEN OTHERS THEN
821:
822: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
823: p_msg_name => G_DB_ERROR,
824: p_token1 => G_PROG_NAME_TOKEN,
825: p_token1_value => l_prog_name,
826: p_token2 => G_SQLCODE_TOKEN,

Line 871: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

867: p_lrev_rec => p_lrev_tbl(i),
868: x_lrev_rec => x_lrev_tbl(i));
869:
870: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
871: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF l_return_status = G_RET_STS_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_ERROR;
874: END IF;
875:

Line 873: RAISE OKL_API.G_EXCEPTION_ERROR;

869:
870: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
871: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
872: ELSIF l_return_status = G_RET_STS_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_ERROR;
874: END IF;
875:
876: EXIT WHEN (i = p_lrev_tbl.LAST);
877: i := p_lrev_tbl.NEXT(i);

Line 893: WHEN OKL_API.G_EXCEPTION_ERROR THEN

889: x_return_status := l_return_status;
890:
891: EXCEPTION
892:
893: WHEN OKL_API.G_EXCEPTION_ERROR THEN
894:
895: x_return_status := G_RET_STS_ERROR;
896:
897: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 897: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

893: WHEN OKL_API.G_EXCEPTION_ERROR THEN
894:
895: x_return_status := G_RET_STS_ERROR;
896:
897: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
898:
899: x_return_status := G_RET_STS_UNEXP_ERROR;
900:
901: WHEN OTHERS THEN

Line 903: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

899: x_return_status := G_RET_STS_UNEXP_ERROR;
900:
901: WHEN OTHERS THEN
902:
903: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
904: p_msg_name => G_DB_ERROR,
905: p_token1 => G_PROG_NAME_TOKEN,
906: p_token1_value => l_prog_name,
907: p_token2 => G_SQLCODE_TOKEN,

Line 957: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

953:
954: IF (lock_csr%ISOPEN) THEN
955: CLOSE lock_csr;
956: END IF;
957: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
958: p_msg_name => G_OVN_ERROR2,
959: p_token1 => G_PROG_NAME_TOKEN,
960: p_token1_value => l_prog_name);
961: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 961: RAISE OKL_API.G_EXCEPTION_ERROR;

957: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
958: p_msg_name => G_OVN_ERROR2,
959: p_token1 => G_PROG_NAME_TOKEN,
960: p_token1_value => l_prog_name);
961: RAISE OKL_API.G_EXCEPTION_ERROR;
962: END;
963:
964: IF l_object_version_number IS NULL THEN
965:

Line 972: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

968: CLOSE lchk_csr;
969:
970: IF lc_object_version_number IS NULL THEN
971:
972: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
973: p_msg_name => G_OVN_ERROR3,
974: p_token1 => G_PROG_NAME_TOKEN,
975: p_token1_value => l_prog_name);
976:

Line 979: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

975: p_token1_value => l_prog_name);
976:
977: ELSIF lc_object_version_number <> p_lre_rec.object_version_number THEN
978:
979: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
980: p_msg_name => G_OVN_ERROR,
981: p_token1 => G_PROG_NAME_TOKEN,
982: p_token1_value => l_prog_name);
983:

Line 986: RAISE OKL_API.G_EXCEPTION_ERROR;

982: p_token1_value => l_prog_name);
983:
984: END IF;
985:
986: RAISE OKL_API.G_EXCEPTION_ERROR;
987:
988: END IF;
989:
990: x_return_status := G_RET_STS_SUCCESS;

Line 994: WHEN OKL_API.G_EXCEPTION_ERROR THEN

990: x_return_status := G_RET_STS_SUCCESS;
991:
992: EXCEPTION
993:
994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995:
996: x_return_status := G_RET_STS_ERROR;
997:
998: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 998: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

994: WHEN OKL_API.G_EXCEPTION_ERROR THEN
995:
996: x_return_status := G_RET_STS_ERROR;
997:
998: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
999:
1000: x_return_status := G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN

Line 1004: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1000: x_return_status := G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN
1003:
1004: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1005: p_msg_name => G_DB_ERROR,
1006: p_token1 => G_PROG_NAME_TOKEN,
1007: p_token1_value => l_prog_name,
1008: p_token2 => G_SQLCODE_TOKEN,

Line 1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1030:
1031: lock_row (x_return_status => l_return_status, p_lre_rec => p_lre_rec);
1032:
1033: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF l_return_status = G_RET_STS_ERROR THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:

Line 1036: RAISE OKL_API.G_EXCEPTION_ERROR;

1032:
1033: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF l_return_status = G_RET_STS_ERROR THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: UPDATE okl_LINE_RELATIONSHIPS_b
1040: SET

Line 1073: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1069: x_return_status := l_return_status;
1070:
1071: EXCEPTION
1072:
1073: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1074: x_return_status := G_RET_STS_ERROR;
1075:
1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1072:
1073: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1074: x_return_status := G_RET_STS_ERROR;
1075:
1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := G_RET_STS_UNEXP_ERROR;
1078:
1079: WHEN OTHERS THEN
1080: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1080: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1076: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1077: x_return_status := G_RET_STS_UNEXP_ERROR;
1078:
1079: WHEN OTHERS THEN
1080: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1081: p_msg_name => G_DB_ERROR,
1082: p_token1 => G_PROG_NAME_TOKEN,
1083: p_token1_value => l_prog_name,
1084: p_token2 => G_SQLCODE_TOKEN,

Line 1128: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1124: EXCEPTION
1125:
1126: WHEN OTHERS THEN
1127:
1128: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1129: p_msg_name => G_DB_ERROR,
1130: p_token1 => G_PROG_NAME_TOKEN,
1131: p_token1_value => l_prog_name,
1132: p_token2 => G_SQLCODE_TOKEN,

Line 1175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1171: x_lrev_rec := p_lrev_rec;
1172: l_db_lrev_rec := get_rec (p_lrev_rec.id, l_return_status);
1173:
1174: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = G_RET_STS_ERROR THEN
1177: RAISE OKL_API.G_EXCEPTION_ERROR;
1178: END IF;
1179:

Line 1177: RAISE OKL_API.G_EXCEPTION_ERROR;

1173:
1174: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = G_RET_STS_ERROR THEN
1177: RAISE OKL_API.G_EXCEPTION_ERROR;
1178: END IF;
1179:
1180: IF x_lrev_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1181: x_lrev_rec.attribute_category := l_db_lrev_rec.attribute_category;

Line 1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1258: RETURN l_return_status;
1259:
1260: EXCEPTION
1261:
1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1263:
1264: x_return_status := G_RET_STS_ERROR;
1265:
1266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1263:
1264: x_return_status := G_RET_STS_ERROR;
1265:
1266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1267:
1268: x_return_status := G_RET_STS_UNEXP_ERROR;
1269:
1270: WHEN OTHERS THEN

Line 1272: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1268: x_return_status := G_RET_STS_UNEXP_ERROR;
1269:
1270: WHEN OTHERS THEN
1271:
1272: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1273: p_msg_name => G_DB_ERROR,
1274: p_token1 => G_PROG_NAME_TOKEN,
1275: p_token1_value => l_prog_name,
1276: p_token2 => G_SQLCODE_TOKEN,

Line 1292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1288:
1289: l_return_status := populate_new_record (p_lrev_rec, l_lrev_rec);
1290:
1291: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296:

Line 1294: RAISE OKL_API.G_EXCEPTION_ERROR;

1290:
1291: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1293: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1294: RAISE OKL_API.G_EXCEPTION_ERROR;
1295: END IF;
1296:
1297: l_return_status := validate_attributes (l_lrev_rec);
1298:

Line 1300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1296:
1297: l_return_status := validate_attributes (l_lrev_rec);
1298:
1299: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304:

Line 1302: RAISE OKL_API.G_EXCEPTION_ERROR;

1298:
1299: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1301: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1302: RAISE OKL_API.G_EXCEPTION_ERROR;
1303: END IF;
1304:
1305: l_return_status := validate_record (l_lrev_rec);
1306:

Line 1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1304:
1305: l_return_status := validate_record (l_lrev_rec);
1306:
1307: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312:

Line 1310: RAISE OKL_API.G_EXCEPTION_ERROR;

1306:
1307: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312:
1313: migrate (l_lrev_rec, l_lre_rec);
1314: migrate (l_lrev_rec, l_lretl_rec);

Line 1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1315:
1316: update_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);
1317:
1318: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1321: RAISE OKL_API.G_EXCEPTION_ERROR;
1322: END IF;
1323:

Line 1321: RAISE OKL_API.G_EXCEPTION_ERROR;

1317:
1318: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1321: RAISE OKL_API.G_EXCEPTION_ERROR;
1322: END IF;
1323:
1324: update_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
1325:

Line 1327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1323:
1324: update_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
1325:
1326: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1328: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: END IF;
1331:

Line 1329: RAISE OKL_API.G_EXCEPTION_ERROR;

1325:
1326: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1328: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330: END IF;
1331:
1332: x_return_status := l_return_status;
1333: x_lrev_rec := l_lrev_rec;

Line 1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1333: x_lrev_rec := l_lrev_rec;
1334:
1335: EXCEPTION
1336:
1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1338:
1339: x_return_status := G_RET_STS_ERROR;
1340:
1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1338:
1339: x_return_status := G_RET_STS_ERROR;
1340:
1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1342:
1343: x_return_status := G_RET_STS_UNEXP_ERROR;
1344:
1345: WHEN OTHERS THEN

Line 1347: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1343: x_return_status := G_RET_STS_UNEXP_ERROR;
1344:
1345: WHEN OTHERS THEN
1346:
1347: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1348: p_msg_name => G_DB_ERROR,
1349: p_token1 => G_PROG_NAME_TOKEN,
1350: p_token1_value => l_prog_name,
1351: p_token2 => G_SQLCODE_TOKEN,

Line 1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1386: p_lrev_rec => p_lrev_rec,
1387: x_lrev_rec => x_lrev_rec);
1388:
1389: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF l_return_status = G_RET_STS_ERROR THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394:

Line 1392: RAISE OKL_API.G_EXCEPTION_ERROR;

1388:
1389: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF l_return_status = G_RET_STS_ERROR THEN
1392: RAISE OKL_API.G_EXCEPTION_ERROR;
1393: END IF;
1394:
1395: x_return_status := l_return_status;
1396:

Line 1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1395: x_return_status := l_return_status;
1396:
1397: EXCEPTION
1398:
1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1400:
1401: x_return_status := G_RET_STS_ERROR;
1402:
1403: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1403: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1400:
1401: x_return_status := G_RET_STS_ERROR;
1402:
1403: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1404:
1405: x_return_status := G_RET_STS_UNEXP_ERROR;
1406:
1407: WHEN OTHERS THEN

Line 1409: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1405: x_return_status := G_RET_STS_UNEXP_ERROR;
1406:
1407: WHEN OTHERS THEN
1408:
1409: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1410: p_msg_name => G_DB_ERROR,
1411: p_token1 => G_PROG_NAME_TOKEN,
1412: p_token1_value => l_prog_name,
1413: p_token2 => G_SQLCODE_TOKEN,

Line 1461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1457: p_lrev_rec => p_lrev_tbl(i),
1458: x_lrev_rec => x_lrev_tbl(i));
1459:
1460: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = G_RET_STS_ERROR THEN
1463: RAISE OKL_API.G_EXCEPTION_ERROR;
1464: END IF;
1465:

Line 1463: RAISE OKL_API.G_EXCEPTION_ERROR;

1459:
1460: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = G_RET_STS_ERROR THEN
1463: RAISE OKL_API.G_EXCEPTION_ERROR;
1464: END IF;
1465:
1466: EXIT WHEN (i = p_lrev_tbl.LAST);
1467: i := p_lrev_tbl.NEXT(i);

Line 1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1479: x_return_status := l_return_status;
1480:
1481: EXCEPTION
1482:
1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1484:
1485: x_return_status := G_RET_STS_ERROR;
1486:
1487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1484:
1485: x_return_status := G_RET_STS_ERROR;
1486:
1487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1488:
1489: x_return_status := G_RET_STS_UNEXP_ERROR;
1490:
1491: WHEN OTHERS THEN

Line 1493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1489: x_return_status := G_RET_STS_UNEXP_ERROR;
1490:
1491: WHEN OTHERS THEN
1492:
1493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1494: p_msg_name => G_DB_ERROR,
1495: p_token1 => G_PROG_NAME_TOKEN,
1496: p_token1_value => l_prog_name,
1497: p_token2 => G_SQLCODE_TOKEN,

Line 1529: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1525: EXCEPTION
1526:
1527: WHEN OTHERS THEN
1528:
1529: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1530: p_msg_name => G_DB_ERROR,
1531: p_token1 => G_PROG_NAME_TOKEN,
1532: p_token1_value => l_prog_name,
1533: p_token2 => G_SQLCODE_TOKEN,

Line 1570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1566: delete_row (x_return_status => l_return_status,
1567: p_id => p_lrev_rec.id);
1568:
1569: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF l_return_status = G_RET_STS_ERROR THEN
1572: RAISE OKL_API.G_EXCEPTION_ERROR;
1573: END IF;
1574:

Line 1572: RAISE OKL_API.G_EXCEPTION_ERROR;

1568:
1569: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1570: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1571: ELSIF l_return_status = G_RET_STS_ERROR THEN
1572: RAISE OKL_API.G_EXCEPTION_ERROR;
1573: END IF;
1574:
1575: x_return_status := l_return_status;
1576:

Line 1579: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1575: x_return_status := l_return_status;
1576:
1577: EXCEPTION
1578:
1579: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1580:
1581: x_return_status := G_RET_STS_ERROR;
1582:
1583: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1583: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1579: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1580:
1581: x_return_status := G_RET_STS_ERROR;
1582:
1583: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1584:
1585: x_return_status := G_RET_STS_UNEXP_ERROR;
1586:
1587: WHEN OTHERS THEN

Line 1589: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1585: x_return_status := G_RET_STS_UNEXP_ERROR;
1586:
1587: WHEN OTHERS THEN
1588:
1589: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1590: p_msg_name => G_DB_ERROR,
1591: p_token1 => G_PROG_NAME_TOKEN,
1592: p_token1_value => l_prog_name,
1593: p_token2 => G_SQLCODE_TOKEN,

Line 1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1635: delete_row (x_return_status => l_return_status,
1636: p_id => p_lrev_tbl(i).id);
1637:
1638: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF l_return_status = G_RET_STS_ERROR THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;
1643:

Line 1641: RAISE OKL_API.G_EXCEPTION_ERROR;

1637:
1638: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1640: ELSIF l_return_status = G_RET_STS_ERROR THEN
1641: RAISE OKL_API.G_EXCEPTION_ERROR;
1642: END IF;
1643:
1644: EXIT WHEN (i = p_lrev_tbl.LAST);
1645: i := p_lrev_tbl.NEXT(i);

Line 1663: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1659: EXCEPTION
1660:
1661: WHEN OTHERS THEN
1662:
1663: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1664: p_msg_name => G_DB_ERROR,
1665: p_token1 => G_PROG_NAME_TOKEN,
1666: p_token1_value => l_prog_name,
1667: p_token2 => G_SQLCODE_TOKEN,