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 FND_MESSAGE

Line 310: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');

306: END IF;
307:
308: -- THE JSP RETURNS EITHER SUCCESS OR FAILURE AS STATUS CODE AND GIVE APPROPRIATE MESSAGES.
309: IF NOT (INSTR(L_STATUS, L_SUCCESS_STATUS, 1) > 0) THEN
310: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
311: FND_MESSAGE.SET_TOKEN('ERROR_MSG',L_STATUS);
312: L_UPLOAD_STATUS := FND_MESSAGE.GET();
313: ELSE
314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');

Line 311: FND_MESSAGE.SET_TOKEN('ERROR_MSG',L_STATUS);

307:
308: -- THE JSP RETURNS EITHER SUCCESS OR FAILURE AS STATUS CODE AND GIVE APPROPRIATE MESSAGES.
309: IF NOT (INSTR(L_STATUS, L_SUCCESS_STATUS, 1) > 0) THEN
310: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
311: FND_MESSAGE.SET_TOKEN('ERROR_MSG',L_STATUS);
312: L_UPLOAD_STATUS := FND_MESSAGE.GET();
313: ELSE
314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');
315: END IF;

Line 312: L_UPLOAD_STATUS := FND_MESSAGE.GET();

308: -- THE JSP RETURNS EITHER SUCCESS OR FAILURE AS STATUS CODE AND GIVE APPROPRIATE MESSAGES.
309: IF NOT (INSTR(L_STATUS, L_SUCCESS_STATUS, 1) > 0) THEN
310: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
311: FND_MESSAGE.SET_TOKEN('ERROR_MSG',L_STATUS);
312: L_UPLOAD_STATUS := FND_MESSAGE.GET();
313: ELSE
314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');
315: END IF;
316:

Line 314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');

310: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
311: FND_MESSAGE.SET_TOKEN('ERROR_MSG',L_STATUS);
312: L_UPLOAD_STATUS := FND_MESSAGE.GET();
313: ELSE
314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');
315: END IF;
316:
317: ELSIF (L_EVENT_STATUS = 'REJECTED') THEN
318: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_APPROVAL_REJECTION');

Line 318: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_APPROVAL_REJECTION');

314: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_TEMPLATE_SUCCESS');
315: END IF;
316:
317: ELSIF (L_EVENT_STATUS = 'REJECTED') THEN
318: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_APPROVAL_REJECTION');
319:
320: ELSE
321: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
322: FND_MESSAGE.SET_TOKEN('ERROR_MSG','WF EVENT FAILED');

Line 321: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');

317: ELSIF (L_EVENT_STATUS = 'REJECTED') THEN
318: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_APPROVAL_REJECTION');
319:
320: ELSE
321: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
322: FND_MESSAGE.SET_TOKEN('ERROR_MSG','WF EVENT FAILED');
323: L_UPLOAD_STATUS := FND_MESSAGE.GET();
324: END IF;
325:

Line 322: FND_MESSAGE.SET_TOKEN('ERROR_MSG','WF EVENT FAILED');

318: L_UPLOAD_STATUS := FND_MESSAGE.GET_STRING('EDR','EDR_FILES_APPROVAL_REJECTION');
319:
320: ELSE
321: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
322: FND_MESSAGE.SET_TOKEN('ERROR_MSG','WF EVENT FAILED');
323: L_UPLOAD_STATUS := FND_MESSAGE.GET();
324: END IF;
325:
326: END IF;

Line 323: L_UPLOAD_STATUS := FND_MESSAGE.GET();

319:
320: ELSE
321: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_FAILURE');
322: FND_MESSAGE.SET_TOKEN('ERROR_MSG','WF EVENT FAILED');
323: L_UPLOAD_STATUS := FND_MESSAGE.GET();
324: END IF;
325:
326: END IF;
327:

Line 334: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');

330:
331: EXCEPTION
332: WHEN L_PAGENOTFOUND THEN
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;

Line 335: FND_MESSAGE.SET_TOKEN('ERROR_MSG','JSP NOT FOUND');

331: EXCEPTION
332: WHEN L_PAGENOTFOUND THEN
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;

Line 336: L_UPLOAD_STATUS := FND_MESSAGE.GET();

332: WHEN L_PAGENOTFOUND THEN
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

Line 344: FND_MESSAGE.SET_NAME('EDR','EDR_PROFILE_CHECK_FAILURE');

340: -- Bug 3950047 : Start
341: -- Improved Error Handling
342: WHEN PROFILE_ERROR THEN
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;

Line 345: FND_MESSAGE.SET_TOKEN('PROFILENAME','FND_DB_WALLET_DIR');

341: -- Improved Error Handling
342: WHEN PROFILE_ERROR THEN
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;

Line 346: L_UPLOAD_STATUS := FND_MESSAGE.GET();

342: WHEN PROFILE_ERROR THEN
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

Line 352: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');

348: P_RESULTOUT := L_RETURN_STATUS;
349: END;
350: WHEN REQUEST_FAIL THEN
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;

Line 353: FND_MESSAGE.SET_TOKEN('ERROR_MSG','HTTP REQUEST FAILED');

349: END;
350: WHEN REQUEST_FAIL THEN
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;

Line 354: L_UPLOAD_STATUS := FND_MESSAGE.GET();

350: WHEN REQUEST_FAIL THEN
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

Line 360: FND_MESSAGE.SET_NAME('EDR','EDR_FILES_TEMPLATE_HTTPFAILURE');

356: P_RESULTOUT := L_RETURN_STATUS;
357: END;
358: WHEN INIT_FAIL THEN
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;

Line 361: FND_MESSAGE.SET_TOKEN('ERROR_MSG','UTL_HTTP INIT FAILED');

357: END;
358: WHEN INIT_FAIL THEN
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;

Line 362: L_UPLOAD_STATUS := FND_MESSAGE.GET();

358: WHEN INIT_FAIL THEN
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