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.QP_FORMULA_RULES_PVT dependencies on OE_DEBUG_PUB

Line 52: -- oe_debug_pub.add(' ');

48: BEGIN
49:
50: line_number := line_number + 1;
51: ad_ddl.build_package(' ',line_number);
52: -- oe_debug_pub.add(' ');
53:
54: END New_Line;
55:
56: PROCEDURE Text

Line 65: -- oe_debug_pub.add(LPAD(p_string,p_level*2+LENGTH(p_string)));

61: BEGIN
62:
63: line_number := line_number + 1;
64: ad_ddl.build_package(LPAD(p_string,p_level*2+LENGTH(p_string)),line_number);
65: -- oe_debug_pub.add(LPAD(p_string,p_level*2+LENGTH(p_string)));
66: --dbms_output.put_line(LPAD(p_string,p_level*2+LENGTH(p_string)));
67:
68: END text;
69:

Line 217: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

213: l_is_pkg_body := 'FALSE';
214: END IF;
215:
216: PUT_LINE( 'Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
217: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);
218:
219:
220: ad_ddl.create_package(applsys_schema => g_schema
221: ,application_short_name => 'QP'

Line 233: oe_debug_pub.add('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);

229: l_pkg_name := p_pkg_name;
230: FOR error IN errors LOOP
231: if n= 0 then
232: PUT_LINE('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
233: oe_debug_pub.add('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
234: end if;
235: PUT_LINE('LINE :'||error.line||' '||substr(error.text,1,200));
236: oe_debug_pub.add('LINE :'||error.line||' '||substr(error.text,1,200));
237: n := 1;

Line 236: oe_debug_pub.add('LINE :'||error.line||' '||substr(error.text,1,200));

232: PUT_LINE('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
233: oe_debug_pub.add('ERROR in creating PACKAGE '||p_pkg_type||' :'||p_pkg_name);
234: end if;
235: PUT_LINE('LINE :'||error.line||' '||substr(error.text,1,200));
236: oe_debug_pub.add('LINE :'||error.line||' '||substr(error.text,1,200));
237: n := 1;
238: END LOOP;
239:
240: -- if there was an error in compiling the package, raise

Line 254: oe_debug_pub.add('PACKAGE '||p_pkg_type||' Name to :' || l_pkg_name||' compiled successfully ');

250: --as QP_BUILD_FORMULA_RULES
251:
252: PUT_LINE('PACKAGE '||p_pkg_type||' Name to :' ||l_pkg_name||' compiled successfully ');
253:
254: oe_debug_pub.add('PACKAGE '||p_pkg_type||' Name to :' || l_pkg_name||' compiled successfully ');
255:
256: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
257:
258: oe_debug_pub.add('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);

Line 258: oe_debug_pub.add('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);

254: oe_debug_pub.add('PACKAGE '||p_pkg_type||' Name to :' || l_pkg_name||' compiled successfully ');
255:
256: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
257:
258: oe_debug_pub.add('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
259:
260: IF instr(ad_ddl.glprogtext(1),p_pkg_name) > 0 THEN
261:
262: ad_ddl.glprogtext(1) := REPLACE(ad_ddl.glprogtext(1)

Line 268: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));

264: ,l_new_pkg_name);
265:
266: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));
267:
268: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));
269:
270: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)
271: ,p_pkg_name
272: ,l_new_pkg_name);

Line 276: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));

272: ,l_new_pkg_name);
273:
274: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
275:
276: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
277:
278: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
279:
280: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);

Line 280: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);

276: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
277:
278: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
279:
280: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
281:
282: ad_ddl.create_package(applsys_schema => g_schema
283: ,application_short_name => 'QP'
284: ,package_name => l_new_pkg_name

Line 298: oe_debug_pub.add('ERROR in creating PACKAGE ' ||p_pkg_type||' :'||l_pkg_name);

294: FOR error IN errors LOOP
295: if n = 0 then
296: PUT_LINE('ERROR in creating PACKAGE ' ||p_pkg_type||' :'||l_pkg_name);
297:
298: oe_debug_pub.add('ERROR in creating PACKAGE ' ||p_pkg_type||' :'||l_pkg_name);
299:
300: end if;
301: PUT_LINE('LINE :'||error.line||' ' ||substr(error.text,1,200));
302:

Line 303: oe_debug_pub.add('LINE :'||error.line||' ' ||substr(error.text,1,200));

299:
300: end if;
301: PUT_LINE('LINE :'||error.line||' ' ||substr(error.text,1,200));
302:
303: oe_debug_pub.add('LINE :'||error.line||' ' ||substr(error.text,1,200));
304: n := 1;
305: END LOOP;
306:
307: -- if there was an error in compiling the package, raise

Line 316: oe_debug_pub.add('Generated PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name ||' Successfully');

312: end if;
313:
314: PUT_LINE('Generated PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name ||' Successfully');
315:
316: oe_debug_pub.add('Generated PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name ||' Successfully');
317:
318: ELSE
319: null;
320: END IF;--instr

Line 428: oe_debug_pub.add('##### Begin Build Formulas #####');

424: l_formula_String_f varchar2(32000):=' '; -- modified by rassharm 5713302
425:
426: BEGIN
427:
428: oe_debug_pub.add('##### Begin Build Formulas #####');
429:
430: Init_Applsys_Schema;
431:
432: -- Writing out the body

Line 616: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);

612: Text(' THEN', 2);
613: Text('IF p_procedure_type != ''S'' THEN', 3); --sfiresto
614: New_Line;
615: IF l_category = 'EXPRESSION' THEN
616: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
617: Break_Text('x_formula_value := ' || l_new_formula, 4);
618: Text('x_return_status := ''S''' || ';',4);
619: --dbms_output.put_line('IN EXPRESSION ');
620: ELSIF l_category = 'PLSQL' THEN

Line 621: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);

617: Break_Text('x_formula_value := ' || l_new_formula, 4);
618: Text('x_return_status := ''S''' || ';',4);
619: --dbms_output.put_line('IN EXPRESSION ');
620: ELSIF l_category = 'PLSQL' THEN
621: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
622: l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';
623: Break_Text(l_select_stmt, 4);
624: Text('x_return_status := ''S''' || ';',4);
625: --dbms_output.put_line('IN PLSQL ');

Line 627: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);

623: Break_Text(l_select_stmt, 4);
624: Text('x_return_status := ''S''' || ';',4);
625: --dbms_output.put_line('IN PLSQL ');
626: ELSIF l_category = 'SQL' THEN
627: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
628: select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara
629: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
630: Break_Text(l_select_stmt, 4);
631: Text('x_return_status := ''S''' || ';',4);

Line 650: Text('oe_debug_pub.add(''Error in QP_BUILD_FORMULA_RULES_TMP -''||sqlerrm)'||';');

646: New_Line;
647: Text('EXCEPTION',1);
648: Text('WHEN OTHERS THEN',2);
649: Text('x_return_status := ''E''' || ';',3);
650: Text('oe_debug_pub.add(''Error in QP_BUILD_FORMULA_RULES_TMP -''||sqlerrm)'||';');
651: Text('END' || ';',1);
652: Text('END Get_Formula_Values;',0);
653: New_Line;
654:

Line 661: oe_debug_pub.add('##### ' || err_buff || ' #####');

657: FND_MESSAGE.SET_NAME('QP','QP_BUILD_FORMULAS_SUCCESS');
658: err_buff := FND_MESSAGE.GET;
659: PUT_LINE(err_buff);
660: retcode := 0;
661: oe_debug_pub.add('##### ' || err_buff || ' #####');
662: oe_debug_pub.add('##### End Build Formulas #####');
663:
664: EXCEPTION
665:

Line 662: oe_debug_pub.add('##### End Build Formulas #####');

658: err_buff := FND_MESSAGE.GET;
659: PUT_LINE(err_buff);
660: retcode := 0;
661: oe_debug_pub.add('##### ' || err_buff || ' #####');
662: oe_debug_pub.add('##### End Build Formulas #####');
663:
664: EXCEPTION
665:
666: WHEN FND_API.G_EXC_ERROR THEN

Line 674: oe_debug_pub.add('##### ' || err_buff || ' #####');

670: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
671: err_buff := FND_MESSAGE.GET;
672: PUT_LINE(err_buff);
673: retcode := 2;
674: oe_debug_pub.add('##### ' || err_buff || ' #####');
675: oe_debug_pub.add('##### End Build Formulas #####');
676:
677: WHEN OTHERS THEN
678: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');

Line 675: oe_debug_pub.add('##### End Build Formulas #####');

671: err_buff := FND_MESSAGE.GET;
672: PUT_LINE(err_buff);
673: retcode := 2;
674: oe_debug_pub.add('##### ' || err_buff || ' #####');
675: oe_debug_pub.add('##### End Build Formulas #####');
676:
677: WHEN OTHERS THEN
678: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
679: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');

Line 685: oe_debug_pub.add('##### ' || err_buff || ' #####');

681: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
682: err_buff := FND_MESSAGE.GET;
683: PUT_LINE(err_buff);
684: retcode := 2;
685: oe_debug_pub.add('##### ' || err_buff || ' #####');
686: oe_debug_pub.add('##### End Build Formulas #####');
687:
688: END FORMULAS;
689:

Line 686: oe_debug_pub.add('##### End Build Formulas #####');

682: err_buff := FND_MESSAGE.GET;
683: PUT_LINE(err_buff);
684: retcode := 2;
685: oe_debug_pub.add('##### ' || err_buff || ' #####');
686: oe_debug_pub.add('##### End Build Formulas #####');
687:
688: END FORMULAS;
689:
690: END QP_FORMULA_RULES_PVT;