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.FV_STATUS_OF_FUNDS_PKG dependencies on FND_LOG

Line 815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

811: OPEN c_parent_value_budget;
812: LOOP
813: FETCH c_parent_value_budget into v_value_low, v_value_high;
814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
817: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW FOR BUDGET'||V_VALUE_LOW);
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH FOR BUDGET'||V_VALUE_HIGH);
819: END IF;

Line 816: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);

812: LOOP
813: FETCH c_parent_value_budget into v_value_low, v_value_high;
814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
817: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW FOR BUDGET'||V_VALUE_LOW);
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH FOR BUDGET'||V_VALUE_HIGH);
819: END IF;
820:

Line 817: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW FOR BUDGET'||V_VALUE_LOW);

813: FETCH c_parent_value_budget into v_value_low, v_value_high;
814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
817: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW FOR BUDGET'||V_VALUE_LOW);
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH FOR BUDGET'||V_VALUE_HIGH);
819: END IF;
820:
821: IF c_parent_value_budget%FOUND THEN

Line 818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH FOR BUDGET'||V_VALUE_HIGH);

814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
817: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW FOR BUDGET'||V_VALUE_LOW);
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH FOR BUDGET'||V_VALUE_HIGH);
819: END IF;
820:
821: IF c_parent_value_budget%FOUND THEN
822: FOR c_balances_budget_rec IN c_balances_budget LOOP

Line 824: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

820:
821: IF c_parent_value_budget%FOUND THEN
822: FOR c_balances_budget_rec IN c_balances_budget LOOP
823:
824: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
826: END IF;
827: INSERT INTO fv_status_funds_temp
828: (pagebk1,pagebk2,pagebk3,acct_total) VALUES

Line 825: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);

821: IF c_parent_value_budget%FOUND THEN
822: FOR c_balances_budget_rec IN c_balances_budget LOOP
823:
824: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_PARENT_VALUE FOR BUDGET'||V_PARENT_VALUE);
826: END IF;
827: INSERT INTO fv_status_funds_temp
828: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
829: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,

Line 847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

843: IF parent_flag = 'N' THEN
844: -- since there are no children assign account to high and low
845: v_value_low := v_parent_value;
846: v_value_high := v_parent_value;
847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'IN THE LOOP WHERE NO CHILD FOUND');
849: END IF;
850:
851: FOR c_balances_budget_rec IN c_balances_budget LOOP

Line 848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'IN THE LOOP WHERE NO CHILD FOUND');

844: -- since there are no children assign account to high and low
845: v_value_low := v_parent_value;
846: v_value_high := v_parent_value;
847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'IN THE LOOP WHERE NO CHILD FOUND');
849: END IF;
850:
851: FOR c_balances_budget_rec IN c_balances_budget LOOP
852: INSERT INTO fv_status_funds_temp

Line 856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

852: INSERT INTO fv_status_funds_temp
853: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
854: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
855: c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);
856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);
858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);
859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);
860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);

Line 857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);

853: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
854: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
855: c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);
856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);
858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);
859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);
860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);
861: END IF;

Line 858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);

854: (c_balances_budget_rec.pg1,c_balances_budget_rec.pg2,
855: c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);
856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);
858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);
859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);
860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);
861: END IF;
862: END LOOP;

Line 859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);

855: c_balances_budget_rec.pg3,c_balances_budget_rec.bal_bud);
856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);
858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);
859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);
860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);
861: END IF;
862: END LOOP;
863: FOR c_packets_budget_rec IN c_packets_budget LOOP

Line 860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);

856: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG1 :'||C_BALANCES_BUDGET_REC.PG1);
858: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG2 :'||C_BALANCES_BUDGET_REC.PG2);
859: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.PG3 :'||C_BALANCES_BUDGET_REC.PG3);
860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_BUD_REC.BAL_BUD :'||C_BALANCES_BUDGET_REC.BAL_BUD);
861: END IF;
862: END LOOP;
863: FOR c_packets_budget_rec IN c_packets_budget LOOP
864: INSERT INTO fv_status_funds_temp

Line 868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

864: INSERT INTO fv_status_funds_temp
865: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
866: (c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
867: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);
871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);
872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);

Line 869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);

865: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
866: (c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
867: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);
871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);
872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);
873: END IF;

Line 870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);

866: (c_packets_budget_rec.pg1,c_packets_budget_rec.pg2,
867: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);
871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);
872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);
873: END IF;
874: END LOOP;

Line 871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);

867: c_packets_budget_rec.pg3,c_packets_budget_rec.pac_bud);
868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);
871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);
872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);
873: END IF;
874: END LOOP;
875: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP

Line 872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);

868: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATS.PG1 :'||C_PACKETS_BUDGET_REC.PG1);
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKATES.PG2 :'||C_PACKETS_BUDGET_REC.PG2);
871: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PG3 :'||C_PACKETS_BUDGET_REC.PG3);
872: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_PACKETS.PAC_BUD :'||C_PACKETS_BUDGET_REC.PAC_BUD);
873: END IF;
874: END LOOP;
875: FOR c_get_temptable_info_rec IN c_get_temptable_info LOOP
876:

Line 890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

886: c_get_temptable_info_rec.pagebk3,
887: v_treasury_symbol_id1,
888: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
889:
890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

Line 891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);

887: v_treasury_symbol_id1,
888: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
889:
890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
895: END IF;

Line 892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);

888: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
889:
890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
895: END IF;
896: END LOOP;

Line 893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);

889:
890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
895: END IF;
896: END LOOP;
897: END IF;

Line 894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

890: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
892: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
893: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
894: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
895: END IF;
896: END LOOP;
897: END IF;
898: exit;

Line 920: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);

916: END IF;
917: EXCEPTION
918: WHEN OTHERS THEN
919: l_errbuf := SQLERRM;
920: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
921: raise;
922: END sum_children_budget;
923:
924:

Line 997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

993: INSERT INTO fv_status_funds_temp
994: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
995: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
996: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);
1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);

Line 998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);

994: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
995: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
996: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);
1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);
1002: END IF;

Line 999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);

995: (c_balances_transfers_rec.pg1,c_balances_transfers_rec.pg2,
996: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);
1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);
1002: END IF;
1003: END LOOP;

Line 1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);

996: c_balances_transfers_rec.pg3,c_balances_transfers_rec.bal_trans);
997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);
1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);
1002: END IF;
1003: END LOOP;
1004: FOR c_packets_spending_rec IN c_packets_spending LOOP

Line 1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);

997: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG1 :'||C_BALANCES_TRANSFERS_REC.PG1);
999: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG2 :'||C_BALANCES_TRANSFERS_REC.PG2);
1000: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.PG3 :'||C_BALANCES_TRANSFERS_REC.PG3);
1001: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_TRANS_REC.BAL_TRANS :'||C_BALANCES_TRANSFERS_REC.BAL_TRANS);
1002: END IF;
1003: END LOOP;
1004: FOR c_packets_spending_rec IN c_packets_spending LOOP
1005: INSERT INTO fv_status_funds_temp

Line 1020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1016: AND pagebreak_seg2 = c_get_temptable_info_rec.pagebk2
1017: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
1018: AND fund = v_fund_value1;
1019:
1020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1022: END IF;
1023:
1024: -- Modified to fix Bug.1575992

Line 1021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

1017: AND pagebreak_seg3 = c_get_temptable_info_rec.pagebk3
1018: AND fund = v_fund_value1;
1019:
1020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1022: END IF;
1023:
1024: -- Modified to fix Bug.1575992
1025: IF SQL%ROWCOUNT = 0 THEN

Line 1035: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1031: c_get_temptable_info_rec.pagebk2,
1032: c_get_temptable_info_rec.pagebk3,
1033: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
1034:
1035: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN_2:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1037: END IF;
1038: END IF;
1039: ELSIF v_trans_type = 'TRANS_OUT' THEN

Line 1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN_2:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

1032: c_get_temptable_info_rec.pagebk3,
1033: decode(v_sign,'C',(c_get_temptable_info_rec.atot*-1),c_get_temptable_info_rec.atot));
1034:
1035: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANS_IN_2:C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1037: END IF;
1038: END IF;
1039: ELSIF v_trans_type = 'TRANS_OUT' THEN
1040: UPDATE fv_status_funds_final SET

Line 1117: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);

1113: END IF;
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: l_errbuf := SQLERRM;
1117: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
1118: raise;
1119: END sum_children_transfers;
1120:
1121:

Line 1153: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1149:
1150: OPEN c_parent_value_spending;
1151: LOOP
1152: FETCH c_parent_value_spending into v_value_low, v_value_high;
1153: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW '||V_VALUE_LOW);
1155: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH '||V_VALUE_HIGH);
1156: END IF;
1157: IF c_parent_value_spending%FOUND THEN

Line 1154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW '||V_VALUE_LOW);

1150: OPEN c_parent_value_spending;
1151: LOOP
1152: FETCH c_parent_value_spending into v_value_low, v_value_high;
1153: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW '||V_VALUE_LOW);
1155: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH '||V_VALUE_HIGH);
1156: END IF;
1157: IF c_parent_value_spending%FOUND THEN
1158: FOR c_balances_spending_rec IN c_balances_spending LOOP

Line 1155: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH '||V_VALUE_HIGH);

1151: LOOP
1152: FETCH c_parent_value_spending into v_value_low, v_value_high;
1153: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1154: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_LOW '||V_VALUE_LOW);
1155: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_VALUE_HIGH '||V_VALUE_HIGH);
1156: END IF;
1157: IF c_parent_value_spending%FOUND THEN
1158: FOR c_balances_spending_rec IN c_balances_spending LOOP
1159: INSERT INTO fv_status_funds_temp

Line 1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1159: INSERT INTO fv_status_funds_temp
1160: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1161: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1162: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);
1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);
1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);
1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);

Line 1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);

1160: (pagebk1,pagebk2,pagebk3,acct_total) VALUES
1161: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1162: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);
1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);
1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);
1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);
1168: END IF;

Line 1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);

1161: (c_balances_spending_rec.pg1,c_balances_spending_rec.pg2,
1162: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);
1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);
1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);
1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);
1168: END IF;
1169:

Line 1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);

1162: c_balances_spending_rec.pg3,c_balances_spending_rec.bal_spend);
1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);
1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);
1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);
1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);
1168: END IF;
1169:
1170: END LOOP;

Line 1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);

1163: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG1 :'||C_BALANCES_SPENDING_REC.PG1);
1165: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG2 :'||C_BALANCES_SPENDING_REC.PG2);
1166: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.PG3 :'||C_BALANCES_SPENDING_REC.PG3);
1167: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_BAL_SPEND_REC.BAL_SPEND :'||C_BALANCES_SPENDING_REC.BAL_SPEND);
1168: END IF;
1169:
1170: END LOOP;
1171: FOR c_packets_spending_rec IN c_packets_spending LOOP

Line 1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1214: c_get_temptable_info_rec.pagebk2,
1215: c_get_temptable_info_rec.pagebk3,
1216: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1217: END IF;
1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

Line 1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);

1215: c_get_temptable_info_rec.pagebk3,
1216: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1217: END IF;
1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1223: END IF;

Line 1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);

1216: decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0)));
1217: END IF;
1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1223: END IF;
1224: ELSIF v_spend_type = 'UNLIQ_OBLIG' THEN

Line 1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);

1217: END IF;
1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1223: END IF;
1224: ELSIF v_spend_type = 'UNLIQ_OBLIG' THEN
1225: UPDATE fv_status_funds_final SET

Line 1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);

1218: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1219: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMP.PAGEBK1 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK1);
1220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK2 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK2);
1221: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.PAGEBK3 :'||C_GET_TEMPTABLE_INFO_REC.PAGEBK3);
1222: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_GET_TEMPTABLE_INFO_REC.ATOT :'||C_GET_TEMPTABLE_INFO_REC.ATOT);
1223: END IF;
1224: ELSIF v_spend_type = 'UNLIQ_OBLIG' THEN
1225: UPDATE fv_status_funds_final SET
1226: unliquid_oblig_total = decode(v_sign,'C',nvl(c_get_temptable_info_rec.atot,0) * (-1),nvl(c_get_temptable_info_rec.atot,0))

Line 1340: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);

1336: END IF;
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: l_errbuf := SQLERRM;
1340: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
1341: raise;
1342: END sum_children_spending;
1343:
1344: /*************************************************************************/

Line 1369: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1365: when others then
1366: err_message := 'FV_FUNDS_AVAILABLE_PKG.GET_FLEX_VALUE_ID.L.'||sqlerrm;
1367: fnd_message.set_name('FV','FV_FAI_GENERAL');
1368: fnd_message.set_token('MGS',err_message);
1369: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);
1371: END IF;
1372: app_exception.raise_exception;
1373:

Line 1370: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);

1366: err_message := 'FV_FUNDS_AVAILABLE_PKG.GET_FLEX_VALUE_ID.L.'||sqlerrm;
1367: fnd_message.set_name('FV','FV_FAI_GENERAL');
1368: fnd_message.set_token('MGS',err_message);
1369: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);
1371: END IF;
1372: app_exception.raise_exception;
1373:
1374: END get_flex_value_id;

Line 1389: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);

1385: commit;
1386: EXCEPTION
1387: WHEN OTHERS THEN
1388: l_errbuf := SQLERRM;
1389: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name||'.final_exception',l_errbuf);
1390: raise;
1391: END delete_from_final;
1392:
1393:

Line 1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1414:
1415: BEGIN
1416: -- delete all the rows from the final table
1417: delete_from_final;
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
1420: END IF;
1421: -- reassign incoming variables
1422: acct_ff_low := x_acct_ff_low;

Line 1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');

1415: BEGIN
1416: -- delete all the rows from the final table
1417: delete_from_final;
1418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BEGIN');
1420: END IF;
1421: -- reassign incoming variables
1422: acct_ff_low := x_acct_ff_low;
1423: acct_ff_high := x_acct_ff_high;

Line 1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1474: v_obligation := nvl(c_treasury_fund_value_rec.unliquid_obligations,'-1');
1475: v_expenditure := nvl(c_treasury_fund_value_rec.expended_amount,'-1');
1476: v_treasury_symbol_id:=c_treasury_fund_value_rec.treasury_symbol_id ;
1477: v_statement := 'D';
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FUND VALUE :' ||V_FUND_VALUE);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCING SEGMENT NAME :' ||BAL_SEG_NAME);
1481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ACCOUNTING SEG NAME:' || ACCT_SEG_NAME);
1482: END IF;

Line 1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FUND VALUE :' ||V_FUND_VALUE);

1475: v_expenditure := nvl(c_treasury_fund_value_rec.expended_amount,'-1');
1476: v_treasury_symbol_id:=c_treasury_fund_value_rec.treasury_symbol_id ;
1477: v_statement := 'D';
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FUND VALUE :' ||V_FUND_VALUE);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCING SEGMENT NAME :' ||BAL_SEG_NAME);
1481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ACCOUNTING SEG NAME:' || ACCT_SEG_NAME);
1482: END IF;
1483:

Line 1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCING SEGMENT NAME :' ||BAL_SEG_NAME);

1476: v_treasury_symbol_id:=c_treasury_fund_value_rec.treasury_symbol_id ;
1477: v_statement := 'D';
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FUND VALUE :' ||V_FUND_VALUE);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCING SEGMENT NAME :' ||BAL_SEG_NAME);
1481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ACCOUNTING SEG NAME:' || ACCT_SEG_NAME);
1482: END IF;
1483:
1484: -- Processing the budget authority account

Line 1481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ACCOUNTING SEG NAME:' || ACCT_SEG_NAME);

1477: v_statement := 'D';
1478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FUND VALUE :' ||V_FUND_VALUE);
1480: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCING SEGMENT NAME :' ||BAL_SEG_NAME);
1481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ACCOUNTING SEG NAME:' || ACCT_SEG_NAME);
1482: END IF;
1483:
1484: -- Processing the budget authority account
1485:

Line 1488: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1484: -- Processing the budget authority account
1485:
1486: -- Find flex_value_id
1487: acct_flex_id := get_flex_value_id(v_budget);
1488: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1489: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BUDGET_ID = '||ACCT_FLEX_ID);
1490: END IF;
1491: --FV_UTILITY.DEBUG_MESG('budget = '||v_budget);
1492:

Line 1489: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BUDGET_ID = '||ACCT_FLEX_ID);

1485:
1486: -- Find flex_value_id
1487: acct_flex_id := get_flex_value_id(v_budget);
1488: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1489: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BUDGET_ID = '||ACCT_FLEX_ID);
1490: END IF;
1491: --FV_UTILITY.DEBUG_MESG('budget = '||v_budget);
1492:
1493: -- sum budget authority accounts (parent and children)

Line 1501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1497: -- Processing the transfers-in account
1498:
1499: -- Find flex_value_id
1500: acct_flex_id := get_flex_value_id(v_transfers_in);
1501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_IN = '||V_TRANSFERS_IN);
1503: END IF;
1504: v_acct_type := 'TRANS_IN';
1505:

Line 1502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_IN = '||V_TRANSFERS_IN);

1498:
1499: -- Find flex_value_id
1500: acct_flex_id := get_flex_value_id(v_transfers_in);
1501: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_IN = '||V_TRANSFERS_IN);
1503: END IF;
1504: v_acct_type := 'TRANS_IN';
1505:
1506: -- sum transfers_in accounts (parent and children)

Line 1514: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1510: -- Processing the transfers-out account
1511:
1512: -- Find flex_value_id
1513: acct_flex_id := get_flex_value_id(v_transfers_out);
1514: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_OUT = '||V_TRANSFERS_OUT);
1516: END IF;
1517: v_acct_type := 'TRANS_OUT';
1518:

Line 1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_OUT = '||V_TRANSFERS_OUT);

1511:
1512: -- Find flex_value_id
1513: acct_flex_id := get_flex_value_id(v_transfers_out);
1514: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSFERS_OUT = '||V_TRANSFERS_OUT);
1516: END IF;
1517: v_acct_type := 'TRANS_OUT';
1518:
1519: -- sum transfers_out accounts (parent and children)

Line 1528: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1524: -- Processing the commitment account
1525:
1526: -- Find flex_value_id
1527: acct_flex_id := get_flex_value_id(v_commitment);
1528: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COMMIT = '||V_COMMITMENT);
1530: END IF;
1531: v_acct_type := 'UNLIQ_COMM';
1532:

Line 1529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COMMIT = '||V_COMMITMENT);

1525:
1526: -- Find flex_value_id
1527: acct_flex_id := get_flex_value_id(v_commitment);
1528: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COMMIT = '||V_COMMITMENT);
1530: END IF;
1531: v_acct_type := 'UNLIQ_COMM';
1532:
1533: -- sum commitment accounts (parent and children)

Line 1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1538: -- Processing the obligation account
1539:
1540: -- Find flex_value_id
1541: acct_flex_id := get_flex_value_id(v_obligation);
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'OBL = '||V_OBLIGATION);
1544: END IF;
1545: v_acct_type := 'UNLIQ_OBLIG';
1546:

Line 1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'OBL = '||V_OBLIGATION);

1539:
1540: -- Find flex_value_id
1541: acct_flex_id := get_flex_value_id(v_obligation);
1542: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'OBL = '||V_OBLIGATION);
1544: END IF;
1545: v_acct_type := 'UNLIQ_OBLIG';
1546:
1547: -- sum obligation accounts (parent and children)

Line 1556: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1552: -- Processing the expenditure account
1553:
1554: -- Find flex_value_id
1555: acct_flex_id := get_flex_value_id(v_expenditure);
1556: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'EXP = '||V_EXPENDITURE);
1558: END IF;
1559: v_acct_type := 'EXPEN_AMT';
1560:

Line 1557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'EXP = '||V_EXPENDITURE);

1553:
1554: -- Find flex_value_id
1555: acct_flex_id := get_flex_value_id(v_expenditure);
1556: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'EXP = '||V_EXPENDITURE);
1558: END IF;
1559: v_acct_type := 'EXPEN_AMT';
1560:
1561: -- sum expenditure accounts (parent and children)

Line 1581: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1577: when others then
1578: IF c_treasury_fund_values%ISOPEN THEN
1579: close c_treasury_fund_values;
1580: END IF;
1581: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ERROR = '||SQLERRM);
1583: END IF;
1584: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS.'||v_statement||'.'||sqlerrm;
1585: fnd_message.set_name('FV','FV_FAI_GENERAL');

Line 1582: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ERROR = '||SQLERRM);

1578: IF c_treasury_fund_values%ISOPEN THEN
1579: close c_treasury_fund_values;
1580: END IF;
1581: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'ERROR = '||SQLERRM);
1583: END IF;
1584: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS.'||v_statement||'.'||sqlerrm;
1585: fnd_message.set_name('FV','FV_FAI_GENERAL');
1586: fnd_message.set_token('MSG',err_message);

Line 1587: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1583: END IF;
1584: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS.'||v_statement||'.'||sqlerrm;
1585: fnd_message.set_name('FV','FV_FAI_GENERAL');
1586: fnd_message.set_token('MSG',err_message);
1587: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1588: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);
1589: END IF;
1590: -- app_exception.raise_exception;
1591:

Line 1588: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);

1584: err_message := 'FV_FUNDS_AVAILABLE_PKG.CALC_FUNDS.'||v_statement||'.'||sqlerrm;
1585: fnd_message.set_name('FV','FV_FAI_GENERAL');
1586: fnd_message.set_token('MSG',err_message);
1587: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1588: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module_name);
1589: END IF;
1590: -- app_exception.raise_exception;
1591:
1592: END calc_funds;