1 PACKAGE WMS_Label_PUB AUTHID CURRENT_USER AS
2 /* $Header: WMSLABLS.pls 115.0 2000/07/07 15:47:32 pkm ship $ */
3
4 /* Define global variables */
5 g_dir VARCHAR2(100); -- get this from profile
6 g_file VARCHAR2(30); -- generate this based on a sequence or request id
7 -- since it has to be unique
8 g_printer VARCHAR2(30); -- get this from profile
9 g_label VARCHAR2(30); -- get this based on business logic
10 g_no_copies NUMBER; -- get this based on business logic
11 g_variable_name VARCHAR2(30); -- get the variable name used in the label template
12 g_variable_value VARCHAR2(4000); -- get this based on the business logic
13
14 /*---------------------------------------------------------------------*/
15 -- Name
16 -- FUNCTION Output_file_dir
17 /* --------------------------------------------------------------------*/
18 -- Purpose
19 -- Extract the outfile dir name from the database
20
21 FUNCTION Output_file_dir return varchar2;
22 /*---------------------------------------------------------------------*/
23 -- Name
24 -- PROCEDURE Location_Label
25 /* --------------------------------------------------------------------*/
26 --
27 -- Purpose
28 -- Create XML File for Location label
29 --
30 -- Input Parameters
31 -- p_api_version
32 -- API version number (current version is 1.0)
33 -- p_init_msg_list (optional, default FND_API.G_FALSE)
34 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
35 -- if set to FND_API.G_TRUE
36 -- initialize error message list
37 -- if set to FND_API.G_FALSE - not initialize error
38 -- message list
39 -- p_commit (optional, default FND_API.G_FALSE)
40 -- whether or not to commit the changes to database
41 -- p_organization_id Organization Id - Required Value
42 -- p_Zone_From Zone Range From
43 -- p_Zone_To Zone Range To
44 -- p_location_fr Location Range From
45 -- (only Segment Values are passed)
46 -- p_location_to Location Range To
47 -- (only Segment Values are passed)
48 -- p_no_of_copies Number of copies of dupliate label
49 --
50 --
51 -- Output Parameters
52 -- x_return_status
53 -- if the pick release process succeeds, the value is
54 -- fnd_api.g_ret_sts_success;
55 -- if there is an expected error, the value is
56 -- fnd_api.g_ret_sts_error;
57 -- if there is an unexpected error, the value is
58 -- fnd_api.g_ret_sts_unexp_error;
59 -- x_msg_count
60 -- if there is one or more errors, the number of error messages
61 -- in the buffer
62 -- x_msg_data
63 -- if there is one and only one error, the error message
64 -- (See fnd_api package for more details about the above output parameters)
65
66 PROCEDURE Location_Label
67 ( p_api_version IN NUMBER ,
68 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
69 p_commit IN VARCHAR2 := fnd_api.g_false ,
70 x_return_status OUT VARCHAR2 ,
71 x_msg_count OUT NUMBER ,
72 x_msg_data OUT VARCHAR2 ,
73 p_organization_id IN NUMBER ,
74 p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,
75 p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,
76 p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,
77 p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,
78 p_no_of_copies IN NUMBER := 1
79 );
80 /*---------------------------------------------------------------------*/
81 -- Name
82 -- PROCEDURE Item_Label
83 /* --------------------------------------------------------------------*/
84 --
85 -- Purpose
86 -- Create XML File for Item Label
87 --
88 -- Input Parameters
89 -- p_api_version
90 -- API version number (current version is 1.0)
91 -- p_init_msg_list (optional, default FND_API.G_FALSE)
92 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
93 -- if set to FND_API.G_TRUE
94 -- initialize error message list
95 -- if set to FND_API.G_FALSE - not initialize error
96 -- message list
97 -- p_commit (optional, default FND_API.G_FALSE)
98 -- whether or not to commit the changes to database
99 -- p_organization_id Organization Id - Required Value
100 -- p_Zone_From Zone Range From
101 -- p_Zone_To Zone Range To
102 -- p_location_fr Location Range From
103 -- (Segment Values are passed)
104 -- p_location_to Location Range To
105 -- (Segment Values are passed)
106 -- p_item_fr item Range From
107 -- (only Segment Values are passed)
108 -- p_item_to Location Range To
109 -- (only Segment Values are passed)
110 -- p_no_of_copies Number of copies of dupliate label
111 --
112 --
113 -- Output Parameters
114 -- x_return_status
115 -- if the pick release process succeeds, the value is
116 -- fnd_api.g_ret_sts_success;
117 -- if there is an expected error, the value is
118 -- fnd_api.g_ret_sts_error;
119 -- if there is an unexpected error, the value is
120 -- fnd_api.g_ret_sts_unexp_error;
121 -- x_msg_count
122 -- if there is one or more errors, the number of error messages
123 -- in the buffer
124 -- x_msg_data
125 -- if there is one and only one error, the error message
126 -- (See fnd_api package for more details about the above output parameters)
127
128 PROCEDURE Item_Label
129 ( p_api_version IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
131 p_commit IN VARCHAR2 := fnd_api.g_false ,
132 x_return_status OUT VARCHAR2 ,
133 x_msg_count OUT NUMBER ,
134 x_msg_data OUT VARCHAR2 ,
135 p_organization_id IN NUMBER ,
136 p_zone_fr IN VARCHAR2 := NULL ,
137 p_zone_to IN VARCHAR2 := NULL ,
138 p_location_fr IN VARCHAR2 := NULL ,
139 p_location_to IN VARCHAR2 := NULL ,
140 p_item_fr IN VARCHAR2 := NULL ,
141 p_item_to IN VARCHAR2 := NULL ,
142 p_no_of_copies IN NUMBER
143 );
144 /*---------------------------------------------------------------------*/
145 -- Name
146 -- PROCEDURE Material_Movement_Label
147 /* --------------------------------------------------------------------*/
148 --
149 -- Purpose
150 -- Create XML File for Material Movement Label like Pick and Putaway
151 --
152 -- Input Parameters
153 -- p_api_version
154 -- API version number (current version is 1.0)
155 -- p_init_msg_list (optional, default FND_API.G_FALSE)
156 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
157 -- if set to FND_API.G_TRUE
158 -- initialize error message list
159 -- if set to FND_API.G_FALSE - not initialize error
160 -- message list
161 -- p_commit (optional, default FND_API.G_FALSE)
162 -- whether or not to commit the changes to database
163 -- p_organization_id Organization Id - Required Value
164 -- p_Move_Order_Number Move Order Number
165 -- p_Zone_From Zone Range From
166 -- p_Zone_To Zone Range To
167 -- p_location_fr Location Range From
168 -- (only Segment Values are passed)
169 -- p_location_to Location Range To
170 -- (only Segment Values are passed)
171 -- p_mo_no Mover Order Number
172 -- p_wip_job_no WIP Job Number
173 -- p_no_of_copies Number of copies of dupliate label
174 --
175 --
176 -- Output Parameters
177 -- x_return_status
178 -- if the pick release process succeeds, the value is
179 -- fnd_api.g_ret_sts_success;
180 -- if there is an expected error, the value is
181 -- fnd_api.g_ret_sts_error;
182 -- if there is an unexpected error, the value is
183 -- fnd_api.g_ret_sts_unexp_error;
184 -- x_msg_count
185 -- if there is one or more errors, the number of error messages
186 -- in the buffer
187 -- x_msg_data
188 -- if there is one and only one error, the error message
189 -- (See fnd_api package for more details about the above output parameters)
190
191 PROCEDURE Material_Movement_Label
192 ( p_api_version IN NUMBER ,
193 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
194 p_commit IN VARCHAR2 := fnd_api.g_false ,
195 x_return_status OUT VARCHAR2 ,
196 x_msg_count OUT NUMBER ,
197 x_msg_data OUT VARCHAR2 ,
198 p_organization_id IN NUMBER ,
199 p_zone_fr IN VARCHAR2 := NULL ,
200 p_zone_to IN VARCHAR2 := NULL ,
201 p_location_fr IN VARCHAR2 := NULL ,
202 p_location_to IN VARCHAR2 := NULL ,
203 p_mo_no IN NUMBER := NULL ,
204 p_wip_job_no IN NUMBER := NULL ,
205 p_no_of_copies IN NUMBER
206 );
207 /*---------------------------------------------------------------------*/
208 -- Name
209 -- PROCEDURE Palette_Label
210 /* --------------------------------------------------------------------*/
211 --
212 -- Purpose
213 -- Create XML File for Palette Label
214 --
215 -- Input Parameters
216 -- p_api_version
217 -- API version number (current version is 1.0)
218 -- p_init_msg_list (optional, default FND_API.G_FALSE)
219 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
220 -- if set to FND_API.G_TRUE
221 -- initialize error message list
222 -- if set to FND_API.G_FALSE - not initialize error
223 -- message list
224 -- p_commit (optional, default FND_API.G_FALSE)
225 -- whether or not to commit the changes to database
226 -- p_organization_id Organization Id - Required Value
227 -- p_Move_Order_Number Move Order Number
228 -- p_Zone_From Zone Range From
229 -- p_Zone_To Zone Range To
230 -- p_Location_fr Location Range From
231 -- (only Segment Values are passed)
232 -- p_Location_to Location Range To
233 -- (only Segment Values are passed)
234 -- p_Shipment Number Shipment Number
235 -- p_Delivery_id Delivery Id
236 -- p_Delivery_line_id Delivery Line Id
237 -- p_Pslip_no Pick Slip Number
238 -- p_no_of_copies Number of copies of dupliate label
242 -- x_return_status
239 --
240 --
241 -- Output Parameters
243 -- if the pick release process succeeds, the value is
244 -- fnd_api.g_ret_sts_success;
245 -- if there is an expected error, the value is
246 -- fnd_api.g_ret_sts_error;
247 -- if there is an unexpected error, the value is
248 -- fnd_api.g_ret_sts_unexp_error;
249 -- x_msg_count
250 -- if there is one or more errors, the number of error messages
251 -- in the buffer
252 -- x_msg_data
253 -- if there is one and only one error, the error message
254 -- (See fnd_api package for more details about the above output parameters)
255
256 PROCEDURE Palette_Label
257 ( p_api_version IN NUMBER ,
258 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
259 p_commit IN VARCHAR2 := fnd_api.g_false ,
260 x_return_status OUT VARCHAR2 ,
261 x_msg_count OUT NUMBER ,
262 x_msg_data OUT VARCHAR2 ,
263 p_organization_id IN NUMBER ,
264 p_zone_fr IN VARCHAR2 := NULL ,
265 p_zone_to IN VARCHAR2 := NULL ,
266 p_location_fr IN VARCHAR2 := NULL ,
267 p_location_to IN VARCHAR2 := NULL ,
268 p_delivery_id IN NUMBER := NULL ,
269 p_shipment_number IN VARCHAR2 := NULL ,
270 p_delivery_line_id IN NUMBER := NULL ,
271 p_pslip_number IN VARCHAR2 := NULL ,
272 p_no_of_copies IN NUMBER
273 );
274 /*---------------------------------------------------------------------*/
275 -- Name
276 -- PROCEDURE Kanban_Card_Label
277 /* --------------------------------------------------------------------*/
278 --
279 -- Purpose
280 -- Create XML File for Kanban Card Label
281 --
282 -- Input Parameters
283 -- p_api_version
284 -- API version number (current version is 1.0)
285 -- p_init_msg_list (optional, default FND_API.G_FALSE)
286 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
287 -- if set to FND_API.G_TRUE
288 -- initialize error message list
289 -- if set to FND_API.G_FALSE - not initialize error
290 -- message list
291 -- p_commit (optional, default FND_API.G_FALSE)
292 -- whether or not to commit the changes to database
293 -- p_kanban_card_id_fr Kanban Card Id Range from
294 -- p_kanban_card_id_to Kanban Card Id Range To
295 -- p_no_of_copies Number of copies of dupliate label
296 --
297 --
298 -- Output Parameters
299 -- x_return_status
300 -- if the pick release process succeeds, the value is
301 -- fnd_api.g_ret_sts_success;
302 -- if there is an expected error, the value is
303 -- fnd_api.g_ret_sts_error;
304 -- if there is an unexpected error, the value is
305 -- fnd_api.g_ret_sts_unexp_error;
306 -- x_msg_count
307 -- if there is one or more errors, the number of error messages
308 -- in the buffer
309 -- x_msg_data
310 -- if there is one and only one error, the error message
311 -- (See fnd_api package for more details about the above output parameters)
312
313 PROCEDURE Kanban_Card_Label
314 ( p_api_version IN NUMBER ,
315 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
316 p_commit IN VARCHAR2 := fnd_api.g_false ,
317 x_return_status OUT VARCHAR2 ,
318 x_msg_count OUT NUMBER ,
319 x_msg_data OUT VARCHAR2 ,
320 p_kanban_card_id_fr IN NUMBER ,
321 p_kanban_card_id_to IN NUMBER ,
322 p_no_of_copies IN NUMBER
323 );
324 /*---------------------------------------------------------------------*/
325 -- Name
326 -- PROCEDURE LPN_Label
327 /* --------------------------------------------------------------------*/
328 --
329 -- Purpose
330 -- Create XML File for LPN Label
331 --
332 -- Input Parameters
333 -- p_api_version
334 -- API version number (current version is 1.0)
335 -- p_init_msg_list (optional, default FND_API.G_FALSE)
336 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
337 -- if set to FND_API.G_TRUE
338 -- initialize error message list
339 -- if set to FND_API.G_FALSE - not initialize error
340 -- message list
341 -- p_commit (optional, default FND_API.G_FALSE)
342 -- whether or not to commit the changes to database
343 -- p_lpn_fr LPN Range from
344 -- p_lpn_to LPN Range To
345 -- p_customer_id Customer ID
346 -- p_ship_to_loc_id Ship To Location ID
347 -- p_Include_Contents Include LPn Contents
348 -- p_no_of_copies Number of copies of dupliate label
349 --
350 --
351 -- Output Parameters
352 -- x_return_status
353 -- if the pick release process succeeds, the value is
354 -- fnd_api.g_ret_sts_success;
355 -- if there is an expected error, the value is
356 -- fnd_api.g_ret_sts_error;
357 -- if there is an unexpected error, the value is
358 -- fnd_api.g_ret_sts_unexp_error;
359 -- x_msg_count
360 -- if there is one or more errors, the number of error messages
361 -- in the buffer
362 -- x_msg_data
366 PROCEDURE LPN_Label
363 -- if there is one and only one error, the error message
364 -- (See fnd_api package for more details about the above output parameters)
365
367 ( p_api_version IN NUMBER ,
368 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
369 p_commit IN VARCHAR2 := fnd_api.g_false ,
370 x_return_status OUT VARCHAR2 ,
371 x_msg_count OUT NUMBER ,
372 x_msg_data OUT VARCHAR2 ,
373 p_lpn_fr IN VARCHAR2 ,
374 p_lpn_to IN VARCHAR2 ,
375 p_customer_id IN NUMBER ,
376 p_ship_to_loc_id IN NUMBER ,
377 p_include_contents IN VARCHAR2 ,
378 p_no_of_copies IN NUMBER
379 );
380
381 /*---------------------------------------------------------------------*/
382 -- Name
383 -- PROCEDURE Shipping Label
384 /* --------------------------------------------------------------------*/
385 --
386 -- Purpose
387 -- Create XML File for Shipping Label
388 --
389 -- Input Parameters
390 -- p_api_version
391 -- API version number (current version is 1.0)
392 -- p_init_msg_list (optional, default FND_API.G_FALSE)
393 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
394 -- if set to FND_API.G_TRUE
395 -- initialize error message list
396 -- if set to FND_API.G_FALSE - not initialize error
397 -- message list
398 -- p_commit (optional, default FND_API.G_FALSE)
399 -- whether or not to commit the changes to database
400 -- p_organization_id Organization Id - Required Value
401 -- p_Move_Order_Number Move Order Number
402 -- p_Zone_From Zone Range From
403 -- p_Zone_To Zone Range To
404 -- p_Location_fr Location Range From
405 -- (only Segment Values are passed)
406 -- p_Location_to Location Range To
407 -- (only Segment Values are passed)
408 -- p_Shipment Number Shipment Number
409 -- p_Delivery_id Delivery Id
410 -- p_Delivery_line_id Delivery Line Id
411 -- p_Pslip_no Pick Slip Number
412 -- p_no_of_copies Number of copies of dupliate label
413 --
414 --
415 -- Output Parameters
416 -- x_return_status
417 -- if the pick release process succeeds, the value is
418 -- fnd_api.g_ret_sts_success;
419 -- if there is an expected error, the value is
420 -- fnd_api.g_ret_sts_error;
421 -- if there is an unexpected error, the value is
422 -- fnd_api.g_ret_sts_unexp_error;
423 -- x_msg_count
424 -- if there is one or more errors, the number of error messages
425 -- in the buffer
426 -- x_msg_data
427 -- if there is one and only one error, the error message
428 -- (See fnd_api package for more details about the above output parameters)
429
430 PROCEDURE Shipping_Label
431 ( p_api_version IN NUMBER ,
432 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
433 p_commit IN VARCHAR2 := fnd_api.g_false ,
434 x_return_status OUT VARCHAR2 ,
435 x_msg_count OUT NUMBER ,
436 x_msg_data OUT VARCHAR2 ,
437 p_organization_id IN NUMBER ,
438 p_zone_fr IN VARCHAR2 := NULL ,
439 p_zone_to IN VARCHAR2 := NULL ,
440 p_location_fr IN VARCHAR2 := NULL ,
441 p_location_to IN VARCHAR2 := NULL ,
442 p_delivery_id IN NUMBER := NULL ,
443 p_shipment_number IN VARCHAR2 := NULL ,
444 p_delivery_line_id IN NUMBER := NULL ,
445 p_pslip_number IN VARCHAR2 := NULL ,
446 p_no_of_copies IN NUMBER
447 );
448 END WMS_Label_PUB;