169: AND pbg.legislation_code = 'AE';
170: --
171: --
172: BEGIN
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: -- Initialise local variable
176: --
177: l_effective_date := trunc(p_effective_date);
184: FETCH csr_legislation
185: INTO l_legislation_code;
186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;
185: INTO l_legislation_code;
186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;
193: --
186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;
193: --
194: --
314: ,p_group_name => p_group_name
315: ,p_other_manager_warning => p_other_manager_warning
316: );
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 30);
319: --
320: END create_ae_secondary_emp_asg;
321:
322: -- ----------------------------------------------------------------------------
424: --
425:
426:
427: BEGIN
428: hr_utility.set_location('Entering:'|| l_proc, 10);
429:
430: --
431: -- Truncate DATE variables
432: --
439: OPEN check_legislation(p_assignment_id, l_effective_date);
440: FETCH check_legislation into l_legislation_code;
441: IF check_legislation%notfound THEN
442: CLOSE check_legislation;
443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);
440: FETCH check_legislation into l_legislation_code;
441: IF check_legislation%notfound THEN
442: CLOSE check_legislation;
443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);
448: --
443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);
448: --
449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN
448: --
449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --
450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --
458: --
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --
458: --
459: -- Call update_emp_asg business process
460: --
535: ,p_other_manager_warning => p_other_manager_warning
536: );
537:
538:
539: hr_utility.set_location(' Leaving:'||l_proc, 40);
540: END update_ae_emp_asg;
541:
542:
543: END hr_ae_assignment_api;