APPS.IGS_RE_GV_FLD_OF_SDY_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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

Line 78: App_Exception.Raise_Exception;

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

Line 104: App_Exception.Raise_Exception ;

100: IF upper(column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
101: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR new_references.closed_ind NOT IN ('Y', 'N') THEN
102: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception ;
105: END IF;
106: END IF;
107: IF upper(column_name) = 'GOVT_FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN
108: IF new_references.GOVT_FIELD_OF_STUDY <> upper(NEW_REFERENCES.GOVT_FIELD_OF_STUDY) then

Line 111: App_Exception.Raise_Exception ;

107: IF upper(column_name) = 'GOVT_FIELD_OF_STUDY' OR COLUMN_NAME IS NULL THEN
108: IF new_references.GOVT_FIELD_OF_STUDY <> upper(NEW_REFERENCES.GOVT_FIELD_OF_STUDY) then
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception ;
112: END IF;
113: END IF;
114: IF upper(column_name) = 'RES_FCD_CLASS_IND' OR COLUMN_NAME IS NULL THEN
115: IF new_references.RES_FCD_CLASS_IND <> upper(NEW_REFERENCES.RES_FCD_CLASS_IND) OR

Line 119: App_Exception.Raise_Exception ;

115: IF new_references.RES_FCD_CLASS_IND <> upper(NEW_REFERENCES.RES_FCD_CLASS_IND) OR
116: new_references.RES_FCD_CLASS_IND NOT IN ('Y', 'N') THEN
117: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception ;
120: END IF;
121: END IF;
122: END Check_Constraints ;
123:

Line 199: App_Exception.Raise_Exception;

195: ) THEN
196:
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: Check_Constraints;
202: ELSIF (p_action = 'UPDATE') THEN
203: -- Call all the procedures related to Before Update.

Line 215: App_Exception.Raise_Exception;

211: new_references.govt_field_of_study
212: ) THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: Check_Constraints;
218: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
219: Check_Constraints;

Line 255: app_exception.raise_exception;

251: end if;
252: else
253: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
254: IGS_GE_MSG_STACK.ADD;
255: app_exception.raise_exception;
256: end if;
257:
258: Before_DML (
259: p_action => 'INSERT',

Line 326: app_exception.raise_exception;

322: fetch c1 into tlinfo;
323: if (c1%notfound) then
324: close c1;
325: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
326: app_exception.raise_exception;
327: return;
328: end if;
329: close c1;
330:

Line 338: app_exception.raise_exception;

334: ) then
335: null;
336: else
337: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
338: app_exception.raise_exception;
339: end if;
340: return;
341: end LOCK_ROW;
342:

Line 371: app_exception.raise_exception;

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