APPS.GMD_EXPRESSION_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: IF l_expression_tab(i).expression_type = 0 THEN
413: l_expr := l_expr||get_value (p_line_id => p_line_id
414: ,p_parameter => l_expression_tab(i).expression_key);
415: ELSIF l_expression_tab(i).expression_type = 2 THEN

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

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

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

459: x_return_status => l_return_status);
460: IF l_return_status <> x_return_status THEN
461: RAISE expression_eval_err;
462: END IF;
463: gmd_debug.put_line('Not In ISUM Value:'||l_value);
464: IF NVL(l_value, 'NULL') <> 'NULL' THEN
465: l_tot_value := l_tot_value + l_value;
466: END IF;
467: 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;