[Home] [Help]
PACKAGE BODY: APPS.INV_CALCULATE_EXP_DATE
Source
1 PACKAGE BODY INV_CALCULATE_EXP_DATE AS
2 /* $Header: INVCEDTB.pls 120.6.12020000.2 2012/07/09 08:04:02 asugandh ship $ */
3
4 g_pkg_name VARCHAR2(80) := 'INV_CALCULATE_EXP_DATE';
5 l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6
7 PROCEDURE mydebug( p_msg IN VARCHAR2
8 ,p_module IN VARCHAR2 DEFAULT NULL)
9 IS
10 BEGIN
11
12 IF (l_debug = 1) THEN
13 inv_log_util.trace( p_message => p_msg,
14 p_module => g_pkg_name ||'.'||p_module ,
15 p_level => 9);
16 END IF;
17
18 --dbms_output.put_line( p_msg );
19 END mydebug;
20
21 -- Function used to get the transaciton id for row inserted in MTI and MMTT
22 FUNCTION get_txn_id ( p_table IN NUMBER) RETURN NUMBER IS
23 BEGIN
24 IF p_table = 1 THEN
25 IF g_mti_txn_id IS NOT NULL THEN
26 RETURN g_mti_txn_id;
27 ELSE
28 RETURN -1;
29 END IF;
30 ELSE
31 IF g_mmtt_txn_id IS NOT NULL THEN
32 RETURN g_mmtt_txn_id;
33 ELSE
34 RETURN -1;
35 END IF;
36 END IF;
37 EXCEPTION
38 WHEN OTHERS THEN
39 IF (l_debug = 1) THEN
40 mydebug('WHEN OTHERS exception : '||SQLERRM, 'GET_TXN_ID');
41 END IF;
42 RETURN -1;
43 END get_txn_id;
44
45 -- Function used to get the transaciton id for row inserted in MTLI and MTLT
46 FUNCTION get_lot_txn_id ( p_table IN NUMBER) RETURN ROWID IS
47 BEGIN
48 IF p_table = 1 THEN
49 IF g_mtli_txn_id IS NOT NULL THEN
50 RETURN g_mtli_txn_id;
51 ELSE
52 RETURN '-1';
53 END IF;
54 ELSE
55 IF g_mtlt_txn_id IS NOT NULL THEN
56 RETURN g_mtlt_txn_id;
57 ELSE
58 RETURN '-1';
59 END IF;
60 END IF;
61 EXCEPTION
62 WHEN OTHERS THEN
63 IF (l_debug = 1) THEN
64 mydebug('WHEN OTHERS exception : '||SQLERRM, 'GET_TXN_ID');
65 END IF;
66 RETURN '-1';
67 END get_lot_txn_id;
68
69 -- Function used to set the transaciton id for row inserted in MTI and MMTT
70 PROCEDURE set_txn_id ( p_table IN NUMBER,
71 p_header_id IN NUMBER) IS
72 BEGIN
73 IF p_table = 1 THEN
74 g_mti_txn_id := p_header_id;
75 ELSE
76 g_mmtt_txn_id := p_header_id;
77 END IF;
78 EXCEPTION
79 WHEN OTHERS THEN NULL;
80 END set_txn_id;
81
82 -- Function used to set the transaciton id for row inserted in MTLI and MTLT
83 PROCEDURE set_lot_txn_id ( p_table IN NUMBER,
87 g_mtli_txn_id := p_header_id;
84 p_header_id IN ROWID) IS
85 BEGIN
86 IF p_table = 1 THEN
88 ELSE
89 g_mtlt_txn_id := p_header_id;
90 END IF;
91 EXCEPTION
92 WHEN OTHERS THEN NULL;
93 END set_lot_txn_id;
94
95 -- Function used to reset all transaciton id for rows inserted in MTI, MMTT, MTLI and MTLT
96 PROCEDURE reset_header_id IS
97 BEGIN
98 g_mti_txn_id := -1;
99 g_mtli_txn_id := '-1';
100 g_mmtt_txn_id := -1;
101 g_mtlt_txn_id := '-1';
102 END reset_header_id;
103
104 -- Function used to populate MTI record. Data stored in this table can be used during Custom Lot Expiration Calc.
105 PROCEDURE assign_mti_rec (
106 p_inventory_item_id IN NUMBER
107 , p_revision IN VARCHAR2
108 , p_organization_id IN NUMBER
109 , p_transaction_action_id IN NUMBER
110 , p_subinventory_code IN VARCHAR2
111 , p_locator_id IN NUMBER
112 , p_transaction_type_id IN NUMBER
113 , p_trx_source_type_id IN NUMBER
114 , p_transaction_quantity IN NUMBER
115 , p_primary_quantity IN NUMBER
116 , p_transaction_uom IN VARCHAR2
117 , p_ship_to_location IN NUMBER
118 , p_reason_id IN NUMBER
119 , p_user_id IN NUMBER
120 , p_transfer_lpn_id IN NUMBER
121 , p_transaction_source_id IN NUMBER
122 , p_trx_source_line_id IN NUMBER
123 , p_project_id IN NUMBER
124 , p_task_id IN NUMBER
125 , p_planning_organization_id IN NUMBER
126 , p_planning_tp_type IN NUMBER
127 , p_owning_organization_id IN NUMBER
128 , p_owning_tp_type IN NUMBER
129 , p_distribution_account_id IN NUMBER
130 , p_sec_transaction_quantity IN NUMBER
131 , p_secondary_uom_code IN VARCHAR2
132 , x_return_status OUT NOCOPY VARCHAR2
133 ) IS
134 BEGIN
135 x_return_status := FND_API.G_RET_STS_SUCCESS;
136
137 IF g_mti_tbl.COUNT > 0 THEN
138 g_mti_tbl.DELETE;
139 END IF;
140
141 g_mti_tbl(0).inventory_item_id := p_inventory_item_id;
142 g_mti_tbl(0).revision := p_revision;
143 g_mti_tbl(0).organization_id := p_organization_id;
144 g_mti_tbl(0).transaction_action_id := p_transaction_action_id;
145 g_mti_tbl(0).subinventory_code := p_subinventory_code;
146 g_mti_tbl(0).locator_id := p_locator_id;
147 g_mti_tbl(0).transaction_type_id := p_transaction_type_id;
148 g_mti_tbl(0).transaction_source_type_id := p_trx_source_type_id;
149 g_mti_tbl(0).transaction_quantity := p_transaction_quantity;
150 g_mti_tbl(0).primary_quantity := p_primary_quantity;
151 g_mti_tbl(0).transaction_uom := p_transaction_uom;
152 g_mti_tbl(0).ship_to_location_id := p_ship_to_location;
153 g_mti_tbl(0).reason_id := p_reason_id;
154 g_mti_tbl(0).transfer_lpn_id := p_transfer_lpn_id;
155 g_mti_tbl(0).transaction_source_id := p_transaction_source_id;
156 g_mti_tbl(0).trx_source_line_id := p_trx_source_line_id;
157 g_mti_tbl(0).project_id := p_project_id;
158 g_mti_tbl(0).task_id := p_task_id;
159 g_mti_tbl(0).planning_organization_id := p_planning_organization_id;
160 g_mti_tbl(0).planning_tp_type := p_planning_tp_type;
161 g_mti_tbl(0).owning_organization_id := p_owning_organization_id;
162 g_mti_tbl(0).owning_tp_type := p_owning_tp_type;
163 g_mti_tbl(0).distribution_account_id := p_distribution_account_id;
164 g_mti_tbl(0).secondary_transaction_quantity := p_sec_transaction_quantity;
165 g_mti_tbl(0).secondary_uom_code := p_secondary_uom_code;
166
167 EXCEPTION
168 WHEN OTHERS THEN
169 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170 IF (l_debug = 1) THEN
171 mydebug('WHEN OTHERS exception : '||SQLERRM, 'GET_TXN_ID');
172 END IF;
173 END assign_mti_rec;
174
175 -- Function used to get populated MTI table populated by assign_mti_rec Procedure.
176 FUNCTION get_mti_tbl RETURN mti_tab IS
177 BEGIN
178 RETURN g_mti_tbl;
179 END get_mti_tbl;
180
181 -- Function used to purge populated MTI table populated by assign_mti_rec Procedure.
182 PROCEDURE purge_mti_tab IS
183 BEGIN
184 IF g_mti_tbl.COUNT > 0 THEN
185 g_mti_tbl.DELETE;
186 END IF;
187 END purge_mti_tab;
188
189 -- Function used to populate MMTT record. Data stored in this table can be used during Custom Lot Expiration Calc.
190 PROCEDURE assign_mmtt_rec (
191 p_inventory_item_id IN NUMBER
192 , p_revision IN VARCHAR2
193 , p_organization_id IN NUMBER
194 , p_transaction_action_id IN NUMBER
195 , p_subinventory_code IN VARCHAR2
196 , p_locator_id IN NUMBER
200 , p_primary_quantity IN NUMBER
197 , p_transaction_type_id IN NUMBER
198 , p_trx_source_type_id IN NUMBER
199 , p_transaction_quantity IN NUMBER
201 , p_transaction_uom IN VARCHAR2
202 , p_ship_to_location IN NUMBER
203 , p_reason_id IN NUMBER
204 , p_user_id IN NUMBER
205 , p_transfer_lpn_id IN NUMBER
206 , p_transaction_source_id IN NUMBER
207 , p_transaction_cost IN NUMBER
208 , p_project_id IN NUMBER
209 , p_task_id IN NUMBER
210 , p_planning_organization_id IN NUMBER
211 , p_planning_tp_type IN NUMBER
212 , p_owning_organization_id IN NUMBER
213 , p_owning_tp_type IN NUMBER
214 , p_distribution_account_id IN NUMBER
215 , p_sec_transaction_quantity IN NUMBER
216 , p_secondary_uom_code IN VARCHAR2
217 , x_return_status OUT NOCOPY VARCHAR2
218 ) IS
219 BEGIN
220 x_return_status := FND_API.G_RET_STS_SUCCESS;
221
222 IF g_mmtt_tbl.COUNT > 0 THEN
223 g_mmtt_tbl.DELETE;
224 END IF;
225
226 g_mmtt_tbl(0).inventory_item_id := p_inventory_item_id;
227 g_mmtt_tbl(0).revision := p_revision;
228 g_mmtt_tbl(0).organization_id := p_organization_id;
229 g_mmtt_tbl(0).transaction_action_id := p_transaction_action_id;
230 g_mmtt_tbl(0).subinventory_code := p_subinventory_code;
231 g_mmtt_tbl(0).locator_id := p_locator_id;
232 g_mmtt_tbl(0).transaction_type_id := p_transaction_type_id;
233 g_mmtt_tbl(0).transaction_source_type_id := p_trx_source_type_id;
234 g_mmtt_tbl(0).transaction_quantity := p_transaction_quantity;
235 g_mmtt_tbl(0).primary_quantity := p_primary_quantity;
236 g_mmtt_tbl(0).transaction_uom := p_transaction_uom;
237 g_mmtt_tbl(0).ship_to_location := p_ship_to_location;
238 g_mmtt_tbl(0).reason_id := p_reason_id;
239 g_mmtt_tbl(0).transfer_lpn_id := p_transfer_lpn_id;
240 g_mmtt_tbl(0).transaction_source_id := p_transaction_source_id;
241 g_mmtt_tbl(0).transaction_cost := p_transaction_cost;
242 g_mmtt_tbl(0).project_id := p_project_id;
243 g_mmtt_tbl(0).task_id := p_task_id;
244 g_mmtt_tbl(0).planning_organization_id := p_planning_organization_id;
245 g_mmtt_tbl(0).planning_tp_type := p_planning_tp_type;
246 g_mmtt_tbl(0).owning_organization_id := p_owning_organization_id;
247 g_mmtt_tbl(0).owning_tp_type := p_owning_tp_type;
248 g_mmtt_tbl(0).distribution_account_id := p_distribution_account_id;
249 g_mmtt_tbl(0).secondary_transaction_quantity := p_sec_transaction_quantity;
250 g_mmtt_tbl(0).secondary_uom_code := p_secondary_uom_code;
251
252 EXCEPTION
253 WHEN OTHERS THEN
254 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255 IF (l_debug = 1) THEN
256 mydebug('WHEN OTHERS exception : '||SQLERRM, 'GET_TXN_ID');
257 END IF;
258 END assign_mmtt_rec;
259
260 -- Function used to get populated MMTT table populated by assign_mmtt_rec Procedure.
261 FUNCTION get_mmtt_tbl RETURN mmtt_tab IS
262 BEGIN
263 RETURN g_mmtt_tbl;
264 END get_mmtt_tbl;
265
266 -- Function used to purge populated MMTT table populated by assign_mmtt_rec Procedure.
267 PROCEDURE purge_mmtt_tab IS
268 BEGIN
269 IF g_mmtt_tbl.COUNT > 0 THEN
270 g_mmtt_tbl.DELETE;
271 END IF;
272 END purge_mmtt_tab;
273
274 -- Procedure to query the primary onhand qty of lot. If this is zero and origination date null,
275 -- system will default the lot attributes and will update the lot record.
276 PROCEDURE get_lot_primary_onhand
277 ( p_inventory_item_id IN NUMBER
278 ,p_organization_id IN NUMBER
279 ,p_lot_number IN VARCHAR2
280 ,x_onhand OUT NOCOPY NUMBER
281 ,x_return_status OUT NOCOPY VARCHAR2
282 ,x_msg_count OUT NOCOPY NUMBER
283 ,x_msg_data OUT NOCOPY VARCHAR2
284 ) IS
285 l_rqoh NUMBER;
286 l_qr NUMBER;
287 l_qs NUMBER;
288 l_att NUMBER;
289 l_atr NUMBER;
290 l_sqoh NUMBER;
291 l_satt NUMBER;
292 l_satr NUMBER;
293 l_srqoh NUMBER;
294 l_sqr NUMBER;
295 l_sqs NUMBER;
296 BEGIN
297 inv_quantity_tree_pub.query_quantities
298 (
299 p_api_version_number => 1.0
300 , p_init_msg_lst => 'T'
301 , x_return_status => x_return_status
302 , x_msg_count => x_msg_count
303 , x_msg_data => x_msg_data
304 , p_organization_id => p_organization_id
305 , p_inventory_item_id => p_inventory_item_id
306 , p_tree_mode => 1
307 , p_is_revision_control => FALSE
308 , p_is_lot_control => TRUE
309 , p_is_serial_control => FALSE
310 , p_revision => NULL
311 , p_lot_number => p_lot_number
312 , p_subinventory_code => NULL
316 , x_rqoh => l_rqoh
313 , p_locator_id => NULL
314 , p_onhand_source => 3
315 , x_qoh => x_onhand
317 , x_qr => l_qr
318 , x_qs => l_qs
319 , x_att => l_att
320 , x_atr => l_atr
321 , p_grade_code => NULL
322 , x_sqoh => l_sqoh
323 , x_satt => l_satt
324 , x_satr => l_satr
325 , x_srqoh => l_srqoh
326 , x_sqr => l_sqr
327 , x_sqs => l_sqs
328 , p_lpn_id => NULL
329 );
330 END get_lot_primary_onhand;
331
332 -- Procedure to query the origination date of lot. If this is null and primary qty zero,
333 -- system will default the lot attributes and will update the lot record.
334 PROCEDURE get_origination_date
335 ( p_inventory_item_id IN NUMBER
336 ,p_organization_id IN NUMBER
337 ,p_lot_number IN VARCHAR2
338 ,x_orig_date OUT NOCOPY DATE
339 ,x_return_status OUT NOCOPY VARCHAR2
340 ) IS
341 PRAGMA AUTONOMOUS_TRANSACTION; /* Bug# 13028193 Added PRAGMA to get the actual value from DB as changes in session not yet reflected */
342 orig_date DATE;
343 BEGIN
344 x_return_status := FND_API.G_RET_STS_SUCCESS;
345 BEGIN /*begin segment 2 */
346 SELECT origination_date
347 INTO x_orig_date
348 FROM mtl_lot_numbers
349 WHERE inventory_item_id = p_inventory_item_id
350 AND lot_number = p_lot_number
351 AND organization_id = p_organization_id;
352 EXCEPTION
353 WHEN no_data_found THEN
354 BEGIN /*begin segment 3*/
355 SELECT a.origination_date
356 INTO x_orig_date
357 FROM mtl_transaction_lots_temp a
358 , mtl_material_transactions_temp b
359 WHERE b.inventory_item_id = p_inventory_item_id
360 AND a.lot_number = p_lot_number
361 AND a.transaction_temp_id = b.transaction_temp_id
362 AND ROWNUM = 1
363 AND b.organization_id = p_organization_id;
364 EXCEPTION
365 WHEN OTHERS THEN
366 x_orig_date := NULL;
367 END;
368 WHEN OTHERS THEN
369 x_orig_date := NULL;
370 END;
371 EXCEPTION
372 WHEN OTHERS THEN
373 x_orig_date := NULL;
374 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375 END get_origination_date;
376
377 --Bug 13992231,Get origination_date from session level.
378 PROCEDURE get_origination_date_session
379 ( p_inventory_item_id IN NUMBER
380 ,p_organization_id IN NUMBER
381 ,p_lot_number IN VARCHAR2
382 ,x_orig_date OUT NOCOPY DATE
383 ,x_return_status OUT NOCOPY VARCHAR2
384 ) IS
385 --PRAGMA AUTONOMOUS_TRANSACTION; --Comment PRAGMA AUTONOMOUS_TRANSACTION,For some cases,We need get origination date from sesson level.
386 orig_date DATE;
387 BEGIN
388 x_return_status := FND_API.G_RET_STS_SUCCESS;
389 BEGIN /*begin segment 2 */
390 SELECT origination_date
391 INTO x_orig_date
392 FROM mtl_lot_numbers
393 WHERE inventory_item_id = p_inventory_item_id
394 AND lot_number = p_lot_number
395 AND organization_id = p_organization_id;
396 EXCEPTION
397 WHEN no_data_found THEN
398 BEGIN /*begin segment 3*/
399 SELECT a.origination_date
400 INTO x_orig_date
401 FROM mtl_transaction_lots_temp a
402 , mtl_material_transactions_temp b
403 WHERE b.inventory_item_id = p_inventory_item_id
404 AND a.lot_number = p_lot_number
405 AND a.transaction_temp_id = b.transaction_temp_id
406 AND ROWNUM = 1
407 AND b.organization_id = p_organization_id;
408 EXCEPTION
409 WHEN OTHERS THEN
410 x_orig_date := NULL;
411 END;
412 WHEN OTHERS THEN
413 x_orig_date := NULL;
414 END;
415 EXCEPTION
416 WHEN OTHERS THEN
417 x_orig_date := NULL;
418 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419 END get_origination_date_session;
420
421 -- bug#6073680 START
422 -- Procedure to determine if lot is an existing lot.
423
424 PROCEDURE check_lot_exists
425 ( p_inventory_item_id IN NUMBER
426 ,p_organization_id IN NUMBER
427 ,p_lot_number IN VARCHAR2
428 ,x_lot_exist OUT NOCOPY VARCHAR2
429 ,x_return_status OUT NOCOPY VARCHAR2
430 ) IS
431 l_lot_exists NUMBER;
432 BEGIN
433 x_return_status := FND_API.G_RET_STS_SUCCESS;
434 l_lot_exists := 0;
435 x_lot_exist := 'FALSE';
439 FROM mtl_lot_numbers
436 BEGIN /*begin segment 2 */
437 SELECT 1
438 INTO l_lot_exists
440 WHERE inventory_item_id = p_inventory_item_id
441 AND lot_number = p_lot_number
442 AND organization_id = p_organization_id;
443 EXCEPTION
444 WHEN no_data_found THEN
445 l_lot_exists := 0;
446 END;
447 IF l_lot_exists = 1 THEN
448 x_lot_exist := 'TRUE';
449 ELSE
450 x_lot_exist := 'FALSE';
451 END IF;
452 EXCEPTION
453 WHEN OTHERS THEN
454 x_lot_exist := 'FALSE';
455 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456 END check_lot_exists;
457 -- bug#6073680 END
458
459 -- Procedure to return the lot expiration date. This will call the custom lot expiration code.
460 -- If custom lot expiration code returns null, this procedure will return expiration date by
461 -- adding shelf life days to transaction date.
462 PROCEDURE get_lot_expiration_date
463 ( p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
464 ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
465 ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
466 ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
467 ,p_table IN NUMBER
468 ,x_lot_expiration_date OUT NOCOPY DATE
469 ,x_return_status OUT NOCOPY VARCHAR2
470 ) IS
471 l_shelf_life_code NUMBER;
472 l_shelf_life_days NUMBER;
473 l_inventory_item_id NUMBER;
474 l_organization_id NUMBER;
475 l_transaction_date DATE;
476 l_transaction_action_id NUMBER; -- nsinghi bug#5209065 rework
477
478 CURSOR Cur_item_dtl (c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
479 SELECT msi.shelf_life_code, msi.shelf_life_days
480 FROM mtl_system_items msi
481 WHERE msi.inventory_item_id = c_inventory_item_id
482 AND msi.organization_id = c_organization_id;
483 BEGIN
484 /* Initialize return status to success */
485 x_return_status := FND_API.G_RET_STS_SUCCESS;
486
487 IF ((p_table = 1 AND p_mti_trx_rec.inventory_item_id IS NOT NULL
488 AND p_mti_trx_rec.organization_id IS NOT NULL)
489 OR
490 (p_table = 2 AND p_mmtt_trx_rec.inventory_item_id IS NOT NULL
491 AND p_mmtt_trx_rec.organization_id IS NOT NULL)) THEN
492
493 IF p_table = 1 THEN
494 l_inventory_item_id := p_mti_trx_rec.inventory_item_id;
495 l_organization_id := p_mti_trx_rec.organization_id;
496 l_transaction_date := p_mti_trx_rec.transaction_date;
497 l_transaction_action_id := p_mti_trx_rec.transaction_action_id; -- nsinghi bug#5209065 rework
498 ELSE
499 l_inventory_item_id := p_mmtt_trx_rec.inventory_item_id;
500 l_organization_id := p_mmtt_trx_rec.organization_id;
501 l_transaction_date := p_mmtt_trx_rec.transaction_date;
502 l_transaction_action_id := p_mmtt_trx_rec.transaction_action_id; -- nsinghi bug#5209065 rework
503 END IF;
504
505 OPEN Cur_item_dtl (l_inventory_item_id, l_organization_id);
506 FETCH Cur_item_dtl INTO l_shelf_life_code, l_shelf_life_days;
507 CLOSE Cur_item_dtl;
508 /*
509 IF (l_debug = 1 )THEN
510 log_transaction_rec( p_mtli_lot_rec => p_mtli_lot_rec
511 ,p_mti_trx_rec => p_mti_trx_rec
512 ,p_mtlt_lot_rec => p_mtlt_lot_rec
513 ,p_mmtt_trx_rec => p_mmtt_trx_rec
514 ,p_table => p_table);
515 END IF;
516 */
517 -- nsinghi bug#5209065 rework. Added the IF clause, as we need to call custom lot routine only for receipt transactions.
518 IF NVL(l_transaction_action_id, -1) IN
519 ( inv_globals.g_action_receipt
520 , inv_globals.g_action_assycomplete
521 )
522 THEN
523 inv_cust_calc_exp_date.get_custom_lot_expiration_date (
524 p_mtli_lot_rec => p_mtli_lot_rec
525 ,p_mti_trx_rec => p_mti_trx_rec
526 ,p_mtlt_lot_rec => p_mtlt_lot_rec
527 ,p_mmtt_trx_rec => p_mmtt_trx_rec
528 ,p_table => p_table
529 ,x_lot_expiration_date => x_lot_expiration_date
530 ,x_return_status => x_return_status);
531 END IF;
532 IF (x_lot_expiration_date IS NULL) THEN
533 IF l_transaction_date IS NOT NULL THEN
534 x_lot_expiration_date:=l_transaction_date+l_shelf_life_days;
535 ELSE
536 x_lot_expiration_date:=SYSDATE+l_shelf_life_days;
537 END IF;
538 END IF;
539 ELSE
540 x_lot_expiration_date:=SYSDATE+l_shelf_life_days;
541 END IF;
542
543
544 EXCEPTION
545 WHEN OTHERS THEN
546 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547 IF (l_debug = 1) THEN
548 mydebug('WHEN OTHERS exception : '||SQLERRM, 'GET_TXN_ID');
549 END IF;
550 END get_lot_expiration_date;
551
552 -- Procedure to Update Inventory Lot. From MSCA, we cannot pass record type parameter. Hence all the parameters
556 , x_msg_count OUT NOCOPY NUMBER
553 -- are passed to this API, which will inturn call the Public Update Inv Lot API.
554 PROCEDURE update_inv_lot_attr(
555 x_return_status OUT NOCOPY VARCHAR2
557 , x_msg_data OUT NOCOPY VARCHAR2
558 , p_inventory_item_id IN NUMBER
559 , p_organization_id IN NUMBER
560 , p_lot_number IN VARCHAR2
561 , p_source IN NUMBER
562 , p_expiration_date IN DATE DEFAULT NULL
563 , p_grade_code IN VARCHAR2 DEFAULT NULL
564 , p_origination_date IN DATE DEFAULT NULL
565 , p_origination_type IN NUMBER DEFAULT NULL
566 , p_status_id IN NUMBER DEFAULT NULL
567 , p_retest_date IN DATE DEFAULT NULL
568 , p_maturity_date IN DATE DEFAULT NULL
569 , p_supplier_lot_number IN VARCHAR2 DEFAULT NULL
570 , p_expiration_action_code IN VARCHAR2 DEFAULT NULL
571 , p_expiration_action_date IN DATE DEFAULT NULL
572 , p_hold_date IN DATE DEFAULT NULL
573 , p_c_attribute1 IN VARCHAR2 := NULL
574 , p_c_attribute2 IN VARCHAR2 := NULL
575 , p_c_attribute3 IN VARCHAR2 := NULL
576 , p_c_attribute4 IN VARCHAR2 := NULL
577 , p_c_attribute5 IN VARCHAR2 := NULL
578 , p_c_attribute6 IN VARCHAR2 := NULL
579 , p_c_attribute7 IN VARCHAR2 := NULL
580 , p_c_attribute8 IN VARCHAR2 := NULL
581 , p_c_attribute9 IN VARCHAR2 := NULL
582 , p_c_attribute10 IN VARCHAR2 := NULL
583 , p_c_attribute11 IN VARCHAR2 := NULL
584 , p_c_attribute12 IN VARCHAR2 := NULL
585 , p_c_attribute13 IN VARCHAR2 := NULL
586 , p_c_attribute14 IN VARCHAR2 := NULL
587 , p_c_attribute15 IN VARCHAR2 := NULL
588 , p_c_attribute16 IN VARCHAR2 := NULL
589 , p_c_attribute17 IN VARCHAR2 := NULL
590 , p_c_attribute18 IN VARCHAR2 := NULL
591 , p_c_attribute19 IN VARCHAR2 := NULL
592 , p_c_attribute20 IN VARCHAR2 := NULL
593 , p_d_attribute1 IN DATE := NULL
594 , p_d_attribute2 IN DATE := NULL
595 , p_d_attribute3 IN DATE := NULL
596 , p_d_attribute4 IN DATE := NULL
597 , p_d_attribute5 IN DATE := NULL
598 , p_d_attribute6 IN DATE := NULL
599 , p_d_attribute7 IN DATE := NULL
600 , p_d_attribute8 IN DATE := NULL
601 , p_d_attribute9 IN DATE := NULL
602 , p_d_attribute10 IN DATE := NULL
603 , p_n_attribute1 IN NUMBER := NULL
604 , p_n_attribute2 IN NUMBER := NULL
605 , p_n_attribute3 IN NUMBER := NULL
606 , p_n_attribute4 IN NUMBER := NULL
607 , p_n_attribute5 IN NUMBER := NULL
608 , p_n_attribute6 IN NUMBER := NULL
609 , p_n_attribute7 IN NUMBER := NULL
610 , p_n_attribute8 IN NUMBER := NULL
611 , p_n_attribute9 IN NUMBER := NULL
612 , p_n_attribute10 IN NUMBER := NULL
613 -- bug#6073680 START. Added following parameters to handle WMS Attributes
614 , p_description IN VARCHAR2 := NULL
615 , p_vendor_name IN VARCHAR2 := NULL
616 , p_date_code IN VARCHAR2 := NULL
617 , p_change_date IN DATE := NULL
618 , p_age IN NUMBER := NULL
619 , p_item_size IN NUMBER := NULL
620 , p_color IN VARCHAR2 := NULL
621 , p_volume IN NUMBER := NULL
622 , p_volume_uom IN VARCHAR2 := NULL
623 , p_place_of_origin IN VARCHAR2 := NULL
627 , p_recycled_content IN NUMBER := NULL
624 , p_best_by_date IN DATE := NULL
625 , p_length IN NUMBER := NULL
626 , p_length_uom IN VARCHAR2 := NULL
628 , p_thickness IN NUMBER := NULL
629 , p_thickness_uom IN VARCHAR2 := NULL
630 , p_width IN NUMBER := NULL
631 , p_width_uom IN VARCHAR2 := NULL
632 , p_curl_wrinkle_fold IN VARCHAR2 := NULL
633 , p_lot_attribute_category IN VARCHAR2 := NULL
634 , p_territory_code IN VARCHAR2 := NULL
635 , p_vendor_id IN VARCHAR2 := NULL
636 , p_parent_lot_number IN VARCHAR2 := NULL
637 -- bug#6073680 END. Added following parameters to handle WMS Attributes
638 ) IS
639 l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
640 x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
641 l_api_version NUMBER;
642 l_init_msg_list VARCHAR2(100);
643 l_commit VARCHAR2(100);
644 l_return_status VARCHAR2(1) ;
645 l_msg_data VARCHAR2(3000) ;
646 l_msg_count NUMBER ;
647 l_exc_error EXCEPTION;
648 l_exc_unexpected_error EXCEPTION;
649
650 BEGIN
651 x_return_status := FND_API.G_RET_STS_SUCCESS;
652
653 /* Populating the variables and calling the overloaded API */
654
655 l_in_lot_rec.inventory_item_id := p_inventory_item_id;
656 l_in_lot_rec.organization_id := p_organization_id;
657 l_in_lot_rec.lot_number := p_lot_number;
658 l_in_lot_rec.expiration_date := p_expiration_date;
659 l_in_lot_rec.grade_code := p_grade_code;
660 l_in_lot_rec.origination_date := p_origination_date;
661 l_in_lot_rec.origination_type := p_origination_type;
662 l_in_lot_rec.status_id := p_status_id;
663 l_in_lot_rec.retest_date := p_retest_date;
664 l_in_lot_rec.maturity_date := p_maturity_date;
665 l_in_lot_rec.supplier_lot_number := p_supplier_lot_number;
666 l_in_lot_rec.expiration_action_code := p_expiration_action_code;
667 l_in_lot_rec.expiration_action_date := p_expiration_action_date;
668 l_in_lot_rec.hold_date := p_hold_date;
669
670 l_in_lot_rec.last_update_date := SYSDATE ;
671 l_in_lot_rec.last_updated_by := FND_GLOBAL.USER_ID;
672 l_in_lot_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
673
674 -- bug#6073680 START. Added following parameters to handle WMS Attributes
675 l_in_lot_rec.description := p_description;
676 l_in_lot_rec.vendor_name := p_vendor_name;
677 l_in_lot_rec.date_code := p_date_code;
678 l_in_lot_rec.change_date := p_change_date;
679 l_in_lot_rec.age := p_age;
680 l_in_lot_rec.item_size := p_item_size;
681 l_in_lot_rec.color := p_color;
682 l_in_lot_rec.volume := p_volume;
683 l_in_lot_rec.volume_uom := p_volume_uom;
684 l_in_lot_rec.place_of_origin := p_place_of_origin;
685 l_in_lot_rec.best_by_date := p_best_by_date;
686 l_in_lot_rec.length := p_length;
687 l_in_lot_rec.length_uom := p_length_uom;
688 l_in_lot_rec.recycled_content := p_recycled_content;
689 l_in_lot_rec.thickness := p_thickness;
690 l_in_lot_rec.thickness_uom := p_thickness_uom;
691 l_in_lot_rec.width := p_width;
692 l_in_lot_rec.width_uom := p_width_uom;
693 l_in_lot_rec.curl_wrinkle_fold := p_curl_wrinkle_fold;
697 l_in_lot_rec.parent_lot_number := p_parent_lot_number;
694 l_in_lot_rec.lot_attribute_category := p_lot_attribute_category;
695 l_in_lot_rec.territory_code := p_territory_code;
696 l_in_lot_rec.vendor_id := p_vendor_id;
698 -- bug#6073680 END.
699
700 IF (p_c_attribute1 IS NOT NULL) THEN
701 l_in_lot_rec.c_attribute1 := p_c_attribute1;
702 END IF;
703 IF (p_c_attribute2 IS NOT NULL) THEN
704 l_in_lot_rec.c_attribute2 := p_c_attribute2;
705 END IF;
706 IF (p_c_attribute3 IS NOT NULL) THEN
707 l_in_lot_rec.c_attribute3 := p_c_attribute3;
708 END IF;
709 IF (p_c_attribute4 IS NOT NULL) THEN
710 l_in_lot_rec.c_attribute4 := p_c_attribute4;
711 END IF;
712 IF (p_c_attribute5 IS NOT NULL) THEN
713 l_in_lot_rec.c_attribute5 := p_c_attribute5;
714 END IF;
715 IF (p_c_attribute6 IS NOT NULL) THEN
716 l_in_lot_rec.c_attribute6 := p_c_attribute6;
717 END IF;
718 IF (p_c_attribute7 IS NOT NULL) THEN
719 l_in_lot_rec.c_attribute7 := p_c_attribute7;
720 END IF;
721 IF (p_c_attribute8 IS NOT NULL) THEN
722 l_in_lot_rec.c_attribute8 := p_c_attribute8;
723 END IF;
724 IF (p_c_attribute9 IS NOT NULL) THEN
725 l_in_lot_rec.c_attribute9 := p_c_attribute9;
726 END IF;
727 IF (p_c_attribute10 IS NOT NULL) THEN
728 l_in_lot_rec.c_attribute10 := p_c_attribute10;
729 END IF;
730 IF (p_c_attribute11 IS NOT NULL) THEN
731 l_in_lot_rec.c_attribute11 := p_c_attribute11;
732 END IF;
733 IF (p_c_attribute12 IS NOT NULL) THEN
734 l_in_lot_rec.c_attribute12 := p_c_attribute12;
735 END IF;
736 IF (p_c_attribute13 IS NOT NULL) THEN
737 l_in_lot_rec.c_attribute13 := p_c_attribute13;
738 END IF;
739 IF (p_c_attribute14 IS NOT NULL) THEN
740 l_in_lot_rec.c_attribute14 := p_c_attribute14;
741 END IF;
742 IF (p_c_attribute15 IS NOT NULL) THEN
743 l_in_lot_rec.c_attribute15 := p_c_attribute15;
744 END IF;
745 IF (p_c_attribute16 IS NOT NULL) THEN
746 l_in_lot_rec.c_attribute16 := p_c_attribute16;
747 END IF;
748 IF (p_c_attribute17 IS NOT NULL) THEN
749 l_in_lot_rec.c_attribute17 := p_c_attribute17;
750 END IF;
751 IF (p_c_attribute18 IS NOT NULL) THEN
752 l_in_lot_rec.c_attribute18 := p_c_attribute18;
753 END IF;
754 IF (p_c_attribute19 IS NOT NULL) THEN
755 l_in_lot_rec.c_attribute19 := p_c_attribute19;
756 END IF;
757 IF (p_c_attribute20 IS NOT NULL) THEN
758 l_in_lot_rec.c_attribute20 := p_c_attribute20;
759 END IF;
760 IF (p_n_attribute1 IS NOT NULL) THEN
761 l_in_lot_rec.n_attribute1 := p_n_attribute1;
762 END IF;
763 IF (p_n_attribute2 IS NOT NULL) THEN
764 l_in_lot_rec.n_attribute2 := p_n_attribute2;
765 END IF;
766 IF (p_n_attribute3 IS NOT NULL) THEN
767 l_in_lot_rec.n_attribute3 := p_n_attribute3;
768 END IF;
769 IF (p_n_attribute4 IS NOT NULL) THEN
770 l_in_lot_rec.n_attribute4 := p_n_attribute4;
771 END IF;
772 IF (p_n_attribute5 IS NOT NULL) THEN
773 l_in_lot_rec.n_attribute5 := p_n_attribute5;
774 END IF;
775 IF (p_n_attribute6 IS NOT NULL) THEN
776 l_in_lot_rec.n_attribute6 := p_n_attribute6;
777 END IF;
778 IF (p_n_attribute7 IS NOT NULL) THEN
779 l_in_lot_rec.n_attribute7 := p_n_attribute7;
780 END IF;
781 IF (p_n_attribute8 IS NOT NULL) THEN
782 l_in_lot_rec.n_attribute8 := p_n_attribute8;
783 END IF;
784 IF (p_n_attribute9 IS NOT NULL) THEN
785 l_in_lot_rec.n_attribute9 := p_n_attribute9;
786 END IF;
787 IF (p_n_attribute10 IS NOT NULL) THEN
788 l_in_lot_rec.n_attribute10 := p_n_attribute10;
789 END IF;
790 IF (p_d_attribute1 IS NOT NULL) THEN
791 l_in_lot_rec.d_attribute1 := p_d_attribute1;
792 END IF;
793 IF (p_d_attribute2 IS NOT NULL) THEN
794 l_in_lot_rec.d_attribute2 := p_d_attribute2;
795 END IF;
796 IF (p_d_attribute3 IS NOT NULL) THEN
797 l_in_lot_rec.d_attribute3 := p_d_attribute3;
798 END IF;
799 IF (p_d_attribute4 IS NOT NULL) THEN
800 l_in_lot_rec.d_attribute4 := p_d_attribute4;
801 END IF;
802 IF (p_d_attribute5 IS NOT NULL) THEN
803 l_in_lot_rec.d_attribute5 := p_d_attribute5;
807 END IF;
804 END IF;
805 IF (p_d_attribute6 IS NOT NULL) THEN
806 l_in_lot_rec.d_attribute6 := p_d_attribute6;
808 IF (p_d_attribute7 IS NOT NULL) THEN
809 l_in_lot_rec.d_attribute7 := p_d_attribute7;
810 END IF;
811 IF (p_d_attribute8 IS NOT NULL) THEN
812 l_in_lot_rec.d_attribute8 := p_d_attribute8;
813 END IF;
814 IF (p_d_attribute9 IS NOT NULL) THEN
815 l_in_lot_rec.d_attribute9 := p_d_attribute9;
816 END IF;
817 IF (p_d_attribute10 IS NOT NULL) THEN
818 l_in_lot_rec.d_attribute10 := p_d_attribute10;
819 END IF;
820 --END BUG 4748451
821 l_api_version := 1.0;
822 l_init_msg_list := fnd_api.g_false;
823 l_commit := fnd_api.g_false;
824
825 /* Calling the overloaded procedure */
826 inv_lot_api_pub.Update_Inv_lot(
827 x_return_status => l_return_status
828 , x_msg_count => l_msg_count
829 , x_msg_data => l_msg_data
830 , x_lot_rec => x_lot_rec
831 , p_lot_rec => l_in_lot_rec
832 , p_source => p_source
833 , p_api_version => l_api_version
834 , p_init_msg_list => l_init_msg_list
835 , p_commit => l_commit
836 );
837
838 IF l_debug = 1 THEN
839 mydebug('Program Update_Inv_lot return ' || l_return_status, 9);
840 END IF;
841 IF l_return_status = fnd_api.g_ret_sts_error THEN
842 IF l_debug = 1 THEN
843 mydebug('Program Update_Inv_lot has failed with a user defined exception', 9);
844 END IF;
845 RAISE l_exc_error;
846 ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
847 IF l_debug = 1 THEN
848 mydebug('Program Update_Inv_lot has failed with a Unexpected exception', 9);
849 END IF;
850 FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
851 FND_MESSAGE.SET_TOKEN('PROG_NAME','Update_Inv_lot');
852 fnd_msg_pub.ADD;
853 RAISE l_exc_unexpected_error;
854 END IF;
855
856 EXCEPTION
857 WHEN NO_DATA_FOUND THEN
858 x_return_status := fnd_api.g_ret_sts_error;
859 fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
860 if( x_msg_count > 1 ) then
861 x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
862 end if;
863 mydebug('Upd Inv Lot Attr: In No data found ' || SQLERRM, 9);
864 WHEN l_exc_error THEN
865 x_return_status := fnd_api.g_ret_sts_error;
866 fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
867 if( x_msg_count > 1 ) then
868 x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
869 end if;
870 mydebug('Upd Inv Lot Attr: In l_exc_error ' || SQLERRM, 9);
871 WHEN l_exc_unexpected_error THEN
872 x_return_status := fnd_api.g_ret_sts_unexp_error;
873 fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
874 if ( x_msg_count > 1 ) then
875 x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
876 end if;
877 mydebug('In l_exc_unexpected_error ' || SQLERRM, 9);
878 WHEN OTHERS THEN
879 x_return_status := fnd_api.g_ret_sts_unexp_error;
880 fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
881 if( x_msg_count > 1 ) then
882 x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
883 end if;
884 mydebug('Upd Inv Lot Attr: In others ' || SQLERRM, 9);
885 END;
886
887 -- Procedure to log all the data present in MTI, MTLI, MMTT and MTLT tables. Custom can use this API to
891 p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
888 -- verify which columns have data at runtime, so that those can be used in their Custom Code. This is
889 -- a utility procedure.
890 PROCEDURE log_transaction_rec(
892 ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
893 ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
894 ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
895 ,p_table IN NUMBER
896 )IS
897 l_date_format VARCHAR2(30);
898 BEGIN
899 l_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
900 IF ((l_debug = 1) AND (p_table = 2 )) THEN
901 mydebug(' TRANSACTION_HEADER_ID '||p_mmtt_trx_rec.TRANSACTION_HEADER_ID);
902 mydebug(' TRANSACTION_TEMP_ID '||p_mmtt_trx_rec.TRANSACTION_TEMP_ID);
903 mydebug(' SOURCE_CODE '||p_mmtt_trx_rec.SOURCE_CODE);
904 mydebug(' SOURCE_LINE_ID '||p_mmtt_trx_rec.SOURCE_LINE_ID);
905 mydebug(' TRANSACTION_MODE '||p_mmtt_trx_rec.TRANSACTION_MODE);
906 mydebug(' LOCK_FLAG '||p_mmtt_trx_rec.LOCK_FLAG);
907 mydebug(' LAST_UPDATE_DATE '||TO_CHAR(p_mmtt_trx_rec.LAST_UPDATE_DATE, l_date_format));
908 mydebug(' LAST_UPDATED_BY '||p_mmtt_trx_rec.LAST_UPDATED_BY);
909 mydebug(' CREATION_DATE '||TO_CHAR(p_mmtt_trx_rec.CREATION_DATE, l_date_format));
910 mydebug(' CREATED_BY '||p_mmtt_trx_rec.CREATED_BY);
911 mydebug(' LAST_UPDATE_LOGIN '||p_mmtt_trx_rec.LAST_UPDATE_LOGIN);
912 mydebug(' REQUEST_ID '||p_mmtt_trx_rec.REQUEST_ID);
913 mydebug(' PROGRAM_APPLICATION_ID '||p_mmtt_trx_rec.PROGRAM_APPLICATION_ID);
914 mydebug(' PROGRAM_ID '||p_mmtt_trx_rec.PROGRAM_ID);
915 mydebug(' PROGRAM_UPDATE_DATE '||TO_CHAR(p_mmtt_trx_rec.PROGRAM_UPDATE_DATE, l_date_format));
916 mydebug(' INVENTORY_ITEM_ID '||p_mmtt_trx_rec.INVENTORY_ITEM_ID);
917 mydebug(' REVISION '||p_mmtt_trx_rec.REVISION);
918 mydebug(' ORGANIZATION_ID '||p_mmtt_trx_rec.ORGANIZATION_ID);
919 mydebug(' SUBINVENTORY_CODE '||p_mmtt_trx_rec.SUBINVENTORY_CODE);
920 mydebug(' LOCATOR_ID '||p_mmtt_trx_rec.LOCATOR_ID);
921 mydebug(' TRANSACTION_QUANTITY '||p_mmtt_trx_rec.TRANSACTION_QUANTITY);
922 mydebug(' PRIMARY_QUANTITY '||p_mmtt_trx_rec.PRIMARY_QUANTITY);
923 mydebug(' TRANSACTION_UOM '||p_mmtt_trx_rec.TRANSACTION_UOM);
924 mydebug(' TRANSACTION_COST '||p_mmtt_trx_rec.TRANSACTION_COST);
925 mydebug(' TRANSACTION_TYPE_ID '||p_mmtt_trx_rec.TRANSACTION_TYPE_ID);
926 mydebug(' TRANSACTION_ACTION_ID '||p_mmtt_trx_rec.TRANSACTION_ACTION_ID);
927 mydebug(' TRANSACTION_SOURCE_TYPE_ID '||p_mmtt_trx_rec.TRANSACTION_SOURCE_TYPE_ID);
928 mydebug(' TRANSACTION_SOURCE_ID '||p_mmtt_trx_rec.TRANSACTION_SOURCE_ID);
929 mydebug(' TRANSACTION_SOURCE_NAME '||p_mmtt_trx_rec.TRANSACTION_SOURCE_NAME);
930 mydebug(' TRANSACTION_DATE '||TO_CHAR(p_mmtt_trx_rec.TRANSACTION_DATE, l_date_format));
931 mydebug(' ACCT_PERIOD_ID '||p_mmtt_trx_rec.ACCT_PERIOD_ID);
932 mydebug(' DISTRIBUTION_ACCOUNT_ID '||p_mmtt_trx_rec.DISTRIBUTION_ACCOUNT_ID);
933 mydebug(' TRANSACTION_REFERENCE '||p_mmtt_trx_rec.TRANSACTION_REFERENCE);
934 mydebug(' REQUISITION_LINE_ID '||p_mmtt_trx_rec.REQUISITION_LINE_ID);
935 mydebug(' REQUISITION_DISTRIBUTION_ID '||p_mmtt_trx_rec.REQUISITION_DISTRIBUTION_ID);
936 mydebug(' REASON_ID '||p_mmtt_trx_rec.REASON_ID);
937 mydebug(' LOT_NUMBER '||p_mmtt_trx_rec.LOT_NUMBER);
938 mydebug(' LOT_EXPIRATION_DATE '||TO_CHAR(p_mmtt_trx_rec.LOT_EXPIRATION_DATE, l_date_format));
939 mydebug(' SERIAL_NUMBER '||p_mmtt_trx_rec.SERIAL_NUMBER);
940 mydebug(' RECEIVING_DOCUMENT '||p_mmtt_trx_rec.RECEIVING_DOCUMENT);
941 mydebug(' DEMAND_ID '||p_mmtt_trx_rec.DEMAND_ID);
942 mydebug(' RCV_TRANSACTION_ID '||p_mmtt_trx_rec.RCV_TRANSACTION_ID);
943 mydebug(' MOVE_TRANSACTION_ID '||p_mmtt_trx_rec.MOVE_TRANSACTION_ID);
944 mydebug(' COMPLETION_TRANSACTION_ID '||p_mmtt_trx_rec.COMPLETION_TRANSACTION_ID);
945 mydebug(' WIP_ENTITY_TYPE '||p_mmtt_trx_rec.WIP_ENTITY_TYPE);
946 mydebug(' SCHEDULE_ID '||p_mmtt_trx_rec.SCHEDULE_ID);
947 mydebug(' REPETITIVE_LINE_ID '||p_mmtt_trx_rec.REPETITIVE_LINE_ID);
951 mydebug(' SETUP_TEARDOWN_CODE '||p_mmtt_trx_rec.SETUP_TEARDOWN_CODE);
948 mydebug(' EMPLOYEE_CODE '||p_mmtt_trx_rec.EMPLOYEE_CODE);
949 mydebug(' PRIMARY_SWITCH '||p_mmtt_trx_rec.PRIMARY_SWITCH);
950 mydebug(' SCHEDULE_UPDATE_CODE '||p_mmtt_trx_rec.SCHEDULE_UPDATE_CODE);
952 mydebug(' ITEM_ORDERING '||p_mmtt_trx_rec.ITEM_ORDERING);
953 mydebug(' NEGATIVE_REQ_FLAG '||p_mmtt_trx_rec.NEGATIVE_REQ_FLAG);
954 mydebug(' OPERATION_SEQ_NUM '||p_mmtt_trx_rec.OPERATION_SEQ_NUM);
955 mydebug(' PICKING_LINE_ID '||p_mmtt_trx_rec.PICKING_LINE_ID);
956 mydebug(' TRX_SOURCE_LINE_ID '||p_mmtt_trx_rec.TRX_SOURCE_LINE_ID);
957 mydebug(' TRX_SOURCE_DELIVERY_ID '||p_mmtt_trx_rec.TRX_SOURCE_DELIVERY_ID);
958 mydebug(' PHYSICAL_ADJUSTMENT_ID '||p_mmtt_trx_rec.PHYSICAL_ADJUSTMENT_ID);
959 mydebug(' CYCLE_COUNT_ID '||p_mmtt_trx_rec.CYCLE_COUNT_ID);
960 mydebug(' RMA_LINE_ID '||p_mmtt_trx_rec.RMA_LINE_ID);
961 mydebug(' CUSTOMER_SHIP_ID '||p_mmtt_trx_rec.CUSTOMER_SHIP_ID);
962 mydebug(' CURRENCY_CODE '||p_mmtt_trx_rec.CURRENCY_CODE);
963 mydebug(' CURRENCY_CONVERSION_RATE '||p_mmtt_trx_rec.CURRENCY_CONVERSION_RATE);
964 mydebug(' CURRENCY_CONVERSION_TYPE '||p_mmtt_trx_rec.CURRENCY_CONVERSION_TYPE);
965 mydebug(' CURRENCY_CONVERSION_DATE '||TO_CHAR(p_mmtt_trx_rec.CURRENCY_CONVERSION_DATE, l_date_format));
966 mydebug(' USSGL_TRANSACTION_CODE '||p_mmtt_trx_rec.USSGL_TRANSACTION_CODE);
967 mydebug(' VENDOR_LOT_NUMBER '||p_mmtt_trx_rec.VENDOR_LOT_NUMBER);
968 mydebug(' ENCUMBRANCE_ACCOUNT '||p_mmtt_trx_rec.ENCUMBRANCE_ACCOUNT);
969 mydebug(' ENCUMBRANCE_AMOUNT '||p_mmtt_trx_rec.ENCUMBRANCE_AMOUNT);
970 mydebug(' SHIP_TO_LOCATION '||p_mmtt_trx_rec.SHIP_TO_LOCATION);
971 mydebug(' SHIPMENT_NUMBER '||p_mmtt_trx_rec.SHIPMENT_NUMBER);
972 mydebug(' TRANSFER_COST '||p_mmtt_trx_rec.TRANSFER_COST);
973 mydebug(' TRANSPORTATION_COST '||p_mmtt_trx_rec.TRANSPORTATION_COST);
974 mydebug(' TRANSPORTATION_ACCOUNT '||p_mmtt_trx_rec.TRANSPORTATION_ACCOUNT);
975 mydebug(' FREIGHT_CODE '||p_mmtt_trx_rec.FREIGHT_CODE);
976 mydebug(' CONTAINERS '||p_mmtt_trx_rec.CONTAINERS);
977 mydebug(' WAYBILL_AIRBILL '||p_mmtt_trx_rec.WAYBILL_AIRBILL);
978 mydebug(' EXPECTED_ARRIVAL_DATE '||TO_CHAR(p_mmtt_trx_rec.EXPECTED_ARRIVAL_DATE, l_date_format));
979 mydebug(' TRANSFER_SUBINVENTORY '||p_mmtt_trx_rec.TRANSFER_SUBINVENTORY);
980 mydebug(' TRANSFER_ORGANIZATION '||p_mmtt_trx_rec.TRANSFER_ORGANIZATION);
981 mydebug(' TRANSFER_TO_LOCATION '||p_mmtt_trx_rec.TRANSFER_TO_LOCATION);
982 mydebug(' NEW_AVERAGE_COST '||p_mmtt_trx_rec.NEW_AVERAGE_COST);
983 mydebug(' VALUE_CHANGE '||p_mmtt_trx_rec.VALUE_CHANGE);
984 mydebug(' PERCENTAGE_CHANGE '||p_mmtt_trx_rec.PERCENTAGE_CHANGE);
985 mydebug(' MATERIAL_ALLOCATION_TEMP_ID '||p_mmtt_trx_rec.MATERIAL_ALLOCATION_TEMP_ID);
986 mydebug(' DEMAND_SOURCE_HEADER_ID '||p_mmtt_trx_rec.DEMAND_SOURCE_HEADER_ID);
987 mydebug(' DEMAND_SOURCE_LINE '||p_mmtt_trx_rec.DEMAND_SOURCE_LINE);
988 mydebug(' DEMAND_SOURCE_DELIVERY '||p_mmtt_trx_rec.DEMAND_SOURCE_DELIVERY);
989 mydebug(' ITEM_SEGMENTS '||p_mmtt_trx_rec.ITEM_SEGMENTS);
990 mydebug(' ITEM_DESCRIPTION '||p_mmtt_trx_rec.ITEM_DESCRIPTION);
991 mydebug(' ITEM_TRX_ENABLED_FLAG '||p_mmtt_trx_rec.ITEM_TRX_ENABLED_FLAG);
992 mydebug(' ITEM_LOCATION_CONTROL_CODE '||p_mmtt_trx_rec.ITEM_LOCATION_CONTROL_CODE);
993 mydebug(' ITEM_RESTRICT_SUBINV_CODE '||p_mmtt_trx_rec.ITEM_RESTRICT_SUBINV_CODE);
994 mydebug(' ITEM_RESTRICT_LOCATORS_CODE '||p_mmtt_trx_rec.ITEM_RESTRICT_LOCATORS_CODE);
995 mydebug(' ITEM_REVISION_QTY_CONTROL_CODE '||p_mmtt_trx_rec.ITEM_REVISION_QTY_CONTROL_CODE);
996 mydebug(' ITEM_PRIMARY_UOM_CODE '||p_mmtt_trx_rec.ITEM_PRIMARY_UOM_CODE);
997 mydebug(' ITEM_UOM_CLASS '||p_mmtt_trx_rec.ITEM_UOM_CLASS);
998 mydebug(' ITEM_SHELF_LIFE_CODE '||p_mmtt_trx_rec.ITEM_SHELF_LIFE_CODE);
999 mydebug(' ITEM_SHELF_LIFE_DAYS '||p_mmtt_trx_rec.ITEM_SHELF_LIFE_DAYS);
1000 mydebug(' ITEM_LOT_CONTROL_CODE '||p_mmtt_trx_rec.ITEM_LOT_CONTROL_CODE);
1001 mydebug(' ITEM_SERIAL_CONTROL_CODE '||p_mmtt_trx_rec.ITEM_SERIAL_CONTROL_CODE);
1002 mydebug(' ITEM_INVENTORY_ASSET_FLAG '||p_mmtt_trx_rec.ITEM_INVENTORY_ASSET_FLAG);
1003 mydebug(' ALLOWED_UNITS_LOOKUP_CODE '||p_mmtt_trx_rec.ALLOWED_UNITS_LOOKUP_CODE);
1004 mydebug(' DEPARTMENT_ID '||p_mmtt_trx_rec.DEPARTMENT_ID);
1005 mydebug(' DEPARTMENT_CODE '||p_mmtt_trx_rec.DEPARTMENT_CODE);
1006 mydebug(' WIP_SUPPLY_TYPE '||p_mmtt_trx_rec.WIP_SUPPLY_TYPE);
1007 mydebug(' SUPPLY_SUBINVENTORY '||p_mmtt_trx_rec.SUPPLY_SUBINVENTORY);
1008 mydebug(' SUPPLY_LOCATOR_ID '||p_mmtt_trx_rec.SUPPLY_LOCATOR_ID);
1009 mydebug(' VALID_SUBINVENTORY_FLAG '||p_mmtt_trx_rec.VALID_SUBINVENTORY_FLAG);
1010 mydebug(' VALID_LOCATOR_FLAG '||p_mmtt_trx_rec.VALID_LOCATOR_FLAG);
1011 mydebug(' LOCATOR_SEGMENTS '||p_mmtt_trx_rec.LOCATOR_SEGMENTS);
1012 mydebug(' CURRENT_LOCATOR_CONTROL_CODE '||p_mmtt_trx_rec.CURRENT_LOCATOR_CONTROL_CODE);
1013 mydebug(' NUMBER_OF_LOTS_ENTERED '||p_mmtt_trx_rec.NUMBER_OF_LOTS_ENTERED);
1014 mydebug(' WIP_COMMIT_FLAG '||p_mmtt_trx_rec.WIP_COMMIT_FLAG);
1015 mydebug(' NEXT_LOT_NUMBER '||p_mmtt_trx_rec.NEXT_LOT_NUMBER);
1019 mydebug(' SHIPPABLE_FLAG '||p_mmtt_trx_rec.SHIPPABLE_FLAG);
1016 mydebug(' LOT_ALPHA_PREFIX '||p_mmtt_trx_rec.LOT_ALPHA_PREFIX);
1017 mydebug(' NEXT_SERIAL_NUMBER '||p_mmtt_trx_rec.NEXT_SERIAL_NUMBER);
1018 mydebug(' SERIAL_ALPHA_PREFIX '||p_mmtt_trx_rec.SERIAL_ALPHA_PREFIX);
1020 mydebug(' POSTING_FLAG '||p_mmtt_trx_rec.POSTING_FLAG);
1021 mydebug(' REQUIRED_FLAG '||p_mmtt_trx_rec.REQUIRED_FLAG);
1022 mydebug(' PROCESS_FLAG '||p_mmtt_trx_rec.PROCESS_FLAG);
1023 mydebug(' ERROR_CODE '||p_mmtt_trx_rec.ERROR_CODE);
1024 mydebug(' ERROR_EXPLANATION '||p_mmtt_trx_rec.ERROR_EXPLANATION);
1025 mydebug(' ATTRIBUTE_CATEGORY '||p_mmtt_trx_rec.ATTRIBUTE_CATEGORY);
1026 mydebug(' ATTRIBUTE1 '||p_mmtt_trx_rec.ATTRIBUTE1);
1027 mydebug(' ATTRIBUTE2 '||p_mmtt_trx_rec.ATTRIBUTE2);
1028 mydebug(' ATTRIBUTE3 '||p_mmtt_trx_rec.ATTRIBUTE3);
1029 mydebug(' ATTRIBUTE4 '||p_mmtt_trx_rec.ATTRIBUTE4);
1030 mydebug(' ATTRIBUTE5 '||p_mmtt_trx_rec.ATTRIBUTE5);
1031 mydebug(' ATTRIBUTE6 '||p_mmtt_trx_rec.ATTRIBUTE6);
1032 mydebug(' ATTRIBUTE7 '||p_mmtt_trx_rec.ATTRIBUTE7);
1033 mydebug(' ATTRIBUTE8 '||p_mmtt_trx_rec.ATTRIBUTE8);
1034 mydebug(' ATTRIBUTE9 '||p_mmtt_trx_rec.ATTRIBUTE9);
1035 mydebug(' ATTRIBUTE10 '||p_mmtt_trx_rec.ATTRIBUTE10);
1036 mydebug(' ATTRIBUTE11 '||p_mmtt_trx_rec.ATTRIBUTE11);
1037 mydebug(' ATTRIBUTE12 '||p_mmtt_trx_rec.ATTRIBUTE12);
1038 mydebug(' ATTRIBUTE13 '||p_mmtt_trx_rec.ATTRIBUTE13);
1039 mydebug(' ATTRIBUTE14 '||p_mmtt_trx_rec.ATTRIBUTE14);
1040 mydebug(' ATTRIBUTE15 '||p_mmtt_trx_rec.ATTRIBUTE15);
1041 mydebug(' MOVEMENT_ID '||p_mmtt_trx_rec.MOVEMENT_ID);
1042 mydebug(' RESERVATION_QUANTITY '||p_mmtt_trx_rec.RESERVATION_QUANTITY);
1043 mydebug(' SHIPPED_QUANTITY '||p_mmtt_trx_rec.SHIPPED_QUANTITY);
1044 mydebug(' TRANSACTION_LINE_NUMBER '||p_mmtt_trx_rec.TRANSACTION_LINE_NUMBER);
1045 mydebug(' TASK_ID '||p_mmtt_trx_rec.TASK_ID);
1046 mydebug(' SOURCE_TASK_ID '||p_mmtt_trx_rec.SOURCE_TASK_ID);
1047 mydebug(' PROJECT_ID '||p_mmtt_trx_rec.PROJECT_ID);
1048 mydebug(' SOURCE_PROJECT_ID '||p_mmtt_trx_rec.SOURCE_PROJECT_ID);
1049 mydebug(' PA_EXPENDITURE_ORG_ID '||p_mmtt_trx_rec.PA_EXPENDITURE_ORG_ID);
1050 mydebug(' EXPENDITURE_TYPE '||p_mmtt_trx_rec.EXPENDITURE_TYPE);
1051 mydebug(' FINAL_COMPLETION_FLAG '||p_mmtt_trx_rec.FINAL_COMPLETION_FLAG);
1052 mydebug(' TRANSFER_PERCENTAGE '||p_mmtt_trx_rec.TRANSFER_PERCENTAGE);
1053 mydebug(' QA_COLLECTION_ID '||p_mmtt_trx_rec.QA_COLLECTION_ID);
1054 mydebug(' END_ITEM_UNIT_NUMBER '||p_mmtt_trx_rec.END_ITEM_UNIT_NUMBER);
1055 mydebug(' SCHEDULED_PAYBACK_DATE '||TO_CHAR(p_mmtt_trx_rec.SCHEDULED_PAYBACK_DATE, l_date_format));
1056 mydebug(' MOVE_ORDER_LINE_ID '||p_mmtt_trx_rec.MOVE_ORDER_LINE_ID);
1057 mydebug(' TASK_GROUP_ID '||p_mmtt_trx_rec.TASK_GROUP_ID);
1058 mydebug(' PICK_SLIP_NUMBER '||p_mmtt_trx_rec.PICK_SLIP_NUMBER);
1059 mydebug(' RESERVATION_ID '||p_mmtt_trx_rec.RESERVATION_ID);
1060 mydebug(' TRANSACTION_STATUS '||p_mmtt_trx_rec.TRANSACTION_STATUS);
1061 mydebug(' WMS_TASK_TYPE '||p_mmtt_trx_rec.WMS_TASK_TYPE);
1062 mydebug(' PARENT_LINE_ID '||p_mmtt_trx_rec.PARENT_LINE_ID);
1063 mydebug(' WMS_TASK_STATUS '||p_mmtt_trx_rec.WMS_TASK_STATUS);
1064 mydebug(' REBUILD_ITEM_ID '||p_mmtt_trx_rec.REBUILD_ITEM_ID);
1065 mydebug(' REBUILD_SERIAL_NUMBER '||p_mmtt_trx_rec.REBUILD_SERIAL_NUMBER);
1066 mydebug(' REBUILD_ACTIVITY_ID '||p_mmtt_trx_rec.REBUILD_ACTIVITY_ID);
1067 mydebug(' REBUILD_JOB_NAME '||p_mmtt_trx_rec.REBUILD_JOB_NAME);
1068 mydebug(' OWNING_TP_TYPE '||p_mmtt_trx_rec.OWNING_TP_TYPE);
1069 mydebug(' XFR_OWNING_ORGANIZATION_ID '||p_mmtt_trx_rec.XFR_OWNING_ORGANIZATION_ID);
1070 mydebug(' TRANSFER_OWNING_TP_TYPE '||p_mmtt_trx_rec.TRANSFER_OWNING_TP_TYPE);
1071 mydebug(' PLANNING_TP_TYPE '||p_mmtt_trx_rec.PLANNING_TP_TYPE);
1072 mydebug(' XFR_PLANNING_ORGANIZATION_ID '||p_mmtt_trx_rec.XFR_PLANNING_ORGANIZATION_ID);
1073 mydebug(' TRANSFER_PLANNING_TP_TYPE '||p_mmtt_trx_rec.TRANSFER_PLANNING_TP_TYPE);
1074 mydebug(' SECONDARY_UOM_CODE '||p_mmtt_trx_rec.SECONDARY_UOM_CODE);
1075 mydebug(' SECONDARY_TRANSACTION_QUANTITY '||p_mmtt_trx_rec.SECONDARY_TRANSACTION_QUANTITY);
1076 mydebug(' MOVE_ORDER_HEADER_ID '||p_mmtt_trx_rec.MOVE_ORDER_HEADER_ID);
1077 mydebug(' SERIAL_ALLOCATED_FLAG '||p_mmtt_trx_rec.SERIAL_ALLOCATED_FLAG);
1078 mydebug(' ORIGINAL_TRANSACTION_TEMP_ID '||p_mmtt_trx_rec.ORIGINAL_TRANSACTION_TEMP_ID);
1079 mydebug(' TRANSFER_SECONDARY_QUANTITY '||p_mmtt_trx_rec.TRANSFER_SECONDARY_QUANTITY);
1080 mydebug(' TRANSFER_SECONDARY_UOM '||p_mmtt_trx_rec.TRANSFER_SECONDARY_UOM);
1081 mydebug(' TRANSFER_PRICE '||p_mmtt_trx_rec.TRANSFER_PRICE);
1082 -- END IF;
1083 -- IF ((l_debug = 1) AND (p_mtlt_lot_rec.COUNT > 0 )) THEN
1084 mydebug(' TRANSACTION_TEMP_ID '||p_mtlt_lot_rec.TRANSACTION_TEMP_ID);
1085 mydebug(' LAST_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));
1086 mydebug(' LAST_UPDATED_BY '||p_mtlt_lot_rec.LAST_UPDATED_BY);
1087 mydebug(' CREATION_DATE '||TO_CHAR(p_mtlt_lot_rec.CREATION_DATE, l_date_format));
1088 mydebug(' CREATED_BY '||p_mtlt_lot_rec.CREATED_BY);
1089 mydebug(' LAST_UPDATE_LOGIN '||p_mtlt_lot_rec.LAST_UPDATE_LOGIN);
1090 mydebug(' REQUEST_ID '||p_mtlt_lot_rec.REQUEST_ID);
1091 mydebug(' PROGRAM_APPLICATION_ID '||p_mtlt_lot_rec.PROGRAM_APPLICATION_ID);
1095 mydebug(' PRIMARY_QUANTITY '||p_mtlt_lot_rec.PRIMARY_QUANTITY);
1092 mydebug(' PROGRAM_ID '||p_mtlt_lot_rec.PROGRAM_ID);
1093 mydebug(' PROGRAM_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));
1094 mydebug(' TRANSACTION_QUANTITY '||p_mtlt_lot_rec.TRANSACTION_QUANTITY);
1096 mydebug(' LOT_NUMBER '||p_mtlt_lot_rec.LOT_NUMBER);
1097 mydebug(' LOT_EXPIRATION_DATE '||TO_CHAR(p_mtlt_lot_rec.LOT_EXPIRATION_DATE, l_date_format));
1098 mydebug(' ERROR_CODE '||p_mtlt_lot_rec.ERROR_CODE);
1099 mydebug(' SERIAL_TRANSACTION_TEMP_ID '||p_mtlt_lot_rec.SERIAL_TRANSACTION_TEMP_ID);
1100 mydebug(' DESCRIPTION '||p_mtlt_lot_rec.DESCRIPTION);
1101 mydebug(' VENDOR_NAME '||p_mtlt_lot_rec.VENDOR_NAME);
1102 mydebug(' SUPPLIER_LOT_NUMBER '||p_mtlt_lot_rec.SUPPLIER_LOT_NUMBER);
1103 mydebug(' ORIGINATION_DATE '||TO_CHAR(p_mtlt_lot_rec.ORIGINATION_DATE, l_date_format));
1104 mydebug(' DATE_CODE '||p_mtlt_lot_rec.DATE_CODE);
1105 mydebug(' GRADE_CODE '||p_mtlt_lot_rec.GRADE_CODE);
1106 mydebug(' CHANGE_DATE '||TO_CHAR(p_mtlt_lot_rec.CHANGE_DATE, l_date_format));
1107 mydebug(' MATURITY_DATE '||TO_CHAR(p_mtlt_lot_rec.MATURITY_DATE, l_date_format));
1108 mydebug(' STATUS_ID '||p_mtlt_lot_rec.STATUS_ID);
1109 mydebug(' RETEST_DATE '||TO_CHAR(p_mtlt_lot_rec.RETEST_DATE, l_date_format));
1110 mydebug(' AGE '||p_mtlt_lot_rec.AGE);
1111 mydebug(' ITEM_SIZE '||p_mtlt_lot_rec.ITEM_SIZE);
1112 mydebug(' COLOR '||p_mtlt_lot_rec.COLOR);
1113 mydebug(' VOLUME '||p_mtlt_lot_rec.VOLUME);
1114 mydebug(' VOLUME_UOM '||p_mtlt_lot_rec.VOLUME_UOM);
1115 mydebug(' PLACE_OF_ORIGIN '||p_mtlt_lot_rec.PLACE_OF_ORIGIN);
1116 mydebug(' BEST_BY_DATE '||TO_CHAR(p_mtlt_lot_rec.BEST_BY_DATE, l_date_format));
1117 mydebug(' LENGTH '||p_mtlt_lot_rec.LENGTH);
1118 mydebug(' LENGTH_UOM '||p_mtlt_lot_rec.LENGTH_UOM);
1119 mydebug(' RECYCLED_CONTENT '||p_mtlt_lot_rec.RECYCLED_CONTENT);
1120 mydebug(' THICKNESS '||p_mtlt_lot_rec.THICKNESS);
1121 mydebug(' THICKNESS_UOM '||p_mtlt_lot_rec.THICKNESS_UOM);
1122 mydebug(' WIDTH '||p_mtlt_lot_rec.WIDTH);
1123 mydebug(' WIDTH_UOM '||p_mtlt_lot_rec.WIDTH_UOM);
1124 mydebug(' CURL_WRINKLE_FOLD '||p_mtlt_lot_rec.CURL_WRINKLE_FOLD);
1125 mydebug(' LOT_ATTRIBUTE_CATEGORY '||p_mtlt_lot_rec.LOT_ATTRIBUTE_CATEGORY);
1126 mydebug(' C_ATTRIBUTE1 '||p_mtlt_lot_rec.C_ATTRIBUTE1);
1127 mydebug(' C_ATTRIBUTE2 '||p_mtlt_lot_rec.C_ATTRIBUTE2);
1128 mydebug(' C_ATTRIBUTE3 '||p_mtlt_lot_rec.C_ATTRIBUTE3);
1129 mydebug(' C_ATTRIBUTE4 '||p_mtlt_lot_rec.C_ATTRIBUTE4);
1130 mydebug(' C_ATTRIBUTE5 '||p_mtlt_lot_rec.C_ATTRIBUTE5);
1131 mydebug(' C_ATTRIBUTE6 '||p_mtlt_lot_rec.C_ATTRIBUTE6);
1132 mydebug(' C_ATTRIBUTE7 '||p_mtlt_lot_rec.C_ATTRIBUTE7);
1133 mydebug(' C_ATTRIBUTE8 '||p_mtlt_lot_rec.C_ATTRIBUTE8);
1134 mydebug(' C_ATTRIBUTE9 '||p_mtlt_lot_rec.C_ATTRIBUTE9);
1135 mydebug(' C_ATTRIBUTE10 '||p_mtlt_lot_rec.C_ATTRIBUTE10);
1136 mydebug(' C_ATTRIBUTE11 '||p_mtlt_lot_rec.C_ATTRIBUTE11);
1137 mydebug(' C_ATTRIBUTE12 '||p_mtlt_lot_rec.C_ATTRIBUTE12);
1138 mydebug(' C_ATTRIBUTE13 '||p_mtlt_lot_rec.C_ATTRIBUTE13);
1139 mydebug(' C_ATTRIBUTE14 '||p_mtlt_lot_rec.C_ATTRIBUTE14);
1140 mydebug(' C_ATTRIBUTE15 '||p_mtlt_lot_rec.C_ATTRIBUTE15);
1141 mydebug(' C_ATTRIBUTE16 '||p_mtlt_lot_rec.C_ATTRIBUTE16);
1142 mydebug(' C_ATTRIBUTE17 '||p_mtlt_lot_rec.C_ATTRIBUTE17);
1143 mydebug(' C_ATTRIBUTE18 '||p_mtlt_lot_rec.C_ATTRIBUTE18);
1144 mydebug(' C_ATTRIBUTE19 '||p_mtlt_lot_rec.C_ATTRIBUTE19);
1145 mydebug(' C_ATTRIBUTE20 '||p_mtlt_lot_rec.C_ATTRIBUTE20);
1146 mydebug(' D_ATTRIBUTE1 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE1, l_date_format));
1147 mydebug(' D_ATTRIBUTE2 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE2, l_date_format));
1148 mydebug(' D_ATTRIBUTE3 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE3, l_date_format));
1149 mydebug(' D_ATTRIBUTE4 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE4, l_date_format));
1150 mydebug(' D_ATTRIBUTE5 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE5, l_date_format));
1151 mydebug(' D_ATTRIBUTE6 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE6, l_date_format));
1152 mydebug(' D_ATTRIBUTE7 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE7, l_date_format));
1153 mydebug(' D_ATTRIBUTE8 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE8, l_date_format));
1154 mydebug(' D_ATTRIBUTE9 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE9, l_date_format));
1155 mydebug(' D_ATTRIBUTE10 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE10, l_date_format));
1156 mydebug(' N_ATTRIBUTE1 '||p_mtlt_lot_rec.N_ATTRIBUTE1);
1157 mydebug(' N_ATTRIBUTE2 '||p_mtlt_lot_rec.N_ATTRIBUTE2);
1158 mydebug(' N_ATTRIBUTE3 '||p_mtlt_lot_rec.N_ATTRIBUTE3);
1159 mydebug(' N_ATTRIBUTE4 '||p_mtlt_lot_rec.N_ATTRIBUTE4);
1160 mydebug(' N_ATTRIBUTE5 '||p_mtlt_lot_rec.N_ATTRIBUTE5);
1161 mydebug(' N_ATTRIBUTE6 '||p_mtlt_lot_rec.N_ATTRIBUTE6);
1162 mydebug(' N_ATTRIBUTE7 '||p_mtlt_lot_rec.N_ATTRIBUTE7);
1163 mydebug(' N_ATTRIBUTE8 '||p_mtlt_lot_rec.N_ATTRIBUTE8);
1164 mydebug(' N_ATTRIBUTE9 '||p_mtlt_lot_rec.N_ATTRIBUTE9);
1165 mydebug(' N_ATTRIBUTE10 '||p_mtlt_lot_rec.N_ATTRIBUTE10);
1166 mydebug(' VENDOR_ID '||p_mtlt_lot_rec.VENDOR_ID);
1167 mydebug(' TERRITORY_CODE '||p_mtlt_lot_rec.TERRITORY_CODE);
1168 mydebug(' SECONDARY_QUANTITY '||p_mtlt_lot_rec.SECONDARY_QUANTITY);
1169 mydebug(' SECONDARY_UNIT_OF_MEASURE '||p_mtlt_lot_rec.SECONDARY_UNIT_OF_MEASURE);
1173 mydebug(' ATTRIBUTE2 '||p_mtlt_lot_rec.ATTRIBUTE2);
1170 mydebug(' REASON_CODE '||p_mtlt_lot_rec.REASON_CODE);
1171 mydebug(' ATTRIBUTE_CATEGORY '||p_mtlt_lot_rec.ATTRIBUTE_CATEGORY);
1172 mydebug(' ATTRIBUTE1 '||p_mtlt_lot_rec.ATTRIBUTE1);
1174 mydebug(' ATTRIBUTE3 '||p_mtlt_lot_rec.ATTRIBUTE3);
1175 mydebug(' ATTRIBUTE4 '||p_mtlt_lot_rec.ATTRIBUTE4);
1176 mydebug(' ATTRIBUTE5 '||p_mtlt_lot_rec.ATTRIBUTE5);
1177 mydebug(' ATTRIBUTE6 '||p_mtlt_lot_rec.ATTRIBUTE6);
1178 mydebug(' ATTRIBUTE7 '||p_mtlt_lot_rec.ATTRIBUTE7);
1179 mydebug(' ATTRIBUTE8 '||p_mtlt_lot_rec.ATTRIBUTE8);
1180 mydebug(' ATTRIBUTE9 '||p_mtlt_lot_rec.ATTRIBUTE9);
1181 mydebug(' ATTRIBUTE10 '||p_mtlt_lot_rec.ATTRIBUTE10);
1182 mydebug(' ATTRIBUTE11 '||p_mtlt_lot_rec.ATTRIBUTE11);
1183 mydebug(' ATTRIBUTE12 '||p_mtlt_lot_rec.ATTRIBUTE12);
1184 mydebug(' ATTRIBUTE13 '||p_mtlt_lot_rec.ATTRIBUTE13);
1185 mydebug(' ATTRIBUTE14 '||p_mtlt_lot_rec.ATTRIBUTE14);
1186 mydebug(' ATTRIBUTE15 '||p_mtlt_lot_rec.ATTRIBUTE15);
1187 mydebug(' EXPIRATION_ACTION_CODE '||p_mtlt_lot_rec.EXPIRATION_ACTION_CODE);
1188 mydebug(' EXPIRATION_ACTION_DATE '||TO_CHAR(p_mtlt_lot_rec.EXPIRATION_ACTION_DATE, l_date_format));
1189 mydebug(' HOLD_DATE '||TO_CHAR(p_mtlt_lot_rec.HOLD_DATE, l_date_format));
1190 mydebug(' ORIGINATION_TYPE '||p_mtlt_lot_rec.ORIGINATION_TYPE);
1191 mydebug(' PARENT_LOT_NUMBER '||p_mtlt_lot_rec.PARENT_LOT_NUMBER);
1192 mydebug(' REASON_ID '||p_mtlt_lot_rec.REASON_ID);
1193 mydebug(' PARENT_OBJECT_TYPE '||p_mtlt_lot_rec.PARENT_OBJECT_TYPE);
1194 mydebug(' PARENT_OBJECT_ID '||p_mtlt_lot_rec.PARENT_OBJECT_ID);
1195 mydebug(' PARENT_OBJECT_TYPE2 '||p_mtlt_lot_rec.PARENT_OBJECT_TYPE2);
1196 mydebug(' PARENT_OBJECT_ID2 '||p_mtlt_lot_rec.PARENT_OBJECT_ID2);
1197 END IF;
1198 IF ((l_debug = 1) AND (p_table = 1 )) THEN
1199 mydebug(' TRANSACTION_INTERFACE_ID '||p_mti_trx_rec.TRANSACTION_INTERFACE_ID);
1200 mydebug(' TRANSACTION_HEADER_ID '||p_mti_trx_rec.TRANSACTION_HEADER_ID);
1201 mydebug(' SOURCE_CODE '||p_mti_trx_rec.SOURCE_CODE);
1202 mydebug(' SOURCE_LINE_ID '||p_mti_trx_rec.SOURCE_LINE_ID);
1203 mydebug(' SOURCE_HEADER_ID '||p_mti_trx_rec.SOURCE_HEADER_ID);
1204 mydebug(' PROCESS_FLAG '||p_mti_trx_rec.PROCESS_FLAG);
1205 mydebug(' VALIDATION_REQUIRED '||p_mti_trx_rec.VALIDATION_REQUIRED);
1206 mydebug(' TRANSACTION_MODE '||p_mti_trx_rec.TRANSACTION_MODE);
1207 mydebug(' LOCK_FLAG '||p_mti_trx_rec.LOCK_FLAG);
1208 mydebug(' LAST_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));
1209 mydebug(' LAST_UPDATED_BY '||p_mti_trx_rec.LAST_UPDATED_BY);
1210 mydebug(' CREATION_DATE '||TO_CHAR(p_mtlt_lot_rec.CREATION_DATE, l_date_format));
1211 mydebug(' CREATED_BY '||p_mti_trx_rec.CREATED_BY);
1212 mydebug(' LAST_UPDATE_LOGIN '||p_mti_trx_rec.LAST_UPDATE_LOGIN);
1213 mydebug(' REQUEST_ID '||p_mti_trx_rec.REQUEST_ID);
1214 mydebug(' PROGRAM_APPLICATION_ID '||p_mti_trx_rec.PROGRAM_APPLICATION_ID);
1215 mydebug(' PROGRAM_ID '||p_mti_trx_rec.PROGRAM_ID);
1216 mydebug(' PROGRAM_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));
1217 mydebug(' INVENTORY_ITEM_ID '||p_mti_trx_rec.INVENTORY_ITEM_ID);
1218 mydebug(' ITEM_SEGMENT1 '||p_mti_trx_rec.ITEM_SEGMENT1);
1219 mydebug(' ITEM_SEGMENT2 '||p_mti_trx_rec.ITEM_SEGMENT2);
1220 mydebug(' ITEM_SEGMENT3 '||p_mti_trx_rec.ITEM_SEGMENT3);
1221 mydebug(' ITEM_SEGMENT4 '||p_mti_trx_rec.ITEM_SEGMENT4);
1222 mydebug(' ITEM_SEGMENT5 '||p_mti_trx_rec.ITEM_SEGMENT5);
1223 mydebug(' ITEM_SEGMENT6 '||p_mti_trx_rec.ITEM_SEGMENT6);
1224 mydebug(' ITEM_SEGMENT7 '||p_mti_trx_rec.ITEM_SEGMENT7);
1225 mydebug(' ITEM_SEGMENT8 '||p_mti_trx_rec.ITEM_SEGMENT8);
1226 mydebug(' ITEM_SEGMENT9 '||p_mti_trx_rec.ITEM_SEGMENT9);
1227 mydebug(' ITEM_SEGMENT10 '||p_mti_trx_rec.ITEM_SEGMENT10);
1228 mydebug(' ITEM_SEGMENT11 '||p_mti_trx_rec.ITEM_SEGMENT11);
1229 mydebug(' ITEM_SEGMENT12 '||p_mti_trx_rec.ITEM_SEGMENT12);
1230 mydebug(' ITEM_SEGMENT13 '||p_mti_trx_rec.ITEM_SEGMENT13);
1231 mydebug(' ITEM_SEGMENT14 '||p_mti_trx_rec.ITEM_SEGMENT14);
1232 mydebug(' ITEM_SEGMENT15 '||p_mti_trx_rec.ITEM_SEGMENT15);
1233 mydebug(' ITEM_SEGMENT16 '||p_mti_trx_rec.ITEM_SEGMENT16);
1234 mydebug(' ITEM_SEGMENT17 '||p_mti_trx_rec.ITEM_SEGMENT17);
1235 mydebug(' ITEM_SEGMENT18 '||p_mti_trx_rec.ITEM_SEGMENT18);
1236 mydebug(' ITEM_SEGMENT19 '||p_mti_trx_rec.ITEM_SEGMENT19);
1237 mydebug(' ITEM_SEGMENT20 '||p_mti_trx_rec.ITEM_SEGMENT20);
1238 mydebug(' REVISION '||p_mti_trx_rec.REVISION);
1239 mydebug(' ORGANIZATION_ID '||p_mti_trx_rec.ORGANIZATION_ID);
1240 mydebug(' TRANSACTION_QUANTITY '||p_mti_trx_rec.TRANSACTION_QUANTITY);
1241 mydebug(' PRIMARY_QUANTITY '||p_mti_trx_rec.PRIMARY_QUANTITY);
1242 mydebug(' TRANSACTION_UOM '||p_mti_trx_rec.TRANSACTION_UOM);
1243 mydebug(' TRANSACTION_DATE '||TO_CHAR(p_mti_trx_rec.TRANSACTION_DATE, l_date_format));
1244 mydebug(' ACCT_PERIOD_ID '||p_mti_trx_rec.ACCT_PERIOD_ID);
1245 mydebug(' SUBINVENTORY_CODE '||p_mti_trx_rec.SUBINVENTORY_CODE);
1246 mydebug(' LOCATOR_ID '||p_mti_trx_rec.LOCATOR_ID);
1247 mydebug(' LOC_SEGMENT1 '||p_mti_trx_rec.LOC_SEGMENT1);
1248 mydebug(' LOC_SEGMENT2 '||p_mti_trx_rec.LOC_SEGMENT2);
1249 mydebug(' LOC_SEGMENT3 '||p_mti_trx_rec.LOC_SEGMENT3);
1253 mydebug(' LOC_SEGMENT7 '||p_mti_trx_rec.LOC_SEGMENT7);
1250 mydebug(' LOC_SEGMENT4 '||p_mti_trx_rec.LOC_SEGMENT4);
1251 mydebug(' LOC_SEGMENT5 '||p_mti_trx_rec.LOC_SEGMENT5);
1252 mydebug(' LOC_SEGMENT6 '||p_mti_trx_rec.LOC_SEGMENT6);
1254 mydebug(' LOC_SEGMENT8 '||p_mti_trx_rec.LOC_SEGMENT8);
1255 mydebug(' LOC_SEGMENT9 '||p_mti_trx_rec.LOC_SEGMENT9);
1256 mydebug(' LOC_SEGMENT10 '||p_mti_trx_rec.LOC_SEGMENT10);
1257 mydebug(' LOC_SEGMENT11 '||p_mti_trx_rec.LOC_SEGMENT11);
1258 mydebug(' LOC_SEGMENT12 '||p_mti_trx_rec.LOC_SEGMENT12);
1259 mydebug(' LOC_SEGMENT13 '||p_mti_trx_rec.LOC_SEGMENT13);
1260 mydebug(' LOC_SEGMENT14 '||p_mti_trx_rec.LOC_SEGMENT14);
1261 mydebug(' LOC_SEGMENT15 '||p_mti_trx_rec.LOC_SEGMENT15);
1262 mydebug(' LOC_SEGMENT16 '||p_mti_trx_rec.LOC_SEGMENT16);
1263 mydebug(' LOC_SEGMENT17 '||p_mti_trx_rec.LOC_SEGMENT17);
1264 mydebug(' LOC_SEGMENT18 '||p_mti_trx_rec.LOC_SEGMENT18);
1265 mydebug(' LOC_SEGMENT19 '||p_mti_trx_rec.LOC_SEGMENT19);
1266 mydebug(' LOC_SEGMENT20 '||p_mti_trx_rec.LOC_SEGMENT20);
1267 mydebug(' TRANSACTION_SOURCE_ID '||p_mti_trx_rec.TRANSACTION_SOURCE_ID);
1268 mydebug(' DSP_SEGMENT1 '||p_mti_trx_rec.DSP_SEGMENT1);
1269 mydebug(' DSP_SEGMENT2 '||p_mti_trx_rec.DSP_SEGMENT2);
1270 mydebug(' DSP_SEGMENT3 '||p_mti_trx_rec.DSP_SEGMENT3);
1271 mydebug(' DSP_SEGMENT4 '||p_mti_trx_rec.DSP_SEGMENT4);
1272 mydebug(' DSP_SEGMENT5 '||p_mti_trx_rec.DSP_SEGMENT5);
1273 mydebug(' DSP_SEGMENT6 '||p_mti_trx_rec.DSP_SEGMENT6);
1274 mydebug(' DSP_SEGMENT7 '||p_mti_trx_rec.DSP_SEGMENT7);
1275 mydebug(' DSP_SEGMENT8 '||p_mti_trx_rec.DSP_SEGMENT8);
1276 mydebug(' DSP_SEGMENT9 '||p_mti_trx_rec.DSP_SEGMENT9);
1277 mydebug(' DSP_SEGMENT10 '||p_mti_trx_rec.DSP_SEGMENT10);
1278 mydebug(' DSP_SEGMENT11 '||p_mti_trx_rec.DSP_SEGMENT11);
1279 mydebug(' DSP_SEGMENT12 '||p_mti_trx_rec.DSP_SEGMENT12);
1280 mydebug(' DSP_SEGMENT13 '||p_mti_trx_rec.DSP_SEGMENT13);
1281 mydebug(' DSP_SEGMENT14 '||p_mti_trx_rec.DSP_SEGMENT14);
1282 mydebug(' DSP_SEGMENT15 '||p_mti_trx_rec.DSP_SEGMENT15);
1283 mydebug(' DSP_SEGMENT16 '||p_mti_trx_rec.DSP_SEGMENT16);
1284 mydebug(' DSP_SEGMENT17 '||p_mti_trx_rec.DSP_SEGMENT17);
1285 mydebug(' DSP_SEGMENT18 '||p_mti_trx_rec.DSP_SEGMENT18);
1286 mydebug(' DSP_SEGMENT19 '||p_mti_trx_rec.DSP_SEGMENT19);
1287 mydebug(' DSP_SEGMENT20 '||p_mti_trx_rec.DSP_SEGMENT20);
1288 mydebug(' DSP_SEGMENT21 '||p_mti_trx_rec.DSP_SEGMENT21);
1289 mydebug(' DSP_SEGMENT22 '||p_mti_trx_rec.DSP_SEGMENT22);
1290 mydebug(' DSP_SEGMENT23 '||p_mti_trx_rec.DSP_SEGMENT23);
1291 mydebug(' DSP_SEGMENT24 '||p_mti_trx_rec.DSP_SEGMENT24);
1292 mydebug(' DSP_SEGMENT25 '||p_mti_trx_rec.DSP_SEGMENT25);
1293 mydebug(' DSP_SEGMENT26 '||p_mti_trx_rec.DSP_SEGMENT26);
1294 mydebug(' DSP_SEGMENT27 '||p_mti_trx_rec.DSP_SEGMENT27);
1295 mydebug(' DSP_SEGMENT28 '||p_mti_trx_rec.DSP_SEGMENT28);
1296 mydebug(' DSP_SEGMENT29 '||p_mti_trx_rec.DSP_SEGMENT29);
1297 mydebug(' DSP_SEGMENT30 '||p_mti_trx_rec.DSP_SEGMENT30);
1298 mydebug(' TRANSACTION_SOURCE_NAME '||p_mti_trx_rec.TRANSACTION_SOURCE_NAME);
1299 mydebug(' TRANSACTION_SOURCE_TYPE_ID '||p_mti_trx_rec.TRANSACTION_SOURCE_TYPE_ID);
1300 mydebug(' TRANSACTION_ACTION_ID '||p_mti_trx_rec.TRANSACTION_ACTION_ID);
1301 mydebug(' TRANSACTION_TYPE_ID '||p_mti_trx_rec.TRANSACTION_TYPE_ID);
1302 mydebug(' REASON_ID '||p_mti_trx_rec.REASON_ID);
1303 mydebug(' TRANSACTION_REFERENCE '||p_mti_trx_rec.TRANSACTION_REFERENCE);
1304 mydebug(' TRANSACTION_COST '||p_mti_trx_rec.TRANSACTION_COST);
1305 mydebug(' DISTRIBUTION_ACCOUNT_ID '||p_mti_trx_rec.DISTRIBUTION_ACCOUNT_ID);
1306 mydebug(' DST_SEGMENT1 '||p_mti_trx_rec.DST_SEGMENT1);
1307 mydebug(' DST_SEGMENT2 '||p_mti_trx_rec.DST_SEGMENT2);
1308 mydebug(' DST_SEGMENT3 '||p_mti_trx_rec.DST_SEGMENT3);
1309 mydebug(' DST_SEGMENT4 '||p_mti_trx_rec.DST_SEGMENT4);
1310 mydebug(' DST_SEGMENT5 '||p_mti_trx_rec.DST_SEGMENT5);
1311 mydebug(' DST_SEGMENT6 '||p_mti_trx_rec.DST_SEGMENT6);
1312 mydebug(' DST_SEGMENT7 '||p_mti_trx_rec.DST_SEGMENT7);
1313 mydebug(' DST_SEGMENT8 '||p_mti_trx_rec.DST_SEGMENT8);
1314 mydebug(' DST_SEGMENT9 '||p_mti_trx_rec.DST_SEGMENT9);
1315 mydebug(' DST_SEGMENT10 '||p_mti_trx_rec.DST_SEGMENT10);
1316 mydebug(' DST_SEGMENT11 '||p_mti_trx_rec.DST_SEGMENT11);
1317 mydebug(' DST_SEGMENT12 '||p_mti_trx_rec.DST_SEGMENT12);
1318 mydebug(' DST_SEGMENT13 '||p_mti_trx_rec.DST_SEGMENT13);
1319 mydebug(' DST_SEGMENT14 '||p_mti_trx_rec.DST_SEGMENT14);
1320 mydebug(' DST_SEGMENT15 '||p_mti_trx_rec.DST_SEGMENT15);
1321 mydebug(' DST_SEGMENT16 '||p_mti_trx_rec.DST_SEGMENT16);
1322 mydebug(' DST_SEGMENT17 '||p_mti_trx_rec.DST_SEGMENT17);
1323 mydebug(' DST_SEGMENT18 '||p_mti_trx_rec.DST_SEGMENT18);
1324 mydebug(' DST_SEGMENT19 '||p_mti_trx_rec.DST_SEGMENT19);
1325 mydebug(' DST_SEGMENT20 '||p_mti_trx_rec.DST_SEGMENT20);
1326 mydebug(' DST_SEGMENT21 '||p_mti_trx_rec.DST_SEGMENT21);
1327 mydebug(' DST_SEGMENT22 '||p_mti_trx_rec.DST_SEGMENT22);
1328 mydebug(' DST_SEGMENT23 '||p_mti_trx_rec.DST_SEGMENT23);
1329 mydebug(' DST_SEGMENT24 '||p_mti_trx_rec.DST_SEGMENT24);
1330 mydebug(' DST_SEGMENT25 '||p_mti_trx_rec.DST_SEGMENT25);
1331 mydebug(' DST_SEGMENT26 '||p_mti_trx_rec.DST_SEGMENT26);
1335 mydebug(' DST_SEGMENT30 '||p_mti_trx_rec.DST_SEGMENT30);
1332 mydebug(' DST_SEGMENT27 '||p_mti_trx_rec.DST_SEGMENT27);
1333 mydebug(' DST_SEGMENT28 '||p_mti_trx_rec.DST_SEGMENT28);
1334 mydebug(' DST_SEGMENT29 '||p_mti_trx_rec.DST_SEGMENT29);
1336 mydebug(' REQUISITION_LINE_ID '||p_mti_trx_rec.REQUISITION_LINE_ID);
1337 mydebug(' CURRENCY_CODE '||p_mti_trx_rec.CURRENCY_CODE);
1338 mydebug(' CURRENCY_CONVERSION_DATE '||TO_CHAR(p_mti_trx_rec.CURRENCY_CONVERSION_DATE, l_date_format));
1339 mydebug(' CURRENCY_CONVERSION_TYPE '||p_mti_trx_rec.CURRENCY_CONVERSION_TYPE);
1340 mydebug(' CURRENCY_CONVERSION_RATE '||p_mti_trx_rec.CURRENCY_CONVERSION_RATE);
1341 mydebug(' USSGL_TRANSACTION_CODE '||p_mti_trx_rec.USSGL_TRANSACTION_CODE);
1342 mydebug(' WIP_ENTITY_TYPE '||p_mti_trx_rec.WIP_ENTITY_TYPE);
1343 mydebug(' SCHEDULE_ID '||p_mti_trx_rec.SCHEDULE_ID);
1344 mydebug(' EMPLOYEE_CODE '||p_mti_trx_rec.EMPLOYEE_CODE);
1345 mydebug(' DEPARTMENT_ID '||p_mti_trx_rec.DEPARTMENT_ID);
1346 mydebug(' SCHEDULE_UPDATE_CODE '||p_mti_trx_rec.SCHEDULE_UPDATE_CODE);
1347 mydebug(' SETUP_TEARDOWN_CODE '||p_mti_trx_rec.SETUP_TEARDOWN_CODE);
1348 mydebug(' PRIMARY_SWITCH '||p_mti_trx_rec.PRIMARY_SWITCH);
1349 mydebug(' MRP_CODE '||p_mti_trx_rec.MRP_CODE);
1350 mydebug(' OPERATION_SEQ_NUM '||p_mti_trx_rec.OPERATION_SEQ_NUM);
1351 mydebug(' REPETITIVE_LINE_ID '||p_mti_trx_rec.REPETITIVE_LINE_ID);
1352 mydebug(' PICKING_LINE_ID '||p_mti_trx_rec.PICKING_LINE_ID);
1353 mydebug(' TRX_SOURCE_LINE_ID '||p_mti_trx_rec.TRX_SOURCE_LINE_ID);
1354 mydebug(' TRX_SOURCE_DELIVERY_ID '||p_mti_trx_rec.TRX_SOURCE_DELIVERY_ID);
1355 mydebug(' DEMAND_ID '||p_mti_trx_rec.DEMAND_ID);
1356 mydebug(' CUSTOMER_SHIP_ID '||p_mti_trx_rec.CUSTOMER_SHIP_ID);
1357 mydebug(' LINE_ITEM_NUM '||p_mti_trx_rec.LINE_ITEM_NUM);
1358 mydebug(' RECEIVING_DOCUMENT '||p_mti_trx_rec.RECEIVING_DOCUMENT);
1359 mydebug(' RCV_TRANSACTION_ID '||p_mti_trx_rec.RCV_TRANSACTION_ID);
1360 mydebug(' SHIP_TO_LOCATION_ID '||p_mti_trx_rec.SHIP_TO_LOCATION_ID);
1361 mydebug(' ENCUMBRANCE_ACCOUNT '||p_mti_trx_rec.ENCUMBRANCE_ACCOUNT);
1362 mydebug(' ENCUMBRANCE_AMOUNT '||p_mti_trx_rec.ENCUMBRANCE_AMOUNT);
1363 mydebug(' VENDOR_LOT_NUMBER '||p_mti_trx_rec.VENDOR_LOT_NUMBER);
1364 mydebug(' TRANSFER_SUBINVENTORY '||p_mti_trx_rec.TRANSFER_SUBINVENTORY);
1365 mydebug(' TRANSFER_ORGANIZATION '||p_mti_trx_rec.TRANSFER_ORGANIZATION);
1366 mydebug(' TRANSFER_LOCATOR '||p_mti_trx_rec.TRANSFER_LOCATOR);
1367 mydebug(' XFER_LOC_SEGMENT1 '||p_mti_trx_rec.XFER_LOC_SEGMENT1);
1368 mydebug(' XFER_LOC_SEGMENT2 '||p_mti_trx_rec.XFER_LOC_SEGMENT2);
1369 mydebug(' XFER_LOC_SEGMENT3 '||p_mti_trx_rec.XFER_LOC_SEGMENT3);
1370 mydebug(' XFER_LOC_SEGMENT4 '||p_mti_trx_rec.XFER_LOC_SEGMENT4);
1371 mydebug(' XFER_LOC_SEGMENT5 '||p_mti_trx_rec.XFER_LOC_SEGMENT5);
1372 mydebug(' XFER_LOC_SEGMENT6 '||p_mti_trx_rec.XFER_LOC_SEGMENT6);
1373 mydebug(' XFER_LOC_SEGMENT7 '||p_mti_trx_rec.XFER_LOC_SEGMENT7);
1374 mydebug(' XFER_LOC_SEGMENT8 '||p_mti_trx_rec.XFER_LOC_SEGMENT8);
1375 mydebug(' XFER_LOC_SEGMENT9 '||p_mti_trx_rec.XFER_LOC_SEGMENT9);
1376 mydebug(' XFER_LOC_SEGMENT10 '||p_mti_trx_rec.XFER_LOC_SEGMENT10);
1377 mydebug(' XFER_LOC_SEGMENT11 '||p_mti_trx_rec.XFER_LOC_SEGMENT11);
1378 mydebug(' XFER_LOC_SEGMENT12 '||p_mti_trx_rec.XFER_LOC_SEGMENT12);
1379 mydebug(' XFER_LOC_SEGMENT13 '||p_mti_trx_rec.XFER_LOC_SEGMENT13);
1380 mydebug(' XFER_LOC_SEGMENT14 '||p_mti_trx_rec.XFER_LOC_SEGMENT14);
1381 mydebug(' XFER_LOC_SEGMENT15 '||p_mti_trx_rec.XFER_LOC_SEGMENT15);
1382 mydebug(' XFER_LOC_SEGMENT16 '||p_mti_trx_rec.XFER_LOC_SEGMENT16);
1383 mydebug(' XFER_LOC_SEGMENT17 '||p_mti_trx_rec.XFER_LOC_SEGMENT17);
1384 mydebug(' XFER_LOC_SEGMENT18 '||p_mti_trx_rec.XFER_LOC_SEGMENT18);
1385 mydebug(' XFER_LOC_SEGMENT19 '||p_mti_trx_rec.XFER_LOC_SEGMENT19);
1386 mydebug(' XFER_LOC_SEGMENT20 '||p_mti_trx_rec.XFER_LOC_SEGMENT20);
1387 mydebug(' SHIPMENT_NUMBER '||p_mti_trx_rec.SHIPMENT_NUMBER);
1388 mydebug(' TRANSPORTATION_COST '||p_mti_trx_rec.TRANSPORTATION_COST);
1389 mydebug(' TRANSPORTATION_ACCOUNT '||p_mti_trx_rec.TRANSPORTATION_ACCOUNT);
1390 mydebug(' TRANSFER_COST '||p_mti_trx_rec.TRANSFER_COST);
1391 mydebug(' FREIGHT_CODE '||p_mti_trx_rec.FREIGHT_CODE);
1392 mydebug(' CONTAINERS '||p_mti_trx_rec.CONTAINERS);
1393 mydebug(' WAYBILL_AIRBILL '||p_mti_trx_rec.WAYBILL_AIRBILL);
1394 mydebug(' EXPECTED_ARRIVAL_DATE '||TO_CHAR(p_mti_trx_rec.EXPECTED_ARRIVAL_DATE, l_date_format));
1395 mydebug(' NEW_AVERAGE_COST '||p_mti_trx_rec.NEW_AVERAGE_COST);
1396 mydebug(' VALUE_CHANGE '||p_mti_trx_rec.VALUE_CHANGE);
1397 mydebug(' PERCENTAGE_CHANGE '||p_mti_trx_rec.PERCENTAGE_CHANGE);
1398 mydebug(' DEMAND_SOURCE_HEADER_ID '||p_mti_trx_rec.DEMAND_SOURCE_HEADER_ID);
1399 mydebug(' DEMAND_SOURCE_LINE '||p_mti_trx_rec.DEMAND_SOURCE_LINE);
1400 mydebug(' DEMAND_SOURCE_DELIVERY '||p_mti_trx_rec.DEMAND_SOURCE_DELIVERY);
1401 mydebug(' NEGATIVE_REQ_FLAG '||p_mti_trx_rec.NEGATIVE_REQ_FLAG);
1402 mydebug(' ERROR_EXPLANATION '||p_mti_trx_rec.ERROR_EXPLANATION);
1403 mydebug(' SHIPPABLE_FLAG '||p_mti_trx_rec.SHIPPABLE_FLAG);
1404 mydebug(' ERROR_CODE '||p_mti_trx_rec.ERROR_CODE);
1408 mydebug(' ATTRIBUTE2 '||p_mti_trx_rec.ATTRIBUTE2);
1405 mydebug(' REQUIRED_FLAG '||p_mti_trx_rec.REQUIRED_FLAG);
1406 mydebug(' ATTRIBUTE_CATEGORY '||p_mti_trx_rec.ATTRIBUTE_CATEGORY);
1407 mydebug(' ATTRIBUTE1 '||p_mti_trx_rec.ATTRIBUTE1);
1409 mydebug(' ATTRIBUTE3 '||p_mti_trx_rec.ATTRIBUTE3);
1410 mydebug(' ATTRIBUTE4 '||p_mti_trx_rec.ATTRIBUTE4);
1411 mydebug(' ATTRIBUTE5 '||p_mti_trx_rec.ATTRIBUTE5);
1412 mydebug(' ATTRIBUTE6 '||p_mti_trx_rec.ATTRIBUTE6);
1413 mydebug(' ATTRIBUTE7 '||p_mti_trx_rec.ATTRIBUTE7);
1414 mydebug(' ATTRIBUTE8 '||p_mti_trx_rec.ATTRIBUTE8);
1415 mydebug(' ATTRIBUTE9 '||p_mti_trx_rec.ATTRIBUTE9);
1416 mydebug(' ATTRIBUTE10 '||p_mti_trx_rec.ATTRIBUTE10);
1417 mydebug(' ATTRIBUTE11 '||p_mti_trx_rec.ATTRIBUTE11);
1418 mydebug(' ATTRIBUTE12 '||p_mti_trx_rec.ATTRIBUTE12);
1419 mydebug(' ATTRIBUTE13 '||p_mti_trx_rec.ATTRIBUTE13);
1420 mydebug(' ATTRIBUTE14 '||p_mti_trx_rec.ATTRIBUTE14);
1421 mydebug(' ATTRIBUTE15 '||p_mti_trx_rec.ATTRIBUTE15);
1422 mydebug(' REQUISITION_DISTRIBUTION_ID '||p_mti_trx_rec.REQUISITION_DISTRIBUTION_ID);
1423 mydebug(' MOVEMENT_ID '||p_mti_trx_rec.MOVEMENT_ID);
1424 mydebug(' RESERVATION_QUANTITY '||p_mti_trx_rec.RESERVATION_QUANTITY);
1425 mydebug(' SHIPPED_QUANTITY '||p_mti_trx_rec.SHIPPED_QUANTITY);
1426 mydebug(' INVENTORY_ITEM '||p_mti_trx_rec.INVENTORY_ITEM);
1427 mydebug(' LOCATOR_NAME '||p_mti_trx_rec.LOCATOR_NAME);
1428 mydebug(' TASK_ID '||p_mti_trx_rec.TASK_ID);
1429 mydebug(' TO_TASK_ID '||p_mti_trx_rec.TO_TASK_ID);
1430 mydebug(' SOURCE_TASK_ID '||p_mti_trx_rec.SOURCE_TASK_ID);
1431 mydebug(' PROJECT_ID '||p_mti_trx_rec.PROJECT_ID);
1432 mydebug(' TO_PROJECT_ID '||p_mti_trx_rec.TO_PROJECT_ID);
1433 mydebug(' SOURCE_PROJECT_ID '||p_mti_trx_rec.SOURCE_PROJECT_ID);
1434 mydebug(' PA_EXPENDITURE_ORG_ID '||p_mti_trx_rec.PA_EXPENDITURE_ORG_ID);
1435 mydebug(' EXPENDITURE_TYPE '||p_mti_trx_rec.EXPENDITURE_TYPE);
1436 mydebug(' FINAL_COMPLETION_FLAG '||p_mti_trx_rec.FINAL_COMPLETION_FLAG);
1437 mydebug(' TRANSFER_PERCENTAGE '||p_mti_trx_rec.TRANSFER_PERCENTAGE);
1438 mydebug(' TRANSACTION_SEQUENCE_ID '||p_mti_trx_rec.TRANSACTION_SEQUENCE_ID);
1439 mydebug(' MATERIAL_ACCOUNT '||p_mti_trx_rec.MATERIAL_ACCOUNT);
1440 mydebug(' MATERIAL_OVERHEAD_ACCOUNT '||p_mti_trx_rec.MATERIAL_OVERHEAD_ACCOUNT);
1441 mydebug(' RESOURCE_ACCOUNT '||p_mti_trx_rec.RESOURCE_ACCOUNT);
1442 mydebug(' OUTSIDE_PROCESSING_ACCOUNT '||p_mti_trx_rec.OUTSIDE_PROCESSING_ACCOUNT);
1443 mydebug(' OVERHEAD_ACCOUNT '||p_mti_trx_rec.OVERHEAD_ACCOUNT);
1444 mydebug(' BOM_REVISION '||p_mti_trx_rec.BOM_REVISION);
1445 mydebug(' ROUTING_REVISION '||p_mti_trx_rec.ROUTING_REVISION);
1446 mydebug(' BOM_REVISION_DATE '||TO_CHAR(p_mti_trx_rec.BOM_REVISION_DATE, l_date_format));
1447 mydebug(' ROUTING_REVISION_DATE '||TO_CHAR(p_mti_trx_rec.ROUTING_REVISION_DATE, l_date_format));
1448 mydebug(' ALTERNATE_BOM_DESIGNATOR '||p_mti_trx_rec.ALTERNATE_BOM_DESIGNATOR);
1449 mydebug(' ALTERNATE_ROUTING_DESIGNATOR '||p_mti_trx_rec.ALTERNATE_ROUTING_DESIGNATOR);
1450 mydebug(' ACCOUNTING_CLASS '||p_mti_trx_rec.ACCOUNTING_CLASS);
1451 mydebug(' DEMAND_CLASS '||p_mti_trx_rec.DEMAND_CLASS);
1452 mydebug(' PARENT_ID '||p_mti_trx_rec.PARENT_ID);
1453 mydebug(' SUBSTITUTION_TYPE_ID '||p_mti_trx_rec.SUBSTITUTION_TYPE_ID);
1454 mydebug(' SUBSTITUTION_ITEM_ID '||p_mti_trx_rec.SUBSTITUTION_ITEM_ID);
1455 mydebug(' SCHEDULE_GROUP '||p_mti_trx_rec.SCHEDULE_GROUP);
1456 mydebug(' BUILD_SEQUENCE '||p_mti_trx_rec.BUILD_SEQUENCE);
1457 mydebug(' SCHEDULE_NUMBER '||p_mti_trx_rec.SCHEDULE_NUMBER);
1458 mydebug(' SCHEDULED_FLAG '||p_mti_trx_rec.SCHEDULED_FLAG);
1459 mydebug(' FLOW_SCHEDULE '||p_mti_trx_rec.FLOW_SCHEDULE);
1460 mydebug(' COST_GROUP_ID '||p_mti_trx_rec.COST_GROUP_ID);
1461 mydebug(' KANBAN_CARD_ID '||p_mti_trx_rec.KANBAN_CARD_ID);
1462 mydebug(' QA_COLLECTION_ID '||p_mti_trx_rec.QA_COLLECTION_ID);
1463 mydebug(' OVERCOMPLETION_TRANSACTION_QTY '||p_mti_trx_rec.OVERCOMPLETION_TRANSACTION_QTY);
1464 mydebug(' OVERCOMPLETION_PRIMARY_QTY '||p_mti_trx_rec.OVERCOMPLETION_PRIMARY_QTY);
1465 mydebug(' OVERCOMPLETION_TRANSACTION_ID '||p_mti_trx_rec.OVERCOMPLETION_TRANSACTION_ID);
1466 mydebug(' END_ITEM_UNIT_NUMBER '||p_mti_trx_rec.END_ITEM_UNIT_NUMBER);
1467 mydebug(' SCHEDULED_PAYBACK_DATE '||TO_CHAR(p_mti_trx_rec.SCHEDULED_PAYBACK_DATE, l_date_format));
1468 mydebug(' ORG_COST_GROUP_ID '||p_mti_trx_rec.ORG_COST_GROUP_ID);
1469 mydebug(' COST_TYPE_ID '||p_mti_trx_rec.COST_TYPE_ID);
1470 mydebug(' SOURCE_LOT_NUMBER '||p_mti_trx_rec.SOURCE_LOT_NUMBER);
1471 mydebug(' TRANSFER_COST_GROUP_ID '||p_mti_trx_rec.TRANSFER_COST_GROUP_ID);
1472 mydebug(' LPN_ID '||p_mti_trx_rec.LPN_ID);
1473 mydebug(' TRANSFER_LPN_ID '||p_mti_trx_rec.TRANSFER_LPN_ID);
1474 mydebug(' CONTENT_LPN_ID '||p_mti_trx_rec.CONTENT_LPN_ID);
1475 mydebug(' XML_DOCUMENT_ID '||p_mti_trx_rec.XML_DOCUMENT_ID);
1476 mydebug(' ORGANIZATION_TYPE '||p_mti_trx_rec.ORGANIZATION_TYPE);
1477 mydebug(' TRANSFER_ORGANIZATION_TYPE '||p_mti_trx_rec.TRANSFER_ORGANIZATION_TYPE);
1478 mydebug(' OWNING_ORGANIZATION_ID '||p_mti_trx_rec.OWNING_ORGANIZATION_ID);
1479 mydebug(' OWNING_TP_TYPE '||p_mti_trx_rec.OWNING_TP_TYPE);
1483 mydebug(' PLANNING_TP_TYPE '||p_mti_trx_rec.PLANNING_TP_TYPE);
1480 mydebug(' XFR_OWNING_ORGANIZATION_ID '||p_mti_trx_rec.XFR_OWNING_ORGANIZATION_ID);
1481 mydebug(' TRANSFER_OWNING_TP_TYPE '||p_mti_trx_rec.TRANSFER_OWNING_TP_TYPE);
1482 mydebug(' PLANNING_ORGANIZATION_ID '||p_mti_trx_rec.PLANNING_ORGANIZATION_ID);
1484 mydebug(' XFR_PLANNING_ORGANIZATION_ID '||p_mti_trx_rec.XFR_PLANNING_ORGANIZATION_ID);
1485 mydebug(' TRANSFER_PLANNING_TP_TYPE '||p_mti_trx_rec.TRANSFER_PLANNING_TP_TYPE);
1486 mydebug(' SECONDARY_UOM_CODE '||p_mti_trx_rec.SECONDARY_UOM_CODE);
1487 mydebug(' SECONDARY_TRANSACTION_QUANTITY '||p_mti_trx_rec.SECONDARY_TRANSACTION_QUANTITY);
1488 -- Bug 9239746 : Commenting the following two columns as they are obsolete.
1489 -- mydebug(' TRANSACTION_GROUP_ID '||p_mti_trx_rec.TRANSACTION_GROUP_ID);
1490 -- mydebug(' TRANSACTION_GROUP_SEQ '||p_mti_trx_rec.TRANSACTION_GROUP_SEQ);
1491 mydebug(' REPRESENTATIVE_LOT_NUMBER '||p_mti_trx_rec.REPRESENTATIVE_LOT_NUMBER);
1492 mydebug(' TRANSACTION_BATCH_ID '||p_mti_trx_rec.TRANSACTION_BATCH_ID);
1493 mydebug(' TRANSACTION_BATCH_SEQ '||p_mti_trx_rec.TRANSACTION_BATCH_SEQ);
1494 mydebug(' REBUILD_ITEM_ID '||p_mti_trx_rec.REBUILD_ITEM_ID);
1495 mydebug(' REBUILD_SERIAL_NUMBER '||p_mti_trx_rec.REBUILD_SERIAL_NUMBER);
1496 mydebug(' REBUILD_ACTIVITY_ID '||p_mti_trx_rec.REBUILD_ACTIVITY_ID);
1497 mydebug(' REBUILD_JOB_NAME '||p_mti_trx_rec.REBUILD_JOB_NAME);
1498 mydebug(' MOVE_TRANSACTION_ID '||p_mti_trx_rec.MOVE_TRANSACTION_ID);
1499 mydebug(' COMPLETION_TRANSACTION_ID '||p_mti_trx_rec.COMPLETION_TRANSACTION_ID);
1500 mydebug(' WIP_SUPPLY_TYPE '||p_mti_trx_rec.WIP_SUPPLY_TYPE);
1501 mydebug(' RELIEVE_RESERVATIONS_FLAG '||p_mti_trx_rec.RELIEVE_RESERVATIONS_FLAG);
1502 mydebug(' RELIEVE_HIGH_LEVEL_RSV_FLAG '||p_mti_trx_rec.RELIEVE_HIGH_LEVEL_RSV_FLAG);
1503 mydebug(' TRANSFER_PRICE '||p_mti_trx_rec.TRANSFER_PRICE);
1504 -- END IF;
1505 -- IF ((l_debug = 1) AND (p_mtli_lot_rec.COUNT > 0 )) THEN
1506 mydebug(' TRANSACTION_INTERFACE_ID '||p_mtli_lot_rec.TRANSACTION_INTERFACE_ID);
1507 mydebug(' SOURCE_CODE '||p_mtli_lot_rec.SOURCE_CODE);
1508 mydebug(' SOURCE_LINE_ID '||p_mtli_lot_rec.SOURCE_LINE_ID);
1509 mydebug(' LAST_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));
1510 mydebug(' LAST_UPDATED_BY '||p_mtli_lot_rec.LAST_UPDATED_BY);
1511 mydebug(' CREATION_DATE '||TO_CHAR(p_mtlt_lot_rec.CREATION_DATE, l_date_format));
1512 mydebug(' CREATED_BY '||p_mtli_lot_rec.CREATED_BY);
1513 mydebug(' LAST_UPDATE_LOGIN '||p_mtli_lot_rec.LAST_UPDATE_LOGIN);
1514 mydebug(' REQUEST_ID '||p_mtli_lot_rec.REQUEST_ID);
1515 mydebug(' PROGRAM_APPLICATION_ID '||p_mtli_lot_rec.PROGRAM_APPLICATION_ID);
1516 mydebug(' PROGRAM_ID '||p_mtli_lot_rec.PROGRAM_ID);
1517 mydebug(' PROGRAM_UPDATE_DATE '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));
1518 mydebug(' LOT_NUMBER '||p_mtli_lot_rec.LOT_NUMBER);
1519 mydebug(' LOT_EXPIRATION_DATE '||TO_CHAR(p_mtlt_lot_rec.LOT_EXPIRATION_DATE, l_date_format));
1520 mydebug(' TRANSACTION_QUANTITY '||p_mtli_lot_rec.TRANSACTION_QUANTITY);
1521 mydebug(' PRIMARY_QUANTITY '||p_mtli_lot_rec.PRIMARY_QUANTITY);
1522 mydebug(' SERIAL_TRANSACTION_TEMP_ID '||p_mtli_lot_rec.SERIAL_TRANSACTION_TEMP_ID);
1523 mydebug(' ERROR_CODE '||p_mtli_lot_rec.ERROR_CODE);
1524 mydebug(' PROCESS_FLAG '||p_mtli_lot_rec.PROCESS_FLAG);
1525 mydebug(' DESCRIPTION '||p_mtli_lot_rec.DESCRIPTION);
1526 mydebug(' VENDOR_NAME '||p_mtli_lot_rec.VENDOR_NAME);
1527 mydebug(' SUPPLIER_LOT_NUMBER '||p_mtli_lot_rec.SUPPLIER_LOT_NUMBER);
1528 mydebug(' ORIGINATION_DATE '||TO_CHAR(p_mtlt_lot_rec.ORIGINATION_DATE, l_date_format));
1529 mydebug(' DATE_CODE '||p_mtli_lot_rec.DATE_CODE);
1530 mydebug(' GRADE_CODE '||p_mtli_lot_rec.GRADE_CODE);
1531 mydebug(' CHANGE_DATE '||TO_CHAR(p_mtlt_lot_rec.CHANGE_DATE, l_date_format));
1532 mydebug(' MATURITY_DATE '||TO_CHAR(p_mtlt_lot_rec.MATURITY_DATE, l_date_format));
1533 mydebug(' STATUS_ID '||p_mtli_lot_rec.STATUS_ID);
1534 mydebug(' RETEST_DATE '||TO_CHAR(p_mtlt_lot_rec.RETEST_DATE, l_date_format));
1535 mydebug(' AGE '||p_mtli_lot_rec.AGE);
1536 mydebug(' ITEM_SIZE '||p_mtli_lot_rec.ITEM_SIZE);
1537 mydebug(' COLOR '||p_mtli_lot_rec.COLOR);
1538 mydebug(' VOLUME '||p_mtli_lot_rec.VOLUME);
1539 mydebug(' VOLUME_UOM '||p_mtli_lot_rec.VOLUME_UOM);
1540 mydebug(' PLACE_OF_ORIGIN '||p_mtli_lot_rec.PLACE_OF_ORIGIN);
1541 mydebug(' BEST_BY_DATE '||TO_CHAR(p_mtlt_lot_rec.BEST_BY_DATE, l_date_format));
1542 mydebug(' LENGTH '||p_mtli_lot_rec.LENGTH);
1543 mydebug(' LENGTH_UOM '||p_mtli_lot_rec.LENGTH_UOM);
1544 mydebug(' RECYCLED_CONTENT '||p_mtli_lot_rec.RECYCLED_CONTENT);
1545 mydebug(' THICKNESS '||p_mtli_lot_rec.THICKNESS);
1546 mydebug(' THICKNESS_UOM '||p_mtli_lot_rec.THICKNESS_UOM);
1547 mydebug(' WIDTH '||p_mtli_lot_rec.WIDTH);
1548 mydebug(' WIDTH_UOM '||p_mtli_lot_rec.WIDTH_UOM);
1549 mydebug(' CURL_WRINKLE_FOLD '||p_mtli_lot_rec.CURL_WRINKLE_FOLD);
1550 mydebug(' LOT_ATTRIBUTE_CATEGORY '||p_mtli_lot_rec.LOT_ATTRIBUTE_CATEGORY);
1551 mydebug(' C_ATTRIBUTE1 '||p_mtli_lot_rec.C_ATTRIBUTE1);
1552 mydebug(' C_ATTRIBUTE2 '||p_mtli_lot_rec.C_ATTRIBUTE2);
1553 mydebug(' C_ATTRIBUTE3 '||p_mtli_lot_rec.C_ATTRIBUTE3);
1554 mydebug(' C_ATTRIBUTE4 '||p_mtli_lot_rec.C_ATTRIBUTE4);
1555 mydebug(' C_ATTRIBUTE5 '||p_mtli_lot_rec.C_ATTRIBUTE5);
1559 mydebug(' C_ATTRIBUTE9 '||p_mtli_lot_rec.C_ATTRIBUTE9);
1556 mydebug(' C_ATTRIBUTE6 '||p_mtli_lot_rec.C_ATTRIBUTE6);
1557 mydebug(' C_ATTRIBUTE7 '||p_mtli_lot_rec.C_ATTRIBUTE7);
1558 mydebug(' C_ATTRIBUTE8 '||p_mtli_lot_rec.C_ATTRIBUTE8);
1560 mydebug(' C_ATTRIBUTE10 '||p_mtli_lot_rec.C_ATTRIBUTE10);
1561 mydebug(' C_ATTRIBUTE11 '||p_mtli_lot_rec.C_ATTRIBUTE11);
1562 mydebug(' C_ATTRIBUTE12 '||p_mtli_lot_rec.C_ATTRIBUTE12);
1563 mydebug(' C_ATTRIBUTE13 '||p_mtli_lot_rec.C_ATTRIBUTE13);
1564 mydebug(' C_ATTRIBUTE14 '||p_mtli_lot_rec.C_ATTRIBUTE14);
1565 mydebug(' C_ATTRIBUTE15 '||p_mtli_lot_rec.C_ATTRIBUTE15);
1566 mydebug(' C_ATTRIBUTE16 '||p_mtli_lot_rec.C_ATTRIBUTE16);
1567 mydebug(' C_ATTRIBUTE17 '||p_mtli_lot_rec.C_ATTRIBUTE17);
1568 mydebug(' C_ATTRIBUTE18 '||p_mtli_lot_rec.C_ATTRIBUTE18);
1569 mydebug(' C_ATTRIBUTE19 '||p_mtli_lot_rec.C_ATTRIBUTE19);
1570 mydebug(' C_ATTRIBUTE20 '||p_mtli_lot_rec.C_ATTRIBUTE20);
1571 mydebug(' D_ATTRIBUTE1 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE1, l_date_format));
1572 mydebug(' D_ATTRIBUTE2 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE2, l_date_format));
1573 mydebug(' D_ATTRIBUTE3 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE3, l_date_format));
1574 mydebug(' D_ATTRIBUTE4 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE4, l_date_format));
1575 mydebug(' D_ATTRIBUTE5 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE5, l_date_format));
1576 mydebug(' D_ATTRIBUTE6 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE6, l_date_format));
1577 mydebug(' D_ATTRIBUTE7 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE7, l_date_format));
1578 mydebug(' D_ATTRIBUTE8 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE8, l_date_format));
1579 mydebug(' D_ATTRIBUTE9 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE9, l_date_format));
1580 mydebug(' D_ATTRIBUTE10 '||TO_CHAR(p_mtlt_lot_rec.D_ATTRIBUTE10, l_date_format));
1581 mydebug(' N_ATTRIBUTE1 '||p_mtli_lot_rec.N_ATTRIBUTE1);
1582 mydebug(' N_ATTRIBUTE2 '||p_mtli_lot_rec.N_ATTRIBUTE2);
1583 mydebug(' N_ATTRIBUTE3 '||p_mtli_lot_rec.N_ATTRIBUTE3);
1584 mydebug(' N_ATTRIBUTE4 '||p_mtli_lot_rec.N_ATTRIBUTE4);
1585 mydebug(' N_ATTRIBUTE5 '||p_mtli_lot_rec.N_ATTRIBUTE5);
1586 mydebug(' N_ATTRIBUTE6 '||p_mtli_lot_rec.N_ATTRIBUTE6);
1587 mydebug(' N_ATTRIBUTE7 '||p_mtli_lot_rec.N_ATTRIBUTE7);
1588 mydebug(' N_ATTRIBUTE8 '||p_mtli_lot_rec.N_ATTRIBUTE8);
1589 mydebug(' N_ATTRIBUTE9 '||p_mtli_lot_rec.N_ATTRIBUTE9);
1590 mydebug(' N_ATTRIBUTE10 '||p_mtli_lot_rec.N_ATTRIBUTE10);
1591 mydebug(' VENDOR_ID '||p_mtli_lot_rec.VENDOR_ID);
1592 mydebug(' TERRITORY_CODE '||p_mtli_lot_rec.TERRITORY_CODE);
1593 mydebug(' PRODUCT_CODE '||p_mtli_lot_rec.PRODUCT_CODE);
1594 mydebug(' PRODUCT_TRANSACTION_ID '||p_mtli_lot_rec.PRODUCT_TRANSACTION_ID);
1595 mydebug(' SECONDARY_TRANSACTION_QUANTITY '||p_mtli_lot_rec.SECONDARY_TRANSACTION_QUANTITY);
1596 mydebug(' SUBLOT_NUM '||p_mtli_lot_rec.SUBLOT_NUM);
1597 mydebug(' REASON_CODE '||p_mtli_lot_rec.REASON_CODE);
1598 mydebug(' ATTRIBUTE_CATEGORY '||p_mtli_lot_rec.ATTRIBUTE_CATEGORY);
1599 mydebug(' ATTRIBUTE1 '||p_mtli_lot_rec.ATTRIBUTE1);
1600 mydebug(' ATTRIBUTE2 '||p_mtli_lot_rec.ATTRIBUTE2);
1601 mydebug(' ATTRIBUTE3 '||p_mtli_lot_rec.ATTRIBUTE3);
1602 mydebug(' ATTRIBUTE4 '||p_mtli_lot_rec.ATTRIBUTE4);
1603 mydebug(' ATTRIBUTE5 '||p_mtli_lot_rec.ATTRIBUTE5);
1604 mydebug(' ATTRIBUTE6 '||p_mtli_lot_rec.ATTRIBUTE6);
1605 mydebug(' ATTRIBUTE7 '||p_mtli_lot_rec.ATTRIBUTE7);
1606 mydebug(' ATTRIBUTE8 '||p_mtli_lot_rec.ATTRIBUTE8);
1607 mydebug(' ATTRIBUTE9 '||p_mtli_lot_rec.ATTRIBUTE9);
1608 mydebug(' ATTRIBUTE10 '||p_mtli_lot_rec.ATTRIBUTE10);
1609 mydebug(' ATTRIBUTE11 '||p_mtli_lot_rec.ATTRIBUTE11);
1610 mydebug(' ATTRIBUTE12 '||p_mtli_lot_rec.ATTRIBUTE12);
1611 mydebug(' ATTRIBUTE13 '||p_mtli_lot_rec.ATTRIBUTE13);
1612 mydebug(' ATTRIBUTE14 '||p_mtli_lot_rec.ATTRIBUTE14);
1613 mydebug(' ATTRIBUTE15 '||p_mtli_lot_rec.ATTRIBUTE15);
1614 mydebug(' EXPIRATION_ACTION_CODE '||p_mtli_lot_rec.EXPIRATION_ACTION_CODE);
1615 mydebug(' EXPIRATION_ACTION_DATE '||TO_CHAR(p_mtlt_lot_rec.EXPIRATION_ACTION_DATE, l_date_format));
1616 mydebug(' HOLD_DATE '||TO_CHAR(p_mtlt_lot_rec.HOLD_DATE, l_date_format));
1617 mydebug(' ORIGINATION_TYPE '||p_mtli_lot_rec.ORIGINATION_TYPE);
1618 mydebug(' PARENT_LOT_NUMBER '||p_mtli_lot_rec.PARENT_LOT_NUMBER);
1619 mydebug(' REASON_ID '||p_mtli_lot_rec.REASON_ID);
1620 mydebug(' PARENT_OBJECT_TYPE '||p_mtli_lot_rec.PARENT_OBJECT_TYPE);
1621 mydebug(' PARENT_OBJECT_ID '||p_mtli_lot_rec.PARENT_OBJECT_ID);
1622 mydebug(' PARENT_OBJECT_NUMBER '||p_mtli_lot_rec.PARENT_OBJECT_NUMBER);
1623 mydebug(' PARENT_ITEM_ID '||p_mtli_lot_rec.PARENT_ITEM_ID);
1624 mydebug(' PARENT_OBJECT_TYPE2 '||p_mtli_lot_rec.PARENT_OBJECT_TYPE2);
1625 mydebug(' PARENT_OBJECT_ID2 '||p_mtli_lot_rec.PARENT_OBJECT_ID2);
1626 mydebug(' PARENT_OBJECT_NUMBER2 '||p_mtli_lot_rec.PARENT_OBJECT_NUMBER2);
1627 END IF;
1628 EXCEPTION
1629 WHEN OTHERS THEN
1630 mydebug('WHEN OTHERS exception : '||SQLERRM, 'LOG_TRANSACTION_REC');
1631 END log_transaction_rec;
1632
1633 END INV_CALCULATE_EXP_DATE;