[Home] [Help]
66: -- x_return_status OUT VARCHAR2
67: -- x_msg_count OUT NUMBER
68: -- x_msg_data OUT VARCHAR2
69: -- Version : Current version 1.0
70: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
71: -- and basic operation, developer must manually add parameters and business logic as necessary.
72: --
73: -- History
74: --
105: SELECT 1
106: FROM AMS_WEB_TRACKING
107: WHERE web_tracking_id = l_id;
108: BEGIN
109: -- Standard Start of API savepoint
110: SAVEPOINT create_web_track_pvt;
111:
112: --insert_log_mesg('SAVEPOINT create_web_track_pvt ::::');
113:
110: SAVEPOINT create_web_track_pvt;
111:
112: --insert_log_mesg('SAVEPOINT create_web_track_pvt ::::');
113:
114: -- Standard call to check for call compatibility.
115: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
116: p_api_version_number,
117: l_api_name,
118: G_PKG_NAME)
119: THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: --insert_log_mesg('Standard call to check for call compatibility');
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean( p_init_msg_list )
126: THEN
127: FND_MSG_PUB.initialize;
236: --
237: -- End of API body
238: --
239:
240: -- Standard check for p_commit
241: IF FND_API.to_Boolean( p_commit )
242: THEN
243: COMMIT WORK;
244: END IF;
247: -- Debug Message
248: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
249:
250:
251: -- Standard call to get message count and if count is 1, get message info.
252: FND_MSG_PUB.Count_And_Get
253: (p_count => x_msg_count,
254: p_data => x_msg_data
255: );
262:
263: WHEN FND_API.G_EXC_ERROR THEN
264: ROLLBACK TO create_web_track_pvt;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO create_web_track_pvt;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: -- Standard call to get message count and if count=1, get the message
278: FND_MSG_PUB.Count_And_Get (
279: p_encoded => FND_API.G_FALSE,
280: p_count => x_msg_count,
281: p_data => x_msg_data
287: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
290: END IF;
291: -- Standard call to get message count and if count=1, get the message
292: FND_MSG_PUB.Count_And_Get (
293: p_encoded => FND_API.G_FALSE,
294: p_count => x_msg_count,
295: p_data => x_msg_data
320: -- x_return_status OUT VARCHAR2
321: -- x_msg_count OUT NUMBER
322: -- x_msg_data OUT VARCHAR2
323: -- Version : Current version 1.0
324: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
325: -- and basic operation, developer must manually add parameters and business logic as necessary.
326: --
327: -- History
328: --
363: l_tar_web_track_rec web_track_rec_type := P_web_track_rec;
364: l_rowid ROWID;
365:
366: BEGIN
367: -- Standard Start of API savepoint
368: SAVEPOINT update_web_track_pvt;
369:
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
366: BEGIN
367: -- Standard Start of API savepoint
368: SAVEPOINT update_web_track_pvt;
369:
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
372: p_api_version_number,
373: l_api_name,
374: G_PKG_NAME)
484: --
485: -- End of API body.
486: --
487:
488: -- Standard check for p_commit
489: IF FND_API.to_Boolean( p_commit )
490: THEN
491: COMMIT WORK;
492: END IF;
495: -- Debug Message
496: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
497:
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get
501: (p_count => x_msg_count,
502: p_data => x_msg_data
503: );
509:
510: WHEN FND_API.G_EXC_ERROR THEN
511: ROLLBACK TO UPDATE_Web_Track_PVT;
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: -- Standard call to get message count and if count=1, get the message
514: FND_MSG_PUB.Count_And_Get (
515: p_encoded => FND_API.G_FALSE,
516: p_count => x_msg_count,
517: p_data => x_msg_data
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO UPDATE_Web_Track_PVT;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: -- Standard call to get message count and if count=1, get the message
524: FND_MSG_PUB.Count_And_Get (
525: p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => x_msg_data
533: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
536: END IF;
537: -- Standard call to get message count and if count=1, get the message
538: FND_MSG_PUB.Count_And_Get (
539: p_encoded => FND_API.G_FALSE,
540: p_count => x_msg_count,
541: p_data => x_msg_data
566: -- x_return_status OUT VARCHAR2
567: -- x_msg_count OUT NUMBER
568: -- x_msg_data OUT VARCHAR2
569: -- Version : Current version 1.0
570: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
571: -- and basic operation, developer must manually add parameters and business logic as necessary.
572: --
573: -- History
574: --
594: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
595: l_object_version_number NUMBER;
596:
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT delete_web_track_pvt;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
597: BEGIN
598: -- Standard Start of API savepoint
599: SAVEPOINT delete_web_track_pvt;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
603: p_api_version_number,
604: l_api_name,
605: G_PKG_NAME)
637: --
638: -- End of API body
639: --
640:
641: -- Standard check for p_commit
642: IF FND_API.to_Boolean( p_commit )
643: THEN
644: COMMIT WORK;
645: END IF;
648: -- Debug Message
649: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
650:
651:
652: -- Standard call to get message count and if count is 1, get message info.
653: FND_MSG_PUB.Count_And_Get
654: (p_count => x_msg_count,
655: p_data => x_msg_data
656: );
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO DELETE_Web_Track_PVT;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: ROLLBACK TO DELETE_Web_Track_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
687: THEN
688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
689: END IF;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
720: -- x_return_status OUT VARCHAR2
721: -- x_msg_count OUT NUMBER
722: -- x_msg_data OUT VARCHAR2
723: -- Version : Current version 1.0
724: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
725: -- and basic operation, developer must manually add parameters and business logic as necessary.
726: --
727: -- History
728: --
762: END IF;
763:
764:
765:
766: -- Standard call to check for call compatibility.
767: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
768: p_api_version_number,
769: l_api_name,
770: G_PKG_NAME)
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_Web_Track_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO LOCK_Web_Track_PVT;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
1216: l_object_version_number NUMBER;
1217: l_web_track_rec web_track_rec_type;
1218:
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT validate_web_track_;
1222:
1223: --insert_log_mesg('Standard Start of API savepoint');
1224:
1219: BEGIN
1220: -- Standard Start of API savepoint
1221: SAVEPOINT validate_web_track_;
1222:
1223: --insert_log_mesg('Standard Start of API savepoint');
1224:
1225: -- Standard call to check for call compatibility.
1226: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1227: p_api_version_number,
1221: SAVEPOINT validate_web_track_;
1222:
1223: --insert_log_mesg('Standard Start of API savepoint');
1224:
1225: -- Standard call to check for call compatibility.
1226: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1227: p_api_version_number,
1228: l_api_name,
1229: G_PKG_NAME)
1230: THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233:
1234: --insert_log_mesg('Standard call to check for call');
1235: -- Initialize message list if p_init_msg_list is set to TRUE.
1236: IF FND_API.to_Boolean( p_init_msg_list )
1237: THEN
1238: FND_MSG_PUB.initialize;
1297: -- Debug Message
1298: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1299:
1300:
1301: -- Standard call to get message count and if count is 1, get message info.
1302: FND_MSG_PUB.Count_And_Get
1303: (p_count => x_msg_count,
1304: p_data => x_msg_data
1305: );
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO VALIDATE_Web_Track_;
1314: x_return_status := FND_API.G_RET_STS_ERROR;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO VALIDATE_Web_Track_;
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: -- Standard call to get message count and if count=1, get the message
1326: FND_MSG_PUB.Count_And_Get (
1327: p_encoded => FND_API.G_FALSE,
1328: p_count => x_msg_count,
1329: p_data => x_msg_data
1335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1336: THEN
1337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1338: END IF;
1339: -- Standard call to get message count and if count=1, get the message
1340: FND_MSG_PUB.Count_And_Get (
1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data
1372: -- x_return_status := FND_API.G_RET_STS_ERROR;
1373:
1374: -- Debug Message
1375: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1376: -- Standard call to get message count and if count is 1, get message info.
1377: FND_MSG_PUB.Count_And_Get
1378: (p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );
1413: -- x_return_status OUT VARCHAR2
1414: -- x_msg_count OUT NUMBER
1415: -- x_msg_data OUT VARCHAR2
1416: -- Version : Current version 1.0
1417: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1418: -- and basic operation, developer must manually add parameters and business logic as necessary.
1419: --
1420: -- History
1421: --
1452: SELECT 1
1453: FROM AMS_WEB_RECOMMS
1454: WHERE web_recomm_id = l_id;
1455: BEGIN
1456: -- Standard Start of API savepoint
1457: SAVEPOINT create_web_recomms_pvt;
1458:
1459: -- Standard call to check for call compatibility.
1460: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1455: BEGIN
1456: -- Standard Start of API savepoint
1457: SAVEPOINT create_web_recomms_pvt;
1458:
1459: -- Standard call to check for call compatibility.
1460: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1461: p_api_version_number,
1462: l_api_name,
1463: G_PKG_NAME)
1576: --
1577: -- End of API body
1578: --
1579:
1580: -- Standard check for p_commit
1581: IF FND_API.to_Boolean( p_commit )
1582: THEN
1583: COMMIT WORK;
1584: END IF;
1587: -- Debug Message
1588: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1589:
1590:
1591: -- Standard call to get message count and if count is 1, get message info.
1592: FND_MSG_PUB.Count_And_Get
1593: (p_count => x_msg_count,
1594: p_data => x_msg_data
1595: );
1601:
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: ROLLBACK TO CREATE_Web_Recomms_PVT;
1604: x_return_status := FND_API.G_RET_STS_ERROR;
1605: -- Standard call to get message count and if count=1, get the message
1606: FND_MSG_PUB.Count_And_Get (
1607: p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data
1611:
1612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1613: ROLLBACK TO CREATE_Web_Recomms_PVT;
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (
1617: p_encoded => FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data
1625: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1626: THEN
1627: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1628: END IF;
1629: -- Standard call to get message count and if count=1, get the message
1630: FND_MSG_PUB.Count_And_Get (
1631: p_encoded => FND_API.G_FALSE,
1632: p_count => x_msg_count,
1633: p_data => x_msg_data
1657: -- x_return_status OUT VARCHAR2
1658: -- x_msg_count OUT NUMBER
1659: -- x_msg_data OUT VARCHAR2
1660: -- Version : Current version 1.0
1661: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1662: -- and basic operation, developer must manually add parameters and business logic as necessary.
1663: --
1664: -- History
1665: --
1700: l_tar_web_recomms_rec web_recomms_rec_type := P_web_recomms_rec;
1701: l_rowid ROWID;
1702:
1703: BEGIN
1704: -- Standard Start of API savepoint
1705: SAVEPOINT update_web_recomms_pvt;
1706:
1707: -- Standard call to check for call compatibility.
1708: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1703: BEGIN
1704: -- Standard Start of API savepoint
1705: SAVEPOINT update_web_recomms_pvt;
1706:
1707: -- Standard call to check for call compatibility.
1708: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1709: p_api_version_number,
1710: l_api_name,
1711: G_PKG_NAME)
1822: --
1823: -- End of API body.
1824: --
1825:
1826: -- Standard check for p_commit
1827: IF FND_API.to_Boolean( p_commit )
1828: THEN
1829: COMMIT WORK;
1830: END IF;
1833: -- Debug Message
1834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1835:
1836:
1837: -- Standard call to get message count and if count is 1, get message info.
1838: FND_MSG_PUB.Count_And_Get
1839: (p_count => x_msg_count,
1840: p_data => x_msg_data
1841: );
1847:
1848: WHEN FND_API.G_EXC_ERROR THEN
1849: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: -- Standard call to get message count and if count=1, get the message
1852: FND_MSG_PUB.Count_And_Get (
1853: p_encoded => FND_API.G_FALSE,
1854: p_count => x_msg_count,
1855: p_data => x_msg_data
1857:
1858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1859: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: FND_MSG_PUB.Count_And_Get (
1863: p_encoded => FND_API.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data
1871: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1874: END IF;
1875: -- Standard call to get message count and if count=1, get the message
1876: FND_MSG_PUB.Count_And_Get (
1877: p_encoded => FND_API.G_FALSE,
1878: p_count => x_msg_count,
1879: p_data => x_msg_data
1904: -- x_return_status OUT VARCHAR2
1905: -- x_msg_count OUT NUMBER
1906: -- x_msg_data OUT VARCHAR2
1907: -- Version : Current version 1.0
1908: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1909: -- and basic operation, developer must manually add parameters and business logic as necessary.
1910: --
1911: -- History
1912: --
1932: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1933: l_object_version_number NUMBER;
1934:
1935: BEGIN
1936: -- Standard Start of API savepoint
1937: SAVEPOINT delete_web_recomms_pvt;
1938:
1939: -- Standard call to check for call compatibility.
1940: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1935: BEGIN
1936: -- Standard Start of API savepoint
1937: SAVEPOINT delete_web_recomms_pvt;
1938:
1939: -- Standard call to check for call compatibility.
1940: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1941: p_api_version_number,
1942: l_api_name,
1943: G_PKG_NAME)
1975: --
1976: -- End of API body
1977: --
1978:
1979: -- Standard check for p_commit
1980: IF FND_API.to_Boolean( p_commit )
1981: THEN
1982: COMMIT WORK;
1983: END IF;
1986: -- Debug Message
1987: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1988:
1989:
1990: -- Standard call to get message count and if count is 1, get message info.
1991: FND_MSG_PUB.Count_And_Get
1992: (p_count => x_msg_count,
1993: p_data => x_msg_data
1994: );
2000:
2001: WHEN FND_API.G_EXC_ERROR THEN
2002: ROLLBACK TO DELETE_Web_Recomms_PVT;
2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004: -- Standard call to get message count and if count=1, get the message
2005: FND_MSG_PUB.Count_And_Get (
2006: p_encoded => FND_API.G_FALSE,
2007: p_count => x_msg_count,
2008: p_data => x_msg_data
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: ROLLBACK TO DELETE_Web_Recomms_PVT;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: -- Standard call to get message count and if count=1, get the message
2015: FND_MSG_PUB.Count_And_Get (
2016: p_encoded => FND_API.G_FALSE,
2017: p_count => x_msg_count,
2018: p_data => x_msg_data
2024: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2027: END IF;
2028: -- Standard call to get message count and if count=1, get the message
2029: FND_MSG_PUB.Count_And_Get (
2030: p_encoded => FND_API.G_FALSE,
2031: p_count => x_msg_count,
2032: p_data => x_msg_data
2058: -- x_return_status OUT VARCHAR2
2059: -- x_msg_count OUT NUMBER
2060: -- x_msg_data OUT VARCHAR2
2061: -- Version : Current version 1.0
2062: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
2063: -- and basic operation, developer must manually add parameters and business logic as necessary.
2064: --
2065: -- History
2066: --
2100: END IF;
2101:
2102:
2103:
2104: -- Standard call to check for call compatibility.
2105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2106: p_api_version_number,
2107: l_api_name,
2108: G_PKG_NAME)
2134:
2135: WHEN FND_API.G_EXC_ERROR THEN
2136: ROLLBACK TO LOCK_Web_Recomms_PVT;
2137: x_return_status := FND_API.G_RET_STS_ERROR;
2138: -- Standard call to get message count and if count=1, get the message
2139: FND_MSG_PUB.Count_And_Get (
2140: p_encoded => FND_API.G_FALSE,
2141: p_count => x_msg_count,
2142: p_data => x_msg_data
2144:
2145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2146: ROLLBACK TO LOCK_Web_Recomms_PVT;
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2148: -- Standard call to get message count and if count=1, get the message
2149: FND_MSG_PUB.Count_And_Get (
2150: p_encoded => FND_API.G_FALSE,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data
2158: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2161: END IF;
2162: -- Standard call to get message count and if count=1, get the message
2163: FND_MSG_PUB.Count_And_Get (
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data
2525: l_object_version_number NUMBER;
2526: l_web_recomms_rec web_recomms_rec_type;
2527:
2528: BEGIN
2529: -- Standard Start of API savepoint
2530: SAVEPOINT validate_web_recomms_;
2531:
2532: -- Standard call to check for call compatibility.
2533: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2528: BEGIN
2529: -- Standard Start of API savepoint
2530: SAVEPOINT validate_web_recomms_;
2531:
2532: -- Standard call to check for call compatibility.
2533: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2534: p_api_version_number,
2535: l_api_name,
2536: G_PKG_NAME)
2600: -- Debug Message
2601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2602:
2603:
2604: -- Standard call to get message count and if count is 1, get message info.
2605: FND_MSG_PUB.Count_And_Get
2606: (p_count => x_msg_count,
2607: p_data => x_msg_data
2608: );
2614:
2615: WHEN FND_API.G_EXC_ERROR THEN
2616: ROLLBACK TO VALIDATE_Web_Recomms_;
2617: x_return_status := FND_API.G_RET_STS_ERROR;
2618: -- Standard call to get message count and if count=1, get the message
2619: FND_MSG_PUB.Count_And_Get (
2620: p_encoded => FND_API.G_FALSE,
2621: p_count => x_msg_count,
2622: p_data => x_msg_data
2624:
2625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2626: ROLLBACK TO VALIDATE_Web_Recomms_;
2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2628: -- Standard call to get message count and if count=1, get the message
2629: FND_MSG_PUB.Count_And_Get (
2630: p_encoded => FND_API.G_FALSE,
2631: p_count => x_msg_count,
2632: p_data => x_msg_data
2638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2639: THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data
2675: -- x_return_status := FND_API.G_RET_STS_ERROR;
2676:
2677: -- Debug Message
2678: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2679: -- Standard call to get message count and if count is 1, get message info.
2680: FND_MSG_PUB.Count_And_Get
2681: (p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2719: l_offer_id NUMBER;
2720:
2721: BEGIN
2722:
2723: -- Standard Start of API savepoint
2724: SAVEPOINT Create_Web_Imp_Track;
2725:
2726: -- Initialize message list if p_init_msg_list is set to TRUE.
2727: IF FND_API.to_Boolean( p_init_msg_list )
2738: -- x_return_status := FND_API.G_RET_STS_ERROR;
2739:
2740: -- Debug Message
2741: AMS_UTILITY_PVT.debug_message('Private API: Create_Web_Imp_Track');
2742: -- Standard call to get message count and if count is 1, get message info.
2743: FND_MSG_PUB.Count_And_Get
2744: (p_count => x_msg_count,
2745: p_data => x_msg_data
2746: );
2904:
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: ROLLBACK TO Create_Web_Imp_Track;
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: -- Standard call to get message count and if count=1, get the message
2909: FND_MSG_PUB.Count_And_Get (
2910: p_encoded => FND_API.G_FALSE,
2911: p_count => x_msg_count,
2912: p_data => x_msg_data
2915:
2916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2917: ROLLBACK TO Create_Web_Imp_Track;
2918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2919: -- Standard call to get message count and if count=1, get the message
2920: FND_MSG_PUB.Count_And_Get (
2921: p_encoded => FND_API.G_FALSE,
2922: p_count => x_msg_count,
2923: p_data => x_msg_data
2930: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2931: THEN
2932: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2933: END IF;
2934: -- Standard call to get message count and if count=1, get the message
2935: FND_MSG_PUB.Count_And_Get (
2936: p_encoded => FND_API.G_FALSE,
2937: p_count => x_msg_count,
2938: p_data => x_msg_data