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_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_DETAILS_PKG

Line 431: IF l_line_rec.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN

427: END IF;
428: --2587777
429:
430: --X-dock
431: IF l_line_rec.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN
432: WSH_USA_INV_PVT.get_putaway_detail_id
433: (p_detail_id => p_delivery_detail_id,
434: p_released_status => l_line_rec.released_status,
435: p_move_order_line_id => l_line_rec.move_order_line_id,

Line 3985: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

3981: del_not_updatable exception;
3982: grouping_attributes_not_match exception;
3983: arrival_SET_failed exception;
3984: ship_method_not_match exception;
3985: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
3986: l_mdc_detail_tab wsh_util_core.id_tab_type;
3987: DETAIL_DEL_FROM_to_not_SAME exception;
3988: det_confirmed exception;
3989: update_mol_carton_group_error exception;

Line 4812: IF (l_detail.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN

4808: --
4809: -- J-IB-NPARIKH-}
4810:
4811:
4812: IF (l_detail.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN
4813: --{
4814: IF (wsh_util_validate.Check_Wms_Org(l_detail.organization_id)='Y') AND
4815: (l_detail.move_order_line_id IS NOT NULL AND
4816: (WSH_USA_INV_PVT.is_mo_type_putaway

Line 8358: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

8354: IS
8355: l_rowid varchar2(150);
8356: l_group_status varchar2(30);
8357: l_ship_method_match boolean;
8358: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
8359: l_cr_assg_status varchar2(30);
8360: l_delivery_assignment_id NUMBER;
8361: del_id number;
8362: cont_id number;

Line 8701: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

8697: mark reprice required flag when split_delivery_details
8698: */
8699: l_entity_ids WSH_UTIL_CORE.id_tab_type;
8700: reprice_required_err EXCEPTION;
8701: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
8702: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8703: l_split_weight number;
8704: l_split_volume number;
8705: l_split_return_status varchar2(30);

Line 9104: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

9100: l_output_quantity number;
9101: l_qty_return_status varchar2(30);
9102: new_det_wt_vol_failed exception;
9103: old_det_wt_vol_failed exception;
9104: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9105: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9106: l_split_weight number;
9107: l_split_volume number;
9108: l_split_return_status varchar2(30);

Line 9306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9302:
9303: --
9304: /*
9305: IF l_debug_on THEN
9306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9307: END IF;
9308: --
9309: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
9310: p_delivery_detail_rec => l_delivery_details_info);

Line 9309: WSH_DELIVERY_DETAILS_PKG.initialize_detail(

9305: IF l_debug_on THEN
9306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9307: END IF;
9308: --
9309: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
9310: p_delivery_detail_rec => l_delivery_details_info);
9311: */
9312:
9313: IF p_old_delivery_detail_rec.picked_quantity IS NULL THEN

Line 9433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DD_FROM_OLD_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

9429: l_num_of_split := p_num_of_split;
9430:
9431: --
9432: IF l_debug_on THEN
9433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DD_FROM_OLD_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
9434: END IF;
9435: --
9436: -- call to new API
9437: -- with a value for p_num_of_rec

Line 9438: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk(

9434: END IF;
9435: --
9436: -- call to new API
9437: -- with a value for p_num_of_rec
9438: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk(
9439: p_delivery_detail_rec => l_delivery_details_info,
9440: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
9441: p_num_of_rec => l_num_of_split,
9442: x_dd_id_tab => l_dd_id_tab,

Line 9642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

9638:
9639: l_delivery_assignments_info.delivery_detail_id := l_new_delivery_detail_id;
9640: --
9641: IF l_debug_on THEN
9642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
9643: END IF;
9644: --
9645:
9646: -- this is a bulk call

Line 9649: wsh_delivery_details_pkg.create_deliv_assignment_bulk(

9645:
9646: -- this is a bulk call
9647: -- with new parameter of p_num_of_rec
9648: -- and pass l_dd_id_tab which will pass the delivery detail id
9649: wsh_delivery_details_pkg.create_deliv_assignment_bulk(
9650: p_delivery_assignments_info => l_delivery_assignments_info,
9651: p_num_of_rec => l_num_of_split,
9652: p_dd_id_tab => l_dd_id_tab,
9653: x_da_id_tab => l_da_id_tab,

Line 9665: wsh_delivery_details_pkg.create_deliv_assignment_bulk(

9661: l_delivery_assignments_info.type := 'C';
9662: l_delivery_assignments_info.parent_delivery_id := p_old_delivery_detail_rec.parent_delivery_id;
9663: l_delivery_assignments_info.parent_delivery_detail_id := p_old_delivery_detail_rec.parent_delivery_detail_id;
9664:
9665: wsh_delivery_details_pkg.create_deliv_assignment_bulk(
9666: p_delivery_assignments_info => l_delivery_assignments_info,
9667: p_num_of_rec => l_num_of_split,
9668: p_dd_id_tab => l_dd_id_tab,
9669: x_da_id_tab => l_da_id_tab,

Line 9988: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

9984: mark reprice required flag when split_delivery_details
9985: */
9986: l_entity_ids WSH_UTIL_CORE.id_tab_type;
9987: reprice_required_err EXCEPTION;
9988: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9989: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9990: l_split_weight number;
9991: l_split_volume number;
9992: l_split_return_status varchar2(30);

Line 10320: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

10316: l_output_quantity number;
10317: l_qty_return_status varchar2(30);
10318: new_det_wt_vol_failed exception;
10319: old_det_wt_vol_failed exception;
10320: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10321: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10322: l_split_weight number;
10323: l_split_volume number;
10324: l_split_return_status varchar2(30);

Line 10491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

10487:
10488: --
10489: /*
10490: IF l_debug_on THEN
10491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
10492: END IF;
10493: --
10494: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
10495: p_delivery_detail_rec => l_delivery_details_info);

Line 10494: WSH_DELIVERY_DETAILS_PKG.initialize_detail(

10490: IF l_debug_on THEN
10491: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
10492: END IF;
10493: --
10494: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
10495: p_delivery_detail_rec => l_delivery_details_info);
10496: */
10497:
10498: IF p_old_delivery_detail_rec.picked_quantity IS NULL THEN

Line 10782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);

10778: END IF; -- are there serial numbers to split?
10779:
10780: --
10781: IF l_debug_on THEN
10782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);
10783: END IF;
10784: --
10785: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
10786: p_delivery_detail_rec => l_delivery_details_info,

Line 10785: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(

10781: IF l_debug_on THEN
10782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_NEW_DETAIL_FROM_OLD',WSH_DEBUG_SV.C_PROC_LEVEL);
10783: END IF;
10784: --
10785: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
10786: p_delivery_detail_rec => l_delivery_details_info,
10787: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
10788: x_row_id => detail_rowid,
10789: x_delivery_detail_id => l_new_delivery_detail_id,

Line 10849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);

10845:
10846: l_delivery_assignments_info.delivery_detail_id := l_new_delivery_detail_id;
10847: --
10848: IF l_debug_on THEN
10849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
10850: END IF;
10851: --
10852: wsh_delivery_details_pkg.create_delivery_assignments(
10853: l_delivery_assignments_info,

Line 10852: wsh_delivery_details_pkg.create_delivery_assignments(

10848: IF l_debug_on THEN
10849: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
10850: END IF;
10851: --
10852: wsh_delivery_details_pkg.create_delivery_assignments(
10853: l_delivery_assignments_info,
10854: assignment_rowid,
10855: l_delivery_assignment_id,
10856: l_cr_assg_status

Line 10877: wsh_delivery_details_pkg.create_delivery_assignments(

10873: l_delivery_assignments_info.parent_delivery_id := p_old_delivery_detail_rec.parent_delivery_id;
10874: l_delivery_assignments_info.parent_delivery_detail_id := p_old_delivery_detail_rec.parent_delivery_detail_id;
10875: l_delivery_assignments_info.type := 'C';
10876:
10877: wsh_delivery_details_pkg.create_delivery_assignments(
10878: l_delivery_assignments_info,
10879: assignment_rowid,
10880: l_delivery_assignment_id,
10881: l_cr_assg_status

Line 12375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

12371: --
12372: -- Debug Statements
12373: --
12374: IF l_debug_on THEN
12375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
12376: END IF;
12377: --
12378: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
12379: p_delivery_detail_id => l_delete_dd_ids(i),

Line 12378: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

12374: IF l_debug_on THEN
12375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
12376: END IF;
12377: --
12378: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
12379: p_delivery_detail_id => l_delete_dd_ids(i),
12380: x_return_status => l_return_status );
12381:
12382: --

Line 12786: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);

12782: --
12783: -- Debug Statements
12784: --
12785: IF l_debug_on THEN
12786: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
12787: END IF;
12788: --
12789:
12790: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

Line 12790: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

12786: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
12787: END IF;
12788: --
12789:
12790: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
12791: p_delivery_detail_id => p_delivery_detail_id,
12792: p_cancel_flag => 'N',
12793: x_return_status => l_return_status);
12794: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

Line 12808: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Process_Delivery_Details',l_module_name);

12804:
12805: EXCEPTION
12806: WHEN others THEN
12807: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12808: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Process_Delivery_Details',l_module_name);
12809: --
12810: IF l_debug_on THEN
12811: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
12812: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');