[Home] [Help]
119: l_text varchar2(2000);
120: l_message varchar2(10);
121: --
122: cursor get_seq is
123: select per_wf_events_s.nextval from dual;
124: --
125: l_proc varchar2(72):=' pay_element_link_be1.create_element_link_a';
126: begin
127: hr_utility.set_location('Entering: '||l_proc,10);
126: begin
127: hr_utility.set_location('Entering: '||l_proc,10);
128: -- check the status of the business event
129: l_event_name:='oracle.apps.pay.api.element_link.create_element_link';
130: l_message:=wf_event.test(l_event_name);
131: --
132: if (l_message='MESSAGE') then
133: hr_utility.set_location(l_proc,20);
134: --
597: if p_effective_start_date is not NULL and
598: p_effective_start_date > trunc(SYSDATE) and
599: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
600: -- raise the event with the event data, with send date set to effective date
601: wf_event.raise(p_event_name=>l_event_name
602: ,p_event_key=>l_event_key
603: ,p_event_data=>l_event_data
604: ,p_send_date => p_effective_start_date);
605: --
604: ,p_send_date => p_effective_start_date);
605: --
606: else
607: -- raise the event with the event data
608: wf_event.raise(p_event_name=>l_event_name
609: ,p_event_key=>l_event_key
610: ,p_event_data=>l_event_data);
611: end if;
612: elsif (l_message='KEY') then
619: p_effective_start_date > trunc(SYSDATE) and
620: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
621: -- this is a key event, so just raise the event
622: -- without the event data, with send date set to effective date
623: wf_event.raise(p_event_name=>l_event_name
624: ,p_event_key=>l_event_key
625: ,p_send_date => p_effective_start_date);
626: --
627: else
626: --
627: else
628: -- this is a key event, so just raise the event
629: -- without the event data
630: wf_event.raise(p_event_name=>l_event_name
631: ,p_event_key=>l_event_key);
632: end if;
633: elsif (l_message='NONE') then
634: hr_utility.set_location(l_proc,40);