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

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

374: EXCEPTION
375:
376: WHEN OTHERS THEN
377:
378: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
379: p_msg_name => G_DB_ERROR,
380: p_token1 => G_PROG_NAME_TOKEN,
381: p_token1_value => l_prog_name,
382: p_token2 => G_SQLCODE_TOKEN,

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

394: ------------------------
395: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
396: BEGIN
397: IF p_id IS NULL THEN
398: OKL_API.set_message(p_app_name => G_APP_NAME,
399: p_msg_name => G_COL_ERROR,
400: p_token1 => G_COL_NAME_TOKEN,
401: p_token1_value => 'id',
402: p_token2 => G_PKG_NAME_TOKEN,

Line 404: RAISE OKL_API.G_EXCEPTION_ERROR;

400: p_token1 => G_COL_NAME_TOKEN,
401: p_token1_value => 'id',
402: p_token2 => G_PKG_NAME_TOKEN,
403: p_token2_value => G_PKG_NAME);
404: RAISE OKL_API.G_EXCEPTION_ERROR;
405: END IF;
406: x_return_status := G_RET_STS_SUCCESS;
407: END validate_id;
408:

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

412: -------------------------------------------
413: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
414: BEGIN
415: IF p_object_version_number 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 => 'object_version_number',
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 => 'object_version_number',
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_object_version_number;
426:

Line 434: x_return_status := OKL_API.G_RET_STS_SUCCESS;

430:
431: PROCEDURE validate_sts_code(x_return_status out NOCOPY varchar2,p_sts_code IN VARCHAR2) IS
432: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_sts_code';
433: BEGIN
434: x_return_status := OKL_API.G_RET_STS_SUCCESS;
435: -- Column is mandatory
436: IF (p_sts_code is null) THEN
437: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
438: p_msg_name => G_COL_ERROR,

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

433: BEGIN
434: x_return_status := OKL_API.G_RET_STS_SUCCESS;
435: -- Column is mandatory
436: IF (p_sts_code is null) THEN
437: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
438: p_msg_name => G_COL_ERROR,
439: p_token1 => g_col_name_token,
440: p_token1_value => 'sts_code',
441: p_token2 => G_PKG_NAME_TOKEN,

Line 444: RAISE OKL_API.G_EXCEPTION_ERROR;

440: p_token1_value => 'sts_code',
441: p_token2 => G_PKG_NAME_TOKEN,
442: p_token2_value => G_PKG_NAME);
443: -- notify caller of an error
444: RAISE OKL_API.G_EXCEPTION_ERROR;
445: END IF;
446: -- Lookup Code Validation
447: x_return_status := OKL_UTIL.check_lookup_code(
448: p_lookup_type => 'OKL_QQ_STATUS',

Line 451: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

447: x_return_status := OKL_UTIL.check_lookup_code(
448: p_lookup_type => 'OKL_QQ_STATUS',
449: p_lookup_code => p_sts_code);
450:
451: IF (x_return_status = OKL_API.G_RET_STS_ERROR) 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 => 'sts_code',

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

448: p_lookup_type => 'OKL_QQ_STATUS',
449: p_lookup_code => p_sts_code);
450:
451: IF (x_return_status = OKL_API.G_RET_STS_ERROR) 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 => 'sts_code',
456: p_token2 => G_PKG_NAME_TOKEN,

Line 459: raise OKL_API.G_EXCEPTION_ERROR;

455: p_token1_value => 'sts_code',
456: p_token2 => G_PKG_NAME_TOKEN,
457: p_token2_value => G_PKG_NAME);
458: -- notify caller of an error
459: raise OKL_API.G_EXCEPTION_ERROR;
460: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: -- notify caller of an error
462: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: END IF;

Line 460: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

456: p_token2 => G_PKG_NAME_TOKEN,
457: p_token2_value => G_PKG_NAME);
458: -- notify caller of an error
459: raise OKL_API.G_EXCEPTION_ERROR;
460: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: -- notify caller of an error
462: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: END IF;
464: EXCEPTION

Line 462: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

458: -- notify caller of an error
459: raise OKL_API.G_EXCEPTION_ERROR;
460: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: -- notify caller of an error
462: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: END IF;
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := G_RET_STS_ERROR;

Line 465: WHEN OKL_API.G_EXCEPTION_ERROR THEN

461: -- notify caller of an error
462: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: END IF;
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := G_RET_STS_ERROR;
467: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
468: x_return_status := G_RET_STS_UNEXP_ERROR;
469: WHEN OTHERS THEN

Line 467: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

463: END IF;
464: EXCEPTION
465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
466: x_return_status := G_RET_STS_ERROR;
467: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
468: x_return_status := G_RET_STS_UNEXP_ERROR;
469: WHEN OTHERS THEN
470: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
471: p_msg_name => G_DB_ERROR,

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

466: x_return_status := G_RET_STS_ERROR;
467: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
468: x_return_status := G_RET_STS_UNEXP_ERROR;
469: WHEN OTHERS THEN
470: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
471: p_msg_name => G_DB_ERROR,
472: p_token1 => G_PROG_NAME_TOKEN,
473: p_token1_value => l_api_name,
474: p_token2 => 'SQLCODE',

Line 491: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

487: WHERE reference_number = p_qqhv_rec_type.reference_number
488: AND id <> NVL(p_qqhv_rec_type.id, -9999);
489:
490: l_dummy_var VARCHAR2(1);
491: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
492: l_api_name CONSTANT VARCHAR2(61) := g_pkg_name || '.' || 'validate_header';
493: l_msg_count NUMBER;
494: l_msg_data VARCHAR2(2000);
495:

Line 508: okl_api.set_message(p_app_name => g_app_name

504: FETCH chk_uniquness INTO l_dummy_var;
505: CLOSE chk_uniquness; -- if l_dummy_var is 'x' then Ref Num already exists
506:
507: IF (l_dummy_var = 'x') THEN
508: okl_api.set_message(p_app_name => g_app_name
509: ,p_msg_name => 'OKL_DUPLICATE_CURE_REQUEST'
510: ,p_token1 => 'COL_NAME'
511: ,p_token1_value => p_qqhv_rec_type.reference_number);
512: RETURN okl_api.g_ret_sts_error;

Line 512: RETURN okl_api.g_ret_sts_error;

508: okl_api.set_message(p_app_name => g_app_name
509: ,p_msg_name => 'OKL_DUPLICATE_CURE_REQUEST'
510: ,p_token1 => 'COL_NAME'
511: ,p_token1_value => p_qqhv_rec_type.reference_number);
512: RETURN okl_api.g_ret_sts_error;
513: END IF;
514:
515: --get prefix
516: OPEN c_get_prefix;

Line 522: okl_api.set_message(p_app_name => g_app_name

518: CLOSE c_get_prefix;
519:
520: IF l_prefix IS NOT NULL THEN
521: IF INSTR(p_qqhv_rec_type.reference_number,l_prefix) <> 1 THEN
522: okl_api.set_message(p_app_name => g_app_name
523: ,p_msg_name => 'OKL_NO_PREFIX'
524: ,p_token1 => 'COL_NAME'
525: ,p_token1_value => p_qqhv_rec_type.reference_number
526: ,p_token2 => 'PREFIX'

Line 528: RETURN okl_api.g_ret_sts_error;

524: ,p_token1 => 'COL_NAME'
525: ,p_token1_value => p_qqhv_rec_type.reference_number
526: ,p_token2 => 'PREFIX'
527: ,p_token2_value => l_prefix);
528: RETURN okl_api.g_ret_sts_error;
529: END IF;
530: END IF;
531:
532: RETURN x_return_status;

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

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

Line 550: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

558: -----------------------------------------
559: PROCEDURE validate_expected_start_date (x_return_status OUT NOCOPY VARCHAR2, p_expected_start_date IN DATE) IS
560: BEGIN
561: IF p_expected_start_date IS NULL THEN
562: OKL_API.set_message(p_app_name => G_APP_NAME,
563: p_msg_name => G_COL_ERROR,
564: p_token1 => G_COL_NAME_TOKEN,
565: p_token1_value => 'expected_start_date',
566: p_token2 => G_PKG_NAME_TOKEN,

Line 568: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 586: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 604: RAISE OKL_API.G_EXCEPTION_ERROR;

600: p_token1 => G_COL_NAME_TOKEN,
601: p_token1_value => 'inv_org_id',
602: p_token2 => G_PKG_NAME_TOKEN,
603: p_token2_value => G_PKG_NAME);
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF;
606: x_return_status := G_RET_STS_SUCCESS;
607: END validate_inv_org_id;
608:

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

612: -----------------------------------------
613: PROCEDURE validate_currency_code (x_return_status OUT NOCOPY VARCHAR2, p_currency_code IN VARCHAR2) IS
614: BEGIN
615: IF p_currency_code IS NULL 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 => 'currency_code',
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 => 'currency_code',
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_currency_code;
626:

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

630: -----------------------------------------
631: PROCEDURE validate_term (x_return_status OUT NOCOPY VARCHAR2, p_term IN NUMBER) IS
632: BEGIN
633: IF p_term IS NULL THEN
634: OKL_API.set_message(p_app_name => G_APP_NAME,
635: p_msg_name => G_COL_ERROR,
636: p_token1 => G_COL_NAME_TOKEN,
637: p_token1_value => 'term',
638: p_token2 => G_PKG_NAME_TOKEN,

Line 640: RAISE OKL_API.G_EXCEPTION_ERROR;

636: p_token1 => G_COL_NAME_TOKEN,
637: p_token1_value => 'term',
638: p_token2 => G_PKG_NAME_TOKEN,
639: p_token2_value => G_PKG_NAME);
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642: x_return_status := G_RET_STS_SUCCESS;
643: END validate_term;
644:

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

648: -----------------------------------------
649: PROCEDURE validate_end_of_term_option_id (x_return_status OUT NOCOPY VARCHAR2, p_end_of_term_option_id IN NUMBER) IS
650: BEGIN
651: IF p_end_of_term_option_id IS NULL THEN
652: OKL_API.set_message(p_app_name => G_APP_NAME,
653: p_msg_name => G_COL_ERROR,
654: p_token1 => G_COL_NAME_TOKEN,
655: p_token1_value => 'end_of_term_option_id',
656: p_token2 => G_PKG_NAME_TOKEN,

Line 658: RAISE OKL_API.G_EXCEPTION_ERROR;

654: p_token1 => G_COL_NAME_TOKEN,
655: p_token1_value => 'end_of_term_option_id',
656: p_token2 => G_PKG_NAME_TOKEN,
657: p_token2_value => G_PKG_NAME);
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660: x_return_status := G_RET_STS_SUCCESS;
661: END validate_end_of_term_option_id;
662:

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

666: -----------------------------------------
667: PROCEDURE validate_pricing_method (x_return_status OUT NOCOPY VARCHAR2, p_pricing_method IN VARCHAR2) IS
668: BEGIN
669: IF p_pricing_method IS NULL THEN
670: OKL_API.set_message(p_app_name => G_APP_NAME,
671: p_msg_name => G_COL_ERROR,
672: p_token1 => G_COL_NAME_TOKEN,
673: p_token1_value => 'pricing_method',
674: p_token2 => G_PKG_NAME_TOKEN,

Line 676: RAISE OKL_API.G_EXCEPTION_ERROR;

672: p_token1 => G_COL_NAME_TOKEN,
673: p_token1_value => 'pricing_method',
674: p_token2 => G_PKG_NAME_TOKEN,
675: p_token2_value => G_PKG_NAME);
676: RAISE OKL_API.G_EXCEPTION_ERROR;
677: END IF;
678: x_return_status := G_RET_STS_SUCCESS;
679: END validate_pricing_method;
680:

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

928: EXCEPTION
929:
930: WHEN OTHERS THEN
931:
932: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
933: p_msg_name => G_DB_ERROR,
934: p_token1 => G_PROG_NAME_TOKEN,
935: p_token1_value => l_prog_name,
936: p_token2 => G_SQLCODE_TOKEN,

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

1003: EXCEPTION
1004:
1005: WHEN OTHERS THEN
1006:
1007: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1008: p_msg_name => G_DB_ERROR,
1009: p_token1 => G_PROG_NAME_TOKEN,
1010: p_token1_value => l_prog_name,
1011: p_token2 => G_SQLCODE_TOKEN,

Line 1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1046:
1047: l_return_status := validate_attributes(l_qqhv_rec);
1048:
1049: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054: --Bug 7022258-Added by kkorrapo

Line 1052: RAISE OKL_API.G_EXCEPTION_ERROR;

1048:
1049: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054: --Bug 7022258-Added by kkorrapo
1055: IF (okl_util.validate_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER',l_qqhv_rec.reference_number) = 'N') THEN
1056: RAISE okl_api.g_exception_error;

Line 1056: RAISE okl_api.g_exception_error;

1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054: --Bug 7022258-Added by kkorrapo
1055: IF (okl_util.validate_seq_num('OKL_QQH_REF_SEQ','OKL_QUICK_QUOTES_B','REFERENCE_NUMBER',l_qqhv_rec.reference_number) = 'N') THEN
1056: RAISE okl_api.g_exception_error;
1057: END IF;
1058: --Bug 7022258--Addition end
1059:
1060: l_return_status := validate_record(l_qqhv_rec);

Line 1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1059:
1060: l_return_status := validate_record(l_qqhv_rec);
1061:
1062: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067:

Line 1065: RAISE OKL_API.G_EXCEPTION_ERROR;

1061:
1062: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067:
1068: migrate (l_qqhv_rec, l_qqh_rec);
1069: migrate (l_qqhv_rec, l_qqhtl_rec);

Line 1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1070:
1071: insert_row (x_return_status => l_return_status, p_qqh_rec => l_qqh_rec);
1072:
1073: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1076: RAISE OKL_API.G_EXCEPTION_ERROR;
1077: END IF;
1078:

Line 1076: RAISE OKL_API.G_EXCEPTION_ERROR;

1072:
1073: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1076: RAISE OKL_API.G_EXCEPTION_ERROR;
1077: END IF;
1078:
1079: insert_row (x_return_status => l_return_status, p_qqhtl_rec => l_qqhtl_rec);
1080:

Line 1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1078:
1079: insert_row (x_return_status => l_return_status, p_qqhtl_rec => l_qqhtl_rec);
1080:
1081: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;
1086:

Line 1084: RAISE OKL_API.G_EXCEPTION_ERROR;

1080:
1081: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;
1086:
1087: x_qqhv_rec := l_qqhv_rec;
1088: x_return_status := l_return_status;

Line 1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1088: x_return_status := l_return_status;
1089:
1090: EXCEPTION
1091:
1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093:
1094: x_return_status := G_RET_STS_ERROR;
1095:
1096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1092: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1093:
1094: x_return_status := G_RET_STS_ERROR;
1095:
1096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1097:
1098: x_return_status := G_RET_STS_UNEXP_ERROR;
1099:
1100: WHEN OTHERS THEN

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

1098: x_return_status := G_RET_STS_UNEXP_ERROR;
1099:
1100: WHEN OTHERS THEN
1101:
1102: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1103: p_msg_name => G_DB_ERROR,
1104: p_token1 => G_PROG_NAME_TOKEN,
1105: p_token1_value => l_prog_name,
1106: p_token2 => G_SQLCODE_TOKEN,

Line 1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1141: p_qqhv_rec => p_qqhv_rec,
1142: x_qqhv_rec => x_qqhv_rec);
1143:
1144: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF l_return_status = G_RET_STS_ERROR THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149:

Line 1147: RAISE OKL_API.G_EXCEPTION_ERROR;

1143:
1144: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF l_return_status = G_RET_STS_ERROR THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149:
1150: x_return_status := l_return_status;
1151:

Line 1154: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1150: x_return_status := l_return_status;
1151:
1152: EXCEPTION
1153:
1154: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1155:
1156: x_return_status := G_RET_STS_ERROR;
1157:
1158: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1158: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1154: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1155:
1156: x_return_status := G_RET_STS_ERROR;
1157:
1158: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1159:
1160: x_return_status := G_RET_STS_UNEXP_ERROR;
1161:
1162: WHEN OTHERS THEN

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

1160: x_return_status := G_RET_STS_UNEXP_ERROR;
1161:
1162: WHEN OTHERS THEN
1163:
1164: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1165: p_msg_name => G_DB_ERROR,
1166: p_token1 => G_PROG_NAME_TOKEN,
1167: p_token1_value => l_prog_name,
1168: p_token2 => G_SQLCODE_TOKEN,

Line 1213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1209: p_qqhv_rec => p_qqhv_tbl(i),
1210: x_qqhv_rec => x_qqhv_tbl(i));
1211:
1212: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF l_return_status = G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: END IF;
1217:

Line 1215: RAISE OKL_API.G_EXCEPTION_ERROR;

1211:
1212: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF l_return_status = G_RET_STS_ERROR THEN
1215: RAISE OKL_API.G_EXCEPTION_ERROR;
1216: END IF;
1217:
1218: EXIT WHEN (i = p_qqhv_tbl.LAST);
1219: i := p_qqhv_tbl.NEXT(i);

Line 1235: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1231: x_return_status := l_return_status;
1232:
1233: EXCEPTION
1234:
1235: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1236:
1237: x_return_status := G_RET_STS_ERROR;
1238:
1239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1235: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1236:
1237: x_return_status := G_RET_STS_ERROR;
1238:
1239: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1240:
1241: x_return_status := G_RET_STS_UNEXP_ERROR;
1242:
1243: WHEN OTHERS THEN

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

1241: x_return_status := G_RET_STS_UNEXP_ERROR;
1242:
1243: WHEN OTHERS THEN
1244:
1245: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1246: p_msg_name => G_DB_ERROR,
1247: p_token1 => G_PROG_NAME_TOKEN,
1248: p_token1_value => l_prog_name,
1249: p_token2 => G_SQLCODE_TOKEN,

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

1296:
1297: IF (lock_csr%ISOPEN) THEN
1298: CLOSE lock_csr;
1299: END IF;
1300: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1301: p_msg_name => G_OVN_ERROR2,
1302: p_token1 => G_PROG_NAME_TOKEN,
1303: p_token1_value => l_prog_name);
1304: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1304: RAISE OKL_API.G_EXCEPTION_ERROR;

