DBA Data[Home] [Help]

APPS.HR_FI_ASSIGNMENT_API dependencies on HR_UTILITY

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

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

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

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

Line 179: hr_utility.set_message_token('LEG_CODE', 'FI');

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

Line 180: hr_utility.raise_error;

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

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_fi_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 'FI'.
452: --
453: IF l_legislation_code <> 'FI' 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 'FI'.
452: --
453: IF l_legislation_code <> 'FI' THEN
454: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
455: hr_utility.set_message_token('LEG_CODE','FI');
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','FI');

451: -- Check that the legislation of the specified business group IS 'FI'.
452: --
453: IF l_legislation_code <> 'FI' THEN
454: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
455: hr_utility.set_message_token('LEG_CODE','FI');
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 <> 'FI' THEN
454: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
455: hr_utility.set_message_token('LEG_CODE','FI');
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','FI');
456: hr_utility.raise_error;
457: END IF;
458: hr_utility.set_location(l_proc, 30);
459: --
460:
461: --
462: -- Call update_emp_asg business process

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

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