My service manual says it's only for the cam position sensor (crank position is P0335). P0341 is specifically for a lack of a cam position sensor. I suppose the first thing to try is disconnecting it, cleaning, then plugging it back in.
There is a relationship between the crank position sensor and the cam position sensor. At startup the cam position sensor is used, then once the engine is running the crank position sensor is used instead as the primary means to determine engine position. However, both sensors are monitored continuously, and if they differ by more than 1 tooth on the cam gear, the engine will throw a code (not sure whether it will run or not).
The fact that you have a Rokktech modified sensor makes me think maybe it's at fault. Perhaps it somehow provided a signal that was too far away (in terms of crank angle) from the camshaft and the engine panicked and shut down.
Attached is a picture of the location of the cam position sensor. The service manual's first suggestion is to clean the connector. Failing that, check the resistance across the sensor - it should be 900-1100 ohm. Any value outside that range indicates a bad sensor.
Ryan