193: END IF;
194:
195:
196: -- Debug info.
197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug(p_message=>'get_relationship_bos(+)',
199: p_prefix=>l_debug_prefix,
200: p_msg_level=>fnd_log.level_procedure);
201: END IF;
196: -- Debug info.
197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug(p_message=>'get_relationship_bos(+)',
199: p_prefix=>l_debug_prefix,
200: p_msg_level=>fnd_log.level_procedure);
201: END IF;
202:
203: x_relationship_objs := HZ_RELATIONSHIP_OBJ_TBL();
204: open c1;
205: fetch c1 BULK COLLECT into x_relationship_objs;
206: close c1;
207:
208: -- Debug info.
209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
211: p_msg_data=>x_msg_data,
212: p_msg_type=>'WARNING',
213: p_msg_level=>fnd_log.level_exception);
209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
211: p_msg_data=>x_msg_data,
212: p_msg_type=>'WARNING',
213: p_msg_level=>fnd_log.level_exception);
214: END IF;
215:
216: -- Debug info.
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
213: p_msg_level=>fnd_log.level_exception);
214: END IF;
215:
216: -- Debug info.
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
219: p_prefix=>l_debug_prefix,
220: p_msg_level=>fnd_log.level_procedure);
221: END IF;
216: -- Debug info.
217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
219: p_prefix=>l_debug_prefix,
220: p_msg_level=>fnd_log.level_procedure);
221: END IF;
222:
223:
224: EXCEPTION
230: p_count => x_msg_count,
231: p_data => x_msg_data);
232:
233: -- Debug info.
234: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
236: p_msg_data=>x_msg_data,
237: p_msg_type=>'ERROR',
238: p_msg_level=>fnd_log.level_error);
234: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
236: p_msg_data=>x_msg_data,
237: p_msg_type=>'ERROR',
238: p_msg_level=>fnd_log.level_error);
239: END IF;
240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
242: p_prefix=>l_debug_prefix,
236: p_msg_data=>x_msg_data,
237: p_msg_type=>'ERROR',
238: p_msg_level=>fnd_log.level_error);
239: END IF;
240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
242: p_prefix=>l_debug_prefix,
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
239: END IF;
240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
242: p_prefix=>l_debug_prefix,
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: -- Debug info.
253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
261: p_prefix=>l_debug_prefix,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
264: WHEN OTHERS THEN
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266:
272: p_count => x_msg_count,
273: p_data => x_msg_data);
274:
275: -- Debug info.
276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
278: p_msg_data=>x_msg_data,
279: p_msg_type=>'SQL ERROR',
280: p_msg_level=>fnd_log.level_error);
276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
278: p_msg_data=>x_msg_data,
279: p_msg_type=>'SQL ERROR',
280: p_msg_level=>fnd_log.level_error);
281: END IF;
282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
284: p_prefix=>l_debug_prefix,
278: p_msg_data=>x_msg_data,
279: p_msg_type=>'SQL ERROR',
280: p_msg_level=>fnd_log.level_error);
281: END IF;
282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
284: p_prefix=>l_debug_prefix,
285: p_msg_level=>fnd_log.level_procedure);
286: END IF;
281: END IF;
282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
284: p_prefix=>l_debug_prefix,
285: p_msg_level=>fnd_log.level_procedure);
286: END IF;
287:
288: end;
289: