APPS.IGS_HE_AD_DTL_ALL_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 116: app_exception.raise_exception;

112: new_references.sequence_number
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117:
118: END IF;
119:
120: END check_parent_existance;

Line 191: app_exception.raise_exception;

187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGS', 'IGS_HE_HAD_APAI_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;
194: CLOSE cur_rowid;
195:

Line 258: app_exception.raise_exception;

254: )
255: ) THEN
256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260: check_parent_existance;
261: ELSIF (p_action = 'UPDATE') THEN
262: -- Call all the procedures related to Before Update.

Line 272: app_exception.raise_exception;

268: )
269: ) THEN
270: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: END IF;
274: END IF;
275:
276: END before_dml;

Line 329: app_exception.raise_exception;

325: END IF;
326: ELSE
327: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331:
332: SELECT igs_he_ad_dtl_all_s.NEXTVAL
333: INTO x_hesa_ad_dtl_id

Line 413: app_exception.raise_exception;

409: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
410: fnd_message.set_token ('ERR_CD', SQLCODE);
411: igs_ge_msg_stack.add;
412: igs_sc_gen_001.unset_ctx('R');
413: app_exception.raise_exception;
414: ELSE
415: igs_sc_gen_001.unset_ctx('R');
416: RAISE;
417: END IF;

Line 470: app_exception.raise_exception;

466: IF (c1%notfound) THEN
467: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
468: igs_ge_msg_stack.add;
469: CLOSE c1;
470: app_exception.raise_exception;
471: RETURN;
472: END IF;
473: CLOSE c1;
474:

Line 489: app_exception.raise_exception;

485: NULL;
486: ELSE
487: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: RETURN;
493:

Line 542: app_exception.raise_exception;

538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(
546: p_action => 'UPDATE',

Line 587: app_exception.raise_exception;

583: IF (SQL%NOTFOUND) THEN
584: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
585: igs_ge_msg_stack.add;
586: igs_sc_gen_001.unset_ctx('R');
587: app_exception.raise_exception;
588: END IF;
589: IF (x_mode = 'S') THEN
590: igs_sc_gen_001.unset_ctx('R');
591: END IF;

Line 600: app_exception.raise_exception;

596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE
602: igs_sc_gen_001.unset_ctx('R');
603: RAISE;
604: END IF;

Line 710: app_exception.raise_exception;

706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
708: igs_ge_msg_stack.add;
709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;
712: IF (x_mode = 'S') THEN
713: igs_sc_gen_001.unset_ctx('R');
714: END IF;