[Home] [Help]
37: Open cur_old_ref_values;
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;
106:
107: IF upper(Column_Name) = 'ATTENDANCE_MODE' OR
108: column_name is NULL THEN
109: IF new_references.attendance_mode <> UPPER(new_references.attendance_mode) 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;
115:
116: IF upper(Column_Name) = 'ATTENDANCE_TYPE' OR
117: column_name is NULL THEN
118: IF new_references.attendance_type <> UPPER(new_references.attendance_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: IF upper(Column_Name) = 'COURSE_CD' OR
125: column_name is NULL THEN
126: IF new_references.course_cd <> UPPER(new_references.course_cd) 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: IF upper(Column_Name) = 'LOCATION_CD' OR
133: column_name is NULL THEN
134: IF new_references.location_cd <> UPPER(new_references.location_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;
140:
141: IF upper(Column_Name) = 'LOWER_NRML_RATE_OVRD_IND' OR
142: column_name is NULL THEN
143: IF new_references.lower_nrml_rate_ovrd_ind <> 'Y' AND new_references.lower_nrml_rate_ovrd_ind <> 'N'THEN
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: IF upper(Column_Name) = 'CHG_RATE' OR
151: column_name is NULL THEN
152: IF new_references.chg_rate < 0 OR new_references.chg_rate > 99999.99 THEN
153: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
164: IF (((old_references.fee_type = new_references.fee_type)) OR
165: ((new_references.fee_type IS NULL))) THEN
166: NULL;
167: ELSIF NOT IGS_FI_FEE_TYPE_PKG.Get_PK_For_Validation ( new_references.fee_type ) THEN
168: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172:
173: IF (((old_references.person_id = new_references.person_id)) OR
174: ((new_references.person_id IS NULL))) THEN
175: NULL;
176: ELSIF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation ( new_references.person_id ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181:
224: Open cur_rowid;
225: Fetch cur_rowid INTO lv_rowid;
226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_FI_CFARH_PE_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;
286: new_references.course_cd,
287: new_references.fee_type,
288: new_references.start_dt,
289: new_references.hist_start_dt ) THEN
290: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294: Check_Constraints;
303: new_references.course_cd,
304: new_references.fee_type,
305: new_references.start_dt,
306: new_references.hist_start_dt ) THEN
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: Check_Constraints;
354: if X_LAST_UPDATE_LOGIN is NULL then
355: X_LAST_UPDATE_LOGIN := -1;
356: end if;
357: else
358: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362: Before_DML(
464: open c1;
465: fetch c1 into tlinfo;
466: if (c1%notfound) then
467: close c1;
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: IGS_GE_MSG_STACK.ADD;
470: app_exception.raise_exception;
471: return;
472: end if;
493: AND (X_LOWER_NRML_RATE_OVRD_IND is null)))
494: ) then
495: null;
496: else
497: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
498: IGS_GE_MSG_STACK.ADD;
499: app_exception.raise_exception;
500: end if;
501: 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(