58: --
59: -- raise error as this eligibility factor is invalid
60: -- create generic message here
61: --
62: fnd_message.set_name('BEN', 'BEN_94611_INV_FCTR');
63: --fnd_message.set_token('PROCEDURE', l_proc);
64: --fnd_message.set_token('STEP','5');
65: fnd_message.raise_error;
66: --
59: -- raise error as this eligibility factor is invalid
60: -- create generic message here
61: --
62: fnd_message.set_name('BEN', 'BEN_94611_INV_FCTR');
63: --fnd_message.set_token('PROCEDURE', l_proc);
64: --fnd_message.set_token('STEP','5');
65: fnd_message.raise_error;
66: --
67: end if;
60: -- create generic message here
61: --
62: fnd_message.set_name('BEN', 'BEN_94611_INV_FCTR');
63: --fnd_message.set_token('PROCEDURE', l_proc);
64: --fnd_message.set_token('STEP','5');
65: fnd_message.raise_error;
66: --
67: end if;
68: --
61: --
62: fnd_message.set_name('BEN', 'BEN_94611_INV_FCTR');
63: --fnd_message.set_token('PROCEDURE', l_proc);
64: --fnd_message.set_token('STEP','5');
65: fnd_message.raise_error;
66: --
67: end if;
68: --
69: close c1;
290: close c3;
291: --
292: -- raise error as this per type already exists for this profile
293: --
294: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
295: fnd_message.raise_error;
296: --
297: end if;
298: close c3;
291: --
292: -- raise error as this per type already exists for this profile
293: --
294: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
295: fnd_message.raise_error;
296: --
297: end if;
298: close c3;
299: --
309: --
310: -- raise error as person type can not be set to not employee
311: -- need to create message
312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
313: fnd_message.set_name('BEN', 'BEN_91387_INV_PER_TYPE');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
310: -- raise error as person type can not be set to not employee
311: -- need to create message
312: -- ben_ept_shd.constraint_error('BEN_ELIG_PER_TYP_PRTE_FK2');
313: fnd_message.set_name('BEN', 'BEN_91387_INV_PER_TYPE');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
318: close c2;
415: --
416: -- Raise error as system person type can not be found
417: --
418: close c1;
419: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
420: fnd_message.raise_error;
421: --
422: end if;
423: --
416: -- Raise error as system person type can not be found
417: --
418: close c1;
419: fnd_message.set_name('PER','HR_7513_PER_TYPE_INVALID');
420: fnd_message.raise_error;
421: --
422: end if;
423: --
424: close c1;
486: p_effective_date => p_effective_date) then
487: --
488: -- raise error as does not exist as lookup
489: --
490: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
487: --
488: -- raise error as does not exist as lookup
489: --
490: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
495: end if;
547: open c1;
548: fetch c1 into l_dummy;
549: if c1%found then
550: close c1;
551: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
552: fnd_message.raise_error;
553: end if;
554: close c1;
555: --
548: fetch c1 into l_dummy;
549: if c1%found then
550: close c1;
551: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
552: fnd_message.raise_error;
553: end if;
554: close c1;
555: --
556: hr_utility.set_location('Leaving:'||l_proc, 15);
641: --
642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |--------------------------< dt_delete_validate >--------------------------|
745: --
746: -- A referential integrity check was violated therefore
747: -- we must error
748: --
749: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
750: fnd_message.set_token('TABLE_NAME', l_table_name);
751: fnd_message.raise_error;
752: When Others Then
753: --
746: -- A referential integrity check was violated therefore
747: -- we must error
748: --
749: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
750: fnd_message.set_token('TABLE_NAME', l_table_name);
751: fnd_message.raise_error;
752: When Others Then
753: --
754: -- An unhandled or unexpected error has occurred which
747: -- we must error
748: --
749: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
750: fnd_message.set_token('TABLE_NAME', l_table_name);
751: fnd_message.raise_error;
752: When Others Then
753: --
754: -- An unhandled or unexpected error has occurred which
755: -- we must report
753: --
754: -- An unhandled or unexpected error has occurred which
755: -- we must report
756: --
757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
758: fnd_message.set_token('PROCEDURE', l_proc);
759: fnd_message.set_token('STEP','15');
760: fnd_message.raise_error;
761: End dt_delete_validate;
754: -- An unhandled or unexpected error has occurred which
755: -- we must report
756: --
757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
758: fnd_message.set_token('PROCEDURE', l_proc);
759: fnd_message.set_token('STEP','15');
760: fnd_message.raise_error;
761: End dt_delete_validate;
762: --
755: -- we must report
756: --
757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
758: fnd_message.set_token('PROCEDURE', l_proc);
759: fnd_message.set_token('STEP','15');
760: fnd_message.raise_error;
761: End dt_delete_validate;
762: --
763: -- ----------------------------------------------------------------------------
756: --
757: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
758: fnd_message.set_token('PROCEDURE', l_proc);
759: fnd_message.set_token('STEP','15');
760: fnd_message.raise_error;
761: End dt_delete_validate;
762: --
763: -- ----------------------------------------------------------------------------
764: -- |---------------------------< insert_validate >----------------------------|
961: close csr_leg_code;
962: --
963: -- The primary key is invalid therefore we must error
964: --
965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
966: fnd_message.raise_error;
967: --
968: end if;
969: --
962: --
963: -- The primary key is invalid therefore we must error
964: --
965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
966: fnd_message.raise_error;
967: --
968: end if;
969: --
970: close csr_leg_code;