147: from per_business_groups pbg
148: where pbg.business_group_id = p_business_group_id;
149: --
150: begin
151: hr_utility.set_location('Entering:'|| l_proc, 5);
152: --
153: -- Validation in addition to Row Handlers
154: --
155: -- Check that the specified business group is valid.
158: fetch csr_bg
159: into l_legislation_code;
160: if csr_bg%notfound then
161: close csr_bg;
162: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
163: hr_utility.raise_error;
164: end if;
165: close csr_bg;
166: --
159: into l_legislation_code;
160: if csr_bg%notfound then
161: close csr_bg;
162: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
163: hr_utility.raise_error;
164: end if;
165: close csr_bg;
166: --
167: -- Check that the legislation of the specified business group is 'NL'.
166: --
167: -- Check that the legislation of the specified business group is 'NL'.
168: --
169: if l_legislation_code <> 'NL' then
170: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
171: hr_utility.set_message_token('LEG_CODE','NL');
172: hr_utility.raise_error;
173: end if;
174:
167: -- Check that the legislation of the specified business group is 'NL'.
168: --
169: if l_legislation_code <> 'NL' then
170: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
171: hr_utility.set_message_token('LEG_CODE','NL');
172: hr_utility.raise_error;
173: end if;
174:
175:
168: --
169: if l_legislation_code <> 'NL' then
170: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
171: hr_utility.set_message_token('LEG_CODE','NL');
172: hr_utility.raise_error;
173: end if;
174:
175:
176: hr_utility.set_location(l_proc, 6);
172: hr_utility.raise_error;
173: end if;
174:
175:
176: hr_utility.set_location(l_proc, 6);
177:
178:
179: --
180: -- Call the person business process