[Home] [Help]
42: l_legislation_code varchar2(150);
43: --
44: begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
82: --
83: hr_api.set_legislation_context(l_legislation_code);
84: end if;
85: --
86: hr_utility.set_location(' Leaving:'|| l_proc, 20);
87: --
88: end set_security_group_id;
89: --
90: -- ---------------------------------------------------------------------------
114: l_proc varchar2(72) := g_package||'return_legislation_code';
115: --
116: Begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: -- Ensure that all the mandatory parameter are not null
121: --
122: hr_api.mandatory_arg_error
132: -- call to this function. Just return the value in the global
133: -- variable.
134: --
135: l_legislation_code := irc_iad_bus.g_legislation_code;
136: hr_utility.set_location(l_proc, 20);
137: else
138: --
139: -- The ID is different to the last call to this function
140: -- or this is the first call to this function.
149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are
156: -- available for the next call to this function.
157: --
158: close csr_leg_code;
159: irc_iad_bus.g_assignment_details_id := p_assignment_details_id;
160: irc_iad_bus.g_legislation_code := l_legislation_code;
161: end if;
162: hr_utility.set_location(' Leaving:'|| l_proc, 40);
163: return l_legislation_code;
164: end return_legislation_code;
165: --
166: -- ----------------------------------------------------------------------------
486: where attempt_id = p_attempt_id;
487: --
488: Begin
489: --
490: hr_utility.set_location('Entering:'|| l_proc, 10);
491: --
492: l_api_updating := irc_iad_shd.api_updating
493: (p_assignment_details_id => p_assignment_details_id
494: ,p_effective_date => p_effective_date
498: if ((l_api_updating and
499: nvl(irc_iad_shd.g_old_rec.attempt_id, hr_api.g_number) <>
500: nvl(p_attempt_id, hr_api.g_number)) or
501: (NOT l_api_updating)) then
502: hr_utility.set_location(l_proc, 20);
503: --
504: -- Check if attempt_id is not null
505: --
506: if p_attempt_id IS NOT NULL then
511: fetch attempt_exists into l_dummy;
512: --
513: if attempt_exists%notfound then
514: close attempt_exists;
515: hr_utility.set_location(l_proc, 30);
516: fnd_message.set_name('PER', 'IRC_412233_INV_OTA_ATTEMPT');
517: fnd_message.raise_error;
518: else
519: close attempt_exists;
525: fetch csr_assignment_type into l_assignment_type;
526: close csr_assignment_type;
527: --
528: if l_assignment_type in ('E','C','B','O') then
529: hr_utility.set_location(l_proc, 40);
530: --
531: -- Check if the assignment is being updated
532: --
533: if l_api_updating then
542: end if;
543: end if;
544: end if;
545: end if;
546: hr_utility.set_location('Leaving: '||l_proc, 50);
547: exception
548: when app_exception.application_exception then
549: if hr_multi_message.exception_add
550: (p_associated_column1 => 'IRC_ASSIGNMENT_DETAILS_F.ATTEMPT_ID'
565: --
566: l_proc varchar2(72) := g_package||'insert_validate';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS
581: ,p_effective_date => p_effective_date
582: ,p_object_version_number => p_rec.object_version_number
583: );
584: --
585: hr_utility.set_location(' Leaving:'||l_proc, 10);
586: End insert_validate;
587: --
588: -- ----------------------------------------------------------------------------
589: -- |---------------------------< update_validate >----------------------------|
598: --
599: l_proc varchar2(72) := g_package||'update_validate';
600: --
601: Begin
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: -- Call all supporting business operations
605: --
606: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS
615: ,p_validation_start_date => p_validation_start_date
616: ,p_validation_end_date => p_validation_end_date
617: );
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: --
621: chk_non_updateable_args
622: (p_effective_date => p_effective_date
623: ,p_rec => p_rec
622: (p_effective_date => p_effective_date
623: ,p_rec => p_rec
624: );
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 20);
627: --
628: chk_attempt_id
629: (p_attempt_id => p_rec.attempt_id
630: ,p_assignment_details_id => p_rec.assignment_details_id
632: ,p_effective_date => p_effective_date
633: ,p_object_version_number => p_rec.object_version_number
634: );
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 30);
637: End update_validate;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< delete_validate >----------------------------|
649: --
650: l_proc varchar2(72) := g_package||'delete_validate';
651: --
652: Begin
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: --
655: -- Call all supporting business operations
656: --
657: dt_delete_validate
660: ,p_validation_end_date => p_validation_end_date
661: ,p_assignment_details_id => p_rec.assignment_details_id
662: );
663: --
664: hr_utility.set_location(' Leaving:'||l_proc, 10);
665: End delete_validate;
666: --
667: end irc_iad_bus;