DBA Data[Home] [Help]

APPS.IEM_MDTSTARTPROCESS_PUB dependencies on FND_API

Line 54: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

50: BEGIN
51: -- Standard Start of API savepoint
52: --SAVEPOINT LaunchProcess_PUB;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
58: THEN

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN

Line 62: IF FND_API.to_Boolean( p_init_msg_list )

58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66: -- dbms_lock.sleep(2*60);

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133: END IF;
134: END LOOP;
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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');
147: l_Error_Message := FND_MESSAGE.GET;
148: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 223: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

219: BEGIN
220: -- Standard Start of API savepoint
221: SAVEPOINT ProcessRetry_PUB;
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
224: p_api_version_number,
225: l_api_name,
226: G_PKG_NAME)
227: THEN

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: p_api_version_number,
225: l_api_name,
226: G_PKG_NAME)
227: THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230: -- Initialize message list if p_init_msg_list is set to TRUE.
231: IF FND_API.to_Boolean( p_init_msg_list )
232: THEN

Line 231: IF FND_API.to_Boolean( p_init_msg_list )

227: THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230: -- Initialize message list if p_init_msg_list is set to TRUE.
231: IF FND_API.to_Boolean( p_init_msg_list )
232: THEN
233: FND_MSG_PUB.initialize;
234: END IF;
235: commit;

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233: FND_MSG_PUB.initialize;
234: END IF;
235: commit;
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
247: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 274: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

270: BEGIN
271: -- Standard Start of API savepoint
272: SAVEPOINT StopWorkflow_PUB;
273: -- Standard call to check for call compatibility.
274: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
275: p_api_version_number,
276: l_api_name,
277: G_PKG_NAME)
278: THEN

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275: p_api_version_number,
276: l_api_name,
277: G_PKG_NAME)
278: THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: END IF;
281: -- Initialize message list if p_init_msg_list is set to TRUE.
282: IF FND_API.to_Boolean( p_init_msg_list )
283: THEN

Line 282: IF FND_API.to_Boolean( p_init_msg_list )

278: THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: END IF;
281: -- Initialize message list if p_init_msg_list is set to TRUE.
282: IF FND_API.to_Boolean( p_init_msg_list )
283: THEN
284: FND_MSG_PUB.initialize;
285: END IF;
286: -- Initialize API return status to SUCCESS

Line 292: WHEN FND_API.G_EXC_ERROR THEN

288: set VALUE='F'
289: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
290: COMMIT;
291: EXCEPTION
292: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
302: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 339: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

335: BEGIN
336: -- Standard Start of API savepoint
337: SAVEPOINT PurgeWorkflow_PUB;
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)
343: THEN

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)
343: THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )
348: THEN

Line 347: IF FND_API.to_Boolean( p_init_msg_list )

343: THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )
348: THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351: -- Initialize API return status to SUCCESS

Line 362: WHEN FND_API.G_EXC_ERROR THEN

358: END LOOP;
359: l_date:=to_date(p_end_Date,'yyyy/mm/dd hh24:mi:ss');
360: wf_purge.total(p_item_type,null,l_Date);
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
372: fnd_file.put_line(fnd_file.log, l_Error_Message);