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 128: fa_debug_pkg.add(l_calling_fn,'Before','Fetching data', p_log_level_rec => g_log_level_rec);

124:
125: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
126:
127: if (g_log_level_rec.statement_level) then
128: fa_debug_pkg.add(l_calling_fn,'Before','Fetching data', p_log_level_rec => g_log_level_rec);
129: end if;
130:
131: /*Added for parallelism start */
132: if (p_total_requests > 1) then

Line 153: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt, p_log_level_rec => g_log_level_rec);

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

Line 154: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt, p_log_level_rec => g_log_level_rec);

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

Line 155: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt, p_log_level_rec => g_log_level_rec);

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

Line 156: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt, p_log_level_rec => g_log_level_rec);

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

Line 157: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt, p_log_level_rec => g_log_level_rec);

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

Line 158: fa_debug_pkg.add(l_calling_fn, 'Job status - p_parent_request_id ', p_parent_request_id, p_log_level_rec => g_log_level_rec);

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

Line 163: fa_debug_pkg.add(l_calling_fn, 'another worker has errored out: ', 'stop processing', p_log_level_rec => g_log_level_rec);

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

Line 168: fa_debug_pkg.add(l_calling_fn, 'no more jobs left', 'terminating.', p_log_level_rec => g_log_level_rec);

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

Line 173: fa_debug_pkg.add(l_calling_fn, 'all jobs completed, no more jobs. ', 'terminating', p_log_level_rec => g_log_level_rec);

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

Line 189: fa_debug_pkg.add(l_calling_fn, 'taking job from job queue', l_counter, p_log_level_rec => g_log_level_rec);

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

Line 195: fa_debug_pkg.add(l_calling_fn, 'exception ', ' raised', p_log_level_rec => g_log_level_rec);

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

Line 232: fa_debug_pkg.add(l_calling_fn, 'exception', 'raised', p_log_level_rec => g_log_level_rec);

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

Line 255: fa_debug_pkg.add(l_calling_fn,'After','Fetching data', p_log_level_rec => g_log_level_rec);

251: -- 7339522 closing the cursor after loop.
252: --close c_assets;
253:
254: if (g_log_level_rec.statement_level) then
255: fa_debug_pkg.add(l_calling_fn,'After','Fetching data', p_log_level_rec => g_log_level_rec);
256: end if;
257:
258: if l_itf_rowid.count = 0 then
259: raise done_exc;

Line 268: FA_DEBUG_PKG.initialize;

264: -- set savepoint
265: savepoint fapadj_savepoint;
266:
267: -- clear the debug stack for each asset
268: FA_DEBUG_PKG.initialize;
269: -- reset the message level to prevent bogus errors
270: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
271:
272: l_mesg_name := null;

Line 307: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

303: x_success_count := x_success_count + 1;
304: write_message(l_asset_number(l_loop_count),'FA_MCP_ADJUSTMENT_SUCCESS');
305:
306: if (g_log_level_rec.statement_level) then
307: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
308: end if;
309:
310: else
311: if(nvl(l_posting_status(l_loop_count),'NULL') <> 'POST' or

Line 409: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

405: x_success_count := x_success_count + 1;
406: write_message(l_asset_number(l_loop_count),'FA_MCP_ADJUSTMENT_SUCCESS');
407:
408: if (g_log_level_rec.statement_level) then
409: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
410: end if;
411:
412:
413: EXCEPTION -- exceptions

Line 421: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

417:
418: write_message(l_asset_number(l_loop_count),l_mesg_name);
419:
420: if (g_log_level_rec.statement_level) then
421: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
422: end if;
423:
424: rollback to savepoint fapadj_savepoint;
425:

Line 433: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

429: write_message(l_asset_number(l_loop_count),'FA_TAXUP_FAIL_TRX');
430: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
431:
432: if (g_log_level_rec.statement_level) then
433: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
434: end if;
435:
436: rollback to savepoint fapadj_savepoint;
437:

Line 481: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);

477: end if;
478:
479:
480: if g_log_level_rec.statement_level then
481: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
482: end if;
483:
484: end if;
485:

Line 501: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);

497: and status = 'IN PROCESS';
498: commit;
499:
500: if g_log_level_rec.statement_level then
501: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
502: end if;
503: end if;
504:
505: x_return_status := 0;

Line 519: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);

515: and status = 'IN PROCESS';
516: commit;
517:
518: if g_log_level_rec.statement_level then
519: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
520: end if;
521: end if;
522:
523: ROLLBACK WORK;

Line 528: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

524: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
525:
526: -- Dump Debug messages when run in debug mode to log file
527: if (g_log_level_rec.statement_level) then
528: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
529: end if;
530:
531: x_return_status := 2;
532:

Line 545: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);

541: and status = 'IN PROCESS';
542: commit;
543:
544: if g_log_level_rec.statement_level then
545: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs', p_log_level_rec => g_log_level_rec);
546: end if;
547: end if;
548:
549: ROLLBACK WORK;

Line 554: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

550: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
551:
552: -- Dump Debug messages when run in debug mode to log file
553: if (g_log_level_rec.statement_level) then
554: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
555: end if;
556:
557: x_return_status := 2;
558:

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

638: commit;
639: end if;
640:
641: if g_log_level_rec.statement_level then
642: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);
643: end if;
644:
645: x_return_status := 0;
646:

Line 655: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);

651: when OTHERS then
652: fa_srvr_msg.add_sql_error(calling_fn => 'FA_XADJ_ITF_PKG.Load_Workers', p_log_level_rec => g_log_level_rec);
653: rollback;
654: if (g_log_level_rec.statement_level) then
655: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
656: end if;
657: x_return_status := 2;
658:
659: END Load_Workers;