APPS.INV_3PL_LOC_PVT dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: l_client_code VARCHAR2(10);
33: l_organization_id NUMBER;
34:
35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: IF (g_debug = 1) THEN
39: inv_trx_util_pub.TRACE('In update locator capcity ', 'update_current_capacity', 4);
40: inv_trx_util_pub.TRACE('Locator ID' || p_inventory_location_id , 'update_current_capacity',4);

Line 82: IF ( l_success <> fnd_api.g_ret_sts_success )

78: p_client_code,
79: 1
80: );
81:
82: IF ( l_success <> fnd_api.g_ret_sts_success )
83: THEN
84: x_msg_data := SQLERRM;
85: END IF;
86: x_return_status := l_success;

Line 197: IF ( l_success <> fnd_api.g_ret_sts_success )

193: l_client_code,
194: l_number_of_days
195: );
196:
197: IF ( l_success <> fnd_api.g_ret_sts_success )
198: THEN
199: x_msg_data := SQLERRM;
200: END IF;
201: x_return_status := l_success;

Line 210: x_return_status := fnd_api.g_ret_sts_unexp_error;

206: WHEN OTHERS THEN
207: IF (g_debug = 1) THEN
208: inv_trx_util_pub.TRACE(' Exception in update_locator_capacity => '||sqlerrm, 'update_current_capacity', 4);
209: END IF;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: END update_locator_capacity;
212:
213: Function update_3pl_loc_occupancy (
214: l_Last_Receipt_Date date,

Line 258: RETURN FND_API.G_RET_STS_SUCCESS;

254: and client_code = recinfo.client_code
255: and organization_id = recinfo.organization_id;
256: END LOOP;
257:
258: RETURN FND_API.G_RET_STS_SUCCESS;
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF (g_debug = 1) THEN

Line 266: RETURN FND_API.G_RET_STS_ERROR;

262: IF (g_debug = 1) THEN
263: inv_trx_util_pub.TRACE(' Exception in update_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);
264: END IF;
265:
266: RETURN FND_API.G_RET_STS_ERROR;
267: END update_3pl_loc_occupancy;
268:
269: Function insert_3pl_loc_occupancy (
270: l_Last_Receipt_Date date,

Line 314: RETURN FND_API.G_RET_STS_SUCCESS;

310: l_organization_id ,
311: l_client_code
312: );
313:
314: RETURN FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: WHEN OTHERS THEN
318: IF (g_debug = 1) THEN

Line 321: RETURN FND_API.G_RET_STS_ERROR;

317: WHEN OTHERS THEN
318: IF (g_debug = 1) THEN
319: inv_trx_util_pub.TRACE(' Exception in insert_3pl_loc_occupancy => '||sqlerrm, 'update_current_capacity', 4);
320: END IF;
321: RETURN FND_API.G_RET_STS_ERROR;
322: END insert_3pl_loc_occupancy;
323:
324: END INV_3PL_LOC_PVT;