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.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);
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 885: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');

881:
882: resultout := 'COMPLETE:';
883: end if;
884:
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,

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

966:
967: begin
968:
969: -- Log the entering
970: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
971:
972: -- Log parameters
973: if l_is_debug_parameter_on then
974: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,

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

970: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (G_MODULE, l_method_name);
971:
972: -- Log parameters
973: if l_is_debug_parameter_on then
974: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
975: 'p_itemtype=' || p_itemtype);
976: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
977: 'p_itemkey=' || p_itemkey);
978: end if;

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

972: -- Log parameters
973: if l_is_debug_parameter_on then
974: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
975: 'p_itemtype=' || p_itemtype);
976: JTF_DEBUG_PUB.LOG_PARAMETERS (G_MODULE || '.' || l_method_name,
977: 'p_itemkey=' || p_itemkey);
978: end if;
979:
980: -- to construct the roleName, we need the organization number

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

1032: if l_uni_approver_not_found then
1033: x_role_name := null;
1034: end if;
1035:
1036: JTF_DEBUG_PUB.LOG_EXITING_METHOD (G_MODULE, l_method_name);
1037:
1038: end get_org_ad_hoc_role;
1039:
1040: --

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

1066: uniPrimaryUser fnd_profile_option_values.profile_option_value%type;
1067: l_approver_username_display varchar2 (100);
1068:
1069: begin
1070: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering SelectApprover (' ||
1071: itemtype || ',' || itemkey || ',' || actid || ',' ||
1072: funcmode || ') API');
1073:
1074: --

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

1181: resultout := 'COMPLETE:';
1182: --
1183: end if;
1184:
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,

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

1278: and hzr.object_table_name = 'HZ_PARTIES';
1279: --
1280: begin
1281:
1282: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering GetApprover (' ||
1283: x_itemtype || ',' || x_itemkey || ') API');
1284:
1285: -- check input parameter
1286: if (x_itemtype is null) then

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

1351: if (nextOrgApproverInfoCursor%notfound) then
1352: -- No more approvers, result 'END' -
1353: x_resultType := 'END';
1354: close nextOrgApproverInfoCursor;
1355: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1356: return;
1357: end if;
1358: close nextOrgApproverInfoCursor;
1359: -- If we should use the default approvers, find the first / next one

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

1364: if (nextApproverInfoCursor%notfound) then
1365: -- No more approvers, result 'END'
1366: x_resultType := 'END';
1367: close nextApproverInfoCursor;
1368: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting GetApprover API');
1369: return;
1370: end if;
1371: close nextApproverInfoCursor;
1372: end if;

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

1370: end if;
1371: close nextApproverInfoCursor;
1372: end if;
1373:
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);

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

1401: requestType varchar2 (10);
1402: --
1403: begin
1404:
1405: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Initialization (' ||
1406: itemtype || ',' || itemkey || ',' || actid || ',' ||
1407: funcmode || ') API');
1408:
1409: --

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

1432: elsif (funcmode = 'TIMEOUT') then
1433: resultout := 'COMPLETE:';
1434: end if;
1435:
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);

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

1469: and wn.notification_id = wias.notification_id;
1470: --
1471: begin
1472:
1473: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering cancel_notification (' ||
1474: p_itemtype || ',' || p_itemkey || ') API');
1475:
1476: -- check input parameter
1477: if (p_itemtype is null) then

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

1491: fetch getNotificationID into notificationID;
1492: end loop;
1493: close getNotificationID;
1494:
1495: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting cancel_notification API');
1496:
1497: end cancel_notification;
1498:
1499: --

Line 1528: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

1524: where USER_NAME = ownerUsername;
1525: --
1526: begin
1527:
1528: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
1529: 'Entering initialize_fail_escalate (' || itemtype || ',' ||
1530: itemkey || ',' || actid || ',' || funcmode || ') API');
1531:
1532: --

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

1577: end if;
1578: resultout := 'COMPLETE';
1579: end if;
1580:
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);

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

1608: requestResult varchar2 (8);
1609: --
1610: begin
1611:
1612: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering WaitForApproval (' ||
1613: itemtype || ',' || itemkey || ',' || actid || ',' ||
1614: funcmode || ') API');
1615:
1616: --

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

1647: elsif (funcmode = 'TIMEOUT') then
1648: resultout := 'COMPLETE:';
1649: end if;
1650:
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);

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

1685: where USER_NAME = WF_ENGINE.context_text;
1686: --
1687: begin
1688:
1689: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering post_notification (' ||
1690: itemtype || ',' || itemkey || ',' || actid || ',' ||
1691: funcmode || ') API');
1692:
1693: --

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

1760: resultout := 'COMPLETE';
1761: end if;
1762: end if;
1763:
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);

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

1793: l_requesterUserID number;
1794:
1795: begin
1796:
1797: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering store_delegate_flag (' ||
1798: itemtype || ',' || itemkey || ',' || actid || ',' ||
1799: funcmode || ') API');
1800:
1801: --

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

1829: P_GRANT_DELEGATION_FLAG => l_bool_flag);
1830:
1831: end if;
1832:
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);

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

1890:
1891:
1892: begin
1893:
1894: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Do_Approve_Req (' ||
1895: itemtype || ',' || itemkey || ') API');
1896:
1897:
1898: if itemtype is null then

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

1985: X_SUBSCRIPTION_ID => requestID);
1986:
1987: end if;
1988:
1989: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Approve_Req API');
1990:
1991: end Do_Approve_Req;
1992:
1993: --

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

2012: resultout out NOCOPY varchar2) is
2013: --
2014: begin
2015:
2016: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Approve_Req (' ||
2017: itemtype || ',' || itemkey || ',' || actid || ',' ||
2018: funcmode || ') API');
2019:
2020: --

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

2038: elsif (funcmode = 'TIMEOUT') then
2039: resultout := 'COMPLETE:';
2040: end if;
2041:
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);

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

2108:
2109: --
2110: begin
2111:
2112: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Reject_Req (' ||
2113: itemtype || ',' || itemkey || ',' || actid || ',' ||
2114: funcmode || ') API');
2115:
2116: --

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

2181:
2182: -- Event handling
2183: -- Get the values for creation of parameters for the event
2184:
2185: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Start Raising Event');
2186:
2187: open getRejectEventData;
2188:
2189: fetch getRejectEventData into l_app_id,l_usertype_key,l_usertype_reg_id;

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

2188:
2189: fetch getRejectEventData into l_app_id,l_usertype_key,l_usertype_reg_id;
2190:
2191: close getRejectEventData;
2192: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Parameters '|| l_app_id ||' '||l_usertype_key|| ' '||l_usertype_reg_id );
2193:
2194: -- create the parameter list
2195: wf_event.AddParameterToList(
2196: p_name => 'USERTYPEREG_ID',

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

2262: elsif (funcmode = 'TIMEOUT') then
2263: resultout := 'COMPLETE:';
2264: end if;
2265:
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);

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

2303: and user_name = l_approver_username;
2304: --
2305: begin
2306:
2307: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering Can_Delegate (' ||
2308: itemtype || ',' || itemkey || ',' || actid || ',' ||
2309: funcmode || ') API');
2310:
2311: --

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

2354:
2355: end if;
2356: end if;
2357:
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));

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

2390: l_result boolean;
2391:
2392: begin
2393:
2394: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2395: p_message => l_procedure_name);
2396:
2397: if l_is_debug_parameter_on then
2398: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

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

2394: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2395: p_message => l_procedure_name);
2396:
2397: if l_is_debug_parameter_on then
2398: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,
2399: p_message => itemtype || ',' || itemkey ||
2400: ',' || actid || ',' || funcmode || ') ');
2401: end if;
2402:

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

2429: end if;
2430:
2431: end if;
2432:
2433: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,
2434: p_message => l_procedure_name);
2435:
2436: exception
2437: when others then

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

2471: l_universal_approvers fnd_profile_option_values.profile_option_value%type;
2472:
2473: begin
2474:
2475: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2476: p_message => l_procedure_name);
2477:
2478: if l_is_debug_parameter_on then
2479: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,

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

2475: JTF_DEBUG_PUB.LOG_ENTERING_METHOD (p_module => G_MODULE,
2476: p_message => l_procedure_name);
2477:
2478: if l_is_debug_parameter_on then
2479: JTF_DEBUG_PUB.LOG_PARAMETERS (p_module => G_MODULE,
2480: p_message => itemtype || ',' || itemkey ||
2481: ',' || actid || ',' || funcmode || ') ');
2482: end if;
2483:

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

2524: end if;
2525:
2526: end if;
2527:
2528: JTF_DEBUG_PUB.LOG_EXITING_METHOD (p_module => G_MODULE,
2529: p_message => l_procedure_name);
2530:
2531: exception
2532: when others then

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

2570: where USERTYPE_ID = usertypeID;
2571:
2572: begin
2573:
2574: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CHECK_EMAIL_NOTIFI_TYPE (' ||
2575: itemtype || ',' || itemkey || ',' || actid || ',' ||
2576: funcmode || ') API');
2577:
2578: --

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

2637: elsif (funcmode = 'TIMEOUT') then
2638: resultout := 'COMPLETE:';
2639: end if;
2640:
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');

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

2709:
2710:
2711: begin
2712:
2713: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering CompleteApprovalActivity (' ||
2714: itemtype || ',' || itemkey || ',' || resultCode || ',' ||
2715: approverComment || ') API');
2716:
2717: -- check on the input

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

2806: else
2807: raise UNKNOWN_REQUEST_TYPE;
2808: end if;
2809:
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',

Line 2908: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

2904: wf_resultCode varchar2 (8) := p_resultCode;
2905:
2906: begin
2907:
2908: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
2909: 'Entering Do_Complete_Approval_Activity (' || p_itemtype ||
2910: ',' || p_itemkey || ',' || p_resultCode || ',' || p_approverComment ||
2911: ',' || p_act1 || ',' || p_act2 || ',' || p_act3 || ',' || p_act4 ||
2912: ',' || p_act5 || ',' || p_act6 || ') API');

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

3016: p_act6||')');
3017:
3018: end if;
3019:
3020: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Do_Complete_Approval_Activity API');
3021:
3022: end Do_Complete_Approval_Activity;
3023:
3024: --

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

3038: result varchar2 (10);
3039: status varchar2 (10);
3040: begin
3041:
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.');

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

3058: wf_engine.abortprocess (itemtype => p_itemtype,
3059: itemkey => p_itemkey);
3060: end if;
3061:
3062: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting abort_process API');
3063:
3064: end abort_process;
3065:
3066: procedure usertype_approval_changed (p_usertype_id in number,

Line 3100: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3096: p_new_item_key number;
3097:
3098: begin
3099:
3100: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3101: 'Entering usertype_approval_changed (' || p_usertype_id || ',' ||
3102: p_new_approval_id || ',' || p_old_approval_id || ') API');
3103:
3104:

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

3174:
3175: end loop;
3176: close usertype_reg;
3177:
3178: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');
3179:
3180: end usertype_approval_changed;
3181:
3182: procedure usertype_approval_changed (p_usertype_id in number,

Line 3225: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3221: p_new_item_key number;
3222:
3223: begin
3224:
3225: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3226: 'Entering usertype_approval_changed (' || p_usertype_id || ',' ||
3227: p_new_approval_id || ',' || p_old_approval_id || ',' ||
3228: p_org_party_id || ') API');
3229:

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

3288: end if;
3289: end loop;
3290: close usertype_reg;
3291:
3292: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting usertype_approval_changed API');
3293:
3294: end usertype_approval_changed;
3295:
3296: procedure enrollment_approval_changed (p_subscription_id in number,

Line 3347: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3343: or effective_end_date > sysdate);
3344:
3345: begin
3346:
3347: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3348: 'Entering enrollment_approval_changed (' || p_subscription_id || ',' ||
3349: p_new_approval_id || ',' || p_old_approval_id || ',' ||
3350: p_org_party_id || ') API');
3351:

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

3477: else
3478: close subscription_reg_w_org;
3479: end if;
3480:
3481: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting Initialization API');
3482:
3483: end enrollment_approval_changed;
3484:
3485: procedure enrollment_approval_changed (p_subscription_id in number,

Line 3490: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3486: p_new_approval_id in number,
3487: p_old_approval_id in number) is
3488: begin
3489:
3490: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3491: 'Entering enrollment_approval_changed (' || p_subscription_id || ',' ||
3492: p_new_approval_id || ',' || p_old_approval_id || ') API');
3493:
3494: enrollment_approval_changed (p_subscription_id,

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

3495: p_new_approval_id,
3496: p_old_approval_id,
3497: null);
3498:
3499: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting enrollment_approval_changed API');
3500:
3501: end enrollment_approval_changed;
3502:
3503: procedure approval_chain_changed(p_approval_id in number,

Line 3519: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3515: p_subscription_id number;
3516:
3517: begin
3518:
3519: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3520: 'Entering approval_chain_changed (' || p_approval_id || ',' ||
3521: p_org_party_id || ') API');
3522:
3523: open usertype_approval;

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

3566: end if;
3567: end loop;
3568: close subscription_approval;
3569:
3570: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting approval_chain_changed API');
3571:
3572: end approval_chain_changed;
3573:
3574: function get_approver_comment(p_reg_id in number,

Line 3581: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,

3577: p_approver_comment varchar2(4000);
3578:
3579: begin
3580:
3581: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE,
3582: 'Entering get_approver_comment (' || p_reg_id || ',' ||
3583: p_wf_item_type || ') API');
3584:
3585: p_approver_comment := wf_engine.GetItemAttrText (

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

3586: itemtype => p_wf_item_type,
3587: itemkey => to_char(p_reg_id),
3588: aname => 'APPROVER_COMMENT');
3589:
3590: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Exiting get_approver_comment API');
3591:
3592: return p_approver_comment;
3593:
3594: end get_approver_comment;