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_MESSAGE

Line 219: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
223: --Initialize message list if p_init_msg_list is TRUE.

Line 220: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
223: --Initialize message list if p_init_msg_list is TRUE.
224: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

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

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

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

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;
264: END IF;
265: RAISE FND_API.G_EXC_ERROR;

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

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;
264: END IF;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;

Line 280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

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;
283: END IF;
284: -- Standard check of commit

Line 281: FND_MESSAGE.Set_Token('ROW', l_full_name);

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;
283: END IF;
284: -- Standard check of commit
285: IF FND_API.To_Boolean ( p_commit ) THEN

Line 290: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
294: --Standard call to get message count and if count=1, get the message

Line 291: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
294: --Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (

Line 423: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
427: --Initialize message list if p_init_msg_list is TRUE.

Line 424: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
427: --Initialize message list if p_init_msg_list is TRUE.
428: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 479: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_EXISTS');

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;
482: END IF;
483: RAISE FND_API.G_EXC_ERROR;

Line 480: FND_MESSAGE.Set_Token('TKN',p_mychannel_obj.user_or_group_type);

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;
482: END IF;
483: RAISE FND_API.G_EXC_ERROR;
484: ELSE

Line 542: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

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);
544: FND_MSG_PUB.Add;
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;

Line 543: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

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);
544: FND_MSG_PUB.Add;
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;

Line 552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

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;
555: END IF;
556: --Standard check of commit

Line 553: FND_MESSAGE.Set_Token('ROW', l_full_name);

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;
555: END IF;
556: --Standard check of commit
557: IF FND_API.To_Boolean ( p_commit ) THEN

Line 562: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
566: --Standard call to get message count and if count=1, get the message

Line 563: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
566: --Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (

Line 702: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
706: --Initialize message list if p_init_msg_list is TRUE.

Line 703: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
706: --Initialize message list if p_init_msg_list is TRUE.
707: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 757: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

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;
760: END IF;
761: RAISE FND_API.G_EXC_ERROR;

Line 758: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

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;
760: END IF;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;

Line 786: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

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;
789: END IF;
790: --Standard check of commit

Line 787: FND_MESSAGE.Set_Token('ROW', l_full_name);

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;
789: END IF;
790: --Standard check of commit
791: IF FND_API.To_Boolean ( p_commit ) THEN

Line 796: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
800: --Standard call to get message count and if count=1, get the message

Line 797: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
800: --Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (

Line 919: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
923: --Initialize message list if p_init_msg_list is TRUE.

Line 920: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
923: --Initialize message list if p_init_msg_list is TRUE.
924: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 975: FND_MESSAGE.Set_Name('AMV', 'AMV_SUBSCRIPTION_INVALID');

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);
978: FND_MSG_PUB.Add;
979: END IF;

Line 976: FND_MESSAGE.Set_Token('TKN',

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);
978: FND_MSG_PUB.Add;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;

Line 985: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);

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;
988: END IF;
989: RAISE FND_API.G_EXC_ERROR;

Line 986: FND_MESSAGE.Set_Token('TKN',l_Error_Token);

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;
988: END IF;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;

Line 1038: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');

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;
1041: END IF;
1042: --Standard check of commit

Line 1039: FND_MESSAGE.Set_Token('ROW',l_full_name) ;

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;
1041: END IF;
1042: --Standard check of commit
1043: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1048: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1052: --Standard call to get message count and if count=1, get the message

Line 1049: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
1052: --Standard call to get message count and if count=1, get the message
1053: FND_MSG_PUB.Count_And_Get (

Line 1213: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1217: --Initialize message list if p_init_msg_list is TRUE.

Line 1214: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
1217: --Initialize message list if p_init_msg_list is TRUE.
1218: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 1326: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');

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;
1329: END IF;
1330: RAISE FND_API.G_EXC_ERROR;

Line 1327: FND_MESSAGE.Set_Token('TKN',p_user_id);

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;
1329: END IF;
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;

Line 1336: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1340: --Standard call to get message count and if count=1, get the message

Line 1337: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
1340: --Standard call to get message count and if count=1, get the message
1341: FND_MSG_PUB.Count_And_Get (

Line 1464: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1468: --Initialize message list if p_init_msg_list is TRUE.

Line 1465: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
1468: --Initialize message list if p_init_msg_list is TRUE.
1469: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 1515: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1519: --Standard call to get message count and if count=1, get the message

Line 1516: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
1519: --Standard call to get message count and if count=1, get the message
1520: FND_MSG_PUB.Count_And_Get (

Line 1715: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1719: --Initialize message list if p_init_msg_list is TRUE.

Line 1716: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
1719: --Initialize message list if p_init_msg_list is TRUE.
1720: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 1764: FND_MESSAGE.Set_Name('AMV', 'AMV_NOTIF_NO_VALS');

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;
1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;

Line 1777: FND_MESSAGE.Set_Name('AMV', 'AMV_RESOURCE_ID_INVALID');

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);
1779: FND_MSG_PUB.Add;
1780: END IF;
1781: RAISE FND_API.G_EXC_ERROR;

Line 1778: FND_MESSAGE.Set_Token('TKN',p_resource_id);

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);
1779: FND_MSG_PUB.Add;
1780: END IF;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;

Line 1792: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_USER_ID');

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);
1794: FND_MSG_PUB.Add;
1795: END IF;
1796: RAISE FND_API.G_EXC_ERROR;

Line 1793: FND_MESSAGE.Set_Token('TKN',p_user_id);

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);
1794: FND_MSG_PUB.Add;
1795: END IF;
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;

Line 1888: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
1892: --Standard call to get message count and if count=1, get the message

Line 1889: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
1892: --Standard call to get message count and if count=1, get the message
1893: FND_MSG_PUB.Count_And_Get (

Line 2094: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2098: --Initialize message list if p_init_msg_list is TRUE.

Line 2095: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
2098: --Initialize message list if p_init_msg_list is TRUE.
2099: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 2182: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2186: --Standard call to get message count and if count=1, get the message

Line 2183: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
2186: --Standard call to get message count and if count=1, get the message
2187: FND_MSG_PUB.Count_And_Get (

Line 2325: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2329: --Initialize message list if p_init_msg_list is TRUE.

Line 2326: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
2329: --Initialize message list if p_init_msg_list is TRUE.
2330: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 2400: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2404: --Standard call to get message count and if count=1, get the message

Line 2401: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
2404: --Standard call to get message count and if count=1, get the message
2405: FND_MSG_PUB.Count_And_Get (

Line 2529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2533: --Initialize message list if p_init_msg_list is TRUE.

Line 2530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');

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;
2533: --Initialize message list if p_init_msg_list is TRUE.
2534: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

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

Line 2587: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');

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;
2591: --Standard call to get message count and if count=1, get the message

Line 2588: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');

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;
2591: --Standard call to get message count and if count=1, get the message
2592: FND_MSG_PUB.Count_And_Get (