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

Line 19: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

15:
16: PROCEDURE Debug_Period(p_period igi_iac_types.prd_rec) IS
17: l_path_name VARCHAR2(150) := g_path||'debug_period';
18: BEGIN
19: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
20: p_full_path => l_path_name,
21: p_string => ' Period counter :'||to_char(p_period.period_counter));
22: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
23: p_full_path => l_path_name,

Line 22: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

18: BEGIN
19: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
20: p_full_path => l_path_name,
21: p_string => ' Period counter :'||to_char(p_period.period_counter));
22: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
23: p_full_path => l_path_name,
24: p_string => ' Period Num :'||to_char(p_period.period_num));
25: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
26: p_full_path => l_path_name,

Line 25: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

21: p_string => ' Period counter :'||to_char(p_period.period_counter));
22: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
23: p_full_path => l_path_name,
24: p_string => ' Period Num :'||to_char(p_period.period_num));
25: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
26: p_full_path => l_path_name,
27: p_string => ' Fiscal Year :'||to_char(p_period.fiscal_year));
28: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
29: p_full_path => l_path_name,

Line 28: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

24: p_string => ' Period Num :'||to_char(p_period.period_num));
25: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
26: p_full_path => l_path_name,
27: p_string => ' Fiscal Year :'||to_char(p_period.fiscal_year));
28: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
29: p_full_path => l_path_name,
30: p_string => ' Period Name :'||p_period.period_name);
31: END Debug_Period;
32:

Line 36: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

32:
33: PROCEDURE Debug_Asset(p_asset igi_iac_types.iac_reval_input_asset) IS
34: l_path_name VARCHAR2(150) := g_path||'debug_asset';
35: BEGIN
36: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
37: p_full_path => l_path_name,
38: p_string => '==============================================================');
39: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
40: p_full_path => l_path_name,

Line 39: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

35: BEGIN
36: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
37: p_full_path => l_path_name,
38: p_string => '==============================================================');
39: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
40: p_full_path => l_path_name,
41: p_string => ' Net book value :'||to_char(p_asset.net_book_value));
42: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
43: p_full_path => l_path_name,

Line 42: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

38: p_string => '==============================================================');
39: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
40: p_full_path => l_path_name,
41: p_string => ' Net book value :'||to_char(p_asset.net_book_value));
42: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
43: p_full_path => l_path_name,
44: p_string => ' Adjusted Cost :'||to_char(p_asset.adjusted_cost));
45: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
46: p_full_path => l_path_name,

Line 45: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

41: p_string => ' Net book value :'||to_char(p_asset.net_book_value));
42: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
43: p_full_path => l_path_name,
44: p_string => ' Adjusted Cost :'||to_char(p_asset.adjusted_cost));
45: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
46: p_full_path => l_path_name,
47: p_string => ' Operating Account :'||to_char(p_asset.operating_acct));
48: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
49: p_full_path => l_path_name,

Line 48: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

44: p_string => ' Adjusted Cost :'||to_char(p_asset.adjusted_cost));
45: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
46: p_full_path => l_path_name,
47: p_string => ' Operating Account :'||to_char(p_asset.operating_acct));
48: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
49: p_full_path => l_path_name,
50: p_string => ' Reval Reserve :'||to_char(p_asset.reval_reserve));
51: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
52: p_full_path => l_path_name,

Line 51: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

47: p_string => ' Operating Account :'||to_char(p_asset.operating_acct));
48: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
49: p_full_path => l_path_name,
50: p_string => ' Reval Reserve :'||to_char(p_asset.reval_reserve));
51: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
52: p_full_path => l_path_name,
53: p_string => ' Deprn Amount :'||to_char(p_asset.deprn_amount));
54: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
55: p_full_path => l_path_name,

Line 54: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

50: p_string => ' Reval Reserve :'||to_char(p_asset.reval_reserve));
51: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
52: p_full_path => l_path_name,
53: p_string => ' Deprn Amount :'||to_char(p_asset.deprn_amount));
54: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
55: p_full_path => l_path_name,
56: p_string => ' Deprn Reserve :'||to_char(p_asset.deprn_reserve));
57: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
58: p_full_path => l_path_name,

Line 57: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

53: p_string => ' Deprn Amount :'||to_char(p_asset.deprn_amount));
54: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
55: p_full_path => l_path_name,
56: p_string => ' Deprn Reserve :'||to_char(p_asset.deprn_reserve));
57: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
58: p_full_path => l_path_name,
59: p_string => ' Backlog Deprn Reserve :'||to_char(p_asset.backlog_deprn_reserve));
60: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
61: p_full_path => l_path_name,

Line 60: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

56: p_string => ' Deprn Reserve :'||to_char(p_asset.deprn_reserve));
57: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
58: p_full_path => l_path_name,
59: p_string => ' Backlog Deprn Reserve :'||to_char(p_asset.backlog_deprn_reserve));
60: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
61: p_full_path => l_path_name,
62: p_string => ' General Fund :'||to_char(p_asset.general_fund));
63: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
64: p_full_path => l_path_name,

Line 63: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

59: p_string => ' Backlog Deprn Reserve :'||to_char(p_asset.backlog_deprn_reserve));
60: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
61: p_full_path => l_path_name,
62: p_string => ' General Fund :'||to_char(p_asset.general_fund));
63: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
64: p_full_path => l_path_name,
65: p_string => ' Current Reval Factor :'||to_char(p_asset.current_reval_factor));
66: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
67: p_full_path => l_path_name,

Line 66: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

62: p_string => ' General Fund :'||to_char(p_asset.general_fund));
63: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
64: p_full_path => l_path_name,
65: p_string => ' Current Reval Factor :'||to_char(p_asset.current_reval_factor));
66: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
67: p_full_path => l_path_name,
68: p_string => ' Cumulative Reval Factor :'||to_char(p_asset.Cumulative_reval_factor));
69: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
70: p_full_path => l_path_name,

Line 69: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

65: p_string => ' Current Reval Factor :'||to_char(p_asset.current_reval_factor));
66: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
67: p_full_path => l_path_name,
68: p_string => ' Cumulative Reval Factor :'||to_char(p_asset.Cumulative_reval_factor));
69: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
70: p_full_path => l_path_name,
71: p_string => '==============================================================');
72: END Debug_Asset;
73:

Line 157: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

153: return TRUE;
154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
158: return FALSE;
159:
160: END Is_Default_Index_Found;
161:

Line 206: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

202: END IF;
203: return TRUE;
204: EXCEPTION
205: WHEN OTHERS THEN
206: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
207: return FALSE;
208: END Do_Prior_Addition;
209:
210: /*=========================================================================+

Line 234: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

230: ) return BOOLEAN IS
231: l_path_name VARCHAR2(150) := g_path||'Do_Addition_Wrapper';
232: BEGIN
233:
234: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
235: p_full_path => l_path_name,
236: p_string => '********************************************');
237: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
238: p_full_path => l_path_name,

Line 237: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

233:
234: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
235: p_full_path => l_path_name,
236: p_string => '********************************************');
237: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
238: p_full_path => l_path_name,
239: p_string => ' Start of Do_Addition_Wrapper ');
240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
241: p_full_path => l_path_name,

Line 240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

236: p_string => '********************************************');
237: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
238: p_full_path => l_path_name,
239: p_string => ' Start of Do_Addition_Wrapper ');
240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
241: p_full_path => l_path_name,
242: p_string => '********************************************');
243:
244: IF NOT Do_Prior_Addition(

Line 261: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

257: END IF;
258: return TRUE;
259: EXCEPTION
260: WHEN OTHERS THEN
261: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
262: return FALSE;
263: END;
264:
265: /*=========================================================================+

Line 394: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

390: END IF;
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
395: return FALSE ;
396: END is_iac_cat_book_defined;
397:
398: BEGIN

Line 399: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

395: return FALSE ;
396: END is_iac_cat_book_defined;
397:
398: BEGIN
399: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
400: p_full_path => l_path_name,
401: p_string => '********************************************');
402: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
403: p_full_path => l_path_name,

Line 402: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

398: BEGIN
399: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
400: p_full_path => l_path_name,
401: p_string => '********************************************');
402: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
403: p_full_path => l_path_name,
404: p_string => ' Start of IAC Prior Additions Processing');
405: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
406: p_full_path => l_path_name,

Line 405: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

401: p_string => '********************************************');
402: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
403: p_full_path => l_path_name,
404: p_string => ' Start of IAC Prior Additions Processing');
405: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
406: p_full_path => l_path_name,
407: p_string => '********************************************');
408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
409: p_full_path => l_path_name,

Line 408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

404: p_string => ' Start of IAC Prior Additions Processing');
405: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
406: p_full_path => l_path_name,
407: p_string => '********************************************');
408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
409: p_full_path => l_path_name,
410: p_string => ' Parameters from FA code hook');
411: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
412: p_full_path => l_path_name,

Line 411: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

407: p_string => '********************************************');
408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
409: p_full_path => l_path_name,
410: p_string => ' Parameters from FA code hook');
411: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
412: p_full_path => l_path_name,
413: p_string => ' Book type code :'||p_book_type_code);
414: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
415: p_full_path => l_path_name,

Line 414: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

410: p_string => ' Parameters from FA code hook');
411: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
412: p_full_path => l_path_name,
413: p_string => ' Book type code :'||p_book_type_code);
414: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
415: p_full_path => l_path_name,
416: p_string => ' Category Id :'||to_char(p_category_id));
417: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
418: p_full_path => l_path_name,

Line 417: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

413: p_string => ' Book type code :'||p_book_type_code);
414: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
415: p_full_path => l_path_name,
416: p_string => ' Category Id :'||to_char(p_category_id));
417: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
418: p_full_path => l_path_name,
419: p_string => ' Asset Id :'||to_char(p_asset_id));
420:
421: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN

Line 422: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

418: p_full_path => l_path_name,
419: p_string => ' Asset Id :'||to_char(p_asset_id));
420:
421: IF NOT igi_iac_common_utils.is_iac_book(p_book_type_code) THEN
422: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
423: p_full_path => l_path_name,
424: p_string => ' This book is not an IAC book');
425: return TRUE;
426: END IF;

Line 428: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

424: p_string => ' This book is not an IAC book');
425: return TRUE;
426: END IF;
427:
428: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
429: p_full_path => l_path_name,
430: p_string => ' This book is an IAC book');
431:
432: --bug 11852403 begin

Line 436: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

432: --bug 11852403 begin
433: SELECT asset_type into l_asset_type from fa_additions where
434: asset_id= p_asset_id;
435:
436: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
437: p_full_path => l_path_name,
438: p_string => to_char(p_asset_id)|| ' : Asset type :'|| l_asset_type);
439:
440: IF UPPER(l_asset_type)= 'CIP' THEN

Line 441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

437: p_full_path => l_path_name,
438: p_string => to_char(p_asset_id)|| ' : Asset type :'|| l_asset_type);
439:
440: IF UPPER(l_asset_type)= 'CIP' THEN
441: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
442: p_full_path => l_path_name,
443: p_string => to_char(p_asset_id)|| ': This is a CIP asset. Should not be processed.');
444: RETURN TRUE;
445: END IF;

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

449: p_category_id) THEN
450: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
451: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_additions_pkg');
452: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','The category is not set up for book in IAC Options', TRUE);
453: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
454: p_full_path => l_path_name,
455: p_remove_from_stack => FALSE);
456: fnd_file.put_line(fnd_file.log, fnd_message.get);
457: return FALSE;

Line 460: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

456: fnd_file.put_line(fnd_file.log, fnd_message.get);
457: return FALSE;
458: END IF;
459:
460: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
461: p_full_path => l_path_name,
462: p_string => ' This Category defined for book in IAC setup');
463:
464: -- 30/07/2003, check if asset is a negative asset, if it is return TRUE

Line 466: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

462: p_string => ' This Category defined for book in IAC setup');
463:
464: -- 30/07/2003, check if asset is a negative asset, if it is return TRUE
465: IF (p_cost < 0) THEN
466: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
467: p_full_path => l_path_name,
468: p_string => 'Asset '||to_char(p_asset_id)||' is a negative asset. Cost '||to_char(p_cost));
469: RETURN TRUE;
470: END IF;

Line 476: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

472: OPEN c_allow_indexed_reval_flag;
473: FETCH c_allow_indexed_reval_flag INTO l_allow_indexed_reval_flag;
474: CLOSE c_allow_indexed_reval_flag;
475:
476: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
477: p_full_path => l_path_name,
478: p_string => ' Allow Indexed reval flag :'||l_allow_indexed_reval_flag);
479: IF (nvl(l_allow_indexed_reval_flag,'Y') = 'N') THEN
480: return TRUE;

Line 486: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

482:
483: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,
484: p_asset_id,
485: l_dpis_period_counter) THEN
486: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
487: p_full_path => l_path_name,
488: p_string => '*** Error in Fetching DPIS period counter');
489: return FALSE;
490: END IF;

Line 494: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

490: END IF;
491:
492: IF NOT igi_iac_common_utils.get_open_period_info(p_book_type_code,
493: l_open_period) THEN
494: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
495: p_full_path => l_path_name,
496: p_string => '*** Error in fetching Open period info for book');
497: return FALSE;
498: END IF;

Line 516: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

512: /* Bug 2906034 vgadde 25/04/2002 End(1) */
513:
514: /* Bug 2407352 vgadde 07/06/2002 Start */
515: IF (l_dpis_period_counter = l_open_period.period_counter) THEN
516: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
517: p_full_path => l_path_name,
518: p_string => ' The asset is added in the current period');
519: return TRUE;
520: END IF;

Line 540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

536: OPEN c_period_num_for_catchup;
537: FETCH c_period_num_for_catchup INTO l_period_num_for_catchup;
538: CLOSE c_period_num_for_catchup;
539:
540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
541: p_full_path => l_path_name,
542: p_string => ' Checking for default price index values in catchup periods');
543: IF NOT Is_Default_Index_Found(p_book_type_code,
544: p_asset_id,

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

547: l_period_num_for_catchup) THEN
548: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
549: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_additions_pkg');
550: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','The price indexes are not setup properly. Atleast one period in catchup has the index 9999.99', TRUE);
551: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
552: p_full_path => l_path_name,
553: p_remove_from_stack => FALSE);
554: fnd_file.put_line(fnd_file.log, fnd_message.get);
555: return FALSE;

Line 558: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

554: fnd_file.put_line(fnd_file.log, fnd_message.get);
555: return FALSE;
556: END IF;
557:
558: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
559: p_full_path => l_path_name,
560: p_string => ' Revaluation catchup period for the book :'||to_char(l_period_num_for_catchup));
561: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
562: p_full_path => l_path_name,

Line 561: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

557:
558: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
559: p_full_path => l_path_name,
560: p_string => ' Revaluation catchup period for the book :'||to_char(l_period_num_for_catchup));
561: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
562: p_full_path => l_path_name,
563: p_string => ' Revaluation catchup periods for the asset ');
564: FOR l_period_counter IN l_dpis_period_counter..(l_open_period.period_counter-1) LOOP
565:

Line 569: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

565:
566: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
567: l_period_counter,
568: l_period_info) THEN
569: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
570: p_full_path => l_path_name,
571: p_string => '*** Error in fetching period information');
572: return FALSE;
573: END IF;

Line 592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

588: END LOOP;
589:
590:
591: IF (l_idx1 = 0) THEN /* No catch-up required */
592: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
593: p_full_path => l_path_name,
594: p_string => ' No revaluation catchup periods found');
595: return TRUE;
596: END IF;

Line 607: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

603: p_deprn_ytd,
604: l_fa_deprn_amount_py,
605: l_fa_deprn_amount_cy,
606: l_last_asset_period) THEN
607: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
608: p_full_path => l_path_name,
609: p_string => '*** Error in get_FA_Deprn_Expense function');
610: return FALSE;
611: END IF;

Line 626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

622: l_cost := P_cost;
623: END IF;
624:
625: IF l_salvage_value <> 0 Then
626: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
627: p_full_path => l_path_name,
628: p_string => '+Salavge Value Correction deprn_amount_py before :' ||l_fa_deprn_amount_py);
629: -- deprn amount l_fa_deprn_amount_py
630: IF NOT igi_iac_salvage_pkg.correction(p_asset_id => p_asset_id,

Line 636: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

632: P_value=>l_fa_deprn_amount_py,
633: P_cost=>l_cost,
634: P_salvage_value=>l_salvage_value,
635: P_calling_program=>'ADDITION') THEN
636: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
637: p_full_path => l_path_name,
638: p_string => '+Salavge Value Correction Failed : ');
639: return false;
640: END IF;

Line 641: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

637: p_full_path => l_path_name,
638: p_string => '+Salavge Value Correction Failed : ');
639: return false;
640: END IF;
641: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
642: p_full_path => l_path_name,
643: p_string => '+Salavge Value Correction deprn_amount_py after :' ||l_fa_deprn_amount_py );
644: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
645: p_full_path => l_path_name,

Line 644: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

640: END IF;
641: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
642: p_full_path => l_path_name,
643: p_string => '+Salavge Value Correction deprn_amount_py after :' ||l_fa_deprn_amount_py );
644: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
645: p_full_path => l_path_name,
646: p_string => '+Salavge Value Correction deprn_amount_cy before :' ||l_fa_deprn_amount_cy);
647: -- deprn l_fa_deprn_amount_cy
648: IF NOT igi_iac_salvage_pkg.correction(p_asset_id => p_asset_id,

Line 655: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

651: P_cost=>l_cost,
652: P_salvage_value=>l_salvage_value,
653: P_calling_program=>'ADDITION') THEN
654:
655: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
656: p_full_path => l_path_name,
657: p_string => '+Salavge Value Correction Failed : ');
658: return false;
659: END IF;

Line 660: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

656: p_full_path => l_path_name,
657: p_string => '+Salavge Value Correction Failed : ');
658: return false;
659: END IF;
660: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
661: p_full_path => l_path_name,
662: p_string => '+Salavge Value Correction deprn_amount_cy after :' ||l_fa_deprn_amount_cy);
663: END IF;
664: /*salvage value correction*/

Line 667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

663: END IF;
664: /*salvage value correction*/
665:
666:
667: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
668: p_full_path => l_path_name,
669: p_string => ' Calling Revaluation Initialization program ');
670: IF NOT igi_iac_catchup_pkg.do_reval_init_struct(l_open_period.period_counter,
671: l_reval_control,

Line 687: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

683: l_fa_deprn_amount_py,
684: l_fa_deprn_amount_cy,
685: l_last_asset_period,
686: l_calling_function) THEN
687: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
688: p_full_path => l_path_name,
689: p_string => '*** Error in catchup pkg for revaluation initialization');
690: return FALSE;
691: END IF;

Line 692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

688: p_full_path => l_path_name,
689: p_string => '*** Error in catchup pkg for revaluation initialization');
690: return FALSE;
691: END IF;
692: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
693: p_full_path => l_path_name,
694: p_string => ' Back from Revaluation Initialization');
695:
696: FOR l_idx2 IN 1..l_idx1 LOOP

Line 703: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

699:
700: l_reval_asset := l_reval_output_asset(l_idx2 - 1);
701:
702: /* Added + 1 for the first 2 parameters for bug 2411478 vgadde */
703: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
704: p_full_path => l_path_name,
705: p_string => ' Doing depreciation catchup for the periods between revaluation');
706: IF NOT igi_iac_catchup_pkg.do_deprn_catchup(l_reval_asset_params(l_idx2 - 1).period_counter + 1,
707: l_reval_asset_params(l_idx2).period_counter + 1,

Line 718: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

714: p_deprn_reserve,
715: p_deprn_ytd,
716: l_reval_asset,
717: p_event_id )THEN
718: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
719: p_full_path => l_path_name,
720: p_string => '*** Error in depreciation catchup');
721: return FALSE;
722: END IF;

