1: PACKAGE BODY HR_KPI as
2: /* $Header: hrkpi02.pkb 120.0.12010000.1 2008/07/28 03:27:59 appldev ship $ */
3:
4:
5: -- AOL logging info
78: pragma autonomous_transaction ;
79: l_result varchar2(2000);
80: begin
81:
82: debug_start(l_module_name||'hr_kpi','request');
83: debug_text(l_module_name||'hr_kpi','request','context =' || context||'session_id='||sid);
84: debug_text(l_module_name||'hr_kpi','request','cookie =' || cookie);
85:
86: l_result := request_pvt('&'||context, cookie,sid);
79: l_result varchar2(2000);
80: begin
81:
82: debug_start(l_module_name||'hr_kpi','request');
83: debug_text(l_module_name||'hr_kpi','request','context =' || context||'session_id='||sid);
84: debug_text(l_module_name||'hr_kpi','request','cookie =' || cookie);
85:
86: l_result := request_pvt('&'||context, cookie,sid);
87:
80: begin
81:
82: debug_start(l_module_name||'hr_kpi','request');
83: debug_text(l_module_name||'hr_kpi','request','context =' || context||'session_id='||sid);
84: debug_text(l_module_name||'hr_kpi','request','cookie =' || cookie);
85:
86: l_result := request_pvt('&'||context, cookie,sid);
87:
88: if l_result is null then
89: l_result := 'type=ERROR' || '&' || 'sub=' || '&' ||
90: 'value=A null response was received from the servlet';
91: end if;
92:
93: debug_end(l_module_name||'hr_kpi','request');
94:
95: return(l_result);
96: end ;
97:
116:
117: exception when others
118: then
119: --null;
120: debug_exception(routine=>l_module_name||'.'||'hr_kpi'||'parseResponse_pvt' ,
121: errcode=>null,
122: errmsg=> 'error occured in parseResponse_pvt' ) ;
123: end parseResponse;
124:
137: end if;
138:
139: end ;
140:
141: end hr_kpi;