APPS.IGS_PS_USEC_CAL_NUMS_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 117: app_exception.raise_exception;

113: ,new_references.ci_sequence_number
114: ) THEN
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
116: IGS_GE_MSG_STACK.ADD;
117: app_exception.raise_exception;
118: END IF;
119: END Check_Uniqueness ;
120: FUNCTION Get_PK_For_Validation (
121: x_unit_section_call_number_id IN NUMBER

Line 240: App_Exception.Raise_Exception;

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

Line 258: App_Exception.Raise_Exception;

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

Line 345: app_exception.raise_exception;

341: end if;
342: else
343: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: end if;
347: SELECT
348: IGS_PS_USEC_CAL_NUMS_S.nextval
349: INTO

Line 429: app_exception.raise_exception;

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

Line 441: app_exception.raise_exception;

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

Line 484: app_exception.raise_exception;

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