In the Dispatch List, the default display for exceptions is:

• If only one exception occurs, the type is named such as Resource.

• In the case of more than one exception, the value Multiple displays.

This program customizes the code so you can view the number of exceptions both open and closed.

get_custom_exception

function get_custom_exception(wip_entity_id number, operation_seq_num
number,serial_number varchar2) return varchar2
is
l_count number;
l_message varchar2(50);
l_wip_entity_id number;
l_operation_seq_num number;
begin
l_wip_entity_id := wip_entity_id;
l_operation_seq_num := operation_seq_num;
--Fill the custom implmentation here and return the final status the user wants to see on the page
for Exception column
select count(*) into l_count
from wip_exceptions
where wip_entity_id=l_wip_entity_id
and operation_seq_num=l_operation_seq_num;
l_message := '(Custom)Exceptions Count:'||l_count;
return l_message;
end;