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.FTE_TENDER_PVT dependencies on WSH_UTIL_CORE

Line 48: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
49: x_msg_count := 0;
50: x_msg_data := 0;
51:
52: -- raise event

Line 156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');

152: p_encoded => FND_API.G_FALSE
153: );
154: WHEN OTHERS THEN
155: ROLLBACK TO RAISE_TENDER_REQUEST_PUB;
156: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REQUEST');
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count,

Line 255: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

251: THEN
252: FND_MSG_PUB.initialize;
253: END IF;
254:
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
256: x_msg_count := 0;
257: x_msg_data := 0;
258:
259: ------------------------------------------------------------------

Line 345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');

341: p_encoded => FND_API.G_FALSE
342: );
343: WHEN OTHERS THEN
344: ROLLBACK TO RAISE_TENDER_CANCEL_PUB;
345: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_CANCEL');
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,

Line 393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

389: THEN
390: FND_MSG_PUB.initialize;
391: END IF;
392:
393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
394: x_msg_count := 0;
395: x_msg_data := 0;
396:
397:

Line 495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');

491: p_encoded => FND_API.G_FALSE
492: );
493: WHEN OTHERS THEN
494: ROLLBACK TO RAISE_TENDER_ACCEPT_PUB;
495: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_ACCEPT');
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get
498: (
499: p_count => x_msg_count,

Line 550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

546: FND_MSG_PUB.initialize;
547: END IF;
548:
549:
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551: x_msg_count := 0;
552: x_msg_data := 0;
553:
554:

Line 676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');

672: p_encoded => FND_API.G_FALSE
673: );
674: WHEN OTHERS THEN
675: ROLLBACK TO RAISE_TENDER_UPDATE_PUB;
676: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_UPDATE');
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get
679: (
680: p_count => x_msg_count,

Line 724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

720: FND_MSG_PUB.initialize;
721: END IF;
722:
723:
724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
725: x_msg_count := 0;
726: x_msg_data := 0;
727:
728: ------------------------------------------------------------------

Line 818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');

814: p_encoded => FND_API.G_FALSE
815: );
816: WHEN OTHERS THEN
817: ROLLBACK TO RAISE_TENDER_REJECT_PUB;
818: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_REJECT');
819: x_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,

Line 1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1122: wsh_debug_sv.push(l_module_name);
1123: END IF;
1124: --
1125: -- Initialize API return status to success
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1127: x_msg_count := 0;
1128: x_msg_data := 0;
1129:
1130: IF (p_action_code = 'CREATE') THEN

Line 1183: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1179: END IF;
1180:
1181: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_ID');
1182: --FND_MESSAGE.SET_TOKEN('TENDER_ID',p_trip_id);
1183: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1184:
1185: IF l_debug_on THEN
1186: wsh_debug_sv.pop(l_api_name);
1187: END IF;

Line 1206: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',

1202: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_STATUS');
1203:
1204:
1205: FND_MESSAGE.SET_TOKEN('TENDER_ACTION',
1206: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1207: p_tender_action));
1208: FND_MESSAGE.SET_TOKEN('TRIP_SEG_LT_STATUS',
1209: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1210: l_trip_status));

Line 1209: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',

1205: FND_MESSAGE.SET_TOKEN('TENDER_ACTION',
1206: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1207: p_tender_action));
1208: FND_MESSAGE.SET_TOKEN('TRIP_SEG_LT_STATUS',
1209: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1210: l_trip_status));
1211: FND_MESSAGE.SET_TOKEN('TRIP_SEG_NAME',l_trip_name);
1212: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1213: RAISE FND_API.G_EXC_ERROR;

Line 1212: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1208: FND_MESSAGE.SET_TOKEN('TRIP_SEG_LT_STATUS',
1209: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1210: l_trip_status));
1211: FND_MESSAGE.SET_TOKEN('TRIP_SEG_NAME',l_trip_name);
1212: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1213: RAISE FND_API.G_EXC_ERROR;
1214:
1215: END IF;
1216:

Line 1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');

1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:31 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1273: END IF;
1274: ROLLBACK TO VALIDATE_TENDER_REQUEST_PUB;
1275: wsh_util_core.default_handler('FTE_TENDER_PVT.VALIDATE_TENDER_REQUEST');
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: FND_MSG_PUB.Count_And_Get
1278: (
1279: p_count => x_msg_count,

Line 1348: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1344: END IF;
1345: --
1346: --
1347: -- Initialize API return status to success
1348: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1349: x_msg_count := 0;
1350: x_msg_data := 0;
1351:
1352:

Line 1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');

1393: p_encoded => FND_API.G_FALSE
1394: );
1395: WHEN OTHERS THEN
1396: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');
1398: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1399: FND_MSG_PUB.Count_And_Get
1400: (
1401: p_count => x_msg_count,

Line 1398: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1394: );
1395: WHEN OTHERS THEN
1396: ROLLBACK TO DELETE_TENDER_SNAPSHOT_PUB;
1397: wsh_util_core.default_handler('FTE_TENDER_PVT.DELETE_TENDER_SNAPSHOT');
1398: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1399: FND_MSG_PUB.Count_And_Get
1400: (
1401: p_count => x_msg_count,
1402: p_data => x_msg_data,

Line 1475: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1471: END IF;
1472: --
1473: --
1474: -- Initialize API return status to success
1475: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1476: x_msg_count := 0;
1477: x_msg_data := 0;
1478:
1479: IF(p_action = 'CREATE')

Line 1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

1575: p_encoded => FND_API.G_FALSE
1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get
1582: (
1583: p_count => x_msg_count,

Line 1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1579: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get
1582: (
1583: p_count => x_msg_count,
1584: p_data => x_msg_data,

Line 1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1639: END IF;
1640: --
1641: --
1642: -- Initialize API return status to success
1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1644: x_msg_count := 0;
1645: x_msg_data := 0;
1646: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1647: l_number_of_warnings := 0;

Line 1646: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1642: -- Initialize API return status to success
1643: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1644: x_msg_count := 0;
1645: x_msg_data := 0;
1646: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1647: l_number_of_warnings := 0;
1648: l_number_of_errors := 0;
1649:
1650: l_action := p_action;

Line 1661: wsh_util_core.api_post_call(

1657: x_return_status => l_return_status,
1658: x_msg_count => l_msg_count,
1659: x_msg_data => l_msg_data);
1660:
1661: wsh_util_core.api_post_call(
1662: p_return_status =>l_return_status,
1663: x_num_warnings =>l_number_of_warnings,
1664: x_num_errors =>l_number_of_errors,
1665: p_msg_data =>l_msg_data);

Line 1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1665: p_msg_data =>l_msg_data);
1666:
1667: IF l_number_of_errors > 0
1668: THEN
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: RAISE FND_API.G_EXC_ERROR;
1671: ELSIF l_number_of_warnings > 0
1672: THEN
1673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: RAISE FND_API.G_EXC_ERROR;
1671: ELSIF l_number_of_warnings > 0
1672: THEN
1673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1674: ELSE
1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1676: END IF;
1677:

Line 1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1671: ELSIF l_number_of_warnings > 0
1672: THEN
1673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1674: ELSE
1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1676: END IF;
1677:
1678: l_action := 'CREATE';
1679: END IF;

Line 1701: wsh_util_core.api_post_call(

1697: x_return_status => l_return_status,
1698: x_msg_count => l_msg_count,
1699: x_msg_data => l_msg_data);
1700:
1701: wsh_util_core.api_post_call(
1702: p_return_status =>l_return_status,
1703: x_num_warnings =>l_number_of_warnings,
1704: x_num_errors =>l_number_of_errors,
1705: p_msg_data =>l_msg_data);

Line 1712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1708: END LOOP;
1709:
1710: IF l_number_of_errors > 0
1711: THEN
1712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF l_number_of_warnings > 0 THEN
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1716: ELSE

Line 1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1711: THEN
1712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF l_number_of_warnings > 0 THEN
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1716: ELSE
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1718: END IF;
1719:

Line 1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1713: RAISE FND_API.G_EXC_ERROR;
1714: ELSIF l_number_of_warnings > 0 THEN
1715: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1716: ELSE
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1718: END IF;
1719:
1720:
1721: -- Standard call to get message count and if count is 1,get message info.

Line 1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');

1752: p_encoded => FND_API.G_FALSE
1753: );
1754: WHEN OTHERS THEN
1755: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,

Line 1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1753: );
1754: WHEN OTHERS THEN
1755: ROLLBACK TO TAKE_TENDER_SNAPSHOT_PUB;
1756: wsh_util_core.default_handler('FTE_TENDER_PVT.TAKE_TENDER_SNAPSHOT_PUB');
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1758: FND_MSG_PUB.Count_And_Get
1759: (
1760: p_count => x_msg_count,
1761: p_data => x_msg_data,

Line 1909: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1905: END IF;
1906: --
1907: --
1908: -- Initialize API return status to success
1909: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1910: x_msg_count := 0;
1911: x_msg_data := null;
1912: l_number_of_warnings := 0;
1913: l_number_of_errors := 0;

Line 1931: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1927:
1928: IF (l_trip_id IS NULL)
1929: THEN
1930: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_ID_CHK');
1931: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934:
1935:

Line 1957: l_tender_string := WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',

1953:
1954: IF (l_stop_id IS NULL)
1955: THEN
1956: -- new stop. Throw error. We cannot take it
1957: l_tender_string := WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
1958: l_tender_status);
1959: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_ACT_CNT_ADD_STOP');
1960: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_trip_segment_rec.name);
1961: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',l_tender_string);

Line 1962: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1958: l_tender_status);
1959: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_ACT_CNT_ADD_STOP');
1960: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_trip_segment_rec.name);
1961: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',l_tender_string);
1962: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1963: RAISE FND_API.G_EXC_ERROR;
1964: END IF;
1965:
1966:

Line 2015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2011:
2012: IF (l_tender_number IS NULL)
2013: THEN
2014: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TENDER_NUMBER');
2015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2016: RAISE FND_API.G_EXC_ERROR;
2017: END IF;
2018:
2019:

Line 2043: wsh_util_core.api_post_call(

2039: x_return_status => l_return_status,
2040: x_msg_count => l_msg_count,
2041: x_msg_data => l_msg_data);
2042:
2043: wsh_util_core.api_post_call(
2044: p_return_status =>l_return_status,
2045: x_num_warnings =>l_number_of_warnings,
2046: x_num_errors =>l_number_of_errors,
2047: p_msg_data =>l_msg_data);

Line 2051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2047: p_msg_data =>l_msg_data);
2048:
2049: IF l_number_of_errors > 0
2050: THEN
2051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_number_of_warnings > 0 THEN
2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2055: ELSE

Line 2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2050: THEN
2051: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_number_of_warnings > 0 THEN
2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2055: ELSE
2056: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2057: END IF;
2058:

Line 2056: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_number_of_warnings > 0 THEN
2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2055: ELSE
2056: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2057: END IF;
2058:
2059:
2060: IF l_debug_on THEN

Line 2096: wsh_util_core.api_post_call(

2092: x_msg_data => l_msg_data,
2093: x_trip_id => x_trip_id,
2094: x_trip_name => x_trip_name);
2095:
2096: wsh_util_core.api_post_call(
2097: p_return_status =>l_return_status,
2098: x_num_warnings =>l_number_of_warnings,
2099: x_num_errors =>l_number_of_errors,
2100: p_msg_data =>l_msg_data);

Line 2119: wsh_util_core.api_post_call(

2115: x_return_status => l_return_status,
2116: x_msg_count => l_msg_count,
2117: x_msg_data => l_msg_data);
2118:
2119: wsh_util_core.api_post_call(
2120: p_return_status =>l_return_status,
2121: x_num_warnings =>l_number_of_warnings,
2122: x_num_errors =>l_number_of_errors,
2123: p_msg_data =>l_msg_data);

Line 2131: wsh_util_core.api_post_call(

2127: p_location_id => l_stop_id,
2128: x_location => l_stop_location,
2129: x_return_status => l_return_status);
2130:
2131: wsh_util_core.api_post_call(
2132: p_return_status =>l_return_status,
2133: x_num_warnings =>l_number_of_warnings,
2134: x_num_errors =>l_number_of_errors,
2135: p_msg_data =>l_msg_data);

Line 2140: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

2136:
2137: FND_MESSAGE.SET_NAME('FTE','FTE_NO_DLVYFND_CANCEL_TENDER');
2138: FND_MESSAGE.SET_TOKEN('STOP_LOC',l_stop_location);
2139: FND_MESSAGE.SET_TOKEN('TENDER_ID',l_tender_number);
2140: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2141: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2142: FND_MSG_PUB.Count_And_Get
2143: (
2144: p_count => x_msg_count,

Line 2141: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2137: FND_MESSAGE.SET_NAME('FTE','FTE_NO_DLVYFND_CANCEL_TENDER');
2138: FND_MESSAGE.SET_TOKEN('STOP_LOC',l_stop_location);
2139: FND_MESSAGE.SET_TOKEN('TENDER_ID',l_tender_number);
2140: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2141: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2142: FND_MSG_PUB.Count_And_Get
2143: (
2144: p_count => x_msg_count,
2145: p_data => x_msg_data,

Line 2187: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

2183: x_return_status => x_return_status);
2184:
2185: IF (x_return_status = 'E') THEN
2186: FND_MESSAGE.SET_NAME('FTE','FTE_NO_THRESHOLD_INFO');
2187: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2188: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count,

Line 2188: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2184:
2185: IF (x_return_status = 'E') THEN
2186: FND_MESSAGE.SET_NAME('FTE','FTE_NO_THRESHOLD_INFO');
2187: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
2188: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count,
2192: p_data => x_msg_data,

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

2197: END IF;
2198: RETURN;
2199: ELSIF (x_return_status = 'U') THEN
2200: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_THRESHOLD_INFO');
2201: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: END IF;
2204:
2205: IF (l_site_trans_rec.WEIGHT_THRESHOLD_LOWER = NULL

Line 2458: wsh_util_core.api_post_call(

2454: x_return_status => l_return_status,
2455: x_msg_count => l_msg_count,
2456: x_msg_data => l_msg_data);
2457:
2458: wsh_util_core.api_post_call(
2459: p_return_status =>l_return_status,
2460: x_num_warnings =>l_number_of_warnings,
2461: x_num_errors =>l_number_of_errors,
2462: p_msg_data =>l_msg_data);

Line 2465: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

2461: x_num_errors =>l_number_of_errors,
2462: p_msg_data =>l_msg_data);
2463:
2464:
2465: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2466: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2467: THEN
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.pop(l_module_name);

Line 2466: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

2462: p_msg_data =>l_msg_data);
2463:
2464:
2465: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2466: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2467: THEN
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.pop(l_module_name);
2470: END IF;

Line 2512: wsh_util_core.api_post_call(

2508: x_return_status => l_return_status,
2509: x_msg_count => l_msg_count,
2510: x_msg_data => l_msg_data);
2511:
2512: wsh_util_core.api_post_call(
2513: p_return_status =>l_return_status,
2514: x_num_warnings =>l_number_of_warnings,
2515: x_num_errors =>l_number_of_errors,
2516: p_msg_data =>l_msg_data);

Line 2518: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

2514: x_num_warnings =>l_number_of_warnings,
2515: x_num_errors =>l_number_of_errors,
2516: p_msg_data =>l_msg_data);
2517:
2518: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2519: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2520: THEN
2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);

Line 2519: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

2515: x_num_errors =>l_number_of_errors,
2516: p_msg_data =>l_msg_data);
2517:
2518: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2519: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2520: THEN
2521: IF l_debug_on THEN
2522: WSH_DEBUG_SV.pop(l_module_name);
2523: END IF;

Line 2544: wsh_util_core.api_post_call(

2540: x_msg_data => l_msg_data,
2541: x_trip_id => x_trip_id,
2542: x_trip_name => x_trip_name);
2543:
2544: wsh_util_core.api_post_call(
2545: p_return_status =>l_return_status,
2546: x_num_warnings =>l_number_of_warnings,
2547: x_num_errors =>l_number_of_errors,
2548: p_msg_data =>l_msg_data);

Line 2559: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

2555: CREATE_UPDATE_TRIP ' || x_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
2556:
2557: END IF;
2558:
2559: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2560: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2561: THEN
2562: IF l_debug_on THEN
2563: WSH_DEBUG_SV.pop(l_module_name);

Line 2560: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

2556:
2557: END IF;
2558:
2559: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2560: x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2561: THEN
2562: IF l_debug_on THEN
2563: WSH_DEBUG_SV.pop(l_module_name);
2564: END IF;

Line 2581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2577:
2578:
2579: IF l_number_of_errors > 0
2580: THEN
2581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2582: ELSIF l_number_of_warnings > 0
2583: THEN
2584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2585: ELSE

Line 2584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2580: THEN
2581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2582: ELSIF l_number_of_warnings > 0
2583: THEN
2584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2585: ELSE
2586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2587: END IF;
2588:

Line 2586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2582: ELSIF l_number_of_warnings > 0
2583: THEN
2584: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2585: ELSE
2586: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2587: END IF;
2588:
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

Line 2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');

2636: WSH_DEBUG_SV.pop(l_module_name);
2637: END IF;
2638: WHEN OTHERS THEN
2639: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');
2641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2642: FND_MSG_PUB.Count_And_Get
2643: (
2644: p_count => x_msg_count,

Line 2641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2637: END IF;
2638: WHEN OTHERS THEN
2639: ROLLBACK TO CHECK_THRESHOLD_FOR_STOP_PUB;
2640: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_THRESHOLD_FOR_STOP');
2641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2642: FND_MSG_PUB.Count_And_Get
2643: (
2644: p_count => x_msg_count,
2645: p_data => x_msg_data,

Line 2745: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2741:
2742: SAVEPOINT HANDLE_WF_ROLES_PUB;
2743:
2744:
2745: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2746: x_msg_count := 0;
2747: x_msg_data := 0;
2748:
2749: IF l_debug_on THEN

Line 2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');

2954: WSH_DEBUG_SV.pop(l_module_name);
2955: END IF;
2956: WHEN OTHERS THEN
2957: ROLLBACK TO HANDLE_WF_ROLES_PUB;
2958: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_WF_ROLES');
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960: FND_MSG_PUB.Count_And_Get
2961: (
2962: p_count => x_msg_count,

Line 3044: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3040:
3041: SAVEPOINT RAISE_TENDER_EVENT_PUB;
3042:
3043:
3044: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3045: x_msg_count := 0;
3046: x_msg_data := 0;
3047:
3048: IF FND_API.to_Boolean( p_init_msg_list )

Line 3053: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3049: THEN
3050: FND_MSG_PUB.initialize;
3051: END IF;
3052:
3053: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3054: x_msg_count := 0;
3055: x_msg_data := 0;
3056: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3057: l_number_of_warnings := 0;

Line 3056: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3052:
3053: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3054: x_msg_count := 0;
3055: x_msg_data := 0;
3056: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3057: l_number_of_warnings := 0;
3058: l_number_of_errors := 0;
3059:
3060: -- As per PackJ to show notifications for carrier user, in worklist

Line 3077: wsh_util_core.api_post_call(

3073: x_msg_data => l_msg_data,
3074: x_role_name => l_role_name,
3075: p_contact_name => p_contact_perf);
3076:
3077: wsh_util_core.api_post_call(
3078: p_return_status =>l_return_status,
3079: x_num_warnings =>l_number_of_warnings,
3080: x_num_errors =>l_number_of_errors,
3081: p_msg_data =>l_msg_data);

Line 3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3081: p_msg_data =>l_msg_data);
3082:
3083: IF l_number_of_errors > 0
3084: THEN
3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3086: RAISE FND_API.G_EXC_ERROR;
3087: ELSIF l_number_of_warnings > 0
3088: THEN
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3085: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3086: RAISE FND_API.G_EXC_ERROR;
3087: ELSIF l_number_of_warnings > 0
3088: THEN
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3090: ELSE
3091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3092: END IF;
3093: END IF;

Line 3091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3087: ELSIF l_number_of_warnings > 0
3088: THEN
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3090: ELSE
3091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3092: END IF;
3093: END IF;
3094:
3095: IF (p_action = FTE_TENDER_PVT.S_TENDERED) THEN

Line 3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');

3196: p_encoded => FND_API.G_FALSE
3197: );
3198: WHEN OTHERS THEN
3199: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3200: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,

Line 3295: wsh_util_core.api_post_call(

3291: p_data => x_msg_data,
3292: p_encoded => FND_API.G_FALSE
3293: );
3294:
3295: wsh_util_core.api_post_call(
3296: p_return_status =>l_preturn_status,
3297: x_num_warnings =>l_number_of_pwarnings,
3298: x_num_errors =>l_number_of_perrors,
3299: p_msg_data =>x_msg_data);

Line 3302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3298: x_num_errors =>l_number_of_perrors,
3299: p_msg_data =>x_msg_data);
3300:
3301: IF l_number_of_perrors > 0 THEN
3302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF l_number_of_pwarnings > 0 THEN
3305: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3306: ELSE

