[Home] [Help]
42: Open cur_old_ref_values;
43: Fetch cur_old_ref_values INTO old_references;
44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
100: END IF;
101:
102: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
103: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
104: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception ;
107: END IF;
108: END IF;
107: END IF;
108: END IF;
109: IF upper(column_name) = 'THE_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
110: IF new_references.THE_SEQUENCE_NUMBER < 1 OR new_references.THE_SEQUENCE_NUMBER > 999999 then
111: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception ;
114: END IF;
115: END IF;
115: END IF;
116:
117: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN
118: IF new_references.THESIS_EXAM_TYPE <> upper(NEW_REFERENCES.THESIS_EXAM_TYPE) then
119: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception ;
122: END IF;
123: END IF;
123: END IF;
124:
125: IF upper(column_name) = 'THESIS_PANEL_TYPE' OR COLUMN_NAME IS NULL THEN
126: IF new_references.THESIS_PANEL_TYPE <> upper(NEW_REFERENCES.THESIS_PANEL_TYPE) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131: END IF;
131: END IF;
132:
133: IF upper(column_name) = 'THESIS_RESULT_CD' OR COLUMN_NAME IS NULL THEN
134: IF new_references.THESIS_RESULT_CD <> upper(NEW_REFERENCES.THESIS_RESULT_CD) then
135: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception ;
138: END IF;
139: END IF;
230: new_references.the_sequence_number ,
231: new_references.creation_dt ,
232: new_references.hist_start_dt
233: ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: Check_Constraints;
246: new_references.the_sequence_number ,
247: new_references.creation_dt ,
248: new_references.hist_start_dt
249: ) THEN
250: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: Check_Constraints;
297: if X_LAST_UPDATE_LOGIN is NULL then
298: X_LAST_UPDATE_LOGIN := -1;
299: end if;
300: else
301: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
302: IGS_GE_MSG_STACK.ADD;
303: app_exception.raise_exception;
304: end if;
305:
407: open c1 ;
408: fetch c1 into tlinfo ;
409: if (c1%notfound) then
410: close c1;
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: app_exception.raise_exception;
413: return;
414: end if;
415: close c1;
433: AND (X_THESIS_RESULT_CD is null)))
434: ) then
435: null;
436: else
437: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
438: app_exception.raise_exception;
439: end if;
440: return;
441: end LOCK_ROW;
473: if X_LAST_UPDATE_LOGIN is NULL then
474: X_LAST_UPDATE_LOGIN := -1;
475: end if;
476: else
477: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
478: IGS_GE_MSG_STACK.ADD;
479: app_exception.raise_exception;
480: end if;
481: