309: p_effective_date => p_effective_date) then
310: --
311: -- raise error as does not exist as lookup
312: --
313: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
310: --
311: -- raise error as does not exist as lookup
312: --
313: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
314: fnd_message.raise_error;
315: --
316: end if;
317: --
318: end if;
370: open c1;
371: fetch c1 into l_dummy;
372: if c1%found then
373: close c1;
374: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --
371: fetch c1 into l_dummy;
372: if c1%found then
373: close c1;
374: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
471: --
472: -- An unhandled or unexpected error has occurred which
473: -- we must report
474: --
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','15');
478: fnd_message.raise_error;
479: End dt_update_validate;
472: -- An unhandled or unexpected error has occurred which
473: -- we must report
474: --
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','15');
478: fnd_message.raise_error;
479: End dt_update_validate;
480: --
473: -- we must report
474: --
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','15');
478: fnd_message.raise_error;
479: End dt_update_validate;
480: --
481: -- ----------------------------------------------------------------------------
474: --
475: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
476: fnd_message.set_token('PROCEDURE', l_proc);
477: fnd_message.set_token('STEP','15');
478: fnd_message.raise_error;
479: End dt_update_validate;
480: --
481: -- ----------------------------------------------------------------------------
482: -- |--------------------------< dt_delete_validate >--------------------------|
573: --
574: -- An unhandled or unexpected error has occurred which
575: -- we must report
576: --
577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
578: fnd_message.set_token('PROCEDURE', l_proc);
579: fnd_message.set_token('STEP','15');
580: fnd_message.raise_error;
581: End dt_delete_validate;
574: -- An unhandled or unexpected error has occurred which
575: -- we must report
576: --
577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
578: fnd_message.set_token('PROCEDURE', l_proc);
579: fnd_message.set_token('STEP','15');
580: fnd_message.raise_error;
581: End dt_delete_validate;
582: --
575: -- we must report
576: --
577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
578: fnd_message.set_token('PROCEDURE', l_proc);
579: fnd_message.set_token('STEP','15');
580: fnd_message.raise_error;
581: End dt_delete_validate;
582: --
583: -- ----------------------------------------------------------------------------
576: --
577: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
578: fnd_message.set_token('PROCEDURE', l_proc);
579: fnd_message.set_token('STEP','15');
580: fnd_message.raise_error;
581: End dt_delete_validate;
582: --
583: -- ----------------------------------------------------------------------------
584: -- |---------------------------< insert_validate >----------------------------|
762: close csr_leg_code;
763: --
764: -- The primary key is invalid therefore we must error
765: --
766: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
763: --
764: -- The primary key is invalid therefore we must error
765: --
766: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
767: fnd_message.raise_error;
768: --
769: end if;
770: --
771: close csr_leg_code;