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.AMS_ITEM_OWNER_PVT dependencies on FND_MSG_PUB

Line 45: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

41: -- passed in is as controlled by status code.
42: -- History
43: -- 07/31/2001 musman@us created
44: --------------------------------------------------------------------------
45: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: FUNCTION is_it_status_control_attr

Line 46: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

42: -- History
43: -- 07/31/2001 musman@us created
44: --------------------------------------------------------------------------
45: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: FUNCTION is_it_status_control_attr
50: ( p_attribute_name IN VARCHAR2

Line 47: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

43: -- 07/31/2001 musman@us created
44: --------------------------------------------------------------------------
45: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: FUNCTION is_it_status_control_attr
50: ( p_attribute_name IN VARCHAR2
51: ) RETURN VARCHAR2;

Line 145: FND_MSG_PUB.initialize;

141:
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list )
144: THEN
145: FND_MSG_PUB.initialize;
146: END IF;
147:
148: -- Debug Message
149: IF (AMS_DEBUG_HIGH_ON) THEN

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

162: -- Validate Environment
163: -- ******************************************************************
164: IF FND_GLOBAL.User_Id IS NULL
165: THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
167: THEN
168: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
169: FND_MSG_PUB.ADD;
170: END IF;

Line 169: FND_MSG_PUB.ADD;

165: THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
167: THEN
168: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
169: FND_MSG_PUB.ADD;
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:

Line 438: FND_MSG_PUB.Count_And_Get

434: -- Debug Message
435: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end'); END IF;
436:
437: -- Standard call to get message count and if count is 1, get message info.
438: FND_MSG_PUB.Count_And_Get
439: (p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: EXCEPTION

Line 447: FND_MSG_PUB.Count_And_Get (

443: WHEN FND_API.G_EXC_ERROR THEN
444: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: -- Standard call to get message count and if count=1, get the message
447: FND_MSG_PUB.Count_And_Get (
448: p_encoded => FND_API.G_FALSE,
449: p_count => x_msg_count,
450: p_data => x_msg_data
451: );

Line 456: FND_MSG_PUB.Count_And_Get (

452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: -- Standard call to get message count and if count=1, get the message
456: FND_MSG_PUB.Count_And_Get (
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data
460: );

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

460: );
461: WHEN OTHERS THEN
462: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message

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

462: -- ROLLBACK TO CREATE_ITEM_OWNER_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,

Line 469: FND_MSG_PUB.Count_And_Get (

465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 560: FND_MSG_PUB.initialize;

556:
557: -- Initialize message list if p_init_msg_list is set to TRUE.
558: IF FND_API.to_Boolean( p_init_msg_list )
559: THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Debug Message
564: IF (AMS_DEBUG_HIGH_ON) THEN

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

597: ***/
598: l_can_update_inv_item := FND_PROFILE.value('AMS_ALLOW_INVENTORY_UPDATE');
599:
600: if (l_can_update_inv_item = 'N') AND (IS_OMO_ITEM = 'N') then
601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
602: THEN
603: FND_MESSAGE.Set_Name('AMS', 'AMS_CANNOT_UPDATE_INV_ITEM');
604: FND_MSG_PUB.Add;
605: END IF;

Line 604: FND_MSG_PUB.Add;

600: if (l_can_update_inv_item = 'N') AND (IS_OMO_ITEM = 'N') then
601: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
602: THEN
603: FND_MESSAGE.Set_Name('AMS', 'AMS_CANNOT_UPDATE_INV_ITEM');
604: FND_MSG_PUB.Add;
605: END IF;
606: raise FND_API.G_EXC_ERROR;
607: end if;
608: /******************* end by ABHOLA ****************************************/

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

625:
626:
627:
628: If ( C_Get_item_owner%NOTFOUND) Then
629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
630: THEN
631: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
632: FND_MESSAGE.Set_Token ('INFO', 'item_owner', FALSE);
633: FND_MSG_PUB.Add;

Line 633: FND_MSG_PUB.Add;

629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
630: THEN
631: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
632: FND_MESSAGE.Set_Token ('INFO', 'item_owner', FALSE);
633: FND_MSG_PUB.Add;
634: END IF;
635: raise FND_API.G_EXC_ERROR;
636: END IF;
637: -- Debug Message

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

645: if (IS_OMO_ITEM = 'Y') then
646:
647: If (l_tar_ITEM_OWNER_rec.object_version_number is NULL or
648: l_tar_ITEM_OWNER_rec.object_version_number = FND_API.G_MISS_NUM ) Then
649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
650: THEN
651: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
652: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
653: FND_MSG_PUB.ADD;

Line 653: FND_MSG_PUB.ADD;

649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
650: THEN
651: FND_MESSAGE.Set_Name('AMS', 'API_VERSION_MISSING');
652: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
653: FND_MSG_PUB.ADD;
654: END IF;
655: raise FND_API.G_EXC_ERROR;
656: End if;
657:

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

659:
660:
661: -- Check Whether record has been changed by someone else
662: If (l_tar_ITEM_OWNER_rec.object_version_number <> l_ref_ITEM_OWNER_rec.object_version_number) Then
663: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
664: THEN
665: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
666: FND_MESSAGE.Set_Token('INFO', 'item_owner', FALSE);
667: FND_MSG_PUB.ADD;

Line 667: FND_MSG_PUB.ADD;

663: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
664: THEN
665: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
666: FND_MESSAGE.Set_Token('INFO', 'item_owner', FALSE);
667: FND_MSG_PUB.ADD;
668: END IF;
669: raise FND_API.G_EXC_ERROR;
670: End if;
671:

Line 677: FND_MSG_PUB.Add;

673:
674: /* Bug fix start */
675: IF (l_ref_ITEM_OWNER_rec.STATUS_CODE='CANCEL')THEN
676: FND_MESSAGE.Set_Name('AMS', 'AMS_CANNOT_UPDATE_PRODUCT');
677: FND_MSG_PUB.Add;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: /* Bug fix ends*/
681: /* calling validate item */

Line 939: FND_MSG_PUB.Count_And_Get

935: -- Debug Message
936: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end'); END IF;
937:
938: -- Standard call to get message count and if count is 1, get message info.
939: FND_MSG_PUB.Count_And_Get
940: (p_count => x_msg_count,
941: p_data => x_msg_data
942: );
943: EXCEPTION

Line 948: FND_MSG_PUB.Count_And_Get (

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

Line 957: FND_MSG_PUB.Count_And_Get (

953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data
961: );

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

961: );
962: WHEN OTHERS THEN
963: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
966: THEN
967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;
969: -- Standard call to get message count and if count=1, get the message

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

963: -- ROLLBACK TO UPDATE_ITEM_OWNER_PVT;
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
966: THEN
967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;
969: -- Standard call to get message count and if count=1, get the message
970: FND_MSG_PUB.Count_And_Get (
971: p_encoded => FND_API.G_FALSE,

Line 970: FND_MSG_PUB.Count_And_Get (

966: THEN
967: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
968: END IF;
969: -- Standard call to get message count and if count=1, get the message
970: FND_MSG_PUB.Count_And_Get (
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );

Line 1011: FND_MSG_PUB.initialize;

1007:
1008: -- Initialize message list if p_init_msg_list is set to TRUE.
1009: IF FND_API.to_Boolean( p_init_msg_list )
1010: THEN
1011: FND_MSG_PUB.initialize;
1012: END IF;
1013:
1014: -- Debug Message
1015: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1054: FND_MSG_PUB.Count_And_Get

1050: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get
1055: (p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: EXCEPTION

Line 1063: FND_MSG_PUB.Count_And_Get (

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

Line 1072: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1085: FND_MSG_PUB.Count_And_Get (

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

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

1113: OPEN c_ITEM_OWNER;
1114: FETCH c_ITEM_OWNER INTO l_ITEM_OWNER_Rec_Type;
1115: IF c_ITEM_OWNER%NOTFOUND THEN
1116: CLOSE c_ITEM_OWNER;
1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1118: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1119: FND_MSG_PUB.add;
1120: END IF;
1121: RAISE FND_API.g_exc_error;

Line 1119: FND_MSG_PUB.add;

1115: IF c_ITEM_OWNER%NOTFOUND THEN
1116: CLOSE c_ITEM_OWNER;
1117: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1118: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1119: FND_MSG_PUB.add;
1120: END IF;
1121: RAISE FND_API.g_exc_error;
1122: END IF;
1123: CLOSE c_ITEM_OWNER;

Line 1184: FND_MSG_PUB.initialize;

1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE.
1182: IF FND_API.to_Boolean( p_init_msg_list )
1183: THEN
1184: FND_MSG_PUB.initialize;
1185: END IF;
1186:
1187: -- Debug Message
1188: IF (AMS_DEBUG_HIGH_ON) THEN

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

1197: -- check 1 : both inv item flag and service item cannot be Y
1198: IF (( P_ITEM_REC_In.INVENTORY_ITEM_FLAG = 'Y')
1199: AND ( P_ITEM_REC_In.SERVICE_ITEM_FLAG = 'Y'))
1200: THEN
1201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1202: THEN
1203: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_SRV_ITM_FLG_ERR');
1204: FND_MSG_PUB.Add;
1205: END IF;

Line 1204: FND_MSG_PUB.Add;

1200: THEN
1201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1202: THEN
1203: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_SRV_ITM_FLG_ERR');
1204: FND_MSG_PUB.Add;
1205: END IF;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:

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

1209: -- check 2 : both service item flag and service able product flag cannot be Y
1210: IF (( P_ITEM_REC_In.SERVICEABLE_PRODUCT_FLAG = 'Y')
1211: AND ( P_ITEM_REC_In.SERVICE_ITEM_FLAG = 'Y'))
1212: THEN
1213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1214: THEN
1215: FND_MESSAGE.Set_Name('AMS', 'AMS_SRPRD_SRV_ITM_FLG_ERR');
1216: FND_MSG_PUB.Add;
1217: END IF;

Line 1216: FND_MSG_PUB.Add;

1212: THEN
1213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1214: THEN
1215: FND_MESSAGE.Set_Name('AMS', 'AMS_SRPRD_SRV_ITM_FLG_ERR');
1216: FND_MSG_PUB.Add;
1217: END IF;
1218: raise FND_API.G_EXC_ERROR;
1219: END IF;
1220:

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

1223: -- if warranty is Y, then service has to be Y
1224: IF (( P_ITEM_REC_In.VENDOR_WARRANTY_FLAG = 'Y')
1225: AND ( P_ITEM_REC_In.SERVICE_ITEM_FLAG = 'N'))
1226: THEN
1227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1228: THEN
1229: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRV_ERR');
1230: FND_MSG_PUB.Add;
1231: END IF;

Line 1230: FND_MSG_PUB.Add;

1226: THEN
1227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1228: THEN
1229: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRV_ERR');
1230: FND_MSG_PUB.Add;
1231: END IF;
1232: raise FND_API.G_EXC_ERROR;
1233: END IF;
1234: */

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

1236: /**
1237: IF (( P_ITEM_REC_In.VENDOR_WARRANTY_FLAG = 'Y') AND
1238: ( P_ITEM_REC_In.SERVICE_DURATION_PERIOD_CODE IS NULL ) OR ( P_ITEM_REC_In.COVERAGE_SCHEDULE_ID IS NULL ))
1239: THEN
1240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1241: THEN
1242: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRVDUR_PER_ERR');
1243: FND_MSG_PUB.Add;
1244: END IF;

Line 1243: FND_MSG_PUB.Add;

1239: THEN
1240: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1241: THEN
1242: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRANTY_SRVDUR_PER_ERR');
1243: FND_MSG_PUB.Add;
1244: END IF;
1245: raise FND_API.G_EXC_ERROR;
1246: END IF;
1247: **/

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

1251: -- if BOM flag is Y , INV ITEM should also be Y
1252: IF (( P_ITEM_REC_In.INVENTORY_ITEM_FLAG = 'N')
1253: AND ( P_ITEM_REC_In.BOM_ENABLED_FLAG = 'Y'))
1254: THEN
1255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1256: THEN
1257: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_BOM_FLG_ERR');
1258: FND_MSG_PUB.Add;
1259: END IF;

Line 1258: FND_MSG_PUB.Add;

1254: THEN
1255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1256: THEN
1257: FND_MESSAGE.Set_Name('AMS', 'AMS_INV_BOM_FLG_ERR');
1258: FND_MSG_PUB.Add;
1259: END IF;
1260: raise FND_API.G_EXC_ERROR;
1261: END IF;
1262: */

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

1264: /**
1265: IF (( P_ITEM_REC_In.VENDOR_WARRANTY_FLAG = 'N' )
1266: AND ( P_ITEM_REC_In.SERVICE_DURATION_PERIOD_CODE IS NOT NULL ) OR ( P_ITEM_REC_In.COVERAGE_SCHEDULE_ID IS NOT NULL ) )
1267: THEN
1268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1269: THEN
1270: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRN_SRV_COMB_ERR');
1271: FND_MSG_PUB.Add;
1272: END IF;

Line 1271: FND_MSG_PUB.Add;

1267: THEN
1268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1269: THEN
1270: FND_MESSAGE.Set_Name('AMS', 'AMS_WARRN_SRV_COMB_ERR');
1271: FND_MSG_PUB.Add;
1272: END IF;
1273: raise FND_API.G_EXC_ERROR;
1274: END IF;
1275: ***/

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

1279: OR P_ITEM_REC_In.BOM_ITEM_TYPE = 2 ) -- option Class
1280: AND P_ITEM_REC_In.PICK_COMPONENTS_FLAG <> 'Y'
1281: AND P_ITEM_REC_In.REPLENISH_TO_ORDER_FLAG <> 'Y')
1282: THEN
1283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1284: THEN
1285: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_BOM_ERROR');
1286: FND_MSG_PUB.Add;
1287: END IF;

Line 1286: FND_MSG_PUB.Add;

1282: THEN
1283: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1284: THEN
1285: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_BOM_ERROR');
1286: FND_MSG_PUB.Add;
1287: END IF;
1288: raise FND_API.G_EXC_ERROR;
1289: END IF;
1290:

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

1292:
1293: IF ( P_ITEM_REC_In.SUBSCRIPTION_DEPEND_FLAG = 'Y'
1294: AND P_ITEM_REC_In.CONTRACT_ITEM_TYPE_CODE <> 'SUBSCRIPTION' )
1295: THEN
1296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1297: THEN
1298: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_SUBSCRIP_ERROR');
1299: FND_MSG_PUB.Add;
1300: END IF;

Line 1299: FND_MSG_PUB.Add;

1295: THEN
1296: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1297: THEN
1298: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_SUBSCRIP_ERROR');
1299: FND_MSG_PUB.Add;
1300: END IF;
1301: raise FND_API.G_EXC_ERROR;
1302: END IF;
1303:

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

1305: -- if contract item type code is subscription ,service _item_flag has to 'Y'
1306: IF ( P_ITEM_REC_In.CONTRACT_ITEM_TYPE_CODE = 'SUBSCRIPTION'
1307: AND P_ITEM_REC_In.SERVICE_ITEM_FLAG <> 'Y' )
1308: THEN
1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1310: THEN
1311: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_CONTRACT_ERROR');
1312: FND_MSG_PUB.Add;
1313: END IF;

Line 1312: FND_MSG_PUB.Add;

1308: THEN
1309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1310: THEN
1311: FND_MESSAGE.Set_Name('AMS', 'AMS_PROD_CONTRACT_ERROR');
1312: FND_MSG_PUB.Add;
1313: END IF;
1314: raise FND_API.G_EXC_ERROR;
1315: END IF;
1316: */

Line 1319: FND_MSG_PUB.Count_And_Get

1315: END IF;
1316: */
1317:
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );
1323: EXCEPTION

Line 1328: FND_MSG_PUB.Count_And_Get (

1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

Line 1337: FND_MSG_PUB.Count_And_Get (

1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: -- Standard call to get message count and if count=1, get the message
1337: FND_MSG_PUB.Count_And_Get (
1338: p_encoded => FND_API.G_FALSE,
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );

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

1341: );
1342: WHEN OTHERS THEN
1343: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;
1349: -- Standard call to get message count and if count=1, get the message

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

1343: ROLLBACK TO VALIDATE_ITEM_OWNER_;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;
1349: -- Standard call to get message count and if count=1, get the message
1350: FND_MSG_PUB.Count_And_Get (
1351: p_encoded => FND_API.G_FALSE,

Line 1350: FND_MSG_PUB.Count_And_Get (

1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1348: END IF;
1349: -- Standard call to get message count and if count=1, get the message
1350: FND_MSG_PUB.Count_And_Get (
1351: p_encoded => FND_API.G_FALSE,
1352: p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );