APPS.IRC_JPS_GENERATOR dependencies on IRC_XML_UTIL

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

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

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

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

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

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