DBA Data[Home] [Help]

APPS.IEM_CONCURRENT_MDT_PVT dependencies on FND_FILE

Line 30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);

26: UPDATE IEM_COMP_RT_STATS
27: set VALUE='T'
28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));

Line 31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);

27: set VALUE='T'
28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:

Line 32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));

28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');

Line 33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));

29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:

Line 34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));

30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:
38:

Line 36: fnd_file.put_line(fnd_file.log, 'Starting Processing');

32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:
38:
39: FOR i in 1..p_number_of_threads loop
40:

Line 51: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));

47: rollback;
48: raise REPEAT_OPTIONS_NOT_SET;
49: end if;
50:
51: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));
52:
53: if l_request_id = 0 then
54: rollback;
55: raise WORKER_NOT_SUBMITTED;

Line 69: fnd_file.put_line(fnd_file.log, 'Retry process time ' || l_time_to_sch);

65: if (p_schedule_retry = 'Y') then
66:
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

Line 78: fnd_file.put_line(fnd_file.log, 'Retry repeat options set for retry process');

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

Line 89: fnd_file.put_line(fnd_file.log, 'Retry folders scheduled. Request id = ' || to_char(l_request_id));

85: else
86: commit;
87: end if;
88:
89: fnd_file.put_line(fnd_file.log, 'Retry folders scheduled. Request id = ' || to_char(l_request_id));
90:
91: end if;
92:
93: */

Line 95: fnd_file.put_line(fnd_file.log, 'Controller Exited');

91: end if;
92:
93: */
94: Commit work;
95: fnd_file.put_line(fnd_file.log, 'Controller Exited');
96:
97: EXCEPTION
98: WHEN INVALID_HOUR THEN
99: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');

Line 101: fnd_file.put_line(fnd_file.log, l_Error_Message);

97: EXCEPTION
98: WHEN INVALID_HOUR THEN
99: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');
100: l_Error_Message := FND_MESSAGE.GET;
101: fnd_file.put_line(fnd_file.log, l_Error_Message);
102: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
103:
104: WHEN INVALID_MINUTE THEN
105: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');

Line 107: fnd_file.put_line(fnd_file.log, l_Error_Message);

103:
104: WHEN INVALID_MINUTE THEN
105: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');
106: l_Error_Message := FND_MESSAGE.GET;
107: fnd_file.put_line(fnd_file.log, l_Error_Message);
108: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
109:
110: WHEN REPEAT_OPTIONS_NOT_SET THEN
111: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');

Line 113: fnd_file.put_line(fnd_file.log, l_Error_Message);

109:
110: WHEN REPEAT_OPTIONS_NOT_SET THEN
111: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');
112: l_Error_Message := FND_MESSAGE.GET;
113: fnd_file.put_line(fnd_file.log, l_Error_Message);
114: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
115:
116: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
117: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');

Line 119: fnd_file.put_line(fnd_file.log, l_Error_Message);

115:
116: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
117: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');
118: l_Error_Message := FND_MESSAGE.GET;
119: fnd_file.put_line(fnd_file.log, l_Error_Message);
120: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
121:
122: WHEN WORKER_NOT_SUBMITTED THEN
123: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');

Line 125: fnd_file.put_line(fnd_file.log, l_Error_Message);

121:
122: WHEN WORKER_NOT_SUBMITTED THEN
123: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');
124: l_Error_Message := FND_MESSAGE.GET;
125: fnd_file.put_line(fnd_file.log, l_Error_Message);
126: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
127:
128: WHEN RETRY_NOT_SUBMITTED THEN
129: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_RETRY_NOT_SUBMITTED');

Line 131: fnd_file.put_line(fnd_file.log, l_Error_Message);

127:
128: WHEN RETRY_NOT_SUBMITTED THEN
129: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_RETRY_NOT_SUBMITTED');
130: l_Error_Message := FND_MESSAGE.GET;
131: fnd_file.put_line(fnd_file.log, l_Error_Message);
132: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
133:
134: WHEN OTHERS THEN
135: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');

Line 137: fnd_file.put_line(fnd_file.log, l_Error_Message);

133:
134: WHEN OTHERS THEN
135: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');
136: l_Error_Message := FND_MESSAGE.GET;
137: fnd_file.put_line(fnd_file.log, l_Error_Message);
138: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
139: END StartProcess;
140: /*
141:

Line 250: fnd_file.put_line(fnd_file.log, l_Error_Message);

246:
247: WHEN IM_AUTHENTICATION_FAILED THEN
248: FND_MESSAGE.SET_NAME('IEM','IM_AUTHENTICATION_FAILED');
249: l_Error_Message := FND_MESSAGE.GET;
250: fnd_file.put_line(fnd_file.log, l_Error_Message);
251: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
252:
253:
254: WHEN IM_CREATEFOLDER_FAILED THEN

Line 257: fnd_file.put_line(fnd_file.log, l_Error_Message);

253:
254: WHEN IM_CREATEFOLDER_FAILED THEN
255: FND_MESSAGE.SET_NAME('IEM','IM_CREATEFOLDER_FAILED');
256: l_Error_Message := FND_MESSAGE.GET;
257: fnd_file.put_line(fnd_file.log, l_Error_Message);
258: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
259:
260: end SyncFolder;
261: */