eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_MYCHANNEL_PVT dependencies on FND_MSG_PUB

Line 218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: -- Debug Message
218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
219: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
220: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
221: FND_MSG_PUB.Add;
222: END IF;

Line 221: FND_MSG_PUB.Add;

217: -- Debug Message
218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
219: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
220: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
221: FND_MSG_PUB.Add;
222: END IF;
223: --Initialize message list if p_init_msg_list is TRUE.
224: IF FND_API.To_Boolean (p_init_msg_list) THEN
225: FND_MSG_PUB.initialize;

Line 225: FND_MSG_PUB.initialize;

221: FND_MSG_PUB.Add;
222: END IF;
223: --Initialize message list if p_init_msg_list is TRUE.
224: IF FND_API.To_Boolean (p_init_msg_list) THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227: -- Get the current (login) user id.
228: AMV_UTILITY_PVT.Get_UserInfo(
229: x_resource_id => l_resource_id,

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

235: IF (p_check_login_user = FND_API.G_TRUE) THEN
236: -- Check if user is login and has the required privilege.
237: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
238: -- User is not login.
239: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
240: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
241: FND_MSG_PUB.Add;
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;

Line 241: FND_MSG_PUB.Add;

237: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
238: -- User is not login.
239: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
240: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
241: FND_MSG_PUB.Add;
242: END IF;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: END IF;

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

255: OPEN Get_OwnerIDAndName_csr (l_resource_id);
256: FETCH Get_OwnerIDAndName_csr INTO l_owner_name, l_owner_id;
257: IF (Get_OwnerIDAndName_csr%NOTFOUND) THEN
258: CLOSE Get_OwnerIDAndName_csr;
259: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
261: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
262: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
263: FND_MSG_PUB.Add;

Line 263: FND_MSG_PUB.Add;

259: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
261: FND_MESSAGE.Set_Token('RECORD', 'AMV_CHANNEL_TK', TRUE);
262: FND_MESSAGE.Set_Token('ID', to_char(nvl(l_resource_id,-1)));
263: FND_MSG_PUB.Add;
264: END IF;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267: CLOSE Get_OwnerIDAndName_csr;

Line 278: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

274: Workflowprocess => 'AMV_SUBSCRIPTION_APPROVAL'
275: );
276:
277: -- Success message
278: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
279: THEN
280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
281: FND_MESSAGE.Set_Token('ROW', l_full_name);
282: FND_MSG_PUB.Add;

Line 282: FND_MSG_PUB.Add;

278: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
279: THEN
280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
281: FND_MESSAGE.Set_Token('ROW', l_full_name);
282: FND_MSG_PUB.Add;
283: END IF;
284: -- Standard check of commit
285: IF FND_API.To_Boolean ( p_commit ) THEN
286: COMMIT WORK;

Line 289: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

285: IF FND_API.To_Boolean ( p_commit ) THEN
286: COMMIT WORK;
287: END IF;
288: -- Debug Message
289: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
290: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
291: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
292: FND_MSG_PUB.Add;
293: END IF;

Line 292: FND_MSG_PUB.Add;

