62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: COMMIT;
135:
136:
137: -- Standard call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get
139: (p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142:
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: -- Standard call to get message count and if count=1, get the message
148: FND_msg_PUB.Count_And_Get (
149: -- p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: /* FOR l_counter IN 1 .. x_msg_count
158: LOOP
159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
160: fnd_msg_pub.dump_msg(l_counter);
161: end loop; */
162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156:
157: /* FOR l_counter IN 1 .. x_msg_count
158: LOOP
159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
160: fnd_msg_pub.dump_msg(l_counter);
161: end loop; */
162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
161: end loop; */
162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_msg_PUB.Count_And_Get (
166: --p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
169: );
170:
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
174: THEN
175: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
176: END IF;
177: -- Standard call to get message count and if count=1, get the message
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
174: THEN
175: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
176: END IF;
177: -- Standard call to get message count and if count=1, get the message
178: FND_msg_PUB.Count_And_Get (
179: -- p_encoded => FND_API.G_FALSE,
174: THEN
175: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
176: END IF;
177: -- Standard call to get message count and if count=1, get the message
178: FND_msg_PUB.Count_And_Get (
179: -- p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );
236:
237: -- Initialize message list if p_init_msg_list is set to TRUE.
238: IF FND_API.to_Boolean( p_init_msg_list )
239: THEN
240: FND_msg_PUB.initialize;
241: END IF;
242:
243: -- Initialize API return status to SUCCESS
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_msg_PUB.Count_And_Get (
784: -- p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
792:
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794:
795: -- Standard call to get message count and if count=1, get the message
796: FND_msg_PUB.Count_And_Get (
797: --p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
804: WHEN OTHERS THEN
805:
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
809: THEN
810: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
811: END IF;
812:
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
809: THEN
810: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
811: END IF;
812:
813: -- Standard call to get message count and if count=1, get the message
814: FND_msg_PUB.Count_And_Get (
810: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
811: END IF;
812:
813: -- Standard call to get message count and if count=1, get the message
814: FND_msg_PUB.Count_And_Get (
815: -- p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );
871:
872: -- Initialize message list if p_init_msg_list is set to TRUE.
873: IF FND_API.to_Boolean( p_init_msg_list )
874: THEN
875: FND_msg_PUB.initialize;
876: END IF;
877:
878: -- Initialize API return status to SUCCESS
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_msg_PUB.Count_And_Get (
1526: -- p_encoded => FND_API.G_FALSE,
1527: p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: -- Standard call to get message count and if count=1, get the message
1538: FND_msg_PUB.Count_And_Get (
1539: --p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );
1546: WHEN OTHERS THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549:
1550: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1551: THEN
1552: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1553: END IF;
1554:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549:
1550: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1551: THEN
1552: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1553: END IF;
1554:
1555: -- Standard call to get message count and if count=1, get the message
1556: FND_msg_PUB.Count_And_Get (
1552: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1553: END IF;
1554:
1555: -- Standard call to get message count and if count=1, get the message
1556: FND_msg_PUB.Count_And_Get (
1557: -- p_encoded => FND_API.G_FALSE,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );