[Home] [Help]
506: CURSOR ChannelId_Seq IS
507: select amv_c_channels_b_s.nextval
508: from dual;
509: BEGIN
510: -- Standard begin of API savepoint
511: SAVEPOINT Add_Channel_PVT;
512: -- Standard call to check for call compatibility.
513: IF NOT FND_API.Compatible_API_Call (
514: l_api_version,
508: from dual;
509: BEGIN
510: -- Standard begin of API savepoint
511: SAVEPOINT Add_Channel_PVT;
512: -- Standard call to check for call compatibility.
513: IF NOT FND_API.Compatible_API_Call (
514: l_api_version,
515: p_api_version,
516: l_api_name,
772: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
773: FND_MESSAGE.Set_Token('ROW', l_full_name);
774: FND_MSG_PUB.Add;
775: END IF;
776: --Standard check of commit
777: IF FND_API.To_Boolean ( p_commit ) THEN
778: COMMIT WORK;
779: END IF;
780: -- Debug Message
782: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
783: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
784: FND_MSG_PUB.Add;
785: END IF;
786: --Standard call to get message count and if count=1, get the message
787: FND_MSG_PUB.Count_And_Get (
788: p_encoded => FND_API.G_FALSE,
789: p_count => x_msg_count,
790: p_data => x_msg_data
792: EXCEPTION
793: WHEN FND_API.G_EXC_ERROR THEN
794: ROLLBACK TO Add_Channel_PVT;
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: -- Standard call to get message count and if count=1, get the message
797: FND_MSG_PUB.Count_And_Get (
798: p_encoded => FND_API.G_FALSE,
799: p_count => x_msg_count,
800: p_data => x_msg_data
801: );
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: ROLLBACK TO Add_Channel_PVT;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: -- Standard call to get message count and if count=1, get the message
806: FND_MSG_PUB.Count_And_Get (
807: p_encoded => FND_API.G_FALSE,
808: p_count => x_msg_count,
809: p_data => x_msg_data
814: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
817: END IF;
818: -- Standard call to get message count and if count=1, get the message
819: FND_MSG_PUB.Count_And_Get (
820: p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => x_msg_data
883: l_expiration_date date;
884: l_mychannel_obj AMV_MYCHANNEL_PVT.AMV_MY_CHANNEL_OBJ_TYPE;
885:
886: BEGIN
887: -- Standard begin of API savepoint
888: SAVEPOINT Add_PublicChannel_PVT;
889: -- Standard call to check for call compatibility.
890: IF NOT FND_API.Compatible_API_Call (
891: l_api_version,
885:
886: BEGIN
887: -- Standard begin of API savepoint
888: SAVEPOINT Add_PublicChannel_PVT;
889: -- Standard call to check for call compatibility.
890: IF NOT FND_API.Compatible_API_Call (
891: l_api_version,
892: p_api_version,
893: l_api_name,
1026: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1027: FND_MESSAGE.Set_Token('ROW', l_full_name);
1028: FND_MSG_PUB.Add;
1029: END IF;
1030: --Standard check of commit
1031: IF FND_API.To_Boolean ( p_commit ) THEN
1032: COMMIT WORK;
1033: END IF;
1034: -- Debug Message
1036: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1037: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1038: FND_MSG_PUB.Add;
1039: END IF;
1040: --Standard call to get message count and if count=1, get the message
1041: FND_MSG_PUB.Count_And_Get (
1042: p_encoded => FND_API.G_FALSE,
1043: p_count => x_msg_count,
1044: p_data => x_msg_data
1046: EXCEPTION
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: ROLLBACK TO Add_PublicChannel_PVT;
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: -- Standard call to get message count and if count=1, get the message
1051: FND_MSG_PUB.Count_And_Get (
1052: p_encoded => FND_API.G_FALSE,
1053: p_count => x_msg_count,
1054: p_data => x_msg_data
1055: );
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO Add_PublicChannel_PVT;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: -- Standard call to get message count and if count=1, get the message
1060: FND_MSG_PUB.Count_And_Get (
1061: p_encoded => FND_API.G_FALSE,
1062: p_count => x_msg_count,
1063: p_data => x_msg_data
1068: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1069: THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1071: END IF;
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
1138: l_expiration_date date;
1139: l_mychannel_obj AMV_MYCHANNEL_PVT.AMV_MY_CHANNEL_OBJ_TYPE;
1140:
1141: BEGIN
1142: -- Standard begin of API savepoint
1143: SAVEPOINT Add_ProtectedChannel_PVT;
1144: -- Standard call to check for call compatibility.
1145: IF NOT FND_API.Compatible_API_Call (
1146: l_api_version,
1140:
1141: BEGIN
1142: -- Standard begin of API savepoint
1143: SAVEPOINT Add_ProtectedChannel_PVT;
1144: -- Standard call to check for call compatibility.
1145: IF NOT FND_API.Compatible_API_Call (
1146: l_api_version,
1147: p_api_version,
1148: l_api_name,
1281: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1282: FND_MESSAGE.Set_Token('ROW', l_full_name);
1283: FND_MSG_PUB.Add;
1284: END IF;
1285: --Standard check of commit
1286: IF FND_API.To_Boolean ( p_commit ) THEN
1287: COMMIT WORK;
1288: END IF;
1289: -- Debug Message
1291: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1292: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1293: FND_MSG_PUB.Add;
1294: END IF;
1295: --Standard call to get message count and if count=1, get the message
1296: FND_MSG_PUB.Count_And_Get (
1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: ROLLBACK TO Add_ProtectedChannel_PVT;
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: -- Standard call to get message count and if count=1, get the message
1306: FND_MSG_PUB.Count_And_Get (
1307: p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: ROLLBACK TO Add_ProtectedChannel_PVT;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: -- Standard call to get message count and if count=1, get the message
1315: FND_MSG_PUB.Count_And_Get (
1316: p_encoded => FND_API.G_FALSE,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data
1323: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1324: THEN
1325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1326: END IF;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1392: l_expiration_date date;
1393: l_mychannel_obj AMV_MYCHANNEL_PVT.AMV_MY_CHANNEL_OBJ_TYPE;
1394:
1395: BEGIN
1396: -- Standard begin of API savepoint
1397: SAVEPOINT Add_PrivateChannel_PVT;
1398: -- Standard call to check for call compatibility.
1399: IF NOT FND_API.Compatible_API_Call (
1400: l_api_version,
1394:
1395: BEGIN
1396: -- Standard begin of API savepoint
1397: SAVEPOINT Add_PrivateChannel_PVT;
1398: -- Standard call to check for call compatibility.
1399: IF NOT FND_API.Compatible_API_Call (
1400: l_api_version,
1401: p_api_version,
1402: l_api_name,
1531: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1532: FND_MESSAGE.Set_Token('ROW', l_full_name);
1533: FND_MSG_PUB.Add;
1534: END IF;
1535: --Standard check of commit
1536: IF FND_API.To_Boolean ( p_commit ) THEN
1537: COMMIT WORK;
1538: END IF;
1539: -- Debug Message
1541: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1542: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1543: FND_MSG_PUB.Add;
1544: END IF;
1545: --Standard call to get message count and if count=1, get the message
1546: FND_MSG_PUB.Count_And_Get (
1547: p_encoded => FND_API.G_FALSE,
1548: p_count => x_msg_count,
1549: p_data => x_msg_data
1551: EXCEPTION
1552: WHEN FND_API.G_EXC_ERROR THEN
1553: ROLLBACK TO Add_PrivateChannel_PVT;
1554: x_return_status := FND_API.G_RET_STS_ERROR;
1555: -- Standard call to get message count and if count=1, get the message
1556: FND_MSG_PUB.Count_And_Get (
1557: p_encoded => FND_API.G_FALSE,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1562: ROLLBACK TO Add_PrivateChannel_PVT;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: -- Standard call to get message count and if count=1, get the message
1565: FND_MSG_PUB.Count_And_Get (
1566: p_encoded => FND_API.G_FALSE,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data
1573: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1574: THEN
1575: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1576: END IF;
1577: -- Standard call to get message count and if count=1, get the message
1578: FND_MSG_PUB.Count_And_Get (
1579: p_encoded => FND_API.G_FALSE,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data
1657: from JTF_RS_GROUPS_VL
1658: where group_id = p_group_id;
1659:
1660: BEGIN
1661: -- Standard begin of API savepoint
1662: SAVEPOINT Add_GroupChannel_PVT;
1663: -- Standard call to check for call compatibility.
1664: IF NOT FND_API.Compatible_API_Call (
1665: l_api_version,
1659:
1660: BEGIN
1661: -- Standard begin of API savepoint
1662: SAVEPOINT Add_GroupChannel_PVT;
1663: -- Standard call to check for call compatibility.
1664: IF NOT FND_API.Compatible_API_Call (
1665: l_api_version,
1666: p_api_version,
1667: l_api_name,
1811: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1812: FND_MESSAGE.Set_Token('ROW', l_full_name);
1813: FND_MSG_PUB.Add;
1814: END IF;
1815: --Standard check of commit
1816: IF FND_API.To_Boolean ( p_commit ) THEN
1817: COMMIT WORK;
1818: END IF;
1819: -- Debug Message
1821: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1822: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1823: FND_MSG_PUB.Add;
1824: END IF;
1825: --Standard call to get message count and if count=1, get the message
1826: FND_MSG_PUB.Count_And_Get (
1827: p_encoded => FND_API.G_FALSE,
1828: p_count => x_msg_count,
1829: p_data => x_msg_data
1831: EXCEPTION
1832: WHEN FND_API.G_EXC_ERROR THEN
1833: ROLLBACK TO Add_GroupChannel_PVT;
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835: -- Standard call to get message count and if count=1, get the message
1836: FND_MSG_PUB.Count_And_Get (
1837: p_encoded => FND_API.G_FALSE,
1838: p_count => x_msg_count,
1839: p_data => x_msg_data
1840: );
1841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1842: ROLLBACK TO Add_GroupChannel_PVT;
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844: -- Standard call to get message count and if count=1, get the message
1845: FND_MSG_PUB.Count_And_Get (
1846: p_encoded => FND_API.G_FALSE,
1847: p_count => x_msg_count,
1848: p_data => x_msg_data
1853: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1854: THEN
1855: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1856: END IF;
1857: -- Standard call to get message count and if count=1, get the message
1858: FND_MSG_PUB.Count_And_Get (
1859: p_encoded => FND_API.G_FALSE,
1860: p_count => x_msg_count,
1861: p_data => x_msg_data
1925: l_delete_channel_flag varchar2(1);
1926: l_setup_result varchar2(1);
1927: --
1928: BEGIN
1929: -- Standard begin of API savepoint
1930: SAVEPOINT Delete_Channel_PVT;
1931: -- Standard call to check for call compatibility.
1932: IF NOT FND_API.Compatible_API_Call (
1933: l_api_version,
1927: --
1928: BEGIN
1929: -- Standard begin of API savepoint
1930: SAVEPOINT Delete_Channel_PVT;
1931: -- Standard call to check for call compatibility.
1932: IF NOT FND_API.Compatible_API_Call (
1933: l_api_version,
1934: p_api_version,
1935: l_api_name,
2087: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
2088: FND_MESSAGE.Set_Token('ROW', l_full_name);
2089: FND_MSG_PUB.Add;
2090: END IF;
2091: --Standard check of commit
2092: IF FND_API.To_Boolean ( p_commit ) THEN
2093: COMMIT WORK;
2094: END IF;
2095: -- Debug Message
2097: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2098: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2099: FND_MSG_PUB.Add;
2100: END IF;
2101: --Standard call to get message count and if count=1, get the message
2102: FND_MSG_PUB.Count_And_Get (
2103: p_encoded => FND_API.G_FALSE,
2104: p_count => x_msg_count,
2105: p_data => x_msg_data
2107: EXCEPTION
2108: WHEN FND_API.G_EXC_ERROR THEN
2109: ROLLBACK TO Delete_Channel_PVT;
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: -- Standard call to get message count and if count=1, get the message
2112: FND_MSG_PUB.Count_And_Get (
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: ROLLBACK TO Delete_Channel_PVT;
2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2120: -- Standard call to get message count and if count=1, get the message
2121: FND_MSG_PUB.Count_And_Get (
2122: p_encoded => FND_API.G_FALSE,
2123: p_count => x_msg_count,
2124: p_data => x_msg_data
2129: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2130: THEN
2131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2132: END IF;
2133: -- Standard call to get message count and if count=1, get the message
2134: FND_MSG_PUB.Count_And_Get (
2135: p_encoded => FND_API.G_FALSE,
2136: p_count => x_msg_count,
2137: p_data => x_msg_data
2201: from amv_c_channels_b
2202: where channel_id = l_channel_id;
2203: --
2204: BEGIN
2205: -- Standard begin of API savepoint
2206: SAVEPOINT Update_Channel_PVT;
2207: -- Standard call to check for call compatibility.
2208: IF NOT FND_API.Compatible_API_Call (
2209: l_api_version,
2203: --
2204: BEGIN
2205: -- Standard begin of API savepoint
2206: SAVEPOINT Update_Channel_PVT;
2207: -- Standard call to check for call compatibility.
2208: IF NOT FND_API.Compatible_API_Call (
2209: l_api_version,
2210: p_api_version,
2211: l_api_name,
2611: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
2612: FND_MESSAGE.Set_Token('ROW', l_full_name);
2613: FND_MSG_PUB.Add;
2614: END IF;
2615: --Standard check of commit
2616: IF FND_API.To_Boolean ( p_commit ) THEN
2617: COMMIT WORK;
2618: END IF;
2619: -- Debug Message
2621: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2622: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2623: FND_MSG_PUB.Add;
2624: END IF;
2625: --Standard call to get message count and if count=1, get the message
2626: FND_MSG_PUB.Count_And_Get (
2627: p_encoded => FND_API.G_FALSE,
2628: p_count => x_msg_count,
2629: p_data => x_msg_data
2631: EXCEPTION
2632: WHEN FND_API.G_EXC_ERROR THEN
2633: ROLLBACK TO Update_Channel_PVT;
2634: x_return_status := FND_API.G_RET_STS_ERROR;
2635: -- Standard call to get message count and if count=1, get the message
2636: FND_MSG_PUB.Count_And_Get (
2637: p_encoded => FND_API.G_FALSE,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data
2640: );
2641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2642: ROLLBACK TO Update_Channel_PVT;
2643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2644: -- Standard call to get message count and if count=1, get the message
2645: FND_MSG_PUB.Count_And_Get (
2646: p_encoded => FND_API.G_FALSE,
2647: p_count => x_msg_count,
2648: p_data => x_msg_data
2653: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2654: THEN
2655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2656: END IF;
2657: -- Standard call to get message count and if count=1, get the message
2658: FND_MSG_PUB.Count_And_Get (
2659: p_encoded => FND_API.G_FALSE,
2660: p_count => x_msg_count,
2661: p_data => x_msg_data
2722: l_channel_id number;
2723: l_channel_exist_flag varchar2(1);
2724: --
2725: BEGIN
2726: -- Standard begin of API savepoint
2727: SAVEPOINT Get_Channel_PVT;
2728: -- Standard call to check for call compatibility.
2729: IF NOT FND_API.Compatible_API_Call (
2730: l_api_version,
2724: --
2725: BEGIN
2726: -- Standard begin of API savepoint
2727: SAVEPOINT Get_Channel_PVT;
2728: -- Standard call to check for call compatibility.
2729: IF NOT FND_API.Compatible_API_Call (
2730: l_api_version,
2731: p_api_version,
2732: l_api_name,
2802: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2803: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2804: FND_MSG_PUB.Add;
2805: END IF;
2806: --Standard call to get message count and if count=1, get the message
2807: FND_MSG_PUB.Count_And_Get (
2808: p_encoded => FND_API.G_FALSE,
2809: p_count => x_msg_count,
2810: p_data => x_msg_data
2812: EXCEPTION
2813: WHEN FND_API.G_EXC_ERROR THEN
2814: ROLLBACK TO Get_Channel_PVT;
2815: x_return_status := FND_API.G_RET_STS_ERROR;
2816: -- Standard call to get message count and if count=1, get the message
2817: FND_MSG_PUB.Count_And_Get (
2818: p_encoded => FND_API.G_FALSE,
2819: p_count => x_msg_count,
2820: p_data => x_msg_data
2821: );
2822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2823: ROLLBACK TO Get_Channel_PVT;
2824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2825: -- Standard call to get message count and if count=1, get the message
2826: FND_MSG_PUB.Count_And_Get (
2827: p_encoded => FND_API.G_FALSE,
2828: p_count => x_msg_count,
2829: p_data => x_msg_data
2834: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2835: THEN
2836: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2837: END IF;
2838: -- Standard call to get message count and if count=1, get the message
2839: FND_MSG_PUB.Count_And_Get (
2840: p_encoded => FND_API.G_FALSE,
2841: p_count => x_msg_count,
2842: p_data => x_msg_data
2912: CURSOR C_ChanContentType_Seq IS
2913: select amv_c_content_types_s.nextval
2914: from dual;
2915: BEGIN
2916: -- Standard begin of API savepoint
2917: SAVEPOINT Set_ChannelContent_PVT;
2918: -- Standard call to check for call compatibility.
2919: IF NOT FND_API.Compatible_API_Call (
2920: l_api_version,
2914: from dual;
2915: BEGIN
2916: -- Standard begin of API savepoint
2917: SAVEPOINT Set_ChannelContent_PVT;
2918: -- Standard call to check for call compatibility.
2919: IF NOT FND_API.Compatible_API_Call (
2920: l_api_version,
2921: p_api_version,
2922: l_api_name,
3100: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
3101: FND_MESSAGE.Set_Token('ROW', l_full_name);
3102: FND_MSG_PUB.Add;
3103: END IF;
3104: --Standard check of commit
3105: IF FND_API.To_Boolean ( p_commit ) THEN
3106: COMMIT WORK;
3107: END IF;
3108: -- Debug Message
3110: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3111: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3112: FND_MSG_PUB.Add;
3113: END IF;
3114: --Standard call to get message count and if count=1, get the message
3115: FND_MSG_PUB.Count_And_Get (
3116: p_encoded => FND_API.G_FALSE,
3117: p_count => x_msg_count,
3118: p_data => x_msg_data
3120: EXCEPTION
3121: WHEN FND_API.G_EXC_ERROR THEN
3122: ROLLBACK TO Set_ChannelContent_PVT;
3123: x_return_status := FND_API.G_RET_STS_ERROR;
3124: -- Standard call to get message count and if count=1, get the message
3125: FND_MSG_PUB.Count_And_Get (
3126: p_encoded => FND_API.G_FALSE,
3127: p_count => x_msg_count,
3128: p_data => x_msg_data
3129: );
3130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3131: ROLLBACK TO Set_ChannelContent_PVT;
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133: -- Standard call to get message count and if count=1, get the message
3134: FND_MSG_PUB.Count_And_Get (
3135: p_encoded => FND_API.G_FALSE,
3136: p_count => x_msg_count,
3137: p_data => x_msg_data
3142: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3143: THEN
3144: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3145: END IF;
3146: -- Standard call to get message count and if count=1, get the message
3147: FND_MSG_PUB.Count_And_Get (
3148: p_encoded => FND_API.G_FALSE,
3149: p_count => x_msg_count,
3150: p_data => x_msg_data
3217: from amv_c_content_types
3218: where channel_id = l_channel_id;
3219: --
3220: BEGIN
3221: -- Standard begin of API savepoint
3222: SAVEPOINT Get_ChannelContent_PVT;
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call (
3225: l_api_version,
3219: --
3220: BEGIN
3221: -- Standard begin of API savepoint
3222: SAVEPOINT Get_ChannelContent_PVT;
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call (
3225: l_api_version,
3226: p_api_version,
3227: l_api_name,
3306: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3307: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3308: FND_MSG_PUB.Add;
3309: END IF;
3310: --Standard call to get message count and if count=1, get the message
3311: FND_MSG_PUB.Count_And_Get (
3312: p_encoded => FND_API.G_FALSE,
3313: p_count => x_msg_count,
3314: p_data => x_msg_data
3316: EXCEPTION
3317: WHEN FND_API.G_EXC_ERROR THEN
3318: ROLLBACK TO Get_ChannelContent_PVT;
3319: x_return_status := FND_API.G_RET_STS_ERROR;
3320: -- Standard call to get message count and if count=1, get the message
3321: FND_MSG_PUB.Count_And_Get (
3322: p_encoded => FND_API.G_FALSE,
3323: p_count => x_msg_count,
3324: p_data => x_msg_data
3325: );
3326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3327: ROLLBACK TO Get_ChannelContent_PVT;
3328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3329: -- Standard call to get message count and if count=1, get the message
3330: FND_MSG_PUB.Count_And_Get (
3331: p_encoded => FND_API.G_FALSE,
3332: p_count => x_msg_count,
3333: p_data => x_msg_data
3338: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3339: THEN
3340: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3341: END IF;
3342: -- Standard call to get message count and if count=1, get the message
3343: FND_MSG_PUB.Count_And_Get (
3344: p_encoded => FND_API.G_FALSE,
3345: p_count => x_msg_count,
3346: p_data => x_msg_data
3416: CURSOR C_ChanPerspective_Seq IS
3417: select amv_c_chl_perspectives_s.nextval
3418: from dual;
3419: BEGIN
3420: -- Standard begin of API savepoint
3421: SAVEPOINT Set_ChannelPerspectives_PVT;
3422: -- Standard call to check for call compatibility.
3423: IF NOT FND_API.Compatible_API_Call (
3424: l_api_version,
3418: from dual;
3419: BEGIN
3420: -- Standard begin of API savepoint
3421: SAVEPOINT Set_ChannelPerspectives_PVT;
3422: -- Standard call to check for call compatibility.
3423: IF NOT FND_API.Compatible_API_Call (
3424: l_api_version,
3425: p_api_version,
3426: l_api_name,
3603: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
3604: FND_MESSAGE.Set_Token('ROW', l_full_name);
3605: FND_MSG_PUB.Add;
3606: END IF;
3607: --Standard check of commit
3608: IF FND_API.To_Boolean ( p_commit ) THEN
3609: COMMIT WORK;
3610: END IF;
3611: -- Debug Message
3613: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3614: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3615: FND_MSG_PUB.Add;
3616: END IF;
3617: --Standard call to get message count and if count=1, get the message
3618: FND_MSG_PUB.Count_And_Get (
3619: p_encoded => FND_API.G_FALSE,
3620: p_count => x_msg_count,
3621: p_data => x_msg_data
3623: EXCEPTION
3624: WHEN FND_API.G_EXC_ERROR THEN
3625: ROLLBACK TO Set_ChannelPerspectives_PVT;
3626: x_return_status := FND_API.G_RET_STS_ERROR;
3627: -- Standard call to get message count and if count=1, get the message
3628: FND_MSG_PUB.Count_And_Get (
3629: p_encoded => FND_API.G_FALSE,
3630: p_count => x_msg_count,
3631: p_data => x_msg_data
3632: );
3633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3634: ROLLBACK TO Set_ChannelPerspectives_PVT;
3635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3636: -- Standard call to get message count and if count=1, get the message
3637: FND_MSG_PUB.Count_And_Get (
3638: p_encoded => FND_API.G_FALSE,
3639: p_count => x_msg_count,
3640: p_data => x_msg_data
3645: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3646: THEN
3647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3648: END IF;
3649: -- Standard call to get message count and if count=1, get the message
3650: FND_MSG_PUB.Count_And_Get (
3651: p_encoded => FND_API.G_FALSE,
3652: p_count => x_msg_count,
3653: p_data => x_msg_data
3720: from amv_c_chl_perspectives
3721: where channel_id = l_channel_id;
3722: --
3723: BEGIN
3724: -- Standard begin of API savepoint
3725: SAVEPOINT Get_ChannelPerspectives_PVT;
3726: -- Standard call to check for call compatibility.
3727: IF NOT FND_API.Compatible_API_Call (
3728: l_api_version,
3722: --
3723: BEGIN
3724: -- Standard begin of API savepoint
3725: SAVEPOINT Get_ChannelPerspectives_PVT;
3726: -- Standard call to check for call compatibility.
3727: IF NOT FND_API.Compatible_API_Call (
3728: l_api_version,
3729: p_api_version,
3730: l_api_name,
3809: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3810: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3811: FND_MSG_PUB.Add;
3812: END IF;
3813: --Standard call to get message count and if count=1, get the message
3814: FND_MSG_PUB.Count_And_Get (
3815: p_encoded => FND_API.G_FALSE,
3816: p_count => x_msg_count,
3817: p_data => x_msg_data
3819: EXCEPTION
3820: WHEN FND_API.G_EXC_ERROR THEN
3821: ROLLBACK TO Get_ChannelPerspectives_PVT;
3822: x_return_status := FND_API.G_RET_STS_ERROR;
3823: -- Standard call to get message count and if count=1, get the message
3824: FND_MSG_PUB.Count_And_Get (
3825: p_encoded => FND_API.G_FALSE,
3826: p_count => x_msg_count,
3827: p_data => x_msg_data
3828: );
3829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3830: ROLLBACK TO Get_ChannelPerspectives_PVT;
3831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3832: -- Standard call to get message count and if count=1, get the message
3833: FND_MSG_PUB.Count_And_Get (
3834: p_encoded => FND_API.G_FALSE,
3835: p_count => x_msg_count,
3836: p_data => x_msg_data
3841: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3842: THEN
3843: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3844: END IF;
3845: -- Standard call to get message count and if count=1, get the message
3846: FND_MSG_PUB.Count_And_Get (
3847: p_encoded => FND_API.G_FALSE,
3848: p_count => x_msg_count,
3849: p_data => x_msg_data
3919: CURSOR C_ChanItemType_Seq IS
3920: select amv_c_item_types_s.nextval
3921: from dual;
3922: BEGIN
3923: -- Standard begin of API savepoint
3924: SAVEPOINT Set_ChannelItems_PVT;
3925: -- Standard call to check for call compatibility.
3926: IF NOT FND_API.Compatible_API_Call (
3927: l_api_version,
3921: from dual;
3922: BEGIN
3923: -- Standard begin of API savepoint
3924: SAVEPOINT Set_ChannelItems_PVT;
3925: -- Standard call to check for call compatibility.
3926: IF NOT FND_API.Compatible_API_Call (
3927: l_api_version,
3928: p_api_version,
3929: l_api_name,
4105: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
4106: FND_MESSAGE.Set_Token('ROW', l_full_name);
4107: FND_MSG_PUB.Add;
4108: END IF;
4109: --Standard check of commit
4110: IF FND_API.To_Boolean ( p_commit ) THEN
4111: COMMIT WORK;
4112: END IF;
4113: -- Debug Message
4115: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4116: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4117: FND_MSG_PUB.Add;
4118: END IF;
4119: --Standard call to get message count and if count=1, get the message
4120: FND_MSG_PUB.Count_And_Get (
4121: p_encoded => FND_API.G_FALSE,
4122: p_count => x_msg_count,
4123: p_data => x_msg_data
4125: EXCEPTION
4126: WHEN FND_API.G_EXC_ERROR THEN
4127: ROLLBACK TO Set_ChannelItems_PVT;
4128: x_return_status := FND_API.G_RET_STS_ERROR;
4129: -- Standard call to get message count and if count=1, get the message
4130: FND_MSG_PUB.Count_And_Get (
4131: p_encoded => FND_API.G_FALSE,
4132: p_count => x_msg_count,
4133: p_data => x_msg_data
4134: );
4135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4136: ROLLBACK TO Set_ChannelItems_PVT;
4137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4138: -- Standard call to get message count and if count=1, get the message
4139: FND_MSG_PUB.Count_And_Get (
4140: p_encoded => FND_API.G_FALSE,
4141: p_count => x_msg_count,
4142: p_data => x_msg_data
4147: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4148: THEN
4149: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4150: END IF;
4151: -- Standard call to get message count and if count=1, get the message
4152: FND_MSG_PUB.Count_And_Get (
4153: p_encoded => FND_API.G_FALSE,
4154: p_count => x_msg_count,
4155: p_data => x_msg_data
4222: from amv_c_item_types
4223: where channel_id = l_channel_id;
4224: --
4225: BEGIN
4226: -- Standard begin of API savepoint
4227: SAVEPOINT Get_ChannelItems_PVT;
4228: -- Standard call to check for call compatibility.
4229: IF NOT FND_API.Compatible_API_Call (
4230: l_api_version,
4224: --
4225: BEGIN
4226: -- Standard begin of API savepoint
4227: SAVEPOINT Get_ChannelItems_PVT;
4228: -- Standard call to check for call compatibility.
4229: IF NOT FND_API.Compatible_API_Call (
4230: l_api_version,
4231: p_api_version,
4232: l_api_name,
4311: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4312: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4313: FND_MSG_PUB.Add;
4314: END IF;
4315: --Standard call to get message count and if count=1, get the message
4316: FND_MSG_PUB.Count_And_Get (
4317: p_encoded => FND_API.G_FALSE,
4318: p_count => x_msg_count,
4319: p_data => x_msg_data
4321: EXCEPTION
4322: WHEN FND_API.G_EXC_ERROR THEN
4323: ROLLBACK TO Get_Get_ChannelItems_PVT;
4324: x_return_status := FND_API.G_RET_STS_ERROR;
4325: -- Standard call to get message count and if count=1, get the message
4326: FND_MSG_PUB.Count_And_Get (
4327: p_encoded => FND_API.G_FALSE,
4328: p_count => x_msg_count,
4329: p_data => x_msg_data
4330: );
4331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4332: ROLLBACK TO Get_ChannelItems_PVT;
4333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4334: -- Standard call to get message count and if count=1, get the message
4335: FND_MSG_PUB.Count_And_Get (
4336: p_encoded => FND_API.G_FALSE,
4337: p_count => x_msg_count,
4338: p_data => x_msg_data
4343: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4344: THEN
4345: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4346: END IF;
4347: -- Standard call to get message count and if count=1, get the message
4348: FND_MSG_PUB.Count_And_Get (
4349: p_encoded => FND_API.G_FALSE,
4350: p_count => x_msg_count,
4351: p_data => x_msg_data
4422: select amv_c_keywords_s.nextval
4423: from dual;
4424: --
4425: BEGIN
4426: -- Standard begin of API savepoint
4427: SAVEPOINT Set_ChannelKeywords_PVT;
4428: -- Standard call to check for call compatibility.
4429: IF NOT FND_API.Compatible_API_Call (
4430: l_api_version,
4424: --
4425: BEGIN
4426: -- Standard begin of API savepoint
4427: SAVEPOINT Set_ChannelKeywords_PVT;
4428: -- Standard call to check for call compatibility.
4429: IF NOT FND_API.Compatible_API_Call (
4430: l_api_version,
4431: p_api_version,
4432: l_api_name,
4607: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
4608: FND_MESSAGE.Set_Token('ROW', l_full_name);
4609: FND_MSG_PUB.Add;
4610: END IF;
4611: --Standard check of commit
4612: IF FND_API.To_Boolean ( p_commit ) THEN
4613: COMMIT WORK;
4614: END IF;
4615: -- Debug Message
4617: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4618: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4619: FND_MSG_PUB.Add;
4620: END IF;
4621: --Standard call to get message count and if count=1, get the message
4622: FND_MSG_PUB.Count_And_Get (
4623: p_encoded => FND_API.G_FALSE,
4624: p_count => x_msg_count,
4625: p_data => x_msg_data
4627: EXCEPTION
4628: WHEN FND_API.G_EXC_ERROR THEN
4629: ROLLBACK TO Set_ChannelKeywords_PVT;
4630: x_return_status := FND_API.G_RET_STS_ERROR;
4631: -- Standard call to get message count and if count=1, get the message
4632: FND_MSG_PUB.Count_And_Get (
4633: p_encoded => FND_API.G_FALSE,
4634: p_count => x_msg_count,
4635: p_data => x_msg_data
4636: );
4637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4638: ROLLBACK TO Set_ChannelKeywords_PVT;
4639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4640: -- Standard call to get message count and if count=1, get the message
4641: FND_MSG_PUB.Count_And_Get (
4642: p_encoded => FND_API.G_FALSE,
4643: p_count => x_msg_count,
4644: p_data => x_msg_data
4649: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4650: THEN
4651: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4652: END IF;
4653: -- Standard call to get message count and if count=1, get the message
4654: FND_MSG_PUB.Count_And_Get (
4655: p_encoded => FND_API.G_FALSE,
4656: p_count => x_msg_count,
4657: p_data => x_msg_data
4725: from amv_c_keywords
4726: where channel_id = l_channel_id;
4727: --
4728: BEGIN
4729: -- Standard begin of API savepoint
4730: SAVEPOINT Get_ChannelKeywords_PVT;
4731: -- Standard call to check for call compatibility.
4732: IF NOT FND_API.Compatible_API_Call (
4733: l_api_version,
4727: --
4728: BEGIN
4729: -- Standard begin of API savepoint
4730: SAVEPOINT Get_ChannelKeywords_PVT;
4731: -- Standard call to check for call compatibility.
4732: IF NOT FND_API.Compatible_API_Call (
4733: l_api_version,
4734: p_api_version,
4735: l_api_name,
4814: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4815: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
4816: FND_MSG_PUB.Add;
4817: END IF;
4818: --Standard call to get message count and if count=1, get the message
4819: FND_MSG_PUB.Count_And_Get (
4820: p_encoded => FND_API.G_FALSE,
4821: p_count => x_msg_count,
4822: p_data => x_msg_data
4824: EXCEPTION
4825: WHEN FND_API.G_EXC_ERROR THEN
4826: ROLLBACK TO Get_ChannelKeywords_PVT;
4827: x_return_status := FND_API.G_RET_STS_ERROR;
4828: -- Standard call to get message count and if count=1, get the message
4829: FND_MSG_PUB.Count_And_Get (
4830: p_encoded => FND_API.G_FALSE,
4831: p_count => x_msg_count,
4832: p_data => x_msg_data
4833: );
4834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4835: ROLLBACK TO Get_ChannelKeywords_PVT;
4836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4837: -- Standard call to get message count and if count=1, get the message
4838: FND_MSG_PUB.Count_And_Get (
4839: p_encoded => FND_API.G_FALSE,
4840: p_count => x_msg_count,
4841: p_data => x_msg_data
4846: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4847: THEN
4848: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4849: END IF;
4850: -- Standard call to get message count and if count=1, get the message
4851: FND_MSG_PUB.Count_And_Get (
4852: p_encoded => FND_API.G_FALSE,
4853: p_count => x_msg_count,
4854: p_data => x_msg_data
4925: select amv_c_authors_s.nextval
4926: from dual;
4927: --
4928: BEGIN
4929: -- Standard begin of API savepoint
4930: SAVEPOINT Set_ChannelAuthors_PVT;
4931: -- Standard call to check for call compatibility.
4932: IF NOT FND_API.Compatible_API_Call (
4933: l_api_version,
4927: --
4928: BEGIN
4929: -- Standard begin of API savepoint
4930: SAVEPOINT Set_ChannelAuthors_PVT;
4931: -- Standard call to check for call compatibility.
4932: IF NOT FND_API.Compatible_API_Call (
4933: l_api_version,
4934: p_api_version,
4935: l_api_name,
5110: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
5111: FND_MESSAGE.Set_Token('ROW', l_full_name);
5112: FND_MSG_PUB.Add;
5113: END IF;
5114: --Standard check of commit
5115: IF FND_API.To_Boolean ( p_commit ) THEN
5116: COMMIT WORK;
5117: END IF;
5118: -- Debug Message
5120: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5121: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
5122: FND_MSG_PUB.Add;
5123: END IF;
5124: --Standard call to get message count and if count=1, get the message
5125: FND_MSG_PUB.Count_And_Get (
5126: p_encoded => FND_API.G_FALSE,
5127: p_count => x_msg_count,
5128: p_data => x_msg_data
5130: EXCEPTION
5131: WHEN FND_API.G_EXC_ERROR THEN
5132: ROLLBACK TO Set_ChannelAuthors_PVT;
5133: x_return_status := FND_API.G_RET_STS_ERROR;
5134: -- Standard call to get message count and if count=1, get the message
5135: FND_MSG_PUB.Count_And_Get (
5136: p_encoded => FND_API.G_FALSE,
5137: p_count => x_msg_count,
5138: p_data => x_msg_data
5139: );
5140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5141: ROLLBACK TO Set_ChannelAuthors_PVT;
5142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5143: -- Standard call to get message count and if count=1, get the message
5144: FND_MSG_PUB.Count_And_Get (
5145: p_encoded => FND_API.G_FALSE,
5146: p_count => x_msg_count,
5147: p_data => x_msg_data
5152: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5153: THEN
5154: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5155: END IF;
5156: -- Standard call to get message count and if count=1, get the message
5157: FND_MSG_PUB.Count_And_Get (
5158: p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count,
5160: p_data => x_msg_data
5227: from amv_c_authors
5228: where channel_id = l_channel_id;
5229: --
5230: BEGIN
5231: -- Standard begin of API savepoint
5232: SAVEPOINT Get_ChannelAuthors_PVT;
5233: -- Standard call to check for call compatibility.
5234: IF NOT FND_API.Compatible_API_Call (
5235: l_api_version,
5229: --
5230: BEGIN
5231: -- Standard begin of API savepoint
5232: SAVEPOINT Get_ChannelAuthors_PVT;
5233: -- Standard call to check for call compatibility.
5234: IF NOT FND_API.Compatible_API_Call (
5235: l_api_version,
5236: p_api_version,
5237: l_api_name,
5316: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5317: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
5318: FND_MSG_PUB.Add;
5319: END IF;
5320: --Standard call to get message count and if count=1, get the message
5321: FND_MSG_PUB.Count_And_Get (
5322: p_encoded => FND_API.G_FALSE,
5323: p_count => x_msg_count,
5324: p_data => x_msg_data
5326: EXCEPTION
5327: WHEN FND_API.G_EXC_ERROR THEN
5328: ROLLBACK TO Get_ChannelAuthors_PVT;
5329: x_return_status := FND_API.G_RET_STS_ERROR;
5330: -- Standard call to get message count and if count=1, get the message
5331: FND_MSG_PUB.Count_And_Get (
5332: p_encoded => FND_API.G_FALSE,
5333: p_count => x_msg_count,
5334: p_data => x_msg_data
5335: );
5336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5337: ROLLBACK TO Get_ChannelAuthors_PVT;
5338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5339: -- Standard call to get message count and if count=1, get the message
5340: FND_MSG_PUB.Count_And_Get (
5341: p_encoded => FND_API.G_FALSE,
5342: p_count => x_msg_count,
5343: p_data => x_msg_data
5348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5349: THEN
5350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5351: END IF;
5352: -- Standard call to get message count and if count=1, get the message
5353: FND_MSG_PUB.Count_And_Get (
5354: p_encoded => FND_API.G_FALSE,
5355: p_count => x_msg_count,
5356: p_data => x_msg_data
5475: and nvl(ib.expiration_date, sysdate) >= sysdate
5476: order by ib.effective_start_date desc;
5477: --
5478: BEGIN
5479: -- Standard begin of API savepoint
5480: SAVEPOINT Get_ItemsPerChannel_PVT;
5481: -- Standard call to check for call compatibility.
5482: IF NOT FND_API.Compatible_API_Call (
5483: l_api_version,
5477: --
5478: BEGIN
5479: -- Standard begin of API savepoint
5480: SAVEPOINT Get_ItemsPerChannel_PVT;
5481: -- Standard call to check for call compatibility.
5482: IF NOT FND_API.Compatible_API_Call (
5483: l_api_version,
5484: p_api_version,
5485: l_api_name,
5628: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5629: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
5630: FND_MSG_PUB.Add;
5631: END IF;
5632: --Standard call to get message count and if count=1, get the message
5633: FND_MSG_PUB.Count_And_Get (
5634: p_encoded => FND_API.G_FALSE,
5635: p_count => x_msg_count,
5636: p_data => x_msg_data
5638: EXCEPTION
5639: WHEN FND_API.G_EXC_ERROR THEN
5640: ROLLBACK TO Get_ItemsPerChannel_PVT;
5641: x_return_status := FND_API.G_RET_STS_ERROR;
5642: -- Standard call to get message count and if count=1, get the message
5643: FND_MSG_PUB.Count_And_Get (
5644: p_encoded => FND_API.G_FALSE,
5645: p_count => x_msg_count,
5646: p_data => x_msg_data
5647: );
5648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5649: ROLLBACK TO Get_ItemsPerChannel_PVT;
5650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5651: -- Standard call to get message count and if count=1, get the message
5652: FND_MSG_PUB.Count_And_Get (
5653: p_encoded => FND_API.G_FALSE,
5654: p_count => x_msg_count,
5655: p_data => x_msg_data
5660: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5661: THEN
5662: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5663: END IF;
5664: -- Standard call to get message count and if count=1, get the message
5665: FND_MSG_PUB.Count_And_Get (
5666: p_encoded => FND_API.G_FALSE,
5667: p_count => x_msg_count,
5668: p_data => x_msg_data
5734: l_channel_id number;
5735: l_channel_exist_flag varchar2(1);
5736: --
5737: BEGIN
5738: -- Standard begin of API savepoint
5739: SAVEPOINT Set_ChannelApprovalStatus_PVT;
5740: -- Standard call to check for call compatibility.
5741: IF NOT FND_API.Compatible_API_Call (
5742: l_api_version,
5736: --
5737: BEGIN
5738: -- Standard begin of API savepoint
5739: SAVEPOINT Set_ChannelApprovalStatus_PVT;
5740: -- Standard call to check for call compatibility.
5741: IF NOT FND_API.Compatible_API_Call (
5742: l_api_version,
5743: p_api_version,
5744: l_api_name,
5822: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
5823: FND_MESSAGE.Set_Token('ROW', l_full_name);
5824: FND_MSG_PUB.Add;
5825: END IF;
5826: --Standard check of commit
5827: IF FND_API.To_Boolean ( p_commit ) THEN
5828: COMMIT WORK;
5829: END IF;
5830: -- Debug Message
5832: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5833: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
5834: FND_MSG_PUB.Add;
5835: END IF;
5836: --Standard call to get message count and if count=1, get the message
5837: FND_MSG_PUB.Count_And_Get (
5838: p_encoded => FND_API.G_FALSE,
5839: p_count => x_msg_count,
5840: p_data => x_msg_data
5842: EXCEPTION
5843: WHEN FND_API.G_EXC_ERROR THEN
5844: ROLLBACK TO Set_ChannelApprovalStatus_PVT;
5845: x_return_status := FND_API.G_RET_STS_ERROR;
5846: -- Standard call to get message count and if count=1, get the message
5847: FND_MSG_PUB.Count_And_Get (
5848: p_encoded => FND_API.G_FALSE,
5849: p_count => x_msg_count,
5850: p_data => x_msg_data
5851: );
5852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5853: ROLLBACK TO Set_ChannelApprovalStatus_PVT;
5854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5855: -- Standard call to get message count and if count=1, get the message
5856: FND_MSG_PUB.Count_And_Get (
5857: p_encoded => FND_API.G_FALSE,
5858: p_count => x_msg_count,
5859: p_data => x_msg_data
5864: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5865: THEN
5866: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5867: END IF;
5868: -- Standard call to get message count and if count=1, get the message
5869: FND_MSG_PUB.Count_And_Get (
5870: p_encoded => FND_API.G_FALSE,
5871: p_count => x_msg_count,
5872: p_data => x_msg_data
5970: l_notification_interval_type VARCHAR2(30);
5971: l_last_notification_time DATE;
5972: --
5973: BEGIN
5974: -- Standard begin of API savepoint
5975: SAVEPOINT Find_Channels_PVT;
5976: -- Standard call to check for call compatibility.
5977: IF NOT FND_API.Compatible_API_Call (
5978: l_api_version,
5972: --
5973: BEGIN
5974: -- Standard begin of API savepoint
5975: SAVEPOINT Find_Channels_PVT;
5976: -- Standard call to check for call compatibility.
5977: IF NOT FND_API.Compatible_API_Call (
5978: l_api_version,
5979: p_api_version,
5980: l_api_name,
6402: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6403: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
6404: FND_MSG_PUB.Add;
6405: END IF;
6406: --Standard call to get message count and if count=1, get the message
6407: FND_MSG_PUB.Count_And_Get (
6408: p_encoded => FND_API.G_FALSE,
6409: p_count => x_msg_count,
6410: p_data => x_msg_data
6412: EXCEPTION
6413: WHEN FND_API.G_EXC_ERROR THEN
6414: ROLLBACK TO Find_Channels_PVT;
6415: x_return_status := FND_API.G_RET_STS_ERROR;
6416: -- Standard call to get message count and if count=1, get the message
6417: FND_MSG_PUB.Count_And_Get (
6418: p_encoded => FND_API.G_FALSE,
6419: p_count => x_msg_count,
6420: p_data => x_msg_data
6421: );
6422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6423: ROLLBACK TO Find_Channels_PVT;
6424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6425: -- Standard call to get message count and if count=1, get the message
6426: FND_MSG_PUB.Count_And_Get (
6427: p_encoded => FND_API.G_FALSE,
6428: p_count => x_msg_count,
6429: p_data => x_msg_data
6434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6435: THEN
6436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6437: END IF;
6438: -- Standard call to get message count and if count=1, get the message
6439: FND_MSG_PUB.Count_And_Get (
6440: p_encoded => FND_API.G_FALSE,
6441: p_count => x_msg_count,
6442: p_data => x_msg_data