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

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

40: /* those stores that the user does not have access to */
41: /**************************************************************************/
42: BEGIN
43:
44: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');
46: END IF;
47: -- initilization of variables
48:

Line 45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');

41: /**************************************************************************/
42: BEGIN
43:
44: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
45: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.begin','BEGIN');
46: END IF;
47: -- initilization of variables
48:
49: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

164: l_timetable||','||'CURR_START_DATE:'||l_cur_start||','||'PREV_START_DATE:'||
165: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
166: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
167:
168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.parameters',dbg_msg);
170: END IF;
171:
172: IF(l_comparison_type = 'SEQUENTIAL') THEN

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.parameters',dbg_msg);

165: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
166: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
167:
168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.parameters',dbg_msg);
170: END IF;
171:
172: IF(l_comparison_type = 'SEQUENTIAL') THEN
173:

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

398: END IF;
399:
400: x_custom_sql := l_custom_sql;
401:
402: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.query',l_custom_sql);
404: END IF;
405:
406: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.query',l_custom_sql);

399:
400: x_custom_sql := l_custom_sql;
401:
402: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.query',l_custom_sql);
404: END IF;
405:
406: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
407: x_custom_output.EXTEND(13);

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

498: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
499:
500: x_custom_output(13) := l_custom_rec;
501:
502: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.end','END');
504: END IF;
505:
506: END GET_ORDER_GRAPH_SQL;

Line 503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.end','END');

499:
500: x_custom_output(13) := l_custom_rec;
501:
502: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_order_graph_sql.end','END');
504: END IF;
505:
506: END GET_ORDER_GRAPH_SQL;
507:

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

546: /* those stores that the user does not have access to */
547: /**************************************************************************/
548: BEGIN
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.begin','BEGIN');
552: END IF;
553:
554: -- initilization of variables

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.begin','BEGIN');

547: /**************************************************************************/
548: BEGIN
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.begin','BEGIN');
552: END IF;
553:
554: -- initilization of variables
555:

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

674: l_timetable||','||'CURR_START_DATE:'||l_cur_start||','||'PREV_START_DATE:'||
675: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
676: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
677:
678: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.parameters',dbg_msg);
680: END IF;
681:
682: IF(l_comparison_type = 'SEQUENTIAL') THEN

Line 679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.parameters',dbg_msg);

675: l_prev_start||','||'MID_START_DATE:'||l_mid_start||','||'CURR_YEAR:'||
676: l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||'TIME_SPAN:'||l_timespan;
677:
678: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.parameters',dbg_msg);
680: END IF;
681:
682: IF(l_comparison_type = 'SEQUENTIAL') THEN
683:

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

957: END IF;
958:
959: x_custom_sql := l_custom_sql;
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.query',l_custom_sql);
963: END IF;
964:
965: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.query',l_custom_sql);

958:
959: x_custom_sql := l_custom_sql;
960:
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
962: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.query',l_custom_sql);
963: END IF;
964:
965: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
966: x_custom_output.EXTEND(13);

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

1056: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1057:
1058: x_custom_output(13) := l_custom_rec;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.end','END');
1062: END IF;
1063:
1064: END GET_AVG_ORD_GRAPH_SQL;

Line 1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.end','END');

1057:
1058: x_custom_output(13) := l_custom_rec;
1059:
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_ord_graph_sql.end','END');
1062: END IF;
1063:
1064: END GET_AVG_ORD_GRAPH_SQL;
1065:

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

1107:
1108:
1109: BEGIN
1110:
1111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.begin','BEGIN');
1113: END IF;
1114:
1115: -- initilization of variables

Line 1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.begin','BEGIN');

1108:
1109: BEGIN
1110:
1111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.begin','BEGIN');
1113: END IF;
1114:
1115: -- initilization of variables
1116:

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

1233: 'PREV_START_DATE:'||l_prev_start||','||'MID_START_DATE:'||l_mid_start||
1234: ','||'CURR_YEAR:'||l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||
1235: 'TIME_SPAN:'||l_timespan;
1236:
1237: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.parameters',dbg_msg);
1239: END IF;
1240:
1241: IF(l_comparison_type = 'SEQUENTIAL') THEN

Line 1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.parameters',dbg_msg);

1234: ','||'CURR_YEAR:'||l_cur_year||','||'PREV_YEAR:'||l_prev_year||','||
1235: 'TIME_SPAN:'||l_timespan;
1236:
1237: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.parameters',dbg_msg);
1239: END IF;
1240:
1241: IF(l_comparison_type = 'SEQUENTIAL') THEN
1242:

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

1514: x_custom_sql := l_custom_sql;
1515:
1516:
1517:
1518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql',l_custom_sql);
1520: END IF;
1521:
1522: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql',l_custom_sql);

1515:
1516:
1517:
1518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql',l_custom_sql);
1520: END IF;
1521:
1522: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1523: x_custom_output.EXTEND(13);

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

1615:
1616: x_custom_output(13) := l_custom_rec;
1617:
1618:
1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.end','END');
1621: END IF;
1622:
1623:

Line 1620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.end','END');

1616: x_custom_output(13) := l_custom_rec;
1617:
1618:
1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_ord_graph_pvt.get_avg_disc_graph_sql.end','END');
1621: END IF;
1622:
1623:
1624: END GET_AVG_DISC_GRAPH_SQL;