DBA Data[Home] [Help]

APPS.BEN_YRP_BUS dependencies on FND_MESSAGE

Line 264: fnd_message.set_name('BEN','BEN_92130_START_END_DT_UNIQUE');

260: open c1;
261: fetch c1 into l_dummy;
262: if c1%found then
263: close c1;
264: fnd_message.set_name('BEN','BEN_92130_START_END_DT_UNIQUE');
265: fnd_message.raise_error;
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 265: fnd_message.raise_error;

261: fetch c1 into l_dummy;
262: if c1%found then
263: close c1;
264: fnd_message.set_name('BEN','BEN_92130_START_END_DT_UNIQUE');
265: fnd_message.raise_error;
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 15);
269: End chk_start_and_end_dt_unique;

Line 338: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');

334: p_perd_typ_cd <> 'CLNDR' then
335: --
336: -- Raise error as this is a full Calendar year
337: --
338: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');
339: fnd_message.raise_error;
340: --
341: elsif(to_char(p_start_date, 'DDMM') <> '0101'
342: or to_char(p_end_date, 'DDMM') <> '3112')

Line 339: fnd_message.raise_error;

335: --
336: -- Raise error as this is a full Calendar year
337: --
338: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');
339: fnd_message.raise_error;
340: --
341: elsif(to_char(p_start_date, 'DDMM') <> '0101'
342: or to_char(p_end_date, 'DDMM') <> '3112')
343: and p_perd_typ_cd <> 'FISCAL' then

Line 347: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');

343: and p_perd_typ_cd <> 'FISCAL' then
344: --
345: -- Raise error as this is a fiscal year
346: --
347: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');
348: fnd_message.raise_error;
349: --
350: end if;
351: --

Line 348: fnd_message.raise_error;

344: --
345: -- Raise error as this is a fiscal year
346: --
347: fnd_message.set_name('BEN','BEN_91742_YR_PERD_DATES');
348: fnd_message.raise_error;
349: --
350: end if;
351: --
352: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 584: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');

580: fetch c_popl_yr_exists into l_popl_yr_exists ;
581: if c_popl_yr_exists%found
582: then
583: close c_popl_yr_exists ;
584: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
585: fnd_message.set_token('TABLE_NAME', 'BEN_POPL_YR_PERD');
586: fnd_message.raise_error;
587: end if ;
588: close c_popl_yr_exists ;

Line 585: fnd_message.set_token('TABLE_NAME', 'BEN_POPL_YR_PERD');

581: if c_popl_yr_exists%found
582: then
583: close c_popl_yr_exists ;
584: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
585: fnd_message.set_token('TABLE_NAME', 'BEN_POPL_YR_PERD');
586: fnd_message.raise_error;
587: end if ;
588: close c_popl_yr_exists ;
589: --

Line 586: fnd_message.raise_error;

582: then
583: close c_popl_yr_exists ;
584: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
585: fnd_message.set_token('TABLE_NAME', 'BEN_POPL_YR_PERD');
586: fnd_message.raise_error;
587: end if ;
588: close c_popl_yr_exists ;
589: --
590: open c_enrt_perd ;

Line 595: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');

591: fetch c_enrt_perd into l_enrt_perd ;
592: if c_enrt_perd%found
593: then
594: close c_enrt_perd ;
595: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
596: fnd_message.set_token('TABLE_NAME', 'BEN_ENRT_PERD');
597: fnd_message.raise_error;
598: end if ;
599: close c_enrt_perd ;

Line 596: fnd_message.set_token('TABLE_NAME', 'BEN_ENRT_PERD');

592: if c_enrt_perd%found
593: then
594: close c_enrt_perd ;
595: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
596: fnd_message.set_token('TABLE_NAME', 'BEN_ENRT_PERD');
597: fnd_message.raise_error;
598: end if ;
599: close c_enrt_perd ;
600: --

Line 597: fnd_message.raise_error;

593: then
594: close c_enrt_perd ;
595: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
596: fnd_message.set_token('TABLE_NAME', 'BEN_ENRT_PERD');
597: fnd_message.raise_error;
598: end if ;
599: close c_enrt_perd ;
600: --
601: open c_wthn_yr_perd ;

Line 606: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');

602: fetch c_wthn_yr_perd into l_wthn_yr_perd ;
603: if c_wthn_yr_perd%found
604: then
605: close c_wthn_yr_perd ;
606: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
607: fnd_message.set_token('TABLE_NAME', 'BEN_WTHN_YR_PERD');
608: fnd_message.raise_error;
609: end if ;
610: close c_wthn_yr_perd ;

Line 607: fnd_message.set_token('TABLE_NAME', 'BEN_WTHN_YR_PERD');

603: if c_wthn_yr_perd%found
604: then
605: close c_wthn_yr_perd ;
606: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
607: fnd_message.set_token('TABLE_NAME', 'BEN_WTHN_YR_PERD');
608: fnd_message.raise_error;
609: end if ;
610: close c_wthn_yr_perd ;
611: --

Line 608: fnd_message.raise_error;

604: then
605: close c_wthn_yr_perd ;
606: fnd_message.set_name('PER', 'HR_7215_DT_CHILD_EXISTS');
607: fnd_message.set_token('TABLE_NAME', 'BEN_WTHN_YR_PERD');
608: fnd_message.raise_error;
609: end if ;
610: close c_wthn_yr_perd ;
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);