eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_MC_PUB dependencies on FND_API

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IEM_MC_PUB';
5:
6: PROCEDURE prepareMessageComponent
7: (p_api_version_number IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_action IN VARCHAR2,
11: p_master_account_id IN NUMBER,
12: p_activity_id IN NUMBER,

Line 9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

5:
6: PROCEDURE prepareMessageComponent
7: (p_api_version_number IN NUMBER,
8: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_action IN VARCHAR2,
11: p_master_account_id IN NUMBER,
12: p_activity_id IN NUMBER,
13: p_to_address_list IN VARCHAR2,

Line 59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

55: END prepareMessageComponent;
56:
57: PROCEDURE prepareMessageComponent
58: (p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61: p_action IN VARCHAR2,
62: p_master_account_id IN NUMBER,
63: p_activity_id IN NUMBER,

Line 60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

56:
57: PROCEDURE prepareMessageComponent
58: (p_api_version_number IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61: p_action IN VARCHAR2,
62: p_master_account_id IN NUMBER,
63: p_activity_id IN NUMBER,
64: p_to_address_list IN VARCHAR2,

Line 109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)

105:
106: SAVEPOINT IEM_MC_PARAMETERS;
107:
108:
109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
110: then
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107:
108:
109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
110: then
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:
114: IF fnd_api.to_boolean(p_init_msg_list)
115: then

Line 114: IF fnd_api.to_boolean(p_init_msg_list)

110: then
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:
114: IF fnd_api.to_boolean(p_init_msg_list)
115: then
116: FND_MSG_PUB.initialize;
117: end if;
118:

Line 119: x_return_status := fnd_api.g_ret_sts_success;

115: then
116: FND_MSG_PUB.initialize;
117: end if;
118:
119: x_return_status := fnd_api.g_ret_sts_success;
120: x_mc_parameters_id := 0;
121:
122: l_action := p_action;
123: IF (l_action is null)

Line 215: IF FND_API.To_Boolean(p_commit) THEN

211: END;
212: END IF;
213:
214: -- Standard check of p_commit
215: IF FND_API.To_Boolean(p_commit) THEN
216: COMMIT WORK;
217: END IF;
218:
219: -- Standard call to get message count and if count is 1, get message info.

Line 227: WHEN FND_API.G_EXC_ERROR THEN

223: );
224:
225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO IEM_MC_PARAMETERS;
229:
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get(

Line 230: x_return_status := FND_API.G_RET_STS_ERROR;

226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO IEM_MC_PARAMETERS;
229:
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MSG_PUB.Count_And_Get(
232: p_count => x_msg_count,
233: p_data => x_msg_data
234: );

Line 238: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

234: );
235:
236:
237: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
238: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
239: x_msg_data := x_msg_data || ',' || l_msg_data;
240: END LOOP;
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
239: x_msg_data := x_msg_data || ',' || l_msg_data;
240: END LOOP;
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO IEM_MC_PARAMETERS;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get
246: (

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: END LOOP;
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO IEM_MC_PARAMETERS;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get
246: (
247: p_count => x_msg_count,
248: p_data => x_msg_data

Line 252: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

248: p_data => x_msg_data
249: );
250:
251: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
252: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
253: x_msg_data := x_msg_data || ',' || l_msg_data;
254: END LOOP;
255:
256: WHEN OTHERS THEN

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

254: END LOOP;
255:
256: WHEN OTHERS THEN
257: ROLLBACK TO IEM_MC_PARAMETERS;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259:
260: FND_MSG_PUB.Count_And_Get (
261: p_count => x_msg_count,
262: p_data => x_msg_data

Line 266: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

262: p_data => x_msg_data
263: );
264:
265: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
266: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
267: x_msg_data := x_msg_data || ',' || l_msg_data;
268: END LOOP;
269:
270: END prepareMessageComponent;

Line 319: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)

315: -- Standard Start of API savepoint
316: SAVEPOINT prepareMessageComponentII_pvt;
317:
318: -- Standard call to check for call compatibility.
319: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
320: then
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317:
318: -- Standard call to check for call compatibility.
319: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
320: then
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: -- Initialize message list if p_init_msg_list is set to TRUE.
325: IF fnd_api.to_boolean(p_init_msg_list)

Line 325: IF fnd_api.to_boolean(p_init_msg_list)

321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: -- Initialize message list if p_init_msg_list is set to TRUE.
325: IF fnd_api.to_boolean(p_init_msg_list)
326: then
327: FND_MSG_PUB.initialize;
328: end if;
329:

Line 331: x_return_status := fnd_api.g_ret_sts_success;

327: FND_MSG_PUB.initialize;
328: end if;
329:
330: -- Initialize API return status to SUCCESS
331: x_return_status := fnd_api.g_ret_sts_success;
332:
333: -----------------------Code------------------------
334: l_action := p_action;
335: IF (l_action is null or l_action = fnd_api.g_miss_char)

Line 335: IF (l_action is null or l_action = fnd_api.g_miss_char)

331: x_return_status := fnd_api.g_ret_sts_success;
332:
333: -----------------------Code------------------------
334: l_action := p_action;
335: IF (l_action is null or l_action = fnd_api.g_miss_char)
336: THEN
337: l_action := 'reply';
338: END IF;
339:

Line 375: decode(p_activity_id, fnd_api.g_miss_num, null, p_activity_id),

371: (
372: x_mc_parameters_id,
373: l_action,
374: p_master_account_id,
375: decode(p_activity_id, fnd_api.g_miss_num, null, p_activity_id),
376: p_to_address_list,
377: p_cc_address_list,
378: p_bcc_address_list,
379: p_subject,

Line 383: decode (p_mes_document_id, FND_API.G_MISS_NUM, NULL, p_mes_document_id),

379: p_subject,
380: p_sr_id,
381: p_customer_id,
382: p_contact_id,
383: decode (p_mes_document_id, FND_API.G_MISS_NUM, NULL, p_mes_document_id),
384: decode (p_mes_category_id, FND_API.G_MISS_NUM, NULL, p_mes_category_id),
385: p_interaction_id,
386: 'N',
387: l_created_by,

Line 384: decode (p_mes_category_id, FND_API.G_MISS_NUM, NULL, p_mes_category_id),

380: p_sr_id,
381: p_customer_id,
382: p_contact_id,
383: decode (p_mes_document_id, FND_API.G_MISS_NUM, NULL, p_mes_document_id),
384: decode (p_mes_category_id, FND_API.G_MISS_NUM, NULL, p_mes_category_id),
385: p_interaction_id,
386: 'N',
387: l_created_by,
388: SYSDATE,

Line 392: decode(p_encoding, fnd_api.g_miss_char, null, p_encoding),

388: SYSDATE,
389: l_last_updated_by,
390: SYSDATE,
391: l_last_update_login,
392: decode(p_encoding, fnd_api.g_miss_char, null, p_encoding),
393: decode(p_character_set, fnd_api.g_miss_char, null, p_character_set),
394: p_message_type, p_relationship_id );
395:
396: IF (p_qualifiers.count > 0)

Line 393: decode(p_character_set, fnd_api.g_miss_char, null, p_character_set),

389: l_last_updated_by,
390: SYSDATE,
391: l_last_update_login,
392: decode(p_encoding, fnd_api.g_miss_char, null, p_encoding),
393: decode(p_character_set, fnd_api.g_miss_char, null, p_character_set),
394: p_message_type, p_relationship_id );
395:
396: IF (p_qualifiers.count > 0)
397: THEN

Line 419: IF FND_API.To_Boolean(p_commit) THEN

415: END IF;
416:
417: --------- end of codes -------------------
418: -- Standard check of p_commit
419: IF FND_API.To_Boolean(p_commit) THEN
420: COMMIT WORK;
421: END IF;
422:
423: EXCEPTION

Line 424: WHEN FND_API.G_EXC_ERROR THEN

420: COMMIT WORK;
421: END IF;
422:
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: ROLLBACK TO prepareMessageComponentII_pvt;
426:
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MSG_PUB.Count_And_Get(

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: ROLLBACK TO prepareMessageComponentII_pvt;
426:
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MSG_PUB.Count_And_Get(
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );

Line 433: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
433: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
434: x_msg_data := x_msg_data || ',' || l_msg_data;
435: END LOOP;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
434: x_msg_data := x_msg_data || ',' || l_msg_data;
435: END LOOP;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: ROLLBACK TO IEM_MC_PARAMETERS;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.Count_And_Get
441: (

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: END LOOP;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: ROLLBACK TO IEM_MC_PARAMETERS;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count,
443: p_data => x_msg_data

Line 446: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

442: p_count => x_msg_count,
443: p_data => x_msg_data
444: );
445: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
446: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
447: x_msg_data := x_msg_data || ',' || l_msg_data;
448: END LOOP;
449:
450: WHEN OTHERS THEN

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

448: END LOOP;
449:
450: WHEN OTHERS THEN
451: ROLLBACK TO prepareMessageComponentII_pvt;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453:
454: FND_MSG_PUB.Count_And_Get (
455: p_count => x_msg_count,
456: p_data => x_msg_data

Line 459: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
459: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
460: x_msg_data := x_msg_data || ',' || l_msg_data;
461: END LOOP;
462:
463: END prepareMessageComponentII;