APPS.MST_CMP_KPIS dependencies on DBMS_OUTPUT

Line 1532: --DBMS_OUTPUT.put_line('Range1_low is '||l_target_rec_out.Range1_low||

1528: CLOSE get_target_id;
1529: RAISE invalid_target;
1530: END IF;
1531:
1532: --DBMS_OUTPUT.put_line('Range1_low is '||l_target_rec_out.Range1_low||
1533: -- ' and Hig val is '||l_target_rec_out.Range1_high||
1534: -- ' and target is '||l_target_rec_out.target);
1535: ELSE
1536: --dbms_output.put_line('target not defined!!!');

Line 1536: --dbms_output.put_line('target not defined!!!');

1532: --DBMS_OUTPUT.put_line('Range1_low is '||l_target_rec_out.Range1_low||
1533: -- ' and Hig val is '||l_target_rec_out.Range1_high||
1534: -- ' and target is '||l_target_rec_out.target);
1535: ELSE
1536: --dbms_output.put_line('target not defined!!!');
1537: NULL;
1538: END IF;
1539: CLOSE get_target_id;
1540: RETURN NVL(l_target_rec_out.target,0);

Line 1544: DBMS_OUTPUT.put_line('error is '||l_error_tbl(i).Error_Description);

1540: RETURN NVL(l_target_rec_out.target,0);
1541: EXCEPTION
1542: WHEN invalid_target THEN
1543: for i in 1..l_error_tbl.count loop
1544: DBMS_OUTPUT.put_line('error is '||l_error_tbl(i).Error_Description);
1545: end loop;
1546: RETURN 0;
1547: WHEN OTHERS THEN
1548: DBMS_OUTPUT.put_line('error is '||sqlerrm(sqlcode));

Line 1548: DBMS_OUTPUT.put_line('error is '||sqlerrm(sqlcode));

1544: DBMS_OUTPUT.put_line('error is '||l_error_tbl(i).Error_Description);
1545: end loop;
1546: RETURN 0;
1547: WHEN OTHERS THEN
1548: DBMS_OUTPUT.put_line('error is '||sqlerrm(sqlcode));
1549: return 0;
1550: END mst_performance_targets;
1551: END MST_CMP_KPIS;