113: from per_business_groups pbg
114: where pbg.business_group_id = p_business_group_id;
115: --
116: begin
117: hr_utility.set_location('Entering:'|| l_proc, 45);
118: --
119: -- Validation in addition to Table Handlers
120: --
121: -- Check that the specified business group is valid.
124: fetch csr_bg
125: into l_legislation_code;
126: if csr_bg%notfound then
127: close csr_bg;
128: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
129: hr_utility.raise_error;
130: end if;
131: close csr_bg;
132: --
125: into l_legislation_code;
126: if csr_bg%notfound then
127: close csr_bg;
128: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
129: hr_utility.raise_error;
130: end if;
131: close csr_bg;
132: --
133: -- Check that the legislation of the specified business group is 'GB'.
132: --
133: -- Check that the legislation of the specified business group is 'GB'.
134: --
135: if l_legislation_code <> 'FR' then
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE','FR');
138: hr_utility.raise_error;
139: end if;
140:
133: -- Check that the legislation of the specified business group is 'GB'.
134: --
135: if l_legislation_code <> 'FR' then
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE','FR');
138: hr_utility.raise_error;
139: end if;
140:
141: hr_utility.set_location(l_proc, 50);
134: --
135: if l_legislation_code <> 'FR' then
136: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
137: hr_utility.set_message_token('LEG_CODE','FR');
138: hr_utility.raise_error;
139: end if;
140:
141: hr_utility.set_location(l_proc, 50);
142: --
137: hr_utility.set_message_token('LEG_CODE','FR');
138: hr_utility.raise_error;
139: end if;
140:
141: hr_utility.set_location(l_proc, 50);
142: --
143: -- Call the person business process
144: --
145: hr_applicant_api.create_applicant
236: ,p_name_combination_warning => p_name_combination_warning
237: ,p_orig_hire_warning => l_orig_hire_warning
238: );
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 55);
241: end create_fr_applicant;
242: --
243: end hr_fr_applicant_api;