116: open c;
117: fetch c into recinfo;
118: if (c%notfound) then
119: close c;
120: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
121: app_exception.raise_exception;
122: end if;
123: close c;
124: if ( (recinfo.LANG_CODE = X_LANG_CODE)
128: AND (recinfo.DELETE_MARK = X_DELETE_MARK)
129: ) then
130: null;
131: else
132: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
133: app_exception.raise_exception;
134: end if;
135:
136: for tlinfo in c1 loop
139: AND (tlinfo.ORDER_STATUS_DESC = X_ORDER_STATUS_DESC)
140: ) then
141: null;
142: else
143: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
144: app_exception.raise_exception;
145: end if;
146: end if;
147: end loop;