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.3 2007/12/21 14:25:29 mvudugul 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 381: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');

377: --}
378: END IF;
379: WHEN OTHERS THEN
380: ROLLBACK TO PICKING_BATCH_PUB;
381: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
383: FND_MSG_PUB.Count_And_Get
384: (
385: p_count => x_msg_count,

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

448: x_request_id OUT NOCOPY NUMBER
449: ) IS
450:
451: l_api_version CONSTANT NUMBER := 1.0;
452: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
453:
454: l_return_status VARCHAR2(30) := NULL;
455: l_msg_count NUMBER;
456: l_msg_data VARCHAR2(32767);

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

627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
628: --}
629: END IF;
630: WHEN OTHERS THEN
631: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.RELEASE_BATCH');
632: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.Count_And_Get
634: (
635: p_count => x_msg_count,

Line 690: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec

686: x_msg_data OUT NOCOPY VARCHAR2,
687: -- program specific paramters.
688: p_batch_id IN NUMBER DEFAULT NULL,
689: p_batch_name IN VARCHAR2 DEFAULT NULL,
690: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
691: ) IS
692: l_api_version CONSTANT NUMBER := 1.0;
693: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
694:

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

689: p_batch_name IN VARCHAR2 DEFAULT NULL,
690: x_batch_rec OUT NOCOPY WSH_PICKING_BATCHES_PUB.Batch_Info_Rec
691: ) IS
692: l_api_version CONSTANT NUMBER := 1.0;
693: l_api_name CONSTANT VARCHAR2(30):= 'WSH_PICKING_BATCHES_PUB';
694:
695: l_return_status VARCHAR2(30) := NULL;
696: l_msg_count NUMBER;
697: l_msg_data VARCHAR2(32767);

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

1050: WHEN OTHERS THEN
1051: IF c_batch_info%ISOPEN THEN
1052: CLOSE c_batch_info;
1053: END IF;
1054: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.GET_BATCH_RECORD');
1055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1056: FND_MSG_PUB.Count_And_Get
1057: (
1058: p_count => x_msg_count,

Line 1072: END WSH_PICKING_BATCHES_PUB;

1068: END IF;
1069: --
1070: END Get_Batch_Record;
1071:
1072: END WSH_PICKING_BATCHES_PUB;