Line 723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

719: p_full_path => l_path_name,
720: p_string => '*** Error in depreciation catchup');
721: return FALSE;
722: END IF;
723: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
724: p_full_path => l_path_name,
725: p_string => ' Back from depreciation catchup');
726:
727: l_current_reval_factor := l_reval_input_asset(l_idx2).current_reval_factor;

Line 737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

733:
734: IF (l_idx2 = l_idx1) THEN
735: /* Last revaluation - Insert records into revaluation tables*/
736: IF (p_calling_function <> 'UPGRADE') THEN
737: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
738: p_full_path => l_path_name,
739: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
740:
741: l_rowid := NULL;

Line 755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

751: NULL,
752: NULL,
753: 'ADDITION',
754: X_event_id => p_event_id);
755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
756: p_full_path => l_path_name,
757: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
758:
759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

755: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
756: p_full_path => l_path_name,
757: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
758:
759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
760: p_full_path => l_path_name,
761: p_string => ' Inserting into igi_iac_reval_asset_rules');
762: l_rowid := NULL;
763: igi_iac_reval_asset_rules_pkg.insert_row

Line 788: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

784:
785: IF (p_calling_function = 'UPGRADE') THEN
786: l_reval_control(l_idx2).calling_program := 'UPGRADE';
787: END IF;
788: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
789: p_full_path => l_path_name,
790: p_string => ' Period counter passed to Reval CRUD :'||to_char(l_open_period.period_counter ));
791:
792: END IF;

Line 807: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

803: l_reval_params.reval_asset_exceptions := l_reval_exceptions(l_idx2);
804: l_reval_params.fa_asset_info := l_fa_asset_info(l_idx2);
805:
806: /* call revaluation processing function here */
807: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
808: p_full_path => l_path_name,
809: p_string => ' Input asset balances to revaluation program');
810: Debug_Asset(l_reval_input_asset(l_idx2));
811:

Line 814: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

810: Debug_Asset(l_reval_input_asset(l_idx2));
811:
812: IF NOT igi_iac_reval_wrapper.do_reval_calc_asset(l_reval_params,
813: l_reval_asset_out) THEN
814: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
815: p_full_path => l_path_name,
816: p_string => '*** Error in Revaluation Program');
817: return FALSE;
818: END IF;

Line 829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

825:
826: /* Bug 2425856 vgadde 20/06/2002 Start(1) */
827: BEGIN
828: IF (l_idx2 = l_idx1 and p_calling_function <> 'UPGRADE') THEN /* Last Revaluation */
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,
831: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
833: p_full_path => l_path_name,

Line 832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

828: IF (l_idx2 = l_idx1 and p_calling_function <> 'UPGRADE') THEN /* Last Revaluation */
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,
831: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
832: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
833: p_full_path => l_path_name,
834: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
835: UPDATE igi_iac_revaluation_rates
836: SET period_counter = l_last_reval_period

Line 842: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

838: AND asset_id = p_asset_id
839: AND book_type_code = p_book_type_code;
840:
841: IF SQL%FOUND then
842: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
843: p_full_path => l_path_name,
844: p_string => ' Records in reval rates updated for correct period');
845: ELSE
846: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 846: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

842: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
843: p_full_path => l_path_name,
844: p_string => ' Records in reval rates updated for correct period');
845: ELSE
846: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
847: p_full_path => l_path_name,
848: p_string => '*** No record found in reval rates table to update');
849: return FALSE;
850: END IF;

Line 859: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

855: END LOOP;
856:
857: IF (l_last_reval_period < l_open_period.period_counter) THEN
858:
859: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
860: p_full_path => l_path_name,
861: p_string => ' Doing the final catchup for depreciation');
862:
863: l_reval_asset := l_reval_output_asset(l_idx1);

Line 877: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

873: p_deprn_reserve,
874: p_deprn_ytd,
875: l_reval_asset,
876: p_event_id )THEN
877: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
878: p_full_path => l_path_name,
879: p_string => '*** Error in depreciation catchup for final run');
880: return FALSE;
881: END IF;

Line 882: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

878: p_full_path => l_path_name,
879: p_string => '*** Error in depreciation catchup for final run');
880: return FALSE;
881: END IF;
882: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
883: p_full_path => l_path_name,
884: p_string => ' Output from final catchup');
885: Debug_Asset(l_reval_asset);
886:

Line 896: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

892: OPEN C_Reval_Rates;
893: FETCH C_Reval_Rates into l_get_latest_adjustment_id;
894: CLOSE C_Reval_Rates;
895: IF NOT IGI_IAC_REVAL_CRUD.update_reval_rates (fp_adjustment_id => l_get_latest_adjustment_id) THEN
896: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
897: p_full_path => l_path_name,
898: p_string => '*** Failed to Update REVAL RATES');
899: return FALSE;
900: END IF;

Line 916: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

912: WHERE book_type_code = p_book_type_code
913: AND asset_id = p_asset_id;
914: END IF;
915: -- End of code added by Venkat Gadde
916: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
917: p_full_path => l_path_name,
918: p_string => '******* End of IAC Prior addition processing for asset *****');
919: return TRUE;
920:

Line 923: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

919: return TRUE;
920:
921: EXCEPTION
922: WHEN OTHERS THEN
923: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
924: return FALSE;
925: END Do_Addition;
926:
927:

Line 996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

992: l_dummy VARCHAR2(1);
993: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
994:
995: BEGIN
996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
997: p_full_path => l_path_name,
998: p_string => '********* Start of IAC Additions Rollback **********');
999: FOR l_asset_info IN c_get_asset_add_info LOOP
1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

996: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
997: p_full_path => l_path_name,
998: p_string => '********* Start of IAC Additions Rollback **********');
999: FOR l_asset_info IN c_get_asset_add_info LOOP
1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1001: p_full_path => l_path_name,
1002: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
1003: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1004: p_full_path => l_path_name,

Line 1003: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

999: FOR l_asset_info IN c_get_asset_add_info LOOP
1000: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1001: p_full_path => l_path_name,
1002: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
1003: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1004: p_full_path => l_path_name,
1005: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
1006: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1007: p_full_path => l_path_name,

Line 1006: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1002: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
1003: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1004: p_full_path => l_path_name,
1005: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
1006: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1007: p_full_path => l_path_name,
1008: p_string => ' Transaction :'||l_asset_info.transaction_sub_type);
1009:
1010: /* Delete records from igi_iac_adjustments */

Line 1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1012: OPEN c_get_adjustments(l_asset_info.asset_id,l_asset_info.adjustment_id);
1013: FETCH c_get_adjustments INTO l_dummy;
1014:
1015: IF c_get_adjustments%FOUND THEN
1016: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1017: p_full_path => l_path_name,
1018: p_string => ' Deleting records from igi_iac_adjustments');
1019: igi_iac_adjustments_pkg.delete_row(
1020: x_adjustment_id => l_asset_info.adjustment_id);

Line 1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1018: p_string => ' Deleting records from igi_iac_adjustments');
1019: igi_iac_adjustments_pkg.delete_row(
1020: x_adjustment_id => l_asset_info.adjustment_id);
1021: ELSIF c_get_adjustments%NOTFOUND THEN
1022: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1023: p_full_path => l_path_name,
1024: p_string => ' No records found in igi_iac_adjustments for delete');
1025: END IF;
1026:

Line 1030: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1026:
1027: CLOSE c_get_adjustments;
1028:
1029: /* Delete records from igi_iac_det_balances */
1030: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1031: p_full_path => l_path_name,
1032: p_string => ' Deleting records from igi_iac_det_balances');
1033: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,
1034: l_asset_info.adjustment_id) LOOP

Line 1044: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1040: x_period_counter => p_period_counter);
1041: END LOOP;
1042:
1043: /* Delete records from igi_iac_fa_deprn */
1044: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1045: p_full_path => l_path_name,
1046: p_string => ' Deleting records from igi_iac_fa_deprn');
1047: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,
1048: l_asset_info.adjustment_id) LOOP

Line 1064: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1060: OPEN c_get_asset_balances(l_asset_info.asset_id,p_period_counter);
1061: FETCH c_get_asset_balances INTO l_dummy;
1062:
1063: IF c_get_asset_balances%FOUND THEN
1064: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1065: p_full_path => l_path_name,
1066: p_string => ' Deleting records from igi_iac_asset_balances for current period');
1067: igi_iac_asset_balances_pkg.delete_row(
1068: x_asset_id => l_asset_info.asset_id,

Line 1072: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1068: x_asset_id => l_asset_info.asset_id,
1069: x_book_type_code => p_book_type_code,
1070: x_period_counter => p_period_counter);
1071: ELSIF c_get_asset_balances%NOTFOUND THEN
1072: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1073: p_full_path => l_path_name,
1074: p_string => ' No records found in igi_iac_asset_balances to delete');
1075: END IF;
1076:

Line 1082: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1078:
1079: OPEN c_get_asset_balances(l_asset_info.asset_id, p_period_counter+1);
1080: FETCH c_get_asset_balances INTO l_dummy;
1081: IF c_get_asset_balances%FOUND THEN
1082: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1083: p_full_path => l_path_name,
1084: p_string => ' Deleting records from igi_iac_asset_balances for next period');
1085: igi_iac_asset_balances_pkg.delete_row(
1086: x_asset_id => l_asset_info.asset_id,

Line 1090: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1086: x_asset_id => l_asset_info.asset_id,
1087: x_book_type_code => p_book_type_code,
1088: x_period_counter => p_period_counter+1);
1089: ELSE
1090: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1091: p_full_path => l_path_name,
1092: p_string => ' No records found in igi_iac_asset_balances to delete');
1093: END IF;
1094: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously

Line 1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1094: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
1095: END IF;
1096:
1097: /* Delete records from igi_iac_transaction_headers */
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,
1100: p_string => ' Deleting records from igi_iac_transaction_headers');
1101: igi_iac_trans_headers_pkg.delete_row(
1102: x_adjustment_id => l_asset_info.adjustment_id);

Line 1110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1106: l_revaluation_id := NULL;
1107: OPEN c_get_revaluation_info(l_asset_info.asset_id);
1108: FETCH c_get_revaluation_info INTO l_revaluation_id;
1109: CLOSE c_get_revaluation_info;
1110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1111: p_full_path => l_path_name,
1112: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
1113:
1114: /* Delete records from igi_iac_reval_asset_rules */

Line 1117: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1113:
1114: /* Delete records from igi_iac_reval_asset_rules */
1115: IF (l_revaluation_id IS NOT NULL) THEN
1116:
1117: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1118: p_full_path => l_path_name,
1119: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1120: igi_iac_reval_asset_rules_pkg.delete_row(
1121: x_asset_id => l_asset_info.asset_id,

Line 1126: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1122: x_book_type_code => p_book_type_code,
1123: x_revaluation_id => l_revaluation_id);
1124:
1125: /* Delete records from igi_iac_revaluations */
1126: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1127: p_full_path => l_path_name,
1128: p_string => ' Deleting records from igi_iac_revaluations');
1129: igi_iac_revaluations_pkg.delete_row(
1130: x_revaluation_id => l_revaluation_id);

Line 1137: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1133: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
1134: FETCH c_get_revaluation_rates INTO l_dummy;
1135:
1136: IF c_get_revaluation_rates%FOUND THEN
1137: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1138: p_full_path => l_path_name,
1139: p_string => ' Deleting records from igi_iac_revaluation_rates');
1140: DELETE FROM igi_iac_revaluation_rates
1141: WHERE asset_id = l_asset_info.asset_id

Line 1153: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1149:
1150: END IF;
1151:
1152: END LOOP;
1153: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1154: p_full_path => l_path_name,
1155: p_string => '********* End of IAC Additions Rollback **********');
1156: return TRUE;
1157:

Line 1160: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

1156: return TRUE;
1157:
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1161: return FALSE;
1162:
1163: END Do_Rollback_Addition;
1164: