DBA Data[Home] [Help]

APPS.WSH_ROUTING_RESPONSE_PKG dependencies on FND_API

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: END IF;
120: --
121: EXCEPTION
122: --
123: WHEN FND_API.G_EXC_ERROR THEN
124: --
125: IF l_debugOn THEN
126: wsh_debug_sv.logmsg(l_moduleName, 'Expected error ' || SUBSTRB(SQLERRM,1,200));
127: END IF;

Line 165: WHEN FND_API.G_EXC_ERROR THEN

161: END IF;
162: --
163: EXCEPTION
164: --
165: WHEN FND_API.G_EXC_ERROR THEN
166: --
167: x_RetStatus := WSH_UTIL_CORE.g_RET_STS_ERROR;
168: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_FAILURE');
169: WSH_UTIL_CORE.ADD_MESSAGE(x_RetStatus, l_moduleName);

Line 176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

172: wsh_debug_sv.logmsg(l_moduleName, 'Expected error ' || SUBSTRB(SQLERRM,1,200));
173: wsh_debug_sv.pop(l_moduleName);
174: END IF;
175: --
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: --
178: x_RetStatus := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;
179: FND_MESSAGE.SET_NAME('WSH', 'WSH_ROUTING_RESP_FAILURE');
180: WSH_UTIL_CORE.ADD_MESSAGE(x_RetStatus, l_moduleName);

Line 520: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);

516: --
517: FOR i IN 1..FND_MSG_PUB.COUNT_MSG LOOP
518: --
519: l_failReason := l_failReason || FND_GLOBAL.local_chr(10) ||
520: FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE);
521: --
522: END LOOP;
523: --
524: IF l_debugOn THEN

Line 642: FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

638: l_failReason := FND_MESSAGE.GET;
639: --
640: FOR i IN 1..FND_MSG_PUB.COUNT_MSG LOOP
641: l_failReason := l_failReason || FND_GLOBAL.local_chr(10) ||
642: FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
643: END LOOP;
644: --}
645: END IF;
646: --}

Line 1164: raise FND_API.G_EXC_ERROR;

1160: THEN
1161: FND_MESSAGE.SET_NAME('WSH', 'WSH_SUPP_CONTACT_INACTIVE');
1162: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_del_name);
1163: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1164: raise FND_API.G_EXC_ERROR;
1165: END IF;
1166: -- } IB-Phase-2
1167:
1168: --

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: RETURN (l_roleName);
1241: --
1242: EXCEPTION
1243: --
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: --
1246: --
1247: IF l_debugOn THEN
1248: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',

Line 1248: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',

1244: WHEN FND_API.G_EXC_ERROR THEN
1245: --
1246: --
1247: IF l_debugOn THEN
1248: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
1249: wsh_debug_sv.C_EXCEP_LEVEL);
1250: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
1251: END IF;
1252: --

Line 1250: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');

1246: --
1247: IF l_debugOn THEN
1248: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
1249: wsh_debug_sv.C_EXCEP_LEVEL);
1250: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
1251: END IF;
1252: --
1253: --
1254:

Line 1414: WHEN FND_API.G_EXC_ERROR THEN

1410: END IF;
1411: --
1412: EXCEPTION
1413: --
1414: WHEN FND_API.G_EXC_ERROR THEN
1415: --
1416: x_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1417: --
1418: IF l_debugOn THEN

Line 1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1419: wsh_debug_sv.logmsg(l_moduleName, 'Expected error ' || SUBSTRB(SQLERRM,1,200));
1420: wsh_debug_sv.pop(l_moduleName);
1421: END IF;
1422: --
1423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1424: --
1425: x_Status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;
1426: --
1427: IF l_debugOn THEN

Line 1545: WHEN FND_API.G_EXC_ERROR THEN

1541: END IF;
1542: --
1543: EXCEPTION
1544: --
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: --
1547: x_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1548: --
1549: IF l_debugOn THEN

Line 1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1550: wsh_debug_sv.logmsg(l_moduleName, 'Expected error ' || SUBSTRB(SQLERRM,1,200));
1551: wsh_debug_sv.pop(l_moduleName);
1552: END IF;
1553: --
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: --
1556: x_Status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;
1557: --
1558: IF l_debugOn THEN

Line 1693: raise fnd_api.g_exc_error;

1689: wsh_debug_sv.log(l_moduleName,'l_return_status',l_return_status);
1690: END IF;
1691: --
1692: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1693: raise fnd_api.g_exc_error;
1694: END IF;
1695: --
1696:
1697: --Determine,if delivery has fist leg.

Line 1715: raise fnd_api.g_exc_error;

1711: --
1712: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_NO_FIRST_LEG');
1713: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1714: CLOSE validate_first_leg_csr;
1715: raise fnd_api.g_exc_error;
1716: --
1717: END IF;
1718: --
1719: CLOSE validate_first_leg_csr;

Line 1728: raise FND_API.G_EXC_ERROR;

