[Home] [Help]
182: l_text varchar2(2000);
183: l_message varchar2(10);
184: --
185: cursor get_seq is
186: select per_wf_events_s.nextval from dual;
187: --
188: l_proc varchar2(72):=' hr_assignment_be1.create_secondary_emp_asg_a';
189: begin
190: hr_utility.set_location('Entering: '||l_proc,10);
189: begin
190: hr_utility.set_location('Entering: '||l_proc,10);
191: -- check the status of the business event
192: l_event_name:='oracle.apps.per.api.assignment.create_secondary_emp_asg';
193: l_message:=wf_event.test(l_event_name);
194: --
195: if (l_message='MESSAGE') then
196: hr_utility.set_location(l_proc,20);
197: --
920: if p_effective_start_date is not NULL and
921: p_effective_start_date > trunc(SYSDATE) and
922: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
923: -- raise the event with the event data, with send date set to effective date
924: wf_event.raise(p_event_name=>l_event_name
925: ,p_event_key=>l_event_key
926: ,p_event_data=>l_event_data
927: ,p_send_date => p_effective_start_date);
928: --
927: ,p_send_date => p_effective_start_date);
928: --
929: else
930: -- raise the event with the event data
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: end if;
935: elsif (l_message='KEY') then
942: p_effective_start_date > trunc(SYSDATE) and
943: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
944: -- this is a key event, so just raise the event
945: -- without the event data, with send date set to effective date
946: wf_event.raise(p_event_name=>l_event_name
947: ,p_event_key=>l_event_key
948: ,p_send_date => p_effective_start_date);
949: --
950: else
949: --
950: else
951: -- this is a key event, so just raise the event
952: -- without the event data
953: wf_event.raise(p_event_name=>l_event_name
954: ,p_event_key=>l_event_key);
955: end if;
956: elsif (l_message='NONE') then
957: hr_utility.set_location(l_proc,40);