DBA Data[Home] [Help]

APPS.BEN_CCP_BUS dependencies on FND_MESSAGE

Line 137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 138: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_rqd_flag');

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;

Line 139: fnd_message.set_token('TYPE','YES_NO');

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: --

Line 140: fnd_message.raise_error;

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;

Line 235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 236: fnd_message.set_token('FIELD','p_dpnt_dsgn_ctfn_typ_cd');

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;

Line 237: fnd_message.set_token('TYPE','BEN_DPNT_CVG_CTFN_TYP');

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: --

Line 238: fnd_message.raise_error;

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;

Line 249: fnd_message.set_name('BEN', 'BEN_91632_DUP_DPNT_CTFN');

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;

Line 250: fnd_message.raise_error;

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: --

Line 322: fnd_message.set_name('BEN','BEN_94211_DPNT_CTFN_RECD_DT');

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: --

Line 323: fnd_message.raise_error;

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;

Line 437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 438: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 439: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 440: fnd_message.raise_error;

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 >--------------------------|

Line 540: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 541: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 542: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 543: fnd_message.raise_error;

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 >----------------------------|

Line 733: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 734: fnd_message.raise_error;

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;