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_MSG_PUB

Line 102: FND_MSG_PUB.initialize;

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

Line 229: FND_MSG_PUB.Count_And_Get

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

Line 237: FND_MSG_PUB.Count_And_Get(

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

Line 244: FND_MSG_PUB.Count_And_Get(

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
248: ROLLBACK TO createOutboxMessage_pvt;

Line 251: FND_MSG_PUB.ADD;

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,
254: p_count => x_msg_count,
255: p_data => x_msg_data);

Line 252: FND_MSG_PUB.Count_And_Get(

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,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN OTHERS THEN

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

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

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

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;
263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
264: p_data => x_msg_data);
265:

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

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;
263: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
264: p_data => x_msg_data);
265:
266: END createOutboxMessage;
267:

Line 307: FND_MSG_PUB.initialize;

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

Line 340: FND_MSG_PUB.Count_And_Get(

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

Line 347: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
358: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
359: p_data => x_msg_data);
360:

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

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;
358: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
359: p_data => x_msg_data);
360:
361: END cancelOutboxMessage;
362:

Line 410: FND_MSG_PUB.initialize;

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

Line 460: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 561: FND_MSG_PUB.Count_And_Get(

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

Line 568: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
579: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
580: p_data => x_msg_data);
581:

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

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;
579: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
580: p_data => x_msg_data);
581:
582: END writeOutboxError;
583:

Line 656: FND_MSG_PUB.initialize;

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

Line 850: FND_MSG_PUB.Count_And_Get

846: COMMIT WORK;
847: END IF;
848:
849: -- Standard callto get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: EXCEPTION

Line 858: FND_MSG_PUB.Count_And_Get(

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

Line 865: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
876: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
877: p_data => x_msg_data);
878:

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

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;
876: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
877: p_data => x_msg_data);
878:
879: END createAutoReply;
880:

Line 913: FND_MSG_PUB.initialize;

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:
916: x_return_status := fnd_api.g_ret_sts_success;
917:

Line 948: FND_MSG_PUB.Count_And_Get(

944: COMMIT WORK;
945: END IF;
946:
947: -- Standard call to get message count and if count is 1, get message info.
948: FND_MSG_PUB.Count_And_Get(
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );
952:

Line 958: FND_MSG_PUB.Count_And_Get(

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: );
962:

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

960: p_data => x_msg_data
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:

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

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
976: );

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

974: p_count => x_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:

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

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
990: );
991:

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

988: p_count => x_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:

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

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:
1035: x_return_status := fnd_api.g_ret_sts_success;
1036:

Line 1069: FND_MSG_PUB.Count_And_Get(

1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info.
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,
1071: p_data => x_msg_data
1072: );
1073:

Line 1079: FND_MSG_PUB.Count_And_Get(

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: );
1083:

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

1081: p_data => x_msg_data
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:

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

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
1097: );

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

1095: p_count => x_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:

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

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
1112: );
1113:

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

1110: p_count => x_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:

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

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:
1158: x_return_status := fnd_api.g_ret_sts_success;
1159:

Line 1216: FND_MSG_PUB.Count_And_Get(

1212: COMMIT WORK;
1213: END IF;
1214:
1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );
1220:

Line 1226: FND_MSG_PUB.Count_And_Get(

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: );
1230:

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

1228: p_data => x_msg_data
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:

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

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
1244: );

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

1242: p_count => x_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:

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

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
1258: );
1259:

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

1256: p_count => x_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:

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

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

Line 1350: FND_MSG_PUB.Count_And_Get(

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

Line 1357: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
1368: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1369: p_data => x_msg_data);
1370:

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

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;
1368: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1369: p_data => x_msg_data);
1370:
1371: END getAccountList;
1372:

Line 1419: FND_MSG_PUB.initialize;

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

Line 1482: FND_MSG_PUB.Count_And_Get

1478: COMMIT WORK;
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: );

Line 1493: FND_MSG_PUB.ADD;

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,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);

Line 1494: FND_MSG_PUB.Count_And_Get(

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,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:

Line 1502: FND_MSG_PUB.Count_And_Get(

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

Line 1509: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
1520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1521: p_data => x_msg_data);
1522:

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

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;
1520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1521: p_data => x_msg_data);
1522:
1523: END redirectMessage;
1524:

Line 1600: FND_MSG_PUB.initialize;

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

Line 1801: FND_MSG_PUB.Count_And_Get

1797: COMMIT WORK;
1798: END IF;
1799:
1800: -- Standard callto get message count and if count is 1, get message info.
1801: FND_MSG_PUB.Count_And_Get
1802: ( p_count => x_msg_count,
1803: p_data => x_msg_data
1804: );
1805: EXCEPTION

Line 1809: FND_MSG_PUB.Count_And_Get(

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

Line 1816: FND_MSG_PUB.Count_And_Get(

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
1820: ROLLBACK TO autoForward_pvt;

Line 1823: FND_MSG_PUB.ADD;

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,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);

Line 1824: FND_MSG_PUB.Count_And_Get(

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,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828: WHEN OTHERS THEN

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

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

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

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;
1835: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1836: p_data => x_msg_data);
1837:

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

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;
1835: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1836: p_data => x_msg_data);
1837:
1838: END autoForward;
1839:

Line 1910: FND_MSG_PUB.initialize;

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

Line 2112: FND_MSG_PUB.Count_And_Get

2108: COMMIT WORK;
2109: END IF;
2110:
2111: -- Standard callto get message count and if count is 1, get message info.
2112: FND_MSG_PUB.Count_And_Get
2113: ( p_count => x_msg_count,
2114: p_data => x_msg_data
2115: );
2116: EXCEPTION

Line 2121: FND_MSG_PUB.ADD;

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,
2124: p_data => x_msg_data);
2125: WHEN FND_API.G_EXC_ERROR THEN

Line 2122: FND_MSG_PUB.Count_And_Get(

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,
2124: p_data => x_msg_data);
2125: WHEN FND_API.G_EXC_ERROR THEN
2126: ROLLBACK TO createSRAutoNotification_spt;

Line 2128: FND_MSG_PUB.Count_And_Get(

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

Line 2135: FND_MSG_PUB.Count_And_Get(

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

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

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

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

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;
2146: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2147: p_data => x_msg_data);
2148: END createSRAutoNotification;

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

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;
2146: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2147: p_data => x_msg_data);
2148: END createSRAutoNotification;
2149:
2150: