APPS.IGS_AD_AUS_SEC_ED_SC_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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;
43: Close cur_old_ref_values;

Line 79: App_Exception.Raise_Exception;

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:
83:

Line 108: App_Exception.Raise_Exception;

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
112: IF new_references.s_scndry_school_type <> UPPER(new_references.s_scndry_school_type) THEN

Line 115: App_Exception.Raise_Exception;

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
119: IF new_references.closed_ind NOT IN ('Y','N') THEN

Line 122: App_Exception.Raise_Exception;

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;
126:

Line 140: App_Exception.Raise_Exception;

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:
144: END Check_Parent_Existance;

Line 203: App_Exception.Raise_Exception;

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;
207:

Line 248: App_Exception.Raise_Exception;

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;
252: ELSIF (p_action = 'UPDATE') THEN

Line 264: App_Exception.Raise_Exception;

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
268: Check_Constraints;

Line 316: app_exception.raise_exception;

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(
320: p_action=>'INSERT',

Line 395: app_exception.raise_exception;

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;
399: close c1;

Line 412: app_exception.raise_exception;

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;
416:

Line 446: app_exception.raise_exception;

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(
450: p_action=>'UPDATE',