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_TRX_HANDLER dependencies on WSH_TRX_HANDLER

Line 1: PACKAGE BODY WSH_TRX_HANDLER AS

1: PACKAGE BODY WSH_TRX_HANDLER AS
2: /* $Header: WSHIIXIB.pls 120.0.12010000.2 2009/04/27 13:50:00 selsubra ship $ */
3: --
4: -- PACKAGE VARIABLES
5: --

Line 22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRX_HANDLER';

18: -- MTL_TRANSACTIONS_INTERFACE table.
19: --
20: -- ===========================================================================
21: --
22: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRX_HANDLER';
23: --
24:
25: --HVOP heali
26: PROCEDURE INSERT_ROW_BULK (

Line 482: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',

478: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
479: --
480: BEGIN
481:
482: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
483: 'START',
484: 'Start of procedure INSERT_ROW, input parameters:
485: source_code='||p_source_code||
486: ', source_line_id='||p_source_line_id||

Line 1607: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',

1603:
1604: FETCH row_id INTO x_rowid;
1605:
1606: IF (row_id%NOTFOUND) then
1607: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1608: 'END',
1609: 'No rowid found. Raising NO_DATA_FOUND.');
1610: */
1611: CLOSE row_id;

Line 1620: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',

1616: END IF;
1617:
1618: CLOSE row_id;
1619:
1620: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1621: 'END',
1622: 'End of procedure INSERT_ROW');
1623: */
1624: --

Line 1918: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',

1914: --
1915: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
1916: --
1917: BEGIN
1918: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.INSERT_ROW',
1919: 'START',
1920: 'Start of procedure INSERT_ROW, input parameters:
1921: source_code='||p_source_code||
1922: ', source_line_id='||p_source_line_id||

Line 2755: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',

2751: IF l_debug_on THEN
2752: WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);
2753: END IF;
2754: IF (SQL%NOTFOUND) THEN
2755: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',
2756: 'END',
2757: 'No rows updated. Raising NO_DATA_FOUND.');
2758: */
2759: IF l_debug_on THEN

Line 2765: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',

2761: END IF;
2762: RAISE NO_DATA_FOUND;
2763: END IF;
2764:
2765: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.UPDATE_ROW',
2766: 'END',
2767: 'End of procedure UPDATE_ROW');
2768: */
2769: --

Line 2800: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2796: --
2797: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
2798: --
2799: BEGIN
2800: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2801: 'START',
2802: 'Start of procedure DELETE_ROW');
2803: */
2804:

Line 2806: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2802: 'Start of procedure DELETE_ROW');
2803: */
2804:
2805: -- get the column which may map to another table
2806: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2807: 'START',
2808: 'Select transaction_interface_id INTO l_trx_interface_id
2809: FROM mtl_transactions_interface');
2810: */

Line 2830: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2826: SELECT transaction_interface_id INTO l_trx_interface_id
2827: FROM mtl_transactions_interface
2828: WHERE rowid = x_rowid;
2829:
2830: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2831: 'END',
2832: 'Finish selecting transaction_header_id');
2833: */
2834: IF l_debug_on THEN

Line 2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2839: IF (l_trx_interface_id is NOT NULL) THEN
2840:
2841: -- delete from mtl_serial_numbers_interface if there are mappings
2842: -- of mtl_transaction_lots_interface to the two other tables
2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844: 'START',
2845: 'Delete mtl_serial_numbers_interface,
2846: if it is one of two child tables');
2847: wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

Line 2847: wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844: 'START',
2845: 'Delete mtl_serial_numbers_interface,
2846: if it is one of two child tables');
2847: wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2848: 'START',
2849: 'interface_id ' || l_trx_interface_id);
2850: */
2851: DELETE FROM mtl_serial_numbers_interface

Line 2857: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2853: ( SELECT serial_transaction_temp_id
2854: FROM mtl_transaction_lots_interface
2855: WHERE transaction_interface_id = l_trx_interface_id );
2856:
2857: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2858: 'END',
2859: 'Finish delete mtl_serial_numbers_interface, if any');
2860: */
2861: -- delete from mtl_transaction_lots_interface, if there is mapping

Line 2862: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2858: 'END',
2859: 'Finish delete mtl_serial_numbers_interface, if any');
2860: */
2861: -- delete from mtl_transaction_lots_interface, if there is mapping
2862: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2863: 'START',
2864: 'Delete mtl_transaction_lots_interface, if there is mapping');
2865: */
2866: IF l_debug_on THEN

Line 2877: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2873: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2874: END IF;
2875: IF (SQL%NOTFOUND) THEN
2876: -- there is no mapping to mtl_transaction_lots_interface
2877: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2878: 'START',
2879: 'Delete mtl_serial_numbers_interface -- only child');
2880: */
2881:

Line 2888: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2884: IF l_debug_on THEN
2885: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2886: END IF;
2887:
2888: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2889: 'END',
2890: 'Finish delete mtl_serial_numbers_interface');
2891: */
2892: END IF;

Line 2895: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2891: */
2892: END IF;
2893: END IF;
2894:
2895: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2896: 'START',
2897: 'Delete mtl_transactions_interface');
2898: */
2899: DELETE FROM mtl_transactions_interface WHERE rowid = x_rowid;

Line 2905: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2901: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2902: END IF;
2903:
2904: IF (SQL%NOTFOUND) THEN
2905: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2906: 'END',
2907: 'No rows deleted from mtl_transactions_interface.
2908: Raising NO_DATA_FOUND');
2909: */

Line 2916: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',

2912: END IF;
2913: RAISE NO_DATA_FOUND;
2914: END IF;
2915:
2916: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2917: 'END',
2918: 'End of procedure DELETE_ROW');
2919: */
2920: --

Line 3223: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',

3219: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
3220: --
3221: BEGIN
3222:
3223: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
3224: 'START',
3225: 'Start of procedure LOCK_ROW, input parameters:
3226: transaction_interface_id='||p_trx_interface_id||
3227: ',transaction_header_id='||p_trx_header_id||

Line 3756: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',

3752:
3753: FETCH lock_record into rec_info;
3754:
3755: IF (lock_record%NOTFOUND) THEN
3756: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
3757: 'END',
3758: 'Lock record failed. Raising exception FORM_RECORD_DELETED');
3759: */
3760: CLOSE lock_record;

Line 4381: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',

4377: OR ((rec_info.SECONDARY_UOM_CODE IS NULL) AND (p_secondary_uom_code IS NULL)))
4378: AND ((rec_info.SECONDARY_TRANSACTION_QUANTITY = p_secondary_trx_quantity)
4379: OR ((rec_info.SECONDARY_TRANSACTION_QUANTITY IS NULL) AND (p_secondary_trx_quantity IS NULL)))
4380: ) THEN
4381: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
4382: 'END',
4383: 'End of procedure LOCK_ROW');
4384: */
4385: --

Line 4392: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',

4388: END IF;
4389: --
4390: return;
4391: ELSE
4392: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.LOCK_ROW',
4393: 'END',
4394: 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
4395: */
4396: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

Line 4410: END WSH_TRX_HANDLER;

4406: END IF;
4407: --
4408: END Lock_Row;
4409:
4410: END WSH_TRX_HANDLER;