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

Line 47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

43: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
44: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
48: 1.0,
49: l_api_name,
50: G_PKG_NAME)
51: THEN

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 56: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: -----------------------Code------------------------
65: select iem_outbound_msg_stats_s1.nextval into l_i_sequence from dual;
66:

Line 113: IF FND_API.To_Boolean(p_commit) THEN

109: );
110:
111: -------------------End Code------------------------
112: -- Standard Check Of p_commit.
113: IF FND_API.To_Boolean(p_commit) THEN
114: COMMIT WORK;
115: END IF;
116:
117: -- Standard callto get message count and if count is 1, get message info.

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO createMSGStat_pvt;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,

Line 125: x_return_status := FND_API.G_RET_STS_ERROR ;

121: );
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO createMSGStat_pvt;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,
128: p_data => x_msg_data);
129:

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,
128: p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO createMSGStat_pvt;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: FND_MSG_PUB.Count_And_Get(
134: p_count => x_msg_count,

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

128: p_data => x_msg_data);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO createMSGStat_pvt;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: FND_MSG_PUB.Count_And_Get(
134: p_count => x_msg_count,
135: p_data => x_msg_data);
136: WHEN OTHERS THEN

Line 138: x_return_status := FND_API.G_RET_STS_ERROR;

134: p_count => x_msg_count,
135: p_data => x_msg_data);
136: WHEN OTHERS THEN
137: ROLLBACK TO createMSGStat_pvt;
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
142: END IF;

Line 190: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

186: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
187: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
188:
189: -- Standard call to check for call compatibility.
190: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
191: 1.0,
192: l_api_name,
193: G_PKG_NAME)
194: THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: 1.0,
192: l_api_name,
193: G_PKG_NAME)
194: THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )

Line 199: IF FND_API.to_Boolean( p_init_msg_list )

195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Initialize API return status to SUCCESS
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: -----------------------Code------------------------
208: l_outBoundMethod := p_outBoundMethod;
209: BEGIN

Line 267: IF FND_API.To_Boolean(p_commit) THEN

263: LAST_UPDATE_LOGIN = l_last_update_login
264: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
265: -------------------End Code------------------------
266: -- Standard Check Of p_commit.
267: IF FND_API.To_Boolean(p_commit) THEN
268: COMMIT WORK;
269: END IF;
270:
271: EXCEPTION

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: COMMIT WORK;
269: END IF;
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO sendMSGStat_pvt;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get(
276: p_count => x_msg_count,

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO sendMSGStat_pvt;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get(
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: FND_MSG_PUB.Count_And_Get(
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO sendMSGStat_pvt;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282: FND_MSG_PUB.Count_And_Get(
283: p_count => x_msg_count,

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO sendMSGStat_pvt;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282: FND_MSG_PUB.Count_And_Get(
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: p_data => x_msg_data);
285:
286: WHEN OTHERS THEN
287: ROLLBACK TO sendMSGStat_pvt;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
292: END IF;

Line 333: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

329: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
330: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
331:
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
334: 1.0,
335: l_api_name,
336: G_PKG_NAME)
337: THEN

Line 338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

334: 1.0,
335: l_api_name,
336: G_PKG_NAME)
337: THEN
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean( p_init_msg_list )

Line 342: IF FND_API.to_Boolean( p_init_msg_list )

338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean( p_init_msg_list )
343: THEN
344: FND_MSG_PUB.initialize;
345: END IF;
346:

Line 348: x_return_status := FND_API.G_RET_STS_SUCCESS;

344: FND_MSG_PUB.initialize;
345: END IF;
346:
347: -- Initialize API return status to SUCCESS
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350: -----------------------Code------------------------
351: BEGIN
352: IF (p_outBoundMediaID > 0) THEN

Line 369: IF FND_API.To_Boolean(p_commit) THEN

365: DELETE FROM IEM_OUTBOUND_MSG_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
366:
367: -------------------End Code------------------------
368: -- Standard Check Of p_commit.
369: IF FND_API.To_Boolean(p_commit) THEN
370: COMMIT WORK;
371: END IF;
372:
373: EXCEPTION

Line 374: WHEN FND_API.G_EXC_ERROR THEN

370: COMMIT WORK;
371: END IF;
372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO deleteMSGStat_pvt;
376: x_return_status := FND_API.G_RET_STS_ERROR ;
377: FND_MSG_PUB.Count_And_Get(
378: p_count => x_msg_count,

Line 376: x_return_status := FND_API.G_RET_STS_ERROR ;

372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO deleteMSGStat_pvt;
376: x_return_status := FND_API.G_RET_STS_ERROR ;
377: FND_MSG_PUB.Count_And_Get(
378: p_count => x_msg_count,
379: p_data => x_msg_data);
380: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

377: FND_MSG_PUB.Count_And_Get(
378: p_count => x_msg_count,
379: p_data => x_msg_data);
380: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
381: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
382: x_msg_data := x_msg_data || ',' || l_msg_data;
383: END LOOP;
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

381: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
382: x_msg_data := x_msg_data || ',' || l_msg_data;
383: END LOOP;
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO deleteMSGStat_pvt;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.Count_And_Get(
389: p_count => x_msg_count,

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

383: END LOOP;
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO deleteMSGStat_pvt;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.Count_And_Get(
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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

388: FND_MSG_PUB.Count_And_Get(
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
392: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
393: x_msg_data := x_msg_data || ',' || l_msg_data;
394: END LOOP;
395:
396: WHEN OTHERS THEN

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: END LOOP;
395:
396: WHEN OTHERS THEN
397: ROLLBACK TO deleteMSGStat_pvt;
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
402: END IF;

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

402: END IF;
403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
404: p_data => x_msg_data);
405: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
406: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
407: x_msg_data := x_msg_data || ',' || l_msg_data;
408: END LOOP;
409:
410: END deleteMSGStat;

Line 448: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

444: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
445: l_yes := 'Y';
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
449: 1.0,
450: l_api_name,
451: G_PKG_NAME)
452: THEN

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: 1.0,
450: l_api_name,
451: G_PKG_NAME)
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: -- Initialize message list if p_init_msg_list is set to TRUE.
457: IF FND_API.to_Boolean( p_init_msg_list )

Line 457: IF FND_API.to_Boolean( p_init_msg_list )

453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: -- Initialize message list if p_init_msg_list is set to TRUE.
457: IF FND_API.to_Boolean( p_init_msg_list )
458: THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:

Line 463: x_return_status := FND_API.G_RET_STS_SUCCESS;

459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: -- Initialize API return status to SUCCESS
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: -----------------------Code------------------------
466:
467: BEGIN

Line 485: IF FND_API.To_Boolean(p_commit) THEN

481: AND SAVED_Y_N <> l_yes;
482:
483: -------------------End Code------------------------
484: -- Standard Check Of p_commit.
485: IF FND_API.To_Boolean(p_commit) THEN
486: COMMIT WORK;
487: END IF;
488:
489: EXCEPTION

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: COMMIT WORK;
487: END IF;
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO cancelMSGStat_pvt;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: FND_MSG_PUB.Count_And_Get(
494: p_count => x_msg_count,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR ;

488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO cancelMSGStat_pvt;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: FND_MSG_PUB.Count_And_Get(
494: p_count => x_msg_count,
495: p_data => x_msg_data);
496:

Line 497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

493: FND_MSG_PUB.Count_And_Get(
494: p_count => x_msg_count,
495: p_data => x_msg_data);
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO cancelMSGStat_pvt;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500: FND_MSG_PUB.Count_And_Get(
501: p_count => x_msg_count,

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

495: p_data => x_msg_data);
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO cancelMSGStat_pvt;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500: FND_MSG_PUB.Count_And_Get(
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503:

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: p_data => x_msg_data);
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO cancelMSGStat_pvt;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
510: END IF;

Line 551: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

547: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
548: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
552: 1.0,
553: l_api_name,
554: G_PKG_NAME)
555: THEN

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: 1.0,
553: l_api_name,
554: G_PKG_NAME)
555: THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- Initialize message list if p_init_msg_list is set to TRUE.
560: IF FND_API.to_Boolean( p_init_msg_list )

Line 560: IF FND_API.to_Boolean( p_init_msg_list )

556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- Initialize message list if p_init_msg_list is set to TRUE.
560: IF FND_API.to_Boolean( p_init_msg_list )
561: THEN
562: FND_MSG_PUB.initialize;
563: END IF;
564:

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562: FND_MSG_PUB.initialize;
563: END IF;
564:
565: -- Initialize API return status to SUCCESS
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: -----------------------Code------------------------
569: BEGIN
570: IF (p_outBoundMediaID > 0) THEN

Line 592: IF FND_API.To_Boolean(p_commit) THEN

588: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
589:
590: -------------------End Code------------------------
591: -- Standard Check Of p_commit.
592: IF FND_API.To_Boolean(p_commit) THEN
593: COMMIT WORK;
594: END IF;
595:
596: -- Standard callto get message count and if count is 1, get message info.

Line 602: WHEN FND_API.G_EXC_ERROR THEN

598: ( p_count => x_msg_count,
599: p_data => x_msg_data
600: );
601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK TO saveMSGStat_pvt;
604: x_return_status := FND_API.G_RET_STS_ERROR ;
605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,

Line 604: x_return_status := FND_API.G_RET_STS_ERROR ;

600: );
601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK TO saveMSGStat_pvt;
604: x_return_status := FND_API.G_RET_STS_ERROR ;
605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608:

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: FND_MSG_PUB.Count_And_Get(
606: p_count => x_msg_count,
607: p_data => x_msg_data);
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO saveMSGStat_pvt;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: FND_MSG_PUB.Count_And_Get(
613: p_count => x_msg_count,

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

607: p_data => x_msg_data);
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO saveMSGStat_pvt;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
612: FND_MSG_PUB.Count_And_Get(
613: p_count => x_msg_count,
614: p_data => x_msg_data);
615:

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614: p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
617: ROLLBACK TO saveMSGStat_pvt;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
620: THEN
621: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
622: END IF;

Line 688: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

684: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
685: l_uses_kb_docs_y_n := 'N';
686:
687: -- Standard call to check for call compatibility.
688: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
689: 1.0,
690: l_api_name,
691: G_PKG_NAME)
692: THEN

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689: 1.0,
690: l_api_name,
691: G_PKG_NAME)
692: THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695:
696: -- Initialize message list if p_init_msg_list is set to TRUE.
697: IF FND_API.to_Boolean( p_init_msg_list )

Line 697: IF FND_API.to_Boolean( p_init_msg_list )

693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695:
696: -- Initialize message list if p_init_msg_list is set to TRUE.
697: IF FND_API.to_Boolean( p_init_msg_list )
698: THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701:

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

699: FND_MSG_PUB.initialize;
700: END IF;
701:
702: -- Initialize API return status to SUCCESS
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704:
705: -----------------------Code------------------------
706: BEGIN
707: select rt_interaction_id into l_rt_interaction_id from iem_rt_media_items

Line 812: IF FND_API.To_Boolean(p_commit) THEN

808: LAST_UPDATE_LOGIN = l_last_update_login
809: WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
810: -------------------End Code------------------------
811: -- Standard Check Of p_commit.
812: IF FND_API.To_Boolean(p_commit) THEN
813: COMMIT WORK;
814: END IF;
815:
816: -- Standard callto get message count and if count is 1, get message info.

Line 822: WHEN FND_API.G_EXC_ERROR THEN

818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821: EXCEPTION
822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO insertDocUsageStat_pvt;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825: FND_MSG_PUB.Count_And_Get(
826: p_count => x_msg_count,

Line 824: x_return_status := FND_API.G_RET_STS_ERROR ;

820: );
821: EXCEPTION
822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO insertDocUsageStat_pvt;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825: FND_MSG_PUB.Count_And_Get(
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: FND_MSG_PUB.Count_And_Get(
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO insertDocUsageStat_pvt;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: FND_MSG_PUB.Count_And_Get(
833: p_count => x_msg_count,

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: ROLLBACK TO insertDocUsageStat_pvt;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: FND_MSG_PUB.Count_And_Get(
833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:

Line 838: x_return_status := FND_API.G_RET_STS_ERROR;

834: p_data => x_msg_data);
835:
836: WHEN OTHERS THEN
837: ROLLBACK TO insertDocUsageStat_pvt;
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
842: END IF;