DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on WMS_CONTAINER_PVT

Line 151: l_lpn_bulk_rec WMS_CONTAINER_PVT.LPNBulkRecType;

147: -- Variables use by Auto_Create_LPNs
148: l_lpn_att_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
149: l_serial_tbl WMS_Data_Type_Definitions_PUB.SerialRangeTableType;
150: l_gen_lpn_tbl WMS_Data_Type_Definitions_PUB.LPNTableType;
151: l_lpn_bulk_rec WMS_CONTAINER_PVT.LPNBulkRecType;
152:
153: -- Validation Parameters
154: l_quantity NUMBER;
155: l_org inv_validate.org;

Line 502: WMS_Container_PVT.Auto_Create_LPNs (

498:
499: l_serial_tbl(1).fm_serial_number := p_from_serial_number;
500: l_serial_tbl(1).to_serial_number := p_to_serial_number;
501:
502: WMS_Container_PVT.Auto_Create_LPNs (
503: p_api_version => p_api_version
504: , p_init_msg_list => fnd_api.g_false
505: , p_commit => fnd_api.g_false
506: , x_return_status => x_return_status

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

521: p_lpn_id_out := l_gen_lpn_tbl(1).lpn_id;
522: p_lpn_out := l_gen_lpn_tbl(1).license_plate_number;
523: ELSE
524: IF ( l_debug = 1 ) THEN
525: mdebug('Call to WMS_Container_PVT.Auto_Create_LPNs Failed', G_ERROR);
526: END IF;
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529:

Line 1366: WMS_CONTAINER_PVT.Create_LPN (

1362: END IF;
1363:
1364: /* End of input validation */
1365:
1366: WMS_CONTAINER_PVT.Create_LPN (
1367: p_api_version => p_api_version
1368: , p_init_msg_list => p_init_msg_list
1369: , p_commit => p_commit
1370: , p_validation_level => p_validation_level

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

1390: , x_lpn_id => x_lpn_id );
1391:
1392: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
1393: IF ( l_debug = 1 ) THEN
1394: mdebug('Call to WMS_CONTAINER_PVT.Create_LPN Failed', G_ERROR);
1395: END IF;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398:

Line 1690: WMS_CONTAINER_PVT.Modify_LPN (

1686: ELSIF ( p_lpn.source_name IS NULL ) THEN
1687: l_lpn.source_name := fnd_api.g_miss_char;
1688: END IF;
1689:
1690: WMS_CONTAINER_PVT.Modify_LPN (
1691: p_api_version => p_api_version
1692: , p_init_msg_list => p_init_msg_list
1693: , p_commit => p_commit
1694: , p_validation_level => p_validation_level

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

1698: , p_lpn => l_lpn );
1699:
1700: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
1701: IF ( l_debug = 1 ) THEN
1702: mdebug('Call to WMS_CONTAINER_PVT.Modify_LPN Failed', G_ERROR);
1703: END IF;
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:

Line 1798: WMS_CONTAINER_PVT.Modify_LPN_Wrapper(

1794: fnd_msg_pub.ADD;
1795: RAISE fnd_api.g_exc_error;
1796: END IF;
1797:
1798: WMS_CONTAINER_PVT.Modify_LPN_Wrapper(
1799: p_api_version => p_api_version
1800: , p_init_msg_list => p_init_msg_list
1801: , p_commit => p_commit
1802: , p_validation_level => p_validation_level

Line 2380: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP

2376:
2377: /* Validate Quantity if item is not serial controlled */
2378: IF (p_content_item_id IS NOT NULL) THEN
2379: IF (l_content_item.serial_number_control_code IN (1, 6)
2380: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP
2381: ) THEN
2382: IF (p_quantity <= 0) THEN
2383: IF (l_debug = 1) THEN
2384: mdebug('Requested a negative item qty', G_ERROR);

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

2509: --l_current_serial := RPAD(l_prefix, l_padded_length, '0') ||
2510: --l_current_number;
2511: END LOOP;
2512: END IF;
2513: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN
2514: -- If lpn context is prepacked for WIP, user does not need to specify sn
2515: -- Needs to be treated like a non serial item, no mtl_serial_number entry
2516: -- except serial_summary_entry flag should be set.
2517: l_serial_summary_entry := 1;

Line 2593: WMS_CONTAINER_PVT.PackUnpack_Container (

2589: -- Change operation to new Unpack All type
2590: l_operation := 4;
2591: END IF;
2592:
2593: WMS_CONTAINER_PVT.PackUnpack_Container (
2594: p_api_version => p_api_version
2595: , p_init_msg_list => p_init_msg_list
2596: , p_commit => p_commit
2597: , p_validation_level => p_validation_level

Line 2832: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP

2828:
2829: /* Validate Quantity if item is not serial controlled */
2830: IF (p_content_item_id IS NOT NULL) THEN
2831: IF (l_content_item.serial_number_control_code IN (1, 6)
2832: OR l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP
2833: ) THEN
2834: IF (p_quantity <= 0) THEN
2835: IF (l_debug = 1) THEN
2836: mdebug('Requested a negative item qty', 1);

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

2931: -- Bug 2375043
2932: --l_current_serial := RPAD(l_prefix, l_padded_length, '0') || l_current_number;
2933: END LOOP;
2934: END IF;
2935: ELSIF (l_lpn.lpn_context = WMS_CONTAINER_PVT.LPN_PREPACK_FOR_WIP) THEN
2936: -- If lpn context is prepacked for WIP, user does not need to specify sn
2937: -- Needs to be treated like a non serial item, no mtl_serial_number entry
2938: -- except serial_summary_entry flag should be set.
2939: l_serial_summary_entry := 1;

Line 2977: WMS_CONTAINER_PVT.Pack_Prepack_Container (

2973: END IF;
2974: END IF;
2975: /* End of Input Validation */
2976:
2977: WMS_CONTAINER_PVT.Pack_Prepack_Container (
2978: p_api_version => p_api_version
2979: , p_init_msg_list => p_init_msg_list
2980: , p_commit => p_commit
2981: , p_validation_level => p_validation_level

Line 3046: WMS_CONTAINER_PVT.explode_lpn(

3042: x_content_tbl OUT NOCOPY wms_container_tbl_type
3043: ) IS
3044: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3045: BEGIN
3046: WMS_CONTAINER_PVT.explode_lpn(
3047: p_api_version=> p_api_version,
3048: p_init_msg_list=> p_init_msg_list,
3049: p_commit=> p_commit,
3050: x_return_status=> x_return_status,

Line 3079: WMS_CONTAINER_PVT.container_required_qty(

3075: p_qty_required OUT NOCOPY NUMBER
3076: ) IS
3077: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3078: BEGIN
3079: WMS_CONTAINER_PVT.container_required_qty(
3080: p_api_version=> p_api_version,
3081: p_init_msg_list=> p_init_msg_list,
3082: p_commit=> p_commit,
3083: x_return_status=> x_return_status,

Line 3156: WMS_CONTAINER_PVT.prepack_lpn(

3152: x_return_status := fnd_api.g_ret_sts_success;
3153: -- Start API body
3154:
3155: -- Call Prepack LPN
3156: WMS_CONTAINER_PVT.prepack_lpn(
3157: p_api_version=> p_api_version,
3158: p_init_msg_list=> p_init_msg_list,
3159: p_commit=> p_commit,
3160: x_return_status=> x_return_status,

Line 3229: RETURN WMS_CONTAINER_PVT.Validate_LPN (

3225: FUNCTION Validate_LPN( p_lpn IN OUT nocopy LPN, p_lock IN NUMBER := 2) RETURN NUMBER
3226: IS
3227:
3228: BEGIN
3229: RETURN WMS_CONTAINER_PVT.Validate_LPN (
3230: p_lpn => p_lpn
3231: , p_lock => p_lock );
3232: EXCEPTION
3233: WHEN OTHERS THEN

Line 3347: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3343: END IF;
3344:
3345: l_progress := '300';
3346: -- Validate if LPN is valid for this transaction
3347: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3348: p_organization_id => p_organization_id
3349: , p_lpn_id => p_outermost_lpn_id
3350: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3351:

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

3346: -- Validate if LPN is valid for this transaction
3347: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3348: p_organization_id => p_organization_id
3349: , p_lpn_id => p_outermost_lpn_id
3350: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3351:
3352: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3353: IF ( l_debug = 1 ) THEN
3354: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);

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

3348: p_organization_id => p_organization_id
3349: , p_lpn_id => p_outermost_lpn_id
3350: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3351:
3352: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3353: IF ( l_debug = 1 ) THEN
3354: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);
3355: END IF;
3356: RAISE FND_API.G_EXC_ERROR;

Line 3360: WMS_CONTAINER_PVT.Merge_Up_LPN (

3356: RAISE FND_API.G_EXC_ERROR;
3357: END IF;
3358:
3359: l_progress := '400';
3360: WMS_CONTAINER_PVT.Merge_Up_LPN (
3361: p_api_version => p_api_version
3362: , p_init_msg_list => p_init_msg_list
3363: , p_commit => p_commit
3364: , x_return_status => x_return_status

Line 3471: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3467: END IF;
3468:
3469: l_progress := '300';
3470: -- Validate if LPN is valid for this transaction
3471: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3472: p_organization_id => p_organization_id
3473: , p_lpn_id => p_outermost_lpn_id
3474: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3475:

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

3470: -- Validate if LPN is valid for this transaction
3471: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3472: p_organization_id => p_organization_id
3473: , p_lpn_id => p_outermost_lpn_id
3474: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3475:
3476: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3477: IF ( l_debug = 1 ) THEN
3478: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);

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

3472: p_organization_id => p_organization_id
3473: , p_lpn_id => p_outermost_lpn_id
3474: , p_validation_type => WMS_CONTAINER_PVT.G_RECONFIGURE_LPN );
3475:
3476: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3477: IF ( l_debug = 1 ) THEN
3478: mdebug(p_outermost_lpn_id || ' cannot be used for merge up', G_ERROR);
3479: END IF;
3480: RAISE FND_API.G_EXC_ERROR;

Line 3484: WMS_CONTAINER_PVT.Break_Down_LPN (

3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:
3483: l_progress := '400';
3484: WMS_CONTAINER_PVT.Break_Down_LPN (
3485: p_api_version => p_api_version
3486: , p_init_msg_list => p_init_msg_list
3487: , p_commit => p_commit
3488: , x_return_status => x_return_status

Line 3595: l_result := WMS_CONTAINER_PVT.Validate_LPN (

3591: END IF;
3592:
3593: l_progress := '300';
3594: -- Validate if LPN is valid for this transaction
3595: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3596: p_organization_id => p_organization_id
3597: , p_lpn_id => p_outermost_lpn_id
3598: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3599:

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

3594: -- Validate if LPN is valid for this transaction
3595: l_result := WMS_CONTAINER_PVT.Validate_LPN (
3596: p_organization_id => p_organization_id
3597: , p_lpn_id => p_outermost_lpn_id
3598: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3599:
3600: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3601: IF ( l_debug = 1 ) THEN
3602: mdebug(p_outermost_lpn_id || ' cannot initialize LPN', G_ERROR);

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

3596: p_organization_id => p_organization_id
3597: , p_lpn_id => p_outermost_lpn_id
3598: , p_validation_type => WMS_CONTAINER_PVT.G_NO_ONHAND_EXISTS );
3599:
3600: IF ( l_result = WMS_CONTAINER_PVT.F ) THEN
3601: IF ( l_debug = 1 ) THEN
3602: mdebug(p_outermost_lpn_id || ' cannot initialize LPN', G_ERROR);
3603: END IF;
3604: RAISE FND_API.G_EXC_ERROR;

Line 3608: WMS_CONTAINER_PVT.Initialize_LPN (

3604: RAISE FND_API.G_EXC_ERROR;
3605: END IF;
3606:
3607: l_progress := '400';
3608: WMS_CONTAINER_PVT.Initialize_LPN (
3609: p_api_version => p_api_version
3610: , p_init_msg_list => p_init_msg_list
3611: , p_commit => p_commit
3612: , x_return_status => x_return_status