256: EXCEPTION
257: WHEN OTHERS THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: restore_context(l_orig_acc_mode, l_orig_org_id);
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
263: END IF;
264: FND_MSG_PUB.count_and_get
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: restore_context(l_orig_acc_mode, l_orig_org_id);
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
263: END IF;
264: FND_MSG_PUB.count_and_get
265: (
266: p_count => l_msg_count ,
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
263: END IF;
264: FND_MSG_PUB.count_and_get
265: (
266: p_count => l_msg_count ,
267: p_data => l_msg_data ,
268: p_encoded => FND_API.g_false
489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: restore_context(l_orig_acc_mode, l_orig_org_id);
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: THEN
495: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
496: END IF;
497: FND_MSG_PUB.count_and_get
491: x_return_status := fnd_api.g_ret_sts_unexp_error;
492: restore_context(l_orig_acc_mode, l_orig_org_id);
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: THEN
495: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
496: END IF;
497: FND_MSG_PUB.count_and_get
498: (
499: p_count => l_msg_count ,
493: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: THEN
495: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
496: END IF;
497: FND_MSG_PUB.count_and_get
498: (
499: p_count => l_msg_count ,
500: p_data => l_msg_data ,
501: p_encoded => FND_API.g_false