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