448: --
449: hr_utility.set_location(' Leaving:'||l_proc,50);
450: --
451: exception
452: when app_exception.application_exception then
453: if hr_multi_message.exception_add
454: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
455: ) then
456: --
532: close csr_vacancy_id;
533: hr_utility.set_location(' Leaving:'||l_proc,35);
534: --
535: exception
536: when app_exception.application_exception then
537: if hr_multi_message.exception_add
538: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
539: ) then
540: hr_utility.set_location(' Leaving:'||l_proc, 40);
608: end if;
609: end if;
610: hr_utility.set_location(' Leaving:'||l_proc,45);
611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.START_DATE'
615: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.END_DATE'
616: ) then
726: --
727: hr_utility.set_location(' Leaving:'||l_proc,50);
728: --
729: exception
730: when app_exception.application_exception then
731: if hr_multi_message.exception_add
732: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.AGENCY_ID'
733: ,p_associated_column2 => 'IRC_AGENCY_VACANCIES.VACANCY_ID'
734: ) then
809: --
810: end if;
811: hr_utility.set_location(' Leaving:'||l_proc,45);
812: exception
813: when app_exception.application_exception then
814: if hr_multi_message.exception_add
815: (p_associated_column1 => 'IRC_AGENCY_VACANCIES.MANAGE_APPLICANTS_ALLOWED'
816: ) then
817: hr_utility.set_location(' Leaving:'||l_proc, 50);