DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DETAILS_VALIDATIONS

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

1922: -- doing it every time we assign a split delivery line to a container.
1923: -- Thus, auto-pack lines will always call assign_detail procedure
1924: -- with parameter p_check_credit_holds = FALSE.
1925: -- Auto-pack lines will explicitly call the procedure
1926: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery
1927: -- line
1928: --
1929: IF p_check_credit_holds
1930: THEN

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

1929: IF p_check_credit_holds
1930: THEN
1931: --
1932: IF l_debug_on THEN
1933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
1934: END IF;
1935: --
1936: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
1937: l_del_detail_id,

Line 1936: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

1932: IF l_debug_on THEN
1933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
1934: END IF;
1935: --
1936: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
1937: l_del_detail_id,
1938: 'PACK',
1939: l_src_line_id,
1940: l_src_hdr_id,

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

4948:
4949: -- Per Pushkar,OPM: Call Check_Decimal_Quantity for both OPM and Discrete for primary quantity
4950: --
4951: IF l_debug_on THEN
4952: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4953: END IF;
4954: --
4955: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
4956: p_line_cont_rec.inventory_item_id,

Line 4955: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

4951: IF l_debug_on THEN
4952: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
4953: END IF;
4954: --
4955: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
4956: p_line_cont_rec.inventory_item_id,
4957: p_line_cont_rec.organization_id,
4958: l_tmp_split_qty,
4959: p_line_cont_rec.req_qty_uom,

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

4965: END IF;
4966: IF (l_return_status <> C_SUCCESS_STATUS OR
4967: p_line_cont_rec.indivisible_flag = 'Y')THEN
4968: -- Fractional qtys not allowed
4969: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
4970: l_discard_message := FND_MESSAGE.GET;
4971: l_tmp_split_qty := FLOOR(l_tmp_split_qty);
4972: END IF;
4973: -- HW OPMCONV - 1) No need to check for process

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

5192:
5193: -- Per Pushkar,OPM: Call Check_Decimal_Quantity for both OPM and Discrete for primary quantity
5194: --
5195: IF l_debug_on THEN
5196: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5197: END IF;
5198: --
5199: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5200: p_line_cont_rec.inventory_item_id,

Line 5199: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

5195: IF l_debug_on THEN
5196: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5197: END IF;
5198: --
5199: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5200: p_line_cont_rec.inventory_item_id,
5201: p_line_cont_rec.organization_id,
5202: l_tmp_split_qty,
5203: p_line_cont_rec.req_qty_uom,

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

5209: END IF;
5210: IF (l_return_status <> C_SUCCESS_STATUS OR
5211: p_line_cont_rec.indivisible_flag = 'Y')THEN
5212: -- Fractional qtys not allowed
5213: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
5214: l_discard_message := FND_MESSAGE.GET;
5215: l_split_qty := FLOOR(l_tmp_split_qty);
5216: END IF;
5217:

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

5942: --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);
5943:
5944: --
5945: IF l_debug_on THEN
5946: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5947: END IF;
5948: --
5949: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5950: p_item_id => rec.inventory_item_id,

Line 5949: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

5945: IF l_debug_on THEN
5946: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5947: END IF;
5948: --
5949: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
5950: p_item_id => rec.inventory_item_id,
5951: p_organization_id => rec.organization_id,
5952: p_input_quantity => ROUND((rec.packed_quantity/l_max_load_qty),LIMITED_PRECISION),
5953: p_uom_code => rec.requested_quantity_uom,

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

5957: IF l_debug_on THEN
5958: WSH_DEBUG_SV.log(l_module_name,'return status -',l_return_status);
5959: END IF;
5960: IF l_return_status <> C_SUCCESS_STATUS THEN
5961: --dbms_output.put_line('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity returned '||l_return_status);
5962: l_discard_message := FND_MESSAGE.GET;
5963: l_tmp_num_cont := FLOOR(rec.packed_quantity/l_max_load_qty);
5964:
5965: IF (l_tmp_num_cont = 0) THEN

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

6173: -- 20.70 Do Credit Check
6174: --dbms_output.put_line('Doing Credit Check');
6175: --
6176: IF l_debug_on THEN
6177: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
6178: END IF;
6179: --
6180: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
6181: p_detail_id => rec.delivery_detail_id,

Line 6180: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

6176: IF l_debug_on THEN
6177: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
6178: END IF;
6179: --
6180: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
6181: p_detail_id => rec.delivery_detail_id,
6182: p_activity_type => 'PACK',
6183: p_source_line_id => NULL,
6184: p_source_header_id => NULL,

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

8495: -- doing it every time we assign a split delivery line to a container.
8496: -- Thus, auto-pack lines will always call assign_detail procedure
8497: -- with parameter p_check_credit_holds = FALSE.
8498: -- pack_multi lines will explicitly call the procedure (as follows)
8499: -- WSH_DETAILS_VALIDATIONS.Check_Credit_Holds only once for a delivery
8500: -- line . If any of the delivery lines fails this check, API will
8501: -- return with error.
8502: --
8503:

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

8507: l_det_tab(j).pack_status := 'Unpacked';
8508:
8509: --
8510: IF l_debug_on THEN
8511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
8512: END IF;
8513: --
8514: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
8515: l_det_tab(j).delivery_detail_id,

Line 8514: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (

8510: IF l_debug_on THEN
8511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
8512: END IF;
8513: --
8514: WSH_DETAILS_VALIDATIONS.Check_Credit_Holds (
8515: l_det_tab(j).delivery_detail_id,
8516: 'PACK',
8517: NULL,
8518: NULL,

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

8954: l_tmp_split_qty := ROUND(((l_det_pack_qty*l_cont_avail_pc)/l_req_cont_num),LIMITED_PRECISION);
8955:
8956: --
8957: IF l_debug_on THEN
8958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
8959: END IF;
8960: --
8961: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
8962: l_det_inv_item_id,

Line 8961: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

8957: IF l_debug_on THEN
8958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
8959: END IF;
8960: --
8961: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
8962: l_det_inv_item_id,
8963: l_det_org_id,
8964: l_tmp_split_qty,
8965: l_det_qty_uom,

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

9230: l_tmp_split_qty := ROUND((l_split_pc*l_det_pack_qty/100),LIMITED_PRECISION);
9231:
9232: --
9233: IF l_debug_on THEN
9234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9235: END IF;
9236: --
9237: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9238: l_det_inv_item_id,

Line 9237: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (

9233: IF l_debug_on THEN
9234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
9235: END IF;
9236: --
9237: WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity (
9238: l_det_inv_item_id,
9239: l_det_org_id,
9240: l_tmp_split_qty,
9241: l_det_qty_uom,