DBA Data[Home] [Help]

APPS.OTA_CCI_BUS dependencies on APP_EXCEPTION

Line 454: when app_exception.application_exception then

450: End IF;
451: --
452: hr_utility.set_location(' Leaving:' || l_proc,10);
453: Exception
454: when app_exception.application_exception then
455: IF hr_multi_message.exception_add
456: (p_associated_column1 => 'OTA_CERTIFICATIONS.START_DATE_ACTIVE'
457: ,p_associated_column2 => 'OTA_CERTIFICATIONS.END_DATE_ACTIVE'
458: ) THEN

Line 629: WHEN app_exception.application_exception THEN

625: --
626: hr_utility.set_location(' Leaving:'|| v_proc, 10);
627:
628: Exception
629: WHEN app_exception.application_exception THEN
630:
631: IF hr_multi_message.exception_add(
632: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
633:

Line 682: WHEN app_exception.application_exception THEN

678: close sel_primary_category;
679: --
680: hr_utility.set_location(' Leaving:'|| v_proc, 10);
681: Exception
682: WHEN app_exception.application_exception THEN
683:
684: IF hr_multi_message.exception_add(
685: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
686:

Line 722: WHEN app_exception.application_exception THEN

718: --
719: hr_utility.set_location(' Leaving:'|| v_proc, 10);
720:
721: Exception
722: WHEN app_exception.application_exception THEN
723:
724: IF hr_multi_message.exception_add(
725: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
726: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')

Line 779: WHEN app_exception.application_exception THEN

775: close sel_unique_key;
776: --
777: hr_utility.set_location(' Leaving:'|| v_proc, 10);
778: Exception
779: WHEN app_exception.application_exception THEN
780:
781: IF hr_multi_message.exception_add(
782: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.certification_id',
783: p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')

Line 837: WHEN app_exception.application_exception THEN

833: --
834: hr_utility.set_location(' Leaving:'|| v_proc, 10);
835:
836: Exception
837: WHEN app_exception.application_exception THEN
838:
839: IF hr_multi_message.exception_add(
840: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
841: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')