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.WMS_DEVHIST_HANDLER_PKG dependencies on INV_LOG_UTIL

Line 59: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);

55:
56: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
57: BEGIN
58: IF (l_debug = 1) THEN
59: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
60: END IF;
61: insert into WMS_DEVICE_REQUESTS_HIST (
62: REQUEST_ID ,
63: TASK_ID ,

Line 244: inv_log_util.trace('inside LOCK ROW c%notfound','WMS_DEVHIST_HANDLER_PKG',9);

240: fetch c into recinfo;
241: if (c%notfound) then
242: close c;
243: IF (l_debug = 1) THEN
244: inv_log_util.trace('inside LOCK ROW c%notfound','WMS_DEVHIST_HANDLER_PKG',9);
245: END IF;
246: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
247: app_exception.raise_exception;
248: end if;

Line 251: inv_log_util.trace('inside LOCK ROW','WMS_DEVHIST_HANDLER_PKG',9);

247: app_exception.raise_exception;
248: end if;
249: close c;
250: IF (l_debug = 1) THEN
251: inv_log_util.trace('inside LOCK ROW','WMS_DEVHIST_HANDLER_PKG',9);
252: END IF;
253: if ( (recinfo.request_id = x_request_id)
254: AND (recinfo.task_id = X_task_id)
255: AND (recinfo.business_event_id = X_business_event_id)

Line 321: inv_log_util.trace('inside LOCK ROW WILL SHOW CHNAGED MESG','WMS_DEVHIST_HANDLER_PKG',9);

317: ) then
318: return;
319: ELSE
320: IF (l_debug = 1) THEN
321: inv_log_util.trace('inside LOCK ROW WILL SHOW CHNAGED MESG','WMS_DEVHIST_HANDLER_PKG',9);
322: END IF;
323: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
324: app_exception.raise_exception;
325: end if;

Line 379: inv_log_util.trace('inside updating for HIST form','WMS_DEVHIST_HANDLER_PKG',9);

375: BEGIN
376:
377: /*
378: IF (l_debug = 1) THEN
379: inv_log_util.trace('inside updating for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
380: END IF;
381:
382: */
383:

Line 444: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);

440: begin
441:
442: /*
443: IF (l_debug = 1) THEN
444: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
445: END IF;
446: */
447:
448: delete from wms_device_requests_hist

Line 519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);

515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
516: BEGIN
517: /*
518: IF (l_debug = 1) THEN
519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);
520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);
521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);
522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);
523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);

Line 520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);

516: BEGIN
517: /*
518: IF (l_debug = 1) THEN
519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);
520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);
521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);
522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);
523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);
524: END IF;

Line 521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);

517: /*
518: IF (l_debug = 1) THEN
519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);
520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);
521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);
522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);
523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);
524: END IF;
525: */

Line 522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);

518: IF (l_debug = 1) THEN
519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);
520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);
521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);
522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);
523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);
524: END IF;
525: */
526: OPEN C_child_records;

Line 523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);

519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);
520: inv_log_util.trace(' '||X_TASK_ID,'WMS_DEVHIST_HANDLER_PKG',9);
521: inv_log_util.trace(' ' ||x_RELATION_ID,'WMS_DEVHIST_HANDLER_PKG',9);
522: inv_log_util.trace(''||X_SEQUENCE_ID,'WMS_DEVHIST_HANDLER_PKG',9);
523: inv_log_util.trace(' '||X_business_event_id,'WMS_DEVHIST_HANDLER_PKG',9);
524: END IF;
525: */
526: OPEN C_child_records;
527: FETCH C_child_records INTO recinfo_child_records;

Line 531: inv_log_util.trace('Return:No chldRec to update','WMS_DEVHIST_HANDLER_PKG',9);

527: FETCH C_child_records INTO recinfo_child_records;
528: IF (C_child_records%notfound) THEN
529: CLOSE C_child_records;
530: IF (l_debug = 1) THEN
531: inv_log_util.trace('Return:No chldRec to update','WMS_DEVHIST_HANDLER_PKG',9);
532: END IF;
533: --fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
534: RETURN;
535: ELSE

Line 537: inv_log_util.trace('updating the child rec','WMS_DEVHIST_HANDLER_PKG',9);

533: --fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
534: RETURN;
535: ELSE
536: IF (l_debug = 1) THEN
537: inv_log_util.trace('updating the child rec','WMS_DEVHIST_HANDLER_PKG',9);
538: END IF;
539: update wms_device_requests_hist set
540: task_type_id = X_task_type_id,
541: organization_id = X_organization_id,

Line 584: inv_log_util.trace('inside exception'||SQLCODE,'WMS_DEVHIST_HANDLER_PKG',9);

580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF (l_debug = 1) THEN
584: inv_log_util.trace('inside exception'||SQLCODE,'WMS_DEVHIST_HANDLER_PKG',9);
585: END IF;
586: IF SQLCODE = -54 THEN --record locked by other session
587: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
588: app_exception.raise_exception;

Line 606: inv_log_util.trace('Inside delete_CHILD_RECORDS','WMS_DEVHIST_HANDLER_PKG',9);

602: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
603: BEGIN
604: /*
605: IF (l_debug = 1) THEN
606: inv_log_util.trace('Inside delete_CHILD_RECORDS','WMS_DEVHIST_HANDLER_PKG',9);
607: END IF;
608: */
609: delete from wms_device_requests_hist
610: WHERE REQUEST_ID = X_REQUEST_ID

Line 651: inv_log_util.trace('Inside lock_CHILD_RECORDS:::'||x_is_new_row,'WMS_DEVHIST_HANDLER_PKG',9);

647: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
648: BEGIN
649: /*
650: IF (l_debug = 1) THEN
651: inv_log_util.trace('Inside lock_CHILD_RECORDS:::'||x_is_new_row,'WMS_DEVHIST_HANDLER_PKG',9);
652: END IF;
653: */
654:
655: open c;