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);
6: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9:
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);
6: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9:
10: PROCEDURE sortRandom
3:
4:
5: AMS_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9:
10: PROCEDURE sortRandom
11: (
145: END IF;
146:
147: -- Initialize message list if p_init_msg_list is set to TRUE.
148: IF FND_API.to_Boolean( p_init_msg_list ) THEN
149: FND_MSG_PUB.initialize;
150: END IF;
151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: EXCEPTION
185:
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: p_data => x_msg_data);
191:
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);
197:
198: WHEN OTHERS THEN
196: p_data => x_msg_data);
197:
198: WHEN OTHERS THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
202: END IF;
203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
197:
198: WHEN OTHERS THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
202: END IF;
203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data);
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
201: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
202: END IF;
203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
204: p_count => x_msg_count,
205: p_data => x_msg_data);
206:
207: END getFilteredOfferIds;
353: END IF;
354:
355: -- Initialize message list if p_init_msg_list is set to TRUE.
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Initialize API return status to success
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
544: p_count => x_msg_count ,
545: p_data => x_msg_data );
546:
547: EXCEPTION
546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count ,
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: p_data => x_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count ,
558: p_data => x_msg_data );
559:
560:
560:
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
566: l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
566: l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count ,
564: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
566: l_api_name );
567: END IF;
568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count ,
570: p_data => x_msg_data );
571:
572: END getFilteredSchedulesFromList;
727: END IF;
728:
729: -- Initialize message list if p_init_msg_list is set to TRUE.
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733:
734: -- Initialize API return status to success
735: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
808: p_count => x_msg_count ,
809: p_data => x_msg_data );
810: return;
811: END IF;
924:
925: END IF;
926:
927: -- Standard call to get message count and if count is 1, get message info.
928: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count ,
930: p_data => x_msg_data );
931:
932: EXCEPTION
931:
932: EXCEPTION
933: WHEN FND_API.G_EXC_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count ,
937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: p_data => x_msg_data );
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count ,
943: p_data => x_msg_data );
944:
945:
945:
946: WHEN OTHERS THEN
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948:
949: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
951: l_api_name );
952: END IF;
953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
946: WHEN OTHERS THEN
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948:
949: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
951: l_api_name );
952: END IF;
953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count ,
949: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
950: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
951: l_api_name );
952: END IF;
953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
954: p_count => x_msg_count ,
955: p_data => x_msg_data );
956:
957: END getRelSchedulesForQuoteAndCust;
1113: END IF;
1114:
1115: -- Initialize message list if p_init_msg_list is set to TRUE.
1116: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: -- Initialize API return status to success
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
1191: p_count => x_msg_count ,
1192: p_data => x_msg_data );
1193: return;
1194: END IF;
1365:
1366: END IF;
1367:
1368: -- Standard call to get message count and if count is 1, get message info.
1369: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1370: p_count => x_msg_count,
1371: p_data => x_msg_data);
1372:
1373: EXCEPTION
1372:
1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: p_data => x_msg_data);
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data);
1385:
1386:
1386:
1387: WHEN OTHERS THEN
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1392: END IF;
1393:
1394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1387: WHEN OTHERS THEN
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389:
1390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1392: END IF;
1393:
1394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1392: END IF;
1393:
1394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397:
1398: END getRelSchedulesForProdAndCust;
1484: END IF;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE.
1487: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491: -- Initialize API return status to success
1492: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
1628: p_count => x_msg_count ,
1629: p_data => x_msg_data );
1630:
1631: return;
1820: END IF;
1821:
1822: -- Standard call to get message count and if count is 1, get message info.
1823:
1824: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1825: p_count => x_msg_count,
1826: p_data => x_msg_data);
1827:
1828: EXCEPTION
1828: EXCEPTION
1829:
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1833: p_count => x_msg_count,
1834: p_data => x_msg_data);
1835:
1836:
1835:
1836:
1837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data);
1842:
1843:
1843:
1844: WHEN OTHERS THEN
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846:
1847: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1849: l_api_name);
1850: END IF;
1851: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1844: WHEN OTHERS THEN
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846:
1847: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1849: l_api_name);
1850: END IF;
1851: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1852: p_count => x_msg_count,
1847: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1849: l_api_name);
1850: END IF;
1851: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data);
1854:
1855: END getFilteredOffersFromList;
1951: END IF;
1952:
1953: -- Initialize message list if p_init_msg_list is set to TRUE.
1954: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1955: FND_MSG_PUB.initialize;
1956: END IF;
1957:
1958: -- Initialize API return status to success
1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
2025: p_count => x_msg_count,
2026: p_data => x_msg_data);
2027: return;
2028: ELSE
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,
2084: p_count => x_msg_count,
2085: p_data => x_msg_data);
2086: RETURN;
2087:
2239:
2240: END IF;
2241:
2242: -- Standard call to get message count and if count is 1, get message info.
2243: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2244: p_count => x_msg_count,
2245: p_data => x_msg_data);
2246:
2247: EXCEPTION
2246:
2247: EXCEPTION
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_ERROR;
2250: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data);
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2252: p_data => x_msg_data);
2253:
2254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2257: p_count => x_msg_count,
2258: p_data => x_msg_data);
2259:
2260: WHEN OTHERS THEN
2259:
2260: WHEN OTHERS THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2262:
2263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2265: END IF;
2266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2267: p_count => x_msg_count,
2260: WHEN OTHERS THEN
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2262:
2263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2265: END IF;
2266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2267: p_count => x_msg_count,
2268: p_data => x_msg_data);
2262:
2263: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
2265: END IF;
2266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2267: p_count => x_msg_count,
2268: p_data => x_msg_data);
2269:
2270: END getRelOffersForQuoteAndCust;
2355:
2356:
2357: -- Initialize message list if p_init_msg_list is set to TRUE.
2358: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2359: FND_MSG_PUB.initialize;
2360: END IF;
2361:
2362: -- Initialize API return status to success
2363: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444: RETURN;
2445:
2528:
2529: END IF;
2530:
2531: -- Standard call to get message count and if count is 1, get message info.
2532: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2533: p_count => x_msg_count,
2534: p_data => x_msg_data);
2535: return;
2536:
2767:
2768: END IF;
2769:
2770: -- Standard call to get message count and if count is 1, get message info.
2771: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774:
2775: EXCEPTION
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2780: p_count => x_msg_count,
2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: p_data => x_msg_data);
2782:
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2786: p_count => x_msg_count,
2787: p_data => x_msg_data);
2788:
2789: WHEN OTHERS THEN
2788:
2789: WHEN OTHERS THEN
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791:
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2794: END IF;
2795: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2796: p_count => x_msg_count,
2789: WHEN OTHERS THEN
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791:
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2794: END IF;
2795: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2796: p_count => x_msg_count,
2797: p_data => x_msg_data);
2791:
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2793: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2794: END IF;
2795: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2796: p_count => x_msg_count,
2797: p_data => x_msg_data);
2798:
2799: END getRelOffersForProdAndCust;