APPS.IGS_CO_CAT_MAP_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) = 'DFLT_CAT_IND' OR column_name IS NULL) THEN
94: IF NOT (new_references.dflt_cat_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 124: app_exception.raise_exception;

120: new_references.correspondence_cat
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: IF (((old_references.admission_cat = new_references.admission_cat)) OR
128: ((new_references.admission_cat IS NULL))) THEN

Line 136: app_exception.raise_exception;

132: 'N'
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:

Line 206: app_exception.raise_exception;

202: IF (cur_rowid%FOUND) THEN
203: CLOSE cur_rowid;
204: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207: RETURN;
208: END IF;
209: CLOSE cur_rowid;
210:

Line 241: app_exception.raise_exception;

237: IF (cur_rowid%FOUND) THEN
238: CLOSE cur_rowid;
239: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: RETURN;
243: END IF;
244: CLOSE cur_rowid;
245:

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_constraints;
298: check_parent_existance;
299: ELSIF (p_action = 'UPDATE') THEN

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_constraints;
315: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
316: check_constraints;

Line 366: app_exception.raise_exception;

362: END IF;
363: ELSE
364: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368:
369: before_dml(
370: p_action => 'INSERT',

Line 445: app_exception.raise_exception;

441: IF (c1%notfound) THEN
442: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
443: igs_ge_msg_stack.add;
444: CLOSE c1;
445: app_exception.raise_exception;
446: RETURN;
447: END IF;
448: CLOSE c1;
449:

Line 457: app_exception.raise_exception;

453: NULL;
454: ELSE
455: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
456: igs_ge_msg_stack.add;
457: app_exception.raise_exception;
458: END IF;
459:
460: RETURN;
461:

Line 503: app_exception.raise_exception;

499: END IF;
500: ELSE
501: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
502: igs_ge_msg_stack.add;
503: app_exception.raise_exception;
504: END IF;
505:
506: before_dml(
507: p_action => 'UPDATE',