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_DEBUG_PUB

Line 5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(G_MODULE);

1: PACKAGE BODY JTF_UM_WF_APPROVAL as
2: /* $Header: JTFUMWFB.pls 120.19.12020000.2 2012/07/18 16:05:58 anurtrip 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);
6:
7:
8: /*
9: Internal procedure to check if a Workflow has started or not. The Workflow should have been

Line 45: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequestName (' ||

41: where subscription_id = x_subscription_id;
42:
43: begin
44:
45: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequestName (' ||
46: requestType || ',' || requestId || ') API');
47:
48: if requestType = 'USERTYPE' then
49: open getUsertypeName(requestId);

Line 58: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequestName API');

54: fetch getSubscriptionName into requestName;
55: close getSubscriptionName;
56: end if;
57:
58: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequestName API');
59:
60: return requestName;
61:
62: end getRequestName;

Line 82: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequestApplId (' ||

78: where subscription_id = x_subscription_id;
79:
80: begin
81:
82: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequestApplId (' ||
83: requestType || ',' || requestId || ') API');
84:
85: if requestType = 'USERTYPE' then
86: open getUsertypeApplID (requestId);

Line 95: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequestApplId API');

91: fetch getSubscriptionApplID into l_application_id;
92: close getSubscriptionApplID;
93: end if;
94:
95: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequestApplId API');
96:
97: return l_application_id;
98:
99: end getRequestApplId;

Line 116: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequesterUsername (' ||

112: -- Bug Fix: 4741111: Added the clause to look for pending users
113:
114: begin
115:
116: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getRequesterUsername (' ||
117: userID || ') API');
118:
119: open getUserNameCursor;
120: fetch getUserNameCursor into requesterUsername;

Line 127: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getRequesterUsername API');

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');
128:
129: return requesterUsername;
130: end getRequesterUsername;
131:

Line 146: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getUserID (' ||

142: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
143:
144: begin
145:
146: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering getUserID (' ||
147: userID || ') API');
148:
149: open getUserIDCursor;
150: fetch getUserIDCursor into userId;

Line 157: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting getUserID API');

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');
158:
159: return userId;
160: end getUserID;
161:

Line 184: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);

180:
181: begin
182:
183: -- Log the entering
184: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
185:
186: -- Log parameters
187: if l_is_debug_parameter_on then
188: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

Line 188: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

184: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
185:
186: -- Log parameters
187: if l_is_debug_parameter_on then
188: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
189: 'p_request_id=' || p_request_id);
190: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
191: 'p_request_type=' || p_request_type);
192: end if;

Line 190: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

186: -- Log parameters
187: if l_is_debug_parameter_on then
188: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
189: 'p_request_id=' || p_request_id);
190: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
191: 'p_request_type=' || p_request_type);
192: end if;
193:
194: l_application_id := getRequestApplId (p_request_type, p_request_id);

Line 201: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);

197: NAME => 'JTF_UM_APPROVAL_OWNER',
198: APPLICATION_ID => l_application_id,
199: SITE_LEVEL => true), 'SYSADMIN');
200:
201: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);
202:
203: return l_owner_username;
204:
205: end get_wf_owner_username;

Line 241: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);

237:
238: begin
239:
240: -- Log the entering
241: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
242:
243: -- Log parameters
244: if l_is_debug_parameter_on then
245: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

Line 245: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

241: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
242:
243: -- Log parameters
244: if l_is_debug_parameter_on then
245: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
246: 'p_user_id=' || p_user_id);
247: end if;
248: open getOrgNameAndNumber;
249: fetch getOrgNameAndNumber into x_org_name, x_org_number;

Line 253: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);

249: fetch getOrgNameAndNumber into x_org_name, x_org_number;
250: close getOrgNameAndNumber;
251:
252:
253: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);
254:
255: end get_org_info;
256:
257: --

Line 274: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering ValidateWF (' ||

270: l_format varchar2 (240);
271:
272: begin
273:
274: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering ValidateWF (' ||
275: itemtype || ') API');
276:
277: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_TYPE', l_atype, l_subtype, l_format);
278: wf_engine.getItemAttrInfo (itemtype, 'REQUEST_ID', l_atype, l_subtype, l_format);

Line 285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting ValidateWF API');

281: wf_engine.getItemAttrInfo (itemtype, 'APPROVAL_ID', l_atype, l_subtype, l_format);
282: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_ID', l_atype, l_subtype, l_format);
283: wf_engine.getItemAttrInfo (itemtype, 'APPROVER_COMMENT', l_atype, l_subtype, l_format);
284:
285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting ValidateWF API');
286:
287: exception
288: when others then
289: raise;

Line 356: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CreateProcess (' ||

352: --
353:
354: begin
355:
356: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CreateProcess (' ||
357: ownerUserId || ',' || requestType || ',' || requestID || ',' ||
358: requesterUserID || ',' || requestRegID || ') API');
359:
360: -- Check input parameter

Line 473: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CreateProcess API');

469: owner => processOwner);
470:
471:
472:
473: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CreateProcess API');
474:
475: end CreateProcess;
476:
477: --

Line 504: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering LaunchProcess (' ||

500: itemtype varchar2 (8);
501:
502: begin
503:
504: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering LaunchProcess (' ||
505: requestType || ',' || requestRegID || ') API');
506:
507: -- Get the WF item type from the reg table
508: -- If WF item type is missing, raise an exception.

Line 536: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting LaunchProcess API');

532:
533: wf_engine.startProcess (itemtype => itemType,
534: itemkey => to_char(requestRegID));
535:
536: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting LaunchProcess API');
537:
538: end LaunchProcess;
539:
540: --

Line 562: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Selector (' ||

558: resultout out NOCOPY varchar2) is
559: --
560: begin
561:
562: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Selector (' ||
563: item_type || ',' || item_key || ',' || activity_id || ',' ||
564: command || ') API');
565:
566: --

Line 576: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Selector API');

572: --
573: resultout := 'UM_APPROVAL';
574: end if;
575:
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);

Line 680: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Initialization (' ||

676:
677:
678: begin
679:
680: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Initialization (' ||
681: itemtype || ',' || itemkey || ',' || actid || ',' ||
682: funcmode || ') API');
683:
684: --

Line 891: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');

887:
888: resultout := 'COMPLETE:';
889: end if;
890:
891: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
892:
893: exception
894: when MISSING_REQUESTER_USER_ID then
895: wf_core.context ('JTF_UM_WF_APPROVAL', 'Initialization', itemtype, itemkey, to_char (actid), funcmode,

Line 977: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);

973:
974: begin
975:
976: -- Log the entering
977: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
978:
979: -- Log parameters
980: if l_is_debug_parameter_on then
981: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

Line 981: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

977: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
978:
979: -- Log parameters
980: if l_is_debug_parameter_on then
981: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
982: 'p_itemtype=' || p_itemtype);
983: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
984: 'p_itemkey=' || p_itemkey);
985: end if;

Line 983: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

979: -- Log parameters
980: if l_is_debug_parameter_on then
981: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
982: 'p_itemtype=' || p_itemtype);
983: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
984: 'p_itemkey=' || p_itemkey);
985: end if;
986:
987: -- to construct the roleName, we need the organization number

Line 1044: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);

1040: if l_uni_approver_not_found then
1041: x_role_name := null;
1042: end if;
1043:
1044: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);
1045:
1046: end get_org_ad_hoc_role;
1047:
1048: --

Line 1078: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering SelectApprover (' ||

1074: uniPrimaryUser fnd_profile_option_values.profile_option_value%type;
1075: l_approver_username_display varchar2 (100);
1076:
1077: begin
1078: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering SelectApprover (' ||
1079: itemtype || ',' || itemkey || ',' || actid || ',' ||
1080: funcmode || ') API');
1081:
1082: --

Line 1193: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');

1189: resultout := 'COMPLETE:';
1190: --
1191: end if;
1192:
1193: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
1194:
1195: exception
1196: when others then
1197: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectorApprover', itemtype,

Line 1294: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering GetApprover (' ||

1290: and hzr.object_table_name = 'HZ_PARTIES';
1291: --
1292: begin
1293:
1294: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering GetApprover (' ||
1295: x_itemtype || ',' || x_itemkey || ') API');
1296:
1297: -- check input parameter
1298: if (x_itemtype is null) then

Line 1367: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');

1363: if (nextOrgApproverInfoCursor%notfound) then
1364: -- No more approvers, result 'END' -
1365: x_resultType := 'END';
1366: close nextOrgApproverInfoCursor;
1367: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1368: return;
1369: end if;
1370: close nextOrgApproverInfoCursor;
1371: -- If we should use the default approvers, find the first / next one

Line 1380: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');

1376: if (nextApproverInfoCursor%notfound) then
1377: -- No more approvers, result 'END'
1378: x_resultType := 'END';
1379: close nextApproverInfoCursor;
1380: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1381: return;
1382: end if;
1383: close nextApproverInfoCursor;
1384: end if;

Line 1386: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');

1382: end if;
1383: close nextApproverInfoCursor;
1384: end if;
1385:
1386: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1387:
1388: exception
1389: when others then
1390: wf_core.context ('JTF_UM_WF_APPROVAL', 'GetApprover', x_itemtype, x_itemkey);

Line 1417: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Initialization (' ||

1413: requestType varchar2 (10);
1414: --
1415: begin
1416:
1417: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Initialization (' ||
1418: itemtype || ',' || itemkey || ',' || actid || ',' ||
1419: funcmode || ') API');
1420:
1421: --

Line 1448: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting SelectRequestType API');

1444: elsif (funcmode = 'TIMEOUT') then
1445: resultout := 'COMPLETE:';
1446: end if;
1447:
1448: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting SelectRequestType API');
1449:
1450: exception
1451: when others then
1452: wf_core.context ('JTF_UM_WF_APPROVAL', 'SelectRequestType', itemtype, itemkey, to_char (actid), funcmode);

Line 1485: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering cancel_notification (' ||

1481: and wn.notification_id = wias.notification_id;
1482: --
1483: begin
1484:
1485: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering cancel_notification (' ||
1486: p_itemtype || ',' || p_itemkey || ') API');
1487:
1488: -- check input parameter
1489: if (p_itemtype is null) then

Line 1507: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting cancel_notification API');

1503: fetch getNotificationID into notificationID;
1504: end loop;
1505: close getNotificationID;
1506:
1507: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting cancel_notification API');
1508:
1509: end cancel_notification;
1510:
1511: --

Line 1540: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

1536: where USER_NAME = ownerUsername;
1537: --
1538: begin
1539:
1540: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
1541: 'Entering initialize_fail_escalate (' || itemtype || ',' ||
1542: itemkey || ',' || actid || ',' || funcmode || ') API');
1543:
1544: --

Line 1593: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting initialize_fail_escalate API');

1589: end if;
1590: resultout := 'COMPLETE';
1591: end if;
1592:
1593: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting initialize_fail_escalate API');
1594:
1595: exception
1596: when others then
1597: wf_core.context ('JTF_UM_WF_APPROVAL', 'initialize_fail_escalate', itemtype, itemkey, to_char (actid), funcmode);

Line 1624: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering WaitForApproval (' ||

1620: requestResult varchar2 (8);
1621: --
1622: begin
1623:
1624: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering WaitForApproval (' ||
1625: itemtype || ',' || itemkey || ',' || actid || ',' ||
1626: funcmode || ') API');
1627:
1628: --

Line 1663: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting WaitForApproval API');

1659: elsif (funcmode = 'TIMEOUT') then
1660: resultout := 'COMPLETE:';
1661: end if;
1662:
1663: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting WaitForApproval API');
1664:
1665: exception
1666: when others then
1667: wf_core.context ('JTF_UM_WF_APPROVAL', 'WaitForApproval', itemtype, itemkey, to_char (actid), funcmode);

Line 1701: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering post_notification (' ||

1697: where USER_NAME = WF_ENGINE.context_text;
1698: --
1699: begin
1700:
1701: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering post_notification (' ||
1702: itemtype || ',' || itemkey || ',' || actid || ',' ||
1703: funcmode || ') API');
1704:
1705: --

Line 1776: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting post_notification API');

1772: resultout := 'COMPLETE';
1773: end if;
1774: end if;
1775:
1776: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting post_notification API');
1777:
1778: exception
1779: when others then
1780: wf_core.context ('JTF_UM_WF_APPROVAL', 'post_notification', itemtype, itemkey, to_char (actid), funcmode);

Line 1809: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering store_delegate_flag (' ||

1805: l_requesterUserID number;
1806:
1807: begin
1808:
1809: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering store_delegate_flag (' ||
1810: itemtype || ',' || itemkey || ',' || actid || ',' ||
1811: funcmode || ') API');
1812:
1813: --

Line 1845: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting store_delegate_flag API');

1841: P_GRANT_DELEGATION_FLAG => l_bool_flag);
1842:
1843: end if;
1844:
1845: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting store_delegate_flag API');
1846:
1847: exception
1848: when others then
1849: -- wf_core.context ('JTF_UM_WF_APPROVAL', 'store_delegate_flag', itemtype, itemkey, to_char (actid), funcmode);

Line 1909: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Do_Approve_Req (' ||

1905:
1906:
1907: begin
1908:
1909: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Do_Approve_Req (' ||
1910: itemtype || ',' || itemkey || ') API');
1911:
1912:
1913: if itemtype is null then

Line 2015: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Approve_Req API');

2011: X_SUBSCRIPTION_ID => requestID);
2012:
2013: end if;
2014:
2015: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Approve_Req API');
2016:
2017: end Do_Approve_Req;
2018:
2019: --

Line 2042: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Approve_Req (' ||

2038: resultout out NOCOPY varchar2) is
2039: --
2040: begin
2041:
2042: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Approve_Req (' ||
2043: itemtype || ',' || itemkey || ',' || actid || ',' ||
2044: funcmode || ') API');
2045:
2046: --

Line 2068: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Approve_Req API');

2064: elsif (funcmode = 'TIMEOUT') then
2065: resultout := 'COMPLETE:';
2066: end if;
2067:
2068: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Approve_Req API');
2069:
2070: exception
2071: when others then
2072: wf_core.context ('JTF_UM_WF_APPROVAL', 'Approve_Req', itemtype, itemkey, to_char(actid), funcmode);

Line 2138: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Reject_Req (' ||

2134:
2135: --
2136: begin
2137:
2138: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Reject_Req (' ||
2139: itemtype || ',' || itemkey || ',' || actid || ',' ||
2140: funcmode || ') API');
2141:
2142: --

Line 2211: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Start Raising Event');

2207:
2208: -- Event handling
2209: -- Get the values for creation of parameters for the event
2210:
2211: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Start Raising Event');
2212:
2213: open getRejectEventData;
2214:
2215: fetch getRejectEventData into l_app_id,l_usertype_key,l_usertype_reg_id;

Line 2218: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Parameters '|| l_app_id ||' '||l_usertype_key|| ' '||l_usertype_reg_id );

2214:
2215: fetch getRejectEventData into l_app_id,l_usertype_key,l_usertype_reg_id;
2216:
2217: close getRejectEventData;
2218: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Parameters '|| l_app_id ||' '||l_usertype_key|| ' '||l_usertype_reg_id );
2219:
2220: -- create the parameter list
2221: wf_event.AddParameterToList(
2222: p_name => 'USERTYPEREG_ID',

Line 2292: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Reject_Req API');

2288: elsif (funcmode = 'TIMEOUT') then
2289: resultout := 'COMPLETE:';
2290: end if;
2291:
2292: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Reject_Req API');
2293:
2294: exception
2295: when others then
2296: wf_core.context ('JTF_UM_WF_APPROVAL', 'Reject_Req', itemtype, itemkey, to_char(actid), funcmode);

Line 2333: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Can_Delegate (' ||

2329: and user_name = l_approver_username;
2330: --
2331: begin
2332:
2333: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Can_Delegate (' ||
2334: itemtype || ',' || itemkey || ',' || actid || ',' ||
2335: funcmode || ') API');
2336:
2337: --

Line 2384: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Can_Delegate API');

2380:
2381: end if;
2382: end if;
2383:
2384: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Can_Delegate API');
2385:
2386: exception
2387: when others then
2388: wf_core.context ('JTF_UM_WF_APPROVAL', 'Can_Delegate', itemtype, itemkey, to_char (actid), funcmode, 'l_approver_userID='||to_char (l_approver_userID));

Line 2420: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,

2416: l_result boolean;
2417:
2418: begin
2419:
2420: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2421: p_message => l_procedure_name);
2422:
2423: if l_is_debug_parameter_on then
2424: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

Line 2424: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

2420: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2421: p_message => l_procedure_name);
2422:
2423: if l_is_debug_parameter_on then
2424: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,
2425: p_message => itemtype || ',' || itemkey ||
2426: ',' || actid || ',' || funcmode || ') ');
2427: end if;
2428:

Line 2459: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,

2455: end if;
2456:
2457: end if;
2458:
2459: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,
2460: p_message => l_procedure_name);
2461:
2462: exception
2463: when others then

Line 2501: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,

2497: l_universal_approvers fnd_profile_option_values.profile_option_value%type;
2498:
2499: begin
2500:
2501: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2502: p_message => l_procedure_name);
2503:
2504: if l_is_debug_parameter_on then
2505: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

Line 2505: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

2501: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2502: p_message => l_procedure_name);
2503:
2504: if l_is_debug_parameter_on then
2505: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,
2506: p_message => itemtype || ',' || itemkey ||
2507: ',' || actid || ',' || funcmode || ') ');
2508: end if;
2509:

Line 2554: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,

2550: end if;
2551:
2552: end if;
2553:
2554: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,
2555: p_message => l_procedure_name);
2556:
2557: exception
2558: when others then

Line 2600: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CHECK_EMAIL_NOTIFI_TYPE (' ||

2596: where USERTYPE_ID = usertypeID;
2597:
2598: begin
2599:
2600: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CHECK_EMAIL_NOTIFI_TYPE (' ||
2601: itemtype || ',' || itemkey || ',' || actid || ',' ||
2602: funcmode || ') API');
2603:
2604: --

Line 2667: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CHECK_EMAIL_NOTIFI_TYPE API');

2663: elsif (funcmode = 'TIMEOUT') then
2664: resultout := 'COMPLETE:';
2665: end if;
2666:
2667: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CHECK_EMAIL_NOTIFI_TYPE API');
2668:
2669: exception
2670: when MISSING_USERTYPE_INFO then
2671: wf_core.context ('JTF_UM_WF_APPROVAL', 'CHECK_EMAIL_NOTIFI_TYPE', itemtype, itemkey, to_char (actid), funcmode, 'Usertype info is missing');

Line 2739: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CompleteApprovalActivity (' ||

2735:
2736:
2737: begin
2738:
2739: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CompleteApprovalActivity (' ||
2740: itemtype || ',' || itemkey || ',' || resultCode || ',' ||
2741: approverComment || ') API');
2742:
2743: -- check on the input

Line 2840: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CompleteApprovalActivity API');

2836: else
2837: raise UNKNOWN_REQUEST_TYPE;
2838: end if;
2839:
2840: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting CompleteApprovalActivity API');
2841:
2842: exception
2843: when UNKNOWN_REQUEST_TYPE then
2844: wf_core.context ('JTF_UM_WF_APPROVAL', 'CompleteApprovalActivity',

Line 2940: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

2936: wf_resultCode varchar2 (8) := p_resultCode;
2937:
2938: begin
2939:
2940: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
2941: 'Entering Do_Complete_Approval_Activity (' || p_itemtype ||
2942: ',' || p_itemkey || ',' || p_resultCode || ',' || p_approverComment ||
2943: ',' || p_act1 || ',' || p_act2 || ',' || p_act3 || ',' || p_act4 ||
2944: ',' || p_act5 || ',' || p_act6 || ',' || p_act7 || ',' || p_act8 || ') API');

Line 3080: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Complete_Approval_Activity API');

3076: p_act6||','||p_act7||','||p_act8||')');
3077:
3078: end if;
3079:
3080: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Complete_Approval_Activity API');
3081:
3082: end Do_Complete_Approval_Activity;
3083:
3084: --

Line 3102: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering abort_process (' ||

3098: result varchar2 (10);
3099: status varchar2 (10);
3100: begin
3101:
3102: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering abort_process (' ||
3103: p_itemtype || ',' || p_itemkey || ') API');
3104:
3105: if p_itemtype is null then
3106: raise_application_error (-20000, 'itemtype is null while calling JTF_UM_WF_APPROVAL.abort_process.');

Line 3122: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting abort_process API');

3118: wf_engine.abortprocess (itemtype => p_itemtype,
3119: itemkey => p_itemkey);
3120: end if;
3121:
3122: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting abort_process API');
3123:
3124: end abort_process;
3125:
3126: procedure usertype_approval_changed (p_usertype_id in number,

Line 3160: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3156: p_new_item_key number;
3157:
3158: begin
3159:
3160: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3161: 'Entering usertype_approval_changed (' || p_usertype_id || ',' ||
3162: p_new_approval_id || ',' || p_old_approval_id || ') API');
3163:
3164:

Line 3238: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');

3234:
3235: end loop;
3236: close usertype_reg;
3237:
3238: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');
3239:
3240: end usertype_approval_changed;
3241:
3242: procedure usertype_approval_changed (p_usertype_id in number,

Line 3285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3281: p_new_item_key number;
3282:
3283: begin
3284:
3285: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3286: 'Entering usertype_approval_changed (' || p_usertype_id || ',' ||
3287: p_new_approval_id || ',' || p_old_approval_id || ',' ||
3288: p_org_party_id || ') API');
3289:

Line 3352: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');

3348: end if;
3349: end loop;
3350: close usertype_reg;
3351:
3352: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');
3353:
3354: end usertype_approval_changed;
3355:
3356: procedure enrollment_approval_changed (p_subscription_id in number,

Line 3407: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3403: or effective_end_date > sysdate);
3404:
3405: begin
3406:
3407: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3408: 'Entering enrollment_approval_changed (' || p_subscription_id || ',' ||
3409: p_new_approval_id || ',' || p_old_approval_id || ',' ||
3410: p_org_party_id || ') API');
3411:

Line 3541: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');

3537: else
3538: close subscription_reg_w_org;
3539: end if;
3540:
3541: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
3542:
3543: end enrollment_approval_changed;
3544:
3545: procedure enrollment_approval_changed (p_subscription_id in number,

Line 3550: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3546: p_new_approval_id in number,
3547: p_old_approval_id in number) is
3548: begin
3549:
3550: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3551: 'Entering enrollment_approval_changed (' || p_subscription_id || ',' ||
3552: p_new_approval_id || ',' || p_old_approval_id || ') API');
3553:
3554: enrollment_approval_changed (p_subscription_id,

Line 3559: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting enrollment_approval_changed API');

3555: p_new_approval_id,
3556: p_old_approval_id,
3557: null);
3558:
3559: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting enrollment_approval_changed API');
3560:
3561: end enrollment_approval_changed;
3562:
3563: procedure approval_chain_changed(p_approval_id in number,

Line 3579: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3575: p_subscription_id number;
3576:
3577: begin
3578:
3579: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3580: 'Entering approval_chain_changed (' || p_approval_id || ',' ||
3581: p_org_party_id || ') API');
3582:
3583: open usertype_approval;

Line 3630: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting approval_chain_changed API');

3626: end if;
3627: end loop;
3628: close subscription_approval;
3629:
3630: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting approval_chain_changed API');
3631:
3632: end approval_chain_changed;
3633:
3634: function get_approver_comment(p_reg_id in number,

Line 3641: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3637: p_approver_comment varchar2(4000);
3638:
3639: begin
3640:
3641: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3642: 'Entering get_approver_comment (' || p_reg_id || ',' ||
3643: p_wf_item_type || ') API');
3644:
3645: p_approver_comment := wf_engine.GetItemAttrText (

Line 3650: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting get_approver_comment API');

3646: itemtype => p_wf_item_type,
3647: itemkey => to_char(p_reg_id),
3648: aname => 'APPROVER_COMMENT');
3649:
3650: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting get_approver_comment API');
3651:
3652: return p_approver_comment;
3653:
3654: end get_approver_comment;