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