eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_XML dependencies on FND_LOG

Line 101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

97:
98: l_renderType varchar2(10);
99:
100: begin
101: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
102: wf_log_pkg.string(WF_LOG_PKG.level_statement,
103: 'wf.plsql.WF_XML.isImageReference',
104: 'BEGIN {'||url||'} {'||renderType||'}');
105: end if;

Line 490: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

486: l_pos := (p_pos + l_nodesize) - length(l_end);
487: -- Free up the use of the temporary LOB
488: -- dbms_lob.FreeTemporary(l_temp);
489:
490: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
491: wf_log_pkg.string(WF_LOG_PKG.level_statement,
492: 'wf.plsql.WF_XML.newLOBTag',
493: 'TAG: '||l_start||' POS: '||to_char(l_pos));
494: end if;

Line 624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

620:
621: -- Free up the use of the temporary LOBs
622: wf_temp_lob.releaseLOB(g_LOBTable, l_nodeIdx);
623:
624: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
625: wf_log_pkg.string(WF_LOG_PKG.level_statement,
626: 'wf.plsql.WF_XML.newLOBTag',
627: 'TAG: '||l_start||' POS: '||to_char(l_pos));
628: end if;

Line 715: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

711: end if;
712:
713: l_pos := (p_pos + l_nodesize) - length(l_end);
714:
715: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
716: wf_log_pkg.string(WF_LOG_PKG.level_statement,
717: 'wf.plsql.WF_XML.newTag',
718: 'TAG: '||l_start||' POS: '||to_char(l_pos));
719: end if;

Line 945: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

941:
942: l_pos := p_pos;
943: for l_crec in c_attr(p_nid) loop
944: dbms_lob.trim(g_LOBTable(l_contentIdx).temp_lob, 0);
945: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
946:
947: wf_log_pkg.string(WF_LOG_PKG.level_statement,
948: 'wf.plsql.WF_XML.GetAttachment',
949: 'Document URL {'||l_crec.url||'}');

Line 972: fnd_log.g_current_runtime_level) then

968: l_tmpcontent, l_content_type);
969: exception
970: when others then
971: if (wf_log_pkg.level_error >=
972: fnd_log.g_current_runtime_level) then
973: wf_log_pkg.string(WF_LOG_PKG.level_error,
974: 'wf.plsql.WF_XML.GetAttachment',
975: 'Error when getting PLSQL Document attachment -> '||sqlerrm);
976: end if;

Line 1045: fnd_log.g_current_runtime_level) then

1041: l_content_type, l_error_result);
1042: exception
1043: when others then
1044: if (wf_log_pkg.level_error >=
1045: fnd_log.g_current_runtime_level) then
1046: wf_log_pkg.string(WF_LOG_PKG.level_error,
1047: 'wf.plsql.WF_XML.GetAttachment',
1048: 'Error when getting PLSQL CLOB Document attachment -> '||sqlerrm);
1049: end if;

Line 1163: fnd_log.g_current_runtime_level) then

1159: l_aname);
1160: exception
1161: when others then
1162: if (wf_log_pkg.level_error >=
1163: fnd_log.g_current_runtime_level) then
1164: wf_log_pkg.string(WF_LOG_PKG.level_error,
1165: 'wf.plsql.WF_XML.GetAttachment',
1166: 'Error when getting BLOB attachment -> '||sqlerrm);
1167: end if;

Line 1264: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1260:
1261: -- relase TEMP allocated LOB
1262: wf_temp_lob.releaseLob(g_LOBTable, l_contentIdx);
1263:
1264: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1265: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1266: 'wf.plsql.WF_XML.GetAttachment',
1267: 'END');
1268: end if;

Line 2627: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

2623: l_language := 'AMERICAN';
2624: l_territory := 'AMERICA';
2625: end;
2626:
2627: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
2628: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
2629: 'wf.plsql.WF_XML.SetNLS',
2630: 'Setting Language {'||l_language||'} {'||
2631: l_territory||'} - Passed in {'||language||

Line 3192: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3188: l_is_iana_cs varchar2(1);
3189:
3190: begin
3191:
3192: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3193: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3194: 'wf.plsql.WF_XML.generateDoc', 'BEGIN');
3195: end if;
3196:

Line 3426: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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,
3428: 'wf.plsql.WF_XML.generateDoc',
3429: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3430: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'

Line 3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3525: g_urlNotification := wf_core.translate('WF_URL_NOTIFICATION');
3526: g_urlListAttachment := wf_core.translate('WF_URLLIST_ATTACHMENT');
3527:
3528: -- Reset base NLS settings
3529: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3530: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3531: 'wf.plsql.WF_XML.generateDoc',
3532: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
3533: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'

Line 3800: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3796: -- pos := NewLOBTag(p_doc, pos, 'CONTENT', '', attrlist);
3797: -- attrlist.DELETE;
3798: -- end if;
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:

Line 3853: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3849: -- For BODYPART tag
3850: if ( (frameworkContent = true or imgFound = true) and
3851: ( t_name is null or t_name <>'OPEN_MAIL_SECURE') ) then
3852:
3853: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3854: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3855: 'wf.plsql.WF_XML.generateDoc',
3856: 'Setting BODYPART content-type multipart/related');
3857: end if;

Line 3959: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

3955:
3956: -- Bug 5379861: Notification Reference section and Attachements of a pl/sql
3957: -- notificaton appears as Non-Translated.
3958: -- Set NLS language and territory for this notification
3959: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
3960: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
3961: 'wf.plsql.WF_XML.generateDoc',
3962: 'Setting User NLS {'|| l_nlsLanguage ||'} {'||l_nlsTerritory||'}'
3963: || l_nlsDateFormat || '} {' || l_nlsDateLanguage || '} {'

Line 4010: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4006: else
4007: pos := GetAttachment(nid, p_doc, agent, 'attachment', doctype, pos);
4008: end if;
4009:
4010: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4011: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4012: 'wf.plsql.WF_XML.generateDoc',
4013: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
4014: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'

Line 4042: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4038: p_pos := pos;
4039: wf_temp_lob.releaseLob(g_LOBTable, messageIdx);
4040:
4041:
4042: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4043: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4044: 'wf.plsql.WF_XML.generateDoc', 'END');
4045: end if;
4046: exception

Line 4055: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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',
4058: 'Re-Setting Base NLS {'|| g_base_language ||'} {'||g_base_territory||'}'
4059: || g_base_nlsDateFormat || '} {' || g_base_nlsDateLanguage || '} {'

Line 4119: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4115: resetNls varchar2(10);
4116: corrId varchar2(128);
4117:
4118: begin
4119: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4120: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4121: 'wf.plsql.WF_XML.generateGroupDoc', 'BEGIN');
4122: end if;
4123: i := 1;

Line 4168: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4164: p_event_name, p_event_key, p_parameter_list);
4165: end loop;
4166: end if;
4167:
4168: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4169: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4170: 'wf.plsql.WF_XML.generateGroupDoc', 'END');
4171: end if;
4172: exception

Line 4218: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4214: resetNls varchar2(10);
4215:
4216: begin
4217:
4218: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4219: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4220: 'wf.plsql.WF_XML.generateMessage', 'BEGIN');
4221: end if;
4222:

Line 4326: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4322: orig_system, orig_system_id,
4323: p_event_name, p_event_key, p_parameter_list);
4324: end if;
4325:
4326: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
4327: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
4328: 'wf.plsql.WF_XML.generateMessage', 'END');
4329: end if;
4330: exception

Line 4396: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4392:
4393:
4394: begin
4395:
4396: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4397: wf_log_pkg.string(wf_log_pkg.level_event,
4398: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4399: 'BEGIN');
4400: end if;

Line 4432: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

