677: end if;
678: --
679: if p_actn_typ_id is null then
680: --
681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
682: fnd_message.set_token('PACKAGE',l_proc);
683: fnd_message.set_token('PROC','Enrollment Action Items');
684: fnd_message.set_token('PARAM','p_actn_typ_id');
685: fnd_message.raise_error;
678: --
679: if p_actn_typ_id is null then
680: --
681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
682: fnd_message.set_token('PACKAGE',l_proc);
683: fnd_message.set_token('PROC','Enrollment Action Items');
684: fnd_message.set_token('PARAM','p_actn_typ_id');
685: fnd_message.raise_error;
686: --
679: if p_actn_typ_id is null then
680: --
681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
682: fnd_message.set_token('PACKAGE',l_proc);
683: fnd_message.set_token('PROC','Enrollment Action Items');
684: fnd_message.set_token('PARAM','p_actn_typ_id');
685: fnd_message.raise_error;
686: --
687: end if;
680: --
681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
682: fnd_message.set_token('PACKAGE',l_proc);
683: fnd_message.set_token('PROC','Enrollment Action Items');
684: fnd_message.set_token('PARAM','p_actn_typ_id');
685: fnd_message.raise_error;
686: --
687: end if;
688: --
681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');
682: fnd_message.set_token('PACKAGE',l_proc);
683: fnd_message.set_token('PROC','Enrollment Action Items');
684: fnd_message.set_token('PARAM','p_actn_typ_id');
685: fnd_message.raise_error;
686: --
687: end if;
688: --
689: open c_elctbl_chc;
4513: if g_debug then
4514: hr_utility.set_location('Exception Raised '||l_proc, 10);
4515: end if;
4516: fnd_file.put_line(fnd_file.log,'Exception Raised -'||l_proc);
4517: fnd_file.put_line(fnd_file.log,fnd_message.get);
4518: fnd_file.put_line(fnd_file.log,sqlerrm);
4519:
4520: p_rslt_object_version_number :=l_rslt_object_version_number;
4521: p_suspend_flag :=l_suspend_flag ;
6311: requirement (for example) the enrollment might already be end dated
6312: as part of calls from bepenapi delete_enrollment and this may fail.
6313: Instead let us return without doing anything if this cursor doesnot
6314: return any records */
6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6312: as part of calls from bepenapi delete_enrollment and this may fail.
6313: Instead let us return without doing anything if this cursor doesnot
6314: return any records */
6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6320: -- fnd_message.raise_error;
6313: Instead let us return without doing anything if this cursor doesnot
6314: return any records */
6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6320: -- fnd_message.raise_error;
6321: if g_debug then
6314: return any records */
6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6320: -- fnd_message.raise_error;
6321: if g_debug then
6322: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6320: -- fnd_message.raise_error;
6321: if g_debug then
6322: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6323: end if;
6316: -- fnd_message.set_token('PROC',l_proc);
6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));
6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6320: -- fnd_message.raise_error;
6321: if g_debug then
6322: hr_utility.set_location('Enrollment already ended/ZAPed by another process ',22);
6323: end if;
6324: return ;
6444: fetch c_enrt_bnft into l_enrt_bnft;
6445: --
6446: if c_enrt_bnft%notfound then
6447: close c_enrt_bnft;
6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6445: --
6446: if c_enrt_bnft%notfound then
6447: close c_enrt_bnft;
6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6453: fnd_message.raise_error;
6446: if c_enrt_bnft%notfound then
6447: close c_enrt_bnft;
6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6453: fnd_message.raise_error;
6454: else
6447: close c_enrt_bnft;
6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6453: fnd_message.raise_error;
6454: else
6455: close c_enrt_bnft;
6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6453: fnd_message.raise_error;
6454: else
6455: close c_enrt_bnft;
6456: if g_debug then
6449: fnd_message.set_token('PROC',l_proc);
6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));
6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));
6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6453: fnd_message.raise_error;
6454: else
6455: close c_enrt_bnft;
6456: if g_debug then
6457: hr_utility.set_location('c_enrt_bnft found', 10);