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.FND_OAM_KBF_SUBS dependencies on FND_LOG_EXCEPTIONS

Line 13: , pUniqueExId IN FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE

9: --Private Functions
10: ---------------------------------------------------------------------------------
11: FUNCTION HAS_NOTIFIED(
12: pSubID IN FND_OAM_BIZEX_SUBSCRIP.SUBSCRIPTION_ID%TYPE
13: , pUniqueExId IN FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE
14: )
15: RETURN BOOLEAN
16: IS
17: l_retu BOOLEAN;

Line 256: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

252: IS
253: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
254: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
255: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
256: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
257: l_system VARCHAR2(200);
258: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
259: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
260: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 271: fnd_log_exceptions fle,

267: INTO
268: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
269: FROM fnd_log_transaction_context fltc,
270: fnd_log_messages flm,
271: fnd_log_exceptions fle,
272: FND_LOG_UNIQUE_EXCEPTIONS flue,
273: fnd_application fa
274: WHERE
275: flm.log_sequence = to_number(itemkey)

Line 307: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;

303: actid in number,
304: funcmode in varchar2,
305: resultout out NOCOPY varchar2)
306: IS
307: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;
308: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
309: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
310: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
311: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 308: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

304: funcmode in varchar2,
305: resultout out NOCOPY varchar2)
306: IS
307: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;
308: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
309: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
310: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
311: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
312: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 314: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;

310: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
311: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
312: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
313: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
314: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;
315: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
316:
317: l_sub_list VARCHAR2(32000);
318: l_role_name VARCHAR2(2000);

Line 315: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

311: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
312: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
313: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
314: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;
315: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
316:
317: l_sub_list VARCHAR2(32000);
318: l_role_name VARCHAR2(2000);
319: l_display_name VARCHAR2(100);

Line 351: ,FND_LOG_EXCEPTIONS fle

347: ,l_category, l_severity
348: ,l_comp_id, l_unique_ex_id
349: FROM FND_LOG_MESSAGES flm
350: ,FND_LOG_TRANSACTION_CONTEXT fltc
351: ,FND_LOG_EXCEPTIONS fle
352: ,FND_LOG_UNIQUE_EXCEPTIONS flue
353: WHERE
354: flm.LOG_SEQUENCE = TO_NUMBER(itemkey)
355: AND fle.LOG_SEQUENCE = flm.LOG_SEQUENCE

Line 490: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

486: document_type in out NOCOPY varchar2)
487: IS
488: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
489: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
490: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
491: l_system VARCHAR2(200);
492:
493: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
494: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 507: fnd_log_exceptions fle,

503: INTO
504: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
505: FROM fnd_log_transaction_context fltc,
506: fnd_log_messages flm,
507: fnd_log_exceptions fle,
508: FND_LOG_UNIQUE_EXCEPTIONS flue,
509: fnd_application_vl fa,
510: fnd_lookups fl
511: WHERE

Line 551: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

547: display_type in varchar2,
548: document in out NOCOPY varchar2,
549: document_type in out NOCOPY varchar2)
550: IS
551: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
552: BEGIN
553: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDoc');
554:
555: l_msg_id := TO_NUMBER(document_id);

Line 572: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

568: display_type in varchar2,
569: document in out NOCOPY varchar2,
570: document_type in out NOCOPY varchar2)
571: IS
572: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
573: l_subject VARCHAR2(200);
574:
575: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
576: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;