[Home] [Help]
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;
56: Close cur_old_ref_values;
57:
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;
219:
220: END Check_Constraints;
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 ;
243:
244: PROCEDURE Check_Parent_Existance AS
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;
267:
268: END Check_Parent_Existance;
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;
427: Check_Parent_Existance;
428: Check_Uniqueness;
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;
448: Check_Uniqueness;
449: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
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:
519: Before_DML (
520: p_action => 'INSERT',
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;
654: close c1;
655:
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;
688: end LOCK_ROW;
689:
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:
734: Before_DML (
735: p_action => 'UPDATE',