APPS.INV_ITEM_INQ dependencies on FND_API

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: AND mlk.lookup_type = 'WMS_LPN_CONTEXT'
990: AND mlk.lookup_code = lpn.lpn_context;
991: END IF;
992: EXCEPTION
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: null;
995: END GET_LPN_CONTENTS;
996:
997:

Line 1124: when FND_API.G_EXC_UNEXPECTED_ERROR then

1120: and wlpn.lpn_id = lpn.lpn_id
1121: and (t.content_lpn_id = wlpn.lpn_id)); -- #Bug 4892698
1122: -- or t.lpn_id = wlpn.lpn_id)); -- Line commented out for #Bug 4892698
1123: EXCEPTION
1124: when FND_API.G_EXC_UNEXPECTED_ERROR then
1125: null;
1126:
1127: END GET_LPN_FOR_ITEM;
1128:

Line 1342: p_init_msg_lst => fnd_api.g_false,

1338: end if;
1339:
1340: Inv_Quantity_Tree_Pub.Query_Quantities (
1341: p_api_version_number => 1.0,
1342: p_init_msg_lst => fnd_api.g_false,
1343: x_return_status => l_return_status,
1344: x_msg_count => l_msg_count,
1345: x_msg_data => l_msg_data,
1346: p_organization_id => p_organization_id,

Line 1433: p_init_msg_lst => fnd_api.g_false,

1429: end if;
1430:
1431: Inv_Quantity_Tree_Pub.Query_Quantities (
1432: p_api_version_number => 1.0,
1433: p_init_msg_lst => fnd_api.g_false,
1434: x_return_status => l_return_status,
1435: x_msg_count => l_msg_count,
1436: x_msg_data => l_msg_data,
1437: p_organization_id => p_organization_id,

Line 1455: IF (l_return_status = fnd_api.g_ret_sts_success)

1451: x_att => l_att,
1452: x_atr => l_atr,
1453: p_cost_group_id => l_cost_group_id);
1454: --
1455: IF (l_return_status = fnd_api.g_ret_sts_success)
1456: THEN
1457: return l_atr; -- Return the available quantity
1458: ELSE
1459: return -99999999; -- Return bogus number if error occurs

Line 1512: when FND_API.G_EXC_UNEXPECTED_ERROR then

1508: -- Following condition is added as a part of Bug fix for Bug# 3549931
1509: AND msik.inventory_item_id = mln.inventory_item_id;
1510: END IF;
1511: EXCEPTION
1512: when FND_API.G_EXC_UNEXPECTED_ERROR then
1513: null;
1514: END LOT_ATTRIBUTES;
1515:
1516: /****************************************************************************

Line 1560: when FND_API.G_EXC_UNEXPECTED_ERROR then

1556: AND msn.status_id = mmst.status_id(+)
1557: AND msn.serial_number = p_serial_number;
1558: END IF;
1559: EXCEPTION
1560: when FND_API.G_EXC_UNEXPECTED_ERROR then
1561: null;
1562: END SERIAL_ATTRIBUTES;
1563:
1564: PROCEDURE Get_Serial_Number(

Line 1882: , p_init_msg_lst => fnd_api.g_false

1878: end if;
1879:
1880: inv_quantity_tree_pub.update_quantities
1881: ( p_api_version_number => l_api_version_number
1882: , p_init_msg_lst => fnd_api.g_false
1883: , x_return_status => x_return_status
1884: , x_msg_count => x_msg_count
1885: , x_msg_data => x_msg_data
1886: , p_organization_id => p_organization_id

Line 1921: x_return_status := fnd_api.g_ret_sts_unexp_error;

1917: --
1918: if iteminfo%isopen then
1919: close iteminfo;
1920: end if;
1921: x_return_status := fnd_api.g_ret_sts_unexp_error;
1922: fnd_msg_pub.count_and_get( p_count => x_msg_count
1923: ,p_data => x_msg_data );
1924:
1925: END UPDATE_QUANTITY;

Line 2022: , p_init_msg_lst => fnd_api.g_false

2018: end if;
2019:
2020: inv_quantity_tree_pub.update_quantities
2021: ( p_api_version_number => l_api_version_number
2022: , p_init_msg_lst => fnd_api.g_false
2023: , x_return_status => x_return_status
2024: , x_msg_count => x_msg_count
2025: , x_msg_data => x_msg_data
2026: , p_organization_id => p_organization_id

Line 2073: x_return_status := fnd_api.g_ret_sts_unexp_error;

2069: --
2070: if iteminfo%isopen then
2071: close iteminfo;
2072: end if;
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;
2074: fnd_msg_pub.count_and_get( p_count => x_msg_count
2075: ,p_data => x_msg_data );
2076:
2077: END UPDATE_QUANTITY;