APPS.IGS_AD_RATING_SCALES_PKG dependencies on APP_EXCEPTION

Line 52: App_Exception.Raise_Exception;

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

Line 111: App_Exception.Raise_Exception;

107: Column_Name IS NULL THEN
108: IF NOT (new_references.closed_ind in ('Y','N')) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:
115: -- The following code checks for check constraints on the Columns.

Line 121: App_Exception.Raise_Exception;

117: Column_Name IS NULL THEN
118: IF NOT (new_references.dflt in ('Y','N')) THEN
119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:
125:

Line 146: app_exception.raise_exception;

142: new_references.rating_scale_name
143: ) THEN
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
145: IGS_GE_MSG_STACK.ADD;
146: app_exception.raise_exception;
147: END IF;
148: END Check_Uniqueness ;
149: PROCEDURE Check_Child_Existance IS
150: /*************************************************************

Line 299: App_Exception.Raise_Exception;

295: IF Get_Pk_For_Validation(
296: new_references.rating_scale_id) THEN
297: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: END IF;
301: Check_Uniqueness;
302: Check_Constraints;
303: ELSIF (p_action = 'UPDATE') THEN

Line 318: App_Exception.Raise_Exception;

314: IF Get_PK_For_Validation (
315: new_references.rating_scale_id) THEN
316: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: END IF;
320: Check_Uniqueness;
321: Check_Constraints;
322: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 409: app_exception.raise_exception;

405: end if;
406: else
407: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: end if;
411:
412: X_RATING_SCALE_ID := -1;
413: Before_DML(

Line 503: app_exception.raise_exception;

499: if (c1%notfound) then
500: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
501: IGS_GE_MSG_STACK.ADD;
502: close c1;
503: app_exception.raise_exception;
504: return;
505: end if;
506: close c1;
507: if ( ( tlinfo.RATING_SCALE_NAME = X_RATING_SCALE_NAME)

Line 516: app_exception.raise_exception;

512: null;
513: else
514: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
515: IGS_GE_MSG_STACK.ADD;
516: app_exception.raise_exception;
517: end if;
518: return;
519: end LOCK_ROW;
520: Procedure UPDATE_ROW (

Line 562: app_exception.raise_exception;

558: end if;
559: else
560: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
561: IGS_GE_MSG_STACK.ADD;
562: app_exception.raise_exception;
563: end if;
564: Before_DML(
565: p_action=>'UPDATE',
566: x_rowid=>X_ROWID,