DBA Data[Home] [Help]

APPS.IGS_FI_ELM_RANGE_H_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

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;
46: Close cur_old_ref_values;

Line 84: IGS_GE_MSG_STACK.ADD;

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;
88:

Line 127: IGS_GE_MSG_STACK.ADD;

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

Line 136: IGS_GE_MSG_STACK.ADD;

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

Line 145: IGS_GE_MSG_STACK.ADD;

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;
149:

Line 155: IGS_GE_MSG_STACK.ADD;

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;
159:

Line 165: IGS_GE_MSG_STACK.ADD;

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;
169:

Line 175: IGS_GE_MSG_STACK.ADD;

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;
179:

Line 185: IGS_GE_MSG_STACK.ADD;

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;
189: END Check_Constraints;

Line 209: IGS_GE_MSG_STACK.ADD;

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;
213: IF (((old_references.fee_type = new_references.fee_type) AND

Line 227: IGS_GE_MSG_STACK.ADD;

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;
231: END Check_Parent_Existance;

Line 353: IGS_GE_MSG_STACK.ADD;

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;
357: Check_Uniqueness;

Line 378: IGS_GE_MSG_STACK.ADD;

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;
382: Check_Uniqueness;

Line 433: IGS_GE_MSG_STACK.ADD;

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 (
437: p_action => 'INSERT',

Line 537: IGS_GE_MSG_STACK.ADD;

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;
541: close c1;

Line 560: IGS_GE_MSG_STACK.ADD;

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;
564: end LOCK_ROW;

Line 600: IGS_GE_MSG_STACK.ADD;

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 (
604: p_action => 'UPDATE',