DBA Data[Home] [Help]

APPS.BEN_PCD_BUS dependencies on FND_MESSAGE

Line 211: fnd_message.set_name('BEN','BEN_91882_TO_BE_SENT_DT_ERR');

207: and p_to_be_sent_dt is not null then
208: --
209: if p_to_be_sent_dt < p_effective_date then
210: --
211: fnd_message.set_name('BEN','BEN_91882_TO_BE_SENT_DT_ERR');
212: fnd_message.raise_error;
213: --
214: end if;
215: --

Line 212: fnd_message.raise_error;

208: --
209: if p_to_be_sent_dt < p_effective_date then
210: --
211: fnd_message.set_name('BEN','BEN_91882_TO_BE_SENT_DT_ERR');
212: fnd_message.raise_error;
213: --
214: end if;
215: --
216: end if;

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

276: p_effective_date => p_effective_date) then
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --

Line 281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');

277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;

Line 282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');

278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;
286: --

Line 283: fnd_message.raise_error;

279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
287: end if;

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

348: p_effective_date => p_effective_date) then
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --

Line 353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');

349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;

Line 354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');

350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;
358: --

Line 355: fnd_message.raise_error;

351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
359: end if;

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

419: p_effective_date => p_effective_date) then
420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --

Line 424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');

420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;

Line 425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');

421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;
429: --

Line 426: fnd_message.raise_error;

422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
430: end if;

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

491: p_effective_date => p_effective_date) then
492: --
493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --

Line 496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');

492: --
493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;

Line 497: fnd_message.set_token('TYPE','BEN_RESND_RSN');

493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;
501: --

Line 498: fnd_message.raise_error;

494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;
501: --
502: end if;

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

561: p_effective_date => p_effective_date) then
562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --

Line 566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');

562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;

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

563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;
571: --

Line 568: fnd_message.raise_error;

564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;
571: --
572: end if;

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

632: p_effective_date => p_effective_date) then
633: --
634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --

Line 637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');

633: --
634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;

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

634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;
642: --

Line 639: fnd_message.raise_error;

635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;
642: --
643: end if;

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

738: --
739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;

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

739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --

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

740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --
748: -- ----------------------------------------------------------------------------

Line 745: fnd_message.raise_error;

741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --
748: -- ----------------------------------------------------------------------------
749: -- |--------------------------< dt_delete_validate >--------------------------|

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

840: --
841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;

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

841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --

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

842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------

Line 847: fnd_message.raise_error;

843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------
851: -- |---------------------------< insert_validate >----------------------------|

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

1075: close csr_leg_code;
1076: --
1077: -- The primary key is invalid therefore we must error
1078: --
1079: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1080: fnd_message.raise_error;
1081: --
1082: end if;
1083: --

Line 1080: fnd_message.raise_error;

1076: --
1077: -- The primary key is invalid therefore we must error
1078: --
1079: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1080: fnd_message.raise_error;
1081: --
1082: end if;
1083: --
1084: close csr_leg_code;