[Home] [Help]
106: l_text varchar2(2000);
107: l_message varchar2(10);
108: --
109: cursor get_seq is
110: select per_wf_events_s.nextval from dual;
111: --
112: l_proc varchar2(72):=' hr_personal_pay_method_be1.create_personal_pay_method_a';
113: begin
114: hr_utility.set_location('Entering: '||l_proc,10);
113: begin
114: hr_utility.set_location('Entering: '||l_proc,10);
115: -- check the status of the business event
116: l_event_name:='oracle.apps.per.api.personal_pay_method.create_personal_pay_method';
117: l_message:=wf_event.test(l_event_name);
118: --
119: if (l_message='MESSAGE') then
120: hr_utility.set_location(l_proc,20);
121: --
532: if p_effective_start_date is not NULL and
533: p_effective_start_date > trunc(SYSDATE) and
534: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
535: -- raise the event with the event data, with send date set to effective date
536: wf_event.raise(p_event_name=>l_event_name
537: ,p_event_key=>l_event_key
538: ,p_event_data=>l_event_data
539: ,p_send_date => p_effective_start_date);
540: --
539: ,p_send_date => p_effective_start_date);
540: --
541: else
542: -- raise the event with the event data
543: wf_event.raise(p_event_name=>l_event_name
544: ,p_event_key=>l_event_key
545: ,p_event_data=>l_event_data);
546: end if;
547: elsif (l_message='KEY') then
554: p_effective_start_date > trunc(SYSDATE) and
555: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
556: -- this is a key event, so just raise the event
557: -- without the event data, with send date set to effective date
558: wf_event.raise(p_event_name=>l_event_name
559: ,p_event_key=>l_event_key
560: ,p_send_date => p_effective_start_date);
561: --
562: else
561: --
562: else
563: -- this is a key event, so just raise the event
564: -- without the event data
565: wf_event.raise(p_event_name=>l_event_name
566: ,p_event_key=>l_event_key);
567: end if;
568: elsif (l_message='NONE') then
569: hr_utility.set_location(l_proc,40);