DBA Data[Home] [Help]

APPS.BEN_CWB_RSGN_EMP dependencies on BEN_CWB_RSGN_EMP

Line 1: PACKAGE BODY BEN_CWB_RSGN_EMP as

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

Line 46: g_package varchar2(80) := 'ben_cwb_rsgn_emp';

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

Line 179: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'check_approver',l_error);

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:

Line 255: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);

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;

Line 291: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'curr_ws_mgr_check',l_error);

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:

Line 326: --Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'prop_ws_mgr_check',l_error);

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:

Line 366: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);

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:

Line 434: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'set_rejection',l_error);

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:

Line 831: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);

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);

Line 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'

Line 840: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);

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'

Line 845: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_error_html/'||l_itemkey);

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);

Line 1030: Wf_Core.Context('BEN_CWB_RSGN_EMP', 'start_workflow',l_error);

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:

Line 1156: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);

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);

Line 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'

Line 1165: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);

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);

Line 1228: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'send_fyi_notifications',l_error);

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:

Line 1351: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);

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;

Line 1386: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'remove_emp_details',l_error);

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:

Line 1490: END BEN_CWB_RSGN_EMP;

1486: -- No longer is use
1487: hr_utility.set_location('Leaving '||l_package ,30);
1488: END;
1489:
1490: END BEN_CWB_RSGN_EMP;