APPS.BIL_TX_OPTY_LIST_RPT_PKG dependencies on BIL_TX_UTIL_RPT_PKG

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

84: l_conversion_type := nvl(FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE'), 'Corporate');
85:
86:
87: -- FND logging standard
88: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
89:
90: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
91: p_module => g_pkg || l_proc || 'begin',
92: p_msg => 'Start of Procedure '|| l_proc );

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

86:
87: -- FND logging standard
88: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
89:
90: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
91: p_module => g_pkg || l_proc || 'begin',
92: p_msg => 'Start of Procedure '|| l_proc );
93: END IF;
94:

Line 106: BIL_TX_UTIL_RPT_PKG.GET_PAGE_PARAMS

102:
103: l_customer_url2 := '''pFunctionName=ASN_CUSTDETGWAYPG&ASNReqAcsErrInDlg=Y&addBreadCrumb=Y&ASNReqFrmCustId=''||ascd.CUSTOMER_ID ';
104:
105:
106: BIL_TX_UTIL_RPT_PKG.GET_PAGE_PARAMS
107: (p_page_parameter_tbl => p_page_parameter_tbl
108: ,p_region_id => l_region_id
109: ,x_period_type => l_period_type
110: ,x_to_currency => l_to_currency

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

181:
182: -- insert into zz values(l_sql_error_desc);
183: -- commit;
184:
185: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
186: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
187: p_module => g_pkg || l_proc ,
188: p_msg => ' Params are =>'||l_sql_error_desc);
189:

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

182: -- insert into zz values(l_sql_error_desc);
183: -- commit;
184:
185: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
186: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
187: p_module => g_pkg || l_proc ,
188: p_msg => ' Params are =>'||l_sql_error_desc);
189:
190: END IF;

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

574: x_custom_sql := l_custom_sql||l_select1||l_select2||l_from||l_dummy_where_clause ;
575: END IF;
576:
577:
578: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
579: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
580: p_proc => l_proc,
581: p_query => x_custom_sql);
582: END IF;

Line 579: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,

575: END IF;
576:
577:
578: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
579: BIL_TX_UTIL_RPT_PKG.writeQuery(p_pkg => g_pkg,
580: p_proc => l_proc,
581: p_query => x_custom_sql);
582: END IF;
583: