[Home] [Help]
49: OPEN cur_old_ref_values;
50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
103: new_references.org_unit_cd,
104: new_references.incomplete_grade
105: )
106: ) THEN
107: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
135: new_references.grading_schema_cd,
136: new_references.version_number,
137: new_references.default_grade
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:
152: new_references.grading_schema_cd,
153: new_references.version_number,
154: new_references.incomplete_grade
155: ) THEN
156: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
163: NULL;
164: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
165: new_references.comp_after_dt_alias
166: ) THEN
167: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171:
177: ELSIF NOT igs_as_grd_schema_pkg.get_pk_for_validation (
178: new_references.grading_schema_cd,
179: new_references.version_number
180: ) THEN
181: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: END IF;
185:
293: OPEN cur_rowid;
294: FETCH cur_rowid INTO lv_rowid;
295: IF (cur_rowid%FOUND) THEN
296: CLOSE cur_rowid;
297: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_CSG_FK');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: RETURN;
301: END IF;
328: OPEN cur_rowid;
329: FETCH cur_rowid INTO lv_rowid;
330: IF (cur_rowid%FOUND) THEN
331: CLOSE cur_rowid;
332: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_DA_FK');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: RETURN;
336: END IF;
365: OPEN cur_rowid;
366: FETCH cur_rowid INTO lv_rowid;
367: IF (cur_rowid%FOUND) THEN
368: CLOSE cur_rowid;
369: fnd_message.set_name ('IGS', 'IGS_AS_IGCP_GS_FK');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: RETURN;
373: END IF;
434: IF ( get_pk_for_validation(
435: new_references.inc_grd_cprof_id
436: )
437: ) THEN
438: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442: check_uniqueness;
450: IF ( get_pk_for_validation (
451: new_references.inc_grd_cprof_id
452: )
453: ) THEN
454: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458: check_uniqueness;
511: IF (x_last_update_login IS NULL) THEN
512: x_last_update_login := -1;
513: END IF;
514: ELSE
515: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:
634:
635: OPEN c1;
636: FETCH c1 INTO tlinfo;
637: IF (c1%notfound) THEN
638: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
639: igs_ge_msg_stack.add;
640: CLOSE c1;
641: app_exception.raise_exception;
642: RETURN;
656: AND (tlinfo.instructor_update_ind = x_instructor_update_ind)
657: ) THEN
658: NULL;
659: ELSE
660: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
661: igs_ge_msg_stack.add;
662: app_exception.raise_exception;
663: END IF;
664:
710: IF (x_last_update_login IS NULL) THEN
711: x_last_update_login := -1;
712: END IF;
713: ELSE
714: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718: