[Home] [Help]
47: Open cur_old_ref_values;
48: Fetch cur_old_ref_values INTO old_references;
49: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
50: Close cur_old_ref_values;
51: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
129:
130: IF upper(column_name) = 'ATTENDANCE_MODE' OR
131: column_name is null Then
132: IF ( new_references.attendance_mode <> UPPER(new_references.attendance_mode) ) Then
133: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
140: column_name is null Then
141: IF ( new_references.attendance_type <> UPPER(new_references.attendance_type) ) 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;
147:
148: IF upper(column_name) = 'CAL_TYPE' OR
149: column_name is null Then
150: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156:
157: IF upper(column_name) = 'COURSE_CD' OR
158: column_name is null Then
159: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
160: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: END IF;
165:
166: IF upper(column_name) = 'FEE_CAL_TYPE' OR
167: column_name is null Then
168: IF ( new_references.fee_cal_type <> UPPER(new_references.fee_cal_type) ) Then
169: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: IF upper(column_name) = 'LOCATION_CD' OR
176: column_name is null Then
177: IF ( new_references.location_cd <> UPPER(new_references.location_cd) ) Then
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
183:
184: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR
185: column_name is null Then
186: IF ( new_references.fee_ci_sequence_number < 1 OR new_references.fee_ci_sequence_number > 999999 ) Then
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
193: IF upper(column_name) = 'SEQUENCE_NUMBER' OR
194: column_name is null Then
195: IF ( new_references.sequence_number < 1 OR new_references.sequence_number > 999999 ) Then
196: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
197: IGS_GE_MSG_STACK.ADD;
198: App_Exception.Raise_Exception;
199: END IF;
200: END IF;
201:
202: IF upper(column_name) = 'VERSION_NUMBER' OR
203: column_name is null Then
204: IF ( new_references.version_number < 1 OR new_references.version_number > 999 ) Then
205: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
206: IGS_GE_MSG_STACK.ADD;
207: App_Exception.Raise_Exception;
208: END IF;
209: END IF;
210:
211: IF upper(column_name) = 'FEE_TRIGGER_GROUP_NUMBER' OR
212: column_name is null Then
213: IF ( new_references.fee_trigger_group_number < 1 OR new_references.fee_trigger_group_number > 999999 ) Then
214: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
234: new_references.ATTENDANCE_MODE,
235: new_references.ATTENDANCE_TYPE,
236: new_references.CREATE_DT,
237: new_references.hist_start_dt) THEN
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242: END Check_Uniqueness ;
258: new_references.fee_cat,
259: new_references.fee_cal_type,
260: new_references.fee_ci_sequence_number,
261: new_references.fee_type ) THEN
262: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: END IF;
418: new_references.fee_type,
419: new_references.course_cd,
420: new_references.sequence_number,
421: new_references.hist_start_dt) THEN
422: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
423: IGS_GE_MSG_STACK.ADD;
424: App_Exception.Raise_Exception;
425: END IF;
426: Check_Constraints;
439: new_references.fee_type,
440: new_references.course_cd,
441: new_references.sequence_number,
442: new_references.hist_start_dt) THEN
443: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
444: IGS_GE_MSG_STACK.ADD;
445: App_Exception.Raise_Exception;
446: END IF;
447: Check_Constraints;
510: if X_LAST_UPDATE_LOGIN is NULL then
511: X_LAST_UPDATE_LOGIN := -1;
512: end if;
513: else
514: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
515: IGS_GE_MSG_STACK.ADD;
516: app_exception.raise_exception;
517: end if;
518:
645: open c1;
646: fetch c1 into tlinfo;
647: if (c1%notfound) then
648: close c1;
649: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
650: IGS_GE_MSG_STACK.ADD;
651: app_exception.raise_exception;
652: return;
653: end if;
679:
680: ) then
681: null;
682: else
683: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
684: IGS_GE_MSG_STACK.ADD;
685: app_exception.raise_exception;
686: end if;
687: return;
725: if X_LAST_UPDATE_LOGIN is NULL then
726: X_LAST_UPDATE_LOGIN := -1;
727: end if;
728: else
729: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
730: IGS_GE_MSG_STACK.ADD;
731: app_exception.raise_exception;
732: end if;
733: