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;
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(
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;
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,
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);
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: /**
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;
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
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;
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 (
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;
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
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;
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:
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;
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
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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;
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
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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;
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
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;
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,
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;
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(
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;
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);
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,
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;
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;