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_UTILITY_PVT

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 233: AMS_UTILITY_PVT.debug_message('p_org_id : p_rel_type_code '

229: IF (AMS_DEBUG_HIGH_ON) THEN
230:
231:
232:
233: AMS_UTILITY_PVT.debug_message('p_org_id : p_rel_type_code '
234: || p_org_id || ' : '
235: || p_rel_type_code);
236:
237: END IF;

Line 258: AMS_UTILITY_PVT.debug_message('p_max_ret_num is NULL: relationship NOT in MTL. Top Section Id ' || To_CHAR(p_top_section_id));

254: IF (p_max_ret_num IS NULL) AND (NOT include_mtl) THEN -- Can use bulk fetching
255:
256: IF (AMS_DEBUG_HIGH_ON) THEN
257:
258: AMS_UTILITY_PVT.debug_message('p_max_ret_num is NULL: relationship NOT in MTL. Top Section Id ' || To_CHAR(p_top_section_id));
259:
260: END IF;
261:
262: IF (p_top_section_id IS NULL OR p_incl_section IS NULL) THEN

Line 288: AMS_UTILITY_PVT.debug_message('relationship in MTL. Top Section Id ' || To_CHAR(p_top_section_id));

284:
285: IF include_mtl THEN
286: IF (AMS_DEBUG_HIGH_ON) THEN
287:
288: AMS_UTILITY_PVT.debug_message('relationship in MTL. Top Section Id ' || To_CHAR(p_top_section_id));
289: END IF;
290: IF (p_top_section_id IS NULL OR p_incl_section IS NULL) THEN
291: --no Section Filtering, only Minisite Filtering
292: OPEN l_rel_items_csr FOR

Line 320: AMS_UTILITY_PVT.debug_message('p_max_ret_num is not NULL: relationship in MTL. Top Section Id ' || To_CHAR(p_top_section_id));

316:
317: ELSE -- don't need to do union with mtl_related_items
318: IF (AMS_DEBUG_HIGH_ON) THEN
319:
320: AMS_UTILITY_PVT.debug_message('p_max_ret_num is not NULL: relationship in MTL. Top Section Id ' || To_CHAR(p_top_section_id));
321: END IF;
322:
323: IF (p_top_section_id IS NULL OR p_incl_section IS NULL) THEN
324: --no Section Filtering, only Minisite Filtering

Line 376: AMS_UTILITY_PVT.debug_message('No of items collected ' || To_CHAR(x_items_tbl.COUNT));

372: IF (AMS_DEBUG_HIGH_ON) THEN
373:
374:
375:
376: AMS_UTILITY_PVT.debug_message('No of items collected ' || To_CHAR(x_items_tbl.COUNT));
377:
378: END IF;
379:
380: -- End of API body.

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 576: AMS_UTILITY_PVT.debug_message('p_org_id : p_rel_type_code = '

572: -- Initialize the return value table
573: x_items_tbl := JTF_Number_Table();
574:
575: IF (AMS_DEBUG_HIGH_ON) THEN
576: AMS_UTILITY_PVT.debug_message('p_org_id : p_rel_type_code = '
577: || TO_CHAR(p_org_id) || ' : ' || p_rel_type_code);
578: END IF;
579: -- Commented IN Clause BugFix 3776065
580: -- p_Index := p_prod_lst.FIRST;

Line 598: AMS_UTILITY_PVT.debug_message(' p_max_ret_num is NULL: relationship NOT in MTL.', FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);

594:
595: IF (p_max_ret_num IS NULL) AND (NOT include_mtl) THEN -- Can use bulk fetching
596: IF (AMS_DEBUG_HIGH_ON) THEN
597:
598: AMS_UTILITY_PVT.debug_message(' p_max_ret_num is NULL: relationship NOT in MTL.', FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
599: END IF;
600:
601: EXECUTE IMMEDIATE l_without_mtl_bulk_stmt ||
602: '; END;'

Line 607: AMS_UTILITY_PVT.debug_message(' relationship in MTL.');

603: USING OUT x_items_tbl, p_rel_type_code, p_org_id ,p_prod_lst;
604:
605: ELSE -- Cannot use bulk fetching
606: IF (AMS_DEBUG_HIGH_ON) THEN
607: AMS_UTILITY_PVT.debug_message(' relationship in MTL.');
608: END IF;
609:
610: IF include_mtl THEN -- must do union with mtl_related_items
611: IF (AMS_DEBUG_HIGH_ON) THEN

Line 612: AMS_UTILITY_PVT.debug_message('Mapping rule: relationship in MTL.'||l_items_in_clause);

608: END IF;
609:
610: IF include_mtl THEN -- must do union with mtl_related_items
611: IF (AMS_DEBUG_HIGH_ON) THEN
612: AMS_UTILITY_PVT.debug_message('Mapping rule: relationship in MTL.'||l_items_in_clause);
613: END IF;
614:
615: OPEN l_rel_items_csr FOR l_with_mtl_stmt1 ||
616: l_with_mtl_stmt2 ||

Line 628: AMS_UTILITY_PVT.debug_message('p_max_ret_num is NOT NULL: relationship in MTL.');

624:
625: ELSE -- don't need to do union with mtl_related_items
626: IF (AMS_DEBUG_HIGH_ON) THEN
627:
628: AMS_UTILITY_PVT.debug_message('p_max_ret_num is NOT NULL: relationship in MTL.');
629: END IF;
630:
631: OPEN l_rel_items_csr FOR l_without_mtl_stmt
632: USING p_rel_type_code, p_org_id, p_prod_lst;

Line 647: AMS_UTILITY_PVT.debug_message('Loop ');

643: ELSE
644: LOOP
645: IF (AMS_DEBUG_HIGH_ON) THEN
646:
647: AMS_UTILITY_PVT.debug_message('Loop ');
648: END IF;
649: FETCH l_rel_items_csr INTO l_rel_item_id;
650: EXIT WHEN l_rel_items_csr%NOTFOUND;
651: x_items_tbl.EXTEND;

Line 667: AMS_UTILITY_PVT.debug_message('Max ' || To_CHAR(p_max_ret_num));

663:
664: -- End of API body.
665:
666: IF (AMS_DEBUG_HIGH_ON) THEN
667: AMS_UTILITY_PVT.debug_message('Max ' || To_CHAR(p_max_ret_num));
668: END IF;
669:
670: IF (AMS_DEBUG_HIGH_ON) THEN
671: AMS_UTILITY_PVT.debug_message('No of items collected ' || To_CHAR(x_items_tbl.COUNT));

Line 671: AMS_UTILITY_PVT.debug_message('No of items collected ' || To_CHAR(x_items_tbl.COUNT));

667: AMS_UTILITY_PVT.debug_message('Max ' || To_CHAR(p_max_ret_num));
668: END IF;
669:
670: IF (AMS_DEBUG_HIGH_ON) THEN
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');

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 730: AMS_UTILITY_PVT.debug_message('random sorting starts');

726: IF (AMS_DEBUG_HIGH_ON) THEN
727:
728:
729:
730: AMS_UTILITY_PVT.debug_message('random sorting starts');
731:
732: END IF;
733: l_input_lst := JTF_NUMBER_TABLE();
734: x_output_lst := JTF_NUMBER_TABLE();

Line 751: AMS_UTILITY_PVT.debug_message('random value '||to_char(l_randoms(i))||' for '||p_input_lst(i));

747: l_randoms.EXTEND;
748: l_randoms(i) := dbms_random.value;
749: IF (AMS_DEBUG_HIGH_ON) THEN
750:
751: AMS_UTILITY_PVT.debug_message('random value '||to_char(l_randoms(i))||' for '||p_input_lst(i));
752: END IF;
753: end loop;
754:
755: -- then , do bubble sort the ids based on random numbers values

Line 796: AMS_UTILITY_PVT.debug_message('random sorting ends');

792: end loop;
793: END IF;
794: IF (AMS_DEBUG_HIGH_ON) THEN
795:
796: AMS_UTILITY_PVT.debug_message('random sorting ends');
797: END IF;
798: END sortRandom;
799:
800:

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 931: -- AMS_UTILITY_PVT.debug_message('items in clause '||l_items_in_clause);

927: -- p_Index := p_prod_lst.LAST;
928: -- l_items_in_clause := l_items_in_clause || TO_CHAR( p_prod_lst( p_Index ) ) || ')';
929:
930: -- IF (AMS_DEBUG_HIGH_ON) THEN
931: -- AMS_UTILITY_PVT.debug_message('items in clause '||l_items_in_clause);
932: -- END IF;
933:
934: IF(p_max_ret_num IS NULL) THEN
935: --max return no is null

Line 1015: AMS_UTILITY_PVT.debug_message('random');

1011:
1012: IF (p_max_ret_num IS NULL OR p_bus_prior = 'RANDOM'
1013: OR (p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL)) THEN
1014: IF (AMS_DEBUG_HIGH_ON) THEN
1015: AMS_UTILITY_PVT.debug_message('random');
1016: END IF;
1017: LOOP
1018: FETCH l_rel_items_csr INTO l_rel_item_id;
1019: EXIT WHEN l_rel_items_csr%NOTFOUND;

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 1176: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');

1172: -- 1. Check if the relationship exists and is active
1173: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
1174: IF (AMS_DEBUG_HIGH_ON) THEN
1175:
1176: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
1177: END IF;
1178: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1179: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1180: FND_MSG_PUB.Add;

Line 1210: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));

1206: IF SQL%ROWCOUNT = 0 THEN
1207: x_prod_lst := JTF_Number_Table();
1208: IF (AMS_DEBUG_HIGH_ON) THEN
1209:
1210: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
1211: END IF;
1212: ELSIF l_quote_prod_lst.COUNT = 0 THEN
1213: x_prod_lst := JTF_Number_Table();
1214: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1216: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));

1212: ELSIF l_quote_prod_lst.COUNT = 0 THEN
1213: x_prod_lst := JTF_Number_Table();
1214: IF (AMS_DEBUG_HIGH_ON) THEN
1215:
1216: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
1217: END IF;
1218: ELSE
1219: -- 3. Collect related items
1220: IF (p_msite_id IS NULL) THEN

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 1377: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');

1373: -- 1. Check if the relationship exists and is active
1374: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
1375: IF (AMS_DEBUG_HIGH_ON) THEN
1376:
1377: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
1378: END IF;
1379: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
1380: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
1381: FND_MSG_PUB.Add;

Line 1424: AMS_UTILITY_PVT.debug_message('Calling Price priority');

1420: -- 3. Get Prioritized Products if any Product Priority is given
1421: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL) THEN
1422: IF (AMS_DEBUG_HIGH_ON) THEN
1423:
1424: AMS_UTILITY_PVT.debug_message('Calling Price priority');
1425: END IF;
1426: getPrioritizedProds(
1427: p_api_version_number
1428: , FND_API.G_FALSE

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 1575: AMS_UTILITY_PVT.debug_message('Order of Sorting is : '||l_order);

1571: l_order := 'DESC';
1572: END IF;
1573:
1574: IF (AMS_DEBUG_HIGH_ON) THEN
1575: AMS_UTILITY_PVT.debug_message('Order of Sorting is : '||l_order);
1576: END IF;
1577:
1578: x_prod_lst := JTF_Number_Table();
1579: p_in_prod_lst := JTF_VARCHAR2_TABLE_100();

Line 1584: AMS_UTILITY_PVT.debug_message('sort Products by Product List Price in order '||l_order);

1580:
1581: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL AND p_prod_lst.COUNT > 1) THEN
1582: IF (AMS_DEBUG_HIGH_ON) THEN
1583:
1584: AMS_UTILITY_PVT.debug_message('sort Products by Product List Price in order '||l_order);
1585: END IF;
1586: -- Commented IN Clause BugFix 3776065
1587: -- l_Index := p_prod_lst.FIRST;
1588: -- FOR pNum IN 1..( p_prod_lst.COUNT - 1 ) LOOP

Line 1607: -- AMS_UTILITY_PVT.debug_message('item list '||l_items_in_clause);

1603: l_order
1604: USING p_price_list_id , p_in_prod_lst;
1605:
1606: -- IF (AMS_DEBUG_HIGH_ON) THEN
1607: -- AMS_UTILITY_PVT.debug_message('item list '||l_items_in_clause);
1608: -- END IF;
1609:
1610: i := 1;
1611: IF p_max_ret_num IS NULL THEN

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 1839: AMS_UTILITY_PVT.debug_message('No Products returned');

1835:
1836:
1837: IF p_itmid_tbl.COUNT = 0 THEN
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;

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 2018: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');

2014:
2015: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
2016:
2017: IF (AMS_DEBUG_HIGH_ON) THEN
2018: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
2019: END IF;
2020: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2021: FND_MESSAGE.Set_Token('RELATIONSHIP', p_rel_type_code);
2022: FND_MSG_PUB.Add;

Line 2041: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));

2037:
2038: IF (SQL%ROWCOUNT = 0) THEN
2039: x_prod_lst := JTF_Number_Table();
2040: IF (AMS_DEBUG_HIGH_ON) THEN
2041: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
2042: END IF;
2043:
2044: ELSIF (l_quote_prod_lst.COUNT = 0) THEN
2045: x_prod_lst := JTF_Number_Table();

Line 2047: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));

2043:
2044: ELSIF (l_quote_prod_lst.COUNT = 0) THEN
2045: x_prod_lst := JTF_Number_Table();
2046: IF (AMS_DEBUG_HIGH_ON) THEN
2047: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
2048: END IF;
2049: ELSE
2050: -- 3. Collect related items
2051: IF (p_msite_id IS NULL) THEN

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 2185: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');

2181: -- API body
2182: -- 1. Check if the relationship exists and is active
2183: IF NOT Is_Relationship_Valid(p_rel_type_code) THEN
2184: IF (AMS_DEBUG_HIGH_ON) THEN
2185: AMS_UTILITY_PVT.debug_message('Relationship is not valid.');
2186: END IF;
2187:
2188: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_NOT_VALID');
2189: FND_MESSAGE.Set_Token('RELATIONSHIP', 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,