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_TEST dependencies on WSH_TRXLOTS_HANDLER_TEST

Line 1: PACKAGE BODY WSH_TRXLOTS_HANDLER_TEST AS

1: PACKAGE BODY WSH_TRXLOTS_HANDLER_TEST AS
2: /* $Header: WSHTESTB.pls 115.3 2003/12/01 18:48:00 heali noship $ */
3:
4: --
5: -- PACKAGE VARIABLES

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

20: --
21: -- ===========================================================================
22:
23: --
24: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRXLOTS_HANDLER_TEST';
25: --
26: PROCEDURE Insert_Row(
27: x_rowid IN OUT NOCOPY VARCHAR2,
28: x_trx_interface_id IN OUT NOCOPY NUMBER,

Line 65: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',

61: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';
62: --
63: BEGIN
64:
65: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
66: 'START',
67: 'Start of procedure INSERT_ROW, input parameters:
68: source_code='||p_source_code||
69: ', source_line_id='||p_source_line_id||

Line 181: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',

177:
178: FETCH row_id INTO x_rowid;
179:
180: IF (row_id%NOTFOUND) then
181: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
182: 'END',
183: 'No rowid found. Raising NO_DATA_FOUND.');
184: */
185: CLOSE row_id;

Line 191: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',

187: END IF;
188:
189: CLOSE row_id;
190:
191: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.INSERT_ROW',
192: 'END',
193: 'End of procedure INSERT_ROW');
194: */
195: --

Line 243: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',

239: --
240: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';
241: --
242: BEGIN
243: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
244: 'START',
245: 'Start of procedure UPDATE_ROW, input parameters:
246: source_code='||p_source_code||
247: ', source_line_id='||p_source_line_id||

Line 323: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',

319: process_flag = p_process_flag
320: WHERE rowid = x_rowid;
321:
322: IF (SQL%NOTFOUND) THEN
323: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
324: 'END',
325: 'No rows updated. Raising NO_DATA_FOUND.');
326: */
327: RAISE NO_DATA_FOUND;

Line 330: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',

326: */
327: RAISE NO_DATA_FOUND;
328: END IF;
329:
330: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.UPDATE_ROW',
331: 'END',
332: 'End of procedure UPDATE_ROW');
333: */
334: --

Line 365: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

361: --
362: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';
363: --
364: BEGIN
365: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
366: 'START',
367: 'Start of procedure DELETE_ROW');
368:
369: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

Line 369: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

365: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
366: 'START',
367: 'Start of procedure DELETE_ROW');
368:
369: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
370: 'START',
371: 'Deleting from mtl_serial_numbers_interface, if any');
372: */
373:

Line 397: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

393: ( SELECT serial_transaction_temp_id
394: FROM mtl_transaction_lots_interface
395: WHERE rowid = x_rowid);
396:
397: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
398: 'END',
399: 'Finish with call to DELETE mtl_serial_numbers_interface');
400:
401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

Line 401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

397: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
398: 'END',
399: 'Finish with call to DELETE mtl_serial_numbers_interface');
400:
401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
402: 'START',
403: 'Delete from mtl_transaction_lots_interface ');
404: */
405: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;

Line 408: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

404: */
405: DELETE FROM mtl_transaction_lots_interface WHERE rowid = x_rowid;
406:
407: IF (SQL%NOTFOUND) THEN
408: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
409: 'END',
410: 'No rows deleted. Raising NO_DATA_FOUND');
411: */
412: RAISE NO_DATA_FOUND;

Line 415: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',

411: */
412: RAISE NO_DATA_FOUND;
413: END IF;
414:
415: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
416: 'END',
417: 'End of procedure DELETE_ROW');
418: */
419: --

Line 467: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',

463: --
464: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'LOCK_ROW';
465: --
466: BEGIN
467: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',
468: 'START',
469: 'Start of procedure LOCK_ROW, input parameters:
470: source_code='||p_source_code||', source_line_id='||p_source_line_id||
471: ', transaction_interface_id='||p_trx_interface_id||

Line 512: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',

508:
509: FETCH lock_record into rec_info;
510:
511: IF (lock_record%NOTFOUND) THEN
512: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',
513: 'END',
514: 'Lock record failed. Raising exception FORM_RECORD_DELETED');
515: */
516: CLOSE lock_record;

Line 547: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',

543: OR ((rec_info.error_code IS NULL) AND (p_error_code IS NULL)))
544: AND ((rec_info.process_flag = p_process_flag)
545: OR ((rec_info.process_flag IS NULL) AND (p_process_flag IS NULL)))
546: ) THEN
547: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',
548: 'END',
549: 'End of procedure LOCK_ROW');
550: */
551: --

Line 560: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',

556: END IF;
557: --
558: return;
559: ELSE
560: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.LOCK_ROW',
561: 'END',
562: 'Lock record failed. Raising exception FORM_RECORD_CHANGED');
563: */
564: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

Line 577: END WSH_TRXLOTS_HANDLER_TEST;

573: END IF;
574: --
575: END Lock_Row;
576:
577: END WSH_TRXLOTS_HANDLER_TEST;