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 393: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

423: p_string => ' This book is not an IAC book');
424: return TRUE;
425: END IF;
426:
427: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
428: p_full_path => l_path_name,
429: p_string => ' This book is an IAC book');
430:
431: IF NOT is_iac_cat_book_defined(p_book_type_code,

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

432: p_category_id) THEN
433: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
434: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_additions_pkg');
435: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','The category is not set up for book in IAC Options', TRUE);
436: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
437: p_full_path => l_path_name,
438: p_remove_from_stack => FALSE);
439: fnd_file.put_line(fnd_file.log, fnd_message.get);
440: return FALSE;

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

439: fnd_file.put_line(fnd_file.log, fnd_message.get);
440: return FALSE;
441: END IF;
442:
443: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
444: p_full_path => l_path_name,
445: p_string => ' This Category defined for book in IAC setup');
446:
447: -- 30/07/2003, check if asset is a negative asset, if it is return TRUE

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

445: p_string => ' This Category defined for book in IAC setup');
446:
447: -- 30/07/2003, check if asset is a negative asset, if it is return TRUE
448: IF (p_cost < 0) THEN
449: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
450: p_full_path => l_path_name,
451: p_string => 'Asset '||to_char(p_asset_id)||' is a negative asset. Cost '||to_char(p_cost));
452: RETURN TRUE;
453: END IF;

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

455: OPEN c_allow_indexed_reval_flag;
456: FETCH c_allow_indexed_reval_flag INTO l_allow_indexed_reval_flag;
457: CLOSE c_allow_indexed_reval_flag;
458:
459: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
460: p_full_path => l_path_name,
461: p_string => ' Allow Indexed reval flag :'||l_allow_indexed_reval_flag);
462: IF (nvl(l_allow_indexed_reval_flag,'Y') = 'N') THEN
463: return TRUE;

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

465:
466: IF NOT igi_iac_common_utils.get_dpis_period_counter(p_book_type_code,
467: p_asset_id,
468: l_dpis_period_counter) THEN
469: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
470: p_full_path => l_path_name,
471: p_string => '*** Error in Fetching DPIS period counter');
472: return FALSE;
473: END IF;

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

473: END IF;
474:
475: IF NOT igi_iac_common_utils.get_open_period_info(p_book_type_code,
476: l_open_period) THEN
477: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
478: p_full_path => l_path_name,
479: p_string => '*** Error in fetching Open period info for book');
480: return FALSE;
481: END IF;

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

495: /* Bug 2906034 vgadde 25/04/2002 End(1) */
496:
497: /* Bug 2407352 vgadde 07/06/2002 Start */
498: IF (l_dpis_period_counter = l_open_period.period_counter) THEN
499: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
500: p_full_path => l_path_name,
501: p_string => ' The asset is added in the current period');
502: return TRUE;
503: END IF;

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

519: OPEN c_period_num_for_catchup;
520: FETCH c_period_num_for_catchup INTO l_period_num_for_catchup;
521: CLOSE c_period_num_for_catchup;
522:
523: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
524: p_full_path => l_path_name,
525: p_string => ' Checking for default price index values in catchup periods');
526: IF NOT Is_Default_Index_Found(p_book_type_code,
527: p_asset_id,

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

530: l_period_num_for_catchup) THEN
531: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
532: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_additions_pkg');
533: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','The price indexes are not setup properly. Atleast one period in catchup has the index 9999.99', TRUE);
534: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
535: p_full_path => l_path_name,
536: p_remove_from_stack => FALSE);
537: fnd_file.put_line(fnd_file.log, fnd_message.get);
538: return FALSE;

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

537: fnd_file.put_line(fnd_file.log, fnd_message.get);
538: return FALSE;
539: END IF;
540:
541: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
542: p_full_path => l_path_name,
543: p_string => ' Revaluation catchup period for the book :'||to_char(l_period_num_for_catchup));
544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
545: p_full_path => l_path_name,

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

540:
541: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
542: p_full_path => l_path_name,
543: p_string => ' Revaluation catchup period for the book :'||to_char(l_period_num_for_catchup));
544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
545: p_full_path => l_path_name,
546: p_string => ' Revaluation catchup periods for the asset ');
547: FOR l_period_counter IN l_dpis_period_counter..(l_open_period.period_counter-1) LOOP
548:

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

548:
549: IF NOT igi_iac_common_utils.get_period_info_for_counter(p_book_type_code,
550: l_period_counter,
551: l_period_info) THEN
552: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
553: p_full_path => l_path_name,
554: p_string => '*** Error in fetching period information');
555: return FALSE;
556: END IF;

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

571: END LOOP;
572:
573:
574: IF (l_idx1 = 0) THEN /* No catch-up required */
575: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
576: p_full_path => l_path_name,
577: p_string => ' No revaluation catchup periods found');
578: return TRUE;
579: END IF;

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

586: p_deprn_ytd,
587: l_fa_deprn_amount_py,
588: l_fa_deprn_amount_cy,
589: l_last_asset_period) THEN
590: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
591: p_full_path => l_path_name,
592: p_string => '*** Error in get_FA_Deprn_Expense function');
593: return FALSE;
594: END IF;

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

605: l_cost := P_cost;
606: END IF;
607:
608: IF l_salvage_value <> 0 Then
609: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
610: p_full_path => l_path_name,
611: p_string => '+Salavge Value Correction deprn_amount_py before :' ||l_fa_deprn_amount_py);
612: -- deprn amount l_fa_deprn_amount_py
613: IF NOT igi_iac_salvage_pkg.correction(p_asset_id => p_asset_id,

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

615: P_value=>l_fa_deprn_amount_py,
616: P_cost=>l_cost,
617: P_salvage_value=>l_salvage_value,
618: P_calling_program=>'ADDITION') THEN
619: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
620: p_full_path => l_path_name,
621: p_string => '+Salavge Value Correction Failed : ');
622: return false;
623: END IF;

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

620: p_full_path => l_path_name,
621: p_string => '+Salavge Value Correction Failed : ');
622: return false;
623: END IF;
624: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
625: p_full_path => l_path_name,
626: p_string => '+Salavge Value Correction deprn_amount_py after :' ||l_fa_deprn_amount_py );
627: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
628: p_full_path => l_path_name,

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

623: END IF;
624: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
625: p_full_path => l_path_name,
626: p_string => '+Salavge Value Correction deprn_amount_py after :' ||l_fa_deprn_amount_py );
627: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
628: p_full_path => l_path_name,
629: p_string => '+Salavge Value Correction deprn_amount_cy before :' ||l_fa_deprn_amount_cy);
630: -- deprn l_fa_deprn_amount_cy
631: IF NOT igi_iac_salvage_pkg.correction(p_asset_id => p_asset_id,

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

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

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

639: p_full_path => l_path_name,
640: p_string => '+Salavge Value Correction Failed : ');
641: return false;
642: END IF;
643: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
644: p_full_path => l_path_name,
645: p_string => '+Salavge Value Correction deprn_amount_cy after :' ||l_fa_deprn_amount_cy);
646: END IF;
647: /*salvage value correction*/

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

646: END IF;
647: /*salvage value correction*/
648:
649:
650: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
651: p_full_path => l_path_name,
652: p_string => ' Calling Revaluation Initialization program ');
653: IF NOT igi_iac_catchup_pkg.do_reval_init_struct(l_open_period.period_counter,
654: l_reval_control,

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

666: l_fa_deprn_amount_py,
667: l_fa_deprn_amount_cy,
668: l_last_asset_period,
669: l_calling_function) THEN
670: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
671: p_full_path => l_path_name,
672: p_string => '*** Error in catchup pkg for revaluation initialization');
673: return FALSE;
674: END IF;

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

671: p_full_path => l_path_name,
672: p_string => '*** Error in catchup pkg for revaluation initialization');
673: return FALSE;
674: END IF;
675: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
676: p_full_path => l_path_name,
677: p_string => ' Back from Revaluation Initialization');
678:
679: FOR l_idx2 IN 1..l_idx1 LOOP

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

682:
683: l_reval_asset := l_reval_output_asset(l_idx2 - 1);
684:
685: /* Added + 1 for the first 2 parameters for bug 2411478 vgadde */
686: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
687: p_full_path => l_path_name,
688: p_string => ' Doing depreciation catchup for the periods between revaluation');
689: IF NOT igi_iac_catchup_pkg.do_deprn_catchup(l_reval_asset_params(l_idx2 - 1).period_counter + 1,
690: l_reval_asset_params(l_idx2).period_counter + 1,

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

697: p_deprn_reserve,
698: p_deprn_ytd,
699: l_reval_asset,
700: p_event_id )THEN
701: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
702: p_full_path => l_path_name,
703: p_string => '*** Error in depreciation catchup');
704: return FALSE;
705: END IF;

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

702: p_full_path => l_path_name,
703: p_string => '*** Error in depreciation catchup');
704: return FALSE;
705: END IF;
706: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
707: p_full_path => l_path_name,
708: p_string => ' Back from depreciation catchup');
709:
710: l_current_reval_factor := l_reval_input_asset(l_idx2).current_reval_factor;

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

716:
717: IF (l_idx2 = l_idx1) THEN
718: /* Last revaluation - Insert records into revaluation tables*/
719: IF (p_calling_function <> 'UPGRADE') THEN
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
721: p_full_path => l_path_name,
722: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
723:
724: l_rowid := NULL;

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

734: NULL,
735: NULL,
736: 'ADDITION',
737: X_event_id => p_event_id);
738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
739: p_full_path => l_path_name,
740: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
741:
742: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

738: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
739: p_full_path => l_path_name,
740: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
741:
742: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
743: p_full_path => l_path_name,
744: p_string => ' Inserting into igi_iac_reval_asset_rules');
745: l_rowid := NULL;
746: igi_iac_reval_asset_rules_pkg.insert_row

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

767:
768: IF (p_calling_function = 'UPGRADE') THEN
769: l_reval_control(l_idx2).calling_program := 'UPGRADE';
770: END IF;
771: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
772: p_full_path => l_path_name,
773: p_string => ' Period counter passed to Reval CRUD :'||to_char(l_open_period.period_counter ));
774:
775: END IF;

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

786: l_reval_params.reval_asset_exceptions := l_reval_exceptions(l_idx2);
787: l_reval_params.fa_asset_info := l_fa_asset_info(l_idx2);
788:
789: /* call revaluation processing function here */
790: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
791: p_full_path => l_path_name,
792: p_string => ' Input asset balances to revaluation program');
793: Debug_Asset(l_reval_input_asset(l_idx2));
794:

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

793: Debug_Asset(l_reval_input_asset(l_idx2));
794:
795: IF NOT igi_iac_reval_wrapper.do_reval_calc_asset(l_reval_params,
796: l_reval_asset_out) THEN
797: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
798: p_full_path => l_path_name,
799: p_string => '*** Error in Revaluation Program');
800: return FALSE;
801: END IF;

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

808:
809: /* Bug 2425856 vgadde 20/06/2002 Start(1) */
810: BEGIN
811: IF (l_idx2 = l_idx1 and p_calling_function <> 'UPGRADE') THEN /* Last Revaluation */
812: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
813: p_full_path => l_path_name,
814: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
816: p_full_path => l_path_name,

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

811: IF (l_idx2 = l_idx1 and p_calling_function <> 'UPGRADE') THEN /* Last Revaluation */
812: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
813: p_full_path => l_path_name,
814: p_string => ' Last revaluation period :'||to_char(l_last_reval_period));
815: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
816: p_full_path => l_path_name,
817: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
818: UPDATE igi_iac_revaluation_rates
819: SET period_counter = l_last_reval_period

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

821: AND asset_id = p_asset_id
822: AND book_type_code = p_book_type_code;
823:
824: IF SQL%FOUND then
825: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
826: p_full_path => l_path_name,
827: p_string => ' Records in reval rates updated for correct period');
828: ELSE
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

825: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
826: p_full_path => l_path_name,
827: p_string => ' Records in reval rates updated for correct period');
828: ELSE
829: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
830: p_full_path => l_path_name,
831: p_string => '*** No record found in reval rates table to update');
832: return FALSE;
833: END IF;

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

838: END LOOP;
839:
840: IF (l_last_reval_period < l_open_period.period_counter) THEN
841:
842: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
843: p_full_path => l_path_name,
844: p_string => ' Doing the final catchup for depreciation');
845:
846: l_reval_asset := l_reval_output_asset(l_idx1);

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

856: p_deprn_reserve,
857: p_deprn_ytd,
858: l_reval_asset,
859: p_event_id )THEN
860: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
861: p_full_path => l_path_name,
862: p_string => '*** Error in depreciation catchup for final run');
863: return FALSE;
864: END IF;

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

861: p_full_path => l_path_name,
862: p_string => '*** Error in depreciation catchup for final run');
863: return FALSE;
864: END IF;
865: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
866: p_full_path => l_path_name,
867: p_string => ' Output from final catchup');
868: Debug_Asset(l_reval_asset);
869:

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

875: OPEN C_Reval_Rates;
876: FETCH C_Reval_Rates into l_get_latest_adjustment_id;
877: CLOSE C_Reval_Rates;
878: IF NOT IGI_IAC_REVAL_CRUD.update_reval_rates (fp_adjustment_id => l_get_latest_adjustment_id) THEN
879: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
880: p_full_path => l_path_name,
881: p_string => '*** Failed to Update REVAL RATES');
882: return FALSE;
883: END IF;

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

895: WHERE book_type_code = p_book_type_code
896: AND asset_id = p_asset_id;
897: END IF;
898: -- End of code added by Venkat Gadde
899: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
900: p_full_path => l_path_name,
901: p_string => '******* End of IAC Prior addition processing for asset *****');
902: return TRUE;
903:

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

902: return TRUE;
903:
904: EXCEPTION
905: WHEN OTHERS THEN
906: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
907: return FALSE;
908: END Do_Addition;
909:
910:

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

975: l_dummy VARCHAR2(1);
976: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
977:
978: BEGIN
979: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
980: p_full_path => l_path_name,
981: p_string => '********* Start of IAC Additions Rollback **********');
982: FOR l_asset_info IN c_get_asset_add_info LOOP
983: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

979: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
980: p_full_path => l_path_name,
981: p_string => '********* Start of IAC Additions Rollback **********');
982: FOR l_asset_info IN c_get_asset_add_info LOOP
983: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
984: p_full_path => l_path_name,
985: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,

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

982: FOR l_asset_info IN c_get_asset_add_info LOOP
983: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
984: p_full_path => l_path_name,
985: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
990: p_full_path => l_path_name,

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

985: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
986: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
987: p_full_path => l_path_name,
988: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
989: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
990: p_full_path => l_path_name,
991: p_string => ' Transaction :'||l_asset_info.transaction_sub_type);
992:
993: /* Delete records from igi_iac_adjustments */

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

995: OPEN c_get_adjustments(l_asset_info.asset_id,l_asset_info.adjustment_id);
996: FETCH c_get_adjustments INTO l_dummy;
997:
998: IF c_get_adjustments%FOUND THEN
999: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1000: p_full_path => l_path_name,
1001: p_string => ' Deleting records from igi_iac_adjustments');
1002: igi_iac_adjustments_pkg.delete_row(
1003: x_adjustment_id => l_asset_info.adjustment_id);

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

1001: p_string => ' Deleting records from igi_iac_adjustments');
1002: igi_iac_adjustments_pkg.delete_row(
1003: x_adjustment_id => l_asset_info.adjustment_id);
1004: ELSIF c_get_adjustments%NOTFOUND THEN
1005: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1006: p_full_path => l_path_name,
1007: p_string => ' No records found in igi_iac_adjustments for delete');
1008: END IF;
1009:

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

1009:
1010: CLOSE c_get_adjustments;
1011:
1012: /* Delete records from igi_iac_det_balances */
1013: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1014: p_full_path => l_path_name,
1015: p_string => ' Deleting records from igi_iac_det_balances');
1016: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,
1017: l_asset_info.adjustment_id) LOOP

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

1023: x_period_counter => p_period_counter);
1024: END LOOP;
1025:
1026: /* Delete records from igi_iac_fa_deprn */
1027: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1028: p_full_path => l_path_name,
1029: p_string => ' Deleting records from igi_iac_fa_deprn');
1030: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,
1031: l_asset_info.adjustment_id) LOOP

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

1043: OPEN c_get_asset_balances(l_asset_info.asset_id,p_period_counter);
1044: FETCH c_get_asset_balances INTO l_dummy;
1045:
1046: IF c_get_asset_balances%FOUND THEN
1047: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1048: p_full_path => l_path_name,
1049: p_string => ' Deleting records from igi_iac_asset_balances for current period');
1050: igi_iac_asset_balances_pkg.delete_row(
1051: x_asset_id => l_asset_info.asset_id,

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

1051: x_asset_id => l_asset_info.asset_id,
1052: x_book_type_code => p_book_type_code,
1053: x_period_counter => p_period_counter);
1054: ELSIF c_get_asset_balances%NOTFOUND THEN
1055: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1056: p_full_path => l_path_name,
1057: p_string => ' No records found in igi_iac_asset_balances to delete');
1058: END IF;
1059:

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

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

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

1069: x_asset_id => l_asset_info.asset_id,
1070: x_book_type_code => p_book_type_code,
1071: x_period_counter => p_period_counter+1);
1072: ELSE
1073: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1074: p_full_path => l_path_name,
1075: p_string => ' No records found in igi_iac_asset_balances to delete');
1076: END IF;
1077: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously

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

1077: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
1078: END IF;
1079:
1080: /* Delete records from igi_iac_transaction_headers */
1081: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1082: p_full_path => l_path_name,
1083: p_string => ' Deleting records from igi_iac_transaction_headers');
1084: igi_iac_trans_headers_pkg.delete_row(
1085: x_adjustment_id => l_asset_info.adjustment_id);

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

1089: l_revaluation_id := NULL;
1090: OPEN c_get_revaluation_info(l_asset_info.asset_id);
1091: FETCH c_get_revaluation_info INTO l_revaluation_id;
1092: CLOSE c_get_revaluation_info;
1093: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1094: p_full_path => l_path_name,
1095: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
1096:
1097: /* Delete records from igi_iac_reval_asset_rules */

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

1096:
1097: /* Delete records from igi_iac_reval_asset_rules */
1098: IF (l_revaluation_id IS NOT NULL) THEN
1099:
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1101: p_full_path => l_path_name,
1102: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1103: igi_iac_reval_asset_rules_pkg.delete_row(
1104: x_asset_id => l_asset_info.asset_id,

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

1105: x_book_type_code => p_book_type_code,
1106: x_revaluation_id => l_revaluation_id);
1107:
1108: /* Delete records from igi_iac_revaluations */
1109: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1110: p_full_path => l_path_name,
1111: p_string => ' Deleting records from igi_iac_revaluations');
1112: igi_iac_revaluations_pkg.delete_row(
1113: x_revaluation_id => l_revaluation_id);

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

1116: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
1117: FETCH c_get_revaluation_rates INTO l_dummy;
1118:
1119: IF c_get_revaluation_rates%FOUND THEN
1120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1121: p_full_path => l_path_name,
1122: p_string => ' Deleting records from igi_iac_revaluation_rates');
1123: DELETE FROM igi_iac_revaluation_rates
1124: WHERE asset_id = l_asset_info.asset_id

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

1132:
1133: END IF;
1134:
1135: END LOOP;
1136: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1137: p_full_path => l_path_name,
1138: p_string => '********* End of IAC Additions Rollback **********');
1139: return TRUE;
1140:

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

1139: return TRUE;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1144: return FALSE;
1145:
1146: END Do_Rollback_Addition;
1147: