22: , x_return_status OUT NOCOPY VARCHAR2
23: , x_msg_count OUT NOCOPY NUMBER
24: , x_msg_data OUT NOCOPY VARCHAR2
25: , p_caller IN VARCHAR2
26: , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType
27: , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
28: ) IS
29:
30: l_debug number;
23: , x_msg_count OUT NOCOPY NUMBER
24: , x_msg_data OUT NOCOPY VARCHAR2
25: , p_caller IN VARCHAR2
26: , p_gen_lpn_rec IN WMS_Data_Type_Definitions_PUB.AutoCreateLPNRecordType
27: , p_lpn_table OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
28: ) IS
29:
30: l_debug number;
31: l_api_name VARCHAR2(20);
31: l_api_name VARCHAR2(20);
32:
33: l_msgdata VARCHAR2(1000);
34: l_ucc_128_suffix_flag VARCHAR2(1);
35: l_serial_range WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
36: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;
37:
38: BEGIN
39: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
32:
33: l_msgdata VARCHAR2(1000);
34: l_ucc_128_suffix_flag VARCHAR2(1);
35: l_serial_range WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
36: l_lpn_attr WMS_Data_Type_Definitions_PUB.LPNRecordType;
37:
38: BEGIN
39: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
40: l_api_name := 'Auto_Create_LPNs';
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_msg_count OUT NOCOPY NUMBER
137: , x_msg_data OUT NOCOPY VARCHAR2
138: , p_caller IN VARCHAR2
139: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
140: ) IS
141: BEGIN
142: x_return_status := fnd_api.g_ret_sts_success;
143:
162: , x_return_status OUT NOCOPY VARCHAR2
163: , x_msg_count OUT NOCOPY NUMBER
164: , x_msg_data OUT NOCOPY VARCHAR2
165: , p_caller IN VARCHAR2
166: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
167: ) IS
168: BEGIN
169: x_return_status := fnd_api.g_ret_sts_success;
170:
190: , x_msg_count OUT NOCOPY NUMBER
191: , x_msg_data OUT NOCOPY VARCHAR2
192: , p_caller IN VARCHAR2
193: , p_action IN VARCHAR2
194: , p_lpn_purge_rec IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNPurgeRecordType
195: ) IS
196:
197: l_debug number;
198: l_api_name VARCHAR2(20);
195: ) IS
196:
197: l_debug number;
198: l_api_name VARCHAR2(20);
199: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
200: l_purge_count WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
201: l_msgdata VARCHAR2(1000);
202:
203: BEGIN
196:
197: l_debug number;
198: l_api_name VARCHAR2(20);
199: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
200: l_purge_count WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
201: l_msgdata VARCHAR2(1000);
202:
203: BEGIN
204: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);