DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DETAILS_VALIDATIONS

Line 1953: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery

1949: -- doing it every time we assign a split delivery line to a container.
1950: -- Thus, auto-pack lines will always call assign_detail procedure
1951: -- with parameter p_check_credit_holds = FALSE.
1952: -- Auto-pack lines will explicitly call the procedure
1953: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery
1954: -- line
1955: --
1956: IF p_check_credit_holds
1957: THEN

Line 1960: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);

1956: IF p_check_credit_holds
1957: THEN
1958: --
1959: IF l_debug_on THEN
1960: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
1961: END IF;
1962: --
1963: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
1964: l_del_detail_id,

Line 1963: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

1959: IF l_debug_on THEN
1960: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
1961: END IF;
1962: --
1963: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
1964: l_del_detail_id,
1965: 'PACK',
1966: l_src_line_id,
1967: l_src_hdr_id,

Line 5024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

5020:
5021: -- Per Pushkar,OPM: Call Check_Decimal_Quantity for both OPM and Discrete for primary quantity
5022: --
5023: IF l_debug_on THEN
5024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5025: END IF;
5026: --
5027: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5028: p_line_cont_rec.inventory_item_id,

Line 5027: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

5023: IF l_debug_on THEN
5024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5025: END IF;
5026: --
5027: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5028: p_line_cont_rec.inventory_item_id,
5029: p_line_cont_rec.organization_id,
5030: l_tmp_split_qty,
5031: p_line_cont_rec.req_qty_uom,

Line 5041: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);

5037: END IF;
5038: IF (l_return_status <> C_SUCCESS_STATUS OR
5039: p_line_cont_rec.indivisible_flag = 'Y')THEN
5040: -- Fractional qtys not allowed
5041: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
5042: l_discard_message := FND_MESSAGE.GET;
5043: l_tmp_split_qty := FLOOR(l_tmp_split_qty);
5044: END IF;
5045: -- HW OPMCONV - 1) No need to check for process

Line 5268: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

5264:
5265: -- Per Pushkar,OPM: Call Check_Decimal_Quantity for both OPM and Discrete for primary quantity
5266: --
5267: IF l_debug_on THEN
5268: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5269: END IF;
5270: --
5271: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5272: p_line_cont_rec.inventory_item_id,

Line 5271: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

5267: IF l_debug_on THEN
5268: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5269: END IF;
5270: --
5271: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5272: p_line_cont_rec.inventory_item_id,
5273: p_line_cont_rec.organization_id,
5274: l_tmp_split_qty,
5275: p_line_cont_rec.req_qty_uom,

Line 5285: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);

5281: END IF;
5282: IF (l_return_status <> C_SUCCESS_STATUS OR
5283: p_line_cont_rec.indivisible_flag = 'Y')THEN
5284: -- Fractional qtys not allowed
5285: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
5286: l_discard_message := FND_MESSAGE.GET;
5287: l_split_qty := FLOOR(l_tmp_split_qty);
5288: END IF;
5289:

Line 6018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6014: --dbms_output.put_line('l_dd_gross_wt '||l_dd_gross_wt||' l_dd_volume '||l_dd_volume ||' l_mtl_max_load '||l_mtl_max_load||' l_mtl_max_vol '||l_mtl_max_vol || ' l_max_load_qty '||l_max_load_qty);
6015:
6016: --
6017: IF l_debug_on THEN
6018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6019: END IF;
6020: --
6021: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
6022: p_item_id => rec.inventory_item_id,

Line 6021: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

6017: IF l_debug_on THEN
6018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6019: END IF;
6020: --
6021: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
6022: p_item_id => rec.inventory_item_id,
6023: p_organization_id => rec.organization_id,
6024: p_input_quantity => ROUND((rec.packed_quantity/l_max_load_qty),LIMITED_PRECISION),
6025: p_uom_code => rec.requested_quantity_uom,

Line 6033: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);

6029: IF l_debug_on THEN
6030: WSH_DEBUG_SV.log(l_module_name,'return status -',l_return_status);
6031: END IF;
6032: IF l_return_status <> C_SUCCESS_STATUS THEN
6033: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
6034: l_discard_message := FND_MESSAGE.GET;
6035: l_tmp_num_cont := FLOOR(rec.packed_quantity/l_max_load_qty);
6036:
6037: IF (l_tmp_num_cont = 0) THEN

Line 6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);

6245: -- 20.70 Do Credit Check
6246: --dbms_output.put_line('Doing Credit Check');
6247: --
6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
6253: p_detail_id => rec.delivery_detail_id,

Line 6252: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

6248: IF l_debug_on THEN
6249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
6250: END IF;
6251: --
6252: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
6253: p_detail_id => rec.delivery_detail_id,
6254: p_activity_type => 'PACK',
6255: p_source_line_id => NULL,
6256: p_source_header_id => NULL,

Line 8628: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery

8624: -- doing it every time we assign a split delivery line to a container.
8625: -- Thus, auto-pack lines will always call assign_detail procedure
8626: -- with parameter p_check_credit_holds = FALSE.
8627: -- pack_multi lines will explicitly call the procedure (as follows)
8628: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery
8629: -- line . If any of the delivery lines fails this check, API will
8630: -- return with error.
8631: --
8632:

Line 8640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);

8636: l_det_tab(j).pack_status := 'Unpacked';
8637:
8638: --
8639: IF l_debug_on THEN
8640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
8641: END IF;
8642: --
8643: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
8644: l_det_tab(j).delivery_detail_id,

Line 8643: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

8639: IF l_debug_on THEN
8640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
8641: END IF;
8642: --
8643: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
8644: l_det_tab(j).delivery_detail_id,
8645: 'PACK',
8646: NULL,
8647: NULL,

Line 9087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

9083: l_tmp_split_qty := ROUND(((l_det_pack_qty*l_cont_avail_pc)/l_req_cont_num),LIMITED_PRECISION);
9084:
9085: --
9086: IF l_debug_on THEN
9087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9088: END IF;
9089: --
9090: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9091: l_det_inv_item_id,

Line 9090: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

9086: IF l_debug_on THEN
9087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9088: END IF;
9089: --
9090: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9091: l_det_inv_item_id,
9092: l_det_org_id,
9093: l_tmp_split_qty,
9094: l_det_qty_uom,

Line 9363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

9359: l_tmp_split_qty := ROUND((l_split_pc*l_det_pack_qty/100),LIMITED_PRECISION);
9360:
9361: --
9362: IF l_debug_on THEN
9363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9364: END IF;
9365: --
9366: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9367: l_det_inv_item_id,

Line 9366: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

9362: IF l_debug_on THEN
9363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9364: END IF;
9365: --
9366: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9367: l_det_inv_item_id,
9368: l_det_org_id,
9369: l_tmp_split_qty,
9370: l_det_qty_uom,