DBA Data[Home] [Help]

APPS.PO_GML_DB_COMMON dependencies on MTL_ITEM_LOCATIONS

Line 857: from mtl_item_locations

853: THEN
854: BEGIN
855: select substrb(segment1,1,16)
856: into l_location
857: from mtl_item_locations
858: where inventory_location_id = l_locator_id;
859: EXCEPTION
860: When NO_DATA_FOUND then
861: x_return_status := '-50';

Line 1447: l_error_message := x_return_Status||' No data found in MTL_ITEM_LOCATIONS for locator with id '||to_char(l_locator_id);

1443: ELSIF x_return_status = '-40' THEN
1444: l_error_message := x_return_Status||' No data found in IC_LOCT_MST for locator with id '||to_char(l_locator_id);
1445:
1446: ELSIF x_return_status = '-50' THEN
1447: l_error_message := x_return_Status||' No data found in MTL_ITEM_LOCATIONS for locator with id '||to_char(l_locator_id);
1448: -- Bug 3597203 following condition added.
1449: ELSIF x_return_status = '-55' THEN
1450: FND_MESSAGE.SET_NAME('PO','RCV_LOCATOR_CONTROL_INVALID');
1451: l_error_message := x_return_status||' : '||FND_MESSAGE.GET;