81:
82: --Check constraint for thesis exam type
83: IF p_the_dtls_rec.thesis_exam_type IS NOT NULL THEN
84: BEGIN
85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);
86: EXCEPTION
87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
95:
96: --Check constraint for the Thesis Panel Type parameter
97: IF p_the_dtls_rec.thesis_panel_type IS NOT NULL THEN
98: BEGIN
99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);
100: EXCEPTION
101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
109:
110: --Check Constraint for the thesis result code
111: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
112: BEGIN
113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);