APPS.IGS_CA_ARTS_TC_CA_CD_PKG dependencies on IGS_GE_MSG_STACK

Line 36: IGS_GE_MSG_STACK.ADD;

32: Fetch cur_old_ref_values INTO old_references;
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;

Line 110: IGS_GE_MSG_STACK.ADD;

106: end if;
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

Line 117: IGS_GE_MSG_STACK.ADD;

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
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:

Line 156: IGS_GE_MSG_STACK.ADD;

152: IF (p_action = 'INSERT') THEN
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

Line 163: IGS_GE_MSG_STACK.ADD;

159: Check_Constraints;
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

Line 210: IGS_GE_MSG_STACK.ADD;

206: X_LAST_UPDATE_LOGIN := -1;
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',

Line 275: IGS_GE_MSG_STACK.ADD;

271: fetch c1 into tlinfo;
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;

Line 287: IGS_GE_MSG_STACK.ADD;

283: ) then
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;

Line 319: IGS_GE_MSG_STACK.ADD;

315: X_LAST_UPDATE_LOGIN := -1;
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 (