DBA Data[Home] [Help]

APPS.HR_RU_ASSIGNMENT_API dependencies on HR_UTILITY

Line 221: hr_utility.set_location('Entering:'|| l_proc, 10);

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);

Line 236: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

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;

Line 237: hr_utility.set_message_token('LEG_CODE', 'RU');

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: --

Line 238: hr_utility.raise_error;

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: --

Line 414: hr_utility.set_location(' Leaving:'||l_proc, 30);

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: -- ----------------------------------------------------------------------------

Line 572: hr_utility.set_location('Entering:'|| l_proc, 10);

568: --
569:
570:
571: BEGIN
572: hr_utility.set_location('Entering:'|| l_proc, 10);
573:
574: --
575: -- Truncate DATE variables
576: --

Line 587: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

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);

Line 588: hr_utility.raise_error;

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: --

Line 591: hr_utility.set_location(l_proc, 20);

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

Line 596: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

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);

Line 597: hr_utility.set_message_token('LEG_CODE','RU');

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: --

Line 598: hr_utility.raise_error;

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: --

Line 600: hr_utility.set_location(l_proc, 30);

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: --

Line 743: hr_utility.set_location(' Leaving:'||l_proc, 40);

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;