APPS.IGS_AD_RS_VALUES_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 104: IGS_GE_MSG_STACK.ADD;

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

Line 130: IGS_GE_MSG_STACK.ADD;

126: new_references.rating_scale_id
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

Line 155: IGS_GE_MSG_STACK.ADD;

151: ELSIF NOT Igs_Ad_Rating_Scales_Pkg.Get_PK_For_Validation (
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;

Line 288: IGS_GE_MSG_STACK.ADD;

284: Fetch cur_rowid INTO lv_rowid;
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;

Line 344: IGS_GE_MSG_STACK.ADD;

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

Line 365: IGS_GE_MSG_STACK.ADD;

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

Line 453: IGS_GE_MSG_STACK.ADD;

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

Line 538: IGS_GE_MSG_STACK.ADD;

534: open c1;
535: fetch c1 into tlinfo;
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;

Line 552: IGS_GE_MSG_STACK.ADD;

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

Line 596: IGS_GE_MSG_STACK.ADD;

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