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

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

108: l_debug_prefix VARCHAR2(30) := '';
109: BEGIN
110:
111: -- Debug info.
112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
113: hz_utility_v2pub.debug(p_message=>'do_create_style (+)',
114: p_prefix=>l_debug_prefix,
115: p_msg_level=>fnd_log.level_procedure);
116: END IF;

Line 115: p_msg_level=>fnd_log.level_procedure);

111: -- Debug info.
112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
113: hz_utility_v2pub.debug(p_message=>'do_create_style (+)',
114: p_prefix=>l_debug_prefix,
115: p_msg_level=>fnd_log.level_procedure);
116: END IF;
117:
118: -- validate the input record
119: HZ_NAME_ADDRESS_FMT_VALIDATE.validate_style(

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

127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130: -- Debug info.
131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
132: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.insert_row (+)',
133: p_prefix=>l_debug_prefix,
134: p_msg_level=>fnd_log.level_procedure);
135: END IF;

Line 134: p_msg_level=>fnd_log.level_procedure);

130: -- Debug info.
131: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
132: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.insert_row (+)',
133: p_prefix=>l_debug_prefix,
134: p_msg_level=>fnd_log.level_procedure);
135: END IF;
136:
137: hz_styles_pkg.insert_row (
138: X_ROWID => l_rowid,

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

143: x_object_version_number => 1
144: );
145:
146: -- Debug info.
147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.insert_row (-) ' ||
149: 'p_style_rec.style_code = ' || p_style_rec.style_code,
150: p_prefix=>l_debug_prefix,
151: p_msg_level=>fnd_log.level_procedure);

Line 151: p_msg_level=>fnd_log.level_procedure);

