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.IEX_FILTER_PUB dependencies on IEX_DEBUG_PUB

Line 118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

114:
115: l_api_name := 'buildUniverse';
116: x_end_of_universe := true;
117:
118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
120: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
121: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
122:

Line 119: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);

115: l_api_name := 'buildUniverse';
116: x_end_of_universe := true;
117:
118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
120: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
121: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
122:
123: --chang updated for sql bind var 05/07/2003

Line 120: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);

116: x_end_of_universe := true;
117:
118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
120: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
121: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
122:
123: --chang updated for sql bind var 05/07/2003
124: vstr1 := 'SELECT ';

Line 121: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);

117:
118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
119: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
120: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
121: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
122:
123: --chang updated for sql bind var 05/07/2003
124: vstr1 := 'SELECT ';
125: vstr2 := ' FROM ';

Line 166: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': vPLSQL is ' || vPLSQL );

162: vPLSQL:= vPLSQL|| ' ORDER BY ' || l_select_column;
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

Line 183: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':Batch size met');

179: end if;
180: /*LOOP
181: if i > G_Batch_Size then
182: x_end_of_universe := false;
183: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':Batch size met');
184: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':last object : ' || p_last_object_scored);
185: return l_universe_ids;
186: end if;
187: i := i + 1;

Line 184: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':last object : ' || p_last_object_scored);

180: /*LOOP
181: if i > G_Batch_Size then
182: x_end_of_universe := false;
183: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':Batch size met');
184: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':last object : ' || p_last_object_scored);
185: return l_universe_ids;
186: end if;
187: i := i + 1;
188: fetch universe_cur into l_universe_ids(i);

Line 195: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Reached the End');

191: end loop;*/
192: --End bug#7166924 by schekuri on 25-Aug-2008
193:
194: x_end_of_universe := true;
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);

Line 200: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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:
204: When No_Data_Found then

Line 205: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);

201:
202: exception
203:
204: When No_Data_Found then
205: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
206: return l_universe_ids;
207: When others Then
208: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
209: return l_universe_ids;

Line 208: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);

204: When No_Data_Found then
205: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
206: return l_universe_ids;
207: When others Then
208: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
209: return l_universe_ids;
210: end buildUniverse;
211:
212: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,