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_CAMP_PVT dependencies on AMS_UTILITY_PVT

Line 29: AMS_UTILITY_PVT.debug_message('random sorting starts');

25: IF (AMS_DEBUG_HIGH_ON) THEN
26:
27:
28:
29: AMS_UTILITY_PVT.debug_message('random sorting starts');
30:
31: END IF;
32: l_input_lst := JTF_NUMBER_TABLE();
33: x_output_lst := JTF_NUMBER_TABLE();

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

46: l_randoms.EXTEND;
47: l_randoms(i) := dbms_random.value;
48: IF (AMS_DEBUG_HIGH_ON) THEN
49:
50: AMS_UTILITY_PVT.debug_message('random value '||to_char(l_randoms(i))||' for '||p_input_lst(i));
51: END IF;
52: end loop;
53:
54: -- then , do bubble sort the ids based on random numbers values

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

91: end loop;
92: END IF;
93: IF (AMS_DEBUG_HIGH_ON) THEN
94:
95: AMS_UTILITY_PVT.debug_message('random sorting ends');
96: END IF;
97: END sortRandom;
98:
99:

Line 157: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOfferIds starts');

153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155:
156: IF (AMS_DEBUG_HIGH_ON) THEN
157: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOfferIds starts');
158: END IF;
159:
160: FOR i IN 1..p_offer_lst.COUNT
161: LOOP

Line 181: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOfferIds Ends');

177:
178: x_offer_qp_lst := l_off_rec_type_tbl;
179:
180: IF (AMS_DEBUG_HIGH_ON) THEN
181: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOfferIds Ends');
182: END IF;
183:
184: EXCEPTION
185:

Line 364: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredSchedulesFromList starts '||p_party_id);

360: -- Initialize API return status to success
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: IF (AMS_DEBUG_HIGH_ON) THEN
364: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredSchedulesFromList starts '||p_party_id);
365: END IF;
366:
367: IF(p_max_ret_num IS NULL) THEN
368: --max return no is null

Line 390: -- AMS_UTILITY_PVT.debug_message(l_sched_in_clause1);

386: -- p_Index := p_sched_lst.LAST;
387: -- l_sched_in_clause1 := l_sched_in_clause1 || TO_CHAR( p_sched_lst( p_Index ) ) || ')';
388:
389: -- IF (AMS_DEBUG_HIGH_ON) THEN
390: -- AMS_UTILITY_PVT.debug_message(l_sched_in_clause1);
391: -- END IF;
392:
393: IF(p_bus_prior_order IS NULL OR p_bus_prior_order = 'ASC' OR p_bus_prior_order <> 'DESC') THEN
394: l_order := 'ASC';

Line 538: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredSchedulesFromList ends');

534: IF (AMS_DEBUG_HIGH_ON) THEN
535:
536:
537:
538: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredSchedulesFromList ends');
539:
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.

Line 741: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust starts');

737: IF (AMS_DEBUG_HIGH_ON) THEN
738:
739:
740:
741: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust starts');
742:
743: END IF;
744:
745: IF(p_max_ret_num IS NULL) THEN

Line 791: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');

787:
788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF (AMS_DEBUG_HIGH_ON) THEN
790:
791: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
792: END IF;
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795:

Line 799: AMS_UTILITY_PVT.debug_message('No Products returned');

795:
796: IF l_quote_prod_lst.COUNT = 0 THEN
797: IF (AMS_DEBUG_HIGH_ON) THEN
798:
799: AMS_UTILITY_PVT.debug_message('No Products returned');
800: END IF;
801: IF (AMS_DEBUG_HIGH_ON) THEN
802:
803: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');

Line 803: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');

799: AMS_UTILITY_PVT.debug_message('No Products returned');
800: END IF;
801: IF (AMS_DEBUG_HIGH_ON) THEN
802:
803: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
804: END IF;
805:
806: -- Standard call to get message count and if count is 1, get message info.
807: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 826: AMS_UTILITY_PVT.debug_message(l_items_in_clause1);

822: IF (AMS_DEBUG_HIGH_ON) THEN
823:
824:
825:
826: AMS_UTILITY_PVT.debug_message(l_items_in_clause1);
827:
828: END IF;
829:
830: --collect the schedules containing those items

Line 923: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');

919: -- End of API body.
920:
921: IF (AMS_DEBUG_HIGH_ON) THEN
922:
923: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
924:
925: END IF;
926:
927: -- Standard call to get message count and if count is 1, get message info.

Line 1127: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust starts');

1123: IF (AMS_DEBUG_HIGH_ON) THEN
1124:
1125:
1126:
1127: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust starts');
1128:
1129: END IF;
1130:
1131: IF(p_max_ret_num IS NULL) THEN

Line 1174: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');

1170:
1171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1172: IF (AMS_DEBUG_HIGH_ON) THEN
1173:
1174: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
1175: END IF;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:

Line 1182: AMS_UTILITY_PVT.debug_message('No Products returned');

1178:
1179: IF l_prod_lst.COUNT = 0 THEN
1180: IF (AMS_DEBUG_HIGH_ON) THEN
1181:
1182: AMS_UTILITY_PVT.debug_message('No Products returned');
1183: END IF;
1184: IF (AMS_DEBUG_HIGH_ON) THEN
1185:
1186: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');

Line 1186: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');

1182: AMS_UTILITY_PVT.debug_message('No Products returned');
1183: END IF;
1184: IF (AMS_DEBUG_HIGH_ON) THEN
1185:
1186: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');
1187: END IF;
1188:
1189: -- Standard call to get message count and if count is 1, get message info.
1190: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1207: AMS_UTILITY_PVT.debug_message(l_items_in_clause1);

1203: l_items_in_clause1 := l_items_in_clause1 || TO_CHAR( l_prod_lst( p_Index ) ) || ')';
1204:
1205: IF (AMS_DEBUG_HIGH_ON) THEN
1206:
1207: AMS_UTILITY_PVT.debug_message(l_items_in_clause1);
1208:
1209: END IF;
1210:
1211:

Line 1364: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');

1360: IF (AMS_DEBUG_HIGH_ON) THEN
1361:
1362:
1363:
1364: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');
1365:
1366: END IF;
1367:
1368: -- Standard call to get message count and if count is 1, get message info.

Line 1496: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOffersFromList starts');

1492: x_return_status := FND_API.G_RET_STS_SUCCESS;
1493:
1494:
1495: IF (AMS_DEBUG_HIGH_ON) THEN
1496: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOffersFromList starts');
1497: END IF;
1498:
1499:
1500: -- Validation on the required parameters

Line 1553: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');

1549: l_cust_account_id := p_cust_account_id;
1550:
1551:
1552: IF (AMS_DEBUG_HIGH_ON) THEN
1553: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1554: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1555: END IF;
1556:
1557: /*

Line 1554: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');

1550:
1551:
1552: IF (AMS_DEBUG_HIGH_ON) THEN
1553: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1554: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1555: END IF;
1556:
1557: /*
1558: AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig(

Line 1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');

1599:
1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: IF (AMS_DEBUG_HIGH_ON) THEN
1602:
1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1605: END IF;
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;

Line 1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');

1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: IF (AMS_DEBUG_HIGH_ON) THEN
1602:
1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1605: END IF;
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;
1608:

Line 1618: AMS_UTILITY_PVT.debug_message('No Offers returned');

1614:
1615: IF x_offers_tbl.COUNT = 0 THEN
1616: IF (AMS_DEBUG_HIGH_ON) THEN
1617:
1618: AMS_UTILITY_PVT.debug_message('No Offers returned');
1619: END IF;
1620:
1621: IF (AMS_DEBUG_HIGH_ON) THEN
1622: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

Line 1622: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1618: AMS_UTILITY_PVT.debug_message('No Offers returned');
1619: END IF;
1620:
1621: IF (AMS_DEBUG_HIGH_ON) THEN
1622: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.

Line 1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1619: END IF;
1620:
1621: IF (AMS_DEBUG_HIGH_ON) THEN
1622: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1668: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);

1664: p_Index := x_offer_lst.LAST;
1665: l_offer_in_clause1 := l_offer_in_clause1 || TO_CHAR( x_offer_lst( p_Index ) ) || ')';
1666:
1667: IF (AMS_DEBUG_HIGH_ON) THEN
1668: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);
1669: END IF;
1670:
1671: IF(p_bus_prior_order IS NULL OR p_bus_prior_order = 'ASC' OR p_bus_prior_order <> 'DESC') THEN
1672: l_order := 'ASC';

Line 1813: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1809:
1810: -- End of API body.
1811:
1812: IF (AMS_DEBUG_HIGH_ON) THEN
1813: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1814: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1815:
1816: END IF;
1817:

Line 1814: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1810: -- End of API body.
1811:
1812: IF (AMS_DEBUG_HIGH_ON) THEN
1813: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1814: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1815:
1816: END IF;
1817:
1818: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1819: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOffersFromList ends');

1815:
1816: END IF;
1817:
1818: IF (AMS_DEBUG_HIGH_ON) THEN
1819: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getFilteredOffersFromList ends');
1820: END IF;
1821:
1822: -- Standard call to get message count and if count is 1, get message info.
1823:

Line 1963: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuoteAndCust starts');

1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1960:
1961: IF (AMS_DEBUG_HIGH_ON) THEN
1962:
1963: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuoteAndCust starts');
1964:
1965: END IF;
1966:
1967: IF(p_max_ret_num IS NULL) THEN

Line 2010: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');

2006: END IF;
2007:
2008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2009: IF (AMS_DEBUG_HIGH_ON) THEN
2010: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForQuoteAndCust');
2011: END IF;
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:

Line 2017: AMS_UTILITY_PVT.debug_message('No Products returned');

2013: END IF;
2014:
2015: IF l_quote_prod_lst.COUNT = 0 THEN
2016: IF (AMS_DEBUG_HIGH_ON) THEN
2017: AMS_UTILITY_PVT.debug_message('No Products returned');
2018: END IF;
2019: IF (AMS_DEBUG_HIGH_ON) THEN
2020: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
2021: END IF;

Line 2020: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');

2016: IF (AMS_DEBUG_HIGH_ON) THEN
2017: AMS_UTILITY_PVT.debug_message('No Products returned');
2018: END IF;
2019: IF (AMS_DEBUG_HIGH_ON) THEN
2020: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForQuoteAndCust ends');
2021: END IF;
2022:
2023: -- Standard call to get message count and if count is 1, get message info.
2024: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2064: );
2065:
2066: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2067: IF (AMS_DEBUG_HIGH_ON) THEN
2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;

Line 2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2065:
2066: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2067: IF (AMS_DEBUG_HIGH_ON) THEN
2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2076: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');

2072: END IF;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074: IF l_offer_tbl.COUNT = 0 THEN
2075: IF (AMS_DEBUG_HIGH_ON) THEN
2076: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');
2077: END IF;
2078: IF (AMS_DEBUG_HIGH_ON) THEN
2079: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuotAndCust ends');
2080: END IF;

Line 2079: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuotAndCust ends');

2075: IF (AMS_DEBUG_HIGH_ON) THEN
2076: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');
2077: END IF;
2078: IF (AMS_DEBUG_HIGH_ON) THEN
2079: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuotAndCust ends');
2080: END IF;
2081:
2082: -- Standard call to get message count and if count is 1, get message info.
2083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2093: AMS_UTILITY_PVT.debug_message('# of Offers: '|| l_offer_tbl.COUNT);

2089:
2090: -- There are some offers
2091: -- convert l_offer_tbl to x_offer_list
2092: IF (AMS_DEBUG_HIGH_ON) THEN
2093: AMS_UTILITY_PVT.debug_message('# of Offers: '|| l_offer_tbl.COUNT);
2094: END IF;
2095:
2096: -- temp_offer_lst := JTF_Number_Table();
2097:

Line 2121: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);

2117: p_Index := l_in_offer_lst.LAST;
2118: l_offer_in_clause1 := l_offer_in_clause1 || TO_CHAR( l_in_offer_lst( p_Index ) ) || ')';
2119:
2120: IF (AMS_DEBUG_HIGH_ON) THEN
2121: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);
2122: END IF;
2123:
2124: IF(p_bus_prior_order IS NULL OR p_bus_prior_order = 'ASC' OR p_bus_prior_order <> 'DESC') THEN
2125: l_order := 'ASC';

Line 2238: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuoteAndCust ends');

2234: -- End of API body.
2235:
2236: IF (AMS_DEBUG_HIGH_ON) THEN
2237:
2238: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForQuoteAndCust ends');
2239:
2240: END IF;
2241:
2242: -- Standard call to get message count and if count is 1, get message info.

Line 2369: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts');

2365: IF (AMS_DEBUG_HIGH_ON) THEN
2366:
2367:
2368:
2369: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts');
2370:
2371: END IF;
2372:
2373: IF(p_max_ret_num IS NULL) THEN

Line 2378: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts max ret null');

2374: --max return no is null
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: IF (AMS_DEBUG_HIGH_ON) THEN
2377:
2378: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust starts max ret null');
2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: END IF;
2382:

Line 2424: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');

2420:
2421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2422: IF (AMS_DEBUG_HIGH_ON) THEN
2423:
2424: AMS_UTILITY_PVT.debug_message('Problem in AMS_RUNTIME_PROD_PVT.getRelProdsForProdAndCust');
2425: END IF;
2426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2427: END IF;
2428:

Line 2433: AMS_UTILITY_PVT.debug_message('No Products returned');

2429:
2430: IF l_prod_lst.COUNT = 0 THEN
2431: IF (AMS_DEBUG_HIGH_ON) THEN
2432:
2433: AMS_UTILITY_PVT.debug_message('No Products returned');
2434: END IF;
2435: IF (AMS_DEBUG_HIGH_ON) THEN
2436:
2437: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');

Line 2437: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');

2433: AMS_UTILITY_PVT.debug_message('No Products returned');
2434: END IF;
2435: IF (AMS_DEBUG_HIGH_ON) THEN
2436:
2437: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelSchedulesForProdAndCust ends');
2438: END IF;
2439:
2440: -- Standard call to get message count and if count is 1, get message info.
2441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2459: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust We have list of products');

2455: IF (AMS_DEBUG_HIGH_ON) THEN
2456:
2457:
2458:
2459: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust We have list of products');
2460:
2461: END IF;
2462:
2463: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2467: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust Get all the offer for the products call find_product_elig');

2463: IF (AMS_DEBUG_HIGH_ON) THEN
2464:
2465:
2466:
2467: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust Get all the offer for the products call find_product_elig');
2468:
2469: END IF;
2470:
2471: -- Get all the offer for the products - call find_product_elig.

Line 2502: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust Get all the offer for the products ends find_product_elig');

2498: l_offer_tbl
2499: );
2500:
2501: IF (AMS_DEBUG_HIGH_ON) THEN
2502: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust Get all the offer for the products ends find_product_elig');
2503: END IF;
2504:
2505:
2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2505:
2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2507: IF (AMS_DEBUG_HIGH_ON) THEN
2508:
2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;

Line 2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2507: IF (AMS_DEBUG_HIGH_ON) THEN
2508:
2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514:

Line 2520: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');

2516:
2517: IF l_offer_tbl.COUNT = 0 THEN
2518: IF (AMS_DEBUG_HIGH_ON) THEN
2519:
2520: AMS_UTILITY_PVT.debug_message('No Offers for the products being viewed');
2521: END IF;
2522:
2523: IF (AMS_DEBUG_HIGH_ON) THEN
2524:

Line 2527: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust ends');

2523: IF (AMS_DEBUG_HIGH_ON) THEN
2524:
2525:
2526:
2527: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust ends');
2528:
2529: END IF;
2530:
2531: -- Standard call to get message count and if count is 1, get message info.

Line 2546: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust count is more than one');

2542:
2543:
2544:
2545:
2546: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust count is more than one');
2547:
2548:
2549: END IF;
2550:

Line 2555: AMS_UTILITY_PVT.debug_message('# of Offers: '|| l_offer_tbl.COUNT);

2551: -- There are some offers
2552: -- convert l_offer_tbl to x_offer_list
2553: IF (AMS_DEBUG_HIGH_ON) THEN
2554:
2555: AMS_UTILITY_PVT.debug_message('# of Offers: '|| l_offer_tbl.COUNT);
2556: END IF;
2557:
2558: FOR i in l_offer_tbl.first .. l_offer_tbl.last
2559: LOOP

Line 2586: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);

2582: l_offer_in_clause1 := l_offer_in_clause1 || TO_CHAR( x_offer_lst( p_Index ) ) || ')';
2583:
2584: IF (AMS_DEBUG_HIGH_ON) THEN
2585:
2586: AMS_UTILITY_PVT.debug_message(l_offer_in_clause1);
2587:
2588: END IF;
2589:
2590: IF(p_bus_prior_order IS NULL OR p_bus_prior_order = 'ASC' OR p_bus_prior_order <> 'DESC') THEN

Line 2766: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust ends');

2762: IF (AMS_DEBUG_HIGH_ON) THEN
2763:
2764:
2765:
2766: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_CAMP_PVT.getRelOffersForProdAndCust ends');
2767:
2768: END IF;
2769:
2770: -- Standard call to get message count and if count is 1, get message info.