585: hr_utility.set_location('Entering: '||l_proc,10);
586: -- clear out table of combination records that were written.
587: l_wrote_cmbn.delete;
588: if p_effective_date is null then
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
590: fnd_message.set_token('PACKAGE',l_proc);
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
586: -- clear out table of combination records that were written.
587: l_wrote_cmbn.delete;
588: if p_effective_date is null then
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
590: fnd_message.set_token('PACKAGE',l_proc);
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
587: l_wrote_cmbn.delete;
588: if p_effective_date is null then
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
590: fnd_message.set_token('PACKAGE',l_proc);
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
588: if p_effective_date is null then
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
590: fnd_message.set_token('PACKAGE',l_proc);
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
589: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
590: fnd_message.set_token('PACKAGE',l_proc);
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
591: fnd_message.set_token('PROC','Flex Credit');
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
598: fnd_message.set_token('PARAM','p_person_id');
599: fnd_message.raise_error;
592: fnd_message.set_token('PARAM','p_effective_date');
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
598: fnd_message.set_token('PARAM','p_person_id');
599: fnd_message.raise_error;
600: end if;
593: fnd_message.raise_error;
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
598: fnd_message.set_token('PARAM','p_person_id');
599: fnd_message.raise_error;
600: end if;
601: ---------------------------------------------------------------------
594: elsif p_person_id is null then
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
598: fnd_message.set_token('PARAM','p_person_id');
599: fnd_message.raise_error;
600: end if;
601: ---------------------------------------------------------------------
602: -- Process Program Level Flex Credits
595: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
596: fnd_message.set_token('PACKAGE',l_proc);
597: fnd_message.set_token('PROC','Flex Credit');
598: fnd_message.set_token('PARAM','p_person_id');
599: fnd_message.raise_error;
600: end if;
601: ---------------------------------------------------------------------
602: -- Process Program Level Flex Credits
603: ---------------------------------------------------------------------