DBA Data[Home] [Help]

APPS.FTE_DELIVERY_LEGS_PVT dependencies on WSH_UTIL_CORE

Line 92: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

88: END IF;
89: --
90: --
91: -- Initialize API return status to success
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
93: l_number_of_errors := 0;
94: l_number_of_warnings := 0;
95: --
96:

Line 163: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.search_segment_save');

159: ROLLBACK TO SEARCH_SEGMENT_SAVE_PUB;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: --
162: --
163: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.search_segment_save');
164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
165: --
166: --
167: FND_MSG_PUB.Count_And_Get

Line 164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: --
162: --
163: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.search_segment_save');
164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
165: --
166: --
167: FND_MSG_PUB.Count_And_Get
168: (

Line 363: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

359: END IF;
360: --
361: --
362: -- Initialize API return status to success
363: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
364: l_number_of_errors := 0;
365: l_number_of_warnings := 0;
366: --
367: IF p_ui_page_name = GK_DLEG_WB_PAGE

Line 643: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

639: x_return_status => x_return_status
640: );
641: --
642: --
643: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
644: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
645: THEN
646: --{
647: RAISE FND_API.G_EXC_ERROR;

Line 644: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

640: );
641: --
642: --
643: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
644: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
645: THEN
646: --{
647: RAISE FND_API.G_EXC_ERROR;
648: --RETURN;

Line 721: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

717: x_return_status => x_return_status
718: );
719: --
720: --
721: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
722: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
723: THEN
724: --{
725: RAISE FND_API.G_EXC_ERROR;

Line 722: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

718: );
719: --
720: --
721: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
722: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
723: THEN
724: --{
725: RAISE FND_API.G_EXC_ERROR;
726: --RETURN;

Line 804: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

800: x_return_status => x_return_status
801: );
802: --
803: --
804: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
805: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
806: THEN
807: --{
808: RAISE FND_API.G_EXC_ERROR;

Line 805: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

801: );
802: --
803: --
804: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
805: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
806: THEN
807: --{
808: RAISE FND_API.G_EXC_ERROR;
809: --RETURN;

Line 863: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

859: x_return_status => x_return_status
860: );
861: --
862: --
863: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
864: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
865: THEN
866: --{
867: RAISE FND_API.G_EXC_ERROR;

Line 864: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

860: );
861: --
862: --
863: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
864: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
865: THEN
866: --{
867: RAISE FND_API.G_EXC_ERROR;
868: --RETURN;

Line 960: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

956: x_return_status => x_return_status
957: );
958: --
959: --
960: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
961: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
962: THEN
963: --{
964: RAISE FND_API.G_EXC_ERROR;

Line 961: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

957: );
958: --
959: --
960: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
961: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
962: THEN
963: --{
964: RAISE FND_API.G_EXC_ERROR;
965: --RETURN;

Line 1053: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1049: x_return_status => x_return_status
1050: );
1051: --
1052: --
1053: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1054: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1055: THEN
1056: --{
1057: RAISE FND_API.G_EXC_ERROR;

Line 1054: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1050: );
1051: --
1052: --
1053: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1054: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1055: THEN
1056: --{
1057: RAISE FND_API.G_EXC_ERROR;
1058: --RETURN;

Line 1114: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1110: x_return_status => x_return_status
1111: );
1112: --
1113: --
1114: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1115: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1116: THEN
1117: --{
1118: RAISE FND_API.G_EXC_ERROR;

Line 1115: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1111: );
1112: --
1113: --
1114: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1115: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1116: THEN
1117: --{
1118: RAISE FND_API.G_EXC_ERROR;
1119: --RETURN;

Line 1159: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1155: x_return_status => x_return_status
1156: );
1157: --
1158: --
1159: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1160: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1161: THEN
1162: --{
1163: RAISE FND_API.G_EXC_ERROR;

Line 1160: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1156: );
1157: --
1158: --
1159: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1160: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1161: THEN
1162: --{
1163: RAISE FND_API.G_EXC_ERROR;
1164: --RETURN;

Line 1196: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1192: x_return_status => x_return_status
1193: );
1194: --
1195: --
1196: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1197: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1198: THEN
1199: --{
1200: RAISE FND_API.G_EXC_ERROR;

Line 1197: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1193: );
1194: --
1195: --
1196: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1197: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1198: THEN
1199: --{
1200: RAISE FND_API.G_EXC_ERROR;
1201: --RETURN;

Line 1227: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1223: --
1224: IF SQL%NOTFOUND
1225: THEN
1226: --{
1227: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1228: --
1229: --
1230: FTE_MLS_UTIL.api_post_call
1231: (

Line 1243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1239: x_return_status => x_return_status
1240: );
1241: --
1242: --
1243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1244: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1245: THEN
1246: --{
1247: RAISE FND_API.G_EXC_ERROR;

Line 1244: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1240: );
1241: --
1242: --
1243: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1244: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1245: THEN
1246: --{
1247: RAISE FND_API.G_EXC_ERROR;
1248: --RETURN;

Line 1277: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1273: --
1274: IF SQL%NOTFOUND
1275: THEN
1276: --{
1277: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: --
1279: --
1280: FTE_MLS_UTIL.api_post_call
1281: (

Line 1293: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1289: x_return_status => x_return_status
1290: );
1291: --
1292: --
1293: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1294: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1295: THEN
1296: --{
1297: RAISE FND_API.G_EXC_ERROR;

Line 1294: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1290: );
1291: --
1292: --
1293: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1294: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1295: THEN
1296: --{
1297: RAISE FND_API.G_EXC_ERROR;
1298: --RETURN;

Line 1343: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1339: x_return_status => x_return_status
1340: );
1341: --
1342: --
1343: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1344: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1345: THEN
1346: --{
1347: RAISE FND_API.G_EXC_ERROR;

Line 1344: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1340: );
1341: --
1342: --
1343: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1344: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1345: THEN
1346: --{
1347: RAISE FND_API.G_EXC_ERROR;
1348: --RETURN;

Line 1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1372:
1373: IF l_number_of_errors > 0
1374: THEN
1375: ROLLBACK TO PROCESS_DELIVERY_LEG_PUB;
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1374: THEN
1375: ROLLBACK TO PROCESS_DELIVERY_LEG_PUB;
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1381: END IF;
1382: --

Line 1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: ELSIF l_number_of_warnings > 0 THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1379: ELSE
1380: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1381: END IF;
1382: --
1383: --
1384: -- Standard call to get message count and if count is 1,get message info.

Line 1430: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.PROCESS_DELIVERY_LEG');

1426: l_api_name
1427: );
1428: END IF;
1429: */
1430: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.PROCESS_DELIVERY_LEG');
1431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1432: --
1433: --
1434: FND_MSG_PUB.Count_And_Get

Line 1431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1427: );
1428: END IF;
1429: */
1430: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.PROCESS_DELIVERY_LEG');
1431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1432: --
1433: --
1434: FND_MSG_PUB.Count_And_Get
1435: (

Line 1566: p_api_return_status => WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,

1562: --{
1563: FTE_MLS_UTIL.api_post_call
1564: (
1565: p_api_name => 'FIRST_LAST_ID_DATES_NULL',
1566: p_api_return_status => WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1567: p_message_name => 'FTE_SEGMENT_UNEXP_ERROR',
1568: p_trip_segment_id => p_wsh_trip_id,
1569: p_trip_segment_name => p_wsh_trip_name,
1570: x_number_of_errors => l_number_of_errors,

Line 1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1580: END IF;
1581: --
1582: --
1583: -- Initialize API return status to success
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1585: l_number_of_errors := 0;
1586: l_number_of_warnings := 0;
1587: l_first_stop_id := NULL;
1588: l_last_stop_id := NULL;

Line 1697: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1693: x_return_status => x_return_status
1694: );
1695: --
1696: --
1697: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1698: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1699: THEN
1700: --{
1701: RAISE FND_API.G_EXC_ERROR;

Line 1698: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1694: );
1695: --
1696: --
1697: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1698: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1699: THEN
1700: --{
1701: RAISE FND_API.G_EXC_ERROR;
1702: --RETURN;

Line 1753: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1749: x_return_status => x_return_status
1750: );
1751: --
1752: --
1753: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1754: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1755: THEN
1756: --{
1757: RAISE FND_API.G_EXC_ERROR;

Line 1754: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1750: );
1751: --
1752: --
1753: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1754: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1755: THEN
1756: --{
1757: RAISE FND_API.G_EXC_ERROR;
1758: --RETURN;

Line 1828: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1824: x_return_status => x_return_status
1825: );
1826: --
1827: --
1828: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1829: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1830: THEN
1831: --{
1832: RAISE FND_API.G_EXC_ERROR;

Line 1829: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1825: );
1826: --
1827: --
1828: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1829: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1830: THEN
1831: --{
1832: RAISE FND_API.G_EXC_ERROR;
1833: --RETURN;

Line 1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1838: --
1839: IF l_number_of_errors > 0
1840: THEN
1841: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE

Line 1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1841: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1848: END IF;
1849: --

Line 1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1843: ELSIF l_number_of_warnings > 0
1844: THEN
1845: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1846: ELSE
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1848: END IF;
1849: --
1850: --
1851: -- Standard call to get message count and if count is 1,get message info.

Line 1887: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.assign_service_to_segment');

1883: ROLLBACK TO ASSIGN_SERVICE_TO_SEGMENT_PUB;
1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: --
1886: --
1887: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.assign_service_to_segment');
1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1889: --
1890: --
1891: FND_MSG_PUB.Count_And_Get

Line 1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1885: --
1886: --
1887: wsh_util_core.default_handler('FTE_DELIVERY_LEGS_PVT.assign_service_to_segment');
1888: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1889: --
1890: --
1891: FND_MSG_PUB.Count_And_Get
1892: (

Line 2123: X_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2119:
2120: --}
2121: BEGIN
2122: --{
2123: X_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2124: --
2125: -- INITIALIZATION
2126:
2127: IF l_debug_on THEN

Line 2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');

2571: --}
2572: EXCEPTION
2573: --{
2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get

Line 2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

2573: --{
2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get
2580: (
2581: p_count => x_msg_count,

Line 2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2574: WHEN OTHERS THEN
2575: wsh_util_core.default_handler('FTE_DELIVERY_LEGS.build_delivery_leg_info');
2576: FND_MESSAGE.SET_NAME('FTE','FTE_BLD_DLEG_UNEXP_ERROR');
2577: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2578: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2579: FND_MSG_PUB.Count_And_Get
2580: (
2581: p_count => x_msg_count,
2582: p_data => x_msg_data,