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_RUNTIME_CAMP_PVT

Line 1: PACKAGE BODY AMS_RUNTIME_CAMP_PVT as

1: PACKAGE BODY AMS_RUNTIME_CAMP_PVT as
2: /* $Header: amsvrcab.pls 120.1 2005/10/04 03:28:29 sikalyan noship $*/
3:
4:
5: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 131: l_off_rec_type AMS_RUNTIME_CAMP_PVT.off_rec_type;

127:
128:
129: l_api_name CONSTANT VARCHAR2(30) := 'getFilteredOffersIds';
130: l_api_version CONSTANT NUMBER := 1.0;
131: l_off_rec_type AMS_RUNTIME_CAMP_PVT.off_rec_type;
132: l_off_rec_type_tbl AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
133: l_counter NUMBER := 0;
134:
135:

Line 132: l_off_rec_type_tbl AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;

128:
129: l_api_name CONSTANT VARCHAR2(30) := 'getFilteredOffersIds';
130: l_api_version CONSTANT NUMBER := 1.0;
131: l_off_rec_type AMS_RUNTIME_CAMP_PVT.off_rec_type;
132: l_off_rec_type_tbl AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
133: l_counter NUMBER := 0;
134:
135:
136: BEGIN

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 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 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 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 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 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 1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;

1468: l_found BOOLEAN := FALSE;
1469: act_offer_lst JTF_Number_Table;
1470: l_offer_lst1 JTF_Number_Table;
1471: l_offer_lst2 JTF_Number_Table;
1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
1473: l_validate_qp_list_header_id NUMBER;
1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1475:
1476: BEGIN

Line 1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

1470: l_offer_lst1 JTF_Number_Table;
1471: l_offer_lst2 JTF_Number_Table;
1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
1473: l_validate_qp_list_header_id NUMBER;
1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1475:
1476: BEGIN
1477: -- Standard call to check for call compatibility.
1478: IF NOT FND_API.Compatible_API_Call( l_api_version,

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 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 1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1940: l_counter NUMBER := 0;
1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
1942:
1943: BEGIN

Line 1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;

1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1940: l_counter NUMBER := 0;
1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
1942:
1943: BEGIN
1944: -- Standard call to check for call compatibility.
1945: IF NOT FND_API.Compatible_API_Call( l_api_version,

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 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 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 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 2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

2335: l_offer_lst JTF_Number_Table;
2336: l_offer_lst1 JTF_Number_Table;
2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;
2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
2340: l_counter NUMBER := 0;
2341: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
2342:
2343:

Line 2341: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;

2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;
2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
2340: l_counter NUMBER := 0;
2341: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
2342:
2343:
2344:
2345: BEGIN

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 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 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 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.

Line 2802: END AMS_RUNTIME_CAMP_PVT;

2798:
2799: END getRelOffersForProdAndCust;
2800:
2801:
2802: END AMS_RUNTIME_CAMP_PVT;