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');
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');
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);
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;
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);
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: FUNCTION Correction
58: err_asset_info EXCEPTION;
59: l_path_name VARCHAR2(150) := g_path||'correction';
60:
61: BEGIN
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'Parameter values Asset ID..'||p_asset_id );
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
61: BEGIN
62: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
63: p_full_path => l_path_name,
64: p_string => 'Parameter values Asset ID..'||p_asset_id );
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'Parameter values Book Type Code..'||P_book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
64: p_string => 'Parameter values Asset ID..'||p_asset_id );
65: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
66: p_full_path => l_path_name,
67: p_string => 'Parameter values Book Type Code..'||P_book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'Parameter values Cost'||P_cost);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
67: p_string => 'Parameter values Book Type Code..'||P_book_type_code);
68: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
69: p_full_path => l_path_name,
70: p_string => 'Parameter values Cost'||P_cost);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'Parameter values salavge Value'||P_salvage_value);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
70: p_string => 'Parameter values Cost'||P_cost);
71: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
72: p_full_path => l_path_name,
73: p_string => 'Parameter values salavge Value'||P_salvage_value);
74: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
75: p_full_path => l_path_name,
76: p_string => 'Parameter values Value to be corrected'||P_value);
77:
78: IF P_salvage_value = 0 THEN
104: WHEN err_asset_info THEN
105: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
106: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_iac_salvage_pkg');
107: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Error in fetching latest cost and salvage value for the asset', TRUE);
108: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
109: p_full_path => l_path_name,
110: p_remove_from_stack => FALSE);
111: fnd_file.put_line(fnd_file.log, fnd_message.get);
112: RETURN FALSE;
110: p_remove_from_stack => FALSE);
111: fnd_file.put_line(fnd_file.log, fnd_message.get);
112: RETURN FALSE;
113: WHEN others THEN
114: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
115: RETURN FALSE;
116:
117: END correction;
118: