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: -- Bug#12831673. Added lpn_id
80: INSERT INTO mtl_available_inventory_temp
81: (transaction_temp_id,source_line_id,move_order_line_id,organization_id,inventory_item_id,
82: transaction_source_type_id,transaction_action_id,lot_number,subinventory_code,lot_created,

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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