157: fetch csr_bg
158: into l_legislation_code;
159: if csr_bg%notfound then
160: close csr_bg;
161: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
162: hr_utility.raise_error;
163: end if;
164: close csr_bg;
165: --
158: into l_legislation_code;
159: if csr_bg%notfound then
160: close csr_bg;
161: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
162: hr_utility.raise_error;
163: end if;
164: close csr_bg;
165: --
166: -- Check that the legislation of the specified business group is 'RU'.
165: --
166: -- Check that the legislation of the specified business group is 'RU'.
167: --
168: if l_legislation_code <> 'RU' then
169: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
170: hr_utility.set_message_token('LEG_CODE','RU');
171: hr_utility.raise_error;
172: end if;
173:
166: -- Check that the legislation of the specified business group is 'RU'.
167: --
168: if l_legislation_code <> 'RU' then
169: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
170: hr_utility.set_message_token('LEG_CODE','RU');
171: hr_utility.raise_error;
172: end if;
173:
174:
167: --
168: if l_legislation_code <> 'RU' then
169: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
170: hr_utility.set_message_token('LEG_CODE','RU');
171: hr_utility.raise_error;
172: end if;
173:
174:
175: hr_employee_api.create_employee