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_ENGINE

Line 49: -- to_char(, wf_engine.date_format)

45: -- An example is the Standard AND activity.
46: -- DEFERRED:activity is deferred to a
47: -- background engine for execution until a given date.
48: -- must be of the format:
49: -- to_char(, wf_engine.date_format)
50: -- NOTIFIED::-a
51: -- n external entity is notified that an action must be
52: -- performed. A notification ID and an assigned user
53: -- can optionally be returned with this result. Note

Line 119: L_EVENT_NAME :=WF_ENGINE.GETITEMATTRTEXT(

115: CURSOR C_GET_ID IS
116: SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL
117: FROM DUAL;
118: BEGIN
119: L_EVENT_NAME :=WF_ENGINE.GETITEMATTRTEXT(
120: ITEMTYPE=>P_ITEMTYPE,
121: ITEMKEY=>P_ITEMKEY,
122: ANAME=>'EVENT_NAME');
123:

Line 124: L_EVENT_KEY :=WF_ENGINE.GETITEMATTRTEXT(

120: ITEMTYPE=>P_ITEMTYPE,
121: ITEMKEY=>P_ITEMKEY,
122: ANAME=>'EVENT_NAME');
123:
124: L_EVENT_KEY :=WF_ENGINE.GETITEMATTRTEXT(
125: ITEMTYPE=>P_ITEMTYPE,
126: ITEMKEY=>P_ITEMKEY,
127: ANAME=>'EVENT_KEY');
128:

Line 180: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'AUTHOR',L_AUTHOR);

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
184: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'RTF_NAME', l_file_name);

Line 184: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'RTF_NAME', l_file_name);

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');
186:
187: --set the version
188: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);

Line 191: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);

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);
195: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);

Line 196: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);

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');
200: WF_LOG_PKG.STRING(6, 'UPLOAD_RTF','EVENT STATUS'||L_EVENT_STATUS);

Line 199: L_EVENT_STATUS := WF_ENGINE.GETITEMATTRTEXT(P_ITEMTYPE,P_ITEMKEY,'FILE_STATUS');

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');
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:

Line 328: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);

324: END IF;
325:
326: END IF;
327:
328: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);
329: P_RESULTOUT := L_RETURN_STATUS;
330:
331: EXCEPTION
332: WHEN L_PAGENOTFOUND THEN

Line 337: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);

333: BEGIN
334: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');
335: FND_MESSAGE.SET_TOKEN('ERROR_MSG','JSP NOT FOUND');
336: L_UPLOAD_STATUS := FND_MESSAGE.GET();
337: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);
338: P_RESULTOUT := L_RETURN_STATUS;
339: END;
340: -- Bug 3950047 : Start
341: -- Improved Error Handling

Line 347: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE,P_ITEMKEY, 'UPLOAD_STATUS', L_UPLOAD_STATUS);

343: BEGIN
344: FND_MESSAGE.SET_NAME('EDR','EDR_PROFILE_CHECK_FAILURE');
345: FND_MESSAGE.SET_TOKEN('PROFILENAME','FND_DB_WALLET_DIR');
346: L_UPLOAD_STATUS := FND_MESSAGE.GET();
347: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE,P_ITEMKEY, 'UPLOAD_STATUS', L_UPLOAD_STATUS);
348: P_RESULTOUT := L_RETURN_STATUS;
349: END;
350: WHEN REQUEST_FAIL THEN
351: BEGIN

Line 355: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);

351: BEGIN
352: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');
353: FND_MESSAGE.SET_TOKEN('ERROR_MSG','HTTP REQUEST FAILED');
354: L_UPLOAD_STATUS := FND_MESSAGE.GET();
355: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);
356: P_RESULTOUT := L_RETURN_STATUS;
357: END;
358: WHEN INIT_FAIL THEN
359: BEGIN

Line 363: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);

359: BEGIN
360: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');
361: FND_MESSAGE.SET_TOKEN('ERROR_MSG','UTL_HTTP INIT FAILED');
362: L_UPLOAD_STATUS := FND_MESSAGE.GET();
363: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);
364: P_RESULTOUT := L_RETURN_STATUS;
365: END;
366: WHEN OTHERS THEN
367: BEGIN

Line 369: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);

365: END;
366: WHEN OTHERS THEN
367: BEGIN
368: L_UPLOAD_STATUS := SQLERRM;
369: WF_ENGINE.SETITEMATTRTEXT(P_ITEMTYPE, P_ITEMKEY, 'UPLOAD_STATUS',L_UPLOAD_STATUS);
370: P_RESULTOUT := L_RETURN_STATUS;
371: END;
372: -- Bug 3950047 : End
373: