APPS.INV_SELECT_INVENTORY_PKG dependencies on FND_API

Line 36: X_return_status := FND_API.G_RET_STS_SUCCESS;

32: FROM gme_batch_header a, gme_material_details b
33: WHERE a.batch_id = b.batch_id
34: AND b.material_detail_id = V_source_line_id;
35: BEGIN
36: X_return_status := FND_API.G_RET_STS_SUCCESS;
37: --Getting the source number from order header Getting the source line number from order lines
38: IF (V_source_type_id = INV_GLOBALS.G_SOURCETYPE_SALESORDER) THEN
39: OPEN Cur_get_order;
40: FETCH Cur_get_order INTO X_line_no, X_header_no;

Line 63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: fnd_msg_pub.add_exc_msg ('INV_SELECT_INVENTORY_PKG', 'get_source_info');
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: END get_source_info;
65:
66: /*##############################################################
67: # NAME

Line 78: X_return_status := FND_API.G_RET_STS_SUCCESS;

74: ###############################################################*/
75:
76: PROCEDURE get_details (V_move_order_line_id IN NUMBER, X_return_status OUT NOCOPY VARCHAR2) IS
77: BEGIN
78: X_return_status := FND_API.G_RET_STS_SUCCESS;
79: INSERT INTO mtl_available_inventory_temp
80: (transaction_temp_id,source_line_id,move_order_line_id,organization_id,inventory_item_id,
81: transaction_source_type_id,transaction_action_id,lot_number,subinventory_code,lot_created,
82: lot_expiration_date,grade_code,locator_id,onhand_qty,secondary_onhand_qty,reason_id,

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

99: AND decode(lots.lot_number,null,'-99999',lots.lot_number) = decode(mln.lot_number,null,'-99999',mln.lot_number);
100: EXCEPTION
101: WHEN OTHERS THEN
102: fnd_msg_pub.add_exc_msg ('INV_SELECT_INVENTORY_PKG', 'get_details');
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: END get_details;
105:
106: /*##############################################################
107: # NAME