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 176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 179: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 192: p_msg_level=>fnd_log.level_exception);

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

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

192: p_msg_level=>fnd_log.level_exception);
193: END IF;
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_bo_root_ids (-)',
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_bo_root_ids (-)',
198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;
201:
202:
203: EXCEPTION

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

209: p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: -- Debug info.
213: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
214: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
215: p_msg_data=>x_msg_data,
216: p_msg_type=>'ERROR',
217: p_msg_level=>fnd_log.level_error);

Line 217: p_msg_level=>fnd_log.level_error);

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

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

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

Line 222: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 236: p_msg_level=>fnd_log.level_error);

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

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

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

Line 241: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 259: p_msg_level=>fnd_log.level_error);

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

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

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

Line 264: p_msg_level=>fnd_log.level_procedure);

260: END IF;
261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
263: p_prefix=>l_debug_prefix,
264: p_msg_level=>fnd_log.level_procedure);
265: END IF;
266:
267: end;
268:

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

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

Line 353: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 499: p_msg_level=>fnd_log.level_error);

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

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

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

Line 504: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 518: p_msg_level=>fnd_log.level_error);

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

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

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

Line 523: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 541: p_msg_level=>fnd_log.level_error);

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

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

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

Line 546: p_msg_level=>fnd_log.level_procedure);

542: END IF;
543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
545: p_prefix=>l_debug_prefix,
546: p_msg_level=>fnd_log.level_procedure);
547: END IF;
548: END validate_ssm_id;
549:
550: