[Home] [Help]
33: --
34: l_dummy number(1);
35: c_proc constant varchar2(60) := 'create_item_attrib_if_notexist';
36: begin
37: g_debug := hr_utility.debug_enabled;
38: if g_debug then
39: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
40: end if;
41:
35: c_proc constant varchar2(60) := 'create_item_attrib_if_notexist';
36: begin
37: g_debug := hr_utility.debug_enabled;
38: if g_debug then
39: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
40: end if;
41:
42:
43: if g_debug then
40: end if;
41:
42:
43: if g_debug then
44: hr_utility.set_location('opening cursor csr_wiav with itemtype:'|| itemtype ||' , itemkey: '|| itemkey ||' , aname: '|| aname, 1);
45: end if;
46: -- open the cursor to determine if the a
47: open csr_wiav(itemtype,itemkey,aname);
48: fetch csr_wiav into l_dummy;
49: if csr_wiav%notfound then
50: --
51: -- item attribute does not exist so create it
52: if g_debug then
53: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);
54: end if;
55: wf_engine.additemattr
56: (itemtype => itemtype
57: ,itemkey => itemkey
65: if csr_wiav%found then
66: -- set the values as per the type
67: if(text_value is not null) then
68: if g_debug then
69: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);
70: end if;
71: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);
72: end if;
73:
72: end if;
73:
74: if(number_value is not null) then
75: if g_debug then
76: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);
77: end if;
78: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);
79: end if;
80:
79: end if;
80:
81: if(date_value is not null) then
82: if g_debug then
83: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);
84: end if;
85: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);
86: end if;
87:
89:
90: close csr_wiav;
91:
92: if (g_debug ) then
93: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
94: end if;
95:
96: exception
97: when others then
95:
96: exception
97: when others then
98: if g_debug then
99: hr_utility.set_location('Error in create_item_attrib_if_notexist SQLERRM' ||' '||to_char(SQLCODE),20);
100: end if;
101: raise;
102:
103: end create_item_attrib_if_notexist;
109: IS
110: -- Local Variables
111: l_proc constant varchar2(100) := g_package ||'.'|| 'set_custom_wf_globals';
112: BEGIN
113: g_debug := hr_utility.debug_enabled;
114: hr_utility.set_location('Entering: '|| l_proc,1);
115:
116: if g_debug then
117: hr_utility.set_location('Setting hr_approval_custom.g_itemtype as :'|| p_itemtype,2);
110: -- Local Variables
111: l_proc constant varchar2(100) := g_package ||'.'|| 'set_custom_wf_globals';
112: BEGIN
113: g_debug := hr_utility.debug_enabled;
114: hr_utility.set_location('Entering: '|| l_proc,1);
115:
116: if g_debug then
117: hr_utility.set_location('Setting hr_approval_custom.g_itemtype as :'|| p_itemtype,2);
118: hr_utility.set_location('Setting hr_approval_custom.g_itemkey as :'|| p_itemkey,3);
113: g_debug := hr_utility.debug_enabled;
114: hr_utility.set_location('Entering: '|| l_proc,1);
115:
116: if g_debug then
117: hr_utility.set_location('Setting hr_approval_custom.g_itemtype as :'|| p_itemtype,2);
118: hr_utility.set_location('Setting hr_approval_custom.g_itemkey as :'|| p_itemkey,3);
119: end if;
120:
121: hr_approval_custom.g_itemtype := p_itemtype;
114: hr_utility.set_location('Entering: '|| l_proc,1);
115:
116: if g_debug then
117: hr_utility.set_location('Setting hr_approval_custom.g_itemtype as :'|| p_itemtype,2);
118: hr_utility.set_location('Setting hr_approval_custom.g_itemkey as :'|| p_itemkey,3);
119: end if;
120:
121: hr_approval_custom.g_itemtype := p_itemtype;
122: hr_approval_custom.g_itemkey := p_itemkey;
119: end if;
120:
121: hr_approval_custom.g_itemtype := p_itemtype;
122: hr_approval_custom.g_itemkey := p_itemkey;
123: hr_utility.set_location('Leaving: '|| l_proc,10);
124: END set_custom_wf_globals;
125:
126: function getOAFPageActId(p_item_type in wf_items.item_type%type,
127: p_item_key in wf_items.item_key%type) return number
129: -- local variables
130: c_proc constant varchar2(30) := 'storeApproverDetails';
131: ln_activity_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
132: begin
133: g_debug := hr_utility.debug_enabled;
134: if g_debug then
135: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
136: end if;
137:
131: ln_activity_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
132: begin
133: g_debug := hr_utility.debug_enabled;
134: if g_debug then
135: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
136: end if;
137:
138: -- get the blockid value corresponding to the UI page
139: SELECT process_activity
165: order by begin_date desc)
166: where rownum<=1;
167:
168: if (g_debug ) then
169: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
170: end if;
171:
172: return ln_activity_id;
173:
201: lv_recipient varchar2(250);
202: lv_new_transaction varchar2(250);
203: l_cpersonId VARCHAR2(15);
204: begin
205: g_debug := hr_utility.debug_enabled;
206:
207: if g_debug then
208: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
209: end if;
204: begin
205: g_debug := hr_utility.debug_enabled;
206:
207: if g_debug then
208: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
209: end if;
210:
211: -- get the transaction id of the sshr transaction
212: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
242: null;
243: end;
244:
245: if g_debug then
246: hr_utility.set_location('processing notification response, notification_id:'||wf_engine.context_nid,2);
247: hr_utility.set_location('lv_result_code:'||lv_result_code,3);
248: end if;
249:
250: -- possible actions
243: end;
244:
245: if g_debug then
246: hr_utility.set_location('processing notification response, notification_id:'||wf_engine.context_nid,2);
247: hr_utility.set_location('lv_result_code:'||lv_result_code,3);
248: end if;
249:
250: -- possible actions
251: /* APPROVED :Approve
261: -- block update the approval action history
262: begin
263: if(lv_result_code ='APPROVED') then
264: if g_debug then
265: hr_utility.set_location('calling hr_trans_history_api.archive_approve',4);
266: end if;
267: -- use the new routing api's to handle archive
268: hr_trans_history_api.archive_approve(c_transaction_id,
269: wf_engine.context_nid,
271: lv_comments);
272:
273: elsif(lv_result_code='RESUBMIT') then
274: if g_debug then
275: hr_utility.set_location('calling hr_trans_history_api.archive_approve',4);
276: end if;
277: -- use the new routing api's to handle archive
278: hr_trans_history_api.archive_resubmit(c_transaction_id,
279: wf_engine.context_nid,
284: ,'APPROVAL_COMMENT_COPY'));
285: elsif(lv_result_code='REJECTED') then
286:
287: if g_debug then
288: hr_utility.set_location('calling hr_trans_history_api.archive_reject',5);
289: end if;
290: -- archive the action to history
291: hr_trans_history_api.archive_reject(c_transaction_id,
292: wf_engine.context_nid,
293: wf_engine.context_user,
294: lv_comments);
295: elsif(lv_result_code='RETURNEDFORCORRECTION') then
296: if g_debug then
297: hr_utility.set_location('calling hr_trans_history_api.archive_rfc',6);
298: end if;
299: -- archive the action to history
300: hr_trans_history_api.archive_rfc(c_transaction_id,
301: wf_engine.context_nid,
303: lv_comments);
304: --wf_engine.context_user_comment);
305: elsif(lv_result_code='DEL') then
306: if g_debug then
307: hr_utility.set_location('calling hr_trans_history_api.archive_delete',7);
308: end if;
309: -- archive the action to history
310: hr_trans_history_api.archive_delete(c_transaction_id,
311: wf_engine.context_nid,
350:
351: hr_multi_tenancy_pkg.set_context_for_person(l_cpersonId);
352: end if;
353: if g_debug then
354: hr_utility.set_location('calling hr_trans_history_api.archive_timeout',7);
355: end if;
356: lv_new_transaction := wf_engine.getitemattrtext(p_item_type,
357: p_item_key,
358: 'HR_NEW_TRANSACTION',true);
383: result:= 'COMPLETE:'||lv_result_code;
384: end if;
385:
386: if g_debug then
387: hr_utility.set_location('returning with the result'||result,8);
388: end if;
389:
390:
391: if (g_debug ) then
388: end if;
389:
390:
391: if (g_debug ) then
392: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
393: end if;
394: exception
395: when others then
396: hr_utility.set_location('Error:'|| g_package||'.'||c_proc, 10);
392: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
393: end if;
394: exception
395: when others then
396: hr_utility.set_location('Error:'|| g_package||'.'||c_proc, 10);
397: raise;
398:
399: end handleArchive;
400:
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
412: g_debug := hr_utility.debug_enabled;
413: if g_debug then
414: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
415: end if;
416: -- get the current forward to approver details
410:
411: begin
412: g_debug := hr_utility.debug_enabled;
413: if g_debug then
414: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
415: end if;
416: -- get the current forward to approver details
417: l_current_forward_to_id :=
418: nvl(wf_engine.GetItemAttrNumber
448:
449:
450:
451: if g_debug then
452: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
453: end if;
454:
455: wf_directory.GetRoleName--GetUserName
456: (p_orig_system => l_current_forward_to_origSys
537: -- Get the username and display name for forward from person
538: -- and save to item attributes
539: --
540: if g_debug then
541: hr_utility.set_location('calling wf_directory.GetRoleName for p_orig_system:'|| l_current_forward_to_origSys ||' and p_orig_system_id:'|| l_current_forward_to_id,2);
542: end if;
543: wf_directory.GetRoleName--GetUserName
544: (p_orig_system => l_current_forward_to_origSys
545: ,p_orig_system_id => l_current_forward_to_id
611: date_value=>null
612: );
613:
614: if (g_debug ) then
615: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
616: end if;
617: exception
618: when others then
619: raise;
628: l_current_forward_to_disp_name wf_users.display_name%type;
629: l_role_name varchar2(1000) := null;
630:
631: begin
632: g_debug := hr_utility.debug_enabled;
633: if g_debug then
634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
635: end if;
636:
630:
631: begin
632: g_debug := hr_utility.debug_enabled;
633: if g_debug then
634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
635: end if;
636:
637: -- set the passed approver values to the forward to item attributes
638:
641: ,itemkey => p_item_key
642: ,aname => 'FORWARD_FROM_ROLE_NAME'
643: ,ignore_notfound=>true);
644:
645: hr_utility.set_location('storeprll l_current_forward_to_username: '|| l_current_forward_to_username, 1);
646:
647: if( l_current_forward_to_username is null) then
648:
649: hr_utility.set_location('storeprll l_current_forward_to_username is null: '|| l_current_forward_to_username, 2);
645: hr_utility.set_location('storeprll l_current_forward_to_username: '|| l_current_forward_to_username, 1);
646:
647: if( l_current_forward_to_username is null) then
648:
649: hr_utility.set_location('storeprll l_current_forward_to_username is null: '|| l_current_forward_to_username, 2);
650:
651: l_current_forward_to_username := fnd_global.user_name;
652:
653: hr_utility.set_location('storeprll l_current_forward_to_username: '|| l_current_forward_to_username, 3);
649: hr_utility.set_location('storeprll l_current_forward_to_username is null: '|| l_current_forward_to_username, 2);
650:
651: l_current_forward_to_username := fnd_global.user_name;
652:
653: hr_utility.set_location('storeprll l_current_forward_to_username: '|| l_current_forward_to_username, 3);
654:
655:
656: end if;
657:
699: ,avalue => null);
700:
701:
702: if (g_debug ) then
703: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
704: end if;
705: exception
706: when others then
707: raise;
737:
738:
739:
740: begin
741: g_debug := hr_utility.debug_enabled;
742: if g_debug then
743: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
744: end if;
745:
739:
740: begin
741: g_debug := hr_utility.debug_enabled;
742: if g_debug then
743: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
744: end if;
745:
746: --
747: l_creator_person_id := wf_engine.GetItemAttrNumber
1056:
1057: end if;
1058:
1059: if (g_debug ) then
1060: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1061: end if;
1062: exception
1063: when others then
1064: raise;
1070: is
1071: -- local variables
1072: c_proc constant varchar2(60) := 'populateApproverDetails';
1073: begin
1074: g_debug := hr_utility.debug_enabled;
1075:
1076: if g_debug then
1077: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1078: end if;
1073: begin
1074: g_debug := hr_utility.debug_enabled;
1075:
1076: if g_debug then
1077: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1078: end if;
1079: -- create and/or populate approver details to item attributes
1080: -- same structer as ame_util.approverRecord2
1081: -- HR_APR_NAME_ATTR
1268: date_value=>null);
1269:
1270:
1271: if (g_debug ) then
1272: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1273: end if;
1274:
1275: exception
1276: when others then
1283: is
1284: -- local variables
1285: c_proc constant varchar2(60) := 'populateApproverDetails';
1286: begin
1287: g_debug := hr_utility.debug_enabled;
1288:
1289: if g_debug then
1290: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1291: end if;
1286: begin
1287: g_debug := hr_utility.debug_enabled;
1288:
1289: if g_debug then
1290: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1291: end if;
1292: -- create and/or populate approver details to item attributes
1293: -- same structer as ame_util.approverRecord2
1294:
1468: date_value=>null);
1469:
1470:
1471: if (g_debug ) then
1472: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1473: end if;
1474:
1475: exception
1476: when others then
1490: l_current_forward_to_disp_name wf_users.display_name%type;
1491: l_is_parallel varchar2(10) := null;
1492:
1493: begin
1494: g_debug := hr_utility.debug_enabled;
1495:
1496: if g_debug then
1497: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1498: end if;
1493: begin
1494: g_debug := hr_utility.debug_enabled;
1495:
1496: if g_debug then
1497: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1498: end if;
1499: if ( funmode = wf_engine.eng_run ) then
1500: -- HR_APR_CATEGORY_ATTR
1501: lv_current_approver_category :=wf_engine.GetItemAttrText(itemtype => p_item_type ,
1560: end if;
1561:
1562:
1563: if (g_debug ) then
1564: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1565: end if;
1566: exception
1567: when others then
1568: raise;
1574: p_item_key in varchar2) return boolean is
1575: lv_result varchar2(50);
1576: c_proc constant varchar2(60) := 'isPreNonAMEFYIComplete';
1577: begin
1578: g_debug := hr_utility.debug_enabled;
1579: if g_debug then
1580: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1581: end if;
1582:
1576: c_proc constant varchar2(60) := 'isPreNonAMEFYIComplete';
1577: begin
1578: g_debug := hr_utility.debug_enabled;
1579: if g_debug then
1580: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1581: end if;
1582:
1583: -- call the initialize code
1584: --HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1634: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'
1635: ,avalue=>null);
1636:
1637: if (g_debug ) then
1638: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 11);
1639: end if;
1640: return false;
1641: else
1642: if (g_debug ) then
1639: end if;
1640: return false;
1641: else
1642: if (g_debug ) then
1643: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 12);
1644: end if;
1645: return true;
1646: end if;
1647: exception
1646: end if;
1647: exception
1648: when others then
1649: if g_debug then
1650: hr_utility.set_location('Error in isPreNonAMEFYIComplete SQLERRM' ||' '||to_char(SQLCODE),20);
1651: end if;
1652: raise;
1653: end isPreNonAMEFYIComplete;
1654:
1657: p_item_key in varchar2) return boolean is
1658: lv_result varchar2(50);
1659: c_proc constant varchar2(60) := 'isPostNonAMEFYIComplete';
1660: begin
1661: g_debug := hr_utility.debug_enabled;
1662:
1663: if g_debug then
1664: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1665: end if;
1660: begin
1661: g_debug := hr_utility.debug_enabled;
1662:
1663: if g_debug then
1664: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1665: end if;
1666:
1667: -- fyiApproverCategory
1668: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONAPPROVAL_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1714: ,itemkey => p_item_key
1715: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'
1716: ,avalue=>null);
1717: if (g_debug ) then
1718: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 11);
1719: end if;
1720: return false;
1721: else
1722: if (g_debug ) then
1719: end if;
1720: return false;
1721: else
1722: if (g_debug ) then
1723: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 12);
1724: end if;
1725: return true;
1726: end if;
1727: exception
1726: end if;
1727: exception
1728: when others then
1729: if g_debug then
1730: hr_utility.set_location('Error in isPostNonAMEFYIComplete SQLERRM' ||' '||to_char(SQLCODE),20);
1731: end if;
1732: raise;
1733:
1734: end isPostNonAMEFYIComplete;
1741: l_users varchar2(1000) := null;
1742: l_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
1743:
1744: begin
1745: g_debug := hr_utility.debug_enabled;
1746:
1747: if g_debug then
1748: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1749: end if;
1744: begin
1745: g_debug := hr_utility.debug_enabled;
1746:
1747: if g_debug then
1748: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1749: end if;
1750:
1751: wf_directory.GetRoleInfo2(p_role_name,l_approver_role_info_tbl);
1752:
1750:
1751: wf_directory.GetRoleInfo2(p_role_name,l_approver_role_info_tbl);
1752:
1753: if g_debug then
1754: hr_utility.set_location('l_approver_role_info_tbl(1).name : '|| l_approver_role_info_tbl(1).name, 999);
1755: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system : '|| l_approver_role_info_tbl(1).orig_system, 999);
1756: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system_id : '|| l_approver_role_info_tbl(1).orig_system_id, 999);
1757: hr_utility.set_location('l_approver_role_info_tbl(1).display_name : '|| l_approver_role_info_tbl(1).display_name, 999);
1758: end if;
1751: wf_directory.GetRoleInfo2(p_role_name,l_approver_role_info_tbl);
1752:
1753: if g_debug then
1754: hr_utility.set_location('l_approver_role_info_tbl(1).name : '|| l_approver_role_info_tbl(1).name, 999);
1755: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system : '|| l_approver_role_info_tbl(1).orig_system, 999);
1756: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system_id : '|| l_approver_role_info_tbl(1).orig_system_id, 999);
1757: hr_utility.set_location('l_approver_role_info_tbl(1).display_name : '|| l_approver_role_info_tbl(1).display_name, 999);
1758: end if;
1759:
1752:
1753: if g_debug then
1754: hr_utility.set_location('l_approver_role_info_tbl(1).name : '|| l_approver_role_info_tbl(1).name, 999);
1755: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system : '|| l_approver_role_info_tbl(1).orig_system, 999);
1756: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system_id : '|| l_approver_role_info_tbl(1).orig_system_id, 999);
1757: hr_utility.set_location('l_approver_role_info_tbl(1).display_name : '|| l_approver_role_info_tbl(1).display_name, 999);
1758: end if;
1759:
1760:
1753: if g_debug then
1754: hr_utility.set_location('l_approver_role_info_tbl(1).name : '|| l_approver_role_info_tbl(1).name, 999);
1755: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system : '|| l_approver_role_info_tbl(1).orig_system, 999);
1756: hr_utility.set_location('l_approver_role_info_tbl(1).orig_system_id : '|| l_approver_role_info_tbl(1).orig_system_id, 999);
1757: hr_utility.set_location('l_approver_role_info_tbl(1).display_name : '|| l_approver_role_info_tbl(1).display_name, 999);
1758: end if;
1759:
1760:
1761: -- create and/or populate approver details to item attributes
1780: date_value=>null);
1781:
1782:
1783: if (g_debug ) then
1784: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1785: end if;
1786:
1787: exception
1788: when others then
1829:
1830: --
1831:
1832: BEGIN
1833: g_debug := hr_utility.debug_enabled;
1834: c_approvalprocesscompleteynout := ame_util.booleanFalse;
1835:
1836: if g_debug then
1837: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1833: g_debug := hr_utility.debug_enabled;
1834: c_approvalprocesscompleteynout := ame_util.booleanFalse;
1835:
1836: if g_debug then
1837: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1838: end if;
1839:
1840: error_message_text := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1841: itemkey => p_item_key,
1873: -- expose the wf control variables to the custom package
1874: -- -----------------------------------------------------------------------
1875: -- Needed for backward compatibility
1876: if g_debug then
1877: hr_utility.set_location('calling set_custom_wf_globals with p_item_type: '|| p_item_type ||' and p_item_key:' || p_item_key,2);
1878: end if;
1879:
1880: set_custom_wf_globals
1881: (p_itemtype => p_item_type
1882: ,p_itemkey => p_item_key);
1883:
1884: -- check if the pre-notification process for non-AME FYI is completed
1885: if g_debug then
1886: hr_utility.set_location('calling isPreNonAMEFYIComplete with p_item_type: '|| p_item_type ||' and p_item_key:' || p_item_key,3);
1887: end if;
1888:
1889: if(NOT isPreNonAMEFYIComplete(p_item_type,p_item_key)) then
1890: result := 'COMPLETE:'||'N';
1900: aname => 'TRANSACTION_ID');
1901: if(c_transaction_type is not null) then
1902: begin
1903: if g_debug then
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1901: if(c_transaction_type is not null) then
1902: begin
1903: if g_debug then
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1909: end if;
1902: begin
1903: if g_debug then
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1909: end if;
1910: ame_api2.getNextApprovers4
1903: if g_debug then
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1909: end if;
1910: ame_api2.getNextApprovers4
1911: (applicationIdIn => c_application_id
1904: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
1905: hr_utility.set_location('c_application_id:'||c_application_id,5);
1906: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
1907: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
1908: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
1909: end if;
1910: ame_api2.getNextApprovers4
1911: (applicationIdIn => c_application_id
1912: ,transactionTypeIn => c_transaction_type
1915: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
1916: ,nextApproversOut => c_next_approvers);
1917:
1918: if g_debug then
1919: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);
1920: end if;
1921:
1922: -- Parallel Approvers case
1923: if(c_next_approvers.COUNT >1 ) then
1922: -- Parallel Approvers case
1923: if(c_next_approvers.COUNT >1 ) then
1924:
1925: if g_debug then
1926: hr_utility.set_location('Entered into Parallel Approval mode', 1);
1927: end if;
1928:
1929: create_item_attrib_if_notexist(itemtype=>p_item_type,
1930: itemkey=>p_item_key,
1938:
1939: if c_next_approvers.count > 0 then
1940: for l_index in 1 .. c_next_approvers.count
1941: loop
1942: hr_utility.set_location('Approver Name : ' || c_next_approvers(l_index).name,115);
1943: hr_utility.set_location('Approver Orig system : ' || c_next_approvers(l_index).orig_system,115);
1944:
1945: if(c_next_approvers(l_index).orig_system = 'PQH_ROLE' OR c_next_approvers(l_index).orig_system = 'POS') then
1946: for c in c_get_users_from_role(c_next_approvers(l_index).name) loop
1939: if c_next_approvers.count > 0 then
1940: for l_index in 1 .. c_next_approvers.count
1941: loop
1942: hr_utility.set_location('Approver Name : ' || c_next_approvers(l_index).name,115);
1943: hr_utility.set_location('Approver Orig system : ' || c_next_approvers(l_index).orig_system,115);
1944:
1945: if(c_next_approvers(l_index).orig_system = 'PQH_ROLE' OR c_next_approvers(l_index).orig_system = 'POS') then
1946: for c in c_get_users_from_role(c_next_approvers(l_index).name) loop
1947: IF l_users IS NULL THEN
1962: -- added as fix for Bug 16221443
1963: populatePrllApprDet(p_item_type,p_item_key,c_next_approvers(1));
1964: end if;
1965:
1966: hr_utility.set_location('l_users : ' || l_users,111);
1967:
1968: l_role_name:='PRLL_APPR_'||c_transaction_id || '_'|| l_users;
1969: l_role_display:='Parallel Approvers Group For '||c_transaction_id || ' '|| l_users;
1970: l_role_exists:='N';
1969: l_role_display:='Parallel Approvers Group For '||c_transaction_id || ' '|| l_users;
1970: l_role_exists:='N';
1971:
1972: if g_debug then
1973: hr_utility.set_location('l_role_name : ' || l_role_name, 1);
1974: hr_utility.set_location('l_role_display : ' || l_role_display, 1);
1975: end if;
1976:
1977: -- Check if the ADHOC role already exists
1970: l_role_exists:='N';
1971:
1972: if g_debug then
1973: hr_utility.set_location('l_role_name : ' || l_role_name, 1);
1974: hr_utility.set_location('l_role_display : ' || l_role_display, 1);
1975: end if;
1976:
1977: -- Check if the ADHOC role already exists
1978: OPEN c_chk_wf_role(l_role_name);
2007: END IF; -- approver count
2008: else
2009:
2010: if g_debug then
2011: hr_utility.set_location('Entered into Serial Approval mode', 1);
2012: end if;
2013: if(c_approvalprocesscompleteynout<>'Y') then
2014: create_item_attrib_if_notexist(itemtype=>p_item_type,
2015: itemkey=>p_item_key,
2023:
2024: exception
2025: when others then
2026: if g_debug then
2027: hr_utility.set_location('Error in isFinalApprover, SQLERRM' ||' '||to_char(SQLCODE),20);
2028: end if;
2029: handleApprovalErrors(p_item_type, p_item_key, sqlerrm);
2030: result := 'COMPLETE:'||'E';
2031: return;
2041: p_approver_rec=>c_approver_to_notify_rec);
2042: exception
2043: when others then
2044: if g_debug then
2045: hr_utility.set_location('Error in isFinalApprover calling hr_approval_ss.getNextCustomApprover, SQLERRM' ||' '||to_char(SQLCODE),20);
2046: end if;
2047: raise;
2048: end;
2049: end if ; -- check for AME
2049: end if ; -- check for AME
2050:
2051:
2052: if g_debug then
2053: hr_utility.set_location('c_approvalprocesscompleteynout:'||c_approvalprocesscompleteynout,12);
2054: end if;
2055:
2056: -- check if the approval process is complete
2057: if(c_approvalprocesscompleteynout='Y') then
2057: if(c_approvalprocesscompleteynout='Y') then
2058: result := 'COMPLETE:'||'Y';
2059: -- check if the pre-notification process for non-AME FYI is completed
2060: if g_debug then
2061: hr_utility.set_location('calling isPostNonAMEFYIComplete',13);
2062: end if;
2063:
2064: if(NOT isPostNonAMEFYIComplete(p_item_type,p_item_key)) then
2065: result := 'COMPLETE:'||'N';
2082: end if;
2083:
2084:
2085: if (g_debug ) then
2086: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 50);
2087: end if;
2088:
2089:
2090: EXCEPTION
2089:
2090: EXCEPTION
2091: WHEN OTHERS THEN
2092: if g_debug then
2093: hr_utility.set_location('Error in isFinalApprover , SQLERRM' ||' '||to_char(SQLCODE),30);
2094: end if;
2095: raise;
2096:
2097: END isFinalApprover ;
2114: c_approvalprocesscompleteynout ame_util.charType;
2115: l_current_forward_to_username wf_users.name%type;
2116:
2117: begin
2118: g_debug := hr_utility.debug_enabled;
2119:
2120: if g_debug then
2121: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2122: end if;
2117: begin
2118: g_debug := hr_utility.debug_enabled;
2119:
2120: if g_debug then
2121: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2122: end if;
2123: if ( funmode = wf_engine.eng_run ) then
2124: -- call PQH_SS_HISTORY.transfer_approval_to_history
2125: if g_debug then
2122: end if;
2123: if ( funmode = wf_engine.eng_run ) then
2124: -- call PQH_SS_HISTORY.transfer_approval_to_history
2125: if g_debug then
2126: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_approval_to_history ',2);
2127: hr_utility.set_location('p_item_type:'|| p_item_type,3);
2128: hr_utility.set_location('p_item_key:'|| p_item_key,4);
2129: end if;
2130:
2123: if ( funmode = wf_engine.eng_run ) then
2124: -- call PQH_SS_HISTORY.transfer_approval_to_history
2125: if g_debug then
2126: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_approval_to_history ',2);
2127: hr_utility.set_location('p_item_type:'|| p_item_type,3);
2128: hr_utility.set_location('p_item_key:'|| p_item_key,4);
2129: end if;
2130:
2131: PQH_SS_HISTORY.transfer_approval_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2124: -- call PQH_SS_HISTORY.transfer_approval_to_history
2125: if g_debug then
2126: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_approval_to_history ',2);
2127: hr_utility.set_location('p_item_type:'|| p_item_type,3);
2128: hr_utility.set_location('p_item_key:'|| p_item_key,4);
2129: end if;
2130:
2131: PQH_SS_HISTORY.transfer_approval_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2132: -- reset the status to pending approval
2130:
2131: PQH_SS_HISTORY.transfer_approval_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2132: -- reset the status to pending approval
2133: if g_debug then
2134: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_approve_status ',5);
2135: hr_utility.set_location('p_item_type:'|| p_item_type,6);
2136: hr_utility.set_location('p_item_key:'|| p_item_key,7);
2137: end if;
2138:
2131: PQH_SS_HISTORY.transfer_approval_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2132: -- reset the status to pending approval
2133: if g_debug then
2134: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_approve_status ',5);
2135: hr_utility.set_location('p_item_type:'|| p_item_type,6);
2136: hr_utility.set_location('p_item_key:'|| p_item_key,7);
2137: end if;
2138:
2139: PQH_SS_WORKFLOW.set_txn_approve_status(p_item_type,p_item_key,p_act_id,funmode,result);
2132: -- reset the status to pending approval
2133: if g_debug then
2134: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_approve_status ',5);
2135: hr_utility.set_location('p_item_type:'|| p_item_type,6);
2136: hr_utility.set_location('p_item_key:'|| p_item_key,7);
2137: end if;
2138:
2139: PQH_SS_WORKFLOW.set_txn_approve_status(p_item_type,p_item_key,p_act_id,funmode,result);
2140:
2140:
2141: end if;
2142:
2143: if (g_debug ) then
2144: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2145: end if;
2146: exception
2147: when others then
2148: raise;
2219:
2220:
2221: begin
2222:
2223: g_debug := hr_utility.debug_enabled;
2224:
2225: if g_debug then
2226: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2227: end if;
2222:
2223: g_debug := hr_utility.debug_enabled;
2224:
2225: if g_debug then
2226: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2227: end if;
2228: if ( funmode = wf_engine.eng_run ) then
2229: -- check if it is AME or custom approvals
2230: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2238: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2239: itemkey => p_item_key,
2240: aname => 'HR_AME_TRAN_TYPE_ATTR');
2241: if(c_transaction_type is not null) then
2242: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
2243:
2244: notification_rec.notification_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2245: itemkey => p_item_key,
2246: aname => 'HR_CONTEXT_NID_ATTR');
2255:
2256: if(l_is_parallel = 'PARALLEL') then
2257:
2258: if g_debug then
2259: hr_utility.set_location('Approval mode is parallel', 1);
2260: end if;
2261:
2262: if(notification_rec.notification_id is not null) then
2263:
2312: itemkey => p_item_key,
2313: aname => 'RETURN_TO_USERNAME'));
2314:
2315: if g_debug then
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2313: aname => 'RETURN_TO_USERNAME'));
2314:
2315: if g_debug then
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2321: end if;
2314:
2315: if g_debug then
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2321: end if;
2322:
2315: if g_debug then
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2321: end if;
2322:
2323: hr_utility.set_location('before update AME: ' || l_current_forward_to_username,111);
2316: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2317: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2318: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2321: end if;
2322:
2323: hr_utility.set_location('before update AME: ' || l_current_forward_to_username,111);
2324:
2319: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2320: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2321: end if;
2322:
2323: hr_utility.set_location('before update AME: ' || l_current_forward_to_username,111);
2324:
2325:
2326:
2327: begin
2350: ,itemkey => p_item_key
2351: ,aname => 'FORWARD_FROM_ROLE_NAME'
2352: ,ignore_notfound=>true);
2353:
2354: hr_utility.set_location('l_role_name: ' || l_role_name,111);
2355:
2356:
2357:
2358:
2358:
2359: exception
2360: when others then
2361: if g_debug then
2362: hr_utility.set_location('Error in updateApproveStatus SQLERRM' ||' '||to_char(SQLCODE),10);
2363: end if;
2364: hr_utility.trace('ORCL error '||SQLERRM);
2365: --start code fix for bug 13610627
2366: --result := wf_engine.eng_trans_default;
2360: when others then
2361: if g_debug then
2362: hr_utility.set_location('Error in updateApproveStatus SQLERRM' ||' '||to_char(SQLCODE),10);
2363: end if;
2364: hr_utility.trace('ORCL error '||SQLERRM);
2365: --start code fix for bug 13610627
2366: --result := wf_engine.eng_trans_default;
2367: handleApprovalErrors(p_item_type, p_item_key, sqlerrm);
2368: result := 'COMPLETE:'||'FAILURE';
2370: return;
2371: end;
2372:
2373: if g_debug then
2374: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
2375: end if;
2376:
2377: --result := wf_engine.eng_trans_default;
2378: result := 'COMPLETE:'||'SUCCESS';
2393: result := 'COMPLETE:'||'SUCCESS';
2394: end if;
2395:
2396: if (g_debug ) then
2397: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 20);
2398: end if;
2399: exception
2400: when others then
2401: if g_debug then
2398: end if;
2399: exception
2400: when others then
2401: if g_debug then
2402: hr_utility.set_location('Error in updateApproveStatus SQLERRM' ||' '||to_char(SQLCODE),30);
2403: end if;
2404: raise;
2405: end updateApproveStatus;
2406:
2414: lv_current_approver_category varchar2(4000);
2415: ln_sublist_order_number number;
2416: c_proc constant varchar2(60) := 'approver_category';
2417: begin
2418: g_debug := hr_utility.debug_enabled;
2419:
2420: if g_debug then
2421: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2422: end if;
2417: begin
2418: g_debug := hr_utility.debug_enabled;
2419:
2420: if g_debug then
2421: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2422: end if;
2423:
2424: -- get the current approver category
2425: -- HR_APR_CATEGORY_ATTR
2446: result:= 'COMPLETE:'||'POST';
2447: end if;
2448:
2449: if (g_debug ) then
2450: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2451: end if;
2452:
2453: exception
2454: when others then
2452:
2453: exception
2454: when others then
2455: if g_debug then
2456: hr_utility.set_location('Error in approver_category SQLERRM' ||' '||to_char(SQLCODE),20);
2457: end if;
2458: raise;
2459:
2460: end approver_category;
2478: c_next_approvers ame_util.approverstable2;
2479: c_approvalprocesscompleteynout varchar2(1) ;
2480:
2481: begin
2482: g_debug := hr_utility.debug_enabled;
2483:
2484: if g_debug then
2485: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2486: end if;
2481: begin
2482: g_debug := hr_utility.debug_enabled;
2483:
2484: if g_debug then
2485: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2486: end if;
2487: if ( funmode = wf_engine.eng_run ) then
2488: -- check if it is AME or custom approvals
2489: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2497: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2498: itemkey => p_item_key,
2499: aname => 'HR_AME_TRAN_TYPE_ATTR');
2500: if(c_transaction_type is not null) then
2501: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
2502:
2503: l_is_parallel := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2504: itemkey => p_item_key,
2505: aname => 'HR_PARALLEL_ATTR',
2563: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR');
2564: if(l_curr_fwd_to_orig_system_id is not null) then
2565:
2566: if g_debug then
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2564: if(l_curr_fwd_to_orig_system_id is not null) then
2565:
2566: if g_debug then
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2565:
2566: if g_debug then
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2566: if g_debug then
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2574:
2567: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2574:
2575: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2568: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2569: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2570: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2571: hr_utility.set_location('approvalStatusIn:'|| ame_util.notifiedStatus, 6);
2572: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2573: end if;
2574:
2575: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2576: transactionTypeIn =>c_transaction_type,
2604: end if;
2605: end if;
2606:
2607: if (g_debug ) then
2608: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2609: end if;
2610: exception
2611: when others then
2612: if g_debug then
2609: end if;
2610: exception
2611: when others then
2612: if g_debug then
2613: hr_utility.set_location('Error in flagApproversAsNotified SQLERRM' ||' '||to_char(SQLCODE),20);
2614: end if;
2615: raise;
2616: end flagApproversAsNotified;
2617:
2639: from wf_user_roles
2640: where role_name = p_role_name;
2641:
2642: begin
2643: g_debug := hr_utility.debug_enabled;
2644:
2645: if g_debug then
2646: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2647: end if;
2642: begin
2643: g_debug := hr_utility.debug_enabled;
2644:
2645: if g_debug then
2646: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2647: end if;
2648: if ( funmode = wf_engine.eng_run ) then
2649: -- check if it is AME or custom approvals
2650: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2658: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2659: itemkey => p_item_key,
2660: aname => 'HR_AME_TRAN_TYPE_ATTR');
2661: if(c_transaction_type is not null) then
2662: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
2663:
2664:
2665: l_is_parallel := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2666: itemkey => p_item_key,
2678: ,approvalProcessCompleteYNOut => c_approvalprocesscompleteynout
2679: ,nextApproversOut => c_next_approvers);
2680:
2681: if g_debug then
2682: hr_utility.set_location('returned from ame_api2.getNextApprovers4, number records fetched:'||c_next_approvers.count,9);
2683: end if;
2684:
2685: if(c_next_approvers.COUNT >1 ) then
2686:
2687:
2688: if c_next_approvers.count > 0 then
2689: for l_index in 1 .. c_next_approvers.count
2690: loop
2691: hr_utility.set_location('Approver Name : ' || c_next_approvers(l_index).name,115);
2692: hr_utility.set_location('Approver Orig system : ' || c_next_approvers(l_index).orig_system,115);
2693:
2694: if(c_next_approvers(l_index).orig_system = 'PQH_ROLE' OR c_next_approvers(l_index).orig_system = 'POS') then
2695: for c in c_get_users_from_role(c_next_approvers(l_index).name) loop
2688: if c_next_approvers.count > 0 then
2689: for l_index in 1 .. c_next_approvers.count
2690: loop
2691: hr_utility.set_location('Approver Name : ' || c_next_approvers(l_index).name,115);
2692: hr_utility.set_location('Approver Orig system : ' || c_next_approvers(l_index).orig_system,115);
2693:
2694: if(c_next_approvers(l_index).orig_system = 'PQH_ROLE' OR c_next_approvers(l_index).orig_system = 'POS') then
2695: for c in c_get_users_from_role(c_next_approvers(l_index).name) loop
2696: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2732: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
2733: ,itemkey => p_item_key
2734: ,aname => 'FORWARD_TO_USERNAME');
2735: if g_debug then
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2733: ,itemkey => p_item_key
2734: ,aname => 'FORWARD_TO_USERNAME');
2735: if g_debug then
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2734: ,aname => 'FORWARD_TO_USERNAME');
2735: if g_debug then
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2735: if g_debug then
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2743:
2736: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2743:
2744: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2737: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
2738: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
2739: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
2740: hr_utility.set_location('approvalStatusIn:'|| ame_util.noResponseStatus, 6);
2741: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2742: end if;
2743:
2744: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
2745: transactionTypeIn =>c_transaction_type,
2764: pqh_ss_workflow.set_txn_approve_status(p_item_type,p_item_key,p_act_id,funmode,result);
2765: end if;
2766:
2767: if (g_debug ) then
2768: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2769: end if;
2770:
2771:
2772: exception
2787:
2788: begin
2789:
2790:
2791: g_debug := hr_utility.debug_enabled;
2792:
2793: if g_debug then
2794: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2795: end if;
2790:
2791: g_debug := hr_utility.debug_enabled;
2792:
2793: if g_debug then
2794: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2795: end if;
2796:
2797: if ( funmode = 'RESPOND' OR funmode = 'TIMEOUT') then
2798: create_item_attrib_if_notexist(itemtype=>p_item_type,
2857: return;
2858: end if;
2859:
2860: if (g_debug ) then
2861: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2862: end if;
2863:
2864:
2865:
2865:
2866: exception
2867: when others then
2868: if g_debug then
2869: hr_utility.set_location('Error in setRespondedUserContext SQLERRM' ||' '||to_char(SQLCODE),20);
2870: end if;
2871: raise;
2872: end setRespondedUserContext;
2873:
2892: lv_result varchar2(100);
2893: lv_comments wf_item_attribute_values.text_value%type;
2894:
2895: begin
2896: g_debug := hr_utility.debug_enabled;
2897:
2898: if g_debug then
2899: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2900: end if;
2895: begin
2896: g_debug := hr_utility.debug_enabled;
2897:
2898: if g_debug then
2899: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2900: end if;
2901: if ( funmode = wf_engine.eng_run ) then
2902: -- Creating attribute to check the new transaction
2903: create_item_attrib_if_notexist(itemtype => p_item_type
2935: -- call the other intialization routines needed for approval
2936: -- notification process
2937: -- PQH_SS_HISTORY.transfer_submit_to_history
2938: if g_debug then
2939: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_submit_to_history', 2);
2940: hr_utility.set_location('p_item_type:'|| p_item_type, 3);
2941: hr_utility.set_location('p_item_key:'|| p_item_key, 4);
2942: end if;
2943: -- PQH_SS_HISTORY.transfer_submit_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2936: -- notification process
2937: -- PQH_SS_HISTORY.transfer_submit_to_history
2938: if g_debug then
2939: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_submit_to_history', 2);
2940: hr_utility.set_location('p_item_type:'|| p_item_type, 3);
2941: hr_utility.set_location('p_item_key:'|| p_item_key, 4);
2942: end if;
2943: -- PQH_SS_HISTORY.transfer_submit_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2944: -- use the new history API's
2937: -- PQH_SS_HISTORY.transfer_submit_to_history
2938: if g_debug then
2939: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_submit_to_history', 2);
2940: hr_utility.set_location('p_item_type:'|| p_item_type, 3);
2941: hr_utility.set_location('p_item_key:'|| p_item_key, 4);
2942: end if;
2943: -- PQH_SS_HISTORY.transfer_submit_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2944: -- use the new history API's
2945: -- add the code plugin transfer history
2951: lv_comments);
2952:
2953: -- HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES
2954: if g_debug then
2955: hr_utility.set_location('calling HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES', 5);
2956: hr_utility.set_location('p_item_type:'|| p_item_type, 6);
2957: hr_utility.set_location('p_item_key:'|| p_item_key, 7);
2958: end if;
2959:
2952:
2953: -- HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES
2954: if g_debug then
2955: hr_utility.set_location('calling HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES', 5);
2956: hr_utility.set_location('p_item_type:'|| p_item_type, 6);
2957: hr_utility.set_location('p_item_key:'|| p_item_key, 7);
2958: end if;
2959:
2960: HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
2953: -- HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES
2954: if g_debug then
2955: hr_utility.set_location('calling HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES', 5);
2956: hr_utility.set_location('p_item_type:'|| p_item_type, 6);
2957: hr_utility.set_location('p_item_key:'|| p_item_key, 7);
2958: end if;
2959:
2960: HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
2961: HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,p_act_id,funmode,result);
2961: HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,p_act_id,funmode,result);
2962:
2963: -- PQH_SS_WORKFLOW.set_image_source
2964: if g_debug then
2965: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_image_source', 8);
2966: hr_utility.set_location('p_item_type:'|| p_item_type, 9);
2967: hr_utility.set_location('p_item_key:'|| p_item_key, 10);
2968: end if;
2969:
2962:
2963: -- PQH_SS_WORKFLOW.set_image_source
2964: if g_debug then
2965: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_image_source', 8);
2966: hr_utility.set_location('p_item_type:'|| p_item_type, 9);
2967: hr_utility.set_location('p_item_key:'|| p_item_key, 10);
2968: end if;
2969:
2970: PQH_SS_WORKFLOW.set_image_source(p_item_type,p_item_key,p_act_id,funmode,result);
2963: -- PQH_SS_WORKFLOW.set_image_source
2964: if g_debug then
2965: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_image_source', 8);
2966: hr_utility.set_location('p_item_type:'|| p_item_type, 9);
2967: hr_utility.set_location('p_item_key:'|| p_item_key, 10);
2968: end if;
2969:
2970: PQH_SS_WORKFLOW.set_image_source(p_item_type,p_item_key,p_act_id,funmode,result);
2971: result := 'COMPLETE:'||'Y';
2978:
2979: end if;
2980:
2981: if (g_debug ) then
2982: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2983: end if;
2984: exception
2985: when others then
2986: if g_debug then
2983: end if;
2984: exception
2985: when others then
2986: if g_debug then
2987: hr_utility.set_location('Error in submit_for_approval SQLERRM' ||' '||to_char(SQLCODE),20);
2988: end if;
2989: raise;
2990: end submit_for_approval;
2991:
3009: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3010: lv_result_display varchar2(250);
3011:
3012: begin
3013: g_debug := hr_utility.debug_enabled;
3014:
3015: if g_debug then
3016: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3017: end if;
3012: begin
3013: g_debug := hr_utility.debug_enabled;
3014:
3015: if g_debug then
3016: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3017: end if;
3018:
3019: handleArchive(p_item_type,
3020: p_item_key,
3022: funmode,
3023: result);
3024:
3025: if g_debug then
3026: hr_utility.set_location('returning with the result'||result,8);
3027: end if;
3028:
3029:
3030: if (g_debug ) then
3027: end if;
3028:
3029:
3030: if (g_debug ) then
3031: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
3032: end if;
3033:
3034: exception
3035: when others then
3033:
3034: exception
3035: when others then
3036: if g_debug then
3037: hr_utility.set_location('Error in setSFLResponseContext SQLERRM' ||' '||to_char(SQLCODE),20);
3038: end if;
3039: raise;
3040: end setSFLResponseContext;
3041:
3065: l_transaction_ref_table VARCHAR2(50);
3066: l_transaction_ref_id NUMBER;
3067:
3068: begin
3069: g_debug := hr_utility.debug_enabled;
3070:
3071: if g_debug then
3072: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3073: end if;
3068: begin
3069: g_debug := hr_utility.debug_enabled;
3070:
3071: if g_debug then
3072: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3073: end if;
3074:
3075: --sturlapa coding starts for bug 3866581
3076: begin
3099:
3100: OPEN csr_txn(c_transaction_id);
3101: FETCH csr_txn INTO l_transaction_ref_table,l_transaction_ref_id;
3102: CLOSE csr_txn;
3103: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);
3104: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN
3105: hr_utility.trace('returning with resubmit as we donot want RFC deletion for appraisal');
3106: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
3107: RETURN;
3101: FETCH csr_txn INTO l_transaction_ref_table,l_transaction_ref_id;
3102: CLOSE csr_txn;
3103: hr_utility.trace('txn_ref_table: '||l_transaction_ref_table);
3104: IF NVL(l_transaction_ref_table,'XXX') = 'PER_APPRAISALS' and lv_result_code = 'DEL' THEN
3105: hr_utility.trace('returning with resubmit as we donot want RFC deletion for appraisal');
3106: result := 'COMPLETE:XYZ'; --so that this takes the default option in the WF
3107: RETURN;
3108: END IF;
3109: ---END Changes by KMG
3113: p_act_id,
3114: funmode,
3115: result);
3116: if g_debug then
3117: hr_utility.set_location('returning with the result'||result,8);
3118: end if;
3119:
3120:
3121:
3120:
3121:
3122:
3123: if (g_debug ) then
3124: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
3125: end if;
3126:
3127: exception
3128: when others then
3126:
3127: exception
3128: when others then
3129: if g_debug then
3130: hr_utility.set_location('Error in setRFCResponseContext SQLERRM' ||' '||to_char(SQLCODE),20);
3131: end if;
3132: raise;
3133: end setRFCResponseContext;
3134:
3166: person_id = l_new_fwd_person_id;*/
3167:
3168: begin
3169:
3170: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3171:
3172: if ( funmode = 'TRANSFER' ) then
3173: -- TRANSFER - When a notification recipient transfers the notification.
3174: -- check if it is AME or custom approvals
3184: itemkey => p_item_key,
3185: aname => 'HR_AME_TRAN_TYPE_ATTR');
3186:
3187: if(c_transaction_type is not null) then
3188: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
3189:
3190: /*
3191: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
3192: ,itemkey => p_item_key
3212: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
3213: itemkey => p_item_key,
3214: aname => 'RETURN_TO_USERNAME'));
3215: if g_debug then
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3213: itemkey => p_item_key,
3214: aname => 'RETURN_TO_USERNAME'));
3215: if g_debug then
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3214: aname => 'RETURN_TO_USERNAME'));
3215: if g_debug then
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3222: end if;
3215: if g_debug then
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3222: end if;
3223:
3216: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3222: end if;
3223:
3224: begin
3217: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
3218: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
3219: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
3220: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
3221: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
3222: end if;
3223:
3224: begin
3225:
3232: rec_forwardee.orig_system_id :=l_new_fwd_person_id;
3233: rec_forwardee.display_name :=l_new_fwd_display_name;
3234: --rec_forwardee.api_insertion:='Y';
3235:
3236: hr_utility.set_location('new approver person id:'|| l_new_fwd_person_id, 7);
3237:
3238:
3239:
3240: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,
3257: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3258: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USER',getToString(p_item_key) || wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3266: end if;
3259:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3266: end if;
3267:
3260: if g_debug then
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3266: end if;
3267:
3268: ame_api2.getNextApprovers4
3261: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
3262: hr_utility.set_location('c_application_id:'||c_application_id,5);
3263: hr_utility.set_location('c_transaction_type:'|| c_transaction_type,6);
3264: hr_utility.set_location('c_transaction_id:'|| c_transaction_id,7);
3265: hr_utility.set_location('flagApproversAsNotifiedIn:'|| ame_util.booleanFalse,8);
3266: end if;
3267:
3268: ame_api2.getNextApprovers4
3269: (applicationIdIn => c_application_id
3276:
3277: exception
3278: when others then
3279: if g_debug then
3280: hr_utility.set_location('Error in updateApproveStatus SQLERRM' ||' '||to_char(SQLCODE),10);
3281: end if;
3282:
3283: result := 'COMPLETE:' || 'ERROR';
3284: return;
3284: return;
3285: end ;
3286:
3287: if g_debug then
3288: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
3289: end if;
3290:
3291:
3292:
3298:
3299: end if;
3300:
3301:
3302: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 20);
3303: -- hr_utility.trace_off;
3304: exception
3305: when others then
3306:
3299: end if;
3300:
3301:
3302: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 20);
3303: -- hr_utility.trace_off;
3304: exception
3305: when others then
3306:
3307: hr_utility.set_location('Error in setNtfTransferCtx SQLERRM' ||' '||to_char(SQLCODE),30);
3303: -- hr_utility.trace_off;
3304: exception
3305: when others then
3306:
3307: hr_utility.set_location('Error in setNtfTransferCtx SQLERRM' ||' '||to_char(SQLCODE),30);
3308:
3309: raise;
3310: end setNtfTransferCtx;
3311:
3339:
3340:
3341: begin
3342:
3343: g_debug := hr_utility.debug_enabled;
3344:
3345:
3346: if g_debug then
3347: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3343: g_debug := hr_utility.debug_enabled;
3344:
3345:
3346: if g_debug then
3347: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3348: end if;
3349:
3350: -- added for bug 13485539
3351: if hr_multi_tenancy_pkg.is_multi_tenant_system then
3354: ,itemkey => p_item_key
3355: ,aname => 'CREATOR_PERSON_ID'),-1);
3356:
3357: hr_multi_tenancy_pkg.set_context_for_person(l_cpersonId);
3358: -- hr_utility.set_location('After callto multi DBG_'||sa_session.row_label('HR_ENTERPRISE_POLICY')||':Entering',5);
3359: end if;
3360: -- End of addition for bug 13485539
3361: -- capture the approver login context information
3362:
3376: if(l_is_parallel = 'PARALLEL') then
3377:
3378:
3379: if g_debug then
3380: hr_utility.set_location('Approval mode is parallel', 1);
3381: end if;
3382:
3383: l_notification_id := wf_engine.context_nid;
3384: l_current_forward_to_username:= wf_engine.context_original_recipient;
3397:
3398:
3399: else
3400: if g_debug then
3401: hr_utility.set_location('Approval mode is serial', 1);
3402: end if;
3403: lv_new_transaction := wf_engine.getitemattrtext(p_item_type,
3404: p_item_key,
3405: 'HR_NEW_TRANSACTION',true);
3424:
3425:
3426:
3427: if (g_debug ) then
3428: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
3429: end if;
3430: exception
3431: when others then
3432: if g_debug then
3429: end if;
3430: exception
3431: when others then
3432: if g_debug then
3433: hr_utility.set_location('Error in setApproverResponseContext SQLERRM' ||' '||to_char(SQLCODE),20);
3434: end if;
3435:
3436: raise;
3437: end setApproverResponseContext;
3457:
3458: l_proc constant varchar2(100) := g_package || ' reset_ame_to_rfc_state';
3459: begin
3460:
3461: g_debug := hr_utility.debug_enabled;
3462: c_match_found := 'N';
3463:
3464: IF g_debug THEN
3465: hr_utility.set_location('Entering:'||l_proc, 1);
3461: g_debug := hr_utility.debug_enabled;
3462: c_match_found := 'N';
3463:
3464: IF g_debug THEN
3465: hr_utility.set_location('Entering:'||l_proc, 1);
3466: END IF;
3467:
3468:
3469: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
3488: aname => 'NOTE_FROM_APPR');
3489:
3490: if(c_transaction_type is not null) then
3491: if g_debug then
3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);
3493: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;
3489:
3490: if(c_transaction_type is not null) then
3491: if g_debug then
3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);
3493: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;
3497:
3490: if(c_transaction_type is not null) then
3491: if g_debug then
3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);
3493: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;
3497:
3498: ame_api2.getAllApprovers7(applicationIdIn =>c_application_id,
3491: if g_debug then
3492: hr_utility.set_location('calling ame_api2.getAllApprovers7', 2);
3493: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3494: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3495: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3496: end if;
3497:
3498: ame_api2.getAllApprovers7(applicationIdIn =>c_application_id,
3499: transactionTypeIn =>c_transaction_type,
3528:
3529:
3530:
3531:
3532: hr_utility.set_location('c_creator_user : ' || c_creator_user,111);
3533: hr_utility.set_location('c_return_user : ' || c_return_user,111);
3534:
3535: IF ( c_return_user IS NULL OR c_creator_user = c_return_user ) THEN
3536: c_rfc_initiator := 'Y';
3529:
3530:
3531:
3532: hr_utility.set_location('c_creator_user : ' || c_creator_user,111);
3533: hr_utility.set_location('c_return_user : ' || c_return_user,111);
3534:
3535: IF ( c_return_user IS NULL OR c_creator_user = c_return_user ) THEN
3536: c_rfc_initiator := 'Y';
3537: hr_utility.set_location('c_rfc_initiator is Y',111);
3533: hr_utility.set_location('c_return_user : ' || c_return_user,111);
3534:
3535: IF ( c_return_user IS NULL OR c_creator_user = c_return_user ) THEN
3536: c_rfc_initiator := 'Y';
3537: hr_utility.set_location('c_rfc_initiator is Y',111);
3538: ELSE
3539: c_rfc_initiator := 'N';
3540: hr_utility.set_location('c_rfc_initiator is N',111);
3541: END IF;
3536: c_rfc_initiator := 'Y';
3537: hr_utility.set_location('c_rfc_initiator is Y',111);
3538: ELSE
3539: c_rfc_initiator := 'N';
3540: hr_utility.set_location('c_rfc_initiator is N',111);
3541: END IF;
3542:
3543: hr_utility.set_location('Entering For Loop',111);
3544: for i in 1..c_all_approvers.count loop
3539: c_rfc_initiator := 'N';
3540: hr_utility.set_location('c_rfc_initiator is N',111);
3541: END IF;
3542:
3543: hr_utility.set_location('Entering For Loop',111);
3544: for i in 1..c_all_approvers.count loop
3545:
3546: hr_utility.set_location('c_all_approvers(i).name : ' || c_all_approvers(i).name,111);
3547: hr_utility.set_location('c_rfc_initiator : ' || c_rfc_initiator,111);
3542:
3543: hr_utility.set_location('Entering For Loop',111);
3544: for i in 1..c_all_approvers.count loop
3545:
3546: hr_utility.set_location('c_all_approvers(i).name : ' || c_all_approvers(i).name,111);
3547: hr_utility.set_location('c_rfc_initiator : ' || c_rfc_initiator,111);
3548:
3549: IF ( c_rfc_initiator = 'N' AND c_return_user = c_all_approvers(i).name ) THEN
3550: c_match_found := 'Y';
3543: hr_utility.set_location('Entering For Loop',111);
3544: for i in 1..c_all_approvers.count loop
3545:
3546: hr_utility.set_location('c_all_approvers(i).name : ' || c_all_approvers(i).name,111);
3547: hr_utility.set_location('c_rfc_initiator : ' || c_rfc_initiator,111);
3548:
3549: IF ( c_rfc_initiator = 'N' AND c_return_user = c_all_approvers(i).name ) THEN
3550: c_match_found := 'Y';
3551: END IF;
3548:
3549: IF ( c_rfc_initiator = 'N' AND c_return_user = c_all_approvers(i).name ) THEN
3550: c_match_found := 'Y';
3551: END IF;
3552: hr_utility.set_location('c_match_found :' || c_match_found,111);
3553:
3554: IF (c_rfc_initiator = 'Y' OR (c_rfc_initiator = 'N' AND c_match_found = 'Y' ) ) THEN
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3552: hr_utility.set_location('c_match_found :' || c_match_found,111);
3553:
3554: IF (c_rfc_initiator = 'Y' OR (c_rfc_initiator = 'N' AND c_match_found = 'Y' ) ) THEN
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3553:
3554: IF (c_rfc_initiator = 'Y' OR (c_rfc_initiator = 'N' AND c_match_found = 'Y' ) ) THEN
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3554: IF (c_rfc_initiator = 'Y' OR (c_rfc_initiator = 'N' AND c_match_found = 'Y' ) ) THEN
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3562: hr_utility.set_location('c_rfc_user:'|| c_rfc_user, 8);
3555:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3562: hr_utility.set_location('c_rfc_user:'|| c_rfc_user, 8);
3563:
3556: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3562: hr_utility.set_location('c_rfc_user:'|| c_rfc_user, 8);
3563:
3564:
3557: hr_utility.set_location('c_application_id:'|| c_application_id, 3);
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3562: hr_utility.set_location('c_rfc_user:'|| c_rfc_user, 8);
3563:
3564:
3565: IF (c_rfc_user = c_all_approvers(i).name) THEN
3558: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 4);
3559: hr_utility.set_location('c_transaction_id:'|| c_transaction_id, 5);
3560: hr_utility.set_location('approvalStatusIn:'|| null, 6);
3561: hr_utility.set_location('approverNameIn:'|| c_all_approvers(i).name, 7);
3562: hr_utility.set_location('c_rfc_user:'|| c_rfc_user, 8);
3563:
3564:
3565: IF (c_rfc_user = c_all_approvers(i).name) THEN
3566:
3597: end loop;
3598: end if;
3599:
3600: IF g_debug THEN
3601: hr_utility.set_location('Leaving:'|| l_proc, 35);
3602: END IF;
3603:
3604: EXCEPTION
3605: when others then
3602: END IF;
3603:
3604: EXCEPTION
3605: when others then
3606: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
3607: hr_utility.trace(' exception in '||l_proc||' : ' || sqlerrm);
3608:
3609: Wf_Core.Context(g_package, l_proc, p_item_type, p_item_key);
3610: raise;
3603:
3604: EXCEPTION
3605: when others then
3606: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
3607: hr_utility.trace(' exception in '||l_proc||' : ' || sqlerrm);
3608:
3609: Wf_Core.Context(g_package, l_proc, p_item_type, p_item_key);
3610: raise;
3611: end reset_ame_to_rfc_state;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:
3626: begin
3627: g_debug := hr_utility.debug_enabled;
3628: if g_debug then
3629: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3630: end if;
3631:
3625:
3626: begin
3627: g_debug := hr_utility.debug_enabled;
3628: if g_debug then
3629: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3630: end if;
3631:
3632: -- functional logic
3633: -- case : notification sent to M3 for approval
3648: aname => 'CREATOR_PERSON_USERNAME');
3649:
3650: c_return_user := nvl(c_return_user,c_creator_user);
3651:
3652: hr_utility.set_location('c_return_user' || c_return_user,111);
3653: hr_utility.set_location('c_creator_user' || c_creator_user,111);
3654:
3655:
3656: -- get the return to user orig system and sys id
3649:
3650: c_return_user := nvl(c_return_user,c_creator_user);
3651:
3652: hr_utility.set_location('c_return_user' || c_return_user,111);
3653: hr_utility.set_location('c_creator_user' || c_creator_user,111);
3654:
3655:
3656: -- get the return to user orig system and sys id
3657: wf_directory.GetRoleInfo2(c_return_user,c_return_user_role_info_tbl);
3681:
3682:
3683: ---- get the current approver orig system and sys id
3684:
3685: hr_utility.set_location('l_curr_approver_role' || l_curr_approver_role,111);
3686:
3687: wf_directory.GetRoleInfo2(l_curr_approver_role,l_curr_approver_role_info_tbl);
3688:
3689: hr_utility.set_location('l_curr_approver_role_info_tbl(1).display_name' || l_curr_approver_role_info_tbl(1).display_name,111);
3685: hr_utility.set_location('l_curr_approver_role' || l_curr_approver_role,111);
3686:
3687: wf_directory.GetRoleInfo2(l_curr_approver_role,l_curr_approver_role_info_tbl);
3688:
3689: hr_utility.set_location('l_curr_approver_role_info_tbl(1).display_name' || l_curr_approver_role_info_tbl(1).display_name,111);
3690: hr_utility.set_location('c_return_user_role_info_tbl(1).display_name' || c_return_user_role_info_tbl(1).display_name,111);
3691:
3692: -- FORWARD_FROM_DISPLAY_NAME
3693: -- set the attribute value to null
3686:
3687: wf_directory.GetRoleInfo2(l_curr_approver_role,l_curr_approver_role_info_tbl);
3688:
3689: hr_utility.set_location('l_curr_approver_role_info_tbl(1).display_name' || l_curr_approver_role_info_tbl(1).display_name,111);
3690: hr_utility.set_location('c_return_user_role_info_tbl(1).display_name' || c_return_user_role_info_tbl(1).display_name,111);
3691:
3692: -- FORWARD_FROM_DISPLAY_NAME
3693: -- set the attribute value to null
3694: create_item_attrib_if_notexist(itemtype => p_item_type
3813: date_value=>null
3814: );
3815:
3816: if (g_debug ) then
3817: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
3818: end if;
3819:
3820: exception
3821: when others then
3819:
3820: exception
3821: when others then
3822: if g_debug then
3823: hr_utility.set_location('Error in reset_approval_rfc_data SQLERRM' ||' '||to_char(SQLCODE),20);
3824: end if;
3825: raise;
3826: end reset_approval_rfc_data;
3827:
3851: lv_queryProcedure varchar2(4000);
3852: begin
3853:
3854:
3855: g_debug := hr_utility.debug_enabled;
3856: if g_debug then
3857: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3858: end if;
3859: if ( funmode = wf_engine.eng_run ) then
3853:
3854:
3855: g_debug := hr_utility.debug_enabled;
3856: if g_debug then
3857: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
3858: end if;
3859: if ( funmode = wf_engine.eng_run ) then
3860:
3861: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3882: -- check if we have product overwrite which does not allow RFC and
3883: -- action would default to delete the transaction
3884: -- HR_CUSTOM_RETURN_FOR_CORR
3885: if g_debug then
3886: hr_utility.set_location('checking product specific custom RFC',2);
3887: end if;
3888: lv_customRFC:=wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CUSTOM_RETURN_FOR_CORR',true);
3889: lv_customRFC:= nvl(lv_customRFC,'N');
3890: if g_debug then
3887: end if;
3888: lv_customRFC:=wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CUSTOM_RETURN_FOR_CORR',true);
3889: lv_customRFC:= nvl(lv_customRFC,'N');
3890: if g_debug then
3891: hr_utility.set_location('lv_customRFC:'||lv_customRFC,3);
3892: end if;
3893:
3894: if(lv_customRFC='Y') then
3895: -- no more processing return to delete the transaction
3898: end if;
3899:
3900: -- call PQH_SS_HISTORY.transfer_approval_to_history
3901: if g_debug then
3902: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_rfc_status',3);
3903: hr_utility.set_location('p_item_type:'|| p_item_type,4);
3904: hr_utility.set_location('p_item_key:'|| p_item_key,5);
3905: end if;
3906:
3899:
3900: -- call PQH_SS_HISTORY.transfer_approval_to_history
3901: if g_debug then
3902: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_rfc_status',3);
3903: hr_utility.set_location('p_item_type:'|| p_item_type,4);
3904: hr_utility.set_location('p_item_key:'|| p_item_key,5);
3905: end if;
3906:
3907: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3900: -- call PQH_SS_HISTORY.transfer_approval_to_history
3901: if g_debug then
3902: hr_utility.set_location('calling PQH_SS_WORKFLOW.set_txn_rfc_status',3);
3903: hr_utility.set_location('p_item_type:'|| p_item_type,4);
3904: hr_utility.set_location('p_item_key:'|| p_item_key,5);
3905: end if;
3906:
3907: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3908:
3906:
3907: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3908:
3909: if g_debug then
3910: hr_utility.set_location('calling reset_approval_rfc_data',6);
3911: hr_utility.set_location('p_item_type:'|| p_item_type,7);
3912: hr_utility.set_location('p_item_key:'|| p_item_key,8);
3913: end if;
3914:
3907: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
3908:
3909: if g_debug then
3910: hr_utility.set_location('calling reset_approval_rfc_data',6);
3911: hr_utility.set_location('p_item_type:'|| p_item_type,7);
3912: hr_utility.set_location('p_item_key:'|| p_item_key,8);
3913: end if;
3914:
3915: begin
3908:
3909: if g_debug then
3910: hr_utility.set_location('calling reset_approval_rfc_data',6);
3911: hr_utility.set_location('p_item_type:'|| p_item_type,7);
3912: hr_utility.set_location('p_item_key:'|| p_item_key,8);
3913: end if;
3914:
3915: begin
3916: hr_utility.set_location('Calling reset_approval_rfc_data',111);
3912: hr_utility.set_location('p_item_key:'|| p_item_key,8);
3913: end if;
3914:
3915: begin
3916: hr_utility.set_location('Calling reset_approval_rfc_data',111);
3917: reset_approval_rfc_data(p_item_type,p_item_key);
3918: exception
3919: when others then
3920:
3934:
3935: if(lv_queryProcedure is not null or lv_queryProcedure<>'') then
3936:
3937: if g_debug then
3938: hr_utility.set_location('Calling queryProcedure: '||lv_queryProcedure, 20);
3939: hr_utility.set_location('p_item_type: '|| p_item_type, 21);
3940: hr_utility.set_location('p_item_key: '|| p_item_key, 22);
3941: hr_utility.set_location('p_act_id: '|| p_act_id, 23);
3942: end if;
3935: if(lv_queryProcedure is not null or lv_queryProcedure<>'') then
3936:
3937: if g_debug then
3938: hr_utility.set_location('Calling queryProcedure: '||lv_queryProcedure, 20);
3939: hr_utility.set_location('p_item_type: '|| p_item_type, 21);
3940: hr_utility.set_location('p_item_key: '|| p_item_key, 22);
3941: hr_utility.set_location('p_act_id: '|| p_act_id, 23);
3942: end if;
3943:
3936:
3937: if g_debug then
3938: hr_utility.set_location('Calling queryProcedure: '||lv_queryProcedure, 20);
3939: hr_utility.set_location('p_item_type: '|| p_item_type, 21);
3940: hr_utility.set_location('p_item_key: '|| p_item_key, 22);
3941: hr_utility.set_location('p_act_id: '|| p_act_id, 23);
3942: end if;
3943:
3944: lv_dynamicQuery :=
3937: if g_debug then
3938: hr_utility.set_location('Calling queryProcedure: '||lv_queryProcedure, 20);
3939: hr_utility.set_location('p_item_type: '|| p_item_type, 21);
3940: hr_utility.set_location('p_item_key: '|| p_item_key, 22);
3941: hr_utility.set_location('p_act_id: '|| p_act_id, 23);
3942: end if;
3943:
3944: lv_dynamicQuery :=
3945: 'begin ' ||
3952: in p_act_id,
3953: in funmode,
3954: in out result;
3955: if g_debug then
3956: hr_utility.set_location('After queryProcedure: '|| lv_queryProcedure, 40);
3957: hr_utility.set_location('result: '|| result, 41);
3958: end if;
3959:
3960: end if;
3953: in funmode,
3954: in out result;
3955: if g_debug then
3956: hr_utility.set_location('After queryProcedure: '|| lv_queryProcedure, 40);
3957: hr_utility.set_location('result: '|| result, 41);
3958: end if;
3959:
3960: end if;
3961: exception
3980: result := wf_engine.eng_completed||':YES_INIT';
3981: end if;
3982:
3983: if g_debug then
3984: hr_utility.set_location('leaving with resultcode :'|| result,9);
3985: end if;
3986:
3987:
3988: end if;
3987:
3988: end if;
3989:
3990: if (g_debug ) then
3991: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
3992: end if;
3993: exception
3994: when others then
3995: if g_debug then
3992: end if;
3993: exception
3994: when others then
3995: if g_debug then
3996: hr_utility.set_location('Error in processRFC SQLERRM' ||' '||to_char(SQLCODE),20);
3997: end if;
3998: raise;
3999: end processRFC;
4000:
4007: c_proc constant varchar2(30) := 'processRFC';
4008: lv_role_displayName wf_users.display_name%type;
4009: lv_roleName wf_users.name%type;
4010: begin
4011: g_debug := hr_utility.debug_enabled;
4012: if g_debug then
4013: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4014: end if;
4015: if(p_orig_system is null or p_orig_system_id is null) then
4009: lv_roleName wf_users.name%type;
4010: begin
4011: g_debug := hr_utility.debug_enabled;
4012: if g_debug then
4013: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4014: end if;
4015: if(p_orig_system is null or p_orig_system_id is null) then
4016: lv_role_displayName :=wf_directory.getroledisplayname(p_user_name);
4017: else
4024: return lv_role_displayName;
4025: exception
4026: when others then
4027: if g_debug then
4028: hr_utility.set_location('Error in getRoleDisplayName SQLERRM' ||' '||to_char(SQLCODE),20);
4029: end if;
4030:
4031: end getRoleDisplayName;
4032:
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4047: begin
4048: g_debug := hr_utility.debug_enabled;
4049: if g_debug then
4050: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4051: end if;
4052: lv_orig_system := p_orig_system;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4047: begin
4048: g_debug := hr_utility.debug_enabled;
4049: if g_debug then
4050: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4051: end if;
4052: lv_orig_system := p_orig_system;
4053: lv_orig_systemId := p_orig_system_id;
4054:
4094:
4095: exception
4096: when others then
4097: if g_debug then
4098: hr_utility.set_location('Error in getRoleDisplayName SQLERRM' ||' '||to_char(SQLCODE),20);
4099: end if;
4100:
4101: end isApproverEditAllowed;
4102:
4107: lv_orig_system wf_roles.parent_orig_system%type;
4108: lv_orig_system_id wf_roles.orig_system_id%type;
4109: lv_user_name wf_roles.name%type;
4110: begin
4111: g_debug := hr_utility.debug_enabled;
4112: if g_debug then
4113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4114: end if;
4115: if(p_notification_id is null) then
4109: lv_user_name wf_roles.name%type;
4110: begin
4111: g_debug := hr_utility.debug_enabled;
4112: if g_debug then
4113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4114: end if;
4115: if(p_notification_id is null) then
4116: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);
4117: else
4128:
4129: exception
4130: when others then
4131: if g_debug then
4132: hr_utility.set_location('Error in getRoleDisplayName SQLERRM' ||' '||to_char(SQLCODE),20);
4133: end if;
4134:
4135: end getuserOrigSystem;
4136:
4141: lv_orig_system wf_roles.parent_orig_system%type;
4142: lv_orig_system_id wf_roles.orig_system_id%type;
4143: lv_user_name wf_roles.name%type;
4144: begin
4145: g_debug := hr_utility.debug_enabled;
4146: if g_debug then
4147: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4148: end if;
4149: if(p_notification_id is null) then
4143: lv_user_name wf_roles.name%type;
4144: begin
4145: g_debug := hr_utility.debug_enabled;
4146: if g_debug then
4147: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4148: end if;
4149: if(p_notification_id is null) then
4150: wf_directory.getroleorigsysinfo(p_user_name,lv_orig_system,lv_orig_system_id);
4151: else
4162:
4163: exception
4164: when others then
4165: if g_debug then
4166: hr_utility.set_location('Error in getUserOrigSystemId SQLERRM' ||' '||to_char(SQLCODE),20);
4167: end if;
4168:
4169: end getUserOrigSystemId;
4170:
4236: )
4237: );
4238:
4239: begin
4240: g_debug := hr_utility.debug_enabled;
4241: if g_debug then
4242: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4243: end if;
4244:
4238:
4239: begin
4240: g_debug := hr_utility.debug_enabled;
4241: if g_debug then
4242: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4243: end if;
4244:
4245:
4246:
4436: null;
4437: end;
4438:
4439: if (g_debug ) then
4440: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
4441: end if;
4442:
4443: exception
4444: when others then
4442:
4443: exception
4444: when others then
4445: if g_debug then
4446: hr_utility.set_location('Error in handleRFCAction SQLERRM' ||' '||to_char(SQLCODE),20);
4447: end if;
4448:
4449: end handleRFCAction;
4450:
4764: lv_item_type wf_items.item_type%type;
4765: lv_item_key wf_items.item_key%type;
4766:
4767: begin
4768: g_debug := hr_utility.debug_enabled;
4769: if g_debug then
4770: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4771: end if;
4772:
4766:
4767: begin
4768: g_debug := hr_utility.debug_enabled;
4769: if g_debug then
4770: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4771: end if;
4772:
4773: -- get the item type item key
4774: if(p_notification_id is not null) then
4816:
4817: exception
4818: when others then
4819: if g_debug then
4820: hr_utility.set_location('Error in reInitPerformerRoles SQLERRM' ||' '||to_char(SQLCODE),20);
4821: end if;
4822: raise;
4823:
4824: end reInitPerformerRoles;
5024: l_employee_name per_all_people_f.full_name%type;
5025: --
5026: BEGIN
5027: --
5028: hr_utility.trace('Finding Person name for person_id :' || p_person_id || ':');
5029: --
5030: open csr_full_name;
5031: fetch csr_full_name into l_employee_name;
5032: --
5034: l_employee_name := ' ';
5035: end if;
5036: close csr_full_name;
5037: --
5038: hr_utility.trace('Found :' || l_employee_name || ':');
5039: --
5040: return l_employee_name;
5041: --
5042: END getPersonNameFromID;
5065: l_role_displayname wf_roles.display_name%type;
5066: l_current_person_name per_all_people_f.full_name%type;
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin
5069: g_debug := hr_utility.debug_enabled;
5070: if g_debug then
5071: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5072: end if;
5073: -- check if the transaction id is passed if not raise exception
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin
5069: g_debug := hr_utility.debug_enabled;
5070: if g_debug then
5071: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5072: end if;
5073: -- check if the transaction id is passed if not raise exception
5074: -- no more iterations
5075: if(p_transaction_id is not null) then
5097: ,p_process_name => lr_transaction_rec.process_name
5098: ) then
5099: -- supply HR error message, p_process_name either does not exist or
5100: -- is NOT a runnable process
5101: hr_utility.set_message(800,'HR_52958_WKF2TSK_INC_PROCESS');
5102: hr_utility.set_message_token('ITEM_TYPE', lr_transaction_rec.item_type);
5103: hr_utility.set_message_token('PROCESS_NAME', lr_transaction_rec.process_name);
5104: hr_utility.raise_error;
5105: end if;
5098: ) then
5099: -- supply HR error message, p_process_name either does not exist or
5100: -- is NOT a runnable process
5101: hr_utility.set_message(800,'HR_52958_WKF2TSK_INC_PROCESS');
5102: hr_utility.set_message_token('ITEM_TYPE', lr_transaction_rec.item_type);
5103: hr_utility.set_message_token('PROCESS_NAME', lr_transaction_rec.process_name);
5104: hr_utility.raise_error;
5105: end if;
5106:
5099: -- supply HR error message, p_process_name either does not exist or
5100: -- is NOT a runnable process
5101: hr_utility.set_message(800,'HR_52958_WKF2TSK_INC_PROCESS');
5102: hr_utility.set_message_token('ITEM_TYPE', lr_transaction_rec.item_type);
5103: hr_utility.set_message_token('PROCESS_NAME', lr_transaction_rec.process_name);
5104: hr_utility.raise_error;
5105: end if;
5106:
5107: -- now check if we need to derive the item key from db seq
5100: -- is NOT a runnable process
5101: hr_utility.set_message(800,'HR_52958_WKF2TSK_INC_PROCESS');
5102: hr_utility.set_message_token('ITEM_TYPE', lr_transaction_rec.item_type);
5103: hr_utility.set_message_token('PROCESS_NAME', lr_transaction_rec.process_name);
5104: hr_utility.raise_error;
5105: end if;
5106:
5107: -- now check if we need to derive the item key from db seq
5108: if(p_item_key is null)then
5306: raise g_no_transaction_id;
5307: end if;
5308:
5309: if (g_debug ) then
5310: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
5311: end if;
5312:
5313: exception
5314: WHEN g_invalid_responsibility THEN
5312:
5313: exception
5314: WHEN g_invalid_responsibility THEN
5315: fnd_message.set_name('PER','HR_SSA_INVALID_RESPONSIBILITY');
5316: hr_utility.raise_error;
5317: when g_wf_error_state then
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5320: fnd_message.set_token('ERRORMSG',p_error_message,true);
5318: -- HR_WF_TRANSACTION_ERROR_SS
5319: fnd_message.set_name('PER','HR_WF_TRANSACTION_ERROR_SS');
5320: fnd_message.set_token('ERRORMSG',p_error_message,true);
5321: fnd_message.set_token('ERRORSTACK',p_errstack,true);
5322: hr_utility.raise_error;
5323: when g_no_transaction_id then
5324: null;
5325: -- handle the proper error message propagation
5326: when others then
5420: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5421: ln_activity_id wf_item_activity_statuses.process_activity%type;
5422: begin
5423: if g_debug then
5424: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5425: end if;
5426:
5427: if(p_transaction_id is not null) then
5428:
5480: end if;
5481: end if;
5482:
5483: if (g_debug ) then
5484: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
5485: end if;
5486: exception
5487: when others then
5488: raise;
5537: ln_loginPersonId fnd_user.employee_id%type;
5538:
5539: begin
5540: if g_debug then
5541: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5542: end if;
5543:
5544: if(p_transaction_id is not null) then
5545:
5656: null; -- null transaction id throw error ??
5657: end if;
5658:
5659: if (g_debug ) then
5660: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
5661: end if;
5662: exception
5663: when others then
5664: raise;
5678: lv_item_key wf_items.item_key%type;
5679: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
5680: begin
5681: if g_debug then
5682: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5683: end if;
5684:
5685: -- code logic
5686:
5697: if(hr_multi_message.is_message_list_enabled) then
5698: fnd_message.set_name('PER', 'HR_SS_NO_TXN_DATA');
5699: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5700: end if;
5701: hr_utility.raise_error;
5702: when others then
5703: raise;
5704: end; -- finished fetching record
5705:
5726: if(hr_multi_message.is_message_list_enabled) then
5727: fnd_message.set_name('PER', 'HR_SS_WF_NOT_INITIALZED');
5728: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5729: end if;
5730: hr_utility.raise_error;
5731: when others then
5732: if hr_multi_message.unexpected_error_add(c_proc) then
5733: hr_utility.set_location(' Leaving:' || c_proc,40);
5734: raise;
5729: end if;
5730: hr_utility.raise_error;
5731: when others then
5732: if hr_multi_message.unexpected_error_add(c_proc) then
5733: hr_utility.set_location(' Leaving:' || c_proc,40);
5734: raise;
5735: end if;
5736: end;
5737:
5743: if(hr_multi_message.is_message_list_enabled) then
5744: fnd_message.set_name('PER', 'HR_SS_NULL_TXN_ID');
5745: hr_multi_message.add(p_message_type => hr_multi_message.G_ERROR_MSG );
5746: end if;
5747: hr_utility.raise_error;
5748: end if;
5749:
5750:
5751:
5749:
5750:
5751:
5752: if (g_debug ) then
5753: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
5754: end if;
5755:
5756: exception
5757: when others then
5835: lv_status hr_api_transactions.status%type;
5836: lv_state hr_api_transactions.transaction_state%type;
5837: begin
5838: if g_debug then
5839: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5840: end if;
5841:
5842:
5843: begin
5850: if(lv_status in ('YS','RIS','ROS')) then
5851: -- saved transaction exists set the warning message
5852:
5853: if(hr_multi_message.is_message_list_enabled) then
5854: hr_utility.set_message(800,'HR_SS_SAVED_TXN_DATA_EXISTS');
5855: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5856: hr_utility.set_warning;
5857: end if;
5858: end if;
5852:
5853: if(hr_multi_message.is_message_list_enabled) then
5854: hr_utility.set_message(800,'HR_SS_SAVED_TXN_DATA_EXISTS');
5855: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5856: hr_utility.set_warning;
5857: end if;
5858: end if;
5859: if(lv_state is not null) then
5860: -- in advertant saved transaction exists set the warning message
5859: if(lv_state is not null) then
5860: -- in advertant saved transaction exists set the warning message
5861:
5862: if(hr_multi_message.is_message_list_enabled) then
5863: hr_utility.set_message(800,'HR_SS_INADV_TXN_DATA_EXISTS');
5864: hr_multi_message.add( p_message_type => hr_multi_message.G_WARNING_MSG);
5865: end if;
5866:
5867: end if;
5871: null; -- do nothing
5872: end ;
5873:
5874: if (g_debug ) then
5875: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
5876: end if;
5877: exception
5878: when others then
5879: raise;
5962:
5963: exception
5964: when others then
5965: if g_debug then
5966: hr_utility.set_location('Error in handleApprovalErrors SQLERRM' ||' '||to_char(SQLCODE),20);
5967: end if;
5968: raise;
5969: end handleApprovalErrors;
5970:
6009:
6010:
6011: begin
6012:
6013: g_debug := hr_utility.debug_enabled;
6014:
6015: if g_debug then
6016: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
6017: end if;
6012:
6013: g_debug := hr_utility.debug_enabled;
6014:
6015: if g_debug then
6016: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
6017: end if;
6018:
6019: begin
6020:
6049: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
6050: itemkey => p_item_key,
6051: aname => 'HR_AME_TRAN_TYPE_ATTR');
6052: if(c_transaction_type is not null) then
6053: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
6054:
6055: notification_rec.notification_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
6056: itemkey => p_item_key,
6057: aname => 'HR_CONTEXT_NID_ATTR');
6066:
6067: if(l_is_parallel = 'PARALLEL') then
6068:
6069: if g_debug then
6070: hr_utility.set_location('Approval mode is parallel', 1);
6071: end if;
6072: if(notification_rec.notification_id is not null) then
6073:
6074: select ORIGINAL_RECIPIENT into original_forward_to_user from wf_notifications where notification_id = notification_rec.notification_id;
6124: aname => 'RETURN_TO_USERNAME'));
6125:
6126:
6127: if g_debug then
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6125:
6126:
6127: if g_debug then
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6133: end if;
6126:
6127: if g_debug then
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6133: end if;
6134:
6127: if g_debug then
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6133: end if;
6134:
6135: begin
6128: hr_utility.set_location('calling ame_api6.updateApproveStatus2 with Reject status', 3);
6129: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
6130: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
6131: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
6132: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
6133: end if;
6134:
6135: begin
6136: ame_api6.updateApprovalStatus2(applicationIdIn=>c_application_id,
6149:
6150: exception
6151: when others then
6152: if g_debug then
6153: hr_utility.set_location('Error in updateRejectStatus SQLERRM' ||' '||to_char(SQLCODE),10);
6154: end if;
6155: raise;
6156: end ;
6157:
6156: end ;
6157:
6158:
6159: if g_debug then
6160: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
6161: end if;
6162:
6163: if(l_is_parallel = 'PARALLEL') then
6164: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(l_current_forward_to_username1));
6180:
6181: end if;
6182:
6183: if (g_debug ) then
6184: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 20);
6185: end if;
6186: exception
6187: when others then
6188: if g_debug then
6185: end if;
6186: exception
6187: when others then
6188: if g_debug then
6189: hr_utility.set_location('Error in updateRejectStatus SQLERRM' ||' '||to_char(SQLCODE),30);
6190: end if;
6191: raise;
6192: end updateRejectStatus;
6193:
6197: c_proc constant varchar2(30) := 'getToString';
6198: toString varchar2(30);
6199:
6200: begin
6201: g_debug := hr_utility.debug_enabled;
6202: if g_debug then
6203: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
6204: end if;
6205:
6199:
6200: begin
6201: g_debug := hr_utility.debug_enabled;
6202: if g_debug then
6203: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
6204: end if;
6205:
6206: begin
6207: select lower(meaning) into toString from hr_lookups where LOOKUP_TYPE = 'BEN_TO_FROM' and lookup_code = 'TO';
6213: return toString || ' ';
6214: exception
6215: when others then
6216: if g_debug then
6217: hr_utility.set_location('Error in getToString SQLERRM' ||' '||to_char(SQLCODE),20);
6218: end if;
6219:
6220: end getToString;
6221: