DBA Data[Home] [Help]

APPS.IGF_AW_AWD_FRML_DET_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

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

Line 120: app_exception.raise_exception;

116: new_references.fund_id
117: ) THEN
118: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
119: igs_ge_msg_stack.add;
120: app_exception.raise_exception;
121: END IF;
122:
123: IF ((old_references.adplans_id = new_references.adplans_id)) OR
124: ((new_references.adplans_id IS NULL)) THEN

Line 129: app_exception.raise_exception;

125: NULL;
126: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation(new_references.adplans_id) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
132: END check_parent_existance;
133:

Line 203: app_exception.raise_exception;

199: IF (cur_rowid%FOUND) THEN
200: CLOSE cur_rowid;
201: fnd_message.set_name ('IGF', 'IGF_AW_FMDET_FMAST_FK');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: RETURN;
205: END IF;
206: CLOSE cur_rowid;
207:

Line 241: app_exception.raise_exception;

237: IF (cur_rowid%FOUND) THEN
238: CLOSE cur_rowid;
239: fnd_message.set_name ('IGF', 'IGF_AW_FMDET_ADPLANS_FK');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: RETURN;
243: END IF;
244: CLOSE cur_rowid;
245:

Line 279: app_exception.raise_exception;

275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
282: CLOSE cur_rowid;
283:

Line 353: app_exception.raise_exception;

349: )
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: check_parent_existance;
356: ELSIF (p_action = 'UPDATE') THEN
357: -- Call all the procedures related to Before Update.

Line 370: app_exception.raise_exception;

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

Line 434: app_exception.raise_exception;

430: END IF;
431: ELSE
432: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END IF;
436:
437: before_dml(
438: p_action => 'INSERT',

Line 554: app_exception.raise_exception;

550: IF (c1%notfound) THEN
551: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
552: igs_ge_msg_stack.add;
553: CLOSE c1;
554: app_exception.raise_exception;
555: RETURN;
556: END IF;
557: CLOSE c1;
558:

Line 570: app_exception.raise_exception;

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

Line 626: app_exception.raise_exception;

622: END IF;
623: ELSE
624: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END IF;
628:
629: before_dml(
630: p_action => 'UPDATE',