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.27.12020000.3 2013/03/06 09:30:42 admarath ship $
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 32: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_UTILS','LOG: '||pa_debug.g_err_stage,3);

28:
29: IF p_message is NOT NULL then
30: pa_debug.g_err_stage := substr(p_message,1,250);
31: pa_debug.write_file('LOG: '||pa_debug.g_err_stage);
32: pa_debug.write('pa.plsql.PA_FUNDS_CONTROL_UTILS','LOG: '||pa_debug.g_err_stage,3);
33: END IF;
34: END IF;
35:
36: END LOG_MESSAGE;

Line 38: --This Api Initialize the pa_funds_control_utils package

34: END IF;
35:
36: END LOG_MESSAGE;
37:
38: --This Api Initialize the pa_funds_control_utils package
39: -- global variables ( this is used as a one level cache)
40: PROCEDURE init_util_variables IS
41:
42: BEGIN

Line 484: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period

480: (p_start_date IN date
481: ,p_end_date IN date
482: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type
483: ,x_tab_count IN OUT NOCOPY Number
484: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period
485: ,x_return_status IN OUT NOCOPY varchar2
486: ) is
487:
488:

Line 510: l_tab_rec pa_funds_control_utils.tab_closed_period;

506: AND closing_status in ('C','O','P');
507:
508: l_count_rows NUMBER := 0;
509: l_tab_count NUMBER:=0;
510: l_tab_rec pa_funds_control_utils.tab_closed_period;
511:
512:
513: BEGIN
514: -- Initialize the error statck

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

902: BEGIN
903: x_return_status := fnd_api.g_ret_sts_success;
904:
905: IF P_DEBUG_MODE = 'Y' THEN
906: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'Inside Get Budget CCID');
907: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:Inside Get Budget CCID');
908: 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);
909: END IF;
910:

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

923: and pra.resource_assignment_id = pbl.resource_assignment_id
924: and trunc(pbl.start_date) = trunc(p_start_date);
925:
926: IF P_DEBUG_MODE = 'Y' THEN
927: pa_funds_control_utils.print_message('Get_Budget_CCID: ' || 'End of Get Budget CCID');
928: pa_fck_util.debug_msg('Get_Budget_CCID: ' || 'PB:End of Get Budget CCID = ' || x_budget_ccid||' Line id:'||x_budget_line_id);
929: END IF;
930:
931: EXCEPTION

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

946: BEGIN
947: x_return_status := fnd_api.g_ret_sts_success;
948:
949: IF P_DEBUG_MODE = 'Y' THEN
950: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'Inside Get Time Phased Type Code');
951: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:Inside Get Time Phased Type Code');
952: END IF;
953:
954: select time_phased_type_code

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

958: where a.budget_entry_method_code = b.budget_entry_method_code
959: and b.budget_version_id = p_budget_version_id;
960:
961: IF P_DEBUG_MODE = 'Y' THEN
962: pa_funds_control_utils.print_message('Get_Time_Phased_Type_Code: ' || 'End of Get Time Phased Type Code');
963: pa_fck_util.debug_msg('Get_Time_Phased_Type_Code: ' || 'PB:End of Get Time Phased Type Code');
964: END IF;
965:
966: EXCEPTION

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

986: BEGIN
987: x_return_status := fnd_api.g_ret_sts_success;
988:
989: IF P_DEBUG_MODE = 'Y' THEN
990: pa_funds_control_utils.print_message('Inside Get_Baselined_Budget_Version');
991: pa_fck_util.debug_msg('PB:Inside Get_Baselined_Budget_Version');
992: END IF;
993:
994: select pbv.budget_version_id, pbv.resource_list_id, pbm.entry_level_code

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

1012: --and pbt.budget_amount_code = 'C'
1013: and pbv.budget_entry_method_code = pbm.budget_entry_method_code;
1014:
1015: IF P_DEBUG_MODE = 'Y' THEN
1016: pa_funds_control_utils.print_message('End of Get_Baselined_Budget_Version');
1017: pa_fck_util.debug_msg('Get_Baselined_Budget_Version: ' || 'PB:Output = '|| x_base_version_id || ':' || x_res_list_id || ':'|| x_entry_level_code);
1018: pa_fck_util.debug_msg('PB:End of Get_Baselined_Budget_Version');
1019: END IF;
1020:

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

1041: p_budget_ccid in number) RETURN NUMBER IS
1042: x_avail_balance number;
1043: BEGIN
1044: IF P_DEBUG_MODE = 'Y' THEN
1045: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'Inside Get Acct Line Balance');
1046: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:Inside Get Acct Line Balance');
1047: END IF;
1048: /*
1049: --select bal.Curr_Ver_Available_Amount

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

1070: AND start_date between trunc(p_start_date) and trunc(p_end_date)
1071: AND end_date between trunc(p_start_date) and trunc(p_end_date);
1072:
1073: IF P_DEBUG_MODE = 'Y' THEN
1074: pa_funds_control_utils.print_message('Get_Acct_Line_Balance: ' || 'End of Get Acct Line Balance');
1075: pa_fck_util.debug_msg('Get_Acct_Line_Balance: ' || 'PB:End of Get Acct Line Balance');
1076: END IF;
1077: return nvl(x_avail_balance,0);
1078: EXCEPTION

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

1088: l_count NUMBER;
1089: BEGIN
1090:
1091: IF P_DEBUG_MODE = 'Y' THEN
1092: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'Inside Is budget baselined before');
1093: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:Inside Is budget baselined before');
1094: END IF;
1095:
1096: select 1 into l_count

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

1108: x_baselined := 'N';
1109: end if;
1110:
1111: IF P_DEBUG_MODE = 'Y' THEN
1112: pa_funds_control_utils.print_message('Is_Budget_Baselined_Before: ' || 'After Is budget baselined before = ' || x_baselined);
1113: pa_fck_util.debug_msg('Is_Budget_Baselined_Before: ' || 'PB:After Is budget baselined before = ' || x_baselined);
1114: END IF;
1115: return x_baselined;
1116: EXCEPTION

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

2165: -- If exists we need to have additional logic to stamp latest budget version id and
2166: -- budget_line_id on CDL and bc commitments as baseline process donot pick these
2167: -- transactions for fundschecking
2168:
2169: l_closed_prd_exists := PA_FUNDS_CONTROL_UTILS.CLOSED_PERIODS_EXISTS_IN_BUDG(p_bud_ver_id);
2170:
2171: IF P_DEBUG_MODE = 'Y' THEN
2172: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start l_closed_prd_exists ='||l_closed_prd_exists );
2173: pa_fck_util.debug_msg('Update_bvid_blid_on_cdl_bccom: Start p_bud_ver_id ='||p_bud_ver_id );

Line 2891: END PA_FUNDS_CONTROL_UTILS ;

2887: END get_corrective_action;
2888:
2889: -- -----------------------------------------------------------------------------------------+
2890:
2891: END PA_FUNDS_CONTROL_UTILS ;