APPS.IGS_EN_ENCMB_EFCTTYP_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 80: App_Exception.Raise_Exception;

76: Column_name is null THEN
77: IF new_references.apply_to_course_ind NOT IN ('Y','N') THEN
78: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82: END IF;
83:
84: IF upper(column_name) = 'CLOSED_IND' OR

Line 89: App_Exception.Raise_Exception;

85: Column_name is null THEN
86: IF new_references.closed_ind NOT IN ('Y','N') THEN
87: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92:
93: IF upper(column_name) = 'S_ENCMB_EFFECT_TYPE' OR

Line 99: App_Exception.Raise_Exception;

95: IF new_references.s_encmb_effect_type <>
96: upper(new_references.s_encmb_effect_type) THEN
97: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102:
103: END check_constraints;

Line 166: App_Exception.Raise_Exception;

162: new_references.s_encmb_effect_type
163: ) THEN
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: Check_constraints;
169: ELSIF (p_action = 'UPDATE') THEN
170: -- Call all the procedures related to Before Update.

Line 180: App_Exception.Raise_Exception;

176: new_references.s_encmb_effect_type
177: ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182:
183: Check_constraints;
184: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 236: app_exception.raise_exception;

232: end if;
233: else
234: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
235: IGS_GE_MSG_STACK.ADD;
236: app_exception.raise_exception;
237: end if;
238: Before_DML (
239: p_action =>'INSERT',
240: x_rowid => x_rowid,

Line 302: app_exception.raise_exception;

298: if (c1%notfound) then
299: close c1;
300: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
301: IGS_GE_MSG_STACK.ADD;
302: app_exception.raise_exception;
303: return;
304: end if;
305: close c1;
306:

Line 314: app_exception.raise_exception;

310: null;
311: else
312: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
313: IGS_GE_MSG_STACK.ADD;
314: app_exception.raise_exception;
315: end if;
316: return;
317: end LOCK_ROW;
318:

Line 346: app_exception.raise_exception;

342: end if;
343: else
344: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: end if;
348:
349: Before_DML (
350: p_action =>'UPDATE',