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

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

67:
68: l_fdcp_date_j := TO_CHAR(l_fdcp_date,'J');
69: l_fdpp_date_j := TO_CHAR(l_fdpp_date,'J');
70:
71: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
72: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
73: MODULE => l_module_name,
74: MESSAGE => ' Begining to construct query ..');
75: END IF;

Line 72: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

68: l_fdcp_date_j := TO_CHAR(l_fdcp_date,'J');
69: l_fdpp_date_j := TO_CHAR(l_fdpp_date,'J');
70:
71: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
72: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
73: MODULE => l_module_name,
74: MESSAGE => ' Begining to construct query ..');
75: END IF;
76:

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

264: ,DECODE(SUM(ASO_VALUE2),0,NULL,SUM(ASO_VALUE2)) ASO_VALUE2
265: FROM ('|| l_sql_text4 ||')
266: GROUP BY Rule_id ';
267:
268: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
269: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);
270: END IF;
271:
272: DELETE FROM ASO_BI_RPT_TMP2;

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

447:
448: l_fdcp_date_j := TO_CHAR(l_fdcp_date,'J');
449: l_fdpp_date_j := TO_CHAR(l_fdpp_date,'J');
450:
451: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
452: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
453: MODULE => l_module_name,
454: MESSAGE => ' Begining to construct query ..');
455: END IF;

Line 452: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

448: l_fdcp_date_j := TO_CHAR(l_fdcp_date,'J');
449: l_fdpp_date_j := TO_CHAR(l_fdpp_date,'J');
450:
451: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
452: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
453: MODULE => l_module_name,
454: MESSAGE => ' Begining to construct query ..');
455: END IF;
456:

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

704: GROUP BY DECODE(restl.resource_id,NULL,'''|| l_url ||''',NULL)
705: ,DECODE(restl.resource_id,NULL,grptl.group_name,restl.resource_name)
706: ,NVL(restl.resource_id,grptl.group_id) ';
707:
708: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
709: aso_bi_qot_util_pvt.write_query(l_sql_text2,l_module_name);
710: END IF;
711:
712: DELETE FROM ASO_BI_RPT_TMP1;

Line 768: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

764: x_custom_output.Extend;
765: x_custom_output(rec_index):=l_custom_rec;
766: EXCEPTION
767: WHEN OTHERS THEN
768: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
770: MODULE => l_module_name,
771: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
772: END IF;

Line 769: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,

765: x_custom_output(rec_index):=l_custom_rec;
766: EXCEPTION
767: WHEN OTHERS THEN
768: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
770: MODULE => l_module_name,
771: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
772: END IF;
773: RAISE;

Line 869: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

865: x_viewby => l_viewby,
866: x_prodcat_id => l_prodcat_id,
867: x_product_id => l_product_id);
868:
869: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
871: MODULE => l_module_name,
872: MESSAGE => ' Begining to construct query ..');
873: END IF;

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

866: x_prodcat_id => l_prodcat_id,
867: x_product_id => l_product_id);
868:
869: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
871: MODULE => l_module_name,
872: MESSAGE => ' Begining to construct query ..');
873: END IF;
874:

Line 875: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

871: MODULE => l_module_name,
872: MESSAGE => ' Begining to construct query ..');
873: END IF;
874:
875: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
876: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
877: MODULE => l_module_name,
878: MESSAGE => ' Resource : ' || l_sr_id_num ||' Group is :' || l_sg_id_num || 'l_orderbyi :' ||l_orderBy);
879:

Line 876: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

872: MESSAGE => ' Begining to construct query ..');
873: END IF;
874:
875: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
876: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
877: MODULE => l_module_name,
878: MESSAGE => ' Resource : ' || l_sr_id_num ||' Group is :' || l_sg_id_num || 'l_orderbyi :' ||l_orderBy);
879:
880: END IF;

