56: CLOSE c_translation;
57: ELSE
58: hr_utility.set_location (l_package_name,70);
59: CLOSE c_translation;
60: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
61: fnd_message.raise_error;
62: END IF;
63: hr_utility.set_location ('Leaving:'||l_package_name,80);
64: END validate_translation;
57: ELSE
58: hr_utility.set_location (l_package_name,70);
59: CLOSE c_translation;
60: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
61: fnd_message.raise_error;
62: END IF;
63: hr_utility.set_location ('Leaving:'||l_package_name,80);
64: END validate_translation;
65: --
267: if l_table_name is not null then
268: if p_delete_flag = 'Y' then
269: ben_utility.child_exists_error(p_table_name => l_table_name);
270: else
271: fnd_message.set_name('BEN', 'BEN_91040_CAN_NOT_CHG_TYPE');
272: fnd_message.raise_error;
273: end if;
274: end if;
275: --
268: if p_delete_flag = 'Y' then
269: ben_utility.child_exists_error(p_table_name => l_table_name);
270: else
271: fnd_message.set_name('BEN', 'BEN_91040_CAN_NOT_CHG_TYPE');
272: fnd_message.raise_error;
273: end if;
274: end if;
275: --
276: hr_utility.set_location('Leaving:'||l_proc, 10);
289: --
290: select null into dummy from ben_ler_f ler
291: where ler.ler_id = p_ler_id and ler.typ_cd in
292: (select typ_cd from ben_startup_lers);
293: -- fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
295: fnd_message.raise_error;
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: Exception
290: select null into dummy from ben_ler_f ler
291: where ler.ler_id = p_ler_id and ler.typ_cd in
292: (select typ_cd from ben_startup_lers);
293: -- fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
295: fnd_message.raise_error;
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: Exception
298: When no_data_found then
291: where ler.ler_id = p_ler_id and ler.typ_cd in
292: (select typ_cd from ben_startup_lers);
293: -- fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
295: fnd_message.raise_error;
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: Exception
298: When no_data_found then
299: null;
357: p_effective_date => p_effective_date) then
358: --
359: -- raise error as does not exist as lookup
360: --
361: fnd_message.set_name('BEN','BEN_91010_INV_WHN_TO_PRCS_CD');
362: fnd_message.raise_error;
363: --
364: end if;
365: --
358: --
359: -- raise error as does not exist as lookup
360: --
361: fnd_message.set_name('BEN','BEN_91010_INV_WHN_TO_PRCS_CD');
362: fnd_message.raise_error;
363: --
364: end if;
365: --
366: end if;
445: close c1;
446: --
447: -- raise error
448: --
449: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
450: fnd_message.raise_error;
451: --
452: end if;
453: --
446: --
447: -- raise error
448: --
449: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
450: fnd_message.raise_error;
451: --
452: end if;
453: --
454: close c1;
516: p_effective_date => p_effective_date) then
517: --
518: -- raise error as does not exist as lookup
519: --
520: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
521: fnd_message.set_token('FIELD','p_ptnl_ler_trtmt_cd');
522: fnd_message.set_token('TYPE','BEN_PTNL_LER_TRTMT');
523: fnd_message.raise_error;
524: --
517: --
518: -- raise error as does not exist as lookup
519: --
520: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
521: fnd_message.set_token('FIELD','p_ptnl_ler_trtmt_cd');
522: fnd_message.set_token('TYPE','BEN_PTNL_LER_TRTMT');
523: fnd_message.raise_error;
524: --
525: end if;
518: -- raise error as does not exist as lookup
519: --
520: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
521: fnd_message.set_token('FIELD','p_ptnl_ler_trtmt_cd');
522: fnd_message.set_token('TYPE','BEN_PTNL_LER_TRTMT');
523: fnd_message.raise_error;
524: --
525: end if;
526: --
519: --
520: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
521: fnd_message.set_token('FIELD','p_ptnl_ler_trtmt_cd');
522: fnd_message.set_token('TYPE','BEN_PTNL_LER_TRTMT');
523: fnd_message.raise_error;
524: --
525: end if;
526: --
527: end if;
591: if p_typ_cd not in ('DRVDAGE', 'DRVDCAL', 'DRVDCMP', 'DRVDLOS', 'DRVDHRW', 'DRVDTPF')
592: and p_ptnl_ler_trtmt_cd = 'IGNRTHIS'
593: then
594: --
595: fnd_message.set_name('BEN','BEN_93957_LER_TRTMT_SEED_ERR');
596: fnd_message.raise_error;
597: --
598: end if;
599: --
592: and p_ptnl_ler_trtmt_cd = 'IGNRTHIS'
593: then
594: --
595: fnd_message.set_name('BEN','BEN_93957_LER_TRTMT_SEED_ERR');
596: fnd_message.raise_error;
597: --
598: end if;
599: --
600: end if;
659: --
660: -- GSP Rate Synchronization : Check if Operation Code is not null for LER type = GSP and ABSENCES
661: if p_typ_cd in ('GSP', 'ABS') and p_lf_evt_oper_cd is null then
662: --
663: fnd_message.set_name('BEN', 'BEN_94032_GSP_OPER_CD_NULL');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
660: -- GSP Rate Synchronization : Check if Operation Code is not null for LER type = GSP and ABSENCES
661: if p_typ_cd in ('GSP', 'ABS') and p_lf_evt_oper_cd is null then
662: --
663: fnd_message.set_name('BEN', 'BEN_94032_GSP_OPER_CD_NULL');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: l_api_updating := ben_ler_shd.api_updating
684: p_effective_date => p_effective_date) then
685: --
686: -- raise error as does not exist as lookup
687: --
688: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
689: fnd_message.set_token('FIELD','lf_evt_oper_cd');
690: fnd_message.set_token('TYPE','BEN_LF_EVT_OPER');
691: fnd_message.raise_error;
692: --
685: --
686: -- raise error as does not exist as lookup
687: --
688: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
689: fnd_message.set_token('FIELD','lf_evt_oper_cd');
690: fnd_message.set_token('TYPE','BEN_LF_EVT_OPER');
691: fnd_message.raise_error;
692: --
693: end if;
686: -- raise error as does not exist as lookup
687: --
688: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
689: fnd_message.set_token('FIELD','lf_evt_oper_cd');
690: fnd_message.set_token('TYPE','BEN_LF_EVT_OPER');
691: fnd_message.raise_error;
692: --
693: end if;
694: --
687: --
688: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
689: fnd_message.set_token('FIELD','lf_evt_oper_cd');
690: fnd_message.set_token('TYPE','BEN_LF_EVT_OPER');
691: fnd_message.raise_error;
692: --
693: end if;
694: --
695: -- GSP Rate Synchronization
694: --
695: -- GSP Rate Synchronization
696: if p_typ_cd = 'ABS' and p_lf_evt_oper_cd not in ('START', 'END', 'DELETE') then
697: --
698: fnd_message.set_name('BEN', 'BEN_94033_ABS_OPER_CD_FALSE');
699: fnd_message.raise_error;
700: --
701: elsif p_typ_cd = 'GSP' and p_lf_evt_oper_cd not in ('PROG', 'SYNC') then
702: --
695: -- GSP Rate Synchronization
696: if p_typ_cd = 'ABS' and p_lf_evt_oper_cd not in ('START', 'END', 'DELETE') then
697: --
698: fnd_message.set_name('BEN', 'BEN_94033_ABS_OPER_CD_FALSE');
699: fnd_message.raise_error;
700: --
701: elsif p_typ_cd = 'GSP' and p_lf_evt_oper_cd not in ('PROG', 'SYNC') then
702: --
703: fnd_message.set_name('BEN', 'BEN_94034_GSP_OPER_CD_FALSE');
699: fnd_message.raise_error;
700: --
701: elsif p_typ_cd = 'GSP' and p_lf_evt_oper_cd not in ('PROG', 'SYNC') then
702: --
703: fnd_message.set_name('BEN', 'BEN_94034_GSP_OPER_CD_FALSE');
704: fnd_message.raise_error;
705: --
706: end if;
707: --
700: --
701: elsif p_typ_cd = 'GSP' and p_lf_evt_oper_cd not in ('PROG', 'SYNC') then
702: --
703: fnd_message.set_name('BEN', 'BEN_94034_GSP_OPER_CD_FALSE');
704: fnd_message.raise_error;
705: --
706: end if;
707: --
708: -- Bug 2851090 Added checks for duplicate Start and End
712: open c1;
713: fetch c1 into l_dummy;
714: if c1%found then
715: close c1;
716: fnd_message.set_name('BEN','BEN_93362_DUP_START_LF_EVT');
717: fnd_message.raise_error;
718: end if;
719: close c1;
720: elsif p_lf_evt_oper_cd = 'END' then
713: fetch c1 into l_dummy;
714: if c1%found then
715: close c1;
716: fnd_message.set_name('BEN','BEN_93362_DUP_START_LF_EVT');
717: fnd_message.raise_error;
718: end if;
719: close c1;
720: elsif p_lf_evt_oper_cd = 'END' then
721: open c1;
721: open c1;
722: fetch c1 into l_dummy;
723: if c1%found then
724: close c1;
725: fnd_message.set_name('BEN','BEN_93363_DUP_END_LF_EVT');
726: fnd_message.raise_error;
727: end if;
728: close c1;
729: elsif p_lf_evt_oper_cd = 'DELETE' then
722: fetch c1 into l_dummy;
723: if c1%found then
724: close c1;
725: fnd_message.set_name('BEN','BEN_93363_DUP_END_LF_EVT');
726: fnd_message.raise_error;
727: end if;
728: close c1;
729: elsif p_lf_evt_oper_cd = 'DELETE' then
730: open c1;
730: open c1;
731: fetch c1 into l_dummy;
732: if c1%found then
733: close c1;
734: fnd_message.set_name('BEN','BEN_93145_DUP_DEL_LF_EVT');
735: fnd_message.raise_error;
736: end if;
737: close c1;
738: elsif p_lf_evt_oper_cd = 'PROG' then -- GSP Rate Synchronization
731: fetch c1 into l_dummy;
732: if c1%found then
733: close c1;
734: fnd_message.set_name('BEN','BEN_93145_DUP_DEL_LF_EVT');
735: fnd_message.raise_error;
736: end if;
737: close c1;
738: elsif p_lf_evt_oper_cd = 'PROG' then -- GSP Rate Synchronization
739: open c1;
739: open c1;
740: fetch c1 into l_dummy;
741: if c1%found then
742: close c1;
743: fnd_message.set_name('BEN','BEN_94030_DUP_PROG_LF_EVT');
744: fnd_message.raise_error;
745: end if;
746: close c1;
747: elsif p_lf_evt_oper_cd = 'SYNC' then
740: fetch c1 into l_dummy;
741: if c1%found then
742: close c1;
743: fnd_message.set_name('BEN','BEN_94030_DUP_PROG_LF_EVT');
744: fnd_message.raise_error;
745: end if;
746: close c1;
747: elsif p_lf_evt_oper_cd = 'SYNC' then
748: open c1;
748: open c1;
749: fetch c1 into l_dummy;
750: if c1%found then
751: close c1;
752: fnd_message.set_name('BEN','BEN_94031_DUP_SYNC_LF_EVT');
753: fnd_message.raise_error;
754: end if;
755: close c1; -- GSP Rate Synchronization
756: end if;
749: fetch c1 into l_dummy;
750: if c1%found then
751: close c1;
752: fnd_message.set_name('BEN','BEN_94031_DUP_SYNC_LF_EVT');
753: fnd_message.raise_error;
754: end if;
755: close c1; -- GSP Rate Synchronization
756: end if;
757: end if;
816: p_effective_date => p_effective_date) then
817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_slctbl_slf_svc_cd');
822: fnd_message.set_token('TYPE','BEN_SLCTBL_SLF_SVC_CD');
823: fnd_message.raise_error;
824: --
817: --
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_slctbl_slf_svc_cd');
822: fnd_message.set_token('TYPE','BEN_SLCTBL_SLF_SVC_CD');
823: fnd_message.raise_error;
824: --
825: end if;
818: -- raise error as does not exist as lookup
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_slctbl_slf_svc_cd');
822: fnd_message.set_token('TYPE','BEN_SLCTBL_SLF_SVC_CD');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
819: --
820: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
821: fnd_message.set_token('FIELD','p_slctbl_slf_svc_cd');
822: fnd_message.set_token('TYPE','BEN_SLCTBL_SLF_SVC_CD');
823: fnd_message.raise_error;
824: --
825: end if;
826: --
827: end if;
892: and nvl(p_typ_cd,hr_api.g_varchar2) <> ben_ler_shd.g_old_rec.typ_cd) then
893: --
894: -- The user is not allowed to change Life Event TYPE of derived types.
895: --
896: fnd_message.set_name('BEN','BEN_91423_DELIVERED_TYPE_CHG');
897: fnd_message.raise_error;
898: end if;
899:
900: if nvl(p_typ_cd,hr_api.g_varchar2)
893: --
894: -- The user is not allowed to change Life Event TYPE of derived types.
895: --
896: fnd_message.set_name('BEN','BEN_91423_DELIVERED_TYPE_CHG');
897: fnd_message.raise_error;
898: end if;
899:
900: if nvl(p_typ_cd,hr_api.g_varchar2)
901: <> nvl(ben_ler_shd.g_old_rec.typ_cd,hr_api.g_varchar2)
916: -- The user is not allowed to create Life Events of these derived types.
917: -- GRADE/STEP : Only one Grade/step life event is allowed.
918: --
919: if p_typ_cd = 'GSP' then
920: fnd_message.set_name('BEN','BEN_93619_ONLY_1_GSP_LE_ALWD');
921: else
922: fnd_message.set_name('BEN','BEN_91424_DERIV_TYPE_INS');
923: end if;
924: fnd_message.raise_error;
918: --
919: if p_typ_cd = 'GSP' then
920: fnd_message.set_name('BEN','BEN_93619_ONLY_1_GSP_LE_ALWD');
921: else
922: fnd_message.set_name('BEN','BEN_91424_DERIV_TYPE_INS');
923: end if;
924: fnd_message.raise_error;
925: else
926: close l_csr_ler;
920: fnd_message.set_name('BEN','BEN_93619_ONLY_1_GSP_LE_ALWD');
921: else
922: fnd_message.set_name('BEN','BEN_91424_DERIV_TYPE_INS');
923: end if;
924: fnd_message.raise_error;
925: else
926: close l_csr_ler;
927: end if;
928: end if;
942: p_effective_date => p_effective_date) then
943: --
944: -- raise error as does not exist as lookup
945: --
946: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');
947: fnd_message.raise_error;
948: --
949: end if;
950: --
943: --
944: -- raise error as does not exist as lookup
945: --
946: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');
947: fnd_message.raise_error;
948: --
949: end if;
950: --
951: end if;
1014: p_object_version_number => p_object_version_number);
1015: --
1016: if (l_api_updating and p_typ_cd is null ) then
1017: --
1018: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');
1019: fnd_message.raise_error;
1020: --
1021: end if;
1022: --
1015: --
1016: if (l_api_updating and p_typ_cd is null ) then
1017: --
1018: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');
1019: fnd_message.raise_error;
1020: --
1021: end if;
1022: --
1023: hr_utility.set_location('Leaving:'||l_proc,10);
1099: close l_csr_ler;
1100: --
1101: --Raise error : Life event of Type = 'iRecruitment' already exists for the Business Group
1102: --
1103: fnd_message.set_name('BEN','BEN_93924_IREC_LER_EXIST_IN_BG');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1100: --
1101: --Raise error : Life event of Type = 'iRecruitment' already exists for the Business Group
1102: --
1103: fnd_message.set_name('BEN','BEN_93924_IREC_LER_EXIST_IN_BG');
1104: fnd_message.raise_error;
1105: --
1106: end if;
1107: --
1108: close l_csr_ler;
1172: p_effective_date => p_effective_date) then
1173: --
1174: -- raise error as does not exist as lookup
1175: --
1176: fnd_message.set_name('BEN','BEN_91014_INV_CHK_RLTD_FLAG');
1177: fnd_message.raise_error;
1178: --
1179: end if;
1180: --
1173: --
1174: -- raise error as does not exist as lookup
1175: --
1176: fnd_message.set_name('BEN','BEN_91014_INV_CHK_RLTD_FLAG');
1177: fnd_message.raise_error;
1178: --
1179: end if;
1180: --
1181: end if;
1241: p_effective_date => p_effective_date) then
1242: --
1243: -- raise error as does not exist as lookup
1244: --
1245: fnd_message.set_name('BEN','BEN_91013_INV_CM_APLY_FLAG');
1246: fnd_message.raise_error;
1247: --
1248: end if;
1249: --
1242: --
1243: -- raise error as does not exist as lookup
1244: --
1245: fnd_message.set_name('BEN','BEN_91013_INV_CM_APLY_FLAG');
1246: fnd_message.raise_error;
1247: --
1248: end if;
1249: --
1250: end if;
1254: if (p_typ_cd <> 'PRSNL' or p_typ_cd is null) and p_cm_aply_flag = 'Y' then
1255: --
1256: -- raise error as does not exist as lookup
1257: --
1258: fnd_message.set_name('BEN','BEN_91012_CM_APLY_FLAG_OFF');
1259: fnd_message.raise_error;
1260: --
1261: end if;
1262: --
1255: --
1256: -- raise error as does not exist as lookup
1257: --
1258: fnd_message.set_name('BEN','BEN_91012_CM_APLY_FLAG_OFF');
1259: fnd_message.raise_error;
1260: --
1261: end if;
1262: --
1263: hr_utility.set_location('Leaving:'||l_proc,10);
1403: p_effective_date => p_effective_date) then
1404: --
1405: -- raise error as does not exist as lookup
1406: --
1407: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1408: fnd_message.set_token('FIELD','p_ovridg_le_flag');
1409: fnd_message.set_token('TYPE', 'YES_NO');
1410: fnd_message.raise_error;
1411: --
1404: --
1405: -- raise error as does not exist as lookup
1406: --
1407: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1408: fnd_message.set_token('FIELD','p_ovridg_le_flag');
1409: fnd_message.set_token('TYPE', 'YES_NO');
1410: fnd_message.raise_error;
1411: --
1412: end if;
1405: -- raise error as does not exist as lookup
1406: --
1407: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1408: fnd_message.set_token('FIELD','p_ovridg_le_flag');
1409: fnd_message.set_token('TYPE', 'YES_NO');
1410: fnd_message.raise_error;
1411: --
1412: end if;
1413: --
1406: --
1407: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1408: fnd_message.set_token('FIELD','p_ovridg_le_flag');
1409: fnd_message.set_token('TYPE', 'YES_NO');
1410: fnd_message.raise_error;
1411: --
1412: end if;
1413: --
1414: end if;
1475: p_effective_date => p_effective_date) then
1476: --
1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_qualg_evt_flag');
1481: fnd_message.set_token('TYPE', 'YES_NO');
1482: fnd_message.raise_error;
1483: --
1476: --
1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_qualg_evt_flag');
1481: fnd_message.set_token('TYPE', 'YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1477: -- raise error as does not exist as lookup
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_qualg_evt_flag');
1481: fnd_message.set_token('TYPE', 'YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1485: --
1478: --
1479: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1480: fnd_message.set_token('FIELD','p_qualg_evt_flag');
1481: fnd_message.set_token('TYPE', 'YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1485: --
1486: end if;
1546: p_effective_date => p_effective_date) then
1547: --
1548: -- raise error as does not exist as lookup
1549: --
1550: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1551: fnd_message.set_token('FIELD','p_tmlns_eval_cd');
1552: fnd_message.set_token('TYPE','BEN_LER_TMLNS_EVAL');
1553: fnd_message.raise_error;
1554: --
1547: --
1548: -- raise error as does not exist as lookup
1549: --
1550: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1551: fnd_message.set_token('FIELD','p_tmlns_eval_cd');
1552: fnd_message.set_token('TYPE','BEN_LER_TMLNS_EVAL');
1553: fnd_message.raise_error;
1554: --
1555: end if;
1548: -- raise error as does not exist as lookup
1549: --
1550: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1551: fnd_message.set_token('FIELD','p_tmlns_eval_cd');
1552: fnd_message.set_token('TYPE','BEN_LER_TMLNS_EVAL');
1553: fnd_message.raise_error;
1554: --
1555: end if;
1556: --
1549: --
1550: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1551: fnd_message.set_token('FIELD','p_tmlns_eval_cd');
1552: fnd_message.set_token('TYPE','BEN_LER_TMLNS_EVAL');
1553: fnd_message.raise_error;
1554: --
1555: end if;
1556: --
1557: end if;
1617: p_effective_date => p_effective_date) then
1618: --
1619: -- raise error as does not exist as lookup
1620: --
1621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1622: fnd_message.set_token('FIELD','p_tmlns_perd_cd');
1623: fnd_message.set_token('TYPE','BEN_LER_TMLNS_PERD');
1624: fnd_message.raise_error;
1625: --
1618: --
1619: -- raise error as does not exist as lookup
1620: --
1621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1622: fnd_message.set_token('FIELD','p_tmlns_perd_cd');
1623: fnd_message.set_token('TYPE','BEN_LER_TMLNS_PERD');
1624: fnd_message.raise_error;
1625: --
1626: end if;
1619: -- raise error as does not exist as lookup
1620: --
1621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1622: fnd_message.set_token('FIELD','p_tmlns_perd_cd');
1623: fnd_message.set_token('TYPE','BEN_LER_TMLNS_PERD');
1624: fnd_message.raise_error;
1625: --
1626: end if;
1627: --
1620: --
1621: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1622: fnd_message.set_token('FIELD','p_tmlns_perd_cd');
1623: fnd_message.set_token('TYPE','BEN_LER_TMLNS_PERD');
1624: fnd_message.raise_error;
1625: --
1626: end if;
1627: --
1628: end if;
1690: p_effective_date => p_effective_date) then
1691: --
1692: -- raise error
1693: --
1694: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1695: fnd_message.set_token('ID',p_tmlns_perd_rl);
1696: fnd_message.set_token('TYPE_ID',-453);
1697: fnd_message.raise_error;
1698: --
1691: --
1692: -- raise error
1693: --
1694: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1695: fnd_message.set_token('ID',p_tmlns_perd_rl);
1696: fnd_message.set_token('TYPE_ID',-453);
1697: fnd_message.raise_error;
1698: --
1699: end if;
1692: -- raise error
1693: --
1694: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1695: fnd_message.set_token('ID',p_tmlns_perd_rl);
1696: fnd_message.set_token('TYPE_ID',-453);
1697: fnd_message.raise_error;
1698: --
1699: end if;
1700: --
1693: --
1694: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1695: fnd_message.set_token('ID',p_tmlns_perd_rl);
1696: fnd_message.set_token('TYPE_ID',-453);
1697: fnd_message.raise_error;
1698: --
1699: end if;
1700: --
1701: end if;
1760: if p_qualg_evt_flag = 'N' then
1761: --
1762: -- raise error
1763: --
1764: fnd_message.set_name('BEN','BEN_92959_QLFG_EVT_FLAG_UNCHK');
1765: fnd_message.raise_error;
1766: --
1767: else
1768: -- valid data entered
1761: --
1762: -- raise error
1763: --
1764: fnd_message.set_name('BEN','BEN_92959_QLFG_EVT_FLAG_UNCHK');
1765: fnd_message.raise_error;
1766: --
1767: else
1768: -- valid data entered
1769: null ;
1865: --
1866: -- An unhandled or unexpected error has occurred which
1867: -- we must report
1868: --
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','15');
1872: fnd_message.raise_error;
1873: End dt_update_validate;
1866: -- An unhandled or unexpected error has occurred which
1867: -- we must report
1868: --
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','15');
1872: fnd_message.raise_error;
1873: End dt_update_validate;
1874: --
1867: -- we must report
1868: --
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','15');
1872: fnd_message.raise_error;
1873: End dt_update_validate;
1874: --
1875: -- ----------------------------------------------------------------------------
1868: --
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','15');
1872: fnd_message.raise_error;
1873: End dt_update_validate;
1874: --
1875: -- ----------------------------------------------------------------------------
1876: -- |--------------------------< dt_delete_validate >--------------------------|
1971: --
1972: -- An unhandled or unexpected error has occurred which
1973: -- we must report
1974: --
1975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1976: fnd_message.set_token('PROCEDURE', l_proc);
1977: fnd_message.set_token('STEP','15');
1978: fnd_message.raise_error;
1979: End dt_delete_validate;
1972: -- An unhandled or unexpected error has occurred which
1973: -- we must report
1974: --
1975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1976: fnd_message.set_token('PROCEDURE', l_proc);
1977: fnd_message.set_token('STEP','15');
1978: fnd_message.raise_error;
1979: End dt_delete_validate;
1980: --
1973: -- we must report
1974: --
1975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1976: fnd_message.set_token('PROCEDURE', l_proc);
1977: fnd_message.set_token('STEP','15');
1978: fnd_message.raise_error;
1979: End dt_delete_validate;
1980: --
1981: -- ----------------------------------------------------------------------------
1974: --
1975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1976: fnd_message.set_token('PROCEDURE', l_proc);
1977: fnd_message.set_token('STEP','15');
1978: fnd_message.raise_error;
1979: End dt_delete_validate;
1980: --
1981: -- ----------------------------------------------------------------------------
1982: -- |---------------------------< insert_validate >----------------------------|
2361: close csr_leg_code;
2362: --
2363: -- The primary key is invalid therefore we must error
2364: --
2365: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2366: fnd_message.raise_error;
2367: --
2368: end if;
2369: --
2362: --
2363: -- The primary key is invalid therefore we must error
2364: --
2365: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2366: fnd_message.raise_error;
2367: --
2368: end if;
2369: --
2370: close csr_leg_code;