637: WSH_DEBUG_SV.logmsg(l_module_name,'logging to the message table NO_REGION_MAP_D');
638: END IF;
639:
640: l_msg_ctr := msg_message_text_tab.COUNT + 1;
641: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_DEST_LOC');
642: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).destination_id));
643: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
644: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
645: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_D';
638: END IF;
639:
640: l_msg_ctr := msg_message_text_tab.COUNT + 1;
641: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_DEST_LOC');
642: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).destination_id));
643: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
644: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
645: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_D';
646: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
639:
640: l_msg_ctr := msg_message_text_tab.COUNT + 1;
641: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_DEST_LOC');
642: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).destination_id));
643: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
644: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
645: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_D';
646: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
647: msg_level_tab(l_msg_ctr) := l_distance_profile;
666: WSH_DEBUG_SV.logmsg(l_module_name,'logging to the message table NO_REGION_MAP_O');
667: END IF;
668:
669: l_msg_ctr := msg_message_text_tab.COUNT + 1;
670: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_ORIG_LOC');
671: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).origin_id));
672: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
673: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
674: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_O';
667: END IF;
668:
669: l_msg_ctr := msg_message_text_tab.COUNT + 1;
670: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_ORIG_LOC');
671: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).origin_id));
672: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
673: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
674: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_O';
675: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
668:
669: l_msg_ctr := msg_message_text_tab.COUNT + 1;
670: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGN_MAP_ORIG_LOC');
671: FND_MESSAGE.SET_TOKEN('LOCATION_ID',to_char(p_distance_input_tab(eee).origin_id));
672: msg_message_text_tab(l_msg_ctr) := FND_MESSAGE.GET;
673: msg_message_type_tab(l_msg_ctr) := WSH_UTIL_CORE.G_RET_STS_WARNING;
674: msg_message_code_tab(l_msg_ctr) := 'NO_REGION_MAP_O';
675: msg_location_region_flag_tab(l_msg_ctr) := p_location_region_flag;
676: msg_level_tab(l_msg_ctr) := l_distance_profile;
984:
985: EXCEPTION
986: WHEN FTE_DIST_NO_INPUT_DATA THEN
987: --5067249
988: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_INPUT_DATA');
989: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
990: x_return_message := 'FTE_DIST_NO_INPUT_DATA';
991: --WSH_UTIL_CORE.add_message(x_return_status);
992:
1007: END IF;
1008:
1009: WHEN FTE_DIST_INVALID_LOC_REG_FLAG THEN
1010: --5067249
1011: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_LOC_REG_FLAG');
1012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1013: x_return_message := 'FTE_DIST_INVALID_LOC_REG_FLAG';
1014: --WSH_UTIL_CORE.add_message(x_return_status);
1015:
1054: WSH_UTIL_CORE.default_handler('FTE_DIST_INT.GET_DISTANCE_TIME');
1055:
1056: WHEN FTE_DIST_INVALID_PROFILE THEN
1057: --5067249
1058: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: x_return_message := 'FTE_DIST_INVALID_PROFILE';
1061: --WSH_UTIL_CORE.add_message(x_return_status);
1062:
1078: END IF;
1079:
1080: WHEN FTE_DIST_NULL_PROFILE THEN
1081: --5067249
1082: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_PROFILE');
1083: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1084: x_return_message := 'FTE_DIST_NULL_PROFILE';
1085: --WSH_UTIL_CORE.add_message(x_return_status);
1086:
1102: END IF;
1103:
1104: WHEN FTE_DIST_NO_REGS_FOR_ANY_LOCS THEN
1105: --5067249
1106: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_FOR_ANY_LOCS');
1107: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1108: x_return_message := 'FTE_DIST_NO_REGS_FOR_ANY_LOCS';
1109: --WSH_UTIL_CORE.add_message(x_return_status);
1110:
1126: END IF;
1127:
1128: WHEN FTE_DIST_NO_REGS_IN_SEARCH THEN
1129: --5067249
1130: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGS_IN_SEARCH');
1131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1132: x_return_message := 'FTE_DIST_NO_REGS_IN_SEARCH';
1133: --WSH_UTIL_CORE.add_message(x_return_status);
1134:
1150: END IF;
1151:
1152: WHEN FTE_DIST_NULL_REGION_TYPE THEN
1153: --5067249
1154: --FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_REGION_TYPE');
1155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1156: x_return_message := 'FTE_DIST_NULL_REGION_TYPE';
1157: --WSH_UTIL_CORE.add_message(x_return_status);
1158:
1411: IF (p_messaging_yn = 'Y') THEN
1412: --
1413: -- Set the no records found error message in case we need to log it
1414: --
1415: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RECORDS_FOUND');
1416: l_msg_no_rcds_fnd := FND_MESSAGE.GET;
1417: END IF;
1418:
1419:
1412: --
1413: -- Set the no records found error message in case we need to log it
1414: --
1415: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RECORDS_FOUND');
1416: l_msg_no_rcds_fnd := FND_MESSAGE.GET;
1417: END IF;
1418:
1419:
1420: