DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on INV_LOC_WMS_UTILS

Line 4485: log_statement(l_api_name, 'calling_revert', 'Calling inv_loc_wms_utils.revert_loc_suggested_capacity');

4481: -- to update if locator_id is null
4482: IF l_line.to_locator_id IS NOT NULL THEN
4483:
4484: IF l_debug = 1 THEN
4485: log_statement(l_api_name, 'calling_revert', 'Calling inv_loc_wms_utils.revert_loc_suggested_capacity');
4486: log_statement(l_api_name, 'revert_org', 'Org: ' || p_organization_id);
4487: log_statement(l_api_name, 'revert_item', 'Item: ' || p_inventory_item_id);
4488: log_statement(l_api_name, 'revert_loc', 'Loc: ' || l_line.to_locator_id);
4489: log_statement(l_api_name, 'revert_qty', 'Qty: ' || l_line.quantity);

Line 4491: inv_loc_wms_utils.revert_loc_suggested_capacity(

4487: log_statement(l_api_name, 'revert_item', 'Item: ' || p_inventory_item_id);
4488: log_statement(l_api_name, 'revert_loc', 'Loc: ' || l_line.to_locator_id);
4489: log_statement(l_api_name, 'revert_qty', 'Qty: ' || l_line.quantity);
4490: END IF;
4491: inv_loc_wms_utils.revert_loc_suggested_capacity(
4492: x_return_status => l_return_status
4493: , x_msg_count => l_msg_count
4494: , x_msg_data => l_msg_data
4495: , p_organization_id => p_organization_id

Line 4512: log_statement(l_api_name, 'first_error', 'Error in inv_loc_wms_utils.revert_loc_suggested_capacity');

4508: x_msg_data := l_msg_data;
4509: l_no_error := FALSE;
4510:
4511: IF l_debug = 1 THEN
4512: log_statement(l_api_name, 'first_error', 'Error in inv_loc_wms_utils.revert_loc_suggested_capacity');
4513: END IF;
4514: END IF;
4515: END IF;
4516: END LOOP;

Line 12969: inv_loc_wms_utils.update_loc_suggested_capacity(

12965: IF l_olocator_id IS NOT NULL THEN
12966: IF l_debug = 1 THEN
12967: log_statement(l_api_name, 'update_capacity', 'Updating suggested capacity');
12968: END IF;
12969: inv_loc_wms_utils.update_loc_suggested_capacity(
12970: x_return_status => x_return_status
12971: , x_msg_count => x_msg_count
12972: , x_msg_data => x_msg_data
12973: , p_organization_id => p_organization_id

Line 13274: inv_loc_wms_utils.revert_loc_suggested_capacity(

13270: IF l_capacity_updated THEN
13271: IF l_debug = 1 THEN
13272: log_statement(l_api_name, 'revert_capacity', 'Calling revert_loc_suggested_capacity');
13273: END IF;
13274: inv_loc_wms_utils.revert_loc_suggested_capacity(
13275: x_return_status => x_return_status
13276: , x_msg_count => x_msg_count
13277: , x_msg_data => x_msg_data
13278: , p_organization_id => p_organization_id

Line 13464: inv_loc_wms_utils.revert_loc_suggested_capacity(

13460:
13461: --if error occurred after capacity got updated but before
13462: -- insertion into WTT, fix the capacity for that record
13463: IF l_capacity_updated THEN
13464: inv_loc_wms_utils.revert_loc_suggested_capacity(
13465: x_return_status => l_return_status
13466: , x_msg_count => l_msg_count
13467: , x_msg_data => l_msg_data
13468: , p_organization_id => p_organization_id

Line 13507: inv_loc_wms_utils.revert_loc_suggested_capacity(

13503:
13504: --if error occurred after capacity got updated but before
13505: -- insertion into WTT, fix the capacity for that record
13506: IF l_capacity_updated THEN
13507: inv_loc_wms_utils.revert_loc_suggested_capacity(
13508: x_return_status => l_return_status
13509: , x_msg_count => l_msg_count
13510: , x_msg_data => l_msg_data
13511: , p_organization_id => p_organization_id

Line 13550: inv_loc_wms_utils.revert_loc_suggested_capacity(

13546:
13547: --if error occurred after capacity got updated but before
13548: -- insertion into WTT, fix the capacity for that record
13549: IF l_capacity_updated THEN
13550: inv_loc_wms_utils.revert_loc_suggested_capacity(
13551: x_return_status => l_return_status
13552: , x_msg_count => l_msg_count
13553: , x_msg_data => l_msg_data
13554: , p_organization_id => p_organization_id