[Home] [Help]
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: END IF;
521: -- Debug Message
522: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
523: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
524: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
525: FND_MSG_PUB.Add;
526: END IF;
527: --Initialize message list if p_init_msg_list is TRUE.
520: END IF;
521: -- Debug Message
522: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
523: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
524: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
525: FND_MSG_PUB.Add;
526: END IF;
527: --Initialize message list if p_init_msg_list is TRUE.
528: IF FND_API.To_Boolean (p_init_msg_list) THEN
540: -- Check if user is login and has the required privilege.
541: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
542: -- User is not login.
543: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
544: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
545: FND_MSG_PUB.Add;
546: END IF;
547: RAISE FND_API.G_EXC_ERROR;
548: END IF;
575: -- raise exception if null values passed
576: IF l_error_flag = FND_API.G_TRUE THEN
577: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
578: THEN
579: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_OBJ_VALUES');
580: FND_MESSAGE.Set_Token('TKN', 'Channel');
581: FND_MSG_PUB.Add;
582: END IF;
583: RAISE FND_API.G_EXC_ERROR;
576: IF l_error_flag = FND_API.G_TRUE THEN
577: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
578: THEN
579: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_OBJ_VALUES');
580: FND_MESSAGE.Set_Token('TKN', 'Channel');
581: FND_MSG_PUB.Add;
582: END IF;
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
657: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
658: IF (l_channel_exist_flag = FND_API.G_TRUE) THEN
659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
660: THEN
661: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
662: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
663: FND_MSG_PUB.Add;
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;
658: IF (l_channel_exist_flag = FND_API.G_TRUE) THEN
659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
660: THEN
661: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
662: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
663: FND_MSG_PUB.Add;
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;
666: ELSE
743: WHEN OTHERS THEN
744: --will log the error
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
746: THEN
747: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
748: FND_MESSAGE.Set_Token('ACTION', 'Adding Channel');
749: FND_MESSAGE.Set_Token('TABLE', sqlerrm);
750: FND_MSG_PUB.Add;
751: END IF;
744: --will log the error
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
746: THEN
747: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
748: FND_MESSAGE.Set_Token('ACTION', 'Adding Channel');
749: FND_MESSAGE.Set_Token('TABLE', sqlerrm);
750: FND_MSG_PUB.Add;
751: END IF;
752: RAISE FND_API.G_EXC_ERROR;
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
746: THEN
747: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
748: FND_MESSAGE.Set_Token('ACTION', 'Adding Channel');
749: FND_MESSAGE.Set_Token('TABLE', sqlerrm);
750: FND_MSG_PUB.Add;
751: END IF;
752: RAISE FND_API.G_EXC_ERROR;
753: END;
757: ELSE
758: -- exception errors from get_channelstatus
759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
760: THEN
761: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
762: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
763: FND_MSG_PUB.Add;
764: END IF;
765: RAISE FND_API.G_EXC_ERROR;
758: -- exception errors from get_channelstatus
759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
760: THEN
761: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
762: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
763: FND_MSG_PUB.Add;
764: END IF;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
768:
769: -- Success message
770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
771: THEN
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
769: -- Success message
770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
771: THEN
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
781: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
779: END IF;
780: -- Debug Message
781: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
897: END IF;
898: -- Debug Message
899: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
900: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
901: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
902: FND_MSG_PUB.Add;
903: END IF;
904: --Initialize message list if p_init_msg_list is TRUE.
897: END IF;
898: -- Debug Message
899: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
900: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
901: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
902: FND_MSG_PUB.Add;
903: END IF;
904: --Initialize message list if p_init_msg_list is TRUE.
905: IF FND_API.To_Boolean (p_init_msg_list) THEN
917: -- Check if user is login and has the required privilege.
918: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
919: -- User is not login.
920: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
921: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
922: FND_MSG_PUB.Add;
923: END IF;
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
983: ELSE
984: -- Invalid channel type passed
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
986: THEN
987: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
988: FND_MESSAGE.Set_Token('TKN','Content');
989: FND_MSG_PUB.Add;
990: END IF;
991: END IF;
984: -- Invalid channel type passed
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
986: THEN
987: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
988: FND_MESSAGE.Set_Token('TKN','Content');
989: FND_MSG_PUB.Add;
990: END IF;
991: END IF;
992: ELSE
992: ELSE
993: -- Invalid channel type passed
994: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
995: THEN
996: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
997: FND_MESSAGE.Set_Token('TKN','Public');
998: FND_MSG_PUB.Add;
999: END IF;
1000: END IF;
993: -- Invalid channel type passed
994: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
995: THEN
996: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
997: FND_MESSAGE.Set_Token('TKN','Public');
998: FND_MSG_PUB.Add;
999: END IF;
1000: END IF;
1001: ELSE
1001: ELSE
1002: -- user does not have privilege to create public channel
1003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1004: THEN
1005: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1006: FND_MESSAGE.Set_Token('LEVEL','Channel');
1007: FND_MSG_PUB.Add;
1008: END IF;
1009: RAISE FND_API.G_EXC_ERROR;
1002: -- user does not have privilege to create public channel
1003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1004: THEN
1005: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1006: FND_MESSAGE.Set_Token('LEVEL','Channel');
1007: FND_MSG_PUB.Add;
1008: END IF;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011: ELSE
1012: -- error while user privilege check in Can_SetupChannel
1013: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1014: THEN
1015: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1016: FND_MESSAGE.Set_Token('LEVEL','Channel');
1017: FND_MSG_PUB.Add;
1018: END IF;
1019: RAISE FND_API.G_EXC_ERROR;
1012: -- error while user privilege check in Can_SetupChannel
1013: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1014: THEN
1015: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1016: FND_MESSAGE.Set_Token('LEVEL','Channel');
1017: FND_MSG_PUB.Add;
1018: END IF;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1022:
1023: -- Success message
1024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1025: THEN
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
1023: -- Success message
1024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1025: THEN
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
1035: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
1033: END IF;
1034: -- Debug Message
1035: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: -- Debug Message
1154: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1155: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1156: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1157: FND_MSG_PUB.Add;
1158: END IF;
1159: --Initialize message list if p_init_msg_list is TRUE.
1152: END IF;
1153: -- Debug Message
1154: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1155: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1156: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1157: FND_MSG_PUB.Add;
1158: END IF;
1159: --Initialize message list if p_init_msg_list is TRUE.
1160: IF FND_API.To_Boolean (p_init_msg_list) THEN
1172: -- Check if user is login and has the required privilege.
1173: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1174: -- User is not login.
1175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1176: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1177: FND_MSG_PUB.Add;
1178: END IF;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1238: ELSE
1239: -- Invalid channel type passed
1240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1241: THEN
1242: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1243: FND_MESSAGE.Set_Token('TKN','Content');
1244: FND_MSG_PUB.Add;
1245: END IF;
1246: END IF;
1239: -- Invalid channel type passed
1240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1241: THEN
1242: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1243: FND_MESSAGE.Set_Token('TKN','Content');
1244: FND_MSG_PUB.Add;
1245: END IF;
1246: END IF;
1247: ELSE
1247: ELSE
1248: -- Invalid channel type passed
1249: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1250: THEN
1251: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
1252: FND_MESSAGE.Set_Token('TKN','Protected');
1253: FND_MSG_PUB.Add;
1254: END IF;
1255: END IF;
1248: -- Invalid channel type passed
1249: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1250: THEN
1251: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
1252: FND_MESSAGE.Set_Token('TKN','Protected');
1253: FND_MSG_PUB.Add;
1254: END IF;
1255: END IF;
1256: ELSE
1256: ELSE
1257: -- user does not have privilege to create public channel
1258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1259: THEN
1260: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1261: FND_MESSAGE.Set_Token('LEVEL','Channel');
1262: FND_MSG_PUB.Add;
1263: END IF;
1264: RAISE FND_API.G_EXC_ERROR;
1257: -- user does not have privilege to create public channel
1258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1259: THEN
1260: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1261: FND_MESSAGE.Set_Token('LEVEL','Channel');
1262: FND_MSG_PUB.Add;
1263: END IF;
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266: ELSE
1267: -- error while user privilege check in Can_SetupChannel
1268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1269: THEN
1270: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1271: FND_MESSAGE.Set_Token('LEVEL','Channel');
1272: FND_MSG_PUB.Add;
1273: END IF;
1274: RAISE FND_API.G_EXC_ERROR;
1267: -- error while user privilege check in Can_SetupChannel
1268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1269: THEN
1270: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1271: FND_MESSAGE.Set_Token('LEVEL','Channel');
1272: FND_MSG_PUB.Add;
1273: END IF;
1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1277:
1278: -- Success message
1279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1280: THEN
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
1278: -- Success message
1279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1280: THEN
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
1290: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
1288: END IF;
1289: -- Debug Message
1290: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: END IF;
1407: -- Debug Message
1408: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1409: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1410: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1411: FND_MSG_PUB.Add;
1412: END IF;
1413: --Initialize message list if p_init_msg_list is TRUE.
1406: END IF;
1407: -- Debug Message
1408: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1409: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1410: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1411: FND_MSG_PUB.Add;
1412: END IF;
1413: --Initialize message list if p_init_msg_list is TRUE.
1414: IF FND_API.To_Boolean (p_init_msg_list) THEN
1426: -- Check if user is login and has the required privilege.
1427: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1428: -- User is not login.
1429: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1430: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1431: FND_MSG_PUB.Add;
1432: END IF;
1433: RAISE FND_API.G_EXC_ERROR;
1434: END IF;
1508: ELSE
1509: -- Invalid channel type passed
1510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1511: THEN
1512: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1513: FND_MESSAGE.Set_Token('TKN','Content');
1514: FND_MSG_PUB.Add;
1515: END IF;
1516: END IF;
1509: -- Invalid channel type passed
1510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1511: THEN
1512: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1513: FND_MESSAGE.Set_Token('TKN','Content');
1514: FND_MSG_PUB.Add;
1515: END IF;
1516: END IF;
1517: ELSE
1517: ELSE
1518: -- Invalid channel type passed
1519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1520: THEN
1521: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
1522: FND_MESSAGE.Set_Token('TKN','Protected');
1523: FND_MSG_PUB.Add;
1524: END IF;
1525: END IF;
1518: -- Invalid channel type passed
1519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1520: THEN
1521: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_ACCS');
1522: FND_MESSAGE.Set_Token('TKN','Protected');
1523: FND_MSG_PUB.Add;
1524: END IF;
1525: END IF;
1526: --
1527:
1528: -- Success message
1529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1530: THEN
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
1528: -- Success message
1529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1530: THEN
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
1540: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
1538: END IF;
1539: -- Debug Message
1540: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;
1672: -- Debug Message
1673: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1674: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1675: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1676: FND_MSG_PUB.Add;
1677: END IF;
1678: --Initialize message list if p_init_msg_list is TRUE.
1671: END IF;
1672: -- Debug Message
1673: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1674: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1675: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1676: FND_MSG_PUB.Add;
1677: END IF;
1678: --Initialize message list if p_init_msg_list is TRUE.
1679: IF FND_API.To_Boolean (p_init_msg_list) THEN
1691: -- Check if user is login and has the required privilege.
1692: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1693: -- User is not login.
1694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1695: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1696: FND_MSG_PUB.Add;
1697: END IF;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1718: IF l_group_name is null THEN
1719: -- Invalid channel type passed
1720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1721: THEN
1722: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_GROUP_ID');
1723: FND_MESSAGE.Set_Token('TKN',p_group_id);
1724: FND_MSG_PUB.Add;
1725: END IF;
1726: RAISE FND_API.G_EXC_ERROR;
1719: -- Invalid channel type passed
1720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1721: THEN
1722: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_GROUP_ID');
1723: FND_MESSAGE.Set_Token('TKN',p_group_id);
1724: FND_MSG_PUB.Add;
1725: END IF;
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1796: ELSE
1797: -- Invalid channel type passed
1798: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1799: THEN
1800: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1801: FND_MESSAGE.Set_Token('TKN','Group');
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;
1797: -- Invalid channel type passed
1798: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1799: THEN
1800: FND_MESSAGE.Set_Name('AMV','AMV_INVALID_CHAN_TYPE');
1801: FND_MESSAGE.Set_Token('TKN','Group');
1802: FND_MSG_PUB.Add;
1803: END IF;
1804: RAISE FND_API.G_EXC_ERROR;
1805: END IF;
1807:
1808: -- Success message
1809: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1810: THEN
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
1808: -- Success message
1809: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1810: THEN
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
1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
1818: END IF;
1819: -- Debug Message
1820: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1939: END IF;
1940: -- Debug Message
1941: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1942: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1943: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1944: FND_MSG_PUB.Add;
1945: END IF;
1946: --Initialize message list if p_init_msg_list is TRUE.
1939: END IF;
1940: -- Debug Message
1941: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1942: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1943: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1944: FND_MSG_PUB.Add;
1945: END IF;
1946: --Initialize message list if p_init_msg_list is TRUE.
1947: IF FND_API.To_Boolean (p_init_msg_list) THEN
1959: -- Check if user is login and has the required privilege.
1960: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1961: -- User is not login.
1962: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1963: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1964: FND_MSG_PUB.Add;
1965: END IF;
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1990: -- remove channel if it exists
1991: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
1992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1993: THEN
1994: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
1995: FND_MESSAGE.Set_Token('CHN',l_Error_Token);
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1991: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
1992: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1993: THEN
1994: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
1995: FND_MESSAGE.Set_Token('CHN',l_Error_Token);
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: ELSE
2023: ELSE
2024: -- user does not have privilege to create public channel
2025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2026: THEN
2027: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
2028: FND_MESSAGE.Set_Token('LEVEL','Channel');
2029: FND_MSG_PUB.Add;
2030: END IF;
2031: RAISE FND_API.G_EXC_ERROR;
2024: -- user does not have privilege to create public channel
2025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2026: THEN
2027: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
2028: FND_MESSAGE.Set_Token('LEVEL','Channel');
2029: FND_MSG_PUB.Add;
2030: END IF;
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2034: ELSE
2035: -- error while user privilege check in Can_SetupChannel
2036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2037: THEN
2038: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
2039: FND_MESSAGE.Set_Token('LEVEL','Channel');
2040: FND_MSG_PUB.Add;
2041: END IF;
2042: RAISE FND_API.G_EXC_ERROR;
2035: -- error while user privilege check in Can_SetupChannel
2036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2037: THEN
2038: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
2039: FND_MESSAGE.Set_Token('LEVEL','Channel');
2040: FND_MSG_PUB.Add;
2041: END IF;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2083:
2084: -- Success message
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2086: THEN
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
2084: -- Success message
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2086: THEN
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
2096: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
2094: END IF;
2095: -- Debug Message
2096: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216: -- Debug Message
2217: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2218: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2220: FND_MSG_PUB.Add;
2221: END IF;
2222: --Initialize message list if p_init_msg_list is TRUE.
2215: END IF;
2216: -- Debug Message
2217: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2218: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2219: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2220: FND_MSG_PUB.Add;
2221: END IF;
2222: --Initialize message list if p_init_msg_list is TRUE.
2223: IF FND_API.To_Boolean (p_init_msg_list) THEN
2235: -- Check if user is login and has the required privilege.
2236: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2237: -- User is not login.
2238: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2239: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2240: FND_MSG_PUB.Add;
2241: END IF;
2242: RAISE FND_API.G_EXC_ERROR;
2243: END IF;
2266: -- check if channel exists
2267: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2269: THEN
2270: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
2271: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2272: FND_MSG_PUB.Add;
2273: END IF;
2274: RAISE FND_API.G_EXC_ERROR;
2267: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2269: THEN
2270: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
2271: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2272: FND_MSG_PUB.Add;
2273: END IF;
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSE
2301: ELSE
2302: -- user does not have privilege to create public channel
2303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2304: THEN
2305: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
2306: FND_MESSAGE.Set_Token('LEVEL','Channel');
2307: FND_MSG_PUB.Add;
2308: END IF;
2309: RAISE FND_API.G_EXC_ERROR;
2302: -- user does not have privilege to create public channel
2303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2304: THEN
2305: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
2306: FND_MESSAGE.Set_Token('LEVEL','Channel');
2307: FND_MSG_PUB.Add;
2308: END IF;
2309: RAISE FND_API.G_EXC_ERROR;
2310: END IF;
2312: ELSE
2313: -- error while user privilege check in Can_SetupChannel
2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2315: THEN
2316: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
2317: FND_MESSAGE.Set_Token('LEVEL','Channel');
2318: FND_MSG_PUB.Add;
2319: END IF;
2320: RAISE FND_API.G_EXC_ERROR;
2313: -- error while user privilege check in Can_SetupChannel
2314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2315: THEN
2316: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
2317: FND_MESSAGE.Set_Token('LEVEL','Channel');
2318: FND_MSG_PUB.Add;
2319: END IF;
2320: RAISE FND_API.G_EXC_ERROR;
2321: END IF;
2495: l_channel_obj.channel_name := p_channel_record.channel_name;
2496: ELSE
2497: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2498: THEN
2499: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2500: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2501: FND_MSG_PUB.Add;
2502: END IF;
2503: RAISE FND_API.G_EXC_ERROR;
2496: ELSE
2497: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2498: THEN
2499: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2500: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2501: FND_MSG_PUB.Add;
2502: END IF;
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2504: END IF;
2505: ELSE
2506: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2507: THEN
2508: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2509: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2510: FND_MSG_PUB.Add;
2511: END IF;
2512: RAISE FND_API.G_EXC_ERROR;
2505: ELSE
2506: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2507: THEN
2508: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2509: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2510: FND_MSG_PUB.Add;
2511: END IF;
2512: RAISE FND_API.G_EXC_ERROR;
2513: END IF;
2573: WHEN OTHERS THEN
2574: --will log the error
2575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2576: THEN
2577: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
2578: FND_MESSAGE.Set_Token('ACTION', 'Updating');
2579: FND_MESSAGE.Set_Token('TABLE', 'Channel');
2580: FND_MSG_PUB.Add;
2581: END IF;
2574: --will log the error
2575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2576: THEN
2577: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
2578: FND_MESSAGE.Set_Token('ACTION', 'Updating');
2579: FND_MESSAGE.Set_Token('TABLE', 'Channel');
2580: FND_MSG_PUB.Add;
2581: END IF;
2582: RAISE FND_API.G_EXC_ERROR;
2575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2576: THEN
2577: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
2578: FND_MESSAGE.Set_Token('ACTION', 'Updating');
2579: FND_MESSAGE.Set_Token('TABLE', 'Channel');
2580: FND_MSG_PUB.Add;
2581: END IF;
2582: RAISE FND_API.G_EXC_ERROR;
2583: END;
2596: END IF;
2597: ELSE
2598: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2599: THEN
2600: FND_MESSAGE.Set_Name('AMV', 'AMV_CHN_VERSION_CHANGE');
2601: FND_MSG_PUB.Add;
2602: END IF;
2603: RAISE FND_API.G_EXC_ERROR;
2604: END IF;
2607:
2608: -- Success message
2609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2610: THEN
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
2608: -- Success message
2609: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2610: THEN
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
2620: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
2618: END IF;
2619: -- Debug Message
2620: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
2735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2736: END IF;
2737: -- Debug Message
2738: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2739: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2740: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2741: FND_MSG_PUB.Add;
2742: END IF;
2743: --Initialize message list if p_init_msg_list is TRUE.
2736: END IF;
2737: -- Debug Message
2738: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2739: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2740: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2741: FND_MSG_PUB.Add;
2742: END IF;
2743: --Initialize message list if p_init_msg_list is TRUE.
2744: IF FND_API.To_Boolean (p_init_msg_list) THEN
2756: -- Check if user is login and has the required privilege.
2757: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2758: -- User is not login.
2759: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2760: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2761: FND_MSG_PUB.Add;
2762: END IF;
2763: RAISE FND_API.G_EXC_ERROR;
2764: END IF;
2786: -- check if channel exists
2787: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2789: THEN
2790: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2791: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2792: FND_MSG_PUB.Add;
2793: END IF;
2794: RAISE FND_API.G_EXC_ERROR;
2787: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2789: THEN
2790: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2791: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2792: FND_MSG_PUB.Add;
2793: END IF;
2794: RAISE FND_API.G_EXC_ERROR;
2795: ELSE
2798: --
2799:
2800: -- Debug Message
2801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
2799:
2800: -- Debug Message
2801: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2926: END IF;
2927: -- Debug Message
2928: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2929: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2930: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2931: FND_MSG_PUB.Add;
2932: END IF;
2933: --Initialize message list if p_init_msg_list is TRUE.
2926: END IF;
2927: -- Debug Message
2928: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2929: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2930: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2931: FND_MSG_PUB.Add;
2932: END IF;
2933: --Initialize message list if p_init_msg_list is TRUE.
2934: IF FND_API.To_Boolean (p_init_msg_list) THEN
2946: -- Check if user is login and has the required privilege.
2947: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2948: -- User is not login.
2949: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2950: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2951: FND_MSG_PUB.Add;
2952: END IF;
2953: RAISE FND_API.G_EXC_ERROR;
2954: END IF;
2976: -- change channel categories if the channel exists
2977: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2978: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2979: THEN
2980: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
2981: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2982: FND_MSG_PUB.Add;
2983: END IF;
2984: RAISE FND_API.G_EXC_ERROR;
2977: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
2978: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2979: THEN
2980: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
2981: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
2982: FND_MSG_PUB.Add;
2983: END IF;
2984: RAISE FND_API.G_EXC_ERROR;
2985: ELSE
3010: ELSE
3011: -- user does not have privilege to create public channel
3012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3013: THEN
3014: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
3015: FND_MESSAGE.Set_Token('LEVEL','Channel');
3016: FND_MSG_PUB.Add;
3017: END IF;
3018: RAISE FND_API.G_EXC_ERROR;
3011: -- user does not have privilege to create public channel
3012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3013: THEN
3014: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
3015: FND_MESSAGE.Set_Token('LEVEL','Channel');
3016: FND_MSG_PUB.Add;
3017: END IF;
3018: RAISE FND_API.G_EXC_ERROR;
3019: END IF;
3021: ELSE
3022: -- error while user privilege check in Can_SetupChannel
3023: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3024: THEN
3025: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
3026: FND_MESSAGE.Set_Token('LEVEL','Channel');
3027: FND_MSG_PUB.Add;
3028: END IF;
3029: RAISE FND_API.G_EXC_ERROR;
3022: -- error while user privilege check in Can_SetupChannel
3023: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3024: THEN
3025: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
3026: FND_MESSAGE.Set_Token('LEVEL','Channel');
3027: FND_MSG_PUB.Add;
3028: END IF;
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3096:
3097: -- Success message
3098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3099: THEN
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
3097: -- Success message
3098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3099: THEN
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
3109: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
3107: END IF;
3108: -- Debug Message
3109: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
3230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3231: END IF;
3232: -- Debug Message
3233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3234: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3235: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3236: FND_MSG_PUB.Add;
3237: END IF;
3238: --Initialize message list if p_init_msg_list is TRUE.
3231: END IF;
3232: -- Debug Message
3233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3234: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3235: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3236: FND_MSG_PUB.Add;
3237: END IF;
3238: --Initialize message list if p_init_msg_list is TRUE.
3239: IF FND_API.To_Boolean (p_init_msg_list) THEN
3251: -- Check if user is login and has the required privilege.
3252: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3253: -- User is not login.
3254: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3255: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3256: FND_MSG_PUB.Add;
3257: END IF;
3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;
3281: -- get channel categories if the channel exists
3282: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3284: THEN
3285: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3286: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3287: FND_MSG_PUB.Add;
3288: END IF;
3289: RAISE FND_API.G_EXC_ERROR;
3282: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3284: THEN
3285: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3286: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3287: FND_MSG_PUB.Add;
3288: END IF;
3289: RAISE FND_API.G_EXC_ERROR;
3290: ELSE
3302: --
3303:
3304: -- Debug Message
3305: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
3303:
3304: -- Debug Message
3305: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
3429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3430: END IF;
3431: -- Debug Message
3432: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3433: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3434: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3435: FND_MSG_PUB.Add;
3436: END IF;
3437: --Initialize message list if p_init_msg_list is TRUE.
3430: END IF;
3431: -- Debug Message
3432: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3433: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3434: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3435: FND_MSG_PUB.Add;
3436: END IF;
3437: --Initialize message list if p_init_msg_list is TRUE.
3438: IF FND_API.To_Boolean (p_init_msg_list) THEN
3450: -- Check if user is login and has the required privilege.
3451: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3452: -- User is not login.
3453: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3454: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3455: FND_MSG_PUB.Add;
3456: END IF;
3457: RAISE FND_API.G_EXC_ERROR;
3458: END IF;
3480: -- change perspectives if the channel exists
3481: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3483: THEN
3484: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3485: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3486: FND_MSG_PUB.Add;
3487: END IF;
3488: RAISE FND_API.G_EXC_ERROR;
3481: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3483: THEN
3484: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3485: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3486: FND_MSG_PUB.Add;
3487: END IF;
3488: RAISE FND_API.G_EXC_ERROR;
3489: ELSE
3514: ELSE
3515: -- user does not have privilege to create public channel
3516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3517: THEN
3518: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
3519: FND_MESSAGE.Set_Token('LEVEL','Channel');
3520: FND_MSG_PUB.Add;
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3515: -- user does not have privilege to create public channel
3516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3517: THEN
3518: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
3519: FND_MESSAGE.Set_Token('LEVEL','Channel');
3520: FND_MSG_PUB.Add;
3521: END IF;
3522: RAISE FND_API.G_EXC_ERROR;
3523: END IF;
3525: ELSE
3526: -- error while user privilege check in Can_SetupChannel
3527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3528: THEN
3529: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
3530: FND_MESSAGE.Set_Token('LEVEL','Channel');
3531: FND_MSG_PUB.Add;
3532: END IF;
3533: RAISE FND_API.G_EXC_ERROR;
3526: -- error while user privilege check in Can_SetupChannel
3527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3528: THEN
3529: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
3530: FND_MESSAGE.Set_Token('LEVEL','Channel');
3531: FND_MSG_PUB.Add;
3532: END IF;
3533: RAISE FND_API.G_EXC_ERROR;
3534: END IF;
3599:
3600: -- Success message
3601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3602: THEN
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
3600: -- Success message
3601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3602: THEN
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
3612: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
3610: END IF;
3611: -- Debug Message
3612: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
3733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3734: END IF;
3735: -- Debug Message
3736: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3737: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3738: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3739: FND_MSG_PUB.Add;
3740: END IF;
3741: --Initialize message list if p_init_msg_list is TRUE.
3734: END IF;
3735: -- Debug Message
3736: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3737: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3738: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3739: FND_MSG_PUB.Add;
3740: END IF;
3741: --Initialize message list if p_init_msg_list is TRUE.
3742: IF FND_API.To_Boolean (p_init_msg_list) THEN
3754: -- Check if user is login and has the required privilege.
3755: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3756: -- User is not login.
3757: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3758: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3759: FND_MSG_PUB.Add;
3760: END IF;
3761: RAISE FND_API.G_EXC_ERROR;
3762: END IF;
3784: -- get channel perspectives if the channel exists
3785: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3787: THEN
3788: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3789: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3790: FND_MSG_PUB.Add;
3791: END IF;
3792: RAISE FND_API.G_EXC_ERROR;
3785: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3787: THEN
3788: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3789: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3790: FND_MSG_PUB.Add;
3791: END IF;
3792: RAISE FND_API.G_EXC_ERROR;
3793: ELSE
3805: --
3806:
3807: -- Debug Message
3808: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
3806:
3807: -- Debug Message
3808: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934: -- Debug Message
3935: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3936: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3937: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3938: FND_MSG_PUB.Add;
3939: END IF;
3940: --Initialize message list if p_init_msg_list is TRUE.
3933: END IF;
3934: -- Debug Message
3935: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3936: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3937: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3938: FND_MSG_PUB.Add;
3939: END IF;
3940: --Initialize message list if p_init_msg_list is TRUE.
3941: IF FND_API.To_Boolean (p_init_msg_list) THEN
3953: -- Check if user is login and has the required privilege.
3954: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3955: -- User is not login.
3956: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3957: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3958: FND_MSG_PUB.Add;
3959: END IF;
3960: RAISE FND_API.G_EXC_ERROR;
3961: END IF;
3983: -- change usergroups if the channel exists
3984: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3986: THEN
3987: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3988: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3989: FND_MSG_PUB.Add;
3990: END IF;
3991: RAISE FND_API.G_EXC_ERROR;
3984: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
3985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3986: THEN
3987: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3988: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3989: FND_MSG_PUB.Add;
3990: END IF;
3991: RAISE FND_API.G_EXC_ERROR;
3992: ELSE
4017: ELSE
4018: -- user does not have privilege to create public channel
4019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4020: THEN
4021: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
4022: FND_MESSAGE.Set_Token('LEVEL','Channel');
4023: FND_MSG_PUB.Add;
4024: END IF;
4025: RAISE FND_API.G_EXC_ERROR;
4018: -- user does not have privilege to create public channel
4019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4020: THEN
4021: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
4022: FND_MESSAGE.Set_Token('LEVEL','Channel');
4023: FND_MSG_PUB.Add;
4024: END IF;
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4028: ELSE
4029: -- error while user privilege check in Can_SetupChannel
4030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4031: THEN
4032: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
4033: FND_MESSAGE.Set_Token('LEVEL','Channel');
4034: FND_MSG_PUB.Add;
4035: END IF;
4036: RAISE FND_API.G_EXC_ERROR;
4029: -- error while user privilege check in Can_SetupChannel
4030: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4031: THEN
4032: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
4033: FND_MESSAGE.Set_Token('LEVEL','Channel');
4034: FND_MSG_PUB.Add;
4035: END IF;
4036: RAISE FND_API.G_EXC_ERROR;
4037: END IF;
4101:
4102: -- Success message
4103: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4104: THEN
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
4102: -- Success message
4103: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4104: THEN
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
4114: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
4112: END IF;
4113: -- Debug Message
4114: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
4235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4236: END IF;
4237: -- Debug Message
4238: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4239: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4240: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4241: FND_MSG_PUB.Add;
4242: END IF;
4243: --Initialize message list if p_init_msg_list is TRUE.
4236: END IF;
4237: -- Debug Message
4238: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4239: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4240: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4241: FND_MSG_PUB.Add;
4242: END IF;
4243: --Initialize message list if p_init_msg_list is TRUE.
4244: IF FND_API.To_Boolean (p_init_msg_list) THEN
4256: -- Check if user is login and has the required privilege.
4257: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4258: -- User is not login.
4259: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4260: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4261: FND_MSG_PUB.Add;
4262: END IF;
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4286: -- get channel groups if the channel exists
4287: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4289: THEN
4290: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4291: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4292: FND_MSG_PUB.Add;
4293: END IF;
4294: RAISE FND_API.G_EXC_ERROR;
4287: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4289: THEN
4290: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4291: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4292: FND_MSG_PUB.Add;
4293: END IF;
4294: RAISE FND_API.G_EXC_ERROR;
4295: ELSE
4307: --
4308:
4309: -- Debug Message
4310: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
4308:
4309: -- Debug Message
4310: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
4435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4436: END IF;
4437: -- Debug Message
4438: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4439: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4440: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4441: FND_MSG_PUB.Add;
4442: END IF;
4443: --Initialize message list if p_init_msg_list is TRUE.
4436: END IF;
4437: -- Debug Message
4438: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4439: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4440: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4441: FND_MSG_PUB.Add;
4442: END IF;
4443: --Initialize message list if p_init_msg_list is TRUE.
4444: IF FND_API.To_Boolean (p_init_msg_list) THEN
4456: -- Check if user is login and has the required privilege.
4457: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4458: -- User is not login.
4459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4460: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4461: FND_MSG_PUB.Add;
4462: END IF;
4463: RAISE FND_API.G_EXC_ERROR;
4464: END IF;
4486: -- change channel keywords if the channel exists
4487: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4489: THEN
4490: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4491: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4492: FND_MSG_PUB.Add;
4493: END IF;
4494: RAISE FND_API.G_EXC_ERROR;
4487: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4489: THEN
4490: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4491: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4492: FND_MSG_PUB.Add;
4493: END IF;
4494: RAISE FND_API.G_EXC_ERROR;
4495: ELSE
4520: ELSE
4521: -- user does not have privilege to create public channel
4522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4523: THEN
4524: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
4525: FND_MESSAGE.Set_Token('LEVEL','Channel');
4526: FND_MSG_PUB.Add;
4527: END IF;
4528: RAISE FND_API.G_EXC_ERROR;
4521: -- user does not have privilege to create public channel
4522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4523: THEN
4524: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
4525: FND_MESSAGE.Set_Token('LEVEL','Channel');
4526: FND_MSG_PUB.Add;
4527: END IF;
4528: RAISE FND_API.G_EXC_ERROR;
4529: END IF;
4531: ELSE
4532: -- error while user privilege check in Can_SetupChannel
4533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4534: THEN
4535: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
4536: FND_MESSAGE.Set_Token('LEVEL','Channel');
4537: FND_MSG_PUB.Add;
4538: END IF;
4539: RAISE FND_API.G_EXC_ERROR;
4532: -- error while user privilege check in Can_SetupChannel
4533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4534: THEN
4535: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
4536: FND_MESSAGE.Set_Token('LEVEL','Channel');
4537: FND_MSG_PUB.Add;
4538: END IF;
4539: RAISE FND_API.G_EXC_ERROR;
4540: END IF;
4603:
4604: -- Success message
4605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4606: THEN
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
4604: -- Success message
4605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4606: THEN
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
4616: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
4614: END IF;
4615: -- Debug Message
4616: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4739: END IF;
4740: -- Debug Message
4741: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4742: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4743: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4744: FND_MSG_PUB.Add;
4745: END IF;
4746: --Initialize message list if p_init_msg_list is TRUE.
4739: END IF;
4740: -- Debug Message
4741: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4742: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4743: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4744: FND_MSG_PUB.Add;
4745: END IF;
4746: --Initialize message list if p_init_msg_list is TRUE.
4747: IF FND_API.To_Boolean (p_init_msg_list) THEN
4759: -- Check if user is login and has the required privilege.
4760: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4761: -- User is not login.
4762: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4763: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4764: FND_MSG_PUB.Add;
4765: END IF;
4766: RAISE FND_API.G_EXC_ERROR;
4767: END IF;
4789: -- get channel keywords if the channel exists
4790: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4791: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4792: THEN
4793: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4794: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4795: FND_MSG_PUB.Add;
4796: END IF;
4797: RAISE FND_API.G_EXC_ERROR;
4790: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4791: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4792: THEN
4793: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4794: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4795: FND_MSG_PUB.Add;
4796: END IF;
4797: RAISE FND_API.G_EXC_ERROR;
4798: ELSE
4810: --
4811:
4812: -- Debug Message
4813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
4811:
4812: -- Debug Message
4813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: END IF;
4940: -- Debug Message
4941: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4942: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4943: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4944: FND_MSG_PUB.Add;
4945: END IF;
4946: --Initialize message list if p_init_msg_list is TRUE.
4939: END IF;
4940: -- Debug Message
4941: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4942: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4943: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4944: FND_MSG_PUB.Add;
4945: END IF;
4946: --Initialize message list if p_init_msg_list is TRUE.
4947: IF FND_API.To_Boolean (p_init_msg_list) THEN
4959: -- Check if user is login and has the required privilege.
4960: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4961: -- User is not login.
4962: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4963: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4964: FND_MSG_PUB.Add;
4965: END IF;
4966: RAISE FND_API.G_EXC_ERROR;
4967: END IF;
4989: -- change authors if the channel exists
4990: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4992: THEN
4993: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4995: FND_MSG_PUB.Add;
4996: END IF;
4997: RAISE FND_API.G_EXC_ERROR;
4990: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
4991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4992: THEN
4993: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
4994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
4995: FND_MSG_PUB.Add;
4996: END IF;
4997: RAISE FND_API.G_EXC_ERROR;
4998: ELSE
5023: ELSE
5024: -- user does not have privilege to create public channel
5025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5026: THEN
5027: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
5028: FND_MESSAGE.Set_Token('LEVEL','Channel');
5029: FND_MSG_PUB.Add;
5030: END IF;
5031: RAISE FND_API.G_EXC_ERROR;
5024: -- user does not have privilege to create public channel
5025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5026: THEN
5027: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
5028: FND_MESSAGE.Set_Token('LEVEL','Channel');
5029: FND_MSG_PUB.Add;
5030: END IF;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;
5034: ELSE
5035: -- error while user privilege check in Can_SetupChannel
5036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5037: THEN
5038: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
5039: FND_MESSAGE.Set_Token('LEVEL','Channel');
5040: FND_MSG_PUB.Add;
5041: END IF;
5042: RAISE FND_API.G_EXC_ERROR;
5035: -- error while user privilege check in Can_SetupChannel
5036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5037: THEN
5038: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
5039: FND_MESSAGE.Set_Token('LEVEL','Channel');
5040: FND_MSG_PUB.Add;
5041: END IF;
5042: RAISE FND_API.G_EXC_ERROR;
5043: END IF;
5106:
5107: -- Success message
5108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5109: THEN
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
5107: -- Success message
5108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5109: THEN
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
5119: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
5117: END IF;
5118: -- Debug Message
5119: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
5240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5241: END IF;
5242: -- Debug Message
5243: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5244: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5245: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5246: FND_MSG_PUB.Add;
5247: END IF;
5248: --Initialize message list if p_init_msg_list is TRUE.
5241: END IF;
5242: -- Debug Message
5243: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5244: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5245: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5246: FND_MSG_PUB.Add;
5247: END IF;
5248: --Initialize message list if p_init_msg_list is TRUE.
5249: IF FND_API.To_Boolean (p_init_msg_list) THEN
5261: -- Check if user is login and has the required privilege.
5262: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
5263: -- User is not login.
5264: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5265: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5266: FND_MSG_PUB.Add;
5267: END IF;
5268: RAISE FND_API.G_EXC_ERROR;
5269: END IF;
5291: -- get channel authors if the channel exists
5292: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5294: THEN
5295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5296: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5297: FND_MSG_PUB.Add;
5298: END IF;
5299: RAISE FND_API.G_EXC_ERROR;
5292: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5294: THEN
5295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5296: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5297: FND_MSG_PUB.Add;
5298: END IF;
5299: RAISE FND_API.G_EXC_ERROR;
5300: ELSE
5312: --
5313:
5314: -- Debug Message
5315: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
5313:
5314: -- Debug Message
5315: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5489: END IF;
5490: -- Debug Message
5491: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5492: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5493: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5494: FND_MSG_PUB.Add;
5495: END IF;
5496: --Initialize message list if p_init_msg_list is TRUE.
5489: END IF;
5490: -- Debug Message
5491: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5492: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5493: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5494: FND_MSG_PUB.Add;
5495: END IF;
5496: --Initialize message list if p_init_msg_list is TRUE.
5497: IF FND_API.To_Boolean (p_init_msg_list) THEN
5509: -- Check if user is login and has the required privilege.
5510: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
5511: -- User is not login.
5512: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5513: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5514: FND_MSG_PUB.Add;
5515: END IF;
5516: RAISE FND_API.G_EXC_ERROR;
5517: END IF;
5527:
5528: IF (p_channel_id IS NULL OR p_channel_name IS NULL) THEN
5529: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5530: THEN
5531: FND_MESSAGE.Set_Name('AMV', 'AMV_CHN_ID_OR_NAME_NULL');
5532: FND_MSG_PUB.Add;
5533: END IF;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: END IF;
5547: -- get items if channel exists
5548: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5550: THEN
5551: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5552: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5553: FND_MSG_PUB.Add;
5554: END IF;
5555: RAISE FND_API.G_EXC_ERROR;
5548: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5550: THEN
5551: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5552: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5553: FND_MSG_PUB.Add;
5554: END IF;
5555: RAISE FND_API.G_EXC_ERROR;
5556: ELSE
5624: --
5625:
5626: -- Debug Message
5627: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
5625:
5626: -- Debug Message
5627: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
5747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5748: END IF;
5749: -- Debug Message
5750: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5751: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5752: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5753: FND_MSG_PUB.Add;
5754: END IF;
5755: --Initialize message list if p_init_msg_list is TRUE.
5748: END IF;
5749: -- Debug Message
5750: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5751: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5752: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5753: FND_MSG_PUB.Add;
5754: END IF;
5755: --Initialize message list if p_init_msg_list is TRUE.
5756: IF FND_API.To_Boolean (p_init_msg_list) THEN
5768: -- Check if user is login and has the required privilege.
5769: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
5770: -- User is not login.
5771: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5772: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5773: FND_MSG_PUB.Add;
5774: END IF;
5775: RAISE FND_API.G_EXC_ERROR;
5776: END IF;
5798: -- set channel approval status if it exists
5799: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5801: THEN
5802: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5803: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5804: FND_MSG_PUB.Add;
5805: END IF;
5806: RAISE FND_API.G_EXC_ERROR;
5799: IF (l_channel_exist_flag = FND_API.G_FALSE) THEN
5800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
5801: THEN
5802: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
5803: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
5804: FND_MSG_PUB.Add;
5805: END IF;
5806: RAISE FND_API.G_EXC_ERROR;
5807: ELSE
5818:
5819: -- Success message
5820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5821: THEN
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
5819: -- Success message
5820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
5821: THEN
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
5831: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
5829: END IF;
5830: -- Debug Message
5831: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (
5983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5984: END IF;
5985: -- Debug Message
5986: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5987: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5988: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5989: FND_MSG_PUB.Add;
5990: END IF;
5991: --Initialize message list if p_init_msg_list is TRUE.
5984: END IF;
5985: -- Debug Message
5986: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5987: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
5988: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
5989: FND_MSG_PUB.Add;
5990: END IF;
5991: --Initialize message list if p_init_msg_list is TRUE.
5992: IF FND_API.To_Boolean (p_init_msg_list) THEN
6004: -- Check if user is login and has the required privilege.
6005: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
6006: -- User is not login.
6007: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6008: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6009: FND_MSG_PUB.Add;
6010: END IF;
6011: RAISE FND_API.G_EXC_ERROR;
6012: END IF;
6398: --
6399:
6400: -- Debug Message
6401: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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
6399:
6400: -- Debug Message
6401: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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 (