DBA Data[Home] [Help]

APPS.HR_CA_ASSIGNMENT_API dependencies on HR_UTILITY

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

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

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

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

Line 203: hr_utility.set_message_token('LEG_CODE', 'CA');

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

Line 204: hr_utility.raise_error;

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

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

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

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

358: ,p_group_name => p_group_name
359: ,p_other_manager_warning => p_other_manager_warning
360: );
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 30);
363: --
364: end create_ca_secondary_emp_asg;
365: --
366: -- ----------------------------------------------------------------------------

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

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

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

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

Line 514: hr_utility.raise_error;

510: fetch check_legislation into l_legislation_code;
511: if check_legislation%notfound then
512: close check_legislation;
513: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
514: hr_utility.raise_error;
515: end if;
516: close check_legislation;
517: hr_utility.set_location(l_proc, 20);
518: --

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

513: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
514: hr_utility.raise_error;
515: end if;
516: close check_legislation;
517: hr_utility.set_location(l_proc, 20);
518: --
519: -- Check that the legislation of the specified business group is 'CA'.
520: --
521: if l_legislation_code <> 'CA' then

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

518: --
519: -- Check that the legislation of the specified business group is 'CA'.
520: --
521: if l_legislation_code <> 'CA' then
522: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
523: hr_utility.set_message_token('LEG_CODE','CA');
524: hr_utility.raise_error;
525: end if;
526: hr_utility.set_location(l_proc, 30);

Line 523: hr_utility.set_message_token('LEG_CODE','CA');

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

Line 524: hr_utility.raise_error;

520: --
521: if l_legislation_code <> 'CA' then
522: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
523: hr_utility.set_message_token('LEG_CODE','CA');
524: hr_utility.raise_error;
525: end if;
526: hr_utility.set_location(l_proc, 30);
527: --
528: -- Call update_emp_asg business process

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

522: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
523: hr_utility.set_message_token('LEG_CODE','CA');
524: hr_utility.raise_error;
525: end if;
526: hr_utility.set_location(l_proc, 30);
527: --
528: -- Call update_emp_asg business process
529: --
530: hr_assignment_api.update_emp_asg

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

633: ,p_no_managers_warning => p_no_managers_warning
634: ,p_other_manager_warning => p_other_manager_warning
635: );
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 30);
638: --
639: end update_ca_emp_asg;
640: --
641: end hr_ca_assignment_api;