152: AND pbg.legislation_code = 'SE';
153: --
154: --
155: BEGIN
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: --
158: -- Initialise local variable
159: --
160: l_effective_date := trunc(p_effective_date);
167: FETCH csr_legislation
168: INTO l_legislation_code;
169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;
168: INTO l_legislation_code;
169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;
176: --
169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;
176: --
177: --
296: ,p_group_name => p_group_name
297: ,p_other_manager_warning => p_other_manager_warning
298: );
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 30);
301: --
302: END create_se_secondary_emp_asg;
303:
304: -- ----------------------------------------------------------------------------
405: --
406:
407:
408: BEGIN
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410:
411: --
412: -- Truncate DATE variables
413: --
420: OPEN check_legislation(p_assignment_id, l_effective_date);
421: FETCH check_legislation into l_legislation_code;
422: IF check_legislation%notfound THEN
423: CLOSE check_legislation;
424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);
421: FETCH check_legislation into l_legislation_code;
422: IF check_legislation%notfound THEN
423: CLOSE check_legislation;
424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);
429: --
424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);
429: --
430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN
429: --
430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --
431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --
439:
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --
439:
440: --
441: -- Call update_emp_asg business process
515: ,p_no_managers_warning => p_no_managers_warning
516: ,p_other_manager_warning => p_other_manager_warning
517: );
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: END update_se_emp_asg;
521:
522:
523: END hr_se_assignment_api;