APPS.IGS_CO_S_LTR_PR_RSTN_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 90: app_exception.raise_exception;

86: new_references.correspondence_type
87: ) THEN
88: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
89: igs_ge_msg_stack.add;
90: app_exception.raise_exception;
91: END IF;
92:
93: IF (((old_references.s_letter_parameter_type = new_references.s_letter_parameter_type)) OR
94: ((new_references.s_letter_parameter_type IS NULL))) THEN

Line 101: app_exception.raise_exception;

97: new_references.s_letter_parameter_type
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: END check_parent_existance;
105:

Line 171: app_exception.raise_exception;

167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_CO_CORT_SLPR_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;
174: CLOSE cur_rowid;
175:

Line 206: app_exception.raise_exception;

202: IF (cur_rowid%FOUND) THEN
203: CLOSE cur_rowid;
204: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207: RETURN;
208: END IF;
209: CLOSE cur_rowid;
210:

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 273: app_exception.raise_exception;

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

Line 323: app_exception.raise_exception;

319: END IF;
320: ELSE
321: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:
326: before_dml(
327: p_action => 'INSERT',

Line 398: app_exception.raise_exception;

394: IF (c1%notfound) THEN
395: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
396: igs_ge_msg_stack.add;
397: CLOSE c1;
398: app_exception.raise_exception;
399: RETURN;
400: END IF;
401: CLOSE c1;
402: