APPS.IGS_PS_USO_INSTRCTRS_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 125: app_exception.raise_exception;

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

Line 140: app_exception.raise_exception;

136: ELSE
137: CLOSE cur_rowid;
138: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
139: igs_ge_msg_stack.add;
140: app_exception.raise_exception;
141: END IF;
142: END IF;
143:
144: END check_parent_existance;

Line 246: app_exception.raise_exception;

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

Line 281: app_exception.raise_exception;

277: IF (cur_rowid%FOUND) THEN
278: CLOSE cur_rowid;
279: fnd_message.set_name ('IGS', 'IGS_PS_HZP_INS_FK2');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: RETURN;
283: END IF;
284: CLOSE cur_rowid;
285:

Line 334: app_exception.raise_exception;

330: )
331: ) THEN
332: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: END IF;
336: check_uniqueness;
337: check_parent_existance;
338: ELSIF (p_action = 'UPDATE') THEN

Line 350: app_exception.raise_exception;

346: )
347: ) THEN
348: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: check_uniqueness;
353: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
354: check_uniqueness;

Line 405: app_exception.raise_exception;

401: END IF;
402: ELSE
403: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igs_ps_uso_instrctrs_s.NEXTVAL
409: INTO x_uso_instructor_id

Line 489: app_exception.raise_exception;

485: IF (c1%notfound) THEN
486: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
487: igs_ge_msg_stack.add;
488: CLOSE c1;
489: app_exception.raise_exception;
490: RETURN;
491: END IF;
492: CLOSE c1;
493:

Line 502: app_exception.raise_exception;

498: NULL;
499: ELSE
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504:
505: RETURN;
506:

Line 548: app_exception.raise_exception;

544: END IF;
545: ELSE
546: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
547: igs_ge_msg_stack.add;
548: app_exception.raise_exception;
549: END IF;
550:
551: before_dml(
552: p_action => 'UPDATE',