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, 5);
118: --
119: -- Validation in addition to Row 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 'FR'.
132: --
133: -- Check that the legislation of the specified business group is 'FR'.
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 'FR'.
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, 6);
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, 6);
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, 6);
142: --
143: -- Call the person business process
144: --
145: hr_employee_api.create_employee
236: ,p_name_combination_warning => p_name_combination_warning
237: ,p_assign_payroll_warning => p_assign_payroll_warning
238: );
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 7);
241: --
242: end create_fr_employee;
243: --
244: end hr_fr_employee_api;