DBA Data[Home] [Help]

APPS.IEM_CONFIGURATION_PUB dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5:
6: PROCEDURE GetConfiguration(ERRBUF VARCHAR2,
7: ERRRET VARCHAR2,
8: p_api_version_number IN NUMBER := 1,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_TRUE
11: ) IS
12: l_api_name VARCHAR2(255):='GetConfiguration';
13: l_api_version_number NUMBER:=1.0;

Line 10: p_commit IN VARCHAR2 := FND_API.G_TRUE

6: PROCEDURE GetConfiguration(ERRBUF VARCHAR2,
7: ERRRET VARCHAR2,
8: p_api_version_number IN NUMBER := 1,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_TRUE
11: ) IS
12: l_api_name VARCHAR2(255):='GetConfiguration';
13: l_api_version_number NUMBER:=1.0;
14: l_call_status BOOLEAN;

Line 47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

43: BEGIN
44: -- Standard Start of API savepoint
45: SAVEPOINT GetConfiguration_PUB;
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)
51: THEN

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)
51: THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list )
56: THEN

Line 55: IF FND_API.to_Boolean( p_init_msg_list )

51: THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list )
56: THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59: -- Initialize API return status to SUCCESS

Line 272: p_init_msg_list => FND_API.G_FALSE,

268: l_Error_Message := '*** eMail Center Profile Values *** ';
269: fnd_file.put_line(fnd_file.log, l_Error_Message);
270:
271: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
272: p_init_msg_list => FND_API.G_FALSE,
273: p_commit => FND_API.G_FALSE,
274: p_profile_name => 'IEM_ACCOUNT_SENDER_NAME',
275: x_profile_value => l_profile_value,
276: x_return_status => l_return_status,

Line 273: p_commit => FND_API.G_FALSE,

269: fnd_file.put_line(fnd_file.log, l_Error_Message);
270:
271: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
272: p_init_msg_list => FND_API.G_FALSE,
273: p_commit => FND_API.G_FALSE,
274: p_profile_name => 'IEM_ACCOUNT_SENDER_NAME',
275: x_profile_value => l_profile_value,
276: x_return_status => l_return_status,
277: x_msg_count => l_msg_count,

Line 284: p_init_msg_list => FND_API.G_FALSE,

280: l_Error_Message := 'IEM_ACCOUNT_SENDER_NAME : ' || l_profile_value;
281: fnd_file.put_line(fnd_file.log, l_Error_Message);
282:
283: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
284: p_init_msg_list => FND_API.G_FALSE,
285: p_commit => FND_API.G_FALSE,
286: p_profile_name => 'IEM_CACHE_UPDATE_FREQ',
287: x_profile_value => l_profile_value,
288: x_return_status => l_return_status,

Line 285: p_commit => FND_API.G_FALSE,

281: fnd_file.put_line(fnd_file.log, l_Error_Message);
282:
283: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
284: p_init_msg_list => FND_API.G_FALSE,
285: p_commit => FND_API.G_FALSE,
286: p_profile_name => 'IEM_CACHE_UPDATE_FREQ',
287: x_profile_value => l_profile_value,
288: x_return_status => l_return_status,
289: x_msg_count => l_msg_count,

Line 296: p_init_msg_list => FND_API.G_FALSE,

292: l_Error_Message := 'IEM_CACHE_UPDATE_FREQ : ' || l_profile_value;
293: fnd_file.put_line(fnd_file.log, l_Error_Message);
294:
295: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
296: p_init_msg_list => FND_API.G_FALSE,
297: p_commit => FND_API.G_FALSE,
298: p_profile_name => 'IEM_DEFAULT_CUSTOMER_ID',
299: x_profile_value => l_profile_value,
300: x_return_status => l_return_status,

Line 297: p_commit => FND_API.G_FALSE,

293: fnd_file.put_line(fnd_file.log, l_Error_Message);
294:
295: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
296: p_init_msg_list => FND_API.G_FALSE,
297: p_commit => FND_API.G_FALSE,
298: p_profile_name => 'IEM_DEFAULT_CUSTOMER_ID',
299: x_profile_value => l_profile_value,
300: x_return_status => l_return_status,
301: x_msg_count => l_msg_count,

Line 308: p_init_msg_list => FND_API.G_FALSE,

304: l_Error_Message := 'IEM_DEFAULT_CUSTOMER_ID : ' || l_profile_value;
305: fnd_file.put_line(fnd_file.log, l_Error_Message);
306:
307: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
308: p_init_msg_list => FND_API.G_FALSE,
309: p_commit => FND_API.G_FALSE,
310: p_profile_name => 'IEM_DEFAULT_CUSTOMER_NUMBER',
311: x_profile_value => l_profile_value,
312: x_return_status => l_return_status,

Line 309: p_commit => FND_API.G_FALSE,

305: fnd_file.put_line(fnd_file.log, l_Error_Message);
306:
307: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
308: p_init_msg_list => FND_API.G_FALSE,
309: p_commit => FND_API.G_FALSE,
310: p_profile_name => 'IEM_DEFAULT_CUSTOMER_NUMBER',
311: x_profile_value => l_profile_value,
312: x_return_status => l_return_status,
313: x_msg_count => l_msg_count,

Line 320: p_init_msg_list => FND_API.G_FALSE,

316: l_Error_Message := 'IEM_DEFAULT_CUSTOMER_NUMBER : ' || l_profile_value;
317: fnd_file.put_line(fnd_file.log, l_Error_Message);
318:
319: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
320: p_init_msg_list => FND_API.G_FALSE,
321: p_commit => FND_API.G_FALSE,
322: p_profile_name => 'IEM_DEFAULT_RESOURCE_NUMBER',
323: x_profile_value => l_profile_value,
324: x_return_status => l_return_status,

Line 321: p_commit => FND_API.G_FALSE,

317: fnd_file.put_line(fnd_file.log, l_Error_Message);
318:
319: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
320: p_init_msg_list => FND_API.G_FALSE,
321: p_commit => FND_API.G_FALSE,
322: p_profile_name => 'IEM_DEFAULT_RESOURCE_NUMBER',
323: x_profile_value => l_profile_value,
324: x_return_status => l_return_status,
325: x_msg_count => l_msg_count,

Line 332: p_init_msg_list => FND_API.G_FALSE,

328: l_Error_Message := 'IEM_DEFAULT_RESOURCE_NUMBER : ' || l_profile_value;
329: fnd_file.put_line(fnd_file.log, l_Error_Message);
330:
331: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
332: p_init_msg_list => FND_API.G_FALSE,
333: p_commit => FND_API.G_FALSE,
334: p_profile_name => 'IEM_INTENT_RESPONSE_NUM',
335: x_profile_value => l_profile_value,
336: x_return_status => l_return_status,

Line 333: p_commit => FND_API.G_FALSE,

329: fnd_file.put_line(fnd_file.log, l_Error_Message);
330:
331: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
332: p_init_msg_list => FND_API.G_FALSE,
333: p_commit => FND_API.G_FALSE,
334: p_profile_name => 'IEM_INTENT_RESPONSE_NUM',
335: x_profile_value => l_profile_value,
336: x_return_status => l_return_status,
337: x_msg_count => l_msg_count,

Line 344: p_init_msg_list => FND_API.G_FALSE,

340: l_Error_Message := 'IEM_INTENT_RESPONSE_NUM : ' || l_profile_value;
341: fnd_file.put_line(fnd_file.log, l_Error_Message);
342:
343: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
344: p_init_msg_list => FND_API.G_FALSE,
345: p_commit => FND_API.G_FALSE,
346: p_profile_name => 'IEM_KNOWLEDGE_BASE',
347: x_profile_value => l_profile_value,
348: x_return_status => l_return_status,

Line 345: p_commit => FND_API.G_FALSE,

341: fnd_file.put_line(fnd_file.log, l_Error_Message);
342:
343: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
344: p_init_msg_list => FND_API.G_FALSE,
345: p_commit => FND_API.G_FALSE,
346: p_profile_name => 'IEM_KNOWLEDGE_BASE',
347: x_profile_value => l_profile_value,
348: x_return_status => l_return_status,
349: x_msg_count => l_msg_count,

Line 356: p_init_msg_list => FND_API.G_FALSE,

352: l_Error_Message := 'IEM_KNOWLEDGE_BASE : ' || l_profile_value;
353: fnd_file.put_line(fnd_file.log, l_Error_Message);
354:
355: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
356: p_init_msg_list => FND_API.G_FALSE,
357: p_commit => FND_API.G_FALSE,
358: p_profile_name => 'IEM_SRVRPROC_APENABLE',
359: x_profile_value => l_profile_value,
360: x_return_status => l_return_status,

Line 357: p_commit => FND_API.G_FALSE,

