60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'VACANCY_ID')
67: );
68: --
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: --
457: hr_utility.set_location(' Leaving:'||l_proc,60);
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);
541: raise;
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
617: hr_utility.set_location(' Leaving:'||l_proc, 50);
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
735: hr_utility.set_location(' Leaving:'||l_proc, 60);
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);
818: raise;