APPS.IGS_AD_RATING_SCALES_PKG dependencies on IGS_GE_MSG_STACK

Line 51: IGS_GE_MSG_STACK.ADD;

47: Fetch cur_old_ref_values INTO old_references;
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;

Line 110: IGS_GE_MSG_STACK.ADD;

106: IF Upper(Column_Name) = 'CLOSED_IND' OR
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:

Line 120: IGS_GE_MSG_STACK.ADD;

116: IF Upper(Column_Name) = 'DFLT' OR
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:

Line 145: IGS_GE_MSG_STACK.ADD;

141: IF Get_Uk_For_Validation (
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

Line 298: IGS_GE_MSG_STACK.ADD;

294: Null;
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;

Line 317: IGS_GE_MSG_STACK.ADD;

313: -- Call all the procedures related to Before Insert.
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;

Line 408: IGS_GE_MSG_STACK.ADD;

404: X_LAST_UPDATE_LOGIN := -1;
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;

Line 501: IGS_GE_MSG_STACK.ADD;

497: open c1;
498: fetch c1 into tlinfo;
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;

Line 515: IGS_GE_MSG_STACK.ADD;

511: ) then
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;

Line 561: IGS_GE_MSG_STACK.ADD;

557: X_LAST_UPDATE_LOGIN := -1;
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',