DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on INV_EXPRESS_PICK_PUB

Line 60: g_exp_pick_release_stat Inv_Express_Pick_Pub.P_Pick_Release_Status_Tbl;

56: g_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
57: g_trolin_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
58: g_order_number NUMBER;
59: g_del_detail_ids WSH_PICK_LIST.DelDetTabTyp;
60: g_exp_pick_release_stat Inv_Express_Pick_Pub.P_Pick_Release_Status_Tbl;
61:
62: -- X-dock, declare package level global variables
63: g_allocation_method WSH_PICKING_BATCHES.ALLOCATION_METHOD%TYPE;
64: g_xdock_delivery_ids WSH_UTIL_CORE.Id_Tab_Type; -- used for X-dock only

Line 1456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );

1452: IF l_debug_on THEN
1453: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1454: WSH_DEBUG_SV.logmsg(l_module_name,'Express Pick');
1455: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1460: Inv_Express_Pick_Pub.Pick_Release (

Line 1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);

1453: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1454: WSH_DEBUG_SV.logmsg(l_module_name,'Express Pick');
1455: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1460: Inv_Express_Pick_Pub.Pick_Release (
1461: p_api_version => l_api_version_number,

Line 1460: Inv_Express_Pick_Pub.Pick_Release (

1456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1460: Inv_Express_Pick_Pub.Pick_Release (
1461: p_api_version => l_api_version_number,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => l_commit,
1464: p_mo_line_tbl => g_trolin_tbl,

Line 1474: WSH_DEBUG_SV.log(l_module_name,'Inv_Express_Pick_Pub.Pick_Release l_return_status',l_return_status);

1470: x_msg_count => l_msg_count,
1471: x_msg_data => l_msg_data);
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1474: WSH_DEBUG_SV.log(l_module_name,'Inv_Express_Pick_Pub.Pick_Release l_return_status',l_return_status);
1475: END IF;
1476: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1477: --{
1478: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Express_Pick_Pub.Pick_Release');

Line 1478: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Express_Pick_Pub.Pick_Release');

1474: WSH_DEBUG_SV.log(l_module_name,'Inv_Express_Pick_Pub.Pick_Release l_return_status',l_return_status);
1475: END IF;
1476: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1477: --{
1478: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Express_Pick_Pub.Pick_Release');
1479: FOR i in 1..l_msg_count LOOP
1480: l_message := fnd_msg_pub.get(i,'F');
1481: l_message := replace(l_message,chr(0),' ');
1482: WSH_UTIL_CORE.PrintMsg(l_message);

Line 1490: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Express_Pick_Pub.Pick_Release. Exiting');

1486: END LOOP;
1487: fnd_msg_pub.delete_msg();
1488: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1489: --{
1490: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Express_Pick_Pub.Pick_Release. Exiting');
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.pop(l_module_name);
1494: END IF;