[Home] [Help]
392: where access_id = l_access_obj.access_id
393: ;--and object_version_number = l_access_obj.access_id.object_version_number;
394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_ACCESS_ID');
397: FND_MESSAGE.Set_Token('ACCESS_ID', TO_CHAR(l_access_obj.access_id) );
398: FND_MSG_PUB.add;
399: END IF;
400: RAISE FND_API.G_EXC_ERROR;
393: ;--and object_version_number = l_access_obj.access_id.object_version_number;
394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_ACCESS_ID');
397: FND_MESSAGE.Set_Token('ACCESS_ID', TO_CHAR(l_access_obj.access_id) );
398: FND_MSG_PUB.add;
399: END IF;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
455: -- Check if user is login and has the required privilege.
456: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
457: -- User is not login.
458: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
459: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
460: FND_MSG_PUB.Add;
461: END IF;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
575: -- Check if user is login and has the required privilege.
576: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
577: -- User is not login.
578: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
579: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
580: FND_MSG_PUB.Add;
581: END IF;
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
809: -- Check if user is login and has the required privilege.
810: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
811: -- User is not login.
812: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
1028: -- Check if user is login and has the required privilege.
1029: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1030: -- User is not login.
1031: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1032: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1033: FND_MSG_PUB.Add;
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1046: );
1047: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1048: -- User is not an administrator.
1049: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1050: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1202: -- Check if user is login and has the required privilege.
1203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1204: -- User is not login.
1205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1207: FND_MSG_PUB.Add;
1208: END IF;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1220: );
1221: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1222: -- User is not an administrator.
1223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1224: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1225: FND_MSG_PUB.Add;
1226: END IF;
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1237: IF (Check_ResourceRole_csr%NOTFOUND) THEN
1238: CLOSE Check_ResourceRole_csr;
1239: IF (p_resource_type = G_RESOURCE_ROLE_CODE) THEN
1240: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.Set_name('AMV','AMV_RESOURCE_NOT_HAS_ROLE');
1242: FND_MESSAGE.Set_Token('P_RESOURCE_ID', TO_CHAR(p_resource_id) );
1243: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1238: CLOSE Check_ResourceRole_csr;
1239: IF (p_resource_type = G_RESOURCE_ROLE_CODE) THEN
1240: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.Set_name('AMV','AMV_RESOURCE_NOT_HAS_ROLE');
1242: FND_MESSAGE.Set_Token('P_RESOURCE_ID', TO_CHAR(p_resource_id) );
1243: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1239: IF (p_resource_type = G_RESOURCE_ROLE_CODE) THEN
1240: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.Set_name('AMV','AMV_RESOURCE_NOT_HAS_ROLE');
1242: FND_MESSAGE.Set_Token('P_RESOURCE_ID', TO_CHAR(p_resource_id) );
1243: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1249: FND_MESSAGE.Set_name('AMV','AMV_GROUP_NOT_HAS_ROLE');
1250: FND_MESSAGE.Set_Token('P_GROUP_ID', TO_CHAR(p_resource_id) );
1251: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1252: FND_MSG_PUB.Add;
1253: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1249: FND_MESSAGE.Set_name('AMV','AMV_GROUP_NOT_HAS_ROLE');
1250: FND_MESSAGE.Set_Token('P_GROUP_ID', TO_CHAR(p_resource_id) );
1251: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1252: FND_MSG_PUB.Add;
1253: END IF;
1254: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1249: FND_MESSAGE.Set_name('AMV','AMV_GROUP_NOT_HAS_ROLE');
1250: FND_MESSAGE.Set_Token('P_GROUP_ID', TO_CHAR(p_resource_id) );
1251: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1252: FND_MSG_PUB.Add;
1253: END IF;
1254: RAISE FND_API.G_EXC_ERROR;
1255: END IF;
1389: -- Check if user is login and has the required privilege.
1390: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1391: -- User is not login.
1392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1393: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1394: FND_MSG_PUB.Add;
1395: END IF;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1407: );
1408: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1409: -- User is not an administrator.
1410: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1411: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1412: FND_MSG_PUB.Add;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1421: END IF;
1422: -- Check if the resource id is valid
1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1424: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1426: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1427: FND_MSG_PUB.Add;
1428: END IF;
1429: RAISE FND_API.G_EXC_ERROR;
1422: -- Check if the resource id is valid
1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1424: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1426: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1427: FND_MSG_PUB.Add;
1428: END IF;
1429: RAISE FND_API.G_EXC_ERROR;
1430: END IF;
1582: -- Check if user is login and has the required privilege.
1583: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1584: -- User is not login.
1585: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1586: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1587: FND_MSG_PUB.Add;
1588: END IF;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1600: );
1601: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1602: -- User is not an administrator.
1603: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1604: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1605: FND_MSG_PUB.Add;
1606: END IF;
1607: RAISE FND_API.G_EXC_ERROR;
1608: END IF;
1614: END IF;
1615: -- Check if the resource id is valid
1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1617: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1619: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1620: FND_MSG_PUB.Add;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;
1615: -- Check if the resource id is valid
1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1617: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1619: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1620: FND_MSG_PUB.Add;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1902: -- Check if user is login and has the required privilege.
1903: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1904: -- User is not login.
1905: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1916: END IF;
1917: -- Check if the resource id is valid
1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1919: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1921: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1922: FND_MSG_PUB.Add;
1923: END IF;
1924: RAISE FND_API.G_EXC_ERROR;
1917: -- Check if the resource id is valid
1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1919: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1921: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1922: FND_MSG_PUB.Add;
1923: END IF;
1924: RAISE FND_API.G_EXC_ERROR;
1925: END IF;
2085: -- Check if user is login and has the required privilege.
2086: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2087: -- User is not login.
2088: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2089: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2104: l_resource_id := p_resource_id;
2105: -- Check if the resource id is valid
2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
2107: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2108: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
2109: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
2110: FND_MSG_PUB.Add;
2111: END IF;
2112: RAISE FND_API.G_EXC_ERROR;
2105: -- Check if the resource id is valid
2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
2107: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2108: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
2109: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
2110: FND_MSG_PUB.Add;
2111: END IF;
2112: RAISE FND_API.G_EXC_ERROR;
2113: END IF;
2545: -- Check if user is login and has the required privilege.
2546: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2547: -- User is not login.
2548: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2550: FND_MSG_PUB.Add;
2551: END IF;
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;
2563: );
2564: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2565: -- User is not an administrator.
2566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2568: FND_MSG_PUB.Add;
2569: END IF;
2570: RAISE FND_API.G_EXC_ERROR;
2571: END IF;
2577: END IF;
2578: -- Check if the group id is valid
2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2582: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2583: FND_MSG_PUB.Add;
2584: END IF;
2585: RAISE FND_API.G_EXC_ERROR;
2578: -- Check if the group id is valid
2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2582: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2583: FND_MSG_PUB.Add;
2584: END IF;
2585: RAISE FND_API.G_EXC_ERROR;
2586: END IF;
2739: -- Check if user is login and has the required privilege.
2740: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2741: -- User is not login.
2742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2744: FND_MSG_PUB.Add;
2745: END IF;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;
2757: );
2758: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2759: -- User is not an administrator.
2760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2761: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2762: FND_MSG_PUB.Add;
2763: END IF;
2764: RAISE FND_API.G_EXC_ERROR;
2765: END IF;
2771: END IF;
2772: -- Check if the Group id is valid
2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2774: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2775: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2776: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2777: FND_MSG_PUB.Add;
2778: END IF;
2779: RAISE FND_API.G_EXC_ERROR;
2772: -- Check if the Group id is valid
2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2774: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2775: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2776: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2777: FND_MSG_PUB.Add;
2778: END IF;
2779: RAISE FND_API.G_EXC_ERROR;
2780: END IF;
3058: -- Check if user is login and has the required privilege.
3059: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3060: -- User is not login.
3061: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3062: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3063: FND_MSG_PUB.Add;
3064: END IF;
3065: RAISE FND_API.G_EXC_ERROR;
3066: END IF;
3072: END IF;
3073: -- Check if the group id is valid
3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3075: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3076: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3077: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3078: FND_MSG_PUB.Add;
3079: END IF;
3080: RAISE FND_API.G_EXC_ERROR;
3073: -- Check if the group id is valid
3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3075: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3076: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3077: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3078: FND_MSG_PUB.Add;
3079: END IF;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3195: -- Check if user is login and has the required privilege.
3196: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3197: -- User is not login.
3198: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3199: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3200: FND_MSG_PUB.Add;
3201: END IF;
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;
3204: END IF;
3205: -- Check if the resource id is valid
3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3207: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3208: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3209: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3210: FND_MSG_PUB.Add;
3211: END IF;
3212: RAISE FND_API.G_EXC_ERROR;
3205: -- Check if the resource id is valid
3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3207: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3208: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3209: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3210: FND_MSG_PUB.Add;
3211: END IF;
3212: RAISE FND_API.G_EXC_ERROR;
3213: END IF;
3342: -- Check if user is login and has the required privilege.
3343: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3344: -- User is not login.
3345: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3346: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3347: FND_MSG_PUB.Add;
3348: END IF;
3349: RAISE FND_API.G_EXC_ERROR;
3350: END IF;
3360: );
3361: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3362: -- User is not an administrator.
3363: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3364: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3365: FND_MSG_PUB.Add;
3366: END IF;
3367: RAISE FND_API.G_EXC_ERROR;
3368: END IF;
3377: FETCH Check_Group_csr INTO l_group_id;
3378: IF (Check_Group_csr%FOUND) THEN
3379: CLOSE Check_Group_csr;
3380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3381: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3382: FND_MESSAGE.Set_Token('NAME', p_group_name );
3383: FND_MSG_PUB.Add;
3384: END IF;
3385: RAISE FND_API.G_EXC_ERROR;
3378: IF (Check_Group_csr%FOUND) THEN
3379: CLOSE Check_Group_csr;
3380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3381: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3382: FND_MESSAGE.Set_Token('NAME', p_group_name );
3383: FND_MSG_PUB.Add;
3384: END IF;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSE
3674: -- Check if user is login and has the required privilege.
3675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3676: -- User is not login.
3677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3679: FND_MSG_PUB.Add;
3680: END IF;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3692: );
3693: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3694: -- User is not an administrator.
3695: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3696: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3697: FND_MSG_PUB.Add;
3698: END IF;
3699: RAISE FND_API.G_EXC_ERROR;
3700: END IF;
3706: END IF;
3707: -- Check if the group id is valid
3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3709: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3710: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3711: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3712: FND_MSG_PUB.Add;
3713: END IF;
3714: RAISE FND_API.G_EXC_ERROR;
3707: -- Check if the group id is valid
3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3709: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3710: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3711: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3712: FND_MSG_PUB.Add;
3713: END IF;
3714: RAISE FND_API.G_EXC_ERROR;
3715: END IF;
3719: FETCH Check_Group_csr INTO l_group_id;
3720: IF (Check_Group_csr%FOUND) THEN
3721: CLOSE Check_Group_csr;
3722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3723: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3724: FND_MESSAGE.Set_Token('NAME', p_new_group_name );
3725: FND_MSG_PUB.Add;
3726: END IF;
3727: RAISE FND_API.G_EXC_ERROR;
3720: IF (Check_Group_csr%FOUND) THEN
3721: CLOSE Check_Group_csr;
3722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3723: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3724: FND_MESSAGE.Set_Token('NAME', p_new_group_name );
3725: FND_MSG_PUB.Add;
3726: END IF;
3727: RAISE FND_API.G_EXC_ERROR;
3728: ELSE
3888: -- Check if the group id is valid
3889: IF (p_group_id IS NOT NULL AND p_group_id <> FND_API.G_MISS_NUM) THEN
3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3893: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3894: FND_MSG_PUB.Add;
3895: END IF;
3896: RAISE FND_API.G_EXC_ERROR;
3889: IF (p_group_id IS NOT NULL AND p_group_id <> FND_API.G_MISS_NUM) THEN
3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3893: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3894: FND_MSG_PUB.Add;
3895: END IF;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3904: FETCH Get_GroupID_csr INTO l_group_id;
3905: IF (Get_GroupID_csr%NOTFOUND) THEN
3906: CLOSE Get_GroupID_csr;
3907: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3908: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_NAME');
3909: FND_MESSAGE.Set_Token('NAME', p_group_name );
3910: FND_MSG_PUB.Add;
3911: END IF;
3912: RAISE FND_API.G_EXC_ERROR;
3905: IF (Get_GroupID_csr%NOTFOUND) THEN
3906: CLOSE Get_GroupID_csr;
3907: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3908: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_NAME');
3909: FND_MESSAGE.Set_Token('NAME', p_group_name );
3910: FND_MSG_PUB.Add;
3911: END IF;
3912: RAISE FND_API.G_EXC_ERROR;
3913: ELSE
3914: CLOSE Get_GroupID_csr;
3915: END IF;
3916: ELSE
3917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3918: FND_MESSAGE.Set_name('AMV','AMV_NO_GROUP_NAME_OR_ID');
3919: FND_MSG_PUB.Add;
3920: END IF;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
4056: -- Check if user is login and has the required privilege.
4057: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4058: -- User is not login.
4059: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4060: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4061: FND_MSG_PUB.Add;
4062: END IF;
4063: RAISE FND_API.G_EXC_ERROR;
4064: END IF;
4202: -- Check if user is login and has the required privilege.
4203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4204: -- User is not login.
4205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4207: FND_MSG_PUB.Add;
4208: END IF;
4209: RAISE FND_API.G_EXC_ERROR;
4210: END IF;
4448: -- Check if user is login and has the required privilege.
4449: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4450: -- User is not login.
4451: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4452: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4453: FND_MSG_PUB.Add;
4454: END IF;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;
4659: -- Check if user is login and has the required privilege.
4660: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4661: -- User is not login.
4662: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4663: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4664: FND_MSG_PUB.Add;
4665: END IF;
4666: RAISE FND_API.G_EXC_ERROR;
4667: END IF;
4677: );
4678: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4679: -- User is not an administrator.
4680: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4681: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4682: FND_MSG_PUB.Add;
4683: END IF;
4684: RAISE FND_API.G_EXC_ERROR;
4685: END IF;
4691: END IF;
4692: -- Check if the group id is valid
4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4695: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4696: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4697: FND_MSG_PUB.Add;
4698: END IF;
4699: RAISE FND_API.G_EXC_ERROR;
4692: -- Check if the group id is valid
4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4695: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4696: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4697: FND_MSG_PUB.Add;
4698: END IF;
4699: RAISE FND_API.G_EXC_ERROR;
4700: END IF;
4700: END IF;
4701: -- Check if the resource id is valid
4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
4703: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4704: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
4705: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
4706: FND_MSG_PUB.Add;
4707: END IF;
4708: RAISE FND_API.G_EXC_ERROR;
4701: -- Check if the resource id is valid
4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
4703: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4704: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
4705: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
4706: FND_MSG_PUB.Add;
4707: END IF;
4708: RAISE FND_API.G_EXC_ERROR;
4709: END IF;
4820: -- Check if user is login and has the required privilege.
4821: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4822: -- User is not login.
4823: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4824: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4825: FND_MSG_PUB.Add;
4826: END IF;
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4838: );
4839: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4840: -- User is not an administrator.
4841: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4842: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4843: FND_MSG_PUB.Add;
4844: END IF;
4845: RAISE FND_API.G_EXC_ERROR;
4846: END IF;
4852: END IF;
4853: -- Check if the group id is valid
4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4855: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4856: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4857: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4858: FND_MSG_PUB.Add;
4859: END IF;
4860: RAISE FND_API.G_EXC_ERROR;
4853: -- Check if the group id is valid
4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4855: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4856: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4857: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4858: FND_MSG_PUB.Add;
4859: END IF;
4860: RAISE FND_API.G_EXC_ERROR;
4861: END IF;
4975: -- Check if user is login and has the required privilege.
4976: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4977: -- User is not login.
4978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4979: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4980: FND_MSG_PUB.Add;
4981: END IF;
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4993: );
4994: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4995: -- User is not an administrator.
4996: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4997: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4998: FND_MSG_PUB.Add;
4999: END IF;
5000: RAISE FND_API.G_EXC_ERROR;
5001: END IF;
5118: -- Check if user is login and has the required privilege.
5119: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5120: -- User is not login.
5121: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5122: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5123: FND_MSG_PUB.Add;
5124: END IF;
5125: RAISE FND_API.G_EXC_ERROR;
5126: END IF;
5136: );
5137: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5138: -- User is not an administrator.
5139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5140: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5141: FND_MSG_PUB.Add;
5142: END IF;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5150: END IF;
5151: -- Check if the group id is valid
5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
5153: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5154: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5155: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
5156: FND_MSG_PUB.Add;
5157: END IF;
5158: RAISE FND_API.G_EXC_ERROR;
5151: -- Check if the group id is valid
5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
5153: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5154: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5155: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
5156: FND_MSG_PUB.Add;
5157: END IF;
5158: RAISE FND_API.G_EXC_ERROR;
5159: END IF;
5282: -- Check if user is login and has the required privilege.
5283: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5284: -- User is not login.
5285: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5286: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5287: FND_MSG_PUB.Add;
5288: END IF;
5289: RAISE FND_API.G_EXC_ERROR;
5290: END IF;
5391: -- Check if user is login and has the required privilege.
5392: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5393: -- User is not login.
5394: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5395: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5396: FND_MSG_PUB.Add;
5397: END IF;
5398: RAISE FND_API.G_EXC_ERROR;
5399: END IF;
5410: );
5411: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5412: -- User is not an administrator.
5413: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5414: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5415: FND_MSG_PUB.Add;
5416: END IF;
5417: RAISE FND_API.G_EXC_ERROR;
5418: END IF;
5423: l_current_user_id := -1;
5424: END IF;
5425: IF (l_access_obj.access_id IS NULL) THEN
5426: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5427: FND_MESSAGE.Set_name('AMV','AMV_NULL_ACCESS_OBJ');
5428: FND_MSG_PUB.Add;
5429: END IF;
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: END IF;
5444: -- Check if the Group id is valid
5445: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(l_access_obj.user_or_group_id)
5446: <> TRUE) THEN
5447: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5448: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5449: FND_MESSAGE.Set_Token('ID',
5450: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5451: FND_MSG_PUB.Add;
5452: END IF;
5445: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(l_access_obj.user_or_group_id)
5446: <> TRUE) THEN
5447: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5448: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5449: FND_MESSAGE.Set_Token('ID',
5450: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5451: FND_MSG_PUB.Add;
5452: END IF;
5453: RAISE FND_API.G_EXC_ERROR;
5456: -- Check if the resource id is valid
5457: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(l_access_obj.user_or_group_id)
5458: <> TRUE) THEN
5459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5460: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
5461: FND_MESSAGE.Set_Token('ID',
5462: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5463: FND_MSG_PUB.Add;
5464: END IF;
5457: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(l_access_obj.user_or_group_id)
5458: <> TRUE) THEN
5459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5460: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
5461: FND_MESSAGE.Set_Token('ID',
5462: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5463: FND_MSG_PUB.Add;
5464: END IF;
5465: RAISE FND_API.G_EXC_ERROR;
5465: RAISE FND_API.G_EXC_ERROR;
5466: END IF;
5467: ELSE
5468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5469: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_USER_TYPE');
5470: FND_MSG_PUB.Add;
5471: END IF;
5472: RAISE FND_API.G_EXC_ERROR;
5473: END IF;
5475: -- Check if the item id is valid
5476: IF (AMV_UTILITY_PVT.IS_ITEMIDVALID(
5477: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5478: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_name('AMV','AMV_INVALID_ITEM_ID');
5480: FND_MESSAGE.Set_Token('ID',
5481: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5482: FND_MSG_PUB.Add;
5483: END IF;
5476: IF (AMV_UTILITY_PVT.IS_ITEMIDVALID(
5477: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5478: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_name('AMV','AMV_INVALID_ITEM_ID');
5480: FND_MESSAGE.Set_Token('ID',
5481: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5482: FND_MSG_PUB.Add;
5483: END IF;
5484: RAISE FND_API.G_EXC_ERROR;
5487: -- Check if the channel id is valid
5488: IF (AMV_UTILITY_PVT.IS_CHANNELIDVALID(
5489: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5490: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5491: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CHANEL_ID');
5492: FND_MESSAGE.Set_Token('ID',
5493: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5494: FND_MSG_PUB.Add;
5495: END IF;
5488: IF (AMV_UTILITY_PVT.IS_CHANNELIDVALID(
5489: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5490: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5491: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CHANEL_ID');
5492: FND_MESSAGE.Set_Token('ID',
5493: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5494: FND_MSG_PUB.Add;
5495: END IF;
5496: RAISE FND_API.G_EXC_ERROR;
5499: -- Check if the category id is valid
5500: IF (AMV_UTILITY_PVT.IS_CATEGORYIDVALID(
5501: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5502: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5503: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
5504: FND_MESSAGE.Set_Token('ID',
5505: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5506: FND_MSG_PUB.Add;
5507: END IF;
5500: IF (AMV_UTILITY_PVT.IS_CATEGORYIDVALID(
5501: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5502: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5503: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
5504: FND_MESSAGE.Set_Token('ID',
5505: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5506: FND_MSG_PUB.Add;
5507: END IF;
5508: RAISE FND_API.G_EXC_ERROR;
5511: -- Check if the application id is valid
5512: IF (AMV_UTILITY_PVT.IS_APPLIDVALID(
5513: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5515: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPLICATION_ID');
5516: FND_MESSAGE.Set_Token('ID',
5517: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5518: FND_MSG_PUB.Add;
5519: END IF;
5512: IF (AMV_UTILITY_PVT.IS_APPLIDVALID(
5513: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5515: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPLICATION_ID');
5516: FND_MESSAGE.Set_Token('ID',
5517: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5518: FND_MSG_PUB.Add;
5519: END IF;
5520: RAISE FND_API.G_EXC_ERROR;
5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: ELSE
5523: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5524: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_TABLE_TYPE');
5525: FND_MSG_PUB.Add;
5526: END IF;
5527: RAISE FND_API.G_EXC_ERROR;
5528: END IF;
5699: -- Check if user is login and has the required privilege.
5700: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5701: -- User is not login.
5702: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5703: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5704: FND_MSG_PUB.Add;
5705: END IF;
5706: RAISE FND_API.G_EXC_ERROR;
5707: END IF;
5718: );
5719: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5720: -- User is not an administrator.
5721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5722: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5723: FND_MSG_PUB.Add;
5724: END IF;
5725: RAISE FND_API.G_EXC_ERROR;
5726: END IF;
6409: -- Check if user is login and has the required privilege.
6410: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6411: -- User is not login.
6412: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6413: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;
6596: -- Check if user is login and has the required privilege.
6597: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6598: -- User is not login.
6599: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6600: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6601: FND_MSG_PUB.Add;
6602: END IF;
6603: RAISE FND_API.G_EXC_ERROR;
6604: END IF;
6840: -- Check if user is login and has the required privilege.
6841: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6842: -- User is not login.
6843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6844: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6845: FND_MSG_PUB.Add;
6846: END IF;
6847: RAISE FND_API.G_EXC_ERROR;
6848: END IF;
7087: -- Check if user is login and has the required privilege.
7088: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
7089: -- User is not login.
7090: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7091: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7092: FND_MSG_PUB.Add;
7093: END IF;
7094: RAISE FND_API.G_EXC_ERROR;
7095: END IF;