DBA Data[Home] [Help]

APPS.HZ_EXTRACT_RELATIONSHIP_BO_PVT dependencies on FND_LOG

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

192: END IF;
193:
194:
195: -- Debug info.
196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
197: hz_utility_v2pub.debug(p_message=>'get_relationship_bos(+)',
198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;

Line 199: p_msg_level=>fnd_log.level_procedure);

195: -- Debug info.
196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
197: hz_utility_v2pub.debug(p_message=>'get_relationship_bos(+)',
198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;
201:
202: x_relationship_objs := HZ_RELATIONSHIP_OBJ_TBL();
203: open c1;

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

204: fetch c1 BULK COLLECT into x_relationship_objs;
205: close c1;
206:
207: -- Debug info.
208: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
209: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
210: p_msg_data=>x_msg_data,
211: p_msg_type=>'WARNING',
212: p_msg_level=>fnd_log.level_exception);

Line 212: p_msg_level=>fnd_log.level_exception);

208: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
209: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
210: p_msg_data=>x_msg_data,
211: p_msg_type=>'WARNING',
212: p_msg_level=>fnd_log.level_exception);
213: END IF;
214:
215: -- Debug info.
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

212: p_msg_level=>fnd_log.level_exception);
213: END IF;
214:
215: -- Debug info.
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;

Line 219: p_msg_level=>fnd_log.level_procedure);

215: -- Debug info.
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;
221:
222:
223: EXCEPTION

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

229: p_count => x_msg_count,
230: p_data => x_msg_data);
231:
232: -- Debug info.
233: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
235: p_msg_data=>x_msg_data,
236: p_msg_type=>'ERROR',
237: p_msg_level=>fnd_log.level_error);

Line 237: p_msg_level=>fnd_log.level_error);

233: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
235: p_msg_data=>x_msg_data,
236: p_msg_type=>'ERROR',
237: p_msg_level=>fnd_log.level_error);
238: END IF;
239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
240: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
241: p_prefix=>l_debug_prefix,

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

235: p_msg_data=>x_msg_data,
236: p_msg_type=>'ERROR',
237: p_msg_level=>fnd_log.level_error);
238: END IF;
239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
240: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
241: p_prefix=>l_debug_prefix,
242: p_msg_level=>fnd_log.level_procedure);
243: END IF;

Line 242: p_msg_level=>fnd_log.level_procedure);

238: END IF;
239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
240: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
241: p_prefix=>l_debug_prefix,
242: p_msg_level=>fnd_log.level_procedure);
243: END IF;
244: WHEN fnd_api.g_exc_unexpected_error THEN
245: x_return_status := fnd_api.g_ret_sts_unexp_error;
246:

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

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=>'UNEXPECTED ERROR',
256: p_msg_level=>fnd_log.level_error);

Line 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=>'UNEXPECTED 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_relationship_bos (-)',
260: p_prefix=>l_debug_prefix,

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

254: p_msg_data=>x_msg_data,
255: p_msg_type=>'UNEXPECTED 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_relationship_bos (-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;

Line 261: p_msg_level=>fnd_log.level_procedure);

257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: WHEN OTHERS THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:

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

271: p_count => x_msg_count,
272: p_data => x_msg_data);
273:
274: -- Debug info.
275: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
276: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
277: p_msg_data=>x_msg_data,
278: p_msg_type=>'SQL ERROR',
279: p_msg_level=>fnd_log.level_error);

Line 279: p_msg_level=>fnd_log.level_error);

275: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
276: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
277: p_msg_data=>x_msg_data,
278: p_msg_type=>'SQL ERROR',
279: p_msg_level=>fnd_log.level_error);
280: END IF;
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
283: p_prefix=>l_debug_prefix,

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

277: p_msg_data=>x_msg_data,
278: p_msg_type=>'SQL ERROR',
279: p_msg_level=>fnd_log.level_error);
280: END IF;
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;

Line 284: p_msg_level=>fnd_log.level_procedure);

280: END IF;
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;
286:
287: end;
288: