76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.To_Boolean(p_init_msg_list) THEN
80: FND_MSG_PUB.Initialize;
81: END IF;
82:
83: -- Initialize Procedure return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: COMMIT WORK;
104: END IF;
105:
106: -- Standard call to get message count and if count is 1, get message info
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data,
110: p_encoded => fnd_api.g_false);
111:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_ERROR;
118: Rollback to Update_Utilization_Pub;
119: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
120: p_data => x_msg_data,
121: p_encoded => fnd_api.g_false);
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: Rollback to Update_Utilization_Pub;
126: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
127: p_data => x_msg_data,
128: p_encoded => fnd_api.g_false);
129:
130: WHEN OTHERS THEN
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: Rollback to Update_Utilization_Pub;
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
135: p_procedure_name => 'Update_Utilization',
136: p_error_text => SUBSTR(SQLERRM,1,240));
137: END IF;
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: Rollback to Update_Utilization_Pub;
133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
135: p_procedure_name => 'Update_Utilization',
136: p_error_text => SUBSTR(SQLERRM,1,240));
137: END IF;
138: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
134: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
135: p_procedure_name => 'Update_Utilization',
136: p_error_text => SUBSTR(SQLERRM,1,240));
137: END IF;
138: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
139: p_data => x_msg_data,
140: p_encoded => fnd_api.g_false);
141:
142: END Update_Utilization;