The Surging Frenzied Flame is a Consumable Item ... you must head to the Midra's Manse. You can get to this place from the Main Gate Plaza Site of Grace at Shadow Keep, then head northwest ...

The Roped Frenzied Flame Pot is a Consumable ... bring salvation to those it strikes. To get this item, you must travel to the Abyssal Woods Site of Grace, then start travelling to the west ...