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

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

392: EXCEPTION
393:
394: WHEN OTHERS THEN
395:
396: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
397: p_msg_name => G_DB_ERROR,
398: p_token1 => G_PROG_NAME_TOKEN,
399: p_token1_value => l_prog_name,
400: p_token2 => G_SQLCODE_TOKEN,

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

412: ------------------------
413: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
414: BEGIN
415: IF p_id IS NULL THEN
416: OKL_API.set_message(p_app_name => G_APP_NAME,
417: p_msg_name => G_COL_ERROR,
418: p_token1 => G_COL_NAME_TOKEN,
419: p_token1_value => 'id',
420: p_token2 => G_PKG_NAME_TOKEN,

Line 422: RAISE OKL_API.G_EXCEPTION_ERROR;

418: p_token1 => G_COL_NAME_TOKEN,
419: p_token1_value => 'id',
420: p_token2 => G_PKG_NAME_TOKEN,
421: p_token2_value => G_PKG_NAME);
422: RAISE OKL_API.G_EXCEPTION_ERROR;
423: END IF;
424: x_return_status := G_RET_STS_SUCCESS;
425: END validate_id;
426:

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

430: -------------------------------------------
431: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
432: BEGIN
433: IF p_object_version_number IS NULL THEN
434: OKL_API.set_message(p_app_name => G_APP_NAME,
435: p_msg_name => G_COL_ERROR,
436: p_token1 => G_COL_NAME_TOKEN,
437: p_token1_value => 'object_version_number',
438: p_token2 => G_PKG_NAME_TOKEN,

Line 440: RAISE OKL_API.G_EXCEPTION_ERROR;

436: p_token1 => G_COL_NAME_TOKEN,
437: p_token1_value => 'object_version_number',
438: p_token2 => G_PKG_NAME_TOKEN,
439: p_token2_value => G_PKG_NAME);
440: RAISE OKL_API.G_EXCEPTION_ERROR;
441: END IF;
442: x_return_status := G_RET_STS_SUCCESS;
443: END validate_object_version_number;
444:

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

448: PROCEDURE validate_reference_number (x_return_status OUT NOCOPY VARCHAR2, p_reference_number IN VARCHAR2) IS
449: BEGIN
450:
451: IF p_reference_number IS NULL THEN
452: OKL_API.set_message(p_app_name => G_APP_NAME,
453: p_msg_name => G_COL_ERROR,
454: p_token1 => G_COL_NAME_TOKEN,
455: p_token1_value => 'reference_number',
456: p_token2 => G_PKG_NAME_TOKEN,

Line 458: RAISE OKL_API.G_EXCEPTION_ERROR;

454: p_token1 => G_COL_NAME_TOKEN,
455: p_token1_value => 'reference_number',
456: p_token2 => G_PKG_NAME_TOKEN,
457: p_token2_value => G_PKG_NAME);
458: RAISE OKL_API.G_EXCEPTION_ERROR;
459: END IF;
460:
461: x_return_status := G_RET_STS_SUCCESS;
462: END validate_reference_number;

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

468: PROCEDURE validate_status (x_return_status OUT NOCOPY VARCHAR2, p_status IN VARCHAR2) IS
469: BEGIN
470:
471: IF p_status IS NULL THEN
472: OKL_API.set_message(p_app_name => G_APP_NAME,
473: p_msg_name => G_COL_ERROR,
474: p_token1 => G_COL_NAME_TOKEN,
475: p_token1_value => 'status',
476: p_token2 => G_PKG_NAME_TOKEN,

Line 478: RAISE OKL_API.G_EXCEPTION_ERROR;

474: p_token1 => G_COL_NAME_TOKEN,
475: p_token1_value => 'status',
476: p_token2 => G_PKG_NAME_TOKEN,
477: p_token2_value => G_PKG_NAME);
478: RAISE OKL_API.G_EXCEPTION_ERROR;
479: END IF;
480:
481: x_return_status := G_RET_STS_SUCCESS;
482: END validate_status;

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

486: -----------------------------------------
487: PROCEDURE validate_valid_from (x_return_status OUT NOCOPY VARCHAR2, p_valid_from IN DATE) IS
488: BEGIN
489: IF p_valid_from IS NULL THEN
490: OKL_API.set_message(p_app_name => G_APP_NAME,
491: p_msg_name => G_COL_ERROR,
492: p_token1 => G_COL_NAME_TOKEN,
493: p_token1_value => 'valid_from',
494: p_token2 => G_PKG_NAME_TOKEN,

Line 496: RAISE OKL_API.G_EXCEPTION_ERROR;

492: p_token1 => G_COL_NAME_TOKEN,
493: p_token1_value => 'valid_from',
494: p_token2 => G_PKG_NAME_TOKEN,
495: p_token2_value => G_PKG_NAME);
496: RAISE OKL_API.G_EXCEPTION_ERROR;
497: END IF;
498: x_return_status := G_RET_STS_SUCCESS;
499: END validate_valid_from;
500:

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

503: -----------------------------------------
504: PROCEDURE validate_expected_start_date (x_return_status OUT NOCOPY VARCHAR2, p_expected_start_date IN DATE) IS
505: BEGIN
506: IF p_expected_start_date IS NULL THEN
507: OKL_API.set_message(p_app_name => G_APP_NAME,
508: p_msg_name => G_COL_ERROR,
509: p_token1 => G_COL_NAME_TOKEN,
510: p_token1_value => 'expected_start_date',
511: p_token2 => G_PKG_NAME_TOKEN,

Line 513: RAISE OKL_API.G_EXCEPTION_ERROR;

509: p_token1 => G_COL_NAME_TOKEN,
510: p_token1_value => 'expected_start_date',
511: p_token2 => G_PKG_NAME_TOKEN,
512: p_token2_value => G_PKG_NAME);
513: RAISE OKL_API.G_EXCEPTION_ERROR;
514: END IF;
515: x_return_status := G_RET_STS_SUCCESS;
516: END validate_expected_start_date;
517:

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

521: ----------------------------
522: PROCEDURE validate_org_id (x_return_status OUT NOCOPY VARCHAR2, p_org_id IN NUMBER) IS
523: BEGIN
524: IF p_org_id IS NULL THEN
525: OKL_API.set_message(p_app_name => G_APP_NAME,
526: p_msg_name => G_COL_ERROR,
527: p_token1 => G_COL_NAME_TOKEN,
528: p_token1_value => 'org_id',
529: p_token2 => G_PKG_NAME_TOKEN,

Line 531: RAISE OKL_API.G_EXCEPTION_ERROR;

527: p_token1 => G_COL_NAME_TOKEN,
528: p_token1_value => 'org_id',
529: p_token2 => G_PKG_NAME_TOKEN,
530: p_token2_value => G_PKG_NAME);
531: RAISE OKL_API.G_EXCEPTION_ERROR;
532: END IF;
533: x_return_status := G_RET_STS_SUCCESS;
534: END validate_org_id;
535:

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

539: --------------------------------
540: PROCEDURE validate_inv_org_id (x_return_status OUT NOCOPY VARCHAR2, p_inv_org_id IN NUMBER) IS
541: BEGIN
542: IF p_inv_org_id IS NULL THEN
543: OKL_API.set_message(p_app_name => G_APP_NAME,
544: p_msg_name => G_COL_ERROR,
545: p_token1 => G_COL_NAME_TOKEN,
546: p_token1_value => 'inv_org_id',
547: p_token2 => G_PKG_NAME_TOKEN,

Line 549: RAISE OKL_API.G_EXCEPTION_ERROR;

545: p_token1 => G_COL_NAME_TOKEN,
546: p_token1_value => 'inv_org_id',
547: p_token2 => G_PKG_NAME_TOKEN,
548: p_token2_value => G_PKG_NAME);
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: x_return_status := G_RET_STS_SUCCESS;
552: END validate_inv_org_id;
553:

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

557: ---------------------------------
558: PROCEDURE validate_prospect_id (x_return_status OUT NOCOPY VARCHAR2, p_prospect_id IN NUMBER) IS
559: BEGIN
560: IF p_prospect_id IS NULL THEN
561: OKL_API.set_message(p_app_name => G_APP_NAME,
562: p_msg_name => G_COL_ERROR,
563: p_token1 => G_COL_NAME_TOKEN,
564: p_token1_value => 'prospect_id',
565: p_token2 => G_PKG_NAME_TOKEN,

Line 567: RAISE OKL_API.G_EXCEPTION_ERROR;

563: p_token1 => G_COL_NAME_TOKEN,
564: p_token1_value => 'prospect_id',
565: p_token2 => G_PKG_NAME_TOKEN,
566: p_token2_value => G_PKG_NAME);
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: x_return_status := G_RET_STS_SUCCESS;
570: END validate_prospect_id;
571:

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

575: -----------------------------------------
576: PROCEDURE validate_prospect_address_id (x_return_status OUT NOCOPY VARCHAR2, p_prospect_address_id IN NUMBER) IS
577: BEGIN
578: IF p_prospect_address_id IS NULL THEN
579: OKL_API.set_message(p_app_name => G_APP_NAME,
580: p_msg_name => G_COL_ERROR,
581: p_token1 => G_COL_NAME_TOKEN,
582: p_token1_value => 'prospect_address_id',
583: p_token2 => G_PKG_NAME_TOKEN,

Line 585: RAISE OKL_API.G_EXCEPTION_ERROR;

581: p_token1 => G_COL_NAME_TOKEN,
582: p_token1_value => 'prospect_address_id',
583: p_token2 => G_PKG_NAME_TOKEN,
584: p_token2_value => G_PKG_NAME);
585: RAISE OKL_API.G_EXCEPTION_ERROR;
586: END IF;
587: x_return_status := G_RET_STS_SUCCESS;
588: END validate_prospect_address_id;
589:

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

593: -----------------------------------------
594: PROCEDURE validate_currency_code (x_return_status OUT NOCOPY VARCHAR2, p_currency_code IN VARCHAR2) IS
595: BEGIN
596: IF p_currency_code IS NULL THEN
597: OKL_API.set_message(p_app_name => G_APP_NAME,
598: p_msg_name => G_COL_ERROR,
599: p_token1 => G_COL_NAME_TOKEN,
600: p_token1_value => 'currency_code',
601: p_token2 => G_PKG_NAME_TOKEN,

Line 603: RAISE OKL_API.G_EXCEPTION_ERROR;

599: p_token1 => G_COL_NAME_TOKEN,
600: p_token1_value => 'currency_code',
601: p_token2 => G_PKG_NAME_TOKEN,
602: p_token2_value => G_PKG_NAME);
603: RAISE OKL_API.G_EXCEPTION_ERROR;
604: END IF;
605: x_return_status := G_RET_STS_SUCCESS;
606: END validate_currency_code;
607: --Added Bug # 5647107 ssdeshpa start

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

612: l_return_val NUMBER(1);
613: BEGIN
614: l_return_val := NVL((OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id)),0);
615: IF (p_legal_entity_id IS NOT NULL AND l_return_val <> 1) THEN
616: OKL_API.set_message(p_app_name => G_APP_NAME,
617: p_msg_name => G_COL_ERROR,
618: p_token1 => G_COL_NAME_TOKEN,
619: p_token1_value => 'legal_entity_id',
620: p_token2 => G_PKG_NAME_TOKEN,

Line 622: RAISE OKL_API.G_EXCEPTION_ERROR;

618: p_token1 => G_COL_NAME_TOKEN,
619: p_token1_value => 'legal_entity_id',
620: p_token2 => G_PKG_NAME_TOKEN,
621: p_token2_value => G_PKG_NAME);
622: RAISE OKL_API.G_EXCEPTION_ERROR;
623: END IF;
624: x_return_status := G_RET_STS_SUCCESS;
625: END validate_legal_entity_id;
626:

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

870: EXCEPTION
871:
872: WHEN OTHERS THEN
873:
874: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
875: p_msg_name => G_DB_ERROR,
876: p_token1 => G_PROG_NAME_TOKEN,
877: p_token1_value => l_prog_name,
878: p_token2 => G_SQLCODE_TOKEN,

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

945: EXCEPTION
946:
947: WHEN OTHERS THEN
948:
949: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
950: p_msg_name => G_DB_ERROR,
951: p_token1 => G_PROG_NAME_TOKEN,
952: p_token1_value => l_prog_name,
953: p_token2 => G_SQLCODE_TOKEN,

Line 996: RAISE OKL_API.G_EXCEPTION_ERROR;

992: --Bug 7022258-Added by kkorrapo
993: l_valid := okl_util.validate_seq_num('OKL_LOP_REF_SEQ','OKL_LEASE_OPPORTUNITIES_B','REFERENCE_NUMBER',l_lopv_rec.reference_number);
994:
995: IF l_valid = 'N' THEN
996: RAISE OKL_API.G_EXCEPTION_ERROR;
997: END IF;
998: --Bug 7022258--Addition end
999:
1000: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1001: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

997: END IF;
998: --Bug 7022258--Addition end
999:
1000: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1003: RAISE OKL_API.G_EXCEPTION_ERROR;
1004: END IF;
1005:

Line 1003: RAISE OKL_API.G_EXCEPTION_ERROR;

999:
1000: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1003: RAISE OKL_API.G_EXCEPTION_ERROR;
1004: END IF;
1005:
1006: l_return_status := validate_record(l_lopv_rec);
1007:

Line 1009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1005:
1006: l_return_status := validate_record(l_lopv_rec);
1007:
1008: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1010: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_ERROR;
1012: END IF;
1013:

Line 1011: RAISE OKL_API.G_EXCEPTION_ERROR;

1007:
1008: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1009: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1010: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_ERROR;
1012: END IF;
1013:
1014: migrate (l_lopv_rec, l_lop_rec);
1015: migrate (l_lopv_rec, l_loptl_rec);

Line 1020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1016:
1017: insert_row (x_return_status => l_return_status, p_lop_rec => l_lop_rec);
1018:
1019: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1021: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1022: RAISE OKL_API.G_EXCEPTION_ERROR;
1023: END IF;
1024:

Line 1022: RAISE OKL_API.G_EXCEPTION_ERROR;

1018:
1019: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1021: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1022: RAISE OKL_API.G_EXCEPTION_ERROR;
1023: END IF;
1024:
1025: insert_row (x_return_status => l_return_status, p_loptl_rec => l_loptl_rec);
1026:

Line 1028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1024:
1025: insert_row (x_return_status => l_return_status, p_loptl_rec => l_loptl_rec);
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: x_lopv_rec := l_lopv_rec;
1034: x_return_status := l_return_status;

Line 1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1034: x_return_status := l_return_status;
1035:
1036: EXCEPTION
1037:
1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1039:
1040: x_return_status := G_RET_STS_ERROR;
1041:
1042: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1042: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1038: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1039:
1040: x_return_status := G_RET_STS_ERROR;
1041:
1042: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1043:
1044: x_return_status := G_RET_STS_UNEXP_ERROR;
1045:
1046: WHEN OTHERS THEN

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

1044: x_return_status := G_RET_STS_UNEXP_ERROR;
1045:
1046: WHEN OTHERS THEN
1047:
1048: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1049: p_msg_name => G_DB_ERROR,
1050: p_token1 => G_PROG_NAME_TOKEN,
1051: p_token1_value => l_prog_name,
1052: p_token2 => G_SQLCODE_TOKEN,

Line 1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1087: p_lopv_rec => p_lopv_rec,
1088: x_lopv_rec => x_lopv_rec);
1089:
1090: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = G_RET_STS_ERROR THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;
1095:

Line 1093: RAISE OKL_API.G_EXCEPTION_ERROR;

1089:
1090: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = G_RET_STS_ERROR THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;
1095:
1096: x_return_status := l_return_status;
1097:

Line 1100: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1096: x_return_status := l_return_status;
1097:
1098: EXCEPTION
1099:
1100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1101:
1102: x_return_status := G_RET_STS_ERROR;
1103:
1104: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1104: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1106: x_return_status := G_RET_STS_UNEXP_ERROR;
1107:
1108: WHEN OTHERS THEN
1109:
1110: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1111: p_msg_name => G_DB_ERROR,
1112: p_token1 => G_PROG_NAME_TOKEN,
1113: p_token1_value => l_prog_name,
1114: p_token2 => G_SQLCODE_TOKEN,

Line 1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1155: p_lopv_rec => p_lopv_tbl(i),
1156: x_lopv_rec => x_lopv_tbl(i));
1157:
1158: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = G_RET_STS_ERROR THEN
1161: RAISE OKL_API.G_EXCEPTION_ERROR;
1162: END IF;
1163:

Line 1161: RAISE OKL_API.G_EXCEPTION_ERROR;

1157:
1158: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: ELSIF l_return_status = G_RET_STS_ERROR THEN
1161: RAISE OKL_API.G_EXCEPTION_ERROR;
1162: END IF;
1163:
1164: EXIT WHEN (i = p_lopv_tbl.LAST);
1165: i := p_lopv_tbl.NEXT(i);

Line 1181: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1185: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

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

1241:
1242: IF (lock_csr%ISOPEN) THEN
1243: CLOSE lock_csr;
1244: END IF;
1245: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1246: p_msg_name => G_OVN_ERROR2,
1247: p_token1 => G_PROG_NAME_TOKEN,
1248: p_token1_value => l_prog_name);
1249: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1249: RAISE OKL_API.G_EXCEPTION_ERROR;

1245: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1246: p_msg_name => G_OVN_ERROR2,
1247: p_token1 => G_PROG_NAME_TOKEN,
1248: p_token1_value => l_prog_name);
1249: RAISE OKL_API.G_EXCEPTION_ERROR;
1250: END;
1251:
1252: IF l_object_version_number IS NULL THEN
1253:

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

1256: CLOSE lchk_csr;
1257:
1258: IF lc_object_version_number IS NULL THEN
1259:
1260: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1261: p_msg_name => G_OVN_ERROR3,
1262: p_token1 => G_PROG_NAME_TOKEN,
1263: p_token1_value => l_prog_name);
1264:

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

1263: p_token1_value => l_prog_name);
1264:
1265: ELSIF lc_object_version_number <> p_lop_rec.object_version_number THEN
1266:
1267: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1268: p_msg_name => G_OVN_ERROR,
1269: p_token1 => G_PROG_NAME_TOKEN,
1270: p_token1_value => l_prog_name);
1271:

Line 1274: RAISE OKL_API.G_EXCEPTION_ERROR;

1270: p_token1_value => l_prog_name);
1271:
1272: END IF;
1273:
1274: RAISE OKL_API.G_EXCEPTION_ERROR;
1275:
1276: END IF;
1277:
1278: x_return_status := G_RET_STS_SUCCESS;

Line 1282: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1278: x_return_status := G_RET_STS_SUCCESS;
1279:
1280: EXCEPTION
1281:
1282: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1283:
1284: x_return_status := G_RET_STS_ERROR;
1285:
1286: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1286: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1282: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1283:
1284: x_return_status := G_RET_STS_ERROR;
1285:
1286: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1287:
1288: x_return_status := G_RET_STS_UNEXP_ERROR;
1289:
1290: WHEN OTHERS THEN

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

1288: x_return_status := G_RET_STS_UNEXP_ERROR;
1289:
1290: WHEN OTHERS THEN
1291:
1292: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1293: p_msg_name => G_DB_ERROR,
1294: p_token1 => G_PROG_NAME_TOKEN,
1295: p_token1_value => l_prog_name,
1296: p_token2 => G_SQLCODE_TOKEN,

Line 1322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1324: RAISE OKL_API.G_EXCEPTION_ERROR;

1320:
1321: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1323: ELSIF l_return_status = G_RET_STS_ERROR THEN
1324: RAISE OKL_API.G_EXCEPTION_ERROR;
1325: END IF;
1326:
1327: UPDATE okl_lease_opportunities_b
1328: SET

Line 1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1385: x_return_status := l_return_status;
1386:
1387: EXCEPTION
1388:
1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1390: x_return_status := G_RET_STS_ERROR;
1391:
1392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1393: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1388:
1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1390: x_return_status := G_RET_STS_ERROR;
1391:
1392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1393: x_return_status := G_RET_STS_UNEXP_ERROR;
1394:
1395: WHEN OTHERS THEN
1396: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1393: x_return_status := G_RET_STS_UNEXP_ERROR;
1394:
1395: WHEN OTHERS THEN
1396: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1397: p_msg_name => G_DB_ERROR,
1398: p_token1 => G_PROG_NAME_TOKEN,
1399: p_token1_value => l_prog_name,
1400: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 1491: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1487: x_lopv_rec := p_lopv_rec;
1488: l_db_lopv_rec := get_rec (p_lopv_rec.id, l_return_status);
1489:
1490: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF l_return_status = G_RET_STS_ERROR THEN
1493: RAISE OKL_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:

Line 1493: RAISE OKL_API.G_EXCEPTION_ERROR;

1489:
1490: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1491: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF l_return_status = G_RET_STS_ERROR THEN
1493: RAISE OKL_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: IF x_lopv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1497: x_lopv_rec.attribute_category := l_db_lopv_rec.attribute_category;

Line 1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1652: RETURN l_return_status;
1653:
1654: EXCEPTION
1655:
1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1657:
1658: x_return_status := G_RET_STS_ERROR;
1659:
1660: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1660: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1657:
1658: x_return_status := G_RET_STS_ERROR;
1659:
1660: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1661:
1662: x_return_status := G_RET_STS_UNEXP_ERROR;
1663:
1664: WHEN OTHERS THEN

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

1662: x_return_status := G_RET_STS_UNEXP_ERROR;
1663:
1664: WHEN OTHERS THEN
1665:
1666: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1667: p_msg_name => G_DB_ERROR,
1668: p_token1 => G_PROG_NAME_TOKEN,
1669: p_token1_value => l_prog_name,
1670: p_token2 => G_SQLCODE_TOKEN,

Line 1686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1682:
1683: l_return_status := populate_new_record (p_lopv_rec, l_lopv_rec);
1684:
1685: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_ERROR;
1689: END IF;
1690:

Line 1688: RAISE OKL_API.G_EXCEPTION_ERROR;

1684:
1685: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_ERROR;
1689: END IF;
1690:
1691: l_return_status := validate_attributes (l_lopv_rec);
1692:

Line 1694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1690:
1691: l_return_status := validate_attributes (l_lopv_rec);
1692:
1693: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1695: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1696: RAISE OKL_API.G_EXCEPTION_ERROR;
1697: END IF;
1698:

Line 1696: RAISE OKL_API.G_EXCEPTION_ERROR;

1692:
1693: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1695: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1696: RAISE OKL_API.G_EXCEPTION_ERROR;
1697: END IF;
1698:
1699: l_return_status := validate_record (l_lopv_rec);
1700:

Line 1702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1698:
1699: l_return_status := validate_record (l_lopv_rec);
1700:
1701: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1703: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1704: RAISE OKL_API.G_EXCEPTION_ERROR;
1705: END IF;
1706:

Line 1704: RAISE OKL_API.G_EXCEPTION_ERROR;

1700:
1701: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1703: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1704: RAISE OKL_API.G_EXCEPTION_ERROR;
1705: END IF;
1706:
1707: migrate (l_lopv_rec, l_lop_rec);
1708: migrate (l_lopv_rec, l_loptl_rec);

Line 1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1709:
1710: update_row (x_return_status => l_return_status, p_lop_rec => l_lop_rec);
1711:
1712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1715: RAISE OKL_API.G_EXCEPTION_ERROR;
1716: END IF;
1717:

Line 1715: RAISE OKL_API.G_EXCEPTION_ERROR;

1711:
1712: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1715: RAISE OKL_API.G_EXCEPTION_ERROR;
1716: END IF;
1717:
1718: update_row (x_return_status => l_return_status, p_loptl_rec => l_loptl_rec);
1719:

Line 1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1717:
1718: update_row (x_return_status => l_return_status, p_loptl_rec => l_loptl_rec);
1719:
1720: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_ERROR;
1724: END IF;
1725:

Line 1723: RAISE OKL_API.G_EXCEPTION_ERROR;

1719:
1720: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1722: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_ERROR;
1724: END IF;
1725:
1726: x_return_status := l_return_status;
1727: x_lopv_rec := l_lopv_rec;

Line 1731: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1727: x_lopv_rec := l_lopv_rec;
1728:
1729: EXCEPTION
1730:
1731: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1732:
1733: x_return_status := G_RET_STS_ERROR;
1734:
1735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1731: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1732:
1733: x_return_status := G_RET_STS_ERROR;
1734:
1735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1736:
1737: x_return_status := G_RET_STS_UNEXP_ERROR;
1738:
1739: WHEN OTHERS THEN

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

1737: x_return_status := G_RET_STS_UNEXP_ERROR;
1738:
1739: WHEN OTHERS THEN
1740:
1741: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1742: p_msg_name => G_DB_ERROR,
1743: p_token1 => G_PROG_NAME_TOKEN,
1744: p_token1_value => l_prog_name,
1745: p_token2 => G_SQLCODE_TOKEN,

Line 1784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1780: p_lopv_rec => p_lopv_rec,
1781: x_lopv_rec => x_lopv_rec);
1782:
1783: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = G_RET_STS_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_ERROR;
1787: END IF;
1788:

Line 1786: RAISE OKL_API.G_EXCEPTION_ERROR;

1782:
1783: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = G_RET_STS_ERROR THEN
1786: RAISE OKL_API.G_EXCEPTION_ERROR;
1787: END IF;
1788:
1789: x_return_status := l_return_status;
1790:

Line 1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1789: x_return_status := l_return_status;
1790:
1791: EXCEPTION
1792:
1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794:
1795: x_return_status := G_RET_STS_ERROR;
1796:
1797: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1797: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1793: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1794:
1795: x_return_status := G_RET_STS_ERROR;
1796:
1797: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1798:
1799: x_return_status := G_RET_STS_UNEXP_ERROR;
1800:
1801: WHEN OTHERS THEN

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

1799: x_return_status := G_RET_STS_UNEXP_ERROR;
1800:
1801: WHEN OTHERS THEN
1802:
1803: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1804: p_msg_name => G_DB_ERROR,
1805: p_token1 => G_PROG_NAME_TOKEN,
1806: p_token1_value => l_prog_name,
1807: p_token2 => G_SQLCODE_TOKEN,

Line 1855: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1851: p_lopv_rec => p_lopv_tbl(i),
1852: x_lopv_rec => x_lopv_tbl(i));
1853:
1854: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1855: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF l_return_status = G_RET_STS_ERROR THEN
1857: RAISE OKL_API.G_EXCEPTION_ERROR;
1858: END IF;
1859:

Line 1857: RAISE OKL_API.G_EXCEPTION_ERROR;

