APPS.IGS_RE_SPRVSR_TYPE_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 83: App_Exception.Raise_Exception ;

79: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind)
80: OR new_references.closed_ind NOT IN ('Y', 'N') then
81: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception ;
84: END IF;
85: END IF;
86: IF upper(column_name) = 'PRINCIPAL_SUPERVISOR_IND' OR COLUMN_NAME IS NULL THEN
87: IF new_references.PRINCIPAL_SUPERVISOR_IND <> upper(NEW_REFERENCES.PRINCIPAL_SUPERVISOR_IND) OR

Line 91: App_Exception.Raise_Exception ;

87: IF new_references.PRINCIPAL_SUPERVISOR_IND <> upper(NEW_REFERENCES.PRINCIPAL_SUPERVISOR_IND) OR
88: new_references.PRINCIPAL_SUPERVISOR_IND NOT IN ('Y', 'N') then
89: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception ;
92: END IF;
93: END IF;
94: IF upper(column_name) = 'RESEARCH_SUPERVISOR_TYPE' OR COLUMN_NAME IS NULL THEN
95: IF new_references.RESEARCH_SUPERVISOR_TYPE <> upper(NEW_REFERENCES.RESEARCH_SUPERVISOR_TYPE) then

Line 98: App_Exception.Raise_Exception ;

94: IF upper(column_name) = 'RESEARCH_SUPERVISOR_TYPE' OR COLUMN_NAME IS NULL THEN
95: IF new_references.RESEARCH_SUPERVISOR_TYPE <> upper(NEW_REFERENCES.RESEARCH_SUPERVISOR_TYPE) then
96: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception ;
99: END IF;
100: END IF;
101: END Check_Constraints ;
102:

Line 176: App_Exception.Raise_Exception;

172: new_references.research_supervisor_type
173: ) THEN
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: Check_Constraints;
179: ELSIF (p_action = 'UPDATE') THEN
180: -- Call all the procedures related to Before Update.

Line 191: App_Exception.Raise_Exception;

187: new_references.research_supervisor_type
188: ) THEN
189: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193: Check_Constraints;
194: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
195: Check_Constraints;

Line 231: app_exception.raise_exception;

227: end if;
228: else
229: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
230: IGS_GE_MSG_STACK.ADD;
231: app_exception.raise_exception;
232: end if;
233:
234: Before_DML (
235: p_action => 'INSERT',

Line 302: app_exception.raise_exception;

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

Line 314: app_exception.raise_exception;

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

Line 347: app_exception.raise_exception;

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