[Home] [Help]
185: l_text varchar2(2000);
186: l_message varchar2(10);
187: --
188: cursor get_seq is
189: select per_wf_events_s.nextval from dual;
190: --
191: l_proc varchar2(72):=' hr_assignment_be8.create_secondary_apl_asg_a';
192: begin
193: hr_utility.set_location('Entering: '||l_proc,10);
192: begin
193: hr_utility.set_location('Entering: '||l_proc,10);
194: -- check the status of the business event
195: l_event_name:='oracle.apps.per.api.assignment.create_secondary_apl_asg';
196: l_message:=wf_event.test(l_event_name);
197: --
198: if (l_message='MESSAGE') then
199: hr_utility.set_location(l_proc,20);
200: --
927: if p_effective_start_date is not NULL and
928: p_effective_start_date > trunc(SYSDATE) and
929: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
930: -- raise the event with the event data, with send date set to effective date
931: wf_event.raise(p_event_name=>l_event_name
932: ,p_event_key=>l_event_key
933: ,p_event_data=>l_event_data
934: ,p_send_date => p_effective_start_date);
935: --
934: ,p_send_date => p_effective_start_date);
935: --
936: else
937: -- raise the event with the event data
938: wf_event.raise(p_event_name=>l_event_name
939: ,p_event_key=>l_event_key
940: ,p_event_data=>l_event_data);
941: end if;
942: elsif (l_message='KEY') then
949: p_effective_start_date > trunc(SYSDATE) and
950: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
951: -- this is a key event, so just raise the event
952: -- without the event data, with send date set to effective date
953: wf_event.raise(p_event_name=>l_event_name
954: ,p_event_key=>l_event_key
955: ,p_send_date => p_effective_start_date);
956: --
957: else
956: --
957: else
958: -- this is a key event, so just raise the event
959: -- without the event data
960: wf_event.raise(p_event_name=>l_event_name
961: ,p_event_key=>l_event_key);
962: end if;
963: elsif (l_message='NONE') then
964: hr_utility.set_location(l_proc,40);