DBA Data[Home] [Help]

APPS.IGS_DA_SETUP_PKG dependencies on APP_EXCEPTION

Line 59: app_exception.raise_exception;

55: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
56: CLOSE cur_old_ref_values;
57: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
58: igs_ge_msg_stack.add;
59: app_exception.raise_exception;
60: RETURN;
61: END IF;
62: CLOSE cur_old_ref_values;
63:

Line 116: app_exception.raise_exception;

112: new_references.default_student_id_type
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: IF (((old_references.wif_major_unit_set_cat = new_references.wif_major_unit_set_cat)) OR
120: ((new_references.wif_major_unit_set_cat IS NULL))) THEN

Line 127: app_exception.raise_exception;

123: new_references.wif_major_unit_set_cat
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: IF (((old_references.wif_minor_unit_set_cat = new_references.wif_minor_unit_set_cat)) OR
131: ((new_references.wif_minor_unit_set_cat IS NULL))) THEN

Line 138: app_exception.raise_exception;

134: new_references.wif_minor_unit_set_cat
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: IF (((old_references.wif_track_unit_set_cat = new_references.wif_track_unit_set_cat)) OR
142: ((new_references.wif_track_unit_set_cat IS NULL))) THEN

Line 149: app_exception.raise_exception;

145: new_references.wif_track_unit_set_cat
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: IF (((old_references.default_inst_id_type = new_references.default_inst_id_type)) OR
153: ((new_references.default_inst_id_type IS NULL))) THEN

Line 160: app_exception.raise_exception;

156: new_references.default_inst_id_type
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: END check_parent_existance;
164:

Line 229: app_exception.raise_exception;

225: IF (cur_rowid%FOUND) THEN
226: CLOSE cur_rowid;
227: fnd_message.set_name ('IGS', 'IGS_DA_SET_EUS_FK');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: RETURN;
231: END IF;
232: CLOSE cur_rowid;
233:

Line 264: app_exception.raise_exception;

260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGS', 'IGS_DA_SET_OAIT_FK');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
267: CLOSE cur_rowid;
268:

Line 341: app_exception.raise_exception;

337: )
338: ) THEN
339: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342: END IF;
343: check_parent_existance;
344: ELSIF (p_action = 'UPDATE') THEN
345: -- Call all the procedures related to Before Update.

Line 355: app_exception.raise_exception;

351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: END IF;
358:
359: END before_dml;

Line 414: app_exception.raise_exception;

410: ELSE
411: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
412: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.INSERT_ROW');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416:
417: before_dml(
418: p_action => 'INSERT',

Line 546: app_exception.raise_exception;

542: IF (c1%notfound) THEN
543: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
544: igs_ge_msg_stack.add;
545: CLOSE c1;
546: app_exception.raise_exception;
547: RETURN;
548: END IF;
549: CLOSE c1;
550:

Line 571: app_exception.raise_exception;

567: NULL;
568: ELSE
569: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
574: RETURN;
575:

Line 630: app_exception.raise_exception;

626: ELSE
627: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
628: fnd_message.set_token ('ROUTINE', 'IGS_DA_SETUP_PKG.UPDATE_ROW');
629: igs_ge_msg_stack.add;
630: app_exception.raise_exception;
631: END IF;
632:
633: before_dml(
634: p_action => 'UPDATE',