[Home] [Help]
79:
80: g_WebMail_PostScript_Msg varchar2(1024);
81:
82: -- Bug 10202313: global variables to store status, mail_status of WF_NOTIFICATIONS table
83: -- which will be passed as parameters to WF_MAIL.GetLOBMessage4() API
84: g_status wf_notifications.status%TYPE;
85: g_mstatus wf_notifications.mail_status%TYPE;
86:
87:
957: ** as attachments.
958: */
959: if upper(substr(l_crec.url,1, 6)) = 'PLSQL:' then
960:
961: -- wf_mail.getDocContent(p_nid, l_crec.name, l_display_type,
962: -- l_tmpcontent, l_error_result);
963: -- bug 2879507. call wf_notification.GetAttrDoc2 to get the
964: -- doc content as well as the document type
965:
984: if (l_content_type is null) then
985: l_content_type := l_display_type;
986: end if;
987: -- Derrive the name for the attachment.
988: WF_MAIL_UTIL.parseContentType(l_content_type, l_mimeType, l_filename,
989: l_extn, l_encoding);
990:
991: if l_filename is null or l_filename = '' then
992: l_filename := l_crec.display_name ||'.'||l_extn;
1032: -- Getting Content
1033: -- First we call the existing APIs to render the
1034: -- content and then we fetch the content into
1035: -- the new structure.
1036: -- Note: LOB allocated within wf_mail.getLOBDocContent API
1037: -- is released here after processing by calling
1038: -- WF_MAIL.CloseLob(l_display_type) api.
1039: begin
1040: wf_mail.getLOBDocContent(p_nid, l_crec.name, l_display_type,
1034: -- content and then we fetch the content into
1035: -- the new structure.
1036: -- Note: LOB allocated within wf_mail.getLOBDocContent API
1037: -- is released here after processing by calling
1038: -- WF_MAIL.CloseLob(l_display_type) api.
1039: begin
1040: wf_mail.getLOBDocContent(p_nid, l_crec.name, l_display_type,
1041: l_content_type, l_error_result);
1042: exception
1036: -- Note: LOB allocated within wf_mail.getLOBDocContent API
1037: -- is released here after processing by calling
1038: -- WF_MAIL.CloseLob(l_display_type) api.
1039: begin
1040: wf_mail.getLOBDocContent(p_nid, l_crec.name, l_display_type,
1041: l_content_type, l_error_result);
1042: exception
1043: when others then
1044: if (wf_log_pkg.level_error >=
1056: if (l_content_type is null) then
1057: l_content_type := l_display_type;
1058: end if;
1059: -- Derrive the name for the attachment.
1060: WF_MAIL_UTIL.parseContentType(l_content_type, l_mimeType, l_filename,
1061: l_extn, l_encoding);
1062: if l_filename is null or l_filename = '' then
1063: l_filename := l_crec.display_name ||'.'||l_extn;
1064: end if;
1097:
1098: else
1099:
1100: -- Fetch the content
1101: WF_MAIL.InitFetchLOB(l_display_type, l_doc_length);
1102: l_doc_end := 0;
1103: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1104: length(l_start), l_start);
1105: while l_doc_end = 0 loop
1102: l_doc_end := 0;
1103: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1104: length(l_start), l_start);
1105: while l_doc_end = 0 loop
1106: WF_MAIL.FetchLobContent(l_tmpContent, l_display_type,
1107: l_doc_end);
1108: l_tmpContent := replace(l_tmpContent, g_fndapi_misschr);
1109: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1110: length(l_tmpContent), l_tmpContent);
1135: l_pos := SkipLOBTag(p_doc, 'MESSAGE', l_pos, l_occurance);
1136: l_pos := SkipLOBTag(p_doc, 'BODYPART', l_pos, l_occurance);
1137: end if;
1138:
1139: -- Release temp LOB allocated within wf_mail.getLOBDocContent
1140: -- i.e. wf_mail.g_html_messageIdx or wf_mail.g_text_messageIdx Locators
1141: WF_MAIL.CloseLob(l_display_type);
1142:
1143: elsif upper(substr(l_crec.url,1, 10)) = 'PLSQLBLOB:' then
1136: l_pos := SkipLOBTag(p_doc, 'BODYPART', l_pos, l_occurance);
1137: end if;
1138:
1139: -- Release temp LOB allocated within wf_mail.getLOBDocContent
1140: -- i.e. wf_mail.g_html_messageIdx or wf_mail.g_text_messageIdx Locators
1141: WF_MAIL.CloseLob(l_display_type);
1142:
1143: elsif upper(substr(l_crec.url,1, 10)) = 'PLSQLBLOB:' then
1144: /*
1137: end if;
1138:
1139: -- Release temp LOB allocated within wf_mail.getLOBDocContent
1140: -- i.e. wf_mail.g_html_messageIdx or wf_mail.g_text_messageIdx Locators
1141: WF_MAIL.CloseLob(l_display_type);
1142:
1143: elsif upper(substr(l_crec.url,1, 10)) = 'PLSQLBLOB:' then
1144: /*
1145: ** For PLSQLBLOB documents.
1175: if (l_content_type is null) then
1176: l_content_type := l_display_type;
1177: end if;
1178: -- Derrive the name for the attachment.
1179: WF_MAIL_UTIL.parseContentType(l_content_type, l_mimeType, l_filename,
1180: l_extn, l_encoding);
1181:
1182: if l_filename is null or l_filename = '' then
1183: l_filename := l_crec.display_name ||'.'||l_extn;
1220:
1221: if l_isURLAttrs then
1222: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob,0);
1223:
1224: wf_mail.GetURLAttachment(p_nid, l_tmpContent, l_error_result);
1225: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1226: length(l_start), l_start);
1227: dbms_lob.writeAppend(g_LOBTable(l_contentIdx).temp_lob,
1228: length(l_tmpContent), l_tmpContent);
1269:
1270: return l_pos;
1271: exception
1272: when others then
1273: WF_MAIL.CloseLob(l_display_type);
1274: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1275: wf_core.context('WF_XML', 'GetAttachments', to_char(p_nid), p_agent,
1276: to_char(p_pos));
1277: l_err_message := sqlerrm;
1413:
1414: begin
1415:
1416: -- Grab the details of the message to be enqueued using the
1417: -- previous interface of WF_MAIL.GetMessage.
1418: begin
1419:
1420: select installed_flag
1421: into l_installed_lang
1433: end;
1434: dbms_session.set_nls('NLS_LANGUAGE' , l_language);
1435: dbms_session.set_nls('NLS_TERRITORY' , l_territory);
1436:
1437: wf_mail.getmessage(p_nid, p_node, p_agent, p_replyto,
1438: l_subject, l_text_body, l_html_body, l_body_atth,
1439: l_error_result);
1440: -- Check for any problems
1441: if l_error_result is not NULL then
1624:
1625: begin
1626:
1627: -- Grab the details of the message to be enqueued using the
1628: -- previous interface of WF_MAIL.GetMessage.
1629:
1630: -- Instantiate a handle to the new document.
1631: -- dbms_lob.createTemporary(l_doc, TRUE, dbms_lob.session);
1632: l_docIdx := wf_temp_lob.getLOB(g_LOBTable);
1732:
1733: begin
1734:
1735: -- Grab the details of the message to be enqueued using the
1736: -- previous interface of WF_MAIL.GetMessage.
1737:
1738: -- Instantiate a handle to the new document.
1739: p_message := '';
1740:
2528: l_start VARCHAR2(10) := '
2529: l_end VARCHAR2(4) := ']]>';
2530: begin
2531:
2532: WF_MAIL.InitFetchLOB(p_doctype, l_doc_length);
2533: l_doc_end := 0;
2534: dbms_lob.writeAppend(p_doc, length(l_start), l_start);
2535: while l_doc_end = 0 loop
2536: WF_MAIL.FetchLobContent(l_message, p_doctype, l_doc_end);
2532: WF_MAIL.InitFetchLOB(p_doctype, l_doc_length);
2533: l_doc_end := 0;
2534: dbms_lob.writeAppend(p_doc, length(l_start), l_start);
2535: while l_doc_end = 0 loop
2536: WF_MAIL.FetchLobContent(l_message, p_doctype, l_doc_end);
2537: l_message := replace(l_message, g_fndapi_misschr);
2538: dbms_lob.writeAppend(p_doc, length(l_message), l_message);
2539: end loop;
2540:
2539: end loop;
2540:
2541: -- bug 8515763:
2542: -- Adding PostScript message for Hotmail and Yahoo users here
2543: -- because if we want to add within WF_MAIL.GetMessageLob3 then new global
2544: -- variable or API have to introduce to communicate from one pkg to another pkg.
2545: if( g_WebMail_PostScript_Msg is not null ) then
2546:
2547: dbms_lob.writeAppend(p_doc,length(g_newLine), g_newLine);
2552: g_WebMail_PostScript_Msg := null;
2553: end if;
2554:
2555: dbms_lob.writeAppend(p_doc, length(l_end), l_end);
2556: WF_MAIL.CloseLob(p_doctype);
2557:
2558: exception
2559: when others then
2560: wf_core.context('WF_XML','getBodyPart',to_char(p_nid),p_doctype);
2776: attrlist.DELETE;
2777:
2778: for resourceIdx in 1..resourceList.COUNT loop
2779:
2780: encodedURL := wf_mail.urlEncode(resourceList(resourceIdx).value);
2781: AddElementAttribute('content-type', resourceList(resourceIdx).contentType, attrlist);
2782: AddElementAttribute('src', resourceList(resourceIdx).value, attrlist);
2783: AddElementAttribute('content-id', resourceList(resourceIdx).contentId, attrlist);
2784: AddElementAttribute('filename', resourceList(resourceIdx).fileName, attrlist);
2854: p_list in varchar2,
2855: p_type in varchar2,
2856: p_pos in out nocopy integer)
2857: is
2858: copy_recipient_list WF_MAIL_UTIL.parserStack_t;
2859: atPos pls_integer;
2860:
2861: display_name varchar2(360);
2862: recipient_role varchar2(320);
2881:
2882: begin
2883: step := 'Initializing the copy list';
2884: copy_recipient_list.DELETE;
2885: copy_recipient_list := WF_MAIL_UTIL.strParser(p_list, ';');
2886: if (copy_recipient_list.COUNT > 0) then
2887:
2888: for i in 1..copy_recipient_list.COUNT loop
2889:
3012: end if;
3013:
3014:
3015:
3016: wf_mail.SetResponseDelimiters(open_text => null,
3017: close_text => null,
3018: open_html => open_html_delimiter,
3019: close_html => close_html_delimiter);
3020:
3247:
3248: corrId := wf_event.getValueForParameter('Q_CORRELATION_ID',
3249: p_parameter_list);
3250: -- Obtain the values for the configurable items
3251: nodename := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3252: pCorrId => corrId,
3253: pName => 'NODENAME',
3254: pInAttr => dummy);
3255:
3252: pCorrId => corrId,
3253: pName => 'NODENAME',
3254: pInAttr => dummy);
3255:
3256: agent := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3257: pCorrId => corrId,
3258: pName => 'HTMLAGENT',
3259: pInAttr => dummy);
3260:
3257: pCorrId => corrId,
3258: pName => 'HTMLAGENT',
3259: pInAttr => dummy);
3260:
3261: fromName := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3262: pCorrId => corrId,
3263: pName => 'FROM',
3264: pInAttr => FromInAttr);
3265:
3262: pCorrId => corrId,
3263: pName => 'FROM',
3264: pInAttr => FromInAttr);
3265:
3266: replyto := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3267: pCorrId => corrId,
3268: pName => 'REPLYTO',
3269: pInAttr => ReplyToInAttr);
3270:
3267: pCorrId => corrId,
3268: pName => 'REPLYTO',
3269: pInAttr => ReplyToInAttr);
3270:
3271: inlineAtt := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3272: pCorrId => corrId,
3273: pName => 'INLINE_ATTACHMENT',
3274: pInAttr => dummy);
3275:
3272: pCorrId => corrId,
3273: pName => 'INLINE_ATTACHMENT',
3274: pInAttr => dummy);
3275:
3276: sendAccessKey := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
3277: pCorrId => corrId,
3278: pName => 'SEND_ACCESS_KEY',
3279: pInAttr => dummy);
3280:
3277: pCorrId => corrId,
3278: pName => 'SEND_ACCESS_KEY',
3279: pInAttr => dummy);
3280:
3281: stylesheetEnabled := wf_mailer_parameter.getValueForCorr(pNid => nid,
3282: pCorrId => corrId,
3283: pName => 'ENABLE_STYLESHEET',
3284: pInAttr => EnableStyleInAttr);
3285:
3284: pInAttr => EnableStyleInAttr);
3285:
3286: -- 5393647 - Parameter to control the text/html response
3287: -- template delimiter
3288: delimiter_string := wf_mailer_parameter.getValueForCorr(pNId => nid,
3289: pCorrId => corrId,
3290: pName => 'HTML_DELIMITER',
3291: pInAttr => dummy);
3292:
3293:
3294: setHtmlDelimiters(upper(trim(delimiter_string)));
3295:
3296: -- 4676402 Support for CC and BCC. These are not configuration parameters
3297: -- so the values can not be retrieved through the wf_mailer_parameter
3298: -- interface.
3299: -- The precedence will be only for normal notifications. Requests
3300: -- for more information will not be subject to the cc and bcc
3301: -- handling.
3330: -- They are not configurable at the message level because of the
3331: -- confusion caused with multiple mailers and especially those that
3332: -- share the same correlation ID. The value must be consisten in the
3333: -- PL/SQL layer as well as the Java layer.
3334: directResponse := WF_MAILER_PARAMETER.getValueForCorr(pCorrId => corrId,
3335: pName => 'DIRECT_RESPONSE');
3336:
3337: attachInlineImages := WF_MAILER_PARAMETER.GetValueForCorr (
3338: pCorrId => corrId,
3333: -- PL/SQL layer as well as the Java layer.
3334: directResponse := WF_MAILER_PARAMETER.getValueForCorr(pCorrId => corrId,
3335: pName => 'DIRECT_RESPONSE');
3336:
3337: attachInlineImages := WF_MAILER_PARAMETER.GetValueForCorr (
3338: pCorrId => corrId,
3339: pName => 'ATTACH_IMAGES');
3340: if inlineAtt = 'Y' then
3341: disposition := 'inline';
3343: disposition := 'attachment';
3344: end if;
3345:
3346: if sendAccessKey = 'Y' then
3347: wf_mail.Send_Access_Key_On;
3348: else
3349: wf_mail.Send_Access_Key_Off;
3350: end if;
3351:
3345:
3346: if sendAccessKey = 'Y' then
3347: wf_mail.Send_Access_Key_On;
3348: else
3349: wf_mail.Send_Access_Key_Off;
3350: end if;
3351:
3352: if directResponse = 'Y' then
3353: wf_mail.direct_response_on;
3349: wf_mail.Send_Access_Key_Off;
3350: end if;
3351:
3352: if directResponse = 'Y' then
3353: wf_mail.direct_response_on;
3354: else
3355: wf_mail.direct_response_off;
3356: end if;
3357:
3351:
3352: if directResponse = 'Y' then
3353: wf_mail.direct_response_on;
3354: else
3355: wf_mail.direct_response_off;
3356: end if;
3357:
3358: -- If we are here, we are going to generate notification xml payload
3359: -- So allocate TEMP LOB now. << bug 6511028 >>
3358: -- If we are here, we are going to generate notification xml payload
3359: -- So allocate TEMP LOB now. << bug 6511028 >>
3360: messageIdx := wf_temp_lob.getLob(g_LOBTable);
3361:
3362: WF_MAIL.setContext(nid);
3363:
3364: -- bug-8515763 : Temporary workaround for HOTMAIL and Yahoo web clients user.
3365: -- list of domains here.
3366:
3419: -- If user's language also not installed then below API updates OUT params
3420: -- with base language, territory and charset etc..
3421: --
3422: -- TODO : Get_Ntf_Language : optimization required.
3423: WF_MAIL.Get_Ntf_Language(nid, l_nlsLanguage, l_nlsTerritory, l_nlsCodeset, l_is_iana_cs);
3424:
3425: -- Set NLS language and territory for this notification
3426: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3427: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3487:
3488: if frameworkContent = TRUE then
3489: -- Get a modified version of the message. All is rendered
3490: -- except for the &BODY token.
3491: -- NOTE: TEMP LOBs allocated within WF_MAIL.GetLobMessage4 for
3492: -- message body contents should be released here
3493: -- after processsing
3494: -- Bug 10202313: propagating g_status, g_mstatus values to
3495: -- WF_MAIL.GetLOBMessage4() API as these values may update in the meantime
3491: -- NOTE: TEMP LOBs allocated within WF_MAIL.GetLobMessage4 for
3492: -- message body contents should be released here
3493: -- after processsing
3494: -- Bug 10202313: propagating g_status, g_mstatus values to
3495: -- WF_MAIL.GetLOBMessage4() API as these values may update in the meantime
3496: WF_MAIL.GetLobMessage4(nid, nodeName, agent, replyto,
3497: recipient_role, l_nlsLanguage, l_nlsTerritory,
3498: notification_pref, email,
3499: display_name,
3492: -- message body contents should be released here
3493: -- after processsing
3494: -- Bug 10202313: propagating g_status, g_mstatus values to
3495: -- WF_MAIL.GetLOBMessage4() API as these values may update in the meantime
3496: WF_MAIL.GetLobMessage4(nid, nodeName, agent, replyto,
3497: recipient_role, l_nlsLanguage, l_nlsTerritory,
3498: notification_pref, email,
3499: display_name,
3500: 'N',
3503: g_status, g_mstatus);
3504:
3505: else
3506: -- Bug 10202313: propagating g_status, g_mstatus values to
3507: -- WF_MAIL.GetLOBMessage4() API as these values may update in the meantime
3508: WF_MAIL.GetLobMessage4(nid, nodeName, agent, replyto,
3509: recipient_role, l_nlsLanguage, l_nlsTerritory,
3510: notification_pref, email,
3511: display_name,
3504:
3505: else
3506: -- Bug 10202313: propagating g_status, g_mstatus values to
3507: -- WF_MAIL.GetLOBMessage4() API as these values may update in the meantime
3508: WF_MAIL.GetLobMessage4(nid, nodeName, agent, replyto,
3509: recipient_role, l_nlsLanguage, l_nlsTerritory,
3510: notification_pref, email,
3511: display_name,
3512: 'Y',
3659: -- <
3660: --- Below API returns Template Name based on l_sec_policy . So if 'OPEN_MAIL_SECURE'
3661: -- it means user should view online version of ntf but user will
3662: -- get "notification detail.html" as attachement.
3663: Wf_Mail.ProcessSecurityPolicy(nid, l_sec_policy, t_name);
3664:
3665:
3666: /*
3667: ** Potentially, it could be possible for a text/plain notification
3681: */
3682: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
3683:
3684: -- This getBodyPart API releases temp lob allocated within
3685: -- WF_MAIL.GetLobMessage4 for doctype (text/plain )
3686: -- i.e. g_text_messageIdx locator
3687: getBodyPart(g_LOBTable(messageIdx).temp_lob, nid,
3688: g_ntfDocText);
3689:
3721: -- Build the resource section of the XML so that the
3722: -- java layer can locate the notification body to
3723: -- merge into the template.
3724:
3725: ntfURL := wf_mail.urlEncode(wf_notification.getFwkBodyURL2(nid,
3726: g_ntfDocText,
3727: l_nlsLanguage,
3728: l_nlsCalendar));
3729:
3762: --
3763: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
3764:
3765: -- This getBodyPart API releases temp lob allocated within
3766: -- WF_MAIL.GetLobMessage4 for doctype (text/html )
3767: -- i.e. g_html_messageIdx locator
3768: getBodyPart(g_LOBTable(messageIdx).temp_lob, nid,
3769: g_ntfDocHtml);
3770:
3799:
3800: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3801: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3802: 'wf.plsql.WF_XML.generateDoc',
3803: ' Template Name returned by Wf_Mail.ProcessSecurityPolicy: [' || t_name || ']' );
3804:
3805: if (frameworkContent ) then
3806: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3807: 'wf.plsql.WF_XML.generateDoc', ' framework-Content ?: YES') ;
3899: -- Build the resource section of the XML so that the
3900: -- java layer can locate the notification body to
3901: -- merge into the template.
3902:
3903: ntfURL := wf_mail.urlEncode(wf_notification.getFwkBodyURL2(nid,
3904: g_ntfDocHtml,
3905: l_nlsLanguage,
3906: l_nlsCalendar));
3907:
3995: -- attachment or inline through e-mail.
3996: --
3997:
3998: -- << sstomar : below API is being called above so t_name have assigned (null or somevalue) .
3999: -- Wf_Mail.ProcessSecurityPolicy(nid, l_sec_policy, t_name);
4000:
4001: if (t_name is not null) then
4002: if (t_name <> 'OPEN_MAIL_SECURE')
4003: then
4047: when others then
4048:
4049: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4050:
4051: -- Since within wf_mail.getLOBMessage4 we are releasing
4052: -- TEMP LOBs incase of any exception, so there is no need to
4053: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)
4054:
4055: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4049: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4050:
4051: -- Since within wf_mail.getLOBMessage4 we are releasing
4052: -- TEMP LOBs incase of any exception, so there is no need to
4053: -- release those LOBs here. -- WF_MAIL.CloseLob(doctype)
4054:
4055: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4056: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4057: 'wf.plsql.WF_XML.generateDoc',
4144: -- 4628088 Send the RESET_NLS flag if one is defined
4145: -- at the message level.
4146: corrId := wf_event.getValueForParameter('Q_CORRELATION_ID',
4147: p_parameter_list);
4148: resetNls := WF_MAILER_PARAMETER.GetValueForCorr (pNid => p_event_key,
4149: pCorrId => corrId,
4150: pName => 'RESET_NLS',
4151: pInAttr => inAttr);
4152:
4244: GenerateEmptyDoc(nid, 0, p_doc, 'Reassigned, not sent to oringinal recipient', TRUE);
4245: return;
4246: end if;
4247:
4248: if (wf_mail.test_flag = TRUE) then
4249: mail_status := 'MAIL';
4250: if (status not in ('OPEN','CANCELED','CLOSED')) then
4251: status := 'OPEN';
4252: end if;
4281: dbms_lob.write(p_doc, pos, 1, str);
4282:
4283: -- 4628088 Send the RESET_NLS flag if one is defined
4284: -- at the message level.
4285: resetNls := WF_MAILER_PARAMETER.GetValueForCorr (pNid => nid,
4286: pCorrId => messageType,
4287: pName => 'RESET_NLS',
4288: pInAttr => inAttr);
4289:
4476: end if;
4477:
4478: -- Get the Base NLS.
4479: -- << sstomar>> : already being set in GENERATE function
4480: -- WF_MAIL.GetSessionLanguage(base_lang, base_territory, base_codeset);
4481:
4482: -- If requested language is not installed, use base NLS setting
4483: if installed = 'N' then
4484: l_nlsLanguage := g_base_language;
4527:
4528: l_lob := 'N';
4529:
4530: -- <
4531: -- This WF_MAIL.GetSummary2 API may allocate temp LOB depending on
4532: -- size of contents. We release within getBodyPart api, getBodyPart
4533: -- is being called below...
4534: WF_MAIL.GetSummary2(
4535: role => recipient_role,
4530: -- <
4531: -- This WF_MAIL.GetSummary2 API may allocate temp LOB depending on
4532: -- size of contents. We release within getBodyPart api, getBodyPart
4533: -- is being called below...
4534: WF_MAIL.GetSummary2(
4535: role => recipient_role,
4536: dname => display_name,
4537: node => nodename,
4538: renderBody=> l_renderBody,
4609:
4610: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'FROM', '', attrlist);
4611:
4612: -- fromName := '&#FROM';
4613: fromName := WF_MAILER_PARAMETER.GetValueForCorr (pCorrId => corrId,
4614: pName => 'FROM');
4615: fromName := replace(fromName, g_newLine);
4616: fromName := '';
4617: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'NAME', fromName, attrlist);
4617: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'NAME', fromName, attrlist);
4618: hdrxmlPos := SkipTag(hdrxml, 'NAME', hdrxmlPos, occurance);
4619:
4620: -- replyto := '&#REPLYTO';
4621: replyto := WF_MAILER_PARAMETER.GetValueForCorr (pCorrId => corrId,
4622: pName => 'REPLYTO');
4623: replyto := replace(replyto, g_newLine);
4624: replyto := '';
4625: hdrxmlPos := NewTag(hdrxml, hdrxmlPos, 'ADDRESS', replyto, attrlist);
4666: dbms_lob.trim(g_LOBTable(messageIdx).temp_lob, 0);
4667:
4668: -- << bug 6511028 >>
4669: -- This getBodyPart API also releases temp lob allocated within
4670: -- WF_MAIL.GetSummary2 for doctype (text/plain )
4671: -- i.e. g_text_messageIdx locator
4672: getBodyPart(g_LOBTable(messageIdx).temp_lob, 1,
4673: g_ntfDocText);
4674:
4689: if l_renderBody = 'N' then
4690: -- If this is a HTML summary notification then
4691: -- create a RESOURCE tag to obtain the content from
4692: -- the Applications Framework
4693: resourceSrc := wf_mail.urlEncode(wf_notification.getSummaryUrl2(
4694: recipient_role, docType, l_nlsCalendar));
4695: AddElementAttribute('page-type','fwk', attrlist);
4696: AddElementAttribute('src', resourceSrc, attrlist);
4697:
5434: wf_core.Context('WF_XML','handleReceiveEvent',
5435: p_event.getEventName(), p_subscription_guid);
5436: -- Save error message and set status to INVALID so mailer will
5437: -- bounce an "invalid reply" message to sender.
5438: WF_MAIL.HandleResponseError(l_nid, lk_type, lk_code,
5439: l_error_result);
5440: end;
5441: return 'SUCCESS';
5442: end if;
5449: if l_responses.COUNT > 0 then
5450: begin
5451: -- Check if this notification requires a Signature. Other than DEFAULT
5452: -- policies, no other policy is processed by the mailer.
5453: Wf_Mail.GetSignaturePolicy(l_nid, l_sig_policy);
5454: if (l_sig_policy is not NULL and upper(l_sig_policy) <> 'DEFAULT') then
5455: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5456: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5457: 'wf.plsql.WF_XML.handleReceiveEvent',
5491: -- Verify the content of the lookup. This will raise
5492: -- an exception if it is not matched. GetLovMeaning
5493: -- allows for nulls. This is not acceptable here.
5494:
5495: lk_meaning := wf_mail.GetLovMeaning(lk_type,
5496: lk_code);
5497: if lk_meaning is null then
5498: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5499: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5610: end if;
5611:
5612: wf_core.Context('WF_XML','handleReceiveEvent',
5613: to_char(l_nid), 'Step '||l_step);
5614: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5615: -- Save error message and set status to INVALID so mailer will
5616: -- bounce an "invalid reply" message to sender.
5617: WF_MAIL.HandleResponseError(l_nid, lk_type,
5618: substrb(lk_code, 1, 1000),
5613: to_char(l_nid), 'Step '||l_step);
5614: wf_core.context('WF_MAIL','HandleRevieveEvent', to_char(l_nid));
5615: -- Save error message and set status to INVALID so mailer will
5616: -- bounce an "invalid reply" message to sender.
5617: WF_MAIL.HandleResponseError(l_nid, lk_type,
5618: substrb(lk_code, 1, 1000),
5619: l_error_result);
5620: end;
5621: end if;