[Home] [Help]
38: Open cur_old_ref_values;
39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
88:
89: IF upper(column_name) = 'MAJOR_FIELD_IND' OR
90: column_name is null Then
91: IF ( new_references.major_field_ind NOT IN ( 'Y' , 'N' ) ) Then
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98: IF upper(column_name) = 'COURSE_CD' OR
99: column_name is null Then
100: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107: IF upper(column_name) = 'FIELD_OF_STUDY' OR
108: column_name is null Then
109: IF ( new_references.field_of_study <> UPPER(new_references.field_of_study) ) Then
110: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
127: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
128: new_references.course_cd,
129: new_references.version_number
130: ) THEN
131: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
140: ELSE
141: IF NOT IGS_PS_FLD_OF_STUDY_PKG.Get_PK_For_Validation (
142: new_references.field_of_study
143: ) THEN
144: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
200: Open cur_rowid;
201: Fetch cur_rowid INTO lv_rowid;
202: IF (cur_rowid%FOUND) THEN
203: Close cur_rowid;
204: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CFOSH_CV_FK');
205: IGS_GE_MSG_STACK.ADD;
206: App_Exception.Raise_Exception;
207: Return;
208: END IF;
255: new_references.course_cd,
256: new_references.version_number,
257: new_references.field_of_study ,
258: new_references.hist_start_dt) THEN
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: Check_Constraints;
274: new_references.course_cd,
275: new_references.version_number,
276: new_references.field_of_study ,
277: new_references.hist_start_dt) THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints;
332: if X_LAST_UPDATE_LOGIN is NULL then
333: X_LAST_UPDATE_LOGIN := -1;
334: end if;
335: else
336: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: end if;
340: Before_DML (
428: open c1;
429: fetch c1 into tlinfo;
430: if (c1%notfound) then
431: close c1;
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: return;
436: end if;
446: AND (X_MAJOR_FIELD_IND is null)))
447: ) then
448: null;
449: else
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: IGS_GE_MSG_STACK.ADD;
452: app_exception.raise_exception;
453: end if;
454: return;
484: if X_LAST_UPDATE_LOGIN is NULL then
485: X_LAST_UPDATE_LOGIN := -1;
486: end if;
487: else
488: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
489: IGS_GE_MSG_STACK.ADD;
490: app_exception.raise_exception;
491: end if;
492: Before_DML (