46: p_entity_type IN VARCHAR2,
47: p_entity_id IN NUMBER,
48: p_parent_entity_id IN NUMBER,
49: p_list_type IN VARCHAR2,
50: x_disabled_list OUT NOCOPY wsh_util_core.column_tab_type,
51: p_caller IN VARCHAR2 DEFAULT NULL
52: )
53: IS
54:
328: EXCEPTION
329:
330: WHEN WSH_DP_NO_ENTITY THEN
331: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
332: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
335: if x_msg_count > 1 then
336: x_msg_data := l_msg_summary || l_msg_details;
330: WHEN WSH_DP_NO_ENTITY THEN
331: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
332: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
335: if x_msg_count > 1 then
336: x_msg_data := l_msg_summary || l_msg_details;
337: else
338: x_msg_data := l_msg_summary;
346: END IF;
347: --
348: WHEN WSH_DP_NO_STOP THEN
349: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_STOP');
350: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
353: if x_msg_count > 1 then
354: x_msg_data := l_msg_summary || l_msg_details;
348: WHEN WSH_DP_NO_STOP THEN
349: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_STOP');
350: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
353: if x_msg_count > 1 then
354: x_msg_data := l_msg_summary || l_msg_details;
355: else
356: x_msg_data := l_msg_summary;
364: END IF;
365: --
366: WHEN WSH_INV_LIST_TYPE THEN
367: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
368: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
371: if x_msg_count > 1 then
372: x_msg_data := l_msg_summary || l_msg_details;
366: WHEN WSH_INV_LIST_TYPE THEN
367: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
368: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
371: if x_msg_count > 1 then
372: x_msg_data := l_msg_summary || l_msg_details;
373: else
374: x_msg_data := l_msg_summary;
396: CLOSE get_trip_status;
397: END IF;
398:
399: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
401:
402: --
403: -- Debug Statements
404: --