[Home] [Help]
PACKAGE BODY: APPS.WSH_INTERFACE_PUB
Source
1 PACKAGE BODY WSH_INTERFACE_PUB as
2 /* $Header: WSHDDITB.pls 120.0 2005/05/26 18:06:48 appldev noship $ */
3
4 -- Procedure: Create_Shipment_Lines
5 --
6 -- Parameters: p_delivery_details_info IN WSH_DELIVERY_DETAILS_PKG.Deliver
7 -- y_Details_Rec_Type
8
9 -- Description: This procedure is a wraper for the create_delivery_Details.
10 -- It is called by any system that is pushing shipment lines
11 -- into shipping system.
12 --
13 --
14
15 --
16 G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INTERFACE_PUB';
17 --
18 PROCEDURE Create_Shipment_Lines(
19 p_delivery_details_info IN OUT NOCOPY wsh_delivery_details_pkg.Delivery_Details_Rec_Type,
20 x_delivery_Detail_id out NOCOPY number,
21 x_return_status out NOCOPY varchar2) is
22
23 -- Harmonization Project
24 l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
25 l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
26 l_dummy_ids wsh_util_core.id_Tab_type;
27 l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
28 l_msg_count NUMBER;
29 l_msg_data VARCHAR2(32767);
30 l_number_of_errors NUMBER := 0;
31 l_number_of_warnings NUMBER := 0;
32 l_return_status VARCHAR2(32767);
33 l_api_version NUMBER := 1.0;
34 l_init_msg_list VARCHAR2(32767);
35 l_commit VARCHAR2(32767);
36
37 --
38 l_debug_on BOOLEAN;
39 --
40 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_SHIPMENT_LINES';
41 --
42 BEGIN
43 --
44 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
45 --
46 IF l_debug_on IS NULL
47 THEN
48 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
49 END IF;
50 --
51 IF l_debug_on THEN
52 wsh_debug_sv.push(l_module_name, 'Create_Shipment_Lines');
53 wsh_debug_sv.log (l_module_name, 'Source Code', p_delivery_details_info.source_code);
54 wsh_debug_sv.log (l_module_name, 'Source Header Id', p_delivery_details_info.source_header_id);
55 wsh_debug_sv.log (l_module_name, 'Source Line Id', p_delivery_details_info.source_line_id);
56 wsh_debug_sv.log (l_module_name,'src_requested_quantity', p_delivery_details_info.src_requested_quantity);
57 wsh_debug_sv.log(l_module_name,'src_requested_quantity_uom', p_delivery_details_info.src_requested_quantity_uom);
58 wsh_debug_sv.log (l_module_name,'Item ID', p_delivery_details_info.inventory_item_id);
59 wsh_debug_sv.log (l_module_name, 'Ship From Location Id', p_delivery_details_info.ship_from_location_id);
60 wsh_debug_sv.log (l_module_name, 'Ship To Location Id', p_delivery_details_info.ship_to_location_id);
61 wsh_debug_sv.log (l_module_name, 'Organization Id', p_delivery_details_info.organization_id);
62 wsh_debug_sv.log (l_module_name, 'Org Id', p_delivery_details_info.org_id);
63 wsh_debug_sv.log (l_module_name, 'source_header_number', p_delivery_details_info.source_header_number);
64 wsh_debug_sv.log (l_module_name, 'Source Line Number', p_delivery_details_info.source_line_number);
65 END IF;
66
67 x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
68
69 IF (p_delivery_details_info.source_code='OKE') THEN
70
71 l_detail_info_tab(1).delivery_detail_id := p_delivery_details_info.delivery_detail_id;
72 l_detail_info_tab(1).source_code := p_delivery_details_info.source_code;
73 l_detail_info_tab(1).source_header_id := p_delivery_details_info.source_header_id;
74 l_detail_info_tab(1).source_line_id := p_delivery_details_info.source_line_id;
75 l_detail_info_tab(1).customer_id := p_delivery_details_info.customer_id;
76 l_detail_info_tab(1).sold_to_contact_id := p_delivery_details_info.sold_to_contact_id;
77 l_detail_info_tab(1).inventory_item_id := p_delivery_details_info.inventory_item_id;
78 l_detail_info_tab(1).item_description := p_delivery_details_info.item_description;
79 l_detail_info_tab(1).hazard_class_id := p_delivery_details_info.hazard_class_id;
80 l_detail_info_tab(1).country_of_origin := p_delivery_details_info.country_of_origin;
81 l_detail_info_tab(1).classification := p_delivery_details_info.classification;
82 l_detail_info_tab(1).ship_from_location_id := p_delivery_details_info.ship_from_location_id;
83 l_detail_info_tab(1).ship_to_location_id := p_delivery_details_info.ship_to_location_id;
84 l_detail_info_tab(1).ship_to_contact_id := p_delivery_details_info.ship_to_contact_id;
85 l_detail_info_tab(1).ship_to_site_use_id := p_delivery_details_info.ship_to_site_use_id;
86 l_detail_info_tab(1).deliver_to_location_id := p_delivery_details_info.deliver_to_location_id;
87 l_detail_info_tab(1).deliver_to_contact_id := p_delivery_details_info.deliver_to_contact_id;
88 l_detail_info_tab(1).deliver_to_site_use_id := p_delivery_details_info.deliver_to_site_use_id;
89 l_detail_info_tab(1).intmed_ship_to_location_id := p_delivery_details_info.intmed_ship_to_location_id;
90 l_detail_info_tab(1).intmed_ship_to_contact_id := p_delivery_details_info.intmed_ship_to_contact_id;
91 l_detail_info_tab(1).hold_code := p_delivery_details_info.hold_code;
92 l_detail_info_tab(1).ship_tolerance_above := p_delivery_details_info.ship_tolerance_above;
93 l_detail_info_tab(1).ship_tolerance_below := p_delivery_details_info.ship_tolerance_below;
94 l_detail_info_tab(1).requested_quantity := p_delivery_details_info.requested_quantity;
95 l_detail_info_tab(1).shipped_quantity := p_delivery_details_info.shipped_quantity;
96 l_detail_info_tab(1).delivered_quantity := p_delivery_details_info.delivered_quantity;
97 l_detail_info_tab(1).requested_quantity_uom := p_delivery_details_info.requested_quantity_uom;
98 l_detail_info_tab(1).subinventory := p_delivery_details_info.subinventory;
99 l_detail_info_tab(1).revision := p_delivery_details_info.revision;
100 l_detail_info_tab(1).lot_number := p_delivery_details_info.lot_number;
101 l_detail_info_tab(1).customer_requested_lot_flag := p_delivery_details_info.customer_requested_lot_flag;
102 l_detail_info_tab(1).serial_number := p_delivery_details_info.serial_number;
103 l_detail_info_tab(1).locator_id := p_delivery_details_info.locator_id;
104 l_detail_info_tab(1).date_requested := p_delivery_details_info.date_requested;
105 l_detail_info_tab(1).date_scheduled := p_delivery_details_info.date_scheduled;
106 l_detail_info_tab(1).master_container_item_id := p_delivery_details_info.master_container_item_id;
107 l_detail_info_tab(1).detail_container_item_id := p_delivery_details_info.detail_container_item_id;
108 l_detail_info_tab(1).load_seq_number := p_delivery_details_info.load_seq_number;
109 l_detail_info_tab(1).ship_method_code := p_delivery_details_info.ship_method_code;
110 l_detail_info_tab(1).carrier_id := p_delivery_details_info.carrier_id;
111 l_detail_info_tab(1).freight_terms_code := p_delivery_details_info.freight_terms_code;
112 l_detail_info_tab(1).shipment_priority_code := p_delivery_details_info.shipment_priority_code;
113 l_detail_info_tab(1).fob_code := p_delivery_details_info.fob_code;
114 l_detail_info_tab(1).customer_item_id := p_delivery_details_info.customer_item_id;
115 l_detail_info_tab(1).dep_plan_required_flag := p_delivery_details_info.dep_plan_required_flag;
116 l_detail_info_tab(1).customer_prod_seq := p_delivery_details_info.customer_prod_seq;
117 l_detail_info_tab(1).customer_dock_code := p_delivery_details_info.customer_dock_code;
118 l_detail_info_tab(1).cust_model_serial_number := p_delivery_details_info.cust_model_serial_number;
119 l_detail_info_tab(1).customer_job := p_delivery_details_info.customer_job ;
120 l_detail_info_tab(1).customer_production_line := p_delivery_details_info.customer_production_line;
121 l_detail_info_tab(1).net_weight := p_delivery_details_info.net_weight;
122 l_detail_info_tab(1).weight_uom_code := p_delivery_details_info.weight_uom_code;
123 l_detail_info_tab(1).volume := p_delivery_details_info.volume;
124 l_detail_info_tab(1).volume_uom_code := p_delivery_details_info.volume_uom_code;
125 l_detail_info_tab(1).tp_attribute_category := p_delivery_details_info.tp_attribute_category;
126 l_detail_info_tab(1).tp_attribute1 := p_delivery_details_info.tp_attribute1;
127 l_detail_info_tab(1).tp_attribute2 := p_delivery_details_info.tp_attribute2;
128 l_detail_info_tab(1).tp_attribute3 := p_delivery_details_info.tp_attribute3;
129 l_detail_info_tab(1).tp_attribute4 := p_delivery_details_info.tp_attribute4;
130 l_detail_info_tab(1).tp_attribute5 := p_delivery_details_info.tp_attribute5;
131 l_detail_info_tab(1).tp_attribute6 := p_delivery_details_info.tp_attribute6;
132 l_detail_info_tab(1).tp_attribute7 := p_delivery_details_info.tp_attribute7;
133 l_detail_info_tab(1).tp_attribute8 := p_delivery_details_info.tp_attribute8;
134 l_detail_info_tab(1).tp_attribute9 := p_delivery_details_info.tp_attribute9;
135 l_detail_info_tab(1).tp_attribute10 := p_delivery_details_info.tp_attribute10;
136 l_detail_info_tab(1).tp_attribute11 := p_delivery_details_info.tp_attribute11;
137 l_detail_info_tab(1).tp_attribute12 := p_delivery_details_info.tp_attribute12;
138 l_detail_info_tab(1).tp_attribute13 := p_delivery_details_info.tp_attribute13;
139 l_detail_info_tab(1).tp_attribute14 := p_delivery_details_info.tp_attribute14;
140 l_detail_info_tab(1).tp_attribute15 := p_delivery_details_info.tp_attribute15;
141 l_detail_info_tab(1).attribute_category := p_delivery_details_info.attribute_category;
142 l_detail_info_tab(1).attribute1 := p_delivery_details_info.attribute1;
143 l_detail_info_tab(1).attribute2 := p_delivery_details_info.attribute2;
144 l_detail_info_tab(1).attribute3 := p_delivery_details_info.attribute3;
145 l_detail_info_tab(1).attribute4 := p_delivery_details_info.attribute4;
146 l_detail_info_tab(1).attribute5 := p_delivery_details_info.attribute5;
147 l_detail_info_tab(1).attribute6 := p_delivery_details_info.attribute6;
148 l_detail_info_tab(1).attribute7 := p_delivery_details_info.attribute7;
149 l_detail_info_tab(1).attribute8 := p_delivery_details_info.attribute8;
150 l_detail_info_tab(1).attribute9 := p_delivery_details_info.attribute9;
151 l_detail_info_tab(1).attribute10 := p_delivery_details_info.attribute10;
152 l_detail_info_tab(1).attribute11 := p_delivery_details_info.attribute11;
153 l_detail_info_tab(1).attribute12 := p_delivery_details_info.attribute12;
154 l_detail_info_tab(1).attribute13 := p_delivery_details_info.attribute13;
155 l_detail_info_tab(1).attribute14 := p_delivery_details_info.attribute14;
156 l_detail_info_tab(1).attribute15 := p_delivery_details_info.attribute15;
157 l_detail_info_tab(1).created_by := p_delivery_details_info.created_by;
158 l_detail_info_tab(1).creation_date := p_delivery_details_info.creation_date;
159 l_detail_info_tab(1).last_update_date := p_delivery_details_info.last_update_date;
160 l_detail_info_tab(1).last_update_login := p_delivery_details_info.last_update_login;
161 l_detail_info_tab(1).last_updated_by := p_delivery_details_info.last_updated_by;
162 l_detail_info_tab(1).program_application_id := p_delivery_details_info.program_application_id;
163 l_detail_info_tab(1).program_id := p_delivery_details_info.program_id;
164 l_detail_info_tab(1).program_update_date := p_delivery_details_info.program_update_date;
165 l_detail_info_tab(1).request_id := p_delivery_details_info.request_id;
166 l_detail_info_tab(1).mvt_stat_status := p_delivery_details_info.mvt_stat_status;
167 l_detail_info_tab(1).released_flag := p_delivery_details_info.released_flag;
168 l_detail_info_tab(1).organization_id := p_delivery_details_info.organization_id;
169 l_detail_info_tab(1).transaction_temp_id := p_delivery_details_info.transaction_temp_id;
170 l_detail_info_tab(1).ship_set_id := p_delivery_details_info.ship_set_id;
171 l_detail_info_tab(1).arrival_set_id := p_delivery_details_info.arrival_set_id;
172 l_detail_info_tab(1).ship_model_complete_flag := p_delivery_details_info.ship_model_complete_flag;
173 l_detail_info_tab(1).top_model_line_id := p_delivery_details_info.top_model_line_id;
174 l_detail_info_tab(1).source_header_number := p_delivery_details_info.source_header_number;
175 l_detail_info_tab(1).source_header_type_id := p_delivery_details_info.source_header_type_id;
176 l_detail_info_tab(1).source_header_type_name := p_delivery_details_info.source_header_type_name;
177 l_detail_info_tab(1).cust_po_number := p_delivery_details_info.cust_po_number;
178 l_detail_info_tab(1).ato_line_id := p_delivery_details_info.ato_line_id;
179 l_detail_info_tab(1).src_requested_quantity := p_delivery_details_info.src_requested_quantity;
180 l_detail_info_tab(1).src_requested_quantity_uom := p_delivery_details_info.src_requested_quantity_uom;
181 l_detail_info_tab(1).move_order_line_id := p_delivery_details_info.move_order_line_id;
182 l_detail_info_tab(1).cancelled_quantity := p_delivery_details_info.cancelled_quantity;
183 l_detail_info_tab(1).quality_control_quantity := p_delivery_details_info.quality_control_quantity;
184 l_detail_info_tab(1).cycle_count_quantity := p_delivery_details_info.cycle_count_quantity;
185 l_detail_info_tab(1).tracking_number := p_delivery_details_info.tracking_number;
186 l_detail_info_tab(1).movement_id := p_delivery_details_info.movement_id;
187 l_detail_info_tab(1).shipping_instructions := p_delivery_details_info.shipping_instructions;
188 l_detail_info_tab(1).packing_instructions := p_delivery_details_info.packing_instructions;
189 l_detail_info_tab(1).project_id := p_delivery_details_info.project_id;
190 l_detail_info_tab(1).task_id := p_delivery_details_info.task_id ;
191 l_detail_info_tab(1).org_id := p_delivery_details_info.org_id ;
192 l_detail_info_tab(1).oe_interfaced_flag := p_delivery_details_info.oe_interfaced_flag;
193 l_detail_info_tab(1).split_from_detail_id := p_delivery_details_info.split_from_detail_id;
194 l_detail_info_tab(1).inv_interfaced_flag := p_delivery_details_info.inv_interfaced_flag;
195 l_detail_info_tab(1).source_line_number := p_delivery_details_info.source_line_number;
196 l_detail_info_tab(1).inspection_flag := p_delivery_details_info.inspection_flag;
197 l_detail_info_tab(1).released_status := p_delivery_details_info.released_status;
198 l_detail_info_tab(1).container_flag := p_delivery_details_info.container_flag;
199 l_detail_info_tab(1).container_type_code := p_delivery_details_info.container_type_code;
200 l_detail_info_tab(1).container_name := p_delivery_details_info.container_name;
201 l_detail_info_tab(1).fill_percent := p_delivery_details_info.fill_percent;
202 l_detail_info_tab(1).gross_weight := p_delivery_details_info.gross_weight;
203 l_detail_info_tab(1).master_serial_number := p_delivery_details_info.master_serial_number;
204 l_detail_info_tab(1).maximum_load_weight := p_delivery_details_info.maximum_load_weight;
205 l_detail_info_tab(1).maximum_volume := p_delivery_details_info.maximum_volume;
206 l_detail_info_tab(1).minimum_fill_percent := p_delivery_details_info.minimum_fill_percent;
207 l_detail_info_tab(1).seal_code := p_delivery_details_info.seal_code;
208 l_detail_info_tab(1).unit_number := p_delivery_details_info.unit_number;
209 l_detail_info_tab(1).unit_price := p_delivery_details_info.unit_price;
210 l_detail_info_tab(1).currency_code := p_delivery_details_info.currency_code;
211 l_detail_info_tab(1).freight_class_cat_id := p_delivery_details_info.freight_class_cat_id;
212 l_detail_info_tab(1).commodity_code_cat_id := p_delivery_details_info.commodity_code_cat_id;
213 l_detail_info_tab(1).preferred_grade := p_delivery_details_info.preferred_grade ;
214 l_detail_info_tab(1).src_requested_quantity2 := p_delivery_details_info.src_requested_quantity2 ;
215 l_detail_info_tab(1).src_requested_quantity_uom2 := p_delivery_details_info.src_requested_quantity_uom2;
216 l_detail_info_tab(1).requested_quantity2 := p_delivery_details_info.requested_quantity2 ;
217 l_detail_info_tab(1).shipped_quantity2 := p_delivery_details_info.shipped_quantity2 ;
218 l_detail_info_tab(1).delivered_quantity2 := p_delivery_details_info.delivered_quantity2 ;
219 l_detail_info_tab(1).cancelled_quantity2 := p_delivery_details_info.cancelled_quantity2 ;
220 l_detail_info_tab(1).quality_control_quantity2 := p_delivery_details_info.quality_control_quantity2 ;
221 l_detail_info_tab(1).cycle_count_quantity2 := p_delivery_details_info.cycle_count_quantity2 ;
222 l_detail_info_tab(1).requested_quantity_uom2 := p_delivery_details_info.requested_quantity_uom2;
223 l_detail_info_tab(1).lpn_id := p_delivery_details_info.lpn_id ;
224 l_detail_info_tab(1).pickable_flag := p_delivery_details_info.pickable_flag;
225 l_detail_info_tab(1).original_subinventory := p_delivery_details_info.original_subinventory;
226 l_detail_info_tab(1).to_serial_number := p_delivery_details_info.to_serial_number ;
227 l_detail_info_tab(1).picked_quantity := p_delivery_details_info.picked_quantity;
228 l_detail_info_tab(1).picked_quantity2 := p_delivery_details_info.picked_quantity2;
229 l_detail_info_tab(1).received_quantity := p_delivery_details_info.received_quantity;
230 l_detail_info_tab(1).received_quantity2 := p_delivery_details_info.received_quantity2;
231 l_detail_info_tab(1).source_line_set_id := p_delivery_details_info.source_line_set_id;
232 l_detail_info_tab(1).batch_id := p_delivery_details_info.batch_id;
233 l_detail_info_tab(1).ROWID := p_delivery_details_info.ROWID;
234 l_detail_info_tab(1).transaction_id := p_delivery_details_info.transaction_id;
235 l_detail_info_tab(1).VENDOR_ID := p_delivery_details_info.VENDOR_ID;
236 l_detail_info_tab(1).SHIP_FROM_SITE_ID := p_delivery_details_info.SHIP_FROM_SITE_ID;
237 l_detail_info_tab(1).LINE_DIRECTION := p_delivery_details_info.LINE_DIRECTION ;
238 l_detail_info_tab(1).PARTY_ID := p_delivery_details_info.PARTY_ID ;
239 l_detail_info_tab(1).ROUTING_REQ_ID := p_delivery_details_info.ROUTING_REQ_ID;
240 l_detail_info_tab(1).SHIPPING_CONTROL := p_delivery_details_info.SHIPPING_CONTROL;
241 l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := p_delivery_details_info.SOURCE_BLANKET_REFERENCE_ID;
242 l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := p_delivery_details_info.SOURCE_BLANKET_REFERENCE_NUM;
243 l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := p_delivery_details_info.PO_SHIPMENT_LINE_ID ;
244 l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := p_delivery_details_info.PO_SHIPMENT_LINE_NUMBER ;
245 l_detail_info_tab(1).RETURNED_QUANTITY := p_delivery_details_info.RETURNED_QUANTITY ;
246 l_detail_info_tab(1).RETURNED_QUANTITY2 := p_delivery_details_info.RETURNED_QUANTITY2 ;
247 l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := p_delivery_details_info.RCV_SHIPMENT_LINE_ID ;
248 l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := p_delivery_details_info.SOURCE_LINE_TYPE_CODE ;
249 l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := p_delivery_details_info.SUPPLIER_ITEM_NUMBER ;
250 l_detail_info_tab(1).IGNORE_FOR_PLANNING := p_delivery_details_info.IGNORE_FOR_PLANNING;
251 l_detail_info_tab(1).EARLIEST_PICKUP_DATE := p_delivery_details_info.EARLIEST_PICKUP_DATE ;
252 l_detail_info_tab(1).LATEST_PICKUP_DATE := p_delivery_details_info.LATEST_PICKUP_DATE ;
253 l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := p_delivery_details_info.EARLIEST_DROPOFF_DATE ;
254 l_detail_info_tab(1).LATEST_DROPOFF_DATE := p_delivery_details_info.LATEST_DROPOFF_DATE ;
255 l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := p_delivery_details_info.REQUEST_DATE_TYPE_CODE;
256 l_detail_info_tab(1).tp_delivery_detail_id := p_delivery_details_info.tp_delivery_detail_id;
257 l_detail_info_tab(1).source_document_type_id := p_delivery_details_info.source_document_type_id;
258 l_detail_info_tab(1).unit_weight := p_delivery_details_info.unit_weight;
259 l_detail_info_tab(1).unit_volume := p_delivery_details_info.unit_volume;
260 l_detail_info_tab(1).filled_volume := p_delivery_details_info.filled_volume;
261 l_detail_info_tab(1).wv_frozen_flag := p_delivery_details_info.wv_frozen_flag;
262 l_detail_info_tab(1).mode_of_transport := p_delivery_details_info.mode_of_transport;
263 l_detail_info_tab(1).service_level := p_delivery_details_info.service_level ;
264 l_detail_info_tab(1).po_revision_number := p_delivery_details_info.po_revision_number;
265 l_detail_info_tab(1).release_revision_number := p_delivery_details_info.release_revision_number ;
266 -- Harmonization Project. Call Group API.
267 l_in_rec.caller := 'WSH_PUB';
268 l_in_rec.action_code := 'CREATE';
269
270
271 IF l_debug_on THEN
272 WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
273 END IF;
274
275 wsh_interface_grp.create_update_delivery_detail(
276 p_api_version_number => l_api_version,
277 p_init_msg_list => l_init_msg_list,
278 p_commit => l_commit,
279 x_return_status => l_return_status,
280 x_msg_count => l_msg_count,
281 x_msg_data => l_msg_data,
282 p_detail_info_tab => l_detail_info_tab,
283 p_IN_rec => l_in_rec,
284 x_OUT_rec => l_out_rec);
285
286 --
287 wsh_util_core.api_post_call(
288 p_return_status => l_return_status,
289 x_num_warnings => l_number_of_warnings,
290 x_num_errors => l_number_of_errors,
291 p_msg_data => l_msg_data
292 );
293
294 x_delivery_Detail_id := l_out_rec.detail_ids(l_out_rec.detail_ids.first);
295
296 END IF;
297 IF l_debug_on THEN
298 wsh_debug_sv.pop(l_module_name);
299 END IF;
300
301 EXCEPTION
302 when fnd_api.g_exc_error then
303 x_return_status := FND_API.G_RET_STS_ERROR ;
304
305 IF l_debug_on THEN
306 WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
307 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
308 END IF;
309 --
310 when others then
311 x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
312 wsh_util_core.default_handler('WSH_INTERFACE_PUB.Create_Shipment_Lines');
313 IF l_debug_on THEN
314 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
315 SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
316 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
317 END IF;
318
319 END Create_Shipment_Lines;
320
321
322 END WSH_INTERFACE_PUB;