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_OUTBOX_PROC_PUB dependencies on FND_API

Line 91: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

87: -- Standard Start of API savepoint
88: SAVEPOINT createOutboxMessage_pvt;
89:
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
92: 1.0,
93: l_api_name,
94: G_PKG_NAME)
95: THEN

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: 1.0,
93: l_api_name,
94: G_PKG_NAME)
95: THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list )

Line 100: IF FND_API.to_Boolean( p_init_msg_list )

96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list )
101: THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104:

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: FND_MSG_PUB.initialize;
103: END IF;
104:
105: -- Initialize API return status to SUCCESS
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: -----------------------Code------------------------
109: -- insanity check
110: IF (p_to_address_list is null and p_cc_address_list is null) THEN

Line 127: p_init_msg_list =>fnd_api.g_false,

123: END IF;
124:
125: IEM_MC_PUB.prepareMessageComponentII
126: (p_api_version_number => 1.0,
127: p_init_msg_list =>fnd_api.g_false,
128: p_commit =>fnd_api.g_false,
129: p_action => 'automsg',
130: p_master_account_id => p_master_account_id,
131: p_activity_id =>fnd_api.g_miss_num,

Line 128: p_commit =>fnd_api.g_false,

124:
125: IEM_MC_PUB.prepareMessageComponentII
126: (p_api_version_number => 1.0,
127: p_init_msg_list =>fnd_api.g_false,
128: p_commit =>fnd_api.g_false,
129: p_action => 'automsg',
130: p_master_account_id => p_master_account_id,
131: p_activity_id =>fnd_api.g_miss_num,
132: p_to_address_list => p_to_address_list,

Line 131: p_activity_id =>fnd_api.g_miss_num,

127: p_init_msg_list =>fnd_api.g_false,
128: p_commit =>fnd_api.g_false,
129: p_action => 'automsg',
130: p_master_account_id => p_master_account_id,
131: p_activity_id =>fnd_api.g_miss_num,
132: p_to_address_list => p_to_address_list,
133: p_cc_address_list => p_cc_address_list,
134: p_bcc_address_list => p_bcc_address_list,
135: p_subject => p_subject,

Line 139: p_mes_document_id =>fnd_api.g_miss_num,

135: p_subject => p_subject,
136: p_sr_id => p_sr_id,
137: p_customer_id => p_customer_id,
138: p_contact_id => p_contact_id,
139: p_mes_document_id =>fnd_api.g_miss_num,
140: p_mes_category_id =>fnd_api.g_miss_num,
141: p_interaction_id => p_interaction_id,
142: p_qualifiers => l_qualifiers,
143: p_message_type => p_message_type,

Line 140: p_mes_category_id =>fnd_api.g_miss_num,

136: p_sr_id => p_sr_id,
137: p_customer_id => p_customer_id,
138: p_contact_id => p_contact_id,
139: p_mes_document_id =>fnd_api.g_miss_num,
140: p_mes_category_id =>fnd_api.g_miss_num,
141: p_interaction_id => p_interaction_id,
142: p_qualifiers => l_qualifiers,
143: p_message_type => p_message_type,
144: p_encoding => p_encoding,

Line 155: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

151: );
152:
153:
154: -- Check return status; Proceed on success Or report back in case of error.
155: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
156: -- Success.
157: --create outbound here
158:
159: -- if auto-ack, update the parent_ih_id

Line 170: p_init_msg_list => fnd_api.g_false,

166: end if;
167:
168: IEM_CLIENT_PUB.createMediaDetails (
169: p_api_version_number => 1.0,
170: p_init_msg_list => fnd_api.g_false,
171: p_commit => fnd_api.g_false,
172: p_resource_id => p_resource_id,
173: p_rfc822_message_id => null,
174: p_folder_name => G_NEWOUTB_FOLDER,

Line 171: p_commit => fnd_api.g_false,

167:
168: IEM_CLIENT_PUB.createMediaDetails (
169: p_api_version_number => 1.0,
170: p_init_msg_list => fnd_api.g_false,
171: p_commit => fnd_api.g_false,
172: p_resource_id => p_resource_id,
173: p_rfc822_message_id => null,
174: p_folder_name => G_NEWOUTB_FOLDER,
175: p_folder_uid => G_NUM_NOP2,

Line 180: p_rt_media_item_id => FND_API.G_MISS_NUM,

176: p_account_id => p_master_account_id,
177: p_account_type => G_MASTER_ACCOUNT,
178: p_status => G_CHAR_NOP,
179: p_customer_id => p_customer_id,
180: p_rt_media_item_id => FND_API.G_MISS_NUM,
181: p_subject => p_subject,
182: p_interaction_id => null,
183: p_service_request_id => p_sr_id,
184: p_mc_parameter_id => l_mc_parameter_id,

Line 199: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

195: x_rt_media_item_id => l_rt_media_item_id,
196: x_rt_interaction_id=> l_rt_interaction_id
197: );
198:
199: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
200:
201: UPDATE iem_rt_interactions SET status = 'S' -- send
202: WHERE rt_interaction_id = l_rt_interaction_id;
203:

Line 224: IF FND_API.To_Boolean(p_commit) THEN

220:
221: END IF;
222: -------------------End Code------------------------
223: -- Standard Check Of p_commit.
224: IF FND_API.To_Boolean(p_commit) THEN
225: COMMIT WORK;
226: END IF;
227:
228: -- Standard callto get message count and if count is 1, get message info.

Line 234: WHEN FND_API.G_EXC_ERROR THEN

230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO createOutboxMessage_pvt;
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,

Line 236: x_return_status := FND_API.G_RET_STS_ERROR ;

232: );
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO createOutboxMessage_pvt;
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240:

Line 241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: ROLLBACK TO createOutboxMessage_pvt;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.Count_And_Get(
245: p_count => x_msg_count,

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

239: p_data => x_msg_data);
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: ROLLBACK TO createOutboxMessage_pvt;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.Count_And_Get(
245: p_count => x_msg_count,
246: p_data => x_msg_data);
247: WHEN IEM_BAD_RECIPIENT THEN

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: p_count => x_msg_count,
246: p_data => x_msg_data);
247: WHEN IEM_BAD_RECIPIENT THEN
248: ROLLBACK TO createOutboxMessage_pvt;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RECIPIENT');
251: FND_MSG_PUB.ADD;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_TRUE,

Line 253: p_encoded => FND_API.G_TRUE,

249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RECIPIENT');
251: FND_MSG_PUB.ADD;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_TRUE,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN OTHERS THEN
257: ROLLBACK TO createOutboxMessage_pvt;

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN OTHERS THEN
257: ROLLBACK TO createOutboxMessage_pvt;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
260: THEN
261: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
262: END IF;

Line 296: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

292: -- Standard Start of API savepoint
293: SAVEPOINT cancelOutboxMessage_pvt;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
297: 1.0,
298: l_api_name,
299: G_PKG_NAME)
300: THEN

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: 1.0,
298: l_api_name,
299: G_PKG_NAME)
300: THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )

Line 305: IF FND_API.to_Boolean( p_init_msg_list )

301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Initialize API return status to SUCCESS
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: -----------------------Code------------------------
314: -- Expire rt_interactions and rt_media_items
315: SELECT rt_interaction_id INTO l_rt_interaction_id

Line 332: IF FND_API.To_Boolean(p_commit) THEN

328: WHERE rt_interaction_id = l_rt_interaction_id;
329:
330: -------------------End Code------------------------
331: -- Standard Check Of p_commit.
332: IF FND_API.To_Boolean(p_commit) THEN
333: COMMIT WORK;
334: END IF;
335:
336: EXCEPTION

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: COMMIT WORK;
334: END IF;
335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO cancelOutboxMessage_pvt;
339: x_return_status := FND_API.G_RET_STS_ERROR ;
340: FND_MSG_PUB.Count_And_Get(
341: p_count => x_msg_count,

Line 339: x_return_status := FND_API.G_RET_STS_ERROR ;

335:
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: ROLLBACK TO cancelOutboxMessage_pvt;
339: x_return_status := FND_API.G_RET_STS_ERROR ;
340: FND_MSG_PUB.Count_And_Get(
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

340: FND_MSG_PUB.Count_And_Get(
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO cancelOutboxMessage_pvt;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: FND_MSG_PUB.Count_And_Get(
348: p_count => x_msg_count,

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

342: p_data => x_msg_data);
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO cancelOutboxMessage_pvt;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: FND_MSG_PUB.Count_And_Get(
348: p_count => x_msg_count,
349: p_data => x_msg_data);
350:

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: p_data => x_msg_data);
350:
351: WHEN OTHERS THEN
352: ROLLBACK TO cancelOutboxMessage_pvt;
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
355: THEN
356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
357: END IF;

Line 399: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

395: -- Standard Start of API savepoint
396: SAVEPOINT submitOutboxMessage_pvt;
397:
398: -- Standard call to check for call compatibility.
399: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
400: 1.0,
401: l_api_name,
402: G_PKG_NAME)
403: THEN

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: 1.0,
401: l_api_name,
402: G_PKG_NAME)
403: THEN
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )

Line 408: IF FND_API.to_Boolean( p_init_msg_list )

404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: -- Initialize API return status to SUCCESS
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: -----------------------Code------------------------
417:
418: SELECT rt_interaction_id INTO l_rt_interaction_id

Line 429: p_init_msg_list => fnd_api.g_false,

425: FROM iem_rt_interactions
426: WHERE rt_interaction_id = l_rt_interaction_id;
427:
428: IEM_CLIENT_PUB.queueToOutbox (p_api_version_number => 1.0,
429: p_init_msg_list => fnd_api.g_false,
430: p_commit => fnd_api.g_false,
431: p_action => l_status,
432: p_action_id => l_action_id,
433: p_rt_media_item_id => p_outbox_item_id,

Line 430: p_commit => fnd_api.g_false,

426: WHERE rt_interaction_id = l_rt_interaction_id;
427:
428: IEM_CLIENT_PUB.queueToOutbox (p_api_version_number => 1.0,
429: p_init_msg_list => fnd_api.g_false,
430: p_commit => fnd_api.g_false,
431: p_action => l_status,
432: p_action_id => l_action_id,
433: p_rt_media_item_id => p_outbox_item_id,
434: p_version => 0,

Line 452: IF FND_API.To_Boolean(p_commit) THEN

448: x_msg_data := l_msg_data;
449:
450: -------------------End Code------------------------
451: -- Standard Check Of p_commit.
452: IF FND_API.To_Boolean(p_commit) THEN
453: COMMIT WORK;
454: END IF;
455:
456: EXCEPTION

Line 457: WHEN FND_API.G_EXC_ERROR THEN

453: COMMIT WORK;
454: END IF;
455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO submitOutboxMessage_pvt;
459: x_return_status := FND_API.G_RET_STS_ERROR ;
460: FND_MSG_PUB.Count_And_Get(
461: p_count => x_msg_count,

Line 459: x_return_status := FND_API.G_RET_STS_ERROR ;

455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO submitOutboxMessage_pvt;
459: x_return_status := FND_API.G_RET_STS_ERROR ;
460: FND_MSG_PUB.Count_And_Get(
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

460: FND_MSG_PUB.Count_And_Get(
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
464: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
465: x_msg_data := x_msg_data || ',' || l_msg_data;
466: END LOOP;
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

464: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
465: x_msg_data := x_msg_data || ',' || l_msg_data;
466: END LOOP;
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO submitOutboxMessage_pvt;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: FND_MSG_PUB.Count_And_Get(
472: p_count => x_msg_count,

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

466: END LOOP;
467:
468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: ROLLBACK TO submitOutboxMessage_pvt;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
471: FND_MSG_PUB.Count_And_Get(
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

471: FND_MSG_PUB.Count_And_Get(
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
475: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
476: x_msg_data := x_msg_data || ',' || l_msg_data;
477: END LOOP;
478:
479: WHEN OTHERS THEN

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: END LOOP;
478:
479: WHEN OTHERS THEN
480: ROLLBACK TO submitOutboxMessage_pvt;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
483: THEN
484: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
485: END IF;

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

485: END IF;
486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
487: p_data => x_msg_data);
488: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
489: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
490: x_msg_data := x_msg_data || ',' || l_msg_data;
491: END LOOP;
492:
493: END submitOutboxMessage;

Line 524: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

520: -- Standard Start of API savepoint
521: SAVEPOINT writeOutboxError_pvt;
522:
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
525: 1.0,
526: l_api_name,
527: G_PKG_NAME)
528: THEN

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

525: 1.0,
526: l_api_name,
527: G_PKG_NAME)
528: THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: -- Initialize message list if p_init_msg_list is set to TRUE.
533: IF FND_API.to_Boolean( p_init_msg_list )

Line 533: IF FND_API.to_Boolean( p_init_msg_list )

529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: -- Initialize message list if p_init_msg_list is set to TRUE.
533: IF FND_API.to_Boolean( p_init_msg_list )
534: THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537:

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- Initialize API return status to SUCCESS
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: -----------------------Code------------------------
542:
543: select iem_outbox_errors_s1.nextval into l_error_id from dual;

Line 553: IF FND_API.To_Boolean(p_commit) THEN

549: p_error_msg, SYSDATE, G_ACTIVE );
550:
551: -------------------End Code------------------------
552: -- Standard Check Of p_commit.
553: IF FND_API.To_Boolean(p_commit) THEN
554: COMMIT WORK;
555: END IF;
556:
557: EXCEPTION

Line 558: WHEN FND_API.G_EXC_ERROR THEN

554: COMMIT WORK;
555: END IF;
556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO writeOutboxError_pvt;
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get(
562: p_count => x_msg_count,

Line 560: x_return_status := FND_API.G_RET_STS_ERROR ;

556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO writeOutboxError_pvt;
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get(
562: p_count => x_msg_count,
563: p_data => x_msg_data);
564:

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561: FND_MSG_PUB.Count_And_Get(
562: p_count => x_msg_count,
563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO writeOutboxError_pvt;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: FND_MSG_PUB.Count_And_Get(
569: p_count => x_msg_count,

Line 567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

563: p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO writeOutboxError_pvt;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: FND_MSG_PUB.Count_And_Get(
569: p_count => x_msg_count,
570: p_data => x_msg_data);
571:

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570: p_data => x_msg_data);
571:
572: WHEN OTHERS THEN
573: ROLLBACK TO writeOutboxError_pvt;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
578: END IF;

Line 645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

641: -- Standard Start of API savepoint
642: SAVEPOINT createAutoReply_pvt;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
646: 1.0,
647: l_api_name,
648: G_PKG_NAME)
649: THEN

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

646: 1.0,
647: l_api_name,
648: G_PKG_NAME)
649: THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_Boolean( p_init_msg_list )

Line 654: IF FND_API.to_Boolean( p_init_msg_list )

650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_Boolean( p_init_msg_list )
655: THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: -- Initialize API return status to SUCCESS
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: -----------------------Code------------------------
663: -- Extract tag key value from key value table
664: -- Currently valid system key names:

Line 705: IF ( p_interaction_id = fnd_api.g_miss_num) THEN

701: -- Find resource_id by searching outbox_processing_agent.
702: l_resource_id := p_resource_id;
703:
704: -- Record details into the RT tables.
705: IF ( p_interaction_id = fnd_api.g_miss_num) THEN
706: l_interaction_id := null;
707: l_ih_creator := null;
708: ELSE
709: l_interaction_id := p_interaction_id;

Line 726: p_init_msg_list =>fnd_api.g_false,

722: END IF;
723:
724: IEM_MC_PUB.prepareMessageComponentII
725: (p_api_version_number => 1.0,
726: p_init_msg_list =>fnd_api.g_false,
727: p_commit =>fnd_api.g_false,
728: p_action => 'autoreply',
729: p_master_account_id => p_master_account_id,
730: p_activity_id => fnd_api.g_miss_num,

Line 727: p_commit =>fnd_api.g_false,

723:
724: IEM_MC_PUB.prepareMessageComponentII
725: (p_api_version_number => 1.0,
726: p_init_msg_list =>fnd_api.g_false,
727: p_commit =>fnd_api.g_false,
728: p_action => 'autoreply',
729: p_master_account_id => p_master_account_id,
730: p_activity_id => fnd_api.g_miss_num,
731: p_to_address_list => p_to_address_list,

Line 730: p_activity_id => fnd_api.g_miss_num,

726: p_init_msg_list =>fnd_api.g_false,
727: p_commit =>fnd_api.g_false,
728: p_action => 'autoreply',
729: p_master_account_id => p_master_account_id,
730: p_activity_id => fnd_api.g_miss_num,
731: p_to_address_list => p_to_address_list,
732: p_cc_address_list => p_cc_address_list,
733: p_bcc_address_list => p_bcc_address_list,
734: p_subject => p_subject,

Line 738: p_mes_document_id => fnd_api.g_miss_num,

734: p_subject => p_subject,
735: p_sr_id => null,
736: p_customer_id => l_customer_id,
737: p_contact_id => l_contact_id,
738: p_mes_document_id => fnd_api.g_miss_num,
739: p_mes_category_id => fnd_api.g_miss_num,
740: p_interaction_id => null,
741: p_qualifiers => l_qualifiers,
742: p_message_type => null, --p_message_type,

Line 739: p_mes_category_id => fnd_api.g_miss_num,

735: p_sr_id => null,
736: p_customer_id => l_customer_id,
737: p_contact_id => l_contact_id,
738: p_mes_document_id => fnd_api.g_miss_num,
739: p_mes_category_id => fnd_api.g_miss_num,
740: p_interaction_id => null,
741: p_qualifiers => l_qualifiers,
742: p_message_type => null, --p_message_type,
743: p_encoding => null, --p_encoding,

Line 754: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

750: );
751:
752:
753: -- Check return status; Proceed on success Or report back in case of error.
754: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
755: -- Success.
756:
757:
758: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

Line 795: p_init_msg_list => fnd_api.g_false,

791: l_last_updated_by, SYSDATE, l_last_update_login );
792:
793: --create outbound here
794: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
795: p_init_msg_list => fnd_api.g_false,
796: p_commit => fnd_api.g_false,
797: p_resource_id => l_resource_id,
798: p_rfc822_message_id => null,
799: p_folder_name => G_NEWOUTB_FOLDER,

Line 796: p_commit => fnd_api.g_false,

792:
793: --create outbound here
794: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
795: p_init_msg_list => fnd_api.g_false,
796: p_commit => fnd_api.g_false,
797: p_resource_id => l_resource_id,
798: p_rfc822_message_id => null,
799: p_folder_name => G_NEWOUTB_FOLDER,
800: p_folder_uid => G_NUM_NOP2,

Line 824: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

820: x_rt_media_item_id => l_rt_media_item_id,
821: x_rt_interaction_id => l_rt_interaction_id
822: );
823:
824: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
825: x_outbox_item_id := l_rt_media_item_id;
826:
827: ELSE
828: -- return the error returned by IEM_CLIENT_PUB.createMediaDetails

Line 845: IF FND_API.To_Boolean(p_commit) THEN

841: END IF;
842:
843: -------------------End Code------------------------
844: -- Standard Check Of p_commit.
845: IF FND_API.To_Boolean(p_commit) THEN
846: COMMIT WORK;
847: END IF;
848:
849: -- Standard callto get message count and if count is 1, get message info.

Line 855: WHEN FND_API.G_EXC_ERROR THEN

851: ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO createAutoReply_pvt;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get(
859: p_count => x_msg_count,

Line 857: x_return_status := FND_API.G_RET_STS_ERROR ;

853: );
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO createAutoReply_pvt;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get(
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:

Line 862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

858: FND_MSG_PUB.Count_And_Get(
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK TO createAutoReply_pvt;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
865: FND_MSG_PUB.Count_And_Get(
866: p_count => x_msg_count,

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

860: p_data => x_msg_data);
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK TO createAutoReply_pvt;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
865: FND_MSG_PUB.Count_And_Get(
866: p_count => x_msg_count,
867: p_data => x_msg_data);
868:

Line 871: x_return_status := FND_API.G_RET_STS_ERROR;

867: p_data => x_msg_data);
868:
869: WHEN OTHERS THEN
870: ROLLBACK TO createAutoReply_pvt;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN
874: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
875: END IF;

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

902: BEGIN
903:
904: SAVEPOINT insertBodyText;
905:
906: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
907: then
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: SAVEPOINT insertBodyText;
905:
906: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
907: then
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: IF fnd_api.to_boolean(p_init_msg_list)
912: then

Line 911: IF fnd_api.to_boolean(p_init_msg_list)

907: then
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: IF fnd_api.to_boolean(p_init_msg_list)
912: then
913: FND_MSG_PUB.initialize;
914: end if;
915:

Line 916: x_return_status := fnd_api.g_ret_sts_success;

912: then
913: FND_MSG_PUB.initialize;
914: end if;
915:
916: x_return_status := fnd_api.g_ret_sts_success;
917:
918: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';
919: l_sequence := l_sequence + 1;
920:

Line 943: IF FND_API.To_Boolean(p_commit) THEN

939:
940: update IEM_MSG_PARTS set PART_DATA = p_text where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT' and PART_NAME = l_sequence;
941:
942: -- Standard check of p_commit
943: IF FND_API.To_Boolean(p_commit) THEN
944: COMMIT WORK;
945: END IF;
946:
947: -- Standard call to get message count and if count is 1, get message info.

Line 954: WHEN FND_API.G_EXC_ERROR THEN

950: p_data => x_msg_data
951: );
952:
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: ROLLBACK TO IEM_MSG_PARTS;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get(

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: ROLLBACK TO IEM_MSG_PARTS;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_count => x_msg_count,
960: p_data => x_msg_data
961: );

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

961: );
962:
963:
964: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
965: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
966: x_msg_data := x_msg_data || ',' || l_msg_data;
967: END LOOP;
968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

965: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
966: x_msg_data := x_msg_data || ',' || l_msg_data;
967: END LOOP;
968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO IEM_MSG_PARTS;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_And_Get
973: (

Line 971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

967: END LOOP;
968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO IEM_MSG_PARTS;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_And_Get
973: (
974: p_count => x_msg_count,
975: p_data => x_msg_data

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

975: p_data => x_msg_data
976: );
977:
978: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
979: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
980: x_msg_data := x_msg_data || ',' || l_msg_data;
981: END LOOP;
982:
983: WHEN OTHERS THEN

Line 985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

981: END LOOP;
982:
983: WHEN OTHERS THEN
984: ROLLBACK TO IEM_MSG_PARTS;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986:
987: FND_MSG_PUB.Count_And_Get (
988: p_count => x_msg_count,
989: p_data => x_msg_data

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

989: p_data => x_msg_data
990: );
991:
992: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
993: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
994: x_msg_data := x_msg_data || ',' || l_msg_data;
995: END LOOP;
996:
997: END insertBodyText;

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

1021: BEGIN
1022:
1023: SAVEPOINT insertDocument;
1024:
1025: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
1026: then
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029:

Line 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1023: SAVEPOINT insertDocument;
1024:
1025: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
1026: then
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029:
1030: IF fnd_api.to_boolean(p_init_msg_list)
1031: then

Line 1030: IF fnd_api.to_boolean(p_init_msg_list)

1026: then
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029:
1030: IF fnd_api.to_boolean(p_init_msg_list)
1031: then
1032: FND_MSG_PUB.initialize;
1033: end if;
1034:

Line 1035: x_return_status := fnd_api.g_ret_sts_success;

1031: then
1032: FND_MSG_PUB.initialize;
1033: end if;
1034:
1035: x_return_status := fnd_api.g_ret_sts_success;
1036:
1037: l_part_info := '__DOC__:'||p_document_id||'@'||p_document_source;
1038:
1039: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';

Line 1064: IF FND_API.To_Boolean(p_commit) THEN

1060: SYSDATE
1061: );
1062:
1063: -- Standard check of p_commit
1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info.

Line 1075: WHEN FND_API.G_EXC_ERROR THEN

1071: p_data => x_msg_data
1072: );
1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK TO IEM_MSG_PARTS;
1077:
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get(

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK TO IEM_MSG_PARTS;
1077:
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get(
1080: p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );

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

1082: );
1083:
1084:
1085: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1086: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1087: x_msg_data := x_msg_data || ',' || l_msg_data;
1088: END LOOP;
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1086: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1087: x_msg_data := x_msg_data || ',' || l_msg_data;
1088: END LOOP;
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: ROLLBACK TO IEM_MSG_PARTS;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: FND_MSG_PUB.Count_And_Get
1094: (

Line 1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1088: END LOOP;
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: ROLLBACK TO IEM_MSG_PARTS;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: FND_MSG_PUB.Count_And_Get
1094: (
1095: p_count => x_msg_count,
1096: p_data => x_msg_data

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

1096: p_data => x_msg_data
1097: );
1098:
1099: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1100: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1101: x_msg_data := x_msg_data || ',' || l_msg_data;
1102: END LOOP;
1103:
1104:

Line 1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1103:
1104:
1105: WHEN OTHERS THEN
1106: ROLLBACK TO IEM_MSG_PARTS;
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108:
1109: FND_MSG_PUB.Count_And_Get (
1110: p_count => x_msg_count,
1111: p_data => x_msg_data

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

1111: p_data => x_msg_data
1112: );
1113:
1114: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1115: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1116: x_msg_data := x_msg_data || ',' || l_msg_data;
1117: END LOOP;
1118:
1119: END insertDocument;

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

1144: BEGIN
1145:
1146: SAVEPOINT attachDocument;
1147:
1148: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
1149: then
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152:

Line 1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1146: SAVEPOINT attachDocument;
1147:
1148: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
1149: then
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152:
1153: IF fnd_api.to_boolean(p_init_msg_list)
1154: then

Line 1153: IF fnd_api.to_boolean(p_init_msg_list)

1149: then
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152:
1153: IF fnd_api.to_boolean(p_init_msg_list)
1154: then
1155: FND_MSG_PUB.initialize;
1156: end if;
1157:

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: then
1155: FND_MSG_PUB.initialize;
1156: end if;
1157:
1158: x_return_status := fnd_api.g_ret_sts_success;
1159:
1160: IF (p_document_source = 'BINARY')
1161: THEN
1162: insert into IEM_MSG_PARTS

Line 1211: IF FND_API.To_Boolean(p_commit) THEN

1207: );
1208: END IF;
1209:
1210: -- Standard check of p_commit
1211: IF FND_API.To_Boolean(p_commit) THEN
1212: COMMIT WORK;
1213: END IF;
1214:
1215: -- Standard call to get message count and if count is 1, get message info.

Line 1222: WHEN FND_API.G_EXC_ERROR THEN

1218: p_data => x_msg_data
1219: );
1220:
1221: EXCEPTION
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: ROLLBACK TO IEM_MSG_PARTS;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR;

1221: EXCEPTION
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: ROLLBACK TO IEM_MSG_PARTS;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );

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

1229: );
1230:
1231:
1232: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1233: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1234: x_msg_data := x_msg_data || ',' || l_msg_data;
1235: END LOOP;
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1233: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1234: x_msg_data := x_msg_data || ',' || l_msg_data;
1235: END LOOP;
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO IEM_MSG_PARTS;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get
1241: (

Line 1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1235: END LOOP;
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO IEM_MSG_PARTS;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get
1241: (
1242: p_count => x_msg_count,
1243: p_data => x_msg_data

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

1243: p_data => x_msg_data
1244: );
1245:
1246: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1247: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1248: x_msg_data := x_msg_data || ',' || l_msg_data;
1249: END LOOP;
1250:
1251: WHEN OTHERS THEN

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1249: END LOOP;
1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO IEM_MSG_PARTS;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: FND_MSG_PUB.Count_And_Get (
1256: p_count => x_msg_count,
1257: p_data => x_msg_data

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

1257: p_data => x_msg_data
1258: );
1259:
1260: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
1261: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
1262: x_msg_data := x_msg_data || ',' || l_msg_data;
1263: END LOOP;
1264:
1265: END attachDocument;

Line 1298: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1294: -- Standard Start of API savepoint
1295: SAVEPOINT getAccountList_pvt;
1296:
1297: -- Standard call to check for call compatibility.
1298: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1299: 1.0,
1300: l_api_name,
1301: G_PKG_NAME)
1302: THEN

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299: 1.0,
1300: l_api_name,
1301: G_PKG_NAME)
1302: THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list )

Line 1307: IF FND_API.to_Boolean( p_init_msg_list )

1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: -- Initialize message list if p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list )
1308: THEN
1309: FND_MSG_PUB.initialize;
1310: END IF;
1311:

Line 1313: x_return_status := FND_API.G_RET_STS_SUCCESS;

1309: FND_MSG_PUB.initialize;
1310: END IF;
1311:
1312: -- Initialize API return status to SUCCESS
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: -----------------------Code------------------------
1316:
1317: IEM_EMAILACCOUNT_PUB.Get_EmailAccount_List (p_api_version_number =>1.0,

Line 1318: p_init_msg_list => FND_API.G_FALSE,

1314:
1315: -----------------------Code------------------------
1316:
1317: IEM_EMAILACCOUNT_PUB.Get_EmailAccount_List (p_api_version_number =>1.0,
1318: p_init_msg_list => FND_API.G_FALSE,
1319: p_commit => FND_API.G_FALSE,
1320: p_RESOURCE_ID => p_resource_id,
1321: x_return_status => l_return_status,
1322: x_msg_count => l_msg_count,

Line 1319: p_commit => FND_API.G_FALSE,

1315: -----------------------Code------------------------
1316:
1317: IEM_EMAILACCOUNT_PUB.Get_EmailAccount_List (p_api_version_number =>1.0,
1318: p_init_msg_list => FND_API.G_FALSE,
1319: p_commit => FND_API.G_FALSE,
1320: p_RESOURCE_ID => p_resource_id,
1321: x_return_status => l_return_status,
1322: x_msg_count => l_msg_count,
1323: x_msg_data => l_msg_data,

Line 1326: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

1322: x_msg_count => l_msg_count,
1323: x_msg_data => l_msg_data,
1324: x_Email_Acnt_tbl => l_account_list
1325: );
1326: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1327: if (l_account_list.count > 0) then
1328: l_index := 1;
1329: FOR i in l_account_list.first..l_account_list.last LOOP
1330: x_account_list(l_index).account_id := l_account_list(i).account_id;

Line 1342: IF FND_API.To_Boolean(p_commit) THEN

1338: x_msg_data := l_msg_data;
1339: END IF;
1340: -------------------End Code------------------------
1341: -- Standard Check Of p_commit.
1342: IF FND_API.To_Boolean(p_commit) THEN
1343: COMMIT WORK;
1344: END IF;
1345:
1346: EXCEPTION

Line 1347: WHEN FND_API.G_EXC_ERROR THEN

1343: COMMIT WORK;
1344: END IF;
1345:
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO getAccountList_pvt;
1349: x_return_status := FND_API.G_RET_STS_ERROR ;
1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,

Line 1349: x_return_status := FND_API.G_RET_STS_ERROR ;

1345:
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: ROLLBACK TO getAccountList_pvt;
1349: x_return_status := FND_API.G_RET_STS_ERROR ;
1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,
1352: p_data => x_msg_data);
1353:

Line 1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,
1352: p_data => x_msg_data);
1353:
1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1355: ROLLBACK TO getAccountList_pvt;
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1357: FND_MSG_PUB.Count_And_Get(
1358: p_count => x_msg_count,

Line 1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1352: p_data => x_msg_data);
1353:
1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1355: ROLLBACK TO getAccountList_pvt;
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1357: FND_MSG_PUB.Count_And_Get(
1358: p_count => x_msg_count,
1359: p_data => x_msg_data);
1360:

Line 1363: x_return_status := FND_API.G_RET_STS_ERROR;

1359: p_data => x_msg_data);
1360:
1361: WHEN OTHERS THEN
1362: ROLLBACK TO getAccountList_pvt;
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1367: END IF;

Line 1408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1404: -- Standard Start of API savepoint
1405: SAVEPOINT redirectMessage_pvt;
1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1409: 1.0,
1410: l_api_name,
1411: G_PKG_NAME)
1412: THEN

Line 1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1409: 1.0,
1410: l_api_name,
1411: G_PKG_NAME)
1412: THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415:
1416: -- Initialize message list if p_init_msg_list is set to TRUE.
1417: IF FND_API.to_Boolean( p_init_msg_list )

Line 1417: IF FND_API.to_Boolean( p_init_msg_list )

1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415:
1416: -- Initialize message list if p_init_msg_list is set to TRUE.
1417: IF FND_API.to_Boolean( p_init_msg_list )
1418: THEN
1419: FND_MSG_PUB.initialize;
1420: END IF;
1421:

Line 1423: x_return_status := FND_API.G_RET_STS_SUCCESS;

1419: FND_MSG_PUB.initialize;
1420: END IF;
1421:
1422: -- Initialize API return status to SUCCESS
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:
1425: -----------------------Code------------------------
1426: begin
1427: select EMAIL_ACCOUNT_ID, RT_CLASSIFICATION_ID,

Line 1477: IF FND_API.To_Boolean(p_commit) THEN

1473:
1474: x_outbox_item_id := l_m_sequence;
1475: -------------------End Code------------------------
1476: -- Standard Check Of p_commit.
1477: IF FND_API.To_Boolean(p_commit) THEN
1478: COMMIT WORK;
1479: END IF;
1480:
1481: -- Standard callto get message count and if count is 1, get message info.

Line 1483: ( p_encoded => FND_API.G_TRUE,

1479: END IF;
1480:
1481: -- Standard callto get message count and if count is 1, get message info.
1482: FND_MSG_PUB.Count_And_Get
1483: ( p_encoded => FND_API.G_TRUE,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data
1486: );
1487:

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR ;

1487:
1488: EXCEPTION
1489: WHEN IEM_NO_DATA THEN
1490: ROLLBACK TO redirectMessage_pvt;
1491: x_return_status := FND_API.G_RET_STS_ERROR ;
1492: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1493: FND_MSG_PUB.ADD;
1494: FND_MSG_PUB.Count_And_Get(
1495: p_encoded => FND_API.G_TRUE,

Line 1495: p_encoded => FND_API.G_TRUE,

1491: x_return_status := FND_API.G_RET_STS_ERROR ;
1492: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1493: FND_MSG_PUB.ADD;
1494: FND_MSG_PUB.Count_And_Get(
1495: p_encoded => FND_API.G_TRUE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:
1499: WHEN FND_API.G_EXC_ERROR THEN

Line 1499: WHEN FND_API.G_EXC_ERROR THEN

1495: p_encoded => FND_API.G_TRUE,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK TO redirectMessage_pvt;
1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502: FND_MSG_PUB.Count_And_Get(
1503: p_count => x_msg_count,

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR ;

1497: p_data => x_msg_data);
1498:
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK TO redirectMessage_pvt;
1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502: FND_MSG_PUB.Count_And_Get(
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);
1505:

Line 1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1502: FND_MSG_PUB.Count_And_Get(
1503: p_count => x_msg_count,
1504: p_data => x_msg_data);
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: ROLLBACK TO redirectMessage_pvt;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1509: FND_MSG_PUB.Count_And_Get(
1510: p_count => x_msg_count,

Line 1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1504: p_data => x_msg_data);
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: ROLLBACK TO redirectMessage_pvt;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1509: FND_MSG_PUB.Count_And_Get(
1510: p_count => x_msg_count,
1511: p_data => x_msg_data);
1512:

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: p_data => x_msg_data);
1512:
1513: WHEN OTHERS THEN
1514: ROLLBACK TO redirectMessage_pvt;
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1519: END IF;

Line 1589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1585: -- Standard Start of API savepoint
1586: SAVEPOINT autoForward_pvt;
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1590: 1.0,
1591: l_api_name,
1592: G_PKG_NAME)
1593: THEN

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590: 1.0,
1591: l_api_name,
1592: G_PKG_NAME)
1593: THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;
1596:
1597: -- Initialize message list if p_init_msg_list is set to TRUE.
1598: IF FND_API.to_Boolean( p_init_msg_list )

Line 1598: IF FND_API.to_Boolean( p_init_msg_list )

1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;
1596:
1597: -- Initialize message list if p_init_msg_list is set to TRUE.
1598: IF FND_API.to_Boolean( p_init_msg_list )
1599: THEN
1600: FND_MSG_PUB.initialize;
1601: END IF;
1602:

Line 1604: x_return_status := FND_API.G_RET_STS_SUCCESS;

1600: FND_MSG_PUB.initialize;
1601: END IF;
1602:
1603: -- Initialize API return status to SUCCESS
1604: x_return_status := FND_API.G_RET_STS_SUCCESS;
1605:
1606: -----------------------Code------------------------
1607: -- insanity check
1608: IF (p_to_address_list is null and p_cc_address_list is null) THEN

Line 1654: IF ( p_interaction_id = fnd_api.g_miss_num) THEN

1650: -- Find resource_id by searching outbox_processing_agent.
1651: l_resource_id := p_resource_id;
1652:
1653: -- Record details into the RT tables.
1654: IF ( p_interaction_id = fnd_api.g_miss_num) THEN
1655: l_interaction_id := null;
1656: l_ih_creator := null;
1657: ELSE
1658: l_interaction_id := p_interaction_id;

Line 1676: p_init_msg_list => fnd_api.g_false,

1672: END IF;
1673:
1674: IEM_MC_PUB.prepareMessageComponentII
1675: (p_api_version_number => 1.0,
1676: p_init_msg_list => fnd_api.g_false,
1677: p_commit => fnd_api.g_false,
1678: p_action => 'autoforward',
1679: p_master_account_id => p_master_account_id,
1680: p_activity_id => fnd_api.g_miss_num,

Line 1677: p_commit => fnd_api.g_false,

1673:
1674: IEM_MC_PUB.prepareMessageComponentII
1675: (p_api_version_number => 1.0,
1676: p_init_msg_list => fnd_api.g_false,
1677: p_commit => fnd_api.g_false,
1678: p_action => 'autoforward',
1679: p_master_account_id => p_master_account_id,
1680: p_activity_id => fnd_api.g_miss_num,
1681: p_to_address_list => p_to_address_list,

Line 1680: p_activity_id => fnd_api.g_miss_num,

1676: p_init_msg_list => fnd_api.g_false,
1677: p_commit => fnd_api.g_false,
1678: p_action => 'autoforward',
1679: p_master_account_id => p_master_account_id,
1680: p_activity_id => fnd_api.g_miss_num,
1681: p_to_address_list => p_to_address_list,
1682: p_cc_address_list => p_cc_address_list,
1683: p_bcc_address_list => p_bcc_address_list,
1684: p_subject => p_subject,

Line 1688: p_mes_document_id => fnd_api.g_miss_num,

1684: p_subject => p_subject,
1685: p_sr_id => null,
1686: p_customer_id => l_customer_id,
1687: p_contact_id => l_contact_id,
1688: p_mes_document_id => fnd_api.g_miss_num,
1689: p_mes_category_id => fnd_api.g_miss_num,
1690: p_interaction_id => l_interaction_id,
1691: p_qualifiers => l_qualifiers,
1692: p_message_type => null, --p_message_type, use the same as inb

Line 1689: p_mes_category_id => fnd_api.g_miss_num,

1685: p_sr_id => null,
1686: p_customer_id => l_customer_id,
1687: p_contact_id => l_contact_id,
1688: p_mes_document_id => fnd_api.g_miss_num,
1689: p_mes_category_id => fnd_api.g_miss_num,
1690: p_interaction_id => l_interaction_id,
1691: p_qualifiers => l_qualifiers,
1692: p_message_type => null, --p_message_type, use the same as inb
1693: p_encoding => null, --p_encoding,

Line 1704: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1700: );
1701:
1702:
1703: -- Check return status; Proceed on success Or report back in case of error.
1704: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1705: -- Success.
1706: --create outbound here
1707:
1708: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

Line 1746: p_init_msg_list => fnd_api.g_false,

1742: l_last_updated_by, SYSDATE, l_last_update_login, p_attach_inb);
1743:
1744: --create outbound here
1745: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
1746: p_init_msg_list => fnd_api.g_false,
1747: p_commit => fnd_api.g_false,
1748: p_resource_id => l_resource_id,
1749: p_rfc822_message_id => null,
1750: p_folder_name => G_NEWOUTB_FOLDER,

Line 1747: p_commit => fnd_api.g_false,

1743:
1744: --create outbound here
1745: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
1746: p_init_msg_list => fnd_api.g_false,
1747: p_commit => fnd_api.g_false,
1748: p_resource_id => l_resource_id,
1749: p_rfc822_message_id => null,
1750: p_folder_name => G_NEWOUTB_FOLDER,
1751: p_folder_uid => G_NUM_NOP2,

Line 1775: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1771: x_rt_media_item_id => l_rt_media_item_id,
1772: x_rt_interaction_id => l_rt_interaction_id
1773: );
1774:
1775: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1776: x_outbox_item_id := l_rt_media_item_id;
1777:
1778: ELSE
1779: -- return the error returned by IEM_CLIENT_PUB.createMediaDetails

Line 1796: IF FND_API.To_Boolean(p_commit) THEN

1792:
1793: END IF;
1794: -------------------End Code------------------------
1795: -- Standard Check Of p_commit.
1796: IF FND_API.To_Boolean(p_commit) THEN
1797: COMMIT WORK;
1798: END IF;
1799:
1800: -- Standard callto get message count and if count is 1, get message info.

Line 1806: WHEN FND_API.G_EXC_ERROR THEN

1802: ( p_count => x_msg_count,
1803: p_data => x_msg_data
1804: );
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: ROLLBACK TO autoForward_pvt;
1808: x_return_status := FND_API.G_RET_STS_ERROR ;
1809: FND_MSG_PUB.Count_And_Get(
1810: p_count => x_msg_count,

Line 1808: x_return_status := FND_API.G_RET_STS_ERROR ;

1804: );
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: ROLLBACK TO autoForward_pvt;
1808: x_return_status := FND_API.G_RET_STS_ERROR ;
1809: FND_MSG_PUB.Count_And_Get(
1810: p_count => x_msg_count,
1811: p_data => x_msg_data);
1812:

Line 1813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1809: FND_MSG_PUB.Count_And_Get(
1810: p_count => x_msg_count,
1811: p_data => x_msg_data);
1812:
1813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1814: ROLLBACK TO autoForward_pvt;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1816: FND_MSG_PUB.Count_And_Get(
1817: p_count => x_msg_count,

Line 1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1811: p_data => x_msg_data);
1812:
1813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1814: ROLLBACK TO autoForward_pvt;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1816: FND_MSG_PUB.Count_And_Get(
1817: p_count => x_msg_count,
1818: p_data => x_msg_data);
1819: WHEN IEM_BAD_RECIPIENT THEN

Line 1821: x_return_status := FND_API.G_RET_STS_ERROR;

1817: p_count => x_msg_count,
1818: p_data => x_msg_data);
1819: WHEN IEM_BAD_RECIPIENT THEN
1820: ROLLBACK TO autoForward_pvt;
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RECIPIENT');
1823: FND_MSG_PUB.ADD;
1824: FND_MSG_PUB.Count_And_Get(
1825: p_encoded => FND_API.G_TRUE,

Line 1825: p_encoded => FND_API.G_TRUE,

1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RECIPIENT');
1823: FND_MSG_PUB.ADD;
1824: FND_MSG_PUB.Count_And_Get(
1825: p_encoded => FND_API.G_TRUE,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828: WHEN OTHERS THEN
1829: ROLLBACK TO autoForward_pvt;

Line 1830: x_return_status := FND_API.G_RET_STS_ERROR;

1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828: WHEN OTHERS THEN
1829: ROLLBACK TO autoForward_pvt;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1832: THEN
1833: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1834: END IF;

Line 1899: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1895: -- Standard Start of API savepoint
1896: SAVEPOINT createSRAutoNotification_spt;
1897:
1898: -- Standard call to check for call compatibility.
1899: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1900: 1.0,
1901: l_api_name,
1902: G_PKG_NAME)
1903: THEN

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: 1.0,
1901: l_api_name,
1902: G_PKG_NAME)
1903: THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906:
1907: -- Initialize message list if p_init_msg_list is set to TRUE.
1908: IF FND_API.to_Boolean( p_init_msg_list )

Line 1908: IF FND_API.to_Boolean( p_init_msg_list )

1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: END IF;
1906:
1907: -- Initialize message list if p_init_msg_list is set to TRUE.
1908: IF FND_API.to_Boolean( p_init_msg_list )
1909: THEN
1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910: FND_MSG_PUB.initialize;
1911: END IF;
1912:
1913: -- Initialize API return status to SUCCESS
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: -----------------------Code------------------------
1917: -- Extract tag key value from key value table
1918: -- Currently valid system key names:

Line 1957: IF ( p_interaction_id = fnd_api.g_miss_num) THEN

1953: -- Find resource_id by searching outbox_processing_agent.
1954: l_resource_id := p_resource_id;
1955:
1956: -- Record details into the RT tables.
1957: IF ( p_interaction_id = fnd_api.g_miss_num) THEN
1958: l_interaction_id := null;
1959: l_ih_creator := null;
1960: ELSE
1961: l_interaction_id := p_interaction_id;

Line 1988: p_init_msg_list =>fnd_api.g_false,

1984: END IF;
1985:
1986: IEM_MC_PUB.prepareMessageComponentII
1987: (p_api_version_number => 1.0,
1988: p_init_msg_list =>fnd_api.g_false,
1989: p_commit =>fnd_api.g_false,
1990: p_action => 'srautonotification',
1991: p_master_account_id => p_master_account_id,
1992: p_activity_id => fnd_api.g_miss_num,

Line 1989: p_commit =>fnd_api.g_false,

1985:
1986: IEM_MC_PUB.prepareMessageComponentII
1987: (p_api_version_number => 1.0,
1988: p_init_msg_list =>fnd_api.g_false,
1989: p_commit =>fnd_api.g_false,
1990: p_action => 'srautonotification',
1991: p_master_account_id => p_master_account_id,
1992: p_activity_id => fnd_api.g_miss_num,
1993: p_to_address_list => p_to_address_list,

Line 1992: p_activity_id => fnd_api.g_miss_num,

1988: p_init_msg_list =>fnd_api.g_false,
1989: p_commit =>fnd_api.g_false,
1990: p_action => 'srautonotification',
1991: p_master_account_id => p_master_account_id,
1992: p_activity_id => fnd_api.g_miss_num,
1993: p_to_address_list => p_to_address_list,
1994: p_cc_address_list => p_cc_address_list,
1995: p_bcc_address_list => p_bcc_address_list,
1996: p_subject => p_subject,

Line 2000: p_mes_document_id => fnd_api.g_miss_num,

1996: p_subject => p_subject,
1997: p_sr_id => p_sr_id,
1998: p_customer_id => l_customer_id,
1999: p_contact_id => l_contact_id,
2000: p_mes_document_id => fnd_api.g_miss_num,
2001: p_mes_category_id => fnd_api.g_miss_num,
2002: p_interaction_id => null,
2003: p_qualifiers => l_qualifiers,
2004: p_message_type => null, --p_message_type,

Line 2001: p_mes_category_id => fnd_api.g_miss_num,

1997: p_sr_id => p_sr_id,
1998: p_customer_id => l_customer_id,
1999: p_contact_id => l_contact_id,
2000: p_mes_document_id => fnd_api.g_miss_num,
2001: p_mes_category_id => fnd_api.g_miss_num,
2002: p_interaction_id => null,
2003: p_qualifiers => l_qualifiers,
2004: p_message_type => null, --p_message_type,
2005: p_encoding => null, --p_encoding,

Line 2016: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2012: );
2013:
2014:
2015: -- Check return status; Proceed on success Or report back in case of error.
2016: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2017: -- Success.
2018:
2019:
2020: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

Line 2057: p_init_msg_list => fnd_api.g_false,

2053: l_last_updated_by, SYSDATE, l_last_update_login );
2054:
2055: --create outbound here
2056: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
2057: p_init_msg_list => fnd_api.g_false,
2058: p_commit => fnd_api.g_false,
2059: p_resource_id => l_resource_id,
2060: p_rfc822_message_id => null,
2061: p_folder_name => G_NEWOUTB_FOLDER,

Line 2058: p_commit => fnd_api.g_false,

2054:
2055: --create outbound here
2056: IEM_CLIENT_PUB.createMediaDetails (p_api_version_number => 1.0,
2057: p_init_msg_list => fnd_api.g_false,
2058: p_commit => fnd_api.g_false,
2059: p_resource_id => l_resource_id,
2060: p_rfc822_message_id => null,
2061: p_folder_name => G_NEWOUTB_FOLDER,
2062: p_folder_uid => null,

Line 2086: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2082: x_rt_media_item_id => l_rt_media_item_id,
2083: x_rt_interaction_id => l_rt_interaction_id
2084: );
2085:
2086: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2087: x_outbox_item_id := l_rt_media_item_id;
2088:
2089: ELSE
2090: -- return the error returned by IEM_CLIENT_PUB.createMediaDetails

Line 2107: IF FND_API.To_Boolean(p_commit) THEN

2103: END IF;
2104:
2105: -------------------End Code------------------------
2106: -- Standard Check Of p_commit.
2107: IF FND_API.To_Boolean(p_commit) THEN
2108: COMMIT WORK;
2109: END IF;
2110:
2111: -- Standard callto get message count and if count is 1, get message info.

Line 2119: x_return_status := FND_API.G_RET_STS_ERROR ;

2115: );
2116: EXCEPTION
2117: WHEN IEM_BAD_IH_ID THEN
2118: ROLLBACK TO createSRAutoNotification_spt;
2119: x_return_status := FND_API.G_RET_STS_ERROR ;
2120: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_IH_ID');
2121: FND_MSG_PUB.ADD;
2122: FND_MSG_PUB.Count_And_Get(
2123: p_count => x_msg_count,

Line 2125: WHEN FND_API.G_EXC_ERROR THEN

2121: FND_MSG_PUB.ADD;
2122: FND_MSG_PUB.Count_And_Get(
2123: p_count => x_msg_count,
2124: p_data => x_msg_data);
2125: WHEN FND_API.G_EXC_ERROR THEN
2126: ROLLBACK TO createSRAutoNotification_spt;
2127: x_return_status := FND_API.G_RET_STS_ERROR ;
2128: FND_MSG_PUB.Count_And_Get(
2129: p_count => x_msg_count,

Line 2127: x_return_status := FND_API.G_RET_STS_ERROR ;

2123: p_count => x_msg_count,
2124: p_data => x_msg_data);
2125: WHEN FND_API.G_EXC_ERROR THEN
2126: ROLLBACK TO createSRAutoNotification_spt;
2127: x_return_status := FND_API.G_RET_STS_ERROR ;
2128: FND_MSG_PUB.Count_And_Get(
2129: p_count => x_msg_count,
2130: p_data => x_msg_data);
2131:

Line 2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2128: FND_MSG_PUB.Count_And_Get(
2129: p_count => x_msg_count,
2130: p_data => x_msg_data);
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133: ROLLBACK TO createSRAutoNotification_spt;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2135: FND_MSG_PUB.Count_And_Get(
2136: p_count => x_msg_count,

Line 2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2130: p_data => x_msg_data);
2131:
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133: ROLLBACK TO createSRAutoNotification_spt;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2135: FND_MSG_PUB.Count_And_Get(
2136: p_count => x_msg_count,
2137: p_data => x_msg_data);
2138:

Line 2141: x_return_status := FND_API.G_RET_STS_ERROR;

2137: p_data => x_msg_data);
2138:
2139: WHEN OTHERS THEN
2140: ROLLBACK TO createSRAutoNotification_spt;
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2143: THEN
2144: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2145: END IF;