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

Line 117: IF g_debug <= gme_debug.g_log_procedure THEN

113: AND inventory_item_id = v_inventory_item_id
114: AND line_type = gme_common_pvt.g_line_type_prod
115: ORDER BY line_no;
116: BEGIN
117: IF g_debug <= gme_debug.g_log_procedure THEN
118: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
119: || l_api_name);
120: END IF;
121:

Line 118: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

114: AND line_type = gme_common_pvt.g_line_type_prod
115: ORDER BY line_no;
116: BEGIN
117: IF g_debug <= gme_debug.g_log_procedure THEN
118: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
119: || l_api_name);
120: END IF;
121:
122: /* Set the return status to success initially */

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

157: ELSE
158: l_object_type := 'P';
159: END IF;
160:
161: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
162: gme_debug.put_line ( g_pkg_name
163: || '.'
164: || l_api_name
165: || ':'

Line 162: gme_debug.put_line ( g_pkg_name

158: l_object_type := 'P';
159: END IF;
160:
161: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
162: gme_debug.put_line ( g_pkg_name
163: || '.'
164: || l_api_name
165: || ':'
166: || 'Get VR for phantom ingredient '||x_material_detail_rec.inventory_item_id||' revision '||x_material_detail_rec.revision);

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

192: l_validity_rule_id := l_validity_tbl (1).recipe_validity_rule_id;
193: ELSE
194: l_validity_rule_id := p_validity_rule_id;
195: END IF; /* IF p_validity_rule_id IS NULL */
196: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
197: gme_debug.put_line ( g_pkg_name
198: || '.'
199: || l_api_name
200: || ':'

Line 197: gme_debug.put_line ( g_pkg_name

193: ELSE
194: l_validity_rule_id := p_validity_rule_id;
195: END IF; /* IF p_validity_rule_id IS NULL */
196: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
197: gme_debug.put_line ( g_pkg_name
198: || '.'
199: || l_api_name
200: || ':'
201: || 'VR for phantom ingredient '||l_validity_rule_id);

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

225:
226: CLOSE cur_step_matl_detail;
227: END IF;
228:
229: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
230: gme_debug.put_line ( g_pkg_name
231: || '.'
232: || l_api_name
233: || ':'

Line 230: gme_debug.put_line ( g_pkg_name

226: CLOSE cur_step_matl_detail;
227: END IF;
228:
229: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
230: gme_debug.put_line ( g_pkg_name
231: || '.'
232: || l_api_name
233: || ':'
234: || 'Calling Create_batch');

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

247: ,p_contiguity_override => p_contiguity_override
248: ,x_exception_material_tbl => x_exception_material_tbl
249: ,p_is_phantom => 'Y');
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('create_batch-return_status ' || x_return_status);
253: gme_debug.put_line ( g_pkg_name
254: || '.'
255: || l_api_name

Line 252: gme_debug.put_line ('create_batch-return_status ' || x_return_status);

248: ,x_exception_material_tbl => x_exception_material_tbl
249: ,p_is_phantom => 'Y');
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('create_batch-return_status ' || x_return_status);
253: gme_debug.put_line ( g_pkg_name
254: || '.'
255: || l_api_name
256: || ':'

Line 253: gme_debug.put_line ( g_pkg_name

249: ,p_is_phantom => 'Y');
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('create_batch-return_status ' || x_return_status);
253: gme_debug.put_line ( g_pkg_name
254: || '.'
255: || l_api_name
256: || ':'
257: || ' Create_batch returned '

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

263: ROLLBACK TO SAVEPOINT create_auto_phantom;
264: RAISE batch_creation_failed;
265: END IF;
266:
267: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
268: gme_debug.put_line ('Update batch_id '|| l_phant_batch.batch_id||' with parentline_id '||p_material_detail_rec.material_detail_id);
269: END IF;
270:
271: -- Bug 14681911 - Refresh the variable data before the next update.

Line 268: gme_debug.put_line ('Update batch_id '|| l_phant_batch.batch_id||' with parentline_id '||p_material_detail_rec.material_detail_id);

264: RAISE batch_creation_failed;
265: END IF;
266:
267: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
268: gme_debug.put_line ('Update batch_id '|| l_phant_batch.batch_id||' with parentline_id '||p_material_detail_rec.material_detail_id);
269: END IF;
270:
271: -- Bug 14681911 - Refresh the variable data before the next update.
272: IF NOT (gme_batch_header_dbl.fetch_row (l_phant_batch, l_phant_batch)) THEN

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

291: INTO l_prod_mtl_dtl_id;
292:
293: CLOSE cur_get_phantom_prod;
294:
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('Lets Update line ids now');
297: gme_debug.put_line ('Update phantom prod material_detail_id '|| l_prod_mtl_dtl_id||' with phantom_line_id '||p_material_detail_rec.material_detail_id);
298: END IF;
299:

Line 296: gme_debug.put_line ('Lets Update line ids now');

292:
293: CLOSE cur_get_phantom_prod;
294:
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('Lets Update line ids now');
297: gme_debug.put_line ('Update phantom prod material_detail_id '|| l_prod_mtl_dtl_id||' with phantom_line_id '||p_material_detail_rec.material_detail_id);
298: END IF;
299:
300: UPDATE gme_material_details

Line 297: gme_debug.put_line ('Update phantom prod material_detail_id '|| l_prod_mtl_dtl_id||' with phantom_line_id '||p_material_detail_rec.material_detail_id);

293: CLOSE cur_get_phantom_prod;
294:
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('Lets Update line ids now');
297: gme_debug.put_line ('Update phantom prod material_detail_id '|| l_prod_mtl_dtl_id||' with phantom_line_id '||p_material_detail_rec.material_detail_id);
298: END IF;
299:
300: UPDATE gme_material_details
301: SET phantom_line_id = p_material_detail_rec.material_detail_id

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

309:
310: x_material_detail_rec.phantom_id := l_phant_batch.batch_id;
311: x_material_detail_rec.phantom_line_id := l_prod_mtl_dtl_id;
312:
313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
314: gme_debug.put_line (' ');
315: gme_debug.put_line ('Update material_detail_id '|| p_material_detail_rec.material_detail_id||' with phantom_line_id '||l_prod_mtl_dtl_id);
316: END IF;
317:

Line 314: gme_debug.put_line (' ');

310: x_material_detail_rec.phantom_id := l_phant_batch.batch_id;
311: x_material_detail_rec.phantom_line_id := l_prod_mtl_dtl_id;
312:
313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
314: gme_debug.put_line (' ');
315: gme_debug.put_line ('Update material_detail_id '|| p_material_detail_rec.material_detail_id||' with phantom_line_id '||l_prod_mtl_dtl_id);
316: END IF;
317:
318: UPDATE gme_material_details

Line 315: gme_debug.put_line ('Update material_detail_id '|| p_material_detail_rec.material_detail_id||' with phantom_line_id '||l_prod_mtl_dtl_id);

311: x_material_detail_rec.phantom_line_id := l_prod_mtl_dtl_id;
312:
313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
314: gme_debug.put_line (' ');
315: gme_debug.put_line ('Update material_detail_id '|| p_material_detail_rec.material_detail_id||' with phantom_line_id '||l_prod_mtl_dtl_id);
316: END IF;
317:
318: UPDATE gme_material_details
319: SET phantom_line_id = l_prod_mtl_dtl_id

Line 328: IF g_debug <= gme_debug.g_log_procedure THEN

324: WHERE material_detail_id = p_material_detail_rec.material_detail_id;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
328: IF g_debug <= gme_debug.g_log_procedure THEN
329: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
330: END IF;
331: EXCEPTION
332: WHEN batch_creation_failed OR material_detail_fetch_error OR not_a_phantom OR phantom_exists OR batch_header_fetch_error OR validity_fetch_error OR batch_creation_failed OR batch_upd_error THEN

Line 329: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
328: IF g_debug <= gme_debug.g_log_procedure THEN
329: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
330: END IF;
331: EXCEPTION
332: WHEN batch_creation_failed OR material_detail_fetch_error OR not_a_phantom OR phantom_exists OR batch_header_fetch_error OR validity_fetch_error OR batch_creation_failed OR batch_upd_error THEN
333: x_return_status := fnd_api.g_ret_sts_error;

Line 337: IF g_debug <= gme_debug.g_log_unexpected THEN

333: x_return_status := fnd_api.g_ret_sts_error;
334: WHEN no_validity_found THEN
335: x_return_status := 'W';
336: WHEN OTHERS THEN
337: IF g_debug <= gme_debug.g_log_unexpected THEN
338: gme_debug.put_line ( 'When others exception in '
339: || g_pkg_name
340: || '.'
341: || l_api_name

Line 338: gme_debug.put_line ( 'When others exception in '

334: WHEN no_validity_found THEN
335: x_return_status := 'W';
336: WHEN OTHERS THEN
337: IF g_debug <= gme_debug.g_log_unexpected THEN
338: gme_debug.put_line ( 'When others exception in '
339: || g_pkg_name
340: || '.'
341: || l_api_name
342: || ' Error is '

Line 371: IF g_debug <= gme_debug.g_log_procedure THEN

367: l_batch_header gme_batch_header%ROWTYPE;
368: error_fetch_header EXCEPTION;
369: l_api_name CONSTANT VARCHAR2 (30) := 'IS_PHANTOM';
370: BEGIN
371: IF g_debug <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
373: || l_api_name);
374: END IF;
375:

Line 372: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

368: error_fetch_header EXCEPTION;
369: l_api_name CONSTANT VARCHAR2 (30) := 'IS_PHANTOM';
370: BEGIN
371: IF g_debug <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
373: || l_api_name);
374: END IF;
375:
376: x_return_status := fnd_api.g_ret_sts_success;

Line 393: IF g_debug <= gme_debug.g_log_unexpected THEN

389: WHEN error_fetch_header THEN
390: x_return_status := fnd_api.g_ret_sts_error;
391: RETURN FALSE;
392: WHEN OTHERS THEN
393: IF g_debug <= gme_debug.g_log_unexpected THEN
394: gme_debug.put_line ( 'When others exception in '
395: || g_pkg_name
396: || '.'
397: || l_api_name

Line 394: gme_debug.put_line ( 'When others exception in '

390: x_return_status := fnd_api.g_ret_sts_error;
391: RETURN FALSE;
392: WHEN OTHERS THEN
393: IF g_debug <= gme_debug.g_log_unexpected THEN
394: gme_debug.put_line ( 'When others exception in '
395: || g_pkg_name
396: || '.'
397: || l_api_name
398: || ' Error is '

Line 451: IF g_debug <= gme_debug.g_log_procedure THEN

447: AND NVL (d.phantom_id, 0) > 0;
448:
449: no_keys EXCEPTION;
450: BEGIN
451: IF g_debug <= gme_debug.g_log_procedure THEN
452: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
453: || l_api_name);
454: END IF;
455:

Line 452: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

448:
449: no_keys EXCEPTION;
450: BEGIN
451: IF g_debug <= gme_debug.g_log_procedure THEN
452: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
453: || l_api_name);
454: END IF;
455:
456: x_return_status := fnd_api.g_ret_sts_success;

Line 469: IF g_debug <= gme_debug.g_log_procedure THEN

465: BULK COLLECT INTO x_phantom_ids;
466:
467: CLOSE cur_step_matl_detail_ids;
468:
469: IF g_debug <= gme_debug.g_log_procedure THEN
470: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
471: END IF;
472: EXCEPTION
473: WHEN no_keys THEN

Line 470: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

466:
467: CLOSE cur_step_matl_detail_ids;
468:
469: IF g_debug <= gme_debug.g_log_procedure THEN
470: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
471: END IF;
472: EXCEPTION
473: WHEN no_keys THEN
474: x_return_status := fnd_api.g_ret_sts_error;

Line 479: IF g_debug <= gme_debug.g_log_unexpected THEN

475: gme_common_pvt.log_message ('GME_NO_KEYS'
476: ,'TABLE_NAME'
477: ,'FETCH_STEP_PHANTOMS');
478: WHEN OTHERS THEN
479: IF g_debug <= gme_debug.g_log_unexpected THEN
480: gme_debug.put_line ( 'When others exception in '
481: || g_pkg_name
482: || '.'
483: || l_api_name

Line 480: gme_debug.put_line ( 'When others exception in '

476: ,'TABLE_NAME'
477: ,'FETCH_STEP_PHANTOMS');
478: WHEN OTHERS THEN
479: IF g_debug <= gme_debug.g_log_unexpected THEN
480: gme_debug.put_line ( 'When others exception in '
481: || g_pkg_name
482: || '.'
483: || l_api_name
484: || ' Error is '

Line 525: IF g_debug <= gme_debug.g_log_procedure THEN

521: AND NVL (d.phantom_id, 0) > 0;
522:
523: no_keys EXCEPTION;
524: BEGIN
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
527: || l_api_name);
528: END IF;
529:

Line 526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

522:
523: no_keys EXCEPTION;
524: BEGIN
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
527: || l_api_name);
528: END IF;
529:
530: x_return_status := fnd_api.g_ret_sts_success;

Line 549: IF g_debug <= gme_debug.g_log_procedure THEN

545: BULK COLLECT INTO x_phantom_ids;
546:
547: CLOSE cur_matl_phant_ids;
548:
549: IF g_debug <= gme_debug.g_log_procedure THEN
550: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
551: END IF;
552: EXCEPTION
553: WHEN no_keys THEN

Line 550: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

546:
547: CLOSE cur_matl_phant_ids;
548:
549: IF g_debug <= gme_debug.g_log_procedure THEN
550: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
551: END IF;
552: EXCEPTION
553: WHEN no_keys THEN
554: x_return_status := fnd_api.g_ret_sts_error;

Line 559: IF g_debug <= gme_debug.g_log_unexpected THEN

555: gme_common_pvt.log_message ('GME_NO_KEYS'
556: ,'TABLE_NAME'
557: ,'FETCH_LINE_PHANTOMS');
558: WHEN OTHERS THEN
559: IF g_debug <= gme_debug.g_log_unexpected THEN
560: gme_debug.put_line ( 'When others exception in '
561: || g_pkg_name
562: || '.'
563: || l_api_name

Line 560: gme_debug.put_line ( 'When others exception in '

556: ,'TABLE_NAME'
557: ,'FETCH_LINE_PHANTOMS');
558: WHEN OTHERS THEN
559: IF g_debug <= gme_debug.g_log_unexpected THEN
560: gme_debug.put_line ( 'When others exception in '
561: || g_pkg_name
562: || '.'
563: || l_api_name
564: || ' Error is '