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

Line 128: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);

124: -- enable the exception handler to log negative assets as well
125: IF (p_exception_type = 'PERIOD_INDEX') THEN
126: l_user_id := fnd_global.user_id;
127: fnd_message.set_name('IGI','IGI_IAC_INVALID_PRICE_INDEX');
128: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);
129: l_str:=fnd_message.get;
130: fnd_file.put_line(FND_FILE.LOG,l_str);
131: ELSIF (p_exception_type = 'NEGATIVE_ASSET') THEN
132: l_user_id := fnd_global.user_id;

Line 134: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);

130: fnd_file.put_line(FND_FILE.LOG,l_str);
131: ELSIF (p_exception_type = 'NEGATIVE_ASSET') THEN
132: l_user_id := fnd_global.user_id;
133: fnd_message.set_name('IGI','IGI_IAC_NEGATIVE_ASSETS');
134: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);
135: l_str:=fnd_message.get;
136: fnd_file.put_line(FND_FILE.LOG,l_str);
137: END IF;
138:

Line 290: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','starting get assets');

286: BEGIN
287:
288: l_user_id := fnd_global.user_id;
289:
290: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','starting get assets');
291: -- get the period counter from the :books.revaluation_date
292: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
293: p_revaluation_date,
294: l_get_record_from_date) THEN

Line 298: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');

294: l_get_record_from_date) THEN
295:
296: l_get_counter_from_date:=l_get_record_from_date.period_counter;
297:
298: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
299: END IF;
300:
301: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
302: FOR r_get_categories IN c_get_categories

Line 301: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');

297:
298: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
299: END IF;
300:
301: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
302: FOR r_get_categories IN c_get_categories
303: LOOP
304: OPEN c_get_assets(r_get_categories.category_id,
305: l_get_counter_from_date,

Line 325: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');

321: r_get_categories.category_id,
322: p_book_type_code,
323: 'NEGATIVE_ASSET'
324: );
325: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
326: ELSE
327: -- if revaluation type = 'O' (Indexed) then calculate the reval_rate
328: IF r_get_categories.reval_type = 'O' THEN
329: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','reval type is O');

Line 329: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','reval type is O');

325: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
326: ELSE
327: -- if revaluation type = 'O' (Indexed) then calculate the reval_rate
328: IF r_get_categories.reval_type = 'O' THEN
329: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','reval type is O');
330: -- first get the period counter for the last revaluation on this asset
331: OPEN c_get_last_reval_period_count(l_asset_id(l_loop_count));
332: FETCH c_get_last_reval_period_count
333: INTO l_reval_period_counter;

Line 340: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',

336: -- then get the period_name using get_period_for_counter
337: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
338: l_reval_period_counter,
339: l_get_reval_period) THEN
340: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
341: 'asset getting price index for last reval period');
342: l_reval_period_name := l_get_reval_period.period_name;
343: -- then get the price index using get_price_index_value
344: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

Line 352: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','no revaluation,

348: THEN null;
349: END IF;
350: END IF;
351: ELSE -- no revaluation on this asset, so get the date placed in service
352: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','no revaluation,
353: so get date placed in service');
354: CLOSE c_get_last_reval_period_count;
355: OPEN c_get_date_place_in_service(l_asset_id(l_loop_count));
356: FETCH c_get_date_place_in_service

Line 366: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get index for date placed

362: l_date_placed_in_service,
363: l_get_reval_period) THEN
364: l_reval_period_name := l_get_reval_period.period_name;
365: -- then get the price index using get_price_index_value
366: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get index for date placed
367: in service');
368: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
369: l_asset_id(l_loop_count),
370: l_reval_period_name,

Line 381: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get last closed period');

377: END IF; --fetch c_get_date_placed_in_service
378: END IF; -- fetch c_get_laset_reval_period_count
379: -- now get the latest closed period number
380: -- first get the open period
381: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get last closed period');
382: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,
383: l_get_open_period)THEN
384: null;
385: END IF;

Line 392: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get price index for last closed period');

388: l_get_open_period.period_counter-1,
389: l_get_closed_period) THEN
390: l_lastest_closed_per_name:=l_get_closed_period.period_name;
391: END IF;
392: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get price index for last closed period');
393: -- then get the proce index for the latest closed period using coomon utils
394: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
395: l_asset_id(l_loop_count),
396: l_lastest_closed_per_name,

Line 410: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','calculate new cost');

406: l_adjusted_cost);
407: -- Now calculate the current cost
408: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
409: -- Now calculate the new cost
410: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','calculate new cost');
411: l_new_cost:=((l_cost_tbl(l_loop_count)+l_adjusted_cost)*l_reval_factor);
412: -- Now round hte new cost
413: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;
414: ELSE -- reval_type = 'P'

Line 415: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','getting adjusted cost for P asset');

411: l_new_cost:=((l_cost_tbl(l_loop_count)+l_adjusted_cost)*l_reval_factor);
412: -- Now round hte new cost
413: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;
414: ELSE -- reval_type = 'P'
415: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','getting adjusted cost for P asset');
416: get_adjusted_cost(l_asset_id(l_loop_count),
417: l_get_counter_from_date,
418: p_book_type_code,
419: l_adjusted_cost);

Line 422: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','professional allowed only');

418: p_book_type_code,
419: l_adjusted_cost);
420: -- Now calculate the current cost
421: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
422: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','professional allowed only');
423: l_new_cost:=(l_cost_tbl(l_loop_count)+l_adjusted_cost);
424: END IF; --is r_get_categories.reval_type = 'O'
425: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
426: IF l_last_closed_index_value = 9999.99 AND

Line 425: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');

421: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
422: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','professional allowed only');
423: l_new_cost:=(l_cost_tbl(l_loop_count)+l_adjusted_cost);
424: END IF; --is r_get_categories.reval_type = 'O'
425: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
426: IF l_last_closed_index_value = 9999.99 AND
427: r_get_categories.reval_type = 'O' THEN
428: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','l_last_closed_index_value = 9999.99');
429: insert_exceptions(p_revaluation_id,

Line 428: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','l_last_closed_index_value = 9999.99');

424: END IF; --is r_get_categories.reval_type = 'O'
425: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
426: IF l_last_closed_index_value = 9999.99 AND
427: r_get_categories.reval_type = 'O' THEN
428: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','l_last_closed_index_value = 9999.99');
429: insert_exceptions(p_revaluation_id,
430: l_asset_id(l_loop_count),
431: r_get_categories.category_id,
432: p_book_type_code,

Line 435: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');

431: r_get_categories.category_id,
432: p_book_type_code,
433: 'PERIOD_INDEX'
434: );
435: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
436: ELSE -- l_last_closed_index_value not equal to 9999.99
437: -- insert into igi_iac_reval_asset_rules
438: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
439: IF (r_get_categories.reval_type = 'P' ) OR

Line 438: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');

434: );
435: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
436: ELSE -- l_last_closed_index_value not equal to 9999.99
437: -- insert into igi_iac_reval_asset_rules
438: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
439: IF (r_get_categories.reval_type = 'P' ) OR
440: (r_get_categories.allow_prof_reval_flag = 'N' AND
441: r_get_categories.allow_indexed_reval_flag = 'Y' AND
442: l_reval_factor<>1) OR

Line 474: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','end of insert for this asset');

470: sysdate,
471: sysdate,
472: l_user_id);
473:
474: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','end of insert for this asset');
475: END IF; -- insert asset
476: END IF; -- last closed index 9999.99
477: l_commit_cnt := l_commit_cnt + 1;
478: IF l_commit_cnt=1000 THEN

Line 493: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'get_assets');

489: commit;
490: EXCEPTION WHEN OTHERS THEN
491: errbuf := SQLERRM;
492: retcode := 2;
493: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'get_assets');
494: END get_assets;
495: END; -- package