[Home] [Help]
PACKAGE BODY: APPS.WSH_TRX_HANDLER
Source
1 PACKAGE BODY WSH_TRX_HANDLER AS
2 /* $Header: WSHIIXIB.pls 120.0.12010000.2 2009/04/27 13:50:00 selsubra ship $ */
3 --
4 -- PACKAGE VARIABLES
5 --
6
7 g_userid NUMBER;
8
9 -- ===========================================================================
10 --
11 -- Name:
12 --
13 -- insert_row
14 --
15 -- Description:
16 --
17 -- Called by the client to insert a row into the
18 -- MTL_TRANSACTIONS_INTERFACE table.
19 --
20 -- ===========================================================================
21 --
22 G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRX_HANDLER';
23 --
24
25 --HVOP heali
26 PROCEDURE INSERT_ROW_BULK (
27 p_start_index IN NUMBER,
28 p_end_index IN NUMBER,
29 p_mtl_txn_if_rec IN WSH_SHIP_CONFIRM_ACTIONS.mtl_txn_if_rec_type,
30 x_return_status OUT NOCOPY VARCHAR2) IS
31
32 l_debug_on BOOLEAN;
33 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW_BULK';
34
35 l_bulk_batch_size NUMBER;
36 l_total_row_count NUMBER:=0;
37 l_start_index NUMBER ;
38 l_end_index NUMBER ;
39
40 BEGIN
41 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
42
43 IF l_debug_on IS NULL THEN
44 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
45 END IF;
46
47 IF l_debug_on THEN
48 WSH_DEBUG_SV.push(l_module_name);
49 WSH_DEBUG_SV.log(l_module_name,'p_start_index',p_start_index);
50 WSH_DEBUG_SV.log(l_module_name,'p_end_index',p_end_index);
51 WSH_DEBUG_SV.log(l_module_name,'p_mtl_txn_if_rec.count',p_mtl_txn_if_rec.picking_line_id.count);
52 END IF;
53
54 x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
55
56 fnd_profile.get('USER_ID',g_userid);
57
58 FORALL i IN p_start_index..p_end_index
59 INSERT INTO mtl_transactions_interface (
60 source_code,
61 source_header_id,
62 source_line_id,
63 inventory_item_id,
64 subinventory_code,
65 transaction_quantity,
66 transaction_date,
67 organization_id,
68 transaction_source_id,
69 transaction_source_type_id,
70 transaction_action_id,
71 transaction_type_id,
72 distribution_account_id,
73 transaction_reference,
74 transaction_header_id,
75 trx_source_line_id,
76 trx_source_delivery_id,
77 revision,
78 locator_id,
79 picking_line_id,
80 transfer_subinventory,
81 transfer_organization,
82 ship_to_location_id,
83 requisition_line_id,
84 requisition_distribution_id,
85 transaction_uom,
86 transaction_interface_id,
87 shipment_number,
88 expected_arrival_date,
89 encumbrance_account,
90 encumbrance_amount,
91 movement_id,
92 freight_code,
93 waybill_airbill,
94 content_lpn_id,
95 process_flag,
96 transaction_mode,
97 -- HW OPMCONV. Added secondary_qty and secondary_uom
98 SECONDARY_TRANSACTION_QUANTITY,
99 SECONDARY_UOM_CODE,
100 last_update_date,
101 last_updated_by,
102 creation_date,
103 created_by
104
105 ) VALUES (
106 p_mtl_txn_if_rec.source_code(i),
107 p_mtl_txn_if_rec.source_header_id(i),
108 p_mtl_txn_if_rec.source_line_id(i),
109 p_mtl_txn_if_rec.inventory_item_id(i),
110 p_mtl_txn_if_rec.subinventory(i),
111 p_mtl_txn_if_rec.trx_quantity(i),
112 p_mtl_txn_if_rec.trx_date(i),
113 p_mtl_txn_if_rec.organization_id(i),
114 p_mtl_txn_if_rec.trx_source_id(i),
115 p_mtl_txn_if_rec.trx_source_type_id(i),
116 p_mtl_txn_if_rec.trx_action_id(i),
117 p_mtl_txn_if_rec.trx_type_id(i),
118 p_mtl_txn_if_rec.distribution_account_id(i),
119 p_mtl_txn_if_rec.trx_reference(i),
120 p_mtl_txn_if_rec.trx_header_id(i),
121 p_mtl_txn_if_rec.trx_source_line_id(i),
122 p_mtl_txn_if_rec.trx_source_delivery_id(i),
123 p_mtl_txn_if_rec.revision(i),
124 p_mtl_txn_if_rec.locator_id(i),
125 p_mtl_txn_if_rec.picking_line_id(i),
126 p_mtl_txn_if_rec.transfer_subinventory(i),
127 p_mtl_txn_if_rec.transfer_organization(i),
128 p_mtl_txn_if_rec.ship_to_location_id(i),
129 p_mtl_txn_if_rec.requisition_line_id(i),
130 p_mtl_txn_if_rec.requisition_distribution_id(i),
131 p_mtl_txn_if_rec.trx_uom(i),
132 p_mtl_txn_if_rec.trx_interface_id(i),
133 p_mtl_txn_if_rec.shipment_number(i),
134 p_mtl_txn_if_rec.expected_arrival_date(i),
135 p_mtl_txn_if_rec.encumbrance_account(i),
136 p_mtl_txn_if_rec.encumbrance_amount(i),
137 p_mtl_txn_if_rec.movement_id(i),
138 p_mtl_txn_if_rec.freight_code(i),
139 p_mtl_txn_if_rec.waybill_airbill(i), --Bug 7503285
140 p_mtl_txn_if_rec.content_lpn_id(i),
141 '1',
142 '3',
143 -- HW OPMCONV. Added secondary_qty and secondary_uom
144 p_mtl_txn_if_rec.trx_quantity2(i),
145 p_mtl_txn_if_rec.SECONDARY_TRX_UOM(i),
146 SYSDATE,
147 g_userid,
148 SYSDATE,
149 g_userid
150 );
151
152 IF l_debug_on THEN
153 WSH_DEBUG_SV.log(l_module_name,'Rows inserted in mtl_transactions_interface',SQL%ROWCOUNT);
154 END IF;
155
156 -- Delete all the record with error_flag 'Y'
157 FORALL i IN p_start_index..p_end_index
158 DELETE mtl_transactions_interface
159 WHERE picking_line_id = decode(p_mtl_txn_if_rec.error_flag(i),
160 'Y',p_mtl_txn_if_rec.picking_line_id(i),
161 'N',-99999);
162 IF l_debug_on THEN
163 WSH_DEBUG_SV.log(l_module_name,'Rows Delete in mtl_transactions_interface',SQL%ROWCOUNT);
164 END IF;
165
166 FORALL i IN p_start_index..p_end_index
167 UPDATE wsh_delivery_details
168 SET inv_interfaced_flag='P'
169 WHERE delivery_detail_id = decode(p_mtl_txn_if_rec.error_flag(i),
170 'N',p_mtl_txn_if_rec.picking_line_id(i),
171 'Y',-99999);
172 IF l_debug_on THEN
173 WSH_DEBUG_SV.log(l_module_name,'Rows Updated in wsh_delivery_details',SQL%ROWCOUNT);
174 END IF;
175
176 IF l_debug_on THEN
177 WSH_DEBUG_SV.pop(l_module_name);
178 END IF;
179
180 EXCEPTION
181 WHEN OTHERS THEN
182 x_return_status:= WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
183
184 IF l_debug_on THEN
185 WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
186 WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
187 END IF;
188
189 END insert_row_bulk;
190 --HVOP heali
191
192
193
194 PROCEDURE Insert_Row (
195 x_rowid IN OUT NOCOPY VARCHAR2,
196 x_trx_interface_id IN OUT NOCOPY NUMBER,
197 p_trx_header_id IN NUMBER,
198 p_trx_source_id IN NUMBER,
199 p_source_code IN VARCHAR2,
200 p_source_line_id IN NUMBER,
201 p_source_header_id IN NUMBER,
202 p_inventory_item_id IN NUMBER,
203 p_subinventory_code IN VARCHAR2,
204 p_trx_quantity IN NUMBER,
205 p_transaction_date IN DATE,
206 p_organization_id IN NUMBER,
207 p_dsp_segment1 IN VARCHAR2,
208 p_dsp_segment2 IN VARCHAR2,
209 p_dsp_segment3 IN VARCHAR2,
210 p_trx_source_type_id IN NUMBER,
211 p_trx_action_id IN NUMBER,
212 p_trx_type_id IN NUMBER,
213 p_distribution_account_id IN NUMBER,
214 p_dst_segment1 IN VARCHAR2,
215 p_dst_segment2 IN VARCHAR2,
216 p_dst_segment3 IN VARCHAR2,
217 p_dst_segment4 IN VARCHAR2,
218 p_dst_segment5 IN VARCHAR2,
219 p_dst_segment6 IN VARCHAR2,
220 p_dst_segment7 IN VARCHAR2,
221 p_dst_segment8 IN VARCHAR2,
222 p_dst_segment9 IN VARCHAR2,
223 p_dst_segment10 IN VARCHAR2,
224 p_dst_segment11 IN VARCHAR2,
225 p_dst_segment12 IN VARCHAR2,
226 p_dst_segment13 IN VARCHAR2,
227 p_dst_segment14 IN VARCHAR2,
228 p_dst_segment15 IN VARCHAR2,
229 p_dst_segment16 IN VARCHAR2,
230 p_dst_segment17 IN VARCHAR2,
231 p_dst_segment18 IN VARCHAR2,
232 p_dst_segment19 IN VARCHAR2,
233 p_dst_segment20 IN VARCHAR2,
234 p_dst_segment21 IN VARCHAR2,
235 p_dst_segment22 IN VARCHAR2,
236 p_dst_segment23 IN VARCHAR2,
237 p_dst_segment24 IN VARCHAR2,
238 p_dst_segment25 IN VARCHAR2,
239 p_dst_segment26 IN VARCHAR2,
240 p_dst_segment27 IN VARCHAR2,
241 p_dst_segment28 IN VARCHAR2,
242 p_dst_segment29 IN VARCHAR2,
243 p_dst_segment30 IN VARCHAR2,
244 p_trx_reference IN VARCHAR2,
245 p_trx_source_line_id IN NUMBER,
246 p_trx_source_delivery_id IN NUMBER,
247 p_revision IN VARCHAR2,
248 p_locator_id IN NUMBER,
249 p_loc_segment1 IN VARCHAR2,
250 p_loc_segment2 IN VARCHAR2,
251 p_loc_segment3 IN VARCHAR2,
252 p_loc_segment4 IN VARCHAR2,
253 p_picking_line_id IN NUMBER,
254 p_transfer_subinventory IN VARCHAR2,
255 p_transfer_organization IN NUMBER,
256 p_ship_to_location_id IN NUMBER,
257 p_requisition_line_id IN NUMBER,
258 p_trx_uom IN VARCHAR2,
259 p_demand_id IN NUMBER,
260 p_shipment_number IN VARCHAR2,
261 p_expected_arrival_date IN DATE,
262 p_encumbrance_account IN NUMBER,
263 p_encumbrance_amount IN NUMBER,
264 p_movement_id IN NUMBER,
265 p_freight_code IN VARCHAR2,
266 p_waybill_airbill IN VARCHAR2,
267 p_last_update_date IN DATE,
268 p_last_updated_by IN NUMBER,
269 p_creation_date IN DATE,
270 p_created_by IN NUMBER,
271 p_last_update_login IN NUMBER DEFAULT NULL,
272 p_request_id IN NUMBER DEFAULT NULL,
273 p_program_application_id IN NUMBER DEFAULT NULL,
274 p_program_id IN NUMBER DEFAULT NULL,
275 p_program_update_date IN DATE DEFAULT NULL,
276 p_process_flag IN NUMBER DEFAULT 1,
277 p_trx_mode IN NUMBER DEFAULT 3,
278 -- rec in MTI shold be locked, since the Inv worker is called to process the interface records.
279 p_lock_flag IN NUMBER DEFAULT 2,
280 p_acct_period_id IN NUMBER DEFAULT NULL,
281 p_required_flag IN VARCHAR2 DEFAULT NULL,
282 p_currency_code IN VARCHAR2 DEFAULT NULL,
283 p_currency_conversion_type IN VARCHAR2 DEFAULT NULL,
284 p_currency_conversion_date IN DATE DEFAULT NULL,
285 p_currency_conversion_rate IN NUMBER DEFAULT NULL,
286 p_project_id IN NUMBER DEFAULT NULL,
287 p_task_id IN NUMBER DEFAULT NULL,
288 p_validation_required IN NUMBER DEFAULT NULL,
289 p_item_segment1 IN VARCHAR2 DEFAULT NULL,
290 p_item_segment2 IN VARCHAR2 DEFAULT NULL,
291 p_item_segment3 IN VARCHAR2 DEFAULT NULL,
292 p_item_segment4 IN VARCHAR2 DEFAULT NULL,
293 p_item_segment5 IN VARCHAR2 DEFAULT NULL,
294 p_item_segment6 IN VARCHAR2 DEFAULT NULL,
295 p_item_segment7 IN VARCHAR2 DEFAULT NULL,
296 p_item_segment8 IN VARCHAR2 DEFAULT NULL,
297 p_item_segment9 IN VARCHAR2 DEFAULT NULL,
298 p_item_segment10 IN VARCHAR2 DEFAULT NULL,
299 p_item_segment11 IN VARCHAR2 DEFAULT NULL,
300 p_item_segment12 IN VARCHAR2 DEFAULT NULL,
301 p_item_segment13 IN VARCHAR2 DEFAULT NULL,
302 p_item_segment14 IN VARCHAR2 DEFAULT NULL,
303 p_item_segment15 IN VARCHAR2 DEFAULT NULL,
304 p_item_segment16 IN VARCHAR2 DEFAULT NULL,
305 p_item_segment17 IN VARCHAR2 DEFAULT NULL,
306 p_item_segment18 IN VARCHAR2 DEFAULT NULL,
307 p_item_segment19 IN VARCHAR2 DEFAULT NULL,
308 p_item_segment20 IN VARCHAR2 DEFAULT NULL,
309 p_primary_quantity IN NUMBER DEFAULT NULL,
310 p_loc_segment5 IN VARCHAR2 DEFAULT NULL,
311 p_loc_segment6 IN VARCHAR2 DEFAULT NULL,
312 p_loc_segment7 IN VARCHAR2 DEFAULT NULL,
313 p_loc_segment8 IN VARCHAR2 DEFAULT NULL,
314 p_loc_segment9 IN VARCHAR2 DEFAULT NULL,
315 p_loc_segment10 IN VARCHAR2 DEFAULT NULL,
316 p_loc_segment11 IN VARCHAR2 DEFAULT NULL,
317 p_loc_segment12 IN VARCHAR2 DEFAULT NULL,
318 p_loc_segment13 IN VARCHAR2 DEFAULT NULL,
319 p_loc_segment14 IN VARCHAR2 DEFAULT NULL,
320 p_loc_segment15 IN VARCHAR2 DEFAULT NULL,
321 p_loc_segment16 IN VARCHAR2 DEFAULT NULL,
322 p_loc_segment17 IN VARCHAR2 DEFAULT NULL,
323 p_loc_segment18 IN VARCHAR2 DEFAULT NULL,
324 p_loc_segment19 IN VARCHAR2 DEFAULT NULL,
325 p_loc_segment20 IN VARCHAR2 DEFAULT NULL,
326 p_dsp_segment4 IN VARCHAR2 DEFAULT NULL,
327 p_dsp_segment5 IN VARCHAR2 DEFAULT NULL,
328 p_dsp_segment6 IN VARCHAR2 DEFAULT NULL,
329 p_dsp_segment7 IN VARCHAR2 DEFAULT NULL,
330 p_dsp_segment8 IN VARCHAR2 DEFAULT NULL,
331 p_dsp_segment9 IN VARCHAR2 DEFAULT NULL,
332 p_dsp_segment10 IN VARCHAR2 DEFAULT NULL,
333 p_dsp_segment11 IN VARCHAR2 DEFAULT NULL,
334 p_dsp_segment12 IN VARCHAR2 DEFAULT NULL,
335 p_dsp_segment13 IN VARCHAR2 DEFAULT NULL,
336 p_dsp_segment14 IN VARCHAR2 DEFAULT NULL,
337 p_dsp_segment15 IN VARCHAR2 DEFAULT NULL,
338 p_dsp_segment16 IN VARCHAR2 DEFAULT NULL,
339 p_dsp_segment17 IN VARCHAR2 DEFAULT NULL,
340 p_dsp_segment18 IN VARCHAR2 DEFAULT NULL,
341 p_dsp_segment19 IN VARCHAR2 DEFAULT NULL,
342 p_dsp_segment20 IN VARCHAR2 DEFAULT NULL,
343 p_dsp_segment21 IN VARCHAR2 DEFAULT NULL,
344 p_dsp_segment22 IN VARCHAR2 DEFAULT NULL,
345 p_dsp_segment23 IN VARCHAR2 DEFAULT NULL,
346 p_dsp_segment24 IN VARCHAR2 DEFAULT NULL,
347 p_dsp_segment25 IN VARCHAR2 DEFAULT NULL,
348 p_dsp_segment26 IN VARCHAR2 DEFAULT NULL,
349 p_dsp_segment27 IN VARCHAR2 DEFAULT NULL,
350 p_dsp_segment28 IN VARCHAR2 DEFAULT NULL,
351 p_dsp_segment29 IN VARCHAR2 DEFAULT NULL,
352 p_dsp_segment30 IN VARCHAR2 DEFAULT NULL,
353 p_trx_source_name IN VARCHAR2 DEFAULT NULL,
354 p_reason_id IN NUMBER DEFAULT NULL,
355 p_trx_cost IN NUMBER DEFAULT NULL,
356 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
357 p_wip_entity_type IN NUMBER DEFAULT NULL,
358 p_schedule_id IN NUMBER DEFAULT NULL,
359 p_employee_code IN VARCHAR2 DEFAULT NULL,
360 p_department_id IN NUMBER DEFAULT NULL,
361 p_schedule_update_code IN NUMBER DEFAULT NULL,
362 p_setup_teardown_code IN NUMBER DEFAULT NULL,
363 p_primary_switch IN NUMBER DEFAULT NULL,
364 p_mrp_code IN NUMBER DEFAULT NULL,
365 p_operation_seq_num IN NUMBER DEFAULT NULL,
366 p_repetitive_line_id IN NUMBER DEFAULT NULL,
367 p_customer_ship_id IN NUMBER DEFAULT NULL,
368 p_line_item_num IN NUMBER DEFAULT NULL,
369 p_receiving_document IN VARCHAR2 DEFAULT NULL,
370 p_rcv_transaction_id IN NUMBER DEFAULT NULL,
371 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
372 p_transfer_locator IN NUMBER DEFAULT NULL,
373 p_xfer_loc_segment1 IN VARCHAR2 DEFAULT NULL,
374 p_xfer_loc_segment2 IN VARCHAR2 DEFAULT NULL,
375 p_xfer_loc_segment3 IN VARCHAR2 DEFAULT NULL,
376 p_xfer_loc_segment4 IN VARCHAR2 DEFAULT NULL,
377 p_xfer_loc_segment5 IN VARCHAR2 DEFAULT NULL,
378 p_xfer_loc_segment6 IN VARCHAR2 DEFAULT NULL,
379 p_xfer_loc_segment7 IN VARCHAR2 DEFAULT NULL,
380 p_xfer_loc_segment8 IN VARCHAR2 DEFAULT NULL,
381 p_xfer_loc_segment9 IN VARCHAR2 DEFAULT NULL,
382 p_xfer_loc_segment10 IN VARCHAR2 DEFAULT NULL,
383 p_xfer_loc_segment11 IN VARCHAR2 DEFAULT NULL,
384 p_xfer_loc_segment12 IN VARCHAR2 DEFAULT NULL,
385 p_xfer_loc_segment13 IN VARCHAR2 DEFAULT NULL,
386 p_xfer_loc_segment14 IN VARCHAR2 DEFAULT NULL,
387 p_xfer_loc_segment15 IN VARCHAR2 DEFAULT NULL,
388 p_xfer_loc_segment16 IN VARCHAR2 DEFAULT NULL,
389 p_xfer_loc_segment17 IN VARCHAR2 DEFAULT NULL,
390 p_xfer_loc_segment18 IN VARCHAR2 DEFAULT NULL,
391 p_xfer_loc_segment19 IN VARCHAR2 DEFAULT NULL,
392 p_xfer_loc_segment20 IN VARCHAR2 DEFAULT NULL,
393 p_transportation_cost IN NUMBER DEFAULT NULL,
394 p_transportation_account IN NUMBER DEFAULT NULL,
395 p_transfer_cost IN NUMBER DEFAULT NULL,
396 p_containers IN NUMBER DEFAULT NULL,
397 p_new_average_cost IN NUMBER DEFAULT NULL,
398 p_value_change IN NUMBER DEFAULT NULL,
399 p_percentage_change IN NUMBER DEFAULT NULL,
400 p_demand_source_header_id IN NUMBER DEFAULT NULL,
401 p_demand_source_line IN VARCHAR2 DEFAULT NULL,
402 p_demand_source_delivery IN VARCHAR2 DEFAULT NULL,
403 p_negative_req_flag IN NUMBER DEFAULT NULL,
404 p_error_explanation IN VARCHAR2 DEFAULT NULL,
405 p_shippable_flag IN VARCHAR2 DEFAULT NULL,
406 p_error_code IN VARCHAR2 DEFAULT NULL,
407 p_attribute_category IN VARCHAR2 DEFAULT NULL,
408 p_attribute1 IN VARCHAR2 DEFAULT NULL,
409 p_attribute2 IN VARCHAR2 DEFAULT NULL,
410 p_attribute3 IN VARCHAR2 DEFAULT NULL,
411 p_attribute4 IN VARCHAR2 DEFAULT NULL,
412 p_attribute5 IN VARCHAR2 DEFAULT NULL,
413 p_attribute6 IN VARCHAR2 DEFAULT NULL,
414 p_attribute7 IN VARCHAR2 DEFAULT NULL,
415 p_attribute8 IN VARCHAR2 DEFAULT NULL,
416 p_attribute9 IN VARCHAR2 DEFAULT NULL,
417 p_attribute10 IN VARCHAR2 DEFAULT NULL,
418 p_attribute11 IN VARCHAR2 DEFAULT NULL,
419 p_attribute12 IN VARCHAR2 DEFAULT NULL,
420 p_attribute13 IN VARCHAR2 DEFAULT NULL,
421 p_attribute14 IN VARCHAR2 DEFAULT NULL,
422 p_attribute15 IN VARCHAR2 DEFAULT NULL,
423 p_requisition_distribution_id IN NUMBER DEFAULT NULL,
424 p_reservation_quantity IN NUMBER DEFAULT NULL,
425 p_shipped_quantity IN NUMBER DEFAULT NULL,
426 p_inventory_item IN VARCHAR2 DEFAULT NULL,
427 p_locator_name IN VARCHAR2 DEFAULT NULL,
428 p_to_task_id IN NUMBER DEFAULT NULL,
429 p_source_task_id IN NUMBER DEFAULT NULL,
430 p_to_project_id IN NUMBER DEFAULT NULL,
431 p_source_project_id IN NUMBER DEFAULT NULL,
432 p_pa_expenditure_org_id IN NUMBER DEFAULT NULL,
433 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
434 p_final_completion_flag IN VARCHAR2 DEFAULT NULL,
435 p_transfer_percentage IN NUMBER DEFAULT NULL,
436 p_trx_sequence_id IN NUMBER DEFAULT NULL,
437 p_material_account IN NUMBER DEFAULT NULL,
438 p_material_overhead_account IN NUMBER DEFAULT NULL,
439 p_resource_account IN NUMBER DEFAULT NULL,
440 p_outside_processing_account IN NUMBER DEFAULT NULL,
441 p_overhead_account IN NUMBER DEFAULT NULL,
442 p_bom_revision IN VARCHAR2 DEFAULT NULL,
443 p_routing_revision IN VARCHAR2 DEFAULT NULL,
444 p_bom_revision_date IN DATE DEFAULT NULL,
445 p_routing_revision_date IN DATE DEFAULT NULL,
446 p_alternate_bom_designator IN VARCHAR2 DEFAULT NULL,
447 p_alternate_routing_designator IN VARCHAR2 DEFAULT NULL,
448 p_accounting_class IN VARCHAR2 DEFAULT NULL,
449 p_demand_class IN VARCHAR2 DEFAULT NULL,
450 p_parent_id IN NUMBER DEFAULT NULL,
451 p_substitution_type_id IN NUMBER DEFAULT NULL,
452 p_substitution_item_id IN NUMBER DEFAULT NULL,
453 p_schedule_group IN NUMBER DEFAULT NULL,
454 p_build_sequence IN NUMBER DEFAULT NULL,
455 p_schedule_number IN VARCHAR2 DEFAULT NULL,
456 p_scheduled_flag IN NUMBER DEFAULT NULL,
457 p_flow_schedule IN VARCHAR2 DEFAULT NULL,
458 p_cost_group_id IN NUMBER DEFAULT NULL,
459 p_content_lpn_id IN NUMBER DEFAULT NULL,
460 -- HW OPMCONV. Added p_secondary_trx_quantity
461 -- and p_secondary_uom_code
462 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
463 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
464 )
465 IS
466
467 CURSOR row_id IS
468 SELECT rowid FROM mtl_transactions_interface
469 WHERE transaction_interface_id = x_trx_interface_id;
470
471 CURSOR get_interface_id IS
472 SELECT mtl_material_transactions_s.nextval
473 FROM sys.dual;
474
475 --
476 l_debug_on BOOLEAN;
477 --
478 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
479 --
480 BEGIN
481
482 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
483 'START',
484 'Start of procedure INSERT_ROW, input parameters:
485 source_code='||p_source_code||
486 ', source_line_id='||p_source_line_id||
487 ', source_header_id='||p_source_header_id||
488 ', inventory_item='||p_inventory_item||
489 ', subinventory_code='||p_subinventory_code||
490 ', transaction_quantity='||p_trx_quantity||
491 ', transaction_date='||p_transaction_date||
492 ', organization_id='||p_organization_id);
493 wsh_server_debug.debug_message(
494 ', dsp_segment1='||p_dsp_segment1||
495 ', dsp_segment2='||p_dsp_segment2||
496 ', dsp_segment3='||p_dsp_segment3||
497 ', transaction_source_type_id='||p_trx_source_type_id||
498 ', transaction_action_id='||p_trx_action_id||
499 ', transaction_type_id='||p_trx_type_id||
500 ', distribution_account_id='||p_distribution_account_id);
501 wsh_server_debug.debug_message(
502 ', dst_segment1='||p_dst_segment1||
503 ', dst_segment2='||p_dst_segment2||
504 ', dst_segment3='||p_dst_segment3||
505 ', dst_segment4='||p_dst_segment4||
506 ', dst_segment5='||p_dst_segment5||
507 ', dst_segment6='||p_dst_segment6||
508 ', dst_segment7='||p_dst_segment7||
509 ', dst_segment8='||p_dst_segment8||
510 ', dst_segment9='||p_dst_segment9||
511 ', dst_segment10='||p_dst_segment10);
512 wsh_server_debug.debug_message(
513 ', dst_segment11='||p_dst_segment11||
514 ', dst_segment12='||p_dst_segment12||
515 ', dst_segment13='||p_dst_segment13||
516 ', dst_segment14='||p_dst_segment14||
517 ', dst_segment15='||p_dst_segment15||
518 ', dst_segment16='||p_dst_segment16||
519 ', dst_segment17='||p_dst_segment17||
520 ', dst_segment18='||p_dst_segment18||
521 ', dst_segment19='||p_dst_segment19||
522 ', dst_segment20='||p_dst_segment20);
523 wsh_server_debug.debug_message(
524 ', dst_segment21='||p_dst_segment21||
525 ', dst_segment22='||p_dst_segment22||
526 ', dst_segment23='||p_dst_segment23||
527 ', dst_segment24='||p_dst_segment24||
528 ', dst_segment25='||p_dst_segment25||
529 ', dst_segment26='||p_dst_segment26||
530 ', dst_segment27='||p_dst_segment27||
531 ', dst_segment28='||p_dst_segment28||
532 ', dst_segment29='||p_dst_segment29||
533 ', dst_segment30='||p_dst_segment30);
534 wsh_server_debug.debug_message(
535 ', transaction_reference='||p_trx_reference||
536 ', trx_source_line_id='||p_trx_source_line_id||
537 ', trx_source_delivery_id='||p_trx_source_delivery_id||
538 ', revision='||p_revision||
539 ', locator_id='||p_locator_id||
540 ', loc_segment1='||p_loc_segment1||
541 ', loc_segment2='||p_loc_segment2||
542 ', loc_segment3='||p_loc_segment3||
543 ', loc_segment4='||p_loc_segment4||
544 ', picking_line_id='||p_picking_line_id||
545 ', transfer_subinventory='||p_transfer_subinventory||
546 ', transfer_organization='||p_transfer_organization);
547 wsh_server_debug.debug_message(
548 ', ship_to_location_id='||p_ship_to_location_id||
549 ', requisition_line_id='||p_requisition_line_id||
550 ', transaction_uom='||p_trx_uom||
551 ', transaction_interface_id='||x_trx_interface_id||
552 ', demand_id='||p_demand_id||
553 ', shipment_number='||p_shipment_number||
554 ', expected_arrival_date='||p_expected_arrival_date||
555 ', encumbrance_account='||p_encumbrance_account||
556 ', encumbrance_amount='||p_encumbrance_amount||
557 ', movement_id='||p_movement_id);
558 wsh_server_debug.debug_message(
559 ', freight_code='||p_freight_code||
560 ', waybill_airbill='||p_waybill_airbill||
561 ', last_update_date='||p_last_update_date||
562 ', last_updated_by='||p_last_updated_by||
563 ', creation_date='||p_creation_date||
564 ', created_by='||p_created_by||
565 ', last_update_login='||p_last_update_login||
566 ', request_id='||p_request_id||
567 ', program_application_id='||p_program_application_id||
568 ', program_id='||p_program_id||
569 ', program_update_date='||p_program_update_date);
570 wsh_server_debug.debug_message(
571 ', process_flag='||p_process_flag||
572 ', transaction_mode='||p_trx_mode||
573 ', lock_flag='||p_lock_flag||
574 ', transaction_header_id='||p_trx_header_id||
575 ', acct_period_id='||p_acct_period_id||
576 ', transaction_source_id='||p_trx_source_id||
577 ', required_flag='||p_required_flag||
578 ', currency_code='||p_currency_code||
579 ', currency_conversion_type='||p_currency_conversion_type||
580 ', currency_conversion_date='||p_currency_conversion_date||
581 ', currency_conversion_rate='||p_currency_conversion_rate);
582 wsh_server_debug.debug_message(
583 ', project_id='||p_project_id||
584 ', task_id='||p_task_id||
585 ', validation_required='||p_validation_required||
586 ', item_segment1='||p_item_segment1||
587 ', item_segment2='||p_item_segment2||
588 ', item_segment3='||p_item_segment3||
589 ', item_segment4='||p_item_segment4||
590 ', item_segment5='||p_item_segment5||
591 ', item_segment6='||p_item_segment6||
592 ', item_segment7='||p_item_segment7||
593 ', item_segment8='||p_item_segment8||
594 ', item_segment9='||p_item_segment9);
595 wsh_server_debug.debug_message(
596 ', item_segment10='||p_item_segment10||
597 ', item_segment11='||p_item_segment11||
598 ', item_segment12='||p_item_segment12||
599 ', item_segment13='||p_item_segment13||
600 ', item_segment14='||p_item_segment14||
601 ', item_segment15='||p_item_segment15||
602 ', item_segment16='||p_item_segment16||
603 ', item_segment17='||p_item_segment17||
604 ', item_segment18='||p_item_segment18||
605 ', item_segment19='||p_item_segment19||
606 ', item_segment20='||p_item_segment20);
607 wsh_server_debug.debug_message(
608 ', primary_quantity='||p_primary_quantity||
609 ', loc_segment5='||p_loc_segment5||
610 ', loc_segment6='||p_loc_segment6||
611 ', loc_segment7='||p_loc_segment7||
612 ', loc_segment8='||p_loc_segment8||
613 ', loc_segment9='||p_loc_segment9||
614 ', loc_segment10='||p_loc_segment10||
615 ', loc_segment11='||p_loc_segment11||
616 ', loc_segment12='||p_loc_segment12||
617 ', loc_segment13='||p_loc_segment13||
618 ', loc_segment14='||p_loc_segment14||
619 ', loc_segment15='||p_loc_segment15);
620 wsh_server_debug.debug_message(
621 ', loc_segment16='||p_loc_segment16||
622 ', loc_segment17='||p_loc_segment17||
623 ', loc_segment18='||p_loc_segment18||
624 ', loc_segment19='||p_loc_segment19||
625 ', loc_segment20='||p_loc_segment20||
626 ', dsp_segment4='||p_dsp_segment4||
627 ', dsp_segment5='||p_dsp_segment5||
628 ', dsp_segment6='||p_dsp_segment6||
629 ', dsp_segment7='||p_dsp_segment7||
630 ', dsp_segment8='||p_dsp_segment8||
631 ', dsp_segment9='||p_dsp_segment9);
632 wsh_server_debug.debug_message(
633 ', dsp_segment10='||p_dsp_segment10||
634 ', dsp_segment11='||p_dsp_segment11||
635 ', dsp_segment12='||p_dsp_segment12||
636 ', dsp_segment13='||p_dsp_segment13||
637 ', dsp_segment14='||p_dsp_segment14||
638 ', dsp_segment15='||p_dsp_segment15||
639 ', dsp_segment16='||p_dsp_segment16||
640 ', dsp_segment17='||p_dsp_segment17||
641 ', dsp_segment18='||p_dsp_segment18||
642 ', dsp_segment19='||p_dsp_segment19);
643 wsh_server_debug.debug_message(
644 ', dsp_segment20='||p_dsp_segment20||
645 ', dsp_segment21='||p_dsp_segment21||
646 ', dsp_segment22='||p_dsp_segment22||
647 ', dsp_segment23='||p_dsp_segment23||
648 ', dsp_segment24='||p_dsp_segment24||
649 ', dsp_segment25='||p_dsp_segment25||
650 ', dsp_segment26='||p_dsp_segment26||
651 ', dsp_segment27='||p_dsp_segment27||
652 ', dsp_segment28='||p_dsp_segment28||
653 ', dsp_segment29='||p_dsp_segment29||
654 ', dsp_segment30='||p_dsp_segment30);
655 wsh_server_debug.debug_message(
656 ', transaction_source_name='||p_trx_source_name||
657 ', reason_id='||p_reason_id||
658 ', transaction_cost='||p_trx_cost||
659 ', ussgl_transaction_code='||p_ussgl_transaction_code||
660 ', wip_entity_type='||p_wip_entity_type||
661 ', schedule_id='||p_schedule_id||
662 ', employee_code='||p_employee_code||
663 ', department_id='||p_department_id||
664 ', schedule_update_code='||p_schedule_update_code||
665 ', setup_teardown_code='||p_setup_teardown_code);
666 wsh_server_debug.debug_message(
667 ', primary_switch='||p_primary_switch||
668 ', mrp_code='||p_mrp_code||
669 ', operation_seq_num='||p_operation_seq_num||
670 ', repetitive_line_id='||p_repetitive_line_id||
671 ', customer_ship_id='||p_customer_ship_id||
672 ', line_item_num='||p_line_item_num||
673 ', receiving_document='||p_receiving_document||
674 ', rcv_transaction_id='||p_rcv_transaction_id||
675 ', vendor_lot_number='||p_vendor_lot_number||
676 ', transfer_locator='||p_transfer_locator);
677 wsh_server_debug.debug_message(
678 ', xfer_loc_segment1='||p_xfer_loc_segment1||
679 ', xfer_loc_segment2='||p_xfer_loc_segment2||
680 ', xfer_loc_segment3='||p_xfer_loc_segment3||
681 ', xfer_loc_segment4='||p_xfer_loc_segment4||
682 ', xfer_loc_segment5='||p_xfer_loc_segment5||
683 ', xfer_loc_segment6='||p_xfer_loc_segment6||
684 ', xfer_loc_segment7='||p_xfer_loc_segment7||
685 ', xfer_loc_segment8='||p_xfer_loc_segment8||
686 ', xfer_loc_segment9='||p_xfer_loc_segment9||
687 ', xfer_loc_segment10='||p_xfer_loc_segment10);
688 wsh_server_debug.debug_message(
689 ', xfer_loc_segment11='||p_xfer_loc_segment11||
690 ', xfer_loc_segment12='||p_xfer_loc_segment12||
691 ', xfer_loc_segment13='||p_xfer_loc_segment13||
692 ', xfer_loc_segment14='||p_xfer_loc_segment14||
693 ', xfer_loc_segment15='||p_xfer_loc_segment15||
694 ', xfer_loc_segment16='||p_xfer_loc_segment16||
695 ', xfer_loc_segment17='||p_xfer_loc_segment17||
696 ', xfer_loc_segment18='||p_xfer_loc_segment18||
697 ', xfer_loc_segment19='||p_xfer_loc_segment19||
698 ', xfer_loc_segment20='||p_xfer_loc_segment20);
699 wsh_server_debug.debug_message(
700 ', transportation_cost='||p_transportation_cost||
701 ', transportation_account='||p_transportation_account||
702 ', transfer_cost='||p_transfer_cost||
703 ', containers='||p_containers||
704 ', new_average_cost='||p_new_average_cost||
705 ', value_change='||p_value_change||
706 ', percentage_change='||p_percentage_change||
707 ', demand_source_header_id='||p_demand_source_header_id||
708 ', demand_source_line='||p_demand_source_line||
709 ', demand_source_delivery='||p_demand_source_delivery);
710 wsh_server_debug.debug_message(
711 ', negative_req_flag='||p_negative_req_flag||
712 ', error_explanation='||p_error_explanation||
713 ', shippable_flag='||p_shippable_flag||
714 ', error_code='||p_error_code||
715 ', attribute_category='||p_attribute_category||
716 ', attribute1='||p_attribute1||
717 ', attribute2='||p_attribute2||
718 ', attribute3='||p_attribute3||
719 ', attribute4='||p_attribute4||
720 ', attribute5='||p_attribute5);
721 wsh_server_debug.debug_message(
722 ', attribute6='||p_attribute6||
723 ', attribute7='||p_attribute7||
724 ', attribute8='||p_attribute8||
725 ', attribute9='||p_attribute9||
726 ', attribute10='||p_attribute10||
727 ', attribute11='||p_attribute11||
728 ', attribute12='||p_attribute12||
729 ', attribute13='||p_attribute13||
730 ', attribute14='||p_attribute14||
731 ', attribute15='||p_attribute15);
732 wsh_server_debug.debug_message(
733 ', requisition_distribution_id='||p_requisition_distribution_id||
734 ', reservation_quantity='||p_reservation_quantity||
735 ', shipped_quantity='||p_shipped_quantity||
736 ', locator_name='||p_locator_name||
737 ', to_task_id='||p_to_task_id||
738 ', source_task_id='||p_source_task_id||
739 ', to_project_id='||p_to_project_id||
740 ', source_project_id='||p_source_project_id||
741 ', pa_expenditure_org_id='||p_pa_expenditure_org_id||
742 ', expenditure_type='||p_expenditure_type);
743 wsh_server_debug.debug_message(
744 ', final_completion_flag='||p_final_completion_flag||
745 ', transfer_percentage='||p_transfer_percentage||
746 ', transaction_sequence_id='||p_trx_sequence_id||
747 ', material_account='||p_material_account||
748 ', material_overhead_account='||p_material_overhead_account||
749 ', resource_account='||p_resource_account||
750 ', outside_processing_account='||p_outside_processing_account||
751 ', overhead_account='||p_overhead_account);
752 wsh_server_debug.debug_message(
753 ', bom_revision='||p_bom_revision||
754 ', routing_revision='||p_routing_revision||
755 ', bom_revision_date='||p_bom_revision_date||
756 ', routing_revision_date='||p_routing_revision_date||
757 ', alternate_bom_designator='||p_alternate_bom_designator||
758 ', alternate_routing_designator='||p_alternate_routing_designator||
759 ', accounting_class='||p_accounting_class||
760 ', demand_class='||p_demand_class);
761 wsh_server_debug.debug_message(
762 ', parent_id='||p_parent_id||
763 ', substitution_type_id='||p_substitution_type_id||
764 ', substitution_item_id='||p_substitution_item_id||
765 ', schedule_group='||p_schedule_group||
766 ', build_sequence='||p_build_sequence||
767 ', schedule_number='||p_schedule_number||
768 ', scheduled_flag='||p_scheduled_flag||
769 ', flow_schedule='||p_flow_schedule||
770 ', cost_group_id='||p_cost_group_id );
771 */
772
773 --
774 --
775 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
776 --
777 IF l_debug_on IS NULL
778 THEN
779 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
780 END IF;
781 --
782 IF l_debug_on THEN
783 WSH_DEBUG_SV.push(l_module_name);
784 --
785 WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
786 WSH_DEBUG_SV.log(l_module_name,'X_TRX_INTERFACE_ID',X_TRX_INTERFACE_ID);
787 WSH_DEBUG_SV.log(l_module_name,'P_TRX_HEADER_ID',P_TRX_HEADER_ID);
788 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_ID',P_TRX_SOURCE_ID);
789 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
790 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
791 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
792 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
793 WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY_CODE',P_SUBINVENTORY_CODE);
794 WSH_DEBUG_SV.log(l_module_name,'P_TRX_QUANTITY',P_TRX_QUANTITY);
795 WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_DATE',P_TRANSACTION_DATE);
796 WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
797 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT1',P_DSP_SEGMENT1);
798 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT2',P_DSP_SEGMENT2);
799 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT3',P_DSP_SEGMENT3);
800 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_TYPE_ID',P_TRX_SOURCE_TYPE_ID);
801 WSH_DEBUG_SV.log(l_module_name,'P_TRX_ACTION_ID',P_TRX_ACTION_ID);
802 WSH_DEBUG_SV.log(l_module_name,'P_TRX_TYPE_ID',P_TRX_TYPE_ID);
803 WSH_DEBUG_SV.log(l_module_name,'P_DISTRIBUTION_ACCOUNT_ID',P_DISTRIBUTION_ACCOUNT_ID);
804 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT1',P_DST_SEGMENT1);
805 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT2',P_DST_SEGMENT2);
806 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT3',P_DST_SEGMENT3);
807 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT4',P_DST_SEGMENT4);
808 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT5',P_DST_SEGMENT5);
809 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT6',P_DST_SEGMENT6);
810 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT7',P_DST_SEGMENT7);
811 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT8',P_DST_SEGMENT8);
812 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT9',P_DST_SEGMENT9);
813 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT10',P_DST_SEGMENT10);
814 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT11',P_DST_SEGMENT11);
815 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT12',P_DST_SEGMENT12);
816 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT13',P_DST_SEGMENT13);
817 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT14',P_DST_SEGMENT14);
818 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT15',P_DST_SEGMENT15);
819 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT16',P_DST_SEGMENT16);
820 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT17',P_DST_SEGMENT17);
821 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT18',P_DST_SEGMENT18);
822 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT19',P_DST_SEGMENT19);
823 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT20',P_DST_SEGMENT20);
824 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT21',P_DST_SEGMENT21);
825 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT22',P_DST_SEGMENT22);
826 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT23',P_DST_SEGMENT23);
827 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT24',P_DST_SEGMENT24);
828 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT25',P_DST_SEGMENT25);
829 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT26',P_DST_SEGMENT26);
830 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT27',P_DST_SEGMENT27);
831 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT28',P_DST_SEGMENT28);
832 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT29',P_DST_SEGMENT29);
833 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT30',P_DST_SEGMENT30);
834 WSH_DEBUG_SV.log(l_module_name,'P_TRX_REFERENCE',P_TRX_REFERENCE);
835 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_LINE_ID',P_TRX_SOURCE_LINE_ID);
836 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_DELIVERY_ID',P_TRX_SOURCE_DELIVERY_ID);
837 WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
838 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
839 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT1',P_LOC_SEGMENT1);
840 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT2',P_LOC_SEGMENT2);
841 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT3',P_LOC_SEGMENT3);
842 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT4',P_LOC_SEGMENT4);
843 WSH_DEBUG_SV.log(l_module_name,'P_PICKING_LINE_ID',P_PICKING_LINE_ID);
844 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_SUBINVENTORY',P_TRANSFER_SUBINVENTORY);
845 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_ORGANIZATION',P_TRANSFER_ORGANIZATION);
846 WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_LOCATION_ID',P_SHIP_TO_LOCATION_ID);
847 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_LINE_ID',P_REQUISITION_LINE_ID);
848 WSH_DEBUG_SV.log(l_module_name,'P_TRX_UOM',P_TRX_UOM);
849 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_ID',P_DEMAND_ID);
850 WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_NUMBER',P_SHIPMENT_NUMBER);
851 WSH_DEBUG_SV.log(l_module_name,'P_EXPECTED_ARRIVAL_DATE',P_EXPECTED_ARRIVAL_DATE);
852 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_ACCOUNT',P_ENCUMBRANCE_ACCOUNT);
853 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_AMOUNT',P_ENCUMBRANCE_AMOUNT);
854 WSH_DEBUG_SV.log(l_module_name,'P_MOVEMENT_ID',P_MOVEMENT_ID);
855 WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',P_FREIGHT_CODE);
856 WSH_DEBUG_SV.log(l_module_name,'P_WAYBILL_AIRBILL',P_WAYBILL_AIRBILL);
857 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
858 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
859 WSH_DEBUG_SV.log(l_module_name,'P_CREATION_DATE',P_CREATION_DATE);
860 WSH_DEBUG_SV.log(l_module_name,'P_CREATED_BY',P_CREATED_BY);
861 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
862 WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
863 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
864 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
865 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
866 WSH_DEBUG_SV.log(l_module_name,'P_PROCESS_FLAG',P_PROCESS_FLAG);
867 WSH_DEBUG_SV.log(l_module_name,'P_TRX_MODE',P_TRX_MODE);
868 WSH_DEBUG_SV.log(l_module_name,'P_LOCK_FLAG',P_LOCK_FLAG);
869 WSH_DEBUG_SV.log(l_module_name,'P_ACCT_PERIOD_ID',P_ACCT_PERIOD_ID);
870 WSH_DEBUG_SV.log(l_module_name,'P_REQUIRED_FLAG',P_REQUIRED_FLAG);
871 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
872 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_TYPE',P_CURRENCY_CONVERSION_TYPE);
873 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_DATE',P_CURRENCY_CONVERSION_DATE);
874 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_RATE',P_CURRENCY_CONVERSION_RATE);
875 WSH_DEBUG_SV.log(l_module_name,'P_PROJECT_ID',P_PROJECT_ID);
876 WSH_DEBUG_SV.log(l_module_name,'P_TASK_ID',P_TASK_ID);
877 WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_REQUIRED',P_VALIDATION_REQUIRED);
878 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT1',P_ITEM_SEGMENT1);
879 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT2',P_ITEM_SEGMENT2);
880 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT3',P_ITEM_SEGMENT3);
881 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT4',P_ITEM_SEGMENT4);
882 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT5',P_ITEM_SEGMENT5);
883 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT6',P_ITEM_SEGMENT6);
884 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT7',P_ITEM_SEGMENT7);
885 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT8',P_ITEM_SEGMENT8);
886 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT9',P_ITEM_SEGMENT9);
887 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT10',P_ITEM_SEGMENT10);
888 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT11',P_ITEM_SEGMENT11);
889 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT12',P_ITEM_SEGMENT12);
890 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT13',P_ITEM_SEGMENT13);
891 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT14',P_ITEM_SEGMENT14);
892 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT15',P_ITEM_SEGMENT15);
893 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT16',P_ITEM_SEGMENT16);
894 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT17',P_ITEM_SEGMENT17);
895 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT18',P_ITEM_SEGMENT18);
896 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT19',P_ITEM_SEGMENT19);
897 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT20',P_ITEM_SEGMENT20);
898 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_QUANTITY',P_PRIMARY_QUANTITY);
899 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT5',P_LOC_SEGMENT5);
900 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT6',P_LOC_SEGMENT6);
901 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT7',P_LOC_SEGMENT7);
902 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT8',P_LOC_SEGMENT8);
903 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT9',P_LOC_SEGMENT9);
904 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT10',P_LOC_SEGMENT10);
905 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT11',P_LOC_SEGMENT11);
906 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT12',P_LOC_SEGMENT12);
907 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT13',P_LOC_SEGMENT13);
908 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT14',P_LOC_SEGMENT14);
909 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT15',P_LOC_SEGMENT15);
910 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT16',P_LOC_SEGMENT16);
911 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT17',P_LOC_SEGMENT17);
912 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT18',P_LOC_SEGMENT18);
913 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT19',P_LOC_SEGMENT19);
914 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT20',P_LOC_SEGMENT20);
915 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT4',P_DSP_SEGMENT4);
916 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT5',P_DSP_SEGMENT5);
917 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT6',P_DSP_SEGMENT6);
918 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT7',P_DSP_SEGMENT7);
919 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT8',P_DSP_SEGMENT8);
920 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT9',P_DSP_SEGMENT9);
921 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT10',P_DSP_SEGMENT10);
922 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT11',P_DSP_SEGMENT11);
923 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT12',P_DSP_SEGMENT12);
924 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT13',P_DSP_SEGMENT13);
925 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT14',P_DSP_SEGMENT14);
926 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT15',P_DSP_SEGMENT15);
927 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT16',P_DSP_SEGMENT16);
928 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT17',P_DSP_SEGMENT17);
929 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT18',P_DSP_SEGMENT18);
930 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT19',P_DSP_SEGMENT19);
931 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT20',P_DSP_SEGMENT20);
932 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT21',P_DSP_SEGMENT21);
933 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT22',P_DSP_SEGMENT22);
934 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT23',P_DSP_SEGMENT23);
935 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT24',P_DSP_SEGMENT24);
936 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT25',P_DSP_SEGMENT25);
937 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT26',P_DSP_SEGMENT26);
938 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT27',P_DSP_SEGMENT27);
939 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT28',P_DSP_SEGMENT28);
940 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT29',P_DSP_SEGMENT29);
941 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT30',P_DSP_SEGMENT30);
942 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_NAME',P_TRX_SOURCE_NAME);
943 WSH_DEBUG_SV.log(l_module_name,'P_REASON_ID',P_REASON_ID);
944 WSH_DEBUG_SV.log(l_module_name,'P_TRX_COST',P_TRX_COST);
945 WSH_DEBUG_SV.log(l_module_name,'P_USSGL_TRANSACTION_CODE',P_USSGL_TRANSACTION_CODE);
946 WSH_DEBUG_SV.log(l_module_name,'P_WIP_ENTITY_TYPE',P_WIP_ENTITY_TYPE);
947 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_ID',P_SCHEDULE_ID);
948 WSH_DEBUG_SV.log(l_module_name,'P_EMPLOYEE_CODE',P_EMPLOYEE_CODE);
949 WSH_DEBUG_SV.log(l_module_name,'P_DEPARTMENT_ID',P_DEPARTMENT_ID);
950 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_UPDATE_CODE',P_SCHEDULE_UPDATE_CODE);
951 WSH_DEBUG_SV.log(l_module_name,'P_SETUP_TEARDOWN_CODE',P_SETUP_TEARDOWN_CODE);
952 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_SWITCH',P_PRIMARY_SWITCH);
953 WSH_DEBUG_SV.log(l_module_name,'P_MRP_CODE',P_MRP_CODE);
954 WSH_DEBUG_SV.log(l_module_name,'P_OPERATION_SEQ_NUM',P_OPERATION_SEQ_NUM);
955 WSH_DEBUG_SV.log(l_module_name,'P_REPETITIVE_LINE_ID',P_REPETITIVE_LINE_ID);
956 WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_SHIP_ID',P_CUSTOMER_SHIP_ID);
957 WSH_DEBUG_SV.log(l_module_name,'P_LINE_ITEM_NUM',P_LINE_ITEM_NUM);
958 WSH_DEBUG_SV.log(l_module_name,'P_RECEIVING_DOCUMENT',P_RECEIVING_DOCUMENT);
959 WSH_DEBUG_SV.log(l_module_name,'P_RCV_TRANSACTION_ID',P_RCV_TRANSACTION_ID);
960 WSH_DEBUG_SV.log(l_module_name,'P_VENDOR_LOT_NUMBER',P_VENDOR_LOT_NUMBER);
961 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_LOCATOR',P_TRANSFER_LOCATOR);
962 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT1',P_XFER_LOC_SEGMENT1);
963 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT2',P_XFER_LOC_SEGMENT2);
964 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT3',P_XFER_LOC_SEGMENT3);
965 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT4',P_XFER_LOC_SEGMENT4);
966 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT5',P_XFER_LOC_SEGMENT5);
967 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT6',P_XFER_LOC_SEGMENT6);
968 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT7',P_XFER_LOC_SEGMENT7);
969 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT8',P_XFER_LOC_SEGMENT8);
970 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT9',P_XFER_LOC_SEGMENT9);
971 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT10',P_XFER_LOC_SEGMENT10);
972 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT11',P_XFER_LOC_SEGMENT11);
973 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT12',P_XFER_LOC_SEGMENT12);
974 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT13',P_XFER_LOC_SEGMENT13);
975 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT14',P_XFER_LOC_SEGMENT14);
976 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT15',P_XFER_LOC_SEGMENT15);
977 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT16',P_XFER_LOC_SEGMENT16);
978 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT17',P_XFER_LOC_SEGMENT17);
979 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT18',P_XFER_LOC_SEGMENT18);
980 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT19',P_XFER_LOC_SEGMENT19);
981 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT20',P_XFER_LOC_SEGMENT20);
982 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_COST',P_TRANSPORTATION_COST);
983 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_ACCOUNT',P_TRANSPORTATION_ACCOUNT);
984 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_COST',P_TRANSFER_COST);
985 WSH_DEBUG_SV.log(l_module_name,'P_CONTAINERS',P_CONTAINERS);
986 WSH_DEBUG_SV.log(l_module_name,'P_NEW_AVERAGE_COST',P_NEW_AVERAGE_COST);
987 WSH_DEBUG_SV.log(l_module_name,'P_VALUE_CHANGE',P_VALUE_CHANGE);
988 WSH_DEBUG_SV.log(l_module_name,'P_PERCENTAGE_CHANGE',P_PERCENTAGE_CHANGE);
989 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_HEADER_ID',P_DEMAND_SOURCE_HEADER_ID);
990 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_LINE',P_DEMAND_SOURCE_LINE);
991 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_DELIVERY',P_DEMAND_SOURCE_DELIVERY);
992 WSH_DEBUG_SV.log(l_module_name,'P_NEGATIVE_REQ_FLAG',P_NEGATIVE_REQ_FLAG);
993 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_EXPLANATION',P_ERROR_EXPLANATION);
994 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPABLE_FLAG',P_SHIPPABLE_FLAG);
995 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_CODE',P_ERROR_CODE);
996 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
997 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
998 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
999 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
1000 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
1001 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
1002 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
1003 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
1004 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
1005 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
1006 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
1007 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
1008 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
1009 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
1010 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
1011 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
1012 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_DISTRIBUTION_ID',P_REQUISITION_DISTRIBUTION_ID);
1013 WSH_DEBUG_SV.log(l_module_name,'P_RESERVATION_QUANTITY',P_RESERVATION_QUANTITY);
1014 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_QUANTITY',P_SHIPPED_QUANTITY);
1015 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
1016 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_NAME',P_LOCATOR_NAME);
1017 WSH_DEBUG_SV.log(l_module_name,'P_TO_TASK_ID',P_TO_TASK_ID);
1018 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TASK_ID',P_SOURCE_TASK_ID);
1019 WSH_DEBUG_SV.log(l_module_name,'P_TO_PROJECT_ID',P_TO_PROJECT_ID);
1020 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_PROJECT_ID',P_SOURCE_PROJECT_ID);
1021 WSH_DEBUG_SV.log(l_module_name,'P_PA_EXPENDITURE_ORG_ID',P_PA_EXPENDITURE_ORG_ID);
1022 WSH_DEBUG_SV.log(l_module_name,'P_EXPENDITURE_TYPE',P_EXPENDITURE_TYPE);
1023 WSH_DEBUG_SV.log(l_module_name,'P_FINAL_COMPLETION_FLAG',P_FINAL_COMPLETION_FLAG);
1024 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_PERCENTAGE',P_TRANSFER_PERCENTAGE);
1025 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SEQUENCE_ID',P_TRX_SEQUENCE_ID);
1026 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_ACCOUNT',P_MATERIAL_ACCOUNT);
1027 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_OVERHEAD_ACCOUNT',P_MATERIAL_OVERHEAD_ACCOUNT);
1028 WSH_DEBUG_SV.log(l_module_name,'P_RESOURCE_ACCOUNT',P_RESOURCE_ACCOUNT);
1029 WSH_DEBUG_SV.log(l_module_name,'P_OUTSIDE_PROCESSING_ACCOUNT',P_OUTSIDE_PROCESSING_ACCOUNT);
1030 WSH_DEBUG_SV.log(l_module_name,'P_OVERHEAD_ACCOUNT',P_OVERHEAD_ACCOUNT);
1031 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION',P_BOM_REVISION);
1032 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION',P_ROUTING_REVISION);
1033 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION_DATE',P_BOM_REVISION_DATE);
1034 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION_DATE',P_ROUTING_REVISION_DATE);
1035 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_BOM_DESIGNATOR',P_ALTERNATE_BOM_DESIGNATOR);
1036 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_ROUTING_DESIGNATOR',P_ALTERNATE_ROUTING_DESIGNATOR);
1037 WSH_DEBUG_SV.log(l_module_name,'P_ACCOUNTING_CLASS',P_ACCOUNTING_CLASS);
1038 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_CLASS',P_DEMAND_CLASS);
1039 WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ID',P_PARENT_ID);
1040 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_TYPE_ID',P_SUBSTITUTION_TYPE_ID);
1041 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_ITEM_ID',P_SUBSTITUTION_ITEM_ID);
1042 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_GROUP',P_SCHEDULE_GROUP);
1043 WSH_DEBUG_SV.log(l_module_name,'P_BUILD_SEQUENCE',P_BUILD_SEQUENCE);
1044 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_NUMBER',P_SCHEDULE_NUMBER);
1045 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULED_FLAG',P_SCHEDULED_FLAG);
1046 WSH_DEBUG_SV.log(l_module_name,'P_FLOW_SCHEDULE',P_FLOW_SCHEDULE);
1047 WSH_DEBUG_SV.log(l_module_name,'P_COST_GROUP_ID',P_COST_GROUP_ID);
1048 WSH_DEBUG_SV.log(l_module_name,'P_CONTENT_LPN_ID',P_CONTENT_LPN_ID);
1049 -- HW OPMCONV. Added debugging msgs
1050 WSH_DEBUG_SV.log(l_module_name,'P_SECONDARY_TRX_QUANTITY',P_SECONDARY_TRX_QUANTITY);
1051 WSH_DEBUG_SV.log(l_module_name,'p_secondary_uom_code',p_secondary_uom_code);
1052 END IF;
1053 --
1054 fnd_profile.get('USER_ID',g_userid);
1055
1056 -- Set interface id if necessary
1057 IF x_trx_interface_id IS NULL THEN
1058 OPEN get_interface_id;
1059 FETCH get_interface_id INTO x_trx_interface_id;
1060 CLOSE get_interface_id;
1061 END IF;
1062
1063 INSERT INTO mtl_transactions_interface (
1064 source_code,
1065 source_line_id,
1066 source_header_id,
1067 inventory_item_id,
1068 subinventory_code,
1069 transaction_quantity,
1070 transaction_date,
1071 organization_id,
1072 dsp_segment1,
1073 dsp_segment2,
1074 dsp_segment3,
1075 transaction_source_type_id,
1076 transaction_action_id,
1077 transaction_type_id,
1078 distribution_account_id,
1079 dst_segment1,
1080 dst_segment2,
1081 dst_segment3,
1082 dst_segment4,
1083 dst_segment5,
1084 dst_segment6,
1085 dst_segment7,
1086 dst_segment8,
1087 dst_segment9,
1088 dst_segment10,
1089 dst_segment11,
1090 dst_segment12,
1091 dst_segment13,
1092 dst_segment14,
1093 dst_segment15,
1094 dst_segment16,
1095 dst_segment17,
1096 dst_segment18,
1097 dst_segment19,
1098 dst_segment20,
1099 dst_segment21,
1100 dst_segment22,
1101 dst_segment23,
1102 dst_segment24,
1103 dst_segment25,
1104 dst_segment26,
1105 dst_segment27,
1106 dst_segment28,
1107 dst_segment29,
1108 dst_segment30,
1109 transaction_reference,
1110 trx_source_line_id,
1111 trx_source_delivery_id,
1112 revision,
1113 locator_id,
1114 loc_segment1,
1115 loc_segment2,
1116 loc_segment3,
1117 loc_segment4,
1118 picking_line_id,
1119 transfer_subinventory,
1120 transfer_organization,
1121 ship_to_location_id,
1122 requisition_line_id,
1123 transaction_uom,
1124 transaction_interface_id,
1125 demand_id,
1126 shipment_number,
1127 expected_arrival_date,
1128 encumbrance_account,
1129 encumbrance_amount,
1130 movement_id,
1131 freight_code,
1132 waybill_airbill,
1133 last_update_date,
1134 last_updated_by,
1135 creation_date,
1136 created_by,
1137 last_update_login,
1138 request_id,
1139 program_application_id,
1140 program_id,
1141 program_update_date,
1142 process_flag,
1143 transaction_mode,
1144 lock_flag,
1145 transaction_header_id,
1146 acct_period_id,
1147 transaction_source_id,
1148 required_flag,
1149 currency_code,
1150 currency_conversion_type,
1151 currency_conversion_date,
1152 currency_conversion_rate,
1153 project_id,
1154 task_id,
1155 validation_required,
1156 item_segment1,
1157 item_segment2,
1158 item_segment3,
1159 item_segment4,
1160 item_segment5,
1161 item_segment6,
1162 item_segment7,
1163 item_segment8,
1164 item_segment9,
1165 item_segment10,
1166 item_segment11,
1167 item_segment12,
1168 item_segment13,
1169 item_segment14,
1170 item_segment15,
1171 item_segment16,
1172 item_segment17,
1173 item_segment18,
1174 item_segment19,
1175 item_segment20,
1176 primary_quantity,
1177 loc_segment5,
1178 loc_segment6,
1179 loc_segment7,
1180 loc_segment8,
1181 loc_segment9,
1182 loc_segment10,
1183 loc_segment11,
1184 loc_segment12,
1185 loc_segment13,
1186 loc_segment14,
1187 loc_segment15,
1188 loc_segment16,
1189 loc_segment17,
1190 loc_segment18,
1191 loc_segment19,
1192 loc_segment20,
1193 dsp_segment4,
1194 dsp_segment5,
1195 dsp_segment6,
1196 dsp_segment7,
1197 dsp_segment8,
1198 dsp_segment9,
1199 dsp_segment10,
1200 dsp_segment11,
1201 dsp_segment12,
1202 dsp_segment13,
1203 dsp_segment14,
1204 dsp_segment15,
1205 dsp_segment16,
1206 dsp_segment17,
1207 dsp_segment18,
1208 dsp_segment19,
1209 dsp_segment20,
1210 dsp_segment21,
1211 dsp_segment22,
1212 dsp_segment23,
1213 dsp_segment24,
1214 dsp_segment25,
1215 dsp_segment26,
1216 dsp_segment27,
1217 dsp_segment28,
1218 dsp_segment29,
1219 dsp_segment30,
1220 transaction_source_name,
1221 reason_id,
1222 transaction_cost,
1223 ussgl_transaction_code,
1224 wip_entity_type,
1225 schedule_id,
1226 employee_code,
1227 department_id,
1228 schedule_update_code,
1229 setup_teardown_code,
1230 primary_switch,
1231 mrp_code,
1232 operation_seq_num,
1233 repetitive_line_id,
1234 customer_ship_id,
1235 line_item_num,
1236 receiving_document,
1237 rcv_transaction_id,
1238 vendor_lot_number,
1239 transfer_locator,
1240 xfer_loc_segment1,
1241 xfer_loc_segment2,
1242 xfer_loc_segment3,
1243 xfer_loc_segment4,
1244 xfer_loc_segment5,
1245 xfer_loc_segment6,
1246 xfer_loc_segment7,
1247 xfer_loc_segment8,
1248 xfer_loc_segment9,
1249 xfer_loc_segment10,
1250 xfer_loc_segment11,
1251 xfer_loc_segment12,
1252 xfer_loc_segment13,
1253 xfer_loc_segment14,
1254 xfer_loc_segment15,
1255 xfer_loc_segment16,
1256 xfer_loc_segment17,
1257 xfer_loc_segment18,
1258 xfer_loc_segment19,
1259 xfer_loc_segment20,
1260 transportation_cost,
1261 transportation_account,
1262 transfer_cost,
1263 containers,
1264 new_average_cost,
1265 value_change,
1266 percentage_change,
1267 demand_source_header_id,
1268 demand_source_line,
1269 demand_source_delivery,
1270 negative_req_flag,
1271 error_explanation,
1272 shippable_flag,
1273 error_code,
1274 attribute_category,
1275 attribute1,
1276 attribute2,
1277 attribute3,
1278 attribute4,
1279 attribute5,
1280 attribute6,
1281 attribute7,
1282 attribute8,
1283 attribute9,
1284 attribute10,
1285 attribute11,
1286 attribute12,
1287 attribute13,
1288 attribute14,
1289 attribute15,
1290 requisition_distribution_id,
1291 reservation_quantity,
1292 shipped_quantity,
1293 inventory_item,
1294 locator_name,
1295 to_task_id,
1296 source_task_id,
1297 to_project_id,
1298 source_project_id,
1299 pa_expenditure_org_id,
1300 expenditure_type,
1301 final_completion_flag,
1302 transfer_percentage,
1303 transaction_sequence_id,
1304 material_account,
1305 material_overhead_account,
1306 resource_account,
1307 outside_processing_account,
1308 overhead_account,
1309 bom_revision,
1310 routing_revision,
1311 bom_revision_date,
1312 routing_revision_date,
1313 alternate_bom_designator,
1314 alternate_routing_designator,
1315 accounting_class,
1316 demand_class,
1317 parent_id,
1318 substitution_type_id,
1319 substitution_item_id,
1320 schedule_group,
1321 build_sequence,
1322 schedule_number,
1323 scheduled_flag,
1324 flow_schedule,
1325 cost_group_id,
1326 content_lpn_id, /* Bug 1549125 */
1327 -- HW OPMCONV. Added secondary_qty and secondary_uom
1328 SECONDARY_TRANSACTION_QUANTITY,
1329 SECONDARY_UOM_CODE
1330 ) VALUES (
1331 p_source_code,
1332 p_source_line_id,
1333 p_source_header_id,
1334 p_inventory_item_id,
1335 p_subinventory_code,
1336 p_trx_quantity,
1337 p_transaction_date,
1338 p_organization_id,
1339 p_dsp_segment1,
1340 p_dsp_segment2,
1341 p_dsp_segment3,
1342 p_trx_source_type_id,
1343 p_trx_action_id,
1344 p_trx_type_id,
1345 p_distribution_account_id,
1346 p_dst_segment1,
1347 p_dst_segment2,
1348 p_dst_segment3,
1349 p_dst_segment4,
1350 p_dst_segment5,
1351 p_dst_segment6,
1352 p_dst_segment7,
1353 p_dst_segment8,
1354 p_dst_segment9,
1355 p_dst_segment10,
1356 p_dst_segment11,
1357 p_dst_segment12,
1358 p_dst_segment13,
1359 p_dst_segment14,
1360 p_dst_segment15,
1361 p_dst_segment16,
1362 p_dst_segment17,
1363 p_dst_segment18,
1364 p_dst_segment19,
1365 p_dst_segment20,
1366 p_dst_segment21,
1367 p_dst_segment22,
1368 p_dst_segment23,
1369 p_dst_segment24,
1370 p_dst_segment25,
1371 p_dst_segment26,
1372 p_dst_segment27,
1373 p_dst_segment28,
1374 p_dst_segment29,
1375 p_dst_segment30,
1376 p_trx_reference,
1377 p_trx_source_line_id,
1378 p_trx_source_delivery_id,
1379 p_revision,
1380 p_locator_id,
1381 p_loc_segment1,
1382 p_loc_segment2,
1383 p_loc_segment3,
1384 p_loc_segment4,
1385 p_picking_line_id,
1386 p_transfer_subinventory,
1387 p_transfer_organization,
1388 p_ship_to_location_id,
1389 p_requisition_line_id,
1390 p_trx_uom,
1391 x_trx_interface_id,
1392 p_demand_id,
1393 p_shipment_number,
1394 p_expected_arrival_date,
1395 p_encumbrance_account,
1396 p_encumbrance_amount,
1397 p_movement_id,
1398 p_freight_code,
1399 p_waybill_airbill, --Bug 7503285
1400 NVL(p_last_update_date,SYSDATE),
1401 NVL(p_last_updated_by,g_userid),
1402 NVL(p_creation_date,SYSDATE),
1403 NVL( p_created_by,g_userid),
1404 p_last_update_login,
1405 p_request_id,
1406 p_program_application_id,
1407 p_program_id,
1408 p_program_update_date,
1409 p_process_flag,
1410 p_trx_mode,
1411 p_lock_flag,
1412 p_trx_header_id,
1413 p_acct_period_id,
1414 p_trx_source_id,
1415 p_required_flag,
1416 p_currency_code,
1417 p_currency_conversion_type,
1418 p_currency_conversion_date,
1419 p_currency_conversion_rate,
1420 p_project_id,
1421 p_task_id,
1422 p_validation_required,
1423 p_item_segment1,
1424 p_item_segment2,
1425 p_item_segment3,
1426 p_item_segment4,
1427 p_item_segment5,
1428 p_item_segment6,
1429 p_item_segment7,
1430 p_item_segment8,
1431 p_item_segment9,
1432 p_item_segment10,
1433 p_item_segment11,
1434 p_item_segment12,
1435 p_item_segment13,
1436 p_item_segment14,
1437 p_item_segment15,
1438 p_item_segment16,
1439 p_item_segment17,
1440 p_item_segment18,
1441 p_item_segment19,
1442 p_item_segment20,
1443 p_primary_quantity,
1444 p_loc_segment5,
1445 p_loc_segment6,
1446 p_loc_segment7,
1447 p_loc_segment8,
1448 p_loc_segment9,
1449 p_loc_segment10,
1450 p_loc_segment11,
1451 p_loc_segment12,
1452 p_loc_segment13,
1453 p_loc_segment14,
1454 p_loc_segment15,
1455 p_loc_segment16,
1456 p_loc_segment17,
1457 p_loc_segment18,
1458 p_loc_segment19,
1459 p_loc_segment20,
1460 p_dsp_segment4,
1461 p_dsp_segment5,
1462 p_dsp_segment6,
1463 p_dsp_segment7,
1464 p_dsp_segment8,
1465 p_dsp_segment9,
1466 p_dsp_segment10,
1467 p_dsp_segment11,
1468 p_dsp_segment12,
1469 p_dsp_segment13,
1470 p_dsp_segment14,
1471 p_dsp_segment15,
1472 p_dsp_segment16,
1473 p_dsp_segment17,
1474 p_dsp_segment18,
1475 p_dsp_segment19,
1476 p_dsp_segment20,
1477 p_dsp_segment21,
1478 p_dsp_segment22,
1479 p_dsp_segment23,
1480 p_dsp_segment24,
1481 p_dsp_segment25,
1482 p_dsp_segment26,
1483 p_dsp_segment27,
1484 p_dsp_segment28,
1485 p_dsp_segment29,
1486 p_dsp_segment30,
1487 p_trx_source_name,
1488 p_reason_id,
1489 p_trx_cost,
1490 p_ussgl_transaction_code,
1491 p_wip_entity_type,
1492 p_schedule_id,
1493 p_employee_code,
1494 p_department_id,
1495 p_schedule_update_code,
1496 p_setup_teardown_code,
1497 p_primary_switch,
1498 p_mrp_code,
1499 p_operation_seq_num,
1500 p_repetitive_line_id,
1501 p_customer_ship_id,
1502 p_line_item_num,
1503 p_receiving_document,
1504 p_rcv_transaction_id,
1505 p_vendor_lot_number,
1506 p_transfer_locator,
1507 p_xfer_loc_segment1,
1508 p_xfer_loc_segment2,
1509 p_xfer_loc_segment3,
1510 p_xfer_loc_segment4,
1511 p_xfer_loc_segment5,
1512 p_xfer_loc_segment6,
1513 p_xfer_loc_segment7,
1514 p_xfer_loc_segment8,
1515 p_xfer_loc_segment9,
1516 p_xfer_loc_segment10,
1517 p_xfer_loc_segment11,
1518 p_xfer_loc_segment12,
1519 p_xfer_loc_segment13,
1520 p_xfer_loc_segment14,
1521 p_xfer_loc_segment15,
1522 p_xfer_loc_segment16,
1523 p_xfer_loc_segment17,
1524 p_xfer_loc_segment18,
1525 p_xfer_loc_segment19,
1526 p_xfer_loc_segment20,
1527 p_transportation_cost,
1528 p_transportation_account,
1529 p_transfer_cost,
1530 p_containers,
1531 p_new_average_cost,
1532 p_value_change,
1533 p_percentage_change,
1534 p_demand_source_header_id,
1535 p_demand_source_line,
1536 p_demand_source_delivery,
1537 p_negative_req_flag,
1538 p_error_explanation,
1539 p_shippable_flag,
1540 p_error_code,
1541 p_attribute_category,
1542 p_attribute1,
1543 p_attribute2,
1544 p_attribute3,
1545 p_attribute4,
1546 p_attribute5,
1547 p_attribute6,
1548 p_attribute7,
1549 p_attribute8,
1550 p_attribute9,
1551 p_attribute10,
1552 p_attribute11,
1553 p_attribute12,
1554 p_attribute13,
1555 p_attribute14,
1556 p_attribute15,
1557 p_requisition_distribution_id,
1558 p_reservation_quantity,
1559 p_shipped_quantity,
1560 p_inventory_item,
1561 p_locator_name,
1562 p_to_task_id,
1563 p_source_task_id,
1564 p_to_project_id,
1565 p_source_project_id,
1566 p_pa_expenditure_org_id,
1567 p_expenditure_type,
1568 p_final_completion_flag,
1569 p_transfer_percentage,
1570 p_trx_sequence_id,
1571 p_material_account,
1572 p_material_overhead_account,
1573 p_resource_account,
1574 p_outside_processing_account,
1575 p_overhead_account,
1576 p_bom_revision,
1577 p_routing_revision,
1578 p_bom_revision_date,
1579 p_routing_revision_date,
1580 p_alternate_bom_designator,
1581 p_alternate_routing_designator,
1582 p_accounting_class,
1583 p_demand_class,
1584 p_parent_id,
1585 p_substitution_type_id,
1586 p_substitution_item_id,
1587 p_schedule_group,
1588 p_build_sequence,
1589 p_schedule_number,
1590 p_scheduled_flag,
1591 p_flow_schedule,
1592 p_cost_group_id,
1593 p_content_lpn_id, -- Bug 1549125
1594 -- HW OPMCONV. Added secondary_qty and grade
1595 p_secondary_trx_quantity,
1596 p_secondary_uom_code
1597 );
1598 IF l_debug_on THEN
1599 WSH_DEBUG_SV.log(l_module_name,'Rows inserted',SQL%ROWCOUNT);
1600 END IF;
1601
1602 OPEN row_id;
1603
1604 FETCH row_id INTO x_rowid;
1605
1606 IF (row_id%NOTFOUND) then
1607 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1608 'END',
1609 'No rowid found. Raising NO_DATA_FOUND.');
1610 */
1611 CLOSE row_id;
1612 IF l_debug_on THEN
1613 WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');
1614 END IF;
1615 RAISE NO_DATA_FOUND;
1616 END IF;
1617
1618 CLOSE row_id;
1619
1620 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1621 'END',
1622 'End of procedure INSERT_ROW');
1623 */
1624 --
1625 IF l_debug_on THEN
1626 WSH_DEBUG_SV.pop(l_module_name);
1627 END IF;
1628 --
1629 END Insert_Row;
1630
1631 -- ===========================================================================
1632 --
1633 -- Name:
1634 --
1635 -- update_row
1636 --
1637 -- Description:
1638 --
1639 -- Called by the client to update a row in the
1640 -- MTL_TRANSACTIONS_INTERFACE table.
1641 --
1642 -- ===========================================================================
1643
1644 PROCEDURE Update_Row (
1645 x_rowid IN OUT NOCOPY VARCHAR2,
1646 p_trx_interface_id IN NUMBER,
1647 p_trx_header_id IN NUMBER,
1648 p_trx_source_id IN NUMBER,
1649 p_source_code IN VARCHAR2,
1650 p_source_line_id IN NUMBER,
1651 p_source_header_id IN NUMBER,
1652 p_inventory_item_id IN NUMBER,
1653 p_subinventory_code IN VARCHAR2,
1654 p_trx_quantity IN NUMBER,
1655 p_transaction_date IN DATE,
1656 p_organization_id IN NUMBER,
1657 p_dsp_segment1 IN VARCHAR2,
1658 p_dsp_segment2 IN VARCHAR2,
1659 p_dsp_segment3 IN VARCHAR2,
1660 p_trx_source_type_id IN NUMBER,
1661 p_trx_action_id IN NUMBER,
1662 p_trx_type_id IN NUMBER,
1663 p_distribution_account_id IN NUMBER,
1664 p_dst_segment1 IN VARCHAR2,
1665 p_dst_segment2 IN VARCHAR2,
1666 p_dst_segment3 IN VARCHAR2,
1667 p_dst_segment4 IN VARCHAR2,
1668 p_dst_segment5 IN VARCHAR2,
1669 p_dst_segment6 IN VARCHAR2,
1670 p_dst_segment7 IN VARCHAR2,
1671 p_dst_segment8 IN VARCHAR2,
1672 p_dst_segment9 IN VARCHAR2,
1673 p_dst_segment10 IN VARCHAR2,
1674 p_dst_segment11 IN VARCHAR2,
1675 p_dst_segment12 IN VARCHAR2,
1676 p_dst_segment13 IN VARCHAR2,
1677 p_dst_segment14 IN VARCHAR2,
1678 p_dst_segment15 IN VARCHAR2,
1679 p_dst_segment16 IN VARCHAR2,
1680 p_dst_segment17 IN VARCHAR2,
1681 p_dst_segment18 IN VARCHAR2,
1682 p_dst_segment19 IN VARCHAR2,
1683 p_dst_segment20 IN VARCHAR2,
1684 p_dst_segment21 IN VARCHAR2,
1685 p_dst_segment22 IN VARCHAR2,
1686 p_dst_segment23 IN VARCHAR2,
1687 p_dst_segment24 IN VARCHAR2,
1688 p_dst_segment25 IN VARCHAR2,
1689 p_dst_segment26 IN VARCHAR2,
1690 p_dst_segment27 IN VARCHAR2,
1691 p_dst_segment28 IN VARCHAR2,
1692 p_dst_segment29 IN VARCHAR2,
1693 p_dst_segment30 IN VARCHAR2,
1694 p_trx_reference IN VARCHAR2,
1695 p_trx_source_line_id IN NUMBER,
1696 p_trx_source_delivery_id IN NUMBER,
1697 p_revision IN VARCHAR2,
1698 p_locator_id IN NUMBER,
1699 p_loc_segment1 IN VARCHAR2,
1700 p_loc_segment2 IN VARCHAR2,
1701 p_loc_segment3 IN VARCHAR2,
1702 p_loc_segment4 IN VARCHAR2,
1703 p_picking_line_id IN NUMBER,
1704 p_transfer_subinventory IN VARCHAR2,
1705 p_transfer_organization IN NUMBER,
1706 p_ship_to_location_id IN NUMBER,
1707 p_requisition_line_id IN NUMBER,
1708 p_trx_uom IN VARCHAR2,
1709 p_demand_id IN NUMBER,
1710 p_shipment_number IN VARCHAR2,
1711 p_expected_arrival_date IN DATE,
1712 p_encumbrance_account IN NUMBER,
1713 p_encumbrance_amount IN NUMBER,
1714 p_movement_id IN NUMBER,
1715 p_freight_code IN VARCHAR2,
1716 p_waybill_airbill IN VARCHAR2,
1717 p_last_update_date IN DATE,
1718 p_last_updated_by IN NUMBER,
1719 p_last_update_login IN NUMBER DEFAULT NULL,
1720 p_request_id IN NUMBER DEFAULT NULL,
1721 p_program_application_id IN NUMBER DEFAULT NULL,
1722 p_program_id IN NUMBER DEFAULT NULL,
1723 p_program_update_date IN DATE DEFAULT NULL,
1724 p_process_flag IN NUMBER DEFAULT 1,
1725 p_trx_mode IN NUMBER DEFAULT 3,
1726 p_lock_flag IN NUMBER DEFAULT 2,
1727 p_acct_period_id IN NUMBER DEFAULT NULL,
1728 p_required_flag IN VARCHAR2 DEFAULT NULL,
1729 p_currency_code IN VARCHAR2 DEFAULT NULL,
1730 p_currency_conversion_type IN VARCHAR2 DEFAULT NULL,
1731 p_currency_conversion_date IN DATE DEFAULT NULL,
1732 p_currency_conversion_rate IN NUMBER DEFAULT NULL,
1733 p_project_id IN NUMBER DEFAULT NULL,
1734 p_task_id IN NUMBER DEFAULT NULL,
1735 p_validation_required IN NUMBER DEFAULT NULL,
1736 p_item_segment1 IN VARCHAR2 DEFAULT NULL,
1737 p_item_segment2 IN VARCHAR2 DEFAULT NULL,
1738 p_item_segment3 IN VARCHAR2 DEFAULT NULL,
1739 p_item_segment4 IN VARCHAR2 DEFAULT NULL,
1740 p_item_segment5 IN VARCHAR2 DEFAULT NULL,
1741 p_item_segment6 IN VARCHAR2 DEFAULT NULL,
1742 p_item_segment7 IN VARCHAR2 DEFAULT NULL,
1743 p_item_segment8 IN VARCHAR2 DEFAULT NULL,
1744 p_item_segment9 IN VARCHAR2 DEFAULT NULL,
1745 p_item_segment10 IN VARCHAR2 DEFAULT NULL,
1746 p_item_segment11 IN VARCHAR2 DEFAULT NULL,
1747 p_item_segment12 IN VARCHAR2 DEFAULT NULL,
1748 p_item_segment13 IN VARCHAR2 DEFAULT NULL,
1749 p_item_segment14 IN VARCHAR2 DEFAULT NULL,
1750 p_item_segment15 IN VARCHAR2 DEFAULT NULL,
1751 p_item_segment16 IN VARCHAR2 DEFAULT NULL,
1752 p_item_segment17 IN VARCHAR2 DEFAULT NULL,
1753 p_item_segment18 IN VARCHAR2 DEFAULT NULL,
1754 p_item_segment19 IN VARCHAR2 DEFAULT NULL,
1755 p_item_segment20 IN VARCHAR2 DEFAULT NULL,
1756 p_primary_quantity IN NUMBER DEFAULT NULL,
1757 p_loc_segment5 IN VARCHAR2 DEFAULT NULL,
1758 p_loc_segment6 IN VARCHAR2 DEFAULT NULL,
1759 p_loc_segment7 IN VARCHAR2 DEFAULT NULL,
1760 p_loc_segment8 IN VARCHAR2 DEFAULT NULL,
1761 p_loc_segment9 IN VARCHAR2 DEFAULT NULL,
1762 p_loc_segment10 IN VARCHAR2 DEFAULT NULL,
1763 p_loc_segment11 IN VARCHAR2 DEFAULT NULL,
1764 p_loc_segment12 IN VARCHAR2 DEFAULT NULL,
1765 p_loc_segment13 IN VARCHAR2 DEFAULT NULL,
1766 p_loc_segment14 IN VARCHAR2 DEFAULT NULL,
1767 p_loc_segment15 IN VARCHAR2 DEFAULT NULL,
1768 p_loc_segment16 IN VARCHAR2 DEFAULT NULL,
1769 p_loc_segment17 IN VARCHAR2 DEFAULT NULL,
1770 p_loc_segment18 IN VARCHAR2 DEFAULT NULL,
1771 p_loc_segment19 IN VARCHAR2 DEFAULT NULL,
1772 p_loc_segment20 IN VARCHAR2 DEFAULT NULL,
1773 p_dsp_segment4 IN VARCHAR2 DEFAULT NULL,
1774 p_dsp_segment5 IN VARCHAR2 DEFAULT NULL,
1775 p_dsp_segment6 IN VARCHAR2 DEFAULT NULL,
1776 p_dsp_segment7 IN VARCHAR2 DEFAULT NULL,
1777 p_dsp_segment8 IN VARCHAR2 DEFAULT NULL,
1778 p_dsp_segment9 IN VARCHAR2 DEFAULT NULL,
1779 p_dsp_segment10 IN VARCHAR2 DEFAULT NULL,
1780 p_dsp_segment11 IN VARCHAR2 DEFAULT NULL,
1781 p_dsp_segment12 IN VARCHAR2 DEFAULT NULL,
1782 p_dsp_segment13 IN VARCHAR2 DEFAULT NULL,
1783 p_dsp_segment14 IN VARCHAR2 DEFAULT NULL,
1784 p_dsp_segment15 IN VARCHAR2 DEFAULT NULL,
1785 p_dsp_segment16 IN VARCHAR2 DEFAULT NULL,
1786 p_dsp_segment17 IN VARCHAR2 DEFAULT NULL,
1787 p_dsp_segment18 IN VARCHAR2 DEFAULT NULL,
1788 p_dsp_segment19 IN VARCHAR2 DEFAULT NULL,
1789 p_dsp_segment20 IN VARCHAR2 DEFAULT NULL,
1790 p_dsp_segment21 IN VARCHAR2 DEFAULT NULL,
1791 p_dsp_segment22 IN VARCHAR2 DEFAULT NULL,
1792 p_dsp_segment23 IN VARCHAR2 DEFAULT NULL,
1793 p_dsp_segment24 IN VARCHAR2 DEFAULT NULL,
1794 p_dsp_segment25 IN VARCHAR2 DEFAULT NULL,
1795 p_dsp_segment26 IN VARCHAR2 DEFAULT NULL,
1796 p_dsp_segment27 IN VARCHAR2 DEFAULT NULL,
1797 p_dsp_segment28 IN VARCHAR2 DEFAULT NULL,
1798 p_dsp_segment29 IN VARCHAR2 DEFAULT NULL,
1799 p_dsp_segment30 IN VARCHAR2 DEFAULT NULL,
1800 p_trx_source_name IN VARCHAR2 DEFAULT NULL,
1801 p_reason_id IN NUMBER DEFAULT NULL,
1802 p_trx_cost IN NUMBER DEFAULT NULL,
1803 p_ussgl_transaction_code IN VARCHAR2 DEFAULT NULL,
1804 p_wip_entity_type IN NUMBER DEFAULT NULL,
1805 p_schedule_id IN NUMBER DEFAULT NULL,
1806 p_employee_code IN VARCHAR2 DEFAULT NULL,
1807 p_department_id IN NUMBER DEFAULT NULL,
1808 p_schedule_update_code IN NUMBER DEFAULT NULL,
1809 p_setup_teardown_code IN NUMBER DEFAULT NULL,
1810 p_primary_switch IN NUMBER DEFAULT NULL,
1811 p_mrp_code IN NUMBER DEFAULT NULL,
1812 p_operation_seq_num IN NUMBER DEFAULT NULL,
1813 p_repetitive_line_id IN NUMBER DEFAULT NULL,
1814 p_customer_ship_id IN NUMBER DEFAULT NULL,
1815 p_line_item_num IN NUMBER DEFAULT NULL,
1816 p_receiving_document IN VARCHAR2 DEFAULT NULL,
1817 p_rcv_transaction_id IN NUMBER DEFAULT NULL,
1818 p_vendor_lot_number IN VARCHAR2 DEFAULT NULL,
1819 p_transfer_locator IN NUMBER DEFAULT NULL,
1820 p_xfer_loc_segment1 IN VARCHAR2 DEFAULT NULL,
1821 p_xfer_loc_segment2 IN VARCHAR2 DEFAULT NULL,
1822 p_xfer_loc_segment3 IN VARCHAR2 DEFAULT NULL,
1823 p_xfer_loc_segment4 IN VARCHAR2 DEFAULT NULL,
1824 p_xfer_loc_segment5 IN VARCHAR2 DEFAULT NULL,
1825 p_xfer_loc_segment6 IN VARCHAR2 DEFAULT NULL,
1826 p_xfer_loc_segment7 IN VARCHAR2 DEFAULT NULL,
1827 p_xfer_loc_segment8 IN VARCHAR2 DEFAULT NULL,
1828 p_xfer_loc_segment9 IN VARCHAR2 DEFAULT NULL,
1829 p_xfer_loc_segment10 IN VARCHAR2 DEFAULT NULL,
1830 p_xfer_loc_segment11 IN VARCHAR2 DEFAULT NULL,
1831 p_xfer_loc_segment12 IN VARCHAR2 DEFAULT NULL,
1832 p_xfer_loc_segment13 IN VARCHAR2 DEFAULT NULL,
1833 p_xfer_loc_segment14 IN VARCHAR2 DEFAULT NULL,
1834 p_xfer_loc_segment15 IN VARCHAR2 DEFAULT NULL,
1835 p_xfer_loc_segment16 IN VARCHAR2 DEFAULT NULL,
1836 p_xfer_loc_segment17 IN VARCHAR2 DEFAULT NULL,
1837 p_xfer_loc_segment18 IN VARCHAR2 DEFAULT NULL,
1838 p_xfer_loc_segment19 IN VARCHAR2 DEFAULT NULL,
1839 p_xfer_loc_segment20 IN VARCHAR2 DEFAULT NULL,
1840 p_transportation_cost IN NUMBER DEFAULT NULL,
1841 p_transportation_account IN NUMBER DEFAULT NULL,
1842 p_transfer_cost IN NUMBER DEFAULT NULL,
1843 p_containers IN NUMBER DEFAULT NULL,
1844 p_new_average_cost IN NUMBER DEFAULT NULL,
1845 p_value_change IN NUMBER DEFAULT NULL,
1846 p_percentage_change IN NUMBER DEFAULT NULL,
1847 p_demand_source_header_id IN NUMBER DEFAULT NULL,
1848 p_demand_source_line IN VARCHAR2 DEFAULT NULL,
1849 p_demand_source_delivery IN VARCHAR2 DEFAULT NULL,
1850 p_negative_req_flag IN NUMBER DEFAULT NULL,
1851 p_error_explanation IN VARCHAR2 DEFAULT NULL,
1852 p_shippable_flag IN VARCHAR2 DEFAULT NULL,
1853 p_error_code IN VARCHAR2 DEFAULT NULL,
1854 p_attribute_category IN VARCHAR2 DEFAULT NULL,
1855 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1856 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1857 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1858 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1859 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1860 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1861 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1862 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1863 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1864 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1865 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1866 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1867 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1868 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1869 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1870 p_requisition_distribution_id IN NUMBER DEFAULT NULL,
1871 p_reservation_quantity IN NUMBER DEFAULT NULL,
1872 p_shipped_quantity IN NUMBER DEFAULT NULL,
1873 p_inventory_item IN VARCHAR2 DEFAULT NULL,
1874 p_locator_name IN VARCHAR2 DEFAULT NULL,
1875 p_to_task_id IN NUMBER DEFAULT NULL,
1876 p_source_task_id IN NUMBER DEFAULT NULL,
1877 p_to_project_id IN NUMBER DEFAULT NULL,
1878 p_source_project_id IN NUMBER DEFAULT NULL,
1879 p_pa_expenditure_org_id IN NUMBER DEFAULT NULL,
1880 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
1881 p_final_completion_flag IN VARCHAR2 DEFAULT NULL,
1882 p_transfer_percentage IN NUMBER DEFAULT NULL,
1883 p_trx_sequence_id IN NUMBER DEFAULT NULL,
1884 p_material_account IN NUMBER DEFAULT NULL,
1885 p_material_overhead_account IN NUMBER DEFAULT NULL,
1886 p_resource_account IN NUMBER DEFAULT NULL,
1887 p_outside_processing_account IN NUMBER DEFAULT NULL,
1888 p_overhead_account IN NUMBER DEFAULT NULL,
1889 p_bom_revision IN VARCHAR2 DEFAULT NULL,
1890 p_routing_revision IN VARCHAR2 DEFAULT NULL,
1891 p_bom_revision_date IN DATE DEFAULT NULL,
1892 p_routing_revision_date IN DATE DEFAULT NULL,
1893 p_alternate_bom_designator IN VARCHAR2 DEFAULT NULL,
1894 p_alternate_routing_designator IN VARCHAR2 DEFAULT NULL,
1895 p_accounting_class IN VARCHAR2 DEFAULT NULL,
1896 p_demand_class IN VARCHAR2 DEFAULT NULL,
1897 p_parent_id IN NUMBER DEFAULT NULL,
1898 p_substitution_type_id IN NUMBER DEFAULT NULL,
1899 p_substitution_item_id IN NUMBER DEFAULT NULL,
1900 p_schedule_group IN NUMBER DEFAULT NULL,
1901 p_build_sequence IN NUMBER DEFAULT NULL,
1902 p_schedule_number IN VARCHAR2 DEFAULT NULL,
1903 p_scheduled_flag IN NUMBER DEFAULT NULL,
1904 p_flow_schedule IN VARCHAR2 DEFAULT NULL,
1905 p_cost_group_id IN NUMBER DEFAULT NULL,
1906 -- HW OPMCONV. Added p_secondary_trx_quantity
1907 -- and p_secondary_uom_code
1908 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
1909 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
1910 )
1911 IS
1912 --
1913 l_debug_on BOOLEAN;
1914 --
1915 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
1916 --
1917 BEGIN
1918 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1919 'START',
1920 'Start of procedure INSERT_ROW, input parameters:
1921 source_code='||p_source_code||
1922 ', source_line_id='||p_source_line_id||
1923 ', source_header_id='||p_source_header_id||
1924 ', inventory_item='||p_inventory_item||
1925 ', subinventory_code='||p_subinventory_code||
1926 ', transaction_quantity='||p_trx_quantity||
1927 ', transaction_date='||p_transaction_date||
1928 ', organization_id='||p_organization_id);
1929 wsh_server_debug.debug_message(
1930 ', dsp_segment1='||p_dsp_segment1||
1931 ', dsp_segment2='||p_dsp_segment2||
1932 ', dsp_segment3='||p_dsp_segment3||
1933 ', transaction_source_type_id='||p_trx_source_type_id||
1934 ', transaction_action_id='||p_trx_action_id||
1935 ', transaction_type_id='||p_trx_type_id||
1936 ', distribution_account_id='||p_distribution_account_id);
1937 wsh_server_debug.debug_message(
1938 ', dst_segment1='||p_dst_segment1||
1939 ', dst_segment2='||p_dst_segment2||
1940 ', dst_segment3='||p_dst_segment3||
1941 ', dst_segment4='||p_dst_segment4||
1942 ', dst_segment5='||p_dst_segment5||
1943 ', dst_segment6='||p_dst_segment6||
1944 ', dst_segment7='||p_dst_segment7||
1945 ', dst_segment8='||p_dst_segment8||
1946 ', dst_segment9='||p_dst_segment9||
1947 ', dst_segment10='||p_dst_segment10);
1948 wsh_server_debug.debug_message(
1949 ', dst_segment11='||p_dst_segment11||
1950 ', dst_segment12='||p_dst_segment12||
1951 ', dst_segment13='||p_dst_segment13||
1952 ', dst_segment14='||p_dst_segment14||
1953 ', dst_segment15='||p_dst_segment15||
1954 ', dst_segment16='||p_dst_segment16||
1955 ', dst_segment17='||p_dst_segment17||
1956 ', dst_segment18='||p_dst_segment18||
1957 ', dst_segment19='||p_dst_segment19||
1958 ', dst_segment20='||p_dst_segment20);
1959 wsh_server_debug.debug_message(
1960 ', dst_segment21='||p_dst_segment21||
1961 ', dst_segment22='||p_dst_segment22||
1962 ', dst_segment23='||p_dst_segment23||
1963 ', dst_segment24='||p_dst_segment24||
1964 ', dst_segment25='||p_dst_segment25||
1965 ', dst_segment26='||p_dst_segment26||
1966 ', dst_segment27='||p_dst_segment27||
1967 ', dst_segment28='||p_dst_segment28||
1968 ', dst_segment29='||p_dst_segment29||
1969 ', dst_segment30='||p_dst_segment30);
1970 wsh_server_debug.debug_message(
1971 ', transaction_reference='||p_trx_reference||
1972 ', trx_source_line_id='||p_trx_source_line_id||
1973 ', trx_source_delivery_id='||p_trx_source_delivery_id||
1974 ', revision='||p_revision||
1975 ', locator_id='||p_locator_id||
1976 ', loc_segment1='||p_loc_segment1||
1977 ', loc_segment2='||p_loc_segment2||
1978 ', loc_segment3='||p_loc_segment3||
1979 ', loc_segment4='||p_loc_segment4||
1980 ', picking_line_id='||p_picking_line_id||
1981 ', transfer_subinventory='||p_transfer_subinventory||
1982 ', transfer_organization='||p_transfer_organization);
1983 wsh_server_debug.debug_message(
1984 ', ship_to_location_id='||p_ship_to_location_id||
1985 ', requisition_line_id='||p_requisition_line_id||
1986 ', transaction_uom='||p_trx_uom||
1987 ', transaction_interface_id='||p_trx_interface_id||
1988 ', demand_id='||p_demand_id||
1989 ', shipment_number='||p_shipment_number||
1990 ', expected_arrival_date='||p_expected_arrival_date||
1991 ', encumbrance_account='||p_encumbrance_account||
1992 ', encumbrance_amount='||p_encumbrance_amount||
1993 ', movement_id='||p_movement_id);
1994 wsh_server_debug.debug_message(
1995 ', freight_code='||p_freight_code||
1996 ', waybill_airbill='||p_waybill_airbill||
1997 ', last_update_date='||p_last_update_date||
1998 ', last_updated_by='||p_last_updated_by||
1999 ', last_update_login='||p_last_update_login||
2000 ', request_id='||p_request_id||
2001 ', program_application_id='||p_program_application_id||
2002 ', program_id='||p_program_id||
2003 ', program_update_date='||p_program_update_date);
2004 wsh_server_debug.debug_message(
2005 ', process_flag='||p_process_flag||
2006 ', transaction_mode='||p_trx_mode||
2007 ', lock_flag='||p_lock_flag||
2008 ', transaction_header_id='||p_trx_header_id||
2009 ', acct_period_id='||p_acct_period_id||
2010 ', transaction_source_id='||p_trx_source_id||
2011 ', required_flag='||p_required_flag||
2012 ', currency_code='||p_currency_code||
2013 ', currency_conversion_type='||p_currency_conversion_type||
2014 ', currency_conversion_date='||p_currency_conversion_date||
2015 ', currency_conversion_rate='||p_currency_conversion_rate);
2016 wsh_server_debug.debug_message(
2017 ', project_id='||p_project_id||
2018 ', task_id='||p_task_id||
2019 ', validation_required='||p_validation_required||
2020 ', item_segment1='||p_item_segment1||
2021 ', item_segment2='||p_item_segment2||
2022 ', item_segment3='||p_item_segment3||
2023 ', item_segment4='||p_item_segment4||
2024 ', item_segment5='||p_item_segment5||
2025 ', item_segment6='||p_item_segment6||
2026 ', item_segment7='||p_item_segment7||
2027 ', item_segment8='||p_item_segment8||
2028 ', item_segment9='||p_item_segment9);
2029 wsh_server_debug.debug_message(
2030 ', item_segment10='||p_item_segment10||
2031 ', item_segment11='||p_item_segment11||
2032 ', item_segment12='||p_item_segment12||
2033 ', item_segment13='||p_item_segment13||
2034 ', item_segment14='||p_item_segment14||
2035 ', item_segment15='||p_item_segment15||
2036 ', item_segment16='||p_item_segment16||
2037 ', item_segment17='||p_item_segment17||
2038 ', item_segment18='||p_item_segment18||
2039 ', item_segment19='||p_item_segment19||
2040 ', item_segment20='||p_item_segment20);
2041 wsh_server_debug.debug_message(
2042 ', primary_quantity='||p_primary_quantity||
2043 ', loc_segment5='||p_loc_segment5||
2044 ', loc_segment6='||p_loc_segment6||
2045 ', loc_segment7='||p_loc_segment7||
2046 ', loc_segment8='||p_loc_segment8||
2047 ', loc_segment9='||p_loc_segment9||
2048 ', loc_segment10='||p_loc_segment10||
2049 ', loc_segment11='||p_loc_segment11||
2050 ', loc_segment12='||p_loc_segment12||
2051 ', loc_segment13='||p_loc_segment13||
2052 ', loc_segment14='||p_loc_segment14||
2053 ', loc_segment15='||p_loc_segment15);
2054 wsh_server_debug.debug_message(
2055 ', loc_segment16='||p_loc_segment16||
2056 ', loc_segment17='||p_loc_segment17||
2057 ', loc_segment18='||p_loc_segment18||
2058 ', loc_segment19='||p_loc_segment19||
2059 ', loc_segment20='||p_loc_segment20||
2060 ', dsp_segment4='||p_dsp_segment4||
2061 ', dsp_segment5='||p_dsp_segment5||
2062 ', dsp_segment6='||p_dsp_segment6||
2063 ', dsp_segment7='||p_dsp_segment7||
2064 ', dsp_segment8='||p_dsp_segment8||
2065 ', dsp_segment9='||p_dsp_segment9);
2066 wsh_server_debug.debug_message(
2067 ', dsp_segment10='||p_dsp_segment10||
2068 ', dsp_segment11='||p_dsp_segment11||
2069 ', dsp_segment12='||p_dsp_segment12||
2070 ', dsp_segment13='||p_dsp_segment13||
2071 ', dsp_segment14='||p_dsp_segment14||
2072 ', dsp_segment15='||p_dsp_segment15||
2073 ', dsp_segment16='||p_dsp_segment16||
2074 ', dsp_segment17='||p_dsp_segment17||
2075 ', dsp_segment18='||p_dsp_segment18||
2076 ', dsp_segment19='||p_dsp_segment19);
2077 wsh_server_debug.debug_message(
2078 ', dsp_segment20='||p_dsp_segment20||
2079 ', dsp_segment21='||p_dsp_segment21||
2080 ', dsp_segment22='||p_dsp_segment22||
2081 ', dsp_segment23='||p_dsp_segment23||
2082 ', dsp_segment24='||p_dsp_segment24||
2083 ', dsp_segment25='||p_dsp_segment25||
2084 ', dsp_segment26='||p_dsp_segment26||
2085 ', dsp_segment27='||p_dsp_segment27||
2086 ', dsp_segment28='||p_dsp_segment28||
2087 ', dsp_segment29='||p_dsp_segment29||
2088 ', dsp_segment30='||p_dsp_segment30);
2089 wsh_server_debug.debug_message(
2090 ', transaction_source_name='||p_trx_source_name||
2091 ', reason_id='||p_reason_id||
2092 ', transaction_cost='||p_trx_cost||
2093 ', ussgl_transaction_code='||p_ussgl_transaction_code||
2094 ', wip_entity_type='||p_wip_entity_type||
2095 ', schedule_id='||p_schedule_id||
2096 ', employee_code='||p_employee_code||
2097 ', department_id='||p_department_id||
2098 ', schedule_update_code='||p_schedule_update_code||
2099 ', setup_teardown_code='||p_setup_teardown_code);
2100 wsh_server_debug.debug_message(
2101 ', primary_switch='||p_primary_switch||
2102 ', mrp_code='||p_mrp_code||
2103 ', operation_seq_num='||p_operation_seq_num||
2104 ', repetitive_line_id='||p_repetitive_line_id||
2105 ', customer_ship_id='||p_customer_ship_id||
2106 ', line_item_num='||p_line_item_num||
2107 ', receiving_document='||p_receiving_document||
2108 ', rcv_transaction_id='||p_rcv_transaction_id||
2109 ', vendor_lot_number='||p_vendor_lot_number||
2110 ', transfer_locator='||p_transfer_locator);
2111 wsh_server_debug.debug_message(
2112 ', xfer_loc_segment1='||p_xfer_loc_segment1||
2113 ', xfer_loc_segment2='||p_xfer_loc_segment2||
2114 ', xfer_loc_segment3='||p_xfer_loc_segment3||
2115 ', xfer_loc_segment4='||p_xfer_loc_segment4||
2116 ', xfer_loc_segment5='||p_xfer_loc_segment5||
2117 ', xfer_loc_segment6='||p_xfer_loc_segment6||
2118 ', xfer_loc_segment7='||p_xfer_loc_segment7||
2119 ', xfer_loc_segment8='||p_xfer_loc_segment8||
2120 ', xfer_loc_segment9='||p_xfer_loc_segment9||
2121 ', xfer_loc_segment10='||p_xfer_loc_segment10);
2122 wsh_server_debug.debug_message(
2123 ', xfer_loc_segment11='||p_xfer_loc_segment11||
2124 ', xfer_loc_segment12='||p_xfer_loc_segment12||
2125 ', xfer_loc_segment13='||p_xfer_loc_segment13||
2126 ', xfer_loc_segment14='||p_xfer_loc_segment14||
2127 ', xfer_loc_segment15='||p_xfer_loc_segment15||
2128 ', xfer_loc_segment16='||p_xfer_loc_segment16||
2129 ', xfer_loc_segment17='||p_xfer_loc_segment17||
2130 ', xfer_loc_segment18='||p_xfer_loc_segment18||
2131 ', xfer_loc_segment19='||p_xfer_loc_segment19||
2132 ', xfer_loc_segment20='||p_xfer_loc_segment20);
2133 wsh_server_debug.debug_message(
2134 ', transportation_cost='||p_transportation_cost||
2135 ', transportation_account='||p_transportation_account||
2136 ', transfer_cost='||p_transfer_cost||
2137 ', containers='||p_containers||
2138 ', new_average_cost='||p_new_average_cost||
2139 ', value_change='||p_value_change||
2140 ', percentage_change='||p_percentage_change||
2141 ', demand_source_header_id='||p_demand_source_header_id||
2142 ', demand_source_line='||p_demand_source_line||
2143 ', demand_source_delivery='||p_demand_source_delivery);
2144 wsh_server_debug.debug_message(
2145 ', negative_req_flag='||p_negative_req_flag||
2146 ', error_explanation='||p_error_explanation||
2147 ', shippable_flag='||p_shippable_flag||
2148 ', error_code='||p_error_code||
2149 ', attribute_category='||p_attribute_category||
2150 ', attribute1='||p_attribute1||
2151 ', attribute2='||p_attribute2||
2152 ', attribute3='||p_attribute3||
2153 ', attribute4='||p_attribute4||
2154 ', attribute5='||p_attribute5);
2155 wsh_server_debug.debug_message(
2156 ', attribute6='||p_attribute6||
2157 ', attribute7='||p_attribute7||
2158 ', attribute8='||p_attribute8||
2159 ', attribute9='||p_attribute9||
2160 ', attribute10='||p_attribute10||
2161 ', attribute11='||p_attribute11||
2162 ', attribute12='||p_attribute12||
2163 ', attribute13='||p_attribute13||
2164 ', attribute14='||p_attribute14||
2165 ', attribute15='||p_attribute15);
2166 wsh_server_debug.debug_message(
2167 ', requisition_distribution_id='||p_requisition_distribution_id||
2168 ', reservation_quantity='||p_reservation_quantity||
2169 ', shipped_quantity='||p_shipped_quantity||
2170 ', locator_name='||p_locator_name||
2171 ', to_task_id='||p_to_task_id||
2172 ', source_task_id='||p_source_task_id||
2173 ', to_project_id='||p_to_project_id||
2174 ', source_project_id='||p_source_project_id||
2175 ', pa_expenditure_org_id='||p_pa_expenditure_org_id||
2176 ', expenditure_type='||p_expenditure_type);
2177 wsh_server_debug.debug_message(
2178 ', final_completion_flag='||p_final_completion_flag||
2179 ', transfer_percentage='||p_transfer_percentage||
2180 ', transaction_sequence_id='||p_trx_sequence_id||
2181 ', material_account='||p_material_account||
2182 ', material_overhead_account='||p_material_overhead_account||
2183 ', resource_account='||p_resource_account||
2184 ', outside_processing_account='||p_outside_processing_account||
2185 ', overhead_account='||p_overhead_account);
2186 wsh_server_debug.debug_message(
2187 ', bom_revision='||p_bom_revision||
2188 ', routing_revision='||p_routing_revision||
2189 ', bom_revision_date='||p_bom_revision_date||
2190 ', routing_revision_date='||p_routing_revision_date||
2191 ', alternate_bom_designator='||p_alternate_bom_designator||
2192 ', alternate_routing_designator='||p_alternate_routing_designator||
2193 ', accounting_class='||p_accounting_class||
2194 ', demand_class='||p_demand_class);
2195 wsh_server_debug.debug_message(
2196 ', parent_id='||p_parent_id||
2197 ', substitution_type_id='||p_substitution_type_id||
2198 ', substitution_item_id='||p_substitution_item_id||
2199 ', schedule_group='||p_schedule_group||
2200 ', build_sequence='||p_build_sequence||
2201 ', schedule_number='||p_schedule_number||
2202 ', scheduled_flag='||p_scheduled_flag||
2203 ', flow_schedule='||p_flow_schedule||
2204 ', cost_group_id='||p_cost_group_id );
2205 */
2206 --
2207 --
2208 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2209 --
2210 IF l_debug_on IS NULL
2211 THEN
2212 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2213 END IF;
2214 --
2215 IF l_debug_on THEN
2216 WSH_DEBUG_SV.push(l_module_name);
2217 --
2218 WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
2219 WSH_DEBUG_SV.log(l_module_name,'P_TRX_INTERFACE_ID',P_TRX_INTERFACE_ID);
2220 WSH_DEBUG_SV.log(l_module_name,'P_TRX_HEADER_ID',P_TRX_HEADER_ID);
2221 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_ID',P_TRX_SOURCE_ID);
2222 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
2223 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
2224 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
2225 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2226 WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY_CODE',P_SUBINVENTORY_CODE);
2227 WSH_DEBUG_SV.log(l_module_name,'P_TRX_QUANTITY',P_TRX_QUANTITY);
2228 WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_DATE',P_TRANSACTION_DATE);
2229 WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
2230 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT1',P_DSP_SEGMENT1);
2231 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT2',P_DSP_SEGMENT2);
2232 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT3',P_DSP_SEGMENT3);
2233 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_TYPE_ID',P_TRX_SOURCE_TYPE_ID);
2234 WSH_DEBUG_SV.log(l_module_name,'P_TRX_ACTION_ID',P_TRX_ACTION_ID);
2235 WSH_DEBUG_SV.log(l_module_name,'P_TRX_TYPE_ID',P_TRX_TYPE_ID);
2236 WSH_DEBUG_SV.log(l_module_name,'P_DISTRIBUTION_ACCOUNT_ID',P_DISTRIBUTION_ACCOUNT_ID);
2237 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT1',P_DST_SEGMENT1);
2238 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT2',P_DST_SEGMENT2);
2239 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT3',P_DST_SEGMENT3);
2240 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT4',P_DST_SEGMENT4);
2241 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT5',P_DST_SEGMENT5);
2242 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT6',P_DST_SEGMENT6);
2243 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT7',P_DST_SEGMENT7);
2244 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT8',P_DST_SEGMENT8);
2245 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT9',P_DST_SEGMENT9);
2246 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT10',P_DST_SEGMENT10);
2247 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT11',P_DST_SEGMENT11);
2248 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT12',P_DST_SEGMENT12);
2249 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT13',P_DST_SEGMENT13);
2250 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT14',P_DST_SEGMENT14);
2251 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT15',P_DST_SEGMENT15);
2252 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT16',P_DST_SEGMENT16);
2253 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT17',P_DST_SEGMENT17);
2254 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT18',P_DST_SEGMENT18);
2255 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT19',P_DST_SEGMENT19);
2256 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT20',P_DST_SEGMENT20);
2257 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT21',P_DST_SEGMENT21);
2258 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT22',P_DST_SEGMENT22);
2259 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT23',P_DST_SEGMENT23);
2260 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT24',P_DST_SEGMENT24);
2261 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT25',P_DST_SEGMENT25);
2262 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT26',P_DST_SEGMENT26);
2263 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT27',P_DST_SEGMENT27);
2264 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT28',P_DST_SEGMENT28);
2265 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT29',P_DST_SEGMENT29);
2266 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT30',P_DST_SEGMENT30);
2267 WSH_DEBUG_SV.log(l_module_name,'P_TRX_REFERENCE',P_TRX_REFERENCE);
2268 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_LINE_ID',P_TRX_SOURCE_LINE_ID);
2269 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_DELIVERY_ID',P_TRX_SOURCE_DELIVERY_ID);
2270 WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
2271 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
2272 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT1',P_LOC_SEGMENT1);
2273 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT2',P_LOC_SEGMENT2);
2274 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT3',P_LOC_SEGMENT3);
2275 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT4',P_LOC_SEGMENT4);
2276 WSH_DEBUG_SV.log(l_module_name,'P_PICKING_LINE_ID',P_PICKING_LINE_ID);
2277 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_SUBINVENTORY',P_TRANSFER_SUBINVENTORY);
2278 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_ORGANIZATION',P_TRANSFER_ORGANIZATION);
2279 WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_LOCATION_ID',P_SHIP_TO_LOCATION_ID);
2280 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_LINE_ID',P_REQUISITION_LINE_ID);
2281 WSH_DEBUG_SV.log(l_module_name,'P_TRX_UOM',P_TRX_UOM);
2282 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_ID',P_DEMAND_ID);
2283 WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_NUMBER',P_SHIPMENT_NUMBER);
2284 WSH_DEBUG_SV.log(l_module_name,'P_EXPECTED_ARRIVAL_DATE',P_EXPECTED_ARRIVAL_DATE);
2285 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_ACCOUNT',P_ENCUMBRANCE_ACCOUNT);
2286 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_AMOUNT',P_ENCUMBRANCE_AMOUNT);
2287 WSH_DEBUG_SV.log(l_module_name,'P_MOVEMENT_ID',P_MOVEMENT_ID);
2288 WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',P_FREIGHT_CODE);
2289 WSH_DEBUG_SV.log(l_module_name,'P_WAYBILL_AIRBILL',P_WAYBILL_AIRBILL);
2290 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_DATE',P_LAST_UPDATE_DATE);
2291 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATED_BY',P_LAST_UPDATED_BY);
2292 WSH_DEBUG_SV.log(l_module_name,'P_LAST_UPDATE_LOGIN',P_LAST_UPDATE_LOGIN);
2293 WSH_DEBUG_SV.log(l_module_name,'P_REQUEST_ID',P_REQUEST_ID);
2294 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_APPLICATION_ID',P_PROGRAM_APPLICATION_ID);
2295 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_ID',P_PROGRAM_ID);
2296 WSH_DEBUG_SV.log(l_module_name,'P_PROGRAM_UPDATE_DATE',P_PROGRAM_UPDATE_DATE);
2297 WSH_DEBUG_SV.log(l_module_name,'P_PROCESS_FLAG',P_PROCESS_FLAG);
2298 WSH_DEBUG_SV.log(l_module_name,'P_TRX_MODE',P_TRX_MODE);
2299 WSH_DEBUG_SV.log(l_module_name,'P_LOCK_FLAG',P_LOCK_FLAG);
2300 WSH_DEBUG_SV.log(l_module_name,'P_ACCT_PERIOD_ID',P_ACCT_PERIOD_ID);
2301 WSH_DEBUG_SV.log(l_module_name,'P_REQUIRED_FLAG',P_REQUIRED_FLAG);
2302 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
2303 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_TYPE',P_CURRENCY_CONVERSION_TYPE);
2304 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_DATE',P_CURRENCY_CONVERSION_DATE);
2305 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_RATE',P_CURRENCY_CONVERSION_RATE);
2306 WSH_DEBUG_SV.log(l_module_name,'P_PROJECT_ID',P_PROJECT_ID);
2307 WSH_DEBUG_SV.log(l_module_name,'P_TASK_ID',P_TASK_ID);
2308 WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_REQUIRED',P_VALIDATION_REQUIRED);
2309 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT1',P_ITEM_SEGMENT1);
2310 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT2',P_ITEM_SEGMENT2);
2311 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT3',P_ITEM_SEGMENT3);
2312 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT4',P_ITEM_SEGMENT4);
2313 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT5',P_ITEM_SEGMENT5);
2314 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT6',P_ITEM_SEGMENT6);
2315 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT7',P_ITEM_SEGMENT7);
2316 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT8',P_ITEM_SEGMENT8);
2317 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT9',P_ITEM_SEGMENT9);
2318 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT10',P_ITEM_SEGMENT10);
2319 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT11',P_ITEM_SEGMENT11);
2320 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT12',P_ITEM_SEGMENT12);
2321 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT13',P_ITEM_SEGMENT13);
2322 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT14',P_ITEM_SEGMENT14);
2323 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT15',P_ITEM_SEGMENT15);
2324 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT16',P_ITEM_SEGMENT16);
2325 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT17',P_ITEM_SEGMENT17);
2326 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT18',P_ITEM_SEGMENT18);
2327 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT19',P_ITEM_SEGMENT19);
2328 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT20',P_ITEM_SEGMENT20);
2329 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_QUANTITY',P_PRIMARY_QUANTITY);
2330 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT5',P_LOC_SEGMENT5);
2331 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT6',P_LOC_SEGMENT6);
2332 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT7',P_LOC_SEGMENT7);
2333 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT8',P_LOC_SEGMENT8);
2334 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT9',P_LOC_SEGMENT9);
2335 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT10',P_LOC_SEGMENT10);
2336 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT11',P_LOC_SEGMENT11);
2337 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT12',P_LOC_SEGMENT12);
2338 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT13',P_LOC_SEGMENT13);
2339 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT14',P_LOC_SEGMENT14);
2340 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT15',P_LOC_SEGMENT15);
2341 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT16',P_LOC_SEGMENT16);
2342 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT17',P_LOC_SEGMENT17);
2343 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT18',P_LOC_SEGMENT18);
2344 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT19',P_LOC_SEGMENT19);
2345 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT20',P_LOC_SEGMENT20);
2346 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT4',P_DSP_SEGMENT4);
2347 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT5',P_DSP_SEGMENT5);
2348 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT6',P_DSP_SEGMENT6);
2349 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT7',P_DSP_SEGMENT7);
2350 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT8',P_DSP_SEGMENT8);
2351 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT9',P_DSP_SEGMENT9);
2352 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT10',P_DSP_SEGMENT10);
2353 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT11',P_DSP_SEGMENT11);
2354 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT12',P_DSP_SEGMENT12);
2355 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT13',P_DSP_SEGMENT13);
2356 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT14',P_DSP_SEGMENT14);
2357 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT15',P_DSP_SEGMENT15);
2358 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT16',P_DSP_SEGMENT16);
2359 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT17',P_DSP_SEGMENT17);
2360 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT18',P_DSP_SEGMENT18);
2361 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT19',P_DSP_SEGMENT19);
2362 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT20',P_DSP_SEGMENT20);
2363 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT21',P_DSP_SEGMENT21);
2364 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT22',P_DSP_SEGMENT22);
2365 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT23',P_DSP_SEGMENT23);
2366 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT24',P_DSP_SEGMENT24);
2367 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT25',P_DSP_SEGMENT25);
2368 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT26',P_DSP_SEGMENT26);
2369 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT27',P_DSP_SEGMENT27);
2370 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT28',P_DSP_SEGMENT28);
2371 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT29',P_DSP_SEGMENT29);
2372 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT30',P_DSP_SEGMENT30);
2373 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_NAME',P_TRX_SOURCE_NAME);
2374 WSH_DEBUG_SV.log(l_module_name,'P_REASON_ID',P_REASON_ID);
2375 WSH_DEBUG_SV.log(l_module_name,'P_TRX_COST',P_TRX_COST);
2376 WSH_DEBUG_SV.log(l_module_name,'P_USSGL_TRANSACTION_CODE',P_USSGL_TRANSACTION_CODE);
2377 WSH_DEBUG_SV.log(l_module_name,'P_WIP_ENTITY_TYPE',P_WIP_ENTITY_TYPE);
2378 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_ID',P_SCHEDULE_ID);
2379 WSH_DEBUG_SV.log(l_module_name,'P_EMPLOYEE_CODE',P_EMPLOYEE_CODE);
2380 WSH_DEBUG_SV.log(l_module_name,'P_DEPARTMENT_ID',P_DEPARTMENT_ID);
2381 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_UPDATE_CODE',P_SCHEDULE_UPDATE_CODE);
2382 WSH_DEBUG_SV.log(l_module_name,'P_SETUP_TEARDOWN_CODE',P_SETUP_TEARDOWN_CODE);
2383 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_SWITCH',P_PRIMARY_SWITCH);
2384 WSH_DEBUG_SV.log(l_module_name,'P_MRP_CODE',P_MRP_CODE);
2385 WSH_DEBUG_SV.log(l_module_name,'P_OPERATION_SEQ_NUM',P_OPERATION_SEQ_NUM);
2386 WSH_DEBUG_SV.log(l_module_name,'P_REPETITIVE_LINE_ID',P_REPETITIVE_LINE_ID);
2387 WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_SHIP_ID',P_CUSTOMER_SHIP_ID);
2388 WSH_DEBUG_SV.log(l_module_name,'P_LINE_ITEM_NUM',P_LINE_ITEM_NUM);
2389 WSH_DEBUG_SV.log(l_module_name,'P_RECEIVING_DOCUMENT',P_RECEIVING_DOCUMENT);
2390 WSH_DEBUG_SV.log(l_module_name,'P_RCV_TRANSACTION_ID',P_RCV_TRANSACTION_ID);
2391 WSH_DEBUG_SV.log(l_module_name,'P_VENDOR_LOT_NUMBER',P_VENDOR_LOT_NUMBER);
2392 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_LOCATOR',P_TRANSFER_LOCATOR);
2393 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT1',P_XFER_LOC_SEGMENT1);
2394 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT2',P_XFER_LOC_SEGMENT2);
2395 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT3',P_XFER_LOC_SEGMENT3);
2396 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT4',P_XFER_LOC_SEGMENT4);
2397 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT5',P_XFER_LOC_SEGMENT5);
2398 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT6',P_XFER_LOC_SEGMENT6);
2399 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT7',P_XFER_LOC_SEGMENT7);
2400 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT8',P_XFER_LOC_SEGMENT8);
2401 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT9',P_XFER_LOC_SEGMENT9);
2402 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT10',P_XFER_LOC_SEGMENT10);
2403 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT11',P_XFER_LOC_SEGMENT11);
2404 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT12',P_XFER_LOC_SEGMENT12);
2405 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT13',P_XFER_LOC_SEGMENT13);
2406 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT14',P_XFER_LOC_SEGMENT14);
2407 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT15',P_XFER_LOC_SEGMENT15);
2408 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT16',P_XFER_LOC_SEGMENT16);
2409 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT17',P_XFER_LOC_SEGMENT17);
2410 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT18',P_XFER_LOC_SEGMENT18);
2411 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT19',P_XFER_LOC_SEGMENT19);
2412 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT20',P_XFER_LOC_SEGMENT20);
2413 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_COST',P_TRANSPORTATION_COST);
2414 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_ACCOUNT',P_TRANSPORTATION_ACCOUNT);
2415 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_COST',P_TRANSFER_COST);
2416 WSH_DEBUG_SV.log(l_module_name,'P_CONTAINERS',P_CONTAINERS);
2417 WSH_DEBUG_SV.log(l_module_name,'P_NEW_AVERAGE_COST',P_NEW_AVERAGE_COST);
2418 WSH_DEBUG_SV.log(l_module_name,'P_VALUE_CHANGE',P_VALUE_CHANGE);
2419 WSH_DEBUG_SV.log(l_module_name,'P_PERCENTAGE_CHANGE',P_PERCENTAGE_CHANGE);
2420 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_HEADER_ID',P_DEMAND_SOURCE_HEADER_ID);
2421 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_LINE',P_DEMAND_SOURCE_LINE);
2422 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_DELIVERY',P_DEMAND_SOURCE_DELIVERY);
2423 WSH_DEBUG_SV.log(l_module_name,'P_NEGATIVE_REQ_FLAG',P_NEGATIVE_REQ_FLAG);
2424 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_EXPLANATION',P_ERROR_EXPLANATION);
2425 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPABLE_FLAG',P_SHIPPABLE_FLAG);
2426 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_CODE',P_ERROR_CODE);
2427 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
2428 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
2429 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
2430 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
2431 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
2432 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
2433 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
2434 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
2435 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
2436 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
2437 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
2438 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
2439 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
2440 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
2441 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
2442 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
2443 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_DISTRIBUTION_ID',P_REQUISITION_DISTRIBUTION_ID);
2444 WSH_DEBUG_SV.log(l_module_name,'P_RESERVATION_QUANTITY',P_RESERVATION_QUANTITY);
2445 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_QUANTITY',P_SHIPPED_QUANTITY);
2446 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
2447 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_NAME',P_LOCATOR_NAME);
2448 WSH_DEBUG_SV.log(l_module_name,'P_TO_TASK_ID',P_TO_TASK_ID);
2449 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TASK_ID',P_SOURCE_TASK_ID);
2450 WSH_DEBUG_SV.log(l_module_name,'P_TO_PROJECT_ID',P_TO_PROJECT_ID);
2451 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_PROJECT_ID',P_SOURCE_PROJECT_ID);
2452 WSH_DEBUG_SV.log(l_module_name,'P_PA_EXPENDITURE_ORG_ID',P_PA_EXPENDITURE_ORG_ID);
2453 WSH_DEBUG_SV.log(l_module_name,'P_EXPENDITURE_TYPE',P_EXPENDITURE_TYPE);
2454 WSH_DEBUG_SV.log(l_module_name,'P_FINAL_COMPLETION_FLAG',P_FINAL_COMPLETION_FLAG);
2455 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_PERCENTAGE',P_TRANSFER_PERCENTAGE);
2456 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SEQUENCE_ID',P_TRX_SEQUENCE_ID);
2457 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_ACCOUNT',P_MATERIAL_ACCOUNT);
2458 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_OVERHEAD_ACCOUNT',P_MATERIAL_OVERHEAD_ACCOUNT);
2459 WSH_DEBUG_SV.log(l_module_name,'P_RESOURCE_ACCOUNT',P_RESOURCE_ACCOUNT);
2460 WSH_DEBUG_SV.log(l_module_name,'P_OUTSIDE_PROCESSING_ACCOUNT',P_OUTSIDE_PROCESSING_ACCOUNT);
2461 WSH_DEBUG_SV.log(l_module_name,'P_OVERHEAD_ACCOUNT',P_OVERHEAD_ACCOUNT);
2462 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION',P_BOM_REVISION);
2463 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION',P_ROUTING_REVISION);
2464 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION_DATE',P_BOM_REVISION_DATE);
2465 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION_DATE',P_ROUTING_REVISION_DATE);
2466 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_BOM_DESIGNATOR',P_ALTERNATE_BOM_DESIGNATOR);
2467 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_ROUTING_DESIGNATOR',P_ALTERNATE_ROUTING_DESIGNATOR);
2468 WSH_DEBUG_SV.log(l_module_name,'P_ACCOUNTING_CLASS',P_ACCOUNTING_CLASS);
2469 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_CLASS',P_DEMAND_CLASS);
2470 WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ID',P_PARENT_ID);
2471 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_TYPE_ID',P_SUBSTITUTION_TYPE_ID);
2472 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_ITEM_ID',P_SUBSTITUTION_ITEM_ID);
2473 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_GROUP',P_SCHEDULE_GROUP);
2474 WSH_DEBUG_SV.log(l_module_name,'P_BUILD_SEQUENCE',P_BUILD_SEQUENCE);
2475 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_NUMBER',P_SCHEDULE_NUMBER);
2476 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULED_FLAG',P_SCHEDULED_FLAG);
2477 WSH_DEBUG_SV.log(l_module_name,'P_FLOW_SCHEDULE',P_FLOW_SCHEDULE);
2478 WSH_DEBUG_SV.log(l_module_name,'P_COST_GROUP_ID',P_COST_GROUP_ID);
2479 -- HW OPMCONV. Added debugging msgs
2480 WSH_DEBUG_SV.log(l_module_name,'P_SECONDARY_TRX_QUANTITY',P_SECONDARY_TRX_QUANTITY);
2481 WSH_DEBUG_SV.log(l_module_name,'P_secondary_uom_code',p_secondary_uom_code);
2482 END IF;
2483 --
2484 fnd_profile.get('USER_ID',g_userid);
2485
2486 UPDATE mtl_transactions_interface SET
2487 source_code = p_source_code,
2488 source_line_id = p_source_line_id,
2489 source_header_id = p_source_header_id,
2490 inventory_item_id = p_inventory_item_id,
2491 subinventory_code = p_subinventory_code,
2492 transaction_quantity = p_trx_quantity,
2493 transaction_date = p_transaction_date,
2494 organization_id = p_organization_id,
2495 dsp_segment1 = p_dsp_segment1,
2496 dsp_segment2 = p_dsp_segment2,
2497 dsp_segment3 = p_dsp_segment3,
2498 transaction_source_type_id = p_trx_source_type_id,
2499 transaction_action_id = p_trx_action_id,
2500 transaction_type_id = p_trx_type_id,
2501 distribution_account_id = p_distribution_account_id,
2502 dst_segment1 = p_dst_segment1,
2503 dst_segment2 = p_dst_segment2,
2504 dst_segment3 = p_dst_segment3,
2505 dst_segment4 = p_dst_segment4,
2506 dst_segment5 = p_dst_segment5,
2507 dst_segment6 = p_dst_segment6,
2508 dst_segment7 = p_dst_segment7,
2509 dst_segment8 = p_dst_segment8,
2510 dst_segment9 = p_dst_segment9,
2511 dst_segment10 = p_dst_segment10,
2512 dst_segment11 = p_dst_segment11,
2513 dst_segment12 = p_dst_segment12,
2514 dst_segment13 = p_dst_segment13,
2515 dst_segment14 = p_dst_segment14,
2516 dst_segment15 = p_dst_segment15,
2517 dst_segment16 = p_dst_segment16,
2518 dst_segment17 = p_dst_segment17,
2519 dst_segment18 = p_dst_segment18,
2520 dst_segment19 = p_dst_segment19,
2521 dst_segment20 = p_dst_segment20,
2522 dst_segment21 = p_dst_segment21,
2523 dst_segment22 = p_dst_segment22,
2524 dst_segment23 = p_dst_segment23,
2525 dst_segment24 = p_dst_segment24,
2526 dst_segment25 = p_dst_segment25,
2527 dst_segment26 = p_dst_segment26,
2528 dst_segment27 = p_dst_segment27,
2529 dst_segment28 = p_dst_segment28,
2530 dst_segment29 = p_dst_segment29,
2531 dsT_Segment30 = p_dst_segment30,
2532 transaction_reference = p_trx_reference,
2533 trx_source_line_id = p_trx_source_line_id,
2534 trx_source_delivery_id = p_trx_source_delivery_id,
2535 revision = p_revision,
2536 locator_id = p_locator_id,
2537 loc_segment1 = p_loc_segment1,
2538 loc_segment2 = p_loc_segment2,
2539 loc_segment3 = p_loc_segment3,
2540 loc_segment4 = p_loc_segment4,
2541 picking_line_id = p_picking_line_id,
2542 transfer_subinventory = p_transfer_subinventory,
2543 transfer_organization = p_transfer_organization,
2544 ship_to_location_id = p_ship_to_location_id,
2545 requisition_line_id = p_requisition_line_id,
2546 transaction_uom = p_trx_uom,
2547 transaction_interface_id = p_trx_interface_id,
2548 demand_id = p_demand_id,
2549 shipment_number = p_shipment_number,
2550 expected_arrival_date = p_expected_arrival_date,
2551 encumbrance_account = p_encumbrance_account,
2552 encumbrance_amount = p_encumbrance_amount,
2553 movement_id = p_movement_id,
2554 freight_code = p_freight_code,
2555 waybill_airbill = p_waybill_airbill, --Bug 7503285
2556 last_update_date = NVL(p_last_update_date,SYSDATE),
2557 last_updated_by = NVL(p_last_updated_by,g_userid),
2558 last_update_login = p_last_update_login,
2559 request_id = p_request_id,
2560 program_application_id = p_program_application_id,
2561 program_id = p_program_id,
2562 program_update_date = p_program_update_date,
2563 process_flag = p_process_flag,
2564 transaction_mode = p_trx_mode,
2565 lock_flag = p_lock_flag,
2566 transaction_header_id = p_trx_header_id,
2567 acct_period_id = p_acct_period_id,
2568 transaction_source_id = p_trx_source_id,
2569 required_flag = p_required_flag,
2570 currency_code = p_currency_code,
2571 currency_conversion_type = p_currency_conversion_type,
2572 currency_conversion_date = p_currency_conversion_date,
2573 currency_conversion_rate = p_currency_conversion_rate,
2574 project_id = p_project_id,
2575 task_id = p_task_id,
2576 validation_required = p_validation_required,
2577 item_segment1 = p_item_segment1,
2578 item_segment2 = p_item_segment2,
2579 item_segment3 = p_item_segment3,
2580 item_segment4 = p_item_segment4,
2581 item_segment5 = p_item_segment5,
2582 item_segment6 = p_item_segment6,
2583 item_segment7 = p_item_segment7,
2584 item_segment8 = p_item_segment8,
2585 item_segment9 = p_item_segment9,
2586 item_segment10 = p_item_segment10,
2587 item_segment11 = p_item_segment11,
2588 item_segment12 = p_item_segment12,
2589 item_segment13 = p_item_segment13,
2590 item_segment14 = p_item_segment14,
2591 item_segment15 = p_item_segment15,
2592 item_segment16 = p_item_segment16,
2593 item_segment17 = p_item_segment17,
2594 item_segment18 = p_item_segment18,
2595 item_segment19 = p_item_segment19,
2596 item_segment20 = p_item_segment20,
2597 primary_quantity = p_primary_quantity,
2598 loc_segment5 = p_loc_segment5,
2599 loc_segment6 = p_loc_segment6,
2600 loc_segment7 = p_loc_segment7,
2601 loc_segment8 = p_loc_segment8,
2602 loc_segment9 = p_loc_segment9,
2603 loc_segment10 = p_loc_segment10,
2604 loc_segment11 = p_loc_segment11,
2605 loc_segment12 = p_loc_segment12,
2606 loc_segment13 = p_loc_segment13,
2607 loc_segment14 = p_loc_segment14,
2608 loc_segment15 = p_loc_segment15,
2609 loc_segment16 = p_loc_segment16,
2610 loc_segment17 = p_loc_segment17,
2611 loc_segment18 = p_loc_segment18,
2612 loc_segment19 = p_loc_segment19,
2613 loc_segment20 = p_loc_segment20,
2614 dsp_segment4 = p_dsp_segment4,
2615 dsp_segment5 = p_dsp_segment5,
2616 dsp_segment6 = p_dsp_segment6,
2617 dsp_segment7 = p_dsp_segment7,
2618 dsp_segment8 = p_dsp_segment8,
2619 dsp_segment9 = p_dsp_segment9,
2620 dsp_segment10 = p_dsp_segment10,
2621 dsp_segment11 = p_dsp_segment11,
2622 dsp_segment12 = p_dsp_segment12,
2623 dsp_segment13 = p_dsp_segment13,
2624 dsp_segment14 = p_dsp_segment14,
2625 dsp_segment15 = p_dsp_segment15,
2626 dsp_segment16 = p_dsp_segment16,
2627 dsp_segment17 = p_dsp_segment17,
2628 dsp_segment18 = p_dsp_segment18,
2629 dsp_segment19 = p_dsp_segment19,
2630 dsp_segment20 = p_dsp_segment20,
2631 dsp_segment21 = p_dsp_segment21,
2632 dsp_segment22 = p_dsp_segment22,
2633 dsp_segment23 = p_dsp_segment23,
2634 dsp_segment24 = p_dsp_segment24,
2635 dsp_segment25 = p_dsp_segment25,
2636 dsp_segment26 = p_dsp_segment26,
2637 dsp_segment27 = p_dsp_segment27,
2638 dsp_segment28 = p_dsp_segment28,
2639 dsp_segment29 = p_dsp_segment29,
2640 dsp_segment30 = p_dsp_segment30,
2641 transaction_source_name = p_trx_source_name,
2642 reason_id = p_reason_id,
2643 transaction_cost = p_trx_cost,
2644 ussgl_transaction_code = p_ussgl_transaction_code,
2645 wip_entity_type = p_wip_entity_type,
2646 schedule_id = p_schedule_id,
2647 employee_code = p_employee_code,
2648 department_id = p_department_id,
2649 schedule_update_code = p_schedule_update_code,
2650 setup_teardown_code = p_setup_teardown_code,
2651 primary_switch = p_primary_switch,
2652 mrp_code = p_mrp_code,
2653 operation_seq_num = p_operation_seq_num,
2654 repetitive_line_id = p_repetitive_line_id,
2655 customer_ship_id = p_customer_ship_id,
2656 line_item_num = p_line_item_num,
2657 receiving_document = p_receiving_document,
2658 rcv_transaction_id = p_rcv_transaction_id,
2659 vendor_lot_number = p_vendor_lot_number,
2660 transfer_locator = p_transfer_locator,
2661 xfer_loc_segment1 = p_xfer_loc_segment1,
2662 xfer_loc_segment2 = p_xfer_loc_segment2,
2663 xfer_loc_segment3 = p_xfer_loc_segment3,
2664 xfer_loc_segment4 = p_xfer_loc_segment4,
2665 xfer_loc_segment5 = p_xfer_loc_segment5,
2666 xfer_loc_segment6 = p_xfer_loc_segment6,
2667 xfer_loc_segment7 = p_xfer_loc_segment7,
2668 xfer_loc_segment8 = p_xfer_loc_segment8,
2669 xfer_loc_segment9 = p_xfer_loc_segment9,
2670 xfer_loc_segment10 = p_xfer_loc_segment10,
2671 xfer_loc_segment11 = p_xfer_loc_segment11,
2672 xfer_loc_segment12 = p_xfer_loc_segment12,
2673 xfer_loc_segment13 = p_xfer_loc_segment13,
2674 xfer_loc_segment14 = p_xfer_loc_segment14,
2675 xfer_loc_segment15 = p_xfer_loc_segment15,
2676 xfer_loc_segment16 = p_xfer_loc_segment16,
2677 xfer_loc_segment17 = p_xfer_loc_segment17,
2678 xfer_loc_segment18 = p_xfer_loc_segment18,
2679 xfer_loc_segment19 = p_xfer_loc_segment19,
2680 xfer_loc_segment20 = p_xfer_loc_segment20,
2681 transportation_cost = p_transportation_cost,
2682 transportation_account = p_transportation_account,
2683 transfer_cost = p_transfer_cost,
2684 containers = p_containers,
2685 new_average_cost = p_new_average_cost,
2686 value_change = p_value_change,
2687 percentage_change = p_percentage_change,
2688 demand_source_header_id = p_demand_source_header_id,
2689 demand_source_line = p_demand_source_line,
2690 demand_source_delivery = p_demand_source_delivery,
2691 negative_req_flag = p_negative_req_flag,
2692 error_explanation = p_error_explanation,
2693 shippable_flag = p_shippable_flag,
2694 error_code = p_error_code,
2695 attribute_category = p_attribute_category,
2696 attribute1 = p_attribute1,
2697 attribute2 = p_attribute2,
2698 attribute3 = p_attribute3,
2699 attribute4 = p_attribute4,
2700 attribute5 = p_attribute5,
2701 attribute6 = p_attribute6,
2702 attribute7 = p_attribute7,
2703 attribute8 = p_attribute8,
2704 attribute9 = p_attribute9,
2705 attribute10 = p_attribute10,
2706 attribute11 = p_attribute11,
2707 attribute12 = p_attribute12,
2708 attribute13 = p_attribute13,
2709 attribute14 = p_attribute14,
2710 attribute15 = p_attribute15,
2711 requisition_distribution_id = p_requisition_distribution_id,
2712 reservation_quantity = p_reservation_quantity,
2713 shipped_quantity = p_shipped_quantity,
2714 inventory_item = p_inventory_item,
2715 locator_name = p_locator_name,
2716 to_task_id = p_to_task_id,
2717 source_task_id = p_source_task_id,
2718 to_project_id = p_to_project_id,
2719 source_project_id = p_source_project_id,
2720 pa_expenditure_org_id = p_pa_expenditure_org_id,
2721 expenditure_type = p_expenditure_type,
2722 final_completion_flag = p_final_completion_flag,
2723 transfer_percentage = p_transfer_percentage,
2724 transaction_sequence_id = p_trx_sequence_id,
2725 material_account = p_material_account,
2726 material_overhead_account = p_material_overhead_account,
2727 resource_account = p_resource_account,
2728 outside_processing_account = p_outside_processing_account,
2729 overhead_account = p_overhead_account,
2730 bom_revision = p_bom_revision,
2731 routing_revision = p_routing_revision,
2732 bom_revision_date = p_bom_revision_date,
2733 routing_revision_date = p_routing_revision_date,
2734 alternate_bom_designator = p_alternate_bom_designator,
2735 alternate_routing_designator = p_alternate_routing_designator,
2736 accounting_class = p_accounting_class,
2737 demand_class = p_demand_class,
2738 parent_id = p_parent_id,
2739 substitution_type_id = p_substitution_type_id,
2740 substitution_item_id = p_substitution_item_id,
2741 schedule_group = p_schedule_group,
2742 build_sequence = p_build_sequence,
2743 schedule_number = p_schedule_number,
2744 scheduled_flag = p_scheduled_flag,
2745 flow_schedule = p_flow_schedule,
2746 cost_group_id = p_cost_group_id,
2747 -- HW OPMCONV. Added secondary_qty and secondary_uom
2748 SECONDARY_TRANSACTION_QUANTITY = p_secondary_trx_quantity,
2749 SECONDARY_UOM_CODE = p_secondary_uom_code
2750 WHERE rowid = x_rowid;
2751 IF l_debug_on THEN
2752 WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);
2753 END IF;
2754 IF (SQL%NOTFOUND) THEN
2755 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',
2756 'END',
2757 'No rows updated. Raising NO_DATA_FOUND.');
2758 */
2759 IF l_debug_on THEN
2760 WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');
2761 END IF;
2762 RAISE NO_DATA_FOUND;
2763 END IF;
2764
2765 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',
2766 'END',
2767 'End of procedure UPDATE_ROW');
2768 */
2769 --
2770 IF l_debug_on THEN
2771 WSH_DEBUG_SV.pop(l_module_name);
2772 END IF;
2773 --
2774 END Update_Row;
2775
2776 -- ===========================================================================
2777 --
2778 -- Name:
2779 --
2780 -- delete_row
2781 --
2782 -- Description:
2783 --
2784 -- Called by the client to delete a row in the
2785 -- MTL_TRANSACTIONS_INTERFACE table.
2786 --
2787 -- ===========================================================================
2788
2789 PROCEDURE Delete_Row (
2790 x_rowid IN OUT NOCOPY VARCHAR2 )
2791 IS
2792 l_trx_interface_id NUMBER;
2793
2794 --
2795 l_debug_on BOOLEAN;
2796 --
2797 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
2798 --
2799 BEGIN
2800 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2801 'START',
2802 'Start of procedure DELETE_ROW');
2803 */
2804
2805 -- get the column which may map to another table
2806 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2807 'START',
2808 'Select transaction_interface_id INTO l_trx_interface_id
2809 FROM mtl_transactions_interface');
2810 */
2811 --
2812 --
2813 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2814 --
2815 IF l_debug_on IS NULL
2816 THEN
2817 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2818 END IF;
2819 --
2820 IF l_debug_on THEN
2821 WSH_DEBUG_SV.push(l_module_name);
2822 --
2823 WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
2824 END IF;
2825 --
2826 SELECT transaction_interface_id INTO l_trx_interface_id
2827 FROM mtl_transactions_interface
2828 WHERE rowid = x_rowid;
2829
2830 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2831 'END',
2832 'Finish selecting transaction_header_id');
2833 */
2834 IF l_debug_on THEN
2835 WSH_DEBUG_SV.log(l_module_name,'l_trx_interface_id',l_trx_interface_id);
2836 END IF;
2837
2838 -- If column is not NULL, child table exists
2839 IF (l_trx_interface_id is NOT NULL) THEN
2840
2841 -- delete from mtl_serial_numbers_interface if there are mappings
2842 -- of mtl_transaction_lots_interface to the two other tables
2843 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844 'START',
2845 'Delete mtl_serial_numbers_interface,
2846 if it is one of two child tables');
2847 wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2848 'START',
2849 'interface_id ' || l_trx_interface_id);
2850 */
2851 DELETE FROM mtl_serial_numbers_interface
2852 WHERE transaction_interface_id IN
2853 ( SELECT serial_transaction_temp_id
2854 FROM mtl_transaction_lots_interface
2855 WHERE transaction_interface_id = l_trx_interface_id );
2856
2857 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2858 'END',
2859 'Finish delete mtl_serial_numbers_interface, if any');
2860 */
2861 -- delete from mtl_transaction_lots_interface, if there is mapping
2862 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2863 'START',
2864 'Delete mtl_transaction_lots_interface, if there is mapping');
2865 */
2866 IF l_debug_on THEN
2867 WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2868 END IF;
2869 DELETE FROM mtl_transaction_lots_interface
2870 WHERE transaction_interface_id = l_trx_interface_id;
2871
2872 IF l_debug_on THEN
2873 WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2874 END IF;
2875 IF (SQL%NOTFOUND) THEN
2876 -- there is no mapping to mtl_transaction_lots_interface
2877 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2878 'START',
2879 'Delete mtl_serial_numbers_interface -- only child');
2880 */
2881
2882 DELETE FROM mtl_serial_numbers_interface
2883 WHERE transaction_interface_id = l_trx_interface_id;
2884 IF l_debug_on THEN
2885 WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2886 END IF;
2887
2888 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2889 'END',
2890 'Finish delete mtl_serial_numbers_interface');
2891 */
2892 END IF;
2893 END IF;
2894
2895 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2896 'START',
2897 'Delete mtl_transactions_interface');
2898 */
2899 DELETE FROM mtl_transactions_interface WHERE rowid = x_rowid;
2900 IF l_debug_on THEN
2901 WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2902 END IF;
2903
2904 IF (SQL%NOTFOUND) THEN
2905 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2906 'END',
2907 'No rows deleted from mtl_transactions_interface.
2908 Raising NO_DATA_FOUND');
2909 */
2910 IF l_debug_on THEN
2911 WSH_DEBUG_SV.pop(l_module_name,'NO_DATA_FOUND');
2912 END IF;
2913 RAISE NO_DATA_FOUND;
2914 END IF;
2915
2916 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2917 'END',
2918 'End of procedure DELETE_ROW');
2919 */
2920 --
2921 IF l_debug_on THEN
2922 WSH_DEBUG_SV.pop(l_module_name);
2923 END IF;
2924 --
2925 END Delete_Row;
2926
2927 -- ===========================================================================
2928 --
2929 -- Name:
2930 --
2931 -- lock_row
2932 --
2933 -- Description:
2934 --
2935 -- Called by the client to lock a row in the
2936 -- MTL_TRANSACTION_LOTS_INTERFACE table.
2937 --
2938 -- ===========================================================================
2939
2940 PROCEDURE Lock_Row (
2941 x_rowid IN OUT NOCOPY VARCHAR2,
2942 p_trx_interface_id IN NUMBER,
2943 p_trx_header_id IN NUMBER,
2944 p_source_code IN VARCHAR2,
2945 p_source_line_id IN NUMBER,
2946 p_source_header_id IN NUMBER,
2947 p_process_flag IN NUMBER,
2948 p_validation_required IN NUMBER,
2949 p_transaction_mode IN NUMBER,
2950 p_lock_flag IN NUMBER,
2951 p_inventory_item_id IN NUMBER,
2952 p_item_segment1 IN VARCHAR2,
2953 p_item_segment2 IN VARCHAR2,
2954 p_item_segment3 IN VARCHAR2,
2955 p_item_segment4 IN VARCHAR2,
2956 p_item_segment5 IN VARCHAR2,
2957 p_item_segment6 IN VARCHAR2,
2958 p_item_segment7 IN VARCHAR2,
2959 p_item_segment8 IN VARCHAR2,
2960 p_item_segment9 IN VARCHAR2,
2961 p_item_segment10 IN VARCHAR2,
2962 p_item_segment11 IN VARCHAR2,
2963 p_item_segment12 IN VARCHAR2,
2964 p_item_segment13 IN VARCHAR2,
2965 p_item_segment14 IN VARCHAR2,
2966 p_item_segment15 IN VARCHAR2,
2967 p_item_segment16 IN VARCHAR2,
2968 p_item_segment17 IN VARCHAR2,
2969 p_item_segment18 IN VARCHAR2,
2970 p_item_segment19 IN VARCHAR2,
2971 p_item_segment20 IN VARCHAR2,
2972 p_revision IN VARCHAR2,
2973 p_organization_id IN NUMBER,
2974 p_transaction_quantity IN NUMBER,
2975 p_primary_quantity IN NUMBER,
2976 p_trx_uom IN VARCHAR2,
2977 p_trx_date IN DATE,
2978 p_acct_period_id IN NUMBER,
2979 p_subinventory_code IN VARCHAR2,
2980 p_locator_id IN NUMBER,
2981 p_loc_segment1 IN VARCHAR2,
2982 p_loc_segment2 IN VARCHAR2,
2983 p_loc_segment3 IN VARCHAR2,
2984 p_loc_segment4 IN VARCHAR2,
2985 p_loc_segment5 IN VARCHAR2,
2986 p_loc_segment6 IN VARCHAR2,
2987 p_loc_segment7 IN VARCHAR2,
2988 p_loc_segment8 IN VARCHAR2,
2989 p_loc_segment9 IN VARCHAR2,
2990 p_loc_segment10 IN VARCHAR2,
2991 p_loc_segment11 IN VARCHAR2,
2992 p_loc_segment12 IN VARCHAR2,
2993 p_loc_segment13 IN VARCHAR2,
2994 p_loc_segment14 IN VARCHAR2,
2995 p_loc_segment15 IN VARCHAR2,
2996 p_loc_segment16 IN VARCHAR2,
2997 p_loc_segment17 IN VARCHAR2,
2998 p_loc_segment18 IN VARCHAR2,
2999 p_loc_segment19 IN VARCHAR2,
3000 p_loc_segment20 IN VARCHAR2,
3001 p_trx_source_id IN NUMBER,
3002 p_dsp_segment1 IN VARCHAR2,
3003 p_dsp_segment2 IN VARCHAR2,
3004 p_dsp_segment3 IN VARCHAR2,
3005 p_dsp_segment4 IN VARCHAR2,
3006 p_dsp_segment5 IN VARCHAR2,
3007 p_dsp_segment6 IN VARCHAR2,
3008 p_dsp_segment7 IN VARCHAR2,
3009 p_dsp_segment8 IN VARCHAR2,
3010 p_dsp_segment9 IN VARCHAR2,
3011 p_dsp_segment10 IN VARCHAR2,
3012 p_dsp_segment11 IN VARCHAR2,
3013 p_dsp_segment12 IN VARCHAR2,
3014 p_dsp_segment13 IN VARCHAR2,
3015 p_dsp_segment14 IN VARCHAR2,
3016 p_dsp_segment15 IN VARCHAR2,
3017 p_dsp_segment16 IN VARCHAR2,
3018 p_dsp_segment17 IN VARCHAR2,
3019 p_dsp_segment18 IN VARCHAR2,
3020 p_dsp_segment19 IN VARCHAR2,
3021 p_dsp_segment20 IN VARCHAR2,
3022 p_dsp_segment21 IN VARCHAR2,
3023 p_dsp_segment22 IN VARCHAR2,
3024 p_dsp_segment23 IN VARCHAR2,
3025 p_dsp_segment24 IN VARCHAR2,
3026 p_dsp_segment25 IN VARCHAR2,
3027 p_dsp_segment26 IN VARCHAR2,
3028 p_dsp_segment27 IN VARCHAR2,
3029 p_dsp_segment28 IN VARCHAR2,
3030 p_dsp_segment29 IN VARCHAR2,
3031 p_dsp_segment30 IN VARCHAR2,
3032 p_trx_source_name IN VARCHAR2,
3033 p_trx_source_type_id IN NUMBER,
3034 p_trx_action_id IN NUMBER,
3035 p_trx_type_id IN NUMBER,
3036 p_reason_id IN NUMBER,
3037 p_trx_reference IN VARCHAR2,
3038 p_trx_cost IN NUMBER,
3039 p_distribution_acct_id IN NUMBER,
3040 p_dst_segment1 IN VARCHAR2,
3041 p_dst_segment2 IN VARCHAR2,
3042 p_dst_segment3 IN VARCHAR2,
3043 p_dst_segment4 IN VARCHAR2,
3044 p_dst_segment5 IN VARCHAR2,
3045 p_dst_segment6 IN VARCHAR2,
3046 p_dst_segment7 IN VARCHAR2,
3047 p_dst_segment8 IN VARCHAR2,
3048 p_dst_segment9 IN VARCHAR2,
3049 p_dst_segment10 IN VARCHAR2,
3050 p_dst_segment11 IN VARCHAR2,
3051 p_dst_segment12 IN VARCHAR2,
3052 p_dst_segment13 IN VARCHAR2,
3053 p_dst_segment14 IN VARCHAR2,
3054 p_dst_segment15 IN VARCHAR2,
3055 p_dst_segment16 IN VARCHAR2,
3056 p_dst_segment17 IN VARCHAR2,
3057 p_dst_segment18 IN VARCHAR2,
3058 p_dst_segment19 IN VARCHAR2,
3059 p_dst_segment20 IN VARCHAR2,
3060 p_dst_segment21 IN VARCHAR2,
3061 p_dst_segment22 IN VARCHAR2,
3062 p_dst_segment23 IN VARCHAR2,
3063 p_dst_segment24 IN VARCHAR2,
3064 p_dst_segment25 IN VARCHAR2,
3065 p_dst_segment26 IN VARCHAR2,
3066 p_dst_segment27 IN VARCHAR2,
3067 p_dst_segment28 IN VARCHAR2,
3068 p_dst_segment29 IN VARCHAR2,
3069 p_dst_segment30 IN VARCHAR2,
3070 p_requisition_line_id IN NUMBER,
3071 p_currency_code IN VARCHAR2,
3072 p_currency_conversion_date IN DATE,
3073 p_currency_conversion_type IN VARCHAR2,
3074 p_currency_conversion_rate IN NUMBER,
3075 p_ussgl_transaction_code IN VARCHAR2,
3076 p_wip_entity_type IN NUMBER,
3077 p_schedule_id IN NUMBER,
3078 p_employee_code IN VARCHAR2,
3079 p_department_id IN NUMBER,
3080 p_schedule_update_code IN NUMBER,
3081 p_setup_teardown_code IN NUMBER,
3082 p_primary_switch IN NUMBER,
3083 p_mrp_code IN NUMBER,
3084 p_operation_seq_num IN NUMBER,
3085 p_repetitive_line_id IN NUMBER,
3086 p_picking_line_id IN NUMBER,
3087 p_trx_source_line_id IN NUMBER,
3088 p_trx_source_delivery_id IN NUMBER,
3089 p_demand_id IN NUMBER,
3090 p_customer_ship_id IN NUMBER,
3091 p_line_item_num IN NUMBER,
3092 p_receiving_document IN VARCHAR2,
3093 p_rcv_transaction_id IN NUMBER,
3094 p_ship_to_location_id IN NUMBER,
3095 p_encumbrance_account IN NUMBER,
3096 p_encumbrance_amount IN NUMBER,
3097 p_vendor_lot_number IN VARCHAR2,
3098 p_transfer_subinventory IN VARCHAR2,
3099 p_transfer_organization IN NUMBER,
3100 p_transfer_locator IN NUMBER,
3101 p_xfer_loc_segment1 IN VARCHAR2,
3102 p_xfer_loc_segment2 IN VARCHAR2,
3103 p_xfer_loc_segment3 IN VARCHAR2,
3104 p_xfer_loc_segment4 IN VARCHAR2,
3105 p_xfer_loc_segment5 IN VARCHAR2,
3106 p_xfer_loc_segment6 IN VARCHAR2,
3107 p_xfer_loc_segment7 IN VARCHAR2,
3108 p_xfer_loc_segment8 IN VARCHAR2,
3109 p_xfer_loc_segment9 IN VARCHAR2,
3110 p_xfer_loc_segment10 IN VARCHAR2,
3111 p_xfer_loc_segment11 IN VARCHAR2,
3112 p_xfer_loc_segment12 IN VARCHAR2,
3113 p_xfer_loc_segment13 IN VARCHAR2,
3114 p_xfer_loc_segment14 IN VARCHAR2,
3115 p_xfer_loc_segment15 IN VARCHAR2,
3116 p_xfer_loc_segment16 IN VARCHAR2,
3117 p_xfer_loc_segment17 IN VARCHAR2,
3118 p_xfer_loc_segment18 IN VARCHAR2,
3119 p_xfer_loc_segment19 IN VARCHAR2,
3120 p_xfer_loc_segment20 IN VARCHAR2,
3121 p_shipment_number IN VARCHAR2,
3122 p_transportation_cost IN NUMBER,
3123 p_transportation_account IN NUMBER,
3124 p_transfer_cost IN NUMBER,
3125 p_freight_code IN VARCHAR2,
3126 p_containers IN NUMBER,
3127 p_waybill_airbill IN VARCHAR2,
3128 p_expected_arrival_date IN DATE,
3129 p_new_average_cost IN NUMBER,
3130 p_value_change IN NUMBER,
3131 p_percentage_change IN NUMBER,
3132 p_demand_source_header_id IN NUMBER,
3133 p_demand_source_line IN VARCHAR2,
3134 p_demand_source_delivery IN VARCHAR2,
3135 p_negative_req_flag IN NUMBER,
3136 p_error_explanation IN VARCHAR2,
3137 p_shippable_flag IN VARCHAR2,
3138 p_error_code IN VARCHAR2,
3139 p_required_flag IN VARCHAR2,
3140 p_attribute_category IN VARCHAR2,
3141 p_attribute1 IN VARCHAR2,
3142 p_attribute2 IN VARCHAR2,
3143 p_attribute3 IN VARCHAR2,
3144 p_attribute4 IN VARCHAR2,
3145 p_attribute5 IN VARCHAR2,
3146 p_attribute6 IN VARCHAR2,
3147 p_attribute7 IN VARCHAR2,
3148 p_attribute8 IN VARCHAR2,
3149 p_attribute9 IN VARCHAR2,
3150 p_attribute10 IN VARCHAR2,
3151 p_attribute11 IN VARCHAR2,
3152 p_attribute12 IN VARCHAR2,
3153 p_attribute13 IN VARCHAR2,
3154 p_attribute14 IN VARCHAR2,
3155 p_attribute15 IN VARCHAR2,
3156 p_requisition_distribution_id IN NUMBER,
3157 p_movement_id IN NUMBER,
3158 p_reservation_quantity IN NUMBER,
3159 p_shipped_quantity IN NUMBER,
3160 p_inventory_item IN VARCHAR2,
3161 p_locator_name IN VARCHAR2,
3162 p_task_id IN NUMBER,
3163 p_to_task_id IN NUMBER,
3164 p_source_task_id IN NUMBER,
3165 p_project_id IN NUMBER,
3166 p_to_project_id IN NUMBER,
3167 p_source_project_id IN NUMBER,
3168 p_pa_expenditure_org_id IN NUMBER,
3169 p_expenditure_type IN VARCHAR2,
3170 p_final_completion_flag IN VARCHAR2,
3171 p_transfer_percentage IN NUMBER,
3172 p_trx_sequence_id IN NUMBER,
3173 p_material_account IN NUMBER,
3174 p_material_overhead_account IN NUMBER,
3175 p_resource_account IN NUMBER,
3176 p_outside_processing_account IN NUMBER,
3177 p_overhead_account IN NUMBER,
3178 p_bom_revision IN VARCHAR2,
3179 p_routing_revision IN VARCHAR2,
3180 p_bom_revision_date IN DATE,
3181 p_routing_revision_date IN DATE,
3182 p_alternate_bom_designator IN VARCHAR2,
3183 p_alternate_routing_designator IN VARCHAR2,
3184 p_accounting_class IN VARCHAR2,
3185 p_demand_class IN VARCHAR2,
3186 p_parent_id IN NUMBER,
3187 p_substitution_type_id IN NUMBER,
3188 p_substitution_item_id IN NUMBER,
3189 p_schedule_group IN NUMBER,
3190 p_build_sequence IN NUMBER,
3191 p_schedule_number IN VARCHAR2,
3192 p_scheduled_flag IN NUMBER,
3193 p_flow_schedule IN VARCHAR2,
3194 p_cost_group_id IN NUMBER,
3195
3196 -- HW OPMCONV. Added p_secondary_trx_quantity
3197 -- and p_secondary_uom_code
3198 p_secondary_trx_quantity IN NUMBER DEFAULT NULL,
3199 p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
3200 -- p_qa_collection_id IN NUMBER,
3201 -- p_kanban_card_id IN NUMBER,
3202 -- p_end_item_unit_number IN VARCHAR2,
3203 -- p_overcompletion_transaction_qty IN NUMBER,
3204 -- p_overcompletion_primary_qty IN NUMBER,
3205 -- p_overcompletion_transaction_id IN NUMBER,
3206 -- p_scheduled_payback_date IN DATE
3207 )
3208 IS
3209 CURSOR lock_record IS
3210 SELECT * FROM mtl_transactions_interface
3211 WHERE rowid = x_rowid
3212 FOR UPDATE NOWAIT;
3213
3214 rec_info lock_record%ROWTYPE;
3215
3216 --
3217 l_debug_on BOOLEAN;
3218 --
3219 l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
3220 --
3221 BEGIN
3222
3223 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
3224 'START',
3225 'Start of procedure LOCK_ROW, input parameters:
3226 transaction_interface_id='||p_trx_interface_id||
3227 ',transaction_header_id='||p_trx_header_id||
3228 ',source_code='||p_source_code||
3229 ',source_line_id='||p_source_line_id||
3230 ',source_header_id='||p_source_header_id||
3231 ',process_flag='||p_process_flag||
3232 ',validation_required='||p_validation_required||
3233 ',transaction_mode='||p_transaction_mode||
3234 ',lock_flag='||p_lock_flag||
3235 ',inventory_item_id='||p_inventory_item_id||
3236 ',item_segment1='||p_item_segment1||
3237 ',item_segment2='||p_item_segment2||
3238 ',item_segment3='||p_item_segment3||
3239 ',item_segment4='||p_item_segment4||
3240 ',item_segment5='||p_item_segment5||
3241 ',item_segment6='||p_item_segment6||
3242 ',item_segment7='||p_item_segment7||
3243 ',item_segment8='||p_item_segment8||
3244 ',item_segment9='||p_item_segment9||
3245 ',item_segment10='||p_item_segment10||
3246 ',item_segment11='||p_item_segment11||
3247 ',item_segment12='||p_item_segment12||
3248 ',item_segment13='||p_item_segment13||
3249 ',item_segment14='||p_item_segment14||
3250 ',item_segment15='||p_item_segment15||
3251 ',item_segment16='||p_item_segment16||
3252 ',item_segment17='||p_item_segment17||
3253 ',item_segment18='||p_item_segment18||
3254 ',item_segment19='||p_item_segment19||
3255 ',item_segment20='||p_item_segment20||
3256 ',revision='||p_revision||
3257 ',organization_id='||p_organization_id||
3258 ',transaction_quantity='||p_transaction_quantity||
3259 ',primary_quantity='||p_primary_quantity||
3260 ',transaction_uom='||p_trx_uom||
3261 ',transaction_date='||p_trx_date||
3262 ',acct_period_id='||p_acct_period_id||
3263 ',subinventory_code='||p_subinventory_code||
3264 ',locator_id='||p_locator_id||
3265 ',loc_segment1='||p_loc_segment1||
3266 ',loc_segment2='||p_loc_segment2||
3267 ',loc_segment3='||p_loc_segment3||
3268 ',loc_segment4='||p_loc_segment4||
3269 ',loc_segment5='||p_loc_segment5||
3270 ',loc_segment6='||p_loc_segment6||
3271 ',loc_segment7='||p_loc_segment7||
3272 ',loc_segment8='||p_loc_segment8||
3273 ',loc_segment9='||p_loc_segment9||
3274 ',loc_segment10='||p_loc_segment10||
3275 ',loc_segment11='||p_loc_segment11||
3276 ',loc_segment12='||p_loc_segment12||
3277 ',loc_segment13='||p_loc_segment13||
3278 ',loc_segment14='||p_loc_segment14||
3279 ',loc_segment15='||p_loc_segment15||
3280 ',loc_segment16='||p_loc_segment16||
3281 ',loc_segment17='||p_loc_segment17||
3282 ',loc_segment18='||p_loc_segment18||
3283 ',loc_segment19='||p_loc_segment19||
3284 ',loc_segment20='||p_loc_segment20||
3285 ',transaction_source_id='||p_trx_source_id||
3286 ',dsp_segment1='||p_dsp_segment1||
3287 ',dsp_segment2='||p_dsp_segment2||
3288 ',dsp_segment3='||p_dsp_segment3||
3289 ',dsp_segment4='||p_dsp_segment4||
3290 ',dsp_segment5='||p_dsp_segment5||
3291 ',dsp_segment6='||p_dsp_segment6||
3292 ',dsp_segment7='||p_dsp_segment7||
3293 ',dsp_segment8='||p_dsp_segment8||
3294 ',dsp_segment9='||p_dsp_segment9||
3295 ',dsp_segment10='||p_dsp_segment10||
3296 ',dsp_segment11='||p_dsp_segment11||
3297 ',dsp_segment12='||p_dsp_segment12||
3298 ',dsp_segment13='||p_dsp_segment13||
3299 ',dsp_segment14='||p_dsp_segment14||
3300 ',dsp_segment15='||p_dsp_segment15||
3301 ',dsp_segment16='||p_dsp_segment16||
3302 ',dsp_segment17='||p_dsp_segment17||
3303 ',dsp_segment18='||p_dsp_segment18||
3304 ',dsp_segment19='||p_dsp_segment19||
3305 ',dsp_segment20='||p_dsp_segment20||
3306 ',dsp_segment21='||p_dsp_segment21||
3307 ',dsp_segment22='||p_dsp_segment22||
3308 ',dsp_segment23='||p_dsp_segment23||
3309 ',dsp_segment24='||p_dsp_segment24||
3310 ',dsp_segment25='||p_dsp_segment25||
3311 ',dsp_segment26='||p_dsp_segment26||
3312 ',dsp_segment27='||p_dsp_segment27||
3313 ',dsp_segment28='||p_dsp_segment28||
3314 ',dsp_segment29='||p_dsp_segment29||
3315 ',dsp_segment30='||p_dsp_segment30||
3316 ',transaction_source_name='||p_trx_source_name||
3317 ',transaction_source_type_id='||p_trx_source_type_id||
3318 ',transaction_action_id='||p_trx_action_id||
3319 ',transaction_type_id='||p_trx_type_id||
3320 ',reason_id='||p_reason_id||
3321 ',transaction_reference='||p_trx_reference||
3322 ',transaction_cost='||p_trx_cost||
3323 ',distribution_account_id='||p_distribution_acct_id||
3324 ',dst_segment1='||p_dst_segment1||
3325 ',dst_segment2='||p_dst_segment2||
3326 ',dst_segment3='||p_dst_segment3||
3327 ',dst_segment4='||p_dst_segment4||
3328 ',dst_segment5='||p_dst_segment5||
3329 ',dst_segment6='||p_dst_segment6||
3330 ',dst_segment7='||p_dst_segment7||
3331 ',dst_segment8='||p_dst_segment8||
3332 ',dst_segment9='||p_dst_segment9||
3333 ',dst_segment10='||p_dst_segment10||
3334 ',dst_segment11='||p_dst_segment11||
3335 ',dst_segment12='||p_dst_segment12||
3336 ',dst_segment13='||p_dst_segment13||
3337 ',dst_segment14='||p_dst_segment14||
3338 ',dst_segment15='||p_dst_segment15||
3339 ',dst_segment16='||p_dst_segment16||
3340 ',dst_segment17='||p_dst_segment17||
3341 ',dst_segment18='||p_dst_segment18||
3342 ',dst_segment19='||p_dst_segment19||
3343 ',dst_segment20='||p_dst_segment20||
3344 ',dst_segment21='||p_dst_segment21||
3345 ',dst_segment22='||p_dst_segment22||
3346 ',dst_segment23='||p_dst_segment23||
3347 ',dst_segment24='||p_dst_segment24||
3348 ',dst_segment25='||p_dst_segment25||
3349 ',dst_segment26='||p_dst_segment26||
3350 ',dst_segment27='||p_dst_segment27||
3351 ',dst_segment28='||p_dst_segment28||
3352 ',dst_segment29='||p_dst_segment29||
3353 ',dst_segment30='||p_dst_segment30||
3354 ',requisition_line_id='||p_requisition_line_id||
3355 ',currency_code='||p_currency_code||
3356 ',currency_conversion_date='||p_currency_conversion_date||
3357 ',currency_conversion_type='||p_currency_conversion_type||
3358 ',currency_conversion_rate='||p_currency_conversion_rate||
3359 ',ussgl_transaction_code='||p_ussgl_transaction_code||
3360 ',wip_entity_type='||p_wip_entity_type||
3361 ',schedule_id='||p_schedule_id||
3362 ',employee_code='||p_employee_code||
3363 ',department_id='||p_department_id||
3364 ',schedule_update_code='||p_schedule_update_code||
3365 ',setup_teardown_code='||p_setup_teardown_code||
3366 ',primary_switch='||p_primary_switch||
3367 ',mrp_code='||p_mrp_code||
3368 ',operation_seq_num='||p_operation_seq_num||
3369 ',repetitive_line_id='||p_repetitive_line_id||
3370 ',picking_line_id='||p_picking_line_id||
3371 ',trx_source_line_id='||p_trx_source_line_id||
3372 ',trx_source_delivery_id='||p_trx_source_delivery_id||
3373 ',demand_id='||p_demand_id||
3374 ',customer_ship_id='||p_customer_ship_id||
3375 ',line_item_num='||p_line_item_num||
3376 ',receiving_document='||p_receiving_document||
3377 ',rcv_transaction_id='||p_rcv_transaction_id||
3378 ',ship_to_location_id='||p_ship_to_location_id||
3379 ',encumbrance_account='||p_encumbrance_account||
3380 ',encumbrance_amount='||p_encumbrance_amount||
3381 ',vendor_lot_number='||p_vendor_lot_number||
3382 ',transfer_subinventory='||p_transfer_subinventory||
3383 ',transfer_organization='||p_transfer_organization||
3384 ',transfer_locator='||p_transfer_locator||
3385 ',xfer_loc_segment1='||p_xfer_loc_segment1||
3386 ',xfer_loc_segment2='||p_xfer_loc_segment2||
3387 ',xfer_loc_segment3='||p_xfer_loc_segment3||
3388 ',xfer_loc_segment4='||p_xfer_loc_segment4||
3389 ',xfer_loc_segment5='||p_xfer_loc_segment5||
3390 ',xfer_loc_segment6='||p_xfer_loc_segment6||
3391 ',xfer_loc_segment7='||p_xfer_loc_segment7||
3392 ',xfer_loc_segment8='||p_xfer_loc_segment8||
3393 ',xfer_loc_segment9='||p_xfer_loc_segment9||
3394 ',xfer_loc_segment10='||p_xfer_loc_segment10||
3395 ',xfer_loc_segment11='||p_xfer_loc_segment11||
3396 ',xfer_loc_segment12='||p_xfer_loc_segment12||
3397 ',xfer_loc_segment13='||p_xfer_loc_segment13||
3398 ',xfer_loc_segment14='||p_xfer_loc_segment14||
3399 ',xfer_loc_segment15='||p_xfer_loc_segment15||
3400 ',xfer_loc_segment16='||p_xfer_loc_segment16||
3401 ',xfer_loc_segment17='||p_xfer_loc_segment17||
3402 ',xfer_loc_segment18='||p_xfer_loc_segment18||
3403 ',xfer_loc_segment19='||p_xfer_loc_segment19||
3404 ',xfer_loc_segment20='||p_xfer_loc_segment20||
3405 ',shipment_number='||p_shipment_number||
3406 ',transportation_cost='||p_transportation_cost||
3407 ',transportation_account='||p_transportation_account||
3408 ',transfer_cost='||p_transfer_cost||
3409 ',freight_code='||p_freight_code||
3410 ',containers='||p_containers||
3411 ',waybill_airbill='||p_waybill_airbill||
3412 ',expected_arrival_date='||p_expected_arrival_date||
3413 ',new_average_cost='||p_new_average_cost||
3414 ',value_change='||p_value_change||
3415 ',percentage_change='||p_percentage_change||
3416 ',demand_source_header_id='||p_demand_source_header_id||
3417 ',demand_source_line='||p_demand_source_line||
3418 ',demand_source_delivery='||p_demand_source_delivery||
3419 ',negative_req_flag='||p_negative_req_flag||
3420 ',error_explanation='||p_error_explanation||
3421 ',shippable_flag='||p_shippable_flag||
3422 ',error_code='||p_error_code||
3423 ',required_flag='||p_required_flag||
3424 ',attribute_category='||p_attribute_category||
3425 ',attribute1='||p_attribute1||
3426 ',attribute2='||p_attribute2||
3427 ',attribute3='||p_attribute3||
3428 ',attribute4='||p_attribute4||
3429 ',attribute5='||p_attribute5||
3430 ',attribute6='||p_attribute6||
3431 ',attribute7='||p_attribute7||
3432 ',attribute8='||p_attribute8||
3433 ',attribute9='||p_attribute9||
3434 ',attribute10='||p_attribute10||
3435 ',attribute11='||p_attribute11||
3436 ',attribute12='||p_attribute12||
3437 ',attribute13='||p_attribute13||
3438 ',attribute14='||p_attribute14||
3439 ',attribute15='||p_attribute15||
3440 ',requisition_distribution_id='||p_requisition_distribution_id||
3441 ',movement_id='||p_movement_id||
3442 ',reservation_quantity='||p_reservation_quantity||
3443 ',shipped_quantity='||p_shipped_quantity||
3444 ',inventory_item='||p_inventory_item||
3445 ',locator_name='||p_locator_name||
3446 ',task_id='||p_task_id||
3447 ',to_task_id='||p_to_task_id||
3448 ',source_task_id='||p_source_task_id||
3449 ',project_id='||p_project_id||
3450 ',to_project_id='||p_to_project_id||
3451 ',source_project_id='||p_source_project_id||
3452 ',pa_expenditure_org_id='||p_pa_expenditure_org_id||
3453 ',expenditure_type='||p_expenditure_type||
3454 ',final_completion_flag='||p_final_completion_flag||
3455 ',transfer_percentage='||p_transfer_percentage||
3456 ',transaction_sequence_id='||p_trx_sequence_id||
3457 ',material_account='||p_material_account||
3458 ',material_overhead_account='||p_material_overhead_account||
3459 ',resource_account='||p_resource_account||
3460 ',outside_processing_account='||p_outside_processing_account||
3461 ',overhead_account='||p_overhead_account||
3462 ',bom_revision='||p_bom_revision||
3463 ',routing_revision='||p_routing_revision||
3464 ',bom_revision_date='||p_bom_revision_date||
3465 ',routing_revision_date='||p_routing_revision_date||
3466 ',alternate_bom_designator='||p_alternate_bom_designator||
3467 ',alternate_routing_designator='||p_alternate_routing_designator||
3468 ',accounting_class='||p_accounting_class||
3469 ',demand_class='||p_demand_class||
3470 ',parent_id='||p_parent_id||
3471 ',substitution_type_id='||p_substitution_type_id||
3472 ',substitution_item_id='||p_substitution_item_id||
3473 ',schedule_group='||p_schedule_group||
3474 ',build_sequence='||p_build_sequence||
3475 ',schedule_number='||p_schedule_number||
3476 ',scheduled_flag='||p_scheduled_flag||
3477 ',flow_schedule='||p_flow_schedule||
3478 ',cost_group_id='||p_cost_group_id);
3479 */
3480 --
3481 --
3482 l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3483 --
3484 IF l_debug_on IS NULL
3485 THEN
3486 l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3487 END IF;
3488 --
3489 IF l_debug_on THEN
3490 WSH_DEBUG_SV.push(l_module_name);
3491 --
3492 WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
3493 WSH_DEBUG_SV.log(l_module_name,'P_TRX_INTERFACE_ID',P_TRX_INTERFACE_ID);
3494 WSH_DEBUG_SV.log(l_module_name,'P_TRX_HEADER_ID',P_TRX_HEADER_ID);
3495 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
3496 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
3497 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
3498 WSH_DEBUG_SV.log(l_module_name,'P_PROCESS_FLAG',P_PROCESS_FLAG);
3499 WSH_DEBUG_SV.log(l_module_name,'P_VALIDATION_REQUIRED',P_VALIDATION_REQUIRED);
3500 WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_MODE',P_TRANSACTION_MODE);
3501 WSH_DEBUG_SV.log(l_module_name,'P_LOCK_FLAG',P_LOCK_FLAG);
3502 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
3503 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT1',P_ITEM_SEGMENT1);
3504 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT2',P_ITEM_SEGMENT2);
3505 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT3',P_ITEM_SEGMENT3);
3506 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT4',P_ITEM_SEGMENT4);
3507 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT5',P_ITEM_SEGMENT5);
3508 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT6',P_ITEM_SEGMENT6);
3509 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT7',P_ITEM_SEGMENT7);
3510 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT8',P_ITEM_SEGMENT8);
3511 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT9',P_ITEM_SEGMENT9);
3512 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT10',P_ITEM_SEGMENT10);
3513 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT11',P_ITEM_SEGMENT11);
3514 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT12',P_ITEM_SEGMENT12);
3515 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT13',P_ITEM_SEGMENT13);
3516 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT14',P_ITEM_SEGMENT14);
3517 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT15',P_ITEM_SEGMENT15);
3518 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT16',P_ITEM_SEGMENT16);
3519 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT17',P_ITEM_SEGMENT17);
3520 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT18',P_ITEM_SEGMENT18);
3521 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT19',P_ITEM_SEGMENT19);
3522 WSH_DEBUG_SV.log(l_module_name,'P_ITEM_SEGMENT20',P_ITEM_SEGMENT20);
3523 WSH_DEBUG_SV.log(l_module_name,'P_REVISION',P_REVISION);
3524 WSH_DEBUG_SV.log(l_module_name,'P_ORGANIZATION_ID',P_ORGANIZATION_ID);
3525 WSH_DEBUG_SV.log(l_module_name,'P_TRANSACTION_QUANTITY',P_TRANSACTION_QUANTITY);
3526 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_QUANTITY',P_PRIMARY_QUANTITY);
3527 WSH_DEBUG_SV.log(l_module_name,'P_TRX_UOM',P_TRX_UOM);
3528 WSH_DEBUG_SV.log(l_module_name,'P_TRX_DATE',P_TRX_DATE);
3529 WSH_DEBUG_SV.log(l_module_name,'P_ACCT_PERIOD_ID',P_ACCT_PERIOD_ID);
3530 WSH_DEBUG_SV.log(l_module_name,'P_SUBINVENTORY_CODE',P_SUBINVENTORY_CODE);
3531 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_ID',P_LOCATOR_ID);
3532 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT1',P_LOC_SEGMENT1);
3533 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT2',P_LOC_SEGMENT2);
3534 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT3',P_LOC_SEGMENT3);
3535 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT4',P_LOC_SEGMENT4);
3536 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT5',P_LOC_SEGMENT5);
3537 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT6',P_LOC_SEGMENT6);
3538 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT7',P_LOC_SEGMENT7);
3539 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT8',P_LOC_SEGMENT8);
3540 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT9',P_LOC_SEGMENT9);
3541 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT10',P_LOC_SEGMENT10);
3542 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT11',P_LOC_SEGMENT11);
3543 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT12',P_LOC_SEGMENT12);
3544 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT13',P_LOC_SEGMENT13);
3545 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT14',P_LOC_SEGMENT14);
3546 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT15',P_LOC_SEGMENT15);
3547 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT16',P_LOC_SEGMENT16);
3548 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT17',P_LOC_SEGMENT17);
3549 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT18',P_LOC_SEGMENT18);
3550 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT19',P_LOC_SEGMENT19);
3551 WSH_DEBUG_SV.log(l_module_name,'P_LOC_SEGMENT20',P_LOC_SEGMENT20);
3552 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_ID',P_TRX_SOURCE_ID);
3553 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT1',P_DSP_SEGMENT1);
3554 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT2',P_DSP_SEGMENT2);
3555 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT3',P_DSP_SEGMENT3);
3556 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT4',P_DSP_SEGMENT4);
3557 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT5',P_DSP_SEGMENT5);
3558 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT6',P_DSP_SEGMENT6);
3559 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT7',P_DSP_SEGMENT7);
3560 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT8',P_DSP_SEGMENT8);
3561 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT9',P_DSP_SEGMENT9);
3562 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT10',P_DSP_SEGMENT10);
3563 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT11',P_DSP_SEGMENT11);
3564 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT12',P_DSP_SEGMENT12);
3565 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT13',P_DSP_SEGMENT13);
3566 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT14',P_DSP_SEGMENT14);
3567 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT15',P_DSP_SEGMENT15);
3568 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT16',P_DSP_SEGMENT16);
3569 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT17',P_DSP_SEGMENT17);
3570 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT18',P_DSP_SEGMENT18);
3571 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT19',P_DSP_SEGMENT19);
3572 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT20',P_DSP_SEGMENT20);
3573 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT21',P_DSP_SEGMENT21);
3574 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT22',P_DSP_SEGMENT22);
3575 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT23',P_DSP_SEGMENT23);
3576 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT24',P_DSP_SEGMENT24);
3577 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT25',P_DSP_SEGMENT25);
3578 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT26',P_DSP_SEGMENT26);
3579 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT27',P_DSP_SEGMENT27);
3580 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT28',P_DSP_SEGMENT28);
3581 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT29',P_DSP_SEGMENT29);
3582 WSH_DEBUG_SV.log(l_module_name,'P_DSP_SEGMENT30',P_DSP_SEGMENT30);
3583 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_NAME',P_TRX_SOURCE_NAME);
3584 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_TYPE_ID',P_TRX_SOURCE_TYPE_ID);
3585 WSH_DEBUG_SV.log(l_module_name,'P_TRX_ACTION_ID',P_TRX_ACTION_ID);
3586 WSH_DEBUG_SV.log(l_module_name,'P_TRX_TYPE_ID',P_TRX_TYPE_ID);
3587 WSH_DEBUG_SV.log(l_module_name,'P_REASON_ID',P_REASON_ID);
3588 WSH_DEBUG_SV.log(l_module_name,'P_TRX_REFERENCE',P_TRX_REFERENCE);
3589 WSH_DEBUG_SV.log(l_module_name,'P_TRX_COST',P_TRX_COST);
3590 WSH_DEBUG_SV.log(l_module_name,'P_DISTRIBUTION_ACCT_ID',P_DISTRIBUTION_ACCT_ID);
3591 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT1',P_DST_SEGMENT1);
3592 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT2',P_DST_SEGMENT2);
3593 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT3',P_DST_SEGMENT3);
3594 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT4',P_DST_SEGMENT4);
3595 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT5',P_DST_SEGMENT5);
3596 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT6',P_DST_SEGMENT6);
3597 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT7',P_DST_SEGMENT7);
3598 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT8',P_DST_SEGMENT8);
3599 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT9',P_DST_SEGMENT9);
3600 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT10',P_DST_SEGMENT10);
3601 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT11',P_DST_SEGMENT11);
3602 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT12',P_DST_SEGMENT12);
3603 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT13',P_DST_SEGMENT13);
3604 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT14',P_DST_SEGMENT14);
3605 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT15',P_DST_SEGMENT15);
3606 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT16',P_DST_SEGMENT16);
3607 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT17',P_DST_SEGMENT17);
3608 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT18',P_DST_SEGMENT18);
3609 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT19',P_DST_SEGMENT19);
3610 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT20',P_DST_SEGMENT20);
3611 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT21',P_DST_SEGMENT21);
3612 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT22',P_DST_SEGMENT22);
3613 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT23',P_DST_SEGMENT23);
3614 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT24',P_DST_SEGMENT24);
3615 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT25',P_DST_SEGMENT25);
3616 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT26',P_DST_SEGMENT26);
3617 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT27',P_DST_SEGMENT27);
3618 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT28',P_DST_SEGMENT28);
3619 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT29',P_DST_SEGMENT29);
3620 WSH_DEBUG_SV.log(l_module_name,'P_DST_SEGMENT30',P_DST_SEGMENT30);
3621 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_LINE_ID',P_REQUISITION_LINE_ID);
3622 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CODE',P_CURRENCY_CODE);
3623 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_DATE',P_CURRENCY_CONVERSION_DATE);
3624 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_TYPE',P_CURRENCY_CONVERSION_TYPE);
3625 WSH_DEBUG_SV.log(l_module_name,'P_CURRENCY_CONVERSION_RATE',P_CURRENCY_CONVERSION_RATE);
3626 WSH_DEBUG_SV.log(l_module_name,'P_USSGL_TRANSACTION_CODE',P_USSGL_TRANSACTION_CODE);
3627 WSH_DEBUG_SV.log(l_module_name,'P_WIP_ENTITY_TYPE',P_WIP_ENTITY_TYPE);
3628 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_ID',P_SCHEDULE_ID);
3629 WSH_DEBUG_SV.log(l_module_name,'P_EMPLOYEE_CODE',P_EMPLOYEE_CODE);
3630 WSH_DEBUG_SV.log(l_module_name,'P_DEPARTMENT_ID',P_DEPARTMENT_ID);
3631 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_UPDATE_CODE',P_SCHEDULE_UPDATE_CODE);
3632 WSH_DEBUG_SV.log(l_module_name,'P_SETUP_TEARDOWN_CODE',P_SETUP_TEARDOWN_CODE);
3633 WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_SWITCH',P_PRIMARY_SWITCH);
3634 WSH_DEBUG_SV.log(l_module_name,'P_MRP_CODE',P_MRP_CODE);
3635 WSH_DEBUG_SV.log(l_module_name,'P_OPERATION_SEQ_NUM',P_OPERATION_SEQ_NUM);
3636 WSH_DEBUG_SV.log(l_module_name,'P_REPETITIVE_LINE_ID',P_REPETITIVE_LINE_ID);
3637 WSH_DEBUG_SV.log(l_module_name,'P_PICKING_LINE_ID',P_PICKING_LINE_ID);
3638 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_LINE_ID',P_TRX_SOURCE_LINE_ID);
3639 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SOURCE_DELIVERY_ID',P_TRX_SOURCE_DELIVERY_ID);
3640 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_ID',P_DEMAND_ID);
3641 WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_SHIP_ID',P_CUSTOMER_SHIP_ID);
3642 WSH_DEBUG_SV.log(l_module_name,'P_LINE_ITEM_NUM',P_LINE_ITEM_NUM);
3643 WSH_DEBUG_SV.log(l_module_name,'P_RECEIVING_DOCUMENT',P_RECEIVING_DOCUMENT);
3644 WSH_DEBUG_SV.log(l_module_name,'P_RCV_TRANSACTION_ID',P_RCV_TRANSACTION_ID);
3645 WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_LOCATION_ID',P_SHIP_TO_LOCATION_ID);
3646 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_ACCOUNT',P_ENCUMBRANCE_ACCOUNT);
3647 WSH_DEBUG_SV.log(l_module_name,'P_ENCUMBRANCE_AMOUNT',P_ENCUMBRANCE_AMOUNT);
3648 WSH_DEBUG_SV.log(l_module_name,'P_VENDOR_LOT_NUMBER',P_VENDOR_LOT_NUMBER);
3649 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_SUBINVENTORY',P_TRANSFER_SUBINVENTORY);
3650 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_ORGANIZATION',P_TRANSFER_ORGANIZATION);
3651 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_LOCATOR',P_TRANSFER_LOCATOR);
3652 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT1',P_XFER_LOC_SEGMENT1);
3653 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT2',P_XFER_LOC_SEGMENT2);
3654 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT3',P_XFER_LOC_SEGMENT3);
3655 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT4',P_XFER_LOC_SEGMENT4);
3656 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT5',P_XFER_LOC_SEGMENT5);
3657 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT6',P_XFER_LOC_SEGMENT6);
3658 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT7',P_XFER_LOC_SEGMENT7);
3659 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT8',P_XFER_LOC_SEGMENT8);
3660 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT9',P_XFER_LOC_SEGMENT9);
3661 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT10',P_XFER_LOC_SEGMENT10);
3662 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT11',P_XFER_LOC_SEGMENT11);
3663 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT12',P_XFER_LOC_SEGMENT12);
3664 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT13',P_XFER_LOC_SEGMENT13);
3665 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT14',P_XFER_LOC_SEGMENT14);
3666 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT15',P_XFER_LOC_SEGMENT15);
3667 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT16',P_XFER_LOC_SEGMENT16);
3668 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT17',P_XFER_LOC_SEGMENT17);
3669 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT18',P_XFER_LOC_SEGMENT18);
3670 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT19',P_XFER_LOC_SEGMENT19);
3671 WSH_DEBUG_SV.log(l_module_name,'P_XFER_LOC_SEGMENT20',P_XFER_LOC_SEGMENT20);
3672 WSH_DEBUG_SV.log(l_module_name,'P_SHIPMENT_NUMBER',P_SHIPMENT_NUMBER);
3673 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_COST',P_TRANSPORTATION_COST);
3674 WSH_DEBUG_SV.log(l_module_name,'P_TRANSPORTATION_ACCOUNT',P_TRANSPORTATION_ACCOUNT);
3675 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_COST',P_TRANSFER_COST);
3676 WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CODE',P_FREIGHT_CODE);
3677 WSH_DEBUG_SV.log(l_module_name,'P_CONTAINERS',P_CONTAINERS);
3678 WSH_DEBUG_SV.log(l_module_name,'P_WAYBILL_AIRBILL',P_WAYBILL_AIRBILL);
3679 WSH_DEBUG_SV.log(l_module_name,'P_EXPECTED_ARRIVAL_DATE',P_EXPECTED_ARRIVAL_DATE);
3680 WSH_DEBUG_SV.log(l_module_name,'P_NEW_AVERAGE_COST',P_NEW_AVERAGE_COST);
3681 WSH_DEBUG_SV.log(l_module_name,'P_VALUE_CHANGE',P_VALUE_CHANGE);
3682 WSH_DEBUG_SV.log(l_module_name,'P_PERCENTAGE_CHANGE',P_PERCENTAGE_CHANGE);
3683 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_HEADER_ID',P_DEMAND_SOURCE_HEADER_ID);
3684 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_LINE',P_DEMAND_SOURCE_LINE);
3685 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_SOURCE_DELIVERY',P_DEMAND_SOURCE_DELIVERY);
3686 WSH_DEBUG_SV.log(l_module_name,'P_NEGATIVE_REQ_FLAG',P_NEGATIVE_REQ_FLAG);
3687 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_EXPLANATION',P_ERROR_EXPLANATION);
3688 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPABLE_FLAG',P_SHIPPABLE_FLAG);
3689 WSH_DEBUG_SV.log(l_module_name,'P_ERROR_CODE',P_ERROR_CODE);
3690 WSH_DEBUG_SV.log(l_module_name,'P_REQUIRED_FLAG',P_REQUIRED_FLAG);
3691 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE_CATEGORY',P_ATTRIBUTE_CATEGORY);
3692 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE1',P_ATTRIBUTE1);
3693 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE2',P_ATTRIBUTE2);
3694 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE3',P_ATTRIBUTE3);
3695 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE4',P_ATTRIBUTE4);
3696 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE5',P_ATTRIBUTE5);
3697 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE6',P_ATTRIBUTE6);
3698 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE7',P_ATTRIBUTE7);
3699 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE8',P_ATTRIBUTE8);
3700 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE9',P_ATTRIBUTE9);
3701 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE10',P_ATTRIBUTE10);
3702 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE11',P_ATTRIBUTE11);
3703 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE12',P_ATTRIBUTE12);
3704 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE13',P_ATTRIBUTE13);
3705 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE14',P_ATTRIBUTE14);
3706 WSH_DEBUG_SV.log(l_module_name,'P_ATTRIBUTE15',P_ATTRIBUTE15);
3707 WSH_DEBUG_SV.log(l_module_name,'P_REQUISITION_DISTRIBUTION_ID',P_REQUISITION_DISTRIBUTION_ID);
3708 WSH_DEBUG_SV.log(l_module_name,'P_MOVEMENT_ID',P_MOVEMENT_ID);
3709 WSH_DEBUG_SV.log(l_module_name,'P_RESERVATION_QUANTITY',P_RESERVATION_QUANTITY);
3710 WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_QUANTITY',P_SHIPPED_QUANTITY);
3711 WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM',P_INVENTORY_ITEM);
3712 WSH_DEBUG_SV.log(l_module_name,'P_LOCATOR_NAME',P_LOCATOR_NAME);
3713 WSH_DEBUG_SV.log(l_module_name,'P_TASK_ID',P_TASK_ID);
3714 WSH_DEBUG_SV.log(l_module_name,'P_TO_TASK_ID',P_TO_TASK_ID);
3715 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TASK_ID',P_SOURCE_TASK_ID);
3716 WSH_DEBUG_SV.log(l_module_name,'P_PROJECT_ID',P_PROJECT_ID);
3717 WSH_DEBUG_SV.log(l_module_name,'P_TO_PROJECT_ID',P_TO_PROJECT_ID);
3718 WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_PROJECT_ID',P_SOURCE_PROJECT_ID);
3719 WSH_DEBUG_SV.log(l_module_name,'P_PA_EXPENDITURE_ORG_ID',P_PA_EXPENDITURE_ORG_ID);
3720 WSH_DEBUG_SV.log(l_module_name,'P_EXPENDITURE_TYPE',P_EXPENDITURE_TYPE);
3721 WSH_DEBUG_SV.log(l_module_name,'P_FINAL_COMPLETION_FLAG',P_FINAL_COMPLETION_FLAG);
3722 WSH_DEBUG_SV.log(l_module_name,'P_TRANSFER_PERCENTAGE',P_TRANSFER_PERCENTAGE);
3723 WSH_DEBUG_SV.log(l_module_name,'P_TRX_SEQUENCE_ID',P_TRX_SEQUENCE_ID);
3724 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_ACCOUNT',P_MATERIAL_ACCOUNT);
3725 WSH_DEBUG_SV.log(l_module_name,'P_MATERIAL_OVERHEAD_ACCOUNT',P_MATERIAL_OVERHEAD_ACCOUNT);
3726 WSH_DEBUG_SV.log(l_module_name,'P_RESOURCE_ACCOUNT',P_RESOURCE_ACCOUNT);
3727 WSH_DEBUG_SV.log(l_module_name,'P_OUTSIDE_PROCESSING_ACCOUNT',P_OUTSIDE_PROCESSING_ACCOUNT);
3728 WSH_DEBUG_SV.log(l_module_name,'P_OVERHEAD_ACCOUNT',P_OVERHEAD_ACCOUNT);
3729 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION',P_BOM_REVISION);
3730 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION',P_ROUTING_REVISION);
3731 WSH_DEBUG_SV.log(l_module_name,'P_BOM_REVISION_DATE',P_BOM_REVISION_DATE);
3732 WSH_DEBUG_SV.log(l_module_name,'P_ROUTING_REVISION_DATE',P_ROUTING_REVISION_DATE);
3733 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_BOM_DESIGNATOR',P_ALTERNATE_BOM_DESIGNATOR);
3734 WSH_DEBUG_SV.log(l_module_name,'P_ALTERNATE_ROUTING_DESIGNATOR',P_ALTERNATE_ROUTING_DESIGNATOR);
3735 WSH_DEBUG_SV.log(l_module_name,'P_ACCOUNTING_CLASS',P_ACCOUNTING_CLASS);
3736 WSH_DEBUG_SV.log(l_module_name,'P_DEMAND_CLASS',P_DEMAND_CLASS);
3737 WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ID',P_PARENT_ID);
3738 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_TYPE_ID',P_SUBSTITUTION_TYPE_ID);
3739 WSH_DEBUG_SV.log(l_module_name,'P_SUBSTITUTION_ITEM_ID',P_SUBSTITUTION_ITEM_ID);
3740 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_GROUP',P_SCHEDULE_GROUP);
3741 WSH_DEBUG_SV.log(l_module_name,'P_BUILD_SEQUENCE',P_BUILD_SEQUENCE);
3742 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULE_NUMBER',P_SCHEDULE_NUMBER);
3743 WSH_DEBUG_SV.log(l_module_name,'P_SCHEDULED_FLAG',P_SCHEDULED_FLAG);
3744 WSH_DEBUG_SV.log(l_module_name,'P_FLOW_SCHEDULE',P_FLOW_SCHEDULE);
3745 WSH_DEBUG_SV.log(l_module_name,'P_COST_GROUP_ID',P_COST_GROUP_ID);
3746 -- HW OPMCONV. Added debugging msgs
3747 WSH_DEBUG_SV.log(l_module_name,'P_SECONDARY_TRX_QUANTITY',P_SECONDARY_TRX_QUANTITY);
3748 WSH_DEBUG_SV.log(l_module_name,'p_secondary_uom_code',p_secondary_uom_code);
3749 END IF;
3750 --
3751 OPEN lock_record;
3752
3753 FETCH lock_record into rec_info;
3754
3755 IF (lock_record%NOTFOUND) THEN
3756 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
3757 'END',
3758 'Lock record failed. Raising exception FORM_RECORD_DELETED');
3759 */
3760 CLOSE lock_record;
3761
3762 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
3763 IF l_debug_on THEN
3764 WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_DELETED');
3765 END IF;
3766 app_exception.raise_exception;
3767 END IF;
3768
3769 CLOSE lock_record;
3770
3771 IF ( ( (rec_info.transaction_interface_id = p_trx_interface_id)
3772 OR ((rec_info.transaction_interface_id IS NULL)
3773 AND (p_trx_interface_id IS NULL)))
3774 AND ((rec_info.transaction_header_id = p_trx_header_id)
3775 OR ((rec_info.transaction_header_id IS NULL)
3776 AND (p_trx_header_id IS NULL)))
3777 AND (rec_info.source_code = p_source_code)
3778 AND (rec_info.source_line_id = p_source_line_id)
3779 AND (rec_info.source_header_id = p_source_header_id)
3780 AND (rec_info.process_flag = p_process_flag)
3781 AND ((rec_info.validation_required = p_validation_required)
3782 OR ((rec_info.validation_required IS NULL)
3783 AND (p_validation_required IS NULL)))
3784 AND (rec_info.transaction_mode = p_transaction_mode)
3785 AND ((rec_info.lock_flag = p_lock_flag)
3786 OR ((rec_info.lock_flag IS NULL) AND (p_lock_flag IS NULL)))
3787 AND ((rec_info.inventory_item_id = p_inventory_item_id)
3788 OR ((rec_info.inventory_item_id IS NULL)
3789 AND (p_inventory_item_id IS NULL)))
3790 AND ((rec_info.item_segment1 = p_item_segment1)
3791 OR ((rec_info.item_segment1 IS NULL) AND (p_item_segment1 IS NULL)))
3792 AND ((rec_info.item_segment2 = p_item_segment2)
3793 OR ((rec_info.item_segment2 IS NULL) AND (p_item_segment2 IS NULL)))
3794 AND ((rec_info.item_segment3 = p_item_segment3)
3795 OR ((rec_info.item_segment3 IS NULL) AND (p_item_segment3 is NULL)))
3796 AND ((rec_info.item_segment4 = p_item_segment4)
3797 OR ((rec_info.item_segment4 IS NULL) AND (p_item_segment4 is NULL)))
3798 AND ((rec_info.item_segment5 = p_item_segment5)
3799 OR ((rec_info.item_segment5 IS NULL) AND (p_item_segment5 is NULL)))
3800 AND ((rec_info.item_segment6 = p_item_segment6)
3801 OR ((rec_info.item_segment6 IS NULL) AND (p_item_segment6 is NULL)))
3802 AND ((rec_info.item_segment7 = p_item_segment7)
3803 OR ((rec_info.item_segment7 IS NULL) AND (p_item_segment7 is NULL)))
3804 AND ((rec_info.item_segment8 = p_item_segment8)
3805 OR ((rec_info.item_segment8 IS NULL) AND (p_item_segment8 is NULL)))
3806 AND ((rec_info.item_segment9 = p_item_segment9)
3807 OR ((rec_info.item_segment9 IS NULL) AND (p_item_segment9 is NULL)))
3808 AND ((rec_info.item_segment10 = p_item_segment10)
3809 OR ((rec_info.item_segment10 IS NULL)
3810 AND (p_item_segment10 is NULL)))
3811 AND ((rec_info.item_segment11 = p_item_segment11)
3812 OR ((rec_info.item_segment11 IS NULL)
3813 AND (p_item_segment11 is NULL)))
3814 AND ((rec_info.item_segment12 = p_item_segment12)
3815 OR ((rec_info.item_segment12 IS NULL)
3816 AND (p_item_segment12 is NULL)))
3817 AND ((rec_info.item_segment13 = p_item_segment13)
3818 OR ((rec_info.item_segment13 IS NULL)
3819 AND (p_item_segment13 is NULL)))
3820 AND ((rec_info.item_segment14 = p_item_segment14)
3821 OR ((rec_info.item_segment14 IS NULL)
3822 AND (p_item_segment14 is NULL)))
3823 AND ((rec_info.item_segment15 = p_item_segment15)
3824 OR ((rec_info.item_segment15 IS NULL)
3825 AND (p_item_segment15 is NULL)))
3826 AND ((rec_info.item_segment16 = p_item_segment16)
3827 OR ((rec_info.item_segment16 IS NULL)
3828 AND (p_item_segment16 is NULL)))
3829 AND ((rec_info.item_segment17 = p_item_segment17)
3830 OR ((rec_info.item_segment17 IS NULL)
3831 AND (p_item_segment17 is NULL)))
3832 AND ((rec_info.item_segment18 = p_item_segment18)
3833 OR ((rec_info.item_segment18 IS NULL)
3834 AND (p_item_segment18 is NULL)))
3835 AND (( rec_info.item_segment19 = p_item_segment19)
3836 OR ((rec_info.item_segment19 IS NULL)
3837 AND (p_item_segment19 is NULL)))
3838 AND (( rec_info.item_segment20 = p_item_segment20)
3839 OR ((rec_info.item_segment20 IS NULL)
3840 AND (p_item_segment20 is NULL)))
3841 AND ((rec_info.revision = p_revision)
3842 OR ((rec_info.revision IS NULL) AND (p_revision is NULL)))
3843 AND (rec_info.organization_id = p_organization_id)
3844 AND (rec_info.transaction_quantity = p_transaction_quantity)
3845 AND ((rec_info.primary_quantity = p_primary_quantity)
3846 OR ((rec_info.primary_quantity IS NULL)
3847 AND (p_primary_quantity is NULL)))
3848 AND (rec_info.transaction_uom = p_trx_uom)
3849 AND (rec_info.transaction_date = p_trx_date)
3850 AND ((rec_info.acct_period_id = p_acct_period_id)
3851 OR ((rec_info.acct_period_id IS NULL)
3852 AND (p_acct_period_id is NULL)))
3853 AND ((rec_info.subinventory_code = p_subinventory_code)
3854 OR ((rec_info.subinventory_code IS NULL)
3855 AND (p_subinventory_code is NULL)))
3856 AND ((rec_info.locator_id = p_locator_id)
3857 OR ((rec_info.locator_id IS NULL) AND (p_locator_id is NULL)))
3858 AND ((rec_info.loc_segment1 = p_loc_segment1)
3859 OR ((rec_info.loc_segment1 IS NULL) AND (p_loc_segment1 is NULL)))
3860 AND ((rec_info.loc_segment2 = p_loc_segment2)
3861 OR ((rec_info.loc_segment2 IS NULL) AND (p_loc_segment2 is NULL)))
3862 AND ((rec_info.loc_segment3 = p_loc_segment3)
3863 OR ((rec_info.loc_segment3 IS NULL) AND (p_loc_segment3 is NULL)))
3864 AND ((rec_info.loc_segment4 = p_loc_segment4)
3865 OR ((rec_info.loc_segment4 IS NULL) AND (p_loc_segment4 is NULL)))
3866 AND ((rec_info.loc_segment5 = p_loc_segment5)
3867 OR ((rec_info.loc_segment5 IS NULL) AND (p_loc_segment5 is NULL)))
3868 AND ((rec_info.loc_segment6 = p_loc_segment6)
3869 OR ((rec_info.loc_segment6 IS NULL) AND (p_loc_segment6 is NULL)))
3870 AND ((rec_info.loc_segment7 = p_loc_segment7)
3871 OR ((rec_info.loc_segment7 IS NULL) AND (p_loc_segment7 is NULL)))
3872 AND ((rec_info.loc_segment8 = p_loc_segment8)
3873 OR ((rec_info.loc_segment8 IS NULL) AND (p_loc_segment8 is NULL)))
3874 AND ((rec_info.loc_segment9 = p_loc_segment9)
3875 OR ((rec_info.loc_segment9 IS NULL) AND (p_loc_segment9 is NULL)))
3876 AND ((rec_info.loc_segment10 = p_loc_segment10)
3877 OR ((rec_info.loc_segment10 IS NULL) AND (p_loc_segment10 is NULL)))
3878 AND ((rec_info.loc_segment11 = p_loc_segment11)
3879 OR ((rec_info.loc_segment11 IS NULL) AND (p_loc_segment11 is NULL)))
3880 AND ((rec_info.loc_segment12 = p_loc_segment12)
3881 OR ((rec_info.loc_segment12 IS NULL) AND (p_loc_segment12 is NULL)))
3882 AND ((rec_info.loc_segment13 = p_loc_segment13)
3883 OR ((rec_info.loc_segment13 IS NULL) AND (p_loc_segment13 is NULL)))
3884 AND ((rec_info.loc_segment14 = p_loc_segment14)
3885 OR ((rec_info.loc_segment14 IS NULL) AND (p_loc_segment14 is NULL)))
3886 AND ((rec_info.loc_segment15 = p_loc_segment15)
3887 OR ((rec_info.loc_segment15 IS NULL) AND (p_loc_segment15 is NULL)))
3888 AND ((rec_info.loc_segment16 = p_loc_segment16)
3889 OR ((rec_info.loc_segment16 IS NULL) AND (p_loc_segment16 is NULL)))
3890 AND ((rec_info.loc_segment17 = p_loc_segment17)
3891 OR ((rec_info.loc_segment17 IS NULL) AND (p_loc_segment17 is NULL)))
3892 AND ((rec_info.loc_segment18 = p_loc_segment18)
3893 OR ((rec_info.loc_segment18 IS NULL) AND (p_loc_segment18 is NULL)))
3894 AND ((rec_info.loc_segment19 = p_loc_segment19)
3895 OR ((rec_info.loc_segment19 IS NULL) AND (p_loc_segment19 is NULL)))
3896 AND ((rec_info.loc_segment20 = p_loc_segment20)
3897 OR ((rec_info.loc_segment20 IS NULL) AND (p_loc_segment20 is NULL)))
3898 AND ((rec_info.transaction_source_id = p_trx_source_id)
3899 OR ((rec_info.transaction_source_id IS NULL)
3900 AND (p_trx_source_id is NULL)))
3901 AND ((rec_info.dsp_segment1 = p_dsp_segment1)
3902 OR ((rec_info.dsp_segment1 IS NULL) AND (p_dsp_segment1 is NULL)))
3903 AND ((rec_info.dsp_segment2 = p_dsp_segment2)
3904 OR ((rec_info.dsp_segment2 IS NULL) AND (p_dsp_segment2 is NULL)))
3905 AND ((rec_info.dsp_segment3 = p_dsp_segment3)
3906 OR ((rec_info.dsp_segment3 IS NULL) AND (p_dsp_segment3 is NULL)))
3907 AND ((rec_info.dsp_segment4 = p_dsp_segment4)
3908 OR ((rec_info.dsp_segment4 IS NULL) AND (p_dsp_segment4 is NULL)))
3909 AND ((rec_info.dsp_segment5 = p_dsp_segment5)
3910 OR ((rec_info.dsp_segment5 IS NULL) AND (p_dsp_segment5 is NULL)))
3911 AND ((rec_info.dsp_segment6 = p_dsp_segment6)
3912 OR ((rec_info.dsp_segment6 IS NULL) AND (p_dsp_segment6 is NULL)))
3913 AND ((rec_info.dsp_segment7 = p_dsp_segment7)
3914 OR ((rec_info.dsp_segment7 IS NULL) AND (p_dsp_segment7 is NULL)))
3915 AND ((rec_info.dsp_segment8 = p_dsp_segment8)
3916 OR ((rec_info.dsp_segment8 IS NULL) AND (p_dsp_segment8 is NULL)))
3917 AND ((rec_info.dsp_segment9 = p_dsp_segment9)
3918 OR ((rec_info.dsp_segment9 IS NULL) AND (p_dsp_segment9 is NULL)))
3919 AND ((rec_info.dsp_segment10 = p_dsp_segment10)
3920 OR ((rec_info.dsp_segment10 IS NULL) AND (p_dsp_segment10 is NULL)))
3921 AND ((rec_info.dsp_segment11 = p_dsp_segment11)
3922 OR ((rec_info.dsp_segment11 IS NULL) AND (p_dsp_segment11 is NULL)))
3923 AND ((rec_info.dsp_segment12 = p_dsp_segment12)
3924 OR ((rec_info.dsp_segment12 IS NULL) AND (p_dsp_segment12 is NULL)))
3925 AND ((rec_info.dsp_segment13 = p_dsp_segment13)
3926 OR ((rec_info.dsp_segment13 IS NULL) AND (p_dsp_segment13 is NULL)))
3927 AND ((rec_info.dsp_segment14 = p_dsp_segment14)
3928 OR ((rec_info.dsp_segment14 IS NULL) AND (p_dsp_segment14 is NULL)))
3929 AND ((rec_info.dsp_segment15 = p_dsp_segment15)
3930 OR ((rec_info.dsp_segment15 IS NULL) AND (p_dsp_segment15 is NULL)))
3931 AND ((rec_info.dsp_segment16 = p_dsp_segment16)
3932 OR ((rec_info.dsp_segment16 IS NULL) AND (p_dsp_segment16 is NULL)))
3933 AND ((rec_info.dsp_segment17 = p_dsp_segment17)
3934 OR ((rec_info.dsp_segment17 IS NULL) AND (p_dsp_segment17 is NULL)))
3935 AND ((rec_info.dsp_segment18 = p_dsp_segment18)
3936 OR ((rec_info.dsp_segment18 IS NULL) AND (p_dsp_segment18 is NULL)))
3937 AND ((rec_info.dsp_segment19 = p_dsp_segment19)
3938 OR ((rec_info.dsp_segment19 IS NULL) AND (p_dsp_segment19 is NULL)))
3939 AND ((rec_info.dsp_segment20 = p_dsp_segment20)
3940 OR ((rec_info.dsp_segment20 IS NULL) AND (p_dsp_segment20 is NULL)))
3941 AND ((rec_info.dsp_segment21 = p_dsp_segment21)
3942 OR ((rec_info.dsp_segment21 IS NULL) AND (p_dsp_segment21 is NULL)))
3943 AND ((rec_info.dsp_segment22 = p_dsp_segment22)
3944 OR ((rec_info.dsp_segment22 IS NULL) AND (p_dsp_segment22 is NULL)))
3945 AND ((rec_info.dsp_segment23 = p_dsp_segment23)
3946 OR ((rec_info.dsp_segment23 IS NULL) AND (p_dsp_segment23 is NULL)))
3947 AND ((rec_info.dsp_segment24 = p_dsp_segment24)
3948 OR ((rec_info.dsp_segment24 IS NULL) AND (p_dsp_segment24 is NULL)))
3949 AND ((rec_info.dsp_segment25 = p_dsp_segment25)
3950 OR ((rec_info.dsp_segment25 IS NULL) AND (p_dsp_segment25 is NULL)))
3951 AND ((rec_info.dsp_segment26 = p_dsp_segment26)
3952 OR ((rec_info.dsp_segment26 IS NULL) AND (p_dsp_segment26 is NULL)))
3953 AND ((rec_info.dsp_segment27 = p_dsp_segment27)
3954 OR ((rec_info.dsp_segment27 IS NULL) AND (p_dsp_segment27 is NULL)))
3955 AND ((rec_info.dsp_segment28 = p_dsp_segment28)
3956 OR ((rec_info.dsp_segment28 IS NULL) AND (p_dsp_segment28 is NULL)))
3957 AND ((rec_info.dsp_segment29 = p_dsp_segment29)
3958 OR ((rec_info.dsp_segment29 IS NULL) AND (p_dsp_segment29 is NULL)))
3959 AND ((rec_info.dsp_segment30 = p_dsp_segment30)
3960 OR ((rec_info.dsp_segment30 IS NULL) AND (p_dsp_segment30 is NULL)))
3961 AND ((rec_info.transaction_source_name = p_trx_source_name)
3962 OR ((rec_info.transaction_source_name IS NULL)
3963 AND (p_trx_source_type_id is NULL)))
3964 AND ((rec_info.transaction_source_type_id = p_trx_source_type_id)
3965 OR ((rec_info.transaction_source_type_id IS NULL)
3966 AND (p_trx_source_type_id is NULL)))
3967 AND ((rec_info.transaction_action_id = p_trx_action_id)
3968 OR ((rec_info.transaction_action_id IS NULL)
3969 AND (p_trx_action_id is NULL)))
3970 AND (rec_info.transaction_type_id = p_trx_type_id)
3971 AND ((rec_info.reason_id = p_reason_id)
3972 OR ((rec_info.reason_id IS NULL) AND (p_reason_id is NULL)))
3973 AND ((rec_info.transaction_reference = p_trx_reference)
3974 OR ((rec_info.transaction_reference IS NULL)
3975 AND (p_trx_reference is NULL)))
3976 AND ((rec_info.transaction_cost = p_trx_cost)
3977 OR ((rec_info.transaction_cost IS NULL) AND (p_trx_cost is NULL)))
3978 AND ((rec_info.distribution_account_id = p_distribution_acct_id)
3979 OR ((rec_info.distribution_account_id IS NULL)
3980 AND (p_distribution_acct_id is NULL)))
3981 AND ((rec_info.dst_segment1 = p_dst_segment1)
3982 OR ((rec_info.dst_segment1 IS NULL) AND (p_dst_segment1 is NULL)))
3983 AND ((rec_info.dst_segment2 = p_dst_segment2)
3984 OR ((rec_info.dst_segment2 IS NULL) AND (p_dst_segment2 is NULL)))
3985 AND ((rec_info.dst_segment3 = p_dst_segment3)
3986 OR ((rec_info.dst_segment3 IS NULL) AND (p_dst_segment3 is NULL)))
3987 AND ((rec_info.dst_segment4 = p_dst_segment4)
3988 OR ((rec_info.dst_segment4 IS NULL) AND (p_dst_segment4 is NULL)))
3989 AND ((rec_info.dst_segment5 = p_dst_segment5)
3990 OR ((rec_info.dst_segment5 IS NULL) AND (p_dst_segment5 is NULL)))
3991 AND ((rec_info.dst_segment6 = p_dst_segment6)
3992 OR ((rec_info.dst_segment6 IS NULL) AND (p_dst_segment6 is NULL)))
3993 AND ((rec_info.dst_segment7 = p_dst_segment7)
3994 OR ((rec_info.dst_segment7 IS NULL) AND (p_dst_segment7 is NULL)))
3995 AND ((rec_info.dst_segment8 = p_dst_segment8)
3996 OR ((rec_info.dst_segment8 IS NULL) AND (p_dst_segment8 is NULL)))
3997 AND ((rec_info.dst_segment9 = p_dst_segment9)
3998 OR ((rec_info.dst_segment9 IS NULL) AND (p_dst_segment9 is NULL)))
3999 AND ((rec_info.dst_segment10 = p_dst_segment10)
4000 OR ((rec_info.dst_segment10 IS NULL) AND (p_dst_segment10 is NULL)))
4001 AND ((rec_info.dst_segment11 = p_dst_segment11)
4002 OR ((rec_info.dst_segment11 IS NULL) AND (p_dst_segment11 is NULL)))
4003 AND ((rec_info.dst_segment12 = p_dst_segment12)
4004 OR ((rec_info.dst_segment12 IS NULL) AND (p_dst_segment12 is NULL)))
4005 AND ((rec_info.dst_segment13 = p_dst_segment13)
4006 OR ((rec_info.dst_segment13 IS NULL) AND (p_dst_segment13 is NULL)))
4007 AND ((rec_info.dst_segment14 = p_dst_segment14)
4008 OR ((rec_info.dst_segment14 IS NULL) AND (p_dst_segment14 is NULL)))
4009 AND ((rec_info.dst_segment15 = p_dst_segment15)
4010 OR ((rec_info.dst_segment15 IS NULL) AND (p_dst_segment15 is NULL)))
4011 AND ((rec_info.dst_segment16 = p_dst_segment16)
4012 OR ((rec_info.dst_segment16 IS NULL) AND (p_dst_segment16 is NULL)))
4013 AND ((rec_info.dst_segment17 = p_dst_segment17)
4014 OR ((rec_info.dst_segment17 IS NULL) AND (p_dst_segment17 is NULL)))
4015 AND ((rec_info.dst_segment18 = p_dst_segment18)
4016 OR ((rec_info.dst_segment18 IS NULL) AND (p_dst_segment18 is NULL)))
4017 AND ((rec_info.dst_segment19 = p_dst_segment19)
4018 OR ((rec_info.dst_segment19 IS NULL) AND (p_dst_segment19 is NULL)))
4019 AND ((rec_info.dst_segment20 = p_dst_segment20)
4020 OR ((rec_info.dst_segment20 IS NULL) AND (p_dst_segment20 is NULL)))
4021 AND ((rec_info.dst_segment21 = p_dst_segment21)
4022 OR ((rec_info.dst_segment21 IS NULL) AND (p_dst_segment21 is NULL)))
4023 AND ((rec_info.dst_segment22 = p_dst_segment22)
4024 OR ((rec_info.dst_segment22 IS NULL) AND (p_dst_segment22 is NULL)))
4025 AND ((rec_info.dst_segment23 = p_dst_segment23)
4026 OR ((rec_info.dst_segment23 IS NULL) AND (p_dst_segment23 is NULL)))
4027 AND ((rec_info.dst_segment24 = p_dst_segment24)
4028 OR ((rec_info.dst_segment24 IS NULL) AND (p_dst_segment24 is NULL)))
4029 AND ((rec_info.dst_segment25 = p_dst_segment25)
4030 OR ((rec_info.dst_segment25 IS NULL) AND (p_dst_segment25 is NULL)))
4031 AND ((rec_info.dst_segment26 = p_dst_segment26)
4032 OR ((rec_info.dst_segment26 IS NULL) AND (p_dst_segment26 is NULL)))
4033 AND ((rec_info.dst_segment27 = p_dst_segment27)
4034 OR ((rec_info.dst_segment27 IS NULL) AND (p_dst_segment27 is NULL)))
4035 AND ((rec_info.dst_segment28 = p_dst_segment28)
4036 OR ((rec_info.dst_segment28 IS NULL) AND (p_dst_segment28 is NULL)))
4037 AND ((rec_info.dst_segment29 = p_dst_segment29)
4038 OR ((rec_info.dst_segment29 IS NULL) AND (p_dst_segment29 is NULL)))
4039 AND ((rec_info.dst_segment30 = p_dst_segment30)
4040 OR ((rec_info.dst_segment30 IS NULL) AND (p_dst_segment30 is NULL)))
4041 AND ((rec_info.requisition_line_id = p_requisition_line_id)
4042 OR ((rec_info.requisition_line_id IS NULL)
4043 AND (p_requisition_line_id is NULL)))
4044 AND ((rec_info.currency_code = p_currency_code)
4045 OR ((rec_info.currency_code IS NULL) AND (p_currency_code is NULL)))
4046 AND ((rec_info.currency_conversion_date = p_currency_conversion_date)
4047 OR ((rec_info.currency_conversion_date IS NULL)
4048 AND (p_currency_conversion_date is NULL)))
4049 AND ((rec_info.currency_conversion_type = p_currency_conversion_type)
4050 OR ((rec_info.currency_conversion_type IS NULL)
4051 AND (p_currency_conversion_type is NULL)))
4052 AND ((rec_info.currency_conversion_rate = p_currency_conversion_rate)
4053 OR ((rec_info.currency_conversion_rate IS NULL)
4054 AND (p_currency_conversion_rate is NULL)))
4055 AND ((rec_info.ussgl_transaction_code = p_ussgl_transaction_code)
4056 OR ((rec_info.ussgl_transaction_code IS NULL)
4057 AND (p_ussgl_transaction_code is NULL)))
4058 AND ((rec_info.wip_entity_type = p_wip_entity_type)
4059 OR ((rec_info.wip_entity_type IS NULL)
4060 AND (p_wip_entity_type is NULL)))
4061 AND ((rec_info.schedule_id = p_schedule_id)
4062 OR ((rec_info.schedule_id IS NULL) AND (p_schedule_id is NULL)))
4063 AND ((rec_info.employee_code = p_employee_code)
4064 OR ((rec_info.employee_code IS NULL) AND (p_employee_code is NULL)))
4065 AND ((rec_info.department_id = p_department_id)
4066 OR ((rec_info.department_id IS NULL) AND (p_department_id is NULL)))
4067 AND ((rec_info.schedule_update_code = p_schedule_update_code)
4068 OR ((rec_info.schedule_update_code IS NULL)
4069 AND (p_schedule_update_code is NULL)))
4070 AND ((rec_info.setup_teardown_code = p_setup_teardown_code)
4071 OR ((rec_info.setup_teardown_code IS NULL)
4072 AND (p_setup_teardown_code is NULL)))
4073 AND ((rec_info.primary_switch = p_primary_switch)
4074 OR ((rec_info.primary_switch IS NULL)
4075 AND (p_primary_switch is NULL)))
4076 AND ((rec_info.mrp_code = p_mrp_code)
4077 OR ((rec_info.mrp_code IS NULL) AND (p_mrp_code is NULL)))
4078 AND ((rec_info.operation_seq_num = p_operation_seq_num)
4079 OR ((rec_info.operation_seq_num IS NULL)
4080 AND (p_operation_seq_num is NULL)))
4081 AND ((rec_info.repetitive_line_id = p_repetitive_line_id)
4082 OR ((rec_info.repetitive_line_id IS NULL)
4083 AND (p_repetitive_line_id is NULL)))
4084 AND ((rec_info.picking_line_id = p_picking_line_id)
4085 OR ((rec_info.picking_line_id IS NULL)
4086 AND (p_picking_line_id is NULL)))
4087 AND ((rec_info.trx_source_line_id = p_trx_source_line_id)
4088 OR ((rec_info.trx_source_line_id IS NULL)
4089 AND (p_trx_source_line_id is NULL)))
4090 AND ((rec_info.trx_source_delivery_id = p_trx_source_delivery_id)
4091 OR ((rec_info.trx_source_delivery_id IS NULL)
4092 AND (p_trx_source_delivery_id is NULL)))
4093 AND ((rec_info.demand_id = p_demand_id)
4094 OR ((rec_info.demand_id IS NULL) AND (p_demand_id is NULL)))
4095 AND ((rec_info.customer_ship_id = p_customer_ship_id)
4096 OR ((rec_info.customer_ship_id IS NULL)
4097 AND (p_customer_ship_id is NULL)))
4098 AND ((rec_info.line_item_num = p_line_item_num)
4099 OR ((rec_info.line_item_num IS NULL) AND (p_line_item_num is NULL)))
4100 AND ((rec_info.receiving_document = p_receiving_document)
4101 OR ((rec_info.receiving_document IS NULL)
4102 AND (p_receiving_document is NULL)))
4103 AND ((rec_info.rcv_transaction_id = p_rcv_transaction_id)
4104 OR ((rec_info.rcv_transaction_id IS NULL)
4105 AND (p_rcv_transaction_id is NULL)))
4106 AND ((rec_info.ship_to_location_id = p_ship_to_location_id)
4107 OR ((rec_info.ship_to_location_id IS NULL)
4108 AND (p_ship_to_location_id is NULL)))
4109 AND ((rec_info.encumbrance_account = p_encumbrance_account)
4110 OR ((rec_info.encumbrance_account IS NULL)
4111 AND (p_encumbrance_account is NULL)))
4112 AND ((rec_info.encumbrance_amount = p_encumbrance_amount)
4113 OR ((rec_info.encumbrance_amount IS NULL)
4114 AND (p_encumbrance_amount is NULL)))
4115 AND ((rec_info.vendor_lot_number = p_vendor_lot_number)
4116 OR ((rec_info.vendor_lot_number IS NULL)
4117 AND (p_vendor_lot_number is NULL)))
4118 AND ((rec_info.transfer_subinventory = p_transfer_subinventory)
4119 OR ((rec_info.transfer_subinventory IS NULL)
4120 AND (p_transfer_subinventory is NULL)))
4121 AND ((rec_info.transfer_organization = p_transfer_organization)
4122 OR ((rec_info.transfer_organization IS NULL)
4123 AND (p_transfer_organization is NULL)))
4124 AND ((rec_info.transfer_locator = p_transfer_locator)
4125 OR ((rec_info.transfer_locator IS NULL) AND (p_transfer_locator is NULL)))
4126 AND ((rec_info.xfer_loc_segment1 = p_xfer_loc_segment1)
4127 OR ((rec_info.xfer_loc_segment1 IS NULL)
4128 AND (p_xfer_loc_segment1 is NULL)))
4129 AND ((rec_info.xfer_loc_segment2 = p_xfer_loc_segment2)
4130 OR ((rec_info.xfer_loc_segment2 IS NULL)
4131 AND (p_xfer_loc_segment2 is NULL)))
4132 AND ((rec_info.xfer_loc_segment3 = p_xfer_loc_segment3)
4133 OR ((rec_info.xfer_loc_segment3 IS NULL)
4134 AND (p_xfer_loc_segment3 is NULL)))
4135 AND ((rec_info.xfer_loc_segment4 = p_xfer_loc_segment4)
4136 OR ((rec_info.xfer_loc_segment4 IS NULL)
4137 AND (p_xfer_loc_segment4 is NULL)))
4138 AND ((rec_info.xfer_loc_segment5 = p_xfer_loc_segment5)
4139 OR ((rec_info.xfer_loc_segment5 IS NULL)
4140 AND (p_xfer_loc_segment5 is NULL)))
4141 AND ((rec_info.xfer_loc_segment6 = p_xfer_loc_segment6)
4142 OR ((rec_info.xfer_loc_segment6 IS NULL)
4143 AND (p_xfer_loc_segment6 is NULL)))
4144 AND ((rec_info.xfer_loc_segment7 = p_xfer_loc_segment7)
4145 OR ((rec_info.xfer_loc_segment7 IS NULL)
4146 AND (p_xfer_loc_segment7 is NULL)))
4147 AND ((rec_info.xfer_loc_segment8 = p_xfer_loc_segment8)
4148 OR ((rec_info.xfer_loc_segment8 IS NULL)
4149 AND (p_xfer_loc_segment8 is NULL)))
4150 AND ((rec_info.xfer_loc_segment9 = p_xfer_loc_segment9)
4151 OR ((rec_info.xfer_loc_segment9 IS NULL)
4152 AND (p_xfer_loc_segment9 is NULL)))
4153 AND ((rec_info.xfer_loc_segment10 = p_xfer_loc_segment10)
4154 OR ((rec_info.xfer_loc_segment10 IS NULL)
4155 AND (p_xfer_loc_segment10 is NULL)))
4156 AND ((rec_info.xfer_loc_segment11 = p_xfer_loc_segment11)
4157 OR ((rec_info.xfer_loc_segment11 IS NULL)
4158 AND (p_xfer_loc_segment11 is NULL)))
4159 AND ((rec_info.xfer_loc_segment12 = p_xfer_loc_segment12)
4160 OR ((rec_info.xfer_loc_segment12 IS NULL)
4161 AND (p_xfer_loc_segment12 is NULL)))
4162 AND ((rec_info.xfer_loc_segment13 = p_xfer_loc_segment13)
4163 OR ((rec_info.xfer_loc_segment13 IS NULL)
4164 AND (p_xfer_loc_segment13 is NULL)))
4165 AND ((rec_info.xfer_loc_segment14 = p_xfer_loc_segment14)
4166 OR ((rec_info.xfer_loc_segment14 IS NULL)
4167 AND (p_xfer_loc_segment14 is NULL)))
4168 AND ((rec_info.xfer_loc_segment15 = p_xfer_loc_segment15)
4169 OR ((rec_info.xfer_loc_segment15 IS NULL)
4170 AND (p_xfer_loc_segment15 is NULL)))
4171 AND ((rec_info.xfer_loc_segment16 = p_xfer_loc_segment16)
4172 OR ((rec_info.xfer_loc_segment16 IS NULL)
4173 AND (p_xfer_loc_segment16 is NULL)))
4174 AND ((rec_info.xfer_loc_segment17 = p_xfer_loc_segment17)
4175 OR ((rec_info.xfer_loc_segment17 IS NULL)
4176 AND (p_xfer_loc_segment17 is NULL)))
4177 AND ((rec_info.xfer_loc_segment18 = p_xfer_loc_segment18)
4178 OR ((rec_info.xfer_loc_segment18 IS NULL)
4179 AND (p_xfer_loc_segment18 is NULL)))
4180 AND ((rec_info.xfer_loc_segment19 = p_xfer_loc_segment19)
4181 OR ((rec_info.xfer_loc_segment19 IS NULL)
4182 AND (p_xfer_loc_segment19 is NULL)))
4183 AND ((rec_info.xfer_loc_segment20 = p_xfer_loc_segment20)
4184 OR ((rec_info.xfer_loc_segment20 IS NULL)
4185 AND (p_xfer_loc_segment20 is NULL)))
4186 AND ((rec_info.shipment_number = p_shipment_number)
4187 OR ((rec_info.shipment_number IS NULL)
4188 AND (p_shipment_number is NULL)))
4189 AND ((rec_info.transportation_cost = p_transportation_cost)
4190 OR ((rec_info.transportation_cost IS NULL)
4191 AND (p_transportation_cost is NULL)))
4192 AND ((rec_info.transportation_account = p_transportation_account)
4193 OR ((rec_info.transportation_account IS NULL)
4194 AND (p_transportation_account is NULL)))
4195 AND ((rec_info.transfer_cost = p_transfer_cost)
4196 OR ((rec_info.transfer_cost IS NULL) AND (p_transfer_cost is NULL)))
4197 AND ((rec_info.freight_code = p_freight_code)
4198 OR ((rec_info.freight_code IS NULL) AND (p_freight_code is NULL)))
4199 AND ((rec_info.containers = p_containers)
4200 OR ((rec_info.containers IS NULL) AND (p_containers is NULL)))
4201 AND ((rec_info.waybill_airbill = p_waybill_airbill)
4202 OR ((rec_info.waybill_airbill IS NULL)
4203 AND (p_waybill_airbill is NULL)))
4204 AND ((rec_info.expected_arrival_date = p_expected_arrival_date)
4205 OR ((rec_info.expected_arrival_date IS NULL)
4206 AND (p_expected_arrival_date is NULL)))
4207 AND ((rec_info.new_average_cost = p_new_average_cost)
4208 OR ((rec_info.new_average_cost IS NULL)
4209 AND (p_new_average_cost is NULL)))
4210 AND ((rec_info.value_change = p_value_change)
4211 OR ((rec_info.value_change IS NULL) AND (p_value_change is NULL)))
4212 AND ((rec_info.percentage_change = p_percentage_change)
4213 OR ((rec_info.percentage_change IS NULL)
4214 AND (p_percentage_change is NULL)))
4215 AND ((rec_info.demand_source_header_id = p_demand_source_header_id)
4216 OR ((rec_info.demand_source_header_id IS NULL)
4217 AND (p_demand_source_header_id is NULL)))
4218 AND ((rec_info.demand_source_line = p_demand_source_line)
4219 OR ((rec_info.demand_source_line IS NULL)
4220 AND (p_demand_source_line is NULL)))
4221 AND ((rec_info.demand_source_delivery = p_demand_source_delivery)
4222 OR ((rec_info.demand_source_delivery IS NULL)
4223 AND (p_demand_source_delivery is NULL)))
4224 AND ((rec_info.negative_req_flag = p_negative_req_flag)
4225 OR ((rec_info.negative_req_flag IS NULL)
4226 AND (p_negative_req_flag is NULL)))
4227 AND ((rec_info.error_explanation = p_error_explanation)
4228 OR ((rec_info.error_explanation IS NULL)
4229 AND (p_error_explanation is NULL)))
4230 AND ((rec_info.shippable_flag = p_shippable_flag)
4231 OR ((rec_info.shippable_flag IS NULL)
4232 AND (p_shippable_flag is NULL)))
4233 AND ((rec_info.error_code = p_error_code)
4234 OR ((rec_info.error_code IS NULL) AND (p_error_code is NULL)))
4235 AND ((rec_info.required_flag = p_required_flag)
4236 OR ((rec_info.required_flag IS NULL) AND (p_required_flag is NULL)))
4237 AND ((rec_info.attribute_category = p_attribute_category)
4238 OR ((rec_info.attribute_category IS NULL)
4239 AND (p_attribute_category is NULL)))
4240 AND ((rec_info.attribute1 = p_attribute1)
4241 OR ((rec_info.attribute1 IS NULL) AND (p_attribute1 is NULL)))
4242 AND ((rec_info.attribute2 = p_attribute2)
4243 OR ((rec_info.attribute2 IS NULL) AND (p_attribute2 is NULL)))
4244 AND ((rec_info.attribute3 = p_attribute3)
4245 OR ((rec_info.attribute3 IS NULL) AND (p_attribute3 is NULL)))
4246 AND ((rec_info.attribute4 = p_attribute4)
4247 OR ((rec_info.attribute4 IS NULL) AND (p_attribute4 is NULL)))
4248 AND ((rec_info.attribute5 = p_attribute5)
4249 OR ((rec_info.attribute5 IS NULL) AND (p_attribute5 is NULL)))
4250 AND ((rec_info.attribute6 = p_attribute6)
4251 OR ((rec_info.attribute6 IS NULL) AND (p_attribute6 is NULL)))
4252 AND ((rec_info.attribute7 = p_attribute7)
4253 OR ((rec_info.attribute7 IS NULL) AND (p_attribute7 is NULL)))
4254 AND ((rec_info.attribute8 = p_attribute8)
4255 OR ((rec_info.attribute8 IS NULL) AND (p_attribute8 is NULL)))
4256 AND ((rec_info.attribute9 = p_attribute9)
4257 OR ((rec_info.attribute9 IS NULL) AND (p_attribute9 is NULL)))
4258 AND ((rec_info.attribute10 = p_attribute10)
4259 OR ((rec_info.attribute10 IS NULL) AND (p_attribute10 is NULL)))
4260 AND ((rec_info.attribute11 = p_attribute11)
4261 OR ((rec_info.attribute11 IS NULL) AND (p_attribute11 is NULL)))
4262 AND ((rec_info.attribute12 = p_attribute12)
4263 OR ((rec_info.attribute12 IS NULL) AND (p_attribute12 is NULL)))
4264 AND ((rec_info.attribute13 = p_attribute13)
4265 OR ((rec_info.attribute13 IS NULL) AND (p_attribute13 is NULL)))
4266 AND ((rec_info.attribute14 = p_attribute14)
4267 OR ((rec_info.attribute14 IS NULL) AND (p_attribute14 is NULL)))
4268 AND ((rec_info.attribute15 = p_attribute15)
4269 OR ((rec_info.attribute15 IS NULL) AND (p_attribute15 is NULL)))
4270 AND ((rec_info.requisition_distribution_id = p_requisition_distribution_id)
4271 OR ((rec_info.requisition_distribution_id IS NULL)
4272 AND (p_requisition_distribution_id is NULL)))
4273 AND ((rec_info.movement_id = p_movement_id)
4274 OR ((rec_info.movement_id IS NULL) AND (p_movement_id is NULL)))
4275 AND ((rec_info.reservation_quantity = p_reservation_quantity)
4276 OR ((rec_info.reservation_quantity IS NULL)
4277 AND (p_reservation_quantity is NULL)))
4278 AND ((rec_info.shipped_quantity = p_shipped_quantity)
4279 OR ((rec_info.shipped_quantity IS NULL)
4280 AND (p_shipped_quantity is NULL)))
4281 AND ((rec_info.inventory_item = p_inventory_item)
4282 OR ((rec_info.inventory_item IS NULL)
4283 AND (p_inventory_item is NULL)))
4284 AND ((rec_info.locator_name = p_locator_name)
4285 OR ((rec_info.locator_name IS NULL) AND (p_locator_name is NULL)))
4286 AND ((rec_info.task_id = p_task_id)
4287 OR ((rec_info.task_id IS NULL) AND (p_task_id is NULL)))
4288 AND ((rec_info.to_task_id = p_to_task_id)
4289 OR ((rec_info.to_task_id IS NULL) AND (p_to_task_id is NULL)))
4290 AND ((rec_info.source_task_id = p_source_task_id)
4291 OR ((rec_info.source_task_id IS NULL)
4292 AND (p_source_task_id is NULL)))
4293 AND ((rec_info.project_id = p_project_id)
4294 OR ((rec_info.project_id IS NULL) AND (p_project_id is NULL)))
4295 AND ((rec_info.to_project_id = p_to_project_id)
4296 OR ((rec_info.to_project_id IS NULL) AND (p_to_project_id is NULL)))
4297 AND ((rec_info.source_project_id = p_source_project_id)
4298 OR ((rec_info.source_project_id IS NULL) AND (p_source_project_id is NULL)))
4299 AND ((rec_info.pa_expenditure_org_id = p_pa_expenditure_org_id)
4300 OR ((rec_info.pa_expenditure_org_id IS NULL)
4301 AND (p_pa_expenditure_org_id is NULL)))
4302 AND ((rec_info.expenditure_type = p_expenditure_type)
4303 OR ((rec_info.expenditure_type IS NULL) AND (p_expenditure_type is NULL)))
4304 AND ((rec_info.final_completion_flag = p_final_completion_flag)
4305 OR ((rec_info.final_completion_flag IS NULL)
4306 AND (p_final_completion_flag is NULL)))
4307 AND ((rec_info.transfer_percentage = p_transfer_percentage)
4308 OR ((rec_info.transfer_percentage IS NULL)
4309 AND (p_transfer_percentage is NULL)))
4310 AND ((rec_info.transaction_sequence_id = p_trx_sequence_id)
4311 OR ((rec_info.transaction_sequence_id IS NULL)
4312 AND (p_trx_sequence_id is NULL)))
4313 AND ((rec_info.material_account = p_material_account)
4314 OR ((rec_info.material_account IS NULL)
4315 AND (p_material_account is NULL)))
4316 AND ((rec_info.material_overhead_account = p_material_overhead_account)
4317 OR ((rec_info.material_overhead_account IS NULL)
4318 AND (p_material_overhead_account is NULL)))
4319 AND ((rec_info.resource_account = p_resource_account)
4320 OR ((rec_info.resource_account IS NULL)
4321 AND (p_resource_account is NULL)))
4322 AND ((rec_info.outside_processing_account = p_outside_processing_account)
4323 OR ((rec_info.outside_processing_account IS NULL)
4324 AND (p_outside_processing_account is NULL)))
4325 AND ((rec_info.overhead_account = p_overhead_account)
4326 OR ((rec_info.overhead_account IS NULL)
4327 AND (p_overhead_account is NULL)))
4328 AND ((rec_info.bom_revision = p_bom_revision)
4329 OR ((rec_info.bom_revision IS NULL) AND (p_bom_revision is NULL)))
4330 AND ((rec_info.routing_revision = p_routing_revision)
4331 OR ((rec_info.routing_revision IS NULL)
4332 AND (p_routing_revision is NULL)))
4333 AND ((rec_info.bom_revision_date = p_bom_revision_date)
4334 OR ((rec_info.bom_revision_date IS NULL)
4335 AND (p_bom_revision_date is NULL)))
4336 AND ((rec_info.routing_revision_date = p_routing_revision_date)
4337 OR ((rec_info.routing_revision_date IS NULL)
4338 AND (p_routing_revision_date is NULL)))
4339 AND ((rec_info.alternate_bom_designator = p_alternate_bom_designator)
4340 OR ((rec_info.alternate_bom_designator IS NULL)
4341 AND (p_alternate_bom_designator is NULL)))
4342 AND ((rec_info.alternate_routing_designator = p_alternate_routing_designator)
4343 OR ((rec_info.alternate_routing_designator IS NULL)
4344 AND (p_alternate_routing_designator is NULL)))
4345 AND ((rec_info.accounting_class = p_accounting_class)
4346 OR ((rec_info.accounting_class IS NULL)
4347 AND (p_accounting_class is NULL)))
4348 AND ((rec_info.demand_class = p_demand_class)
4349 OR ((rec_info.demand_class IS NULL) AND (p_demand_class is NULL)))
4350 AND ((rec_info.parent_id = p_parent_id)
4351 OR ((rec_info.parent_id IS NULL) AND (p_parent_id is NULL)))
4352 AND ((rec_info.substitution_type_id = p_substitution_type_id)
4353 OR ((rec_info.substitution_type_id IS NULL)
4354 AND (p_substitution_type_id is NULL)))
4355 AND ((rec_info.substitution_item_id = p_substitution_item_id)
4356 OR ((rec_info.substitution_item_id IS NULL)
4357 AND (p_substitution_item_id is NULL)))
4358 AND ((rec_info.schedule_group = p_schedule_group)
4359 OR ((rec_info.schedule_group IS NULL)
4360 AND (p_schedule_group is NULL)))
4361 AND ((rec_info.build_sequence = p_build_sequence)
4362 OR ((rec_info.build_sequence IS NULL)
4363 AND (p_build_sequence is NULL)))
4364 AND ((rec_info.schedule_number = p_schedule_number)
4365 OR ((rec_info.schedule_number IS NULL)
4366 AND (p_schedule_number is NULL)))
4367 AND ((rec_info.scheduled_flag = p_scheduled_flag)
4368 OR ((rec_info.scheduled_flag IS NULL)
4369 AND (p_scheduled_flag is NULL)))
4370 AND ((rec_info.flow_schedule = p_flow_schedule)
4371 OR ((rec_info.flow_schedule IS NULL) AND (p_flow_schedule is NULL)))
4372 AND ((rec_info.cost_group_id = p_cost_group_id)
4373 OR ((rec_info.cost_group_id IS NULL) AND (p_cost_group_id IS NULL)))
4374
4375 -- HW OPMCONV. Added secondary_qty and secondary_uom
4376 AND ((rec_info.SECONDARY_UOM_CODE = p_secondary_uom_code)
4377 OR ((rec_info.SECONDARY_UOM_CODE IS NULL) AND (p_secondary_uom_code IS NULL)))
4378 AND ((rec_info.SECONDARY_TRANSACTION_QUANTITY = p_secondary_trx_quantity)
4379 OR ((rec_info.SECONDARY_TRANSACTION_QUANTITY IS NULL) AND (p_secondary_trx_quantity IS NULL)))
4380 ) THEN
4381 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
4382 'END',
4383 'End of procedure LOCK_ROW');
4384 */
4385 --
4386 IF l_debug_on THEN
4387 WSH_DEBUG_SV.pop(l_module_name,'Nothing Changed');
4388 END IF;
4389 --
4390 return;
4391 ELSE
4392 /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
4393 'END',
4394 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
4395 */
4396 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
4397 IF l_debug_on THEN
4398 WSH_DEBUG_SV.pop(l_module_name,'FORM_RECORD_CHANGED');
4399 END IF;
4400 app_exception.raise_exception;
4401 END IF;
4402
4403 --
4404 IF l_debug_on THEN
4405 WSH_DEBUG_SV.pop(l_module_name);
4406 END IF;
4407 --
4408 END Lock_Row;
4409
4410 END WSH_TRX_HANDLER;