eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:
291: l_dup_id_objs := p_dup_id_objs;
292: for i in 1..l_dup_id_objs.count loop

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

449: x_merge_request_id := l_dup_set_id;
450:
451:
452: -- Debug info.
453: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
455: p_msg_data=>x_msg_data,
456: p_msg_type=>'WARNING',
457: p_msg_level=>fnd_log.level_exception);

Line 457: p_msg_level=>fnd_log.level_exception);

453: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
455: p_msg_data=>x_msg_data,
456: p_msg_type=>'WARNING',
457: p_msg_level=>fnd_log.level_exception);
458: END IF;
459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
461: p_prefix=>l_debug_prefix,

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

455: p_msg_data=>x_msg_data,
456: p_msg_type=>'WARNING',
457: p_msg_level=>fnd_log.level_exception);
458: END IF;
459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
461: p_prefix=>l_debug_prefix,
462: p_msg_level=>fnd_log.level_procedure);
463: END IF;

Line 462: p_msg_level=>fnd_log.level_procedure);

458: END IF;
459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
461: p_prefix=>l_debug_prefix,
462: p_msg_level=>fnd_log.level_procedure);
463: END IF;
464:
465: EXCEPTION
466: WHEN fnd_api.g_exc_error THEN

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

471: p_count => x_msg_count,
472: p_data => x_msg_data);
473:
474: -- Debug info.
475: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
476: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
477: p_msg_data=>x_msg_data,
478: p_msg_type=>'ERROR',
479: p_msg_level=>fnd_log.level_error);

Line 479: p_msg_level=>fnd_log.level_error);

475: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
476: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
477: p_msg_data=>x_msg_data,
478: p_msg_type=>'ERROR',
479: p_msg_level=>fnd_log.level_error);
480: END IF;
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
483: p_prefix=>l_debug_prefix,

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

477: p_msg_data=>x_msg_data,
478: p_msg_type=>'ERROR',
479: p_msg_level=>fnd_log.level_error);
480: END IF;
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
483: p_prefix=>l_debug_prefix,
484: p_msg_level=>fnd_log.level_procedure);
485: END IF;

Line 484: p_msg_level=>fnd_log.level_procedure);

480: END IF;
481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
482: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
483: p_prefix=>l_debug_prefix,
484: p_msg_level=>fnd_log.level_procedure);
485: END IF;
486:
487: WHEN fnd_api.g_exc_unexpected_error THEN
488: ROLLBACK TO create_dup_merge_req_pub;

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

492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:
495: -- Debug info.
496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
498: p_msg_data=>x_msg_data,
499: p_msg_type=>'UNEXPECTED ERROR',
500: p_msg_level=>fnd_log.level_error);

Line 500: p_msg_level=>fnd_log.level_error);

496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
498: p_msg_data=>x_msg_data,
499: p_msg_type=>'UNEXPECTED ERROR',
500: p_msg_level=>fnd_log.level_error);
501: END IF;
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
504: p_prefix=>l_debug_prefix,

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

498: p_msg_data=>x_msg_data,
499: p_msg_type=>'UNEXPECTED ERROR',
500: p_msg_level=>fnd_log.level_error);
501: END IF;
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;

Line 505: p_msg_level=>fnd_log.level_procedure);

501: END IF;
502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
503: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
504: p_prefix=>l_debug_prefix,
505: p_msg_level=>fnd_log.level_procedure);
506: END IF;
507:
508: WHEN OTHERS THEN
509: ROLLBACK TO create_dup_merge_req_pub;

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

517: p_count => x_msg_count,
518: p_data => x_msg_data);
519:
520: -- Debug info.
521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
523: p_msg_data=>x_msg_data,
524: p_msg_type=>'SQL ERROR',
525: p_msg_level=>fnd_log.level_error);

Line 525: p_msg_level=>fnd_log.level_error);

521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
523: p_msg_data=>x_msg_data,
524: p_msg_type=>'SQL ERROR',
525: p_msg_level=>fnd_log.level_error);
526: END IF;
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
529: p_prefix=>l_debug_prefix,

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

523: p_msg_data=>x_msg_data,
524: p_msg_type=>'SQL ERROR',
525: p_msg_level=>fnd_log.level_error);
526: END IF;
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
529: p_prefix=>l_debug_prefix,
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;

Line 530: p_msg_level=>fnd_log.level_procedure);

526: END IF;
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(-)',
529: p_prefix=>l_debug_prefix,
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;
532: END create_dup_merge_request;
533:
534: END HZ_DUP_MERGE_PUB;