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

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

732: from fa_worker_jobs
733: where request_id = p_parent_request_id;
734:
735: if g_print_debug then
736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
737: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
738: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
739: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
740: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);

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

733: where request_id = p_parent_request_id;
734:
735: if g_print_debug then
736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
737: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
738: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
739: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
740: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
741: end if;

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

734:
735: if g_print_debug then
736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
737: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
738: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
739: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
740: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
741: end if;
742:

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

735: if g_print_debug then
736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
737: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
738: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
739: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
740: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
741: end if;
742:
743: if (l_failed_cnt > 0) then

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

736: fa_debug_pkg.add(l_calling_fn, 'Job status - Unassigned: ', l_unassigned_cnt);
737: fa_debug_pkg.add(l_calling_fn, 'Job status - In Process: ', l_wip_cnt);
738: fa_debug_pkg.add(l_calling_fn, 'Job status - Completed: ', l_completed_cnt);
739: fa_debug_pkg.add(l_calling_fn, 'Job status - Failed: ', l_failed_cnt);
740: fa_debug_pkg.add(l_calling_fn, 'Job status - Total: ', l_total_cnt);
741: end if;
742:
743: if (l_failed_cnt > 0) then
744: if g_print_debug then

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

741: end if;
742:
743: if (l_failed_cnt > 0) then
744: if g_print_debug then
745: fa_debug_pkg.add(l_calling_fn, 'another worker has errored out: ', 'stop processing');
746: end if;
747: raise error_found; -- probably not
748: elsif (l_unassigned_cnt = 0) then
749: if g_print_debug then

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

746: end if;
747: raise error_found; -- probably not
748: elsif (l_unassigned_cnt = 0) then
749: if g_print_debug then
750: fa_debug_pkg.add(l_calling_fn, 'no more jobs left', 'terminating.');
751: end if;
752: raise done_exc;
753: elsif (l_completed_cnt = l_total_cnt) then
754: if g_print_debug then

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

751: end if;
752: raise done_exc;
753: elsif (l_completed_cnt = l_total_cnt) then
754: if g_print_debug then
755: fa_debug_pkg.add(l_calling_fn, 'all jobs completed, no more jobs. ', 'terminating');
756: end if;
757: raise done_exc;
758: elsif (l_unassigned_cnt > 0) then
759: update fa_worker_jobs

Line 766: fa_debug_pkg.add(l_calling_fn, 'taking job from job queue', sql%rowcount);

762: where status = 'UNASSIGNED'
763: and request_id = p_parent_request_id
764: and rownum < 2;
765: if g_print_debug then
766: fa_debug_pkg.add(l_calling_fn, 'taking job from job queue', sql%rowcount);
767: end if;
768: l_count := sql%rowcount;
769: x_worker_jobs := l_unassigned_cnt;
770: commit;

Line 794: fa_debug_pkg.add(l_calling_fn, 'selecting', 'null ranges');

790:
791: exception
792:
793: when no_data_found then
794: fa_debug_pkg.add(l_calling_fn, 'selecting', 'null ranges');
795: end;
796:
797:
798: -- NOT hypothetical case

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

1087: and status = 'IN PROCESS';
1088: commit;
1089:
1090: if g_print_debug then
1091: fa_debug_pkg.add(l_calling_fn, 'updating', 'worker jobs');
1092: end if;
1093: end if;
1094:
1095: x_success_count := x_success_count + 1;

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

1093: end if;
1094:
1095: x_success_count := x_success_count + 1;
1096: if (g_print_debug) then
1097: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1098: end if;
1099: x_return_status := 0;
1100: return;
1101:

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

1111:
1112: x_failure_count := x_failure_count + 1;
1113: fa_srvr_msg.add_message(calling_fn => 'FARX_C_WD.WHATIF');
1114: if (g_print_debug) then
1115: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1116: end if;
1117: x_return_status := 2;
1118: return;
1119:

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

1129:
1130: x_failure_count := x_failure_count + 1;
1131: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');
1132: if (g_print_debug) then
1133: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1134: end if;
1135: x_return_status := 2;
1136: fa_whatif_deprn_pkg.g_deprn.delete;
1137: return;

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

1182: where book_type_code = p_book_type_code )
1183: group by unit_id;
1184:
1185: if g_print_debug then
1186: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', SQL%ROWCOUNT);
1187: end if;
1188:
1189: x_worker_jobs := sql%rowcount;
1190:

Line 1195: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', x_worker_jobs);

1191: commit;
1192: end if;
1193:
1194: if g_print_debug then
1195: fa_debug_pkg.add(l_calling_fn, 'rows inserted into worker jobs: ', x_worker_jobs);
1196: end if;
1197:
1198: x_return_status := 0;
1199:

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

1201: when OTHERS then
1202: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');
1203: rollback;
1204: if (g_print_debug) then
1205: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1206: end if;
1207: x_return_status := 2;
1208:
1209: END Load_Workers;