429: --
430: hr_utility.set_location(' Leaving:' || l_proc,10);
431:
432: Exception
433: when app_exception.application_exception then
434: IF hr_multi_message.exception_add
435: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
436: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
437: ) THEN
521: --
522: hr_utility.set_location(' Leaving:' || l_proc,10);
523:
524: Exception
525: when app_exception.application_exception then
526: IF hr_multi_message.exception_add
527: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
528: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
529: ) THEN
598: END IF;
599: hr_utility.set_location(' Leaving:' || l_proc,10);
600:
601: Exception
602: when app_exception.application_exception then
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
605: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
606: ) THEN