122: open c_child_exist ;
123: fetch c_child_exist into l_dummy ;
124: if c_child_exist%found then
125: close c_child_exist ;
126: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
127: fnd_message.set_name('NAME', p_name); /* Bug 4057566 */
128: fnd_message.raise_error;
129: end if ;
130: close c_child_exist ;
123: fetch c_child_exist into l_dummy ;
124: if c_child_exist%found then
125: close c_child_exist ;
126: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
127: fnd_message.set_name('NAME', p_name); /* Bug 4057566 */
128: fnd_message.raise_error;
129: end if ;
130: close c_child_exist ;
131: end if ;
124: if c_child_exist%found then
125: close c_child_exist ;
126: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');
127: fnd_message.set_name('NAME', p_name); /* Bug 4057566 */
128: fnd_message.raise_error;
129: end if ;
130: close c_child_exist ;
131: end if ;
132: --
185: fetch c_opt_cwb into l_opt_typ_cd ;
186: if c_opt_cwb%found then
187: if p_group_opt_id is null then
188: close c_opt_cwb ;
189: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
190: fnd_message.raise_error;
191: end if ;
192: end if ;
193: close c_opt_cwb ;
186: if c_opt_cwb%found then
187: if p_group_opt_id is null then
188: close c_opt_cwb ;
189: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
190: fnd_message.raise_error;
191: end if ;
192: end if ;
193: close c_opt_cwb ;
194: */
200: open c_opt_cwb ;
201: fetch c_opt_cwb into l_opt_typ_cd ;
202: if c_opt_cwb%notfound then
203: close c_opt_cwb ;
204: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
205: fnd_message.raise_error;
206: end if ;
207: close c_opt_cwb ;
208: */
201: fetch c_opt_cwb into l_opt_typ_cd ;
202: if c_opt_cwb%notfound then
203: close c_opt_cwb ;
204: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');
205: fnd_message.raise_error;
206: end if ;
207: close c_opt_cwb ;
208: */
209:
212: open c_parent_opt ;
213: fetch c_parent_opt into l_dummy ;
214: if c_parent_opt%notfound then
215: close c_parent_opt ;
216: fnd_message.set_name('BEN','BEN_93726_CWB_PRTN_PLN_ERROR');
217: fnd_message.raise_error;
218: end if ;
219: close c_parent_opt ;
220:
213: fetch c_parent_opt into l_dummy ;
214: if c_parent_opt%notfound then
215: close c_parent_opt ;
216: fnd_message.set_name('BEN','BEN_93726_CWB_PRTN_PLN_ERROR');
217: fnd_message.raise_error;
218: end if ;
219: close c_parent_opt ;
220:
221: chk_opt_group_child(p_opt_id => p_opt_id ,
458: p_effective_date => p_effective_date) then
459: --
460: -- raise error as does not exist as lookup
461: --
462: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');
463: fnd_message.raise_error;
464: --
465: end if;
466: --
459: --
460: -- raise error as does not exist as lookup
461: --
462: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');
463: fnd_message.raise_error;
464: --
465: end if;
466: --
467: end if;
531: if csr_name%found then
532: --
533: -- raise error as UK1 is violated
534: --
535: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
536: fnd_message.raise_error;
537: --ben_opt_shd.constraint_error('BEN_OPT_UK1');
538: --
539: end if;
532: --
533: -- raise error as UK1 is violated
534: --
535: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
536: fnd_message.raise_error;
537: --ben_opt_shd.constraint_error('BEN_OPT_UK1');
538: --
539: end if;
540: --
603: p_effective_date => p_effective_date) then
604: --
605: -- raise error as does not exist as lookup
606: --
607: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
608: fnd_message.raise_error;
609: --
610: end if;
611: --
604: --
605: -- raise error as does not exist as lookup
606: --
607: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
608: fnd_message.raise_error;
609: --
610: end if;
611: --
612: end if;
672: p_effective_date => p_effective_date) then
673: --
674: -- raise error as does not exist as lookup
675: --
676: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
677: fnd_message.set_token('FIELD', 'p_mapping_table_name');
678: fnd_message.set_token('VALUE', p_mapping_table_name);
679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');
680: fnd_message.raise_error;
673: --
674: -- raise error as does not exist as lookup
675: --
676: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
677: fnd_message.set_token('FIELD', 'p_mapping_table_name');
678: fnd_message.set_token('VALUE', p_mapping_table_name);
679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');
680: fnd_message.raise_error;
681: --
674: -- raise error as does not exist as lookup
675: --
676: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
677: fnd_message.set_token('FIELD', 'p_mapping_table_name');
678: fnd_message.set_token('VALUE', p_mapping_table_name);
679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');
680: fnd_message.raise_error;
681: --
682: end if;
675: --
676: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
677: fnd_message.set_token('FIELD', 'p_mapping_table_name');
678: fnd_message.set_token('VALUE', p_mapping_table_name);
679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');
680: fnd_message.raise_error;
681: --
682: end if;
683: --
676: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
677: fnd_message.set_token('FIELD', 'p_mapping_table_name');
678: fnd_message.set_token('VALUE', p_mapping_table_name);
679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');
680: fnd_message.raise_error;
681: --
682: end if;
683: --
684: end if;
840: if csr_mapping%found then
841: --
842: -- raise error
843: --
844: fnd_message.set_name('BEN','BEN_93323_OPT_MAPPING_NOT_UNIQ');
845: fnd_message.raise_error;
846: --
847: end if;
848: --
841: --
842: -- raise error
843: --
844: fnd_message.set_name('BEN','BEN_93323_OPT_MAPPING_NOT_UNIQ');
845: fnd_message.raise_error;
846: --
847: end if;
848: --
849: close csr_mapping;