eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PEN_BUS dependencies on FND_MESSAGE

Line 128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

124: p_effective_date => p_effective_date) then
125: --
126: -- raise error as does not exist as lookup
127: --
128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
129: fnd_message.set_token('FIELD', p_enrt_ovridn_flag);
130: fnd_message.set_token('TYPE','YES_NO');
131: fnd_message.raise_error;
132: --

Line 129: fnd_message.set_token('FIELD', p_enrt_ovridn_flag);

125: --
126: -- raise error as does not exist as lookup
127: --
128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
129: fnd_message.set_token('FIELD', p_enrt_ovridn_flag);
130: fnd_message.set_token('TYPE','YES_NO');
131: fnd_message.raise_error;
132: --
133: end if;

Line 130: fnd_message.set_token('TYPE','YES_NO');

126: -- raise error as does not exist as lookup
127: --
128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
129: fnd_message.set_token('FIELD', p_enrt_ovridn_flag);
130: fnd_message.set_token('TYPE','YES_NO');
131: fnd_message.raise_error;
132: --
133: end if;
134: --

Line 131: fnd_message.raise_error;

127: --
128: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
129: fnd_message.set_token('FIELD', p_enrt_ovridn_flag);
130: fnd_message.set_token('TYPE','YES_NO');
131: fnd_message.raise_error;
132: --
133: end if;
134: --
135: end if;

Line 198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

194: p_effective_date => p_effective_date) then
195: --
196: -- raise error as does not exist as lookup
197: --
198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
199: fnd_message.set_token('FIELD', p_no_lngr_elig_flag);
200: fnd_message.set_token('TYPE','YES_NO');
201: fnd_message.raise_error;
202: --

Line 199: fnd_message.set_token('FIELD', p_no_lngr_elig_flag);

195: --
196: -- raise error as does not exist as lookup
197: --
198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
199: fnd_message.set_token('FIELD', p_no_lngr_elig_flag);
200: fnd_message.set_token('TYPE','YES_NO');
201: fnd_message.raise_error;
202: --
203: end if;

Line 200: fnd_message.set_token('TYPE','YES_NO');

196: -- raise error as does not exist as lookup
197: --
198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
199: fnd_message.set_token('FIELD', p_no_lngr_elig_flag);
200: fnd_message.set_token('TYPE','YES_NO');
201: fnd_message.raise_error;
202: --
203: end if;
204: --

Line 201: fnd_message.raise_error;

197: --
198: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
199: fnd_message.set_token('FIELD', p_no_lngr_elig_flag);
200: fnd_message.set_token('TYPE','YES_NO');
201: fnd_message.raise_error;
202: --
203: end if;
204: --
205: end if;

Line 270: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

266: p_effective_date => p_effective_date) then
267: --
268: -- raise error as does not exist as lookup
269: --
270: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
271: fnd_message.set_token('FIELD',p_enrt_mthd_cd);
272: fnd_message.set_token('TYPE','BEN_ENRT_RSLT_MTHD');
273: fnd_message.raise_error;
274: end if;

Line 271: fnd_message.set_token('FIELD',p_enrt_mthd_cd);

267: --
268: -- raise error as does not exist as lookup
269: --
270: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
271: fnd_message.set_token('FIELD',p_enrt_mthd_cd);
272: fnd_message.set_token('TYPE','BEN_ENRT_RSLT_MTHD');
273: fnd_message.raise_error;
274: end if;
275: --

Line 272: fnd_message.set_token('TYPE','BEN_ENRT_RSLT_MTHD');

268: -- raise error as does not exist as lookup
269: --
270: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
271: fnd_message.set_token('FIELD',p_enrt_mthd_cd);
272: fnd_message.set_token('TYPE','BEN_ENRT_RSLT_MTHD');
273: fnd_message.raise_error;
274: end if;
275: --
276: end if;

Line 273: fnd_message.raise_error;

269: --
270: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
271: fnd_message.set_token('FIELD',p_enrt_mthd_cd);
272: fnd_message.set_token('TYPE','BEN_ENRT_RSLT_MTHD');
273: fnd_message.raise_error;
274: end if;
275: --
276: end if;
277: hr_utility.set_location('Leaving:'||l_proc,10);

Line 342: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

338: --
339: -- raise error as does not exist as lookup
340: --
341: close c1;
342: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
343: fnd_message.set_token('FIELD', p_uom );
344: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
345: fnd_message.raise_error;
346: end if;

Line 343: fnd_message.set_token('FIELD', p_uom );

339: -- raise error as does not exist as lookup
340: --
341: close c1;
342: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
343: fnd_message.set_token('FIELD', p_uom );
344: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
345: fnd_message.raise_error;
346: end if;
347: close c1;

Line 344: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');

340: --
341: close c1;
342: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
343: fnd_message.set_token('FIELD', p_uom );
344: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
345: fnd_message.raise_error;
346: end if;
347: close c1;
348: --

Line 345: fnd_message.raise_error;

341: close c1;
342: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
343: fnd_message.set_token('FIELD', p_uom );
344: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
345: fnd_message.raise_error;
346: end if;
347: close c1;
348: --
349: end if;

Line 413: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

409: p_effective_date => p_effective_date) then
410: --
411: -- raise error as does not exist as lookup
412: --
413: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
414: fnd_message.set_token('FIELD',p_prtt_is_cvrd_flag);
415: fnd_message.set_token('TYPE','YES_NO');
416: fnd_message.raise_error;
417: end if;

Line 414: fnd_message.set_token('FIELD',p_prtt_is_cvrd_flag);

410: --
411: -- raise error as does not exist as lookup
412: --
413: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
414: fnd_message.set_token('FIELD',p_prtt_is_cvrd_flag);
415: fnd_message.set_token('TYPE','YES_NO');
416: fnd_message.raise_error;
417: end if;
418: --

Line 415: fnd_message.set_token('TYPE','YES_NO');

411: -- raise error as does not exist as lookup
412: --
413: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
414: fnd_message.set_token('FIELD',p_prtt_is_cvrd_flag);
415: fnd_message.set_token('TYPE','YES_NO');
416: fnd_message.raise_error;
417: end if;
418: --
419: end if;

Line 416: fnd_message.raise_error;

412: --
413: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
414: fnd_message.set_token('FIELD',p_prtt_is_cvrd_flag);
415: fnd_message.set_token('TYPE','YES_NO');
416: fnd_message.raise_error;
417: end if;
418: --
419: end if;
420: --

Line 483: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

479: p_effective_date => p_effective_date) then
480: --
481: -- raise error as does not exist as lookup
482: --
483: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
484: fnd_message.set_token('FIELD', p_sspndd_flag);
485: fnd_message.set_token('TYPE','YES_NO');
486: fnd_message.raise_error;
487: end if;

Line 484: fnd_message.set_token('FIELD', p_sspndd_flag);

480: --
481: -- raise error as does not exist as lookup
482: --
483: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
484: fnd_message.set_token('FIELD', p_sspndd_flag);
485: fnd_message.set_token('TYPE','YES_NO');
486: fnd_message.raise_error;
487: end if;
488: --

Line 485: fnd_message.set_token('TYPE','YES_NO');

481: -- raise error as does not exist as lookup
482: --
483: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
484: fnd_message.set_token('FIELD', p_sspndd_flag);
485: fnd_message.set_token('TYPE','YES_NO');
486: fnd_message.raise_error;
487: end if;
488: --
489: end if;

Line 486: fnd_message.raise_error;

482: --
483: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
484: fnd_message.set_token('FIELD', p_sspndd_flag);
485: fnd_message.set_token('TYPE','YES_NO');
486: fnd_message.raise_error;
487: end if;
488: --
489: end if;
490: --

Line 553: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

549: p_effective_date => p_effective_date) then
550: --
551: -- raise error as does not exist as lookup
552: --
553: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
554: fnd_message.set_token('FIELD', 'p_comp_lvl_cd '||p_comp_lvl_cd);
555: fnd_message.set_token('TYPE','BEN_COMP_LVL');
556: fnd_message.raise_error;
557: end if;

Line 554: fnd_message.set_token('FIELD', 'p_comp_lvl_cd '||p_comp_lvl_cd);

550: --
551: -- raise error as does not exist as lookup
552: --
553: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
554: fnd_message.set_token('FIELD', 'p_comp_lvl_cd '||p_comp_lvl_cd);
555: fnd_message.set_token('TYPE','BEN_COMP_LVL');
556: fnd_message.raise_error;
557: end if;
558: --

Line 555: fnd_message.set_token('TYPE','BEN_COMP_LVL');

551: -- raise error as does not exist as lookup
552: --
553: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
554: fnd_message.set_token('FIELD', 'p_comp_lvl_cd '||p_comp_lvl_cd);
555: fnd_message.set_token('TYPE','BEN_COMP_LVL');
556: fnd_message.raise_error;
557: end if;
558: --
559: end if;

Line 556: fnd_message.raise_error;

552: --
553: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
554: fnd_message.set_token('FIELD', 'p_comp_lvl_cd '||p_comp_lvl_cd);
555: fnd_message.set_token('TYPE','BEN_COMP_LVL');
556: fnd_message.raise_error;
557: end if;
558: --
559: end if;
560: --

Line 623: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

619: p_effective_date => p_effective_date) then
620: --
621: -- raise error as does not exist as lookup
622: --
623: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
624: fnd_message.set_token('FIELD',p_bnft_nnmntry_uom);
625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
626: fnd_message.raise_error;
627: end if;

Line 624: fnd_message.set_token('FIELD',p_bnft_nnmntry_uom);

620: --
621: -- raise error as does not exist as lookup
622: --
623: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
624: fnd_message.set_token('FIELD',p_bnft_nnmntry_uom);
625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
626: fnd_message.raise_error;
627: end if;
628: end if;

Line 625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');

621: -- raise error as does not exist as lookup
622: --
623: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
624: fnd_message.set_token('FIELD',p_bnft_nnmntry_uom);
625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
626: fnd_message.raise_error;
627: end if;
628: end if;
629: hr_utility.set_location('Leaving:'||l_proc,10);

Line 626: fnd_message.raise_error;

622: --
623: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
624: fnd_message.set_token('FIELD',p_bnft_nnmntry_uom);
625: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
626: fnd_message.raise_error;
627: end if;
628: end if;
629: hr_utility.set_location('Leaving:'||l_proc,10);
630: --

Line 691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

687: p_effective_date => p_effective_date) then
688: --
689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('FIELD',p_bnft_typ_cd);
693: fnd_message.set_token('TYPE','BEN_BNFT_TYP');
694: fnd_message.raise_error;
695: end if;

Line 692: fnd_message.set_token('FIELD',p_bnft_typ_cd);

688: --
689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('FIELD',p_bnft_typ_cd);
693: fnd_message.set_token('TYPE','BEN_BNFT_TYP');
694: fnd_message.raise_error;
695: end if;
696: --

Line 693: fnd_message.set_token('TYPE','BEN_BNFT_TYP');

689: -- raise error as does not exist as lookup
690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('FIELD',p_bnft_typ_cd);
693: fnd_message.set_token('TYPE','BEN_BNFT_TYP');
694: fnd_message.raise_error;
695: end if;
696: --
697: end if;

Line 694: fnd_message.raise_error;

690: --
691: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
692: fnd_message.set_token('FIELD',p_bnft_typ_cd);
693: fnd_message.set_token('TYPE','BEN_BNFT_TYP');
694: fnd_message.raise_error;
695: end if;
696: --
697: end if;
698: hr_utility.set_location('Leaving:'||l_proc,10);

Line 760: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

756: p_effective_date => p_effective_date) then
757: --
758: -- raise error as does not exist as lookup
759: --
760: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
761: fnd_message.set_token('FIELD',p_prtt_enrt_rslt_stat_cd);
762: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
763: fnd_message.raise_error;
764: end if;

Line 761: fnd_message.set_token('FIELD',p_prtt_enrt_rslt_stat_cd);

757: --
758: -- raise error as does not exist as lookup
759: --
760: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
761: fnd_message.set_token('FIELD',p_prtt_enrt_rslt_stat_cd);
762: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
763: fnd_message.raise_error;
764: end if;
765: --

Line 762: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');

758: -- raise error as does not exist as lookup
759: --
760: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
761: fnd_message.set_token('FIELD',p_prtt_enrt_rslt_stat_cd);
762: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
763: fnd_message.raise_error;
764: end if;
765: --
766: end if;

Line 763: fnd_message.raise_error;

759: --
760: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
761: fnd_message.set_token('FIELD',p_prtt_enrt_rslt_stat_cd);
762: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
763: fnd_message.raise_error;
764: end if;
765: --
766: end if;
767: hr_utility.set_location('Leaving:'||l_proc,10);

Line 830: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

826: p_effective_date => p_effective_date) then
827: --
828: -- raise error as does not exist as lookup
829: --
830: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
831: fnd_message.set_token('FIELD', p_enrt_ovrid_rsn_cd);
832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
833: fnd_message.raise_error;
834: end if;

Line 831: fnd_message.set_token('FIELD', p_enrt_ovrid_rsn_cd);

827: --
828: -- raise error as does not exist as lookup
829: --
830: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
831: fnd_message.set_token('FIELD', p_enrt_ovrid_rsn_cd);
832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
833: fnd_message.raise_error;
834: end if;
835: end if;

Line 832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');

828: -- raise error as does not exist as lookup
829: --
830: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
831: fnd_message.set_token('FIELD', p_enrt_ovrid_rsn_cd);
832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
833: fnd_message.raise_error;
834: end if;
835: end if;
836: hr_utility.set_location('Leaving:'||l_proc,10);

Line 833: fnd_message.raise_error;

829: --
830: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
831: fnd_message.set_token('FIELD', p_enrt_ovrid_rsn_cd);
832: fnd_message.set_token('TYPE','BEN_OVRID_RSN');
833: fnd_message.raise_error;
834: end if;
835: end if;
836: hr_utility.set_location('Leaving:'||l_proc,10);
837: end chk_enrt_ovrid_rsn_cd;

Line 1851: fnd_message.set_name('BEN','BEN_91468_PGM_MISSING');

1847: p_pgm_id);
1848: fetch g_c_pgm into g_pgm_rec;
1849: if (g_c_pgm%notfound) then
1850: close g_c_pgm;
1851: fnd_message.set_name('BEN','BEN_91468_PGM_MISSING');
1852: fnd_message.set_token('ID', to_char(p_pgm_id));
1853: fnd_message.raise_error;
1854: end if;
1855: close g_c_pgm;

Line 1852: fnd_message.set_token('ID', to_char(p_pgm_id));

1848: fetch g_c_pgm into g_pgm_rec;
1849: if (g_c_pgm%notfound) then
1850: close g_c_pgm;
1851: fnd_message.set_name('BEN','BEN_91468_PGM_MISSING');
1852: fnd_message.set_token('ID', to_char(p_pgm_id));
1853: fnd_message.raise_error;
1854: end if;
1855: close g_c_pgm;
1856: end if;

Line 1853: fnd_message.raise_error;

1849: if (g_c_pgm%notfound) then
1850: close g_c_pgm;
1851: fnd_message.set_name('BEN','BEN_91468_PGM_MISSING');
1852: fnd_message.set_token('ID', to_char(p_pgm_id));
1853: fnd_message.raise_error;
1854: end if;
1855: close g_c_pgm;
1856: end if;
1857: --

Line 1884: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');

1880: g_enrt_tbl(i).ptip_id);
1881: fetch g_c_ptip into g_ptip_tbl(g_ptip_cnt+1);
1882: if (g_c_ptip%notfound) then
1883: close g_c_ptip;
1884: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
1885: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).ptip_id) );
1886: fnd_message.raise_error;
1887: else
1888: g_ptip_cnt := g_ptip_cnt + 1;

Line 1885: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).ptip_id) );

1881: fetch g_c_ptip into g_ptip_tbl(g_ptip_cnt+1);
1882: if (g_c_ptip%notfound) then
1883: close g_c_ptip;
1884: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
1885: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).ptip_id) );
1886: fnd_message.raise_error;
1887: else
1888: g_ptip_cnt := g_ptip_cnt + 1;
1889: --

Line 1886: fnd_message.raise_error;

1882: if (g_c_ptip%notfound) then
1883: close g_c_ptip;
1884: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
1885: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).ptip_id) );
1886: fnd_message.raise_error;
1887: else
1888: g_ptip_cnt := g_ptip_cnt + 1;
1889: --
1890: -- if no_mx/mn_pl_typ_ov(e)rid_flag='N' and

Line 1910: fnd_message.set_name

1906: g_enrt_tbl(i).pl_typ_id);
1907: fetch g_c_pl_typ into l_pl_typ_rec;
1908: if (g_c_pl_typ%notfound) then
1909: close g_c_pl_typ;
1910: fnd_message.set_name
1911: ('BEN','BEN_91469_PL_TYP_MISSING');
1912: fnd_message.set_token
1913: ('ID',to_char(g_enrt_tbl(i).pl_typ_id) );
1914: fnd_message.raise_error;

Line 1912: fnd_message.set_token

1908: if (g_c_pl_typ%notfound) then
1909: close g_c_pl_typ;
1910: fnd_message.set_name
1911: ('BEN','BEN_91469_PL_TYP_MISSING');
1912: fnd_message.set_token
1913: ('ID',to_char(g_enrt_tbl(i).pl_typ_id) );
1914: fnd_message.raise_error;
1915: end if;
1916: close g_c_pl_typ;

Line 1914: fnd_message.raise_error;

1910: fnd_message.set_name
1911: ('BEN','BEN_91469_PL_TYP_MISSING');
1912: fnd_message.set_token
1913: ('ID',to_char(g_enrt_tbl(i).pl_typ_id) );
1914: fnd_message.raise_error;
1915: end if;
1916: close g_c_pl_typ;
1917: if (g_ptip_tbl(g_ptip_cnt).no_mn_pl_typ_overid_flag='N' and
1918: g_ptip_tbl(g_ptip_cnt).mn_enrd_rqd_ovrid_num is null

Line 1966: fnd_message.set_name('BEN','BEN_91469_PL_TYP_MISSING');

1962: g_enrt_tbl(i).pl_typ_id);
1963: fetch g_c_pl_typ into g_pl_typ_tbl(g_pl_typ_cnt+1);
1964: if (g_c_pl_typ%notfound) then
1965: close g_c_pl_typ;
1966: fnd_message.set_name('BEN','BEN_91469_PL_TYP_MISSING');
1967: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_typ_id));
1968: fnd_message.raise_error;
1969: else
1970: g_pl_typ_cnt := g_pl_typ_cnt +1;

Line 1967: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_typ_id));

1963: fetch g_c_pl_typ into g_pl_typ_tbl(g_pl_typ_cnt+1);
1964: if (g_c_pl_typ%notfound) then
1965: close g_c_pl_typ;
1966: fnd_message.set_name('BEN','BEN_91469_PL_TYP_MISSING');
1967: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_typ_id));
1968: fnd_message.raise_error;
1969: else
1970: g_pl_typ_cnt := g_pl_typ_cnt +1;
1971: l_prev_pl_typ_id := g_enrt_tbl(i).pl_typ_id;

Line 1968: fnd_message.raise_error;

1964: if (g_c_pl_typ%notfound) then
1965: close g_c_pl_typ;
1966: fnd_message.set_name('BEN','BEN_91469_PL_TYP_MISSING');
1967: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_typ_id));
1968: fnd_message.raise_error;
1969: else
1970: g_pl_typ_cnt := g_pl_typ_cnt +1;
1971: l_prev_pl_typ_id := g_enrt_tbl(i).pl_typ_id;
1972: end if;

Line 1994: fnd_message.set_name('BEN','BEN_91460_PLAN_MISSING');

1990: );
1991: fetch g_c_pl into g_pl_tbl(g_pl_cnt + 1);
1992: if (g_c_pl%notfound) then
1993: close g_c_pl;
1994: fnd_message.set_name('BEN','BEN_91460_PLAN_MISSING');
1995: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_id));
1996: fnd_message.raise_error;
1997: else
1998: g_pl_cnt := g_pl_cnt + 1 ;

Line 1995: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_id));

1991: fetch g_c_pl into g_pl_tbl(g_pl_cnt + 1);
1992: if (g_c_pl%notfound) then
1993: close g_c_pl;
1994: fnd_message.set_name('BEN','BEN_91460_PLAN_MISSING');
1995: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_id));
1996: fnd_message.raise_error;
1997: else
1998: g_pl_cnt := g_pl_cnt + 1 ;
1999: --

Line 1996: fnd_message.raise_error;

1992: if (g_c_pl%notfound) then
1993: close g_c_pl;
1994: fnd_message.set_name('BEN','BEN_91460_PLAN_MISSING');
1995: fnd_message.set_token('ID', to_char(g_enrt_tbl(i).pl_id));
1996: fnd_message.raise_error;
1997: else
1998: g_pl_cnt := g_pl_cnt + 1 ;
1999: --
2000: -- Bug 2715942 code addition for ben_ler_bnft_rstrn_f

Line 2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');

2299: --
2300: -- Account for cases where formula returns an unknown
2301: -- variable name
2302: --
2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');
2304: fnd_message.set_token('PROC', p_proc);
2305: fnd_message.set_token('FORMULA', p_rule_id);
2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);
2307: fnd_message.raise_error;

Line 2304: fnd_message.set_token('PROC', p_proc);

2300: -- Account for cases where formula returns an unknown
2301: -- variable name
2302: --
2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');
2304: fnd_message.set_token('PROC', p_proc);
2305: fnd_message.set_token('FORMULA', p_rule_id);
2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);
2307: fnd_message.raise_error;
2308: --

Line 2305: fnd_message.set_token('FORMULA', p_rule_id);

2301: -- variable name
2302: --
2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');
2304: fnd_message.set_token('PROC', p_proc);
2305: fnd_message.set_token('FORMULA', p_rule_id);
2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);
2307: fnd_message.raise_error;
2308: --
2309: end if;

Line 2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);

2302: --
2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');
2304: fnd_message.set_token('PROC', p_proc);
2305: fnd_message.set_token('FORMULA', p_rule_id);
2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);
2307: fnd_message.raise_error;
2308: --
2309: end if;
2310: --

Line 2307: fnd_message.raise_error;

2303: fnd_message.set_name('BEN', 'BEN_92310_FORMULA_RET_PARAM');
2304: fnd_message.set_token('PROC', p_proc);
2305: fnd_message.set_token('FORMULA', p_rule_id);
2306: fnd_message.set_token('PARAMETER', p_rule_returns(l_count).name);
2307: fnd_message.raise_error;
2308: --
2309: end if;
2310: --
2311: -- Code for type casting errors from formula return variables

Line 2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

2313: exception
2314: --
2315: when others then
2316: --
2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2318: fnd_message.set_token('PROC',p_proc);
2319: fnd_message.set_token('FORMULA',p_rule_id);
2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);
2321: fnd_message.raise_error;

Line 2318: fnd_message.set_token('PROC',p_proc);

2314: --
2315: when others then
2316: --
2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2318: fnd_message.set_token('PROC',p_proc);
2319: fnd_message.set_token('FORMULA',p_rule_id);
2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);
2321: fnd_message.raise_error;
2322: --

Line 2319: fnd_message.set_token('FORMULA',p_rule_id);

2315: when others then
2316: --
2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2318: fnd_message.set_token('PROC',p_proc);
2319: fnd_message.set_token('FORMULA',p_rule_id);
2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);
2321: fnd_message.raise_error;
2322: --
2323: end;

Line 2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);

2316: --
2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2318: fnd_message.set_token('PROC',p_proc);
2319: fnd_message.set_token('FORMULA',p_rule_id);
2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);
2321: fnd_message.raise_error;
2322: --
2323: end;
2324: --

Line 2321: fnd_message.raise_error;

2317: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2318: fnd_message.set_token('PROC',p_proc);
2319: fnd_message.set_token('FORMULA',p_rule_id);
2320: fnd_message.set_token('PARAMETER',p_rule_returns(l_count).name);
2321: fnd_message.raise_error;
2322: --
2323: end;
2324: --
2325: end loop;

Line 2329: fnd_message.set_name('BEN','BEN_92187_POST_ELCN_NOT_PASS');

2325: end loop;
2326: --
2327: if l_successful <> 'Y' then
2328: --
2329: fnd_message.set_name('BEN','BEN_92187_POST_ELCN_NOT_PASS');
2330: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
2331: fnd_message.raise_error;
2332: --
2333: end if;

Line 2330: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

2326: --
2327: if l_successful <> 'Y' then
2328: --
2329: fnd_message.set_name('BEN','BEN_92187_POST_ELCN_NOT_PASS');
2330: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: --

Line 2331: fnd_message.raise_error;

2327: if l_successful <> 'Y' then
2328: --
2329: fnd_message.set_name('BEN','BEN_92187_POST_ELCN_NOT_PASS');
2330: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: --
2335: end if;

Line 2552: fnd_message.set_name('BEN', 'BEN_91962_MNDTRY_OBJ_NOT_ENRLD');

2548: open c1;
2549: fetch c1 into l_dump;
2550: If c1%found then
2551: close c1;
2552: fnd_message.set_name('BEN', 'BEN_91962_MNDTRY_OBJ_NOT_ENRLD');
2553: fnd_message.raise_error;
2554: End if;
2555: close c1;
2556: hr_utility.set_location('Leaving - '||l_proc, 10);

Line 2553: fnd_message.raise_error;

2549: fetch c1 into l_dump;
2550: If c1%found then
2551: close c1;
2552: fnd_message.set_name('BEN', 'BEN_91962_MNDTRY_OBJ_NOT_ENRLD');
2553: fnd_message.raise_error;
2554: End if;
2555: close c1;
2556: hr_utility.set_location('Leaving - '||l_proc, 10);
2557: End;

Line 2624: fnd_message.set_name('BEN','BEN_92468_PERSON_TYP_NOT_FOUND');

2620: for r_pt in c_pt loop
2621: l_person_type_id := r_pt.person_type_id;
2622: end loop;
2623: if l_person_type_id is null then
2624: fnd_message.set_name('BEN','BEN_92468_PERSON_TYP_NOT_FOUND');
2625: fnd_message.raise_error;
2626: end if;
2627: -- Fetch enrollment results and create a distinct number or inclusive date records
2628: for r_pen in c_pen loop

Line 2625: fnd_message.raise_error;

2621: l_person_type_id := r_pt.person_type_id;
2622: end loop;
2623: if l_person_type_id is null then
2624: fnd_message.set_name('BEN','BEN_92468_PERSON_TYP_NOT_FOUND');
2625: fnd_message.raise_error;
2626: end if;
2627: -- Fetch enrollment results and create a distinct number or inclusive date records
2628: for r_pen in c_pen loop
2629: if l_pen.count > 0 then

Line 2986: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');

2982: open c_paf;
2983: fetch c_paf into l_assignment_id;
2984: if (c_paf%notfound) then
2985: close c_paf;
2986: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2987: fnd_message.set_token('ID' , to_char(p_person_id));
2988: --Bug# 2261610
2989: fnd_message.set_token('PROC' , l_proc);
2990: fnd_message.raise_error;

Line 2987: fnd_message.set_token('ID' , to_char(p_person_id));

2983: fetch c_paf into l_assignment_id;
2984: if (c_paf%notfound) then
2985: close c_paf;
2986: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2987: fnd_message.set_token('ID' , to_char(p_person_id));
2988: --Bug# 2261610
2989: fnd_message.set_token('PROC' , l_proc);
2990: fnd_message.raise_error;
2991: end if;

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

2985: close c_paf;
2986: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2987: fnd_message.set_token('ID' , to_char(p_person_id));
2988: --Bug# 2261610
2989: fnd_message.set_token('PROC' , l_proc);
2990: fnd_message.raise_error;
2991: end if;
2992: close c_paf;
2993: --

Line 2990: fnd_message.raise_error;

2986: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2987: fnd_message.set_token('ID' , to_char(p_person_id));
2988: --Bug# 2261610
2989: fnd_message.set_token('PROC' , l_proc);
2990: fnd_message.raise_error;
2991: end if;
2992: close c_paf;
2993: --
2994: hr_utility.set_location('l_assignment_id is :-'||l_assignment_id ,1234);

Line 3068: fnd_message.set_name('BEN','BEN_92968_PL_ENRD_GT_MX_ALWD');

3064: end loop;
3065: end if; --l_ptip_tbl_ct > 0
3066:
3067: -- end 2162121
3068: fnd_message.set_name('BEN','BEN_92968_PL_ENRD_GT_MX_ALWD');
3069: fnd_message.set_token ('PLAN_OPTION_NAMES', l_plan_opt_names);
3070: fnd_message.set_token
3071: ('TOT_ENRD'
3072: ,to_char(g_ptip_tbl(i).tot_pl_enrld));

Line 3069: fnd_message.set_token ('PLAN_OPTION_NAMES', l_plan_opt_names);

3065: end if; --l_ptip_tbl_ct > 0
3066:
3067: -- end 2162121
3068: fnd_message.set_name('BEN','BEN_92968_PL_ENRD_GT_MX_ALWD');
3069: fnd_message.set_token ('PLAN_OPTION_NAMES', l_plan_opt_names);
3070: fnd_message.set_token
3071: ('TOT_ENRD'
3072: ,to_char(g_ptip_tbl(i).tot_pl_enrld));
3073: fnd_message.set_token

Line 3070: fnd_message.set_token

3066:
3067: -- end 2162121
3068: fnd_message.set_name('BEN','BEN_92968_PL_ENRD_GT_MX_ALWD');
3069: fnd_message.set_token ('PLAN_OPTION_NAMES', l_plan_opt_names);
3070: fnd_message.set_token
3071: ('TOT_ENRD'
3072: ,to_char(g_ptip_tbl(i).tot_pl_enrld));
3073: fnd_message.set_token
3074: ('MX_ENRL'

Line 3073: fnd_message.set_token

3069: fnd_message.set_token ('PLAN_OPTION_NAMES', l_plan_opt_names);
3070: fnd_message.set_token
3071: ('TOT_ENRD'
3072: ,to_char(g_ptip_tbl(i).tot_pl_enrld));
3073: fnd_message.set_token
3074: ('MX_ENRL'
3075: ,to_char(g_ptip_tbl(i).MX_ENRD_ALWD_OVRID_NUM));
3076: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3077: fnd_message.raise_error;

Line 3076: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);

3072: ,to_char(g_ptip_tbl(i).tot_pl_enrld));
3073: fnd_message.set_token
3074: ('MX_ENRL'
3075: ,to_char(g_ptip_tbl(i).MX_ENRD_ALWD_OVRID_NUM));
3076: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3077: fnd_message.raise_error;
3078: elsif(g_ptip_tbl(i).tot_pl_enrld < g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM
3079: and g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM is not NULL) then
3080: l_erl := 'N';

Line 3077: fnd_message.raise_error;

3073: fnd_message.set_token
3074: ('MX_ENRL'
3075: ,to_char(g_ptip_tbl(i).MX_ENRD_ALWD_OVRID_NUM));
3076: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3077: fnd_message.raise_error;
3078: elsif(g_ptip_tbl(i).tot_pl_enrld < g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM
3079: and g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM is not NULL) then
3080: l_erl := 'N';
3081: if p_include_erl = 'N' then

Line 3091: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');

3087: end if;
3088: if l_erl = 'N' then
3089: --
3090: l_step := 26;
3091: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3092: /* fnd_message.set_token
3093: ('TOT_ENRD'
3094: ,to_char(g_ptip_tbl(i).tot_pl_enrld));*/ -- Bug 5664907
3095: fnd_message.set_token

Line 3092: /* fnd_message.set_token

3088: if l_erl = 'N' then
3089: --
3090: l_step := 26;
3091: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3092: /* fnd_message.set_token
3093: ('TOT_ENRD'
3094: ,to_char(g_ptip_tbl(i).tot_pl_enrld));*/ -- Bug 5664907
3095: fnd_message.set_token
3096: ('MN_ENRL'

Line 3095: fnd_message.set_token

3091: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3092: /* fnd_message.set_token
3093: ('TOT_ENRD'
3094: ,to_char(g_ptip_tbl(i).tot_pl_enrld));*/ -- Bug 5664907
3095: fnd_message.set_token
3096: ('MN_ENRL'
3097: ,to_char(g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM));
3098: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3099: fnd_message.raise_error;

Line 3098: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);

3094: ,to_char(g_ptip_tbl(i).tot_pl_enrld));*/ -- Bug 5664907
3095: fnd_message.set_token
3096: ('MN_ENRL'
3097: ,to_char(g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM));
3098: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3099: fnd_message.raise_error;
3100: --
3101: end if;
3102: --

Line 3099: fnd_message.raise_error;

3095: fnd_message.set_token
3096: ('MN_ENRL'
3097: ,to_char(g_ptip_tbl(i).MN_ENRD_RQD_OVRID_NUM));
3098: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3099: fnd_message.raise_error;
3100: --
3101: end if;
3102: --
3103: end if;

Line 3110: fnd_message.set_name('BEN','BEN_92500_PL_CVG_AMT_GT_MX_ALW');

3106: --
3107: l_step := 30;
3108: if (g_ptip_tbl(i).tot_cvg_amt > g_ptip_tbl(i).MX_CVG_ALWD_AMT
3109: and g_ptip_tbl(i).MX_CVG_ALWD_AMT is not NULL ) then
3110: fnd_message.set_name('BEN','BEN_92500_PL_CVG_AMT_GT_MX_ALW');
3111: fnd_message.set_token
3112: ('TOT_AMT'
3113: ,to_char(g_ptip_tbl(i).tot_cvg_amt));
3114: fnd_message.set_token

Line 3111: fnd_message.set_token

3107: l_step := 30;
3108: if (g_ptip_tbl(i).tot_cvg_amt > g_ptip_tbl(i).MX_CVG_ALWD_AMT
3109: and g_ptip_tbl(i).MX_CVG_ALWD_AMT is not NULL ) then
3110: fnd_message.set_name('BEN','BEN_92500_PL_CVG_AMT_GT_MX_ALW');
3111: fnd_message.set_token
3112: ('TOT_AMT'
3113: ,to_char(g_ptip_tbl(i).tot_cvg_amt));
3114: fnd_message.set_token
3115: ('MX_AMT'

Line 3114: fnd_message.set_token

3110: fnd_message.set_name('BEN','BEN_92500_PL_CVG_AMT_GT_MX_ALW');
3111: fnd_message.set_token
3112: ('TOT_AMT'
3113: ,to_char(g_ptip_tbl(i).tot_cvg_amt));
3114: fnd_message.set_token
3115: ('MX_AMT'
3116: ,to_char(g_ptip_tbl(i).MX_CVG_ALWD_AMT));
3117: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3118: fnd_message.raise_error;

Line 3117: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);

3113: ,to_char(g_ptip_tbl(i).tot_cvg_amt));
3114: fnd_message.set_token
3115: ('MX_AMT'
3116: ,to_char(g_ptip_tbl(i).MX_CVG_ALWD_AMT));
3117: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3118: fnd_message.raise_error;
3119: end if;
3120: --
3121: -- If plan type is spouse/dependent life ins then store amount for

Line 3118: fnd_message.raise_error;

3114: fnd_message.set_token
3115: ('MX_AMT'
3116: ,to_char(g_ptip_tbl(i).MX_CVG_ALWD_AMT));
3117: fnd_message.set_token('PL_TYP_NAME', g_ptip_tbl(i).name);
3118: fnd_message.raise_error;
3119: end if;
3120: --
3121: -- If plan type is spouse/dependent life ins then store amount for
3122: -- later used.

Line 3163: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');

3159: --
3160: l_step := 40;
3161: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3162: < g_tot_dpnt_lf_ins_amt) then
3163: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3164: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt));
3165: fnd_message.set_token
3166: ('MX_INS'
3167: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));

Line 3164: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt));

3160: l_step := 40;
3161: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3162: < g_tot_dpnt_lf_ins_amt) then
3163: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3164: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt));
3165: fnd_message.set_token
3166: ('MX_INS'
3167: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3168: fnd_message.raise_error;

Line 3165: fnd_message.set_token

3161: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3162: < g_tot_dpnt_lf_ins_amt) then
3163: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3164: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt));
3165: fnd_message.set_token
3166: ('MX_INS'
3167: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3168: fnd_message.raise_error;
3169: elsif(((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)

Line 3168: fnd_message.raise_error;

3164: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt));
3165: fnd_message.set_token
3166: ('MX_INS'
3167: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3168: fnd_message.raise_error;
3169: elsif(((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3170: < g_tot_sps_lf_ins_amt) then
3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));

Line 3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');

3167: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3168: fnd_message.raise_error;
3169: elsif(((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3170: < g_tot_sps_lf_ins_amt) then
3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));
3173: fnd_message.set_token('MX_INS',
3174: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3175: fnd_message.raise_error;

Line 3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));

3168: fnd_message.raise_error;
3169: elsif(((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3170: < g_tot_sps_lf_ins_amt) then
3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));
3173: fnd_message.set_token('MX_INS',
3174: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3175: fnd_message.raise_error;
3176: end if;

Line 3173: fnd_message.set_token('MX_INS',

3169: elsif(((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100)
3170: < g_tot_sps_lf_ins_amt) then
3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));
3173: fnd_message.set_token('MX_INS',
3174: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3175: fnd_message.raise_error;
3176: end if;
3177: --

Line 3175: fnd_message.raise_error;

3171: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3172: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt));
3173: fnd_message.set_token('MX_INS',
3174: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt)/100));
3175: fnd_message.raise_error;
3176: end if;
3177: --
3178: l_step := 45;
3179: --This Evaluates the suspended coverage also in determining the

Line 3184: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');

3180: --limits.
3181: --
3182: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3183: < g_tot_dpnt_lf_ins_amt_no) then
3184: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3185: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt_no));
3186: fnd_message.set_token
3187: ('MX_INS'
3188: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));

Line 3185: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt_no));

3181: --
3182: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3183: < g_tot_dpnt_lf_ins_amt_no) then
3184: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3185: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt_no));
3186: fnd_message.set_token
3187: ('MX_INS'
3188: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3189: fnd_message.raise_error;

Line 3186: fnd_message.set_token

3182: if (((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3183: < g_tot_dpnt_lf_ins_amt_no) then
3184: fnd_message.set_name('BEN','BEN_91590_DPNT_LF_INS_OVER_LMT');
3185: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt_no));
3186: fnd_message.set_token
3187: ('MX_INS'
3188: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3189: fnd_message.raise_error;
3190: elsif (((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)

Line 3189: fnd_message.raise_error;

3185: fnd_message.set_token('TOT_INS',to_char(g_tot_dpnt_lf_ins_amt_no));
3186: fnd_message.set_token
3187: ('MX_INS'
3188: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3189: fnd_message.raise_error;
3190: elsif (((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3191: < g_tot_sps_lf_ins_amt_no) then
3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));

Line 3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');

3188: ,to_char((g_mx_dpnt_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3189: fnd_message.raise_error;
3190: elsif (((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3191: < g_tot_sps_lf_ins_amt_no) then
3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));
3194: fnd_message.set_token('MX_INS',
3195: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3196: fnd_message.raise_error;

Line 3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));

3189: fnd_message.raise_error;
3190: elsif (((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3191: < g_tot_sps_lf_ins_amt_no) then
3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));
3194: fnd_message.set_token('MX_INS',
3195: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3196: fnd_message.raise_error;
3197: end if;

Line 3194: fnd_message.set_token('MX_INS',

3190: elsif (((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100)
3191: < g_tot_sps_lf_ins_amt_no) then
3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));
3194: fnd_message.set_token('MX_INS',
3195: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3196: fnd_message.raise_error;
3197: end if;
3198: end loop; -- Bug 4613929

Line 3196: fnd_message.raise_error;

3192: fnd_message.set_name('BEN','BEN_91591_SP_LF_INS_OVER_LMT');
3193: fnd_message.set_token('TOT_INS', to_char(g_tot_sps_lf_ins_amt_no));
3194: fnd_message.set_token('MX_INS',
3195: to_char((g_mx_sps_pct_prtt_lf * g_tot_ee_lf_ins_amt_no)/100));
3196: fnd_message.raise_error;
3197: end if;
3198: end loop; -- Bug 4613929
3199:
3200: -- Check for plan type in enrollment limitation

Line 3215: fnd_message.set_name('BEN','BEN_91587_PL_ENRD_GT_MX_ALWD'); /* Modified the above line to check for the flag from the pl_typ table instead of PTIP table*/

3211: , 101);
3212: if (g_pl_typ_tbl(i).tot_pl_enrld > g_pl_typ_tbl(i).mx_enrl_alwd_num
3213: and g_pl_typ_tbl(i).mx_enrl_alwd_num is not NULL
3214: and g_pl_typ_tbl(i).dpnt_cvd_by_othr_apls_flag = 'N') then /* and g_ptip_tbl(i).dpnt_cvd_by_othr_apls_flag = 'N') then Bug 2093956*/
3215: fnd_message.set_name('BEN','BEN_91587_PL_ENRD_GT_MX_ALWD'); /* Modified the above line to check for the flag from the pl_typ table instead of PTIP table*/
3216: fnd_message.set_token
3217: ('TOT_ENRD'
3218: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3219: fnd_message.set_token

Line 3216: fnd_message.set_token

3212: if (g_pl_typ_tbl(i).tot_pl_enrld > g_pl_typ_tbl(i).mx_enrl_alwd_num
3213: and g_pl_typ_tbl(i).mx_enrl_alwd_num is not NULL
3214: and g_pl_typ_tbl(i).dpnt_cvd_by_othr_apls_flag = 'N') then /* and g_ptip_tbl(i).dpnt_cvd_by_othr_apls_flag = 'N') then Bug 2093956*/
3215: fnd_message.set_name('BEN','BEN_91587_PL_ENRD_GT_MX_ALWD'); /* Modified the above line to check for the flag from the pl_typ table instead of PTIP table*/
3216: fnd_message.set_token
3217: ('TOT_ENRD'
3218: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3219: fnd_message.set_token
3220: ('MX_ENRL'

Line 3219: fnd_message.set_token

3215: fnd_message.set_name('BEN','BEN_91587_PL_ENRD_GT_MX_ALWD'); /* Modified the above line to check for the flag from the pl_typ table instead of PTIP table*/
3216: fnd_message.set_token
3217: ('TOT_ENRD'
3218: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3219: fnd_message.set_token
3220: ('MX_ENRL'
3221: , to_char(g_pl_typ_tbl(i).MX_ENRL_ALWD_NUM));
3222: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3223: fnd_message.raise_error;

Line 3222: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);

3218: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3219: fnd_message.set_token
3220: ('MX_ENRL'
3221: , to_char(g_pl_typ_tbl(i).MX_ENRL_ALWD_NUM));
3222: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3223: fnd_message.raise_error;
3224: elsif (g_pl_typ_tbl(i).tot_pl_enrld < g_pl_typ_tbl(i).mn_enrl_rqd_num
3225: and g_pl_typ_tbl(i).mn_enrl_rqd_num is not NULL ) then
3226: --

Line 3223: fnd_message.raise_error;

3219: fnd_message.set_token
3220: ('MX_ENRL'
3221: , to_char(g_pl_typ_tbl(i).MX_ENRL_ALWD_NUM));
3222: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3223: fnd_message.raise_error;
3224: elsif (g_pl_typ_tbl(i).tot_pl_enrld < g_pl_typ_tbl(i).mn_enrl_rqd_num
3225: and g_pl_typ_tbl(i).mn_enrl_rqd_num is not NULL ) then
3226: --
3227: l_erl := 'N';

Line 3237: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');

3233: --
3234: end if;
3235: if l_erl = 'N' then
3236: --
3237: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3238: /* fnd_message.set_token
3239: ('TOT_ENRD'
3240: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));*/ --Bug 5664907
3241: fnd_message.set_token

Line 3238: /* fnd_message.set_token

3234: end if;
3235: if l_erl = 'N' then
3236: --
3237: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3238: /* fnd_message.set_token
3239: ('TOT_ENRD'
3240: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));*/ --Bug 5664907
3241: fnd_message.set_token
3242: ('MN_ENRL'

Line 3241: fnd_message.set_token

3237: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
3238: /* fnd_message.set_token
3239: ('TOT_ENRD'
3240: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));*/ --Bug 5664907
3241: fnd_message.set_token
3242: ('MN_ENRL'
3243: ,to_char(g_pl_typ_tbl(i).MN_ENRL_RQD_NUM));
3244: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3245: fnd_message.raise_error;

Line 3244: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);

3240: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));*/ --Bug 5664907
3241: fnd_message.set_token
3242: ('MN_ENRL'
3243: ,to_char(g_pl_typ_tbl(i).MN_ENRL_RQD_NUM));
3244: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3245: fnd_message.raise_error;
3246: --
3247: end if;
3248: --

Line 3245: fnd_message.raise_error;

3241: fnd_message.set_token
3242: ('MN_ENRL'
3243: ,to_char(g_pl_typ_tbl(i).MN_ENRL_RQD_NUM));
3244: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3245: fnd_message.raise_error;
3246: --
3247: end if;
3248: --
3249: end if;

Line 3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');

3261: null;
3262: else
3263: if (g_pl_tbl(i).tot_opt_enrld > g_pl_tbl(i).mx_opts_alwd_num
3264: and g_pl_tbl(i).mx_opts_alwd_num is not NULL ) then
3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');
3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));
3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));
3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;

Line 3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));

3262: else
3263: if (g_pl_tbl(i).tot_opt_enrld > g_pl_tbl(i).mx_opts_alwd_num
3264: and g_pl_tbl(i).mx_opts_alwd_num is not NULL ) then
3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');
3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));
3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));
3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num

Line 3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));

3263: if (g_pl_tbl(i).tot_opt_enrld > g_pl_tbl(i).mx_opts_alwd_num
3264: and g_pl_tbl(i).mx_opts_alwd_num is not NULL ) then
3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');
3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));
3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));
3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then

Line 3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);

3264: and g_pl_tbl(i).mx_opts_alwd_num is not NULL ) then
3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');
3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));
3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));
3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');

Line 3269: fnd_message.raise_error;

3265: fnd_message.set_name('BEN','BEN_91592_OPT_ENRD_GT_MX_ALWD');
3266: fnd_message.set_token('OPT_ENRD',to_char(g_pl_tbl(i).tot_opt_enrld));
3267: fnd_message.set_token('MX_ALWD',to_char(g_pl_tbl(i).MX_OPTS_ALWD_NUM));
3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));

Line 3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');

3268: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));
3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));
3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3276: fnd_message.raise_error;

Line 3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));

3269: fnd_message.raise_error;
3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));
3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));
3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3276: fnd_message.raise_error;
3277: end if;

Line 3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));

3270: elsif (g_pl_tbl(i).tot_opt_enrld < g_pl_tbl(i).mn_opts_rqd_num
3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));
3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));
3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3276: fnd_message.raise_error;
3277: end if;
3278: /* BUG: 3949327:

Line 3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);

3271: and g_pl_tbl(i).mn_opts_rqd_num is not NULL) then
3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));
3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));
3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3276: fnd_message.raise_error;
3277: end if;
3278: /* BUG: 3949327:
3279: The below coverage amount limits validations need

Line 3276: fnd_message.raise_error;

3272: fnd_message.set_name('BEN','BEN_91593_OPT_ENRD_LT_MN_RQD');
3273: fnd_message.set_token('OPT_ENRD', to_char(g_pl_tbl(i).tot_opt_enrld));
3274: fnd_message.set_token('MN_RQD',to_char(g_pl_tbl(i).MN_OPTS_RQD_NUM));
3275: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3276: fnd_message.raise_error;
3277: end if;
3278: /* BUG: 3949327:
3279: The below coverage amount limits validations need
3280: to be performed only when enrolled into Plan.

Line 3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');

3307: l_step := 70;
3308: --
3309: if (g_pl_tbl(i).tot_cvg_amt < g_pl_tbl(i).mn_cvg_rqd_amt
3310: and g_pl_tbl(i).mn_cvg_rqd_amt is not NULL ) then
3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');
3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));
3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3315: fnd_message.raise_error;

Line 3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));

3308: --
3309: if (g_pl_tbl(i).tot_cvg_amt < g_pl_tbl(i).mn_cvg_rqd_amt
3310: and g_pl_tbl(i).mn_cvg_rqd_amt is not NULL ) then
3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');
3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));
3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3315: fnd_message.raise_error;
3316: end if;

Line 3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));

3309: if (g_pl_tbl(i).tot_cvg_amt < g_pl_tbl(i).mn_cvg_rqd_amt
3310: and g_pl_tbl(i).mn_cvg_rqd_amt is not NULL ) then
3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');
3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));
3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3315: fnd_message.raise_error;
3316: end if;
3317: --

Line 3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);

3310: and g_pl_tbl(i).mn_cvg_rqd_amt is not NULL ) then
3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');
3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));
3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3315: fnd_message.raise_error;
3316: end if;
3317: --
3318: -- Check max coverage amount.

Line 3315: fnd_message.raise_error;

3311: fnd_message.set_name('BEN','BEN_92286_PL_CVG_AMT_LT_MN_ALW');
3312: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3313: fnd_message.set_token('MN_AMT',to_char(g_pl_tbl(i).mn_cvg_rqd_amt));
3314: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3315: fnd_message.raise_error;
3316: end if;
3317: --
3318: -- Check max coverage amount.
3319: --

Line 3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');

3326: if g_pl_tbl(i).tot_cvg_amt > g_pl_tbl(i).mx_cvg_wcfn_amt then
3327: --
3328: -- Over top even with certification
3329: --
3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));
3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3334: fnd_message.raise_error;

Line 3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));

3327: --
3328: -- Over top even with certification
3329: --
3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));
3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3334: fnd_message.raise_error;
3335: elsif g_pl_tbl(i).mx_cvg_wcfn_amt is null then

Line 3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));

3328: -- Over top even with certification
3329: --
3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));
3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3334: fnd_message.raise_error;
3335: elsif g_pl_tbl(i).mx_cvg_wcfn_amt is null then
3336: --

Line 3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);

3329: --
3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));
3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3334: fnd_message.raise_error;
3335: elsif g_pl_tbl(i).mx_cvg_wcfn_amt is null then
3336: --
3337: -- Over top and no certification limit exists

Line 3334: fnd_message.raise_error;

3330: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3331: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3332: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_wcfn_AMT));
3333: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3334: fnd_message.raise_error;
3335: elsif g_pl_tbl(i).mx_cvg_wcfn_amt is null then
3336: --
3337: -- Over top and no certification limit exists
3338: --

Line 3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');

3335: elsif g_pl_tbl(i).mx_cvg_wcfn_amt is null then
3336: --
3337: -- Over top and no certification limit exists
3338: --
3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));
3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3343: fnd_message.raise_error;

Line 3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));

3336: --
3337: -- Over top and no certification limit exists
3338: --
3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));
3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3343: fnd_message.raise_error;
3344: end if;

Line 3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));

3337: -- Over top and no certification limit exists
3338: --
3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));
3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3343: fnd_message.raise_error;
3344: end if;
3345: end if;

Line 3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);

3338: --
3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));
3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3343: fnd_message.raise_error;
3344: end if;
3345: end if;
3346: --

Line 3343: fnd_message.raise_error;

3339: fnd_message.set_name('BEN','BEN_91589_PL_CVG_AMT_GT_MX_ALW');
3340: fnd_message.set_token('TOT_AMT',to_char(g_pl_tbl(i).tot_cvg_amt));
3341: fnd_message.set_token('MX_AMT',to_char(g_pl_tbl(i).MX_CVG_ALWD_AMT));
3342: fnd_message.set_token('PL_NAME', g_pl_tbl(i).name);
3343: fnd_message.raise_error;
3344: end if;
3345: end if;
3346: --
3347: -- Check max coverage increase amount.

Line 3367: fnd_message.set_name('BEN','BEN_91594_CERT_INCR_GT_MX_INCR');

3363: if l_increase > g_pl_tbl(i).mx_cvg_incr_wcf_alwd_amt then
3364: --
3365: -- Over top even with certification
3366: --
3367: fnd_message.set_name('BEN','BEN_91594_CERT_INCR_GT_MX_INCR');
3368: fnd_message.set_token('CERT_INCR',to_char(l_increase));
3369: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_WCF_ALWD_AMT));
3370: fnd_message.raise_error;
3371: --

Line 3368: fnd_message.set_token('CERT_INCR',to_char(l_increase));

3364: --
3365: -- Over top even with certification
3366: --
3367: fnd_message.set_name('BEN','BEN_91594_CERT_INCR_GT_MX_INCR');
3368: fnd_message.set_token('CERT_INCR',to_char(l_increase));
3369: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_WCF_ALWD_AMT));
3370: fnd_message.raise_error;
3371: --
3372: elsif g_pl_tbl(i).mx_cvg_incr_wcf_alwd_amt is null then

Line 3369: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_WCF_ALWD_AMT));

3365: -- Over top even with certification
3366: --
3367: fnd_message.set_name('BEN','BEN_91594_CERT_INCR_GT_MX_INCR');
3368: fnd_message.set_token('CERT_INCR',to_char(l_increase));
3369: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_WCF_ALWD_AMT));
3370: fnd_message.raise_error;
3371: --
3372: elsif g_pl_tbl(i).mx_cvg_incr_wcf_alwd_amt is null then
3373: --

Line 3370: fnd_message.raise_error;

3366: --
3367: fnd_message.set_name('BEN','BEN_91594_CERT_INCR_GT_MX_INCR');
3368: fnd_message.set_token('CERT_INCR',to_char(l_increase));
3369: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_WCF_ALWD_AMT));
3370: fnd_message.raise_error;
3371: --
3372: elsif g_pl_tbl(i).mx_cvg_incr_wcf_alwd_amt is null then
3373: --
3374: -- Over top and no certification limit exists

Line 3376: fnd_message.set_name('BEN','BEN_91596_CVG_INCR_GT_MX_INCR');

3372: elsif g_pl_tbl(i).mx_cvg_incr_wcf_alwd_amt is null then
3373: --
3374: -- Over top and no certification limit exists
3375: --
3376: fnd_message.set_name('BEN','BEN_91596_CVG_INCR_GT_MX_INCR');
3377: fnd_message.set_token('CVG_INCR',to_char(l_increase));
3378: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_ALWD_AMT));
3379: fnd_message.raise_error;
3380: end if;

Line 3377: fnd_message.set_token('CVG_INCR',to_char(l_increase));

3373: --
3374: -- Over top and no certification limit exists
3375: --
3376: fnd_message.set_name('BEN','BEN_91596_CVG_INCR_GT_MX_INCR');
3377: fnd_message.set_token('CVG_INCR',to_char(l_increase));
3378: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_ALWD_AMT));
3379: fnd_message.raise_error;
3380: end if;
3381: --

Line 3378: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_ALWD_AMT));

3374: -- Over top and no certification limit exists
3375: --
3376: fnd_message.set_name('BEN','BEN_91596_CVG_INCR_GT_MX_INCR');
3377: fnd_message.set_token('CVG_INCR',to_char(l_increase));
3378: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_ALWD_AMT));
3379: fnd_message.raise_error;
3380: end if;
3381: --
3382: end if;

Line 3379: fnd_message.raise_error;

3375: --
3376: fnd_message.set_name('BEN','BEN_91596_CVG_INCR_GT_MX_INCR');
3377: fnd_message.set_token('CVG_INCR',to_char(l_increase));
3378: fnd_message.set_token('MX_INCR',to_char(g_pl_tbl(i).MX_CVG_INCR_ALWD_AMT));
3379: fnd_message.raise_error;
3380: end if;
3381: --
3382: end if;
3383: --

Line 3508: fnd_message.set_name('BEN','BEN_91699_DUP_COMP_OBJ_IN_PGM');

3504: (g_enrt_tbl(i).enrt_cvg_strt_dt between
3505: l_prev_cvg_strt_dt
3506: and nvl(l_prev_cvg_end_dt,hr_api.g_eot)) then
3507: --
3508: fnd_message.set_name('BEN','BEN_91699_DUP_COMP_OBJ_IN_PGM');
3509: fnd_message.set_token
3510: ('PL_NAME'
3511: ,get_plan_name(p_pl_id => g_enrt_tbl(i).pl_id
3512: ,p_business_group_id => p_business_group_id

Line 3509: fnd_message.set_token

3505: l_prev_cvg_strt_dt
3506: and nvl(l_prev_cvg_end_dt,hr_api.g_eot)) then
3507: --
3508: fnd_message.set_name('BEN','BEN_91699_DUP_COMP_OBJ_IN_PGM');
3509: fnd_message.set_token
3510: ('PL_NAME'
3511: ,get_plan_name(p_pl_id => g_enrt_tbl(i).pl_id
3512: ,p_business_group_id => p_business_group_id
3513: ,p_effective_date => p_effective_date

Line 3516: fnd_message.raise_error;

3512: ,p_business_group_id => p_business_group_id
3513: ,p_effective_date => p_effective_date
3514: )
3515: );
3516: fnd_message.raise_error;
3517: --
3518: end if;
3519: --
3520: end if;

Line 3537: fnd_message.set_name('BEN','BEN_91597_MUST_ENRL_PLAN');

3533: exit;
3534: end if;
3535: end loop;
3536: if (l_pl_notfnd) then
3537: fnd_message.set_name('BEN','BEN_91597_MUST_ENRL_PLAN');
3538: fnd_message.set_token('PL_ID', g_enrt_tbl(i).pl_id);
3539: fnd_message.set_token
3540: ('RQD_PL'
3541: ,get_plan_name

Line 3538: fnd_message.set_token('PL_ID', g_enrt_tbl(i).pl_id);

3534: end if;
3535: end loop;
3536: if (l_pl_notfnd) then
3537: fnd_message.set_name('BEN','BEN_91597_MUST_ENRL_PLAN');
3538: fnd_message.set_token('PL_ID', g_enrt_tbl(i).pl_id);
3539: fnd_message.set_token
3540: ('RQD_PL'
3541: ,get_plan_name
3542: (p_pl_id=> g_enrt_tbl(i).must_enrl_anthr_pl_id

Line 3539: fnd_message.set_token

3535: end loop;
3536: if (l_pl_notfnd) then
3537: fnd_message.set_name('BEN','BEN_91597_MUST_ENRL_PLAN');
3538: fnd_message.set_token('PL_ID', g_enrt_tbl(i).pl_id);
3539: fnd_message.set_token
3540: ('RQD_PL'
3541: ,get_plan_name
3542: (p_pl_id=> g_enrt_tbl(i).must_enrl_anthr_pl_id
3543: ,p_business_group_id => p_business_group_id

Line 3547: fnd_message.raise_error;

3543: ,p_business_group_id => p_business_group_id
3544: ,p_effective_date => p_effective_date
3545: )
3546: );
3547: fnd_message.raise_error;
3548: end if;
3549: end if;
3550: end if;
3551: end loop;

Line 3573: fnd_message.set_name('BEN','BEN_91598_OPT_NOT_COORD');

3569: l_prev_opt_id := g_enrt_tbl(j).opt_id;
3570: l_prev_ptip_name := g_ptip_tbl(i).name;
3571: l_init_flag := FALSE;
3572: elsif (l_prev_opt_id <> g_enrt_tbl(j).opt_id) then
3573: fnd_message.set_name('BEN','BEN_91598_OPT_NOT_COORD');
3574: fnd_message.set_token('PTIP_NAME1',g_ptip_tbl(i).name);
3575: fnd_message.set_token('PTIP_NAME2',l_prev_ptip_name);
3576: fnd_message.raise_error;
3577: end if;

Line 3574: fnd_message.set_token('PTIP_NAME1',g_ptip_tbl(i).name);

3570: l_prev_ptip_name := g_ptip_tbl(i).name;
3571: l_init_flag := FALSE;
3572: elsif (l_prev_opt_id <> g_enrt_tbl(j).opt_id) then
3573: fnd_message.set_name('BEN','BEN_91598_OPT_NOT_COORD');
3574: fnd_message.set_token('PTIP_NAME1',g_ptip_tbl(i).name);
3575: fnd_message.set_token('PTIP_NAME2',l_prev_ptip_name);
3576: fnd_message.raise_error;
3577: end if;
3578: --

Line 3575: fnd_message.set_token('PTIP_NAME2',l_prev_ptip_name);

3571: l_init_flag := FALSE;
3572: elsif (l_prev_opt_id <> g_enrt_tbl(j).opt_id) then
3573: fnd_message.set_name('BEN','BEN_91598_OPT_NOT_COORD');
3574: fnd_message.set_token('PTIP_NAME1',g_ptip_tbl(i).name);
3575: fnd_message.set_token('PTIP_NAME2',l_prev_ptip_name);
3576: fnd_message.raise_error;
3577: end if;
3578: --
3579: end if;

Line 3576: fnd_message.raise_error;

3572: elsif (l_prev_opt_id <> g_enrt_tbl(j).opt_id) then
3573: fnd_message.set_name('BEN','BEN_91598_OPT_NOT_COORD');
3574: fnd_message.set_token('PTIP_NAME1',g_ptip_tbl(i).name);
3575: fnd_message.set_token('PTIP_NAME2',l_prev_ptip_name);
3576: fnd_message.raise_error;
3577: end if;
3578: --
3579: end if;
3580: --

Line 3635: benutils.write(p_text=>fnd_message.get);

3631: --
3632: hr_utility.set_location('Entering:'||l_proc, 5);
3633: --
3634: if p_enrt_cvg_strt_dt > p_enrt_cvg_thru_dt then
3635: benutils.write(p_text=>fnd_message.get);
3636: ben_warnings.load_warning
3637: (p_application_short_name => 'BEN'
3638: ,p_message_name => l_message_name
3639: ,p_parma => 'Coverage End Date' || ' ' || fnd_date.date_to_displaydate(p_enrt_cvg_thru_dt)

Line 3787: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

3783: --
3784: -- An unhandled or unexpected error has occurred which
3785: -- we must report
3786: --
3787: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3788: fnd_message.set_token('PROCEDURE', l_proc);
3789: fnd_message.set_token('STEP','15');
3790: fnd_message.raise_error;
3791: End dt_update_validate;

Line 3788: fnd_message.set_token('PROCEDURE', l_proc);

3784: -- An unhandled or unexpected error has occurred which
3785: -- we must report
3786: --
3787: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3788: fnd_message.set_token('PROCEDURE', l_proc);
3789: fnd_message.set_token('STEP','15');
3790: fnd_message.raise_error;
3791: End dt_update_validate;
3792: --

Line 3789: fnd_message.set_token('STEP','15');

3785: -- we must report
3786: --
3787: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3788: fnd_message.set_token('PROCEDURE', l_proc);
3789: fnd_message.set_token('STEP','15');
3790: fnd_message.raise_error;
3791: End dt_update_validate;
3792: --
3793: -- ----------------------------------------------------------------------------

Line 3790: fnd_message.raise_error;

3786: --
3787: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3788: fnd_message.set_token('PROCEDURE', l_proc);
3789: fnd_message.set_token('STEP','15');
3790: fnd_message.raise_error;
3791: End dt_update_validate;
3792: --
3793: -- ----------------------------------------------------------------------------
3794: -- |--------------------------< dt_delete_validate >--------------------------|

Line 3939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

3935: --
3936: -- An unhandled or unexpected error has occurred which
3937: -- we must report
3938: --
3939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3940: fnd_message.set_token('PROCEDURE', l_proc);
3941: fnd_message.set_token('STEP','15');
3942: fnd_message.raise_error;
3943: End dt_delete_validate;

Line 3940: fnd_message.set_token('PROCEDURE', l_proc);

3936: -- An unhandled or unexpected error has occurred which
3937: -- we must report
3938: --
3939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3940: fnd_message.set_token('PROCEDURE', l_proc);
3941: fnd_message.set_token('STEP','15');
3942: fnd_message.raise_error;
3943: End dt_delete_validate;
3944: --

Line 3941: fnd_message.set_token('STEP','15');

3937: -- we must report
3938: --
3939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3940: fnd_message.set_token('PROCEDURE', l_proc);
3941: fnd_message.set_token('STEP','15');
3942: fnd_message.raise_error;
3943: End dt_delete_validate;
3944: --
3945: -- ----------------------------------------------------------------------------

Line 3942: fnd_message.raise_error;

3938: --
3939: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3940: fnd_message.set_token('PROCEDURE', l_proc);
3941: fnd_message.set_token('STEP','15');
3942: fnd_message.raise_error;
3943: End dt_delete_validate;
3944: --
3945: -- ----------------------------------------------------------------------------
3946: -- |---------------------------< insert_validate >----------------------------|

Line 4294: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

4290: close csr_leg_code;
4291: --
4292: -- The primary key is invalid therefore we must error
4293: --
4294: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
4295: fnd_message.raise_error;
4296: --
4297: end if;
4298: --

Line 4295: fnd_message.raise_error;

4291: --
4292: -- The primary key is invalid therefore we must error
4293: --
4294: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
4295: fnd_message.raise_error;
4296: --
4297: end if;
4298: --
4299: close csr_leg_code;