[Home] [Help]
57: l_proc varchar2(72) := g_package||'set_security_group_id';
58: --
59: Begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
88: hr_api.set_security_group_id
89: (p_security_group_id => l_security_group_id
90: );
91: --
92: hr_utility.set_location(' Leaving:'|| l_proc, 20);
93: --
94: End set_security_group_id;
95: --
96: -- ---------------------------------------------------------------------------
131: l_proc varchar2(72) := g_package||'return_legislation_code';
132: --
133: Begin
134: --
135: hr_utility.set_location('Entering:'|| l_proc, 10);
136: --
137: -- Ensure that all the mandatory parameter are not null
138: --
139: hr_api.mandatory_arg_error
149: -- call to this function. Just return the value in the global
150: -- variable.
151: --
152: l_legislation_code := pay_aif_bus.g_legislation_code;
153: hr_utility.set_location(l_proc, 20);
154: else
155: --
156: -- The ID is different to the last call to this function
157: -- or this is the first call to this function.
166: close csr_leg_code;
167: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
168: fnd_message.raise_error;
169: end if;
170: hr_utility.set_location(l_proc,30);
171: --
172: -- Set the global variables so the values are
173: -- available for the next call to this function.
174: --
175: close csr_leg_code;
176: pay_aif_bus.g_action_information_id := p_action_information_id;
177: pay_aif_bus.g_legislation_code := l_legislation_code;
178: end if;
179: hr_utility.set_location(' Leaving:'|| l_proc, 40);
180: return l_legislation_code;
181: end return_legislation_code;
182: --
183: -- ---------------------------------------------------------------------------
214: l_proc varchar2(72) := g_package||'return_nonpk_leg_code';
215: --
216: Begin
217: --
218: hr_utility.set_location('Entering:'|| l_proc, 10);
219: --
220: -- Ensure that all the mandatory parameter are not null
221: --
222: hr_api.mandatory_arg_error
296: pay_aif_bus.g_nonpk_leg_code := l_legislation_code;
297: --
298: end if;
299: --
300: hr_utility.set_location(' Leaving:'|| l_proc, 20);
301: --
302: return l_legislation_code;
303: --
304: end return_nonpk_leg_code;
337: --
338: l_proc varchar2(72) := g_package || 'chk_ddf';
339: --
340: begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: if ((p_rec.action_information_id is not null) and (
344: nvl(pay_aif_shd.g_old_rec.action_information_id, hr_api.g_number) <>
345: nvl(p_rec.action_information_id, hr_api.g_number) or
482: ,p_attribute30_value => p_rec.action_information30
483: );
484: end if;
485: --
486: hr_utility.set_location(' Leaving:'||l_proc,20);
487: end chk_ddf;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |---------------------< chk_action_context_type >--------------------------|
518: l_proc varchar2(72) := g_package || 'chk_action_context_type';
519: --
520: Begin
521: --
522: hr_utility.set_location('Entering:'||l_proc,10);
523: --
524: if p_action_context_type not in ('PA','AAC','AAP','BEE') then
525: --
526: fnd_message.set_name('PAY','PAY_34986_INV_ACT_CONTEXT_TYPE');
527: fnd_message.raise_error;
528: --
529: end if;
530: --
531: hr_utility.set_location('Leaving:'||l_proc,20);
532: --
533: End chk_action_context_type;
534: --
535: -- ----------------------------------------------------------------------------
577: l_dummy varchar2(1);
578: --
579: Begin
580: --
581: hr_utility.set_location('Entering:'||l_proc,10);
582: --
583: if (p_action_context_type = 'PA') then
584: --
585: open csr_pact_exists;
612: fnd_message.raise_error;
613: --
614: end if;
615: --
616: hr_utility.set_location('Leaving:'||l_proc,20);
617: --
618: End chk_action_context_id;
619: --
620: -- ----------------------------------------------------------------------------
655: l_dummy varchar2(1);
656: --
657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc,10);
660: --
661: if (p_assignment_id is not null) then
662: --
663: open csr_asg_exists;
670: end if;
671: --
672: end if;
673: --
674: hr_utility.set_location('Leaving:'||l_proc,20);
675: --
676: End chk_assignment_id;
677: --
678: -- ----------------------------------------------------------------------------
844: l_proc varchar2(72) := g_package||'insert_validate';
845: --
846: Begin
847: --
848: hr_utility.set_location('Entering:'||l_proc, 5);
849: --
850: -- Call all supporting business operations
851: --
852: pay_aif_bus.chk_action_context_type(p_rec.action_context_type);
858: -- Removed call - assume trusted source (performance implications
859: -- in calling this for large volumes)
860: -- pay_aif_bus.chk_ddf(p_rec);
861: --
862: hr_utility.set_location(' Leaving:'||l_proc, 10);
863: --
864: End insert_validate;
865: --
866: -- ----------------------------------------------------------------------------
873: l_proc varchar2(72) := g_package||'update_validate';
874: --
875: Begin
876: --
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: chk_non_updateable_args(p_rec);
880: --
881: -- Removed call - assume trusted source (performance implications
881: -- Removed call - assume trusted source (performance implications
882: -- in calling this for large volumes)
883: -- pay_aif_bus.chk_ddf(p_rec);
884: --
885: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: --
887: End update_validate;
888: --
889: -- ----------------------------------------------------------------------------
895: --
896: l_proc varchar2(72) := g_package||'delete_validate';
897: --
898: Begin
899: hr_utility.set_location('Entering:'||l_proc, 5);
900: --
901: -- Call all supporting business operations
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 10);
899: hr_utility.set_location('Entering:'||l_proc, 5);
900: --
901: -- Call all supporting business operations
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 10);
904: End delete_validate;
905: --
906: end pay_aif_bus;