APPS.IGS_PS_USEC_CATEGORY_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 91: app_exception.raise_exception;

87: )
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_uniqueness;
95:

Line 117: app_exception.raise_exception;

113: new_references.uoo_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.unit_cat = new_references.unit_cat)) OR
121: ((new_references.unit_cat IS NULL))) THEN

Line 128: app_exception.raise_exception;

124: new_references.unit_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: END check_parent_existance;
132:

Line 233: app_exception.raise_exception;

229: IF (cur_rowid%FOUND) THEN
230: CLOSE cur_rowid;
231: fnd_message.set_name ('IGS', 'IGS_PS_USCT_UOO_UFK');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: RETURN;
235: END IF;
236: CLOSE cur_rowid;
237:

Line 268: app_exception.raise_exception;

264: IF (cur_rowid%FOUND) THEN
265: CLOSE cur_rowid;
266: fnd_message.set_name ('IGS', 'IGS_PS_USCT_UCA_FK');
267: igs_ge_msg_stack.add;
268: app_exception.raise_exception;
269: RETURN;
270: END IF;
271: CLOSE cur_rowid;
272:

Line 321: app_exception.raise_exception;

317: )
318: ) THEN
319: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323: check_uniqueness;
324: check_parent_existance;
325: ELSIF (p_action = 'UPDATE') THEN

Line 337: app_exception.raise_exception;

333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_uniqueness;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: check_uniqueness;

Line 392: app_exception.raise_exception;

388: END IF;
389: ELSE
390: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394:
395: SELECT igs_ps_usec_category_s.NEXTVAL
396: INTO x_usec_cat_id

Line 476: app_exception.raise_exception;

472: IF (c1%notfound) THEN
473: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
474: igs_ge_msg_stack.add;
475: CLOSE c1;
476: app_exception.raise_exception;
477: RETURN;
478: END IF;
479: CLOSE c1;
480:

Line 489: app_exception.raise_exception;

485: NULL;
486: ELSE
487: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: RETURN;
493:

Line 535: app_exception.raise_exception;

531: END IF;
532: ELSE
533: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
534: igs_ge_msg_stack.add;
535: app_exception.raise_exception;
536: END IF;
537:
538: before_dml(
539: p_action => 'UPDATE',