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 465: IF l_line_rec.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN

461: END IF;
462: --2587777
463:
464: --X-dock
465: IF l_line_rec.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE THEN
466: WSH_USA_INV_PVT.get_putaway_detail_id
467: (p_detail_id => p_delivery_detail_id,
468: p_released_status => l_line_rec.released_status,
469: p_move_order_line_id => l_line_rec.move_order_line_id,

Line 4130: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

4126: del_not_updatable exception;
4127: grouping_attributes_not_match exception;
4128: arrival_SET_failed exception;
4129: ship_method_not_match exception;
4130: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4131: l_mdc_detail_tab wsh_util_core.id_tab_type;
4132: DETAIL_DEL_FROM_to_not_SAME exception;
4133: det_confirmed exception;
4134: update_mol_carton_group_error exception;

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

4961: --
4962: -- J-IB-NPARIKH-}
4963:
4964:
4965: IF (l_detail.released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE) THEN
4966: --{
4967: IF (wsh_util_validate.Check_Wms_Org(l_detail.organization_id)='Y') AND
4968: (l_detail.move_order_line_id IS NOT NULL AND
4969: (WSH_USA_INV_PVT.is_mo_type_putaway

Line 8522: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;

8518: IS
8519: l_rowid varchar2(150);
8520: l_group_status varchar2(30);
8521: l_ship_method_match boolean;
8522: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_TYPE;
8523: l_cr_assg_status varchar2(30);
8524: l_delivery_assignment_id NUMBER;
8525: del_id number;
8526: cont_id number;

Line 8865: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

8861: mark reprice required flag when split_delivery_details
8862: */
8863: l_entity_ids WSH_UTIL_CORE.id_tab_type;
8864: reprice_required_err EXCEPTION;
8865: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
8866: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
8867: l_split_weight number;
8868: l_split_volume number;
8869: l_split_return_status varchar2(30);

Line 9268: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

9264: l_output_quantity number;
9265: l_qty_return_status varchar2(30);
9266: new_det_wt_vol_failed exception;
9267: old_det_wt_vol_failed exception;
9268: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
9269: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9270: l_split_weight number;
9271: l_split_volume number;
9272: l_split_return_status varchar2(30);

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

9474:
9475: --
9476: /*
9477: IF l_debug_on THEN
9478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9479: END IF;
9480: --
9481: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
9482: p_delivery_detail_rec => l_delivery_details_info);

Line 9481: WSH_DELIVERY_DETAILS_PKG.initialize_detail(

9477: IF l_debug_on THEN
9478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.INITIALIZE_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9479: END IF;
9480: --
9481: WSH_DELIVERY_DETAILS_PKG.initialize_detail(
9482: p_delivery_detail_rec => l_delivery_details_info);
9483: END IF;
9484: */
9485: IF p_old_delivery_detail_rec.picked_quantity IS NULL THEN

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

9609: l_num_of_split := p_num_of_split;
9610:
9611: --
9612: IF l_debug_on THEN
9613: 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);
9614: END IF;
9615: --
9616: -- call to new API
9617: -- with a value for p_num_of_rec

Line 9618: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk(

9614: END IF;
9615: --
9616: -- call to new API
9617: -- with a value for p_num_of_rec
9618: WSH_DELIVERY_DETAILS_PKG.create_dd_from_old_bulk(
9619: p_delivery_detail_rec => l_delivery_details_info,
9620: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
9621: p_num_of_rec => l_num_of_split,
9622: x_dd_id_tab => l_dd_id_tab,

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

9818:
9819: l_delivery_assignments_info.delivery_detail_id := l_new_delivery_detail_id;
9820: --
9821: IF l_debug_on THEN
9822: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIV_ASSIGNMENT_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
9823: END IF;
9824: --
9825:
9826: -- this is a bulk call

Line 9829: wsh_delivery_details_pkg.create_deliv_assignment_bulk(

9825:
9826: -- this is a bulk call
9827: -- with new parameter of p_num_of_rec
9828: -- and pass l_dd_id_tab which will pass the delivery detail id
9829: wsh_delivery_details_pkg.create_deliv_assignment_bulk(
9830: p_delivery_assignments_info => l_delivery_assignments_info,
9831: p_num_of_rec => l_num_of_split,
9832: p_dd_id_tab => l_dd_id_tab,
9833: x_da_id_tab => l_da_id_tab,

Line 9845: wsh_delivery_details_pkg.create_deliv_assignment_bulk(

9841: l_delivery_assignments_info.type := 'C';
9842: l_delivery_assignments_info.parent_delivery_id := p_old_delivery_detail_rec.parent_delivery_id;
9843: l_delivery_assignments_info.parent_delivery_detail_id := p_old_delivery_detail_rec.parent_delivery_detail_id;
9844:
9845: wsh_delivery_details_pkg.create_deliv_assignment_bulk(
9846: p_delivery_assignments_info => l_delivery_assignments_info,
9847: p_num_of_rec => l_num_of_split,
9848: p_dd_id_tab => l_dd_id_tab,
9849: x_da_id_tab => l_da_id_tab,

Line 10170: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

10166: mark reprice required flag when split_delivery_details
10167: */
10168: l_entity_ids WSH_UTIL_CORE.id_tab_type;
10169: reprice_required_err EXCEPTION;
10170: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10171: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10172: l_split_weight number;
10173: l_split_volume number;
10174: l_split_return_status varchar2(30);

Line 10593: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;

10589: l_output_quantity number;
10590: l_qty_return_status varchar2(30);
10591: new_det_wt_vol_failed exception;
10592: old_det_wt_vol_failed exception;
10593: l_delivery_assignments_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
10594: l_delivery_details_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
10595: l_split_weight number;
10596: l_split_volume number;
10597: l_split_return_status varchar2(30);

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

11162: END IF; -- are there serial numbers to split?
11163:
11164: --
11165: IF l_debug_on THEN
11166: 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);
11167: END IF;
11168: --
11169: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
11170: p_delivery_detail_rec => l_delivery_details_info,

Line 11169: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(

11165: IF l_debug_on THEN
11166: 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);
11167: END IF;
11168: --
11169: WSH_DELIVERY_DETAILS_PKG.create_new_detail_from_old(
11170: p_delivery_detail_rec => l_delivery_details_info,
11171: p_delivery_detail_id => p_old_delivery_detail_rec.delivery_detail_id,
11172: x_row_id => detail_rowid,
11173: x_delivery_detail_id => l_new_delivery_detail_id,

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

11242:
11243: l_delivery_assignments_info.delivery_detail_id := l_new_delivery_detail_id;
11244: --
11245: IF l_debug_on THEN
11246: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
11247: END IF;
11248: --
11249: wsh_delivery_details_pkg.create_delivery_assignments(
11250: l_delivery_assignments_info,

Line 11249: wsh_delivery_details_pkg.create_delivery_assignments(

11245: IF l_debug_on THEN
11246: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.CREATE_DELIVERY_ASSIGNMENTS',WSH_DEBUG_SV.C_PROC_LEVEL);
11247: END IF;
11248: --
11249: wsh_delivery_details_pkg.create_delivery_assignments(
11250: l_delivery_assignments_info,
11251: assignment_rowid,
11252: l_delivery_assignment_id,
11253: l_cr_assg_status

Line 11274: wsh_delivery_details_pkg.create_delivery_assignments(

11270: l_delivery_assignments_info.parent_delivery_id := p_old_delivery_detail_rec.parent_delivery_id;
11271: l_delivery_assignments_info.parent_delivery_detail_id := p_old_delivery_detail_rec.parent_delivery_detail_id;
11272: l_delivery_assignments_info.type := 'C';
11273:
11274: wsh_delivery_details_pkg.create_delivery_assignments(
11275: l_delivery_assignments_info,
11276: assignment_rowid,
11277: l_delivery_assignment_id,
11278: l_cr_assg_status

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

12847: --
12848: -- Debug Statements
12849: --
12850: IF l_debug_on THEN
12851: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
12852: END IF;
12853: --
12854: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
12855: p_delivery_detail_id => l_delete_dd_ids(i),

Line 12854: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

12850: IF l_debug_on THEN
12851: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.DELETE_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
12852: END IF;
12853: --
12854: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
12855: p_delivery_detail_id => l_delete_dd_ids(i),
12856: x_return_status => l_return_status );
12857:
12858: --

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

13406: --
13407: -- Debug Statements
13408: --
13409: IF l_debug_on THEN
13410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
13411: END IF;
13412: --
13413:
13414: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

Line 13414: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(

13410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details',WSH_DEBUG_SV.C_PROC_LEVEL);
13411: END IF;
13412: --
13413:
13414: WSH_DELIVERY_DETAILS_PKG.Delete_Delivery_Details(
13415: p_delivery_detail_id => p_delivery_detail_id,
13416: p_cancel_flag => 'N',
13417: x_return_status => l_return_status);
13418: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

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

13447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13448: IF c_detail%ISOPEN THEN
13449: CLOSE c_detail;
13450: END IF;
13451: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.Process_Delivery_Details',l_module_name);
13452: --
13453: IF l_debug_on THEN
13454: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
13455: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');