113: if p_mn_cvg_alwd_amt is null and p_mx_cvg_alwd_amt is null then
114: --
115: -- raise an error as one of the coverage amounts must have a value
116: --
117: fnd_message.set_name('BEN','BEN_93265_MIN_OR_MAX_NOT_NULL');
118: fnd_message.raise_error;
119: --
120: end if;
121: --
114: --
115: -- raise an error as one of the coverage amounts must have a value
116: --
117: fnd_message.set_name('BEN','BEN_93265_MIN_OR_MAX_NOT_NULL');
118: fnd_message.raise_error;
119: --
120: end if;
121: --
122: --
200: --
201: -- A referential integrity check was violated therefore
202: -- we must error
203: --
204: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
205: fnd_message.set_token('TABLE_NAME', l_table_name);
206: fnd_message.raise_error;
207: When Others Then
208: --
201: -- A referential integrity check was violated therefore
202: -- we must error
203: --
204: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
205: fnd_message.set_token('TABLE_NAME', l_table_name);
206: fnd_message.raise_error;
207: When Others Then
208: --
209: -- An unhandled or unexpected error has occurred which
202: -- we must error
203: --
204: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
205: fnd_message.set_token('TABLE_NAME', l_table_name);
206: fnd_message.raise_error;
207: When Others Then
208: --
209: -- An unhandled or unexpected error has occurred which
210: -- we must report
208: --
209: -- An unhandled or unexpected error has occurred which
210: -- we must report
211: --
212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', l_proc);
214: fnd_message.set_token('STEP','15');
215: fnd_message.raise_error;
216: End dt_update_validate;
209: -- An unhandled or unexpected error has occurred which
210: -- we must report
211: --
212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', l_proc);
214: fnd_message.set_token('STEP','15');
215: fnd_message.raise_error;
216: End dt_update_validate;
217: --
210: -- we must report
211: --
212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', l_proc);
214: fnd_message.set_token('STEP','15');
215: fnd_message.raise_error;
216: End dt_update_validate;
217: --
218: -- ----------------------------------------------------------------------------
211: --
212: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', l_proc);
214: fnd_message.set_token('STEP','15');
215: fnd_message.raise_error;
216: End dt_update_validate;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |--------------------------< dt_delete_validate >--------------------------|
311: --
312: -- An unhandled or unexpected error has occurred which
313: -- we must report
314: --
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','15');
318: fnd_message.raise_error;
319: End dt_delete_validate;
312: -- An unhandled or unexpected error has occurred which
313: -- we must report
314: --
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','15');
318: fnd_message.raise_error;
319: End dt_delete_validate;
320: --
313: -- we must report
314: --
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','15');
318: fnd_message.raise_error;
319: End dt_delete_validate;
320: --
321: -- ----------------------------------------------------------------------------
314: --
315: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE', l_proc);
317: fnd_message.set_token('STEP','15');
318: fnd_message.raise_error;
319: End dt_delete_validate;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |---------------------------< insert_validate >----------------------------|
457: close csr_leg_code;
458: --
459: -- The primary key is invalid therefore we must error
460: --
461: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
462: fnd_message.raise_error;
463: --
464: end if;
465: --
458: --
459: -- The primary key is invalid therefore we must error
460: --
461: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
462: fnd_message.raise_error;
463: --
464: end if;
465: --
466: close csr_leg_code;