49: OPEN cur_old_ref_values;
50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
100: new_references.unit_cd,
101: new_references.version_number
102: )
103: ) THEN
104: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END IF;
108:
129: ELSIF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
130: new_references.unit_cd,
131: new_references.version_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
236: OPEN cur_rowid;
237: FETCH cur_rowid INTO lv_rowid;
238: IF (cur_rowid%FOUND) THEN
239: CLOSE cur_rowid;
240: fnd_message.set_name ('IGS', 'IGS_HE_HSUV_UV_FK');
241: igs_ge_msg_stack.add;
242: app_exception.raise_exception;
243: RETURN;
244: END IF;
262: new_references.version_number);
263: FETCH cur_unit_attempt INTO l_unit_attempt;
264: IF cur_unit_attempt%FOUND THEN
265: CLOSE cur_unit_attempt;
266: fnd_message.set_name ('IGS', 'IGS_HE_CANT_DEL_SUA_EXIST');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: RETURN;
270: END IF;
329: IF ( get_pk_for_validation(
330: new_references.hesa_st_unt_vs_id
331: )
332: ) THEN
333: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337: check_uniqueness;
347: IF ( get_pk_for_validation (
348: new_references.hesa_st_unt_vs_id
349: )
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: check_uniqueness;
412: IF (x_last_update_login IS NULL) THEN
413: x_last_update_login := -1;
414: END IF;
415: ELSE
416: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
532:
533: OPEN c1;
534: FETCH c1 INTO tlinfo;
535: IF (c1%notfound) THEN
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: igs_ge_msg_stack.add;
538: CLOSE c1;
539: app_exception.raise_exception;
540: RETURN;
552: AND ((tlinfo.exclude_flag = x_exclude_flag) OR ((tlinfo.exclude_flag IS NULL) AND (X_exclude_flag IS NULL)))
553: ) THEN
554: NULL;
555: ELSE
556: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
557: igs_ge_msg_stack.add;
558: app_exception.raise_exception;
559: END IF;
560:
608: IF (x_last_update_login IS NULL) THEN
609: x_last_update_login := -1;
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: igs_ge_msg_stack.add;
614: app_exception.raise_exception;
615: END IF;
616: