APPS.IGS_CO_CAT_ITM_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 101: app_exception.raise_exception;

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

Line 128: app_exception.raise_exception;

124: new_references.correspondence_cat
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: IF (((old_references.correspondence_type = new_references.correspondence_type)) OR
132: ((new_references.correspondence_type IS NULL))) THEN

Line 139: app_exception.raise_exception;

135: new_references.correspondence_type
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: END check_parent_existance;
143:

Line 211: app_exception.raise_exception;

207: IF (cur_rowid%FOUND) THEN
208: CLOSE cur_rowid;
209: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: RETURN;
213: END IF;
214: CLOSE cur_rowid;
215:

Line 246: app_exception.raise_exception;

242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_CO_CORT_CCI_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;
250:

Line 305: app_exception.raise_exception;

301: )
302: ) THEN
303: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: igs_ge_msg_stack.add;
305: app_exception.raise_exception;
306: END IF;
307: check_constraints;
308: check_parent_existance;
309: ELSIF (p_action = 'UPDATE') THEN

Line 323: app_exception.raise_exception;

319: )
320: ) THEN
321: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: check_constraints;
326: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
327: check_constraints;

Line 380: app_exception.raise_exception;

376: END IF;
377: ELSE
378: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382:
383: before_dml(
384: p_action => 'INSERT',

Line 468: app_exception.raise_exception;

464: IF (c1%notfound) THEN
465: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
466: igs_ge_msg_stack.add;
467: CLOSE c1;
468: app_exception.raise_exception;
469: RETURN;
470: END IF;
471: CLOSE c1;
472:

Line 481: app_exception.raise_exception;

477: NULL;
478: ELSE
479: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483:
484: RETURN;
485:

Line 529: app_exception.raise_exception;

525: END IF;
526: ELSE
527: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: END IF;
531:
532: before_dml(
533: p_action => 'UPDATE',