44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
158: IF ( get_pk_for_validation(
159: new_references.dbpays_id
160: )
161: ) THEN
162: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: END IF;
166: ELSIF (p_action = 'VALIDATE_INSERT') THEN
168: IF ( get_pk_for_validation (
169: new_references.dbpays_id
170: )
171: ) THEN
172: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176: END IF;
221: IF (x_last_update_login IS NULL) THEN
222: x_last_update_login := -1;
223: END IF;
224: ELSE
225: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
319:
320: OPEN c1;
321: FETCH c1 INTO tlinfo;
322: IF (c1%notfound) THEN
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: igs_ge_msg_stack.add;
325: CLOSE c1;
326: app_exception.raise_exception;
327: RETURN;
336: AND ((tlinfo.unit_ver_num = x_unit_ver_num) OR ((tlinfo.unit_ver_num IS NULL) AND (X_unit_ver_num IS NULL)))
337: ) THEN
338: NULL;
339: ELSE
340: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
385: IF (x_last_update_login IS NULL) THEN
386: x_last_update_login := -1;
387: END IF;
388: ELSE
389: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393: