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_dpnt_dsgn_ctfn_rqd_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_dpnt_dsgn_ctfn_rqd_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_dpnt_dsgn_ctfn_rqd_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_dpnt_dsgn_ctfn_rqd_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
231: p_effective_date => p_effective_date) then
232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_typ_cd');
237: fnd_message.set_token('TYPE','BEN_DPNT_CVG_CTFN_TYP');
238: fnd_message.raise_error;
239: --
232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_typ_cd');
237: fnd_message.set_token('TYPE','BEN_DPNT_CVG_CTFN_TYP');
238: fnd_message.raise_error;
239: --
240: end if;
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_typ_cd');
237: fnd_message.set_token('TYPE','BEN_DPNT_CVG_CTFN_TYP');
238: fnd_message.raise_error;
239: --
240: end if;
241: --
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_typ_cd');
237: fnd_message.set_token('TYPE','BEN_DPNT_CVG_CTFN_TYP');
238: fnd_message.raise_error;
239: --
240: end if;
241: --
242: open c3;
245: close c3;
246: --
247: -- raise error as this ctfn row already exists for this beneficiary
248: --
249: fnd_message.set_name('BEN', 'BEN_91632_DUP_DPNT_CTFN');
250: fnd_message.raise_error;
251: --
252: end if;
253: close c3;
246: --
247: -- raise error as this ctfn row already exists for this beneficiary
248: --
249: fnd_message.set_name('BEN', 'BEN_91632_DUP_DPNT_CTFN');
250: fnd_message.raise_error;
251: --
252: end if;
253: close c3;
254: --
318: -- check if received date < than efective start date. .
319: --
320: if p_dpnt_dsgn_ctfn_recd_dt < p_validation_start_date then
321: --
322: fnd_message.set_name('BEN','BEN_94211_DPNT_CTFN_RECD_DT');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
319: --
320: if p_dpnt_dsgn_ctfn_recd_dt < p_validation_start_date then
321: --
322: fnd_message.set_name('BEN','BEN_94211_DPNT_CTFN_RECD_DT');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
327: End If;
433: --
434: -- An unhandled or unexpected error has occurred which
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_update_validate;
434: -- An unhandled or unexpected error has occurred which
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_update_validate;
442: --
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_update_validate;
442: --
443: -- ----------------------------------------------------------------------------
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_update_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |--------------------------< dt_delete_validate >--------------------------|
536: --
537: -- An unhandled or unexpected error has occurred which
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
537: -- An unhandled or unexpected error has occurred which
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
538: -- we must report
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
546: -- ----------------------------------------------------------------------------
539: --
540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE', l_proc);
542: fnd_message.set_token('STEP','15');
543: fnd_message.raise_error;
544: End dt_delete_validate;
545: --
546: -- ----------------------------------------------------------------------------
547: -- |---------------------------< insert_validate >----------------------------|
729: close csr_leg_code;
730: --
731: -- The primary key is invalid therefore we must error
732: --
733: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
734: fnd_message.raise_error;
735: --
736: end if;
737: --
730: --
731: -- The primary key is invalid therefore we must error
732: --
733: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
734: fnd_message.raise_error;
735: --
736: end if;
737: --
738: close csr_leg_code;