227:
228: hr_utility.set_location('Leaving: '||l_proc,20);
229:
230: EXCEPTION
231: when app_exception.application_exception then
232: if hr_multi_message.exception_add
233: (p_associated_column1 => 'PER_APPRAISALS.OPEN'
234: ) then
235: raise;
578:
579: hr_utility.set_location('Leaving: '||l_proc,20);
580:
581: EXCEPTION
582: when app_exception.application_exception then
583: if hr_multi_message.exception_add
584: (p_associated_column1 => 'PER_APPRAISALS.APPRAISER_PERSON_ID'
585: ) then
586: raise;
716: hr_utility.set_location(l_proc, 4);
717:
718: hr_utility.set_location('Leaving: '|| l_proc, 10);
719: EXCEPTION
720: when app_exception.application_exception then
721: if hr_multi_message.exception_add
722: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_TEMPLATE_ID'
723: ) then
724: raise;
1017: -- bug 1980440 fix ends
1018: hr_utility.set_location('Leaving:'|| l_proc, 10);
1019:
1020: EXCEPTION
1021: when app_exception.application_exception then
1022: if hr_multi_message.exception_add
1023: (p_associated_column1 => 'PER_APPRAISALS.MAIN_APPRAISER_ID'
1024: ) then
1025: raise;
1114: end if;
1115: end if;
1116: hr_utility.set_location('Leaving: '|| l_proc, 10);
1117: EXCEPTION
1118: when app_exception.application_exception then
1119: if hr_multi_message.exception_add
1120: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_TYPE'
1121: ) then
1122: raise;
1214: end if;
1215: hr_utility.set_location('Leaving: '|| l_proc, 10);
1216:
1217: EXCEPTION
1218: when app_exception.application_exception then
1219: if hr_multi_message.exception_add
1220: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_STATUS'
1221: ) then
1222: raise;
1281: end if;
1282:
1283: hr_utility.set_location('Leaving:'|| l_proc, 2);
1284: EXCEPTION
1285: when app_exception.application_exception then
1286: if hr_multi_message.exception_add
1287: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_DATE'
1288: ) then
1289: raise;
1393:
1394: hr_utility.set_location('Leaving:'|| l_proc, 1);
1395:
1396: EXCEPTION
1397: when app_exception.application_exception then
1398: if hr_multi_message.exception_add
1399: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
1400: ) then
1401: raise;
1796: end if;
1797: hr_utility.set_location('Leaving: '|| l_proc, 10);
1798:
1799: EXCEPTION
1800: when app_exception.application_exception then
1801: if hr_multi_message.exception_add
1802: (p_associated_column1 => 'PER_APPRAISALS.OVERALL_PERFORMANCE_LEVEL_ID'
1803: ) then
1804: raise;
2074: hr_utility.set_location('Leaving:'|| l_proc, 970);
2075:
2076: EXCEPTION
2077:
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add
2080: (p_associated_column1 => 'PER_APPRAISALS.PLAN_ID')
2081: THEN
2082: hr_utility.set_location(' Leaving:'|| l_proc, 980);
2162:
2163: hr_utility.set_location('Leaving:'|| l_proc, 970);
2164: EXCEPTION
2165:
2166: WHEN app_exception.application_exception THEN
2167: IF hr_multi_message.exception_add
2168: (p_associated_column1 => 'PER_APPRAISALS.OFFLINE_STATUS')
2169: THEN
2170: hr_utility.set_location(' Leaving:'|| l_proc, 980);