37:
38:
39: FOR i in 1..p_number_of_threads loop
40:
41: l_call_status := fnd_request.set_repeat_options('',p_period_to_wake_up,'MINUTES','END',p_schedule_worker_stop_date);
42:
43:
44: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWW', '',p_delay_worker_start_time,FALSE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);
45:
40:
41: l_call_status := fnd_request.set_repeat_options('',p_period_to_wake_up,'MINUTES','END',p_schedule_worker_stop_date);
42:
43:
44: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWW', '',p_delay_worker_start_time,FALSE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);
45:
46: if not l_call_status then
47: rollback;
48: raise REPEAT_OPTIONS_NOT_SET;
67: l_time_to_sch := to_char(p_hour) || ':' || to_char(p_minutes);
68:
69: fnd_file.put_line(fnd_file.log, 'Retry process time ' || l_time_to_sch);
70:
71: l_call_status := fnd_request.set_repeat_options(repeat_time => l_time_to_sch);
72:
73: if not l_call_status then
74: rollback;
75: raise REPEAT_OPTIONS_NOT_SET;
76: end if;
77:
78: fnd_file.put_line(fnd_file.log, 'Retry repeat options set for retry process');
79:
80: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWR', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL');
81:
82: if l_request_id = 0 then
83: rollback;
84: raise RETRY_NOT_SUBMITTED;