DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_DETAILS_ACTIONS

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

1984: -- create assignment with l_del_detail_id and p_container_instance_id;
1985:
1986: --
1987: IF l_debug_on THEN
1988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1989: END IF;
1990: --
1991: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (
1992: l_del_detail_id,

Line 1991: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (

1987: IF l_debug_on THEN
1988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
1989: END IF;
1990: --
1991: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_To_Cont (
1992: l_del_detail_id,
1993: p_container_instance_id,
1994: x_return_status);
1995:

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

2369:
2370: END IF;
2371: --
2372: IF l_debug_on THEN
2373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2374: END IF;
2375: --
2376: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details (
2377: l_del_detail_rec,

Line 2376: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details (

2372: IF l_debug_on THEN
2373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2374: END IF;
2375: --
2376: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details (
2377: l_del_detail_rec,
2378: p_del_unassign,
2379: p_cont_unassign,
2380: x_return_status,

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

3432: END IF;
3433: --
3434: --
3435: IF l_debug_on THEN
3436: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3437: END IF;
3438: --
3439: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_to_Delivery(
3440: P_DETAIL_ID =>p_container_instance_id ,

Line 3439: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_to_Delivery(

3435: IF l_debug_on THEN
3436: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY',WSH_DEBUG_SV.C_PROC_LEVEL);
3437: END IF;
3438: --
3439: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_to_Delivery(
3440: P_DETAIL_ID =>p_container_instance_id ,
3441: P_DELIVERY_ID => p_delivery_id,
3442: X_RETURN_STATUS =>x_return_status,
3443: x_dlvy_has_lines => x_dlvy_has_lines,

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

3965: --dbms_output.put_line('creating assignment of cont ' || p_det_cont_inst_id || ' to container ' || p_par_cont_inst_id);
3966: -- just create assignment of child container to parent.
3967: --
3968: IF l_debug_on THEN
3969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
3970: END IF;
3971: --
3972: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
3973: p_det_cont_inst_id,

Line 3972: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (

3968: IF l_debug_on THEN
3969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
3970: END IF;
3971: --
3972: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
3973: p_det_cont_inst_id,
3974: p_par_cont_inst_id,
3975: x_return_status);
3976:

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

4030:
4031: -- just create assignment of child container to parent.
4032: --
4033: IF l_debug_on THEN
4034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4035: END IF;
4036: --
4037: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4038: p_det_cont_inst_id,

Line 4037: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (

4033: IF l_debug_on THEN
4034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4035: END IF;
4036: --
4037: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4038: p_det_cont_inst_id,
4039: p_par_cont_inst_id,
4040: x_return_status);
4041:

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

4119:
4120: -- just create assignment of child container to parent.
4121: --
4122: IF l_debug_on THEN
4123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4124: END IF;
4125: --
4126: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4127: p_det_cont_inst_id,

Line 4126: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (

4122: IF l_debug_on THEN
4123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4124: END IF;
4125: --
4126: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4127: p_det_cont_inst_id,
4128: p_par_cont_inst_id,
4129: x_return_status);
4130:

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

4249:
4250: -- create assignment between child and parent container
4251: --
4252: IF l_debug_on THEN
4253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4254: END IF;
4255: --
4256: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4257: p_det_cont_inst_id,

Line 4256: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (

4252: IF l_debug_on THEN
4253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_CONT_TO_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
4254: END IF;
4255: --
4256: WSH_DELIVERY_DETAILS_ACTIONS.Assign_Cont_To_Cont (
4257: p_det_cont_inst_id,
4258: p_par_cont_inst_id,
4259: x_return_status);
4260:

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

5022:
5023: --dbms_output.put_line('Splitting dd '||p_line_cont_rec.delivery_detail_id||' with qty '||l_tmp_split_qty);
5024: --
5025: IF l_debug_on THEN
5026: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
5027: WSH_DEBUG_SV.logmsg(l_module_name,'SPLIT QTY IS'||l_tmp_split_qty);
5028: END IF;
5029: --
5030:

Line 5036: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details_bulk (

5032: -- empty container logic, need to test and modify this
5033: -- the value for p_num_of_split is passed as 1
5034: -- so that split occurs once
5035:
5036: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details_bulk (
5037: p_from_detail_id => p_line_cont_rec.delivery_detail_id,
5038: p_req_quantity => l_tmp_split_qty,
5039: p_req_quantity2 => l_tmp_split_qty2,
5040: p_manual_split => 'C',

Line 5054: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '|| l_return_status);

5050: --dbms_output.put_line('STATUS after SPLITDD in empty'||l_return_status||l_dd_id_tab.count);
5051:
5052: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5053: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5054: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '|| l_return_status);
5055: x_return_status := C_ERROR_STATUS;
5056: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '||x_return_status);
5057: FND_MESSAGE.SET_NAME('WSH','WSH_DET_SPLIT_ERROR');
5058: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_line_cont_rec.delivery_detail_id);

Line 5056: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '||x_return_status);

5052: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5053: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5054: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '|| l_return_status);
5055: x_return_status := C_ERROR_STATUS;
5056: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '||x_return_status);
5057: FND_MESSAGE.SET_NAME('WSH','WSH_DET_SPLIT_ERROR');
5058: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_line_cont_rec.delivery_detail_id);
5059: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
5060: --

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

5271: -- End BugFix#3475352
5272:
5273: --dbms_output.put_line('Splitting dd '||p_line_cont_rec.delivery_detail_id||' with qty '||l_split_qty);
5274: IF l_debug_on THEN
5275: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
5276: WSH_DEBUG_SV.logmsg(l_module_name,'Split Qty is'||l_split_qty);
5277: WSH_DEBUG_SV.logmsg(l_module_name,'Number of split is'||l_num_of_split);
5278: END IF;
5279:

Line 5285: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details_bulk (

5281: -- Call BULK Split API
5282:
5283: --dbms_output.put_line('======BEFORE SPLIT'||l_dd_id_tab.count||'<'||l_num_of_split);
5284:
5285: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details_bulk (
5286: p_from_detail_id => p_line_cont_rec.delivery_detail_id,
5287: p_req_quantity => l_split_qty,
5288: p_req_quantity2 => l_split_qty2,
5289: p_manual_split => 'C',

Line 5302: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '|| l_return_status);

5298: END IF;
5299:
5300: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5301: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5302: --dbms_output.put_line('WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details returned '|| l_return_status);
5303: x_return_status := C_ERROR_STATUS;
5304: FND_MESSAGE.SET_NAME('WSH','WSH_DET_SPLIT_ERROR');
5305: FND_MESSAGE.SET_TOKEN('DETAIL_ID',p_line_cont_rec.delivery_detail_id);
5306: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

Line 7201: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(

7197: l_mdc_id_tab(l_mdc_index_j) := l_ddlist(l_mdc_index_i);
7198: l_mdc_index_i := l_ddlist.next(l_mdc_index_i);
7199:
7200: END LOOP;
7201: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
7202: p_detail_id_tab => l_mdc_id_tab,
7203: x_return_status => x_return_status);
7204:
7205: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 7598: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(

7594: l_mdc_index_i := l_contlist1.next(l_mdc_index_i);
7595:
7596: END LOOP;
7597:
7598: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(
7599: p_detail_id_tab => l_mdc_id_tab,
7600: x_return_status => x_return_status);
7601:
7602: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

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

9032: WSH_DEBUG_SV.log(l_module_name,'l_split_qty',l_split_qty);
9033: WSH_DEBUG_SV.log(l_module_name,'l_split_qty2',l_split_qty2);
9034: WSH_DEBUG_SV.log(l_module_name,'l_det_pack_qty2',l_det_pack_qty2);
9035: WSH_DEBUG_SV.log(l_module_name,'l_det_pack_qty',l_det_pack_qty);
9036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
9037: END IF;
9038: --
9039:
9040: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

Line 9040: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

9036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
9037: END IF;
9038: --
9039:
9040: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (
9041: p_from_detail_id => l_det_tab(j).delivery_detail_id,
9042: p_req_quantity => l_split_qty,
9043: p_req_quantity2 => l_split_qty2,
9044: x_new_detail_id => l_split_det_id,

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

9351: WSH_DEBUG_SV.log(l_module_name,'l_split_qty',l_split_qty);
9352: WSH_DEBUG_SV.log(l_module_name,'l_split_qty2',l_split_qty2);
9353: WSH_DEBUG_SV.log(l_module_name,'l_det_pack_qty2',l_det_pack_qty2);
9354: WSH_DEBUG_SV.log(l_module_name,'l_det_pack_qty',l_det_pack_qty);
9355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
9356: END IF;
9357:
9358: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (
9359: p_from_detail_id => l_det_tab(j).delivery_detail_id,

Line 9358: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (

9354: WSH_DEBUG_SV.log(l_module_name,'l_det_pack_qty',l_det_pack_qty);
9355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
9356: END IF;
9357:
9358: WSH_DELIVERY_DETAILS_ACTIONS.Split_Delivery_Details (
9359: p_from_detail_id => l_det_tab(j).delivery_detail_id,
9360: p_req_quantity => l_split_qty,
9361: p_req_quantity2 => l_split_qty2,
9362: x_new_detail_id => l_split_det_id,