DBA Data[Home] [Help]

APPS.HZ_DUP_MERGE_PUB dependencies on FND_LOG

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

64: l_owner_table_id number;
65: l_count number;
66: begin
67: -- Debug info.
68: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
69: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(+)',
70: p_prefix=>l_debug_prefix,
71: p_msg_level=>fnd_log.level_procedure);
72: END IF;

Line 71: p_msg_level=>fnd_log.level_procedure);

67: -- Debug info.
68: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
69: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(+)',
70: p_prefix=>l_debug_prefix,
71: p_msg_level=>fnd_log.level_procedure);
72: END IF;
73:
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:

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

177: p_count => x_msg_count,
178: p_data => x_msg_data);
179:
180: -- Debug info.
181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
183: p_msg_data=>x_msg_data,
184: p_msg_type=>'ERROR',
185: p_msg_level=>fnd_log.level_error);

Line 185: p_msg_level=>fnd_log.level_error);

181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
183: p_msg_data=>x_msg_data,
184: p_msg_type=>'ERROR',
185: p_msg_level=>fnd_log.level_error);
186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
189: p_prefix=>l_debug_prefix,

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

183: p_msg_data=>x_msg_data,
184: p_msg_type=>'ERROR',
185: p_msg_level=>fnd_log.level_error);
186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
191: END IF;

Line 190: p_msg_level=>fnd_log.level_procedure);

186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
191: END IF;
192: WHEN fnd_api.g_exc_unexpected_error THEN
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:

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

196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: -- Debug info.
200: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);

Line 204: p_msg_level=>fnd_log.level_error);

200: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
208: p_prefix=>l_debug_prefix,

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

202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
210: END IF;

Line 209: p_msg_level=>fnd_log.level_procedure);

205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
210: END IF;
211: WHEN OTHERS THEN
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:

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

219: p_count => x_msg_count,
220: p_data => x_msg_data);
221:
222: -- Debug info.
223: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'SQL ERROR',
227: p_msg_level=>fnd_log.level_error);

Line 227: p_msg_level=>fnd_log.level_error);

223: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'SQL ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
231: p_prefix=>l_debug_prefix,

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

225: p_msg_data=>x_msg_data,
226: p_msg_type=>'SQL ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
231: p_prefix=>l_debug_prefix,
232: p_msg_level=>fnd_log.level_procedure);
233: END IF;

Line 232: p_msg_level=>fnd_log.level_procedure);

228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
231: p_prefix=>l_debug_prefix,
232: p_msg_level=>fnd_log.level_procedure);
233: END IF;
234: END validate_ssm_id;
235:
236: function check_obj_dup_value(p_dup_id_objs IN HZ_DUP_ID_OBJ_TBL) return varchar2 is

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

281: -- initialize API return status to success.
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: -- Debug info.
285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
286: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(+)',
287: p_prefix=>l_debug_prefix,
288: p_msg_level=>fnd_log.level_procedure);
289: END IF;

Line 288: p_msg_level=>fnd_log.level_procedure);

284: -- Debug info.
285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
286: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(+)',
287: p_prefix=>l_debug_prefix,
288: p_msg_level=>fnd_log.level_procedure);
289: END IF;
290: --Bug8342391
291: IF FND_API.to_Boolean(p_init_msg_list) THEN
292: FND_MSG_PUB.initialize;

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

456: x_merge_request_id := l_dup_set_id;
457:
458:
459: -- Debug info.
460: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
462: p_msg_data=>x_msg_data,
463: p_msg_type=>'WARNING',
464: p_msg_level=>fnd_log.level_exception);

Line 464: p_msg_level=>fnd_log.level_exception);

460: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
462: p_msg_data=>x_msg_data,
463: p_msg_type=>'WARNING',
464: p_msg_level=>fnd_log.level_exception);
465: END IF;
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
468: p_prefix=>l_debug_prefix,

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

462: p_msg_data=>x_msg_data,
463: p_msg_type=>'WARNING',
464: p_msg_level=>fnd_log.level_exception);
465: END IF;
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
468: p_prefix=>l_debug_prefix,
469: p_msg_level=>fnd_log.level_procedure);
470: END IF;

Line 469: p_msg_level=>fnd_log.level_procedure);

465: END IF;
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
468: p_prefix=>l_debug_prefix,
469: p_msg_level=>fnd_log.level_procedure);
470: END IF;
471:
472: EXCEPTION
473: WHEN fnd_api.g_exc_error THEN

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

478: p_count => x_msg_count,
479: p_data => x_msg_data);
480:
481: -- Debug info.
482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
484: p_msg_data=>x_msg_data,
485: p_msg_type=>'ERROR',
486: p_msg_level=>fnd_log.level_error);

Line 486: p_msg_level=>fnd_log.level_error);

482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
484: p_msg_data=>x_msg_data,
485: p_msg_type=>'ERROR',
486: p_msg_level=>fnd_log.level_error);
487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
490: p_prefix=>l_debug_prefix,

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

484: p_msg_data=>x_msg_data,
485: p_msg_type=>'ERROR',
486: p_msg_level=>fnd_log.level_error);
487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;

Line 491: p_msg_level=>fnd_log.level_procedure);

487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;
493:
494: WHEN fnd_api.g_exc_unexpected_error THEN
495: ROLLBACK TO create_dup_merge_req_pub;

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

499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: -- Debug info.
503: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
505: p_msg_data=>x_msg_data,
506: p_msg_type=>'UNEXPECTED ERROR',
507: p_msg_level=>fnd_log.level_error);

Line 507: p_msg_level=>fnd_log.level_error);

503: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
505: p_msg_data=>x_msg_data,
506: p_msg_type=>'UNEXPECTED ERROR',
507: p_msg_level=>fnd_log.level_error);
508: END IF;
509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
510: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
511: p_prefix=>l_debug_prefix,

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

505: p_msg_data=>x_msg_data,
506: p_msg_type=>'UNEXPECTED ERROR',
507: p_msg_level=>fnd_log.level_error);
508: END IF;
509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
510: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
511: p_prefix=>l_debug_prefix,
512: p_msg_level=>fnd_log.level_procedure);
513: END IF;

Line 512: p_msg_level=>fnd_log.level_procedure);

508: END IF;
509: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
510: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
511: p_prefix=>l_debug_prefix,
512: p_msg_level=>fnd_log.level_procedure);
513: END IF;
514:
515: WHEN OTHERS THEN
516: ROLLBACK TO create_dup_merge_req_pub;

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

524: p_count => x_msg_count,
525: p_data => x_msg_data);
526:
527: -- Debug info.
528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'SQL ERROR',
532: p_msg_level=>fnd_log.level_error);

Line 532: p_msg_level=>fnd_log.level_error);

528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'SQL ERROR',
532: p_msg_level=>fnd_log.level_error);
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
536: p_prefix=>l_debug_prefix,

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

530: p_msg_data=>x_msg_data,
531: p_msg_type=>'SQL ERROR',
532: p_msg_level=>fnd_log.level_error);
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;

Line 537: p_msg_level=>fnd_log.level_procedure);

533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;
539: END create_dup_merge_request;
540:
541: END HZ_DUP_MERGE_PUB;