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);
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;
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: --
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);
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
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: -- ----------------------------------------------------------------------------
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);
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);
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: --
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
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);
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: --
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
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
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;