APPS.IGS_GR_APRV_STAT_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 131: App_Exception.Raise_Exception;

127: -- Call all the procedures related to Before Insert.
128: IF Get_PK_For_Validation(new_references.graduand_appr_status ) THEN
129: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
130: IGS_GE_MSG_STACK.ADD;
131: App_Exception.Raise_Exception;
132: END IF;
133: Check_Constraints;
134:
135: ELSIF (p_action = 'UPDATE') THEN

Line 147: App_Exception.Raise_Exception;

143: ELSIF (p_action = 'VALIDATE_INSERT') THEN
144: IF Get_PK_For_Validation(new_references.graduand_appr_status ) THEN
145: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149: Check_Constraints;
150: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
151: Check_Constraints;

Line 196: app_exception.raise_exception;

192: end if;
193: else
194: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
195: IGS_GE_MSG_STACK.ADD;
196: app_exception.raise_exception;
197: end if;
198:
199: Before_DML (
200: p_action => 'INSERT',

Line 266: app_exception.raise_exception;

262: fetch c1 into tlinfo;
263: if (c1%notfound) then
264: close c1;
265: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
266: app_exception.raise_exception;
267: return;
268: end if;
269: close c1;
270:

Line 278: app_exception.raise_exception;

274: ) then
275: null;
276: else
277: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
278: app_exception.raise_exception;
279: end if;
280: return;
281: end LOCK_ROW;
282:

Line 311: app_exception.raise_exception;

307: end if;
308: else
309: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
310: IGS_GE_MSG_STACK.ADD;
311: app_exception.raise_exception;
312: end if;
313:
314: Before_DML (
315: p_action => 'UPDATE',

Line 400: App_Exception.Raise_Exception;

396: IF upper(Column_name) = 'S_GRADUAND_APPR_STATUS' or column_name IS NULL Then
397: IF new_references.s_graduand_appr_status NOT IN ('WAITING', 'APPROVED', 'REJECTED') THEN
398: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: END IF;
402: END IF;
403:
404: IF upper(Column_name) = 'CLOSED_IND' or column_name IS NULL THEN

Line 408: App_Exception.Raise_Exception;

404: IF upper(Column_name) = 'CLOSED_IND' or column_name IS NULL THEN
405: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
406: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
407: IGS_GE_MSG_STACK.ADD;
408: App_Exception.Raise_Exception;
409: END IF;
410: END IF;
411:
412: IF upper(Column_name) = 'GRADUAND_APPR_STATUS' or column_name IS NULL THEN

Line 416: App_Exception.Raise_Exception;

412: IF upper(Column_name) = 'GRADUAND_APPR_STATUS' or column_name IS NULL THEN
413: IF new_references.graduand_appr_status<> upper(new_references.graduand_appr_status) then
414: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: END IF;
418: END IF;
419:
420: