DBA Data[Home] [Help]

APPS.IEM_MDTSTARTPROCESS_PUB dependencies on FND_API

Line 53: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 61: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 129: WHEN FND_API.G_EXC_ERROR THEN

125: END IF;
126: END LOOP;
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO LaunchProcess_PUB;
131: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
132: l_Error_Message := FND_MESSAGE.GET;
133: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

131: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_EXEC_ERROR');
132: l_Error_Message := FND_MESSAGE.GET;
133: fnd_file.put_line(fnd_file.log, l_Error_Message);
134: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO LaunchProcess_PUB;
137: FND_MESSAGE.SET_NAME('IEM','IEM_LAUNCHPROCESS_UNXPTD_ERR');
138: l_Error_Message := FND_MESSAGE.GET;
139: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 209: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

205: BEGIN
206: -- Standard Start of API savepoint
207: SAVEPOINT ProcessRetry_PUB;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
210: p_api_version_number,
211: l_api_name,
212: G_PKG_NAME)
213: THEN

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: p_api_version_number,
211: l_api_name,
212: G_PKG_NAME)
213: THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list )
218: THEN

Line 217: IF FND_API.to_Boolean( p_init_msg_list )

213: THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list )
218: THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221: commit;

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219: FND_MSG_PUB.initialize;
220: END IF;
221: commit;
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO LaunchProcess_PUB;
225: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
226: l_Error_Message := FND_MESSAGE.GET;
227: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

225: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_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 LaunchProcess_PUB;
231: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_UNXPTD_ERR');
232: l_Error_Message := FND_MESSAGE.GET;
233: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 260: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

256: BEGIN
257: -- Standard Start of API savepoint
258: SAVEPOINT StopWorkflow_PUB;
259: -- Standard call to check for call compatibility.
260: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
261: p_api_version_number,
262: l_api_name,
263: G_PKG_NAME)
264: THEN

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: p_api_version_number,
262: l_api_name,
263: G_PKG_NAME)
264: THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list )
269: THEN

Line 268: IF FND_API.to_Boolean( p_init_msg_list )

264: THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list )
269: THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272: -- Initialize API return status to SUCCESS

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: set VALUE='F'
275: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
276: COMMIT;
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: ROLLBACK TO Stopworkflow_PUB;
280: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
281: l_Error_Message := FND_MESSAGE.GET;
282: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

280: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_EXEC_ERROR');
281: l_Error_Message := FND_MESSAGE.GET;
282: fnd_file.put_line(fnd_file.log, l_Error_Message);
283: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO Stopworkflow_PUB;
286: FND_MESSAGE.SET_NAME('IEM','IEM_STOPWORKFLOW_UNXPTD_ERR');
287: l_Error_Message := FND_MESSAGE.GET;
288: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 325: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

321: BEGIN
322: -- Standard Start of API savepoint
323: SAVEPOINT PurgeWorkflow_PUB;
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
326: p_api_version_number,
327: l_api_name,
328: G_PKG_NAME)
329: THEN

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: p_api_version_number,
327: l_api_name,
328: G_PKG_NAME)
329: THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN

Line 333: IF FND_API.to_Boolean( p_init_msg_list )

329: THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337: -- Initialize API return status to SUCCESS

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344: END LOOP;
345: l_date:=to_date(p_end_Date,'yyyy/mm/dd hh24:mi:ss');
346: wf_purge.total(p_item_type,null,l_Date);
347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO Purgeworkflow_PUB;
350: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_EXEC_ERROR');
351: l_Error_Message := FND_MESSAGE.GET;
352: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_EXEC_ERROR');
351: l_Error_Message := FND_MESSAGE.GET;
352: fnd_file.put_line(fnd_file.log, l_Error_Message);
353: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO Purgeworkflow_PUB;
356: FND_MESSAGE.SET_NAME('IEM','IEM_PURGEWORKFLOW_UNXPTD_ERR');
357: l_Error_Message := FND_MESSAGE.GET;
358: fnd_file.put_line(fnd_file.log, l_Error_Message);