[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') 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;
608: fnd_message.raise_error;
609: --
610: end if;
611: --
612: hr_utility.set_location('Leaving:'||l_proc,20);
613: --
614: End chk_action_context_id;
615: --
616: -- ----------------------------------------------------------------------------
651: l_dummy varchar2(1);
652: --
653: Begin
654: --
655: hr_utility.set_location('Entering:'||l_proc,10);
656: --
657: if (p_assignment_id is not null) then
658: --
659: open csr_asg_exists;
666: end if;
667: --
668: end if;
669: --
670: hr_utility.set_location('Leaving:'||l_proc,20);
671: --
672: End chk_assignment_id;
673: --
674: -- ----------------------------------------------------------------------------
840: l_proc varchar2(72) := g_package||'insert_validate';
841: --
842: Begin
843: --
844: hr_utility.set_location('Entering:'||l_proc, 5);
845: --
846: -- Call all supporting business operations
847: --
848: pay_aif_bus.chk_action_context_type(p_rec.action_context_type);
854: -- Removed call - assume trusted source (performance implications
855: -- in calling this for large volumes)
856: -- pay_aif_bus.chk_ddf(p_rec);
857: --
858: hr_utility.set_location(' Leaving:'||l_proc, 10);
859: --
860: End insert_validate;
861: --
862: -- ----------------------------------------------------------------------------
869: l_proc varchar2(72) := g_package||'update_validate';
870: --
871: Begin
872: --
873: hr_utility.set_location('Entering:'||l_proc, 5);
874: --
875: chk_non_updateable_args(p_rec);
876: --
877: -- Removed call - assume trusted source (performance implications
877: -- Removed call - assume trusted source (performance implications
878: -- in calling this for large volumes)
879: -- pay_aif_bus.chk_ddf(p_rec);
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 10);
882: --
883: End update_validate;
884: --
885: -- ----------------------------------------------------------------------------
891: --
892: l_proc varchar2(72) := g_package||'delete_validate';
893: --
894: Begin
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Call all supporting business operations
898: --
899: hr_utility.set_location(' Leaving:'||l_proc, 10);
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Call all supporting business operations
898: --
899: hr_utility.set_location(' Leaving:'||l_proc, 10);
900: End delete_validate;
901: --
902: end pay_aif_bus;