[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;
622:
623: end if;
624:
625: else
626: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
627: wf_log_pkg.string(WF_LOG_PKG.level_statement,
628: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
629: 'Unable to update notification preference for email ['||
630: tokens(tk)||']. Check for duplicates');
643: --
644: -- The email for Notification NID was undeliverable. The \
645: -- following roles will be disabled DISABLE_REPORT
646: if (recipient_disabled) then
647: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
648: wf_log_pkg.string(WF_LOG_PKG.level_statement,
649: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
650: 'One or more users have been disabled. Sending a notification to SYSADMIN');
651: end if;
697:
698: end if;
699:
700: if invalidRoleCount > 0 then
701: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
702: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
703: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
704: 'END WARNING');
705: end if;
707: p_event.setErrorMessage(wf_core.translate('WFMLR_ROLE_UPDATE_FAILURE'));
708: p_event.setErrorStack(substrb(invalidRoleList, 1, 4000));
709: return 'WARNING';
710: else
711: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
712: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
713: 'wf.plsql.WF_MAIL.Disable_Recipient_Ntf_Pref',
714: 'END SUCCESS');
715: end if;
836: mType varchar2(8);
837: mName varchar2(30);
838:
839: begin
840: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
841: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
842: 'wf.plsql.WF_MAIL.HandleResponseError',
843: 'BEGIN');
844: end if;
963: wf_event.AddParameterToList('ROLE', role, parameterlist);
964: wf_event.AddParameterToList('GROUP_ID', nvl(group_id, nid), parameterlist);
965: wf_event.addParameterToList('Q_CORRELATION_ID', mType || ':' || mName, parameterlist);
966:
967: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
968: wf_log_pkg.string(WF_LOG_PKG.level_statement,
969: 'wf.plsql.WF_MAIL.HandleResponseError',
970: 'Raising the Send event');
971: end if;
976: p_parameters => parameterlist);
977:
978: exception
979: when others then
980: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
981: wf_log_pkg.string(WF_LOG_PKG.level_exception,
982: 'wf.plsql.WF_MAIL.HandleResponseError',
983: 'Error Msg '|| sqlerrm);
984: end if;
4472: l_pos2 := instrb(l_web_agent, '/', l_pos1);
4473:
4474: l_web_agent := substrb(l_web_agent, 1, l_pos2)||'OA_HTML/';
4475:
4476: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4477: wf_log_pkg.string(wf_log_pkg.level_statement,
4478: 'wf.plsql.wf_mail.Validate_JSP_Agent',
4479: 'Validated JSP Agent -> '||l_web_agent);
4480: end if;
4483: return l_web_agent;
4484:
4485: exception
4486: when others then
4487: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
4488: wf_log_pkg.string(wf_log_pkg.level_error,
4489: 'wf.plsql.wf_mail.Validate_JSP_Agent',
4490: 'Error validating JSP Agent -> '||sqlerrm);
4491: end if;
4543: else -- moreinfo REQ or NULL
4544: params := params||'&'||'wfMoreinfo=N';
4545: end if;
4546:
4547: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4548: wf_log_pkg.string(WF_LOG_PKG.level_statement,
4549: 'wf.plsql.WF_MAIL.Get_Ntf_Function_url',
4550: 'params: {'||params||'} override agent: {'
4551: ||n_override_agent||'}');
4612: end if;
4613:
4614: n_click_here := n_click_here||'">'||n_disp_click||'';
4615:
4616: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4617: wf_log_pkg.string(WF_LOG_PKG.level_statement,'wf.plsql.WF_MAIL.newLOBTag',
4618: 'URL: {'||n_click_here||'}');
4619: end if;
4620:
4808: p_html_history := l_html_history;
4809:
4810: exception
4811: when others then
4812: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4813: wf_log_pkg.string(WF_LOG_PKG.level_exception,
4814: 'wf.plsql.wf_mail.Get_Action_History',
4815: 'Get_Action_History failed. Error: ' || sqlerrm);
4816: end if;
4928: n_start_date2 varchar2(64);
4929:
4930: begin
4931:
4932: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4933: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4934: 'wf.plsql.WF_MAIL.GetLOBMessage3', 'BEGIN');
4935: end if;
4936:
5392: -- DBMS_LOB.Close(template_html);
5393: -- DBMS_LOB.FreeTemporary(template_html);
5394: -- end if;
5395:
5396: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5397: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5398: 'wf.plsql.WF_MAIL.GetLOBMessage3', 'END');
5399: end if;
5400:
5684: order by PRIORITY desc, DUE_DATE asc, NOTIFICATION_ID asc ;
5685:
5686: begin
5687:
5688: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
5689: wf_log_pkg.string(wf_log_pkg.level_event,
5690: 'wf.plsql.WF_MAIL.GetSummary2',
5691: 'BEGIN');
5692: end if;
5886: else
5887: body_text := t_html_body;
5888: end if;
5889:
5890: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
5891: wf_log_pkg.string(wf_log_pkg.level_event,
5892: 'wf.plsql.WF_MAIL.GetSummary2',
5893: 'END');
5894: end if;
7373:
7374:
7375: begin
7376:
7377: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7378: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_mail.Get_Ntf_Language.BEGIN',
7379: 'User preferences. LANG {'||p_language||'} TERR {'||p_territory||'}');
7380: end if;
7381:
7476: end if;
7477:
7478: -- If at least one of the value is null, use the base NLS setting
7479: if (p_language is null or p_territory is null) then
7480: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
7481: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_mail.Get_Ntf_Language.NULL',
7482: 'Using base NLS setting because p_language is {'||p_language||
7483: '} and p_territory is {'||p_territory||'}');
7484: end if;
7506: p_territory := nvl(p_territory, l_base_terr);
7507:
7508: end if;
7509:
7510: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7511: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_mail.Get_Ntf_Language.END',
7512: 'Email Notification LANG {'||p_language||'} TERR {'||p_territory||'}'||
7513: ' CODESET {'||p_codeset||'}');
7514: end if;
7584: l_fyi_flag boolean;
7585:
7586: begin
7587:
7588: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7589: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7590: 'wf.plsql.WF_MAIL.send',
7591: 'BEGIN');
7592: end if;
7602: end if;
7603:
7604: -- Recipients required
7605: if (p_recipient_list is null) then
7606: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7607: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7608: 'wf.plsql.WF_MAIL.send',
7609: 'Recipient List is empty. ');
7610: end if;
7613: end if;
7614:
7615: -- At least subject or body is required
7616: if (p_subject is null and (p_message is null or dbms_lob.GetLength(p_message)=0)) then
7617: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7618: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7619: 'wf.plsql.WF_MAIL.send',
7620: 'Subject and Message Contents are blank or null. ');
7621: end if;
7624: end if;
7625:
7626: -- For all e-mails, respone or FYI, module name is required
7627: if (p_module is null) then
7628: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7629: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7630: 'wf.plsql.WF_MAIL.send',
7631: 'Message module is not specified. ');
7632: end if;
7870:
7871: -- Release allocated temp LOBs back to pool
7872: wf_temp_lob.releaseLob(g_LOBTable, l_messageIdx);
7873:
7874: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
7875: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
7876: 'wf.plsql.WF_MAIL.send',
7877: 'END');
7878: end if;
7966: ORDER BY comment_date desc;
7967:
7968: BEGIN
7969:
7970: IF(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) THEN
7971: wf_log_pkg.string(wf_log_pkg.level_procedure,
7972: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'BEGIN');
7973: END IF;
7974:
8283: --
8284: l_pos := wf_xml.skiplobtag(l_msg_doc,'NOTIFICATIONGROUP',l_pos,l_occurance);
8285:
8286:
8287: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8288: wf_log_pkg.string(wf_log_pkg.level_procedure,
8289: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning',
8290: 'Initializing ' || wf_xml.wf_ntf_send_message || ' event');
8291: end if;
8308:
8309: -- Release allocated temp LOBs back to pool
8310: wf_temp_lob.releaselob(g_lobtable, l_messageidx);
8311:
8312: if(wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
8313: wf_log_pkg.string(wf_log_pkg.level_procedure,
8314: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'END');
8315: end if;
8316: