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.PQH_AME_UTILS dependencies on HR_UTILITY

Line 7: g_debug constant boolean := hr_utility.debug_enabled;

3: --
4: --
5: --
6: g_package constant varchar2(30) := 'pqh_ame_utils.';
7: g_debug constant boolean := hr_utility.debug_enabled;
8:
9: -- ---------------------------------------------------------------------------
10: -- --------------- -------------------------------------
11: -- ---------------------------------------------------------------------------

Line 22: hr_utility.set_location('Entering:'||l_proc, 5);

18: where transaction_id = p_transaction_id;
19: l_proc varchar2(72);
20: begin
21: l_proc := g_package||'populate_txn_details';
22: hr_utility.set_location('Entering:'||l_proc, 5);
23: if (g_transaction_id = p_transaction_id ) then
24: return;
25: else
26: g_transaction_id := p_transaction_id;

Line 32: hr_utility.set_location(' Leaving:'||l_proc, 10);

28: fetch csr_txn into g_item_type, g_item_key, g_process_name,
29: g_person_id, g_creator_person_id;
30: close csr_txn;
31: end if;
32: hr_utility.set_location(' Leaving:'||l_proc, 10);
33: Exception
34: WHEN others THEN
35: Raise;
36: end populate_txn_details;

Line 46: hr_utility.set_location('Entering:'||l_proc, 5);

42: function get_item_type( p_transaction_id in varchar2) return varchar2 is
43: l_proc varchar2(72);
44: begin
45: l_proc := g_package||'get_item_type';
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: populate_txn_details(p_transaction_id);
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: return g_item_type;
50: Exception

Line 48: hr_utility.set_location(' Leaving:'||l_proc, 10);

44: begin
45: l_proc := g_package||'get_item_type';
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: populate_txn_details(p_transaction_id);
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: return g_item_type;
50: Exception
51: WHEN others THEN
52: wf_core.context(g_package,'.get_final_approver',g_item_type,g_item_key);

Line 63: hr_utility.set_location('Entering:'||l_proc, 5);

59: function get_item_key( p_transaction_id in varchar2) return varchar2 is
60: l_proc varchar2(72);
61: begin
62: l_proc := g_package||'get_item_key';
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: populate_txn_details(p_transaction_id);
65: hr_utility.set_location(' Leaving:'||l_proc, 10);
66: return g_item_key;
67: Exception

Line 65: hr_utility.set_location(' Leaving:'||l_proc, 10);

61: begin
62: l_proc := g_package||'get_item_key';
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: populate_txn_details(p_transaction_id);
65: hr_utility.set_location(' Leaving:'||l_proc, 10);
66: return g_item_key;
67: Exception
68: WHEN others THEN
69: wf_core.context(g_package,'.get_final_approver',g_item_type,g_item_key);

Line 80: hr_utility.set_location('Entering:'||l_proc, 5);

76: function get_process_name( p_transaction_id in varchar2) return varchar2 is
77: l_proc varchar2(72);
78: begin
79: l_proc := g_package||'get_process_name';
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: populate_txn_details(p_transaction_id);
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: return g_process_name;
84:

Line 82: hr_utility.set_location(' Leaving:'||l_proc, 10);

78: begin
79: l_proc := g_package||'get_process_name';
80: hr_utility.set_location('Entering:'||l_proc, 5);
81: populate_txn_details(p_transaction_id);
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: return g_process_name;
84:
85: Exception
86: WHEN others THEN

Line 106: hr_utility.set_location('Entering:'||l_proc, 5);

102: l_response varchar2(10);
103: l_proc varchar2(72);
104: begin
105: l_proc := g_package||'get_final_approver';
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: populate_txn_details(p_transaction_id);
108:
109: l_creator_person_id := g_person_id;
110: l_final_approver_id := g_person_id;

Line 126: hr_utility.set_location(' Leaving:'||l_proc, 10);

122: p_forward_to_person_id => l_final_approver_id,
123: p_person_id => l_creator_person_id );
124:
125: end loop;
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127:
128: return l_final_approver_id;
129:
130: Exception

Line 151: hr_utility.set_location('Entering:'||l_proc, 5);

147: --
148: l_proc varchar2(72);
149: begin
150: l_proc := g_package||'get_requestor_person_id';
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: populate_txn_details(p_transaction_id);
153: open csr_mgr(g_person_id);
154: fetch csr_mgr into l_supervisor_id;
155: close csr_mgr ;

Line 157: hr_utility.set_location(' Leaving:'||l_proc, 10);

153: open csr_mgr(g_person_id);
154: fetch csr_mgr into l_supervisor_id;
155: close csr_mgr ;
156:
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: return g_person_id;
159:
160: Exception
161: WHEN others THEN