DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_LAYOUT_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_layout (+)',
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_layout (+)',
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_layout_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_layouts_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_layouts_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_LAYOUTS_PKG.insert_row (
143: X_ROWID => l_rowid,

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

162: X_OBJECT_VERSION_NUMBER => 1
163: );
164:
165: -- Debug info.
166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (-) ' ||
168: 'p_style_fmt_layout_rec.style_fmt_layout_id = ' || p_style_fmt_layout_rec.style_fmt_layout_id,
169: p_prefix=>l_debug_prefix,
170: p_msg_level=>fnd_log.level_procedure);

Line 170: p_msg_level=>fnd_log.level_procedure);

166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (-) ' ||
168: 'p_style_fmt_layout_rec.style_fmt_layout_id = ' || p_style_fmt_layout_rec.style_fmt_layout_id,
169: p_prefix=>l_debug_prefix,
170: p_msg_level=>fnd_log.level_procedure);
171: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_layout (-)',
172: p_prefix=>l_debug_prefix,
173: p_msg_level=>fnd_log.level_procedure);
174: END IF;

Line 173: p_msg_level=>fnd_log.level_procedure);

169: p_prefix=>l_debug_prefix,
170: p_msg_level=>fnd_log.level_procedure);
171: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_layout (-)',
172: p_prefix=>l_debug_prefix,
173: p_msg_level=>fnd_log.level_procedure);
174: END IF;
175:
176: END do_create_style_fmt_layout;
177:

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

197:
198: BEGIN
199:
200: -- Debug info.
201: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (+)',
203: p_prefix=>l_debug_prefix,
204: p_msg_level=>fnd_log.level_procedure);
205: END IF;

Line 204: p_msg_level=>fnd_log.level_procedure);

200: -- Debug info.
201: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (+)',
203: p_prefix=>l_debug_prefix,
204: p_msg_level=>fnd_log.level_procedure);
205: END IF;
206:
207: -- check whether record has been updated by another user
208: BEGIN

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

246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (+)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;

Line 253: p_msg_level=>fnd_log.level_procedure);

249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (+)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;
255:
256: -- call table handler to update a row
257: HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (

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

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

Line 283: p_msg_level=>fnd_log.level_procedure);

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

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

283: p_msg_level=>fnd_log.level_procedure);
284: END IF;
285:
286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (-)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;

Line 290: p_msg_level=>fnd_log.level_procedure);

286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (-)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;
292:
293: END do_update_style_fmt_layout;
294:

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

347: -- Check if API is called in debug mode. If yes, enable debug.
348: --enable_debug;
349:
350: -- Debug info.
351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
352: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (+)',
353: p_prefix=>l_debug_prefix,
354: p_msg_level=>fnd_log.level_procedure);
355: END IF;

Line 354: p_msg_level=>fnd_log.level_procedure);

350: -- Debug info.
351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
352: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (+)',
353: p_prefix=>l_debug_prefix,
354: p_msg_level=>fnd_log.level_procedure);
355: END IF;
356:
357: -- initialize message list if p_init_msg_list is set to TRUE.
358: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data);
377: -- Debug info.
378: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
380: p_msg_data=>x_msg_data,
381: p_msg_type=>'WARNING',
382: p_msg_level=>fnd_log.level_exception);

Line 382: p_msg_level=>fnd_log.level_exception);

378: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
380: p_msg_data=>x_msg_data,
381: p_msg_type=>'WARNING',
382: p_msg_level=>fnd_log.level_exception);
383: END IF;
384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
385: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
386: p_prefix=>l_debug_prefix,

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

380: p_msg_data=>x_msg_data,
381: p_msg_type=>'WARNING',
382: p_msg_level=>fnd_log.level_exception);
383: END IF;
384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
385: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
386: p_prefix=>l_debug_prefix,
387: p_msg_level=>fnd_log.level_procedure);
388: END IF;

Line 387: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 407: p_msg_level=>fnd_log.level_error);

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

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

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

Line 412: p_msg_level=>fnd_log.level_procedure);

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

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

423: p_count => x_msg_count,
424: p_data => x_msg_data);
425:
426: -- Debug info.
427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
429: p_msg_data=>x_msg_data,
430: p_msg_type=>'UNEXPECTED ERROR',
431: p_msg_level=>fnd_log.level_error);

Line 431: p_msg_level=>fnd_log.level_error);

427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
429: p_msg_data=>x_msg_data,
430: p_msg_type=>'UNEXPECTED ERROR',
431: p_msg_level=>fnd_log.level_error);
432: END IF;
433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
434: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
435: p_prefix=>l_debug_prefix,

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

429: p_msg_data=>x_msg_data,
430: p_msg_type=>'UNEXPECTED ERROR',
431: p_msg_level=>fnd_log.level_error);
432: END IF;
433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
434: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
435: p_prefix=>l_debug_prefix,
436: p_msg_level=>fnd_log.level_procedure);
437: END IF;

Line 436: p_msg_level=>fnd_log.level_procedure);

432: END IF;
433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
434: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
435: p_prefix=>l_debug_prefix,
436: p_msg_level=>fnd_log.level_procedure);
437: END IF;
438:
439: -- Check if API is called in debug mode. If yes, disable debug.
440: --disable_debug;

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

452: p_count => x_msg_count,
453: p_data => x_msg_data);
454:
455: -- Debug info.
456: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
458: p_msg_data=>x_msg_data,
459: p_msg_type=>'SQL ERROR',
460: p_msg_level=>fnd_log.level_error);

Line 460: p_msg_level=>fnd_log.level_error);

456: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
458: p_msg_data=>x_msg_data,
459: p_msg_type=>'SQL ERROR',
460: p_msg_level=>fnd_log.level_error);
461: END IF;
462: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
463: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
464: p_prefix=>l_debug_prefix,

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

458: p_msg_data=>x_msg_data,
459: p_msg_type=>'SQL ERROR',
460: p_msg_level=>fnd_log.level_error);
461: END IF;
462: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
463: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
464: p_prefix=>l_debug_prefix,
465: p_msg_level=>fnd_log.level_procedure);
466: END IF;

Line 465: p_msg_level=>fnd_log.level_procedure);

461: END IF;
462: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
463: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
464: p_prefix=>l_debug_prefix,
465: p_msg_level=>fnd_log.level_procedure);
466: END IF;
467:
468: -- Check if API is called in debug mode. If yes, disable debug.
469: --disable_debug;

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

523: -- Check if API is called in debug mode. If yes, enable debug.
524: --enable_debug;
525:
526: -- Debug info.
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (+)',
529: p_prefix=>l_debug_prefix,
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;

Line 530: p_msg_level=>fnd_log.level_procedure);

526: -- Debug info.
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (+)',
529: p_prefix=>l_debug_prefix,
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;
532:
533: -- initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

550: p_count => x_msg_count,
551: p_data => x_msg_data);
552:
553: -- Debug info.
554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
556: p_msg_data=>x_msg_data,
557: p_msg_type=>'WARNING',
558: p_msg_level=>fnd_log.level_exception);

Line 558: p_msg_level=>fnd_log.level_exception);

554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
556: p_msg_data=>x_msg_data,
557: p_msg_type=>'WARNING',
558: p_msg_level=>fnd_log.level_exception);
559: END IF;
560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
562: p_prefix=>l_debug_prefix,

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

556: p_msg_data=>x_msg_data,
557: p_msg_type=>'WARNING',
558: p_msg_level=>fnd_log.level_exception);
559: END IF;
560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
562: p_prefix=>l_debug_prefix,
563: p_msg_level=>fnd_log.level_procedure);
564: END IF;

Line 563: p_msg_level=>fnd_log.level_procedure);

559: END IF;
560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
562: p_prefix=>l_debug_prefix,
563: p_msg_level=>fnd_log.level_procedure);
564: END IF;
565:
566: -- Check if API is called in debug mode. If yes, disable debug.
567: --disable_debug;

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

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

Line 583: p_msg_level=>fnd_log.level_error);

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

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

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

Line 588: p_msg_level=>fnd_log.level_procedure);

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

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

599: p_count => x_msg_count,
600: p_data => x_msg_data);
601:
602: -- Debug info.
603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
605: p_msg_data=>x_msg_data,
606: p_msg_type=>'UNEXPECTED ERROR',
607: p_msg_level=>fnd_log.level_error);

Line 607: p_msg_level=>fnd_log.level_error);

603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
605: p_msg_data=>x_msg_data,
606: p_msg_type=>'UNEXPECTED ERROR',
607: p_msg_level=>fnd_log.level_error);
608: END IF;
609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
611: p_prefix=>l_debug_prefix,

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

605: p_msg_data=>x_msg_data,
606: p_msg_type=>'UNEXPECTED ERROR',
607: p_msg_level=>fnd_log.level_error);
608: END IF;
609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
611: p_prefix=>l_debug_prefix,
612: p_msg_level=>fnd_log.level_procedure);
613: END IF;

Line 612: p_msg_level=>fnd_log.level_procedure);

608: END IF;
609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
611: p_prefix=>l_debug_prefix,
612: p_msg_level=>fnd_log.level_procedure);
613: END IF;
614:
615: -- Check if API is called in debug mode. If yes, disable debug.
616: --disable_debug;

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

628: p_count => x_msg_count,
629: p_data => x_msg_data);
630:
631: -- Debug info.
632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
634: p_msg_data=>x_msg_data,
635: p_msg_type=>'SQL ERROR',
636: p_msg_level=>fnd_log.level_error);

Line 636: p_msg_level=>fnd_log.level_error);

632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
634: p_msg_data=>x_msg_data,
635: p_msg_type=>'SQL ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
640: p_prefix=>l_debug_prefix,

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

634: p_msg_data=>x_msg_data,
635: p_msg_type=>'SQL ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;

Line 641: p_msg_level=>fnd_log.level_procedure);

637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;
643:
644: -- Check if API is called in debug mode. If yes, disable debug.
645: --disable_debug;

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

693: -- Check if API is called in debug mode. If yes, enable debug.
694: --enable_debug;
695:
696: -- Debug info.
697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
698: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (+)',
699: p_prefix=>l_debug_prefix,
700: p_msg_level=>fnd_log.level_procedure);
701: END IF;

Line 700: p_msg_level=>fnd_log.level_procedure);

696: -- Debug info.
697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
698: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (+)',
699: p_prefix=>l_debug_prefix,
700: p_msg_level=>fnd_log.level_procedure);
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

719:
720: x_style_fmt_layout_rec.style_fmt_layout_id := p_style_fmt_layout_id;
721:
722: -- Debug info.
723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
724: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.Select_Row (+)',
725: p_prefix=>l_debug_prefix,
726: p_msg_level=>fnd_log.level_procedure);
727: END IF;

Line 726: p_msg_level=>fnd_log.level_procedure);

722: -- Debug info.
723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
724: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.Select_Row (+)',
725: p_prefix=>l_debug_prefix,
726: p_msg_level=>fnd_log.level_procedure);
727: END IF;
728:
729: hz_style_fmt_layouts_pkg.select_row (
730: X_STYLE_FMT_LAYOUT_ID => x_style_fmt_layout_rec.style_fmt_layout_id,

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

747: X_END_DATE_ACTIVE => x_style_fmt_layout_rec.end_date_active
748: );
749:
750: -- Debug info.
751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
752: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.select_row (-)',
753: p_prefix=>l_debug_prefix,
754: p_msg_level=>fnd_log.level_procedure);
755: END IF;

Line 754: p_msg_level=>fnd_log.level_procedure);

750: -- Debug info.
751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
752: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.select_row (-)',
753: p_prefix=>l_debug_prefix,
754: p_msg_level=>fnd_log.level_procedure);
755: END IF;
756:
757: --Standard call to get message count and if count is 1, get message info.
758: fnd_msg_pub.count_and_get(

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

761: p_data => x_msg_data
762: );
763:
764: -- Debug info.
765: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
767: p_msg_data=>x_msg_data,
768: p_msg_type=>'WARNING',
769: p_msg_level=>fnd_log.level_exception);

Line 769: p_msg_level=>fnd_log.level_exception);

765: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
767: p_msg_data=>x_msg_data,
768: p_msg_type=>'WARNING',
769: p_msg_level=>fnd_log.level_exception);
770: END IF;
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
773: p_prefix=>l_debug_prefix,

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

767: p_msg_data=>x_msg_data,
768: p_msg_type=>'WARNING',
769: p_msg_level=>fnd_log.level_exception);
770: END IF;
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;

Line 774: p_msg_level=>fnd_log.level_procedure);

770: END IF;
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;
776:
777: -- Check if API is called in debug mode. If yes, disable debug.
778: --disable_debug;

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

785: p_data => x_msg_data
786: );
787:
788: -- Debug info.
789: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
791: p_msg_data=>x_msg_data,
792: p_msg_type=>'ERROR',
793: p_msg_level=>fnd_log.level_error);

Line 793: p_msg_level=>fnd_log.level_error);

789: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
791: p_msg_data=>x_msg_data,
792: p_msg_type=>'ERROR',
793: p_msg_level=>fnd_log.level_error);
794: END IF;
795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
797: p_prefix=>l_debug_prefix,

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

791: p_msg_data=>x_msg_data,
792: p_msg_type=>'ERROR',
793: p_msg_level=>fnd_log.level_error);
794: END IF;
795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
797: p_prefix=>l_debug_prefix,
798: p_msg_level=>fnd_log.level_procedure);
799: END IF;

Line 798: p_msg_level=>fnd_log.level_procedure);

794: END IF;
795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
797: p_prefix=>l_debug_prefix,
798: p_msg_level=>fnd_log.level_procedure);
799: END IF;
800:
801:
802: -- Check if API is called in debug mode. If yes, disable debug.

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

811: p_data => x_msg_data
812: );
813:
814: -- Debug info.
815: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
816: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
817: p_msg_data=>x_msg_data,
818: p_msg_type=>'UNEXPECTED ERROR',
819: p_msg_level=>fnd_log.level_error);

Line 819: p_msg_level=>fnd_log.level_error);

815: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
816: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
817: p_msg_data=>x_msg_data,
818: p_msg_type=>'UNEXPECTED ERROR',
819: p_msg_level=>fnd_log.level_error);
820: END IF;
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
823: p_prefix=>l_debug_prefix,

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

817: p_msg_data=>x_msg_data,
818: p_msg_type=>'UNEXPECTED ERROR',
819: p_msg_level=>fnd_log.level_error);
820: END IF;
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
823: p_prefix=>l_debug_prefix,
824: p_msg_level=>fnd_log.level_procedure);
825: END IF;

Line 824: p_msg_level=>fnd_log.level_procedure);

820: END IF;
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
823: p_prefix=>l_debug_prefix,
824: p_msg_level=>fnd_log.level_procedure);
825: END IF;
826:
827: -- Check if API is called in debug mode. If yes, disable debug.
828: --disable_debug;

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

840: p_data => x_msg_data
841: );
842:
843: -- Debug info.
844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);

Line 848: p_msg_level=>fnd_log.level_error);

844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
852: p_prefix=>l_debug_prefix,

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

846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;

Line 853: p_msg_level=>fnd_log.level_procedure);

849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;
855:
856: -- Check if API is called in debug mode. If yes, disable debug.
857: --disable_debug;