This content has been marked as final. Show 4 replies
Use user_pkg_serial. Write you code in there to generate your serial number and return it.
Even this does not have the serial number as the input parameter.
i have say '9999999' as the serial number i need to create for Item#1234 for Org id 4
Can i pass the serial# with the item and org data to any APIs to create the serial #
You have to assign 9999999 to x_serial_number (out parameter). And pass your organization_id and inventory_item_id to p_org_id and p_item_id.
System will generate 9999999 for you as your serial number. It is not in parameter but it is OUT. You need to write your logic here. You cannot keep using 9999999 always.
But i was checkign the package
This does not do anything...
procedure generate_serial_number(x_return_status OUT NOCOPY VARCHAR2
,x_msg_data OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_serial_number OUT NOCOPY VARCHAR2
,p_org_id IN NUMBER
,p_item_id IN NUMBER)
WHEN OTHERS THEN
x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
x_serial_number := NULL;