94: */
95: if (r_name_lov%ROWCOUNT = 0) then
96: close r_name_lov;
97: -- Not displayed or internal role name, error
98: wf_core.token('ROLE', p_display_name);
99: wf_core.raise('WFNTF_ROLE');
100: end if;
101:
102: exit when r_name_lov%NOTFOUND;
95: if (r_name_lov%ROWCOUNT = 0) then
96: close r_name_lov;
97: -- Not displayed or internal role name, error
98: wf_core.token('ROLE', p_display_name);
99: wf_core.raise('WFNTF_ROLE');
100: end if;
101:
102: exit when r_name_lov%NOTFOUND;
103:
128: begin
129: l_orig_system_id := to_number(substr(p_user_name, l_colon+1));
130: exception
131: when value_error then
132: wf_core.raise('WFNTF_ORIGSYSTEMID');
133: when others then
134: raise;
135: end;
136: select count(1)
142: and DISPLAY_NAME = p_display_name;
143: end if;
144:
145: if (l_names_count <> 1) then
146: wf_core.token('ROLE', p_display_name);
147: wf_core.raise('WFNTF_UNIQUE_ROLE');
148: end if;
149:
150: exit;
143: end if;
144:
145: if (l_names_count <> 1) then
146: wf_core.token('ROLE', p_display_name);
147: wf_core.raise('WFNTF_UNIQUE_ROLE');
148: end if;
149:
150: exit;
151: end if;
165: when others then
166: if (r_name_lov%ISOPEN) then
167: close r_name_lov;
168: end if;
169: wf_core.context('Wf_Directory_Part_Util', 'validate_display_name',
170: p_display_name, p_user_name);
171: raise;
172: end validate_display_name;
173: