DBA Data[Home] [Help]

APPS.IGF_AW_CORRESP_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 96: app_exception.raise_exception;

92: new_references.base_id
93: ) THEN
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: END check_parent_existance;
100:

Line 164: app_exception.raise_exception;

160: IF (cur_rowid%FOUND) THEN
161: CLOSE cur_rowid;
162: fnd_message.set_name ('IGF', 'IGF_AW_CRSP_FA_BASE_FK');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: RETURN;
166: END IF;
167: CLOSE cur_rowid;
168:

Line 221: app_exception.raise_exception;

217: )
218: ) THEN
219: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: END IF;
223: check_parent_existance;
224: ELSIF (p_action = 'UPDATE') THEN
225: -- Call all the procedures related to Before Update.

Line 235: app_exception.raise_exception;

231: )
232: ) THEN
233: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237: END IF;
238:
239: END before_dml;

Line 303: app_exception.raise_exception;

299: END IF;
300: ELSE
301: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
306: SELECT igf_aw_corresp_s.NEXTVAL
307: INTO x_crsp_id

Line 409: app_exception.raise_exception;

405: IF (c1%notfound) THEN
406: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
407: igs_ge_msg_stack.add;
408: CLOSE c1;
409: app_exception.raise_exception;
410: RETURN;
411: END IF;
412: CLOSE c1;
413:

Line 424: app_exception.raise_exception;

420: NULL;
421: ELSE
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: END IF;
426:
427: RETURN;
428:

Line 476: app_exception.raise_exception;

472: END IF;
473: ELSE
474: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
475: igs_ge_msg_stack.add;
476: app_exception.raise_exception;
477: END IF;
478:
479: before_dml(
480: p_action => 'UPDATE',