DBA Data[Home] [Help]

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 335: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE

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

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

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

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

333: -- p_api_version (required) API version number (current version is 1.0)
334: -- p_init_msg_list (required)
335: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
336: -- if set to FND_API.G_TRUE - initialize error message list
337: -- if set to FND_API.G_FALSE - not initialize error message list
338: -- p_commit (required) whether or not to commit the changes to database
339: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
340: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
341: -- p_lpn_attributes Record of atrributes to be added to each LPN created aand inserted into

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

335: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
336: -- if set to FND_API.G_TRUE - initialize error message list
337: -- if set to FND_API.G_FALSE - not initialize error message list
338: -- p_commit (required) whether or not to commit the changes to database
339: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
340: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
341: -- p_lpn_attributes Record of atrributes to be added to each LPN created aand inserted into
342: -- WMS_License_Plate_Numbers. LPN record type is a generic LPN record type
343: -- and not all attributes listed are allowed while creating LPNs.

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

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

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

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

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

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

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

409: --
410: -- Input Parameters
411: -- p_api_version (required) API version number (current version is 1.0)
412: -- p_init_msg_list (required)
413: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
414: -- if set to FND_API.G_TRUE - initialize error message list
415: -- if set to FND_API.G_FALSE - not initialize error message list
416: -- p_commit (required) whether or not to commit the changes to database
417: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE

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

410: -- Input Parameters
411: -- p_api_version (required) API version number (current version is 1.0)
412: -- p_init_msg_list (required)
413: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
414: -- if set to FND_API.G_TRUE - initialize error message list
415: -- if set to FND_API.G_FALSE - not initialize error message list
416: -- p_commit (required) whether or not to commit the changes to database
417: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
418: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow

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

411: -- p_api_version (required) API version number (current version is 1.0)
412: -- p_init_msg_list (required)
413: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
414: -- if set to FND_API.G_TRUE - initialize error message list
415: -- if set to FND_API.G_FALSE - not initialize error message list
416: -- p_commit (required) whether or not to commit the changes to database
417: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
418: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
419: -- p_lpn_table Table of LPN records to be modified.

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

413: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
414: -- if set to FND_API.G_TRUE - initialize error message list
415: -- if set to FND_API.G_FALSE - not initialize error message list
416: -- p_commit (required) whether or not to commit the changes to database
417: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE
418: -- p_caller (required) VARCHAR2 Code of calling API/Product/Flow
419: -- p_lpn_table Table of LPN records to be modified.
420: -- WMS_License_Plate_Numbers. LPN record type is a generic LPN record type
421: -- and not all attributes listed are allowed while creating LPNs.

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

448: -- used for LPN historical and auditing purposes
449: --
450: -- Output Parameters
451: -- x_return_status
452: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
453: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
454: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
455: -- x_msg_count
456: -- if there is one or more errors, the number of error messages in the buffer

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

449: --
450: -- Output Parameters
451: -- x_return_status
452: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
453: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
454: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
455: -- x_msg_count
456: -- if there is one or more errors, the number of error messages in the buffer
457: -- x_msg_data

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

450: -- Output Parameters
451: -- x_return_status
452: -- if the Create_LPN API succeeds, the value is fnd_api.g_ret_sts_success;
453: -- if there is an expected error, the value is fnd_api.g_ret_sts_error;
454: -- if there is an unexpected error, the value is fnd_api.g_ret_sts_unexp_error;
455: -- x_msg_count
456: -- if there is one or more errors, the number of error messages in the buffer
457: -- x_msg_data
458: -- if there is one and only one error, the error message

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

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

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

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

Line 484: -- if set to FND_API.G_TRUE

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

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

482: -- p_init_msg_list (optional, default FND_API.G_FALSE)
483: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
484: -- if set to FND_API.G_TRUE
485: -- initialize error message list
486: -- if set to FND_API.G_FALSE - not initialize error
487: -- message list
488: -- p_commit (optional, default FND_API.G_FALSE)
489: -- whether or not to commit the changes to database
490: -- p_organization_id Organization Id - Required Value

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

484: -- if set to FND_API.G_TRUE
485: -- initialize error message list
486: -- if set to FND_API.G_FALSE - not initialize error
487: -- message list
488: -- p_commit (optional, default FND_API.G_FALSE)
489: -- whether or not to commit the changes to database
490: -- p_organization_id Organization Id - Required Value
491: -- p_container_item_id Container Item Id - Defaults to NULL
492: -- p_revision Revision - Defaults to NULL

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

559: --
560: -- Input Parameters
561: -- p_api_version
562: -- API version number (current version is 1.0)
563: -- p_init_msg_list (optional, default FND_API.G_FALSE)
564: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
565: -- if set to FND_API.G_TRUE
566: -- initialize error message list
567: -- if set to FND_API.G_FALSE - not initialize error

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

560: -- Input Parameters
561: -- p_api_version
562: -- API version number (current version is 1.0)
563: -- p_init_msg_list (optional, default FND_API.G_FALSE)
564: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
565: -- if set to FND_API.G_TRUE
566: -- initialize error message list
567: -- if set to FND_API.G_FALSE - not initialize error
568: -- message list

Line 565: -- if set to FND_API.G_TRUE

561: -- p_api_version
562: -- API version number (current version is 1.0)
563: -- p_init_msg_list (optional, default FND_API.G_FALSE)
564: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
565: -- if set to FND_API.G_TRUE
566: -- initialize error message list
567: -- if set to FND_API.G_FALSE - not initialize error
568: -- message list
569: -- p_commit (optional, default FND_API.G_FALSE)

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

563: -- p_init_msg_list (optional, default FND_API.G_FALSE)
564: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
565: -- if set to FND_API.G_TRUE
566: -- initialize error message list
567: -- if set to FND_API.G_FALSE - not initialize error
568: -- message list
569: -- p_commit (optional, default FND_API.G_FALSE)
570: -- whether or not to commit the changes to database
571: -- p_organization_id Organization Id - Required Value

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

565: -- if set to FND_API.G_TRUE
566: -- initialize error message list
567: -- if set to FND_API.G_FALSE - not initialize error
568: -- message list
569: -- p_commit (optional, default FND_API.G_FALSE)
570: -- whether or not to commit the changes to database
571: -- p_organization_id Organization Id - Required Value
572: -- p_container_item_id Container Item Id - Defaults to NULL
573: -- p_revision Revision - Defaults to NULL

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

638: --
639: -- Input Parameters
640: -- p_api_version
641: -- API version number (current version is 1.0)
642: -- p_init_msg_list (optional, default FND_API.G_FALSE)
643: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
644: -- if set to FND_API.G_TRUE
645: -- initialize error message list
646: -- if set to FND_API.G_FALSE - not initialize error

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

639: -- Input Parameters
640: -- p_api_version
641: -- API version number (current version is 1.0)
642: -- p_init_msg_list (optional, default FND_API.G_FALSE)
643: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
644: -- if set to FND_API.G_TRUE
645: -- initialize error message list
646: -- if set to FND_API.G_FALSE - not initialize error
647: -- message list

Line 644: -- if set to FND_API.G_TRUE

640: -- p_api_version
641: -- API version number (current version is 1.0)
642: -- p_init_msg_list (optional, default FND_API.G_FALSE)
643: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
644: -- if set to FND_API.G_TRUE
645: -- initialize error message list
646: -- if set to FND_API.G_FALSE - not initialize error
647: -- message list
648: -- p_commit (optional, default FND_API.G_FALSE)

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

642: -- p_init_msg_list (optional, default FND_API.G_FALSE)
643: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
644: -- if set to FND_API.G_TRUE
645: -- initialize error message list
646: -- if set to FND_API.G_FALSE - not initialize error
647: -- message list
648: -- p_commit (optional, default FND_API.G_FALSE)
649: -- whether or not to commit the changes to database
650: -- p_validation_level (optional), determines if full validation or

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

644: -- if set to FND_API.G_TRUE
645: -- initialize error message list
646: -- if set to FND_API.G_FALSE - not initialize error
647: -- message list
648: -- p_commit (optional, default FND_API.G_FALSE)
649: -- whether or not to commit the changes to database
650: -- p_validation_level (optional), determines if full validation or
651: -- no validation will be performed
652: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 652: -- defaults to FND_API.G_VALID_LEVEL_FULL

648: -- p_commit (optional, default FND_API.G_FALSE)
649: -- whether or not to commit the changes to database
650: -- p_validation_level (optional), determines if full validation or
651: -- no validation will be performed
652: -- defaults to FND_API.G_VALID_LEVEL_FULL
653: -- FND_API.G_VALID_LEVEL_NONE is the other value
654: -- p_organization_id Organization Id - Required Value
655: -- p_container_item_id Container Item Id - Defaults to NULL
656: -- p_revision Revision - Defaults to NULL

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

649: -- whether or not to commit the changes to database
650: -- p_validation_level (optional), determines if full validation or
651: -- no validation will be performed
652: -- defaults to FND_API.G_VALID_LEVEL_FULL
653: -- FND_API.G_VALID_LEVEL_NONE is the other value
654: -- p_organization_id Organization Id - Required Value
655: -- p_container_item_id Container Item Id - Defaults to NULL
656: -- p_revision Revision - Defaults to NULL
657: -- p_lot_number Lot Number - Defaults to NULL

Line 680: -- fnd_api.g_ret_sts_success;

676: --
677: -- Output Parameters
678: -- x_return_status
679: -- if the Generate_LPN API succeeds, the value is
680: -- fnd_api.g_ret_sts_success;
681: -- if there is an expected error, the value is
682: -- fnd_api.g_ret_sts_error;
683: -- if there is an unexpected error, the value is
684: -- fnd_api.g_ret_sts_unexp_error;

Line 682: -- fnd_api.g_ret_sts_error;

678: -- x_return_status
679: -- if the Generate_LPN API succeeds, the value is
680: -- fnd_api.g_ret_sts_success;
681: -- if there is an expected error, the value is
682: -- fnd_api.g_ret_sts_error;
683: -- if there is an unexpected error, the value is
684: -- fnd_api.g_ret_sts_unexp_error;
685: -- x_msg_count
686: -- if there is one or more errors, the number of error messages

Line 684: -- fnd_api.g_ret_sts_unexp_error;

680: -- fnd_api.g_ret_sts_success;
681: -- if there is an expected error, the value is
682: -- fnd_api.g_ret_sts_error;
683: -- if there is an unexpected error, the value is
684: -- fnd_api.g_ret_sts_unexp_error;
685: -- x_msg_count
686: -- if there is one or more errors, the number of error messages
687: -- in the buffer
688: -- x_msg_data

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

686: -- if there is one or more errors, the number of error messages
687: -- in the buffer
688: -- x_msg_data
689: -- if there is one and only one error, the error message
690: -- (See fnd_api package for more details about the above output parameters)
691: --
692: -- p_lpn_id_out - Outputs the generated LPN ID
693: -- if only one LPN is requested to be generated
694: -- p_lpn_out - Outputs the generated license plate number

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

697: -- table WMS_LPN_PROCESS_TEMP
698:
699: PROCEDURE Generate_LPN (
700: p_api_version IN NUMBER
701: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
702: , p_commit IN VARCHAR2 := fnd_api.g_false
703: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
704: , x_return_status OUT NOCOPY VARCHAR2
705: , x_msg_count OUT NOCOPY NUMBER

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

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

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

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

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

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

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

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

Line 751: -- if set to FND_API.G_TRUE

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

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

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

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

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

Line 759: -- defaults to FND_API.G_VALID_LEVEL_FULL

755: -- p_commit (optional, default FND_API.G_FALSE)
756: -- whether or not to commit the changes to database
757: -- p_validation_level (optional), determines if full validation or
758: -- no validation will be performed
759: -- defaults to FND_API.G_VALID_LEVEL_FULL
760: -- FND_API.G_VALID_LEVEL_NONE is the other value
761: -- p_organization_id Organization Id - Required Value
762: -- p_container_item_id Container Item Id - Defaults to NULL
763: -- p_revision Revision - Defaults to NULL

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

756: -- whether or not to commit the changes to database
757: -- p_validation_level (optional), determines if full validation or
758: -- no validation will be performed
759: -- defaults to FND_API.G_VALID_LEVEL_FULL
760: -- FND_API.G_VALID_LEVEL_NONE is the other value
761: -- p_organization_id Organization Id - Required Value
762: -- p_container_item_id Container Item Id - Defaults to NULL
763: -- p_revision Revision - Defaults to NULL
764: -- p_lot_number Lot Number - Defaults to NULL

Line 788: -- fnd_api.g_ret_sts_success;

784: --
785: -- Output Parameters
786: -- x_return_status
787: -- if the Generate_LPN API succeeds, the value is
788: -- fnd_api.g_ret_sts_success;
789: -- if there is an expected error, the value is
790: -- fnd_api.g_ret_sts_error;
791: -- if there is an unexpected error, the value is
792: -- fnd_api.g_ret_sts_unexp_error;

Line 790: -- fnd_api.g_ret_sts_error;

786: -- x_return_status
787: -- if the Generate_LPN API succeeds, the value is
788: -- fnd_api.g_ret_sts_success;
789: -- if there is an expected error, the value is
790: -- fnd_api.g_ret_sts_error;
791: -- if there is an unexpected error, the value is
792: -- fnd_api.g_ret_sts_unexp_error;
793: -- x_msg_count
794: -- if there is one or more errors, the number of error messages

Line 792: -- fnd_api.g_ret_sts_unexp_error;

788: -- fnd_api.g_ret_sts_success;
789: -- if there is an expected error, the value is
790: -- fnd_api.g_ret_sts_error;
791: -- if there is an unexpected error, the value is
792: -- fnd_api.g_ret_sts_unexp_error;
793: -- x_msg_count
794: -- if there is one or more errors, the number of error messages
795: -- in the buffer
796: -- x_msg_data

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

794: -- if there is one or more errors, the number of error messages
795: -- in the buffer
796: -- x_msg_data
797: -- if there is one and only one error, the error message
798: -- (See fnd_api package for more details about the above output parameters)
799: --
800: -- p_lpn_id_out - Outputs the generated LPN ID
801: -- if only one LPN is requested to be generated
802: -- p_lpn_out - Outputs the generated license plate number

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

805: -- table WMS_LPN_PROCESS_TEMP
806:
807: PROCEDURE Generate_LPN (
808: p_api_version IN NUMBER
809: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
810: , p_commit IN VARCHAR2 := fnd_api.g_false
811: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
812: , x_return_status OUT NOCOPY VARCHAR2
813: , x_msg_count OUT NOCOPY NUMBER

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

806:
807: PROCEDURE Generate_LPN (
808: p_api_version IN NUMBER
809: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
810: , p_commit IN VARCHAR2 := fnd_api.g_false
811: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
812: , x_return_status OUT NOCOPY VARCHAR2
813: , x_msg_count OUT NOCOPY NUMBER
814: , x_msg_data OUT NOCOPY VARCHAR2

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

807: PROCEDURE Generate_LPN (
808: p_api_version IN NUMBER
809: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
810: , p_commit IN VARCHAR2 := fnd_api.g_false
811: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
812: , x_return_status OUT NOCOPY VARCHAR2
813: , x_msg_count OUT NOCOPY NUMBER
814: , x_msg_data OUT NOCOPY VARCHAR2
815: , p_organization_id IN NUMBER

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

850: --
851: -- Input Parameters
852: -- p_api_version
853: -- API version number (current version is 1.0)
854: -- p_init_msg_list (optional, default FND_API.G_FALSE)
855: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
856: -- if set to FND_API.G_TRUE
857: -- initialize error message list
858: -- if set to FND_API.G_FALSE - not initialize error

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

851: -- Input Parameters
852: -- p_api_version
853: -- API version number (current version is 1.0)
854: -- p_init_msg_list (optional, default FND_API.G_FALSE)
855: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
856: -- if set to FND_API.G_TRUE
857: -- initialize error message list
858: -- if set to FND_API.G_FALSE - not initialize error
859: -- message list

Line 856: -- if set to FND_API.G_TRUE

852: -- p_api_version
853: -- API version number (current version is 1.0)
854: -- p_init_msg_list (optional, default FND_API.G_FALSE)
855: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
856: -- if set to FND_API.G_TRUE
857: -- initialize error message list
858: -- if set to FND_API.G_FALSE - not initialize error
859: -- message list
860: -- p_commit (optional, default FND_API.G_FALSE)

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

854: -- p_init_msg_list (optional, default FND_API.G_FALSE)
855: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
856: -- if set to FND_API.G_TRUE
857: -- initialize error message list
858: -- if set to FND_API.G_FALSE - not initialize error
859: -- message list
860: -- p_commit (optional, default FND_API.G_FALSE)
861: -- whether or not to commit the changes to database
862: -- p_validation_level (optional), determines if full validation or

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

856: -- if set to FND_API.G_TRUE
857: -- initialize error message list
858: -- if set to FND_API.G_FALSE - not initialize error
859: -- message list
860: -- p_commit (optional, default FND_API.G_FALSE)
861: -- whether or not to commit the changes to database
862: -- p_validation_level (optional), determines if full validation or
863: -- no validation will be performed
864: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 864: -- defaults to FND_API.G_VALID_LEVEL_FULL

860: -- p_commit (optional, default FND_API.G_FALSE)
861: -- whether or not to commit the changes to database
862: -- p_validation_level (optional), determines if full validation or
863: -- no validation will be performed
864: -- defaults to FND_API.G_VALID_LEVEL_FULL
865: -- FND_API.G_VALID_LEVEL_NONE is the other value
866: -- p_lpn_id License Plate Number Identifier - Required Value
867: -- p_container_item_id Container Item Id - Required Value
868: -- p_lot_number Lot Number - Defaults to NULL

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

861: -- whether or not to commit the changes to database
862: -- p_validation_level (optional), determines if full validation or
863: -- no validation will be performed
864: -- defaults to FND_API.G_VALID_LEVEL_FULL
865: -- FND_API.G_VALID_LEVEL_NONE is the other value
866: -- p_lpn_id License Plate Number Identifier - Required Value
867: -- p_container_item_id Container Item Id - Required Value
868: -- p_lot_number Lot Number - Defaults to NULL
869: -- p_revision Revision - Defaults to NULL

Line 885: -- fnd_api.g_ret_sts_success;

881: --
882: -- Output Parameters
883: -- x_return_status
884: -- if the Associate_LPN API succeeds, the value is
885: -- fnd_api.g_ret_sts_success;
886: -- if there is an expected error, the value is
887: -- fnd_api.g_ret_sts_error;
888: -- if there is an unexpected error, the value is
889: -- fnd_api.g_ret_sts_unexp_error;

Line 887: -- fnd_api.g_ret_sts_error;

883: -- x_return_status
884: -- if the Associate_LPN API succeeds, the value is
885: -- fnd_api.g_ret_sts_success;
886: -- if there is an expected error, the value is
887: -- fnd_api.g_ret_sts_error;
888: -- if there is an unexpected error, the value is
889: -- fnd_api.g_ret_sts_unexp_error;
890: -- x_msg_count
891: -- if there is one or more errors, the number of error messages

Line 889: -- fnd_api.g_ret_sts_unexp_error;

885: -- fnd_api.g_ret_sts_success;
886: -- if there is an expected error, the value is
887: -- fnd_api.g_ret_sts_error;
888: -- if there is an unexpected error, the value is
889: -- fnd_api.g_ret_sts_unexp_error;
890: -- x_msg_count
891: -- if there is one or more errors, the number of error messages
892: -- in the buffer
893: -- x_msg_data

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

894: -- if there is one and only one error, the error message
895:
896: PROCEDURE Associate_LPN(
897: p_api_version IN NUMBER
898: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
899: , p_commit IN VARCHAR2 := fnd_api.g_false
900: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
901: , x_return_status OUT NOCOPY VARCHAR2
902: , x_msg_count OUT NOCOPY NUMBER

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

895:
896: PROCEDURE Associate_LPN(
897: p_api_version IN NUMBER
898: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
899: , p_commit IN VARCHAR2 := fnd_api.g_false
900: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
901: , x_return_status OUT NOCOPY VARCHAR2
902: , x_msg_count OUT NOCOPY NUMBER
903: , x_msg_data OUT NOCOPY VARCHAR2

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

896: PROCEDURE Associate_LPN(
897: p_api_version IN NUMBER
898: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
899: , p_commit IN VARCHAR2 := fnd_api.g_false
900: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
901: , x_return_status OUT NOCOPY VARCHAR2
902: , x_msg_count OUT NOCOPY NUMBER
903: , x_msg_data OUT NOCOPY VARCHAR2
904: , p_lpn_id IN NUMBER

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

928: --
929: -- Input Parameters
930: -- p_api_version
931: -- API version number (current version is 1.0)
932: -- p_init_msg_list (optional, default FND_API.G_FALSE)
933: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
934: -- if set to FND_API.G_TRUE
935: -- initialize error message list
936: -- if set to FND_API.G_FALSE - not initialize error

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

929: -- Input Parameters
930: -- p_api_version
931: -- API version number (current version is 1.0)
932: -- p_init_msg_list (optional, default FND_API.G_FALSE)
933: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
934: -- if set to FND_API.G_TRUE
935: -- initialize error message list
936: -- if set to FND_API.G_FALSE - not initialize error
937: -- message list

Line 934: -- if set to FND_API.G_TRUE

930: -- p_api_version
931: -- API version number (current version is 1.0)
932: -- p_init_msg_list (optional, default FND_API.G_FALSE)
933: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
934: -- if set to FND_API.G_TRUE
935: -- initialize error message list
936: -- if set to FND_API.G_FALSE - not initialize error
937: -- message list
938: -- p_commit (optional, default FND_API.G_FALSE)

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

932: -- p_init_msg_list (optional, default FND_API.G_FALSE)
933: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
934: -- if set to FND_API.G_TRUE
935: -- initialize error message list
936: -- if set to FND_API.G_FALSE - not initialize error
937: -- message list
938: -- p_commit (optional, default FND_API.G_FALSE)
939: -- whether or not to commit the changes to database
940: -- p_validation_level (optional), determines if full validation or

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

934: -- if set to FND_API.G_TRUE
935: -- initialize error message list
936: -- if set to FND_API.G_FALSE - not initialize error
937: -- message list
938: -- p_commit (optional, default FND_API.G_FALSE)
939: -- whether or not to commit the changes to database
940: -- p_validation_level (optional), determines if full validation or
941: -- no validation will be performed
942: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 942: -- defaults to FND_API.G_VALID_LEVEL_FULL

938: -- p_commit (optional, default FND_API.G_FALSE)
939: -- whether or not to commit the changes to database
940: -- p_validation_level (optional), determines if full validation or
941: -- no validation will be performed
942: -- defaults to FND_API.G_VALID_LEVEL_FULL
943: -- FND_API.G_VALID_LEVEL_NONE is the other value
944: -- p_lpn License Plate Number Identifier - Required Value
945: -- p_organization_id Organization Id - Required Value
946: -- p_container_item_id Container Item Id - Defaults to NULL

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

939: -- whether or not to commit the changes to database
940: -- p_validation_level (optional), determines if full validation or
941: -- no validation will be performed
942: -- defaults to FND_API.G_VALID_LEVEL_FULL
943: -- FND_API.G_VALID_LEVEL_NONE is the other value
944: -- p_lpn License Plate Number Identifier - Required Value
945: -- p_organization_id Organization Id - Required Value
946: -- p_container_item_id Container Item Id - Defaults to NULL
947: -- p_revision Revision - Defaults to NULL

Line 966: -- fnd_api.g_ret_sts_success;

962: --
963: -- Output Parameters
964: -- x_return_status
965: -- if the Create_LPN API succeeds, the value is
966: -- fnd_api.g_ret_sts_success;
967: -- if there is an expected error, the value is
968: -- fnd_api.g_ret_sts_error;
969: -- if there is an unexpected error, the value is
970: -- fnd_api.g_ret_sts_unexp_error;

Line 968: -- fnd_api.g_ret_sts_error;

964: -- x_return_status
965: -- if the Create_LPN API succeeds, the value is
966: -- fnd_api.g_ret_sts_success;
967: -- if there is an expected error, the value is
968: -- fnd_api.g_ret_sts_error;
969: -- if there is an unexpected error, the value is
970: -- fnd_api.g_ret_sts_unexp_error;
971: -- x_msg_count
972: -- if there is one or more errors, the number of error messages

Line 970: -- fnd_api.g_ret_sts_unexp_error;

966: -- fnd_api.g_ret_sts_success;
967: -- if there is an expected error, the value is
968: -- fnd_api.g_ret_sts_error;
969: -- if there is an unexpected error, the value is
970: -- fnd_api.g_ret_sts_unexp_error;
971: -- x_msg_count
972: -- if there is one or more errors, the number of error messages
973: -- in the buffer
974: -- x_msg_data

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

977: --
978:
979: PROCEDURE Create_LPN (
980: p_api_version IN NUMBER
981: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
982: , p_commit IN VARCHAR2 := fnd_api.g_false
983: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
984: , x_return_status OUT NOCOPY VARCHAR2
985: , x_msg_count OUT NOCOPY NUMBER

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

978:
979: PROCEDURE Create_LPN (
980: p_api_version IN NUMBER
981: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
982: , p_commit IN VARCHAR2 := fnd_api.g_false
983: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
984: , x_return_status OUT NOCOPY VARCHAR2
985: , x_msg_count OUT NOCOPY NUMBER
986: , x_msg_data OUT NOCOPY VARCHAR2

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

979: PROCEDURE Create_LPN (
980: p_api_version IN NUMBER
981: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
982: , p_commit IN VARCHAR2 := fnd_api.g_false
983: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
984: , x_return_status OUT NOCOPY VARCHAR2
985: , x_msg_count OUT NOCOPY NUMBER
986: , x_msg_data OUT NOCOPY VARCHAR2
987: , p_lpn IN VARCHAR2

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

1020: --
1021: -- Input Parameters
1022: -- p_api_version
1023: -- API version number (current version is 1.0)
1024: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1025: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1026: -- if set to FND_API.G_TRUE
1027: -- initialize error message list
1028: -- if set to FND_API.G_FALSE - not initialize error

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

1021: -- Input Parameters
1022: -- p_api_version
1023: -- API version number (current version is 1.0)
1024: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1025: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1026: -- if set to FND_API.G_TRUE
1027: -- initialize error message list
1028: -- if set to FND_API.G_FALSE - not initialize error
1029: -- message list

Line 1026: -- if set to FND_API.G_TRUE

1022: -- p_api_version
1023: -- API version number (current version is 1.0)
1024: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1025: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1026: -- if set to FND_API.G_TRUE
1027: -- initialize error message list
1028: -- if set to FND_API.G_FALSE - not initialize error
1029: -- message list
1030: -- p_commit (optional, default FND_API.G_FALSE)

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

1024: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1025: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1026: -- if set to FND_API.G_TRUE
1027: -- initialize error message list
1028: -- if set to FND_API.G_FALSE - not initialize error
1029: -- message list
1030: -- p_commit (optional, default FND_API.G_FALSE)
1031: -- whether or not to commit the changes to database
1032: -- p_validation_level (optional), determines if full validation or

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

1026: -- if set to FND_API.G_TRUE
1027: -- initialize error message list
1028: -- if set to FND_API.G_FALSE - not initialize error
1029: -- message list
1030: -- p_commit (optional, default FND_API.G_FALSE)
1031: -- whether or not to commit the changes to database
1032: -- p_validation_level (optional), determines if full validation or
1033: -- no validation will be performed
1034: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 1034: -- defaults to FND_API.G_VALID_LEVEL_FULL

1030: -- p_commit (optional, default FND_API.G_FALSE)
1031: -- whether or not to commit the changes to database
1032: -- p_validation_level (optional), determines if full validation or
1033: -- no validation will be performed
1034: -- defaults to FND_API.G_VALID_LEVEL_FULL
1035: -- FND_API.G_VALID_LEVEL_NONE is the other value
1036: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
1037: -- Stores the information for the fields of the LPN record that
1038: -- the user desires to modify

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

1031: -- whether or not to commit the changes to database
1032: -- p_validation_level (optional), determines if full validation or
1033: -- no validation will be performed
1034: -- defaults to FND_API.G_VALID_LEVEL_FULL
1035: -- FND_API.G_VALID_LEVEL_NONE is the other value
1036: -- p_lpn WMS_LICENSE_PLATE_NUMBERS%ROWTYPE - Required Value
1037: -- Stores the information for the fields of the LPN record that
1038: -- the user desires to modify
1039: -- p_source_type_id Source type ID for the source transaction

Line 1049: -- fnd_api.g_ret_sts_success;

1045: --
1046: -- Output Parameters
1047: -- x_return_status
1048: -- if the Modify_LPN API succeeds, the value is
1049: -- fnd_api.g_ret_sts_success;
1050: -- if there is an expected error, the value is
1051: -- fnd_api.g_ret_sts_error;
1052: -- if there is an unexpected error, the value is
1053: -- fnd_api.g_ret_sts_unexp_error;

Line 1051: -- fnd_api.g_ret_sts_error;

1047: -- x_return_status
1048: -- if the Modify_LPN API succeeds, the value is
1049: -- fnd_api.g_ret_sts_success;
1050: -- if there is an expected error, the value is
1051: -- fnd_api.g_ret_sts_error;
1052: -- if there is an unexpected error, the value is
1053: -- fnd_api.g_ret_sts_unexp_error;
1054: -- x_msg_count
1055: -- if there is one or more errors, the number of error messages

Line 1053: -- fnd_api.g_ret_sts_unexp_error;

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

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

1058: -- if there is one and only one error, the error message
1059:
1060: PROCEDURE Modify_LPN (
1061: p_api_version IN NUMBER
1062: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1063: , p_commit IN VARCHAR2 := fnd_api.g_false
1064: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1065: , x_return_status OUT NOCOPY VARCHAR2
1066: , x_msg_count OUT NOCOPY NUMBER

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

1059:
1060: PROCEDURE Modify_LPN (
1061: p_api_version IN NUMBER
1062: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1063: , p_commit IN VARCHAR2 := fnd_api.g_false
1064: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1065: , x_return_status OUT NOCOPY VARCHAR2
1066: , x_msg_count OUT NOCOPY NUMBER
1067: , x_msg_data OUT NOCOPY VARCHAR2

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

1060: PROCEDURE Modify_LPN (
1061: p_api_version IN NUMBER
1062: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1063: , p_commit IN VARCHAR2 := fnd_api.g_false
1064: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1065: , x_return_status OUT NOCOPY VARCHAR2
1066: , x_msg_count OUT NOCOPY NUMBER
1067: , x_msg_data OUT NOCOPY VARCHAR2
1068: , p_lpn IN WMS_CONTAINER_PUB.LPN

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

1070: );
1071:
1072: PROCEDURE Modify_LPN_Wrapper(
1073: p_api_version IN NUMBER
1074: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1075: , p_commit IN VARCHAR2 := fnd_api.g_false
1076: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1077: , x_return_status OUT NOCOPY VARCHAR2
1078: , x_msg_count OUT NOCOPY NUMBER

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

1071:
1072: PROCEDURE Modify_LPN_Wrapper(
1073: p_api_version IN NUMBER
1074: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1075: , p_commit IN VARCHAR2 := fnd_api.g_false
1076: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1077: , x_return_status OUT NOCOPY VARCHAR2
1078: , x_msg_count OUT NOCOPY NUMBER
1079: , x_msg_data OUT NOCOPY VARCHAR2

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

1072: PROCEDURE Modify_LPN_Wrapper(
1073: p_api_version IN NUMBER
1074: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1075: , p_commit IN VARCHAR2 := fnd_api.g_false
1076: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1077: , x_return_status OUT NOCOPY VARCHAR2
1078: , x_msg_count OUT NOCOPY NUMBER
1079: , x_msg_data OUT NOCOPY VARCHAR2
1080: , p_lpn_id IN NUMBER

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

1108: -- Parameters:
1109: -- IN :
1110: -- p_api_version
1111: -- API version number (current version is 1.0)
1112: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1113: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1114: -- if set to FND_API.G_TRUE
1115: -- initialize error message list
1116: -- if set to FND_API.G_FALSE - not initialize error

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

1109: -- IN :
1110: -- p_api_version
1111: -- API version number (current version is 1.0)
1112: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1113: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1114: -- if set to FND_API.G_TRUE
1115: -- initialize error message list
1116: -- if set to FND_API.G_FALSE - not initialize error
1117: -- message list

Line 1114: -- if set to FND_API.G_TRUE

1110: -- p_api_version
1111: -- API version number (current version is 1.0)
1112: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1113: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1114: -- if set to FND_API.G_TRUE
1115: -- initialize error message list
1116: -- if set to FND_API.G_FALSE - not initialize error
1117: -- message list
1118: -- p_commit (optional, default FND_API.G_FALSE)

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

1112: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1113: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1114: -- if set to FND_API.G_TRUE
1115: -- initialize error message list
1116: -- if set to FND_API.G_FALSE - not initialize error
1117: -- message list
1118: -- p_commit (optional, default FND_API.G_FALSE)
1119: -- whether or not to commit the changes to database
1120: -- p_validation_level (optional), determines if full validation or

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

1114: -- if set to FND_API.G_TRUE
1115: -- initialize error message list
1116: -- if set to FND_API.G_FALSE - not initialize error
1117: -- message list
1118: -- p_commit (optional, default FND_API.G_FALSE)
1119: -- whether or not to commit the changes to database
1120: -- p_validation_level (optional), determines if full validation or
1121: -- no validation will be performed
1122: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 1122: -- defaults to FND_API.G_VALID_LEVEL_FULL

1118: -- p_commit (optional, default FND_API.G_FALSE)
1119: -- whether or not to commit the changes to database
1120: -- p_validation_level (optional), determines if full validation or
1121: -- no validation will be performed
1122: -- defaults to FND_API.G_VALID_LEVEL_FULL
1123: -- FND_API.G_VALID_LEVEL_NONE is the other value
1124: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1125: -- p_content_lpn_id Content LPN ID
1126: -- p_content_item_id Content Item ID - Defaults to NULL

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

1119: -- whether or not to commit the changes to database
1120: -- p_validation_level (optional), determines if full validation or
1121: -- no validation will be performed
1122: -- defaults to FND_API.G_VALID_LEVEL_FULL
1123: -- FND_API.G_VALID_LEVEL_NONE is the other value
1124: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1125: -- p_content_lpn_id Content LPN ID
1126: -- p_content_item_id Content Item ID - Defaults to NULL
1127: -- p_content_item_desc Content Item Description - Defaults to NULL

Line 1173: -- fnd_api.g_ret_sts_success;

1169: -- 1 = Yes, 2 = No Defaults to 2 = No
1170: -- OUT :
1171: -- x_return_status
1172: -- if the PackUnpack_Container API succeeds, the value is
1173: -- fnd_api.g_ret_sts_success;
1174: -- if there is an expected error, the value is
1175: -- fnd_api.g_ret_sts_error;
1176: -- if there is an unexpected error, the value is
1177: -- fnd_api.g_ret_sts_unexp_error;

Line 1175: -- fnd_api.g_ret_sts_error;

1171: -- x_return_status
1172: -- if the PackUnpack_Container API succeeds, the value is
1173: -- fnd_api.g_ret_sts_success;
1174: -- if there is an expected error, the value is
1175: -- fnd_api.g_ret_sts_error;
1176: -- if there is an unexpected error, the value is
1177: -- fnd_api.g_ret_sts_unexp_error;
1178: -- x_msg_count
1179: -- if there is one or more errors, the number of error messages

Line 1177: -- fnd_api.g_ret_sts_unexp_error;

1173: -- fnd_api.g_ret_sts_success;
1174: -- if there is an expected error, the value is
1175: -- fnd_api.g_ret_sts_error;
1176: -- if there is an unexpected error, the value is
1177: -- fnd_api.g_ret_sts_unexp_error;
1178: -- x_msg_count
1179: -- if there is one or more errors, the number of error messages
1180: -- in the buffer
1181: -- x_msg_data

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

1184: -- End of comments
1185:
1186: PROCEDURE PackUnpack_Container(
1187: p_api_version IN NUMBER
1188: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1189: , p_commit IN VARCHAR2 := fnd_api.g_false
1190: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1191: , x_return_status OUT NOCOPY VARCHAR2
1192: , x_msg_count OUT NOCOPY NUMBER

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

1185:
1186: PROCEDURE PackUnpack_Container(
1187: p_api_version IN NUMBER
1188: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1189: , p_commit IN VARCHAR2 := fnd_api.g_false
1190: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1191: , x_return_status OUT NOCOPY VARCHAR2
1192: , x_msg_count OUT NOCOPY NUMBER
1193: , x_msg_data OUT NOCOPY VARCHAR2

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

1186: PROCEDURE PackUnpack_Container(
1187: p_api_version IN NUMBER
1188: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1189: , p_commit IN VARCHAR2 := fnd_api.g_false
1190: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1191: , x_return_status OUT NOCOPY VARCHAR2
1192: , x_msg_count OUT NOCOPY NUMBER
1193: , x_msg_data OUT NOCOPY VARCHAR2
1194: , p_lpn_id IN NUMBER

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

1236: --
1237: -- Input Parameters
1238: -- p_api_version
1239: -- API version number (current version is 1.0)
1240: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1241: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1242: -- if set to FND_API.G_TRUE
1243: -- initialize error message list
1244: -- if set to FND_API.G_FALSE - not initialize error

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

1237: -- Input Parameters
1238: -- p_api_version
1239: -- API version number (current version is 1.0)
1240: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1241: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1242: -- if set to FND_API.G_TRUE
1243: -- initialize error message list
1244: -- if set to FND_API.G_FALSE - not initialize error
1245: -- message list

Line 1242: -- if set to FND_API.G_TRUE

1238: -- p_api_version
1239: -- API version number (current version is 1.0)
1240: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1241: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1242: -- if set to FND_API.G_TRUE
1243: -- initialize error message list
1244: -- if set to FND_API.G_FALSE - not initialize error
1245: -- message list
1246: -- p_commit (optional, default FND_API.G_FALSE)

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

1240: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1241: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1242: -- if set to FND_API.G_TRUE
1243: -- initialize error message list
1244: -- if set to FND_API.G_FALSE - not initialize error
1245: -- message list
1246: -- p_commit (optional, default FND_API.G_FALSE)
1247: -- whether or not to commit the changes to database
1248: -- p_lpn_id License Plate Number Identifier - Required Value

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

1242: -- if set to FND_API.G_TRUE
1243: -- initialize error message list
1244: -- if set to FND_API.G_FALSE - not initialize error
1245: -- message list
1246: -- p_commit (optional, default FND_API.G_FALSE)
1247: -- whether or not to commit the changes to database
1248: -- p_lpn_id License Plate Number Identifier - Required Value
1249: -- p_content_lpn_id Content LPN Id - Defaults to NULL
1250: -- p_content_item_id Content Item Id - Defaults to NULL

Line 1263: -- fnd_api.g_ret_sts_success;

1259: -- 1. Validate, 2. Update, 3. Validate and Update
1260: -- Output Parameters
1261: -- x_return_status
1262: -- if the Validate_Update_Wt_Volume API succeeds, the value is
1263: -- fnd_api.g_ret_sts_success;
1264: -- if there is an expected error, the value is
1265: -- fnd_api.g_ret_sts_error;
1266: -- if there is an unexpected error, the value is
1267: -- fnd_api.g_ret_sts_unexp_error;

Line 1265: -- fnd_api.g_ret_sts_error;

1261: -- x_return_status
1262: -- if the Validate_Update_Wt_Volume API succeeds, the value is
1263: -- fnd_api.g_ret_sts_success;
1264: -- if there is an expected error, the value is
1265: -- fnd_api.g_ret_sts_error;
1266: -- if there is an unexpected error, the value is
1267: -- fnd_api.g_ret_sts_unexp_error;
1268: -- x_msg_count
1269: -- if there is one or more errors, the number of error messages

Line 1267: -- fnd_api.g_ret_sts_unexp_error;

1263: -- fnd_api.g_ret_sts_success;
1264: -- if there is an expected error, the value is
1265: -- fnd_api.g_ret_sts_error;
1266: -- if there is an unexpected error, the value is
1267: -- fnd_api.g_ret_sts_unexp_error;
1268: -- x_msg_count
1269: -- if there is one or more errors, the number of error messages
1270: -- in the buffer
1271: -- x_msg_data

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

1276: --
1277:
1278: PROCEDURE Validate_Update_Wt_Volume(
1279: p_api_version IN NUMBER
1280: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1281: , p_commit IN VARCHAR2 := fnd_api.g_false
1282: , x_return_status OUT NOCOPY VARCHAR2
1283: , x_msg_count OUT NOCOPY NUMBER
1284: , x_msg_data OUT NOCOPY VARCHAR2

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

1277:
1278: PROCEDURE Validate_Update_Wt_Volume(
1279: p_api_version IN NUMBER
1280: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1281: , p_commit IN VARCHAR2 := fnd_api.g_false
1282: , x_return_status OUT NOCOPY VARCHAR2
1283: , x_msg_count OUT NOCOPY NUMBER
1284: , x_msg_data OUT NOCOPY VARCHAR2
1285: , p_lpn_id IN NUMBER

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

1307: --
1308: -- Input Parameters
1309: -- p_api_version
1310: -- API version number (current version is 1.0)
1311: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1312: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1313: -- if set to FND_API.G_TRUE
1314: -- initialize error message list
1315: -- if set to FND_API.G_FALSE - not initialize error

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

1308: -- Input Parameters
1309: -- p_api_version
1310: -- API version number (current version is 1.0)
1311: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1312: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1313: -- if set to FND_API.G_TRUE
1314: -- initialize error message list
1315: -- if set to FND_API.G_FALSE - not initialize error
1316: -- message list

Line 1313: -- if set to FND_API.G_TRUE

1309: -- p_api_version
1310: -- API version number (current version is 1.0)
1311: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1312: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1313: -- if set to FND_API.G_TRUE
1314: -- initialize error message list
1315: -- if set to FND_API.G_FALSE - not initialize error
1316: -- message list
1317: -- p_commit (optional, default FND_API.G_FALSE)

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

1311: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1312: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1313: -- if set to FND_API.G_TRUE
1314: -- initialize error message list
1315: -- if set to FND_API.G_FALSE - not initialize error
1316: -- message list
1317: -- p_commit (optional, default FND_API.G_FALSE)
1318: -- whether or not to commit the changes to database
1319: -- p_source_item_id Source Item id (can also be a container Item) - Required Value

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

1313: -- if set to FND_API.G_TRUE
1314: -- initialize error message list
1315: -- if set to FND_API.G_FALSE - not initialize error
1316: -- message list
1317: -- p_commit (optional, default FND_API.G_FALSE)
1318: -- whether or not to commit the changes to database
1319: -- p_source_item_id Source Item id (can also be a container Item) - Required Value
1320: -- p_source_qty Source Item Qty - Required Value
1321: -- p_source_qty_uom UOM of Source Item Qty - Required Value

Line 1331: -- fnd_api.g_ret_sts_success;

1327: --
1328: -- Output Parameters
1329: -- x_return_status
1330: -- if the Container_Required_Qty API succeeds, the value is
1331: -- fnd_api.g_ret_sts_success;
1332: -- if there is an expected error, the value is
1333: -- fnd_api.g_ret_sts_error;
1334: -- if there is an unexpected error, the value is
1335: -- fnd_api.g_ret_sts_unexp_error;

Line 1333: -- fnd_api.g_ret_sts_error;

1329: -- x_return_status
1330: -- if the Container_Required_Qty API succeeds, the value is
1331: -- fnd_api.g_ret_sts_success;
1332: -- if there is an expected error, the value is
1333: -- fnd_api.g_ret_sts_error;
1334: -- if there is an unexpected error, the value is
1335: -- fnd_api.g_ret_sts_unexp_error;
1336: -- x_msg_count
1337: -- if there is one or more errors, the number of error messages

Line 1335: -- fnd_api.g_ret_sts_unexp_error;

1331: -- fnd_api.g_ret_sts_success;
1332: -- if there is an expected error, the value is
1333: -- fnd_api.g_ret_sts_error;
1334: -- if there is an unexpected error, the value is
1335: -- fnd_api.g_ret_sts_unexp_error;
1336: -- x_msg_count
1337: -- if there is one or more errors, the number of error messages
1338: -- in the buffer
1339: -- x_msg_data

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

1342: -- p_qty_required Required Container Quantity
1343:
1344: PROCEDURE Container_Required_Qty(
1345: p_api_version IN NUMBER
1346: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1347: , p_commit IN VARCHAR2 := fnd_api.g_false
1348: , x_return_status OUT NOCOPY VARCHAR2
1349: , x_msg_count OUT NOCOPY NUMBER
1350: , x_msg_data OUT NOCOPY VARCHAR2

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

1343:
1344: PROCEDURE Container_Required_Qty(
1345: p_api_version IN NUMBER
1346: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1347: , p_commit IN VARCHAR2 := fnd_api.g_false
1348: , x_return_status OUT NOCOPY VARCHAR2
1349: , x_msg_count OUT NOCOPY NUMBER
1350: , x_msg_data OUT NOCOPY VARCHAR2
1351: , p_source_item_id IN NUMBER

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

1371: --
1372: -- Input Parameters
1373: -- p_api_version
1374: -- API version number (current version is 1.0)
1375: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1376: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1377: -- if set to FND_API.G_TRUE
1378: -- initialize error message list
1379: -- if set to FND_API.G_FALSE - do not initialize error

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

1372: -- Input Parameters
1373: -- p_api_version
1374: -- API version number (current version is 1.0)
1375: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1376: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1377: -- if set to FND_API.G_TRUE
1378: -- initialize error message list
1379: -- if set to FND_API.G_FALSE - do not initialize error
1380: -- message list

Line 1377: -- if set to FND_API.G_TRUE

1373: -- p_api_version
1374: -- API version number (current version is 1.0)
1375: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1376: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1377: -- if set to FND_API.G_TRUE
1378: -- initialize error message list
1379: -- if set to FND_API.G_FALSE - do not initialize error
1380: -- message list
1381: -- p_commit (optional, default FND_API.G_FALSE)

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

1375: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1376: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1377: -- if set to FND_API.G_TRUE
1378: -- initialize error message list
1379: -- if set to FND_API.G_FALSE - do not initialize error
1380: -- message list
1381: -- p_commit (optional, default FND_API.G_FALSE)
1382: -- whether or not to commit the changes to database
1383: -- p_organization_id Organization of the LPN - Required

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

1377: -- if set to FND_API.G_TRUE
1378: -- initialize error message list
1379: -- if set to FND_API.G_FALSE - do not initialize error
1380: -- message list
1381: -- p_commit (optional, default FND_API.G_FALSE)
1382: -- whether or not to commit the changes to database
1383: -- p_organization_id Organization of the LPN - Required
1384: -- p_subinventory Subinventory - Defaults to NULL
1385: -- p_locator_id Locator Id - Defaults to NULL

Line 1409: -- fnd_api.g_ret_sts_success;

1405: -- ERRBUF Concurrent program error buffer
1406: -- RETCODE Concurrent program return code
1407: -- x_return_status
1408: -- if the Prepack_LPN API succeeds, the value is
1409: -- fnd_api.g_ret_sts_success;
1410: -- if there is an expected error, the value is
1411: -- fnd_api.g_ret_sts_error;
1412: -- if there is an unexpected error, the value is
1413: -- fnd_api.g_ret_sts_unexp_error;

Line 1411: -- fnd_api.g_ret_sts_error;

1407: -- x_return_status
1408: -- if the Prepack_LPN API succeeds, the value is
1409: -- fnd_api.g_ret_sts_success;
1410: -- if there is an expected error, the value is
1411: -- fnd_api.g_ret_sts_error;
1412: -- if there is an unexpected error, the value is
1413: -- fnd_api.g_ret_sts_unexp_error;
1414: -- x_msg_count
1415: -- if there is one or more errors, the number of error messages

Line 1413: -- fnd_api.g_ret_sts_unexp_error;

1409: -- fnd_api.g_ret_sts_success;
1410: -- if there is an expected error, the value is
1411: -- fnd_api.g_ret_sts_error;
1412: -- if there is an unexpected error, the value is
1413: -- fnd_api.g_ret_sts_unexp_error;
1414: -- x_msg_count
1415: -- if there is one or more errors, the number of error messages
1416: -- in the buffer
1417: -- x_msg_data

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

1459: --
1460: -- Input Parameters
1461: -- p_api_version
1462: -- API version number (current version is 1.0)
1463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1465: -- if set to FND_API.G_TRUE
1466: -- initialize error message list
1467: -- if set to FND_API.G_FALSE - do not initialize error

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

1460: -- Input Parameters
1461: -- p_api_version
1462: -- API version number (current version is 1.0)
1463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1465: -- if set to FND_API.G_TRUE
1466: -- initialize error message list
1467: -- if set to FND_API.G_FALSE - do not initialize error
1468: -- message list

Line 1465: -- if set to FND_API.G_TRUE

1461: -- p_api_version
1462: -- API version number (current version is 1.0)
1463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1465: -- if set to FND_API.G_TRUE
1466: -- initialize error message list
1467: -- if set to FND_API.G_FALSE - do not initialize error
1468: -- message list
1469: -- p_commit (optional, default FND_API.G_FALSE)

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

1463: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1464: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1465: -- if set to FND_API.G_TRUE
1466: -- initialize error message list
1467: -- if set to FND_API.G_FALSE - do not initialize error
1468: -- message list
1469: -- p_commit (optional, default FND_API.G_FALSE)
1470: -- whether or not to commit the changes to database
1471: -- p_organization_id Organization of the LPN - Required

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

1465: -- if set to FND_API.G_TRUE
1466: -- initialize error message list
1467: -- if set to FND_API.G_FALSE - do not initialize error
1468: -- message list
1469: -- p_commit (optional, default FND_API.G_FALSE)
1470: -- whether or not to commit the changes to database
1471: -- p_organization_id Organization of the LPN - Required
1472: -- p_subinventory Subinventory - Defaults to NULL
1473: -- p_locator_id Locator Id - Defaults to NULL

Line 1495: -- fnd_api.g_ret_sts_success;

1491: --
1492: -- Output Parameters
1493: -- x_return_status
1494: -- if the Prepack_LPN API succeeds, the value is
1495: -- fnd_api.g_ret_sts_success;
1496: -- if there is an expected error, the value is
1497: -- fnd_api.g_ret_sts_error;
1498: -- if there is an unexpected error, the value is
1499: -- fnd_api.g_ret_sts_unexp_error;

Line 1497: -- fnd_api.g_ret_sts_error;

1493: -- x_return_status
1494: -- if the Prepack_LPN API succeeds, the value is
1495: -- fnd_api.g_ret_sts_success;
1496: -- if there is an expected error, the value is
1497: -- fnd_api.g_ret_sts_error;
1498: -- if there is an unexpected error, the value is
1499: -- fnd_api.g_ret_sts_unexp_error;
1500: -- x_msg_count
1501: -- if there is one or more errors, the number of error messages

Line 1499: -- fnd_api.g_ret_sts_unexp_error;

1495: -- fnd_api.g_ret_sts_success;
1496: -- if there is an expected error, the value is
1497: -- fnd_api.g_ret_sts_error;
1498: -- if there is an unexpected error, the value is
1499: -- fnd_api.g_ret_sts_unexp_error;
1500: -- x_msg_count
1501: -- if there is one or more errors, the number of error messages
1502: -- in the buffer
1503: -- x_msg_data

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

1505: --
1506:
1507: PROCEDURE Prepack_LPN(
1508: p_api_version IN NUMBER
1509: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1510: , p_commit IN VARCHAR2 := fnd_api.g_false
1511: , x_return_status OUT NOCOPY VARCHAR2
1512: , x_msg_count OUT NOCOPY NUMBER
1513: , x_msg_data OUT NOCOPY VARCHAR2

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

1506:
1507: PROCEDURE Prepack_LPN(
1508: p_api_version IN NUMBER
1509: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1510: , p_commit IN VARCHAR2 := fnd_api.g_false
1511: , x_return_status OUT NOCOPY VARCHAR2
1512: , x_msg_count OUT NOCOPY NUMBER
1513: , x_msg_data OUT NOCOPY VARCHAR2
1514: , p_organization_id IN NUMBER

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

1544: -- Parameters:
1545: -- IN :
1546: -- p_api_version
1547: -- API version number (current version is 1.0)
1548: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1549: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1550: -- if set to FND_API.G_TRUE
1551: -- initialize error message list
1552: -- if set to FND_API.G_FALSE - not initialize error

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

1545: -- IN :
1546: -- p_api_version
1547: -- API version number (current version is 1.0)
1548: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1549: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1550: -- if set to FND_API.G_TRUE
1551: -- initialize error message list
1552: -- if set to FND_API.G_FALSE - not initialize error
1553: -- message list

Line 1550: -- if set to FND_API.G_TRUE

1546: -- p_api_version
1547: -- API version number (current version is 1.0)
1548: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1549: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1550: -- if set to FND_API.G_TRUE
1551: -- initialize error message list
1552: -- if set to FND_API.G_FALSE - not initialize error
1553: -- message list
1554: -- p_commit (optional, default FND_API.G_FALSE)

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

1548: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1549: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1550: -- if set to FND_API.G_TRUE
1551: -- initialize error message list
1552: -- if set to FND_API.G_FALSE - not initialize error
1553: -- message list
1554: -- p_commit (optional, default FND_API.G_FALSE)
1555: -- whether or not to commit the changes to database
1556: -- p_validation_level (optional), determines if full validation or

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

1550: -- if set to FND_API.G_TRUE
1551: -- initialize error message list
1552: -- if set to FND_API.G_FALSE - not initialize error
1553: -- message list
1554: -- p_commit (optional, default FND_API.G_FALSE)
1555: -- whether or not to commit the changes to database
1556: -- p_validation_level (optional), determines if full validation or
1557: -- no validation will be performed
1558: -- defaults to FND_API.G_VALID_LEVEL_FULL

Line 1558: -- defaults to FND_API.G_VALID_LEVEL_FULL

1554: -- p_commit (optional, default FND_API.G_FALSE)
1555: -- whether or not to commit the changes to database
1556: -- p_validation_level (optional), determines if full validation or
1557: -- no validation will be performed
1558: -- defaults to FND_API.G_VALID_LEVEL_FULL
1559: -- FND_API.G_VALID_LEVEL_NONE is the other value
1560: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1561: -- p_content_item_id Content Item ID - Defaults to NULL
1562: -- p_revision Revision - Defaults to NULL

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

1555: -- whether or not to commit the changes to database
1556: -- p_validation_level (optional), determines if full validation or
1557: -- no validation will be performed
1558: -- defaults to FND_API.G_VALID_LEVEL_FULL
1559: -- FND_API.G_VALID_LEVEL_NONE is the other value
1560: -- p_lpn_id Parent License Plate Number Identifier - Required Value
1561: -- p_content_item_id Content Item ID - Defaults to NULL
1562: -- p_revision Revision - Defaults to NULL
1563: -- p_lot_number Lot Number - Defaults to NULL

Line 1575: -- fnd_api.g_ret_sts_success;

1571: -- p_source_type_id Source type ID for the source transaction
1572: -- OUT :
1573: -- x_return_status
1574: -- if the PackUnpack_Container API succeeds, the value is
1575: -- fnd_api.g_ret_sts_success;
1576: -- if there is an expected error, the value is
1577: -- fnd_api.g_ret_sts_error;
1578: -- if there is an unexpected error, the value is
1579: -- fnd_api.g_ret_sts_unexp_error;

Line 1577: -- fnd_api.g_ret_sts_error;

1573: -- x_return_status
1574: -- if the PackUnpack_Container API succeeds, the value is
1575: -- fnd_api.g_ret_sts_success;
1576: -- if there is an expected error, the value is
1577: -- fnd_api.g_ret_sts_error;
1578: -- if there is an unexpected error, the value is
1579: -- fnd_api.g_ret_sts_unexp_error;
1580: -- x_msg_count
1581: -- if there is one or more errors, the number of error messages

Line 1579: -- fnd_api.g_ret_sts_unexp_error;

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

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

1586: -- End of comments
1587:
1588: PROCEDURE Pack_Prepack_Container(
1589: p_api_version IN NUMBER
1590: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1591: , p_commit IN VARCHAR2 := fnd_api.g_false
1592: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_msg_count OUT NOCOPY NUMBER

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

1587:
1588: PROCEDURE Pack_Prepack_Container(
1589: p_api_version IN NUMBER
1590: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1591: , p_commit IN VARCHAR2 := fnd_api.g_false
1592: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_msg_count OUT NOCOPY NUMBER
1595: , x_msg_data OUT NOCOPY VARCHAR2

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

1588: PROCEDURE Pack_Prepack_Container(
1589: p_api_version IN NUMBER
1590: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1591: , p_commit IN VARCHAR2 := fnd_api.g_false
1592: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_msg_count OUT NOCOPY NUMBER
1595: , x_msg_data OUT NOCOPY VARCHAR2
1596: , p_lpn_id IN NUMBER

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

1616: -- Parameters:
1617: -- IN :
1618: -- p_api_version
1619: -- API version number (current version is 1.0)
1620: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1621: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1622: -- if set to FND_API.G_TRUE
1623: -- initialize error message list
1624: -- if set to FND_API.G_FALSE - not initialize error

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

1617: -- IN :
1618: -- p_api_version
1619: -- API version number (current version is 1.0)
1620: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1621: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1622: -- if set to FND_API.G_TRUE
1623: -- initialize error message list
1624: -- if set to FND_API.G_FALSE - not initialize error
1625: -- message list

Line 1622: -- if set to FND_API.G_TRUE

1618: -- p_api_version
1619: -- API version number (current version is 1.0)
1620: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1621: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1622: -- if set to FND_API.G_TRUE
1623: -- initialize error message list
1624: -- if set to FND_API.G_FALSE - not initialize error
1625: -- message list
1626: -- p_commit (optional, default FND_API.G_FALSE)

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

1620: -- p_init_msg_list (optional, default FND_API.G_FALSE)
1621: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
1622: -- if set to FND_API.G_TRUE
1623: -- initialize error message list
1624: -- if set to FND_API.G_FALSE - not initialize error
1625: -- message list
1626: -- p_commit (optional, default FND_API.G_FALSE)
1627: -- whether or not to commit the changes to database
1628: -- p_lpn_id License Plate Number Identifier - Required Value

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

1622: -- if set to FND_API.G_TRUE
1623: -- initialize error message list
1624: -- if set to FND_API.G_FALSE - not initialize error
1625: -- message list
1626: -- p_commit (optional, default FND_API.G_FALSE)
1627: -- whether or not to commit the changes to database
1628: -- p_lpn_id License Plate Number Identifier - Required Value
1629: -- p_explosion_level Explosion Level - Defaults to 0 (Explode to all levels)
1630: --

Line 1634: -- fnd_api.g_ret_sts_success;

1630: --
1631: -- OUT :
1632: -- x_return_status
1633: -- if the Explode_LPN API succeeds, the value is
1634: -- fnd_api.g_ret_sts_success;
1635: -- if there is an expected error, the value is
1636: -- fnd_api.g_ret_sts_error;
1637: -- if there is an unexpected error, the value is
1638: -- fnd_api.g_ret_sts_unexp_error;

Line 1636: -- fnd_api.g_ret_sts_error;

1632: -- x_return_status
1633: -- if the Explode_LPN API succeeds, the value is
1634: -- fnd_api.g_ret_sts_success;
1635: -- if there is an expected error, the value is
1636: -- fnd_api.g_ret_sts_error;
1637: -- if there is an unexpected error, the value is
1638: -- fnd_api.g_ret_sts_unexp_error;
1639: -- x_msg_count
1640: -- if there is one or more errors, the number of error messages

Line 1638: -- fnd_api.g_ret_sts_unexp_error;

1634: -- fnd_api.g_ret_sts_success;
1635: -- if there is an expected error, the value is
1636: -- fnd_api.g_ret_sts_error;
1637: -- if there is an unexpected error, the value is
1638: -- fnd_api.g_ret_sts_unexp_error;
1639: -- x_msg_count
1640: -- if there is one or more errors, the number of error messages
1641: -- in the buffer
1642: -- x_msg_data

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

1645: -- End of comments
1646:
1647: PROCEDURE Explode_LPN (
1648: p_api_version IN NUMBER
1649: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1650: , p_commit IN VARCHAR2 := fnd_api.g_false
1651: , x_return_status OUT NOCOPY VARCHAR2
1652: , x_msg_count OUT NOCOPY NUMBER
1653: , x_msg_data OUT NOCOPY VARCHAR2

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

1646:
1647: PROCEDURE Explode_LPN (
1648: p_api_version IN NUMBER
1649: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1650: , p_commit IN VARCHAR2 := fnd_api.g_false
1651: , x_return_status OUT NOCOPY VARCHAR2
1652: , x_msg_count OUT NOCOPY NUMBER
1653: , x_msg_data OUT NOCOPY VARCHAR2
1654: , p_lpn_id IN NUMBER

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

1750: -- End of comments
1751:
1752: PROCEDURE Merge_Up_LPN (
1753: p_api_version IN NUMBER
1754: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1755: , p_commit IN VARCHAR2 := fnd_api.g_false
1756: , x_return_status OUT NOCOPY VARCHAR2
1757: , x_msg_count OUT NOCOPY NUMBER
1758: , x_msg_data OUT NOCOPY VARCHAR2

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

1751:
1752: PROCEDURE Merge_Up_LPN (
1753: p_api_version IN NUMBER
1754: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1755: , p_commit IN VARCHAR2 := fnd_api.g_false
1756: , x_return_status OUT NOCOPY VARCHAR2
1757: , x_msg_count OUT NOCOPY NUMBER
1758: , x_msg_data OUT NOCOPY VARCHAR2
1759: , p_organization_id IN NUMBER

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

1793: -- End of comments
1794:
1795: PROCEDURE Break_Down_LPN (
1796: p_api_version IN NUMBER
1797: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1798: , p_commit IN VARCHAR2 := fnd_api.g_false
1799: , x_return_status OUT NOCOPY VARCHAR2
1800: , x_msg_count OUT NOCOPY NUMBER
1801: , x_msg_data OUT NOCOPY VARCHAR2

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

1794:
1795: PROCEDURE Break_Down_LPN (
1796: p_api_version IN NUMBER
1797: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1798: , p_commit IN VARCHAR2 := fnd_api.g_false
1799: , x_return_status OUT NOCOPY VARCHAR2
1800: , x_msg_count OUT NOCOPY NUMBER
1801: , x_msg_data OUT NOCOPY VARCHAR2
1802: , p_organization_id IN NUMBER

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

1823: -- End of comments
1824:
1825: PROCEDURE Initialize_LPN (
1826: p_api_version IN NUMBER
1827: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1828: , p_commit IN VARCHAR2 := fnd_api.g_false
1829: , x_return_status OUT NOCOPY VARCHAR2
1830: , x_msg_count OUT NOCOPY NUMBER
1831: , x_msg_data OUT NOCOPY VARCHAR2

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

1824:
1825: PROCEDURE Initialize_LPN (
1826: p_api_version IN NUMBER
1827: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1828: , p_commit IN VARCHAR2 := fnd_api.g_false
1829: , x_return_status OUT NOCOPY VARCHAR2
1830: , x_msg_count OUT NOCOPY NUMBER
1831: , x_msg_data OUT NOCOPY VARCHAR2
1832: , p_organization_id IN NUMBER

Line 1849: -- fnd_api.g_ret_sts_success;

1845: -- p_lpn_id The LPN which is being split or consolidated.
1846: -- Output Parameters
1847: -- x_return_status
1848: -- if the plan_delivery API succeeds, the value is
1849: -- fnd_api.g_ret_sts_success;
1850: -- if there is an expected error, the value is
1851: -- fnd_api.g_ret_sts_error;
1852: -- if there is an unexpected error, the value is
1853: -- fnd_api.g_ret_sts_unexp_error;

Line 1851: -- fnd_api.g_ret_sts_error;

1847: -- x_return_status
1848: -- if the plan_delivery API succeeds, the value is
1849: -- fnd_api.g_ret_sts_success;
1850: -- if there is an expected error, the value is
1851: -- fnd_api.g_ret_sts_error;
1852: -- if there is an unexpected error, the value is
1853: -- fnd_api.g_ret_sts_unexp_error;
1854: -- x_msg_count
1855: -- if there is one or more errors, the number of error messages

Line 1853: -- fnd_api.g_ret_sts_unexp_error;

1849: -- fnd_api.g_ret_sts_success;
1850: -- if there is an expected error, the value is
1851: -- fnd_api.g_ret_sts_error;
1852: -- if there is an unexpected error, the value is
1853: -- fnd_api.g_ret_sts_unexp_error;
1854: -- x_msg_count
1855: -- if there is one or more errors, the number of error messages
1856: -- in the buffer
1857: -- x_msg_data