664: end if;
665: --
666: if p_actn_typ_id is null then
667: --
668: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
669: fnd_message.set_token('PACKAGE',l_proc);
670: fnd_message.set_token('PROC','Enrollment Action Items');
671: fnd_message.set_token('PARAM','p_actn_typ_id');
672: fnd_message.raise_error;
665: --
666: if p_actn_typ_id is null then
667: --
668: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
669: fnd_message.set_token('PACKAGE',l_proc);
670: fnd_message.set_token('PROC','Enrollment Action Items');
671: fnd_message.set_token('PARAM','p_actn_typ_id');
672: fnd_message.raise_error;
673: --
666: if p_actn_typ_id is null then
667: --
668: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
669: fnd_message.set_token('PACKAGE',l_proc);
670: fnd_message.set_token('PROC','Enrollment Action Items');
671: fnd_message.set_token('PARAM','p_actn_typ_id');
672: fnd_message.raise_error;
673: --
674: end if;
667: --
668: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
669: fnd_message.set_token('PACKAGE',l_proc);
670: fnd_message.set_token('PROC','Enrollment Action Items');
671: fnd_message.set_token('PARAM','p_actn_typ_id');
672: fnd_message.raise_error;
673: --
674: end if;
675: --
668: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
669: fnd_message.set_token('PACKAGE',l_proc);
670: fnd_message.set_token('PROC','Enrollment Action Items');
671: fnd_message.set_token('PARAM','p_actn_typ_id');
672: fnd_message.raise_error;
673: --
674: end if;
675: --
676: open c_elctbl_chc;
4500: if g_debug then
4501: hr_utility.set_location('Exception Raised '||l_proc, 10);
4502: end if;
4503: fnd_file.put_line(fnd_file.log,'Exception Raised -'||l_proc);
4504: fnd_file.put_line(fnd_file.log,fnd_message.get);
4505: fnd_file.put_line(fnd_file.log,sqlerrm);
4506:
4507: p_rslt_object_version_number :=l_rslt_object_version_number;
4508: p_suspend_flag :=l_suspend_flag ;
6233: requirement (for example) the enrollment might already be end dated
6234: as part of calls from bepenapi delete_enrollment and this may fail.
6235: Instead let us return without doing anything if this cursor doesnot
6236: return any records */
6237: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6234: as part of calls from bepenapi delete_enrollment and this may fail.
6235: Instead let us return without doing anything if this cursor doesnot
6236: return any records */
6237: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6242: -- fnd_message.raise_error;
6235: Instead let us return without doing anything if this cursor doesnot
6236: return any records */
6237: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6242: -- fnd_message.raise_error;
6243: if g_debug then
6236: return any records */
6237: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6242: -- fnd_message.raise_error;
6243: if g_debug then
6244: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6237: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6242: -- fnd_message.raise_error;
6243: if g_debug then
6244: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6245: end if;
6238: -- fnd_message.set_token('PROC',l_proc);
6239: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6240: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6241: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6242: -- fnd_message.raise_error;
6243: if g_debug then
6244: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6245: end if;
6246: return ;
6359: fetch c_enrt_bnft into l_enrt_bnft;
6360: --
6361: if c_enrt_bnft%notfound then
6362: close c_enrt_bnft;
6363: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6360: --
6361: if c_enrt_bnft%notfound then
6362: close c_enrt_bnft;
6363: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6368: fnd_message.raise_error;
6361: if c_enrt_bnft%notfound then
6362: close c_enrt_bnft;
6363: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6368: fnd_message.raise_error;
6369: else
6362: close c_enrt_bnft;
6363: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6368: fnd_message.raise_error;
6369: else
6370: close c_enrt_bnft;
6363: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6368: fnd_message.raise_error;
6369: else
6370: close c_enrt_bnft;
6371: if g_debug then
6364: fnd_message.set_token('PROC',l_proc);
6365: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6366: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6367: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6368: fnd_message.raise_error;
6369: else
6370: close c_enrt_bnft;
6371: if g_debug then
6372: hr_utility.set_location('c_enrt_bnft found', 10);