Question: What movie, written by Adam Herz, was a box office hit that spawned three sequels and a bollywood flop?

full_context: Document 1: 2 States (film): 2 States is a 2014 Indian romantic drama film co written and directed by Abhishek Varman based on the 2009 novel of the same name written by Chetan Bhagat. It is produced by Karan Johar and Sajid Nadiadwala. The film stars Arjun Kapoor and Alia Bhatt in lead roles. The film was released on 18 April 2014.
Document 2: Chal Pichchur Banate Hain: Chal Pichchur Banate Hain is a Hindi family comic drama film, the debut film of writer and director Pritish Chakraborty. The film was released all over on 7 September 2012. The film is a delightful satirical take on the Hindi film industry and was appreciated for its fresh and cinematic content. Filming of the movie took place primarily in Goa and Mumbai. Made on a shoestring budget the film explores themes like rampant copy paste in the film industry, the lack of originality in ideas, the prevailing star system alongside the unending passion of a true cinema lover in a humorous but realistic way through the brilliantly portrayed journey of a young MBA who quits everything and goes against everyone in order to pursue his dream of becoming a filmmaker. Screenplay, Dialogues and Direction of this 2012 film is by Pritish Chakraborty, Music is by Gaurav Dagaonkar, Cinematography is by Hari Nair while the film is edited by debutante editor Amardeep Singh Khichi.
Document 3: Paul Weitz (filmmaker): Paul John Weitz (born November 19, 1965) is an American film director, film producer, screenwriter, playwright actor. He is the older brother of filmmaker Chris Weitz. He is best known for his work with his brother, Chris Weitz, on the comedy films "American Pie" and "About a Boy", for which the brothers, who co-directed, were nominated for an Oscar. He also serves as a writer, executive producer, and director of the television series "Mozart in the Jungle".
Document 4: American Pie (film series): American Pie is a series of sex comedy films. The first film in the series was released in 1999, by Universal Pictures, and became a worldwide pop culture phenomenon, cult following. The second and third films were released at two-year intervals, whereas the fourth film was released in 2012. From 2005 to 2009, four spin-off films were released and the fifth VOD sequel is in pre-production.
Document 5: Mangal Ho: Mangal Ho is an upcoming Indian sci-fi comedy film. It is also the second Hindi feature film of Pritish Chakraborty as Writer – Director. The film will also mark Pritish Chakraborty's debut as an actor in a commercial Hindi film. "Mangal Ho" is being produced by Ascent Films Pvt Ltd and actor Annu Kapoor is playing the role of an eccentric genius scientist in the film while versatile Sanjay Mishra is essaying the role of a miser Bengali businessman.
Document 6: Mere Yaar Ki Shaadi Hai: Mere Yaar Ki Shaadi Hai (English: "It's My Friend's Wedding") is a 2002 Indian Bollywood film directed by Sanjay Gadhvi and produced by Yash Chopra and Aditya Chopra under Yash Raj Films. The film starred Uday Chopra, Jimmy Shergill, Bipasha Basu and Tulip Joshi. The film was said to be partly inspired by "My Best Friend's Wedding" (1997). The director Gadhvi, however, claims that he mainly drew from earlier Hindi films and that "My Best Friend's Wedding" only provided less than 1% of the inspiration for his film.
Document 7: American Pie (film): American Pie is a 1999 teen sex comedy film written by Adam Herz and directed by brothers Paul and Chris Weitz, in their directorial film debut. It is the first film in the "American Pie" theatrical series. The film was a box-office hit and spawned three direct sequels: "American Pie 2" (2001), "American Wedding" (2003), and "American Reunion" (2012). The film concentrates on five best friends (Jim, Kevin, Oz, Finch, and Stifler) who attend East Great Falls High. With the exception of Stifler (who has already lost his virginity), the guys make a pact to lose their virginity before their high school graduation. The title is borrowed from the song of the same name and refers to a scene in the film, in which the protagonist is caught masturbating with a pie after being told that third base feels like "warm apple pie". Writer Adam Herz has stated that the title also refers to the quest of losing one's virginity in high school, which is as "American as apple pie."
Document 8: American Pie 2: American Pie 2 is a 2001 American sex comedy film and the sequel to the 1999 film "American Pie" and the second film in the "American Pie" film series. It was written by Adam Herz and David H. Steinberg and directed by James B. Rogers. The film picks up the story of the five friends from the first film as they reunite during the summer after their first year of college. It was released in the United States on August 10, 2001, and grossed over $145 million in the US and $142 million overseas on a budget of $30 million. It was followed by another sequel, "American Wedding".
Document 9: Waisa Bhi Hota Hai Part II: Waisa Bhi Hota Hai Part II (Hindi: वैसा भी होता है , English: It Happens That Way Too ) is a 2003 Indian movie starring Arshad Warsi. Shashanka Ghosh, the creative driver behind the launch of MTV and Channel V in India, marks his debut as a director with this film. Running in many parallel threads, it is in equal parts a comedy, satire, crime, and a Hindi masala film. The film is most famous for its songs "Allah ke Bande" performed by Kailash Kher and "Sajna Aa Bhi Jaa" performed by Shibani Kashyap.
Document 10: Dil Chahta Hai: Dil Chahta Hai (English: "The Heart Desires") is a 2001 Indian comedy-drama film starring Aamir Khan, Saif Ali Khan, Akshaye Khanna, Preity Zinta, Sonali Kulkarni, and Dimple Kapadia. The first film written and directed by Farhan Akhtar, it is set in modern-day urban Mumbai and Sydney, and focuses on a major period of transition in the lives of three young friends.
Document 11: Yeh Kya Ho Raha Hai?: Yeh Kya Ho Raha Hai is a 2002 Bollywood comedy film. Directed by Hansal Mehta, produced by Pammi Baweja and written by Suparn Verma. the film stars Prashant Chianani, Aamir Ali Malik, Vaibhav Jalani, Yash Pandit, Deepti Daryanani, Payal Rohatgi, Samita Bangargi, Punarnava Mehta. Its basic premise is taken from American film American Pie. The film was a failure at box office and was declared a flop .
Document 12: Sameer Iqbal Patel: Sameer Iqbal Patel, also referred to as Sammir I Patel and Sameer Patel, is a theatre personality from India. Sameer, who started his career modeling for various brands, did TV shows, and wrote and directed a dozen commercial plays including 'Jo Khaya So Pachchtaye', 'Hawa Hawai', '3 Flights Down', and 'Baat Baat Mein Bigdey Haalaat'. He has just completed his directorial debut Hotel Beautifool. As an actor, he has featured in national television shows including "Ehsaas", "Mr. Aur Mrs. Verma Ki Rasoi", the "Noor Jehan" television show and others. He is also the writer of the television show "Yeh Chanda Kanoon Hai", which airs on SAB TV. Sameer's theatre production, a Hindi comedy play, named "Baat Baat Mein Bigdey Haalat," featured veteran actor Rakesh Bedi and Chetanya Adib. Sameer has completed his debut film "Hotel Beautifool," which is due for release in 2017, adapted from his hit play Baat Baat Mein Bigdey Halaat. After 'Hotel Beautifool', Sameer has started working on his next project, a Hindi feature film named Tata Goodbye, a black comedy.
Document 13: American Reunion: American Reunion (also known as American Pie 4: Reunion or American Pie: Reunion in certain countries) is a 2012 ensemble sex comedy film written and directed by Jon Hurwitz and Hayden Schlossberg. It is the fourth installment in the "American Pie" theatrical series and eighth installment in the "American Pie" franchise overall.
Document 14: American Pie Presents: Band Camp: American Pie Presents: Band Camp (also known as American Pie: Band Camp) is a 2005 direct-to-DVD sex comedy film. It is the first installment in the "American Pie Presents" series and the fourth installment in the "American Pie" franchise. It was directed by Steve Rash and written by Brad Riddell. The film centers on Matt Stifler, younger brother of Steve Stifler. In this film, Matt is sent to the infamous band camp, where he is compelled to change his ways.
Document 15: American Wedding: American Wedding (known as American Pie 3: The Wedding or American Pie: The Wedding, in some countries) is a 2003 American sex comedy film and a sequel to "American Pie" and "American Pie 2". It is the third (originally intended final) installment in the "American Pie" theatrical series. It was written by Adam Herz and directed by Jesse Dylan. Another sequel, "American Reunion", was released nine years later. This also stands as the last film in the series to be written by Herz, who conceptualized the franchise.
ground_truth: American Pie