[Home] [Help]
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;
47:
79: new_references.fee_type,
80: v_message_name) = FALSE THEN
81: Fnd_Message.Set_Name('IGS',v_message_name);
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86: -- Validate IGS_PS_COURSE Type not closed.
87: IF p_inserting THEN
89: new_references.course_type,
90: v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS',v_message_name);
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception;
94: END IF;
95: END IF;
96:
97: END BeforeRowInsertUpdateDelete1;
118: new_references.create_dt,
119: v_message_name) = FALSE THEN
120: Fnd_Message.Set_Name('IGS',v_message_name);
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: --
126: END IF;
157: IF new_references.course_type <> UPPER(new_references.course_type )
158: THEN
159: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164:
165: IF upper(column_name)= 'FEE_CAL_TYPE' OR
167: IF new_references.fee_cal_type <> UPPER(new_references.fee_cal_type )
168: 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: IF upper(column_name)= 'FEE_CI_SEQUENCE_NUMBER' OR
175: column_name is null THEN
177: new_references.fee_ci_sequence_number > 999999
178: THEN
179: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184:
185: END Check_Constraints;
196: new_references.course_type
197: )THEN
198: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;
202:
203: END IF;
204:
219: new_references.fee_type
220: )THEN
221: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
222: IGS_GE_MSG_STACK.ADD;
223: App_Exception.Raise_Exception;
224: END IF;
225:
226: END IF;
227:
310: new_references.create_dt
311: ) THEN
312: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
313: IGS_GE_MSG_STACK.ADD;
314: App_Exception.Raise_Exception;
315: END IF;
316: Check_Constraints;
317: Check_Parent_Existance;
318: ELSIF (p_action = 'UPDATE') THEN
333: new_references.create_dt
334: ) THEN
335: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339: Check_Constraints;
340: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
341: Check_Constraints;
414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420: Before_DML( p_action => 'INSERT',
421: x_rowid => X_ROWID,
422: x_fee_cat => X_FEE_CAT,
505: if (c1%notfound) then
506: close c1;
507: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: return;
511: end if;
512: close c1;
513:
518: null;
519: else
520: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
521: IGS_GE_MSG_STACK.ADD;
522: app_exception.raise_exception;
523: end if;
524: return;
525: end LOCK_ROW;
526:
559: end if;
560: else
561: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
562: IGS_GE_MSG_STACK.ADD;
563: app_exception.raise_exception;
564: end if;
565:
566: Before_DML( p_action => 'UPDATE',
567: x_rowid => X_ROWID,