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.IGI_IAC_REVAL_WRAPPER dependencies on IGI_IAC_DEBUG_PKG

Line 31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine prepare for calculations');

27:
28: l_reval_params_old := l_reval_params;
29: fp_reval_output_asset_old := fp_reval_output_asset;
30:
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine prepare for calculations');
32: IF NOT IGI_IAC_REVAL_ENGINE.Prepare_calculations
33: ( p_iac_reval_params => L_reval_params )
34: THEN
35: -- add to the message stack!

Line 36: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Prepare_calculations');

32: IF NOT IGI_IAC_REVAL_ENGINE.Prepare_calculations
33: ( p_iac_reval_params => L_reval_params )
34: THEN
35: -- add to the message stack!
36: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Prepare_calculations');
37: return false;
38: END IF;
39: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine first set of calculations...');
40: IF NOT IGI_IAC_REVAL_ENGINE.First_set_calculations

Line 39: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine first set of calculations...');

35: -- add to the message stack!
36: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Prepare_calculations');
37: return false;
38: END IF;
39: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine first set of calculations...');
40: IF NOT IGI_IAC_REVAL_ENGINE.First_set_calculations
41: ( p_iac_reval_params => L_reval_params )
42: THEN
43: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.First_set_calculations');

Line 43: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.First_set_calculations');

39: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation engine first set of calculations...');
40: IF NOT IGI_IAC_REVAL_ENGINE.First_set_calculations
41: ( p_iac_reval_params => L_reval_params )
42: THEN
43: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.First_set_calculations');
44: -- add to the message stack!
45: return false;
46: END IF;
47:

Line 51: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'CRUD for the first set of calculations.');

47:
48: fp_reval_output_asset := L_Reval_params.reval_output_asset;
49:
50: /* call the apis to create/update records in db (first set) */
51: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'CRUD for the first set of calculations.');
52: IF NOT IGI_IAC_REVAL_CRUD.crud_iac_tables
53: ( fp_reval_params => L_Reval_params
54: , fp_second_set => false
55: )

Line 57: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure CRUD IGI_IAC_REVAL_ENGINE.First_set_calculations');

53: ( fp_reval_params => L_Reval_params
54: , fp_second_set => false
55: )
56: THEN
57: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure CRUD IGI_IAC_REVAL_ENGINE.First_set_calculations');
58: return false;
59: END IF;
60:
61: /* call to next set of calculations */

Line 63: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'If mixed, call SWAP and process the second set of calculations');

59: END IF;
60:
61: /* call to next set of calculations */
62: IF L_reval_params.reval_control.mixed_scenario THEN
63: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'If mixed, call SWAP and process the second set of calculations');
64: DECLARE
65: L_reval_params2 IGI_IAC_TYPES.iac_reval_params := L_reval_params;
66: BEGIN
67: IF NOT IGI_IAC_REVAL_ENGINE.swap ( fp_reval_params1 => L_Reval_params

Line 70: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.swap');

66: BEGIN
67: IF NOT IGI_IAC_REVAL_ENGINE.swap ( fp_reval_params1 => L_Reval_params
68: , fp_reval_params2 => L_reval_params2 )
69: THEN
70: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.swap');
71: return false;
72: END IF;
73:
74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'performing the second set of calculations');

Line 74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'performing the second set of calculations');

70: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.swap');
71: return false;
72: END IF;
73:
74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'performing the second set of calculations');
75: IF NOT IGI_IAC_REVAL_ENGINE.Next_set_calculations
76: ( p_iac_reval_params => L_reval_params2 )
77: THEN
78: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Next_set_calculations');

Line 78: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Next_set_calculations');

74: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'performing the second set of calculations');
75: IF NOT IGI_IAC_REVAL_ENGINE.Next_set_calculations
76: ( p_iac_reval_params => L_reval_params2 )
77: THEN
78: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure IGI_IAC_REVAL_ENGINE.Next_set_calculations');
79: return false;
80: END IF;
81: fp_reval_output_asset := L_Reval_params2.reval_output_asset;
82: /* call the apis to create/update records in db (second set) */

Line 83: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'CRUD for the second set of calculations');

79: return false;
80: END IF;
81: fp_reval_output_asset := L_Reval_params2.reval_output_asset;
82: /* call the apis to create/update records in db (second set) */
83: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'CRUD for the second set of calculations');
84: IF NOT IGI_IAC_REVAL_CRUD.crud_iac_tables
85: ( fp_reval_params => L_Reval_params2
86: , fp_second_set => true
87: )

Line 89: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failure CRUD IGI_IAC_REVAL_ENGINE.Next_set_calculations');

85: ( fp_reval_params => L_Reval_params2
86: , fp_second_set => true
87: )
88: THEN
89: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failure CRUD IGI_IAC_REVAL_ENGINE.Next_set_calculations');
90: return false;
91: END IF;
92:
93: END;

Line 99: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

95: return true;
96: exception when others then
97: l_reval_params := l_reval_params_old;
98: fp_reval_output_asset:= fp_reval_output_asset_old;
99: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
100: return false;
101: end;
102:
103: procedure print_exceptions ( fp_reval_exceptions in igi_iac_types.iac_reval_exceptions

Line 119: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+unable to create any exceptions');

115: ( fp_reval_exceptions => l_exception_line
116: , fp_revaluation_id => fp_revaluation_id
117: )
118: THEN
119: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+unable to create any exceptions');
120: return;
121: END IF;
122:
123: if idx < fp_reval_exceptions.LAST then

Line 155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Initialization of the control structure');

151: L_exception_info IGI_IAC_TYPES.iac_reval_exception_line;
152: l_path varchar2(100) := g_path||'do_revaluation_asset';
153: begin
154: /* initialize the control record for the asset */
155: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Initialization of the control structure');
156: if fp_calling_program = 'IGIIARVC' then
157: IF NOT IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs
158: ( fp_asset_id => fp_asset_id
159: , fp_book_type_code => fp_book_type_code

Line 166: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');

162: , fp_period_counter => fp_period_counter
163: , fp_iac_reval_control_type => L_reval_control
164: ) then
165: -- add message to the stack
166: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');
167: return false;
168: end if;
169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');
170: elsif fp_calling_program = 'IGIIAIAR' then

Line 169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');

165: -- add message to the stack
166: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');
167: return false;
168: end if;
169: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_srs');
170: elsif fp_calling_program = 'IGIIAIAR' then
171: IF NOT IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc
172: ( fp_asset_id => fp_asset_id
173: , fp_book_type_code => fp_book_type_code

Line 179: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');

175: , fp_revaluation_mode => fp_reval_mode
176: , fp_period_counter => fp_period_counter
177: , fp_iac_reval_control_type => L_reval_control
178: ) then
179: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');
180: return false;
181: end if;
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');
183: end if;

Line 182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');

178: ) then
179: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');
180: return false;
181: end if;
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');
183: end if;
184:
185: /* initialize the structures and records */
186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Initialization of data structures.');

Line 186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Initialization of data structures.');

182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_CONTROL.init_control_for_calc');
183: end if;
184:
185: /* initialize the structures and records */
186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Initialization of data structures.');
187: if fp_calling_program = 'IGIIARVC' then
188: IF NOT IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs
189: ( fp_asset_id => fp_asset_id
190: , fp_book_type_code => fp_book_type_code

Line 197: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failed IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');

193: , fp_period_counter => fp_period_counter
194: , fp_control => L_reval_control
195: , fp_reval_params => L_reval_params
196: ) then
197: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failed IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');
198: return false;
199: end if;
200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');
201: elsif fp_calling_program = 'IGIIAIAR' then

Line 200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');

196: ) then
197: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failed IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');
198: return false;
199: end if;
200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'success IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_srs');
201: elsif fp_calling_program = 'IGIIAIAR' then
202: IF NOT IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_calc
203: ( fp_asset_id => fp_asset_id
204: , fp_book_type_code => fp_book_type_code

Line 211: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failed IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_calc');

207: , fp_period_counter => fp_period_counter
208: , fp_control => L_reval_control
209: , fp_reval_params => L_reval_params
210: ) then
211: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'failed IGI_IAC_REVAL_INIT_STRUCT.init_struct_for_calc');
212: -- add message to the stack
213: return false;
214: end if;
215: else

Line 216: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unknown calling program.Exiting.');

212: -- add message to the stack
213: return false;
214: end if;
215: else
216: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unknown calling program.Exiting.');
217: end if;
218:
219: /* validate the asset for business rules */
220: /* this should return true to proceed, false to stop */

Line 225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Validation of business rules.');

221:
222: IF L_reval_params.reval_control.validate_business_rules THEN
223:
224: fp_reval_exceptions_idx := fp_reval_exceptions_idx + 1;
225: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Validation of business rules.');
226: declare
227: l_reval_exceptions igi_iac_types.iac_reval_exceptions;
228: l_reval_idx igi_iac_types.iac_reval_exceptions_idx;
229: begin

Line 241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed IGI_IAC_REVAL_VALIDATION.validate_asset');

237: , fp_exceptions_idx => l_reval_idx
238: ) then
239: -- add exception to exception stack
240: -- validation has failed, so do not proceed with this asset.
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Failed IGI_IAC_REVAL_VALIDATION.validate_asset');
242: fp_reval_exceptions := l_reval_exceptions ;
243: IF L_reval_params.reval_control.crud_allowed THEN
244:
245: print_exceptions ( fp_reval_exceptions => fp_reval_exceptions,

Line 264: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Calculation has failed.');

260: if not do_reval_calc_asset ( L_reval_params => L_reval_params
261: , fp_reval_output_asset => fp_reval_output_asset
262: )
263: then
264: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Calculation has failed.');
265: return false;
266: end if;
267:
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Success IGI_IAC_REVAL_WRAPPER.do_revaluation_asset');

Line 268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Success IGI_IAC_REVAL_WRAPPER.do_revaluation_asset');

264: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Calculation has failed.');
265: return false;
266: end if;
267:
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Success IGI_IAC_REVAL_WRAPPER.do_revaluation_asset');
269: return true;
270: exception when others then
271: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
272: return false;

Line 271: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

267:
268: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Success IGI_IAC_REVAL_WRAPPER.do_revaluation_asset');
269: return true;
270: exception when others then
271: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
272: return false;
273: end;
274:
275: function do_calculation_asset

Line 317: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

313: rollback;
314: return true;
315: exception when others then
316: rollback;
317: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
318: return false;
319: end;
320:
321: END;