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

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

88: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
89: l_dummy VARCHAR2(1);
90: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
91: BEGIN
92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
93: p_full_path => l_path_name,
94: p_string => '********* Start of IAC Additions Rollback **********');
95: FOR l_asset_info IN c_get_asset_add_info LOOP
96: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

92: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
93: p_full_path => l_path_name,
94: p_string => '********* Start of IAC Additions Rollback **********');
95: FOR l_asset_info IN c_get_asset_add_info LOOP
96: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
97: p_full_path => l_path_name,
98: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
99: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
100: p_full_path => l_path_name,

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

95: FOR l_asset_info IN c_get_asset_add_info LOOP
96: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
97: p_full_path => l_path_name,
98: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
99: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
100: p_full_path => l_path_name,
101: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
102: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
103: p_full_path => l_path_name,

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

98: p_string => ' Processing for Asset :'||to_char(l_asset_info.asset_id));
99: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
100: p_full_path => l_path_name,
101: p_string => ' Adjustment :'||to_char(l_asset_info.adjustment_id));
102: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
103: p_full_path => l_path_name,
104: p_string => ' Transaction :'||l_asset_info.transaction_sub_type);
105: /* Delete records from igi_iac_adjustments */
106: l_dummy := NULL;

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

106: l_dummy := NULL;
107: OPEN c_get_adjustments(l_asset_info.asset_id,l_asset_info.adjustment_id);
108: FETCH c_get_adjustments INTO l_dummy;
109: IF c_get_adjustments%FOUND THEN
110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
111: p_full_path => l_path_name,
112: p_string => ' Deleting records from igi_iac_adjustments');
113: igi_iac_adjustments_pkg.delete_row(
114: x_adjustment_id => l_asset_info.adjustment_id);

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

112: p_string => ' Deleting records from igi_iac_adjustments');
113: igi_iac_adjustments_pkg.delete_row(
114: x_adjustment_id => l_asset_info.adjustment_id);
115: ELSIF c_get_adjustments%NOTFOUND THEN
116: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
117: p_full_path => l_path_name,
118: p_string => ' No records found in igi_iac_adjustments for delete');
119: END IF;
120: CLOSE c_get_adjustments;

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

118: p_string => ' No records found in igi_iac_adjustments for delete');
119: END IF;
120: CLOSE c_get_adjustments;
121: /* Delete records from igi_iac_det_balances */
122: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
123: p_full_path => l_path_name,
124: p_string => ' Deleting records from igi_iac_det_balances');
125: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,
126: l_asset_info.adjustment_id) LOOP

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

131: x_book_type_code => p_book_type_code,
132: x_period_counter => p_period_counter);
133: END LOOP;
134: /* Delete records from igi_iac_fa_deprn */
135: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
136: p_full_path => l_path_name,
137: p_string => ' Deleting records from igi_iac_fa_deprn');
138: FOR l_iac_fa_det_balance IN c_get_fa_distributions(l_asset_info.asset_id,
139: l_asset_info.adjustment_id) LOOP

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

148: IF l_asset_info.transaction_sub_type <> 'CATCHUP' THEN
149: OPEN c_get_asset_balances(l_asset_info.asset_id,p_period_counter);
150: FETCH c_get_asset_balances INTO l_dummy;
151: IF c_get_asset_balances%FOUND THEN
152: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
153: p_full_path => l_path_name,
154: p_string => ' Deleting records from igi_iac_asset_balances for current period');
155: igi_iac_asset_balances_pkg.delete_row(
156: x_asset_id => l_asset_info.asset_id,

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

156: x_asset_id => l_asset_info.asset_id,
157: x_book_type_code => p_book_type_code,
158: x_period_counter => p_period_counter);
159: ELSIF c_get_asset_balances%NOTFOUND THEN
160: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
161: p_full_path => l_path_name,
162: p_string => ' No records found in igi_iac_asset_balances to delete');
163: END IF;
164: CLOSE c_get_asset_balances;

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

164: CLOSE c_get_asset_balances;
165: OPEN c_get_asset_balances(l_asset_info.asset_id, p_period_counter+1);
166: FETCH c_get_asset_balances INTO l_dummy;
167: IF c_get_asset_balances%FOUND THEN
168: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
169: p_full_path => l_path_name,
170: p_string => ' Deleting records from igi_iac_asset_balances for next period');
171: igi_iac_asset_balances_pkg.delete_row(
172: x_asset_id => l_asset_info.asset_id,

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

172: x_asset_id => l_asset_info.asset_id,
173: x_book_type_code => p_book_type_code,
174: x_period_counter => p_period_counter+1);
175: ELSE
176: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
177: p_full_path => l_path_name,
178: p_string => ' No records found in igi_iac_asset_balances to delete');
179: END IF;
180: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously

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

179: END IF;
180: CLOSE c_get_asset_balances; -- Bug 2417394 this cursor was not gettign closed previously
181: END IF;
182: /* Delete records from igi_iac_transaction_headers */
183: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
184: p_full_path => l_path_name,
185: p_string => ' Deleting records from igi_iac_transaction_headers');
186: igi_iac_trans_headers_pkg.delete_row(
187: x_adjustment_id => l_asset_info.adjustment_id);

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

189: l_revaluation_id := NULL;
190: OPEN c_get_revaluation_info(l_asset_info.asset_id);
191: FETCH c_get_revaluation_info INTO l_revaluation_id;
192: CLOSE c_get_revaluation_info;
193: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
194: p_full_path => l_path_name,
195: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
196: /* Delete records from igi_iac_reval_asset_rules */
197: IF (l_revaluation_id IS NOT NULL) THEN

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

194: p_full_path => l_path_name,
195: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
196: /* Delete records from igi_iac_reval_asset_rules */
197: IF (l_revaluation_id IS NOT NULL) THEN
198: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
199: p_full_path => l_path_name,
200: p_string => ' Deleting records from igi_iac_reval_asset_rules');
201: igi_iac_reval_asset_rules_pkg.delete_row(
202: x_asset_id => l_asset_info.asset_id,

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

202: x_asset_id => l_asset_info.asset_id,
203: x_book_type_code => p_book_type_code,
204: x_revaluation_id => l_revaluation_id);
205: /* Delete records from igi_iac_revaluations */
206: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
207: p_full_path => l_path_name,
208: p_string => ' Deleting records from igi_iac_revaluations');
209: igi_iac_revaluations_pkg.delete_row(
210: x_revaluation_id => l_revaluation_id);

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

211: /* Delete records from igi_iac_revaluation_rates */
212: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);
213: FETCH c_get_revaluation_rates INTO l_dummy;
214: IF c_get_revaluation_rates%FOUND THEN
215: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
216: p_full_path => l_path_name,
217: p_string => ' Deleting records from igi_iac_revaluation_rates');
218: DELETE FROM igi_iac_revaluation_rates
219: WHERE asset_id = l_asset_info.asset_id

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

223: CLOSE c_get_revaluation_rates;
224: END IF;
225: END IF;
226: END LOOP;
227: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
228: p_full_path => l_path_name,
229: p_string => '********* End of IAC Additions Rollback **********');
230: return TRUE;
231: EXCEPTION

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

229: p_string => '********* End of IAC Additions Rollback **********');
230: return TRUE;
231: EXCEPTION
232: WHEN OTHERS THEN
233: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
234: return FALSE;
235: END Do_Rollback_Addition;
236:
237: FUNCTION Do_Rollback_Transfer(

Line 310: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

306: BEGIN
307:
308: l_path := g_path||'Do_Rollback_Deprn';
309:
310: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
313:
314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);

Line 311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');

307:
308: l_path := g_path||'Do_Rollback_Deprn';
309:
310: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
313:
314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
315: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);

Line 312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

308: l_path := g_path||'Do_Rollback_Deprn';
309:
310: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
313:
314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
315: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
316:

Line 314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);

310: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
313:
314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
315: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
316:
317:
318: FOR l_trans_headers in c_trans_headers

Line 315: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);

311: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback of Transactions ');
312: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
313:
314: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing For book '||p_book_type_code);
315: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Current Period Counter :'||p_period_counter);
316:
317:
318: FOR l_trans_headers in c_trans_headers
319: LOOP

Line 320: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);

316:
317:
318: FOR l_trans_headers in c_trans_headers
319: LOOP
320: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
324:

Line 321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);

317:
318: FOR l_trans_headers in c_trans_headers
319: LOOP
320: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
324:
325:

Line 322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);

318: FOR l_trans_headers in c_trans_headers
319: LOOP
320: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
324:
325:
326: /*Check If it is Prior Period Transfer*/

Line 323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);

319: LOOP
320: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction header Id :'||l_trans_headers.transaction_header_id);
321: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date Entered :'||l_trans_headers.transaction_date_entered);
322: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment Id :'||l_trans_headers.adjustment_id);
323: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset Id :'||l_trans_headers.asset_id);
324:
325:
326: /*Check If it is Prior Period Transfer*/
327: IF (IGI_IAC_COMMON_UTILS.get_period_info_for_date(p_book_type_code,

Line 334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);

330: l_prior_period_counter:=l_prd_rec_prior.period_counter;
331: END IF;
332:
333:
334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);
335:
336: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
337:
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');

Line 338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');

334: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period counter :'||l_prior_period_counter);
335:
336: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
337:
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
339:
340: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

Line 340: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

336: IF l_prior_period_counter is not null AND (L_prior_period_counter< p_period_counter) THEN
337:
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
339:
340: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
343:
344: /*DELETE from igi_iac_det_balances

Line 341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');

337:
338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
339:
340: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
343:
344: /*DELETE from igi_iac_det_balances
345: WHERE book_type_code=p_book_type_code

Line 342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

338: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Processing prior period data on this asset');
339:
340: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
341: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From detail balances...');
342: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
343:
344: /*DELETE from igi_iac_det_balances
345: WHERE book_type_code=p_book_type_code
346: AND period_counter=p_period_counter

Line 371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

367: x_period_counter =>l_fa_dist.period_counter
368: );
369: END LOOP;
370:
371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
373: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
374:
375: /* DELETE from igi_iac_adjustments

Line 372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');

368: );
369: END LOOP;
370:
371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
373: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
374:
375: /* DELETE from igi_iac_adjustments
376: WHERE book_type_code=p_book_type_code

Line 373: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

369: END LOOP;
370:
371: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
372: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
373: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
374:
375: /* DELETE from igi_iac_adjustments
376: WHERE book_type_code=p_book_type_code
377: AND period_counter=p_period_counter

Line 392: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Expense Amount to be adjusted :'||l_deprn_expense);

388: open c_deprn_expense(l_trans_headers.asset_id,l_prev_adjustment.adjustment_id);
389: fetch c_deprn_expense into l_deprn_expense;
390: close c_deprn_expense;
391:
392: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Expense Amount to be adjusted :'||l_deprn_expense);
393:
394: open c_amounts(p_period_counter,l_trans_headers.asset_id);
395: fetch c_amounts into l_amounts;
396: close c_amounts;

Line 398: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

394: open c_amounts(p_period_counter,l_trans_headers.asset_id);
395: fetch c_amounts into l_amounts;
396: close c_amounts;
397:
398: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
401:
402: IGI_IAC_ASSET_BALANCES_PKG.update_row (

Line 399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');

395: fetch c_amounts into l_amounts;
396: close c_amounts;
397:
398: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
401:
402: IGI_IAC_ASSET_BALANCES_PKG.update_row (
403: x_asset_id =>l_trans_headers.asset_id,

Line 400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

396: close c_amounts;
397:
398: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
399: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating Asset balances ...');
400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
401:
402: IGI_IAC_ASSET_BALANCES_PKG.update_row (
403: x_asset_id =>l_trans_headers.asset_id,
404: x_book_type_code =>p_book_type_code,

Line 421: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

417: x_mode =>'R'
418: );
419:
420:
421: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
422: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
423: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
424:
425: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)

Line 422: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');

418: );
419:
420:
421: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
422: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
423: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
424:
425: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)
426: LOOP

Line 423: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

419:
420:
421: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
422: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating transaction headers...');
423: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
424:
425: FOR l_prev_data in c_prev_data(l_trans_headers.adjustment_id)
426: LOOP
427: IGI_IAC_TRANS_HEADERS_PKG.update_row (

Line 435: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

431: );
432: END LOOP;
433:
434:
435: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
438:
439: IGI_IAC_TRANS_HEADERS_PKG.delete_row (

Line 436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');

432: END LOOP;
433:
434:
435: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
438:
439: IGI_IAC_TRANS_HEADERS_PKG.delete_row (
440: x_adjustment_id =>l_trans_headers.adjustment_id

Line 437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');

433:
434:
435: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
436: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From transaction headers...');
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
438:
439: IGI_IAC_TRANS_HEADERS_PKG.delete_row (
440: x_adjustment_id =>l_trans_headers.adjustment_id
441: );

Line 448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

444:
445:
446: END LOOP; -- End of First for
447:
448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
449: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
451:
452: RETURN(TRUE);

Line 449: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');

445:
446: END LOOP; -- End of First for
447:
448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
449: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
451:
452: RETURN(TRUE);
453: END Do_rollback_Transfer;

Line 450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');

446: END LOOP; -- End of First for
447:
448: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
449: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Rollback completed successfully ');
450: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'*****************************************************************');
451:
452: RETURN(TRUE);
453: END Do_rollback_Transfer;
454: