APPS.IGS_PS_GOVT_SPL_TYPE_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 78: IGS_GE_MSG_STACK.ADD;

74: IF upper(column_name) = 'CLOSED_IND' OR
75: column_name is null Then
76: IF new_references.closed_ind NOT IN ('Y','N') THEN
77: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82:

Line 87: IGS_GE_MSG_STACK.ADD;

83: IF upper(column_name) = 'GOVT_SPECIAL_COURSE_TYPE' OR
84: column_name is null Then
85: IF new_references.govt_special_course_type <> UPPER(new_references.govt_special_course_type) Then
86: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91: END check_constraints;

Line 162: IGS_GE_MSG_STACK.ADD;

158: IF Get_PK_For_Validation (
159: new_references.govt_special_course_type
160: ) THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: Check_Constraints;
166: ELSIF (p_action = 'UPDATE') THEN

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF Get_PK_For_Validation (
176: new_references.govt_special_course_type
177: ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: Check_Constraints;
183: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 232: IGS_GE_MSG_STACK.ADD;

228: X_LAST_UPDATE_LOGIN := -1;
229: end if;
230: else
231: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
232: IGS_GE_MSG_STACK.ADD;
233: app_exception.raise_exception;
234: end if;
235:
236: Before_DML( p_action => 'INSERT',

Line 301: IGS_GE_MSG_STACK.ADD;

297: fetch c1 into tlinfo;
298: if (c1%notfound) then
299: close c1;
300: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
301: IGS_GE_MSG_STACK.ADD;
302: app_exception.raise_exception;
303: return;
304: end if;
305: close c1;

Line 313: IGS_GE_MSG_STACK.ADD;

309: ) then
310: null;
311: else
312: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
313: IGS_GE_MSG_STACK.ADD;
314: app_exception.raise_exception;
315: end if;
316: return;
317: end LOCK_ROW;

Line 345: IGS_GE_MSG_STACK.ADD;

341: X_LAST_UPDATE_LOGIN := -1;
342: end if;
343: else
344: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348:
349: Before_DML( p_action => 'UPDATE',