267: WHERE rule_id IS NULL;
268:
269:
270: l_failed_entity_tab FTE_CS_TEMP_ENTITY_TAB;
271: l_fnd_message_name VARCHAR2(60);
272: l_exception_name VARCHAR2(60);
273: l_exception_message VARCHAR2(5000);
274:
275: l_exception_id NUMBER;
306:
307: IF (p_entity = 'DLVY') THEN
308:
309: IF p_caller = 'WSH_DLMG' THEN
310: l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';
311: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
312: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
313: l_fnd_message_name := 'WSH_CARRIER_CREATE_DEL';
314: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
309: IF p_caller = 'WSH_DLMG' THEN
310: l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';
311: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
312: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
313: l_fnd_message_name := 'WSH_CARRIER_CREATE_DEL';
314: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
315: END IF;
316:
317: -- Start Logging exceptions.
317: -- Start Logging exceptions.
318: itr := l_failed_entity_tab.FIRST;
319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,
318: itr := l_failed_entity_tab.FIRST;
319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,
326: x_return_status => l_return_status,
319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,
326: x_return_status => l_return_status,
327: x_msg_count => l_msg_count,
345:
346:
347: ELSIF (p_entity = 'TRIP') THEN
348:
349: l_fnd_message_name := 'WSH_ROUTE_TRIP_FAIL';
350: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
351: itr := l_failed_entity_tab.FIRST;
352:
353: LOOP
351: itr := l_failed_entity_tab.FIRST;
352:
353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,
352:
353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,
360: x_return_status => l_return_status,
353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,
360: x_return_status => l_return_status,
361: x_msg_count => l_msg_count,
389: -- Result could not be found
390: IF (p_entity = 'DLVY') THEN
391:
392: IF p_caller = 'WSH_DLMG' THEN
393: FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');
394: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
395: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
392: IF p_caller = 'WSH_DLMG' THEN
393: FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');
394: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
395: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);
396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);
401: l_exception_message := FND_MESSAGE.Get;
402: l_exception_id := NULL;
403:
404: wsh_xc_util.log_exception(
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);
401: l_exception_message := FND_MESSAGE.Get;
402: l_exception_id := NULL;
403:
404: wsh_xc_util.log_exception(
405: p_api_version => 1.0,
419: ELSIF (p_entity = 'TRIP') THEN
420: --
421: -- For Trip we need to log the exception
422: --
423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;
420: --
421: -- For Trip we need to log the exception
422: --
423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;
428: l_exception_id := NULL;
423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;
428: l_exception_id := NULL;
429:
430: wsh_xc_util.log_exception(
431: p_api_version => 1.0,
1155: -- Put Message on the stack and return
1156: -- We can have multirecords in this case
1157: --
1158:
1159: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');
1160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1161: WSH_UTIL_CORE.add_message(x_return_status);
1162:
1163: END IF;