APPS.WSH_PICKING_BATCHES_PUB dependencies on WSH_PICKING_BATCHES_PUB

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 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 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 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 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 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;