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_TRANSACTION_CONTEXT

Line 265: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%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;
268: BEGIN
269: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');

Line 266: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%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;
268: BEGIN
269: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');
270:

Line 267: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%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;
268: BEGIN
269: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');
270:
271: SELECT fa.application_short_name

Line 276: FROM fnd_log_transaction_context fltc,

272: , flue.severity, fltc.component_appl_id, fltc.component_type
273: , fltc.component_id
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

Line 316: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

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;
320: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;

Line 317: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

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;
320: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
321: l_category FND_LOG_EXCEPTIONS.CATEGORY%TYPE;

Line 318: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

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;
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;

Line 319: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_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;
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:

Line 357: ,FND_LOG_TRANSACTION_CONTEXT fltc

353: l_app_id, l_comp_type
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)

Line 500: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%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;
502: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
503: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
504: BEGIN

Line 501: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%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;
502: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
503: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
504: BEGIN
505: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');

Line 502: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%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;
502: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
503: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
504: BEGIN
505: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
506:

Line 512: FROM fnd_log_transaction_context fltc,

508: fa.application_short_name, fl.meaning,
509: fltc.component_appl_id, fltc.component_type, fltc.component_id
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,

Line 590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

586:
587: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
588: l_comp_type_d fnd_lookups.MEANING%TYPE;
589:
590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
593: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
594:

Line 591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

587: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
588: l_comp_type_d fnd_lookups.MEANING%TYPE;
589:
590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
593: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
594:
595: BEGIN

Line 592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

588: l_comp_type_d fnd_lookups.MEANING%TYPE;
589:
590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
593: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
594:
595: BEGIN
596: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');

Line 598: --10254432, added decode in the where clause. The row in fnd_log_transaction_context is

594:
595: BEGIN
596: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
597: ---Set up the Subject
598: --10254432, added decode in the where clause. The row in fnd_log_transaction_context is
599: --created in fnd_log_repository.INIT_TRANS_INT_WITH_CONTEXT and from what I can see there is
600: --no ICX_APP_MODULE there. But the lookups are seeded this way. It may be safest to just use
601: --a decode here in case anyone else is using 'FUNCTION' instead of changing the way the record is logged.
602: SELECT fa.application_short_name, fa.application_name

Line 607: FROM fnd_log_transaction_context fltc,

603: , flu.meaning, fltc.component_appl_id, fltc.component_type
604: , fltc.component_id
605: INTO
606: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
607: FROM fnd_log_transaction_context fltc,
608: fnd_log_messages flm,
609: fnd_application_vl fa,
610: fnd_lookups flu
611: WHERE