DBA Data[Home] [Help]

APPS.BEN_PCS_BUS dependencies on FND_MESSAGE

Line 114: fnd_message.set_name('BEN','BEN_92335_RECD_DND_DATES');

110:
111: if p_enrt_ctfn_recd_dt is not null then
112: if
113: p_enrt_ctfn_dnd_dt is not null then
114: fnd_message.set_name('BEN','BEN_92335_RECD_DND_DATES');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --

Line 115: fnd_message.raise_error;

111: if p_enrt_ctfn_recd_dt is not null then
112: if
113: p_enrt_ctfn_dnd_dt is not null then
114: fnd_message.set_name('BEN','BEN_92335_RECD_DND_DATES');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --
119: hr_utility.set_location('Leaving:'||l_proc, 10);

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

177: p_effective_date => p_effective_date) then
178: --
179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --

Line 182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');

178: --
179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;

Line 183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');

179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;
187: --

Line 184: fnd_message.raise_error;

180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;
187: --
188: end if;

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

249: p_effective_date => p_effective_date) then
250: --
251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --

Line 254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');

250: --
251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;

Line 255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');

251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;
259: --

Line 256: fnd_message.raise_error;

252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;
259: --
260: end if;

Line 343: fnd_message.set_name('BEN','BEN_91601_ENRT_VOID_DT');

339: if p_enrt_ctfn_recd_dt > l_due_dt then
340: --
341: -- raise error as does not satisfy the condition
342: --
343: fnd_message.set_name('BEN','BEN_91601_ENRT_VOID_DT');
344: fnd_message.raise_error;
345: --
346: end if;
347: --

Line 344: fnd_message.raise_error;

340: --
341: -- raise error as does not satisfy the condition
342: --
343: fnd_message.set_name('BEN','BEN_91601_ENRT_VOID_DT');
344: fnd_message.raise_error;
345: --
346: end if;
347: --
348: end if;

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

410: p_effective_date => p_effective_date) then
411: --
412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --

Line 415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');

411: --
412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;

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

412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;
420: --

Line 417: fnd_message.raise_error;

413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;
420: --
421: end if;

Line 524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

520: --
521: -- A referential integrity check was violated therefore
522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --

Line 525: fnd_message.set_token('TABLE_NAME', l_table_name);

521: -- A referential integrity check was violated therefore
522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --
529: -- An unhandled or unexpected error has occurred which

Line 526: fnd_message.raise_error;

522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --
529: -- An unhandled or unexpected error has occurred which
530: -- we must report

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

528: --
529: -- An unhandled or unexpected error has occurred which
530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;

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

529: -- An unhandled or unexpected error has occurred which
530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --

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

530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --
538: -- ----------------------------------------------------------------------------

Line 535: fnd_message.raise_error;

531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --
538: -- ----------------------------------------------------------------------------
539: -- |--------------------------< dt_delete_validate >--------------------------|

Line 628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

624: --
625: -- A referential integrity check was violated therefore
626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --

Line 629: fnd_message.set_token('TABLE_NAME', l_table_name);

625: -- A referential integrity check was violated therefore
626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --
633: -- An unhandled or unexpected error has occurred which

Line 630: fnd_message.raise_error;

626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --
633: -- An unhandled or unexpected error has occurred which
634: -- we must report

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

632: --
633: -- An unhandled or unexpected error has occurred which
634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;

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

633: -- An unhandled or unexpected error has occurred which
634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --

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

634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --
642: -- ----------------------------------------------------------------------------

Line 639: fnd_message.raise_error;

635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --
642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< insert_validate >----------------------------|

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

836: close csr_leg_code;
837: --
838: -- The primary key is invalid therefore we must error
839: --
840: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
841: fnd_message.raise_error;
842: --
843: end if;
844: --

Line 841: fnd_message.raise_error;

837: --
838: -- The primary key is invalid therefore we must error
839: --
840: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
841: fnd_message.raise_error;
842: --
843: end if;
844: --
845: close csr_leg_code;