172: close c3;
173: --
174: -- raise error as this job already exists for this profile
175: --
176: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
177: fnd_message.raise_error;
178: --
179: end if;
180: close c3;
173: --
174: -- raise error as this job already exists for this profile
175: --
176: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
177: fnd_message.raise_error;
178: --
179: end if;
180: close c3;
181: --
242: p_effective_date => p_effective_date) then
243: --
244: -- raise error as does not exist as lookup
245: --
246: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
247: fnd_message.raise_error;
248: --
249: end if;
250: --
243: --
244: -- raise error as does not exist as lookup
245: --
246: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
247: fnd_message.raise_error;
248: --
249: end if;
250: --
251: end if;
311: p_effective_date => p_effective_date) then
312: --
313: -- raise error as does not exist as lookup
314: --
315: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
316: fnd_message.raise_error;
317: --
318: end if;
319: --
312: --
313: -- raise error as does not exist as lookup
314: --
315: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
316: fnd_message.raise_error;
317: --
318: end if;
319: --
320: end if;
373: open c1;
374: fetch c1 into l_dummy;
375: if c1%found then
376: close c1;
377: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
378: fnd_message.raise_error;
379: end if;
380: close c1;
381: --
374: fetch c1 into l_dummy;
375: if c1%found then
376: close c1;
377: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
378: fnd_message.raise_error;
379: end if;
380: close c1;
381: --
382: hr_utility.set_location('Leaving:'||l_proc, 15);
473: --
474: -- An unhandled or unexpected error has occurred which
475: -- we must report
476: --
477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE', l_proc);
479: fnd_message.set_token('STEP','15');
480: fnd_message.raise_error;
481: End dt_update_validate;
474: -- An unhandled or unexpected error has occurred which
475: -- we must report
476: --
477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE', l_proc);
479: fnd_message.set_token('STEP','15');
480: fnd_message.raise_error;
481: End dt_update_validate;
482: --
475: -- we must report
476: --
477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE', l_proc);
479: fnd_message.set_token('STEP','15');
480: fnd_message.raise_error;
481: End dt_update_validate;
482: --
483: -- ----------------------------------------------------------------------------
476: --
477: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE', l_proc);
479: fnd_message.set_token('STEP','15');
480: fnd_message.raise_error;
481: End dt_update_validate;
482: --
483: -- ----------------------------------------------------------------------------
484: -- |--------------------------< dt_delete_validate >--------------------------|
576: --
577: -- An unhandled or unexpected error has occurred which
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
577: -- An unhandled or unexpected error has occurred which
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
586: -- ----------------------------------------------------------------------------
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
586: -- ----------------------------------------------------------------------------
587: -- |---------------------------< insert_validate >----------------------------|
770: close csr_leg_code;
771: --
772: -- The primary key is invalid therefore we must error
773: --
774: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
775: fnd_message.raise_error;
776: --
777: end if;
778: --
771: --
772: -- The primary key is invalid therefore we must error
773: --
774: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
775: fnd_message.raise_error;
776: --
777: end if;
778: --
779: close csr_leg_code;