DBA Data[Home] [Help]

APPS.AMV_MATCH_PVT dependencies on FND_MESSAGE

Line 78: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

74: -- Check if item id is valid.
75: -- The rest of the checking is done on Enqueue_Message().
76: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
77: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
78: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
79: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
80: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
81: FND_MSG_PUB.Add;
82: END IF;

Line 79: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);

75: -- The rest of the checking is done on Enqueue_Message().
76: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
77: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
78: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
79: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
80: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
81: FND_MSG_PUB.Add;
82: END IF;
83: RAISE FND_API.G_EXC_ERROR;

Line 80: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));

76: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
77: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
78: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
79: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
80: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
81: FND_MSG_PUB.Add;
82: END IF;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;

Line 176: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

172: -- Check if channel id is valid.
173: -- The rest of the checking is done on Enqueue_Message().
174: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) <> TRUE) THEN
175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
176: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
177: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
178: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
179: FND_MSG_PUB.Add;
180: END IF;

Line 177: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

173: -- The rest of the checking is done on Enqueue_Message().
174: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) <> TRUE) THEN
175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
176: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
177: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
178: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
179: FND_MSG_PUB.Add;
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;

Line 178: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));

174: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id) <> TRUE) THEN
175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
176: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
177: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
178: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
179: FND_MSG_PUB.Add;
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;

Line 571: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

567: -- Check if user is login and has the required privilege.
568: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
569: -- User is not login.
570: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
571: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
572: FND_MSG_PUB.Add;
573: END IF;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;

Line 593: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

589: IF (Get_ItemInfo_csr%NOTFOUND) THEN
590: CLOSE Get_ItemInfo_csr;
591: -- The item id is invalid.
592: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
593: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
594: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
595: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
596: FND_MSG_PUB.Add;
597: END IF;

Line 594: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);

590: CLOSE Get_ItemInfo_csr;
591: -- The item id is invalid.
592: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
593: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
594: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
595: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
596: FND_MSG_PUB.Add;
597: END IF;
598: RAISE FND_API.G_EXC_ERROR;

Line 595: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));

591: -- The item id is invalid.
592: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
593: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
594: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
595: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1)));
596: FND_MSG_PUB.Add;
597: END IF;
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;

Line 907: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

903: -- Check if user is login and has the required privilege.
904: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
905: -- User is not login.
906: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
907: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
908: FND_MSG_PUB.Add;
909: END IF;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;

Line 934: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

930: IF (Get_ChannelInfo_csr%NOTFOUND) THEN
931: CLOSE Get_ChannelInfo_csr;
932: -- The channel id is NOT valid.
933: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
934: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
935: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
936: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
937: FND_MSG_PUB.Add;
938: END IF;

Line 935: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

931: CLOSE Get_ChannelInfo_csr;
932: -- The channel id is NOT valid.
933: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
934: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
935: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
936: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
937: FND_MSG_PUB.Add;
938: END IF;
939: RAISE FND_API.G_EXC_ERROR;

Line 936: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));

932: -- The channel id is NOT valid.
933: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
934: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
935: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
936: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id, -1)));
937: FND_MSG_PUB.Add;
938: END IF;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;

Line 1188: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

1184: -- Check if user is login and has the required privilege.
1185: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1186: -- User is not login.
1187: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1188: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1189: FND_MSG_PUB.Add;
1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;

Line 1352: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

1348: -- Check if user is login and has the required privilege.
1349: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1350: -- User is not login.
1351: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1352: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1353: FND_MSG_PUB.Add;
1354: END IF;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;

Line 1521: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

1517: -- Check if user is login and has the required privilege.
1518: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1519: -- User is not login.
1520: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1521: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1522: FND_MSG_PUB.Add;
1523: END IF;
1524: x_match_flag := FND_API.G_FALSE;
1525: RAISE FND_API.G_EXC_ERROR;

Line 1733: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

1729: -- Check if user is login and has the required privilege.
1730: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1731: -- User is not login.
1732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1733: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1734: FND_MSG_PUB.Add;
1735: END IF;
1736: RAISE FND_API.G_EXC_ERROR;
1737: END IF;

Line 1762: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

1758: l_current_date;
1759: IF (Get_ChannelInfo_csr%NOTFOUND) THEN
1760: CLOSE Get_ChannelInfo_csr;
1761: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1762: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1763: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1764: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
1765: FND_MSG_PUB.Add;
1766: END IF;

Line 1763: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

1759: IF (Get_ChannelInfo_csr%NOTFOUND) THEN
1760: CLOSE Get_ChannelInfo_csr;
1761: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1762: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1763: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1764: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
1765: FND_MSG_PUB.Add;
1766: END IF;
1767: RAISE FND_API.G_EXC_ERROR;

Line 1764: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));

1760: CLOSE Get_ChannelInfo_csr;
1761: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1762: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1763: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1764: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
1765: FND_MSG_PUB.Add;
1766: END IF;
1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;

Line 1783: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

1779: FETCH Get_OwnerIDAndName_csr INTO l_owner_name, l_owner_id;
1780: IF (Get_OwnerIDAndName_csr%NOTFOUND) THEN
1781: CLOSE Get_OwnerIDAndName_csr;
1782: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1784: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1785: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
1786: FND_MSG_PUB.Add;
1787: END IF;

Line 1784: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

1780: IF (Get_OwnerIDAndName_csr%NOTFOUND) THEN
1781: CLOSE Get_OwnerIDAndName_csr;
1782: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1784: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1785: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
1786: FND_MSG_PUB.Add;
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;

Line 1785: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));

1781: CLOSE Get_OwnerIDAndName_csr;
1782: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1784: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
1785: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
1786: FND_MSG_PUB.Add;
1787: END IF;
1788: RAISE FND_API.G_EXC_ERROR;
1789: END IF;

Line 1844: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');

1840: ELSE -- add the item to the category.
1841: --check category id
1842: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
1843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
1845: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
1846: FND_MSG_PUB.Add;
1847: END IF;
1848: RAISE FND_API.G_EXC_ERROR;

Line 1845: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));

1841: --check category id
1842: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
1843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1844: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
1845: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
1846: FND_MSG_PUB.Add;
1847: END IF;
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;

Line 2060: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

2056: -- Check if user is login and has the required privilege.
2057: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2058: -- User is not login.
2059: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2060: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2061: FND_MSG_PUB.Add;
2062: END IF;
2063: RAISE FND_API.G_EXC_ERROR;
2064: END IF;

Line 2162: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

2158: l_current_date;
2159: IF (Get_ChannelInfo_csr%NOTFOUND) THEN
2160: CLOSE Get_ChannelInfo_csr;
2161: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2162: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2163: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2164: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
2165: FND_MSG_PUB.Add;
2166: END IF;

Line 2163: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

2159: IF (Get_ChannelInfo_csr%NOTFOUND) THEN
2160: CLOSE Get_ChannelInfo_csr;
2161: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2162: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2163: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2164: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
2165: FND_MSG_PUB.Add;
2166: END IF;
2167: RAISE FND_API.G_EXC_ERROR;

Line 2164: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));

2160: CLOSE Get_ChannelInfo_csr;
2161: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2162: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2163: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2164: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_channel_id,-1)));
2165: FND_MSG_PUB.Add;
2166: END IF;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;

Line 2183: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

2179: FETCH Get_OwnerIDAndName_csr INTO l_owner_name, l_owner_id;
2180: IF (Get_OwnerIDAndName_csr%NOTFOUND) THEN
2181: CLOSE Get_OwnerIDAndName_csr;
2182: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2184: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2185: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
2186: FND_MSG_PUB.Add;
2187: END IF;

Line 2184: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);

2180: IF (Get_OwnerIDAndName_csr%NOTFOUND) THEN
2181: CLOSE Get_OwnerIDAndName_csr;
2182: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2184: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2185: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
2186: FND_MSG_PUB.Add;
2187: END IF;
2188: RAISE FND_API.G_EXC_ERROR;

Line 2185: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));

2181: CLOSE Get_OwnerIDAndName_csr;
2182: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2183: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2184: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
2185: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
2186: FND_MSG_PUB.Add;
2187: END IF;
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;

Line 2257: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');

2253: IF l_match_item_catg = 'Y' THEN
2254: --check category id
2255: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2257: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2258: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2259: FND_MSG_PUB.Add;
2260: END IF;
2261: RAISE FND_API.G_EXC_ERROR;

Line 2258: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));

2254: --check category id
2255: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2257: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2258: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2259: FND_MSG_PUB.Add;
2260: END IF;
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;

Line 2435: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

2431: -- Check if user is login and has the required privilege.
2432: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2433: -- User is not login.
2434: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2435: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2436: FND_MSG_PUB.Add;
2437: END IF;
2438: RAISE FND_API.G_EXC_ERROR;
2439: END IF;

Line 2471: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');

2467: ELSE -- delete the item to category match.
2468: --check category id
2469: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2470: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2471: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2472: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2473: FND_MSG_PUB.Add;
2474: END IF;
2475: RAISE FND_API.G_EXC_ERROR;

Line 2472: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));

2468: --check category id
2469: IF (AMV_UTILITY_PVT.Is_CategoryIdValid(p_category_id) <> TRUE) THEN
2470: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2471: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
2472: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_category_id, -1)));
2473: FND_MSG_PUB.Add;
2474: END IF;
2475: RAISE FND_API.G_EXC_ERROR;
2476: END IF;

Line 2594: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

2590: -- Check if user is login and has the required privilege.
2591: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2592: -- User is not login.
2593: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2594: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2595: FND_MSG_PUB.ADD;
2596: END IF;
2597: RAISE FND_API.G_EXC_ERROR;
2598: END IF;

Line 2709: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

2705: -- Check if user is login and has the required privilege.
2706: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2707: -- User is not login.
2708: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2709: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2710: FND_MSG_PUB.ADD;
2711: END IF;
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;