172: l_path := g_path||'run_report';
173:
174: -- Enable this for write to log file when testing or debug!!
175: --fa_rx_util_pkg.enable_debug; -- Does not now follow debug standards!!!
176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
173:
174: -- Enable this for write to log file when testing or debug!!
175: --fa_rx_util_pkg.enable_debug; -- Does not now follow debug standards!!!
176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
174: -- Enable this for write to log file when testing or debug!!
175: --fa_rx_util_pkg.enable_debug; -- Does not now follow debug standards!!!
176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
175: --fa_rx_util_pkg.enable_debug; -- Does not now follow debug standards!!!
176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType' || p_bookType);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
178: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period ' || p_period);
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId' || p_categoryId);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
187: l_login_id := NVL(to_number(fnd_profile.value('LOGIN_ID')),-1);
180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_chartOfAccts' || p_chartOfAccts);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
187: l_login_id := NVL(to_number(fnd_profile.value('LOGIN_ID')),-1);
188: l_user_id := NVL(to_number(fnd_profile.value('USER_ID' )),-1);
181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc' || p_from_cc);
182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc' || p_to_cc);
183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset_num' || p_from_asset_num);
184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset_num ' || p_to_asset_num);
185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_request_id' || p_request_id);
186:
187: l_login_id := NVL(to_number(fnd_profile.value('LOGIN_ID')),-1);
188: l_user_id := NVL(to_number(fnd_profile.value('USER_ID' )),-1);
189:
222: ELSE
223: l_to_asset := p_to_asset_num;
224: END IF;
225:
226: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_s_deprec_report');
227: -- Process Summary Depreciation report
228: IF p_reptShrtName = 'RXIGIIAK' THEN
229: IF NOT run_s_deprec_report ( p_bookType
230: ,p_period
232: ,p_request_id
233: ,l_user_id
234: ,l_login_id)
235: THEN
236: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reptShrtName' || p_reptShrtName);
237: p_retcode := 2;
238: ELSE
239: IF NOT Delete_Zero_Rows(p_bookType,p_request_id,p_reptShrtName) THEN
240: p_retcode := 2;
241: END IF;
242: END IF;
243: -- Process Detailed Depreciation report
244: ELSIF p_reptShrtName = 'RXIGIIAD' THEN
245: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_d_deprec_report');
246: IF NOT run_d_deprec_report(p_bookType
247: ,p_period
248: ,l_finalCategoryId
249: ,l_from_cc
261: END IF;
262: END IF;
263: -- Process Summary Operating report
264: ELSIF p_reptShrtName = 'RXIGIIAM' THEN
265: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_s_operating_report');
266: IF NOT run_s_operating_report(p_bookType
267: ,p_period
268: ,l_finalCategoryId
269: ,p_request_id
277: END IF;
278: END IF;
279: -- Process Detailed Operating report
280: ELSIF p_reptShrtName = 'RXIGIIAO' THEN
281: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_d_operating_report');
282: IF NOT run_d_operating_report(p_bookType
283: ,p_period
284: ,l_finalCategoryId
285: ,l_from_cc
297: END IF;
298: END IF;
299: -- Process Summary Revaluation report
300: ELSIF p_reptShrtName = 'RXIGIIAL' THEN
301: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_s_reval_report');
302: IF NOT run_s_reval_report(p_bookType
303: ,p_period
304: ,l_finalCategoryId
305: ,p_request_id
313: END IF;
314: END IF;
315: -- Process Detailed Revaluation report
316: ELSIF p_reptShrtName = 'RXIGIIAR' THEN
317: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_d_reval_report');
318: IF NOT run_d_reval_report(p_bookType
319: ,p_period
320: ,l_finalCategoryId
321: ,l_from_cc
333: END IF;
334: END IF;
335: -- Process Summary Summary report
336: ELSIF p_reptShrtName = 'RXIGIIAJ' THEN
337: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_s_summary_report');
338: IF NOT run_s_summary_report( p_bookType
339: ,p_period
340: ,l_finalCategoryId
341: ,p_request_id
349: END IF;
350: END IF;
351: -- Process Detailed summary report
352: ELSIF p_reptShrtName = 'RXIGIIAB' THEN
353: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'run_d_summary_report');
354: IF NOT run_d_summary_report( p_bookType
355: ,p_period
356: ,l_finalCategoryId
357: ,l_from_cc
376: p_retcode := 2;
377: END IF;
378: p_retcode := 0;
379:
380: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** END ** ');
381:
382: EXCEPTION WHEN OTHERS THEN
383: IF SQLCODE <> 0 THEN
384: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
380: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** END ** ');
381:
382: EXCEPTION WHEN OTHERS THEN
383: IF SQLCODE <> 0 THEN
384: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
385: END IF;
386: p_retcode := 2;
387:
388: END run_report;
433: IF NOT l_selOk THEN
434: RETURN FALSE;
435: END IF;
436:
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
434: RETURN FALSE;
435: END IF;
436:
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
435: END IF;
436:
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
436:
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
444:
437: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_company_name ' || l_company_name);
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
444:
445: l_g_loc_struct := l_loc_struct;
438: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_cat_struct ' || l_cat_struct);
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
444:
445: l_g_loc_struct := l_loc_struct;
446: l_g_asset_key_struct := l_asset_key_struct;
439: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_loc_struct ' || l_loc_struct);
440: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_key_struct ' || l_asset_key_struct);
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct ' || l_acct_struct);
442: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_fiscal_year_name ' || l_fiscal_year_name);
443: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_currency_code ' || l_currency_code);
444:
445: l_g_loc_struct := l_loc_struct;
446: l_g_asset_key_struct := l_asset_key_struct;
447: l_g_cat_struct := l_cat_struct;
456: p_qualifier => 'GL_BALANCING');
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Balancing Segment No" : '|| sqlerrm);
461: IF c_flex%ISOPEN THEN
462: CLOSE c_flex;
463: END IF;
464: RETURN FALSE;
479: IF c_flex%ISOPEN THEN
480: CLOSE c_flex;
481: END IF;
482: -- bug 3421784, end 1
483: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Cost Centre Segment No" : '|| sqlerrm);
484: RETURN FALSE;
485: END;
486:
487: BEGIN
494: p_qualifier => 'GL_ACCOUNT');
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Account Segment No" : '|| sqlerrm);
499: IF c_flex%ISOPEN THEN
500: CLOSE c_flex;
501: END IF;
502: RETURN FALSE;
500: CLOSE c_flex;
501: END IF;
502: RETURN FALSE;
503: END;
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'company_seg_no is: ' || balancing_seg_no);
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'cost_ctr_seg_no is: ' || cost_ctr_seg_no);
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'account_seg_no is: ' || account_seg_no);
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct is: ' || l_acct_struct);
508:
501: END IF;
502: RETURN FALSE;
503: END;
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'company_seg_no is: ' || balancing_seg_no);
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'cost_ctr_seg_no is: ' || cost_ctr_seg_no);
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'account_seg_no is: ' || account_seg_no);
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct is: ' || l_acct_struct);
508:
509: BEGIN
502: RETURN FALSE;
503: END;
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'company_seg_no is: ' || balancing_seg_no);
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'cost_ctr_seg_no is: ' || cost_ctr_seg_no);
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'account_seg_no is: ' || account_seg_no);
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct is: ' || l_acct_struct);
508:
509: BEGIN
510: major_cat_seg_no :=
503: END;
504: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'company_seg_no is: ' || balancing_seg_no);
505: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'cost_ctr_seg_no is: ' || cost_ctr_seg_no);
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'account_seg_no is: ' || account_seg_no);
507: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_acct_struct is: ' || l_acct_struct);
508:
509: BEGIN
510: major_cat_seg_no :=
511: fa_rx_flex_pkg.flex_sql(p_application_id => 140,
521: IF c_flex%ISOPEN THEN
522: CLOSE c_flex;
523: END IF;
524: -- bug 3421784, end 2
525: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Major Category Segment No" : '|| sqlerrm);
526: RETURN FALSE;
527: END;
528: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'major_cat_seg_no is: ' || major_cat_seg_no);
529:
524: -- bug 3421784, end 2
525: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Major Category Segment No" : '|| sqlerrm);
526: RETURN FALSE;
527: END;
528: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'major_cat_seg_no is: ' || major_cat_seg_no);
529:
530: BEGIN
531: minor_cat_seg_no :=
532: fa_rx_flex_pkg.flex_sql(p_application_id => 140,
535: p_table_alias => 'cf',
536: p_mode => 'SELECT',
537: p_qualifier => 'MINOR_CATEGORY');
538:
539: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'minor_cat_seg_no is: ' || minor_cat_seg_no);
540: EXCEPTION
541: WHEN OTHERS THEN
542: -- bug 3421784, start 3
543: IF c_flex%ISOPEN THEN
544: CLOSE c_flex;
545: END IF;
546: -- bug 3421784, end 3
547:
548: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Unable to get "Minor Category Segment No" : '|| sqlerrm);
549: RETURN FALSE;
550: END;
551:
552: RETURN TRUE;
558: CLOSE c_flex;
559: END IF;
560: -- bug 3421784, end 4
561:
562: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within "get_flex_segments" : '|| sqlerrm);
563: RETURN FALSE;
564:
565: END get_flex_segments;
566:
588: IF NOT l_selOk THEN
589: RETURN FALSE;
590: END IF;
591:
592: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_period_name ' || l_period_name);
593:
594: RETURN TRUE;
595:
596: EXCEPTION
600: CLOSE c_period;
601: END IF;
602: -- bug 3421784, end 5
603:
604: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path, 'Exception within "get_period_name" : '|| sqlerrm);
605: RETURN FALSE;
606: END get_period_name;
607:
608: FUNCTION run_s_deprec_report ( p_bookType IN VARCHAR2
825: cb.asset_cost_acct ';
826:
827: -- bug 3421784, start 6
828: -- commenting out
829: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
830: -- bug 3421784, end 6
831:
832: /* Bug 3490402 */
833: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
861: IF (ret_lines%NOTFOUND) THEN
862: EXIT;
863: END IF;
864:
865: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
866:
867: -- This will get the CONCATANATED LOCATION
868: fa_rx_shared_pkg.concat_location (
869: struct_id => l_g_loc_struct
892: ,l_oper_exp_acct
893: ,l_reval_rsv_acct
894: )
895: THEN
896: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
897: END IF;*/
898:
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
895: THEN
896: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
897: END IF;*/
898:
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
896: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
897: END IF;*/
898:
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
897: END IF;*/
898:
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
898:
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
899: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
900: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
908:
901: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
908:
909: INSERT INTO igi_iac_asset_rep_itf (
902: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
908:
909: INSERT INTO igi_iac_asset_rep_itf (
910: request_id,
903: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
904: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
905: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
906: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
907: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
908:
909: INSERT INTO igi_iac_asset_rep_itf (
910: request_id,
911: company_name,
986: CLOSE ret_lines;
987: END IF;
988: -- bug 3421784, end 7
989:
990: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception in run_s_deprec_report: '|| sqlerrm);
991: RETURN FALSE;
992: END run_s_deprec_report;
993:
994: FUNCTION run_d_deprec_report ( p_bookType IN VARCHAR2
1262: cb.asset_cost_acct';
1263:
1264: -- bug 3421784, start 8
1265: -- commenting out
1266: --igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
1267: -- bug 3421784, end 8
1268:
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1265: -- commenting out
1266: --igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
1267: -- bug 3421784, end 8
1268:
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1266: --igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
1267: -- bug 3421784, end 8
1268:
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1267: -- bug 3421784, end 8
1268:
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1268:
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
1269: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
1277:
1270: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
1277:
1278: IF p_from_asset = 'NULL' THEN
1271: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
1277:
1278: IF p_from_asset = 'NULL' THEN
1279: l_from_asset := NULL;
1272: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
1273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
1274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
1275: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
1276: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
1277:
1278: IF p_from_asset = 'NULL' THEN
1279: l_from_asset := NULL;
1280: ELSE
1286: ELSE
1287: l_to_asset := p_to_asset;
1288: END IF;
1289:
1290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
1291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
1292:
1293: IF p_from_cc = 'NULL' THEN
1294: l_from_cc := NULL;
1287: l_to_asset := p_to_asset;
1288: END IF;
1289:
1290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
1291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
1292:
1293: IF p_from_cc = 'NULL' THEN
1294: l_from_cc := NULL;
1295: ELSE
1301: ELSE
1302: l_to_cc := p_to_cc;
1303: END IF;
1304:
1305: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
1306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
1307:
1308: /* Bug 3490402 */
1309: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
1302: l_to_cc := p_to_cc;
1303: END IF;
1304:
1305: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
1306: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
1307:
1308: /* Bug 3490402 */
1309: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
1310: p_period, /* :v_period */
1351: IF (ret_lines%NOTFOUND) THEN
1352: EXIT;
1353: END IF;
1354:
1355: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
1356:
1357: /* StatReq - The following if statement has been added to calculate the annual depreciation rate
1358: for straight-line, calculated depreciation methods */
1359:
1393: ,l_oper_exp_acct
1394: ,l_reval_rsv_acct
1395: )
1396: THEN
1397: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1398: END IF;*/
1399:
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1396: THEN
1397: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1398: END IF;*/
1399:
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1397: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1398: END IF;*/
1399:
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1398: END IF;*/
1399:
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1399:
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1400: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_number ' || l_asset_number);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1401: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_parent_id ' || l_parent_id);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1409: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_reval_rsv_acct ' || l_reval_rsv_acct);
1402: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1409: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_reval_rsv_acct ' || l_reval_rsv_acct);
1410:
1403: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1409: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_reval_rsv_acct ' || l_reval_rsv_acct);
1410:
1411: l_parent_no := NULL;
1404: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1409: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_reval_rsv_acct ' || l_reval_rsv_acct);
1410:
1411: l_parent_no := NULL;
1412:
1405: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1406: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_concat_cat ' || l_concat_cat);
1407: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1409: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path, 'l_reval_rsv_acct ' || l_reval_rsv_acct);
1410:
1411: l_parent_no := NULL;
1412:
1413: IF l_parent_id IS NOT NULL THEN
1512: CLOSE ret_lines;
1513: END IF;
1514: -- bug 3421784, end 9
1515:
1516: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception in run_d_deprec_report: '|| sqlerrm);
1517: RETURN FALSE;
1518: END run_d_deprec_report;
1519:
1520: FUNCTION run_s_operating_report( p_bookType IN VARCHAR2
1567:
1568: BEGIN
1569: l_path := g_path||'run_s_operating_report';
1570:
1571: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_s_operating_report ** ');
1572:
1573: l_select_statement := 'SELECT ' ||
1574: balancing_seg_no || ', ' ||
1575: cost_ctr_seg_no || ', ' ||
1726: cost_ctr_seg_no || ', ' ||
1727: account_seg_no || ', ' ||
1728: major_cat_seg_no;
1729:
1730: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after select ');
1731: -- bug 3421784, start 10
1732: -- commenting out
1733: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
1734: -- bug 3421784, end 10
1729:
1730: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after select ');
1731: -- bug 3421784, start 10
1732: -- commenting out
1733: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
1734: -- bug 3421784, end 10
1735:
1736: /* Bug 3490402 */
1737: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
1761: IF (ret_lines%NOTFOUND) THEN
1762: EXIT;
1763: END IF;
1764:
1765: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
1766:
1767: -- This will get the CONCATANATED LOCATION
1768: fa_rx_shared_pkg.concat_location (
1769: struct_id => l_g_loc_struct
1794: ,l_oper_exp_acct
1795: ,l_reval_rsv_acct
1796: )
1797: THEN
1798: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1799: END IF;*/
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1796: )
1797: THEN
1798: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1799: END IF;*/
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1797: THEN
1798: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1799: END IF;*/
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1798: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
1799: END IF;*/
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1799: END IF;*/
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1800: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1801: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1809:
1802: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1809:
1810: INSERT INTO igi_iac_asset_rep_itf (
1803: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1809:
1810: INSERT INTO igi_iac_asset_rep_itf (
1811: request_id,
1804: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
1805: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
1806: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
1807: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
1808: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
1809:
1810: INSERT INTO igi_iac_asset_rep_itf (
1811: request_id,
1812: company_name,
1881: IF ret_lines%ISOPEN THEN
1882: CLOSE ret_lines;
1883: END IF;
1884: -- bug 3421784, start 12
1885: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_s_operating_report: '|| sqlerrm);
1886: RETURN FALSE;
1887: END run_s_operating_report;
1888:
1889: FUNCTION run_d_operating_report( p_bookType IN VARCHAR2
1948:
1949: BEGIN
1950: l_path := g_path||'run_d_operating_report';
1951:
1952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_d_operating_report ** ');
1953:
1954: l_select_statement := 'SELECT ' ||
1955: balancing_seg_no || ', ' ||
1956: cost_ctr_seg_no || ', ' ||
2144: cost_ctr_seg_no || ', ' ||
2145: account_seg_no || ', ' ||
2146: major_cat_seg_no;
2147:
2148: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after select ');
2149:
2150: -- bug 3421784, start 12
2151: -- commenting out
2152: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
2148: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after select ');
2149:
2150: -- bug 3421784, start 12
2151: -- commenting out
2152: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
2153: -- bug 3421784, end 12
2154: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2150: -- bug 3421784, start 12
2151: -- commenting out
2152: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
2153: -- bug 3421784, end 12
2154: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2152: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
2153: -- bug 3421784, end 12
2154: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2153: -- bug 3421784, end 12
2154: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2154: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2162: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
2155:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2162: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
2163:
2156: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2162: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
2163:
2164: IF p_from_asset = 'NULL' THEN
2157: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2162: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
2163:
2164: IF p_from_asset = 'NULL' THEN
2165: l_from_asset := NULL;
2158: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
2159: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
2160: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
2161: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
2162: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
2163:
2164: IF p_from_asset = 'NULL' THEN
2165: l_from_asset := NULL;
2166: ELSE
2172: ELSE
2173: l_to_asset := p_to_asset;
2174: END IF;
2175:
2176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
2177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
2178:
2179: IF p_from_cc = 'NULL' THEN
2180: l_from_cc := NULL;
2173: l_to_asset := p_to_asset;
2174: END IF;
2175:
2176: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
2177: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
2178:
2179: IF p_from_cc = 'NULL' THEN
2180: l_from_cc := NULL;
2181: ELSE
2187: ELSE
2188: l_to_cc := p_to_cc;
2189: END IF;
2190:
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
2192: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
2193:
2194: /* Bug 3490402 */
2195: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
2188: l_to_cc := p_to_cc;
2189: END IF;
2190:
2191: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
2192: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
2193:
2194: /* Bug 3490402 */
2195: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
2196: p_period, /* :v_period */
2234: IF (ret_lines%NOTFOUND) THEN
2235: EXIT;
2236: END IF;
2237:
2238: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
2239:
2240: /* StatReq - The following if statement has been added to calculate the annual depreciation rate
2241: for straight-line, calculated depreciation methods */
2242:
2276: ,l_oper_exp_acct
2277: ,l_reval_rsv_acct
2278: )
2279: THEN
2280: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2281: END IF;*/
2282:
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2279: THEN
2280: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2281: END IF;*/
2282:
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2280: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2281: END IF;*/
2282:
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2281: END IF;*/
2282:
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2282:
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2284: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2292:
2285: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2292:
2293: l_parent_no := NULL;
2286: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2292:
2293: l_parent_no := NULL;
2294: IF l_parent_id IS NOT NULL THEN
2287: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2288: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2289: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2290: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2291: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2292:
2293: l_parent_no := NULL;
2294: IF l_parent_id IS NOT NULL THEN
2295: l_parent_no := l_asset_number;
2387: IF ret_lines%ISOPEN THEN
2388: CLOSE ret_lines;
2389: END IF;
2390: -- bug 3421784, end 13
2391: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_d_operating_report: '|| sqlerrm);
2392: RETURN FALSE;
2393: END run_d_operating_report;
2394:
2395: FUNCTION run_s_reval_report ( p_bookType IN VARCHAR2
2450: l_path VARCHAR2(150);
2451:
2452: BEGIN
2453: l_path := g_path||'run_s_reval_report';
2454: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_s_reval_report ** ');
2455:
2456: l_select_statement := 'SELECT ' ||
2457: balancing_seg_no || ', ' ||
2458: cost_ctr_seg_no || ', ' ||
2613: cb.asset_cost_acct';
2614:
2615: -- bug 3421784, start 14
2616: -- commenting out
2617: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
2618: -- bug 3421784, end 14
2619:
2620: /* Bug 3490402 */
2621: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
2647: IF (ret_lines%NOTFOUND) THEN
2648: EXIT;
2649: END IF;
2650:
2651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
2652:
2653: -- This will get the CONCATANATED LOCATION
2654: fa_rx_shared_pkg.concat_location (
2655: struct_id => l_g_loc_struct
2680: ,l_oper_exp_acct
2681: ,l_reval_rsv_acct
2682: )
2683: THEN
2684: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2685: END IF;*/
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2682: )
2683: THEN
2684: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2685: END IF;*/
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2683: THEN
2684: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2685: END IF;*/
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2684: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
2685: END IF;*/
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2685: END IF;*/
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2687: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2695:
2688: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2695:
2696: INSERT INTO igi_iac_asset_rep_itf (
2689: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2695:
2696: INSERT INTO igi_iac_asset_rep_itf (
2697: request_id,
2690: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
2691: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
2692: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
2693: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
2694: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
2695:
2696: INSERT INTO igi_iac_asset_rep_itf (
2697: request_id,
2698: company_name,
2771: IF ret_lines%ISOPEN THEN
2772: CLOSE ret_lines;
2773: END IF;
2774: -- bug 3421784, end 15
2775: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_s_reval_report : '|| sqlerrm);
2776: RETURN FALSE;
2777: END run_s_reval_report;
2778:
2779: FUNCTION run_d_reval_report ( p_bookType IN VARCHAR2
2846: l_path VARCHAR2(150);
2847:
2848: BEGIN
2849: l_path := g_path||'run_d_reval_report';
2850: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_d_reval_report ** ');
2851:
2852: l_select_statement := 'SELECT ' ||
2853: balancing_seg_no || ', ' ||
2854: cost_ctr_seg_no || ', ' ||
3045: cb.asset_cost_acct' ;
3046:
3047: -- bug 3421784, start 16
3048: -- commenting out
3049: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3050: -- bug 3421784, end 16
3051:
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3048: -- commenting out
3049: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3050: -- bug 3421784, end 16
3051:
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3049: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3050: -- bug 3421784, end 16
3051:
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3050: -- bug 3421784, end 16
3051:
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3051:
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3059: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3052: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3059: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3060:
3053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3059: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3060:
3061: IF p_from_asset = 'NULL' THEN
3054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3059: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3060:
3061: IF p_from_asset = 'NULL' THEN
3062: l_from_asset := NULL;
3055: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3056: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3057: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3058: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3059: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3060:
3061: IF p_from_asset = 'NULL' THEN
3062: l_from_asset := NULL;
3063: ELSE
3069: ELSE
3070: l_to_asset := p_to_asset;
3071: END IF;
3072:
3073: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
3074: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
3075:
3076: IF p_from_cc = 'NULL' THEN
3077: l_from_cc := NULL;
3070: l_to_asset := p_to_asset;
3071: END IF;
3072:
3073: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
3074: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
3075:
3076: IF p_from_cc = 'NULL' THEN
3077: l_from_cc := NULL;
3078: ELSE
3084: ELSE
3085: l_to_cc := p_to_cc;
3086: END IF;
3087:
3088: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
3089: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
3090:
3091: /* Bug 3490402 */
3092: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
3085: l_to_cc := p_to_cc;
3086: END IF;
3087:
3088: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
3089: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
3090:
3091: /* Bug 3490402 */
3092: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
3093: p_period, /* :v_period */
3132: IF (ret_lines%NOTFOUND) THEN
3133: EXIT;
3134: END IF;
3135:
3136: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
3137: /* StatReq - The following if statement has been added to calculate the annual depreciation rate
3138: for straight-line, calculated depreciation methods */
3139:
3140: -- Calculate STL_RATE from life_in_months
3173: ,l_oper_exp_acct
3174: ,l_reval_rsv_acct
3175: )
3176: THEN
3177: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3178: END IF;*/
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3175: )
3176: THEN
3177: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3178: END IF;*/
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3176: THEN
3177: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3178: END IF;*/
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3177: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3178: END IF;*/
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3178: END IF;*/
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3179: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3187: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3187: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3188:
3181: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3187: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3188:
3189: l_parent_no := NULL;
3182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3187: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3188:
3189: l_parent_no := NULL;
3190:
3183: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3184: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3185: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3186: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3187: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3188:
3189: l_parent_no := NULL;
3190:
3191: IF l_parent_id IS NOT NULL THEN
3286: IF ret_lines%ISOPEN THEN
3287: CLOSE ret_lines;
3288: END IF;
3289: -- bug 3421784, end 17
3290: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_d_reval_report : '|| sqlerrm);
3291: RETURN FALSE;
3292: END run_d_reval_report;
3293:
3294: FUNCTION run_s_summary_report ( p_bookType IN VARCHAR2
3346: l_path VARCHAR2(150);
3347:
3348: BEGIN
3349: l_path := g_path||'run_s_summary_report';
3350: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_s_summary_report ** ');
3351:
3352: l_select_statement := 'SELECT ' ||
3353: balancing_seg_no || ', ' ||
3354: cost_ctr_seg_no || ', ' ||
3511: cb.asset_cost_acct';
3512:
3513: -- bug 3421784, start 18
3514: -- commenting out
3515: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3516: -- bug 3421784, end 18
3517:
3518: /* Bug 3490402 */
3519: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
3544:
3545: IF (ret_lines%NOTFOUND) THEN
3546: EXIT;
3547: END IF;
3548: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
3549:
3550: -- This will get the CONCATANATED LOCATION
3551: fa_rx_shared_pkg.concat_location (
3552: struct_id => l_g_loc_struct
3577: ,l_oper_exp_acct
3578: ,l_reval_rsv_acct
3579: )
3580: THEN
3581: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3582: END IF;*/
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3579: )
3580: THEN
3581: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3582: END IF;*/
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3580: THEN
3581: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3582: END IF;*/
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3581: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
3582: END IF;*/
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3582: END IF;*/
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3583: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3584: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3592:
3585: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3592:
3593: INSERT INTO igi_iac_asset_rep_itf (
3586: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3592:
3593: INSERT INTO igi_iac_asset_rep_itf (
3594: request_id,
3587: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
3588: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
3589: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
3590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
3591: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
3592:
3593: INSERT INTO igi_iac_asset_rep_itf (
3594: request_id,
3595: company_name,
3669: IF ret_lines%ISOPEN THEN
3670: CLOSE ret_lines;
3671: END IF;
3672: -- bug 3421784, end 19
3673: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_s_summary_report : '|| sqlerrm);
3674: RETURN FALSE;
3675: END run_s_summary_report;
3676:
3677: FUNCTION run_d_summary_report ( p_bookType IN VARCHAR2
3741: l_path VARCHAR2(150);
3742:
3743: BEGIN
3744: l_path := g_path||'run_d_summary_report';
3745: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** START run_d_summary_report ** ');
3746:
3747: l_select_statement := 'SELECT ' ||
3748: balancing_seg_no || ', ' ||
3749: cost_ctr_seg_no || ', ' ||
3940: cb.asset_cost_acct';
3941:
3942: -- bug 3421784, start 20
3943: -- commenting out
3944: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3945: -- bug 3421784, end 20
3946:
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3943: -- commenting out
3944: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3945: -- bug 3421784, end 20
3946:
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3944: -- igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_select_statement ' || l_select_statement);
3945: -- bug 3421784, end 20
3946:
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3945: -- bug 3421784, end 20
3946:
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3946:
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3947: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' ** After l_select ** ');
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3955:
3948: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_categoryId --> ' || p_categoryId);
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3955:
3956: IF p_from_asset = 'NULL' THEN
3949: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_bookType --> ' || p_bookType);
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3955:
3956: IF p_from_asset = 'NULL' THEN
3957: l_from_asset := NULL;
3950: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_period --> ' || p_period);
3951: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_cc --> ' || nvl(p_from_cc,1));
3952: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_cc --> ' || nvl(p_to_cc,1));
3953: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_from_asset --> ' || nvl(p_from_asset,1));
3954: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_to_asset --> ' || nvl(p_to_asset,1));
3955:
3956: IF p_from_asset = 'NULL' THEN
3957: l_from_asset := NULL;
3958: ELSE
3964: ELSE
3965: l_to_asset := p_to_asset;
3966: END IF;
3967:
3968: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
3969: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
3970:
3971: IF p_from_cc = 'NULL' THEN
3972: l_from_cc := NULL;
3965: l_to_asset := p_to_asset;
3966: END IF;
3967:
3968: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_asset --> ' || nvl(l_from_asset,1));
3969: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_asset --> ' || nvl(l_to_asset,1));
3970:
3971: IF p_from_cc = 'NULL' THEN
3972: l_from_cc := NULL;
3973: ELSE
3979: ELSE
3980: l_to_cc := p_to_cc;
3981: END IF;
3982:
3983: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
3984: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
3985:
3986: /* Bug 3490402 */
3987: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
3980: l_to_cc := p_to_cc;
3981: END IF;
3982:
3983: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_from_cc --> ' || nvl(l_from_cc,1));
3984: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_to_cc --> ' || nvl(l_to_cc,1));
3985:
3986: /* Bug 3490402 */
3987: OPEN ret_lines FOR l_select_statement USING p_bookType, /* :v_bookType */
3988: p_period, /* :v_period */
3996: l_to_cc, /* :v_to_cc1 */
3997: l_from_asset, /* :v_from_asset1 */
3998: l_to_asset; /* :v_to_asset1 */
3999: LOOP
4000: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'FETCH');
4001: FETCH ret_lines INTO
4002: l_gl_code_seg1,
4003: l_gl_code_seg2,
4004: l_gl_code_seg3,
4029: IF (ret_lines%NOTFOUND) THEN
4030: EXIT;
4031: END IF;
4032:
4033: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'after fetch ');
4034:
4035: /* StatReq - The following if statement has been added to calculate the annual depreciation rate
4036: for straight-line, calculated depreciation methods */
4037:
4071: ,l_oper_exp_acct
4072: ,l_reval_rsv_acct
4073: )
4074: THEN
4075: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
4076: END IF;*/
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4073: )
4074: THEN
4075: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
4076: END IF;*/
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4074: THEN
4075: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
4076: END IF;*/
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4075: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Failed to get Account segement values - will continue.... ');
4076: END IF;*/
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4076: END IF;*/
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4077: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_stl_rate ' || l_stl_rate);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4085: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
4078: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_loc ' || l_concat_loc);
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4085: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
4086: l_parent_no := NULL;
4079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_asset_key ' || l_concat_asset_key);
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4085: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
4086: l_parent_no := NULL;
4087:
4080: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_asset_cat_id ' || l_asset_cat_id);
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4085: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
4086: l_parent_no := NULL;
4087:
4088: IF l_parent_id IS NOT NULL THEN
4081: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_concat_cat ' || l_concat_cat);
4082: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_dep_backlog ' || l_dep_backlog);
4083: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_gen_fund_acct ' || l_gen_fund_acct);
4084: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_oper_exp_acct ' || l_oper_exp_acct);
4085: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_reval_rsv_acct ' || l_reval_rsv_acct);
4086: l_parent_no := NULL;
4087:
4088: IF l_parent_id IS NOT NULL THEN
4089: l_parent_no := l_asset_number;
4185: IF ret_lines%ISOPEN THEN
4186: CLOSE ret_lines;
4187: END IF;
4188: -- bug 3421784, end 21
4189: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within run_d_summary_report : '|| sqlerrm);
4190: RETURN FALSE;
4191: END run_d_summary_report;
4192:
4193: FUNCTION Delete_Zero_Rows(p_bookType IN VARCHAR2,
4196: RETURN BOOLEAN IS
4197: l_path VARCHAR2(150);
4198: BEGIN
4199: l_path := g_path||'Delete_Zero_Rows';
4200: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting rows with all zero values');
4201: IF p_reptShrtName IN ('RXIGIIAK','RXIGIIAD') THEN
4202: DELETE FROM igi_iac_asset_rep_itf
4203: WHERE book_type_code = p_bookType
4204: AND request_id = p_request_id
4235: AND oper_acct = 0
4236: AND deprn_resv = 0
4237: AND backlog = 0;
4238: END IF;
4239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleted rows with all zero values');
4240: EXCEPTION
4241: WHEN OTHERS THEN
4242: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within Delete_Zero_Rows : '|| sqlerrm);
4243: RETURN FALSE;
4238: END IF;
4239: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleted rows with all zero values');
4240: EXCEPTION
4241: WHEN OTHERS THEN
4242: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within Delete_Zero_Rows : '|| sqlerrm);
4243: RETURN FALSE;
4244: END Delete_Zero_Rows;
4245:
4246: FUNCTION get_acct_seg_values ( p_bookType IN VARCHAR2
4269: p_deprn_res_acct := l_acct.deprn_reserve_acct ;
4270: p_deprn_exp_acct := l_acct.deprn_expense_acct;
4271: l_retVal := TRUE;
4272: END LOOP;
4273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_res_acct ' || p_deprn_res_acct);
4274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_exp_acct ' || p_deprn_exp_acct);
4275: RETURN l_retVal;
4276: EXCEPTION
4277: WHEN OTHERS THEN
4270: p_deprn_exp_acct := l_acct.deprn_expense_acct;
4271: l_retVal := TRUE;
4272: END LOOP;
4273: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_res_acct ' || p_deprn_res_acct);
4274: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_exp_acct ' || p_deprn_exp_acct);
4275: RETURN l_retVal;
4276: EXCEPTION
4277: WHEN OTHERS THEN
4278: -- bug 3421784, start 21
4279: IF c_acct%ISOPEN THEN
4280: CLOSE c_acct;
4281: END IF;
4282: -- bug 3421784, end 21
4283: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within get_acct_seg_values : '|| sqlerrm);
4284: RETURN FALSE;
4285: END get_acct_seg_values;
4286:
4287: FUNCTION get_acct_seg_val_from_ccid ( p_bookType IN VARCHAR2
4382: END IF;
4383:
4384: END IF;
4385:
4386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_set_of_books_id ' || l_set_of_books_id);
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4383:
4384: END IF;
4385:
4386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_set_of_books_id ' || l_set_of_books_id);
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_rsv_acct ' || p_reval_rsv_acct);
4384: END IF;
4385:
4386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_set_of_books_id ' || l_set_of_books_id);
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_rsv_acct ' || p_reval_rsv_acct);
4392:
4385:
4386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_set_of_books_id ' || l_set_of_books_id);
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_rsv_acct ' || p_reval_rsv_acct);
4392:
4393: RETURN TRUE;
4386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_set_of_books_id ' || l_set_of_books_id);
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_rsv_acct ' || p_reval_rsv_acct);
4392:
4393: RETURN TRUE;
4394:
4387: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'l_chart_of_accts ' || l_chart_of_accts);
4388: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_deprn_backlog ' || p_deprn_backlog);
4389: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_gen_fund_acct ' || p_gen_fund_acct);
4390: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_oper_exp_acct ' || p_oper_exp_acct);
4391: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'p_reval_rsv_acct ' || p_reval_rsv_acct);
4392:
4393: RETURN TRUE;
4394:
4395: EXCEPTION
4399: CLOSE c_acct;
4400: END IF;
4401: -- bug 3421784, end 22
4402:
4403: igi_iac_debug_pkg.debug_other_string(g_unexp_level,l_path,'Exception within get_acct_seg_val_from_ccid : '|| sqlerrm);
4404: RETURN FALSE;
4405: END get_acct_seg_val_from_ccid;
4406:
4407: BEGIN