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

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

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

Line 114: p_msg_level=>fnd_log.level_procedure);

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

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

149: END;
150:
151:
152: -- Debug info.
153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.insert_row (+)',
155: p_prefix=>l_debug_prefix,
156: p_msg_level=>fnd_log.level_procedure);
157: END IF;

Line 156: p_msg_level=>fnd_log.level_procedure);

152: -- Debug info.
153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.insert_row (+)',
155: p_prefix=>l_debug_prefix,
156: p_msg_level=>fnd_log.level_procedure);
157: END IF;
158:
159: HZ_STYLE_FORMATS_PKG.insert_row (
160: X_ROWID => l_rowid,

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

166: x_object_version_number => 1
167: );
168:
169: -- Debug info.
170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
171: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.insert_row (-) ' ||
172: 'p_style_format_rec.style_format_code = ' || p_style_format_rec.style_format_code,
173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);

Line 174: p_msg_level=>fnd_log.level_procedure);

170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
171: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.insert_row (-) ' ||
172: 'p_style_format_rec.style_format_code = ' || p_style_format_rec.style_format_code,
173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: hz_utility_v2pub.debug(p_message=>'do_create_style_format (-)',
176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178:

Line 177: p_msg_level=>fnd_log.level_procedure);

173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: hz_utility_v2pub.debug(p_message=>'do_create_style_format (-)',
176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178:
179: END IF;
180: END do_create_style_format;
181:

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

204: BEGIN
205:
206: -- Debug info.
207:
208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
209: hz_utility_v2pub.debug(p_message=>'do_update_style_format (+)',
210: p_prefix=>l_debug_prefix,
211: p_msg_level=>fnd_log.level_procedure);
212: END IF;

Line 211: p_msg_level=>fnd_log.level_procedure);

207:
208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
209: hz_utility_v2pub.debug(p_message=>'do_update_style_format (+)',
210: p_prefix=>l_debug_prefix,
211: p_msg_level=>fnd_log.level_procedure);
212: END IF;
213:
214: -- check whether record has been updated by another user
215: BEGIN

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

284:
285: END IF;
286:
287: -- Debug info.
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FORMATS_PKG.Update_Row (+)',
290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;

Line 291: p_msg_level=>fnd_log.level_procedure);

287: -- Debug info.
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FORMATS_PKG.Update_Row (+)',
290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;
293:
294: -- call table handler to update a row
295: HZ_STYLE_FORMATS_PKG.Update_Row (

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

301: X_OBJECT_VERSION_NUMBER => p_object_version_number
302: );
303:
304: -- Debug info.
305: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
306: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FORMATS_PKG.Update_Row (-)',
307: p_prefix=>l_debug_prefix,
308: p_msg_level=>fnd_log.level_procedure);
309: END IF;

Line 308: p_msg_level=>fnd_log.level_procedure);

304: -- Debug info.
305: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
306: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FORMATS_PKG.Update_Row (-)',
307: p_prefix=>l_debug_prefix,
308: p_msg_level=>fnd_log.level_procedure);
309: END IF;
310:
311: -- Debug info.
312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

308: p_msg_level=>fnd_log.level_procedure);
309: END IF;
310:
311: -- Debug info.
312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
313: hz_utility_v2pub.debug(p_message=>'do_update_style_format (-)',
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=>'do_update_style_format (-)',
314: p_prefix=>l_debug_prefix,
315: p_msg_level=>fnd_log.level_procedure);
316: END IF;
317:
318: END do_update_style_format;
319:

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

369: -- Check if API is called in debug mode. If yes, enable debug.
370: --enable_debug;
371:
372: -- Debug info.
373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
374: hz_utility_v2pub.debug(p_message=>'create_style_format (+)',
375: p_prefix=>l_debug_prefix,
376: p_msg_level=>fnd_log.level_procedure);
377: END IF;

Line 376: p_msg_level=>fnd_log.level_procedure);

