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_CONCURRENT dependencies on IGI_IAC_DEBUG_PKG

Line 51: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Do not submit_revaluation_report');

47: l_path := g_path||'submit_revaluation_report';
48:
49: /* Sekhar The request i ssubmitted only for preview mode*/
50: if p_revaluation_mode not in ( 'P' ) then
51: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Do not submit_revaluation_report');
52: return;
53: end if;
54:
55: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'submit_revaluation_report');

Line 55: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'submit_revaluation_report');

51: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Do not submit_revaluation_report');
52: return;
53: end if;
54:
55: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'submit_revaluation_report');
56:
57: for l_rev in c_reval loop
58: l_reval_res := l_rev;
59: end loop;

Line 84: igi_iac_debug_pkg.debug_other_string(g_event_level,l_path,'Asset Revlaution Preview Summary report .... ');

80: , 'P_BOOK_TYPE_CODE='||l_reval_res.book_type_code
81: , 'P_REVALUATION_ID='||p_revaluation_id
82: , 'P_PERIOD_COUNTER='||l_reval_res.revaluation_period
83: );
84: igi_iac_debug_pkg.debug_other_string(g_event_level,l_path,'Asset Revlaution Preview Summary report .... ');
85: IF Not l_report_Request_id > 0 Then
86: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'Error in Asset Revlaution Preview Summary report .... ');
87: END IF;
88: /*Detail preview report */

Line 86: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'Error in Asset Revlaution Preview Summary report .... ');

82: , 'P_PERIOD_COUNTER='||l_reval_res.revaluation_period
83: );
84: igi_iac_debug_pkg.debug_other_string(g_event_level,l_path,'Asset Revlaution Preview Summary report .... ');
85: IF Not l_report_Request_id > 0 Then
86: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'Error in Asset Revlaution Preview Summary report .... ');
87: END IF;
88: /*Detail preview report */
89:
90: l_report_Request_id := FND_REQUEST.SUBMIT_REQUEST ( 'IGI'

Line 99: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Revlaution Preveiw Detail report .... ');

95: , 'P_BOOK_TYPE_CODE='||l_reval_res.book_type_code
96: , 'P_REVALUATION_ID='||p_revaluation_id
97: , 'P_PERIOD_COUNTER='||l_reval_res.revaluation_period
98: );
99: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Revlaution Preveiw Detail report .... ');
100: IF Not l_report_Request_id > 0 Then
101: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Error in Asset Revlaution Preview Detail report .... ');
102: END IF;
103:

Line 101: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Error in Asset Revlaution Preview Detail report .... ');

97: , 'P_PERIOD_COUNTER='||l_reval_res.revaluation_period
98: );
99: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Revlaution Preveiw Detail report .... ');
100: IF Not l_report_Request_id > 0 Then
101: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Error in Asset Revlaution Preview Detail report .... ');
102: END IF;
103:
104: commit;
105:

Line 108: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

104: commit;
105:
106: return;
107: exception when others then
108: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
109: rollback;
110: end;
111:
112: /*

Line 189: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_transform');

185: l_success_ct := 0;
186: l_failure_ct := 0;
187: l_path := g_path||'preview_mode_hist_transform';
188:
189: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_transform');
190: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Status '|| IGI_IAC_TYPES.gc_running_status);
191:
192: savepoint sp;
193: for l_reval in c_revaluations loop -- get the revaluation for preview

Line 190: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Status '|| IGI_IAC_TYPES.gc_running_status);

186: l_failure_ct := 0;
187: l_path := g_path||'preview_mode_hist_transform';
188:
189: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_transform');
190: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Status '|| IGI_IAC_TYPES.gc_running_status);
191:
192: savepoint sp;
193: for l_reval in c_revaluations loop -- get the revaluation for preview
194: -- found record to process.

Line 195: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation record to process');

191:
192: savepoint sp;
193: for l_reval in c_revaluations loop -- get the revaluation for preview
194: -- found record to process.
195: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation record to process');
196: for l_reval_cats in c_reval_categories -- get the category information
197: ( cp_revaluation_id => l_reval.revaluation_id
198: , cp_book_type_code => l_reval.book_type_code )
199: loop

Line 200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation category record to process '

196: for l_reval_cats in c_reval_categories -- get the category information
197: ( cp_revaluation_id => l_reval.revaluation_id
198: , cp_book_type_code => l_reval.book_type_code )
199: loop
200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation category record to process '
201: || l_reval_cats.category_id);
202:
203: /* for l_assets in c_assets -- get assets
204: ( cp_revaluation_id => l_reval.revaluation_id

Line 222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process : asset number '|| l_asset_no(l_loop_count) );

218: CLOSE c_get_assets;
219:
220: FOR l_loop_count IN 1.. l_asset_id.count
221: loop
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process : asset number '|| l_asset_no(l_loop_count) );
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> asset id '|| l_asset_id(l_loop_count));
224: --
225: -- update balance information
226: --

Line 223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> asset id '|| l_asset_id(l_loop_count));

219:
220: FOR l_loop_count IN 1.. l_asset_id.count
221: loop
222: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process : asset number '|| l_asset_no(l_loop_count) );
223: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> asset id '|| l_asset_id(l_loop_count));
224: --
225: -- update balance information
226: --
227: if IGI_IAC_REVAL_CRUD.update_balances

Line 304: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event capture routine');

300: /* Added for SLA uptake.
301: Following code will create SLA event and stamp it in revaluation and adjustment tables*/
302:
303: IF l_failure_ct = 0 then
304: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event capture routine');
305: If IGI_IAC_XLA_EVENTS_PKG.create_revaluation_event(l_reval.revaluation_id,l_event_id) then
306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event created successfully, Event_id = ' ||l_event_id);
307: else
308: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event creation failed');

Line 306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event created successfully, Event_id = ' ||l_event_id);

302:
303: IF l_failure_ct = 0 then
304: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event capture routine');
305: If IGI_IAC_XLA_EVENTS_PKG.create_revaluation_event(l_reval.revaluation_id,l_event_id) then
306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event created successfully, Event_id = ' ||l_event_id);
307: else
308: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event creation failed');
309: l_failure_ct := l_failure_ct + 1;
310: end if;

Line 308: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event creation failed');

304: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event capture routine');
305: If IGI_IAC_XLA_EVENTS_PKG.create_revaluation_event(l_reval.revaluation_id,l_event_id) then
306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event created successfully, Event_id = ' ||l_event_id);
307: else
308: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event creation failed');
309: l_failure_ct := l_failure_ct + 1;
310: end if;
311: End if;
312:

Line 317: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_completed');

313: /* Added For SLA uptake*/
314: IF l_failure_ct = 0 then
315: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_reval.revaluation_id,l_event_id )
316: THEN
317: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_completed');
318: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
319: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
320: return false;
321: ELSE

Line 318: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');

314: IF l_failure_ct = 0 then
315: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_reval.revaluation_id,l_event_id )
316: THEN
317: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_completed');
318: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
319: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
320: return false;
321: ELSE
322: --Stamp sla event to tables

Line 319: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');

315: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_reval.revaluation_id,l_event_id )
316: THEN
317: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_completed');
318: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
319: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
320: return false;
321: ELSE
322: --Stamp sla event to tables
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>start stamp_sla_event');

Line 323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>start stamp_sla_event');

319: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
320: return false;
321: ELSE
322: --Stamp sla event to tables
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>start stamp_sla_event');
324: IF NOT IGI_IAC_REVAL_CRUD.stamp_sla_event ( l_reval.revaluation_id,
325: l_reval.book_type_code,
326: l_event_id)
327: THEN

Line 328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed stamp_sla_event');

324: IF NOT IGI_IAC_REVAL_CRUD.stamp_sla_event ( l_reval.revaluation_id,
325: l_reval.book_type_code,
326: l_event_id)
327: THEN
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed stamp_sla_event');
329: return false;
330: end if;
331: --Stamp sla event to tables
332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_run');

Line 332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_run');

328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed stamp_sla_event');
329: return false;
330: end if;
331: --Stamp sla event to tables
332: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_run');
333: END IF;
334: ELSE
335: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_reval.revaluation_id )
336: THEN

Line 337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_run');

333: END IF;
334: ELSE
335: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_reval.revaluation_id )
336: THEN
337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_run');
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
340: return false;
341: ELSE

Line 338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');

334: ELSE
335: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_reval.revaluation_id )
336: THEN
337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_run');
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
340: return false;
341: ELSE
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_run');

Line 339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');

335: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_reval.revaluation_id )
336: THEN
337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_run');
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
340: return false;
341: ELSE
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_run');
343: END IF;

Line 342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_run');

338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
339: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
340: return false;
341: ELSE
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_run');
343: END IF;
344: END IF;
345:
346: /* Added for SLA uptake.

Line 349: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation is complete...');

345:
346: /* Added for SLA uptake.
347: Following code will delete SLA event in case of failure*/
348: if l_failure_ct = 0 and l_success_ct > 0 then
349: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation is complete...');
350: else
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event deletion routine');
352: If IGI_IAC_XLA_EVENTS_PKG.delete_revaluation_event(l_reval.revaluation_id) then
353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deleted successfully');

Line 351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event deletion routine');

347: Following code will delete SLA event in case of failure*/
348: if l_failure_ct = 0 and l_success_ct > 0 then
349: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation is complete...');
350: else
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event deletion routine');
352: If IGI_IAC_XLA_EVENTS_PKG.delete_revaluation_event(l_reval.revaluation_id) then
353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deleted successfully');
354: else
355: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deletion failed');

Line 353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deleted successfully');

349: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Revaluation is complete...');
350: else
351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event deletion routine');
352: If IGI_IAC_XLA_EVENTS_PKG.delete_revaluation_event(l_reval.revaluation_id) then
353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deleted successfully');
354: else
355: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deletion failed');
356: end if;
357: end if;

Line 355: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deletion failed');

351: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling event deletion routine');
352: If IGI_IAC_XLA_EVENTS_PKG.delete_revaluation_event(l_reval.revaluation_id) then
353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deleted successfully');
354: else
355: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Event deletion failed');
356: end if;
357: end if;
358: /* Added For SLA uptake*/
359:

Line 363: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>preview_mode_hist_transform');

359:
360: end loop; -- get the revaluation for preview
361:
362: if l_failure_ct = 0 and l_success_ct > 0 then
363: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>preview_mode_hist_transform');
364: else
365: rollback to sp;
366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
367: return false;

Line 366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');

362: if l_failure_ct = 0 and l_success_ct > 0 then
363: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>preview_mode_hist_transform');
364: else
365: rollback to sp;
366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
367: return false;
368: end if;
369:
370: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');

Line 370: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');

366: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_transform');
367: return false;
368: end if;
369:
370: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_transform');
371:
372: return true;
373: end;
374: /*

Line 464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_generate');

460: l_path := g_path||'preview_mode_hist_generate';
461: l_reval_messages_idx := 1;
462: l_reval_exceptions_idx := 1;
463:
464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_generate');
465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);
466:
467: savepoint sp;
468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');

Line 465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);

461: l_reval_messages_idx := 1;
462: l_reval_exceptions_idx := 1;
463:
464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_generate');
465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);
466:
467: savepoint sp;
468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');
469: for l_reval in c_revaluations loop -- get the revaluation for preview

Line 468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');

464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_generate');
465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);
466:
467: savepoint sp;
468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');
469: for l_reval in c_revaluations loop -- get the revaluation for preview
470:
471: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation record to process');
472: for l_reval_cats in c_reval_categories -- get the category information

Line 471: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation record to process');

467: savepoint sp;
468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');
469: for l_reval in c_revaluations loop -- get the revaluation for preview
470:
471: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation record to process');
472: for l_reval_cats in c_reval_categories -- get the category information
473: ( cp_revaluation_id => l_reval.revaluation_id
474: , cp_book_type_code => l_reval.book_type_code )
475: loop

Line 476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation category record to process '

472: for l_reval_cats in c_reval_categories -- get the category information
473: ( cp_revaluation_id => l_reval.revaluation_id
474: , cp_book_type_code => l_reval.book_type_code )
475: loop
476: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found revaluation category record to process '
477: || l_reval_cats.category_id);
478: /* Bulk fetch*/
479: OPEN c_get_assets ( cp_revaluation_id => l_reval.revaluation_id
480: , cp_book_type_code => l_reval.book_type_code

Line 501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process '|| l_asset_id(l_loop_count));

497: FOR l_loop_count IN 1.. l_asset_id.count
498: LOOP
499:
500:
501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process '|| l_asset_id(l_loop_count));
502: -- now call the reval wrapper!
503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

Line 503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

499:
500:
501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process '|| l_asset_id(l_loop_count));
502: -- now call the reval wrapper!
503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);

Line 504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');

500:
501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process '|| l_asset_id(l_loop_count));
502: -- now call the reval wrapper!
503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');

Line 505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

501: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>found asset record to process '|| l_asset_id(l_loop_count));
502: -- now call the reval wrapper!
503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);

Line 506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );

502: -- now call the reval wrapper!
503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');

Line 507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);

503: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

Line 508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');

504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Parameters for do_revaluation_asset ');
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare

Line 509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);

505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;

Line 510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');

506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Revaluation id : '|| l_reval.revaluation_id );
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin

Line 511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Book Type code : '|| l_reval.book_type_code);
508: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Reval mode : P ');
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

Line 515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );
518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));
519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

Line 516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));

512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );
518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));
519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
520: if not IGI_IAC_REVAL_WRAPPER.do_revaluation_asset

Line 517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );

513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );
518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));
519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
520: if not IGI_IAC_REVAL_WRAPPER.do_revaluation_asset
521: ( fp_revaluation_id => l_reval.revaluation_id

Line 518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));

514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );
518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));
519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
520: if not IGI_IAC_REVAL_WRAPPER.do_revaluation_asset
521: ( fp_revaluation_id => l_reval.revaluation_id
522: , fp_asset_id => l_asset_id(l_loop_count)

Line 519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');

515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );
518: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- reval rate : '|| l_reval_factor(l_loop_count));
519: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
520: if not IGI_IAC_REVAL_WRAPPER.do_revaluation_asset
521: ( fp_revaluation_id => l_reval.revaluation_id
522: , fp_asset_id => l_asset_id(l_loop_count)
523: , fp_book_type_code => l_reval.book_type_code

Line 534: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed do_revaluation');

530: , fp_reval_messages_idx => l_reval_messages_idx
531: , fp_reval_exceptions => l_reval_exceptions
532: , fp_reval_exceptions_idx => l_reval_exceptions_idx )
533: then
534: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed do_revaluation');
535: l_failure_ct := l_failure_ct + 1;
536: else
537: l_success_ct := l_success_ct + 1;
538: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success do_revaluation');

Line 538: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success do_revaluation');

534: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed do_revaluation');
535: l_failure_ct := l_failure_ct + 1;
536: else
537: l_success_ct := l_success_ct + 1;
538: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success do_revaluation');
539: end if;
540: -- return true;
541: exception when others then
542: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_reval.revaluation_id )

Line 544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failure reval_status_to_previewed');

540: -- return true;
541: exception when others then
542: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_reval.revaluation_id )
543: THEN
544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failure reval_status_to_previewed');
545: ELSE
546: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
547: END IF;
548: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 546: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');

542: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_reval.revaluation_id )
543: THEN
544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failure reval_status_to_previewed');
545: ELSE
546: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
547: END IF;
548: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
549: l_failure_ct := l_failure_ct + 1;
550: end;

Line 548: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

544: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failure reval_status_to_previewed');
545: ELSE
546: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
547: END IF;
548: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
549: l_failure_ct := l_failure_ct + 1;
550: end;
551:
552: end loop; -- get assets

Line 557: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> failure count '|| l_failure_ct);

553: end loop; -- get the category information
554:
555: end loop; -- get the revaluation for preview
556:
557: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> failure count '|| l_failure_ct);
558: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> success count '|| l_success_ct);
559: IF NOT igi_iac_reval_utilities.synchronize_accounts(p_book_type_code => fp_book_type_code,
560: p_period_counter => fp_period_counter,
561: p_calling_function => 'REVALUATION') THEN

Line 558: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> success count '|| l_success_ct);

554:
555: end loop; -- get the revaluation for preview
556:
557: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> failure count '|| l_failure_ct);
558: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> success count '|| l_success_ct);
559: IF NOT igi_iac_reval_utilities.synchronize_accounts(p_book_type_code => fp_book_type_code,
560: p_period_counter => fp_period_counter,
561: p_calling_function => 'REVALUATION') THEN
562: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_ACCOUNT_NOT_FOUND');

Line 564: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

560: p_period_counter => fp_period_counter,
561: p_calling_function => 'REVALUATION') THEN
562: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_ACCOUNT_NOT_FOUND');
563: FND_MESSAGE.SET_TOKEN('PROCESS','Revaluation',TRUE);
564: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
565: p_full_path => l_path,
566: p_remove_from_stack => FALSE);
567: fnd_file.put_line(fnd_file.log, fnd_message.get);
568:

Line 575: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_previewed');

571:
572: IF l_failure_ct = 0 THEN
573: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )
574: THEN
575: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_previewed');
576: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
577: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
578: ELSE
579: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');

Line 576: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');

572: IF l_failure_ct = 0 THEN
573: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )
574: THEN
575: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_previewed');
576: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
577: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
578: ELSE
579: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
580: END IF;

Line 577: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');

573: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )
574: THEN
575: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_previewed');
576: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
577: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
578: ELSE
579: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
580: END IF;
581: return true;

Line 579: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');

575: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_previewed');
576: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
577: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
578: ELSE
579: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_previewed');
580: END IF;
581: return true;
582: ELSE
583: rollback to sp;

Line 586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_failed_pre');

582: ELSE
583: rollback to sp;
584: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )
585: THEN
586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_failed_pre');
587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
589: ELSE
590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_pre');

Line 587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');

583: rollback to sp;
584: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )
585: THEN
586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_failed_pre');
587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
589: ELSE
590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_pre');
591: END IF;

Line 588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');

584: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )
585: THEN
586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_failed_pre');
587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
589: ELSE
590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_pre');
591: END IF;
592: return false;

Line 590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_pre');

586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed reval_status_to_failed_pre');
587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>not preview_mode_hist_generate');
588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'end preview_mode_hist_generate');
589: ELSE
590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>success reval_status_to_failed_pre');
591: END IF;
592: return false;
593: END IF;
594:

Line 634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Begin preview_mode_hist_delete');

630: l_path varchar2(100);
631: begin
632: l_path := g_path||'preview_mode_hist_delete';
633:
634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Begin preview_mode_hist_delete');
635: for l_rates in c_reval_rates loop
636: l_delete_flag := false;
637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+found reval records to process');
638: for l_headers in c_txn_headers ( cp_book_type_code => l_rates.book_type_code

Line 637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+found reval records to process');

633:
634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Begin preview_mode_hist_delete');
635: for l_rates in c_reval_rates loop
636: l_delete_flag := false;
637: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+found reval records to process');
638: for l_headers in c_txn_headers ( cp_book_type_code => l_rates.book_type_code
639: , cp_asset_id => l_rates.asset_id
640: , cp_period_counter => l_rates.period_counter
641: )

Line 643: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment id '||l_headers.adjustment_id);

639: , cp_asset_id => l_rates.asset_id
640: , cp_period_counter => l_rates.period_counter
641: )
642: loop
643: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment id '||l_headers.adjustment_id);
644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from exceptions table');
645: l_delete_flag := true;
646: delete from igi_iac_exceptions
647: where asset_id = l_rates.asset_id

Line 644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from exceptions table');

640: , cp_period_counter => l_rates.period_counter
641: )
642: loop
643: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+adjustment id '||l_headers.adjustment_id);
644: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from exceptions table');
645: l_delete_flag := true;
646: delete from igi_iac_exceptions
647: where asset_id = l_rates.asset_id
648: and revaluation_id = fp_revaluation_id

Line 651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the transaction headers table');

647: where asset_id = l_rates.asset_id
648: and revaluation_id = fp_revaluation_id
649: and book_type_code = l_rates.book_type_code
650: ;
651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the transaction headers table');
652: delete igi_iac_transaction_headers
653: where adjustment_id = l_headers.adjustment_id
654: and adjustment_id_out is null
655: /* and not exists ( select 'x'

Line 661: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+there have been additional transactions after this');

657: where adjustment_id_out = l_headers.adjustment_id
658: )*/
659: ;
660: if sql%notfound then
661: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+there have been additional transactions after this');
662: rollback;
663: return false;
664: end if;
665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+update previous transaction row if one exists');

Line 665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+update previous transaction row if one exists');

661: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+there have been additional transactions after this');
662: rollback;
663: return false;
664: end if;
665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+update previous transaction row if one exists');
666: declare
667: cursor c_exist is
668: select 'x'
669: from igi_iac_transaction_headers

Line 678: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+previous transaction row exists');

674: for l_exist in c_exist loop
675: l_exists_prev := true;
676: end loop;
677: if l_exists_prev then
678: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+previous transaction row exists');
679: update igi_iac_transaction_headers
680: set adjustment_id_out = null
681: where adjustment_id_out = l_headers.adjustment_id
682: and book_type_code = l_rates.book_type_code

Line 686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+error occurred in igi_iac_transaction_headers');

682: and book_type_code = l_rates.book_type_code
683: and asset_id = l_rates.asset_id
684: ;
685: if sql%notfound then
686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+error occurred in igi_iac_transaction_headers');
687: rollback;
688: return false;
689: end if;
690: end if;

Line 692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the adjustments table');

688: return false;
689: end if;
690: end if;
691: end;
692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the adjustments table');
693: delete igi_iac_adjustments
694: where adjustment_id = l_headers.adjustment_id
695: ;
696: if sql%found then

Line 697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the iac adjustments');

693: delete igi_iac_adjustments
694: where adjustment_id = l_headers.adjustment_id
695: ;
696: if sql%found then
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the iac adjustments');
698: end if;
699:
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the det balances table');
701: delete igi_iac_det_balances

Line 700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the det balances table');

696: if sql%found then
697: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the iac adjustments');
698: end if;
699:
700: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the det balances table');
701: delete igi_iac_det_balances
702: where adjustment_id = l_headers.adjustment_id
703: ;
704: if sql%found then

Line 705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the det balances info');

701: delete igi_iac_det_balances
702: where adjustment_id = l_headers.adjustment_id
703: ;
704: if sql%found then
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the det balances info');
706: end if;
707:
708: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the revaluation rates table');
709: delete from igi_iac_revaluation_rates

Line 708: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the revaluation rates table');

704: if sql%found then
705: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the det balances info');
706: end if;
707:
708: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the revaluation rates table');
709: delete from igi_iac_revaluation_rates
710: where adjustment_id = l_headers.adjustment_id
711: ;
712: if sql%found then

Line 713: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the revaluation rates info');

709: delete from igi_iac_revaluation_rates
710: where adjustment_id = l_headers.adjustment_id
711: ;
712: if sql%found then
713: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+deleted the revaluation rates info');
714: end if;
715: end loop;
716:
717:

Line 722: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_delete');

718:
719: end loop;
720:
721: if not l_delete_flag then
722: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_delete');
723: else
724: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_delete');
725: end if;
726:

Line 724: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_delete');

720:
721: if not l_delete_flag then
722: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_delete');
723: else
724: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_delete');
725: end if;
726:
727: return true;
728: exception when others then

Line 750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_available');

746: l_path varchar2(100) ;
747: begin
748: l_path := g_path||'preview_mode_hist_available';
749: for l_pmha in c_pmha loop
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_available');
751: return true;
752: end loop;
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_available');
754: return false;

Line 753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_available');

749: for l_pmha in c_pmha loop
750: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes preview_mode_hist_available');
751: return true;
752: end loop;
753: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no preview_mode_hist_available');
754: return false;
755: end;
756:
757: /*

Line 775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes run_mode_hist_available');

771: l_path varchar2(100) ;
772: begin
773: l_path := g_path||'run_mode_hist_available';
774: for l_rmha in c_rmha loop
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes run_mode_hist_available');
776: return true;
777: end loop;
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no run_mode_hist_available');
779: return false;

Line 778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no run_mode_hist_available');

774: for l_rmha in c_rmha loop
775: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'yes run_mode_hist_available');
776: return true;
777: end loop;
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'no run_mode_hist_available');
779: return false;
780: end;
781:
782: procedure revaluation

Line 799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Synchronizing Depreciation Data ');

795: l_number := revaluation_id ;
796: l_path := g_path||'revaluation';
797:
798: /* Bug 2480915 this function synchronizes igi_iac_fa_depr table data */
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Synchronizing Depreciation Data ');
800: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(book_type_code,
801: 'REVALUATION') THEN
802: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data ');
803: rollback;

Line 802: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data ');

798: /* Bug 2480915 this function synchronizes igi_iac_fa_depr table data */
799: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Synchronizing Depreciation Data ');
800: IF NOT igi_iac_common_utils.populate_iac_fa_deprn_data(book_type_code,
801: 'REVALUATION') THEN
802: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data ');
803: rollback;
804: errbuf := 'Failure in Synchronizing Depreciation Data. Submit Synchronize Depreciation Data request.';
805: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data. Submit Synchronize Depreciation Data request.');
806: retcode := 2;

Line 805: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data. Submit Synchronize Depreciation Data request.');

801: 'REVALUATION') THEN
802: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data ');
803: rollback;
804: errbuf := 'Failure in Synchronizing Depreciation Data. Submit Synchronize Depreciation Data request.';
805: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failure in Synchronizing Depreciation Data. Submit Synchronize Depreciation Data request.');
806: retcode := 2;
807: return ;
808: END IF;
809: /*

Line 831: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Create request id is '|| create_request_id);

827: l_message varchar2(240);
828:
829: begin
830:
831: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Create request id is '|| create_request_id);
832: if create_request_id is not null then
833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+begin wait for create request id '|| create_request_id);
834: if not fnd_concurrent.wait_for_request (
835: request_id => create_request_id

Line 833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+begin wait for create request id '|| create_request_id);

829: begin
830:
831: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Create request id is '|| create_request_id);
832: if create_request_id is not null then
833: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+begin wait for create request id '|| create_request_id);
834: if not fnd_concurrent.wait_for_request (
835: request_id => create_request_id
836: ,phase => l_phase
837: ,status => l_status

Line 843: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+failed wait for create request id '|| create_request_id);

839: ,dev_status => l_dev_phase
840: ,message => l_message
841: )
842: then
843: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+failed wait for create request id '|| create_request_id);
844: end if;
845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+end wait for create request id '|| create_request_id || ' status '|| l_status);
846: end if;
847: end;

Line 845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+end wait for create request id '|| create_request_id || ' status '|| l_status);

841: )
842: then
843: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+failed wait for create request id '|| create_request_id);
844: end if;
845: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+end wait for create request id '|| create_request_id || ' status '|| l_status);
846: end if;
847: end;
848: commit; -- save changes
849: if run_mode_hist_available ( fp_revaluation_id => revaluation_id ) then

Line 854: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Already in run mode.');

850: /** already in run mode **/
851: if revaluation_mode = 'P' then
852: rollback;
853: errbuf := 'Already in run mode.';
854: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Already in run mode.');
855: retcode := 2;
856: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_number )
857: THEN
858: null;

Line 868: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Normal completion');

864: submit_revaluation_report ( p_revaluation_id => revaluation_id
865: , p_revaluation_mode => revaluation_mode
866: );
867: errbuf := 'Normal completion';
868: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Normal completion');
869: retcode := 0;
870: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_number,null )
871: THEN
872: null;

Line 878: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Incorrect status passed.');

874: return;
875: end if;
876:
877: errbuf := 'Incorrect status passed.';
878: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Incorrect status passed.');
879: retcode := 1;
880: return;
881:
882: end if; /** already in run mode **/

Line 894: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');

890: fp_wait_request_id => create_request_id
891: ) then
892: rollback;
893: errbuf := 'Unable to generate history for Revaluation Preview.';
894: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');
895: retcode := 2;
896: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )
897: THEN
898: null;

Line 911: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');

907: , fp_period_counter => period_counter
908: ) then
909: rollback;
910: errbuf := 'Unable to generate history for Revaluation Preview.';
911: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');
912: retcode := 2;
913: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_number )
914: THEN
915: null;

Line 930: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');

926: , fp_wait_request_id => create_request_id
927: ) then
928: rollback;
929: errbuf := 'Unable to generate history for Revaluation Preview.';
930: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Unable to generate history for Revaluation Preview.');
931: retcode := 2;
932: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )
933: THEN
934: null;

Line 965: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

961: exception when others then
962: errbuf := SQLERRM;
963: retcode := 2;
964:
965: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
966:
967: end;
968:
969: BEGIN