37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;
45:
88: new_references.govt_field_of_study,
89: v_message_name) = FALSE THEN
90: FND_MESSAGE.SET_NAME('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END IF;
94: END IF;
95: -- Create history record.
96: IF p_updating THEN
154: new_references.govt_field_of_study
155: ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:
162: END Check_Parent_Existance;
203: IF (cur_rowid%FOUND) THEN
204: Close cur_rowid;
205: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FOS_GFOS_FK');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: Return;
209: END IF;
210: Close cur_rowid;
211:
251: new_references.field_of_study
252: ) THEN
253: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: Check_Constraints;
258: Check_Parent_Existance;
259: ELSIF (p_action = 'UPDATE') THEN
266: new_references.field_of_study
267: ) THEN
268: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: Check_Constraints;
273: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
274: Check_Constraints;
322: end if;
323: else
324: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
325: IGS_GE_MSG_STACK.ADD;
326: app_exception.raise_exception;
327: end if;
328:
329: Before_DML( p_action => 'INSERT',
330: x_rowid => X_ROWID,
402: if (c1%notfound) then
403: close c1;
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: IGS_GE_MSG_STACK.ADD;
406: app_exception.raise_exception;
407: return;
408: end if;
409: close c1;
410:
415: null;
416: else
417: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421: return;
422: end LOCK_ROW;
423:
449: end if;
450: else
451: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
452: IGS_GE_MSG_STACK.ADD;
453: app_exception.raise_exception;
454: end if;
455:
456: Before_DML( p_action => 'UPDATE',
457: x_rowid => X_ROWID,