DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on WSH_DELIVERY_DETAILS_ACTIONS

Line 294: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

290:
291: l_mdc_detail_tab(1) := p_backorder_rec_tbl(i).delivery_detail_id;
292: IF p_backorder_rec_tbl(i).planned_flag = 'N' THEN --{
293: l_mdc_detail_tab(1) := p_backorder_rec_tbl(i).delivery_detail_id;
294: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
295: p_detail_id_tab => l_mdc_detail_tab,
296: x_return_status => l_return_status);
297:
298: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

Line 300: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record');

296: x_return_status => l_return_status);
297:
298: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record');
301: END IF;
302: ROLLBACK TO unassign_backorder_details;
303: l_num_errors := l_num_errors + 1;
304: GOTO next_record;

Line 307: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record ');

303: l_num_errors := l_num_errors + 1;
304: GOTO next_record;
305: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record ');
308: END IF;
309: RAISE e_return;
310: END IF;
311: --}

Line 314: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(

310: END IF;
311: --}
312: ELSIF p_org_info_tbl(p_backorder_rec_tbl(i).organization_id).wms_org = 'Y' THEN --{
313: l_mdc_detail_tab(1) := p_backorder_rec_tbl(i).delivery_detail_id;
314: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(
315: p_detail_id_tab => l_mdc_detail_tab,
316: x_return_status => l_return_status);
317:
318: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

Line 320: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');

316: x_return_status => l_return_status);
317:
318: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');
321: END IF;
322: ROLLBACK TO unassign_backorder_details;
323: l_num_errors := l_num_errors + 1;
324: GOTO next_record;

Line 327: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');

323: l_num_errors := l_num_errors + 1;
324: GOTO next_record;
325: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');
328: END IF;
329: RAISE e_return;
330: END IF;
331: END IF; --}

Line 3509: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines

3505:
3506: -- Added the record to call the WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
3507: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3508:
3509: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines
3510: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3511: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;
3512:
3513: -- To store the shipping global parameter "Consolidate BO lines" value

Line 3510: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

3506: -- Added the record to call the WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
3507: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3508:
3509: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines
3510: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3511: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;
3512:
3513: -- To store the shipping global parameter "Consolidate BO lines" value
3514: l_auto_consolidate VARCHAR2(1) := 'N';

Line 4016: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4012: --
4013: l_changed_attributes(l_counter).action_flag := 'U';
4014: ELSE
4015: -- odaboval : Begin of OPM Changes (Pick_Confirm)
4016: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4017: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4018: p_req_quantity => l_split_quantity,
4019: x_new_detail_id => l_dummy_detail_id,
4020: x_return_status => l_return_status,

Line 4085: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4081: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
4082:
4083: IF l_split_quantity < old_delivery_detail_rec.picked_quantity THEN
4084:
4085: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4086: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4087: p_req_quantity => l_split_quantity,
4088: x_new_detail_id => l_dummy_detail_id,
4089: x_return_status => l_return_status,

Line 4193: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

4189: --
4190: -- Debug Statements
4191: --
4192: IF l_debug_on THEN
4193: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4194: END IF;
4195: --
4196: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4197: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,

Line 4196: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4192: IF l_debug_on THEN
4193: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4194: END IF;
4195: --
4196: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4197: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4198: p_req_quantity => l_split_quantity,
4199: x_new_detail_id => l_dummy_detail_id,
4200: x_return_status => l_return_status,

Line 4403: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4399: IF l_debug_on THEN
4400: WSH_DEBUG_SV.logmsg(l_module_name, 'SPLIT_DELIVERY_DETAILS BEING CALLED WITH ' || TO_CHAR ( L_SPLIT_QUANTITY ) );
4401: END IF;
4402: --
4403: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4404: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4405: p_req_quantity => l_split_quantity,
4406: x_new_detail_id => l_dummy_detail_id,
4407: x_return_status => l_return_status,

Line 4954: WSH_DEBUG_SV.log(l_module_name, 'WSH_DELIVERY_DETAILS_ACTIONS.CONSOLIDATE_SOURCE_LINE being called with Del Det Id: ',p_Changed_attributes(l_counter).delivery_detail_id);

4950: --
4951: -- Debug Statements
4952: --
4953: IF l_debug_on THEN
4954: WSH_DEBUG_SV.log(l_module_name, 'WSH_DELIVERY_DETAILS_ACTIONS.CONSOLIDATE_SOURCE_LINE being called with Del Det Id: ',p_Changed_attributes(l_counter).delivery_detail_id);
4955: END IF;
4956: --
4957: l_Cons_Source_Line_Rec_Tab(1).delivery_detail_id:= old_Delivery_detail_rec.delivery_detail_id ;
4958: l_Cons_Source_Line_Rec_Tab(1).delivery_id:= null;

Line 4967: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

4963: l_Cons_Source_Line_Rec_Tab(1).req_qty2:= old_Delivery_detail_rec.requested_quantity2 ;
4964: l_Cons_Source_Line_Rec_Tab(1).bo_qty2:= l_split_quantity2;
4965: -- end of 3121616
4966:
4967: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
4968: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
4969: x_consolidate_ids => l_cons_dd_ids,
4970: x_return_status => l_return_status);
4971:

Line 5001: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4997: IF l_debug_on THEN
4998: WSH_DEBUG_SV.logmsg(l_module_name, 'SPLIT_DELIVERY_DETAILS BEING CALLED WITH ' || TO_CHAR ( L_SPLIT_QUANTITY ) );
4999: END IF;
5000: --
5001: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
5002: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
5003: p_req_quantity => l_split_quantity,
5004: x_new_detail_id => l_dummy_detail_id,
5005: x_return_status => l_return_status,

Line 5033: WSH_DEBUG_SV.log(l_module_name, 'WSH_DELIVERY_DETAILS_ACTIONS.CONSOLIDATE_SOURCE_LINE being called with Del Det Id: ',old_Delivery_detail_rec.delivery_detail_id);

5029: -- If it is complete back order case then try to consolidate it
5030: IF ( l_auto_consolidate = 'Y' AND l_dummy_detail_id = p_Changed_attributes(l_counter).delivery_detail_id) THEN
5031: --{
5032: IF l_debug_on THEN
5033: WSH_DEBUG_SV.log(l_module_name, 'WSH_DELIVERY_DETAILS_ACTIONS.CONSOLIDATE_SOURCE_LINE being called with Del Det Id: ',old_Delivery_detail_rec.delivery_detail_id);
5034: END IF;
5035: l_Cons_Source_Line_Rec_Tab(1).delivery_detail_id:= old_Delivery_detail_rec.delivery_detail_id ;
5036: l_Cons_Source_Line_Rec_Tab(1).delivery_id:= null;
5037: l_Cons_Source_Line_Rec_Tab(1).source_line_id:= old_Delivery_detail_rec.source_line_id;

Line 5045: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

5041: l_Cons_Source_Line_Rec_Tab(1).req_qty2:= old_Delivery_detail_rec.requested_quantity2 ;
5042: l_Cons_Source_Line_Rec_Tab(1).bo_qty2:= old_Delivery_detail_rec.requested_quantity2;
5043: -- end of 3121616
5044:
5045: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
5046: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
5047: x_consolidate_ids => l_cons_dd_ids,
5048: x_return_status => l_return_status);
5049:

Line 5377: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (

5373: WSH_WMS_LPN_GRP.g_caller := 'WMS';
5374: WSH_WMS_LPN_GRP.g_callback_required := 'N';
5375: -- LPN CONV rv
5376: --
5377: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (
5378: p_changed_attributes(l_Counter).delivery_detail_id,
5379: l_cont_instance_id,
5380: l_return_status);
5381: IF l_debug_on THEN

Line 6028: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

6024: WSH_DEBUG_SV.log(l_module_name,'Back Order Qty2:',l_Cons_Source_Line_Rec_Tab(1).bo_qty2);
6025:
6026: END IF;
6027: --
6028: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
6029: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
6030: x_consolidate_ids => l_cons_dd_ids,
6031: x_return_status => l_return_status);
6032:

Line 6057: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

6053:
6054: -- IF no consolidation then Split the line
6055: IF ( l_cons_flag = 'N' ) THEN
6056:
6057: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
6058: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
6059: p_req_quantity => l_split_quantity,
6060: x_new_detail_id => l_dummy_detail_id,
6061: x_return_status => l_return_status,