[Home] [Help]
449: and r.name = ur.user_name;
450:
451: begin
452:
453: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
454: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
455: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
456: 'BEGIN');
457: end if;
489:
490: nid := to_number(substrb(externError, 1, delim -1));
491: recipientAddress := substrb(externError, delim+1);
492:
493: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
494: wf_log_pkg.string(WF_LOG_PKG.level_statement,
495: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
496: 'NID ['||to_char(nid)||
497: '] RESPONDER ['||recipientAddress||']');
550: wf_core.newline;
551: for tk in 1..tokens.COUNT loop
552: if tokens(tk) is not null and tokens(tk) <> ',' then
553:
554: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
555: wf_log_pkg.string(WF_LOG_PKG.level_statement,
556: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
557: 'TOKEN ['||tokens(tk)||']');
558: end if;
565: orig_system => orig_system,
566: orig_system_id => orig_system_id,
567: installed_flag => dummy);
568:
569: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
570: wf_log_pkg.string(WF_LOG_PKG.level_statement,
571: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
572: 'PREFERENCE ['||pref||']');
573: end if;
633:
634: end if;
635:
636: else
637: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
638: wf_log_pkg.string(WF_LOG_PKG.level_statement,
639: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
640: 'Unable to update notification preference for email ['||
641: tokens(tk)||']. Check for duplicates');
654: --
655: -- The email for Notification NID was undeliverable. The \
656: -- following roles will be disabled DISABLE_REPORT
657: if (recipient_disabled) then
658: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
659: wf_log_pkg.string(WF_LOG_PKG.level_statement,
660: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
661: 'One or more users have been disabled. Sending a notification to SYSADMIN');
662: end if;
708:
709: end if;
710:
711: if invalidRoleCount > 0 then
712: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
713: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
714: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
715: 'END WARNING');
716: end if;
718: p_event.setErrorMessage(wf_core.translate('WFMLR_ROLE_UPDATE_FAILURE'));
719: p_event.setErrorStack(substrb(invalidRoleList, 1, 4000));
720: return 'WARNING';
721: else
722: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
723: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
724: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
725: 'END SUCCESS');
726: end if;
847: mType varchar2(8);
848: mName varchar2(30);
849:
850: begin
851: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
852: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
853: 'wf.plsql.WF_MAIL.HandleResponseError',
854: 'BEGIN');
855: end if;
974: wf_event.AddParameterToList('ROLE', role, parameterlist);
975: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
976: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
977:
978: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
979: wf_log_pkg.string(WF_LOG_PKG.level_statement,
980: 'wf.plsql.WF_MAIL.HandleResponseError',
981: 'Raising the Send event');
982: end if;
987: p_parameters => parameterlist);
988:
989: exception
990: when others then
991: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
992: wf_log_pkg.string(WF_LOG_PKG.level_exception,
993: 'wf.plsql.WF_MAIL.HandleResponseError',
994: 'Error Msg '|| sqlerrm);
995: end if;
4649: l_pos2 := instrb(l_web_agent, '/', l_pos1);
4650:
4651: l_web_agent := substrb(l_web_agent, 1, l_pos2)||'OA_HTML/';
4652:
4653: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4654: wf_log_pkg.string(wf_log_pkg.level_statement,
4655: 'wf.plsql.wf_mail.Validate_JSP_Agent',
4656: 'Validated JSP Agent -> '||l_web_agent);
4657: end if;
4660: return l_web_agent;
4661:
4662: exception
4663: when others then
4664: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
4665: wf_log_pkg.string(wf_log_pkg.level_error,
4666: 'wf.plsql.wf_mail.Validate_JSP_Agent',
4667: 'Error validating JSP Agent -> '||sqlerrm);
4668: end if;
4720: else -- moreinfo REQ or NULL
4721: params := params||'&'||'wfMoreinfo=N';
4722: end if;
4723:
4724: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4725: wf_log_pkg.string(WF_LOG_PKG.level_statement,
4726: 'wf.plsql.WF_MAIL.Get_Ntf_Function_url',
4727: 'params: {'||params||'} override agent: {'
4728: ||n_override_agent||'}');
4789: end if;
4790:
4791: n_click_here := n_click_here||'">'||n_disp_click||'';
4792:
4793: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4794: wf_log_pkg.string(WF_LOG_PKG.level_statement,'wf.plsql.WF_MAIL.newLOBTag',
4795: 'URL: {'||n_click_here||'}');
4796: end if;
4797:
4985: p_html_history := l_html_history;
4986:
4987: exception
4988: when others then
4989: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4990: wf_log_pkg.string(WF_LOG_PKG.level_exception,
4991: 'wf.plsql.wf_mail.Get_Action_History',
4992: 'Get_Action_History failed. Error: ' || sqlerrm);
4993: end if;
5111: n_start_date2 varchar2(64);
5112:
5113: begin
5114:
5115: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5116: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5117: 'wf.plsql.WF_MAIL.GetLOBMessage4', 'BEGIN');
5118: end if;
5119:
5570: -- DBMS_LOB.Close(template_html);
5571: -- DBMS_LOB.FreeTemporary(template_html);
5572: -- end if;
5573:
5574: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5575: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5576: 'wf.plsql.WF_MAIL.GetLOBMessage4', 'END');
5577: end if;
5578:
5948: order by PRIORITY desc, DUE_DATE asc, NOTIFICATION_ID asc ;
5949:
5950: begin
5951:
5952: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
5953: wf_log_pkg.string(wf_log_pkg.level_event,
5954: 'wf.plsql.WF_MAIL.GetSummary2',
5955: 'BEGIN');
5956: end if;
6150: else
6151: body_text := t_html_body;
6152: end if;
6153:
6154: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
6155: wf_log_pkg.string(wf_log_pkg.level_event,
6156: 'wf.plsql.WF_MAIL.GetSummary2',
6157: 'END');
6158: end if;
7670: l_is_iana_cs varchar2(30);
7671:
7672: begin
7673:
7674: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7675: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_mail.Get_Ntf_Language.BEGIN',
7676: 'User preferences. LANG {'||p_language||'} TERR {'||p_territory||'}');
7677: end if;
7678:
7765: end if;
7766:
7767: -- If at least one of the value is null, use the base NLS setting
7768: if (p_language is null or p_territory is null) then
7769: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7770: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_mail.Get_Ntf_Language.NULL',
7771: 'Using base NLS setting because p_language is {'||p_language||
7772: '} and p_territory is {'||p_territory||'}');
7773: end if;
7796: p_territory := nvl(p_territory, l_base_terr);
7797:
7798: end if;
7799:
7800: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7801: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_mail.Get_Ntf_Language.END',
7802: 'Email Notification LANG {'||p_language||'} TERR {'||p_territory||'}'||
7803: ' CODESET {'||p_codeset||'}');
7804: end if;
7900: l_fyi_flag boolean;
7901:
7902: begin
7903:
7904: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7905: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7906: 'wf.plsql.WF_MAIL.send',
7907: 'BEGIN');
7908: end if;
7918: end if;
7919:
7920: -- Recipients required
7921: if (p_recipient_list is null) then
7922: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7923: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7924: 'wf.plsql.WF_MAIL.send',
7925: 'Recipient List is empty. ');
7926: end if;
7929: end if;
7930:
7931: -- At least subject or body is required
7932: if (p_subject is null and (p_message is null or dbms_lob.GetLength(p_message)=0)) then
7933: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7934: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7935: 'wf.plsql.WF_MAIL.send',
7936: 'Subject and Message Contents are blank or null. ');
7937: end if;
7940: end if;
7941:
7942: -- For all e-mails, respone or FYI, module name is required
7943: if (p_module is null) then
7944: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7945: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7946: 'wf.plsql.WF_MAIL.send',
7947: 'Message module is not specified. ');
7948: end if;
8189:
8190: -- Release allocated temp LOBs back to pool
8191: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
8192:
8193: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8194: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
8195: 'wf.plsql.WF_MAIL.send',
8196: 'END');
8197: end if;
8285: ORDER BY comment_date desc;
8286:
8287: BEGIN
8288:
8289: IF(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) THEN
8290: wf_log_pkg.string(wf_log_pkg.level_procedure,
8291: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'BEGIN');
8292: END IF;
8293:
8602: --
8603: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);
8604:
8605:
8606: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8607: wf_log_pkg.string(wf_log_pkg.level_procedure,
8608: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning',
8609: 'Initializing ' || wf_xml.wf_ntf_send_message || ' event');
8610: end if;
8627:
8628: -- Release allocated temp LOBs back to pool
8629: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8630:
8631: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8632: wf_log_pkg.string(wf_log_pkg.level_procedure,
8633: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'END');
8634: end if;
8635: