203: hr_utility.set_location('Leaving:'|| l_proc, 1);
204:
205: EXCEPTION
206:
207: when app_exception.application_exception then
208: if hr_multi_message.exception_add
209: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_ID'
210: ) then
211: raise;
265: hr_utility.set_location('Leaving:'|| l_proc, 1);
266:
267: EXCEPTION
268:
269: when app_exception.application_exception then
270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_DATE'
272: ) then
273: raise;
364: hr_utility.set_location('Leaving:'|| l_proc, 1);
365:
366: EXCEPTION
367:
368: when app_exception.application_exception then
369: if hr_multi_message.exception_add
370: (p_associated_column1 => 'PER_ASSESSMENTS.PERSON_ID'
371: ) then
372: raise;
474: hr_utility.set_location('Leaving:'|| l_proc, 1);
475: --
476: EXCEPTION
477:
478: when app_exception.application_exception then
479: if hr_multi_message.exception_add
480: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSOR_PERSON_ID'
481: ) then
482: raise;
549: hr_utility.set_location('Leaving:'|| l_proc, 2);
550: --
551: EXCEPTION
552:
553: when app_exception.application_exception then
554: if hr_multi_message.exception_add
555: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
556: ,p_associated_column2 => 'PER_ASSESSMENTS.P_GROUP_DATE'
557: ) then
665: hr_utility.set_location('Leaving:'|| l_proc, 1);
666: --
667: EXCEPTION
668:
669: when app_exception.application_exception then
670: if hr_multi_message.exception_add
671: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
672: ) then
673: raise;
739: --
740: hr_utility.set_location('Leaving:'|| l_proc, 100);
741: EXCEPTION
742:
743: when app_exception.application_exception then
744: if hr_multi_message.exception_add
745: (p_associated_column1 => 'PER_ASSESSMENTS.STATUS'
746: ) then
747: raise;
826: --
827: end if;
828: EXCEPTION
829:
830: when app_exception.application_exception then
831: if hr_multi_message.exception_add
832: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_PERIOD_START_DATE'
833: ,p_associated_column2 => 'PER_ASSESSMENTS.ASSESSMENT_PERIOD_END_DATE'
834: ) then
921: --
922:
923: EXCEPTION
924:
925: when app_exception.application_exception then
926: if hr_multi_message.exception_add
927: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_TYPE_ID'
928: ,p_associated_column2 => 'PER_ASSESSMENTS.ASSESSMENT_DATE'
929: ,p_associated_column3 => 'PER_ASSESSMENTS.PERSON_ID'
1009: end if;
1010: --
1011: EXCEPTION
1012:
1013: when app_exception.application_exception then
1014: if hr_multi_message.exception_add
1015: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_GROUP_ID'
1016: ) then
1017: raise;
1093: --
1094: end if;
1095: EXCEPTION
1096:
1097: when app_exception.application_exception then
1098: if hr_multi_message.exception_add
1099: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_GROUP_ID'
1100: ) then
1101: raise;
1152: close csr_comp_elements_usage;
1153: --
1154: EXCEPTION
1155:
1156: when app_exception.application_exception then
1157: if hr_multi_message.exception_add
1158: (p_associated_column1 => 'PER_ASSESSMENTS.ASSESSMENT_ID'
1159: ) then
1160: raise;