1: PACKAGE BODY BIV_HS_PROB_AVOID_REPORT_PKG AS
2: -- $Header: bivhprob.pls 115.23 2004/01/23 04:55:17 vganeshk ship $ */
3: -- Problem Avoidence Report
4: -- global params
5: g_err VARCHAR2(500);
169: end if;
170: EXCEPTION
171: WHEN OTHERS THEN
172: if (g_debug_flag = 'Y') then
173: g_err := 'Err in BIV_HS_PROB_AVOID_REPORT_PKG. ' ||
174: 'load_prob_avoid_rpt:' || substr(sqlerrm,1,500);
175: biv_core_pkg.biv_debug(g_err,'BIV_HS_PROB_AVOID');
176: end if;
177:
310: and session_id = g_session_id;
311: EXCEPTION
312: WHEN OTHERS THEN
313: if (g_debug_flag = 'Y') then
314: g_err := 'Err in BIV_HS_PROB_AVOID_REPORT_PKG.' ||
315: 'load_prob_avoid_res_rpt:' || substr(sqlerrm,1,500);
316: biv_core_pkg.biv_debug(g_err,'BIV_HS_PROB_AVOID_RES');
317: end if;
318:
358:
359:
360: return l_where_stmt;
361: END get_prob_avoid_res_rpt_where;
362: END BIV_HS_PROB_AVOID_REPORT_PKG;