APPS.IGS_PS_FIELD_STUDY_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 97: App_Exception.Raise_Exception;

93: v_version_number,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS',v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: -- Validate field of study. Field of study is not updateable.
100: IF p_inserting THEN
101: IF IGS_PS_VAL_CFOS.crsp_val_cfos_fos (

Line 106: App_Exception.Raise_Exception;

102: new_references.field_of_study,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS',v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109: -- Insert history record on update.
110: IF p_updating THEN

Line 182: App_Exception.Raise_Exception;

178: new_references.version_number
179: ) THEN
180: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;
185:
186: IF (((old_references.field_of_study = new_references.field_of_study)) OR

Line 195: App_Exception.Raise_Exception;

191: new_references.field_of_study
192: ) THEN
193: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198:
199: END Check_Parent_Existance;

Line 252: App_Exception.Raise_Exception;

248: IF (cur_rowid%FOUND) THEN
249: Close cur_rowid;
250: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CFOS_CRV_FK');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: Return;
254: END IF;
255: Close cur_rowid;
256:

Line 299: App_Exception.Raise_Exception;

295: new_references.version_number ,
296: new_references.field_of_study) THEN
297: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: END IF;
301: Check_Constraints;
302: Check_Parent_Existance;
303: ELSIF (p_action = 'UPDATE') THEN

Line 318: App_Exception.Raise_Exception;

314: new_references.version_number ,
315: new_references.field_of_study) THEN
316: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Constraints;
321: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
322: Check_Constraints;

Line 370: app_exception.raise_exception;

366: end if;
367: else
368: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
369: IGS_GE_MSG_STACK.ADD;
370: app_exception.raise_exception;
371: end if;
372: Before_DML (
373: p_action => 'INSERT',
374: x_rowid => X_ROWID,

Line 447: app_exception.raise_exception;

443: if (c1%notfound) then
444: close c1;
445: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
446: IGS_GE_MSG_STACK.ADD;
447: app_exception.raise_exception;
448: return;
449: end if;
450: close c1;
451:

Line 459: app_exception.raise_exception;

455: null;
456: else
457: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: end if;
461: return;
462: end LOCK_ROW;
463:

Line 493: app_exception.raise_exception;

489: end if;
490: else
491: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: Before_DML (
496: p_action => 'UPDATE',
497: x_rowid => X_ROWID,