DBA Data[Home] [Help]

APPS.IGS_PS_DEGREES_PKG dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

45: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
46: Close cur_old_ref_values;
47: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
48: IGS_GE_MSG_STACK.ADD;
49: App_Exception.Raise_Exception;
50: Return;
51: END IF;
52: Close cur_old_ref_values;
53:

Line 103: App_Exception.Raise_Exception;

99: Column_Name IS NULL THEN
100: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
101: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107:

Line 132: App_Exception.Raise_Exception;

128: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
129: new_references.program_type ) THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135:
136: END check_parent_existance;

Line 241: App_Exception.Raise_Exception;

237: IF Get_Pk_For_Validation(
238: new_references.degree_cd) THEN
239: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: Check_Constraints;
244: check_parent_existance;
245: ELSIF (p_action = 'UPDATE') THEN

Line 260: App_Exception.Raise_Exception;

256: IF Get_PK_For_Validation (
257: new_references.degree_cd) THEN
258: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262: Check_Constraints;
263: check_parent_existance;
264: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

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:
351: -----

Line 428: app_exception.raise_exception;

424: if (c1%notfound) then
425: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
426: IGS_GE_MSG_STACK.ADD;
427: close c1;
428: app_exception.raise_exception;
429: return;
430: end if;
431: close c1;
432: if ( ( tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 442: app_exception.raise_exception;

438: null;
439: else
440: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
441: IGS_GE_MSG_STACK.ADD;
442: app_exception.raise_exception;
443: end if;
444: return;
445: end LOCK_ROW;
446: Procedure UPDATE_ROW (

Line 485: app_exception.raise_exception;

481: end if;
482: else
483: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487: Before_DML(
488: p_action=>'UPDATE',
489: x_rowid=>X_ROWID,