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

Line 140: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

136: IF ( (p_batch_row.batch_id IS NULL)
137: OR (p_batch_row.batch_id = fnd_api.g_miss_num) ) THEN
138: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
139:
140: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
141: gme_debug.put_line ( g_pkg_name
142: || '.'
143: || l_api_name
144: || ':'

Line 141: gme_debug.put_line ( g_pkg_name

137: OR (p_batch_row.batch_id = fnd_api.g_miss_num) ) THEN
138: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
139:
140: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
141: gme_debug.put_line ( g_pkg_name
142: || '.'
143: || l_api_name
144: || ':'
145: || 'BATCH ID NEEDED FOR RETRIEVAL');

Line 149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

145: || 'BATCH ID NEEDED FOR RETRIEVAL');
146: END IF;
147: END IF;
148:
149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
150: gme_debug.put_line ( g_pkg_name
151: || '.'
152: || l_api_name
153: || ':'

Line 150: gme_debug.put_line ( g_pkg_name

146: END IF;
147: END IF;
148:
149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
150: gme_debug.put_line ( g_pkg_name
151: || '.'
152: || l_api_name
153: || ':'
154: || 'Update Inventory Ind:'

Line 162: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

158: END IF;
159:
160: -- Check that the UPDATE_INVENTORY_IND Value
161: IF (p_batch_row.update_inventory_ind <> 'Y') THEN
162: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
163: gme_debug.put_line ( g_pkg_name
164: || '.'
165: || l_api_name
166: || ':'

Line 163: gme_debug.put_line ( g_pkg_name

159:
160: -- Check that the UPDATE_INVENTORY_IND Value
161: IF (p_batch_row.update_inventory_ind <> 'Y') THEN
162: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
163: gme_debug.put_line ( g_pkg_name
164: || '.'
165: || l_api_name
166: || ':'
167: || 'No Transactions will be loaded');

Line 176: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

172: ,p_batch_row.batch_no);
173: RAISE fnd_api.g_exc_error;
174: END IF;
175:
176: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
177: gme_debug.put_line ( g_pkg_name
178: || '.'
179: || l_api_name
180: || ':'

Line 177: gme_debug.put_line ( g_pkg_name

173: RAISE fnd_api.g_exc_error;
174: END IF;
175:
176: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
177: gme_debug.put_line ( g_pkg_name
178: || '.'
179: || l_api_name
180: || ':'
181: || 'Batch Type = > '

Line 192: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

188: l_doc_type := 'PROD';
189: ELSIF (p_batch_row.batch_type = 10) THEN
190: l_doc_type := 'FPO';
191: ELSE
192: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
193: gme_debug.put_line ( g_pkg_name
194: || '.'
195: || l_api_name
196: || ':'

Line 193: gme_debug.put_line ( g_pkg_name

189: ELSIF (p_batch_row.batch_type = 10) THEN
190: l_doc_type := 'FPO';
191: ELSE
192: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
193: gme_debug.put_line ( g_pkg_name
194: || '.'
195: || l_api_name
196: || ':'
197: || 'No BATCH TYPE loaded');

Line 336: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

332: INTO l_current_txn;
333:
334: EXIT WHEN c_get_cmplt_zero_def_txns%NOTFOUND;
335:
336: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
337: gme_debug.put_line ( g_pkg_name
338: || '.'
339: || l_api_name
340: || ':'

Line 337: gme_debug.put_line ( g_pkg_name

333:
334: EXIT WHEN c_get_cmplt_zero_def_txns%NOTFOUND;
335:
336: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
337: gme_debug.put_line ( g_pkg_name
338: || '.'
339: || l_api_name
340: || ':'
341: || 'l_last_txn id = '

Line 343: gme_debug.put_line ( g_pkg_name

339: || l_api_name
340: || ':'
341: || 'l_last_txn id = '
342: || l_last_txn.trans_id);
343: gme_debug.put_line ( g_pkg_name
344: || '.'
345: || l_api_name
346: || ':'
347: || 'l_current_txn id = '

Line 358: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

354: AND (l_last_txn.item_id = l_current_txn.item_id)
355: AND (l_last_txn.whse_code = l_current_txn.whse_code)
356: AND (l_last_txn.lot_id = l_current_txn.lot_id)
357: AND (l_last_txn.LOCATION = l_current_txn.LOCATION) THEN
358: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
359: gme_debug.put_line ( g_pkg_name
360: || '.'
361: || l_api_name
362: || ':'

Line 359: gme_debug.put_line ( g_pkg_name

355: AND (l_last_txn.whse_code = l_current_txn.whse_code)
356: AND (l_last_txn.lot_id = l_current_txn.lot_id)
357: AND (l_last_txn.LOCATION = l_current_txn.LOCATION) THEN
358: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
359: gme_debug.put_line ( g_pkg_name
360: || '.'
361: || l_api_name
362: || ':'
363: || 'These txns match!');

Line 364: gme_debug.put_line ( g_pkg_name

360: || '.'
361: || l_api_name
362: || ':'
363: || 'These txns match!');
364: gme_debug.put_line ( g_pkg_name
365: || '.'
366: || l_api_name
367: || ':'
368: || 'Matching Reversal for '

Line 384: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

380: FETCH c_get_cmplt_zero_def_txns
381: INTO l_last_txn;
382: ELSE
383: /* _last_txn.material_detail_id = l_current_txn.material_detail_id */
384: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
385: gme_debug.put_line ( g_pkg_name
386: || '.'
387: || l_api_name
388: || ':'

Line 385: gme_debug.put_line ( g_pkg_name

381: INTO l_last_txn;
382: ELSE
383: /* _last_txn.material_detail_id = l_current_txn.material_detail_id */
384: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
385: gme_debug.put_line ( g_pkg_name
386: || '.'
387: || l_api_name
388: || ':'
389: || 'These txns do not match!');

Line 410: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

406: AND doc_id = p_batch_row.batch_id
407: AND ( (line_type = -1 AND trans_qty > 0)
408: OR (line_type <> -1 AND trans_qty < 0) );
409:
410: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
411: gme_debug.put_line ( g_pkg_name
412: || '.'
413: || l_api_name
414: || ':'

Line 411: gme_debug.put_line ( g_pkg_name

407: AND ( (line_type = -1 AND trans_qty > 0)
408: OR (line_type <> -1 AND trans_qty < 0) );
409:
410: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
411: gme_debug.put_line ( g_pkg_name
412: || '.'
413: || l_api_name
414: || ':'
415: || 'No. Of reversals Found is = '

Line 428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

424: INTO init_revs;
425:
426: EXIT WHEN c_get_init_reversal%NOTFOUND;
427:
428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);

Line 429: gme_debug.put_line ('Find matching Revserals');

425:
426: EXIT WHEN c_get_init_reversal%NOTFOUND;
427:
428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);

Line 430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);

426: EXIT WHEN c_get_init_reversal%NOTFOUND;
427:
428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);

Line 431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);

427:
428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));

Line 432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);

428: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));
436: */

Line 433: gme_debug.put_line('ORIG location is => ' || init_revs.location);

429: gme_debug.put_line ('Find matching Revserals');
430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));
436: */
437: END IF; /* NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT */

Line 434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);

430: gme_debug.put_line ('ORIG id is => ' || init_revs.trans_id);
431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));
436: */
437: END IF; /* NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT */
438:

Line 435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));

431: /* gme_debug.put_line('ORIG itemid is => ' || init_revs.item_id);
432: gme_debug.put_line('ORIG lotid is => ' || init_revs.lot_id);
433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));
436: */
437: END IF; /* NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT */
438:
439: --BUG#3528006 OPEN c_get_match_reversal (p_batch_row.batch_id);

Line 437: END IF; /* NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT */

433: gme_debug.put_line('ORIG location is => ' || init_revs.location);
434: gme_debug.put_line('ORIG COM IND is => ' || init_revs.completed_ind);
435: gme_debug.put_line('ORIG TRANS is => ' || ABS(init_revs.trans_qty));
436: */
437: END IF; /* NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT */
438:
439: --BUG#3528006 OPEN c_get_match_reversal (p_batch_row.batch_id);
440: --3187467 Shikha Nagar 05/12/03
441: l_match_rev_id := NULL;

Line 460: gme_debug.put_line ('NEW id is => ' || match_revs.trans_id);

456: FETCH c_get_match_reversal_date_cmp
457: INTO match_revs;
458:
459: IF c_get_match_reversal_date_cmp%FOUND THEN
460: gme_debug.put_line ('NEW id is => ' || match_revs.trans_id);
461: gme_debug.put_line ( g_pkg_name
462: || '.'
463: || l_api_name
464: || ':'

Line 461: gme_debug.put_line ( g_pkg_name

457: INTO match_revs;
458:
459: IF c_get_match_reversal_date_cmp%FOUND THEN
460: gme_debug.put_line ('NEW id is => ' || match_revs.trans_id);
461: gme_debug.put_line ( g_pkg_name
462: || '.'
463: || l_api_name
464: || ':'
465: || 'Matching Reversal for '

Line 488: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

484: INTO match_revs;
485:
486: /* BEGIN BUG#3528006
487: EXIT WHEN c_get_match_reversal%NOTFOUND;
488: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
489: END BUG#3528006 */
490: IF c_get_match_reversal%FOUND THEN --BUG#3528006
491: gme_debug.put_line ('NEW id is => '
492: || match_revs.trans_id);

Line 491: gme_debug.put_line ('NEW id is => '

487: EXIT WHEN c_get_match_reversal%NOTFOUND;
488: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
489: END BUG#3528006 */
490: IF c_get_match_reversal%FOUND THEN --BUG#3528006
491: gme_debug.put_line ('NEW id is => '
492: || match_revs.trans_id);
493: --BEGIN BUG#3528006
494: gme_debug.put_line ( g_pkg_name
495: || '.'

Line 494: gme_debug.put_line ( g_pkg_name

490: IF c_get_match_reversal%FOUND THEN --BUG#3528006
491: gme_debug.put_line ('NEW id is => '
492: || match_revs.trans_id);
493: --BEGIN BUG#3528006
494: gme_debug.put_line ( g_pkg_name
495: || '.'
496: || l_api_name
497: || ':'
498: || 'Matching Reversal for '

Line 526: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

522: (init_revs.completed_ind = match_revs.completed_ind) AND
523: (NVL(init_revs.reason_code,0) = NVL(match_revs.reason_code,0)) AND --3187467
524: (ABS (init_revs.trans_qty) = ABS (match_revs.trans_qty))
525: ) THEN
526: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
527: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Tentative Matching Reversal for '
528: || init_revs.trans_id|| ' Is => '|| match_revs.trans_id);
529: END IF;
530: --3187467

Line 527: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Tentative Matching Reversal for '

523: (NVL(init_revs.reason_code,0) = NVL(match_revs.reason_code,0)) AND --3187467
524: (ABS (init_revs.trans_qty) = ABS (match_revs.trans_qty))
525: ) THEN
526: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
527: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Tentative Matching Reversal for '
528: || init_revs.trans_id|| ' Is => '|| match_revs.trans_id);
529: END IF;
530: --3187467
531: IF l_match_rev_id IS NULL THEN

Line 585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

581: x_return_status := fnd_api.g_ret_sts_error;
582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN
585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
586: gme_debug.put_line ('sqlerrm=' || SQLERRM);
587: END IF;
588:
589: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 586: gme_debug.put_line ('sqlerrm=' || SQLERRM);

582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN
585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
586: gme_debug.put_line ('sqlerrm=' || SQLERRM);
587: END IF;
588:
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 690: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

686: l_doc_type := 'PROD';
687: ELSIF (p_batch_row.batch_type = 10) THEN
688: l_doc_type := 'FPO';
689: ELSE
690: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
691: gme_debug.put_line ( g_pkg_name
692: || '.'
693: || l_api_name
694: || ':'

Line 691: gme_debug.put_line ( g_pkg_name

687: ELSIF (p_batch_row.batch_type = 10) THEN
688: l_doc_type := 'FPO';
689: ELSE
690: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
691: gme_debug.put_line ( g_pkg_name
692: || '.'
693: || l_api_name
694: || ':'
695: || 'No BATCH TYPE loaded');

Line 696: gme_debug.put_line ( g_pkg_name

692: || '.'
693: || l_api_name
694: || ':'
695: || 'No BATCH TYPE loaded');
696: gme_debug.put_line ( g_pkg_name
697: || '.'
698: || l_api_name
699: || ':'
700: || 'This should RETURN AN Expected Error');

Line 758: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

754: x_rsc_row_count := SQL%ROWCOUNT;
755:
756: /* Lets Now Mark all Resource Transactions that are Reversals
757: With the ACTION_CODE ='REVL' */
758: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
759: gme_debug.put_line ( g_pkg_name
760: || '.'
761: || l_api_name
762: || ':'

Line 759: gme_debug.put_line ( g_pkg_name

755:
756: /* Lets Now Mark all Resource Transactions that are Reversals
757: With the ACTION_CODE ='REVL' */
758: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
759: gme_debug.put_line ( g_pkg_name
760: || '.'
761: || l_api_name
762: || ':'
763: || 'Use SQL to Mark reversals');