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_MESSAGE

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

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

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

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

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

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

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

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

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

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;
653: END IF;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;

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

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

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

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;
695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: ELSE

Line 744: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
747: FND_MSG_PUB.Add;
748: END IF;

Line 745: FND_MESSAGE.Set_Token('ACTION', 'Adding');

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');
747: FND_MSG_PUB.Add;
748: END IF;
749: RAISE FND_API.G_EXC_ERROR;

Line 746: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
747: FND_MSG_PUB.Add;
748: END IF;
749: RAISE FND_API.G_EXC_ERROR;
750: END;

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

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

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

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

Line 768: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');

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

Line 769: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
771: END IF;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;

Line 779: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');

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

Line 780: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
782: END IF;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;

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

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

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

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;
793: END IF;
794: --Standard check of commit
795: IF FND_API.To_Boolean ( p_commit ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
996: END IF;
997: RAISE FND_API.G_EXC_ERROR;
998: ELSE

Line 1028: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');

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

Line 1029: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
1031: END IF;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;

Line 1039: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');

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

Line 1040: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
1042: END IF;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;

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

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

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

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;
1112: END IF;
1113: --Standard check of commit
1114: IF FND_API.To_Boolean ( p_commit ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
1320: END IF;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;

Line 1383: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
1386: FND_MSG_PUB.Add;
1387: END IF;

Line 1384: FND_MESSAGE.Set_Token('ACTION', 'Sorting');

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');
1386: FND_MSG_PUB.Add;
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;

Line 1385: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
1386: FND_MSG_PUB.Add;
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;
1389: END;

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

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

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

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;
1399: END IF;
1400: --Standard check of commit
1401: IF FND_API.To_Boolean ( p_commit ) THEN

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

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

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

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

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

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

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

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

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

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

Line 1594: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
1597: FND_MSG_PUB.Add;
1598: END IF;

Line 1595: FND_MESSAGE.Set_Token('ACTION', 'Reordering');

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');
1597: FND_MSG_PUB.Add;
1598: END IF;
1599: RAISE FND_API.G_EXC_ERROR;

Line 1596: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
1597: FND_MSG_PUB.Add;
1598: END IF;
1599: RAISE FND_API.G_EXC_ERROR;
1600: END;

Line 1606: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_REORDER_ERROR');

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

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

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

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

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;
1619: END IF;
1620: --Standard check of commit
1621: IF FND_API.To_Boolean ( p_commit ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
1846: END IF;
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;

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

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

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

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;
1896: END IF;
1897: RAISE FND_API.G_EXC_ERROR;
1898: ELSE

Line 1928: FND_MESSAGE.Set_Name('AMV', 'AMV_NO_ACCESS_ERROR');

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

Line 1929: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
1931: END IF;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;

Line 1939: FND_MESSAGE.Set_Name('AMV', 'AMV_SETUP_CHECK_ERROR');

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

Line 1940: FND_MESSAGE.Set_Token('LEVEL','Category');

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;
1942: END IF;
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;

Line 1993: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
1996: FND_MSG_PUB.Add;
1997: END IF;

Line 1994: FND_MESSAGE.Set_Token('ACTION', 'Updating');

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');
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;

Line 1995: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
1996: FND_MSG_PUB.Add;
1997: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END;

Line 2003: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');

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

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

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

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

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;
2017: END IF;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;

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

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

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

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;
2028: END IF;
2029: --Standard check of commit
2030: IF FND_API.To_Boolean ( p_commit ) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
2298: END IF;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;

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

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

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

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

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

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

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

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

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

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

Line 2714: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 2715: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
2717: END IF;
2718: RAISE FND_API.G_EXC_ERROR;
2719: END IF;

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

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

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

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

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

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

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

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

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

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

Line 2944: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 2945: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
2947: END IF;
2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;

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

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

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

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

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

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

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

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

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

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

Line 3239: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 3240: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
3242: END IF;
3243: RAISE FND_API.G_EXC_ERROR;
3244: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
3432: END IF;
3433: RAISE FND_API.G_EXC_ERROR;
3434: END IF;

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

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

Line 3439: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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

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

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

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

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

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

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

Line 3599: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 3600: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
3602: END IF;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;

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

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

Line 3610: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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

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

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

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

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

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

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

Line 3770: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 3771: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
3773: END IF;
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;

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

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

Line 3781: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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

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

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

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

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

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

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

Line 3955: FND_MESSAGE.Set_Name('AMV', 'AMV_CHANNEL_ID_INVALID');

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

Line 3956: FND_MESSAGE.Set_Token('TKN',p_channel_id);

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;
3958: END IF;
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;

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

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

Line 3966: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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

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

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

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

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

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

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

Line 4165: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 4166: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);

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;
4168: END IF;
4169: RAISE FND_API.G_EXC_ERROR;
4170: END IF;

Line 4174: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 4175: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
4177: END IF;
4178: RAISE FND_API.G_EXC_ERROR;
4179: END IF;

Line 4197: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_LOOPING');

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

Line 4198: FND_MESSAGE.Set_Token('TKN',p_parent_category_id);

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;
4200: END IF;
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;

Line 4218: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_NAME_EXISTS');

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

Line 4219: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
4221: END IF;
4222: RAISE FND_API.G_EXC_ERROR;
4223: END IF;

Line 4242: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
4245: FND_MSG_PUB.Add;
4246: END IF;

Line 4243: FND_MESSAGE.Set_Token('ACTION', 'Updating');

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');
4245: FND_MSG_PUB.Add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;

Line 4244: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
4245: FND_MSG_PUB.Add;
4246: END IF;
4247: RAISE FND_API.G_EXC_ERROR;
4248: END;

Line 4252: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');

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

Line 4260: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_PARENT_EXISTS');

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

Line 4261: FND_MESSAGE.Set_Token('TKN',l_parent_category_id);

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;
4263: END IF;
4264: RAISE FND_API.G_EXC_ERROR;
4265: END IF;

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

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

Line 4276: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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

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

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

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

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

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

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

Line 4463: FND_MESSAGE.Set_Name('AMV', 'AMV_TABLE_HANDLER_ERROR');

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');
4466: FND_MSG_PUB.Add;
4467: END IF;

Line 4464: FND_MESSAGE.Set_Token('ACTION', 'Updating');

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');
4466: FND_MSG_PUB.Add;
4467: END IF;
4468: RAISE FND_API.G_EXC_ERROR;

Line 4465: FND_MESSAGE.Set_Token('TABLE', 'Categories');

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');
4466: FND_MSG_PUB.Add;
4467: END IF;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END;

Line 4473: FND_MESSAGE.Set_Name('AMV', 'AMV_CAT_VERSION_CHANGE');

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

Line 4481: FND_MESSAGE.Set_Name('AMV', 'AMV_CATEGORY_ID_INVALID');

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

Line 4482: FND_MESSAGE.Set_Token('TKN',p_category_id);

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;
4484: END IF;
4485: RAISE FND_API.G_EXC_ERROR;
4486: END IF;

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

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

Line 4497: FND_MESSAGE.Set_Token('ROW',l_full_name||': END');

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