APPS.IGS_CA_ARTS_TC_CA_CD_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Close cur_old_ref_values;
35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Return;
39: END IF;
40: Close cur_old_ref_values;
41:

Line 111: App_Exception.Raise_Exception;

107: If upper(column_name) = 'CLOSED_IND' or column_name is null Then
108: if new_references.closed_ind not in ('Y', 'N') then
109: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: end if;
113: end if;
114: if upper(column_name) = 'ARTS_TEACHING_CAL_TYPE_CD' or column_name is null Then
115: if new_references.arts_teaching_cal_type_cd <> upper(new_references.arts_teaching_cal_type_cd ) then

Line 118: App_Exception.Raise_Exception;

114: if upper(column_name) = 'ARTS_TEACHING_CAL_TYPE_CD' or column_name is null Then
115: if new_references.arts_teaching_cal_type_cd <> upper(new_references.arts_teaching_cal_type_cd ) then
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: end if;
120: end if;
121:
122: END Check_Constraints;

Line 157: App_Exception.Raise_Exception;

153: -- Call all the procedures related to Before Insert.
154: IF Get_PK_For_Validation ( new_references.arts_teaching_cal_type_cd ) THEN
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: Check_Constraints;
160: ELSIF (p_action = 'VALIDATE_INSERT') THEN
161: IF Get_PK_For_Validation ( new_references.arts_teaching_cal_type_cd ) THEN

Line 164: App_Exception.Raise_Exception;

160: ELSIF (p_action = 'VALIDATE_INSERT') THEN
161: IF Get_PK_For_Validation ( new_references.arts_teaching_cal_type_cd ) THEN
162: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: Check_Constraints;
167: ELSIF (p_action = 'UPDATE') THEN
168: -- Call all the procedures related to Before Update.

Line 211: app_exception.raise_exception;

207: end if;
208: else
209: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
210: IGS_GE_MSG_STACK.ADD;
211: app_exception.raise_exception;
212: end if;
213: Before_DML (
214: p_action =>'INSERT',
215: x_rowid =>X_ROWID,

Line 276: app_exception.raise_exception;

272: if (c1%notfound) then
273: close c1;
274: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
275: IGS_GE_MSG_STACK.ADD;
276: app_exception.raise_exception;
277: return;
278: end if;
279: close c1;
280:

Line 288: app_exception.raise_exception;

284: null;
285: else
286: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
287: IGS_GE_MSG_STACK.ADD;
288: app_exception.raise_exception;
289: end if;
290: return;
291: end LOCK_ROW;
292:

Line 320: app_exception.raise_exception;

316: end if;
317: else
318: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
319: IGS_GE_MSG_STACK.ADD;
320: app_exception.raise_exception;
321: end if;
322:
323: Before_DML (
324: p_action =>'UPDATE',