APPS.IGS_AD_RS_VALUES_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

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

Line 105: App_Exception.Raise_Exception;

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

Line 131: app_exception.raise_exception;

127: ,new_references.rating_value
128: ) 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: END Check_Uniqueness ;
134: PROCEDURE Check_Parent_Existance AS
135: /*************************************************************

Line 156: App_Exception.Raise_Exception;

152: new_references.rating_scale_id ,
153: 'N') THEN
154: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158:
159: END Check_Parent_Existance;
160:

Line 289: App_Exception.Raise_Exception;

285: IF (cur_rowid%FOUND) THEN
286: Close cur_rowid;
287: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ARV_ARS_FK');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: Return;
291: END IF;
292: Close cur_rowid;
293:

Line 345: App_Exception.Raise_Exception;

341: IF Get_Pk_For_Validation(
342: new_references.rating_values_id) THEN
343: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: Check_Uniqueness;
348: Check_Constraints;
349: Check_Parent_Existance;

Line 366: App_Exception.Raise_Exception;

362: IF Get_PK_For_Validation (
363: new_references.rating_values_id) THEN
364: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
365: IGS_GE_MSG_STACK.ADD;
366: App_Exception.Raise_Exception;
367: END IF;
368: Check_Uniqueness;
369: Check_Constraints;
370: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 454: app_exception.raise_exception;

450: end if;
451: else
452: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456:
457: X_RATING_VALUES_ID := -1;
458:

Line 540: app_exception.raise_exception;

536: if (c1%notfound) then
537: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
538: IGS_GE_MSG_STACK.ADD;
539: close c1;
540: app_exception.raise_exception;
541: return;
542: end if;
543: close c1;
544: if ( (tlinfo.RATING_SCALE_ID = X_RATING_SCALE_ID)

Line 553: app_exception.raise_exception;

549: null;
550: else
551: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: end if;
555: return;
556: end LOCK_ROW;
557: Procedure UPDATE_ROW (

Line 597: app_exception.raise_exception;

593: end if;
594: else
595: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
596: IGS_GE_MSG_STACK.ADD;
597: app_exception.raise_exception;
598: end if;
599: Before_DML(
600: p_action=>'UPDATE',
601: x_rowid=>X_ROWID,