APPS.IGS_AD_OS_SEC_EDU_QF_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

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

Line 82: IGS_GE_MSG_STACK.ADD;

78:
79: IF upper(Column_Name) = 'OS_SCNDRY_EDU_QUALIFICATION' OR Column_Name IS NULL THEN
80: IF new_references.os_scndry_edu_qualification <> UPPER(new_references.os_scndry_edu_qualification) THEN
81: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN

Line 89: IGS_GE_MSG_STACK.ADD;

85: END IF;
86: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
87: IF new_references.country_cd <> UPPER(new_references.country_cd) 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: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN

Line 96: IGS_GE_MSG_STACK.ADD;

92: END IF;
93: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
94: IF new_references.closed_ind NOT IN ('Y','N') THEN
95: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: END IF;
100:

Line 114: IGS_GE_MSG_STACK.ADD;

110: IF NOT IGS_PE_COUNTRY_CD_PKG.Get_PK_For_Validation (
111: new_references.country_cd
112: ) THEN
113: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118:

Line 176: IGS_GE_MSG_STACK.ADD;

172: Fetch cur_rowid INTO lv_rowid;
173: IF (cur_rowid%FOUND) THEN
174: Close cur_rowid;
175: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSEQ_CNC_FK');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: Return;
179: END IF;
180: Close cur_rowid;

Line 218: IGS_GE_MSG_STACK.ADD;

214: IF Get_PK_For_Validation (
215: new_references.os_scndry_edu_qualification
216: ) THEN
217: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception;
220: END IF;
221: Check_Constraints;
222: Check_Parent_Existance;

Line 233: IGS_GE_MSG_STACK.ADD;

229: IF Get_PK_For_Validation (
230: new_references.os_scndry_edu_qualification
231: ) THEN
232: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: END IF;
236: Check_Constraints;
237: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 285: IGS_GE_MSG_STACK.ADD;

281: X_LAST_UPDATE_LOGIN := -1;
282: end if;
283: else
284: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
285: IGS_GE_MSG_STACK.ADD;
286: app_exception.raise_exception;
287: end if;
288:
289: Before_DML(

Line 363: IGS_GE_MSG_STACK.ADD;

359: fetch c1 into tlinfo;
360: if (c1%notfound) then
361: close c1;
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: return;
366: end if;
367: close c1;

Line 378: IGS_GE_MSG_STACK.ADD;

374: ) then
375: null;
376: else
377: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
378: IGS_GE_MSG_STACK.ADD;
379: app_exception.raise_exception;
380: end if;
381: return;
382: end LOCK_ROW;

Line 411: IGS_GE_MSG_STACK.ADD;

407: X_LAST_UPDATE_LOGIN := -1;
408: end if;
409: else
410: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414:
415: Before_DML(