[Home] [Help]
45: Open cur_old_ref_values;
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;
105: END IF;
106:
107: IF upper(Column_name) = 'THESIS_RESULT_CD' OR column_name is null then
108: IF new_references.thesis_result_cd <> UPPER(new_references.thesis_result_cd ) 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:
115: IF upper(Column_name) = 'ANONYMITY_IND' OR column_name is null then
116: IF new_references.anonymity_ind <> UPPER(new_references.anonymity_ind ) OR
117: new_references.anonymity_ind NOT IN ( 'Y' , 'N' ) then
118: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
122: END IF;
123:
124: IF upper(Column_name) = 'PANEL_MEMBER_TYPE' OR column_name is null then
125: IF new_references.panel_member_type <> UPPER(new_references.panel_member_type ) then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
130: END IF;
131:
132: IF upper(Column_name) = 'THE_SEQUENCE_NUMBER' OR column_name is null then
133: IF new_references.the_sequence_number < 1 OR new_references.the_sequence_number > 999999 THEN
134: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
138: END IF;
139:
140: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR column_name is null then
141: IF new_references.ca_sequence_number < 1 OR new_references.ca_sequence_number > 999999 THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;
249: new_references.creation_dt ,
250: new_references.person_id,
251: new_references.hist_start_dt
252: )THEN
253: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: Check_Constraints;
266: new_references.creation_dt ,
267: new_references.person_id,
268: new_references.hist_start_dt
269: )THEN
270: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: Check_Constraints;
323: if X_LAST_UPDATE_LOGIN is NULL then
324: X_LAST_UPDATE_LOGIN := -1;
325: end if;
326: else
327: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331:
453: open c1;
454: fetch c1 into tlinfo;
455: if (c1%notfound) then
456: close c1;
457: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
458: app_exception.raise_exception;
459: return;
460: end if;
461: close c1;
488: AND (X_RECOMMENDATION_SUMMARY is null)))
489: ) then
490: null;
491: else
492: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
493: app_exception.raise_exception;
494: end if;
495: return;
496: end LOCK_ROW;
532: if X_LAST_UPDATE_LOGIN is NULL then
533: X_LAST_UPDATE_LOGIN := -1;
534: end if;
535: else
536: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
537: IGS_GE_MSG_STACK.ADD;
538: app_exception.raise_exception;
539: end if;
540: