APPS.IGS_HE_POOUS_ALL_PKG dependencies on APP_EXCEPTION

Line 88: app_exception.raise_exception;

84: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
85: CLOSE cur_old_ref_values;
86: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
87: igs_ge_msg_stack.add;
88: app_exception.raise_exception;
89: RETURN;
90: END IF;
91: CLOSE cur_old_ref_values;
92:

Line 172: app_exception.raise_exception;

168: )
169: ) THEN
170: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
175: END check_uniqueness;
176:

Line 239: app_exception.raise_exception;

235: new_references.attendance_type
236: ) THEN
237: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241:
242: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND
243: (old_references.us_version_number = new_references.us_version_number)) OR

Line 253: app_exception.raise_exception;

249: new_references.us_version_number
250: ) THEN
251: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: END IF;
255:
256: -- smaddali added parent check for funding_source field
257: IF (old_references.funding_source = new_references.funding_source) OR

Line 265: app_exception.raise_exception;

261: new_references.funding_source
262: ) THEN
263: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
264: igs_ge_msg_stack.add;
265: app_exception.raise_exception;
266: END IF;
267:
268: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view
269: OPEN cur_unitset_check( new_references.course_cd,

Line 282: App_Exception.Raise_Exception;

278: IF cur_unitset_check%NOTFOUND THEN
279: CLOSE cur_unitset_check;
280: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: CLOSE cur_unitset_check;
285:
286: END check_parent_existance;

Line 410: app_exception.raise_exception;

406: IF (cur_rowid%FOUND) THEN
407: CLOSE cur_rowid;
408: fnd_message.set_name ('IGS', 'IGS_HE_HPUD_UOO_FK');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: RETURN;
412: END IF;
413: CLOSE cur_rowid;
414:

Line 447: app_exception.raise_exception;

443: IF (cur_rowid%FOUND) THEN
444: CLOSE cur_rowid;
445: fnd_message.set_name ('IGS', 'IGS_HE_HPUD_US_FK');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: RETURN;
449: END IF;
450: CLOSE cur_rowid;
451:

Line 490: App_Exception.Raise_Exception;

486: IF (cur_rowid%FOUND) THEN
487: Close cur_rowid;
488: Fnd_Message.Set_Name ('IGS', 'IGS_HE_HPUD_US_FK');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;
491: Return;
492: END IF;
493: Close cur_rowid;
494:

Line 527: app_exception.raise_exception;

523: IF cur_stdnt%FOUND THEN
524: CLOSE cur_stdnt;
525: fnd_message.set_name ('IGS', 'IGS_HE_CANT_DEL_POP_EXIST');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: RETURN;
529: END IF;
530: CLOSE cur_stdnt;
531:

Line 656: app_exception.raise_exception;

652: )
653: ) THEN
654: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658: check_uniqueness;
659: check_parent_existance;
660: ELSIF (p_action = 'UPDATE') THEN

Line 675: app_exception.raise_exception;

671: )
672: ) THEN
673: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677: check_uniqueness;
678: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
679: check_uniqueness;

Line 773: app_exception.raise_exception;

769: END IF;
770: ELSE
771: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
772: igs_ge_msg_stack.add;
773: app_exception.raise_exception;
774: END IF;
775:
776: SELECT igs_he_poous_all_s.NEXTVAL
777: INTO x_hesa_poous_id

Line 1036: app_exception.raise_exception;

1032: IF (c1%notfound) THEN
1033: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1034: igs_ge_msg_stack.add;
1035: CLOSE c1;
1036: app_exception.raise_exception;
1037: RETURN;
1038: END IF;
1039: CLOSE c1;
1040:

Line 1082: app_exception.raise_exception;

1078: NULL;
1079: ELSE
1080: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1081: igs_ge_msg_stack.add;
1082: app_exception.raise_exception;
1083: END IF;
1084:
1085: RETURN;
1086:

Line 1169: app_exception.raise_exception;

1165: END IF;
1166: ELSE
1167: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception;
1170: END IF;
1171:
1172: before_dml(
1173: p_action => 'UPDATE',