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

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

486: EXCEPTION
487:
488: WHEN OTHERS THEN
489:
490: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
491: p_msg_name => G_DB_ERROR,
492: p_token1 => G_PROG_NAME_TOKEN,
493: p_token1_value => l_prog_name,
494: p_token2 => G_SQLCODE_TOKEN,

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

506: ------------------------
507: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
508: BEGIN
509: IF p_id IS NULL THEN
510: OKL_API.set_message(p_app_name => G_APP_NAME,
511: p_msg_name => G_COL_ERROR,
512: p_token1 => G_COL_NAME_TOKEN,
513: p_token1_value => 'id',
514: p_token2 => G_PKG_NAME_TOKEN,

Line 516: RAISE OKL_API.G_EXCEPTION_ERROR;

512: p_token1 => G_COL_NAME_TOKEN,
513: p_token1_value => 'id',
514: p_token2 => G_PKG_NAME_TOKEN,
515: p_token2_value => G_PKG_NAME);
516: RAISE OKL_API.G_EXCEPTION_ERROR;
517: END IF;
518: x_return_status := G_RET_STS_SUCCESS;
519: END validate_id;
520:

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

524: -------------------------------------------
525: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
526: BEGIN
527: IF p_object_version_number IS NULL THEN
528: OKL_API.set_message(p_app_name => G_APP_NAME,
529: p_msg_name => G_COL_ERROR,
530: p_token1 => G_COL_NAME_TOKEN,
531: p_token1_value => 'object_version_number',
532: p_token2 => G_PKG_NAME_TOKEN,

Line 534: RAISE OKL_API.G_EXCEPTION_ERROR;

530: p_token1 => G_COL_NAME_TOKEN,
531: p_token1_value => 'object_version_number',
532: p_token2 => G_PKG_NAME_TOKEN,
533: p_token2_value => G_PKG_NAME);
534: RAISE OKL_API.G_EXCEPTION_ERROR;
535: END IF;
536: x_return_status := G_RET_STS_SUCCESS;
537: END validate_object_version_number;
538:

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

542: --------------------------------------
543: PROCEDURE validate_reference_number (x_return_status OUT NOCOPY VARCHAR2, p_reference_number IN VARCHAR2) IS
544: BEGIN
545: IF p_reference_number IS NULL THEN
546: OKL_API.set_message(p_app_name => G_APP_NAME,
547: p_msg_name => G_COL_ERROR,
548: p_token1 => G_COL_NAME_TOKEN,
549: p_token1_value => 'reference_number',
550: p_token2 => G_PKG_NAME_TOKEN,

Line 552: RAISE OKL_API.G_EXCEPTION_ERROR;

548: p_token1 => G_COL_NAME_TOKEN,
549: p_token1_value => 'reference_number',
550: p_token2 => G_PKG_NAME_TOKEN,
551: p_token2_value => G_PKG_NAME);
552: RAISE OKL_API.G_EXCEPTION_ERROR;
553: END IF;
554:
555: --Bug 7022258-Added by kkorrapo
556: IF (okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',p_reference_number) = 'N') THEN

Line 557: RAISE okl_api.g_exception_error;

553: END IF;
554:
555: --Bug 7022258-Added by kkorrapo
556: IF (okl_util.validate_seq_num('OKL_LSQ_REF_SEQ','OKL_LEASE_QUOTES_B','REFERENCE_NUMBER',p_reference_number) = 'N') THEN
557: RAISE okl_api.g_exception_error;
558: END IF;
559: --Bug 7022258--Addition end
560:
561: x_return_status := G_RET_STS_SUCCESS;

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

567: -----------------------------------------
568: PROCEDURE validate_status (x_return_status OUT NOCOPY VARCHAR2, p_status IN VARCHAR2) IS
569: BEGIN
570: IF p_status IS NULL THEN
571: OKL_API.set_message(p_app_name => G_APP_NAME,
572: p_msg_name => G_COL_ERROR,
573: p_token1 => G_COL_NAME_TOKEN,
574: p_token1_value => 'status',
575: p_token2 => G_PKG_NAME_TOKEN,

Line 577: RAISE OKL_API.G_EXCEPTION_ERROR;

573: p_token1 => G_COL_NAME_TOKEN,
574: p_token1_value => 'status',
575: p_token2 => G_PKG_NAME_TOKEN,
576: p_token2_value => G_PKG_NAME);
577: RAISE OKL_API.G_EXCEPTION_ERROR;
578: END IF;
579: x_return_status := G_RET_STS_SUCCESS;
580: END validate_status;
581:

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

585: -----------------------------------------
586: PROCEDURE validate_parent_object_code (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_code IN VARCHAR2) IS
587: BEGIN
588: IF p_parent_object_code IS NULL THEN
589: OKL_API.set_message(p_app_name => G_APP_NAME,
590: p_msg_name => G_COL_ERROR,
591: p_token1 => G_COL_NAME_TOKEN,
592: p_token1_value => 'parent_object_code',
593: p_token2 => G_PKG_NAME_TOKEN,

Line 595: RAISE OKL_API.G_EXCEPTION_ERROR;

591: p_token1 => G_COL_NAME_TOKEN,
592: p_token1_value => 'parent_object_code',
593: p_token2 => G_PKG_NAME_TOKEN,
594: p_token2_value => G_PKG_NAME);
595: RAISE OKL_API.G_EXCEPTION_ERROR;
596: END IF;
597: x_return_status := G_RET_STS_SUCCESS;
598: END validate_parent_object_code;
599:

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

603: -----------------------------------------
604: PROCEDURE validate_parent_object_id (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_id IN NUMBER) IS
605: BEGIN
606: IF p_parent_object_id IS NULL THEN
607: OKL_API.set_message(p_app_name => G_APP_NAME,
608: p_msg_name => G_COL_ERROR,
609: p_token1 => G_COL_NAME_TOKEN,
610: p_token1_value => 'parent_object_id',
611: p_token2 => G_PKG_NAME_TOKEN,

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609: p_token1 => G_COL_NAME_TOKEN,
610: p_token1_value => 'parent_object_id',
611: p_token2 => G_PKG_NAME_TOKEN,
612: p_token2_value => G_PKG_NAME);
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: x_return_status := G_RET_STS_SUCCESS;
616: END validate_parent_object_id;
617:

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

621: -----------------------------------------
622: PROCEDURE validate_expected_start_date (x_return_status OUT NOCOPY VARCHAR2, p_expected_start_date IN DATE) IS
623: BEGIN
624: IF p_expected_start_date IS NULL THEN
625: OKL_API.set_message(p_app_name => G_APP_NAME,
626: p_msg_name => G_COL_ERROR,
627: p_token1 => G_COL_NAME_TOKEN,
628: p_token1_value => 'expected_start_date',
629: p_token2 => G_PKG_NAME_TOKEN,

Line 631: RAISE OKL_API.G_EXCEPTION_ERROR;

627: p_token1 => G_COL_NAME_TOKEN,
628: p_token1_value => 'expected_start_date',
629: p_token2 => G_PKG_NAME_TOKEN,
630: p_token2_value => G_PKG_NAME);
631: RAISE OKL_API.G_EXCEPTION_ERROR;
632: END IF;
633: x_return_status := G_RET_STS_SUCCESS;
634: END validate_expected_start_date;
635:

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

639: -----------------------------------------
640: PROCEDURE validate_pricing_method (x_return_status OUT NOCOPY VARCHAR2, p_pricing_method IN VARCHAR2) IS
641: BEGIN
642: IF p_pricing_method IS NULL THEN
643: OKL_API.set_message(p_app_name => G_APP_NAME,
644: p_msg_name => G_COL_ERROR,
645: p_token1 => G_COL_NAME_TOKEN,
646: p_token1_value => 'pricing_method',
647: p_token2 => G_PKG_NAME_TOKEN,

Line 649: RAISE OKL_API.G_EXCEPTION_ERROR;

645: p_token1 => G_COL_NAME_TOKEN,
646: p_token1_value => 'pricing_method',
647: p_token2 => G_PKG_NAME_TOKEN,
648: p_token2_value => G_PKG_NAME);
649: RAISE OKL_API.G_EXCEPTION_ERROR;
650: END IF;
651: x_return_status := G_RET_STS_SUCCESS;
652: END validate_pricing_method;
653:

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

657: -----------------------------------------
658: PROCEDURE validate_term (x_return_status OUT NOCOPY VARCHAR2, p_term IN NUMBER) IS
659: BEGIN
660: IF p_term IS NULL THEN
661: OKL_API.set_message(p_app_name => G_APP_NAME,
662: p_msg_name => G_COL_ERROR,
663: p_token1 => G_COL_NAME_TOKEN,
664: p_token1_value => 'term',
665: p_token2 => G_PKG_NAME_TOKEN,

Line 667: RAISE OKL_API.G_EXCEPTION_ERROR;

663: p_token1 => G_COL_NAME_TOKEN,
664: p_token1_value => 'term',
665: p_token2 => G_PKG_NAME_TOKEN,
666: p_token2_value => G_PKG_NAME);
667: RAISE OKL_API.G_EXCEPTION_ERROR;
668: END IF;
669: x_return_status := G_RET_STS_SUCCESS;
670: END validate_term;
671:

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

675: -----------------------------------------
676: PROCEDURE validate_product_id (x_return_status OUT NOCOPY VARCHAR2, p_product_id IN NUMBER) IS
677: BEGIN
678: IF p_product_id IS NULL THEN
679: OKL_API.set_message(p_app_name => G_APP_NAME,
680: p_msg_name => G_COL_ERROR,
681: p_token1 => G_COL_NAME_TOKEN,
682: p_token1_value => 'product_id',
683: p_token2 => G_PKG_NAME_TOKEN,

Line 685: RAISE OKL_API.G_EXCEPTION_ERROR;

681: p_token1 => G_COL_NAME_TOKEN,
682: p_token1_value => 'product_id',
683: p_token2 => G_PKG_NAME_TOKEN,
684: p_token2_value => G_PKG_NAME);
685: RAISE OKL_API.G_EXCEPTION_ERROR;
686: END IF;
687: x_return_status := G_RET_STS_SUCCESS;
688: END validate_product_id;
689:

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

693: -----------------------------------------
694: PROCEDURE validate_end_of_term_option_id (x_return_status OUT NOCOPY VARCHAR2, p_end_of_term_option_id IN NUMBER) IS
695: BEGIN
696: IF p_end_of_term_option_id IS NULL THEN
697: OKL_API.set_message(p_app_name => G_APP_NAME,
698: p_msg_name => G_COL_ERROR,
699: p_token1 => G_COL_NAME_TOKEN,
700: p_token1_value => 'end_of_term_option_id',
701: p_token2 => G_PKG_NAME_TOKEN,

Line 703: RAISE OKL_API.G_EXCEPTION_ERROR;

699: p_token1 => G_COL_NAME_TOKEN,
700: p_token1_value => 'end_of_term_option_id',
701: p_token2 => G_PKG_NAME_TOKEN,
702: p_token2_value => G_PKG_NAME);
703: RAISE OKL_API.G_EXCEPTION_ERROR;
704: END IF;
705: x_return_status := G_RET_STS_SUCCESS;
706: END validate_end_of_term_option_id;
707:

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

713: l_return_val NUMBER(1);
714: BEGIN
715: l_return_val := NVL((OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id)),0);
716: IF (p_legal_entity_id IS NOT NULL AND l_return_val <> 1) THEN
717: OKL_API.set_message(p_app_name => G_APP_NAME,
718: p_msg_name => G_COL_ERROR,
719: p_token1 => G_COL_NAME_TOKEN,
720: p_token1_value => 'legal_entity_id',
721: p_token2 => G_PKG_NAME_TOKEN,

Line 723: RAISE OKL_API.G_EXCEPTION_ERROR;

719: p_token1 => G_COL_NAME_TOKEN,
720: p_token1_value => 'legal_entity_id',
721: p_token2 => G_PKG_NAME_TOKEN,
722: p_token2_value => G_PKG_NAME);
723: RAISE OKL_API.G_EXCEPTION_ERROR;
724: END IF;
725: x_return_status := G_RET_STS_SUCCESS;
726: END validate_legal_entity_id;
727:

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

1030: EXCEPTION
1031:
1032: WHEN OTHERS THEN
1033:
1034: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1035: p_msg_name => G_DB_ERROR,
1036: p_token1 => G_PROG_NAME_TOKEN,
1037: p_token1_value => l_prog_name,
1038: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 1152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1148:
1149: l_return_status := validate_attributes(l_lsqv_rec,'CREATE'); --Bug 7596781
1150:
1151: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1153: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1154: RAISE OKL_API.G_EXCEPTION_ERROR;
1155: END IF;
1156:

Line 1154: RAISE OKL_API.G_EXCEPTION_ERROR;

1150:
1151: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1153: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1154: RAISE OKL_API.G_EXCEPTION_ERROR;
1155: END IF;
1156:
1157: l_return_status := validate_record(l_lsqv_rec);
1158:

Line 1160: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1156:
1157: l_return_status := validate_record(l_lsqv_rec);
1158:
1159: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1161: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1162: RAISE OKL_API.G_EXCEPTION_ERROR;
1163: END IF;
1164:

Line 1162: RAISE OKL_API.G_EXCEPTION_ERROR;

1158:
1159: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1161: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1162: RAISE OKL_API.G_EXCEPTION_ERROR;
1163: END IF;
1164:
1165: migrate (l_lsqv_rec, l_lsq_rec);
1166: migrate (l_lsqv_rec, l_lsqtl_rec);

Line 1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1167:
1168: insert_row (x_return_status => l_return_status, p_lsq_rec => l_lsq_rec);
1169:
1170: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;
1175:

Line 1173: RAISE OKL_API.G_EXCEPTION_ERROR;

1169:
1170: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;
1175:
1176: insert_row (x_return_status => l_return_status, p_lsqtl_rec => l_lsqtl_rec);
1177:

Line 1179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1175:
1176: insert_row (x_return_status => l_return_status, p_lsqtl_rec => l_lsqtl_rec);
1177:
1178: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1181: RAISE OKL_API.G_EXCEPTION_ERROR;
1182: END IF;
1183:

Line 1181: RAISE OKL_API.G_EXCEPTION_ERROR;

1177:
1178: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1180: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1181: RAISE OKL_API.G_EXCEPTION_ERROR;
1182: END IF;
1183:
1184: x_lsqv_rec := l_lsqv_rec;
1185: x_return_status := l_return_status;

Line 1189: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 1242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1238: p_lsqv_rec => p_lsqv_rec,
1239: x_lsqv_rec => x_lsqv_rec);
1240:
1241: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF l_return_status = G_RET_STS_ERROR THEN
1244: RAISE OKL_API.G_EXCEPTION_ERROR;
1245: END IF;
1246:

Line 1244: RAISE OKL_API.G_EXCEPTION_ERROR;

1240:
1241: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF l_return_status = G_RET_STS_ERROR THEN
1244: RAISE OKL_API.G_EXCEPTION_ERROR;
1245: END IF;
1246:
1247: x_return_status := l_return_status;
1248:

Line 1251: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1247: x_return_status := l_return_status;
1248:
1249: EXCEPTION
1250:
1251: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1252:
1253: x_return_status := G_RET_STS_ERROR;
1254:
1255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1251: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1252:
1253: x_return_status := G_RET_STS_ERROR;
1254:
1255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1256:
1257: x_return_status := G_RET_STS_UNEXP_ERROR;
1258:
1259: WHEN OTHERS THEN

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

1257: x_return_status := G_RET_STS_UNEXP_ERROR;
1258:
1259: WHEN OTHERS THEN
1260:
1261: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1262: p_msg_name => G_DB_ERROR,
1263: p_token1 => G_PROG_NAME_TOKEN,
1264: p_token1_value => l_prog_name,
1265: p_token2 => G_SQLCODE_TOKEN,

Line 1310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1306: p_lsqv_rec => p_lsqv_tbl(i),
1307: x_lsqv_rec => x_lsqv_tbl(i));
1308:
1309: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1311: ELSIF l_return_status = G_RET_STS_ERROR THEN
1312: RAISE OKL_API.G_EXCEPTION_ERROR;
1313: END IF;
1314:

Line 1312: RAISE OKL_API.G_EXCEPTION_ERROR;

1308:
1309: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1310: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1311: ELSIF l_return_status = G_RET_STS_ERROR THEN
1312: RAISE OKL_API.G_EXCEPTION_ERROR;
1313: END IF;
1314:
1315: EXIT WHEN (i = p_lsqv_tbl.LAST);
1316: i := p_lsqv_tbl.NEXT(i);

Line 1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1328: x_return_status := l_return_status;
1329:
1330: EXCEPTION
1331:
1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333:
1334: x_return_status := G_RET_STS_ERROR;
1335:
1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1332: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1333:
1334: x_return_status := G_RET_STS_ERROR;
1335:
1336: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1337:
1338: x_return_status := G_RET_STS_UNEXP_ERROR;
1339:
1340: WHEN OTHERS THEN

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

1338: x_return_status := G_RET_STS_UNEXP_ERROR;
1339:
1340: WHEN OTHERS THEN
1341:
1342: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1343: p_msg_name => G_DB_ERROR,
1344: p_token1 => G_PROG_NAME_TOKEN,
1345: p_token1_value => l_prog_name,
1346: p_token2 => G_SQLCODE_TOKEN,

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

1392:
1393: IF (lock_csr%ISOPEN) THEN
1394: CLOSE lock_csr;
1395: END IF;
1396: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1397: p_msg_name => G_OVN_ERROR2,
1398: p_token1 => G_PROG_NAME_TOKEN,
1399: p_token1_value => l_prog_name);
1400: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1400: RAISE OKL_API.G_EXCEPTION_ERROR;

1396: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1397: p_msg_name => G_OVN_ERROR2,
1398: p_token1 => G_PROG_NAME_TOKEN,
1399: p_token1_value => l_prog_name);
1400: RAISE OKL_API.G_EXCEPTION_ERROR;
1401: END;
1402:
1403: IF l_object_version_number IS NULL THEN
1404:

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

1407: CLOSE lchk_csr;
1408:
1409: IF lc_object_version_number IS NULL THEN
1410:
1411: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1412: p_msg_name => G_OVN_ERROR3,
1413: p_token1 => G_PROG_NAME_TOKEN,
1414: p_token1_value => l_prog_name);
1415:

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

1414: p_token1_value => l_prog_name);
1415:
1416: ELSIF lc_object_version_number <> p_lsq_rec.object_version_number THEN
1417:
1418: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1419: p_msg_name => G_OVN_ERROR,
1420: p_token1 => G_PROG_NAME_TOKEN,
1421: p_token1_value => l_prog_name);
1422:

Line 1425: RAISE OKL_API.G_EXCEPTION_ERROR;

1421: p_token1_value => l_prog_name);
1422:
1423: END IF;
1424:
1425: RAISE OKL_API.G_EXCEPTION_ERROR;
1426:
1427: END IF;
1428:
1429: x_return_status := G_RET_STS_SUCCESS;

Line 1433: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1429: x_return_status := G_RET_STS_SUCCESS;
1430:
1431: EXCEPTION
1432:
1433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1434:
1435: x_return_status := G_RET_STS_ERROR;
1436:
1437: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1437: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1434:
1435: x_return_status := G_RET_STS_ERROR;
1436:
1437: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1438:
1439: x_return_status := G_RET_STS_UNEXP_ERROR;
1440:
1441: WHEN OTHERS THEN

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

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

Line 1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469:
1470: lock_row (x_return_status => l_return_status, p_lsq_rec => p_lsq_rec);
1471:
1472: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = G_RET_STS_ERROR THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:

Line 1475: RAISE OKL_API.G_EXCEPTION_ERROR;

1471:
1472: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = G_RET_STS_ERROR THEN
1475: RAISE OKL_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: UPDATE okl_lease_quotes_b
1479: SET

Line 1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1552: x_return_status := l_return_status;
1553:
1554: EXCEPTION
1555:
1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1557: x_return_status := G_RET_STS_ERROR;
1558:
1559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1560: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1555:
1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1557: x_return_status := G_RET_STS_ERROR;
1558:
1559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1560: x_return_status := G_RET_STS_UNEXP_ERROR;
1561:
1562: WHEN OTHERS THEN
1563: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1559: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1560: x_return_status := G_RET_STS_UNEXP_ERROR;
1561:
1562: WHEN OTHERS THEN
1563: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1564: p_msg_name => G_DB_ERROR,
1565: p_token1 => G_PROG_NAME_TOKEN,
1566: p_token1_value => l_prog_name,
1567: p_token2 => G_SQLCODE_TOKEN,

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

1607: EXCEPTION
1608:
1609: WHEN OTHERS THEN
1610:
1611: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1612: p_msg_name => G_DB_ERROR,
1613: p_token1 => G_PROG_NAME_TOKEN,
1614: p_token1_value => l_prog_name,
1615: p_token2 => G_SQLCODE_TOKEN,

Line 1658: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1654: x_lsqv_rec := p_lsqv_rec;
1655: l_db_lsqv_rec := get_rec (p_lsqv_rec.id, l_return_status);
1656:
1657: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1658: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = G_RET_STS_ERROR THEN
1660: RAISE OKL_API.G_EXCEPTION_ERROR;
1661: END IF;
1662:

Line 1660: RAISE OKL_API.G_EXCEPTION_ERROR;

1656:
1657: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1658: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = G_RET_STS_ERROR THEN
1660: RAISE OKL_API.G_EXCEPTION_ERROR;
1661: END IF;
1662:
1663: IF x_lsqv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1664: x_lsqv_rec.attribute_category := l_db_lsqv_rec.attribute_category;

Line 1882: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1878: RETURN l_return_status;
1879:
1880: EXCEPTION
1881:
1882: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1883:
1884: x_return_status := G_RET_STS_ERROR;
1885:
1886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1882: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1883:
1884: x_return_status := G_RET_STS_ERROR;
1885:
1886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1887:
1888: x_return_status := G_RET_STS_UNEXP_ERROR;
1889:
1890: WHEN OTHERS THEN

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

1888: x_return_status := G_RET_STS_UNEXP_ERROR;
1889:
1890: WHEN OTHERS THEN
1891:
1892: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1893: p_msg_name => G_DB_ERROR,
1894: p_token1 => G_PROG_NAME_TOKEN,
1895: p_token1_value => l_prog_name,
1896: p_token2 => G_SQLCODE_TOKEN,

Line 1912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1908:
1909: l_return_status := populate_new_record (p_lsqv_rec, l_lsqv_rec);
1910:
1911: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1913: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1914: RAISE OKL_API.G_EXCEPTION_ERROR;
1915: END IF;
1916:

Line 1914: RAISE OKL_API.G_EXCEPTION_ERROR;

1910:
1911: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1913: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1914: RAISE OKL_API.G_EXCEPTION_ERROR;
1915: END IF;
1916:
1917: l_return_status := validate_attributes (l_lsqv_rec,'UPDATE'); --Bug 7596781
1918:

Line 1920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1916:
1917: l_return_status := validate_attributes (l_lsqv_rec,'UPDATE'); --Bug 7596781
1918:
1919: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1922: RAISE OKL_API.G_EXCEPTION_ERROR;
1923: END IF;
1924:

Line 1922: RAISE OKL_API.G_EXCEPTION_ERROR;

1918:
1919: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1920: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1921: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1922: RAISE OKL_API.G_EXCEPTION_ERROR;
1923: END IF;
1924:
1925: l_return_status := validate_record (l_lsqv_rec);
1926:

Line 1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1924:
1925: l_return_status := validate_record (l_lsqv_rec);
1926:
1927: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;
1932:

Line 1930: RAISE OKL_API.G_EXCEPTION_ERROR;

1926:
1927: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;
1932:
1933: migrate (l_lsqv_rec, l_lsq_rec);
1934: migrate (l_lsqv_rec, l_lsqtl_rec);

Line 1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1935:
1936: update_row (x_return_status => l_return_status, p_lsq_rec => l_lsq_rec);
1937:
1938: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1941: RAISE OKL_API.G_EXCEPTION_ERROR;
1942: END IF;
1943:

Line 1941: RAISE OKL_API.G_EXCEPTION_ERROR;

1937:
1938: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1941: RAISE OKL_API.G_EXCEPTION_ERROR;
1942: END IF;
1943:
1944: update_row (x_return_status => l_return_status, p_lsqtl_rec => l_lsqtl_rec);
1945:

Line 1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1943:
1944: update_row (x_return_status => l_return_status, p_lsqtl_rec => l_lsqtl_rec);
1945:
1946: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951:

Line 1949: RAISE OKL_API.G_EXCEPTION_ERROR;

1945:
1946: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1947: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1948: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1949: RAISE OKL_API.G_EXCEPTION_ERROR;
1950: END IF;
1951:
1952: x_return_status := l_return_status;
1953: x_lsqv_rec := l_lsqv_rec;

Line 1957: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1953: x_lsqv_rec := l_lsqv_rec;
1954:
1955: EXCEPTION
1956:
1957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1958:
1959: x_return_status := G_RET_STS_ERROR;
1960:
1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1958:
1959: x_return_status := G_RET_STS_ERROR;
1960:
1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1962:
1963: x_return_status := G_RET_STS_UNEXP_ERROR;
1964:
1965: WHEN OTHERS THEN

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

1963: x_return_status := G_RET_STS_UNEXP_ERROR;
1964:
1965: WHEN OTHERS THEN
1966:
1967: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1968: p_msg_name => G_DB_ERROR,
1969: p_token1 => G_PROG_NAME_TOKEN,
1970: p_token1_value => l_prog_name,
1971: p_token2 => G_SQLCODE_TOKEN,

Line 2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2006: p_lsqv_rec => p_lsqv_rec,
2007: x_lsqv_rec => x_lsqv_rec);
2008:
2009: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF l_return_status = G_RET_STS_ERROR THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;
2014:

Line 2012: RAISE OKL_API.G_EXCEPTION_ERROR;

2008:
2009: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF l_return_status = G_RET_STS_ERROR THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;
2014:
2015: x_return_status := l_return_status;
2016:

Line 2019: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2015: x_return_status := l_return_status;
2016:
2017: EXCEPTION
2018:
2019: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2020:
2021: x_return_status := G_RET_STS_ERROR;
2022:
2023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2019: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2020:
2021: x_return_status := G_RET_STS_ERROR;
2022:
2023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2024:
2025: x_return_status := G_RET_STS_UNEXP_ERROR;
2026:
2027: WHEN OTHERS THEN

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

2025: x_return_status := G_RET_STS_UNEXP_ERROR;
2026:
2027: WHEN OTHERS THEN
2028:
2029: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2030: p_msg_name => G_DB_ERROR,
2031: p_token1 => G_PROG_NAME_TOKEN,
2032: p_token1_value => l_prog_name,
2033: p_token2 => G_SQLCODE_TOKEN,

