DBA Data[Home] [Help]

APPS.BEN_CRT_BUS dependencies on FND_MESSAGE

Line 254: fnd_message.set_name('BEN','BEN_93965_SELECT_ACTIVE_PLAN');

250: close c2;
251: --
252: -- Raise error as inactive plan is selected
253: --
254: fnd_message.set_name('BEN','BEN_93965_SELECT_ACTIVE_PLAN');
255: fnd_message.raise_error;
256: --
257: end if;
258: --

Line 255: fnd_message.raise_error;

251: --
252: -- Raise error as inactive plan is selected
253: --
254: fnd_message.set_name('BEN','BEN_93965_SELECT_ACTIVE_PLAN');
255: fnd_message.raise_error;
256: --
257: end if;
258: --
259: close c2;

Line 298: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT'); -- 3709010

294: if p_start_Date is not null and p_end_date is not null and p_start_date > p_end_date then
295: --
296: -- raise error Start Date must precede End date
297: --
298: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT'); -- 3709010
299: hr_utility.set_message_token('START',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
300: hr_utility.set_message_token('END',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
301: fnd_message.raise_error;
302: --

Line 301: fnd_message.raise_error;

297: --
298: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT'); -- 3709010
299: hr_utility.set_message_token('START',to_char(p_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
300: hr_utility.set_message_token('END',to_char(p_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
301: fnd_message.raise_error;
302: --
303: end if;
304: --
305: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 427: fnd_message.set_name('BEN','BEN_92398_PL_PLTYP_BNULL');

423: if p_pl_id is null and
424: p_pl_typ_id is null then
425: --
426: -- raise error as at least one must exist
427: fnd_message.set_name('BEN','BEN_92398_PL_PLTYP_BNULL');
428: fnd_message.raise_error;
429: --
430: --
431: elsif p_pl_id is not null and

Line 428: fnd_message.raise_error;

424: p_pl_typ_id is null then
425: --
426: -- raise error as at least one must exist
427: fnd_message.set_name('BEN','BEN_92398_PL_PLTYP_BNULL');
428: fnd_message.raise_error;
429: --
430: --
431: elsif p_pl_id is not null and
432: p_pl_typ_id is not null then

Line 435: fnd_message.set_name('BEN','BEN_92399_PL_PLTYP_BVAL');

431: elsif p_pl_id is not null and
432: p_pl_typ_id is not null then
433: --
434: -- raise error as only one may exist
435: fnd_message.set_name('BEN','BEN_92399_PL_PLTYP_BVAL');
436: fnd_message.raise_error;
437: end if;
438: --
439: hr_utility.set_location('Leaving:'||l_proc,10);

Line 436: fnd_message.raise_error;

432: p_pl_typ_id is not null then
433: --
434: -- raise error as only one may exist
435: fnd_message.set_name('BEN','BEN_92399_PL_PLTYP_BVAL');
436: fnd_message.raise_error;
437: end if;
438: --
439: hr_utility.set_location('Leaving:'||l_proc,10);
440: --

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

497: p_effective_date => p_effective_date) then
498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
502: fnd_message.set_token('FIELD','p_qdro_dstr_mthd_cd');
503: fnd_message.set_token('TYPE','BEN_QDRO_DSTR_MTHD');
504: fnd_message.raise_error;
505: --

Line 502: fnd_message.set_token('FIELD','p_qdro_dstr_mthd_cd');

498: --
499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
502: fnd_message.set_token('FIELD','p_qdro_dstr_mthd_cd');
503: fnd_message.set_token('TYPE','BEN_QDRO_DSTR_MTHD');
504: fnd_message.raise_error;
505: --
506: end if;

Line 503: fnd_message.set_token('TYPE','BEN_QDRO_DSTR_MTHD');

499: -- raise error as does not exist as lookup
500: --
501: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
502: fnd_message.set_token('FIELD','p_qdro_dstr_mthd_cd');
503: fnd_message.set_token('TYPE','BEN_QDRO_DSTR_MTHD');
504: fnd_message.raise_error;
505: --
506: end if;
507: --

Line 504: fnd_message.raise_error;

500: --
501: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
502: fnd_message.set_token('FIELD','p_qdro_dstr_mthd_cd');
503: fnd_message.set_token('TYPE','BEN_QDRO_DSTR_MTHD');
504: fnd_message.raise_error;
505: --
506: end if;
507: --
508: end if;

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

568: p_effective_date => p_effective_date) then
569: --
570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD','p_qdro_per_perd_cd');
574: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
575: fnd_message.raise_error;
576: --

Line 573: fnd_message.set_token('FIELD','p_qdro_per_perd_cd');

569: --
570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD','p_qdro_per_perd_cd');
574: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
575: fnd_message.raise_error;
576: --
577: end if;

Line 574: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');

570: -- raise error as does not exist as lookup
571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD','p_qdro_per_perd_cd');
574: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
575: fnd_message.raise_error;
576: --
577: end if;
578: --

Line 575: fnd_message.raise_error;

571: --
572: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD','p_qdro_per_perd_cd');
574: fnd_message.set_token('TYPE','BEN_BNDRY_PERD');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: end if;

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

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

Line 643: fnd_message.set_token('FIELD','p_crt_ordr_typ_cd');

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

Line 644: fnd_message.set_token('TYPE','BEN_CRT_ORDR_TYP');

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

Line 645: fnd_message.raise_error;

641: --
642: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
643: fnd_message.set_token('FIELD','p_crt_ordr_typ_cd');
644: fnd_message.set_token('TYPE','BEN_CRT_ORDR_TYP');
645: fnd_message.raise_error;
646: --
647: end if;
648: --
649: end if;

Line 707: fnd_message.set_name('BEN','BEN_91977_DT_RQD_CRTORDR');

703: (p_crt_ordr_id => p_crt_ordr_id,
704: p_object_version_number => p_object_version_number);
705: --
706: If p_apls_perd_strtg_dt is null then
707: fnd_message.set_name('BEN','BEN_91977_DT_RQD_CRTORDR');
708: fnd_message.raise_error;
709: End If;
710:
711: If p_crt_ordr_typ_cd = 'QDRO' then

Line 708: fnd_message.raise_error;

704: p_object_version_number => p_object_version_number);
705: --
706: If p_apls_perd_strtg_dt is null then
707: fnd_message.set_name('BEN','BEN_91977_DT_RQD_CRTORDR');
708: fnd_message.raise_error;
709: End If;
710:
711: If p_crt_ordr_typ_cd = 'QDRO' then
712: If p_qdro_amt is null and p_qdro_pct is null then

Line 713: fnd_message.set_name('BEN','BEN_91978_AMT_PCT_RQD_QDRO');

709: End If;
710:
711: If p_crt_ordr_typ_cd = 'QDRO' then
712: If p_qdro_amt is null and p_qdro_pct is null then
713: fnd_message.set_name('BEN','BEN_91978_AMT_PCT_RQD_QDRO');
714: fnd_message.raise_error;
715: elsif p_qdro_amt is not null then
716: If p_uom is null then
717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');

Line 714: fnd_message.raise_error;

710:
711: If p_crt_ordr_typ_cd = 'QDRO' then
712: If p_qdro_amt is null and p_qdro_pct is null then
713: fnd_message.set_name('BEN','BEN_91978_AMT_PCT_RQD_QDRO');
714: fnd_message.raise_error;
715: elsif p_qdro_amt is not null then
716: If p_uom is null then
717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');
718: fnd_message.raise_error;

Line 717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');

713: fnd_message.set_name('BEN','BEN_91978_AMT_PCT_RQD_QDRO');
714: fnd_message.raise_error;
715: elsif p_qdro_amt is not null then
716: If p_uom is null then
717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');
718: fnd_message.raise_error;
719: End If;
720: If p_qdro_pct is not null then
721: fnd_message.set_name('BEN','BEN_91980_AMT_PCT_MUTEXCL');

Line 718: fnd_message.raise_error;

714: fnd_message.raise_error;
715: elsif p_qdro_amt is not null then
716: If p_uom is null then
717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');
718: fnd_message.raise_error;
719: End If;
720: If p_qdro_pct is not null then
721: fnd_message.set_name('BEN','BEN_91980_AMT_PCT_MUTEXCL');
722: fnd_message.raise_error;

Line 721: fnd_message.set_name('BEN','BEN_91980_AMT_PCT_MUTEXCL');

717: fnd_message.set_name('BEN','BEN_91979_AMT_UOM_RQD_QDRO');
718: fnd_message.raise_error;
719: End If;
720: If p_qdro_pct is not null then
721: fnd_message.set_name('BEN','BEN_91980_AMT_PCT_MUTEXCL');
722: fnd_message.raise_error;
723: End If;
724: elsif p_qdro_pct is not null then
725: If p_qdro_amt is not null or p_uom is not null then

Line 722: fnd_message.raise_error;

718: fnd_message.raise_error;
719: End If;
720: If p_qdro_pct is not null then
721: fnd_message.set_name('BEN','BEN_91980_AMT_PCT_MUTEXCL');
722: fnd_message.raise_error;
723: End If;
724: elsif p_qdro_pct is not null then
725: If p_qdro_amt is not null or p_uom is not null then
726: fnd_message.set_name('BEN','BEN_91981_PCT_AMTUOM_MUTEXCL');

Line 726: fnd_message.set_name('BEN','BEN_91981_PCT_AMTUOM_MUTEXCL');

722: fnd_message.raise_error;
723: End If;
724: elsif p_qdro_pct is not null then
725: If p_qdro_amt is not null or p_uom is not null then
726: fnd_message.set_name('BEN','BEN_91981_PCT_AMTUOM_MUTEXCL');
727: fnd_message.raise_error;
728: End if;
729: End if;
730: End if;

Line 727: fnd_message.raise_error;

723: End If;
724: elsif p_qdro_pct is not null then
725: If p_qdro_amt is not null or p_uom is not null then
726: fnd_message.set_name('BEN','BEN_91981_PCT_AMTUOM_MUTEXCL');
727: fnd_message.raise_error;
728: End if;
729: End if;
730: End if;
731:

Line 951: fnd_message.set_name('BEN','HR_7220_INVALID_PRIMARY_KEY');

947: close csr_leg_code;
948: --
949: -- The primary key is invalid therefore we must error
950: --
951: fnd_message.set_name('BEN','HR_7220_INVALID_PRIMARY_KEY');
952: fnd_message.raise_error;
953: --
954: end if;
955: --

Line 952: fnd_message.raise_error;

948: --
949: -- The primary key is invalid therefore we must error
950: --
951: fnd_message.set_name('BEN','HR_7220_INVALID_PRIMARY_KEY');
952: fnd_message.raise_error;
953: --
954: end if;
955: --
956: close csr_leg_code;