47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
54: CLOSE cur_old_ref_values;
55:
96: new_references.assessment_type
97: ) THEN
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
103: IF (((old_references.unit_cd = new_references.unit_cd) AND
104: (old_references.version_number = new_references.version_number)) OR
110: new_references.version_number
111: ) THEN
112: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
113: igs_ge_msg_stack.add;
114: app_exception.raise_exception;
115: END IF;
116:
117: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND
118: (old_references.gs_version_number = new_references.gs_version_number)) OR
124: new_references.gs_version_number
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: END check_parent_existance;
132:
176: IF l_ass_count <> 0 THEN
177: CLOSE c_us_ass_item;
178: fnd_message.set_name ('IGS', 'IGS_AS_UNAS_AAGS_FK');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182: CLOSE c_us_ass_item;
183: -- checks for the assesment type is available at unit level or not
184: OPEN c_u_ass_item;
186: IF l_ass_count <> 0 THEN
187: CLOSE c_u_ass_item;
188: fnd_message.set_name ('IGS', 'IGS_AS_UAI_AAGS_FK');
189: igs_ge_msg_stack.add;
190: app_exception.raise_exception;
191: END IF;
192: CLOSE c_u_ass_item;
193: END check_child_existence;
194:
261: IF (cur_rowid%FOUND) THEN
262: CLOSE cur_rowid;
263: fnd_message.set_name ('IGS', 'IGS_AS_AAGS_ATYP_FK');
264: igs_ge_msg_stack.add;
265: app_exception.raise_exception;
266: RETURN;
267: END IF;
268: CLOSE cur_rowid;
269:
298: IF (cur_rowid%FOUND) THEN
299: CLOSE cur_rowid;
300: fnd_message.set_name ('IGS', 'IGS_AS_AAGS_PUV_FK');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: RETURN;
304: END IF;
305: CLOSE cur_rowid;
306:
335: IF (cur_rowid%FOUND) THEN
336: CLOSE cur_rowid;
337: fnd_message.set_name ('IGS', 'IGS_AS_AAGS_GS_FK');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: RETURN;
341: END IF;
342: CLOSE cur_rowid;
343:
399: )
400: ) THEN
401: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
402: igs_ge_msg_stack.add;
403: app_exception.raise_exception;
404: END IF;
405: check_parent_existance;
406: ELSIF (p_action = 'DELETE') THEN
407: check_child_existence;
419: )
420: ) THEN
421: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425: ELSIF (p_action = 'VALIDATE_DELETE') THEN
426: check_child_existence;
427: END IF;
479: END IF;
480: ELSE
481: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
482: igs_ge_msg_stack.add;
483: app_exception.raise_exception;
484: END IF;
485:
486: before_dml(
487: p_action => 'INSERT',
575: IF (c1%notfound) THEN
576: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
577: igs_ge_msg_stack.add;
578: CLOSE c1;
579: app_exception.raise_exception;
580: RETURN;
581: END IF;
582: CLOSE c1;
583:
588: NULL;
589: ELSE
590: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
591: igs_ge_msg_stack.add;
592: app_exception.raise_exception;
593: END IF;
594:
595: RETURN;
596:
638: END IF;
639: ELSE
640: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644:
645: before_dml(
646: p_action => 'UPDATE',