217: AND pbg.legislation_code = 'RU';
218: --
219: --
220: BEGIN
221: hr_utility.set_location('Entering:'|| l_proc, 10);
222: --
223: -- Initialise local variable
224: --
225: l_effective_date := trunc(p_effective_date);
232: FETCH csr_legislation
233: INTO l_legislation_code;
234: IF csr_legislation%notfound THEN
235: CLOSE csr_legislation;
236: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
237: hr_utility.set_message_token('LEG_CODE', 'RU');
238: hr_utility.raise_error;
239: END IF;
240: CLOSE csr_legislation;
233: INTO l_legislation_code;
234: IF csr_legislation%notfound THEN
235: CLOSE csr_legislation;
236: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
237: hr_utility.set_message_token('LEG_CODE', 'RU');
238: hr_utility.raise_error;
239: END IF;
240: CLOSE csr_legislation;
241: --
234: IF csr_legislation%notfound THEN
235: CLOSE csr_legislation;
236: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
237: hr_utility.set_message_token('LEG_CODE', 'RU');
238: hr_utility.raise_error;
239: END IF;
240: CLOSE csr_legislation;
241: --
242: --
410: ,p_hourly_salaried_warning => p_hourly_salaried_warning
411: ,p_gsp_post_process_warning => p_gsp_post_process_warning
412: );
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 30);
415: --
416: END create_ru_secondary_emp_asg;
417:
418: -- ----------------------------------------------------------------------------
568: --
569:
570:
571: BEGIN
572: hr_utility.set_location('Entering:'|| l_proc, 10);
573:
574: --
575: -- Truncate DATE variables
576: --
583: OPEN check_legislation(p_assignment_id, l_effective_date);
584: FETCH check_legislation into l_legislation_code;
585: IF check_legislation%notfound THEN
586: CLOSE check_legislation;
587: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
588: hr_utility.raise_error;
589: END IF;
590: CLOSE check_legislation;
591: hr_utility.set_location(l_proc, 20);
584: FETCH check_legislation into l_legislation_code;
585: IF check_legislation%notfound THEN
586: CLOSE check_legislation;
587: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
588: hr_utility.raise_error;
589: END IF;
590: CLOSE check_legislation;
591: hr_utility.set_location(l_proc, 20);
592: --
587: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
588: hr_utility.raise_error;
589: END IF;
590: CLOSE check_legislation;
591: hr_utility.set_location(l_proc, 20);
592: --
593: -- Check that the legislation of the specified business group IS 'RU'.
594: --
595: IF l_legislation_code <> 'RU' THEN
592: --
593: -- Check that the legislation of the specified business group IS 'RU'.
594: --
595: IF l_legislation_code <> 'RU' THEN
596: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
597: hr_utility.set_message_token('LEG_CODE','RU');
598: hr_utility.raise_error;
599: END IF;
600: hr_utility.set_location(l_proc, 30);
593: -- Check that the legislation of the specified business group IS 'RU'.
594: --
595: IF l_legislation_code <> 'RU' THEN
596: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
597: hr_utility.set_message_token('LEG_CODE','RU');
598: hr_utility.raise_error;
599: END IF;
600: hr_utility.set_location(l_proc, 30);
601: --
594: --
595: IF l_legislation_code <> 'RU' THEN
596: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
597: hr_utility.set_message_token('LEG_CODE','RU');
598: hr_utility.raise_error;
599: END IF;
600: hr_utility.set_location(l_proc, 30);
601: --
602: --
596: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
597: hr_utility.set_message_token('LEG_CODE','RU');
598: hr_utility.raise_error;
599: END IF;
600: hr_utility.set_location(l_proc, 30);
601: --
602: --
603: -- Call update_emp_asg business process
604: --
739:
740: );
741:
742:
743: hr_utility.set_location(' Leaving:'||l_proc, 40);
744: END update_ru_emp_asg;
745:
746:
747: END hr_ru_assignment_api;