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

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

594: THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597: -- Debug Message
598: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
599: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
600: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
601: FND_MSG_PUB.Add;
602: END IF;

Line 601: FND_MSG_PUB.Add;

597: -- Debug Message
598: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
599: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
600: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
601: FND_MSG_PUB.Add;
602: END IF;
603: --Initialize message list if p_init_msg_list is TRUE.
604: IF FND_API.To_Boolean (p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;

Line 605: FND_MSG_PUB.initialize;

601: FND_MSG_PUB.Add;
602: END IF;
603: --Initialize message list if p_init_msg_list is TRUE.
604: IF FND_API.To_Boolean (p_init_msg_list) THEN
605: FND_MSG_PUB.initialize;
606: END IF;
607: -- Get the current (login) user id.
608: AMV_UTILITY_PVT.Get_UserInfo(
609: x_resource_id => l_resource_id,

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

615: IF (p_check_login_user = FND_API.G_TRUE) THEN
616: -- Check if user is login and has the required privilege.
617: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
618: -- User is not login.
619: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
620: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
621: FND_MSG_PUB.Add;
622: END IF;
623: RAISE FND_API.G_EXC_ERROR;

Line 621: FND_MSG_PUB.Add;

617: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
618: -- User is not login.
619: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
620: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
621: FND_MSG_PUB.Add;
622: END IF;
623: RAISE FND_API.G_EXC_ERROR;
624: END IF;
625: END IF;

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

644: );
645: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
646: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
647: -- parent id or name is not valid
648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
651: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
652: FND_MSG_PUB.Add;

Line 652: FND_MSG_PUB.Add;

648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
651: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
652: FND_MSG_PUB.Add;
653: END IF;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: ELSE

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

686: );
687: -- Add category if it does not exist
688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
689: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
691: THEN
692: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
693: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
694: FND_MSG_PUB.Add;

Line 694: FND_MSG_PUB.Add;

690: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
691: THEN
692: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
693: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
694: FND_MSG_PUB.Add;
695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE
698: -- set the category order

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

738: );
739: EXCEPTION
740: WHEN OTHERS THEN
741: --will log the error
742: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
743: THEN
744: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
745: FND_MESSAGE.Set_Token('ACTION', 'Adding');
746: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 747: FND_MSG_PUB.Add;

743: THEN
744: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
745: FND_MESSAGE.Set_Token('ACTION', 'Adding');
746: FND_MESSAGE.Set_Token('TABLE', 'Categories');
747: FND_MSG_PUB.Add;
748: END IF;
749: RAISE FND_API.G_EXC_ERROR;
750: END;
751: --

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

752: -- Pass the channel category id created
753: x_category_id := l_category_id;
754: END IF;
755: ELSE
756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
757: THEN
758: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
759: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
760: FND_MSG_PUB.Add;

Line 760: FND_MSG_PUB.Add;

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

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

762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: ELSE
765: -- user does not have privelege to create category
766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
767: THEN
768: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
769: FND_MESSAGE.Set_Token('LEVEL','Category');
770: FND_MSG_PUB.Add;

Line 770: FND_MSG_PUB.Add;

766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
767: THEN
768: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
769: FND_MESSAGE.Set_Token('LEVEL','Category');
770: FND_MSG_PUB.Add;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: ELSE

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

773: END IF;
774: ELSE
775: -- error while checking for user privilege
776: -- error in Can_SetupCategory
777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
778: THEN
779: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
780: FND_MESSAGE.Set_Token('LEVEL','Category');
781: FND_MSG_PUB.Add;

Line 781: FND_MSG_PUB.Add;

777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
778: THEN
779: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
780: FND_MESSAGE.Set_Token('LEVEL','Category');
781: FND_MSG_PUB.Add;
782: END IF;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785: --

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

784: END IF;
785: --
786:
787: -- Success message
788: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
789: THEN
790: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
791: FND_MESSAGE.Set_Token('ROW', l_full_name);
792: FND_MSG_PUB.Add;

Line 792: FND_MSG_PUB.Add;

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

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

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

Line 802: FND_MSG_PUB.Add;

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

Line 805: FND_MSG_PUB.Count_And_Get (

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

Line 815: FND_MSG_PUB.Count_And_Get (

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

Line 824: FND_MSG_PUB.Count_And_Get (

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

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

828: );
829: WHEN OTHERS THEN
830: ROLLBACK TO Add_Category_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
835: END IF;
836: -- Standard call to get message count and if count=1, get the message

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

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

Line 837: FND_MSG_PUB.Count_And_Get (

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

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

935: THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: END IF;
938: -- Debug Message
939: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
940: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
941: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
942: FND_MSG_PUB.Add;
943: END IF;

Line 942: FND_MSG_PUB.Add;

938: -- Debug Message
939: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
940: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
941: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
942: FND_MSG_PUB.Add;
943: END IF;
944: --Initialize message list if p_init_msg_list is TRUE.
945: IF FND_API.To_Boolean (p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;

Line 946: FND_MSG_PUB.initialize;

942: FND_MSG_PUB.Add;
943: END IF;
944: --Initialize message list if p_init_msg_list is TRUE.
945: IF FND_API.To_Boolean (p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;
947: END IF;
948: -- Get the current (login) user id.
949: AMV_UTILITY_PVT.Get_UserInfo(
950: x_resource_id => l_resource_id,

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

956: IF (p_check_login_user = FND_API.G_TRUE) THEN
957: -- Check if user is login and has the required privilege.
958: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
959: -- User is not login.
960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
962: FND_MSG_PUB.Add;
963: END IF;
964: RAISE FND_API.G_EXC_ERROR;

Line 962: FND_MSG_PUB.Add;

958: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
959: -- User is not login.
960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
962: FND_MSG_PUB.Add;
963: END IF;
964: RAISE FND_API.G_EXC_ERROR;
965: END IF;
966: END IF;

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

987: x_error_token => l_Error_Token
988: );
989: -- check if channel exists
990: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
992: THEN
993: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
995: FND_MSG_PUB.Add;

Line 995: FND_MSG_PUB.Add;

991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
992: THEN
993: FND_MESSAGE.Set_Name('AMV', 'l_Error_Msg');
994: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
995: FND_MSG_PUB.Add;
996: END IF;
997: RAISE FND_API.G_EXC_ERROR;
998: ELSE
999: -- check if the user has privilege to delete category

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

1022: THEN
1023: l_delete_category_flag := FND_API.G_TRUE;
1024: ELSE
1025: -- user does not have privilege to create category
1026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1027: THEN
1028: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1029: FND_MESSAGE.Set_Token('LEVEL','Category');
1030: FND_MSG_PUB.Add;

Line 1030: FND_MSG_PUB.Add;

1026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1027: THEN
1028: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1029: FND_MESSAGE.Set_Token('LEVEL','Category');
1030: FND_MSG_PUB.Add;
1031: END IF;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: END IF;

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

1033: END IF;
1034: END IF;
1035: ELSE
1036: -- error while user privilege check in Can_SetupCategory
1037: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1038: THEN
1039: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1040: FND_MESSAGE.Set_Token('LEVEL','Category');
1041: FND_MSG_PUB.Add;

Line 1041: FND_MSG_PUB.Add;

1037: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1038: THEN
1039: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1040: FND_MESSAGE.Set_Token('LEVEL','Category');
1041: FND_MSG_PUB.Add;
1042: END IF;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045: END IF;

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

1103: END IF;
1104: --
1105:
1106: -- Success message
1107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1108: THEN
1109: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1110: FND_MESSAGE.Set_Token('ROW', l_full_name);
1111: FND_MSG_PUB.Add;

Line 1111: FND_MSG_PUB.Add;

1107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1108: THEN
1109: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1110: FND_MESSAGE.Set_Token('ROW', l_full_name);
1111: FND_MSG_PUB.Add;
1112: END IF;
1113: --Standard check of commit
1114: IF FND_API.To_Boolean ( p_commit ) THEN
1115: COMMIT WORK;

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

1114: IF FND_API.To_Boolean ( p_commit ) THEN
1115: COMMIT WORK;
1116: END IF;
1117: -- Debug Message
1118: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1119: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1120: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1121: FND_MSG_PUB.Add;
1122: END IF;

Line 1121: FND_MSG_PUB.Add;

1117: -- Debug Message
1118: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1119: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1120: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1121: FND_MSG_PUB.Add;
1122: END IF;
1123: --Standard call to get message count and if count=1, get the message
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,

Line 1124: FND_MSG_PUB.Count_And_Get (

1120: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1121: FND_MSG_PUB.Add;
1122: END IF;
1123: --Standard call to get message count and if count=1, get the message
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );

Line 1134: FND_MSG_PUB.Count_And_Get (

1130: WHEN FND_API.G_EXC_ERROR THEN
1131: ROLLBACK TO Delete_Category_PVT;
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133: -- Standard call to get message count and if count=1, get the message
1134: FND_MSG_PUB.Count_And_Get (
1135: p_encoded => FND_API.G_FALSE,
1136: p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );

Line 1143: FND_MSG_PUB.Count_And_Get (

1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: ROLLBACK TO Delete_Category_PVT;
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );

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

1147: );
1148: WHEN OTHERS THEN
1149: ROLLBACK TO Delete_Category_PVT;
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;
1155: -- Standard call to get message count and if count=1, get the message

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

1149: ROLLBACK TO Delete_Category_PVT;
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,

Line 1156: FND_MSG_PUB.Count_And_Get (

1152: THEN
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1154: END IF;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );

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

1262: THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: END IF;
1265: -- Debug Message
1266: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1267: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1268: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1269: FND_MSG_PUB.Add;
1270: END IF;

Line 1269: FND_MSG_PUB.Add;

1265: -- Debug Message
1266: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1267: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1268: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1269: FND_MSG_PUB.Add;
1270: END IF;
1271: --Initialize message list if p_init_msg_list is TRUE.
1272: IF FND_API.To_Boolean (p_init_msg_list) THEN
1273: FND_MSG_PUB.initialize;

Line 1273: FND_MSG_PUB.initialize;

1269: FND_MSG_PUB.Add;
1270: END IF;
1271: --Initialize message list if p_init_msg_list is TRUE.
1272: IF FND_API.To_Boolean (p_init_msg_list) THEN
1273: FND_MSG_PUB.initialize;
1274: END IF;
1275: -- Get the current (login) user id.
1276: AMV_UTILITY_PVT.Get_UserInfo(
1277: x_resource_id => l_resource_id,

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

1283: IF (p_check_login_user = FND_API.G_TRUE) THEN
1284: -- Check if user is login and has the required privilege.
1285: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1286: -- User is not login.
1287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1289: FND_MSG_PUB.Add;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;

Line 1289: FND_MSG_PUB.Add;

1285: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1286: -- User is not login.
1287: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1288: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1289: FND_MSG_PUB.Add;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: END IF;
1293: END IF;

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

1311: x_error_token => l_Error_Token
1312: );
1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1314: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1316: THEN
1317: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1318: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
1319: FND_MSG_PUB.Add;

Line 1319: FND_MSG_PUB.Add;

1315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1316: THEN
1317: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1318: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
1319: FND_MSG_PUB.Add;
1320: END IF;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: ELSE

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

1377: );
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: --will log the error
1381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1382: THEN
1383: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1384: FND_MESSAGE.Set_Token('ACTION', 'Sorting');
1385: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 1386: FND_MSG_PUB.Add;

1382: THEN
1383: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1384: FND_MESSAGE.Set_Token('ACTION', 'Sorting');
1385: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1386: FND_MSG_PUB.Add;
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;
1389: END;
1390: END LOOP;

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

1390: END LOOP;
1391: --
1392:
1393: -- Success message
1394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1395: THEN
1396: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1397: FND_MESSAGE.Set_Token('ROW', l_full_name);
1398: FND_MSG_PUB.Add;

Line 1398: FND_MSG_PUB.Add;

1394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1395: THEN
1396: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1397: FND_MESSAGE.Set_Token('ROW', l_full_name);
1398: FND_MSG_PUB.Add;
1399: END IF;
1400: --Standard check of commit
1401: IF FND_API.To_Boolean ( p_commit ) THEN
1402: COMMIT WORK;

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

1401: IF FND_API.To_Boolean ( p_commit ) THEN
1402: COMMIT WORK;
1403: END IF;
1404: -- Debug Message
1405: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1406: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1407: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1408: FND_MSG_PUB.Add;
1409: END IF;

Line 1408: FND_MSG_PUB.Add;

1404: -- Debug Message
1405: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1406: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1407: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1408: FND_MSG_PUB.Add;
1409: END IF;
1410: --Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,

Line 1411: FND_MSG_PUB.Count_And_Get (

1407: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1408: FND_MSG_PUB.Add;
1409: END IF;
1410: --Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );

Line 1421: FND_MSG_PUB.Count_And_Get (

1417: WHEN FND_API.G_EXC_ERROR THEN
1418: ROLLBACK TO Sort_Category_PVT;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: -- Standard call to get message count and if count=1, get the message
1421: FND_MSG_PUB.Count_And_Get (
1422: p_encoded => FND_API.G_FALSE,
1423: p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );

Line 1430: FND_MSG_PUB.Count_And_Get (

1426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1427: ROLLBACK TO Sort_Category_PVT;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: -- Standard call to get message count and if count=1, get the message
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => x_msg_count,
1433: p_data => x_msg_data
1434: );

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

1434: );
1435: WHEN OTHERS THEN
1436: ROLLBACK TO Sort_Category_PVT;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;
1442: -- Standard call to get message count and if count=1, get the message

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

1436: ROLLBACK TO Sort_Category_PVT;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,

Line 1443: FND_MSG_PUB.Count_And_Get (

1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1441: END IF;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );

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

1524: THEN
1525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1526: END IF;
1527: -- Debug Message
1528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1531: FND_MSG_PUB.Add;
1532: END IF;

Line 1531: FND_MSG_PUB.Add;

1527: -- Debug Message
1528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1529: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1530: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1531: FND_MSG_PUB.Add;
1532: END IF;
1533: --Initialize message list if p_init_msg_list is TRUE.
1534: IF FND_API.To_Boolean (p_init_msg_list) THEN
1535: FND_MSG_PUB.initialize;

Line 1535: FND_MSG_PUB.initialize;

1531: FND_MSG_PUB.Add;
1532: END IF;
1533: --Initialize message list if p_init_msg_list is TRUE.
1534: IF FND_API.To_Boolean (p_init_msg_list) THEN
1535: FND_MSG_PUB.initialize;
1536: END IF;
1537: -- Get the current (login) user id.
1538: AMV_UTILITY_PVT.Get_UserInfo(
1539: x_resource_id => l_resource_id,

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

1545: IF (p_check_login_user = FND_API.G_TRUE) THEN
1546: -- Check if user is login and has the required privilege.
1547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1548: -- User is not login.
1549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1551: FND_MSG_PUB.Add;
1552: END IF;
1553: RAISE FND_API.G_EXC_ERROR;

Line 1551: FND_MSG_PUB.Add;

1547: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1548: -- User is not login.
1549: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1550: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1551: FND_MSG_PUB.Add;
1552: END IF;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: END IF;

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

1588: );
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: --will log the error
1592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1593: THEN
1594: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1595: FND_MESSAGE.Set_Token('ACTION', 'Reordering');
1596: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 1597: FND_MSG_PUB.Add;

1593: THEN
1594: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1595: FND_MESSAGE.Set_Token('ACTION', 'Reordering');
1596: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1597: FND_MSG_PUB.Add;
1598: END IF;
1599: RAISE FND_API.G_EXC_ERROR;
1600: END;
1601: END LOOP;

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

1600: END;
1601: END LOOP;
1602: ELSE
1603: --Category count and new order count must be equal
1604: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1605: THEN
1606: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_REORDER_ERROR');
1607: FND_MSG_PUB.Add;
1608: END IF;

Line 1607: FND_MSG_PUB.Add;

1603: --Category count and new order count must be equal
1604: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1605: THEN
1606: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_REORDER_ERROR');
1607: FND_MSG_PUB.Add;
1608: END IF;
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: --

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

1610: END IF;
1611: --
1612:
1613: -- Success message
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1615: THEN
1616: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1617: FND_MESSAGE.Set_Token('ROW', l_full_name);
1618: FND_MSG_PUB.Add;

Line 1618: FND_MSG_PUB.Add;

1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1615: THEN
1616: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
1617: FND_MESSAGE.Set_Token('ROW', l_full_name);
1618: FND_MSG_PUB.Add;
1619: END IF;
1620: --Standard check of commit
1621: IF FND_API.To_Boolean ( p_commit ) THEN
1622: COMMIT WORK;

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

1621: IF FND_API.To_Boolean ( p_commit ) THEN
1622: COMMIT WORK;
1623: END IF;
1624: -- Debug Message
1625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1627: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1628: FND_MSG_PUB.Add;
1629: END IF;

Line 1628: FND_MSG_PUB.Add;

1624: -- Debug Message
1625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1627: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1628: FND_MSG_PUB.Add;
1629: END IF;
1630: --Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,

Line 1631: FND_MSG_PUB.Count_And_Get (

1627: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
1628: FND_MSG_PUB.Add;
1629: END IF;
1630: --Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );

Line 1641: FND_MSG_PUB.Count_And_Get (

1637: WHEN FND_API.G_EXC_ERROR THEN
1638: ROLLBACK TO Reorder_Category_PVT;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: -- Standard call to get message count and if count=1, get the message
1641: FND_MSG_PUB.Count_And_Get (
1642: p_encoded => FND_API.G_FALSE,
1643: p_count => x_msg_count,
1644: p_data => x_msg_data
1645: );

Line 1650: FND_MSG_PUB.Count_And_Get (

1646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1647: ROLLBACK TO Reorder_Category_PVT;
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: -- Standard call to get message count and if count=1, get the message
1650: FND_MSG_PUB.Count_And_Get (
1651: p_encoded => FND_API.G_FALSE,
1652: p_count => x_msg_count,
1653: p_data => x_msg_data
1654: );

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

1654: );
1655: WHEN OTHERS THEN
1656: ROLLBACK TO Reorder_Category_PVT;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;
1662: -- Standard call to get message count and if count=1, get the message

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

1656: ROLLBACK TO Reorder_Category_PVT;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;
1662: -- Standard call to get message count and if count=1, get the message
1663: FND_MSG_PUB.Count_And_Get (
1664: p_encoded => FND_API.G_FALSE,

Line 1663: FND_MSG_PUB.Count_And_Get (

1659: THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1661: END IF;
1662: -- Standard call to get message count and if count=1, get the message
1663: FND_MSG_PUB.Count_And_Get (
1664: p_encoded => FND_API.G_FALSE,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data
1667: );

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

1785: THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: -- Debug Message
1789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1790: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1791: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1792: FND_MSG_PUB.Add;
1793: END IF;

Line 1792: FND_MSG_PUB.Add;

1788: -- Debug Message
1789: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1790: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
1791: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
1792: FND_MSG_PUB.Add;
1793: END IF;
1794: --Initialize message list if p_init_msg_list is TRUE.
1795: IF FND_API.To_Boolean (p_init_msg_list) THEN
1796: FND_MSG_PUB.initialize;

Line 1796: FND_MSG_PUB.initialize;

1792: FND_MSG_PUB.Add;
1793: END IF;
1794: --Initialize message list if p_init_msg_list is TRUE.
1795: IF FND_API.To_Boolean (p_init_msg_list) THEN
1796: FND_MSG_PUB.initialize;
1797: END IF;
1798: -- Get the current (login) user id.
1799: AMV_UTILITY_PVT.Get_UserInfo(
1800: x_resource_id => l_resource_id,

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

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

Line 1812: FND_MSG_PUB.Add;

1808: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
1809: -- User is not login.
1810: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1811: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1812: FND_MSG_PUB.Add;
1813: END IF;
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816: END IF;

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

1837: );
1838: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1839: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
1840: -- (sub)catgeory id or name is not valid
1841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1842: THEN
1843: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1844: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1845: FND_MSG_PUB.Add;

Line 1845: FND_MSG_PUB.Add;

1841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1842: THEN
1843: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1844: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1845: FND_MSG_PUB.Add;
1846: END IF;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;
1849: ELSE

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

1887: -- update category if it does not exist
1888: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1889: IF (l_category_exist_flag = FND_API.G_TRUE) THEN
1890: -- (sub)category with the new name already exists
1891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1892: THEN
1893: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1894: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1895: FND_MSG_PUB.Add;

Line 1895: FND_MSG_PUB.Add;

1891: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1892: THEN
1893: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
1894: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
1895: FND_MSG_PUB.Add;
1896: END IF;
1897: RAISE FND_API.G_EXC_ERROR;
1898: ELSE
1899: --

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

1922: THEN
1923: l_update_category_flag := FND_API.G_TRUE;
1924: ELSE
1925: -- user does not have privilege to create category
1926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1929: FND_MESSAGE.Set_Token('LEVEL','Category');
1930: FND_MSG_PUB.Add;

Line 1930: FND_MSG_PUB.Add;

1926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1927: THEN
1928: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');
1929: FND_MESSAGE.Set_Token('LEVEL','Category');
1930: FND_MSG_PUB.Add;
1931: END IF;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: END IF;

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

1933: END IF;
1934: END IF;
1935: ELSE
1936: -- error while user privilege check in Can_SetupCategory
1937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1938: THEN
1939: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1940: FND_MESSAGE.Set_Token('LEVEL','Category');
1941: FND_MSG_PUB.Add;

Line 1941: FND_MSG_PUB.Add;

1937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1938: THEN
1939: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');
1940: FND_MESSAGE.Set_Token('LEVEL','Category');
1941: FND_MSG_PUB.Add;
1942: END IF;
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;
1945: --

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

1987: );
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: --will log the error
1991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1992: THEN
1993: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1994: FND_MESSAGE.Set_Token('ACTION', 'Updating');
1995: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 1996: FND_MSG_PUB.Add;

1992: THEN
1993: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
1994: FND_MESSAGE.Set_Token('ACTION', 'Updating');
1995: FND_MESSAGE.Set_Token('TABLE', 'Categories');
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END;
2000: ELSE

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

1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END;
2000: ELSE
2001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2002: THEN
2003: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
2004: FND_MSG_PUB.Add;
2005: END IF;

Line 2004: FND_MSG_PUB.Add;

2000: ELSE
2001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2002: THEN
2003: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
2004: FND_MSG_PUB.Add;
2005: END IF;
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;

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

2008: END IF;
2009: END IF;
2010: --
2011: ELSE
2012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2013: THEN
2014: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2015: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2016: FND_MSG_PUB.Add;

Line 2016: FND_MSG_PUB.Add;

2012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2013: THEN
2014: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2015: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2016: FND_MSG_PUB.Add;
2017: END IF;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020: --

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

2019: END IF;
2020: --
2021:
2022: -- Success message
2023: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2024: THEN
2025: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
2026: FND_MESSAGE.Set_Token('ROW', l_full_name);
2027: FND_MSG_PUB.Add;

Line 2027: FND_MSG_PUB.Add;

2023: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2024: THEN
2025: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
2026: FND_MESSAGE.Set_Token('ROW', l_full_name);
2027: FND_MSG_PUB.Add;
2028: END IF;
2029: --Standard check of commit
2030: IF FND_API.To_Boolean ( p_commit ) THEN
2031: COMMIT WORK;

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

2030: IF FND_API.To_Boolean ( p_commit ) THEN
2031: COMMIT WORK;
2032: END IF;
2033: -- Debug Message
2034: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2035: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2036: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2037: FND_MSG_PUB.Add;
2038: END IF;

Line 2037: FND_MSG_PUB.Add;

2033: -- Debug Message
2034: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2035: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2036: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2037: FND_MSG_PUB.Add;
2038: END IF;
2039: --Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE,

Line 2040: FND_MSG_PUB.Count_And_Get (

2036: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2037: FND_MSG_PUB.Add;
2038: END IF;
2039: --Standard call to get message count and if count=1, get the message
2040: FND_MSG_PUB.Count_And_Get (
2041: p_encoded => FND_API.G_FALSE,
2042: p_count => x_msg_count,
2043: p_data => x_msg_data
2044: );

Line 2050: FND_MSG_PUB.Count_And_Get (

2046: WHEN FND_API.G_EXC_ERROR THEN
2047: ROLLBACK TO Update_Category_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: -- Standard call to get message count and if count=1, get the message
2050: FND_MSG_PUB.Count_And_Get (
2051: p_encoded => FND_API.G_FALSE,
2052: p_count => x_msg_count,
2053: p_data => x_msg_data
2054: );

Line 2059: FND_MSG_PUB.Count_And_Get (

2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: ROLLBACK TO Update_Category_PVT;
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: -- Standard call to get message count and if count=1, get the message
2059: FND_MSG_PUB.Count_And_Get (
2060: p_encoded => FND_API.G_FALSE,
2061: p_count => x_msg_count,
2062: p_data => x_msg_data
2063: );

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

2063: );
2064: WHEN OTHERS THEN
2065: ROLLBACK TO Update_Category_PVT;
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2068: THEN
2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;
2071: -- Standard call to get message count and if count=1, get the message

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

2065: ROLLBACK TO Update_Category_PVT;
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2068: THEN
2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;
2071: -- Standard call to get message count and if count=1, get the message
2072: FND_MSG_PUB.Count_And_Get (
2073: p_encoded => FND_API.G_FALSE,

Line 2072: FND_MSG_PUB.Count_And_Get (

2068: THEN
2069: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2070: END IF;
2071: -- Standard call to get message count and if count=1, get the message
2072: FND_MSG_PUB.Count_And_Get (
2073: p_encoded => FND_API.G_FALSE,
2074: p_count => x_msg_count,
2075: p_data => x_msg_data
2076: );

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

2238: THEN
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241: -- Debug Message
2242: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2243: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2244: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2245: FND_MSG_PUB.Add;
2246: END IF;

Line 2245: FND_MSG_PUB.Add;

2241: -- Debug Message
2242: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2243: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2244: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2245: FND_MSG_PUB.Add;
2246: END IF;
2247: --Initialize message list if p_init_msg_list is TRUE.
2248: IF FND_API.To_Boolean (p_init_msg_list) THEN
2249: FND_MSG_PUB.initialize;

Line 2249: FND_MSG_PUB.initialize;

2245: FND_MSG_PUB.Add;
2246: END IF;
2247: --Initialize message list if p_init_msg_list is TRUE.
2248: IF FND_API.To_Boolean (p_init_msg_list) THEN
2249: FND_MSG_PUB.initialize;
2250: END IF;
2251: -- Get the current (login) user id.
2252: AMV_UTILITY_PVT.Get_UserInfo(
2253: x_resource_id => l_resource_id,

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

2259: IF (p_check_login_user = FND_API.G_TRUE) THEN
2260: -- Check if user is login and has the required privilege.
2261: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2262: -- User is not login.
2263: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2264: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2265: FND_MSG_PUB.Add;
2266: END IF;
2267: RAISE FND_API.G_EXC_ERROR;

Line 2265: FND_MSG_PUB.Add;

2261: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2262: -- User is not login.
2263: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2264: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2265: FND_MSG_PUB.Add;
2266: END IF;
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269: END IF;

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

2289: );
2290: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2291: IF (l_category_exist_flag = FND_API.G_FALSE) THEN
2292: -- parent id or name is not valid
2293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN
2295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2296: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2297: FND_MSG_PUB.Add;

Line 2297: FND_MSG_PUB.Add;

2293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2294: THEN
2295: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
2296: FND_MESSAGE.Set_Token('TKN', l_Error_Token);
2297: FND_MSG_PUB.Add;
2298: END IF;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301: ELSE

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

2493: */
2494: --
2495:
2496: -- Debug Message
2497: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2498: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2499: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2500: FND_MSG_PUB.Add;
2501: END IF;

Line 2500: FND_MSG_PUB.Add;

2496: -- Debug Message
2497: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2498: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2499: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2500: FND_MSG_PUB.Add;
2501: END IF;
2502: --Standard call to get message count and if count=1, get the message
2503: FND_MSG_PUB.Count_And_Get (
2504: p_encoded => FND_API.G_FALSE,

Line 2503: FND_MSG_PUB.Count_And_Get (

2499: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2500: FND_MSG_PUB.Add;
2501: END IF;
2502: --Standard call to get message count and if count=1, get the message
2503: FND_MSG_PUB.Count_And_Get (
2504: p_encoded => FND_API.G_FALSE,
2505: p_count => x_msg_count,
2506: p_data => x_msg_data
2507: );

Line 2513: FND_MSG_PUB.Count_And_Get (

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

Line 2522: FND_MSG_PUB.Count_And_Get (

2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2519: ROLLBACK TO Find_Categories_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: -- Standard call to get message count and if count=1, get the message
2522: FND_MSG_PUB.Count_And_Get (
2523: p_encoded => FND_API.G_FALSE,
2524: p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );

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

2526: );
2527: WHEN OTHERS THEN
2528: ROLLBACK TO Find_Categories_PVT;
2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;
2534: -- Standard call to get message count and if count=1, get the message

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

2528: ROLLBACK TO Find_Categories_PVT;
2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2531: THEN
2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;
2534: -- Standard call to get message count and if count=1, get the message
2535: FND_MSG_PUB.Count_And_Get (
2536: p_encoded => FND_API.G_FALSE,

Line 2535: FND_MSG_PUB.Count_And_Get (

2531: THEN
2532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2533: END IF;
2534: -- Standard call to get message count and if count=1, get the message
2535: FND_MSG_PUB.Count_And_Get (
2536: p_encoded => FND_API.G_FALSE,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );

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

2621: THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: -- Debug Message
2625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2627: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2628: FND_MSG_PUB.Add;
2629: END IF;

Line 2628: FND_MSG_PUB.Add;

2624: -- Debug Message
2625: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2626: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2627: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2628: FND_MSG_PUB.Add;
2629: END IF;
2630: --Initialize message list if p_init_msg_list is TRUE.
2631: IF FND_API.To_Boolean (p_init_msg_list) THEN
2632: FND_MSG_PUB.initialize;

Line 2632: FND_MSG_PUB.initialize;

2628: FND_MSG_PUB.Add;
2629: END IF;
2630: --Initialize message list if p_init_msg_list is TRUE.
2631: IF FND_API.To_Boolean (p_init_msg_list) THEN
2632: FND_MSG_PUB.initialize;
2633: END IF;
2634: -- Get the current (login) user id.
2635: AMV_UTILITY_PVT.Get_UserInfo(
2636: x_resource_id => l_resource_id,

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

2642: IF (p_check_login_user = FND_API.G_TRUE) THEN
2643: -- Check if user is login and has the required privilege.
2644: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2645: -- User is not login.
2646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2647: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2648: FND_MSG_PUB.Add;
2649: END IF;
2650: RAISE FND_API.G_EXC_ERROR;

Line 2648: FND_MSG_PUB.Add;

2644: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2645: -- User is not login.
2646: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2647: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2648: FND_MSG_PUB.Add;
2649: END IF;
2650: RAISE FND_API.G_EXC_ERROR;
2651: END IF;
2652: END IF;

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

2708: CLOSE Get_CategoryChannels;
2709: END LOOP;
2710: END IF;
2711: ELSE
2712: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2713: THEN
2714: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2715: FND_MESSAGE.Set_Token('TKN',p_category_id);
2716: FND_MSG_PUB.Add;

Line 2716: FND_MSG_PUB.Add;

2712: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2713: THEN
2714: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2715: FND_MESSAGE.Set_Token('TKN',p_category_id);
2716: FND_MSG_PUB.Add;
2717: END IF;
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;
2720: --

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

2719: END IF;
2720: --
2721:
2722: -- Debug Message
2723: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2724: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2725: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2726: FND_MSG_PUB.Add;
2727: END IF;

Line 2726: FND_MSG_PUB.Add;

2722: -- Debug Message
2723: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2724: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2725: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2726: FND_MSG_PUB.Add;
2727: END IF;
2728: --Standard call to get message count and if count=1, get the message
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,

Line 2729: FND_MSG_PUB.Count_And_Get (

2725: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2726: FND_MSG_PUB.Add;
2727: END IF;
2728: --Standard call to get message count and if count=1, get the message
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => x_msg_count,
2732: p_data => x_msg_data
2733: );

Line 2739: FND_MSG_PUB.Count_And_Get (

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

Line 2748: FND_MSG_PUB.Count_And_Get (

2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: ROLLBACK TO Get_ChansPerCategory_PVT;
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: -- Standard call to get message count and if count=1, get the message
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => x_msg_count,
2751: p_data => x_msg_data
2752: );

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

2752: );
2753: WHEN OTHERS THEN
2754: ROLLBACK TO Get_ChansPerCategory_PVT;
2755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;
2760: -- Standard call to get message count and if count=1, get the message

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

2754: ROLLBACK TO Get_ChansPerCategory_PVT;
2755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2757: THEN
2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;
2760: -- Standard call to get message count and if count=1, get the message
2761: FND_MSG_PUB.Count_And_Get (
2762: p_encoded => FND_API.G_FALSE,

Line 2761: FND_MSG_PUB.Count_And_Get (

2757: THEN
2758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2759: END IF;
2760: -- Standard call to get message count and if count=1, get the message
2761: FND_MSG_PUB.Count_And_Get (
2762: p_encoded => FND_API.G_FALSE,
2763: p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );

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

2853: THEN
2854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2855: END IF;
2856: -- Debug Message
2857: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2858: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2859: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2860: FND_MSG_PUB.Add;
2861: END IF;

Line 2860: FND_MSG_PUB.Add;

2856: -- Debug Message
2857: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2858: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2859: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
2860: FND_MSG_PUB.Add;
2861: END IF;
2862: --Initialize message list if p_init_msg_list is TRUE.
2863: IF FND_API.To_Boolean (p_init_msg_list) THEN
2864: FND_MSG_PUB.initialize;

Line 2864: FND_MSG_PUB.initialize;

2860: FND_MSG_PUB.Add;
2861: END IF;
2862: --Initialize message list if p_init_msg_list is TRUE.
2863: IF FND_API.To_Boolean (p_init_msg_list) THEN
2864: FND_MSG_PUB.initialize;
2865: END IF;
2866: -- Get the current (login) user id.
2867: AMV_UTILITY_PVT.Get_UserInfo(
2868: x_resource_id => l_resource_id,

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

2874: IF (p_check_login_user = FND_API.G_TRUE) THEN
2875: -- Check if user is login and has the required privilege.
2876: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2877: -- User is not login.
2878: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2879: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2880: FND_MSG_PUB.Add;
2881: END IF;
2882: RAISE FND_API.G_EXC_ERROR;

Line 2880: FND_MSG_PUB.Add;

2876: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
2877: -- User is not login.
2878: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2879: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
2880: FND_MSG_PUB.Add;
2881: END IF;
2882: RAISE FND_API.G_EXC_ERROR;
2883: END IF;
2884: END IF;

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

2938: CLOSE Get_CategoryItems_csr;
2939: END LOOP;
2940: END IF;
2941: ELSE
2942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2943: THEN
2944: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2945: FND_MESSAGE.Set_Token('TKN',p_category_id);
2946: FND_MSG_PUB.Add;

Line 2946: FND_MSG_PUB.Add;

2942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2943: THEN
2944: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
2945: FND_MESSAGE.Set_Token('TKN',p_category_id);
2946: FND_MSG_PUB.Add;
2947: END IF;
2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;
2950: --

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

2949: END IF;
2950: --
2951:
2952: -- Debug Message
2953: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2954: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2955: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2956: FND_MSG_PUB.Add;
2957: END IF;

Line 2956: FND_MSG_PUB.Add;

2952: -- Debug Message
2953: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2954: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
2955: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2956: FND_MSG_PUB.Add;
2957: END IF;
2958: --Standard call to get message count and if count=1, get the message
2959: FND_MSG_PUB.Count_And_Get (
2960: p_encoded => FND_API.G_FALSE,

Line 2959: FND_MSG_PUB.Count_And_Get (

2955: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
2956: FND_MSG_PUB.Add;
2957: END IF;
2958: --Standard call to get message count and if count=1, get the message
2959: FND_MSG_PUB.Count_And_Get (
2960: p_encoded => FND_API.G_FALSE,
2961: p_count => x_msg_count,
2962: p_data => x_msg_data
2963: );

Line 2969: FND_MSG_PUB.Count_And_Get (

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

Line 2978: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 2991: FND_MSG_PUB.Count_And_Get (

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

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

3104: THEN
3105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3106: END IF;
3107: -- Debug Message
3108: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3109: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3110: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3111: FND_MSG_PUB.Add;
3112: END IF;

Line 3111: FND_MSG_PUB.Add;

3107: -- Debug Message
3108: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3109: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3110: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3111: FND_MSG_PUB.Add;
3112: END IF;
3113: --Initialize message list if p_init_msg_list is TRUE.
3114: IF FND_API.To_Boolean (p_init_msg_list) THEN
3115: FND_MSG_PUB.initialize;

Line 3115: FND_MSG_PUB.initialize;

3111: FND_MSG_PUB.Add;
3112: END IF;
3113: --Initialize message list if p_init_msg_list is TRUE.
3114: IF FND_API.To_Boolean (p_init_msg_list) THEN
3115: FND_MSG_PUB.initialize;
3116: END IF;
3117: -- Get the current (login) user id.
3118: AMV_UTILITY_PVT.Get_UserInfo(
3119: x_resource_id => l_resource_id,

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

3125: IF (p_check_login_user = FND_API.G_TRUE) THEN
3126: -- Check if user is login and has the required privilege.
3127: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3128: -- User is not login.
3129: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3130: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3131: FND_MSG_PUB.Add;
3132: END IF;
3133: RAISE FND_API.G_EXC_ERROR;

Line 3131: FND_MSG_PUB.Add;

3127: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3128: -- User is not login.
3129: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3130: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3131: FND_MSG_PUB.Add;
3132: END IF;
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135: END IF;

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

3233: l_counter + 1,
3234: l_total_count);
3235: */
3236: ELSE
3237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3238: THEN
3239: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3240: FND_MESSAGE.Set_Token('TKN',p_category_id);
3241: FND_MSG_PUB.Add;

Line 3241: FND_MSG_PUB.Add;

3237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3238: THEN
3239: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3240: FND_MESSAGE.Set_Token('TKN',p_category_id);
3241: FND_MSG_PUB.Add;
3242: END IF;
3243: RAISE FND_API.G_EXC_ERROR;
3244: END IF;
3245: --

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

3244: END IF;
3245: --
3246:
3247: -- Debug Message
3248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3249: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3250: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3251: FND_MSG_PUB.Add;
3252: END IF;

Line 3251: FND_MSG_PUB.Add;

3247: -- Debug Message
3248: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3249: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3250: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3251: FND_MSG_PUB.Add;
3252: END IF;
3253: --Standard call to get message count and if count=1, get the message
3254: FND_MSG_PUB.Count_And_Get (
3255: p_encoded => FND_API.G_FALSE,

Line 3254: FND_MSG_PUB.Count_And_Get (

3250: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
3251: FND_MSG_PUB.Add;
3252: END IF;
3253: --Standard call to get message count and if count=1, get the message
3254: FND_MSG_PUB.Count_And_Get (
3255: p_encoded => FND_API.G_FALSE,
3256: p_count => x_msg_count,
3257: p_data => x_msg_data
3258: );

Line 3264: FND_MSG_PUB.Count_And_Get (

3260: WHEN FND_API.G_EXC_ERROR THEN
3261: ROLLBACK TO Get_ItemsPerCategory_PVT;
3262: x_return_status := FND_API.G_RET_STS_ERROR;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );

Line 3273: FND_MSG_PUB.Count_And_Get (

3269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3270: ROLLBACK TO Get_ItemsPerCategory_PVT;
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: -- Standard call to get message count and if count=1, get the message
3273: FND_MSG_PUB.Count_And_Get (
3274: p_encoded => FND_API.G_FALSE,
3275: p_count => x_msg_count,
3276: p_data => x_msg_data
3277: );

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

3277: );
3278: WHEN OTHERS THEN
3279: ROLLBACK TO Get_ItemsPerCategory_PVT;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;
3285: -- Standard call to get message count and if count=1, get the message

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

3279: ROLLBACK TO Get_ItemsPerCategory_PVT;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;
3285: -- Standard call to get message count and if count=1, get the message
3286: FND_MSG_PUB.Count_And_Get (
3287: p_encoded => FND_API.G_FALSE,

Line 3286: FND_MSG_PUB.Count_And_Get (

3282: THEN
3283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3284: END IF;
3285: -- Standard call to get message count and if count=1, get the message
3286: FND_MSG_PUB.Count_And_Get (
3287: p_encoded => FND_API.G_FALSE,
3288: p_count => x_msg_count,
3289: p_data => x_msg_data
3290: );

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

3373: THEN
3374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3375: END IF;
3376: -- Debug Message
3377: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3378: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3379: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3380: FND_MSG_PUB.Add;
3381: END IF;

Line 3380: FND_MSG_PUB.Add;

3376: -- Debug Message
3377: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3378: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3379: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3380: FND_MSG_PUB.Add;
3381: END IF;
3382: --Initialize message list if p_init_msg_list is TRUE.
3383: IF FND_API.To_Boolean (p_init_msg_list) THEN
3384: FND_MSG_PUB.initialize;

Line 3384: FND_MSG_PUB.initialize;

3380: FND_MSG_PUB.Add;
3381: END IF;
3382: --Initialize message list if p_init_msg_list is TRUE.
3383: IF FND_API.To_Boolean (p_init_msg_list) THEN
3384: FND_MSG_PUB.initialize;
3385: END IF;
3386: -- Get the current (login) user id.
3387: AMV_UTILITY_PVT.Get_UserInfo(
3388: x_resource_id => l_resource_id,

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

3394: IF (p_check_login_user = FND_API.G_TRUE) THEN
3395: -- Check if user is login and has the required privilege.
3396: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3397: -- User is not login.
3398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3399: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3400: FND_MSG_PUB.Add;
3401: END IF;
3402: RAISE FND_API.G_EXC_ERROR;

Line 3400: FND_MSG_PUB.Add;

3396: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3397: -- User is not login.
3398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3399: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3400: FND_MSG_PUB.Add;
3401: END IF;
3402: RAISE FND_API.G_EXC_ERROR;
3403: END IF;
3404: END IF;

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

3423: x_error_token => l_Error_Token
3424: );
3425: --
3426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3428: THEN
3429: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3430: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3431: FND_MSG_PUB.Add;

Line 3431: FND_MSG_PUB.Add;

3427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3428: THEN
3429: FND_MESSAGE.Set_Name('AMV', l_Error_Msg);
3430: FND_MESSAGE.Set_Token('TKN',l_Error_Token);
3431: FND_MSG_PUB.Add;
3432: END IF;
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;
3435:

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

3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;
3435:
3436: -- Debug Message
3437: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3438: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3439: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3440: FND_MSG_PUB.Add;
3441: END IF;

Line 3440: FND_MSG_PUB.Add;

3436: -- Debug Message
3437: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3438: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3439: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3440: FND_MSG_PUB.Add;
3441: END IF;
3442: --Standard call to get message count and if count=1, get the message
3443: FND_MSG_PUB.Count_And_Get (
3444: p_encoded => FND_API.G_FALSE,

Line 3443: FND_MSG_PUB.Count_And_Get (

3439: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3440: FND_MSG_PUB.Add;
3441: END IF;
3442: --Standard call to get message count and if count=1, get the message
3443: FND_MSG_PUB.Count_And_Get (
3444: p_encoded => FND_API.G_FALSE,
3445: p_count => x_msg_count,
3446: p_data => x_msg_data
3447: );

Line 3453: FND_MSG_PUB.Count_And_Get (

3449: WHEN FND_API.G_EXC_ERROR THEN
3450: ROLLBACK TO Fetch_CategoryId_PVT;
3451: x_return_status := FND_API.G_RET_STS_ERROR;
3452: -- Standard call to get message count and if count=1, get the message
3453: FND_MSG_PUB.Count_And_Get (
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data
3457: );

Line 3462: FND_MSG_PUB.Count_And_Get (

3458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3459: ROLLBACK TO Fetch_CategoryId_PVT;
3460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3461: -- Standard call to get message count and if count=1, get the message
3462: FND_MSG_PUB.Count_And_Get (
3463: p_encoded => FND_API.G_FALSE,
3464: p_count => x_msg_count,
3465: p_data => x_msg_data
3466: );

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

3466: );
3467: WHEN OTHERS THEN
3468: ROLLBACK TO Fetch_CategoryId_PVT;
3469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3470: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3471: THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;
3474: -- Standard call to get message count and if count=1, get the message

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

3468: ROLLBACK TO Fetch_CategoryId_PVT;
3469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3470: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3471: THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;
3474: -- Standard call to get message count and if count=1, get the message
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,

Line 3475: FND_MSG_PUB.Count_And_Get (

3471: THEN
3472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3473: END IF;
3474: -- Standard call to get message count and if count=1, get the message
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data
3479: );

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

3546: THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: END IF;
3549: -- Debug Message
3550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3551: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3552: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3553: FND_MSG_PUB.Add;
3554: END IF;

Line 3553: FND_MSG_PUB.Add;

3549: -- Debug Message
3550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3551: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3552: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3553: FND_MSG_PUB.Add;
3554: END IF;
3555: --Initialize message list if p_init_msg_list is TRUE.
3556: IF FND_API.To_Boolean (p_init_msg_list) THEN
3557: FND_MSG_PUB.initialize;

Line 3557: FND_MSG_PUB.initialize;

3553: FND_MSG_PUB.Add;
3554: END IF;
3555: --Initialize message list if p_init_msg_list is TRUE.
3556: IF FND_API.To_Boolean (p_init_msg_list) THEN
3557: FND_MSG_PUB.initialize;
3558: END IF;
3559: -- Get the current (login) user id.
3560: AMV_UTILITY_PVT.Get_UserInfo(
3561: x_resource_id => l_resource_id,

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

3567: IF (p_check_login_user = FND_API.G_TRUE) THEN
3568: -- Check if user is login and has the required privilege.
3569: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3570: -- User is not login.
3571: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3573: FND_MSG_PUB.Add;
3574: END IF;
3575: RAISE FND_API.G_EXC_ERROR;

Line 3573: FND_MSG_PUB.Add;

3569: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3570: -- User is not login.
3571: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3572: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3573: FND_MSG_PUB.Add;
3574: END IF;
3575: RAISE FND_API.G_EXC_ERROR;
3576: END IF;
3577: END IF;

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

3593: l_category_level,
3594: x_category_hierarchy);
3595:
3596: ELSE
3597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3598: THEN
3599: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3600: FND_MESSAGE.Set_Token('TKN',p_category_id);
3601: FND_MSG_PUB.Add;

Line 3601: FND_MSG_PUB.Add;

3597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3598: THEN
3599: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3600: FND_MESSAGE.Set_Token('TKN',p_category_id);
3601: FND_MSG_PUB.Add;
3602: END IF;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605: --

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

3604: END IF;
3605: --
3606:
3607: -- Debug Message
3608: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3609: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3610: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3611: FND_MSG_PUB.Add;
3612: END IF;

Line 3611: FND_MSG_PUB.Add;

3607: -- Debug Message
3608: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3609: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3610: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3611: FND_MSG_PUB.Add;
3612: END IF;
3613: --Standard call to get message count and if count=1, get the message
3614: FND_MSG_PUB.Count_And_Get (
3615: p_encoded => FND_API.G_FALSE,

Line 3614: FND_MSG_PUB.Count_And_Get (

3610: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3611: FND_MSG_PUB.Add;
3612: END IF;
3613: --Standard call to get message count and if count=1, get the message
3614: FND_MSG_PUB.Count_And_Get (
3615: p_encoded => FND_API.G_FALSE,
3616: p_count => x_msg_count,
3617: p_data => x_msg_data
3618: );

Line 3624: FND_MSG_PUB.Count_And_Get (

3620: WHEN FND_API.G_EXC_ERROR THEN
3621: ROLLBACK TO Get_CatParentsHrPVT;
3622: x_return_status := FND_API.G_RET_STS_ERROR;
3623: -- Standard call to get message count and if count=1, get the message
3624: FND_MSG_PUB.Count_And_Get (
3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,
3627: p_data => x_msg_data
3628: );

Line 3633: FND_MSG_PUB.Count_And_Get (

3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630: ROLLBACK TO Get_CatParentsHrPVT;
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: -- Standard call to get message count and if count=1, get the message
3633: FND_MSG_PUB.Count_And_Get (
3634: p_encoded => FND_API.G_FALSE,
3635: p_count => x_msg_count,
3636: p_data => x_msg_data
3637: );

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

3637: );
3638: WHEN OTHERS THEN
3639: ROLLBACK TO Get_CatParentsHrPVT;
3640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;
3645: -- Standard call to get message count and if count=1, get the message

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

3639: ROLLBACK TO Get_CatParentsHrPVT;
3640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3641: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3642: THEN
3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;
3645: -- Standard call to get message count and if count=1, get the message
3646: FND_MSG_PUB.Count_And_Get (
3647: p_encoded => FND_API.G_FALSE,

Line 3646: FND_MSG_PUB.Count_And_Get (

3642: THEN
3643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3644: END IF;
3645: -- Standard call to get message count and if count=1, get the message
3646: FND_MSG_PUB.Count_And_Get (
3647: p_encoded => FND_API.G_FALSE,
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3650: );

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

3717: THEN
3718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3719: END IF;
3720: -- Debug Message
3721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3722: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3723: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3724: FND_MSG_PUB.Add;
3725: END IF;

Line 3724: FND_MSG_PUB.Add;

3720: -- Debug Message
3721: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3722: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3723: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3724: FND_MSG_PUB.Add;
3725: END IF;
3726: --Initialize message list if p_init_msg_list is TRUE.
3727: IF FND_API.To_Boolean (p_init_msg_list) THEN
3728: FND_MSG_PUB.initialize;

Line 3728: FND_MSG_PUB.initialize;

3724: FND_MSG_PUB.Add;
3725: END IF;
3726: --Initialize message list if p_init_msg_list is TRUE.
3727: IF FND_API.To_Boolean (p_init_msg_list) THEN
3728: FND_MSG_PUB.initialize;
3729: END IF;
3730: -- Get the current (login) user id.
3731: AMV_UTILITY_PVT.Get_UserInfo(
3732: x_resource_id => l_resource_id,

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

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

Line 3744: FND_MSG_PUB.Add;

3740: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3741: -- User is not login.
3742: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3743: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3744: FND_MSG_PUB.Add;
3745: END IF;
3746: RAISE FND_API.G_EXC_ERROR;
3747: END IF;
3748: END IF;

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

3764: l_category_level,
3765: x_category_hierarchy);
3766:
3767: ELSE
3768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3769: THEN
3770: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3771: FND_MESSAGE.Set_Token('TKN',p_category_id);
3772: FND_MSG_PUB.Add;

Line 3772: FND_MSG_PUB.Add;

3768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3769: THEN
3770: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
3771: FND_MESSAGE.Set_Token('TKN',p_category_id);
3772: FND_MSG_PUB.Add;
3773: END IF;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;
3776: --

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

3775: END IF;
3776: --
3777:
3778: -- Debug Message
3779: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3780: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3781: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3782: FND_MSG_PUB.Add;
3783: END IF;

Line 3782: FND_MSG_PUB.Add;

3778: -- Debug Message
3779: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3780: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3781: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3782: FND_MSG_PUB.Add;
3783: END IF;
3784: --Standard call to get message count and if count=1, get the message
3785: FND_MSG_PUB.Count_And_Get (
3786: p_encoded => FND_API.G_FALSE,

Line 3785: FND_MSG_PUB.Count_And_Get (

3781: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3782: FND_MSG_PUB.Add;
3783: END IF;
3784: --Standard call to get message count and if count=1, get the message
3785: FND_MSG_PUB.Count_And_Get (
3786: p_encoded => FND_API.G_FALSE,
3787: p_count => x_msg_count,
3788: p_data => x_msg_data
3789: );

Line 3795: FND_MSG_PUB.Count_And_Get (

3791: WHEN FND_API.G_EXC_ERROR THEN
3792: ROLLBACK TO Get_CatChildrenHrPVT;
3793: x_return_status := FND_API.G_RET_STS_ERROR;
3794: -- Standard call to get message count and if count=1, get the message
3795: FND_MSG_PUB.Count_And_Get (
3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,
3798: p_data => x_msg_data
3799: );

Line 3804: FND_MSG_PUB.Count_And_Get (

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

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

3808: );
3809: WHEN OTHERS THEN
3810: ROLLBACK TO Get_CatChildrenHrPVT;
3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3813: THEN
3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;
3816: -- Standard call to get message count and if count=1, get the message

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

3810: ROLLBACK TO Get_CatChildrenHrPVT;
3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3813: THEN
3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;
3816: -- Standard call to get message count and if count=1, get the message
3817: FND_MSG_PUB.Count_And_Get (
3818: p_encoded => FND_API.G_FALSE,

Line 3817: FND_MSG_PUB.Count_And_Get (

3813: THEN
3814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3815: END IF;
3816: -- Standard call to get message count and if count=1, get the message
3817: FND_MSG_PUB.Count_And_Get (
3818: p_encoded => FND_API.G_FALSE,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data
3821: );

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

3900: THEN
3901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3902: END IF;
3903: -- Debug Message
3904: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3905: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3906: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3907: FND_MSG_PUB.Add;
3908: END IF;

Line 3907: FND_MSG_PUB.Add;

3903: -- Debug Message
3904: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3905: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3906: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
3907: FND_MSG_PUB.Add;
3908: END IF;
3909: --Initialize message list if p_init_msg_list is TRUE.
3910: IF FND_API.To_Boolean (p_init_msg_list) THEN
3911: FND_MSG_PUB.initialize;

Line 3911: FND_MSG_PUB.initialize;

3907: FND_MSG_PUB.Add;
3908: END IF;
3909: --Initialize message list if p_init_msg_list is TRUE.
3910: IF FND_API.To_Boolean (p_init_msg_list) THEN
3911: FND_MSG_PUB.initialize;
3912: END IF;
3913: -- Get the current (login) user id.
3914: AMV_UTILITY_PVT.Get_UserInfo(
3915: x_resource_id => l_resource_id,

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

3921: IF (p_check_login_user = FND_API.G_TRUE) THEN
3922: -- Check if user is login and has the required privilege.
3923: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3924: -- User is not login.
3925: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3927: FND_MSG_PUB.Add;
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR;

Line 3927: FND_MSG_PUB.Add;

3923: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
3924: -- User is not login.
3925: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3926: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
3927: FND_MSG_PUB.Add;
3928: END IF;
3929: RAISE FND_API.G_EXC_ERROR;
3930: END IF;
3931: END IF;

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

3949: Get_CategoryParents(l_category_id,
3950: l_category_level,
3951: x_category_hierarchy);
3952: ELSE
3953: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3954: THEN
3955: FND_MESSAGE.Set_Name('AMV', 'AMV_CHANNEL_ID_INVALID');
3956: FND_MESSAGE.Set_Token('TKN',p_channel_id);
3957: FND_MSG_PUB.Add;

Line 3957: FND_MSG_PUB.Add;

3953: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3954: THEN
3955: FND_MESSAGE.Set_Name('AMV', 'AMV_CHANNEL_ID_INVALID');
3956: FND_MESSAGE.Set_Token('TKN',p_channel_id);
3957: FND_MSG_PUB.Add;
3958: END IF;
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;
3961: --

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

3960: END IF;
3961: --
3962:
3963: -- Debug Message
3964: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3965: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3966: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3967: FND_MSG_PUB.Add;
3968: END IF;

Line 3967: FND_MSG_PUB.Add;

3963: -- Debug Message
3964: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3965: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
3966: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3967: FND_MSG_PUB.Add;
3968: END IF;
3969: --Standard call to get message count and if count=1, get the message
3970: FND_MSG_PUB.Count_And_Get (
3971: p_encoded => FND_API.G_FALSE,

Line 3970: FND_MSG_PUB.Count_And_Get (

3966: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
3967: FND_MSG_PUB.Add;
3968: END IF;
3969: --Standard call to get message count and if count=1, get the message
3970: FND_MSG_PUB.Count_And_Get (
3971: p_encoded => FND_API.G_FALSE,
3972: p_count => x_msg_count,
3973: p_data => x_msg_data
3974: );

Line 3980: FND_MSG_PUB.Count_And_Get (

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

Line 3989: FND_MSG_PUB.Count_And_Get (

3985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3986: ROLLBACK TO Get_ChnCategoryHierarchy;
3987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3988: -- Standard call to get message count and if count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,
3992: p_data => x_msg_data
3993: );

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

3993: );
3994: WHEN OTHERS THEN
3995: ROLLBACK TO Get_ChnCategoryHierarchy;
3996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3998: THEN
3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;
4001: -- Standard call to get message count and if count=1, get the message

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

3995: ROLLBACK TO Get_ChnCategoryHierarchy;
3996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3998: THEN
3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;
4001: -- Standard call to get message count and if count=1, get the message
4002: FND_MSG_PUB.Count_And_Get (
4003: p_encoded => FND_API.G_FALSE,

Line 4002: FND_MSG_PUB.Count_And_Get (

3998: THEN
3999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4000: END IF;
4001: -- Standard call to get message count and if count=1, get the message
4002: FND_MSG_PUB.Count_And_Get (
4003: p_encoded => FND_API.G_FALSE,
4004: p_count => x_msg_count,
4005: p_data => x_msg_data
4006: );

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

4101: THEN
4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: END IF;
4104: -- Debug Message
4105: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4106: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4107: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4108: FND_MSG_PUB.Add;
4109: END IF;

Line 4108: FND_MSG_PUB.Add;

4104: -- Debug Message
4105: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4106: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4107: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Initialize message list if p_init_msg_list is TRUE.
4111: IF FND_API.To_Boolean (p_init_msg_list) THEN
4112: FND_MSG_PUB.initialize;

Line 4112: FND_MSG_PUB.initialize;

4108: FND_MSG_PUB.Add;
4109: END IF;
4110: --Initialize message list if p_init_msg_list is TRUE.
4111: IF FND_API.To_Boolean (p_init_msg_list) THEN
4112: FND_MSG_PUB.initialize;
4113: END IF;
4114: -- Get the current (login) user id.
4115: AMV_UTILITY_PVT.Get_UserInfo(
4116: x_resource_id => l_resource_id,

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

4122: IF (p_check_login_user = FND_API.G_TRUE) THEN
4123: -- Check if user is login and has the required privilege.
4124: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4125: -- User is not login.
4126: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4127: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4128: FND_MSG_PUB.Add;
4129: END IF;
4130: RAISE FND_API.G_EXC_ERROR;

Line 4128: FND_MSG_PUB.Add;

4124: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4125: -- User is not login.
4126: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4127: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4128: FND_MSG_PUB.Add;
4129: END IF;
4130: RAISE FND_API.G_EXC_ERROR;
4131: END IF;
4132: END IF;

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

4159: l_update_flag := FND_API.G_FALSE;
4160: END IF;
4161: END IF;
4162: ELSE
4163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4164: THEN
4165: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4166: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4167: FND_MSG_PUB.Add;

Line 4167: FND_MSG_PUB.Add;

4163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4164: THEN
4165: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4166: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4167: FND_MSG_PUB.Add;
4168: END IF;
4169: RAISE FND_API.G_EXC_ERROR;
4170: END IF;
4171: ELSE

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

4168: END IF;
4169: RAISE FND_API.G_EXC_ERROR;
4170: END IF;
4171: ELSE
4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4173: THEN
4174: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4175: FND_MESSAGE.Set_Token('TKN',p_category_id);
4176: FND_MSG_PUB.Add;

Line 4176: FND_MSG_PUB.Add;

4172: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4173: THEN
4174: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4175: FND_MESSAGE.Set_Token('TKN',p_category_id);
4176: FND_MSG_PUB.Add;
4177: END IF;
4178: RAISE FND_API.G_EXC_ERROR;
4179: END IF;
4180:

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

4191: END IF;
4192: EXIT WHEN l_category_hr(i).id = p_parent_category_id;
4193: END LOOP;
4194: IF l_update_flag = FND_API.G_FALSE THEN
4195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4196: THEN
4197: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_LOOPING');
4198: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4199: FND_MSG_PUB.Add;

Line 4199: FND_MSG_PUB.Add;

4195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4196: THEN
4197: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_LOOPING');
4198: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);
4199: FND_MSG_PUB.Add;
4200: END IF;
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:

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

4212: EXIT WHEN UPPER(l_subcat_name) = UPPER(l_cat_name);
4213: END LOOP;
4214: CLOSE Get_SubCatName;
4215: IF l_update_flag = FND_API.G_FALSE THEN
4216: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4217: THEN
4218: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_NAME_EXISTS');
4219: FND_MESSAGE.Set_Token('TKN',p_category_id);
4220: FND_MSG_PUB.Add;

Line 4220: FND_MSG_PUB.Add;

4216: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4217: THEN
4218: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_NAME_EXISTS');
4219: FND_MESSAGE.Set_Token('TKN',p_category_id);
4220: FND_MSG_PUB.Add;
4221: END IF;
4222: RAISE FND_API.G_EXC_ERROR;
4223: END IF;
4224:

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

4236: );
4237: EXCEPTION
4238: WHEN OTHERS THEN
4239: --will log the error
4240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4241: THEN
4242: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
4243: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4244: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 4245: FND_MSG_PUB.Add;

4241: THEN
4242: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
4243: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4244: FND_MESSAGE.Set_Token('TABLE', 'Categories');
4245: FND_MSG_PUB.Add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;
4249: ELSE

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

4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;
4249: ELSE
4250: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4251: THEN
4252: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4253: FND_MSG_PUB.Add;
4254: END IF;

Line 4253: FND_MSG_PUB.Add;

4249: ELSE
4250: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4251: THEN
4252: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4253: FND_MSG_PUB.Add;
4254: END IF;
4255: RAISE FND_API.G_EXC_ERROR;
4256: END IF;
4257: ELSE

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

4254: END IF;
4255: RAISE FND_API.G_EXC_ERROR;
4256: END IF;
4257: ELSE
4258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4259: THEN
4260: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_EXISTS');
4261: FND_MESSAGE.Set_Token('TKN',l_parent_category_id);
4262: FND_MSG_PUB.Add;

Line 4262: FND_MSG_PUB.Add;

4258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4259: THEN
4260: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_EXISTS');
4261: FND_MESSAGE.Set_Token('TKN',l_parent_category_id);
4262: FND_MSG_PUB.Add;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;
4266: --

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

4270: COMMIT WORK;
4271: END IF;
4272:
4273: -- Debug Message
4274: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4275: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4276: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4277: FND_MSG_PUB.Add;
4278: END IF;

Line 4277: FND_MSG_PUB.Add;

4273: -- Debug Message
4274: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4275: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4276: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4277: FND_MSG_PUB.Add;
4278: END IF;
4279: --Standard call to get message count and if count=1, get the message
4280: FND_MSG_PUB.Count_And_Get (
4281: p_encoded => FND_API.G_FALSE,

Line 4280: FND_MSG_PUB.Count_And_Get (

4276: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4277: FND_MSG_PUB.Add;
4278: END IF;
4279: --Standard call to get message count and if count=1, get the message
4280: FND_MSG_PUB.Count_And_Get (
4281: p_encoded => FND_API.G_FALSE,
4282: p_count => x_msg_count,
4283: p_data => x_msg_data
4284: );

Line 4290: FND_MSG_PUB.Count_And_Get (

4286: WHEN FND_API.G_EXC_ERROR THEN
4287: ROLLBACK TO Add_CategoryParent;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: -- Standard call to get message count and if count=1, get the message
4290: FND_MSG_PUB.Count_And_Get (
4291: p_encoded => FND_API.G_FALSE,
4292: p_count => x_msg_count,
4293: p_data => x_msg_data
4294: );

Line 4299: FND_MSG_PUB.Count_And_Get (

4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: ROLLBACK TO Add_CategoryParent;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: -- Standard call to get message count and if count=1, get the message
4299: FND_MSG_PUB.Count_And_Get (
4300: p_encoded => FND_API.G_FALSE,
4301: p_count => x_msg_count,
4302: p_data => x_msg_data
4303: );

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

4303: );
4304: WHEN OTHERS THEN
4305: ROLLBACK TO Add_CategoryParent;
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4308: THEN
4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;
4311: -- Standard call to get message count and if count=1, get the message

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

4305: ROLLBACK TO Add_CategoryParent;
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4308: THEN
4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;
4311: -- Standard call to get message count and if count=1, get the message
4312: FND_MSG_PUB.Count_And_Get (
4313: p_encoded => FND_API.G_FALSE,

Line 4312: FND_MSG_PUB.Count_And_Get (

4308: THEN
4309: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4310: END IF;
4311: -- Standard call to get message count and if count=1, get the message
4312: FND_MSG_PUB.Count_And_Get (
4313: p_encoded => FND_API.G_FALSE,
4314: p_count => x_msg_count,
4315: p_data => x_msg_data
4316: );

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

4393: THEN
4394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4395: END IF;
4396: -- Debug Message
4397: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4398: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4399: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4400: FND_MSG_PUB.Add;
4401: END IF;

Line 4400: FND_MSG_PUB.Add;

4396: -- Debug Message
4397: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4398: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4399: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
4400: FND_MSG_PUB.Add;
4401: END IF;
4402: --Initialize message list if p_init_msg_list is TRUE.
4403: IF FND_API.To_Boolean (p_init_msg_list) THEN
4404: FND_MSG_PUB.initialize;

Line 4404: FND_MSG_PUB.initialize;

4400: FND_MSG_PUB.Add;
4401: END IF;
4402: --Initialize message list if p_init_msg_list is TRUE.
4403: IF FND_API.To_Boolean (p_init_msg_list) THEN
4404: FND_MSG_PUB.initialize;
4405: END IF;
4406: -- Get the current (login) user id.
4407: AMV_UTILITY_PVT.Get_UserInfo(
4408: x_resource_id => l_resource_id,

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

4414: IF (p_check_login_user = FND_API.G_TRUE) THEN
4415: -- Check if user is login and has the required privilege.
4416: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4417: -- User is not login.
4418: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4420: FND_MSG_PUB.Add;
4421: END IF;
4422: RAISE FND_API.G_EXC_ERROR;

Line 4420: FND_MSG_PUB.Add;

4416: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
4417: -- User is not login.
4418: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4419: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
4420: FND_MSG_PUB.Add;
4421: END IF;
4422: RAISE FND_API.G_EXC_ERROR;
4423: END IF;
4424: END IF;

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

4457: );
4458: EXCEPTION
4459: WHEN OTHERS THEN
4460: --will log the error
4461: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4462: THEN
4463: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
4464: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4465: FND_MESSAGE.Set_Token('TABLE', 'Categories');

Line 4466: FND_MSG_PUB.Add;

4462: THEN
4463: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');
4464: FND_MESSAGE.Set_Token('ACTION', 'Updating');
4465: FND_MESSAGE.Set_Token('TABLE', 'Categories');
4466: FND_MSG_PUB.Add;
4467: END IF;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END;
4470: ELSE

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

4467: END IF;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END;
4470: ELSE
4471: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4472: THEN
4473: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4474: FND_MSG_PUB.Add;
4475: END IF;

Line 4474: FND_MSG_PUB.Add;

4470: ELSE
4471: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4472: THEN
4473: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');
4474: FND_MSG_PUB.Add;
4475: END IF;
4476: RAISE FND_API.G_EXC_ERROR;
4477: END IF;
4478: ELSE

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

4475: END IF;
4476: RAISE FND_API.G_EXC_ERROR;
4477: END IF;
4478: ELSE
4479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4480: THEN
4481: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4482: FND_MESSAGE.Set_Token('TKN',p_category_id);
4483: FND_MSG_PUB.Add;

Line 4483: FND_MSG_PUB.Add;

4479: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4480: THEN
4481: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');
4482: FND_MESSAGE.Set_Token('TKN',p_category_id);
4483: FND_MSG_PUB.Add;
4484: END IF;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;
4487: --

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

4491: COMMIT WORK;
4492: END IF;
4493:
4494: -- Debug Message
4495: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4496: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4497: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4498: FND_MSG_PUB.Add;
4499: END IF;

Line 4498: FND_MSG_PUB.Add;

4494: -- Debug Message
4495: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4496: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
4497: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4498: FND_MSG_PUB.Add;
4499: END IF;
4500: --Standard call to get message count and if count=1, get the message
4501: FND_MSG_PUB.Count_And_Get (
4502: p_encoded => FND_API.G_FALSE,

Line 4501: FND_MSG_PUB.Count_And_Get (

4497: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');
4498: FND_MSG_PUB.Add;
4499: END IF;
4500: --Standard call to get message count and if count=1, get the message
4501: FND_MSG_PUB.Count_And_Get (
4502: p_encoded => FND_API.G_FALSE,
4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );

Line 4511: FND_MSG_PUB.Count_And_Get (

4507: WHEN FND_API.G_EXC_ERROR THEN
4508: ROLLBACK TO Remove_CategoryParent;
4509: x_return_status := FND_API.G_RET_STS_ERROR;
4510: -- Standard call to get message count and if count=1, get the message
4511: FND_MSG_PUB.Count_And_Get (
4512: p_encoded => FND_API.G_FALSE,
4513: p_count => x_msg_count,
4514: p_data => x_msg_data
4515: );

Line 4520: FND_MSG_PUB.Count_And_Get (

4516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4517: ROLLBACK TO Remove_CategoryParent;
4518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4519: -- Standard call to get message count and if count=1, get the message
4520: FND_MSG_PUB.Count_And_Get (
4521: p_encoded => FND_API.G_FALSE,
4522: p_count => x_msg_count,
4523: p_data => x_msg_data
4524: );

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

4524: );
4525: WHEN OTHERS THEN
4526: ROLLBACK TO Remove_CategoryParent;
4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4528: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4529: THEN
4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;
4532: -- Standard call to get message count and if count=1, get the message

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

4526: ROLLBACK TO Remove_CategoryParent;
4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4528: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4529: THEN
4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;
4532: -- Standard call to get message count and if count=1, get the message
4533: FND_MSG_PUB.Count_And_Get (
4534: p_encoded => FND_API.G_FALSE,

Line 4533: FND_MSG_PUB.Count_And_Get (

4529: THEN
4530: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4531: END IF;
4532: -- Standard call to get message count and if count=1, get the message
4533: FND_MSG_PUB.Count_And_Get (
4534: p_encoded => FND_API.G_FALSE,
4535: p_count => x_msg_count,
4536: p_data => x_msg_data
4537: );