4428: l_nlsSort ,
4429: l_nlsCurrency );
4430:
4431:
4432: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
4433: wf_log_pkg.string(wf_log_pkg.level_statement,
4434: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4435: 'ROLE {'||recipient_role||'} LANG {'||l_nlsLanguage||
4436: '} TERR {'||l_nlsTerritory||' NTF {'||notification_pref||

Line 4445: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

4441: -- XX TODO Sentinal for DISABLED case? Though there is no NID to be
4442: -- updated, can be used as documentation in the log
4443: if notification_pref not in ('SUMMARY','SUMHTML') or
4444: email is null then
4445: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4446: if email is null then
4447: wf_log_pkg.string(wf_log_pkg.level_exception,
4448: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4449: 'Not generating. Recipient has a null '||

Line 4715: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4711: pos := SkipLOBTag(p_doc, 'NOTIFICATION', pos, occurance);
4712:
4713: p_pos := pos;
4714:
4715: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4716: wf_log_pkg.string(wf_log_pkg.level_event,
4717: 'wf.plsql.WF_XML.GenerateSummaryDoc',
4718: 'END');
4719: end if;

Line 4776: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4772: attrlist wf_xml_attr_table_type;
4773:
4774: begin
4775:
4776: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4777: wf_log_pkg.string(wf_log_pkg.level_event,
4778: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4779: 'BEGIN');
4780: end if;

Line 4791: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4787: i := i + 1;
4788: end loop;
4789:
4790: if members_t.count = 0 then
4791: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4792: wf_log_pkg.string(wf_log_pkg.level_event,
4793: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4794: 'No role members.');
4795: end if;

Line 4809: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4805: p_event_name, p_event_key, p_parameter_list);
4806: end loop;
4807: end if;
4808:
4809: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4810: wf_log_pkg.string(wf_log_pkg.level_event,
4811: 'wf.plsql.WF_XML.GenerateGroupSummaryDoc',
4812: 'END');
4813: end if;

Line 4850: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4846: e_RoleNameNotSpecified EXCEPTION;
4847:
4848: begin
4849:
4850: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4851: wf_log_pkg.string(wf_log_pkg.level_event,
4852: 'wf.plsql.WF_XML.GenerateSummary',
4853: 'BEGIN');
4854: end if;

Line 4903: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

4899: p_parameter_list);
4900:
4901: end if;
4902:
4903: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
4904: wf_log_pkg.string(wf_log_pkg.level_event,
4905: 'wf.plsql.WF_XML.GenerateSummary',
4906: 'END');
4907: end if;

Line 4932: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

4928: l_parameters wf_parameter_list_t;
4929: l_erragt wf_agent_t;
4930:
4931: begin
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_XML.generate', 'BEGIN');
4935: end if;
4936: -- We do not use the LOB pooling for the generate as the LOB

Line 5004: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

5000:
5001: raise;
5002: end;
5003:
5004: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
5005: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
5006: 'wf.plsql.WF_XML.generate', 'END');
5007: end if;
5008: return l_doc;

Line 5427: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5423: 'to provide user feedback');
5424: Wf_Notification.Respond(l_nid, NULL, 'email:'||l_fromAddr);
5425: exception
5426: when others then
5427: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5428: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5429: 'wf.plsql.WF_XML.handleReceiveEvent',
5430: 'Exception on call to Wf_Notification.Respond NID['||l_nid||'] '||
5431: 'Error Msg '||sqlerrm);

Line 5455: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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',
5458: 'Signature policy is not DEFAULT');
5459: end if;

Line 5475: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5471: lk_type := l_responses(i).format;
5472:
5473: lk_code := substrb(l_responses(i).value, 1, 4000);
5474:
5475: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5476: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5477: 'wf.plsql.WF_XML.handleReceiveEvent',
5478: 'Response VALUE ['||
5479: substrb(lk_code, 1, 100)||

Line 5498: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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,
5500: 'wf.plsql.WF_XML.handleReceiveEvent',
5501: 'LOV Meaning is null');
5502: end if;

Line 5594: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5590: else
5591: -- Do not need to preserve context
5592: wf_engine.preserved_context := FALSE;
5593:
5594: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5595: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5596: 'wf.plsql.WF_XML.handleReceiveEvent',
5597: 'Calling Wf_Notification.Respond');
5598: end if;

Line 5605: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

5601: responder => 'email:'||l_fromAddr);
5602: end if;
5603: exception
5604: when others then
5605: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
5606: wf_log_pkg.string(WF_LOG_PKG.level_statement,
5607: 'wf.plsql.WF_XML.handleReceiveEvent',
5608: 'Exception in processing the Response. Step '||l_step||
5609: ' Error Msg '||sqlerrm);

Line 6269: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

6265: l_fulldocloc := dbms_lob.instr(l_eventdata, 'full-document="y"', 1, 1);
6266: end if;
6267:
6268: if (l_fulldocloc > 0) then
6269: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
6270: wf_log_pkg.string(wf_log_pkg.level_statement,
6271: 'wf.plsql.WF_XML.Send_Rule',
6272: 'Full Message for the event key '||l_eventKey||'.'
6273: ||'Running the default rule function.');

Line 6278: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

6274: end if;
6275: return wf_rule.default_rule(p_subscription_guid, p_event);
6276: else
6277:
6278: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
6279: wf_log_pkg.string(wf_log_pkg.level_statement,
6280: 'wf.plsql.WF_XML.Send_Rule',
6281: 'No Full Message for the event key '||l_eventKey||'.'
6282: ||'NOT enquing the message into WF_NOTIFICATION_OUT queue.');