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.FND_APD dependencies on FND_FILE

Line 39: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');

35: FROM v$session
36: WHERE audsid = userenv('SESSIONID');
37: EXCEPTION
38: when no_data_found then
39: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
40: when others then
41: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
42: errmsg := substr(sqlerrm,1,80);
43: fnd_file.put_line(fnd_file.log,errmsg);

Line 41: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');

37: EXCEPTION
38: when no_data_found then
39: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
40: when others then
41: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
42: errmsg := substr(sqlerrm,1,80);
43: fnd_file.put_line(fnd_file.log,errmsg);
44: END;
45:

Line 43: fnd_file.put_line(fnd_file.log,errmsg);

39: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
40: when others then
41: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');
42: errmsg := substr(sqlerrm,1,80);
43: fnd_file.put_line(fnd_file.log,errmsg);
44: END;
45:
46: BEGIN
47: SELECT value

Line 53: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');

49: FROM v$parameter
50: WHERE name = 'user_dump_dest';
51: EXCEPTION
52: when no_data_found then
53: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
54: when others then
55: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
56: errmsg := substr(sqlerrm,1,80);
57: fnd_file.put_line(fnd_file.log,errmsg);

Line 55: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');

51: EXCEPTION
52: when no_data_found then
53: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
54: when others then
55: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
56: errmsg := substr(sqlerrm,1,80);
57: fnd_file.put_line(fnd_file.log,errmsg);
58: END;
59:

Line 57: fnd_file.put_line(fnd_file.log,errmsg);

53: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
54: when others then
55: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting user dump destination ');
56: errmsg := substr(sqlerrm,1,80);
57: fnd_file.put_line(fnd_file.log,errmsg);
58: END;
59:
60: BEGIN
61: select application_short_name , concurrent_program_name,

Line 78: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');

74: and fcr.concurrent_program_id = fcp.concurrent_program_id
75: and fcr.program_application_id = fcp.application_id;
76: EXCEPTION
77: when no_data_found then
78: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
79: when others then
80: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
81: errmsg := substr(sqlerrm,1,80);
82: fnd_file.put_line(fnd_file.log,errmsg);

Line 80: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');

76: EXCEPTION
77: when no_data_found then
78: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
79: when others then
80: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
81: errmsg := substr(sqlerrm,1,80);
82: fnd_file.put_line(fnd_file.log,errmsg);
83: END;
84:

Line 82: fnd_file.put_line(fnd_file.log,errmsg);

78: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
79: when others then
80: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error getting data from FND tables...');
81: errmsg := substr(sqlerrm,1,80);
82: fnd_file.put_line(fnd_file.log,errmsg);
83: END;
84:
85: BEGIN
86: vsql := 'begin gatherCPStat@rtperf(:1,:2,:3, ''C'',:4, :5, :6, :7, :8, :9 , :10); end; ';

Line 91: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error during remote procedure call');

87: execute immediate vsql using p_req_id,session,vdbname,parentreqid,vversion,tracefile,udump,module_id,flow_id,vduration;
88: EXCEPTION
89: when others then
90: errmsg := substr(sqlerrm,1,80);
91: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error during remote procedure call');
92: fnd_file.put_line(fnd_file.log,errmsg);
93: END;
94:
95: END collect;

Line 92: fnd_file.put_line(fnd_file.log,errmsg);

88: EXCEPTION
89: when others then
90: errmsg := substr(sqlerrm,1,80);
91: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error during remote procedure call');
92: fnd_file.put_line(fnd_file.log,errmsg);
93: END;
94:
95: END collect;
96:

Line 130: fnd_file.put_line(fnd_file.log,errmsg);

126: execute immediate vsql ;
127: EXCEPTION
128: when others then
129: errmsg := substr(sqlerrm,1,80);
130: fnd_file.put_line(fnd_file.log,errmsg);
131: END;
132: BEGIN
133: SELECT sid
134: INTO session

Line 139: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');

135: FROM v$session
136: WHERE audsid = userenv('SESSIONID');
137: EXCEPTION
138: when no_data_found then
139: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
140: when others then
141: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
142: errmsg := substr(sqlerrm,1,80);
143: fnd_file.put_line(fnd_file.log,errmsg);

Line 141: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');

137: EXCEPTION
138: when no_data_found then
139: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
140: when others then
141: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
142: errmsg := substr(sqlerrm,1,80);
143: fnd_file.put_line(fnd_file.log,errmsg);
144: END;
145:

Line 143: fnd_file.put_line(fnd_file.log,errmsg);

139: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
140: when others then
141: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');
142: errmsg := substr(sqlerrm,1,80);
143: fnd_file.put_line(fnd_file.log,errmsg);
144: END;
145:
146: BEGIN
147: SELECT value

Line 153: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');

149: FROM v$parameter
150: WHERE name = 'user_dump_dest';
151: EXCEPTION
152: when no_data_found then
153: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
154: when others then
155: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
156: errmsg := substr(sqlerrm,1,80);
157: fnd_file.put_line(fnd_file.log,errmsg);

Line 155: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');

151: EXCEPTION
152: when no_data_found then
153: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
154: when others then
155: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
156: errmsg := substr(sqlerrm,1,80);
157: fnd_file.put_line(fnd_file.log,errmsg);
158: END;
159:

Line 157: fnd_file.put_line(fnd_file.log,errmsg);

153: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
154: when others then
155: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting user dump destination ');
156: errmsg := substr(sqlerrm,1,80);
157: fnd_file.put_line(fnd_file.log,errmsg);
158: END;
159:
160: BEGIN
161: select application_short_name , concurrent_program_name,

Line 175: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');

171: and fcr.program_application_id = fcp.application_id;
172: EXCEPTION
173: when no_data_found then
174: errmsg := substr(sqlerrm,1,80);
175: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
176: when others then
177: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
178: errmsg := substr(sqlerrm,1,80);
179: fnd_file.put_line(fnd_file.log,errmsg);

Line 177: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');

173: when no_data_found then
174: errmsg := substr(sqlerrm,1,80);
175: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
176: when others then
177: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
178: errmsg := substr(sqlerrm,1,80);
179: fnd_file.put_line(fnd_file.log,errmsg);
180: END;
181: BEGIN

Line 179: fnd_file.put_line(fnd_file.log,errmsg);

175: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
176: when others then
177: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error getting data from FND tables...');
178: errmsg := substr(sqlerrm,1,80);
179: fnd_file.put_line(fnd_file.log,errmsg);
180: END;
181: BEGIN
182: vsql := 'begin gatherCPStat@rtperf(:1,:2,:3, ''I'',:4, :5, :6, :7, :8, :9 , :10); end; ';
183: execute immediate vsql using p_req_id,session,vdbname,parentreqid,vversion,tracefile,udump,module_id,flow_id,vduration;

Line 187: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error during remote procedure call');

183: execute immediate vsql using p_req_id,session,vdbname,parentreqid,vversion,tracefile,udump,module_id,flow_id,vduration;
184: EXCEPTION
185: when others then
186: errmsg := substr(sqlerrm,1,80);
187: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error during remote procedure call');
188: fnd_file.put_line(fnd_file.log,errmsg);
189: END;
190: END store_initial;
191:

Line 188: fnd_file.put_line(fnd_file.log,errmsg);

184: EXCEPTION
185: when others then
186: errmsg := substr(sqlerrm,1,80);
187: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error during remote procedure call');
188: fnd_file.put_line(fnd_file.log,errmsg);
189: END;
190: END store_initial;
191:
192: /*

Line 226: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');

222: FROM v$session
223: WHERE audsid = userenv('SESSIONID');
224: EXCEPTION
225: when no_data_found then
226: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
227: when others then
228: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
229: errmsg := substr(sqlerrm,1,80);
230: fnd_file.put_line(fnd_file.log,errmsg);

Line 228: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');

224: EXCEPTION
225: when no_data_found then
226: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
227: when others then
228: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
229: errmsg := substr(sqlerrm,1,80);
230: fnd_file.put_line(fnd_file.log,errmsg);
231: END;
232:

Line 230: fnd_file.put_line(fnd_file.log,errmsg);

226: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
227: when others then
228: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');
229: errmsg := substr(sqlerrm,1,80);
230: fnd_file.put_line(fnd_file.log,errmsg);
231: END;
232:
233: BEGIN
234: SELECT value

Line 240: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');

236: FROM v$parameter
237: WHERE name = 'user_dump_dest';
238: EXCEPTION
239: when no_data_found then
240: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
241: when others then
242: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
243: errmsg := substr(sqlerrm,1,80);
244: fnd_file.put_line(fnd_file.log,errmsg);

Line 242: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');

238: EXCEPTION
239: when no_data_found then
240: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
241: when others then
242: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
243: errmsg := substr(sqlerrm,1,80);
244: fnd_file.put_line(fnd_file.log,errmsg);
245: END;
246:

Line 244: fnd_file.put_line(fnd_file.log,errmsg);

240: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
241: when others then
242: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting user dump destination ');
243: errmsg := substr(sqlerrm,1,80);
244: fnd_file.put_line(fnd_file.log,errmsg);
245: END;
246:
247: BEGIN
248: select application_short_name , concurrent_program_name,

Line 261: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');

257: and fcr.program_application_id = fa.application_id
258: and fcr.concurrent_program_id = fcp.concurrent_program_id;
259: EXCEPTION
260: when no_data_found then
261: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
262: when others then
263: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
264: errmsg := substr(sqlerrm,1,80);
265: fnd_file.put_line(fnd_file.log,errmsg);

Line 263: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');

259: EXCEPTION
260: when no_data_found then
261: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
262: when others then
263: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
264: errmsg := substr(sqlerrm,1,80);
265: fnd_file.put_line(fnd_file.log,errmsg);
266: END;
267: BEGIN

Line 265: fnd_file.put_line(fnd_file.log,errmsg);

261: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
262: when others then
263: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error getting data from FND tables...');
264: errmsg := substr(sqlerrm,1,80);
265: fnd_file.put_line(fnd_file.log,errmsg);
266: END;
267: BEGIN
268: vsql := 'begin gatherCPStat@rtperf(:1,:2,:3, ''F'',:4, :5, :6, :7, :8, :9 , :10); end; ';
269: execute immediate vsql using p_req_id,session,vdbname,parentreqid,vversion,tracefile,udump,module_id,flow_id,vduration;

Line 272: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error during remote procedure call');

268: vsql := 'begin gatherCPStat@rtperf(:1,:2,:3, ''F'',:4, :5, :6, :7, :8, :9 , :10); end; ';
269: execute immediate vsql using p_req_id,session,vdbname,parentreqid,vversion,tracefile,udump,module_id,flow_id,vduration;
270: EXCEPTION
271: when others then
272: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error during remote procedure call');
273: errmsg := substr(sqlerrm,1,80);
274: fnd_file.put_line(fnd_file.log,errmsg);
275: END;
276:

Line 274: fnd_file.put_line(fnd_file.log,errmsg);

270: EXCEPTION
271: when others then
272: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error during remote procedure call');
273: errmsg := substr(sqlerrm,1,80);
274: fnd_file.put_line(fnd_file.log,errmsg);
275: END;
276:
277: END store_final;
278: