eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIRX_IMP_IAC_REP dependencies on IGI_IAC_DEBUG_PKG

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

697: l_path_name := g_path||'imp';
698:
699: OPEN C_source_book;
700: FETCH C_source_book INTO l_dist_source_book;
701: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
702: p_full_path => l_path_name,
703: p_string => 'after fetch c_dist_source_book ');
704: CLOSE C_source_book;
705:

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

704: CLOSE C_source_book;
705:
706: OPEN c_period_counter;
707: FETCH c_period_counter into l_max_period_counter;
708: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
709: p_full_path => l_path_name,
710: p_string => 'after fetch c_period_counter ');
711: CLOSE c_period_counter;
712:

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

711: CLOSE c_period_counter;
712:
713: OPEN C_period(l_max_period_counter);
714: FETCH C_period INTO l_period_name;
715: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
716: p_full_path => l_path_name,
717: p_string => 'after fetch c_period ');
718: CLOSE C_period;
719:

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

727: l_organization_name,
728: l_fiscal_year,
729: l_cat_flex_struct,
730: l_Currency_Code;
731: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
732: p_full_path => l_path_name,
733: p_string => 'after fetch cur_dets ');
734: CLOSE cur_dets;
735:

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

760: END IF;
761:
762: -- get depreciate flag;
763: l_deprn_flag :='YES';
764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
765: p_full_path => l_path_name,
766: p_string => 'Get depreciate flag');
767:
768: open C_asset_derpn_Info (P_book_type_code,l_asset_id);

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

770: Close C_asset_derpn_Info;
771:
772: l_asset_ytd_deprn :=0;
773: l_asset_fiscal_year:=Null;
774: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
775: p_full_path => l_path_name,
776: p_string => 'before fetch C_YTD_ASSET');
777:
778: OPEN C_ytd_asset ( l_asset_id ,

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

790: End If;
791: END IF;
792: close C_ytd_asset_non_dep;
793: END IF;
794: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
795: p_full_path => l_path_name,
796: p_string => 'C_YTD_ASSET'|| l_asset_ytd_deprn);
797: CLOSE C_ytd_asset;
798:

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

795: p_full_path => l_path_name,
796: p_string => 'C_YTD_ASSET'|| l_asset_ytd_deprn);
797: CLOSE C_ytd_asset;
798:
799: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
800: p_full_path => l_path_name,
801: p_string => 'after fetch C_YTD_ASSET');
802:
803: OPEN cur_acct(l_asset_id);

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

802:
803: OPEN cur_acct(l_asset_id);
804: FETCH cur_acct
805: INTO l_acct;
806: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
807: p_full_path => l_path_name,
808: p_string => 'after fetch CUR ACCT');
809: CLOSE cur_acct;
810:

Line 824: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');

820: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
821: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
822: )
823: THEN
824: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
825: END IF;
826:
827: FOR l_deprn IN C_Deprn(l_curr_fiscal_year , l_asset_id , l_dist_source_book )
828: LOOP --LOOP 3

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

838: /* Fetching accounts for active distribution */
839: OPEN Cur_acct2(l_category_id,l_dist_source_book);
840: FETCH Cur_Acct2
841: INTO l_acct2;
842: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
843: p_full_path => l_path_name,
844: p_string => 'after fetch CUR ACCT2');
845: CLOSE Cur_Acct2;
846:

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

858: IF C_Ytd_Dist_non_deprn%notfound Then
859: l_dist_ytd_deprn:=0;
860: end if;
861: close C_Ytd_Dist_non_deprn;
862: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
863: p_full_path => l_path_name,
864: p_string => 'after fetch C_YTD_DIST');
865: END IF;
866: CLOSE C_Ytd_Dist;

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

874: /* Fetching accounts for inactive distribution */
875: OPEN Cur_acct2(l_category_id,l_dist_source_book);
876: FETCH Cur_Acct2
877: INTO l_acct2;
878: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
879: p_full_path => l_path_name,
880: p_string => 'after fetch CUR ACCT2');
881: CLOSE Cur_Acct2;
882:

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

895: l_fiscal_year,
896: l_dist_source_book);
897: FETCH C_Counter Into l_Inactive_Counter;
898:
899: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
900: p_full_path => l_path_name,
901: p_string => 'after fetch C_COUNTER');
902: CLOSE C_counter;
903:

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

914: IF C_Ytd_Dist_non_deprn%notfound Then
915: l_dist_ytd_deprn:=0;
916: end if;
917: close C_Ytd_Dist_non_deprn;
918: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
919: p_full_path => l_path_name,
920: p_string => 'after fetch C_Ytd_Dist');
921:
922: END IF;

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

925: ELSE
926: OPEN Cur_acct2(l_category_id,l_dist_source_book);
927: FETCH Cur_Acct2
928: INTO l_acct2;
929: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
930: p_full_path => l_path_name,
931: p_string => 'after fetch CUR ACCT2');
932: CLOSE Cur_Acct2;
933:

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

962:
963: OPEN C_dist_acct(l_deprn.distribution_id);
964: FETCH C_dist_acct
965: INTO l_dist_acct;
966: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
967: p_full_path => l_path_name,
968: p_string => 'after fetch dist acct');
969: CLOSE C_Dist_Acct;
970:

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

1048: p_qualifier => 'BASED_CATEGORY',
1049: p_ccid => l_category_id);
1050: EXCEPTION
1051: WHEN OTHERS THEN
1052: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1053: END;
1054:
1055: BEGIN
1056: l_minor_category:= fa_rx_flex_pkg.get_value(

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

1060: p_qualifier => 'MINOR_CATEGORY',
1061: p_ccid => l_category_id);
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1065: END;
1066:
1067: --This will get the concatenated category
1068: fa_rx_shared_pkg.concat_category (struct_id => l_cat_flex_struct,

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

1076: ,concat_string => l_concat_location
1077: ,segarray => l_loc_segs);
1078:
1079: --This will get the concatenated asset key
1080: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1081: p_full_path => l_path_name,
1082: p_string => 'ccid'||l_deprn.code_combination_id);
1083:
1084: fa_rx_shared_pkg.concat_asset_key (struct_id => l_asset_key_flex_struct,

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

1085: ccid => l_acct.asset_key_ccid,
1086: concat_string => l_concat_asset_key,
1087: segarray => l_asset_segs);
1088:
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,
1091: p_string => 'l_concat_location ' || l_concat_location);
1092: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1093: p_full_path => l_path_name,

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

1088:
1089: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1090: p_full_path => l_path_name,
1091: p_string => 'l_concat_location ' || l_concat_location);
1092: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1093: p_full_path => l_path_name,
1094: p_string => 'l_concat_asset_key ' || l_concat_asset_key);
1095: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1096: p_full_path => l_path_name,

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

1091: p_string => 'l_concat_location ' || l_concat_location);
1092: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1093: p_full_path => l_path_name,
1094: p_string => 'l_concat_asset_key ' || l_concat_asset_key);
1095: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1096: p_full_path => l_path_name,
1097: p_string => 'l_category_id ' || l_category_id);
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,

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

1094: p_string => 'l_concat_asset_key ' || l_concat_asset_key);
1095: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1096: p_full_path => l_path_name,
1097: p_string => 'l_category_id ' || l_category_id);
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,
1100: p_string => 'l_concat_category ' || l_concat_category);
1101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1102: p_full_path => l_path_name,

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

1097: p_string => 'l_category_id ' || l_category_id);
1098: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1099: p_full_path => l_path_name,
1100: p_string => 'l_concat_category ' || l_concat_category);
1101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1102: p_full_path => l_path_name,
1103: p_string => 'l_currency_code ' || l_currency_code);
1104: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1105: p_full_path => l_path_name,

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

1100: p_string => 'l_concat_category ' || l_concat_category);
1101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1102: p_full_path => l_path_name,
1103: p_string => 'l_currency_code ' || l_currency_code);
1104: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1105: p_full_path => l_path_name,
1106: p_string => 'l_concat_location ' ||l_concat_location );
1107:
1108: IF NOT( Igi_Iac_Common_Utils.Iac_Round ( l_main.cost_mhca ,

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

1276: -- Bug 3439808, end 1
1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1281: retcode:=2;
1282: errbuf:='Exception within igirx_imp_iac_rep';
1283:
1284: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

Line 1284: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1280: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => l_path_name);
1281: retcode:=2;
1282: errbuf:='Exception within igirx_imp_iac_rep';
1283:
1284: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1285: p_full_path => l_path_name,
1286: p_string => 'l_set_of_books_id ' || l_set_of_books_id);
1287: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1288: p_full_path => l_path_name,

Line 1287: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1283:
1284: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1285: p_full_path => l_path_name,
1286: p_string => 'l_set_of_books_id ' || l_set_of_books_id);
1287: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1288: p_full_path => l_path_name,
1289: p_string => 'l_period_name ' || l_period_name);
1290: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1291: p_full_path => l_path_name,

Line 1290: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1286: p_string => 'l_set_of_books_id ' || l_set_of_books_id);
1287: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1288: p_full_path => l_path_name,
1289: p_string => 'l_period_name ' || l_period_name);
1290: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1291: p_full_path => l_path_name,
1292: p_string => 'l_general_fund_acct ' || l_general_fund_acct);
1293: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1294: p_full_path => l_path_name,

Line 1293: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1289: p_string => 'l_period_name ' || l_period_name);
1290: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1291: p_full_path => l_path_name,
1292: p_string => 'l_general_fund_acct ' || l_general_fund_acct);
1293: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1294: p_full_path => l_path_name,
1295: p_string => 'l_operating_exp_acct ' || l_oper_expense_acct);
1296: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1297: p_full_path => l_path_name,

Line 1296: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1292: p_string => 'l_general_fund_acct ' || l_general_fund_acct);
1293: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1294: p_full_path => l_path_name,
1295: p_string => 'l_operating_exp_acct ' || l_oper_expense_acct);
1296: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1297: p_full_path => l_path_name,
1298: p_string => 'l_balancing_seg ' || l_balancing_seg);
1299: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1300: p_full_path => l_path_name,

Line 1299: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,

1295: p_string => 'l_operating_exp_acct ' || l_oper_expense_acct);
1296: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1297: p_full_path => l_path_name,
1298: p_string => 'l_balancing_seg ' || l_balancing_seg);
1299: igi_iac_debug_pkg.debug_other_string(p_level => g_unexp_level,
1300: p_full_path => l_path_name,
1301: p_string => 'l_book_type_code ' || p_book_type_code);
1302:
1303: END IMP;