DBA Data[Home] [Help]

APPS.IGS_CO_CAT_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 97: app_exception.raise_exception;

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

Line 207: app_exception.raise_exception;

203: )
204: ) THEN
205: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209: check_constraints;
210: ELSIF (p_action = 'UPDATE') THEN
211: -- Call all the procedures related to Before Update.

Line 224: app_exception.raise_exception;

220: )
221: ) THEN
222: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: END IF;
226: check_constraints;
227: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
228: check_constraints;

Line 279: app_exception.raise_exception;

275: END IF;
276: ELSE
277: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281:
282: before_dml(
283: p_action => 'INSERT',

Line 359: app_exception.raise_exception;

355: IF (c1%notfound) THEN
356: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
357: igs_ge_msg_stack.add;
358: CLOSE c1;
359: app_exception.raise_exception;
360: RETURN;
361: END IF;
362: CLOSE c1;
363:

Line 372: app_exception.raise_exception;

368: NULL;
369: ELSE
370: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374:
375: RETURN;
376:

Line 418: app_exception.raise_exception;

414: END IF;
415: ELSE
416: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
421: before_dml(
422: p_action => 'UPDATE',