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_alctd_val_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_alctd_val_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_alctd_val_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_alctd_val_flag);
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
204: p_effective_date => p_effective_date) then
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD',p_cr_mnl_adj_flag);
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD',p_cr_mnl_adj_flag);
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD',p_cr_mnl_adj_flag);
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD',p_cr_mnl_adj_flag);
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
277: if c1%notfound then
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
282: fnd_message.raise_error;
283: --
284: -- end if;
285: end if;
278: --
279: -- raise error as does not exist as lookup
280: --
281: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
282: fnd_message.raise_error;
283: --
284: -- end if;
285: end if;
286: close c1;
351: if c1%notfound then
352: --
353: -- raise error as does not exist as lookup
354: --
355: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
356: fnd_message.raise_error;
357: --
358: -- end if;
359: end if;
352: --
353: -- raise error as does not exist as lookup
354: --
355: fnd_message.set_name('BEN','BEN_91048_INVALID_UOM');
356: fnd_message.raise_error;
357: --
358: -- end if;
359: end if;
360: close c1;
422: p_effective_date => p_effective_date) then
423: --
424: -- raise error as does not exist as lookup
425: --
426: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
427: fnd_message.set_token('FIELD',p_mnl_adj_flag);
428: fnd_message.set_token('TYPE','YES_NO');
429: fnd_message.raise_error;
430: --
423: --
424: -- raise error as does not exist as lookup
425: --
426: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
427: fnd_message.set_token('FIELD',p_mnl_adj_flag);
428: fnd_message.set_token('TYPE','YES_NO');
429: fnd_message.raise_error;
430: --
431: end if;
424: -- raise error as does not exist as lookup
425: --
426: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
427: fnd_message.set_token('FIELD',p_mnl_adj_flag);
428: fnd_message.set_token('TYPE','YES_NO');
429: fnd_message.raise_error;
430: --
431: end if;
432: --
425: --
426: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
427: fnd_message.set_token('FIELD',p_mnl_adj_flag);
428: fnd_message.set_token('TYPE','YES_NO');
429: fnd_message.raise_error;
430: --
431: end if;
432: --
433: end if;
527: --
528: -- An unhandled or unexpected error has occurred which
529: -- we must report
530: --
531: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
532: fnd_message.set_token('PROCEDURE', l_proc);
533: fnd_message.set_token('STEP','15');
534: fnd_message.raise_error;
535: End dt_update_validate;
528: -- An unhandled or unexpected error has occurred which
529: -- we must report
530: --
531: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
532: fnd_message.set_token('PROCEDURE', l_proc);
533: fnd_message.set_token('STEP','15');
534: fnd_message.raise_error;
535: End dt_update_validate;
536: --
529: -- we must report
530: --
531: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
532: fnd_message.set_token('PROCEDURE', l_proc);
533: fnd_message.set_token('STEP','15');
534: fnd_message.raise_error;
535: End dt_update_validate;
536: --
537: -- ----------------------------------------------------------------------------
530: --
531: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
532: fnd_message.set_token('PROCEDURE', l_proc);
533: fnd_message.set_token('STEP','15');
534: fnd_message.raise_error;
535: End dt_update_validate;
536: --
537: -- ----------------------------------------------------------------------------
538: -- |--------------------------< dt_delete_validate >--------------------------|
629: --
630: -- An unhandled or unexpected error has occurred which
631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_delete_validate;
630: -- An unhandled or unexpected error has occurred which
631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_delete_validate;
638: --
631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_delete_validate;
638: --
639: -- ----------------------------------------------------------------------------
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_delete_validate;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< insert_validate >----------------------------|
827: close csr_leg_code;
828: --
829: -- The primary key is invalid therefore we must error
830: --
831: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
832: fnd_message.raise_error;
833: --
834: end if;
835: --
828: --
829: -- The primary key is invalid therefore we must error
830: --
831: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
832: fnd_message.raise_error;
833: --
834: end if;
835: --
836: close csr_leg_code;