was it successful or faced cancellation at any point of time?
Nine of the planned flights were canceled.
Project Mercury
Nine of the planned flights were canceled. 
from which profession is frank borman? He is a retired United States Air Force colonel, aeronautical engineer, test pilot, businessman, rancher, and NASA astronaut. do you know the full form of this acronym? National Aeronautics and Space Administration who formed it? UNANSWERABLE of which project was it a part during 1958 to 63? Project Mercury any person from its organization? T. Keith Glennan was any spacecraft used for it? Yes, the  spacecraft was given a name ending with a "7" by its pilot. was it a part of any movie? Yes, it was portrayed in "The Right Stuff".
wiki:25619330
Project Mercury [SEP] Canceled
Nine of the planned flights were canceled. Suborbital flights were planned for four other astronauts but the number of flights was cut down gradually and finally all remaining were canceled after Titov's flight. Mercury-Atlas 9 was intended to be followed by more one-day flights and even a three-day flight but with the coming of the Gemini Project it seemed unnecessary. The Jupiter booster was, as mentioned above, intended to be used for different purposes.