DBA Data[Home] [Help]

APPS.FA_MASS_DPR_RSV_ADJ_PKG dependencies on FA_DEBUG_PKG

Line 168: fa_debug_pkg.add(l_calling_fn,'opening c_assets cursor','');

164:
165: l_primary_sob_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
166:
167: if (g_log_level_rec.statement_level) then
168: fa_debug_pkg.add(l_calling_fn,'opening c_assets cursor','');
169: fa_debug_pkg.add(l_calling_fn,'g_start_pc',g_start_pc);
170: fa_debug_pkg.add(l_calling_fn,'g_end_pc',g_end_pc);
171: end if;
172:

Line 169: fa_debug_pkg.add(l_calling_fn,'g_start_pc',g_start_pc);

165: l_primary_sob_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
166:
167: if (g_log_level_rec.statement_level) then
168: fa_debug_pkg.add(l_calling_fn,'opening c_assets cursor','');
169: fa_debug_pkg.add(l_calling_fn,'g_start_pc',g_start_pc);
170: fa_debug_pkg.add(l_calling_fn,'g_end_pc',g_end_pc);
171: end if;
172:
173: Open c_assets;

Line 170: fa_debug_pkg.add(l_calling_fn,'g_end_pc',g_end_pc);

166:
167: if (g_log_level_rec.statement_level) then
168: fa_debug_pkg.add(l_calling_fn,'opening c_assets cursor','');
169: fa_debug_pkg.add(l_calling_fn,'g_start_pc',g_start_pc);
170: fa_debug_pkg.add(l_calling_fn,'g_end_pc',g_end_pc);
171: end if;
172:
173: Open c_assets;
174:

Line 178: fa_debug_pkg.add(l_calling_fn,'in main loop ' , '');

174:
175: loop
176:
177: if (g_log_level_rec.statement_level) then
178: fa_debug_pkg.add(l_calling_fn,'in main loop ' , '');
179: end if;
180:
181: fetch c_assets into l_asset_id;
182: Exit when c_assets%NOTFOUND;

Line 187: fa_debug_pkg.add(l_calling_fn,'in main block ' , '');

183:
184: BEGIN /* Inside Loop */
185:
186: if (g_log_level_rec.statement_level) then
187: fa_debug_pkg.add(l_calling_fn,'in main block ' , '');
188: end if;
189:
190: g_adj_asset_hdr_rec.asset_id := l_asset_id;
191:

Line 627: fa_debug_pkg.add(l_calling_fn,'g_asset_tax_rsv_adj_rec.adjusted_ytd_deprn',

623: --Bug7630553: fa_tax_rsv_adj_pub.do_tax_rsv_adj is expecting delta reserve between current one and user specified reserve
624: g_asset_tax_rsv_adj_rec.adjusted_ytd_deprn := (g_asset_tax_rsv_adj_rec.adjusted_ytd_deprn - l_deprn_rsv_adj_end);
625:
626: if (g_log_level_rec.statement_level) then
627: fa_debug_pkg.add(l_calling_fn,'g_asset_tax_rsv_adj_rec.adjusted_ytd_deprn',
628: g_asset_tax_rsv_adj_rec.adjusted_ytd_deprn, g_log_level_rec);
629: end if;
630:
631:

Line 680: fa_debug_pkg.add(l_calling_fn,'asset_ret ','');

676: fa_srvr_msg.add_message(
677: calling_fn => l_calling_fn,
678: name => 'FA_TAX_FULLY_RET');
679: if (g_log_level_rec.statement_level) then
680: fa_debug_pkg.add(l_calling_fn,'asset_ret ','');
681:
682: -- Commented for bugfix 4672237
683: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);
684:

Line 683: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);

679: if (g_log_level_rec.statement_level) then
680: fa_debug_pkg.add(l_calling_fn,'asset_ret ','');
681:
682: -- Commented for bugfix 4672237
683: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);
684:
685: end if;
686: when mass_dpr_rsv_adj_err then
687: FND_CONCURRENT.AF_ROLLBACK;

Line 690: fa_debug_pkg.add(l_calling_fn,'mass_dpr_rsv_adj_err ','');

686: when mass_dpr_rsv_adj_err then
687: FND_CONCURRENT.AF_ROLLBACK;
688: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
689: if (g_log_level_rec.statement_level) then
690: fa_debug_pkg.add(l_calling_fn,'mass_dpr_rsv_adj_err ','');
691:
692: -- Commented for bugfix 4672237
693: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);
694:

Line 693: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);

689: if (g_log_level_rec.statement_level) then
690: fa_debug_pkg.add(l_calling_fn,'mass_dpr_rsv_adj_err ','');
691:
692: -- Commented for bugfix 4672237
693: -- FA_DEBUG_PKG.dump_debug_messages(max_mesgs => 0);
694:
695: end if;
696: G_failure_count := G_failure_count + 1;
697:

Line 705: fa_debug_pkg.add(l_calling_fn,'when others','end of main block in loop');

701: CALLING_FN => l_calling_fn,
702: p_log_level_rec => g_log_level_rec);
703: fnd_concurrent.af_rollback;
704: if (g_log_level_rec.statement_level) then
705: fa_debug_pkg.add(l_calling_fn,'when others','end of main block in loop');
706:
707: -- Commented for bugfix 4672237
708: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
709: end if;

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

704: if (g_log_level_rec.statement_level) then
705: fa_debug_pkg.add(l_calling_fn,'when others','end of main block in loop');
706:
707: -- Commented for bugfix 4672237
708: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
709: end if;
710: G_failure_count := G_failure_count + 1;
711:
712: END; /* Inside Loop */

Line 723: fa_debug_pkg.add(l_calling_fn,'when others','end of process_assets');

719: CALLING_FN => l_calling_fn,
720: p_log_level_rec => g_log_level_rec);
721: fnd_concurrent.af_rollback;
722: if (g_log_level_rec.statement_level) then
723: fa_debug_pkg.add(l_calling_fn,'when others','end of process_assets');
724:
725: -- Commented for bugfix 4672237
726: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
727:

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

722: if (g_log_level_rec.statement_level) then
723: fa_debug_pkg.add(l_calling_fn,'when others','end of process_assets');
724:
725: -- Commented for bugfix 4672237
726: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
727:
728: end if;
729:
730: END PROCESS_ASSETS;

Line 830: fa_debug_pkg.add(l_calling_fn,'Job status - Unassigned: '||l_unassigned_cnt||

826: FROM FA_WORKER_JOBS
827: WHERE request_Id = p_parent_request_id;
828:
829: if (g_log_level_rec.statement_level) then
830: fa_debug_pkg.add(l_calling_fn,'Job status - Unassigned: '||l_unassigned_cnt||
831: ' In Process: '||l_wip_cnt||
832: ' Completed: '||l_completed_cnt||
833: ' Failed: '||l_failed_cnt||
834: ' Total: ', l_total_cnt);

Line 835: fa_debug_pkg.add(l_calling_fn,'p_parent_request_id',p_parent_request_id);

831: ' In Process: '||l_wip_cnt||
832: ' Completed: '||l_completed_cnt||
833: ' Failed: '||l_failed_cnt||
834: ' Total: ', l_total_cnt);
835: fa_debug_pkg.add(l_calling_fn,'p_parent_request_id',p_parent_request_id);
836: end if;
837:
838:
839: IF (l_failed_cnt > 0) THEN

Line 841: fa_debug_pkg.add(l_calling_fn,'','');

837:
838:
839: IF (l_failed_cnt > 0) THEN
840: if (g_log_level_rec.statement_level) then
841: fa_debug_pkg.add(l_calling_fn,'','');
842: fa_debug_pkg.add(l_calling_fn,'Another worker have errored out. Stop processing.','');
843: end if;
844: raise error_found; -- ??? this is dbi behavior - we shoudl probably continue
845: ELSIF (l_unassigned_cnt = 0) THEN

Line 842: fa_debug_pkg.add(l_calling_fn,'Another worker have errored out. Stop processing.','');

838:
839: IF (l_failed_cnt > 0) THEN
840: if (g_log_level_rec.statement_level) then
841: fa_debug_pkg.add(l_calling_fn,'','');
842: fa_debug_pkg.add(l_calling_fn,'Another worker have errored out. Stop processing.','');
843: end if;
844: raise error_found; -- ??? this is dbi behavior - we shoudl probably continue
845: ELSIF (l_unassigned_cnt = 0) THEN
846: if (g_log_level_rec.statement_level) then

Line 847: fa_debug_pkg.add(l_calling_fn,'','');

843: end if;
844: raise error_found; -- ??? this is dbi behavior - we shoudl probably continue
845: ELSIF (l_unassigned_cnt = 0) THEN
846: if (g_log_level_rec.statement_level) then
847: fa_debug_pkg.add(l_calling_fn,'','');
848: fa_debug_pkg.add(l_calling_fn,'No more jobs left. Terminating.','');
849: end if;
850: raise done_exc;
851: ELSIF (l_completed_cnt = l_total_cnt) THEN

Line 848: fa_debug_pkg.add(l_calling_fn,'No more jobs left. Terminating.','');

844: raise error_found; -- ??? this is dbi behavior - we shoudl probably continue
845: ELSIF (l_unassigned_cnt = 0) THEN
846: if (g_log_level_rec.statement_level) then
847: fa_debug_pkg.add(l_calling_fn,'','');
848: fa_debug_pkg.add(l_calling_fn,'No more jobs left. Terminating.','');
849: end if;
850: raise done_exc;
851: ELSIF (l_completed_cnt = l_total_cnt) THEN
852: if (g_log_level_rec.statement_level) then

Line 853: fa_debug_pkg.add(l_calling_fn,'','');

849: end if;
850: raise done_exc;
851: ELSIF (l_completed_cnt = l_total_cnt) THEN
852: if (g_log_level_rec.statement_level) then
853: fa_debug_pkg.add(l_calling_fn,'','');
854: fa_debug_pkg.add(l_calling_fn,'All jobs completed, no more job. Terminating','');
855: end if;
856: raise done_exc;
857: ELSIF (l_unassigned_cnt > 0) THEN

Line 854: fa_debug_pkg.add(l_calling_fn,'All jobs completed, no more job. Terminating','');

850: raise done_exc;
851: ELSIF (l_completed_cnt = l_total_cnt) THEN
852: if (g_log_level_rec.statement_level) then
853: fa_debug_pkg.add(l_calling_fn,'','');
854: fa_debug_pkg.add(l_calling_fn,'All jobs completed, no more job. Terminating','');
855: end if;
856: raise done_exc;
857: ELSIF (l_unassigned_cnt > 0) THEN
858: UPDATE FA_WORKER_JOBS

Line 868: fa_debug_pkg.add(l_calling_fn,'Taking job from job queue','');

864:
865: l_count := sql%rowcount;
866:
867: if (g_log_level_rec.statement_level) then
868: fa_debug_pkg.add(l_calling_fn,'Taking job from job queue','');
869: fa_debug_pkg.add(l_calling_fn,'count: ' , l_count);
870: end if;
871:
872: FND_CONCURRENT.AF_COMMIT;

Line 869: fa_debug_pkg.add(l_calling_fn,'count: ' , l_count);

865: l_count := sql%rowcount;
866:
867: if (g_log_level_rec.statement_level) then
868: fa_debug_pkg.add(l_calling_fn,'Taking job from job queue','');
869: fa_debug_pkg.add(l_calling_fn,'count: ' , l_count);
870: end if;
871:
872: FND_CONCURRENT.AF_COMMIT;
873: END IF;

Line 888: fa_debug_pkg.add(l_calling_fn,g_phase,'');

884: BEGIN
885: g_phase := 'Getting ID range from FA_WORKER_JOBS table';
886:
887: if (g_log_level_rec.statement_level) then
888: fa_debug_pkg.add(l_calling_fn,g_phase,'');
889: end if;
890:
891: SELECT start_range,
892: end_range

Line 907: fa_debug_pkg.add(l_calling_fn,g_phase,'');

903: -- using the start_range and end_range.
904: --------------------------------------------------
905: g_phase := 'Calc. adj. deprn expense ';
906: if (g_log_level_rec.statement_level) then
907: fa_debug_pkg.add(l_calling_fn,g_phase,'');
908: end if;
909:
910: PROCESS_ASSETS(p_mass_tax_adjustment_id,
911: p_parent_request_id,

Line 924: fa_debug_pkg.add(l_calling_fn,g_phase,'');

920: -- to complete
921: -----------------------------------------------------
922: g_phase:='Updating job status in FA_WORKER_JOBS table';
923: if (g_log_level_rec.statement_level) then
924: fa_debug_pkg.add(l_calling_fn,g_phase,'');
925: end if;
926:
927: UPDATE FA_WORKER_JOBS
928: SET status = 'COMPLETED'

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

960: x_failure_count := G_failure_count;
961:
962: -- Commented for bugfix 4672237
963: -- if (g_log_level_rec.statement_level) then
964: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
965: -- end if;
966:
967: x_return_status := 0;
968:

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

972: x_failure_count := G_failure_count;
973:
974: -- Commented for bugfix 4672237
975: -- if (g_log_level_rec.statement_level) then
976: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
977: -- end if;
978:
979: x_return_status := 0;
980:

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

985: p_log_level_rec => g_log_level_rec);
986:
987: -- Commented for bugfix 4672237
988: -- if (g_log_level_rec.statement_level) then
989: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
990: -- end if;
991: x_return_status := 2;
992:
993: WHEN OTHERS THEN

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

998: p_log_level_rec => g_log_level_rec);
999:
1000: -- Commented for bugfix 4672237
1001: -- if (g_log_level_rec.statement_level) then
1002: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1003: -- end if;
1004: x_return_status := 2;
1005:
1006: END Do_Deprn_Adjustment;

Line 1040: fa_debug_pkg.add(l_calling_fn,'Calling procedure: LOAD_JOBS','');

1036: end if;
1037: end if;
1038:
1039: if (g_log_level_rec.statement_level) then
1040: fa_debug_pkg.add(l_calling_fn,'Calling procedure: LOAD_JOBS','');
1041: fa_debug_pkg.add(l_calling_fn,'','');
1042: end if;
1043:
1044: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code

Line 1041: fa_debug_pkg.add(l_calling_fn,'','');

1037: end if;
1038:
1039: if (g_log_level_rec.statement_level) then
1040: fa_debug_pkg.add(l_calling_fn,'Calling procedure: LOAD_JOBS','');
1041: fa_debug_pkg.add(l_calling_fn,'','');
1042: end if;
1043:
1044: if not (fa_cache_pkg.fazcbc(x_book => p_book_type_code
1045: ,p_log_level_rec => g_log_level_rec)) then

Line 1053: fa_debug_pkg.add(l_calling_fn,'Register jobs for workers','');

1049: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 1000);
1050:
1051: g_phase := 'Register jobs for workers';
1052: if (g_log_level_rec.statement_level) then
1053: fa_debug_pkg.add(l_calling_fn,'Register jobs for workers','');
1054: fa_debug_pkg.add(l_calling_fn,'p_parent_request_id',p_parent_request_id);
1055: end if;
1056:
1057: ------------------------------------------------------------

Line 1054: fa_debug_pkg.add(l_calling_fn,'p_parent_request_id',p_parent_request_id);

1050:
1051: g_phase := 'Register jobs for workers';
1052: if (g_log_level_rec.statement_level) then
1053: fa_debug_pkg.add(l_calling_fn,'Register jobs for workers','');
1054: fa_debug_pkg.add(l_calling_fn,'p_parent_request_id',p_parent_request_id);
1055: end if;
1056:
1057: ------------------------------------------------------------
1058: -- select min and max sequence IDs from your ID Temp table

Line 1104: fa_debug_pkg.add(l_calling_fn,'Inserted ' || SQL%ROWCOUNT || ' jobs into FA_WORKER_JOBS table','');

1100: AND BK.TRANSACTION_HEADER_ID_OUT IS NULL )
1101: GROUP BY UNIT_ID;
1102:
1103: if (g_log_level_rec.statement_level) then
1104: fa_debug_pkg.add(l_calling_fn,'Inserted ' || SQL%ROWCOUNT || ' jobs into FA_WORKER_JOBS table','');
1105: end if;
1106:
1107: fnd_concurrent.af_commit;
1108:

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

1113: fnd_concurrent.af_rollback;
1114:
1115: -- Commented for bugfix 4672237
1116: -- if (g_log_level_rec.statement_level) then
1117: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1118: -- end if;
1119: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
1120: p_log_level_rec => g_log_level_rec);
1121: x_return_status := 2;

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

1127: fnd_concurrent.af_rollback;
1128:
1129: -- Commented for bugfix 4672237
1130: -- if (g_log_level_rec.statement_level) then
1131: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1132: -- end if;
1133: x_return_status := 2;
1134:
1135: END LOAD_WORKERS;