289: end if;
290: --
291: hr_utility.set_location(' Leaving:'|| l_proc, 15);
292: exception
293: when app_exception.application_exception then
294: if hr_multi_message.exception_add
295: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.MANDATORY'
296: ) then
297: hr_utility.set_location(' Leaving:'||l_proc,20);
393: end if;
394: --
395: hr_utility.set_location(' Leaving:'|| l_proc, 15);
396: exception
397: when app_exception.application_exception then
398: if hr_multi_message.exception_add
399: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
400: ) then
401: hr_utility.set_location(' Leaving:'||l_proc,20);
512: hr_utility.set_location('Leaving: '||l_proc,15);
513: end if;
514: end if;
515: exception
516: when app_exception.application_exception then
517: if hr_multi_message.exception_add
518: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_METHOD'
519: ,p_associated_column2 => 'PER_COMPETENCE_ELEMENTS.CERTIFICATION_DATE'
520: ) then
627: end if; -- end for if checking for no_exclusive_error for CERTIFICATION_DATE
628: --
629: hr_utility.set_location('Leaving:'||l_proc,15);
630: exception
631: when app_exception.application_exception then
632: if hr_multi_message.exception_add
633: (p_associated_column1 =>
634: 'PER_COMPETENCE_ELEMENTS.NEXT_CERTIFICATION_DATE'
635: ,p_associated_column2 =>
735: end if;
736: --
737: hr_utility.set_location(' Leaving:'|| l_proc, 15);
738: exception
739: when app_exception.application_exception then
740: if hr_multi_message.exception_add
741: (p_associated_column1 =>
742: 'PER_COMPETENCE_ELEMENTS.COMPETENCE_TYPE'
743: ) then
845: end if;
846: --
847: hr_utility.set_location(' Leaving:'|| l_proc, 15);
848: exception
849: when app_exception.application_exception then
850: if hr_multi_message.exception_add
851: (p_associated_column1 =>
852: 'PER_COMPETENCE_ELEMENTS.SOURCE_OF_PROFICIENCY_LEVEL'
853: ) then
954: end if;
955: --
956: hr_utility.set_location(' Leaving:'|| l_proc, 15);
957: exception
958: when app_exception.application_exception then
959: if hr_multi_message.exception_add
960: (p_associated_column1 =>
961: 'PER_COMPETENCE_ELEMENTS.TYPE'
962: ) then
3991: hr_utility.set_location('Leaving: ' || l_proc, 110);
3992: end if;
3993: end if; -- check for no_exclusive_error for TYPE.
3994: exception
3995: when app_exception.application_exception then
3996: if hr_multi_message.exception_add
3997: (p_associated_column1 => 'PER_COMPETENCE_ELEMENTS.TYPE'
3998: ) then
3999: hr_utility.set_location(' Leaving:'||l_proc,110);
4331: --
4332: end if; -- no_exclusive_check for TYPE
4333: hr_utility.set_location('Leaving: ' || l_proc, 10);
4334: exception
4335: when app_exception.application_exception then
4336: hr_multi_message.add;
4337: hr_utility.set_location(' Leaving:'||l_proc,105);
4338: end chk_unique_competence_element;
4339: /*