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 in (select SERIAL_TRANSACTION_TEMP_ID'
622: || ' from mtl_transaction_lots_temp where group_header_id = '|| hdr_id||' and transaction_temp_id = '||temp_id
623: || ') OR line_mark_id is NULL or line_mark_id = -1 ) AND '

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

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

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

660: serial_number >= NVL(from_serial_number, serial_number) AND
661: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
662: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
663: IF (l_debug = 1) THEN
664: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
665: END IF;
666: ELSE
667: IF (l_debug = 1) THEN
668: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');

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

664: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
665: END IF;
666: ELSE
667: IF (l_debug = 1) THEN
668: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');
669: END IF;
670: UPDATE mtl_serial_numbers
671: SET line_mark_id = unmarked_value
672: , group_mark_id = unmarked_value

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

685: serial_number >= NVL(from_serial_number, serial_number) AND
686: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
687: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
688: IF (l_debug = 1) THEN
689: inv_log_util.trace('Case 4, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
690: END IF;
691: END IF;
692: ELSE
693: IF (l_debug = 1) THEN

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

690: END IF;
691: END IF;
692: ELSE
693: IF (l_debug = 1) THEN
694: inv_log_util.TRACE('update msn with group_mark_id = '
695: || hdr_id || ' AND serial_number >= nvl(from_serial_number, serial_number) '
696: || ' AND serial_number <= nvl(to_serial_number, nvl(from_serial_number, serial_number)) '
697: || ' AND length(serial_number) = length(nvl(from_serial_number, serial_number))', 'SERIAL_CHECK');
698: END IF;

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

709: /*** End R12 }} ***/
710:
711: IF (p_update_reservation = fnd_api.g_true) THEN
712: IF (l_debug = 1) THEN
713: inv_log_util.TRACE('Case 5 and p_update_reservation it T', '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 725: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');

721: serial_number >= NVL(from_serial_number, serial_number) AND
722: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
723: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
724: IF (l_debug = 1) THEN
725: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
726: END IF;
727: ELSE
728: IF (l_debug = 1) THEN
729: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');

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

725: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
726: END IF;
727: ELSE
728: IF (l_debug = 1) THEN
729: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');
730: END IF;
731: UPDATE mtl_serial_numbers
732: SET line_mark_id = unmarked_value
733: , group_mark_id = unmarked_value

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

736: serial_number >= NVL(from_serial_number, serial_number) AND
737: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
738: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) );
739: IF (l_debug = 1) THEN
740: inv_log_util.trace('Case 5, no. of serials unmarked: ' || SQL%rowcount, 'inv_unmark_rsv_serial');
741: END IF;
742: END IF; --END IF p_update_reservation = F
743: END IF; --END IF p_temp_id IS NOT NULL
744: END IF; --END IF lote_temp_id IS NOT NULL

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

754: WHERE reservation_id = l_rsv_id_tbl(i);
755: EXCEPTION
756: WHEN OTHERS THEN
757: IF (l_debug = 1) THEN
758: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');
759: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');
760: END IF;
761: END;
762: END LOOP;

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

755: EXCEPTION
756: WHEN OTHERS THEN
757: IF (l_debug = 1) THEN
758: inv_log_util.TRACE('Error updating serial_reservation_quantity in mtl_reservations', 'INV_UNMARK_SERIAL');
759: inv_log_util.TRACE('sqlerrm is ' || SUBSTR(SQLERRM, 1, 200), 'INV_UNMARK_SERIAL');
760: END IF;
761: END;
762: END LOOP;
763: END IF;

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

776:
777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
778: BEGIN
779: IF (l_debug = 1) THEN
780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');

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

777: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
778: BEGIN
779: IF (l_debug = 1) THEN
780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');

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

778: BEGIN
779: IF (l_debug = 1) THEN
780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');

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

779: IF (l_debug = 1) THEN
780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
787: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');

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

780: inv_log_util.trace('Inside inv_update_marked_serial','SERIAL_CHECK');
781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
787: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
788: END IF;

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

781: inv_log_util.trace('from_serial_number='||from_serial_number,'SERIAL_CHECK');
782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
787: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
788: END IF;
789:

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

782: inv_log_util.trace('to_serial_number='||to_serial_number,'SERIAL_CHECK');
783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
787: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
788: END IF;
789:
790: success := TRUE;

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

783: inv_log_util.trace('item_id='||item_id,'SERIAL_CHECK');
784: inv_log_util.trace('org_id='||org_id,'SERIAL_CHECK');
785: inv_log_util.trace('temp_id='||temp_id,'SERIAL_CHECK');
786: inv_log_util.trace('hdr_id='||hdr_id,'SERIAL_CHECK');
787: inv_log_util.trace('lot_temp_id='||lot_temp_id,'SERIAL_CHECK');
788: END IF;
789:
790: success := TRUE;
791:

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

790: success := TRUE;
791:
792: IF (temp_id IS NULL AND hdr_id IS NULL) THEN
793: IF (l_debug = 1) THEN
794: inv_log_util.trace('temp_id, hdr_id are both null, return false','SERIAL_CHECK');
795: END IF;
796: success := FALSE;
797: RETURN;
798: END IF;

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

799:
800: IF (to_serial_number IS NULL OR (from_serial_number = to_serial_number)) THEN
801:
802: IF (l_debug = 1) THEN
803: inv_log_util.trace('to_serial_number is null or same as from_serial_number','SERIAL_CHECK');
804: END IF;
805:
806: BEGIN
807: UPDATE mtl_serial_numbers

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

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

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

824: success := TRUE;
825: ELSIF (to_serial_number IS NOT NULL AND NOT (from_serial_number = to_serial_number)) THEN
826:
827: IF (l_debug = 1) THEN
828: inv_log_util.trace('to_serial_number not null and different from from_serial_number','SERIAL_CHECK');
829: END IF;
830:
831: BEGIN
832: UPDATE mtl_serial_numbers

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

842: EXCEPTION
843: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
844: success := FALSE;
845: IF (l_debug = 1) THEN
846: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
847: END IF;
848: END;
849:
850: success := TRUE;

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

855: EXCEPTION
856: WHEN others THEN
857: success := FALSE;
858: IF ( l_debug = 1 ) THEN
859: inv_log_util.trace('sqlerrm is ' || substr(sqlerrm, 1, 200),'SERIAL_CHECK');
860: END IF;
861:
862: END inv_update_marked_serial;
863: