Not clear on what 'failure' means in the test manager. Is it just a test of expected value versus returned value, or does coding and throwing an exception also turn the test red? Does it report the SQLCODE for the exception?
There are certainly tests that should cause a proc/func to fail because that is the expected behavior given the inputs.
Some realistic examples might be very helpful. The user guide section is a bit thin on this topic.