APPS.IGF_AP_ST_INST_APPL_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

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

Line 105: app_exception.raise_exception;

101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
108: END check_uniqueness;
109:

Line 131: app_exception.raise_exception;

127: new_references.question_id
128: ) THEN
129: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: END IF;
133:
134: IF (((old_references.base_id = new_references.base_id)) OR
135: ((new_references.base_id IS NULL))) THEN

Line 142: app_exception.raise_exception;

138: new_references.base_id
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
145: END check_parent_existance;
146:

Line 249: app_exception.raise_exception;

245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGF', 'IGF_AP_SIA_IAS_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;
252: CLOSE cur_rowid;
253:

Line 284: app_exception.raise_exception;

280: IF (cur_rowid%FOUND) THEN
281: CLOSE cur_rowid;
282: fnd_message.set_name ('IGF', 'IGF_AP_SIA_FA_DETAIL_FK');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: RETURN;
286: END IF;
287: CLOSE cur_rowid;
288:

Line 320: app_exception.raise_exception;

316: IF (cur_rowid%FOUND) THEN
317: CLOSE cur_rowid;
318: fnd_message.set_name ('IGF', 'IGF_AP_SIA_FA_DETAIL_FK');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: RETURN;
322: END IF;
323: CLOSE cur_rowid;
324:

Line 377: app_exception.raise_exception;

373: )
374: ) THEN
375: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: check_uniqueness;
380: check_parent_existance;
381: ELSIF (p_action = 'UPDATE') THEN

Line 393: app_exception.raise_exception;

389: )
390: ) THEN
391: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: check_uniqueness;
396: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
397: check_uniqueness;

Line 450: app_exception.raise_exception;

446: END IF;
447: ELSE
448: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
449: igs_ge_msg_stack.add;
450: app_exception.raise_exception;
451: END IF;
452: SELECT igf_ap_st_inst_appl_s.nextval INTO x_inst_app_id FROM DUAL;
453: before_dml(
454: p_action => 'INSERT',

Line 544: app_exception.raise_exception;

540: IF (c1%notfound) THEN
541: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
542: igs_ge_msg_stack.add;
543: CLOSE c1;
544: app_exception.raise_exception;
545: RETURN;
546: END IF;
547: CLOSE c1;
548:

Line 559: app_exception.raise_exception;

555: NULL;
556: ELSE
557: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
558: igs_ge_msg_stack.add;
559: app_exception.raise_exception;
560: END IF;
561:
562: RETURN;
563:

Line 608: app_exception.raise_exception;

604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
611: before_dml(
612: p_action => 'UPDATE',