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.WSH_TRXLOTS_HANDLER dependencies on WSH_TRXLOTS_HANDLER

Line 1: PACKAGE BODY WSH_TRXLOTS_HANDLER AS

1: PACKAGE BODY WSH_TRXLOTS_HANDLER AS
2: /* $Header: WSHIIXLB.pls 120.0 2005/05/26 18:00:49 appldev noship $ */
3:
4: --
5: -- PACKAGE VARIABLES

Line 24: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRXLOTS_HANDLER';

20: --
21: -- ===========================================================================
22:
23: --
24: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRXLOTS_HANDLER';
25: --
26:
27: --HVOP heali
28: PROCEDURE INSERT_ROW_BULK (

Line 158: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',

154: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
155: --
156: BEGIN
157:
158: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
159: 'START',
160: 'Start of procedure INSERT_ROW, input parameters:
161: source_code='||p_source_code||
162: ', source_line_id='||p_source_line_id||

Line 284: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',

280:
281: FETCH row_id INTO x_rowid;
282:
283: IF (row_id%NOTFOUND) then
284: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
285: 'END',
286: 'No rowid found. Raising NO_DATA_FOUND.');
287: */
288: CLOSE row_id;

Line 294: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',

290: END IF;
291:
292: CLOSE row_id;
293:
294: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
295: 'END',
296: 'End of procedure INSERT_ROW');
297: */
298: --

Line 351: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',

347: --
348: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
349: --
350: BEGIN
351: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
352: 'START',
353: 'Start of procedure UPDATE_ROW, input parameters:
354: source_code='||p_source_code||
355: ', source_line_id='||p_source_line_id||

Line 437: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',

433: GRADE_CODE = p_grade_code
434: WHERE rowid = x_rowid;
435:
436: IF (SQL%NOTFOUND) THEN
437: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
438: 'END',
439: 'No rows updated. Raising NO_DATA_FOUND.');
440: */
441: RAISE NO_DATA_FOUND;

Line 444: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',

440: */
441: RAISE NO_DATA_FOUND;
442: END IF;
443:
444: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
445: 'END',
446: 'End of procedure UPDATE_ROW');
447: */
448: --

Line 479: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

475: --
476: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
477: --
478: BEGIN
479: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
480: 'START',
481: 'Start of procedure DELETE_ROW');
482:
483: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

Line 483: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

479: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
480: 'START',
481: 'Start of procedure DELETE_ROW');
482:
483: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
484: 'START',
485: 'Deleting from mtl_serial_numbers_interface, if any');
486: */
487:

Line 511: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

507: ( SELECT serial_transaction_temp_id
508: FROM mtl_transaction_lots_interface
509: WHERE rowid = x_rowid);
510:
511: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
512: 'END',
513: 'Finish with call to DELETE mtl_serial_numbers_interface');
514:
515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

Line 515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

511: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
512: 'END',
513: 'Finish with call to DELETE mtl_serial_numbers_interface');
514:
515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
516: 'START',
517: 'Delete from mtl_transaction_lots_interface ');
518: */
519: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

Line 522: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

518: */
519: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
520:
521: IF (SQL%NOTFOUND) THEN
522: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
523: 'END',
524: 'No rows deleted. Raising NO_DATA_FOUND');
525: */
526: RAISE NO_DATA_FOUND;

Line 529: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

525: */
526: RAISE NO_DATA_FOUND;
527: END IF;
528:
529: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
530: 'END',
531: 'End of procedure DELETE_ROW');
532: */
533: --

Line 585: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',

581: --
582: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
583: --
584: BEGIN
585: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
586: 'START',
587: 'Start of procedure LOCK_ROW, input parameters:
588: source_code='||p_source_code||', source_line_id='||p_source_line_id||
589: ', transaction_interface_id='||p_trx_interface_id||

Line 633: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',

629:
630: FETCH lock_record into rec_info;
631:
632: IF (lock_record%NOTFOUND) THEN
633: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
634: 'END',
635: 'Lock record failed. Raising exception FORM_RECORD_DELETED');
636: */
637: CLOSE lock_record;

Line 674: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',

670: AND ((rec_info.secondary_transaction_quantity = p_secondary_trx_quantity)
671: OR ((rec_info.secondary_transaction_quantity IS NULL) AND (p_secondary_trx_quantity IS NULL)))
672:
673: ) THEN
674: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
675: 'END',
676: 'End of procedure LOCK_ROW');
677: */
678: --

Line 687: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',

683: END IF;
684: --
685: return;
686: ELSE
687: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
688: 'END',
689: 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
690: */
691: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

Line 704: END WSH_TRXLOTS_HANDLER;

700: END IF;
701: --
702: END Lock_Row;
703:
704: END WSH_TRXLOTS_HANDLER;