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

Line 1: PACKAGE BODY gme_debug AS

1: PACKAGE BODY gme_debug AS
2: /* $Header: GMEUDBGB.pls 120.4 2005/10/05 14:39:46 snene noship $ */
3: g_debug VARCHAR2 (5)
4: := NVL (fnd_profile.VALUE ('AFLOG_LEVEL')
5: ,-1);

Line 6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_DEBUG';

2: /* $Header: GMEUDBGB.pls 120.4 2005/10/05 14:39:46 snene noship $ */
3: g_debug VARCHAR2 (5)
4: := NVL (fnd_profile.VALUE ('AFLOG_LEVEL')
5: ,-1);
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_DEBUG';
7:
8: /*
9: REM *********************************************************************
10: REM *

Line 12: REM * PURPOSE: Package Body for the GME debug utilities

8: /*
9: REM *********************************************************************
10: REM *
11: REM * FILE: GMEUDBGB.pls
12: REM * PURPOSE: Package Body for the GME debug utilities
13: REM * AUTHOR: Olivier DABOVAL, OPM Development
14: REM * DATE: 27th MAY 2001
15: REM *
16: REM * PROCEDURE log_initialize

Line 100: fnd_msg_pub.add_exc_msg ('GME_DEBUG', 'LOG_INITIALIZE');

96: g_file_name := p_file_name;
97: END IF;
98: EXCEPTION
99: WHEN OTHERS THEN
100: fnd_msg_pub.add_exc_msg ('GME_DEBUG', 'LOG_INITIALIZE');
101:
102: IF g_debug IS NOT NULL THEN
103: gme_debug.put_line ('Error in ' || SQLERRM);
104: END IF;

Line 103: gme_debug.put_line ('Error in ' || SQLERRM);

99: WHEN OTHERS THEN
100: fnd_msg_pub.add_exc_msg ('GME_DEBUG', 'LOG_INITIALIZE');
101:
102: IF g_debug IS NOT NULL THEN
103: gme_debug.put_line ('Error in ' || SQLERRM);
104: END IF;
105: END log_initialize;
106:
107: --========================================================================

Line 178: gme_debug.put_line ('Message ' || TO_CHAR (i) || ' ' || MESSAGE);

174: fnd_msg_pub.get (p_msg_index => i
175: ,p_data => MESSAGE
176: ,p_encoded => 'F'
177: ,p_msg_index_out => dummy);
178: gme_debug.put_line ('Message ' || TO_CHAR (i) || ' ' || MESSAGE);
179: END LOOP;
180: --Bug2804440
181: EXCEPTION
182: WHEN OTHERS THEN

Line 216: gme_debug.put_line ('Resource transactions temp table');

212: AND (line_id = v_line_id OR v_line_id IS NULL)
213: AND delete_mark = v_delete_mark
214: ORDER BY doc_id, line_id, resources, poc_trans_id;
215: BEGIN
216: gme_debug.put_line ('Resource transactions temp table');
217: gme_debug.put_line
218: ('organization_id/line_id/trans_id/trans_date/resources/resource_usage/trans_um/overrided_protected_ind/completed_ind/action_code/reason_id');
219:
220: IF p_batchstep_id IS NOT NULL THEN

Line 217: gme_debug.put_line

213: AND delete_mark = v_delete_mark
214: ORDER BY doc_id, line_id, resources, poc_trans_id;
215: BEGIN
216: gme_debug.put_line ('Resource transactions temp table');
217: gme_debug.put_line
218: ('organization_id/line_id/trans_id/trans_date/resources/resource_usage/trans_um/overrided_protected_ind/completed_ind/action_code/reason_id');
219:
220: IF p_batchstep_id IS NOT NULL THEN
221: OPEN get_batchstep_resource_id (p_batchstep_id);

Line 243: gme_debug.put_line (rec.organization_id ||'/'

239: WHILE i <= l_resources LOOP
240: FOR rec IN get_temp_table (p_batch_id
241: ,l_resource_ids (i)
242: ,p_delete_mark) LOOP
243: gme_debug.put_line (rec.organization_id ||'/'
244: || rec.line_id
245: || '/'
246: || rec.poc_trans_id
247: || '/'

Line 295: gme_debug.put_line ('Exceptions temp table');

291: AND ( material_detail_id = v_material_detail_id
292: OR v_material_detail_id IS NULL)
293: ORDER BY batch_id, material_detail_id;
294: BEGIN
295: gme_debug.put_line ('Exceptions temp table');
296: gme_debug.put_line
297: ('batch_id/material_detail_id/Pend MO/Pend Rsv/onhand/ATT/ATR/TRANSACTED/EXCEPTION');
298:
299: FOR rec IN get_temp_table (p_organization_id

Line 296: gme_debug.put_line

292: OR v_material_detail_id IS NULL)
293: ORDER BY batch_id, material_detail_id;
294: BEGIN
295: gme_debug.put_line ('Exceptions temp table');
296: gme_debug.put_line
297: ('batch_id/material_detail_id/Pend MO/Pend Rsv/onhand/ATT/ATR/TRANSACTED/EXCEPTION');
298:
299: FOR rec IN get_temp_table (p_organization_id
300: ,p_batch_id

Line 302: gme_debug.put_line ( rec.batch_id

298:
299: FOR rec IN get_temp_table (p_organization_id
300: ,p_batch_id
301: ,p_material_detail_id) LOOP
302: gme_debug.put_line ( rec.batch_id
303: || '/'
304: || rec.material_detail_id
305: || '/'
306: || rec.pending_move_order_ind

Line 347: gme_debug.put_line('* Txns created automatically by release/complete/IB etc. *');

343: ###############################################################*/
344: PROCEDURE dump_temp_txns_exceptions IS
345: BEGIN
346: IF (g_debug IS NOT NULL) THEN
347: gme_debug.put_line('***** Txns created automatically by release/complete/IB etc. *****');
348: FOR get_rec IN (SELECT * FROM mtl_material_transactions_temp WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id) LOOP
349: gme_debug.put_line('Batch_id = '||get_rec.transaction_source_id||' material_detail_id = '||get_rec.trx_source_line_id||
350: ' inventory_item_id = '||get_rec.inventory_item_id||' revision = '||get_rec.revision||
351: ' subinventory = '||get_rec.subinventory_code||' locator_id = '||get_rec.locator_id||

Line 349: gme_debug.put_line('Batch_id = '||get_rec.transaction_source_id||' material_detail_id = '||get_rec.trx_source_line_id||

345: BEGIN
346: IF (g_debug IS NOT NULL) THEN
347: gme_debug.put_line('***** Txns created automatically by release/complete/IB etc. *****');
348: FOR get_rec IN (SELECT * FROM mtl_material_transactions_temp WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id) LOOP
349: gme_debug.put_line('Batch_id = '||get_rec.transaction_source_id||' material_detail_id = '||get_rec.trx_source_line_id||
350: ' inventory_item_id = '||get_rec.inventory_item_id||' revision = '||get_rec.revision||
351: ' subinventory = '||get_rec.subinventory_code||' locator_id = '||get_rec.locator_id||
352: ' transaction_quantity = '||get_rec.transaction_quantity||' transaction_uom = '||get_rec.transaction_uom||
353: ' sec_transaction_qty = '||get_rec.secondary_transaction_quantity);

Line 355: gme_debug.put_line('* End Txns created automatically by release/complete/IB etc. * ');

351: ' subinventory = '||get_rec.subinventory_code||' locator_id = '||get_rec.locator_id||
352: ' transaction_quantity = '||get_rec.transaction_quantity||' transaction_uom = '||get_rec.transaction_uom||
353: ' sec_transaction_qty = '||get_rec.secondary_transaction_quantity);
354: END LOOP;
355: gme_debug.put_line('***** End Txns created automatically by release/complete/IB etc. ***** ');
356: gme_debug.put_line('***** Exceptions created by release/complete/IB etc. *****');
357: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
359: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||

Line 356: gme_debug.put_line('* Exceptions created by release/complete/IB etc. *');

352: ' transaction_quantity = '||get_rec.transaction_quantity||' transaction_uom = '||get_rec.transaction_uom||
353: ' sec_transaction_qty = '||get_rec.secondary_transaction_quantity);
354: END LOOP;
355: gme_debug.put_line('***** End Txns created automatically by release/complete/IB etc. ***** ');
356: gme_debug.put_line('***** Exceptions created by release/complete/IB etc. *****');
357: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
359: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
360: ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);

Line 358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||

354: END LOOP;
355: gme_debug.put_line('***** End Txns created automatically by release/complete/IB etc. ***** ');
356: gme_debug.put_line('***** Exceptions created by release/complete/IB etc. *****');
357: FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
359: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
360: ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);
361: END LOOP;
362: gme_debug.put_line('***** End Exceptions created by release/complete/IB etc. *****');

Line 362: gme_debug.put_line('* End Exceptions created by release/complete/IB etc. *');

358: gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
359: ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
360: ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);
361: END LOOP;
362: gme_debug.put_line('***** End Exceptions created by release/complete/IB etc. *****');
363: END IF;
364: END dump_temp_txns_exceptions;
365:
366: END gme_debug;

Line 366: END gme_debug;

362: gme_debug.put_line('***** End Exceptions created by release/complete/IB etc. *****');
363: END IF;
364: END dump_temp_txns_exceptions;
365:
366: END gme_debug;