DBA Data[Home] [Help]

APPS.IEM_NEXT_GEN_PROCESS_EMAIL_PVT dependencies on FND_CONCURRENT

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

122: ROLLBACK TO LaunchProcess_PVT;
123: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO LaunchProcess_PVT;
130: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');

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

129: ROLLBACK TO LaunchProcess_PVT;
130: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');
131: l_Error_Message := FND_MESSAGE.GET;
132: fnd_file.put_line(fnd_file.log, l_Error_Message);
133: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
134:
135: WHEN STOP_ALL_WORKERS THEN
136: -- Get a current IEM Concurrent worker id.
137: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);

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

133: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
134:
135: WHEN STOP_ALL_WORKERS THEN
136: -- Get a current IEM Concurrent worker id.
137: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
138: IF l_call_status = false THEN
139: fnd_file.put_line(fnd_file.log, l_message);
140: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
141:

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

136: -- Get a current IEM Concurrent worker id.
137: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
138: IF l_call_status = false THEN
139: fnd_file.put_line(fnd_file.log, l_message);
140: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
141:
142: ELSE -- call staus is true
143: -- Cancel request id
144: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);

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

140: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
141:
142: ELSE -- call staus is true
143: -- Cancel request id
144: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
145:
146: IF l_call_status = false THEN
147: -- Try again
148: l_counter2 :=0;

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

149: LOOP -- Sleep while other worker is terminating
150: l_counter2 := l_counter2 +1;
151: EXIT when l_counter2 = 100000000;
152: END LOOP;
153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
154: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
155: IF l_call_status = false THEN
156: fnd_file.put_line(fnd_file.log, l_Error_Message);
157: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);

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

150: l_counter2 := l_counter2 +1;
151: EXIT when l_counter2 = 100000000;
152: END LOOP;
153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
154: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
155: IF l_call_status = false THEN
156: fnd_file.put_line(fnd_file.log, l_Error_Message);
157: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
158: ELSE -- call ststus is true

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

153: l_call_status :=FND_CONCURRENT.GET_REQUEST_STATUS(l_request_id, 'IEM', 'IEMNGNWW', l_rphase,l_rstatus,l_dphase,l_dstatus,l_message);
154: l_call_status :=FND_CONCURRENT.CANCEL_REQUEST(l_request_id,l_Error_Message);
155: IF l_call_status = false THEN
156: fnd_file.put_line(fnd_file.log, l_Error_Message);
157: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
158: ELSE -- call ststus is true
159: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
160: IF l_call_status = false THEN
161: fnd_file.put_line(fnd_file.log, l_Error_Message);

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

155: IF l_call_status = false THEN
156: fnd_file.put_line(fnd_file.log, l_Error_Message);
157: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_Error_Message);
158: ELSE -- call ststus is true
159: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
160: IF l_call_status = false THEN
161: fnd_file.put_line(fnd_file.log, l_Error_Message);
162: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
163: END IF;

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

158: ELSE -- call ststus is true
159: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
160: IF l_call_status = false THEN
161: fnd_file.put_line(fnd_file.log, l_Error_Message);
162: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',l_message);
163: END IF;
164: END IF;
165:
166: ELSE -- Call status is True

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

163: END IF;
164: END IF;
165:
166: ELSE -- Call status is True
167: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
168: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
169: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
170: fnd_file.put_line(fnd_file.log, l_message);
171: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);

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

165:
166: ELSE -- Call status is True
167: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
168: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
169: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
170: fnd_file.put_line(fnd_file.log, l_message);
171: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
172: END IF;
173: END IF;

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

167: l_call_status :=FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id, 60, 600, l_rphase, l_rstatus, l_dphase, l_dstatus, l_message);
168: IF l_call_status = false OR l_dstatus='TERMINATING' THEN
169: l_call_status :=FND_CONCURRENT.CHECK_LOCK_CONTENTION('', l_request_id, l_UProcess_ID, l_UTerminal, l_UNode, l_UName, l_UProgram);
170: fnd_file.put_line(fnd_file.log, l_message);
171: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
172: END IF;
173: END IF;
174: END IF;
175: --l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',' '||l_request_id||' '||l_Error_Message||' '||l_counter2);

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

171: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', ' '||l_UProcess_ID||' '||l_UName||' '||l_UProgram);
172: END IF;
173: END IF;
174: END IF;
175: --l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',' '||l_request_id||' '||l_Error_Message||' '||l_counter2);
176:
177: WHEN OTHERS THEN
178: ROLLBACK TO LaunchProcess_PVT;
179: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_OTHER_ERRORS');

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

178: ROLLBACK TO LaunchProcess_PVT;
179: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_OTHER_ERRORS');
180: l_Error_Message := SQLERRM;
181: fnd_file.put_line(fnd_file.log, l_Error_Message);
182: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
183: END LaunchProcess;
184:
185: PROCEDURE StopProcessing(ERRBUF OUT NOCOPY VARCHAR2,
186: ERRRET OUT NOCOPY VARCHAR2,

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

224: ROLLBACK TO Stopworkflow_PVT;
225: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
226: l_Error_Message := FND_MESSAGE.GET;
227: fnd_file.put_line(fnd_file.log, l_Error_Message);
228: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
230: ROLLBACK TO Stopworkflow_PVT;
231: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
232: l_Error_Message := FND_MESSAGE.GET;

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

230: ROLLBACK TO Stopworkflow_PVT;
231: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
232: l_Error_Message := FND_MESSAGE.GET;
233: fnd_file.put_line(fnd_file.log, l_Error_Message);
234: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
235:
236: WHEN OTHERS THEN
237: ROLLBACK TO Stopworkflow_PVT;
238: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_OTHER_ERR');

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

237: ROLLBACK TO Stopworkflow_PVT;
238: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_OTHER_ERR');
239: l_Error_Message := SQLERRM;
240: fnd_file.put_line(fnd_file.log, l_Error_Message);
241: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
242:
243: END StopProcessing;
244:
245: PROCEDURE PurgeWorkflow(ERRBUF OUT NOCOPY varchar2,

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

293: ROLLBACK TO Purgeworkflow_PVT;
294: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_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 Purgeworkflow_PVT;
300: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_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 Purgeworkflow_PVT;
300: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_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 Purgeworkflow_PVT;
306: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_OTHER_ERR');
307: l_Error_Message := SQLERRM;

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

305: ROLLBACK TO Purgeworkflow_PVT;
306: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_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: END PurgeWorkflow;
311:
312: END IEM_NEXT_GEN_PROCESS_EMAIL_PVT;