1724: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_BUYER_DEL');
1725: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1726: fnd_msg_pub.add;
1727:
1728: raise FND_API.G_EXC_ERROR;
1729: END IF;
1730:
1731:
1732: --Get the Carrier,Mode of transport,Service level and load tendered status of a trip.

Line 1752: RAISE fnd_api.g_exc_error;

1748: --
1749: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_NO_CARRIER_SETUP');
1750: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1751: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1752: RAISE fnd_api.g_exc_error;
1753: --
1754: END IF;
1755: --
1756: IF (l_load_tender_status IS NULL OR l_load_tender_status IN ('OPEN','SHIPPER_CANCELLED') ) THEN

Line 1810: WHEN FND_API.G_EXC_ERROR THEN

1806: END IF;
1807: --
1808: EXCEPTION
1809: --
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: --
1812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1813: --
1814: IF l_debugOn THEN

Line 1815: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',

1811: --
1812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1813: --
1814: IF l_debugOn THEN
1815: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
1816: wsh_debug_sv.C_EXCEP_LEVEL);
1817: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
1818: END IF;
1819: --

Line 1817: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');

1813: --
1814: IF l_debugOn THEN
1815: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
1816: wsh_debug_sv.C_EXCEP_LEVEL);
1817: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
1818: END IF;
1819: --
1820: WHEN OTHERS THEN
1821: --

Line 1910: raise fnd_api.g_exc_error;

1906: --
1907: FND_MESSAGE.SET_NAME('WSH', 'WSH_DEL_NO_DETAILS');
1908: FND_MESSAGE.SET_TOKEN('DEL_NAME', WSH_NEW_DELIVERIES_PVT.Get_Name(p_delivery_id));
1909: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1910: raise fnd_api.g_exc_error;
1911: --
1912: END IF;
1913: --
1914: CLOSE get_del_detail;

Line 1953: raise fnd_api.g_exc_error;

1949: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1950: --
1951: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_PO_INVALID');
1952: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1953: raise fnd_api.g_exc_error;
1954: --
1955: END IF;
1956: --
1957: l_index:=l_po_status_rec.approval_flag.first;

Line 1974: raise fnd_api.g_exc_error;

1970: IF (l_po_status_rec.hold_flag(l_index) = 'Y') THEN
1971: --
1972: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_HOLD');
1973: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1974: raise fnd_api.g_exc_error;
1975: --
1976: END IF;
1977: --
1978: --Error if PO is not Approved.

Line 1983: raise fnd_api.g_exc_error;

1979: IF (l_po_status_rec.approval_flag(l_index)<> 'Y' ) THEN
1980: --
1981: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_UNAPPROVED');
1982: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR, l_moduleName);
1983: raise fnd_api.g_exc_error;
1984: --
1985: END IF;
1986: --
1987: l_index:=l_po_status_rec.approval_flag.next(l_index);

Line 1997: raise fnd_api.g_exc_error;

1993: IF l_debugOn THEN
1994: wsh_debug_sv.logmsg(l_moduleName,'Current Release is Not greater than J');
1995: END IF;
1996: --
1997: raise fnd_api.g_exc_error;
1998: --
1999: END IF;
2000: --
2001: IF l_debugOn THEN

Line 2007: WHEN FND_API.G_EXC_ERROR THEN

2003: END IF;
2004: --
2005: EXCEPTION
2006: --
2007: WHEN FND_API.G_EXC_ERROR THEN
2008: --
2009: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2010: --
2011: IF l_debugOn THEN

Line 2012: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',

2008: --
2009: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2010: --
2011: IF l_debugOn THEN
2012: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
2013: wsh_debug_sv.C_EXCEP_LEVEL);
2014: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
2015: END IF;
2016: --

Line 2014: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');

2010: --
2011: IF l_debugOn THEN
2012: wsh_debug_sv.logmsg(l_moduleName,'FND_API.G_EXC_ERROR exception has occured.',
2013: wsh_debug_sv.C_EXCEP_LEVEL);
2014: wsh_debug_sv.pop(l_moduleName,'EXCEPTION:FND_API.G_EXC_ERROR');
2015: END IF;
2016: --
2017: WHEN OTHERS THEN
2018: --

Line 2300: p_init_msg_list => FND_API.G_TRUE,

2296: -- Call PO Integration group API
2297: --
2298: WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged(
2299: p_api_version_number => 1.0,
2300: p_init_msg_list => FND_API.G_TRUE,
2301: p_commit => FND_API.G_FALSE,
2302: x_return_status => v_Status,
2303: x_msg_Count => v_msgCount,
2304: x_msg_data => v_msgData,

Line 2301: p_commit => FND_API.G_FALSE,

2297: --
2298: WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged(
2299: p_api_version_number => 1.0,
2300: p_init_msg_list => FND_API.G_TRUE,
2301: p_commit => FND_API.G_FALSE,
2302: x_return_status => v_Status,
2303: x_msg_Count => v_msgCount,
2304: x_msg_data => v_msgData,
2305: p_in_rec => v_InRec,