APPS.IGS_PS_STAT_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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

Line 83: IGS_GE_MSG_STACK.ADD;

79: column_name is null THEN
80: IF new_references.course_status <> UPPER(new_references.course_status)
81: THEN
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87:

Line 93: IGS_GE_MSG_STACK.ADD;

89: column_name is null THEN
90: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
91: THEN
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:

Line 103: IGS_GE_MSG_STACK.ADD;

99: column_name is null THEN
100: IF new_references.s_course_status NOT IN ( 'ACTIVE' , 'INACTIVE','PLANNED' )
101: THEN
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107: END Check_Constraints;

Line 179: IGS_GE_MSG_STACK.ADD;

175: IF Get_PK_For_Validation(
176: new_references.course_status
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 = 'UPDATE') THEN

Line 195: IGS_GE_MSG_STACK.ADD;

191: IF Get_PK_For_Validation(
192: new_references.course_status
193: ) THEN
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: Check_Constraints;
199: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 246: IGS_GE_MSG_STACK.ADD;

242: X_LAST_UPDATE_LOGIN := -1;
243: end if;
244: else
245: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
246: IGS_GE_MSG_STACK.ADD;
247: app_exception.raise_exception;
248: end if;
249: Before_DML( p_action => 'INSERT',
250: x_rowid => X_ROWID,

Line 317: IGS_GE_MSG_STACK.ADD;

313: fetch c1 into tlinfo;
314: if (c1%notfound) then
315: close c1;
316: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: return;
320: end if;
321: close c1;

Line 330: IGS_GE_MSG_STACK.ADD;

326: ) then
327: null;
328: else
329: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
330: IGS_GE_MSG_STACK.ADD;
331: app_exception.raise_exception;
332: end if;
333: return;
334: end LOCK_ROW;

Line 363: IGS_GE_MSG_STACK.ADD;

359: X_LAST_UPDATE_LOGIN := -1;
360: end if;
361: else
362: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: end if;
366: Before_DML( p_action => 'UPDATE',
367: x_rowid => X_ROWID,