APPS.IGS_HE_POOUS_OU_ALL_PKG dependencies on APP_EXCEPTION

Line 56: app_exception.raise_exception;

52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: igs_ge_msg_stack.add;
56: app_exception.raise_exception;
57: RETURN;
58: END IF;
59: CLOSE cur_old_ref_values;
60:

Line 116: app_exception.raise_exception;

112: )
113: ) THEN
114: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: END check_uniqueness;
120:

Line 184: app_exception.raise_exception;

180: new_references.attendance_type
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
187: IF((( old_references.unit_set_cd = new_references.unit_set_cd) AND
188: (old_references.us_version_number = new_references.us_version_number))

Line 199: app_exception.raise_exception;

195: new_references.us_version_number
196: )THEN
197: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201:
202: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view
203: OPEN cur_unitset_check( new_references.course_cd,

Line 216: App_Exception.Raise_Exception;

212: IF cur_unitset_check%NOTFOUND THEN
213: CLOSE cur_unitset_check;
214: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: CLOSE cur_unitset_check;
219:
220: END check_parent_existance;

Line 364: app_exception.raise_exception;

360: IF (cur_rowid%FOUND) THEN
361: CLOSE cur_rowid;
362: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_COO_FK');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: RETURN;
366: END IF;
367: CLOSE cur_rowid;
368:

Line 400: app_exception.raise_exception;

396: IF (cur_rowid%FOUND) THEN
397: CLOSE cur_rowid;
398: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_US_FK');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: RETURN;
402: END IF;
403: CLOSE cur_rowid;
404:

Line 443: App_Exception.Raise_Exception;

439: IF (cur_rowid%FOUND) THEN
440: Close cur_rowid;
441: Fnd_Message.Set_Name ('IGS', 'IGS_HE_HPUD_US_FK');
442: IGS_GE_MSG_STACK.ADD;
443: App_Exception.Raise_Exception;
444: Return;
445: END IF;
446: Close cur_rowid;
447:

Line 516: app_exception.raise_exception;

512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_uniqueness;
519: check_parent_existance;
520: ELSIF (p_action = 'UPDATE') THEN

Line 535: app_exception.raise_exception;

531: )
532: ) THEN
533: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
534: igs_ge_msg_stack.add;
535: app_exception.raise_exception;
536: END IF;
537: check_uniqueness;
538: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
539: check_uniqueness;

Line 601: app_exception.raise_exception;

597: END IF;
598: ELSE
599: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
600: igs_ge_msg_stack.add;
601: app_exception.raise_exception;
602: END IF;
603:
604: SELECT igs_he_poous_ou_all_s.NEXTVAL
605: INTO x_hesa_poous_ou_id

Line 731: app_exception.raise_exception;

727: IF (c1%notfound) THEN
728: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
729: igs_ge_msg_stack.add;
730: CLOSE c1;
731: app_exception.raise_exception;
732: RETURN;
733: END IF;
734: CLOSE c1;
735:

Line 752: app_exception.raise_exception;

748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
755: RETURN;
756:

Line 809: app_exception.raise_exception;

805: END IF;
806: ELSE
807: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
808: igs_ge_msg_stack.add;
809: app_exception.raise_exception;
810: END IF;
811:
812: before_dml(
813: p_action => 'UPDATE',