DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB dependencies on FND_MESSAGE

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

82: -- Check if user is login and has the required privilege.
83: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
84: -- User is not login.
85: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
86: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
87: FND_MSG_PUB.ADD;
88: END IF;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;

Line 104: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

100: );
101: IF (l_admin_flag <> FND_API.G_TRUE) THEN
102: -- User is not an administrator.
103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
104: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
105: FND_MSG_PUB.ADD;
106: END IF;
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;

Line 124: FND_MESSAGE.Set_name('AMV','AMV_NEED_ITEM_INFO');

120: -- MAKE SURE THE PASSED ITEM OBJECT HAS ALL THE RIGHT INFORMATION.
121: -- Check if the object is really passed.
122: IF (p_item_obj.item_name IS NULL) THEN
123: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
124: FND_MESSAGE.Set_name('AMV','AMV_NEED_ITEM_INFO');
125: FND_MSG_PUB.ADD;
126: END IF;
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;

Line 134: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TYPE');

130: -- Check if item type in the item object is null
131: IF (l_item_obj.item_type IS NULL OR
132: l_item_obj.item_type = FND_API.G_MISS_CHAR ) THEN
133: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
134: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TYPE');
135: FND_MSG_PUB.ADD;
136: END IF;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;

Line 148: FND_MESSAGE.Set_name('AMV','AMV_INVALID_OWNER_USER_ID');

144: ELSE
145: IF (AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.owner_id)
146: <> TRUE) THEN
147: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
148: FND_MESSAGE.Set_name('AMV','AMV_INVALID_OWNER_USER_ID');
149: FND_MESSAGE.Set_Token('ID', TO_CHAR(l_item_obj.owner_id));
150: FND_MSG_PUB.ADD;
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;

Line 149: FND_MESSAGE.Set_Token('ID', TO_CHAR(l_item_obj.owner_id));

145: IF (AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.owner_id)
146: <> TRUE) THEN
147: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
148: FND_MESSAGE.Set_name('AMV','AMV_INVALID_OWNER_USER_ID');
149: FND_MESSAGE.Set_Token('ID', TO_CHAR(l_item_obj.owner_id));
150: FND_MSG_PUB.ADD;
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;

Line 165: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPROVER_ID');

161: ELSE
162: IF(AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.default_approver_id)
163: <> TRUE) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPROVER_ID');
166: FND_MESSAGE.Set_Token('ID',
167: TO_CHAR(l_item_obj.default_approver_id));
168: FND_MSG_PUB.ADD;
169: END IF;

Line 166: FND_MESSAGE.Set_Token('ID',

162: IF(AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.default_approver_id)
163: <> TRUE) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPROVER_ID');
166: FND_MESSAGE.Set_Token('ID',
167: TO_CHAR(l_item_obj.default_approver_id));
168: FND_MSG_PUB.ADD;
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;

Line 181: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');

177: l_item_obj.content_type_id := NULL;
178: ELSIF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_obj.content_type_id)
179: <> TRUE) THEN
180: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
181: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
182: FND_MESSAGE.Set_Token('ID',
183: TO_CHAR( l_item_obj.content_type_id ) );
184: FND_MSG_PUB.ADD;
185: END IF;

Line 182: FND_MESSAGE.Set_Token('ID',

178: ELSIF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_obj.content_type_id)
179: <> TRUE) THEN
180: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
181: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
182: FND_MESSAGE.Set_Token('ID',
183: TO_CHAR( l_item_obj.content_type_id ) );
184: FND_MSG_PUB.ADD;
185: END IF;
186: RAISE FND_API.G_EXC_ERROR;

Line 192: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TITLE');

188: -- Check if item_name(title) in the item object is null
189: IF (l_item_obj.item_name IS NULL OR
190: l_item_obj.item_name = FND_API.G_MISS_CHAR) THEN
191: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
192: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TITLE');
193: FND_MSG_PUB.ADD;
194: END IF;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;

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

