APPS.IGF_AW_AWARD_LEVEL_HIST_PKG dependencies on APP_EXCEPTION

Line 86: app_exception.raise_exception;

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

Line 144: app_exception.raise_exception;

140: new_references.old_adplans_id
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: IF (((old_references.new_adplans_id = new_references.new_adplans_id)) OR
148: ((new_references.new_adplans_id IS NULL))) THEN

Line 155: app_exception.raise_exception;

151: new_references.new_adplans_id
152: ) THEN
153: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157:
158: IF (((old_references.award_id = new_references.award_id)) OR
159: ((new_references.award_id IS NULL))) THEN

Line 166: app_exception.raise_exception;

162: new_references.award_id
163: ) THEN
164: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168:
169: END check_parent_existance;
170:

Line 239: app_exception.raise_exception;

235: IF (cur_rowid%FOUND) THEN
236: CLOSE cur_rowid;
237: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;
243:

Line 274: app_exception.raise_exception;

270: IF (cur_rowid%FOUND) THEN
271: CLOSE cur_rowid;
272: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: RETURN;
276: END IF;
277: CLOSE cur_rowid;
278:

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: check_parent_existance;
358: ELSIF (p_action = 'UPDATE') THEN
359: -- Call all the procedures related to Before Update.

Line 371: app_exception.raise_exception;

367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
374:
375: END before_dml;

Line 447: app_exception.raise_exception;

443: ELSE
444: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
445: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWARD_LEVEL_HIST_PKG.INSERT_ROW');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: END IF;
449:
450: --new_references.org_id := igs_ge_gen_003.get_org_id;
451:

Line 592: app_exception.raise_exception;

588: IF (c1%notfound) THEN
589: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
590: igs_ge_msg_stack.add;
591: CLOSE c1;
592: app_exception.raise_exception;
593: RETURN;
594: END IF;
595: CLOSE c1;
596:

Line 616: app_exception.raise_exception;

612: NULL;
613: ELSE
614: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
615: igs_ge_msg_stack.add;
616: app_exception.raise_exception;
617: END IF;
618:
619: RETURN;
620:

Line 680: app_exception.raise_exception;

676: ELSE
677: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
678: fnd_message.set_token ('ROUTINE', 'IGF_AW_AWARD_LEVEL_HIST_PKG.UPDATE_ROW');
679: igs_ge_msg_stack.add;
680: app_exception.raise_exception;
681: END IF;
682:
683: before_dml(
684: p_action => 'UPDATE',