51: --Standard start of API savepoint
52: SAVEPOINT update_bod_pvt;
53:
54: -- Debug info.
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'update_bod (+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
54: -- Debug info.
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'update_bod (+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
60:
61: --Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean(p_init_msg_list) THEN
170: p_count => x_msg_count,
171: p_data => x_msg_data);
172:
173: -- Debug info.
174: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
176: p_msg_data=>x_msg_data,
177: p_msg_type=>'WARNING',
178: p_msg_level=>fnd_log.level_exception);
174: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
176: p_msg_data=>x_msg_data,
177: p_msg_type=>'WARNING',
178: p_msg_level=>fnd_log.level_exception);
179: END IF;
180:
181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
177: p_msg_type=>'WARNING',
178: p_msg_level=>fnd_log.level_exception);
179: END IF;
180:
181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
183: p_prefix=>l_debug_prefix,
184: p_msg_level=>fnd_log.level_procedure);
185: END IF;
180:
181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
183: p_prefix=>l_debug_prefix,
184: p_msg_level=>fnd_log.level_procedure);
185: END IF;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195:
196: -- Debug info.
197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
199: p_msg_data=>x_msg_data,
200: p_msg_type=>'ERROR',
201: p_msg_level=>fnd_log.level_error);
197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
199: p_msg_data=>x_msg_data,
200: p_msg_type=>'ERROR',
201: p_msg_level=>fnd_log.level_error);
202: END IF;
203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
200: p_msg_type=>'ERROR',
201: p_msg_level=>fnd_log.level_error);
202: END IF;
203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO update_bod_pvt;
215: p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: -- Debug info.
219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
221: p_msg_data=>x_msg_data,
222: p_msg_type=>'UNEXPECTED ERROR',
223: p_msg_level=>fnd_log.level_error);
219: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
220: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
221: p_msg_data=>x_msg_data,
222: p_msg_type=>'UNEXPECTED ERROR',
223: p_msg_level=>fnd_log.level_error);
224: END IF;
225:
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
222: p_msg_type=>'UNEXPECTED ERROR',
223: p_msg_level=>fnd_log.level_error);
224: END IF;
225:
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
225:
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO update_bod_pvt;
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243: -- Debug info.
244: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
246: p_msg_data=>x_msg_data,
247: p_msg_type=>'SQL ERROR',
248: p_msg_level=>fnd_log.level_error);
244: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
246: p_msg_data=>x_msg_data,
247: p_msg_type=>'SQL ERROR',
248: p_msg_level=>fnd_log.level_error);
249: END IF;
250:
251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
247: p_msg_type=>'SQL ERROR',
248: p_msg_level=>fnd_log.level_error);
249: END IF;
250:
251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
253: p_prefix=>l_debug_prefix,
254: p_msg_level=>fnd_log.level_procedure);
255: END IF;
250:
251: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug(p_message=>'update_bod (-)',
253: p_prefix=>l_debug_prefix,
254: p_msg_level=>fnd_log.level_procedure);
255: END IF;
256: END update_bod;
257:
258: END HZ_BES_BO_DEFINITION_PVT;