DBA Data[Home] [Help]

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_BULK_PROCESS_PVT

Line 1613: l_additional_line_info_rec WSH_BULK_PROCESS_PVT.additional_line_info_rec_type;

1609: x_split_weight NUMBER;
1610: x_split_volume NUMBER;
1611: x_delivery_assignment_id NUMBEr;
1612: l_header_id NUMBER;
1613: l_additional_line_info_rec WSH_BULK_PROCESS_PVT.additional_line_info_rec_type;
1614: l_api_version CONSTANT NUMBER := 1.0;
1615: l_msg_count NUMBER := 0;
1616: l_msg_data VARCHAR2(1000) := NULL;
1617: l_release_status VARCHAR2(1);

Line 2131: -- WSH_BULK_PROCESS_PVT.bulk_insert_details API to do the insert operation.

2127: ELSE
2128: -- p_dd_rec.delivery_detail_id is null.Need to insert record into wsh_delivery_details.
2129: -- This is done by first populating addtional line information using
2130: -- WSH_PO_CMG_PVT.populate_additional_line_info API and then calling
2131: -- WSH_BULK_PROCESS_PVT.bulk_insert_details API to do the insert operation.
2132: --
2133: -- Debug Statements
2134: --
2135: IF l_debug_on THEN

Line 2162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BULK_PROCESS_PVT.BULK_INSERT_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

2158: --
2159: -- Debug Statements
2160: --
2161: IF l_debug_on THEN
2162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BULK_PROCESS_PVT.BULK_INSERT_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
2163: WSH_DEBUG_SV.log(l_module_name,'P_line_rec.requested_quantity is', P_line_rec.requested_quantity(p_dd_rec.shpmt_line_id_idx_tab(i)));
2164: WSH_DEBUG_SV.log(l_module_name,'P_line_rec.received_quantity is', P_line_rec.received_quantity(p_dd_rec.shpmt_line_id_idx_tab(i)));
2165: WSH_DEBUG_SV.log(l_module_name,'P_line_recs index is ', p_dd_rec.shpmt_line_id_idx_tab(i));
2166: END IF;

Line 2179: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details

2175:
2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.log(l_module_name,'p_dd_rec.requested_quantity_uom 2nd occurance ', p_dd_rec.requested_qty_uom_tab(i));
2178: END IF;
2179: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details
2180: WSH_BULK_PROCESS_PVT.bulk_insert_details(
2181: P_line_rec => P_line_rec,
2182: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2183: p_action_prms => l_action_prms,--change by arun

Line 2180: WSH_BULK_PROCESS_PVT.bulk_insert_details(

2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.log(l_module_name,'p_dd_rec.requested_quantity_uom 2nd occurance ', p_dd_rec.requested_qty_uom_tab(i));
2178: END IF;
2179: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details
2180: WSH_BULK_PROCESS_PVT.bulk_insert_details(
2181: P_line_rec => P_line_rec,
2182: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2183: p_action_prms => l_action_prms,--change by arun
2184: p_additional_line_info_rec => l_additional_line_info_rec,

Line 2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BULK_PROCESS_PVT.BULK_INSERT_DETAILS - 2 ',WSH_DEBUG_SV.C_PROC_LEVEL);

2699: --
2700: -- Debug Statements
2701: --
2702: IF l_debug_on THEN
2703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_BULK_PROCESS_PVT.BULK_INSERT_DETAILS - 2 ',WSH_DEBUG_SV.C_PROC_LEVEL);
2704: WSH_DEBUG_SV.log(l_module_name,'P_line_rec.requested_quantity is', P_line_rec.requested_quantity(p_dd_rec.shpmt_line_id_idx_tab(i)));
2705: WSH_DEBUG_SV.log(l_module_name,'P_line_rec.received_quantity is', P_line_rec.received_quantity(p_dd_rec.shpmt_line_id_idx_tab(i)));
2706: WSH_DEBUG_SV.log(l_module_name,'P_line_recs index is ', p_dd_rec.shpmt_line_id_idx_tab(i));
2707: END IF;

Line 2720: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details

2716: IF l_debug_on THEN
2717: WSH_DEBUG_SV.log(l_module_name,'p_dd_rec.requested_quantity_uom 3rd occurance ', p_dd_rec.requested_qty_uom_tab(i));
2718: END IF;
2719:
2720: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details
2721:
2722: WSH_BULK_PROCESS_PVT.bulk_insert_details (
2723: P_line_rec => P_line_rec,
2724: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),

Line 2722: WSH_BULK_PROCESS_PVT.bulk_insert_details (

2718: END IF;
2719:
2720: -- Calling WSH_BULK_PROCESS_PVT.bulk_insert_details
2721:
2722: WSH_BULK_PROCESS_PVT.bulk_insert_details (
2723: P_line_rec => P_line_rec,
2724: p_index => p_dd_rec.shpmt_line_id_idx_tab(i),
2725: p_action_prms => l_action_prms,--change by arun
2726: p_additional_line_info_rec => l_additional_line_info_rec,