[Home] [Help]
38: Open cur_old_ref_values;
39: Fetch cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: Close cur_old_ref_values;
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Return;
46: END IF;
108: IF IGS_PS_VAL_CRS.crsp_val_iud_crv_dtl (
109: v_course_cd,
110: v_version_number,
111: v_message_name) = FALSE THEN
112: Fnd_Message.Set_Name('IGS',v_message_name);
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116:
142:
143: IF upper(column_name) = 'ATTENDANCE_MODE' OR
144: column_name is null Then
145: IF ( new_references.attendance_mode <> UPPER(new_references.attendance_mode) ) Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
153: column_name is null Then
154: IF ( new_references.attendance_type <> UPPER(new_references.attendance_type) ) Then
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:
161: IF upper(column_name) = 'CAL_TYPE' OR
162: column_name is null Then
163: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) 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:
170: IF upper(column_name) = 'COURSE_CD' OR
171: column_name is null Then
172: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
173: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:
179: IF upper(column_name) = 'LOCATION_CD' OR
180: column_name is null Then
181: IF ( new_references.location_cd <> UPPER(new_references.location_cd) ) Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187:
188: IF upper(column_name) = 'CRS_NOTE_TYPE' OR
189: column_name is null Then
190: IF ( new_references.crs_note_type <> UPPER(new_references.crs_note_type) ) Then
191: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
205: ELSE
206: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
207: new_references.crs_note_type
208: ) THEN
209: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: END IF;
233: new_references.location_cd,
234: new_references.attendance_mode,
235: new_references.attendance_type
236: ) THEN
237: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
246: ELSE
247: IF NOT IGS_PS_OFR_OPT_PKG.Get_UK_For_Validation (
248: new_references.coo_id
249: ) THEN
250: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: END IF;
259: ELSE
260: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
261: new_references.reference_number
262: ) THEN
263: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;
323: Open cur_rowid;
324: Fetch cur_rowid INTO lv_rowid;
325: IF (cur_rowid%FOUND) THEN
326: Close cur_rowid;
327: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_CNT_FK');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: Return;
331: END IF;
359: Open cur_rowid;
360: Fetch cur_rowid INTO lv_rowid;
361: IF (cur_rowid%FOUND) THEN
362: Close cur_rowid;
363: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_COO_FK');
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: Return;
367: END IF;
385: Open cur_rowid;
386: Fetch cur_rowid INTO lv_rowid;
387: IF (cur_rowid%FOUND) THEN
388: Close cur_rowid;
389: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_COO_FK');
390: IGS_GE_MSG_STACK.ADD;
391: App_Exception.Raise_Exception;
392: Return;
393: END IF;
411: Open cur_rowid;
412: Fetch cur_rowid INTO lv_rowid;
413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_NOTE_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
470: new_references.location_cd,
471: new_references.attendance_mode,
472: new_references.attendance_type,
473: new_references.reference_number ) THEN
474: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
475: IGS_GE_MSG_STACK.ADD;
476: App_Exception.Raise_Exception;
477: END IF;
478: Check_Constraints;
493: new_references.location_cd,
494: new_references.attendance_mode,
495: new_references.attendance_type,
496: new_references.reference_number ) THEN
497: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
498: IGS_GE_MSG_STACK.ADD;
499: App_Exception.Raise_Exception;
500: END IF;
501: Check_Constraints;
553: if X_LAST_UPDATE_LOGIN is NULL then
554: X_LAST_UPDATE_LOGIN := -1;
555: end if;
556: else
557: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
558: IGS_GE_MSG_STACK.ADD;
559: app_exception.raise_exception;
560: end if;
561: Before_DML (
646: open c1;
647: fetch c1 into tlinfo;
648: if (c1%notfound) then
649: close c1;
650: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
651: IGS_GE_MSG_STACK.ADD;
652: app_exception.raise_exception;
653: return;
654: end if;
658: AND (tlinfo.CRS_NOTE_TYPE = X_CRS_NOTE_TYPE)
659: ) then
660: null;
661: else
662: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
663: IGS_GE_MSG_STACK.ADD;
664: app_exception.raise_exception;
665: end if;
666: return;
696: if X_LAST_UPDATE_LOGIN is NULL then
697: X_LAST_UPDATE_LOGIN := -1;
698: end if;
699: else
700: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
701: IGS_GE_MSG_STACK.ADD;
702: app_exception.raise_exception;
703: end if;
704: Before_DML (