APPS.GMD_EXPRESSION_MIG_UTIL dependencies on GMD_DEBUG

Line 402: gmd_debug.put_line('Evaluating....Line:'||p_line_id);

398: BEGIN
399: /* First let us assign the return status to success */
400: X_return_status := FND_API.g_ret_sts_success;
401:
402: gmd_debug.put_line('Evaluating....Line:'||p_line_id);
403: FOR m IN 1..p_expression_tab.COUNT LOOP
404: l_temp := l_temp||p_expression_tab(m).expression_key;
405: END LOOP;
406: gmd_debug.put_line('Expr:'||l_temp);

Line 406: gmd_debug.put_line('Expr:'||l_temp);

402: gmd_debug.put_line('Evaluating....Line:'||p_line_id);
403: FOR m IN 1..p_expression_tab.COUNT LOOP
404: l_temp := l_temp||p_expression_tab(m).expression_key;
405: END LOOP;
406: gmd_debug.put_line('Expr:'||l_temp);
407:
408: l_expression_tab := P_expression_tab;
409: l_table_count := l_expression_tab.COUNT;
410: WHILE i <= l_table_count LOOP

Line 411: gmd_debug.put_line('Key:'||l_expression_tab(i).expression_key);

407:
408: l_expression_tab := P_expression_tab;
409: l_table_count := l_expression_tab.COUNT;
410: WHILE i <= l_table_count LOOP
411: gmd_debug.put_line('Key:'||l_expression_tab(i).expression_key);
412: /*Bug 4082268 - Value should be fetched also for expression type -1*/
413: IF l_expression_tab(i).expression_type IN (0, -1) THEN
414: l_expr := l_expr||get_value (p_line_id => p_line_id
415: ,p_parameter => l_expression_tab(i).expression_key);

Line 447: gmd_debug.put_line('In ISUM procedure value:'||l_value||' Tot Value:'||l_tot_value);

443: x_return_status => l_return_status);
444: IF l_return_status <> x_return_status THEN
445: RAISE expression_eval_err;
446: END IF;
447: gmd_debug.put_line('In ISUM procedure value:'||l_value||' Tot Value:'||l_tot_value);
448: IF NVL(l_value, 'NULL') <> 'NULL' THEN
449: l_tot_value := l_tot_value + l_value;
450: END IF;
451: END LOOP;

Line 461: gmd_debug.put_line('Not In ISUM Value:'||l_value);

457: x_return_status => l_return_status);
458: IF l_return_status <> x_return_status THEN
459: RAISE expression_eval_err;
460: END IF;
461: gmd_debug.put_line('Not In ISUM Value:'||l_value);
462: IF NVL(l_value, 'NULL') <> 'NULL' THEN
463: l_tot_value := l_tot_value + l_value;
464: END IF;
465: END LOOP;

Line 478: gmd_debug.put_line('Total:'||l_tot_value||' Start:'||l_start||' End:'||l_end||' Expr:'||l_expr);

474: ELSE
475: l_expr := l_expr||l_tot_value;
476: END IF;
477: i := l_end;
478: gmd_debug.put_line('Total:'||l_tot_value||' Start:'||l_start||' End:'||l_end||' Expr:'||l_expr);
479: ELSE
480: l_expr := l_expr||p_expression_tab(i).expression_key;
481: END IF;
482: i := i + 1;

Line 484: gmd_debug.put_line('Final Expr:'||l_expr);

480: l_expr := l_expr||p_expression_tab(i).expression_key;
481: END IF;
482: i := i + 1;
483: END LOOP;
484: gmd_debug.put_line('Final Expr:'||l_expr);
485: IF l_expr IS NOT NULL THEN
486: GMD_UTILITY_PKG.execute_exp (pexp => l_expr,
487: pexp_test => FALSE,
488: x_result => x_value,

Line 493: gmd_debug.put_line('Value:'||x_value);

489: x_return_status => l_return_status);
490: IF l_return_status <> x_return_status THEN
491: RAISE expression_eval_err;
492: END IF;
493: gmd_debug.put_line('Value:'||x_value);
494: END IF;
495: EXCEPTION
496: WHEN expression_eval_err THEN
497: x_return_status := l_return_status;

Line 499: gmd_debug.put_line('ERROR:'||sqlerrm);

495: EXCEPTION
496: WHEN expression_eval_err THEN
497: x_return_status := l_return_status;
498: WHEN OTHERS THEN
499: gmd_debug.put_line('ERROR:'||sqlerrm);
500: fnd_msg_pub.add_exc_msg ('GMD_EXPRESSION_UTIL', 'Evaluate_Expression_Value');
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: END evaluate_expression_value;
503:

Line 530: gmd_debug.put_line(' In Get Value:'||p_parameter);

526: l_value NUMBER;
527: l_mass_qty NUMBER;
528: l_vol_qty NUMBER;
529: BEGIN
530: gmd_debug.put_line(' In Get Value:'||p_parameter);
531: IF p_parameter IN ('QTY$', 'VOL$') THEN
532: OPEN Cur_get_line_qty (p_line_id);
533: FETCH Cur_get_line_qty INTO l_mass_qty, l_vol_qty;
534: CLOSE Cur_get_line_qty;

Line 545: gmd_debug.put_line('Returning:'||l_value);

541: OPEN Cur_value (P_line_id, P_parameter);
542: FETCH Cur_value INTO l_value;
543: CLOSE Cur_value;
544: END IF;
545: gmd_debug.put_line('Returning:'||l_value);
546: IF l_value IS NULL THEN
547: gmd_debug.put_line(' Returning NULL');
548: RETURN('NULL');
549: ELSE

Line 547: gmd_debug.put_line(' Returning NULL');

543: CLOSE Cur_value;
544: END IF;
545: gmd_debug.put_line('Returning:'||l_value);
546: IF l_value IS NULL THEN
547: gmd_debug.put_line(' Returning NULL');
548: RETURN('NULL');
549: ELSE
550: RETURN(l_value);
551: END IF;