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.BIL_BI_UTIL_PKG dependencies on FND_LOG

Line 16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)

12: -- This function is a wrapper on FND APIs for OA Common Error
13: -- logging framework
14: --
15: -- p_log_level = Severity; valid values are -
16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

Line 17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)

13: -- logging framework
14: --
15: -- p_log_level = Severity; valid values are -
16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

Line 18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)

14: --
15: -- p_log_level = Severity; valid values are -
16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --

Line 19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)

15: -- p_log_level = Severity; valid values are -
16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --
23: -- Output values:-

Line 20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

16: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --
23: -- Output values:-
24: -- = TRUE if FND Log is Enabled

Line 21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

17: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
18: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
19: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --
23: -- Output values:-
24: -- = TRUE if FND Log is Enabled
25: -- = FALSE if FND Log is DISABLED

Line 24: -- = TRUE if FND Log is Enabled

20: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --
23: -- Output values:-
24: -- = TRUE if FND Log is Enabled
25: -- = FALSE if FND Log is DISABLED
26: --
27: -- **********************************************************************
28:

Line 25: -- = FALSE if FND Log is DISABLED

21: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
22: --
23: -- Output values:-
24: -- = TRUE if FND Log is Enabled
25: -- = FALSE if FND Log is DISABLED
26: --
27: -- **********************************************************************
28:
29: FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN AS

Line 36: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

32: BEGIN
33: /* Variable Intialization */
34: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
35:
36: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
37:
38: RETURN TRUE;
39:
40: END IF;

Line 48: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

44:
45: EXCEPTION
46: WHEN OTHERS THEN
47:
48: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
49:
50: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
51: fnd_message.set_token('Error is : ' ,SQLCODE);
52: fnd_message.set_token('Reason is : ', SQLERRM);

Line 54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

50: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
51: fnd_message.set_token('Error is : ' ,SQLCODE);
52: fnd_message.set_token('Reason is : ', SQLERRM);
53:
54: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
55: MODULE => g_pkg || '.chkLogLevel',
56: MESSAGE => fnd_message.get );
57:
58: END IF;

Line 122: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

118: x_conv_rate_selected := 'NULL';
119: END IF;
120:
121:
122: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
123: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
124: MODULE => g_pkg || '.get_conv_rate ',
125: MESSAGE => l_primary_currency ||', '||l_conv_type ||', '|| x_conv_rate_selected);
126: END IF;

Line 123: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

119: END IF;
120:
121:
122: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
123: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
124: MODULE => g_pkg || '.get_conv_rate ',
125: MESSAGE => l_primary_currency ||', '||l_conv_type ||', '|| x_conv_rate_selected);
126: END IF;
127:

Line 134: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

130:
131: EXCEPTION
132: WHEN OTHERS THEN
133:
134: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135:
136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
137: fnd_message.set_token('Error is : ' ,SQLCODE);
138: fnd_message.set_token('Reason is : ', SQLERRM);

Line 140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
137: fnd_message.set_token('Error is : ' ,SQLCODE);
138: fnd_message.set_token('Reason is : ', SQLERRM);
139:
140: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
141: MODULE => g_pkg || '.get_conv_rate',
142: MESSAGE => fnd_message.get );
143:
144: END IF;

Line 170: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

166:
167: EXCEPTION
168: WHEN OTHERS THEN
169:
170: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
173: fnd_message.set_token('Error is : ' ,SQLCODE);
174: fnd_message.set_token('Reason is : ', SQLERRM);

Line 177: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

173: fnd_message.set_token('Error is : ' ,SQLCODE);
174: fnd_message.set_token('Reason is : ', SQLERRM);
175:
176:
177: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
178: MODULE => g_pkg || '.get_curr_date',
179: MESSAGE => fnd_message.get );
180:
181: END IF;

Line 239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

235:
236: WHEN OTHERS THEN
237:
238:
239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
240:
241: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
242: fnd_message.set_token('Error is : ' ,SQLCODE);
243: fnd_message.set_token('Reason is : ', SQLERRM);

Line 245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

241: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
242: fnd_message.set_token('Error is : ' ,SQLCODE);
243: fnd_message.set_token('Reason is : ', SQLERRM);
244:
245: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
246: MODULE => g_pkg || '.get_dbi_params',
247: MESSAGE => fnd_message.get );
248:
249: END IF;

Line 287: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

283: EXCEPTION
284:
285: WHEN OTHERS THEN
286:
287: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
288:
289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
290: fnd_message.set_token('Error is : ' ,SQLCODE);
291: fnd_message.set_token('Reason is : ', SQLERRM);

Line 293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
290: fnd_message.set_token('Error is : ' ,SQLCODE);
291: fnd_message.set_token('Reason is : ', SQLERRM);
292:
293: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
294: MODULE => g_pkg || '.get_dbi_sales_group_id',
295: MESSAGE => fnd_message.get );
296: END IF;
297: END;

Line 367: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

363:
364: EXCEPTION
365: WHEN OTHERS THEN
366:
367: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
368:
369: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
370: fnd_message.set_token('Error is : ' ,SQLCODE);
371: fnd_message.set_token('Reason is : ', SQLERRM);

Line 373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

369: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
370: fnd_message.set_token('Error is : ' ,SQLCODE);
371: fnd_message.set_token('Reason is : ', SQLERRM);
372:
373: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
374: MODULE => g_pkg || '.get_default_query',
375: MESSAGE => fnd_message.get );
376:
377: END IF;

Line 409: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

405: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
406:
407:
408:
409: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
410:
411: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
412: MODULE => g_pkg || '.get_forecast_profiles ',
413: MESSAGE => x_FstCrdtType);

Line 411: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

407:
408:
409: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
410:
411: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
412: MODULE => g_pkg || '.get_forecast_profiles ',
413: MESSAGE => x_FstCrdtType);
414:
415: END IF;

Line 420: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

416:
417: EXCEPTION
418: WHEN OTHERS THEN
419:
420: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
421:
422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
423: fnd_message.set_token('Error is : ' ,SQLCODE);
424: fnd_message.set_token('Reason is : ', SQLERRM);

Line 426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
423: fnd_message.set_token('Error is : ' ,SQLCODE);
424: fnd_message.set_token('Reason is : ', SQLERRM);
425:
426: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
427: MODULE => g_pkg || '.get_forecast_profiles',
428: MESSAGE => fnd_message.get );
429:
430: END IF;

Line 467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

463:
464: x_curr_date:=l_curr_date;
465:
466:
467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
468:
469: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
470: MODULE => g_pkg || '.get_global_conts ',
471: MESSAGE => x_bitand_id ||', '||x_calendar_id ||', '|| x_fii_struct);

Line 469: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

465:
466:
467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
468:
469: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
470: MODULE => g_pkg || '.get_global_conts ',
471: MESSAGE => x_bitand_id ||', '||x_calendar_id ||', '|| x_fii_struct);
472:
473: END IF;

Line 479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

475:
476: EXCEPTION
477: WHEN OTHERS THEN
478:
479: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
480: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
481: fnd_message.set_token('Error is : ' ,SQLCODE);
482: fnd_message.set_token('Reason is : ', SQLERRM);
483:

Line 484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

480: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
481: fnd_message.set_token('Error is : ' ,SQLCODE);
482: fnd_message.set_token('Reason is : ', SQLERRM);
483:
484: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
485: MODULE => g_pkg || '.get_global_conts',
486: MESSAGE => fnd_message.get );
487:
488: END IF;

Line 562: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

558: if (x_snapshot_date is null) then
559: x_snapshot_date := p_as_of_date;
560: end if;
561:
562: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563:
564: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
565: MODULE => g_pkg ||'.'|| l_proc || '.x_snapshot_date',
566: MESSAGE => x_snapshot_date);

Line 564: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

560: end if;
561:
562: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563:
564: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
565: MODULE => g_pkg ||'.'|| l_proc || '.x_snapshot_date',
566: MESSAGE => x_snapshot_date);
567:
568: END IF;

Line 573: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

569:
570: EXCEPTION
571: WHEN OTHERS THEN
572:
573: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
574: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
575: fnd_message.set_token('Error is : ' ,SQLCODE);
576: fnd_message.set_token('Reason is : ', SQLERRM);
577:

Line 578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

574: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
575: fnd_message.set_token('Error is : ' ,SQLCODE);
576: fnd_message.set_token('Reason is : ', SQLERRM);
577:
578: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
579: MODULE => g_pkg || '.get_latest_snapshot',
580: MESSAGE => fnd_message.get );
581:
582: END IF;

Line 611: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

607:
608: EXCEPTION
609: WHEN OTHERS THEN
610:
611: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
612: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
613: fnd_message.set_token('Error is : ' ,SQLCODE);
614: fnd_message.set_token('Reason is : ', SQLERRM);
615:

Line 616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

612: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
613: fnd_message.set_token('Error is : ' ,SQLCODE);
614: fnd_message.set_token('Reason is : ', SQLERRM);
615:
616: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
617: MODULE => g_pkg || '.get_other_profiles',
618: MESSAGE => fnd_message.get );
619: END IF;
620: END;

Line 671: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

667: l_err_desc := 'Please run with a valid ';
668: l_proc := ' GET.PAGE.PARAMS ';
669:
670:
671: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
672:
673: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
674: MODULE => g_pkg ||'.'|| l_proc || '.begin',
675: MESSAGE => 'Start of Procedure '||l_proc);

Line 673: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

669:
670:
671: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
672:
673: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
674: MODULE => g_pkg ||'.'|| l_proc || '.begin',
675: MESSAGE => 'Start of Procedure '||l_proc);
676:
677: END IF;

Line 833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

829: ' l_currency : '||l_currency||' p_sg_id : '||x_sg_id||'p_prodcat_id : '||x_prodcat_id||
830: ' p_prev_page_time_id : '||x_prev_page_time_id||' x_curr_page_time_id : '||x_curr_page_time_id;
831:
832:
833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
834:
835: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
836: MODULE => g_pkg ||'.'|| l_proc || '.params',
837: MESSAGE => l_log_str);

Line 835: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

831:
832:
833: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
834:
835: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
836: MODULE => g_pkg ||'.'|| l_proc || '.params',
837: MESSAGE => l_log_str);
838:
839: END IF;

Line 843: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

839: END IF;
840:
841: ELSE
842:
843: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
844:
845: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
846: MODULE => g_pkg ||'.'|| l_proc ||'.'||l_err_msg,
847: MESSAGE => l_err_desc);

Line 845: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

841: ELSE
842:
843: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
844:
845: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
846: MODULE => g_pkg ||'.'|| l_proc ||'.'||l_err_msg,
847: MESSAGE => l_err_desc);
848:
849: END IF;

Line 874: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

870: l_err_msg1 := 'Invalid period type.';
871: l_err_desc1 := 'Invalid period type. ';
872:
873:
874: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875:
876: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
877: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
878: MESSAGE => l_err_desc);

Line 876: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

872:
873:
874: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
875:
876: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
877: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
878: MESSAGE => l_err_desc);
879:
880: END IF;

Line 887: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

883:
884: IF x_parameter_valid = TRUE THEN
885: l_log_str := ' p_period_type : '||x_period_type||' x_record_type_id : '||x_record_type_id;
886:
887: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
888:
889: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
890: MODULE => g_pkg ||'.'|| l_proc,
891: MESSAGE => l_log_str);

Line 889: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

885: l_log_str := ' p_period_type : '||x_period_type||' x_record_type_id : '||x_record_type_id;
886:
887: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
888:
889: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
890: MODULE => g_pkg ||'.'|| l_proc,
891: MESSAGE => l_log_str);
892:
893: END IF;

Line 923: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

919: l_log_str := ' x_prior_as_of_date : '||x_prior_as_of_date||
920: ' p_conv_rate_selected : '||x_conv_rate_selected;
921:
922:
923: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
924:
925: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
926: MODULE => g_pkg ||'.'||l_proc,
927: MESSAGE => l_log_str);

Line 925: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

921:
922:
923: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
924:
925: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
926: MODULE => g_pkg ||'.'||l_proc,
927: MESSAGE => l_log_str);
928:
929: END IF;

Line 933: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

929: END IF;
930:
931: ELSE
932:
933: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
934:
935: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
936: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
937: MESSAGE => l_err_desc);

Line 935: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

931: ELSE
932:
933: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
934:
935: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
936: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
937: MESSAGE => l_err_desc);
938:
939: END IF;

Line 957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

953: IF x_parameter_valid THEN
954:
955: l_log_str := ' x_parent_sls_grp_id : '||x_parent_sg_id;
956:
957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
958:
959: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
960: MODULE => g_pkg ||'.'||l_proc,
961: MESSAGE => l_log_str);

Line 959: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

955: l_log_str := ' x_parent_sls_grp_id : '||x_parent_sg_id;
956:
957: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
958:
959: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
960: MODULE => g_pkg ||'.'||l_proc,
961: MESSAGE => l_log_str);
962:
963: END IF;

Line 968: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

964:
965:
966: ELSE
967:
968: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
969:
970: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
971: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
972: MESSAGE => l_err_desc);

Line 970: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

966: ELSE
967:
968: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
969:
970: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
971: MODULE => g_pkg ||'.'||l_proc||'.'||l_err_msg,
972: MESSAGE => l_err_desc);
973:
974: END IF;

Line 986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

982: IF p_page_parameter_tbl IS NULL THEN
983:
984: l_log_str := ' Param table null! ';
985:
986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987:
988: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
989: MODULE => g_pkg ||'.'||l_proc,
990: MESSAGE => l_log_str);

Line 988: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

984: l_log_str := ' Param table null! ';
985:
986: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
987:
988: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
989: MODULE => g_pkg ||'.'||l_proc,
990: MESSAGE => l_log_str);
991:
992: END IF;

Line 999: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

995: l_log_str := l_log_str || ' Length of param table '||
996: p_page_parameter_tbl.count;
997:
998:
999: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1000:
1001: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1002: MODULE => g_pkg ||'.'||l_proc,
1003: MESSAGE => l_log_str);

Line 1001: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

997:
998:
999: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1000:
1001: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1002: MODULE => g_pkg ||'.'||l_proc,
1003: MESSAGE => l_log_str);
1004:
1005: END IF;

Line 1014: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013:
1014: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1015: l_parameter_valid := FALSE;
1016: x_parameter_valid := l_parameter_valid;
1017: l_err_msg := 'New: '||SQLERRM();
1018:

Line 1021: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1017: l_err_msg := 'New: '||SQLERRM();
1018:
1019: l_log_str := ' Exception_block!! ';
1020:
1021: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1022: MODULE => g_pkg ||'.'||l_proc||'.'||l_log_str,
1023: MESSAGE => l_err_msg );
1024:
1025: END IF;

Line 1059: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1055: x_parameter_valid := l_parameter_valid;
1056: x_parent_sls_grp_id := l_parent_sls_grp_id;
1057: WHEN OTHERS THEN
1058:
1059: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: l_parameter_valid := FALSE;
1061: x_parameter_valid := l_parameter_valid;
1062: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1063: fnd_message.set_token('ERROR',SQLCODE);

Line 1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1062: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1063: fnd_message.set_token('ERROR',SQLCODE);
1064: fnd_message.set_token('REASON', SQLERRM);
1065:
1066: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1067: MODULE => g_pkg ||'.getParentSalesGroup',
1068: MESSAGE => fnd_message.get );
1069:
1070: END IF;

Line 1127: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1123: END IF;
1124:
1125: END IF;
1126:
1127: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1128:
1129: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1130: MODULE => g_pkg || l_proc ||'Prod cat view by',
1131: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '|| l_denorm);

Line 1129: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1125: END IF;
1126:
1127: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1128:
1129: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1130: MODULE => g_pkg || l_proc ||'Prod cat view by',
1131: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '|| l_denorm);
1132:
1133: END IF;

Line 1144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1140: l_product_where_clause := ' AND sumry.product_category_id = :l_prodcat '||
1141: ' AND sumry.item_id IS NULL ';
1142: END IF;
1143:
1144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1145:
1146: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1147: MODULE => g_pkg || l_proc || p_viewBy,
1148: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '||l_denorm);

Line 1146: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1142: END IF;
1143:
1144: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1145:
1146: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1147: MODULE => g_pkg || l_proc || p_viewBy,
1148: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '||l_denorm);
1149:
1150: END IF;

Line 1159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1155: x_where_clause := l_product_where_clause;
1156: EXCEPTION
1157: WHEN OTHERS THEN
1158:
1159: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160:
1161: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);

Line 1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1162: fnd_message.set_token('ERROR' ,SQLCODE);
1163: fnd_message.set_token('REASON',SQLERRM);
1164: fnd_message.set_token('ROUTINE',l_proc);
1165:
1166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1167: MODULE => g_pkg || l_proc,
1168: MESSAGE => fnd_message.get );
1169: END IF;
1170: END get_Product_Where_Clause;

Line 1212: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1208: ' AND sumry.product_category_id = pcd.child_id ';
1209: l_denorm := ',ENI_ITEM_PROD_CAT_LOOKUP_V pcd ';
1210: END IF;
1211:
1212: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1213:
1214: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1215: MODULE => g_pkg || l_proc ||'Prod cat view by',
1216: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '|| l_denorm);

Line 1214: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1210: END IF;
1211:
1212: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1213:
1214: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1215: MODULE => g_pkg || l_proc ||'Prod cat view by',
1216: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '|| l_denorm);
1217:
1218: END IF;

Line 1233: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1229: AND eni1.parent_id = :l_prodcat ';
1230: l_denorm := ',eni_denorm_hierarchies eni1, mtl_default_category_sets d ';
1231: END IF;
1232:
1233: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1234:
1235: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1236: MODULE => g_pkg || l_proc || p_viewBy,
1237: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '||l_denorm);

Line 1235: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1231: END IF;
1232:
1233: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1234:
1235: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1236: MODULE => g_pkg || l_proc || p_viewBy,
1237: MESSAGE => ' Product where clause: '|| l_product_where_clause ||'; denorm: '||l_denorm);
1238:
1239: END IF;

Line 1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1243: x_where_clause := l_product_where_clause;
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246:
1247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);

Line 1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1249: fnd_message.set_token('ERROR' ,SQLCODE);
1250: fnd_message.set_token('REASON',SQLERRM);
1251: fnd_message.set_token('ROUTINE',l_proc);
1252:
1253: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1254: MODULE => g_pkg || l_proc ,
1255: MESSAGE => fnd_message.get );
1256:
1257: END IF;

Line 1393: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1389: */
1390:
1391: END CASE;
1392:
1393: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1394:
1395: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1396: MODULE => g_pkg || '.get_conv_rate ',
1397: MESSAGE => 'x_column_name: '||x_column_name||'; '||

Line 1395: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1391: END CASE;
1392:
1393: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1394:
1395: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1396: MODULE => g_pkg || '.get_conv_rate ',
1397: MESSAGE => 'x_column_name: '||x_column_name||'; '||
1398: 'x_curr_eff_end_date: '|| x_curr_eff_end_date||'; '||
1399: 'x_curr_start_date: '||x_curr_start_date||'; '||

Line 1409: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1405:
1406: EXCEPTION
1407:
1408: WHEN OTHERS THEN
1409: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1410:
1411: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1412: fnd_message.set_token('Error is : ' ,SQLCODE);
1413: fnd_message.set_token('Reason is : ', SQLERRM);

Line 1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1411: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1412: fnd_message.set_token('Error is : ' ,SQLCODE);
1413: fnd_message.set_token('Reason is : ', SQLERRM);
1414:
1415: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1416: MODULE => g_pkg || '.get_trend_params',
1417: MESSAGE => fnd_message.get );
1418:
1419: END IF;

Line 1441: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1437: RETURN l_unassigned_value;
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440:
1441: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1442: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1443: fnd_message.set_token('Error is : ' ,SQLCODE);
1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:

Line 1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1442: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1443: fnd_message.set_token('Error is : ' ,SQLCODE);
1444: fnd_message.set_token('Reason is : ', SQLERRM);
1445:
1446: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1447: MODULE => g_pkg || '. GET_UNASSIGNED_PC',
1448: MESSAGE => fnd_message.get );
1449:
1450: END IF;

Line 1528: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1524: AND a.parent_id = p_prodcat_id
1525: AND a.parent_id = a.child_id;
1526:
1527:
1528: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1529:
1530: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1531: MODULE => g_pkg ||'.Leaf_node ',
1532: MESSAGE => 'Leaf node: '||leaf_node

Line 1530: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

1526:
1527:
1528: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1529:
1530: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1531: MODULE => g_pkg ||'.Leaf_node ',
1532: MESSAGE => 'Leaf node: '||leaf_node
1533: || ', prodcat_id: ' || p_prodcat_id);
1534:

Line 1548: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1544: EXCEPTION
1545:
1546: WHEN OTHERS THEN
1547:
1548: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1549: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1550: fnd_message.set_token('Error is : ' ,SQLCODE);
1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:

Line 1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1549: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1550: fnd_message.set_token('Error is : ' ,SQLCODE);
1551: fnd_message.set_token('Reason is : ', SQLERRM);
1552:
1553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1554: MODULE => g_pkg || '.isLeafNode',
1555: MESSAGE => fnd_message.get );
1556:
1557:

Line 1632: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631:
1632: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1633: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1634: fnd_message.set_token('ERROR',SQLCODE);
1635: fnd_message.set_token('REASON', SQLERRM);
1636:

Line 1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1633: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
1634: fnd_message.set_token('ERROR',SQLCODE);
1635: fnd_message.set_token('REASON', SQLERRM);
1636:
1637: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1638: MODULE => g_pkg ||'.getLookupMeaning',
1639: MESSAGE => fnd_message.get );
1640:
1641: END IF;

Line 1676: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1672: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1673: l_proc := 'get_prior_prior_time';
1674:
1675:
1676: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1677:
1678: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1679: MODULE => g_pkg || l_proc || 'begin',
1680: MESSAGE => 'Start of Procedure '||l_proc);

Line 1678: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1674:
1675:
1676: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1677:
1678: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1679: MODULE => g_pkg || l_proc || 'begin',
1680: MESSAGE => 'Start of Procedure '||l_proc);
1681:
1682: END IF;

Line 1814: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1810: x_prior_prior_date:=TRUNC(p_prev_date);
1811: x_prior_prior_time_id:=p_prev_page_time_id;
1812:
1813: END IF;
1814: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1815:
1816: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1817: MODULE => g_pkg || l_proc || 'End',
1818: MESSAGE => 'End of Procedure '||l_proc);

Line 1816: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1812:
1813: END IF;
1814: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1815:
1816: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1817: MODULE => g_pkg || l_proc || 'End',
1818: MESSAGE => 'End of Procedure '||l_proc);
1819:
1820: END IF;

Line 1831: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1827: x_prior_prior_time_id:= -999;
1828:
1829: WHEN OTHERS THEN
1830:
1831: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1832: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1833: fnd_message.set_token('Error is : ' ,SQLCODE);
1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:

Line 1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1832: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1833: fnd_message.set_token('Error is : ' ,SQLCODE);
1834: fnd_message.set_token('Reason is : ', SQLERRM);
1835:
1836: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1837: MODULE => g_pkg || '. GET_PRIOR_PRIOR_TIME',
1838: MESSAGE => fnd_message.get );
1839: END IF;
1840: END GET_PRIOR_PRIOR_TIME;

Line 1869: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1865: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1866: l_proc := 'GET_DRILL_LINKS';
1867:
1868:
1869: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1870:
1871: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1872: MODULE => g_pkg || l_proc || 'begin',
1873: MESSAGE => 'Start of Procedure '||l_proc);

Line 1871: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1867:
1868:
1869: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1870:
1871: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1872: MODULE => g_pkg || l_proc || 'begin',
1873: MESSAGE => 'Start of Procedure '||l_proc);
1874:
1875: END IF;

Line 1891: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1887: ELSE -- VBY=Sales Group
1888: l_drill_link := 'pFunctionName=BIL_BI_OPPTY_LINE_DETAIL_R&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID&';
1889: END IF;
1890:
1891: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1892:
1893: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_EVENT,
1894: MODULE => g_pkg || l_proc,
1895: MESSAGE => 'Drill Link is =>'||l_drill_link);

Line 1893: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_EVENT,

1889: END IF;
1890:
1891: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1892:
1893: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_EVENT,
1894: MODULE => g_pkg || l_proc,
1895: MESSAGE => 'Drill Link is =>'||l_drill_link);
1896:
1897: END IF;

Line 1900: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1896:
1897: END IF;
1898:
1899:
1900: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1901:
1902: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1903: MODULE => g_pkg || l_proc || 'End',
1904: MESSAGE => 'End of Procedure '||l_proc);

Line 1902: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1898:
1899:
1900: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1901:
1902: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1903: MODULE => g_pkg || l_proc || 'End',
1904: MESSAGE => 'End of Procedure '||l_proc);
1905:
1906: END IF;

Line 1915: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1911:
1912: EXCEPTION
1913:
1914: WHEN OTHERS THEN
1915: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1916: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1917: fnd_message.set_token('Error is : ' ,SQLCODE);
1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:

Line 1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1916: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1917: fnd_message.set_token('Error is : ' ,SQLCODE);
1918: fnd_message.set_token('Reason is : ', SQLERRM);
1919:
1920: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1921: MODULE => g_pkg || l_proc,
1922: MESSAGE => fnd_message.get );
1923:
1924: END IF;

Line 1946: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1942:
1943: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
1944: l_proc := 'GET_LBL_SGFST';
1945:
1946: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1947:
1948: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1949: MODULE => g_pkg || l_proc || 'begin',
1950: MESSAGE => 'Start of Procedure '||l_proc);

Line 1948: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1944: l_proc := 'GET_LBL_SGFST';
1945:
1946: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1947:
1948: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1949: MODULE => g_pkg || l_proc || 'begin',
1950: MESSAGE => 'Start of Procedure '||l_proc);
1951:
1952: END IF;

Line 1974: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1970: ELSE
1971: l_label:=FND_MESSAGE.GET_STRING('BIL','BIL_BI_LABEL_SREP_FCST');
1972: END IF;
1973:
1974: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1975:
1976: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1977: MODULE => g_pkg || l_proc || 'End',
1978: MESSAGE => 'End of Procedure '||l_proc);

Line 1976: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

1972: END IF;
1973:
1974: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1975:
1976: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1977: MODULE => g_pkg || l_proc || 'End',
1978: MESSAGE => 'End of Procedure '||l_proc);
1979:
1980: END IF;

Line 1988: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1984: EXCEPTION
1985:
1986: WHEN OTHERS THEN
1987:
1988: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1990: fnd_message.set_token('Error is : ' ,SQLCODE);
1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:

Line 1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

1989: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1990: fnd_message.set_token('Error is : ' ,SQLCODE);
1991: fnd_message.set_token('Reason is : ', SQLERRM);
1992:
1993: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1994: MODULE => g_pkg || l_proc,
1995: MESSAGE => fnd_message.get );
1996:
1997: END IF;

Line 2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2035:
2036: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2037: l_proc := 'GET_PIPE_SNAP_DATE';
2038:
2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2040:
2041: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2042: MODULE => g_pkg || l_proc || 'begin',
2043: MESSAGE => 'Start of Procedure '||l_proc);

Line 2041: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2037: l_proc := 'GET_PIPE_SNAP_DATE';
2038:
2039: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2040:
2041: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2042: MODULE => g_pkg || l_proc || 'begin',
2043: MESSAGE => 'Start of Procedure '||l_proc);
2044:
2045: END IF;

Line 2102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2098: x_snap_date := l_snapshot_date;
2099: x_prev_snap_date := l_prev_snap_date;
2100:
2101:
2102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2103:
2104: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2105: MODULE => g_pkg || l_proc || 'End',
2106: MESSAGE => 'End of Procedure '||l_proc);

Line 2104: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2100:
2101:
2102: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2103:
2104: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2105: MODULE => g_pkg || l_proc || 'End',
2106: MESSAGE => 'End of Procedure '||l_proc);
2107:
2108: END IF;

Line 2114: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2110: EXCEPTION
2111:
2112: WHEN OTHERS THEN
2113:
2114: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2115: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2116: fnd_message.set_token('Error is : ' ,SQLCODE);
2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:

Line 2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

2115: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2116: fnd_message.set_token('Error is : ' ,SQLCODE);
2117: fnd_message.set_token('Reason is : ', SQLERRM);
2118:
2119: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2120: MODULE => g_pkg || l_proc,
2121: MESSAGE => fnd_message.get );
2122: END IF;
2123:

Line 2164: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2160: l_as_of_date := trunc(p_asof_date);
2161: l_period_type := p_period_type ;
2162:
2163:
2164: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2165:
2166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2167: MODULE => g_pkg || l_proc || 'begin',
2168: MESSAGE => 'Start of Procedure '||l_proc);

Line 2166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2162:
2163:
2164: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2165:
2166: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2167: MODULE => g_pkg || l_proc || 'begin',
2168: MESSAGE => 'Start of Procedure '||l_proc);
2169:
2170: END IF;

Line 2229: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2225: x_snapshot_date := l_snapshot_date ;
2226: x_prev_snap_date := l_prev_snap_date;
2227:
2228:
2229: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2230:
2231: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2232: MODULE => g_pkg || l_proc || 'End',
2233: MESSAGE => 'End of Procedure '||l_proc);

Line 2231: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2227:
2228:
2229: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2230:
2231: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2232: MODULE => g_pkg || l_proc || 'End',
2233: MESSAGE => 'End of Procedure '||l_proc);
2234:
2235: END IF;

Line 2247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2243: x_prev_snap_date := TRUNC(SYSDATE);
2244:
2245: WHEN OTHERS THEN
2246:
2247: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2249: fnd_message.set_token('Error is : ' ,SQLCODE);
2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:

Line 2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

2248: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2249: fnd_message.set_token('Error is : ' ,SQLCODE);
2250: fnd_message.set_token('Reason is : ', SQLERRM);
2251:
2252: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2253: MODULE => g_pkg || l_proc,
2254: MESSAGE => fnd_message.get );
2255:
2256: END IF;

Line 2286: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2282:
2283: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2284: l_proc := 'GET_HIST_SNAPSHOT_DATE';
2285:
2286: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2287:
2288: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2289: MODULE => g_pkg || l_proc || 'begin',
2290: MESSAGE => 'Start of Function '||l_proc);

