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 1830: - FND_MESSAGE contains the specific FND message to store

1826: The following is gathered from the WF:
1827: - RESULT_TYPE contains the lookup type for the result of the Notification.
1828: - RESULT_CODE contains the lookup code for the result of the Notification.
1829: - RESPONSE contains the respond attr for the Notification.
1830: - FND_MESSAGE contains the specific FND message to store
1831:
1832: The Preparer-Auditor note is stored in the form of:
1833: :
1834: */

Line 1846: l_fnd_message fnd_new_messages.message_name%type;

1842: ----------------------------------------------------------------------
1843: l_report_header_id number;
1844: l_debug_info VARCHAR2(200);
1845:
1846: l_fnd_message fnd_new_messages.message_name%type;
1847: l_note_text varchar2(2000);
1848: l_days_overdue number;
1849:
1850: l_message_name fnd_new_messages.message_name%type;

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

1960: l_message_name := 'OIE_NOTES_PREPARER_RESPONSE';
1961:
1962: begin
1963: -------------------------------------------------------------------
1964: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
1965: -------------------------------------------------------------------
1966: select message_text
1967: into l_note_prefix
1968: from fnd_new_messages

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

1971: and language_code = l_new_language_code;
1972:
1973: exception
1974: when no_data_found then
1975: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
1976: l_note_prefix := FND_MESSAGE.GET;
1977: end;
1978:
1979: -------------------------------------------------------------------

Line 1976: l_note_prefix := FND_MESSAGE.GET;

1972:
1973: exception
1974: when no_data_found then
1975: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
1976: l_note_prefix := FND_MESSAGE.GET;
1977: end;
1978:
1979: -------------------------------------------------------------------
1980: l_debug_info := 'Retrieve Activity Attr Result Code';

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

2023:
2024: else
2025:
2026: -------------------------------------------------------------------
2027: l_debug_info := 'Retrieve Activity Attr FND Message';
2028: -------------------------------------------------------------------
2029: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2030: p_item_key,
2031: p_actid,

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

2025:
2026: -------------------------------------------------------------------
2027: l_debug_info := 'Retrieve Activity Attr FND Message';
2028: -------------------------------------------------------------------
2029: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2030: p_item_key,
2031: p_actid,
2032: 'FND_MESSAGE');
2033:

Line 2032: 'FND_MESSAGE');

2028: -------------------------------------------------------------------
2029: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2030: p_item_key,
2031: p_actid,
2032: 'FND_MESSAGE');
2033:
2034: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then
2035:
2036: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

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

2030: p_item_key,
2031: p_actid,
2032: 'FND_MESSAGE');
2033:
2034: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then
2035:
2036: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2037: p_item_key,
2038: 'DAYS_OVERDUE');

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

2036: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2037: p_item_key,
2038: 'DAYS_OVERDUE');
2039:
2040: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2041: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2042: l_note_text := FND_MESSAGE.GET;
2043:
2044: ------------------------------------------------------------

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

2037: p_item_key,
2038: 'DAYS_OVERDUE');
2039:
2040: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2041: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2042: l_note_text := FND_MESSAGE.GET;
2043:
2044: ------------------------------------------------------------
2045: l_debug_info := 'store the fnd message as a note';

Line 2042: l_note_text := FND_MESSAGE.GET;

2038: 'DAYS_OVERDUE');
2039:
2040: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2041: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2042: l_note_text := FND_MESSAGE.GET;
2043:
2044: ------------------------------------------------------------
2045: l_debug_info := 'store the fnd message as a note';
2046: ------------------------------------------------------------

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

2041: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2042: l_note_text := FND_MESSAGE.GET;
2043:
2044: ------------------------------------------------------------
2045: l_debug_info := 'store the fnd message as a note';
2046: ------------------------------------------------------------
2047: AP_WEB_NOTES_PKG.CreateERPrepToAudNote (
2048: p_report_header_id => l_report_header_id,
2049: p_note => l_note_text,

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

2049: p_note => l_note_text,
2050: p_lang => l_new_language_code
2051: );
2052:
2053: end if; -- l_fnd_message is not null
2054:
2055: end if; -- l_result_type is not null
2056:
2057: -------------------------------------------------------------------