DBA Data[Home] [Help]

APPS.HR_SE_ASSIGNMENT_API dependencies on HR_UTILITY

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

152: AND pbg.legislation_code = 'SE';
153: --
154: --
155: BEGIN
156: hr_utility.set_location('Entering:'|| l_proc, 10);
157: --
158: -- Initialise local variable
159: --
160: l_effective_date := trunc(p_effective_date);

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

167: FETCH csr_legislation
168: INTO l_legislation_code;
169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;

Line 172: hr_utility.set_message_token('LEG_CODE', 'SE');

168: INTO l_legislation_code;
169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;
176: --

Line 173: hr_utility.raise_error;

169: IF csr_legislation%notfound THEN
170: CLOSE csr_legislation;
171: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
172: hr_utility.set_message_token('LEG_CODE', 'SE');
173: hr_utility.raise_error;
174: END IF;
175: CLOSE csr_legislation;
176: --
177: --

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

296: ,p_group_name => p_group_name
297: ,p_other_manager_warning => p_other_manager_warning
298: );
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 30);
301: --
302: END create_se_secondary_emp_asg;
303:
304: -- ----------------------------------------------------------------------------

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

405: --
406:
407:
408: BEGIN
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410:
411: --
412: -- Truncate DATE variables
413: --

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

420: OPEN check_legislation(p_assignment_id, l_effective_date);
421: FETCH check_legislation into l_legislation_code;
422: IF check_legislation%notfound THEN
423: CLOSE check_legislation;
424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);

Line 425: hr_utility.raise_error;

421: FETCH check_legislation into l_legislation_code;
422: IF check_legislation%notfound THEN
423: CLOSE check_legislation;
424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);
429: --

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

424: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
425: hr_utility.raise_error;
426: END IF;
427: CLOSE check_legislation;
428: hr_utility.set_location(l_proc, 20);
429: --
430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN

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

429: --
430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);

Line 434: hr_utility.set_message_token('LEG_CODE','SE');

430: -- Check that the legislation of the specified business group IS 'SE.
431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --

Line 435: hr_utility.raise_error;

431: --
432: IF l_legislation_code <> 'SE' THEN
433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --
439:

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

433: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
434: hr_utility.set_message_token('LEG_CODE','SE');
435: hr_utility.raise_error;
436: END IF;
437: hr_utility.set_location(l_proc, 30);
438: --
439:
440: --
441: -- Call update_emp_asg business process

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

515: ,p_no_managers_warning => p_no_managers_warning
516: ,p_other_manager_warning => p_other_manager_warning
517: );
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: END update_se_emp_asg;
521:
522:
523: END hr_se_assignment_api;