660: -- Edit to ensure that the input p_effective_date has a value
661: --
662: If p_effective_date is null then
663: --
664: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
665: fnd_message.set_token('PACKAGE',l_package);
666: fnd_message.set_token('PARAM','p_effective_date');
667: fnd_message.set_token('PROC','Certification requirement');
668: fnd_message.raise_error;
661: --
662: If p_effective_date is null then
663: --
664: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
665: fnd_message.set_token('PACKAGE',l_package);
666: fnd_message.set_token('PARAM','p_effective_date');
667: fnd_message.set_token('PROC','Certification requirement');
668: fnd_message.raise_error;
669: --
662: If p_effective_date is null then
663: --
664: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
665: fnd_message.set_token('PACKAGE',l_package);
666: fnd_message.set_token('PARAM','p_effective_date');
667: fnd_message.set_token('PROC','Certification requirement');
668: fnd_message.raise_error;
669: --
670: elsif p_person_id is null then
663: --
664: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
665: fnd_message.set_token('PACKAGE',l_package);
666: fnd_message.set_token('PARAM','p_effective_date');
667: fnd_message.set_token('PROC','Certification requirement');
668: fnd_message.raise_error;
669: --
670: elsif p_person_id is null then
671: --
664: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
665: fnd_message.set_token('PACKAGE',l_package);
666: fnd_message.set_token('PARAM','p_effective_date');
667: fnd_message.set_token('PROC','Certification requirement');
668: fnd_message.raise_error;
669: --
670: elsif p_person_id is null then
671: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
668: fnd_message.raise_error;
669: --
670: elsif p_person_id is null then
671: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
673: fnd_message.set_token('PACKAGE',l_package);
674: fnd_message.set_token('PARAM','p_person_id');
675: fnd_message.set_token('PROC','Certification requirement');
676: fnd_message.raise_error;
669: --
670: elsif p_person_id is null then
671: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
673: fnd_message.set_token('PACKAGE',l_package);
674: fnd_message.set_token('PARAM','p_person_id');
675: fnd_message.set_token('PROC','Certification requirement');
676: fnd_message.raise_error;
677: --
670: elsif p_person_id is null then
671: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
673: fnd_message.set_token('PACKAGE',l_package);
674: fnd_message.set_token('PARAM','p_person_id');
675: fnd_message.set_token('PROC','Certification requirement');
676: fnd_message.raise_error;
677: --
678: end if;
671: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
673: fnd_message.set_token('PACKAGE',l_package);
674: fnd_message.set_token('PARAM','p_person_id');
675: fnd_message.set_token('PROC','Certification requirement');
676: fnd_message.raise_error;
677: --
678: end if;
679: --
672: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
673: fnd_message.set_token('PACKAGE',l_package);
674: fnd_message.set_token('PARAM','p_person_id');
675: fnd_message.set_token('PROC','Certification requirement');
676: fnd_message.raise_error;
677: --
678: end if;
679: --
680: open c_asg;