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_SEEDED_APPROVAL_WF dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxcseedaw.pkb 120.2 2005/09/23 06:27:25 nissharm noship $ */
3:
4: g_pkg constant varchar2(30) := 'hxc_seeded_approval_wf';
5:
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: procedure do_approval_logic(
9: p_itemtype in varchar2,
10: p_itemkey in varchar2,

Line 17: g_debug := hr_utility.debug_enabled;

13: p_result in out nocopy varchar2)
14: is
15: l_proc varchar2(61);
16: begin
17: g_debug := hr_utility.debug_enabled;
18:
19: if g_debug then
20: l_proc := g_pkg || '.' || 'do_approval_logic';
21: hr_utility.set_location(l_proc, 10);

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

17: g_debug := hr_utility.debug_enabled;
18:
19: if g_debug then
20: l_proc := g_pkg || '.' || 'do_approval_logic';
21: hr_utility.set_location(l_proc, 10);
22: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
23: hr_utility.trace('p_itemtype is >' || p_itemtype || '<');
24: hr_utility.trace('p_itemkey is >' || p_itemkey || '<');
25: end if;

Line 22: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');

18:
19: if g_debug then
20: l_proc := g_pkg || '.' || 'do_approval_logic';
21: hr_utility.set_location(l_proc, 10);
22: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
23: hr_utility.trace('p_itemtype is >' || p_itemtype || '<');
24: hr_utility.trace('p_itemkey is >' || p_itemkey || '<');
25: end if;
26: --

Line 23: hr_utility.trace('p_itemtype is >' || p_itemtype || '<');

19: if g_debug then
20: l_proc := g_pkg || '.' || 'do_approval_logic';
21: hr_utility.set_location(l_proc, 10);
22: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
23: hr_utility.trace('p_itemtype is >' || p_itemtype || '<');
24: hr_utility.trace('p_itemkey is >' || p_itemkey || '<');
25: end if;
26: --
27: -- p_result := 'APPROVED';

Line 24: hr_utility.trace('p_itemkey is >' || p_itemkey || '<');

20: l_proc := g_pkg || '.' || 'do_approval_logic';
21: hr_utility.set_location(l_proc, 10);
22: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
23: hr_utility.trace('p_itemtype is >' || p_itemtype || '<');
24: hr_utility.trace('p_itemkey is >' || p_itemkey || '<');
25: end if;
26: --
27: -- p_result := 'APPROVED';
28: --

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

28: --
29: p_result := 'REJECTED';
30: --
31: if g_debug then
32: hr_utility.set_location(l_proc, 90);
33: end if;
34: exception
35: when others then
36: if g_debug then

Line 37: hr_utility.trace('sqlcode>' || sqlcode || '<');

33: end if;
34: exception
35: when others then
36: if g_debug then
37: hr_utility.trace('sqlcode>' || sqlcode || '<');
38: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
39: end if;
40: --
41: -- record this function call in the error system in case of an exception

Line 38: hr_utility.trace('sqlerrm>' || sqlerrm || '<');

34: exception
35: when others then
36: if g_debug then
37: hr_utility.trace('sqlcode>' || sqlcode || '<');
38: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
39: end if;
40: --
41: -- record this function call in the error system in case of an exception
42: --

Line 60: g_debug := hr_utility.debug_enabled;

56: l_proc varchar2(61);
57: l_item_type hxc_approval_comps.wf_item_type%type;
58: l_item_key number;
59: begin
60: g_debug := hr_utility.debug_enabled;
61:
62: if g_debug then
63: l_proc := g_pkg || '.' || 'approved';
64: hr_utility.set_location(l_proc, 10);

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

60: g_debug := hr_utility.debug_enabled;
61:
62: if g_debug then
63: l_proc := g_pkg || '.' || 'approved';
64: hr_utility.set_location(l_proc, 10);
65: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
66: end if;
67:
68: l_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,

Line 65: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');

61:
62: if g_debug then
63: l_proc := g_pkg || '.' || 'approved';
64: hr_utility.set_location(l_proc, 10);
65: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
66: end if;
67:
68: l_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
69: itemkey => p_itemkey,

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

85:
86: p_result := 'COMPLETE';
87:
88: if g_debug then
89: hr_utility.set_location(l_proc, 90);
90: end if;
91: exception
92: when others then
93: if g_debug then

Line 94: hr_utility.trace('sqlcode>' || sqlcode || '<');

90: end if;
91: exception
92: when others then
93: if g_debug then
94: hr_utility.trace('sqlcode>' || sqlcode || '<');
95: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
96: end if;
97: --
98: -- record this function call in the error system in case of an exception

Line 95: hr_utility.trace('sqlerrm>' || sqlerrm || '<');

91: exception
92: when others then
93: if g_debug then
94: hr_utility.trace('sqlcode>' || sqlcode || '<');
95: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
96: end if;
97: --
98: -- record this function call in the error system in case of an exception
99: --

Line 116: g_debug := hr_utility.debug_enabled;

112: l_proc varchar2(61);
113: l_item_type hxc_approval_comps.wf_item_type%type;
114: l_item_key number;
115: begin
116: g_debug := hr_utility.debug_enabled;
117:
118: if g_debug then
119: l_proc := g_pkg || '.' || 'rejected';
120: hr_utility.set_location(l_proc, 10);

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

116: g_debug := hr_utility.debug_enabled;
117:
118: if g_debug then
119: l_proc := g_pkg || '.' || 'rejected';
120: hr_utility.set_location(l_proc, 10);
121: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
122: end if;
123:
124: l_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,

Line 121: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');

117:
118: if g_debug then
119: l_proc := g_pkg || '.' || 'rejected';
120: hr_utility.set_location(l_proc, 10);
121: hr_utility.trace('p_funcmode is >' || p_funcmode || '<');
122: end if;
123:
124: l_item_type := wf_engine.GetItemAttrText(itemtype => p_itemtype,
125: itemkey => p_itemkey,

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

141:
142: p_result := 'COMPLETE';
143: --
144: if g_debug then
145: hr_utility.set_location(l_proc, 90);
146: end if;
147: exception
148: when others then
149: if g_debug then

Line 150: hr_utility.trace('sqlcode>' || sqlcode || '<');

146: end if;
147: exception
148: when others then
149: if g_debug then
150: hr_utility.trace('sqlcode>' || sqlcode || '<');
151: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
152: end if;
153: --
154: -- record this function call in the error system in case of an exception

Line 151: hr_utility.trace('sqlerrm>' || sqlerrm || '<');

147: exception
148: when others then
149: if g_debug then
150: hr_utility.trace('sqlcode>' || sqlcode || '<');
151: hr_utility.trace('sqlerrm>' || sqlerrm || '<');
152: end if;
153: --
154: -- record this function call in the error system in case of an exception
155: --