130: open c;
131: fetch c into recinfo;
132: if (c%notfound) then
133: close c;
134: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
135: app_exception.raise_exception;
136: end if;
137: close c;
138: if ( ((recinfo.VIEWBY_id = X_VIEWBY_id)
141: AND (recinfo.root_value = x_root_value)
142: ) then
143: null;
144: else
145: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
146: app_exception.raise_exception;
147: end if;
148:
149: for tlinfo in c1 loop
151: if ( (tlinfo.ROOT_LABEL = X_ROOT_LABEL)
152: ) then
153: null;
154: else
155: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
156: app_exception.raise_exception;
157: end if;
158: end if;
159: end loop;