338: x_return_status := FND_API.G_RET_STS_ERROR;
339: END IF;
340: ELSE
341: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
343: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
344: FND_MESSAGE.Set_Token('ID',
345: TO_CHAR(NVL(p_channel_id_array(i), -1)));
346: FND_MSG_PUB.ADD;

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

339: END IF;
340: ELSE
341: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
343: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
344: FND_MESSAGE.Set_Token('ID',
345: TO_CHAR(NVL(p_channel_id_array(i), -1)));
346: FND_MSG_PUB.ADD;
347: END IF;

Line 344: FND_MESSAGE.Set_Token('ID',

340: ELSE
341: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
343: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
344: FND_MESSAGE.Set_Token('ID',
345: TO_CHAR(NVL(p_channel_id_array(i), -1)));
346: FND_MSG_PUB.ADD;
347: END IF;
348: END IF;

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

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;

Line 477: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

473: );
474: IF (l_admin_flag <> FND_API.G_TRUE) THEN
475: -- User is not an administrator.
476: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
477: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
478: FND_MSG_PUB.ADD;
479: END IF;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;

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

482: END IF;
483: -- Check if item id is valid.
484: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
485: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
486: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
487: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
488: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
489: FND_MSG_PUB.ADD;
490: END IF;

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

483: -- Check if item id is valid.
484: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
485: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
486: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
487: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
488: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
489: FND_MSG_PUB.ADD;
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;

Line 488: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

484: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
485: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
486: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
487: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
488: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
489: FND_MSG_PUB.ADD;
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

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

654: -- Check if user is login and has the required privilege.
655: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
656: -- User is not login.
657: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
658: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
659: FND_MSG_PUB.ADD;
660: END IF;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;

Line 676: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

672: );
673: IF (l_admin_flag <> FND_API.G_TRUE) THEN
674: -- User is not an administrator.
675: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
676: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
677: FND_MSG_PUB.ADD;
678: END IF;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;

Line 698: FND_MESSAGE.Set_name('AMV','AMV_NEED_ITEM_INFO');

694: -- MAKE SURE THE PASSED ITEM OBJECT HAS ALL THE RIGHT INFORMATION.
695: -- Check if the object is really passed.
696: IF (p_item_obj.item_id IS NULL) THEN
697: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
698: FND_MESSAGE.Set_name('AMV','AMV_NEED_ITEM_INFO');
699: FND_MSG_PUB.ADD;
700: END IF;
701: RAISE FND_API.G_EXC_ERROR;
702: END IF;

Line 731: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TITLE');

727: l_item_rec.external_access_flag := FND_API.G_MISS_CHAR;
728: END IF;
729: IF (l_item_rec.item_name IS NULL) THEN
730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
731: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TITLE');
732: FND_MSG_PUB.ADD;
733: END IF;
734: l_item_rec.item_name := FND_API.G_MISS_CHAR;
735: END IF;

Line 738: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TYPE');

734: l_item_rec.item_name := FND_API.G_MISS_CHAR;
735: END IF;
736: IF (l_item_rec.item_type IS NULL) THEN
737: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
738: FND_MESSAGE.Set_name('AMV','AMV_NULL_ITEM_TYPE');
739: FND_MSG_PUB.ADD;
740: END IF;
741: l_item_rec.item_type := FND_API.G_MISS_CHAR;
742: END IF;

Line 748: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');

744: l_item_rec.content_type_id <> FND_API.G_MISS_NUM) THEN
745: IF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_rec.content_type_id)
746: <> TRUE) THEN
747: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
748: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
749: FND_MESSAGE.Set_Token('ID',
750: TO_CHAR( l_item_rec.content_type_id ) );
751: FND_MSG_PUB.ADD;
752: END IF;

Line 749: FND_MESSAGE.Set_Token('ID',

745: IF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_rec.content_type_id)
746: <> TRUE) THEN
747: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
748: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
749: FND_MESSAGE.Set_Token('ID',
750: TO_CHAR( l_item_rec.content_type_id ) );
751: FND_MSG_PUB.ADD;
752: END IF;
753: l_item_rec.content_type_id := FND_API.G_MISS_NUM;

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

924: x_return_status := FND_API.G_RET_STS_ERROR;
925: END IF;
926: ELSE
927: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
929: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
930: FND_MESSAGE.Set_Token('ID',
931: TO_CHAR(NVL(l_channel_remove_id(i), -1)));
932: FND_MSG_PUB.ADD;

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

925: END IF;
926: ELSE
927: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
929: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
930: FND_MESSAGE.Set_Token('ID',
931: TO_CHAR(NVL(l_channel_remove_id(i), -1)));
932: FND_MSG_PUB.ADD;
933: END IF;

Line 930: FND_MESSAGE.Set_Token('ID',

926: ELSE
927: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
929: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
930: FND_MESSAGE.Set_Token('ID',
931: TO_CHAR(NVL(l_channel_remove_id(i), -1)));
932: FND_MSG_PUB.ADD;
933: END IF;
934: END IF;

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

958: x_return_status := FND_API.G_RET_STS_ERROR;
959: END IF;
960: ELSE
961: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
962: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
963: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
964: FND_MESSAGE.Set_Token('ID',
965: TO_CHAR(NVL(p_channel_id_array(i), -1)));
966: FND_MSG_PUB.ADD;

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

959: END IF;
960: ELSE
961: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
962: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
963: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
964: FND_MESSAGE.Set_Token('ID',
965: TO_CHAR(NVL(p_channel_id_array(i), -1)));
966: FND_MSG_PUB.ADD;
967: END IF;

Line 964: FND_MESSAGE.Set_Token('ID',

960: ELSE
961: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
962: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
963: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
964: FND_MESSAGE.Set_Token('ID',
965: TO_CHAR(NVL(p_channel_id_array(i), -1)));
966: FND_MSG_PUB.ADD;
967: END IF;
968: END IF;

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

1080: -- Check if user is login and has the required privilege.
1081: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1082: -- User is not login.
1083: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1084: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1085: FND_MSG_PUB.ADD;
1086: END IF;
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;

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

1089: END IF;
1090: -- Check if item id is valid.
1091: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1092: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1093: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1094: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1095: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
1096: FND_MSG_PUB.ADD;
1097: END IF;

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

1090: -- Check if item id is valid.
1091: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1092: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1093: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1094: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1095: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
1096: FND_MSG_PUB.ADD;
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;

Line 1095: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

1091: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1092: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1093: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1094: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1095: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
1096: FND_MSG_PUB.ADD;
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;

Line 1328: FND_MESSAGE.Set_name('AMV','PVT Find Item API: Start');

1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END IF;
1326: -- Debug Message
1327: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1328: FND_MESSAGE.Set_name('AMV','PVT Find Item API: Start');
1329: FND_MSG_PUB.ADD;
1330: END IF;
1331: --Initialize message list if p_init_msg_list is TRUE.
1332: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 1413: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

1409: l_where_clause || 'ORDER BY ITEM_NAME ';
1410: l_sql_statement2 := l_sql_statement2 ||
1411: l_where_clause;
1412: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1413: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1414: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
1415: FND_MSG_PUB.ADD;
1416: --
1417: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

Line 1414: FND_MESSAGE.Set_Token('ROW', l_sql_statement);

1410: l_sql_statement2 := l_sql_statement2 ||
1411: l_where_clause;
1412: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1413: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1414: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
1415: FND_MSG_PUB.ADD;
1416: --
1417: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1418: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);

Line 1417: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

1413: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1414: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
1415: FND_MSG_PUB.ADD;
1416: --
1417: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1418: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);
1419: FND_MSG_PUB.ADD;
1420: END IF;
1421: --Execute the SQL statements to get the total count:

Line 1418: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);

1414: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
1415: FND_MSG_PUB.ADD;
1416: --
1417: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
1418: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);
1419: FND_MSG_PUB.ADD;
1420: END IF;
1421: --Execute the SQL statements to get the total count:
1422: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN

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

1652: -- Check if user is login and has the required privilege.
1653: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1654: -- User is not login.
1655: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1656: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1657: FND_MSG_PUB.ADD;
1658: END IF;
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;

Line 1674: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

1670: );
1671: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1672: -- User is not an administrator.
1673: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1674: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1675: FND_MSG_PUB.ADD;
1676: END IF;
1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;

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

1807: -- Check if user is login and has the required privilege.
1808: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1809: -- User is not login.
1810: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1811: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1812: FND_MSG_PUB.ADD;
1813: END IF;
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;

Line 1829: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

1825: );
1826: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1827: -- User is not an administrator.
1828: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1829: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1830: FND_MSG_PUB.ADD;
1831: END IF;
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;

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

1966: -- Check if user is login and has the required privilege.
1967: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1968: -- User is not login.
1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1971: FND_MSG_PUB.ADD;
1972: END IF;
1973: RAISE FND_API.G_EXC_ERROR;
1974: END IF;

Line 1988: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

1984: );
1985: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1986: -- User is not an administrator.
1987: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1988: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1989: FND_MSG_PUB.ADD;
1990: END IF;
1991: RAISE FND_API.G_EXC_ERROR;
1992: END IF;

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

2097: -- Check if user is login and has the required privilege.
2098: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2099: -- User is not login.
2100: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2101: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2102: FND_MSG_PUB.ADD;
2103: END IF;
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;

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

2196: -- Check if user is login and has the required privilege.
2197: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2198: -- User is not login.
2199: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2200: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2201: FND_MSG_PUB.ADD;
2202: END IF;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;

Line 2218: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

2214: );
2215: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2216: -- User is not an administrator.
2217: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2218: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2219: FND_MSG_PUB.ADD;
2220: END IF;
2221: RAISE FND_API.G_EXC_ERROR;
2222: END IF;

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

2351: -- Check if user is login and has the required privilege.
2352: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2353: -- User is not login.
2354: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2355: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2356: FND_MSG_PUB.ADD;
2357: END IF;
2358: RAISE FND_API.G_EXC_ERROR;
2359: END IF;

Line 2373: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

2369: );
2370: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2371: -- User is not an administrator.
2372: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2373: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2374: FND_MSG_PUB.ADD;
2375: END IF;
2376: RAISE FND_API.G_EXC_ERROR;
2377: END IF;

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

2509: -- Check if user is login and has the required privilege.
2510: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2511: -- User is not login.
2512: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2513: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2514: FND_MSG_PUB.ADD;
2515: END IF;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;

Line 2531: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

2527: );
2528: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2529: -- User is not an administrator.
2530: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2531: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2532: FND_MSG_PUB.ADD;
2533: END IF;
2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;

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

2536: END IF;
2537: -- Check if item id is valid.
2538: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2539: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2540: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2541: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2542: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2543: FND_MSG_PUB.ADD;
2544: END IF;

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

2537: -- Check if item id is valid.
2538: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2539: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2540: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2541: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2542: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2543: FND_MSG_PUB.ADD;
2544: END IF;
2545: RAISE FND_API.G_EXC_ERROR;

Line 2542: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

2538: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2539: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2540: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2541: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2542: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2543: FND_MSG_PUB.ADD;
2544: END IF;
2545: RAISE FND_API.G_EXC_ERROR;
2546: END IF;

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

2650: -- Check if user is login and has the required privilege.
2651: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2652: -- User is not login.
2653: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2654: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2655: FND_MSG_PUB.ADD;
2656: END IF;
2657: RAISE FND_API.G_EXC_ERROR;
2658: END IF;

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

2778: -- Check if user is login and has the required privilege.
2779: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2780: -- User is not login.
2781: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2782: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2783: FND_MSG_PUB.ADD;
2784: END IF;
2785: RAISE FND_API.G_EXC_ERROR;
2786: END IF;

Line 2800: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

2796: );
2797: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2798: -- User is not an administrator.
2799: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2800: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2801: FND_MSG_PUB.ADD;
2802: END IF;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;

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

2810: END IF;
2811: -- Check if item id is valid.
2812: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2814: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2815: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2816: fnd_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2817: FND_MSG_PUB.ADD;
2818: END IF;

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

2811: -- Check if item id is valid.
2812: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2814: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2815: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2816: fnd_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2817: FND_MSG_PUB.ADD;
2818: END IF;
2819: RAISE FND_API.G_EXC_ERROR;

Line 2816: fnd_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

2812: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2814: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2815: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2816: fnd_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
2817: FND_MSG_PUB.ADD;
2818: END IF;
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;

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

2825: FETCH Get_FileLanguage_csr INTO l_language_code;
2826: IF (Get_FileLanguage_csr%NOTFOUND) THEN
2827: CLOSE Get_FileLanguage_csr;
2828: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2830: FND_MESSAGE.Set_Token('RECORD', 'AMV_FILE_TK', TRUE);
2831: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_file_id_varray(i)) );
2832: FND_MSG_PUB.ADD;
2833: END IF;

Line 2830: FND_MESSAGE.Set_Token('RECORD', 'AMV_FILE_TK', TRUE);

2826: IF (Get_FileLanguage_csr%NOTFOUND) THEN
2827: CLOSE Get_FileLanguage_csr;
2828: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2830: FND_MESSAGE.Set_Token('RECORD', 'AMV_FILE_TK', TRUE);
2831: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_file_id_varray(i)) );
2832: FND_MSG_PUB.ADD;
2833: END IF;
2834: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2831: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_file_id_varray(i)) );

2827: CLOSE Get_FileLanguage_csr;
2828: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2829: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2830: FND_MESSAGE.Set_Token('RECORD', 'AMV_FILE_TK', TRUE);
2831: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_file_id_varray(i)) );
2832: FND_MSG_PUB.ADD;
2833: END IF;
2834: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2835: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');

2842: IF (Check_Itemfile_csr%FOUND) THEN
2843: CLOSE Check_Itemfile_csr;
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));

Line 2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);

2843: CLOSE Check_Itemfile_csr;
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));
2851: FND_MSG_PUB.ADD;

Line 2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );

2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));
2851: FND_MSG_PUB.ADD;
2852: END IF;

Line 2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);

2845: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));
2851: FND_MSG_PUB.ADD;
2852: END IF;
2853: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));

2846: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
2847: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
2848: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
2849: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
2850: FND_MESSAGE.Set_Token('ATTRID', p_file_id_varray(i));
2851: FND_MSG_PUB.ADD;
2852: END IF;
2853: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2854: x_return_status := FND_API.G_RET_STS_ERROR;

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

3057: -- Check if user is login and has the required privilege.
3058: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3059: -- User is not login.
3060: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3061: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3062: FND_MSG_PUB.ADD;
3063: END IF;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;

Line 3079: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

3075: );
3076: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3077: -- User is not an administrator.
3078: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3079: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3080: FND_MSG_PUB.ADD;
3081: END IF;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;

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

3084: END IF;
3085: -- Check if item id is valid.
3086: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3087: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3088: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3089: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3090: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3091: FND_MSG_PUB.ADD;
3092: END IF;

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

3085: -- Check if item id is valid.
3086: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3087: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3088: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3089: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3090: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3091: FND_MSG_PUB.ADD;
3092: END IF;
3093: RAISE FND_API.G_EXC_ERROR;

Line 3090: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

3086: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3087: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3088: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3089: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3090: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3091: FND_MSG_PUB.ADD;
3092: END IF;
3093: RAISE FND_API.G_EXC_ERROR;
3094: END IF;

Line 3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');

3100: IF (Check_ItemFile_csr%NOTFOUND) THEN
3101: CLOSE Check_ItemFile_csr;
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
3108: FND_MESSAGE.Set_Token('ATTRID',

Line 3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);

3101: CLOSE Check_ItemFile_csr;
3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
3108: FND_MESSAGE.Set_Token('ATTRID',
3109: TO_CHAR( p_file_id_varray(i) ) );

Line 3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );

3102: x_return_status := FND_API.G_RET_STS_ERROR;
3103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
3108: FND_MESSAGE.Set_Token('ATTRID',
3109: TO_CHAR( p_file_id_varray(i) ) );
3110: FND_MSG_PUB.ADD;

Line 3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);

3103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
3108: FND_MESSAGE.Set_Token('ATTRID',
3109: TO_CHAR( p_file_id_varray(i) ) );
3110: FND_MSG_PUB.ADD;
3111: END IF;

Line 3108: FND_MESSAGE.Set_Token('ATTRID',

3104: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
3105: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
3106: FND_MESSAGE.Set_Token('ENTID', TO_CHAR(p_item_id) );
3107: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_FILE_TK', TRUE);
3108: FND_MESSAGE.Set_Token('ATTRID',
3109: TO_CHAR( p_file_id_varray(i) ) );
3110: FND_MSG_PUB.ADD;
3111: END IF;
3112: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

3262: -- Check if user is login and has the required privilege.
3263: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3264: -- User is not login.
3265: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3266: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3267: FND_MSG_PUB.ADD;
3268: END IF;
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;

Line 3284: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

3280: );
3281: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3282: -- User is not an administrator.
3283: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3284: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3285: FND_MSG_PUB.ADD;
3286: END IF;
3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;

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

3289: END IF;
3290: -- Check if item id is valid.
3291: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3293: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3294: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3295: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3296: FND_MSG_PUB.ADD;
3297: END IF;

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

3290: -- Check if item id is valid.
3291: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3293: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3294: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3295: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3296: FND_MSG_PUB.ADD;
3297: END IF;
3298: RAISE FND_API.G_EXC_ERROR;

Line 3295: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

3291: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3293: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3294: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3295: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3296: FND_MSG_PUB.ADD;
3297: END IF;
3298: RAISE FND_API.G_EXC_ERROR;
3299: END IF;

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

3411: -- Check if user is login and has the required privilege.
3412: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3413: -- User is not login.
3414: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3415: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3416: FND_MSG_PUB.ADD;
3417: END IF;
3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;

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

3420: END IF;
3421: -- Check if item id is valid.
3422: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3423: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3424: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3425: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3426: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3427: FND_MSG_PUB.ADD;
3428: END IF;

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

3421: -- Check if item id is valid.
3422: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3423: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3424: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3425: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3426: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3427: FND_MSG_PUB.ADD;
3428: END IF;
3429: RAISE FND_API.G_EXC_ERROR;

Line 3426: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

3422: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3423: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3424: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3425: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3426: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));
3427: FND_MSG_PUB.ADD;
3428: END IF;
3429: RAISE FND_API.G_EXC_ERROR;
3430: END IF;

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

3558: -- Check if user is login and has the required privilege.
3559: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3560: -- User is not login.
3561: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3562: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3563: FND_MSG_PUB.ADD;
3564: END IF;
3565: RAISE FND_API.G_EXC_ERROR;
3566: END IF;

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

3740: -- Check if user is login and has the required privilege.
3741: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3742: -- User is not login.
3743: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3744: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3745: FND_MSG_PUB.ADD;
3746: END IF;
3747: RAISE FND_API.G_EXC_ERROR;
3748: END IF;

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

3909: -- Check if user is login and has the required privilege.
3910: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3911: -- User is not login.
3912: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3913: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3914: FND_MSG_PUB.ADD;
3915: END IF;
3916: RAISE FND_API.G_EXC_ERROR;
3917: END IF;