DBA Data[Home] [Help]

APPS.HR_AE_ASSIGNMENT_API dependencies on HR_UTILITY

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

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

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

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;

Line 195: hr_utility.set_message_token('LEG_CODE', 'AE');

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

Line 196: hr_utility.raise_error;

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

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

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

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

438: --
439:
440:
441: BEGIN
442: hr_utility.set_location('Entering:'|| l_proc, 10);
443:
444: --
445: -- Truncate DATE variables
446: --

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

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

Line 458: hr_utility.raise_error;

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

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

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

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

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

Line 467: hr_utility.set_message_token('LEG_CODE','AE');

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

Line 468: hr_utility.raise_error;

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

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

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

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

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;