175: AND pbg.legislation_code = 'AE';
176: --
177: --
178: BEGIN
179: hr_utility.set_location('Entering:'|| l_proc, 10);
180: --
181: -- Initialise local variable
182: --
183: l_effective_date := trunc(p_effective_date);
190: FETCH csr_legislation
191: INTO l_legislation_code;
192: IF csr_legislation%notfound THEN
193: CLOSE csr_legislation;
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE', 'AE');
196: hr_utility.raise_error;
197: END IF;
198: CLOSE csr_legislation;
191: INTO l_legislation_code;
192: IF csr_legislation%notfound THEN
193: CLOSE csr_legislation;
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE', 'AE');
196: hr_utility.raise_error;
197: END IF;
198: CLOSE csr_legislation;
199: --
192: IF csr_legislation%notfound THEN
193: CLOSE csr_legislation;
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE', 'AE');
196: hr_utility.raise_error;
197: END IF;
198: CLOSE csr_legislation;
199: --
200: --
324: ,p_group_name => p_group_name
325: ,p_other_manager_warning => p_other_manager_warning
326: );
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 30);
329: --
330: END create_ae_secondary_emp_asg;
331:
332: -- ----------------------------------------------------------------------------
438: --
439:
440:
441: BEGIN
442: hr_utility.set_location('Entering:'|| l_proc, 10);
443:
444: --
445: -- Truncate DATE variables
446: --
453: OPEN check_legislation(p_assignment_id, l_effective_date);
454: FETCH check_legislation into l_legislation_code;
455: IF check_legislation%notfound THEN
456: CLOSE check_legislation;
457: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
458: hr_utility.raise_error;
459: END IF;
460: CLOSE check_legislation;
461: hr_utility.set_location(l_proc, 20);
454: FETCH check_legislation into l_legislation_code;
455: IF check_legislation%notfound THEN
456: CLOSE check_legislation;
457: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
458: hr_utility.raise_error;
459: END IF;
460: CLOSE check_legislation;
461: hr_utility.set_location(l_proc, 20);
462: --
457: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
458: hr_utility.raise_error;
459: END IF;
460: CLOSE check_legislation;
461: hr_utility.set_location(l_proc, 20);
462: --
463: -- Check that the legislation of the specified business group IS 'AE'.
464: --
465: IF l_legislation_code <> 'AE' THEN
462: --
463: -- Check that the legislation of the specified business group IS 'AE'.
464: --
465: IF l_legislation_code <> 'AE' THEN
466: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
467: hr_utility.set_message_token('LEG_CODE','AE');
468: hr_utility.raise_error;
469: END IF;
470: hr_utility.set_location(l_proc, 30);
463: -- Check that the legislation of the specified business group IS 'AE'.
464: --
465: IF l_legislation_code <> 'AE' THEN
466: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
467: hr_utility.set_message_token('LEG_CODE','AE');
468: hr_utility.raise_error;
469: END IF;
470: hr_utility.set_location(l_proc, 30);
471: --
464: --
465: IF l_legislation_code <> 'AE' THEN
466: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
467: hr_utility.set_message_token('LEG_CODE','AE');
468: hr_utility.raise_error;
469: END IF;
470: hr_utility.set_location(l_proc, 30);
471: --
472: --
466: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
467: hr_utility.set_message_token('LEG_CODE','AE');
468: hr_utility.raise_error;
469: END IF;
470: hr_utility.set_location(l_proc, 30);
471: --
472: --
473: -- Call update_emp_asg business process
474: --
553: ,p_other_manager_warning => p_other_manager_warning
554: );
555:
556:
557: hr_utility.set_location(' Leaving:'||l_proc, 40);
558: END update_ae_emp_asg;
559:
560:
561: END hr_ae_assignment_api;