DBA Data[Home] [Help]

APPS.HR_AE_ASSIGNMENT_API dependencies on HR_UTILITY

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

169: AND pbg.legislation_code = 'AE';
170: --
171: --
172: BEGIN
173: hr_utility.set_location('Entering:'|| l_proc, 10);
174: --
175: -- Initialise local variable
176: --
177: l_effective_date := trunc(p_effective_date);

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

184: FETCH csr_legislation
185: INTO l_legislation_code;
186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;

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

185: INTO l_legislation_code;
186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;
193: --

Line 190: hr_utility.raise_error;

186: IF csr_legislation%notfound THEN
187: CLOSE csr_legislation;
188: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
189: hr_utility.set_message_token('LEG_CODE', 'AE');
190: hr_utility.raise_error;
191: END IF;
192: CLOSE csr_legislation;
193: --
194: --

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

314: ,p_group_name => p_group_name
315: ,p_other_manager_warning => p_other_manager_warning
316: );
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 30);
319: --
320: END create_ae_secondary_emp_asg;
321:
322: -- ----------------------------------------------------------------------------

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

424: --
425:
426:
427: BEGIN
428: hr_utility.set_location('Entering:'|| l_proc, 10);
429:
430: --
431: -- Truncate DATE variables
432: --

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

439: OPEN check_legislation(p_assignment_id, l_effective_date);
440: FETCH check_legislation into l_legislation_code;
441: IF check_legislation%notfound THEN
442: CLOSE check_legislation;
443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);

Line 444: hr_utility.raise_error;

440: FETCH check_legislation into l_legislation_code;
441: IF check_legislation%notfound THEN
442: CLOSE check_legislation;
443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);
448: --

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

443: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
444: hr_utility.raise_error;
445: END IF;
446: CLOSE check_legislation;
447: hr_utility.set_location(l_proc, 20);
448: --
449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN

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

448: --
449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);

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

449: -- Check that the legislation of the specified business group IS 'AE'.
450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --

Line 454: hr_utility.raise_error;

450: --
451: IF l_legislation_code <> 'AE' THEN
452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --
458: --

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

452: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
453: hr_utility.set_message_token('LEG_CODE','AE');
454: hr_utility.raise_error;
455: END IF;
456: hr_utility.set_location(l_proc, 30);
457: --
458: --
459: -- Call update_emp_asg business process
460: --

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

535: ,p_other_manager_warning => p_other_manager_warning
536: );
537:
538:
539: hr_utility.set_location(' Leaving:'||l_proc, 40);
540: END update_ae_emp_asg;
541:
542:
543: END hr_ae_assignment_api;