{awk: Command not found

I am new to bash coding so thanks in advance for your patience.

I will be processing 100,000's of image files over the coming weeks. As images arrive they have a raw name that needs to be modified. The name needs to be modified by looking up information for that image in a csv file and renamed accordingly. The prefix and suffix of the name together indicate exactly which record it is associated with and depending on which column the suffix matches, different name conventions are required. What am I doing wrong????

#!/usr/bin/awk -f

for file in *.NEF

do 

{awk '
BEGIN { 
FS=","
}

raw_name=$file
prefix="${file:0:3}"
suffix="${file:4:4}"

if ($28 ~ /$prefix/ && $24 ~ /$suffix/) 
{$100="New_prefix_1" "$raw_name";}

else 
{
if ($28 ~ /$prefix/ && $25 ~ /$suffix/) 
{ $100="New_prefix_2" "$raw_name";}
}
else 
{ 
if ($28 ~ /$prefix/ && $26 ~ /$suffix/) 
{$100="New_prefix_3" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ && $27 ~ /$suffix/) 
{$100="New_prefix_4" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ && $29 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_5" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ && $30 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_6" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ && $31 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_7" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ && $32 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_8" "$raw_name":}
}
else 
{
if ($28 ~ /$prefix/ && $33 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_9" "$raw_name";}
}
else 
{
if ($28 ~ /$prefix/ &&  $34 ~ /$suffix/) 
{$100= $4 "_" $2 "New_prefix_10" "$raw_name";}
}
else 
{mv $file  ~/Rename_error/$file.NEF}
}
END }' Data.csv