DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on FND_MESSAGE

Line 681: fnd_message.set_name('BEN','BEN_91832_PACKAGE_PARAM_NULL');

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;

Line 682: fnd_message.set_token('PACKAGE',l_proc);

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: --

Line 683: fnd_message.set_token('PROC','Enrollment Action Items');

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;

Line 684: fnd_message.set_token('PARAM','p_actn_typ_id');

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: --

Line 685: fnd_message.raise_error;

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;

Line 4517: fnd_file.put_line(fnd_file.log,fnd_message.get);

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 ;

Line 6315: -- fnd_message.set_name('BEN', 'BEN_91578_BENACPRM_EPE_NF');

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));

Line 6316: -- fnd_message.set_token('PROC',l_proc);

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;

Line 6317: -- fnd_message.set_token('PRTT_ENRT_RSLT_ID',to_char(p_prtt_enrt_rslt_id));

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

Line 6318: -- fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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);

Line 6319: -- fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));

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;

Line 6320: -- fnd_message.raise_error;

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 ;

Line 6448: fnd_message.set_name('BEN', 'BEN_91580_BENACPRM_ENB_NF');

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);

Line 6449: fnd_message.set_token('PROC',l_proc);

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;

Line 6450: fnd_message.set_token('ENRT_BNFT_ID',to_char(p_enrt_bnft_id));

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

Line 6451: fnd_message.set_token('BUSINESS_GROUP_ID',to_char(p_business_group_id));

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;

Line 6452: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

Line 6453: fnd_message.raise_error;

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);