You're going to hate my answer but don't feel bad ... I didn't see this until after I cut-and-pasted your example in and fiddled with it a few minutes trying to see why it wouldn't cast timestamp to timestamptz!
You defined the function as "template_products__new" yet called it as "template_product__new" ...
