APPS.PO_GML_DB_COMMON dependencies on IC_LOCT_MST

Line 174: l_location ic_loct_mst.location%TYPE;

170: ) RETURN NUMBER IS
171:
172: v_progress VARCHAR2(3) := '010';
173: l_whse_code ic_whse_mst.whse_code%TYPE;
174: l_location ic_loct_mst.location%TYPE;
175: l_quantity_onhand NUMBER;
176: l_lot_id ic_lots_mst.lot_id%TYPE;
177: BEGIN
178: BEGIN

Line 216: from ic_loct_mst

212:
213: ELSE
214: BEGIN
215: select location INTO l_location
216: from ic_loct_mst
217: where whse_code = l_whse_code
218: and inventory_location_id = plocator_id;
219:
220: EXCEPTION WHEN NO_DATA_FOUND

Line 844: from ic_loct_mst

840: then
841: BEGIN
842: select location
843: into l_location
844: from ic_loct_mst
845: where whse_code = l_whse_code
846: and inventory_location_id = l_locator_id;
847: EXCEPTION
848: When NO_DATA_FOUND then

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

1440: ELSIF x_return_status = '-30' THEN
1441: l_error_message := x_return_Status||' When others in get_opm_uom_code';
1442:
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.