179: --
180: -- An unhandled or unexpected error has occurred which
181: -- we must report
182: --
183: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
184: fnd_message.set_token('PROCEDURE', l_proc);
185: fnd_message.set_token('STEP','15');
186: fnd_message.raise_error;
187: End dt_update_validate;
180: -- An unhandled or unexpected error has occurred which
181: -- we must report
182: --
183: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
184: fnd_message.set_token('PROCEDURE', l_proc);
185: fnd_message.set_token('STEP','15');
186: fnd_message.raise_error;
187: End dt_update_validate;
188: --
181: -- we must report
182: --
183: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
184: fnd_message.set_token('PROCEDURE', l_proc);
185: fnd_message.set_token('STEP','15');
186: fnd_message.raise_error;
187: End dt_update_validate;
188: --
189: -- ----------------------------------------------------------------------------
182: --
183: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
184: fnd_message.set_token('PROCEDURE', l_proc);
185: fnd_message.set_token('STEP','15');
186: fnd_message.raise_error;
187: End dt_update_validate;
188: --
189: -- ----------------------------------------------------------------------------
190: -- |--------------------------< dt_delete_validate >--------------------------|
275: --
276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_delete_validate;
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_delete_validate;
292: --
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_delete_validate;
292: --
293: -- ----------------------------------------------------------------------------
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_delete_validate;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |---------------------------< insert_validate >----------------------------|
427: close csr_leg_code;
428: --
429: -- The primary key is invalid therefore we must error
430: --
431: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
432: fnd_message.raise_error;
433: --
434: end if;
435: --
428: --
429: -- The primary key is invalid therefore we must error
430: --
431: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
432: fnd_message.raise_error;
433: --
434: end if;
435: --
436: close csr_leg_code;