APPS.IGS_PS_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

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

Line 79: IGS_GE_MSG_STACK.ADD;

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

Line 88: IGS_GE_MSG_STACK.ADD;

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

Line 163: IGS_GE_MSG_STACK.ADD;

159: -- Call all the procedures related to Before Insert.
160: IF Get_PK_For_Validation (
161: new_references.course_cat ) 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 179: IGS_GE_MSG_STACK.ADD;

175: ELSIF (p_action = 'VALIDATE_INSERT') THEN
176: IF Get_PK_For_Validation (
177: new_references.course_cat ) 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 230: IGS_GE_MSG_STACK.ADD;

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

Line 302: IGS_GE_MSG_STACK.ADD;

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

Line 314: IGS_GE_MSG_STACK.ADD;

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

Line 346: IGS_GE_MSG_STACK.ADD;

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