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_EXTRACT_BO_UTIL_PVT dependencies on FND_LOG

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

168: END IF;
169:
170:
171: -- Debug info.
172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
173: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(+)',
174: p_prefix=>l_debug_prefix,
175: p_msg_level=>fnd_log.level_procedure);
176: END IF;

Line 175: p_msg_level=>fnd_log.level_procedure);

171: -- Debug info.
172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
173: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(+)',
174: p_prefix=>l_debug_prefix,
175: p_msg_level=>fnd_log.level_procedure);
176: END IF;
177:
178:
179: open c1;

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

180: fetch c1 bulk collect into x_obj_root_ids;
181: close c1;
182:
183: -- Debug info.
184: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
186: p_msg_data=>x_msg_data,
187: p_msg_type=>'WARNING',
188: p_msg_level=>fnd_log.level_exception);

Line 188: p_msg_level=>fnd_log.level_exception);

184: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
186: p_msg_data=>x_msg_data,
187: p_msg_type=>'WARNING',
188: p_msg_level=>fnd_log.level_exception);
189: END IF;
190:
191: -- Debug info.
192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

188: p_msg_level=>fnd_log.level_exception);
189: END IF;
190:
191: -- Debug info.
192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids (-)',
194: p_prefix=>l_debug_prefix,
195: p_msg_level=>fnd_log.level_procedure);
196: END IF;

Line 195: p_msg_level=>fnd_log.level_procedure);

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

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

205: p_count => x_msg_count,
206: p_data => x_msg_data);
207:
208: -- Debug info.
209: IF fnd_log.level_error>=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=>'ERROR',
213: p_msg_level=>fnd_log.level_error);

Line 213: p_msg_level=>fnd_log.level_error);

209: IF fnd_log.level_error>=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=>'ERROR',
213: p_msg_level=>fnd_log.level_error);
214: END IF;
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
217: p_prefix=>l_debug_prefix,

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

211: p_msg_data=>x_msg_data,
212: p_msg_type=>'ERROR',
213: p_msg_level=>fnd_log.level_error);
214: END IF;
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
217: p_prefix=>l_debug_prefix,
218: p_msg_level=>fnd_log.level_procedure);
219: END IF;

Line 218: p_msg_level=>fnd_log.level_procedure);

214: END IF;
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
217: p_prefix=>l_debug_prefix,
218: p_msg_level=>fnd_log.level_procedure);
219: END IF;
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: x_return_status := fnd_api.g_ret_sts_unexp_error;
222:

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

224: p_count => x_msg_count,
225: p_data => x_msg_data);
226:
227: -- Debug info.
228: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
229: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
230: p_msg_data=>x_msg_data,
231: p_msg_type=>'UNEXPECTED ERROR',
232: p_msg_level=>fnd_log.level_error);

Line 232: p_msg_level=>fnd_log.level_error);

228: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
229: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
230: p_msg_data=>x_msg_data,
231: p_msg_type=>'UNEXPECTED ERROR',
232: p_msg_level=>fnd_log.level_error);
233: END IF;
234: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
236: p_prefix=>l_debug_prefix,

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

230: p_msg_data=>x_msg_data,
231: p_msg_type=>'UNEXPECTED ERROR',
232: p_msg_level=>fnd_log.level_error);
233: END IF;
234: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
236: p_prefix=>l_debug_prefix,
237: p_msg_level=>fnd_log.level_procedure);
238: END IF;

Line 237: p_msg_level=>fnd_log.level_procedure);

233: END IF;
234: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
236: p_prefix=>l_debug_prefix,
237: p_msg_level=>fnd_log.level_procedure);
238: END IF;
239: WHEN OTHERS THEN
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241:

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

247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:
250: -- Debug info.
251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
253: p_msg_data=>x_msg_data,
254: p_msg_type=>'SQL ERROR',
255: p_msg_level=>fnd_log.level_error);

Line 255: p_msg_level=>fnd_log.level_error);

251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
253: p_msg_data=>x_msg_data,
254: p_msg_type=>'SQL ERROR',
255: p_msg_level=>fnd_log.level_error);
256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
259: p_prefix=>l_debug_prefix,

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

253: p_msg_data=>x_msg_data,
254: p_msg_type=>'SQL ERROR',
255: p_msg_level=>fnd_log.level_error);
256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
259: p_prefix=>l_debug_prefix,
260: p_msg_level=>fnd_log.level_procedure);
261: END IF;

Line 260: p_msg_level=>fnd_log.level_procedure);

256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
259: p_prefix=>l_debug_prefix,
260: p_msg_level=>fnd_log.level_procedure);
261: END IF;
262:
263: end;
264:

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

342: l_dummy VARCHAR2(1);
343: l_obj_type VARCHAR2(30);
344: BEGIN
345: -- Debug info.
346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
347: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(+)',
348: p_prefix=>l_debug_prefix,
349: p_msg_level=>fnd_log.level_procedure);
350: END IF;

Line 349: p_msg_level=>fnd_log.level_procedure);

345: -- Debug info.
346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
347: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(+)',
348: p_prefix=>l_debug_prefix,
349: p_msg_level=>fnd_log.level_procedure);
350: END IF;
351:
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:

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

487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: -- Debug info.
491: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
493: p_msg_data=>x_msg_data,
494: p_msg_type=>'ERROR',
495: p_msg_level=>fnd_log.level_error);

Line 495: p_msg_level=>fnd_log.level_error);

491: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
493: p_msg_data=>x_msg_data,
494: p_msg_type=>'ERROR',
495: p_msg_level=>fnd_log.level_error);
496: END IF;
497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
498: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
499: p_prefix=>l_debug_prefix,

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

493: p_msg_data=>x_msg_data,
494: p_msg_type=>'ERROR',
495: p_msg_level=>fnd_log.level_error);
496: END IF;
497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
498: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);
501: END IF;

Line 500: p_msg_level=>fnd_log.level_procedure);

496: END IF;
497: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
498: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);
501: END IF;
502: WHEN fnd_api.g_exc_unexpected_error THEN
503: x_return_status := fnd_api.g_ret_sts_unexp_error;
504:

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

506: p_count => x_msg_count,
507: p_data => x_msg_data);
508:
509: -- Debug info.
510: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
511: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
512: p_msg_data=>x_msg_data,
513: p_msg_type=>'UNEXPECTED ERROR',
514: p_msg_level=>fnd_log.level_error);

Line 514: p_msg_level=>fnd_log.level_error);

510: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
511: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
512: p_msg_data=>x_msg_data,
513: p_msg_type=>'UNEXPECTED ERROR',
514: p_msg_level=>fnd_log.level_error);
515: END IF;
516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
517: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
518: p_prefix=>l_debug_prefix,

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

512: p_msg_data=>x_msg_data,
513: p_msg_type=>'UNEXPECTED ERROR',
514: p_msg_level=>fnd_log.level_error);
515: END IF;
516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
517: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
518: p_prefix=>l_debug_prefix,
519: p_msg_level=>fnd_log.level_procedure);
520: END IF;

Line 519: p_msg_level=>fnd_log.level_procedure);

515: END IF;
516: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
517: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
518: p_prefix=>l_debug_prefix,
519: p_msg_level=>fnd_log.level_procedure);
520: END IF;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523:

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

529: p_count => x_msg_count,
530: p_data => x_msg_data);
531:
532: -- Debug info.
533: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
534: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
535: p_msg_data=>x_msg_data,
536: p_msg_type=>'SQL ERROR',
537: p_msg_level=>fnd_log.level_error);

Line 537: p_msg_level=>fnd_log.level_error);

533: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
534: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
535: p_msg_data=>x_msg_data,
536: p_msg_type=>'SQL ERROR',
537: p_msg_level=>fnd_log.level_error);
538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
541: p_prefix=>l_debug_prefix,

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

535: p_msg_data=>x_msg_data,
536: p_msg_type=>'SQL ERROR',
537: p_msg_level=>fnd_log.level_error);
538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;

Line 542: p_msg_level=>fnd_log.level_procedure);

538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;
544: END validate_ssm_id;
545:
546: