APPS.IGS_PS_UNT_INLV_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 89: IGS_GE_MSG_STACK.ADD;

85:
86: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
87: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
88: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;
93:

Line 97: IGS_GE_MSG_STACK.ADD;

93:
94: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then
95: IF New_References.Unit_Int_Course_Level_Cd <> UPPER(New_References.Unit_Int_Course_Level_Cd) Then
96: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101:

Line 174: IGS_GE_MSG_STACK.ADD;

170: -- Call all the procedures related to Before Insert.
171: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd,
172: New_References.hist_start_dt) THEN
173: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: Check_Constraints;
178: ELSIF (p_action = 'UPDATE') THEN

Line 186: IGS_GE_MSG_STACK.ADD;

182: ELSIF (p_action = 'VALIDATE_INSERT') THEN
183: IF Get_PK_For_Validation (New_References.unit_int_course_level_cd,
184: New_References.hist_start_dt) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: Check_Constraints;
190: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 244: IGS_GE_MSG_STACK.ADD;

240: X_LAST_UPDATE_LOGIN := -1;
241: end if;
242: else
243: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
244: IGS_GE_MSG_STACK.ADD;
245: app_exception.raise_exception;
246: end if;
247:
248: Before_DML(

Line 337: IGS_GE_MSG_STACK.ADD;

333: fetch c1 into tlinfo;
334: if (c1%notfound) then
335: close c1;
336: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: return;
340: end if;
341: close c1;

Line 358: IGS_GE_MSG_STACK.ADD;

354: ) then
355: null;
356: else
357: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
358: IGS_GE_MSG_STACK.ADD;
359: app_exception.raise_exception;
360: end if;
361: return;
362: end LOCK_ROW;

Line 394: IGS_GE_MSG_STACK.ADD;

390: X_LAST_UPDATE_LOGIN := -1;
391: end if;
392: else
393: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
394: IGS_GE_MSG_STACK.ADD;
395: app_exception.raise_exception;
396: end if;
397: Before_DML(
398: p_action => 'UPDATE',