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_REVAL_CRUD

Line 227: if IGI_IAC_REVAL_CRUD.update_balances

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
228: ( fp_reval_id => l_reval.revaluation_id
229: , fp_asset_id => l_asset_id(l_loop_count)
230: , fp_period_counter => fp_period_counter
231: , fp_book_type_code => l_reval.book_type_code

Line 242: IF IGI_IAC_REVAL_CRUD.adjustment_status_to_run

238: --
239: -- Adjustment_status of igi_iac_transaction_headers is updated
240: -- from 'PREVIEW' to 'RUN'.
241: --
242: IF IGI_IAC_REVAL_CRUD.adjustment_status_to_run
243: ( fp_reval_id => l_reval.revaluation_id
244: , fp_asset_id => l_asset_id(l_loop_count))
245: then
246: l_success_ct := l_success_ct + 1;

Line 251: IF IGI_IAC_REVAL_CRUD.allow_transfer_to_gl

247: else
248: l_failure_ct := l_failure_ct + 1;
249: end if;
250:
251: IF IGI_IAC_REVAL_CRUD.allow_transfer_to_gl
252: ( fp_reval_id => l_reval.revaluation_id
253: , fp_book_type_code => l_reval.book_type_code
254: , fp_asset_id => l_asset_id(l_loop_count)
255: )

Line 283: if not igi_iac_reval_crud.update_reval_rates

279:
280: if l_adjustment_id = -1 then
281: l_failure_ct := l_failure_ct + 1;
282: else
283: if not igi_iac_reval_crud.update_reval_rates
284: ( fp_adjustment_id => l_adjustment_id )
285: then
286: l_failure_ct := l_failure_ct + 1;
287: else

Line 315: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_reval.revaluation_id,l_event_id )

311: End if;
312:
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');

Line 324: IF NOT IGI_IAC_REVAL_CRUD.stamp_sla_event ( l_reval.revaluation_id,

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
328: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>>failed stamp_sla_event');

Line 335: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_reval.revaluation_id )

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
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');

Line 542: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_reval.revaluation_id )

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 )
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');

Line 573: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )

569: l_failure_ct := l_failure_ct + 1;
570: END IF;
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');

Line 584: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )

580: END IF;
581: return true;
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');

Line 856: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_number )

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;
859: END IF;
860: return;

Line 870: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_number,null )

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;
873: END IF;
874: return;

Line 896: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_previewed ( l_number )

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;
899: END IF;
900: return;

Line 913: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_run ( l_number )

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;
916: END IF;
917: return;

Line 932: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_failed_pre ( l_number )

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;
935: END IF;
936: return;

Line 945: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_number,null )

941: if revaluation_mode = 'R' then
942: rollback;
943: errbuf := 'No preview records';
944: retcode := 0;
945: IF NOT IGI_IAC_REVAL_CRUD.reval_status_to_completed ( l_number,null )
946: THEN
947: null;
948: END IF;
949: return;