DBA Data[Home] [Help]

APPS.IEM_MDTSTARTPROCESS_PUB dependencies on FND_CONCURRENT

Line 142: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

138:
139: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
140: l_Error_Message := FND_MESSAGE.GET;
141: fnd_file.put_line(fnd_file.log, l_Error_Message);
142: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
143: --ROLLBACK TO LaunchProcess_PUB;
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145:
146: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');

Line 149: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

145:
146: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');
147: l_Error_Message := FND_MESSAGE.GET;
148: fnd_file.put_line(fnd_file.log, l_Error_Message);
149: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
150: --ROLLBACK TO LaunchProcess_PUB;
151: WHEN STOP_ALL_WORKERS THEN
152: -- Get a current IEM Concurrent worker id.
153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);

Line 153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);

149: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
150: --ROLLBACK TO LaunchProcess_PUB;
151: WHEN STOP_ALL_WORKERS THEN
152: -- Get a current IEM Concurrent worker id.
153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
154: IF l_call_status = false THEN
155: fnd_file.put_line(fnd_file.log, l_message);
156: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
157:

Line 156: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);

152: -- Get a current IEM Concurrent worker id.
153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
154: IF l_call_status = false THEN
155: fnd_file.put_line(fnd_file.log, l_message);
156: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
157:
158: ELSE -- call staus is true
159: -- Cancel request id
160: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);

Line 160: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);

156: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
157:
158: ELSE -- call staus is true
159: -- Cancel request id
160: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
161:
162: IF l_call_status = false THEN
163: -- Try again
164: l_counter2 :=0;

Line 169: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);

165: LOOP -- Sleep while other worker is terminating
166: l_counter2 := l_counter2 +1;
167: EXIT when l_counter2 = 100000000;
168: END LOOP;
169: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
170: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
171: IF l_call_status = false THEN
172: fnd_file.put_line(fnd_file.log, l_Error_Message);
173: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);

Line 170: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);

166: l_counter2 := l_counter2 +1;
167: EXIT when l_counter2 = 100000000;
168: END LOOP;
169: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
170: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
171: IF l_call_status = false THEN
172: fnd_file.put_line(fnd_file.log, l_Error_Message);
173: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
174: ELSE -- call ststus is true

Line 173: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);

169: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMMDTWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
170: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
171: IF l_call_status = false THEN
172: fnd_file.put_line(fnd_file.log, l_Error_Message);
173: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
174: ELSE -- call ststus is true
175: -- l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
176: IF l_call_status = false THEN
177: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 175: -- l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);

171: IF l_call_status = false THEN
172: fnd_file.put_line(fnd_file.log, l_Error_Message);
173: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
174: ELSE -- call ststus is true
175: -- l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
176: IF l_call_status = false THEN
177: fnd_file.put_line(fnd_file.log, l_Error_Message);
178: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
179: END IF;

Line 178: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);

174: ELSE -- call ststus is true
175: -- l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
176: IF l_call_status = false THEN
177: fnd_file.put_line(fnd_file.log, l_Error_Message);
178: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
179: END IF;
180: END IF;
181:
182: ELSE -- Call status is True

Line 183: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);

179: END IF;
180: END IF;
181:
182: ELSE -- Call status is True
183: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
184: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
185: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
186: fnd_file.put_line(fnd_file.log, l_message);
187: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);

Line 185: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);

181:
182: ELSE -- Call status is True
183: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
184: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
185: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
186: fnd_file.put_line(fnd_file.log, l_message);
187: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
188: END IF;
189: commit;

Line 187: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);

183: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
184: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
185: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
186: fnd_file.put_line(fnd_file.log, l_message);
187: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
188: END IF;
189: commit;
190: END IF;
191: commit;

Line 194: --l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',' '||l_request_id||' '||l_Error_Message||' '||l_counter2);

190: END IF;
191: commit;
192: END IF;
193: return;
194: --l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',' '||l_request_id||' '||l_Error_Message||' '||l_counter2);
195: WHEN OTHERS THEN
196:
197: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_OTHER_ERRORS');
198: l_Error_Message := SQLERRM;

Line 200: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

196:
197: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_OTHER_ERRORS');
198: l_Error_Message := SQLERRM;
199: fnd_file.put_line(fnd_file.log, l_Error_Message);
200: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
201: --ROLLBACK TO LaunchProcess_PUB;
202: END LaunchProcess;
203:
204: PROCEDURE ProcessRetry(ERRBUF OUT NOCOPY VARCHAR2,

Line 242: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

238: ROLLBACK TO LaunchProcess_PUB;
239: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
240: l_Error_Message := FND_MESSAGE.GET;
241: fnd_file.put_line(fnd_file.log, l_Error_Message);
242: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: ROLLBACK TO LaunchProcess_PUB;
245: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_UNXPTD_ERR');
246: l_Error_Message := FND_MESSAGE.GET;

Line 248: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

244: ROLLBACK TO LaunchProcess_PUB;
245: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_UNXPTD_ERR');
246: l_Error_Message := FND_MESSAGE.GET;
247: fnd_file.put_line(fnd_file.log, l_Error_Message);
248: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
249: WHEN OTHERS THEN
250: ROLLBACK TO LaunchProcess_PUB;
251: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_OTHER_ERR');
252: l_Error_Message := SQLERRM;

Line 254: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

250: ROLLBACK TO LaunchProcess_PUB;
251: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_OTHER_ERR');
252: l_Error_Message := SQLERRM;
253: fnd_file.put_line(fnd_file.log, l_Error_Message);
254: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
255:
256: END ProcessRetry;
257: PROCEDURE StopProcessing(ERRBUF OUT NOCOPY VARCHAR2,
258: ERRRET OUT NOCOPY VARCHAR2,

Line 297: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

293: ROLLBACK TO Stopworkflow_PUB;
294: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
295: l_Error_Message := FND_MESSAGE.GET;
296: fnd_file.put_line(fnd_file.log, l_Error_Message);
297: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299: ROLLBACK TO Stopworkflow_PUB;
300: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
301: l_Error_Message := FND_MESSAGE.GET;

Line 303: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

299: ROLLBACK TO Stopworkflow_PUB;
300: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
301: l_Error_Message := FND_MESSAGE.GET;
302: fnd_file.put_line(fnd_file.log, l_Error_Message);
303: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
304: WHEN OTHERS THEN
305: ROLLBACK TO Stopworkflow_PUB;
306: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_OTHER_ERR');
307: l_Error_Message := SQLERRM;

Line 309: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

305: ROLLBACK TO Stopworkflow_PUB;
306: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_OTHER_ERR');
307: l_Error_Message := SQLERRM;
308: fnd_file.put_line(fnd_file.log, l_Error_Message);
309: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
310:
311: END StopProcessing;
312:
313: PROCEDURE PurgeWorkflow(ERRBUF OUT NOCOPY varchar2,

Line 367: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

363: ROLLBACK TO Purgeworkflow_PUB;
364: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_EXEC_ERROR');
365: l_Error_Message := FND_MESSAGE.GET;
366: fnd_file.put_line(fnd_file.log, l_Error_Message);
367: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO Purgeworkflow_PUB;
370: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_UNXPTD_ERR');
371: l_Error_Message := FND_MESSAGE.GET;

Line 373: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

369: ROLLBACK TO Purgeworkflow_PUB;
370: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_UNXPTD_ERR');
371: l_Error_Message := FND_MESSAGE.GET;
372: fnd_file.put_line(fnd_file.log, l_Error_Message);
373: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
374: WHEN OTHERS THEN
375: ROLLBACK TO Purgeworkflow_PUB;
376: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_OTHER_ERR');
377: l_Error_Message := SQLERRM;

Line 379: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);

375: ROLLBACK TO Purgeworkflow_PUB;
376: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_OTHER_ERR');
377: l_Error_Message := SQLERRM;
378: fnd_file.put_line(fnd_file.log, l_Error_Message);
379: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
380: END PurgeWorkflow;
381:
382: END IEM_MDTSTARTPROCESS_PUB ;