DBA Data[Home] [Help]

APPS.IGS_FI_FEE_AS_RT_HT_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 111: IGS_GE_MSG_STACK.ADD;

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:

Line 120: IGS_GE_MSG_STACK.ADD;

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;
124: IF upper(Column_Name) = 'COURSE_CD' OR

Line 128: IGS_GE_MSG_STACK.ADD;

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;
132: IF upper(Column_Name) = 'LOCATION_CD' OR

Line 136: IGS_GE_MSG_STACK.ADD;

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:

Line 145: IGS_GE_MSG_STACK.ADD;

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:

Line 154: IGS_GE_MSG_STACK.ADD;

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

Line 169: IGS_GE_MSG_STACK.ADD;

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

Line 178: IGS_GE_MSG_STACK.ADD;

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

Line 229: IGS_GE_MSG_STACK.ADD;

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;
233: Close cur_rowid;

Line 291: IGS_GE_MSG_STACK.ADD;

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;
295: Check_Parent_Existance;

Line 308: IGS_GE_MSG_STACK.ADD;

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;
312: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 359: IGS_GE_MSG_STACK.ADD;

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

Line 469: IGS_GE_MSG_STACK.ADD;

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

Line 498: IGS_GE_MSG_STACK.ADD;

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

Line 539: IGS_GE_MSG_STACK.ADD;

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