eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_RUNTIME_PROD_PVT dependencies on AMS_RUNTIME_PROD_PVT

Line 1: PACKAGE BODY AMS_RUNTIME_PROD_PVT as

1: PACKAGE BODY AMS_RUNTIME_PROD_PVT as
2: /* $Header: amsvrpdb.pls 115.20 2004/07/27 14:06:48 sikalyan ship $*/
3:
4: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 222: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems starts');

218: IF (AMS_DEBUG_HIGH_ON) THEN
219:
220:
221:
222: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems starts');
223:
224: END IF;
225:
226: -- Initialize the return value table

Line 383: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');

379:
380: -- End of API body.
381:
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,

Line 568: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems starts');

564: IF (AMS_DEBUG_HIGH_ON) THEN
565:
566:
567:
568: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems starts');
569:
570: END IF;
571:
572: -- Initialize the return value table

Line 675: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelatedItems ends');

671: AMS_UTILITY_PVT.debug_message('No of items collected ' || To_CHAR(x_items_tbl.COUNT));
672: END IF;
673:
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,

Line 914: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList starts');

910: -- Initialize API return status to success
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912:
913: IF (AMS_DEBUG_HIGH_ON) THEN
914: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList starts');
915: END IF;
916:
917: -- Initialize the return value table
918: x_prod_lst := JTF_Number_Table();

Line 1074: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList ends');

1070:
1071: -- End of API body.
1072:
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,

Line 1168: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust starts');

1164: -- Initialize API return status to success
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166:
1167: IF (AMS_DEBUG_HIGH_ON) THEN
1168: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust starts');
1169: END IF;
1170:
1171: -- API body
1172: -- 1. Check if the relationship exists and is active

Line 1221: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

1217: END IF;
1218: ELSE
1219: -- 3. Collect related items
1220: IF (p_msite_id IS NULL) THEN
1221: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1222: :6, :7, :8, :9, :10, :11, :12 ); END;'
1223: USING IN l_api_version, IN FND_API.G_FALSE,
1224: IN p_application_id, IN l_quote_prod_lst,
1225: IN p_rel_type_code, IN p_org_id,

Line 1230: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

1226: IN l_max, IN l_null,
1227: OUT l_prod_lst,
1228: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1229: ELSE
1230: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1231: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
1232: USING IN l_api_version, IN FND_API.G_FALSE,
1233: IN p_application_id, IN p_msite_id,
1234: IN p_top_section_id, IN l_incl_top_section,

Line 1276: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');

1272:
1273: -- End of API body.
1274:
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,

Line 1369: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust starts');

1365: -- Initialize API return status to success
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367:
1368: IF (AMS_DEBUG_HIGH_ON) THEN
1369: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust starts');
1370: END IF;
1371:
1372: -- API body
1373: -- 1. Check if the relationship exists and is active

Line 1400: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

1396: END IF;
1397:
1398: -- 2. Collect related items
1399: IF (p_msite_id IS NULL) THEN
1400: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1401: :6, :7, :8, :9, :10, :11, :12 ); END;'
1402: USING IN l_api_version, IN FND_API.G_FALSE,
1403: IN p_application_id, IN p_prod_lst,
1404: IN p_rel_type_code, IN p_org_id,

Line 1409: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

1405: IN l_max, IN l_null,
1406: OUT l_prod_lst,
1407: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1408: ELSE
1409: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
1410: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
1411: USING IN l_api_version, IN FND_API.G_FALSE,
1412: IN p_application_id, IN p_msite_id,
1413: IN p_top_section_id, IN l_incl_top_section,

Line 1463: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');

1459:
1460:
1461:
1462:
1463: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');
1464:
1465:
1466: END IF;
1467:

Line 1565: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getPrioritizedProds starts');

1561: -- Initialize API return status to success
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563:
1564: IF (AMS_DEBUG_HIGH_ON) THEN
1565: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getPrioritizedProds starts');
1566: END IF;
1567:
1568: IF(p_bus_prior_order IS NULL OR p_bus_prior_order = 'ASC' OR p_bus_prior_order <> 'DESC') THEN
1569: l_order := 'ASC';

Line 1709: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getPrioritizedProds ends');

1705: END IF;
1706: END IF;
1707:
1708: IF (AMS_DEBUG_HIGH_ON) THEN
1709: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getPrioritizedProds ends');
1710: END IF;
1711:
1712: -- End of API body.
1713:

Line 1833: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails starts');

1829: -- Initialize API return status to success
1830: x_item_return_status := FND_API.G_RET_STS_SUCCESS;
1831:
1832: IF (AMS_DEBUG_HIGH_ON) THEN
1833: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails starts');
1834: END IF;
1835:
1836:
1837: IF p_itmid_tbl.COUNT = 0 THEN

Line 1842: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');

1838: IF (AMS_DEBUG_HIGH_ON) THEN
1839: AMS_UTILITY_PVT.debug_message('No Products returned');
1840: END IF;
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,

Line 1910: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');

1906:
1907: END IF;
1908:
1909: IF (AMS_DEBUG_HIGH_ON) THEN
1910: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.loadItemDetails ends');
1911: END IF;
1912:
1913: -- End of API body.
1914:

Line 2007: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForCart starts');

2003:
2004: x_return_status := FND_API.G_RET_STS_SUCCESS;
2005:
2006: IF (AMS_DEBUG_HIGH_ON) THEN
2007: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForCart starts');
2008: END IF;
2009:
2010:
2011: -- API body

Line 2052: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

2048: END IF;
2049: ELSE
2050: -- 3. Collect related items
2051: IF (p_msite_id IS NULL) THEN
2052: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
2053: :6, :7, :8, :9, :10, :11, :12 ); END;'
2054: USING IN l_api_version, IN FND_API.G_FALSE,
2055: IN p_application_id, IN l_quote_prod_lst,
2056: IN p_rel_type_code, IN p_org_id,

Line 2061: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,

2057: IN l_max, IN l_null,
2058: OUT l_prod_lst,
2059: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
2060: ELSE
2061: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,
2062: :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
2063: USING IN l_api_version, IN FND_API.G_FALSE,
2064: IN p_application_id, IN p_msite_id,
2065: IN p_top_section_id, IN l_incl_top_section,

Line 2087: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust ends');

2083: -- End of API body.
2084:
2085:
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,

Line 2178: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProd starts');

2174: -- Initialize API return status to success
2175: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
2176:
2177: IF (AMS_DEBUG_HIGH_ON) THEN
2178: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProd starts');
2179: END IF;
2180:
2181: -- API body
2182: -- 1. Check if the relationship exists and is active

Line 2201: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,:6, :7, :8, :9, :10, :11, :12 ); END;'

2197: -- 2. Collect related items
2198:
2199: IF (p_msite_id IS NULL) THEN
2200:
2201: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5,:6, :7, :8, :9, :10, :11, :12 ); END;'
2202: USING IN l_api_version, IN FND_API.G_FALSE,
2203: IN p_application_id, IN p_prod_lst,
2204: IN p_rel_type_code, IN p_org_id,
2205: IN l_max, IN l_null,

Line 2211: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'

2207: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
2208:
2209: ELSE
2210:
2211: EXECUTE IMMEDIATE 'BEGIN AMS_RUNTIME_PROD_PVT.getRelatedItems( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 ); END;'
2212: USING IN l_api_version, IN FND_API.G_FALSE,
2213: IN p_application_id, IN p_msite_id,
2214: IN p_top_section_id, IN l_incl_top_section,
2215: IN p_prod_lst, IN p_rel_type_code,

Line 2233: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust ends');

2229: -- End of API body.
2230:
2231:
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,

Line 2273: END AMS_RUNTIME_PROD_PVT;

2269:
2270:
2271: -- web lite code Ends here
2272:
2273: END AMS_RUNTIME_PROD_PVT;