1853:
1854: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1855: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF l_return_status = G_RET_STS_ERROR THEN
1857: RAISE OKL_API.G_EXCEPTION_ERROR;
1858: END IF;
1859:
1860: EXIT WHEN (i = p_lopv_tbl.LAST);
1861: i := p_lopv_tbl.NEXT(i);

Line 1877: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1873: x_return_status := l_return_status;
1874:
1875: EXCEPTION
1876:
1877: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1878:
1879: x_return_status := G_RET_STS_ERROR;
1880:
1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1877: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1878:
1879: x_return_status := G_RET_STS_ERROR;
1880:
1881: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1882:
1883: x_return_status := G_RET_STS_UNEXP_ERROR;
1884:
1885: WHEN OTHERS THEN

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

1883: x_return_status := G_RET_STS_UNEXP_ERROR;
1884:
1885: WHEN OTHERS THEN
1886:
1887: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1888: p_msg_name => G_DB_ERROR,
1889: p_token1 => G_PROG_NAME_TOKEN,
1890: p_token1_value => l_prog_name,
1891: p_token2 => G_SQLCODE_TOKEN,

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

1919: EXCEPTION
1920:
1921: WHEN OTHERS THEN
1922:
1923: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1924: p_msg_name => G_DB_ERROR,
1925: p_token1 => G_PROG_NAME_TOKEN,
1926: p_token1_value => l_prog_name,
1927: p_token2 => G_SQLCODE_TOKEN,

Line 1964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1960: delete_row (x_return_status => l_return_status,
1961: p_id => p_lopv_rec.id);
1962:
1963: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1965: ELSIF l_return_status = G_RET_STS_ERROR THEN
1966: RAISE OKL_API.G_EXCEPTION_ERROR;
1967: END IF;
1968:

Line 1966: RAISE OKL_API.G_EXCEPTION_ERROR;

1962:
1963: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1965: ELSIF l_return_status = G_RET_STS_ERROR THEN
1966: RAISE OKL_API.G_EXCEPTION_ERROR;
1967: END IF;
1968:
1969: x_return_status := l_return_status;
1970:

Line 1973: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1969: x_return_status := l_return_status;
1970:
1971: EXCEPTION
1972:
1973: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1974:
1975: x_return_status := G_RET_STS_ERROR;
1976:
1977: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1977: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1973: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1974:
1975: x_return_status := G_RET_STS_ERROR;
1976:
1977: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1978:
1979: x_return_status := G_RET_STS_UNEXP_ERROR;
1980:
1981: WHEN OTHERS THEN

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

1979: x_return_status := G_RET_STS_UNEXP_ERROR;
1980:
1981: WHEN OTHERS THEN
1982:
1983: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1984: p_msg_name => G_DB_ERROR,
1985: p_token1 => G_PROG_NAME_TOKEN,
1986: p_token1_value => l_prog_name,
1987: p_token2 => G_SQLCODE_TOKEN,

Line 2033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2029: delete_row (x_return_status => l_return_status,
2030: p_id => p_lopv_tbl(i).id);
2031:
2032: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2034: ELSIF l_return_status = G_RET_STS_ERROR THEN
2035: RAISE OKL_API.G_EXCEPTION_ERROR;
2036: END IF;
2037:

Line 2035: RAISE OKL_API.G_EXCEPTION_ERROR;

2031:
2032: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2034: ELSIF l_return_status = G_RET_STS_ERROR THEN
2035: RAISE OKL_API.G_EXCEPTION_ERROR;
2036: END IF;
2037:
2038: EXIT WHEN (i = p_lopv_tbl.LAST);
2039: i := p_lopv_tbl.NEXT(i);

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

2053: EXCEPTION
2054:
2055: WHEN OTHERS THEN
2056:
2057: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2058: p_msg_name => G_DB_ERROR,
2059: p_token1 => G_PROG_NAME_TOKEN,
2060: p_token1_value => l_prog_name,
2061: p_token2 => G_SQLCODE_TOKEN,