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_TEMPLATE_SUBS dependencies on WF_LOG_PKG

Line 137: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT NAME '||L_EVENT_NAME);

133:
134:
135:
136:
137: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT NAME '||L_EVENT_NAME);
138: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT KEY '||L_EVENT_KEY);
139:
140: --START WITH CHECKING THAT THE FILE IS AN RTF TEMPLATE
141: EDR_FILE_UTIL_PUB.GET_FILE_NAME(L_EVENT_KEY, L_FILE_NAME);

Line 138: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT KEY '||L_EVENT_KEY);

134:
135:
136:
137: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT NAME '||L_EVENT_NAME);
138: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT KEY '||L_EVENT_KEY);
139:
140: --START WITH CHECKING THAT THE FILE IS AN RTF TEMPLATE
141: EDR_FILE_UTIL_PUB.GET_FILE_NAME(L_EVENT_KEY, L_FILE_NAME);
142:

Line 143: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','FILE NAME'||L_FILE_NAME);

139:
140: --START WITH CHECKING THAT THE FILE IS AN RTF TEMPLATE
141: EDR_FILE_UTIL_PUB.GET_FILE_NAME(L_EVENT_KEY, L_FILE_NAME);
142:
143: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','FILE NAME'||L_FILE_NAME);
144:
145: --LOCATE BEGINNING OF THE EXTENSION IN THE FILE NAME STRING TO USE
146: --POSITION TO SPLIT UP THE FILE NAME
147: L_EXTENSION := NULL;

Line 154: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EXTENSION '||L_EXTENSION);

150: IF L_POS <> 0 THEN
151: L_EXTENSION := SUBSTR(L_FILE_NAME,L_POS+1,LENGTH(L_FILE_NAME));
152: END IF;
153:
154: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EXTENSION '||L_EXTENSION);
155:
156:
157: --ONLY IF THE EXTENSION OF THE FILE IS XSL PROCEED FURTHER
158: IF (UPPER(L_EXTENSION) = 'RTF') THEN

Line 161: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','CATEGORY NAME'||L_CATEGORY_NAME);

157: --ONLY IF THE EXTENSION OF THE FILE IS XSL PROCEED FURTHER
158: IF (UPPER(L_EXTENSION) = 'RTF') THEN
159: --GET THE CATEGORY OF THE FILE
160: EDR_FILE_UTIL_PUB.GET_CATEGORY_NAME(L_EVENT_KEY,L_CATEGORY_NAME);
161: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','CATEGORY NAME'||L_CATEGORY_NAME);
162:
163:
164: -- CHECK THE FILE CATEGORY AFTER CHECKING EXTENSION, WHETHER ITS ERECORD TEMPLATE
165: IF (L_CATEGORY_NAME = G_TMP_CATEGORY) THEN

Line 166: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EDR ERCORD TEMPLATE CATEGORY NAME FOUND');

162:
163:
164: -- CHECK THE FILE CATEGORY AFTER CHECKING EXTENSION, WHETHER ITS ERECORD TEMPLATE
165: IF (L_CATEGORY_NAME = G_TMP_CATEGORY) THEN
166: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EDR ERCORD TEMPLATE CATEGORY NAME FOUND');
167: L_RETURN_STATUS := G_YES;
168: END IF;
169: END IF;
170:

Line 175: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','RETURN STATUS IS YES...STARTING UPLOAD');

171: --NOW THAT WE HAVE MADE CERTAIN THAT THE FILE EXTENSION IS RTF AND THE CATEGORY
172: --IS E RECORD TEMPLATE GO AHEAD AND TRY TO UPLOAD IT
173:
174: IF (L_RETURN_STATUS = G_YES) THEN
175: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','RETURN STATUS IS YES...STARTING UPLOAD');
176:
177: --SET THE FILE AUTHOR ATTRIBUTE IN WORKFLOW
178: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(L_EVENT_KEY, L_AUTHOR);
179: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR '||L_AUTHOR);

Line 179: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR '||L_AUTHOR);

175: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','RETURN STATUS IS YES...STARTING UPLOAD');
176:
177: --SET THE FILE AUTHOR ATTRIBUTE IN WORKFLOW
178: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(L_EVENT_KEY, L_AUTHOR);
179: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR '||L_AUTHOR);
180: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'AUTHOR',L_AUTHOR);
181: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR NAME SET IN THE WORKFLOW');
182:
183: --set the file name

Line 181: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR NAME SET IN THE WORKFLOW');

