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

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 98: * pItemException comes from fnd_log_unique_exceptions which is ultimately

94: * CRITICAL
95: * ERROR
96: * WARNING
97: *
98: * pItemException comes from fnd_log_unique_exceptions which is ultimately
99: * from the message dictionary.
100: *
101: *
102: * Below logic should be:

Line 110: * fnd_log_unique_exceptions is ERROR or CRITICAL.

106: * if setup to get a notification for WARNING return true (because that is the
107: * lowest level in the message dictionary).
108: *
109: * if setup to get a notification for ERROR return true if the severity in
110: * fnd_log_unique_exceptions is ERROR or CRITICAL.
111: *
112: * if setup to only get CRITICAL notifications only return true if
113: * fnd_log_unique_exceptions has a CRITICAL severity.
114: *

Line 113: * fnd_log_unique_exceptions has a CRITICAL severity.

109: * if setup to get a notification for ERROR return true if the severity in
110: * fnd_log_unique_exceptions is ERROR or CRITICAL.
111: *
112: * if setup to only get CRITICAL notifications only return true if
113: * fnd_log_unique_exceptions has a CRITICAL severity.
114: *
115: * */
116:
117:

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 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 270: fnd_log_messages flm,

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
274: WHERE

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 272: FND_LOG_UNIQUE_EXCEPTIONS flue,

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)
276: and flm.log_sequence = fle.log_sequence

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 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 313: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.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:
317: l_sub_list VARCHAR2(32000);

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 349: FROM FND_LOG_MESSAGES flm

345: INTO
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

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 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 352: ,FND_LOG_UNIQUE_EXCEPTIONS flue

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
356: AND fltc.TRANSACTION_CONTEXT_ID = flm.TRANSACTION_CONTEXT_ID

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 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 506: fnd_log_messages flm,

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,
510: fnd_lookups fl

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 508: FND_LOG_UNIQUE_EXCEPTIONS flue,

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
512: flm.log_sequence = document_id

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 556: document := FND_LOG.GET_TEXT(l_msg_id);

552: BEGIN
553: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDoc');
554:
555: l_msg_id := TO_NUMBER(document_id);
556: document := FND_LOG.GET_TEXT(l_msg_id);
557: --document := 'Rm test:document_id '|| document_id ;
558: document_type := 'text/plain';
559: fdebug('document' || document);
560:

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;

Line 580: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;

576: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
577:
578: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%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;

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

Line 598: fnd_log_messages flm,

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
602: flm.log_sequence = document_id