[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;
77: -- Validate trigger can be defined.
78: IF IGS_FI_VAL_CTFT.finp_val_ctft_ins (
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;
87: IF p_inserting THEN
88: IF IGS_as_VAL_acot.crsp_val_cty_closed (
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;
116: new_references.fee_type,
117: new_references.course_type,
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;
155: IF upper(column_name)= 'COURSE_TYPE' OR
156: column_name is null THEN
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;
165: IF upper(column_name)= 'FEE_CAL_TYPE' OR
166: column_name is null THEN
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;
175: column_name is null THEN
176: IF new_references.fee_ci_sequence_number <1 OR
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;
194: ELSE
195: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
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:
217: new_references.fee_cal_type,
218: new_references.fee_ci_sequence_number,
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:
308: new_references.fee_type,
309: new_references.course_type,
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;
331: new_references.fee_type,
332: new_references.course_type,
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;
412: else
413: X_PROGRAM_UPDATE_DATE := SYSDATE;
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',
503: open c1;
504: fetch c1 into tlinfo;
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;
516: AND (X_LOGICAL_DELETE_DT is null)))
517: ) then
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;
557: if X_LAST_UPDATE_LOGIN is NULL then
558: X_LAST_UPDATE_LOGIN := -1;
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: