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.PA_FUNDS_CONTROL_UTILS dependencies on PA_FUNDS_CONTROL_UTILS

Line 1: package body PA_FUNDS_CONTROL_UTILS as

1: package body PA_FUNDS_CONTROL_UTILS as
2: -- $Header: PAFCUTLB.pls 120.20.12000000.2 2007/04/20 08:51:05 rshaik ship $
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 18: --This Api Initialize the pa_funds_control_utils package

14: g_txn_exists_for_bvid Varchar2(1);
15: -- R12 complete
16:
17:
18: --This Api Initialize the pa_funds_control_utils package
19: -- global variables ( this is used as a one level cache)
20: PROCEDURE init_util_variables IS
21:
22: BEGIN

Line 411: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period

407: (p_start_date IN date
408: ,p_end_date IN date
409: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type
410: ,x_tab_count IN OUT NOCOPY Number
411: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period
412: ,x_return_status IN OUT NOCOPY varchar2
413: ) is
414:
415:

Line 437: l_tab_rec pa_funds_control_utils.tab_closed_period;

433: AND closing_status in ('C','O','P');
434:
435: l_count_rows NUMBER := 0;
436: l_tab_count NUMBER:=0;
437: l_tab_rec pa_funds_control_utils.tab_closed_period;
438:
439:
440: BEGIN
441: -- Initialize the error statck

Line 755: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'Inside Get Budget CCID');

751: BEGIN
752: x_return_status := fnd_api.g_ret_sts_success;
753:
754: IF P_DEBUG_MODE = 'Y' THEN
755: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'Inside Get Budget CCID');
756: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:Inside Get Budget CCID');
757: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:P:T:TT:R:S:B:E = ' || p_project_id || ':' || p_task_id || ':' || p_top_task_id|| ':' || p_res_list_mem_id ||':'|| p_start_date || ':' || p_budget_version_id ||':'|| p_entry_level_code);
758: END IF;
759:

Line 776: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'End of Get Budget CCID');

772: and pra.resource_assignment_id = pbl.resource_assignment_id
773: and trunc(pbl.start_date) = trunc(p_start_date);
774:
775: IF P_DEBUG_MODE = 'Y' THEN
776: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'End of Get Budget CCID');
777: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:End of Get Budget CCID = ' || x_budget_ccid||' Line id:'||x_budget_line_id);
778: END IF;
779:
780: EXCEPTION

Line 799: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'Inside Get Time Phased Type Code');

795: BEGIN
796: x_return_status := fnd_api.g_ret_sts_success;
797:
798: IF P_DEBUG_MODE = 'Y' THEN
799: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'Inside Get Time Phased Type Code');
800: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:Inside Get Time Phased Type Code');
801: END IF;
802:
803: select time_phased_type_code

Line 811: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'End of Get Time Phased Type Code');

807: where a.budget_entry_method_code = b.budget_entry_method_code
808: and b.budget_version_id = p_budget_version_id;
809:
810: IF P_DEBUG_MODE = 'Y' THEN
811: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'End of Get Time Phased Type Code');
812: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:End of Get Time Phased Type Code');
813: END IF;
814:
815: EXCEPTION

Line 839: pa_funds_control_utils.print_message('Inside Get_Baselined_Budget_Version');

835: BEGIN
836: x_return_status := fnd_api.g_ret_sts_success;
837:
838: IF P_DEBUG_MODE = 'Y' THEN
839: pa_funds_control_utils.print_message('Inside Get_Baselined_Budget_Version');
840: pa_fck_util.debug_msg('PB:Inside Get_Baselined_Budget_Version');
841: END IF;
842:
843: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code

Line 865: pa_funds_control_utils.print_message('End of Get_Baselined_Budget_Version');

861: --and pbt.budget_amount_code = 'C'
862: and pbv.budget_entry_method_code = pbm.budget_entry_method_code;
863:
864: IF P_DEBUG_MODE = 'Y' THEN
865: pa_funds_control_utils.print_message('End of Get_Baselined_Budget_Version');
866: pa_fck_util.debug_msg('Get_Baselined_Budget_Version: ' || 'PB:Output = '|| x_base_version_id || ':' || x_res_list_id || ':'|| x_entry_level_code);
867: pa_fck_util.debug_msg('PB:End of Get_Baselined_Budget_Version');
868: END IF;
869:

Line 894: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'Inside Get Acct Line Balance');

890: p_budget_ccid in number) RETURN NUMBER IS
891: x_avail_balance number;
892: BEGIN
893: IF P_DEBUG_MODE = 'Y' THEN
894: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'Inside Get Acct Line Balance');
895: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:Inside Get Acct Line Balance');
896: END IF;
897: /*
898: --select bal.Curr_Ver_Available_Amount

Line 923: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'End of Get Acct Line Balance');

919: AND start_date between trunc(p_start_date) and trunc(p_end_date)
920: AND end_date between trunc(p_start_date) and trunc(p_end_date);
921:
922: IF P_DEBUG_MODE = 'Y' THEN
923: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'End of Get Acct Line Balance');
924: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:End of Get Acct Line Balance');
925: END IF;
926: return nvl(x_avail_balance,0);
927: EXCEPTION

Line 941: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'Inside Is budget baselined before');

937: l_count NUMBER;
938: BEGIN
939:
940: IF P_DEBUG_MODE = 'Y' THEN
941: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'Inside Is budget baselined before');
942: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');
943: END IF;
944:
945: select 1 into l_count

Line 961: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'After Is budget baselined before = ' || x_baselined);

957: x_baselined := 'N';
958: end if;
959:
960: IF P_DEBUG_MODE = 'Y' THEN
961: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'After Is budget baselined before = ' || x_baselined);
962: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:After Is budget baselined before = ' || x_baselined);
963: END IF;
964: return x_baselined;
965: EXCEPTION

Line 2018: l_closed_prd_exists := PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_bud_ver_id);

2014: -- If exists we need to have additional logic to stamp latest budget version id and
2015: -- budget_line_id on CDL and bc commitments as baseline process donot pick these
2016: -- transactions for fundschecking
2017:
2018: l_closed_prd_exists := PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_bud_ver_id);
2019:
2020: IF P_DEBUG_MODE = 'Y' THEN
2021: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start l_closed_prd_exists ='||l_closed_prd_exists );
2022: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );

Line 2555: END PA_FUNDS_CONTROL_UTILS ;

2551:
2552:
2553: -- -----------------------------------------------------------------------------------------+
2554:
2555: END PA_FUNDS_CONTROL_UTILS ;