awk -F\| '{
  for (i = 0; ++i <= NF;)
    if (!isnum($i))
	  printf "line %d, field %i does\47t look like a number: %s\n", \
	    NR, i, $i
  }
func isnum(x) {
  return x == x + 0
  }' infile

% cat infile 
123|123
234|234
23e|23e
234.456|234.456
234.876e|234.876e
345.00|345.00
% awk -F\| '{
  for (i = 0; ++i <= NF;)
    if (!isnum($i))
  printf "line %d, field %i does\47t look like a number: %s\n", \
    NR, i, $i
  }
func isnum(x) {
  return x == x + 0
  }' infile
line 3, field 1 does't look like a number: 23e
line 3, field 2 does't look like a number: 23e
line 5, field 1 does't look like a number: 234.876e
line 5, field 2 does't look like a number: 234.876e

awk -F\| '{
  for (i = 0; ++i <= NF;)
    if (!isnum($i)) {
	  print "line", NR, "contains invalid numbers, skipping it ..."
	  break
	  }
  }
func isnum(x) {
  return x == x + 0
  }' infile

line 3 contains invalid numbers, skipping it ...
line 5 contains invalid numbers, skipping it ...