DBA Data[Home] [Help]

APPS.BEN_XDF_BUS dependencies on FND_MESSAGE

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

50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;

Line 55: fnd_message.raise_error;

51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --

Line 333: fnd_message.set_name('BEN','BEN_91784_DATA_NULL');

329: (p_ext_dfn_id => p_ext_dfn_id,
330: p_object_version_number => p_object_version_number);
331: --
332: if p_data_typ_cd is null then
333: fnd_message.set_name('BEN','BEN_91784_DATA_NULL');
334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd

Line 334: fnd_message.raise_error;

330: p_object_version_number => p_object_version_number);
331: --
332: if p_data_typ_cd is null then
333: fnd_message.set_name('BEN','BEN_91784_DATA_NULL');
334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd
338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)

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

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

Line 355: fnd_message.set_token('FIELD','p_data_typ_cd');

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

Line 356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');

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

Line 357: fnd_message.raise_error;

353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD','p_data_typ_cd');
356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
357: fnd_message.raise_error;
358: --
359: end if;
360: --
361: else

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

366: p_effective_date => p_effective_date) then
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --

Line 371: fnd_message.set_token('FIELD','p_data_typ_cd');

367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;

Line 372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');

368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;
376: --

Line 373: fnd_message.raise_error;

369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
377: end if;

Line 381: fnd_message.set_name('BEN','BEN_91782_EXT_CRIT_PRFL_NULL');

377: end if;
378: --
379: if p_data_typ_cd = 'C' then
380: if p_ext_crit_prfl_id is null then
381: fnd_message.set_name('BEN','BEN_91782_EXT_CRIT_PRFL_NULL');
382: fnd_message.raise_error;
383: end if;
384: end if;
385: end if;

Line 382: fnd_message.raise_error;

378: --
379: if p_data_typ_cd = 'C' then
380: if p_ext_crit_prfl_id is null then
381: fnd_message.set_name('BEN','BEN_91782_EXT_CRIT_PRFL_NULL');
382: fnd_message.raise_error;
383: end if;
384: end if;
385: end if;
386: --

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

449: p_effective_date => p_effective_date) then
450: --
451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --

Line 454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');

450: --
451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;

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

451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;
459: --

Line 456: fnd_message.raise_error;

452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
460: else

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

465: p_effective_date => p_effective_date) then
466: --
467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --

Line 470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');

466: --
467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;

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

467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;
475: --

Line 472: fnd_message.raise_error;

468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;
475: --
476: end if;

Line 483: fnd_message.set_name('BEN','BEN_91774_OUTPUT_NAME_NULL');

479: end if;
480:
481: if p_apnd_rqst_id_flag = 'Y' then
482: if p_output_name is null then
483: fnd_message.set_name('BEN','BEN_91774_OUTPUT_NAME_NULL');
484: fnd_message.raise_error;
485: end if;
486: end if;
487:

Line 484: fnd_message.raise_error;

480:
481: if p_apnd_rqst_id_flag = 'Y' then
482: if p_output_name is null then
483: fnd_message.set_name('BEN','BEN_91774_OUTPUT_NAME_NULL');
484: fnd_message.raise_error;
485: end if;
486: end if;
487:
488: --

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

548: p_effective_date => p_effective_date) then
549: --
550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --

Line 553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');

549: --
550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;

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

550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;
558: --

Line 555: fnd_message.raise_error;

551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;
558: --
559: else

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

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

Line 569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');

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

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

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

Line 571: fnd_message.raise_error;

567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
570: fnd_message.set_token('TYPE','YES_NO');
571: fnd_message.raise_error;
572: --
573: end if;
574: --
575: end if;

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

637: p_effective_date => p_effective_date) then
638: --
639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --

Line 642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');

638: --
639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;

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

639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;
647: --

Line 644: fnd_message.raise_error;

640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;
647: --
648: else

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

653: p_effective_date => p_effective_date) then
654: --
655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --

Line 658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');

654: --
655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;

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

655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;
663: --

Line 660: fnd_message.raise_error;

656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;
663: --
664: end if;

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

704: p_effective_date => p_effective_date) then
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --

Line 709: fnd_message.set_token('FIELD','p_ext_global_flag');

705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;

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

706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;
714: --

Line 711: fnd_message.raise_error;

707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
715: else

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

720: p_effective_date => p_effective_date) then
721: --
722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --

Line 725: fnd_message.set_token('FIELD','p_ext_global_flag');

721: --
722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;

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

722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;
730: --

Line 727: fnd_message.raise_error;

723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;
730: --
731: end if;

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

771: p_effective_date => p_effective_date) then
772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --

Line 776: fnd_message.set_token('FIELD','p_cm_display_flag');

772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;

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

773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;
781: --

Line 778: fnd_message.raise_error;

774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
782: else

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

787: p_effective_date => p_effective_date) then
788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --

Line 792: fnd_message.set_token('FIELD','cm_display_flag');

788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;

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

789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;
797: --

Line 794: fnd_message.raise_error;

790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;
797: --
798: end if;

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

861: p_effective_date => p_effective_date) then
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --

Line 866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');

862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;

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

863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;
871: --

Line 868: fnd_message.raise_error;

864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
872: else

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

877: p_effective_date => p_effective_date) then
878: --
879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --

Line 882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');

878: --
879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;

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

879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;
887: --

Line 884: fnd_message.raise_error;

880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;
887: --
888: end if;

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

951: p_effective_date => p_effective_date) then
952: --
953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --

Line 956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');

952: --
953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;

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

953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;
961: --

Line 958: fnd_message.raise_error;

954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;
961: --
962: else

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

967: p_effective_date => p_effective_date) then
968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --

Line 972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');

968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;

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

969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;
977: --

Line 974: fnd_message.raise_error;

970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;
977: --
978: end if;

Line 1042: fnd_message.set_name('BEN','BEN_91776_END_DT_NULL');

1038: --
1039: if p_data_typ_cd = 'F' then
1040: if not (p_strt_dt is not null
1041: and p_end_dt is null) then
1042: fnd_message.set_name('BEN','BEN_91776_END_DT_NULL');
1043: fnd_message.raise_error;
1044: end if;
1045: end if;
1046: --

Line 1043: fnd_message.raise_error;

1039: if p_data_typ_cd = 'F' then
1040: if not (p_strt_dt is not null
1041: and p_end_dt is null) then
1042: fnd_message.set_name('BEN','BEN_91776_END_DT_NULL');
1043: fnd_message.raise_error;
1044: end if;
1045: end if;
1046: --
1047: if p_data_typ_cd in ('C', 'CM') then

Line 1050: fnd_message.set_name('BEN','BEN_91780_STRT_DT_NULL');

1046: --
1047: if p_data_typ_cd in ('C', 'CM') then
1048: if not (p_strt_dt is not null
1049: and p_end_dt is not null) then
1050: fnd_message.set_name('BEN','BEN_91780_STRT_DT_NULL');
1051: fnd_message.raise_error;
1052: end if;
1053: end if;
1054: --

Line 1051: fnd_message.raise_error;

1047: if p_data_typ_cd in ('C', 'CM') then
1048: if not (p_strt_dt is not null
1049: and p_end_dt is not null) then
1050: fnd_message.set_name('BEN','BEN_91780_STRT_DT_NULL');
1051: fnd_message.raise_error;
1052: end if;
1053: end if;
1054: --
1055: if (l_api_updating

Line 1068: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');

1064: --
1065: l_dummy := to_date(p_strt_dt,'DD/MM/YYYY');
1066: exception
1067: when others then
1068: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1069: fnd_message.raise_error;
1070: end;
1071: else
1072: -- check if value of lookup falls within lookup type.

Line 1069: fnd_message.raise_error;

1065: l_dummy := to_date(p_strt_dt,'DD/MM/YYYY');
1066: exception
1067: when others then
1068: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1069: fnd_message.raise_error;
1070: end;
1071: else
1072: -- check if value of lookup falls within lookup type.
1073: --

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

1080: p_effective_date => p_effective_date) then
1081: --
1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --

Line 1085: fnd_message.set_token('FIELD','p_strt_dt');

1081: --
1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;

Line 1086: fnd_message.set_token('TYPE','BEN_EXT_DT');

1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --

Line 1087: fnd_message.raise_error;

1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1091: else

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

1096: p_effective_date => p_effective_date) then
1097: --
1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --

Line 1101: fnd_message.set_token('FIELD','p_strt_dt');

1097: --
1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;

Line 1102: fnd_message.set_token('TYPE','BEN_EXT_DT');

1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --

Line 1103: fnd_message.raise_error;

1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --
1107: end if;

Line 1123: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');

1119: --
1120: l_dummy := to_date(p_end_dt,'DD/MM/YYYY');
1121: exception
1122: when others then
1123: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1124: fnd_message.raise_error;
1125: end;
1126:
1127: else

Line 1124: fnd_message.raise_error;

1120: l_dummy := to_date(p_end_dt,'DD/MM/YYYY');
1121: exception
1122: when others then
1123: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1124: fnd_message.raise_error;
1125: end;
1126:
1127: else
1128: -- check if value of lookup falls within lookup type.

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

1135: p_effective_date => p_effective_date) then
1136: --
1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --

Line 1140: fnd_message.set_token('FIELD','p_end_dt');

1136: --
1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;

Line 1141: fnd_message.set_token('TYPE','BEN_EXT_DT');

1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --

Line 1142: fnd_message.raise_error;

1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --
1146: else

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

1151: p_effective_date => p_effective_date) then
1152: --
1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --

Line 1156: fnd_message.set_token('FIELD','p_end_dt');

1152: --
1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;

Line 1157: fnd_message.set_token('TYPE','BEN_EXT_DT');

1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --

Line 1158: fnd_message.raise_error;

1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --
1162: end if;

Line 1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');

1203: Begin
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;
1209: end if;
1210: --
1211: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 1208: fnd_message.raise_error;

1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;
1209: end if;
1210: --
1211: hr_utility.set_location('Leaving:'||l_proc, 15);
1212: End chk_output_file;

Line 1239: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');

1235: --
1236: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
1237: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
1238: then
1239: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
1240: fnd_message.raise_error;
1241: end if;
1242:
1243: if p_xdo_template_id is not null then

Line 1240: fnd_message.raise_error;

1236: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
1237: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
1238: then
1239: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
1240: fnd_message.raise_error;
1241: end if;
1242:
1243: if p_xdo_template_id is not null then
1244: open c ;

Line 1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

1244: open c ;
1245: fetch c into l_source_code ;
1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;

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

1245: fetch c into l_source_code ;
1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;

Line 1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');

1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;
1254:

Line 1251: fnd_message.raise_error;

1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;
1254:
1255: -- make sure correct template attched to correct extract defintionm

Line 1262: fnd_message.set_name('BEN', 'BEN_94499_EXT_WRONG_XDO');

1258:
1259: if (p_cm_display_flag = 'Y' and l_source_code <> 'BENXMLWRIT' ) OR
1260: (p_cm_display_flag <> 'Y' and l_source_code = 'BENXMLWRIT' ) then
1261:
1262: fnd_message.set_name('BEN', 'BEN_94499_EXT_WRONG_XDO');
1263: fnd_message.raise_error;
1264:
1265: end if ;
1266:

Line 1263: fnd_message.raise_error;

1259: if (p_cm_display_flag = 'Y' and l_source_code <> 'BENXMLWRIT' ) OR
1260: (p_cm_display_flag <> 'Y' and l_source_code = 'BENXMLWRIT' ) then
1261:
1262: fnd_message.set_name('BEN', 'BEN_94499_EXT_WRONG_XDO');
1263: fnd_message.raise_error;
1264:
1265: end if ;
1266:
1267:

Line 1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');

1319: Begin
1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: if p_name is null then
1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
1324: fnd_message.raise_error;
1325: end if;
1326: open c1;
1327: fetch c1 into l_dummy;

Line 1324: fnd_message.raise_error;

1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: if p_name is null then
1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
1324: fnd_message.raise_error;
1325: end if;
1326: open c1;
1327: fetch c1 into l_dummy;
1328: if c1%found then

Line 1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

1326: open c1;
1327: fetch c1 into l_dummy;
1328: if c1%found then
1329: close c1;
1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1331: fnd_message.raise_error;
1332: end if;
1333: --
1334: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 1331: fnd_message.raise_error;

1327: fetch c1 into l_dummy;
1328: if c1%found then
1329: close c1;
1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1331: fnd_message.raise_error;
1332: end if;
1333: --
1334: hr_utility.set_location('Leaving:'||l_proc, 15);
1335: End chk_name_unique;

Line 1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');

1409: fetch c_ext_rslt into l_dummy ;
1410: close c_ext_rslt;
1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;

Line 1414: fnd_message.set_token('TABLE_NAME','Extract Results');

1410: close c_ext_rslt;
1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;
1418:

Line 1415: fnd_message.raise_error;

1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;
1418:
1419: --