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 PSP_ELEMENT_TYPES (
55: ELEMENT_TYPE_ID,
56: START_DATE_ACTIVE,
181: open c1;
182: fetch c1 into tlinfo;
183: if (c1%notfound) then
184: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
185: app_exception.raise_exception;
186: close c1;
187: return;
188: end if;
189: close c1;
248: ) then
249: null;
250: else
251: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
252: app_exception.raise_exception;
253: end if;
254: return;
255: end LOCK_ROW;
256:
298: X_LAST_UPDATE_LOGIN := -1;
299: end if;
300: else
301: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
302: app_exception.raise_exception;
303: end if;
304: update PSP_ELEMENT_TYPES set
305: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
306: COMMENTS = X_COMMENTS,