DBA Data[Home] [Help]

APPS.BEN_PRV_BUS dependencies on FND_MESSAGE

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

289: p_effective_date => p_effective_date) then
290: --
291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
294: fnd_message.set_token('FIELD', p_cmcd_ref_perd_cd);
295: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
296: fnd_message.raise_error;
297: --

Line 294: fnd_message.set_token('FIELD', p_cmcd_ref_perd_cd);

290: --
291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
294: fnd_message.set_token('FIELD', p_cmcd_ref_perd_cd);
295: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
296: fnd_message.raise_error;
297: --
298: end if;

Line 295: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');

291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
294: fnd_message.set_token('FIELD', p_cmcd_ref_perd_cd);
295: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
296: fnd_message.raise_error;
297: --
298: end if;
299: --

Line 296: fnd_message.raise_error;

292: --
293: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
294: fnd_message.set_token('FIELD', p_cmcd_ref_perd_cd);
295: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
296: fnd_message.raise_error;
297: --
298: end if;
299: --
300: end if;

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

358: p_effective_date => p_effective_date) then
359: --
360: -- raise error as does not exist as lookup
361: --
362: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
363: fnd_message.set_token('FIELD', p_prtt_rt_val_stat_cd);
364: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
365: fnd_message.raise_error;
366: --

Line 363: fnd_message.set_token('FIELD', p_prtt_rt_val_stat_cd);

359: --
360: -- raise error as does not exist as lookup
361: --
362: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
363: fnd_message.set_token('FIELD', p_prtt_rt_val_stat_cd);
364: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
365: fnd_message.raise_error;
366: --
367: end if;

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

360: -- raise error as does not exist as lookup
361: --
362: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
363: fnd_message.set_token('FIELD', p_prtt_rt_val_stat_cd);
364: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
365: fnd_message.raise_error;
366: --
367: end if;
368: --

Line 365: fnd_message.raise_error;

361: --
362: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
363: fnd_message.set_token('FIELD', p_prtt_rt_val_stat_cd);
364: fnd_message.set_token('TYPE','BEN_PRTT_ENRT_RSLT_STAT');
365: fnd_message.raise_error;
366: --
367: end if;
368: --
369: end if;

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

428: p_effective_date => p_effective_date) then
429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
433: fnd_message.set_token('FIELD', p_bnft_rt_typ_cd);
434: fnd_message.set_token('TYPE','BEN_RT_TYP');
435: fnd_message.raise_error;
436: --

Line 433: fnd_message.set_token('FIELD', p_bnft_rt_typ_cd);

429: --
430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
433: fnd_message.set_token('FIELD', p_bnft_rt_typ_cd);
434: fnd_message.set_token('TYPE','BEN_RT_TYP');
435: fnd_message.raise_error;
436: --
437: end if;

Line 434: fnd_message.set_token('TYPE','BEN_RT_TYP');

430: -- raise error as does not exist as lookup
431: --
432: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
433: fnd_message.set_token('FIELD', p_bnft_rt_typ_cd);
434: fnd_message.set_token('TYPE','BEN_RT_TYP');
435: fnd_message.raise_error;
436: --
437: end if;
438: --

Line 435: fnd_message.raise_error;

431: --
432: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
433: fnd_message.set_token('FIELD', p_bnft_rt_typ_cd);
434: fnd_message.set_token('TYPE','BEN_RT_TYP');
435: fnd_message.raise_error;
436: --
437: end if;
438: --
439: end if;

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

498: p_effective_date => p_effective_date) then
499: --
500: -- raise error as does not exist as lookup
501: --
502: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
503: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
504: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
505: fnd_message.raise_error;
506: --

Line 503: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);

499: --
500: -- raise error as does not exist as lookup
501: --
502: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
503: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
504: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
505: fnd_message.raise_error;
506: --
507: end if;

Line 504: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');

500: -- raise error as does not exist as lookup
501: --
502: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
503: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
504: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
505: fnd_message.raise_error;
506: --
507: end if;
508: --

Line 505: fnd_message.raise_error;

501: --
502: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
503: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
504: fnd_message.set_token('TYPE','BEN_ACTY_REF_PERD');
505: fnd_message.raise_error;
506: --
507: end if;
508: --
509: end if;

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

568: p_effective_date => p_effective_date) then
569: --
570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', p_mlt_cd);
574: fnd_message.set_token('TYPE','BEN_MLT');
575: fnd_message.raise_error;
576: --

Line 573: fnd_message.set_token('FIELD', p_mlt_cd);

569: --
570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', p_mlt_cd);
574: fnd_message.set_token('TYPE','BEN_MLT');
575: fnd_message.raise_error;
576: --
577: end if;

Line 574: fnd_message.set_token('TYPE','BEN_MLT');

570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', p_mlt_cd);
574: fnd_message.set_token('TYPE','BEN_MLT');
575: fnd_message.raise_error;
576: --
577: end if;
578: --

Line 575: fnd_message.raise_error;

571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', p_mlt_cd);
574: fnd_message.set_token('TYPE','BEN_MLT');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: end if;

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

638: p_effective_date => p_effective_date) then
639: --
640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD', p_acty_typ_cd);
644: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
645: fnd_message.raise_error;
646: --

Line 643: fnd_message.set_token('FIELD', p_acty_typ_cd);

639: --
640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD', p_acty_typ_cd);
644: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
645: fnd_message.raise_error;
646: --
647: end if;

Line 644: fnd_message.set_token('TYPE','BEN_ACTY_TYP');

640: -- raise error as does not exist as lookup
641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD', p_acty_typ_cd);
644: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
645: fnd_message.raise_error;
646: --
647: end if;
648: --

Line 645: fnd_message.raise_error;

641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD', p_acty_typ_cd);
644: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
649: end if;

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

708: p_effective_date => p_effective_date) then
709: --
710: -- raise error as does not exist as lookup
711: --
712: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
713: fnd_message.set_token('FIELD', p_tx_typ_cd);
714: fnd_message.set_token('TYPE','BEN_TX_TYP');
715: fnd_message.raise_error;
716: --

Line 713: fnd_message.set_token('FIELD', p_tx_typ_cd);

709: --
710: -- raise error as does not exist as lookup
711: --
712: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
713: fnd_message.set_token('FIELD', p_tx_typ_cd);
714: fnd_message.set_token('TYPE','BEN_TX_TYP');
715: fnd_message.raise_error;
716: --
717: end if;

Line 714: fnd_message.set_token('TYPE','BEN_TX_TYP');

710: -- raise error as does not exist as lookup
711: --
712: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
713: fnd_message.set_token('FIELD', p_tx_typ_cd);
714: fnd_message.set_token('TYPE','BEN_TX_TYP');
715: fnd_message.raise_error;
716: --
717: end if;
718: --

Line 715: fnd_message.raise_error;

711: --
712: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
713: fnd_message.set_token('FIELD', p_tx_typ_cd);
714: fnd_message.set_token('TYPE','BEN_TX_TYP');
715: fnd_message.raise_error;
716: --
717: end if;
718: --
719: end if;

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

778: p_effective_date => p_effective_date) then
779: --
780: -- raise error as does not exist as lookup
781: --
782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
783: fnd_message.set_token('FIELD', p_rt_typ_cd);
784: fnd_message.set_token('TYPE','BEN_RT_TYP');
785: fnd_message.raise_error;
786: --

Line 783: fnd_message.set_token('FIELD', p_rt_typ_cd);

779: --
780: -- raise error as does not exist as lookup
781: --
782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
783: fnd_message.set_token('FIELD', p_rt_typ_cd);
784: fnd_message.set_token('TYPE','BEN_RT_TYP');
785: fnd_message.raise_error;
786: --
787: end if;

Line 784: fnd_message.set_token('TYPE','BEN_RT_TYP');

780: -- raise error as does not exist as lookup
781: --
782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
783: fnd_message.set_token('FIELD', p_rt_typ_cd);
784: fnd_message.set_token('TYPE','BEN_RT_TYP');
785: fnd_message.raise_error;
786: --
787: end if;
788: --

Line 785: fnd_message.raise_error;

781: --
782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
783: fnd_message.set_token('FIELD', p_rt_typ_cd);
784: fnd_message.set_token('TYPE','BEN_RT_TYP');
785: fnd_message.raise_error;
786: --
787: end if;
788: --
789: end if;

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

848: p_effective_date => p_effective_date) then
849: --
850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD', p_rt_ovridn_flag);
854: fnd_message.set_token('TYPE','YES_NO');
855: fnd_message.raise_error;
856: --

