DBA Data[Home] [Help]

APPS.WSH_PACKING_SLIPS_PVT dependencies on WSH_UTIL_CORE

Line 164: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

160: EXCEPTION
161: WHEN wsh_update_document_error THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: --FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_UPDATE_DOCUMENT_ERROR');
164: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
165:
166: --
167: -- Debug Statements
168: --

Line 177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

173: --
174: WHEN delivery_id_locked THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178:
179: --
180: -- Debug Statements
181: --

Line 190: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

186: --
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: --FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
190: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
191:
192: --
193: -- Debug Statements
194: --

Line 220: l_del_rows wsh_util_core.id_tab_type;

216: )
217: IS
218: x_rowid varchar2(30);
219: l_trip_info wsh_trips_pvt.trip_rec_type;
220: l_del_rows wsh_util_core.id_tab_type;
221: l_ledger_id VARCHAR2(30); -- LE Uptake
222:
223: wsh_create_document_error EXCEPTION;
224:

Line 369: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

365: EXCEPTION
366: WHEN wsh_create_document_error THEN
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: -- FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CREATE_DOCUMENT_ERROR');
369: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
370:
371: --
372: -- Debug Statements
373: --

Line 382: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

378: --
379: WHEN delivery_id_locked THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_LOCK');
382: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
383:
384: --
385: -- Debug Statements
386: --

Line 395: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

391: --
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: -- FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
395: -- WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
396:
397: --
398: -- Debug Statements
399: --

Line 486: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

482: EXCEPTION
483: WHEN wsh_cancel_document_error THEN
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: --FND_MESSAGE.SET_NAME('WSH', 'WSH_BOL_CANCEL_DOCUMENT_ERROR');
486: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
487: --
488: -- Debug Statements
489: --
490: IF l_debug_on THEN

Line 498: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

494: --
495: WHEN OTHERS THEN
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: --FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
498: --WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
499:
500: --
501: -- Debug Statements
502: --

Line 524: , x_disabled_list OUT NOCOPY WSH_UTIL_CORE.column_tab_type

520: PROCEDURE Get_Disabled_List(
521: p_delivery_id IN NUMBER
522: , p_list_type IN VARCHAR2
523: , x_return_status OUT NOCOPY VARCHAR2
524: , x_disabled_list OUT NOCOPY WSH_UTIL_CORE.column_tab_type
525: , x_msg_count OUT NOCOPY NUMBER
526: , x_msg_data OUT NOCOPY VARCHAR2
527: )
528: IS

Line 565: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

561: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
562: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
563: END IF;
564: --
565: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
566:
567: -- clear the disabled list first
568: x_disabled_list.delete;
569:

Line 599: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

595: EXCEPTION
596: WHEN wsh_dp_no_entity THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
599: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
600: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
601: IF x_msg_count > 1 then
602: x_msg_data := l_msg_summary || l_msg_details;
603: ELSE

Line 600: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);

596: WHEN wsh_dp_no_entity THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');
599: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
600: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
601: IF x_msg_count > 1 then
602: x_msg_data := l_msg_summary || l_msg_details;
603: ELSE
604: x_msg_data := l_msg_summary;

Line 618: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

614: --
615: WHEN wsh_inv_list_type THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
618: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
619: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
620: IF x_msg_count > 1 then
621: x_msg_data := l_msg_summary || l_msg_details;
622: ELSE

Line 619: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);

615: WHEN wsh_inv_list_type THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');
618: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
619: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
620: IF x_msg_count > 1 then
621: x_msg_data := l_msg_summary || l_msg_details;
622: ELSE
623: x_msg_data := l_msg_summary;

Line 638: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');

634: WHEN others THEN
635: IF (get_delivery_status%ISOPEN) THEN
636: CLOSE get_delivery_status;
637: END IF;
638: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640:
641: --
642: -- Debug Statements

Line 639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

635: IF (get_delivery_status%ISOPEN) THEN
636: CLOSE get_delivery_status;
637: END IF;
638: wsh_util_core.default_handler('WSH_DELIVERY_VALIDATIONS.get_disabled_list');
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640:
641: --
642: -- Debug Statements
643: --