DBA Data[Home] [Help]

APPS.IGS_PS_USO_CM_GRP_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.ci_sequence_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_CI_CMG_FK1');
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 391: app_exception.raise_exception;

387: END IF;
388: ELSE
389: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393:
394: SELECT igs_ps_uso_cm_grp_s.NEXTVAL
395: INTO x_class_meet_group_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 509: app_exception.raise_exception;

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

Line 558: app_exception.raise_exception;

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