[Home] [Help]
582: FROM amv_c_categories_b
583: WHERE parent_channel_category_id = l_parent_category_id;
584:
585: BEGIN
586: -- Standard begin of API savepoint
587: SAVEPOINT Add_Category_PVT;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call (
590: l_api_version,
584:
585: BEGIN
586: -- Standard begin of API savepoint
587: SAVEPOINT Add_Category_PVT;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call (
590: l_api_version,
591: p_api_version,
592: l_api_name,
790: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
791: FND_MESSAGE.Set_Token('ROW', l_full_name);
792: FND_MSG_PUB.Add;
793: END IF;
794: --Standard check of commit
795: IF FND_API.To_Boolean ( p_commit ) THEN
796: COMMIT WORK;
797: END IF;
798: -- Debug Message
800: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
801: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
802: FND_MSG_PUB.Add;
803: END IF;
804: --Standard call to get message count and if count=1, get the message
805: FND_MSG_PUB.Count_And_Get (
806: p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: ROLLBACK TO Add_Category_PVT;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO Add_Category_PVT;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
832: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
835: END IF;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
923: from amv_c_channels_b
924: where channel_category_id = l_category_id;
925: --
926: BEGIN
927: -- Standard begin of API savepoint
928: SAVEPOINT Delete_Category_PVT;
929: -- Standard call to check for call compatibility.
930: IF NOT FND_API.Compatible_API_Call (
931: l_api_version,
925: --
926: BEGIN
927: -- Standard begin of API savepoint
928: SAVEPOINT Delete_Category_PVT;
929: -- Standard call to check for call compatibility.
930: IF NOT FND_API.Compatible_API_Call (
931: l_api_version,
932: p_api_version,
933: l_api_name,
1109: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1110: FND_MESSAGE.Set_Token('ROW', l_full_name);
1111: FND_MSG_PUB.Add;
1112: END IF;
1113: --Standard check of commit
1114: IF FND_API.To_Boolean ( p_commit ) THEN
1115: COMMIT WORK;
1116: END IF;
1117: -- Debug Message
1119: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1120: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1121: FND_MSG_PUB.Add;
1122: END IF;
1123: --Standard call to get message count and if count=1, get the message
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1129: EXCEPTION
1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO Delete_Category_PVT;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: -- Standard call to get message count and if count=1, get the message
1134: FND_MSG_PUB.Count_And_Get (
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: ROLLBACK TO Delete_Category_PVT;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1250: FROM amv_c_categories_b
1251: WHERE channel_category_id = l_category_id;
1252:
1253: BEGIN
1254: -- Standard begin of API savepoint
1255: SAVEPOINT Sort_Category_PVT;
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call (
1258: l_api_version,
1252:
1253: BEGIN
1254: -- Standard begin of API savepoint
1255: SAVEPOINT Sort_Category_PVT;
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call (
1258: l_api_version,
1259: p_api_version,
1260: l_api_name,
1396: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1397: FND_MESSAGE.Set_Token('ROW', l_full_name);
1398: FND_MSG_PUB.Add;
1399: END IF;
1400: --Standard check of commit
1401: IF FND_API.To_Boolean ( p_commit ) THEN
1402: COMMIT WORK;
1403: END IF;
1404: -- Debug Message
1406: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1407: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1408: FND_MSG_PUB.Add;
1409: END IF;
1410: --Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO Sort_Category_PVT;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: -- Standard call to get message count and if count=1, get the message
1421: FND_MSG_PUB.Count_And_Get (
1422: p_encoded => FND_API.G_FALSE,
1423: p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );
1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1427: ROLLBACK TO Sort_Category_PVT;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => x_msg_count,
1433: p_data => x_msg_data
1438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1512: channel_count
1513: from amv_c_categories_b
1514: where channel_category_id = l_category_id;
1515: BEGIN
1516: -- Standard begin of API savepoint
1517: SAVEPOINT Reorder_Category_PVT;
1518: -- Standard call to check for call compatibility.
1519: IF NOT FND_API.Compatible_API_Call (
1520: l_api_version,
1514: where channel_category_id = l_category_id;
1515: BEGIN
1516: -- Standard begin of API savepoint
1517: SAVEPOINT Reorder_Category_PVT;
1518: -- Standard call to check for call compatibility.
1519: IF NOT FND_API.Compatible_API_Call (
1520: l_api_version,
1521: p_api_version,
1522: l_api_name,
1616: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1617: FND_MESSAGE.Set_Token('ROW', l_full_name);
1618: FND_MSG_PUB.Add;
1619: END IF;
1620: --Standard check of commit
1621: IF FND_API.To_Boolean ( p_commit ) THEN
1622: COMMIT WORK;
1623: END IF;
1624: -- Debug Message
1626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1627: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1628: FND_MSG_PUB.Add;
1629: END IF;
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
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO Reorder_Category_PVT;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: -- Standard call to get message count and if count=1, get the message
1641: FND_MSG_PUB.Count_And_Get (
1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,
1644: p_data => x_msg_data
1645: );
1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1647: ROLLBACK TO Reorder_Category_PVT;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Standard call to get message count and if count=1, get the message
1650: FND_MSG_PUB.Count_And_Get (
1651: p_encoded => FND_API.G_FALSE,
1652: p_count => x_msg_count,
1653: p_data => x_msg_data
1658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;
1662: -- Standard call to get message count and if count=1, get the message
1663: FND_MSG_PUB.Count_And_Get (
1664: p_encoded => FND_API.G_FALSE,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data
1773:
1774: --
1775: --
1776: BEGIN
1777: -- Standard begin of API savepoint
1778: SAVEPOINT Update_Category_PVT;
1779: -- Standard call to check for call compatibility.
1780: IF NOT FND_API.Compatible_API_Call (
1781: l_api_version,
1775: --
1776: BEGIN
1777: -- Standard begin of API savepoint
1778: SAVEPOINT Update_Category_PVT;
1779: -- Standard call to check for call compatibility.
1780: IF NOT FND_API.Compatible_API_Call (
1781: l_api_version,
1782: p_api_version,
1783: l_api_name,
2025: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
2026: FND_MESSAGE.Set_Token('ROW', l_full_name);
2027: FND_MSG_PUB.Add;
2028: END IF;
2029: --Standard check of commit
2030: IF FND_API.To_Boolean ( p_commit ) THEN
2031: COMMIT WORK;
2032: END IF;
2033: -- Debug Message
2035: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2036: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2037: FND_MSG_PUB.Add;
2038: END IF;
2039: --Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE,
2042: p_count => x_msg_count,
2043: p_data => x_msg_data
2045: EXCEPTION
2046: WHEN FND_API.G_EXC_ERROR THEN
2047: ROLLBACK TO Update_Category_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: -- Standard call to get message count and if count=1, get the message
2050: FND_MSG_PUB.Count_And_Get (
2051: p_encoded => FND_API.G_FALSE,
2052: p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: ROLLBACK TO Update_Category_PVT;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: -- Standard call to get message count and if count=1, get the message
2059: FND_MSG_PUB.Count_And_Get (
2060: p_encoded => FND_API.G_FALSE,
2061: p_count => x_msg_count,
2062: p_data => x_msg_data
2067: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2068: THEN
2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;
2071: -- Standard call to get message count and if count=1, get the message
2072: FND_MSG_PUB.Count_And_Get (
2073: p_encoded => FND_API.G_FALSE,
2074: p_count => x_msg_count,
2075: p_data => x_msg_data
2226: from amv_c_channels_b
2227: where channel_category_id = l_category_id;
2228: --
2229: BEGIN
2230: -- Standard begin of API savepoint
2231: SAVEPOINT Find_Categories_PVT;
2232: -- Standard call to check for call compatibility.
2233: IF NOT FND_API.Compatible_API_Call (
2234: l_api_version,
2228: --
2229: BEGIN
2230: -- Standard begin of API savepoint
2231: SAVEPOINT Find_Categories_PVT;
2232: -- Standard call to check for call compatibility.
2233: IF NOT FND_API.Compatible_API_Call (
2234: l_api_version,
2235: p_api_version,
2236: l_api_name,
2498: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2499: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2500: FND_MSG_PUB.Add;
2501: END IF;
2502: --Standard call to get message count and if count=1, get the message
2503: FND_MSG_PUB.Count_And_Get (
2504: p_encoded => FND_API.G_FALSE,
2505: p_count => x_msg_count,
2506: p_data => x_msg_data
2508: EXCEPTION
2509: WHEN FND_API.G_EXC_ERROR THEN
2510: ROLLBACK TO Find_Categories_PVT;
2511: x_return_status := FND_API.G_RET_STS_ERROR;
2512: -- Standard call to get message count and if count=1, get the message
2513: FND_MSG_PUB.Count_And_Get (
2514: p_encoded => FND_API.G_FALSE,
2515: p_count => x_msg_count,
2516: p_data => x_msg_data
2517: );
2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2519: ROLLBACK TO Find_Categories_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data
2530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;
2534: -- Standard call to get message count and if count=1, get the message
2535: FND_MSG_PUB.Count_And_Get (
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data
2609: order by b.channel_name;
2610: --order by b.creation_date desc;
2611:
2612: BEGIN
2613: -- Standard begin of API savepoint
2614: SAVEPOINT Get_ChansPerCategory_PVT;
2615: -- Standard call to check for call compatibility.
2616: IF NOT FND_API.Compatible_API_Call (
2617: l_api_version,
2611:
2612: BEGIN
2613: -- Standard begin of API savepoint
2614: SAVEPOINT Get_ChansPerCategory_PVT;
2615: -- Standard call to check for call compatibility.
2616: IF NOT FND_API.Compatible_API_Call (
2617: l_api_version,
2618: p_api_version,
2619: l_api_name,
2724: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2725: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2726: FND_MSG_PUB.Add;
2727: END IF;
2728: --Standard call to get message count and if count=1, get the message
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => x_msg_count,
2732: p_data => x_msg_data
2734: EXCEPTION
2735: WHEN FND_API.G_EXC_ERROR THEN
2736: ROLLBACK TO Get_ChansPerCategory_PVT;
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count and if count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data
2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: ROLLBACK TO Get_ChansPerCategory_PVT;
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: -- Standard call to get message count and if count=1, get the message
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => x_msg_count,
2751: p_data => x_msg_data
2756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;
2760: -- Standard call to get message count and if count=1, get the message
2761: FND_MSG_PUB.Count_And_Get (
2762: p_encoded => FND_API.G_FALSE,
2763: p_count => x_msg_count,
2764: p_data => x_msg_data
2841: and nvl(ib.expiration_date, sysdate) >= sysdate
2842: order by ib.effective_start_date;
2843:
2844: BEGIN
2845: -- Standard begin of API savepoint
2846: SAVEPOINT Get_ItemsPerCategory_PVT;
2847: -- Standard call to check for call compatibility.
2848: IF NOT FND_API.Compatible_API_Call (
2849: l_api_version,
2843:
2844: BEGIN
2845: -- Standard begin of API savepoint
2846: SAVEPOINT Get_ItemsPerCategory_PVT;
2847: -- Standard call to check for call compatibility.
2848: IF NOT FND_API.Compatible_API_Call (
2849: l_api_version,
2850: p_api_version,
2851: l_api_name,
2954: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2955: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2956: FND_MSG_PUB.Add;
2957: END IF;
2958: --Standard call to get message count and if count=1, get the message
2959: FND_MSG_PUB.Count_And_Get (
2960: p_encoded => FND_API.G_FALSE,
2961: p_count => x_msg_count,
2962: p_data => x_msg_data
2964: EXCEPTION
2965: WHEN FND_API.G_EXC_ERROR THEN
2966: ROLLBACK TO Get_ItemsPerCategory_PVT;
2967: x_return_status := FND_API.G_RET_STS_ERROR;
2968: -- Standard call to get message count and if count=1, get the message
2969: FND_MSG_PUB.Count_And_Get (
2970: p_encoded => FND_API.G_FALSE,
2971: p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975: ROLLBACK TO Get_ItemsPerCategory_PVT;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: -- Standard call to get message count and if count=1, get the message
2978: FND_MSG_PUB.Count_And_Get (
2979: p_encoded => FND_API.G_FALSE,
2980: p_count => x_msg_count,
2981: p_data => x_msg_data
2986: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2987: THEN
2988: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2989: END IF;
2990: -- Standard call to get message count and if count=1, get the message
2991: FND_MSG_PUB.Count_And_Get (
2992: p_encoded => FND_API.G_FALSE,
2993: p_count => x_msg_count,
2994: p_data => x_msg_data
3092: and nvl(ib.effective_start_date, sysdate) <= sysdate + 1
3093: and nvl(ib.expiration_date, sysdate) >= sysdate;
3094:
3095: BEGIN
3096: -- Standard begin of API savepoint
3097: SAVEPOINT Get_ItemsPerCategory_PVT;
3098: -- Standard call to check for call compatibility.
3099: IF NOT FND_API.Compatible_API_Call (
3100: l_api_version,
3094:
3095: BEGIN
3096: -- Standard begin of API savepoint
3097: SAVEPOINT Get_ItemsPerCategory_PVT;
3098: -- Standard call to check for call compatibility.
3099: IF NOT FND_API.Compatible_API_Call (
3100: l_api_version,
3101: p_api_version,
3102: l_api_name,
3249: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3250: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3251: FND_MSG_PUB.Add;
3252: END IF;
3253: --Standard call to get message count and if count=1, get the message
3254: FND_MSG_PUB.Count_And_Get (
3255: p_encoded => FND_API.G_FALSE,
3256: p_count => x_msg_count,
3257: p_data => x_msg_data
3259: EXCEPTION
3260: WHEN FND_API.G_EXC_ERROR THEN
3261: ROLLBACK TO Get_ItemsPerCategory_PVT;
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3270: ROLLBACK TO Get_ItemsPerCategory_PVT;
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: -- Standard call to get message count and if count=1, get the message
3273: FND_MSG_PUB.Count_And_Get (
3274: p_encoded => FND_API.G_FALSE,
3275: p_count => x_msg_count,
3276: p_data => x_msg_data
3281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;
3285: -- Standard call to get message count and if count=1, get the message
3286: FND_MSG_PUB.Count_And_Get (
3287: p_encoded => FND_API.G_FALSE,
3288: p_count => x_msg_count,
3289: p_data => x_msg_data
3361: l_category_id number;
3362: l_category_exist_flag varchar2(1);
3363: --
3364: BEGIN
3365: -- Standard begin of API savepoint
3366: SAVEPOINT Fetch_CategoryId_PVT;
3367: -- Standard call to check for call compatibility.
3368: IF NOT FND_API.Compatible_API_Call (
3369: l_api_version,
3363: --
3364: BEGIN
3365: -- Standard begin of API savepoint
3366: SAVEPOINT Fetch_CategoryId_PVT;
3367: -- Standard call to check for call compatibility.
3368: IF NOT FND_API.Compatible_API_Call (
3369: l_api_version,
3370: p_api_version,
3371: l_api_name,
3438: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3439: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3440: FND_MSG_PUB.Add;
3441: END IF;
3442: --Standard call to get message count and if count=1, get the message
3443: FND_MSG_PUB.Count_And_Get (
3444: p_encoded => FND_API.G_FALSE,
3445: p_count => x_msg_count,
3446: p_data => x_msg_data
3448: EXCEPTION
3449: WHEN FND_API.G_EXC_ERROR THEN
3450: ROLLBACK TO Fetch_CategoryId_PVT;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: -- Standard call to get message count and if count=1, get the message
3453: FND_MSG_PUB.Count_And_Get (
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data
3457: );
3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK TO Fetch_CategoryId_PVT;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: -- Standard call to get message count and if count=1, get the message
3462: FND_MSG_PUB.Count_And_Get (
3463: p_encoded => FND_API.G_FALSE,
3464: p_count => x_msg_count,
3465: p_data => x_msg_data
3470: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3471: THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;
3474: -- Standard call to get message count and if count=1, get the message
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data
3534: --
3535: l_category_level number := 1;
3536: --
3537: BEGIN
3538: -- Standard begin of API savepoint
3539: SAVEPOINT Get_CatParentsHrPVT;
3540: -- Standard call to check for call compatibility.
3541: IF NOT FND_API.Compatible_API_Call (
3542: l_api_version,
3536: --
3537: BEGIN
3538: -- Standard begin of API savepoint
3539: SAVEPOINT Get_CatParentsHrPVT;
3540: -- Standard call to check for call compatibility.
3541: IF NOT FND_API.Compatible_API_Call (
3542: l_api_version,
3543: p_api_version,
3544: l_api_name,
3609: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3610: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3611: FND_MSG_PUB.Add;
3612: END IF;
3613: --Standard call to get message count and if count=1, get the message
3614: FND_MSG_PUB.Count_And_Get (
3615: p_encoded => FND_API.G_FALSE,
3616: p_count => x_msg_count,
3617: p_data => x_msg_data
3619: EXCEPTION
3620: WHEN FND_API.G_EXC_ERROR THEN
3621: ROLLBACK TO Get_CatParentsHrPVT;
3622: x_return_status := FND_API.G_RET_STS_ERROR;
3623: -- Standard call to get message count and if count=1, get the message
3624: FND_MSG_PUB.Count_And_Get (
3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,
3627: p_data => x_msg_data
3628: );
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630: ROLLBACK TO Get_CatParentsHrPVT;
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: -- Standard call to get message count and if count=1, get the message
3633: FND_MSG_PUB.Count_And_Get (
3634: p_encoded => FND_API.G_FALSE,
3635: p_count => x_msg_count,
3636: p_data => x_msg_data
3641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;
3645: -- Standard call to get message count and if count=1, get the message
3646: FND_MSG_PUB.Count_And_Get (
3647: p_encoded => FND_API.G_FALSE,
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3705: --
3706: l_category_level number := 1;
3707: --
3708: BEGIN
3709: -- Standard begin of API savepoint
3710: SAVEPOINT Get_CatChildrenHrPVT;
3711: -- Standard call to check for call compatibility.
3712: IF NOT FND_API.Compatible_API_Call (
3713: l_api_version,
3707: --
3708: BEGIN
3709: -- Standard begin of API savepoint
3710: SAVEPOINT Get_CatChildrenHrPVT;
3711: -- Standard call to check for call compatibility.
3712: IF NOT FND_API.Compatible_API_Call (
3713: l_api_version,
3714: p_api_version,
3715: l_api_name,
3780: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3781: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3782: FND_MSG_PUB.Add;
3783: END IF;
3784: --Standard call to get message count and if count=1, get the message
3785: FND_MSG_PUB.Count_And_Get (
3786: p_encoded => FND_API.G_FALSE,
3787: p_count => x_msg_count,
3788: p_data => x_msg_data
3790: EXCEPTION
3791: WHEN FND_API.G_EXC_ERROR THEN
3792: ROLLBACK TO Get_CatChildrenHrPVT;
3793: x_return_status := FND_API.G_RET_STS_ERROR;
3794: -- Standard call to get message count and if count=1, get the message
3795: FND_MSG_PUB.Count_And_Get (
3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,
3798: p_data => x_msg_data
3799: );
3800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3801: ROLLBACK TO Get_CatChildrenHrPVT;
3802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3803: -- Standard call to get message count and if count=1, get the message
3804: FND_MSG_PUB.Count_And_Get (
3805: p_encoded => FND_API.G_FALSE,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data
3812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3813: THEN
3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;
3816: -- Standard call to get message count and if count=1, get the message
3817: FND_MSG_PUB.Count_And_Get (
3818: p_encoded => FND_API.G_FALSE,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data
3888: and b.channel_id = tl.channel_id
3889: and tl.language = userenv('lang');
3890: --
3891: BEGIN
3892: -- Standard begin of API savepoint
3893: SAVEPOINT Get_ChnCategoryHierarchy;
3894: -- Standard call to check for call compatibility.
3895: IF NOT FND_API.Compatible_API_Call (
3896: l_api_version,
3890: --
3891: BEGIN
3892: -- Standard begin of API savepoint
3893: SAVEPOINT Get_ChnCategoryHierarchy;
3894: -- Standard call to check for call compatibility.
3895: IF NOT FND_API.Compatible_API_Call (
3896: l_api_version,
3897: p_api_version,
3898: l_api_name,
3965: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3966: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3967: FND_MSG_PUB.Add;
3968: END IF;
3969: --Standard call to get message count and if count=1, get the message
3970: FND_MSG_PUB.Count_And_Get (
3971: p_encoded => FND_API.G_FALSE,
3972: p_count => x_msg_count,
3973: p_data => x_msg_data
3975: EXCEPTION
3976: WHEN FND_API.G_EXC_ERROR THEN
3977: ROLLBACK TO Get_ChnCategoryHierarchy;
3978: x_return_status := FND_API.G_RET_STS_ERROR;
3979: -- Standard call to get message count and if count=1, get the message
3980: FND_MSG_PUB.Count_And_Get (
3981: p_encoded => FND_API.G_FALSE,
3982: p_count => x_msg_count,
3983: p_data => x_msg_data
3984: );
3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3986: ROLLBACK TO Get_ChnCategoryHierarchy;
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: -- Standard call to get message count and if count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,
3992: p_data => x_msg_data
3997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3998: THEN
3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;
4001: -- Standard call to get message count and if count=1, get the message
4002: FND_MSG_PUB.Count_And_Get (
4003: p_encoded => FND_API.G_FALSE,
4004: p_count => x_msg_count,
4005: p_data => x_msg_data
4089: where parent_channel_category_id = p_parent_category_id;
4090:
4091: --
4092: BEGIN
4093: -- Standard begin of API savepoint
4094: SAVEPOINT Add_CategoryParent;
4095: -- Standard call to check for call compatibility.
4096: IF NOT FND_API.Compatible_API_Call (
4097: l_api_version,
4091: --
4092: BEGIN
4093: -- Standard begin of API savepoint
4094: SAVEPOINT Add_CategoryParent;
4095: -- Standard call to check for call compatibility.
4096: IF NOT FND_API.Compatible_API_Call (
4097: l_api_version,
4098: p_api_version,
4099: l_api_name,
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266: --
4267:
4268: --Standard check of commit
4269: IF FND_API.To_Boolean ( p_commit ) THEN
4270: COMMIT WORK;
4271: END IF;
4272:
4275: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4276: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4277: FND_MSG_PUB.Add;
4278: END IF;
4279: --Standard call to get message count and if count=1, get the message
4280: FND_MSG_PUB.Count_And_Get (
4281: p_encoded => FND_API.G_FALSE,
4282: p_count => x_msg_count,
4283: p_data => x_msg_data
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: ROLLBACK TO Add_CategoryParent;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: -- Standard call to get message count and if count=1, get the message
4290: FND_MSG_PUB.Count_And_Get (
4291: p_encoded => FND_API.G_FALSE,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data
4294: );
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: ROLLBACK TO Add_CategoryParent;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: -- Standard call to get message count and if count=1, get the message
4299: FND_MSG_PUB.Count_And_Get (
4300: p_encoded => FND_API.G_FALSE,
4301: p_count => x_msg_count,
4302: p_data => x_msg_data
4307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4308: THEN
4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;
4311: -- Standard call to get message count and if count=1, get the message
4312: FND_MSG_PUB.Count_And_Get (
4313: p_encoded => FND_API.G_FALSE,
4314: p_count => x_msg_count,
4315: p_data => x_msg_data
4381: from amv_c_categories_b b
4382: where b.channel_category_id = p_category_id;
4383: --
4384: BEGIN
4385: -- Standard begin of API savepoint
4386: SAVEPOINT Remove_CategoryParent;
4387: -- Standard call to check for call compatibility.
4388: IF NOT FND_API.Compatible_API_Call (
4389: l_api_version,
4383: --
4384: BEGIN
4385: -- Standard begin of API savepoint
4386: SAVEPOINT Remove_CategoryParent;
4387: -- Standard call to check for call compatibility.
4388: IF NOT FND_API.Compatible_API_Call (
4389: l_api_version,
4390: p_api_version,
4391: l_api_name,
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: --
4488:
4489: --Standard check of commit
4490: IF FND_API.To_Boolean ( p_commit ) THEN
4491: COMMIT WORK;
4492: END IF;
4493:
4496: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4497: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4498: FND_MSG_PUB.Add;
4499: END IF;
4500: --Standard call to get message count and if count=1, get the message
4501: FND_MSG_PUB.Count_And_Get (
4502: p_encoded => FND_API.G_FALSE,
4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4506: EXCEPTION
4507: WHEN FND_API.G_EXC_ERROR THEN
4508: ROLLBACK TO Remove_CategoryParent;
4509: x_return_status := FND_API.G_RET_STS_ERROR;
4510: -- Standard call to get message count and if count=1, get the message
4511: FND_MSG_PUB.Count_And_Get (
4512: p_encoded => FND_API.G_FALSE,
4513: p_count => x_msg_count,
4514: p_data => x_msg_data
4515: );
4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4517: ROLLBACK TO Remove_CategoryParent;
4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4519: -- Standard call to get message count and if count=1, get the message
4520: FND_MSG_PUB.Count_And_Get (
4521: p_encoded => FND_API.G_FALSE,
4522: p_count => x_msg_count,
4523: p_data => x_msg_data
4528: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4529: THEN
4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;
4532: -- Standard call to get message count and if count=1, get the message
4533: FND_MSG_PUB.Count_And_Get (
4534: p_encoded => FND_API.G_FALSE,
4535: p_count => x_msg_count,
4536: p_data => x_msg_data