414: l_job_html := l_job_html
415: || '&p_svid='||to_char(p_posting_details_tab(counter).object_id)
416: || '&p_spid='||to_char(p_posting_details_tab(counter).posting_content_id)
417: || '">'
418: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
419: || '
'
420: || fnd_global.local_chr(38)||'nbsp; '
421: || fnd_global.local_chr(38)||'nbsp;'
422: || fnd_global.local_chr(38)||'nbsp;'
416: || '&p_spid='||to_char(p_posting_details_tab(counter).posting_content_id)
417: || '">'
418: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
419: || '
'
420: || fnd_global.local_chr(38)||'nbsp; '
421: || fnd_global.local_chr(38)||'nbsp;'
422: || fnd_global.local_chr(38)||'nbsp;'
423: || fnd_global.local_chr(38)||'nbsp;'
424: || l_brief_description_v2
417: || '">'
418: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
419: || '
'
420: || fnd_global.local_chr(38)||'nbsp; '
421: || fnd_global.local_chr(38)||'nbsp;'
422: || fnd_global.local_chr(38)||'nbsp;'
423: || fnd_global.local_chr(38)||'nbsp;'
424: || l_brief_description_v2
425: || '
';
418: || replace(p_posting_details_tab(counter).name,'<',fnd_global.local_chr(38)||'lt;')
419: || '
'
420: || fnd_global.local_chr(38)||'nbsp; '
421: || fnd_global.local_chr(38)||'nbsp;'
422: || fnd_global.local_chr(38)||'nbsp;'
423: || fnd_global.local_chr(38)||'nbsp;'
424: || l_brief_description_v2
425: || '
';
426: l_return_job_html := l_job_html||l_job_html_end;
419: || '
'
420: || fnd_global.local_chr(38)||'nbsp; '
421: || fnd_global.local_chr(38)||'nbsp;'
422: || fnd_global.local_chr(38)||'nbsp;'
423: || fnd_global.local_chr(38)||'nbsp;'
424: || l_brief_description_v2
425: || '
';
426: l_return_job_html := l_job_html||l_job_html_end;
427: END LOOP;
545: else
546: l_url:=l_url||'OA_HTML/';
547: end if;
548: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
549: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
550: -- Loop through the suitable jobs and and list them.
551: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
552: || '
';
553: --
553: --
554: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
555: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
556: l_new_html:= '
'
557: || replace(ltrim(p_seeker_details_tab(counter).full_name,chr(0)),'<',fnd_global.local_chr(38)||'lt;')
558: || ''
559: || '
';
560: if(length(l_seeker_html)+length(l_new_html)<=l_max_length) then
561: l_seeker_html := l_seeker_html||l_new_html;
593: else
594: l_url:=l_url||'OA_HTML/';
595: end if;
596: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
597: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
598: -- Loop through the suitable jobs and and list them.
599: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
600: || '\n';
601: --
751: IS
752: BEGIN
753: fnd_file.put_line(which => fnd_file.log,
754: buff => p_message);
755: if fnd_global.conc_request_id <> -1 then
756: -- log is additionally written out via FND_FILE,
757: -- for visibility from view SRS window.
758: fnd_file.put_line(which => fnd_file.output,
759: buff => 'REQ'||p_message);