Line 2288: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2284: l_proc := 'GET_HIST_SNAPSHOT_DATE';
2285:
2286: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2287:
2288: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2289: MODULE => g_pkg || l_proc || 'begin',
2290: MESSAGE => 'Start of Function '||l_proc);
2291:
2292: END IF;

Line 2334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2330: l_end_date := l_week_end_date;
2331: END IF;
2332:
2333:
2334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2335:
2336: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2337: MODULE => g_pkg || l_proc || 'End',
2338: MESSAGE => 'End of Procedure '||l_proc);

Line 2336: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2332:
2333:
2334: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2335:
2336: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2337: MODULE => g_pkg || l_proc || 'End',
2338: MESSAGE => 'End of Procedure '||l_proc);
2339:
2340: END IF;

Line 2352: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2348: RETURN TRUNC(SYSDATE);
2349:
2350: WHEN OTHERS THEN
2351:
2352: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2353: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2354: fnd_message.set_token('Error is : ' ,SQLCODE);
2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:

Line 2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

2353: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2354: fnd_message.set_token('Error is : ' ,SQLCODE);
2355: fnd_message.set_token('Reason is : ', SQLERRM);
2356:
2357: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2358: MODULE => g_pkg || l_proc,
2359: MESSAGE => fnd_message.get );
2360:
2361: END IF;

Line 2388: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2384:
2385: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2386: l_proc := 'GET_PIPE_COL_NAMES';
2387:
2388: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2389:
2390: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2391: MODULE => g_pkg || l_proc || 'begin',
2392: MESSAGE => 'Start of Function '||l_proc);

Line 2390: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2386: l_proc := 'GET_PIPE_COL_NAMES';
2387:
2388: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2389:
2390: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2391: MODULE => g_pkg || l_proc || 'begin',
2392: MESSAGE => 'Start of Function '||l_proc);
2393:
2394: END IF;

Line 2465: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2461: l_prev_amt := l_prev_amt||'YEAR';
2462: END CASE;
2463: END IF;
2464:
2465: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2466:
2467: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2468: MODULE => g_pkg || l_proc || 'End',
2469: MESSAGE => 'End of Function '||l_proc);

Line 2467: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2463: END IF;
2464:
2465: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2466:
2467: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2468: MODULE => g_pkg || l_proc || 'End',
2469: MESSAGE => 'End of Function '||l_proc);
2470:
2471: END IF;

Line 2478: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2474: EXCEPTION
2475:
2476: WHEN OTHERS THEN
2477:
2478: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2479: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2480: fnd_message.set_token('Error is : ' ,SQLCODE);
2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:

Line 2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

2479: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2480: fnd_message.set_token('Error is : ' ,SQLCODE);
2481: fnd_message.set_token('Reason is : ', SQLERRM);
2482:
2483: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2484: MODULE => g_pkg || l_proc,
2485: MESSAGE => fnd_message.get );
2486:
2487: END IF;

Line 2523: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2519:
2520: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
2521: l_proc := 'GET_PIPE_TREND_SOURCE';
2522:
2523: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2524:
2525: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2526: MODULE => g_pkg || l_proc || 'begin',
2527: MESSAGE => 'Start of Procedure '||l_proc);

Line 2525: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2521: l_proc := 'GET_PIPE_TREND_SOURCE';
2522:
2523: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2524:
2525: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2526: MODULE => g_pkg || l_proc || 'begin',
2527: MESSAGE => 'Start of Procedure '||l_proc);
2528:
2529: END IF;

Line 2611: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2607:
2608:
2609:
2610:
2611: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2612:
2613: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2614: MODULE => g_pkg || l_proc || 'End',
2615: MESSAGE => 'End of Procedure '||l_proc);

Line 2613: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

2609:
2610:
2611: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2612:
2613: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2614: MODULE => g_pkg || l_proc || 'End',
2615: MESSAGE => 'End of Procedure '||l_proc);
2616:
2617: END IF;

Line 2629: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2625: x_prev_snap_date := TRUNC(SYSDATE);
2626:
2627: WHEN OTHERS THEN
2628:
2629: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2630: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2631: fnd_message.set_token('Error is : ' ,SQLCODE);
2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:

Line 2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

2630: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2631: fnd_message.set_token('Error is : ' ,SQLCODE);
2632: fnd_message.set_token('Reason is : ', SQLERRM);
2633:
2634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2635: MODULE => g_pkg || l_proc,
2636: MESSAGE => fnd_message.get );
2637:
2638: END IF;