193: AND pbg.legislation_code = 'AU';
194: --
195: --
196: BEGIN
197: hr_utility.set_location('Entering:'|| l_proc, 10);
198: --
199: -- Initialise local variable
200: --
201: l_effective_date := trunc(p_effective_date);
208: FETCH csr_legislation
209: INTO l_legislation_code;
210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;
209: INTO l_legislation_code;
210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;
217: --
210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;
217: --
218: --
360: ,p_group_name => p_group_name
361: ,p_other_manager_warning => p_other_manager_warning
362: );
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 30);
365: --
366: END create_au_secondary_emp_asg;
367:
368: -- ----------------------------------------------------------------------------
493: --
494:
495:
496: BEGIN
497: hr_utility.set_location('Entering:'|| l_proc, 10);
498:
499: --
500: -- Truncate DATE variables
501: --
508: OPEN check_legislation(p_assignment_id, l_effective_date);
509: FETCH check_legislation into l_legislation_code;
510: IF check_legislation%notfound THEN
511: CLOSE check_legislation;
512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);
509: FETCH check_legislation into l_legislation_code;
510: IF check_legislation%notfound THEN
511: CLOSE check_legislation;
512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);
517: --
512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);
517: --
518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN
517: --
518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --
519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --
527: --
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --
527: --
528: -- Call update_emp_asg business process
529: --
627: ,p_other_manager_warning => p_other_manager_warning
628: );
629:
630:
631: hr_utility.set_location(' Leaving:'||l_proc, 40);
632: END update_au_emp_asg;
633:
634:
635: END hr_au_assignment_api;