eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SERIAL_CHECK dependencies on INV_LOG_UTIL

Line 29: inv_log_util.trace('In inv_mark_serial, no reservation', 'SERIAL_CHECK');

25:
26: l_debug := g_debug;
27:
28: IF (l_debug = 1) THEN
29: inv_log_util.trace('In inv_mark_serial, no reservation', 'SERIAL_CHECK');
30: END IF;
31:
32: inv_mark_rsv_serial
33: ( from_serial_number => from_serial_number

Line 46: inv_log_util.trace('success is ' || l_success, 'SERIAL_CHECK');

42: , success => l_success
43: );
44:
45: IF (l_debug = 1) THEN
46: inv_log_util.trace('success is ' || l_success, 'SERIAL_CHECK');
47: END IF;
48:
49: success := l_success;
50: /*** End R12 }} ***/

Line 55: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

51:
52: EXCEPTION
53: WHEN OTHERS then
54: if( l_debug = 1 ) then
55: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
56: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
57: end if;
58: success := -3;
59: END inv_mark_serial;

Line 56: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');

52: EXCEPTION
53: WHEN OTHERS then
54: if( l_debug = 1 ) then
55: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
56: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
57: end if;
58: success := -3;
59: END inv_mark_serial;
60:

Line 90: inv_log_util.trace('In inv_mark_serial overloaded with reservation_id', 'SERIAL_CHECK');

86:
87: l_debug := g_debug;
88:
89: IF (l_debug = 1) THEN
90: inv_log_util.trace('In inv_mark_serial overloaded with reservation_id', 'SERIAL_CHECK');
91: END IF;
92:
93: DECLARE
94: marked_numbers_found NUMBER:= 0;

Line 126: inv_log_util.trace('Inside inv_mark_serial hdr_id is ' || l_hdr_id, 'SERIAL_CHECK');

122: end if;
123: success := 1;
124:
125: if( l_debug = 1 ) then
126: inv_log_util.trace('Inside inv_mark_serial hdr_id is ' || l_hdr_id, 'SERIAL_CHECK');
127: end if;
128: IF (to_serial_number IS NOT NULL) and NOT (from_serial_number = to_serial_number ) then
129: if( l_debug = 1 ) then
130: inv_log_util.trace('to_serial_number is ' || to_serial_number, 'SERIAL_CHECK');

Line 130: inv_log_util.trace('to_serial_number is ' || to_serial_number, 'SERIAL_CHECK');

126: inv_log_util.trace('Inside inv_mark_serial hdr_id is ' || l_hdr_id, 'SERIAL_CHECK');
127: end if;
128: IF (to_serial_number IS NOT NULL) and NOT (from_serial_number = to_serial_number ) then
129: if( l_debug = 1 ) then
130: inv_log_util.trace('to_serial_number is ' || to_serial_number, 'SERIAL_CHECK');
131: end if;
132: success := 1 ;
133: OPEN serial_lock1 ;
134:

Line 147: inv_log_util.trace('marked_numbers_found is ' || marked_numbers_found, 'SERIAL_CHECK');

143: --BUG 2249383 Cannot have same item with serial number in different org
144: --AND current_organization_id = org_id
145:
146: if( l_debug = 1 ) then
147: inv_log_util.trace('marked_numbers_found is ' || marked_numbers_found, 'SERIAL_CHECK');
148: end if;
149: IF (marked_numbers_found > 0) then
150: success := -1 ;
151: CLOSE serial_lock1 ;

Line 180: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

176: CLOSE serial_lock1;
177: success := 3;
178: end if;
179: if( l_debug = 1 ) then
180: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
181: end if;
182: else
183: if( l_debug = 1) then
184: inv_log_util.trace('to_serial_number is null or same', 'SERIAL_CHECK');

Line 184: inv_log_util.trace('to_serial_number is null or same', 'SERIAL_CHECK');

180: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
181: end if;
182: else
183: if( l_debug = 1) then
184: inv_log_util.trace('to_serial_number is null or same', 'SERIAL_CHECK');
185: end if;
186: success := 2 ;
187: OPEN serial_lock2 ;
188:

Line 199: inv_log_util.trace('marked_numbers_found is ' || marked_numbers_found, 'SERIAL_CHECK');

195: --BUG 2249383 Cannot have same item with serial number in different org
196: --AND current_organization_id = org_id
197:
198: if( l_debug = 1 ) then
199: inv_log_util.trace('marked_numbers_found is ' || marked_numbers_found, 'SERIAL_CHECK');
200: end if;
201: IF (marked_numbers_found > 0) then
202: success := -1;
203: CLOSE serial_lock2;

Line 230: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

226: CLOSE serial_lock2;
227: success := 3;
228: end if;
229: if( l_debug = 1 ) then
230: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
231: end if;
232: end if;
233:
234: /*** {{ R12 Enhanced reservations code changes ***/

Line 244: inv_log_util.trace('Error updating serial_reservation_quantity in mtl_reservations', 'INV_MARK_SERIAL');

240:
241: EXCEPTION
242: WHEN others THEN
243: IF (l_debug = 1) THEN
244: inv_log_util.trace('Error updating serial_reservation_quantity in mtl_reservations', 'INV_MARK_SERIAL');
245: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'INV_MARK_SERIAL');
246: END IF;
247: END;
248: END IF;

Line 245: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'INV_MARK_SERIAL');

241: EXCEPTION
242: WHEN others THEN
243: IF (l_debug = 1) THEN
244: inv_log_util.trace('Error updating serial_reservation_quantity in mtl_reservations', 'INV_MARK_SERIAL');
245: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'INV_MARK_SERIAL');
246: END IF;
247: END;
248: END IF;
249: /*** End R12 }} ***/

Line 259: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

255: CLOSE serial_lock2;
256: end if;
257: success := -2;
258: if( l_debug = 1 ) then
259: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');
261: end if;
262: WHEN OTHERS then
263: IF success = 1 then

Line 260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');

256: end if;
257: success := -2;
258: if( l_debug = 1 ) then
259: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');
261: end if;
262: WHEN OTHERS then
263: IF success = 1 then
264: CLOSE serial_lock1;

Line 270: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

266: CLOSE serial_lock2;
267: end if;
268: success := -3;
269: if( l_debug = 1 ) then
270: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
271: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
272: end if;
273: END;
274: null;

Line 271: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');

267: end if;
268: success := -3;
269: if( l_debug = 1 ) then
270: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
271: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
272: end if;
273: END;
274: null;
275: EXCEPTION

Line 278: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');

274: null;
275: EXCEPTION
276: WHEN OTHERS then
277: if( l_debug = 1 ) then
278: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
279: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
280: end if;
281: success := -3;
282: END inv_mark_rsv_serial;

Line 279: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');

275: EXCEPTION
276: WHEN OTHERS then
277: if( l_debug = 1 ) then
278: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
279: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
280: end if;
281: success := -3;
282: END inv_mark_rsv_serial;
283:

Line 306: inv_log_util.trace('In inv_unmark_serial, no reservation', 'SERIAL_CHECK');

302:
303: l_debug := g_debug;
304:
305: IF (l_debug = 1) THEN
306: inv_log_util.trace('In inv_unmark_serial, no reservation', 'SERIAL_CHECK');
307: END IF;
308:
309: inv_unmark_rsv_serial
310: ( from_serial_number => from_serial_number

Line 325: inv_log_util.trace('exception in inv_unmark_serial, sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');

321:
322: EXCEPTION
323: WHEN OTHERS then
324: if( l_debug = 1 ) then
325: inv_log_util.trace('exception in inv_unmark_serial, sqlerrm is ' || substr(sqlerrm, 1, 200), 'SERIAL_CHECK');
326: end if;
327: END inv_unmark_serial;
328:
329:

Line 434: inv_log_util.TRACE('Inside inv_unmark_serial', 'SERIAL_CHECK');

430: -- if (serial_code = 5 OR serial_code = 6) then
431: -- unmarked_value := -1 ;
432: -- end if;
433: IF (l_debug = 1) THEN
434: inv_log_util.TRACE('Inside inv_unmark_serial', 'SERIAL_CHECK');
435: inv_log_util.TRACE('from_serial_number = ' || from_serial_number
436: || ' to_serial_number = ' || to_serial_number, 'SERIAL_CHECK');
437: inv_log_util.TRACE('serial_code = ' || serial_code || ' hdr_id = ' || hdr_id
438: || ' temp_id = ' || temp_id || ' lot_temp_id = ' || lot_temp_id

Line 435: inv_log_util.TRACE('from_serial_number = ' || from_serial_number

431: -- unmarked_value := -1 ;
432: -- end if;
433: IF (l_debug = 1) THEN
434: inv_log_util.TRACE('Inside inv_unmark_serial', 'SERIAL_CHECK');
435: inv_log_util.TRACE('from_serial_number = ' || from_serial_number
436: || ' to_serial_number = ' || to_serial_number, 'SERIAL_CHECK');
437: inv_log_util.TRACE('serial_code = ' || serial_code || ' hdr_id = ' || hdr_id
438: || ' temp_id = ' || temp_id || ' lot_temp_id = ' || lot_temp_id
439: || ' p_inventory_item_id = ' || p_inventory_item_id

Line 437: inv_log_util.TRACE('serial_code = ' || serial_code || ' hdr_id = ' || hdr_id

433: IF (l_debug = 1) THEN
434: inv_log_util.TRACE('Inside inv_unmark_serial', 'SERIAL_CHECK');
435: inv_log_util.TRACE('from_serial_number = ' || from_serial_number
436: || ' to_serial_number = ' || to_serial_number, 'SERIAL_CHECK');
437: inv_log_util.TRACE('serial_code = ' || serial_code || ' hdr_id = ' || hdr_id
438: || ' temp_id = ' || temp_id || ' lot_temp_id = ' || lot_temp_id
439: || ' p_inventory_item_id = ' || p_inventory_item_id
440: || ' p_update_reservation = ' || p_update_reservation , 'SERIAL_CHECK');
441: END IF;

Line 452: inv_log_util.TRACE('Update msn with serial_number= from_serial_number and '

448: from_serial_number = to_serial_number
449: )
450: ) THEN
451: IF (l_debug = 1) THEN
452: inv_log_util.TRACE('Update msn with serial_number= from_serial_number and '
453: || 'inventory_item_id = ' || p_inventory_item_id, 'SERIAL_CHECK');
454: END IF;
455:
456: /*** {{ R12 Enhanced reservations code changes ***/

Line 470: inv_log_util.TRACE('Case 1 and p_update_reservation is T', 'inv_unmark_rsv_serial');

466: /*** End R12 }} ***/
467:
468: IF (p_update_reservation = fnd_api.g_true) THEN
469: IF (l_debug = 1) THEN
470: inv_log_util.TRACE('Case 1 and p_update_reservation is T', 'inv_unmark_rsv_serial');
471: END IF;
472: UPDATE mtl_serial_numbers
473: SET line_mark_id = unmarked_value
474: , group_mark_id = unmarked_value

Line 479: inv_log_util.trace('Case 1, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

475: , lot_line_mark_id = unmarked_value
476: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/
477: WHERE serial_number = from_serial_number AND inventory_item_id = p_inventory_item_id;
478: IF (l_debug = 1) THEN
479: inv_log_util.trace('Case 1, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
480: END IF;
481: ELSE
482: IF (l_debug = 1) THEN
483: inv_log_util.TRACE('Case 1 and p_update_reservation it F', 'inv_unmark_rsv_serial');

Line 483: inv_log_util.TRACE('Case 1 and p_update_reservation it F', 'inv_unmark_rsv_serial');

479: inv_log_util.trace('Case 1, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
480: END IF;
481: ELSE
482: IF (l_debug = 1) THEN
483: inv_log_util.TRACE('Case 1 and p_update_reservation it F', 'inv_unmark_rsv_serial');
484: END IF;
485: UPDATE mtl_serial_numbers
486: SET line_mark_id = unmarked_value
487: , group_mark_id = unmarked_value

Line 491: inv_log_util.trace('Case 1, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

487: , group_mark_id = unmarked_value
488: , lot_line_mark_id = unmarked_value
489: WHERE serial_number = from_serial_number AND inventory_item_id = p_inventory_item_id;
490: IF (l_debug = 1) THEN
491: inv_log_util.trace('Case 1, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
492: END IF;
493: END IF;
494: ELSE
495: IF (l_debug = 1) THEN

Line 496: inv_log_util.TRACE('Update msn with serial_number >= '

492: END IF;
493: END IF;
494: ELSE
495: IF (l_debug = 1) THEN
496: inv_log_util.TRACE('Update msn with serial_number >= '
497: || ' nvl(from_serial_number, serial_number) '
498: || ' AND serial_number <= nvl(to_serial_number, '
499: || 'nvl(from_serial_number, serial_number)) AND inventory_item_id= '
500: || p_inventory_item_id, 'SERIAL_CHECK');

Line 516: inv_log_util.TRACE('Case 2 and p_update_reservation it T', 'inv_unmark_rsv_serial');

512: /*** End R12 }} ***/
513:
514: IF (p_update_reservation = fnd_api.g_true) THEN
515: IF (l_debug = 1) THEN
516: inv_log_util.TRACE('Case 2 and p_update_reservation it T', 'inv_unmark_rsv_serial');
517: END IF;
518: UPDATE mtl_serial_numbers
519: SET line_mark_id = unmarked_value
520: , group_mark_id = unmarked_value

Line 527: inv_log_util.trace('Case 2, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

523: WHERE serial_number >= NVL(from_serial_number, serial_number) AND
524: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
525: inventory_item_id = p_inventory_item_id;
526: IF (l_debug = 1) THEN
527: inv_log_util.trace('Case 2, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
528: END IF;
529: ELSE
530: IF (l_debug = 1) THEN
531: inv_log_util.TRACE('Case 2 and p_update_reservation it F', 'inv_unmark_rsv_serial');

Line 531: inv_log_util.TRACE('Case 2 and p_update_reservation it F', 'inv_unmark_rsv_serial');

527: inv_log_util.trace('Case 2, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
528: END IF;
529: ELSE
530: IF (l_debug = 1) THEN
531: inv_log_util.TRACE('Case 2 and p_update_reservation it F', 'inv_unmark_rsv_serial');
532: END IF;
533: UPDATE mtl_serial_numbers
534: SET line_mark_id = unmarked_value
535: , group_mark_id = unmarked_value

Line 541: inv_log_util.trace('Case 2, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

537: WHERE serial_number >= NVL(from_serial_number, serial_number) AND
538: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
539: inventory_item_id = p_inventory_item_id;
540: IF (l_debug = 1) THEN
541: inv_log_util.trace('Case 2, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
542: END IF;
543: END IF; --END IF p_update_reservation is T
544: END IF; --END IF fm_serial = to_serial
545: ELSE

Line 548: inv_log_util.TRACE('Update msn with group_mark_id in ('

544: END IF; --END IF fm_serial = to_serial
545: ELSE
546: IF (lot_temp_id IS NOT NULL) THEN
547: IF (l_debug = 1) THEN
548: inv_log_util.TRACE('Update msn with group_mark_id in ('
549: || hdr_id || ', ' || lot_temp_id || ', ' || temp_id
550: || 'AND (line_mark_id = ' || temp_id
551: || ' OR line_mark_id is NULL OR line_mark_id = -1)', 'SERIAL_CHECK');
552: inv_log_util.TRACE(' AND (lot_line_mark_id = '|| lot_temp_id

Line 552: inv_log_util.TRACE(' AND (lot_line_mark_id = '|| lot_temp_id

548: inv_log_util.TRACE('Update msn with group_mark_id in ('
549: || hdr_id || ', ' || lot_temp_id || ', ' || temp_id
550: || 'AND (line_mark_id = ' || temp_id
551: || ' OR line_mark_id is NULL OR line_mark_id = -1)', 'SERIAL_CHECK');
552: inv_log_util.TRACE(' AND (lot_line_mark_id = '|| lot_temp_id
553: || ' OR lot_line_mark_id IS NULL OR '
554: || 'lot_line_mark_id = -1) AND serial_number >= nvl(from_serial_number, serial_number) '
555: || ' serial_number <= nvl(to_serial_number, nvl(from_serial_number, serial_number)) '
556: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number)) ', 'SERIAL_CHECK');

Line 572: inv_log_util.TRACE('Case 3 and p_update_reservation it T', 'inv_unmark_rsv_serial');

568: /*** End R12 }} ***/
569:
570: IF (p_update_reservation = fnd_api.g_true) THEN
571: IF (l_debug = 1) THEN
572: inv_log_util.TRACE('Case 3 and p_update_reservation it T', 'inv_unmark_rsv_serial');
573: END IF;
574: UPDATE mtl_serial_numbers
575: SET line_mark_id = unmarked_value
576: , group_mark_id = unmarked_value

Line 591: inv_log_util.trace('Case 3, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

587: serial_number >= NVL(from_serial_number, serial_number) AND
588: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
589: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
590: IF (l_debug = 1) THEN
591: inv_log_util.trace('Case 3, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
592: END IF;
593: ELSE
594: IF (l_debug = 1) THEN
595: inv_log_util.TRACE('Case 3 and p_update_reservation it F', 'inv_unmark_rsv_serial');

Line 595: inv_log_util.TRACE('Case 3 and p_update_reservation it F', 'inv_unmark_rsv_serial');

591: inv_log_util.trace('Case 3, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
592: END IF;
593: ELSE
594: IF (l_debug = 1) THEN
595: inv_log_util.TRACE('Case 3 and p_update_reservation it F', 'inv_unmark_rsv_serial');
596: END IF;
597: UPDATE mtl_serial_numbers
598: SET line_mark_id = unmarked_value
599: , group_mark_id = unmarked_value

Line 613: inv_log_util.trace('Case 3, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

609: serial_number >= NVL(from_serial_number, serial_number) AND
610: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
611: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
612: IF (l_debug = 1) THEN
613: inv_log_util.trace('Case 3, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
614: END IF;
615: END IF;
616: ELSE
617: IF (temp_id IS NOT NULL) THEN

Line 619: inv_log_util.TRACE(

615: END IF;
616: ELSE
617: IF (temp_id IS NOT NULL) THEN
618: IF (l_debug = 1) THEN
619: inv_log_util.TRACE(
620: 'update msn with group_mark_id in ('|| hdr_id || ', '|| temp_id
621: || ' AND (line_mark_id = '|| temp_id || ' OR line_mark_id is NULL or line_mark_id = -1 ) AND '
622: || ' serial_number >= nvl(from_serial_number, serial_number) '
623: || ' AND serial_number <= nvl(to_serial_number, nvl(from_serial_number, serial_number)) '

Line 640: inv_log_util.TRACE('Case 4 and p_update_reservation it T', 'inv_unmark_rsv_serial');

636: /*** End R12 }} ***/
637:
638: IF (p_update_reservation = fnd_api.g_true) THEN
639: IF (l_debug = 1) THEN
640: inv_log_util.TRACE('Case 4 and p_update_reservation it T', 'inv_unmark_rsv_serial');
641: END IF;
642: UPDATE mtl_serial_numbers
643: SET line_mark_id = unmarked_value
644: , group_mark_id = unmarked_value

Line 655: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

651: serial_number >= NVL(from_serial_number, serial_number) AND
652: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
653: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
654: IF (l_debug = 1) THEN
655: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
656: END IF;
657: ELSE
658: IF (l_debug = 1) THEN
659: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');

Line 659: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');

655: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
656: END IF;
657: ELSE
658: IF (l_debug = 1) THEN
659: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');
660: END IF;
661: UPDATE mtl_serial_numbers
662: SET line_mark_id = unmarked_value
663: , group_mark_id = unmarked_value

Line 673: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

669: serial_number >= NVL(from_serial_number, serial_number) AND
670: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
671: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
672: IF (l_debug = 1) THEN
673: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
674: END IF;
675: END IF;
676: ELSE
677: IF (l_debug = 1) THEN

Line 678: inv_log_util.TRACE('update msn with group_mark_id = '

674: END IF;
675: END IF;
676: ELSE
677: IF (l_debug = 1) THEN
678: inv_log_util.TRACE('update msn with group_mark_id = '
679: || hdr_id || ' AND serial_number >= nvl(from_serial_number, serial_number) '
680: || ' AND serial_number <= nvl(to_serial_number, nvl(from_serial_number, serial_number)) '
681: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number))', 'SERIAL_CHECK');
682: END IF;

Line 697: inv_log_util.TRACE('Case 5 and p_update_reservation it T', 'inv_unmark_rsv_serial');

693: /*** End R12 }} ***/
694:
695: IF (p_update_reservation = fnd_api.g_true) THEN
696: IF (l_debug = 1) THEN
697: inv_log_util.TRACE('Case 5 and p_update_reservation it T', 'inv_unmark_rsv_serial');
698: END IF;
699: UPDATE mtl_serial_numbers
700: SET line_mark_id = unmarked_value
701: , group_mark_id = unmarked_value

Line 709: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

705: serial_number >= NVL(from_serial_number, serial_number) AND
706: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
707: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
708: IF (l_debug = 1) THEN
709: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
710: END IF;
711: ELSE
712: IF (l_debug = 1) THEN
713: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');

Line 713: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');

709: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
710: END IF;
711: ELSE
712: IF (l_debug = 1) THEN
713: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');
714: END IF;
715: UPDATE mtl_serial_numbers
716: SET line_mark_id = unmarked_value
717: , group_mark_id = unmarked_value

Line 724: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

720: serial_number >= NVL(from_serial_number, serial_number) AND
721: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
722: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
723: IF (l_debug = 1) THEN
724: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
725: END IF;
726: END IF; --END IF p_update_reservation = F
727: END IF; --END IF p_temp_id IS NOT NULL
728: END IF; --END IF lote_temp_id IS NOT NULL

Line 742: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');

738: WHERE reservation_id = l_rsv_id_tbl(i);
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (l_debug = 1) THEN
742: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');
743: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');
744: END IF;
745: END;
746: END LOOP;

Line 743: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');

739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (l_debug = 1) THEN
742: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');
743: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');
744: END IF;
745: END;
746: END LOOP;
747: END IF;

Line 764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');

760:
761: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
762: BEGIN
763: IF (l_debug = 1) THEN
764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');

Line 765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');

761: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
762: BEGIN
763: IF (l_debug = 1) THEN
764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');

Line 766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');

762: BEGIN
763: IF (l_debug = 1) THEN
764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');

Line 767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');

763: IF (l_debug = 1) THEN
764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');

Line 768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');

764: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
772: END IF;

Line 769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');

765: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
772: END IF;
773:

Line 770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');

766: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
772: END IF;
773:
774: success := TRUE;

Line 771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');

767: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
768: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
769: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
770: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
771: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
772: END IF;
773:
774: success := TRUE;
775:

Line 778: inv_log_util.trace('temp_id, hdr_id are both null, return false','SERIAL_CHECK');

774: success := TRUE;
775:
776: IF (temp_id IS NULL AND hdr_id IS NULL) THEN
777: IF (l_debug = 1) THEN
778: inv_log_util.trace('temp_id, hdr_id are both null, return false','SERIAL_CHECK');
779: END IF;
780: success := FALSE;
781: RETURN;
782: END IF;

Line 787: inv_log_util.trace('to_serial_number is null or same as from_serial_number','SERIAL_CHECK');

783:
784: IF (to_serial_number IS NULL OR (from_serial_number = to_serial_number)) THEN
785:
786: IF (l_debug = 1) THEN
787: inv_log_util.trace('to_serial_number is null or same as from_serial_number','SERIAL_CHECK');
788: END IF;
789:
790: BEGIN
791: UPDATE mtl_serial_numbers

Line 800: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

796: EXCEPTION
797: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
798: success := FALSE;
799: IF (l_debug = 1) THEN
800: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
801: END IF;
802: END;
803:
804: success := TRUE;

Line 808: inv_log_util.trace('to_serial_number not null and different from from_serial_number','SERIAL_CHECK');

804: success := TRUE;
805: ELSIF (to_serial_number IS NOT NULL AND NOT (from_serial_number = to_serial_number)) THEN
806:
807: IF (l_debug = 1) THEN
808: inv_log_util.trace('to_serial_number not null and different from from_serial_number','SERIAL_CHECK');
809: END IF;
810:
811: BEGIN
812: UPDATE mtl_serial_numbers

Line 822: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

818: EXCEPTION
819: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
820: success := FALSE;
821: IF (l_debug = 1) THEN
822: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
823: END IF;
824: END;
825:
826: success := TRUE;

Line 835: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200),'SERIAL_CHECK');

831: EXCEPTION
832: WHEN others THEN
833: success := FALSE;
834: IF ( l_debug = 1 ) THEN
835: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200),'SERIAL_CHECK');
836: END IF;
837:
838: END inv_update_marked_serial;
839: