eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PICKING_BATCHES_GRP dependencies on WSH_PICKING_BATCHES_GRP

Line 1: PACKAGE BODY WSH_PICKING_BATCHES_GRP AS

1: PACKAGE BODY WSH_PICKING_BATCHES_GRP AS
2: /* $Header: WSHPRGPB.pls 120.12 2011/01/20 12:37:10 sunilku ship $ */
3:
4: -- Package Variables
5: --

Line 10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PICKING_BATCHES_GRP';

6: --===================
7: -- CONSTANTS
8: --===================
9: --
10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PICKING_BATCHES_GRP';
11: -- add your constants here if any
12:
13: --===================
14: -- PROCEDURES

Line 203: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';

199:
200:
201: -- Standard call to check for call compatibility
202: l_api_version CONSTANT NUMBER := 1.0;
203: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
204: l_return_status VARCHAR2(30) := NULL;
205: l_msg_count NUMBER;
206: l_msg_data VARCHAR2(32767);
207: l_number_of_errors NUMBER := 0;

Line 214: l_batch_grp_rec WSH_PICKING_BATCHES_GRP.Batch_Info_rec;

210:
211: -- Record Variable which holds the input Batch Record
212: l_batch_in_rec WSH_PICKING_BATCHES_PUB.Batch_Info_rec;
213: -- Record Variable which holds final data to be sent to the private API
214: l_batch_grp_rec WSH_PICKING_BATCHES_GRP.Batch_Info_rec;
215:
216: l_rule_id NUMBER;
217: l_rule_name VARCHAR2(60);
218: l_batch_name_prefix VARCHAR2(60);

Line 2858: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';

2854: ) IS
2855:
2856: -- Standard call to check for call compatibility
2857: l_api_version CONSTANT NUMBER := 1.0;
2858: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
2859: l_return_status VARCHAR2(30);
2860: l_msg_count NUMBER;
2861: l_msg_data VARCHAR2(32767);
2862: l_number_of_errors NUMBER := 0;

Line 3192: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');

3188: --}
3189: END IF;
3190: WHEN OTHERS THEN
3191: ROLLBACK TO PICKING_BATCH_GRP;
3192: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');
3193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3194: FND_MSG_PUB.Count_And_Get
3195: (
3196: p_count => x_msg_count,

Line 3304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_GRP.Create_Batch',WSH_DEBUG_SV.C_PROC_LEVEL);

3300: WSH_DEBUG_SV.push(l_module_name);
3301: l_log_level := 1;
3302: wsh_debug_sv.LOG(l_module_name, 'p_release_mode', p_release_mode);
3303: wsh_debug_sv.LOG(l_module_name, 'p_pick_wave_header_id', p_pick_wave_header_id);
3304: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_GRP.Create_Batch',WSH_DEBUG_SV.C_PROC_LEVEL);
3305: END IF;
3306: --pass delivery detail id as -1 as dd's are getting updated with batch id.
3307: l_batch_rec := p_batch_rec;
3308: l_batch_rec.Delivery_Detail_Id := -1;

Line 3309: WSH_PICKING_BATCHES_GRP.Create_Batch(

3305: END IF;
3306: --pass delivery detail id as -1 as dd's are getting updated with batch id.
3307: l_batch_rec := p_batch_rec;
3308: l_batch_rec.Delivery_Detail_Id := -1;
3309: WSH_PICKING_BATCHES_GRP.Create_Batch(
3310: p_api_version_number => 1.1,
3311: p_batch_rec => l_batch_rec,
3312: x_batch_id => l_batch_id,
3313: x_return_status => l_return_status,

Line 3318: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.Create_Batch return status', l_return_status);

3314: x_msg_count => x_msg_count,
3315: x_msg_data => x_msg_data
3316: );
3317: IF l_debug_on THEN
3318: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.Create_Batch return status', l_return_status);
3319: wsh_debug_sv.LOG(l_module_name, 'l_batch_id', l_batch_id);
3320: END IF;
3321: --
3322: IF NVL(l_batch_id,0) = 0 OR l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 3421: WSH_PICKING_BATCHES_GRP.release_batch(

3417: IF l_debug_on THEN
3418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PUB.RELEASE_BATCH',WSH_DEBUG_SV.C_PROC_LEVEL);
3419: END IF;
3420: --
3421: WSH_PICKING_BATCHES_GRP.release_batch(
3422: p_api_version_number => 1.1,
3423: p_batch_id => l_batch_id,
3424: p_log_level => l_log_level,
3425: p_release_mode => p_release_mode,

Line 3431: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.release_batch return status:', l_return_status);

3427: x_msg_count => x_msg_count,
3428: x_msg_data => x_msg_data,
3429: x_request_id => l_request_id);
3430: IF l_debug_on THEN
3431: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.release_batch return status:', l_return_status);
3432: wsh_debug_sv.LOG(l_module_name, 'pick release concurrent req.id:',l_request_id);
3433: END IF;
3434: IF ((l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))
3435: AND ( p_release_mode='ONLINE' OR nvl(l_request_id,0) = 0 )) THEN

Line 3460: WSH_UTIL_CORE.Default_Handler ('WSH_PICKING_BATCHES_GRP.release_wms_wave');

3456:
3457: EXCEPTION
3458: WHEN Others THEN
3459: ROLLBACK TO create_batch;
3460: WSH_UTIL_CORE.Default_Handler ('WSH_PICKING_BATCHES_GRP.release_wms_wave');
3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3462: IF c_get_dds_for_wave%ISOPEN THEN
3463: CLOSE c_get_dds_for_wave;
3464: END IF;

Line 3475: END WSH_PICKING_BATCHES_GRP;

3471: END IF;
3472: --
3473: END release_wms_wave;
3474:
3475: END WSH_PICKING_BATCHES_GRP;