DBA Data[Home] [Help]

APPS.FND_OAM_KBF_SUBS dependencies on FND_LOG_TRANSACTION_CONTEXT

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

Line 259: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%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;
261: BEGIN
262: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');
263:

Line 260: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%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;
261: BEGIN
262: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');
263:
264: SELECT fa.application_short_name

Line 269: FROM fnd_log_transaction_context fltc,

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

Line 309: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

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

Line 310: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

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

Line 311: l_comp_type_s FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

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

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

Line 350: ,FND_LOG_TRANSACTION_CONTEXT fltc

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

Line 493: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%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;
495: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
496: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
497: BEGIN

Line 494: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%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;
495: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
496: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
497: BEGIN
498: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');

Line 495: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%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;
495: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
496: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
497: BEGIN
498: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
499:

Line 505: FROM fnd_log_transaction_context fltc,

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

Line 583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;

579:
580: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
581: l_comp_type_d fnd_lookups.MEANING%TYPE;
582:
583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
586: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
587:

Line 584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

580: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
581: l_comp_type_d fnd_lookups.MEANING%TYPE;
582:
583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
586: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
587:
588: BEGIN

Line 585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

581: l_comp_type_d fnd_lookups.MEANING%TYPE;
582:
583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;
586: l_comp_fn FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
587:
588: BEGIN
589: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');

Line 597: FROM fnd_log_transaction_context fltc,

593: , flu.meaning, fltc.component_appl_id, fltc.component_type
594: , fltc.component_id
595: INTO
596: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
597: FROM fnd_log_transaction_context fltc,
598: fnd_log_messages flm,
599: fnd_application_vl fa,
600: fnd_lookups flu
601: WHERE