APPS.IGS_PS_GOVT_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 73: IGS_GE_MSG_STACK.ADD;

69: new_references.govt_course_type,
70: new_references.closed_ind,
71: v_message_name) = FALSE THEN
72: Fnd_Message.Set_Name('IGS', v_message_name);
73: IGS_GE_MSG_STACK.ADD;
74: App_Exception.Raise_Exception;
75: END IF;
76: END IF;
77:

Line 99: IGS_GE_MSG_STACK.ADD;

95: IF upper(column_name) = 'CLOSED_IND' OR
96: column_name is null Then
97: IF new_references.closed_ind NOT IN ('Y','N') THEN
98: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103:

Line 108: IGS_GE_MSG_STACK.ADD;

104: IF upper(column_name) = 'GOVT_COURSE_TYPE' OR
105: column_name is null Then
106: IF new_references.govt_course_type < 0 OR new_references.govt_course_type > 99 Then
107: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112: END check_constraints;

Line 182: IGS_GE_MSG_STACK.ADD;

178: IF Get_PK_For_Validation (
179: new_references.govt_course_type
180: ) THEN
181: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: Check_Constraints;
186: ELSIF (p_action = 'UPDATE') THEN

Line 198: IGS_GE_MSG_STACK.ADD;

194: IF Get_PK_For_Validation (
195: new_references.govt_course_type
196: ) THEN
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: Check_Constraints;
202: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 248: IGS_GE_MSG_STACK.ADD;

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

Line 315: IGS_GE_MSG_STACK.ADD;

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

Line 327: IGS_GE_MSG_STACK.ADD;

323: ) then
324: null;
325: else
326: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: return;
331: 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:
363: Before_DML( p_action => 'UPDATE',