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 263: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

259: IS
260: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
261: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
262: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
263: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
264: l_system VARCHAR2(200);
265: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
266: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
267: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 278: fnd_log_exceptions fle,

274: INTO
275: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
276: FROM fnd_log_transaction_context fltc,
277: fnd_log_messages flm,
278: fnd_log_exceptions fle,
279: FND_LOG_UNIQUE_EXCEPTIONS flue,
280: fnd_application fa
281: WHERE
282: flm.log_sequence = to_number(itemkey)

Line 314: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;

310: actid in number,
311: funcmode in varchar2,
312: resultout out NOCOPY varchar2)
313: IS
314: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;
315: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
316: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
317: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
318: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 315: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

311: funcmode in varchar2,
312: resultout out NOCOPY varchar2)
313: IS
314: l_unique_ex_id FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE;
315: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
316: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
317: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
318: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
319: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 321: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;

317: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
318: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
319: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
320: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
321: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;
322: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
323:
324: l_sub_list VARCHAR2(32000);
325: l_role_name VARCHAR2(2000);

Line 322: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

318: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
319: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
320: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
321: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;
322: l_severity FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
323:
324: l_sub_list VARCHAR2(32000);
325: l_role_name VARCHAR2(2000);
326: l_display_name VARCHAR2(100);

Line 358: ,FND_LOG_EXCEPTIONS fle

354: ,l_category, l_severity
355: ,l_comp_id, l_unique_ex_id
356: FROM FND_LOG_MESSAGES flm
357: ,FND_LOG_TRANSACTION_CONTEXT fltc
358: ,FND_LOG_EXCEPTIONS fle
359: ,FND_LOG_UNIQUE_EXCEPTIONS flue
360: WHERE
361: flm.LOG_SEQUENCE = TO_NUMBER(itemkey)
362: AND fle.LOG_SEQUENCE = flm.LOG_SEQUENCE

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

493: document_type in out NOCOPY varchar2)
494: IS
495: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
496: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
497: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
498: l_system VARCHAR2(200);
499:
500: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
501: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 514: fnd_log_exceptions fle,

510: INTO
511: l_app_sn, l_severity, l_app_id, l_comp_type, l_comp_id
512: FROM fnd_log_transaction_context fltc,
513: fnd_log_messages flm,
514: fnd_log_exceptions fle,
515: FND_LOG_UNIQUE_EXCEPTIONS flue,
516: fnd_application_vl fa,
517: fnd_lookups fl
518: WHERE

Line 558: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

554: display_type in varchar2,
555: document in out NOCOPY varchar2,
556: document_type in out NOCOPY varchar2)
557: IS
558: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
559: BEGIN
560: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDoc');
561:
562: l_msg_id := TO_NUMBER(document_id);

Line 579: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;

575: display_type in varchar2,
576: document in out NOCOPY varchar2,
577: document_type in out NOCOPY varchar2)
578: IS
579: l_msg_id FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE;
580: l_subject VARCHAR2(200);
581:
582: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
583: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;