APPS.INV_ITEM_INQ dependencies on FND_API

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: AND mlk.lookup_type = 'WMS_LPN_CONTEXT'
914: AND mlk.lookup_code = lpn.lpn_context;
915: END IF;
916: EXCEPTION
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: null;
919: END GET_LPN_CONTENTS;
920:
921:

Line 1048: when FND_API.G_EXC_UNEXPECTED_ERROR then

1044: and wlpn.lpn_id = lpn.lpn_id
1045: and (t.content_lpn_id = wlpn.lpn_id)); -- #Bug 4892698
1046: -- or t.lpn_id = wlpn.lpn_id)); -- Line commented out for #Bug 4892698
1047: EXCEPTION
1048: when FND_API.G_EXC_UNEXPECTED_ERROR then
1049: null;
1050:
1051: END GET_LPN_FOR_ITEM;
1052:

Line 1266: p_init_msg_lst => fnd_api.g_false,

1262: end if;
1263:
1264: Inv_Quantity_Tree_Pub.Query_Quantities (
1265: p_api_version_number => 1.0,
1266: p_init_msg_lst => fnd_api.g_false,
1267: x_return_status => l_return_status,
1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data,
1270: p_organization_id => p_organization_id,

Line 1357: p_init_msg_lst => fnd_api.g_false,

1353: end if;
1354:
1355: Inv_Quantity_Tree_Pub.Query_Quantities (
1356: p_api_version_number => 1.0,
1357: p_init_msg_lst => fnd_api.g_false,
1358: x_return_status => l_return_status,
1359: x_msg_count => l_msg_count,
1360: x_msg_data => l_msg_data,
1361: p_organization_id => p_organization_id,

Line 1379: IF (l_return_status = fnd_api.g_ret_sts_success)

1375: x_att => l_att,
1376: x_atr => l_atr,
1377: p_cost_group_id => l_cost_group_id);
1378: --
1379: IF (l_return_status = fnd_api.g_ret_sts_success)
1380: THEN
1381: return l_atr; -- Return the available quantity
1382: ELSE
1383: return -99999999; -- Return bogus number if error occurs

Line 1436: when FND_API.G_EXC_UNEXPECTED_ERROR then

1432: -- Following condition is added as a part of Bug fix for Bug# 3549931
1433: AND msik.inventory_item_id = mln.inventory_item_id;
1434: END IF;
1435: EXCEPTION
1436: when FND_API.G_EXC_UNEXPECTED_ERROR then
1437: null;
1438: END LOT_ATTRIBUTES;
1439:
1440: /****************************************************************************

Line 1484: when FND_API.G_EXC_UNEXPECTED_ERROR then

1480: AND msn.status_id = mmst.status_id(+)
1481: AND msn.serial_number = p_serial_number;
1482: END IF;
1483: EXCEPTION
1484: when FND_API.G_EXC_UNEXPECTED_ERROR then
1485: null;
1486: END SERIAL_ATTRIBUTES;
1487:
1488: PROCEDURE Get_Serial_Number(

Line 1806: , p_init_msg_lst => fnd_api.g_false

1802: end if;
1803:
1804: inv_quantity_tree_pub.update_quantities
1805: ( p_api_version_number => l_api_version_number
1806: , p_init_msg_lst => fnd_api.g_false
1807: , x_return_status => x_return_status
1808: , x_msg_count => x_msg_count
1809: , x_msg_data => x_msg_data
1810: , p_organization_id => p_organization_id

Line 1845: x_return_status := fnd_api.g_ret_sts_unexp_error;

1841: --
1842: if iteminfo%isopen then
1843: close iteminfo;
1844: end if;
1845: x_return_status := fnd_api.g_ret_sts_unexp_error;
1846: fnd_msg_pub.count_and_get( p_count => x_msg_count
1847: ,p_data => x_msg_data );
1848:
1849: END UPDATE_QUANTITY;

Line 1946: , p_init_msg_lst => fnd_api.g_false

1942: end if;
1943:
1944: inv_quantity_tree_pub.update_quantities
1945: ( p_api_version_number => l_api_version_number
1946: , p_init_msg_lst => fnd_api.g_false
1947: , x_return_status => x_return_status
1948: , x_msg_count => x_msg_count
1949: , x_msg_data => x_msg_data
1950: , p_organization_id => p_organization_id

Line 1997: x_return_status := fnd_api.g_ret_sts_unexp_error;

1993: --
1994: if iteminfo%isopen then
1995: close iteminfo;
1996: end if;
1997: x_return_status := fnd_api.g_ret_sts_unexp_error;
1998: fnd_msg_pub.count_and_get( p_count => x_msg_count
1999: ,p_data => x_msg_data );
2000:
2001: END UPDATE_QUANTITY;