134: END IF;
135:
136: -- Debug info.
137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
138: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.insert_row (+)',
139: p_prefix=>l_debug_prefix,
140: p_msg_level=>fnd_log.level_procedure);
141: END IF;
142:
139: p_prefix=>l_debug_prefix,
140: p_msg_level=>fnd_log.level_procedure);
141: END IF;
142:
143: HZ_STYLE_FMT_LOCALES_PKG.insert_row (
144: X_ROWID => l_rowid,
145: X_STYLE_FMT_LOCALE_ID => p_style_fmt_locale_rec.style_fmt_locale_id,
146: X_STYLE_FORMAT_CODE => p_style_fmt_locale_rec.style_format_code,
147: X_LANGUAGE_CODE => p_style_fmt_locale_rec.language_code,
152: );
153:
154: -- Debug info.
155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
156: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.insert_row (-) ' ||
157: 'p_style_fmt_locale_rec.style_fmt_locale_id = ' || p_style_fmt_locale_rec.style_fmt_locale_id,
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);
160: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_locale (-)',
237: END IF;
238:
239: -- Debug info.
240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LOCALES_PKG.Update_Row (+)',
242: p_prefix=>l_debug_prefix,
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
245:
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
245:
246: -- call table handler to update a row
247: HZ_STYLE_FMT_LOCALES_PKG.Update_Row (
248: X_STYLE_FMT_LOCALE_ID => p_style_fmt_locale_rec.style_fmt_locale_id,
249: X_STYLE_FORMAT_CODE => p_style_fmt_locale_rec.style_format_code,
250: X_LANGUAGE_CODE => p_style_fmt_locale_rec.language_code,
251: X_TERRITORY_CODE => p_style_fmt_locale_rec.territory_code,
255: );
256:
257: -- Debug info.
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LOCALES_PKG.Update_Row (-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263:
698: x_style_fmt_locale_rec.style_fmt_locale_id := p_style_fmt_locale_id;
699:
700: -- Debug info.
701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
702: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.Select_Row (+)',
703: p_prefix=>l_debug_prefix,
704: p_msg_level=>fnd_log.level_procedure);
705: END IF;
706:
703: p_prefix=>l_debug_prefix,
704: p_msg_level=>fnd_log.level_procedure);
705: END IF;
706:
707: hz_style_fmt_locales_pkg.select_row (
708: X_STYLE_FMT_LOCALE_ID => x_style_fmt_locale_rec.style_fmt_locale_id,
709: X_STYLE_FORMAT_CODE => x_style_fmt_locale_rec.style_format_code,
710: X_LANGUAGE_CODE => x_style_fmt_locale_rec.language_code,
711: X_TERRITORY_CODE => x_style_fmt_locale_rec.territory_code,
714: );
715:
716: -- Debug info.
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.select_row (-)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722: