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.15 2012/01/19 08:16:46 a5sharma 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 1614: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

1610:
1611: BEGIN
1612: IF P_PA_DEBUG_MODE = 'Y' THEN
1613: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');
1614: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1615: l_debug_mode := NVL(l_debug_mode, 'Y');
1616: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1617: END IF;
1618:

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

2513:
2514: BEGIN
2515: IF P_PA_DEBUG_MODE = 'Y' THEN
2516: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID');
2517: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2518: l_debug_mode := NVL(l_debug_mode, 'Y');
2519: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2520: END IF;
2521:

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

2609: BEGIN
2610:
2611: IF P_PA_DEBUG_MODE = 'Y' THEN
2612: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID');
2613: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2614: l_debug_mode := NVL(l_debug_mode, 'Y');
2615: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2616: END IF;
2617:

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

2824: BEGIN
2825:
2826: IF P_PA_DEBUG_MODE = 'Y' THEN
2827: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options');
2828: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2829: l_debug_mode := NVL(l_debug_mode, 'Y');
2830: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2831: END IF;
2832: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2833: -- 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

2829: l_debug_mode := NVL(l_debug_mode, 'Y');
2830: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2831: END IF;
2832: l_return_status := FND_API.G_RET_STS_SUCCESS;
2833: -- 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
2834: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2835: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2836: -- end: Bug 5941436
2837: IF NVL(l_webadi_profile , 'N') <> 'Y' THEN

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

2831: END IF;
2832: l_return_status := FND_API.G_RET_STS_SUCCESS;
2833: -- 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
2834: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2835: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2836: -- end: Bug 5941436
2837: IF NVL(l_webadi_profile , 'N') <> 'Y' THEN
2838: l_non_periodic_budget_layout := NULL;
2839: l_non_periodic_forecast_layout := NULL;

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

3738:
3739: FND_MSG_PUB.initialize;
3740: IF P_PA_DEBUG_MODE = 'Y' THEN
3741: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.SYNCHRONIZE_BUDGET_VERSION');
3742: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3743: l_debug_mode := NVL(l_debug_mode, 'Y');
3744: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3745: END IF;
3746: x_msg_count := 0;

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

4035: BEGIN
4036:
4037: IF P_PA_DEBUG_MODE = 'Y' THEN
4038: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id');
4039: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4040: l_debug_mode := NVL(l_debug_mode, 'Y');
4041: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4042: END IF;
4043:

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

4400: l_all_layout_type_code VARCHAR2(30);
4401: l_debug_mode VARCHAR2(30);
4402: l_stage NUMBER := 100;
4403: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4404: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4405: l_msg_count NUMBER :=0;
4406: l_msg_data VARCHAR2(2000);
4407: l_data VARCHAR2(2000);
4408: l_msg_index_out NUMBER;

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

4428: p_debug_mode => l_debug_mode );
4429:
4430: IF P_PA_DEBUG_MODE = 'Y' THEN
4431: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_amt_types');
4432: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4433: l_debug_mode := NVL(l_debug_mode, 'Y');
4434: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4435: END IF;
4436:

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

4853: ) IS
4854:
4855: l_stage NUMBER := 100;
4856: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub.copy_amt_types';
4857: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4858: --Start of variables used for debugging
4859: l_return_status VARCHAR2(1);
4860: l_msg_count NUMBER := 0;
4861: l_msg_data VARCHAR2(2000);

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

4872:
4873: x_msg_count := 0;
4874: x_return_status := FND_API.G_RET_STS_SUCCESS;
4875:
4876: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4877: l_debug_mode := NVL(l_debug_mode, 'Y');
4878:
4879: IF l_debug_mode = 'Y' THEN
4880: pa_debug.g_err_stage:='Validating input parameters';

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

4985: ) IS
4986:
4987: l_stage NUMBER := 100;
4988: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4989: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4990: --Start of variables used for debugging
4991: l_return_status VARCHAR2(1);
4992: l_msg_count NUMBER := 0;
4993: l_msg_data VARCHAR2(2000);

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

5006:
5007: x_msg_count := 0;
5008: x_return_status := FND_API.G_RET_STS_SUCCESS;
5009:
5010: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5011: l_debug_mode := NVL(l_debug_mode, 'Y');
5012:
5013: IF l_debug_mode = 'Y' THEN
5014: pa_debug.g_err_stage:='Validating input parameters';