DBA Data[Home] [Help]

APPS.HR_FR_ASSIGNMENT_API dependencies on HR_UTILITY

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

184: and pbg.legislation_code = 'FR';
185: --
186: --
187: begin
188: hr_utility.set_location('Entering:'|| l_proc, 10);
189: --
190: -- Initialise local variable
191: --
192: l_effective_date := trunc(p_effective_date);

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

199: fetch csr_legislation
200: into l_legislation_code;
201: if csr_legislation%notfound then
202: close csr_legislation;
203: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
204: hr_utility.set_message_token('LEG_CODE', 'FR');
205: hr_utility.raise_error;
206: end if;
207: close csr_legislation;

Line 204: hr_utility.set_message_token('LEG_CODE', 'FR');

200: into l_legislation_code;
201: if csr_legislation%notfound then
202: close csr_legislation;
203: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
204: hr_utility.set_message_token('LEG_CODE', 'FR');
205: hr_utility.raise_error;
206: end if;
207: close csr_legislation;
208: --

Line 205: hr_utility.raise_error;

201: if csr_legislation%notfound then
202: close csr_legislation;
203: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
204: hr_utility.set_message_token('LEG_CODE', 'FR');
205: hr_utility.raise_error;
206: end if;
207: close csr_legislation;
208: --
209: hr_utility.set_location(l_proc, 20);

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

205: hr_utility.raise_error;
206: end if;
207: close csr_legislation;
208: --
209: hr_utility.set_location(l_proc, 20);
210: --
211: -- Call create_secondary_emp_asg
212: --
213: hr_assignment_api.create_secondary_emp_asg

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_fr_secondary_emp_asg;
367: --
368: -- ----------------------------------------------------------------------------

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

499: and c_effective_date
500: between effective_start_date and effective_end_date;
501: --
502: begin
503: hr_utility.set_location('Entering:'|| l_proc, 10);
504: --
505: -- Truncate date variables
506: --
507: l_effective_date := trunc(p_effective_date);

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

513: open check_legislation(p_assignment_id, l_effective_date);
514: fetch check_legislation into l_legislation_code;
515: if check_legislation%notfound then
516: close check_legislation;
517: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
518: hr_utility.raise_error;
519: end if;
520: close check_legislation;
521: hr_utility.set_location(l_proc, 20);

Line 518: hr_utility.raise_error;

514: fetch check_legislation into l_legislation_code;
515: if check_legislation%notfound then
516: close check_legislation;
517: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
518: hr_utility.raise_error;
519: end if;
520: close check_legislation;
521: hr_utility.set_location(l_proc, 20);
522: --

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

517: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
518: hr_utility.raise_error;
519: end if;
520: close check_legislation;
521: hr_utility.set_location(l_proc, 20);
522: --
523: -- Check that the legislation of the specified business group is 'FR'.
524: --
525: if l_legislation_code <> 'FR' then

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

522: --
523: -- Check that the legislation of the specified business group is 'FR'.
524: --
525: if l_legislation_code <> 'FR' then
526: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
527: hr_utility.set_message_token('LEG_CODE','FR');
528: hr_utility.raise_error;
529: end if;
530: hr_utility.set_location(l_proc, 30);

Line 527: hr_utility.set_message_token('LEG_CODE','FR');

523: -- Check that the legislation of the specified business group is 'FR'.
524: --
525: if l_legislation_code <> 'FR' then
526: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
527: hr_utility.set_message_token('LEG_CODE','FR');
528: hr_utility.raise_error;
529: end if;
530: hr_utility.set_location(l_proc, 30);
531: --

Line 528: hr_utility.raise_error;

524: --
525: if l_legislation_code <> 'FR' then
526: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
527: hr_utility.set_message_token('LEG_CODE','FR');
528: hr_utility.raise_error;
529: end if;
530: hr_utility.set_location(l_proc, 30);
531: --
532: -- Check that valid value for parameters p_work_pattern_start_day and p_working_days_per_year.

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

526: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
527: hr_utility.set_message_token('LEG_CODE','FR');
528: hr_utility.raise_error;
529: end if;
530: hr_utility.set_location(l_proc, 30);
531: --
532: -- Check that valid value for parameters p_work_pattern_start_day and p_working_days_per_year.
533: --
534: if p_work_pattern_start_day = hr_api.g_number then

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

650: ,p_no_managers_warning => p_no_managers_warning
651: ,p_other_manager_warning => p_other_manager_warning
652: );
653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 30);
655: --
656: end update_fr_emp_asg;
657: --
658: end hr_fr_assignment_api;