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_PUB dependencies on WSH_PICKING_BATCHES

Line 1: PACKAGE BODY WSH_PICKING_BATCHES_PUB AS

1: PACKAGE BODY WSH_PICKING_BATCHES_PUB AS
2: /* $Header: WSHPRPBB.pls 120.5 2010/05/14 10:01:58 sunilku ship $ */
3:
4: --
5: -- Package Variables

Line 11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PICKING_BATCHES_PUB';

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

Line 63: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ,

59:
60: -- program specific paramters.
61: p_rule_id IN NUMBER DEFAULT NULL,
62: p_rule_name IN VARCHAR2 DEFAULT NULL,
63: p_batch_rec IN WSH_PICKING_BATCHES_PUB.Batch_Info_Rec ,
64: p_batch_prefix IN VARCHAR2 DEFAULT NULL ,
65: x_batch_id OUT NOCOPY NUMBER
66:
67: ) IS

Line 72: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';

68:
69:
70:
71: l_api_version CONSTANT NUMBER := 1.0;
72: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
73:
74: l_return_status VARCHAR2(30) := NULL;
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(32767);

Line 82: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec;

78: l_number_of_warnings NUMBER := 0;
79:
80: l_rule_id NUMBER;
81: l_rule_name VARCHAR2(150);
82: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec;
83: l_batch_prefix VARCHAR2(30);
84: l_batch_id NUMBER;
85:
86: l_debug_on BOOLEAN;

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

235:
236:
237: IF l_debug_on THEN
238: --{
239: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_GRP.CREATE_BATCH',WSH_DEBUG_SV.C_PROC_LEVEL);
240: --}
241: END IF;
242:
243: /* -- Bug # 7505524 :moved the following code to group API

Line 244: WSH_PICKING_BATCHES_GRP.create_batch

240: --}
241: END IF;
242:
243: /* -- Bug # 7505524 :moved the following code to group API
244: WSH_PICKING_BATCHES_GRP.create_batch
245: --
246: -- X-dock
247: -- 1)Validate CrossDock Criteria Name for WMS org.
248: -- Always use crossdock_criteria_id except when crossdock_criteria_id is null

Line 291: WSH_PICKING_BATCHES_GRP.Create_Batch(

287: END IF;
288: -- End of ECO 4634966
289: Bug # 7505524*/
290:
291: WSH_PICKING_BATCHES_GRP.Create_Batch(
292: p_api_version_number => p_api_version,
293: p_init_msg_list => NULL, --- Treated as False in Group API
294: p_commit => NULL, --- Treated as False in Group API
295: x_return_status => l_return_status,

Line 388: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');

384: --}
385: END IF;
386: WHEN OTHERS THEN
387: ROLLBACK TO PICKING_BATCH_PUB;
388: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count,

Line 427: -- information from the wsh_picking_batches table.

423: -- x_return_status return status
424: -- x_msg_count number of messages in the list
425: -- x_msg_data text of messages
426: -- p_batch_id Picking Batch Id which is used to get Batch
427: -- information from the wsh_picking_batches table.
428: -- p_batch_name Picking Batch Name which is used to get Batch
429: -- information from the wsh_picking_batches table.
430: -- p_log_level Controlls the log message generated by cuncurrent
431: -- pick release process.

Line 429: -- information from the wsh_picking_batches table.

425: -- x_msg_data text of messages
426: -- p_batch_id Picking Batch Id which is used to get Batch
427: -- information from the wsh_picking_batches table.
428: -- p_batch_name Picking Batch Name which is used to get Batch
429: -- information from the wsh_picking_batches table.
430: -- p_log_level Controlls the log message generated by cuncurrent
431: -- pick release process.
432: -- p_release_mode Used to do ONLINE or CONCURRENT pick release,
433: -- Default is "CONCURREN"

Line 459: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';

455: x_request_id OUT NOCOPY NUMBER
456: ) IS
457:
458: l_api_version CONSTANT NUMBER := 1.0;
459: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
460:
461: l_return_status VARCHAR2(30) := NULL;
462: l_msg_count NUMBER;
463: l_msg_data VARCHAR2(32767);

Line 533: WSH_PICKING_BATCHES_GRP.release_batch

529: l_release_mode := p_release_mode;
530: l_log_level := p_log_level;
531:
532: /* Bug # 7505524: moved the following code to group API
533: WSH_PICKING_BATCHES_GRP.release_batch
534: IF l_release_mode = 'CONCURRENT' THEN
535: l_num_workers := NVL(FND_PROFILE.Value('WSH_PR_NUM_WORKERS'), 1);
536: ELSE
537: l_num_workers := 1;

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

539:
540:
541: IF l_debug_on THEN
542: --{
543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_GRP.RELASE_BATCH',WSH_DEBUG_SV.C_PROC_LEVEL);
544: --}
545: END IF;
546: --
547: WSH_PICKING_BATCHES_GRP.Release_Batch(

Line 547: WSH_PICKING_BATCHES_GRP.Release_Batch(

543: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_GRP.RELASE_BATCH',WSH_DEBUG_SV.C_PROC_LEVEL);
544: --}
545: END IF;
546: --
547: WSH_PICKING_BATCHES_GRP.Release_Batch(
548: p_api_version_number => p_api_version,
549: p_init_msg_list => NULL, --- Treated as False in Group API
550: p_commit => NULL, --- Treated as False in Group API
551: x_return_status => l_return_status,

Line 640: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');

636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
637: --}
638: END IF;
639: WHEN OTHERS THEN
640: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get
643: (
644: p_count => x_msg_count,

Line 670: -- the batch record from wsh_picking_batches.

666: -- Type : Public
667: -- Purpose
668: -- Pre-reqs : None.
669: -- Function : The procedure takes in a Batch_id or Batch_name and retrieves
670: -- the batch record from wsh_picking_batches.
671: -- Note: Non-database attributes will be NULL.
672: --
673: -- PARAMETERS : p_api_version_number known api version number
674: -- p_init_msg_list FND_API.G_TRUE to reset list

Line 680: -- information from the wsh_picking_batches table.

676: -- x_return_status return status
677: -- x_msg_count number of messages in the list
678: -- x_msg_data text of messages
679: -- p_batch_id Picking Batch Id which is used to get Batch
680: -- information from the wsh_picking_batches table.
681: -- p_batch_name Picking Batch Name which is used to get Batch
682: -- information from the wsh_picking_batches table.
683: -- x_batch_rec Batch record from wsh_picking_batches
684: -- VERSION : current version 1.0

Line 682: -- information from the wsh_picking_batches table.

678: -- x_msg_data text of messages
679: -- p_batch_id Picking Batch Id which is used to get Batch
680: -- information from the wsh_picking_batches table.
681: -- p_batch_name Picking Batch Name which is used to get Batch
682: -- information from the wsh_picking_batches table.
683: -- x_batch_rec Batch record from wsh_picking_batches
684: -- VERSION : current version 1.0
685: -- initial version 1.0
686: -- End of comments

Line 683: -- x_batch_rec Batch record from wsh_picking_batches

679: -- p_batch_id Picking Batch Id which is used to get Batch
680: -- information from the wsh_picking_batches table.
681: -- p_batch_name Picking Batch Name which is used to get Batch
682: -- information from the wsh_picking_batches table.
683: -- x_batch_rec Batch record from wsh_picking_batches
684: -- VERSION : current version 1.0
685: -- initial version 1.0
686: -- End of comments
687:

Line 699: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec

695: x_msg_data OUT NOCOPY VARCHAR2,
696: -- program specific paramters.
697: p_batch_id IN NUMBER DEFAULT NULL,
698: p_batch_name IN VARCHAR2 DEFAULT NULL,
699: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
700: ) IS
701: l_api_version CONSTANT NUMBER := 1.0;
702: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
703:

Line 702: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';

698: p_batch_name IN VARCHAR2 DEFAULT NULL,
699: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
700: ) IS
701: l_api_version CONSTANT NUMBER := 1.0;
702: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
703:
704: l_return_status VARCHAR2(30) := NULL;
705: l_msg_count NUMBER;
706: l_msg_data VARCHAR2(32767);

Line 805: FROM wsh_picking_batches

801: -- LSP PROJECT :
802: client_id,
803: NULL
804: -- LSP PROJECT :
805: FROM wsh_picking_batches
806: WHERE batch_id = x_batch_id;
807:
808: BEGIN
809:

Line 1067: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');

1063: WHEN OTHERS THEN
1064: IF c_batch_info%ISOPEN THEN
1065: CLOSE c_batch_info;
1066: END IF;
1067: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: FND_MSG_PUB.Count_And_Get
1070: (
1071: p_count => x_msg_count,

Line 1085: END WSH_PICKING_BATCHES_PUB;

1081: END IF;
1082: --
1083: END Get_Batch_Record;
1084:
1085: END WSH_PICKING_BATCHES_PUB;