127: from per_business_groups pbg
128: where pbg.business_group_id = p_business_group_id;
129: --
130: begin
131: hr_utility.set_location('Entering:'|| l_proc, 45);
132: --
133: -- Validation in addition to Table Handlers
134: --
135: -- Check that the specified business group is valid.
138: fetch csr_bg
139: into l_legislation_code;
140: if csr_bg%notfound then
141: close csr_bg;
142: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
143: hr_utility.raise_error;
144: end if;
145: close csr_bg;
146: --
139: into l_legislation_code;
140: if csr_bg%notfound then
141: close csr_bg;
142: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
143: hr_utility.raise_error;
144: end if;
145: close csr_bg;
146: --
147: -- Check that the legislation of the specified business group is 'CA'.
146: --
147: -- Check that the legislation of the specified business group is 'CA'.
148: --
149: if l_legislation_code <> 'CA' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','CA');
152: hr_utility.raise_error;
153: end if;
154:
147: -- Check that the legislation of the specified business group is 'CA'.
148: --
149: if l_legislation_code <> 'CA' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','CA');
152: hr_utility.raise_error;
153: end if;
154:
155: hr_utility.set_location(l_proc, 50);
148: --
149: if l_legislation_code <> 'CA' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','CA');
152: hr_utility.raise_error;
153: end if;
154:
155: hr_utility.set_location(l_proc, 50);
156: --
151: hr_utility.set_message_token('LEG_CODE','CA');
152: hr_utility.raise_error;
153: end if;
154:
155: hr_utility.set_location(l_proc, 50);
156: --
157: -- Call the person business process
158: --
159: hr_applicant_api.create_applicant
263: ,p_name_combination_warning => p_name_combination_warning
264: ,p_orig_hire_warning => l_orig_hire_warning
265: );
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 55);
268: end create_ca_applicant;
269: --
270: end hr_ca_applicant_api;