353: fnd_file.put_line(fnd_file.log, l_Error_Message);
354:
355: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
356: p_init_msg_list => FND_API.G_FALSE,
357: p_commit => FND_API.G_FALSE,
358: p_profile_name => 'IEM_SRVRPROC_APENABLE',
359: x_profile_value => l_profile_value,
360: x_return_status => l_return_status,
361: x_msg_count => l_msg_count,

Line 368: p_init_msg_list => FND_API.G_FALSE,

364: l_Error_Message := 'IEM_SRVRPROC_APENABLE : ' || l_profile_value;
365: fnd_file.put_line(fnd_file.log, l_Error_Message);
366:
367: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_profile_name => 'IEM_SRVR_ARES',
371: x_profile_value => l_profile_value,
372: x_return_status => l_return_status,

Line 369: p_commit => FND_API.G_FALSE,

365: fnd_file.put_line(fnd_file.log, l_Error_Message);
366:
367: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_profile_name => 'IEM_SRVR_ARES',
371: x_profile_value => l_profile_value,
372: x_return_status => l_return_status,
373: x_msg_count => l_msg_count,

Line 380: p_init_msg_list => FND_API.G_FALSE,

376: l_Error_Message := 'IEM_SRVR_ARES : ' || l_profile_value;
377: fnd_file.put_line(fnd_file.log, l_Error_Message);
378:
379: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => FND_API.G_FALSE,
382: p_profile_name => 'IEM_SRVR_AROUTE',
383: x_profile_value => l_profile_value,
384: x_return_status => l_return_status,

Line 381: p_commit => FND_API.G_FALSE,

377: fnd_file.put_line(fnd_file.log, l_Error_Message);
378:
379: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_commit => FND_API.G_FALSE,
382: p_profile_name => 'IEM_SRVR_AROUTE',
383: x_profile_value => l_profile_value,
384: x_return_status => l_return_status,
385: x_msg_count => l_msg_count,

Line 393: p_init_msg_list => FND_API.G_FALSE,

389: fnd_file.put_line(fnd_file.log, l_Error_Message);
390:
391:
392: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_commit => FND_API.G_FALSE,
395: p_profile_name => 'IEM_SRVR_ASRUPD',
396: x_profile_value => l_profile_value,
397: x_return_status => l_return_status,

Line 394: p_commit => FND_API.G_FALSE,

390:
391:
392: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
393: p_init_msg_list => FND_API.G_FALSE,
394: p_commit => FND_API.G_FALSE,
395: p_profile_name => 'IEM_SRVR_ASRUPD',
396: x_profile_value => l_profile_value,
397: x_return_status => l_return_status,
398: x_msg_count => l_msg_count,

Line 405: p_init_msg_list => FND_API.G_FALSE,

401: l_Error_Message := 'IEM_SRVR_ASRUPD : ' || l_profile_value;
402: fnd_file.put_line(fnd_file.log, l_Error_Message);
403:
404: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_commit => FND_API.G_FALSE,
407: p_profile_name => 'IEM_SRVR_SRST',
408: x_profile_value => l_profile_value,
409: x_return_status => l_return_status,

Line 406: p_commit => FND_API.G_FALSE,

402: fnd_file.put_line(fnd_file.log, l_Error_Message);
403:
404: iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_commit => FND_API.G_FALSE,
407: p_profile_name => 'IEM_SRVR_SRST',
408: x_profile_value => l_profile_value,
409: x_return_status => l_return_status,
410: x_msg_count => l_msg_count,

Line 418: WHEN FND_API.G_EXC_ERROR THEN

414: fnd_file.put_line(fnd_file.log, l_Error_Message);
415:
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: ROLLBACK TO GetConfiguration_PUB;
420: FND_MESSAGE.SET_NAME('IEM','IEM_COLLECTCONFIG_EXEC_ERROR');
421: l_Error_Message := FND_MESSAGE.GET;
422: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

420: FND_MESSAGE.SET_NAME('IEM','IEM_COLLECTCONFIG_EXEC_ERROR');
421: l_Error_Message := FND_MESSAGE.GET;
422: fnd_file.put_line(fnd_file.log, l_Error_Message);
423: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO GetConfiguration_PUB;
426: FND_MESSAGE.SET_NAME('IEM','IEM_COLLECTCONFIG_UNXPTD_ERR');
427: l_Error_Message := FND_MESSAGE.GET;
428: fnd_file.put_line(fnd_file.log, l_Error_Message);