1: PACKAGE BODY BEN_CWB_RSGN_EMP as
2: /* $Header: bencwbre.pkb 120.3.12010000.2 2008/09/10 11:13:25 cakunuru ship $ */
3: /* ===========================================================================+
4: * Name
5: * Compensation workbench reassign employee
42: *
43: * ==========================================================================+
44: */
45:
46: g_package varchar2(80) := 'ben_cwb_rsgn_emp';
47:
48: FUNCTION get_for_period(p_group_per_in_ler_id IN NUMBER)
49: RETURN VARCHAR2
50: IS
175: EXCEPTION
176: when others then
177: l_error:=sqlerrm;
178: hr_utility.set_location ('exception is'||l_error , 300);
179: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'check_approver',l_error);
180: raise;
181: END check_approver;
182:
183:
251: EXCEPTION
252: when others then
253: l_error:=sqlerrm;
254: hr_utility.set_location ('exception is'||l_error , 300);
255: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
256: raise;
257:
258:
259: end store_approval_details;
287: EXCEPTION
288: when others then
289: l_error:=sqlerrm;
290: hr_utility.set_location ('exception is'||l_error , 300);
291: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'curr_ws_mgr_check',l_error);
292: raise;
293:
294: end curr_ws_mgr_check;
295:
322: EXCEPTION
323: when others then
324: l_error:=sqlerrm;
325: hr_utility.set_location ('exception is'||l_error , 300);
326: --Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'prop_ws_mgr_check',l_error);
327: raise;
328: end prop_ws_mgr_check;
329:
330:
362: EXCEPTION
363: when others then
364: l_error:=sqlerrm;
365: hr_utility.set_location ('exception is'||l_error , 300);
366: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
367: raise;
368: end which_message;
369:
370:
430: l_error:=sqlerrm;
431:
432: hr_utility.set_location ('exception is'||l_error , 300);
433:
434: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'set_rejection',l_error);
435: raise;
436: end set_rejection;
437:
438:
827: -- No longer is use
828: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
829: -- itemkey => l_itemkey
830: -- ,aname => 'EMP_RSGN_SUMMARY'
831: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
832: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
833: -- itemkey => l_itemkey
834: -- ,aname => 'EMP_RSGN_EMP'
835: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
831: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
832: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
833: -- itemkey => l_itemkey
834: -- ,aname => 'EMP_RSGN_EMP'
835: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
836: --
837: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
838: -- itemkey => l_itemkey
839: -- ,aname => 'EMP_RSGN_APPR'
836: --
837: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
838: -- itemkey => l_itemkey
839: -- ,aname => 'EMP_RSGN_APPR'
840: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
841: --
842: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
843: -- itemkey => l_itemkey
844: -- ,aname => 'EMP_RSGN_ERROR'
841: --
842: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
843: -- itemkey => l_itemkey
844: -- ,aname => 'EMP_RSGN_ERROR'
845: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_error_html/'||l_itemkey);
846: -- No longer is use
847:
848:
849: l_for_period := get_for_period (p_prop_ws_mgr_per_in_ler_id);
1026: l_error:=sqlerrm;
1027:
1028: hr_utility.set_location ('exception is'||l_error , 300);
1029:
1030: Wf_Core.Context('BEN_CWB_RSGN_EMP', 'start_workflow',l_error);
1031: raise;
1032:
1033: END start_workflow;
1034:
1152: -- No longer is use
1153: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1154: -- itemkey => l_itemkey
1155: -- ,aname => 'EMP_RSGN_SUMMARY'
1156: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1157: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1158: -- itemkey => l_itemkey
1159: -- ,aname => 'EMP_RSGN_EMP'
1160: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
1156: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1157: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1158: -- itemkey => l_itemkey
1159: -- ,aname => 'EMP_RSGN_EMP'
1160: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
1161: --
1162: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1163: -- itemkey => l_itemkey
1164: -- ,aname => 'EMP_RSGN_APPR'
1161: --
1162: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1163: -- itemkey => l_itemkey
1164: -- ,aname => 'EMP_RSGN_APPR'
1165: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
1166: -- No longer is use
1167:
1168:
1169: l_for_period := get_for_period (p_prop_mgr_per_in_ler_id);
1224: l_error:=sqlerrm;
1225:
1226: hr_utility.set_location ('exception is'||l_error , 300);
1227:
1228: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'send_fyi_notifications',l_error);
1229: raise;
1230: end send_fyi_notifications;
1231:
1232:
1347: l_error:=sqlerrm;
1348:
1349: hr_utility.set_location ('exception is'||l_error , 300);
1350:
1351: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
1352: raise;
1353:
1354:
1355: end store_emp_details;
1382: l_error:=sqlerrm;
1383:
1384: hr_utility.set_location ('exception is'||l_error , 300);
1385:
1386: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'remove_emp_details',l_error);
1387: raise;
1388: end remove_emp_details;
1389:
1390:
1486: -- No longer is use
1487: hr_utility.set_location('Leaving '||l_package ,30);
1488: END;
1489:
1490: END BEN_CWB_RSGN_EMP;