DBA Data[Home] [Help]

APPS.IEM_MSG_STAT_PUB dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.initialize;

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:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 118: FND_MSG_PUB.Count_And_Get

114: COMMIT WORK;
115: END IF;
116:
117: -- Standard callto get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
122: EXCEPTION

Line 126: FND_MSG_PUB.Count_And_Get(

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:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 133: FND_MSG_PUB.Count_And_Get(

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
137: ROLLBACK TO createMSGStat_pvt;

Line 139: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
143: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 141: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
143: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
144: p_data => x_msg_data);
145:

Line 143: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
143: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
144: p_data => x_msg_data);
145:
146: END createMSGStat;
147:

Line 201: FND_MSG_PUB.initialize;

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:
204: -- Initialize API return status to SUCCESS
205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: FND_MSG_PUB.Count_And_Get(

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:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 282: FND_MSG_PUB.Count_And_Get(

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:
286: WHEN OTHERS THEN

Line 289: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 291: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
294: p_data => x_msg_data);
295:

Line 293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
294: p_data => x_msg_data);
295:
296: END sendMSGStat;
297:

Line 344: FND_MSG_PUB.initialize;

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:
347: -- Initialize API return status to SUCCESS
348: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 377: FND_MSG_PUB.Count_And_Get(

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
381: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

Line 380: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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
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:

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 388: FND_MSG_PUB.Count_And_Get(

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
392: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

Line 391: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

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
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:

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 399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
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

Line 403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
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;

Line 405: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP

401: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
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:

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 459: FND_MSG_PUB.initialize;

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:
462: -- Initialize API return status to SUCCESS
463: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 493: FND_MSG_PUB.Count_And_Get(

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:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 500: FND_MSG_PUB.Count_And_Get(

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:
504: WHEN OTHERS THEN

Line 507: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 509: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
512: p_data => x_msg_data);
513:

Line 511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
512: p_data => x_msg_data);
513:
514: END cancelMSGStat;
515:

Line 562: FND_MSG_PUB.initialize;

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:
565: -- Initialize API return status to SUCCESS
566: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 597: FND_MSG_PUB.Count_And_Get

593: COMMIT WORK;
594: END IF;
595:
596: -- Standard callto get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get
598: ( p_count => x_msg_count,
599: p_data => x_msg_data
600: );
601: EXCEPTION

Line 605: FND_MSG_PUB.Count_And_Get(

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:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 612: FND_MSG_PUB.Count_And_Get(

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:
616: WHEN OTHERS THEN

Line 619: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
623: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 621: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
623: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
624: p_data => x_msg_data);
625:

Line 623: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
623: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
624: p_data => x_msg_data);
625:
626: END saveMSGStat;
627:

Line 699: FND_MSG_PUB.initialize;

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:
702: -- Initialize API return status to SUCCESS
703: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 817: FND_MSG_PUB.Count_And_Get

813: COMMIT WORK;
814: END IF;
815:
816: -- Standard callto get message count and if count is 1, get message info.
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821: EXCEPTION

Line 825: FND_MSG_PUB.Count_And_Get(

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:
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 832: FND_MSG_PUB.Count_And_Get(

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:
836: WHEN OTHERS THEN

Line 839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
843: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 841: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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;
843: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
844: p_data => x_msg_data);
845:

Line 843: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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;
843: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
844: p_data => x_msg_data);
845:
846: END insertDocUsageStat;
847: