how to write a messeage for order number in log

Hi

we have a requirement to show message for every order that without shipped data in concurrent program request and let request complete with warning.

I tried below:

1 . create a cursor in after report trigger.

   it worked. request will complete with warning if some orders haven't ship data.

2. for showing message in log for every order, I tried below, but it not worked.

I created a formula in G_order group

this is my code

function CF_1FORMULA0027 return Number is

l_count1 number;

begin

   SELECT count(wnd.confirm_date)

   into l_count1

From Wsh_New_Deliveries Wnd,

       Oe_Order_Headers_All h