119: open c;
120: fetch c into recinfo;
121: if (c%notfound) then
122: close c;
123: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
124: app_exception.raise_exception;
125: end if;
126: close c;
127: if ( ((recinfo.ACTIVE_START_DATE = X_ACTIVE_START_DATE)
132: AND (recinfo.REPAIR_TYPE_ID = X_REPAIR_TYPE_ID)
133: ) then
134: null;
135: else
136: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
137: app_exception.raise_exception;
138: end if;
139:
140: for tlinfo in c1 loop
146: OR ((tlinfo.TERMS_AND_CONDITIONS is null) AND (X_TERMS_AND_CONDITIONS is null)))
147: ) then
148: null;
149: else
150: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
151: app_exception.raise_exception;
152: end if;
153: end if;
154: end loop;