DBA Data[Home] [Help]

APPS.HR_NO_ASSIGNMENT_API dependencies on HR_UTILITY

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

160: AND pbg.legislation_code = 'NO';
161: --
162: --
163: BEGIN
164: hr_utility.set_location('Entering:'|| l_proc, 10);
165: --
166: -- Initialise local variable
167: --
168: l_effective_date := trunc(p_effective_date);

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

175: FETCH csr_legislation
176: INTO l_legislation_code;
177: IF csr_legislation%notfound THEN
178: CLOSE csr_legislation;
179: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
180: hr_utility.set_message_token('LEG_CODE', 'NO');
181: hr_utility.raise_error;
182: END IF;
183: CLOSE csr_legislation;

Line 180: hr_utility.set_message_token('LEG_CODE', 'NO');

176: INTO l_legislation_code;
177: IF csr_legislation%notfound THEN
178: CLOSE csr_legislation;
179: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
180: hr_utility.set_message_token('LEG_CODE', 'NO');
181: hr_utility.raise_error;
182: END IF;
183: CLOSE csr_legislation;
184: --

Line 181: hr_utility.raise_error;

177: IF csr_legislation%notfound THEN
178: CLOSE csr_legislation;
179: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
180: hr_utility.set_message_token('LEG_CODE', 'NO');
181: hr_utility.raise_error;
182: END IF;
183: CLOSE csr_legislation;
184: --
185: -- Call create_secondary_emp_asg

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

310: ,p_group_name => p_group_name
311: ,p_other_manager_warning => p_other_manager_warning
312: );
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 30);
315: --
316: END create_no_secondary_emp_asg;
317:
318: -- ----------------------------------------------------------------------------

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

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

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

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

Line 446: hr_utility.raise_error;

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

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

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

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

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

Line 455: hr_utility.set_message_token('LEG_CODE','NO');

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

Line 456: hr_utility.raise_error;

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

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

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

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

542: ,p_no_managers_warning => p_no_managers_warning
543: ,p_other_manager_warning => p_other_manager_warning
544: );
545:
546: hr_utility.set_location(' Leaving:'||l_proc, 40);
547: END update_no_emp_asg;
548:
549:
550: END hr_no_assignment_api;