48: OPEN cur_old_ref_values;
49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
102: new_references.building_id,
103: new_references.room_id
104: )
105: ) THEN
106: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
136:
137:
138: IF UPPER(Column_Name)='NUMBER_OF_STUDENTS' OR Column_Name IS NULL THEN
139: IF New_References.number_of_students < 0 OR New_References.number_of_students > 9999999999 THEN
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144: END IF;
144: END IF;
145:
146: IF UPPER(Column_Name)='HOURS_PER_STUDENT' OR Column_Name IS NULL THEN
147: IF New_References.hours_per_student < 0 OR New_References.hours_per_student > 999.99 THEN
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
152: END IF;
153:
154: IF UPPER(Column_Name)='HOURS_PER_FACULTY' OR Column_Name IS NULL THEN
155: IF New_References.hours_per_faculty < 0 OR New_References.hours_per_faculty > 999.99 THEN
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
187: ELSIF NOT igs_ad_location_pkg.get_pk_for_validation (
188: new_references.location_cd ,
189: 'N'
190: ) THEN
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195:
199: ELSIF NOT igs_ad_building_pkg.get_pk_for_validation (
200: new_references.building_id ,
201: 'N'
202: ) THEN
203: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
211: ELSIF NOT igs_ad_room_pkg.get_pk_for_validation (
212: new_references.room_id ,
213: 'N'
214: ) THEN
215: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: END IF;
219:
222: NULL;
223: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
224: new_references.uoo_id
225: ) THEN
226: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230:
237: IF (cur_rowid%FOUND) THEN
238: CLOSE cur_rowid;
239: ELSE
240: CLOSE cur_rowid;
241: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
349: OPEN cur_rowid;
350: FETCH cur_rowid INTO lv_rowid;
351: IF (cur_rowid%FOUND) THEN
352: CLOSE cur_rowid;
353: fnd_message.set_name ('IGS', 'IGS_PS_LOC_UUCL_FK1');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: RETURN;
357: END IF;
384: OPEN cur_rowid;
385: FETCH cur_rowid INTO lv_rowid;
386: IF (cur_rowid%FOUND) THEN
387: CLOSE cur_rowid;
388: fnd_message.set_name ('IGS', 'IGS_PS_BLD_UUCL_FK2');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: RETURN;
392: END IF;
419: OPEN cur_rowid;
420: FETCH cur_rowid INTO lv_rowid;
421: IF (cur_rowid%FOUND) THEN
422: CLOSE cur_rowid;
423: fnd_message.set_name ('IGS', 'IGS_PS_ROM_UUCL_FK3');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: RETURN;
427: END IF;
454: OPEN cur_rowid;
455: FETCH cur_rowid INTO lv_rowid;
456: IF (cur_rowid%FOUND) THEN
457: CLOSE cur_rowid;
458: fnd_message.set_name ('IGS', 'IGS_PS_UOO_UUCL_FK4');
459: igs_ge_msg_stack.add;
460: app_exception.raise_exception;
461: RETURN;
462: END IF;
489: OPEN cur_rowid;
490: FETCH cur_rowid INTO lv_rowid;
491: IF (cur_rowid%FOUND) THEN
492: CLOSE cur_rowid;
493: fnd_message.set_name ('IGS', 'IGS_PS_HZP_UUCL_FK5');
494: igs_ge_msg_stack.add;
495: app_exception.raise_exception;
496: RETURN;
497: END IF;
523: OPEN cur_rowid;
524: FETCH cur_rowid INTO lv_rowid;
525: IF (cur_rowid%FOUND) THEN
526: CLOSE cur_rowid;
527: fnd_message.set_name ('IGS', 'IGS_PS_USAT_UUCL_FK6');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: RETURN;
531: END IF;
589: IF ( get_pk_for_validation(
590: new_references.us_unscheduled_cl_id
591: )
592: ) THEN
593: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597: check_uniqueness;
607: IF ( get_pk_for_validation (
608: new_references.us_unscheduled_cl_id
609: )
610: ) THEN
611: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
612: igs_ge_msg_stack.add;
613: app_exception.raise_exception;
614: END IF;
615: check_uniqueness;
669: IF (x_last_update_login IS NULL) THEN
670: x_last_update_login := -1;
671: END IF;
672: ELSE
673: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677:
787:
788: OPEN c1;
789: FETCH c1 INTO tlinfo;
790: IF (c1%notfound) THEN
791: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
792: igs_ge_msg_stack.add;
793: CLOSE c1;
794: app_exception.raise_exception;
795: RETURN;
808: AND ((tlinfo.instructor_id = x_instructor_id) OR ((tlinfo.instructor_id IS NULL) AND (X_instructor_id IS NULL)))
809: ) THEN
810: NULL;
811: ELSE
812: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
813: igs_ge_msg_stack.add;
814: app_exception.raise_exception;
815: END IF;
816:
861: IF (x_last_update_login IS NULL) THEN
862: x_last_update_login := -1;
863: END IF;
864: ELSE
865: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
866: igs_ge_msg_stack.add;
867: app_exception.raise_exception;
868: END IF;
869: