DBA Data[Home] [Help]

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 1850: fnd_message.set_name('BEN','BEN_91468_PGM_MISSING');

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

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

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

Line 1852: fnd_message.raise_error;

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

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

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

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

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

Line 1885: fnd_message.raise_error;

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

Line 1909: fnd_message.set_name

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

Line 1911: fnd_message.set_token

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

Line 1913: fnd_message.raise_error;

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

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

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

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

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

Line 1967: fnd_message.raise_error;

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

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

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

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

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

Line 1995: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 2306: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 2320: fnd_message.raise_error;

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

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

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

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

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

Line 2330: fnd_message.raise_error;

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

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

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

Line 2552: fnd_message.raise_error;

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

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

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

Line 2624: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 2989: fnd_message.raise_error;

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

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

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

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

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

Line 3069: fnd_message.set_token

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

Line 3072: fnd_message.set_token

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

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

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

Line 3076: fnd_message.raise_error;

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

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

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

Line 3091: /* fnd_message.set_token

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

Line 3094: fnd_message.set_token

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

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

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

Line 3098: fnd_message.raise_error;

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

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

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

Line 3110: fnd_message.set_token

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

Line 3113: fnd_message.set_token

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

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

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

Line 3117: fnd_message.raise_error;

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

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

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

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

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

Line 3164: fnd_message.set_token

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

Line 3167: fnd_message.raise_error;

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

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

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

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

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

Line 3172: fnd_message.set_token('MX_INS',

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

Line 3174: fnd_message.raise_error;

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

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

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

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

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

Line 3185: fnd_message.set_token

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

Line 3188: fnd_message.raise_error;

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

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

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

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

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

Line 3193: fnd_message.set_token('MX_INS',

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

Line 3195: fnd_message.raise_error;

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

Line 3214: 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*/

3210: , 101);
3211: if (g_pl_typ_tbl(i).tot_pl_enrld > g_pl_typ_tbl(i).mx_enrl_alwd_num
3212: and g_pl_typ_tbl(i).mx_enrl_alwd_num is not NULL
3213: 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*/
3214: 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*/
3215: fnd_message.set_token
3216: ('TOT_ENRD'
3217: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3218: fnd_message.set_token

Line 3215: fnd_message.set_token

3211: if (g_pl_typ_tbl(i).tot_pl_enrld > g_pl_typ_tbl(i).mx_enrl_alwd_num
3212: and g_pl_typ_tbl(i).mx_enrl_alwd_num is not NULL
3213: 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*/
3214: 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*/
3215: fnd_message.set_token
3216: ('TOT_ENRD'
3217: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3218: fnd_message.set_token
3219: ('MX_ENRL'

Line 3218: fnd_message.set_token

3214: 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*/
3215: fnd_message.set_token
3216: ('TOT_ENRD'
3217: ,to_char(g_pl_typ_tbl(i).tot_pl_enrld));
3218: fnd_message.set_token
3219: ('MX_ENRL'
3220: , to_char(g_pl_typ_tbl(i).MX_ENRL_ALWD_NUM));
3221: fnd_message.set_token('PL_TYP_NAME', g_pl_typ_tbl(i).name);
3222: fnd_message.raise_error;

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

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

Line 3222: fnd_message.raise_error;

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

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

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

Line 3237: /* fnd_message.set_token

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

Line 3240: fnd_message.set_token

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

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

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

Line 3244: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3268: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3275: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3314: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3333: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3342: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 3369: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 3378: fnd_message.raise_error;

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

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

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

Line 3508: fnd_message.set_token

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

Line 3515: fnd_message.raise_error;

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

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

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

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

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

Line 3538: fnd_message.set_token

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

Line 3546: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 3575: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 3789: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 3941: fnd_message.raise_error;

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

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

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

Line 4294: fnd_message.raise_error;

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