424: end if;
425: close csr_name;
426: hr_utility.set_location(' Leaving:'||l_proc,40);
427: exception
428: when app_exception.application_exception then
429: if hr_multi_message.exception_add
430: (p_associated_column1 => 'PER_REQUISITIONS.NAME'
431: ) then
432: hr_utility.set_location(' Leaving:'|| l_proc, 50);
590: end if;
591: end if;
592: hr_utility.set_location(' Leaving:'||l_proc,40);
593: exception
594: when app_exception.application_exception then
595: if hr_multi_message.exception_add
596: (p_associated_column1 => 'PER_REQUISITIONS.PERSON_ID'
597: ) then
598: hr_utility.set_location(' Leaving:'|| l_proc, 60);