233: close c_dup;
234: --
235: -- raise error as this Position criteria already exists for this profile
236: --
237: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
238: fnd_message.set_token('VAR1','Position criteria',TRUE);
239: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
240: fnd_message.raise_error;
241: --
234: --
235: -- raise error as this Position criteria already exists for this profile
236: --
237: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
238: fnd_message.set_token('VAR1','Position criteria',TRUE);
239: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
240: fnd_message.raise_error;
241: --
242: end if;
235: -- raise error as this Position criteria already exists for this profile
236: --
237: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
238: fnd_message.set_token('VAR1','Position criteria',TRUE);
239: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
240: fnd_message.raise_error;
241: --
242: end if;
243: close c_dup;
236: --
237: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
238: fnd_message.set_token('VAR1','Position criteria',TRUE);
239: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
240: fnd_message.raise_error;
241: --
242: end if;
243: close c_dup;
244: --
306: p_effective_date => p_effective_date) then
307: --
308: -- raise error as does not exist as lookup
309: --
310: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
311: fnd_message.raise_error;
312: --
313: end if;
314: --
307: --
308: -- raise error as does not exist as lookup
309: --
310: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
311: fnd_message.raise_error;
312: --
313: end if;
314: --
315: end if;
377: open c1;
378: fetch c1 into l_dummy;
379: --
380: if c1%found then
381: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
382: fnd_message.raise_error;
383: end if;
384: close c1;
385: --
378: fetch c1 into l_dummy;
379: --
380: if c1%found then
381: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
382: fnd_message.raise_error;
383: end if;
384: close c1;
385: --
386: hr_utility.set_location('Leaving:'||l_proc, 15);
482: --
483: -- An unhandled or unexpected error has occurred which
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_update_validate;
483: -- An unhandled or unexpected error has occurred which
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_update_validate;
491: --
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_update_validate;
491: --
492: -- ----------------------------------------------------------------------------
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_update_validate;
491: --
492: -- ----------------------------------------------------------------------------
493: -- |--------------------------< dt_delete_validate >--------------------------|
584: --
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
594: -- ----------------------------------------------------------------------------
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_delete_validate;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< insert_validate >----------------------------|
786: close csr_leg_code;
787: --
788: -- The primary key is invalid therefore we must error
789: --
790: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
791: fnd_message.raise_error;
792: --
793: end if;
794: --
787: --
788: -- The primary key is invalid therefore we must error
789: --
790: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
791: fnd_message.raise_error;
792: --
793: end if;
794: --
795: close csr_leg_code;