Line 3305: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3301: IF l_number_of_perrors > 0 THEN
3302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF l_number_of_pwarnings > 0 THEN
3305: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3306: ELSE
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3308: END IF;
3309: end if ;

Line 3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF l_number_of_pwarnings > 0 THEN
3305: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3306: ELSE
3307: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3308: END IF;
3309: end if ;
3310: end if ;
3311:

Line 3344: wsh_util_core.api_post_call(

3340: p_data => x_msg_data,
3341: p_encoded => FND_API.G_FALSE
3342: );
3343:
3344: wsh_util_core.api_post_call(
3345: p_return_status =>l_dreturn_status,
3346: x_num_warnings =>l_number_of_dwarnings,
3347: x_num_errors =>l_number_of_derrors,
3348: p_msg_data =>x_msg_data);

Line 3351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3347: x_num_errors =>l_number_of_derrors,
3348: p_msg_data =>x_msg_data);
3349:
3350: IF l_number_of_derrors > 0 THEN
3351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3352: RAISE FND_API.G_EXC_ERROR;
3353: ELSIF l_number_of_dwarnings > 0 THEN
3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3355: ELSE

Line 3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3350: IF l_number_of_derrors > 0 THEN
3351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3352: RAISE FND_API.G_EXC_ERROR;
3353: ELSIF l_number_of_dwarnings > 0 THEN
3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3355: ELSE
3356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3357: END IF;
3358: END IF ;

Line 3356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3352: RAISE FND_API.G_EXC_ERROR;
3353: ELSIF l_number_of_dwarnings > 0 THEN
3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3355: ELSE
3356: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3357: END IF;
3358: END IF ;
3359: END IF ;
3360:

Line 3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');

3385: p_encoded => FND_API.G_FALSE
3386: );
3387: WHEN OTHERS THEN
3388: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');
3390: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3391: FND_MSG_PUB.Count_And_Get
3392: (
3393: p_count => x_msg_count,

Line 3390: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3386: );
3387: WHEN OTHERS THEN
3388: ROLLBACK TO LOG_CARRIER_ARR_EXC_pub;
3389: wsh_util_core.default_handler('FTE_TENDER_PVT.LOG_CARRIER_ARR_EXC');
3390: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3391: FND_MSG_PUB.Count_And_Get
3392: (
3393: p_count => x_msg_count,
3394: p_data => x_msg_data,

Line 3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');

3501: p_encoded => FND_API.G_FALSE
3502: );
3503: WHEN OTHERS THEN
3504: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');
3506: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3507: FND_MSG_PUB.Count_And_Get
3508: (
3509: p_count => x_msg_count,

Line 3506: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3502: );
3503: WHEN OTHERS THEN
3504: ROLLBACK TO CHECK_CARRIER_ARRIVAL_TIME_PUB;
3505: wsh_util_core.default_handler('FTE_TENDER_PVT.CHECK_CARRIER_ARRIVAL_TIME');
3506: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3507: FND_MSG_PUB.Count_And_Get
3508: (
3509: p_count => x_msg_count,
3510: p_data => x_msg_data,

Line 3527: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3523:
3524: l_exception_msg_count NUMBER;
3525: l_exception_msg_data varchar2(2000);
3526: l_dummy_exception_id NUMBER;
3527: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3528: l_msg VARCHAR2(2000);
3529: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
3530:
3531: l_msg varchar2(2000);

Line 3621: wsh_util_core.api_post_call(

3617: p_count => x_msg_count,
3618: p_data => x_msg_data,
3619: p_encoded => FND_API.G_FALSE
3620: );
3621: wsh_util_core.api_post_call(
3622: p_return_status =>l_return_status,
3623: x_num_warnings =>l_number_of_warnings,
3624: x_num_errors =>l_number_of_errors,
3625: p_msg_data =>x_msg_data);

Line 3629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3625: p_msg_data =>x_msg_data);
3626:
3627: IF l_number_of_errors > 0
3628: THEN
3629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3630: RAISE FND_API.G_EXC_ERROR;
3631: ELSIF l_number_of_warnings > 0
3632: THEN
3633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3630: RAISE FND_API.G_EXC_ERROR;
3631: ELSIF l_number_of_warnings > 0
3632: THEN
3633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3634: ELSE
3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3636: END IF;
3637:

Line 3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3631: ELSIF l_number_of_warnings > 0
3632: THEN
3633: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3634: ELSE
3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3636: END IF;
3637:
3638:
3639: IF l_debug_on THEN

Line 3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');

3664: );
3665:
3666: WHEN OTHERS THEN
3667: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');
3669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3670: FND_MSG_PUB.Count_And_Get
3671: (
3672: p_count => x_msg_count,

Line 3669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3665:
3666: WHEN OTHERS THEN
3667: ROLLBACK TO COMPLETE_CANCEL_TENDER_PUB;
3668: wsh_util_core.default_handler('FTE_TENDER_PVT.COMPLETE_CANCEL_TENDER');
3669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3670: FND_MSG_PUB.Count_And_Get
3671: (
3672: p_count => x_msg_count,
3673: p_data => x_msg_data,

Line 3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3725: THEN
3726: FND_MSG_PUB.initialize;
3727: END IF;
3728:
3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3730: x_msg_count := 0;
3731: x_msg_data := 0;
3732: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3733: l_number_of_warnings := 0;

Line 3732: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3728:
3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3730: x_msg_count := 0;
3731: x_msg_data := 0;
3732: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3733: l_number_of_warnings := 0;
3734: l_number_of_errors := 0;
3735:
3736:

Line 3745: wsh_util_core.api_post_call(

3741: x_msg_data => l_msg_data,
3742: x_role_name => l_role_name,
3743: p_contact_name => 'HZ_PARTY:' || p_trip_info.car_contact_id);
3744:
3745: wsh_util_core.api_post_call(
3746: p_return_status =>l_return_status,
3747: x_num_warnings =>l_number_of_warnings,
3748: x_num_errors =>l_number_of_errors,
3749: p_msg_data =>l_msg_data);

Line 3761: wsh_util_core.api_post_call(

3757: x_return_status => l_return_status,
3758: x_msg_count => l_msg_count,
3759: x_msg_data => l_msg_data);
3760:
3761: wsh_util_core.api_post_call(
3762: p_return_status =>l_return_status,
3763: x_num_warnings =>l_number_of_warnings,
3764: x_num_errors =>l_number_of_errors,
3765: p_msg_data =>l_msg_data);

Line 3769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3765: p_msg_data =>l_msg_data);
3766:
3767: IF l_number_of_errors > 0
3768: THEN
3769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSIF l_number_of_warnings > 0
3772: THEN
3773: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3773: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3770: RAISE FND_API.G_EXC_ERROR;
3771: ELSIF l_number_of_warnings > 0
3772: THEN
3773: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3774: ELSE
3775: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3776: END IF;
3777:

Line 3775: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3771: ELSIF l_number_of_warnings > 0
3772: THEN
3773: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3774: ELSE
3775: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3776: END IF;
3777:
3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.logmsg(l_module_name,' TRIP Id ' || p_trip_info.trip_id,

Line 3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');

3895:
3896:
3897: WHEN OTHERS THEN
3898: ROLLBACK TO RAISE_TENDER_EVENT_PUB;
3899: wsh_util_core.default_handler('FTE_TENDER_PVT.RAISE_TENDER_EVENT');
3900: x_return_status := FND_API.G_RET_STS_ERROR;
3901: FND_MSG_PUB.Count_And_Get
3902: (
3903: p_count => x_msg_count,

Line 3997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3993: END IF;
3994:
3995: --
3996: -- Initialize API return status to success
3997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3998: x_msg_count := 0;
3999: x_msg_data := 0;
4000: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4001: l_number_of_warnings := 0;

Line 4000: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3996: -- Initialize API return status to success
3997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3998: x_msg_count := 0;
3999: x_msg_data := 0;
4000: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4001: l_number_of_warnings := 0;
4002: l_number_of_errors := 0;
4003:
4004: IF p_carrier_response_rec.tender_status = S_ACCEPTED

Line 4091: wsh_util_core.api_post_call(

4087: l_return_status,
4088: WSH_DEBUG_SV.C_PROC_LEVEL);
4089: END IF;
4090:
4091: wsh_util_core.api_post_call(
4092: p_return_status =>l_return_status,
4093: x_num_warnings =>l_number_of_warnings,
4094: x_num_errors =>l_number_of_errors,
4095: p_msg_data =>l_msg_data);

Line 4140: wsh_util_core.api_post_call(

4136: l_return_status,
4137: WSH_DEBUG_SV.C_PROC_LEVEL);
4138: END IF;
4139:
4140: wsh_util_core.api_post_call(
4141: p_return_status =>l_return_status,
4142: x_num_warnings =>l_number_of_warnings,
4143: x_num_errors =>l_number_of_errors,
4144: p_msg_data =>l_msg_data);

Line 4151: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4147: END IF;
4148:
4149: IF l_number_of_errors > 0
4150: THEN
4151: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4152: RAISE FND_API.G_EXC_ERROR;
4153: ELSIF l_number_of_warnings > 0
4154: THEN
4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4151: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4152: RAISE FND_API.G_EXC_ERROR;
4153: ELSIF l_number_of_warnings > 0
4154: THEN
4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4156: ELSE
4157: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4158: END IF;
4159:

Line 4157: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4153: ELSIF l_number_of_warnings > 0
4154: THEN
4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4156: ELSE
4157: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4158: END IF;
4159:
4160:
4161: -- Standard call to get message count and if count is 1,get message info.

Line 4172: wsh_util_core.api_post_call(

4168: );
4169: --
4170: --
4171:
4172: wsh_util_core.api_post_call(
4173: p_return_status =>l_return_status,
4174: x_num_warnings =>l_number_of_warnings,
4175: x_num_errors =>l_number_of_errors,
4176: p_msg_data =>l_msg_data);

Line 4180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4176: p_msg_data =>l_msg_data);
4177:
4178: IF l_number_of_errors > 0
4179: THEN
4180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4181: RAISE FND_API.G_EXC_ERROR;
4182: ELSIF l_number_of_warnings > 0
4183: THEN
4184: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4184: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4181: RAISE FND_API.G_EXC_ERROR;
4182: ELSIF l_number_of_warnings > 0
4183: THEN
4184: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4185: ELSE
4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4187: END IF;
4188:

Line 4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4182: ELSIF l_number_of_warnings > 0
4183: THEN
4184: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4185: ELSE
4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4187: END IF;
4188:
4189:
4190:

Line 4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');

4214: );
4215:
4216: WHEN OTHERS THEN
4217: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get
4221: (
4222: p_count => x_msg_count,

Line 4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4215:
4216: WHEN OTHERS THEN
4217: ROLLBACK TO UPDATE_CARRIER_RESPONSE_PUB;
4218: wsh_util_core.default_handler('FTE_TENDER_PVT.UPDATE_CARRIER_RESPONSE');
4219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get
4221: (
4222: p_count => x_msg_count,
4223: p_data => x_msg_data,

Line 4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4275: THEN
4276: FND_MSG_PUB.initialize;
4277: END IF;
4278:
4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4280: x_msg_count := 0;
4281: x_msg_data := 0;
4282: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4283: l_number_of_warnings := 0;

Line 4282: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4278:
4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4280: x_msg_count := 0;
4281: x_msg_data := 0;
4282: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4283: l_number_of_warnings := 0;
4284: l_number_of_errors := 0;
4285:
4286:

Line 4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');

4400:
4401:
4402: WHEN OTHERS THEN
4403: ROLLBACK TO RELEASE_TENDER_BLOCK_PUB;
4404: wsh_util_core.default_handler('FTE_TENDER_PVT.RELEASE_TENDER_BLOCK');
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406: FND_MSG_PUB.Count_And_Get
4407: (
4408: p_count => x_msg_count,

Line 4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4465: THEN
4466: FND_MSG_PUB.initialize;
4467: END IF;
4468:
4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4470: x_msg_count := 0;
4471: x_msg_data := 0;
4472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4473: l_number_of_warnings := 0;

Line 4472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4468:
4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4470: x_msg_count := 0;
4471: x_msg_data := 0;
4472: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4473: l_number_of_warnings := 0;
4474: l_number_of_errors := 0;
4475:
4476:

Line 4492: wsh_util_core.api_post_call(

4488: l_return_status,
4489: WSH_DEBUG_SV.C_PROC_LEVEL);
4490: END IF;
4491:
4492: wsh_util_core.api_post_call(
4493: p_return_status =>l_return_status,
4494: x_num_warnings =>l_number_of_warnings,
4495: x_num_errors =>l_number_of_errors,
4496: p_msg_data =>l_msg_data);

Line 4500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4496: p_msg_data =>l_msg_data);
4497:
4498: IF l_number_of_errors > 0
4499: THEN
4500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4501: RAISE FND_API.G_EXC_ERROR;
4502: ELSIF l_number_of_warnings > 0
4503: THEN
4504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4501: RAISE FND_API.G_EXC_ERROR;
4502: ELSIF l_number_of_warnings > 0
4503: THEN
4504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4505: ELSE
4506: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4507: END IF;
4508:

Line 4506: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4502: ELSIF l_number_of_warnings > 0
4503: THEN
4504: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4505: ELSE
4506: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4507: END IF;
4508:
4509:
4510: -- If source is S_SOURCE_CP or S_SOURCE_XML we have to release the block

Line 4524: wsh_util_core.api_post_call(

4520: x_msg_count => l_msg_count,
4521: x_msg_data => l_msg_data);
4522: END IF;
4523:
4524: wsh_util_core.api_post_call(
4525: p_return_status =>l_return_status,
4526: x_num_warnings =>l_number_of_warnings,
4527: x_num_errors =>l_number_of_errors,
4528: p_msg_data =>l_msg_data);

Line 4532: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4528: p_msg_data =>l_msg_data);
4529:
4530: IF l_number_of_errors > 0
4531: THEN
4532: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4533: RAISE FND_API.G_EXC_ERROR;
4534: ELSIF l_number_of_warnings > 0
4535: THEN
4536: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4536: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4532: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4533: RAISE FND_API.G_EXC_ERROR;
4534: ELSIF l_number_of_warnings > 0
4535: THEN
4536: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4537: ELSE
4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4539: END IF;
4540:

Line 4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4534: ELSIF l_number_of_warnings > 0
4535: THEN
4536: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4537: ELSE
4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4539: END IF;
4540:
4541:
4542: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

Line 4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');

4660:
4661:
4662: WHEN OTHERS THEN
4663: ROLLBACK TO HANDLE_TENDER_RESPONSE_PUB;
4664: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_TENDER_RESPONSE');
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: FND_MSG_PUB.Count_And_Get
4667: (
4668: p_count => x_msg_count,

Line 4735: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4731: THEN
4732: FND_MSG_PUB.initialize;
4733: END IF;
4734:
4735: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4736: x_msg_count := 0;
4737: x_msg_data := 0;
4738: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4739: l_number_of_warnings := 0;

Line 4738: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4734:
4735: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4736: x_msg_count := 0;
4737: x_msg_data := 0;
4738: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4739: l_number_of_warnings := 0;
4740: l_number_of_errors := 0;
4741:
4742: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_wsh_trip_info);

Line 4781: wsh_util_core.api_post_call(

4777: l_return_status,
4778: WSH_DEBUG_SV.C_PROC_LEVEL);
4779: END IF;
4780:
4781: wsh_util_core.api_post_call(
4782: p_return_status =>l_return_status,
4783: x_num_warnings =>l_number_of_warnings,
4784: x_num_errors =>l_number_of_errors,
4785: p_msg_data =>l_msg_data);

Line 4797: wsh_util_core.api_post_call(

4793: x_msg_data => l_msg_data_complete
4794: );
4795:
4796:
4797: wsh_util_core.api_post_call(
4798: p_return_status =>l_return_status,
4799: x_num_warnings =>l_number_of_warnings,
4800: x_num_errors =>l_number_of_errors,
4801: p_msg_data =>l_msg_data);

Line 4811: wsh_util_core.api_post_call(

4807: x_return_status => l_return_status,
4808: x_msg_count => l_msg_count,
4809: x_msg_data => l_msg_data);
4810:
4811: wsh_util_core.api_post_call(
4812: p_return_status =>l_return_status,
4813: x_num_warnings =>l_number_of_warnings,
4814: x_num_errors =>l_number_of_errors,
4815: p_msg_data =>l_msg_data);

Line 4819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4815: p_msg_data =>l_msg_data);
4816:
4817: IF l_number_of_errors > 0
4818: THEN
4819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4820: RAISE FND_API.G_EXC_ERROR;
4821: ELSIF l_number_of_warnings > 0
4822: THEN
4823: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4823: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4819: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4820: RAISE FND_API.G_EXC_ERROR;
4821: ELSIF l_number_of_warnings > 0
4822: THEN
4823: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4824: ELSE
4825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4826: END IF;
4827:

Line 4825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4821: ELSIF l_number_of_warnings > 0
4822: THEN
4823: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4824: ELSE
4825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4826: END IF;
4827:
4828:
4829: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

Line 4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');

4942:
4943:
4944: WHEN OTHERS THEN
4945: ROLLBACK TO HANDLE_CANCEL_TENDER_PUB;
4946: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_CANCEL_TENDER');
4947: x_return_status := FND_API.G_RET_STS_ERROR;
4948: FND_MSG_PUB.Count_And_Get
4949: (
4950: p_count => x_msg_count,

Line 4998: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4994: FND_MSG_PUB.initialize;
4995: END IF;
4996:
4997:
4998: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4999: x_msg_count := 0;
5000: x_msg_data := 0;
5001:
5002:

Line 5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');

5147: p_encoded => FND_API.G_FALSE
5148: );
5149: WHEN OTHERS THEN
5150: ROLLBACK TO HANDLE_UPDATE_TENDER_PUB;
5151: wsh_util_core.default_handler('FTE_TENDER_PVT.HANDLE_UPDATE_TENDER');
5152: x_return_status := FND_API.G_RET_STS_ERROR;
5153: FND_MSG_PUB.Count_And_Get
5154: (
5155: p_count => x_msg_count,