DBA Data[Home] [Help]

APPS.BEN_LER_BUS dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');

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;

Line 61: fnd_message.raise_error;

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

Line 271: fnd_message.set_name('BEN', 'BEN_91040_CAN_NOT_CHG_TYPE');

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

Line 272: fnd_message.raise_error;

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

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

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

Line 294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');

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

Line 295: fnd_message.raise_error;

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;

Line 361: fnd_message.set_name('BEN','BEN_91010_INV_WHN_TO_PRCS_CD');

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

Line 362: fnd_message.raise_error;

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;

Line 449: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');

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

Line 450: fnd_message.raise_error;

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;

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

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

Line 521: fnd_message.set_token('FIELD','p_ptnl_ler_trtmt_cd');

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;

Line 522: fnd_message.set_token('TYPE','BEN_PTNL_LER_TRTMT');

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

Line 523: fnd_message.raise_error;

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;

Line 595: fnd_message.set_name('BEN','BEN_93957_LER_TRTMT_SEED_ERR');

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

Line 596: fnd_message.raise_error;

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;

Line 663: fnd_message.set_name('BEN', 'BEN_94032_GSP_OPER_CD_NULL');

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

Line 664: fnd_message.raise_error;

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

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

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

Line 689: fnd_message.set_token('FIELD','lf_evt_oper_cd');

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;

Line 690: fnd_message.set_token('TYPE','BEN_LF_EVT_OPER');

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

Line 691: fnd_message.raise_error;

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

Line 698: fnd_message.set_name('BEN', 'BEN_94033_ABS_OPER_CD_FALSE');

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

Line 699: fnd_message.raise_error;

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

Line 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: --

Line 704: 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: --
708: -- Bug 2851090 Added checks for duplicate Start and End

Line 716: fnd_message.set_name('BEN','BEN_93362_DUP_START_LF_EVT');

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

Line 717: fnd_message.raise_error;

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;

Line 725: fnd_message.set_name('BEN','BEN_93363_DUP_END_LF_EVT');

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

Line 726: fnd_message.raise_error;

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;

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

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

Line 735: fnd_message.raise_error;

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;

Line 743: fnd_message.set_name('BEN','BEN_94030_DUP_PROG_LF_EVT');

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

Line 744: fnd_message.raise_error;

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;

Line 752: fnd_message.set_name('BEN','BEN_94031_DUP_SYNC_LF_EVT');

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;

Line 753: fnd_message.raise_error;

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;

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

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

Line 821: fnd_message.set_token('FIELD','p_slctbl_slf_svc_cd');

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;

Line 822: fnd_message.set_token('TYPE','BEN_SLCTBL_SLF_SVC_CD');

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

Line 823: fnd_message.raise_error;

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;

Line 896: fnd_message.set_name('BEN','BEN_91423_DELIVERED_TYPE_CHG');

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)

Line 897: fnd_message.raise_error;

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)

Line 920: fnd_message.set_name('BEN','BEN_93619_ONLY_1_GSP_LE_ALWD');

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;

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

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;

Line 924: fnd_message.raise_error;

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;

Line 946: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');

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

Line 947: fnd_message.raise_error;

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;

Line 1018: fnd_message.set_name('BEN','BEN_91011_INVALID_TYPE');

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

Line 1019: fnd_message.raise_error;

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

Line 1103: fnd_message.set_name('BEN','BEN_93924_IREC_LER_EXIST_IN_BG');

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

Line 1104: fnd_message.raise_error;

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;

Line 1176: fnd_message.set_name('BEN','BEN_91014_INV_CHK_RLTD_FLAG');

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

Line 1177: fnd_message.raise_error;

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;

Line 1245: fnd_message.set_name('BEN','BEN_91013_INV_CM_APLY_FLAG');

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

Line 1246: fnd_message.raise_error;

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;

Line 1258: fnd_message.set_name('BEN','BEN_91012_CM_APLY_FLAG_OFF');

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

Line 1259: fnd_message.raise_error;

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

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

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

Line 1408: fnd_message.set_token('FIELD','p_ovridg_le_flag');

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;

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

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

Line 1410: fnd_message.raise_error;

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;

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

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

Line 1480: fnd_message.set_token('FIELD','p_qualg_evt_flag');

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;

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

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

Line 1482: fnd_message.raise_error;

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;

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

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

Line 1551: fnd_message.set_token('FIELD','p_tmlns_eval_cd');

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;

Line 1552: fnd_message.set_token('TYPE','BEN_LER_TMLNS_EVAL');

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

Line 1553: fnd_message.raise_error;

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;

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

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

Line 1622: fnd_message.set_token('FIELD','p_tmlns_perd_cd');

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;

Line 1623: fnd_message.set_token('TYPE','BEN_LER_TMLNS_PERD');

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

Line 1624: fnd_message.raise_error;

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;

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

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

Line 1695: fnd_message.set_token('ID',p_tmlns_perd_rl);

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;

Line 1696: fnd_message.set_token('TYPE_ID',-453);

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

Line 1697: fnd_message.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: --
1701: end if;

Line 1764: fnd_message.set_name('BEN','BEN_92959_QLFG_EVT_FLAG_UNCHK');

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

Line 1765: fnd_message.raise_error;

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 ;

Line 1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1870: fnd_message.set_token('PROCEDURE', l_proc);

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

Line 1871: fnd_message.set_token('STEP','15');

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

Line 1872: fnd_message.raise_error;

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 >--------------------------|

Line 1975: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1976: fnd_message.set_token('PROCEDURE', l_proc);

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

Line 1977: fnd_message.set_token('STEP','15');

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

Line 1978: fnd_message.raise_error;

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 >----------------------------|

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

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

Line 2366: fnd_message.raise_error;

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;