DBA Data[Home] [Help]

APPS.IEM_CONCURRENT_MDT_PVT dependencies on FND_REQUEST

Line 101: l_call_status := fnd_request.set_repeat_options('',p_period_to_wake_up,'MINUTES','END',p_schedule_worker_stop_date);

97: FOR j in 1..p_number_of_threads loop
98:
99: -- Submit the child request. The sub_request parameter
100: -- must be set to 'Y'.
101: l_call_status := fnd_request.set_repeat_options('',p_period_to_wake_up,'MINUTES','END',p_schedule_worker_stop_date);
102: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWW', 'SUBREQ - Child request #'|| to_char(j),p_delay_worker_start_time,TRUE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);
103:
104:
105: end loop;

Line 102: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWW', 'SUBREQ - Child request #'|| to_char(j),p_delay_worker_start_time,TRUE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);

98:
99: -- Submit the child request. The sub_request parameter
100: -- must be set to 'Y'.
101: l_call_status := fnd_request.set_repeat_options('',p_period_to_wake_up,'MINUTES','END',p_schedule_worker_stop_date);
102: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWW', 'SUBREQ - Child request #'|| to_char(j),p_delay_worker_start_time,TRUE,1,'F','T','MAILPREPROC','IEM_MAIL','NO_WAIT',p_number_of_msgs);
103:
104:
105: end loop;
106: Commit work;

Line 118: l_call_status := fnd_request.set_repeat_options(repeat_time => l_time_to_sch);

114: l_time_to_sch := to_char(p_hour) || ':' || to_char(p_minutes);
115:
116: fnd_file.put_line(fnd_file.log, 'Retry process time ' || l_time_to_sch);
117:
118: l_call_status := fnd_request.set_repeat_options(repeat_time => l_time_to_sch);
119:
120: if not l_call_status then
121: rollback;
122: raise REPEAT_OPTIONS_NOT_SET;

Line 127: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWR', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL');

123: end if;
124:
125: fnd_file.put_line(fnd_file.log, 'Retry repeat options set for retry process');
126:
127: l_request_id := fnd_request.submit_request('IEM', 'IEMMDTWR', '','',FALSE,1,'F','T','MAILPREPROC','IEM_MAIL');
128:
129: if l_request_id = 0 then
130: rollback;
131: raise RETRY_NOT_SUBMITTED;