79: OPEN cur_old_ref_values;
80: FETCH cur_old_ref_values INTO old_references;
81: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
82: CLOSE cur_old_ref_values;
83: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
84: igs_ge_msg_stack.add;
85: app_exception.raise_exception;
86: RETURN;
87: END IF;
267: NULL;
268: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
269: new_references.person_id
270: ) THEN
271: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: END IF;
275:
429: IF ( get_pk_for_validation(
430: new_references.ev_form_id
431: )
432: ) THEN
433: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437: check_parent_existance;
446: IF ( get_pk_for_validation (
447: new_references.ev_form_id
448: )
449: ) THEN
450: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454: ELSIF (p_action = 'VALIDATE_DELETE') THEN
532: IF (x_last_update_login IS NULL) THEN
533: x_last_update_login := -1;
534: END IF;
535: ELSE
536: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
701: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
702: fnd_message.set_token ('ERR_CD', SQLCODE);
703: igs_ge_msg_stack.add;
704: igs_sc_gen_001.unset_ctx('R');
705: app_exception.raise_exception;
698: EXCEPTION
699: WHEN OTHERS THEN
700: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
701: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
702: fnd_message.set_token ('ERR_CD', SQLCODE);
703: igs_ge_msg_stack.add;
704: igs_sc_gen_001.unset_ctx('R');
705: app_exception.raise_exception;
706: ELSE
815:
816: OPEN c1;
817: FETCH c1 INTO tlinfo;
818: IF (c1%notfound) THEN
819: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
820: igs_ge_msg_stack.add;
821: CLOSE c1;
822: app_exception.raise_exception;
823: RETURN;
867: AND ((tlinfo.SEVIS_SCHOOL_IDENTIFIER = x_sevis_school_id) OR ((tlinfo.SEVIS_SCHOOL_IDENTIFIER IS NULL) AND (x_sevis_school_id IS NULL )))
868: ) THEN
869: NULL;
870: ELSE
871: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
872: igs_ge_msg_stack.add;
873: app_exception.raise_exception;
874: END IF;
875:
951: IF (x_last_update_login IS NULL) THEN
952: x_last_update_login := -1;
953: END IF;
954: ELSE
955: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
956: igs_ge_msg_stack.add;
957: app_exception.raise_exception;
958: END IF;
959:
1058: SEVIS_SCHOOL_IDENTIFIER = new_references.SEVIS_SCHOOL_IDENTIFIER
1059: WHERE rowid = x_rowid;
1060:
1061: IF (SQL%NOTFOUND) THEN
1062: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1063: igs_ge_msg_stack.add;
1064: igs_sc_gen_001.unset_ctx('R');
1065: app_exception.raise_exception;
1066: END IF;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: IF (SQLCODE = (-28115)) THEN
1078: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1079: fnd_message.set_token ('ERR_CD', SQLCODE);
1080: igs_ge_msg_stack.add;
1081: igs_sc_gen_001.unset_ctx('R');
1082: app_exception.raise_exception;
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: IF (SQLCODE = (-28115)) THEN
1078: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1079: fnd_message.set_token ('ERR_CD', SQLCODE);
1080: igs_ge_msg_stack.add;
1081: igs_sc_gen_001.unset_ctx('R');
1082: app_exception.raise_exception;
1083: ELSE
1277: DELETE FROM igs_pe_ev_form
1278: WHERE rowid = x_rowid;
1279:
1280: IF (SQL%NOTFOUND) THEN
1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1282: igs_ge_msg_stack.add;
1283: igs_sc_gen_001.unset_ctx('R');
1284: app_exception.raise_exception;
1285: END IF;