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_excld_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_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: --
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_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: --
143: end if;
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: --
143: end if;
144: --
205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD','p_optd_mdcr_flag');
211: fnd_message.set_token('TYPE','YES_NO');
212: fnd_message.raise_error;
213: --
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD','p_optd_mdcr_flag');
211: fnd_message.set_token('TYPE','YES_NO');
212: fnd_message.raise_error;
213: --
214: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD','p_optd_mdcr_flag');
211: fnd_message.set_token('TYPE','YES_NO');
212: fnd_message.raise_error;
213: --
214: --
215: end if;
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD','p_optd_mdcr_flag');
211: fnd_message.set_token('TYPE','YES_NO');
212: fnd_message.raise_error;
213: --
214: --
215: end if;
216: --
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_update_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_update_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_update_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_update_validate;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |--------------------------< dt_delete_validate >--------------------------|
407: --
408: -- A referential integrity check was violated therefore
409: -- we must error
410: --
411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
412: fnd_message.set_token('TABLE_NAME', l_table_name);
413: fnd_message.raise_error;
414: When Others Then
415: --
408: -- A referential integrity check was violated therefore
409: -- we must error
410: --
411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
412: fnd_message.set_token('TABLE_NAME', l_table_name);
413: fnd_message.raise_error;
414: When Others Then
415: --
416: -- An unhandled or unexpected error has occurred which
409: -- we must error
410: --
411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
412: fnd_message.set_token('TABLE_NAME', l_table_name);
413: fnd_message.raise_error;
414: When Others Then
415: --
416: -- An unhandled or unexpected error has occurred which
417: -- we must report
415: --
416: -- An unhandled or unexpected error has occurred which
417: -- we must report
418: --
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','15');
422: fnd_message.raise_error;
423: End dt_delete_validate;
416: -- An unhandled or unexpected error has occurred which
417: -- we must report
418: --
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','15');
422: fnd_message.raise_error;
423: End dt_delete_validate;
424: --
417: -- we must report
418: --
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','15');
422: fnd_message.raise_error;
423: End dt_delete_validate;
424: --
425: -- ----------------------------------------------------------------------------
418: --
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','15');
422: fnd_message.raise_error;
423: End dt_delete_validate;
424: --
425: -- ----------------------------------------------------------------------------
426: -- |---------------------------< insert_validate >----------------------------|
577: close csr_leg_code;
578: --
579: -- The primary key is invalid therefore we must error
580: --
581: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
582: fnd_message.raise_error;
583: --
584: end if;
585: --
578: --
579: -- The primary key is invalid therefore we must error
580: --
581: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
582: fnd_message.raise_error;
583: --
584: end if;
585: --
586: close csr_leg_code;