APPS.HZ_STYLE_FMT_LOCALE_V2PUB dependencies on HZ_STYLE_FMT_LOCALES

Line 138: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.insert_row (+)',

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:

Line 143: 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:
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,

Line 156: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.insert_row (-) ' ||

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 (-)',

Line 202: FROM HZ_STYLE_FMT_LOCALES

198: BEGIN
199: -- check last update date.
200: SELECT object_version_number, rowid
201: INTO l_object_version_number, l_rowid
202: FROM HZ_STYLE_FMT_LOCALES
203: WHERE style_fmt_locale_id = p_style_fmt_locale_rec.style_fmt_locale_id
204: FOR UPDATE of style_fmt_locale_id NOWAIT;
205:
206: IF NOT (

Line 213: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_locales');

209: l_object_version_number IS NOT NULL AND
210: p_object_version_number = l_object_version_number ) )
211: THEN
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
213: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_locales');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:

Line 241: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LOCALES_PKG.Update_Row (+)',

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:

Line 247: HZ_STYLE_FMT_LOCALES_PKG.Update_Row (

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,

Line 259: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LOCALES_PKG.Update_Row (-)',

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:

Line 702: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.Select_Row (+)',

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:

Line 707: 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:
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,

Line 718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_locales_pkg.select_row (-)',

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: