eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HR_UTILITY

Line 4: g_debug BOOLEAN :=hr_utility.debug_enabled;

1: Package Body HXC_NOTIFICATION_PROCESS_PKG as
2: /* $Header: hxcnotifprocess.pkb 120.14.12020000.2 2012/07/04 09:28:12 amnaraya ship $ */
3: g_pkg constant varchar2(30) := 'hxc_notification_process_pkg.';
4: g_debug BOOLEAN :=hr_utility.debug_enabled;
5:
6:
7: function IS_TCOWNER_SAMEAS_APPROVER(
8: p_notficationId in varchar2)

Line 27: g_debug:=hr_utility.debug_enabled;

23: where wf.notification_id = l_notification_id
24: and fuser.user_name = wf.RECIPIENT_ROLE;
25:
26: begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: hr_utility.trace('HXC_NOTIFICATION_PROCESS_PKG.IS_TCOWNER_SAMEAS_APPROVER');
30: hr_utility.trace('Opening cursor to get tc approver, item type and key');
31: end if;

Line 29: hr_utility.trace('HXC_NOTIFICATION_PROCESS_PKG.IS_TCOWNER_SAMEAS_APPROVER');

25:
26: begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: hr_utility.trace('HXC_NOTIFICATION_PROCESS_PKG.IS_TCOWNER_SAMEAS_APPROVER');
30: hr_utility.trace('Opening cursor to get tc approver, item type and key');
31: end if;
32:
33: open cur_get_tcapprover_and_ItemKey(p_notficationId);

Line 30: hr_utility.trace('Opening cursor to get tc approver, item type and key');

26: begin
27: g_debug:=hr_utility.debug_enabled;
28: if g_debug then
29: hr_utility.trace('HXC_NOTIFICATION_PROCESS_PKG.IS_TCOWNER_SAMEAS_APPROVER');
30: hr_utility.trace('Opening cursor to get tc approver, item type and key');
31: end if;
32:
33: open cur_get_tcapprover_and_ItemKey(p_notficationId);
34: fetch cur_get_tcapprover_and_ItemKey into l_app_resource_id,l_item_type,l_item_key;

Line 45: hr_utility.trace('Approver '|| l_app_resource_id || 'and Timecard Owner ' || l_tc_owner_resource_id ||'are not same');

41: aname => 'RESOURCE_ID');
42:
43: if l_app_resource_id <> l_tc_owner_resource_id then
44: if g_debug then
45: hr_utility.trace('Approver '|| l_app_resource_id || 'and Timecard Owner ' || l_tc_owner_resource_id ||'are not same');
46: end if;
47: return 'N';
48: end if;
49: if g_debug then

Line 50: hr_utility.trace('Approver '|| l_app_resource_id || 'and Timecard Owner ' || l_tc_owner_resource_id ||'are same');

46: end if;
47: return 'N';
48: end if;
49: if g_debug then
50: hr_utility.trace('Approver '|| l_app_resource_id || 'and Timecard Owner ' || l_tc_owner_resource_id ||'are same');
51: end if;
52: return 'Y';
53:
54: end IS_TCOWNER_SAMEAS_APPROVER;

Line 85: g_debug:=hr_utility.debug_enabled;

81: l_preparer_timeout number;
82: l_proc constant varchar2(61) := g_pkg ||'approved_by';
83:
84: BEGIN
85: g_debug:=hr_utility.debug_enabled;
86: if g_debug then
87: hr_utility.set_location(l_proc, 10);
88: end if;
89:

Line 87: hr_utility.set_location(l_proc, 10);

83:
84: BEGIN
85: g_debug:=hr_utility.debug_enabled;
86: if g_debug then
87: hr_utility.set_location(l_proc, 10);
88: end if;
89:
90: l_app_bb_id:= wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
91: itemkey => p_itemkey,

Line 129: hr_utility.set_location(l_proc, 20);

125:
126: if l_app_mechanism = 'HR_SUPERVISOR' then
127:
128: if g_debug then
129: hr_utility.set_location(l_proc, 20);
130: end if;
131: hxc_approval_wf_helper.set_notif_attribute_values
132: (p_itemtype,
133: p_itemkey,

Line 147: hr_utility.set_location(l_proc, 30);

143: end if;
144:
145: else
146: if g_debug then
147: hr_utility.set_location(l_proc, 30);
148: end if;
149: p_result := 'COMPLETE:PERSON';
150: end if;
151:

Line 160: hr_utility.set_location(l_proc, 999);

156: -- The line below records this function call in the error system
157: -- in the case of an exception.
158: --
159: if g_debug then
160: hr_utility.set_location(l_proc, 999);
161: end if;
162:
163: wf_core.context('HXCNOTIFPROCESS', 'hxc_notification_process_pkg.approved_by',
164: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line 268: g_debug:=hr_utility.debug_enabled;

264: l_preparer_role wf_local_roles.name%type;
265: l_proc constant varchar2(61) := g_pkg ||'timeouts_enabled';
266:
267: BEGIN
268: g_debug:=hr_utility.debug_enabled;
269:
270: if g_debug then
271: hr_utility.set_location(l_proc, 10);
272: end if;

Line 271: hr_utility.set_location(l_proc, 10);

267: BEGIN
268: g_debug:=hr_utility.debug_enabled;
269:
270: if g_debug then
271: hr_utility.set_location(l_proc, 10);
272: end if;
273:
274:
275: --find application period id item attribute value

Line 324: hr_utility.set_location(l_proc, 20);

320:
321: if l_resend_number > 0 then
322: -- set Approval timeout
323: if g_debug then
324: hr_utility.set_location(l_proc, 20);
325: end if;
326:
327: --Bug 5359397.
328: --TC_FROM_ROLE needs ro reset to preparer role since we are overwriting this attribute with approver role

Line 358: hr_utility.set_location(l_proc, 30);

354:
355: p_result := 'COMPLETE:Y';
356: else
357: if g_debug then
358: hr_utility.set_location(l_proc, 30);
359: end if;
360: p_result := 'COMPLETE:N';
361: end if;
362: exception

Line 369: hr_utility.set_location(l_proc, 999);

365: -- The line below records this function call in the error system
366: -- in the case of an exception.
367: --
368: if g_debug then
369: hr_utility.set_location(l_proc, 999);
370: end if;
371:
372: wf_core.context('HXCNOTIFPROCESS', 'hxc_notification_process_pkg.timeouts_enabled',
373: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);

Line 411: g_debug:=hr_utility.debug_enabled;

407: l_resend_counter number;
408: l_proc constant varchar2(61) := g_pkg ||'reset_for_next_timeout';
409: BEGIN
410:
411: g_debug:=hr_utility.debug_enabled;
412:
413: if g_debug then
414: hr_utility.set_location(l_proc, 10);
415: end if;

Line 414: hr_utility.set_location(l_proc, 10);

410:
411: g_debug:=hr_utility.debug_enabled;
412:
413: if g_debug then
414: hr_utility.set_location(l_proc, 10);
415: end if;
416:
417: l_timecard_id := wf_engine.GetItemAttrNumber
418: (itemtype => p_itemtype,

Line 471: hr_utility.set_location(l_proc, 20);

467:
468: if l_current_recipient = hxc_app_comp_notifications_api.c_recipient_approver then
469:
470: if g_debug then
471: hr_utility.set_location(l_proc, 20);
472: end if;
473:
474: --set the attibutes for the PREPARER
475:

Line 530: hr_utility.set_location(l_proc, 30);

526: elsif l_current_recipient = hxc_app_comp_notifications_api.c_recipient_preparer then
527: --set the attibutes for the ADMIN
528:
529: if g_debug then
530: hr_utility.set_location(l_proc, 30);
531: end if;
532:
533: l_admin_timeout := hxc_notification_helper.admin_timeout_value(l_approval_style_id);
534: l_resend_counter := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,

Line 595: hr_utility.set_location(l_proc, 40);

591:
592: --In this case all the attributes were already set in the l_current_recipient = 'PREPARER' section.
593:
594: if g_debug then
595: hr_utility.set_location(l_proc, 40);
596: end if;
597:
598: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
599: itemkey => p_itemkey,

Line 614: hr_utility.set_location(l_proc, 999);

610: -- The line below records this function call in the error system
611: -- in the case of an exception.
612: --
613: if g_debug then
614: hr_utility.set_location(l_proc, 999);
615: end if;
616: wf_core.context('HXCNOTIFPROCESS', 'hxc_notification_process_pkg.reset_for_next_timeout',
617: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
618: raise;

Line 707: g_debug:=hr_utility.debug_enabled;

703: l_proc constant varchar2(61) := g_pkg ||'restart_workflow';
704:
705: begin
706:
707: g_debug:=hr_utility.debug_enabled;
708:
709: l_process_name := 'HXC_APPLY_NOTIFY';
710:
711:

Line 713: hr_utility.set_location(l_proc, 10);

709: l_process_name := 'HXC_APPLY_NOTIFY';
710:
711:
712: if g_debug then
713: hr_utility.set_location(l_proc, 10);
714: end if;
715:
716: --This restart_workflow is called from two places
717: --1.) When Adminstrator chooses to restart the workflow.

Line 788: hr_utility.trace('l_item_key is : ' || l_item_key);

784: where application_period_id = l_app_bb_id
785: and application_period_ovn = l_app_bb_ovn;
786:
787: if g_debug then
788: hr_utility.trace('l_item_key is : ' || l_item_key);
789: end if;
790:
791: wf_engine.CreateProcess(itemtype => p_itemtype,
792: itemkey => l_item_key,

Line 811: hr_utility.set_location(l_proc, 20);

807: l_category_sequence;
808:
809: close c_csr_get_appl_periods;
810: if g_debug then
811: hr_utility.set_location(l_proc, 20);
812: end if;
813:
814: wf_engine.SetItemAttrDate(itemtype => p_itemtype,
815: itemkey => l_item_key,

Line 824: hr_utility.set_location(l_proc, 30);

820: itemkey => l_item_key,
821: aname => 'FORMATTED_APP_START_DATE',
822: avalue => to_char(l_period_start_date,'YYYY/MM/DD'));
823: if g_debug then
824: hr_utility.set_location(l_proc, 30);
825: hr_utility.trace('APP_START_DATE is : ' ||
826: to_char(l_period_start_date, 'DD-MM-YYYY'));
827: end if;
828:

Line 825: hr_utility.trace('APP_START_DATE is : ' ||

821: aname => 'FORMATTED_APP_START_DATE',
822: avalue => to_char(l_period_start_date,'YYYY/MM/DD'));
823: if g_debug then
824: hr_utility.set_location(l_proc, 30);
825: hr_utility.trace('APP_START_DATE is : ' ||
826: to_char(l_period_start_date, 'DD-MM-YYYY'));
827: end if;
828:
829: wf_engine.SetItemAttrDate(itemtype => p_itemtype,

Line 835: hr_utility.set_location(l_proc, 40);

831: aname => 'APP_END_DATE',
832: avalue => l_period_end_date);
833:
834: if g_debug then
835: hr_utility.set_location(l_proc, 40);
836: hr_utility.trace('APP_END_DATE is : ' ||
837: to_char(l_period_end_date, 'DD-MM-YYYY'));
838: end if;
839:

Line 836: hr_utility.trace('APP_END_DATE is : ' ||

832: avalue => l_period_end_date);
833:
834: if g_debug then
835: hr_utility.set_location(l_proc, 40);
836: hr_utility.trace('APP_END_DATE is : ' ||
837: to_char(l_period_end_date, 'DD-MM-YYYY'));
838: end if;
839:
840: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 846: hr_utility.set_location(l_proc, 50);

842: aname => 'APP_BB_ID',
843: avalue => l_app_bb_id);
844:
845: if g_debug then
846: hr_utility.set_location(l_proc, 50);
847: hr_utility.trace('APP_BB_ID is : ' || to_char(l_app_bb_id));
848: end if;
849:
850: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 847: hr_utility.trace('APP_BB_ID is : ' || to_char(l_app_bb_id));

843: avalue => l_app_bb_id);
844:
845: if g_debug then
846: hr_utility.set_location(l_proc, 50);
847: hr_utility.trace('APP_BB_ID is : ' || to_char(l_app_bb_id));
848: end if;
849:
850: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
851: itemkey => l_item_key,

Line 857: hr_utility.set_location(l_proc, 60);

853: avalue => l_app_bb_ovn);
854:
855:
856: if g_debug then
857: hr_utility.set_location(l_proc, 60);
858: hr_utility.trace('APP_BB_OVN is : ' ||
859: to_char(l_app_bb_ovn));
860: end if;
861:

Line 858: hr_utility.trace('APP_BB_OVN is : ' ||

854:
855:
856: if g_debug then
857: hr_utility.set_location(l_proc, 60);
858: hr_utility.trace('APP_BB_OVN is : ' ||
859: to_char(l_app_bb_ovn));
860: end if;
861:
862: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 868: hr_utility.set_location(l_proc, 70);

864: aname => 'RESOURCE_ID',
865: avalue => l_tc_resource_id);
866:
867: if g_debug then
868: hr_utility.set_location(l_proc, 70);
869: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));
870: end if;
871:
872: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 869: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));

865: avalue => l_tc_resource_id);
866:
867: if g_debug then
868: hr_utility.set_location(l_proc, 70);
869: hr_utility.trace('RESOURCE_ID is : ' || to_char(l_tc_resource_id));
870: end if;
871:
872: wf_engine.SetItemAttrText(itemtype => p_itemtype,
873: itemkey => l_item_key,

Line 878: hr_utility.set_location(l_proc, 80);

874: aname => 'TIME_RECIPIENT_ID',
875: avalue => l_time_recipient);
876:
877: if g_debug then
878: hr_utility.set_location(l_proc, 80);
879: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);
880: end if;
881:
882: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 879: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);

875: avalue => l_time_recipient);
876:
877: if g_debug then
878: hr_utility.set_location(l_proc, 80);
879: hr_utility.trace('TIME_RECIPIENT_ID is : ' || l_time_recipient);
880: end if;
881:
882: wf_engine.SetItemAttrText(itemtype => p_itemtype,
883: itemkey => l_item_key,

Line 888: hr_utility.set_location(l_proc, 90);

884: aname => 'TC_RESUBMITTED',
885: avalue => l_tc_resubmitted);
886:
887: if g_debug then
888: hr_utility.set_location(l_proc, 90);
889: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);
890: end if;
891:
892: wf_engine.SetItemAttrText(itemtype => p_itemtype,

Line 889: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);

885: avalue => l_tc_resubmitted);
886:
887: if g_debug then
888: hr_utility.set_location(l_proc, 90);
889: hr_utility.trace('TC_RESUBMITTED is : ' || l_tc_resubmitted);
890: end if;
891:
892: wf_engine.SetItemAttrText(itemtype => p_itemtype,
893: itemkey => l_item_key,

Line 898: hr_utility.set_location(l_proc, 100);

894: aname => 'BB_NEW',
895: avalue => l_bb_new);
896:
897: if g_debug then
898: hr_utility.set_location(l_proc, 100);
899: hr_utility.trace('BB_NEW is : ' || l_bb_new);
900: end if;
901:
902: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 899: hr_utility.trace('BB_NEW is : ' || l_bb_new);

895: avalue => l_bb_new);
896:
897: if g_debug then
898: hr_utility.set_location(l_proc, 100);
899: hr_utility.trace('BB_NEW is : ' || l_bb_new);
900: end if;
901:
902: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
903: itemkey => l_item_key,

Line 908: hr_utility.set_location(l_proc, 110);

904: aname => 'TC_BLD_BLK_ID',
905: avalue => l_timecard_id);
906:
907: if g_debug then
908: hr_utility.set_location(l_proc, 110);
909: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_timecard_id));
910: end if;
911:
912: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,

Line 909: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_timecard_id));

905: avalue => l_timecard_id);
906:
907: if g_debug then
908: hr_utility.set_location(l_proc, 110);
909: hr_utility.trace('TC_BLD_BLK_ID is : ' || to_char(l_timecard_id));
910: end if;
911:
912: wf_engine.SetItemAttrNumber(itemtype => p_itemtype,
913: itemkey => l_item_key,

Line 918: hr_utility.set_location(l_proc, 120);

914: aname => 'TC_BLD_BLK_OVN',
915: avalue => l_timecard_ovn);
916:
917: if g_debug then
918: hr_utility.set_location(l_proc, 120);
919: hr_utility.trace('TC_BLD_BLK_OVN is : ' || to_char(l_timecard_ovn));
920: end if;
921: l_approval_style_id := hxc_approval_wf_pkg.get_approval_style_id(l_tc_start_time,
922: l_tc_stop_time,

Line 919: hr_utility.trace('TC_BLD_BLK_OVN is : ' || to_char(l_timecard_ovn));

915: avalue => l_timecard_ovn);
916:
917: if g_debug then
918: hr_utility.set_location(l_proc, 120);
919: hr_utility.trace('TC_BLD_BLK_OVN is : ' || to_char(l_timecard_ovn));
920: end if;
921: l_approval_style_id := hxc_approval_wf_pkg.get_approval_style_id(l_tc_start_time,
922: l_tc_stop_time,
923: l_tc_resource_id);

Line 1111: hr_utility.set_location(l_proc, 999);

1107: -- The line below records this function call in the error system
1108: -- in the case of an exception.
1109: --
1110: if g_debug then
1111: hr_utility.set_location(l_proc, 999);
1112: end if;
1113:
1114: wf_core.context('HXCNOTIFPROCESS', 'hxc_notification_process_pkg.exclude_total_hours',
1115: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);