133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dsgntr_crntly_enrld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dsgntr_crntly_enrld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dsgntr_crntly_enrld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_dsgntr_crntly_enrld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
229: --
230: -- An unhandled or unexpected error has occurred which
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
230: -- An unhandled or unexpected error has occurred which
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
231: -- we must report
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
239: -- ----------------------------------------------------------------------------
232: --
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','15');
236: fnd_message.raise_error;
237: End dt_update_validate;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |--------------------------< dt_delete_validate >--------------------------|
325: --
326: -- A referential integrity check was violated therefore
327: -- we must error
328: --
329: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
330: fnd_message.set_token('TABLE_NAME', l_table_name);
331: fnd_message.raise_error;
332: When Others Then
333: --
326: -- A referential integrity check was violated therefore
327: -- we must error
328: --
329: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
330: fnd_message.set_token('TABLE_NAME', l_table_name);
331: fnd_message.raise_error;
332: When Others Then
333: --
334: -- An unhandled or unexpected error has occurred which
327: -- we must error
328: --
329: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
330: fnd_message.set_token('TABLE_NAME', l_table_name);
331: fnd_message.raise_error;
332: When Others Then
333: --
334: -- An unhandled or unexpected error has occurred which
335: -- we must report
333: --
334: -- An unhandled or unexpected error has occurred which
335: -- we must report
336: --
337: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
338: fnd_message.set_token('PROCEDURE', l_proc);
339: fnd_message.set_token('STEP','15');
340: fnd_message.raise_error;
341: End dt_delete_validate;
334: -- An unhandled or unexpected error has occurred which
335: -- we must report
336: --
337: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
338: fnd_message.set_token('PROCEDURE', l_proc);
339: fnd_message.set_token('STEP','15');
340: fnd_message.raise_error;
341: End dt_delete_validate;
342: --
335: -- we must report
336: --
337: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
338: fnd_message.set_token('PROCEDURE', l_proc);
339: fnd_message.set_token('STEP','15');
340: fnd_message.raise_error;
341: End dt_delete_validate;
342: --
343: -- ----------------------------------------------------------------------------
336: --
337: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
338: fnd_message.set_token('PROCEDURE', l_proc);
339: fnd_message.set_token('STEP','15');
340: fnd_message.raise_error;
341: End dt_delete_validate;
342: --
343: -- ----------------------------------------------------------------------------
344: -- |---------------------------< insert_validate >----------------------------|
483: close csr_leg_code;
484: --
485: -- The primary key is invalid therefore we must error
486: --
487: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
488: fnd_message.raise_error;
489: --
490: end if;
491: --
484: --
485: -- The primary key is invalid therefore we must error
486: --
487: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
488: fnd_message.raise_error;
489: --
490: end if;
491: --
492: close csr_leg_code;