DBA Data[Home] [Help]

APPS.AMV_PERSPECTIVE_PVT dependencies on AMV_UTILITY_PVT

Line 93: AMV_UTILITY_PVT.Get_UserInfo(

89: -- Initialize API return status to success
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: --
92: -- Get the current (login) user id.
93: AMV_UTILITY_PVT.Get_UserInfo(
94: x_resource_id => l_resource_id,
95: x_user_id => l_current_user_id,
96: x_login_id => l_current_login_id,
97: x_user_status => l_current_user_status

Line 262: AMV_UTILITY_PVT.Get_UserInfo(

258: END IF;
259: -- Initialize API return status to success
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261: -- Get the current (login) user id.
262: AMV_UTILITY_PVT.Get_UserInfo(
263: x_resource_id => l_resource_id,
264: x_user_id => l_current_user_id,
265: x_login_id => l_current_login_id,
266: x_user_status => l_current_user_status

Line 305: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN

301: END IF;
302: --
303: IF (p_perspective_id <> FND_API.G_MISS_NUM) THEN
304: -- Check if user pass the valid perspective id
305: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
306: l_perspective_id := p_perspective_id;
307: ELSE
308: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
309: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

Line 443: AMV_UTILITY_PVT.Get_UserInfo(

439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- Get the current (login) user id.
443: AMV_UTILITY_PVT.Get_UserInfo(
444: x_resource_id => l_resource_id,
445: x_user_id => l_current_user_id,
446: x_login_id => l_current_login_id,
447: x_user_status => l_current_user_status

Line 500: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN

496: CLOSE Check_DupPerspectName_csr;
497: --
498: IF (p_perspective_id <> FND_API.G_MISS_NUM) THEN
499: -- Check if user pass the valid perspective id
500: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
501: l_perspective_id := p_perspective_id;
502: ELSE
503: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
504: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

Line 662: AMV_UTILITY_PVT.Get_UserInfo(

658: -- Initialize API return status to success
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660: --
661: -- Get the current (login) user id.
662: AMV_UTILITY_PVT.Get_UserInfo(
663: x_resource_id => l_resource_id,
664: x_user_id => l_current_user_id,
665: x_login_id => l_current_login_id,
666: x_user_status => l_current_user_status

Line 686: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN

682: l_current_user_id := -1;
683: END IF;
684: IF (p_perspective_id <> FND_API.G_MISS_NUM) THEN
685: -- Check if user pass the valid perspective id
686: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
687: l_perspective_id := p_perspective_id;
688: ELSE
689: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
690: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

Line 856: AMV_UTILITY_PVT.Get_UserInfo(

852: END IF;
853: -- Initialize API return status to success
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: -- Get the current (login) user id.
856: AMV_UTILITY_PVT.Get_UserInfo(
857: x_resource_id => l_resource_id,
858: x_user_id => l_current_user_id,
859: x_login_id => l_current_login_id,
860: x_user_status => l_current_user_status

Line 1093: AMV_UTILITY_PVT.Get_UserInfo(

1089: -- Initialize API return status to success
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091: --
1092: -- Get the current (login) user id.
1093: AMV_UTILITY_PVT.Get_UserInfo(
1094: x_resource_id => l_resource_id,
1095: x_user_id => l_current_user_id,
1096: x_login_id => l_current_login_id,
1097: x_user_status => l_current_user_status

Line 1134: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1130: l_current_login_id := -1;
1131: l_current_user_id := -1;
1132: END IF;
1133: -- Check if item id is valid.
1134: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1135: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1136: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1137: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1138: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));

Line 1161: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(l_perspective_id) THEN

1157: FND_MSG_PUB.Add;
1158: END IF;
1159: ELSE
1160: CLOSE Check_ItemPerspectives_csr;
1161: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(l_perspective_id) THEN
1162: OPEN Get_IDandDate_csr;
1163: FETCH Get_IDandDate_csr Into l_temp_number, l_date;
1164: CLOSE Get_IDandDate_csr;
1165: Insert Into amv_i_item_perspectives

Line 1296: AMV_UTILITY_PVT.Get_UserInfo(

1292: END IF;
1293: -- Initialize API return status to success
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: -- Get the current (login) user id.
1296: AMV_UTILITY_PVT.Get_UserInfo(
1297: x_resource_id => l_resource_id,
1298: x_user_id => l_current_user_id,
1299: x_login_id => l_current_login_id,
1300: x_user_status => l_current_user_status

Line 1337: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1333: l_current_login_id := -1;
1334: l_current_user_id := -1;
1335: END IF;
1336: -- Check if item id is valid.
1337: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1338: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1339: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1340: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1341: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));

Line 1346: IF (AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) <> TRUE) THEN

1342: FND_MSG_PUB.Add;
1343: END IF;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: IF (AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) <> TRUE) THEN
1347: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1348: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1349: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
1350: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));

Line 1490: AMV_UTILITY_PVT.Get_UserInfo(

1486: END IF;
1487: -- Initialize API return status to success
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: -- Get the current (login) user id.
1490: AMV_UTILITY_PVT.Get_UserInfo(
1491: x_resource_id => l_resource_id,
1492: x_user_id => l_current_user_id,
1493: x_login_id => l_current_login_id,
1494: x_user_status => l_current_user_status

Line 1531: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1527: l_current_login_id := -1;
1528: l_current_user_id := -1;
1529: END IF;
1530: -- Check if item id is valid.
1531: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1532: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1534: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1535: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));

Line 1655: AMV_UTILITY_PVT.Get_UserInfo(

1651: END IF;
1652: -- Initialize API return status to success
1653: x_return_status := FND_API.G_RET_STS_SUCCESS;
1654: -- Get the current (login) user id.
1655: AMV_UTILITY_PVT.Get_UserInfo(
1656: x_resource_id => l_resource_id,
1657: x_user_id => l_current_user_id,
1658: x_login_id => l_current_login_id,
1659: x_user_status => l_current_user_status

Line 1696: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1692: l_current_login_id := -1;
1693: l_current_user_id := -1;
1694: END IF;
1695: -- Check if item id is valid.
1696: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1697: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1698: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1699: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1700: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));

Line 1879: AMV_UTILITY_PVT.Get_UserInfo(

1875: END IF;
1876: -- Initialize API return status to success
1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878: -- Get the current (login) user id.
1879: AMV_UTILITY_PVT.Get_UserInfo(
1880: x_resource_id => l_resource_id,
1881: x_user_id => l_current_user_id,
1882: x_login_id => l_current_login_id,
1883: x_user_status => l_current_user_status

Line 1902: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1898: l_current_login_id := -1;
1899: l_current_user_id := -1;
1900: END IF;
1901: -- Check if item id is valid.
1902: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1903: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1904: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1905: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1906: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));