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_OAM_KBF_SUBS

Line 1: PACKAGE BODY FND_OAM_KBF_SUBS AS

1: PACKAGE BODY FND_OAM_KBF_SUBS AS
2: /* $Header: AFOAMSBB.pls 120.4.12020000.2 2012/07/03 13:01:28 rlandows ship $ */
3:
4:
5: --Common constants

Line 20: fdebug('In:FND_OAM_KBF_SUBS.HAS_NOTIFIED');

16: IS
17: l_retu BOOLEAN;
18: l_count NUMBER;
19: BEGIN
20: fdebug('In:FND_OAM_KBF_SUBS.HAS_NOTIFIED');
21: fdebug('pSubID:' || pSubID);
22: fdebug('pUniqueExId:' || pUniqueExId);
23:
24: select count(*) into l_count

Line 39: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');

35: fdebug('FALSE');
36: l_retu := FALSE;
37: END IF;
38:
39: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');
40: RETURN (l_retu);
41: EXCEPTION
42: WHEN NO_DATA_FOUND THEN
43: RETURN (FALSE);

Line 52: fdebug('In:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');

48: RETURN BOOLEAN
49: IS
50: l_retu BOOLEAN;
51: BEGIN
52: fdebug('In:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');
53: fdebug('pItemSub:' || pItemSub);
54: fdebug('pItemException:' || pItemException);
55:
56: IF TRIM(pItemSub) IS NULL THEN

Line 73: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');

69: fdebug('Return=' || 'False');
70: ELSE
71: fdebug('Return=' || 'TRUE');
72: END IF;
73: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS');
74: RETURN (l_retu);
75: EXCEPTION
76: WHEN NO_DATA_FOUND THEN
77: RETURN (FALSE);

Line 125: fdebug('In:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS_SEVERITY');

121: RETURN BOOLEAN
122: IS
123: l_retu BOOLEAN;
124: BEGIN
125: fdebug('In:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS_SEVERITY');
126: fdebug('pItemSub:' || pItemSub);
127: fdebug('pItemException:' || pItemException);
128:
129: IF TRIM(pItemSub) IS NULL THEN

Line 159: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS_SEVERITY');

155: ELSE
156: fdebug('Return=' || 'TRUE');
157: END IF;
158:
159: fdebug('Out:FND_OAM_KBF_SUBS.SHALL_ADD_SUBS_SEVERITY');
160: RETURN (l_retu);
161: EXCEPTION
162: WHEN NO_DATA_FOUND THEN
163: RETURN (FALSE);

Line 177: fdebug('In:FND_OAM_KBF_SUBS.retriveComponentInfo');

173: IS
174: l_comp_name FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
175: l_comp_display_name FND_APP_COMPONENTS_VL.DISPLAY_NAME%TYPE;
176: BEGIN
177: fdebug('In:FND_OAM_KBF_SUBS.retriveComponentInfo');
178: fdebug('app_id=' || app_id || ' comp_type=' || comp_type || ' comp_id=' || comp_id );
179:
180: IF (comp_type = 'CONCURRENT_PROGRAM') THEN
181: SELECT

Line 253: fdebug('OUT:FND_OAM_KBF_SUBS.retriveComponentInfo');

249: comp_display_name :=l_comp_display_name;
250:
251: fdebug('Component Name=' || l_comp_name || ' Component Display Name=' || l_comp_display_name);
252:
253: fdebug('OUT:FND_OAM_KBF_SUBS.retriveComponentInfo');
254: END retriveComponentInfo;
255:
256: --------------------------------------------------------------------------------
257: procedure setWFAttributes(itemtype in varchar2,

Line 269: fdebug('In:FND_OAM_KBF_SUBS.setWFAttributes');

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

Line 305: fdebug('Out:FND_OAM_KBF_SUBS.setWFAttributes');

301: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'APP_SHORT_NAME', l_app_sn);
302: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'COMP_SHORT_NAME', l_comp_sn);
303: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'SEVERITY', l_severity);
304:
305: fdebug('Out:FND_OAM_KBF_SUBS.setWFAttributes');
306: END setWFAttributes;
307: --------------------------------------------------------------------------------
308: PROCEDURE createSubList(itemtype in varchar2,
309: itemkey in varchar2,

Line 346: fdebug('In:FND_OAM_KBF_SUBS.CreateSubList');

342: OR(application_id IS NULL)
343: ;
344:
345: BEGIN
346: fdebug('In:FND_OAM_KBF_SUBS.CreateSubList');
347: fdebug('itemkey:' || itemkey);
348:
349: SELECT fltc.COMPONENT_APPL_ID, fltc.COMPONENT_TYPE
350: ,flue.CATEGORY, flue.SEVERITY

Line 449: l_BE_SUBJECT := 'plsql:FND_OAM_KBF_SUBS.createSubject/' || itemkey;

445:
446: --Sets other attributes as app short name severity etc.
447: setWFAttributes(itemtype, itemkey);
448:
449: l_BE_SUBJECT := 'plsql:FND_OAM_KBF_SUBS.createSubject/' || itemkey;
450: fdebug('l_BE_SUBJECT=' || l_BE_SUBJECT);
451: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MAIL_SUBJECT'
452: , l_BE_SUBJECT);
453:

Line 454: l_BE_MESSAGE1 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDoc/' || itemkey;

450: fdebug('l_BE_SUBJECT=' || l_BE_SUBJECT);
451: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MAIL_SUBJECT'
452: , l_BE_SUBJECT);
453:
454: l_BE_MESSAGE1 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDoc/' || itemkey;
455: fdebug('l_BE_MESSAGE1=' || l_BE_MESSAGE1);
456: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MESSAGE1'
457: , l_BE_MESSAGE1);
458:

Line 459: l_BE_MESSAGE2 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDocPart1/' || itemkey;

455: fdebug('l_BE_MESSAGE1=' || l_BE_MESSAGE1);
456: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MESSAGE1'
457: , l_BE_MESSAGE1);
458:
459: l_BE_MESSAGE2 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDocPart1/' || itemkey;
460: fdebug('l_BE_MESSAGE2=' || l_BE_MESSAGE2);
461: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'EMAIL_BODY_PART1'
462: , l_BE_MESSAGE2);
463:

Line 475: fdebug('Out:FND_OAM_KBF_SUBS.CreateSubList');

471:
472:
473: resultout := l_sub_list;
474:
475: fdebug('Out:FND_OAM_KBF_SUBS.CreateSubList');
476: --- EXCEPTION
477: --- WHEN OTHERS THEN
478: --- err_num := SQLCODE;
479: --- err_msg := SUBSTR(SQLERRM, 1, 1000);

Line 480: --- fdebug('Error:FND_OAM_KBF_SUBS.CreateSubList.');

476: --- EXCEPTION
477: --- WHEN OTHERS THEN
478: --- err_num := SQLCODE;
479: --- err_msg := SUBSTR(SQLERRM, 1, 1000);
480: --- fdebug('Error:FND_OAM_KBF_SUBS.CreateSubList.');
481: --- fdebug('Error Num: ' || err_num);
482: --- fdebug('Error Msg: ' || err_msg);
483:
484: --- raise;

Line 505: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocSubject');

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

Line 541: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');

537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
539:
540: fdebug('Subject:'|| document);
541: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
542: /*
543: EXCEPTION
544: WHEN OTHERS THEN
545: fdebug('Error:FND_OAM_KBF_SUBS.createBusExcepDocSubject.');

Line 545: fdebug('Error:FND_OAM_KBF_SUBS.createBusExcepDocSubject.');

541: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
542: /*
543: EXCEPTION
544: WHEN OTHERS THEN
545: fdebug('Error:FND_OAM_KBF_SUBS.createBusExcepDocSubject.');
546: raise;
547: */
548: END createSubject;
549:

Line 560: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDoc');

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);
563: document := FND_LOG.GET_TEXT(l_msg_id);
564: --document := 'Rm test:document_id '|| document_id ;

Line 568: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDoc');

564: --document := 'Rm test:document_id '|| document_id ;
565: document_type := 'text/plain';
566: fdebug('document' || document);
567:
568: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDoc');
569: END createBusExcepDoc;
570:
571:
572:

Line 596: fdebug('In:FND_OAM_KBF_SUBS.createBusExcepDocPart1');

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

Line 656: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');

652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
653: --fdebug('document' || document);
654: end if;
655:
656: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
657: END createBusExcepDocPart1;
658:
659:
660:

Line 682: fdebug('In:FND_OAM_KBF_SUBS.raise_oamEvent');

678: RETURN VARCHAR2
679: IS
680: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
681: BEGIN
682: fdebug('In:FND_OAM_KBF_SUBS.raise_oamEvent');
683:
684:
685: wf_event.AddParameterToList(p_name=>'ORG_ID', p_value=>'Rm Org Id', p_parameterlist=>l_parameter_list);
686:

Line 697: fdebug('Out:FND_OAM_KBF_SUBS.raise_oamEvent');

693: p_event_key => v_comm,
694: p_parameters => l_parameter_list);
695: l_parameter_list.DELETE;
696: commit;
697: fdebug('Out:FND_OAM_KBF_SUBS.raise_oamEvent');
698:
699: return v_comm || ' success ';
700: -- END;
701: exception

Line 718: END FND_OAM_KBF_SUBS;

714:
715:
716:
717: --End Functions
718: END FND_OAM_KBF_SUBS;