APPS.IGS_PS_UNIT_SUBTITLE_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 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;
102:

Line 127: app_exception.raise_exception;

123: new_references.version_number
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: END check_parent_existance;
131:

Line 255: app_exception.raise_exception;

251: IF (cur_rowid%FOUND) THEN
252: CLOSE cur_rowid;
253: fnd_message.set_name ('IGS', 'IGS_PS_UVSB_UV_FK');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: RETURN;
257: END IF;
258: CLOSE cur_rowid;
259:

Line 314: app_exception.raise_exception;

310: )
311: ) THEN
312: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316: check_uniqueness;
317: check_parent_existance;
318: ELSIF (p_action = 'UPDATE') THEN

Line 333: app_exception.raise_exception;

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

Line 393: app_exception.raise_exception;

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

Line 492: app_exception.raise_exception;

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

Line 508: app_exception.raise_exception;

504: NULL;
505: ELSE
506: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
507: igs_ge_msg_stack.add;
508: app_exception.raise_exception;
509: END IF;
510:
511: RETURN;
512:

Line 557: app_exception.raise_exception;

553: END IF;
554: ELSE
555: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
560: before_dml(
561: p_action => 'UPDATE',