APPS.IGS_PS_CATEGORISE_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 92: IGS_GE_MSG_STACK.ADD;

88: v_course_cd,
89: v_version_number,
90: v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS',v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: -- Validate IGS_PS_COURSE category. IGS_PS_COURSE category is not updateable.
96: IF p_inserting THEN

Line 101: IGS_GE_MSG_STACK.ADD;

97: IF IGS_PS_VAL_CRC.crsp_val_crc_crs_cat (
98: new_references.course_cat,
99: v_message_name) = FALSE THEN
100: Fnd_Message.Set_Name('IGS',v_message_name);
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105:

Line 128: IGS_GE_MSG_STACK.ADD;

124: IF upper(column_name) = 'COURSE_CAT' OR
125: column_name is null Then
126: IF ( new_references.course_cat <> UPPER(new_references.course_cat) ) 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_CD' OR
134: column_name is null Then
135: IF ( new_references.course_cd <> UPPER(new_references.course_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_CAT_PKG.Get_PK_For_Validation (
152: new_references.course_cat
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 227: IGS_GE_MSG_STACK.ADD;

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

Line 255: IGS_GE_MSG_STACK.ADD;

251: Fetch cur_rowid INTO lv_rowid;
252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CRC_CRV_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;

Line 309: IGS_GE_MSG_STACK.ADD;

305: new_references.course_cd,
306: new_references.version_number,
307: new_references.course_cat ) THEN
308: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: END IF;
312: Check_Constraints;
313: Check_Parent_Existance;

Line 328: IGS_GE_MSG_STACK.ADD;

324: new_references.course_cd,
325: new_references.version_number,
326: new_references.course_cat ) THEN
327: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: END IF;
331: Check_Constraints;
332: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 379: IGS_GE_MSG_STACK.ADD;

375: X_LAST_UPDATE_LOGIN := -1;
376: end if;
377: else
378: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
379: IGS_GE_MSG_STACK.ADD;
380: app_exception.raise_exception;
381: end if;
382:
383: Before_DML (

Line 453: IGS_GE_MSG_STACK.ADD;

449: fetch c1 into tlinfo;
450: if (c1%notfound) then
451: close c1;
452: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: return;
456: end if;
457: close c1;