DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on WMS_CONTAINER_PVT

Line 226: l_lpn_bulk_rec WMS_CONTAINER_PVT.LPNBulkRecType;

222: -- Variables use by Auto_Create_LPNs
223: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
224: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
225: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
226: l_lpn_bulk_rec WMS_CONTAINER_PVT.LPNBulkRecType;
227:
228: -- Validation Parameters
229: l_quantity NUMBER;
230: l_org inv_validate.org;

Line 577: WMS_Container_PVT.Auto_Create_LPNs (

573:
574: l_serial_tbl(1).fm_serial_number := p_from_serial_number;
575: l_serial_tbl(1).to_serial_number := p_to_serial_number;
576:
577: WMS_Container_PVT.Auto_Create_LPNs (
578: p_api_version => p_api_version
579: , p_init_msg_list => fnd_api.g_false
580: , p_commit => fnd_api.g_false
581: , x_return_status => x_return_status

Line 602: mdebug('Call to WMS_Container_PVT.Auto_Create_LPNs Failed', G_ERROR);

598: p_lpn_id_out := l_gen_lpn_tbl(1).lpn_id;
599: p_lpn_out := l_gen_lpn_tbl(1).license_plate_number;
600: ELSE
601: IF ( l_debug = 1 ) THEN
602: mdebug('Call to WMS_Container_PVT.Auto_Create_LPNs Failed', G_ERROR);
603: END IF;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;
606:

Line 1443: WMS_CONTAINER_PVT.Create_LPN (

1439: END IF;
1440:
1441: /* End of input validation */
1442:
1443: WMS_CONTAINER_PVT.Create_LPN (
1444: p_api_version => p_api_version
1445: , p_init_msg_list => p_init_msg_list
1446: , p_commit => p_commit
1447: , p_validation_level => p_validation_level

Line 1471: mdebug('Call to WMS_CONTAINER_PVT.Create_LPN Failed', G_ERROR);

1467: , x_lpn_id => x_lpn_id );
1468:
1469: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
1470: IF ( l_debug = 1 ) THEN
1471: mdebug('Call to WMS_CONTAINER_PVT.Create_LPN Failed', G_ERROR);
1472: END IF;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END IF;
1475:

Line 1767: WMS_CONTAINER_PVT.Modify_LPN (

1763: ELSIF ( p_lpn.source_name IS NULL ) THEN
1764: l_lpn.source_name := fnd_api.g_miss_char;
1765: END IF;
1766:
1767: WMS_CONTAINER_PVT.Modify_LPN (
1768: p_api_version => p_api_version
1769: , p_init_msg_list => p_init_msg_list
1770: , p_commit => p_commit
1771: , p_validation_level => p_validation_level

Line 1779: mdebug('Call to WMS_CONTAINER_PVT.Modify_LPN Failed', G_ERROR);

1775: , p_lpn => l_lpn );
1776:
1777: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
1778: IF ( l_debug = 1 ) THEN
1779: mdebug('Call to WMS_CONTAINER_PVT.Modify_LPN Failed', G_ERROR);
1780: END IF;
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783:

Line 1875: WMS_CONTAINER_PVT.Modify_LPN_Wrapper(

1871: fnd_msg_pub.ADD;
1872: RAISE fnd_api.g_exc_error;
1873: END IF;
1874:
1875: WMS_CONTAINER_PVT.Modify_LPN_Wrapper(
1876: p_api_version => p_api_version
1877: , p_init_msg_list => p_init_msg_list
1878: , p_commit => p_commit
1879: , p_validation_level => p_validation_level

Line 2457: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP

2453:
2454: /* Validate Quantity if item is not serial controlled */
2455: IF (p_content_item_id IS NOT NULL) THEN
2456: IF (l_content_item.serial_number_control_code IN (1, 6)
2457: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP
2458: ) THEN
2459: IF (p_quantity <= 0) THEN
2460: IF (l_debug = 1) THEN
2461: mdebug('Requested a negative item qty', G_ERROR);

Line 2591: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN

2587: --l_current_serial := RPAD(l_prefix, l_padded_length, '0') ||
2588: --l_current_number;
2589: END LOOP;
2590: END IF;
2591: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN
2592: -- If lpn context is prepacked for WIP, user does not need to specify sn
2593: -- Needs to be treated like a non serial item, no mtl_serial_number entry
2594: -- except serial_summary_entry flag should be set.
2595: l_serial_summary_entry := 1;

Line 2671: WMS_CONTAINER_PVT.PackUnpack_Container (

2667: -- Change operation to new Unpack All type
2668: l_operation := 4;
2669: END IF;
2670:
2671: WMS_CONTAINER_PVT.PackUnpack_Container (
2672: p_api_version => p_api_version
2673: , p_init_msg_list => p_init_msg_list
2674: , p_commit => p_commit
2675: , p_validation_level => p_validation_level

Line 2910: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP

2906:
2907: /* Validate Quantity if item is not serial controlled */
2908: IF (p_content_item_id IS NOT NULL) THEN
2909: IF (l_content_item.serial_number_control_code IN (1, 6)
2910: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP
2911: ) THEN
2912: IF (p_quantity <= 0) THEN
2913: IF (l_debug = 1) THEN
2914: mdebug('Requested a negative item qty', 1);

Line 3013: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN

3009: -- Bug 2375043
3010: --l_current_serial := RPAD(l_prefix, l_padded_length, '0') || l_current_number;
3011: END LOOP;
3012: END IF;
3013: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN
3014: -- If lpn context is prepacked for WIP, user does not need to specify sn
3015: -- Needs to be treated like a non serial item, no mtl_serial_number entry
3016: -- except serial_summary_entry flag should be set.
3017: l_serial_summary_entry := 1;

Line 3055: WMS_CONTAINER_PVT.Pack_Prepack_Container (

3051: END IF;
3052: END IF;
3053: /* End of Input Validation */
3054:
3055: WMS_CONTAINER_PVT.Pack_Prepack_Container (
3056: p_api_version => p_api_version
3057: , p_init_msg_list => p_init_msg_list
3058: , p_commit => p_commit
3059: , p_validation_level => p_validation_level

Line 3124: WMS_CONTAINER_PVT.explode_lpn(

3120: x_content_tbl OUT NOCOPY wms_container_tbl_type
3121: ) IS
3122: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3123: BEGIN
3124: WMS_CONTAINER_PVT.explode_lpn(
3125: p_api_version=> p_api_version,
3126: p_init_msg_list=> p_init_msg_list,
3127: p_commit=> p_commit,
3128: x_return_status=> x_return_status,

Line 3157: WMS_CONTAINER_PVT.container_required_qty(

3153: p_qty_required OUT NOCOPY NUMBER
3154: ) IS
3155: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3156: BEGIN
3157: WMS_CONTAINER_PVT.container_required_qty(
3158: p_api_version=> p_api_version,
3159: p_init_msg_list=> p_init_msg_list,
3160: p_commit=> p_commit,
3161: x_return_status=> x_return_status,

Line 3234: WMS_CONTAINER_PVT.prepack_lpn(

3230: x_return_status := fnd_api.g_ret_sts_success;
3231: -- Start API body
3232:
3233: -- Call Prepack LPN
3234: WMS_CONTAINER_PVT.prepack_lpn(
3235: p_api_version=> p_api_version,
3236: p_init_msg_list=> p_init_msg_list,
3237: p_commit=> p_commit,
3238: x_return_status=> x_return_status,

Line 3307: RETURN WMS_CONTAINER_PVT.Validate_LPN (

3303: FUNCTION Validate_LPN( p_lpn IN OUT nocopy LPN, p_lock IN NUMBER := 2) RETURN NUMBER
3304: IS
3305:
3306: BEGIN
3307: RETURN WMS_CONTAINER_PVT.Validate_LPN (
3308: p_lpn => p_lpn
3309: , p_lock => p_lock );
3310: EXCEPTION
3311: WHEN OTHERS THEN

Line 3425: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3421: END IF;
3422:
3423: l_progress := '300';
3424: -- Validate if LPN is valid for this transaction
3425: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3426: p_organization_id => p_organization_id
3427: , p_lpn_id => p_outermost_lpn_id
3428: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3429:

Line 3428: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );

3424: -- Validate if LPN is valid for this transaction
3425: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3426: p_organization_id => p_organization_id
3427: , p_lpn_id => p_outermost_lpn_id
3428: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3429:
3430: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3431: IF ( l_debug = 1 ) THEN
3432: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);

Line 3430: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN

3426: p_organization_id => p_organization_id
3427: , p_lpn_id => p_outermost_lpn_id
3428: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3429:
3430: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3431: IF ( l_debug = 1 ) THEN
3432: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);
3433: END IF;
3434: RAISE FND_API.G_EXC_ERROR;

Line 3438: WMS_CONTAINER_PVT.Merge_Up_LPN (

3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436:
3437: l_progress := '400';
3438: WMS_CONTAINER_PVT.Merge_Up_LPN (
3439: p_api_version => p_api_version
3440: , p_init_msg_list => p_init_msg_list
3441: , p_commit => p_commit
3442: , x_return_status => x_return_status

Line 3549: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3545: END IF;
3546:
3547: l_progress := '300';
3548: -- Validate if LPN is valid for this transaction
3549: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3550: p_organization_id => p_organization_id
3551: , p_lpn_id => p_outermost_lpn_id
3552: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3553:

Line 3552: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );

3548: -- Validate if LPN is valid for this transaction
3549: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3550: p_organization_id => p_organization_id
3551: , p_lpn_id => p_outermost_lpn_id
3552: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3553:
3554: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3555: IF ( l_debug = 1 ) THEN
3556: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);

Line 3554: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN

3550: p_organization_id => p_organization_id
3551: , p_lpn_id => p_outermost_lpn_id
3552: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3553:
3554: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3555: IF ( l_debug = 1 ) THEN
3556: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);
3557: END IF;
3558: RAISE FND_API.G_EXC_ERROR;

Line 3562: WMS_CONTAINER_PVT.Break_Down_LPN (

3558: RAISE FND_API.G_EXC_ERROR;
3559: END IF;
3560:
3561: l_progress := '400';
3562: WMS_CONTAINER_PVT.Break_Down_LPN (
3563: p_api_version => p_api_version
3564: , p_init_msg_list => p_init_msg_list
3565: , p_commit => p_commit
3566: , x_return_status => x_return_status

Line 3673: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3669: END IF;
3670:
3671: l_progress := '300';
3672: -- Validate if LPN is valid for this transaction
3673: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3674: p_organization_id => p_organization_id
3675: , p_lpn_id => p_outermost_lpn_id
3676: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3677:

Line 3676: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );

3672: -- Validate if LPN is valid for this transaction
3673: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3674: p_organization_id => p_organization_id
3675: , p_lpn_id => p_outermost_lpn_id
3676: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3677:
3678: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3679: IF ( l_debug = 1 ) THEN
3680: mdebug(p_outermost_lpn_id || ' cannot initialize LPN', G_ERROR);

Line 3678: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN

3674: p_organization_id => p_organization_id
3675: , p_lpn_id => p_outermost_lpn_id
3676: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3677:
3678: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3679: IF ( l_debug = 1 ) THEN
3680: mdebug(p_outermost_lpn_id || ' cannot initialize LPN', G_ERROR);
3681: END IF;
3682: RAISE FND_API.G_EXC_ERROR;

Line 3686: WMS_CONTAINER_PVT.Initialize_LPN (

3682: RAISE FND_API.G_EXC_ERROR;
3683: END IF;
3684:
3685: l_progress := '400';
3686: WMS_CONTAINER_PVT.Initialize_LPN (
3687: p_api_version => p_api_version
3688: , p_init_msg_list => p_init_msg_list
3689: , p_commit => p_commit
3690: , x_return_status => x_return_status