APPS.IGS_PS_GRP_MBR_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 93: IGS_GE_MSG_STACK.ADD;

89: v_course_cd,
90: v_version_number,
91: v_message_name) = FALSE THEN
92: Fnd_Message.Set_Name('IGS',v_message_name);
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: -- Validate IGS_PS_COURSE group code. IGS_PS_COURSE group code is not updateable.
97: -- Validation is intentionally done on the delete.

Line 102: IGS_GE_MSG_STACK.ADD;

98: IF IGS_PS_VAL_CGM.crsp_val_cgm_crs_grp (
99: v_course_group_cd,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS',v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105:
106:

Line 128: IGS_GE_MSG_STACK.ADD;

124: IF upper(column_name) = 'COURSE_CD' OR
125: column_name is null Then
126: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
127: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:

Line 137: IGS_GE_MSG_STACK.ADD;

133: IF upper(column_name) = 'COURSE_GROUP_CD' OR
134: column_name is null Then
135: IF ( new_references.course_group_cd <> UPPER(new_references.course_group_cd) ) Then
136: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF;
140: END IF;
141:

Line 155: IGS_GE_MSG_STACK.ADD;

151: IF NOT IGS_PS_GRP_PKG.Get_PK_For_Validation (
152: new_references.course_group_cd
153: ) THEN
154: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:

Line 171: IGS_GE_MSG_STACK.ADD;

167: new_references.course_cd,
168: new_references.version_number
169: ) THEN
170: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;
174: END IF;
175:

Line 229: IGS_GE_MSG_STACK.ADD;

225: Fetch cur_rowid INTO lv_rowid;
226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CGM_CRV_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;
233: Close cur_rowid;

Line 272: IGS_GE_MSG_STACK.ADD;

268: new_references.course_cd,
269: new_references.version_number,
270: new_references.course_group_cd) THEN
271: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: END IF;
275: Check_Constraints;
276: Check_Parent_Existance;

Line 291: IGS_GE_MSG_STACK.ADD;

287: new_references.course_cd,
288: new_references.version_number,
289: new_references.course_group_cd) THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: Check_Constraints;
295: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 342: IGS_GE_MSG_STACK.ADD;

338: X_LAST_UPDATE_LOGIN := -1;
339: end if;
340: else
341: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
342: IGS_GE_MSG_STACK.ADD;
343: app_exception.raise_exception;
344: end if;
345:
346: Before_DML (

Line 410: IGS_GE_MSG_STACK.ADD;

406: fetch c1 into tlinfo;
407: if (c1%notfound) then
408: close c1;
409: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
410: IGS_GE_MSG_STACK.ADD;
411: app_exception.raise_exception;
412: return;
413: end if;
414: close c1;