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

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

187: --
188: -- Input Parameters
189: -- p_api_version (required) API version number (current version is 1.0)
190: -- p_init_msg_list (required)
191: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
192: -- if set to FND_API.G_TRUE - initialize error message list
193: -- if set to FND_API.G_FALSE - not initialize error message list
194: -- p_commit (required) whether or not to commit the changes to database
195: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE

Line 192: -- if set to FND_API.G_TRUE - initialize error message list

188: -- Input Parameters
189: -- p_api_version (required) API version number (current version is 1.0)
190: -- p_init_msg_list (required)
191: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
192: -- if set to FND_API.G_TRUE - initialize error message list
193: -- if set to FND_API.G_FALSE - not initialize error message list
194: -- p_commit (required) whether or not to commit the changes to database
195: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
196: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow

Line 193: -- if set to FND_API.G_FALSE - not initialize error message list

189: -- p_api_version (required) API version number (current version is 1.0)
190: -- p_init_msg_list (required)
191: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
192: -- if set to FND_API.G_TRUE - initialize error message list
193: -- if set to FND_API.G_FALSE - not initialize error message list
194: -- p_commit (required) whether or not to commit the changes to database
195: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
196: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
197: --

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

191: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
192: -- if set to FND_API.G_TRUE - initialize error message list
193: -- if set to FND_API.G_FALSE - not initialize error message list
194: -- p_commit (required) whether or not to commit the changes to database
195: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
196: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
197: --
198: -- IN OUT Parameters
199: -- p_lpn_table Table of LPNs to be created The API will create LPN IDs for

Line 226: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;

222: -- used for LPN historical and auditing purposes
223: --
224: -- Output Parameters
225: -- x_return_status
226: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
227: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
228: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
229: -- x_msg_count
230: -- if there is one or more errors, the number of error messages in the buffer

Line 227: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;

223: --
224: -- Output Parameters
225: -- x_return_status
226: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
227: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
228: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
229: -- x_msg_count
230: -- if there is one or more errors, the number of error messages in the buffer
231: -- x_msg_data

Line 228: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;

224: -- Output Parameters
225: -- x_return_status
226: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
227: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
228: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
229: -- x_msg_count
230: -- if there is one or more errors, the number of error messages in the buffer
231: -- x_msg_data
232: -- if there is one and only one error, the error message

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

251: --
252: -- Input Parameters
253: -- p_api_version (required) API version number (current version is 1.0)
254: -- p_init_msg_list (required)
255: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
256: -- if set to FND_API.G_TRUE - initialize error message list
257: -- if set to FND_API.G_FALSE - not initialize error message list
258: -- p_commit (required) whether or not to commit the changes to database
259: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE

Line 256: -- if set to FND_API.G_TRUE - initialize error message list

252: -- Input Parameters
253: -- p_api_version (required) API version number (current version is 1.0)
254: -- p_init_msg_list (required)
255: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
256: -- if set to FND_API.G_TRUE - initialize error message list
257: -- if set to FND_API.G_FALSE - not initialize error message list
258: -- p_commit (required) whether or not to commit the changes to database
259: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
260: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow

Line 257: -- if set to FND_API.G_FALSE - not initialize error message list

253: -- p_api_version (required) API version number (current version is 1.0)
254: -- p_init_msg_list (required)
255: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
256: -- if set to FND_API.G_TRUE - initialize error message list
257: -- if set to FND_API.G_FALSE - not initialize error message list
258: -- p_commit (required) whether or not to commit the changes to database
259: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
260: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
261: -- p_lpn_attributes Record of atrributes to be added to each LPN created aand inserted into

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

255: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
256: -- if set to FND_API.G_TRUE - initialize error message list
257: -- if set to FND_API.G_FALSE - not initialize error message list
258: -- p_commit (required) whether or not to commit the changes to database
259: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
260: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
261: -- p_lpn_attributes Record of atrributes to be added to each LPN created aand inserted into
262: -- WMS_License_Plate_Numbers. LPN record type is a generic LPN record type
263: -- and not all attributes listed are allowed while creating LPNs.

Line 291: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;

287: -- range is supported.
288: --
289: -- Output Parameters
290: -- x_return_status
291: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
292: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
293: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
294: -- x_msg_count
295: -- if there is one or more errors, the number of error messages in the buffer

Line 292: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;

288: --
289: -- Output Parameters
290: -- x_return_status
291: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
292: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
293: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
294: -- x_msg_count
295: -- if there is one or more errors, the number of error messages in the buffer
296: -- x_msg_data

Line 293: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;

289: -- Output Parameters
290: -- x_return_status
291: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
292: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
293: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
294: -- x_msg_count
295: -- if there is one or more errors, the number of error messages in the buffer
296: -- x_msg_data
297: -- if there is one and only one error, the error message

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

326: --
327: -- Input Parameters
328: -- p_api_version (required) API version number (current version is 1.0)
329: -- p_init_msg_list (required)
330: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
331: -- if set to FND_API.G_TRUE - initialize error message list
332: -- if set to FND_API.G_FALSE - not initialize error message list
333: -- p_commit (required) whether or not to commit the changes to database
334: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE

Line 331: -- if set to FND_API.G_TRUE - initialize error message list

327: -- Input Parameters
328: -- p_api_version (required) API version number (current version is 1.0)
329: -- p_init_msg_list (required)
330: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
331: -- if set to FND_API.G_TRUE - initialize error message list
332: -- if set to FND_API.G_FALSE - not initialize error message list
333: -- p_commit (required) whether or not to commit the changes to database
334: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
335: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow

Line 332: -- if set to FND_API.G_FALSE - not initialize error message list

328: -- p_api_version (required) API version number (current version is 1.0)
329: -- p_init_msg_list (required)
330: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
331: -- if set to FND_API.G_TRUE - initialize error message list
332: -- if set to FND_API.G_FALSE - not initialize error message list
333: -- p_commit (required) whether or not to commit the changes to database
334: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
335: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
336: -- p_lpn_table Table of LPN records to be modified.

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

330: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
331: -- if set to FND_API.G_TRUE - initialize error message list
332: -- if set to FND_API.G_FALSE - not initialize error message list
333: -- p_commit (required) whether or not to commit the changes to database
334: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
335: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
336: -- p_lpn_table Table of LPN records to be modified.
337: -- WMS_License_Plate_Numbers. LPN record type is a generic LPN record type
338: -- and not all attributes listed are allowed while creating LPNs.

Line 369: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;

365: -- used for LPN historical and auditing purposes
366: --
367: -- Output Parameters
368: -- x_return_status
369: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
370: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
371: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
372: -- x_msg_count
373: -- if there is one or more errors, the number of error messages in the buffer

Line 370: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;

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

Line 371: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;

367: -- Output Parameters
368: -- x_return_status
369: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
370: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
371: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
372: -- x_msg_count
373: -- if there is one or more errors, the number of error messages in the buffer
374: -- x_msg_data
375: -- if there is one and only one error, the error message

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

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

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

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

Line 401: -- if set to FND_API.G_TRUE

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

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

399: -- p_init_msg_list (optional, default FND_API.G_FALSE)
400: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
401: -- if set to FND_API.G_TRUE
402: -- initialize error message list
403: -- if set to FND_API.G_FALSE - not initialize error
404: -- message list
405: -- p_commit (optional, default FND_API.G_FALSE)
406: -- whether or not to commit the changes to database
407: -- p_organization_id Organization Id - Required Value

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

401: -- if set to FND_API.G_TRUE
402: -- initialize error message list
403: -- if set to FND_API.G_FALSE - not initialize error
404: -- message list
405: -- p_commit (optional, default FND_API.G_FALSE)
406: -- whether or not to commit the changes to database
407: -- p_organization_id Organization Id - Required Value
408: -- p_container_item_id Container Item Id - Defaults to NULL
409: -- p_revision Revision - Defaults to NULL

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

471: --
472: -- Input Parameters
473: -- p_api_version
474: -- API version number (current version is 1.0)
475: -- p_init_msg_list (optional, default FND_API.G_FALSE)
476: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
477: -- if set to FND_API.G_TRUE
478: -- initialize error message list
479: -- if set to FND_API.G_FALSE - not initialize error

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

472: -- Input Parameters
473: -- p_api_version
474: -- API version number (current version is 1.0)
475: -- p_init_msg_list (optional, default FND_API.G_FALSE)
476: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
477: -- if set to FND_API.G_TRUE
478: -- initialize error message list
479: -- if set to FND_API.G_FALSE - not initialize error
480: -- message list

Line 477: -- if set to FND_API.G_TRUE

473: -- p_api_version
474: -- API version number (current version is 1.0)
475: -- p_init_msg_list (optional, default FND_API.G_FALSE)
476: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
477: -- if set to FND_API.G_TRUE
478: -- initialize error message list
479: -- if set to FND_API.G_FALSE - not initialize error
480: -- message list
481: -- p_commit (optional, default FND_API.G_FALSE)

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

475: -- p_init_msg_list (optional, default FND_API.G_FALSE)
476: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
477: -- if set to FND_API.G_TRUE
478: -- initialize error message list
479: -- if set to FND_API.G_FALSE - not initialize error
480: -- message list
481: -- p_commit (optional, default FND_API.G_FALSE)
482: -- whether or not to commit the changes to database
483: -- p_validation_level (optional), determines if full validation or

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

477: -- if set to FND_API.G_TRUE
478: -- initialize error message list
479: -- if set to FND_API.G_FALSE - not initialize error
480: -- message list
481: -- p_commit (optional, default FND_API.G_FALSE)
482: -- whether or not to commit the changes to database
483: -- p_validation_level (optional), determines if full validation or
484: -- no validation will be performed
485: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 485: -- defaults to FND_API.G_VALID_LEVEL_FULL

481: -- p_commit (optional, default FND_API.G_FALSE)
482: -- whether or not to commit the changes to database
483: -- p_validation_level (optional), determines if full validation or
484: -- no validation will be performed
485: -- defaults to FND_API.G_VALID_LEVEL_FULL
486: -- FND_API.G_VALID_LEVEL_NONE is the other value
487: -- p_organization_id Organization Id - Required Value
488: -- p_container_item_id Container Item Id - Defaults to NULL
489: -- p_revision Revision - Defaults to NULL

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

482: -- whether or not to commit the changes to database
483: -- p_validation_level (optional), determines if full validation or
484: -- no validation will be performed
485: -- defaults to FND_API.G_VALID_LEVEL_FULL
486: -- FND_API.G_VALID_LEVEL_NONE is the other value
487: -- p_organization_id Organization Id - Required Value
488: -- p_container_item_id Container Item Id - Defaults to NULL
489: -- p_revision Revision - Defaults to NULL
490: -- p_lot_number Lot Number - Defaults to NULL

Line 513: -- fnd_api.g_ret_sts_success;

509: --
510: -- Output Parameters
511: -- x_return_status
512: -- if the Generate_LPN API succeeds, the value is
513: -- fnd_api.g_ret_sts_success;
514: -- if there is an expected error, the value is
515: -- fnd_api.g_ret_sts_error;
516: -- if there is an unexpected error, the value is
517: -- fnd_api.g_ret_sts_unexp_error;

Line 515: -- fnd_api.g_ret_sts_error;

511: -- x_return_status
512: -- if the Generate_LPN API succeeds, the value is
513: -- fnd_api.g_ret_sts_success;
514: -- if there is an expected error, the value is
515: -- fnd_api.g_ret_sts_error;
516: -- if there is an unexpected error, the value is
517: -- fnd_api.g_ret_sts_unexp_error;
518: -- x_msg_count
519: -- if there is one or more errors, the number of error messages

Line 517: -- fnd_api.g_ret_sts_unexp_error;

513: -- fnd_api.g_ret_sts_success;
514: -- if there is an expected error, the value is
515: -- fnd_api.g_ret_sts_error;
516: -- if there is an unexpected error, the value is
517: -- fnd_api.g_ret_sts_unexp_error;
518: -- x_msg_count
519: -- if there is one or more errors, the number of error messages
520: -- in the buffer
521: -- x_msg_data

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

519: -- if there is one or more errors, the number of error messages
520: -- in the buffer
521: -- x_msg_data
522: -- if there is one and only one error, the error message
523: -- (See fnd_api package for more details about the above output parameters)
524: --
525: -- p_lpn_id_out - Outputs the generated LPN ID
526: -- if only one LPN is requested to be generated
527: -- p_lpn_out - Outputs the generated license plate number

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

530: -- table WMS_LPN_PROCESS_TEMP
531:
532: PROCEDURE Generate_LPN (
533: p_api_version IN NUMBER
534: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
535: , p_commit IN VARCHAR2 := fnd_api.g_false
536: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
537: , x_return_status OUT NOCOPY VARCHAR2
538: , x_msg_count OUT NOCOPY NUMBER

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

531:
532: PROCEDURE Generate_LPN (
533: p_api_version IN NUMBER
534: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
535: , p_commit IN VARCHAR2 := fnd_api.g_false
536: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
537: , x_return_status OUT NOCOPY VARCHAR2
538: , x_msg_count OUT NOCOPY NUMBER
539: , x_msg_data OUT NOCOPY VARCHAR2

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

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

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

572: --
573: -- Input Parameters
574: -- p_api_version
575: -- API version number (current version is 1.0)
576: -- p_init_msg_list (optional, default FND_API.G_FALSE)
577: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
578: -- if set to FND_API.G_TRUE
579: -- initialize error message list
580: -- if set to FND_API.G_FALSE - not initialize error

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

573: -- Input Parameters
574: -- p_api_version
575: -- API version number (current version is 1.0)
576: -- p_init_msg_list (optional, default FND_API.G_FALSE)
577: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
578: -- if set to FND_API.G_TRUE
579: -- initialize error message list
580: -- if set to FND_API.G_FALSE - not initialize error
581: -- message list

Line 578: -- if set to FND_API.G_TRUE

574: -- p_api_version
575: -- API version number (current version is 1.0)
576: -- p_init_msg_list (optional, default FND_API.G_FALSE)
577: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
578: -- if set to FND_API.G_TRUE
579: -- initialize error message list
580: -- if set to FND_API.G_FALSE - not initialize error
581: -- message list
582: -- p_commit (optional, default FND_API.G_FALSE)

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

576: -- p_init_msg_list (optional, default FND_API.G_FALSE)
577: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
578: -- if set to FND_API.G_TRUE
579: -- initialize error message list
580: -- if set to FND_API.G_FALSE - not initialize error
581: -- message list
582: -- p_commit (optional, default FND_API.G_FALSE)
583: -- whether or not to commit the changes to database
584: -- p_validation_level (optional), determines if full validation or

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

578: -- if set to FND_API.G_TRUE
579: -- initialize error message list
580: -- if set to FND_API.G_FALSE - not initialize error
581: -- message list
582: -- p_commit (optional, default FND_API.G_FALSE)
583: -- whether or not to commit the changes to database
584: -- p_validation_level (optional), determines if full validation or
585: -- no validation will be performed
586: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 586: -- defaults to FND_API.G_VALID_LEVEL_FULL

582: -- p_commit (optional, default FND_API.G_FALSE)
583: -- whether or not to commit the changes to database
584: -- p_validation_level (optional), determines if full validation or
585: -- no validation will be performed
586: -- defaults to FND_API.G_VALID_LEVEL_FULL
587: -- FND_API.G_VALID_LEVEL_NONE is the other value
588: -- p_lpn_id License Plate Number Identifier - Required Value
589: -- p_container_item_id Container Item Id - Required Value
590: -- p_lot_number Lot Number - Defaults to NULL

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

583: -- whether or not to commit the changes to database
584: -- p_validation_level (optional), determines if full validation or
585: -- no validation will be performed
586: -- defaults to FND_API.G_VALID_LEVEL_FULL
587: -- FND_API.G_VALID_LEVEL_NONE is the other value
588: -- p_lpn_id License Plate Number Identifier - Required Value
589: -- p_container_item_id Container Item Id - Required Value
590: -- p_lot_number Lot Number - Defaults to NULL
591: -- p_revision Revision - Defaults to NULL

Line 607: -- fnd_api.g_ret_sts_success;

603: --
604: -- Output Parameters
605: -- x_return_status
606: -- if the Associate_LPN API succeeds, the value is
607: -- fnd_api.g_ret_sts_success;
608: -- if there is an expected error, the value is
609: -- fnd_api.g_ret_sts_error;
610: -- if there is an unexpected error, the value is
611: -- fnd_api.g_ret_sts_unexp_error;

Line 609: -- fnd_api.g_ret_sts_error;

605: -- x_return_status
606: -- if the Associate_LPN API succeeds, the value is
607: -- fnd_api.g_ret_sts_success;
608: -- if there is an expected error, the value is
609: -- fnd_api.g_ret_sts_error;
610: -- if there is an unexpected error, the value is
611: -- fnd_api.g_ret_sts_unexp_error;
612: -- x_msg_count
613: -- if there is one or more errors, the number of error messages

Line 611: -- fnd_api.g_ret_sts_unexp_error;

607: -- fnd_api.g_ret_sts_success;
608: -- if there is an expected error, the value is
609: -- fnd_api.g_ret_sts_error;
610: -- if there is an unexpected error, the value is
611: -- fnd_api.g_ret_sts_unexp_error;
612: -- x_msg_count
613: -- if there is one or more errors, the number of error messages
614: -- in the buffer
615: -- x_msg_data

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

616: -- if there is one and only one error, the error message
617:
618: PROCEDURE Associate_LPN(
619: p_api_version IN NUMBER
620: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
621: , p_commit IN VARCHAR2 := fnd_api.g_false
622: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
623: , x_return_status OUT NOCOPY VARCHAR2
624: , x_msg_count OUT NOCOPY NUMBER

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

617:
618: PROCEDURE Associate_LPN(
619: p_api_version IN NUMBER
620: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
621: , p_commit IN VARCHAR2 := fnd_api.g_false
622: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
623: , x_return_status OUT NOCOPY VARCHAR2
624: , x_msg_count OUT NOCOPY NUMBER
625: , x_msg_data OUT NOCOPY VARCHAR2

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

618: PROCEDURE Associate_LPN(
619: p_api_version IN NUMBER
620: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
621: , p_commit IN VARCHAR2 := fnd_api.g_false
622: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
623: , x_return_status OUT NOCOPY VARCHAR2
624: , x_msg_count OUT NOCOPY NUMBER
625: , x_msg_data OUT NOCOPY VARCHAR2
626: , p_lpn_id IN NUMBER

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

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

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

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

Line 656: -- if set to FND_API.G_TRUE

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

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

654: -- p_init_msg_list (optional, default FND_API.G_FALSE)
655: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
656: -- if set to FND_API.G_TRUE
657: -- initialize error message list
658: -- if set to FND_API.G_FALSE - not initialize error
659: -- message list
660: -- p_commit (optional, default FND_API.G_FALSE)
661: -- whether or not to commit the changes to database
662: -- p_validation_level (optional), determines if full validation or

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

656: -- if set to FND_API.G_TRUE
657: -- initialize error message list
658: -- if set to FND_API.G_FALSE - not initialize error
659: -- message list
660: -- p_commit (optional, default FND_API.G_FALSE)
661: -- whether or not to commit the changes to database
662: -- p_validation_level (optional), determines if full validation or
663: -- no validation will be performed
664: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 664: -- defaults to FND_API.G_VALID_LEVEL_FULL

660: -- p_commit (optional, default FND_API.G_FALSE)
661: -- whether or not to commit the changes to database
662: -- p_validation_level (optional), determines if full validation or
663: -- no validation will be performed
664: -- defaults to FND_API.G_VALID_LEVEL_FULL
665: -- FND_API.G_VALID_LEVEL_NONE is the other value
666: -- p_lpn License Plate Number Identifier - Required Value
667: -- p_organization_id Organization Id - Required Value
668: -- p_container_item_id Container Item Id - Defaults to NULL

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

661: -- whether or not to commit the changes to database
662: -- p_validation_level (optional), determines if full validation or
663: -- no validation will be performed
664: -- defaults to FND_API.G_VALID_LEVEL_FULL
665: -- FND_API.G_VALID_LEVEL_NONE is the other value
666: -- p_lpn License Plate Number Identifier - Required Value
667: -- p_organization_id Organization Id - Required Value
668: -- p_container_item_id Container Item Id - Defaults to NULL
669: -- p_revision Revision - Defaults to NULL

Line 688: -- fnd_api.g_ret_sts_success;

684: --
685: -- Output Parameters
686: -- x_return_status
687: -- if the Create_LPN API succeeds, the value is
688: -- fnd_api.g_ret_sts_success;
689: -- if there is an expected error, the value is
690: -- fnd_api.g_ret_sts_error;
691: -- if there is an unexpected error, the value is
692: -- fnd_api.g_ret_sts_unexp_error;

Line 690: -- fnd_api.g_ret_sts_error;

686: -- x_return_status
687: -- if the Create_LPN API succeeds, the value is
688: -- fnd_api.g_ret_sts_success;
689: -- if there is an expected error, the value is
690: -- fnd_api.g_ret_sts_error;
691: -- if there is an unexpected error, the value is
692: -- fnd_api.g_ret_sts_unexp_error;
693: -- x_msg_count
694: -- if there is one or more errors, the number of error messages

Line 692: -- fnd_api.g_ret_sts_unexp_error;

688: -- fnd_api.g_ret_sts_success;
689: -- if there is an expected error, the value is
690: -- fnd_api.g_ret_sts_error;
691: -- if there is an unexpected error, the value is
692: -- fnd_api.g_ret_sts_unexp_error;
693: -- x_msg_count
694: -- if there is one or more errors, the number of error messages
695: -- in the buffer
696: -- x_msg_data

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

699: --
700:
701: PROCEDURE Create_LPN (
702: p_api_version IN NUMBER
703: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
704: , p_commit IN VARCHAR2 := fnd_api.g_false
705: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
706: , x_return_status OUT NOCOPY VARCHAR2
707: , x_msg_count OUT NOCOPY NUMBER

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

700:
701: PROCEDURE Create_LPN (
702: p_api_version IN NUMBER
703: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
704: , p_commit IN VARCHAR2 := fnd_api.g_false
705: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
706: , x_return_status OUT NOCOPY VARCHAR2
707: , x_msg_count OUT NOCOPY NUMBER
708: , x_msg_data OUT NOCOPY VARCHAR2

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

701: PROCEDURE Create_LPN (
702: p_api_version IN NUMBER
703: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
704: , p_commit IN VARCHAR2 := fnd_api.g_false
705: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
706: , x_return_status OUT NOCOPY VARCHAR2
707: , x_msg_count OUT NOCOPY NUMBER
708: , x_msg_data OUT NOCOPY VARCHAR2
709: , p_lpn IN VARCHAR2

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

742: --
743: -- Input Parameters
744: -- p_api_version
745: -- API version number (current version is 1.0)
746: -- p_init_msg_list (optional, default FND_API.G_FALSE)
747: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
748: -- if set to FND_API.G_TRUE
749: -- initialize error message list
750: -- if set to FND_API.G_FALSE - not initialize error

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

743: -- Input Parameters
744: -- p_api_version
745: -- API version number (current version is 1.0)
746: -- p_init_msg_list (optional, default FND_API.G_FALSE)
747: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
748: -- if set to FND_API.G_TRUE
749: -- initialize error message list
750: -- if set to FND_API.G_FALSE - not initialize error
751: -- message list

Line 748: -- if set to FND_API.G_TRUE

744: -- p_api_version
745: -- API version number (current version is 1.0)
746: -- p_init_msg_list (optional, default FND_API.G_FALSE)
747: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
748: -- if set to FND_API.G_TRUE
749: -- initialize error message list
750: -- if set to FND_API.G_FALSE - not initialize error
751: -- message list
752: -- p_commit (optional, default FND_API.G_FALSE)

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

746: -- p_init_msg_list (optional, default FND_API.G_FALSE)
747: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
748: -- if set to FND_API.G_TRUE
749: -- initialize error message list
750: -- if set to FND_API.G_FALSE - not initialize error
751: -- message list
752: -- p_commit (optional, default FND_API.G_FALSE)
753: -- whether or not to commit the changes to database
754: -- p_validation_level (optional), determines if full validation or

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

748: -- if set to FND_API.G_TRUE
749: -- initialize error message list
750: -- if set to FND_API.G_FALSE - not initialize error
751: -- message list
752: -- p_commit (optional, default FND_API.G_FALSE)
753: -- whether or not to commit the changes to database
754: -- p_validation_level (optional), determines if full validation or
755: -- no validation will be performed
756: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 756: -- defaults to FND_API.G_VALID_LEVEL_FULL

752: -- p_commit (optional, default FND_API.G_FALSE)
753: -- whether or not to commit the changes to database
754: -- p_validation_level (optional), determines if full validation or
755: -- no validation will be performed
756: -- defaults to FND_API.G_VALID_LEVEL_FULL
757: -- FND_API.G_VALID_LEVEL_NONE is the other value
758: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
759: -- Stores the information for the fields of the LPN record that
760: -- the user desires to modify

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

753: -- whether or not to commit the changes to database
754: -- p_validation_level (optional), determines if full validation or
755: -- no validation will be performed
756: -- defaults to FND_API.G_VALID_LEVEL_FULL
757: -- FND_API.G_VALID_LEVEL_NONE is the other value
758: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
759: -- Stores the information for the fields of the LPN record that
760: -- the user desires to modify
761: -- p_source_type_id Source type ID for the source transaction

Line 771: -- fnd_api.g_ret_sts_success;

767: --
768: -- Output Parameters
769: -- x_return_status
770: -- if the Modify_LPN API succeeds, the value is
771: -- fnd_api.g_ret_sts_success;
772: -- if there is an expected error, the value is
773: -- fnd_api.g_ret_sts_error;
774: -- if there is an unexpected error, the value is
775: -- fnd_api.g_ret_sts_unexp_error;

Line 773: -- fnd_api.g_ret_sts_error;

769: -- x_return_status
770: -- if the Modify_LPN API succeeds, the value is
771: -- fnd_api.g_ret_sts_success;
772: -- if there is an expected error, the value is
773: -- fnd_api.g_ret_sts_error;
774: -- if there is an unexpected error, the value is
775: -- fnd_api.g_ret_sts_unexp_error;
776: -- x_msg_count
777: -- if there is one or more errors, the number of error messages

Line 775: -- fnd_api.g_ret_sts_unexp_error;

771: -- fnd_api.g_ret_sts_success;
772: -- if there is an expected error, the value is
773: -- fnd_api.g_ret_sts_error;
774: -- if there is an unexpected error, the value is
775: -- fnd_api.g_ret_sts_unexp_error;
776: -- x_msg_count
777: -- if there is one or more errors, the number of error messages
778: -- in the buffer
779: -- x_msg_data

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

780: -- if there is one and only one error, the error message
781:
782: PROCEDURE Modify_LPN (
783: p_api_version IN NUMBER
784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
785: , p_commit IN VARCHAR2 := fnd_api.g_false
786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
787: , x_return_status OUT NOCOPY VARCHAR2
788: , x_msg_count OUT NOCOPY NUMBER

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

781:
782: PROCEDURE Modify_LPN (
783: p_api_version IN NUMBER
784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
785: , p_commit IN VARCHAR2 := fnd_api.g_false
786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
787: , x_return_status OUT NOCOPY VARCHAR2
788: , x_msg_count OUT NOCOPY NUMBER
789: , x_msg_data OUT NOCOPY VARCHAR2

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

782: PROCEDURE Modify_LPN (
783: p_api_version IN NUMBER
784: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
785: , p_commit IN VARCHAR2 := fnd_api.g_false
786: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
787: , x_return_status OUT NOCOPY VARCHAR2
788: , x_msg_count OUT NOCOPY NUMBER
789: , x_msg_data OUT NOCOPY VARCHAR2
790: , p_lpn IN WMS_CONTAINER_PUB.LPN

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

792: );
793:
794: PROCEDURE Modify_LPN_Wrapper(
795: p_api_version IN NUMBER
796: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
797: , p_commit IN VARCHAR2 := fnd_api.g_false
798: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
799: , x_return_status OUT NOCOPY VARCHAR2
800: , x_msg_count OUT NOCOPY NUMBER

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

793:
794: PROCEDURE Modify_LPN_Wrapper(
795: p_api_version IN NUMBER
796: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
797: , p_commit IN VARCHAR2 := fnd_api.g_false
798: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
799: , x_return_status OUT NOCOPY VARCHAR2
800: , x_msg_count OUT NOCOPY NUMBER
801: , x_msg_data OUT NOCOPY VARCHAR2

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

794: PROCEDURE Modify_LPN_Wrapper(
795: p_api_version IN NUMBER
796: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
797: , p_commit IN VARCHAR2 := fnd_api.g_false
798: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
799: , x_return_status OUT NOCOPY VARCHAR2
800: , x_msg_count OUT NOCOPY NUMBER
801: , x_msg_data OUT NOCOPY VARCHAR2
802: , p_lpn_id IN NUMBER

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

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

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

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

Line 836: -- if set to FND_API.G_TRUE

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

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

834: -- p_init_msg_list (optional, default FND_API.G_FALSE)
835: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
836: -- if set to FND_API.G_TRUE
837: -- initialize error message list
838: -- if set to FND_API.G_FALSE - not initialize error
839: -- message list
840: -- p_commit (optional, default FND_API.G_FALSE)
841: -- whether or not to commit the changes to database
842: -- p_validation_level (optional), determines if full validation or

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

836: -- if set to FND_API.G_TRUE
837: -- initialize error message list
838: -- if set to FND_API.G_FALSE - not initialize error
839: -- message list
840: -- p_commit (optional, default FND_API.G_FALSE)
841: -- whether or not to commit the changes to database
842: -- p_validation_level (optional), determines if full validation or
843: -- no validation will be performed
844: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 844: -- defaults to FND_API.G_VALID_LEVEL_FULL

840: -- p_commit (optional, default FND_API.G_FALSE)
841: -- whether or not to commit the changes to database
842: -- p_validation_level (optional), determines if full validation or
843: -- no validation will be performed
844: -- defaults to FND_API.G_VALID_LEVEL_FULL
845: -- FND_API.G_VALID_LEVEL_NONE is the other value
846: -- p_lpn_id Parent License Plate Number Identifier - Required Value
847: -- p_content_lpn_id Content LPN ID
848: -- p_content_item_id Content Item ID - Defaults to NULL

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

841: -- whether or not to commit the changes to database
842: -- p_validation_level (optional), determines if full validation or
843: -- no validation will be performed
844: -- defaults to FND_API.G_VALID_LEVEL_FULL
845: -- FND_API.G_VALID_LEVEL_NONE is the other value
846: -- p_lpn_id Parent License Plate Number Identifier - Required Value
847: -- p_content_lpn_id Content LPN ID
848: -- p_content_item_id Content Item ID - Defaults to NULL
849: -- p_content_item_desc Content Item Description - Defaults to NULL

Line 895: -- fnd_api.g_ret_sts_success;

891: -- 1 = Yes, 2 = No Defaults to 2 = No
892: -- OUT :
893: -- x_return_status
894: -- if the PackUnpack_Container API succeeds, the value is
895: -- fnd_api.g_ret_sts_success;
896: -- if there is an expected error, the value is
897: -- fnd_api.g_ret_sts_error;
898: -- if there is an unexpected error, the value is
899: -- fnd_api.g_ret_sts_unexp_error;

Line 897: -- fnd_api.g_ret_sts_error;

893: -- x_return_status
894: -- if the PackUnpack_Container API succeeds, the value is
895: -- fnd_api.g_ret_sts_success;
896: -- if there is an expected error, the value is
897: -- fnd_api.g_ret_sts_error;
898: -- if there is an unexpected error, the value is
899: -- fnd_api.g_ret_sts_unexp_error;
900: -- x_msg_count
901: -- if there is one or more errors, the number of error messages

Line 899: -- fnd_api.g_ret_sts_unexp_error;

895: -- fnd_api.g_ret_sts_success;
896: -- if there is an expected error, the value is
897: -- fnd_api.g_ret_sts_error;
898: -- if there is an unexpected error, the value is
899: -- fnd_api.g_ret_sts_unexp_error;
900: -- x_msg_count
901: -- if there is one or more errors, the number of error messages
902: -- in the buffer
903: -- x_msg_data

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

906: -- End of comments
907:
908: PROCEDURE PackUnpack_Container(
909: p_api_version IN NUMBER
910: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
911: , p_commit IN VARCHAR2 := fnd_api.g_false
912: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
913: , x_return_status OUT NOCOPY VARCHAR2
914: , x_msg_count OUT NOCOPY NUMBER

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

907:
908: PROCEDURE PackUnpack_Container(
909: p_api_version IN NUMBER
910: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
911: , p_commit IN VARCHAR2 := fnd_api.g_false
912: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
913: , x_return_status OUT NOCOPY VARCHAR2
914: , x_msg_count OUT NOCOPY NUMBER
915: , x_msg_data OUT NOCOPY VARCHAR2

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

908: PROCEDURE PackUnpack_Container(
909: p_api_version IN NUMBER
910: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
911: , p_commit IN VARCHAR2 := fnd_api.g_false
912: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
913: , x_return_status OUT NOCOPY VARCHAR2
914: , x_msg_count OUT NOCOPY NUMBER
915: , x_msg_data OUT NOCOPY VARCHAR2
916: , p_lpn_id IN NUMBER

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

958: --
959: -- Input Parameters
960: -- p_api_version
961: -- API version number (current version is 1.0)
962: -- p_init_msg_list (optional, default FND_API.G_FALSE)
963: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
964: -- if set to FND_API.G_TRUE
965: -- initialize error message list
966: -- if set to FND_API.G_FALSE - not initialize error

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

959: -- Input Parameters
960: -- p_api_version
961: -- API version number (current version is 1.0)
962: -- p_init_msg_list (optional, default FND_API.G_FALSE)
963: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
964: -- if set to FND_API.G_TRUE
965: -- initialize error message list
966: -- if set to FND_API.G_FALSE - not initialize error
967: -- message list

Line 964: -- if set to FND_API.G_TRUE

960: -- p_api_version
961: -- API version number (current version is 1.0)
962: -- p_init_msg_list (optional, default FND_API.G_FALSE)
963: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
964: -- if set to FND_API.G_TRUE
965: -- initialize error message list
966: -- if set to FND_API.G_FALSE - not initialize error
967: -- message list
968: -- p_commit (optional, default FND_API.G_FALSE)

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

962: -- p_init_msg_list (optional, default FND_API.G_FALSE)
963: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
964: -- if set to FND_API.G_TRUE
965: -- initialize error message list
966: -- if set to FND_API.G_FALSE - not initialize error
967: -- message list
968: -- p_commit (optional, default FND_API.G_FALSE)
969: -- whether or not to commit the changes to database
970: -- p_lpn_id License Plate Number Identifier - Required Value

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

964: -- if set to FND_API.G_TRUE
965: -- initialize error message list
966: -- if set to FND_API.G_FALSE - not initialize error
967: -- message list
968: -- p_commit (optional, default FND_API.G_FALSE)
969: -- whether or not to commit the changes to database
970: -- p_lpn_id License Plate Number Identifier - Required Value
971: -- p_content_lpn_id Content LPN Id - Defaults to NULL
972: -- p_content_item_id Content Item Id - Defaults to NULL

Line 985: -- fnd_api.g_ret_sts_success;

981: -- 1. Validate, 2. Update, 3. Validate and Update
982: -- Output Parameters
983: -- x_return_status
984: -- if the Validate_Update_Wt_Volume API succeeds, the value is
985: -- fnd_api.g_ret_sts_success;
986: -- if there is an expected error, the value is
987: -- fnd_api.g_ret_sts_error;
988: -- if there is an unexpected error, the value is
989: -- fnd_api.g_ret_sts_unexp_error;

Line 987: -- fnd_api.g_ret_sts_error;

983: -- x_return_status
984: -- if the Validate_Update_Wt_Volume API succeeds, the value is
985: -- fnd_api.g_ret_sts_success;
986: -- if there is an expected error, the value is
987: -- fnd_api.g_ret_sts_error;
988: -- if there is an unexpected error, the value is
989: -- fnd_api.g_ret_sts_unexp_error;
990: -- x_msg_count
991: -- if there is one or more errors, the number of error messages

Line 989: -- fnd_api.g_ret_sts_unexp_error;

985: -- fnd_api.g_ret_sts_success;
986: -- if there is an expected error, the value is
987: -- fnd_api.g_ret_sts_error;
988: -- if there is an unexpected error, the value is
989: -- fnd_api.g_ret_sts_unexp_error;
990: -- x_msg_count
991: -- if there is one or more errors, the number of error messages
992: -- in the buffer
993: -- x_msg_data

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

998: --
999:
1000: PROCEDURE Validate_Update_Wt_Volume(
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 Validate_Update_Wt_Volume(
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_lpn_id IN NUMBER

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

1029: --
1030: -- Input Parameters
1031: -- p_api_version
1032: -- API version number (current version is 1.0)
1033: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1034: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1035: -- if set to FND_API.G_TRUE
1036: -- initialize error message list
1037: -- if set to FND_API.G_FALSE - not initialize error

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

1030: -- Input Parameters
1031: -- p_api_version
1032: -- API version number (current version is 1.0)
1033: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1034: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1035: -- if set to FND_API.G_TRUE
1036: -- initialize error message list
1037: -- if set to FND_API.G_FALSE - not initialize error
1038: -- message list

Line 1035: -- if set to FND_API.G_TRUE

1031: -- p_api_version
1032: -- API version number (current version is 1.0)
1033: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1034: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1035: -- if set to FND_API.G_TRUE
1036: -- initialize error message list
1037: -- if set to FND_API.G_FALSE - not initialize error
1038: -- message list
1039: -- p_commit (optional, default FND_API.G_FALSE)

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

1033: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1034: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1035: -- if set to FND_API.G_TRUE
1036: -- initialize error message list
1037: -- if set to FND_API.G_FALSE - not initialize error
1038: -- message list
1039: -- p_commit (optional, default FND_API.G_FALSE)
1040: -- whether or not to commit the changes to database
1041: -- p_source_item_id Source Item id (can also be a container Item) - Required Value

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

1035: -- if set to FND_API.G_TRUE
1036: -- initialize error message list
1037: -- if set to FND_API.G_FALSE - not initialize error
1038: -- message list
1039: -- p_commit (optional, default FND_API.G_FALSE)
1040: -- whether or not to commit the changes to database
1041: -- p_source_item_id Source Item id (can also be a container Item) - Required Value
1042: -- p_source_qty Source Item Qty - Required Value
1043: -- p_source_qty_uom UOM of Source Item Qty - Required Value

Line 1053: -- fnd_api.g_ret_sts_success;

1049: --
1050: -- Output Parameters
1051: -- x_return_status
1052: -- if the Container_Required_Qty API succeeds, the value is
1053: -- fnd_api.g_ret_sts_success;
1054: -- if there is an expected error, the value is
1055: -- fnd_api.g_ret_sts_error;
1056: -- if there is an unexpected error, the value is
1057: -- fnd_api.g_ret_sts_unexp_error;

Line 1055: -- fnd_api.g_ret_sts_error;

1051: -- x_return_status
1052: -- if the Container_Required_Qty API succeeds, the value is
1053: -- fnd_api.g_ret_sts_success;
1054: -- if there is an expected error, the value is
1055: -- fnd_api.g_ret_sts_error;
1056: -- if there is an unexpected error, the value is
1057: -- fnd_api.g_ret_sts_unexp_error;
1058: -- x_msg_count
1059: -- if there is one or more errors, the number of error messages

Line 1057: -- fnd_api.g_ret_sts_unexp_error;

1053: -- fnd_api.g_ret_sts_success;
1054: -- if there is an expected error, the value is
1055: -- fnd_api.g_ret_sts_error;
1056: -- if there is an unexpected error, the value is
1057: -- fnd_api.g_ret_sts_unexp_error;
1058: -- x_msg_count
1059: -- if there is one or more errors, the number of error messages
1060: -- in the buffer
1061: -- x_msg_data

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

1064: -- p_qty_required Required Container Quantity
1065:
1066: PROCEDURE Container_Required_Qty(
1067: p_api_version IN NUMBER
1068: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1069: , p_commit IN VARCHAR2 := fnd_api.g_false
1070: , x_return_status OUT NOCOPY VARCHAR2
1071: , x_msg_count OUT NOCOPY NUMBER
1072: , x_msg_data OUT NOCOPY VARCHAR2

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

1065:
1066: PROCEDURE Container_Required_Qty(
1067: p_api_version IN NUMBER
1068: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1069: , p_commit IN VARCHAR2 := fnd_api.g_false
1070: , x_return_status OUT NOCOPY VARCHAR2
1071: , x_msg_count OUT NOCOPY NUMBER
1072: , x_msg_data OUT NOCOPY VARCHAR2
1073: , p_source_item_id IN NUMBER

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

1093: --
1094: -- Input Parameters
1095: -- p_api_version
1096: -- API version number (current version is 1.0)
1097: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1098: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1099: -- if set to FND_API.G_TRUE
1100: -- initialize error message list
1101: -- if set to FND_API.G_FALSE - do not initialize error

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

1094: -- Input Parameters
1095: -- p_api_version
1096: -- API version number (current version is 1.0)
1097: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1098: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1099: -- if set to FND_API.G_TRUE
1100: -- initialize error message list
1101: -- if set to FND_API.G_FALSE - do not initialize error
1102: -- message list

Line 1099: -- if set to FND_API.G_TRUE

1095: -- p_api_version
1096: -- API version number (current version is 1.0)
1097: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1098: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1099: -- if set to FND_API.G_TRUE
1100: -- initialize error message list
1101: -- if set to FND_API.G_FALSE - do not initialize error
1102: -- message list
1103: -- p_commit (optional, default FND_API.G_FALSE)

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

1097: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1098: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1099: -- if set to FND_API.G_TRUE
1100: -- initialize error message list
1101: -- if set to FND_API.G_FALSE - do not initialize error
1102: -- message list
1103: -- p_commit (optional, default FND_API.G_FALSE)
1104: -- whether or not to commit the changes to database
1105: -- p_organization_id Organization of the LPN - Required

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

1099: -- if set to FND_API.G_TRUE
1100: -- initialize error message list
1101: -- if set to FND_API.G_FALSE - do not initialize error
1102: -- message list
1103: -- p_commit (optional, default FND_API.G_FALSE)
1104: -- whether or not to commit the changes to database
1105: -- p_organization_id Organization of the LPN - Required
1106: -- p_subinventory Subinventory - Defaults to NULL
1107: -- p_locator_id Locator Id - Defaults to NULL

Line 1131: -- fnd_api.g_ret_sts_success;

1127: -- ERRBUF Concurrent program error buffer
1128: -- RETCODE Concurrent program return code
1129: -- x_return_status
1130: -- if the Prepack_LPN API succeeds, the value is
1131: -- fnd_api.g_ret_sts_success;
1132: -- if there is an expected error, the value is
1133: -- fnd_api.g_ret_sts_error;
1134: -- if there is an unexpected error, the value is
1135: -- fnd_api.g_ret_sts_unexp_error;

Line 1133: -- fnd_api.g_ret_sts_error;

1129: -- x_return_status
1130: -- if the Prepack_LPN API succeeds, the value is
1131: -- fnd_api.g_ret_sts_success;
1132: -- if there is an expected error, the value is
1133: -- fnd_api.g_ret_sts_error;
1134: -- if there is an unexpected error, the value is
1135: -- fnd_api.g_ret_sts_unexp_error;
1136: -- x_msg_count
1137: -- if there is one or more errors, the number of error messages

Line 1135: -- fnd_api.g_ret_sts_unexp_error;

1131: -- fnd_api.g_ret_sts_success;
1132: -- if there is an expected error, the value is
1133: -- fnd_api.g_ret_sts_error;
1134: -- if there is an unexpected error, the value is
1135: -- fnd_api.g_ret_sts_unexp_error;
1136: -- x_msg_count
1137: -- if there is one or more errors, the number of error messages
1138: -- in the buffer
1139: -- x_msg_data

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

1181: --
1182: -- Input Parameters
1183: -- p_api_version
1184: -- API version number (current version is 1.0)
1185: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1186: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1187: -- if set to FND_API.G_TRUE
1188: -- initialize error message list
1189: -- if set to FND_API.G_FALSE - do not initialize error

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

1182: -- Input Parameters
1183: -- p_api_version
1184: -- API version number (current version is 1.0)
1185: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1186: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1187: -- if set to FND_API.G_TRUE
1188: -- initialize error message list
1189: -- if set to FND_API.G_FALSE - do not initialize error
1190: -- message list

Line 1187: -- if set to FND_API.G_TRUE

1183: -- p_api_version
1184: -- API version number (current version is 1.0)
1185: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1186: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1187: -- if set to FND_API.G_TRUE
1188: -- initialize error message list
1189: -- if set to FND_API.G_FALSE - do not initialize error
1190: -- message list
1191: -- p_commit (optional, default FND_API.G_FALSE)

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

1185: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1186: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1187: -- if set to FND_API.G_TRUE
1188: -- initialize error message list
1189: -- if set to FND_API.G_FALSE - do not initialize error
1190: -- message list
1191: -- p_commit (optional, default FND_API.G_FALSE)
1192: -- whether or not to commit the changes to database
1193: -- p_organization_id Organization of the LPN - Required

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

1187: -- if set to FND_API.G_TRUE
1188: -- initialize error message list
1189: -- if set to FND_API.G_FALSE - do not initialize error
1190: -- message list
1191: -- p_commit (optional, default FND_API.G_FALSE)
1192: -- whether or not to commit the changes to database
1193: -- p_organization_id Organization of the LPN - Required
1194: -- p_subinventory Subinventory - Defaults to NULL
1195: -- p_locator_id Locator Id - Defaults to NULL

Line 1217: -- fnd_api.g_ret_sts_success;

1213: --
1214: -- Output Parameters
1215: -- x_return_status
1216: -- if the Prepack_LPN API succeeds, the value is
1217: -- fnd_api.g_ret_sts_success;
1218: -- if there is an expected error, the value is
1219: -- fnd_api.g_ret_sts_error;
1220: -- if there is an unexpected error, the value is
1221: -- fnd_api.g_ret_sts_unexp_error;

Line 1219: -- fnd_api.g_ret_sts_error;

1215: -- x_return_status
1216: -- if the Prepack_LPN API succeeds, the value is
1217: -- fnd_api.g_ret_sts_success;
1218: -- if there is an expected error, the value is
1219: -- fnd_api.g_ret_sts_error;
1220: -- if there is an unexpected error, the value is
1221: -- fnd_api.g_ret_sts_unexp_error;
1222: -- x_msg_count
1223: -- if there is one or more errors, the number of error messages

Line 1221: -- fnd_api.g_ret_sts_unexp_error;

1217: -- fnd_api.g_ret_sts_success;
1218: -- if there is an expected error, the value is
1219: -- fnd_api.g_ret_sts_error;
1220: -- if there is an unexpected error, the value is
1221: -- fnd_api.g_ret_sts_unexp_error;
1222: -- x_msg_count
1223: -- if there is one or more errors, the number of error messages
1224: -- in the buffer
1225: -- x_msg_data

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

1227: --
1228:
1229: PROCEDURE Prepack_LPN(
1230: p_api_version IN NUMBER
1231: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1232: , p_commit IN VARCHAR2 := fnd_api.g_false
1233: , x_return_status OUT NOCOPY VARCHAR2
1234: , x_msg_count OUT NOCOPY NUMBER
1235: , x_msg_data OUT NOCOPY VARCHAR2

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

1228:
1229: PROCEDURE Prepack_LPN(
1230: p_api_version IN NUMBER
1231: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1232: , p_commit IN VARCHAR2 := fnd_api.g_false
1233: , x_return_status OUT NOCOPY VARCHAR2
1234: , x_msg_count OUT NOCOPY NUMBER
1235: , x_msg_data OUT NOCOPY VARCHAR2
1236: , p_organization_id IN NUMBER

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

1266: -- Parameters:
1267: -- IN :
1268: -- p_api_version
1269: -- API version number (current version is 1.0)
1270: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1271: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1272: -- if set to FND_API.G_TRUE
1273: -- initialize error message list
1274: -- if set to FND_API.G_FALSE - not initialize error

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

1267: -- IN :
1268: -- p_api_version
1269: -- API version number (current version is 1.0)
1270: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1271: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1272: -- if set to FND_API.G_TRUE
1273: -- initialize error message list
1274: -- if set to FND_API.G_FALSE - not initialize error
1275: -- message list

Line 1272: -- if set to FND_API.G_TRUE

1268: -- p_api_version
1269: -- API version number (current version is 1.0)
1270: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1271: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1272: -- if set to FND_API.G_TRUE
1273: -- initialize error message list
1274: -- if set to FND_API.G_FALSE - not initialize error
1275: -- message list
1276: -- p_commit (optional, default FND_API.G_FALSE)

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

1270: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1271: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1272: -- if set to FND_API.G_TRUE
1273: -- initialize error message list
1274: -- if set to FND_API.G_FALSE - not initialize error
1275: -- message list
1276: -- p_commit (optional, default FND_API.G_FALSE)
1277: -- whether or not to commit the changes to database
1278: -- p_validation_level (optional), determines if full validation or

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

1272: -- if set to FND_API.G_TRUE
1273: -- initialize error message list
1274: -- if set to FND_API.G_FALSE - not initialize error
1275: -- message list
1276: -- p_commit (optional, default FND_API.G_FALSE)
1277: -- whether or not to commit the changes to database
1278: -- p_validation_level (optional), determines if full validation or
1279: -- no validation will be performed
1280: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 1280: -- defaults to FND_API.G_VALID_LEVEL_FULL

1276: -- p_commit (optional, default FND_API.G_FALSE)
1277: -- whether or not to commit the changes to database
1278: -- p_validation_level (optional), determines if full validation or
1279: -- no validation will be performed
1280: -- defaults to FND_API.G_VALID_LEVEL_FULL
1281: -- FND_API.G_VALID_LEVEL_NONE is the other value
1282: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1283: -- p_content_item_id Content Item ID - Defaults to NULL
1284: -- p_revision Revision - Defaults to NULL

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

1277: -- whether or not to commit the changes to database
1278: -- p_validation_level (optional), determines if full validation or
1279: -- no validation will be performed
1280: -- defaults to FND_API.G_VALID_LEVEL_FULL
1281: -- FND_API.G_VALID_LEVEL_NONE is the other value
1282: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1283: -- p_content_item_id Content Item ID - Defaults to NULL
1284: -- p_revision Revision - Defaults to NULL
1285: -- p_lot_number Lot Number - Defaults to NULL

Line 1297: -- fnd_api.g_ret_sts_success;

1293: -- p_source_type_id Source type ID for the source transaction
1294: -- OUT :
1295: -- x_return_status
1296: -- if the PackUnpack_Container API succeeds, the value is
1297: -- fnd_api.g_ret_sts_success;
1298: -- if there is an expected error, the value is
1299: -- fnd_api.g_ret_sts_error;
1300: -- if there is an unexpected error, the value is
1301: -- fnd_api.g_ret_sts_unexp_error;

Line 1299: -- fnd_api.g_ret_sts_error;

1295: -- x_return_status
1296: -- if the PackUnpack_Container API succeeds, the value is
1297: -- fnd_api.g_ret_sts_success;
1298: -- if there is an expected error, the value is
1299: -- fnd_api.g_ret_sts_error;
1300: -- if there is an unexpected error, the value is
1301: -- fnd_api.g_ret_sts_unexp_error;
1302: -- x_msg_count
1303: -- if there is one or more errors, the number of error messages

Line 1301: -- fnd_api.g_ret_sts_unexp_error;

1297: -- fnd_api.g_ret_sts_success;
1298: -- if there is an expected error, the value is
1299: -- fnd_api.g_ret_sts_error;
1300: -- if there is an unexpected error, the value is
1301: -- fnd_api.g_ret_sts_unexp_error;
1302: -- x_msg_count
1303: -- if there is one or more errors, the number of error messages
1304: -- in the buffer
1305: -- x_msg_data

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

1308: -- End of comments
1309:
1310: PROCEDURE Pack_Prepack_Container(
1311: p_api_version IN NUMBER
1312: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1313: , p_commit IN VARCHAR2 := fnd_api.g_false
1314: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1315: , x_return_status OUT NOCOPY VARCHAR2
1316: , x_msg_count OUT NOCOPY NUMBER

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

1309:
1310: PROCEDURE Pack_Prepack_Container(
1311: p_api_version IN NUMBER
1312: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1313: , p_commit IN VARCHAR2 := fnd_api.g_false
1314: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1315: , x_return_status OUT NOCOPY VARCHAR2
1316: , x_msg_count OUT NOCOPY NUMBER
1317: , x_msg_data OUT NOCOPY VARCHAR2

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

1310: PROCEDURE Pack_Prepack_Container(
1311: p_api_version IN NUMBER
1312: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1313: , p_commit IN VARCHAR2 := fnd_api.g_false
1314: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1315: , x_return_status OUT NOCOPY VARCHAR2
1316: , x_msg_count OUT NOCOPY NUMBER
1317: , x_msg_data OUT NOCOPY VARCHAR2
1318: , p_lpn_id IN NUMBER

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

1338: -- Parameters:
1339: -- IN :
1340: -- p_api_version
1341: -- API version number (current version is 1.0)
1342: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1343: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1344: -- if set to FND_API.G_TRUE
1345: -- initialize error message list
1346: -- if set to FND_API.G_FALSE - not initialize error

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

1339: -- IN :
1340: -- p_api_version
1341: -- API version number (current version is 1.0)
1342: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1343: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1344: -- if set to FND_API.G_TRUE
1345: -- initialize error message list
1346: -- if set to FND_API.G_FALSE - not initialize error
1347: -- message list

Line 1344: -- if set to FND_API.G_TRUE

1340: -- p_api_version
1341: -- API version number (current version is 1.0)
1342: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1343: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1344: -- if set to FND_API.G_TRUE
1345: -- initialize error message list
1346: -- if set to FND_API.G_FALSE - not initialize error
1347: -- message list
1348: -- p_commit (optional, default FND_API.G_FALSE)

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

1342: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1343: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1344: -- if set to FND_API.G_TRUE
1345: -- initialize error message list
1346: -- if set to FND_API.G_FALSE - not initialize error
1347: -- message list
1348: -- p_commit (optional, default FND_API.G_FALSE)
1349: -- whether or not to commit the changes to database
1350: -- p_lpn_id License Plate Number Identifier - Required Value

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

1344: -- if set to FND_API.G_TRUE
1345: -- initialize error message list
1346: -- if set to FND_API.G_FALSE - not initialize error
1347: -- message list
1348: -- p_commit (optional, default FND_API.G_FALSE)
1349: -- whether or not to commit the changes to database
1350: -- p_lpn_id License Plate Number Identifier - Required Value
1351: -- p_explosion_level Explosion Level - Defaults to 0 (Explode to all levels)
1352: --

Line 1356: -- fnd_api.g_ret_sts_success;

1352: --
1353: -- OUT :
1354: -- x_return_status
1355: -- if the Explode_LPN API succeeds, the value is
1356: -- fnd_api.g_ret_sts_success;
1357: -- if there is an expected error, the value is
1358: -- fnd_api.g_ret_sts_error;
1359: -- if there is an unexpected error, the value is
1360: -- fnd_api.g_ret_sts_unexp_error;

Line 1358: -- fnd_api.g_ret_sts_error;

1354: -- x_return_status
1355: -- if the Explode_LPN API succeeds, the value is
1356: -- fnd_api.g_ret_sts_success;
1357: -- if there is an expected error, the value is
1358: -- fnd_api.g_ret_sts_error;
1359: -- if there is an unexpected error, the value is
1360: -- fnd_api.g_ret_sts_unexp_error;
1361: -- x_msg_count
1362: -- if there is one or more errors, the number of error messages

Line 1360: -- fnd_api.g_ret_sts_unexp_error;

1356: -- fnd_api.g_ret_sts_success;
1357: -- if there is an expected error, the value is
1358: -- fnd_api.g_ret_sts_error;
1359: -- if there is an unexpected error, the value is
1360: -- fnd_api.g_ret_sts_unexp_error;
1361: -- x_msg_count
1362: -- if there is one or more errors, the number of error messages
1363: -- in the buffer
1364: -- x_msg_data

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

1367: -- End of comments
1368:
1369: PROCEDURE Explode_LPN (
1370: p_api_version IN NUMBER
1371: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1372: , p_commit IN VARCHAR2 := fnd_api.g_false
1373: , x_return_status OUT NOCOPY VARCHAR2
1374: , x_msg_count OUT NOCOPY NUMBER
1375: , x_msg_data OUT NOCOPY VARCHAR2

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

1368:
1369: PROCEDURE Explode_LPN (
1370: p_api_version IN NUMBER
1371: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1372: , p_commit IN VARCHAR2 := fnd_api.g_false
1373: , x_return_status OUT NOCOPY VARCHAR2
1374: , x_msg_count OUT NOCOPY NUMBER
1375: , x_msg_data OUT NOCOPY VARCHAR2
1376: , p_lpn_id IN NUMBER

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

1472: -- End of comments
1473:
1474: PROCEDURE Merge_Up_LPN (
1475: p_api_version IN NUMBER
1476: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1477: , p_commit IN VARCHAR2 := fnd_api.g_false
1478: , x_return_status OUT NOCOPY VARCHAR2
1479: , x_msg_count OUT NOCOPY NUMBER
1480: , x_msg_data OUT NOCOPY VARCHAR2

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

1473:
1474: PROCEDURE Merge_Up_LPN (
1475: p_api_version IN NUMBER
1476: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1477: , p_commit IN VARCHAR2 := fnd_api.g_false
1478: , x_return_status OUT NOCOPY VARCHAR2
1479: , x_msg_count OUT NOCOPY NUMBER
1480: , x_msg_data OUT NOCOPY VARCHAR2
1481: , p_organization_id IN NUMBER

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

1515: -- End of comments
1516:
1517: PROCEDURE Break_Down_LPN (
1518: p_api_version IN NUMBER
1519: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1520: , p_commit IN VARCHAR2 := fnd_api.g_false
1521: , x_return_status OUT NOCOPY VARCHAR2
1522: , x_msg_count OUT NOCOPY NUMBER
1523: , x_msg_data OUT NOCOPY VARCHAR2

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

1516:
1517: PROCEDURE Break_Down_LPN (
1518: p_api_version IN NUMBER
1519: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1520: , p_commit IN VARCHAR2 := fnd_api.g_false
1521: , x_return_status OUT NOCOPY VARCHAR2
1522: , x_msg_count OUT NOCOPY NUMBER
1523: , x_msg_data OUT NOCOPY VARCHAR2
1524: , p_organization_id IN NUMBER

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

1545: -- End of comments
1546:
1547: PROCEDURE Initialize_LPN (
1548: p_api_version IN NUMBER
1549: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1550: , p_commit IN VARCHAR2 := fnd_api.g_false
1551: , x_return_status OUT NOCOPY VARCHAR2
1552: , x_msg_count OUT NOCOPY NUMBER
1553: , x_msg_data OUT NOCOPY VARCHAR2

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

1546:
1547: PROCEDURE Initialize_LPN (
1548: p_api_version IN NUMBER
1549: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1550: , p_commit IN VARCHAR2 := fnd_api.g_false
1551: , x_return_status OUT NOCOPY VARCHAR2
1552: , x_msg_count OUT NOCOPY NUMBER
1553: , x_msg_data OUT NOCOPY VARCHAR2
1554: , p_organization_id IN NUMBER

Line 1571: -- fnd_api.g_ret_sts_success;

1567: -- p_lpn_id The LPN which is being split or consolidated.
1568: -- Output Parameters
1569: -- x_return_status
1570: -- if the plan_delivery API succeeds, the value is
1571: -- fnd_api.g_ret_sts_success;
1572: -- if there is an expected error, the value is
1573: -- fnd_api.g_ret_sts_error;
1574: -- if there is an unexpected error, the value is
1575: -- fnd_api.g_ret_sts_unexp_error;

Line 1573: -- fnd_api.g_ret_sts_error;

1569: -- x_return_status
1570: -- if the plan_delivery API succeeds, the value is
1571: -- fnd_api.g_ret_sts_success;
1572: -- if there is an expected error, the value is
1573: -- fnd_api.g_ret_sts_error;
1574: -- if there is an unexpected error, the value is
1575: -- fnd_api.g_ret_sts_unexp_error;
1576: -- x_msg_count
1577: -- if there is one or more errors, the number of error messages

Line 1575: -- fnd_api.g_ret_sts_unexp_error;

1571: -- fnd_api.g_ret_sts_success;
1572: -- if there is an expected error, the value is
1573: -- fnd_api.g_ret_sts_error;
1574: -- if there is an unexpected error, the value is
1575: -- fnd_api.g_ret_sts_unexp_error;
1576: -- x_msg_count
1577: -- if there is one or more errors, the number of error messages
1578: -- in the buffer
1579: -- x_msg_data