358: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
359:
360: EXCEPTION
361:
362: WHEN app_exception.application_exception THEN
363: IF hr_multi_message.exception_add
364: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.PLAN_ID')
365: THEN
366: hr_utility.set_location(' Leaving:'|| l_proc, 980);
433: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
434:
435: EXCEPTION
436:
437: WHEN app_exception.application_exception THEN
438: IF hr_multi_message.exception_add
439: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.APPRAISAL_TEMPLATE_ID')
440: THEN
441: hr_utility.set_location(' Leaving:'|| l_proc, 980);
586: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
587:
588: EXCEPTION
589:
590: WHEN app_exception.application_exception THEN
591: IF hr_multi_message.exception_add
592: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.START_DATE'
593: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.END_DATE')
594: THEN
688: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
689:
690: EXCEPTION
691:
692: WHEN app_exception.application_exception THEN
693: IF hr_multi_message.exception_add
694: (p_associated_column1 => 'PER_PERSONAL_SCORECARDS.PLAN_ID'
695: ,p_associated_column2 => 'PER_PERSONAL_SCORECARDS.APPRAISAL_TEMPLATE_ID'
696: ,p_associated_column3 => 'PER_PERSONAL_SCORECARDS.START_DATE'
783:
784: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
785:
786: exception
787: when app_exception.application_exception then
788: IF hr_multi_message.exception_add
789: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.INITIATOR_CODE'
790: ) THEN
791: hr_utility.set_location(' Leaving:'||l_proc, 980);
857: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
858:
859: EXCEPTION
860:
861: WHEN app_exception.application_exception THEN
862: IF hr_multi_message.exception_add
863: (p_associated_column1 => 'PER_APPRAISAL_PERIODS.TASK_START_DATE'
864: ,p_associated_column2 => 'PER_APPRAISAL_PERIODS.TASK_END_DATE')
865: THEN