APPS.IGS_UC_MAP_OFF_RESP_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 101: app_exception.raise_exception;

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

Line 113: app_exception.raise_exception;

109: 'N'
110: ) THEN
111: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115:
116: END check_parent_existance;
117:

Line 187: app_exception.raise_exception;

183: IF (cur_rowid%FOUND) THEN
184: CLOSE cur_rowid;
185: fnd_message.set_name ('IGS', 'IGS_UC_UCSD_UMOF_FK');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: RETURN;
189: END IF;
190: CLOSE cur_rowid;
191:

Line 222: app_exception.raise_exception;

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

Line 282: app_exception.raise_exception;

278: )
279: ) THEN
280: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: check_parent_existance;
285: ELSIF (p_action = 'UPDATE') THEN
286: -- Call all the procedures related to Before Update.

Line 298: app_exception.raise_exception;

294: )
295: ) THEN
296: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300: END IF;
301:
302: END before_dml;

Line 346: app_exception.raise_exception;

342: END IF;
343: ELSE
344: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: END IF;
348:
349: before_dml(
350: p_action => 'INSERT',

Line 426: app_exception.raise_exception;

422: IF (c1%notfound) THEN
423: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
424: igs_ge_msg_stack.add;
425: CLOSE c1;
426: app_exception.raise_exception;
427: RETURN;
428: END IF;
429: CLOSE c1;
430:

Line 439: app_exception.raise_exception;

435: NULL;
436: ELSE
437: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END IF;
441:
442: RETURN;
443:

Line 487: app_exception.raise_exception;

483: END IF;
484: ELSE
485: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
486: igs_ge_msg_stack.add;
487: app_exception.raise_exception;
488: END IF;
489:
490: before_dml(
491: p_action => 'UPDATE',