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.ZPB_EXCEPTION_ALERT dependencies on ZPB_EXCEPTION_ALERT

Line 1: PACKAGE BODY ZPB_EXCEPTION_ALERT AS

1: PACKAGE BODY ZPB_EXCEPTION_ALERT AS
2: /* $Header: zpbwfexc.plb 120.4 2007/12/04 16:23:03 mbhat ship $ */
3:
4: Owner varchar2(30);
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'zpb_exception_alert';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'zpb_exception_alert';

1: PACKAGE BODY ZPB_EXCEPTION_ALERT AS
2: /* $Header: zpbwfexc.plb 120.4 2007/12/04 16:23:03 mbhat ship $ */
3:
4: Owner varchar2(30);
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'zpb_exception_alert';
6:
7: -- Directly called by WF function Activity
8: procedure EVALUATE_RESULTS (itemtype in varchar2,
9: itemkey in varchar2,

Line 329: 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'||

325: wf_engine.SetItemAttrText(itemtype => itemtype,
326: itemkey => NEWItemKey,
327: aname => 'EXCEPLIST',
328: avalue =>
329: 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'||
330: TO_CHAR(taskID)||':'||NEWItemKey);
331:
332: if ntfTarget = 'SPECIFIED' then
333: -- this will populate wf attrs and WF Ad Hoc role with users.

Line 334: ZPB_EXCEPTION_ALERT.SET_SPECIFIED_USERS(ExcType, AuthorID, itemtype, NEWItemkey, taskID, InstanceID);

330: TO_CHAR(taskID)||':'||NEWItemKey);
331:
332: if ntfTarget = 'SPECIFIED' then
333: -- this will populate wf attrs and WF Ad Hoc role with users.
334: ZPB_EXCEPTION_ALERT.SET_SPECIFIED_USERS(ExcType, AuthorID, itemtype, NEWItemkey, taskID, InstanceID);
335:
336: elsif ntfTarget = 'OWNER_OF_AC' then
337:
338: -- BUSINESS PROCESS OWNER => OWNER_OF_AC

Line 374: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

370: avalue => RoleName);
371: end if;
372:
373: -- reads parameters and sets attributes for this process
374: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
375:
376: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
377: Itemkey => NEWItemKey,
378: aname => 'ACID',

Line 431: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);

427: return;
428:
429: exception
430: when others then
431: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);
432: raise;
433:
434: end FYI_NOTIFICATIONS;
435:

Line 510: ZPB_EXCEPTION_ALERT.FYI_BY_OWNER(itemtype, itemkey, taskID);

506: if NtfType = 'N' then
507:
508: if ntfTarget = 'DATA_OWNERS' then
509: -- this will populate wf attrs and start the NTF Workflow to send FYI for data owners.
510: ZPB_EXCEPTION_ALERT.FYI_BY_OWNER(itemtype, itemkey, taskID);
511: --after all dataowner get their ntfs send one to author if type = analyst.
512:
513: if ExcType = 'A' then
514: -- overloaded ntfTarget type to included JUST_AUTHOR

Line 515: ZPB_EXCEPTION_ALERT.FYI_NOTIFICATIONS('JUST_AUTHOR', itemtype, itemkey, taskID);

511: --after all dataowner get their ntfs send one to author if type = analyst.
512:
513: if ExcType = 'A' then
514: -- overloaded ntfTarget type to included JUST_AUTHOR
515: ZPB_EXCEPTION_ALERT.FYI_NOTIFICATIONS('JUST_AUTHOR', itemtype, itemkey, taskID);
516: end if;
517: resultout := 'COMPLETE';
518: else
519: -- this will populate wf attrs and start the NTF Workflow which send the NTF.

Line 520: ZPB_EXCEPTION_ALERT.FYI_NOTIFICATIONS(ntfTarget, itemtype, itemkey, taskID);

516: end if;
517: resultout := 'COMPLETE';
518: else
519: -- this will populate wf attrs and start the NTF Workflow which send the NTF.
520: ZPB_EXCEPTION_ALERT.FYI_NOTIFICATIONS(ntfTarget, itemtype, itemkey, taskID);
521: resultout := 'COMPLETE';
522: end if;
523:
524: elsif NtfType = 'Y' then

Line 563: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_OWNER(itemtype, itemkey, taskID);

559:
560: if ntfTarget = 'DATA_OWNERS' then
561: -- this will populate wf attrs and start the NTF Workflow to send Exp NTFs.
562: -- Note: itemkey is ParentItemkey
563: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_OWNER(itemtype, itemkey, taskID);
564: resultout := 'COMPLETE';
565: elsif ntfTarget = 'SPECIFIED' then
566: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED(itemtype, itemkey, taskID);
567: resultout := 'COMPLETE';

Line 566: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED(itemtype, itemkey, taskID);

562: -- Note: itemkey is ParentItemkey
563: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_OWNER(itemtype, itemkey, taskID);
564: resultout := 'COMPLETE';
565: elsif ntfTarget = 'SPECIFIED' then
566: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED(itemtype, itemkey, taskID);
567: resultout := 'COMPLETE';
568: elsif ntfTarget = 'OWNER_OF_AC' then
569: ZPB_EXCEPTION_ALERT.EXPL_BY_ACOWNER(itemtype, itemkey, taskID);
570: resultout := 'COMPLETE';

Line 569: ZPB_EXCEPTION_ALERT.EXPL_BY_ACOWNER(itemtype, itemkey, taskID);

565: elsif ntfTarget = 'SPECIFIED' then
566: ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED(itemtype, itemkey, taskID);
567: resultout := 'COMPLETE';
568: elsif ntfTarget = 'OWNER_OF_AC' then
569: ZPB_EXCEPTION_ALERT.EXPL_BY_ACOWNER(itemtype, itemkey, taskID);
570: resultout := 'COMPLETE';
571: end if;
572:
573:

Line 625: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_BEGEXCPRUN');

621: */
622:
623: -- Begining run of exception request
624:
625: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_BEGEXCPRUN');
626:
627: zpb_excp_pvt.run_exception(p_api_version => 1.0,
628: p_init_msg_list => FND_API.G_FALSE,
629: p_commit => FND_API.G_TRUE,

Line 638: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_COMPEXCPRUN');

634: p_task_id => taskID,
635: p_user_id => UserID);
636:
637: -- Successfully completed run of exception request
638: ZPB_LOG.WRITE_EVENT_TR ('ZPB_EXCEPTION_ALERT.WF_RUN_EXCEPTION', 'ZPB_WF_COMPEXCPRUN');
639:
640: retcode :='0';
641: return;
642:

Line 738: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEPTION_LIST',ItemType, ItemKey);

734: return;
735:
736: exception
737: when others then
738: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEPTION_LIST',ItemType, ItemKey);
739: raise;
740:
741:
742: END EXCEPTION_LIST;

Line 862: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEPTION_BY_OWNER',ItemType, ItemKey);

858: return;
859:
860: exception
861: when others then
862: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEPTION_BY_OWNER',ItemType, ItemKey);
863: raise;
864:
865: END EXCEPTION_BY_OWNER;
866:

Line 1060: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXP_EXCEP_BY_OWNER/' || TO_CHAR(taskID) || ':' || thisOwner);

1056: -- plsql document procedure
1057: wf_engine.SetItemAttrText(itemtype => itemtype,
1058: itemkey => NEWItemKey,
1059: aname => 'EXCEPLIST',
1060: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXP_EXCEP_BY_OWNER/' || TO_CHAR(taskID) || ':' || thisOwner);
1061:
1062: -- plsql document procedure
1063: wf_engine.SetItemAttrText(itemtype => itemtype,
1064: itemkey => NEWItemKey,

Line 1066: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );

1062: -- plsql document procedure
1063: wf_engine.SetItemAttrText(itemtype => itemtype,
1064: itemkey => NEWItemKey,
1065: aname => 'RESPNOTE',
1066: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
1067:
1068:
1069: -- reads parameters and sets attributes for this process
1070: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

Line 1070: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

1066: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
1067:
1068:
1069: -- reads parameters and sets attributes for this process
1070: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
1071:
1072: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
1073: Itemkey => NEWItemKey,
1074: aname => 'ACID',

Line 1154: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);

1150: return;
1151:
1152: exception
1153: when others then
1154: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);
1155: raise;
1156:
1157: end EXPLANATION_BY_OWNER;
1158:

Line 1243: wf_core.context('ZPB_EXCEPTION_ALERT','EXP_EXCEP_BY_OWNER',ItemType, ItemKey);

1239: return;
1240:
1241: exception
1242: when others then
1243: wf_core.context('ZPB_EXCEPTION_ALERT','EXP_EXCEP_BY_OWNER',ItemType, ItemKey);
1244: raise;
1245:
1246: END EXP_EXCEP_BY_OWNER;
1247:

Line 1405: WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.MANAGE_RESPONSE', itemtype, itemkey, to_char(actid), funcmode);

1401: return;
1402:
1403: exception
1404: when others then
1405: WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.MANAGE_RESPONSE', itemtype, itemkey, to_char(actid), funcmode);
1406: raise;
1407:
1408: end MANAGE_RESPONSE;
1409:

Line 1515: wf_core.context('ZPB_EXCEPTION_ALERT','SHOW_RESP',ItemType, ItemKey);

1511: return;
1512:
1513: exception
1514: when others then
1515: wf_core.context('ZPB_EXCEPTION_ALERT','SHOW_RESP',ItemType, ItemKey);
1516: raise;
1517:
1518: END SHOW_RESP;
1519:

Line 1739: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'|| TO_CHAR(taskID)||':'||NEWItemKey);

1735: -- plsql document procedure
1736: wf_engine.SetItemAttrText(itemtype => itemtype,
1737: itemkey => NEWItemKey,
1738: aname => 'EXCEPLIST',
1739: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'|| TO_CHAR(taskID)||':'||NEWItemKey);
1740:
1741: -- plsql document procedure
1742: wf_engine.SetItemAttrText(itemtype => itemtype,
1743: itemkey => NEWItemKey,

Line 1745: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );

1741: -- plsql document procedure
1742: wf_engine.SetItemAttrText(itemtype => itemtype,
1743: itemkey => NEWItemKey,
1744: aname => 'RESPNOTE',
1745: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
1746:
1747:
1748: -- reads parameters and sets attributes for this process
1749: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

Line 1749: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

1745: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
1746:
1747:
1748: -- reads parameters and sets attributes for this process
1749: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
1750:
1751: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
1752: Itemkey => NEWItemKey,
1753: aname => 'ACID',

Line 1837: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);

1833: return;
1834:
1835: exception
1836: when others then
1837: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.EXPLANATION_BY_SPECIFIED', itemtype, itemkey, to_char(actid), funcmode);
1838: raise;
1839:
1840: end EXPLANATION_BY_SPECIFIED;
1841:

Line 2084: wf_core.context('ZPB_EXCEPTION_ALERT','NON_RESPONDERS',ItemType, ItemKey);

2080:
2081: exception
2082:
2083: when others then
2084: wf_core.context('ZPB_EXCEPTION_ALERT','NON_RESPONDERS',ItemType, ItemKey);
2085: raise;
2086:
2087: end NON_RESPONDERS;
2088:

Line 2330: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEP_NTF_LIST/' || TO_CHAR(taskID) || ':' || NID || ':' || thisOwner);

2326: -- plsql document procedure
2327: wf_engine.SetItemAttrText(itemtype => itemtype,
2328: itemkey => NEWItemKey,
2329: aname => 'EXCEPLIST',
2330: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEP_NTF_LIST/' || TO_CHAR(taskID) || ':' || NID || ':' || thisOwner);
2331:
2332: -- plsql document procedure
2333: wf_engine.SetItemAttrText(itemtype => itemtype,
2334: itemkey => NEWItemKey,

Line 2336: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );

2332: -- plsql document procedure
2333: wf_engine.SetItemAttrText(itemtype => itemtype,
2334: itemkey => NEWItemKey,
2335: aname => 'RESPNOTE',
2336: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
2337:
2338: -- reads parameters and sets attributes for this process
2339: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
2340:

Line 2339: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

2335: aname => 'RESPNOTE',
2336: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
2337:
2338: -- reads parameters and sets attributes for this process
2339: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
2340:
2341: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
2342: Itemkey => NEWItemKey,
2343: aname => 'ACID',

Line 2584: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEP_NTF_LIST',ItemType, ItemKey);

2580: return;
2581:
2582: exception
2583: when others then
2584: wf_core.context('ZPB_EXCEPTION_ALERT','EXCEP_NTF_LIST',ItemType, ItemKey);
2585: raise;
2586:
2587: END EXCEP_NTF_LIST;
2588:

Line 2735: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXP_EXCEP_BY_OWNER/' || TO_CHAR(taskID) || ':' || thisOwner);

2731: -- plsql document procedure
2732: wf_engine.SetItemAttrText(itemtype => itemtype,
2733: itemkey => NEWItemKey,
2734: aname => 'EXCEPLIST',
2735: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXP_EXCEP_BY_OWNER/' || TO_CHAR(taskID) || ':' || thisOwner);
2736:
2737:
2738: -- reads parameters and sets attributes for this process
2739: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

Line 2739: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

2735: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXP_EXCEP_BY_OWNER/' || TO_CHAR(taskID) || ':' || thisOwner);
2736:
2737:
2738: -- reads parameters and sets attributes for this process
2739: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
2740:
2741: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
2742: Itemkey => NEWItemKey,
2743: aname => 'ACID',

Line 2786: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_BY_OWNER', itemtype, itemkey, to_char(actid), funcmode);

2782: return;
2783:
2784: exception
2785: when others then
2786: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.FYI_BY_OWNER', itemtype, itemkey, to_char(actid), funcmode);
2787: raise;
2788:
2789: end FYI_BY_OWNER;
2790:

Line 2974: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'|| TO_CHAR(taskID)||':'||NEWItemKey);

2970: -- plsql document procedure
2971: wf_engine.SetItemAttrText(itemtype => itemtype,
2972: itemkey => NEWItemKey,
2973: aname => 'EXCEPLIST',
2974: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.EXCEPTION_LIST/'|| TO_CHAR(taskID)||':'||NEWItemKey);
2975:
2976: -- plsql document procedure
2977: wf_engine.SetItemAttrText(itemtype => itemtype,
2978: itemkey => NEWItemKey,

Line 2980: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );

2976: -- plsql document procedure
2977: wf_engine.SetItemAttrText(itemtype => itemtype,
2978: itemkey => NEWItemKey,
2979: aname => 'RESPNOTE',
2980: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
2981:
2982:
2983: -- reads parameters and sets attributes for this process
2984: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

Line 2984: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);

2980: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.SHOW_RESP/' || NEWitemkey );
2981:
2982:
2983: -- reads parameters and sets attributes for this process
2984: ZPB_EXCEPTION_ALERT.SET_ATTRIBUTES(itemtype, NEWItemkey, taskID);
2985:
2986: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
2987: Itemkey => NEWItemKey,
2988: aname => 'ACID',

Line 3065: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.EXPL_BY_ACOWNER', itemtype, itemkey, to_char(actid), funcmode);

3061: return;
3062:
3063: exception
3064: when others then
3065: -- WF_CORE.CONTEXT('ZPB_EXCEPTION_ALERT.EXPL_BY_ACOWNER', itemtype, itemkey, to_char(actid), funcmode);
3066: raise;
3067:
3068: end EXPL_BY_ACOWNER;
3069:

Line 3071: end ZPB_EXCEPTION_ALERT;

3067:
3068: end EXPL_BY_ACOWNER;
3069:
3070:
3071: end ZPB_EXCEPTION_ALERT;