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

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

92: l_region_id := 'BIL_BI_FRCST_WON_QUOTA_TREND';
93: l_yes := 'Y';
94: g_sch_name := 'BIL';
95:
96: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
97:
98: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
99: MODULE => g_pkg || l_proc || 'begin',
100: MESSAGE => 'Start of Procedure '|| l_proc);

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

94: g_sch_name := 'BIL';
95:
96: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
97:
98: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
99: MODULE => g_pkg || l_proc || 'begin',
100: MESSAGE => 'Start of Procedure '|| l_proc);
101:
102: END IF;

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

166: l_fst := 'BIL_BI_FST_PG_MV';
167: l_product_where_fst := 'AND sumry.product_category_id = :l_prodcat_id ';
168: END IF;
169:
170: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
173: MODULE => g_pkg || l_proc,
174: MESSAGE => 'Prod cat is '||NVL(l_prodcat_id, 0)||' Lang '||USERENV('LANG'));

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

168: END IF;
169:
170: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
171:
172: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
173: MODULE => g_pkg || l_proc,
174: MESSAGE => 'Prod cat is '||NVL(l_prodcat_id, 0)||' Lang '||USERENV('LANG'));
175:
176: END IF;

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

175:
176: END IF;
177:
178:
179: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
180:
181: l_sql_error_desc := ' l_curr_eff_end_date '||l_curr_eff_end_date||' l_curr_start_date '||l_curr_start_date||
182: ' l_curr_as_of_date '||l_curr_as_of_date||' l_calendar_id '|| l_calendar_id||
183: ' l_bitand_id '||l_bitand_id||' l_period_type '||l_period_type||

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

185: ' l_prev_eff_end_date '||l_prev_eff_end_date||
186: ' l_prev_start_date '||l_prev_start_date;
187:
188:
189: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
190: MODULE => g_pkg || l_proc,
191: MESSAGE => 'Parameters '||l_sql_error_desc);
192:
193: END IF;

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

206:
207: IF (l_comp_type = 'SEQUENTIAL' OR (l_comp_type = 'YEARLY' AND l_page_period_type = 'FII_TIME_ENT_YEAR')) THEN
208:
209:
210: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
211:
212: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
213: MODULE => g_pkg || l_proc,
214: MESSAGE => 'Sequential OR (Yearly and Year) ');

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

208:
209:
210: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
211:
212: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
213: MODULE => g_pkg || l_proc,
214: MESSAGE => 'Sequential OR (Yearly and Year) ');
215:
216: END IF;

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

303: AND ftime.end_date > :curr_prd_start_date
304: AND ftime.'|| l_column_name ||' = tmp.timeId(+)
305: ORDER BY ftime.end_date';
306:
307: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
308: l_ind :=1;
309: l_len:= length(l_custom_sql);
310:
311: WHILE l_ind <= l_len LOOP

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

310:
311: WHILE l_ind <= l_len LOOP
312: l_str:= substr(l_custom_sql, l_ind, 4000);
313:
314: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
315: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
316: MESSAGE => l_str);
317:
318: l_ind := l_ind + 4000;

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

324:
325: ELSIF (l_comp_type = 'YEARLY' and l_page_period_type = 'FII_TIME_WEEK') THEN/*Query for yearly week only */
326:
327:
328: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
329:
330: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
331: MODULE => g_pkg || l_proc,
332: MESSAGE => 'Yeary and Week ');

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

326:
327:
328: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
329:
330: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
331: MODULE => g_pkg || l_proc,
332: MESSAGE => 'Yeary and Week ');
333:
334: END IF;

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

412:
413: BEGIN
414:
415:
416: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
417: l_ind :=1;
418: l_len:= length(l_sql_stmnt1);
419:
420: WHILE l_ind <= l_len LOOP

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

419:
420: WHILE l_ind <= l_len LOOP
421: l_str:= substr(l_sql_stmnt1, l_ind, 4000);
422:
423: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
424: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
425: MESSAGE => l_str);
426:
427: l_ind := l_ind + 4000;

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

490:
491: EXCEPTION
492: WHEN OTHERS THEN
493:
494: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
496: fnd_message.set_token('ERROR' ,SQLCODE);
497: fnd_message.set_token('REASON', SQLERRM);
498:

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

495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
496: fnd_message.set_token('ERROR' ,SQLCODE);
497: fnd_message.set_token('REASON', SQLERRM);
498:
499: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
500: MODULE => g_pkg || l_proc || 'proc_error',
501: MESSAGE => fnd_message.get );
502:
503: END IF;

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

579:
580: BEGIN
581:
582:
583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
584: l_ind :=1;
585: l_len:= length(l_sql_stmnt2);
586:
587: WHILE l_ind <= l_len LOOP

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

586:
587: WHILE l_ind <= l_len LOOP
588: l_str:= substr(l_sql_stmnt2, l_ind, 4000);
589:
590: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
591: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
592: MESSAGE => l_str);
593:
594: l_ind := l_ind + 4000;

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

656:
657: EXCEPTION
658: WHEN OTHERS THEN
659:
660: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661:
662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
663: fnd_message.set_token('ERROR' ,SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);

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

662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
663: fnd_message.set_token('ERROR' ,SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665:
666: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
667: MODULE => g_pkg || l_proc || 'proc_error',
668: MESSAGE => fnd_message.get );
669:
670: END IF;

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

687: EXECUTE IMMEDIATE l_insert_stmnt || l_sql_outer;
688: COMMIT;
689: EXCEPTION
690: WHEN OTHERS THEN
691: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
692:
693: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
694: fnd_message.set_token('ERROR' ,SQLCODE);
695: fnd_message.set_token('REASON', SQLERRM);

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

694: fnd_message.set_token('ERROR' ,SQLCODE);
695: fnd_message.set_token('REASON', SQLERRM);
696:
697:
698: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
699: MODULE => g_pkg || l_proc || 'proc_error',
700: MESSAGE => fnd_message.get );
701:
702: END IF;

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

718: ORDER BY ftime.end_date ';
719:
720:
721:
722: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
723: l_ind :=1;
724: l_len:= length(l_custom_sql);
725:
726: WHILE l_ind <= l_len LOOP

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

725:
726: WHILE l_ind <= l_len LOOP
727: l_str:= substr(l_custom_sql, l_ind, 4000);
728:
729: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
730: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
731: MESSAGE => l_str);
732:
733: l_ind := l_ind + 4000;

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

738:
739: /* Query for month and quarter year/year comparison*/
740: ELSE
741:
742: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
743:
744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
745: MODULE => g_pkg || l_proc,
746: MESSAGE => 'Query for month and quarter year/year comparison ');

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

740: ELSE
741:
742: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
743:
744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
745: MODULE => g_pkg || l_proc,
746: MESSAGE => 'Query for month and quarter year/year comparison ');
747:
748: END IF;

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

859:
860: x_custom_sql := l_custom_sql;
861:
862:
863: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
864: l_ind :=1;
865: l_len:= length(x_custom_sql);
866:
867: WHILE l_ind <= l_len LOOP

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

866:
867: WHILE l_ind <= l_len LOOP
868: l_str:= substr(x_custom_sql, l_ind, 4000);
869:
870: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
871: MODULE => g_pkg || l_proc ||'.'|| ' Final Query to PMV ',
872: MESSAGE => l_str);
873:
874: l_ind := l_ind + 4000;

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

1038:
1039: l_bind_ctr:=l_bind_ctr+1;
1040: END IF;
1041:
1042: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1043:
1044: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1045: MODULE => g_pkg || l_proc||'end',
1046: MESSAGE => 'End of Procedure '|| l_proc);

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

1040: END IF;
1041:
1042: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1043:
1044: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1045: MODULE => g_pkg || l_proc||'end',
1046: MESSAGE => 'End of Procedure '|| l_proc);
1047:
1048: END IF;

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

1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053:
1054: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);

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

1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);
1059:
1060: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1061: MODULE => g_pkg || l_proc || 'proc_error',
1062: MESSAGE => fnd_message.get );
1063:
1064: END IF;

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

1165: l_yes := 'Y';
1166: g_sch_name := 'BIL';
1167:
1168:
1169: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1170:
1171: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1172: MODULE => g_pkg || l_proc || 'begin',
1173: MESSAGE => 'Start of Procedure '|| l_proc);

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

1167:
1168:
1169: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1170:
1171: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1172: MODULE => g_pkg || l_proc || 'begin',
1173: MESSAGE => 'Start of Procedure '|| l_proc);
1174:
1175: END IF;

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

1262: l_pipe_group_by := ' ,eni1.parent_id';
1263: END IF;
1264:
1265:
1266: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1267:
1268: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1269: MODULE => g_pkg || l_proc ,
1270: MESSAGE => 'Prod cat is '||NVL(l_prodcat, 0)||' Lang '||USERENV('LANG'));

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

1264:
1265:
1266: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1267:
1268: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1269: MODULE => g_pkg || l_proc ,
1270: MESSAGE => 'Prod cat is '||NVL(l_prodcat, 0)||' Lang '||USERENV('LANG'));
1271:
1272: END IF;

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

1272: END IF;
1273:
1274:
1275:
1276: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1277:
1278: l_sql_error_desc := ' l_curr_eff_end_date '||l_curr_eff_end_date||' l_curr_start_date '||l_curr_start_date||
1279: ' l_curr_as_of_date '||l_curr_as_of_date||' l_calendar_id '|| l_calendar_id||
1280: ' l_bitand_id '||l_bitand_id||' l_period_type '||l_period_type||

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

1281: ' l_sg_id_num '||l_sg_id_num||' l_fst_crdt_type '||l_fst_crdt_type||' l_prev_eff_end_date '||l_prev_eff_end_date||
1282: ' l_prev_start_date '||l_prev_start_date;
1283:
1284:
1285: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1286: MODULE => g_pkg || l_proc ,
1287: MESSAGE => 'Parameters '||l_sql_error_desc);
1288:
1289: END IF;

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

1398: ORDER BY ftime.end_date';
1399:
1400:
1401:
1402: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1403: l_ind :=1;
1404: l_len:= length(l_custom_sql);
1405:
1406: WHILE l_ind <= l_len LOOP

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

1405:
1406: WHILE l_ind <= l_len LOOP
1407: l_str:= substr(l_custom_sql, l_ind, 4000);
1408:
1409: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1410: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1411: MESSAGE => l_str);
1412:
1413: l_ind := l_ind + 4000;

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

1495:
1496: BEGIN
1497:
1498:
1499: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1500: l_ind :=1;
1501: l_len:= length(l_sql_stmnt1);
1502:
1503: WHILE l_ind <= l_len LOOP

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

1502:
1503: WHILE l_ind <= l_len LOOP
1504: l_str:= substr(l_sql_stmnt1, l_ind, 4000);
1505:
1506: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1507: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1508: MESSAGE => l_str);
1509:
1510: l_ind := l_ind + 4000;

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

1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559:
1560: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1562: fnd_message.set_token('ERROR' ,SQLCODE);
1563: fnd_message.set_token('REASON', SQLERRM);
1564:

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

1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1562: fnd_message.set_token('ERROR' ,SQLCODE);
1563: fnd_message.set_token('REASON', SQLERRM);
1564:
1565: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1566: MODULE => g_pkg || l_proc || 'proc_error',
1567: MESSAGE => fnd_message.get );
1568:
1569: END IF;

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

1639:
1640: BEGIN
1641:
1642:
1643: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1644: l_ind :=1;
1645: l_len:= length(l_sql_stmnt2);
1646:
1647: WHILE l_ind <= l_len LOOP

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

1646:
1647: WHILE l_ind <= l_len LOOP
1648: l_str:= substr(l_sql_stmnt2, l_ind, 4000);
1649:
1650: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1651: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1652: MESSAGE => l_str);
1653:
1654: l_ind := l_ind + 4000;

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

1704:
1705: EXCEPTION
1706: WHEN OTHERS THEN
1707:
1708: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);

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

1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);
1713:
1714: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1715: MODULE => g_pkg || l_proc || 'proc_error',
1716: MESSAGE => fnd_message.get );
1717:
1718: END IF;

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

1734: COMMIT;
1735: EXCEPTION
1736: WHEN OTHERS THEN
1737:
1738: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);

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

1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);
1743:
1744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1745: MODULE => g_pkg || l_proc || 'proc_error',
1746: MESSAGE => fnd_message.get );
1747:
1748: END IF;

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

1761: ORDER BY ftime.end_date ';
1762:
1763:
1764:
1765: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1766: l_ind :=1;
1767: l_len:= length(l_custom_sql);
1768:
1769: WHILE l_ind <= l_len LOOP

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

1768:
1769: WHILE l_ind <= l_len LOOP
1770: l_str:= substr(l_custom_sql, l_ind, 4000);
1771:
1772: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1773: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1774: MESSAGE => l_str);
1775:
1776: l_ind := l_ind + 4000;

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

1896:
1897: x_custom_sql := l_custom_sql;
1898:
1899:
1900: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1901: l_ind :=1;
1902: l_len:= length(x_custom_sql);
1903:
1904: WHILE l_ind <= l_len LOOP

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

1903:
1904: WHILE l_ind <= l_len LOOP
1905: l_str:= substr(x_custom_sql, l_ind, 4000);
1906:
1907: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1908: MODULE => g_pkg || l_proc ||'.'|| ' Final Query to PMV ',
1909: MESSAGE => l_str);
1910:
1911: l_ind := l_ind + 4000;

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

2072: x_custom_attr(l_bind_ctr):=l_custom_rec;
2073: l_bind_ctr:=l_bind_ctr+1;
2074: END IF;
2075:
2076: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2077:
2078: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2079: MODULE => g_pkg || l_proc||'end',
2080: MESSAGE => 'End of Procedure '|| l_proc);

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

2074: END IF;
2075:
2076: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2077:
2078: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2079: MODULE => g_pkg || l_proc||'end',
2080: MESSAGE => 'End of Procedure '|| l_proc);
2081:
2082: END IF;

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

2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087:
2088: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);

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

2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);
2093:
2094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2095: MODULE => g_pkg || l_proc || 'proc_error',
2096: MESSAGE => fnd_message.get );
2097:
2098: END IF;

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

2189: l_yes := 'Y';
2190: g_sch_name := 'BIL';
2191:
2192:
2193: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2194:
2195: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2196: MODULE => g_pkg || l_proc || 'begin',
2197: MESSAGE => ' Start of Procedure '|| l_proc);

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

2191:
2192:
2193: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2194:
2195: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2196: MODULE => g_pkg || l_proc || 'begin',
2197: MESSAGE => ' Start of Procedure '|| l_proc);
2198:
2199: END IF;

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

2341: l_curr_eff_end_date, l_curr_eff_start_date;
2342: EXCEPTION
2343: WHEN OTHERS THEN
2344:
2345: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2347: fnd_message.set_token('Error is : ' ,SQLCODE);
2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:

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

2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2347: fnd_message.set_token('Error is : ' ,SQLCODE);
2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:
2350: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2351: MODULE => g_pkg || l_proc || 'proc_error',
2352: MESSAGE => fnd_message.get );
2353:
2354: END IF;

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

2559: l_custom_sql := REPLACE(l_custom_sql,' ',' ');
2560: x_custom_sql := l_custom_sql;
2561:
2562:
2563: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2564: l_ind :=1;
2565: l_len:= length(x_custom_sql);
2566:
2567: WHILE l_ind <= l_len LOOP

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

2566:
2567: WHILE l_ind <= l_len LOOP
2568: l_str:= substr(x_custom_sql, l_ind, 4000);
2569:
2570: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2571: MODULE => g_pkg || l_proc ||'.'|| ' Final Query to PMV ',
2572: MESSAGE => l_str);
2573:
2574: l_ind := l_ind + 4000;

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

2684: x_custom_attr(l_bind_ctr):=l_custom_rec;
2685: l_bind_ctr:=l_bind_ctr+1;
2686: end if;
2687:
2688: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2689:
2690: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2691: MODULE => g_pkg || l_proc || 'end',
2692: MESSAGE => ' End of Procedure '|| l_proc);

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

2686: end if;
2687:
2688: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2689:
2690: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2691: MODULE => g_pkg || l_proc || 'end',
2692: MESSAGE => ' End of Procedure '|| l_proc);
2693:
2694: END IF;

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

2694: END IF;
2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);

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

2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);
2703:
2704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2705: MODULE => g_pkg || l_proc || 'proc_error',
2706: MESSAGE => fnd_message.get );
2707:
2708: END IF;

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

2804: l_parameter_valid := FALSE;
2805: l_proc := 'BIL_BI_PIPELINE_MOMENTUM_TREND';
2806:
2807:
2808: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2809:
2810: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2811: MODULE => g_pkg || l_proc || '.begin ',
2812: MESSAGE => ' Start of Procedure '|| l_proc);

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

2806:
2807:
2808: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2809:
2810: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2811: MODULE => g_pkg || l_proc || '.begin ',
2812: MESSAGE => ' Start of Procedure '|| l_proc);
2813:
2814: END IF;

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

3027:
3028: END IF;
3029:
3030:
3031: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3032: l_ind :=1;
3033: l_len:= length(l_custom_sql);
3034:
3035: WHILE l_ind <= l_len LOOP

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

3034:
3035: WHILE l_ind <= l_len LOOP
3036: l_str:= substr(l_custom_sql, l_ind, 4000);
3037:
3038: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3039: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
3040: MESSAGE => l_str);
3041:
3042: l_ind := l_ind + 4000;

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

3044: END LOOP;
3045: END IF;
3046:
3047:
3048: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3049:
3050: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3051: MODULE => g_pkg || l_proc || '.statement ',
3052: MESSAGE => ' Binds: '||

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

3046:
3047:
3048: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3049:
3050: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3051: MODULE => g_pkg || l_proc || '.statement ',
3052: MESSAGE => ' Binds: '||
3053: ' l_viewby: '||l_viewby||
3054: ',l_conv_rate_selected: '||l_conv_rate_selected||

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

3224: l_bind_ctr:=l_bind_ctr+1;
3225: END IF;
3226:
3227:
3228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3229:
3230: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3231: MODULE => g_pkg || l_proc || '.end',
3232: MESSAGE => ' End of Procedure '|| l_proc);

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

3226:
3227:
3228: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3229:
3230: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3231: MODULE => g_pkg || l_proc || '.end',
3232: MESSAGE => ' End of Procedure '|| l_proc);
3233:
3234: END IF;

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

3235:
3236:
3237: EXCEPTION
3238: WHEN OTHERS THEN
3239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3241: fnd_message.set_token('Error is : ' ,SQLCODE);
3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:

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

3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3241: fnd_message.set_token('Error is : ' ,SQLCODE);
3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:
3244: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3245: MODULE => g_pkg || l_proc || 'proc_error',
3246: MESSAGE => fnd_message.get );
3247:
3248: END IF;

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

3343: l_parameter_valid := FALSE;
3344: l_proc := 'BIL.BI.WIN.LOSS.CONV.TREND';
3345: l_yes := 'Y';
3346:
3347: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3348:
3349: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3350: MODULE => g_pkg ||'.'||l_proc || '.begin ',
3351: MESSAGE => ' Start of Procedure '|| l_proc);

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

3345: l_yes := 'Y';
3346:
3347: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3348:
3349: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3350: MODULE => g_pkg ||'.'||l_proc || '.begin ',
3351: MESSAGE => ' Start of Procedure '|| l_proc);
3352:
3353: END IF;

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

3612: l_custom_sql := l_default_query;
3613:
3614: END IF;
3615:
3616: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3617: l_ind :=1;
3618: l_len:= length(l_custom_sql);
3619:
3620: WHILE l_ind <= l_len LOOP

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

3619:
3620: WHILE l_ind <= l_len LOOP
3621: l_str:= substr(l_custom_sql, l_ind, 4000);
3622:
3623: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3624: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
3625: MESSAGE => l_str);
3626:
3627: l_ind := l_ind + 4000;

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

3630: END IF;
3631:
3632:
3633:
3634: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3635:
3636: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3637: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.statement ',
3638: MESSAGE => ' Binds: '||

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

3632:
3633:
3634: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3635:
3636: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3637: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.statement ',
3638: MESSAGE => ' Binds: '||
3639: ' l_viewby: '||l_viewby||
3640: ',l_conv_rate_selected: '||l_conv_rate_selected||

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

3764:
3765: /* LATEST SNAPSHOT IMPLEMENTATION */
3766:
3767:
3768: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3769: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3770: MODULE => g_pkg ||'.'||l_proc || '.end ',
3771: MESSAGE => ' End of Procedure '|| l_proc);
3772: END IF;

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

3765: /* LATEST SNAPSHOT IMPLEMENTATION */
3766:
3767:
3768: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3769: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3770: MODULE => g_pkg ||'.'||l_proc || '.end ',
3771: MESSAGE => ' End of Procedure '|| l_proc);
3772: END IF;
3773:

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

3774:
3775: EXCEPTION
3776:
3777: WHEN OTHERS THEN
3778: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3780: fnd_message.set_token('Error is : ' ,SQLCODE);
3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:

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

3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3780: fnd_message.set_token('Error is : ' ,SQLCODE);
3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:
3783: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3784: MODULE => g_pkg || l_proc || 'proc_error',
3785: MESSAGE => fnd_message.get );
3786: END IF;
3787: COMMIT;

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

3881: l_proc := 'BIL_BI_FRCST_WON_TREND';
3882: l_yes := 'Y';
3883: g_sch_name := 'BIL';
3884:
3885: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3886:
3887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3888: MODULE => g_pkg || l_proc || '.begin ',
3889: MESSAGE => ' Start of Procedure '|| l_proc);

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

3883: g_sch_name := 'BIL';
3884:
3885: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3886:
3887: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3888: MODULE => g_pkg || l_proc || '.begin ',
3889: MESSAGE => ' Start of Procedure '|| l_proc);
3890:
3891: END IF;

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

3957: END CASE;
3958: END LOOP;
3959: END IF;
3960:
3961: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3962:
3963:
3964: l_sql_error_desc := 'l_period_type =>'||l_period_type ||',' ||
3965: 'l_bitand_id =>'||l_bitand_id || ', '||

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

3982: 'l_prev_eff_end_date: =>'||l_prev_eff_end_date ||',' ||
3983: 'l_parent_sls_grp_id: =>'||l_parent_sls_grp_id;
3984:
3985:
3986: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3987: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
3988: MESSAGE => 'Parameters '||l_sql_error_desc);
3989:
3990: END IF;

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

4041: AND show_period.end_date >= :l_prev_eff_start_date
4042: ORDER BY show_period.start_date desc)';
4043:
4044:
4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046:
4047: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4048: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4049: MESSAGE => 'l_time_sql: '||l_time_sql);

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

4043:
4044:
4045: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4046:
4047: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4048: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4049: MESSAGE => 'l_time_sql: '||l_time_sql);
4050: END IF;
4051:

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

4071: l_prev_eff_end_date,l_prev_eff_start_date;
4072:
4073: EXCEPTION
4074: WHEN OTHERS THEN
4075: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

4075: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4080: MODULE => g_pkg || l_proc || 'proc_error',
4081: MESSAGE => fnd_message.get );
4082: END IF;
4083: COMMIT;

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

4084: RAISE;
4085: END;
4086:
4087:
4088: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4089:
4090: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4091: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4092: MESSAGE => 'Comp type: '||l_comp_type);

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

4086:
4087:
4088: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4089:
4090: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4091: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4092: MESSAGE => 'Comp type: '||l_comp_type);
4093:
4094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

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

4090: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4091: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4092: MESSAGE => 'Comp type: '||l_comp_type);
4093:
4094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4095: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4096: MESSAGE => ' curr: '||l_curr_weeks||', prev: '||l_prev_weeks);
4097:
4098: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

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

4094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4095: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4096: MESSAGE => ' curr: '||l_curr_weeks||', prev: '||l_prev_weeks);
4097:
4098: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4099: MODULE => g_pkg || l_proc || g_pkg ||'.'||l_proc || '.debug ',
4100: MESSAGE => ' as of date: '||l_curr_as_of_date);
4101: END IF;
4102:

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

4256:
4257: x_custom_sql := l_custom_sql;
4258:
4259:
4260: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4261: l_ind :=1;
4262: l_len:= length(l_custom_sql);
4263:
4264: WHILE l_ind <= l_len LOOP

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

4263:
4264: WHILE l_ind <= l_len LOOP
4265: l_str:= substr(l_custom_sql, l_ind, 4000);
4266:
4267: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
4268: MODULE => g_pkg || l_proc ||'.'|| ' Final Query ',
4269: MESSAGE => l_str);
4270:
4271: l_ind := l_ind + 4000;

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

4406: x_custom_attr.Extend();
4407: x_custom_attr(l_bind_ctr):= l_custom_rec;
4408: l_bind_ctr:=l_bind_ctr+1;
4409:
4410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4411:
4412: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
4413: MODULE => g_pkg || l_proc || 'end',
4414: MESSAGE => ' End of Procedure '|| l_proc);

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

4408: l_bind_ctr:=l_bind_ctr+1;
4409:
4410: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4411:
4412: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
4413: MODULE => g_pkg || l_proc || 'end',
4414: MESSAGE => ' End of Procedure '|| l_proc);
4415:
4416: END IF;

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

4417:
4418:
4419: EXCEPTION
4420: WHEN OTHERS THEN
4421: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

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

4421: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4426: MODULE => g_pkg || l_proc || 'proc_error',
4427: MESSAGE => fnd_message.get );
4428:
4429: END IF;