207: x_return_status := Fnd_Api.G_RET_STS_ERROR;
208: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
210: p_data => x_msg_data);
211: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
212: THEN
213: Fnd_Log.STRING(Fnd_Log.level_error,
214: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
215: 'EXC_ERROR[' || x_msg_data || ']');
209: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
210: p_data => x_msg_data);
211: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)
212: THEN
213: Fnd_Log.STRING(Fnd_Log.level_error,
214: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
215: 'EXC_ERROR[' || x_msg_data || ']');
216: END IF;
217:
219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
220: ROLLBACK TO UPDATE_LOGISTICS_LINE_PUB;
221: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
222: p_data => x_msg_data);
223: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
224: THEN
225: Fnd_Log.STRING(Fnd_Log.level_exception,
226: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
227: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
221: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
222: p_data => x_msg_data);
223: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
224: THEN
225: Fnd_Log.STRING(Fnd_Log.level_exception,
226: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
227: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
228: END IF;
229: WHEN OTHERS THEN
234: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
235: END IF;
236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
237: p_data => x_msg_data);
238: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
239: THEN
240: Fnd_Log.STRING(Fnd_Log.level_exception,
241: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
242: 'SQL MEssage[' || SQLERRM || ']');
236: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
237: p_data => x_msg_data);
238: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)
239: THEN
240: Fnd_Log.STRING(Fnd_Log.level_exception,
241: 'csd.plsql.csd_logistics_pub.update_logistics_pub',
242: 'SQL MEssage[' || SQLERRM || ']');
243: END IF;
244: