DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on FND_MESSAGE

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

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;

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

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

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

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;

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

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

Line 672: fnd_message.raise_error;

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;

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

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 ;

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

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

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

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;

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

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

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

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

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

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;

Line 6242: -- fnd_message.raise_error;

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 ;

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

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

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

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;

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

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

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

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;

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

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

Line 6368: fnd_message.raise_error;

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