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

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

135: l_proc := 'BIL_BI_FRCST_OVERVIEW.';
136: g_sch_name := 'BIL';
137:
138:
139: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
140:
141: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
142: MODULE => g_pkg || l_proc || 'begin',
143: MESSAGE => 'Start of Procedure '||l_proc);

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

137:
138:
139: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
140:
141: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
142: MODULE => g_pkg || l_proc || 'begin',
143: MESSAGE => 'Start of Procedure '||l_proc);
144:
145: END IF;

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

217: ELSE
218: l_currency_suffix := '';
219: END IF;
220:
221: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
222:
223: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
224: MODULE => g_pkg || l_proc,
225: MESSAGE => 'l_parameter_valid = true');

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

219: END IF;
220:
221: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
222:
223: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
224: MODULE => g_pkg || l_proc,
225: MESSAGE => 'l_parameter_valid = true');
226:
227: END IF;

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

614: ' BIL_MEASURE10 IS NULL) ';
615: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
616:
617:
618: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
619:
620: l_sql_error_desc :=
621: 'l_viewby => '||l_viewby||', '||
622: 'l_curr_page_time_id => '|| l_curr_page_time_id ||', ' ||

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

631: 'l_fst_crdt_type => '|| l_fst_crdt_type ||', ' ||
632: 'l_calendar_id => '|| l_calendar_id;
633:
634:
635: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
636: MODULE => g_pkg || l_proc || 'l_sql_error_desc',
637: MESSAGE => l_sql_error_desc);
638:
639: END IF;

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

646: x_denorm => l_pipe_denorm,
647: x_where_clause => l_pipe_product_where_clause);
648:
649:
650: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
651:
652: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
653: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
654: MESSAGE => ' Prod cat '||l_prodcat_id);

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

648:
649:
650: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
651:
652: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
653: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
654: MESSAGE => ' Prod cat '||l_prodcat_id);
655:
656: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

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

652: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
653: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
654: MESSAGE => ' Prod cat '||l_prodcat_id);
655:
656: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
657: MODULE => g_pkg || l_proc || ' l_pipe_prod_where =>',
658: MESSAGE => ' l_pipe_product_where_clause '||l_pipe_product_where_clause);
659:
660: END IF;

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

870: ' AND tmp1.salesrep_id = :l_resource_id';
871: END IF;
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,
878: MESSAGE => 'before exec imm');

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,
878: MESSAGE => 'before exec imm');
879:
880: END IF;

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

879:
880: END IF;
881:
882:
883: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
884: l_ind :=1;
885: l_len:= length(l_custom_sql);
886:
887: WHILE l_ind <= l_len LOOP

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

886:
887: WHILE l_ind <= l_len LOOP
888: l_str:= substr(l_custom_sql, l_ind, 4000);
889:
890: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
891: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
892: MESSAGE => l_str);
893:
894: l_ind := l_ind + 4000;

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

1195: ' WHERE mtl.category_id (+) = tmp1.viewbyid)' ||
1196: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER,BIL_URL2 ';
1197:
1198:
1199: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1200:
1201: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1202: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
1203: MESSAGE => 'l_custom_sql length '||LENGTH(l_custom_sql));

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

1197:
1198:
1199: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1200:
1201: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1202: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
1203: MESSAGE => 'l_custom_sql length '||LENGTH(l_custom_sql));
1204:
1205: END IF;

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

1205: END IF;
1206:
1207:
1208:
1209: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1210: l_ind :=1;
1211: l_len:= length(l_custom_sql);
1212:
1213: WHILE l_ind <= l_len LOOP

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

1212:
1213: WHILE l_ind <= l_len LOOP
1214: l_str:= substr(l_custom_sql, l_ind, 4000);
1215:
1216: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1217: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1218: MESSAGE => l_str);
1219:
1220: l_ind := l_ind + 4000;

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

1404: ' )tmp1'||
1405: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER,BIL_URL2 ';
1406:
1407:
1408: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1409:
1410: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1411: MODULE => g_pkg || 'Prod cat Viewby ',
1412: MESSAGE => ' Forecast Query Product Cat not All ');

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

1406:
1407:
1408: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1409:
1410: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1411: MODULE => g_pkg || 'Prod cat Viewby ',
1412: MESSAGE => ' Forecast Query Product Cat not All ');
1413:
1414: END IF;

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

1413:
1414: END IF;
1415:
1416:
1417: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1418: l_ind :=1;
1419: l_len:= length(l_custom_sql);
1420:
1421: WHILE l_ind <= l_len LOOP

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

1420:
1421: WHILE l_ind <= l_len LOOP
1422: l_str:= substr(l_custom_sql, l_ind, 4000);
1423:
1424: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1425: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1426: MESSAGE => l_str);
1427:
1428: l_ind := l_ind + 4000;

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

1554: ' )tmp1'||
1555: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER,BIL_URL2 ';
1556:
1557:
1558: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1559:
1560: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1561: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
1562: MESSAGE => ' x_custom_sql length '||LENGTH(l_custom_sql));

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

1556:
1557:
1558: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1559:
1560: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1561: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
1562: MESSAGE => ' x_custom_sql length '||LENGTH(l_custom_sql));
1563:
1564: END IF;

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

1563:
1564: END IF;
1565:
1566:
1567: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1568: l_ind :=1;
1569: l_len:= length(l_custom_sql);
1570:
1571: WHILE l_ind <= l_len LOOP

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

1570:
1571: WHILE l_ind <= l_len LOOP
1572: l_str:= substr(l_custom_sql, l_ind, 4000);
1573:
1574: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1575: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
1576: MESSAGE => l_str);
1577:
1578: l_ind := l_ind + 4000;

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

1693: END IF;
1694: END CASE;
1695:
1696:
1697: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1698: l_ind :=1;
1699: l_len:= length(l_custom_sql);
1700:
1701: WHILE l_ind <= l_len LOOP

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

1700:
1701: WHILE l_ind <= l_len LOOP
1702: l_str:= substr(l_custom_sql, l_ind, 4000);
1703:
1704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1705: MODULE => g_pkg || l_proc ||'.'|| 'Final Query =>',
1706: MESSAGE => l_str);
1707:
1708: l_ind := l_ind + 4000;

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

1711: END IF;
1712:
1713:
1714:
1715: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716:
1717: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1718: MODULE => g_pkg || l_proc || 'Query Length=>',
1719: MESSAGE => length(x_custom_sql));

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

1713:
1714:
1715: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716:
1717: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1718: MODULE => g_pkg || l_proc || 'Query Length=>',
1719: MESSAGE => length(x_custom_sql));
1720:
1721: END IF;

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

1726: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
1727: ,x_sqlstr => x_custom_sql);
1728: END IF;
1729:
1730: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1731:
1732: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1733: MODULE => g_pkg || l_proc || 'End',
1734: MESSAGE => 'End of Procedure '||l_proc);

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

1728: END IF;
1729:
1730: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1731:
1732: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1733: MODULE => g_pkg || l_proc || 'End',
1734: MESSAGE => 'End of Procedure '||l_proc);
1735: END IF;
1736:

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

1737:
1738: EXCEPTION
1739: WHEN OTHERS THEN
1740:
1741: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1742:
1743: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1744: fnd_message.set_token('Error is : ' ,SQLCODE);
1745: fnd_message.set_token('Reason is : ', SQLERRM);

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

1743: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1744: fnd_message.set_token('Error is : ' ,SQLCODE);
1745: fnd_message.set_token('Reason is : ', SQLERRM);
1746:
1747: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1748: MODULE => g_pkg || l_proc || 'proc_error',
1749: MESSAGE => fnd_message.get );
1750:
1751: END IF;

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

1861: l_proc := 'BIL_BI_FRCST_PRODCAT';
1862: g_sch_name := 'BIL';
1863:
1864:
1865: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1866:
1867: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1868: MODULE => g_pkg || l_proc || 'begin',
1869: MESSAGE => 'Start of Procedure '||l_proc);

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

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

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

1952: ELSE
1953: l_currency_suffix := '';
1954: END IF;
1955:
1956: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1957:
1958: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1959: MODULE => g_pkg || l_proc,
1960: MESSAGE => 'l_parameter_valid = true');

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

1954: END IF;
1955:
1956: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1957:
1958: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1959: MODULE => g_pkg || l_proc,
1960: MESSAGE => 'l_parameter_valid = true');
1961: END IF;
1962:

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

2235:
2236: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
2237:
2238:
2239: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2240:
2241: l_sql_error_desc :=
2242: 'l_viewby => '||l_viewby||', '||
2243: 'l_curr_page_time_id => '|| l_curr_page_time_id ||', ' ||

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

2255: 'l_fst_crdt_type => '|| l_fst_crdt_type ||', ' ||
2256: 'l_calendar_id => '|| l_calendar_id;
2257:
2258:
2259: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2260: MODULE => g_pkg || l_proc || 'l_sql_error_desc',
2261: MESSAGE => l_sql_error_desc);
2262:
2263: END IF;

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

2267: p_viewby => l_viewby,
2268: x_denorm => l_pipe_denorm,
2269: x_where_clause => l_pipe_product_where_clause);
2270:
2271: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2272:
2273: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2274: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
2275: MESSAGE => ' Prod cat '||l_prodcat_id);

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

2269: x_where_clause => l_pipe_product_where_clause);
2270:
2271: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2272:
2273: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2274: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
2275: MESSAGE => ' Prod cat '||l_prodcat_id);
2276:
2277: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

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

2273: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2274: MODULE => g_pkg || l_proc || ' l_viewby =>'||l_viewby,
2275: MESSAGE => ' Prod cat '||l_prodcat_id);
2276:
2277: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2278: MODULE => g_pkg || l_proc || ' l_pipe_prod_where =>',
2279: MESSAGE => ' l_pipe_product_where_clause '||l_pipe_product_where_clause);
2280: END IF;
2281:

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

2439: ' WHERE mtl.category_id (+) = tmp1.viewbyid)' ||
2440: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER ,BIL_URL1, BIL_URL2 ';
2441:
2442:
2443: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2444:
2445: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2446: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2447: MESSAGE => ' l_custom_sql length '||LENGTH(l_custom_sql));

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

2441:
2442:
2443: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2444:
2445: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2446: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2447: MESSAGE => ' l_custom_sql length '||LENGTH(l_custom_sql));
2448:
2449: END IF;

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

2448:
2449: END IF;
2450:
2451:
2452: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2453: l_ind :=1;
2454: l_len:= length(l_custom_sql);
2455:
2456: WHILE l_ind <= l_len LOOP

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

2455:
2456: WHILE l_ind <= l_len LOOP
2457: l_str:= substr(l_custom_sql, l_ind, 4000);
2458:
2459: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2460: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
2461: MESSAGE => l_str);
2462:
2463: l_ind := l_ind + 4000;

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

2672: l_custom_sql := l_custom_sql ||
2673: ' )tmp1'||
2674: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER,BIL_URL1,BIL_URL2 ';
2675:
2676: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2677:
2678: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2679: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2680: MESSAGE => ' Forecast Query Product Cat not All ');

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

2674: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER,BIL_URL1,BIL_URL2 ';
2675:
2676: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2677:
2678: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2679: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2680: MESSAGE => ' Forecast Query Product Cat not All ');
2681: END IF;
2682:

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

2681: END IF;
2682:
2683:
2684:
2685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2686: l_ind :=1;
2687: l_len:= length(l_custom_sql);
2688:
2689: WHILE l_ind <= l_len LOOP

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

2688:
2689: WHILE l_ind <= l_len LOOP
2690: l_str:= substr(l_custom_sql, l_ind, 4000);
2691:
2692: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2693: MODULE => g_pkg || l_proc ||'.'|| 'Forecast Query =>',
2694: MESSAGE => l_str);
2695:
2696: l_ind := l_ind + 4000;

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

2889: ' )tmp1'||
2890: ' GROUP BY VIEWBY, VIEWBYID, SORTORDER ,BIL_URL1, BIL_URL2 ';
2891:
2892:
2893: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2894:
2895: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2896: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2897: MESSAGE => ' x_custom_sql length '||LENGTH(l_custom_sql));

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

2891:
2892:
2893: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2894:
2895: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2896: MODULE => g_pkg || l_proc || 'Prod cat Viewby ',
2897: MESSAGE => ' x_custom_sql length '||LENGTH(l_custom_sql));
2898:
2899: END IF;

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

2898:
2899: END IF;
2900:
2901:
2902: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2903: l_ind :=1;
2904: l_len:= length(l_custom_sql);
2905:
2906: WHILE l_ind <= l_len LOOP

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

2905:
2906: WHILE l_ind <= l_len LOOP
2907: l_str:= substr(l_custom_sql, l_ind, 4000);
2908:
2909: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2910: MODULE => g_pkg || l_proc ||'.'|| ' Oppty Pipe query ',
2911: MESSAGE => l_str);
2912:
2913: l_ind := l_ind + 4000;

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

3162:
3163: END IF;
3164:
3165:
3166: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3167: l_ind :=1;
3168: l_len:= length(l_custom_sql);
3169:
3170: WHILE l_ind <= l_len LOOP

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

3169:
3170: WHILE l_ind <= l_len LOOP
3171: l_str:= substr(l_custom_sql, l_ind, 4000);
3172:
3173: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3174: MODULE => g_pkg || l_proc ||'.'|| ' Final Query ',
3175: MESSAGE => l_str);
3176:
3177: l_ind := l_ind + 4000;

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

3179: END LOOP;
3180: END IF;
3181:
3182:
3183: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3184:
3185: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3186: MODULE => g_pkg || l_proc || 'Query Length=>',
3187: MESSAGE => length(x_custom_sql));

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

3181:
3182:
3183: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3184:
3185: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3186: MODULE => g_pkg || l_proc || 'Query Length=>',
3187: MESSAGE => length(x_custom_sql));
3188:
3189: END IF;

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

3193: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
3194: ,x_sqlstr => x_custom_sql);
3195: END IF;
3196:
3197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3198:
3199: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3200: MODULE => g_pkg || l_proc || 'End',
3201: MESSAGE => 'End of Procedure '||l_proc);

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

3195: END IF;
3196:
3197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3198:
3199: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3200: MODULE => g_pkg || l_proc || 'End',
3201: MESSAGE => 'End of Procedure '||l_proc);
3202:
3203: END IF;

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

3204:
3205: EXCEPTION
3206: WHEN OTHERS THEN
3207:
3208: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3209: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3210: fnd_message.set_token('Error is : ' ,SQLCODE);
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:

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

3209: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3210: fnd_message.set_token('Error is : ' ,SQLCODE);
3211: fnd_message.set_token('Reason is : ', SQLERRM);
3212:
3213: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3214: MODULE => g_pkg || l_proc || 'proc_error',
3215: MESSAGE => fnd_message.get );
3216: END IF;
3217: RAISE;