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

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

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

Line 113: p_msg_level=>fnd_log.level_procedure);

109: -- Debug info.
110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
111: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_variation (+)',
112: p_prefix=>l_debug_prefix,
113: p_msg_level=>fnd_log.level_procedure);
114: END IF;
115:
116: -- start_date_active default to sysdate
117: IF p_style_fmt_variation_rec.start_date_active is null OR

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

132: RAISE fnd_api.g_exc_error;
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;

Line 139: p_msg_level=>fnd_log.level_procedure);

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:
142: HZ_STYLE_FMT_VARIATIONS_PKG.insert_row (
143: X_ROWID => l_rowid,

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

150: X_OBJECT_VERSION_NUMBER => 1
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,

Line 159: p_msg_level=>fnd_log.level_procedure);

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);
160: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_variation (-)',
161: p_prefix=>l_debug_prefix,
162: p_msg_level=>fnd_log.level_procedure);
163: END IF;

Line 162: p_msg_level=>fnd_log.level_procedure);

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_variation (-)',
161: p_prefix=>l_debug_prefix,
162: p_msg_level=>fnd_log.level_procedure);
163: END IF;
164:
165: END do_create_style_fmt_variation;
166:

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

189:
190: BEGIN
191:
192: -- Debug info.
193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (+)',
195: p_prefix=>l_debug_prefix,
196: p_msg_level=>fnd_log.level_procedure);
197: END IF;

Line 196: p_msg_level=>fnd_log.level_procedure);

192: -- Debug info.
193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (+)',
195: p_prefix=>l_debug_prefix,
196: p_msg_level=>fnd_log.level_procedure);
197: END IF;
198:
199: -- check whether record has been updated by another user
200: BEGIN

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

242: RAISE FND_API.G_EXC_ERROR;
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;

Line 249: p_msg_level=>fnd_log.level_procedure);

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:
252: -- call table handler to update a row
253: HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (

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

260: X_OBJECT_VERSION_NUMBER => p_object_version_number
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;

Line 267: p_msg_level=>fnd_log.level_procedure);

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:
270: IF p_style_fmt_variation_rec.end_date_active is not null AND
271: p_style_fmt_variation_rec.end_date_active <> fnd_api.g_miss_date THEN

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

277:
278: END IF;
279:
280: -- Debug info.
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (-)',
283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;

Line 284: p_msg_level=>fnd_log.level_procedure);

280: -- Debug info.
281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (-)',
283: p_prefix=>l_debug_prefix,
284: p_msg_level=>fnd_log.level_procedure);
285: END IF;
286:
287: END do_update_style_fmt_variation;
288:

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

339: -- Check if API is called in debug mode. If yes, enable debug.
340: --enable_debug;
341:
342: -- Debug info.
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (+)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;

Line 346: p_msg_level=>fnd_log.level_procedure);

342: -- Debug info.
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (+)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;
348:
349: -- initialize message list if p_init_msg_list is set to TRUE.
350: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data);
367: -- Debug info.
368: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
370: p_msg_data=>x_msg_data,
371: p_msg_type=>'WARNING',
372: p_msg_level=>fnd_log.level_exception);

Line 372: p_msg_level=>fnd_log.level_exception);

368: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
370: p_msg_data=>x_msg_data,
371: p_msg_type=>'WARNING',
372: p_msg_level=>fnd_log.level_exception);
373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
376: p_prefix=>l_debug_prefix,

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

370: p_msg_data=>x_msg_data,
371: p_msg_type=>'WARNING',
372: p_msg_level=>fnd_log.level_exception);
373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: END IF;

Line 377: p_msg_level=>fnd_log.level_procedure);

373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: END IF;
379:
380: -- Check if API is called in debug mode. If yes, disable debug.
381: --disable_debug;

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

389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:
392: -- Debug info.
393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
395: p_msg_data=>x_msg_data,
396: p_msg_type=>'ERROR',
397: p_msg_level=>fnd_log.level_error);

Line 397: p_msg_level=>fnd_log.level_error);

393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
395: p_msg_data=>x_msg_data,
396: p_msg_type=>'ERROR',
397: p_msg_level=>fnd_log.level_error);
398: END IF;
399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
400: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
401: p_prefix=>l_debug_prefix,

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

395: p_msg_data=>x_msg_data,
396: p_msg_type=>'ERROR',
397: p_msg_level=>fnd_log.level_error);
398: END IF;
399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
400: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
401: p_prefix=>l_debug_prefix,
402: p_msg_level=>fnd_log.level_procedure);
403: END IF;

Line 402: p_msg_level=>fnd_log.level_procedure);

398: END IF;
399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
400: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
401: p_prefix=>l_debug_prefix,
402: p_msg_level=>fnd_log.level_procedure);
403: END IF;
404:
405: -- Check if API is called in debug mode. If yes, disable debug.
406: --disable_debug;

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

413: p_count => x_msg_count,
414: p_data => x_msg_data);
415:
416: -- Debug info.
417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
419: p_msg_data=>x_msg_data,
420: p_msg_type=>'UNEXPECTED ERROR',
421: p_msg_level=>fnd_log.level_error);

Line 421: p_msg_level=>fnd_log.level_error);

417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
419: p_msg_data=>x_msg_data,
420: p_msg_type=>'UNEXPECTED ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
425: p_prefix=>l_debug_prefix,

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

419: p_msg_data=>x_msg_data,
420: p_msg_type=>'UNEXPECTED ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
425: p_prefix=>l_debug_prefix,
426: p_msg_level=>fnd_log.level_procedure);
427: END IF;

Line 426: p_msg_level=>fnd_log.level_procedure);

422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
425: p_prefix=>l_debug_prefix,
426: p_msg_level=>fnd_log.level_procedure);
427: END IF;
428:
429: -- Check if API is called in debug mode. If yes, disable debug.
430: --disable_debug;

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

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

Line 450: p_msg_level=>fnd_log.level_error);

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

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

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

Line 455: p_msg_level=>fnd_log.level_procedure);

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

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

514: -- Check if API is called in debug mode. If yes, enable debug.
515: --enable_debug;
516:
517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;

Line 521: p_msg_level=>fnd_log.level_procedure);

517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;
523:
524: -- initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

541: p_count => x_msg_count,
542: p_data => x_msg_data);
543:
544: -- Debug info.
545: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
546: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
547: p_msg_data=>x_msg_data,
548: p_msg_type=>'WARNING',
549: p_msg_level=>fnd_log.level_exception);

Line 549: p_msg_level=>fnd_log.level_exception);

545: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
546: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
547: p_msg_data=>x_msg_data,
548: p_msg_type=>'WARNING',
549: p_msg_level=>fnd_log.level_exception);
550: END IF;
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
553: p_prefix=>l_debug_prefix,

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

547: p_msg_data=>x_msg_data,
548: p_msg_type=>'WARNING',
549: p_msg_level=>fnd_log.level_exception);
550: END IF;
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
553: p_prefix=>l_debug_prefix,
554: p_msg_level=>fnd_log.level_procedure);
555: END IF;

Line 554: p_msg_level=>fnd_log.level_procedure);

550: END IF;
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
553: p_prefix=>l_debug_prefix,
554: p_msg_level=>fnd_log.level_procedure);
555: END IF;
556:
557: -- Check if API is called in debug mode. If yes, disable debug.
558: --disable_debug;

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

566: p_count => x_msg_count,
567: p_data => x_msg_data);
568:
569: -- Debug info.
570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
571: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
572: p_msg_data=>x_msg_data,
573: p_msg_type=>'ERROR',
574: p_msg_level=>fnd_log.level_error);

Line 574: p_msg_level=>fnd_log.level_error);

570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
571: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
572: p_msg_data=>x_msg_data,
573: p_msg_type=>'ERROR',
574: p_msg_level=>fnd_log.level_error);
575: END IF;
576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
578: p_prefix=>l_debug_prefix,

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

572: p_msg_data=>x_msg_data,
573: p_msg_type=>'ERROR',
574: p_msg_level=>fnd_log.level_error);
575: END IF;
576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
578: p_prefix=>l_debug_prefix,
579: p_msg_level=>fnd_log.level_procedure);
580: END IF;

Line 579: p_msg_level=>fnd_log.level_procedure);

575: END IF;
576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
578: p_prefix=>l_debug_prefix,
579: p_msg_level=>fnd_log.level_procedure);
580: END IF;
581:
582: -- Check if API is called in debug mode. If yes, disable debug.
583: --disable_debug;

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

590: p_count => x_msg_count,
591: p_data => x_msg_data);
592:
593: -- Debug info.
594: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
596: p_msg_data=>x_msg_data,
597: p_msg_type=>'UNEXPECTED ERROR',
598: p_msg_level=>fnd_log.level_error);

Line 598: p_msg_level=>fnd_log.level_error);

594: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
596: p_msg_data=>x_msg_data,
597: p_msg_type=>'UNEXPECTED ERROR',
598: p_msg_level=>fnd_log.level_error);
599: END IF;
600: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
601: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
602: p_prefix=>l_debug_prefix,

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

596: p_msg_data=>x_msg_data,
597: p_msg_type=>'UNEXPECTED ERROR',
598: p_msg_level=>fnd_log.level_error);
599: END IF;
600: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
601: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
602: p_prefix=>l_debug_prefix,
603: p_msg_level=>fnd_log.level_procedure);
604: END IF;

Line 603: p_msg_level=>fnd_log.level_procedure);

599: END IF;
600: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
601: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
602: p_prefix=>l_debug_prefix,
603: p_msg_level=>fnd_log.level_procedure);
604: END IF;
605:
606: -- Check if API is called in debug mode. If yes, disable debug.
607: --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=>'SQL 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=>'SQL 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_fmt_variation (-)',
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=>'SQL 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_fmt_variation (-)',
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_fmt_variation (-)',
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 688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

684: -- Check if API is called in debug mode. If yes, enable debug.
685: --enable_debug;
686:
687: -- Debug info.
688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (+)',
690: p_prefix=>l_debug_prefix,
691: p_msg_level=>fnd_log.level_procedure);
692: END IF;

Line 691: p_msg_level=>fnd_log.level_procedure);

687: -- Debug info.
688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (+)',
690: p_prefix=>l_debug_prefix,
691: p_msg_level=>fnd_log.level_procedure);
692: END IF;
693:
694: -- Initialize message list if p_init_msg_list is set to TRUE.
695: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

713: x_style_fmt_variation_rec.style_format_code := p_style_format_code;
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;

Line 720: p_msg_level=>fnd_log.level_procedure);

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:
723: hz_style_fmt_variations_pkg.select_row (
724: X_STYLE_FORMAT_CODE => x_style_fmt_variation_rec.style_format_code,

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

729: X_END_DATE_ACTIVE => x_style_fmt_variation_rec.end_date_active
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;

Line 736: p_msg_level=>fnd_log.level_procedure);

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:
739: --Standard call to get message count and if count is 1, get message info.
740: fnd_msg_pub.count_and_get(

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

743: p_data => x_msg_data
744: );
745:
746: -- Debug info.
747: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
748: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
749: p_msg_data=>x_msg_data,
750: p_msg_type=>'WARNING',
751: p_msg_level=>fnd_log.level_exception);

Line 751: p_msg_level=>fnd_log.level_exception);

747: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
748: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
749: p_msg_data=>x_msg_data,
750: p_msg_type=>'WARNING',
751: p_msg_level=>fnd_log.level_exception);
752: END IF;
753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
755: p_prefix=>l_debug_prefix,

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

749: p_msg_data=>x_msg_data,
750: p_msg_type=>'WARNING',
751: p_msg_level=>fnd_log.level_exception);
752: END IF;
753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
755: p_prefix=>l_debug_prefix,
756: p_msg_level=>fnd_log.level_procedure);
757: END IF;

Line 756: p_msg_level=>fnd_log.level_procedure);

752: END IF;
753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
755: p_prefix=>l_debug_prefix,
756: p_msg_level=>fnd_log.level_procedure);
757: END IF;
758:
759: -- Check if API is called in debug mode. If yes, disable debug.
760: --disable_debug;

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

767: p_data => x_msg_data
768: );
769:
770: -- Debug info.
771: IF fnd_log.level_error>=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=>'ERROR',
775: p_msg_level=>fnd_log.level_error);

Line 775: p_msg_level=>fnd_log.level_error);

771: IF fnd_log.level_error>=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=>'ERROR',
775: p_msg_level=>fnd_log.level_error);
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_fmt_variation_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=>'ERROR',
775: p_msg_level=>fnd_log.level_error);
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_fmt_variation_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_fmt_variation_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 796: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 800: p_msg_level=>fnd_log.level_error);

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

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

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

Line 805: p_msg_level=>fnd_log.level_procedure);

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

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

821: p_data => x_msg_data
822: );
823:
824: -- Debug info.
825: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
826: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
827: p_msg_data=>x_msg_data,
828: p_msg_type=>'SQL ERROR',
829: p_msg_level=>fnd_log.level_error);

Line 829: p_msg_level=>fnd_log.level_error);

825: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
826: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
827: p_msg_data=>x_msg_data,
828: p_msg_type=>'SQL ERROR',
829: p_msg_level=>fnd_log.level_error);
830: END IF;
831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
833: p_prefix=>l_debug_prefix,

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

827: p_msg_data=>x_msg_data,
828: p_msg_type=>'SQL ERROR',
829: p_msg_level=>fnd_log.level_error);
830: END IF;
831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
833: p_prefix=>l_debug_prefix,
834: p_msg_level=>fnd_log.level_procedure);
835: END IF;

Line 834: p_msg_level=>fnd_log.level_procedure);

830: END IF;
831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
833: p_prefix=>l_debug_prefix,
834: p_msg_level=>fnd_log.level_procedure);
835: END IF;
836:
837: -- Check if API is called in debug mode. If yes, disable debug.
838: --disable_debug;