DBA Data[Home] [Help]

APPS.PAY_BALANCE_FEEDS_BE2 dependencies on HR_UTILITY

Line 24: hr_utility.set_location('Entering: '||l_proc,10);

20: select per_wf_events_s.nextval from dual;
21: --
22: l_proc varchar2(72):=' pay_balance_feeds_be2.update_balance_feed_a';
23: begin
24: hr_utility.set_location('Entering: '||l_proc,10);
25: -- check the status of the business event
26: l_event_name:='oracle.apps.pay.api.balance_feeds.update_balance_feed';
27: l_message:=wf_event.test(l_event_name);
28: --

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

26: l_event_name:='oracle.apps.pay.api.balance_feeds.update_balance_feed';
27: l_message:=wf_event.test(l_event_name);
28: --
29: if (l_message='MESSAGE') then
30: hr_utility.set_location(l_proc,20);
31: --
32: -- get a key for the event
33: --
34: open get_seq;

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

98: ,p_event_key=>l_event_key
99: ,p_event_data=>l_event_data);
100: end if;
101: elsif (l_message='KEY') then
102: hr_utility.set_location(l_proc,30);
103: -- get a key for the event
104: open get_seq;
105: fetch get_seq into l_event_key;
106: close get_seq;

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

119: wf_event.raise(p_event_name=>l_event_name
120: ,p_event_key=>l_event_key);
121: end if;
122: elsif (l_message='NONE') then
123: hr_utility.set_location(l_proc,40);
124: -- no event is required, so do nothing
125: null;
126: end if;
127: hr_utility.set_location('Leaving: '||l_proc,50);

Line 127: hr_utility.set_location('Leaving: '||l_proc,50);

123: hr_utility.set_location(l_proc,40);
124: -- no event is required, so do nothing
125: null;
126: end if;
127: hr_utility.set_location('Leaving: '||l_proc,50);
128: end update_balance_feed_a;
129: end pay_balance_feeds_be2;