DBA Data[Home] [Help]

APPS.HR_DK_ASSIGNMENT_API dependencies on HR_UTILITY

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

163: AND pbg.legislation_code = 'DK';
164: --
165: --
166: BEGIN
167: hr_utility.set_location('Entering:'|| l_proc, 10);
168: --
169: -- Initialise local variable
170: --
171: l_effective_date := trunc(p_effective_date);

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

178: FETCH csr_legislation
179: INTO l_legislation_code;
180: IF csr_legislation%notfound THEN
181: CLOSE csr_legislation;
182: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
183: hr_utility.set_message_token('LEG_CODE', 'DK');
184: hr_utility.raise_error;
185: END IF;
186: CLOSE csr_legislation;

Line 183: hr_utility.set_message_token('LEG_CODE', 'DK');

179: INTO l_legislation_code;
180: IF csr_legislation%notfound THEN
181: CLOSE csr_legislation;
182: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
183: hr_utility.set_message_token('LEG_CODE', 'DK');
184: hr_utility.raise_error;
185: END IF;
186: CLOSE csr_legislation;
187: --

Line 184: hr_utility.raise_error;

180: IF csr_legislation%notfound THEN
181: CLOSE csr_legislation;
182: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
183: hr_utility.set_message_token('LEG_CODE', 'DK');
184: hr_utility.raise_error;
185: END IF;
186: CLOSE csr_legislation;
187: --
188: --

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

319: ,p_group_name => p_group_name
320: ,p_other_manager_warning => p_other_manager_warning
321: );
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 30);
324: --
325: END create_dk_secondary_emp_asg;
326:
327: -- ----------------------------------------------------------------------------

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

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

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

455: OPEN check_legislation(p_assignment_id, l_effective_date);
456: FETCH check_legislation into l_legislation_code;
457: IF check_legislation%notfound THEN
458: CLOSE check_legislation;
459: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
460: hr_utility.raise_error;
461: END IF;
462: CLOSE check_legislation;
463: hr_utility.set_location(l_proc, 20);

Line 460: hr_utility.raise_error;

456: FETCH check_legislation into l_legislation_code;
457: IF check_legislation%notfound THEN
458: CLOSE check_legislation;
459: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
460: hr_utility.raise_error;
461: END IF;
462: CLOSE check_legislation;
463: hr_utility.set_location(l_proc, 20);
464: --

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

459: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
460: hr_utility.raise_error;
461: END IF;
462: CLOSE check_legislation;
463: hr_utility.set_location(l_proc, 20);
464: --
465: -- Check that the legislation of the specified business group IS 'DK'.
466: --
467: IF l_legislation_code <> 'DK' THEN

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

464: --
465: -- Check that the legislation of the specified business group IS 'DK'.
466: --
467: IF l_legislation_code <> 'DK' THEN
468: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
469: hr_utility.set_message_token('LEG_CODE','DK');
470: hr_utility.raise_error;
471: END IF;
472: hr_utility.set_location(l_proc, 30);

Line 469: hr_utility.set_message_token('LEG_CODE','DK');

465: -- Check that the legislation of the specified business group IS 'DK'.
466: --
467: IF l_legislation_code <> 'DK' THEN
468: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
469: hr_utility.set_message_token('LEG_CODE','DK');
470: hr_utility.raise_error;
471: END IF;
472: hr_utility.set_location(l_proc, 30);
473: --

Line 470: hr_utility.raise_error;

466: --
467: IF l_legislation_code <> 'DK' THEN
468: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
469: hr_utility.set_message_token('LEG_CODE','DK');
470: hr_utility.raise_error;
471: END IF;
472: hr_utility.set_location(l_proc, 30);
473: --
474: --

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

468: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
469: hr_utility.set_message_token('LEG_CODE','DK');
470: hr_utility.raise_error;
471: END IF;
472: hr_utility.set_location(l_proc, 30);
473: --
474: --
475: -- Call update_emp_asg business process
476: --

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

562: ,p_other_manager_warning => p_other_manager_warning
563: );
564:
565:
566: hr_utility.set_location(' Leaving:'||l_proc, 40);
567: END update_dk_emp_asg;
568:
569:
570: END hr_dk_assignment_api;