48: X_LAST_UPDATE_LOGIN := -1;
49: end if;
50: else
51: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
52: app_exception.raise_exception;
53: end if;
54: insert into GMS_REPORTS (
55: REPORT_ID,
56: INSTALLMENT_ID,
182: open c1;
183: fetch c1 into tlinfo;
184: if (c1%notfound) then
185: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
186: app_exception.raise_exception;
187: close c1;
188: return;
189: end if;
190: close c1;
253: ) then
254: null;
255: else
256: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
257: app_exception.raise_exception;
258: end if;
259: return;
260: end LOCK_ROW;
261:
304: X_LAST_UPDATE_LOGIN := -1;
305: end if;
306: else
307: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
308: app_exception.raise_exception;
309: end if;
310: update GMS_REPORTS set
311: INSTALLMENT_ID = X_INSTALLMENT_ID,
312: REPORT_TEMPLATE_ID = X_REPORT_TEMPLATE_ID,