DBA Data[Home] [Help]

APPS.PA_FP_ELEMENTS_PUB dependencies on FND_PROFILE

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

12: default task elements based on the automatic resource selection parameter and resource planning
13: level for automatic resource selection. Currently only the defaul task elements are created based
14: on the input planning level and resource list id.
15: ==================================================================================================*/
16: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
17:
18: PROCEDURE Refresh_FP_Elements (
19: p_proj_fp_options_id IN NUMBER
20: ,p_cost_planning_level IN VARCHAR2

Line 51: fnd_profile.get('pa_debug_MODE',l_debug_mode);

47: FND_MSG_PUB.initialize;
48: IF P_PA_DEBUG_MODE = 'Y' THEN
49: pa_debug.init_err_stack('PA_FP_ELEMENTS_PUB.Refresh_FP_Elements');
50: END IF;
51: fnd_profile.get('pa_debug_MODE',l_debug_mode);
52: l_debug_mode := NVL(l_debug_mode, 'Y');
53: IF P_PA_DEBUG_MODE = 'Y' THEN
54: pa_debug.set_process('Refresh_FP_Elements: ' || 'PLSQL','LOG',l_debug_mode);
55: END IF;

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

262: FND_MSG_PUB.initialize;
263: IF P_PA_DEBUG_MODE = 'Y' THEN
264: pa_debug.init_err_stack('PA_FP_ELEMENTS_PUB.Copy_Elements');
265: END IF;
266: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
267: l_debug_mode := NVL(l_debug_mode, 'Y');
268: IF P_PA_DEBUG_MODE = 'Y' THEN
269: pa_debug.set_process('Copy_Elements: ' || 'PLSQL','LOG',l_debug_mode);
270: END IF;

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

1015:
1016: BEGIN
1017:
1018: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Insert_Default');
1019: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1020: l_debug_mode := NVL(l_debug_mode, 'Y');
1021: IF P_PA_DEBUG_MODE = 'Y' THEN
1022: pa_debug.set_process('Insert_Default: ' || 'PLSQL','LOG',l_debug_mode);
1023: END IF;

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

1480:
1481: BEGIN
1482:
1483: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Delete_Elements');
1484: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1485: l_debug_mode := NVL(l_debug_mode, 'Y');
1486: IF P_PA_DEBUG_MODE = 'Y' THEN
1487: pa_debug.set_process('Delete_Elements: ' || 'PLSQL','LOG',l_debug_mode);
1488: END IF;

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

1599:
1600: BEGIN
1601:
1602: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Delete_Element');
1603: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1604: l_debug_mode := NVL(l_debug_mode, 'Y');
1605: IF P_PA_DEBUG_MODE = 'Y' THEN
1606: pa_debug.set_process('Delete_Element: ' || 'PLSQL','LOG',l_debug_mode);
1607: END IF;

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

1853: -- Set the error stack.
1854: pa_debug.set_err_stack('PA_FP_ELELEMNTS_PUB.Insert_Bulk_Rows');
1855:
1856: -- Get the Debug mode into local variable and set it to 'Y' if its NULL
1857: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1858: l_debug_mode := NVL(l_debug_mode, 'Y');
1859:
1860: -- Initialize the return status to success
1861: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1974: -- Set the error stack.
1975: pa_debug.set_err_stack('PA_FP_ELELEMNTS_PUB.Insert_Bulk_Rows_Res');
1976:
1977: -- Get the Debug mode into local variable and set it to 'Y' if its NULL
1978: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1979: l_debug_mode := NVL(l_debug_mode, 'Y');
1980:
1981: -- Initialize the return status to success
1982: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2181:
2182: x_msg_count := 0;
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Create_Enterable_Resources');
2185: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2186: l_debug_mode := NVL(l_debug_mode, 'Y');
2187: IF P_PA_DEBUG_MODE = 'Y' THEN
2188: pa_debug.set_process('create_enterable_resources: ' || 'PLSQL','LOG',l_debug_mode);
2189: END IF;

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

2985: x_msg_count := 0;
2986: x_return_status := FND_API.G_RET_STS_SUCCESS;
2987:
2988: pa_debug.set_err_stack('Create_elements_from_version');
2989: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2990: l_debug_mode := NVL(l_debug_mode, 'Y');
2991: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2992:
2993: IF p_pa_debug_mode = 'Y' THEN

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

3387:
3388: BEGIN
3389:
3390: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.refresh_res_list_changes');
3391: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3392: l_debug_mode := NVL(l_debug_mode, 'Y');
3393: IF P_PA_DEBUG_MODE = 'Y' THEN
3394: pa_debug.set_process('refresh_res_list_changes: ' || 'PLSQL','LOG',l_debug_mode);
3395: END IF;

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

3850:
3851: x_msg_count := 0;
3852: x_return_status := FND_API.G_RET_STS_SUCCESS;
3853: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.CREATE_ASSGMT_FROM_ROLLUPTMP');
3854: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3855: l_debug_mode := NVL(l_debug_mode, 'Y');
3856: IF P_PA_DEBUG_MODE = 'Y' THEN
3857: pa_debug.set_process('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || 'PLSQL','LOG',l_debug_mode);
3858: END IF;

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

4207:
4208: x_msg_count := 0;
4209: x_return_status := FND_API.G_RET_STS_SUCCESS;
4210: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Create_CI_Resource_Assignments');
4211: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4212: l_debug_mode := NVL(l_debug_mode, 'Y');
4213: IF P_PA_DEBUG_MODE = 'Y' THEN
4214: pa_debug.set_process('Create_CI_Resource_Assignments: ' || 'PLSQL','LOG',l_debug_mode);
4215: END IF;

Line 5055: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5051: BEGIN
5052:
5053: x_msg_count := 0;
5054: x_return_status := FND_API.G_RET_STS_SUCCESS;
5055: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5056:
5057: pa_debug.set_curr_function( p_function => 'delete_task_elements',
5058: p_debug_mode => l_debug_mode );
5059:

Line 5221: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5217:
5218: BEGIN
5219: x_msg_count := 0;
5220: x_return_status := FND_API.G_RET_STS_SUCCESS;
5221: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5222:
5223: IF l_debug_mode = 'Y' THEN
5224: pa_debug.set_curr_function( p_function => 'Get_Task_Element_Attributes',
5225: p_debug_mode => l_debug_mode );

Line 5633: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

5629:
5630: BEGIN
5631: x_msg_count := 0;
5632: x_return_status := FND_API.G_RET_STS_SUCCESS;
5633: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5634:
5635:
5636: -- Check for business rules violations
5637:

Line 6073: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

6069: BEGIN
6070:
6071: x_msg_count := 0;
6072: x_return_status := FND_API.G_RET_STS_SUCCESS;
6073: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6074:
6075:
6076: -- Check for business rules violations
6077:

Line 6561: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

6557: BEGIN
6558:
6559: x_msg_count := 0;
6560: x_return_status := FND_API.G_RET_STS_SUCCESS;
6561: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6562:
6563: IF l_debug_mode = 'Y' THEN
6564: pa_debug.set_curr_function( p_function => 'maintain_plannable_tasks',
6565: p_debug_mode => l_debug_mode );