APPS.IEX_FILTER_PUB dependencies on FND_FILE

Line 73: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring engine object filter SQL: ' || vPLSQL);

69: --End Bug 9670348 27-May-2010 barathsr
70:
71: vPLSQL:=vPLSQL|| ' and '||l_select_column|| ' >0 '; --Added for Bug 9790046 22-Jun-2010 barathsr
72: vPLSQL:= vPLSQL|| ' ORDER BY ' || l_select_column;
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring engine object filter SQL: ' || vPLSQL);
74:
75: return vPLSQL;
76:
77: exception

Line 79: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Failed to construct Scoring engine object filter');

75: return vPLSQL;
76:
77: exception
78: when others then
79: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Failed to construct Scoring engine object filter');
80: return vPLSQL;
81:
82: end buildsql;
83:

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG,'sql-->'||vPLSQL);

163:
164:
165:
166: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': vPLSQL is ' || vPLSQL );
167: FND_FILE.PUT_LINE(FND_FILE.LOG,'sql-->'||vPLSQL);
168:
169: -- "fill" the universe
170: open universe_cur for
171: vPLSQL using l_last_object_scored; --Added bind variable for bug#7166924 by schekuri on 25-Aug-2008

Line 199: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'unv_size-->'||l_universe_ids.count);

195: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Reached the End');
196:
197: close universe_cur;
198: return l_universe_ids;
199: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'unv_size-->'||l_universe_ids.count);
200: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
201:
202: exception
203: