31: 'Metalink). We would also appreciate your feedback regarding the usefulness of this ' ||
32: 'test,however, there will be no replies to feedback emails. ';
33: exec_id := report_context.EXEC_ID;
34: BEGIN
35: diag_com_url := FND_PROFILE.value('OAM_DIAG_COMMUNITY_URL');
36: EXCEPTION
37: WHEN OTHERS THEN
38: diag_com_url := 'https://communities.oracle.com/portal/server.pt/community/Diagnosibility/242';
39: END;
453: BEGIN
454: VALIDATE_REPORT_CONTEXT(report_context);
455: IF linkText IS NOT NULL AND note_id IS NOT NULL THEN
456: link_text_content := DBMS_XMLGEN.CONVERT(linkText,0);
457: metalink_url := FND_PROFILE.value('OAM_DIAG_METALINK_URL');
458: metalink_url := metalink_url || note_id;
459: link_url_content := DBMS_XMLGEN.CONVERT(metalink_url,0);
460: exec_id := report_context.EXEC_ID;
461: select JTF_DIAGNOSTIC_REPORT_S.nextval into ui_node_id from dual;