Line 2081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2077: p_lsqv_rec => p_lsqv_tbl(i),
2078: x_lsqv_rec => x_lsqv_tbl(i));
2079:
2080: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF l_return_status = G_RET_STS_ERROR THEN
2083: RAISE OKL_API.G_EXCEPTION_ERROR;
2084: END IF;
2085:

Line 2083: RAISE OKL_API.G_EXCEPTION_ERROR;

2079:
2080: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF l_return_status = G_RET_STS_ERROR THEN
2083: RAISE OKL_API.G_EXCEPTION_ERROR;
2084: END IF;
2085:
2086: EXIT WHEN (i = p_lsqv_tbl.LAST);
2087: i := p_lsqv_tbl.NEXT(i);

Line 2103: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2099: x_return_status := l_return_status;
2100:
2101: EXCEPTION
2102:
2103: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2104:
2105: x_return_status := G_RET_STS_ERROR;
2106:
2107: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2107: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2103: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2104:
2105: x_return_status := G_RET_STS_ERROR;
2106:
2107: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2108:
2109: x_return_status := G_RET_STS_UNEXP_ERROR;
2110:
2111: WHEN OTHERS THEN

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

2109: x_return_status := G_RET_STS_UNEXP_ERROR;
2110:
2111: WHEN OTHERS THEN
2112:
2113: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2114: p_msg_name => G_DB_ERROR,
2115: p_token1 => G_PROG_NAME_TOKEN,
2116: p_token1_value => l_prog_name,
2117: p_token2 => G_SQLCODE_TOKEN,

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

2145: EXCEPTION
2146:
2147: WHEN OTHERS THEN
2148:
2149: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2150: p_msg_name => G_DB_ERROR,
2151: p_token1 => G_PROG_NAME_TOKEN,
2152: p_token1_value => l_prog_name,
2153: p_token2 => G_SQLCODE_TOKEN,

Line 2190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2186: delete_row (x_return_status => l_return_status,
2187: p_id => p_lsqv_rec.id);
2188:
2189: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2191: ELSIF l_return_status = G_RET_STS_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_ERROR;
2193: END IF;
2194:

Line 2192: RAISE OKL_API.G_EXCEPTION_ERROR;

2188:
2189: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2191: ELSIF l_return_status = G_RET_STS_ERROR THEN
2192: RAISE OKL_API.G_EXCEPTION_ERROR;
2193: END IF;
2194:
2195: x_return_status := l_return_status;
2196:

Line 2199: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2195: x_return_status := l_return_status;
2196:
2197: EXCEPTION
2198:
2199: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2200:
2201: x_return_status := G_RET_STS_ERROR;
2202:
2203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2199: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2200:
2201: x_return_status := G_RET_STS_ERROR;
2202:
2203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2204:
2205: x_return_status := G_RET_STS_UNEXP_ERROR;
2206:
2207: WHEN OTHERS THEN

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

2205: x_return_status := G_RET_STS_UNEXP_ERROR;
2206:
2207: WHEN OTHERS THEN
2208:
2209: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2210: p_msg_name => G_DB_ERROR,
2211: p_token1 => G_PROG_NAME_TOKEN,
2212: p_token1_value => l_prog_name,
2213: p_token2 => G_SQLCODE_TOKEN,

Line 2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2255: delete_row (x_return_status => l_return_status,
2256: p_id => p_lsqv_tbl(i).id);
2257:
2258: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = G_RET_STS_ERROR THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;
2263:

Line 2261: RAISE OKL_API.G_EXCEPTION_ERROR;

2257:
2258: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = G_RET_STS_ERROR THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;
2263:
2264: EXIT WHEN (i = p_lsqv_tbl.LAST);
2265: i := p_lsqv_tbl.NEXT(i);

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

2279: EXCEPTION
2280:
2281: WHEN OTHERS THEN
2282:
2283: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2284: p_msg_name => G_DB_ERROR,
2285: p_token1 => G_PROG_NAME_TOKEN,
2286: p_token1_value => l_prog_name,
2287: p_token2 => G_SQLCODE_TOKEN,