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.1.12010000.2 2008/08/12 18:45:30 tshort 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 246: fdebug('OUT:FND_OAM_KBF_SUBS.retriveComponentInfo');

242: comp_display_name :=l_comp_display_name;
243:
244: fdebug('Component Name=' || l_comp_name || ' Component Display Name=' || l_comp_display_name);
245:
246: fdebug('OUT:FND_OAM_KBF_SUBS.retriveComponentInfo');
247: END retriveComponentInfo;
248:
249: --------------------------------------------------------------------------------
250: procedure setWFAttributes(itemtype in varchar2,

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

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

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

294: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'APP_SHORT_NAME', l_app_sn);
295: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'COMP_SHORT_NAME', l_comp_sn);
296: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'SEVERITY', l_severity);
297:
298: fdebug('Out:FND_OAM_KBF_SUBS.setWFAttributes');
299: END setWFAttributes;
300: --------------------------------------------------------------------------------
301: PROCEDURE createSubList(itemtype in varchar2,
302: itemkey in varchar2,

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

335: OR(application_id IS NULL)
336: ;
337:
338: BEGIN
339: fdebug('In:FND_OAM_KBF_SUBS.CreateSubList');
340: fdebug('itemkey:' || itemkey);
341:
342: SELECT fltc.COMPONENT_APPL_ID, fltc.COMPONENT_TYPE
343: ,flue.CATEGORY, flue.SEVERITY

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

438:
439: --Sets other attributes as app short name severity etc.
440: setWFAttributes(itemtype, itemkey);
441:
442: l_BE_SUBJECT := 'plsql:FND_OAM_KBF_SUBS.createSubject/' || itemkey;
443: fdebug('l_BE_SUBJECT=' || l_BE_SUBJECT);
444: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MAIL_SUBJECT'
445: , l_BE_SUBJECT);
446:

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

443: fdebug('l_BE_SUBJECT=' || l_BE_SUBJECT);
444: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MAIL_SUBJECT'
445: , l_BE_SUBJECT);
446:
447: l_BE_MESSAGE1 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDoc/' || itemkey;
448: fdebug('l_BE_MESSAGE1=' || l_BE_MESSAGE1);
449: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MESSAGE1'
450: , l_BE_MESSAGE1);
451:

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

448: fdebug('l_BE_MESSAGE1=' || l_BE_MESSAGE1);
449: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'BE_MESSAGE1'
450: , l_BE_MESSAGE1);
451:
452: l_BE_MESSAGE2 := 'plsql:FND_OAM_KBF_SUBS.createBusExcepDocPart1/' || itemkey;
453: fdebug('l_BE_MESSAGE2=' || l_BE_MESSAGE2);
454: WF_ENGINE.SetItemAttrtext(itemtype, itemkey, 'EMAIL_BODY_PART1'
455: , l_BE_MESSAGE2);
456:

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

464:
465:
466: resultout := l_sub_list;
467:
468: fdebug('Out:FND_OAM_KBF_SUBS.CreateSubList');
469: --- EXCEPTION
470: --- WHEN OTHERS THEN
471: --- err_num := SQLCODE;
472: --- err_msg := SUBSTR(SQLERRM, 1, 1000);

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

469: --- EXCEPTION
470: --- WHEN OTHERS THEN
471: --- err_num := SQLCODE;
472: --- err_msg := SUBSTR(SQLERRM, 1, 1000);
473: --- fdebug('Error:FND_OAM_KBF_SUBS.CreateSubList.');
474: --- fdebug('Error Num: ' || err_num);
475: --- fdebug('Error Msg: ' || err_msg);
476:
477: --- raise;

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

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

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

530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
532:
533: fdebug('Subject:'|| document);
534: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
535: /*
536: EXCEPTION
537: WHEN OTHERS THEN
538: fdebug('Error:FND_OAM_KBF_SUBS.createBusExcepDocSubject.');

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

534: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
535: /*
536: EXCEPTION
537: WHEN OTHERS THEN
538: fdebug('Error:FND_OAM_KBF_SUBS.createBusExcepDocSubject.');
539: raise;
540: */
541: END createSubject;
542:

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

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

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

557: --document := 'Rm test:document_id '|| document_id ;
558: document_type := 'text/plain';
559: fdebug('document' || document);
560:
561: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDoc');
562: END createBusExcepDoc;
563:
564:
565:

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

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');
590: ---Set up the Subject
591:
592: SELECT fa.application_short_name, fa.application_name
593: , flu.meaning, fltc.component_appl_id, fltc.component_type

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

639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
641: --fdebug('document' || document);
642:
643: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
644: END createBusExcepDocPart1;
645:
646:
647:

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

665: RETURN VARCHAR2
666: IS
667: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
668: BEGIN
669: fdebug('In:FND_OAM_KBF_SUBS.raise_oamEvent');
670:
671:
672: wf_event.AddParameterToList(p_name=>'ORG_ID', p_value=>'Rm Org Id', p_parameterlist=>l_parameter_list);
673:

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

680: p_event_key => v_comm,
681: p_parameters => l_parameter_list);
682: l_parameter_list.DELETE;
683: commit;
684: fdebug('Out:FND_OAM_KBF_SUBS.raise_oamEvent');
685:
686: return v_comm || ' success ';
687: -- END;
688: exception

Line 705: END FND_OAM_KBF_SUBS;

701:
702:
703:
704: --End Functions
705: END FND_OAM_KBF_SUBS;