41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
149: new_references.view_name,
150: new_references.ucas_cycle
151: )
152: ) THEN
153: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157: ELSIF (p_action = 'VALIDATE_INSERT') THEN
160: new_references.view_name,
161: new_references.ucas_cycle
162: )
163: ) THEN
164: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168: END IF;
206: IF (x_last_update_login IS NULL) THEN
207: x_last_update_login := -1;
208: END IF;
209: ELSE
210: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
211: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.INSERT_ROW');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: END IF;
207: x_last_update_login := -1;
208: END IF;
209: ELSE
210: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
211: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.INSERT_ROW');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: END IF;
215:
277:
278: OPEN c1;
279: FETCH c1 INTO tlinfo;
280: IF (c1%notfound) THEN
281: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
282: igs_ge_msg_stack.add;
283: CLOSE c1;
284: app_exception.raise_exception;
285: RETURN;
290: ((tlinfo.timestamp = x_timestamp) OR ((tlinfo.timestamp IS NULL) AND (X_timestamp IS NULL)))
291: ) THEN
292: NULL;
293: ELSE
294: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: END IF;
298:
336: IF (x_last_update_login IS NULL) THEN
337: x_last_update_login := -1;
338: END IF;
339: ELSE
340: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
341: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.UPDATE_ROW');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
337: x_last_update_login := -1;
338: END IF;
339: ELSE
340: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
341: fnd_message.set_token ('ROUTINE', 'IGS_UC_HRC_TIMSTMPS_PKG.UPDATE_ROW');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345: