[Home] [Help]
544: order by amst.stock_symbol ASC;
545: --order by l_order_by;
546: --
547: BEGIN
548: -- Standard begin of API savepoint
549: SAVEPOINT Get_UserTicker;
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (
552: l_api_version,
546: --
547: BEGIN
548: -- Standard begin of API savepoint
549: SAVEPOINT Get_UserTicker;
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (
552: l_api_version,
553: p_api_version,
554: l_api_name,
661: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
662: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
663: FND_MSG_PUB.Add;
664: END IF;
665: --Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,
669: p_data => x_msg_data
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO Get_UserTicker;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO Get_UserTicker;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
696: END IF;
697: -- Standard call to get message count and if count=1, get the message
698: FND_MSG_PUB.Count_And_Get (
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data
769: and amst.stock_ric = amsp.stock_ric(+)
770: order by amsp.time_stamp desc;
771: --
772: BEGIN
773: -- Standard begin of API savepoint
774: SAVEPOINT Get_StockDetails;
775: -- Standard call to check for call compatibility.
776: IF NOT FND_API.Compatible_API_Call (
777: l_api_version,
771: --
772: BEGIN
773: -- Standard begin of API savepoint
774: SAVEPOINT Get_StockDetails;
775: -- Standard call to check for call compatibility.
776: IF NOT FND_API.Compatible_API_Call (
777: l_api_version,
778: p_api_version,
779: l_api_name,
831: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
832: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
833: FND_MSG_PUB.Add;
834: END IF;
835: --Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
841: EXCEPTION
842: WHEN FND_API.G_EXC_ERROR THEN
843: ROLLBACK TO Get_StockDetails;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: -- Standard call to get message count and if count=1, get the message
846: FND_MSG_PUB.Count_And_Get (
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO Get_StockDetails;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: -- Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
863: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
864: THEN
865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
866: END IF;
867: -- Standard call to get message count and if count=1, get the message
868: FND_MSG_PUB.Count_And_Get (
869: p_encoded => FND_API.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
936: l_upd_num number := 0;
937: l_flag varchar2(20);
938: --
939: BEGIN
940: -- Standard begin of API savepoint
941: SAVEPOINT Update_UserTicker;
942: -- Standard call to check for call compatibility.
943: IF NOT FND_API.Compatible_API_Call (
944: l_api_version,
938: --
939: BEGIN
940: -- Standard begin of API savepoint
941: SAVEPOINT Update_UserTicker;
942: -- Standard call to check for call compatibility.
943: IF NOT FND_API.Compatible_API_Call (
944: l_api_version,
945: p_api_version,
946: l_api_name,
1039: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1040: FND_MESSAGE.Set_Token('ROW', l_full_name);
1041: FND_MSG_PUB.Add;
1042: END IF;
1043: --Standard check of commit
1044: IF FND_API.To_Boolean ( p_commit ) THEN
1045: COMMIT WORK;
1046: END IF;
1047: -- Debug Message
1049: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1050: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: --Standard call to get message count and if count=1, get the message
1054: FND_MSG_PUB.Count_And_Get (
1055: p_encoded => FND_API.G_FALSE,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO Update_UserTicker;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data
1068: );
1069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1070: ROLLBACK TO Update_UserTicker;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: -- Standard call to get message count and if count=1, get the message
1073: FND_MSG_PUB.Count_And_Get (
1074: p_encoded => FND_API.G_FALSE,
1075: p_count => x_msg_count,
1076: p_data => x_msg_data
1081: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1084: END IF;
1085: -- Standard call to get message count and if count=1, get the message
1086: FND_MSG_PUB.Count_And_Get (
1087: p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data
1166: from amv_stocks
1167: where stock_id = l_stock_id;
1168: --
1169: BEGIN
1170: -- Standard begin of API savepoint
1171: SAVEPOINT Get_VendorMissedStocks;
1172: -- Standard call to check for call compatibility.
1173: IF NOT FND_API.Compatible_API_Call (
1174: l_api_version,
1168: --
1169: BEGIN
1170: -- Standard begin of API savepoint
1171: SAVEPOINT Get_VendorMissedStocks;
1172: -- Standard call to check for call compatibility.
1173: IF NOT FND_API.Compatible_API_Call (
1174: l_api_version,
1175: p_api_version,
1176: l_api_name,
1223: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1224: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1225: FND_MSG_PUB.Add;
1226: END IF;
1227: --Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data
1233: EXCEPTION
1234: WHEN FND_API.G_EXC_ERROR THEN
1235: ROLLBACK TO Get_VendorMissedStocks;
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1244: ROLLBACK TO Get_VendorMissedStocks;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: -- Standard call to get message count and if count=1, get the message
1247: FND_MSG_PUB.Count_And_Get (
1248: p_encoded => FND_API.G_FALSE,
1249: p_count => x_msg_count,
1250: p_data => x_msg_data
1255: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1256: THEN
1257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1258: END IF;
1259: -- Standard call to get message count and if count=1, get the message
1260: FND_MSG_PUB.Count_And_Get (
1261: p_encoded => FND_API.G_FALSE,
1262: p_count => x_msg_count,
1263: p_data => x_msg_data
1326: select amv_vendor_keys_s.nextval
1327: from dual;
1328: --
1329: BEGIN
1330: -- Standard begin of API savepoint
1331: SAVEPOINT Insert_StockVendorKeys;
1332: -- Standard call to check for call compatibility.
1333: IF NOT FND_API.Compatible_API_Call (
1334: l_api_version,
1328: --
1329: BEGIN
1330: -- Standard begin of API savepoint
1331: SAVEPOINT Insert_StockVendorKeys;
1332: -- Standard call to check for call compatibility.
1333: IF NOT FND_API.Compatible_API_Call (
1334: l_api_version,
1335: p_api_version,
1336: l_api_name,
1404: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1405: FND_MESSAGE.Set_Token('ROW', l_full_name);
1406: FND_MSG_PUB.Add;
1407: END IF;
1408: --Standard check of commit
1409: IF FND_API.To_Boolean ( p_commit ) THEN
1410: COMMIT WORK;
1411: END IF;
1412: -- Debug Message
1414: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1415: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1416: FND_MSG_PUB.Add;
1417: END IF;
1418: --Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Insert_StockVendorKeys;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (
1430: p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data
1433: );
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO Insert_StockVendorKeys;
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437: -- Standard call to get message count and if count=1, get the message
1438: FND_MSG_PUB.Count_And_Get (
1439: p_encoded => FND_API.G_FALSE,
1440: p_count => x_msg_count,
1441: p_data => x_msg_data
1446: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1447: THEN
1448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1449: END IF;
1450: -- Standard call to get message count and if count=1, get the message
1451: FND_MSG_PUB.Count_And_Get (
1452: p_encoded => FND_API.G_FALSE,
1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1530: from amv_vendor_keys amvk
1531: where amvk.vendor_id = p_vendor_id;
1532: --
1533: BEGIN
1534: -- Standard begin of API savepoint
1535: SAVEPOINT Get_UserSelectedKeys;
1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call (
1538: l_api_version,
1532: --
1533: BEGIN
1534: -- Standard begin of API savepoint
1535: SAVEPOINT Get_UserSelectedKeys;
1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call (
1538: l_api_version,
1539: p_api_version,
1540: l_api_name,
1607: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1608: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1609: FND_MSG_PUB.Add;
1610: END IF;
1611: --Standard call to get message count and if count=1, get the message
1612: FND_MSG_PUB.Count_And_Get (
1613: p_encoded => FND_API.G_FALSE,
1614: p_count => x_msg_count,
1615: p_data => x_msg_data
1617: EXCEPTION
1618: WHEN FND_API.G_EXC_ERROR THEN
1619: ROLLBACK TO Get_UserSelectedKeys;
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: -- Standard call to get message count and if count=1, get the message
1622: FND_MSG_PUB.Count_And_Get (
1623: p_encoded => FND_API.G_FALSE,
1624: p_count => x_msg_count,
1625: p_data => x_msg_data
1626: );
1627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1628: ROLLBACK TO Get_UserSelectedKeys;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1639: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1640: THEN
1641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1642: END IF;
1643: -- Standard call to get message count and if count=1, get the message
1644: FND_MSG_PUB.Count_And_Get (
1645: p_encoded => FND_API.G_FALSE,
1646: p_count => x_msg_count,
1647: p_data => x_msg_data
1715: select amv_news_s.nextval
1716: from dual;
1717: --
1718: BEGIN
1719: -- Standard begin of API savepoint
1720: SAVEPOINT Insert_VendorNews;
1721: -- Standard call to check for call compatibility.
1722: IF NOT FND_API.Compatible_API_Call (
1723: l_api_version,
1717: --
1718: BEGIN
1719: -- Standard begin of API savepoint
1720: SAVEPOINT Insert_VendorNews;
1721: -- Standard call to check for call compatibility.
1722: IF NOT FND_API.Compatible_API_Call (
1723: l_api_version,
1724: p_api_version,
1725: l_api_name,
1795: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1796: FND_MESSAGE.Set_Token('ROW', l_full_name);
1797: FND_MSG_PUB.Add;
1798: END IF;
1799: --Standard check of commit
1800: IF FND_API.To_Boolean ( p_commit ) THEN
1801: COMMIT WORK;
1802: END IF;
1803: -- Debug Message
1805: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1806: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1807: FND_MSG_PUB.Add;
1808: END IF;
1809: --Standard call to get message count and if count=1, get the message
1810: FND_MSG_PUB.Count_And_Get (
1811: p_encoded => FND_API.G_FALSE,
1812: p_count => x_msg_count,
1813: p_data => x_msg_data
1815: EXCEPTION
1816: WHEN FND_API.G_EXC_ERROR THEN
1817: ROLLBACK TO Insert_VendorNews;
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: -- Standard call to get message count and if count=1, get the message
1820: FND_MSG_PUB.Count_And_Get (
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1826: ROLLBACK TO Insert_VendorNews;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: -- Standard call to get message count and if count=1, get the message
1829: FND_MSG_PUB.Count_And_Get (
1830: p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data
1837: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1840: END IF;
1841: -- Standard call to get message count and if count=1, get the message
1842: FND_MSG_PUB.Count_And_Get (
1843: p_encoded => FND_API.G_FALSE,
1844: p_count => x_msg_count,
1845: p_data => x_msg_data
1918: order by n.date_time desc;
1919:
1920: --
1921: BEGIN
1922: -- Standard begin of API savepoint
1923: SAVEPOINT Get_CompanyNews;
1924: -- Standard call to check for call compatibility.
1925: IF NOT FND_API.Compatible_API_Call (
1926: l_api_version,
1920: --
1921: BEGIN
1922: -- Standard begin of API savepoint
1923: SAVEPOINT Get_CompanyNews;
1924: -- Standard call to check for call compatibility.
1925: IF NOT FND_API.Compatible_API_Call (
1926: l_api_version,
1927: p_api_version,
1928: l_api_name,
1959: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1960: FND_MESSAGE.Set_Token('ROW', l_full_name);
1961: FND_MSG_PUB.Add;
1962: END IF;
1963: --Standard check of commit
1964: IF FND_API.To_Boolean ( p_commit ) THEN
1965: COMMIT WORK;
1966: END IF;
1967: -- Debug Message
1969: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1970: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1971: FND_MSG_PUB.Add;
1972: END IF;
1973: --Standard call to get message count and if count=1, get the message
1974: FND_MSG_PUB.Count_And_Get (
1975: p_encoded => FND_API.G_FALSE,
1976: p_count => x_msg_count,
1977: p_data => x_msg_data
1979: EXCEPTION
1980: WHEN FND_API.G_EXC_ERROR THEN
1981: ROLLBACK TO Get_CompanyNews;
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: -- Standard call to get message count and if count=1, get the message
1984: FND_MSG_PUB.Count_And_Get (
1985: p_encoded => FND_API.G_FALSE,
1986: p_count => x_msg_count,
1987: p_data => x_msg_data
1988: );
1989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1990: ROLLBACK TO Get_CompanyNews;
1991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1992: -- Standard call to get message count and if count=1, get the message
1993: FND_MSG_PUB.Count_And_Get (
1994: p_encoded => FND_API.G_FALSE,
1995: p_count => x_msg_count,
1996: p_data => x_msg_data
2001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2002: THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: -- Standard call to get message count and if count=1, get the message
2006: FND_MSG_PUB.Count_And_Get (
2007: p_encoded => FND_API.G_FALSE,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data