22: -- 21-May-2001 msista Modified to work better.
23:
24: -- 09-Jul-2001 gpagadal Removed Dialing Method.
25:
26: -- 20-Jul-2001 gpagadal fnd_msg_pub.delete_msg() added.
27:
28: -- 02-Aug-2001 gpagadal Fields added.
29:
30: --
152: BEGIN
153:
154:
155:
156: fnd_msg_pub.delete_msg();
157:
158:
159:
160: -- Standard Start of API savepoint
286: COMMIT;
287:
288: ELSE
289:
290: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
291:
292: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
293:
294: x_msg_data := x_msg_data || ',' || l_msg_data;
288: ELSE
289:
290: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
291:
292: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
293:
294: x_msg_data := x_msg_data || ',' || l_msg_data;
295:
296: END LOOP;
304: EXCEPTION
305:
306: WHEN OTHERS THEN
307:
308: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
309:
310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
311:
312: x_msg_data := x_msg_data || ',' || l_msg_data;
306: WHEN OTHERS THEN
307:
308: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
309:
310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
311:
312: x_msg_data := x_msg_data || ',' || l_msg_data;
313:
314: END LOOP;
424: BEGIN
425:
426:
427:
428: fnd_msg_pub.delete_msg();
429:
430:
431:
432: -- Standard Start of API savepoint
508:
509:
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
511:
512: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
513:
514: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
515:
516: x_msg_data := x_msg_data || ',' || l_msg_data;
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
511:
512: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
513:
514: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
515:
516: x_msg_data := x_msg_data || ',' || l_msg_data;
517:
518: END LOOP;
534: EXCEPTION
535:
536: WHEN OTHERS THEN
537:
538: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
539:
540: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
541:
542: x_msg_data := x_msg_data || ',' || l_msg_data;
536: WHEN OTHERS THEN
537:
538: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
539:
540: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
541:
542: x_msg_data := x_msg_data || ',' || l_msg_data;
543:
544: END LOOP;
650: BEGIN
651:
652:
653:
654: fnd_msg_pub.delete_msg();
655:
656:
657:
658:
754: COMMIT;
755:
756: ELSE
757:
758: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
759:
760: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
761:
762: x_msg_data := x_msg_data || ',' || l_msg_data;
756: ELSE
757:
758: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
759:
760: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
761:
762: x_msg_data := x_msg_data || ',' || l_msg_data;
763:
764: END LOOP;
774:
775:
776: WHEN OTHERS THEN
777:
778: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
779:
780: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
781:
782: x_msg_data := x_msg_data || ',' || l_msg_data;
776: WHEN OTHERS THEN
777:
778: FOR i in 1..fnd_msg_pub.COUNT_MSG() LOOP
779:
780: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
781:
782: x_msg_data := x_msg_data || ',' || l_msg_data;
783:
784: END LOOP;