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

Line 1: PACKAGE BODY JTF_UM_WF_APPROVAL as

1: PACKAGE BODY JTF_UM_WF_APPROVAL as
2: /* $Header: JTFUMWFB.pls 120.11.12010000.4 2008/11/01 05:25:12 appldev ship $ */
3:
4: G_MODULE CONSTANT VARCHAR2(40) := 'JTF.UM.PLSQL.APPROVAL';
5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);

Line 123: raise_application_error (-20000, 'requester username is not found while calling JTF_UM_WF_APPROVAL.getRequesterUsername');

119: open getUserNameCursor;
120: fetch getUserNameCursor into requesterUsername;
121: if (getUserNameCursor%notfound) then
122: close getUserNameCursor;
123: raise_application_error (-20000, 'requester username is not found while calling JTF_UM_WF_APPROVAL.getRequesterUsername');
124: end if;
125: close getUserNameCursor;
126:
127: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequesterUsername API');

Line 153: raise_application_error (-20000, 'userId is not found while calling JTF_UM_WF_APPROVAL.getUserID');

149: open getUserIDCursor;
150: fetch getUserIDCursor into userId;
151: if (getUserIDCursor%notfound) then
152: close getUserIDCursor;
153: raise_application_error (-20000, 'userId is not found while calling JTF_UM_WF_APPROVAL.getUserID');
154: end if;
155: close getUserIDCursor;
156:
157: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getUserID API');

Line 362: raise_application_error (-20000, 'requestType is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

358: requesterUserID || ',' || requestRegID || ') API');
359:
360: -- Check input parameter
361: if (requestType is null) then
362: raise_application_error (-20000, 'requestType is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
363: end if;
364:
365: if (requestID is null) then
366: raise_application_error (-20000, 'requestID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

Line 366: raise_application_error (-20000, 'requestID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

362: raise_application_error (-20000, 'requestType is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
363: end if;
364:
365: if (requestID is null) then
366: raise_application_error (-20000, 'requestID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
367: end if;
368:
369: if (requesterUserID is null) then
370: raise_application_error (-20000, 'requesterUserID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

Line 370: raise_application_error (-20000, 'requesterUserID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

366: raise_application_error (-20000, 'requestID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
367: end if;
368:
369: if (requesterUserID is null) then
370: raise_application_error (-20000, 'requesterUserID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
371: end if;
372:
373: if (requestRegID is null) then
374: raise_application_error (-20000, 'requestRegID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

Line 374: raise_application_error (-20000, 'requestRegID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');

370: raise_application_error (-20000, 'requesterUserID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
371: end if;
372:
373: if (requestRegID is null) then
374: raise_application_error (-20000, 'requestRegID is null when calling JTF_UM_WF_APPROVAL.CreateProcess.');
375: end if;
376:
377: -- Get the approvalID
378: if (requestType = 'USERTYPE') then

Line 383: raise_application_error (-20000, 'ApprovalID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess requestType='||requestType||'.');

379: open usertypeApprovalCursor;
380: fetch usertypeApprovalCursor into approvalID;
381: if (usertypeApprovalCursor%notfound) then
382: close usertypeApprovalCursor;
383: raise_application_error (-20000, 'ApprovalID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess requestType='||requestType||'.');
384: end if;
385: close usertypeApprovalCursor;
386: requesterUsertypeID := requestId;
387: else

Line 392: raise_application_error (-20000, 'ApprovalID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess requestType='||requestType||'.');

388: open enrollApprovalCursor;
389: fetch enrollApprovalCursor into approvalID;
390: if (enrollApprovalCursor%notfound) then
391: close enrollApprovalCursor;
392: raise_application_error (-20000, 'ApprovalID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess requestType='||requestType||'.');
393: end if;
394: close enrollApprovalCursor;
395: -- Get the requesterUsertypeID
396: open getUsertypeIdCursor;

Line 400: raise_application_error (-20000, 'requesterUsertypeID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess.');

396: open getUsertypeIdCursor;
397: fetch getUsertypeIdCursor into requesterUsertypeID;
398: if (getUsertypeIdCursor%notfound) then
399: close getUsertypeIdCursor;
400: raise_application_error (-20000, 'requesterUsertypeID is not found when calling JTF_UM_WF_APPROVAL.CreateProcess.');
401: end if;
402: close getUsertypeIdCursor;
403: end if;
404:

Line 580: wf_core.context ('JTF_UM_WF_APPROVAL', 'Selector', item_type, item_key, to_char (activity_id), command);

576: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Selector API');
577:
578: exception
579: when others then
580: wf_core.context ('JTF_UM_WF_APPROVAL', 'Selector', item_type, item_key, to_char (activity_id), command);
581: raise;
582: end selector;
583:
584: --

Line 889: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode,

885: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
886:
887: exception
888: when MISSING_REQUESTER_USER_ID then
889: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode,
890: 'Requester User ID is missing in the FND_USER');
891: raise;
892: when others then
893: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode);

Line 893: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode);

889: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode,
890: 'Requester User ID is missing in the FND_USER');
891: raise;
892: when others then
893: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode);
894: raise;
895: end Initialization;
896:
897: /**

Line 1189: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectorApprover', itemtype,

1185: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
1186:
1187: exception
1188: when others then
1189: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectorApprover', itemtype,
1190: itemkey, to_char (actid), funcmode);
1191: raise;
1192: end SelectApprover;
1193:

Line 1287: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.GetApprover');

1283: x_itemtype || ',' || x_itemkey || ') API');
1284:
1285: -- check input parameter
1286: if (x_itemtype is null) then
1287: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.GetApprover');
1288: end if;
1289:
1290: if (x_itemkey is null) then
1291: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.GetApprover');

Line 1291: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.GetApprover');

1287: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.GetApprover');
1288: end if;
1289:
1290: if (x_itemkey is null) then
1291: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.GetApprover');
1292: end if;
1293:
1294: x_resultType := 'OK';
1295: -- Get the APPROVER_ID and APPROVAL_ID

Line 1378: wf_core.context ('JTF_UM_WF_APPROVAL', 'GetApprover', x_itemtype, x_itemkey);

1374: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1375:
1376: exception
1377: when others then
1378: wf_core.context ('JTF_UM_WF_APPROVAL', 'GetApprover', x_itemtype, x_itemkey);
1379: raise;
1380: end GetApprover;
1381:
1382: --

Line 1440: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectRequestType', itemtype, itemkey, to_char (actid), funcmode);

1436: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting SelectRequestType API');
1437:
1438: exception
1439: when others then
1440: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectRequestType', itemtype, itemkey, to_char (actid), funcmode);
1441: raise;
1442: end SelectRequestType;
1443:
1444: --

Line 1478: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.cancel_notification');

1474: p_itemtype || ',' || p_itemkey || ') API');
1475:
1476: -- check input parameter
1477: if (p_itemtype is null) then
1478: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.cancel_notification');
1479: end if;
1480:
1481: if (p_itemkey is null) then
1482: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.cancel_notification');

Line 1482: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.cancel_notification');

1478: raise_application_error (-20000, 'itemtype is null when calling JTF_UM_WF_APPROVAL.cancel_notification');
1479: end if;
1480:
1481: if (p_itemkey is null) then
1482: raise_application_error (-20000, 'itemkey is null when calling JTF_UM_WF_APPROVAL.cancel_notification');
1483: end if;
1484:
1485: -- Need to end all open notifications.
1486: open getNotificationID;

Line 1585: wf_core.context ('JTF_UM_WF_APPROVAL', 'initialize_fail_escalate', itemtype, itemkey, to_char (actid), funcmode);

1581: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting initialize_fail_escalate API');
1582:
1583: exception
1584: when others then
1585: wf_core.context ('JTF_UM_WF_APPROVAL', 'initialize_fail_escalate', itemtype, itemkey, to_char (actid), funcmode);
1586: raise;
1587: end initialize_fail_escalate;
1588:
1589: --

Line 1655: wf_core.context ('JTF_UM_WF_APPROVAL', 'WaitForApproval', itemtype, itemkey, to_char (actid), funcmode);

1651: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting WaitForApproval API');
1652:
1653: exception
1654: when others then
1655: wf_core.context ('JTF_UM_WF_APPROVAL', 'WaitForApproval', itemtype, itemkey, to_char (actid), funcmode);
1656: raise;
1657: end WaitForApproval;
1658:
1659: --

Line 1768: wf_core.context ('JTF_UM_WF_APPROVAL', 'post_notification', itemtype, itemkey, to_char (actid), funcmode);

1764: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting post_notification API');
1765:
1766: exception
1767: when others then
1768: wf_core.context ('JTF_UM_WF_APPROVAL', 'post_notification', itemtype, itemkey, to_char (actid), funcmode);
1769: raise;
1770: end post_notification;
1771:
1772: --

Line 1837: -- wf_core.context ('JTF_UM_WF_APPROVAL', 'store_delegate_flag', itemtype, itemkey, to_char (actid), funcmode);

1833: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting store_delegate_flag API');
1834:
1835: exception
1836: when others then
1837: -- wf_core.context ('JTF_UM_WF_APPROVAL', 'store_delegate_flag', itemtype, itemkey, to_char (actid), funcmode);
1838: raise;
1839:
1840: end store_delegate_flag;
1841:

Line 1899: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');

1895: itemtype || ',' || itemkey || ') API');
1896:
1897:
1898: if itemtype is null then
1899: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');
1900: end if;
1901:
1902: if itemkey is null then
1903: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');

Line 1903: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');

1899: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');
1900: end if;
1901:
1902: if itemkey is null then
1903: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.Do_Approve_Req.');
1904: end if;
1905:
1906: requesterUserID := wf_engine.GetItemAttrNumber (
1907: itemtype => itemtype,

Line 2046: wf_core.context ('JTF_UM_WF_APPROVAL', 'Approve_Req', itemtype, itemkey, to_char(actid), funcmode);

2042: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Approve_Req API');
2043:
2044: exception
2045: when others then
2046: wf_core.context ('JTF_UM_WF_APPROVAL', 'Approve_Req', itemtype, itemkey, to_char(actid), funcmode);
2047: raise;
2048: end Approve_Req;
2049:
2050: --

Line 2270: wf_core.context ('JTF_UM_WF_APPROVAL', 'Reject_Req', itemtype, itemkey, to_char(actid), funcmode);

2266: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Reject_Req API');
2267:
2268: exception
2269: when others then
2270: wf_core.context ('JTF_UM_WF_APPROVAL', 'Reject_Req', itemtype, itemkey, to_char(actid), funcmode);
2271: raise;
2272: end Reject_Req;
2273:
2274: --

Line 2362: wf_core.context ('JTF_UM_WF_APPROVAL', 'Can_Delegate', itemtype, itemkey, to_char (actid), funcmode, 'l_approver_userID='||to_char (l_approver_userID));

2358: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Can_Delegate API');
2359:
2360: exception
2361: when others then
2362: wf_core.context ('JTF_UM_WF_APPROVAL', 'Can_Delegate', itemtype, itemkey, to_char (actid), funcmode, 'l_approver_userID='||to_char (l_approver_userID));
2363: raise;
2364: end Can_Delegate;
2365:
2366: --

Line 2438: wf_core.context ('JTF_UM_WF_APPROVAL', 'CAN_ENROLLMENT_DELEGATE', itemtype, itemkey, to_char (actid), funcmode);

2434: p_message => l_procedure_name);
2435:
2436: exception
2437: when others then
2438: wf_core.context ('JTF_UM_WF_APPROVAL', 'CAN_ENROLLMENT_DELEGATE', itemtype, itemkey, to_char (actid), funcmode);
2439: raise;
2440: end can_enrollment_delegate;
2441:
2442: --

Line 2533: wf_core.context ('JTF_UM_WF_APPROVAL', l_procedure_name, itemtype, itemkey, to_char (actid), funcmode);

2529: p_message => l_procedure_name);
2530:
2531: exception
2532: when others then
2533: wf_core.context ('JTF_UM_WF_APPROVAL', l_procedure_name, itemtype, itemkey, to_char (actid), funcmode);
2534: raise;
2535: end universal_approvers_exists;
2536:
2537: --

Line 2645: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode, 'Usertype info is missing');

2641: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CHECK_EMAIL_NOTIFI_TYPE API');
2642:
2643: exception
2644: when MISSING_USERTYPE_INFO then
2645: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode, 'Usertype info is missing');
2646: raise;
2647: when others then
2648: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode);
2649: raise;

Line 2648: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode);

2644: when MISSING_USERTYPE_INFO then
2645: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode, 'Usertype info is missing');
2646: raise;
2647: when others then
2648: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode);
2649: raise;
2650: end CHECK_EMAIL_NOTIFI_TYPE;
2651:
2652: --

Line 2719: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');

2715: approverComment || ') API');
2716:
2717: -- check on the input
2718: if itemtype is null then
2719: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2720: end if;
2721:
2722: if itemkey is null then
2723: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');

Line 2723: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');

2719: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2720: end if;
2721:
2722: if itemkey is null then
2723: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2724: end if;
2725:
2726: if resultCode is null then
2727: raise_application_error (-20000, 'resultCode is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');

Line 2727: raise_application_error (-20000, 'resultCode is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');

2723: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2724: end if;
2725:
2726: if resultCode is null then
2727: raise_application_error (-20000, 'resultCode is null while calling JTF_UM_WF_APPROVAL.CompleteApprovalActivity.');
2728: end if;
2729:
2730: -- Check Request type
2731: request_type := wf_engine.GetItemAttrText (

Line 2814: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity',

2810: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CompleteApprovalActivity API');
2811:
2812: exception
2813: when UNKNOWN_REQUEST_TYPE then
2814: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity',
2815: itemtype, itemkey, resultCode, approverComment);
2816: raise;
2817: when others then
2818: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity', itemtype, itemkey, resultCode, approverComment);

Line 2818: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity', itemtype, itemkey, resultCode, approverComment);

2814: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity',
2815: itemtype, itemkey, resultCode, approverComment);
2816: raise;
2817: when others then
2818: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity', itemtype, itemkey, resultCode, approverComment);
2819: raise;
2820:
2821: end CompleteApprovalActivity;
2822:

Line 3013: raise_application_error (-20000, 'No Activity Found Failed at JTF_UM_WF_APPROVAL.Do_Complete_Approval_Activity ('

3009: wf_engine.CompleteActivity (p_itemtype, p_itemkey, act, wf_resultCode);
3010:
3011: else
3012:
3013: raise_application_error (-20000, 'No Activity Found Failed at JTF_UM_WF_APPROVAL.Do_Complete_Approval_Activity ('
3014: ||p_itemtype||','||p_itemkey||','||p_resultCode||','||p_approverComment
3015: ||','||p_act1||','||p_act2||','||p_act3||','||p_act4||','||p_act5||','||
3016: p_act6||')');
3017:

Line 3046: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.abort_process.');

3042: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering abort_process (' ||
3043: p_itemtype || ',' || p_itemkey || ') API');
3044:
3045: if p_itemtype is null then
3046: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.abort_process.');
3047: end if;
3048:
3049: if p_itemtype is null then
3050: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.abort_process.');

Line 3050: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.abort_process.');

3046: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.abort_process.');
3047: end if;
3048:
3049: if p_itemtype is null then
3050: raise_application_error (-20000, 'itemkey is null while calling JTF_UM_WF_APPROVAL.abort_process.');
3051: end if;
3052:
3053: wf_engine.ItemStatus (p_itemtype, p_itemkey, status, result);
3054: if (status <> 'COMPLETE') then

Line 3597: end JTF_UM_WF_APPROVAL;

3593:
3594: end get_approver_comment;
3595:
3596:
3597: end JTF_UM_WF_APPROVAL;