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 'RO'.
146: --
147: -- Check that the legislation of the specified business group is 'RO'.
148: --
149: if l_legislation_code <> 'RO' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','RO');
152: hr_utility.raise_error;
153: end if;
154: -----------------------------------------------------------------
147: -- Check that the legislation of the specified business group is 'RO'.
148: --
149: if l_legislation_code <> 'RO' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','RO');
152: hr_utility.raise_error;
153: end if;
154: -----------------------------------------------------------------
155: hr_employee_api.create_employee
148: --
149: if l_legislation_code <> 'RO' then
150: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
151: hr_utility.set_message_token('LEG_CODE','RO');
152: hr_utility.raise_error;
153: end if;
154: -----------------------------------------------------------------
155: hr_employee_api.create_employee
156: (