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 175: -- p_init_msg_list (optional, default FND_API.G_FALSE)

171: --
172: -- Input Parameters
173: -- p_api_version
174: -- API version number (current version is 1.0)
175: -- p_init_msg_list (optional, default FND_API.G_FALSE)
176: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
177: -- if set to FND_API.G_TRUE
178: -- initialize error message list
179: -- if set to FND_API.G_FALSE - not initialize error

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

172: -- Input Parameters
173: -- p_api_version
174: -- API version number (current version is 1.0)
175: -- p_init_msg_list (optional, default FND_API.G_FALSE)
176: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
177: -- if set to FND_API.G_TRUE
178: -- initialize error message list
179: -- if set to FND_API.G_FALSE - not initialize error
180: -- message list

Line 177: -- if set to FND_API.G_TRUE

173: -- p_api_version
174: -- API version number (current version is 1.0)
175: -- p_init_msg_list (optional, default FND_API.G_FALSE)
176: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
177: -- if set to FND_API.G_TRUE
178: -- initialize error message list
179: -- if set to FND_API.G_FALSE - not initialize error
180: -- message list
181: -- p_commit (optional, default FND_API.G_FALSE)

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

175: -- p_init_msg_list (optional, default FND_API.G_FALSE)
176: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
177: -- if set to FND_API.G_TRUE
178: -- initialize error message list
179: -- if set to FND_API.G_FALSE - not initialize error
180: -- message list
181: -- p_commit (optional, default FND_API.G_FALSE)
182: -- whether or not to commit the changes to database
183: -- p_validation_level (optional), determines if full validation or

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

177: -- if set to FND_API.G_TRUE
178: -- initialize error message list
179: -- if set to FND_API.G_FALSE - not initialize error
180: -- message list
181: -- p_commit (optional, default FND_API.G_FALSE)
182: -- whether or not to commit the changes to database
183: -- p_validation_level (optional), determines if full validation or
184: -- no validation will be performed
185: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 185: -- defaults to FND_API.G_VALID_LEVEL_FULL

181: -- p_commit (optional, default FND_API.G_FALSE)
182: -- whether or not to commit the changes to database
183: -- p_validation_level (optional), determines if full validation or
184: -- no validation will be performed
185: -- defaults to FND_API.G_VALID_LEVEL_FULL
186: -- FND_API.G_VALID_LEVEL_NONE is the other value
187: -- p_lpn_id License Plate Number Identifier - Required Value
188: -- p_container_item_id Container Item Id - Required Value
189: -- p_lot_number Lot Number - Defaults to NULL

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

182: -- whether or not to commit the changes to database
183: -- p_validation_level (optional), determines if full validation or
184: -- no validation will be performed
185: -- defaults to FND_API.G_VALID_LEVEL_FULL
186: -- FND_API.G_VALID_LEVEL_NONE is the other value
187: -- p_lpn_id License Plate Number Identifier - Required Value
188: -- p_container_item_id Container Item Id - Required Value
189: -- p_lot_number Lot Number - Defaults to NULL
190: -- p_revision Revision - Defaults to NULL

Line 206: -- fnd_api.g_ret_sts_success;

202: --
203: -- Output Parameters
204: -- x_return_status
205: -- if the Associate_LPN API succeeds, the value is
206: -- fnd_api.g_ret_sts_success;
207: -- if there is an expected error, the value is
208: -- fnd_api.g_ret_sts_error;
209: -- if there is an unexpected error, the value is
210: -- fnd_api.g_ret_sts_unexp_error;

Line 208: -- fnd_api.g_ret_sts_error;

204: -- x_return_status
205: -- if the Associate_LPN API succeeds, the value is
206: -- fnd_api.g_ret_sts_success;
207: -- if there is an expected error, the value is
208: -- fnd_api.g_ret_sts_error;
209: -- if there is an unexpected error, the value is
210: -- fnd_api.g_ret_sts_unexp_error;
211: -- x_msg_count
212: -- if there is one or more errors, the number of error messages

Line 210: -- fnd_api.g_ret_sts_unexp_error;

206: -- fnd_api.g_ret_sts_success;
207: -- if there is an expected error, the value is
208: -- fnd_api.g_ret_sts_error;
209: -- if there is an unexpected error, the value is
210: -- fnd_api.g_ret_sts_unexp_error;
211: -- x_msg_count
212: -- if there is one or more errors, the number of error messages
213: -- in the buffer
214: -- x_msg_data

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

220: /***********************************************************************/
221:
222: PROCEDURE Associate_LPN
223: ( p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225: p_commit IN VARCHAR2 := fnd_api.g_false ,
226: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
227: x_return_status OUT NOCOPY VARCHAR2 ,
228: x_msg_count OUT NOCOPY NUMBER ,

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

221:
222: PROCEDURE Associate_LPN
223: ( p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225: p_commit IN VARCHAR2 := fnd_api.g_false ,
226: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
227: x_return_status OUT NOCOPY VARCHAR2 ,
228: x_msg_count OUT NOCOPY NUMBER ,
229: x_msg_data OUT NOCOPY VARCHAR2 ,

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

222: PROCEDURE Associate_LPN
223: ( p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225: p_commit IN VARCHAR2 := fnd_api.g_false ,
226: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
227: x_return_status OUT NOCOPY VARCHAR2 ,
228: x_msg_count OUT NOCOPY NUMBER ,
229: x_msg_data OUT NOCOPY VARCHAR2 ,
230: p_lpn_id IN NUMBER ,

Line 252: * @ 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

248: * the WMS_LICENSE_PLATE_NUMBERS table returning to the caller a uniquely generated LPN_ID.
249: *
250: * @ param p_api_version API version number (current version is 1.0)
251: * @ paraminfo {@rep:required}
252: * @ 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
253: * @ paraminfo {@rep:required}
254: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
255: * @ paraminfo {@rep:required}
256: * @ 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 254: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database

250: * @ param p_api_version API version number (current version is 1.0)
251: * @ paraminfo {@rep:required}
252: * @ 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
253: * @ paraminfo {@rep:required}
254: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
255: * @ paraminfo {@rep:required}
256: * @ 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
257: * @ paraminfo {@rep:required}
258: * @ param p_lpn License Plate Number Identifier - Required Value

Line 256: * @ 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

252: * @ 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
253: * @ paraminfo {@rep:required}
254: * @ param p_commit default FND_API.G_FALSE whether or not to commit the changes to database
255: * @ paraminfo {@rep:required}
256: * @ 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
257: * @ paraminfo {@rep:required}
258: * @ param p_lpn License Plate Number Identifier - Required Value
259: * @ paraminfo {@rep:required}
260: * @ param p_organization_id Organization Id - Required Value

Line 290: * @ 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;

286: * @ param p_source_line_id Source line ID for the source transaction
287: * @ paraminfo {@rep:optional}
288: * @ param p_source_line_detail_id Source line detail ID for the source transaction
289: * @ paraminfo {@rep:optional}
290: * @ 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;
291: * @ paraminfo {@rep:required}
292: * @ param x_msg_count if there is one or more errors, the number of error messages in the buffer
293: * @ paraminfo {@rep:required}
294: * @ param x_msg_data if there is one and only one error, the error message

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

301: * @rep:businessevent Create_LPN
302: */
303: PROCEDURE Create_LPN (
304: p_api_version IN NUMBER
305: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
306: , p_commit IN VARCHAR2 := fnd_api.g_false
307: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
308: , x_return_status OUT NOCOPY VARCHAR2
309: , x_msg_count OUT NOCOPY NUMBER

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

302: */
303: PROCEDURE Create_LPN (
304: p_api_version IN NUMBER
305: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
306: , p_commit IN VARCHAR2 := fnd_api.g_false
307: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
308: , x_return_status OUT NOCOPY VARCHAR2
309: , x_msg_count OUT NOCOPY NUMBER
310: , x_msg_data OUT NOCOPY VARCHAR2

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

303: PROCEDURE Create_LPN (
304: p_api_version IN NUMBER
305: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
306: , p_commit IN VARCHAR2 := fnd_api.g_false
307: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
308: , x_return_status OUT NOCOPY VARCHAR2
309: , x_msg_count OUT NOCOPY NUMBER
310: , x_msg_data OUT NOCOPY VARCHAR2
311: , p_lpn IN VARCHAR2

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

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

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

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

Line 350: -- if set to FND_API.G_TRUE

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

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

348: -- p_init_msg_list (optional, default FND_API.G_FALSE)
349: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
350: -- if set to FND_API.G_TRUE
351: -- initialize error message list
352: -- if set to FND_API.G_FALSE - not initialize error
353: -- message list
354: -- p_commit (optional, default FND_API.G_FALSE)
355: -- whether or not to commit the changes to database
356: -- p_validation_level (optional), determines if full validation or

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

350: -- if set to FND_API.G_TRUE
351: -- initialize error message list
352: -- if set to FND_API.G_FALSE - not initialize error
353: -- message list
354: -- p_commit (optional, default FND_API.G_FALSE)
355: -- whether or not to commit the changes to database
356: -- p_validation_level (optional), determines if full validation or
357: -- no validation will be performed
358: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 358: -- defaults to FND_API.G_VALID_LEVEL_FULL

354: -- p_commit (optional, default FND_API.G_FALSE)
355: -- whether or not to commit the changes to database
356: -- p_validation_level (optional), determines if full validation or
357: -- no validation will be performed
358: -- defaults to FND_API.G_VALID_LEVEL_FULL
359: -- FND_API.G_VALID_LEVEL_NONE is the other value
360: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
361: -- Stores the information for the fields of the LPN record that
362: -- the user desires to modify

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

355: -- whether or not to commit the changes to database
356: -- p_validation_level (optional), determines if full validation or
357: -- no validation will be performed
358: -- defaults to FND_API.G_VALID_LEVEL_FULL
359: -- FND_API.G_VALID_LEVEL_NONE is the other value
360: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
361: -- Stores the information for the fields of the LPN record that
362: -- the user desires to modify
363: -- p_source_type_id Source type ID for the source transaction

Line 373: -- fnd_api.g_ret_sts_success;

369: --
370: -- Output Parameters
371: -- x_return_status
372: -- if the Modify_LPN API succeeds, the value is
373: -- fnd_api.g_ret_sts_success;
374: -- if there is an expected error, the value is
375: -- fnd_api.g_ret_sts_error;
376: -- if there is an unexpected error, the value is
377: -- fnd_api.g_ret_sts_unexp_error;

Line 375: -- fnd_api.g_ret_sts_error;

371: -- x_return_status
372: -- if the Modify_LPN API succeeds, the value is
373: -- fnd_api.g_ret_sts_success;
374: -- if there is an expected error, the value is
375: -- fnd_api.g_ret_sts_error;
376: -- if there is an unexpected error, the value is
377: -- fnd_api.g_ret_sts_unexp_error;
378: -- x_msg_count
379: -- if there is one or more errors, the number of error messages

Line 377: -- fnd_api.g_ret_sts_unexp_error;

373: -- fnd_api.g_ret_sts_success;
374: -- if there is an expected error, the value is
375: -- fnd_api.g_ret_sts_error;
376: -- if there is an unexpected error, the value is
377: -- fnd_api.g_ret_sts_unexp_error;
378: -- x_msg_count
379: -- if there is one or more errors, the number of error messages
380: -- in the buffer
381: -- x_msg_data

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

382: -- if there is one and only one error, the error message
383:
384: PROCEDURE Modify_LPN
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
387: p_commit IN VARCHAR2 := fnd_api.g_false ,
388: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
389: x_return_status OUT NOCOPY VARCHAR2 ,
390: x_msg_count OUT NOCOPY NUMBER ,

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

383:
384: PROCEDURE Modify_LPN
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
387: p_commit IN VARCHAR2 := fnd_api.g_false ,
388: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
389: x_return_status OUT NOCOPY VARCHAR2 ,
390: x_msg_count OUT NOCOPY NUMBER ,
391: x_msg_data OUT NOCOPY VARCHAR2 ,

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

384: PROCEDURE Modify_LPN
385: ( p_api_version IN NUMBER ,
386: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
387: p_commit IN VARCHAR2 := fnd_api.g_false ,
388: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
389: x_return_status OUT NOCOPY VARCHAR2 ,
390: x_msg_count OUT NOCOPY NUMBER ,
391: x_msg_data OUT NOCOPY VARCHAR2 ,
392: p_lpn IN LPN ,

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

404: /***********************************************************************/
405:
406: PROCEDURE Modify_LPN_Wrapper
407: ( p_api_version IN NUMBER ,
408: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
409: p_commit IN VARCHAR2 := fnd_api.g_false ,
410: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
411: x_return_status OUT NOCOPY VARCHAR2 ,
412: x_msg_count OUT NOCOPY NUMBER ,

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

405:
406: PROCEDURE Modify_LPN_Wrapper
407: ( p_api_version IN NUMBER ,
408: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
409: p_commit IN VARCHAR2 := fnd_api.g_false ,
410: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
411: x_return_status OUT NOCOPY VARCHAR2 ,
412: x_msg_count OUT NOCOPY NUMBER ,
413: x_msg_data OUT NOCOPY VARCHAR2 ,

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

406: PROCEDURE Modify_LPN_Wrapper
407: ( p_api_version IN NUMBER ,
408: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
409: p_commit IN VARCHAR2 := fnd_api.g_false ,
410: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
411: x_return_status OUT NOCOPY VARCHAR2 ,
412: x_msg_count OUT NOCOPY NUMBER ,
413: x_msg_data OUT NOCOPY VARCHAR2 ,
414: p_lpn_id IN NUMBER ,

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

442: --
443: -- Input Parameters
444: -- p_api_version
445: -- API version number (current version is 1.0)
446: -- p_init_msg_list (optional, default FND_API.G_FALSE)
447: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
448: -- if set to FND_API.G_TRUE
449: -- initialize error message list
450: -- if set to FND_API.G_FALSE - not initialize error

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

443: -- Input Parameters
444: -- p_api_version
445: -- API version number (current version is 1.0)
446: -- p_init_msg_list (optional, default FND_API.G_FALSE)
447: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
448: -- if set to FND_API.G_TRUE
449: -- initialize error message list
450: -- if set to FND_API.G_FALSE - not initialize error
451: -- message list

Line 448: -- if set to FND_API.G_TRUE

444: -- p_api_version
445: -- API version number (current version is 1.0)
446: -- p_init_msg_list (optional, default FND_API.G_FALSE)
447: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
448: -- if set to FND_API.G_TRUE
449: -- initialize error message list
450: -- if set to FND_API.G_FALSE - not initialize error
451: -- message list
452: -- p_commit (optional, default FND_API.G_FALSE)

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

446: -- p_init_msg_list (optional, default FND_API.G_FALSE)
447: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
448: -- if set to FND_API.G_TRUE
449: -- initialize error message list
450: -- if set to FND_API.G_FALSE - not initialize error
451: -- message list
452: -- p_commit (optional, default FND_API.G_FALSE)
453: -- whether or not to commit the changes to database
454: -- p_validation_level (optional), determines if full validation or

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

448: -- if set to FND_API.G_TRUE
449: -- initialize error message list
450: -- if set to FND_API.G_FALSE - not initialize error
451: -- message list
452: -- p_commit (optional, default FND_API.G_FALSE)
453: -- whether or not to commit the changes to database
454: -- p_validation_level (optional), determines if full validation or
455: -- no validation will be performed
456: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 456: -- defaults to FND_API.G_VALID_LEVEL_FULL

452: -- p_commit (optional, default FND_API.G_FALSE)
453: -- whether or not to commit the changes to database
454: -- p_validation_level (optional), determines if full validation or
455: -- no validation will be performed
456: -- defaults to FND_API.G_VALID_LEVEL_FULL
457: -- FND_API.G_VALID_LEVEL_NONE is the other value
458: -- p_lpn_id Parent License Plate Number Identifier - Required Value
459: -- p_content_lpn_id Content LPN ID
460: -- p_content_item_id Content Item ID - Defaults to NULL

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

453: -- whether or not to commit the changes to database
454: -- p_validation_level (optional), determines if full validation or
455: -- no validation will be performed
456: -- defaults to FND_API.G_VALID_LEVEL_FULL
457: -- FND_API.G_VALID_LEVEL_NONE is the other value
458: -- p_lpn_id Parent License Plate Number Identifier - Required Value
459: -- p_content_lpn_id Content LPN ID
460: -- p_content_item_id Content Item ID - Defaults to NULL
461: -- p_content_item_desc Content Item Description - Defaults to NULL

Line 519: -- fnd_api.g_ret_sts_success;

515: --
516: -- Output Parameters
517: -- x_return_status
518: -- if the PackUnpack_Container API succeeds, the value is
519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;

Line 521: -- fnd_api.g_ret_sts_error;

517: -- x_return_status
518: -- if the PackUnpack_Container API succeeds, the value is
519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;
524: -- x_msg_count
525: -- if there is one or more errors, the number of error messages

Line 523: -- fnd_api.g_ret_sts_unexp_error;

519: -- fnd_api.g_ret_sts_success;
520: -- if there is an expected error, the value is
521: -- fnd_api.g_ret_sts_error;
522: -- if there is an unexpected error, the value is
523: -- fnd_api.g_ret_sts_unexp_error;
524: -- x_msg_count
525: -- if there is one or more errors, the number of error messages
526: -- in the buffer
527: -- x_msg_data

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

533: /***********************************************************************/
534:
535: PROCEDURE PackUnpack_Container (
536: p_api_version IN NUMBER
537: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
538: , p_commit IN VARCHAR2 := fnd_api.g_false
539: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
540: , x_return_status OUT NOCOPY VARCHAR2
541: , x_msg_count OUT NOCOPY NUMBER

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

534:
535: PROCEDURE PackUnpack_Container (
536: p_api_version IN NUMBER
537: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
538: , p_commit IN VARCHAR2 := fnd_api.g_false
539: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
540: , x_return_status OUT NOCOPY VARCHAR2
541: , x_msg_count OUT NOCOPY NUMBER
542: , x_msg_data OUT NOCOPY VARCHAR2

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

535: PROCEDURE PackUnpack_Container (
536: p_api_version IN NUMBER
537: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
538: , p_commit IN VARCHAR2 := fnd_api.g_false
539: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
540: , x_return_status OUT NOCOPY VARCHAR2
541: , x_msg_count OUT NOCOPY NUMBER
542: , x_msg_data OUT NOCOPY VARCHAR2
543: , p_lpn_id IN NUMBER

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

582: /***********************************************************************/
583:
584: PROCEDURE pack_prepack_container
585: ( p_api_version IN NUMBER ,
586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
587: p_commit IN VARCHAR2 := fnd_api.g_false ,
588: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
589: x_return_status OUT NOCOPY VARCHAR2 ,
590: x_msg_count OUT NOCOPY NUMBER ,

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

583:
584: PROCEDURE pack_prepack_container
585: ( p_api_version IN NUMBER ,
586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
587: p_commit IN VARCHAR2 := fnd_api.g_false ,
588: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
589: x_return_status OUT NOCOPY VARCHAR2 ,
590: x_msg_count OUT NOCOPY NUMBER ,
591: x_msg_data OUT NOCOPY VARCHAR2 ,

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

584: PROCEDURE pack_prepack_container
585: ( p_api_version IN NUMBER ,
586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
587: p_commit IN VARCHAR2 := fnd_api.g_false ,
588: p_validation_level IN NUMBER := fnd_api.g_valid_level_full ,
589: x_return_status OUT NOCOPY VARCHAR2 ,
590: x_msg_count OUT NOCOPY NUMBER ,
591: x_msg_data OUT NOCOPY VARCHAR2 ,
592: p_lpn_id IN NUMBER ,

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

614: --
615: -- Input Parameters
616: -- p_api_version
617: -- API version number (current version is 1.0)
618: -- p_init_msg_list (optional, default FND_API.G_FALSE)
619: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
620: -- if set to FND_API.G_TRUE
621: -- initialize error message list
622: -- if set to FND_API.G_FALSE - not initialize error

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

615: -- Input Parameters
616: -- p_api_version
617: -- API version number (current version is 1.0)
618: -- p_init_msg_list (optional, default FND_API.G_FALSE)
619: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
620: -- if set to FND_API.G_TRUE
621: -- initialize error message list
622: -- if set to FND_API.G_FALSE - not initialize error
623: -- message list

Line 620: -- if set to FND_API.G_TRUE

616: -- p_api_version
617: -- API version number (current version is 1.0)
618: -- p_init_msg_list (optional, default FND_API.G_FALSE)
619: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
620: -- if set to FND_API.G_TRUE
621: -- initialize error message list
622: -- if set to FND_API.G_FALSE - not initialize error
623: -- message list
624: -- p_commit (optional, default FND_API.G_FALSE)

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

618: -- p_init_msg_list (optional, default FND_API.G_FALSE)
619: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
620: -- if set to FND_API.G_TRUE
621: -- initialize error message list
622: -- if set to FND_API.G_FALSE - not initialize error
623: -- message list
624: -- p_commit (optional, default FND_API.G_FALSE)
625: -- whether or not to commit the changes to database
626: -- p_lpn_id License Plate Number Identifier - Required Value

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

620: -- if set to FND_API.G_TRUE
621: -- initialize error message list
622: -- if set to FND_API.G_FALSE - not initialize error
623: -- message list
624: -- p_commit (optional, default FND_API.G_FALSE)
625: -- whether or not to commit the changes to database
626: -- p_lpn_id License Plate Number Identifier - Required Value
627: -- p_explosion_level Explosion Level - Defaults to 0 (Explode to all levels)
628: --

Line 633: -- fnd_api.g_ret_sts_success;

629: --
630: -- Output Parameters
631: -- x_return_status
632: -- if the Explode_LPN API succeeds, the value is
633: -- fnd_api.g_ret_sts_success;
634: -- if there is an expected error, the value is
635: -- fnd_api.g_ret_sts_error;
636: -- if there is an unexpected error, the value is
637: -- fnd_api.g_ret_sts_unexp_error;

Line 635: -- fnd_api.g_ret_sts_error;

631: -- x_return_status
632: -- if the Explode_LPN API succeeds, the value is
633: -- fnd_api.g_ret_sts_success;
634: -- if there is an expected error, the value is
635: -- fnd_api.g_ret_sts_error;
636: -- if there is an unexpected error, the value is
637: -- fnd_api.g_ret_sts_unexp_error;
638: -- x_msg_count
639: -- if there is one or more errors, the number of error messages

Line 637: -- fnd_api.g_ret_sts_unexp_error;

633: -- fnd_api.g_ret_sts_success;
634: -- if there is an expected error, the value is
635: -- fnd_api.g_ret_sts_error;
636: -- if there is an unexpected error, the value is
637: -- fnd_api.g_ret_sts_unexp_error;
638: -- x_msg_count
639: -- if there is one or more errors, the number of error messages
640: -- in the buffer
641: -- x_msg_data

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

669: INDEX BY BINARY_INTEGER;
670:
671: PROCEDURE Explode_LPN
672: ( p_api_version IN NUMBER ,
673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
674: p_commit IN VARCHAR2 := fnd_api.g_false ,
675: x_return_status OUT NOCOPY VARCHAR2 ,
676: x_msg_count OUT NOCOPY NUMBER ,
677: x_msg_data OUT NOCOPY VARCHAR2 ,

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

670:
671: PROCEDURE Explode_LPN
672: ( p_api_version IN NUMBER ,
673: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
674: p_commit IN VARCHAR2 := fnd_api.g_false ,
675: x_return_status OUT NOCOPY VARCHAR2 ,
676: x_msg_count OUT NOCOPY NUMBER ,
677: x_msg_data OUT NOCOPY VARCHAR2 ,
678: p_lpn_id IN NUMBER ,

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

715: --
716: -- Input Parameters
717: -- p_api_version
718: -- API version number (current version is 1.0)
719: -- p_init_msg_list (optional, default FND_API.G_FALSE)
720: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
721: -- if set to FND_API.G_TRUE
722: -- initialize error message list
723: -- if set to FND_API.G_FALSE - not initialize error

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

716: -- Input Parameters
717: -- p_api_version
718: -- API version number (current version is 1.0)
719: -- p_init_msg_list (optional, default FND_API.G_FALSE)
720: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
721: -- if set to FND_API.G_TRUE
722: -- initialize error message list
723: -- if set to FND_API.G_FALSE - not initialize error
724: -- message list

Line 721: -- if set to FND_API.G_TRUE

717: -- p_api_version
718: -- API version number (current version is 1.0)
719: -- p_init_msg_list (optional, default FND_API.G_FALSE)
720: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
721: -- if set to FND_API.G_TRUE
722: -- initialize error message list
723: -- if set to FND_API.G_FALSE - not initialize error
724: -- message list
725: -- p_commit (optional, default FND_API.G_FALSE)

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

719: -- p_init_msg_list (optional, default FND_API.G_FALSE)
720: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
721: -- if set to FND_API.G_TRUE
722: -- initialize error message list
723: -- if set to FND_API.G_FALSE - not initialize error
724: -- message list
725: -- p_commit (optional, default FND_API.G_FALSE)
726: -- whether or not to commit the changes to database
727: -- p_source_item_id Source Item id (can also be a container Item) - Required Value

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

721: -- if set to FND_API.G_TRUE
722: -- initialize error message list
723: -- if set to FND_API.G_FALSE - not initialize error
724: -- message list
725: -- p_commit (optional, default FND_API.G_FALSE)
726: -- whether or not to commit the changes to database
727: -- p_source_item_id Source Item id (can also be a container Item) - Required Value
728: -- p_source_qty Source Item Qty - Required Value
729: -- p_source_qty_uom UOM of Source Item Qty - Required Value

Line 739: -- fnd_api.g_ret_sts_success;

735: --
736: -- Output Parameters
737: -- x_return_status
738: -- if the Container_Required_Qty API succeeds, the value is
739: -- fnd_api.g_ret_sts_success;
740: -- if there is an expected error, the value is
741: -- fnd_api.g_ret_sts_error;
742: -- if there is an unexpected error, the value is
743: -- fnd_api.g_ret_sts_unexp_error;

Line 741: -- fnd_api.g_ret_sts_error;

737: -- x_return_status
738: -- if the Container_Required_Qty API succeeds, the value is
739: -- fnd_api.g_ret_sts_success;
740: -- if there is an expected error, the value is
741: -- fnd_api.g_ret_sts_error;
742: -- if there is an unexpected error, the value is
743: -- fnd_api.g_ret_sts_unexp_error;
744: -- x_msg_count
745: -- if there is one or more errors, the number of error messages

Line 743: -- fnd_api.g_ret_sts_unexp_error;

739: -- fnd_api.g_ret_sts_success;
740: -- if there is an expected error, the value is
741: -- fnd_api.g_ret_sts_error;
742: -- if there is an unexpected error, the value is
743: -- fnd_api.g_ret_sts_unexp_error;
744: -- x_msg_count
745: -- if there is one or more errors, the number of error messages
746: -- in the buffer
747: -- x_msg_data

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

755: /***********************************************************************/
756:
757: PROCEDURE Container_Required_Qty
758: ( p_api_version IN NUMBER ,
759: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
760: p_commit IN VARCHAR2 := fnd_api.g_false ,
761: x_return_status OUT NOCOPY VARCHAR2 ,
762: x_msg_count OUT NOCOPY NUMBER ,
763: x_msg_data OUT NOCOPY VARCHAR2 ,

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

756:
757: PROCEDURE Container_Required_Qty
758: ( p_api_version IN NUMBER ,
759: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
760: p_commit IN VARCHAR2 := fnd_api.g_false ,
761: x_return_status OUT NOCOPY VARCHAR2 ,
762: x_msg_count OUT NOCOPY NUMBER ,
763: x_msg_data OUT NOCOPY VARCHAR2 ,
764: p_source_item_id IN NUMBER ,

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

788: --
789: -- Input Parameters
790: -- p_api_version
791: -- API version number (current version is 1.0)
792: -- p_init_msg_list (optional, default FND_API.G_FALSE)
793: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
794: -- if set to FND_API.G_TRUE
795: -- initialize error message list
796: -- if set to FND_API.G_FALSE - do not initialize error

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

789: -- Input Parameters
790: -- p_api_version
791: -- API version number (current version is 1.0)
792: -- p_init_msg_list (optional, default FND_API.G_FALSE)
793: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
794: -- if set to FND_API.G_TRUE
795: -- initialize error message list
796: -- if set to FND_API.G_FALSE - do not initialize error
797: -- message list

Line 794: -- if set to FND_API.G_TRUE

790: -- p_api_version
791: -- API version number (current version is 1.0)
792: -- p_init_msg_list (optional, default FND_API.G_FALSE)
793: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
794: -- if set to FND_API.G_TRUE
795: -- initialize error message list
796: -- if set to FND_API.G_FALSE - do not initialize error
797: -- message list
798: -- p_commit (optional, default FND_API.G_FALSE)

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

792: -- p_init_msg_list (optional, default FND_API.G_FALSE)
793: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
794: -- if set to FND_API.G_TRUE
795: -- initialize error message list
796: -- if set to FND_API.G_FALSE - do not initialize error
797: -- message list
798: -- p_commit (optional, default FND_API.G_FALSE)
799: -- whether or not to commit the changes to database
800: -- p_organization_id Organization of the LPN - Required

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

794: -- if set to FND_API.G_TRUE
795: -- initialize error message list
796: -- if set to FND_API.G_FALSE - do not initialize error
797: -- message list
798: -- p_commit (optional, default FND_API.G_FALSE)
799: -- whether or not to commit the changes to database
800: -- p_organization_id Organization of the LPN - Required
801: -- p_subinventory Subinventory - Defaults to NULL
802: -- p_locator_id Locator Id - Defaults to NULL

Line 826: -- fnd_api.g_ret_sts_success;

822: -- ERRBUF Concurrent program error buffer
823: -- RETCODE Concurrent program return code
824: -- x_return_status
825: -- if the Prepack_LPN API succeeds, the value is
826: -- fnd_api.g_ret_sts_success;
827: -- if there is an expected error, the value is
828: -- fnd_api.g_ret_sts_error;
829: -- if there is an unexpected error, the value is
830: -- fnd_api.g_ret_sts_unexp_error;

Line 828: -- fnd_api.g_ret_sts_error;

824: -- x_return_status
825: -- if the Prepack_LPN API succeeds, the value is
826: -- fnd_api.g_ret_sts_success;
827: -- if there is an expected error, the value is
828: -- fnd_api.g_ret_sts_error;
829: -- if there is an unexpected error, the value is
830: -- fnd_api.g_ret_sts_unexp_error;
831: -- x_msg_count
832: -- if there is one or more errors, the number of error messages

Line 830: -- fnd_api.g_ret_sts_unexp_error;

826: -- fnd_api.g_ret_sts_success;
827: -- if there is an expected error, the value is
828: -- fnd_api.g_ret_sts_error;
829: -- if there is an unexpected error, the value is
830: -- fnd_api.g_ret_sts_unexp_error;
831: -- x_msg_count
832: -- if there is one or more errors, the number of error messages
833: -- in the buffer
834: -- x_msg_data

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

859: p_cont_revision IN VARCHAR2 := NULL ,
860: p_cont_lot_number IN VARCHAR2 := NULL ,
861: p_cont_serial_number_from IN VARCHAR2 := NULL ,
862: p_cont_serial_number_to IN VARCHAR2 := NULL ,
863: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
864: p_print_label IN NUMBER := fnd_api.g_miss_num ,
865: p_print_content_report IN NUMBER := fnd_api.g_miss_num
866: );
867:

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

860: p_cont_lot_number IN VARCHAR2 := NULL ,
861: p_cont_serial_number_from IN VARCHAR2 := NULL ,
862: p_cont_serial_number_to IN VARCHAR2 := NULL ,
863: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
864: p_print_label IN NUMBER := fnd_api.g_miss_num ,
865: p_print_content_report IN NUMBER := fnd_api.g_miss_num
866: );
867:
868: TYPE Transaction_History IS TABLE OF WMS_LPN_HISTORIES.lpn_history_id%TYPE

Line 865: p_print_content_report IN NUMBER := fnd_api.g_miss_num

861: p_cont_serial_number_from IN VARCHAR2 := NULL ,
862: p_cont_serial_number_to IN VARCHAR2 := NULL ,
863: p_lpn_sealed_flag IN NUMBER := fnd_api.g_miss_num ,
864: p_print_label IN NUMBER := fnd_api.g_miss_num ,
865: p_print_content_report IN NUMBER := fnd_api.g_miss_num
866: );
867:
868: TYPE Transaction_History IS TABLE OF WMS_LPN_HISTORIES.lpn_history_id%TYPE
869: INDEX BY BINARY_INTEGER;

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

925: -- End of comments
926:
927: PROCEDURE Merge_Up_LPN (
928: p_api_version IN NUMBER
929: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
930: , p_commit IN VARCHAR2 := fnd_api.g_false
931: , x_return_status OUT NOCOPY VARCHAR2
932: , x_msg_count OUT NOCOPY NUMBER
933: , x_msg_data OUT NOCOPY VARCHAR2

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

926:
927: PROCEDURE Merge_Up_LPN (
928: p_api_version IN NUMBER
929: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
930: , p_commit IN VARCHAR2 := fnd_api.g_false
931: , x_return_status OUT NOCOPY VARCHAR2
932: , x_msg_count OUT NOCOPY NUMBER
933: , x_msg_data OUT NOCOPY VARCHAR2
934: , p_organization_id IN NUMBER

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

968: -- End of comments
969:
970: PROCEDURE Break_Down_LPN (
971: p_api_version IN NUMBER
972: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
973: , p_commit IN VARCHAR2 := fnd_api.g_false
974: , x_return_status OUT NOCOPY VARCHAR2
975: , x_msg_count OUT NOCOPY NUMBER
976: , x_msg_data OUT NOCOPY VARCHAR2

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

969:
970: PROCEDURE Break_Down_LPN (
971: p_api_version IN NUMBER
972: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
973: , p_commit IN VARCHAR2 := fnd_api.g_false
974: , x_return_status OUT NOCOPY VARCHAR2
975: , x_msg_count OUT NOCOPY NUMBER
976: , x_msg_data OUT NOCOPY VARCHAR2
977: , p_organization_id IN NUMBER

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

998: -- End of comments
999:
1000: PROCEDURE Initialize_LPN (
1001: p_api_version IN NUMBER
1002: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1003: , p_commit IN VARCHAR2 := fnd_api.g_false
1004: , x_return_status OUT NOCOPY VARCHAR2
1005: , x_msg_count OUT NOCOPY NUMBER
1006: , x_msg_data OUT NOCOPY VARCHAR2

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

999:
1000: PROCEDURE Initialize_LPN (
1001: p_api_version IN NUMBER
1002: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1003: , p_commit IN VARCHAR2 := fnd_api.g_false
1004: , x_return_status OUT NOCOPY VARCHAR2
1005: , x_msg_count OUT NOCOPY NUMBER
1006: , x_msg_data OUT NOCOPY VARCHAR2
1007: , p_organization_id IN NUMBER

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

1010:
1011: -- For LPN reuse ER : 6845650
1012: PROCEDURE REUSE_LPNS (
1013: p_api_version IN NUMBER
1014: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1015: , p_commit IN VARCHAR2 := fnd_api.g_false
1016: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER

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

1011: -- For LPN reuse ER : 6845650
1012: PROCEDURE REUSE_LPNS (
1013: p_api_version IN NUMBER
1014: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1015: , p_commit IN VARCHAR2 := fnd_api.g_false
1016: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER
1019: , x_msg_data OUT NOCOPY VARCHAR2

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

1012: PROCEDURE REUSE_LPNS (
1013: p_api_version IN NUMBER
1014: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1015: , p_commit IN VARCHAR2 := fnd_api.g_false
1016: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER
1019: , x_msg_data OUT NOCOPY VARCHAR2
1020: , p_lpn_id IN NUMBER