DBA Data[Home] [Help]

APPS.HR_AU_ASSIGNMENT_API dependencies on HR_UTILITY

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

193: AND pbg.legislation_code = 'AU';
194: --
195: --
196: BEGIN
197: hr_utility.set_location('Entering:'|| l_proc, 10);
198: --
199: -- Initialise local variable
200: --
201: l_effective_date := trunc(p_effective_date);

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

208: FETCH csr_legislation
209: INTO l_legislation_code;
210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;

Line 213: hr_utility.set_message_token('LEG_CODE', 'AU');

209: INTO l_legislation_code;
210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;
217: --

Line 214: hr_utility.raise_error;

210: IF csr_legislation%notfound THEN
211: CLOSE csr_legislation;
212: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
213: hr_utility.set_message_token('LEG_CODE', 'AU');
214: hr_utility.raise_error;
215: END IF;
216: CLOSE csr_legislation;
217: --
218: --

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

360: ,p_group_name => p_group_name
361: ,p_other_manager_warning => p_other_manager_warning
362: );
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 30);
365: --
366: END create_au_secondary_emp_asg;
367:
368: -- ----------------------------------------------------------------------------

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

493: --
494:
495:
496: BEGIN
497: hr_utility.set_location('Entering:'|| l_proc, 10);
498:
499: --
500: -- Truncate DATE variables
501: --

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

508: OPEN check_legislation(p_assignment_id, l_effective_date);
509: FETCH check_legislation into l_legislation_code;
510: IF check_legislation%notfound THEN
511: CLOSE check_legislation;
512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);

Line 513: hr_utility.raise_error;

509: FETCH check_legislation into l_legislation_code;
510: IF check_legislation%notfound THEN
511: CLOSE check_legislation;
512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);
517: --

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

512: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
513: hr_utility.raise_error;
514: END IF;
515: CLOSE check_legislation;
516: hr_utility.set_location(l_proc, 20);
517: --
518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN

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

517: --
518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);

Line 522: hr_utility.set_message_token('LEG_CODE','AU');

518: -- Check that the legislation of the specified business group IS 'AU'.
519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --

Line 523: hr_utility.raise_error;

519: --
520: IF l_legislation_code <> 'AU' THEN
521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --
527: --

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

521: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
522: hr_utility.set_message_token('LEG_CODE','AU');
523: hr_utility.raise_error;
524: END IF;
525: hr_utility.set_location(l_proc, 30);
526: --
527: --
528: -- Call update_emp_asg business process
529: --

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

627: ,p_other_manager_warning => p_other_manager_warning
628: );
629:
630:
631: hr_utility.set_location(' Leaving:'||l_proc, 40);
632: END update_au_emp_asg;
633:
634:
635: END hr_au_assignment_api;