APPS.IGI_IAC_XLA_EVENTS_PKG dependencies on IGI_IAC_DEBUG_PKG

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

33: invalid_ledger exception;
34: l_path_name varchar2(150) := g_path || 'create_revaluation_event';
35:
36: BEGIN
37: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
38: p_full_path => l_path_name,
39: p_string => 'create_revaluation_event....Welcome... ');
40:
41: select book_type_code,revaluation_date

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

42: into l_book_type_code,l_revaluation_date
43: from igi_iac_revaluations
44: where revaluation_id =p_revaluation_id;
45:
46: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
47: p_full_path => l_path_name,
48: p_string => 'l_book_type_code = ' || l_book_type_code);
49:
50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

46: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
47: p_full_path => l_path_name,
48: p_string => 'l_book_type_code = ' || l_book_type_code);
49:
50: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
51: p_full_path => l_path_name,
52: p_string => 'l_revaluation_date = ' || l_revaluation_date);
53:
54: -- Find the set_of_books_id and the currency code

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

57: ,l_chart_of_accounts_id
58: ,l_currency_code
59: ,l_precision)) THEN
60:
61: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
62: p_full_path => l_path_name,
63: p_string => 'GL book info found for ledger_id = '||l_ledger_id);
64: ELSE
65: raise invalid_ledger;

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

77: l_valuation_method := l_book_type_code;
78: l_event_date := l_revaluation_date; -- Bug 8297092
79: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;
80:
81: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
82: p_full_path => l_path_name,
83: p_string => 'p_revaluation_id = ' || p_revaluation_id);
84:
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

81: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
82: p_full_path => l_path_name,
83: p_string => 'p_revaluation_id = ' || p_revaluation_id);
84:
85: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
86: p_full_path => l_path_name,
87: p_string => 'Calling xla create event api.');
88:
89: -- Call XLA API

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

97: p_reference_info => NULL,
98: p_valuation_method => l_valuation_method,
99: p_security_context => l_security_context);
100:
101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
102: p_full_path => l_path_name,
103: p_string => 'p_event_id = ' || p_event_id);
104:
105: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
102: p_full_path => l_path_name,
103: p_string => 'p_event_id = ' || p_event_id);
104:
105: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
106: p_full_path => l_path_name,
107: p_string => 'End of create_revaluation_event');
108:
109: return true;

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

109: return true;
110:
111: EXCEPTION
112: WHEN invalid_ledger THEN
113: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
114: p_full_path => l_path_name,
115: p_string => 'GL book info not found for book = '|| l_book_type_code);
116: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
117: return FALSE;

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

112: WHEN invalid_ledger THEN
113: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
114: p_full_path => l_path_name,
115: p_string => 'GL book info not found for book = '|| l_book_type_code);
116: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
117: return FALSE;
118:
119: WHEN OTHERS THEN
120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

116: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
117: return FALSE;
118:
119: WHEN OTHERS THEN
120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
121: p_full_path => l_path_name,
122: p_string => 'Fatal Error = '|| sqlerrm);
123: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
124: return FALSE;

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

119: WHEN OTHERS THEN
120: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
121: p_full_path => l_path_name,
122: p_string => 'Fatal Error = '|| sqlerrm);
123: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
124: return FALSE;
125: END create_revaluation_event;
126:
127:

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

156: ,l_chart_of_accounts_id
157: ,l_currency_code
158: ,l_precision)) THEN
159:
160: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
161: p_full_path => l_path_name,
162: p_string => 'GL book info found for ledger_id = '||l_ledger_id);
163: ELSE
164: raise invalid_ledger;

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

186: return true;
187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
191: p_full_path => l_path_name,
192: p_string => 'Fatal Error = '|| sqlerrm);
193: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
194: return FALSE;

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

189: WHEN OTHERS THEN
190: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
191: p_full_path => l_path_name,
192: p_string => 'Fatal Error = '|| sqlerrm);
193: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
194: return FALSE;
195:
196: end update_revaluation_event;
197:

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

228: ,l_chart_of_accounts_id
229: ,l_currency_code
230: ,l_precision)) THEN
231:
232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,
234: p_string => 'GL book info found for ledger_id = '||l_ledger_id);
235: ELSE
236: raise invalid_ledger;

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

256: return true;
257:
258: EXCEPTION
259: WHEN OTHERS THEN
260: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
261: p_full_path => l_path_name,
262: p_string => 'Fatal Error = '|| sqlerrm);
263: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
264: return FALSE;

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

259: WHEN OTHERS THEN
260: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
261: p_full_path => l_path_name,
262: p_string => 'Fatal Error = '|| sqlerrm);
263: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
264: return FALSE;
265:
266: END delete_revaluation_event;
267: