Two programs provide the ability to customize serial number pages:

• Configuring Attributes for Context Display

  The program get_dummy_serial_dff_context enables you to customize the context by default so that results are displayed every time in the View Assembly Serial Number page.

• Validating Serialized Components

  The program validate_comp_serial enables you to incorporate business specific conditions to validate components before adding items in the Express Transact Component page.

Configuring Attributes for Context Display

get_dummy_serial_dff_context:

Using this program you can customize the Viiew Assembly Serial Number page context so that results are displayed based on the context selected; by default no data is displayed.

Once the serial attributes Digital Forensics Framework (DFF) is enabled in forms, you can select the context and provide the context values while performing express material transactions. These details are viewed in the View Assembly Serial Number page by selecting the attributes context.

/* Hook to get Dummy DFF context which is configured to show all the attributes from all
different context */
Function get_dummy_serial_dff_context
return varchar2
IS
l_dff_context_code varchar2(50) :=null;
BEGIN
/* This dummy context used by Component serials table in view assembly serial page to show all
the attributes of different context */
l_dff_context_code := 'Physical Parameters';
return l_dff_context_code;
END get_dummy_serial_dff_context;

Validating Serialized Components

validate_comp_serial

This program provides the ability to validate components with serial attributes in the Express Transact Components page. You can set up business specific conditions to validate components before clicking Add on this page:

PROCEDURE validate_comp_serial( p_org_id IN NUMBER,
p_wip_entity_id IN NUMBER,
p_assy_serial IN VARCHAR2,
p_op_seq_num IN NUMBER,
p_comp_item_id IN NUMBER,
p_comp_serial IN VARCHAR2,
p_quantity IN NUMBER,
p_txn_type_id IN NUMBER,
p_return_status OUT NOCOPY VARCHAR2,
p_errmsg OUT NOCOPY VARCHAR2)
IS
l_dummy number :=-1;
BEGIN
p_return_status := 'S';
p_errmsg := null;
/*p_return_status should return E/S/W/I.
S- will add component serial successfully.
W- will add component serial along with warning message.
I- will add component serial along with information message.
E- will throw error message and doesn't add the component serial.*/
begin
select 1 into l_dummy
from mtl_serial_numbers
where serial_number=p_comp_serial
and inventory_item_id=p_comp_item_id
and ( C_ATTRIBUTE10='Red' or C_ATTRIBUTE10 IS NULL);
exception
when NO_DATA_FOUND then
p_return_status := 'E';
p_errmsg := 'Custom validation message : Only serial number with physical attribute
Red allowed';
end;
END validate_comp_serial;