372: -- Debug info.
373: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
374: hz_utility_v2pub.debug(p_message=>'create_style_format (+)',
375: p_prefix=>l_debug_prefix,
376: p_msg_level=>fnd_log.level_procedure);
377: END IF;
378:
379: -- initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397: -- Debug info.
398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);

Line 402: p_msg_level=>fnd_log.level_exception);

398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);
403: END IF;
404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
406: p_prefix=>l_debug_prefix,

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

400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);
403: END IF;
404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
406: p_prefix=>l_debug_prefix,
407: p_msg_level=>fnd_log.level_procedure);
408: END IF;

Line 407: p_msg_level=>fnd_log.level_procedure);

403: END IF;
404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
406: p_prefix=>l_debug_prefix,
407: p_msg_level=>fnd_log.level_procedure);
408: END IF;
409:
410: -- Check if API is called in debug mode. If yes, disable debug.
411: --disable_debug;

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

419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: -- Debug info.
423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
425: p_msg_data=>x_msg_data,
426: p_msg_type=>'ERROR',
427: p_msg_level=>fnd_log.level_error);

Line 427: p_msg_level=>fnd_log.level_error);

423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
425: p_msg_data=>x_msg_data,
426: p_msg_type=>'ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
431: p_prefix=>l_debug_prefix,

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

425: p_msg_data=>x_msg_data,
426: p_msg_type=>'ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;

Line 432: p_msg_level=>fnd_log.level_procedure);

428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434:
435: -- Check if API is called in debug mode. If yes, disable debug.
436: --disable_debug;

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

443: p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: -- Debug info.
447: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
449: p_msg_data=>x_msg_data,
450: p_msg_type=>'UNEXPECTED ERROR',
451: p_msg_level=>fnd_log.level_error);

Line 451: p_msg_level=>fnd_log.level_error);

447: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
449: p_msg_data=>x_msg_data,
450: p_msg_type=>'UNEXPECTED ERROR',
451: p_msg_level=>fnd_log.level_error);
452: END IF;
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
455: p_prefix=>l_debug_prefix,

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

449: p_msg_data=>x_msg_data,
450: p_msg_type=>'UNEXPECTED ERROR',
451: p_msg_level=>fnd_log.level_error);
452: END IF;
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;

Line 456: p_msg_level=>fnd_log.level_procedure);

452: END IF;
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Check if API is called in debug mode. If yes, disable debug.
460: --disable_debug;

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

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

Line 480: p_msg_level=>fnd_log.level_error);

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

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

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

Line 485: p_msg_level=>fnd_log.level_procedure);

481: END IF;
482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(p_message=>'create_style_format (-)',
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;
487:
488: -- Check if API is called in debug mode. If yes, disable debug.
489: --disable_debug;

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

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

Line 550: p_msg_level=>fnd_log.level_procedure);

546: -- Debug info.
547: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
548: hz_utility_v2pub.debug(p_message=>'update_style_format (+)',
549: p_prefix=>l_debug_prefix,
550: p_msg_level=>fnd_log.level_procedure);
551: END IF;
552:
553: -- initialize message list if p_init_msg_list is set to TRUE.
554: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

570: p_count => x_msg_count,
571: p_data => x_msg_data);
572:
573: -- Debug info.
574: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'WARNING',
578: p_msg_level=>fnd_log.level_exception);

Line 578: p_msg_level=>fnd_log.level_exception);

574: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'WARNING',
578: p_msg_level=>fnd_log.level_exception);
579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
582: p_prefix=>l_debug_prefix,

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

576: p_msg_data=>x_msg_data,
577: p_msg_type=>'WARNING',
578: p_msg_level=>fnd_log.level_exception);
579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;

Line 583: p_msg_level=>fnd_log.level_procedure);

579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585:
586: -- Check if API is called in debug mode. If yes, disable debug.
587: --disable_debug;

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

595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.
599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);

Line 603: p_msg_level=>fnd_log.level_error);

599: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
607: p_prefix=>l_debug_prefix,

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

601: p_msg_data=>x_msg_data,
602: p_msg_type=>'ERROR',
603: p_msg_level=>fnd_log.level_error);
604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;

Line 608: p_msg_level=>fnd_log.level_procedure);

604: END IF;
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610:
611: -- Check if API is called in debug mode. If yes, disable debug.
612: --disable_debug;

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

619: p_count => x_msg_count,
620: p_data => x_msg_data);
621:
622: -- Debug info.
623: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
625: p_msg_data=>x_msg_data,
626: p_msg_type=>'UNEXPECTED ERROR',
627: p_msg_level=>fnd_log.level_error);

Line 627: p_msg_level=>fnd_log.level_error);

623: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
625: p_msg_data=>x_msg_data,
626: p_msg_type=>'UNEXPECTED ERROR',
627: p_msg_level=>fnd_log.level_error);
628: END IF;
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
631: p_prefix=>l_debug_prefix,

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

625: p_msg_data=>x_msg_data,
626: p_msg_type=>'UNEXPECTED ERROR',
627: p_msg_level=>fnd_log.level_error);
628: END IF;
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
631: p_prefix=>l_debug_prefix,
632: p_msg_level=>fnd_log.level_procedure);
633: END IF;

Line 632: p_msg_level=>fnd_log.level_procedure);

628: END IF;
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
631: p_prefix=>l_debug_prefix,
632: p_msg_level=>fnd_log.level_procedure);
633: END IF;
634:
635: -- Check if API is called in debug mode. If yes, disable debug.
636: --disable_debug;

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

648: p_count => x_msg_count,
649: p_data => x_msg_data);
650:
651: -- Debug info.
652: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
654: p_msg_data=>x_msg_data,
655: p_msg_type=>'SQL ERROR',
656: p_msg_level=>fnd_log.level_error);

Line 656: p_msg_level=>fnd_log.level_error);

652: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
654: p_msg_data=>x_msg_data,
655: p_msg_type=>'SQL ERROR',
656: p_msg_level=>fnd_log.level_error);
657: END IF;
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
660: p_prefix=>l_debug_prefix,

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

654: p_msg_data=>x_msg_data,
655: p_msg_type=>'SQL ERROR',
656: p_msg_level=>fnd_log.level_error);
657: END IF;
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;

Line 661: p_msg_level=>fnd_log.level_procedure);

657: END IF;
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'update_style_format (-)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;
663:
664: -- Check if API is called in debug mode. If yes, disable debug.
665: --disable_debug;

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

712: -- Check if API is called in debug mode. If yes, enable debug.
713: --enable_debug;
714:
715: -- Debug info.
716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
717: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (+)',
718: p_prefix=>l_debug_prefix,
719: p_msg_level=>fnd_log.level_procedure);
720: END IF;

Line 719: p_msg_level=>fnd_log.level_procedure);

715: -- Debug info.
716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
717: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (+)',
718: p_prefix=>l_debug_prefix,
719: p_msg_level=>fnd_log.level_procedure);
720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

738:
739: x_style_format_rec.style_format_code := p_style_format_code;
740:
741: -- Debug info.
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.Select_Row (+)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;

Line 745: p_msg_level=>fnd_log.level_procedure);

741: -- Debug info.
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.Select_Row (+)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747:
748: hz_style_formats_pkg.select_row (
749: X_STYLE_FORMAT_CODE => x_style_format_rec.style_format_code,

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

753: X_DESCRIPTION => x_style_format_rec.description
754: );
755:
756: -- Debug info.
757: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.select_row (-)',
759: p_prefix=>l_debug_prefix,
760: p_msg_level=>fnd_log.level_procedure);
761: END IF;

Line 760: p_msg_level=>fnd_log.level_procedure);

756: -- Debug info.
757: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug(p_message=>'hz_style_formats_pkg.select_row (-)',
759: p_prefix=>l_debug_prefix,
760: p_msg_level=>fnd_log.level_procedure);
761: END IF;
762:
763: --Standard call to get message count and if count is 1, get message info.
764: fnd_msg_pub.count_and_get(

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

767: p_data => x_msg_data
768: );
769:
770: -- Debug info.
771: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
773: p_msg_data=>x_msg_data,
774: p_msg_type=>'WARNING',
775: p_msg_level=>fnd_log.level_exception);

Line 775: p_msg_level=>fnd_log.level_exception);

771: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
773: p_msg_data=>x_msg_data,
774: p_msg_type=>'WARNING',
775: p_msg_level=>fnd_log.level_exception);
776: END IF;
777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
779: p_prefix=>l_debug_prefix,

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

773: p_msg_data=>x_msg_data,
774: p_msg_type=>'WARNING',
775: p_msg_level=>fnd_log.level_exception);
776: END IF;
777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
779: p_prefix=>l_debug_prefix,
780: p_msg_level=>fnd_log.level_procedure);
781: END IF;

Line 780: p_msg_level=>fnd_log.level_procedure);

776: END IF;
777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
779: p_prefix=>l_debug_prefix,
780: p_msg_level=>fnd_log.level_procedure);
781: END IF;
782:
783: -- Check if API is called in debug mode. If yes, disable debug.
784: --disable_debug;

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

791: p_data => x_msg_data
792: );
793:
794: -- Debug info.
795: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
797: p_msg_data=>x_msg_data,
798: p_msg_type=>'ERROR',
799: p_msg_level=>fnd_log.level_error);

Line 799: p_msg_level=>fnd_log.level_error);

795: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
797: p_msg_data=>x_msg_data,
798: p_msg_type=>'ERROR',
799: p_msg_level=>fnd_log.level_error);
800: END IF;
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
802: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
803: p_prefix=>l_debug_prefix,

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

797: p_msg_data=>x_msg_data,
798: p_msg_type=>'ERROR',
799: p_msg_level=>fnd_log.level_error);
800: END IF;
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
802: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
803: p_prefix=>l_debug_prefix,
804: p_msg_level=>fnd_log.level_procedure);
805: END IF;

Line 804: p_msg_level=>fnd_log.level_procedure);

800: END IF;
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
802: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
803: p_prefix=>l_debug_prefix,
804: p_msg_level=>fnd_log.level_procedure);
805: END IF;
806:
807: -- Check if API is called in debug mode. If yes, disable debug.
808: --disable_debug;

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

816: p_data => x_msg_data
817: );
818:
819: -- Debug info.
820: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
822: p_msg_data=>x_msg_data,
823: p_msg_type=>'UNEXPECTED ERROR',
824: p_msg_level=>fnd_log.level_error);

Line 824: p_msg_level=>fnd_log.level_error);

820: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
822: p_msg_data=>x_msg_data,
823: p_msg_type=>'UNEXPECTED ERROR',
824: p_msg_level=>fnd_log.level_error);
825: END IF;
826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
828: p_prefix=>l_debug_prefix,

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

822: p_msg_data=>x_msg_data,
823: p_msg_type=>'UNEXPECTED ERROR',
824: p_msg_level=>fnd_log.level_error);
825: END IF;
826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
828: p_prefix=>l_debug_prefix,
829: p_msg_level=>fnd_log.level_procedure);
830: END IF;

Line 829: p_msg_level=>fnd_log.level_procedure);

825: END IF;
826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
828: p_prefix=>l_debug_prefix,
829: p_msg_level=>fnd_log.level_procedure);
830: END IF;
831:
832:
833: -- Check if API is called in debug mode. If yes, disable debug.

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

846: p_data => x_msg_data
847: );
848:
849: -- Debug info.
850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);

Line 854: p_msg_level=>fnd_log.level_error);

850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
858: p_prefix=>l_debug_prefix,

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

852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;

Line 859: p_msg_level=>fnd_log.level_procedure);

855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_style_format_rec (-)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
861:
862: -- Check if API is called in debug mode. If yes, disable debug.
863: --disable_debug;