eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_JPS_GENERATOR dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering: generateJPSinit',10);

20: tv_sheet utl_http.html_pieces;
21: l_index number;
22: begin
23:
24: hr_utility.set_location('Entering: generateJPSinit',10);
25: l_query:= 'select per.*'
26: ||' ,per.full_name personname'
27: ||' ,per.last_name personlastname'
28: ||' ,decode(per.sex, ''M'',''1'',''F'',''2'',''9'') gender'

Line 186: hr_utility.set_location('Formed the query to retrieve data',11);

182: ||' and per.person_type_id=ppttl.person_type_id'
183: ||' and ppttl.language=userenv(''LANG'')'
184: ||' and rownum=1';
185:
186: hr_utility.set_location('Formed the query to retrieve data',11);
187:
188: if (p_stylesheet is null) then
189:
190: hr_utility.set_location('Stylesheet is null',12);

Line 190: hr_utility.set_location('Stylesheet is null',12);

186: hr_utility.set_location('Formed the query to retrieve data',11);
187:
188: if (p_stylesheet is null) then
189:
190: hr_utility.set_location('Stylesheet is null',12);
191:
192: lv_stylesheet:=''||
193: ''||
194: ''||

Line 335: hr_utility.set_location('Created the stylesheet',13);

331: '||'
332:
333:
334: ';
335: hr_utility.set_location('Created the stylesheet',13);
336:
337: else
338: if (p_stylesheet_content is not null) then
339: lv_stylesheet:=p_stylesheet_content;

Line 342: hr_utility.set_location('Getting stylesheet from URL',15);

338: if (p_stylesheet_content is not null) then
339: lv_stylesheet:=p_stylesheet_content;
340: else
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:

Line 351: hr_utility.set_location('Got the stylesheet from the URL',16);

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
354: hr_utility.set_location('Exception occured while getting stylesheet',17);
355: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),18);

Line 354: hr_utility.set_location('Exception occured while getting stylesheet',17);

350: end if;
351: hr_utility.set_location('Got the stylesheet from the URL',16);
352:
353: exception when others then
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);

Line 355: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),18);

351: hr_utility.set_location('Got the stylesheet from the URL',16);
352:
353: exception when others then
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;

Line 356: hr_utility.set_location('Exception: '||sqlcode,19);

352:
353: exception when others then
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:='';

Line 364: hr_utility.set_location('Created the Stylesheet',20);

360: lv_stylesheet:='';
361: for l_index in 1..tv_sheet.count loop
362: lv_stylesheet:=lv_stylesheet||tv_sheet(l_index);
363: end loop;
364: hr_utility.set_location('Created the Stylesheet',20);
365: end if;
366: end if;
367:
368: hr_utility.set_location('Executing the query',21);

Line 368: hr_utility.set_location('Executing the query',21);

364: hr_utility.set_location('Created the Stylesheet',20);
365: end if;
366: end if;
367:
368: hr_utility.set_location('Executing the query',21);
369: ctx:= dbms_xmlquery.newContext(l_query);
370: dbms_xmlquery.setBindValue(ctx,'1',p_person_id);
371: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
372: dbms_xmlquery.setRowsetTag(ctx,'jobpositionseeker');

Line 374: hr_utility.set_location('Retrieved the XML data',22);

370: dbms_xmlquery.setBindValue(ctx,'1',p_person_id);
371: dbms_xmlquery.setTagCase(ctx,dbms_xmlquery.LOWER_CASE);
372: dbms_xmlquery.setRowsetTag(ctx,'jobpositionseeker');
373: clobdoc:=dbms_xmlquery.getXML(ctx);
374: hr_utility.set_location('Retrieved the XML data',22);
375: dbms_xmlquery.closeContext(ctx);
376: dbms_lob.createTemporary(l_formatted_doc,false,dbms_lob.call);
377: hr_utility.set_location('Entering Parsing section',23);
378: parser:=xmlparser.newparser;

Line 377: hr_utility.set_location('Entering Parsing section',23);

373: clobdoc:=dbms_xmlquery.getXML(ctx);
374: hr_utility.set_location('Retrieved the XML data',22);
375: dbms_xmlquery.closeContext(ctx);
376: dbms_lob.createTemporary(l_formatted_doc,false,dbms_lob.call);
377: hr_utility.set_location('Entering Parsing section',23);
378: parser:=xmlparser.newparser;
379:
380: hr_utility.set_location('Setting encoding',231);
381: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then

Line 380: hr_utility.set_location('Setting encoding',231);

376: dbms_lob.createTemporary(l_formatted_doc,false,dbms_lob.call);
377: hr_utility.set_location('Entering Parsing section',23);
378: parser:=xmlparser.newparser;
379:
380: hr_utility.set_location('Setting encoding',231);
381: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then
382: clobdoc := replace(clobdoc, '?>', ' encoding = '''||fnd_profile.value('ICX_CLIENT_IANA_ENCODING')||'''?>');
383: end if;
384: hr_utility.set_location('Exiting after setting encoding',233);

Line 384: hr_utility.set_location('Exiting after setting encoding',233);

380: hr_utility.set_location('Setting encoding',231);
381: if(fnd_profile.value('ICX_CLIENT_IANA_ENCODING') <> '') then
382: clobdoc := replace(clobdoc, '?>', ' encoding = '''||fnd_profile.value('ICX_CLIENT_IANA_ENCODING')||'''?>');
383: end if;
384: hr_utility.set_location('Exiting after setting encoding',233);
385:
386: xmlparser.parseCLOB(parser,clobdoc);
387: xmldoc:=xmlparser.getDocument(parser);
388: engine:=xslprocessor.newProcessor;

Line 392: hr_utility.set_location('Parsing the stylesheet',24);

388: engine:=xslprocessor.newProcessor;
389: xmlparser.parseBuffer(parser,lv_stylesheet);
390: stylesheetdoc:=xmlparser.getDocument(parser);
391: stylesheet:=xslprocessor.newStylesheet(stylesheetdoc,null);
392: hr_utility.set_location('Parsing the stylesheet',24);
393: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_formatted_doc);
394: hr_utility.set_location('Parsing Sucess. Freeing parser',25);
395: xslprocessor.freeStylesheet(stylesheet);
396: xmldom.freeDocument(stylesheetdoc);

Line 394: hr_utility.set_location('Parsing Sucess. Freeing parser',25);

390: stylesheetdoc:=xmlparser.getDocument(parser);
391: stylesheet:=xslprocessor.newStylesheet(stylesheetdoc,null);
392: hr_utility.set_location('Parsing the stylesheet',24);
393: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_formatted_doc);
394: hr_utility.set_location('Parsing Sucess. Freeing parser',25);
395: xslprocessor.freeStylesheet(stylesheet);
396: xmldom.freeDocument(stylesheetdoc);
397: xmlParser.freeParser(parser);
398: xslprocessor.freeProcessor(engine);

Line 409: hr_utility.set_location('Generation successful',26);

405: end if;
406:
407: p_formatted_doc:=l_formatted_doc;
408: -- p_formatted_doc:=clobdoc;
409: hr_utility.set_location('Generation successful',26);
410: exception when others then
411: hr_utility.set_location('Exception occured',27);
412: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),28);
413: hr_utility.set_location('Exception: '||sqlcode,29);

Line 411: hr_utility.set_location('Exception occured',27);

407: p_formatted_doc:=l_formatted_doc;
408: -- p_formatted_doc:=clobdoc;
409: hr_utility.set_location('Generation successful',26);
410: exception when others then
411: hr_utility.set_location('Exception occured',27);
412: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),28);
413: hr_utility.set_location('Exception: '||sqlcode,29);
414: xmlParser.freeParser(parser);
415: xslprocessor.freeProcessor(engine);

Line 412: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),28);

408: -- p_formatted_doc:=clobdoc;
409: hr_utility.set_location('Generation successful',26);
410: exception when others then
411: hr_utility.set_location('Exception occured',27);
412: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),28);
413: hr_utility.set_location('Exception: '||sqlcode,29);
414: xmlParser.freeParser(parser);
415: xslprocessor.freeProcessor(engine);
416: xslprocessor.freeStylesheet(stylesheet);

Line 413: hr_utility.set_location('Exception: '||sqlcode,29);

409: hr_utility.set_location('Generation successful',26);
410: exception when others then
411: hr_utility.set_location('Exception occured',27);
412: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),28);
413: hr_utility.set_location('Exception: '||sqlcode,29);
414: xmlParser.freeParser(parser);
415: xslprocessor.freeProcessor(engine);
416: xslprocessor.freeStylesheet(stylesheet);
417: xmldom.freeDocument(xmldoc);

Line 429: hr_utility.set_location('Entering generateJPS',10);

425: l_dummy_doc CLOB;
426: l_formatted_doc CLOB;
427: l_stylesheet varchar2(240);
428: begin
429: hr_utility.set_location('Entering generateJPS',10);
430: if (p_stylesheet is not null) then
431: hr_utility.set_location('Stylesheet not null',11);
432: l_stylesheet:=p_stylesheet||'.xsl';
433: hr_utility.set_location('Calling generateJPSint with stylesheet',12);

Line 431: hr_utility.set_location('Stylesheet not null',11);

427: l_stylesheet varchar2(240);
428: begin
429: hr_utility.set_location('Entering generateJPS',10);
430: if (p_stylesheet is not null) then
431: hr_utility.set_location('Stylesheet not null',11);
432: l_stylesheet:=p_stylesheet||'.xsl';
433: hr_utility.set_location('Calling generateJPSint with stylesheet',12);
434: generateJPSint(p_person_id=>p_person_id
435: ,p_stylesheet=>l_stylesheet

Line 433: hr_utility.set_location('Calling generateJPSint with stylesheet',12);

429: hr_utility.set_location('Entering generateJPS',10);
430: if (p_stylesheet is not null) then
431: hr_utility.set_location('Stylesheet not null',11);
432: l_stylesheet:=p_stylesheet||'.xsl';
433: hr_utility.set_location('Calling generateJPSint with stylesheet',12);
434: generateJPSint(p_person_id=>p_person_id
435: ,p_stylesheet=>l_stylesheet
436: ,p_raw_doc=>l_dummy_doc
437: ,p_formatted_doc=>l_formatted_doc

Line 440: hr_utility.set_location('Calling generateJPSint without stylesheet',12);

436: ,p_raw_doc=>l_dummy_doc
437: ,p_formatted_doc=>l_formatted_doc
438: ,p_stylesheet_content=>p_stylesheet_content);
439: else
440: hr_utility.set_location('Calling generateJPSint without stylesheet',12);
441: generateJPSint(p_person_id=>p_person_id
442: ,p_raw_doc=>l_dummy_doc
443: ,p_formatted_doc=>l_formatted_doc);
444: end if;

Line 452: hr_utility.set_location('Entering show_resume',10);

448: procedure show_resume(p number,s varchar2) is
449: --
450: l_result CLOB;
451: begin
452: hr_utility.set_location('Entering show_resume',10);
453: l_result:=generateJPS(p,s);
454: htp.p(dbms_lob.substr(l_result));
455: exception
456: when others then

Line 457: hr_utility.set_location('Exception occured',20);

453: l_result:=generateJPS(p,s);
454: htp.p(dbms_lob.substr(l_result));
455: exception
456: when others then
457: hr_utility.set_location('Exception occured',20);
458: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
459: hr_utility.set_location('Exception: '||sqlcode,40);
460: htp.p(dbms_utility.format_error_stack);
461: end show_resume;

Line 458: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);

454: htp.p(dbms_lob.substr(l_result));
455: exception
456: when others then
457: hr_utility.set_location('Exception occured',20);
458: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
459: hr_utility.set_location('Exception: '||sqlcode,40);
460: htp.p(dbms_utility.format_error_stack);
461: end show_resume;
462: --

Line 459: hr_utility.set_location('Exception: '||sqlcode,40);

455: exception
456: when others then
457: hr_utility.set_location('Exception occured',20);
458: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
459: hr_utility.set_location('Exception: '||sqlcode,40);
460: htp.p(dbms_utility.format_error_stack);
461: end show_resume;
462: --
463: procedure save_candidate_resume(p_person_id in number

Line 508: hr_utility.set_location('Entering save_candidate_resume',10);

504: Begin
505: --
506: hr_multi_message.enable_message_list;
507: --
508: hr_utility.set_location('Entering save_candidate_resume',10);
509: open get_doc_name;
510: fetch get_doc_name into l_file_name;
511: close get_doc_name;
512: if l_file_name is null then

Line 525: hr_utility.set_location('Getting stylesheet',11);

521: fnd_message.set_token('STYLE',l_meaning);
522: l_description:=substrb(fnd_message.get,1,240);
523: fnd_message.clear;
524: --
525: hr_utility.set_location('Getting stylesheet',11);
526: l_stylesheet:=p_stylesheet||'.xsl';
527: generateJPSint(p_person_id=>p_person_id
528: ,p_stylesheet=>l_stylesheet
529: ,p_raw_doc =>l_parsed_xml

Line 582: hr_utility.set_location('Saved resume',12);

578: where document_id=l_document_id;
579: end if;
580: irc_document_api.process_document(l_document_id);
581: --
582: hr_utility.set_location('Saved resume',12);
583: exception
584: when others then
585: hr_utility.set_location('Exception occured',20);
586: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);

Line 585: hr_utility.set_location('Exception occured',20);

581: --
582: hr_utility.set_location('Saved resume',12);
583: exception
584: when others then
585: hr_utility.set_location('Exception occured',20);
586: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
587: hr_utility.set_location('Exception: '||sqlcode,40);
588: l_error_added := hr_multi_message.unexpected_error_add(l_proc);
589: raise;

Line 586: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);

582: hr_utility.set_location('Saved resume',12);
583: exception
584: when others then
585: hr_utility.set_location('Exception occured',20);
586: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
587: hr_utility.set_location('Exception: '||sqlcode,40);
588: l_error_added := hr_multi_message.unexpected_error_add(l_proc);
589: raise;
590: end save_candidate_resume;

Line 587: hr_utility.set_location('Exception: '||sqlcode,40);

583: exception
584: when others then
585: hr_utility.set_location('Exception occured',20);
586: hr_utility.set_location('Exception: '||substrb(sqlerrm,1,160),30);
587: hr_utility.set_location('Exception: '||sqlcode,40);
588: l_error_added := hr_multi_message.unexpected_error_add(l_proc);
589: raise;
590: end save_candidate_resume;
591: end;