APPS.IGS_PS_UNT_PRV_GRADE_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;
55:

Line 124: app_exception.raise_exception;

120: ,new_references.grading_schema_version_number
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;
127: PROCEDURE Check_Parent_Existance AS
128: /*************************************************************

Line 155: App_Exception.Raise_Exception;

151: new_references.grading_schema_value
152: ) THEN
153: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157:
158: IF (((old_references.unit_code = new_references.unit_code) AND
159: (old_references.unit_version_number = new_references.unit_version_number)) OR

Line 169: App_Exception.Raise_Exception;

165: new_references.unit_version_number
166: ) THEN
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171:
172: END Check_Parent_Existance;
173:

Line 287: App_Exception.Raise_Exception;

283: IF (cur_rowid%FOUND) THEN
284: Close cur_rowid;
285: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UPG_GSG_FK');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: Return;
289: END IF;
290: Close cur_rowid;
291:

Line 326: App_Exception.Raise_Exception;

322: IF (cur_rowid%FOUND) THEN
323: Close cur_rowid;
324: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UPG_UV_FK');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: Return;
328: END IF;
329: Close cur_rowid;
330:

Line 384: App_Exception.Raise_Exception;

380: IF Get_Pk_For_Validation(
381: new_references.unit_prev_grade_id) THEN
382: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: IGS_GE_MSG_STACK.ADD;
384: App_Exception.Raise_Exception;
385: END IF;
386: Check_Uniqueness;
387: Check_Constraints;
388: Check_Parent_Existance;

Line 404: App_Exception.Raise_Exception;

400: IF Get_PK_For_Validation (
401: new_references.unit_prev_grade_id) THEN
402: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406: Check_Uniqueness;
407: Check_Constraints;
408: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 493: app_exception.raise_exception;

489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: select igs_ps_unt_prv_grade_s.nextval
496: into x_unit_prev_grade_id
497: from dual;

Line 584: app_exception.raise_exception;

580: if (c1%notfound) then
581: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
582: IGS_GE_MSG_STACK.ADD;
583: close c1;
584: app_exception.raise_exception;
585: return;
586: end if;
587: close c1;
588: if ( ( tlinfo.UNIT_CODE = X_UNIT_CODE)

Line 598: app_exception.raise_exception;

594: null;
595: else
596: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600: return;
601: end LOCK_ROW;
602: Procedure UPDATE_ROW (

Line 643: app_exception.raise_exception;

639: end if;
640: else
641: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
642: IGS_GE_MSG_STACK.ADD;
643: app_exception.raise_exception;
644: end if;
645: Before_DML(
646: p_action=>'UPDATE',
647: x_rowid=>X_ROWID,