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_CONTAINER_PUB dependencies on FND_API

Line 67: * @ param p_init_msg_list default FND_API.G_FALSE) Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list

63: * This api is used to generate LPN numbers, either individually or in a sequence.
64: *
65: * @ param p_api_version API version number (current version is 1.0)
66: * @ paraminfo {@rep:required}
67: * @ param p_init_msg_list default FND_API.G_FALSE) Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
68: * @ paraminfo {@rep:required}
69: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
70: * @ paraminfo {@rep:required}
71: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL; FND_API.G_VALID_LEVEL_NONE is the other value

Line 69: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database

65: * @ param p_api_version API version number (current version is 1.0)
66: * @ paraminfo {@rep:required}
67: * @ param p_init_msg_list default FND_API.G_FALSE) Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
68: * @ paraminfo {@rep:required}
69: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
70: * @ paraminfo {@rep:required}
71: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL; FND_API.G_VALID_LEVEL_NONE is the other value
72: * @ paraminfo {@rep:required}
73: * @ param p_organization_id Organization Id

Line 71: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL; FND_API.G_VALID_LEVEL_NONE is the other value

67: * @ param p_init_msg_list default FND_API.G_FALSE) Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
68: * @ paraminfo {@rep:required}
69: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
70: * @ paraminfo {@rep:required}
71: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL; FND_API.G_VALID_LEVEL_NONE is the other value
72: * @ paraminfo {@rep:required}
73: * @ param p_organization_id Organization Id
74: * @ paraminfo {@rep:required}
75: * @ param p_container_item_id Container Item Id - Defaults to NULL

Line 115: * @ param x_return_status if the Generate_LPN API succeeds, the value is fnd_api.g_ret_sts_success; if there is an expected error, the value is fnd_api.g_ret_sts_error; if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;

111: * @ param p_total_length Specify the total length of LPN, pad with 0 numeric portion of LPN
112: * @ paraminfo {@rep:optional}
113: * @ param p_ucc_128_suffix_flag Use a UCC128 suffix on LPNs or not 'Y'/'N'
114: * @ paraminfo {@rep:optional}
115: * @ param x_return_status if the Generate_LPN API succeeds, the value is fnd_api.g_ret_sts_success; if there is an expected error, the value is fnd_api.g_ret_sts_error; if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
116: * @ paraminfo {@rep:required}
117: * @ param x_msg_count if there is one or more errors, the number of error messages in the buffer
118: * @ paraminfo {@rep:required}
119: * @ param x_msg_data if there is one and only one error, the error message

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

