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

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

172: l_default_query1 := ' ';
173: l_default_query2 := ' ';
174:
175:
176: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
177:
178: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
179: MODULE => g_pkg || l_proc || 'begin',
180: MESSAGE => 'Start of Procedure '|| l_proc);

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

174:
175:
176: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
177:
178: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
179: MODULE => g_pkg || l_proc || 'begin',
180: MESSAGE => 'Start of Procedure '|| l_proc);
181:
182: END IF;

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

348: x_prev_snap_date => l_prev_snap_date
349: );
350:
351:
352: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
353:
354: l_sql_error_desc := 'l_viewby => '||l_viewby||','||
355: 'l_curr_page_time_id => '|| l_curr_page_time_id ||',' ||
356: 'l_prev_page_time_id => '|| l_prev_page_time_id ||',' ||

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

365: 'l_calendar_id => '|| l_calendar_id ||',' ||
366: 'l_prodcat => '|| l_prodcat;
367:
368:
369: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
370: MODULE => g_pkg || l_proc,
371: MESSAGE => 'Params '||l_sql_error_desc);
372:
373: END IF;

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

423: --INTO l_buckets
424: --FROM BIL_BI_BUCKET_MV;
425:
426:
427: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
428:
429: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
430: MODULE => g_pkg || l_proc,
431: MESSAGE => 'No of buckets '|| l_buckets);

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

425:
426:
427: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
428:
429: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
430: MODULE => g_pkg || l_proc,
431: MESSAGE => 'No of buckets '|| l_buckets);
432:
433: END IF;

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

744: l_pipe_product_where_clause := l_pipe_product_where_clause||' AND sumry.grp_total_flag = 0 ';
745: END IF;
746:
747:
748: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749:
750: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
751: MODULE => g_pkg || l_proc || 'Sales grp view by',
752: MESSAGE => ' Product where clause '||l_pipe_product_where_clause);

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

746:
747:
748: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
749:
750: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
751: MODULE => g_pkg || l_proc || 'Sales grp view by',
752: MESSAGE => ' Product where clause '||l_pipe_product_where_clause);
753:
754: END IF;

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

822:
823: END IF;
824:
825:
826: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
827: l_ind :=1;
828: l_len:= length(x_custom_sql);
829:
830: WHILE l_ind <= l_len LOOP

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

829:
830: WHILE l_ind <= l_len LOOP
831: l_str:= substr(x_custom_sql, l_ind, 4000);
832:
833: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
834: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
835: MESSAGE => l_str);
836:
837: l_ind := l_ind + 4000;

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

840: END IF;
841:
842:
843:
844: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845:
846: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
847: MODULE => g_pkg || l_proc || 'Query Length=>',
848: MESSAGE => length(l_custom_sql));

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

842:
843:
844: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845:
846: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
847: MODULE => g_pkg || l_proc || 'Query Length=>',
848: MESSAGE => length(l_custom_sql));
849:
850: END IF;

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

854:
855: l_pipe_product_where_clause := l_pipe_product_where_clause||' AND sumry.grp_total_flag = 0 ';
856:
857:
858: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859:
860: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
861: MODULE => g_pkg || l_proc || ' Prod cat view by.Product where clause ',
862: MESSAGE => l_pipe_product_where_clause);

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

856:
857:
858: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
859:
860: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
861: MODULE => g_pkg || l_proc || ' Prod cat view by.Product where clause ',
862: MESSAGE => l_pipe_product_where_clause);
863:
864: END IF;

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

934: mtl.DESCRIPTION || '' ('' || mtl.CATEGORY_CONCAT_SEGS ||'')''),
935: VIEWBYID, BIL_URL1, BIL_URL2 ';
936:
937:
938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
939:
940: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
941: MODULE => g_pkg || l_proc || 'Query Length for View By '|| l_viewby,
942: MESSAGE => ' Length => '|| LENGTH('SELECT * FROM ( '||l_outer_select ||

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

936:
937:
938: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
939:
940: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
941: MODULE => g_pkg || l_proc || 'Query Length for View By '|| l_viewby,
942: MESSAGE => ' Length => '|| LENGTH('SELECT * FROM ( '||l_outer_select ||
943: ' FROM ('||l_custom_sql||') '||
944: ' ORDER BY SORT_ORDER,UPPER(VIEWBY))'|| l_null_rem_clause));

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

944: ' ORDER BY SORT_ORDER,UPPER(VIEWBY))'|| l_null_rem_clause));
945: END IF;
946:
947:
948: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
949: l_ind :=1;
950: l_len:= length(l_custom_sql);
951:
952: WHILE l_ind <= l_len LOOP

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

951:
952: WHILE l_ind <= l_len LOOP
953: l_str:= substr(l_custom_sql, l_ind, 4000);
954:
955: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
956: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
957: MESSAGE => l_str);
958:
959: l_ind := l_ind + 4000;

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

971:
972: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
973: ,p_lookupcode => 'ASSIGN_CATEG');
974:
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976:
977: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
978: MODULE => g_pkg || l_proc || ' Product cat is not all ',
979: MESSAGE => ' Product cat '||l_prodcat);

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

973: ,p_lookupcode => 'ASSIGN_CATEG');
974:
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976:
977: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
978: MODULE => g_pkg || l_proc || ' Product cat is not all ',
979: MESSAGE => ' Product cat '||l_prodcat);
980:
981: END IF;

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

1034:
1035: l_custom_sql := l_custom_sql||' ) GROUP BY SORT_ORDER,VIEWBY,VIEWBYID,BIL_URL1,BIL_URL2';
1036:
1037:
1038: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1039: l_ind :=1;
1040: l_len:= length(l_custom_sql);
1041:
1042: WHILE l_ind <= l_len LOOP

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

1041:
1042: WHILE l_ind <= l_len LOOP
1043: l_str:= substr(l_custom_sql, l_ind, 4000);
1044:
1045: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1046: MODULE => g_pkg || l_proc ||'.'|| 'Query populating temp table ',
1047: MESSAGE => l_str);
1048:
1049: l_ind := l_ind + 4000;

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

1077: x_custom_sql := REPLACE(x_custom_sql,' ',' ');
1078: x_custom_sql := REPLACE(x_custom_sql,' ',' ');
1079:
1080:
1081: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: l_ind :=1;
1083: l_len:= length(x_custom_sql);
1084:
1085: WHILE l_ind <= l_len LOOP

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

1084:
1085: WHILE l_ind <= l_len LOOP
1086: l_str:= substr(x_custom_sql, l_ind, 4000);
1087:
1088: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1089: MODULE => g_pkg || l_proc ||'.'|| ' Query ',
1090: MESSAGE => l_str);
1091:
1092: l_ind := l_ind + 4000;

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

1310: x_custom_sql := REPLACE(x_custom_sql, 'null BIL_MEASURE12,', l_default_query2);
1311:
1312: END IF;
1313:
1314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1315:
1316: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1317: MODULE => g_pkg || l_proc || 'End',
1318: MESSAGE => 'End of Procedure '||l_proc);

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

1312: END IF;
1313:
1314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1315:
1316: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1317: MODULE => g_pkg || l_proc || 'End',
1318: MESSAGE => 'End of Procedure '||l_proc);
1319:
1320: END IF;

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

1322:
1323: EXCEPTION
1324: WHEN OTHERS THEN
1325:
1326: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1327:
1328: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);

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

1329: fnd_message.set_token('ERRNO',SQLCODE);
1330: fnd_message.set_token('REASON',SQLERRM);
1331: fnd_message.set_token('ROUTINE',l_proc);
1332:
1333: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1334: MODULE => g_pkg || l_proc,
1335: MESSAGE => fnd_message.get );
1336:
1337: END IF;

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

1513: l_proc := 'BIL_BI_OPPTY_ACTIVITY.';
1514: l_rpt_str := 'BIL_BI_OPACTY_R';
1515: g_sch_name := 'BIL';
1516:
1517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1518:
1519: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1520: MODULE => g_pkg || l_proc || 'begin',
1521: MESSAGE => 'Start of Procedure '||l_proc);

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

1515: g_sch_name := 'BIL';
1516:
1517: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1518:
1519: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
1520: MODULE => g_pkg || l_proc || 'begin',
1521: MESSAGE => 'Start of Procedure '||l_proc);
1522:
1523: END IF;

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

1579: IF l_prodcat_id IS NULL THEN
1580: l_prodcat := 'All';
1581: END IF;
1582:
1583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1584:
1585: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1586: MODULE => g_pkg || l_proc,
1587: MESSAGE => ' Product Cat => '||l_prodcat);

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

1581: END IF;
1582:
1583: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1584:
1585: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1586: MODULE => g_pkg || l_proc,
1587: MESSAGE => ' Product Cat => '||l_prodcat);
1588:
1589: END IF;

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

1640: x_prev_snap_date => l_prev_snap_date
1641: );
1642:
1643:
1644: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1645:
1646: l_sql_error_desc := 'l_viewby => '||l_viewby||', '||
1647: 'l_curr_page_time_id => '|| l_curr_page_time_id ||', ' ||
1648: 'l_prev_page_time_id => '|| l_prev_page_time_id ||', ' ||

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

1657: 'l_calendar_id => '|| l_calendar_id ||', '||
1658: 'l_record_type_id => '||l_record_type_id;
1659:
1660:
1661: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
1662: MODULE => g_pkg || l_proc || 'Param values ' ,
1663: MESSAGE => 'Param values '||l_sql_error_desc);
1664:
1665: END IF;

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

1952: l_open_mv := ' BIL_BI_PIPE_G_V ';
1953: l_open_where_clause := l_open_where_clause||' AND sumry.grp_total_flag = 0 ';
1954:
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 || ' Prod cat view by.Product where clause ',
1960: MESSAGE => l_pipe_product_where_clause);

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

1954:
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 || ' Prod cat view by.Product where clause ',
1960: MESSAGE => l_pipe_product_where_clause);
1961:
1962: END IF;

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

2053: --For 'Assigned to Category' message
2054: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
2055: ,p_lookupcode => 'ASSIGN_CATEG');
2056:
2057: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2058:
2059: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2060: MODULE => g_pkg || l_proc || ' Product cat is not all ',
2061: MESSAGE => ' Product cat : '||l_prodcat_id);

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

2055: ,p_lookupcode => 'ASSIGN_CATEG');
2056:
2057: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2058:
2059: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2060: MODULE => g_pkg || l_proc || ' Product cat is not all ',
2061: MESSAGE => ' Product cat : '||l_prodcat_id);
2062:
2063: END IF;

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

2109: l_custom_sql := l_custom_sql||' ) GROUP BY SORT_ORDER, VIEWBY, VIEWBYID, BIL_URL1, BIL_URL2';
2110:
2111: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
2112:
2113: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2114: l_ind :=1;
2115: l_len:= length(l_custom_sql);
2116:
2117: WHILE l_ind <= l_len LOOP

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

2116:
2117: WHILE l_ind <= l_len LOOP
2118: l_str:= substr(l_custom_sql, l_ind, 4000);
2119:
2120: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2121: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
2122: MESSAGE => l_str);
2123:
2124: l_ind := l_ind + 4000;

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

2218: x_custom_sql := REPLACE(x_custom_sql,' ',' ');
2219:
2220: --Log the query being returned
2221:
2222: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2223:
2224: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2225: MODULE => g_pkg || l_proc,
2226: MESSAGE => ' x_custom_sql length '||LENGTH(x_custom_sql));

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

2220: --Log the query being returned
2221:
2222: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2223:
2224: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2225: MODULE => g_pkg || l_proc,
2226: MESSAGE => ' x_custom_sql length '||LENGTH(x_custom_sql));
2227:
2228: END IF;

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

2227:
2228: END IF;
2229:
2230:
2231: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2232: l_ind :=1;
2233: l_len:= length(x_custom_sql);
2234:
2235: WHILE l_ind <= l_len LOOP

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

2234:
2235: WHILE l_ind <= l_len LOOP
2236: l_str:= substr(x_custom_sql, l_ind, 4000);
2237:
2238: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2239: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
2240: MESSAGE => l_str);
2241:
2242: l_ind := l_ind + 4000;

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

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

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

2388: END IF;
2389:
2390: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2391:
2392: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2393: MODULE => g_pkg || l_proc || 'End',
2394: MESSAGE => 'End of Procedure '||l_proc);
2395:
2396: END IF;

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

2397:
2398: EXCEPTION
2399: WHEN OTHERS THEN
2400:
2401: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2402:
2403: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);

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

2404: fnd_message.set_token('ERROR' ,SQLCODE);
2405: fnd_message.set_token('REASON', SQLERRM);
2406: fnd_message.set_token('ROUTINE',l_proc);
2407:
2408: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2409: MODULE => g_pkg || l_proc || 'proc_error',
2410: MESSAGE => fnd_message.get );
2411:
2412: END IF;

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

2487: l_opty_status:= 'OPEN';
2488:
2489: -- log the start of this proc.
2490:
2491: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2492:
2493: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2494: MODULE => g_pkg || l_proc || 'begin',
2495: MESSAGE => 'Start of Procedure '||l_proc);

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

2489: -- log the start of this proc.
2490:
2491: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2492:
2493: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2494: MODULE => g_pkg || l_proc || 'begin',
2495: MESSAGE => 'Start of Procedure '||l_proc);
2496:
2497: END IF;

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

2508: l_parameter_valid := FALSE;
2509: l_err_msg := 'Null parameter';
2510: l_err_desc := 'l_currency';
2511:
2512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2513:
2514: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2515: MODULE => g_pkg || l_proc || 'Currency Fail!',
2516: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);

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

2510: l_err_desc := 'l_currency';
2511:
2512: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2513:
2514: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2515: MODULE => g_pkg || l_proc || 'Currency Fail!',
2516: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);
2517:
2518: END IF;

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

2531: l_parameter_valid := FALSE;
2532: l_err_msg := 'Null parameter(s)';
2533: l_err_desc := l_err_desc || ' ,SALES GROUP';
2534:
2535: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2536:
2537: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2538: MODULE => g_pkg || l_proc || 'Sales Group Fail!',
2539: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);

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

2533: l_err_desc := l_err_desc || ' ,SALES GROUP';
2534:
2535: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2536:
2537: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2538: MODULE => g_pkg || l_proc || 'Sales Group Fail!',
2539: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);
2540:
2541: END IF;

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

2547: l_parameter_valid := FALSE;
2548: l_err_msg := 'Null parameter';
2549: l_err_desc := 'l_period_type';
2550:
2551: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2552:
2553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2554: MODULE => g_pkg || l_proc || 'Period type Fail!',
2555: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);

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

2549: l_err_desc := 'l_period_type';
2550:
2551: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2552:
2553: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2554: MODULE => g_pkg || l_proc || 'Period type Fail!',
2555: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);
2556:
2557: END IF;

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

2573: l_opty_status := 'OPEN';
2574: l_err_msg := 'opty status is '||l_opty_status;
2575: l_err_desc := 'Defaulted to open opportunity';
2576:
2577: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2578:
2579: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2580: MODULE => g_pkg || l_proc || 'opty status default',
2581: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);

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

2575: l_err_desc := 'Defaulted to open opportunity';
2576:
2577: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2578:
2579: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2580: MODULE => g_pkg || l_proc || 'opty status default',
2581: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);
2582:
2583: END IF;

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

2599:
2600: l_err_desc := l_err_desc||' l_conversion_rate '||l_conv_rate_selected||' Curr date '||SYSDATE;
2601:
2602:
2603: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604:
2605: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2606: MODULE => g_pkg || l_proc || 'Query bind params',
2607: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);

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

2601:
2602:
2603: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604:
2605: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2606: MODULE => g_pkg || l_proc || 'Query bind params',
2607: MESSAGE => ' Mesg '||l_err_msg||' Desc '||l_err_desc);
2608:
2609: END IF;

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

2662: l_period_where := 'AND OPTY_STATUS = :l_opty_status '||l_period_where;
2663: END IF;
2664:
2665:
2666: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2667:
2668: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2669: MODULE => g_pkg || l_proc || 'l_period_where',
2670: MESSAGE => l_period_where);

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

2664:
2665:
2666: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2667:
2668: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2669: MODULE => g_pkg || l_proc || 'l_period_where',
2670: MESSAGE => l_period_where);
2671:
2672: END IF;

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

2779: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id,x_sqlstr => l_select_stmt);
2780: x_custom_sql := l_select_stmt;
2781: END IF;
2782:
2783: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2784: l_ind :=1;
2785: l_len:= length(x_custom_sql);
2786:
2787: WHILE l_ind <= l_len LOOP

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

2786:
2787: WHILE l_ind <= l_len LOOP
2788: l_str:= substr(x_custom_sql, l_ind, 4000);
2789:
2790: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
2791: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
2792: MESSAGE => l_str);
2793:
2794: l_ind := l_ind + 4000;

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

2795:
2796: END LOOP;
2797: END IF;
2798:
2799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2800:
2801: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2802: MODULE => g_pkg || l_proc || 'End',
2803: MESSAGE => 'End of Procedure '||l_proc);

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

2797: END IF;
2798:
2799: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2800:
2801: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2802: MODULE => g_pkg || l_proc || 'End',
2803: MESSAGE => 'End of Procedure '||l_proc);
2804:
2805: END IF;

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

2807: EXCEPTION
2808:
2809: WHEN OTHERS THEN
2810:
2811: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2812:
2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);

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

2813: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2814: fnd_message.set_token('Error is : ' ,SQLCODE);
2815: fnd_message.set_token('Reason is : ', SQLERRM);
2816:
2817: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2818: MODULE => g_pkg || l_proc || 'proc_error',
2819: MESSAGE => fnd_message.get );
2820:
2821: END IF;

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

2889: l_region_id := 'BIL_BI_OPPTY_LINE_DETAIL';
2890: l_proc := 'BIL_BI_OPPTY_LINE_DETAIL.';
2891:
2892:
2893: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2894:
2895: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2896: MODULE => g_pkg || l_proc || 'begin',
2897: MESSAGE => 'Start of Procedure '|| l_proc);

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

2891:
2892:
2893: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2894:
2895: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
2896: MODULE => g_pkg || l_proc || 'begin',
2897: MESSAGE => 'Start of Procedure '|| l_proc);
2898:
2899: END IF;

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

3014: If prod cat is ALL then IF part is executed else ELSE part is executed
3015:
3016: */
3017:
3018: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3019:
3020: l_sql_error_desc :=
3021: 'l_curr_as_of_date => '|| l_asof_date ||', ' ||
3022: 'l_period_type => '|| l_period_type ||', ' ||

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

3025: 'l_resource_id => '|| l_resource_id ||', ' ||
3026: 'l_prodcat_id => '|| l_prodcat_id ||', ' ||
3027: 'l_customer_id => '|| l_customer_id ;
3028:
3029: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3030: MODULE => g_pkg || l_proc ,
3031: MESSAGE => 'Parameters => '||l_sql_error_desc);
3032: END IF;
3033:

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

3182:
3183: --Log the query being returned
3184:
3185:
3186: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3187:
3188: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3189: MODULE => g_pkg || l_proc || 'Query Length=>',
3190: MESSAGE => ' x_custom_sql length '||LENGTH(x_custom_sql));

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

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

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

3192: END IF;
3193:
3194:
3195:
3196: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3197: l_ind :=1;
3198: l_len:= length(x_custom_sql);
3199:
3200: WHILE l_ind <= l_len LOOP

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

3199:
3200: WHILE l_ind <= l_len LOOP
3201: l_str:= substr(x_custom_sql, l_ind, 4000);
3202:
3203: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,
3204: MODULE => g_pkg || l_proc ||'.'|| ' statement ',
3205: MESSAGE => l_str);
3206:
3207: l_ind := l_ind + 4000;

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

3258: x_custom_attr(l_bind_ctr) := l_custom_rec;
3259: l_bind_ctr := l_bind_ctr+1;
3260:
3261:
3262: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3263:
3264: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3265: MODULE => g_pkg || l_proc || 'End',
3266: MESSAGE => 'End of Procedure '||l_proc);

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

3260:
3261:
3262: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3263:
3264: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,
3265: MODULE => g_pkg || l_proc || 'End',
3266: MESSAGE => 'End of Procedure '||l_proc);
3267:
3268: END IF;