[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;
79: new_references.range_number ,
80: new_references.hist_start_dt ,
81: new_references.fee_cat
82: ) THEN
83: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
84: IGS_GE_MSG_STACK.ADD;
85: App_Exception.Raise_Exception;
86: END IF;
87: End Check_Uniqueness;
122: IF upper(column_name) = 'FEE_CAL_TYPE' OR
123: column_name is null Then
124: IF new_references.FEE_CAL_TYPE <>
125: UPPER(new_references.FEE_CAL_TYPE) Then
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131: IF upper(column_name) = 'S_CHG_METHOD_TYPE' OR
132: column_name is null Then
133: IF new_references.S_CHG_METHOD_TYPE <>
134: UPPER(new_references.S_CHG_METHOD_TYPE) 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: IF upper(column_name) = 'S_RELATION_TYPE' OR
141: column_name is null Then
142: IF new_references.S_RELATION_TYPE <>
143: UPPER(new_references.S_RELATION_TYPE) 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;
150: IF upper(column_name) = 'RANGE_NUMBER' OR
151: column_name is null Then
152: IF new_references.range_number < 1 OR
153: new_references.range_number > 999999 Then
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
160: IF upper(column_name) = 'UPPER_RANGE' OR
161: column_name is null Then
162: IF new_references.upper_range < 0 OR
163: new_references.upper_range > 9999.999 Then
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
170: IF upper(column_name) = 'LOWER_RANGE' OR
171: column_name is null Then
172: IF new_references.lower_range < 0 OR
173: new_references.lower_range > 9999.999 Then
174: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178: END IF;
180: IF upper(column_name) = 'FEE_CI_SEQUENCE_NUMBER' OR
181: column_name is null Then
182: IF new_references.fee_ci_sequence_number < 1 OR
183: new_references.fee_ci_sequence_number > 999999 Then
184: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;
188: END IF;
204: new_references.fee_cal_type,
205: new_references.fee_ci_sequence_number,
206: new_references.fee_type
207: ) THEN
208: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212: END IF;
222: new_references.fee_type,
223: new_references.fee_cal_type,
224: new_references.fee_ci_sequence_number
225: ) THEN
226: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230: END IF;
348: new_references.s_relation_type ,
349: new_references.range_number ,
350: new_references.hist_start_dt
351: ) THEN
352: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
353: IGS_GE_MSG_STACK.ADD;
354: App_Exception.Raise_Exception;
355: END IF;
356: Check_Constraints;
373: new_references.s_relation_type ,
374: new_references.range_number ,
375: new_references.hist_start_dt
376: ) THEN
377: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;
381: Check_Constraints;
428: if X_LAST_UPDATE_LOGIN is NULL then
429: X_LAST_UPDATE_LOGIN := -1;
430: end if;
431: else
432: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
433: IGS_GE_MSG_STACK.ADD;
434: app_exception.raise_exception;
435: end if;
436: Before_DML (
532: open c1;
533: fetch c1 into tlinfo;
534: if (c1%notfound) then
535: close c1;
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: IGS_GE_MSG_STACK.ADD;
538: app_exception.raise_exception;
539: return;
540: end if;
555: AND (X_S_CHG_METHOD_TYPE is null)))
556: ) then
557: null;
558: else
559: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
560: IGS_GE_MSG_STACK.ADD;
561: app_exception.raise_exception;
562: end if;
563: return;
595: if X_LAST_UPDATE_LOGIN is NULL then
596: X_LAST_UPDATE_LOGIN := -1;
597: end if;
598: else
599: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;
603: Before_DML (