150: p_effective_date => p_effective_date) then
151: --
152: -- raise error as does not exist as lookup
153: --
154: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
151: --
152: -- raise error as does not exist as lookup
153: --
154: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
159: open c3;
162: close c3;
163: --
164: -- raise error as this criteria already exists for this profile
165: --
166: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
167: fnd_message.raise_error;
168: --
169: end if;
170: close c3;
163: --
164: -- raise error as this criteria already exists for this profile
165: --
166: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
167: fnd_message.raise_error;
168: --
169: end if;
170: close c3;
171: --
233: p_effective_date => p_effective_date) then
234: --
235: -- raise error as does not exist as lookup
236: --
237: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
238: fnd_message.raise_error;
239: --
240: end if;
241: --
234: --
235: -- raise error as does not exist as lookup
236: --
237: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
238: fnd_message.raise_error;
239: --
240: end if;
241: --
242: end if;
295: open c1;
296: fetch c1 into l_dummy;
297: if c1%found then
298: close c1;
299: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
300: fnd_message.raise_error;
301: end if;
302: close c1;
303: --
296: fetch c1 into l_dummy;
297: if c1%found then
298: close c1;
299: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
300: fnd_message.raise_error;
301: end if;
302: close c1;
303: --
304: hr_utility.set_location('Leaving:'||l_proc, 15);
379: --
380: -- A referential integrity check was violated therefore
381: -- we must error
382: --
383: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: fnd_message.set_token('TABLE_NAME', l_table_name);
385: fnd_message.raise_error;
386: When Others Then
387: --
380: -- A referential integrity check was violated therefore
381: -- we must error
382: --
383: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: fnd_message.set_token('TABLE_NAME', l_table_name);
385: fnd_message.raise_error;
386: When Others Then
387: --
388: -- An unhandled or unexpected error has occurred which
381: -- we must error
382: --
383: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: fnd_message.set_token('TABLE_NAME', l_table_name);
385: fnd_message.raise_error;
386: When Others Then
387: --
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
387: --
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |--------------------------< dt_delete_validate >--------------------------|
483: --
484: -- A referential integrity check was violated therefore
485: -- we must error
486: --
487: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
488: fnd_message.set_token('TABLE_NAME', l_table_name);
489: fnd_message.raise_error;
490: When Others Then
491: --
484: -- A referential integrity check was violated therefore
485: -- we must error
486: --
487: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
488: fnd_message.set_token('TABLE_NAME', l_table_name);
489: fnd_message.raise_error;
490: When Others Then
491: --
492: -- An unhandled or unexpected error has occurred which
485: -- we must error
486: --
487: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
488: fnd_message.set_token('TABLE_NAME', l_table_name);
489: fnd_message.raise_error;
490: When Others Then
491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_delete_validate;
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_delete_validate;
500: --
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_delete_validate;
500: --
501: -- ----------------------------------------------------------------------------
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_delete_validate;
500: --
501: -- ----------------------------------------------------------------------------
502: -- |---------------------------< insert_validate >----------------------------|
673: close csr_leg_code;
674: --
675: -- The primary key is invalid therefore we must error
676: --
677: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
678: fnd_message.raise_error;
679: --
680: end if;
681: --
674: --
675: -- The primary key is invalid therefore we must error
676: --
677: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
678: fnd_message.raise_error;
679: --
680: end if;
681: --
682: close csr_leg_code;