DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on FND_LOG

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

277: END IF;
278:
279:
280: -- Debug info.
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_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: -- Debug info.
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos(+)',
283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;
286:
287: x_cust_acct_contact_objs := HZ_CUST_ACCT_CONTACT_BO_TBL();
288: open c1;

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

291:
292:
293:
294: -- Debug info.
295: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
296: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
297: p_msg_data=>x_msg_data,
298: p_msg_type=>'WARNING',
299: p_msg_level=>fnd_log.level_exception);

Line 299: p_msg_level=>fnd_log.level_exception);

295: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
296: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
297: p_msg_data=>x_msg_data,
298: p_msg_type=>'WARNING',
299: p_msg_level=>fnd_log.level_exception);
300: END IF;
301:
302: -- Debug info.
303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

299: p_msg_level=>fnd_log.level_exception);
300: END IF;
301:
302: -- Debug info.
303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
304: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
305: p_prefix=>l_debug_prefix,
306: p_msg_level=>fnd_log.level_procedure);
307: END IF;

Line 306: p_msg_level=>fnd_log.level_procedure);

302: -- Debug info.
303: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
304: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
305: p_prefix=>l_debug_prefix,
306: p_msg_level=>fnd_log.level_procedure);
307: END IF;
308:
309:
310: EXCEPTION

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

316: p_count => x_msg_count,
317: p_data => x_msg_data);
318:
319: -- Debug info.
320: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
321: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
322: p_msg_data=>x_msg_data,
323: p_msg_type=>'ERROR',
324: p_msg_level=>fnd_log.level_error);

Line 324: p_msg_level=>fnd_log.level_error);

320: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
321: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
322: p_msg_data=>x_msg_data,
323: p_msg_type=>'ERROR',
324: p_msg_level=>fnd_log.level_error);
325: END IF;
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
327: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
328: p_prefix=>l_debug_prefix,

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

322: p_msg_data=>x_msg_data,
323: p_msg_type=>'ERROR',
324: p_msg_level=>fnd_log.level_error);
325: END IF;
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
327: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;

Line 329: p_msg_level=>fnd_log.level_procedure);

325: END IF;
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
327: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;
331: WHEN fnd_api.g_exc_unexpected_error THEN
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333:

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

335: p_count => x_msg_count,
336: p_data => x_msg_data);
337:
338: -- Debug info.
339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
341: p_msg_data=>x_msg_data,
342: p_msg_type=>'UNEXPECTED ERROR',
343: p_msg_level=>fnd_log.level_error);

Line 343: p_msg_level=>fnd_log.level_error);

339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
341: p_msg_data=>x_msg_data,
342: p_msg_type=>'UNEXPECTED ERROR',
343: p_msg_level=>fnd_log.level_error);
344: END IF;
345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
346: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
347: p_prefix=>l_debug_prefix,

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

341: p_msg_data=>x_msg_data,
342: p_msg_type=>'UNEXPECTED ERROR',
343: p_msg_level=>fnd_log.level_error);
344: END IF;
345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
346: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
347: p_prefix=>l_debug_prefix,
348: p_msg_level=>fnd_log.level_procedure);
349: END IF;

Line 348: p_msg_level=>fnd_log.level_procedure);

344: END IF;
345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
346: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
347: p_prefix=>l_debug_prefix,
348: p_msg_level=>fnd_log.level_procedure);
349: END IF;
350: WHEN OTHERS THEN
351: x_return_status := fnd_api.g_ret_sts_unexp_error;
352:

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

358: p_count => x_msg_count,
359: p_data => x_msg_data);
360:
361: -- Debug info.
362: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
363: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
364: p_msg_data=>x_msg_data,
365: p_msg_type=>'SQL ERROR',
366: p_msg_level=>fnd_log.level_error);

Line 366: p_msg_level=>fnd_log.level_error);

362: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
363: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
364: p_msg_data=>x_msg_data,
365: p_msg_type=>'SQL ERROR',
366: p_msg_level=>fnd_log.level_error);
367: END IF;
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
370: p_prefix=>l_debug_prefix,

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

364: p_msg_data=>x_msg_data,
365: p_msg_type=>'SQL ERROR',
366: p_msg_level=>fnd_log.level_error);
367: END IF;
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;

Line 371: p_msg_level=>fnd_log.level_procedure);

367: END IF;
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
373:
374: end;
375: