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 252: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

248: EXCEPTION
249:
250: WHEN OTHERS THEN
251:
252: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
253: p_msg_name => G_DB_ERROR,
254: p_token1 => G_PROG_NAME_TOKEN,
255: p_token1_value => l_prog_name,
256: p_token2 => G_SQLCODE_TOKEN,

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

268: ------------------------
269: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
270: BEGIN
271: IF p_id IS NULL THEN
272: OKL_API.set_message(p_app_name => G_APP_NAME,
273: p_msg_name => G_COL_ERROR,
274: p_token1 => G_COL_NAME_TOKEN,
275: p_token1_value => 'id',
276: p_token2 => G_PKG_NAME_TOKEN,

Line 278: RAISE OKL_API.G_EXCEPTION_ERROR;

274: p_token1 => G_COL_NAME_TOKEN,
275: p_token1_value => 'id',
276: p_token2 => G_PKG_NAME_TOKEN,
277: p_token2_value => G_PKG_NAME);
278: RAISE OKL_API.G_EXCEPTION_ERROR;
279: END IF;
280: x_return_status := G_RET_STS_SUCCESS;
281: END validate_id;
282:

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

286: -------------------------------------------
287: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
288: BEGIN
289: IF p_object_version_number IS NULL THEN
290: OKL_API.set_message(p_app_name => G_APP_NAME,
291: p_msg_name => G_COL_ERROR,
292: p_token1 => G_COL_NAME_TOKEN,
293: p_token1_value => 'object_version_number',
294: p_token2 => G_PKG_NAME_TOKEN,

Line 296: RAISE OKL_API.G_EXCEPTION_ERROR;

292: p_token1 => G_COL_NAME_TOKEN,
293: p_token1_value => 'object_version_number',
294: p_token2 => G_PKG_NAME_TOKEN,
295: p_token2_value => G_PKG_NAME);
296: RAISE OKL_API.G_EXCEPTION_ERROR;
297: END IF;
298: x_return_status := G_RET_STS_SUCCESS;
299: END validate_object_version_number;
300:

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

304: --------------------------------------
305: PROCEDURE validate_source_line_type (x_return_status OUT NOCOPY VARCHAR2, p_source_line_type IN VARCHAR2) IS
306: BEGIN
307: IF p_source_line_type IS NULL THEN
308: OKL_API.set_message(p_app_name => G_APP_NAME,
309: p_msg_name => G_COL_ERROR,
310: p_token1 => G_COL_NAME_TOKEN,
311: p_token1_value => 'source_line_type',
312: p_token2 => G_PKG_NAME_TOKEN,

Line 314: RAISE OKL_API.G_EXCEPTION_ERROR;

310: p_token1 => G_COL_NAME_TOKEN,
311: p_token1_value => 'source_line_type',
312: p_token2 => G_PKG_NAME_TOKEN,
313: p_token2_value => G_PKG_NAME);
314: RAISE OKL_API.G_EXCEPTION_ERROR;
315: END IF;
316: x_return_status := G_RET_STS_SUCCESS;
317: END validate_source_line_type;
318:

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

322: --------------------------------------
323: PROCEDURE validate_source_line_id (x_return_status OUT NOCOPY VARCHAR2, p_source_line_id IN NUMBER) IS
324: BEGIN
325: IF p_source_line_id IS NULL THEN
326: OKL_API.set_message(p_app_name => G_APP_NAME,
327: p_msg_name => G_COL_ERROR,
328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'source_line_id',
330: p_token2 => G_PKG_NAME_TOKEN,

Line 332: RAISE OKL_API.G_EXCEPTION_ERROR;

328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'source_line_id',
330: p_token2 => G_PKG_NAME_TOKEN,
331: p_token2_value => G_PKG_NAME);
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334: x_return_status := G_RET_STS_SUCCESS;
335: END validate_source_line_id;
336:

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

340: --------------------------------------
341: PROCEDURE validate_related_line_type (x_return_status OUT NOCOPY VARCHAR2, p_related_line_type IN VARCHAR2) IS
342: BEGIN
343: IF p_related_line_type IS NULL THEN
344: OKL_API.set_message(p_app_name => G_APP_NAME,
345: p_msg_name => G_COL_ERROR,
346: p_token1 => G_COL_NAME_TOKEN,
347: p_token1_value => 'related_line_type',
348: p_token2 => G_PKG_NAME_TOKEN,

Line 350: RAISE OKL_API.G_EXCEPTION_ERROR;

346: p_token1 => G_COL_NAME_TOKEN,
347: p_token1_value => 'related_line_type',
348: p_token2 => G_PKG_NAME_TOKEN,
349: p_token2_value => G_PKG_NAME);
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;
352: x_return_status := G_RET_STS_SUCCESS;
353: END validate_related_line_type;
354:

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

358: --------------------------------------
359: PROCEDURE validate_related_line_id (x_return_status OUT NOCOPY VARCHAR2, p_related_line_id IN NUMBER) IS
360: BEGIN
361: IF p_related_line_id IS NULL THEN
362: OKL_API.set_message(p_app_name => G_APP_NAME,
363: p_msg_name => G_COL_ERROR,
364: p_token1 => G_COL_NAME_TOKEN,
365: p_token1_value => 'related_line_id',
366: p_token2 => G_PKG_NAME_TOKEN,

Line 368: RAISE OKL_API.G_EXCEPTION_ERROR;

364: p_token1 => G_COL_NAME_TOKEN,
365: p_token1_value => 'related_line_id',
366: p_token2 => G_PKG_NAME_TOKEN,
367: p_token2_value => G_PKG_NAME);
368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370: x_return_status := G_RET_STS_SUCCESS;
371: END validate_related_line_id;
372:

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

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

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

600: EXCEPTION
601:
602: WHEN OTHERS THEN
603:
604: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
605: p_msg_name => G_DB_ERROR,
606: p_token1 => G_PROG_NAME_TOKEN,
607: p_token1_value => l_prog_name,
608: p_token2 => G_SQLCODE_TOKEN,

Line 647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

643:
644: l_return_status := validate_attributes(l_lrev_rec);
645:
646: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_ERROR;
650: END IF;
651:

Line 649: RAISE OKL_API.G_EXCEPTION_ERROR;

645:
646: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
648: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_ERROR;
650: END IF;
651:
652: l_return_status := validate_record(l_lrev_rec);
653:

Line 655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

651:
652: l_return_status := validate_record(l_lrev_rec);
653:
654: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:

Line 657: RAISE OKL_API.G_EXCEPTION_ERROR;

653:
654: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: migrate (l_lrev_rec, l_lre_rec);
661: migrate (l_lrev_rec, l_lretl_rec);

Line 666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

662:
663: insert_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);
664:
665: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670:

Line 668: RAISE OKL_API.G_EXCEPTION_ERROR;

664:
665: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
667: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670:
671: insert_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
672:

Line 674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

670:
671: insert_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
672:
673: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_ERROR;
677: END IF;
678:

Line 676: RAISE OKL_API.G_EXCEPTION_ERROR;

672:
673: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_ERROR;
677: END IF;
678:
679: x_lrev_rec := l_lrev_rec;
680: x_return_status := l_return_status;

Line 684: WHEN OKL_API.G_EXCEPTION_ERROR THEN

680: x_return_status := l_return_status;
681:
682: EXCEPTION
683:
684: WHEN OKL_API.G_EXCEPTION_ERROR THEN
685:
686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 688: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

684: WHEN OKL_API.G_EXCEPTION_ERROR THEN
685:
686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
689:
690: x_return_status := G_RET_STS_UNEXP_ERROR;
691:
692: WHEN OTHERS THEN

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

690: x_return_status := G_RET_STS_UNEXP_ERROR;
691:
692: WHEN OTHERS THEN
693:
694: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
695: p_msg_name => G_DB_ERROR,
696: p_token1 => G_PROG_NAME_TOKEN,
697: p_token1_value => l_prog_name,
698: p_token2 => G_SQLCODE_TOKEN,

Line 737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

733: p_lrev_rec => p_lrev_rec,
734: x_lrev_rec => x_lrev_rec);
735:
736: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF l_return_status = G_RET_STS_ERROR THEN
739: RAISE OKL_API.G_EXCEPTION_ERROR;
740: END IF;
741:

Line 739: RAISE OKL_API.G_EXCEPTION_ERROR;

735:
736: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF l_return_status = G_RET_STS_ERROR THEN
739: RAISE OKL_API.G_EXCEPTION_ERROR;
740: END IF;
741:
742: x_return_status := l_return_status;
743:

Line 746: WHEN OKL_API.G_EXCEPTION_ERROR THEN

742: x_return_status := l_return_status;
743:
744: EXCEPTION
745:
746: WHEN OKL_API.G_EXCEPTION_ERROR THEN
747:
748: x_return_status := G_RET_STS_ERROR;
749:
750: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 750: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

752: x_return_status := G_RET_STS_UNEXP_ERROR;
753:
754: WHEN OTHERS THEN
755:
756: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
757: p_msg_name => G_DB_ERROR,
758: p_token1 => G_PROG_NAME_TOKEN,
759: p_token1_value => l_prog_name,
760: p_token2 => G_SQLCODE_TOKEN,

Line 805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

801: p_lrev_rec => p_lrev_tbl(i),
802: x_lrev_rec => x_lrev_tbl(i));
803:
804: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
806: ELSIF l_return_status = G_RET_STS_ERROR THEN
807: RAISE OKL_API.G_EXCEPTION_ERROR;
808: END IF;
809:

Line 807: RAISE OKL_API.G_EXCEPTION_ERROR;

803:
804: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
806: ELSIF l_return_status = G_RET_STS_ERROR THEN
807: RAISE OKL_API.G_EXCEPTION_ERROR;
808: END IF;
809:
810: EXIT WHEN (i = p_lrev_tbl.LAST);
811: i := p_lrev_tbl.NEXT(i);

Line 827: WHEN OKL_API.G_EXCEPTION_ERROR THEN

823: x_return_status := l_return_status;
824:
825: EXCEPTION
826:
827: WHEN OKL_API.G_EXCEPTION_ERROR THEN
828:
829: x_return_status := G_RET_STS_ERROR;
830:
831: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 831: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

827: WHEN OKL_API.G_EXCEPTION_ERROR THEN
828:
829: x_return_status := G_RET_STS_ERROR;
830:
831: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
832:
833: x_return_status := G_RET_STS_UNEXP_ERROR;
834:
835: WHEN OTHERS THEN

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

833: x_return_status := G_RET_STS_UNEXP_ERROR;
834:
835: WHEN OTHERS THEN
836:
837: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
838: p_msg_name => G_DB_ERROR,
839: p_token1 => G_PROG_NAME_TOKEN,
840: p_token1_value => l_prog_name,
841: p_token2 => G_SQLCODE_TOKEN,

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

887:
888: IF (lock_csr%ISOPEN) THEN
889: CLOSE lock_csr;
890: END IF;
891: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
892: p_msg_name => G_OVN_ERROR2,
893: p_token1 => G_PROG_NAME_TOKEN,
894: p_token1_value => l_prog_name);
895: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 895: RAISE OKL_API.G_EXCEPTION_ERROR;

891: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
892: p_msg_name => G_OVN_ERROR2,
893: p_token1 => G_PROG_NAME_TOKEN,
894: p_token1_value => l_prog_name);
895: RAISE OKL_API.G_EXCEPTION_ERROR;
896: END;
897:
898: IF l_object_version_number IS NULL THEN
899:

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

902: CLOSE lchk_csr;
903:
904: IF lc_object_version_number IS NULL THEN
905:
906: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
907: p_msg_name => G_OVN_ERROR3,
908: p_token1 => G_PROG_NAME_TOKEN,
909: p_token1_value => l_prog_name);
910:

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

909: p_token1_value => l_prog_name);
910:
911: ELSIF lc_object_version_number <> p_lre_rec.object_version_number THEN
912:
913: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
914: p_msg_name => G_OVN_ERROR,
915: p_token1 => G_PROG_NAME_TOKEN,
916: p_token1_value => l_prog_name);
917:

Line 920: RAISE OKL_API.G_EXCEPTION_ERROR;

916: p_token1_value => l_prog_name);
917:
918: END IF;
919:
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921:
922: END IF;
923:
924: x_return_status := G_RET_STS_SUCCESS;

Line 928: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 932: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

928: WHEN OKL_API.G_EXCEPTION_ERROR THEN
929:
930: x_return_status := G_RET_STS_ERROR;
931:
932: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
933:
934: x_return_status := G_RET_STS_UNEXP_ERROR;
935:
936: WHEN OTHERS THEN

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

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

Line 968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

964:
965: lock_row (x_return_status => l_return_status, p_lre_rec => p_lre_rec);
966:
967: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF l_return_status = G_RET_STS_ERROR THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:

Line 970: RAISE OKL_API.G_EXCEPTION_ERROR;

966:
967: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF l_return_status = G_RET_STS_ERROR THEN
970: RAISE OKL_API.G_EXCEPTION_ERROR;
971: END IF;
972:
973: UPDATE okl_LINE_RELATIONSHIPS_b
974: SET

Line 1003: WHEN OKL_API.G_EXCEPTION_ERROR THEN

999: x_return_status := l_return_status;
1000:
1001: EXCEPTION
1002:
1003: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1004: x_return_status := G_RET_STS_ERROR;
1005:
1006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1007: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1002:
1003: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1004: x_return_status := G_RET_STS_ERROR;
1005:
1006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1007: x_return_status := G_RET_STS_UNEXP_ERROR;
1008:
1009: WHEN OTHERS THEN
1010: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1007: x_return_status := G_RET_STS_UNEXP_ERROR;
1008:
1009: WHEN OTHERS THEN
1010: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1011: p_msg_name => G_DB_ERROR,
1012: p_token1 => G_PROG_NAME_TOKEN,
1013: p_token1_value => l_prog_name,
1014: p_token2 => G_SQLCODE_TOKEN,

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

1054: EXCEPTION
1055:
1056: WHEN OTHERS THEN
1057:
1058: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1059: p_msg_name => G_DB_ERROR,
1060: p_token1 => G_PROG_NAME_TOKEN,
1061: p_token1_value => l_prog_name,
1062: p_token2 => G_SQLCODE_TOKEN,

Line 1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1101: x_lrev_rec := p_lrev_rec;
1102: l_db_lrev_rec := get_rec (p_lrev_rec.id, l_return_status);
1103:
1104: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF l_return_status = G_RET_STS_ERROR THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:

Line 1107: RAISE OKL_API.G_EXCEPTION_ERROR;

1103:
1104: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF l_return_status = G_RET_STS_ERROR THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: IF x_lrev_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1111: x_lrev_rec.attribute_category := l_db_lrev_rec.attribute_category;

Line 1187: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1183: RETURN l_return_status;
1184:
1185: EXCEPTION
1186:
1187: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1188:
1189: x_return_status := G_RET_STS_ERROR;
1190:
1191: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1191: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1187: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1188:
1189: x_return_status := G_RET_STS_ERROR;
1190:
1191: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1192:
1193: x_return_status := G_RET_STS_UNEXP_ERROR;
1194:
1195: WHEN OTHERS THEN

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

1193: x_return_status := G_RET_STS_UNEXP_ERROR;
1194:
1195: WHEN OTHERS THEN
1196:
1197: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1198: p_msg_name => G_DB_ERROR,
1199: p_token1 => G_PROG_NAME_TOKEN,
1200: p_token1_value => l_prog_name,
1201: p_token2 => G_SQLCODE_TOKEN,

Line 1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1213:
1214: l_return_status := populate_new_record (p_lrev_rec, l_lrev_rec);
1215:
1216: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221:

Line 1219: RAISE OKL_API.G_EXCEPTION_ERROR;

1215:
1216: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221:
1222: l_return_status := validate_attributes (l_lrev_rec);
1223:

Line 1225: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1221:
1222: l_return_status := validate_attributes (l_lrev_rec);
1223:
1224: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_ERROR;
1228: END IF;
1229:

Line 1227: RAISE OKL_API.G_EXCEPTION_ERROR;

1223:
1224: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_ERROR;
1228: END IF;
1229:
1230: l_return_status := validate_record (l_lrev_rec);
1231:

Line 1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1229:
1230: l_return_status := validate_record (l_lrev_rec);
1231:
1232: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:

Line 1235: RAISE OKL_API.G_EXCEPTION_ERROR;

1231:
1232: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:
1238: migrate (l_lrev_rec, l_lre_rec);
1239: migrate (l_lrev_rec, l_lretl_rec);

Line 1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1240:
1241: update_row (x_return_status => l_return_status, p_lre_rec => l_lre_rec);
1242:
1243: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248:

Line 1246: RAISE OKL_API.G_EXCEPTION_ERROR;

1242:
1243: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248:
1249: update_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
1250:

Line 1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1248:
1249: update_row (x_return_status => l_return_status, p_lretl_rec => l_lretl_rec);
1250:
1251: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:

