[Home] [Help]
234:
235: WHEN OTHERS THEN
236: l_untrxd_rec_count := null;
237: x_msg_count := 1;
238: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
240:
241: END;
242: BEGIN
273: l_rec_exp_count := 0;
274: WHEN OTHERS THEN
275: l_rec_exp_count := null;
276: x_msg_count := 1;
277: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
279: END;
280:
281: BEGIN
316: l_rec_direct_count := 0;
317: WHEN OTHERS THEN
318: l_rec_direct_count := null;
319: x_msg_count := 1;
320: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
321: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
322: END;
323:
324: p_out_attributes.untrxd_rec_count := l_untrxd_rec_count;
397:
398: WHEN OTHERS THEN
399: l_nonintf_line_qty := null;
400: x_msg_count := 1;
401: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
402: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
403:
404: END;
405:
531: EXCEPTION
532:
533: WHEN OTHERS THEN
534:
535: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
537:
538: -- Get message count and data
539:
667: trace('p_enabled_flag passed in = ' || p_enabled_flag);
668:
669: IF (p_enabled_flag = 'Y') AND (p_printer_name IS NULL) THEN
670: trace('Printer name is required for enabling');
671: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NAME_REQUIRED');
672: FND_MSG_PUB.ADD;
673: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
674: , p_data => x_msg_data );
675: x_return_status := fnd_api.g_ret_sts_error;
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: trace('Printer is not signed on');
712: wsh_debug_sv.pop(l_module_name);
713: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINTER_NOT_SIGNON');
714: FND_MSG_PUB.ADD;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: , p_data => x_msg_data );
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: EXCEPTION
1006:
1007: WHEN OTHERS THEN
1008:
1009: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1011:
1012: -- Get message count and data
1013:
1033: EXCEPTION
1034:
1035: WHEN OTHERS THEN
1036:
1037: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1039:
1040: -- Get message count and data
1041:
1083: RETURN 'N';
1084:
1085: /*EXCEPTION
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1088: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
1089: IF l_debug_on THEN
1090: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1091: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1140: END IF;
1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: wsh_util_core.add_message(x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1230: -- all others have to be treated as success and code flow
1231: -- will continue and not rollback
1232: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1233: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1234: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1235: WSH_UTIL_CORE.Add_Message(x_return_status);
1236: ELSE -- all other Statuses are equivalent to Success
1237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1238: END IF;
1245: END IF;
1246:
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1251: wsh_util_core.add_message(x_return_status,l_module_name);
1252:
1253: IF l_debug_on THEN
1344: -- all others have to be treated as success and code flow
1345: -- will continue and not rollback
1346: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1347: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1348: FND_MESSAGE.SET_NAME('WSH','WSH_INCOMPLETE_TRANSACTION');
1349: WSH_UTIL_CORE.Add_Message(x_return_status);
1350: ELSE -- all other Statuses are equivalent to Success
1351: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1352: END IF;
1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366:
1367: IF l_debug_on THEN
1701: IF l_debug_on THEN
1702: WSH_DEBUG_SV.log(l_module_name, 'No Data Found. Req. Qty. allowed to be cancelled'||to_char(x_cancel_qty_allowed) );
1703: WSH_DEBUG_SV.pop(l_module_name);
1704: END IF;
1705: FND_MESSAGE.SET_NAME('WSH', 'WSH_LINE_CANCEL_NOT_ALLOWED');
1706: FND_MSG_PUB.ADD;
1707: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1708: , p_data => x_msg_data );
1709: x_return_status := fnd_api.g_ret_sts_error;
1744:
1745: EXCEPTION
1746:
1747: WHEN OTHERS THEN
1748: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1750:
1751: FND_MSG_PUB.Count_And_Get
1752: ( p_count => x_msg_count
2059: END IF;
2060: RETURN l_return_status;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2064: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,l_module_name);
2065: IF l_debug_on THEN
2066: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2067: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);