DBA Data[Home] [Help]

APPS.HZ_EXTRACT_RELATIONSHIP_BO_PVT dependencies on FND_LOG

Line 197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 200: p_msg_level=>fnd_log.level_procedure);

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;

Line 209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 220: p_msg_level=>fnd_log.level_procedure);

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

Line 234: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 243: p_msg_level=>fnd_log.level_procedure);

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:

Line 253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 262: p_msg_level=>fnd_log.level_procedure);

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:

Line 276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 285: p_msg_level=>fnd_log.level_procedure);

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: