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

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

221: EXCEPTION
222:
223: WHEN OTHERS THEN
224:
225: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
226: p_msg_name => G_DB_ERROR,
227: p_token1 => G_PROG_NAME_TOKEN,
228: p_token1_value => l_prog_name,
229: p_token2 => G_SQLCODE_TOKEN,

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

241: ------------------------
242: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
243: BEGIN
244: IF p_id IS NULL THEN
245: OKL_API.set_message(p_app_name => G_APP_NAME,
246: p_msg_name => G_COL_ERROR,
247: p_token1 => G_COL_NAME_TOKEN,
248: p_token1_value => 'id',
249: p_token2 => G_PKG_NAME_TOKEN,

Line 251: RAISE OKL_API.G_EXCEPTION_ERROR;

247: p_token1 => G_COL_NAME_TOKEN,
248: p_token1_value => 'id',
249: p_token2 => G_PKG_NAME_TOKEN,
250: p_token2_value => G_PKG_NAME);
251: RAISE OKL_API.G_EXCEPTION_ERROR;
252: END IF;
253: x_return_status := G_RET_STS_SUCCESS;
254: END validate_id;
255:

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

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

Line 269: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 287: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 305: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

313: -------------------------------------------
314: PROCEDURE validate_validation_id (x_return_status OUT NOCOPY VARCHAR2, p_validation_id IN NUMBER) IS
315: BEGIN
316: IF p_validation_id IS NULL THEN
317: OKL_API.set_message(p_app_name => G_APP_NAME,
318: p_msg_name => G_COL_ERROR,
319: p_token1 => G_COL_NAME_TOKEN,
320: p_token1_value => 'validation_id',
321: p_token2 => G_PKG_NAME_TOKEN,

Line 323: RAISE OKL_API.G_EXCEPTION_ERROR;

319: p_token1 => G_COL_NAME_TOKEN,
320: p_token1_value => 'validation_id',
321: p_token2 => G_PKG_NAME_TOKEN,
322: p_token2_value => G_PKG_NAME);
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325: x_return_status := G_RET_STS_SUCCESS;
326: END validate_validation_id;
327:

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

331: -------------------------------------------
332: PROCEDURE validate_result_code (x_return_status OUT NOCOPY VARCHAR2, p_result_code IN VARCHAR2) IS
333: BEGIN
334: IF p_result_code IS NULL THEN
335: OKL_API.set_message(p_app_name => G_APP_NAME,
336: p_msg_name => G_COL_ERROR,
337: p_token1 => G_COL_NAME_TOKEN,
338: p_token1_value => 'result_code',
339: p_token2 => G_PKG_NAME_TOKEN,

Line 341: RAISE OKL_API.G_EXCEPTION_ERROR;

337: p_token1 => G_COL_NAME_TOKEN,
338: p_token1_value => 'result_code',
339: p_token2 => G_PKG_NAME_TOKEN,
340: p_token2_value => G_PKG_NAME);
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343: x_return_status := G_RET_STS_SUCCESS;
344: END validate_result_code;
345:

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

493: EXCEPTION
494:
495: WHEN OTHERS THEN
496:
497: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
498: p_msg_name => G_DB_ERROR,
499: p_token1 => G_PROG_NAME_TOKEN,
500: p_token1_value => l_prog_name,
501: p_token2 => G_SQLCODE_TOKEN,

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

564: EXCEPTION
565:
566: WHEN OTHERS THEN
567:
568: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
569: p_msg_name => G_DB_ERROR,
570: p_token1 => G_PROG_NAME_TOKEN,
571: p_token1_value => l_prog_name,
572: p_token2 => G_SQLCODE_TOKEN,

Line 611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

607:
608: l_return_status := validate_attributes(l_vlrv_rec);
609:
610: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615:

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609:
610: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615:
616: l_return_status := validate_record(l_vlrv_rec);
617:

Line 619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

615:
616: l_return_status := validate_record(l_vlrv_rec);
617:
618: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_ERROR;
622: END IF;
623:

Line 621: RAISE OKL_API.G_EXCEPTION_ERROR;

617:
618: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
621: RAISE OKL_API.G_EXCEPTION_ERROR;
622: END IF;
623:
624: migrate (l_vlrv_rec, l_vlr_rec);
625: migrate (l_vlrv_rec, l_vlrtl_rec);

Line 630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

626:
627: insert_row (x_return_status => l_return_status, p_vlr_rec => l_vlr_rec);
628:
629: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:

Line 632: RAISE OKL_API.G_EXCEPTION_ERROR;

628:
629: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: insert_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
636:

Line 638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

634:
635: insert_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
636:
637: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642:

Line 640: RAISE OKL_API.G_EXCEPTION_ERROR;

636:
637: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642:
643: x_vlrv_rec := l_vlrv_rec;
644: x_return_status := l_return_status;

Line 648: WHEN OKL_API.G_EXCEPTION_ERROR THEN

644: x_return_status := l_return_status;
645:
646: EXCEPTION
647:
648: WHEN OKL_API.G_EXCEPTION_ERROR THEN
649:
650: x_return_status := G_RET_STS_ERROR;
651:
652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

648: WHEN OKL_API.G_EXCEPTION_ERROR THEN
649:
650: x_return_status := G_RET_STS_ERROR;
651:
652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
653:
654: x_return_status := G_RET_STS_UNEXP_ERROR;
655:
656: WHEN OTHERS THEN

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

654: x_return_status := G_RET_STS_UNEXP_ERROR;
655:
656: WHEN OTHERS THEN
657:
658: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
659: p_msg_name => G_DB_ERROR,
660: p_token1 => G_PROG_NAME_TOKEN,
661: p_token1_value => l_prog_name,
662: p_token2 => G_SQLCODE_TOKEN,

Line 701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

697: p_vlrv_rec => p_vlrv_rec,
698: x_vlrv_rec => x_vlrv_rec);
699:
700: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF l_return_status = G_RET_STS_ERROR THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705:

Line 703: RAISE OKL_API.G_EXCEPTION_ERROR;

699:
700: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
701: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
702: ELSIF l_return_status = G_RET_STS_ERROR THEN
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705:
706: x_return_status := l_return_status;
707:

Line 710: WHEN OKL_API.G_EXCEPTION_ERROR THEN

706: x_return_status := l_return_status;
707:
708: EXCEPTION
709:
710: WHEN OKL_API.G_EXCEPTION_ERROR THEN
711:
712: x_return_status := G_RET_STS_ERROR;
713:
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

710: WHEN OKL_API.G_EXCEPTION_ERROR THEN
711:
712: x_return_status := G_RET_STS_ERROR;
713:
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
715:
716: x_return_status := G_RET_STS_UNEXP_ERROR;
717:
718: WHEN OTHERS THEN

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

716: x_return_status := G_RET_STS_UNEXP_ERROR;
717:
718: WHEN OTHERS THEN
719:
720: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
721: p_msg_name => G_DB_ERROR,
722: p_token1 => G_PROG_NAME_TOKEN,
723: p_token1_value => l_prog_name,
724: p_token2 => G_SQLCODE_TOKEN,

Line 769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

765: p_vlrv_rec => p_vlrv_tbl(i),
766: x_vlrv_rec => x_vlrv_tbl(i));
767:
768: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF l_return_status = G_RET_STS_ERROR THEN
771: RAISE OKL_API.G_EXCEPTION_ERROR;
772: END IF;
773:

Line 771: RAISE OKL_API.G_EXCEPTION_ERROR;

767:
768: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
770: ELSIF l_return_status = G_RET_STS_ERROR THEN
771: RAISE OKL_API.G_EXCEPTION_ERROR;
772: END IF;
773:
774: EXIT WHEN (i = p_vlrv_tbl.LAST);
775: i := p_vlrv_tbl.NEXT(i);

Line 791: WHEN OKL_API.G_EXCEPTION_ERROR THEN

787: x_return_status := l_return_status;
788:
789: EXCEPTION
790:
791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
792:
793: x_return_status := G_RET_STS_ERROR;
794:
795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
792:
793: x_return_status := G_RET_STS_ERROR;
794:
795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
796:
797: x_return_status := G_RET_STS_UNEXP_ERROR;
798:
799: WHEN OTHERS THEN

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

797: x_return_status := G_RET_STS_UNEXP_ERROR;
798:
799: WHEN OTHERS THEN
800:
801: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
802: p_msg_name => G_DB_ERROR,
803: p_token1 => G_PROG_NAME_TOKEN,
804: p_token1_value => l_prog_name,
805: p_token2 => G_SQLCODE_TOKEN,

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

851:
852: IF (lock_csr%ISOPEN) THEN
853: CLOSE lock_csr;
854: END IF;
855: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
856: p_msg_name => G_OVN_ERROR2,
857: p_token1 => G_PROG_NAME_TOKEN,
858: p_token1_value => l_prog_name);
859: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 859: RAISE OKL_API.G_EXCEPTION_ERROR;

855: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
856: p_msg_name => G_OVN_ERROR2,
857: p_token1 => G_PROG_NAME_TOKEN,
858: p_token1_value => l_prog_name);
859: RAISE OKL_API.G_EXCEPTION_ERROR;
860: END;
861:
862: IF l_object_version_number IS NULL THEN
863:

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

866: CLOSE lchk_csr;
867:
868: IF lc_object_version_number IS NULL THEN
869:
870: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
871: p_msg_name => G_OVN_ERROR3,
872: p_token1 => G_PROG_NAME_TOKEN,
873: p_token1_value => l_prog_name);
874:

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

873: p_token1_value => l_prog_name);
874:
875: ELSIF lc_object_version_number <> p_vlr_rec.object_version_number THEN
876:
877: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
878: p_msg_name => G_OVN_ERROR,
879: p_token1 => G_PROG_NAME_TOKEN,
880: p_token1_value => l_prog_name);
881:

Line 884: RAISE OKL_API.G_EXCEPTION_ERROR;

880: p_token1_value => l_prog_name);
881:
882: END IF;
883:
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885:
886: END IF;
887:
888: x_return_status := G_RET_STS_SUCCESS;

Line 892: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 896: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 932: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

928:
929: lock_row (x_return_status => l_return_status, p_vlr_rec => p_vlr_rec);
930:
931: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
932: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
933: ELSIF l_return_status = G_RET_STS_ERROR THEN
934: RAISE OKL_API.G_EXCEPTION_ERROR;
935: END IF;
936:

Line 934: RAISE OKL_API.G_EXCEPTION_ERROR;

930:
931: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
932: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
933: ELSIF l_return_status = G_RET_STS_ERROR THEN
934: RAISE OKL_API.G_EXCEPTION_ERROR;
935: END IF;
936:
937: UPDATE okl_validation_results_b
938: SET

Line 966: WHEN OKL_API.G_EXCEPTION_ERROR THEN

962: x_return_status := l_return_status;
963:
964: EXCEPTION
965:
966: WHEN OKL_API.G_EXCEPTION_ERROR THEN
967: x_return_status := G_RET_STS_ERROR;
968:
969: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
970: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 969: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

965:
966: WHEN OKL_API.G_EXCEPTION_ERROR THEN
967: x_return_status := G_RET_STS_ERROR;
968:
969: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
970: x_return_status := G_RET_STS_UNEXP_ERROR;
971:
972: WHEN OTHERS THEN
973: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

969: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
970: x_return_status := G_RET_STS_UNEXP_ERROR;
971:
972: WHEN OTHERS THEN
973: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
974: p_msg_name => G_DB_ERROR,
975: p_token1 => G_PROG_NAME_TOKEN,
976: p_token1_value => l_prog_name,
977: p_token2 => G_SQLCODE_TOKEN,

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

1015: EXCEPTION
1016:
1017: WHEN OTHERS THEN
1018:
1019: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1020: p_msg_name => G_DB_ERROR,
1021: p_token1 => G_PROG_NAME_TOKEN,
1022: p_token1_value => l_prog_name,
1023: p_token2 => G_SQLCODE_TOKEN,

Line 1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1060: x_vlrv_rec := p_vlrv_rec;
1061: l_db_vlrv_rec := get_rec (p_vlrv_rec.id, l_return_status);
1062:
1063: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF l_return_status = G_RET_STS_ERROR THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:

Line 1066: RAISE OKL_API.G_EXCEPTION_ERROR;

1062:
1063: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1064: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1065: ELSIF l_return_status = G_RET_STS_ERROR THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:
1069: IF x_vlrv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1070: x_vlrv_rec.attribute_category := l_db_vlrv_rec.attribute_category;

Line 1137: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1133: RETURN l_return_status;
1134:
1135: EXCEPTION
1136:
1137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1138:
1139: x_return_status := G_RET_STS_ERROR;
1140:
1141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1138:
1139: x_return_status := G_RET_STS_ERROR;
1140:
1141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142:
1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144:
1145: WHEN OTHERS THEN

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

1143: x_return_status := G_RET_STS_UNEXP_ERROR;
1144:
1145: WHEN OTHERS THEN
1146:
1147: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1148: p_msg_name => G_DB_ERROR,
1149: p_token1 => G_PROG_NAME_TOKEN,
1150: p_token1_value => l_prog_name,
1151: p_token2 => G_SQLCODE_TOKEN,

Line 1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1163:
1164: l_return_status := populate_new_record (p_vlrv_rec, l_vlrv_rec);
1165:
1166: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171:

Line 1169: RAISE OKL_API.G_EXCEPTION_ERROR;

1165:
1166: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171:
1172: l_return_status := validate_attributes (l_vlrv_rec);
1173:

Line 1175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1171:
1172: l_return_status := validate_attributes (l_vlrv_rec);
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: l_return_status := validate_record (l_vlrv_rec);
1181:

Line 1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1179:
1180: l_return_status := validate_record (l_vlrv_rec);
1181:
1182: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;
1187:

Line 1185: RAISE OKL_API.G_EXCEPTION_ERROR;

1181:
1182: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;
1187:
1188: migrate (l_vlrv_rec, l_vlr_rec);
1189: migrate (l_vlrv_rec, l_vlrtl_rec);

Line 1194: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1190:
1191: update_row (x_return_status => l_return_status, p_vlr_rec => l_vlr_rec);
1192:
1193: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1196: RAISE OKL_API.G_EXCEPTION_ERROR;
1197: END IF;
1198:

Line 1196: RAISE OKL_API.G_EXCEPTION_ERROR;

1192:
1193: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1196: RAISE OKL_API.G_EXCEPTION_ERROR;
1197: END IF;
1198:
1199: update_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
1200:

Line 1202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1198:
1199: update_row (x_return_status => l_return_status, p_vlrtl_rec => l_vlrtl_rec);
1200:
1201: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1204: RAISE OKL_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:

Line 1204: RAISE OKL_API.G_EXCEPTION_ERROR;

1200:
1201: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1202: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1203: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1204: RAISE OKL_API.G_EXCEPTION_ERROR;
1205: END IF;
1206:
1207: x_return_status := l_return_status;
1208: x_vlrv_rec := l_vlrv_rec;

Line 1212: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1208: x_vlrv_rec := l_vlrv_rec;
1209:
1210: EXCEPTION
1211:
1212: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1213:
1214: x_return_status := G_RET_STS_ERROR;
1215:
1216: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1216: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1212: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1213:
1214: x_return_status := G_RET_STS_ERROR;
1215:
1216: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1217:
1218: x_return_status := G_RET_STS_UNEXP_ERROR;
1219:
1220: WHEN OTHERS THEN

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

1218: x_return_status := G_RET_STS_UNEXP_ERROR;
1219:
1220: WHEN OTHERS THEN
1221:
1222: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1223: p_msg_name => G_DB_ERROR,
1224: p_token1 => G_PROG_NAME_TOKEN,
1225: p_token1_value => l_prog_name,
1226: p_token2 => G_SQLCODE_TOKEN,

Line 1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1261: p_vlrv_rec => p_vlrv_rec,
1262: x_vlrv_rec => x_vlrv_rec);
1263:
1264: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = G_RET_STS_ERROR THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:

Line 1267: RAISE OKL_API.G_EXCEPTION_ERROR;

1263:
1264: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = G_RET_STS_ERROR THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: x_return_status := l_return_status;
1271:

Line 1274: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1270: x_return_status := l_return_status;
1271:
1272: EXCEPTION
1273:
1274: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1275:
1276: x_return_status := G_RET_STS_ERROR;
1277:
1278: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1278: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1274: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1275:
1276: x_return_status := G_RET_STS_ERROR;
1277:
1278: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1279:
1280: x_return_status := G_RET_STS_UNEXP_ERROR;
1281:
1282: WHEN OTHERS THEN

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

1280: x_return_status := G_RET_STS_UNEXP_ERROR;
1281:
1282: WHEN OTHERS THEN
1283:
1284: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1285: p_msg_name => G_DB_ERROR,
1286: p_token1 => G_PROG_NAME_TOKEN,
1287: p_token1_value => l_prog_name,
1288: p_token2 => G_SQLCODE_TOKEN,

Line 1336: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1332: p_vlrv_rec => p_vlrv_tbl(i),
1333: x_vlrv_rec => x_vlrv_tbl(i));
1334:
1335: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1336: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF l_return_status = G_RET_STS_ERROR THEN
1338: RAISE OKL_API.G_EXCEPTION_ERROR;
1339: END IF;
1340:

Line 1338: RAISE OKL_API.G_EXCEPTION_ERROR;

1334:
1335: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1336: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF l_return_status = G_RET_STS_ERROR THEN
1338: RAISE OKL_API.G_EXCEPTION_ERROR;
1339: END IF;
1340:
1341: EXIT WHEN (i = p_vlrv_tbl.LAST);
1342: i := p_vlrv_tbl.NEXT(i);

Line 1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1354: x_return_status := l_return_status;
1355:
1356: EXCEPTION
1357:
1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1359:
1360: x_return_status := G_RET_STS_ERROR;
1361:
1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1359:
1360: x_return_status := G_RET_STS_ERROR;
1361:
1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1363:
1364: x_return_status := G_RET_STS_UNEXP_ERROR;
1365:
1366: WHEN OTHERS THEN

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

1364: x_return_status := G_RET_STS_UNEXP_ERROR;
1365:
1366: WHEN OTHERS THEN
1367:
1368: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1369: p_msg_name => G_DB_ERROR,
1370: p_token1 => G_PROG_NAME_TOKEN,
1371: p_token1_value => l_prog_name,
1372: p_token2 => G_SQLCODE_TOKEN,

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

1400: EXCEPTION
1401:
1402: WHEN OTHERS THEN
1403:
1404: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1405: p_msg_name => G_DB_ERROR,
1406: p_token1 => G_PROG_NAME_TOKEN,
1407: p_token1_value => l_prog_name,
1408: p_token2 => G_SQLCODE_TOKEN,

Line 1445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1441: delete_row (x_return_status => l_return_status,
1442: p_id => p_vlrv_rec.id);
1443:
1444: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = G_RET_STS_ERROR THEN
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:

Line 1447: RAISE OKL_API.G_EXCEPTION_ERROR;

1443:
1444: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = G_RET_STS_ERROR THEN
1447: RAISE OKL_API.G_EXCEPTION_ERROR;
1448: END IF;
1449:
1450: x_return_status := l_return_status;
1451:

Line 1454: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1450: x_return_status := l_return_status;
1451:
1452: EXCEPTION
1453:
1454: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1455:
1456: x_return_status := G_RET_STS_ERROR;
1457:
1458: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1458: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1454: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1455:
1456: x_return_status := G_RET_STS_ERROR;
1457:
1458: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1459:
1460: x_return_status := G_RET_STS_UNEXP_ERROR;
1461:
1462: WHEN OTHERS THEN

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

1460: x_return_status := G_RET_STS_UNEXP_ERROR;
1461:
1462: WHEN OTHERS THEN
1463:
1464: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1465: p_msg_name => G_DB_ERROR,
1466: p_token1 => G_PROG_NAME_TOKEN,
1467: p_token1_value => l_prog_name,
1468: p_token2 => G_SQLCODE_TOKEN,

Line 1514: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1510: delete_row (x_return_status => l_return_status,
1511: p_id => p_vlrv_tbl(i).id);
1512:
1513: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1514: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF l_return_status = G_RET_STS_ERROR THEN
1516: RAISE OKL_API.G_EXCEPTION_ERROR;
1517: END IF;
1518:

Line 1516: RAISE OKL_API.G_EXCEPTION_ERROR;

1512:
1513: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1514: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1515: ELSIF l_return_status = G_RET_STS_ERROR THEN
1516: RAISE OKL_API.G_EXCEPTION_ERROR;
1517: END IF;
1518:
1519: EXIT WHEN (i = p_vlrv_tbl.LAST);
1520: i := p_vlrv_tbl.NEXT(i);

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

1534: EXCEPTION
1535:
1536: WHEN OTHERS THEN
1537:
1538: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1539: p_msg_name => G_DB_ERROR,
1540: p_token1 => G_PROG_NAME_TOKEN,
1541: p_token1_value => l_prog_name,
1542: p_token2 => G_SQLCODE_TOKEN,