La Cucaracha (1998)
La Cucaracha is a 1998 American film directed by Jack Perez and starring Eric Roberts and Joaquim de Almeida. The film follows the story of Walter Pool (Eric Roberts), a down on his luck wannabe novelist, who receives an offer of $100,000 to kill an alleged child killer. Walter needs the money desperately for many reasons, not the least of which is the fact that he is infatuated with a local woman and he feels as though he has nothing to offer to her. He accepts the offer only to find out that the task of killing another human being is much more difficult than he thought, especially when it turns out that his intended victim is not really a child killer.
More at Wikipedia.