APPS.IGS_EN_TIMESLOT_STUP_PKG dependencies on APP_EXCEPTION

Line 53: app_exception.raise_exception;

49: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
56: CLOSE cur_old_ref_values;
57:

Line 111: app_exception.raise_exception;

107: column_name IS NULL THEN
108: IF NOT (new_references.assign_randomly IN ('Y','N')) THEN
109: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113: END IF;
114:
115:

Line 139: app_exception.raise_exception;

135: ,new_references.student_type
136: ) THEN
137: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141: END check_uniqueness ;
142: PROCEDURE check_parent_existance AS
143: /*************************************************************

Line 167: app_exception.raise_exception;

163: new_references.sequence_number
164: ) THEN
165: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169:
170: IF (((old_references.program_type_group_cd = new_references.program_type_group_cd)) OR
171: ((new_references.program_type_group_cd IS NULL))) THEN

Line 178: app_exception.raise_exception;

174: new_references.program_type_group_cd
175: ) THEN
176: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: END IF;
180:
181: END check_parent_existance;
182:

Line 312: app_exception.raise_exception;

308: IF (cur_rowid%FOUND) THEN
309: CLOSE cur_rowid;
310: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: RETURN;
314: END IF;
315: CLOSE cur_rowid;
316:

Line 349: app_exception.raise_exception;

345: IF (cur_rowid%FOUND) THEN
346: CLOSE cur_rowid;
347: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: RETURN;
351: END IF;
352: CLOSE cur_rowid;
353:

Line 412: app_exception.raise_exception;

408: IF get_pk_for_validation(
409: new_references.igs_en_timeslot_stup_id) THEN
410: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414: check_uniqueness;
415: check_constraints;
416: check_parent_existance;

Line 433: app_exception.raise_exception;

429: IF get_pk_for_validation (
430: new_references.igs_en_timeslot_stup_id) THEN
431: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435: check_uniqueness;
436: check_constraints;
437: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 527: app_exception.raise_exception;

523: END IF;
524: ELSE
525: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: end if;
529:
530: select igs_en_timeslot_stup_s.nextval into x_igs_en_timeslot_stup_id from dual;
531:

Line 625: app_exception.raise_exception;

621: IF (c1%notfound) THEN
622: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
623: igs_ge_msg_stack.add;
624: CLOSE c1;
625: app_exception.raise_exception;
626: RETURN;
627: END IF;
628: CLOSE c1;
629: if ( ( tlinfo.SEQUENCE_NUMBER = X_SEQUENCE_NUMBER)

Line 642: app_exception.raise_exception;

638: NULL;
639: ELSE
640: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644: RETURN;
645: END lock_row;
646: PROCEDURE update_row (

Line 688: app_exception.raise_exception;

684: END IF;
685: ELSE
686: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
687: igs_ge_msg_stack.add;
688: app_exception.raise_exception;
689: END IF;
690: before_dml(
691: p_action=>'UPDATE',
692: x_rowid=>X_ROWID,