DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_VARIATION_V2PUB dependencies on HZ_STYLE_FMT_VARIATIONS

Line 137: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (+)',

133: END IF;
134:
135: -- Debug info.
136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
137: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (+)',
138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:

Line 142: HZ_STYLE_FMT_VARIATIONS_PKG.insert_row (

138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:
142: HZ_STYLE_FMT_VARIATIONS_PKG.insert_row (
143: X_ROWID => l_rowid,
144: X_STYLE_FORMAT_CODE => p_style_fmt_variation_rec.style_format_code,
145: X_VARIATION_NUMBER => p_style_fmt_variation_rec.variation_number,
146: X_VARIATION_RANK => p_style_fmt_variation_rec.variation_rank,

Line 155: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||

151: );
152:
153: -- Debug info.
154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
155: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||
156: 'p_style_fmt_variation_rec.style_format_code = ' || p_style_fmt_variation_rec.style_format_code ||
157: 'p_style_fmt_variation_rec.variation_number = ' || p_style_fmt_variation_rec.variation_number,
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);

Line 187: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%type;

183: l_object_version_number NUMBER;
184: l_debug_prefix VARCHAR2(30) := '';
185: l_rowid ROWID;
186:
187: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%type;
188: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%type;
189:
190: BEGIN
191:

Line 188: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%type;

184: l_debug_prefix VARCHAR2(30) := '';
185: l_rowid ROWID;
186:
187: l_style_format_code HZ_STYLE_FMT_VARIATIONS.style_format_code%type;
188: l_variation_number HZ_STYLE_FMT_VARIATIONS.variation_number%type;
189:
190: BEGIN
191:
192: -- Debug info.

Line 206: FROM HZ_STYLE_FMT_VARIATIONS

202: SELECT object_version_number, rowid,
203: style_format_code, variation_number
204: INTO l_object_version_number, l_rowid,
205: l_style_format_code, l_variation_number
206: FROM HZ_STYLE_FMT_VARIATIONS
207: WHERE style_format_code = p_style_fmt_variation_rec.style_format_code
208: AND variation_number = p_style_fmt_variation_rec.variation_number
209: FOR UPDATE of style_format_code, variation_number NOWAIT;
210:

Line 218: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_variations');

214: l_object_version_number IS NOT NULL AND
215: p_object_version_number = l_object_version_number ) )
216: THEN
217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
218: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_variations');
219: FND_MSG_PUB.ADD;
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:

Line 247: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (+)',

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

Line 253: HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (

249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:
252: -- call table handler to update a row
253: HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (
254: X_STYLE_FORMAT_CODE => p_style_fmt_variation_rec.style_format_code,
255: X_VARIATION_NUMBER => p_style_fmt_variation_rec.variation_number,
256: X_VARIATION_RANK => p_style_fmt_variation_rec.variation_rank,
257: X_SELECTION_CONDITION => p_style_fmt_variation_rec.selection_condition,

Line 265: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',

261: );
262:
263: -- Debug info.
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;
269:

Line 718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.Select_Row (+)',

714: x_style_fmt_variation_rec.variation_number := p_variation_number;
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_variations_pkg.Select_Row (+)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:

Line 723: hz_style_fmt_variations_pkg.select_row (

719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:
723: hz_style_fmt_variations_pkg.select_row (
724: X_STYLE_FORMAT_CODE => x_style_fmt_variation_rec.style_format_code,
725: X_VARIATION_NUMBER => x_style_fmt_variation_rec.variation_number,
726: X_VARIATION_RANK => x_style_fmt_variation_rec.variation_rank,
727: X_SELECTION_CONDITION => x_style_fmt_variation_rec.selection_condition,

Line 734: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.select_row (-)',

730: );
731:
732: -- Debug info.
733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
734: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.select_row (-)',
735: p_prefix=>l_debug_prefix,
736: p_msg_level=>fnd_log.level_procedure);
737: END IF;
738: