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.5.12020000.2 2012/07/03 12:24:48 amnaraya ship $ */
3: /* ===========================================================================+
4: * Name
5: * Compensation workbench reassign employee

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

43: * 115.24 06-MAR-2012 kgowripe Changed procedure store_emp_details
44: * ==========================================================================+
45: */
46:
47: g_package varchar2(80) := 'ben_cwb_rsgn_emp';
48:
49: FUNCTION get_for_period(p_group_per_in_ler_id IN NUMBER)
50: RETURN VARCHAR2
51: IS

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

176: EXCEPTION
177: when others then
178: l_error:=sqlerrm;
179: hr_utility.set_location ('exception is'||l_error , 300);
180: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'check_approver',l_error);
181: raise;
182: END check_approver;
183:
184:

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

252: EXCEPTION
253: when others then
254: l_error:=sqlerrm;
255: hr_utility.set_location ('exception is'||l_error , 300);
256: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
257: raise;
258:
259:
260: end store_approval_details;

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

288: EXCEPTION
289: when others then
290: l_error:=sqlerrm;
291: hr_utility.set_location ('exception is'||l_error , 300);
292: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'curr_ws_mgr_check',l_error);
293: raise;
294:
295: end curr_ws_mgr_check;
296:

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

323: EXCEPTION
324: when others then
325: l_error:=sqlerrm;
326: hr_utility.set_location ('exception is'||l_error , 300);
327: --Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'prop_ws_mgr_check',l_error);
328: raise;
329: end prop_ws_mgr_check;
330:
331:

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

363: EXCEPTION
364: when others then
365: l_error:=sqlerrm;
366: hr_utility.set_location ('exception is'||l_error , 300);
367: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
368: raise;
369: end which_message;
370:
371:

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

431: l_error:=sqlerrm;
432:
433: hr_utility.set_location ('exception is'||l_error , 300);
434:
435: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'set_rejection',l_error);
436: raise;
437: end set_rejection;
438:
439:

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

828: -- No longer is use
829: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
830: -- itemkey => l_itemkey
831: -- ,aname => 'EMP_RSGN_SUMMARY'
832: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
833: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
834: -- itemkey => l_itemkey
835: -- ,aname => 'EMP_RSGN_EMP'
836: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);

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

832: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
833: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
834: -- itemkey => l_itemkey
835: -- ,aname => 'EMP_RSGN_EMP'
836: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
837: --
838: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
839: -- itemkey => l_itemkey
840: -- ,aname => 'EMP_RSGN_APPR'

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

837: --
838: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
839: -- itemkey => l_itemkey
840: -- ,aname => 'EMP_RSGN_APPR'
841: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
842: --
843: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
844: -- itemkey => l_itemkey
845: -- ,aname => 'EMP_RSGN_ERROR'

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

842: --
843: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
844: -- itemkey => l_itemkey
845: -- ,aname => 'EMP_RSGN_ERROR'
846: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_error_html/'||l_itemkey);
847: -- No longer is use
848:
849:
850: l_for_period := get_for_period (p_prop_ws_mgr_per_in_ler_id);

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

1027: l_error:=sqlerrm;
1028:
1029: hr_utility.set_location ('exception is'||l_error , 300);
1030:
1031: Wf_Core.Context('BEN_CWB_RSGN_EMP', 'start_workflow',l_error);
1032: raise;
1033:
1034: END start_workflow;
1035:

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

1153: -- No longer is use
1154: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1155: -- itemkey => l_itemkey
1156: -- ,aname => 'EMP_RSGN_SUMMARY'
1157: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1158: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1159: -- itemkey => l_itemkey
1160: -- ,aname => 'EMP_RSGN_EMP'
1161: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);

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

1157: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1158: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1159: -- itemkey => l_itemkey
1160: -- ,aname => 'EMP_RSGN_EMP'
1161: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
1162: --
1163: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1164: -- itemkey => l_itemkey
1165: -- ,aname => 'EMP_RSGN_APPR'

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

1162: --
1163: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1164: -- itemkey => l_itemkey
1165: -- ,aname => 'EMP_RSGN_APPR'
1166: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
1167: -- No longer is use
1168:
1169:
1170: l_for_period := get_for_period (p_prop_mgr_per_in_ler_id);

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

1225: l_error:=sqlerrm;
1226:
1227: hr_utility.set_location ('exception is'||l_error , 300);
1228:
1229: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'send_fyi_notifications',l_error);
1230: raise;
1231: end send_fyi_notifications;
1232:
1233:

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

1348: l_error:=sqlerrm;
1349:
1350: hr_utility.set_location ('exception is'||l_error , 300);
1351:
1352: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
1353: raise;
1354:
1355:
1356: end store_emp_details;

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

1383: l_error:=sqlerrm;
1384:
1385: hr_utility.set_location ('exception is'||l_error , 300);
1386:
1387: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'remove_emp_details',l_error);
1388: raise;
1389: end remove_emp_details;
1390:
1391:

Line 1493: END BEN_CWB_RSGN_EMP;

1489: -- No longer is use
1490: hr_utility.set_location('Leaving '||l_package ,30);
1491: END;
1492:
1493: END BEN_CWB_RSGN_EMP;