[Home] [Help]
50: OPEN cur_old_ref_values;
51: FETCH cur_old_ref_values INTO old_references;
52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: igs_ge_msg_stack.add;
56: app_exception.raise_exception;
57: RETURN;
58: END IF;
110: new_references.us_version_number,
111: new_references.organization_unit
112: )
113: ) THEN
114: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
178: new_references.location_cd,
179: new_references.attendance_mode,
180: new_references.attendance_type
181: ) THEN
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: END IF;
186:
193: ELSIF NOT igs_en_unit_set_pkg.get_pk_for_validation(
194: new_references.unit_set_cd,
195: new_references.us_version_number
196: )THEN
197: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201:
210: new_references.us_version_number);
211: FETCH cur_unitset_check INTO l_c_var;
212: IF cur_unitset_check%NOTFOUND THEN
213: CLOSE cur_unitset_check;
214: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: CLOSE cur_unitset_check;
358: OPEN cur_rowid;
359: FETCH cur_rowid INTO lv_rowid;
360: IF (cur_rowid%FOUND) THEN
361: CLOSE cur_rowid;
362: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_COO_FK');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: RETURN;
366: END IF;
394: OPEN cur_rowid;
395: FETCH cur_rowid INTO lv_rowid;
396: IF (cur_rowid%FOUND) THEN
397: CLOSE cur_rowid;
398: fnd_message.set_name ('IGS', 'IGS_HE_HPOU_US_FK');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: RETURN;
402: END IF;
437: Open cur_rowid;
438: Fetch cur_rowid INTO lv_rowid;
439: IF (cur_rowid%FOUND) THEN
440: Close cur_rowid;
441: Fnd_Message.Set_Name ('IGS', 'IGS_HE_HPUD_US_FK');
442: IGS_GE_MSG_STACK.ADD;
443: App_Exception.Raise_Exception;
444: Return;
445: END IF;
510: IF ( get_pk_for_validation(
511: new_references.hesa_poous_ou_id
512: )
513: ) THEN
514: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518: check_uniqueness;
529: IF ( get_pk_for_validation (
530: new_references.hesa_poous_ou_id
531: )
532: ) THEN
533: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
534: igs_ge_msg_stack.add;
535: app_exception.raise_exception;
536: END IF;
537: check_uniqueness;
595: IF (x_last_update_login IS NULL) THEN
596: x_last_update_login := -1;
597: END IF;
598: ELSE
599: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
600: igs_ge_msg_stack.add;
601: app_exception.raise_exception;
602: END IF;
603:
724:
725: OPEN c1;
726: FETCH c1 INTO tlinfo;
727: IF (c1%notfound) THEN
728: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
729: igs_ge_msg_stack.add;
730: CLOSE c1;
731: app_exception.raise_exception;
732: RETURN;
746: AND ((tlinfo.proportion = x_proportion) OR ((tlinfo.proportion IS NULL) AND (X_proportion IS NULL)))
747: ) THEN
748: NULL;
749: ELSE
750: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754:
803: IF (x_last_update_login IS NULL) THEN
804: x_last_update_login := -1;
805: END IF;
806: ELSE
807: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
808: igs_ge_msg_stack.add;
809: app_exception.raise_exception;
810: END IF;
811: