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.IEX_CASE_INFO_PUB dependencies on FND_MSG_PUB

Line 129: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

125:
126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
130: if PG_DEBUG < 10 then
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
133: END IF;

Line 138: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

134: end if;
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
139: if PG_DEBUG < 10 then
140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
141: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
142: END IF;

Line 147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

143: end if;
144:
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
148: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
151: if PG_DEBUG < 10 then

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

144:
145: WHEN OTHERS THEN
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
148: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
151: if PG_DEBUG < 10 then
152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 150: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
148: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
149: END IF;
150: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
151: if PG_DEBUG < 10 then
152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
153: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
154: END IF;

Line 250: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
251: if PG_DEBUG < 10 then
252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
253: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
254: END IF;

Line 259: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

255: end if;
256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
260: if PG_DEBUG < 10 then
261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
262: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
263: END IF;

Line 268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

264: end if;
265:
266: WHEN OTHERS THEN
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
272: if PG_DEBUG < 10 then

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

265:
266: WHEN OTHERS THEN
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
272: if PG_DEBUG < 10 then
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 271: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
270: END IF;
271: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
272: if PG_DEBUG < 10 then
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
275: END IF;

Line 353: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

349:
350: EXCEPTION
351: WHEN FND_API.G_EXC_ERROR THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
354: if PG_DEBUG < 10 then
355: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
356: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
357: END IF;

Line 362: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

358: end if;
359:
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
363: if PG_DEBUG < 10 then
364: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
365: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
366: END IF;

Line 371: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

367: end if;
368:
369: WHEN OTHERS THEN
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
372: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
373: END IF;
374: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
375: if PG_DEBUG < 10 then

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

368:
369: WHEN OTHERS THEN
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
372: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
373: END IF;
374: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
375: if PG_DEBUG < 10 then
376: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 374: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
372: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
373: END IF;
374: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
375: if PG_DEBUG < 10 then
376: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
377: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
378: END IF;

Line 458: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

454:
455: EXCEPTION
456: WHEN FND_API.G_EXC_ERROR THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
459: if PG_DEBUG < 10 then
460: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
461: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
462: END IF;

Line 467: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

463: end if;
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
468: if PG_DEBUG < 10 then
469: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
470: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
471: END IF;

Line 476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

472: end if;
473:
474: WHEN OTHERS THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: if PG_DEBUG < 10 then

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

473:
474: WHEN OTHERS THEN
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: if PG_DEBUG < 10 then
481: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
477: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
478: END IF;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: if PG_DEBUG < 10 then
481: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
482: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
483: END IF;

Line 559: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
560: if PG_DEBUG < 10 then
561: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
562: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
563: END IF;

Line 568: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

564: end if;
565:
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
569: if PG_DEBUG < 10 then
570: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
571: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
572: END IF;

Line 577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

573: end if;
574:
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
578: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
579: END IF;
580: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
581: if PG_DEBUG < 10 then

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

574:
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
578: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
579: END IF;
580: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
581: if PG_DEBUG < 10 then
582: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 580: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
578: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
579: END IF;
580: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
581: if PG_DEBUG < 10 then
582: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
583: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
584: END IF;

Line 661: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

657:
658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
662: if PG_DEBUG < 10 then
663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
664: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
665: END IF;

Line 670: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

666: end if;
667:
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
671: if PG_DEBUG < 10 then
672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
674: END IF;

Line 679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

675: end if;
676:
677: WHEN OTHERS THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
681: END IF;
682: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
683: if PG_DEBUG < 10 then

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

676:
677: WHEN OTHERS THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
681: END IF;
682: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
683: if PG_DEBUG < 10 then
684: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 682: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
681: END IF;
682: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
683: if PG_DEBUG < 10 then
684: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
685: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
686: END IF;

Line 763: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_ERROR;
763: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
764: if PG_DEBUG < 10 then
765: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
766: IEX_DEBUG_PUB.LogMessage('Exec Error ' || sqlerrm);
767: END IF;

Line 772: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

768: end if;
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
773: if PG_DEBUG < 10 then
774: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
775: IEX_DEBUG_PUB.LogMessage('Unexec Error ' || sqlerrm);
776: END IF;

Line 781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

777: end if;
778:
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
783: END IF;
784: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
785: if PG_DEBUG < 10 then

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

778:
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
783: END IF;
784: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
785: if PG_DEBUG < 10 then
786: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 784: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
782: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
783: END IF;
784: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
785: if PG_DEBUG < 10 then
786: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
787: IEX_DEBUG_PUB.LogMessage('Other Error ' || sqlerrm);
788: END IF;