APPS.IGS_PS_FLD_STD_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 43: IGS_GE_MSG_STACK.ADD;

39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
47: Close cur_old_ref_values;

Line 93: IGS_GE_MSG_STACK.ADD;

89: IF upper(column_name) = 'MAJOR_FIELD_IND' OR
90: column_name is null Then
91: IF ( new_references.major_field_ind NOT IN ( 'Y' , 'N' ) ) 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 102: IGS_GE_MSG_STACK.ADD;

98: IF upper(column_name) = 'COURSE_CD' OR
99: column_name is null Then
100: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:

Line 111: IGS_GE_MSG_STACK.ADD;

107: IF upper(column_name) = 'FIELD_OF_STUDY' OR
108: column_name is null Then
109: IF ( new_references.field_of_study <> UPPER(new_references.field_of_study) ) Then
110: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:

Line 132: IGS_GE_MSG_STACK.ADD;

128: new_references.course_cd,
129: new_references.version_number
130: ) THEN
131: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:

Line 145: IGS_GE_MSG_STACK.ADD;

141: IF NOT IGS_PS_FLD_OF_STUDY_PKG.Get_PK_For_Validation (
142: new_references.field_of_study
143: ) THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:

Line 205: IGS_GE_MSG_STACK.ADD;

201: Fetch cur_rowid INTO lv_rowid;
202: IF (cur_rowid%FOUND) THEN
203: Close cur_rowid;
204: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CFOSH_CV_FK');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: Return;
208: END IF;
209: Close cur_rowid;

Line 260: IGS_GE_MSG_STACK.ADD;

256: new_references.version_number,
257: new_references.field_of_study ,
258: new_references.hist_start_dt) THEN
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: Check_Constraints;
264: Check_Parent_Existance;

Line 279: IGS_GE_MSG_STACK.ADD;

275: new_references.version_number,
276: new_references.field_of_study ,
277: new_references.hist_start_dt) THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints;
283: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 337: IGS_GE_MSG_STACK.ADD;

333: X_LAST_UPDATE_LOGIN := -1;
334: end if;
335: else
336: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: end if;
340: Before_DML (
341: p_action => 'INSERT',

Line 433: IGS_GE_MSG_STACK.ADD;

429: fetch c1 into tlinfo;
430: if (c1%notfound) then
431: close c1;
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: return;
436: end if;
437: close c1;

Line 451: IGS_GE_MSG_STACK.ADD;

447: ) then
448: null;
449: else
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: return;
455: end LOCK_ROW;

Line 489: IGS_GE_MSG_STACK.ADD;

485: X_LAST_UPDATE_LOGIN := -1;
486: end if;
487: else
488: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
489: IGS_GE_MSG_STACK.ADD;
490: app_exception.raise_exception;
491: end if;
492: Before_DML (
493: p_action => 'UPDATE',