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.WMS_LABEL_PUB dependencies on FND_API

Line 14: -- p_init_msg_list (optional, default FND_API.G_FALSE)

10: --
11: -- Input Parameters
12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error

Line 15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

11: -- Input Parameters
12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list

Line 16: -- if set to FND_API.G_TRUE

12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)

Line 18: -- if set to FND_API.G_FALSE - not initialize error

14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)
21: -- whether or not to commit the changes to database
22: -- p_organization_id Organization Id - Required Value

Line 20: -- p_commit (optional, default FND_API.G_FALSE)

16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)
21: -- whether or not to commit the changes to database
22: -- p_organization_id Organization Id - Required Value
23: -- p_Zone_From Zone Range From
24: -- p_Zone_To Zone Range To

Line 35: -- fnd_api.g_ret_sts_success;

31: --
32: -- Output Parameters
33: -- x_return_status
34: -- if the pick release process succeeds, the value is
35: -- fnd_api.g_ret_sts_success;
36: -- if there is an expected error, the value is
37: -- fnd_api.g_ret_sts_error;
38: -- if there is an unexpected error, the value is
39: -- fnd_api.g_ret_sts_unexp_error;

Line 37: -- fnd_api.g_ret_sts_error;

33: -- x_return_status
34: -- if the pick release process succeeds, the value is
35: -- fnd_api.g_ret_sts_success;
36: -- if there is an expected error, the value is
37: -- fnd_api.g_ret_sts_error;
38: -- if there is an unexpected error, the value is
39: -- fnd_api.g_ret_sts_unexp_error;
40: -- x_msg_count
41: -- if there is one or more errors, the number of error messages

Line 39: -- fnd_api.g_ret_sts_unexp_error;

35: -- fnd_api.g_ret_sts_success;
36: -- if there is an expected error, the value is
37: -- fnd_api.g_ret_sts_error;
38: -- if there is an unexpected error, the value is
39: -- fnd_api.g_ret_sts_unexp_error;
40: -- x_msg_count
41: -- if there is one or more errors, the number of error messages
42: -- in the buffer
43: -- x_msg_data

Line 45: -- (See fnd_api package for more details about the above output parameters)

41: -- if there is one or more errors, the number of error messages
42: -- in the buffer
43: -- x_msg_data
44: -- if there is one and only one error, the error message
45: -- (See fnd_api package for more details about the above output parameters)
46:
47: PROCEDURE Location_Label
48: ( p_api_version IN NUMBER ,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

45: -- (See fnd_api package for more details about the above output parameters)
46:
47: PROCEDURE Location_Label
48: ( p_api_version IN NUMBER ,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
50: p_commit IN VARCHAR2 := fnd_api.g_false ,
51: x_return_status OUT VARCHAR2 ,
52: x_msg_count OUT NUMBER ,
53: x_msg_data OUT VARCHAR2 ,

Line 50: p_commit IN VARCHAR2 := fnd_api.g_false ,

46:
47: PROCEDURE Location_Label
48: ( p_api_version IN NUMBER ,
49: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
50: p_commit IN VARCHAR2 := fnd_api.g_false ,
51: x_return_status OUT VARCHAR2 ,
52: x_msg_count OUT NUMBER ,
53: x_msg_data OUT VARCHAR2 ,
54: p_organization_id IN NUMBER ,

Line 55: p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,

51: x_return_status OUT VARCHAR2 ,
52: x_msg_count OUT NUMBER ,
53: x_msg_data OUT VARCHAR2 ,
54: p_organization_id IN NUMBER ,
55: p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,
56: p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,
57: p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,
58: p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,
59: p_no_of_copies IN NUMBER :=1

Line 56: p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,

52: x_msg_count OUT NUMBER ,
53: x_msg_data OUT VARCHAR2 ,
54: p_organization_id IN NUMBER ,
55: p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,
56: p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,
57: p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,
58: p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,
59: p_no_of_copies IN NUMBER :=1
60: ) IS

Line 57: p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,

53: x_msg_data OUT VARCHAR2 ,
54: p_organization_id IN NUMBER ,
55: p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,
56: p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,
57: p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,
58: p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,
59: p_no_of_copies IN NUMBER :=1
60: ) IS
61: CURSOR loc_cursor IS

Line 58: p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,

54: p_organization_id IN NUMBER ,
55: p_zone_fr IN VARCHAR2 := fnd_api.g_miss_char ,
56: p_zone_to IN VARCHAR2 := fnd_api.g_miss_char ,
57: p_location_fr IN VARCHAR2 := fnd_api.g_miss_char ,
58: p_location_to IN VARCHAR2 := fnd_api.g_miss_char ,
59: p_no_of_copies IN NUMBER :=1
60: ) IS
61: CURSOR loc_cursor IS
62: select inventory_location_id

