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.EDR_PSIG dependencies on WF_NOTIFICATION

Line 162: l_attachment_string:=wf_notification.getattrtext(p_nid,'#ATTACHMENTS');

158: BEGIN
159: /* Parse the string */
160: BEGIN
161: wf_log_pkg.string(6, 'Copy Attachments...','Verifying....the attribute attachments');
162: l_attachment_string:=wf_notification.getattrtext(p_nid,'#ATTACHMENTS');
163: wf_log_pkg.string(6, 'Copy Attachments...','Attribute String.....'||l_attachment_string);
164: exception
165: when others then
166: NULL;

Line 404: wf_notification.newclob(l_document,l_msg);

400: l_document := empty_clob();
401: l_end_of_msgbody := 'N';
402: --Bug 4073809 : end
403:
404: wf_notification.newclob(l_document,l_msg);
405:
406: /* Check if Server time Zone is set to NULL and if error out */
407: VERIFY_TIMEZONE(X_TIMEZONE =>l_server_timezone,
408: X_ERROR => P_ERROR,

Line 423: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN

419: /* Begin Bug Fix 3142631*/
420: /* Check the Document_type */
421: if (P_PSIG_DOCUMENTFORMAT is NULL
422: or P_PSIG_DOCUMENTFORMAT ='TEXT'
423: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
424: l_doc_format:=WF_NOTIFICATION.doc_text;
425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else

Line 424: l_doc_format:=WF_NOTIFICATION.doc_text;

420: /* Check the Document_type */
421: if (P_PSIG_DOCUMENTFORMAT is NULL
422: or P_PSIG_DOCUMENTFORMAT ='TEXT'
423: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
424: l_doc_format:=WF_NOTIFICATION.doc_text;
425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');

Line 425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN

421: if (P_PSIG_DOCUMENTFORMAT is NULL
422: or P_PSIG_DOCUMENTFORMAT ='TEXT'
423: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
424: l_doc_format:=WF_NOTIFICATION.doc_text;
425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');

Line 426: l_doc_format:=WF_NOTIFICATION.doc_html;

422: or P_PSIG_DOCUMENTFORMAT ='TEXT'
423: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
424: l_doc_format:=WF_NOTIFICATION.doc_text;
425: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
426: l_doc_format:=WF_NOTIFICATION.doc_html;
427: else
428: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
429: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
430: P_ERROR_MSG:= fnd_message.get();

Line 438: wf_notification.GetFullBodyWrapper

434:
435: /* User requested to use Workflow notification body as text */
436: BEGIN
437: while (l_end_of_msgbody <> 'Y') Loop
438: wf_notification.GetFullBodyWrapper
439: ( NID => P_WF_NID ,
440: msgbody => l_msg ,
441: end_of_body => l_end_of_msgbody,
442: disptype => l_doc_format

Line 445: wf_notification.writetoclob(l_document,l_msg);

441: end_of_body => l_end_of_msgbody,
442: disptype => l_doc_format
443: );
444: wf_log_pkg.string(6, 'EDR_PSIG_rule.psig_rule','l_msg '|| l_msg);
445: wf_notification.writetoclob(l_document,l_msg);
446: end loop;
447: EXCEPTION
448: WHEN OTHERS then
449: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');

Line 620: wf_notification.newclob(l_document,l_msg);

616: --Bug 4073809 : end
617:
618:
619:
620: wf_notification.newclob(l_document,l_msg);
621: /* Check if Server time Zone is set to NULL and if error out */
622: VERIFY_TIMEZONE(X_TIMEZONE =>l_server_timezone,
623: X_ERROR => P_ERROR,
624: X_ERROR_MSG =>P_ERROR_MSG);

Line 872: wf_notification.newclob(l_document,l_msg);

868: IF L_STATUS IN ('COMPLETE','REJECTED','CANCEL','TIMEDOUT') THEN
869: RAISE EDR_INVALID_DOC_TRAN;
870: END IF;
871:
872: wf_notification.newclob(l_document,l_msg);
873: if P_WF_NID is NULL then
874: /* Assign passed Document to l_document */
875: l_document:= P_PSIG_DOCUMENT;
876: else

Line 882: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN

878: /* Begin Bug Fix 3142631*/
879: /* Check the Document_type */
880: if (P_PSIG_DOCUMENTFORMAT is NULL
881: or P_PSIG_DOCUMENTFORMAT ='TEXT'
882: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
883: l_doc_format:=WF_NOTIFICATION.doc_text;
884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else

Line 883: l_doc_format:=WF_NOTIFICATION.doc_text;

879: /* Check the Document_type */
880: if (P_PSIG_DOCUMENTFORMAT is NULL
881: or P_PSIG_DOCUMENTFORMAT ='TEXT'
882: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
883: l_doc_format:=WF_NOTIFICATION.doc_text;
884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');

Line 884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN

880: if (P_PSIG_DOCUMENTFORMAT is NULL
881: or P_PSIG_DOCUMENTFORMAT ='TEXT'
882: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
883: l_doc_format:=WF_NOTIFICATION.doc_text;
884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');

Line 885: l_doc_format:=WF_NOTIFICATION.doc_html;

881: or P_PSIG_DOCUMENTFORMAT ='TEXT'
882: or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_text) THEN
883: l_doc_format:=WF_NOTIFICATION.doc_text;
884: elsif ( P_PSIG_DOCUMENTFORMAT = 'HTML' or P_PSIG_DOCUMENTFORMAT = WF_NOTIFICATION.doc_html) THEN
885: l_doc_format:=WF_NOTIFICATION.doc_html;
886: else
887: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_DOCFORMAT');
888: P_ERROR:=fnd_message.get_number('EDR','EDR_PSIG_WFNTF_FORMAT');
889: P_ERROR_MSG:= fnd_message.get();

Line 898: wf_notification.GetFullBodyWrapper

894:
895: /* User requested to use Workflow notification body as text */
896: BEGIN
897: while (l_end_of_msgbody <> 'Y') Loop
898: wf_notification.GetFullBodyWrapper
899: ( NID => P_WF_NID ,
900: msgbody => l_msg ,
901: end_of_body => l_end_of_msgbody,
902: disptype => l_doc_format

Line 905: wf_notification.writetoclob(l_document,l_msg);

901: end_of_body => l_end_of_msgbody,
902: disptype => l_doc_format
903: );
904: wf_log_pkg.string(6, 'EDR_PSIG_rule.psig_rule','l_msg '|| l_msg);
905: wf_notification.writetoclob(l_document,l_msg);
906: end loop;
907: EXCEPTION
908: WHEN OTHERS then
909: fnd_message.set_name('EDR','EDR_PSIG_WFNTF_ERROR');