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.PV_GQ_ELEMENTS_PVT dependencies on STANDARD

Line 71: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

67: -- x_return_status OUT VARCHAR2
68: -- x_msg_count OUT NUMBER
69: -- x_msg_data OUT VARCHAR2
70: -- Version : Current version 1.0
71: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
72: -- and basic operation, developer must manually add parameters and business logic as necessary.
73: --
74: -- History
75: --

Line 118: -- Standard Start of API savepoint

114: SELECT 1
115: FROM PV_GE_QSNR_ELEMENTS_B
116: WHERE qsnr_element_id = l_id;
117: BEGIN
118: -- Standard Start of API savepoint
119: SAVEPOINT create_gq_elements_pvt;
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 121: -- Standard call to check for call compatibility.

117: BEGIN
118: -- Standard Start of API savepoint
119: SAVEPOINT create_gq_elements_pvt;
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)

Line 248: -- Standard check for p_commit

244: --
245: -- End of API body
246: --
247:
248: -- Standard check for p_commit
249: IF FND_API.to_Boolean( p_commit )
250: THEN
251: COMMIT WORK;
252: END IF;

Line 262: -- Standard call to get message count and if count is 1, get message info.

258: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
259: END IF;
260:
261:
262: -- Standard call to get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get
264: (p_count => x_msg_count,
265: p_data => x_msg_data
266: );

Line 276: -- Standard call to get message count and if count=1, get the message

272:
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO CREATE_Gq_Elements_PVT;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data

Line 286: -- Standard call to get message count and if count=1, get the message

282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO CREATE_Gq_Elements_PVT;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: -- Standard call to get message count and if count=1, get the message
287: FND_MSG_PUB.Count_And_Get (
288: p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data

Line 300: -- Standard call to get message count and if count=1, get the message

296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
297: THEN
298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
299: END IF;
300: -- Standard call to get message count and if count=1, get the message
301: FND_MSG_PUB.Count_And_Get (
302: p_encoded => FND_API.G_FALSE,
303: p_count => x_msg_count,
304: p_data => x_msg_data

Line 394: -- Standard Start of API savepoint

390: PRGM_SOURCE_LANG_ARRAY varcharArray;
391: PRGM_LANGUAGE_ARRAY varcharArray;
392:
393: BEGIN
394: -- Standard Start of API savepoint
395: SAVEPOINT Copy_Row;
396:
397: -- Standard call to check for call compatibility.
398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 397: -- Standard call to check for call compatibility.

393: BEGIN
394: -- Standard Start of API savepoint
395: SAVEPOINT Copy_Row;
396:
397: -- Standard call to check for call compatibility.
398: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)

Line 599: -- Standard call to get message count and if count=1, get the message

595:
596: WHEN FND_API.G_EXC_ERROR THEN
597: ROLLBACK TO Copy_Row;
598: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 609: -- Standard call to get message count and if count=1, get the message

605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO Copy_Row;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: -- Standard call to get message count and if count=1, get the message
610: FND_MSG_PUB.Count_And_Get (
611: p_encoded => FND_API.G_FALSE,
612: p_count => x_msg_count,
613: p_data => x_msg_data

Line 623: -- Standard call to get message count and if count=1, get the message

619: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
620: THEN
621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
622: END IF;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data

Line 657: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

653: -- x_return_status OUT VARCHAR2
654: -- x_msg_count OUT NUMBER
655: -- x_msg_data OUT VARCHAR2
656: -- Version : Current version 1.0
657: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
658: -- and basic operation, developer must manually add parameters and business logic as necessary.
659: --
660: -- History
661: --

Line 702: -- Standard Start of API savepoint

698: l_tar_qsnr_element_rec qsnr_element_rec_type := p_qsnr_element_rec;
699: l_rowid ROWID;
700:
701: BEGIN
702: -- Standard Start of API savepoint
703: SAVEPOINT update_gq_elements_pvt;
704:
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 705: -- Standard call to check for call compatibility.

701: BEGIN
702: -- Standard Start of API savepoint
703: SAVEPOINT update_gq_elements_pvt;
704:
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)

Line 865: -- Standard check for p_commit

861: --
862: -- End of API body.
863: --
864:
865: -- Standard check for p_commit
866: IF FND_API.to_Boolean( p_commit )
867: THEN
868: COMMIT WORK;
869: END IF;

Line 879: -- Standard call to get message count and if count is 1, get message info.

875: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
876: END IF;
877:
878:
879: -- Standard call to get message count and if count is 1, get message info.
880: FND_MSG_PUB.Count_And_Get
881: (p_count => x_msg_count,
882: p_data => x_msg_data
883: );

Line 893: -- Standard call to get message count and if count=1, get the message

889:
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO UPDATE_Gq_Elements_PVT;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: -- Standard call to get message count and if count=1, get the message
894: FND_MSG_PUB.Count_And_Get (
895: p_encoded => FND_API.G_FALSE,
896: p_count => x_msg_count,
897: p_data => x_msg_data

Line 903: -- Standard call to get message count and if count=1, get the message

899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: ROLLBACK TO UPDATE_Gq_Elements_PVT;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: -- Standard call to get message count and if count=1, get the message
904: FND_MSG_PUB.Count_And_Get (
905: p_encoded => FND_API.G_FALSE,
906: p_count => x_msg_count,
907: p_data => x_msg_data

Line 917: -- Standard call to get message count and if count=1, get the message

913: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
914: THEN
915: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
916: END IF;
917: -- Standard call to get message count and if count=1, get the message
918: FND_MSG_PUB.Count_And_Get (
919: p_encoded => FND_API.G_FALSE,
920: p_count => x_msg_count,
921: p_data => x_msg_data

Line 950: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

946: -- x_return_status OUT VARCHAR2
947: -- x_msg_count OUT NUMBER
948: -- x_msg_data OUT VARCHAR2
949: -- Version : Current version 1.0
950: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
951: -- and basic operation, developer must manually add parameters and business logic as necessary.
952: --
953: -- History
954: --

Line 991: -- Standard Start of API savepoint

987: l_get_elmt_greater_than c_get_elmt_greater_than%ROWTYPE;
988: l_qsnr_element_rec qsnr_element_rec_type := g_miss_qsnr_element_rec;
989:
990: BEGIN
991: -- Standard Start of API savepoint
992: SAVEPOINT delete_gq_elements_pvt;
993:
994: -- Standard call to check for call compatibility.
995: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 994: -- Standard call to check for call compatibility.

990: BEGIN
991: -- Standard Start of API savepoint
992: SAVEPOINT delete_gq_elements_pvt;
993:
994: -- Standard call to check for call compatibility.
995: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
996: p_api_version_number,
997: l_api_name,
998: G_PKG_NAME)

Line 1075: -- Standard check for p_commit

1071: --
1072: -- End of API body
1073: --
1074:
1075: -- Standard check for p_commit
1076: IF FND_API.to_Boolean( p_commit )
1077: THEN
1078: COMMIT WORK;
1079: END IF;

Line 1089: -- Standard call to get message count and if count is 1, get message info.

1085: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1086: END IF;
1087:
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get
1091: (p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );

Line 1103: -- Standard call to get message count and if count=1, get the message

1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO DELETE_Gq_Elements_PVT;
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data

Line 1113: -- Standard call to get message count and if count=1, get the message

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

Line 1127: -- Standard call to get message count and if count=1, get the message

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

Line 1160: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1156: -- x_return_status OUT VARCHAR2
1157: -- x_msg_count OUT NUMBER
1158: -- x_msg_data OUT VARCHAR2
1159: -- Version : Current version 1.0
1160: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1161: -- and basic operation, developer must manually add parameters and business logic as necessary.
1162: --
1163: -- History
1164: --

Line 1201: -- Standard Start of API savepoint

1197: l_get_elmt_greater_than c_get_elmt_greater_than%ROWTYPE;
1198: l_qsnr_element_rec qsnr_element_rec_type := g_miss_qsnr_element_rec;
1199:
1200: BEGIN
1201: -- Standard Start of API savepoint
1202: SAVEPOINT Delete_Gq_PB_Elements_pvt;
1203:
1204: -- Standard call to check for call compatibility.
1205: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1204: -- Standard call to check for call compatibility.

1200: BEGIN
1201: -- Standard Start of API savepoint
1202: SAVEPOINT Delete_Gq_PB_Elements_pvt;
1203:
1204: -- Standard call to check for call compatibility.
1205: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1206: p_api_version_number,
1207: l_api_name,
1208: G_PKG_NAME)

Line 1303: -- Standard check for p_commit

1299: --
1300: -- End of API body
1301: --
1302:
1303: -- Standard check for p_commit
1304: IF FND_API.to_Boolean( p_commit )
1305: THEN
1306: COMMIT WORK;
1307: END IF;

Line 1317: -- Standard call to get message count and if count is 1, get message info.

1313: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1314: END IF;
1315:
1316:
1317: -- Standard call to get message count and if count is 1, get message info.
1318: FND_MSG_PUB.Count_And_Get
1319: (p_count => x_msg_count,
1320: p_data => x_msg_data
1321: );

Line 1331: -- Standard call to get message count and if count=1, get the message

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

Line 1341: -- Standard call to get message count and if count=1, get the message

1337:
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: ROLLBACK TO Delete_Gq_PB_Elements_PVT;
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: -- Standard call to get message count and if count=1, get the message
1342: FND_MSG_PUB.Count_And_Get (
1343: p_encoded => FND_API.G_FALSE,
1344: p_count => x_msg_count,
1345: p_data => x_msg_data

Line 1355: -- Standard call to get message count and if count=1, get the message

1351: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1352: THEN
1353: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1354: END IF;
1355: -- Standard call to get message count and if count=1, get the message
1356: FND_MSG_PUB.Count_And_Get (
1357: p_encoded => FND_API.G_FALSE,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data

Line 1389: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1385: -- x_return_status OUT VARCHAR2
1386: -- x_msg_count OUT NUMBER
1387: -- x_msg_data OUT VARCHAR2
1388: -- Version : Current version 1.0
1389: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1390: -- and basic operation, developer must manually add parameters and business logic as necessary.
1391: --
1392: -- History
1393: --

Line 1434: -- Standard call to check for call compatibility.

1430: END IF;
1431:
1432:
1433:
1434: -- Standard call to check for call compatibility.
1435: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1436: p_api_version_number,
1437: l_api_name,
1438: G_PKG_NAME)

Line 1471: -- Standard call to get message count and if count=1, get the message

1467:
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: ROLLBACK TO LOCK_Gq_Elements_PVT;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: -- Standard call to get message count and if count=1, get the message
1472: FND_MSG_PUB.Count_And_Get (
1473: p_encoded => FND_API.G_FALSE,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data

Line 1481: -- Standard call to get message count and if count=1, get the message

1477:
1478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1479: ROLLBACK TO LOCK_Gq_Elements_PVT;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: -- Standard call to get message count and if count=1, get the message
1482: FND_MSG_PUB.Count_And_Get (
1483: p_encoded => FND_API.G_FALSE,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data

Line 1495: -- Standard call to get message count and if count=1, get the message

1491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1492: THEN
1493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1494: END IF;
1495: -- Standard call to get message count and if count=1, get the message
1496: FND_MSG_PUB.Count_And_Get (
1497: p_encoded => FND_API.G_FALSE,
1498: p_count => x_msg_count,
1499: p_data => x_msg_data

Line 1967: -- Standard Start of API savepoint

1963: l_qsnr_element_rec qsnr_element_rec_type;
1964: l_qsnr_element_rec_out qsnr_element_rec_type;
1965:
1966: BEGIN
1967: -- Standard Start of API savepoint
1968: SAVEPOINT validate_gq_elements_;
1969:
1970: -- Standard call to check for call compatibility.
1971: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1970: -- Standard call to check for call compatibility.

1966: BEGIN
1967: -- Standard Start of API savepoint
1968: SAVEPOINT validate_gq_elements_;
1969:
1970: -- Standard call to check for call compatibility.
1971: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1972: p_api_version_number,
1973: l_api_name,
1974: G_PKG_NAME)

Line 2076: -- Standard call to get message count and if count is 1, get message info.

2072: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2073: END IF;
2074:
2075:
2076: -- Standard call to get message count and if count is 1, get message info.
2077: FND_MSG_PUB.Count_And_Get
2078: (p_count => x_msg_count,
2079: p_data => x_msg_data
2080: );

Line 2090: -- Standard call to get message count and if count=1, get the message

2086:
2087: WHEN FND_API.G_EXC_ERROR THEN
2088: ROLLBACK TO VALIDATE_Gq_Elements_;
2089: x_return_status := FND_API.G_RET_STS_ERROR;
2090: -- Standard call to get message count and if count=1, get the message
2091: FND_MSG_PUB.Count_And_Get (
2092: p_encoded => FND_API.G_FALSE,
2093: p_count => x_msg_count,
2094: p_data => x_msg_data

Line 2100: -- Standard call to get message count and if count=1, get the message

2096:
2097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2098: ROLLBACK TO VALIDATE_Gq_Elements_;
2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2100: -- Standard call to get message count and if count=1, get the message
2101: FND_MSG_PUB.Count_And_Get (
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2104: p_data => x_msg_data

Line 2114: -- Standard call to get message count and if count=1, get the message

2110: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2111: THEN
2112: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2113: END IF;
2114: -- Standard call to get message count and if count=1, get the message
2115: FND_MSG_PUB.Count_And_Get (
2116: p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count,
2118: p_data => x_msg_data

Line 2154: -- Standard call to get message count and if count is 1, get message info.

2150: IF (PV_DEBUG_HIGH_ON) THEN
2151:
2152: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2153: END IF;
2154: -- Standard call to get message count and if count is 1, get message info.
2155: FND_MSG_PUB.Count_And_Get
2156: (p_count => x_msg_count,
2157: p_data => x_msg_data
2158: );

Line 2239: -- Standard Start of API savepoint

2235: BEGIN
2236:
2237: ---- Initialize----------------
2238:
2239: -- Standard Start of API savepoint
2240: SAVEPOINT Move_Qsnr_Element;
2241:
2242: -- Debug Message
2243: IF (PV_DEBUG_HIGH_ON) THEN

Line 2248: -- Standard call to check for call compatibility.

2244:
2245: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
2246: END IF;
2247:
2248: -- Standard call to check for call compatibility.
2249: IF NOT FND_API.Compatible_API_Call (l_api_version_number
2250: ,p_api_version_number
2251: ,l_api_name
2252: ,G_PKG_NAME

Line 2533: -- Standard check for p_commit

2529:
2530: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2531: END IF;
2532:
2533: -- Standard check for p_commit
2534: IF FND_API.to_Boolean( p_commit ) THEN
2535: COMMIT WORK;
2536: END IF;
2537:

Line 2548: -- Standard call to get message count and if count=1, get the message

2544: EXCEPTION
2545: WHEN FND_API.G_EXC_ERROR THEN
2546: ROLLBACK TO Move_Qsnr_Element;
2547: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2548: -- Standard call to get message count and if count=1, get the message
2549: Fnd_Msg_Pub.Count_And_Get (
2550: p_encoded => Fnd_Api.G_FALSE
2551: ,p_count => x_msg_count
2552: ,p_data => x_msg_data

Line 2558: -- Standard call to get message count and if count=1, get the message

2554:
2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2556: ROLLBACK TO Move_Qsnr_Element;
2557: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2558: -- Standard call to get message count and if count=1, get the message
2559: Fnd_Msg_Pub.Count_And_Get (
2560: p_encoded => Fnd_Api.G_FALSE
2561: ,p_count => x_msg_count
2562: ,p_data => x_msg_data

Line 2572: -- Standard call to get message count and if count=1, get the message

2568: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2569: THEN
2570: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2571: END IF;
2572: -- Standard call to get message count and if count=1, get the message
2573: Fnd_Msg_Pub.Count_And_Get (
2574: p_encoded => Fnd_Api.G_FALSE
2575: ,p_count => x_msg_count
2576: ,p_data => x_msg_data