APPS.IRC_JPS_GENERATOR dependencies on IRC_XML_UTIL

Line 345: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);

341: begin
342: hr_utility.set_location('Getting stylesheet from URL',15);
343:
344: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||userenv('LANG')||'/'||p_stylesheet;
345: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
346:
347: if instr(lower(tv_sheet(1)),'1 then
348: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||p_stylesheet;
349: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);

Line 349: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);

345: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
346:
347: if instr(lower(tv_sheet(1)),'1 then
348: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||p_stylesheet;
349: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
350: end if;
351: hr_utility.set_location('Got the stylesheet from the URL',16);
352:
353: exception when others then

Line 358: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);

354: hr_utility.set_location('Exception occured while getting stylesheet',17);
355: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),18);
356: hr_utility.set_location('Exception: '||sqlcode,19);
357: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||p_stylesheet;
358: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
359: end;
360: lv_stylesheet:='';
361: for l_index in 1..tv_sheet.count loop
362: lv_stylesheet:=lv_stylesheet||tv_sheet(l_index);