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

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

22: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvxelb.pls';
23: G_B2B_VIEW_NAME CONSTANT VARCHAR2(100) := 'AMS_HZ_B2B_MAPPING_V';
24: G_B2C_VIEW_NAME CONSTANT VARCHAR2(100) := 'AMS_HZ_B2C_MAPPING_V';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE write_msg(p_message IN VARCHAR2)

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

23: G_B2B_VIEW_NAME CONSTANT VARCHAR2(100) := 'AMS_HZ_B2B_MAPPING_V';
24: G_B2C_VIEW_NAME CONSTANT VARCHAR2(100) := 'AMS_HZ_B2C_MAPPING_V';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE write_msg(p_message IN VARCHAR2)
31: IS

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

24: G_B2C_VIEW_NAME CONSTANT VARCHAR2(100) := 'AMS_HZ_B2C_MAPPING_V';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: PROCEDURE write_msg(p_message IN VARCHAR2)
31: IS
32: BEGIN

Line 112: FND_MSG_PUB.Count_And_Get (

108: WHEN FND_API.G_EXC_ERROR THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util expected');END IF;
111: -- Standard call to get message count and if count=1, get the message
112: FND_MSG_PUB.Count_And_Get (
113: p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data
116: );

Line 121: FND_MSG_PUB.Count_And_Get (

117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util unexpected');END IF;
120: -- Standard call to get message count and if count=1, get the message
121: FND_MSG_PUB.Count_And_Get (
122: p_encoded => FND_API.G_FALSE,
123: p_count => x_msg_count,
124: p_data => x_msg_data
125: );

Line 130: FND_MSG_PUB.Count_And_Get (

126: WHEN OTHERS THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
128: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_Xml_Source_Lines_Util OTHERS');END IF;
129: -- Standard call to get message count and if count=1, get the message
130: FND_MSG_PUB.Count_And_Get (
131: p_encoded => FND_API.G_FALSE,
132: p_count => x_msg_count,
133: p_data => x_msg_data
134: );

Line 195: FND_MSG_PUB.Count_And_Get (

191: WHEN FND_API.G_EXC_ERROR THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines expected');END IF;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );

Line 204: FND_MSG_PUB.Count_And_Get (

200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines unexpected');END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );

Line 213: FND_MSG_PUB.Count_And_Get (

209: WHEN OTHERS THEN
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines OTHERS');END IF;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );

Line 308: FND_MSG_PUB.Count_And_Get (

304: WHEN FND_API.G_EXC_ERROR THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines expected');END IF;
307: -- Standard call to get message count and if count=1, get the message
308: FND_MSG_PUB.Count_And_Get (
309: p_encoded => FND_API.G_FALSE,
310: p_count => x_msg_count,
311: p_data => x_msg_data
312: );

Line 317: FND_MSG_PUB.Count_And_Get (

313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines unexpected');END IF;
316: -- Standard call to get message count and if count=1, get the message
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );

Line 326: FND_MSG_PUB.Count_And_Get (

322: WHEN OTHERS THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: Update_B2B_Xml_Source_lines OTHERS');END IF;
325: -- Standard call to get message count and if count=1, get the message
326: FND_MSG_PUB.Count_And_Get (
327: p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );

Line 402: FND_MSG_PUB.initialize;

398:
399: -- Initialize message list if p_init_msg_list is set to TRUE.
400: IF FND_API.to_Boolean( p_init_msg_list )
401: THEN
402: FND_MSG_PUB.initialize;
403: END IF;
404:
405: -- Debug Message
406: IF (AMS_DEBUG_HIGH_ON) THEN

Line 571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

567: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
568: END IF;
569:
570: -- Standard call to get message count and if count is 1, get message info.
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: EXCEPTION
575: WHEN AMS_Utility_PVT.resource_locked THEN

Line 587: FND_MSG_PUB.Count_And_Get (

583:
584: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_ERROR');
585: END IF;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data );
591:

Line 600: FND_MSG_PUB.Count_And_Get (

596:
597: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_UNEXPECTED_ERROR');
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );

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

609: IF (AMS_DEBUG_HIGH_ON) THEN
610:
611: AMS_UTILITY_PVT.debug_message('Private API: Exception OTHERS');
612: END IF;
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (

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

610:
611: AMS_UTILITY_PVT.debug_message('Private API: Exception OTHERS');
612: END IF;
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,

Line 617: FND_MSG_PUB.Count_And_Get (

613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
621: END Update_Error_Xml_Element;

Line 672: FND_MSG_PUB.initialize;

668:
669: -- Initialize message list if p_init_msg_list is set to TRUE.
670: IF FND_API.to_Boolean( p_init_msg_list )
671: THEN
672: FND_MSG_PUB.initialize;
673: END IF;
674:
675: -- Debug Message
676: IF (AMS_DEBUG_HIGH_ON) THEN

Line 785: FND_MSG_PUB.Count_And_Get

781: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
782: END IF;
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get
786: (p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789: EXCEPTION

Line 799: FND_MSG_PUB.Count_And_Get (

795: WHEN FND_API.G_EXC_ERROR THEN
796: ROLLBACK TO CREATE_Xml_Element_PVT;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: -- Standard call to get message count and if count=1, get the message
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );

Line 809: FND_MSG_PUB.Count_And_Get (

805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ROLLBACK TO CREATE_Xml_Element_PVT;
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: -- Standard call to get message count and if count=1, get the message
809: FND_MSG_PUB.Count_And_Get (
810: p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data
813: );

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

814:
815: WHEN OTHERS THEN
816: ROLLBACK TO CREATE_Xml_Element_PVT;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message

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

816: ROLLBACK TO CREATE_Xml_Element_PVT;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,

Line 823: FND_MSG_PUB.Count_And_Get (

819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_msg_count,
826: p_data => x_msg_data
827: );

Line 896: FND_MSG_PUB.initialize;

892:
893: -- Initialize message list if p_init_msg_list is set to TRUE.
894: IF FND_API.to_Boolean( p_init_msg_list )
895: THEN
896: FND_MSG_PUB.initialize;
897: END IF;
898:
899: -- Debug Message
900: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1077: FND_MSG_PUB.Count_And_Get

1073: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1074: END IF;
1075:
1076: -- Standard call to get message count and if count is 1, get message info.
1077: FND_MSG_PUB.Count_And_Get
1078: (p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081: EXCEPTION

Line 1095: FND_MSG_PUB.Count_And_Get (

1091:
1092: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_ERROR');
1093: END IF;
1094: -- Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );

Line 1109: FND_MSG_PUB.Count_And_Get (

1105:
1106: AMS_UTILITY_PVT.debug_message('Private API: Exception G_EXC_UNEXPECTED_ERROR');
1107: END IF;
1108: -- Standard call to get message count and if count=1, get the message
1109: FND_MSG_PUB.Count_And_Get (
1110: p_encoded => FND_API.G_FALSE,
1111: p_count => x_msg_count,
1112: p_data => x_msg_data
1113: );

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

1118: IF (AMS_DEBUG_HIGH_ON) THEN
1119:
1120: AMS_UTILITY_PVT.debug_message('Private API: Exception OTHERS');
1121: END IF;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1125: END IF;
1126: -- Standard call to get message count and if count=1, get the message

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

1120: AMS_UTILITY_PVT.debug_message('Private API: Exception OTHERS');
1121: END IF;
1122: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1125: END IF;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,

Line 1127: FND_MSG_PUB.Count_And_Get (

1123: THEN
1124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1125: END IF;
1126: -- Standard call to get message count and if count=1, get the message
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_msg_count,
1130: p_data => x_msg_data
1131: );

Line 1168: FND_MSG_PUB.initialize;

1164:
1165: -- Initialize message list if p_init_msg_list is set to TRUE.
1166: IF FND_API.to_Boolean( p_init_msg_list )
1167: THEN
1168: FND_MSG_PUB.initialize;
1169: END IF;
1170:
1171: -- Debug Message
1172: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1211: FND_MSG_PUB.Count_And_Get

1207: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1208: END IF;
1209:
1210: -- Standard call to get message count and if count is 1, get message info.
1211: FND_MSG_PUB.Count_And_Get
1212: (p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215: EXCEPTION

Line 1225: FND_MSG_PUB.Count_And_Get (

1221: WHEN FND_API.G_EXC_ERROR THEN
1222: ROLLBACK TO DELETE_Xml_Element_PVT;
1223: x_return_status := FND_API.G_RET_STS_ERROR;
1224: -- Standard call to get message count and if count=1, get the message
1225: FND_MSG_PUB.Count_And_Get (
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );

Line 1235: FND_MSG_PUB.Count_And_Get (

1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: ROLLBACK TO DELETE_Xml_Element_PVT;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data
1239: );

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

1240:
1241: WHEN OTHERS THEN
1242: ROLLBACK TO DELETE_Xml_Element_PVT;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: -- Standard call to get message count and if count=1, get the message

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

1242: ROLLBACK TO DELETE_Xml_Element_PVT;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,

Line 1249: FND_MSG_PUB.Count_And_Get (

1245: THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1253: );

Line 1295: FND_MSG_PUB.initialize;

1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean( p_init_msg_list )
1294: THEN
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Standard call to check for call compatibility.
1299: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1323: FETCH c_Xml_Element INTO l_IMP_XML_ELEMENT_ID;
1324:
1325: IF (c_Xml_Element%NOTFOUND) THEN
1326: CLOSE c_Xml_Element;
1327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1329: FND_MSG_PUB.add;
1330: END IF;
1331: RAISE FND_API.g_exc_error;

Line 1329: FND_MSG_PUB.add;

1325: IF (c_Xml_Element%NOTFOUND) THEN
1326: CLOSE c_Xml_Element;
1327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1329: FND_MSG_PUB.add;
1330: END IF;
1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:

Line 1337: FND_MSG_PUB.count_and_get(

1333:
1334: CLOSE c_Xml_Element;
1335:
1336: -------------------- finish --------------------------
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: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1355: FND_MSG_PUB.Count_And_Get (

1351: WHEN FND_API.G_EXC_ERROR THEN
1352: ROLLBACK TO LOCK_Xml_Element_PVT;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: -- Standard call to get message count and if count=1, get the message
1355: FND_MSG_PUB.Count_And_Get (
1356: p_encoded => FND_API.G_FALSE,
1357: p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );

Line 1365: FND_MSG_PUB.Count_And_Get (

1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO LOCK_Xml_Element_PVT;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: -- Standard call to get message count and if count=1, get the message
1365: FND_MSG_PUB.Count_And_Get (
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data
1369: );

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

1370:
1371: WHEN OTHERS THEN
1372: ROLLBACK TO LOCK_Xml_Element_PVT;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message

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

1372: ROLLBACK TO LOCK_Xml_Element_PVT;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,

Line 1379: FND_MSG_PUB.Count_And_Get (

1375: THEN
1376: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1377: END IF;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1383: );

Line 1743: FND_MSG_PUB.initialize;

1739:
1740: -- Initialize message list if p_init_msg_list is set to TRUE.
1741: IF FND_API.to_Boolean( p_init_msg_list )
1742: THEN
1743: FND_MSG_PUB.initialize;
1744: END IF;
1745: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1746: Check_xml_element_Items(
1747: p_xml_element_rec => p_xml_element_rec,

Line 1799: FND_MSG_PUB.Count_And_Get

1795: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1796: END IF;
1797:
1798: -- Standard call to get message count and if count is 1, get message info.
1799: FND_MSG_PUB.Count_And_Get
1800: (p_count => x_msg_count,
1801: p_data => x_msg_data
1802: );
1803: EXCEPTION

Line 1813: FND_MSG_PUB.Count_And_Get (

1809: WHEN FND_API.G_EXC_ERROR THEN
1810: ROLLBACK TO VALIDATE_Xml_Element_;
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812: -- Standard call to get message count and if count=1, get the message
1813: FND_MSG_PUB.Count_And_Get (
1814: p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => x_msg_data
1817: );

Line 1823: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1837: FND_MSG_PUB.Count_And_Get (

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

Line 1858: FND_MSG_PUB.initialize;

1854: BEGIN
1855: -- Initialize message list if p_init_msg_list is set to TRUE.
1856: IF FND_API.to_Boolean( p_init_msg_list )
1857: THEN
1858: FND_MSG_PUB.initialize;
1859: END IF;
1860:
1861: -- Initialize API return status to SUCCESS
1862: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1875: FND_MSG_PUB.Count_And_Get

1871:
1872: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1873: END IF;
1874: -- Standard call to get message count and if count is 1, get message info.
1875: FND_MSG_PUB.Count_And_Get
1876: (p_count => x_msg_count,
1877: p_data => x_msg_data
1878: );
1879: END Validate_xml_element_Rec;