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.BIV_CORE_PKG dependencies on BIV_DEBUG

Line 28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);

24: g_param_sep,
25: g_value_sep);
26:
27: /*
28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);
29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||
30: '---->' || nvl(l_value_str,'NULL'),g_report_id);
31: commit;
32: */

Line 29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||

25: g_value_sep);
26:
27: /*
28: biv_core_pkg.biv_debug('Param:'||p_param_str,g_report_id);
29: biv_core_pkg.biv_debug( 'Values String for Param:'||p_param_name ||
30: '---->' || nvl(l_value_str,'NULL'),g_report_id);
31: commit;
32: */
33: if (nvl(l_value_str,'NOT_FOUND') <> 'NOT_FOUND' ) then

Line 37: biv_core_pkg.biv_debug('Total Value for :'||p_param_name ||

33: if (nvl(l_value_str,'NOT_FOUND') <> 'NOT_FOUND' ) then
34: p_total_values := jtfb_dcf.get_multiselect_count(l_value_str,
35: g_multi_value_sep);
36: /***
37: biv_core_pkg.biv_debug('Total Value for :'||p_param_name ||
38: ' : ' ||to_char(p_total_values),g_report_id);
39: ****/
40: if (p_total_values > 100) then
41: --dbms_output.put_line('Two Many Values for :'|| p_param_name);

Line 43: biv_core_pkg.biv_debug('Too many values for :'||p_param_name ||

39: ****/
40: if (p_total_values > 100) then
41: --dbms_output.put_line('Two Many Values for :'|| p_param_name);
42: if (g_debug = 'Y') then
43: biv_core_pkg.biv_debug('Too many values for :'||p_param_name ||
44: ' : ' ||to_char(p_total_values),g_report_id);
45: end if;
46: else
47: for i in 1..p_total_values loop

Line 94: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');

90: ************************************/
91: procedure prt_parameter_values(p_param_values in out nocopy g_parameter_array,
92: p_total_values in out nocopy number) as
93: i number;
94: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
95: begin
96: i := 0;
97: loop
98: i := i + 1;

Line 107: biv_core_pkg.biv_debug ('Parameter value at index:'||

103: p_param_values(i)
104: );
105: */
106: if (l_debug = 'Y') then
107: biv_core_pkg.biv_debug ('Parameter value at index:'||
108: to_char(i) || ' is:'||
109: p_param_values(i), g_report_id
110: );
111: end if;

Line 114: procedure biv_debug(p_msg varchar2,

110: );
111: end if;
112: end loop;
113: end;
114: procedure biv_debug(p_msg varchar2,
115: p_report varchar2) is
116: l_msg varchar2(4000);
117: q_msg varchar2(6000);
118: begin

Line 122: insert into biv_debug(report_id,message,creation_date,session_id,seq_no)

118: begin
119: --if (nvl(g_debug,'N') = 'Y' ) then
120: q_msg := replace(p_msg,g_local_chr,'
');
121: l_msg := substr(q_msg,1,4000);
122: insert into biv_debug(report_id,message,creation_date,session_id,seq_no)
123: values(p_report,l_msg,sysdate,get_session_id, g_srl_no);
124: g_srl_no := g_srl_no + 1;
125: if (length(q_msg) > 4000) then
126: l_msg := substr(q_msg,4001,4000);

Line 127: insert into biv_debug(report_id,message,creation_date,

123: values(p_report,l_msg,sysdate,get_session_id, g_srl_no);
124: g_srl_no := g_srl_no + 1;
125: if (length(q_msg) > 4000) then
126: l_msg := substr(q_msg,4001,4000);
127: insert into biv_debug(report_id,message,creation_date,
128: session_id,seq_no)
129: values(p_report,l_msg,sysdate,get_session_id, g_srl_no);
130: g_srl_no := g_srl_no + 1;
131: end if;

Line 134: insert into biv_debug(report_id,message,creation_date,

130: g_srl_no := g_srl_no + 1;
131: end if;
132: if (length(q_msg) > 8000) then
133: l_msg := substr(q_msg,8001,4000);
134: insert into biv_debug(report_id,message,creation_date,
135: session_id,seq_no)
136: values(p_report,l_msg,sysdate,get_session_id, g_srl_no);
137: g_srl_no := g_srl_no + 1;
138: end if;

Line 141: end biv_debug;

137: g_srl_no := g_srl_no + 1;
138: end if;
139: commit;
140: -- end if;
141: end biv_debug;
142: -------------------------
143: function get_parameter_value(p_param_str varchar2,
144: p_param_name varchar2,
145: p_param_end_pos in out nocopy number,

Line 279: biv_core_pkg.biv_debug('Saturday in nls Lang:' || l_sat, g_report_id);

275: l_sat varchar2(80);
276: begin
277: l_sat := to_char(to_date('01/01/2000','dd/mm/yyyy'),'dy');
278: if (g_debug = 'Y') then
279: biv_core_pkg.biv_debug('Saturday in nls Lang:' || l_sat, g_report_id);
280: end if;
281: x_date := next_day(sysdate,l_sat) - 13;
282: x_start_date := to_date(to_char(x_date,'dd-mon-yyyy') || ' 00:00:00',
283: 'dd-mon-yyyy hh24:mi:ss');

Line 320: g_debug := fnd_profile.value('BIV:DEBUG');

316: procedure get_report_parameters(p_param_str varchar2) as
317: l_dt varchar2(30);
318: l_dt_fmt varchar2(30) := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
319: begin
320: g_debug := fnd_profile.value('BIV:DEBUG');
321: g_cust_id_cnt := 0;
322: g_cntr_id_cnt := 0;
323: g_ogrp_cnt := 0;
324: g_agrp_cnt := 0;

Line 333: g_debug := fnd_profile.value('BIV:DEBUG');

329: g_comp_id_cnt := 0;
330: g_subcomp_id_cnt := 0;
331: g_platform_id_cnt := 0;
332: g_sts_id_cnt := 0;
333: g_debug := fnd_profile.value('BIV:DEBUG');
334: --g_srl_no := 1;
335: biv_core_pkg.get_parameter_values_all(g_cust_id ,
336: g_cust_id_cnt ,
337: p_param_str ,

Line 471: biv_core_pkg.biv_debug('No default view by for the report '||

467: 'BIV_HS_SR_ESCALATION', 'BIV_RT_TASK_ACTIVITY')
468: )then
469: g_view_by := 'MGR';
470: elsif (g_debug = 'Y') then
471: biv_core_pkg.biv_debug('No default view by for the report '||
472: g_report_id, g_report_id);
473: end if;
474: end if;
475: if (g_debug = 'Y') then

Line 476: biv_core_pkg.biv_debug('Report Id:'||g_report_id,g_report_id);

472: g_report_id, g_report_id);
473: end if;
474: end if;
475: if (g_debug = 'Y') then
476: biv_core_pkg.biv_debug('Report Id:'||g_report_id,g_report_id);
477: end if;
478: g_disp := biv_core_pkg.get_parameter_value(p_param_str,'P_DISP');
479: if (g_disp is null) then
480: g_disp := 10;

Line 545: biv_debug('Error:'||substr(sqlerrm,1,200), g_report_id);

541: end if;
542: exception
543: when others then
544: if (g_debug = 'Y' ) then
545: biv_debug('Error:'||substr(sqlerrm,1,200), g_report_id);
546: end if;
547: end;
548: ------------------------------------------------------------
549: procedure add_a_bind(p_cursor number,

Line 1367: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql, g_report_id);

1363: set col2 = col1
1364: where session_id = :session_id' ;
1365: end if;
1366: if (g_debug = 'Y') then
1367: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql, g_report_id);
1368: end if;
1369: commit;
1370: if (l_sql is null) then
1371: if (g_debug = 'Y') then

Line 1372: biv_core_pkg.biv_debug('Invalid Value for P_VIEW parameter:'||g_view_by,

1368: end if;
1369: commit;
1370: if (l_sql is null) then
1371: if (g_debug = 'Y') then
1372: biv_core_pkg.biv_debug('Invalid Value for P_VIEW parameter:'||g_view_by,
1373: g_report_id);
1374: end if;
1375: else
1376: execute immediate l_sql using l_session_id;

Line 1384: biv_core_pkg.biv_debug('SQL for NULLL Description:'||l_sql, g_report_id);

1380: set col2 = :null_desc
1381: where col2 is null
1382: and session_id = :session_id';
1383: if (g_debug = 'Y') then
1384: biv_core_pkg.biv_debug('SQL for NULLL Description:'||l_sql, g_report_id);
1385: end if;
1386: execute immediate l_sql using l_null_desc, l_session_id;
1387:
1388: exception

Line 1392: biv_core_pkg.biv_debug(l_err,g_report_id);

1388: exception
1389: when others then
1390: if (g_debug = 'Y') then
1391: l_err := 'Err in update_base_col:' ||substr(sqlerrm,1,200);
1392: biv_core_pkg.biv_debug(l_err,g_report_id);
1393: biv_core_pkg.biv_debug(l_sql,g_report_id);
1394: end if;
1395: end;
1396: procedure update_description(p_id_type varchar2,

Line 1393: biv_core_pkg.biv_debug(l_sql,g_report_id);

1389: when others then
1390: if (g_debug = 'Y') then
1391: l_err := 'Err in update_base_col:' ||substr(sqlerrm,1,200);
1392: biv_core_pkg.biv_debug(l_err,g_report_id);
1393: biv_core_pkg.biv_debug(l_sql,g_report_id);
1394: end if;
1395: end;
1396: procedure update_description(p_id_type varchar2,
1397: p_id_col varchar2,

Line 1454: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql_sttmnt,

1450: where session_id = :session_id';
1451: end if;
1452:
1453: if (g_debug = 'Y') then
1454: biv_core_pkg.biv_debug('SQL for updating Description:'||l_sql_sttmnt,
1455: g_report_id);
1456: end if;
1457: execute immediate l_sql_sttmnt using biv_core_pkg.get_session_id;
1458:

Line 1465: biv_core_pkg.biv_debug('SQL for updating NULL Description:'||

1461: l_sql_sttmnt := 'update ' || l_tbl || '
1462: set col2 = :nul_desc
1463: where col2 is null and session_id = :session_id';
1464: if (g_debug = 'Y') then
1465: biv_core_pkg.biv_debug('SQL for updating NULL Description:'||
1466: l_sql_sttmnt, g_report_id);
1467: end if;
1468: execute immediate l_sql_sttmnt using l_null_desc,
1469: biv_core_pkg.get_session_id;

Line 1475: biv_core_pkg.biv_debug(l_err,g_report_id);

1471: exception
1472: when others then
1473: if (g_debug = 'Y') then
1474: l_err := 'Err in update_description:' ||substr(sqlerrm,1,200);
1475: biv_core_pkg.biv_debug(l_err,g_report_id);
1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);
1477: end if;
1478: end;
1479: function are_all_parameters_null return number is

Line 1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);

1472: when others then
1473: if (g_debug = 'Y') then
1474: l_err := 'Err in update_description:' ||substr(sqlerrm,1,200);
1475: biv_core_pkg.biv_debug(l_err,g_report_id);
1476: biv_core_pkg.biv_debug(l_sql_sttmnt,g_report_id);
1477: end if;
1478: end;
1479: function are_all_parameters_null return number is
1480: begin

Line 1706: g_debug := fnd_profile.value('BIV:DEBUG');

1702: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1703: execute immediate 'delete from BIV_TMP_SR_ARRVL where
1704: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1705: end if;
1706: g_debug := fnd_profile.value('BIV:DEBUG');
1707: if (g_debug = 'Y') then
1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1709: end if;
1710: biv_core_pkg.g_srl_no := 0;

Line 1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;

1704: session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1705: end if;
1706: g_debug := fnd_profile.value('BIV:DEBUG');
1707: if (g_debug = 'Y') then
1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1709: end if;
1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

Line 1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

1708: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1709: end if;
1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;

Line 1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);

1710: biv_core_pkg.g_srl_no := 0;
1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;
1717: exception when others then
1718: rollback;

Line 1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);

1711: if (g_debug = 'Y') then
1712: biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1713: end if;
1714: -- biv_core_pkg.biv_debug('Code:'||l_code,biv_core_pkg.g_report_id);
1715: -- biv_core_pkg.biv_debug('Debug:'||g_debug,biv_core_pkg.g_report_id);
1716: commit;
1717: exception when others then
1718: rollback;
1719: if (g_debug = 'Y') then

Line 1720: biv_core_pkg.biv_debug('Error:'||substr(sqlerrm,1,200),

1716: commit;
1717: exception when others then
1718: rollback;
1719: if (g_debug = 'Y') then
1720: biv_core_pkg.biv_debug('Error:'||substr(sqlerrm,1,200),
1721: biv_core_pkg.g_report_id);
1722: end if;
1723:
1724: end clean_dcf_table;

Line 1775: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;

1771: delete from biv_tmp_hs2 where session_id = l_session_id;
1772: delete from biv_tmp_bin where session_id = l_session_id;
1773: end if;
1774: if (g_debug = 'Y') then
1775: execute immediate 'delete from biv_debug where session_id = :l_session_id or creation_date < sysdate -1 ' using l_session_id;
1776: end if;
1777: commit;
1778: end clean_region_table;
1779: -----------------------

Line 1785: biv_core_pkg.biv_debug('AA' ||p_param_str,biv_core_pkg.g_report_id);

1781: l_view_by varchar2(80);
1782: l_meaning varchar2(80);
1783: begin
1784: if (g_debug = 'Y') then
1785: biv_core_pkg.biv_debug('AA' ||p_param_str,biv_core_pkg.g_report_id);
1786: commit;
1787: end if;
1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
1789: if (g_debug = 'Y') then

Line 1790: biv_core_pkg.biv_debug('Param:'||p_param_str,'g_report_id');

1786: commit;
1787: end if;
1788: l_view_by := biv_core_pkg.get_parameter_value(p_param_str,'P_VIEW_BY');
1789: if (g_debug = 'Y') then
1790: biv_core_pkg.biv_debug('Param:'||p_param_str,'g_report_id');
1791: commit;
1792: end if;
1793: select meaning into l_meaning
1794: from fnd_lookups