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

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

238: EXCEPTION
239:
240: WHEN OTHERS THEN
241:
242: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
243: p_msg_name => G_DB_ERROR,
244: p_token1 => G_PROG_NAME_TOKEN,
245: p_token1_value => l_prog_name,
246: p_token2 => G_SQLCODE_TOKEN,

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

258: ------------------------
259: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
260: BEGIN
261: IF p_id IS NULL THEN
262: OKL_API.set_message(p_app_name => G_APP_NAME,
263: p_msg_name => G_COL_ERROR,
264: p_token1 => G_COL_NAME_TOKEN,
265: p_token1_value => 'id',
266: p_token2 => G_PKG_NAME_TOKEN,

Line 268: RAISE OKL_API.G_EXCEPTION_ERROR;

264: p_token1 => G_COL_NAME_TOKEN,
265: p_token1_value => 'id',
266: p_token2 => G_PKG_NAME_TOKEN,
267: p_token2_value => G_PKG_NAME);
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;
270: x_return_status := G_RET_STS_SUCCESS;
271: END validate_id;
272:

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

276: -------------------------------------------
277: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
278: BEGIN
279: IF p_object_version_number IS NULL THEN
280: OKL_API.set_message(p_app_name => G_APP_NAME,
281: p_msg_name => G_COL_ERROR,
282: p_token1 => G_COL_NAME_TOKEN,
283: p_token1_value => 'object_version_number',
284: p_token2 => G_PKG_NAME_TOKEN,

Line 286: RAISE OKL_API.G_EXCEPTION_ERROR;

282: p_token1 => G_COL_NAME_TOKEN,
283: p_token1_value => 'object_version_number',
284: p_token2 => G_PKG_NAME_TOKEN,
285: p_token2_value => G_PKG_NAME);
286: RAISE OKL_API.G_EXCEPTION_ERROR;
287: END IF;
288: x_return_status := G_RET_STS_SUCCESS;
289: END validate_object_version_number;
290:

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

294: ------------------------
295: PROCEDURE validate_validation_set_id (x_return_status OUT NOCOPY VARCHAR2, p_validation_set_id IN NUMBER) IS
296: BEGIN
297: IF p_validation_set_id IS NULL THEN
298: OKL_API.set_message(p_app_name => G_APP_NAME,
299: p_msg_name => G_COL_ERROR,
300: p_token1 => G_COL_NAME_TOKEN,
301: p_token1_value => 'validation_set_id',
302: p_token2 => G_PKG_NAME_TOKEN,

Line 304: RAISE OKL_API.G_EXCEPTION_ERROR;

300: p_token1 => G_COL_NAME_TOKEN,
301: p_token1_value => 'validation_set_id',
302: p_token2 => G_PKG_NAME_TOKEN,
303: p_token2_value => G_PKG_NAME);
304: RAISE OKL_API.G_EXCEPTION_ERROR;
305: END IF;
306: x_return_status := G_RET_STS_SUCCESS;
307: END validate_validation_set_id;
308:

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

452: EXCEPTION
453:
454: WHEN OTHERS THEN
455:
456: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
457: p_msg_name => G_DB_ERROR,
458: p_token1 => G_PROG_NAME_TOKEN,
459: p_token1_value => l_prog_name,
460: p_token2 => G_SQLCODE_TOKEN,

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

527: EXCEPTION
528:
529: WHEN OTHERS THEN
530:
531: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
532: p_msg_name => G_DB_ERROR,
533: p_token1 => G_PROG_NAME_TOKEN,
534: p_token1_value => l_prog_name,
535: p_token2 => G_SQLCODE_TOKEN,

Line 574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

570:
571: l_return_status := validate_attributes(l_vldv_rec);
572:
573: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:

Line 576: RAISE OKL_API.G_EXCEPTION_ERROR;

572:
573: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: l_return_status := validate_record(l_vldv_rec);
580:

Line 582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

578:
579: l_return_status := validate_record(l_vldv_rec);
580:
581: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
583: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
584: RAISE OKL_API.G_EXCEPTION_ERROR;
585: END IF;
586:

Line 584: RAISE OKL_API.G_EXCEPTION_ERROR;

580:
581: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
582: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
583: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
584: RAISE OKL_API.G_EXCEPTION_ERROR;
585: END IF;
586:
587: migrate (l_vldv_rec, l_vld_rec);
588: migrate (l_vldv_rec, l_vldtl_rec);

Line 593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

589:
590: insert_row (x_return_status => l_return_status, p_vld_rec => l_vld_rec);
591:
592: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_ERROR;
596: END IF;
597:

Line 595: RAISE OKL_API.G_EXCEPTION_ERROR;

591:
592: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_ERROR;
596: END IF;
597:
598: insert_row (x_return_status => l_return_status, p_vldtl_rec => l_vldtl_rec);
599:

Line 601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

597:
598: insert_row (x_return_status => l_return_status, p_vldtl_rec => l_vldtl_rec);
599:
600: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
603: RAISE OKL_API.G_EXCEPTION_ERROR;
604: END IF;
605:

Line 603: RAISE OKL_API.G_EXCEPTION_ERROR;

599:
600: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
603: RAISE OKL_API.G_EXCEPTION_ERROR;
604: END IF;
605:
606: x_vldv_rec := l_vldv_rec;
607: x_return_status := l_return_status;

Line 611: WHEN OKL_API.G_EXCEPTION_ERROR THEN

607: x_return_status := l_return_status;
608:
609: EXCEPTION
610:
611: WHEN OKL_API.G_EXCEPTION_ERROR THEN
612:
613: x_return_status := G_RET_STS_ERROR;
614:
615: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 615: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

611: WHEN OKL_API.G_EXCEPTION_ERROR THEN
612:
613: x_return_status := G_RET_STS_ERROR;
614:
615: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
616:
617: x_return_status := G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN

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

617: x_return_status := G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN
620:
621: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
622: p_msg_name => G_DB_ERROR,
623: p_token1 => G_PROG_NAME_TOKEN,
624: p_token1_value => l_prog_name,
625: p_token2 => G_SQLCODE_TOKEN,

Line 664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

660: p_vldv_rec => p_vldv_rec,
661: x_vldv_rec => x_vldv_rec);
662:
663: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
665: ELSIF l_return_status = G_RET_STS_ERROR THEN
666: RAISE OKL_API.G_EXCEPTION_ERROR;
667: END IF;
668:

Line 666: RAISE OKL_API.G_EXCEPTION_ERROR;

662:
663: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
665: ELSIF l_return_status = G_RET_STS_ERROR THEN
666: RAISE OKL_API.G_EXCEPTION_ERROR;
667: END IF;
668:
669: x_return_status := l_return_status;
670:

Line 673: WHEN OKL_API.G_EXCEPTION_ERROR THEN

669: x_return_status := l_return_status;
670:
671: EXCEPTION
672:
673: WHEN OKL_API.G_EXCEPTION_ERROR THEN
674:
675: x_return_status := G_RET_STS_ERROR;
676:
677: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 677: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

673: WHEN OKL_API.G_EXCEPTION_ERROR THEN
674:
675: x_return_status := G_RET_STS_ERROR;
676:
677: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
678:
679: x_return_status := G_RET_STS_UNEXP_ERROR;
680:
681: WHEN OTHERS THEN

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

679: x_return_status := G_RET_STS_UNEXP_ERROR;
680:
681: WHEN OTHERS THEN
682:
683: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
684: p_msg_name => G_DB_ERROR,
685: p_token1 => G_PROG_NAME_TOKEN,
686: p_token1_value => l_prog_name,
687: p_token2 => G_SQLCODE_TOKEN,

Line 732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

728: p_vldv_rec => p_vldv_tbl(i),
729: x_vldv_rec => x_vldv_tbl(i));
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: EXIT WHEN (i = p_vldv_tbl.LAST);
738: i := p_vldv_tbl.NEXT(i);

Line 754: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 758: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

754: WHEN OKL_API.G_EXCEPTION_ERROR THEN
755:
756: x_return_status := G_RET_STS_ERROR;
757:
758: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
759:
760: x_return_status := G_RET_STS_UNEXP_ERROR;
761:
762: WHEN OTHERS THEN

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

760: x_return_status := G_RET_STS_UNEXP_ERROR;
761:
762: WHEN OTHERS THEN
763:
764: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
765: p_msg_name => G_DB_ERROR,
766: p_token1 => G_PROG_NAME_TOKEN,
767: p_token1_value => l_prog_name,
768: p_token2 => G_SQLCODE_TOKEN,

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

814:
815: IF (lock_csr%ISOPEN) THEN
816: CLOSE lock_csr;
817: END IF;
818: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
819: p_msg_name => G_OVN_ERROR2,
820: p_token1 => G_PROG_NAME_TOKEN,
821: p_token1_value => l_prog_name);
822: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 822: RAISE OKL_API.G_EXCEPTION_ERROR;

818: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
819: p_msg_name => G_OVN_ERROR2,
820: p_token1 => G_PROG_NAME_TOKEN,
821: p_token1_value => l_prog_name);
822: RAISE OKL_API.G_EXCEPTION_ERROR;
823: END;
824:
825: IF l_object_version_number IS NULL THEN
826:

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

829: CLOSE lchk_csr;
830:
831: IF lc_object_version_number IS NULL THEN
832:
833: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
834: p_msg_name => G_OVN_ERROR3,
835: p_token1 => G_PROG_NAME_TOKEN,
836: p_token1_value => l_prog_name);
837:

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

836: p_token1_value => l_prog_name);
837:
838: ELSIF lc_object_version_number <> p_vld_rec.object_version_number THEN
839:
840: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
841: p_msg_name => G_OVN_ERROR,
842: p_token1 => G_PROG_NAME_TOKEN,
843: p_token1_value => l_prog_name);
844:

Line 847: RAISE OKL_API.G_EXCEPTION_ERROR;

843: p_token1_value => l_prog_name);
844:
845: END IF;
846:
847: RAISE OKL_API.G_EXCEPTION_ERROR;
848:
849: END IF;
850:
851: x_return_status := G_RET_STS_SUCCESS;

Line 855: WHEN OKL_API.G_EXCEPTION_ERROR THEN

851: x_return_status := G_RET_STS_SUCCESS;
852:
853: EXCEPTION
854:
855: WHEN OKL_API.G_EXCEPTION_ERROR THEN
856:
857: x_return_status := G_RET_STS_ERROR;
858:
859: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 859: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

855: WHEN OKL_API.G_EXCEPTION_ERROR THEN
856:
857: x_return_status := G_RET_STS_ERROR;
858:
859: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
860:
861: x_return_status := G_RET_STS_UNEXP_ERROR;
862:
863: WHEN OTHERS THEN

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

861: x_return_status := G_RET_STS_UNEXP_ERROR;
862:
863: WHEN OTHERS THEN
864:
865: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
866: p_msg_name => G_DB_ERROR,
867: p_token1 => G_PROG_NAME_TOKEN,
868: p_token1_value => l_prog_name,
869: p_token2 => G_SQLCODE_TOKEN,

Line 895: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

891:
892: lock_row (x_return_status => l_return_status, p_vld_rec => p_vld_rec);
893:
894: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
895: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
896: ELSIF l_return_status = G_RET_STS_ERROR THEN
897: RAISE OKL_API.G_EXCEPTION_ERROR;
898: END IF;
899:

Line 897: RAISE OKL_API.G_EXCEPTION_ERROR;

893:
894: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
895: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
896: ELSIF l_return_status = G_RET_STS_ERROR THEN
897: RAISE OKL_API.G_EXCEPTION_ERROR;
898: END IF;
899:
900: UPDATE okl_validations_b
901: SET

Line 928: WHEN OKL_API.G_EXCEPTION_ERROR THEN

924: x_return_status := l_return_status;
925:
926: EXCEPTION
927:
928: WHEN OKL_API.G_EXCEPTION_ERROR THEN
929: x_return_status := G_RET_STS_ERROR;
930:
931: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
932: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 931: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

927:
928: WHEN OKL_API.G_EXCEPTION_ERROR THEN
929: x_return_status := G_RET_STS_ERROR;
930:
931: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
932: x_return_status := G_RET_STS_UNEXP_ERROR;
933:
934: WHEN OTHERS THEN
935: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

931: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
932: x_return_status := G_RET_STS_UNEXP_ERROR;
933:
934: WHEN OTHERS THEN
935: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
936: p_msg_name => G_DB_ERROR,
937: p_token1 => G_PROG_NAME_TOKEN,
938: p_token1_value => l_prog_name,
939: p_token2 => G_SQLCODE_TOKEN,

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

979: EXCEPTION
980:
981: WHEN OTHERS THEN
982:
983: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
984: p_msg_name => G_DB_ERROR,
985: p_token1 => G_PROG_NAME_TOKEN,
986: p_token1_value => l_prog_name,
987: p_token2 => G_SQLCODE_TOKEN,

Line 1028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1024: x_vldv_rec := p_vldv_rec;
1025: l_db_vldv_rec := get_rec (p_vldv_rec.id, l_return_status);
1026:
1027: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1029: ELSIF l_return_status = G_RET_STS_ERROR THEN
1030: RAISE OKL_API.G_EXCEPTION_ERROR;
1031: END IF;
1032:

Line 1030: RAISE OKL_API.G_EXCEPTION_ERROR;

1026:
1027: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1029: ELSIF l_return_status = G_RET_STS_ERROR THEN
1030: RAISE OKL_API.G_EXCEPTION_ERROR;
1031: END IF;
1032:
1033: IF x_vldv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1034: x_vldv_rec.attribute_category := l_db_vldv_rec.attribute_category;

Line 1104: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1100: RETURN l_return_status;
1101:
1102: EXCEPTION
1103:
1104: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1105:
1106: x_return_status := G_RET_STS_ERROR;
1107:
1108: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1108: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1104: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1105:
1106: x_return_status := G_RET_STS_ERROR;
1107:
1108: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1109:
1110: x_return_status := G_RET_STS_UNEXP_ERROR;
1111:
1112: WHEN OTHERS THEN

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

1110: x_return_status := G_RET_STS_UNEXP_ERROR;
1111:
1112: WHEN OTHERS THEN
1113:
1114: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1115: p_msg_name => G_DB_ERROR,
1116: p_token1 => G_PROG_NAME_TOKEN,
1117: p_token1_value => l_prog_name,
1118: p_token2 => G_SQLCODE_TOKEN,

Line 1134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1130:
1131: l_return_status := populate_new_record (p_vldv_rec, l_vldv_rec);
1132:
1133: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138:

Line 1136: RAISE OKL_API.G_EXCEPTION_ERROR;

1132:
1133: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1135: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_ERROR;
1137: END IF;
1138:
1139: l_return_status := validate_attributes (l_vldv_rec);
1140:

Line 1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1138:
1139: l_return_status := validate_attributes (l_vldv_rec);
1140:
1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:

Line 1144: RAISE OKL_API.G_EXCEPTION_ERROR;

1140:
1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1143: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: l_return_status := validate_record (l_vldv_rec);
1148:

Line 1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1146:
1147: l_return_status := validate_record (l_vldv_rec);
1148:
1149: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;
1154:

Line 1152: RAISE OKL_API.G_EXCEPTION_ERROR;

1148:
1149: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;
1154:
1155: migrate (l_vldv_rec, l_vld_rec);
1156: migrate (l_vldv_rec, l_vldtl_rec);

Line 1161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1157:
1158: update_row (x_return_status => l_return_status, p_vld_rec => l_vld_rec);
1159:
1160: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1163: RAISE OKL_API.G_EXCEPTION_ERROR;
1164: END IF;
1165:

Line 1163: RAISE OKL_API.G_EXCEPTION_ERROR;

1159:
1160: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1163: RAISE OKL_API.G_EXCEPTION_ERROR;
1164: END IF;
1165:
1166: update_row (x_return_status => l_return_status, p_vldtl_rec => l_vldtl_rec);
1167:

Line 1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1165:
1166: update_row (x_return_status => l_return_status, p_vldtl_rec => l_vldtl_rec);
1167:
1168: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;
1173:

Line 1171: RAISE OKL_API.G_EXCEPTION_ERROR;

1167:
1168: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1170: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_ERROR;
1172: END IF;
1173:
1174: x_return_status := l_return_status;
1175: x_vldv_rec := l_vldv_rec;

Line 1179: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1175: x_vldv_rec := l_vldv_rec;
1176:
1177: EXCEPTION
1178:
1179: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1180:
1181: x_return_status := G_RET_STS_ERROR;
1182:
1183: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1183: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1179: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1180:
1181: x_return_status := G_RET_STS_ERROR;
1182:
1183: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1184:
1185: x_return_status := G_RET_STS_UNEXP_ERROR;
1186:
1187: WHEN OTHERS THEN

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

1185: x_return_status := G_RET_STS_UNEXP_ERROR;
1186:
1187: WHEN OTHERS THEN
1188:
1189: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1190: p_msg_name => G_DB_ERROR,
1191: p_token1 => G_PROG_NAME_TOKEN,
1192: p_token1_value => l_prog_name,
1193: p_token2 => G_SQLCODE_TOKEN,

Line 1232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1228: p_vldv_rec => p_vldv_rec,
1229: x_vldv_rec => x_vldv_rec);
1230:
1231: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF l_return_status = G_RET_STS_ERROR THEN
1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236:

Line 1234: RAISE OKL_API.G_EXCEPTION_ERROR;

1230:
1231: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1233: ELSIF l_return_status = G_RET_STS_ERROR THEN
1234: RAISE OKL_API.G_EXCEPTION_ERROR;
1235: END IF;
1236:
1237: x_return_status := l_return_status;
1238:

Line 1241: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1237: x_return_status := l_return_status;
1238:
1239: EXCEPTION
1240:
1241: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1242:
1243: x_return_status := G_RET_STS_ERROR;
1244:
1245: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1245: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1241: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1242:
1243: x_return_status := G_RET_STS_ERROR;
1244:
1245: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1246:
1247: x_return_status := G_RET_STS_UNEXP_ERROR;
1248:
1249: WHEN OTHERS THEN

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

1247: x_return_status := G_RET_STS_UNEXP_ERROR;
1248:
1249: WHEN OTHERS THEN
1250:
1251: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1252: p_msg_name => G_DB_ERROR,
1253: p_token1 => G_PROG_NAME_TOKEN,
1254: p_token1_value => l_prog_name,
1255: p_token2 => G_SQLCODE_TOKEN,

Line 1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1299: p_vldv_rec => p_vldv_tbl(i),
1300: x_vldv_rec => x_vldv_tbl(i));
1301:
1302: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:

Line 1305: RAISE OKL_API.G_EXCEPTION_ERROR;

1301:
1302: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF l_return_status = G_RET_STS_ERROR THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: EXIT WHEN (i = p_vldv_tbl.LAST);
1309: i := p_vldv_tbl.NEXT(i);

Line 1325: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1321: x_return_status := l_return_status;
1322:
1323: EXCEPTION
1324:
1325: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1326:
1327: x_return_status := G_RET_STS_ERROR;
1328:
1329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1325: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1326:
1327: x_return_status := G_RET_STS_ERROR;
1328:
1329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1330:
1331: x_return_status := G_RET_STS_UNEXP_ERROR;
1332:
1333: WHEN OTHERS THEN

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

1331: x_return_status := G_RET_STS_UNEXP_ERROR;
1332:
1333: WHEN OTHERS THEN
1334:
1335: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1336: p_msg_name => G_DB_ERROR,
1337: p_token1 => G_PROG_NAME_TOKEN,
1338: p_token1_value => l_prog_name,
1339: p_token2 => G_SQLCODE_TOKEN,

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

1367: EXCEPTION
1368:
1369: WHEN OTHERS THEN
1370:
1371: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1372: p_msg_name => G_DB_ERROR,
1373: p_token1 => G_PROG_NAME_TOKEN,
1374: p_token1_value => l_prog_name,
1375: p_token2 => G_SQLCODE_TOKEN,

Line 1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1408: delete_row (x_return_status => l_return_status,
1409: p_id => p_vldv_rec.id);
1410:
1411: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF l_return_status = G_RET_STS_ERROR THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:

Line 1414: RAISE OKL_API.G_EXCEPTION_ERROR;

1410:
1411: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1413: ELSIF l_return_status = G_RET_STS_ERROR THEN
1414: RAISE OKL_API.G_EXCEPTION_ERROR;
1415: END IF;
1416:
1417: x_return_status := l_return_status;
1418:

Line 1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1417: x_return_status := l_return_status;
1418:
1419: EXCEPTION
1420:
1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422:
1423: x_return_status := G_RET_STS_ERROR;
1424:
1425: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1425: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1421: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1422:
1423: x_return_status := G_RET_STS_ERROR;
1424:
1425: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1426:
1427: x_return_status := G_RET_STS_UNEXP_ERROR;
1428:
1429: WHEN OTHERS THEN

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

1427: x_return_status := G_RET_STS_UNEXP_ERROR;
1428:
1429: WHEN OTHERS THEN
1430:
1431: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1432: p_msg_name => G_DB_ERROR,
1433: p_token1 => G_PROG_NAME_TOKEN,
1434: p_token1_value => l_prog_name,
1435: p_token2 => G_SQLCODE_TOKEN,

Line 1481: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1477: delete_row (x_return_status => l_return_status,
1478: p_id => p_vldv_tbl(i).id);
1479:
1480: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1481: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = G_RET_STS_ERROR THEN
1483: RAISE OKL_API.G_EXCEPTION_ERROR;
1484: END IF;
1485:

Line 1483: RAISE OKL_API.G_EXCEPTION_ERROR;

1479:
1480: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1481: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = G_RET_STS_ERROR THEN
1483: RAISE OKL_API.G_EXCEPTION_ERROR;
1484: END IF;
1485:
1486: EXIT WHEN (i = p_vldv_tbl.LAST);
1487: i := p_vldv_tbl.NEXT(i);

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

1501: EXCEPTION
1502:
1503: WHEN OTHERS THEN
1504:
1505: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1506: p_msg_name => G_DB_ERROR,
1507: p_token1 => G_PROG_NAME_TOKEN,
1508: p_token1_value => l_prog_name,
1509: p_token2 => G_SQLCODE_TOKEN,