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