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.AP_WEB_RECEIPTS_WF dependencies on FND_MESSAGE

Line 2022: - FND_MESSAGE contains the specific FND message to store

2018: The following is gathered from the WF:
2019: - RESULT_TYPE contains the lookup type for the result of the Notification.
2020: - RESULT_CODE contains the lookup code for the result of the Notification.
2021: - RESPONSE contains the respond attr for the Notification.
2022: - FND_MESSAGE contains the specific FND message to store
2023:
2024: The Preparer-Auditor note is stored in the form of:
2025: :
2026: */

Line 2038: l_fnd_message fnd_new_messages.message_name%type;

2034: ----------------------------------------------------------------------
2035: l_report_header_id number;
2036: l_debug_info VARCHAR2(200);
2037:
2038: l_fnd_message fnd_new_messages.message_name%type;
2039: l_note_text varchar2(2000);
2040: l_days_overdue number;
2041:
2042: l_message_name fnd_new_messages.message_name%type;

Line 2157: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

2153: l_message_name := 'OIE_NOTES_PREPARER_RESPONSE';
2154:
2155: begin
2156: -------------------------------------------------------------------
2157: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
2158: -------------------------------------------------------------------
2159: select message_text
2160: into l_note_prefix
2161: from fnd_new_messages

Line 2168: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

2164: and language_code = l_new_language_code;
2165:
2166: exception
2167: when no_data_found then
2168: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2169: l_note_prefix := FND_MESSAGE.GET;
2170: end;
2171:
2172: BEGIN

Line 2169: l_note_prefix := FND_MESSAGE.GET;

2165:
2166: exception
2167: when no_data_found then
2168: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2169: l_note_prefix := FND_MESSAGE.GET;
2170: end;
2171:
2172: BEGIN
2173: IF (l_result_type = 'APWRECPT_OVERDUE_RESPONSE') THEN

Line 2179: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

2175: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2176: p_item_key,
2177: 'DAYS_OVERDUE');
2178:
2179: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2180: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2181: l_note_prefix := FND_MESSAGE.GET;
2182: END IF;
2183:

Line 2180: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

2176: p_item_key,
2177: 'DAYS_OVERDUE');
2178:
2179: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2180: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2181: l_note_prefix := FND_MESSAGE.GET;
2182: END IF;
2183:
2184: IF (l_result_type = 'APWRECPT_IMG_OVERDUE_RESPONSE') THEN

Line 2181: l_note_prefix := FND_MESSAGE.GET;

2177: 'DAYS_OVERDUE');
2178:
2179: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2180: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2181: l_note_prefix := FND_MESSAGE.GET;
2182: END IF;
2183:
2184: IF (l_result_type = 'APWRECPT_IMG_OVERDUE_RESPONSE') THEN
2185: l_message_name := 'OIE_NOTES_IMG_OVERDUE_RESPONSE';

Line 2189: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

2185: l_message_name := 'OIE_NOTES_IMG_OVERDUE_RESPONSE';
2186: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2187: p_item_key,
2188: 'IMAGE_DAYS_OVERDUE');
2189: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2190: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2191: l_note_prefix := FND_MESSAGE.GET;
2192: END IF;
2193: EXCEPTION

Line 2190: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

2186: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2187: p_item_key,
2188: 'IMAGE_DAYS_OVERDUE');
2189: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2190: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2191: l_note_prefix := FND_MESSAGE.GET;
2192: END IF;
2193: EXCEPTION
2194: WHEN OTHERS THEN

Line 2191: l_note_prefix := FND_MESSAGE.GET;

2187: p_item_key,
2188: 'IMAGE_DAYS_OVERDUE');
2189: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2190: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2191: l_note_prefix := FND_MESSAGE.GET;
2192: END IF;
2193: EXCEPTION
2194: WHEN OTHERS THEN
2195: NULL;

Line 2247: l_debug_info := 'Retrieve Activity Attr FND Message';

2243:
2244: else
2245:
2246: -------------------------------------------------------------------
2247: l_debug_info := 'Retrieve Activity Attr FND Message';
2248: -------------------------------------------------------------------
2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2250: p_item_key,
2251: p_actid,

Line 2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,

2245:
2246: -------------------------------------------------------------------
2247: l_debug_info := 'Retrieve Activity Attr FND Message';
2248: -------------------------------------------------------------------
2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2250: p_item_key,
2251: p_actid,
2252: 'FND_MESSAGE');
2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',

Line 2252: 'FND_MESSAGE');

2248: -------------------------------------------------------------------
2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2250: p_item_key,
2251: p_actid,
2252: 'FND_MESSAGE');
2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',
2254: 'APWRECPT_MISSING_SENT','APWRECPT_IMG_MISSING_SENT',
2255: 'APWRECPT_RECEIVED_SENT','APWRECPT_IMG_RECEIVED_SENT')) then
2256:

Line 2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',

2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2250: p_item_key,
2251: p_actid,
2252: 'FND_MESSAGE');
2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',
2254: 'APWRECPT_MISSING_SENT','APWRECPT_IMG_MISSING_SENT',
2255: 'APWRECPT_RECEIVED_SENT','APWRECPT_IMG_RECEIVED_SENT')) then
2256:
2257: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then

Line 2257: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then

2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',
2254: 'APWRECPT_MISSING_SENT','APWRECPT_IMG_MISSING_SENT',
2255: 'APWRECPT_RECEIVED_SENT','APWRECPT_IMG_RECEIVED_SENT')) then
2256:
2257: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then
2258:
2259: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2260: p_item_key,
2261: 'DAYS_OVERDUE');

Line 2262: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

2258:
2259: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2260: p_item_key,
2261: 'DAYS_OVERDUE');
2262: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2264:
2265: elsif (l_fnd_message in ('APWRECPT_IMG_OVERDUE_SENT','APWRECPT_IMG_MISSING_SENT')) then
2266:

Line 2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

2259: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2260: p_item_key,
2261: 'DAYS_OVERDUE');
2262: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2264:
2265: elsif (l_fnd_message in ('APWRECPT_IMG_OVERDUE_SENT','APWRECPT_IMG_MISSING_SENT')) then
2266:
2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 2265: elsif (l_fnd_message in ('APWRECPT_IMG_OVERDUE_SENT','APWRECPT_IMG_MISSING_SENT')) then

2261: 'DAYS_OVERDUE');
2262: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2264:
2265: elsif (l_fnd_message in ('APWRECPT_IMG_OVERDUE_SENT','APWRECPT_IMG_MISSING_SENT')) then
2266:
2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2268: p_item_key,
2269: 'IMAGE_DAYS_OVERDUE');

Line 2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

2266:
2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2268: p_item_key,
2269: 'IMAGE_DAYS_OVERDUE');
2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

Line 2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2268: p_item_key,
2269: 'IMAGE_DAYS_OVERDUE');
2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date

Line 2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN

2268: p_item_key,
2269: 'IMAGE_DAYS_OVERDUE');
2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date
2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

Line 2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2272: elsif (l_fnd_message = 'APWRECPT_RECEIVED_SENT') THEN
2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date
2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2277: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2278: EXCEPTION

Line 2277: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));

2273: BEGIN
2274: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2275: SELECT trunc(receipts_received_date) INTO l_received_date
2276: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2277: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2278: EXCEPTION
2279: WHEN OTHERS THEN
2280: NULL;
2281: END;

Line 2282: elsif (l_fnd_message = 'APWRECPT_IMG_RECEIVED_SENT') THEN

2278: EXCEPTION
2279: WHEN OTHERS THEN
2280: NULL;
2281: END;
2282: elsif (l_fnd_message = 'APWRECPT_IMG_RECEIVED_SENT') THEN
2283: BEGIN
2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2285: SELECT trunc(image_receipts_received_date) INTO l_received_date
2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;

Line 2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);

2280: NULL;
2281: END;
2282: elsif (l_fnd_message = 'APWRECPT_IMG_RECEIVED_SENT') THEN
2283: BEGIN
2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2285: SELECT trunc(image_receipts_received_date) INTO l_received_date
2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2287: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2288: EXCEPTION

Line 2287: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));

2283: BEGIN
2284: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2285: SELECT trunc(image_receipts_received_date) INTO l_received_date
2286: FROM ap_expense_report_headers_all WHERE report_header_id = l_report_header_id;
2287: FND_MESSAGE.SET_TOKEN('RECEIVED_DATE', to_char(l_received_date));
2288: EXCEPTION
2289: WHEN OTHERS THEN
2290: NULL;
2291: END;

Line 2294: l_note_text := FND_MESSAGE.GET;

2290: NULL;
2291: END;
2292: end if;
2293:
2294: l_note_text := FND_MESSAGE.GET;
2295:
2296: ------------------------------------------------------------
2297: l_debug_info := 'store the fnd message as a note';
2298: ------------------------------------------------------------

Line 2297: l_debug_info := 'store the fnd message as a note';

2293:
2294: l_note_text := FND_MESSAGE.GET;
2295:
2296: ------------------------------------------------------------
2297: l_debug_info := 'store the fnd message as a note';
2298: ------------------------------------------------------------
2299: AP_WEB_NOTES_PKG.CreateERPrepToAudNote (
2300: p_report_header_id => l_report_header_id,
2301: p_note => l_note_text,

Line 2305: end if; -- l_fnd_message is not null

2301: p_note => l_note_text,
2302: p_lang => l_new_language_code
2303: );
2304:
2305: end if; -- l_fnd_message is not null
2306:
2307: end if; -- l_result_type is not null
2308:
2309: -------------------------------------------------------------------