Uncaught ReferenceError

Boa tarde, alguem pode me ajudar com esse erro fazendo favor, não consegui resolver

Uncaught ReferenceError: retornaSqlInsert is not defined
    at confirm (data_webcbvcadastro.do:1206)

1206:    document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro.value = retornaSqlInsert(document,document.FrmDataWEBCbvCadastro,document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro,sqlFields,sqlValues,sqlDelimiter);

Codigo :

function confirm(){

//elemA = document.getElementById('field-text-equal-NOME');
	//elemA.value = tinyMCE.get('NOME').getContent();
	//elemA.value = replaceAll (elemA.value,'#','|');
	//elemA.value = replaceAll (elemA.value,'\'','\"');
	//alert(elemA.value);

<%
if (strEventName.equals("search")){
%>
//elemA.style.visibility="visible";
montaWhere(document,document.FrmDataWEBCbvCadastro,document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros);
//if (document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value.length > 0){
//	if (document.FrmDataWEBCbvCadastro.whereClauseListBasico.value.length > 0){
	//		document.FrmDataWEBCbvCadastro.whereClauseListBasico.value = document.FrmDataWEBCbvCadastro.whereClauseListBasico.value + ' and CODIGO_MASTERCBV in (select CODIGO_MASTERCBV from TabelaXXX where ' + document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value + ')';    
	//	}else{
	//		document.FrmDataWEBCbvCadastro.whereClauseListBasico.value = ' CODIGO_MASTERCBV in (select CODIGO_MASTERCBV from TabelaXXX where ' + document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value + ')';    
	//	}
//}



elemIni4 = document.getElementById('DATA_CADASTRO_INI');
elemFim4 = document.getElementById('DATA_CADASTRO_FIM');
if (elemIni4.value.length > 9){
  if (elemFim4.value.length > 9){
    temp_split = elemIni4.value.split ('/');
    strWhere = "DATA_CADASTRO>=to_date('" + temp_split[0] + "-" + temp_split[1] + "-" + temp_split[2] + " 00:00:00','dd-mm-yyyy hh24:mi:ss')";
    temp_split = elemFim4.value.split ('/');
    strWhere = strWhere + " AND DATA_CADASTRO<=to_date('" + temp_split[0] + "-" + temp_split[1] + "-" + temp_split[2] + " 23:59:59','dd-mm-yyyy hh24:mi:ss')";
    if (document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value.length > 0){
      document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value = document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value + " AND " + strWhere;
    }else{
      document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value = strWhere;
    }
  }else{
    temp_split = elemIni4.value.split ('/');
    strWhere = "DATA_CADASTRO>=to_date('" + temp_split[0] + "-" + temp_split[1] + "-" + temp_split[2] + " 00:00:00','dd-mm-yyyy hh24:mi:ss') and DATA_CADASTRO<=to_date('" + temp_split[0] + "-" + temp_split[1] + "-" + temp_split[2] + " 23:59:59','dd-mm-yyyy hh24:mi:ss')";
    if (document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value.length > 0){
      document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value = document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value + " AND " + strWhere;
    }else{
      document.FrmDataWEBCbvCadastro.whereClauseListWEBCbvCadastros.value = strWhere;
    }
  }
}

	document.FrmDataWEBCbvCadastro.action='<%=request.getContextPath()%>/list_webcbvcadastros.do';
document.FrmDataWEBCbvCadastro.eventType.value='load';
document.FrmDataWEBCbvCadastro.eventName.value='';
<%
}else{
%>
	 
	
	//elem = document.getElementById('field-number-equal-CAMPO');
	//elem = document.getElementById('field-text-equal-OBS');
	//if (elem.value.length > 500){
	//	alert ('O campo de observação aceita até 500 caracteres, diminua o texto digitado!');
	//	return false;
	//}			
	
	<% if (strEventName.equals("update")){ %>
    elem = document.getElementById('field-text-equal-PASTA_FTP');
    if (elem.value.length > 250){
        alert ('O campo <Pasta FTP> aceita até 250 caracteres, diminua o texto digitado!');
        return false;
    }
    <% }else{ %>
    elem = document.getElementById('field-text-like-PASTA_FTP');
    if (elem.value.length > 250){
        alert ('O campo <Pasta FTP> aceita até 250 caracteres, diminua o texto digitado!');
        return false;
    }
    <% } %>		
	
	//elemA.style.visibility="visible";
<%
  if (strEventName.equals("update")){
%>
sqlFields = '';
sqlValues = '';
sqlWhere = '';
sqlDelimiter = '';
sqlDelimiterWhere = '';
document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro.value = retornaSqlUpdate(document,document.FrmDataWEBCbvCadastro,document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro,sqlFields,sqlValues,sqlDelimiter,sqlWhere,sqlDelimiterWhere);
<%
  }else if(strEventName.equals("insert")){
%>
sqlFields = 'CODIGO_MASTERCBV';
sqlValues = 'pkValue';
sqlDelimiter = '|-|';
elemKey = document.getElementById('field-number-equal-' + sqlFields);
elemKey.style.visibility="visible";    
document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro.value = retornaSqlInsert(document,document.FrmDataWEBCbvCadastro,document.FrmDataWEBCbvCadastro.sqlDataWEBCbvCadastro,sqlFields,sqlValues,sqlDelimiter);
<%
  };
%>
	document.FrmDataWEBCbvCadastro.action='<%=request.getContextPath()%>/data_webcbvcadastro.do';
document.FrmDataWEBCbvCadastro.eventType.value='confirm';
<%
}
%>
	go();
}

Topicos relacionados