Line 1254: RAISE OKL_API.G_EXCEPTION_ERROR;

1250:
1251: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:
1257: x_return_status := l_return_status;
1258: x_lrev_rec := l_lrev_rec;

Line 1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1258: x_lrev_rec := l_lrev_rec;
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 1315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1311: p_lrev_rec => p_lrev_rec,
1312: x_lrev_rec => x_lrev_rec);
1313:
1314: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = G_RET_STS_ERROR THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: END IF;
1319:

Line 1317: RAISE OKL_API.G_EXCEPTION_ERROR;

1313:
1314: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1315: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1316: ELSIF l_return_status = G_RET_STS_ERROR THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: END IF;
1319:
1320: x_return_status := l_return_status;
1321:

Line 1324: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1328: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1382: p_lrev_rec => p_lrev_tbl(i),
1383: x_lrev_rec => x_lrev_tbl(i));
1384:
1385: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF l_return_status = G_RET_STS_ERROR THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;
1390:

Line 1388: RAISE OKL_API.G_EXCEPTION_ERROR;

1384:
1385: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF l_return_status = G_RET_STS_ERROR THEN
1388: RAISE OKL_API.G_EXCEPTION_ERROR;
1389: END IF;
1390:
1391: EXIT WHEN (i = p_lrev_tbl.LAST);
1392: i := p_lrev_tbl.NEXT(i);

Line 1408: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1404: x_return_status := l_return_status;
1405:
1406: EXCEPTION
1407:
1408: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1409:
1410: x_return_status := G_RET_STS_ERROR;
1411:
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1408: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1409:
1410: x_return_status := G_RET_STS_ERROR;
1411:
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1413:
1414: x_return_status := G_RET_STS_UNEXP_ERROR;
1415:
1416: WHEN OTHERS THEN

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

1414: x_return_status := G_RET_STS_UNEXP_ERROR;
1415:
1416: WHEN OTHERS THEN
1417:
1418: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1419: p_msg_name => G_DB_ERROR,
1420: p_token1 => G_PROG_NAME_TOKEN,
1421: p_token1_value => l_prog_name,
1422: p_token2 => G_SQLCODE_TOKEN,

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

1450: EXCEPTION
1451:
1452: WHEN OTHERS THEN
1453:
1454: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1455: p_msg_name => G_DB_ERROR,
1456: p_token1 => G_PROG_NAME_TOKEN,
1457: p_token1_value => l_prog_name,
1458: p_token2 => G_SQLCODE_TOKEN,

Line 1495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1491: delete_row (x_return_status => l_return_status,
1492: p_id => p_lrev_rec.id);
1493:
1494: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = G_RET_STS_ERROR THEN
1497: RAISE OKL_API.G_EXCEPTION_ERROR;
1498: END IF;
1499:

Line 1497: RAISE OKL_API.G_EXCEPTION_ERROR;

1493:
1494: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = G_RET_STS_ERROR THEN
1497: RAISE OKL_API.G_EXCEPTION_ERROR;
1498: END IF;
1499:
1500: x_return_status := l_return_status;
1501:

Line 1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1500: x_return_status := l_return_status;
1501:
1502: EXCEPTION
1503:
1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := G_RET_STS_ERROR;
1507:
1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := G_RET_STS_ERROR;
1507:
1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509:
1510: x_return_status := G_RET_STS_UNEXP_ERROR;
1511:
1512: WHEN OTHERS THEN

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

1510: x_return_status := G_RET_STS_UNEXP_ERROR;
1511:
1512: WHEN OTHERS THEN
1513:
1514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1515: p_msg_name => G_DB_ERROR,
1516: p_token1 => G_PROG_NAME_TOKEN,
1517: p_token1_value => l_prog_name,
1518: p_token2 => G_SQLCODE_TOKEN,

Line 1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1560: delete_row (x_return_status => l_return_status,
1561: p_id => p_lrev_tbl(i).id);
1562:
1563: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = G_RET_STS_ERROR THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;
1568:

Line 1566: RAISE OKL_API.G_EXCEPTION_ERROR;

1562:
1563: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF l_return_status = G_RET_STS_ERROR THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;
1568:
1569: EXIT WHEN (i = p_lrev_tbl.LAST);
1570: i := p_lrev_tbl.NEXT(i);

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

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