164: EXCEPTION
165: WHEN OTHERS THEN
166: X_return_code := SQLCODE;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
169: END;
170: /* Bug No.6788488 - End */
171:
172: ELSIF p_object_type = 'G' then
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: X_return_code := SQLCODE;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: X_return_code := SQLCODE;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: X_return_code := SQLCODE;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
194:
195: WHEN OTHERS THEN
196: X_return_code := SQLCODE;
197: x_return_status := FND_API.G_RET_STS_ERROR;
194:
195: WHEN OTHERS THEN
196: X_return_code := SQLCODE;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
199:
200: END ;
201:
202: