[Home] [Help]
13: g_mid_pay_period_change constant varchar2(30) := 'HR_MID_PAY_PERIOD_CHANGE';
14: g_oa_media constant varchar2(100) DEFAULT fnd_web_config.web_server||'OA_MEDIA/';
15: g_oa_html constant varchar2(100) DEFAULT fnd_web_config.jsp_agent;
16:
17: g_debug boolean := hr_utility.debug_enabled;
18: gv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
19: -- cursor determines if an attribute exists
20: cursor csr_wiav (p_item_type in varchar2
21: ,p_item_key in varchar2
206: begin
207:
208: begin
209: if g_debug then
210: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
211: end if;
212: select t.item_type
213: into c_item_type
214: from hr_api_transactions t
216: exception
217: when no_data_found then
218: -- get the data from the steps
219: if g_debug then
220: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
221: end if;
222: select ts.item_type
223: into get_item_type.c_item_type
224: from hr_api_transaction_steps ts
249: begin
250:
251: begin
252: if g_debug then
253: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
254: end if;
255: select t.item_key
256: into get_item_key.c_item_key
257: from hr_api_transactions t
259: exception
260: when no_data_found then
261: -- get the data from the steps
262: if g_debug then
263: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
264: end if;
265: select ts.item_key
266: into get_item_key.c_item_key
267: from hr_api_transaction_steps ts
1069: c_proc varchar2(30) default 'GetActivityAttrText';
1070:
1071:
1072: begin
1073: g_debug := hr_utility.debug_enabled;
1074:
1075: if g_debug then
1076: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1077: end if;
1072: begin
1073: g_debug := hr_utility.debug_enabled;
1074:
1075: if g_debug then
1076: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1077: end if;
1078:
1079:
1080: if(ignore_notfound='TRUE') then
1078:
1079:
1080: if(ignore_notfound='TRUE') then
1081: if g_debug then
1082: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1083: end if;
1084: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1085: itemkey=>itemkey,
1086: actid=>actid,
1087: aname=>aname,
1088: ignore_notfound=>TRUE);
1089: elsif (ignore_notfound='FALSE') then
1090: if g_debug then
1091: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1092: end if;
1093:
1094: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1095: itemkey=>itemkey,
1115: return date is
1116: c_proc varchar2(30) default 'GetActivityAttrDate';
1117:
1118: begin
1119: g_debug := hr_utility.debug_enabled;
1120:
1121: if g_debug then
1122: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1123: end if;
1118: begin
1119: g_debug := hr_utility.debug_enabled;
1120:
1121: if g_debug then
1122: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1123: end if;
1124:
1125: if(ignore_notfound='TRUE') then
1126: if g_debug then
1123: end if;
1124:
1125: if(ignore_notfound='TRUE') then
1126: if g_debug then
1127: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1128: end if;
1129: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1130: itemkey=>itemkey,
1131: actid=>actid,
1132: aname=>aname,
1133: ignore_notfound=>TRUE);
1134: elsif (ignore_notfound='FALSE') then
1135: if g_debug then
1136: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1137: end if;
1138: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1139: itemkey=>itemkey,
1140: actid=>actid,
1161: return number is
1162: c_proc varchar2(30) default 'GetActivityAttrNumber';
1163:
1164: begin
1165: g_debug := hr_utility.debug_enabled;
1166:
1167: if g_debug then
1168: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1169: end if;
1164: begin
1165: g_debug := hr_utility.debug_enabled;
1166:
1167: if g_debug then
1168: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1169: end if;
1170:
1171: if(ignore_notfound='TRUE') then
1172: if g_debug then
1169: end if;
1170:
1171: if(ignore_notfound='TRUE') then
1172: if g_debug then
1173: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1174: end if;
1175: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1176: itemkey=>itemkey,
1177: actid=>actid,
1178: aname=>aname,
1179: ignore_notfound=>TRUE);
1180: elsif (ignore_notfound='FALSE') then
1181: if g_debug then
1182: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1183: end if;
1184:
1185: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1186: itemkey=>itemkey,
1212: lv_page_type wf_item_attribute_values.text_value%type;
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
1220: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
1213: ln_page_applicationId wf_item_attribute_values.number_value%type;
1214: lv_additional_params wf_item_attribute_values.text_value%type;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
1220: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
1221: end if;
1215: BEGIN
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
1220: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
1221: end if;
1222: -- get the activity id for blocked page activity
1223: -- activity used for page should have activity attribute
1216: hr_utility.set_location(lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
1220: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
1221: end if;
1222: -- get the activity id for blocked page activity
1223: -- activity used for page should have activity attribute
1224: -- of type 'FORM'
1222: -- get the activity id for blocked page activity
1223: -- activity used for page should have activity attribute
1224: -- of type 'FORM'
1225: begin
1226: if(hr_utility.debug_enabled) then
1227: -- write debug statements
1228: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity of type FORM'||lv_procedure_name||'with itemtype:', 3);
1229: end if;
1230:
1224: -- of type 'FORM'
1225: begin
1226: if(hr_utility.debug_enabled) then
1227: -- write debug statements
1228: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity of type FORM'||lv_procedure_name||'with itemtype:', 3);
1229: end if;
1230:
1231: -- Fix for bug 3719338
1232: SELECT process_activity
1259: where rownum<=1;
1260:
1261: exception
1262: when no_data_found then
1263: if(hr_utility.debug_enabled) then
1264: -- write debug statements
1265: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES of type FORM for itemtype:'|| p_item_type||' and item key:'||p_item_key, 4);
1266: end if;
1267: ln_activityId := null;
1261: exception
1262: when no_data_found then
1263: if(hr_utility.debug_enabled) then
1264: -- write debug statements
1265: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES of type FORM for itemtype:'|| p_item_type||' and item key:'||p_item_key, 4);
1266: end if;
1267: ln_activityId := null;
1268: when others then
1269: ln_activityId := null;
1267: ln_activityId := null;
1268: when others then
1269: ln_activityId := null;
1270: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1271: hr_utility.raise_error;
1272: end;
1273:
1274: if(ln_activityId is not null) then
1275: -- we have a blocked page activity in the wf root process
1273:
1274: if(ln_activityId is not null) then
1275: -- we have a blocked page activity in the wf root process
1276: -- get the activity attribute values
1277: if(hr_utility.debug_enabled) then
1278: -- write debug statements
1279: hr_utility.set_location('getting activity attributes for activity id:'||ln_activityId ||', itemtype:'|| p_item_type||' and item key:'||p_item_key, 5);
1280: end if;
1281: lv_page := wf_engine.GetActivityAttrText(
1275: -- we have a blocked page activity in the wf root process
1276: -- get the activity attribute values
1277: if(hr_utility.debug_enabled) then
1278: -- write debug statements
1279: hr_utility.set_location('getting activity attributes for activity id:'||ln_activityId ||', itemtype:'|| p_item_type||' and item key:'||p_item_key, 5);
1280: end if;
1281: lv_page := wf_engine.GetActivityAttrText(
1282: itemtype => p_item_type
1283: ,itemkey => p_item_key
1310: p_page_applicationId :=ln_page_applicationId;
1311: p_additional_params := lv_additional_params;
1312: else
1313: -- there is no blocked page activity, check for additional details
1314: if(hr_utility.debug_enabled) then
1315: -- write debug statements
1316: hr_utility.set_location(' itemtype:'|| p_item_type||' and item key:'||p_item_key, 6);
1317: p_activityId :='0'; -- fix for bug 3823494
1318: end if;
1312: else
1313: -- there is no blocked page activity, check for additional details
1314: if(hr_utility.debug_enabled) then
1315: -- write debug statements
1316: hr_utility.set_location(' itemtype:'|| p_item_type||' and item key:'||p_item_key, 6);
1317: p_activityId :='0'; -- fix for bug 3823494
1318: end if;
1319: end if;
1320:
1317: p_activityId :='0'; -- fix for bug 3823494
1318: end if;
1319: end if;
1320:
1321: if(hr_utility.debug_enabled) then
1322: -- write debug statements
1323: hr_utility.set_location('Leaving '||lv_procedure_name||'with itemtype:'||p_item_type, 10);
1324: end if;
1325:
1319: end if;
1320:
1321: if(hr_utility.debug_enabled) then
1322: -- write debug statements
1323: hr_utility.set_location('Leaving '||lv_procedure_name||'with itemtype:'||p_item_type, 10);
1324: end if;
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1329: hr_utility.raise_error;
1330: END getPageDetails;
1331:
1332: function GetItemAttrText(itemtype in varchar2,
1333: itemkey in varchar2,
1337: c_proc varchar2(30) default 'GetItemAttrText';
1338:
1339:
1340: begin
1341: g_debug := hr_utility.debug_enabled;
1342:
1343: if g_debug then
1344: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1345: end if;
1340: begin
1341: g_debug := hr_utility.debug_enabled;
1342:
1343: if g_debug then
1344: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1345: end if;
1346:
1347:
1348: if(ignore_notfound='TRUE') then
1346:
1347:
1348: if(ignore_notfound='TRUE') then
1349: if g_debug then
1350: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1351: end if;
1352: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1353: itemkey=>itemkey,
1354: aname=>aname,
1354: aname=>aname,
1355: ignore_notfound=>TRUE);
1356: elsif (ignore_notfound='FALSE') then
1357: if g_debug then
1358: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1359: end if;
1360:
1361: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1362: itemkey=>itemkey,
1380: lv_item_type wf_item_activity_statuses.item_type%type;
1381: lv_item_key wf_item_activity_statuses.item_key%type;
1382: lv_activity_id wf_item_activity_statuses.process_activity%type;
1383: begin
1384: g_debug := hr_utility.debug_enabled;
1385: if g_debug then
1386: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1387: end if;
1388:
1382: lv_activity_id wf_item_activity_statuses.process_activity%type;
1383: begin
1384: g_debug := hr_utility.debug_enabled;
1385: if g_debug then
1386: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1387: end if;
1388:
1389: -- get the itemtype and item key for the notification id
1390: begin
1402: from wf_notifications
1403: where notification_id = p_ntfid;
1404: exception
1405: when no_data_found then
1406: hr_utility.set_location('Error in '|| g_package||'.'||c_proc ||SQLERRM ||' '||to_char(SQLCODE), 20);
1407: raise;
1408: when others then
1409: raise;
1410: end;
1416: p_itemKey := lv_item_key;
1417:
1418: exception
1419: when others then
1420: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1421: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1422: raise;
1423: end get_item_type_and_key;
1424:
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1448:
1449: begin
1450: g_debug := hr_utility.debug_enabled;
1451: if g_debug then
1452: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1453: end if;
1454:
1448:
1449: begin
1450: g_debug := hr_utility.debug_enabled;
1451: if g_debug then
1452: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1453: end if;
1454:
1455: -- fix for bug#3333763
1456: -- check the status of the notification before doing any iterations.
1470: -- check if the workflow process has been configured to
1471: --restrict edit to transaction owner/creator
1472: -- HR_RESTRICT_EDIT_ATTR
1473: if g_debug then
1474: hr_utility.set_location('querying wf_engine.GetItemAttrText for HR_RESTRICT_EDIT_ATTR with itemtype:itemkey '||lv_item_type||':'||lv_item_key, 2);
1475: end if;
1476:
1477: lv_restrict_edit_to_owner :=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1478: itemkey=>lv_item_key,
1478: itemkey=>lv_item_key,
1479: aname=>'HR_RESTRICT_EDIT_ATTR',
1480: ignore_notfound=>TRUE);
1481: if g_debug then
1482: hr_utility.set_location('HR_RESTRICT_EDIT_ATTR value:'||lv_restrict_edit_to_owner,3);
1483: end if;
1484:
1485: if(lv_restrict_edit_to_owner='Y') then
1486: hr_utility.set_location('process configured to restrict edit to owner/creator, no edit so returning',4);
1482: hr_utility.set_location('HR_RESTRICT_EDIT_ATTR value:'||lv_restrict_edit_to_owner,3);
1483: end if;
1484:
1485: if(lv_restrict_edit_to_owner='Y') then
1486: hr_utility.set_location('process configured to restrict edit to owner/creator, no edit so returning',4);
1487: -- get the current login user name and compare with the creator user name
1488: if(fnd_global.USER_NAME=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1489: itemkey=>lv_item_key,
1490: aname=>'CREATOR_PERSON_USERNAME',
1542: from fnd_form_functions_vl
1543: where function_name=lv_pageFunc;
1544: exception
1545: when no_data_found then
1546: hr_utility.set_location('Unable to retrieve function details,web_html_call and parameters for:'||lv_pageFunc||' '|| g_package||'.'||c_proc, 10);
1547: when others then
1548: raise;
1549: end;
1550: -- set the out variables
1561: document := null;
1562: end if;
1563:
1564: if g_debug then
1565: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1566: end if;
1567:
1568: exception
1569: when others then
1568: exception
1569: when others then
1570: document := null;
1571: document_type :=null;
1572: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1573: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1574: raise;
1575: end build_edit_link;
1576:
1582: return number is
1583: c_proc varchar2(30) default 'GetAttrNumber';
1584: lvalue wf_notification_attributes.NUMBER_VALUE%type;
1585: begin
1586: g_debug := hr_utility.debug_enabled;
1587:
1588: if g_debug then
1589: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1590: end if;
1585: begin
1586: g_debug := hr_utility.debug_enabled;
1587:
1588: if g_debug then
1589: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1590: end if;
1591: if ((nid is null) or (aname is null)) then
1592: wf_core.token('NID', to_char(nid));
1593: wf_core.token('ANAME', aname);
1595: end if;
1596:
1597: begin
1598: if g_debug then
1599: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);
1600: end if;
1601: select WNA.NUMBER_VALUE
1602: into lvalue
1603: from WF_NOTIFICATION_ATTRIBUTES WNA
1616: return(lvalue);
1617: exception
1618: when others then
1619: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1620: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1621: raise;
1622: end GetAttrNumber;
1623:
1624: function GetAttrText (nid in number,
1627: return varchar2 is
1628: c_proc varchar2(30) default 'GetAttrText';
1629: lvalue wf_notification_attributes.text_value%type;
1630: begin
1631: g_debug := hr_utility.debug_enabled;
1632:
1633: if g_debug then
1634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1635: end if;
1630: begin
1631: g_debug := hr_utility.debug_enabled;
1632:
1633: if g_debug then
1634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1635: end if;
1636: if ((nid is null) or (aname is null)) then
1637: wf_core.token('NID', to_char(nid));
1638: wf_core.token('ANAME', aname);
1640: end if;
1641:
1642: begin
1643: if g_debug then
1644: hr_utility.set_location('querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid, 2);
1645: end if;
1646: select WNA.TEXT_VALUE
1647: into lvalue
1648: from WF_NOTIFICATION_ATTRIBUTES WNA
1661: return(lvalue);
1662: exception
1663: when others then
1664: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1665: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1666: raise;
1667: end GetAttrText;
1668:
1669: function getApprStartingPointPersonId
1710: end;
1711: end if;
1712: exception
1713: when others then
1714: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
1715: 'rollback_transaction'||' : ' || sqlerrm);
1716: -- just log the message no need to raise it
1717: end;
1718:
1738: dynamicQuery varchar2(4000) default null;
1739: queryProcedure varchar2(4000) default 'pqh_ss_workflow.set_transaction_status';
1740: actionStatus varchar2(3) default 'SFL';
1741: begin
1742: g_debug := hr_utility.debug_enabled;
1743:
1744: if g_debug then
1745: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1746: end if;
1741: begin
1742: g_debug := hr_utility.debug_enabled;
1743:
1744: if g_debug then
1745: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1746: end if;
1747:
1748: -- fix for bug 4454439
1749: begin
1761:
1762: if ( funmode = wf_engine.eng_run ) then
1763: -- code to update status and history
1764: if g_debug then
1765: hr_utility.set_location('Calling queryProcedure: '||queryProcedure, 20);
1766: hr_utility.set_location('itemType: '|| itemType, 21);
1767: hr_utility.set_location('itemKey: '|| itemKey, 22);
1768: hr_utility.set_location('actId: '|| actId, 23);
1769: end if;
1762: if ( funmode = wf_engine.eng_run ) then
1763: -- code to update status and history
1764: if g_debug then
1765: hr_utility.set_location('Calling queryProcedure: '||queryProcedure, 20);
1766: hr_utility.set_location('itemType: '|| itemType, 21);
1767: hr_utility.set_location('itemKey: '|| itemKey, 22);
1768: hr_utility.set_location('actId: '|| actId, 23);
1769: end if;
1770:
1763: -- code to update status and history
1764: if g_debug then
1765: hr_utility.set_location('Calling queryProcedure: '||queryProcedure, 20);
1766: hr_utility.set_location('itemType: '|| itemType, 21);
1767: hr_utility.set_location('itemKey: '|| itemKey, 22);
1768: hr_utility.set_location('actId: '|| actId, 23);
1769: end if;
1770:
1771: dynamicQuery :=
1764: if g_debug then
1765: hr_utility.set_location('Calling queryProcedure: '||queryProcedure, 20);
1766: hr_utility.set_location('itemType: '|| itemType, 21);
1767: hr_utility.set_location('itemKey: '|| itemKey, 22);
1768: hr_utility.set_location('actId: '|| actId, 23);
1769: end if;
1770:
1771: dynamicQuery :=
1772: 'begin ' ||
1779: in actId,
1780: in actionStatus,
1781: out result;
1782: if g_debug then
1783: hr_utility.set_location('After queryProcedure: '||queryProcedure, 40);
1784: hr_utility.set_location('result: '|| result, 41);
1785: end if;
1786:
1787:
1780: in actionStatus,
1781: out result;
1782: if g_debug then
1783: hr_utility.set_location('After queryProcedure: '||queryProcedure, 40);
1784: hr_utility.set_location('result: '|| result, 41);
1785: end if;
1786:
1787:
1788: --
1788: --
1789: elsif ( funmode = wf_engine.eng_cancel ) then
1790: --
1791: if g_debug then
1792: hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
1793: hr_utility.set_location('itemType: '|| itemType, 51);
1794: hr_utility.set_location('itemKey: '|| itemKey, 52);
1795: hr_utility.set_location('actId: '|| actId, 53);
1796: end if;
1789: elsif ( funmode = wf_engine.eng_cancel ) then
1790: --
1791: if g_debug then
1792: hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
1793: hr_utility.set_location('itemType: '|| itemType, 51);
1794: hr_utility.set_location('itemKey: '|| itemKey, 52);
1795: hr_utility.set_location('actId: '|| actId, 53);
1796: end if;
1797: end if;
1790: --
1791: if g_debug then
1792: hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
1793: hr_utility.set_location('itemType: '|| itemType, 51);
1794: hr_utility.set_location('itemKey: '|| itemKey, 52);
1795: hr_utility.set_location('actId: '|| actId, 53);
1796: end if;
1797: end if;
1798:
1791: if g_debug then
1792: hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
1793: hr_utility.set_location('itemType: '|| itemType, 51);
1794: hr_utility.set_location('itemKey: '|| itemKey, 52);
1795: hr_utility.set_location('actId: '|| actId, 53);
1796: end if;
1797: end if;
1798:
1799: EXCEPTION
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: WF_CORE.CONTEXT(g_package,'.updateSFLTransaction',itemtype,itemkey,funmode);
1802: hr_utility.set_location(''||SQLERRM ||' '||to_char(SQLCODE), 100);
1803: RAISE;
1804:
1805:
1806: end updateSFLTransaction;
1815: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1816:
1817: begin
1818: if g_debug then
1819: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1820: end if;
1821: if g_debug then
1822: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1823: hr_utility.set_location('ItemType:'||itemtype,12);
1818: if g_debug then
1819: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1820: end if;
1821: if g_debug then
1822: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1823: hr_utility.set_location('ItemType:'||itemtype,12);
1824: hr_utility.set_location('ItemKey:'||itemkey,13);
1825: end if;
1826:
1819: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1820: end if;
1821: if g_debug then
1822: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1823: hr_utility.set_location('ItemType:'||itemtype,12);
1824: hr_utility.set_location('ItemKey:'||itemkey,13);
1825: end if;
1826:
1827: begin
1820: end if;
1821: if g_debug then
1822: hr_utility.set_location('Querying wf_runnable_processes_v',11);
1823: hr_utility.set_location('ItemType:'||itemtype,12);
1824: hr_utility.set_location('ItemKey:'||itemkey,13);
1825: end if;
1826:
1827: begin
1828: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => itemtype ,
1845: when others then
1846: getProcessDisplayName.lv_display_name := itemtype||':'||itemkey;
1847: end;
1848: if g_debug then
1849: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 20);
1850: end if;
1851:
1852: return getProcessDisplayName.lv_display_name;
1853: exception
1865: lv_item_type wf_item_activity_statuses.item_type%type;
1866: lv_item_key wf_item_activity_statuses.item_key%type;
1867:
1868: begin
1869: g_debug := hr_utility.debug_enabled;
1870: if g_debug then
1871: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1872: end if;
1873:
1867:
1868: begin
1869: g_debug := hr_utility.debug_enabled;
1870: if g_debug then
1871: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1872: end if;
1873:
1874: if g_debug then
1875: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1871: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1872: end if;
1873:
1874: if g_debug then
1875: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1876: end if;
1877: -- get the itemtype and item key for the notification id
1878: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1879: -- set the document type
1879: -- set the document type
1880: document_type := wf_notification.doc_html;
1881: -- set the document
1882: if g_debug then
1883: hr_utility.set_location('Calling getProcessDisplayName',12);
1884: hr_utility.set_location('ItemType:'||lv_item_type,13);
1885: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1886: end if;
1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1880: document_type := wf_notification.doc_html;
1881: -- set the document
1882: if g_debug then
1883: hr_utility.set_location('Calling getProcessDisplayName',12);
1884: hr_utility.set_location('ItemType:'||lv_item_type,13);
1885: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1886: end if;
1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1888:
1881: -- set the document
1882: if g_debug then
1883: hr_utility.set_location('Calling getProcessDisplayName',12);
1884: hr_utility.set_location('ItemType:'||lv_item_type,13);
1885: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1886: end if;
1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1888:
1889: if g_debug then
1886: end if;
1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1888:
1889: if g_debug then
1890: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1891: end if;
1892:
1893: exception
1894: when others then
1892:
1893: exception
1894: when others then
1895: document :=null;
1896: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1897: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1898: raise;
1899: end getProcessDisplayName;
1900:
1918: lv_custom_callBack varchar2(60);
1919: l_sqlbuf Varchar2(1000);
1920:
1921: begin
1922: g_debug := hr_utility.debug_enabled;
1923: if g_debug then
1924: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1925: end if;
1926:
1920:
1921: begin
1922: g_debug := hr_utility.debug_enabled;
1923: if g_debug then
1924: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
1925: end if;
1926:
1927: -- check if we have custom callback for the Approval Ntf subject
1928: --
1945: End If;
1946: exception
1947: when others then
1948: document :=null;
1949: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1950: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1951: raise;
1952: end;
1953:
1954:
1955:
1956: -- get the itemtype and item key for the notification id
1957: if g_debug then
1958: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1959: end if;
1960: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1961:
1962: -- get the process display name
1960: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1961:
1962: -- get the process display name
1963: if g_debug then
1964: hr_utility.set_location('Calling getProcessDisplayName',12);
1965: hr_utility.set_location('ItemType:'||lv_item_type,13);
1966: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1967: end if;
1968: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1961:
1962: -- get the process display name
1963: if g_debug then
1964: hr_utility.set_location('Calling getProcessDisplayName',12);
1965: hr_utility.set_location('ItemType:'||lv_item_type,13);
1966: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1967: end if;
1968: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1969:
1962: -- get the process display name
1963: if g_debug then
1964: hr_utility.set_location('Calling getProcessDisplayName',12);
1965: hr_utility.set_location('ItemType:'||lv_item_type,13);
1966: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1967: end if;
1968: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1969:
1970: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,
1990: (itemtype => lv_item_type
1991: ,itemkey => lv_item_key
1992: ,aname => 'CURRENT_PERSON_ID');
1993: if g_debug then
1994: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
1995: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
1996: end if;
1997: if g_debug then
1998: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
1991: ,itemkey => lv_item_key
1992: ,aname => 'CURRENT_PERSON_ID');
1993: if g_debug then
1994: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
1995: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
1996: end if;
1997: if g_debug then
1998: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
1999: end if;
1994: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
1995: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
1996: end if;
1997: if g_debug then
1998: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
1999: end if;
2000: if(l_creator_person_id=l_current_person_id) then
2001: if g_debug then
2002: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,18);
1998: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
1999: end if;
2000: if(l_creator_person_id=l_current_person_id) then
2001: if g_debug then
2002: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,18);
2003: end if;
2004:
2005: -- get creator display name from role
2006: wf_directory.GetUserName
2012:
2013: -- Subject pattern
2014: -- "Change Job for Doe, John "
2015: if g_debug then
2016: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2017: end if;
2018: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2019: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2020: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2022:
2023: else
2024: -- get creator display name from role
2025: if g_debug then
2026: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,20);
2027: end if;
2028: wf_directory.GetUserName
2029: (p_orig_system => 'PER'
2030: ,p_orig_system_id => l_creator_person_id
2032: ,p_display_name => l_creator_disp_name);
2033:
2034: -- get current person display name from role
2035: if g_debug then
2036: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_current_person_id,21);
2037: end if;
2038: wf_directory.GetUserName
2039: (p_orig_system => 'PER'
2040: ,p_orig_system_id => l_current_person_id
2068:
2069: -- Subject pattern
2070: -- "Change Job for Doe, John (proposed by Bond, James)"
2071: if g_debug then
2072: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2073: end if;
2074:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2083: -- set the document type
2084: document_type := wf_notification.doc_html;
2085:
2086: if g_debug then
2087: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2088: end if;
2089:
2090: exception
2091: when others then
2089:
2090: exception
2091: when others then
2092: document :=null;
2093: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2094: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2095: raise;
2096: end getApprovalMsgSubject;
2097:
2124: l_foundApprLoc boolean default false;
2125:
2126:
2127: begin
2128: hr_utility.set_location(lv_procedure_name,1);
2129: if(hr_utility.debug_enabled) then
2130: -- write debug statements
2131: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
2132: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
2125:
2126:
2127: begin
2128: hr_utility.set_location(lv_procedure_name,1);
2129: if(hr_utility.debug_enabled) then
2130: -- write debug statements
2131: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
2132: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
2133: end if;
2127: begin
2128: hr_utility.set_location(lv_procedure_name,1);
2129: if(hr_utility.debug_enabled) then
2130: -- write debug statements
2131: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
2132: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
2133: end if;
2134:
2135: -- processing logic
2128: hr_utility.set_location(lv_procedure_name,1);
2129: if(hr_utility.debug_enabled) then
2130: -- write debug statements
2131: hr_utility.set_location('Entered'||lv_procedure_name||'with itemtype:'||p_item_type, 2);
2132: hr_utility.set_location('Entered'||lv_procedure_name||'with itemkey:'||p_item_key, 2);
2133: end if;
2134:
2135: -- processing logic
2136: if(p_item_type is null OR p_item_key is null) then
2319: end if;
2320:
2321:
2322:
2323: if(hr_utility.debug_enabled) then
2324: -- write debug statements
2325: hr_utility.set_location('Leaving '||lv_procedure_name||'with itemtype:'||p_item_type, 10);
2326: end if;
2327:
2321:
2322:
2323: if(hr_utility.debug_enabled) then
2324: -- write debug statements
2325: hr_utility.set_location('Leaving '||lv_procedure_name||'with itemtype:'||p_item_type, 10);
2326: end if;
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
2331: hr_utility.raise_error;
2332: return null;
2333: end getNextApproverForHist;
2334:
2335: function Authenticate(p_username in varchar2,