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.AMV_MYCHANNEL_PVT dependencies on STANDARD

Line 206: -- Standard begin of API savepoint

202: where r.resource_id = res_id
203: and u.user_id = r.user_id;
204: --
205: BEGIN
206: -- Standard begin of API savepoint
207: SAVEPOINT Subscribe_Channel_PVT;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call (
210: l_api_version,

Line 208: -- Standard call to check for call compatibility.

204: --
205: BEGIN
206: -- Standard begin of API savepoint
207: SAVEPOINT Subscribe_Channel_PVT;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call (
210: l_api_version,
211: p_api_version,
212: l_api_name,

Line 284: -- Standard check of commit

280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
281: FND_MESSAGE.Set_Token('ROW', l_full_name);
282: FND_MSG_PUB.Add;
283: END IF;
284: -- Standard check of commit
285: IF FND_API.To_Boolean ( p_commit ) THEN
286: COMMIT WORK;
287: END IF;
288: -- Debug Message

Line 294: --Standard call to get message count and if count=1, get the message

290: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
291: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
292: FND_MSG_PUB.Add;
293: END IF;
294: --Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (
296: p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count,
298: p_data => x_msg_data

Line 304: -- Standard call to get message count and if count=1, get the message

300: EXCEPTION
301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO Subscribe_Channel_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: -- Standard call to get message count and if count=1, get the message
305: FND_MSG_PUB.Count_And_Get (
306: p_encoded => FND_API.G_FALSE,
307: p_count => x_msg_count,
308: p_data => x_msg_data

Line 313: -- Standard call to get message count and if count=1, get the message

309: );
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: ROLLBACK TO Subscribe_Channel_PVT;
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: -- Standard call to get message count and if count=1, get the message
314: FND_MSG_PUB.Count_And_Get (
315: p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data

Line 326: -- Standard call to get message count and if count=1, get the message

322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
327: FND_MSG_PUB.Count_And_Get (
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data

Line 410: -- Standard begin of API savepoint

406: WHERE user_or_group_id = p_mychannel_obj.user_or_group_id
407: and user_or_group_type = p_mychannel_obj.user_or_group_type;
408: --
409: BEGIN
410: -- Standard begin of API savepoint
411: SAVEPOINT Add_Subscription_PVT;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version,

Line 412: -- Standard call to check for call compatibility.

408: --
409: BEGIN
410: -- Standard begin of API savepoint
411: SAVEPOINT Add_Subscription_PVT;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version,
415: p_api_version,
416: l_api_name,

Line 556: --Standard check of commit

552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
553: FND_MESSAGE.Set_Token('ROW', l_full_name);
554: FND_MSG_PUB.Add;
555: END IF;
556: --Standard check of commit
557: IF FND_API.To_Boolean ( p_commit ) THEN
558: COMMIT WORK;
559: END IF;
560: -- Debug Message

Line 566: --Standard call to get message count and if count=1, get the message

562: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
563: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
564: FND_MSG_PUB.Add;
565: END IF;
566: --Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data

Line 576: -- Standard call to get message count and if count=1, get the message

572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO Add_Subscription_PVT;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data

Line 585: -- Standard call to get message count and if count=1, get the message

581: );
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: ROLLBACK TO Add_Subscription_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data

Line 598: -- Standard call to get message count and if count=1, get the message

594: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
597: END IF;
598: -- Standard call to get message count and if count=1, get the message
599: FND_MSG_PUB.Count_And_Get (
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_msg_count,
602: p_data => x_msg_data

Line 689: -- Standard begin of API savepoint

685: from amv_u_my_channels
686: where my_channel_id = p_mychannel_id;
687: --
688: BEGIN
689: -- Standard begin of API savepoint
690: SAVEPOINT Remove_Subscription_PVT;
691: -- Standard call to check for call compatibility.
692: IF NOT FND_API.Compatible_API_Call (
693: l_api_version,

Line 691: -- Standard call to check for call compatibility.

687: --
688: BEGIN
689: -- Standard begin of API savepoint
690: SAVEPOINT Remove_Subscription_PVT;
691: -- Standard call to check for call compatibility.
692: IF NOT FND_API.Compatible_API_Call (
693: l_api_version,
694: p_api_version,
695: l_api_name,

Line 790: --Standard check of commit

786: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
787: FND_MESSAGE.Set_Token('ROW', l_full_name);
788: FND_MSG_PUB.Add;
789: END IF;
790: --Standard check of commit
791: IF FND_API.To_Boolean ( p_commit ) THEN
792: COMMIT WORK;
793: END IF;
794: -- Debug Message

Line 800: --Standard call to get message count and if count=1, get the message

796: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
797: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
798: FND_MSG_PUB.Add;
799: END IF;
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

Line 810: -- Standard call to get message count and if count=1, get the message

806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO Remove_Subscription_PVT;
809: x_return_status := FND_API.G_RET_STS_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

Line 819: -- Standard call to get message count and if count=1, get the message

815: );
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: ROLLBACK TO Remove_Subscription_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data

Line 832: -- Standard call to get message count and if count=1, get the message

828: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
831: END IF;
832: -- Standard call to get message count and if count=1, get the message
833: FND_MSG_PUB.Count_And_Get (
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data

Line 906: -- Standard begin of API savepoint

902: from amv_u_my_channels
903: where my_channel_id = l_mychannel_id;
904: --
905: BEGIN
906: -- Standard begin of API savepoint
907: SAVEPOINT Update_MyChannel_PVT;
908: -- Standard call to check for call compatibility.
909: IF NOT FND_API.Compatible_API_Call (
910: l_api_version,

Line 908: -- Standard call to check for call compatibility.

904: --
905: BEGIN
906: -- Standard begin of API savepoint
907: SAVEPOINT Update_MyChannel_PVT;
908: -- Standard call to check for call compatibility.
909: IF NOT FND_API.Compatible_API_Call (
910: l_api_version,
911: p_api_version,
912: l_api_name,

Line 1042: --Standard check of commit

1038: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1039: FND_MESSAGE.Set_Token('ROW',l_full_name) ;
1040: FND_MSG_PUB.Add;
1041: END IF;
1042: --Standard check of commit
1043: IF FND_API.To_Boolean ( p_commit ) THEN
1044: COMMIT WORK;
1045: END IF;
1046: -- Debug Message

Line 1052: --Standard call to get message count and if count=1, get the message

1048: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1049: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1050: FND_MSG_PUB.Add;
1051: END IF;
1052: --Standard call to get message count and if count=1, get the message
1053: FND_MSG_PUB.Count_And_Get (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data

Line 1062: -- Standard call to get message count and if count=1, get the message

1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO Update_MyChannel_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data

Line 1071: -- Standard call to get message count and if count=1, get the message

1067: );
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK TO Update_MyChannel_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data

Line 1084: -- Standard call to get message count and if count=1, get the message

1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message
1085: FND_MSG_PUB.Count_And_Get (
1086: p_encoded => FND_API.G_FALSE,
1087: p_count => x_msg_count,
1088: p_data => x_msg_data

Line 1200: -- Standard begin of API savepoint

1196: from amv_c_channels_b
1197: where channel_id = l_channel_id;
1198: --
1199: BEGIN
1200: -- Standard begin of API savepoint
1201: SAVEPOINT Get_MyChannels_PVT;
1202: -- Standard call to check for call compatibility.
1203: IF NOT FND_API.Compatible_API_Call (
1204: l_api_version,

Line 1202: -- Standard call to check for call compatibility.

1198: --
1199: BEGIN
1200: -- Standard begin of API savepoint
1201: SAVEPOINT Get_MyChannels_PVT;
1202: -- Standard call to check for call compatibility.
1203: IF NOT FND_API.Compatible_API_Call (
1204: l_api_version,
1205: p_api_version,
1206: l_api_name,

Line 1340: --Standard call to get message count and if count=1, get the message

1336: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1337: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1338: FND_MSG_PUB.Add;
1339: END IF;
1340: --Standard call to get message count and if count=1, get the message
1341: FND_MSG_PUB.Count_And_Get (
1342: p_encoded => FND_API.G_FALSE,
1343: p_count => x_msg_count,
1344: p_data => x_msg_data

Line 1350: -- Standard call to get message count and if count=1, get the message

1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO Get_MyChannels_PVT;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: -- Standard call to get message count and if count=1, get the message
1351: FND_MSG_PUB.Count_And_Get (
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data

Line 1359: -- Standard call to get message count and if count=1, get the message

1355: );
1356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1357: ROLLBACK TO Get_MyChannels_PVT;
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: -- Standard call to get message count and if count=1, get the message
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => x_msg_count,
1363: p_data => x_msg_data

Line 1372: -- Standard call to get message count and if count=1, get the message

1368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1369: THEN
1370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1371: END IF;
1372: -- Standard call to get message count and if count=1, get the message
1373: FND_MSG_PUB.Count_And_Get (
1374: p_encoded => FND_API.G_FALSE,
1375: p_count => x_msg_count,
1376: p_data => x_msg_data

Line 1451: -- Standard begin of API savepoint

1447: and channel_type = AMV_UTILITY_PVT.G_CONTENT
1448: and access_level_type = AMV_UTILITY_PVT.G_PUBLIC;
1449: --
1450: BEGIN
1451: -- Standard begin of API savepoint
1452: SAVEPOINT Get_MyChannelsPerCategory_PVT;
1453: -- Standard call to check for call compatibility.
1454: IF NOT FND_API.Compatible_API_Call (
1455: l_api_version,

Line 1453: -- Standard call to check for call compatibility.

1449: --
1450: BEGIN
1451: -- Standard begin of API savepoint
1452: SAVEPOINT Get_MyChannelsPerCategory_PVT;
1453: -- Standard call to check for call compatibility.
1454: IF NOT FND_API.Compatible_API_Call (
1455: l_api_version,
1456: p_api_version,
1457: l_api_name,

Line 1519: --Standard call to get message count and if count=1, get the message

1515: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1516: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1517: FND_MSG_PUB.Add;
1518: END IF;
1519: --Standard call to get message count and if count=1, get the message
1520: FND_MSG_PUB.Count_And_Get (
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data

Line 1529: -- Standard call to get message count and if count=1, get the message

1525: EXCEPTION
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: -- Standard call to get message count and if count=1, get the message
1530: FND_MSG_PUB.Count_And_Get (
1531: p_encoded => FND_API.G_FALSE,
1532: p_count => x_msg_count,
1533: p_data => x_msg_data

Line 1538: -- Standard call to get message count and if count=1, get the message

1534: );
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: -- Standard call to get message count and if count=1, get the message
1539: FND_MSG_PUB.Count_And_Get (
1540: p_encoded => FND_API.G_FALSE,
1541: p_count => x_msg_count,
1542: p_data => x_msg_data

Line 1551: -- Standard call to get message count and if count=1, get the message

1547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1548: THEN
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1550: END IF;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data

Line 1702: -- Standard begin of API savepoint

1698: and language = 'US';
1699:
1700: --
1701: BEGIN
1702: -- Standard begin of API savepoint
1703: SAVEPOINT Get_MyNotifications;
1704: -- Standard call to check for call compatibility.
1705: IF NOT FND_API.Compatible_API_Call (
1706: l_api_version,

Line 1704: -- Standard call to check for call compatibility.

1700: --
1701: BEGIN
1702: -- Standard begin of API savepoint
1703: SAVEPOINT Get_MyNotifications;
1704: -- Standard call to check for call compatibility.
1705: IF NOT FND_API.Compatible_API_Call (
1706: l_api_version,
1707: p_api_version,
1708: l_api_name,

Line 1892: --Standard call to get message count and if count=1, get the message

1888: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1889: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1890: FND_MSG_PUB.Add;
1891: END IF;
1892: --Standard call to get message count and if count=1, get the message
1893: FND_MSG_PUB.Count_And_Get (
1894: p_encoded => FND_API.G_FALSE,
1895: p_count => x_msg_count,
1896: p_data => x_msg_data

Line 1902: -- Standard call to get message count and if count=1, get the message

1898: EXCEPTION
1899: WHEN FND_API.G_EXC_ERROR THEN
1900: ROLLBACK TO Get_MyNotifications;
1901: x_return_status := FND_API.G_RET_STS_ERROR;
1902: -- Standard call to get message count and if count=1, get the message
1903: FND_MSG_PUB.Count_And_Get (
1904: p_encoded => FND_API.G_FALSE,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data

Line 1911: -- Standard call to get message count and if count=1, get the message

1907: );
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO Get_MyNotifications;
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: -- Standard call to get message count and if count=1, get the message
1912: FND_MSG_PUB.Count_And_Get (
1913: p_encoded => FND_API.G_FALSE,
1914: p_count => x_msg_count,
1915: p_data => x_msg_data

Line 1924: -- Standard call to get message count and if count=1, get the message

1920: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1921: THEN
1922: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1923: END IF;
1924: -- Standard call to get message count and if count=1, get the message
1925: FND_MSG_PUB.Count_And_Get (
1926: p_encoded => FND_API.G_FALSE,
1927: p_count => x_msg_count,
1928: p_data => x_msg_data

Line 2081: -- Standard begin of API savepoint

2077: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
2078: and nvl(ib.expiration_date, sysdate) >= sysdate;
2079:
2080: BEGIN
2081: -- Standard begin of API savepoint
2082: SAVEPOINT Get_ItemsPerUser;
2083: -- Standard call to check for call compatibility.
2084: IF NOT FND_API.Compatible_API_Call (
2085: l_api_version,

Line 2083: -- Standard call to check for call compatibility.

2079:
2080: BEGIN
2081: -- Standard begin of API savepoint
2082: SAVEPOINT Get_ItemsPerUser;
2083: -- Standard call to check for call compatibility.
2084: IF NOT FND_API.Compatible_API_Call (
2085: l_api_version,
2086: p_api_version,
2087: l_api_name,

Line 2186: --Standard call to get message count and if count=1, get the message

2182: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2183: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2184: FND_MSG_PUB.Add;
2185: END IF;
2186: --Standard call to get message count and if count=1, get the message
2187: FND_MSG_PUB.Count_And_Get (
2188: p_encoded => FND_API.G_FALSE,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data

Line 2196: -- Standard call to get message count and if count=1, get the message

2192: EXCEPTION
2193: WHEN FND_API.G_EXC_ERROR THEN
2194: ROLLBACK TO Get_ItemsPerUser;
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: -- Standard call to get message count and if count=1, get the message
2197: FND_MSG_PUB.Count_And_Get (
2198: p_encoded => FND_API.G_FALSE,
2199: p_count => x_msg_count,
2200: p_data => x_msg_data

Line 2205: -- Standard call to get message count and if count=1, get the message

2201: );
2202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2203: ROLLBACK TO Get_ItemsPerUser;
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205: -- Standard call to get message count and if count=1, get the message
2206: FND_MSG_PUB.Count_And_Get (
2207: p_encoded => FND_API.G_FALSE,
2208: p_count => x_msg_count,
2209: p_data => x_msg_data

Line 2218: -- Standard call to get message count and if count=1, get the message

2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2219: FND_MSG_PUB.Count_And_Get (
2220: p_encoded => FND_API.G_FALSE,
2221: p_count => x_msg_count,
2222: p_data => x_msg_data

Line 2312: -- Standard begin of API savepoint

2308: and nvl(effective_start_date, sysdate) <= sysdate
2309: and application_id = p_application_id;
2310:
2311: BEGIN
2312: -- Standard begin of API savepoint
2313: SAVEPOINT Get_UserItems;
2314: -- Standard call to check for call compatibility.
2315: IF NOT FND_API.Compatible_API_Call (
2316: l_api_version,

Line 2314: -- Standard call to check for call compatibility.

2310:
2311: BEGIN
2312: -- Standard begin of API savepoint
2313: SAVEPOINT Get_UserItems;
2314: -- Standard call to check for call compatibility.
2315: IF NOT FND_API.Compatible_API_Call (
2316: l_api_version,
2317: p_api_version,
2318: l_api_name,

Line 2404: --Standard call to get message count and if count=1, get the message

2400: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2401: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2402: FND_MSG_PUB.Add;
2403: END IF;
2404: --Standard call to get message count and if count=1, get the message
2405: FND_MSG_PUB.Count_And_Get (
2406: p_encoded => FND_API.G_FALSE,
2407: p_count => x_msg_count,
2408: p_data => x_msg_data

Line 2414: -- Standard call to get message count and if count=1, get the message

2410: EXCEPTION
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO Get_UserItems;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data

Line 2423: -- Standard call to get message count and if count=1, get the message

2419: );
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: ROLLBACK TO Get_UserItems;
2422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2423: -- Standard call to get message count and if count=1, get the message
2424: FND_MSG_PUB.Count_And_Get (
2425: p_encoded => FND_API.G_FALSE,
2426: p_count => x_msg_count,
2427: p_data => x_msg_data

Line 2436: -- Standard call to get message count and if count=1, get the message

2432: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2435: END IF;
2436: -- Standard call to get message count and if count=1, get the message
2437: FND_MSG_PUB.Count_And_Get (
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,
2440: p_data => x_msg_data

Line 2518: -- Standard call to check for call compatibility.

2514: and effective_start_date <= sysdate
2515: and nvl(expiration_date, sysdate) >= sysdate;
2516:
2517: BEGIN
2518: -- Standard call to check for call compatibility.
2519: IF NOT FND_API.Compatible_API_Call (
2520: l_api_version,
2521: p_api_version,
2522: l_api_name,

Line 2591: --Standard call to get message count and if count=1, get the message

2587: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2588: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2589: FND_MSG_PUB.Add;
2590: END IF;
2591: --Standard call to get message count and if count=1, get the message
2592: FND_MSG_PUB.Count_And_Get (
2593: p_encoded => FND_API.G_FALSE,
2594: p_count => x_msg_count,
2595: p_data => x_msg_data

Line 2600: -- Standard call to get message count and if count=1, get the message

2596: );
2597: EXCEPTION
2598: WHEN FND_API.G_EXC_ERROR THEN
2599: x_return_status := FND_API.G_RET_STS_ERROR;
2600: -- Standard call to get message count and if count=1, get the message
2601: FND_MSG_PUB.Count_And_Get (
2602: p_encoded => FND_API.G_FALSE,
2603: p_count => x_msg_count,
2604: p_data => x_msg_data

Line 2608: -- Standard call to get message count and if count=1, get the message

2604: p_data => x_msg_data
2605: );
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: -- Standard call to get message count and if count=1, get the message
2609: FND_MSG_PUB.Count_And_Get (
2610: p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count,
2612: p_data => x_msg_data

Line 2620: -- Standard call to get message count and if count=1, get the message

2616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2619: END IF;
2620: -- Standard call to get message count and if count=1, get the message
2621: FND_MSG_PUB.Count_And_Get (
2622: p_encoded => FND_API.G_FALSE,
2623: p_count => x_msg_count,
2624: p_data => x_msg_data