How to put Action Check on Award Spot Bid Action

Hello Team, there is a requirement where shipment status needs to be checked before awarding spot bid tender to any Carrier.
I have already checked
AWARD BID , saved condition based on tender collaboration and shipment both didn't work.

Query:
SELECT 1
FROM tender_collaboration tc
WHERE tc.i_transaction_no = ?
AND tc.shipment_gid IS NOT NULL
AND EXISTS (
SELECT 1
FROM shipment_refnum shr
WHERE shr.shipment_gid = tc.shipment_gid
AND shr.shipment_refnum_qual_gid =''
AND shr.shipment_refnum_value = ''
)
AND EXISTS (
SELECT 1
FROM shipment_status ss
WHERE ss.shipment_gid = tc.shipment_gid
AND ss.status_type_gid = ''