124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
126: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
130: THEN
131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
132: p_module => g_pkg || l_proc || 'begin',
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
126: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
130: THEN
131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
132: p_module => g_pkg || l_proc || 'begin',
133: p_msg => 'Start of Procedure '|| l_proc );
127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
130: THEN
131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
132: p_module => g_pkg || l_proc || 'begin',
133: p_msg => 'Start of Procedure '|| l_proc );
134: END IF;
135:
255: ' l_orderBy =>'||l_orderBy|| ' , '||
256: ' l_sortBy =>'||l_sortBy|| ' , '||
257: 'l_frcst_owner =>' ||l_frcst_owner;
258:
259: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
260: THEN
261: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
262: p_module => g_pkg || l_proc,
263: p_msg => ' Params are =>'||l_log_param );
257: 'l_frcst_owner =>' ||l_frcst_owner;
258:
259: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
260: THEN
261: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
262: p_module => g_pkg || l_proc,
263: p_msg => ' Params are =>'||l_log_param );
264: END IF;
265: