APPS.IGS_AD_AUS_SEC_ED_SC_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

34: Open cur_old_ref_values;
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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Close cur_old_ref_values;
41: Return;
42: END IF;

Line 78: IGS_GE_MSG_STACK.ADD;

74: IF IGS_AD_VAL_ASES.admp_val_ssst_closed(
75: new_references.s_scndry_school_type,
76: v_message_name) = FALSE THEN
77: Fnd_Message.Set_Name('IGS',v_message_name);
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82:

Line 107: IGS_GE_MSG_STACK.ADD;

103:
104: IF upper(Column_Name) = 'STATE_CD' OR Column_Name IS NULL THEN
105: IF new_references.state_cd <> UPPER(new_references.state_cd) THEN
106: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111: IF upper(Column_Name) = 'S_SCNDRY_SCHOOL_TYPE' OR Column_Name IS NULL THEN

Line 114: IGS_GE_MSG_STACK.ADD;

110: END IF;
111: IF upper(Column_Name) = 'S_SCNDRY_SCHOOL_TYPE' OR Column_Name IS NULL THEN
112: IF new_references.s_scndry_school_type <> UPPER(new_references.s_scndry_school_type) THEN
113: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN

Line 121: IGS_GE_MSG_STACK.ADD;

117: END IF;
118: IF upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
119: IF new_references.closed_ind NOT IN ('Y','N') THEN
120: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: END Check_Constraints;

Line 139: IGS_GE_MSG_STACK.ADD;

135: 'SCNDRY_SCHOOL_TYPE',
136: new_references.s_scndry_school_type
137: ) THEN
138: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142: END IF;
143:

Line 202: IGS_GE_MSG_STACK.ADD;

198: Fetch cur_rowid INTO lv_rowid;
199: IF (cur_rowid%FOUND) THEN
200: Close cur_rowid;
201: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASES_SLV_FK');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: Return;
205: END IF;
206: Close cur_rowid;

Line 247: IGS_GE_MSG_STACK.ADD;

243: IF Get_PK_For_Validation (
244: new_references.secondary_school_cd
245: ) THEN
246: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: Check_Constraints;
251: Check_Parent_Existance;

Line 263: IGS_GE_MSG_STACK.ADD;

259: IF Get_PK_For_Validation (
260: new_references.secondary_school_cd
261: ) THEN
262: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: Check_Constraints;
267: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 315: IGS_GE_MSG_STACK.ADD;

311: X_LAST_UPDATE_LOGIN := -1;
312: end if;
313: else
314: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: end if;
318:
319: Before_DML(

Line 394: IGS_GE_MSG_STACK.ADD;

390: open c1;
391: fetch c1 into tlinfo;
392: if (c1%notfound) then
393: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
394: IGS_GE_MSG_STACK.ADD;
395: app_exception.raise_exception;
396: close c1;
397: return;
398: end if;

Line 411: IGS_GE_MSG_STACK.ADD;

407: ) then
408: null;
409: else
410: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
411: IGS_GE_MSG_STACK.ADD;
412: app_exception.raise_exception;
413: end if;
414: return;
415: end LOCK_ROW;

Line 445: IGS_GE_MSG_STACK.ADD;

441: X_LAST_UPDATE_LOGIN := -1;
442: end if;
443: else
444: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
445: IGS_GE_MSG_STACK.ADD;
446: app_exception.raise_exception;
447: end if;
448:
449: Before_DML(