DBA Data[Home] [Help]

APPS.IRC_JPS_GENERATOR dependencies on FND_PROFILE

Line 342: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||userenv('LANG')||'/'||p_stylesheet;

338:
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);

Line 345: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||p_stylesheet;

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;
348: hr_utility.set_location('Got the stylesheet from the URL',16);
349:

Line 354: l_stylesheet_url:=rtrim(fnd_profile.value('APPS_FRAMEWORK_AGENT'),'/')||'/OA_HTML/'||p_stylesheet;

350: exception when others then
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

Line 376: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then

372: hr_utility.set_location('Entering Parsing section',23);
373: parser:=xmlparser.newparser;
374:
375: hr_utility.set_location('Setting encoding',231);
376: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then
377: clobdoc := replace(clobdoc, '?>', ' encoding = '''||fnd_profile.value('ICX_CLIENT_IANA_ENCODING')||'''?>');
378: end if;
379: hr_utility.set_location('Exiting after setting encoding',233);
380:

Line 377: clobdoc := replace(clobdoc, '?>', ' encoding = '''||fnd_profile.value('ICX_CLIENT_IANA_ENCODING')||'''?>');

373: parser:=xmlparser.newparser;
374:
375: hr_utility.set_location('Setting encoding',231);
376: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then
377: clobdoc := replace(clobdoc, '?>', ' encoding = '''||fnd_profile.value('ICX_CLIENT_IANA_ENCODING')||'''?>');
378: end if;
379: hr_utility.set_location('Exiting after setting encoding',233);
380:
381: xmlparser.parseCLOB(parser,clobdoc);