Line 853: fnd_message.set_token('FIELD', p_rt_ovridn_flag);

849: --
850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD', p_rt_ovridn_flag);
854: fnd_message.set_token('TYPE','YES_NO');
855: fnd_message.raise_error;
856: --
857: end if;

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

850: -- raise error as does not exist as lookup
851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD', p_rt_ovridn_flag);
854: fnd_message.set_token('TYPE','YES_NO');
855: fnd_message.raise_error;
856: --
857: end if;
858: --

Line 855: fnd_message.raise_error;

851: --
852: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
853: fnd_message.set_token('FIELD', p_rt_ovridn_flag);
854: fnd_message.set_token('TYPE','YES_NO');
855: fnd_message.raise_error;
856: --
857: end if;
858: --
859: end if;

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

918: p_effective_date => p_effective_date) then
919: --
920: -- raise error as does not exist as lookup
921: --
922: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
923: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
924: fnd_message.set_token('TYPE','YES_NO');
925: fnd_message.raise_error;
926: --

Line 923: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);

919: --
920: -- raise error as does not exist as lookup
921: --
922: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
923: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
924: fnd_message.set_token('TYPE','YES_NO');
925: fnd_message.raise_error;
926: --
927: end if;

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

920: -- raise error as does not exist as lookup
921: --
922: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
923: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
924: fnd_message.set_token('TYPE','YES_NO');
925: fnd_message.raise_error;
926: --
927: end if;
928: --

Line 925: fnd_message.raise_error;

921: --
922: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
923: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
924: fnd_message.set_token('TYPE','YES_NO');
925: fnd_message.raise_error;
926: --
927: end if;
928: --
929: end if;

Line 1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');

1134: close c_chc;
1135: open c_pln (c_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id);
1136: fetch c_pln into l_pln_name;
1137: close c_pln;
1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);
1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);
1141: fnd_message.set_token('PLOPT',l_pln_name);
1142: fnd_message.raise_error;

Line 1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);

1135: open c_pln (c_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id);
1136: fetch c_pln into l_pln_name;
1137: close c_pln;
1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);
1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);
1141: fnd_message.set_token('PLOPT',l_pln_name);
1142: fnd_message.raise_error;
1143: END IF;

Line 1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);

1136: fetch c_pln into l_pln_name;
1137: close c_pln;
1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);
1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);
1141: fnd_message.set_token('PLOPT',l_pln_name);
1142: fnd_message.raise_error;
1143: END IF;
1144: --

Line 1141: fnd_message.set_token('PLOPT',l_pln_name);

1137: close c_pln;
1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);
1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);
1141: fnd_message.set_token('PLOPT',l_pln_name);
1142: fnd_message.raise_error;
1143: END IF;
1144: --
1145: -- Bug 2438533 Added this for checking annual increment values

Line 1142: fnd_message.raise_error;

1138: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1139: fnd_message.set_token('MIN',l_ann_mn_elcn_val);
1140: fnd_message.set_token('MAX',l_ann_mx_elcn_val);
1141: fnd_message.set_token('PLOPT',l_pln_name);
1142: fnd_message.raise_error;
1143: END IF;
1144: --
1145: -- Bug 2438533 Added this for checking annual increment values
1146: --

Line 1160: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');

1156:
1157: --
1158: -- raise error is not multiple of increment
1159: --
1160: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1161: fnd_message.set_token('INCREMENT', l_c1.incrmt_elcn_val);
1162: fnd_message.set_token('PLAN', l_pln_name);
1163:
1164: fnd_message.raise_error;

Line 1161: fnd_message.set_token('INCREMENT', l_c1.incrmt_elcn_val);

1157: --
1158: -- raise error is not multiple of increment
1159: --
1160: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1161: fnd_message.set_token('INCREMENT', l_c1.incrmt_elcn_val);
1162: fnd_message.set_token('PLAN', l_pln_name);
1163:
1164: fnd_message.raise_error;
1165: END IF;

Line 1162: fnd_message.set_token('PLAN', l_pln_name);

1158: -- raise error is not multiple of increment
1159: --
1160: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1161: fnd_message.set_token('INCREMENT', l_c1.incrmt_elcn_val);
1162: fnd_message.set_token('PLAN', l_pln_name);
1163:
1164: fnd_message.raise_error;
1165: END IF;
1166: End if;

Line 1164: fnd_message.raise_error;

1160: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1161: fnd_message.set_token('INCREMENT', l_c1.incrmt_elcn_val);
1162: fnd_message.set_token('PLAN', l_pln_name);
1163:
1164: fnd_message.raise_error;
1165: END IF;
1166: End if;
1167: End if;
1168: --

Line 1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');

1329: close c_chc;
1330: open c_pln (c_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id);
1331: fetch c_pln into l_pln_name;
1332: close c_pln;
1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1334: fnd_message.set_token('MIN', l_min);
1335: fnd_message.set_token('MAX', l_max);
1336: fnd_message.set_token('PLOPT', l_pln_name);
1337: fnd_message.raise_error;

Line 1334: fnd_message.set_token('MIN', l_min);

1330: open c_pln (c_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id);
1331: fetch c_pln into l_pln_name;
1332: close c_pln;
1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1334: fnd_message.set_token('MIN', l_min);
1335: fnd_message.set_token('MAX', l_max);
1336: fnd_message.set_token('PLOPT', l_pln_name);
1337: fnd_message.raise_error;
1338: --

Line 1335: fnd_message.set_token('MAX', l_max);

1331: fetch c_pln into l_pln_name;
1332: close c_pln;
1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1334: fnd_message.set_token('MIN', l_min);
1335: fnd_message.set_token('MAX', l_max);
1336: fnd_message.set_token('PLOPT', l_pln_name);
1337: fnd_message.raise_error;
1338: --
1339: elsif (mod(p_rt_val,l_incrt)<>0) then

Line 1336: fnd_message.set_token('PLOPT', l_pln_name);

1332: close c_pln;
1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1334: fnd_message.set_token('MIN', l_min);
1335: fnd_message.set_token('MAX', l_max);
1336: fnd_message.set_token('PLOPT', l_pln_name);
1337: fnd_message.raise_error;
1338: --
1339: elsif (mod(p_rt_val,l_incrt)<>0) then
1340: --

Line 1337: fnd_message.raise_error;

1333: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1334: fnd_message.set_token('MIN', l_min);
1335: fnd_message.set_token('MAX', l_max);
1336: fnd_message.set_token('PLOPT', l_pln_name);
1337: fnd_message.raise_error;
1338: --
1339: elsif (mod(p_rt_val,l_incrt)<>0) then
1340: --
1341: -- raise error is not multiple of increment

Line 1354: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');

1350:
1351: --
1352: -- raise error is not multiple of increment
1353: --
1354: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1355: fnd_message.set_token('INCREMENT', l_incrt);
1356: fnd_message.set_token('PLAN', l_pln_name);
1357: fnd_message.raise_error;
1358: end if;

Line 1355: fnd_message.set_token('INCREMENT', l_incrt);

1351: --
1352: -- raise error is not multiple of increment
1353: --
1354: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1355: fnd_message.set_token('INCREMENT', l_incrt);
1356: fnd_message.set_token('PLAN', l_pln_name);
1357: fnd_message.raise_error;
1358: end if;
1359: end if ;

Line 1356: fnd_message.set_token('PLAN', l_pln_name);

1352: -- raise error is not multiple of increment
1353: --
1354: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1355: fnd_message.set_token('INCREMENT', l_incrt);
1356: fnd_message.set_token('PLAN', l_pln_name);
1357: fnd_message.raise_error;
1358: end if;
1359: end if ;
1360: elsif p_enrt_rt_id is not null and p_rt_val is null then

Line 1357: fnd_message.raise_error;

1353: --
1354: fnd_message.set_name('BEN','BEN_91932_NOT_INCREMENT');
1355: fnd_message.set_token('INCREMENT', l_incrt);
1356: fnd_message.set_token('PLAN', l_pln_name);
1357: fnd_message.raise_error;
1358: end if;
1359: end if ;
1360: elsif p_enrt_rt_id is not null and p_rt_val is null then
1361: --

Line 1388: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');

1384: open c_pln (c_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id);
1385: fetch c_pln into l_pln_name;
1386: close c_pln;
1387: --
1388: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1389: fnd_message.set_token('PLOPT', l_pln_name);
1390: --
1391: if l_entr_ann_val_flag = 'N' then
1392: --

Line 1389: fnd_message.set_token('PLOPT', l_pln_name);

1385: fetch c_pln into l_pln_name;
1386: close c_pln;
1387: --
1388: fnd_message.set_name('BEN','BEN_91939_NOT_IN_RANGE');
1389: fnd_message.set_token('PLOPT', l_pln_name);
1390: --
1391: if l_entr_ann_val_flag = 'N' then
1392: --
1393: fnd_message.set_token('MIN',l_min);

Line 1393: fnd_message.set_token('MIN',l_min);

1389: fnd_message.set_token('PLOPT', l_pln_name);
1390: --
1391: if l_entr_ann_val_flag = 'N' then
1392: --
1393: fnd_message.set_token('MIN',l_min);
1394: fnd_message.set_token('MAX',l_max);
1395: --
1396: elsif l_entr_ann_val_flag = 'Y' then
1397: --

Line 1394: fnd_message.set_token('MAX',l_max);

1390: --
1391: if l_entr_ann_val_flag = 'N' then
1392: --
1393: fnd_message.set_token('MIN',l_min);
1394: fnd_message.set_token('MAX',l_max);
1395: --
1396: elsif l_entr_ann_val_flag = 'Y' then
1397: --
1398: fnd_message.set_token('MIN',l_ann_min);

Line 1398: fnd_message.set_token('MIN',l_ann_min);

1394: fnd_message.set_token('MAX',l_max);
1395: --
1396: elsif l_entr_ann_val_flag = 'Y' then
1397: --
1398: fnd_message.set_token('MIN',l_ann_min);
1399: fnd_message.set_token('MAX',l_ann_max);
1400: --
1401: end if;
1402: --

Line 1399: fnd_message.set_token('MAX',l_ann_max);

1395: --
1396: elsif l_entr_ann_val_flag = 'Y' then
1397: --
1398: fnd_message.set_token('MIN',l_ann_min);
1399: fnd_message.set_token('MAX',l_ann_max);
1400: --
1401: end if;
1402: --
1403: fnd_message.raise_error;

Line 1403: fnd_message.raise_error;

1399: fnd_message.set_token('MAX',l_ann_max);
1400: --
1401: end if;
1402: --
1403: fnd_message.raise_error;
1404: --
1405: end if;
1406: --
1407: end if;

Line 1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');

1473: l_error := true;
1474: end if;
1475: --
1476: if l_error then
1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1478: fnd_message.set_token('PROC',l_proc);
1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1480: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1481: fnd_message.raise_error;

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

1474: end if;
1475: --
1476: if l_error then
1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1478: fnd_message.set_token('PROC',l_proc);
1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1480: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1481: fnd_message.raise_error;
1482: end if;

Line 1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

1475: --
1476: if l_error then
1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1478: fnd_message.set_token('PROC',l_proc);
1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1480: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1481: fnd_message.raise_error;
1482: end if;
1483: end if;

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

1476: if l_error then
1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1478: fnd_message.set_token('PROC',l_proc);
1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1480: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1481: fnd_message.raise_error;
1482: end if;
1483: end if;
1484: --

Line 1481: fnd_message.raise_error;

1477: fnd_message.set_name('BEN','BEN_91723_NO_ENRT_RT_ABR_FOUND');
1478: fnd_message.set_token('PROC',l_proc);
1479: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
1480: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1481: fnd_message.raise_error;
1482: end if;
1483: end if;
1484: --
1485: hr_utility.set_location('Leaving:'||l_proc,10);

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

1517: fetch c_person_id into l_person_id;
1518: close c_person_id;
1519: --
1520: if p_rt_strt_dt > p_rt_end_dt then
1521: benutils.write(p_text=>fnd_message.get);
1522: ben_warnings.load_warning
1523: (p_application_short_name => 'BEN'
1524: ,p_message_name => l_message_name
1525: ,p_parma => 'Rate End Date' || ' ' || fnd_date.date_to_displaydate(p_rt_end_dt)

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

1854: close csr_leg_code;
1855: --
1856: -- The primary key is invalid therefore we must error
1857: --
1858: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1859: fnd_message.raise_error;
1860: --
1861: end if;
1862: --

Line 1859: fnd_message.raise_error;

1855: --
1856: -- The primary key is invalid therefore we must error
1857: --
1858: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1859: fnd_message.raise_error;
1860: --
1861: end if;
1862: --
1863: close csr_leg_code;