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_PROJ_FP_OPTIONS_PUB dependencies on FND_PROFILE

Line 5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: package body PA_PROJ_FP_OPTIONS_PUB as
2: /* $Header: PAFPOPPB.pls 120.10 2007/11/26 15:50:53 rthumma ship $ */
3:
4: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6:
7: /*==================================================================================================
8: CREATE_FP_OPTION: This procedure inserts or updates records in 3 table depending
9: on the Source and the Target FP Option Details passed to this procedure.

Line 121: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance

117: l_prj_end_date VARCHAR2(100);
118:
119: --Added for webAdi development
120: l_source_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
121: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance
122: /* Bug 6413612 : Added substr to fetch only 1 character of profile value */
123: l_webadi_profile VARCHAR(1) := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'), 1, 1));
124: -- end Bug 5941436:
125: -- FP M Dev Effort new cursor defined to fetch plan type information

Line 123: l_webadi_profile VARCHAR(1) := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'), 1, 1));

119: --Added for webAdi development
120: l_source_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
121: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance
122: /* Bug 6413612 : Added substr to fetch only 1 character of profile value */
123: l_webadi_profile VARCHAR(1) := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'), 1, 1));
124: -- end Bug 5941436:
125: -- FP M Dev Effort new cursor defined to fetch plan type information
126:
127: CURSOR plan_type_info_cur (c_fin_plan_type_id NUMBER) IS

Line 159: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

155: BEGIN
156: FND_MSG_PUB.initialize;
157: IF P_PA_DEBUG_MODE = 'Y' THEN
158: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option');
159: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
160: l_debug_mode := NVL(l_debug_mode, 'Y');
161: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
162: END IF;
163:

Line 1593: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1589:
1590: BEGIN
1591: IF P_PA_DEBUG_MODE = 'Y' THEN
1592: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');
1593: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1594: l_debug_mode := NVL(l_debug_mode, 'Y');
1595: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1596: END IF;
1597:

Line 2472: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2468:
2469: BEGIN
2470: IF P_PA_DEBUG_MODE = 'Y' THEN
2471: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID');
2472: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2473: l_debug_mode := NVL(l_debug_mode, 'Y');
2474: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2475: END IF;
2476:

Line 2568: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2564: BEGIN
2565:
2566: IF P_PA_DEBUG_MODE = 'Y' THEN
2567: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID');
2568: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2569: l_debug_mode := NVL(l_debug_mode, 'Y');
2570: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2571: END IF;
2572:

Line 2783: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2779: BEGIN
2780:
2781: IF P_PA_DEBUG_MODE = 'Y' THEN
2782: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options');
2783: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2784: l_debug_mode := NVL(l_debug_mode, 'Y');
2785: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2786: END IF;
2787: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2788: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance

2784: l_debug_mode := NVL(l_debug_mode, 'Y');
2785: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2786: END IF;
2787: l_return_status := FND_API.G_RET_STS_SUCCESS;
2788: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance
2789: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2790: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2791: -- end: Bug 5941436
2792: IF NVL(l_webadi_profile , 'N') <> 'Y' THEN

Line 2790: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));

2786: END IF;
2787: l_return_status := FND_API.G_RET_STS_SUCCESS;
2788: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance
2789: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2790: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2791: -- end: Bug 5941436
2792: IF NVL(l_webadi_profile , 'N') <> 'Y' THEN
2793: l_non_periodic_budget_layout := NULL;
2794: l_non_periodic_forecast_layout := NULL;

Line 3697: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3693:
3694: FND_MSG_PUB.initialize;
3695: IF P_PA_DEBUG_MODE = 'Y' THEN
3696: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.SYNCHRONIZE_BUDGET_VERSION');
3697: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3698: l_debug_mode := NVL(l_debug_mode, 'Y');
3699: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3700: END IF;
3701: x_msg_count := 0;

Line 3994: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3990: BEGIN
3991:
3992: IF P_PA_DEBUG_MODE = 'Y' THEN
3993: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id');
3994: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3995: l_debug_mode := NVL(l_debug_mode, 'Y');
3996: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3997: END IF;
3998:

Line 4359: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4355: l_all_layout_type_code VARCHAR2(30);
4356: l_debug_mode VARCHAR2(30);
4357: l_stage NUMBER := 100;
4358: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4359: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4360: l_msg_count NUMBER :=0;
4361: l_msg_data VARCHAR2(2000);
4362: l_data VARCHAR2(2000);
4363: l_msg_index_out NUMBER;

Line 4387: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4383: p_debug_mode => l_debug_mode );
4384:
4385: IF P_PA_DEBUG_MODE = 'Y' THEN
4386: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_amt_types');
4387: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4388: l_debug_mode := NVL(l_debug_mode, 'Y');
4389: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4390: END IF;
4391:

Line 4812: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4808: ) IS
4809:
4810: l_stage NUMBER := 100;
4811: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub.copy_amt_types';
4812: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4813: --Start of variables used for debugging
4814: l_return_status VARCHAR2(1);
4815: l_msg_count NUMBER := 0;
4816: l_msg_data VARCHAR2(2000);

Line 4831: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4827:
4828: x_msg_count := 0;
4829: x_return_status := FND_API.G_RET_STS_SUCCESS;
4830:
4831: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4832: l_debug_mode := NVL(l_debug_mode, 'Y');
4833:
4834: IF l_debug_mode = 'Y' THEN
4835: pa_debug.g_err_stage:='Validating input parameters';

Line 4944: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4940: ) IS
4941:
4942: l_stage NUMBER := 100;
4943: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4944: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4945: --Start of variables used for debugging
4946: l_return_status VARCHAR2(1);
4947: l_msg_count NUMBER := 0;
4948: l_msg_data VARCHAR2(2000);

Line 4965: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4961:
4962: x_msg_count := 0;
4963: x_return_status := FND_API.G_RET_STS_SUCCESS;
4964:
4965: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4966: l_debug_mode := NVL(l_debug_mode, 'Y');
4967:
4968: IF l_debug_mode = 'Y' THEN
4969: pa_debug.g_err_stage:='Validating input parameters';