512: and answer_id = anscount_rec.answer_id;
513: END LOOP;
514: EXCEPTION
515: WHEN OTHERS THEN
516: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_UPDATE_DEPLOY_STATUS');
517: l_error_msg := FND_MESSAGE.GET;
518: fnd_file.put_line(fnd_file.log, l_error_msg);
519: p_error_msg := l_error_msg;
520: p_retcode := -1;
513: END LOOP;
514: EXCEPTION
515: WHEN OTHERS THEN
516: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_UPDATE_DEPLOY_STATUS');
517: l_error_msg := FND_MESSAGE.GET;
518: fnd_file.put_line(fnd_file.log, l_error_msg);
519: p_error_msg := l_error_msg;
520: p_retcode := -1;
521: ROLLBACK TO Create_Summary;
552: AND e.question_type_id is not null
553: AND e.active_status = 1;
554:
555: IF (l_ques_type_count = 0) THEN
556: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_QUESTION_TYPE_ERROR');
557: l_error_msg := FND_MESSAGE.GET;
558: fnd_file.put_line(fnd_file.log, l_error_msg);
559: p_error_msg := l_error_msg;
560: p_retcode := -1;
553: AND e.active_status = 1;
554:
555: IF (l_ques_type_count = 0) THEN
556: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_QUESTION_TYPE_ERROR');
557: l_error_msg := FND_MESSAGE.GET;
558: fnd_file.put_line(fnd_file.log, l_error_msg);
559: p_error_msg := l_error_msg;
560: p_retcode := -1;
561: ELSE
687: end if;
688: END LOOP;
689: EXCEPTION
690: WHEN OTHERS THEN
691: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_UPDATE_DEPLOY_STATUS');
692: l_error_msg := FND_MESSAGE.GET;
693: fnd_file.put_line(fnd_file.log, l_error_msg);
694: p_error_msg := l_error_msg;
695: p_retcode := -1;
688: END LOOP;
689: EXCEPTION
690: WHEN OTHERS THEN
691: FND_MESSAGE.SET_NAME('IES', 'IES_SVY_UPDATE_DEPLOY_STATUS');
692: l_error_msg := FND_MESSAGE.GET;
693: fnd_file.put_line(fnd_file.log, l_error_msg);
694: p_error_msg := l_error_msg;
695: p_retcode := -1;
696: ROLLBACK TO List_Response;