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_mnl_adj_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_mnl_adj_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_mnl_adj_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_mnl_adj_flag);
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
205: if c1%notfound then
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
210: fnd_message.raise_error;
211: --
212: -- end if;
213: end if;
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
210: fnd_message.raise_error;
211: --
212: -- end if;
213: end if;
214: close c1;
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 >--------------------------|
413: --
414: -- An unhandled or unexpected error has occurred which
415: -- we must report
416: --
417: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
418: fnd_message.set_token('PROCEDURE', l_proc);
419: fnd_message.set_token('STEP','15');
420: fnd_message.raise_error;
421: End dt_delete_validate;
414: -- An unhandled or unexpected error has occurred which
415: -- we must report
416: --
417: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
418: fnd_message.set_token('PROCEDURE', l_proc);
419: fnd_message.set_token('STEP','15');
420: fnd_message.raise_error;
421: End dt_delete_validate;
422: --
415: -- we must report
416: --
417: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
418: fnd_message.set_token('PROCEDURE', l_proc);
419: fnd_message.set_token('STEP','15');
420: fnd_message.raise_error;
421: End dt_delete_validate;
422: --
423: -- ----------------------------------------------------------------------------
416: --
417: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
418: fnd_message.set_token('PROCEDURE', l_proc);
419: fnd_message.set_token('STEP','15');
420: fnd_message.raise_error;
421: End dt_delete_validate;
422: --
423: -- ----------------------------------------------------------------------------
424: -- |---------------------------< insert_validate >----------------------------|
575: close csr_leg_code;
576: --
577: -- The primary key is invalid therefore we must error
578: --
579: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
580: fnd_message.raise_error;
581: --
582: end if;
583: --
576: --
577: -- The primary key is invalid therefore we must error
578: --
579: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
580: fnd_message.raise_error;
581: --
582: end if;
583: --
584: close csr_leg_code;