[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;
104: IF upper(column_name)= 'COURSE_TYPE' OR
105: column_name is null THEN
106: IF new_references.course_type <> UPPER(new_references.course_type )
107: THEN
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
114: IF upper(column_name)= 'COURSE_TYPE_GROUP_CD' OR
115: column_name is null THEN
116: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd )
117: 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;
125: IF upper(column_name)= 'TAC_COURSE_LEVEL' OR
126: column_name is null THEN
127: IF new_references.tac_course_level <> UPPER(new_references.tac_course_level)
128: THEN
129: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
130: IGS_GE_MSG_STACK.ADD;
131: App_Exception.Raise_Exception;
132: END IF;
133: END IF;
135: IF upper(column_name)= 'RESEARCH_TYPE_IND' OR
136: column_name is null THEN
137: IF new_references.research_type_ind NOT IN ( 'Y' , 'N' )
138: THEN
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144: IF upper(column_name)= 'CLOSED_IND' OR
145: column_name is null THEN
146: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
147: THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153: IF upper(column_name)= 'AWARD_COURSE_IND' OR
154: column_name is null THEN
155: IF new_references.award_course_ind NOT IN ( 'Y' , 'N' )
156: THEN
157: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;
162: IF upper(column_name) = 'PRIMARY_AUTO_SELECT' OR
163: column_name is null THEN
164: IF new_references.primary_auto_select NOT IN ( 'Y','N' )
165: THEN
166: Fnd_Message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170: END IF;
253: IF Get_PK_For_Validation(
254: new_references.course_type,
255: new_references.hist_start_dt
256: ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
270: IF Get_PK_For_Validation(
271: new_references.course_type,
272: new_references.hist_start_dt
273: ) THEN
274: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: Check_Constraints;
333: if X_LAST_UPDATE_LOGIN is NULL then
334: X_LAST_UPDATE_LOGIN := -1;
335: end if;
336: else
337: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
338: IGS_GE_MSG_STACK.ADD;
339: app_exception.raise_exception;
340: end if;
341: Before_DML(
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: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: return;
461: end if;
492: AND (X_FIN_AID_PROGRAM_TYPE is null )))
493: ) then
494: null;
495: else
496: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
497: IGS_GE_MSG_STACK.ADD;
498: app_exception.raise_exception;
499: end if;
500: return;
534: if X_LAST_UPDATE_LOGIN is NULL then
535: X_LAST_UPDATE_LOGIN := -1;
536: end if;
537: else
538: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
539: IGS_GE_MSG_STACK.ADD;
540: app_exception.raise_exception;
541: end if;
542: Before_DML( p_action => 'UPDATE',