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.1 2012/01/04 16:26:21 shtadepa ship $ */
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 272: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',

268: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
269: --
270: BEGIN
271:
272: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
273: 'START',
274: 'Start of procedure INSERT_ROW, input parameters:
275: source_code='||p_source_code||
276: ', source_line_id='||p_source_line_id||

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

394:
395: FETCH row_id INTO x_rowid;
396:
397: IF (row_id%NOTFOUND) then
398: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
399: 'END',
400: 'No rowid found. Raising NO_DATA_FOUND.');
401: */
402: CLOSE row_id;

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

404: END IF;
405:
406: CLOSE row_id;
407:
408: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.INSERT_ROW',
409: 'END',
410: 'End of procedure INSERT_ROW');
411: */
412: --

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

461: --
462: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
463: --
464: BEGIN
465: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
466: 'START',
467: 'Start of procedure UPDATE_ROW, input parameters:
468: source_code='||p_source_code||
469: ', source_line_id='||p_source_line_id||

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

547: GRADE_CODE = p_grade_code
548: WHERE rowid = x_rowid;
549:
550: IF (SQL%NOTFOUND) THEN
551: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
552: 'END',
553: 'No rows updated. Raising NO_DATA_FOUND.');
554: */
555: RAISE NO_DATA_FOUND;

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

554: */
555: RAISE NO_DATA_FOUND;
556: END IF;
557:
558: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.UPDATE_ROW',
559: 'END',
560: 'End of procedure UPDATE_ROW');
561: */
562: --

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

589: --
590: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
591: --
592: BEGIN
593: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
594: 'START',
595: 'Start of procedure DELETE_ROW');
596:
597: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

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

593: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
594: 'START',
595: 'Start of procedure DELETE_ROW');
596:
597: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
598: 'START',
599: 'Deleting from mtl_serial_numbers_interface, if any');
600: */
601:

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

621: ( SELECT serial_transaction_temp_id
622: FROM mtl_transaction_lots_interface
623: WHERE rowid = x_rowid);
624:
625: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
626: 'END',
627: 'Finish with call to DELETE mtl_serial_numbers_interface');
628:
629: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',

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

625: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
626: 'END',
627: 'Finish with call to DELETE mtl_serial_numbers_interface');
628:
629: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
630: 'START',
631: 'Delete from mtl_transaction_lots_interface ');
632: */
633: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

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

632: */
633: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
634:
635: IF (SQL%NOTFOUND) THEN
636: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
637: 'END',
638: 'No rows deleted. Raising NO_DATA_FOUND');
639: */
640: RAISE NO_DATA_FOUND;

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

639: */
640: RAISE NO_DATA_FOUND;
641: END IF;
642:
643: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
644: 'END',
645: 'End of procedure DELETE_ROW');
646: */
647: --

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

695: --
696: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
697: --
698: BEGIN
699: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
700: 'START',
701: 'Start of procedure LOCK_ROW, input parameters:
702: source_code='||p_source_code||', source_line_id='||p_source_line_id||
703: ', transaction_interface_id='||p_trx_interface_id||

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

743:
744: FETCH lock_record into rec_info;
745:
746: IF (lock_record%NOTFOUND) THEN
747: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
748: 'END',
749: 'Lock record failed. Raising exception FORM_RECORD_DELETED');
750: */
751: CLOSE lock_record;

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

784: AND ((rec_info.secondary_transaction_quantity = p_secondary_trx_quantity)
785: OR ((rec_info.secondary_transaction_quantity IS NULL) AND (p_secondary_trx_quantity IS NULL)))
786:
787: ) THEN
788: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
789: 'END',
790: 'End of procedure LOCK_ROW');
791: */
792: --

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

797: END IF;
798: --
799: return;
800: ELSE
801: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.LOCK_ROW',
802: 'END',
803: 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
804: */
805: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

Line 818: END WSH_TRXLOTS_HANDLER;

814: END IF;
815: --
816: END Lock_Row;
817:
818: END WSH_TRXLOTS_HANDLER;