DBA Data[Home] [Help]

APPS.BEN_OPT_BUS dependencies on FND_MESSAGE

Line 126: fnd_message.set_name('BEN','BEN_93724_CWB_CHILD_EXIST');

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 ;

Line 127: fnd_message.set_name('NAME', p_name); /* Bug 4057566 */

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 ;

Line 128: fnd_message.raise_error;

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: --

Line 189: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');

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 ;

Line 190: fnd_message.raise_error;

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: */

Line 204: fnd_message.set_name('BEN','BEN_93725_CWB_GROUP_PLN_NULL');

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: */

Line 205: fnd_message.raise_error;

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:

Line 216: fnd_message.set_name('BEN','BEN_93726_CWB_PRTN_PLN_ERROR');

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:

Line 217: fnd_message.raise_error;

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 ,

Line 462: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');

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: --

Line 463: fnd_message.raise_error;

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;

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

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;

Line 536: fnd_message.raise_error;

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: --

Line 607: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

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: --

Line 608: fnd_message.raise_error;

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;

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

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;

Line 677: fnd_message.set_token('FIELD', 'p_mapping_table_name');

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: --

Line 678: fnd_message.set_token('VALUE', p_mapping_table_name);

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;

Line 679: fnd_message.set_token('TYPE', 'BEN_MAPPING_OPTION_TABLE');

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: --

Line 680: fnd_message.raise_error;

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;

Line 844: fnd_message.set_name('BEN','BEN_93323_OPT_MAPPING_NOT_UNIQ');

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: --

Line 845: fnd_message.raise_error;

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;