1300: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1301: p_msg_name => G_OVN_ERROR2,
1302: p_token1 => G_PROG_NAME_TOKEN,
1303: p_token1_value => l_prog_name);
1304: RAISE OKL_API.G_EXCEPTION_ERROR;
1305: END;
1306:
1307: IF l_object_version_number IS NULL THEN
1308:

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

1311: CLOSE lchk_csr;
1312:
1313: IF lc_object_version_number IS NULL THEN
1314:
1315: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1316: p_msg_name => G_OVN_ERROR3,
1317: p_token1 => G_PROG_NAME_TOKEN,
1318: p_token1_value => l_prog_name);
1319:

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

1318: p_token1_value => l_prog_name);
1319:
1320: ELSIF lc_object_version_number <> p_qqh_rec.object_version_number THEN
1321:
1322: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1323: p_msg_name => G_OVN_ERROR,
1324: p_token1 => G_PROG_NAME_TOKEN,
1325: p_token1_value => l_prog_name);
1326:

Line 1329: RAISE OKL_API.G_EXCEPTION_ERROR;

1325: p_token1_value => l_prog_name);
1326:
1327: END IF;
1328:
1329: RAISE OKL_API.G_EXCEPTION_ERROR;
1330:
1331: END IF;
1332:
1333: x_return_status := G_RET_STS_SUCCESS;

Line 1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1333: x_return_status := G_RET_STS_SUCCESS;
1334:
1335: EXCEPTION
1336:
1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1338:
1339: x_return_status := G_RET_STS_ERROR;
1340:
1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1337: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1338:
1339: x_return_status := G_RET_STS_ERROR;
1340:
1341: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1342:
1343: x_return_status := G_RET_STS_UNEXP_ERROR;
1344:
1345: WHEN OTHERS THEN

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

1343: x_return_status := G_RET_STS_UNEXP_ERROR;
1344:
1345: WHEN OTHERS THEN
1346:
1347: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1348: p_msg_name => G_DB_ERROR,
1349: p_token1 => G_PROG_NAME_TOKEN,
1350: p_token1_value => l_prog_name,
1351: p_token2 => G_SQLCODE_TOKEN,

Line 1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1373:
1374: lock_row (x_return_status => l_return_status, p_qqh_rec => p_qqh_rec);
1375:
1376: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF l_return_status = G_RET_STS_ERROR THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:

Line 1379: RAISE OKL_API.G_EXCEPTION_ERROR;

1375:
1376: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF l_return_status = G_RET_STS_ERROR THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:
1382: UPDATE okl_quick_quotes_b
1383: SET

Line 1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1438: x_return_status := l_return_status;
1439:
1440: EXCEPTION
1441:
1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1443: x_return_status := G_RET_STS_ERROR;
1444:
1445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1446: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1441:
1442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1443: x_return_status := G_RET_STS_ERROR;
1444:
1445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1446: x_return_status := G_RET_STS_UNEXP_ERROR;
1447:
1448: WHEN OTHERS THEN
1449: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1446: x_return_status := G_RET_STS_UNEXP_ERROR;
1447:
1448: WHEN OTHERS THEN
1449: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1450: p_msg_name => G_DB_ERROR,
1451: p_token1 => G_PROG_NAME_TOKEN,
1452: p_token1_value => l_prog_name,
1453: p_token2 => G_SQLCODE_TOKEN,

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

1493: EXCEPTION
1494:
1495: WHEN OTHERS THEN
1496:
1497: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1498: p_msg_name => G_DB_ERROR,
1499: p_token1 => G_PROG_NAME_TOKEN,
1500: p_token1_value => l_prog_name,
1501: p_token2 => G_SQLCODE_TOKEN,

Line 1544: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1540: x_qqhv_rec := p_qqhv_rec;
1541: l_db_qqhv_rec := get_rec (p_qqhv_rec.id, l_return_status);
1542:
1543: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1544: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF l_return_status = G_RET_STS_ERROR THEN
1546: RAISE OKL_API.G_EXCEPTION_ERROR;
1547: END IF;
1548:

Line 1546: RAISE OKL_API.G_EXCEPTION_ERROR;

1542:
1543: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1544: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF l_return_status = G_RET_STS_ERROR THEN
1546: RAISE OKL_API.G_EXCEPTION_ERROR;
1547: END IF;
1548:
1549: -- smadhava - Modified - G_MISS compliance - Start
1550: IF x_qqhv_rec.attribute_category IS NULL THEN

Line 1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1863: RETURN l_return_status;
1864:
1865: EXCEPTION
1866:
1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1868:
1869: x_return_status := G_RET_STS_ERROR;
1870:
1871: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1871: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1867: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1868:
1869: x_return_status := G_RET_STS_ERROR;
1870:
1871: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1872:
1873: x_return_status := G_RET_STS_UNEXP_ERROR;
1874:
1875: WHEN OTHERS THEN

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

1873: x_return_status := G_RET_STS_UNEXP_ERROR;
1874:
1875: WHEN OTHERS THEN
1876:
1877: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1878: p_msg_name => G_DB_ERROR,
1879: p_token1 => G_PROG_NAME_TOKEN,
1880: p_token1_value => l_prog_name,
1881: p_token2 => G_SQLCODE_TOKEN,

Line 1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1893:
1894: l_return_status := populate_new_record (p_qqhv_rec, l_qqhv_rec);
1895:
1896: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901:

Line 1899: RAISE OKL_API.G_EXCEPTION_ERROR;

1895:
1896: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901:
1902: l_return_status := validate_attributes (l_qqhv_rec);
1903:

Line 1905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1901:
1902: l_return_status := validate_attributes (l_qqhv_rec);
1903:
1904: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1906: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_ERROR;
1908: END IF;
1909:

Line 1907: RAISE OKL_API.G_EXCEPTION_ERROR;

1903:
1904: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1905: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1906: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_ERROR;
1908: END IF;
1909:
1910: l_return_status := validate_record (l_qqhv_rec);
1911:

Line 1913: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1909:
1910: l_return_status := validate_record (l_qqhv_rec);
1911:
1912: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1913: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1914: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1915: RAISE OKL_API.G_EXCEPTION_ERROR;
1916: END IF;
1917:

Line 1915: RAISE OKL_API.G_EXCEPTION_ERROR;

1911:
1912: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1913: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1914: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1915: RAISE OKL_API.G_EXCEPTION_ERROR;
1916: END IF;
1917:
1918: --Bug 7022258-Added by kkorrapo
1919: l_return_status := validate_unique (l_qqhv_rec);

Line 1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1918: --Bug 7022258-Added by kkorrapo
1919: l_return_status := validate_unique (l_qqhv_rec);
1920:
1921: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1924: RAISE OKL_API.G_EXCEPTION_ERROR;
1925: END IF;
1926: --Bug 7022258--Addition end

Line 1924: RAISE OKL_API.G_EXCEPTION_ERROR;

1920:
1921: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1923: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1924: RAISE OKL_API.G_EXCEPTION_ERROR;
1925: END IF;
1926: --Bug 7022258--Addition end
1927:
1928: migrate (l_qqhv_rec, l_qqh_rec);

Line 1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1930:
1931: update_row (x_return_status => l_return_status, p_qqh_rec => l_qqh_rec);
1932:
1933: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1935: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1936: RAISE OKL_API.G_EXCEPTION_ERROR;
1937: END IF;
1938:

Line 1936: RAISE OKL_API.G_EXCEPTION_ERROR;

1932:
1933: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1935: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1936: RAISE OKL_API.G_EXCEPTION_ERROR;
1937: END IF;
1938:
1939: update_row (x_return_status => l_return_status, p_qqhtl_rec => l_qqhtl_rec);
1940:

Line 1942: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1944: RAISE OKL_API.G_EXCEPTION_ERROR;

1940:
1941: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1942: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1943: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_ERROR;
1945: END IF;
1946:
1947: x_return_status := l_return_status;
1948: x_qqhv_rec := l_qqhv_rec;

Line 1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1948: x_qqhv_rec := l_qqhv_rec;
1949:
1950: EXCEPTION
1951:
1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1953:
1954: x_return_status := G_RET_STS_ERROR;
1955:
1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1953:
1954: x_return_status := G_RET_STS_ERROR;
1955:
1956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1957:
1958: x_return_status := G_RET_STS_UNEXP_ERROR;
1959:
1960: WHEN OTHERS THEN

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

1958: x_return_status := G_RET_STS_UNEXP_ERROR;
1959:
1960: WHEN OTHERS THEN
1961:
1962: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1963: p_msg_name => G_DB_ERROR,
1964: p_token1 => G_PROG_NAME_TOKEN,
1965: p_token1_value => l_prog_name,
1966: p_token2 => G_SQLCODE_TOKEN,

Line 2005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2001: p_qqhv_rec => p_qqhv_rec,
2002: x_qqhv_rec => x_qqhv_rec);
2003:
2004: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF l_return_status = G_RET_STS_ERROR THEN
2007: RAISE OKL_API.G_EXCEPTION_ERROR;
2008: END IF;
2009:

Line 2007: RAISE OKL_API.G_EXCEPTION_ERROR;

2003:
2004: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2005: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2006: ELSIF l_return_status = G_RET_STS_ERROR THEN
2007: RAISE OKL_API.G_EXCEPTION_ERROR;
2008: END IF;
2009:
2010: -- viselvar added
2011: x_qqhv_rec.object_version_number:=x_qqhv_rec.object_version_number+1;

Line 2016: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2012: x_return_status := l_return_status;
2013:
2014: EXCEPTION
2015:
2016: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2017:
2018: x_return_status := G_RET_STS_ERROR;
2019:
2020: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2020: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2016: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2017:
2018: x_return_status := G_RET_STS_ERROR;
2019:
2020: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2021:
2022: x_return_status := G_RET_STS_UNEXP_ERROR;
2023:
2024: WHEN OTHERS THEN

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

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

Line 2078: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2074: p_qqhv_rec => p_qqhv_tbl(i),
2075: x_qqhv_rec => x_qqhv_tbl(i));
2076:
2077: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2078: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2079: ELSIF l_return_status = G_RET_STS_ERROR THEN
2080: RAISE OKL_API.G_EXCEPTION_ERROR;
2081: END IF;
2082:

Line 2080: RAISE OKL_API.G_EXCEPTION_ERROR;

2076:
2077: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2078: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2079: ELSIF l_return_status = G_RET_STS_ERROR THEN
2080: RAISE OKL_API.G_EXCEPTION_ERROR;
2081: END IF;
2082:
2083: EXIT WHEN (i = p_qqhv_tbl.LAST);
2084: i := p_qqhv_tbl.NEXT(i);

Line 2100: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2096: x_return_status := l_return_status;
2097:
2098: EXCEPTION
2099:
2100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2101:
2102: x_return_status := G_RET_STS_ERROR;
2103:
2104: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2104: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2100: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2101:
2102: x_return_status := G_RET_STS_ERROR;
2103:
2104: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2105:
2106: x_return_status := G_RET_STS_UNEXP_ERROR;
2107:
2108: WHEN OTHERS THEN

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

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

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

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

Line 2187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2183: delete_row (x_return_status => l_return_status,
2184: p_id => p_qqhv_rec.id);
2185:
2186: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2188: ELSIF l_return_status = G_RET_STS_ERROR THEN
2189: RAISE OKL_API.G_EXCEPTION_ERROR;
2190: END IF;
2191:

Line 2189: RAISE OKL_API.G_EXCEPTION_ERROR;

2185:
2186: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2187: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2188: ELSIF l_return_status = G_RET_STS_ERROR THEN
2189: RAISE OKL_API.G_EXCEPTION_ERROR;
2190: END IF;
2191:
2192: x_return_status := l_return_status;
2193:

Line 2196: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2192: x_return_status := l_return_status;
2193:
2194: EXCEPTION
2195:
2196: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2197:
2198: x_return_status := G_RET_STS_ERROR;
2199:
2200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2196: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2197:
2198: x_return_status := G_RET_STS_ERROR;
2199:
2200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2201:
2202: x_return_status := G_RET_STS_UNEXP_ERROR;
2203:
2204: WHEN OTHERS THEN

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

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

Line 2256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2252: delete_row (x_return_status => l_return_status,
2253: p_id => p_qqhv_tbl(i).id);
2254:
2255: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2257: ELSIF l_return_status = G_RET_STS_ERROR THEN
2258: RAISE OKL_API.G_EXCEPTION_ERROR;
2259: END IF;
2260:

Line 2258: RAISE OKL_API.G_EXCEPTION_ERROR;

2254:
2255: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2257: ELSIF l_return_status = G_RET_STS_ERROR THEN
2258: RAISE OKL_API.G_EXCEPTION_ERROR;
2259: END IF;
2260:
2261: EXIT WHEN (i = p_qqhv_tbl.LAST);
2262: i := p_qqhv_tbl.NEXT(i);

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

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