248: p_count => x_msg_count,
249: p_data => x_msg_data);
250:
251: -- Debug info.
252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
254: p_msg_data=>x_msg_data,
255: p_msg_type=>'ERROR',
256: p_msg_level=>fnd_log.level_error);
252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
254: p_msg_data=>x_msg_data,
255: p_msg_type=>'ERROR',
256: p_msg_level=>fnd_log.level_error);
257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
260: p_prefix=>l_debug_prefix,
254: p_msg_data=>x_msg_data,
255: p_msg_type=>'ERROR',
256: p_msg_level=>fnd_log.level_error);
257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: WHEN fnd_api.g_exc_unexpected_error THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
267: p_count => x_msg_count,
268: p_data => x_msg_data);
269:
270: -- Debug info.
271: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
272: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
273: p_msg_data=>x_msg_data,
274: p_msg_type=>'UNEXPECTED ERROR',
275: p_msg_level=>fnd_log.level_error);
271: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
272: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
273: p_msg_data=>x_msg_data,
274: p_msg_type=>'UNEXPECTED ERROR',
275: p_msg_level=>fnd_log.level_error);
276: END IF;
277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
278: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
279: p_prefix=>l_debug_prefix,
273: p_msg_data=>x_msg_data,
274: p_msg_type=>'UNEXPECTED ERROR',
275: p_msg_level=>fnd_log.level_error);
276: END IF;
277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
278: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
279: p_prefix=>l_debug_prefix,
280: p_msg_level=>fnd_log.level_procedure);
281: END IF;
276: END IF;
277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
278: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
279: p_prefix=>l_debug_prefix,
280: p_msg_level=>fnd_log.level_procedure);
281: END IF;
282: WHEN OTHERS THEN
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284:
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292:
293: -- Debug info.
294: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
295: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
296: p_msg_data=>x_msg_data,
297: p_msg_type=>'SQL ERROR',
298: p_msg_level=>fnd_log.level_error);
294: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
295: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
296: p_msg_data=>x_msg_data,
297: p_msg_type=>'SQL ERROR',
298: p_msg_level=>fnd_log.level_error);
299: END IF;
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
302: p_prefix=>l_debug_prefix,
296: p_msg_data=>x_msg_data,
297: p_msg_type=>'SQL ERROR',
298: p_msg_level=>fnd_log.level_error);
299: END IF;
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;
299: END IF;
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;
305:
306: end;
307: