59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CWB_WKSHT_GRP_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
377: IF NOT ben_cwg_shd.api_updating
378: (p_cwb_wksht_grp_id => p_rec.cwb_wksht_grp_id
379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
378: (p_cwb_wksht_grp_id => p_rec.cwb_wksht_grp_id
379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --
379: ,p_object_version_number => p_rec.object_version_number
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --
387: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
380: ) THEN
381: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
382: fnd_message.set_token('PROCEDURE ', l_proc);
383: fnd_message.set_token('STEP ', '5');
384: fnd_message.raise_error;
385: END IF;
386: --
387: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
388: nvl(ben_cwg_shd.g_old_rec.business_group_id,hr_api.g_number) then
436: p_effective_date => p_effective_date) then
437: --
438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
437: --
438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --
438: -- raise error as does not exist as lookup
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --
446: end if;
439: --
440: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
441: fnd_message.set_token('FIELD', 'p_status_cd '||p_status_cd);
442: fnd_message.set_token('TYPE','BEN_CWG_STAT');
443: fnd_message.raise_error;
444: end if;
445: --
446: end if;
447: --
481: p_effective_date => p_effective_date) then
482: --
483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
482: --
483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
483: -- raise error as does not exist as lookup
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;
484: --
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;
492: end if ;
485: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
486: fnd_message.set_token('FIELD', 'p_hidden_cd');
487: fnd_message.set_token('VALUE', p_hidden_cd);
488: fnd_message.set_token('TYPE','BEN_WS_ACC');
489: fnd_message.raise_error;
490: --
491: end if;
492: end if ;
493: --
564: fetch c_cwg into l_dummy;
565: close c_cwg;
566:
567: if l_dummy = 1 then
568: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
569: fnd_message.raise_error;
570: end if;
571: end if;
572: end chk_ordr_num;
565: close c_cwg;
566:
567: if l_dummy = 1 then
568: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
569: fnd_message.raise_error;
570: end if;
571: end if;
572: end chk_ordr_num;
573: --
634: fetch c_cwg into l_dummy;
635: close c_cwg;
636:
637: if l_dummy = 1 then
638: fnd_message.set_name('BEN','BEN_93316_LABEL_NOT_UNIQUE');
639: fnd_message.raise_error;
640: end if;
641: end if;
642: end chk_uniq_label;
635: close c_cwg;
636:
637: if l_dummy = 1 then
638: fnd_message.set_name('BEN','BEN_93316_LABEL_NOT_UNIQUE');
639: fnd_message.raise_error;
640: end if;
641: end if;
642: end chk_uniq_label;
643: --
700: p_effective_date => p_effective_date) then
701: --
702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
701: --
702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
702: -- raise error as does not exist as lookup
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;
703: --
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;
711:
704: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
705: fnd_message.set_token('FIELD','p_wksht_grp_cd');
706: fnd_message.set_token('VALUE', p_wksht_grp_cd);
707: fnd_message.set_token('TYPE','BEN_WKSHT_GRP');
708: fnd_message.raise_error;
709: --
710: end if;
711:
712: end if;