DBA Data[Home] [Help]

APPS.IGS_CO_LTR_PHR_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 99: app_exception.raise_exception;

95: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN
96: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
97: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101: END IF;
102:
103: END check_constraints;

Line 188: app_exception.raise_exception;

184: )
185: ) THEN
186: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190: check_constraints;
191: ELSIF (p_action = 'UPDATE') THEN
192: -- Call all the procedures related to Before Update.

Line 202: app_exception.raise_exception;

198: )
199: ) THEN
200: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204: check_constraints;
205: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
206: check_constraints;

Line 256: app_exception.raise_exception;

252: END IF;
253: ELSE
254: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258:
259: before_dml(
260: p_action => 'INSERT',

Line 341: app_exception.raise_exception;

337: IF (c1%notfound) THEN
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: igs_ge_msg_stack.add;
340: CLOSE c1;
341: app_exception.raise_exception;
342: RETURN;
343: END IF;
344: CLOSE c1;
345:

Line 355: app_exception.raise_exception;

351: NULL;
352: ELSE
353: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357:
358: RETURN;
359:

Line 402: app_exception.raise_exception;

398: END IF;
399: ELSE
400: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: END IF;
404:
405: before_dml(
406: p_action => 'UPDATE',