DBA Data[Home] [Help]

APPS.BEN_ENP_BUS dependencies on FND_MESSAGE

Line 250: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');

246: close chk_unique;
247: --
248: -- raise error as UK1 is violated
249: --
250: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
251: fnd_message.raise_error;
252: --
253: end if;
254: --

Line 251: fnd_message.raise_error;

247: --
248: -- raise error as UK1 is violated
249: --
250: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
251: fnd_message.raise_error;
252: --
253: end if;
254: --
255: close chk_unique;

Line 336: fnd_message.set_name('BEN','BEN_92979_INVLD_ENRT_END_DT');

332: if p_strt_dt > p_end_dt then
333: --
334: -- raise error
335: --
336: fnd_message.set_name('BEN','BEN_92979_INVLD_ENRT_END_DT');
337: fnd_message.raise_error;
338: --
339: end if;
340: --

Line 337: fnd_message.raise_error;

333: --
334: -- raise error
335: --
336: fnd_message.set_name('BEN','BEN_92979_INVLD_ENRT_END_DT');
337: fnd_message.raise_error;
338: --
339: end if;
340: --
341: end if;

Line 421: fnd_message.set_name('BEN','BEN_93231_DUP_ASND_LF_EVT_DT');

417: if c_dup_enp%found then
418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_93231_DUP_ASND_LF_EVT_DT');
422: fnd_message.raise_error;
423: --
424: end if;
425: --

Line 422: fnd_message.raise_error;

418: --
419: -- raise error
420: --
421: fnd_message.set_name('BEN','BEN_93231_DUP_ASND_LF_EVT_DT');
422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: end if;

Line 499: fnd_message.set_name('PAY','end date > dflt enrt date');

495: if p_end_dt > p_dflt_enrt_dt then
496: --
497: -- raise error
498: --
499: fnd_message.set_name('PAY','end date > dflt enrt date');
500: fnd_message.raise_error;
501: --
502: end if;
503: --

Line 500: fnd_message.raise_error;

496: --
497: -- raise error
498: --
499: fnd_message.set_name('PAY','end date > dflt enrt date');
500: fnd_message.raise_error;
501: --
502: end if;
503: --
504: end if;

Line 589: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

585: close c1;
586: --
587: -- raise error
588: --
589: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
590: fnd_message.set_token('ID',p_rt_end_dt_rl);
591: fnd_message.set_token('TYPE_ID',-67);
592: fnd_message.raise_error;
593: --

Line 590: fnd_message.set_token('ID',p_rt_end_dt_rl);

586: --
587: -- raise error
588: --
589: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
590: fnd_message.set_token('ID',p_rt_end_dt_rl);
591: fnd_message.set_token('TYPE_ID',-67);
592: fnd_message.raise_error;
593: --
594: end if;

Line 591: fnd_message.set_token('TYPE_ID',-67);

587: -- raise error
588: --
589: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
590: fnd_message.set_token('ID',p_rt_end_dt_rl);
591: fnd_message.set_token('TYPE_ID',-67);
592: fnd_message.raise_error;
593: --
594: end if;
595: --

Line 592: fnd_message.raise_error;

588: --
589: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
590: fnd_message.set_token('ID',p_rt_end_dt_rl);
591: fnd_message.set_token('TYPE_ID',-67);
592: fnd_message.raise_error;
593: --
594: end if;
595: --
596: close c1;

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

656: p_effective_date => p_effective_date) then
657: --
658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);
663: fnd_message.set_token('TYPE', 'BEN_RT_END');
664: fnd_message.raise_error;

Line 661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');

657: --
658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);
663: fnd_message.set_token('TYPE', 'BEN_RT_END');
664: fnd_message.raise_error;
665: --

Line 662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);

658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);
663: fnd_message.set_token('TYPE', 'BEN_RT_END');
664: fnd_message.raise_error;
665: --
666: end if;

Line 663: fnd_message.set_token('TYPE', 'BEN_RT_END');

659: --
660: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);
663: fnd_message.set_token('TYPE', 'BEN_RT_END');
664: fnd_message.raise_error;
665: --
666: end if;
667: --

Line 664: fnd_message.raise_error;

660: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
662: fnd_message.set_token('VALUE', p_rt_end_dt_cd);
663: fnd_message.set_token('TYPE', 'BEN_RT_END');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: end if;

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

730: -- raise error as does not exist as lookup
731: --
732: -- raise error as does not exist as lookup
733: --
734: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
737: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
738: fnd_message.raise_error;

Line 735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');

731: --
732: -- raise error as does not exist as lookup
733: --
734: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
737: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
738: fnd_message.raise_error;
739: --

Line 736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);

732: -- raise error as does not exist as lookup
733: --
734: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
737: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
738: fnd_message.raise_error;
739: --
740: end if;

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

733: --
734: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
737: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
738: fnd_message.raise_error;
739: --
740: end if;
741: --

Line 738: fnd_message.raise_error;

734: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
735: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
736: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
737: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
738: fnd_message.raise_error;
739: --
740: end if;
741: --
742: end if;

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

803: -- raise error as does not exist as lookup
804: --
805: -- raise error as does not exist as lookup
806: --
807: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
808: fnd_message.set_token('FIELD', 'p_reinstate_cd');
809: fnd_message.set_token('VALUE', p_reinstate_cd);
810: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
811: fnd_message.raise_error;

Line 808: fnd_message.set_token('FIELD', 'p_reinstate_cd');

804: --
805: -- raise error as does not exist as lookup
806: --
807: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
808: fnd_message.set_token('FIELD', 'p_reinstate_cd');
809: fnd_message.set_token('VALUE', p_reinstate_cd);
810: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
811: fnd_message.raise_error;
812: end if;

Line 809: fnd_message.set_token('VALUE', p_reinstate_cd);

805: -- raise error as does not exist as lookup
806: --
807: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
808: fnd_message.set_token('FIELD', 'p_reinstate_cd');
809: fnd_message.set_token('VALUE', p_reinstate_cd);
810: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
811: fnd_message.raise_error;
812: end if;
813: --

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

806: --
807: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
808: fnd_message.set_token('FIELD', 'p_reinstate_cd');
809: fnd_message.set_token('VALUE', p_reinstate_cd);
810: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
811: fnd_message.raise_error;
812: end if;
813: --
814: end if;

Line 811: fnd_message.raise_error;

807: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
808: fnd_message.set_token('FIELD', 'p_reinstate_cd');
809: fnd_message.set_token('VALUE', p_reinstate_cd);
810: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
811: fnd_message.raise_error;
812: end if;
813: --
814: end if;
815: --

Line 969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

965: close c1;
966: --
967: -- raise error
968: --
969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
970: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
971: fnd_message.set_token('TYPE_ID',-30);
972: fnd_message.raise_error;
973: --

Line 970: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);

966: --
967: -- raise error
968: --
969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
970: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
971: fnd_message.set_token('TYPE_ID',-30);
972: fnd_message.raise_error;
973: --
974: end if;

Line 971: fnd_message.set_token('TYPE_ID',-30);

967: -- raise error
968: --
969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
970: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
971: fnd_message.set_token('TYPE_ID',-30);
972: fnd_message.raise_error;
973: --
974: end if;
975: --

Line 972: fnd_message.raise_error;

968: --
969: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
970: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
971: fnd_message.set_token('TYPE_ID',-30);
972: fnd_message.raise_error;
973: --
974: end if;
975: --
976: close c1;

Line 1063: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1059: close c1;
1060: --
1061: -- raise error
1062: --
1063: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1064: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1065: fnd_message.set_token('TYPE_ID',-29);
1066: fnd_message.raise_error;
1067: --

Line 1064: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);

1060: --
1061: -- raise error
1062: --
1063: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1064: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1065: fnd_message.set_token('TYPE_ID',-29);
1066: fnd_message.raise_error;
1067: --
1068: end if;

Line 1065: fnd_message.set_token('TYPE_ID',-29);

1061: -- raise error
1062: --
1063: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1064: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1065: fnd_message.set_token('TYPE_ID',-29);
1066: fnd_message.raise_error;
1067: --
1068: end if;
1069: --

Line 1066: fnd_message.raise_error;

1062: --
1063: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1064: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1065: fnd_message.set_token('TYPE_ID',-29);
1066: fnd_message.raise_error;
1067: --
1068: end if;
1069: --
1070: close c1;

Line 1225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1221: close c1;
1222: --
1223: -- raise error
1224: --
1225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1226: fnd_message.set_token('ID',p_rt_strt_dt_rl);
1227: fnd_message.set_token('TYPE_ID',-66);
1228: fnd_message.raise_error;
1229: --

Line 1226: fnd_message.set_token('ID',p_rt_strt_dt_rl);

1222: --
1223: -- raise error
1224: --
1225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1226: fnd_message.set_token('ID',p_rt_strt_dt_rl);
1227: fnd_message.set_token('TYPE_ID',-66);
1228: fnd_message.raise_error;
1229: --
1230: end if;

Line 1227: fnd_message.set_token('TYPE_ID',-66);

1223: -- raise error
1224: --
1225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1226: fnd_message.set_token('ID',p_rt_strt_dt_rl);
1227: fnd_message.set_token('TYPE_ID',-66);
1228: fnd_message.raise_error;
1229: --
1230: end if;
1231: --

Line 1228: fnd_message.raise_error;

1224: --
1225: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1226: fnd_message.set_token('ID',p_rt_strt_dt_rl);
1227: fnd_message.set_token('TYPE_ID',-66);
1228: fnd_message.raise_error;
1229: --
1230: end if;
1231: --
1232: close c1;

Line 1297: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

1293: p_effective_date => p_effective_date) then
1294: --
1295: -- raise error as does not exist as lookup
1296: --
1297: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1298: fnd_message.raise_error;
1299: --
1300: end if;
1301: --

Line 1298: fnd_message.raise_error;

1294: --
1295: -- raise error as does not exist as lookup
1296: --
1297: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1298: fnd_message.raise_error;
1299: --
1300: end if;
1301: --
1302: end if;

Line 1432: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');

1428: or not l_api_updating) then
1429: --
1430: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
1431: --
1432: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');
1433: fnd_message.raise_error;
1434: --
1435: end if;
1436: --

Line 1433: fnd_message.raise_error;

1429: --
1430: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
1431: --
1432: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');
1433: fnd_message.raise_error;
1434: --
1435: end if;
1436: --
1437: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'

Line 1440: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');

1436: --
1437: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
1438: and p_enrt_cvg_strt_dt_rl is not null then
1439: --
1440: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');
1441: fnd_message.raise_error;
1442: --
1443: end if;
1444: --

Line 1441: fnd_message.raise_error;

1437: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
1438: and p_enrt_cvg_strt_dt_rl is not null then
1439: --
1440: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');
1441: fnd_message.raise_error;
1442: --
1443: end if;
1444: --
1445: end if;

Line 1571: fnd_message.set_name('BEN','BEN_93730_CW_HRCHY_AME_ERR');

1567: fetch c_hrchy_ame into l_dummy ;
1568: if c_hrchy_ame%notfound then
1569: close c_hrchy_ame ;
1570: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 7);
1571: fnd_message.set_name('BEN','BEN_93730_CW_HRCHY_AME_ERR');
1572: --Bug 4083891 : Passed Assigned Life Event Date parameter to the modified message
1573: fnd_message.set_token('ALED',fnd_date.date_to_displaydate(p_effective_date));
1574: fnd_message.raise_error;
1575:

Line 1573: fnd_message.set_token('ALED',fnd_date.date_to_displaydate(p_effective_date));

1569: close c_hrchy_ame ;
1570: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 7);
1571: fnd_message.set_name('BEN','BEN_93730_CW_HRCHY_AME_ERR');
1572: --Bug 4083891 : Passed Assigned Life Event Date parameter to the modified message
1573: fnd_message.set_token('ALED',fnd_date.date_to_displaydate(p_effective_date));
1574: fnd_message.raise_error;
1575:
1576: end if ;
1577: close c_hrchy_ame ;

Line 1574: fnd_message.raise_error;

1570: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 7);
1571: fnd_message.set_name('BEN','BEN_93730_CW_HRCHY_AME_ERR');
1572: --Bug 4083891 : Passed Assigned Life Event Date parameter to the modified message
1573: fnd_message.set_token('ALED',fnd_date.date_to_displaydate(p_effective_date));
1574: fnd_message.raise_error;
1575:
1576: end if ;
1577: close c_hrchy_ame ;
1578:

Line 1600: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1596: close c_hrchy_rl;
1597: --
1598: -- raise error
1599: --
1600: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1601: fnd_message.set_token('ID',p_hrchy_rl);
1602: fnd_message.set_token('TYPE_ID',-549);
1603: fnd_message.raise_error;
1604: --

Line 1601: fnd_message.set_token('ID',p_hrchy_rl);

1597: --
1598: -- raise error
1599: --
1600: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1601: fnd_message.set_token('ID',p_hrchy_rl);
1602: fnd_message.set_token('TYPE_ID',-549);
1603: fnd_message.raise_error;
1604: --
1605: end if;

Line 1602: fnd_message.set_token('TYPE_ID',-549);

1598: -- raise error
1599: --
1600: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1601: fnd_message.set_token('ID',p_hrchy_rl);
1602: fnd_message.set_token('TYPE_ID',-549);
1603: fnd_message.raise_error;
1604: --
1605: end if;
1606: close c_hrchy_rl;

Line 1603: fnd_message.raise_error;

1599: --
1600: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1601: fnd_message.set_token('ID',p_hrchy_rl);
1602: fnd_message.set_token('TYPE_ID',-549);
1603: fnd_message.raise_error;
1604: --
1605: end if;
1606: close c_hrchy_rl;
1607: --

Line 1642: fnd_message.set_name('BEN','BEN_93731_CWB_HRCHY_CWOR_RWOC');

1638: if (p_hrchy_to_use_cd = 'RL' and p_hrchy_rl is null)
1639: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'RL'
1640: and p_hrchy_rl is not null ) then
1641: --
1642: fnd_message.set_name('BEN','BEN_93731_CWB_HRCHY_CWOR_RWOC');
1643: fnd_message.raise_error;
1644: --
1645: end if;
1646: --

Line 1643: fnd_message.raise_error;

1639: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'RL'
1640: and p_hrchy_rl is not null ) then
1641: --
1642: fnd_message.set_name('BEN','BEN_93731_CWB_HRCHY_CWOR_RWOC');
1643: fnd_message.raise_error;
1644: --
1645: end if;
1646: --
1647:

Line 1651: fnd_message.set_name('BEN','BEN_93732_CWB_HRCHY_AME_CWOC');

1647:
1648: if (p_hrchy_to_use_cd = 'AME' and p_hrchy_ame_trn_cd is null)
1649: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'AME' and p_hrchy_ame_trn_cd is not null ) then
1650: --
1651: fnd_message.set_name('BEN','BEN_93732_CWB_HRCHY_AME_CWOC');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655:

Line 1652: fnd_message.raise_error;

1648: if (p_hrchy_to_use_cd = 'AME' and p_hrchy_ame_trn_cd is null)
1649: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'AME' and p_hrchy_ame_trn_cd is not null ) then
1650: --
1651: fnd_message.set_name('BEN','BEN_93732_CWB_HRCHY_AME_CWOC');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655:
1656:

Line 1661: fnd_message.set_name('BEN','BEN_93733_CWB_HRCHY_AME_CWOC');

1657: if (p_hrchy_to_use_cd = 'P' and p_pos_structure_version_id is null)
1658: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'P'
1659: and p_pos_structure_version_id is not null ) then
1660: --
1661: fnd_message.set_name('BEN','BEN_93733_CWB_HRCHY_AME_CWOC');
1662: fnd_message.raise_error;
1663: --
1664: end if;
1665: --

Line 1662: fnd_message.raise_error;

1658: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'P'
1659: and p_pos_structure_version_id is not null ) then
1660: --
1661: fnd_message.set_name('BEN','BEN_93733_CWB_HRCHY_AME_CWOC');
1662: fnd_message.raise_error;
1663: --
1664: end if;
1665: --
1666: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1727: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');

1723: or not l_api_updating) then
1724: --
1725: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
1726: --
1727: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');
1728: fnd_message.raise_error;
1729: --
1730: end if;
1731: --

Line 1728: fnd_message.raise_error;

1724: --
1725: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
1726: --
1727: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');
1728: fnd_message.raise_error;
1729: --
1730: end if;
1731: --
1732: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'

Line 1735: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');

1731: --
1732: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
1733: and p_enrt_cvg_end_dt_rl is not null then
1734: --
1735: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');
1736: fnd_message.raise_error;
1737: --
1738: end if;
1739: --

Line 1736: fnd_message.raise_error;

1732: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
1733: and p_enrt_cvg_end_dt_rl is not null then
1734: --
1735: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');
1736: fnd_message.raise_error;
1737: --
1738: end if;
1739: --
1740: end if;

Line 1802: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

1798: or not l_api_updating) then
1799: --
1800: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null) then
1801: --
1802: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1803: fnd_message.raise_error;
1804: --
1805: end if;
1806: --

Line 1803: fnd_message.raise_error;

1799: --
1800: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null) then
1801: --
1802: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1803: fnd_message.raise_error;
1804: --
1805: end if;
1806: --
1807: if nvl(p_rt_strt_dt_cd,hr_api.g_varchar2) <> 'RL'

Line 1810: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

1806: --
1807: if nvl(p_rt_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
1808: and p_rt_strt_dt_rl is not null then
1809: --
1810: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1811: fnd_message.raise_error;
1812: --
1813: end if;
1814: --

Line 1811: fnd_message.raise_error;

1807: if nvl(p_rt_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
1808: and p_rt_strt_dt_rl is not null then
1809: --
1810: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1811: fnd_message.raise_error;
1812: --
1813: end if;
1814: --
1815: end if;

Line 1878: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

1874: or not l_api_updating) then
1875: --
1876: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null) then
1877: --
1878: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1879: fnd_message.raise_error;
1880: --
1881: end if;
1882: --

Line 1879: fnd_message.raise_error;

1875: --
1876: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null) then
1877: --
1878: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1879: fnd_message.raise_error;
1880: --
1881: end if;
1882: --
1883: if nvl(p_rt_end_dt_cd,hr_api.g_varchar2) <> 'RL'

Line 1886: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

1882: --
1883: if nvl(p_rt_end_dt_cd,hr_api.g_varchar2) <> 'RL'
1884: and p_rt_end_dt_rl is not null then
1885: --
1886: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1887: fnd_message.raise_error;
1888: --
1889: end if;
1890: --

Line 1887: fnd_message.raise_error;

1883: if nvl(p_rt_end_dt_cd,hr_api.g_varchar2) <> 'RL'
1884: and p_rt_end_dt_rl is not null then
1885: --
1886: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1887: fnd_message.raise_error;
1888: --
1889: end if;
1890: --
1891: end if;

Line 1958: fnd_message.set_name('BEN','BEN_92975_INVLD_BGT_UPD_END_DT');

1954: if p_bdgt_upd_strt_dt > p_bdgt_upd_end_dt then
1955: --
1956: -- raise error
1957: --
1958: fnd_message.set_name('BEN','BEN_92975_INVLD_BGT_UPD_END_DT');
1959: fnd_message.raise_error;
1960: --
1961: end if;
1962: --

Line 1959: fnd_message.raise_error;

1955: --
1956: -- raise error
1957: --
1958: fnd_message.set_name('BEN','BEN_92975_INVLD_BGT_UPD_END_DT');
1959: fnd_message.raise_error;
1960: --
1961: end if;
1962: --
1963: end if;

Line 2030: fnd_message.set_name('BEN','BEN_92976_INVLD_WS_UPD_END_DT');

2026: if p_ws_upd_strt_dt > p_ws_upd_end_dt then
2027: --
2028: -- raise error
2029: --
2030: fnd_message.set_name('BEN','BEN_92976_INVLD_WS_UPD_END_DT');
2031: fnd_message.raise_error;
2032: --
2033: end if;
2034: --

Line 2031: fnd_message.raise_error;

2027: --
2028: -- raise error
2029: --
2030: fnd_message.set_name('BEN','BEN_92976_INVLD_WS_UPD_END_DT');
2031: fnd_message.raise_error;
2032: --
2033: end if;
2034: --
2035: end if;

Line 2116: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');

2112: not (p_bdgt_upd_strt_dt between p_strt_dt and p_end_dt) then
2113: --
2114: -- raise error
2115: --
2116: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');
2117: fnd_message.raise_error;
2118: --
2119: elsif (p_bdgt_upd_end_dt is not null) and
2120: not (p_bdgt_upd_end_dt between p_strt_dt and p_end_dt) then

Line 2117: fnd_message.raise_error;

2113: --
2114: -- raise error
2115: --
2116: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');
2117: fnd_message.raise_error;
2118: --
2119: elsif (p_bdgt_upd_end_dt is not null) and
2120: not (p_bdgt_upd_end_dt between p_strt_dt and p_end_dt) then
2121: --

Line 2124: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');

2120: not (p_bdgt_upd_end_dt between p_strt_dt and p_end_dt) then
2121: --
2122: -- raise error
2123: --
2124: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');
2125: fnd_message.raise_error;
2126: --
2127: end if;
2128: --

Line 2125: fnd_message.raise_error;

2121: --
2122: -- raise error
2123: --
2124: fnd_message.set_name('BEN','BEN_92977_INVLD_BDGT_UPD_PERD');
2125: fnd_message.raise_error;
2126: --
2127: end if;
2128: --
2129: end if;

Line 2210: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');

2206: not (p_ws_upd_strt_dt between p_strt_dt and p_end_dt) then
2207: --
2208: -- raise error
2209: --
2210: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');
2211: fnd_message.raise_error;
2212: --
2213: elsif (p_ws_upd_end_dt is not null) and
2214: not (p_ws_upd_end_dt between p_strt_dt and p_end_dt) then

Line 2211: fnd_message.raise_error;

2207: --
2208: -- raise error
2209: --
2210: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');
2211: fnd_message.raise_error;
2212: --
2213: elsif (p_ws_upd_end_dt is not null) and
2214: not (p_ws_upd_end_dt between p_strt_dt and p_end_dt) then
2215: --

Line 2218: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');

2214: not (p_ws_upd_end_dt between p_strt_dt and p_end_dt) then
2215: --
2216: -- raise error
2217: --
2218: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');
2219: fnd_message.raise_error;
2220: --
2221: end if;
2222: --

Line 2219: fnd_message.raise_error;

2215: --
2216: -- raise error
2217: --
2218: fnd_message.set_name('BEN','BEN_92978_INVLD_WS_UPD_PERD');
2219: fnd_message.raise_error;
2220: --
2221: end if;
2222: --
2223: end if;

Line 2298: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');

2294: if l_pl_cd = 'MSTBPGM' then
2295: --
2296: if p_defer_deenrol_flag = 'Y' then
2297: --
2298: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');
2299: fnd_message.raise_error;
2300: --
2301: end if;
2302: --

Line 2299: fnd_message.raise_error;

2295: --
2296: if p_defer_deenrol_flag = 'Y' then
2297: --
2298: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');
2299: fnd_message.raise_error;
2300: --
2301: end if;
2302: --
2303: end if;

Line 2364: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

2360: p_effective_date => p_effective_date) then
2361: --
2362: -- raise error as does not exist as lookup
2363: --
2364: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2365: fnd_message.raise_error;
2366: --
2367: end if;
2368: --

Line 2365: fnd_message.raise_error;

2361: --
2362: -- raise error as does not exist as lookup
2363: --
2364: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
2365: fnd_message.raise_error;
2366: --
2367: end if;
2368: --
2369: end if;