147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.insert_row (-) ' ||
149: 'p_style_rec.style_code = ' || p_style_rec.style_code,
150: p_prefix=>l_debug_prefix,
151: p_msg_level=>fnd_log.level_procedure);
152: END IF;
153: END do_create_style;
154:
155: /**

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

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

Line 181: p_msg_level=>fnd_log.level_procedure);

177: -- Debug info.
178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug(p_message=>'do_update_style (+)',
180: p_prefix=>l_debug_prefix,
181: p_msg_level=>fnd_log.level_procedure);
182: END IF;
183:
184: -- check whether record has been updated by another user
185: BEGIN

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

223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: -- Debug info.
227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
228: hz_utility_v2pub.debug(p_message=>'HZ_STYLES_PKG.Update_Row (+)',
229: p_prefix=>l_debug_prefix,
230: p_msg_level=>fnd_log.level_procedure);
231: END IF;

Line 230: p_msg_level=>fnd_log.level_procedure);

226: -- Debug info.
227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
228: hz_utility_v2pub.debug(p_message=>'HZ_STYLES_PKG.Update_Row (+)',
229: p_prefix=>l_debug_prefix,
230: p_msg_level=>fnd_log.level_procedure);
231: END IF;
232:
233: -- call table handler to update a row
234: HZ_STYLES_PKG.Update_Row (

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

239: x_object_version_number => p_object_version_number
240: );
241:
242: -- Debug info.
243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
244: hz_utility_v2pub.debug(p_message=>'HZ_STYLES_PKG.Update_Row (-)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;

Line 246: p_msg_level=>fnd_log.level_procedure);

242: -- Debug info.
243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
244: hz_utility_v2pub.debug(p_message=>'HZ_STYLES_PKG.Update_Row (-)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;
248:
249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

246: p_msg_level=>fnd_log.level_procedure);
247: END IF;
248:
249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'do_update_style (-)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;

Line 253: p_msg_level=>fnd_log.level_procedure);

249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'do_update_style (-)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;
255:
256: END do_update_style;
257:

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

308: -- Check if API is called in debug mode. If yes, enable debug.
309: --enable_debug;
310:
311: -- Debug info.
312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
313: hz_utility_v2pub.debug(p_message=>'create_style (+)',
314: p_prefix=>l_debug_prefix,
315: p_msg_level=>fnd_log.level_procedure);
316: END IF;

Line 315: p_msg_level=>fnd_log.level_procedure);

311: -- Debug info.
312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
313: hz_utility_v2pub.debug(p_message=>'create_style (+)',
314: p_prefix=>l_debug_prefix,
315: p_msg_level=>fnd_log.level_procedure);
316: END IF;
317:
318: -- initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

333: p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);
336: -- Debug info.
337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
339: p_msg_data=>x_msg_data,
340: p_msg_type=>'WARNING',
341: p_msg_level=>fnd_log.level_exception);

Line 341: p_msg_level=>fnd_log.level_exception);

337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
339: p_msg_data=>x_msg_data,
340: p_msg_type=>'WARNING',
341: p_msg_level=>fnd_log.level_exception);
342: END IF;
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style (-)',
345: p_prefix=>l_debug_prefix,

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

339: p_msg_data=>x_msg_data,
340: p_msg_type=>'WARNING',
341: p_msg_level=>fnd_log.level_exception);
342: END IF;
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style (-)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;

Line 346: p_msg_level=>fnd_log.level_procedure);

342: END IF;
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style (-)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;
348:
349: -- Check if API is called in debug mode. If yes, disable debug.
350: --disable_debug;

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=>'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=>'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=>'create_style (-)',
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=>'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=>'create_style (-)',
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=>'create_style (-)',
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
373:
374: -- Check if API is called in debug mode. If yes, disable debug.
375: --disable_debug;

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

382: p_count => x_msg_count,
383: p_data => x_msg_data);
384:
385: -- Debug info.
386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
388: p_msg_data=>x_msg_data,
389: p_msg_type=>'UNEXPECTED ERROR',
390: p_msg_level=>fnd_log.level_error);

Line 390: p_msg_level=>fnd_log.level_error);

386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
388: p_msg_data=>x_msg_data,
389: p_msg_type=>'UNEXPECTED ERROR',
390: p_msg_level=>fnd_log.level_error);
391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'create_style (-)',
394: p_prefix=>l_debug_prefix,

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

388: p_msg_data=>x_msg_data,
389: p_msg_type=>'UNEXPECTED ERROR',
390: p_msg_level=>fnd_log.level_error);
391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'create_style (-)',
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: END IF;

Line 395: p_msg_level=>fnd_log.level_procedure);

391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'create_style (-)',
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: END IF;
397:
398: -- Check if API is called in debug mode. If yes, disable debug.
399: --disable_debug;

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

411: p_count => x_msg_count,
412: p_data => x_msg_data);
413:
414: -- Debug info.
415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
417: p_msg_data=>x_msg_data,
418: p_msg_type=>'SQL ERROR',
419: p_msg_level=>fnd_log.level_error);

Line 419: p_msg_level=>fnd_log.level_error);

415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
417: p_msg_data=>x_msg_data,
418: p_msg_type=>'SQL ERROR',
419: p_msg_level=>fnd_log.level_error);
420: END IF;
421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug(p_message=>'create_style (-)',
423: p_prefix=>l_debug_prefix,

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

417: p_msg_data=>x_msg_data,
418: p_msg_type=>'SQL ERROR',
419: p_msg_level=>fnd_log.level_error);
420: END IF;
421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug(p_message=>'create_style (-)',
423: p_prefix=>l_debug_prefix,
424: p_msg_level=>fnd_log.level_procedure);
425: END IF;

Line 424: p_msg_level=>fnd_log.level_procedure);

420: END IF;
421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug(p_message=>'create_style (-)',
423: p_prefix=>l_debug_prefix,
424: p_msg_level=>fnd_log.level_procedure);
425: END IF;
426:
427: -- Check if API is called in debug mode. If yes, disable debug.
428: --disable_debug;

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

482: -- Check if API is called in debug mode. If yes, enable debug.
483: --enable_debug;
484:
485: -- Debug info.
486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
487: hz_utility_v2pub.debug(p_message=>'update_style (+)',
488: p_prefix=>l_debug_prefix,
489: p_msg_level=>fnd_log.level_procedure);
490: END IF;

Line 489: p_msg_level=>fnd_log.level_procedure);

485: -- Debug info.
486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
487: hz_utility_v2pub.debug(p_message=>'update_style (+)',
488: p_prefix=>l_debug_prefix,
489: p_msg_level=>fnd_log.level_procedure);
490: END IF;
491:
492: -- initialize message list if p_init_msg_list is set to TRUE.
493: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 517: p_msg_level=>fnd_log.level_exception);

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

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

515: p_msg_data=>x_msg_data,
516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);
518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'update_style (-)',
521: p_prefix=>l_debug_prefix,
522: p_msg_level=>fnd_log.level_procedure);
523: END IF;

Line 522: p_msg_level=>fnd_log.level_procedure);

518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'update_style (-)',
521: p_prefix=>l_debug_prefix,
522: p_msg_level=>fnd_log.level_procedure);
523: END IF;
524:
525: -- Check if API is called in debug mode. If yes, disable debug.
526: --disable_debug;

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

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

Line 542: p_msg_level=>fnd_log.level_error);

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

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

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

Line 547: p_msg_level=>fnd_log.level_procedure);

543: END IF;
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'update_style (-)',
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;
549:
550: -- Check if API is called in debug mode. If yes, disable debug.
551: --disable_debug;

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

558: p_count => x_msg_count,
559: p_data => x_msg_data);
560:
561: -- Debug info.
562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
564: p_msg_data=>x_msg_data,
565: p_msg_type=>'UNEXPECTED ERROR',
566: p_msg_level=>fnd_log.level_error);

Line 566: p_msg_level=>fnd_log.level_error);

562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
564: p_msg_data=>x_msg_data,
565: p_msg_type=>'UNEXPECTED ERROR',
566: p_msg_level=>fnd_log.level_error);
567: END IF;
568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'update_style (-)',
570: p_prefix=>l_debug_prefix,

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

564: p_msg_data=>x_msg_data,
565: p_msg_type=>'UNEXPECTED ERROR',
566: p_msg_level=>fnd_log.level_error);
567: END IF;
568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'update_style (-)',
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);
572: END IF;

Line 571: p_msg_level=>fnd_log.level_procedure);

567: END IF;
568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'update_style (-)',
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);
572: END IF;
573:
574: -- Check if API is called in debug mode. If yes, disable debug.
575: --disable_debug;

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

587: p_count => x_msg_count,
588: p_data => x_msg_data);
589:
590: -- Debug info.
591: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'SQL ERROR',
595: p_msg_level=>fnd_log.level_error);

Line 595: p_msg_level=>fnd_log.level_error);

591: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'SQL ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'update_style (-)',
599: p_prefix=>l_debug_prefix,

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

593: p_msg_data=>x_msg_data,
594: p_msg_type=>'SQL ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'update_style (-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;

Line 600: p_msg_level=>fnd_log.level_procedure);

596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'update_style (-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:
603: -- Check if API is called in debug mode. If yes, disable debug.
604: --disable_debug;

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

650: -- Check if API is called in debug mode. If yes, enable debug.
651: --enable_debug;
652:
653: -- Debug info.
654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
655: hz_utility_v2pub.debug(p_message=>'get_style_rec (+)',
656: p_prefix=>l_debug_prefix,
657: p_msg_level=>fnd_log.level_procedure);
658: END IF;

Line 657: p_msg_level=>fnd_log.level_procedure);

653: -- Debug info.
654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
655: hz_utility_v2pub.debug(p_message=>'get_style_rec (+)',
656: p_prefix=>l_debug_prefix,
657: p_msg_level=>fnd_log.level_procedure);
658: END IF;
659:
660: -- Initialize message list if p_init_msg_list is set to TRUE.
661: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

676:
677: x_style_rec.style_code := p_style_code;
678:
679: -- Debug info.
680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
681: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.Select_Row (+)',
682: p_prefix=>l_debug_prefix,
683: p_msg_level=>fnd_log.level_procedure);
684: END IF;

Line 683: p_msg_level=>fnd_log.level_procedure);

679: -- Debug info.
680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
681: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.Select_Row (+)',
682: p_prefix=>l_debug_prefix,
683: p_msg_level=>fnd_log.level_procedure);
684: END IF;
685:
686: hz_styles_pkg.select_row (
687: x_style_code => x_style_rec.style_code,

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

690: x_description => x_style_rec.description
691: );
692:
693: -- Debug info.
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.select_row (-)',
696: p_prefix=>l_debug_prefix,
697: p_msg_level=>fnd_log.level_procedure);
698: END IF;

Line 697: p_msg_level=>fnd_log.level_procedure);

693: -- Debug info.
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'hz_styles_pkg.select_row (-)',
696: p_prefix=>l_debug_prefix,
697: p_msg_level=>fnd_log.level_procedure);
698: END IF;
699:
700: --Standard call to get message count and if count is 1, get message info.
701: fnd_msg_pub.count_and_get(

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

704: p_data => x_msg_data
705: );
706:
707: -- Debug info.
708: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
710: p_msg_data=>x_msg_data,
711: p_msg_type=>'WARNING',
712: p_msg_level=>fnd_log.level_exception);

Line 712: p_msg_level=>fnd_log.level_exception);

708: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
710: p_msg_data=>x_msg_data,
711: p_msg_type=>'WARNING',
712: p_msg_level=>fnd_log.level_exception);
713: END IF;
714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
716: p_prefix=>l_debug_prefix,

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

710: p_msg_data=>x_msg_data,
711: p_msg_type=>'WARNING',
712: p_msg_level=>fnd_log.level_exception);
713: END IF;
714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
716: p_prefix=>l_debug_prefix,
717: p_msg_level=>fnd_log.level_procedure);
718: END IF;

Line 717: p_msg_level=>fnd_log.level_procedure);

713: END IF;
714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
716: p_prefix=>l_debug_prefix,
717: p_msg_level=>fnd_log.level_procedure);
718: END IF;
719:
720: -- Check if API is called in debug mode. If yes, disable debug.
721: --disable_debug;

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

728: p_data => x_msg_data
729: );
730:
731: -- Debug info.
732: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
734: p_msg_data=>x_msg_data,
735: p_msg_type=>'ERROR',
736: p_msg_level=>fnd_log.level_error);

Line 736: p_msg_level=>fnd_log.level_error);

732: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
734: p_msg_data=>x_msg_data,
735: p_msg_type=>'ERROR',
736: p_msg_level=>fnd_log.level_error);
737: END IF;
738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
739: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
740: p_prefix=>l_debug_prefix,

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

734: p_msg_data=>x_msg_data,
735: p_msg_type=>'ERROR',
736: p_msg_level=>fnd_log.level_error);
737: END IF;
738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
739: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
740: p_prefix=>l_debug_prefix,
741: p_msg_level=>fnd_log.level_procedure);
742: END IF;

Line 741: p_msg_level=>fnd_log.level_procedure);

737: END IF;
738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
739: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
740: p_prefix=>l_debug_prefix,
741: p_msg_level=>fnd_log.level_procedure);
742: END IF;
743:
744: -- Check if API is called in debug mode. If yes, disable debug.
745: --disable_debug;

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

753: p_data => x_msg_data
754: );
755:
756: -- Debug info.
757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
759: p_msg_data=>x_msg_data,
760: p_msg_type=>'UNEXPECTED ERROR',
761: p_msg_level=>fnd_log.level_error);

Line 761: p_msg_level=>fnd_log.level_error);

757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
759: p_msg_data=>x_msg_data,
760: p_msg_type=>'UNEXPECTED ERROR',
761: p_msg_level=>fnd_log.level_error);
762: END IF;
763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
764: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
765: p_prefix=>l_debug_prefix,

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

759: p_msg_data=>x_msg_data,
760: p_msg_type=>'UNEXPECTED ERROR',
761: p_msg_level=>fnd_log.level_error);
762: END IF;
763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
764: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
765: p_prefix=>l_debug_prefix,
766: p_msg_level=>fnd_log.level_procedure);
767: END IF;

Line 766: p_msg_level=>fnd_log.level_procedure);

762: END IF;
763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
764: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
765: p_prefix=>l_debug_prefix,
766: p_msg_level=>fnd_log.level_procedure);
767: END IF;
768:
769: -- Check if API is called in debug mode. If yes, disable debug.
770: --disable_debug;

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

782: p_data => x_msg_data
783: );
784:
785: -- Debug info.
786: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
787: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
788: p_msg_data=>x_msg_data,
789: p_msg_type=>'SQL ERROR',
790: p_msg_level=>fnd_log.level_error);

Line 790: p_msg_level=>fnd_log.level_error);

786: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
787: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
788: p_msg_data=>x_msg_data,
789: p_msg_type=>'SQL ERROR',
790: p_msg_level=>fnd_log.level_error);
791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
794: p_prefix=>l_debug_prefix,

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

788: p_msg_data=>x_msg_data,
789: p_msg_type=>'SQL ERROR',
790: p_msg_level=>fnd_log.level_error);
791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
794: p_prefix=>l_debug_prefix,
795: p_msg_level=>fnd_log.level_procedure);
796: END IF;

Line 795: p_msg_level=>fnd_log.level_procedure);

791: END IF;
792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'get_style_rec (-)',
794: p_prefix=>l_debug_prefix,
795: p_msg_level=>fnd_log.level_procedure);
796: END IF;
797:
798: -- Check if API is called in debug mode. If yes, disable debug.
799: --disable_debug;