137: open c;
138: fetch c into recinfo;
139: if (c%notfound) then
140: close c;
141: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
142: app_exception.raise_exception;
143: end if;
144: close c;
145: if ( (recinfo.WHNVR_TRGRD_FLAG = P_WHNVR_TRGRD_FLAG)
150: AND (recinfo.INSPN_RQD_FLAG = P_INSPN_RQD_FLAG)
151: ) then
152: null;
153: else
154: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
155: app_exception.raise_exception;
156: end if;
157:
158: for tlinfo in c1 loop
160: if ( (tlinfo.NAME = P_NAME)
161: ) then
162: null;
163: else
164: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
165: app_exception.raise_exception;
166: end if;
167: end if;
168: end loop;