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;
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: --
300: (p_ext_crit_typ_id => p_ext_crit_typ_id,
301: p_object_version_number => p_object_version_number);
302: --
303: if p_crit_typ_cd is null then
304: fnd_message.set_name('BEN','BEN_91900_CRIT_CD_NULL');
305: fnd_message.raise_error;
306: end if;
307: --
308: if (l_api_updating
301: p_object_version_number => p_object_version_number);
302: --
303: if p_crit_typ_cd is null then
304: fnd_message.set_name('BEN','BEN_91900_CRIT_CD_NULL');
305: fnd_message.raise_error;
306: end if;
307: --
308: if (l_api_updating
309: and p_crit_typ_cd
321: p_effective_date => p_effective_date) then
322: --
323: -- raise error as does not exist as lookup
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
322: --
323: -- raise error as does not exist as lookup
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
330: end if;
323: -- raise error as does not exist as lookup
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
330: end if;
331: else
324: --
325: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
326: fnd_message.set_token('FIELD','p_crit_typ_cd');
327: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
328: fnd_message.raise_error;
329: --
330: end if;
331: else
332: /* BG is null, so alternative call is required */
336: p_effective_date => p_effective_date) then
337: --
338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
337: --
338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
338: -- raise error as does not exist as lookup
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
346: --
339: --
340: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
341: fnd_message.set_token('FIELD','p_crit_typ_cd');
342: fnd_message.set_name('TYPE','BEN_EXT_CRIT_TYP');
343: fnd_message.raise_error;
344: --
345: end if;
346: --
347: end if; /* p_business_group_id is not null */
414: open c1;
415: fetch c1 into l_dummy;
416: if c1%found then
417: close c1;
418: fnd_message.set_name('BEN','BEN_91898_EXT_CRIT_TYP_UPD');
419: fnd_message.raise_error;
420: end if;
421: --
422: end if;
415: fetch c1 into l_dummy;
416: if c1%found then
417: close c1;
418: fnd_message.set_name('BEN','BEN_91898_EXT_CRIT_TYP_UPD');
419: fnd_message.raise_error;
420: end if;
421: --
422: end if;
423: --
477: open c1;
478: fetch c1 into l_dummy;
479: if c1%found then
480: close c1;
481: fnd_message.set_name('BEN','BEN_91899_EXT_CRIT_TYP_EXISTS');
482: fnd_message.raise_error;
483: end if;
484: --
485: hr_utility.set_location('Leaving:'||l_proc, 15);
478: fetch c1 into l_dummy;
479: if c1%found then
480: close c1;
481: fnd_message.set_name('BEN','BEN_91899_EXT_CRIT_TYP_EXISTS');
482: fnd_message.raise_error;
483: end if;
484: --
485: hr_utility.set_location('Leaving:'||l_proc, 15);
486: End chk_crit_cd_unique;
530: --
531: -- ensure that excld_flag is not null
532: --
533: if p_excld_flag is null then
534: fnd_message.set_name('BEN','BEN_92123_EXCLD_FLAG_NULL');
535: fnd_message.raise_error;
536: end if;
537: --
538: -- ensure that the excld_flag has a valid value
531: -- ensure that excld_flag is not null
532: --
533: if p_excld_flag is null then
534: fnd_message.set_name('BEN','BEN_92123_EXCLD_FLAG_NULL');
535: fnd_message.raise_error;
536: end if;
537: --
538: -- ensure that the excld_flag has a valid value
539: --
553: p_effective_date => p_effective_date) then
554: --
555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
554: --
555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;
555: -- raise error message
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;
563: else
556: --
557: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
558: fnd_message.set_token('FIELD', 'p_excld_flag');
559: fnd_message.set_token('TYPE', 'YES_NO');
560: fnd_message.raise_error;
561: --
562: end if;
563: else
564: /* BG is null, so alternative call is required */
568: p_effective_date => p_effective_date) then
569: --
570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
569: --
570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;
570: -- raise error message
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
571: --
572: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
573: fnd_message.set_token('FIELD', 'p_excld_flag');
574: fnd_message.set_token('TYPE', 'YES_NO');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: end if; /* p_business_group_id is not null */
757: close csr_leg_code;
758: --
759: -- The primary key is invalid therefore we must error
760: --
761: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
762: fnd_message.raise_error;
763: --
764: end if;
765: --
758: --
759: -- The primary key is invalid therefore we must error
760: --
761: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
762: fnd_message.raise_error;
763: --
764: end if;
765: --
766: close csr_leg_code;