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

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

233: EXCEPTION
234:
235: WHEN OTHERS THEN
236:
237: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
238: p_msg_name => G_DB_ERROR,
239: p_token1 => G_PROG_NAME_TOKEN,
240: p_token1_value => l_prog_name,
241: p_token2 => G_SQLCODE_TOKEN,

Line 255: IF (p_id = OKL_API.G_MISS_NUM OR

251: -- PROCEDURE validate_id
252: ------------------------
253: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
254: BEGIN
255: IF (p_id = OKL_API.G_MISS_NUM OR
256: p_id IS NULL)
257: THEN
258: OKL_API.set_message(p_app_name => G_APP_NAME,
259: p_msg_name => G_COL_ERROR,

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

254: BEGIN
255: IF (p_id = OKL_API.G_MISS_NUM OR
256: p_id IS NULL)
257: THEN
258: OKL_API.set_message(p_app_name => G_APP_NAME,
259: p_msg_name => G_COL_ERROR,
260: p_token1 => G_COL_NAME_TOKEN,
261: p_token1_value => 'id',
262: p_token2 => G_PKG_NAME_TOKEN,

Line 264: RAISE OKL_API.G_EXCEPTION_ERROR;

260: p_token1 => G_COL_NAME_TOKEN,
261: p_token1_value => 'id',
262: p_token2 => G_PKG_NAME_TOKEN,
263: p_token2_value => G_PKG_NAME);
264: RAISE OKL_API.G_EXCEPTION_ERROR;
265: END IF;
266: x_return_status := G_RET_STS_SUCCESS;
267: END validate_id;
268:

Line 274: IF (p_object_version_number = OKL_API.G_MISS_NUM OR

270: -- PROCEDURE validate_object_version_number
271: -------------------------------------------
272: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
273: BEGIN
274: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
275: p_object_version_number IS NULL)
276: THEN
277: OKL_API.set_message(p_app_name => G_APP_NAME,
278: p_msg_name => G_COL_ERROR,

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

273: BEGIN
274: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
275: p_object_version_number IS NULL)
276: THEN
277: OKL_API.set_message(p_app_name => G_APP_NAME,
278: p_msg_name => G_COL_ERROR,
279: p_token1 => G_COL_NAME_TOKEN,
280: p_token1_value => 'object_version_number',
281: p_token2 => G_PKG_NAME_TOKEN,

Line 283: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 293: IF (p_leaseapp_template_id = OKL_API.G_MISS_NUM OR

289: -- PROCEDURE validate_leaseapp_template_id
290: --------------------------------------
291: PROCEDURE validate_leaseapp_template_id (x_return_status OUT NOCOPY VARCHAR2, p_leaseapp_template_id IN NUMBER) IS
292: BEGIN
293: IF (p_leaseapp_template_id = OKL_API.G_MISS_NUM OR
294: p_leaseapp_template_id IS NULL)
295: THEN
296: OKL_API.set_message(p_app_name => G_APP_NAME,
297: p_msg_name => G_COL_ERROR,

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

292: BEGIN
293: IF (p_leaseapp_template_id = OKL_API.G_MISS_NUM OR
294: p_leaseapp_template_id IS NULL)
295: THEN
296: OKL_API.set_message(p_app_name => G_APP_NAME,
297: p_msg_name => G_COL_ERROR,
298: p_token1 => G_COL_NAME_TOKEN,
299: p_token1_value => 'leaseapp_template_id',
300: p_token2 => G_PKG_NAME_TOKEN,

Line 302: RAISE OKL_API.G_EXCEPTION_ERROR;

298: p_token1 => G_COL_NAME_TOKEN,
299: p_token1_value => 'leaseapp_template_id',
300: p_token2 => G_PKG_NAME_TOKEN,
301: p_token2_value => G_PKG_NAME);
302: RAISE OKL_API.G_EXCEPTION_ERROR;
303: END IF;
304: x_return_status := G_RET_STS_SUCCESS;
305: END validate_leaseapp_template_id;
306:

Line 312: IF (p_version_status = OKL_API.G_MISS_CHAR OR

308: -- PROCEDURE validate_version_status
309: --------------------------------------
310: PROCEDURE validate_version_status (x_return_status OUT NOCOPY VARCHAR2, p_version_status IN VARCHAR2) IS
311: BEGIN
312: IF (p_version_status = OKL_API.G_MISS_CHAR OR
313: p_version_status IS NULL)
314: THEN
315: OKL_API.set_message(p_app_name => G_APP_NAME,
316: p_msg_name => G_COL_ERROR,

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

311: BEGIN
312: IF (p_version_status = OKL_API.G_MISS_CHAR OR
313: p_version_status IS NULL)
314: THEN
315: OKL_API.set_message(p_app_name => G_APP_NAME,
316: p_msg_name => G_COL_ERROR,
317: p_token1 => G_COL_NAME_TOKEN,
318: p_token1_value => 'version_status',
319: p_token2 => G_PKG_NAME_TOKEN,

Line 321: RAISE OKL_API.G_EXCEPTION_ERROR;

317: p_token1 => G_COL_NAME_TOKEN,
318: p_token1_value => 'version_status',
319: p_token2 => G_PKG_NAME_TOKEN,
320: p_token2_value => G_PKG_NAME);
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;
323: x_return_status := G_RET_STS_SUCCESS;
324: END validate_version_status;
325:

Line 331: IF (p_version_number = OKL_API.G_MISS_CHAR OR

327: -- PROCEDURE validate_version_number
328: --------------------------------------
329: PROCEDURE validate_version_number (x_return_status OUT NOCOPY VARCHAR2, p_version_number IN VARCHAR2) IS
330: BEGIN
331: IF (p_version_number = OKL_API.G_MISS_CHAR OR
332: p_version_number IS NULL)
333: THEN
334: OKL_API.set_message(p_app_name => G_APP_NAME,
335: p_msg_name => G_COL_ERROR,

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

330: BEGIN
331: IF (p_version_number = OKL_API.G_MISS_CHAR OR
332: p_version_number IS NULL)
333: THEN
334: OKL_API.set_message(p_app_name => G_APP_NAME,
335: p_msg_name => G_COL_ERROR,
336: p_token1 => G_COL_NAME_TOKEN,
337: p_token1_value => 'version_number',
338: p_token2 => G_PKG_NAME_TOKEN,

Line 340: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 350: IF (p_valid_from = OKL_API.G_MISS_DATE OR

346: -- PROCEDURE validate_valid_from
347: --------------------------------
348: PROCEDURE validate_valid_from (x_return_status OUT NOCOPY VARCHAR2, p_valid_from IN DATE) IS
349: BEGIN
350: IF (p_valid_from = OKL_API.G_MISS_DATE OR
351: p_valid_from IS NULL)
352: THEN
353: OKL_API.set_message(p_app_name => G_APP_NAME,
354: p_msg_name => G_COL_ERROR,

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

349: BEGIN
350: IF (p_valid_from = OKL_API.G_MISS_DATE OR
351: p_valid_from IS NULL)
352: THEN
353: OKL_API.set_message(p_app_name => G_APP_NAME,
354: p_msg_name => G_COL_ERROR,
355: p_token1 => G_COL_NAME_TOKEN,
356: p_token1_value => 'valid_from',
357: p_token2 => G_PKG_NAME_TOKEN,

Line 359: RAISE OKL_API.G_EXCEPTION_ERROR;

355: p_token1 => G_COL_NAME_TOKEN,
356: p_token1_value => 'valid_from',
357: p_token2 => G_PKG_NAME_TOKEN,
358: p_token2_value => G_PKG_NAME);
359: RAISE OKL_API.G_EXCEPTION_ERROR;
360: END IF;
361: x_return_status := G_RET_STS_SUCCESS;
362: END validate_valid_from;
363:

Line 400: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

396:
397: -- notify caller of an error as UNEXPETED error
398: l_return_status := OKC_API.G_RET_STS_ERROR;
399:
400: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
401: p_msg_name => 'OKL_INVALID_VALID_TO');
402: --End -varangan- updated the condition to > & message to OKL_INVALID_VALID_TO for bug#4684557
403:
404: -- notify caller of an error

Line 405: l_return_status := OKL_API.G_RET_STS_ERROR;

401: p_msg_name => 'OKL_INVALID_VALID_TO');
402: --End -varangan- updated the condition to > & message to OKL_INVALID_VALID_TO for bug#4684557
403:
404: -- notify caller of an error
405: l_return_status := OKL_API.G_RET_STS_ERROR;
406: END IF;
407: END IF;
408: RETURN l_return_status;
409: END validate_record;

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

533: EXCEPTION
534:
535: WHEN OTHERS THEN
536:
537: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
538: p_msg_name => G_DB_ERROR,
539: p_token1 => G_PROG_NAME_TOKEN,
540: p_token1_value => l_prog_name,
541: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 651: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 657: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 659: RAISE OKL_API.G_EXCEPTION_ERROR;

655:
656: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
657: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
659: RAISE OKL_API.G_EXCEPTION_ERROR;
660: END IF;
661:
662: migrate (l_lavv_rec, l_lav_rec);
663: migrate (l_lavv_rec, l_lavtl_rec);

Line 668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 670: RAISE OKL_API.G_EXCEPTION_ERROR;

666:
667: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_ERROR;
671: END IF;
672:
673: insert_row (x_return_status => l_return_status, p_lavtl_rec => l_lavtl_rec);
674:

Line 676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

672:
673: insert_row (x_return_status => l_return_status, p_lavtl_rec => l_lavtl_rec);
674:
675: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:

Line 678: RAISE OKL_API.G_EXCEPTION_ERROR;

674:
675: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
676: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
677: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
678: RAISE OKL_API.G_EXCEPTION_ERROR;
679: END IF;
680:
681: x_lavv_rec := l_lavv_rec;
682: x_return_status := l_return_status;

Line 686: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 690: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 740: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 747: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 751: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

801: p_lavv_rec => p_lavv_tbl(i),
802: x_lavv_rec => x_lavv_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_lavv_tbl.LAST);
811: i := p_lavv_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 890: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

Line 894: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

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

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

Line 919: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 927: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 931: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 968: RAISE OKL_API.G_EXCEPTION_ERROR;

964:
965: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
966: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF l_return_status = G_RET_STS_ERROR THEN
968: RAISE OKL_API.G_EXCEPTION_ERROR;
969: END IF;
970:
971: UPDATE okl_leaseapp_templ_versions_b
972: 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 1055: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

Line 1099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1095: x_lavv_rec := p_lavv_rec;
1096: l_db_lavv_rec := get_rec (p_lavv_rec.id, l_return_status);
1097:
1098: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = G_RET_STS_ERROR THEN
1101: RAISE OKL_API.G_EXCEPTION_ERROR;
1102: END IF;
1103:

Line 1101: RAISE OKL_API.G_EXCEPTION_ERROR;

1097:
1098: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF l_return_status = G_RET_STS_ERROR THEN
1101: RAISE OKL_API.G_EXCEPTION_ERROR;
1102: END IF;
1103:
1104: IF x_lavv_rec.attribute_category IS NULL THEN
1105: x_lavv_rec.attribute_category := l_db_lavv_rec.attribute_category;

Line 1180: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1176:
1177: RETURN l_return_status;
1178:
1179: EXCEPTION
1180: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1181:
1182: x_return_status := G_RET_STS_ERROR;
1183:
1184: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1184: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1207: l_return_status := populate_new_record (p_lavv_rec, l_lavv_rec);
1208: l_lavv_rec := null_out_defaults(l_lavv_rec);
1209:
1210: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215:

Line 1213: RAISE OKL_API.G_EXCEPTION_ERROR;

1209:
1210: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215:
1216: l_return_status := validate_attributes (l_lavv_rec);
1217:

Line 1219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1221: RAISE OKL_API.G_EXCEPTION_ERROR;

1217:
1218: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1220: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1221: RAISE OKL_API.G_EXCEPTION_ERROR;
1222: END IF;
1223:
1224: l_return_status := validate_record (l_lavv_rec);
1225:

Line 1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1229: RAISE OKL_API.G_EXCEPTION_ERROR;

1225:
1226: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: END IF;
1231:
1232: migrate (l_lavv_rec, l_lav_rec);
1233: migrate (l_lavv_rec, l_lavtl_rec);

Line 1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1234:
1235: update_row (x_return_status => l_return_status, p_lav_rec => l_lav_rec);
1236:
1237: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1239: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_ERROR;
1241: END IF;
1242:

Line 1240: RAISE OKL_API.G_EXCEPTION_ERROR;

1236:
1237: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1239: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_ERROR;
1241: END IF;
1242:
1243: update_row (x_return_status => l_return_status, p_lavtl_rec => l_lavtl_rec);
1244:

Line 1246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1248: RAISE OKL_API.G_EXCEPTION_ERROR;

1244:
1245: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_ERROR;
1249: END IF;
1250:
1251: x_return_status := l_return_status;
1252: x_lavv_rec := l_lavv_rec;

Line 1256: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1252: x_lavv_rec := l_lavv_rec;
1253:
1254: EXCEPTION
1255:
1256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1257:
1258: x_return_status := G_RET_STS_ERROR;
1259:
1260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1257:
1258: x_return_status := G_RET_STS_ERROR;
1259:
1260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1261:
1262: x_return_status := G_RET_STS_UNEXP_ERROR;
1263:
1264: WHEN OTHERS THEN

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

1262: x_return_status := G_RET_STS_UNEXP_ERROR;
1263:
1264: WHEN OTHERS THEN
1265:
1266: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1267: p_msg_name => G_DB_ERROR,
1268: p_token1 => G_PROG_NAME_TOKEN,
1269: p_token1_value => l_prog_name,
1270: p_token2 => G_SQLCODE_TOKEN,

Line 1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1304: p_lavv_rec => p_lavv_rec,
1305: x_lavv_rec => x_lavv_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: x_return_status := l_return_status;
1314:

Line 1317: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1313: x_return_status := l_return_status;
1314:
1315: EXCEPTION
1316:
1317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1318:
1319: x_return_status := G_RET_STS_ERROR;
1320:
1321: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1321: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1318:
1319: x_return_status := G_RET_STS_ERROR;
1320:
1321: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1322:
1323: x_return_status := G_RET_STS_UNEXP_ERROR;
1324:
1325: WHEN OTHERS THEN

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

1323: x_return_status := G_RET_STS_UNEXP_ERROR;
1324:
1325: WHEN OTHERS THEN
1326:
1327: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1328: p_msg_name => G_DB_ERROR,
1329: p_token1 => G_PROG_NAME_TOKEN,
1330: p_token1_value => l_prog_name,
1331: p_token2 => G_SQLCODE_TOKEN,

Line 1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1374: p_lavv_rec => p_lavv_tbl(i),
1375: x_lavv_rec => x_lavv_tbl(i));
1376:
1377: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF l_return_status = G_RET_STS_ERROR THEN
1380: RAISE OKL_API.G_EXCEPTION_ERROR;
1381: END IF;
1382:

Line 1380: RAISE OKL_API.G_EXCEPTION_ERROR;

1376:
1377: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1379: ELSIF l_return_status = G_RET_STS_ERROR THEN
1380: RAISE OKL_API.G_EXCEPTION_ERROR;
1381: END IF;
1382:
1383: EXIT WHEN (i = p_lavv_tbl.LAST);
1384: i := p_lavv_tbl.NEXT(i);

Line 1400: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1404: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

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

1441: EXCEPTION
1442:
1443: WHEN OTHERS THEN
1444:
1445: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1446: p_msg_name => G_DB_ERROR,
1447: p_token1 => G_PROG_NAME_TOKEN,
1448: p_token1_value => l_prog_name,
1449: p_token2 => G_SQLCODE_TOKEN,

Line 1485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1481: delete_row (x_return_status => l_return_status,
1482: p_id => p_lavv_rec.id);
1483:
1484: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = G_RET_STS_ERROR THEN
1487: RAISE OKL_API.G_EXCEPTION_ERROR;
1488: END IF;
1489:

Line 1487: RAISE OKL_API.G_EXCEPTION_ERROR;

1483:
1484: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = G_RET_STS_ERROR THEN
1487: RAISE OKL_API.G_EXCEPTION_ERROR;
1488: END IF;
1489:
1490: x_return_status := l_return_status;
1491:

Line 1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1490: x_return_status := l_return_status;
1491:
1492: EXCEPTION
1493:
1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1495:
1496: x_return_status := G_RET_STS_ERROR;
1497:
1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1494: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1495:
1496: x_return_status := G_RET_STS_ERROR;
1497:
1498: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1499:
1500: x_return_status := G_RET_STS_UNEXP_ERROR;
1501:
1502: WHEN OTHERS THEN

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

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

Line 1553: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1549: delete_row (x_return_status => l_return_status,
1550: p_id => p_lavv_tbl(i).id);
1551:
1552: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1553: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = G_RET_STS_ERROR THEN
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: END IF;
1557:

Line 1555: RAISE OKL_API.G_EXCEPTION_ERROR;

1551:
1552: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1553: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1554: ELSIF l_return_status = G_RET_STS_ERROR THEN
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: END IF;
1557:
1558: EXIT WHEN (i = p_lavv_tbl.LAST);
1559: i := p_lavv_tbl.NEXT(i);

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

1573: EXCEPTION
1574:
1575: WHEN OTHERS THEN
1576:
1577: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1578: p_msg_name => G_DB_ERROR,
1579: p_token1 => G_PROG_NAME_TOKEN,
1580: p_token1_value => l_prog_name,
1581: p_token2 => G_SQLCODE_TOKEN,