[Home] [Help]
247: l_proc varchar2(72) := g_package||'set_security_group_id';
248: --
249: begin
250: --
251: hr_utility.set_location('Entering:'|| l_proc, 10);
252: --
253: -- Ensure that all the mandatory parameter are not null
254: --
255: hr_api.mandatory_arg_error
278: hr_api.set_security_group_id
279: (p_security_group_id => l_security_group_id
280: );
281: --
282: hr_utility.set_location(' Leaving:'|| l_proc, 20);
283: --
284: end set_security_group_id;
285: --
286: -- ---------------------------------------------------------------------------
309: l_proc varchar2(72) := g_package||'return_legislation_code';
310: --
311: Begin
312: --
313: hr_utility.set_location('Entering:'|| l_proc, 10);
314: --
315: -- Ensure that all the mandatory parameter are not null
316: --
317: hr_api.mandatory_arg_error
327: -- call to this function. Just return the value in the global
328: -- variable.
329: --
330: l_legislation_code := pay_isb_bus.g_legislation_code;
331: hr_utility.set_location(l_proc, 20);
332: else
333: --
334: -- The ID is different to the last call to this function
335: -- or this is the first call to this function.
344: close csr_leg_code;
345: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
346: fnd_message.raise_error;
347: end if;
348: hr_utility.set_location(l_proc,30);
349: --
350: -- Set the global variables so the values are
351: -- available for the next call to this function.
352: --
353: close csr_leg_code;
354: pay_isb_bus.g_social_benefit_id := p_social_benefit_id;
355: pay_isb_bus.g_legislation_code := l_legislation_code;
356: end if;
357: hr_utility.set_location(' Leaving:'|| l_proc, 40);
358: return l_legislation_code;
359: end return_legislation_code;
360: --
361: -- ----------------------------------------------------------------------------
640: --
641: l_proc varchar2(72) := g_package||'insert_validate';
642: --
643: Begin
644: hr_utility.set_location('Entering:'||l_proc, 5);
645: --Check the Absence Start Date is earlier than Abasence End Date
646: chk_valid_absence_dates( p_absence_start_date =>p_rec.absence_start_date,
647: p_absence_end_date =>p_rec.absence_end_date);
648:
667: --
668: chk_paye_details( p_effective_date => p_effective_date,
669: p_rec => p_rec);
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 10);
672: End insert_validate;
673: --
674: -- ----------------------------------------------------------------------------
675: -- |---------------------------< update_validate >----------------------------|
684: --
685: l_proc varchar2(72) := g_package||'update_validate';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: --Check the Absence Start Date is earlier than Abasence End Date
691: chk_valid_absence_dates(p_absence_start_date =>p_rec.absence_start_date,
692: p_absence_end_date =>p_rec.absence_end_date);
725: ,p_rec => p_rec
726: );
727: --
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 10);
730: End update_validate;
731: --
732: -- ----------------------------------------------------------------------------
733: -- |---------------------------< delete_validate >----------------------------|
742: --
743: l_proc varchar2(72) := g_package||'delete_validate';
744: --
745: Begin
746: hr_utility.set_location('Entering:'||l_proc, 5);
747: --
748: -- Call all supporting business operations
749: --
750: dt_delete_validate
753: ,p_validation_end_date => p_validation_end_date
754: ,p_social_benefit_id => p_rec.social_benefit_id
755: );
756: --
757: hr_utility.set_location(' Leaving:'||l_proc, 10);
758: End delete_validate;
759: --
760: end pay_isb_bus;