[Home] [Help]
112: l_text varchar2(2000);
113: l_message varchar2(10);
114: --
115: cursor get_seq is
116: select per_wf_events_s.nextval from dual;
117: --
118: l_proc varchar2(72):=' pay_element_link_be2.update_element_link_a';
119: begin
120: hr_utility.set_location('Entering: '||l_proc,10);
119: begin
120: hr_utility.set_location('Entering: '||l_proc,10);
121: -- check the status of the business event
122: l_event_name:='oracle.apps.pay.api.element_link.update_element_link';
123: l_message:=wf_event.test(l_event_name);
124: --
125: if (l_message='MESSAGE') then
126: hr_utility.set_location(l_proc,20);
127: --
562: if p_effective_start_date is not NULL and
563: p_effective_start_date > trunc(SYSDATE) and
564: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
565: -- raise the event with the event data, with send date set to effective date
566: wf_event.raise(p_event_name=>l_event_name
567: ,p_event_key=>l_event_key
568: ,p_event_data=>l_event_data
569: ,p_send_date => p_effective_start_date);
570: --
569: ,p_send_date => p_effective_start_date);
570: --
571: else
572: -- raise the event with the event data
573: wf_event.raise(p_event_name=>l_event_name
574: ,p_event_key=>l_event_key
575: ,p_event_data=>l_event_data);
576: end if;
577: elsif (l_message='KEY') then
584: p_effective_start_date > trunc(SYSDATE) and
585: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
586: -- this is a key event, so just raise the event
587: -- without the event data, with send date set to effective date
588: wf_event.raise(p_event_name=>l_event_name
589: ,p_event_key=>l_event_key
590: ,p_send_date => p_effective_start_date);
591: --
592: else
591: --
592: else
593: -- this is a key event, so just raise the event
594: -- without the event data
595: wf_event.raise(p_event_name=>l_event_name
596: ,p_event_key=>l_event_key);
597: end if;
598: elsif (l_message='NONE') then
599: hr_utility.set_location(l_proc,40);