APPS.AMV_MATCH_PVT dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: --Initialize message list if p_init_msg_list is TRUE.
71: IF FND_API.To_Boolean (p_init_msg_list) THEN
72: FND_MSG_PUB.initialize;
73: END IF;
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

Line 77: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

73: END IF;
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;

Line 81: FND_MSG_PUB.Add;

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;
85: --

Line 113: FND_MSG_PUB.Count_And_Get (

109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK TO Request_ItemMatch_Pvt;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data
117: );

Line 122: FND_MSG_PUB.Count_And_Get (

118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO Request_ItemMatch_Pvt;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: -- Standard call to get message count and if count=1, get the message
122: FND_MSG_PUB.Count_And_Get (
123: p_encoded => FND_API.G_FALSE,
124: p_count => x_msg_count,
125: p_data => x_msg_data
126: );

Line 130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

126: );
127: WHEN OTHERS THEN
128: ROLLBACK TO Request_ItemMatch_Pvt;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
132: END IF;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (

Line 131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

127: WHEN OTHERS THEN
128: ROLLBACK TO Request_ItemMatch_Pvt;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
132: END IF;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,

Line 134: FND_MSG_PUB.Count_And_Get (

130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
132: END IF;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );

Line 170: FND_MSG_PUB.initialize;

166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168: --Initialize message list if p_init_msg_list is TRUE.
169: IF FND_API.To_Boolean (p_init_msg_list) THEN
170: FND_MSG_PUB.initialize;
171: END IF;
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

Line 175: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

171: END IF;
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;

Line 179: FND_MSG_PUB.Add;

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;
183: --

Line 211: FND_MSG_PUB.Count_And_Get (

207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Request_ChannelMatch_Pvt;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: -- Standard call to get message count and if count=1, get the message
211: FND_MSG_PUB.Count_And_Get (
212: p_encoded => FND_API.G_FALSE,
213: p_count => x_msg_count,
214: p_data => x_msg_data
215: );

Line 220: FND_MSG_PUB.Count_And_Get (

216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO Request_ChannelMatch_Pvt;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: FND_MSG_PUB.Count_And_Get (
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data
224: );

Line 228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

224: );
225: WHEN OTHERS THEN
226: ROLLBACK TO Request_ChannelMatch_Pvt;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
230: END IF;
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (

Line 229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

225: WHEN OTHERS THEN
226: ROLLBACK TO Request_ChannelMatch_Pvt;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
230: END IF;
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (
233: p_encoded => FND_API.G_FALSE,

Line 232: FND_MSG_PUB.Count_And_Get (

228: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
230: END IF;
231: -- Standard call to get message count and if count=1, get the message
232: FND_MSG_PUB.Count_And_Get (
233: p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => x_msg_data
236: );

Line 268: FND_MSG_PUB.initialize;

264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: --Initialize message list if p_init_msg_list is TRUE.
267: IF FND_API.To_Boolean (p_init_msg_list) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270: l_message_obj := SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
271: (
272: G_AMV_APP_ID,

Line 297: FND_MSG_PUB.Count_And_Get (

293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO Stop_MatchingEngine_Pvt;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get (
298: p_encoded => FND_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 306: FND_MSG_PUB.Count_And_Get (

302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK TO Stop_MatchingEngine_Pvt;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: -- Standard call to get message count and if count=1, get the message
306: FND_MSG_PUB.Count_And_Get (
307: p_encoded => FND_API.G_FALSE,
308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );

Line 314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

310: );
311: WHEN OTHERS THEN
312: ROLLBACK TO Stop_MatchingEngine_Pvt;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
315: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
316: END IF;
317: -- Standard call to get message count and if count=1, get the message
318: FND_MSG_PUB.Count_And_Get (

Line 315: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

311: WHEN OTHERS THEN
312: ROLLBACK TO Stop_MatchingEngine_Pvt;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
315: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
316: END IF;
317: -- Standard call to get message count and if count=1, get the message
318: FND_MSG_PUB.Count_And_Get (
319: p_encoded => FND_API.G_FALSE,

Line 318: FND_MSG_PUB.Count_And_Get (

314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
315: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
316: END IF;
317: -- Standard call to get message count and if count=1, get the message
318: FND_MSG_PUB.Count_And_Get (
319: p_encoded => FND_API.G_FALSE,
320: p_count => x_msg_count,
321: p_data => x_msg_data
322: );

Line 357: FND_MSG_PUB.initialize;

353: --
354: BEGIN
355: SAVEPOINT Start_MatchingEngine_Pvt;
356: --Initialize message list
357: FND_MSG_PUB.initialize;
358: -- Initialize API return status to success
359: errbuf := '';
360: retcode := 0;
361:

Line 438: FND_MSG_PUB.Count_And_Get (

434: END IF;
435: END IF;
436: END LOOP;
437: --Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => l_msg_count,
441: p_data => l_msg_data
442: );

Line 448: FND_MSG_PUB.Count_And_Get (

444: EXCEPTION
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Start_MatchingEngine_Pvt;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => l_msg_count,
451: p_data => l_msg_data
452: );

Line 458: FND_MSG_PUB.Count_And_Get (

454: retcode := 2;
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO Start_MatchingEngine_Pvt;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => l_msg_count,
461: p_data => l_msg_data
462: );

Line 467: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

463: errbuf := l_msg_data;
464: retcode := 2;
465: WHEN OTHERS THEN
466: ROLLBACK TO Start_MatchingEngine_Pvt;
467: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
469: END IF;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (

Line 468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

464: retcode := 2;
465: WHEN OTHERS THEN
466: ROLLBACK TO Start_MatchingEngine_Pvt;
467: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
469: END IF;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,

Line 471: FND_MSG_PUB.Count_And_Get (

467: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
468: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
469: END IF;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => l_msg_count,
474: p_data => l_msg_data
475: );

Line 555: FND_MSG_PUB.initialize;

551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END IF;
553: --Initialize message list if p_init_msg_list is TRUE.
554: IF FND_API.To_Boolean (p_init_msg_list) THEN
555: FND_MSG_PUB.initialize;
556: END IF;
557: -- Initialize API return status to success
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559: -- Get the current (login) user id.

Line 570: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

566: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 572: FND_MSG_PUB.Add;

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;
576: END IF;

Line 592: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

588: INTO l_content_type_id, l_application_id, l_status, l_expiration_date;
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;

Line 596: FND_MSG_PUB.Add;

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;
600: CLOSE Get_ItemInfo_csr;

Line 786: FND_MSG_PUB.Count_And_Get (

782: IF FND_API.To_Boolean ( p_commit ) THEN
783: COMMIT WORK;
784: END IF;
785: --Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790: EXCEPTION

Line 795: FND_MSG_PUB.Count_And_Get (

791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO Match_ItemWithChannels_Pvt;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: -- Standard call to get message count and if count=1, get the message
795: FND_MSG_PUB.Count_And_Get (
796: p_encoded => FND_API.G_FALSE,
797: p_count => x_msg_count,
798: p_data => x_msg_data
799: );

Line 804: FND_MSG_PUB.Count_And_Get (

800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO Match_ItemWithChannels_Pvt;
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: -- Standard call to get message count and if count=1, get the message
804: FND_MSG_PUB.Count_And_Get (
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );

Line 812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

808: );
809: WHEN OTHERS THEN
810: ROLLBACK TO Match_ItemWithChannels_Pvt;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
814: END IF;
815: -- Standard call to get message count and if count=1, get the message
816: FND_MSG_PUB.Count_And_Get (

Line 813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

809: WHEN OTHERS THEN
810: ROLLBACK TO Match_ItemWithChannels_Pvt;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
814: END IF;
815: -- Standard call to get message count and if count=1, get the message
816: FND_MSG_PUB.Count_And_Get (
817: p_encoded => FND_API.G_FALSE,

Line 816: FND_MSG_PUB.Count_And_Get (

812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
813: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
814: END IF;
815: -- Standard call to get message count and if count=1, get the message
816: FND_MSG_PUB.Count_And_Get (
817: p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data
820: );

Line 891: FND_MSG_PUB.initialize;

887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889: --Initialize message list if p_init_msg_list is TRUE.
890: IF FND_API.To_Boolean (p_init_msg_list) THEN
891: FND_MSG_PUB.initialize;
892: END IF;
893: -- Initialize API return status to success
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: -- Get the current (login) user id.

Line 906: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

902: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 908: FND_MSG_PUB.Add;

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;
912: END IF;

Line 933: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

929: l_expiration_date;
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;

Line 937: FND_MSG_PUB.Add;

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;
941: CLOSE Get_ChannelInfo_csr;

Line 1095: FND_MSG_PUB.Count_And_Get (

1091: IF FND_API.To_Boolean ( p_commit ) THEN
1092: COMMIT WORK;
1093: END IF;
1094: --Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_count => x_msg_count,
1097: p_data => x_msg_data
1098: );
1099: EXCEPTION

Line 1104: FND_MSG_PUB.Count_And_Get (

1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: ROLLBACK TO Match_ChannelWithItems_Pvt;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1108: );

Line 1113: FND_MSG_PUB.Count_And_Get (

1109: WHEN FND_API.G_EXC_ERROR THEN
1110: ROLLBACK TO Match_ChannelWithItems_Pvt;
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: -- Standard call to get message count and if count=1, get the message
1113: FND_MSG_PUB.Count_And_Get (
1114: p_encoded => FND_API.G_FALSE,
1115: p_count => x_msg_count,
1116: p_data => x_msg_data
1117: );

Line 1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1117: );
1118: WHEN OTHERS THEN
1119: ROLLBACK TO Match_ChannelWithItems_Pvt;
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1123: END IF;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (

Line 1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1118: WHEN OTHERS THEN
1119: ROLLBACK TO Match_ChannelWithItems_Pvt;
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1123: END IF;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,

Line 1125: FND_MSG_PUB.Count_And_Get (

1121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1123: END IF;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );

Line 1172: FND_MSG_PUB.initialize;

1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END IF;
1170: --Initialize message list if p_init_msg_list is TRUE.
1171: IF FND_API.To_Boolean (p_init_msg_list) THEN
1172: FND_MSG_PUB.initialize;
1173: END IF;
1174: -- Initialize API return status to success
1175: x_return_status := FND_API.G_RET_STS_SUCCESS;
1176: -- Get the current (login) user id.

Line 1187: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1183: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 1189: FND_MSG_PUB.Add;

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;
1193: END IF;

Line 1211: FND_MSG_PUB.Count_And_Get (

1207: x_match_exist_flag := FND_API.G_FALSE;
1208: x_approval_status := FND_API.G_MISS_CHAR;
1209: END IF;
1210: --Standard call to get message count and if count=1, get the message
1211: FND_MSG_PUB.Count_And_Get (
1212: p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215: EXCEPTION

Line 1219: FND_MSG_PUB.Count_And_Get (

1215: EXCEPTION
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: -- Standard call to get message count and if count=1, get the message
1219: FND_MSG_PUB.Count_And_Get (
1220: p_encoded => FND_API.G_FALSE,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data
1223: );

Line 1227: FND_MSG_PUB.Count_And_Get (

1223: );
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: -- Standard call to get message count and if count=1, get the message
1227: FND_MSG_PUB.Count_And_Get (
1228: p_encoded => FND_API.G_FALSE,
1229: p_count => x_msg_count,
1230: p_data => x_msg_data
1231: );

Line 1234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1230: p_data => x_msg_data
1231: );
1232: WHEN OTHERS THEN
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (

Line 1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1231: );
1232: WHEN OTHERS THEN
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,

Line 1238: FND_MSG_PUB.Count_And_Get (

1234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1236: END IF;
1237: -- Standard call to get message count and if count=1, get the message
1238: FND_MSG_PUB.Count_And_Get (
1239: p_encoded => FND_API.G_FALSE,
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );

Line 1327: FND_MSG_PUB.initialize;

1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325: --Initialize message list if p_init_msg_list is TRUE.
1326: IF FND_API.To_Boolean (p_init_msg_list) THEN
1327: FND_MSG_PUB.initialize;
1328: END IF;
1329: -- Initialize API return status to success
1330: x_return_status := FND_API.G_RET_STS_SUCCESS;
1331: IF (p_match_on_author_flag = FND_API.G_FALSE AND

Line 1351: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1347: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 1353: FND_MSG_PUB.Add;

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;
1357: END IF;

Line 1416: FND_MSG_PUB.Count_And_Get (

1412: CLOSE Check_ItemType_Match_csr;
1413: END IF;
1414: END IF;
1415: --Standard call to get message count and if count=1, get the message
1416: FND_MSG_PUB.Count_And_Get (
1417: p_encoded => FND_API.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );

Line 1426: FND_MSG_PUB.Count_And_Get (

1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1424: x_match_flag := FND_API.G_FALSE;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data
1430: );

Line 1435: FND_MSG_PUB.Count_And_Get (

1431: WHEN FND_API.G_EXC_ERROR THEN
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: x_match_flag := FND_API.G_FALSE;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1436: p_encoded => FND_API.G_FALSE,
1437: p_count => x_msg_count,
1438: p_data => x_msg_data
1439: );

Line 1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1439: );
1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: x_match_flag := FND_API.G_FALSE;
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1445: END IF;
1446: -- Standard call to get message count and if count=1, get the message
1447: FND_MSG_PUB.Count_And_Get (

Line 1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: x_match_flag := FND_API.G_FALSE;
1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1445: END IF;
1446: -- Standard call to get message count and if count=1, get the message
1447: FND_MSG_PUB.Count_And_Get (
1448: p_encoded => FND_API.G_FALSE,

Line 1447: FND_MSG_PUB.Count_And_Get (

1443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1444: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1445: END IF;
1446: -- Standard call to get message count and if count=1, get the message
1447: FND_MSG_PUB.Count_And_Get (
1448: p_encoded => FND_API.G_FALSE,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data
1451: );

Line 1495: FND_MSG_PUB.initialize;

1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493: --Initialize message list if p_init_msg_list is TRUE.
1494: IF FND_API.To_Boolean (p_init_msg_list) THEN
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497: -- Initialize API return status to success
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;
1499: IF (p_match_on_author_flag = FND_API.G_FALSE AND

Line 1520: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1516: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 1522: FND_MSG_PUB.Add;

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;
1526: END IF;

Line 1585: FND_MSG_PUB.Count_And_Get (

1581: x_match_flag := FND_API.G_FALSE;
1582: END IF;
1583: CLOSE l_cursor;
1584: --Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );

Line 1595: FND_MSG_PUB.Count_And_Get (

1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: x_match_flag := FND_API.G_FALSE;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1599: );

Line 1604: FND_MSG_PUB.Count_And_Get (

1600: WHEN FND_API.G_EXC_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: x_match_flag := FND_API.G_FALSE;
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data
1608: );

Line 1612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1608: );
1609: WHEN OTHERS THEN
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: x_match_flag := FND_API.G_FALSE;
1612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (

Line 1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1609: WHEN OTHERS THEN
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: x_match_flag := FND_API.G_FALSE;
1612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (
1617: p_encoded => FND_API.G_FALSE,

Line 1616: FND_MSG_PUB.Count_And_Get (

1612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: -- Standard call to get message count and if count=1, get the message
1616: FND_MSG_PUB.Count_And_Get (
1617: p_encoded => FND_API.G_FALSE,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data
1620: );

Line 1704: FND_MSG_PUB.initialize;

1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702: --Initialize message list if p_init_msg_list is TRUE.
1703: IF FND_API.To_Boolean (p_init_msg_list) THEN
1704: FND_MSG_PUB.initialize;
1705: END IF;
1706: -- Initialize API return status to success
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708: -- Get the current (login) user id.

Line 1732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1728: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 1734: FND_MSG_PUB.Add;

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;
1738: END IF;

Line 1761: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1757: l_match_id,
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;

Line 1765: FND_MSG_PUB.Add;

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;
1769: CLOSE Get_ChannelInfo_csr;

Line 1782: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1778: OPEN Get_OwnerIDAndName_csr (l_resource_id);
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;

Line 1786: FND_MSG_PUB.Add;

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;
1790: CLOSE Get_OwnerIDAndName_csr;

Line 1843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1839: END IF;
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;

Line 1846: FND_MSG_PUB.Add;

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;
1850: --

Line 1896: FND_MSG_PUB.Count_And_Get (

1892: IF FND_API.To_Boolean ( p_commit ) THEN
1893: COMMIT WORK;
1894: END IF;
1895: --Standard call to get message count and if count=1, get the message
1896: FND_MSG_PUB.Count_And_Get (
1897: p_encoded => FND_API.G_FALSE,
1898: p_count => x_msg_count,
1899: p_data => x_msg_data
1900: );

Line 1906: FND_MSG_PUB.Count_And_Get (

1902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1903: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: -- Standard call to get message count and if count=1, get the message
1906: FND_MSG_PUB.Count_And_Get (
1907: p_encoded => FND_API.G_FALSE,
1908: p_count => x_msg_count,
1909: p_data => x_msg_data
1910: );

Line 1915: FND_MSG_PUB.Count_And_Get (

1911: WHEN FND_API.G_EXC_ERROR THEN
1912: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1913: x_return_status := FND_API.G_RET_STS_ERROR;
1914: -- Standard call to get message count and if count=1, get the message
1915: FND_MSG_PUB.Count_And_Get (
1916: p_encoded => FND_API.G_FALSE,
1917: p_count => x_msg_count,
1918: p_data => x_msg_data
1919: );

Line 1923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1919: );
1920: WHEN OTHERS THEN
1921: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1925: END IF;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (

Line 1924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1920: WHEN OTHERS THEN
1921: ROLLBACK TO Do_ItemChannelMatch_Pvt;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1925: END IF;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (
1928: p_encoded => FND_API.G_FALSE,

Line 1927: FND_MSG_PUB.Count_And_Get (

1923: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1925: END IF;
1926: -- Standard call to get message count and if count=1, get the message
1927: FND_MSG_PUB.Count_And_Get (
1928: p_encoded => FND_API.G_FALSE,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data
1931: );

Line 2044: FND_MSG_PUB.initialize;

2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: END IF;
2042: --Initialize message list if p_init_msg_list is TRUE.
2043: IF FND_API.To_Boolean (p_init_msg_list) THEN
2044: FND_MSG_PUB.initialize;
2045: END IF;
2046: -- Initialize API return status to success
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048: -- Get the current (login) user id.

Line 2059: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2055: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 2061: FND_MSG_PUB.Add;

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;
2065: END IF;

Line 2161: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2157: l_match_id,
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;

Line 2165: FND_MSG_PUB.Add;

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;
2169: CLOSE Get_ChannelInfo_csr;

Line 2182: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2178: OPEN Get_OwnerIDAndName_csr (l_resource_id);
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;

Line 2186: FND_MSG_PUB.Add;

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;
2190: CLOSE Get_OwnerIDAndName_csr;

Line 2256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2252:
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;

Line 2259: FND_MSG_PUB.Add;

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;
2263: --

Line 2311: FND_MSG_PUB.Count_And_Get (

2307: IF FND_API.To_Boolean ( p_commit ) THEN
2308: COMMIT WORK;
2309: END IF;
2310: --Standard call to get message count and if count=1, get the message
2311: FND_MSG_PUB.Count_And_Get (
2312: p_encoded => FND_API.G_FALSE,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data
2315: );

Line 2321: FND_MSG_PUB.Count_And_Get (

2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2320: -- Standard call to get message count and if count=1, get the message
2321: FND_MSG_PUB.Count_And_Get (
2322: p_encoded => FND_API.G_FALSE,
2323: p_count => x_msg_count,
2324: p_data => x_msg_data
2325: );

Line 2330: FND_MSG_PUB.Count_And_Get (

2326: WHEN FND_API.G_EXC_ERROR THEN
2327: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: -- Standard call to get message count and if count=1, get the message
2330: FND_MSG_PUB.Count_And_Get (
2331: p_encoded => FND_API.G_FALSE,
2332: p_count => x_msg_count,
2333: p_data => x_msg_data
2334: );

Line 2338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2334: );
2335: WHEN OTHERS THEN
2336: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2340: END IF;
2341: -- Standard call to get message count and if count=1, get the message
2342: FND_MSG_PUB.Count_And_Get (

Line 2339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2335: WHEN OTHERS THEN
2336: ROLLBACK TO Do_ItemChannelMatch_Pvt;
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2340: END IF;
2341: -- Standard call to get message count and if count=1, get the message
2342: FND_MSG_PUB.Count_And_Get (
2343: p_encoded => FND_API.G_FALSE,

Line 2342: FND_MSG_PUB.Count_And_Get (

2338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2339: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2340: END IF;
2341: -- Standard call to get message count and if count=1, get the message
2342: FND_MSG_PUB.Count_And_Get (
2343: p_encoded => FND_API.G_FALSE,
2344: p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );

Line 2419: FND_MSG_PUB.initialize;

2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: END IF;
2417: --Initialize message list if p_init_msg_list is TRUE.
2418: IF FND_API.To_Boolean (p_init_msg_list) THEN
2419: FND_MSG_PUB.initialize;
2420: END IF;
2421: -- Initialize API return status to success
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423: -- Get the current (login) user id.

Line 2434: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2430: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 2436: FND_MSG_PUB.Add;

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;
2440: END IF;

Line 2470: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2466: --
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;

Line 2473: FND_MSG_PUB.Add;

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;
2477: --

Line 2491: FND_MSG_PUB.Count_And_Get (

2487: IF FND_API.To_Boolean ( p_commit ) THEN
2488: COMMIT WORK;
2489: END IF;
2490: --Standard call to get message count and if count=1, get the message
2491: FND_MSG_PUB.Count_And_Get (
2492: p_encoded => FND_API.G_FALSE,
2493: p_count => x_msg_count,
2494: p_data => x_msg_data
2495: );

Line 2501: FND_MSG_PUB.Count_And_Get (

2497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2498: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: -- Standard call to get message count and if count=1, get the message
2501: FND_MSG_PUB.Count_And_Get (
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data
2505: );

Line 2510: FND_MSG_PUB.Count_And_Get (

2506: WHEN FND_API.G_EXC_ERROR THEN
2507: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2508: x_return_status := FND_API.G_RET_STS_ERROR;
2509: -- Standard call to get message count and if count=1, get the message
2510: FND_MSG_PUB.Count_And_Get (
2511: p_encoded => FND_API.G_FALSE,
2512: p_count => x_msg_count,
2513: p_data => x_msg_data
2514: );

Line 2518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2514: );
2515: WHEN OTHERS THEN
2516: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2520: END IF;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (

Line 2519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2515: WHEN OTHERS THEN
2516: ROLLBACK TO Remove_ItemChannelMatch_PVT;
2517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2520: END IF;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,

Line 2522: FND_MSG_PUB.Count_And_Get (

2518: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2520: END IF;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );

Line 2578: FND_MSG_PUB.initialize;

2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: END IF;
2576: --Initialize message list if p_init_msg_list is TRUE.
2577: IF FND_API.To_Boolean (p_init_msg_list) THEN
2578: FND_MSG_PUB.initialize;
2579: END IF;
2580: -- Initialize API return status to success
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;
2582: -- Get the current (login) user id.

Line 2593: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2589: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 2595: FND_MSG_PUB.ADD;

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;
2599: END IF;

Line 2615: FND_MSG_PUB.Count_And_Get (

2611: END LOOP;
2612: --TYPE territory_tbl_type IS TABLE OF NUMBER;
2613: --TYPE terr_name_tbl_type IS TABLE OF VARCHAR2(4000);
2614: --Standard call to get message count and if count=1, get the message
2615: FND_MSG_PUB.Count_And_Get (
2616: p_encoded => FND_API.G_FALSE,
2617: p_count => x_msg_count,
2618: p_data => x_msg_data
2619: );

Line 2624: FND_MSG_PUB.Count_And_Get (

2620: EXCEPTION
2621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2623: -- Standard call to get message count and if count=1, get the message
2624: FND_MSG_PUB.Count_And_Get (
2625: p_encoded => FND_API.G_FALSE,
2626: p_count => x_msg_count,
2627: p_data => x_msg_data
2628: );

Line 2632: FND_MSG_PUB.Count_And_Get (

2628: );
2629: WHEN FND_API.G_EXC_ERROR THEN
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: -- Standard call to get message count and if count=1, get the message
2632: FND_MSG_PUB.Count_And_Get (
2633: p_encoded => FND_API.G_FALSE,
2634: p_count => x_msg_count,
2635: p_data => x_msg_data
2636: );

Line 2639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2635: p_data => x_msg_data
2636: );
2637: WHEN OTHERS THEN
2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (

Line 2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2636: );
2637: WHEN OTHERS THEN
2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,

Line 2643: FND_MSG_PUB.Count_And_Get (

2639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2641: END IF;
2642: -- Standard call to get message count and if count=1, get the message
2643: FND_MSG_PUB.Count_And_Get (
2644: p_encoded => FND_API.G_FALSE,
2645: p_count => x_msg_count,
2646: p_data => x_msg_data
2647: );

Line 2693: FND_MSG_PUB.initialize;

2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: END IF;
2691: --Initialize message list if p_init_msg_list is TRUE.
2692: IF FND_API.To_Boolean (p_init_msg_list) THEN
2693: FND_MSG_PUB.initialize;
2694: END IF;
2695: -- Initialize API return status to success
2696: x_return_status := FND_API.G_RET_STS_SUCCESS;
2697: -- Get the current (login) user id.

Line 2708: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2704: IF (p_check_login_user = FND_API.G_TRUE) THEN
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;

Line 2710: FND_MSG_PUB.ADD;

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;
2714: END IF;

Line 2723: FND_MSG_PUB.Count_And_Get (

2719: x_item_id_tbl(l_rec_count) := cur.item_id;
2720: l_rec_count := l_rec_count + 1;
2721: END LOOP;
2722: --Standard call to get message count and if count=1, get the message
2723: FND_MSG_PUB.Count_And_Get (
2724: p_encoded => FND_API.G_FALSE,
2725: p_count => x_msg_count,
2726: p_data => x_msg_data
2727: );

Line 2732: FND_MSG_PUB.Count_And_Get (

2728: EXCEPTION
2729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2731: -- Standard call to get message count and if count=1, get the message
2732: FND_MSG_PUB.Count_And_Get (
2733: p_encoded => FND_API.G_FALSE,
2734: p_count => x_msg_count,
2735: p_data => x_msg_data
2736: );

Line 2740: FND_MSG_PUB.Count_And_Get (

2736: );
2737: WHEN FND_API.G_EXC_ERROR THEN
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: -- Standard call to get message count and if count=1, get the message
2740: FND_MSG_PUB.Count_And_Get (
2741: p_encoded => FND_API.G_FALSE,
2742: p_count => x_msg_count,
2743: p_data => x_msg_data
2744: );

Line 2747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2743: p_data => x_msg_data
2744: );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2749: END IF;
2750: -- Standard call to get message count and if count=1, get the message
2751: FND_MSG_PUB.Count_And_Get (

Line 2748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2744: );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2749: END IF;
2750: -- Standard call to get message count and if count=1, get the message
2751: FND_MSG_PUB.Count_And_Get (
2752: p_encoded => FND_API.G_FALSE,

Line 2751: FND_MSG_PUB.Count_And_Get (

2747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2749: END IF;
2750: -- Standard call to get message count and if count=1, get the message
2751: FND_MSG_PUB.Count_And_Get (
2752: p_encoded => FND_API.G_FALSE,
2753: p_count => x_msg_count,
2754: p_data => x_msg_data
2755: );