288: -- Debug Message
289: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
290: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
291: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
292: FND_MSG_PUB.Add;
293: END IF;
294: --Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (
296: p_encoded => FND_API.G_FALSE,

Line 295: FND_MSG_PUB.Count_And_Get (

291: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
292: FND_MSG_PUB.Add;
293: END IF;
294: --Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (
296: p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );

Line 305: FND_MSG_PUB.Count_And_Get (

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

Line 314: FND_MSG_PUB.Count_And_Get (

310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: ROLLBACK TO Subscribe_Channel_PVT;
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: -- Standard call to get message count and if count=1, get the message
314: FND_MSG_PUB.Count_And_Get (
315: p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );

Line 322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO Subscribe_Channel_PVT;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message

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

320: ROLLBACK TO Subscribe_Channel_PVT;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
327: FND_MSG_PUB.Count_And_Get (
328: p_encoded => FND_API.G_FALSE,

Line 327: FND_MSG_PUB.Count_And_Get (

323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
327: FND_MSG_PUB.Count_And_Get (
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data
331: );

Line 422: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

418: THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: -- Debug Message
422: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
423: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
424: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
425: FND_MSG_PUB.Add;
426: END IF;

Line 425: FND_MSG_PUB.Add;

421: -- Debug Message
422: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
423: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
424: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
425: FND_MSG_PUB.Add;
426: END IF;
427: --Initialize message list if p_init_msg_list is TRUE.
428: IF FND_API.To_Boolean (p_init_msg_list) THEN
429: FND_MSG_PUB.initialize;

Line 429: FND_MSG_PUB.initialize;

425: FND_MSG_PUB.Add;
426: END IF;
427: --Initialize message list if p_init_msg_list is TRUE.
428: IF FND_API.To_Boolean (p_init_msg_list) THEN
429: FND_MSG_PUB.initialize;
430: END IF;
431:
432: -- check login user
433: IF (p_check_login_user = FND_API.G_TRUE) THEN

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

440: );
441: -- Check if user is login and has the required privilege.
442: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
443: -- User is not login.
444: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
445: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
446: FND_MSG_PUB.Add;
447: END IF;
448: RAISE FND_API.G_EXC_ERROR;

Line 446: FND_MSG_PUB.Add;

442: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
443: -- User is not login.
444: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
445: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
446: FND_MSG_PUB.Add;
447: END IF;
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450: END IF;

Line 477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

473:
474: -- create subscription after validation
475: IF l_valid_flag = FND_API.G_TRUE THEN
476: IF l_mychannel_id <> FND_API.G_MISS_NUM THEN
477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
478: THEN
479: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_EXISTS');
480: FND_MESSAGE.Set_Token('TKN',p_mychannel_obj.user_or_group_type);
481: FND_MSG_PUB.Add;

Line 481: FND_MSG_PUB.Add;

477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
478: THEN
479: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_EXISTS');
480: FND_MESSAGE.Set_Token('TKN',p_mychannel_obj.user_or_group_type);
481: FND_MSG_PUB.Add;
482: END IF;
483: RAISE FND_API.G_EXC_ERROR;
484: ELSE
485: -- set mychannel order

Line 539: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

535: p_mychannel_obj.notification_interval_type
536: );
537: END IF;
538: ELSE
539: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
540: THEN
541: -- NOTE change token name CATEGORY to generic name
542: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
543: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

Line 544: FND_MSG_PUB.Add;

540: THEN
541: -- NOTE change token name CATEGORY to generic name
542: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
543: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
544: FND_MSG_PUB.Add;
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: --

Line 550: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: --
549: -- Success message
550: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
551: THEN
552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
553: FND_MESSAGE.Set_Token('ROW', l_full_name);
554: FND_MSG_PUB.Add;

Line 554: FND_MSG_PUB.Add;

550: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
551: THEN
552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
553: FND_MESSAGE.Set_Token('ROW', l_full_name);
554: FND_MSG_PUB.Add;
555: END IF;
556: --Standard check of commit
557: IF FND_API.To_Boolean ( p_commit ) THEN
558: COMMIT WORK;

Line 561: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

557: IF FND_API.To_Boolean ( p_commit ) THEN
558: COMMIT WORK;
559: END IF;
560: -- Debug Message
561: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
562: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
563: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
564: FND_MSG_PUB.Add;
565: END IF;

Line 564: FND_MSG_PUB.Add;

560: -- Debug Message
561: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
562: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
563: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
564: FND_MSG_PUB.Add;
565: END IF;
566: --Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,

Line 567: FND_MSG_PUB.Count_And_Get (

563: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
564: FND_MSG_PUB.Add;
565: END IF;
566: --Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 577: FND_MSG_PUB.Count_And_Get (

573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO Add_Subscription_PVT;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );

Line 586: FND_MSG_PUB.Count_And_Get (

582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: ROLLBACK TO Add_Subscription_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );

Line 594: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

590: );
591: WHEN OTHERS THEN
592: ROLLBACK TO Add_Subscription_PVT;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
597: END IF;
598: -- Standard call to get message count and if count=1, get the message

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

592: ROLLBACK TO Add_Subscription_PVT;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
595: THEN
596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
597: END IF;
598: -- Standard call to get message count and if count=1, get the message
599: FND_MSG_PUB.Count_And_Get (
600: p_encoded => FND_API.G_FALSE,

Line 599: FND_MSG_PUB.Count_And_Get (

595: THEN
596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
597: END IF;
598: -- Standard call to get message count and if count=1, get the message
599: FND_MSG_PUB.Count_And_Get (
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_msg_count,
602: p_data => x_msg_data
603: );

Line 701: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

697: THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;
700: -- Debug Message
701: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
702: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
703: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
704: FND_MSG_PUB.Add;
705: END IF;

Line 704: FND_MSG_PUB.Add;

700: -- Debug Message
701: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
702: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
703: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
704: FND_MSG_PUB.Add;
705: END IF;
706: --Initialize message list if p_init_msg_list is TRUE.
707: IF FND_API.To_Boolean (p_init_msg_list) THEN
708: FND_MSG_PUB.initialize;

Line 708: FND_MSG_PUB.initialize;

704: FND_MSG_PUB.Add;
705: END IF;
706: --Initialize message list if p_init_msg_list is TRUE.
707: IF FND_API.To_Boolean (p_init_msg_list) THEN
708: FND_MSG_PUB.initialize;
709: END IF;
710: -- Get the current (login) user id.
711: AMV_UTILITY_PVT.Get_UserInfo(
712: x_resource_id => l_resource_id,

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

718: IF (p_check_login_user = FND_API.G_TRUE) THEN
719: -- Check if user is login and has the required privilege.
720: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
721: -- User is not login.
722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
723: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
724: FND_MSG_PUB.Add;
725: END IF;
726: RAISE FND_API.G_EXC_ERROR;

Line 724: FND_MSG_PUB.Add;

720: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
721: -- User is not login.
722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
723: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
724: FND_MSG_PUB.Add;
725: END IF;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: END IF;

Line 755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

751: x_error_msg => l_Error_Msg,
752: x_error_token => l_Error_Token
753: );
754: IF l_valid_flag = FND_API.G_FALSE THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
756: THEN
757: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
758: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
759: FND_MSG_PUB.Add;

Line 759: FND_MSG_PUB.Add;

755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
756: THEN
757: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
758: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
759: FND_MSG_PUB.Add;
760: END IF;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: -- set to local variables

Line 784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

780: WHERE my_channel_id = l_mychannel_id;
781: --
782:
783: -- Success message
784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
785: THEN
786: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
787: FND_MESSAGE.Set_Token('ROW', l_full_name);
788: FND_MSG_PUB.Add;

Line 788: FND_MSG_PUB.Add;

784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
785: THEN
786: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
787: FND_MESSAGE.Set_Token('ROW', l_full_name);
788: FND_MSG_PUB.Add;
789: END IF;
790: --Standard check of commit
791: IF FND_API.To_Boolean ( p_commit ) THEN
792: COMMIT WORK;

Line 795: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

791: IF FND_API.To_Boolean ( p_commit ) THEN
792: COMMIT WORK;
793: END IF;
794: -- Debug Message
795: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
796: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
797: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
798: FND_MSG_PUB.Add;
799: END IF;

Line 798: FND_MSG_PUB.Add;

794: -- Debug Message
795: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
796: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
797: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
798: FND_MSG_PUB.Add;
799: END IF;
800: --Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,

Line 801: FND_MSG_PUB.Count_And_Get (

797: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
798: FND_MSG_PUB.Add;
799: END IF;
800: --Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
805: );

Line 811: FND_MSG_PUB.Count_And_Get (

807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO Remove_Subscription_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );

Line 820: FND_MSG_PUB.Count_And_Get (

816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: ROLLBACK TO Remove_Subscription_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );

Line 828: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

824: );
825: WHEN OTHERS THEN
826: ROLLBACK TO Remove_Subscription_PVT;
827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
831: END IF;
832: -- Standard call to get message count and if count=1, get the message

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

826: ROLLBACK TO Remove_Subscription_PVT;
827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
829: THEN
830: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
831: END IF;
832: -- Standard call to get message count and if count=1, get the message
833: FND_MSG_PUB.Count_And_Get (
834: p_encoded => FND_API.G_FALSE,

Line 833: FND_MSG_PUB.Count_And_Get (

829: THEN
830: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
831: END IF;
832: -- Standard call to get message count and if count=1, get the message
833: FND_MSG_PUB.Count_And_Get (
834: p_encoded => FND_API.G_FALSE,
835: p_count => x_msg_count,
836: p_data => x_msg_data
837: );

Line 918: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

914: THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917: -- Debug Message
918: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
919: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
920: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
921: FND_MSG_PUB.Add;
922: END IF;

Line 921: FND_MSG_PUB.Add;

917: -- Debug Message
918: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
919: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
920: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
921: FND_MSG_PUB.Add;
922: END IF;
923: --Initialize message list if p_init_msg_list is TRUE.
924: IF FND_API.To_Boolean (p_init_msg_list) THEN
925: FND_MSG_PUB.initialize;

Line 925: FND_MSG_PUB.initialize;

921: FND_MSG_PUB.Add;
922: END IF;
923: --Initialize message list if p_init_msg_list is TRUE.
924: IF FND_API.To_Boolean (p_init_msg_list) THEN
925: FND_MSG_PUB.initialize;
926: END IF;
927: -- Get the current (login) user id.
928: AMV_UTILITY_PVT.Get_UserInfo(
929: x_resource_id => l_resource_id,

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

935: IF (p_check_login_user = FND_API.G_TRUE) THEN
936: -- Check if user is login and has the required privilege.
937: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
938: -- User is not login.
939: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
940: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
941: FND_MSG_PUB.Add;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;

Line 941: FND_MSG_PUB.Add;

937: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
938: -- User is not login.
939: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
940: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
941: FND_MSG_PUB.Add;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: END IF;

Line 973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

969: x_error_token => l_Error_Token
970: );
971: IF l_valid_flag = FND_API.G_TRUE THEN
972: IF l_mychannel_id = FND_API.G_MISS_NUM THEN
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
974: THEN
975: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_INVALID');
976: FND_MESSAGE.Set_Token('TKN',
977: p_mychannel_obj.subscribing_to_id);

Line 978: FND_MSG_PUB.Add;

974: THEN
975: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_INVALID');
976: FND_MESSAGE.Set_Token('TKN',
977: p_mychannel_obj.subscribing_to_id);
978: FND_MSG_PUB.Add;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
982: ELSE

Line 983: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
982: ELSE
983: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
984: THEN
985: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
986: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
987: FND_MSG_PUB.Add;

Line 987: FND_MSG_PUB.Add;

983: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
984: THEN
985: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
986: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
987: FND_MSG_PUB.Add;
988: END IF;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991: ELSE

Line 1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1032: WHERE my_channel_id = l_mychannel_id;
1033: --
1034:
1035: -- Success message
1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1037: THEN
1038: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1039: FND_MESSAGE.Set_Token('ROW',l_full_name) ;
1040: FND_MSG_PUB.Add;

Line 1040: FND_MSG_PUB.Add;

1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1037: THEN
1038: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1039: FND_MESSAGE.Set_Token('ROW',l_full_name) ;
1040: FND_MSG_PUB.Add;
1041: END IF;
1042: --Standard check of commit
1043: IF FND_API.To_Boolean ( p_commit ) THEN
1044: COMMIT WORK;

Line 1047: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1043: IF FND_API.To_Boolean ( p_commit ) THEN
1044: COMMIT WORK;
1045: END IF;
1046: -- Debug Message
1047: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1048: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1049: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1050: FND_MSG_PUB.Add;
1051: END IF;

Line 1050: FND_MSG_PUB.Add;

1046: -- Debug Message
1047: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1048: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1049: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1050: FND_MSG_PUB.Add;
1051: END IF;
1052: --Standard call to get message count and if count=1, get the message
1053: FND_MSG_PUB.Count_And_Get (
1054: p_encoded => FND_API.G_FALSE,

Line 1053: FND_MSG_PUB.Count_And_Get (

1049: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1050: FND_MSG_PUB.Add;
1051: END IF;
1052: --Standard call to get message count and if count=1, get the message
1053: FND_MSG_PUB.Count_And_Get (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );

Line 1063: FND_MSG_PUB.Count_And_Get (

1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK TO Update_MyChannel_PVT;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );

Line 1072: FND_MSG_PUB.Count_And_Get (

1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK TO Update_MyChannel_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: -- Standard call to get message count and if count=1, get the message
1072: FND_MSG_PUB.Count_And_Get (
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,
1075: p_data => x_msg_data
1076: );

Line 1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1076: );
1077: WHEN OTHERS THEN
1078: ROLLBACK TO Update_MyChannel_PVT;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message

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

1078: ROLLBACK TO Update_MyChannel_PVT;
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message
1085: FND_MSG_PUB.Count_And_Get (
1086: p_encoded => FND_API.G_FALSE,

Line 1085: FND_MSG_PUB.Count_And_Get (

1081: THEN
1082: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1083: END IF;
1084: -- Standard call to get message count and if count=1, get the message
1085: FND_MSG_PUB.Count_And_Get (
1086: p_encoded => FND_API.G_FALSE,
1087: p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );

Line 1212: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1208: THEN
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END IF;
1211: -- Debug Message
1212: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1213: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1214: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1215: FND_MSG_PUB.Add;
1216: END IF;

Line 1215: FND_MSG_PUB.Add;

1211: -- Debug Message
1212: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1213: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1214: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1215: FND_MSG_PUB.Add;
1216: END IF;
1217: --Initialize message list if p_init_msg_list is TRUE.
1218: IF FND_API.To_Boolean (p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;

Line 1219: FND_MSG_PUB.initialize;

1215: FND_MSG_PUB.Add;
1216: END IF;
1217: --Initialize message list if p_init_msg_list is TRUE.
1218: IF FND_API.To_Boolean (p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221: -- Get the current (login) user id.
1222: AMV_UTILITY_PVT.Get_UserInfo(
1223: x_resource_id => l_resource_id,

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

1229: IF (p_check_login_user = FND_API.G_TRUE) THEN
1230: -- Check if user is login and has the required privilege.
1231: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1232: -- User is not login.
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1235: FND_MSG_PUB.Add;
1236: END IF;
1237: RAISE FND_API.G_EXC_ERROR;

Line 1235: FND_MSG_PUB.Add;

1231: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1232: -- User is not login.
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1235: FND_MSG_PUB.Add;
1236: END IF;
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239: END IF;

Line 1324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1320: END LOOP;
1321: CLOSE My_Channels;
1322:
1323: ELSE
1324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');
1327: FND_MESSAGE.Set_Token('TKN',p_user_id);
1328: FND_MSG_PUB.Add;

Line 1328: FND_MSG_PUB.Add;

1324: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');
1327: FND_MESSAGE.Set_Token('TKN',p_user_id);
1328: FND_MSG_PUB.Add;
1329: END IF;
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332: --

Line 1335: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1331: END IF;
1332: --
1333:
1334: -- Debug Message
1335: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1336: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1337: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1338: FND_MSG_PUB.Add;
1339: END IF;

Line 1338: FND_MSG_PUB.Add;

1334: -- Debug Message
1335: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1336: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1337: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1338: FND_MSG_PUB.Add;
1339: END IF;
1340: --Standard call to get message count and if count=1, get the message
1341: FND_MSG_PUB.Count_And_Get (
1342: p_encoded => FND_API.G_FALSE,

Line 1341: FND_MSG_PUB.Count_And_Get (

1337: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1338: FND_MSG_PUB.Add;
1339: END IF;
1340: --Standard call to get message count and if count=1, get the message
1341: FND_MSG_PUB.Count_And_Get (
1342: p_encoded => FND_API.G_FALSE,
1343: p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );

Line 1351: FND_MSG_PUB.Count_And_Get (

1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO Get_MyChannels_PVT;
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: -- Standard call to get message count and if count=1, get the message
1351: FND_MSG_PUB.Count_And_Get (
1352: p_encoded => FND_API.G_FALSE,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data
1355: );

Line 1360: FND_MSG_PUB.Count_And_Get (

1356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1357: ROLLBACK TO Get_MyChannels_PVT;
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: -- Standard call to get message count and if count=1, get the message
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => x_msg_count,
1363: p_data => x_msg_data
1364: );

Line 1368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1364: );
1365: WHEN OTHERS THEN
1366: ROLLBACK TO Get_MyChannels_PVT;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1369: THEN
1370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1371: END IF;
1372: -- Standard call to get message count and if count=1, get the message

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

1366: ROLLBACK TO Get_MyChannels_PVT;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1369: THEN
1370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1371: END IF;
1372: -- Standard call to get message count and if count=1, get the message
1373: FND_MSG_PUB.Count_And_Get (
1374: p_encoded => FND_API.G_FALSE,

Line 1373: FND_MSG_PUB.Count_And_Get (

1369: THEN
1370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1371: END IF;
1372: -- Standard call to get message count and if count=1, get the message
1373: FND_MSG_PUB.Count_And_Get (
1374: p_encoded => FND_API.G_FALSE,
1375: p_count => x_msg_count,
1376: p_data => x_msg_data
1377: );

Line 1463: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1459: THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462: -- Debug Message
1463: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1464: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1465: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1466: FND_MSG_PUB.Add;
1467: END IF;

Line 1466: FND_MSG_PUB.Add;

1462: -- Debug Message
1463: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1464: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1465: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1466: FND_MSG_PUB.Add;
1467: END IF;
1468: --Initialize message list if p_init_msg_list is TRUE.
1469: IF FND_API.To_Boolean (p_init_msg_list) THEN
1470: FND_MSG_PUB.initialize;

Line 1470: FND_MSG_PUB.initialize;

1466: FND_MSG_PUB.Add;
1467: END IF;
1468: --Initialize message list if p_init_msg_list is TRUE.
1469: IF FND_API.To_Boolean (p_init_msg_list) THEN
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472: -- Get the current (login) user id.
1473: AMV_UTILITY_PVT.Get_UserInfo(
1474: x_resource_id => l_resource_id,

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

1480: IF (p_check_login_user = FND_API.G_TRUE) THEN
1481: -- Check if user is login and has the required privilege.
1482: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1483: -- User is not login.
1484: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1485: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1486: FND_MSG_PUB.Add;
1487: END IF;
1488: RAISE FND_API.G_EXC_ERROR;

Line 1486: FND_MSG_PUB.Add;

1482: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1483: -- User is not login.
1484: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1485: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1486: FND_MSG_PUB.Add;
1487: END IF;
1488: RAISE FND_API.G_EXC_ERROR;
1489: END IF;
1490: END IF;

Line 1514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1510: CLOSE Get_CategoryChannels;
1511: --
1512:
1513: -- Debug Message
1514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1515: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1516: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1517: FND_MSG_PUB.Add;
1518: END IF;

Line 1517: FND_MSG_PUB.Add;

1513: -- Debug Message
1514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1515: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1516: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1517: FND_MSG_PUB.Add;
1518: END IF;
1519: --Standard call to get message count and if count=1, get the message
1520: FND_MSG_PUB.Count_And_Get (
1521: p_encoded => FND_API.G_FALSE,

Line 1520: FND_MSG_PUB.Count_And_Get (

1516: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1517: FND_MSG_PUB.Add;
1518: END IF;
1519: --Standard call to get message count and if count=1, get the message
1520: FND_MSG_PUB.Count_And_Get (
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data
1524: );

Line 1530: FND_MSG_PUB.Count_And_Get (

1526: WHEN FND_API.G_EXC_ERROR THEN
1527: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: -- Standard call to get message count and if count=1, get the message
1530: FND_MSG_PUB.Count_And_Get (
1531: p_encoded => FND_API.G_FALSE,
1532: p_count => x_msg_count,
1533: p_data => x_msg_data
1534: );

Line 1539: FND_MSG_PUB.Count_And_Get (

1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1538: -- Standard call to get message count and if count=1, get the message
1539: FND_MSG_PUB.Count_And_Get (
1540: p_encoded => FND_API.G_FALSE,
1541: p_count => x_msg_count,
1542: p_data => x_msg_data
1543: );

Line 1547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1543: );
1544: WHEN OTHERS THEN
1545: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1548: THEN
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1550: END IF;
1551: -- Standard call to get message count and if count=1, get the message

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

1545: ROLLBACK TO Get_MyChannelsPerCategory_PVT;
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1548: THEN
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1550: END IF;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,

Line 1552: FND_MSG_PUB.Count_And_Get (

1548: THEN
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1550: END IF;
1551: -- Standard call to get message count and if count=1, get the message
1552: FND_MSG_PUB.Count_And_Get (
1553: p_encoded => FND_API.G_FALSE,
1554: p_count => x_msg_count,
1555: p_data => x_msg_data
1556: );

Line 1714: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1710: THEN
1711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1712: END IF;
1713: -- Debug Message
1714: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1715: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1716: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1717: FND_MSG_PUB.Add;
1718: END IF;

Line 1717: FND_MSG_PUB.Add;

1713: -- Debug Message
1714: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1715: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1716: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1717: FND_MSG_PUB.Add;
1718: END IF;
1719: --Initialize message list if p_init_msg_list is TRUE.
1720: IF FND_API.To_Boolean (p_init_msg_list) THEN
1721: FND_MSG_PUB.initialize;

Line 1721: FND_MSG_PUB.initialize;

1717: FND_MSG_PUB.Add;
1718: END IF;
1719: --Initialize message list if p_init_msg_list is TRUE.
1720: IF FND_API.To_Boolean (p_init_msg_list) THEN
1721: FND_MSG_PUB.initialize;
1722: END IF;
1723: -- Get the current (login) user id.
1724: AMV_UTILITY_PVT.Get_UserInfo(
1725: x_resource_id => l_resource_id,

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

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

Line 1737: FND_MSG_PUB.Add;

1733: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1734: -- User is not login.
1735: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1736: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1737: FND_MSG_PUB.Add;
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741: END IF;

Line 1762: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1758: THEN
1759: IF p_user_name is not null THEN
1760: l_recipient_role := p_user_name;
1761: ELSE
1762: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1763: THEN
1764: FND_MESSAGE.Set_Name('AMV', 'AMV_NOTIF_NO_VALS');
1765: FND_MSG_PUB.Add;
1766: END IF;

Line 1765: FND_MSG_PUB.Add;

1761: ELSE
1762: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1763: THEN
1764: FND_MESSAGE.Set_Name('AMV', 'AMV_NOTIF_NO_VALS');
1765: FND_MSG_PUB.Add;
1766: END IF;
1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;
1769: ELSE

Line 1774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1770: OPEN Get_ResourceUserName;
1771: FETCH Get_ResourceUserName INTO l_recipient_role;
1772: CLOSE Get_ResourceUserName;
1773: IF l_recipient_role is null THEN
1774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1775: THEN
1776: -- NOTE change token name CATEGORY to generic name
1777: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');
1778: FND_MESSAGE.Set_Token('TKN',p_resource_id);

Line 1779: FND_MSG_PUB.Add;

1775: THEN
1776: -- NOTE change token name CATEGORY to generic name
1777: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');
1778: FND_MESSAGE.Set_Token('TKN',p_resource_id);
1779: FND_MSG_PUB.Add;
1780: END IF;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: END IF;

Line 1789: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1785: OPEN Get_FndUserName;
1786: FETCH Get_FndUserName INTO l_recipient_role;
1787: CLOSE Get_FndUserName;
1788: IF l_recipient_role is null THEN
1789: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1790: THEN
1791: -- NOTE change token name CATEGORY to generic name
1792: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_USER_ID');
1793: FND_MESSAGE.Set_Token('TKN',p_user_id);

Line 1794: FND_MSG_PUB.Add;

1790: THEN
1791: -- NOTE change token name CATEGORY to generic name
1792: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_USER_ID');
1793: FND_MESSAGE.Set_Token('TKN',p_user_id);
1794: FND_MSG_PUB.Add;
1795: END IF;
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798: END IF;

Line 1887: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1883: --
1884: --
1885:
1886: -- Debug Message
1887: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1888: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1889: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1890: FND_MSG_PUB.Add;
1891: END IF;

Line 1890: FND_MSG_PUB.Add;

1886: -- Debug Message
1887: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1888: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1889: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1890: FND_MSG_PUB.Add;
1891: END IF;
1892: --Standard call to get message count and if count=1, get the message
1893: FND_MSG_PUB.Count_And_Get (
1894: p_encoded => FND_API.G_FALSE,

Line 1893: FND_MSG_PUB.Count_And_Get (

1889: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1890: FND_MSG_PUB.Add;
1891: END IF;
1892: --Standard call to get message count and if count=1, get the message
1893: FND_MSG_PUB.Count_And_Get (
1894: p_encoded => FND_API.G_FALSE,
1895: p_count => x_msg_count,
1896: p_data => x_msg_data
1897: );

Line 1903: FND_MSG_PUB.Count_And_Get (

1899: WHEN FND_API.G_EXC_ERROR THEN
1900: ROLLBACK TO Get_MyNotifications;
1901: x_return_status := FND_API.G_RET_STS_ERROR;
1902: -- Standard call to get message count and if count=1, get the message
1903: FND_MSG_PUB.Count_And_Get (
1904: p_encoded => FND_API.G_FALSE,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );

Line 1912: FND_MSG_PUB.Count_And_Get (

1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO Get_MyNotifications;
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1911: -- Standard call to get message count and if count=1, get the message
1912: FND_MSG_PUB.Count_And_Get (
1913: p_encoded => FND_API.G_FALSE,
1914: p_count => x_msg_count,
1915: p_data => x_msg_data
1916: );

Line 1920: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

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

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

Line 1925: FND_MSG_PUB.Count_And_Get (

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

Line 2093: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2089: THEN
2090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2091: END IF;
2092: -- Debug Message
2093: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2094: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2095: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2096: FND_MSG_PUB.Add;
2097: END IF;

Line 2096: FND_MSG_PUB.Add;

2092: -- Debug Message
2093: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2094: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2095: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2096: FND_MSG_PUB.Add;
2097: END IF;
2098: --Initialize message list if p_init_msg_list is TRUE.
2099: IF FND_API.To_Boolean (p_init_msg_list) THEN
2100: FND_MSG_PUB.initialize;

Line 2100: FND_MSG_PUB.initialize;

2096: FND_MSG_PUB.Add;
2097: END IF;
2098: --Initialize message list if p_init_msg_list is TRUE.
2099: IF FND_API.To_Boolean (p_init_msg_list) THEN
2100: FND_MSG_PUB.initialize;
2101: END IF;
2102: -- Get the current (login) user id.
2103: AMV_UTILITY_PVT.Get_UserInfo(
2104: x_resource_id => l_resource_id,

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

2110: IF (p_check_login_user = FND_API.G_TRUE) THEN
2111: -- Check if user is login and has the required privilege.
2112: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2113: -- User is not login.
2114: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2115: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2116: FND_MSG_PUB.Add;
2117: END IF;
2118: RAISE FND_API.G_EXC_ERROR;

Line 2116: FND_MSG_PUB.Add;

2112: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2113: -- User is not login.
2114: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2115: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2116: FND_MSG_PUB.Add;
2117: END IF;
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120: END IF;

Line 2181: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2177: */
2178: --
2179:
2180: -- Debug Message
2181: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2182: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2183: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2184: FND_MSG_PUB.Add;
2185: END IF;

Line 2184: FND_MSG_PUB.Add;

2180: -- Debug Message
2181: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2182: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2183: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2184: FND_MSG_PUB.Add;
2185: END IF;
2186: --Standard call to get message count and if count=1, get the message
2187: FND_MSG_PUB.Count_And_Get (
2188: p_encoded => FND_API.G_FALSE,

Line 2187: FND_MSG_PUB.Count_And_Get (

2183: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2184: FND_MSG_PUB.Add;
2185: END IF;
2186: --Standard call to get message count and if count=1, get the message
2187: FND_MSG_PUB.Count_And_Get (
2188: p_encoded => FND_API.G_FALSE,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data
2191: );

Line 2197: FND_MSG_PUB.Count_And_Get (

2193: WHEN FND_API.G_EXC_ERROR THEN
2194: ROLLBACK TO Get_ItemsPerUser;
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: -- Standard call to get message count and if count=1, get the message
2197: FND_MSG_PUB.Count_And_Get (
2198: p_encoded => FND_API.G_FALSE,
2199: p_count => x_msg_count,
2200: p_data => x_msg_data
2201: );

Line 2206: FND_MSG_PUB.Count_And_Get (

2202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2203: ROLLBACK TO Get_ItemsPerUser;
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205: -- Standard call to get message count and if count=1, get the message
2206: FND_MSG_PUB.Count_And_Get (
2207: p_encoded => FND_API.G_FALSE,
2208: p_count => x_msg_count,
2209: p_data => x_msg_data
2210: );

Line 2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2210: );
2211: WHEN OTHERS THEN
2212: ROLLBACK TO Get_ItemsPerUser;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message

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

2212: ROLLBACK TO Get_ItemsPerUser;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2219: FND_MSG_PUB.Count_And_Get (
2220: p_encoded => FND_API.G_FALSE,

Line 2219: FND_MSG_PUB.Count_And_Get (

2215: THEN
2216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2217: END IF;
2218: -- Standard call to get message count and if count=1, get the message
2219: FND_MSG_PUB.Count_And_Get (
2220: p_encoded => FND_API.G_FALSE,
2221: p_count => x_msg_count,
2222: p_data => x_msg_data
2223: );

Line 2324: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2320: THEN
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323: -- Debug Message
2324: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2325: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2326: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2327: FND_MSG_PUB.Add;
2328: END IF;

Line 2327: FND_MSG_PUB.Add;

2323: -- Debug Message
2324: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2325: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2326: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2327: FND_MSG_PUB.Add;
2328: END IF;
2329: --Initialize message list if p_init_msg_list is TRUE.
2330: IF FND_API.To_Boolean (p_init_msg_list) THEN
2331: FND_MSG_PUB.initialize;

Line 2331: FND_MSG_PUB.initialize;

2327: FND_MSG_PUB.Add;
2328: END IF;
2329: --Initialize message list if p_init_msg_list is TRUE.
2330: IF FND_API.To_Boolean (p_init_msg_list) THEN
2331: FND_MSG_PUB.initialize;
2332: END IF;
2333: -- Get the current (login) user id.
2334: AMV_UTILITY_PVT.Get_UserInfo(
2335: x_resource_id => l_resource_id,

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

2341: IF (p_check_login_user = FND_API.G_TRUE) THEN
2342: -- Check if user is login and has the required privilege.
2343: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2344: -- User is not login.
2345: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2346: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2347: FND_MSG_PUB.Add;
2348: END IF;
2349: RAISE FND_API.G_EXC_ERROR;

Line 2347: FND_MSG_PUB.Add;

2343: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2344: -- User is not login.
2345: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2346: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2347: FND_MSG_PUB.Add;
2348: END IF;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2351: END IF;

Line 2399: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2395: x_return_obj.total_record_count := l_total_count;
2396: --
2397:
2398: -- Debug Message
2399: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2400: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2401: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2402: FND_MSG_PUB.Add;
2403: END IF;

Line 2402: FND_MSG_PUB.Add;

2398: -- Debug Message
2399: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2400: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2401: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2402: FND_MSG_PUB.Add;
2403: END IF;
2404: --Standard call to get message count and if count=1, get the message
2405: FND_MSG_PUB.Count_And_Get (
2406: p_encoded => FND_API.G_FALSE,

Line 2405: FND_MSG_PUB.Count_And_Get (

2401: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2402: FND_MSG_PUB.Add;
2403: END IF;
2404: --Standard call to get message count and if count=1, get the message
2405: FND_MSG_PUB.Count_And_Get (
2406: p_encoded => FND_API.G_FALSE,
2407: p_count => x_msg_count,
2408: p_data => x_msg_data
2409: );

Line 2415: FND_MSG_PUB.Count_And_Get (

2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO Get_UserItems;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data
2419: );

Line 2424: FND_MSG_PUB.Count_And_Get (

2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: ROLLBACK TO Get_UserItems;
2422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2423: -- Standard call to get message count and if count=1, get the message
2424: FND_MSG_PUB.Count_And_Get (
2425: p_encoded => FND_API.G_FALSE,
2426: p_count => x_msg_count,
2427: p_data => x_msg_data
2428: );

Line 2432: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2428: );
2429: WHEN OTHERS THEN
2430: ROLLBACK TO Get_UserItems;
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2432: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2435: END IF;
2436: -- Standard call to get message count and if count=1, get the message

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

2430: ROLLBACK TO Get_UserItems;
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2432: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2435: END IF;
2436: -- Standard call to get message count and if count=1, get the message
2437: FND_MSG_PUB.Count_And_Get (
2438: p_encoded => FND_API.G_FALSE,

Line 2437: FND_MSG_PUB.Count_And_Get (

2433: THEN
2434: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2435: END IF;
2436: -- Standard call to get message count and if count=1, get the message
2437: FND_MSG_PUB.Count_And_Get (
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,
2440: p_data => x_msg_data
2441: );

Line 2528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2524: THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: END IF;
2527: -- Debug Message
2528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2531: FND_MSG_PUB.Add;
2532: END IF;

Line 2531: FND_MSG_PUB.Add;

2527: -- Debug Message
2528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2531: FND_MSG_PUB.Add;
2532: END IF;
2533: --Initialize message list if p_init_msg_list is TRUE.
2534: IF FND_API.To_Boolean (p_init_msg_list) THEN
2535: FND_MSG_PUB.initialize;

Line 2535: FND_MSG_PUB.initialize;

2531: FND_MSG_PUB.Add;
2532: END IF;
2533: --Initialize message list if p_init_msg_list is TRUE.
2534: IF FND_API.To_Boolean (p_init_msg_list) THEN
2535: FND_MSG_PUB.initialize;
2536: END IF;
2537: -- Get the current (login) user id.
2538: AMV_UTILITY_PVT.Get_UserInfo(
2539: x_resource_id => l_resource_id,

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

2545: IF (p_check_login_user = FND_API.G_TRUE) THEN
2546: -- Check if user is login and has the required privilege.
2547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2548: -- User is not login.
2549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2551: FND_MSG_PUB.Add;
2552: END IF;
2553: RAISE FND_API.G_EXC_ERROR;

Line 2551: FND_MSG_PUB.Add;

2547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2548: -- User is not login.
2549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2551: FND_MSG_PUB.Add;
2552: END IF;
2553: RAISE FND_API.G_EXC_ERROR;
2554: END IF;
2555: END IF;

Line 2586: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2582: END IF;
2583: --
2584:
2585: -- Debug Message
2586: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2587: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2588: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2589: FND_MSG_PUB.Add;
2590: END IF;

Line 2589: FND_MSG_PUB.Add;

2585: -- Debug Message
2586: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2587: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2588: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2589: FND_MSG_PUB.Add;
2590: END IF;
2591: --Standard call to get message count and if count=1, get the message
2592: FND_MSG_PUB.Count_And_Get (
2593: p_encoded => FND_API.G_FALSE,

Line 2592: FND_MSG_PUB.Count_And_Get (

2588: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2589: FND_MSG_PUB.Add;
2590: END IF;
2591: --Standard call to get message count and if count=1, get the message
2592: FND_MSG_PUB.Count_And_Get (
2593: p_encoded => FND_API.G_FALSE,
2594: p_count => x_msg_count,
2595: p_data => x_msg_data
2596: );

Line 2601: FND_MSG_PUB.Count_And_Get (

2597: EXCEPTION
2598: WHEN FND_API.G_EXC_ERROR THEN
2599: x_return_status := FND_API.G_RET_STS_ERROR;
2600: -- Standard call to get message count and if count=1, get the message
2601: FND_MSG_PUB.Count_And_Get (
2602: p_encoded => FND_API.G_FALSE,
2603: p_count => x_msg_count,
2604: p_data => x_msg_data
2605: );

Line 2609: FND_MSG_PUB.Count_And_Get (

2605: );
2606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: -- Standard call to get message count and if count=1, get the message
2609: FND_MSG_PUB.Count_And_Get (
2610: p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );

Line 2616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2612: p_data => x_msg_data
2613: );
2614: WHEN OTHERS THEN
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2619: END IF;
2620: -- Standard call to get message count and if count=1, get the message

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

2614: WHEN OTHERS THEN
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2619: END IF;
2620: -- Standard call to get message count and if count=1, get the message
2621: FND_MSG_PUB.Count_And_Get (
2622: p_encoded => FND_API.G_FALSE,

Line 2621: FND_MSG_PUB.Count_And_Get (

2617: THEN
2618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2619: END IF;
2620: -- Standard call to get message count and if count=1, get the message
2621: FND_MSG_PUB.Count_And_Get (
2622: p_encoded => FND_API.G_FALSE,
2623: p_count => x_msg_count,
2624: p_data => x_msg_data
2625: );