Line 130: x_return_status := fnd_api.g_ret_sts_success;

126: WMS_CLABEL.writeLabel(2); -- This call writes the variables of both the header and the lines.
127: END LOOP;
128: WMS_CLABEL.closeLabelFile;
129: --dbms_output.put_line('Total records in the label '||to_char(l_rec_count));
130: x_return_status := fnd_api.g_ret_sts_success;
131: exception
132: when others then
133: x_return_status := 'E';
134: --dbms_output.put_line('Invalid Path:'||sqlcode||' '||sqlerrm);

Line 147: -- p_init_msg_list (optional, default FND_API.G_FALSE)

143: --
144: -- Input Parameters
145: -- p_api_version
146: -- API version number (current version is 1.0)
147: -- p_init_msg_list (optional, default FND_API.G_FALSE)
148: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
149: -- if set to FND_API.G_TRUE
150: -- initialize error message list
151: -- if set to FND_API.G_FALSE - not initialize error

Line 148: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

144: -- Input Parameters
145: -- p_api_version
146: -- API version number (current version is 1.0)
147: -- p_init_msg_list (optional, default FND_API.G_FALSE)
148: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
149: -- if set to FND_API.G_TRUE
150: -- initialize error message list
151: -- if set to FND_API.G_FALSE - not initialize error
152: -- message list

Line 149: -- if set to FND_API.G_TRUE

145: -- p_api_version
146: -- API version number (current version is 1.0)
147: -- p_init_msg_list (optional, default FND_API.G_FALSE)
148: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
149: -- if set to FND_API.G_TRUE
150: -- initialize error message list
151: -- if set to FND_API.G_FALSE - not initialize error
152: -- message list
153: -- p_commit (optional, default FND_API.G_FALSE)

Line 151: -- if set to FND_API.G_FALSE - not initialize error

147: -- p_init_msg_list (optional, default FND_API.G_FALSE)
148: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
149: -- if set to FND_API.G_TRUE
150: -- initialize error message list
151: -- if set to FND_API.G_FALSE - not initialize error
152: -- message list
153: -- p_commit (optional, default FND_API.G_FALSE)
154: -- whether or not to commit the changes to database
155: -- p_organization_id Organization Id - Required Value

Line 153: -- p_commit (optional, default FND_API.G_FALSE)

149: -- if set to FND_API.G_TRUE
150: -- initialize error message list
151: -- if set to FND_API.G_FALSE - not initialize error
152: -- message list
153: -- p_commit (optional, default FND_API.G_FALSE)
154: -- whether or not to commit the changes to database
155: -- p_organization_id Organization Id - Required Value
156: -- p_Zone_From Zone Range From
157: -- p_Zone_To Zone Range To

Line 172: -- fnd_api.g_ret_sts_success;

168: --
169: -- Output Parameters
170: -- x_return_status
171: -- if the pick release process succeeds, the value is
172: -- fnd_api.g_ret_sts_success;
173: -- if there is an expected error, the value is
174: -- fnd_api.g_ret_sts_error;
175: -- if there is an unexpected error, the value is
176: -- fnd_api.g_ret_sts_unexp_error;

Line 174: -- fnd_api.g_ret_sts_error;

170: -- x_return_status
171: -- if the pick release process succeeds, the value is
172: -- fnd_api.g_ret_sts_success;
173: -- if there is an expected error, the value is
174: -- fnd_api.g_ret_sts_error;
175: -- if there is an unexpected error, the value is
176: -- fnd_api.g_ret_sts_unexp_error;
177: -- x_msg_count
178: -- if there is one or more errors, the number of error messages

Line 176: -- fnd_api.g_ret_sts_unexp_error;

172: -- fnd_api.g_ret_sts_success;
173: -- if there is an expected error, the value is
174: -- fnd_api.g_ret_sts_error;
175: -- if there is an unexpected error, the value is
176: -- fnd_api.g_ret_sts_unexp_error;
177: -- x_msg_count
178: -- if there is one or more errors, the number of error messages
179: -- in the buffer
180: -- x_msg_data

Line 182: -- (See fnd_api package for more details about the above output parameters)

178: -- if there is one or more errors, the number of error messages
179: -- in the buffer
180: -- x_msg_data
181: -- if there is one and only one error, the error message
182: -- (See fnd_api package for more details about the above output parameters)
183:
184: PROCEDURE Item_Label
185: ( p_api_version IN NUMBER ,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

182: -- (See fnd_api package for more details about the above output parameters)
183:
184: PROCEDURE Item_Label
185: ( p_api_version IN NUMBER ,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
187: p_commit IN VARCHAR2 := fnd_api.g_false ,
188: x_return_status OUT VARCHAR2 ,
189: x_msg_count OUT NUMBER ,
190: x_msg_data OUT VARCHAR2 ,

Line 187: p_commit IN VARCHAR2 := fnd_api.g_false ,

183:
184: PROCEDURE Item_Label
185: ( p_api_version IN NUMBER ,
186: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
187: p_commit IN VARCHAR2 := fnd_api.g_false ,
188: x_return_status OUT VARCHAR2 ,
189: x_msg_count OUT NUMBER ,
190: x_msg_data OUT VARCHAR2 ,
191: p_organization_id IN NUMBER ,

Line 214: -- p_init_msg_list (optional, default FND_API.G_FALSE)

210: --
211: -- Input Parameters
212: -- p_api_version
213: -- API version number (current version is 1.0)
214: -- p_init_msg_list (optional, default FND_API.G_FALSE)
215: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
216: -- if set to FND_API.G_TRUE
217: -- initialize error message list
218: -- if set to FND_API.G_FALSE - not initialize error

Line 215: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

211: -- Input Parameters
212: -- p_api_version
213: -- API version number (current version is 1.0)
214: -- p_init_msg_list (optional, default FND_API.G_FALSE)
215: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
216: -- if set to FND_API.G_TRUE
217: -- initialize error message list
218: -- if set to FND_API.G_FALSE - not initialize error
219: -- message list

Line 216: -- if set to FND_API.G_TRUE

212: -- p_api_version
213: -- API version number (current version is 1.0)
214: -- p_init_msg_list (optional, default FND_API.G_FALSE)
215: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
216: -- if set to FND_API.G_TRUE
217: -- initialize error message list
218: -- if set to FND_API.G_FALSE - not initialize error
219: -- message list
220: -- p_commit (optional, default FND_API.G_FALSE)

Line 218: -- if set to FND_API.G_FALSE - not initialize error

214: -- p_init_msg_list (optional, default FND_API.G_FALSE)
215: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
216: -- if set to FND_API.G_TRUE
217: -- initialize error message list
218: -- if set to FND_API.G_FALSE - not initialize error
219: -- message list
220: -- p_commit (optional, default FND_API.G_FALSE)
221: -- whether or not to commit the changes to database
222: -- p_organization_id Organization Id - Required Value

Line 220: -- p_commit (optional, default FND_API.G_FALSE)

216: -- if set to FND_API.G_TRUE
217: -- initialize error message list
218: -- if set to FND_API.G_FALSE - not initialize error
219: -- message list
220: -- p_commit (optional, default FND_API.G_FALSE)
221: -- whether or not to commit the changes to database
222: -- p_organization_id Organization Id - Required Value
223: -- p_Move_Order_Number Move Order Number
224: -- p_Zone_From Zone Range From

Line 238: -- fnd_api.g_ret_sts_success;

234: --
235: -- Output Parameters
236: -- x_return_status
237: -- if the pick release process succeeds, the value is
238: -- fnd_api.g_ret_sts_success;
239: -- if there is an expected error, the value is
240: -- fnd_api.g_ret_sts_error;
241: -- if there is an unexpected error, the value is
242: -- fnd_api.g_ret_sts_unexp_error;

Line 240: -- fnd_api.g_ret_sts_error;

236: -- x_return_status
237: -- if the pick release process succeeds, the value is
238: -- fnd_api.g_ret_sts_success;
239: -- if there is an expected error, the value is
240: -- fnd_api.g_ret_sts_error;
241: -- if there is an unexpected error, the value is
242: -- fnd_api.g_ret_sts_unexp_error;
243: -- x_msg_count
244: -- if there is one or more errors, the number of error messages

Line 242: -- fnd_api.g_ret_sts_unexp_error;

238: -- fnd_api.g_ret_sts_success;
239: -- if there is an expected error, the value is
240: -- fnd_api.g_ret_sts_error;
241: -- if there is an unexpected error, the value is
242: -- fnd_api.g_ret_sts_unexp_error;
243: -- x_msg_count
244: -- if there is one or more errors, the number of error messages
245: -- in the buffer
246: -- x_msg_data

Line 248: -- (See fnd_api package for more details about the above output parameters)

244: -- if there is one or more errors, the number of error messages
245: -- in the buffer
246: -- x_msg_data
247: -- if there is one and only one error, the error message
248: -- (See fnd_api package for more details about the above output parameters)
249:
250: PROCEDURE Material_Movement_Label
251: ( p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

248: -- (See fnd_api package for more details about the above output parameters)
249:
250: PROCEDURE Material_Movement_Label
251: ( p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
253: p_commit IN VARCHAR2 := fnd_api.g_false ,
254: x_return_status OUT VARCHAR2 ,
255: x_msg_count OUT NUMBER ,
256: x_msg_data OUT VARCHAR2 ,

Line 253: p_commit IN VARCHAR2 := fnd_api.g_false ,

249:
250: PROCEDURE Material_Movement_Label
251: ( p_api_version IN NUMBER ,
252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
253: p_commit IN VARCHAR2 := fnd_api.g_false ,
254: x_return_status OUT VARCHAR2 ,
255: x_msg_count OUT NUMBER ,
256: x_msg_data OUT VARCHAR2 ,
257: p_organization_id IN NUMBER ,

Line 280: -- p_init_msg_list (optional, default FND_API.G_FALSE)

276: --
277: -- Input Parameters
278: -- p_api_version
279: -- API version number (current version is 1.0)
280: -- p_init_msg_list (optional, default FND_API.G_FALSE)
281: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
282: -- if set to FND_API.G_TRUE
283: -- initialize error message list
284: -- if set to FND_API.G_FALSE - not initialize error

Line 281: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

277: -- Input Parameters
278: -- p_api_version
279: -- API version number (current version is 1.0)
280: -- p_init_msg_list (optional, default FND_API.G_FALSE)
281: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
282: -- if set to FND_API.G_TRUE
283: -- initialize error message list
284: -- if set to FND_API.G_FALSE - not initialize error
285: -- message list

Line 282: -- if set to FND_API.G_TRUE

278: -- p_api_version
279: -- API version number (current version is 1.0)
280: -- p_init_msg_list (optional, default FND_API.G_FALSE)
281: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
282: -- if set to FND_API.G_TRUE
283: -- initialize error message list
284: -- if set to FND_API.G_FALSE - not initialize error
285: -- message list
286: -- p_commit (optional, default FND_API.G_FALSE)

Line 284: -- if set to FND_API.G_FALSE - not initialize error

280: -- p_init_msg_list (optional, default FND_API.G_FALSE)
281: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
282: -- if set to FND_API.G_TRUE
283: -- initialize error message list
284: -- if set to FND_API.G_FALSE - not initialize error
285: -- message list
286: -- p_commit (optional, default FND_API.G_FALSE)
287: -- whether or not to commit the changes to database
288: -- p_organization_id Organization Id - Required Value

Line 286: -- p_commit (optional, default FND_API.G_FALSE)

282: -- if set to FND_API.G_TRUE
283: -- initialize error message list
284: -- if set to FND_API.G_FALSE - not initialize error
285: -- message list
286: -- p_commit (optional, default FND_API.G_FALSE)
287: -- whether or not to commit the changes to database
288: -- p_organization_id Organization Id - Required Value
289: -- p_Move_Order_Number Move Order Number
290: -- p_Zone_From Zone Range From

Line 306: -- fnd_api.g_ret_sts_success;

302: --
303: -- Output Parameters
304: -- x_return_status
305: -- if the pick release process succeeds, the value is
306: -- fnd_api.g_ret_sts_success;
307: -- if there is an expected error, the value is
308: -- fnd_api.g_ret_sts_error;
309: -- if there is an unexpected error, the value is
310: -- fnd_api.g_ret_sts_unexp_error;

Line 308: -- fnd_api.g_ret_sts_error;

304: -- x_return_status
305: -- if the pick release process succeeds, the value is
306: -- fnd_api.g_ret_sts_success;
307: -- if there is an expected error, the value is
308: -- fnd_api.g_ret_sts_error;
309: -- if there is an unexpected error, the value is
310: -- fnd_api.g_ret_sts_unexp_error;
311: -- x_msg_count
312: -- if there is one or more errors, the number of error messages

Line 310: -- fnd_api.g_ret_sts_unexp_error;

306: -- fnd_api.g_ret_sts_success;
307: -- if there is an expected error, the value is
308: -- fnd_api.g_ret_sts_error;
309: -- if there is an unexpected error, the value is
310: -- fnd_api.g_ret_sts_unexp_error;
311: -- x_msg_count
312: -- if there is one or more errors, the number of error messages
313: -- in the buffer
314: -- x_msg_data

Line 316: -- (See fnd_api package for more details about the above output parameters)

312: -- if there is one or more errors, the number of error messages
313: -- in the buffer
314: -- x_msg_data
315: -- if there is one and only one error, the error message
316: -- (See fnd_api package for more details about the above output parameters)
317:
318: PROCEDURE Palette_Label
319: ( p_api_version IN NUMBER ,
320: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 320: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

316: -- (See fnd_api package for more details about the above output parameters)
317:
318: PROCEDURE Palette_Label
319: ( p_api_version IN NUMBER ,
320: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
321: p_commit IN VARCHAR2 := fnd_api.g_false ,
322: x_return_status OUT VARCHAR2 ,
323: x_msg_count OUT NUMBER ,
324: x_msg_data OUT VARCHAR2 ,

Line 321: p_commit IN VARCHAR2 := fnd_api.g_false ,

317:
318: PROCEDURE Palette_Label
319: ( p_api_version IN NUMBER ,
320: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
321: p_commit IN VARCHAR2 := fnd_api.g_false ,
322: x_return_status OUT VARCHAR2 ,
323: x_msg_count OUT NUMBER ,
324: x_msg_data OUT VARCHAR2 ,
325: p_organization_id IN NUMBER ,

Line 350: -- p_init_msg_list (optional, default FND_API.G_FALSE)

346: --
347: -- Input Parameters
348: -- p_api_version
349: -- API version number (current version is 1.0)
350: -- p_init_msg_list (optional, default FND_API.G_FALSE)
351: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
352: -- if set to FND_API.G_TRUE
353: -- initialize error message list
354: -- if set to FND_API.G_FALSE - not initialize error

Line 351: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

347: -- Input Parameters
348: -- p_api_version
349: -- API version number (current version is 1.0)
350: -- p_init_msg_list (optional, default FND_API.G_FALSE)
351: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
352: -- if set to FND_API.G_TRUE
353: -- initialize error message list
354: -- if set to FND_API.G_FALSE - not initialize error
355: -- message list

Line 352: -- if set to FND_API.G_TRUE

348: -- p_api_version
349: -- API version number (current version is 1.0)
350: -- p_init_msg_list (optional, default FND_API.G_FALSE)
351: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
352: -- if set to FND_API.G_TRUE
353: -- initialize error message list
354: -- if set to FND_API.G_FALSE - not initialize error
355: -- message list
356: -- p_commit (optional, default FND_API.G_FALSE)

Line 354: -- if set to FND_API.G_FALSE - not initialize error

350: -- p_init_msg_list (optional, default FND_API.G_FALSE)
351: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
352: -- if set to FND_API.G_TRUE
353: -- initialize error message list
354: -- if set to FND_API.G_FALSE - not initialize error
355: -- message list
356: -- p_commit (optional, default FND_API.G_FALSE)
357: -- whether or not to commit the changes to database
358: -- p_kanban_card_id_fr Kanban Card Id Range from

Line 356: -- p_commit (optional, default FND_API.G_FALSE)

352: -- if set to FND_API.G_TRUE
353: -- initialize error message list
354: -- if set to FND_API.G_FALSE - not initialize error
355: -- message list
356: -- p_commit (optional, default FND_API.G_FALSE)
357: -- whether or not to commit the changes to database
358: -- p_kanban_card_id_fr Kanban Card Id Range from
359: -- p_kanban_card_id_to Kanban Card Id Range To
360: -- p_no_of_copies No of copies of duplicate labels

Line 366: -- fnd_api.g_ret_sts_success;

362: --
363: -- Output Parameters
364: -- x_return_status
365: -- if the pick release process succeeds, the value is
366: -- fnd_api.g_ret_sts_success;
367: -- if there is an expected error, the value is
368: -- fnd_api.g_ret_sts_error;
369: -- if there is an unexpected error, the value is
370: -- fnd_api.g_ret_sts_unexp_error;

Line 368: -- fnd_api.g_ret_sts_error;

364: -- x_return_status
365: -- if the pick release process succeeds, the value is
366: -- fnd_api.g_ret_sts_success;
367: -- if there is an expected error, the value is
368: -- fnd_api.g_ret_sts_error;
369: -- if there is an unexpected error, the value is
370: -- fnd_api.g_ret_sts_unexp_error;
371: -- x_msg_count
372: -- if there is one or more errors, the number of error messages

Line 370: -- fnd_api.g_ret_sts_unexp_error;

366: -- fnd_api.g_ret_sts_success;
367: -- if there is an expected error, the value is
368: -- fnd_api.g_ret_sts_error;
369: -- if there is an unexpected error, the value is
370: -- fnd_api.g_ret_sts_unexp_error;
371: -- x_msg_count
372: -- if there is one or more errors, the number of error messages
373: -- in the buffer
374: -- x_msg_data

Line 376: -- (See fnd_api package for more details about the above output parameters)

372: -- if there is one or more errors, the number of error messages
373: -- in the buffer
374: -- x_msg_data
375: -- if there is one and only one error, the error message
376: -- (See fnd_api package for more details about the above output parameters)
377:
378: PROCEDURE Kanban_Card_Label
379: ( p_api_version IN NUMBER ,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 380: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

376: -- (See fnd_api package for more details about the above output parameters)
377:
378: PROCEDURE Kanban_Card_Label
379: ( p_api_version IN NUMBER ,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
381: p_commit IN VARCHAR2 := fnd_api.g_false ,
382: x_return_status OUT VARCHAR2 ,
383: x_msg_count OUT NUMBER ,
384: x_msg_data OUT VARCHAR2 ,

Line 381: p_commit IN VARCHAR2 := fnd_api.g_false ,

377:
378: PROCEDURE Kanban_Card_Label
379: ( p_api_version IN NUMBER ,
380: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
381: p_commit IN VARCHAR2 := fnd_api.g_false ,
382: x_return_status OUT VARCHAR2 ,
383: x_msg_count OUT NUMBER ,
384: x_msg_data OUT VARCHAR2 ,
385: p_kanban_card_id_fr IN NUMBER ,

Line 403: -- p_init_msg_list (optional, default FND_API.G_FALSE)

399: --
400: -- Input Parameters
401: -- p_api_version
402: -- API version number (current version is 1.0)
403: -- p_init_msg_list (optional, default FND_API.G_FALSE)
404: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
405: -- if set to FND_API.G_TRUE
406: -- initialize error message list
407: -- if set to FND_API.G_FALSE - not initialize error

Line 404: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

400: -- Input Parameters
401: -- p_api_version
402: -- API version number (current version is 1.0)
403: -- p_init_msg_list (optional, default FND_API.G_FALSE)
404: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
405: -- if set to FND_API.G_TRUE
406: -- initialize error message list
407: -- if set to FND_API.G_FALSE - not initialize error
408: -- message list

Line 405: -- if set to FND_API.G_TRUE

401: -- p_api_version
402: -- API version number (current version is 1.0)
403: -- p_init_msg_list (optional, default FND_API.G_FALSE)
404: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
405: -- if set to FND_API.G_TRUE
406: -- initialize error message list
407: -- if set to FND_API.G_FALSE - not initialize error
408: -- message list
409: -- p_commit (optional, default FND_API.G_FALSE)

Line 407: -- if set to FND_API.G_FALSE - not initialize error

403: -- p_init_msg_list (optional, default FND_API.G_FALSE)
404: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
405: -- if set to FND_API.G_TRUE
406: -- initialize error message list
407: -- if set to FND_API.G_FALSE - not initialize error
408: -- message list
409: -- p_commit (optional, default FND_API.G_FALSE)
410: -- whether or not to commit the changes to database
411: -- p_lpn_fr LPN Range from

Line 409: -- p_commit (optional, default FND_API.G_FALSE)

405: -- if set to FND_API.G_TRUE
406: -- initialize error message list
407: -- if set to FND_API.G_FALSE - not initialize error
408: -- message list
409: -- p_commit (optional, default FND_API.G_FALSE)
410: -- whether or not to commit the changes to database
411: -- p_lpn_fr LPN Range from
412: -- p_lpn_to LPN Range To
413: -- p_customer_id Customer ID

Line 422: -- fnd_api.g_ret_sts_success;

418: --
419: -- Output Parameters
420: -- x_return_status
421: -- if the pick release process succeeds, the value is
422: -- fnd_api.g_ret_sts_success;
423: -- if there is an expected error, the value is
424: -- fnd_api.g_ret_sts_error;
425: -- if there is an unexpected error, the value is
426: -- fnd_api.g_ret_sts_unexp_error;

Line 424: -- fnd_api.g_ret_sts_error;

420: -- x_return_status
421: -- if the pick release process succeeds, the value is
422: -- fnd_api.g_ret_sts_success;
423: -- if there is an expected error, the value is
424: -- fnd_api.g_ret_sts_error;
425: -- if there is an unexpected error, the value is
426: -- fnd_api.g_ret_sts_unexp_error;
427: -- x_msg_count
428: -- if there is one or more errors, the number of error messages

Line 426: -- fnd_api.g_ret_sts_unexp_error;

422: -- fnd_api.g_ret_sts_success;
423: -- if there is an expected error, the value is
424: -- fnd_api.g_ret_sts_error;
425: -- if there is an unexpected error, the value is
426: -- fnd_api.g_ret_sts_unexp_error;
427: -- x_msg_count
428: -- if there is one or more errors, the number of error messages
429: -- in the buffer
430: -- x_msg_data

Line 432: -- (See fnd_api package for more details about the above output parameters)

428: -- if there is one or more errors, the number of error messages
429: -- in the buffer
430: -- x_msg_data
431: -- if there is one and only one error, the error message
432: -- (See fnd_api package for more details about the above output parameters)
433:
434: PROCEDURE LPN_Label
435: ( p_api_version IN NUMBER ,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

432: -- (See fnd_api package for more details about the above output parameters)
433:
434: PROCEDURE LPN_Label
435: ( p_api_version IN NUMBER ,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
437: p_commit IN VARCHAR2 := fnd_api.g_false ,
438: x_return_status OUT VARCHAR2 ,
439: x_msg_count OUT NUMBER ,
440: x_msg_data OUT VARCHAR2 ,

Line 437: p_commit IN VARCHAR2 := fnd_api.g_false ,

433:
434: PROCEDURE LPN_Label
435: ( p_api_version IN NUMBER ,
436: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
437: p_commit IN VARCHAR2 := fnd_api.g_false ,
438: x_return_status OUT VARCHAR2 ,
439: x_msg_count OUT NUMBER ,
440: x_msg_data OUT VARCHAR2 ,
441: p_lpn_fr IN VARCHAR2 ,

Line 463: -- p_init_msg_list (optional, default FND_API.G_FALSE)

459: --
460: -- Input Parameters
461: -- p_api_version
462: -- API version number (current version is 1.0)
463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
465: -- if set to FND_API.G_TRUE
466: -- initialize error message list
467: -- if set to FND_API.G_FALSE - not initialize error

Line 464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

460: -- Input Parameters
461: -- p_api_version
462: -- API version number (current version is 1.0)
463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
465: -- if set to FND_API.G_TRUE
466: -- initialize error message list
467: -- if set to FND_API.G_FALSE - not initialize error
468: -- message list

Line 465: -- if set to FND_API.G_TRUE

461: -- p_api_version
462: -- API version number (current version is 1.0)
463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
465: -- if set to FND_API.G_TRUE
466: -- initialize error message list
467: -- if set to FND_API.G_FALSE - not initialize error
468: -- message list
469: -- p_commit (optional, default FND_API.G_FALSE)

Line 467: -- if set to FND_API.G_FALSE - not initialize error

463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
465: -- if set to FND_API.G_TRUE
466: -- initialize error message list
467: -- if set to FND_API.G_FALSE - not initialize error
468: -- message list
469: -- p_commit (optional, default FND_API.G_FALSE)
470: -- whether or not to commit the changes to database
471: -- p_organization_id Organization Id - Required Value

Line 469: -- p_commit (optional, default FND_API.G_FALSE)

465: -- if set to FND_API.G_TRUE
466: -- initialize error message list
467: -- if set to FND_API.G_FALSE - not initialize error
468: -- message list
469: -- p_commit (optional, default FND_API.G_FALSE)
470: -- whether or not to commit the changes to database
471: -- p_organization_id Organization Id - Required Value
472: -- p_Move_Order_Number Move Order Number
473: -- p_Zone_From Zone Range From

Line 489: -- fnd_api.g_ret_sts_success;

485: --
486: -- Output Parameters
487: -- x_return_status
488: -- if the pick release process succeeds, the value is
489: -- fnd_api.g_ret_sts_success;
490: -- if there is an expected error, the value is
491: -- fnd_api.g_ret_sts_error;
492: -- if there is an unexpected error, the value is
493: -- fnd_api.g_ret_sts_unexp_error;

Line 491: -- fnd_api.g_ret_sts_error;

487: -- x_return_status
488: -- if the pick release process succeeds, the value is
489: -- fnd_api.g_ret_sts_success;
490: -- if there is an expected error, the value is
491: -- fnd_api.g_ret_sts_error;
492: -- if there is an unexpected error, the value is
493: -- fnd_api.g_ret_sts_unexp_error;
494: -- x_msg_count
495: -- if there is one or more errors, the number of error messages

Line 493: -- fnd_api.g_ret_sts_unexp_error;

489: -- fnd_api.g_ret_sts_success;
490: -- if there is an expected error, the value is
491: -- fnd_api.g_ret_sts_error;
492: -- if there is an unexpected error, the value is
493: -- fnd_api.g_ret_sts_unexp_error;
494: -- x_msg_count
495: -- if there is one or more errors, the number of error messages
496: -- in the buffer
497: -- x_msg_data

Line 499: -- (See fnd_api package for more details about the above output parameters)

495: -- if there is one or more errors, the number of error messages
496: -- in the buffer
497: -- x_msg_data
498: -- if there is one and only one error, the error message
499: -- (See fnd_api package for more details about the above output parameters)
500:
501: PROCEDURE Shipping_Label
502: ( p_api_version IN NUMBER ,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

Line 503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

499: -- (See fnd_api package for more details about the above output parameters)
500:
501: PROCEDURE Shipping_Label
502: ( p_api_version IN NUMBER ,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
504: p_commit IN VARCHAR2 := fnd_api.g_false ,
505: x_return_status OUT VARCHAR2 ,
506: x_msg_count OUT NUMBER ,
507: x_msg_data OUT VARCHAR2 ,

Line 504: p_commit IN VARCHAR2 := fnd_api.g_false ,

500:
501: PROCEDURE Shipping_Label
502: ( p_api_version IN NUMBER ,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
504: p_commit IN VARCHAR2 := fnd_api.g_false ,
505: x_return_status OUT VARCHAR2 ,
506: x_msg_count OUT NUMBER ,
507: x_msg_data OUT VARCHAR2 ,
508: p_organization_id IN NUMBER ,

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: FND_FILE.PUT_NAMES(v_log_name,v_log_name,v_log_name);
547: return v_log_name;
548: EXCEPTION
549: WHEN OTHERS then
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END Output_file_dir;
552: /*---------------------------------------------------------*/
553: END WMS_Label_PUB;