APPS.IGS_PS_UNIT_FLD_STDY_PKG dependencies on IGS_GE_MSG_STACK

Line 57: IGS_GE_MSG_STACK.ADD;

53: Fetch cur_old_ref_values INTO old_references;
54: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
55: Close cur_old_ref_values;
56: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
57: IGS_GE_MSG_STACK.ADD;
58: App_Exception.Raise_Exception;
59: Return;
60: END IF;
61: Close cur_old_ref_values;

Line 99: IGS_GE_MSG_STACK.ADD;

95: new_references.unit_code,
96: new_references.version_number
97: ) THEN
98: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: IGS_GE_MSG_STACK.ADD;
100: APP_EXCEPTION.RAISE_EXCEPTION;
101: END IF;
102: END Check_Uniqueness ;
103:

Line 127: IGS_GE_MSG_STACK.ADD;

123: new_references.unit_code,
124: new_references.version_number
125: ) THEN
126: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130:
131: END Check_Parent_Existance;

Line 235: IGS_GE_MSG_STACK.ADD;

231: Fetch cur_rowid INTO lv_rowid;
232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UFS_FOS_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;
239: Close cur_rowid;

Line 273: IGS_GE_MSG_STACK.ADD;

269: Fetch cur_rowid INTO lv_rowid;
270: IF (cur_rowid%FOUND) THEN
271: Close cur_rowid;
272: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UFS_UV_FK');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: Return;
276: END IF;
277: Close cur_rowid;

Line 325: IGS_GE_MSG_STACK.ADD;

321: -- Call all the procedures related to Before Insert.
322: IF Get_Pk_For_Validation(
323: new_references.unit_field_of_study_id) THEN
324: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: END IF;
328: Check_Uniqueness;
329: Check_Parent_Existance;

Line 342: IGS_GE_MSG_STACK.ADD;

338: -- Call all the procedures related to Before Insert.
339: IF Get_PK_For_Validation (
340: new_references.unit_field_of_study_id) THEN
341: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END IF;
345: Check_Uniqueness;
346: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 430: IGS_GE_MSG_STACK.ADD;

426: X_LAST_UPDATE_LOGIN := -1;
427: end if;
428: else
429: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
430: IGS_GE_MSG_STACK.ADD;
431: app_exception.raise_exception;
432: end if;
433: SELECT igs_ps_unit_fld_stdy_s.nextval
434: INTO x_unit_field_of_study_id

Line 499: IGS_GE_MSG_STACK.ADD;

495: open c1;
496: fetch c1 into tlinfo;
497: if (c1%notfound) then
498: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
499: IGS_GE_MSG_STACK.ADD;
500: close c1;
501: app_exception.raise_exception;
502: return;
503: end if;

Line 512: IGS_GE_MSG_STACK.ADD;

508: ) then
509: null;
510: else
511: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
512: IGS_GE_MSG_STACK.ADD;
513: app_exception.raise_exception;
514: end if;
515: return;
516: end LOCK_ROW;

Line 555: IGS_GE_MSG_STACK.ADD;

551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: else
554: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
555: IGS_GE_MSG_STACK.ADD;
556: app_exception.raise_exception;
557: end if;
558: Before_DML(
559: p_action=>'UPDATE',