APPS.IGF_AW_DP_TEACH_PRDS_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 102: app_exception.raise_exception;

98: new_references.adterms_id
99: ) THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104: IF (((old_references.tp_cal_type = new_references.tp_cal_type) AND
105: (old_references.tp_sequence_number = new_references.tp_sequence_number)) OR
106: ((new_references.tp_cal_type IS NULL) OR

Line 115: app_exception.raise_exception;

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

Line 126: app_exception.raise_exception;

122: new_references.date_offset_cd
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:

Line 155: app_exception.raise_exception;

151: )
152: ) THEN
153: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157: END check_uniqueness;
158:
159: FUNCTION get_pk_for_validation (

Line 221: app_exception.raise_exception;

217: IF (cur_rowid%FOUND) THEN
218: CLOSE cur_rowid;
219: fnd_message.set_name ('IGF', 'IGF_AW_ADTEACH_ADTERMS_FK');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: RETURN;
223: END IF;
224: CLOSE cur_rowid;
225:

Line 257: app_exception.raise_exception;

253: IF (cur_rowid%FOUND) THEN
254: CLOSE cur_rowid;
255: fnd_message.set_name ('IGF', 'IGF_AW_ADTEACH_CI_FK');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
260: CLOSE cur_rowid;
261:

Line 291: app_exception.raise_exception;

287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGS', 'IGF_AW_ADTEACH_DA_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:

Line 398: app_exception.raise_exception;

394: )
395: ) THEN
396: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400: check_parent_existance;
401: check_uniqueness;
402: ELSIF (p_action = 'UPDATE') THEN

Line 414: app_exception.raise_exception;

410: )
411: ) THEN
412: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416: check_uniqueness;
417: END IF;
418:

Line 467: app_exception.raise_exception;

463: ELSE
464: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
465: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.INSERT_ROW');
466: igs_ge_msg_stack.add;
467: app_exception.raise_exception;
468: END IF;
469:
470: x_adteach_id := NULL;
471:

Line 566: app_exception.raise_exception;

562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
568: END IF;
569: CLOSE c1;
570:

Line 584: app_exception.raise_exception;

580: NULL;
581: ELSE
582: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583: igs_ge_msg_stack.add;
584: app_exception.raise_exception;
585: END IF;
586:
587: RETURN;
588:

Line 636: app_exception.raise_exception;

632: ELSE
633: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
634: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TEACH_PRDS_PKG.UPDATE_ROW');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:
639: before_dml(
640: p_action => 'UPDATE',