Line 1128: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1124: AND Res.Language = USERENV(''LANG'')
1125: GROUP BY Temp.ASO_VALUE12, Res.Resource_Name';
1126: END IF;
1127:
1128: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: aso_bi_qot_util_pvt.write_query(l_SQLTEXT10,' Quote Summary From temp table');
1130: END IF;
1131:
1132: /* Mappings...

Line 1321: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1317: ASO_VALUE9,
1318: ASO_VALUE10
1319: )';
1320:
1321: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1323: MODULE => l_module_name,
1324: MESSAGE => ' Begining insertion into ASO_BI_RPT_TMP1 ..');
1325: END IF;

Line 1322: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

1318: ASO_VALUE10
1319: )';
1320:
1321: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1323: MODULE => l_module_name,
1324: MESSAGE => ' Begining insertion into ASO_BI_RPT_TMP1 ..');
1325: END IF;
1326:

Line 1422: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1418:
1419: COMMIT;
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1423: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1424: MODULE => l_module_name,
1425: MESSAGE => 'Error while inserting into ASO_BI_RPT_TMP1'
1426: || sqlerrm);

Line 1423: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,

1419: COMMIT;
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1423: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1424: MODULE => l_module_name,
1425: MESSAGE => 'Error while inserting into ASO_BI_RPT_TMP1'
1426: || sqlerrm);
1427: END IF;

Line 1462: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1458: ASO_ATTRIBUTE1,
1459: ASO_URL1
1460: )';
1461:
1462: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1464: MODULE => l_module_name,
1465: MESSAGE => ' Begining insertion into ASO_BI_RPT_TMP2 ..');
1466: END IF;

Line 1463: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

1459: ASO_URL1
1460: )';
1461:
1462: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1464: MODULE => l_module_name,
1465: MESSAGE => ' Begining insertion into ASO_BI_RPT_TMP2 ..');
1466: END IF;
1467:

Line 1481: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1477: COMMIT;
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1483: MODULE => l_module_name,
1484: MESSAGE => 'Error while inserting into ASO_BI_RPT_TMP2'
1485: || sqlerrm);

Line 1482: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,

1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1483: MODULE => l_module_name,
1484: MESSAGE => 'Error while inserting into ASO_BI_RPT_TMP2'
1485: || sqlerrm);
1486: END IF;

Line 1491: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1487: RAISE;
1488: END;
1489:
1490:
1491: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1493: MODULE => l_module_name,
1494: MESSAGE => ' Construction of query string of length : '
1495: || length(l_SQLTEXT11));

Line 1492: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

1488: END;
1489:
1490:
1491: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1493: MODULE => l_module_name,
1494: MESSAGE => ' Construction of query string of length : '
1495: || length(l_SQLTEXT11));
1496: END IF;

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

1563: x_viewby => l_viewby,
1564: x_prodcat_id => l_prodcat_id,
1565: x_product_id => l_product_id);
1566:
1567: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1569: MODULE => l_module_name,
1570: MESSAGE => ' Entered Proc... ');
1571: END IF;

Line 1568: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1564: x_prodcat_id => l_prodcat_id,
1565: x_product_id => l_product_id);
1566:
1567: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1569: MODULE => l_module_name,
1570: MESSAGE => ' Entered Proc... ');
1571: END IF;
1572:

Line 1605: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1601: ELSIF UPPER(l_product_id) = 'ALL' THEN
1602: l_product_id := 'ALL';
1603: END IF;
1604:
1605: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1606: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
1607: MODULE => l_module_name,
1608: MESSAGE => ' PC id :' || l_prodcat_id || ' Prod Id :' || l_product_id ||' l_sg_id :' || l_sg_id_num
1609: || ' l_sr_id :' || l_sr_id_num ||'View By :'|| l_viewby ||'l_record_type_id :' ||l_record_type_id

Line 1606: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

1602: l_product_id := 'ALL';
1603: END IF;
1604:
1605: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1606: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
1607: MODULE => l_module_name,
1608: MESSAGE => ' PC id :' || l_prodcat_id || ' Prod Id :' || l_product_id ||' l_sg_id :' || l_sg_id_num
1609: || ' l_sr_id :' || l_sr_id_num ||'View By :'|| l_viewby ||'l_record_type_id :' ||l_record_type_id
1610: || 'l_fdcp_date_j : '||l_fdcp_date_j|| 'l_fdpp_date_j :'||l_fdpp_date_j );

Line 1832: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1828:
1829: l_outer_select := REPLACE(l_outer_select,' ',' ');
1830: l_outer_select := REPLACE(l_outer_select,' ',' ');
1831:
1832: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1833: aso_bi_qot_util_pvt.write_query(l_outer_select,'Front end Query returned to PMV :');
1834: END IF;
1835:
1836: -- Return the values

Line 1841: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1837: x_custom_sql := l_outer_select;
1838: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1842: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1843: MODULE => l_module_name,
1844: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
1845: END IF;

Line 1842: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,

1838: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1842: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
1843: MODULE => l_module_name,
1844: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
1845: END IF;
1846: RAISE;

Line 1916: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1912: x_viewby => l_viewby,
1913: x_prodcat_id => l_prodcat_id,
1914: x_product_id => l_product_id);
1915:
1916: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1918: MODULE => l_module_name,
1919: MESSAGE => ' Begining to construct query ..');
1920: END IF;

Line 1917: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

1913: x_prodcat_id => l_prodcat_id,
1914: x_product_id => l_product_id);
1915:
1916: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
1918: MODULE => l_module_name,
1919: MESSAGE => ' Begining to construct query ..');
1920: END IF;
1921:

Line 2145: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2141: l_query_string2 ||
2142: ' UNION ALL '|| l_query_string3||' ) GROUP BY Low';
2143:
2144:
2145: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2146: aso_bi_qot_util_pvt.write_query(l_query_string,' Query Is : ');
2147: END IF;
2148:
2149: -- Clean up the temp table

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

2327: END IF;
2328:
2329: l_query := replace(l_query_string,' ',' ');
2330:
2331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2332: aso_bi_qot_util_pvt.write_query(l_query,' Outer Query Is : ');
2333: END IF;
2334:
2335: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2335: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2332: aso_bi_qot_util_pvt.write_query(l_query,' Outer Query Is : ');
2333: END IF;
2334:
2335: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2336: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
2337: MODULE => l_module_name,
2338: MESSAGE => ' Construction of query string of length : '
2339: || length(l_query));

Line 2336: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,

2332: aso_bi_qot_util_pvt.write_query(l_query,' Outer Query Is : ');
2333: END IF;
2334:
2335: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2336: FND_LOG.STRING( LOG_LEVEL => FND_LOG.LEVEL_STATEMENT ,
2337: MODULE => l_module_name,
2338: MESSAGE => ' Construction of query string of length : '
2339: || length(l_query));
2340: END IF;

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

2572: --Initialize
2573: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
2574: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_TOPQUOT_SQL';
2575:
2576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2578: MODULE => l_module_name,
2579: MESSAGE => ' Entered Proc... ');
2580: END IF;

Line 2577: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

2573: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
2574: l_module_name := 'ASO_BI_QOT_SUMMRY_PVT.BY_TOPQUOT_SQL';
2575:
2576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
2578: MODULE => l_module_name,
2579: MESSAGE => ' Entered Proc... ');
2580: END IF;
2581:

Line 2760: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2756: x_custom_output(rec_index) := l_custom_rec;
2757:
2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2761: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
2762: MODULE => l_module_name,
2763: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
2764: END IF;

Line 2761: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,

2757:
2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2761: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR ,
2762: MODULE => l_module_name,
2763: MESSAGE => 'Error while executing the procedure '|| SQLERRM);
2764: END IF;
2765: RAISE;