[Home] [Help]
140: l_text varchar2(2000);
141: l_message varchar2(10);
142: --
143: cursor get_seq is
144: select per_wf_events_s.nextval from dual;
145: --
146: l_proc varchar2(72):=' hr_assignment_be2.update_emp_asg_a';
147: begin
148: hr_utility.set_location('Entering: '||l_proc,10);
147: begin
148: hr_utility.set_location('Entering: '||l_proc,10);
149: -- check the status of the business event
150: l_event_name:='oracle.apps.per.api.assignment.update_emp_asg';
151: l_message:=wf_event.test(l_event_name);
152: --
153: if (l_message='MESSAGE') then
154: hr_utility.set_location(l_proc,20);
155: --
714: if p_effective_start_date is not NULL and
715: p_effective_start_date > trunc(SYSDATE) and
716: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
717: -- raise the event with the event data, with send date set to effective date
718: wf_event.raise(p_event_name=>l_event_name
719: ,p_event_key=>l_event_key
720: ,p_event_data=>l_event_data
721: ,p_send_date => p_effective_start_date);
722: --
721: ,p_send_date => p_effective_start_date);
722: --
723: else
724: -- raise the event with the event data
725: wf_event.raise(p_event_name=>l_event_name
726: ,p_event_key=>l_event_key
727: ,p_event_data=>l_event_data);
728: end if;
729: elsif (l_message='KEY') then
736: p_effective_start_date > trunc(SYSDATE) and
737: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
738: -- this is a key event, so just raise the event
739: -- without the event data, with send date set to effective date
740: wf_event.raise(p_event_name=>l_event_name
741: ,p_event_key=>l_event_key
742: ,p_send_date => p_effective_start_date);
743: --
744: else
743: --
744: else
745: -- this is a key event, so just raise the event
746: -- without the event data
747: wf_event.raise(p_event_name=>l_event_name
748: ,p_event_key=>l_event_key);
749: end if;
750: elsif (l_message='NONE') then
751: hr_utility.set_location(l_proc,40);