52: OPEN cur_old_ref_values;
53: FETCH cur_old_ref_values INTO old_references;
54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
109: new_references.uoo_id,
110: new_references.group_name
111: )
112: ) THEN
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117:
159: new_references.person_id,
160: new_references.course_cd,
161: new_references.uoo_id
162: ) THEN
163: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167:
170: NULL;
171: ELSIF NOT igs_as_unit_ai_grp_pkg.get_pk_for_validation (
172: new_references.unit_ass_item_group_id
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:
181: NULL;
182: ELSIF NOT igs_as_us_ai_group_pkg.get_pk_for_validation (
183: new_references.us_ass_item_group_id
184: ) THEN
185: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189:
294: OPEN cur_rowid;
295: FETCH cur_rowid INTO lv_rowid;
296: IF (cur_rowid%FOUND) THEN
297: CLOSE cur_rowid;
298: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
299: igs_ge_msg_stack.add;
300: app_exception.raise_exception;
301: RETURN;
302: END IF;
329: OPEN cur_rowid;
330: FETCH cur_rowid INTO lv_rowid;
331: IF (cur_rowid%FOUND) THEN
332: CLOSE cur_rowid;
333: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: RETURN;
337: END IF;
364: OPEN cur_rowid;
365: FETCH cur_rowid INTO lv_rowid;
366: IF (cur_rowid%FOUND) THEN
367: CLOSE cur_rowid;
368: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: RETURN;
372: END IF;
439: IF ( get_pk_for_validation(
440: new_references.sua_ass_item_group_id
441: )
442: ) THEN
443: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447: check_uniqueness;
455: IF ( get_pk_for_validation (
456: new_references.sua_ass_item_group_id
457: )
458: ) THEN
459: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
460: igs_ge_msg_stack.add;
461: app_exception.raise_exception;
462: END IF;
463: check_uniqueness;
517: IF (x_last_update_login IS NULL) THEN
518: x_last_update_login := -1;
519: END IF;
520: ELSE
521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
518: x_last_update_login := -1;
519: END IF;
520: ELSE
521: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
522: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.INSERT_ROW');
523: igs_ge_msg_stack.add;
524: app_exception.raise_exception;
525: END IF;
526:
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
605: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
606: IF (x_mode = 'S') THEN
607: igs_sc_gen_001.unset_ctx('R');
608: END IF;
609:
606: IF (x_mode = 'S') THEN
607: igs_sc_gen_001.unset_ctx('R');
608: END IF;
609:
610: fnd_message.set_token ('ERR_CD', SQLCODE);
611: igs_ge_msg_stack.add;
612: igs_sc_gen_001.unset_ctx('R');
613: app_exception.raise_exception;
614: ELSE
669:
670: OPEN c1;
671: FETCH c1 INTO tlinfo;
672: IF (c1%notfound) THEN
673: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
674: igs_ge_msg_stack.add;
675: CLOSE c1;
676: app_exception.raise_exception;
677: RETURN;
694: AND ((tlinfo.logical_delete_date = x_logical_delete_date) OR ((tlinfo.logical_delete_date IS NULL) AND (x_logical_delete_date IS NULL)))
695: ) THEN
696: NULL;
697: ELSE
698: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
699: igs_ge_msg_stack.add;
700: app_exception.raise_exception;
701: END IF;
702:
751: IF (x_last_update_login IS NULL) THEN
752: x_last_update_login := -1;
753: END IF;
754: ELSE
755: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
752: x_last_update_login := -1;
753: END IF;
754: ELSE
755: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
756: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_AI_GROUP_PKG.UPDATE_ROW');
757: igs_ge_msg_stack.add;
758: app_exception.raise_exception;
759: END IF;
760:
805: last_update_login = x_last_update_login
806: WHERE rowid = x_rowid;
807:
808: IF (SQL%NOTFOUND) THEN
809: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: END IF;
819:
820: EXCEPTION
821: WHEN OTHERS THEN
822: IF (SQLCODE = (-28115)) THEN
823: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
820: EXCEPTION
821: WHEN OTHERS THEN
822: IF (SQLCODE = (-28115)) THEN
823: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
941: DELETE FROM igs_as_sua_ai_group
942: WHERE rowid = x_rowid;
943:
944: IF (SQL%NOTFOUND) THEN
945: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
946: igs_ge_msg_stack.add;
947: igs_sc_gen_001.unset_ctx('R');
948: app_exception.raise_exception;
949: END IF;