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.FA_XADJ_ITF_PKG dependencies on FA_DEBUG_PKG

Line 125: fa_debug_pkg.add(l_calling_fn,'Before','Fetching data');

121:
122: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
123:
124: if (g_print_debug) then
125: fa_debug_pkg.add(l_calling_fn,'Before','Fetching data');
126: end if;
127:
128: /*Added for parallelism start */
129: if (p_total_requests > 1) then

Line 152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);

148: when others then
149: raise fapadj_err;
150: end;
151: if g_print_debug then
152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);

Line 153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);

149: raise fapadj_err;
150: end;
151: if g_print_debug then
152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);

Line 154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);

150: end;
151: if g_print_debug then
152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);
158: end if;

Line 155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);

151: if g_print_debug then
152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);
158: end if;
159:

Line 156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);

152: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);
158: end if;
159:
160: if (l_failed_cnt > 0) then

Line 157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);

153: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
154: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
155: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
156: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
157: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id);
158: end if;
159:
160: if (l_failed_cnt > 0) then
161: if g_print_debug then

Line 162: fa_debug_pkg.add(l_calling_fn, 'another worker has errored out: ', 'stop processing');

158: end if;
159:
160: if (l_failed_cnt > 0) then
161: if g_print_debug then
162: fa_debug_pkg.add(l_calling_fn, 'another worker has errored out: ', 'stop processing');
163: end if;
164: raise fapadj_err; -- probably not
165: elsif (l_unassigned_cnt = 0) then
166: if g_print_debug then

Line 167: fa_debug_pkg.add(l_calling_fn, 'no more jobs left', 'terminating.');

163: end if;
164: raise fapadj_err; -- probably not
165: elsif (l_unassigned_cnt = 0) then
166: if g_print_debug then
167: fa_debug_pkg.add(l_calling_fn, 'no more jobs left', 'terminating.');
168: end if;
169: raise done_exc;
170: elsif (l_completed_cnt = l_total_cnt) then
171: if g_print_debug then

Line 172: fa_debug_pkg.add(l_calling_fn, 'all jobs completed, no more jobs. ', 'terminating');

168: end if;
169: raise done_exc;
170: elsif (l_completed_cnt = l_total_cnt) then
171: if g_print_debug then
172: fa_debug_pkg.add(l_calling_fn, 'all jobs completed, no more jobs. ', 'terminating');
173: end if;
174: raise done_exc;
175: elsif (l_unassigned_cnt > 0) then
176: begin

Line 188: fa_debug_pkg.add(l_calling_fn, 'taking job from job queue', l_counter);

184:
185: l_counter := sql%rowcount;
186:
187: if g_print_debug then
188: fa_debug_pkg.add(l_calling_fn, 'taking job from job queue', l_counter);
189: end if;
190:
191: commit;
192: exception

Line 194: fa_debug_pkg.add(l_calling_fn, 'exception ', ' raised');

190:
191: commit;
192: exception
193: when others then
194: fa_debug_pkg.add(l_calling_fn, 'exception ', ' raised');
195: raise fapadj_err;
196: end;
197:
198:

Line 231: fa_debug_pkg.add(l_calling_fn, 'exception', 'raised');

227: where batch_id = p_batch_id
228: and fat.asset_number = fab.asset_number;
229:
230: when others then
231: fa_debug_pkg.add(l_calling_fn, 'exception', 'raised');
232: raise fapadj_err;
233: end;
234:
235: end if;

Line 251: fa_debug_pkg.add(l_calling_fn,'After','Fetching data');

247: limit l_batch_size;
248: close c_assets;
249:
250: if (g_print_debug) then
251: fa_debug_pkg.add(l_calling_fn,'After','Fetching data');
252: end if;
253:
254: if l_itf_rowid.count = 0 then
255: raise done_exc;

Line 264: FA_DEBUG_PKG.initialize;

260: -- set savepoint
261: savepoint fapadj_savepoint;
262:
263: -- clear the debug stack for each asset
264: FA_DEBUG_PKG.initialize;
265: -- reset the message level to prevent bogus errors
266: FA_SRVR_MSG.Set_Message_Level(message_level => 10);
267:
268: l_mesg_name := null;

Line 303: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

299: x_success_count := x_success_count + 1;
300: write_message(l_asset_number(l_loop_count),'FA_MCP_ADJUSTMENT_SUCCESS');
301:
302: if (g_print_debug) then
303: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
304: end if;
305:
306: else
307: if(nvl(l_posting_status(l_loop_count),'NULL') <> 'POST' or

Line 406: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

402: x_success_count := x_success_count + 1;
403: write_message(l_asset_number(l_loop_count),'FA_MCP_ADJUSTMENT_SUCCESS');
404:
405: if (g_print_debug) then
406: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
407: end if;
408:
409:
410: EXCEPTION -- exceptions

Line 418: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

414:
415: write_message(l_asset_number(l_loop_count),l_mesg_name);
416:
417: if (g_print_debug) then
418: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
419: end if;
420:
421: rollback to savepoint fapadj_savepoint;
422:

Line 430: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

426: write_message(l_asset_number(l_loop_count),'FA_TAXUP_FAIL_TRX');
427: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);
428:
429: if (g_print_debug) then
430: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
431: end if;
432:
433: rollback to savepoint fapadj_savepoint;
434:

Line 470: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');

466: end if;
467:
468:
469: if g_print_debug then
470: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');
471: end if;
472:
473: end if;
474:

Line 490: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');

486: and status = 'IN PROCESS';
487: commit;
488:
489: if g_print_debug then
490: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');
491: end if;
492: end if;
493:
494: x_return_status := 0;

Line 508: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');

504: and status = 'IN PROCESS';
505: commit;
506:
507: if g_print_debug then
508: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');
509: end if;
510: end if;
511:
512: ROLLBACK WORK;

Line 517: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

513: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
514:
515: -- Dump Debug messages when run in debug mode to log file
516: if (g_print_debug) then
517: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
518: end if;
519:
520: x_return_status := 2;
521:

Line 534: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');

530: and status = 'IN PROCESS';
531: commit;
532:
533: if g_print_debug then
534: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');
535: end if;
536: end if;
537:
538: ROLLBACK WORK;

Line 543: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

539: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);
540:
541: -- Dump Debug messages when run in debug mode to log file
542: if (g_print_debug) then
543: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
544: end if;
545:
546: x_return_status := 2;
547:

Line 623: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);

619: commit;
620: end if;
621:
622: if g_print_debug then
623: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);
624: end if;
625:
626: x_return_status := 0;
627:

Line 633: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);

629: when OTHERS then
630: fa_srvr_msg.add_sql_error(calling_fn => 'FA_XADJ_ITF_PKG.Load_Workers');
631: rollback;
632: if (g_print_debug) then
633: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
634: end if;
635: x_return_status := 2;
636:
637: END Load_Workers;