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

Line 41: -- FND logging standard

37: l_proc := 'OPP_DETL_TAB.';
38: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
39:
40:
41: -- FND logging standard
42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
43:
44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
45: p_module => g_pkg || l_proc || 'begin',

Line 42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

38: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
39:
40:
41: -- FND logging standard
42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
43:
44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
45: p_module => g_pkg || l_proc || 'begin',
46: p_msg => 'Start of Procedure '|| l_proc );

Line 44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

40:
41: -- FND logging standard
42: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
43:
44: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
45: p_module => g_pkg || l_proc || 'begin',
46: p_msg => 'Start of Procedure '|| l_proc );
47: END IF;
48:

Line 161: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

157:
158:
159: x_custom_sql := l_custom_sql ||l_where_clause ;
160:
161: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
162: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
163: p_proc => l_proc,
164: p_query => x_custom_sql);
165: END IF;

Line 247: -- FND logging standard

243: l_proc := 'OPP_FLEX_TAB.';
244: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
245:
246:
247: -- FND logging standard
248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
249:
250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
251: p_module => g_pkg || l_proc || 'begin',

Line 248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

244: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
245:
246:
247: -- FND logging standard
248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
249:
250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
251: p_module => g_pkg || l_proc || 'begin',
252: p_msg => 'Start of Procedure '|| l_proc );

Line 250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

246:
247: -- FND logging standard
248: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
249:
250: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
251: p_module => g_pkg || l_proc || 'begin',
252: p_msg => 'Start of Procedure '|| l_proc );
253: END IF;
254:

Line 327: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

323: -- x_custom_sql := l_custom_sql||l_where_clause ;
324:
325: x_custom_sql := l_custom_sql;
326:
327: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
328: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
329: p_proc => l_proc,
330: p_query => x_custom_sql);
331: END IF;

Line 409: -- FND logging standard

405: l_period_set_name := NVL(FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR'), 'Accounting');
406: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
407:
408:
409: -- FND logging standard
410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
411:
412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',

Line 410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

406: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
407:
408:
409: -- FND logging standard
410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
411:
412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc );

Line 412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

408:
409: -- FND logging standard
410: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
411:
412: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
413: p_module => g_pkg || l_proc || 'begin',
414: p_msg => 'Start of Procedure '|| l_proc );
415: END IF;
416:

Line 511: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

507:
508:
509: x_custom_sql := l_custom_sql ;
510:
511: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
512: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
513: p_proc => l_proc,
514: p_query => x_custom_sql);
515: END IF;

Line 597: -- FND logging standard

593: l_proc := 'SALES_TEAM_TAB.';
594: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
595:
596:
597: -- FND logging standard
598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
599:
600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
601: p_module => g_pkg || l_proc || 'begin',

Line 598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

594: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
595:
596:
597: -- FND logging standard
598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
599:
600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
601: p_module => g_pkg || l_proc || 'begin',
602: p_msg => 'Start of Procedure '|| l_proc );

Line 600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

596:
597: -- FND logging standard
598: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
599:
600: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
601: p_module => g_pkg || l_proc || 'begin',
602: p_msg => 'Start of Procedure '|| l_proc );
603: END IF;
604:

Line 664: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

660:
661: x_custom_sql := l_custom_sql ;
662:
663:
664: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
665: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
666: p_proc => l_proc,
667: p_query => x_custom_sql);
668: END IF;

Line 740: -- FND logging standard

736: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
737:
738:
739:
740: -- FND logging standard
741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
742:
743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
744: p_module => g_pkg || l_proc || 'begin',

Line 741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

737:
738:
739:
740: -- FND logging standard
741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
742:
743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
744: p_module => g_pkg || l_proc || 'begin',
745: p_msg => 'Start of Procedure '|| l_proc );

Line 743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

739:
740: -- FND logging standard
741: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
742:
743: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
744: p_module => g_pkg || l_proc || 'begin',
745: p_msg => 'Start of Procedure '|| l_proc );
746: END IF;
747:

Line 823: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

819:
820:
821: x_custom_sql := l_custom_sql ;
822:
823: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
824: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
825: p_proc => l_proc,
826: p_query => x_custom_sql);
827: END IF;

Line 900: -- FND logging standard

896: l_proc := 'CONTACTS_TAB.';
897: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
898:
899:
900: -- FND logging standard
901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
902:
903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
904: p_module => g_pkg || l_proc || 'begin',

Line 901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

897: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
898:
899:
900: -- FND logging standard
901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
902:
903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
904: p_module => g_pkg || l_proc || 'begin',
905: p_msg => 'Start of Procedure '|| l_proc );

Line 903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

899:
900: -- FND logging standard
901: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
902:
903: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
904: p_module => g_pkg || l_proc || 'begin',
905: p_msg => 'Start of Procedure '|| l_proc );
906: END IF;
907:

Line 975: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

971:
972:
973: x_custom_sql := l_custom_sql ;
974:
975: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
976: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
977: p_proc => l_proc,
978: p_query => x_custom_sql);
979: END IF;

Line 1061: -- FND logging standard

1057: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1058:
1059:
1060:
1061: -- FND logging standard
1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1063:
1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1065: p_module => g_pkg || l_proc || 'begin',

Line 1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1058:
1059:
1060:
1061: -- FND logging standard
1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1063:
1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1065: p_module => g_pkg || l_proc || 'begin',
1066: p_msg => 'Start of Procedure '|| l_proc );

Line 1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1060:
1061: -- FND logging standard
1062: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1063:
1064: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1065: p_module => g_pkg || l_proc || 'begin',
1066: p_msg => 'Start of Procedure '|| l_proc );
1067: END IF;
1068:

Line 1122: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1118:
1119:
1120: x_custom_sql := l_custom_sql ;
1121:
1122: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1123: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1124: p_proc => l_proc,
1125: p_query => x_custom_sql);
1126: END IF;

Line 1202: -- FND logging standard

1198: l_proc := 'QUOTE_TAB.';
1199: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1200:
1201:
1202: -- FND logging standard
1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1204:
1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1206: p_module => g_pkg || l_proc || 'begin',

Line 1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1199: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1200:
1201:
1202: -- FND logging standard
1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1204:
1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1206: p_module => g_pkg || l_proc || 'begin',
1207: p_msg => 'Start of Procedure '|| l_proc );

Line 1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1201:
1202: -- FND logging standard
1203: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1204:
1205: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1206: p_module => g_pkg || l_proc || 'begin',
1207: p_msg => 'Start of Procedure '|| l_proc );
1208: END IF;
1209:

Line 1285: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1281:
1282:
1283: x_custom_sql := l_custom_sql ;
1284:
1285: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1286: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1287: p_proc => l_proc,
1288: p_query => x_custom_sql);
1289: END IF;

Line 1365: -- FND logging standard

1361: l_proc := 'PROJECTS_TAB.';
1362: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1363:
1364:
1365: -- FND logging standard
1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1367:
1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1369: p_module => g_pkg || l_proc || 'begin',

Line 1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1362: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1363:
1364:
1365: -- FND logging standard
1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1367:
1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1369: p_module => g_pkg || l_proc || 'begin',
1370: p_msg => 'Start of Procedure '|| l_proc );

Line 1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1364:
1365: -- FND logging standard
1366: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1367:
1368: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1369: p_module => g_pkg || l_proc || 'begin',
1370: p_msg => 'Start of Procedure '|| l_proc );
1371: END IF;
1372:

Line 1449: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1445:
1446:
1447: x_custom_sql := l_custom_sql ;
1448:
1449: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1450: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1451: p_proc => l_proc,
1452: p_query => x_custom_sql);
1453: END IF;

Line 1528: -- FND logging standard

1524: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1525:
1526:
1527:
1528: -- FND logging standard
1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1530:
1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1532: p_module => g_pkg || l_proc || 'begin',

Line 1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1525:
1526:
1527:
1528: -- FND logging standard
1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1530:
1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1532: p_module => g_pkg || l_proc || 'begin',
1533: p_msg => 'Start of Procedure '|| l_proc );

Line 1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1527:
1528: -- FND logging standard
1529: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1530:
1531: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1532: p_module => g_pkg || l_proc || 'begin',
1533: p_msg => 'Start of Procedure '|| l_proc );
1534: END IF;
1535:

Line 1607: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1603:
1604:
1605: x_custom_sql := l_custom_sql ;
1606:
1607: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1608: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1609: p_proc => l_proc,
1610: p_query => x_custom_sql);
1611: END IF;

Line 1690: -- FND logging standard

1686: l_proc := 'ATTACHMENTS_TAB.';
1687: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1688:
1689:
1690: -- FND logging standard
1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1692:
1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1694: p_module => g_pkg || l_proc || 'begin',

Line 1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1687: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1688:
1689:
1690: -- FND logging standard
1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1692:
1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1694: p_module => g_pkg || l_proc || 'begin',
1695: p_msg => 'Start of Procedure '|| l_proc );

Line 1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1689:
1690: -- FND logging standard
1691: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1692:
1693: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1694: p_module => g_pkg || l_proc || 'begin',
1695: p_msg => 'Start of Procedure '|| l_proc );
1696: END IF;
1697:

Line 1767: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1763:
1764:
1765: x_custom_sql := l_custom_sql ;
1766:
1767: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1768: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1769: p_proc => l_proc,
1770: p_query => x_custom_sql);
1771: END IF;

Line 1850: -- FND logging standard

1846: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_DETL_RPT_PKG.';
1847:
1848:
1849:
1850: -- FND logging standard
1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1852:
1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1854: p_module => g_pkg || l_proc || 'begin',

Line 1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

1847:
1848:
1849:
1850: -- FND logging standard
1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1852:
1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1854: p_module => g_pkg || l_proc || 'begin',
1855: p_msg => 'Start of Procedure '|| l_proc );

Line 1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

1849:
1850: -- FND logging standard
1851: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1852:
1853: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
1854: p_module => g_pkg || l_proc || 'begin',
1855: p_msg => 'Start of Procedure '|| l_proc );
1856: END IF;
1857:

Line 1909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

1905:
1906:
1907: x_custom_sql := l_custom_sql ;
1908:
1909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
1910: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
1911: p_proc => l_proc,
1912: p_query => x_custom_sql);
1913: END IF;