318: p_effective_date => p_effective_date) then
319: --
320: -- raise error as does not exist as lookup
321: --
322: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
319: --
320: -- raise error as does not exist as lookup
321: --
322: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
327: end if;
379: open c1;
380: fetch c1 into l_dummy;
381: if c1%found then
382: close c1;
383: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
384: fnd_message.raise_error;
385: end if;
386: close c1;
387: --
380: fetch c1 into l_dummy;
381: if c1%found then
382: close c1;
383: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
384: fnd_message.raise_error;
385: end if;
386: close c1;
387: --
388: hr_utility.set_location('Leaving:'||l_proc, 15);
480: --
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
482: -- we must report
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
483: --
484: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
485: fnd_message.set_token('PROCEDURE', l_proc);
486: fnd_message.set_token('STEP','15');
487: fnd_message.raise_error;
488: End dt_update_validate;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |--------------------------< dt_delete_validate >--------------------------|
582: --
583: -- An unhandled or unexpected error has occurred which
584: -- we must report
585: --
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','15');
589: fnd_message.raise_error;
590: End dt_delete_validate;
583: -- An unhandled or unexpected error has occurred which
584: -- we must report
585: --
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','15');
589: fnd_message.raise_error;
590: End dt_delete_validate;
591: --
584: -- we must report
585: --
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','15');
589: fnd_message.raise_error;
590: End dt_delete_validate;
591: --
592: -- ----------------------------------------------------------------------------
585: --
586: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
587: fnd_message.set_token('PROCEDURE', l_proc);
588: fnd_message.set_token('STEP','15');
589: fnd_message.raise_error;
590: End dt_delete_validate;
591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< insert_validate >----------------------------|
773: close csr_leg_code;
774: --
775: -- The primary key is invalid therefore we must error
776: --
777: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
774: --
775: -- The primary key is invalid therefore we must error
776: --
777: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
782: close csr_leg_code;