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_APD

Line 1: package body fnd_apd as

1: package body fnd_apd as
2: /* $Header: AFRTPRFB.pls 120.1.12020000.2 2012/08/07 11:37:56 avmurthy ship $ */
3:
4: /*
5: * Procedure: collect

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 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 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 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 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 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 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 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 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 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 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 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: