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_STRATEGY_WF_PUB dependencies on FND_FILE

Line 125: fnd_file.put_line(FND_FILE.LOG, 'Failed Workflow: STATUS = ' || l_return_status || ' l_result= ' || l_result);

121: if (l_return_status in ('COMPLETE', 'ACTIVE', 'SUSPEND')) THEN
122: x_return_status := 'S';
123: else
124: x_return_status := 'F';
125: fnd_file.put_line(FND_FILE.LOG, 'Failed Workflow: STATUS = ' || l_return_status || ' l_result= ' || l_result);
126: fnd_file.put_line(FND_FILE.LOG, 'Database Error if any ' || 'sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
127: raise fnd_api.g_exc_unexpected_error;
128: end if;
129:

Line 126: fnd_file.put_line(FND_FILE.LOG, 'Database Error if any ' || 'sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

122: x_return_status := 'S';
123: else
124: x_return_status := 'F';
125: fnd_file.put_line(FND_FILE.LOG, 'Failed Workflow: STATUS = ' || l_return_status || ' l_result= ' || l_result);
126: fnd_file.put_line(FND_FILE.LOG, 'Database Error if any ' || 'sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
127: raise fnd_api.g_exc_unexpected_error;
128: end if;
129:
130: if (bConcProg = 'YES') then

Line 148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: if (bConcProg = 'YES') then
148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
151: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
152: else

Line 149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');

145: EXCEPTION
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: if (bConcProg = 'YES') then
148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
151: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
152: else
153: IEX_DEBUG_PUB.LogMessage( 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');

Line 150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');

146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: if (bConcProg = 'YES') then
148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
151: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
152: else
153: IEX_DEBUG_PUB.LogMessage( 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
154: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');

Line 151: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

147: if (bConcProg = 'YES') then
148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
151: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
152: else
153: IEX_DEBUG_PUB.LogMessage( 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
154: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');
155: IEX_DEBUG_PUB.LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

157: raise FND_API.G_EXC_UNEXPECTED_ERROR;
158:
159: WHEN OTHERS THEN
160: if (bConcProg = 'YES') then
161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
162: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
163: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
164: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
165: else

Line 162: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);

158:
159: WHEN OTHERS THEN
160: if (bConcProg = 'YES') then
161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
162: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
163: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
164: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
165: else
166: IEX_DEBUG_PUB.LogMessage( 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);

Line 163: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');

159: WHEN OTHERS THEN
160: if (bConcProg = 'YES') then
161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
162: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
163: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
164: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
165: else
166: IEX_DEBUG_PUB.LogMessage( 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
167: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');

Line 164: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

160: if (bConcProg = 'YES') then
161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
162: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
163: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');
164: fnd_file.put_line(FND_FILE.LOG, 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
165: else
166: IEX_DEBUG_PUB.LogMessage( 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
167: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');
168: IEX_DEBUG_PUB.LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 177: fnd_file.put_line(FND_FILE.LOG, mesg);

173:
174: PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2) is
175: BEGIN
176: if (mesg_level >= PG_DEBUG) then
177: fnd_file.put_line(FND_FILE.LOG, mesg);
178: -- fnd_file.put_line(FND_FILE.LOG, my_timestamp || ' ' || mesg);
179: end if;
180: END;
181:

Line 178: -- fnd_file.put_line(FND_FILE.LOG, my_timestamp || ' ' || mesg);

174: PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2) is
175: BEGIN
176: if (mesg_level >= PG_DEBUG) then
177: fnd_file.put_line(FND_FILE.LOG, mesg);
178: -- fnd_file.put_line(FND_FILE.LOG, my_timestamp || ' ' || mesg);
179: end if;
180: END;
181:
182: