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 220: oe_debug_pub.add('Call AD_DDL to create '||p_pkg_type||' of package '||p_pkg_name);

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

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

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

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

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

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

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

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

257: oe_debug_pub.add('PACKAGE '||p_pkg_type||' Name to :' || l_pkg_name||' compiled successfully ');
258:
259: PUT_LINE('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
260:
261: oe_debug_pub.add('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
262: PUT_LINE('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
263:
264: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
265: -- 13638721

Line 264: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);

260:
261: oe_debug_pub.add('Now create PACKAGE '||p_pkg_type||' : ' ||l_new_pkg_name);
262: PUT_LINE('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
263:
264: oe_debug_pub.add('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
265: -- 13638721
266: IF (L_MAINT_DYN_SRC_VER='Y') THEN
267: BEGIN
268: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_FORMULA_ACTV_VER' AND ROWNUM=1;

Line 277: oe_debug_pub.add('found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);

273: l_new_pkg_name := l_new_pkg_name || To_Char(To_Number(l_pkg_ver)+1);
274: END IF;
275: PUT_LINE('found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
276:
277: oe_debug_pub.add('found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
278:
279: EXCEPTION
280: WHEN No_Data_Found THEN
281: l_insert_row := 'Y';

Line 285: oe_debug_pub.add('no data found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);

281: l_insert_row := 'Y';
282: l_new_pkg_name := l_new_pkg_name || '1';
283: PUT_LINE('no data found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
284:
285: oe_debug_pub.add('no data found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
286: WHEN OTHERS THEN
287: PUT_LINE('when others row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
288:
289: oe_debug_pub.add('when others row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);

Line 289: oe_debug_pub.add('when others row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);

285: oe_debug_pub.add('no data found row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
286: WHEN OTHERS THEN
287: PUT_LINE('when others row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
288:
289: oe_debug_pub.add('when others row in qp_params for code BLD_FORMULA_ACTV_VER new pkg name: ' || l_new_pkg_name);
290: END;
291:
292: END IF;
293: -- 13638721

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

298: ,l_new_pkg_name);
299:
300: PUT_LINE('First change : ' ||ad_ddl.glprogtext(1));
301:
302: oe_debug_pub.add('First change : ' ||ad_ddl.glprogtext(1));
303:
304: ad_ddl.glprogtext(line_number) := REPLACE(ad_ddl.glprogtext(line_number)
305: ,p_pkg_name
306: ,l_new_pkg_name);

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

306: ,l_new_pkg_name);
307:
308: PUT_LINE('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
309:
310: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
311:
312: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
313:
314: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);

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

310: oe_debug_pub.add('Second change : ' ||' '||ad_ddl.glprogtext(line_number));
311:
312: PUT_LINE('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
313:
314: oe_debug_pub.add('Trying to create PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name);
315:
316: ad_ddl.create_package(applsys_schema => g_schema
317: ,application_short_name => 'QP'
318: ,package_name => l_new_pkg_name

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

328: FOR error IN errors LOOP
329: if n = 0 then
330: PUT_LINE('ERROR in creating PACKAGE ' ||p_pkg_type||' :'||l_pkg_name);
331:
332: oe_debug_pub.add('ERROR in creating PACKAGE ' ||p_pkg_type||' :'||l_pkg_name);
333:
334: end if;
335: PUT_LINE('LINE :'||error.line||' ' ||substr(error.text,1,200));
336:

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

333:
334: end if;
335: PUT_LINE('LINE :'||error.line||' ' ||substr(error.text,1,200));
336:
337: oe_debug_pub.add('LINE :'||error.line||' ' ||substr(error.text,1,200));
338: n := 1;
339: END LOOP;
340:
341: -- if there was an error in compiling the package, raise

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

346: end if;
347:
348: PUT_LINE('Generated PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name ||' Successfully');
349:
350: oe_debug_pub.add('Generated PACKAGE '||p_pkg_type ||' :'||l_new_pkg_name ||' Successfully');
351: -- 13638721
352: IF (L_MAINT_DYN_SRC_VER='Y') THEN
353:
354: IF (l_insert_row = 'N') THEN

Line 358: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));

354: IF (l_insert_row = 'N') THEN
355:
356: PUT_LINE('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
357:
358: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
359: UPDATE qp_parameters_b
360: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,

Line 375: oe_debug_pub.add('found row in qp_params but no row updated so insert: ');

371: 'N','1',SYSDATE,
372: -1,SYSDATE,-1,-1);
373: PUT_LINE('found row in qp_params but no row updated so insert: ' );
374:
375: oe_debug_pub.add('found row in qp_params but no row updated so insert: ');
376: END IF;
377: ELSE
378: PUT_LINE('insert row flag is Y ' );
379:

Line 380: oe_debug_pub.add('insert row flag is Y ');

376: END IF;
377: ELSE
378: PUT_LINE('insert row flag is Y ' );
379:
380: oe_debug_pub.add('insert row flag is Y ');
381: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,
382: ADVANCED_PRICING_ONLY,SEEDED_VALUE,CREATION_DATE,CREATED_BY,
383: LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
384: VALUES (-8888,'CONC','BLD_FORMULA_ACTV_VER',-8888,

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

498: l_formula_String_f varchar2(32000):=' '; -- modified by rassharm 5713302
499:
500: BEGIN
501:
502: oe_debug_pub.add('##### Begin Build Formulas #####');
503:
504: Init_Applsys_Schema;
505:
506: -- Writing out the body

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

687: Text(' THEN', 2);
688: Text('IF p_procedure_type != ''S'' THEN', 3); --sfiresto
689: New_Line;
690: IF l_category = 'EXPRESSION' THEN
691: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
692: Break_Text('x_formula_value := ' || l_new_formula, 4);
693: Text('x_return_status := ''S''' || ';',4);
694: --dbms_output.put_line('IN EXPRESSION ');
695: ELSIF l_category = 'PLSQL' THEN

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

692: Break_Text('x_formula_value := ' || l_new_formula, 4);
693: Text('x_return_status := ''S''' || ';',4);
694: --dbms_output.put_line('IN EXPRESSION ');
695: ELSIF l_category = 'PLSQL' THEN
696: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
697: l_select_stmt := 'SELECT '|| l_new_formula || ' INTO x_formula_value FROM DUAL';
698: Break_Text(l_select_stmt, 4);
699: Text('x_return_status := ''S''' || ';',4);
700: --dbms_output.put_line('IN PLSQL ');

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

698: Break_Text(l_select_stmt, 4);
699: Text('x_return_status := ''S''' || ';',4);
700: --dbms_output.put_line('IN PLSQL ');
701: ELSIF l_category = 'SQL' THEN
702: --Break_Text('oe_debug_pub.add(''Formula - ' || l_new_formula || ''')',4);
703: --select replace(l_temp_new_formula,'''','''''') into l_temp_new_formula from dual;--6726052,7249280 smbalara:commented for 8348005
704: l_select_stmt := 'EXECUTE IMMEDIATE '' SELECT '|| l_temp_new_formula || ' FROM DUAL '' INTO x_formula_value using ' || l_using_clause;
705: Break_Text(l_select_stmt, 4);
706: Text('x_return_status := ''S''' || ';',4);

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

721: New_Line;
722: Text('EXCEPTION',1);
723: Text('WHEN OTHERS THEN',2);
724: Text('x_return_status := ''E''' || ';',3);
725: Text('oe_debug_pub.add(''Error in QP_BUILD_FORMULA_RULES_TMP -''||sqlerrm)'||';');
726: Text('END' || ';',1);
727: Text('END Get_Formula_Values;',0);
728: New_Line;
729:

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

732: FND_MESSAGE.SET_NAME('QP','QP_BUILD_FORMULAS_SUCCESS');
733: err_buff := FND_MESSAGE.GET;
734: PUT_LINE(err_buff);
735: retcode := 0;
736: oe_debug_pub.add('##### ' || err_buff || ' #####');
737: oe_debug_pub.add('##### End Build Formulas #####');
738:
739: EXCEPTION
740:

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

733: err_buff := FND_MESSAGE.GET;
734: PUT_LINE(err_buff);
735: retcode := 0;
736: oe_debug_pub.add('##### ' || err_buff || ' #####');
737: oe_debug_pub.add('##### End Build Formulas #####');
738:
739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN

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

745: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
748: retcode := 2;
749: oe_debug_pub.add('##### ' || err_buff || ' #####');
750: oe_debug_pub.add('##### End Build Formulas #####');
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');

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

746: err_buff := FND_MESSAGE.GET;
747: PUT_LINE(err_buff);
748: retcode := 2;
749: oe_debug_pub.add('##### ' || err_buff || ' #####');
750: oe_debug_pub.add('##### End Build Formulas #####');
751:
752: WHEN OTHERS THEN
753: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
754: FND_MESSAGE.SET_TOKEN('PACKAGE_TYPE','BODY');

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

756: FND_MESSAGE.SET_TOKEN('ERRMSG',substr(SQLERRM,1,150));
757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
759: retcode := 2;
760: oe_debug_pub.add('##### ' || err_buff || ' #####');
761: oe_debug_pub.add('##### End Build Formulas #####');
762:
763: END FORMULAS;
764:

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

757: err_buff := FND_MESSAGE.GET;
758: PUT_LINE(err_buff);
759: retcode := 2;
760: oe_debug_pub.add('##### ' || err_buff || ' #####');
761: oe_debug_pub.add('##### End Build Formulas #####');
762:
763: END FORMULAS;
764:
765: END QP_FORMULA_RULES_PVT;