APPS.IGS_PS_UNT_PRV_GRADE_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

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

Line 123: IGS_GE_MSG_STACK.ADD;

119: ,new_references.grading_schema_value
120: ,new_references.grading_schema_version_number
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;
127: PROCEDURE Check_Parent_Existance AS

Line 154: IGS_GE_MSG_STACK.ADD;

150: new_references.grading_schema_version_number,
151: new_references.grading_schema_value
152: ) THEN
153: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157:
158: IF (((old_references.unit_code = new_references.unit_code) AND

Line 168: IGS_GE_MSG_STACK.ADD;

164: new_references.unit_code,
165: new_references.unit_version_number
166: ) THEN
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171:
172: END Check_Parent_Existance;

Line 286: IGS_GE_MSG_STACK.ADD;

282: Fetch cur_rowid INTO lv_rowid;
283: IF (cur_rowid%FOUND) THEN
284: Close cur_rowid;
285: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UPG_GSG_FK');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: Return;
289: END IF;
290: Close cur_rowid;

Line 325: IGS_GE_MSG_STACK.ADD;

321: Fetch cur_rowid INTO lv_rowid;
322: IF (cur_rowid%FOUND) THEN
323: Close cur_rowid;
324: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UPG_UV_FK');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: Return;
328: END IF;
329: Close cur_rowid;

Line 383: IGS_GE_MSG_STACK.ADD;

379: Null;
380: IF Get_Pk_For_Validation(
381: new_references.unit_prev_grade_id) THEN
382: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: IGS_GE_MSG_STACK.ADD;
384: App_Exception.Raise_Exception;
385: END IF;
386: Check_Uniqueness;
387: Check_Constraints;

Line 403: IGS_GE_MSG_STACK.ADD;

399: -- Call all the procedures related to Before Insert.
400: IF Get_PK_For_Validation (
401: new_references.unit_prev_grade_id) THEN
402: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406: Check_Uniqueness;
407: Check_Constraints;

Line 492: IGS_GE_MSG_STACK.ADD;

488: X_LAST_UPDATE_LOGIN := -1;
489: end if;
490: else
491: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
492: IGS_GE_MSG_STACK.ADD;
493: app_exception.raise_exception;
494: end if;
495: select igs_ps_unt_prv_grade_s.nextval
496: into x_unit_prev_grade_id

Line 582: IGS_GE_MSG_STACK.ADD;

578: open c1;
579: fetch c1 into tlinfo;
580: if (c1%notfound) then
581: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
582: IGS_GE_MSG_STACK.ADD;
583: close c1;
584: app_exception.raise_exception;
585: return;
586: end if;

Line 597: IGS_GE_MSG_STACK.ADD;

593: ) then
594: null;
595: else
596: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: end if;
600: return;
601: end LOCK_ROW;

Line 642: IGS_GE_MSG_STACK.ADD;

638: X_LAST_UPDATE_LOGIN := -1;
639: end if;
640: else
641: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
642: IGS_GE_MSG_STACK.ADD;
643: app_exception.raise_exception;
644: end if;
645: Before_DML(
646: p_action=>'UPDATE',