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

APPS.BEN_PEL_BUS dependencies on FND_MESSAGE

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

133: --
134: -- raise error as does not exist as lookup
135: --
136: close c1;
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', p_uom );
139: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
140: fnd_message.raise_error;
141: end if;

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

134: -- raise error as does not exist as lookup
135: --
136: close c1;
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', p_uom );
139: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
140: fnd_message.raise_error;
141: end if;
142: close c1;

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

135: --
136: close c1;
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', p_uom );
139: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
140: fnd_message.raise_error;
141: end if;
142: close c1;
143: --

Line 140: fnd_message.raise_error;

136: close c1;
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', p_uom );
139: fnd_message.set_token('TYPE','FND_CURRENCY_TBL');
140: fnd_message.raise_error;
141: end if;
142: close c1;
143: --
144: end if;

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

437: p_effective_date => p_effective_date) then
438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', p_enrt_typ_cycl_cd);
443: fnd_message.set_token('TYPE' ,'BEN_ENRT_TYP_CYCL');
444: fnd_message.raise_error;
445: --

Line 442: fnd_message.set_token('FIELD', p_enrt_typ_cycl_cd);

438: --
439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', p_enrt_typ_cycl_cd);
443: fnd_message.set_token('TYPE' ,'BEN_ENRT_TYP_CYCL');
444: fnd_message.raise_error;
445: --
446: end if;

Line 443: fnd_message.set_token('TYPE' ,'BEN_ENRT_TYP_CYCL');

439: -- raise error as does not exist as lookup
440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', p_enrt_typ_cycl_cd);
443: fnd_message.set_token('TYPE' ,'BEN_ENRT_TYP_CYCL');
444: fnd_message.raise_error;
445: --
446: end if;
447: --

Line 444: fnd_message.raise_error;

440: --
441: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
442: fnd_message.set_token('FIELD', p_enrt_typ_cycl_cd);
443: fnd_message.set_token('TYPE' ,'BEN_ENRT_TYP_CYCL');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
448: end if;

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

507: p_effective_date => p_effective_date) then
508: --
509: -- raise error as does not exist as lookup
510: --
511: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
512: fnd_message.set_token('FIELD', p_ws_stat_cd);
513: fnd_message.set_token('TYPE' ,'BEN_WS_STAT');
514: fnd_message.raise_error;
515: --

Line 512: fnd_message.set_token('FIELD', p_ws_stat_cd);

508: --
509: -- raise error as does not exist as lookup
510: --
511: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
512: fnd_message.set_token('FIELD', p_ws_stat_cd);
513: fnd_message.set_token('TYPE' ,'BEN_WS_STAT');
514: fnd_message.raise_error;
515: --
516: end if;

Line 513: fnd_message.set_token('TYPE' ,'BEN_WS_STAT');

509: -- raise error as does not exist as lookup
510: --
511: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
512: fnd_message.set_token('FIELD', p_ws_stat_cd);
513: fnd_message.set_token('TYPE' ,'BEN_WS_STAT');
514: fnd_message.raise_error;
515: --
516: end if;
517: --

Line 514: fnd_message.raise_error;

510: --
511: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
512: fnd_message.set_token('FIELD', p_ws_stat_cd);
513: fnd_message.set_token('TYPE' ,'BEN_WS_STAT');
514: fnd_message.raise_error;
515: --
516: end if;
517: --
518: end if;

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

577: p_effective_date => p_effective_date) then
578: --
579: -- raise error as does not exist as lookup
580: --
581: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
582: fnd_message.set_token('FIELD', p_WS_ACC_CD);
583: fnd_message.set_token('TYPE' ,'BEN_ws_acc');
584: fnd_message.raise_error;
585: --

Line 582: fnd_message.set_token('FIELD', p_WS_ACC_CD);

578: --
579: -- raise error as does not exist as lookup
580: --
581: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
582: fnd_message.set_token('FIELD', p_WS_ACC_CD);
583: fnd_message.set_token('TYPE' ,'BEN_ws_acc');
584: fnd_message.raise_error;
585: --
586: end if;

Line 583: fnd_message.set_token('TYPE' ,'BEN_ws_acc');

579: -- raise error as does not exist as lookup
580: --
581: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
582: fnd_message.set_token('FIELD', p_WS_ACC_CD);
583: fnd_message.set_token('TYPE' ,'BEN_ws_acc');
584: fnd_message.raise_error;
585: --
586: end if;
587: --

Line 584: fnd_message.raise_error;

580: --
581: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
582: fnd_message.set_token('FIELD', p_WS_ACC_CD);
583: fnd_message.set_token('TYPE' ,'BEN_ws_acc');
584: fnd_message.raise_error;
585: --
586: end if;
587: --
588: end if;

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

647: p_effective_date => p_effective_date) then
648: --
649: -- raise error as does not exist as lookup
650: --
651: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
652: fnd_message.set_token('FIELD', p_bdgt_stat_cd);
653: fnd_message.set_token('TYPE' ,'BEN_BDGT_STAT');
654: fnd_message.raise_error;
655: --

Line 652: fnd_message.set_token('FIELD', p_bdgt_stat_cd);

648: --
649: -- raise error as does not exist as lookup
650: --
651: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
652: fnd_message.set_token('FIELD', p_bdgt_stat_cd);
653: fnd_message.set_token('TYPE' ,'BEN_BDGT_STAT');
654: fnd_message.raise_error;
655: --
656: end if;

Line 653: fnd_message.set_token('TYPE' ,'BEN_BDGT_STAT');

649: -- raise error as does not exist as lookup
650: --
651: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
652: fnd_message.set_token('FIELD', p_bdgt_stat_cd);
653: fnd_message.set_token('TYPE' ,'BEN_BDGT_STAT');
654: fnd_message.raise_error;
655: --
656: end if;
657: --

Line 654: fnd_message.raise_error;

650: --
651: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
652: fnd_message.set_token('FIELD', p_bdgt_stat_cd);
653: fnd_message.set_token('TYPE' ,'BEN_BDGT_STAT');
654: fnd_message.raise_error;
655: --
656: end if;
657: --
658: end if;

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

717: p_effective_date => p_effective_date) then
718: --
719: -- raise error as does not exist as lookup
720: --
721: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
722: fnd_message.set_token('FIELD', p_pop_cd);
723: fnd_message.set_token('TYPE' ,'BEN_POP');
724: fnd_message.raise_error;
725: --

Line 722: fnd_message.set_token('FIELD', p_pop_cd);

718: --
719: -- raise error as does not exist as lookup
720: --
721: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
722: fnd_message.set_token('FIELD', p_pop_cd);
723: fnd_message.set_token('TYPE' ,'BEN_POP');
724: fnd_message.raise_error;
725: --
726: end if;

Line 723: fnd_message.set_token('TYPE' ,'BEN_POP');

719: -- raise error as does not exist as lookup
720: --
721: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
722: fnd_message.set_token('FIELD', p_pop_cd);
723: fnd_message.set_token('TYPE' ,'BEN_POP');
724: fnd_message.raise_error;
725: --
726: end if;
727: --

Line 724: fnd_message.raise_error;

720: --
721: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
722: fnd_message.set_token('FIELD', p_pop_cd);
723: fnd_message.set_token('TYPE' ,'BEN_POP');
724: fnd_message.raise_error;
725: --
726: end if;
727: --
728: end if;

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

787: p_effective_date => p_effective_date) then
788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD', p_bdgt_acc_cd);
793: fnd_message.set_token('TYPE' ,'BEN_BDGT_ACC');
794: fnd_message.raise_error;
795: --

Line 792: fnd_message.set_token('FIELD', p_bdgt_acc_cd);

788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD', p_bdgt_acc_cd);
793: fnd_message.set_token('TYPE' ,'BEN_BDGT_ACC');
794: fnd_message.raise_error;
795: --
796: end if;

Line 793: fnd_message.set_token('TYPE' ,'BEN_BDGT_ACC');

789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD', p_bdgt_acc_cd);
793: fnd_message.set_token('TYPE' ,'BEN_BDGT_ACC');
794: fnd_message.raise_error;
795: --
796: end if;
797: --

Line 794: fnd_message.raise_error;

790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD', p_bdgt_acc_cd);
793: fnd_message.set_token('TYPE' ,'BEN_BDGT_ACC');
794: fnd_message.raise_error;
795: --
796: end if;
797: --
798: end if;

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

857: p_effective_date => p_effective_date) then
858: --
859: -- raise error as does not exist as lookup
860: --
861: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
862: fnd_message.set_token('FIELD', p_cls_enrt_dt_to_use_cd);
863: fnd_message.set_token('TYPE' ,'BEN_CLS_ENRT_DT_TO_USE');
864: fnd_message.raise_error;
865: --

Line 862: fnd_message.set_token('FIELD', p_cls_enrt_dt_to_use_cd);

858: --
859: -- raise error as does not exist as lookup
860: --
861: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
862: fnd_message.set_token('FIELD', p_cls_enrt_dt_to_use_cd);
863: fnd_message.set_token('TYPE' ,'BEN_CLS_ENRT_DT_TO_USE');
864: fnd_message.raise_error;
865: --
866: end if;

Line 863: fnd_message.set_token('TYPE' ,'BEN_CLS_ENRT_DT_TO_USE');

859: -- raise error as does not exist as lookup
860: --
861: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
862: fnd_message.set_token('FIELD', p_cls_enrt_dt_to_use_cd);
863: fnd_message.set_token('TYPE' ,'BEN_CLS_ENRT_DT_TO_USE');
864: fnd_message.raise_error;
865: --
866: end if;
867: --

Line 864: fnd_message.raise_error;

860: --
861: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
862: fnd_message.set_token('FIELD', p_cls_enrt_dt_to_use_cd);
863: fnd_message.set_token('TYPE' ,'BEN_CLS_ENRT_DT_TO_USE');
864: fnd_message.raise_error;
865: --
866: end if;
867: --
868: end if;

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

927: p_effective_date => p_effective_date) then
928: --
929: -- raise error as does not exist as lookup
930: --
931: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
932: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
933: fnd_message.set_token('TYPE' ,'BEN_ACTY_REF_PERD');
934: fnd_message.raise_error;
935: --

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

928: --
929: -- raise error as does not exist as lookup
930: --
931: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
932: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
933: fnd_message.set_token('TYPE' ,'BEN_ACTY_REF_PERD');
934: fnd_message.raise_error;
935: --
936: end if;

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

929: -- raise error as does not exist as lookup
930: --
931: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
932: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
933: fnd_message.set_token('TYPE' ,'BEN_ACTY_REF_PERD');
934: fnd_message.raise_error;
935: --
936: end if;
937: --

Line 934: fnd_message.raise_error;

930: --
931: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
932: fnd_message.set_token('FIELD', p_acty_ref_perd_cd);
933: fnd_message.set_token('TYPE' ,'BEN_ACTY_REF_PERD');
934: fnd_message.raise_error;
935: --
936: end if;
937: --
938: end if;

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

997: p_effective_date => p_effective_date) then
998: --
999: -- raise error as does not exist as lookup
1000: --
1001: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1002: fnd_message.set_token('FIELD', p_pil_elctbl_popl_stat_cd);
1003: fnd_message.set_token('TYPE' ,'BEN_PER_IN_LER_STAT');
1004: fnd_message.raise_error;
1005: --

Line 1002: fnd_message.set_token('FIELD', p_pil_elctbl_popl_stat_cd);

998: --
999: -- raise error as does not exist as lookup
1000: --
1001: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1002: fnd_message.set_token('FIELD', p_pil_elctbl_popl_stat_cd);
1003: fnd_message.set_token('TYPE' ,'BEN_PER_IN_LER_STAT');
1004: fnd_message.raise_error;
1005: --
1006: end if;

Line 1003: fnd_message.set_token('TYPE' ,'BEN_PER_IN_LER_STAT');

999: -- raise error as does not exist as lookup
1000: --
1001: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1002: fnd_message.set_token('FIELD', p_pil_elctbl_popl_stat_cd);
1003: fnd_message.set_token('TYPE' ,'BEN_PER_IN_LER_STAT');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --

Line 1004: fnd_message.raise_error;

1000: --
1001: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1002: fnd_message.set_token('FIELD', p_pil_elctbl_popl_stat_cd);
1003: fnd_message.set_token('TYPE' ,'BEN_PER_IN_LER_STAT');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --
1008: end if;

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

1042: p_effective_date => p_effective_date) then
1043: --
1044: -- raise error as does not exist as lookup
1045: --
1046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1047: fnd_message.set_token('FIELD', P_REINSTATE_CD);
1048: fnd_message.set_token('TYPE' ,'BEN_REINSTATE');
1049: fnd_message.raise_error;
1050: --

Line 1047: fnd_message.set_token('FIELD', P_REINSTATE_CD);

1043: --
1044: -- raise error as does not exist as lookup
1045: --
1046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1047: fnd_message.set_token('FIELD', P_REINSTATE_CD);
1048: fnd_message.set_token('TYPE' ,'BEN_REINSTATE');
1049: fnd_message.raise_error;
1050: --
1051: end if;

Line 1048: fnd_message.set_token('TYPE' ,'BEN_REINSTATE');

1044: -- raise error as does not exist as lookup
1045: --
1046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1047: fnd_message.set_token('FIELD', P_REINSTATE_CD);
1048: fnd_message.set_token('TYPE' ,'BEN_REINSTATE');
1049: fnd_message.raise_error;
1050: --
1051: end if;
1052: --

Line 1049: fnd_message.raise_error;

1045: --
1046: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1047: fnd_message.set_token('FIELD', P_REINSTATE_CD);
1048: fnd_message.set_token('TYPE' ,'BEN_REINSTATE');
1049: fnd_message.raise_error;
1050: --
1051: end if;
1052: --
1053: end if;

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

1087: p_effective_date => p_effective_date) then
1088: --
1089: -- raise error as does not exist as lookup
1090: --
1091: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1092: fnd_message.set_token('FIELD', P_REINSTATE_OVRDN_CD);
1093: fnd_message.set_token('TYPE' ,'BEN_REINSTATE_OVRDN');
1094: fnd_message.raise_error;
1095: --

Line 1092: fnd_message.set_token('FIELD', P_REINSTATE_OVRDN_CD);

1088: --
1089: -- raise error as does not exist as lookup
1090: --
1091: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1092: fnd_message.set_token('FIELD', P_REINSTATE_OVRDN_CD);
1093: fnd_message.set_token('TYPE' ,'BEN_REINSTATE_OVRDN');
1094: fnd_message.raise_error;
1095: --
1096: end if;

Line 1093: fnd_message.set_token('TYPE' ,'BEN_REINSTATE_OVRDN');

1089: -- raise error as does not exist as lookup
1090: --
1091: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1092: fnd_message.set_token('FIELD', P_REINSTATE_OVRDN_CD);
1093: fnd_message.set_token('TYPE' ,'BEN_REINSTATE_OVRDN');
1094: fnd_message.raise_error;
1095: --
1096: end if;
1097: --

Line 1094: fnd_message.raise_error;

1090: --
1091: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1092: fnd_message.set_token('FIELD', P_REINSTATE_OVRDN_CD);
1093: fnd_message.set_token('TYPE' ,'BEN_REINSTATE_OVRDN');
1094: fnd_message.raise_error;
1095: --
1096: end if;
1097: --
1098: end if;

Line 1125: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');

1121: If ( nvl(p_Enrt_Typ_Cycl_cd,'X') = 'U') then
1122: NULL;
1123: Else
1124: if (p_enrt_perd_id is null and p_lee_rsn_id is null) then
1125: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1126: fnd_message.raise_error;
1127: elsif (p_enrt_perd_id is not null and p_lee_rsn_id is not null) then
1128: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1129: fnd_message.raise_error;

Line 1126: fnd_message.raise_error;

1122: NULL;
1123: Else
1124: if (p_enrt_perd_id is null and p_lee_rsn_id is null) then
1125: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1126: fnd_message.raise_error;
1127: elsif (p_enrt_perd_id is not null and p_lee_rsn_id is not null) then
1128: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1129: fnd_message.raise_error;
1130: end if;

Line 1128: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');

1124: if (p_enrt_perd_id is null and p_lee_rsn_id is null) then
1125: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1126: fnd_message.raise_error;
1127: elsif (p_enrt_perd_id is not null and p_lee_rsn_id is not null) then
1128: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1129: fnd_message.raise_error;
1130: end if;
1131: End if;
1132: --

Line 1129: fnd_message.raise_error;

1125: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1126: fnd_message.raise_error;
1127: elsif (p_enrt_perd_id is not null and p_lee_rsn_id is not null) then
1128: fnd_message.set_name('BEN','BEN_91850_PEL_ENRT_PERD_LER_ID');
1129: fnd_message.raise_error;
1130: end if;
1131: End if;
1132: --
1133: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1187: fnd_message.set_name('BEN','BEN_92298_ENRT_PEREND_LT_SYSD');

1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then
1184: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1185: /*
1186: if (trunc(p_enrt_perd_end_dt) < trunc(l_system_date)) then
1187: fnd_message.set_name('BEN','BEN_92298_ENRT_PEREND_LT_SYSD');
1188: fnd_message.raise_error;
1189: end if;
1190: */ -- Bug 3653034
1191: null;

Line 1188: fnd_message.raise_error;

1184: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1185: /*
1186: if (trunc(p_enrt_perd_end_dt) < trunc(l_system_date)) then
1187: fnd_message.set_name('BEN','BEN_92298_ENRT_PEREND_LT_SYSD');
1188: fnd_message.raise_error;
1189: end if;
1190: */ -- Bug 3653034
1191: null;
1192: else

Line 1193: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');

1189: end if;
1190: */ -- Bug 3653034
1191: null;
1192: else
1193: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');
1194: fnd_message.raise_error;
1195: end if;
1196: End if;
1197:

Line 1194: fnd_message.raise_error;

1190: */ -- Bug 3653034
1191: null;
1192: else
1193: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');
1194: fnd_message.raise_error;
1195: end if;
1196: End if;
1197:
1198: -- hr_utility.set_location('Me here :'||l_proc, 10);

Line 1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');

1201: and p_dflt_enrt_dt
1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then
1203: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1204: If p_dflt_asnd_dt is not null then
1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');
1206: fnd_message.raise_error;
1207: /*
1208: elsif (trunc(p_dflt_enrt_dt) < trunc(l_system_date)) then
1209: fnd_message.set_name('BEN','BEN_92296_DFLT_ENRT_LT_SYSD');

Line 1206: fnd_message.raise_error;

1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then
1203: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1204: If p_dflt_asnd_dt is not null then
1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');
1206: fnd_message.raise_error;
1207: /*
1208: elsif (trunc(p_dflt_enrt_dt) < trunc(l_system_date)) then
1209: fnd_message.set_name('BEN','BEN_92296_DFLT_ENRT_LT_SYSD');
1210: fnd_message.raise_error;

Line 1209: fnd_message.set_name('BEN','BEN_92296_DFLT_ENRT_LT_SYSD');

1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');
1206: fnd_message.raise_error;
1207: /*
1208: elsif (trunc(p_dflt_enrt_dt) < trunc(l_system_date)) then
1209: fnd_message.set_name('BEN','BEN_92296_DFLT_ENRT_LT_SYSD');
1210: fnd_message.raise_error;
1211: */ -- Bug 3653034
1212: end if;
1213: else

Line 1210: fnd_message.raise_error;

1206: fnd_message.raise_error;
1207: /*
1208: elsif (trunc(p_dflt_enrt_dt) < trunc(l_system_date)) then
1209: fnd_message.set_name('BEN','BEN_92296_DFLT_ENRT_LT_SYSD');
1210: fnd_message.raise_error;
1211: */ -- Bug 3653034
1212: end if;
1213: else
1214: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');

Line 1214: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');

1210: fnd_message.raise_error;
1211: */ -- Bug 3653034
1212: end if;
1213: else
1214: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');
1215: fnd_message.raise_error;
1216: end if;
1217: End if;
1218: --

Line 1215: fnd_message.raise_error;

1211: */ -- Bug 3653034
1212: end if;
1213: else
1214: fnd_message.set_name('BEN','BEN_92297_STAT_NOT_STRTD');
1215: fnd_message.raise_error;
1216: end if;
1217: End if;
1218: --
1219: -- hr_utility.set_location('Me here :'||l_proc, 12);

Line 1224: fnd_message.set_name('BEN','BEN_94015_DFLT_ENRT_PROC_END');

1220:
1221: -- Added the following two validations for bug 3653034
1222: /* default enrollment date can be after processing end date per plan design
1223: If p_dflt_enrt_dt > p_procg_end_dt then
1224: fnd_message.set_name('BEN','BEN_94015_DFLT_ENRT_PROC_END');
1225: fnd_message.raise_error;
1226: End If;
1227: */
1228:

Line 1225: fnd_message.raise_error;

1221: -- Added the following two validations for bug 3653034
1222: /* default enrollment date can be after processing end date per plan design
1223: If p_dflt_enrt_dt > p_procg_end_dt then
1224: fnd_message.set_name('BEN','BEN_94015_DFLT_ENRT_PROC_END');
1225: fnd_message.raise_error;
1226: End If;
1227: */
1228:
1229: If p_enrt_perd_end_dt > p_procg_end_dt then

Line 1230: fnd_message.set_name('BEN','BEN_94014_PROC_END_ENRT_END');

1226: End If;
1227: */
1228:
1229: If p_enrt_perd_end_dt > p_procg_end_dt then
1230: fnd_message.set_name('BEN','BEN_94014_PROC_END_ENRT_END');
1231: fnd_message.raise_error;
1232: End If;
1233:
1234: If p_enrt_perd_end_dt < p_enrt_perd_strt_dt then

Line 1231: fnd_message.raise_error;

1227: */
1228:
1229: If p_enrt_perd_end_dt > p_procg_end_dt then
1230: fnd_message.set_name('BEN','BEN_94014_PROC_END_ENRT_END');
1231: fnd_message.raise_error;
1232: End If;
1233:
1234: If p_enrt_perd_end_dt < p_enrt_perd_strt_dt then
1235: fnd_message.set_name('BEN','BEN_PDW_93536_SCH_ENRDT_CMP');

Line 1235: fnd_message.set_name('BEN','BEN_PDW_93536_SCH_ENRDT_CMP');

1231: fnd_message.raise_error;
1232: End If;
1233:
1234: If p_enrt_perd_end_dt < p_enrt_perd_strt_dt then
1235: fnd_message.set_name('BEN','BEN_PDW_93536_SCH_ENRDT_CMP');
1236: fnd_message.raise_error;
1237: End If;
1238:
1239: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1236: fnd_message.raise_error;

1232: End If;
1233:
1234: If p_enrt_perd_end_dt < p_enrt_perd_strt_dt then
1235: fnd_message.set_name('BEN','BEN_PDW_93536_SCH_ENRDT_CMP');
1236: fnd_message.raise_error;
1237: End If;
1238:
1239: hr_utility.set_location('Leaving:'||l_proc,10);
1240: --

Line 1298: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');

1294: open c1;
1295: fetch c1 into l_person1,l_person2;
1296: if c1%found then
1297: close c1;
1298: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
1299: fnd_message.set_token('PERSON1', l_person1);
1300: fnd_message.set_token('PERSON2', l_person2);
1301: fnd_message.raise_error;
1302: end if;

Line 1299: fnd_message.set_token('PERSON1', l_person1);

1295: fetch c1 into l_person1,l_person2;
1296: if c1%found then
1297: close c1;
1298: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
1299: fnd_message.set_token('PERSON1', l_person1);
1300: fnd_message.set_token('PERSON2', l_person2);
1301: fnd_message.raise_error;
1302: end if;
1303: close c1;

Line 1300: fnd_message.set_token('PERSON2', l_person2);

1296: if c1%found then
1297: close c1;
1298: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
1299: fnd_message.set_token('PERSON1', l_person1);
1300: fnd_message.set_token('PERSON2', l_person2);
1301: fnd_message.raise_error;
1302: end if;
1303: close c1;
1304:

Line 1301: fnd_message.raise_error;

1297: close c1;
1298: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
1299: fnd_message.set_token('PERSON1', l_person1);
1300: fnd_message.set_token('PERSON2', l_person2);
1301: fnd_message.raise_error;
1302: end if;
1303: close c1;
1304:
1305: end if;

Line 1607: fnd_message.set_name('BEN', 'BEN_91152_EPE_EXISTS');

1603: hr_utility.set_location(' Leaving:'||l_proc, 10);
1604: Exception
1605: When l_rows_exist Then
1606:
1607: fnd_message.set_name('BEN', 'BEN_91152_EPE_EXISTS');
1608: fnd_message.raise_error;
1609:
1610: End delete_validate;
1611: --

Line 1608: fnd_message.raise_error;

1604: Exception
1605: When l_rows_exist Then
1606:
1607: fnd_message.set_name('BEN', 'BEN_91152_EPE_EXISTS');
1608: fnd_message.raise_error;
1609:
1610: End delete_validate;
1611: --
1612: --

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

1650: close csr_leg_code;
1651: --
1652: -- The primary key is invalid therefore we must error
1653: --
1654: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1655: fnd_message.raise_error;
1656: --
1657: end if;
1658: --

Line 1655: fnd_message.raise_error;

1651: --
1652: -- The primary key is invalid therefore we must error
1653: --
1654: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1655: fnd_message.raise_error;
1656: --
1657: end if;
1658: --
1659: close csr_leg_code;