[Home] [Help]
127: x_msg_data OUT NOCOPY VARCHAR2
128: ) IS
129:
130: BEGIN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133: CASE wms_deployment_mode
134: WHEN 'I' THEN
135: x_client_rec.client_id := NULL;
143: END CASE;
144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
149: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, 'Get_Client_Info');
150: END IF;
151: END Get_Client_Info;
165: l_in_txn_rec t_in_txn_rec;
166: l_client_rec t_client_rec;
167:
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: l_in_txn_rec.inventory_item_id := p_inventory_item_id;
172: l_in_txn_rec.organization_id := p_organization_id;
173:
176: x_outsourcer_id := l_client_rec.client_id;
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: IF (FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
182: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, 'Get_Client_Info_For_Item');
183: END IF;
184:
194: p_outsourcer_id NUMBER,
195: x_item_category_id OUT NOCOPY NUMBER
196: )IS
197: BEGIN
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: CASE wms_deployment_mode
201: WHEN 'I' THEN
202: x_item_category_id := NULL; --API will not return anything in Integrated Mode
207: END CASE;
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF (FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
213: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, 'Get_Category_Info');
214: END IF;
215: END;
275: | Input Parameters: |
276: | x_client_id - The client ID for which the details needs to be passed |
277: | x_client_code - The client Code for which the details needs to be passed|
278: | Output Parameters: |
279: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
280: | fnd_api.g_ret_sts_error, if error occurred |
281: | x_client_id - The client ID for which the details needs to be passed |
282: | x_client_code - The client Code for which the details needs to be passed|
283: | x_client_name - The client name corresponding to client ID fetched from |
276: | x_client_id - The client ID for which the details needs to be passed |
277: | x_client_code - The client Code for which the details needs to be passed|
278: | Output Parameters: |
279: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
280: | fnd_api.g_ret_sts_error, if error occurred |
281: | x_client_id - The client ID for which the details needs to be passed |
282: | x_client_code - The client Code for which the details needs to be passed|
283: | x_client_name - The client name corresponding to client ID fetched from |
284: | hz_parties |
293: , x_return_status OUT NOCOPY VARCHAR2
294: )as
295:
296: BEGIN
297: x_return_status := fnd_api.g_ret_sts_success;
298:
299: BEGIN
300:
301: IF x_client_id <> FND_API.G_MISS_NUM
297: x_return_status := fnd_api.g_ret_sts_success;
298:
299: BEGIN
300:
301: IF x_client_id <> FND_API.G_MISS_NUM
302: THEN
303: BEGIN
304: SELECT client_id , client_code
305: INTO x_client_id , x_client_code
305: INTO x_client_id , x_client_code
306: FROM mtl_client_parameters
307: WHERE client_id = x_client_id;
308: END;
309: ELSIF x_client_code <> FND_API.G_MISS_CHAR
310: THEN
311: BEGIN
312: SELECT client_id , client_code
313: INTO x_client_id , x_client_code
314: FROM mtl_client_parameters
315: WHERE client_code = x_client_code;
316: END;
317: ELSE
318: RAISE fnd_api.g_exc_error;
319: End IF;
320:
321: BEGIN
322: SELECT client.party_name
327: END;
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: x_return_status := fnd_api.g_ret_sts_error;
332: END;
333:
334: END get_client_details;
335: