[Home] [Help]
197: l_items_in_clause VARCHAR2(32760);
198:
199:
200: BEGIN
201: -- Standard call to check for call compatibility.
202: IF NOT FND_API.Compatible_API_Call( l_api_version,
203: p_api_version_number,
204: l_api_name,
205: G_PKG_NAME )
382: IF (AMS_DEBUG_HIGH_ON) THEN
383: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
384: END IF;
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data);
390:
543: l_items_in_clause VARCHAR2(32760);
544:
545:
546: BEGIN
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call( l_api_version,
549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME )
674: IF (AMS_DEBUG_HIGH_ON) THEN
675: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');
676: END IF;
677:
678: -- Standard call to get message count and if count is 1, get message info.
679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:
892: i PLS_INTEGER := 1;
893: l_random NUMBER;
894:
895: BEGIN
896: -- Standard call to check for call compatibility.
897: IF NOT FND_API.Compatible_API_Call( l_api_version,
898: p_api_version_number,
899: l_api_name,
900: G_PKG_NAME )
1073: IF (AMS_DEBUG_HIGH_ON) THEN
1074: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList ends');
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info.
1078: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1079: p_count => x_msg_count,
1080: p_data => x_msg_data);
1081:
1146: l_max NUMBER;
1147: l_limit NUMBER;
1148:
1149: BEGIN
1150: -- Standard call to check for call compatibility.
1151: IF NOT FND_API.Compatible_API_Call( l_api_version,
1152: p_api_version_number,
1153: l_api_name,
1154: G_PKG_NAME )
1275: IF (AMS_DEBUG_HIGH_ON) THEN
1276: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
1277: END IF;
1278:
1279: -- Standard call to get message count and if count is 1, get message info.
1280: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1347: l_max NUMBER;
1348: l_limit NUMBER;
1349:
1350: BEGIN
1351: -- Standard call to check for call compatibility.
1352: IF NOT FND_API.Compatible_API_Call( l_api_version,
1353: p_api_version_number,
1354: l_api_name,
1355: G_PKG_NAME )
1464:
1465:
1466: END IF;
1467:
1468: -- Standard call to get message count and if count is 1, get message info.
1469: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1470: p_count => x_msg_count ,
1471: p_data => x_msg_data );
1472:
1543: found BOOLEAN;
1544: p_in_prod_lst JTF_VARCHAR2_TABLE_100;
1545:
1546: BEGIN
1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.Compatible_API_Call( l_api_version,
1549: p_api_version_number,
1550: l_api_name,
1551: G_PKG_NAME )
1710: END IF;
1711:
1712: -- End of API body.
1713:
1714: -- Standard call to get message count and if count is 1, get message info.
1715: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data);
1718:
1811: l_uomcode VARCHAR2(3);
1812: l_uomcode_tbl JTF_VARCHAR2_TABLE_100;
1813:
1814: BEGIN
1815: -- Standard call to check for call compatibility.
1816: IF NOT FND_API.Compatible_API_Call( l_api_version,
1817: p_api_version,
1818: l_api_name,
1819: G_PKG_NAME )
1841: IF (AMS_DEBUG_HIGH_ON) THEN
1842: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');
1843: END IF;
1844:
1845: -- Standard call to get message count and if count is 1, get message info.
1846: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1847: p_count => x_msg_count ,
1848: p_data => x_msg_data );
1849: return;
1911: END IF;
1912:
1913: -- End of API body.
1914:
1915: -- Standard call to get message count and if count is 1, get message info.
1916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1917: p_count => x_msg_count,
1918: p_data => x_msg_data);
1919:
1983:
1984:
1985: BEGIN
1986:
1987: -- Standard call to check for call compatibility.
1988: IF NOT FND_API.Compatible_API_Call( l_api_version,
1989: p_api_version_number,
1990: l_api_name,
1991: G_PKG_NAME )
2086: IF (AMS_DEBUG_HIGH_ON) THEN
2087: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');
2088: END IF;
2089:
2090: -- Standard call to get message count and if count is 1, get message info.
2091: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2092: p_count => x_msg_count,
2093: p_data => x_msg_data);
2094:
2155: l_limit NUMBER;
2156: l_index BINARY_INTEGER;
2157:
2158: BEGIN
2159: -- Standard call to check for call compatibility.
2160: IF NOT FND_API.Compatible_API_Call( l_api_version,
2161: p_api_version_number,
2162: l_api_name,
2163: G_PKG_NAME )
2232: IF (AMS_DEBUG_HIGH_ON) THEN
2233: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');
2234: END IF;
2235:
2236: -- Standard call to get message count and if count is 1, get message info.
2237: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2238: p_count => x_msg_count ,
2239: p_data => x_msg_data );
2240: