DBA Data[Home] [Help]

APPS.PQH_AME_APPROVALS dependencies on HR_UTILITY

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

18: l_proc constant varchar2(72):= g_package||'set_route_to_user';
19: --
20: BEGIN
21:
22: hr_utility.set_location('Entering:'||l_proc, 5);
23: wf_directory.GetUserName
24: (p_orig_system => 'PER'
25: ,p_orig_system_id => p_forward_to_person_id
26: ,p_name => l_forward_to_username

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

41: ,aname => 'ROUTE_TO_USER'
42: ,avalue => l_forward_to_username);
43: end if;
44: --
45: hr_utility.set_location(' Leaving:'||l_proc, 10);
46: Exception
47: When Others Then
48: Raise;
49: END set_route_to_user;

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

60:
61: l_proc constant varchar2(72):= g_package||'get_txn_type_info';
62: begin
63:
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: p_txn_type := wf_engine.GetItemAttrText
66: (itemtype => p_item_type,
67: itemkey => p_item_key,
68: aname => 'PARAMETER2_VALUE' );

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

70: p_txn_app_id := wf_engine.GetItemAttrText
71: (itemtype => p_item_type,
72: itemkey => p_item_key,
73: aname => 'PARAMETER3_VALUE' );
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: Exception
76: When Others Then
77: Raise;
78: end;

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

98: --
99: l_proc constant varchar2(72):= g_package||'check_final_approver';
100: BEGIN
101:
102: hr_utility.set_location('Entering:'||l_proc, 5);
103:
104: if ( p_funmode = 'RUN' ) then
105: l_transaction_id := pqh_ss_workflow.get_transaction_id(p_itemType, p_itemKey);
106:

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

139: p_result := 'COMPLETE:F';
140: end if;
141: --
142: end if;
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144:
145: Exception
146: When Others Then
147: -- Set error attribute and complete activity with result error

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

165: l_proc constant varchar2(72):= g_package||'approve_reject_elctbl_chc';
166: l_ovn number(15);
167: BEGIN
168:
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: -- Get The electable choice id from WF attribute
171: l_elctbl_chc_id := wf_engine.GetItemAttrText
172: (itemtype => p_itemtype,
173: itemkey => p_itemkey,

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

185: ,p_approval_status_cd => p_app_rej
186: ,p_object_version_number => l_ovn
187: ,p_effective_date => sysdate);
188:
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: Exception
191: When Others Then
192: Raise;
193: END approve_reject_elctbl_chc ;

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

206:
207: l_proc constant varchar2(72):= g_package||'mark_elctbl_chc_approved';
208: BEGIN
209:
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: if ( p_funmode = 'RUN' ) then
212: approve_reject_elctbl_chc (
213: p_itemType => p_itemType
214: ,p_itemKey => p_itemKey

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

218: end if;
219:
220: p_result := 'COMPLETE:T';
221:
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: Exception
224: When Others Then
225: wf_core.context(g_package,'mark_elctbl_chc_approved',p_itemType,p_itemKey);
226: Raise;

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

240:
241: l_proc constant varchar2(72):= g_package||'mark_elctbl_chc_rejected';
242: BEGIN
243:
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: if ( p_funmode = 'RUN' ) then
246: approve_reject_elctbl_chc (
247: p_itemType => p_itemType
248: ,p_itemKey => p_itemKey

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

249: ,p_app_rej => 'PQH_GSP_R');
250: end if;
251:
252: p_result := 'COMPLETE:T';
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: Exception
255: When Others Then
256: wf_core.context(g_package,'mark_elctbl_chc_rejected',p_itemType,p_itemKey);
257: Raise;

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

266: l_proc constant varchar2(72):= g_package||'unmark_wf_flag_for_elctbl_chc';
267: l_ovn number;
268: l_elctbl_chc_id number;
269: BEGIN
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: if ( p_funmode = 'RUN' ) then
273: l_elctbl_chc_id := wf_engine.GetItemAttrText (
274: itemtype => p_itemtype,

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

285: ,p_object_version_number => l_ovn
286: ,p_effective_date => sysdate);
287: end if;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: Exception
291: When Others Then
292: wf_core.context(g_package,'unmark_wf_flag_for_elctbl_chc',p_itemType,p_itemKey);
293: Raise;

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

311: --
312: l_proc constant varchar2(72):= g_package||'initialize_ame';
313: l_result varchar2(30);
314: BEGIN
315: hr_utility.set_location('Entering:'||l_proc, 5);
316:
317: if ( p_funmode = 'RUN' ) then
318: p_result := 'COMPLETE:T';
319: end if;

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

316:
317: if ( p_funmode = 'RUN' ) then
318: p_result := 'COMPLETE:T';
319: end if;
320: hr_utility.set_location(' Leaving:'||l_proc, 10);
321: Exception
322: When Others Then
323: -- Set error attribute and complete activity with result error
324: wf_engine.SetItemAttrText (

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

355:
356: l_proc constant varchar2(72):= g_package||'find_next_approver';
357: BEGIN
358:
359: hr_utility.set_location('Entering:'||l_proc, 5);
360:
361: l_txn_id := pqh_ss_workflow.get_transaction_id(p_itemType, p_itemKey);
362:
363: if ( p_funmode = 'RUN' ) then

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

395: --
396: --
397: end if;
398:
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: Exception
401: When Others Then
402: wf_engine.SetItemAttrText (
403: itemtype => p_itemType