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_TRXSN_HANDLER dependencies on WSH_TRXSN_HANDLER

Line 1: PACKAGE BODY WSH_TRXSN_HANDLER AS

1: PACKAGE BODY WSH_TRXSN_HANDLER AS
2: /* $Header: WSHIISNB.pls 120.1 2010/07/05 13:16:20 sunilku ship $ */
3:
4: --
5: -- PACKAGE VARIABLES

Line 10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRXSN_HANDLER';

6: --
7:
8: g_userid NUMBER;
9: --
10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRXSN_HANDLER';
11: --
12:
13: --HVOP heali
14: PROCEDURE INSERT_ROW_BULK (

Line 292: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',

288: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
289: --
290: BEGIN
291:
292: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',
293: 'START',
294: 'Start of procedure INSERT_ROW, input parameters:
295: source_code='||p_source_code||
296: ',source_line_id='||to_char(p_source_line_id)||

Line 353: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',

349: WSH_DEBUG_SV.log(l_module_name,'P_PROCESS_FLAG',P_PROCESS_FLAG);
350: END IF;
351: --
352: IF (p_fm_serial_number IS NULL) THEN
353: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',
354: 'END',
355: 'Insert failed. From serial number is NULL.
356: Raising WSH_FM_SERIALNO_NULL');
357: */

Line 425: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',

421:
422: FETCH row_id INTO x_rowid;
423:
424: IF (row_id%NOTFOUND) then
425: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',
426: 'END',
427: 'No rowid found. Raising NO_DATA_FOUND.');
428: */
429: CLOSE row_id;

Line 438: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',

434: END IF;
435:
436: CLOSE row_id;
437:
438: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.INSERT_ROW',
439: 'END',
440: 'End of procedure INSERT_ROW');
441: */
442:

Line 489: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',

485: --
486: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
487: --
488: BEGIN
489: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',
490: 'START',
491: 'Start of procedure UPDATE_ROW, input parameters:
492: source_code='||p_source_code||
493: ', source_line_id='||p_source_line_id||

Line 544: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',

540: WSH_DEBUG_SV.log(l_module_name,'P_PROCESS_FLAG',P_PROCESS_FLAG);
541: END IF;
542: --
543: IF (p_fm_serial_number IS NULL) THEN
544: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',
545: 'END',
546: 'UPDATE failed. From serial number is NULL.
547: Raising WSH_FM_SERIALNO_NULL');
548: */

Line 582: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',

578: WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);
579: END IF;
580:
581: IF (SQL%NOTFOUND) THEN
582: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',
583: 'END',
584: 'No rows updated. Raising NO_DATA_FOUND.');
585: */
586: IF l_debug_on THEN

Line 592: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',

588: END IF;
589: RAISE NO_DATA_FOUND;
590: END IF;
591:
592: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.UPDATE_ROW',
593: 'END',
594: 'End of procedure UPDATE_ROW');
595: */
596: --

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

621: --
622: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
623: --
624: BEGIN
625: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.DELETE_ROW',
626: 'START',
627: 'Start of procedure DELETE_ROW');
628: */
629: --

Line 650: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.DELETE_ROW',

646: IF l_debug_on THEN
647: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
648: END IF;
649: IF (SQL%NOTFOUND) THEN
650: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.DELETE_ROW',
651: 'END',
652: 'No rows deleted. Raising NO_DATA_FOUND');
653: */
654: IF l_debug_on THEN

Line 660: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.DELETE_ROW',

656: END IF;
657: RAISE NO_DATA_FOUND;
658: END IF;
659:
660: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.DELETE_ROW',
661: 'END',
662: 'End of procedure DELETE_ROW');
663: */
664: --

Line 710: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',

706: --
707: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
708: --
709: BEGIN
710: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',
711: 'START',
712: 'Start of procedure LOCK_ROW, input parameters:
713: source_code='||p_source_code||
714: ', source_line_id='||p_source_line_id||

Line 753: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',

749:
750: FETCH lock_record into rec_info;
751:
752: IF (lock_record%NOTFOUND) THEN
753: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',
754: 'END',
755: 'Lock record failed. Raising exception FORM_RECORD_DELETED');
756: */
757: CLOSE lock_record;

Line 795: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',

791: AND ((rec_info.parent_serial_number = p_parent_serial_number)
792: OR ((rec_info.parent_serial_number IS NULL)
793: AND (p_parent_serial_number IS NULL)))
794: ) THEN
795: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',
796: 'END',
797: 'End of procedure LOCK_ROW');
798: */
799: --

Line 806: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',

802: END IF;
803: --
804: return;
805: ELSE
806: /* wsh_server_debug.log_event('WSH_TRXSN_HANDLER.LOCK_ROW',
807: 'END',
808: 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
809: */
810: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

Line 823: END WSH_TRXSN_HANDLER;

819: END IF;
820: --
821: END Lock_Row;
822:
823: END WSH_TRXSN_HANDLER;