eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 3901: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines

3897:
3898: -- Added the record to call the WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
3899: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3900:
3901: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines
3902: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3903: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;
3904:
3905: -- To store the shipping global parameter "Consolidate BO lines" value

Line 3902: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;

3898: -- Added the record to call the WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters
3899: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3900:
3901: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines
3902: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3903: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;
3904:
3905: -- To store the shipping global parameter "Consolidate BO lines" value
3906: l_auto_consolidate VARCHAR2(1) := 'N';

Line 4427: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4423: END IF;
4424: --
4425: l_changed_attributes(l_counter).action_flag := 'U';
4426: ELSE
4427: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4428: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4429: p_req_quantity => l_split_quantity,
4430: x_new_detail_id => l_dummy_detail_id,
4431: x_return_status => l_return_status,

Line 4494: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4490: WHERE delivery_detail_id = old_delivery_detail_rec.delivery_detail_id;
4491:
4492: IF l_split_quantity < old_delivery_detail_rec.picked_quantity THEN
4493:
4494: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4495: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4496: p_req_quantity => l_split_quantity,
4497: x_new_detail_id => l_dummy_detail_id,
4498: x_return_status => l_return_status,

Line 4558: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4554: --
4555: l_changed_attributes(l_counter).action_flag := 'U';
4556: ELSE
4557:
4558: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4559: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4560: p_req_quantity => l_split_quantity,
4561: x_new_detail_id => l_dummy_detail_id,
4562: x_return_status => l_return_status,

Line 4622: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4618:
4619:
4620: IF l_split_quantity2 < old_delivery_detail_rec.picked_quantity2 THEN
4621:
4622: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4623: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4624: p_req_quantity => l_split_quantity,
4625: x_new_detail_id => l_dummy_detail_id,
4626: x_return_status => l_return_status,

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

4724: --
4725: -- Debug Statements
4726: --
4727: IF l_debug_on THEN
4728: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4729: END IF;
4730: --
4731: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4732: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,

Line 4731: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4727: IF l_debug_on THEN
4728: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4729: END IF;
4730: --
4731: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4732: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4733: p_req_quantity => l_split_quantity,
4734: x_new_detail_id => l_dummy_detail_id,
4735: x_return_status => l_return_status,

Line 4937: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

4933: IF l_debug_on THEN
4934: WSH_DEBUG_SV.logmsg(l_module_name, 'SPLIT_DELIVERY_DETAILS BEING CALLED WITH ' || TO_CHAR ( L_SPLIT_QUANTITY ) );
4935: END IF;
4936: --
4937: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
4938: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
4939: p_req_quantity => l_split_quantity,
4940: x_new_detail_id => l_dummy_detail_id,
4941: x_return_status => l_return_status,

Line 5512: 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);

5508: --
5509: -- Debug Statements
5510: --
5511: IF l_debug_on THEN
5512: 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);
5513: END IF;
5514: --
5515: l_Cons_Source_Line_Rec_Tab(1).delivery_detail_id:= old_Delivery_detail_rec.delivery_detail_id ;
5516: l_Cons_Source_Line_Rec_Tab(1).delivery_id:= null;

Line 5526: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

5522: -- muom
5523: l_Cons_Source_Line_Rec_Tab(1).fulfillment_base := l_fulfillment_base;
5524: -- end of 3121616
5525:
5526: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
5527: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
5528: x_consolidate_ids => l_cons_dd_ids,
5529: x_return_status => l_return_status);
5530:

Line 5561: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

5557: -- muom
5558: WSH_DEBUG_SV.logmsg(l_module_name, 'SPLIT_DELIVERY_DETAILS BEING CALLED WITH ' || TO_CHAR ( L_SPLIT_QUANTITY )||' and '||TO_CHAR ( L_SPLIT_QUANTITY2 ) );
5559: END IF;
5560: --
5561: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
5562: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
5563: p_req_quantity => l_split_quantity,
5564: x_new_detail_id => l_dummy_detail_id,
5565: x_return_status => l_return_status,

Line 5594: 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);

5590: -- If it is complete back order case then try to consolidate it
5591: IF ( l_auto_consolidate = 'Y' AND l_dummy_detail_id = p_Changed_attributes(l_counter).delivery_detail_id) THEN
5592: --{
5593: IF l_debug_on THEN
5594: 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);
5595: END IF;
5596: l_Cons_Source_Line_Rec_Tab(1).delivery_detail_id:= old_Delivery_detail_rec.delivery_detail_id ;
5597: l_Cons_Source_Line_Rec_Tab(1).delivery_id:= null;
5598: l_Cons_Source_Line_Rec_Tab(1).source_line_id:= old_Delivery_detail_rec.source_line_id;

Line 5606: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

5602: l_Cons_Source_Line_Rec_Tab(1).bo_qty2:= old_Delivery_detail_rec.requested_quantity2;
5603: -- muom
5604: l_Cons_Source_Line_Rec_Tab(1).fulfillment_base := l_fulfillment_base;
5605:
5606: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
5607: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
5608: x_consolidate_ids => l_cons_dd_ids,
5609: x_return_status => l_return_status);
5610:

Line 5950: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (

5946: WSH_WMS_LPN_GRP.g_caller := 'WMS';
5947: WSH_WMS_LPN_GRP.g_callback_required := 'N';
5948: -- LPN CONV rv
5949: --
5950: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (
5951: p_changed_attributes(l_Counter).delivery_detail_id,
5952: l_cont_instance_id,
5953: l_return_status);
5954: IF l_debug_on THEN

Line 6653: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(

6649: WSH_DEBUG_SV.log(l_module_name,'Back Order Qty2:',l_Cons_Source_Line_Rec_Tab(1).bo_qty2);
6650:
6651: END IF;
6652: --
6653: WSH_DELIVERY_DETAILS_ACTIONS.Consolidate_Source_Line(
6654: p_Cons_Source_Line_Rec_Tab => l_Cons_Source_Line_Rec_Tab,
6655: x_consolidate_ids => l_cons_dd_ids,
6656: x_return_status => l_return_status);
6657:

Line 6688: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(

6684: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty.', l_split_quantity);
6685: WSH_DEBUG_SV.log(l_module_name, 'Req. Qty2.', l_split_quantity2);
6686: END IF;
6687:
6688: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details(
6689: p_from_detail_id => p_Changed_attributes(l_counter).delivery_detail_id,
6690: p_req_quantity => l_split_quantity,
6691: x_new_detail_id => l_dummy_detail_id,
6692: x_return_status => l_return_status,