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

Line 30: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

26: l_outer_where_clause VARCHAR2(3200) ;
27:
28: BEGIN
29:
30: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.begin','BEGIN');
32: END IF;
33:
34: -- initilization of variables

Line 31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.begin','BEGIN');

27:
28: BEGIN
29:
30: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.begin','BEGIN');
32: END IF;
33:
34: -- initilization of variables
35:

Line 77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

73: ||'PERIOD_TYPE:'||l_period_type||','||'COMPARISION_TYPE:'||l_comparison_type||
74: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
75: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
76:
77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.parameters',dbg_msg);
79: END IF;
80:
81: /**********************************************************************************/

Line 78: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.parameters',dbg_msg);

74: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
75: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
76:
77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.parameters',dbg_msg);
79: END IF;
80:
81: /**********************************************************************************/
82: /* VIEWBYID : Minisite ID */

Line 141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

137: ' GROUP BY MSITES.ID,MSITES.VALUE';
138:
139: x_custom_sql := l_custom_sql;
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);
143: END IF;
144:
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);

138:
139: x_custom_sql := l_custom_sql;
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);
143: END IF;
144:
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: x_custom_output.Extend(4);

Line 178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

174:
175: x_custom_output(4) := l_custom_rec;
176: */
177:
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.end','END');
180: END IF;
181:
182: END GET_NEW_CUST_KPI_SQL;

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.end','END');

175: x_custom_output(4) := l_custom_rec;
176: */
177:
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.end','END');
180: END IF;
181:
182: END GET_NEW_CUST_KPI_SQL;
183:

Line 210: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

206: l_outer_where_clause VARCHAR2(3200) ;
207:
208:
209: BEGIN
210: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.begin','BEGIN');
212: END IF;
213:
214: -- initilization of variables

Line 211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.begin','BEGIN');

207:
208:
209: BEGIN
210: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.begin','BEGIN');
212: END IF;
213:
214: -- initilization of variables
215:

Line 281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

277: ||'PERIOD_TYPE:'||l_period_type||','||'COMPARISION_TYPE:'||l_comparison_type||
278: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
279: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
280:
281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.parameters',dbg_msg);
283: END IF;
284:
285: /*********************************************************************************/

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.parameters',dbg_msg);

278: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
279: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
280:
281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.parameters',dbg_msg);
283: END IF;
284:
285: /*********************************************************************************/
286: /* VIEWBYID : Minisite ID */

Line 370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

366:
367:
368: x_custom_sql := l_custom_sql;
369:
370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);
372: END IF;
373:
374: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);

367:
368: x_custom_sql := l_custom_sql;
369:
370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);
372: END IF;
373:
374: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
375: x_custom_output.Extend(8);

Line 438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

434:
435:
436:
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.end','END');
440: END IF;
441:
442: END GET_CART_ORD_KPIS_SQL;

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.end','END');

435:
436:
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.end','END');
440: END IF;
441:
442: END GET_CART_ORD_KPIS_SQL;
443: