APPS.IGS_CO_TYPE_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 105: app_exception.raise_exception;

101: IF (UPPER(column_name) = 'SYS_GENERATED_IND' OR column_name IS NULL) THEN
102: IF NOT (new_references.sys_generated_ind IN ('Y', 'N')) THEN
103: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107: END IF;
108:
109: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN

Line 113: app_exception.raise_exception;

109: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN
110: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
111: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115: END IF;
116:
117: END check_constraints;

Line 237: app_exception.raise_exception;

233: )
234: ) THEN
235: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: check_constraints;
240: ELSIF (p_action = 'UPDATE') THEN
241: -- Call all the procedures related to Before Update.

Line 254: app_exception.raise_exception;

250: )
251: ) THEN
252: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: END IF;
256: check_constraints;
257: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
258: check_constraints;

Line 313: app_exception.raise_exception;

309:
310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:
316: before_dml(
317: p_action => 'INSERT',

Line 408: app_exception.raise_exception;

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

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

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