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.3 2009/06/25 11:02:56 rthumma 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.3 2009/06/25 11:02:56 rthumma 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 2063: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');

2059: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2060:
2061: BEGIN
2062: IF p_pa_debug_mode = 'Y' THEN
2063: pa_debug.init_err_stack('PA_FIN_PLAN_UTILS2.Get_Agreement_Details');
2064: END IF;
2065: fnd_profile.get('PA_DEBUG_MODE',l_debug_flag);
2066: l_debug_flag := NVL(l_debug_flag, 'N');
2067:

Line 2157: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

2153: WHEN OTHERS THEN
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: x_agr_curr_code := NULL;
2156: fnd_msg_pub.add_exc_msg
2157: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2158: ,p_procedure_name => 'Get_Agreement_Details' );
2159: print_msg(l_debug_flag,l_proc_name,'Failed in Get_Agreement_Details substr(SQLERRM,1,240) => '|| substr(SQLERRM,1,240));
2160: IF p_pa_debug_mode = 'Y' THEN
2161: pa_debug.reset_err_stack;

Line 2257: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'

2253:
2254: EXCEPTION
2255: WHEN OTHERS THEN
2256: fnd_msg_pub.add_exc_msg
2257: ( p_pkg_name => 'PA_FIN_PLAN_UTILS2'
2258: ,p_procedure_name => 'IsFpTaskBillable');
2259: print_msg('Y','IsFpTaskBillable','Failed in IsFpTaskBillable => '|| substr(SQLERRM,1,240));
2260: RAISE;
2261:

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

3644: l_msg_data VARCHAR2(2000);
3645: l_error_msg_code VARCHAR2(30);
3646: l_msg_index_out NUMBER;
3647: l_debug_mode VARCHAR2(30);
3648: g_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_UTILS2';
3649: g_plsql_max_array_size NUMBER := 200 ;
3650:
3651: TYPE l_budget_line_id_tbl_typ IS TABLE OF
3652: pa_budget_lines.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 3780: END PA_FIN_PLAN_UTILS2 ;

3776: RAISE ;--FND_API.G_EXC_UNEXPECTED_ERROR;
3777:
3778: END POPULATE_BL_MAP_TMP ;
3779:
3780: END PA_FIN_PLAN_UTILS2 ;