124: if c_child_nodes%notfound then
125: close c_child_nodes;
126:
127: -- since no data found therefore we must error
128: fnd_message.set_name('HXC', 'HXC_PREF_FULL_NAME_NOT_EXIST');
129: fnd_message.raise_error;
130: end if;
131:
132: close c_child_nodes;
125: close c_child_nodes;
126:
127: -- since no data found therefore we must error
128: fnd_message.set_name('HXC', 'HXC_PREF_FULL_NAME_NOT_EXIST');
129: fnd_message.raise_error;
130: end if;
131:
132: close c_child_nodes;
133: