APPS.IGS_GE_SPL_REQ_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 77: IGS_GE_MSG_STACK.ADD;

73: IF upper(Column_name) = 'CLOSED_IND' OR column_name is null then
74: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
75: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
76: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81: IF upper(Column_name) = 'SPECIAL_REQUIREMENT_CD' OR column_name is null then

Line 84: IGS_GE_MSG_STACK.ADD;

80: END IF;
81: IF upper(Column_name) = 'SPECIAL_REQUIREMENT_CD' OR column_name is null then
82: IF new_references.special_requirement_cd <> UPPER(new_references.special_requirement_cd ) then
83: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: END IF;
88: END Check_Constraints;

Line 160: IGS_GE_MSG_STACK.ADD;

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

Line 175: IGS_GE_MSG_STACK.ADD;

171: IF Get_PK_For_Validation(
172: new_references.special_requirement_cd
173: )THEN
174: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF ;
178: Check_Constraints;
179: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 237: IGS_GE_MSG_STACK.ADD;

233: X_LAST_UPDATE_LOGIN := -1;
234: end if;
235: else
236: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
237: IGS_GE_MSG_STACK.ADD;
238: app_exception.raise_exception;
239: end if;
240: Before_DML (
241: p_action => 'INSERT',

Line 311: IGS_GE_MSG_STACK.ADD;

307: fetch c1 into tlinfo;
308: if (c1%notfound) then
309: close c1;
310: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
311: IGS_GE_MSG_STACK.ADD;
312: app_exception.raise_exception;
313: return;
314: end if;
315: close c1;

Line 326: IGS_GE_MSG_STACK.ADD;

322: ) then
323: null;
324: else
325: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
326: IGS_GE_MSG_STACK.ADD;
327: app_exception.raise_exception;
328: end if;
329: return;
330: end LOCK_ROW;

Line 359: IGS_GE_MSG_STACK.ADD;

355: X_LAST_UPDATE_LOGIN := -1;
356: end if;
357: else
358: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362: Before_DML (
363: p_action => 'UPDATE',