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 57: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

53:
54: l_api_name := 'buildUniverse';
55: x_end_of_universe := true;
56:
57: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
58: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
59: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
60: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
61:

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

54: l_api_name := 'buildUniverse';
55: x_end_of_universe := true;
56:
57: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
58: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
59: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
60: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
61:
62: --chang updated for sql bind var 05/07/2003

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

55: x_end_of_universe := true;
56:
57: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
58: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
59: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
60: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
61:
62: --chang updated for sql bind var 05/07/2003
63: vstr1 := 'SELECT ';

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

56:
57: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Start time ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
58: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_id = ' || p_object_id);
59: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_object_type = ' || p_object_type);
60: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': p_last_object_scored = ' || p_last_object_scored);
61:
62: --chang updated for sql bind var 05/07/2003
63: vstr1 := 'SELECT ';
64: vstr2 := ' FROM ';

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

86: vstr2 || l_entity_name ||
87: vstr3 || l_select_column || vstr4 ||
88: ' AND ' || l_select_column || ' > :1 ' || --l_last_object_scored || --Added bind variable for bug#7166924 by schekuri on 25-Aug-2008
89: ' ORDER BY ' || l_select_column;
90: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': vPLSQL is ' || vPLSQL );
91:
92: -- "fill" the universe
93: open universe_cur for
94: vPLSQL using l_last_object_scored; --Added bind variable for bug#7166924 by schekuri on 25-Aug-2008

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

102: end if;
103: /*LOOP
104: if i > G_Batch_Size then
105: x_end_of_universe := false;
106: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':Batch size met');
107: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':last object : ' || p_last_object_scored);
108: return l_universe_ids;
109: end if;
110: i := i + 1;

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

103: /*LOOP
104: if i > G_Batch_Size then
105: x_end_of_universe := false;
106: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':Batch size met');
107: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ':last object : ' || p_last_object_scored);
108: return l_universe_ids;
109: end if;
110: i := i + 1;
111: fetch universe_cur into l_universe_ids(i);

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

114: end loop;*/
115: --End bug#7166924 by schekuri on 25-Aug-2008
116:
117: x_end_of_universe := true;
118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Reached the End');
119:
120: close universe_cur;
121: return l_universe_ids;
122: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

118: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': Reached the End');
119:
120: close universe_cur;
121: return l_universe_ids;
122: IEX_DEBUG_PUB.logMessage(G_PKG_NAME || ': ' || l_api_name || ': End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
123:
124: exception
125:
126: When No_Data_Found then

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

123:
124: exception
125:
126: When No_Data_Found then
127: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
128: return l_universe_ids;
129: When others Then
130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
131: return l_universe_ids;

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

126: When No_Data_Found then
127: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
128: return l_universe_ids;
129: When others Then
130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
131: return l_universe_ids;
132: end buildUniverse;
133:
134: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,