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_USER_PVT dependencies on FND_MSG_PUB

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

314: EXCEPTION
315: WHEN OTHERS THEN
316: ROLLBACK TO Add_Access_helper_PVT;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
320: END IF;
321: END Add_Access_helper;
322: --------------------------------------------------------------------------------

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

315: WHEN OTHERS THEN
316: ROLLBACK TO Add_Access_helper_PVT;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
320: END IF;
321: END Add_Access_helper;
322: --------------------------------------------------------------------------------
323: PROCEDURE Update_Access_helper

Line 395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

391: l_access_obj.chl_required_need_notif_flag)
392: where access_id = l_access_obj.access_id
393: ;--and object_version_number = l_access_obj.access_id.object_version_number;
394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_ACCESS_ID');
397: FND_MESSAGE.Set_Token('ACCESS_ID', TO_CHAR(l_access_obj.access_id) );
398: FND_MSG_PUB.add;
399: END IF;

Line 398: FND_MSG_PUB.add;

394: IF (SQL%NOTFOUND) THEN
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
396: FND_MESSAGE.Set_Name('AMV', 'AMV_INVALID_ACCESS_ID');
397: FND_MESSAGE.Set_Token('ACCESS_ID', TO_CHAR(l_access_obj.access_id) );
398: FND_MSG_PUB.add;
399: END IF;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

403: EXCEPTION
404: WHEN OTHERS THEN
405: ROLLBACK TO Update_Access_helper_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
409: END IF;
410: END Update_Access_helper;
411: --------------------------------------------------------------------------------

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

404: WHEN OTHERS THEN
405: ROLLBACK TO Update_Access_helper_PVT;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
409: END IF;
410: END Update_Access_helper;
411: --------------------------------------------------------------------------------
412: --------------------------------------------------------------------------------

Line 443: FND_MSG_PUB.initialize;

439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: --Initialize message list if p_init_msg_list is TRUE.
442: IF FND_API.To_Boolean (p_init_msg_list) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445: -- Initialize API return status to success
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447: -- Get the current (login) user id.

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

454: IF (p_check_login_user = FND_API.G_TRUE) THEN
455: -- Check if user is login and has the required privilege.
456: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
457: -- User is not login.
458: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
459: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
460: FND_MSG_PUB.Add;
461: END IF;
462: RAISE FND_API.G_EXC_ERROR;

Line 460: FND_MSG_PUB.Add;

456: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
457: -- User is not login.
458: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
459: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
460: FND_MSG_PUB.Add;
461: END IF;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464: END IF;

Line 475: FND_MSG_PUB.Count_And_Get (

471: x_resource_id => x_resource_id
472: );
473: END IF;
474: --Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
479: );

Line 484: FND_MSG_PUB.Count_And_Get (

480: EXCEPTION
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );

Line 492: FND_MSG_PUB.Count_And_Get (

488: );
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: -- Standard call to get message count and if count=1, get the message
492: FND_MSG_PUB.Count_And_Get (
493: p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );

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

495: p_data => x_msg_data
496: );
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
500: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
501: END IF;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (

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

496: );
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
500: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
501: END IF;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,

Line 503: FND_MSG_PUB.Count_And_Get (

499: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
500: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
501: END IF;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );

Line 563: FND_MSG_PUB.initialize;

559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561: --Initialize message list if p_init_msg_list is TRUE.
562: IF FND_API.To_Boolean (p_init_msg_list) THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565: -- Initialize API return status to success
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567: -- Get the current (login) user id.

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

574: IF (p_check_login_user = FND_API.G_TRUE) THEN
575: -- Check if user is login and has the required privilege.
576: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
577: -- User is not login.
578: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
579: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
580: FND_MSG_PUB.Add;
581: END IF;
582: RAISE FND_API.G_EXC_ERROR;

Line 580: FND_MSG_PUB.Add;

576: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
577: -- User is not login.
578: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
579: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
580: FND_MSG_PUB.Add;
581: END IF;
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584: END IF;

Line 710: FND_MSG_PUB.Count_And_Get (

706: l_total_record_count
707: );
708: */
709: --Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );

Line 719: FND_MSG_PUB.Count_And_Get (

715: EXCEPTION
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: -- Standard call to get message count and if count=1, get the message
719: FND_MSG_PUB.Count_And_Get (
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_msg_count,
722: p_data => x_msg_data
723: );

Line 727: FND_MSG_PUB.Count_And_Get (

723: );
724: WHEN FND_API.G_EXC_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: -- Standard call to get message count and if count=1, get the message
727: FND_MSG_PUB.Count_And_Get (
728: p_encoded => FND_API.G_FALSE,
729: p_count => x_msg_count,
730: p_data => x_msg_data
731: );

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

730: p_data => x_msg_data
731: );
732: WHEN OTHERS THEN
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
736: END IF;
737: -- Standard call to get message count and if count=1, get the message
738: FND_MSG_PUB.Count_And_Get (

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

731: );
732: WHEN OTHERS THEN
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
736: END IF;
737: -- Standard call to get message count and if count=1, get the message
738: FND_MSG_PUB.Count_And_Get (
739: p_encoded => FND_API.G_FALSE,

Line 738: FND_MSG_PUB.Count_And_Get (

734: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
736: END IF;
737: -- Standard call to get message count and if count=1, get the message
738: FND_MSG_PUB.Count_And_Get (
739: p_encoded => FND_API.G_FALSE,
740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );

Line 797: FND_MSG_PUB.initialize;

793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795: --Initialize message list if p_init_msg_list is TRUE.
796: IF FND_API.To_Boolean (p_init_msg_list) THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799: -- Initialize API return status to success
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801: -- Get the current (login) user id.

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

808: IF (p_check_login_user = FND_API.G_TRUE) THEN
809: -- Check if user is login and has the required privilege.
810: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
811: -- User is not login.
812: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;

Line 814: FND_MSG_PUB.Add;

810: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
811: -- User is not login.
812: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818: END IF;

Line 929: FND_MSG_PUB.Count_And_Get (

925: l_total_record_count
926: );
927: */
928: --Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );

Line 939: FND_MSG_PUB.Count_And_Get (

935: EXCEPTION
936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: -- Standard call to get message count and if count=1, get the message
939: FND_MSG_PUB.Count_And_Get (
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data
943: );

Line 947: FND_MSG_PUB.Count_And_Get (

943: );
944: WHEN FND_API.G_EXC_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: -- Standard call to get message count and if count=1, get the message
947: FND_MSG_PUB.Count_And_Get (
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );

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

950: p_data => x_msg_data
951: );
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
956: END IF;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (

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

951: );
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
956: END IF;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,

Line 958: FND_MSG_PUB.Count_And_Get (

954: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
956: END IF;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data
962: );

Line 1016: FND_MSG_PUB.initialize;

1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014: --Initialize message list if p_init_msg_list is TRUE.
1015: IF FND_API.To_Boolean (p_init_msg_list) THEN
1016: FND_MSG_PUB.initialize;
1017: END IF;
1018: -- Initialize API return status to success
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;
1020: -- Get the current (login) user id.

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

1027: IF (p_check_login_user = FND_API.G_TRUE) THEN
1028: -- Check if user is login and has the required privilege.
1029: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1030: -- User is not login.
1031: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1032: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1033: FND_MSG_PUB.Add;
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;

Line 1033: FND_MSG_PUB.Add;

1029: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1030: -- User is not login.
1031: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1032: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1033: FND_MSG_PUB.Add;
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037: AMV_USER_PVT.Is_Administrator

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

1045: x_result_flag => l_admin_flag
1046: );
1047: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1048: -- User is not an administrator.
1049: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1050: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;

Line 1051: FND_MSG_PUB.Add;

1047: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1048: -- User is not an administrator.
1049: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1050: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: END IF;

Line 1104: FND_MSG_PUB.Count_And_Get (

1100: ELSE
1101: CLOSE Check_ResourceRole_csr;
1102: END IF;
1103: --Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1108: );

Line 1114: FND_MSG_PUB.Count_And_Get (

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

Line 1123: FND_MSG_PUB.Count_And_Get (

1119: WHEN FND_API.G_EXC_ERROR THEN
1120: ROLLBACK TO Add_AssignRoleHelper_Pvt;
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: -- Standard call to get message count and if count=1, get the message
1123: FND_MSG_PUB.Count_And_Get (
1124: p_encoded => FND_API.G_FALSE,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );

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

1127: );
1128: WHEN OTHERS THEN
1129: ROLLBACK TO Add_AssignRoleHelper_Pvt;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (

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

1128: WHEN OTHERS THEN
1129: ROLLBACK TO Add_AssignRoleHelper_Pvt;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,

Line 1135: FND_MSG_PUB.Count_And_Get (

1131: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );

Line 1190: FND_MSG_PUB.initialize;

1186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188: --Initialize message list if p_init_msg_list is TRUE.
1189: IF FND_API.To_Boolean (p_init_msg_list) THEN
1190: FND_MSG_PUB.initialize;
1191: END IF;
1192: -- Initialize API return status to success
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: -- Get the current (login) user id.

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

1201: IF (p_check_login_user = FND_API.G_TRUE) THEN
1202: -- Check if user is login and has the required privilege.
1203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1204: -- User is not login.
1205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1207: FND_MSG_PUB.Add;
1208: END IF;
1209: RAISE FND_API.G_EXC_ERROR;

Line 1207: FND_MSG_PUB.Add;

1203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1204: -- User is not login.
1205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1207: FND_MSG_PUB.Add;
1208: END IF;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: AMV_USER_PVT.Is_Administrator

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

1219: x_result_flag => l_admin_flag
1220: );
1221: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1222: -- User is not an administrator.
1223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1224: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1225: FND_MSG_PUB.Add;
1226: END IF;
1227: RAISE FND_API.G_EXC_ERROR;

Line 1225: FND_MSG_PUB.Add;

1221: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1222: -- User is not an administrator.
1223: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1224: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1225: FND_MSG_PUB.Add;
1226: END IF;
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;

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

1236: FETCH Check_ResourceRole_csr INTO l_role_relate_id, l_version;
1237: IF (Check_ResourceRole_csr%NOTFOUND) THEN
1238: CLOSE Check_ResourceRole_csr;
1239: IF (p_resource_type = G_RESOURCE_ROLE_CODE) THEN
1240: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.Set_name('AMV','AMV_RESOURCE_NOT_HAS_ROLE');
1242: FND_MESSAGE.Set_Token('P_RESOURCE_ID', TO_CHAR(p_resource_id) );
1243: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1244: FND_MSG_PUB.Add;

Line 1244: FND_MSG_PUB.Add;

1240: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1241: FND_MESSAGE.Set_name('AMV','AMV_RESOURCE_NOT_HAS_ROLE');
1242: FND_MESSAGE.Set_Token('P_RESOURCE_ID', TO_CHAR(p_resource_id) );
1243: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

1244: FND_MSG_PUB.Add;
1245: END IF;
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF (p_resource_type = G_GROUP_ROLE_CODE) THEN
1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1249: FND_MESSAGE.Set_name('AMV','AMV_GROUP_NOT_HAS_ROLE');
1250: FND_MESSAGE.Set_Token('P_GROUP_ID', TO_CHAR(p_resource_id) );
1251: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1252: FND_MSG_PUB.Add;

Line 1252: FND_MSG_PUB.Add;

1248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1249: FND_MESSAGE.Set_name('AMV','AMV_GROUP_NOT_HAS_ROLE');
1250: FND_MESSAGE.Set_Token('P_GROUP_ID', TO_CHAR(p_resource_id) );
1251: FND_MESSAGE.Set_Token('P_ROLE_ID', TO_CHAR(p_role_id) );
1252: FND_MSG_PUB.Add;
1253: END IF;
1254: RAISE FND_API.G_EXC_ERROR;
1255: END IF;
1256: END IF;

Line 1269: FND_MSG_PUB.Count_And_Get (

1265: x_msg_count => x_msg_count,
1266: x_msg_data => x_msg_data
1267: );
1268: --Standard call to get message count and if count=1, get the message
1269: FND_MSG_PUB.Count_And_Get (
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data
1273: );

Line 1279: FND_MSG_PUB.Count_And_Get (

1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: ROLLBACK TO Remove_RoleHelper_Pvt;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: -- Standard call to get message count and if count=1, get the message
1279: FND_MSG_PUB.Count_And_Get (
1280: p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );

Line 1288: FND_MSG_PUB.Count_And_Get (

1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO Remove_RoleHelper_Pvt;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: -- Standard call to get message count and if count=1, get the message
1288: FND_MSG_PUB.Count_And_Get (
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data
1292: );

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

1292: );
1293: WHEN OTHERS THEN
1294: ROLLBACK TO Remove_RoleHelper_Pvt;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1298: END IF;
1299: -- Standard call to get message count and if count=1, get the message
1300: FND_MSG_PUB.Count_And_Get (

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

1293: WHEN OTHERS THEN
1294: ROLLBACK TO Remove_RoleHelper_Pvt;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1298: END IF;
1299: -- Standard call to get message count and if count=1, get the message
1300: FND_MSG_PUB.Count_And_Get (
1301: p_encoded => FND_API.G_FALSE,

Line 1300: FND_MSG_PUB.Count_And_Get (

1296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1298: END IF;
1299: -- Standard call to get message count and if count=1, get the message
1300: FND_MSG_PUB.Count_And_Get (
1301: p_encoded => FND_API.G_FALSE,
1302: p_count => x_msg_count,
1303: p_data => x_msg_data
1304: );

Line 1377: FND_MSG_PUB.initialize;

1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375: --Initialize message list if p_init_msg_list is TRUE.
1376: IF FND_API.To_Boolean (p_init_msg_list) THEN
1377: FND_MSG_PUB.initialize;
1378: END IF;
1379: -- Initialize API return status to success
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381: -- Get the current (login) user id.

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

1388: IF (p_check_login_user = FND_API.G_TRUE) THEN
1389: -- Check if user is login and has the required privilege.
1390: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1391: -- User is not login.
1392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1393: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1394: FND_MSG_PUB.Add;
1395: END IF;
1396: RAISE FND_API.G_EXC_ERROR;

Line 1394: FND_MSG_PUB.Add;

1390: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1391: -- User is not login.
1392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1393: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1394: FND_MSG_PUB.Add;
1395: END IF;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398: AMV_USER_PVT.Is_Administrator

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

1406: x_result_flag => l_admin_flag
1407: );
1408: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1409: -- User is not an administrator.
1410: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1411: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1412: FND_MSG_PUB.Add;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;

Line 1412: FND_MSG_PUB.Add;

1408: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1409: -- User is not an administrator.
1410: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1411: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1412: FND_MSG_PUB.Add;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1416: END IF;

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

1420: l_current_user_id := -1;
1421: END IF;
1422: -- Check if the resource id is valid
1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1424: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1426: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1427: FND_MSG_PUB.Add;
1428: END IF;

Line 1427: FND_MSG_PUB.Add;

1423: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1424: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1425: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1426: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1427: FND_MSG_PUB.Add;
1428: END IF;
1429: RAISE FND_API.G_EXC_ERROR;
1430: END IF;
1431: IF (p_role_id_varray IS NULL) THEN

Line 1457: FND_MSG_PUB.Count_And_Get (

1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: END IF;
1455: END LOOP;
1456: --Standard call to get message count and if count=1, get the message
1457: FND_MSG_PUB.Count_And_Get (
1458: p_encoded => FND_API.G_FALSE,
1459: p_count => x_msg_count,
1460: p_data => x_msg_data
1461: );

Line 1467: FND_MSG_PUB.Count_And_Get (

1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: ROLLBACK TO Add_ResourceRole_Pvt;
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: -- Standard call to get message count and if count=1, get the message
1467: FND_MSG_PUB.Count_And_Get (
1468: p_encoded => FND_API.G_FALSE,
1469: p_count => x_msg_count,
1470: p_data => x_msg_data
1471: );

Line 1476: FND_MSG_PUB.Count_And_Get (

1472: WHEN FND_API.G_EXC_ERROR THEN
1473: ROLLBACK TO Add_ResourceRole_Pvt;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: -- Standard call to get message count and if count=1, get the message
1476: FND_MSG_PUB.Count_And_Get (
1477: p_encoded => FND_API.G_FALSE,
1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );

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

1480: );
1481: WHEN OTHERS THEN
1482: ROLLBACK TO Add_ResourceRole_Pvt;
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1485: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1486: END IF;
1487: -- Standard call to get message count and if count=1, get the message
1488: FND_MSG_PUB.Count_And_Get (

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

1481: WHEN OTHERS THEN
1482: ROLLBACK TO Add_ResourceRole_Pvt;
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1485: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1486: END IF;
1487: -- Standard call to get message count and if count=1, get the message
1488: FND_MSG_PUB.Count_And_Get (
1489: p_encoded => FND_API.G_FALSE,

Line 1488: FND_MSG_PUB.Count_And_Get (

1484: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1485: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1486: END IF;
1487: -- Standard call to get message count and if count=1, get the message
1488: FND_MSG_PUB.Count_And_Get (
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_msg_count,
1491: p_data => x_msg_data
1492: );

Line 1570: FND_MSG_PUB.initialize;

1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1567: END IF;
1568: --Initialize message list if p_init_msg_list is TRUE.
1569: IF FND_API.To_Boolean (p_init_msg_list) THEN
1570: FND_MSG_PUB.initialize;
1571: END IF;
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574: -- Get the current (login) user id.

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

1581: IF (p_check_login_user = FND_API.G_TRUE) THEN
1582: -- Check if user is login and has the required privilege.
1583: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1584: -- User is not login.
1585: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1586: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1587: FND_MSG_PUB.Add;
1588: END IF;
1589: RAISE FND_API.G_EXC_ERROR;

Line 1587: FND_MSG_PUB.Add;

1583: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1584: -- User is not login.
1585: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1586: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1587: FND_MSG_PUB.Add;
1588: END IF;
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591: AMV_USER_PVT.Is_Administrator

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

1599: x_result_flag => l_admin_flag
1600: );
1601: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1602: -- User is not an administrator.
1603: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1604: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1605: FND_MSG_PUB.Add;
1606: END IF;
1607: RAISE FND_API.G_EXC_ERROR;

Line 1605: FND_MSG_PUB.Add;

1601: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1602: -- User is not an administrator.
1603: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1604: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1605: FND_MSG_PUB.Add;
1606: END IF;
1607: RAISE FND_API.G_EXC_ERROR;
1608: END IF;
1609: END IF;

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

1613: l_current_user_id := -1;
1614: END IF;
1615: -- Check if the resource id is valid
1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1617: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1619: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1620: FND_MSG_PUB.Add;
1621: END IF;

Line 1620: FND_MSG_PUB.Add;

1616: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1617: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1619: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1620: FND_MSG_PUB.Add;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624: IF (p_role_id_varray IS NULL OR p_role_id_varray.count = 0) THEN

Line 1669: FND_MSG_PUB.Count_And_Get (

1665: x_return_status := FND_API.G_RET_STS_ERROR;
1666: END IF;
1667: END LOOP;
1668: --Standard call to get message count and if count=1, get the message
1669: FND_MSG_PUB.Count_And_Get (
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data
1673: );

Line 1679: FND_MSG_PUB.Count_And_Get (

1675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1676: ROLLBACK TO Remove_ResourceRole_Pvt;
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: -- Standard call to get message count and if count=1, get the message
1679: FND_MSG_PUB.Count_And_Get (
1680: p_encoded => FND_API.G_FALSE,
1681: p_count => x_msg_count,
1682: p_data => x_msg_data
1683: );

Line 1688: FND_MSG_PUB.Count_And_Get (

1684: WHEN FND_API.G_EXC_ERROR THEN
1685: ROLLBACK TO Remove_ResourceRole_Pvt;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: -- Standard call to get message count and if count=1, get the message
1688: FND_MSG_PUB.Count_And_Get (
1689: p_encoded => FND_API.G_FALSE,
1690: p_count => x_msg_count,
1691: p_data => x_msg_data
1692: );

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

1692: );
1693: WHEN OTHERS THEN
1694: ROLLBACK TO Remove_ResourceRole_Pvt;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1698: END IF;
1699: -- Standard call to get message count and if count=1, get the message
1700: FND_MSG_PUB.Count_And_Get (

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

1693: WHEN OTHERS THEN
1694: ROLLBACK TO Remove_ResourceRole_Pvt;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1698: END IF;
1699: -- Standard call to get message count and if count=1, get the message
1700: FND_MSG_PUB.Count_And_Get (
1701: p_encoded => FND_API.G_FALSE,

Line 1700: FND_MSG_PUB.Count_And_Get (

1696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1698: END IF;
1699: -- Standard call to get message count and if count=1, get the message
1700: FND_MSG_PUB.Count_And_Get (
1701: p_encoded => FND_API.G_FALSE,
1702: p_count => x_msg_count,
1703: p_data => x_msg_data
1704: );

Line 1806: FND_MSG_PUB.Count_And_Get (

1802: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1803: RAISE FND_API.G_EXC_ERROR;
1804: END IF;
1805: --Standard call to get message count and if count=1, get the message
1806: FND_MSG_PUB.Count_And_Get (
1807: p_encoded => FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data
1810: );

Line 1816: FND_MSG_PUB.Count_And_Get (

1812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1813: ROLLBACK TO Replace_ResourceRole_Pvt;
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: -- Standard call to get message count and if count=1, get the message
1816: FND_MSG_PUB.Count_And_Get (
1817: p_encoded => FND_API.G_FALSE,
1818: p_count => x_msg_count,
1819: p_data => x_msg_data
1820: );

Line 1825: FND_MSG_PUB.Count_And_Get (

1821: WHEN FND_API.G_EXC_ERROR THEN
1822: ROLLBACK TO Replace_ResourceRole_Pvt;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824: -- Standard call to get message count and if count=1, get the message
1825: FND_MSG_PUB.Count_And_Get (
1826: p_encoded => FND_API.G_FALSE,
1827: p_count => x_msg_count,
1828: p_data => x_msg_data
1829: );

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

1829: );
1830: WHEN OTHERS THEN
1831: ROLLBACK TO Replace_ResourceRole_Pvt;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1835: END IF;
1836: -- Standard call to get message count and if count=1, get the message
1837: FND_MSG_PUB.Count_And_Get (

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

1830: WHEN OTHERS THEN
1831: ROLLBACK TO Replace_ResourceRole_Pvt;
1832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1833: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1835: END IF;
1836: -- Standard call to get message count and if count=1, get the message
1837: FND_MSG_PUB.Count_And_Get (
1838: p_encoded => FND_API.G_FALSE,

Line 1837: FND_MSG_PUB.Count_And_Get (

1833: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1835: END IF;
1836: -- Standard call to get message count and if count=1, get the message
1837: FND_MSG_PUB.Count_And_Get (
1838: p_encoded => FND_API.G_FALSE,
1839: p_count => x_msg_count,
1840: p_data => x_msg_data
1841: );

Line 1888: FND_MSG_PUB.initialize;

1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: --Initialize message list if p_init_msg_list is TRUE.
1887: IF FND_API.To_Boolean (p_init_msg_list) THEN
1888: FND_MSG_PUB.initialize;
1889: END IF;
1890: -- Initialize API return status to success
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: x_role_id_varray := AMV_NUMBER_VARRAY_TYPE();

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

1901: IF (p_check_login_user = FND_API.G_TRUE) THEN
1902: -- Check if user is login and has the required privilege.
1903: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1904: -- User is not login.
1905: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909: RAISE FND_API.G_EXC_ERROR;

Line 1907: FND_MSG_PUB.Add;

1903: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1904: -- User is not login.
1905: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911: END IF;

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

1915: l_current_user_id := -1;
1916: END IF;
1917: -- Check if the resource id is valid
1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1919: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1921: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1922: FND_MSG_PUB.Add;
1923: END IF;

Line 1922: FND_MSG_PUB.Add;

1918: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
1919: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1920: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
1921: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
1922: FND_MSG_PUB.Add;
1923: END IF;
1924: RAISE FND_API.G_EXC_ERROR;
1925: END IF;
1926: FOR csr1 IN Get_ResourceRole_csr LOOP

Line 1934: FND_MSG_PUB.Count_And_Get (

1930: x_role_id_varray(l_count) := csr1.role_id;
1931: x_role_code_varray(l_count) := csr1.role_code;
1932: END LOOP;
1933: --Standard call to get message count and if count=1, get the message
1934: FND_MSG_PUB.Count_And_Get (
1935: p_encoded => FND_API.G_FALSE,
1936: p_count => x_msg_count,
1937: p_data => x_msg_data
1938: );

Line 1943: FND_MSG_PUB.Count_And_Get (

1939: EXCEPTION
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1942: -- Standard call to get message count and if count=1, get the message
1943: FND_MSG_PUB.Count_And_Get (
1944: p_encoded => FND_API.G_FALSE,
1945: p_count => x_msg_count,
1946: p_data => x_msg_data
1947: );

Line 1951: FND_MSG_PUB.Count_And_Get (

1947: );
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: -- Standard call to get message count and if count=1, get the message
1951: FND_MSG_PUB.Count_And_Get (
1952: p_encoded => FND_API.G_FALSE,
1953: p_count => x_msg_count,
1954: p_data => x_msg_data
1955: );

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

1954: p_data => x_msg_data
1955: );
1956: WHEN OTHERS THEN
1957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1958: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1960: END IF;
1961: -- Standard call to get message count and if count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (

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

1955: );
1956: WHEN OTHERS THEN
1957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1958: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1960: END IF;
1961: -- Standard call to get message count and if count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,

Line 1962: FND_MSG_PUB.Count_And_Get (

1958: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1959: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1960: END IF;
1961: -- Standard call to get message count and if count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data
1966: );

Line 2072: FND_MSG_PUB.initialize;

2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF;
2070: --Initialize message list if p_init_msg_list is TRUE.
2071: IF FND_API.To_Boolean (p_init_msg_list) THEN
2072: FND_MSG_PUB.initialize;
2073: END IF;
2074: -- Initialize API return status to success
2075: x_return_status := FND_API.G_RET_STS_SUCCESS;
2076: x_result_flag := FND_API.G_FALSE;

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

2084: IF (p_check_login_user = FND_API.G_TRUE) THEN
2085: -- Check if user is login and has the required privilege.
2086: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2087: -- User is not login.
2088: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2089: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: RAISE FND_API.G_EXC_ERROR;

Line 2090: FND_MSG_PUB.Add;

2086: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2087: -- User is not login.
2088: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2089: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2090: FND_MSG_PUB.Add;
2091: END IF;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094: END IF;

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

2103: ELSE
2104: l_resource_id := p_resource_id;
2105: -- Check if the resource id is valid
2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
2107: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2108: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
2109: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
2110: FND_MSG_PUB.Add;
2111: END IF;

Line 2110: FND_MSG_PUB.Add;

2106: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
2107: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2108: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
2109: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
2110: FND_MSG_PUB.Add;
2111: END IF;
2112: RAISE FND_API.G_EXC_ERROR;
2113: END IF;
2114: END IF;

Line 2154: FND_MSG_PUB.Count_And_Get (

2150: CLOSE Get_GroupRole_csr;
2151: END IF;
2152: END IF;
2153: --Standard call to get message count and if count=1, get the message
2154: FND_MSG_PUB.Count_And_Get (
2155: p_encoded => FND_API.G_FALSE,
2156: p_count => x_msg_count,
2157: p_data => x_msg_data
2158: );

Line 2163: FND_MSG_PUB.Count_And_Get (

2159: EXCEPTION
2160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2162: -- Standard call to get message count and if count=1, get the message
2163: FND_MSG_PUB.Count_And_Get (
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data
2167: );

Line 2171: FND_MSG_PUB.Count_And_Get (

2167: );
2168: WHEN FND_API.G_EXC_ERROR THEN
2169: x_return_status := FND_API.G_RET_STS_ERROR;
2170: -- Standard call to get message count and if count=1, get the message
2171: FND_MSG_PUB.Count_And_Get (
2172: p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data
2175: );

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

2174: p_data => x_msg_data
2175: );
2176: WHEN OTHERS THEN
2177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2180: END IF;
2181: -- Standard call to get message count and if count=1, get the message
2182: FND_MSG_PUB.Count_And_Get (

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

2175: );
2176: WHEN OTHERS THEN
2177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2180: END IF;
2181: -- Standard call to get message count and if count=1, get the message
2182: FND_MSG_PUB.Count_And_Get (
2183: p_encoded => FND_API.G_FALSE,

Line 2182: FND_MSG_PUB.Count_And_Get (

2178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2180: END IF;
2181: -- Standard call to get message count and if count=1, get the message
2182: FND_MSG_PUB.Count_And_Get (
2183: p_encoded => FND_API.G_FALSE,
2184: p_count => x_msg_count,
2185: p_data => x_msg_data
2186: );

Line 2533: FND_MSG_PUB.initialize;

2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: --Initialize message list if p_init_msg_list is TRUE.
2532: IF FND_API.To_Boolean (p_init_msg_list) THEN
2533: FND_MSG_PUB.initialize;
2534: END IF;
2535: -- Initialize API return status to success
2536: x_return_status := FND_API.G_RET_STS_SUCCESS;
2537: -- Get the current (login) user id.

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

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

Line 2550: FND_MSG_PUB.Add;

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

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

2562: x_result_flag => l_admin_flag
2563: );
2564: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2565: -- User is not an administrator.
2566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2568: FND_MSG_PUB.Add;
2569: END IF;
2570: RAISE FND_API.G_EXC_ERROR;

Line 2568: FND_MSG_PUB.Add;

2564: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2565: -- User is not an administrator.
2566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2568: FND_MSG_PUB.Add;
2569: END IF;
2570: RAISE FND_API.G_EXC_ERROR;
2571: END IF;
2572: END IF;

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

2576: l_current_user_id := -1;
2577: END IF;
2578: -- Check if the group id is valid
2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2582: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2583: FND_MSG_PUB.Add;
2584: END IF;

Line 2583: FND_MSG_PUB.Add;

2579: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2582: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2583: FND_MSG_PUB.Add;
2584: END IF;
2585: RAISE FND_API.G_EXC_ERROR;
2586: END IF;
2587:

Line 2614: FND_MSG_PUB.Count_And_Get (

2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: END IF;
2612: END LOOP;
2613: --Standard call to get message count and if count=1, get the message
2614: FND_MSG_PUB.Count_And_Get (
2615: p_encoded => FND_API.G_FALSE,
2616: p_count => x_msg_count,
2617: p_data => x_msg_data
2618: );

Line 2624: FND_MSG_PUB.Count_And_Get (

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

Line 2633: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2645: FND_MSG_PUB.Count_And_Get (

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

Line 2727: FND_MSG_PUB.initialize;

2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2724: END IF;
2725: --Initialize message list if p_init_msg_list is TRUE.
2726: IF FND_API.To_Boolean (p_init_msg_list) THEN
2727: FND_MSG_PUB.initialize;
2728: END IF;
2729: -- Initialize API return status to success
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;
2731: -- Get the current (login) user id.

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

2738: IF (p_check_login_user = FND_API.G_TRUE) THEN
2739: -- Check if user is login and has the required privilege.
2740: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2741: -- User is not login.
2742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2744: FND_MSG_PUB.Add;
2745: END IF;
2746: RAISE FND_API.G_EXC_ERROR;

Line 2744: FND_MSG_PUB.Add;

2740: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
2741: -- User is not login.
2742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2744: FND_MSG_PUB.Add;
2745: END IF;
2746: RAISE FND_API.G_EXC_ERROR;
2747: END IF;
2748: AMV_USER_PVT.Is_Administrator

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

2756: x_result_flag => l_admin_flag
2757: );
2758: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2759: -- User is not an administrator.
2760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2761: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2762: FND_MSG_PUB.Add;
2763: END IF;
2764: RAISE FND_API.G_EXC_ERROR;

Line 2762: FND_MSG_PUB.Add;

2758: IF (l_admin_flag <> FND_API.G_TRUE) THEN
2759: -- User is not an administrator.
2760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2761: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
2762: FND_MSG_PUB.Add;
2763: END IF;
2764: RAISE FND_API.G_EXC_ERROR;
2765: END IF;
2766: END IF;

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

2770: l_current_user_id := -1;
2771: END IF;
2772: -- Check if the Group id is valid
2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2774: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2775: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2776: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2777: FND_MSG_PUB.Add;
2778: END IF;

Line 2777: FND_MSG_PUB.Add;

2773: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
2774: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2775: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
2776: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
2777: FND_MSG_PUB.Add;
2778: END IF;
2779: RAISE FND_API.G_EXC_ERROR;
2780: END IF;
2781: IF (p_role_id_varray IS NULL OR p_role_id_varray.count = 0) THEN

Line 2826: FND_MSG_PUB.Count_And_Get (

2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: END IF;
2824: END LOOP;
2825: --Standard call to get message count and if count=1, get the message
2826: FND_MSG_PUB.Count_And_Get (
2827: p_encoded => FND_API.G_FALSE,
2828: p_count => x_msg_count,
2829: p_data => x_msg_data
2830: );

Line 2836: FND_MSG_PUB.Count_And_Get (

2832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2833: ROLLBACK TO Remove_GroupRole_Pvt;
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: -- Standard call to get message count and if count=1, get the message
2836: FND_MSG_PUB.Count_And_Get (
2837: p_encoded => FND_API.G_FALSE,
2838: p_count => x_msg_count,
2839: p_data => x_msg_data
2840: );

Line 2845: FND_MSG_PUB.Count_And_Get (

2841: WHEN FND_API.G_EXC_ERROR THEN
2842: ROLLBACK TO Remove_GroupRole_Pvt;
2843: x_return_status := FND_API.G_RET_STS_ERROR;
2844: -- Standard call to get message count and if count=1, get the message
2845: FND_MSG_PUB.Count_And_Get (
2846: p_encoded => FND_API.G_FALSE,
2847: p_count => x_msg_count,
2848: p_data => x_msg_data
2849: );

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

2849: );
2850: WHEN OTHERS THEN
2851: ROLLBACK TO Remove_GroupRole_Pvt;
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2855: END IF;
2856: -- Standard call to get message count and if count=1, get the message
2857: FND_MSG_PUB.Count_And_Get (

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

2850: WHEN OTHERS THEN
2851: ROLLBACK TO Remove_GroupRole_Pvt;
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2855: END IF;
2856: -- Standard call to get message count and if count=1, get the message
2857: FND_MSG_PUB.Count_And_Get (
2858: p_encoded => FND_API.G_FALSE,

Line 2857: FND_MSG_PUB.Count_And_Get (

2853: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2855: END IF;
2856: -- Standard call to get message count and if count=1, get the message
2857: FND_MSG_PUB.Count_And_Get (
2858: p_encoded => FND_API.G_FALSE,
2859: p_count => x_msg_count,
2860: p_data => x_msg_data
2861: );

Line 2961: FND_MSG_PUB.Count_And_Get (

2957: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2958: RAISE FND_API.G_EXC_ERROR;
2959: END IF;
2960: --Standard call to get message count and if count=1, get the message
2961: FND_MSG_PUB.Count_And_Get (
2962: p_encoded => FND_API.G_FALSE,
2963: p_count => x_msg_count,
2964: p_data => x_msg_data
2965: );

Line 2971: FND_MSG_PUB.Count_And_Get (

2967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2968: ROLLBACK TO Replace_GroupRole_Pvt;
2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2970: -- Standard call to get message count and if count=1, get the message
2971: FND_MSG_PUB.Count_And_Get (
2972: p_encoded => FND_API.G_FALSE,
2973: p_count => x_msg_count,
2974: p_data => x_msg_data
2975: );

Line 2980: FND_MSG_PUB.Count_And_Get (

2976: WHEN FND_API.G_EXC_ERROR THEN
2977: ROLLBACK TO Replace_GroupRole_Pvt;
2978: x_return_status := FND_API.G_RET_STS_ERROR;
2979: -- Standard call to get message count and if count=1, get the message
2980: FND_MSG_PUB.Count_And_Get (
2981: p_encoded => FND_API.G_FALSE,
2982: p_count => x_msg_count,
2983: p_data => x_msg_data
2984: );

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

2984: );
2985: WHEN OTHERS THEN
2986: ROLLBACK TO Replace_GroupRole_Pvt;
2987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2988: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2989: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2990: END IF;
2991: -- Standard call to get message count and if count=1, get the message
2992: FND_MSG_PUB.Count_And_Get (

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

2985: WHEN OTHERS THEN
2986: ROLLBACK TO Replace_GroupRole_Pvt;
2987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2988: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2989: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2990: END IF;
2991: -- Standard call to get message count and if count=1, get the message
2992: FND_MSG_PUB.Count_And_Get (
2993: p_encoded => FND_API.G_FALSE,

Line 2992: FND_MSG_PUB.Count_And_Get (

2988: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2989: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2990: END IF;
2991: -- Standard call to get message count and if count=1, get the message
2992: FND_MSG_PUB.Count_And_Get (
2993: p_encoded => FND_API.G_FALSE,
2994: p_count => x_msg_count,
2995: p_data => x_msg_data
2996: );

Line 3044: FND_MSG_PUB.initialize;

3040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3041: END IF;
3042: --Initialize message list if p_init_msg_list is TRUE.
3043: IF FND_API.To_Boolean (p_init_msg_list) THEN
3044: FND_MSG_PUB.initialize;
3045: END IF;
3046: -- Initialize API return status to success
3047: x_return_status := FND_API.G_RET_STS_SUCCESS;
3048: x_role_id_varray := AMV_NUMBER_VARRAY_TYPE();

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

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

Line 3063: FND_MSG_PUB.Add;

3059: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3060: -- User is not login.
3061: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3062: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3063: FND_MSG_PUB.Add;
3064: END IF;
3065: RAISE FND_API.G_EXC_ERROR;
3066: END IF;
3067: END IF;

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

3071: l_current_user_id := -1;
3072: END IF;
3073: -- Check if the group id is valid
3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3075: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3076: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3077: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3078: FND_MSG_PUB.Add;
3079: END IF;

Line 3078: FND_MSG_PUB.Add;

3074: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3075: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3076: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3077: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3078: FND_MSG_PUB.Add;
3079: END IF;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082: FOR csr1 IN Get_GroupRole_csr LOOP

Line 3090: FND_MSG_PUB.Count_And_Get (

3086: x_role_id_varray(l_count) := csr1.role_id;
3087: x_role_code_varray(l_count) := csr1.role_code;
3088: END LOOP;
3089: --Standard call to get message count and if count=1, get the message
3090: FND_MSG_PUB.Count_And_Get (
3091: p_encoded => FND_API.G_FALSE,
3092: p_count => x_msg_count,
3093: p_data => x_msg_data
3094: );

Line 3099: FND_MSG_PUB.Count_And_Get (

3095: EXCEPTION
3096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: -- Standard call to get message count and if count=1, get the message
3099: FND_MSG_PUB.Count_And_Get (
3100: p_encoded => FND_API.G_FALSE,
3101: p_count => x_msg_count,
3102: p_data => x_msg_data
3103: );

Line 3107: FND_MSG_PUB.Count_And_Get (

3103: );
3104: WHEN FND_API.G_EXC_ERROR THEN
3105: x_return_status := FND_API.G_RET_STS_ERROR;
3106: -- Standard call to get message count and if count=1, get the message
3107: FND_MSG_PUB.Count_And_Get (
3108: p_encoded => FND_API.G_FALSE,
3109: p_count => x_msg_count,
3110: p_data => x_msg_data
3111: );

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

3110: p_data => x_msg_data
3111: );
3112: WHEN OTHERS THEN
3113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3116: END IF;
3117: -- Standard call to get message count and if count=1, get the message
3118: FND_MSG_PUB.Count_And_Get (

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

3111: );
3112: WHEN OTHERS THEN
3113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3116: END IF;
3117: -- Standard call to get message count and if count=1, get the message
3118: FND_MSG_PUB.Count_And_Get (
3119: p_encoded => FND_API.G_FALSE,

Line 3118: FND_MSG_PUB.Count_And_Get (

3114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3116: END IF;
3117: -- Standard call to get message count and if count=1, get the message
3118: FND_MSG_PUB.Count_And_Get (
3119: p_encoded => FND_API.G_FALSE,
3120: p_count => x_msg_count,
3121: p_data => x_msg_data
3122: );

Line 3182: FND_MSG_PUB.initialize;

3178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;
3180: --Initialize message list if p_init_msg_list is TRUE.
3181: IF FND_API.To_Boolean (p_init_msg_list) THEN
3182: FND_MSG_PUB.initialize;
3183: END IF;
3184: -- Initialize API return status to success
3185: x_return_status := FND_API.G_RET_STS_SUCCESS;
3186: x_result_flag := FND_API.G_FALSE;

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

3194: IF (p_check_login_user = FND_API.G_TRUE) THEN
3195: -- Check if user is login and has the required privilege.
3196: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3197: -- User is not login.
3198: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3199: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3200: FND_MSG_PUB.Add;
3201: END IF;
3202: RAISE FND_API.G_EXC_ERROR;

Line 3200: FND_MSG_PUB.Add;

3196: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3197: -- User is not login.
3198: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3199: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3200: FND_MSG_PUB.Add;
3201: END IF;
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;
3204: END IF;

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

3203: END IF;
3204: END IF;
3205: -- Check if the resource id is valid
3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3207: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3208: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3209: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3210: FND_MSG_PUB.Add;
3211: END IF;

Line 3210: FND_MSG_PUB.Add;

3206: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3207: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3208: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3209: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3210: FND_MSG_PUB.Add;
3211: END IF;
3212: RAISE FND_API.G_EXC_ERROR;
3213: END IF;
3214: IF (p_check_effective_date = FND_API.G_TRUE) THEN

Line 3234: FND_MSG_PUB.Count_And_Get (

3230: END IF;
3231: CLOSE Get_GroupRole_csr;
3232: END IF;
3233: --Standard call to get message count and if count=1, get the message
3234: FND_MSG_PUB.Count_And_Get (
3235: p_encoded => FND_API.G_FALSE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data
3238: );

Line 3243: FND_MSG_PUB.Count_And_Get (

3239: EXCEPTION
3240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: -- Standard call to get message count and if count=1, get the message
3243: FND_MSG_PUB.Count_And_Get (
3244: p_encoded => FND_API.G_FALSE,
3245: p_count => x_msg_count,
3246: p_data => x_msg_data
3247: );

Line 3251: FND_MSG_PUB.Count_And_Get (

3247: );
3248: WHEN FND_API.G_EXC_ERROR THEN
3249: x_return_status := FND_API.G_RET_STS_ERROR;
3250: -- Standard call to get message count and if count=1, get the message
3251: FND_MSG_PUB.Count_And_Get (
3252: p_encoded => FND_API.G_FALSE,
3253: p_count => x_msg_count,
3254: p_data => x_msg_data
3255: );

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

3254: p_data => x_msg_data
3255: );
3256: WHEN OTHERS THEN
3257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3260: END IF;
3261: -- Standard call to get message count and if count=1, get the message
3262: FND_MSG_PUB.Count_And_Get (

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

3255: );
3256: WHEN OTHERS THEN
3257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3260: END IF;
3261: -- Standard call to get message count and if count=1, get the message
3262: FND_MSG_PUB.Count_And_Get (
3263: p_encoded => FND_API.G_FALSE,

Line 3262: FND_MSG_PUB.Count_And_Get (

3258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3260: END IF;
3261: -- Standard call to get message count and if count=1, get the message
3262: FND_MSG_PUB.Count_And_Get (
3263: p_encoded => FND_API.G_FALSE,
3264: p_count => x_msg_count,
3265: p_data => x_msg_data
3266: );

Line 3329: FND_MSG_PUB.initialize;

3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326: END IF;
3327: --Initialize message list if p_init_msg_list is TRUE.
3328: IF FND_API.To_Boolean (p_init_msg_list) THEN
3329: FND_MSG_PUB.initialize;
3330: END IF;
3331: -- Initialize API return status to success
3332: x_return_status := FND_API.G_RET_STS_SUCCESS;
3333: -- Get the current (login) user id.

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

3341: IF (p_check_login_user = FND_API.G_TRUE) THEN
3342: -- Check if user is login and has the required privilege.
3343: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3344: -- User is not login.
3345: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3346: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3347: FND_MSG_PUB.Add;
3348: END IF;
3349: RAISE FND_API.G_EXC_ERROR;

Line 3347: FND_MSG_PUB.Add;

3343: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3344: -- User is not login.
3345: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3346: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3347: FND_MSG_PUB.Add;
3348: END IF;
3349: RAISE FND_API.G_EXC_ERROR;
3350: END IF;
3351: AMV_USER_PVT.Is_Administrator

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

3359: x_result_flag => l_admin_flag
3360: );
3361: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3362: -- User is not an administrator.
3363: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3364: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3365: FND_MSG_PUB.Add;
3366: END IF;
3367: RAISE FND_API.G_EXC_ERROR;

Line 3365: FND_MSG_PUB.Add;

3361: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3362: -- User is not an administrator.
3363: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3364: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3365: FND_MSG_PUB.Add;
3366: END IF;
3367: RAISE FND_API.G_EXC_ERROR;
3368: END IF;
3369: END IF;

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

3376: OPEN Check_Group_csr;
3377: FETCH Check_Group_csr INTO l_group_id;
3378: IF (Check_Group_csr%FOUND) THEN
3379: CLOSE Check_Group_csr;
3380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3381: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3382: FND_MESSAGE.Set_Token('NAME', p_group_name );
3383: FND_MSG_PUB.Add;
3384: END IF;

Line 3383: FND_MSG_PUB.Add;

3379: CLOSE Check_Group_csr;
3380: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3381: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3382: FND_MESSAGE.Set_Token('NAME', p_group_name );
3383: FND_MSG_PUB.Add;
3384: END IF;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSE
3387: CLOSE Check_Group_csr;

Line 3560: FND_MSG_PUB.Count_And_Get (

3556: IF FND_API.To_Boolean ( p_commit ) THEN
3557: COMMIT WORK;
3558: END IF;
3559: --Standard call to get message count and if count=1, get the message
3560: FND_MSG_PUB.Count_And_Get (
3561: p_encoded => FND_API.G_FALSE,
3562: p_count => x_msg_count,
3563: p_data => x_msg_data
3564: );

Line 3570: FND_MSG_PUB.Count_And_Get (

3566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3567: ROLLBACK TO Add_Group_Pvt;
3568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3569: -- Standard call to get message count and if count=1, get the message
3570: FND_MSG_PUB.Count_And_Get (
3571: p_encoded => FND_API.G_FALSE,
3572: p_count => x_msg_count,
3573: p_data => x_msg_data
3574: );

Line 3579: FND_MSG_PUB.Count_And_Get (

3575: WHEN FND_API.G_EXC_ERROR THEN
3576: ROLLBACK TO Add_Group_Pvt;
3577: x_return_status := FND_API.G_RET_STS_ERROR;
3578: -- Standard call to get message count and if count=1, get the message
3579: FND_MSG_PUB.Count_And_Get (
3580: p_encoded => FND_API.G_FALSE,
3581: p_count => x_msg_count,
3582: p_data => x_msg_data
3583: );

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

3583: );
3584: WHEN OTHERS THEN
3585: ROLLBACK TO Add_Group_Pvt;
3586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3589: END IF;
3590: -- Standard call to get message count and if count=1, get the message
3591: FND_MSG_PUB.Count_And_Get (

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

3584: WHEN OTHERS THEN
3585: ROLLBACK TO Add_Group_Pvt;
3586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3589: END IF;
3590: -- Standard call to get message count and if count=1, get the message
3591: FND_MSG_PUB.Count_And_Get (
3592: p_encoded => FND_API.G_FALSE,

Line 3591: FND_MSG_PUB.Count_And_Get (

3587: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3589: END IF;
3590: -- Standard call to get message count and if count=1, get the message
3591: FND_MSG_PUB.Count_And_Get (
3592: p_encoded => FND_API.G_FALSE,
3593: p_count => x_msg_count,
3594: p_data => x_msg_data
3595: );

Line 3662: FND_MSG_PUB.initialize;

3658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3659: END IF;
3660: --Initialize message list if p_init_msg_list is TRUE.
3661: IF FND_API.To_Boolean (p_init_msg_list) THEN
3662: FND_MSG_PUB.initialize;
3663: END IF;
3664: -- Initialize API return status to success
3665: x_return_status := FND_API.G_RET_STS_SUCCESS;
3666: -- Get the current (login) user id.

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

3673: IF (p_check_login_user = FND_API.G_TRUE) THEN
3674: -- Check if user is login and has the required privilege.
3675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3676: -- User is not login.
3677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3679: FND_MSG_PUB.Add;
3680: END IF;
3681: RAISE FND_API.G_EXC_ERROR;

Line 3679: FND_MSG_PUB.Add;

3675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
3676: -- User is not login.
3677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3679: FND_MSG_PUB.Add;
3680: END IF;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683: AMV_USER_PVT.Is_Administrator

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

3691: x_result_flag => l_admin_flag
3692: );
3693: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3694: -- User is not an administrator.
3695: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3696: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3697: FND_MSG_PUB.Add;
3698: END IF;
3699: RAISE FND_API.G_EXC_ERROR;

Line 3697: FND_MSG_PUB.Add;

3693: IF (l_admin_flag <> FND_API.G_TRUE) THEN
3694: -- User is not an administrator.
3695: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3696: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
3697: FND_MSG_PUB.Add;
3698: END IF;
3699: RAISE FND_API.G_EXC_ERROR;
3700: END IF;
3701: END IF;

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

3705: l_current_user_id := -1;
3706: END IF;
3707: -- Check if the group id is valid
3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3709: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3710: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3711: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3712: FND_MSG_PUB.Add;
3713: END IF;

Line 3712: FND_MSG_PUB.Add;

3708: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3709: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3710: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3711: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3712: FND_MSG_PUB.Add;
3713: END IF;
3714: RAISE FND_API.G_EXC_ERROR;
3715: END IF;
3716: -- Check if the group name is unique

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

3718: OPEN Check_Group_csr(p_new_group_name);
3719: FETCH Check_Group_csr INTO l_group_id;
3720: IF (Check_Group_csr%FOUND) THEN
3721: CLOSE Check_Group_csr;
3722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3723: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3724: FND_MESSAGE.Set_Token('NAME', p_new_group_name );
3725: FND_MSG_PUB.Add;
3726: END IF;

Line 3725: FND_MSG_PUB.Add;

3721: CLOSE Check_Group_csr;
3722: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3723: FND_MESSAGE.Set_name('AMV','AMV_DUPLICATE_GROUP_NAME');
3724: FND_MESSAGE.Set_Token('NAME', p_new_group_name );
3725: FND_MSG_PUB.Add;
3726: END IF;
3727: RAISE FND_API.G_EXC_ERROR;
3728: ELSE
3729: CLOSE Check_Group_csr;

Line 3797: FND_MSG_PUB.Count_And_Get (

3793: IF FND_API.To_Boolean ( p_commit ) THEN
3794: COMMIT WORK;
3795: END IF;
3796: --Standard call to get message count and if count=1, get the message
3797: FND_MSG_PUB.Count_And_Get (
3798: p_encoded => FND_API.G_FALSE,
3799: p_count => x_msg_count,
3800: p_data => x_msg_data
3801: );

Line 3807: FND_MSG_PUB.Count_And_Get (

3803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3804: ROLLBACK TO Update_Group_Pvt;
3805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3806: -- Standard call to get message count and if count=1, get the message
3807: FND_MSG_PUB.Count_And_Get (
3808: p_encoded => FND_API.G_FALSE,
3809: p_count => x_msg_count,
3810: p_data => x_msg_data
3811: );

Line 3816: FND_MSG_PUB.Count_And_Get (

3812: WHEN FND_API.G_EXC_ERROR THEN
3813: ROLLBACK TO Update_Group_Pvt;
3814: x_return_status := FND_API.G_RET_STS_ERROR;
3815: -- Standard call to get message count and if count=1, get the message
3816: FND_MSG_PUB.Count_And_Get (
3817: p_encoded => FND_API.G_FALSE,
3818: p_count => x_msg_count,
3819: p_data => x_msg_data
3820: );

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

3820: );
3821: WHEN OTHERS THEN
3822: ROLLBACK TO Update_Group_Pvt;
3823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3826: END IF;
3827: -- Standard call to get message count and if count=1, get the message
3828: FND_MSG_PUB.Count_And_Get (

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

3821: WHEN OTHERS THEN
3822: ROLLBACK TO Update_Group_Pvt;
3823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3826: END IF;
3827: -- Standard call to get message count and if count=1, get the message
3828: FND_MSG_PUB.Count_And_Get (
3829: p_encoded => FND_API.G_FALSE,

Line 3828: FND_MSG_PUB.Count_And_Get (

3824: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3826: END IF;
3827: -- Standard call to get message count and if count=1, get the message
3828: FND_MSG_PUB.Count_And_Get (
3829: p_encoded => FND_API.G_FALSE,
3830: p_count => x_msg_count,
3831: p_data => x_msg_data
3832: );

Line 3883: FND_MSG_PUB.initialize;

3879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3880: END IF;
3881: --Initialize message list if p_init_msg_list is TRUE.
3882: IF FND_API.To_Boolean (p_init_msg_list) THEN
3883: FND_MSG_PUB.initialize;
3884: END IF;
3885:
3886: -- Initialize API return status to success
3887: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3887: x_return_status := FND_API.G_RET_STS_SUCCESS;
3888: -- Check if the group id is valid
3889: IF (p_group_id IS NOT NULL AND p_group_id <> FND_API.G_MISS_NUM) THEN
3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3893: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3894: FND_MSG_PUB.Add;
3895: END IF;

Line 3894: FND_MSG_PUB.Add;

3890: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
3891: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3892: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
3893: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
3894: FND_MSG_PUB.Add;
3895: END IF;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3898: l_group_id := p_group_id;

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

3903: OPEN Get_GroupID_csr(p_group_name);
3904: FETCH Get_GroupID_csr INTO l_group_id;
3905: IF (Get_GroupID_csr%NOTFOUND) THEN
3906: CLOSE Get_GroupID_csr;
3907: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3908: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_NAME');
3909: FND_MESSAGE.Set_Token('NAME', p_group_name );
3910: FND_MSG_PUB.Add;
3911: END IF;

Line 3910: FND_MSG_PUB.Add;

3906: CLOSE Get_GroupID_csr;
3907: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3908: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_NAME');
3909: FND_MESSAGE.Set_Token('NAME', p_group_name );
3910: FND_MSG_PUB.Add;
3911: END IF;
3912: RAISE FND_API.G_EXC_ERROR;
3913: ELSE
3914: CLOSE Get_GroupID_csr;

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

3913: ELSE
3914: CLOSE Get_GroupID_csr;
3915: END IF;
3916: ELSE
3917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3918: FND_MESSAGE.Set_name('AMV','AMV_NO_GROUP_NAME_OR_ID');
3919: FND_MSG_PUB.Add;
3920: END IF;
3921: RAISE FND_API.G_EXC_ERROR;

Line 3919: FND_MSG_PUB.Add;

3915: END IF;
3916: ELSE
3917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3918: FND_MESSAGE.Set_name('AMV','AMV_NO_GROUP_NAME_OR_ID');
3919: FND_MSG_PUB.Add;
3920: END IF;
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
3923: --Now do the job.

Line 3962: FND_MSG_PUB.Count_And_Get (

3958: p_new_start_date => sysdate -2,
3959: p_new_end_date => sysdate -1
3960: );
3961: --Standard call to get message count and if count=1, get the message
3962: FND_MSG_PUB.Count_And_Get (
3963: p_encoded => FND_API.G_FALSE,
3964: p_count => x_msg_count,
3965: p_data => x_msg_data
3966: );

Line 3972: FND_MSG_PUB.Count_And_Get (

3968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3969: ROLLBACK TO Delete_Group_Pvt;
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: -- Standard call to get message count and if count=1, get the message
3972: FND_MSG_PUB.Count_And_Get (
3973: p_encoded => FND_API.G_FALSE,
3974: p_count => x_msg_count,
3975: p_data => x_msg_data
3976: );

Line 3981: FND_MSG_PUB.Count_And_Get (

3977: WHEN FND_API.G_EXC_ERROR THEN
3978: ROLLBACK TO Delete_Group_Pvt;
3979: x_return_status := FND_API.G_RET_STS_ERROR;
3980: -- Standard call to get message count and if count=1, get the message
3981: FND_MSG_PUB.Count_And_Get (
3982: p_encoded => FND_API.G_FALSE,
3983: p_count => x_msg_count,
3984: p_data => x_msg_data
3985: );

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

3985: );
3986: WHEN OTHERS THEN
3987: ROLLBACK TO Delete_Group_Pvt;
3988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3991: END IF;
3992: -- Standard call to get message count and if count=1, get the message
3993: FND_MSG_PUB.Count_And_Get (

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

3986: WHEN OTHERS THEN
3987: ROLLBACK TO Delete_Group_Pvt;
3988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3991: END IF;
3992: -- Standard call to get message count and if count=1, get the message
3993: FND_MSG_PUB.Count_And_Get (
3994: p_encoded => FND_API.G_FALSE,

Line 3993: FND_MSG_PUB.Count_And_Get (

3989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3990: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3991: END IF;
3992: -- Standard call to get message count and if count=1, get the message
3993: FND_MSG_PUB.Count_And_Get (
3994: p_encoded => FND_API.G_FALSE,
3995: p_count => x_msg_count,
3996: p_data => x_msg_data
3997: );

Line 4044: FND_MSG_PUB.initialize;

4040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4041: END IF;
4042: --Initialize message list if p_init_msg_list is TRUE.
4043: IF FND_API.To_Boolean (p_init_msg_list) THEN
4044: FND_MSG_PUB.initialize;
4045: END IF;
4046: -- Initialize API return status to success
4047: x_return_status := FND_API.G_RET_STS_SUCCESS;
4048: -- Get the current (login) user id.

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

4055: IF (p_check_login_user = FND_API.G_TRUE) THEN
4056: -- Check if user is login and has the required privilege.
4057: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4058: -- User is not login.
4059: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4060: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4061: FND_MSG_PUB.Add;
4062: END IF;
4063: RAISE FND_API.G_EXC_ERROR;

Line 4061: FND_MSG_PUB.Add;

4057: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4058: -- User is not login.
4059: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4060: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4061: FND_MSG_PUB.Add;
4062: END IF;
4063: RAISE FND_API.G_EXC_ERROR;
4064: END IF;
4065: END IF;

Line 4102: FND_MSG_PUB.Count_And_Get (

4098: CLOSE Get_GroupObj_csr;
4099: RAISE FND_API.G_EXC_ERROR;
4100: END IF;
4101: --Standard call to get message count and if count=1, get the message
4102: FND_MSG_PUB.Count_And_Get (
4103: p_encoded => FND_API.G_FALSE,
4104: p_count => x_msg_count,
4105: p_data => x_msg_data
4106: );

Line 4111: FND_MSG_PUB.Count_And_Get (

4107: EXCEPTION
4108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4110: -- Standard call to get message count and if count=1, get the message
4111: FND_MSG_PUB.Count_And_Get (
4112: p_encoded => FND_API.G_FALSE,
4113: p_count => x_msg_count,
4114: p_data => x_msg_data
4115: );

Line 4119: FND_MSG_PUB.Count_And_Get (

4115: );
4116: WHEN FND_API.G_EXC_ERROR THEN
4117: x_return_status := FND_API.G_RET_STS_ERROR;
4118: -- Standard call to get message count and if count=1, get the message
4119: FND_MSG_PUB.Count_And_Get (
4120: p_encoded => FND_API.G_FALSE,
4121: p_count => x_msg_count,
4122: p_data => x_msg_data
4123: );

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

4122: p_data => x_msg_data
4123: );
4124: WHEN OTHERS THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4126: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4128: END IF;
4129: -- Standard call to get message count and if count=1, get the message
4130: FND_MSG_PUB.Count_And_Get (

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

4123: );
4124: WHEN OTHERS THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4126: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4128: END IF;
4129: -- Standard call to get message count and if count=1, get the message
4130: FND_MSG_PUB.Count_And_Get (
4131: p_encoded => FND_API.G_FALSE,

Line 4130: FND_MSG_PUB.Count_And_Get (

4126: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4127: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4128: END IF;
4129: -- Standard call to get message count and if count=1, get the message
4130: FND_MSG_PUB.Count_And_Get (
4131: p_encoded => FND_API.G_FALSE,
4132: p_count => x_msg_count,
4133: p_data => x_msg_data
4134: );

Line 4190: FND_MSG_PUB.initialize;

4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4187: END IF;
4188: --Initialize message list if p_init_msg_list is TRUE.
4189: IF FND_API.To_Boolean (p_init_msg_list) THEN
4190: FND_MSG_PUB.initialize;
4191: END IF;
4192: -- Initialize API return status to success
4193: x_return_status := FND_API.G_RET_STS_SUCCESS;
4194: -- Get the current (login) user id.

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

4201: IF (p_check_login_user = FND_API.G_TRUE) THEN
4202: -- Check if user is login and has the required privilege.
4203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4204: -- User is not login.
4205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4207: FND_MSG_PUB.Add;
4208: END IF;
4209: RAISE FND_API.G_EXC_ERROR;

Line 4207: FND_MSG_PUB.Add;

4203: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4204: -- User is not login.
4205: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4206: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4207: FND_MSG_PUB.Add;
4208: END IF;
4209: RAISE FND_API.G_EXC_ERROR;
4210: END IF;
4211: END IF;

Line 4349: FND_MSG_PUB.Count_And_Get (

4345: l_total_record_count
4346: );
4347: */
4348: --Standard call to get message count and if count=1, get the message
4349: FND_MSG_PUB.Count_And_Get (
4350: p_encoded => FND_API.G_FALSE,
4351: p_count => x_msg_count,
4352: p_data => x_msg_data
4353: );

Line 4358: FND_MSG_PUB.Count_And_Get (

4354: EXCEPTION
4355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: -- Standard call to get message count and if count=1, get the message
4358: FND_MSG_PUB.Count_And_Get (
4359: p_encoded => FND_API.G_FALSE,
4360: p_count => x_msg_count,
4361: p_data => x_msg_data
4362: );

Line 4366: FND_MSG_PUB.Count_And_Get (

4362: );
4363: WHEN FND_API.G_EXC_ERROR THEN
4364: x_return_status := FND_API.G_RET_STS_ERROR;
4365: -- Standard call to get message count and if count=1, get the message
4366: FND_MSG_PUB.Count_And_Get (
4367: p_encoded => FND_API.G_FALSE,
4368: p_count => x_msg_count,
4369: p_data => x_msg_data
4370: );

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

4369: p_data => x_msg_data
4370: );
4371: WHEN OTHERS THEN
4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4375: END IF;
4376: -- Standard call to get message count and if count=1, get the message
4377: FND_MSG_PUB.Count_And_Get (

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

4370: );
4371: WHEN OTHERS THEN
4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4375: END IF;
4376: -- Standard call to get message count and if count=1, get the message
4377: FND_MSG_PUB.Count_And_Get (
4378: p_encoded => FND_API.G_FALSE,

Line 4377: FND_MSG_PUB.Count_And_Get (

4373: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4375: END IF;
4376: -- Standard call to get message count and if count=1, get the message
4377: FND_MSG_PUB.Count_And_Get (
4378: p_encoded => FND_API.G_FALSE,
4379: p_count => x_msg_count,
4380: p_data => x_msg_data
4381: );

Line 4436: FND_MSG_PUB.initialize;

4432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4433: END IF;
4434: --Initialize message list if p_init_msg_list is TRUE.
4435: IF FND_API.To_Boolean (p_init_msg_list) THEN
4436: FND_MSG_PUB.initialize;
4437: END IF;
4438: -- Initialize API return status to success
4439: x_return_status := FND_API.G_RET_STS_SUCCESS;
4440: -- Get the current (login) user id.

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

4447: IF (p_check_login_user = FND_API.G_TRUE) THEN
4448: -- Check if user is login and has the required privilege.
4449: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4450: -- User is not login.
4451: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4452: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4453: FND_MSG_PUB.Add;
4454: END IF;
4455: RAISE FND_API.G_EXC_ERROR;

Line 4453: FND_MSG_PUB.Add;

4449: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4450: -- User is not login.
4451: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4452: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4453: FND_MSG_PUB.Add;
4454: END IF;
4455: RAISE FND_API.G_EXC_ERROR;
4456: END IF;
4457: END IF;

Line 4567: FND_MSG_PUB.Count_And_Get (

4563: l_total_record_count
4564: );
4565: */
4566: --Standard call to get message count and if count=1, get the message
4567: FND_MSG_PUB.Count_And_Get (
4568: p_encoded => FND_API.G_FALSE,
4569: p_count => x_msg_count,
4570: p_data => x_msg_data
4571: );

Line 4576: FND_MSG_PUB.Count_And_Get (

4572: EXCEPTION
4573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4575: -- Standard call to get message count and if count=1, get the message
4576: FND_MSG_PUB.Count_And_Get (
4577: p_encoded => FND_API.G_FALSE,
4578: p_count => x_msg_count,
4579: p_data => x_msg_data
4580: );

Line 4584: FND_MSG_PUB.Count_And_Get (

4580: );
4581: WHEN FND_API.G_EXC_ERROR THEN
4582: x_return_status := FND_API.G_RET_STS_ERROR;
4583: -- Standard call to get message count and if count=1, get the message
4584: FND_MSG_PUB.Count_And_Get (
4585: p_encoded => FND_API.G_FALSE,
4586: p_count => x_msg_count,
4587: p_data => x_msg_data
4588: );

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

4587: p_data => x_msg_data
4588: );
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4593: END IF;
4594: -- Standard call to get message count and if count=1, get the message
4595: FND_MSG_PUB.Count_And_Get (

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

4588: );
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4593: END IF;
4594: -- Standard call to get message count and if count=1, get the message
4595: FND_MSG_PUB.Count_And_Get (
4596: p_encoded => FND_API.G_FALSE,

Line 4595: FND_MSG_PUB.Count_And_Get (

4591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4592: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4593: END IF;
4594: -- Standard call to get message count and if count=1, get the message
4595: FND_MSG_PUB.Count_And_Get (
4596: p_encoded => FND_API.G_FALSE,
4597: p_count => x_msg_count,
4598: p_data => x_msg_data
4599: );

Line 4647: FND_MSG_PUB.initialize;

4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: END IF;
4645: --Initialize message list if p_init_msg_list is TRUE.
4646: IF FND_API.To_Boolean (p_init_msg_list) THEN
4647: FND_MSG_PUB.initialize;
4648: END IF;
4649: -- Initialize API return status to success
4650: x_return_status := FND_API.G_RET_STS_SUCCESS;
4651: -- Get the current (login) user id.

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

4658: IF (p_check_login_user = FND_API.G_TRUE) THEN
4659: -- Check if user is login and has the required privilege.
4660: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4661: -- User is not login.
4662: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4663: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4664: FND_MSG_PUB.Add;
4665: END IF;
4666: RAISE FND_API.G_EXC_ERROR;

Line 4664: FND_MSG_PUB.Add;

4660: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4661: -- User is not login.
4662: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4663: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4664: FND_MSG_PUB.Add;
4665: END IF;
4666: RAISE FND_API.G_EXC_ERROR;
4667: END IF;
4668: AMV_USER_PVT.Is_Administrator

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

4676: x_result_flag => l_admin_flag
4677: );
4678: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4679: -- User is not an administrator.
4680: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4681: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4682: FND_MSG_PUB.Add;
4683: END IF;
4684: RAISE FND_API.G_EXC_ERROR;

Line 4682: FND_MSG_PUB.Add;

4678: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4679: -- User is not an administrator.
4680: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4681: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4682: FND_MSG_PUB.Add;
4683: END IF;
4684: RAISE FND_API.G_EXC_ERROR;
4685: END IF;
4686: END IF;

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

4690: l_current_user_id := -1;
4691: END IF;
4692: -- Check if the group id is valid
4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4695: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4696: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4697: FND_MSG_PUB.Add;
4698: END IF;

Line 4697: FND_MSG_PUB.Add;

4693: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4695: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4696: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4697: FND_MSG_PUB.Add;
4698: END IF;
4699: RAISE FND_API.G_EXC_ERROR;
4700: END IF;
4701: -- Check if the resource id is valid

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

4699: RAISE FND_API.G_EXC_ERROR;
4700: END IF;
4701: -- Check if the resource id is valid
4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
4703: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4704: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
4705: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
4706: FND_MSG_PUB.Add;
4707: END IF;

Line 4706: FND_MSG_PUB.Add;

4702: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(p_resource_id) <> TRUE) THEN
4703: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4704: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
4705: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_resource_id, -1) ) );
4706: FND_MSG_PUB.Add;
4707: END IF;
4708: RAISE FND_API.G_EXC_ERROR;
4709: END IF;
4710: --

Line 4732: FND_MSG_PUB.Count_And_Get (

4728: ELSE
4729: CLOSE Check_groupMember_csr;
4730: END IF;
4731: --Standard call to get message count and if count=1, get the message
4732: FND_MSG_PUB.Count_And_Get (
4733: p_encoded => FND_API.G_FALSE,
4734: p_count => x_msg_count,
4735: p_data => x_msg_data
4736: );

Line 4742: FND_MSG_PUB.Count_And_Get (

4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: ROLLBACK TO Add_groupMember_Pvt;
4740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4741: -- Standard call to get message count and if count=1, get the message
4742: FND_MSG_PUB.Count_And_Get (
4743: p_encoded => FND_API.G_FALSE,
4744: p_count => x_msg_count,
4745: p_data => x_msg_data
4746: );

Line 4751: FND_MSG_PUB.Count_And_Get (

4747: WHEN FND_API.G_EXC_ERROR THEN
4748: ROLLBACK TO Add_groupMember_Pvt;
4749: x_return_status := FND_API.G_RET_STS_ERROR;
4750: -- Standard call to get message count and if count=1, get the message
4751: FND_MSG_PUB.Count_And_Get (
4752: p_encoded => FND_API.G_FALSE,
4753: p_count => x_msg_count,
4754: p_data => x_msg_data
4755: );

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

4755: );
4756: WHEN OTHERS THEN
4757: ROLLBACK TO Add_groupMember_Pvt;
4758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4761: END IF;
4762: -- Standard call to get message count and if count=1, get the message
4763: FND_MSG_PUB.Count_And_Get (

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

4756: WHEN OTHERS THEN
4757: ROLLBACK TO Add_groupMember_Pvt;
4758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4761: END IF;
4762: -- Standard call to get message count and if count=1, get the message
4763: FND_MSG_PUB.Count_And_Get (
4764: p_encoded => FND_API.G_FALSE,

Line 4763: FND_MSG_PUB.Count_And_Get (

4759: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4761: END IF;
4762: -- Standard call to get message count and if count=1, get the message
4763: FND_MSG_PUB.Count_And_Get (
4764: p_encoded => FND_API.G_FALSE,
4765: p_count => x_msg_count,
4766: p_data => x_msg_data
4767: );

Line 4808: FND_MSG_PUB.initialize;

4804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4805: END IF;
4806: --Initialize message list if p_init_msg_list is TRUE.
4807: IF FND_API.To_Boolean (p_init_msg_list) THEN
4808: FND_MSG_PUB.initialize;
4809: END IF;
4810: -- Initialize API return status to success
4811: x_return_status := FND_API.G_RET_STS_SUCCESS;
4812: -- Get the current (login) user id.

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

4819: IF (p_check_login_user = FND_API.G_TRUE) THEN
4820: -- Check if user is login and has the required privilege.
4821: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4822: -- User is not login.
4823: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4824: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4825: FND_MSG_PUB.Add;
4826: END IF;
4827: RAISE FND_API.G_EXC_ERROR;

Line 4825: FND_MSG_PUB.Add;

4821: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4822: -- User is not login.
4823: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4824: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4825: FND_MSG_PUB.Add;
4826: END IF;
4827: RAISE FND_API.G_EXC_ERROR;
4828: END IF;
4829: AMV_USER_PVT.Is_Administrator

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

4837: x_result_flag => l_admin_flag
4838: );
4839: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4840: -- User is not an administrator.
4841: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4842: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4843: FND_MSG_PUB.Add;
4844: END IF;
4845: RAISE FND_API.G_EXC_ERROR;

Line 4843: FND_MSG_PUB.Add;

4839: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4840: -- User is not an administrator.
4841: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4842: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4843: FND_MSG_PUB.Add;
4844: END IF;
4845: RAISE FND_API.G_EXC_ERROR;
4846: END IF;
4847: END IF;

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

4851: l_current_user_id := -1;
4852: END IF;
4853: -- Check if the group id is valid
4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4855: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4856: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4857: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4858: FND_MSG_PUB.Add;
4859: END IF;

Line 4858: FND_MSG_PUB.Add;

4854: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
4855: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4856: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
4857: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
4858: FND_MSG_PUB.Add;
4859: END IF;
4860: RAISE FND_API.G_EXC_ERROR;
4861: END IF;
4862: FOR i IN 1..p_resource_id_varray.count LOOP

Line 4883: FND_MSG_PUB.Count_And_Get (

4879: x_return_status := FND_API.G_RET_STS_ERROR;
4880: END IF;
4881: END LOOP;
4882: --Standard call to get message count and if count=1, get the message
4883: FND_MSG_PUB.Count_And_Get (
4884: p_encoded => FND_API.G_FALSE,
4885: p_count => x_msg_count,
4886: p_data => x_msg_data
4887: );

Line 4893: FND_MSG_PUB.Count_And_Get (

4889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4890: ROLLBACK TO Add_groupMember_Pvt;
4891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4892: -- Standard call to get message count and if count=1, get the message
4893: FND_MSG_PUB.Count_And_Get (
4894: p_encoded => FND_API.G_FALSE,
4895: p_count => x_msg_count,
4896: p_data => x_msg_data
4897: );

Line 4902: FND_MSG_PUB.Count_And_Get (

4898: WHEN FND_API.G_EXC_ERROR THEN
4899: ROLLBACK TO Add_groupMember_Pvt;
4900: x_return_status := FND_API.G_RET_STS_ERROR;
4901: -- Standard call to get message count and if count=1, get the message
4902: FND_MSG_PUB.Count_And_Get (
4903: p_encoded => FND_API.G_FALSE,
4904: p_count => x_msg_count,
4905: p_data => x_msg_data
4906: );

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

4906: );
4907: WHEN OTHERS THEN
4908: ROLLBACK TO Add_groupMember_Pvt;
4909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4910: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4911: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4912: END IF;
4913: -- Standard call to get message count and if count=1, get the message
4914: FND_MSG_PUB.Count_And_Get (

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

4907: WHEN OTHERS THEN
4908: ROLLBACK TO Add_groupMember_Pvt;
4909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4910: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4911: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4912: END IF;
4913: -- Standard call to get message count and if count=1, get the message
4914: FND_MSG_PUB.Count_And_Get (
4915: p_encoded => FND_API.G_FALSE,

Line 4914: FND_MSG_PUB.Count_And_Get (

4910: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4911: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4912: END IF;
4913: -- Standard call to get message count and if count=1, get the message
4914: FND_MSG_PUB.Count_And_Get (
4915: p_encoded => FND_API.G_FALSE,
4916: p_count => x_msg_count,
4917: p_data => x_msg_data
4918: );

Line 4963: FND_MSG_PUB.initialize;

4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4960: END IF;
4961: --Initialize message list if p_init_msg_list is TRUE.
4962: IF FND_API.To_Boolean (p_init_msg_list) THEN
4963: FND_MSG_PUB.initialize;
4964: END IF;
4965: -- Initialize API return status to success
4966: x_return_status := FND_API.G_RET_STS_SUCCESS;
4967: -- Get the current (login) user id.

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

4974: IF (p_check_login_user = FND_API.G_TRUE) THEN
4975: -- Check if user is login and has the required privilege.
4976: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4977: -- User is not login.
4978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4979: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4980: FND_MSG_PUB.Add;
4981: END IF;
4982: RAISE FND_API.G_EXC_ERROR;

Line 4980: FND_MSG_PUB.Add;

4976: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
4977: -- User is not login.
4978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4979: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4980: FND_MSG_PUB.Add;
4981: END IF;
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984: AMV_USER_PVT.Is_Administrator

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

4992: x_result_flag => l_admin_flag
4993: );
4994: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4995: -- User is not an administrator.
4996: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4997: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4998: FND_MSG_PUB.Add;
4999: END IF;
5000: RAISE FND_API.G_EXC_ERROR;

Line 4998: FND_MSG_PUB.Add;

4994: IF (l_admin_flag <> FND_API.G_TRUE) THEN
4995: -- User is not an administrator.
4996: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4997: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
4998: FND_MSG_PUB.Add;
4999: END IF;
5000: RAISE FND_API.G_EXC_ERROR;
5001: END IF;
5002: END IF;

Line 5029: FND_MSG_PUB.Count_And_Get (

5025: ELSE
5026: CLOSE Check_groupMember_csr;
5027: END IF;
5028: --Standard call to get message count and if count=1, get the message
5029: FND_MSG_PUB.Count_And_Get (
5030: p_encoded => FND_API.G_FALSE,
5031: p_count => x_msg_count,
5032: p_data => x_msg_data
5033: );

Line 5039: FND_MSG_PUB.Count_And_Get (

5035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5036: ROLLBACK TO Remove_GroupMember_Pvt;
5037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5038: -- Standard call to get message count and if count=1, get the message
5039: FND_MSG_PUB.Count_And_Get (
5040: p_encoded => FND_API.G_FALSE,
5041: p_count => x_msg_count,
5042: p_data => x_msg_data
5043: );

Line 5048: FND_MSG_PUB.Count_And_Get (

5044: WHEN FND_API.G_EXC_ERROR THEN
5045: ROLLBACK TO Remove_GroupMember_Pvt;
5046: x_return_status := FND_API.G_RET_STS_ERROR;
5047: -- Standard call to get message count and if count=1, get the message
5048: FND_MSG_PUB.Count_And_Get (
5049: p_encoded => FND_API.G_FALSE,
5050: p_count => x_msg_count,
5051: p_data => x_msg_data
5052: );

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

5052: );
5053: WHEN OTHERS THEN
5054: ROLLBACK TO Remove_GroupMember_Pvt;
5055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5058: END IF;
5059: -- Standard call to get message count and if count=1, get the message
5060: FND_MSG_PUB.Count_And_Get (

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

5053: WHEN OTHERS THEN
5054: ROLLBACK TO Remove_GroupMember_Pvt;
5055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5058: END IF;
5059: -- Standard call to get message count and if count=1, get the message
5060: FND_MSG_PUB.Count_And_Get (
5061: p_encoded => FND_API.G_FALSE,

Line 5060: FND_MSG_PUB.Count_And_Get (

5056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5058: END IF;
5059: -- Standard call to get message count and if count=1, get the message
5060: FND_MSG_PUB.Count_And_Get (
5061: p_encoded => FND_API.G_FALSE,
5062: p_count => x_msg_count,
5063: p_data => x_msg_data
5064: );

Line 5106: FND_MSG_PUB.initialize;

5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: END IF;
5104: --Initialize message list if p_init_msg_list is TRUE.
5105: IF FND_API.To_Boolean (p_init_msg_list) THEN
5106: FND_MSG_PUB.initialize;
5107: END IF;
5108: -- Initialize API return status to success
5109: x_return_status := FND_API.G_RET_STS_SUCCESS;
5110: -- Get the current (login) user id.

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

5117: IF (p_check_login_user = FND_API.G_TRUE) THEN
5118: -- Check if user is login and has the required privilege.
5119: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5120: -- User is not login.
5121: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5122: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5123: FND_MSG_PUB.Add;
5124: END IF;
5125: RAISE FND_API.G_EXC_ERROR;

Line 5123: FND_MSG_PUB.Add;

5119: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5120: -- User is not login.
5121: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5122: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5123: FND_MSG_PUB.Add;
5124: END IF;
5125: RAISE FND_API.G_EXC_ERROR;
5126: END IF;
5127: AMV_USER_PVT.Is_Administrator

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

5135: x_result_flag => l_admin_flag
5136: );
5137: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5138: -- User is not an administrator.
5139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5140: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5141: FND_MSG_PUB.Add;
5142: END IF;
5143: RAISE FND_API.G_EXC_ERROR;

Line 5141: FND_MSG_PUB.Add;

5137: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5138: -- User is not an administrator.
5139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5140: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5141: FND_MSG_PUB.Add;
5142: END IF;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145: END IF;

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

5149: l_current_user_id := -1;
5150: END IF;
5151: -- Check if the group id is valid
5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
5153: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5154: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5155: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
5156: FND_MSG_PUB.Add;
5157: END IF;

Line 5156: FND_MSG_PUB.Add;

5152: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(p_group_id) <> TRUE) THEN
5153: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5154: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5155: FND_MESSAGE.Set_Token('ID', TO_CHAR( NVL(p_group_id, -1) ) );
5156: FND_MSG_PUB.Add;
5157: END IF;
5158: RAISE FND_API.G_EXC_ERROR;
5159: END IF;
5160: IF (p_resource_id_varray IS NULL) THEN

Line 5186: FND_MSG_PUB.Count_And_Get (

5182: x_return_status := FND_API.G_RET_STS_ERROR;
5183: END IF;
5184: END LOOP;
5185: --Standard call to get message count and if count=1, get the message
5186: FND_MSG_PUB.Count_And_Get (
5187: p_encoded => FND_API.G_FALSE,
5188: p_count => x_msg_count,
5189: p_data => x_msg_data
5190: );

Line 5196: FND_MSG_PUB.Count_And_Get (

5192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5193: ROLLBACK TO Remove_GroupMember_Pvt;
5194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5195: -- Standard call to get message count and if count=1, get the message
5196: FND_MSG_PUB.Count_And_Get (
5197: p_encoded => FND_API.G_FALSE,
5198: p_count => x_msg_count,
5199: p_data => x_msg_data
5200: );

Line 5205: FND_MSG_PUB.Count_And_Get (

5201: WHEN FND_API.G_EXC_ERROR THEN
5202: ROLLBACK TO Remove_GroupMember_Pvt;
5203: x_return_status := FND_API.G_RET_STS_ERROR;
5204: -- Standard call to get message count and if count=1, get the message
5205: FND_MSG_PUB.Count_And_Get (
5206: p_encoded => FND_API.G_FALSE,
5207: p_count => x_msg_count,
5208: p_data => x_msg_data
5209: );

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

5209: );
5210: WHEN OTHERS THEN
5211: ROLLBACK TO Remove_GroupMember_Pvt;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5215: END IF;
5216: -- Standard call to get message count and if count=1, get the message
5217: FND_MSG_PUB.Count_And_Get (

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

5210: WHEN OTHERS THEN
5211: ROLLBACK TO Remove_GroupMember_Pvt;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5215: END IF;
5216: -- Standard call to get message count and if count=1, get the message
5217: FND_MSG_PUB.Count_And_Get (
5218: p_encoded => FND_API.G_FALSE,

Line 5217: FND_MSG_PUB.Count_And_Get (

5213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5215: END IF;
5216: -- Standard call to get message count and if count=1, get the message
5217: FND_MSG_PUB.Count_And_Get (
5218: p_encoded => FND_API.G_FALSE,
5219: p_count => x_msg_count,
5220: p_data => x_msg_data
5221: );

Line 5269: FND_MSG_PUB.initialize;

5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: END IF;
5267: --Initialize message list if p_init_msg_list is TRUE.
5268: IF FND_API.To_Boolean (p_init_msg_list) THEN
5269: FND_MSG_PUB.initialize;
5270: END IF;
5271: -- Initialize API return status to success
5272: x_return_status := FND_API.G_RET_STS_SUCCESS;
5273: x_result_flag := FND_API.G_FALSE;

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

5281: IF (p_check_login_user = FND_API.G_TRUE) THEN
5282: -- Check if user is login and has the required privilege.
5283: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5284: -- User is not login.
5285: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5286: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5287: FND_MSG_PUB.Add;
5288: END IF;
5289: RAISE FND_API.G_EXC_ERROR;

Line 5287: FND_MSG_PUB.Add;

5283: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5284: -- User is not login.
5285: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5286: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5287: FND_MSG_PUB.Add;
5288: END IF;
5289: RAISE FND_API.G_EXC_ERROR;
5290: END IF;
5291: END IF;

Line 5299: FND_MSG_PUB.Count_And_Get (

5295: x_result_flag := FND_API.G_TRUE;
5296: END IF;
5297: CLOSE Check_groupMember_csr;
5298: --Standard call to get message count and if count=1, get the message
5299: FND_MSG_PUB.Count_And_Get (
5300: p_encoded => FND_API.G_FALSE,
5301: p_count => x_msg_count,
5302: p_data => x_msg_data
5303: );

Line 5308: FND_MSG_PUB.Count_And_Get (

5304: EXCEPTION
5305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5307: -- Standard call to get message count and if count=1, get the message
5308: FND_MSG_PUB.Count_And_Get (
5309: p_encoded => FND_API.G_FALSE,
5310: p_count => x_msg_count,
5311: p_data => x_msg_data
5312: );

Line 5316: FND_MSG_PUB.Count_And_Get (

5312: );
5313: WHEN FND_API.G_EXC_ERROR THEN
5314: x_return_status := FND_API.G_RET_STS_ERROR;
5315: -- Standard call to get message count and if count=1, get the message
5316: FND_MSG_PUB.Count_And_Get (
5317: p_encoded => FND_API.G_FALSE,
5318: p_count => x_msg_count,
5319: p_data => x_msg_data
5320: );

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

5319: p_data => x_msg_data
5320: );
5321: WHEN OTHERS THEN
5322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5325: END IF;
5326: -- Standard call to get message count and if count=1, get the message
5327: FND_MSG_PUB.Count_And_Get (

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

5320: );
5321: WHEN OTHERS THEN
5322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5325: END IF;
5326: -- Standard call to get message count and if count=1, get the message
5327: FND_MSG_PUB.Count_And_Get (
5328: p_encoded => FND_API.G_FALSE,

Line 5327: FND_MSG_PUB.Count_And_Get (

5323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5325: END IF;
5326: -- Standard call to get message count and if count=1, get the message
5327: FND_MSG_PUB.Count_And_Get (
5328: p_encoded => FND_API.G_FALSE,
5329: p_count => x_msg_count,
5330: p_data => x_msg_data
5331: );

Line 5379: FND_MSG_PUB.initialize;

5375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5376: END IF;
5377: --Initialize message list if p_init_msg_list is TRUE.
5378: IF FND_API.To_Boolean (p_init_msg_list) THEN
5379: FND_MSG_PUB.initialize;
5380: END IF;
5381: -- Initialize API return status to success
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: -- Get the current (login) user id.

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

5390: IF (p_check_login_user = FND_API.G_TRUE) THEN
5391: -- Check if user is login and has the required privilege.
5392: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5393: -- User is not login.
5394: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5395: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5396: FND_MSG_PUB.Add;
5397: END IF;
5398: RAISE FND_API.G_EXC_ERROR;

Line 5396: FND_MSG_PUB.Add;

5392: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5393: -- User is not login.
5394: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5395: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5396: FND_MSG_PUB.Add;
5397: END IF;
5398: RAISE FND_API.G_EXC_ERROR;
5399: END IF;
5400: -- We might not need this one.

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

5409: x_result_flag => l_admin_flag
5410: );
5411: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5412: -- User is not an administrator.
5413: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5414: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5415: FND_MSG_PUB.Add;
5416: END IF;
5417: RAISE FND_API.G_EXC_ERROR;

Line 5415: FND_MSG_PUB.Add;

5411: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5412: -- User is not an administrator.
5413: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5414: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5415: FND_MSG_PUB.Add;
5416: END IF;
5417: RAISE FND_API.G_EXC_ERROR;
5418: END IF;
5419: END IF;

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

5422: l_current_login_id := -1;
5423: l_current_user_id := -1;
5424: END IF;
5425: IF (l_access_obj.access_id IS NULL) THEN
5426: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5427: FND_MESSAGE.Set_name('AMV','AMV_NULL_ACCESS_OBJ');
5428: FND_MSG_PUB.Add;
5429: END IF;
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5428: FND_MSG_PUB.Add;

5424: END IF;
5425: IF (l_access_obj.access_id IS NULL) THEN
5426: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5427: FND_MESSAGE.Set_name('AMV','AMV_NULL_ACCESS_OBJ');
5428: FND_MSG_PUB.Add;
5429: END IF;
5430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5431: END IF;
5432:

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

5443: IF (l_access_obj.user_or_group_type = G_GROUP_ARC_TYPE) THEN
5444: -- Check if the Group id is valid
5445: IF (AMV_UTILITY_PVT.IS_GROUPIDVALID(l_access_obj.user_or_group_id)
5446: <> TRUE) THEN
5447: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5448: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5449: FND_MESSAGE.Set_Token('ID',
5450: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5451: FND_MSG_PUB.Add;

Line 5451: FND_MSG_PUB.Add;

5447: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5448: FND_MESSAGE.Set_name('AMV','AMV_INVALID_GROUP_ID');
5449: FND_MESSAGE.Set_Token('ID',
5450: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5451: FND_MSG_PUB.Add;
5452: END IF;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455: ELSIF (l_access_obj.user_or_group_type = G_USER_ARC_TYPE) THEN

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

5455: ELSIF (l_access_obj.user_or_group_type = G_USER_ARC_TYPE) THEN
5456: -- Check if the resource id is valid
5457: IF (AMV_UTILITY_PVT.IS_RESOURCEIDVALID(l_access_obj.user_or_group_id)
5458: <> TRUE) THEN
5459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5460: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
5461: FND_MESSAGE.Set_Token('ID',
5462: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5463: FND_MSG_PUB.Add;

Line 5463: FND_MSG_PUB.Add;

5459: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5460: FND_MESSAGE.Set_name('AMV','AMV_INVALID_RESOURCE_ID');
5461: FND_MESSAGE.Set_Token('ID',
5462: TO_CHAR( NVL(l_access_obj.user_or_group_id,-1)) );
5463: FND_MSG_PUB.Add;
5464: END IF;
5465: RAISE FND_API.G_EXC_ERROR;
5466: END IF;
5467: ELSE

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

5464: END IF;
5465: RAISE FND_API.G_EXC_ERROR;
5466: END IF;
5467: ELSE
5468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5469: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_USER_TYPE');
5470: FND_MSG_PUB.Add;
5471: END IF;
5472: RAISE FND_API.G_EXC_ERROR;

Line 5470: FND_MSG_PUB.Add;

5466: END IF;
5467: ELSE
5468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5469: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_USER_TYPE');
5470: FND_MSG_PUB.Add;
5471: END IF;
5472: RAISE FND_API.G_EXC_ERROR;
5473: END IF;
5474: IF (l_access_obj.access_to_table_code = G_ITEM_ARC_TYPE) THEN

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

5474: IF (l_access_obj.access_to_table_code = G_ITEM_ARC_TYPE) THEN
5475: -- Check if the item id is valid
5476: IF (AMV_UTILITY_PVT.IS_ITEMIDVALID(
5477: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5478: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_name('AMV','AMV_INVALID_ITEM_ID');
5480: FND_MESSAGE.Set_Token('ID',
5481: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5482: FND_MSG_PUB.Add;

Line 5482: FND_MSG_PUB.Add;

5478: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5479: FND_MESSAGE.Set_name('AMV','AMV_INVALID_ITEM_ID');
5480: FND_MESSAGE.Set_Token('ID',
5481: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5482: FND_MSG_PUB.Add;
5483: END IF;
5484: RAISE FND_API.G_EXC_ERROR;
5485: END IF;
5486: ELSIF (l_access_obj.access_to_table_code = G_CHAN_ARC_TYPE) THEN

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

5486: ELSIF (l_access_obj.access_to_table_code = G_CHAN_ARC_TYPE) THEN
5487: -- Check if the channel id is valid
5488: IF (AMV_UTILITY_PVT.IS_CHANNELIDVALID(
5489: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5490: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5491: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CHANEL_ID');
5492: FND_MESSAGE.Set_Token('ID',
5493: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5494: FND_MSG_PUB.Add;

Line 5494: FND_MSG_PUB.Add;

5490: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5491: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CHANEL_ID');
5492: FND_MESSAGE.Set_Token('ID',
5493: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5494: FND_MSG_PUB.Add;
5495: END IF;
5496: RAISE FND_API.G_EXC_ERROR;
5497: END IF;
5498: ELSIF (l_access_obj.access_to_table_code = G_CATE_ARC_TYPE) THEN

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

5498: ELSIF (l_access_obj.access_to_table_code = G_CATE_ARC_TYPE) THEN
5499: -- Check if the category id is valid
5500: IF (AMV_UTILITY_PVT.IS_CATEGORYIDVALID(
5501: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5502: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5503: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
5504: FND_MESSAGE.Set_Token('ID',
5505: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5506: FND_MSG_PUB.Add;

Line 5506: FND_MSG_PUB.Add;

5502: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5503: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CATEGORY_ID');
5504: FND_MESSAGE.Set_Token('ID',
5505: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5506: FND_MSG_PUB.Add;
5507: END IF;
5508: RAISE FND_API.G_EXC_ERROR;
5509: END IF;
5510: ELSIF (l_access_obj.access_to_table_code = G_APPL_ARC_TYPE) THEN

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

5510: ELSIF (l_access_obj.access_to_table_code = G_APPL_ARC_TYPE) THEN
5511: -- Check if the application id is valid
5512: IF (AMV_UTILITY_PVT.IS_APPLIDVALID(
5513: l_access_obj.access_to_table_record_id) <> TRUE) THEN
5514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5515: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPLICATION_ID');
5516: FND_MESSAGE.Set_Token('ID',
5517: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5518: FND_MSG_PUB.Add;

Line 5518: FND_MSG_PUB.Add;

5514: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5515: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPLICATION_ID');
5516: FND_MESSAGE.Set_Token('ID',
5517: TO_CHAR( NVL(l_access_obj.access_to_table_record_id,-1)) );
5518: FND_MSG_PUB.Add;
5519: END IF;
5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: ELSE

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

5519: END IF;
5520: RAISE FND_API.G_EXC_ERROR;
5521: END IF;
5522: ELSE
5523: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5524: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_TABLE_TYPE');
5525: FND_MSG_PUB.Add;
5526: END IF;
5527: RAISE FND_API.G_EXC_ERROR;

Line 5525: FND_MSG_PUB.Add;

5521: END IF;
5522: ELSE
5523: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5524: FND_MESSAGE.Set_name('AMV','AMV_WRONG_ACCESS_TABLE_TYPE');
5525: FND_MSG_PUB.Add;
5526: END IF;
5527: RAISE FND_API.G_EXC_ERROR;
5528: END IF;
5529: IF (l_access_obj.effective_start_date = FND_API.G_MISS_DATE

Line 5614: FND_MSG_PUB.Count_And_Get (

5610: IF FND_API.To_Boolean ( p_commit ) THEN
5611: COMMIT WORK;
5612: END IF;
5613: --Standard call to get message count and if count=1, get the message
5614: FND_MSG_PUB.Count_And_Get (
5615: p_encoded => FND_API.G_FALSE,
5616: p_count => x_msg_count,
5617: p_data => x_msg_data
5618: );

Line 5624: FND_MSG_PUB.Count_And_Get (

5620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5621: ROLLBACK TO Update_Access_Pvt;
5622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5623: -- Standard call to get message count and if count=1, get the message
5624: FND_MSG_PUB.Count_And_Get (
5625: p_encoded => FND_API.G_FALSE,
5626: p_count => x_msg_count,
5627: p_data => x_msg_data
5628: );

Line 5633: FND_MSG_PUB.Count_And_Get (

5629: WHEN FND_API.G_EXC_ERROR THEN
5630: ROLLBACK TO Update_Access_Pvt;
5631: x_return_status := FND_API.G_RET_STS_ERROR;
5632: -- Standard call to get message count and if count=1, get the message
5633: FND_MSG_PUB.Count_And_Get (
5634: p_encoded => FND_API.G_FALSE,
5635: p_count => x_msg_count,
5636: p_data => x_msg_data
5637: );

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

5637: );
5638: WHEN OTHERS THEN
5639: ROLLBACK TO Update_Access_Pvt;
5640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5643: END IF;
5644: -- Standard call to get message count and if count=1, get the message
5645: FND_MSG_PUB.Count_And_Get (

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

5638: WHEN OTHERS THEN
5639: ROLLBACK TO Update_Access_Pvt;
5640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5643: END IF;
5644: -- Standard call to get message count and if count=1, get the message
5645: FND_MSG_PUB.Count_And_Get (
5646: p_encoded => FND_API.G_FALSE,

Line 5645: FND_MSG_PUB.Count_And_Get (

5641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5643: END IF;
5644: -- Standard call to get message count and if count=1, get the message
5645: FND_MSG_PUB.Count_And_Get (
5646: p_encoded => FND_API.G_FALSE,
5647: p_count => x_msg_count,
5648: p_data => x_msg_data
5649: );

Line 5687: FND_MSG_PUB.initialize;

5683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5684: END IF;
5685: --Initialize message list if p_init_msg_list is TRUE.
5686: IF FND_API.To_Boolean (p_init_msg_list) THEN
5687: FND_MSG_PUB.initialize;
5688: END IF;
5689: -- Initialize API return status to success
5690: x_return_status := FND_API.G_RET_STS_SUCCESS;
5691: -- Get the current (login) user id.

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

5698: IF (p_check_login_user = FND_API.G_TRUE) THEN
5699: -- Check if user is login and has the required privilege.
5700: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5701: -- User is not login.
5702: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5703: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5704: FND_MSG_PUB.Add;
5705: END IF;
5706: RAISE FND_API.G_EXC_ERROR;

Line 5704: FND_MSG_PUB.Add;

5700: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
5701: -- User is not login.
5702: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5703: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
5704: FND_MSG_PUB.Add;
5705: END IF;
5706: RAISE FND_API.G_EXC_ERROR;
5707: END IF;
5708: -- We might not need this one.

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

5717: x_result_flag => l_admin_flag
5718: );
5719: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5720: -- User is not an administrator.
5721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5722: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5723: FND_MSG_PUB.Add;
5724: END IF;
5725: RAISE FND_API.G_EXC_ERROR;

Line 5723: FND_MSG_PUB.Add;

5719: IF (l_admin_flag <> FND_API.G_TRUE) THEN
5720: -- User is not an administrator.
5721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5722: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
5723: FND_MSG_PUB.Add;
5724: END IF;
5725: RAISE FND_API.G_EXC_ERROR;
5726: END IF;
5727: END IF;

Line 5758: FND_MSG_PUB.Count_And_Get (

5754: x_return_status := FND_API.G_RET_STS_ERROR;
5755: END IF;
5756: END LOOP;
5757: --Standard call to get message count and if count=1, get the message
5758: FND_MSG_PUB.Count_And_Get (
5759: p_encoded => FND_API.G_FALSE,
5760: p_count => x_msg_count,
5761: p_data => x_msg_data
5762: );

Line 5768: FND_MSG_PUB.Count_And_Get (

5764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5765: ROLLBACK TO Update_Access_Pvt;
5766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5767: -- Standard call to get message count and if count=1, get the message
5768: FND_MSG_PUB.Count_And_Get (
5769: p_encoded => FND_API.G_FALSE,
5770: p_count => x_msg_count,
5771: p_data => x_msg_data
5772: );

Line 5777: FND_MSG_PUB.Count_And_Get (

5773: WHEN FND_API.G_EXC_ERROR THEN
5774: ROLLBACK TO Update_Access_Pvt;
5775: x_return_status := FND_API.G_RET_STS_ERROR;
5776: -- Standard call to get message count and if count=1, get the message
5777: FND_MSG_PUB.Count_And_Get (
5778: p_encoded => FND_API.G_FALSE,
5779: p_count => x_msg_count,
5780: p_data => x_msg_data
5781: );

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

5781: );
5782: WHEN OTHERS THEN
5783: ROLLBACK TO Update_Access_Pvt;
5784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5787: END IF;
5788: -- Standard call to get message count and if count=1, get the message
5789: FND_MSG_PUB.Count_And_Get (

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

5782: WHEN OTHERS THEN
5783: ROLLBACK TO Update_Access_Pvt;
5784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5787: END IF;
5788: -- Standard call to get message count and if count=1, get the message
5789: FND_MSG_PUB.Count_And_Get (
5790: p_encoded => FND_API.G_FALSE,

Line 5789: FND_MSG_PUB.Count_And_Get (

5785: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5787: END IF;
5788: -- Standard call to get message count and if count=1, get the message
5789: FND_MSG_PUB.Count_And_Get (
5790: p_encoded => FND_API.G_FALSE,
5791: p_count => x_msg_count,
5792: p_data => x_msg_data
5793: );

Line 6397: FND_MSG_PUB.initialize;

6393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6394: END IF;
6395: --Initialize message list if p_init_msg_list is TRUE.
6396: IF FND_API.To_Boolean (p_init_msg_list) THEN
6397: FND_MSG_PUB.initialize;
6398: END IF;
6399: -- Initialize API return status to success
6400: x_return_status := FND_API.G_RET_STS_SUCCESS;
6401: -- Get the current (login) user id.

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

6408: IF (p_check_login_user = FND_API.G_TRUE) THEN
6409: -- Check if user is login and has the required privilege.
6410: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6411: -- User is not login.
6412: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6413: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: RAISE FND_API.G_EXC_ERROR;

Line 6414: FND_MSG_PUB.Add;

6410: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6411: -- User is not login.
6412: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6413: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6414: FND_MSG_PUB.Add;
6415: END IF;
6416: RAISE FND_API.G_EXC_ERROR;
6417: END IF;
6418: END IF;

Line 6466: FND_MSG_PUB.Count_And_Get (

6462: );
6463: */
6464: END LOOP;
6465: --Standard call to get message count and if count=1, get the message
6466: FND_MSG_PUB.Count_And_Get (
6467: p_encoded => FND_API.G_FALSE,
6468: p_count => x_msg_count,
6469: p_data => x_msg_data
6470: );

Line 6475: FND_MSG_PUB.Count_And_Get (

6471: EXCEPTION
6472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6474: -- Standard call to get message count and if count=1, get the message
6475: FND_MSG_PUB.Count_And_Get (
6476: p_encoded => FND_API.G_FALSE,
6477: p_count => x_msg_count,
6478: p_data => x_msg_data
6479: );

Line 6483: FND_MSG_PUB.Count_And_Get (

6479: );
6480: WHEN FND_API.G_EXC_ERROR THEN
6481: x_return_status := FND_API.G_RET_STS_ERROR;
6482: -- Standard call to get message count and if count=1, get the message
6483: FND_MSG_PUB.Count_And_Get (
6484: p_encoded => FND_API.G_FALSE,
6485: p_count => x_msg_count,
6486: p_data => x_msg_data
6487: );

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

6486: p_data => x_msg_data
6487: );
6488: WHEN OTHERS THEN
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6492: END IF;
6493: -- Standard call to get message count and if count=1, get the message
6494: FND_MSG_PUB.Count_And_Get (

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

6487: );
6488: WHEN OTHERS THEN
6489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6492: END IF;
6493: -- Standard call to get message count and if count=1, get the message
6494: FND_MSG_PUB.Count_And_Get (
6495: p_encoded => FND_API.G_FALSE,

Line 6494: FND_MSG_PUB.Count_And_Get (

6490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6491: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6492: END IF;
6493: -- Standard call to get message count and if count=1, get the message
6494: FND_MSG_PUB.Count_And_Get (
6495: p_encoded => FND_API.G_FALSE,
6496: p_count => x_msg_count,
6497: p_data => x_msg_data
6498: );

Line 6584: FND_MSG_PUB.initialize;

6580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6581: END IF;
6582: --Initialize message list if p_init_msg_list is TRUE.
6583: IF FND_API.To_Boolean (p_init_msg_list) THEN
6584: FND_MSG_PUB.initialize;
6585: END IF;
6586: -- Initialize API return status to success
6587: x_return_status := FND_API.G_RET_STS_SUCCESS;
6588: -- Get the current (login) user id.

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

6595: IF (p_check_login_user = FND_API.G_TRUE) THEN
6596: -- Check if user is login and has the required privilege.
6597: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6598: -- User is not login.
6599: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6600: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6601: FND_MSG_PUB.Add;
6602: END IF;
6603: RAISE FND_API.G_EXC_ERROR;

Line 6601: FND_MSG_PUB.Add;

6597: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6598: -- User is not login.
6599: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6600: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6601: FND_MSG_PUB.Add;
6602: END IF;
6603: RAISE FND_API.G_EXC_ERROR;
6604: END IF;
6605: END IF;

Line 6700: FND_MSG_PUB.Count_And_Get (

6696: */
6697: END LOOP;
6698: END IF;
6699: --Standard call to get message count and if count=1, get the message
6700: FND_MSG_PUB.Count_And_Get (
6701: p_encoded => FND_API.G_FALSE,
6702: p_count => x_msg_count,
6703: p_data => x_msg_data
6704: );

Line 6709: FND_MSG_PUB.Count_And_Get (

6705: EXCEPTION
6706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6708: -- Standard call to get message count and if count=1, get the message
6709: FND_MSG_PUB.Count_And_Get (
6710: p_encoded => FND_API.G_FALSE,
6711: p_count => x_msg_count,
6712: p_data => x_msg_data
6713: );

Line 6717: FND_MSG_PUB.Count_And_Get (

6713: );
6714: WHEN FND_API.G_EXC_ERROR THEN
6715: x_return_status := FND_API.G_RET_STS_ERROR;
6716: -- Standard call to get message count and if count=1, get the message
6717: FND_MSG_PUB.Count_And_Get (
6718: p_encoded => FND_API.G_FALSE,
6719: p_count => x_msg_count,
6720: p_data => x_msg_data
6721: );

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

6720: p_data => x_msg_data
6721: );
6722: WHEN OTHERS THEN
6723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (

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

6721: );
6722: WHEN OTHERS THEN
6723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (
6729: p_encoded => FND_API.G_FALSE,

Line 6728: FND_MSG_PUB.Count_And_Get (

6724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6726: END IF;
6727: -- Standard call to get message count and if count=1, get the message
6728: FND_MSG_PUB.Count_And_Get (
6729: p_encoded => FND_API.G_FALSE,
6730: p_count => x_msg_count,
6731: p_data => x_msg_data
6732: );

Line 6789: FND_MSG_PUB.initialize;

6785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6786: END IF;
6787: --Initialize message list if p_init_msg_list is TRUE.
6788: IF FND_API.To_Boolean (p_init_msg_list) THEN
6789: FND_MSG_PUB.initialize;
6790: END IF;
6791: -- Initialize API return status to success
6792: x_return_status := FND_API.G_RET_STS_SUCCESS;
6793:

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

6839: IF (p_check_login_user = FND_API.G_TRUE) THEN
6840: -- Check if user is login and has the required privilege.
6841: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6842: -- User is not login.
6843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6844: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6845: FND_MSG_PUB.Add;
6846: END IF;
6847: RAISE FND_API.G_EXC_ERROR;

Line 6845: FND_MSG_PUB.Add;

6841: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
6842: -- User is not login.
6843: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6844: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6845: FND_MSG_PUB.Add;
6846: END IF;
6847: RAISE FND_API.G_EXC_ERROR;
6848: END IF;
6849: END IF;

Line 6866: FND_MSG_PUB.Count_And_Get (

6862: x_access_obj.CHL_REQUIRED_FLAG,
6863: x_access_obj.CHL_REQUIRED_NEED_NOTIF_FLAG;
6864: CLOSE Get_Access_csr;
6865: --Standard call to get message count and if count=1, get the message
6866: FND_MSG_PUB.Count_And_Get (
6867: p_encoded => FND_API.G_FALSE,
6868: p_count => x_msg_count,
6869: p_data => x_msg_data
6870: );

Line 6875: FND_MSG_PUB.Count_And_Get (

6871: EXCEPTION
6872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6874: -- Standard call to get message count and if count=1, get the message
6875: FND_MSG_PUB.Count_And_Get (
6876: p_encoded => FND_API.G_FALSE,
6877: p_count => x_msg_count,
6878: p_data => x_msg_data
6879: );

Line 6883: FND_MSG_PUB.Count_And_Get (

6879: );
6880: WHEN FND_API.G_EXC_ERROR THEN
6881: x_return_status := FND_API.G_RET_STS_ERROR;
6882: -- Standard call to get message count and if count=1, get the message
6883: FND_MSG_PUB.Count_And_Get (
6884: p_encoded => FND_API.G_FALSE,
6885: p_count => x_msg_count,
6886: p_data => x_msg_data
6887: );

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

6886: p_data => x_msg_data
6887: );
6888: WHEN OTHERS THEN
6889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6890: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6891: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6892: END IF;
6893: -- Standard call to get message count and if count=1, get the message
6894: FND_MSG_PUB.Count_And_Get (

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

6887: );
6888: WHEN OTHERS THEN
6889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6890: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6891: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6892: END IF;
6893: -- Standard call to get message count and if count=1, get the message
6894: FND_MSG_PUB.Count_And_Get (
6895: p_encoded => FND_API.G_FALSE,

Line 6894: FND_MSG_PUB.Count_And_Get (

6890: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6891: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6892: END IF;
6893: -- Standard call to get message count and if count=1, get the message
6894: FND_MSG_PUB.Count_And_Get (
6895: p_encoded => FND_API.G_FALSE,
6896: p_count => x_msg_count,
6897: p_data => x_msg_data
6898: );

Line 7052: FND_MSG_PUB.initialize;

7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END IF;
7050: --Initialize message list if p_init_msg_list is TRUE.
7051: IF FND_API.To_Boolean (p_init_msg_list) THEN
7052: FND_MSG_PUB.initialize;
7053: END IF;
7054: -- Initialize API return status to success
7055: x_return_status := FND_API.G_RET_STS_SUCCESS;
7056:

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

7086: IF (p_check_login_user = FND_API.G_TRUE) THEN
7087: -- Check if user is login and has the required privilege.
7088: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
7089: -- User is not login.
7090: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7091: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7092: FND_MSG_PUB.Add;
7093: END IF;
7094: RAISE FND_API.G_EXC_ERROR;

Line 7092: FND_MSG_PUB.Add;

7088: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
7089: -- User is not login.
7090: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7091: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7092: FND_MSG_PUB.Add;
7093: END IF;
7094: RAISE FND_API.G_EXC_ERROR;
7095: END IF;
7096: END IF;

Line 7108: FND_MSG_PUB.Count_And_Get (

7104: FETCH Get_ItemEffDate_csr INTO l_start_date, l_end_date;
7105: CLOSE Get_ItemEffDate_csr;
7106: IF (l_start_date > sysdate OR l_end_date < sysdate) THEN
7107: --Standard call to get message count and if count=1, get the message
7108: FND_MSG_PUB.Count_And_Get (
7109: p_encoded => FND_API.G_FALSE,
7110: p_count => x_msg_count,
7111: p_data => x_msg_data
7112: );

Line 7123: FND_MSG_PUB.Count_And_Get (

7119: FETCH Get_ChannelEffDate_csr INTO l_start_date, l_end_date;
7120: CLOSE Get_ChannelEffDate_csr;
7121: IF (l_start_date > sysdate OR l_end_date < sysdate) THEN
7122: --Standard call to get message count and if count=1, get the message
7123: FND_MSG_PUB.Count_And_Get (
7124: p_encoded => FND_API.G_FALSE,
7125: p_count => x_msg_count,
7126: p_data => x_msg_data
7127: );

Line 7238: FND_MSG_PUB.Count_And_Get (

7234: END LOOP;
7235: END IF;
7236: END IF; --IF (p_check_effective_date = FND_API.G_TRUE)
7237: --Standard call to get message count and if count=1, get the message
7238: FND_MSG_PUB.Count_And_Get (
7239: p_encoded => FND_API.G_FALSE,
7240: p_count => x_msg_count,
7241: p_data => x_msg_data
7242: );

Line 7247: FND_MSG_PUB.Count_And_Get (

7243: EXCEPTION
7244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7246: -- Standard call to get message count and if count=1, get the message
7247: FND_MSG_PUB.Count_And_Get (
7248: p_encoded => FND_API.G_FALSE,
7249: p_count => x_msg_count,
7250: p_data => x_msg_data
7251: );

Line 7255: FND_MSG_PUB.Count_And_Get (

7251: );
7252: WHEN FND_API.G_EXC_ERROR THEN
7253: x_return_status := FND_API.G_RET_STS_ERROR;
7254: -- Standard call to get message count and if count=1, get the message
7255: FND_MSG_PUB.Count_And_Get (
7256: p_encoded => FND_API.G_FALSE,
7257: p_count => x_msg_count,
7258: p_data => x_msg_data
7259: );

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

7258: p_data => x_msg_data
7259: );
7260: WHEN OTHERS THEN
7261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7264: END IF;
7265: -- Standard call to get message count and if count=1, get the message
7266: FND_MSG_PUB.Count_And_Get (

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

7259: );
7260: WHEN OTHERS THEN
7261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7264: END IF;
7265: -- Standard call to get message count and if count=1, get the message
7266: FND_MSG_PUB.Count_And_Get (
7267: p_encoded => FND_API.G_FALSE,

Line 7266: FND_MSG_PUB.Count_And_Get (

7262: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7264: END IF;
7265: -- Standard call to get message count and if count=1, get the message
7266: FND_MSG_PUB.Count_And_Get (
7267: p_encoded => FND_API.G_FALSE,
7268: p_count => x_msg_count,
7269: p_data => x_msg_data
7270: );