DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_LOCALE_V2PUB dependencies on FND_LOG

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

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

Line 114: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 140: p_msg_level=>fnd_log.level_procedure);

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

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

151: X_OBJECT_VERSION_NUMBER => 1
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);

Line 159: p_msg_level=>fnd_log.level_procedure);

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 (-)',
161: p_prefix=>l_debug_prefix,
162: p_msg_level=>fnd_log.level_procedure);
163:

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

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

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

Line 194: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 243: p_msg_level=>fnd_log.level_procedure);

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:
246: -- call table handler to update a row
247: HZ_STYLE_FMT_LOCALES_PKG.Update_Row (

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

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

Line 261: p_msg_level=>fnd_log.level_procedure);

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:
264: -- Debug info.
265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 268: p_msg_level=>fnd_log.level_procedure);

264: -- Debug info.
265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
266: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_locale (-)',
267: p_prefix=>l_debug_prefix,
268: p_msg_level=>fnd_log.level_procedure);
269: END IF;
270:
271: END do_update_style_fmt_locale;
272:

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

325: -- Check if API is called in debug mode. If yes, enable debug.
326: --enable_debug;
327:
328: -- Debug info.
329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (+)',
331: p_prefix=>l_debug_prefix,
332: p_msg_level=>fnd_log.level_procedure);
333: END IF;

Line 332: p_msg_level=>fnd_log.level_procedure);

328: -- Debug info.
329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (+)',
331: p_prefix=>l_debug_prefix,
332: p_msg_level=>fnd_log.level_procedure);
333: END IF;
334:
335: -- initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

352: p_encoded => FND_API.G_FALSE,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355: -- Debug info.
356: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
357: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
358: p_msg_data=>x_msg_data,
359: p_msg_type=>'WARNING',
360: p_msg_level=>fnd_log.level_exception);

Line 360: p_msg_level=>fnd_log.level_exception);

356: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
357: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
358: p_msg_data=>x_msg_data,
359: p_msg_type=>'WARNING',
360: p_msg_level=>fnd_log.level_exception);
361: END IF;
362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
363: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
364: p_prefix=>l_debug_prefix,

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

358: p_msg_data=>x_msg_data,
359: p_msg_type=>'WARNING',
360: p_msg_level=>fnd_log.level_exception);
361: END IF;
362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
363: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
364: p_prefix=>l_debug_prefix,
365: p_msg_level=>fnd_log.level_procedure);
366: END IF;

Line 365: p_msg_level=>fnd_log.level_procedure);

361: END IF;
362: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
363: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
364: p_prefix=>l_debug_prefix,
365: p_msg_level=>fnd_log.level_procedure);
366: END IF;
367:
368: -- Check if API is called in debug mode. If yes, disable debug.
369: --disable_debug;

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

377: p_count => x_msg_count,
378: p_data => x_msg_data);
379:
380: -- Debug info.
381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
383: p_msg_data=>x_msg_data,
384: p_msg_type=>'ERROR',
385: p_msg_level=>fnd_log.level_error);

Line 385: p_msg_level=>fnd_log.level_error);

381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
383: p_msg_data=>x_msg_data,
384: p_msg_type=>'ERROR',
385: p_msg_level=>fnd_log.level_error);
386: END IF;
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
388: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
389: p_prefix=>l_debug_prefix,

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

383: p_msg_data=>x_msg_data,
384: p_msg_type=>'ERROR',
385: p_msg_level=>fnd_log.level_error);
386: END IF;
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
388: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: END IF;

Line 390: p_msg_level=>fnd_log.level_procedure);

386: END IF;
387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
388: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
389: p_prefix=>l_debug_prefix,
390: p_msg_level=>fnd_log.level_procedure);
391: END IF;
392:
393: -- Check if API is called in debug mode. If yes, disable debug.
394: --disable_debug;

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

401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: -- Debug info.
405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
407: p_msg_data=>x_msg_data,
408: p_msg_type=>'UNEXPECTED ERROR',
409: p_msg_level=>fnd_log.level_error);

Line 409: p_msg_level=>fnd_log.level_error);

405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
407: p_msg_data=>x_msg_data,
408: p_msg_type=>'UNEXPECTED ERROR',
409: p_msg_level=>fnd_log.level_error);
410: END IF;
411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
413: p_prefix=>l_debug_prefix,

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

407: p_msg_data=>x_msg_data,
408: p_msg_type=>'UNEXPECTED ERROR',
409: p_msg_level=>fnd_log.level_error);
410: END IF;
411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
413: p_prefix=>l_debug_prefix,
414: p_msg_level=>fnd_log.level_procedure);
415: END IF;

Line 414: p_msg_level=>fnd_log.level_procedure);

410: END IF;
411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
413: p_prefix=>l_debug_prefix,
414: p_msg_level=>fnd_log.level_procedure);
415: END IF;
416:
417: -- Check if API is called in debug mode. If yes, disable debug.
418: --disable_debug;

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

430: p_count => x_msg_count,
431: p_data => x_msg_data);
432:
433: -- Debug info.
434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
436: p_msg_data=>x_msg_data,
437: p_msg_type=>'SQL ERROR',
438: p_msg_level=>fnd_log.level_error);

Line 438: p_msg_level=>fnd_log.level_error);

434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
436: p_msg_data=>x_msg_data,
437: p_msg_type=>'SQL ERROR',
438: p_msg_level=>fnd_log.level_error);
439: END IF;
440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
441: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
442: p_prefix=>l_debug_prefix,

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

436: p_msg_data=>x_msg_data,
437: p_msg_type=>'SQL ERROR',
438: p_msg_level=>fnd_log.level_error);
439: END IF;
440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
441: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
442: p_prefix=>l_debug_prefix,
443: p_msg_level=>fnd_log.level_procedure);
444: END IF;

Line 443: p_msg_level=>fnd_log.level_procedure);

439: END IF;
440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
441: hz_utility_v2pub.debug(p_message=>'create_style_fmt_locale (-)',
442: p_prefix=>l_debug_prefix,
443: p_msg_level=>fnd_log.level_procedure);
444: END IF;
445:
446: -- Check if API is called in debug mode. If yes, disable debug.
447: --disable_debug;

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

502: -- Check if API is called in debug mode. If yes, enable debug.
503: --enable_debug;
504:
505: -- Debug info.
506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
507: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (+)',
508: p_prefix=>l_debug_prefix,
509: p_msg_level=>fnd_log.level_procedure);
510: END IF;

Line 509: p_msg_level=>fnd_log.level_procedure);

505: -- Debug info.
506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
507: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (+)',
508: p_prefix=>l_debug_prefix,
509: p_msg_level=>fnd_log.level_procedure);
510: END IF;
511:
512: -- initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

529: p_count => x_msg_count,
530: p_data => x_msg_data);
531:
532: -- Debug info.
533: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
534: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
535: p_msg_data=>x_msg_data,
536: p_msg_type=>'WARNING',
537: p_msg_level=>fnd_log.level_exception);

Line 537: p_msg_level=>fnd_log.level_exception);

533: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
534: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
535: p_msg_data=>x_msg_data,
536: p_msg_type=>'WARNING',
537: p_msg_level=>fnd_log.level_exception);
538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
541: p_prefix=>l_debug_prefix,

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

535: p_msg_data=>x_msg_data,
536: p_msg_type=>'WARNING',
537: p_msg_level=>fnd_log.level_exception);
538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;

Line 542: p_msg_level=>fnd_log.level_procedure);

538: END IF;
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;
544:
545: -- Check if API is called in debug mode. If yes, disable debug.
546: --disable_debug;

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

554: p_count => x_msg_count,
555: p_data => x_msg_data);
556:
557: -- Debug info.
558: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
559: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
560: p_msg_data=>x_msg_data,
561: p_msg_type=>'ERROR',
562: p_msg_level=>fnd_log.level_error);

Line 562: p_msg_level=>fnd_log.level_error);

558: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
559: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
560: p_msg_data=>x_msg_data,
561: p_msg_type=>'ERROR',
562: p_msg_level=>fnd_log.level_error);
563: END IF;
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
566: p_prefix=>l_debug_prefix,

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

560: p_msg_data=>x_msg_data,
561: p_msg_type=>'ERROR',
562: p_msg_level=>fnd_log.level_error);
563: END IF;
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;

Line 567: p_msg_level=>fnd_log.level_procedure);

563: END IF;
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;
569:
570: -- Check if API is called in debug mode. If yes, disable debug.
571: --disable_debug;

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

578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: -- Debug info.
582: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
583: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
584: p_msg_data=>x_msg_data,
585: p_msg_type=>'UNEXPECTED ERROR',
586: p_msg_level=>fnd_log.level_error);

Line 586: p_msg_level=>fnd_log.level_error);

582: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
583: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
584: p_msg_data=>x_msg_data,
585: p_msg_type=>'UNEXPECTED ERROR',
586: p_msg_level=>fnd_log.level_error);
587: END IF;
588: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
590: p_prefix=>l_debug_prefix,

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

584: p_msg_data=>x_msg_data,
585: p_msg_type=>'UNEXPECTED ERROR',
586: p_msg_level=>fnd_log.level_error);
587: END IF;
588: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
590: p_prefix=>l_debug_prefix,
591: p_msg_level=>fnd_log.level_procedure);
592: END IF;

Line 591: p_msg_level=>fnd_log.level_procedure);

587: END IF;
588: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
590: p_prefix=>l_debug_prefix,
591: p_msg_level=>fnd_log.level_procedure);
592: END IF;
593:
594: -- Check if API is called in debug mode. If yes, disable debug.
595: --disable_debug;

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

607: p_count => x_msg_count,
608: p_data => x_msg_data);
609:
610: -- Debug info.
611: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
612: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
613: p_msg_data=>x_msg_data,
614: p_msg_type=>'SQL ERROR',
615: p_msg_level=>fnd_log.level_error);

Line 615: p_msg_level=>fnd_log.level_error);

611: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
612: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
613: p_msg_data=>x_msg_data,
614: p_msg_type=>'SQL ERROR',
615: p_msg_level=>fnd_log.level_error);
616: END IF;
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
619: p_prefix=>l_debug_prefix,

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

613: p_msg_data=>x_msg_data,
614: p_msg_type=>'SQL ERROR',
615: p_msg_level=>fnd_log.level_error);
616: END IF;
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;

Line 620: p_msg_level=>fnd_log.level_procedure);

616: END IF;
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'update_style_fmt_locale (-)',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: -- Check if API is called in debug mode. If yes, disable debug.
624: --disable_debug;

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

671: -- Check if API is called in debug mode. If yes, enable debug.
672: --enable_debug;
673:
674: -- Debug info.
675: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
676: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (+)',
677: p_prefix=>l_debug_prefix,
678: p_msg_level=>fnd_log.level_procedure);
679: END IF;

Line 678: p_msg_level=>fnd_log.level_procedure);

674: -- Debug info.
675: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
676: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (+)',
677: p_prefix=>l_debug_prefix,
678: p_msg_level=>fnd_log.level_procedure);
679: END IF;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

697:
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;

Line 704: p_msg_level=>fnd_log.level_procedure);

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:
707: hz_style_fmt_locales_pkg.select_row (
708: X_STYLE_FMT_LOCALE_ID => x_style_fmt_locale_rec.style_fmt_locale_id,

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

713: X_END_DATE_ACTIVE => x_style_fmt_locale_rec.end_date_active
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;

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_locales_pkg.select_row (-)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:
723: --Standard call to get message count and if count is 1, get message info.
724: fnd_msg_pub.count_and_get(

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

727: p_data => x_msg_data
728: );
729:
730: -- Debug info.
731: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
732: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
733: p_msg_data=>x_msg_data,
734: p_msg_type=>'WARNING',
735: p_msg_level=>fnd_log.level_exception);

Line 735: p_msg_level=>fnd_log.level_exception);

731: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
732: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
733: p_msg_data=>x_msg_data,
734: p_msg_type=>'WARNING',
735: p_msg_level=>fnd_log.level_exception);
736: END IF;
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
739: p_prefix=>l_debug_prefix,

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

733: p_msg_data=>x_msg_data,
734: p_msg_type=>'WARNING',
735: p_msg_level=>fnd_log.level_exception);
736: END IF;
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;

Line 740: p_msg_level=>fnd_log.level_procedure);

736: END IF;
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;
742:
743:
744: -- Check if API is called in debug mode. If yes, disable debug.

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

752: p_data => x_msg_data
753: );
754:
755: -- Debug info.
756: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
758: p_msg_data=>x_msg_data,
759: p_msg_type=>'ERROR',
760: p_msg_level=>fnd_log.level_error);

Line 760: p_msg_level=>fnd_log.level_error);

756: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
757: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
758: p_msg_data=>x_msg_data,
759: p_msg_type=>'ERROR',
760: p_msg_level=>fnd_log.level_error);
761: END IF;
762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
763: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
764: p_prefix=>l_debug_prefix,

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

758: p_msg_data=>x_msg_data,
759: p_msg_type=>'ERROR',
760: p_msg_level=>fnd_log.level_error);
761: END IF;
762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
763: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
764: p_prefix=>l_debug_prefix,
765: p_msg_level=>fnd_log.level_procedure);
766: END IF;

Line 765: p_msg_level=>fnd_log.level_procedure);

761: END IF;
762: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
763: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
764: p_prefix=>l_debug_prefix,
765: p_msg_level=>fnd_log.level_procedure);
766: END IF;
767:
768: -- Check if API is called in debug mode. If yes, disable debug.
769: --disable_debug;

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

777: p_data => x_msg_data
778: );
779:
780: -- Debug info.
781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
783: p_msg_data=>x_msg_data,
784: p_msg_type=>'UNEXPECTED ERROR',
785: p_msg_level=>fnd_log.level_error);

Line 785: p_msg_level=>fnd_log.level_error);

781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
783: p_msg_data=>x_msg_data,
784: p_msg_type=>'UNEXPECTED ERROR',
785: p_msg_level=>fnd_log.level_error);
786: END IF;
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
789: p_prefix=>l_debug_prefix,

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

783: p_msg_data=>x_msg_data,
784: p_msg_type=>'UNEXPECTED ERROR',
785: p_msg_level=>fnd_log.level_error);
786: END IF;
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
789: p_prefix=>l_debug_prefix,
790: p_msg_level=>fnd_log.level_procedure);
791: END IF;

Line 790: p_msg_level=>fnd_log.level_procedure);

786: END IF;
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
789: p_prefix=>l_debug_prefix,
790: p_msg_level=>fnd_log.level_procedure);
791: END IF;
792:
793: -- Check if API is called in debug mode. If yes, disable debug.
794: --disable_debug;

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

806: p_data => x_msg_data
807: );
808:
809: -- Debug info.
810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
812: p_msg_data=>x_msg_data,
813: p_msg_type=>'SQL ERROR',
814: p_msg_level=>fnd_log.level_error);

Line 814: p_msg_level=>fnd_log.level_error);

810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
812: p_msg_data=>x_msg_data,
813: p_msg_type=>'SQL ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
818: p_prefix=>l_debug_prefix,

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

812: p_msg_data=>x_msg_data,
813: p_msg_type=>'SQL ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;

Line 819: p_msg_level=>fnd_log.level_procedure);

815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'get_style_fmt_locale_rec (-)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;
821:
822: -- Check if API is called in debug mode. If yes, disable debug.
823: --disable_debug;