APPS.IGS_AZ_GROUPS_PKG dependencies on APP_EXCEPTION

Line 88: app_exception.raise_exception;

84: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
85: CLOSE cur_old_ref_values;
86: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
87: igs_ge_msg_stack.add;
88: app_exception.raise_exception;
89: RETURN;
90: END IF;
91: CLOSE cur_old_ref_values;
92:

Line 175: app_exception.raise_exception;

171: 'N'
172: ) THEN
173: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: END IF;
177:
178: IF (((old_references.advisor_group_id = new_references.advisor_group_id)) OR
179: ((new_references.advisor_group_id IS NULL))) THEN

Line 186: app_exception.raise_exception;

182: new_references.advisor_group_id
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
189: IF (((old_references.student_group_id = new_references.student_group_id)) OR
190: ((new_references.student_group_id IS NULL))) THEN

Line 197: app_exception.raise_exception;

193: new_references.student_group_id
194: ) THEN
195: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
196: igs_ge_msg_stack.add;
197: app_exception.raise_exception;
198: END IF;
199:
200: IF (((old_references.advising_hold_type = new_references.advising_hold_type)) OR
201: ((new_references.advising_hold_type IS NULL))) THEN

Line 208: app_exception.raise_exception;

204: new_references.advising_hold_type
205: ) THEN
206: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: END IF;
210:
211: END check_parent_existance;
212:

Line 302: app_exception.raise_exception;

298: IF (cur_rowid%FOUND) THEN
299: CLOSE cur_rowid;
300: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_LOC_FK');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: RETURN;
304: END IF;
305: CLOSE cur_rowid;
306:

Line 338: app_exception.raise_exception;

334: IF (cur_rowid%FOUND) THEN
335: CLOSE cur_rowid;
336: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_PERS_FK');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: RETURN;
340: END IF;
341: CLOSE cur_rowid;
342:

Line 373: app_exception.raise_exception;

369: IF (cur_rowid%FOUND) THEN
370: CLOSE cur_rowid;
371: fnd_message.set_name ('IGS', 'IGS_AZ_GROUPS_ENCMB_FK');
372: igs_ge_msg_stack.add;
373: app_exception.raise_exception;
374: RETURN;
375: END IF;
376: CLOSE cur_rowid;
377:

Line 508: app_exception.raise_exception;

504: )
505: ) THEN
506: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
507: igs_ge_msg_stack.add;
508: app_exception.raise_exception;
509: END IF;
510: check_parent_existance;
511: ELSIF (p_action = 'UPDATE') THEN
512: -- Call all the procedures related to Before Update.

Line 525: app_exception.raise_exception;

521: )
522: ) THEN
523: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
524: igs_ge_msg_stack.add;
525: app_exception.raise_exception;
526: END IF;
527: ELSIF (p_action = 'VALIDATE_DELETE') THEN
528: check_child_existance;
529: END IF;

Line 618: app_exception.raise_exception;

614: ELSE
615: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
616: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.INSERT_ROW');
617: igs_ge_msg_stack.add;
618: app_exception.raise_exception;
619: END IF;
620:
621: before_dml(
622: p_action => 'INSERT',

Line 932: app_exception.raise_exception;

928: IF (c1%notfound) THEN
929: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
930: igs_ge_msg_stack.add;
931: CLOSE c1;
932: app_exception.raise_exception;
933: RETURN;
934: END IF;
935: CLOSE c1;
936:

Line 1112: app_exception.raise_exception;

1108: ELSE
1109: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1110: fnd_message.set_token ('ROUTINE', 'IGS_AZ_GROUPS_PKG.UPDATE_ROW');
1111: igs_ge_msg_stack.add;
1112: app_exception.raise_exception;
1113: END IF;
1114:
1115: before_dml(
1116: p_action => 'UPDATE',