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 22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');

18: l_amount number := p_amount;
19: l_amount_old number := p_amount;
20: --l_path varchar2(150) := g_path||'do_round';
21: begin
22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

Line 26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');

22: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'--- Inside Round() ---');
23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

Line 27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

23: IF IGI_IAC_COMMON_UTILS.Iac_Round(X_Amount => l_amount, X_Book => p_book_type_code)
24: THEN
25: p_amount := l_amount;
26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

Line 30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');

26: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is TRUE');
27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;

Line 31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);

27: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
28: ELSE
29: p_amount := round( l_amount, 2);
30: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'IGI_IAC_COMMON_UTILS.Iac_Round is FALSE');
31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;
35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

Line 35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

31: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_amount = '||p_amount);
32: END IF;
33: exception when others then
34: p_amount := l_amount_old;
35: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
36: Raise;
37: END;
38:
39: /* to be deleted from spec and body */

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

147: -- enable the exception handler to log negative assets as well
148: IF (p_exception_type = 'PERIOD_INDEX') THEN
149: l_user_id := fnd_global.user_id;
150: fnd_message.set_name('IGI','IGI_IAC_INVALID_PRICE_INDEX');
151: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);
152: l_str:=fnd_message.get;
153: fnd_file.put_line(FND_FILE.LOG,l_str);
154: ELSIF (p_exception_type = 'NEGATIVE_ASSET') THEN
155: l_user_id := fnd_global.user_id;

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

153: fnd_file.put_line(FND_FILE.LOG,l_str);
154: ELSIF (p_exception_type = 'NEGATIVE_ASSET') THEN
155: l_user_id := fnd_global.user_id;
156: fnd_message.set_name('IGI','IGI_IAC_NEGATIVE_ASSETS');
157: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'insert_exceptions',FALSE);
158: l_str:=fnd_message.get;
159: fnd_file.put_line(FND_FILE.LOG,l_str);
160: END IF;
161:

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

309: BEGIN
310:
311: l_user_id := fnd_global.user_id;
312:
313: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','starting get assets');
314: -- get the period counter from the :books.revaluation_date
315: IF igi_iac_common_utils.get_period_info_for_date(p_book_type_code,
316: p_revaluation_date,
317: l_get_record_from_date) THEN

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

317: l_get_record_from_date) THEN
318:
319: l_get_counter_from_date:=l_get_record_from_date.period_counter;
320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
322: END IF;
323:
324: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
325: FOR r_get_categories IN c_get_categories

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

320:
321: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
322: END IF;
323:
324: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','got period counter');
325: FOR r_get_categories IN c_get_categories
326: LOOP
327: OPEN c_get_assets(r_get_categories.category_id,
328: l_get_counter_from_date,

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

344: r_get_categories.category_id,
345: p_book_type_code,
346: 'NEGATIVE_ASSET'
347: );
348: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
349: ELSE
350: -- if revaluation type = 'O' (Indexed) then calculate the reval_rate
351: IF r_get_categories.reval_type = 'O' THEN
352: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','reval type is O');

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

348: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
349: ELSE
350: -- if revaluation type = 'O' (Indexed) then calculate the reval_rate
351: IF r_get_categories.reval_type = 'O' THEN
352: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','reval type is O');
353: -- first get the period counter for the last revaluation on this asset
354: OPEN c_get_last_reval_period_count(l_asset_id(l_loop_count));
355: FETCH c_get_last_reval_period_count
356: INTO l_reval_period_counter;

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

359: -- then get the period_name using get_period_for_counter
360: IF IGI_IAC_COMMON_UTILS.Get_Period_Info_For_Counter(p_book_type_code,
361: l_reval_period_counter,
362: l_get_reval_period) THEN
363: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets',
364: 'asset getting price index for last reval period');
365: l_reval_period_name := l_get_reval_period.period_name;
366: -- then get the price index using get_price_index_value
367: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,

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

371: THEN null;
372: END IF;
373: END IF;
374: ELSE -- no revaluation on this asset, so get the date placed in service
375: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','no revaluation,
376: so get date placed in service');
377: CLOSE c_get_last_reval_period_count;
378: OPEN c_get_date_place_in_service(l_asset_id(l_loop_count));
379: FETCH c_get_date_place_in_service

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

385: l_date_placed_in_service,
386: l_get_reval_period) THEN
387: l_reval_period_name := l_get_reval_period.period_name;
388: -- then get the price index using get_price_index_value
389: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get index for date placed
390: in service');
391: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
392: l_asset_id(l_loop_count),
393: l_reval_period_name,

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

400: END IF; --fetch c_get_date_placed_in_service
401: END IF; -- fetch c_get_laset_reval_period_count
402: -- now get the latest closed period number
403: -- first get the open period
404: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get last closed period');
405: IF IGI_IAC_COMMON_UTILS.Get_Open_Period_Info(p_book_type_code,
406: l_get_open_period)THEN
407: null;
408: END IF;

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

411: l_get_open_period.period_counter-1,
412: l_get_closed_period) THEN
413: l_lastest_closed_per_name:=l_get_closed_period.period_name;
414: END IF;
415: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','get price index for last closed period');
416: -- then get the proce index for the latest closed period using coomon utils
417: IF IGI_IAC_COMMON_UTILS.Get_Price_Index_Value(p_book_type_code,
418: l_asset_id(l_loop_count),
419: l_lastest_closed_per_name,

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

429: l_adjusted_cost);
430: -- Now calculate the current cost
431: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
432: -- Now calculate the new cost
433: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','calculate new cost');
434: l_new_cost:=((l_cost_tbl(l_loop_count)+l_adjusted_cost)*l_reval_factor);
435: do_round(l_new_cost,p_book_type_code);
436: -- Now round hte new cost
437: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;

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

435: do_round(l_new_cost,p_book_type_code);
436: -- Now round hte new cost
437: l_cost := igi_iac_common_utils.iac_round(l_new_cost,p_book_type_code) ;
438: ELSE -- reval_type = 'P'
439: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','getting adjusted cost for P asset');
440: get_adjusted_cost(l_asset_id(l_loop_count),
441: l_get_counter_from_date,
442: p_book_type_code,
443: l_adjusted_cost);

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

442: p_book_type_code,
443: l_adjusted_cost);
444: -- Now calculate the current cost
445: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
446: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','professional allowed only');
447: l_new_cost:=(l_cost_tbl(l_loop_count)+l_adjusted_cost);
448: END IF; --is r_get_categories.reval_type = 'O'
449: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
450: IF l_last_closed_index_value = 9999.99 AND

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

445: l_current_cost:=l_cost_tbl(l_loop_count)+l_adjusted_cost;
446: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','professional allowed only');
447: l_new_cost:=(l_cost_tbl(l_loop_count)+l_adjusted_cost);
448: END IF; --is r_get_categories.reval_type = 'O'
449: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
450: IF l_last_closed_index_value = 9999.99 AND
451: r_get_categories.reval_type = 'O' THEN
452: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','l_last_closed_index_value = 9999.99');
453: insert_exceptions(p_revaluation_id,

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

448: END IF; --is r_get_categories.reval_type = 'O'
449: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','checking if l_last_closed_index_value = 9999.99');
450: IF l_last_closed_index_value = 9999.99 AND
451: r_get_categories.reval_type = 'O' THEN
452: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','l_last_closed_index_value = 9999.99');
453: insert_exceptions(p_revaluation_id,
454: l_asset_id(l_loop_count),
455: r_get_categories.category_id,
456: p_book_type_code,

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

455: r_get_categories.category_id,
456: p_book_type_code,
457: 'PERIOD_INDEX'
458: );
459: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
460: ELSE -- l_last_closed_index_value not equal to 9999.99
461: -- insert into igi_iac_reval_asset_rules
462: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
463: IF (r_get_categories.reval_type = 'P' ) OR

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

458: );
459: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','insert_exceptions called');
460: ELSE -- l_last_closed_index_value not equal to 9999.99
461: -- insert into igi_iac_reval_asset_rules
462: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','inserting into igi_iac_reval_asset_rules');
463: IF (r_get_categories.reval_type = 'P' ) OR
464: (r_get_categories.allow_prof_reval_flag = 'N' AND
465: r_get_categories.allow_indexed_reval_flag = 'Y' AND
466: l_reval_factor<>1) OR

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

494: sysdate,
495: sysdate,
496: l_user_id);
497:
498: igi_iac_debug_pkg.debug_other_string(g_state_level,g_path||'get_assets','end of insert for this asset');
499: END IF; -- insert asset
500: END IF; -- last closed index 9999.99
501: l_commit_cnt := l_commit_cnt + 1;
502: IF l_commit_cnt=1000 THEN

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

513: commit;
514: EXCEPTION WHEN OTHERS THEN
515: errbuf := SQLERRM;
516: retcode := 2;
517: igi_iac_debug_pkg.debug_unexpected_msg(g_path||'get_assets');
518: END get_assets;
519: END; -- package