237: --
238: -- A referential integrity check was violated therefore
239: -- we must error
240: --
241: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
242: fnd_message.set_token('TABLE_NAME', l_table_name);
243: fnd_message.raise_error;
244: When Others Then
245: --
238: -- A referential integrity check was violated therefore
239: -- we must error
240: --
241: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
242: fnd_message.set_token('TABLE_NAME', l_table_name);
243: fnd_message.raise_error;
244: When Others Then
245: --
246: -- An unhandled or unexpected error has occurred which
239: -- we must error
240: --
241: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
242: fnd_message.set_token('TABLE_NAME', l_table_name);
243: fnd_message.raise_error;
244: When Others Then
245: --
246: -- An unhandled or unexpected error has occurred which
247: -- we must report
245: --
246: -- An unhandled or unexpected error has occurred which
247: -- we must report
248: --
249: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
250: fnd_message.set_token('PROCEDURE', l_proc);
251: fnd_message.set_token('STEP','15');
252: fnd_message.raise_error;
253: End dt_update_validate;
246: -- An unhandled or unexpected error has occurred which
247: -- we must report
248: --
249: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
250: fnd_message.set_token('PROCEDURE', l_proc);
251: fnd_message.set_token('STEP','15');
252: fnd_message.raise_error;
253: End dt_update_validate;
254: --
247: -- we must report
248: --
249: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
250: fnd_message.set_token('PROCEDURE', l_proc);
251: fnd_message.set_token('STEP','15');
252: fnd_message.raise_error;
253: End dt_update_validate;
254: --
255: -- ----------------------------------------------------------------------------
248: --
249: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
250: fnd_message.set_token('PROCEDURE', l_proc);
251: fnd_message.set_token('STEP','15');
252: fnd_message.raise_error;
253: End dt_update_validate;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |--------------------------< dt_delete_validate >--------------------------|
358: --
359: -- A referential integrity check was violated therefore
360: -- we must error
361: --
362: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
363: fnd_message.set_token('TABLE_NAME', l_table_name);
364: fnd_message.raise_error;
365: When Others Then
366: --
359: -- A referential integrity check was violated therefore
360: -- we must error
361: --
362: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
363: fnd_message.set_token('TABLE_NAME', l_table_name);
364: fnd_message.raise_error;
365: When Others Then
366: --
367: -- An unhandled or unexpected error has occurred which
360: -- we must error
361: --
362: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
363: fnd_message.set_token('TABLE_NAME', l_table_name);
364: fnd_message.raise_error;
365: When Others Then
366: --
367: -- An unhandled or unexpected error has occurred which
368: -- we must report
366: --
367: -- An unhandled or unexpected error has occurred which
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_delete_validate;
367: -- An unhandled or unexpected error has occurred which
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_delete_validate;
375: --
368: -- we must report
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_delete_validate;
375: --
376: -- ----------------------------------------------------------------------------
369: --
370: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
371: fnd_message.set_token('PROCEDURE', l_proc);
372: fnd_message.set_token('STEP','15');
373: fnd_message.raise_error;
374: End dt_delete_validate;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |---------------------------< insert_validate >----------------------------|
523: close csr_leg_code;
524: --
525: -- The primary key is invalid therefore we must error
526: --
527: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
528: fnd_message.raise_error;
529: --
530: end if;
531: --
524: --
525: -- The primary key is invalid therefore we must error
526: --
527: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
528: fnd_message.raise_error;
529: --
530: end if;
531: --
532: close csr_leg_code;