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.ZPB_UTIL_PVT dependencies on ZPB_LOG

Line 23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);

19: -- call the first query
20: zpb_aw_status.get_status(p_dataAw,p_first_query);
21: -- get the valuseset name
22: l_vs := '&' || 'obj(prp ''LASTQUERYVS'' '||''''||l_dataAwQual||p_line_dim ||''')';
23: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'valueset name:' ||l_vs);
24: -- initialize
25: zpb_aw.execute('push oknullstatus '||l_dataAwQual ||p_line_dim);
26: zpb_aw.execute('oknullstatus=y');
27: if (not zpb_aw.interpbool('shw exists(''l_temp_vs'')')) then

Line 36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));

32: zpb_aw.execute('lmt '|| l_dataAwQual ||'l_temp_vs to '|| l_vs );
33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');

Line 37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));

33:
34: -- generate the valuseset for the second query
35: zpb_aw_status.get_status(p_dataAw,p_second_query);
36: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_dataAwQual ||'l_temp_vs)'),1,254));
37: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,substr(zpb_aw.interp('rpr w 40 values('||l_vs||')'),1,254));
38:
39: -- check if the two valusesets are identical
40: l_first_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||'l_temp_vs)'|| ' values('||l_vs||'))');
41: l_second_superset := zpb_aw.interpbool('shw inlist(values('||l_dataAwQual||l_vs||')'|| ' values(l_temp_vs))');

Line 61: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90)

57: return l_equal;
58: exception
59: when others then
60: l_equal := 0;
61: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90)
62: );
63: return l_equal;
64: end;
65:

Line 82: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'Dimension:' ||l_dataAwQual|| p_dim_name);

78: l_dataAwQual := l_dataAw ||'!';
79: zpb_aw.execute('aw attach '|| l_dataAw || ' first ');
80: zpb_aw.execute('aw attach '|| zpb_aw.get_schema||'.'||zpb_aw.get_code_aw(fnd_global.user_id) || ' ro');
81:
82: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'Dimension:' ||l_dataAwQual|| p_dim_name);
83:
84: x_equal := compare_queries(l_dataAw,p_first_query,p_second_query,p_dim_name);
85: -- cleanup and return
86: zpb_aw.execute('delete l_temp_vs aw ' ||l_dataAw);

Line 94: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

90:
91: exception
92: when others then
93: x_equal := 0;
94: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
95:
96: end compare_dim_members;
97:
98:

Line 410: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'executed ' ||l_call);

406: l_call := l_callbase || l_callnumber;
407:
408: if l_callnumber is not null then
409: execute immediate l_call;
410: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'executed ' ||l_call);
411: end if;
412:
413: exception
414: when others then

Line 415: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

411: end if;
412:
413: exception
414: when others then
415: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
416: end set_opps;
417:
418: -- This function returns the current olap page pool size
419: function get_opps return number is

Line 431: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

427: return to_number(return_val);
428:
429: exception
430: when others then
431: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
432: return to_number(return_val);
433: end get_opps;
434:
435: procedure set_opps_spec(setting in number) is

Line 444: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'executed ' ||l_call);

440: if setting is not null then
441: l_callbase := 'alter session set olap_page_pool_size=';
442: l_call := l_callbase || to_char(setting);
443: execute immediate l_call;
444: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'executed ' ||l_call);
445: end if;
446: exception
447: when others then
448: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

Line 448: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));

444: zpb_log.write_statement(G_PKG_NAME||'.'||l_api_name,'executed ' ||l_call);
445: end if;
446: exception
447: when others then
448: zpb_log.write_event(G_PKG_NAME,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
449: end set_opps_spec;
450:
451: procedure exec_ddl(p_cmd varchar2) is
452: