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

Line 74: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

70: G_ACTIVE := 'Y';
71: G_DIR := 'asc';
72:
73: -- Standard call to check for call compatibility.
74: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
75: 1.0,
76: l_api_name,
77: G_PKG_NAME)
78: THEN

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: 1.0,
76: l_api_name,
77: G_PKG_NAME)
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )

Line 83: IF FND_API.to_Boolean( p_init_msg_list )

79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )
84: THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: -- Initialize API return status to SUCCESS
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: ----------------------code ------------------
92: if (p_sort_by = 'M') then
93:

Line 227: IF FND_API.To_Boolean(p_commit) THEN

223: END IF;
224:
225: --------------------------
226: -- Standard Check Of p_commit.
227: IF FND_API.To_Boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230: -- Standard callto get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get

Line 232: ( p_encoded => FND_API.G_TRUE,

228: COMMIT WORK;
229: END IF;
230: -- Standard callto get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: ( p_encoded => FND_API.G_TRUE,
233: p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: EXCEPTION

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: p_data => x_msg_data
235: );
236: EXCEPTION
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO getItemError_pvt;
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
242: p_count => x_msg_count,

Line 240: x_return_status := FND_API.G_RET_STS_ERROR ;

236: EXCEPTION
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO getItemError_pvt;
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
242: p_count => x_msg_count,
243: p_data => x_msg_data);
244:

Line 241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

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

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
242: p_count => x_msg_count,
243: p_data => x_msg_data);
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: ROLLBACK TO getItemError_pvt;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
249: p_count => x_msg_count,

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: p_data => x_msg_data);
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: ROLLBACK TO getItemError_pvt;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:

Line 248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: ROLLBACK TO getItemError_pvt;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: WHEN OTHERS THEN

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: p_data => x_msg_data);
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO getItemError_pvt;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
258: END IF;

Line 259: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
258: END IF;
259: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
260: p_count => x_msg_count,
261: p_data => x_msg_data);
262:
263:

Line 291: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

287: l_api_name :='clearOutboxErrors';
288: l_api_version_number :=1.0;
289:
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
292: 1.0,
293: l_api_name,
294: G_PKG_NAME)
295: THEN

Line 296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

292: 1.0,
293: l_api_name,
294: G_PKG_NAME)
295: THEN
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: END IF;
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )

Line 300: IF FND_API.to_Boolean( p_init_msg_list )

296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: END IF;
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: -- Initialize API return status to SUCCESS
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: ----------------------code ------------------
309:
310: if ( p_rt_media_item_id_array.COUNT > 0 ) then

Line 321: IF FND_API.To_Boolean(p_commit) THEN

317: end if;
318: end if;
319: --------------------------
320: -- Standard Check Of p_commit.
321: IF FND_API.To_Boolean(p_commit) THEN
322: COMMIT WORK;
323: END IF;
324: -- Standard callto get message count and if count is 1, get message info.
325: FND_MSG_PUB.Count_And_Get

Line 326: ( p_encoded => FND_API.G_TRUE,

322: COMMIT WORK;
323: END IF;
324: -- Standard callto get message count and if count is 1, get message info.
325: FND_MSG_PUB.Count_And_Get
326: ( p_encoded => FND_API.G_TRUE,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: EXCEPTION

Line 332: WHEN FND_API.G_EXC_ERROR THEN

328: p_data => x_msg_data
329: );
330: EXCEPTION
331:
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO clearOutboxErrors_pvt;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
336: p_count => x_msg_count,

Line 334: x_return_status := FND_API.G_RET_STS_ERROR ;

330: EXCEPTION
331:
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO clearOutboxErrors_pvt;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
336: p_count => x_msg_count,
337: p_data => x_msg_data);
338:

Line 335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

331:
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO clearOutboxErrors_pvt;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
336: p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

335: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
336: p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO clearOutboxErrors_pvt;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
343: p_count => x_msg_count,

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

337: p_data => x_msg_data);
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO clearOutboxErrors_pvt;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
343: p_count => x_msg_count,
344: p_data => x_msg_data);
345:

Line 342: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO clearOutboxErrors_pvt;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
343: p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN OTHERS THEN

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: p_data => x_msg_data);
345:
346: WHEN OTHERS THEN
347: ROLLBACK TO clearOutboxErrors_pvt;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
352: END IF;

Line 353: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

349: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
352: END IF;
353: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
354: p_count => x_msg_count,
355: p_data => x_msg_data);
356:
357:

Line 383: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

379: --Init values
380: l_api_name :='purgeOutboxErrors';
381: l_api_version_number :=1.0;
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
384: 1.0,
385: l_api_name,
386: G_PKG_NAME)
387: THEN

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384: 1.0,
385: l_api_name,
386: G_PKG_NAME)
387: THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )

Line 392: IF FND_API.to_Boolean( p_init_msg_list )

388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Initialize API return status to SUCCESS
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:
400: ----------------------code ------------------
401: if ( p_rt_media_item_id_array.COUNT > 0 ) then
402: if ( p_rt_media_item_id_array(p_rt_media_item_id_array.FIRST).num = G_ALL ) then

Line 435: IF FND_API.To_Boolean(p_commit) THEN

431: end if;
432: end if;
433: --------------------------
434: -- Standard Check Of p_commit.
435: IF FND_API.To_Boolean(p_commit) THEN
436: COMMIT WORK;
437: END IF;
438: -- Standard callto get message count and if count is 1, get message info.
439: FND_MSG_PUB.Count_And_Get

Line 440: ( p_encoded => FND_API.G_TRUE,

436: COMMIT WORK;
437: END IF;
438: -- Standard callto get message count and if count is 1, get message info.
439: FND_MSG_PUB.Count_And_Get
440: ( p_encoded => FND_API.G_TRUE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );
444: EXCEPTION

Line 446: WHEN FND_API.G_EXC_ERROR THEN

442: p_data => x_msg_data
443: );
444: EXCEPTION
445:
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO purgeOutboxErrors_pvt;
448: x_return_status := FND_API.G_RET_STS_ERROR ;
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
450: p_count => x_msg_count,

Line 448: x_return_status := FND_API.G_RET_STS_ERROR ;

444: EXCEPTION
445:
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO purgeOutboxErrors_pvt;
448: x_return_status := FND_API.G_RET_STS_ERROR ;
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
450: p_count => x_msg_count,
451: p_data => x_msg_data);
452:

Line 449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

445:
446: WHEN FND_API.G_EXC_ERROR THEN
447: ROLLBACK TO purgeOutboxErrors_pvt;
448: x_return_status := FND_API.G_RET_STS_ERROR ;
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
450: p_count => x_msg_count,
451: p_data => x_msg_data);
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
450: p_count => x_msg_count,
451: p_data => x_msg_data);
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: ROLLBACK TO purgeOutboxErrors_pvt;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
457: p_count => x_msg_count,

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451: p_data => x_msg_data);
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: ROLLBACK TO purgeOutboxErrors_pvt;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
457: p_count => x_msg_count,
458: p_data => x_msg_data);
459:

Line 456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: ROLLBACK TO purgeOutboxErrors_pvt;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
457: p_count => x_msg_count,
458: p_data => x_msg_data);
459:
460: WHEN OTHERS THEN

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458: p_data => x_msg_data);
459:
460: WHEN OTHERS THEN
461: ROLLBACK TO purgeOutboxErrors_pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
466: END IF;

Line 467: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
466: END IF;
467: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
468: p_count => x_msg_count,
469: p_data => x_msg_data);
470:
471: end;

Line 526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

522: l_api_name :='getOpItem';
523: l_api_version_number :=1.0;
524:
525: -- Standard call to check for call compatibility.
526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
527: 1.0,
528: l_api_name,
529: G_PKG_NAME)
530: THEN

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 535: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: -- Initialize API return status to SUCCESS
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: ----------------------code ------------------
544: select rt_interaction_id, resource_id, message_id, media_id,
545: to_char(creation_date, DATE_FORMAT), status

Line 677: IF FND_API.To_Boolean(p_commit) THEN

673:
674:
675: --------------------------
676: -- Standard Check Of p_commit.
677: IF FND_API.To_Boolean(p_commit) THEN
678: COMMIT WORK;
679: END IF;
680: -- Standard callto get message count and if count is 1, get message info.
681: FND_MSG_PUB.Count_And_Get

Line 682: ( p_encoded => FND_API.G_TRUE,

678: COMMIT WORK;
679: END IF;
680: -- Standard callto get message count and if count is 1, get message info.
681: FND_MSG_PUB.Count_And_Get
682: ( p_encoded => FND_API.G_TRUE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
685: );
686: EXCEPTION

Line 688: WHEN FND_API.G_EXC_ERROR THEN

684: p_data => x_msg_data
685: );
686: EXCEPTION
687:
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO getOpItem_pvt;
690: x_return_status := FND_API.G_RET_STS_ERROR ;
691: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
692: p_count => x_msg_count,

Line 690: x_return_status := FND_API.G_RET_STS_ERROR ;

686: EXCEPTION
687:
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO getOpItem_pvt;
690: x_return_status := FND_API.G_RET_STS_ERROR ;
691: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
692: p_count => x_msg_count,
693: p_data => x_msg_data);
694:

Line 691: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

687:
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO getOpItem_pvt;
690: x_return_status := FND_API.G_RET_STS_ERROR ;
691: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
692: p_count => x_msg_count,
693: p_data => x_msg_data);
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

691: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
692: p_count => x_msg_count,
693: p_data => x_msg_data);
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: ROLLBACK TO getOpItem_pvt;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
699: p_count => x_msg_count,

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

693: p_data => x_msg_data);
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: ROLLBACK TO getOpItem_pvt;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
699: p_count => x_msg_count,
700: p_data => x_msg_data);
701:

Line 698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: ROLLBACK TO getOpItem_pvt;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
699: p_count => x_msg_count,
700: p_data => x_msg_data);
701:
702: WHEN OTHERS THEN

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: p_data => x_msg_data);
701:
702: WHEN OTHERS THEN
703: ROLLBACK TO getOpItem_pvt;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
708: END IF;

Line 709: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
708: END IF;
709: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
710: p_count => x_msg_count,
711: p_data => x_msg_data);
712:
713: end;

Line 750: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

746: -- Standard Start of API savepoint
747: SAVEPOINT getThreadStatus_pvt;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
751: 1.0,
752: l_api_name,
753: G_PKG_NAME)
754: THEN

Line 755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

751: 1.0,
752: l_api_name,
753: G_PKG_NAME)
754: THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )

Line 759: IF FND_API.to_Boolean( p_init_msg_list )

755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )
760: THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:

Line 765: x_return_status := FND_API.G_RET_STS_SUCCESS;

761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: -- Initialize API return status to SUCCESS
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:
767: ----------------------code ------------------
768:
769: select a.CONTROLLER_ID, a.JSERV_ID, a.JSERV_PORT,

Line 789: IF FND_API.To_Boolean(p_commit) THEN

785:
786:
787: --------------------------
788: -- Standard Check Of p_commit.
789: IF FND_API.To_Boolean(p_commit) THEN
790: COMMIT WORK;
791: END IF;
792: -- Standard callto get message count and if count is 1, get message info.
793: FND_MSG_PUB.Count_And_Get

Line 794: ( p_encoded => FND_API.G_TRUE,

790: COMMIT WORK;
791: END IF;
792: -- Standard callto get message count and if count is 1, get message info.
793: FND_MSG_PUB.Count_And_Get
794: ( p_encoded => FND_API.G_TRUE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798: EXCEPTION

Line 800: WHEN FND_API.G_EXC_ERROR THEN

796: p_data => x_msg_data
797: );
798: EXCEPTION
799:
800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO getThreadStatus_pvt;
802: x_return_status := FND_API.G_RET_STS_ERROR ;
803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
804: p_count => x_msg_count,

Line 802: x_return_status := FND_API.G_RET_STS_ERROR ;

798: EXCEPTION
799:
800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO getThreadStatus_pvt;
802: x_return_status := FND_API.G_RET_STS_ERROR ;
803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806:

Line 803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

799:
800: WHEN FND_API.G_EXC_ERROR THEN
801: ROLLBACK TO getThreadStatus_pvt;
802: x_return_status := FND_API.G_RET_STS_ERROR ;
803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO getThreadStatus_pvt;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
811: p_count => x_msg_count,

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

805: p_data => x_msg_data);
806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO getThreadStatus_pvt;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
811: p_count => x_msg_count,
812: p_data => x_msg_data);
813:

Line 810: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

806:
807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO getThreadStatus_pvt;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
810: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
811: p_count => x_msg_count,
812: p_data => x_msg_data);
813:
814: WHEN OTHERS THEN

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: p_data => x_msg_data);
813:
814: WHEN OTHERS THEN
815: ROLLBACK TO getThreadStatus_pvt;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
818: THEN
819: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
820: END IF;

Line 821: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

817: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
818: THEN
819: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
820: END IF;
821: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825:

Line 865: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

861: l_api_name :='pushbackToRework';
862: l_api_version_number :=1.0;
863:
864: -- Standard call to check for call compatibility.
865: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
866: 1.0,
867: l_api_name,
868: G_PKG_NAME)
869: THEN

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: 1.0,
867: l_api_name,
868: G_PKG_NAME)
869: THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872:
873: -- Initialize message list if p_init_msg_list is set to TRUE.
874: IF FND_API.to_Boolean( p_init_msg_list )

Line 874: IF FND_API.to_Boolean( p_init_msg_list )

870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END IF;
872:
873: -- Initialize message list if p_init_msg_list is set to TRUE.
874: IF FND_API.to_Boolean( p_init_msg_list )
875: THEN
876: FND_MSG_PUB.initialize;
877: END IF;
878:

Line 880: x_return_status := FND_API.G_RET_STS_SUCCESS;

876: FND_MSG_PUB.initialize;
877: END IF;
878:
879: -- Initialize API return status to SUCCESS
880: x_return_status := FND_API.G_RET_STS_SUCCESS;
881:
882: ----------------------code ------------------
883: for i in p_rt_media_item_ids.first..p_rt_media_item_ids.last loop
884:

Line 913: p_init_msg_list => FND_API.G_FALSE,

909: and email_type = 'I';
910:
911: IEM_EMAIL_PROC_PVT. ReprocessAutoreply(
912: p_api_version_number => 1.0,
913: p_init_msg_list => FND_API.G_FALSE,
914: p_commit => FND_API.G_FALSE,
915: p_media_id => l_inb_media_id,
916: p_interaction_id => l_interaction_id,
917: p_customer_id => l_customer_id,

Line 914: p_commit => FND_API.G_FALSE,

910:
911: IEM_EMAIL_PROC_PVT. ReprocessAutoreply(
912: p_api_version_number => 1.0,
913: p_init_msg_list => FND_API.G_FALSE,
914: p_commit => FND_API.G_FALSE,
915: p_media_id => l_inb_media_id,
916: p_interaction_id => l_interaction_id,
917: p_customer_id => l_customer_id,
918: p_contact_id => l_contact_id,

Line 924: if ( l_status = FND_API.G_RET_STS_ERROR ) then

920: x_return_status => l_status,
921: x_msg_count => l_msg_count,
922: x_msg_data => l_msg_data);
923:
924: if ( l_status = FND_API.G_RET_STS_ERROR ) then
925: raise IEM_MDT_PROC_EX;
926: end if;
927:
928: update iem_rt_media_items set expire = G_EXPIRE

Line 971: IF FND_API.To_Boolean(p_commit) THEN

967: end loop;
968:
969: --------------------------
970: -- Standard Check Of p_commit.
971: IF FND_API.To_Boolean(p_commit) THEN
972: COMMIT WORK;
973: END IF;
974: -- Standard callto get message count and if count is 1, get message info.
975: FND_MSG_PUB.Count_And_Get

Line 976: ( p_encoded => FND_API.G_TRUE,

972: COMMIT WORK;
973: END IF;
974: -- Standard callto get message count and if count is 1, get message info.
975: FND_MSG_PUB.Count_And_Get
976: ( p_encoded => FND_API.G_TRUE,
977: p_count => x_msg_count,
978: p_data => x_msg_data
979: );
980: EXCEPTION

Line 984: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

980: EXCEPTION
981: WHEN IEM_MDT_PROC_EX THEN
982: ROLLBACK TO pushbackToRework_pvt;
983: x_return_status := l_status;
984: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
985: p_count => x_msg_count,
986: p_data => x_msg_data);
987:
988: WHEN FND_API.G_EXC_ERROR THEN

Line 988: WHEN FND_API.G_EXC_ERROR THEN

984: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
985: p_count => x_msg_count,
986: p_data => x_msg_data);
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: ROLLBACK TO pushbackToRework_pvt;
990: x_return_status := FND_API.G_RET_STS_ERROR ;
991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
992: p_count => x_msg_count,

Line 990: x_return_status := FND_API.G_RET_STS_ERROR ;

986: p_data => x_msg_data);
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: ROLLBACK TO pushbackToRework_pvt;
990: x_return_status := FND_API.G_RET_STS_ERROR ;
991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
992: p_count => x_msg_count,
993: p_data => x_msg_data);
994:

Line 991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: ROLLBACK TO pushbackToRework_pvt;
990: x_return_status := FND_API.G_RET_STS_ERROR ;
991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
992: p_count => x_msg_count,
993: p_data => x_msg_data);
994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
992: p_count => x_msg_count,
993: p_data => x_msg_data);
994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO pushbackToRework_pvt;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
999: p_count => x_msg_count,

Line 997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

993: p_data => x_msg_data);
994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO pushbackToRework_pvt;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
999: p_count => x_msg_count,
1000: p_data => x_msg_data);
1001:

Line 998: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO pushbackToRework_pvt;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
999: p_count => x_msg_count,
1000: p_data => x_msg_data);
1001:
1002: WHEN OTHERS THEN

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: p_data => x_msg_data);
1001:
1002: WHEN OTHERS THEN
1003: ROLLBACK TO pushbackToRework_pvt;
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1006: THEN
1007: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1008: END IF;

Line 1009: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

1005: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1006: THEN
1007: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1008: END IF;
1009: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1010: p_count => x_msg_count,
1011: p_data => x_msg_data);
1012:
1013: