DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_FIN_PLAN_UTILS2

Line 1: PACKAGE BODY PA_FIN_PLAN_UTILS2 AS

1: PACKAGE BODY PA_FIN_PLAN_UTILS2 AS
2: /* $Header: PAFPUT2B.pls 120.8.12010000.2 2008/11/28 12:16:02 vgovvala ship $ */
3:
4: G_FpTaskBillable_Tab PA_FIN_PLAN_UTILS2.BillableTab;
5:

Line 4: G_FpTaskBillable_Tab PA_FIN_PLAN_UTILS2.BillableTab;

1: PACKAGE BODY PA_FIN_PLAN_UTILS2 AS
2: /* $Header: PAFPUT2B.pls 120.8.12010000.2 2008/11/28 12:16:02 vgovvala ship $ */
3:
4: G_FpTaskBillable_Tab PA_FIN_PLAN_UTILS2.BillableTab;
5:
6: g_debug_flag Varchar2(1);
7: /** Forward declaration */
8: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 47: l_module varchar2(1000) := 'PA_FIN_PLAN_UTILS2.'||p_proc_name;

43: PROCEDURE print_msg(p_debug_flag varchar2
44: ,p_proc_name varchar2
45: ,p_msg varchar2 ) IS
46:
47: l_module varchar2(1000) := 'PA_FIN_PLAN_UTILS2.'||p_proc_name;
48:
49: BEGIN
50: --calc_log(p_msg);
51: If p_debug_flag = 'Y' Then

Line 124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');

120:
121: BEGIN
122: --- Initialize the error statck
123: IF p_pa_debug_mode = 'Y' THEN
124: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_UOM_RateBasedFlag');
125: END IF;
126: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
127: l_debug_flag := NVL(l_debug_flag, 'N');
128:

Line 345: pa_fin_plan_utils2.g_bdgt_start_date := p_start_date;

341: ,l_other_rejection_flag ;
342: CLOSE cur_bdgtRejFlags;
343: Else
344: /* set the start and end dates for the global variables to return to the function */
345: pa_fin_plan_utils2.g_bdgt_start_date := p_start_date;
346: pa_fin_plan_utils2.g_bdgt_end_date := p_end_date;
347:
348: OPEN cur_bdgtPeriodRejFlags;
349: FETCH cur_bdgtPeriodRejFlags INTO

Line 346: pa_fin_plan_utils2.g_bdgt_end_date := p_end_date;

342: CLOSE cur_bdgtRejFlags;
343: Else
344: /* set the start and end dates for the global variables to return to the function */
345: pa_fin_plan_utils2.g_bdgt_start_date := p_start_date;
346: pa_fin_plan_utils2.g_bdgt_end_date := p_end_date;
347:
348: OPEN cur_bdgtPeriodRejFlags;
349: FETCH cur_bdgtPeriodRejFlags INTO
350: l_cost_rejection_flag

Line 663: PA_FIN_PLAN_UTILS2.Get_Default_FP_Reslist

659: ,x_res_list_id OUT NOCOPY NUMBER
660: ,x_res_list_name OUT NOCOPY Varchar2) IS
661:
662: BEGIN
663: PA_FIN_PLAN_UTILS2.Get_Default_FP_Reslist
664: (p_project_id => p_project_id
665: ,p_fin_plan_type_id => NULL
666: ,x_res_list_id => x_res_list_id
667: ,x_res_list_name => x_res_list_name

Line 1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');

1102: END getMsgtext ;
1103: BEGIN
1104: --- Initialize the error statck
1105: IF p_pa_debug_mode = 'Y' THEN
1106: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.validateAndUpdateBdgtLine');
1107: END IF;
1108: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1109: g_debug_flag := NVL(g_debug_flag, 'N');
1110:

Line 1538: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

1534: x_msg_data := SQLCODE||SQLERRM;
1535: x_msg_count := 1;
1536: print_msg('Y',l_proc_name,l_stage||SQLCODE||SQLERRM);
1537: FND_MSG_PUB.add_exc_msg
1538: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1539: ,p_procedure_name => 'validateAndUpdateBdgtLine');
1540: IF p_pa_debug_mode = 'Y' THEN
1541: PA_DEBUG.reset_err_stack;
1542: END IF;

Line 1554: PA_FIN_PLAN_UTILS2.period_mask_display := p_period_Mask;

1550: */
1551: PROCEDURE setMaskName(p_period_Mask IN Varchar2) IS
1552:
1553: BEGIN
1554: PA_FIN_PLAN_UTILS2.period_mask_display := p_period_Mask;
1555:
1556: END setMaskName;
1557:
1558: /* This API returns the period mask to be displayed on the edit budgetline details page

Line 1564: RETURN PA_FIN_PLAN_UTILS2.period_mask_display;

1560: */
1561: FUNCTION getMaskName Return Varchar2 IS
1562:
1563: BEGIN
1564: RETURN PA_FIN_PLAN_UTILS2.period_mask_display;
1565:
1566: END getMaskName;
1567:
1568: PROCEDURE checkUserRateAllowed

Line 1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');

1797:
1798: BEGIN
1799: --- Initialize the error statck
1800: IF p_pa_debug_mode = 'Y' THEN
1801: PA_DEBUG.init_err_stack ('PA_FIN_PLAN_UTILS2.Get_WbsBdgtLineRejns');
1802: END IF;
1803: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
1804: l_debug_flag := NVL(l_debug_flag, 'N');
1805:

Line 1889: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

1885: x_return_status := 'U';
1886: l_stage := 'Unexpected error Occured ['||SQLCODE||SQLERRM||']';
1887: print_msg('Y',l_proc_name,l_stage);
1888: FND_MSG_PUB.add_exc_msg
1889: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
1890: ,p_procedure_name => 'Get_WbsBdgtLineRejns');
1891: IF p_pa_debug_mode = 'Y' THEN
1892: PA_DEBUG.reset_err_stack;
1893: END IF;

Line 2003: PA_FIN_PLAN_UTILS2.Get_Agreement_Details

1999: l_agr_curr_code varchar2(100);
2000: l_return_status varchar2(100);
2001: l_agr_conv_reqd_flag varchar2(100);
2002: BEGIN
2003: PA_FIN_PLAN_UTILS2.Get_Agreement_Details
2004: (p_budget_version_id => p_budget_version_id
2005: ,p_calling_mode => 'FUNCTION_CALL'
2006: ,x_agr_curr_code => l_agr_curr_code
2007: ,x_AGR_CONV_REQD_FLAG => l_agr_conv_reqd_flag

Line 2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');

2055: G_AGR_CURRENCY_CODE varchar2(100);
2056:
2057: BEGIN
2058: IF p_pa_debug_mode = 'Y' THEN
2059: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2060: END IF;
2061: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2062: l_debug_flag := NVL(l_debug_flag, 'N');
2063:

Line 2150: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

2146: WHEN OTHERS THEN
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2148: x_agr_curr_code := NULL;
2149: fnd_msg_pub.add_exc_msg
2150: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2151: ,p_procedure_name => 'Get_Agreement_Details' );
2152: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2153: IF p_pa_debug_mode = 'Y' THEN
2154: pa_debug.reset_err_stack;

Line 2250: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

2246:
2247: EXCEPTION
2248: WHEN OTHERS THEN
2249: fnd_msg_pub.add_exc_msg
2250: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2251: ,p_procedure_name => 'IsFpTaskBillable');
2252: print_msg('Y','IsFpTaskBillable','Failed in IsFpTaskBillable => '|| substr(SQLERRM,1,240));
2253: RAISE;
2254:

Line 3641: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_UTILS2';

3637: l_msg_data VARCHAR2(2000);
3638: l_error_msg_code VARCHAR2(30);
3639: l_msg_index_out NUMBER;
3640: l_debug_mode VARCHAR2(30);
3641: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_UTILS2';
3642: g_plsql_max_array_size NUMBER := 200 ;
3643:
3644: TYPE l_budget_line_id_tbl_typ IS TABLE OF
3645: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 3773: END PA_FIN_PLAN_UTILS2 ;

3769: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3770:
3771: END POPULATE_BL_MAP_TMP ;
3772:
3773: END PA_FIN_PLAN_UTILS2 ;