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 1517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );

1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1515: WSH_DEBUG_SV.logmsg(l_module_name,'Express Pick');
1516: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1521: Inv_Express_Pick_Pub.Pick_Release (

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

1514: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1515: WSH_DEBUG_SV.logmsg(l_module_name,'Express Pick');
1516: WSH_DEBUG_SV.logmsg(l_module_name,'============');
1517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1521: Inv_Express_Pick_Pub.Pick_Release (
1522: p_api_version => l_api_version_number,

Line 1521: Inv_Express_Pick_Pub.Pick_Release (

1517: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Inv_Express_Pick_Pub.Pick_Release with COUNT:'||G_TROLIN_TBL.COUNT );
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit Inv_Express_Pick_Pub.Pick_Release',WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: WSH_PICK_LIST.G_AUTO_PICK_CONFIRM := 'Y';
1521: Inv_Express_Pick_Pub.Pick_Release (
1522: p_api_version => l_api_version_number,
1523: p_init_msg_list => FND_API.G_TRUE,
1524: p_commit => l_commit,
1525: p_mo_line_tbl => g_trolin_tbl,

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

1531: x_msg_count => l_msg_count,
1532: x_msg_data => l_msg_data);
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1535: WSH_DEBUG_SV.log(l_module_name,'Inv_Express_Pick_Pub.Pick_Release l_return_status',l_return_status);
1536: END IF;
1537: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1538: --{
1539: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Express_Pick_Pub.Pick_Release');

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

1535: WSH_DEBUG_SV.log(l_module_name,'Inv_Express_Pick_Pub.Pick_Release l_return_status',l_return_status);
1536: END IF;
1537: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1538: --{
1539: WSH_UTIL_CORE.PrintMsg('Error occurred in Inv_Express_Pick_Pub.Pick_Release');
1540: FOR i in 1..l_msg_count LOOP
1541: l_message := fnd_msg_pub.get(i,'F');
1542: l_message := replace(l_message,chr(0),' ');
1543: WSH_UTIL_CORE.PrintMsg(l_message);

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

1547: END LOOP;
1548: fnd_msg_pub.delete_msg();
1549: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1550: --{
1551: WSH_UTIL_CORE.PrintMsg('Unexpected error from Inv_Express_Pick_Pub.Pick_Release. Exiting');
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.pop(l_module_name);
1555: END IF;