177: --SET THE FILE AUTHOR ATTRIBUTE IN WORKFLOW
178: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(L_EVENT_KEY, L_AUTHOR);
179: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR '||L_AUTHOR);
180: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'AUTHOR',L_AUTHOR);
181: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR NAME SET IN THE WORKFLOW');
182:
183: --set the file name
184: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'RTF_NAME', l_file_name);
185: wf_log_pkg.string(6, 'UPLOAD_TEMPLATE','file name set in the workflow');

Line 185: wf_log_pkg.string(6, 'UPLOAD_TEMPLATE','file name set in the workflow');

181: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','AUTHOR NAME SET IN THE WORKFLOW');
182:
183: --set the file name
184: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'RTF_NAME', l_file_name);
185: wf_log_pkg.string(6, 'UPLOAD_TEMPLATE','file name set in the workflow');
186:
187: --set the version
188: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);
189: l_version_num := l_version;

Line 190: wf_log_pkg.string(6, 'UPLOAD_TEMPLATE','version num '||l_version_num);

186:
187: --set the version
188: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);
189: l_version_num := l_version;
190: wf_log_pkg.string(6, 'UPLOAD_TEMPLATE','version num '||l_version_num);
191: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);
192:
193: --set the product name of the file owner product
194: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);

Line 195: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);

191: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);
192:
193: --set the product name of the file owner product
194: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);
195: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);
196: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);
197:
198: -- GET THE EVENT STATUS FROM WORKFLOW
199: L_EVENT_STATUS := WF_ENGINE.GETITEMATTRTEXT(P_ITEMTYPE,P_ITEMKEY,'FILE_STATUS');

Line 200: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT STATUS'||L_EVENT_STATUS);

196: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);
197:
198: -- GET THE EVENT STATUS FROM WORKFLOW
199: L_EVENT_STATUS := WF_ENGINE.GETITEMATTRTEXT(P_ITEMTYPE,P_ITEMKEY,'FILE_STATUS');
200: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT STATUS'||L_EVENT_STATUS);
201:
202: --IF THE STATUS IS SUCCESS ONLY THEN UPLOAD IT TO THE DATABASE
203:
204:

Line 262: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','SENDING REQUEST FOR XSL CONVERSION TO JSP');

258: X_DOC_ATTRIBUTE10=>NULL,
259: X_CREATE_DOC=>'N');
260:
261: -- CALL THE JSP TO CREATE AN XSL FO IN THE FND LOB TABLES.
262: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','SENDING REQUEST FOR XSL CONVERSION TO JSP');
263:
264: BEGIN
265:
266: L_AGENT := FND_PROFILE.VALUE('APPS_JSP_AGENT');

Line 275: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','URL' || L_HTTP_URL);

271:
272: L_HTTP_URL := L_AGENT || '/OA_HTML/jsp/edr/iSignPublisherHandler.jsp?eventId=' || L_EVENT_KEY
273: || '&' || 'mediaId='||L_MEDIA_ID || '&' || 'repository=ISIGN'|| '&' || 'src_req=' || l_src_req;
274:
275: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','URL' || L_HTTP_URL);
276: -- Bug 4450651 end
277:
278:
279: --Bug 3950047 : Start

Line 286: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EXCEPTION IN GETTING RESPONSE' || SQLERRM );

282: --Bug 3950047 : End
283:
284: EXCEPTION WHEN OTHERS THEN
285: BEGIN
286: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EXCEPTION IN GETTING RESPONSE' || SQLERRM );
287: RAISE;
288: END;
289:
290: END;

Line 292: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','RESPONSE FROM JSP' || L_HTTP_RESPONSE);

288: END;
289:
290: END;
291:
292: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','RESPONSE FROM JSP' || L_HTTP_RESPONSE);
293:
294: -- READ THE STATUS FROM JSP RESPONSE
295: --L_POSITION := INSTR(L_HTTP_RESPONSE,'=',1);
296: --L_HTTP_RESPONSE := SUBSTR(L_HTTP_RESPONSE,L_POSITION+1);

Line 301: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','STATUS ' || L_STATUS);

297: --L_POSITION :=INSTR(L_HTTP_RESPONSE,';',1);
298: --L_STATUS := SUBSTR(L_HTTP_RESPONSE,1,L_POSITION-1);
299:
300: L_STATUS := UPPER(TRIM(L_HTTP_RESPONSE));
301: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','STATUS ' || L_STATUS);
302:
303: --Check if UTL_HTTP request returned with JSp Not found message.
304: IF (INSTR(SUBSTR(L_HTTP_RESPONSE,1,1024), 'FileNotFoundException', 1) > 0) THEN
305: RAISE L_PAGENOTFOUND;