[Home] [Help]
33: Open cur_old_ref_values;
34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
36: Close cur_old_ref_values;
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: App_Exception.Raise_Exception;
40: Return;
41: END IF;
128: FOR l_c_fci_lci IN c_fci_lci(new_references.sup_cal_type,
129: new_references.sup_ci_sequence_number,
130: new_references.sub_cal_type,
131: new_references.sub_ci_sequence_number) LOOP
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_FCI_LCI_ONE_REL');
133: IGS_GE_MSG_STACK.ADD;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135: END LOOP;
136: END IF;
176: new_references.sup_cal_type,
177: new_references.sup_ci_sequence_number,
178: v_message_name) = FALSE
179: THEN
180: Fnd_Message.Set_Name('IGS',v_message_name);
181: IGS_GE_MSG_STACK.ADD;
182: APP_EXCEPTION.RAISE_EXCEPTION;
183: END IF;
184: END IF;
237:
238: IF upper(Column_Name) = 'LOAD_RESEARCH_PERCENTAGE' OR
239: column_name is NULL THEN
240: IF new_references.load_research_percentage < 000.01 OR new_references.load_research_percentage > 100.00 THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
245: END IF;
246: IF upper(Column_Name) = 'SUB_CAL_TYPE' OR
247: column_name is NULL THEN
248: IF new_references.sub_cal_type <> UPPER(new_references.sub_cal_type) THEN
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
253: END IF;
254: IF upper(Column_Name) = 'SUP_CAL_TYPE' OR
255: column_name is NULL THEN
256: IF new_references.sup_cal_type <> UPPER(new_references.sup_cal_type) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
272: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
273: new_references.sub_cal_type,
274: new_references.sub_ci_sequence_number
275: ) THEN
276: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
277: IGS_GE_MSG_STACK.ADD;
278: App_Exception.Raise_Exception;
279: END IF;
280:
286: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
287: new_references.sup_cal_type,
288: new_references.sup_ci_sequence_number
289: ) THEN
290: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
291: IGS_GE_MSG_STACK.ADD;
292: App_Exception.Raise_Exception;
293: END IF;
294:
364: Open cur_rowid;
365: Fetch cur_rowid INTO lv_rowid;
366: IF (cur_rowid%FOUND) THEN
367: Close cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_CA_CIR_CI_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: Return;
372: END IF;
421: new_references.sub_cal_type,
422: new_references.sub_ci_sequence_number,
423: new_references.sup_cal_type,
424: new_references.sup_ci_sequence_number ) THEN
425: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: BeforeRowInsertUpdateDelete(p_inserting => TRUE);
445: new_references.sub_cal_type,
446: new_references.sub_ci_sequence_number,
447: new_references.sup_cal_type,
448: new_references.sup_ci_sequence_number ) THEN
449: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453: Check_Constraints;
455: Check_Constraints;
456: ELSIF (p_action = 'VALIDATE_DELETE') THEN
457: -- Stop delete if SUP-CAL = Academic and SUB-CAL = Admission and both calendars have active status.
458: IF Check_acad_adm_cal_rel (p_rowid => x_rowid) THEN
459: Fnd_Message.Set_Name ('IGS', 'IGS_CA_REL_DEL_NOT');
460: IGS_GE_MSG_STACK.ADD;
461: App_Exception.Raise_Exception;
462: END IF;
463: BeforeRowInsertUpdateDelete(p_deleting => TRUE);
517: if X_LAST_UPDATE_LOGIN is NULL then
518: X_LAST_UPDATE_LOGIN := -1;
519: end if;
520: else
521: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
522: IGS_GE_MSG_STACK.ADD;
523: app_exception.raise_exception;
524: end if;
525: Before_DML (
592: open c1;
593: fetch c1 into tlinfo;
594: if (c1%notfound) then
595: close c1;
596: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: return;
600: end if;
605: AND (X_LOAD_RESEARCH_PERCENTAGE is null)))
606: ) then
607: null;
608: else
609: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
610: IGS_GE_MSG_STACK.ADD;
611: app_exception.raise_exception;
612: end if;
613: return;
639: if X_LAST_UPDATE_LOGIN is NULL then
640: X_LAST_UPDATE_LOGIN := -1;
641: end if;
642: else
643: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
644: IGS_GE_MSG_STACK.ADD;
645: app_exception.raise_exception;
646: end if;
647: Before_DML (