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

Line 240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset ID :' || p_asset_id);

236: l_path := g_path||'Insert_rows';
237:
238: --test records exists for the asset in the table if yes then return else
239: -- process
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset ID :' || p_asset_id);
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Book_type_code :' || p_book_type_code);
242: OPEN c_get_iac_history;
243: FETCH c_get_iac_history INTO l_get_iac_history;
244: IF c_get_iac_history%FOUND THEN

Line 241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Book_type_code :' || p_book_type_code);

237:
238: --test records exists for the asset in the table if yes then return else
239: -- process
240: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset ID :' || p_asset_id);
241: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Book_type_code :' || p_book_type_code);
242: OPEN c_get_iac_history;
243: FETCH c_get_iac_history INTO l_get_iac_history;
244: IF c_get_iac_history%FOUND THEN
245: CLOSE c_get_iac_history;

Line 246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Records already exist for the asset ');

242: OPEN c_get_iac_history;
243: FETCH c_get_iac_history INTO l_get_iac_history;
244: IF c_get_iac_history%FOUND THEN
245: CLOSE c_get_iac_history;
246: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Records already exist for the asset ');
247: RETURN TRUE;
248: END IF;
249: CLOSE c_get_iac_history;
250:

Line 253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Processing ');

249: CLOSE c_get_iac_history;
250:
251: -- process to get the reuiqred info.
252: --Use bulk fecth for getting the transactions
253: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Start Processing ');
254: OPEN C_get_iac_transactions;
255: FETCH C_get_iac_transactions BULK COLLECT INTO l_adjustment_id,l_transaction_header_id,
256: l_transaction_type_code,l_transaction_sub_type,
257: l_transaction_date_entered,

Line 271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');

267: l_lac_reval_history(l_idx1).transaction_date_entered := l_transaction_date_entered(i);
268: l_lac_reval_history(l_idx1).period_counter := l_period_counter(i);
269: l_lac_reval_history(l_idx1).adjustment_status := l_adjustment_status(i);
270:
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');
272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);

Line 272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);

268: l_lac_reval_history(l_idx1).period_counter := l_period_counter(i);
269: l_lac_reval_history(l_idx1).adjustment_status := l_adjustment_status(i);
270:
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');
272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);

Line 273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);

269: l_lac_reval_history(l_idx1).adjustment_status := l_adjustment_status(i);
270:
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');
272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);

Line 274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);

270:
271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');
272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);
278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');

Line 275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);

271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction details : ');
272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);
278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');
279:

Line 276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);

272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Adjustment ID : '||l_lac_reval_history(l_idx1).adjustment_id);
273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);
278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');
279:
280: l_idx1 := l_idx1 + 1;

Line 277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);

273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Header : '||l_lac_reval_history(l_idx1).transaction_header_id);
274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);
278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');
279:
280: l_idx1 := l_idx1 + 1;
281: END LOOP;

Line 278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');

274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Type : '||l_lac_reval_history(l_idx1).transaction_type_code);
275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Sub Type: '||l_lac_reval_history(l_idx1).transaction_sub_type);
276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Transaction Date : '||l_lac_reval_history(l_idx1).transaction_date_entered);
277: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Period Counter : '||l_lac_reval_history(l_idx1).period_counter);
278: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End');
279:
280: l_idx1 := l_idx1 + 1;
281: END LOOP;
282:

Line 296: /* igi_iac_debug_pkg.debug_other_string(g_state_level,

292: -- AND l_lac_reval_history(l_idx2 + 1).transaction_sub_type = 'CATCHUP') THEN
293: -- l_get_current_adj_id := l_lac_reval_history(l_idx2+1).adjustment_id;
294: --l_lac_reval_history(l_idx2) := l_lac_reval_history(l_idx2+1);
295: -- l_idx2 := l_idx2 + 1;
296: /* igi_iac_debug_pkg.debug_other_string(g_state_level,
297: l_path,
298: 'Skipping ADDITION ' ||l_lac_reval_history(l_idx2).transaction_sub_type);
299: l_get_current_adj_id := NULL;
300: ELSE */

Line 317: /* igi_iac_debug_pkg.debug_other_string(g_state_level,

313: -- bug 3587648, start 3
314: -- commented out as the logic broke under certain circumstances
315: -- IF (l_lac_reval_history(l_idx2).transaction_sub_type = 'REVALUATION')
316: -- AND (l_lac_reval_history(l_idx2 + 1).transaction_sub_type = 'CATCHUP') THEN
317: /* igi_iac_debug_pkg.debug_other_string(g_state_level,
318: l_path,
319: 'Skipping RECLASS ' ||l_lac_reval_history(l_idx2).transaction_sub_type);
320: l_get_current_adj_id := NULL;
321: ELSE*/

Line 406: igi_iac_debug_pkg.debug_other_string(g_state_level,

402: OPEN c_get_iac_Prev_reclass(l_lac_reval_history(l_idx2).adjustment_id,
403: l_lac_reval_history(l_idx2).transaction_type_code);
404: FETCH c_get_iac_prev_reclass INTO l_get_iac_prev_transactions;
405: IF c_get_iac_prev_reclass%FOUND THEN
406: igi_iac_debug_pkg.debug_other_string(g_state_level,
407: l_path,
408: 'reclass previous transaction '|| l_get_iac_prev_transactions.adjustment_id);
409: l_lac_reval_history(l_idx2).adjustment_id :=l_get_iac_prev_transactions.adjustment_id;
410: END IF;

Line 415: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No Previous transaction ');

411: CLOSE c_get_iac_prev_reclass;
412: END IF;
413:
414: IF (l_lac_reval_history(l_idx2).transaction_sub_type = 'IMPLEMENTATION') THEN
415: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No Previous transaction ');
416: l_get_previous_cost := l_get_fa_cost.cost;
417: IF igi_iac_common_utils.Get_Period_Info_for_Date(p_book_type_code,
418: l_get_fa_cost.date_placed_in_service,
419: l_prd_rec_pre ) THEN

Line 433: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No Previous transaction ');

429: -- the case may be the revaluation might be the first transaction
430: -- 1.Current period addition
431: -- 2.Implementation form MHCA
432: -- In the above two cases there is FA_COST only shown as previous cost
433: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No Previous transaction ');
434: /*IF igi_iac_common_utils.Get_Period_Info_for_Date(p_book_type_code,
435: l_get_fa_cost.date_placed_in_service,
436: l_prd_rec_pre ) THEN
437: NULL;

Line 441: igi_iac_debug_pkg.debug_other_string(g_state_level,

437: NULL;
438: END IF;*/
439: l_get_previous_cost := l_get_fa_cost.cost;
440: ELSE
441: igi_iac_debug_pkg.debug_other_string(g_state_level,
442: l_path,
443: 'Previous transaction '|| l_get_iac_prev_transactions.adjustment_id);
444: OPEN C_get_IAC_cost(l_get_iac_prev_transactions.adjustment_id);
445: FETCH c_get_iac_cost INTO l_get_iac_cost;

Line 569: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

565:
566: EXCEPTION
567: WHEN others THEN
568: begin
569: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
570: return false;
571: END;
572: END insert_rows;
573:

Line 612: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

608: RETURN TRUE;
609: EXCEPTION
610: WHEN others THEN
611: begin
612: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
613: RETURN FALSE;
614: END;
615: END delete_rows;
616: