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

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

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

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

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

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

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

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

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

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

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

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

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

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

559: BEGIN
560: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDoc');
561:
562: l_msg_id := TO_NUMBER(document_id);
563: document := FND_LOG.GET_TEXT(l_msg_id);
564: --document := 'Rm test:document_id '|| document_id ;
565: document_type := 'text/plain';
566: fdebug('document' || document);
567:

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;

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

583: l_app_fn FND_APPLICATION_VL.APPLICATION_NAME%TYPE;
584:
585: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%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;

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 599: --created in fnd_log_repository.INIT_TRANS_INT_WITH_CONTEXT and from what I can see there is

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
603: , flu.meaning, fltc.component_appl_id, fltc.component_type

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

Line 608: fnd_log_messages flm,

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