DBA Data[Home] [Help]

APPS.HR_DE_ASSIGNMENT_API dependencies on HR_UTILITY

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

203: and pbg.legislation_code = 'DE';
204: --
205: --
206: begin
207: hr_utility.set_location('Entering:'|| l_proc, 10);
208: --
209: -- Initialise local variable
210: --
211: l_effective_date := trunc(p_effective_date);

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

218: fetch csr_legislation
219: into l_legislation_code;
220: if csr_legislation%notfound then
221: close csr_legislation;
222: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
223: hr_utility.set_message_token('LEG_CODE', 'DE');
224: hr_utility.raise_error;
225: end if;
226: close csr_legislation;

Line 223: hr_utility.set_message_token('LEG_CODE', 'DE');

219: into l_legislation_code;
220: if csr_legislation%notfound then
221: close csr_legislation;
222: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
223: hr_utility.set_message_token('LEG_CODE', 'DE');
224: hr_utility.raise_error;
225: end if;
226: close csr_legislation;
227: --

Line 224: hr_utility.raise_error;

220: if csr_legislation%notfound then
221: close csr_legislation;
222: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
223: hr_utility.set_message_token('LEG_CODE', 'DE');
224: hr_utility.raise_error;
225: end if;
226: close csr_legislation;
227: --
228: hr_utility.set_location(l_proc, 20);

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

224: hr_utility.raise_error;
225: end if;
226: close csr_legislation;
227: --
228: hr_utility.set_location(l_proc, 20);
229: --
230: -- Call create_secondary_emp_asg
231: --
232: hr_assignment_api.create_secondary_emp_asg

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

398: ,p_group_name => p_group_name
399: ,p_other_manager_warning => p_other_manager_warning
400: );
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 30);
403: --
404: end create_de_secondary_emp_asg;
405: --
406: -- ----------------------------------------------------------------------------

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

554: and c_effective_date
555: between effective_start_date and effective_end_date;
556: --
557: begin
558: hr_utility.set_location('Entering:'|| l_proc, 10);
559: --
560: -- Truncate date variables
561: --
562: l_effective_date := trunc(p_effective_date);

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

568: open check_legislation(p_assignment_id, l_effective_date);
569: fetch check_legislation into l_legislation_code;
570: if check_legislation%notfound then
571: close check_legislation;
572: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
573: hr_utility.raise_error;
574: end if;
575: close check_legislation;
576: hr_utility.set_location(l_proc, 20);

Line 573: hr_utility.raise_error;

569: fetch check_legislation into l_legislation_code;
570: if check_legislation%notfound then
571: close check_legislation;
572: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
573: hr_utility.raise_error;
574: end if;
575: close check_legislation;
576: hr_utility.set_location(l_proc, 20);
577: --

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

572: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
573: hr_utility.raise_error;
574: end if;
575: close check_legislation;
576: hr_utility.set_location(l_proc, 20);
577: --
578: -- Check that the legislation of the specified business group is 'DE'.
579: --
580: if l_legislation_code <> 'DE' then

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

577: --
578: -- Check that the legislation of the specified business group is 'DE'.
579: --
580: if l_legislation_code <> 'DE' then
581: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
582: hr_utility.set_message_token('LEG_CODE','DE');
583: hr_utility.raise_error;
584: end if;
585: hr_utility.set_location(l_proc, 30);

Line 582: hr_utility.set_message_token('LEG_CODE','DE');

578: -- Check that the legislation of the specified business group is 'DE'.
579: --
580: if l_legislation_code <> 'DE' then
581: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
582: hr_utility.set_message_token('LEG_CODE','DE');
583: hr_utility.raise_error;
584: end if;
585: hr_utility.set_location(l_proc, 30);
586: --

Line 583: hr_utility.raise_error;

579: --
580: if l_legislation_code <> 'DE' then
581: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
582: hr_utility.set_message_token('LEG_CODE','DE');
583: hr_utility.raise_error;
584: end if;
585: hr_utility.set_location(l_proc, 30);
586: --
587: -- Call update_emp_asg business process

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

581: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
582: hr_utility.set_message_token('LEG_CODE','DE');
583: hr_utility.raise_error;
584: end if;
585: hr_utility.set_location(l_proc, 30);
586: --
587: -- Call update_emp_asg business process
588: --
589: hr_assignment_api.update_emp_asg

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

712: ,p_no_managers_warning => p_no_managers_warning
713: ,p_other_manager_warning => p_other_manager_warning
714: );
715: --
716: hr_utility.set_location(' Leaving:'||l_proc, 30);
717: --
718: end update_de_emp_asg;
719: --
720: end hr_de_assignment_api;