129: * @rep:businessevent Generate_LPN
130: */
131: PROCEDURE Generate_LPN (
132: p_api_version IN NUMBER
133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: , p_commit IN VARCHAR2 := fnd_api.g_false
135: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: , x_return_status OUT NOCOPY VARCHAR2
137: , x_msg_count OUT NOCOPY NUMBER

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

130: */
131: PROCEDURE Generate_LPN (
132: p_api_version IN NUMBER
133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: , p_commit IN VARCHAR2 := fnd_api.g_false
135: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: , x_return_status OUT NOCOPY VARCHAR2
137: , x_msg_count OUT NOCOPY NUMBER
138: , x_msg_data OUT NOCOPY VARCHAR2

Line 135: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

131: PROCEDURE Generate_LPN (
132: p_api_version IN NUMBER
133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
134: , p_commit IN VARCHAR2 := fnd_api.g_false
135: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
136: , x_return_status OUT NOCOPY VARCHAR2
137: , x_msg_count OUT NOCOPY NUMBER
138: , x_msg_data OUT NOCOPY VARCHAR2
139: , p_organization_id IN NUMBER

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

165: -- Overleaded the procedure for the WMS specific changes for LSP, bug 9087971
166:
167: PROCEDURE Generate_LPN (
168: p_api_version IN NUMBER
169: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
170: , p_commit IN VARCHAR2 := fnd_api.g_false
171: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_msg_count OUT NOCOPY NUMBER

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

166:
167: PROCEDURE Generate_LPN (
168: p_api_version IN NUMBER
169: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
170: , p_commit IN VARCHAR2 := fnd_api.g_false
171: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_msg_count OUT NOCOPY NUMBER
174: , x_msg_data OUT NOCOPY VARCHAR2

Line 171: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

167: PROCEDURE Generate_LPN (
168: p_api_version IN NUMBER
169: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
170: , p_commit IN VARCHAR2 := fnd_api.g_false
171: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_msg_count OUT NOCOPY NUMBER
174: , x_msg_data OUT NOCOPY VARCHAR2
175: , 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_validation_level (optional), determines if full validation or

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_validation_level (optional), determines if full validation or
223: -- no validation will be performed
224: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 224: -- defaults to FND_API.G_VALID_LEVEL_FULL

220: -- p_commit (optional, default FND_API.G_FALSE)
221: -- whether or not to commit the changes to database
222: -- p_validation_level (optional), determines if full validation or
223: -- no validation will be performed
224: -- defaults to FND_API.G_VALID_LEVEL_FULL
225: -- FND_API.G_VALID_LEVEL_NONE is the other value
226: -- p_lpn_id License Plate Number Identifier - Required Value
227: -- p_container_item_id Container Item Id - Required Value
228: -- p_lot_number Lot Number - Defaults to NULL

Line 225: -- FND_API.G_VALID_LEVEL_NONE is the other value

221: -- whether or not to commit the changes to database
222: -- p_validation_level (optional), determines if full validation or
223: -- no validation will be performed
224: -- defaults to FND_API.G_VALID_LEVEL_FULL
225: -- FND_API.G_VALID_LEVEL_NONE is the other value
226: -- p_lpn_id License Plate Number Identifier - Required Value
227: -- p_container_item_id Container Item Id - Required Value
228: -- p_lot_number Lot Number - Defaults to NULL
229: -- p_revision Revision - Defaults to NULL

Line 245: -- fnd_api.g_ret_sts_success;

241: --
242: -- Output Parameters
243: -- x_return_status
244: -- if the Associate_LPN API succeeds, the value is
245: -- fnd_api.g_ret_sts_success;
246: -- if there is an expected error, the value is
247: -- fnd_api.g_ret_sts_error;
248: -- if there is an unexpected error, the value is
249: -- fnd_api.g_ret_sts_unexp_error;

Line 247: -- fnd_api.g_ret_sts_error;

243: -- x_return_status
244: -- if the Associate_LPN API succeeds, the value is
245: -- fnd_api.g_ret_sts_success;
246: -- if there is an expected error, the value is
247: -- fnd_api.g_ret_sts_error;
248: -- if there is an unexpected error, the value is
249: -- fnd_api.g_ret_sts_unexp_error;
250: -- x_msg_count
251: -- if there is one or more errors, the number of error messages

Line 249: -- fnd_api.g_ret_sts_unexp_error;

245: -- fnd_api.g_ret_sts_success;
246: -- if there is an expected error, the value is
247: -- fnd_api.g_ret_sts_error;
248: -- if there is an unexpected error, the value is
249: -- fnd_api.g_ret_sts_unexp_error;
250: -- x_msg_count
251: -- if there is one or more errors, the number of error messages
252: -- in the buffer
253: -- x_msg_data

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

259: /***********************************************************************/
260:
261: PROCEDURE Associate_LPN
262: ( p_api_version IN NUMBER ,
263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
264: p_commit IN VARCHAR2 := fnd_api.g_false ,
265: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
266: x_return_status OUT NOCOPY VARCHAR2 ,
267: x_msg_count OUT NOCOPY NUMBER ,

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

260:
261: PROCEDURE Associate_LPN
262: ( p_api_version IN NUMBER ,
263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
264: p_commit IN VARCHAR2 := fnd_api.g_false ,
265: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
266: x_return_status OUT NOCOPY VARCHAR2 ,
267: x_msg_count OUT NOCOPY NUMBER ,
268: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 265: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,

261: PROCEDURE Associate_LPN
262: ( p_api_version IN NUMBER ,
263: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
264: p_commit IN VARCHAR2 := fnd_api.g_false ,
265: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
266: x_return_status OUT NOCOPY VARCHAR2 ,
267: x_msg_count OUT NOCOPY NUMBER ,
268: x_msg_data OUT NOCOPY VARCHAR2 ,
269: p_lpn_id IN NUMBER ,

Line 291: * @ param p_init_msg_list default FND_API.G_FALSE Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list

287: * the WMS_LICENSE_PLATE_NUMBERS table returning to the caller a uniquely generated LPN_ID.
288: *
289: * @ param p_api_version API version number (current version is 1.0)
290: * @ paraminfo {@rep:required}
291: * @ param p_init_msg_list default FND_API.G_FALSE Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
292: * @ paraminfo {@rep:required}
293: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
294: * @ paraminfo {@rep:required}
295: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL FND_API.G_VALID_LEVEL_NONE is the other value

Line 293: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database

289: * @ param p_api_version API version number (current version is 1.0)
290: * @ paraminfo {@rep:required}
291: * @ param p_init_msg_list default FND_API.G_FALSE Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
292: * @ paraminfo {@rep:required}
293: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
294: * @ paraminfo {@rep:required}
295: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL FND_API.G_VALID_LEVEL_NONE is the other value
296: * @ paraminfo {@rep:required}
297: * @ param p_lpn License Plate Number Identifier - Required Value

Line 295: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL FND_API.G_VALID_LEVEL_NONE is the other value

291: * @ param p_init_msg_list default FND_API.G_FALSE Valid values: FND_API.G_FALSE or FND_API.G_TRUE. if set to FND_API.G_TRUE initialize error message list if set to FND_API.G_FALSE - not initialize error message list
292: * @ paraminfo {@rep:required}
293: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
294: * @ paraminfo {@rep:required}
295: * @ param p_validation_level determines if full validation or no validation will be performed defaults to FND_API.G_VALID_LEVEL_FULL FND_API.G_VALID_LEVEL_NONE is the other value
296: * @ paraminfo {@rep:required}
297: * @ param p_lpn License Plate Number Identifier - Required Value
298: * @ paraminfo {@rep:required}
299: * @ param p_organization_id Organization Id - Required Value

Line 329: * @ param x_return_status if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success; if there is an expected error, the value is fnd_api.g_ret_sts_error; if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;

325: * @ param p_source_line_id Source line ID for the source transaction
326: * @ paraminfo {@rep:optional}
327: * @ param p_source_line_detail_id Source line detail ID for the source transaction
328: * @ paraminfo {@rep:optional}
329: * @ param x_return_status if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success; if there is an expected error, the value is fnd_api.g_ret_sts_error; if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
330: * @ paraminfo {@rep:required}
331: * @ param x_msg_count if there is one or more errors, the number of error messages in the buffer
332: * @ paraminfo {@rep:required}
333: * @ param x_msg_data if there is one and only one error, the error message

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

340: * @rep:businessevent Create_LPN
341: */
342: PROCEDURE Create_LPN (
343: p_api_version IN NUMBER
344: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
345: , p_commit IN VARCHAR2 := fnd_api.g_false
346: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
347: , x_return_status OUT NOCOPY VARCHAR2
348: , x_msg_count OUT NOCOPY NUMBER

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

341: */
342: PROCEDURE Create_LPN (
343: p_api_version IN NUMBER
344: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
345: , p_commit IN VARCHAR2 := fnd_api.g_false
346: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
347: , x_return_status OUT NOCOPY VARCHAR2
348: , x_msg_count OUT NOCOPY NUMBER
349: , x_msg_data OUT NOCOPY VARCHAR2

Line 346: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

342: PROCEDURE Create_LPN (
343: p_api_version IN NUMBER
344: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
345: , p_commit IN VARCHAR2 := fnd_api.g_false
346: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
347: , x_return_status OUT NOCOPY VARCHAR2
348: , x_msg_count OUT NOCOPY NUMBER
349: , x_msg_data OUT NOCOPY VARCHAR2
350: , p_lpn IN VARCHAR2

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

383: --
384: -- Input Parameters
385: -- p_api_version
386: -- API version number (current version is 1.0)
387: -- p_init_msg_list (optional, default FND_API.G_FALSE)
388: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
389: -- if set to FND_API.G_TRUE
390: -- initialize error message list
391: -- if set to FND_API.G_FALSE - not initialize error

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

384: -- Input Parameters
385: -- p_api_version
386: -- API version number (current version is 1.0)
387: -- p_init_msg_list (optional, default FND_API.G_FALSE)
388: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
389: -- if set to FND_API.G_TRUE
390: -- initialize error message list
391: -- if set to FND_API.G_FALSE - not initialize error
392: -- message list

Line 389: -- if set to FND_API.G_TRUE

385: -- p_api_version
386: -- API version number (current version is 1.0)
387: -- p_init_msg_list (optional, default FND_API.G_FALSE)
388: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
389: -- if set to FND_API.G_TRUE
390: -- initialize error message list
391: -- if set to FND_API.G_FALSE - not initialize error
392: -- message list
393: -- p_commit (optional, default FND_API.G_FALSE)

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

387: -- p_init_msg_list (optional, default FND_API.G_FALSE)
388: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
389: -- if set to FND_API.G_TRUE
390: -- initialize error message list
391: -- if set to FND_API.G_FALSE - not initialize error
392: -- message list
393: -- p_commit (optional, default FND_API.G_FALSE)
394: -- whether or not to commit the changes to database
395: -- p_validation_level (optional), determines if full validation or

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

389: -- if set to FND_API.G_TRUE
390: -- initialize error message list
391: -- if set to FND_API.G_FALSE - not initialize error
392: -- message list
393: -- p_commit (optional, default FND_API.G_FALSE)
394: -- whether or not to commit the changes to database
395: -- p_validation_level (optional), determines if full validation or
396: -- no validation will be performed
397: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 397: -- defaults to FND_API.G_VALID_LEVEL_FULL

393: -- p_commit (optional, default FND_API.G_FALSE)
394: -- whether or not to commit the changes to database
395: -- p_validation_level (optional), determines if full validation or
396: -- no validation will be performed
397: -- defaults to FND_API.G_VALID_LEVEL_FULL
398: -- FND_API.G_VALID_LEVEL_NONE is the other value
399: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
400: -- Stores the information for the fields of the LPN record that
401: -- the user desires to modify

Line 398: -- FND_API.G_VALID_LEVEL_NONE is the other value

394: -- whether or not to commit the changes to database
395: -- p_validation_level (optional), determines if full validation or
396: -- no validation will be performed
397: -- defaults to FND_API.G_VALID_LEVEL_FULL
398: -- FND_API.G_VALID_LEVEL_NONE is the other value
399: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
400: -- Stores the information for the fields of the LPN record that
401: -- the user desires to modify
402: -- p_source_type_id Source type ID for the source transaction

Line 412: -- fnd_api.g_ret_sts_success;

408: --
409: -- Output Parameters
410: -- x_return_status
411: -- if the Modify_LPN API succeeds, the value is
412: -- fnd_api.g_ret_sts_success;
413: -- if there is an expected error, the value is
414: -- fnd_api.g_ret_sts_error;
415: -- if there is an unexpected error, the value is
416: -- fnd_api.g_ret_sts_unexp_error;

Line 414: -- fnd_api.g_ret_sts_error;

410: -- x_return_status
411: -- if the Modify_LPN API succeeds, the value is
412: -- fnd_api.g_ret_sts_success;
413: -- if there is an expected error, the value is
414: -- fnd_api.g_ret_sts_error;
415: -- if there is an unexpected error, the value is
416: -- fnd_api.g_ret_sts_unexp_error;
417: -- x_msg_count
418: -- if there is one or more errors, the number of error messages

Line 416: -- fnd_api.g_ret_sts_unexp_error;

412: -- fnd_api.g_ret_sts_success;
413: -- if there is an expected error, the value is
414: -- fnd_api.g_ret_sts_error;
415: -- if there is an unexpected error, the value is
416: -- fnd_api.g_ret_sts_unexp_error;
417: -- x_msg_count
418: -- if there is one or more errors, the number of error messages
419: -- in the buffer
420: -- x_msg_data

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

421: -- if there is one and only one error, the error message
422:
423: PROCEDURE Modify_LPN
424: ( p_api_version IN NUMBER ,
425: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
426: p_commit IN VARCHAR2 := fnd_api.g_false ,
427: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
428: x_return_status OUT NOCOPY VARCHAR2 ,
429: x_msg_count OUT NOCOPY NUMBER ,

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

422:
423: PROCEDURE Modify_LPN
424: ( p_api_version IN NUMBER ,
425: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
426: p_commit IN VARCHAR2 := fnd_api.g_false ,
427: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
428: x_return_status OUT NOCOPY VARCHAR2 ,
429: x_msg_count OUT NOCOPY NUMBER ,
430: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 427: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,

423: PROCEDURE Modify_LPN
424: ( p_api_version IN NUMBER ,
425: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
426: p_commit IN VARCHAR2 := fnd_api.g_false ,
427: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
428: x_return_status OUT NOCOPY VARCHAR2 ,
429: x_msg_count OUT NOCOPY NUMBER ,
430: x_msg_data OUT NOCOPY VARCHAR2 ,
431: p_lpn IN LPN ,

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

443: /***********************************************************************/
444:
445: PROCEDURE Modify_LPN_Wrapper
446: ( p_api_version IN NUMBER ,
447: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
448: p_commit IN VARCHAR2 := fnd_api.g_false ,
449: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
450: x_return_status OUT NOCOPY VARCHAR2 ,
451: x_msg_count OUT NOCOPY NUMBER ,

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

444:
445: PROCEDURE Modify_LPN_Wrapper
446: ( p_api_version IN NUMBER ,
447: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
448: p_commit IN VARCHAR2 := fnd_api.g_false ,
449: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
450: x_return_status OUT NOCOPY VARCHAR2 ,
451: x_msg_count OUT NOCOPY NUMBER ,
452: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 449: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,

445: PROCEDURE Modify_LPN_Wrapper
446: ( p_api_version IN NUMBER ,
447: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
448: p_commit IN VARCHAR2 := fnd_api.g_false ,
449: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
450: x_return_status OUT NOCOPY VARCHAR2 ,
451: x_msg_count OUT NOCOPY NUMBER ,
452: x_msg_data OUT NOCOPY VARCHAR2 ,
453: p_lpn_id IN NUMBER ,

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

481: --
482: -- Input Parameters
483: -- p_api_version
484: -- API version number (current version is 1.0)
485: -- p_init_msg_list (optional, default FND_API.G_FALSE)
486: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
487: -- if set to FND_API.G_TRUE
488: -- initialize error message list
489: -- if set to FND_API.G_FALSE - not initialize error

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

482: -- Input Parameters
483: -- p_api_version
484: -- API version number (current version is 1.0)
485: -- p_init_msg_list (optional, default FND_API.G_FALSE)
486: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
487: -- if set to FND_API.G_TRUE
488: -- initialize error message list
489: -- if set to FND_API.G_FALSE - not initialize error
490: -- message list

Line 487: -- if set to FND_API.G_TRUE

483: -- p_api_version
484: -- API version number (current version is 1.0)
485: -- p_init_msg_list (optional, default FND_API.G_FALSE)
486: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
487: -- if set to FND_API.G_TRUE
488: -- initialize error message list
489: -- if set to FND_API.G_FALSE - not initialize error
490: -- message list
491: -- p_commit (optional, default FND_API.G_FALSE)

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

485: -- p_init_msg_list (optional, default FND_API.G_FALSE)
486: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
487: -- if set to FND_API.G_TRUE
488: -- initialize error message list
489: -- if set to FND_API.G_FALSE - not initialize error
490: -- message list
491: -- p_commit (optional, default FND_API.G_FALSE)
492: -- whether or not to commit the changes to database
493: -- p_validation_level (optional), determines if full validation or

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

487: -- if set to FND_API.G_TRUE
488: -- initialize error message list
489: -- if set to FND_API.G_FALSE - not initialize error
490: -- message list
491: -- p_commit (optional, default FND_API.G_FALSE)
492: -- whether or not to commit the changes to database
493: -- p_validation_level (optional), determines if full validation or
494: -- no validation will be performed
495: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 495: -- defaults to FND_API.G_VALID_LEVEL_FULL

491: -- p_commit (optional, default FND_API.G_FALSE)
492: -- whether or not to commit the changes to database
493: -- p_validation_level (optional), determines if full validation or
494: -- no validation will be performed
495: -- defaults to FND_API.G_VALID_LEVEL_FULL
496: -- FND_API.G_VALID_LEVEL_NONE is the other value
497: -- p_lpn_id Parent License Plate Number Identifier - Required Value
498: -- p_content_lpn_id Content LPN ID
499: -- p_content_item_id Content Item ID - Defaults to NULL

Line 496: -- FND_API.G_VALID_LEVEL_NONE is the other value

492: -- whether or not to commit the changes to database
493: -- p_validation_level (optional), determines if full validation or
494: -- no validation will be performed
495: -- defaults to FND_API.G_VALID_LEVEL_FULL
496: -- FND_API.G_VALID_LEVEL_NONE is the other value
497: -- p_lpn_id Parent License Plate Number Identifier - Required Value
498: -- p_content_lpn_id Content LPN ID
499: -- p_content_item_id Content Item ID - Defaults to NULL
500: -- p_content_item_desc Content Item Description - Defaults to NULL

Line 558: -- fnd_api.g_ret_sts_success;

554: --
555: -- Output Parameters
556: -- x_return_status
557: -- if the PackUnpack_Container API succeeds, the value is
558: -- fnd_api.g_ret_sts_success;
559: -- if there is an expected error, the value is
560: -- fnd_api.g_ret_sts_error;
561: -- if there is an unexpected error, the value is
562: -- fnd_api.g_ret_sts_unexp_error;

Line 560: -- fnd_api.g_ret_sts_error;

556: -- x_return_status
557: -- if the PackUnpack_Container API succeeds, the value is
558: -- fnd_api.g_ret_sts_success;
559: -- if there is an expected error, the value is
560: -- fnd_api.g_ret_sts_error;
561: -- if there is an unexpected error, the value is
562: -- fnd_api.g_ret_sts_unexp_error;
563: -- x_msg_count
564: -- if there is one or more errors, the number of error messages

Line 562: -- fnd_api.g_ret_sts_unexp_error;

558: -- fnd_api.g_ret_sts_success;
559: -- if there is an expected error, the value is
560: -- fnd_api.g_ret_sts_error;
561: -- if there is an unexpected error, the value is
562: -- fnd_api.g_ret_sts_unexp_error;
563: -- x_msg_count
564: -- if there is one or more errors, the number of error messages
565: -- in the buffer
566: -- x_msg_data

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

572: /***********************************************************************/
573:
574: PROCEDURE PackUnpack_Container (
575: p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , x_return_status OUT NOCOPY VARCHAR2
580: , x_msg_count OUT NOCOPY NUMBER

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

573:
574: PROCEDURE PackUnpack_Container (
575: p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , x_return_status OUT NOCOPY VARCHAR2
580: , x_msg_count OUT NOCOPY NUMBER
581: , x_msg_data OUT NOCOPY VARCHAR2

Line 578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

574: PROCEDURE PackUnpack_Container (
575: p_api_version IN NUMBER
576: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
577: , p_commit IN VARCHAR2 := fnd_api.g_false
578: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
579: , x_return_status OUT NOCOPY VARCHAR2
580: , x_msg_count OUT NOCOPY NUMBER
581: , x_msg_data OUT NOCOPY VARCHAR2
582: , p_lpn_id IN NUMBER

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

621: /***********************************************************************/
622:
623: PROCEDURE pack_prepack_container
624: ( p_api_version IN NUMBER ,
625: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
626: p_commit IN VARCHAR2 := fnd_api.g_false ,
627: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
628: x_return_status OUT NOCOPY VARCHAR2 ,
629: x_msg_count OUT NOCOPY NUMBER ,

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

622:
623: PROCEDURE pack_prepack_container
624: ( p_api_version IN NUMBER ,
625: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
626: p_commit IN VARCHAR2 := fnd_api.g_false ,
627: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
628: x_return_status OUT NOCOPY VARCHAR2 ,
629: x_msg_count OUT NOCOPY NUMBER ,
630: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 627: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,

623: PROCEDURE pack_prepack_container
624: ( p_api_version IN NUMBER ,
625: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
626: p_commit IN VARCHAR2 := fnd_api.g_false ,
627: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
628: x_return_status OUT NOCOPY VARCHAR2 ,
629: x_msg_count OUT NOCOPY NUMBER ,
630: x_msg_data OUT NOCOPY VARCHAR2 ,
631: p_lpn_id IN NUMBER ,

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

653: --
654: -- Input Parameters
655: -- p_api_version
656: -- API version number (current version is 1.0)
657: -- p_init_msg_list (optional, default FND_API.G_FALSE)
658: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
659: -- if set to FND_API.G_TRUE
660: -- initialize error message list
661: -- if set to FND_API.G_FALSE - not initialize error

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

654: -- Input Parameters
655: -- p_api_version
656: -- API version number (current version is 1.0)
657: -- p_init_msg_list (optional, default FND_API.G_FALSE)
658: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
659: -- if set to FND_API.G_TRUE
660: -- initialize error message list
661: -- if set to FND_API.G_FALSE - not initialize error
662: -- message list

Line 659: -- if set to FND_API.G_TRUE

655: -- p_api_version
656: -- API version number (current version is 1.0)
657: -- p_init_msg_list (optional, default FND_API.G_FALSE)
658: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
659: -- if set to FND_API.G_TRUE
660: -- initialize error message list
661: -- if set to FND_API.G_FALSE - not initialize error
662: -- message list
663: -- p_commit (optional, default FND_API.G_FALSE)

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

657: -- p_init_msg_list (optional, default FND_API.G_FALSE)
658: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
659: -- if set to FND_API.G_TRUE
660: -- initialize error message list
661: -- if set to FND_API.G_FALSE - not initialize error
662: -- message list
663: -- p_commit (optional, default FND_API.G_FALSE)
664: -- whether or not to commit the changes to database
665: -- p_lpn_id License Plate Number Identifier - Required Value

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

659: -- if set to FND_API.G_TRUE
660: -- initialize error message list
661: -- if set to FND_API.G_FALSE - not initialize error
662: -- message list
663: -- p_commit (optional, default FND_API.G_FALSE)
664: -- whether or not to commit the changes to database
665: -- p_lpn_id License Plate Number Identifier - Required Value
666: -- p_explosion_level Explosion Level - Defaults to 0 (Explode to all levels)
667: --

Line 672: -- fnd_api.g_ret_sts_success;

668: --
669: -- Output Parameters
670: -- x_return_status
671: -- if the Explode_LPN API succeeds, the value is
672: -- fnd_api.g_ret_sts_success;
673: -- if there is an expected error, the value is
674: -- fnd_api.g_ret_sts_error;
675: -- if there is an unexpected error, the value is
676: -- fnd_api.g_ret_sts_unexp_error;

Line 674: -- fnd_api.g_ret_sts_error;

670: -- x_return_status
671: -- if the Explode_LPN API succeeds, the value is
672: -- fnd_api.g_ret_sts_success;
673: -- if there is an expected error, the value is
674: -- fnd_api.g_ret_sts_error;
675: -- if there is an unexpected error, the value is
676: -- fnd_api.g_ret_sts_unexp_error;
677: -- x_msg_count
678: -- if there is one or more errors, the number of error messages

Line 676: -- fnd_api.g_ret_sts_unexp_error;

672: -- fnd_api.g_ret_sts_success;
673: -- if there is an expected error, the value is
674: -- fnd_api.g_ret_sts_error;
675: -- if there is an unexpected error, the value is
676: -- fnd_api.g_ret_sts_unexp_error;
677: -- x_msg_count
678: -- if there is one or more errors, the number of error messages
679: -- in the buffer
680: -- x_msg_data

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

709: INDEX BY BINARY_INTEGER;
710:
711: PROCEDURE Explode_LPN
712: ( p_api_version IN NUMBER ,
713: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
714: p_commit IN VARCHAR2 := fnd_api.g_false ,
715: x_return_status OUT NOCOPY VARCHAR2 ,
716: x_msg_count OUT NOCOPY NUMBER ,
717: x_msg_data OUT NOCOPY VARCHAR2 ,

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

710:
711: PROCEDURE Explode_LPN
712: ( p_api_version IN NUMBER ,
713: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
714: p_commit IN VARCHAR2 := fnd_api.g_false ,
715: x_return_status OUT NOCOPY VARCHAR2 ,
716: x_msg_count OUT NOCOPY NUMBER ,
717: x_msg_data OUT NOCOPY VARCHAR2 ,
718: p_lpn_id IN NUMBER ,

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

755: --
756: -- Input Parameters
757: -- p_api_version
758: -- API version number (current version is 1.0)
759: -- p_init_msg_list (optional, default FND_API.G_FALSE)
760: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
761: -- if set to FND_API.G_TRUE
762: -- initialize error message list
763: -- if set to FND_API.G_FALSE - not initialize error

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

756: -- Input Parameters
757: -- p_api_version
758: -- API version number (current version is 1.0)
759: -- p_init_msg_list (optional, default FND_API.G_FALSE)
760: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
761: -- if set to FND_API.G_TRUE
762: -- initialize error message list
763: -- if set to FND_API.G_FALSE - not initialize error
764: -- message list

Line 761: -- if set to FND_API.G_TRUE

757: -- p_api_version
758: -- API version number (current version is 1.0)
759: -- p_init_msg_list (optional, default FND_API.G_FALSE)
760: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
761: -- if set to FND_API.G_TRUE
762: -- initialize error message list
763: -- if set to FND_API.G_FALSE - not initialize error
764: -- message list
765: -- p_commit (optional, default FND_API.G_FALSE)

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

759: -- p_init_msg_list (optional, default FND_API.G_FALSE)
760: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
761: -- if set to FND_API.G_TRUE
762: -- initialize error message list
763: -- if set to FND_API.G_FALSE - not initialize error
764: -- message list
765: -- p_commit (optional, default FND_API.G_FALSE)
766: -- whether or not to commit the changes to database
767: -- p_source_item_id Source Item id (can also be a container Item) - Required Value

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

761: -- if set to FND_API.G_TRUE
762: -- initialize error message list
763: -- if set to FND_API.G_FALSE - not initialize error
764: -- message list
765: -- p_commit (optional, default FND_API.G_FALSE)
766: -- whether or not to commit the changes to database
767: -- p_source_item_id Source Item id (can also be a container Item) - Required Value
768: -- p_source_qty Source Item Qty - Required Value
769: -- p_source_qty_uom UOM of Source Item Qty - Required Value

Line 779: -- fnd_api.g_ret_sts_success;

775: --
776: -- Output Parameters
777: -- x_return_status
778: -- if the Container_Required_Qty API succeeds, the value is
779: -- fnd_api.g_ret_sts_success;
780: -- if there is an expected error, the value is
781: -- fnd_api.g_ret_sts_error;
782: -- if there is an unexpected error, the value is
783: -- fnd_api.g_ret_sts_unexp_error;

Line 781: -- fnd_api.g_ret_sts_error;

777: -- x_return_status
778: -- if the Container_Required_Qty API succeeds, the value is
779: -- fnd_api.g_ret_sts_success;
780: -- if there is an expected error, the value is
781: -- fnd_api.g_ret_sts_error;
782: -- if there is an unexpected error, the value is
783: -- fnd_api.g_ret_sts_unexp_error;
784: -- x_msg_count
785: -- if there is one or more errors, the number of error messages

Line 783: -- fnd_api.g_ret_sts_unexp_error;

779: -- fnd_api.g_ret_sts_success;
780: -- if there is an expected error, the value is
781: -- fnd_api.g_ret_sts_error;
782: -- if there is an unexpected error, the value is
783: -- fnd_api.g_ret_sts_unexp_error;
784: -- x_msg_count
785: -- if there is one or more errors, the number of error messages
786: -- in the buffer
787: -- x_msg_data

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

795: /***********************************************************************/
796:
797: PROCEDURE Container_Required_Qty
798: ( p_api_version IN NUMBER ,
799: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
800: p_commit IN VARCHAR2 := fnd_api.g_false ,
801: x_return_status OUT NOCOPY VARCHAR2 ,
802: x_msg_count OUT NOCOPY NUMBER ,
803: x_msg_data OUT NOCOPY VARCHAR2 ,

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

796:
797: PROCEDURE Container_Required_Qty
798: ( p_api_version IN NUMBER ,
799: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
800: p_commit IN VARCHAR2 := fnd_api.g_false ,
801: x_return_status OUT NOCOPY VARCHAR2 ,
802: x_msg_count OUT NOCOPY NUMBER ,
803: x_msg_data OUT NOCOPY VARCHAR2 ,
804: p_source_item_id IN NUMBER ,

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

828: --
829: -- Input Parameters
830: -- p_api_version
831: -- API version number (current version is 1.0)
832: -- p_init_msg_list (optional, default FND_API.G_FALSE)
833: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
834: -- if set to FND_API.G_TRUE
835: -- initialize error message list
836: -- if set to FND_API.G_FALSE - do not initialize error

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

829: -- Input Parameters
830: -- p_api_version
831: -- API version number (current version is 1.0)
832: -- p_init_msg_list (optional, default FND_API.G_FALSE)
833: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
834: -- if set to FND_API.G_TRUE
835: -- initialize error message list
836: -- if set to FND_API.G_FALSE - do not initialize error
837: -- message list

Line 834: -- if set to FND_API.G_TRUE

830: -- p_api_version
831: -- API version number (current version is 1.0)
832: -- p_init_msg_list (optional, default FND_API.G_FALSE)
833: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
834: -- if set to FND_API.G_TRUE
835: -- initialize error message list
836: -- if set to FND_API.G_FALSE - do not initialize error
837: -- message list
838: -- p_commit (optional, default FND_API.G_FALSE)

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

832: -- p_init_msg_list (optional, default FND_API.G_FALSE)
833: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
834: -- if set to FND_API.G_TRUE
835: -- initialize error message list
836: -- if set to FND_API.G_FALSE - do not initialize error
837: -- message list
838: -- p_commit (optional, default FND_API.G_FALSE)
839: -- whether or not to commit the changes to database
840: -- p_organization_id Organization of the LPN - Required

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

834: -- if set to FND_API.G_TRUE
835: -- initialize error message list
836: -- if set to FND_API.G_FALSE - do not initialize error
837: -- message list
838: -- p_commit (optional, default FND_API.G_FALSE)
839: -- whether or not to commit the changes to database
840: -- p_organization_id Organization of the LPN - Required
841: -- p_subinventory Subinventory - Defaults to NULL
842: -- p_locator_id Locator Id - Defaults to NULL

Line 866: -- fnd_api.g_ret_sts_success;

862: -- ERRBUF Concurrent program error buffer
863: -- RETCODE Concurrent program return code
864: -- x_return_status
865: -- if the Prepack_LPN API succeeds, the value is
866: -- fnd_api.g_ret_sts_success;
867: -- if there is an expected error, the value is
868: -- fnd_api.g_ret_sts_error;
869: -- if there is an unexpected error, the value is
870: -- fnd_api.g_ret_sts_unexp_error;

Line 868: -- fnd_api.g_ret_sts_error;

864: -- x_return_status
865: -- if the Prepack_LPN API succeeds, the value is
866: -- fnd_api.g_ret_sts_success;
867: -- if there is an expected error, the value is
868: -- fnd_api.g_ret_sts_error;
869: -- if there is an unexpected error, the value is
870: -- fnd_api.g_ret_sts_unexp_error;
871: -- x_msg_count
872: -- if there is one or more errors, the number of error messages

Line 870: -- fnd_api.g_ret_sts_unexp_error;

866: -- fnd_api.g_ret_sts_success;
867: -- if there is an expected error, the value is
868: -- fnd_api.g_ret_sts_error;
869: -- if there is an unexpected error, the value is
870: -- fnd_api.g_ret_sts_unexp_error;
871: -- x_msg_count
872: -- if there is one or more errors, the number of error messages
873: -- in the buffer
874: -- x_msg_data

Line 903: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,

899: p_cont_revision IN VARCHAR2 := NULL ,
900: p_cont_lot_number IN VARCHAR2 := NULL ,
901: p_cont_serial_number_from IN VARCHAR2 := NULL ,
902: p_cont_serial_number_to IN VARCHAR2 := NULL ,
903: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
904: p_print_label IN NUMBER := fnd_api.g_miss_num ,
905: p_print_content_report IN NUMBER := fnd_api.g_miss_num
906: );
907:

Line 904: p_print_label IN NUMBER := fnd_api.g_miss_num ,

900: p_cont_lot_number IN VARCHAR2 := NULL ,
901: p_cont_serial_number_from IN VARCHAR2 := NULL ,
902: p_cont_serial_number_to IN VARCHAR2 := NULL ,
903: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
904: p_print_label IN NUMBER := fnd_api.g_miss_num ,
905: p_print_content_report IN NUMBER := fnd_api.g_miss_num
906: );
907:
908: TYPE Transaction_History IS TABLE OF WMS_LPN_HISTORIES.lpn_history_id%TYPE

Line 905: p_print_content_report IN NUMBER := fnd_api.g_miss_num

901: p_cont_serial_number_from IN VARCHAR2 := NULL ,
902: p_cont_serial_number_to IN VARCHAR2 := NULL ,
903: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
904: p_print_label IN NUMBER := fnd_api.g_miss_num ,
905: p_print_content_report IN NUMBER := fnd_api.g_miss_num
906: );
907:
908: TYPE Transaction_History IS TABLE OF WMS_LPN_HISTORIES.lpn_history_id%TYPE
909: INDEX BY BINARY_INTEGER;

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

965: -- End of comments
966:
967: PROCEDURE Merge_Up_LPN (
968: p_api_version IN NUMBER
969: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
970: , p_commit IN VARCHAR2 := fnd_api.g_false
971: , x_return_status OUT NOCOPY VARCHAR2
972: , x_msg_count OUT NOCOPY NUMBER
973: , x_msg_data OUT NOCOPY VARCHAR2

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

966:
967: PROCEDURE Merge_Up_LPN (
968: p_api_version IN NUMBER
969: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
970: , p_commit IN VARCHAR2 := fnd_api.g_false
971: , x_return_status OUT NOCOPY VARCHAR2
972: , x_msg_count OUT NOCOPY NUMBER
973: , x_msg_data OUT NOCOPY VARCHAR2
974: , p_organization_id IN NUMBER

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

1008: -- End of comments
1009:
1010: PROCEDURE Break_Down_LPN (
1011: p_api_version IN NUMBER
1012: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1013: , p_commit IN VARCHAR2 := fnd_api.g_false
1014: , x_return_status OUT NOCOPY VARCHAR2
1015: , x_msg_count OUT NOCOPY NUMBER
1016: , x_msg_data OUT NOCOPY VARCHAR2

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

1009:
1010: PROCEDURE Break_Down_LPN (
1011: p_api_version IN NUMBER
1012: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1013: , p_commit IN VARCHAR2 := fnd_api.g_false
1014: , x_return_status OUT NOCOPY VARCHAR2
1015: , x_msg_count OUT NOCOPY NUMBER
1016: , x_msg_data OUT NOCOPY VARCHAR2
1017: , p_organization_id IN NUMBER

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

1038: -- End of comments
1039:
1040: PROCEDURE Initialize_LPN (
1041: p_api_version IN NUMBER
1042: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1043: , p_commit IN VARCHAR2 := fnd_api.g_false
1044: , x_return_status OUT NOCOPY VARCHAR2
1045: , x_msg_count OUT NOCOPY NUMBER
1046: , x_msg_data OUT NOCOPY VARCHAR2

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

1039:
1040: PROCEDURE Initialize_LPN (
1041: p_api_version IN NUMBER
1042: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1043: , p_commit IN VARCHAR2 := fnd_api.g_false
1044: , x_return_status OUT NOCOPY VARCHAR2
1045: , x_msg_count OUT NOCOPY NUMBER
1046: , x_msg_data OUT NOCOPY VARCHAR2
1047: , p_organization_id IN NUMBER

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

1050:
1051: -- For LPN reuse ER : 6845650
1052: PROCEDURE REUSE_LPNS (
1053: p_api_version IN NUMBER
1054: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1055: , p_commit IN VARCHAR2 := fnd_api.g_false
1056: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1057: , x_return_status OUT NOCOPY VARCHAR2
1058: , x_msg_count OUT NOCOPY NUMBER

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

1051: -- For LPN reuse ER : 6845650
1052: PROCEDURE REUSE_LPNS (
1053: p_api_version IN NUMBER
1054: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1055: , p_commit IN VARCHAR2 := fnd_api.g_false
1056: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1057: , x_return_status OUT NOCOPY VARCHAR2
1058: , x_msg_count OUT NOCOPY NUMBER
1059: , x_msg_data OUT NOCOPY VARCHAR2

Line 1056: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1052: PROCEDURE REUSE_LPNS (
1053: p_api_version IN NUMBER
1054: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1055: , p_commit IN VARCHAR2 := fnd_api.g_false
1056: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1057: , x_return_status OUT NOCOPY VARCHAR2
1058: , x_msg_count OUT NOCOPY NUMBER
1059: , x_msg_data OUT NOCOPY VARCHAR2
1060: , p_lpn_id IN NUMBER