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
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
3855:
3856: x_msg_count := 0;
3857: x_return_status := FND_API.G_RET_STS_SUCCESS;
3858: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.CREATE_ASSGMT_FROM_ROLLUPTMP');
3859: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3860: l_debug_mode := NVL(l_debug_mode, 'Y');
3861: IF P_PA_DEBUG_MODE = 'Y' THEN
3862: pa_debug.set_process('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || 'PLSQL','LOG',l_debug_mode);
3863: END IF;
4216:
4217: x_msg_count := 0;
4218: x_return_status := FND_API.G_RET_STS_SUCCESS;
4219: pa_debug.set_err_stack('PA_FP_ELEMENTS_PUB.Create_CI_Resource_Assignments');
4220: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4221: l_debug_mode := NVL(l_debug_mode, 'Y');
4222: IF P_PA_DEBUG_MODE = 'Y' THEN
4223: pa_debug.set_process('Create_CI_Resource_Assignments: ' || 'PLSQL','LOG',l_debug_mode);
4224: END IF;
5060: BEGIN
5061:
5062: x_msg_count := 0;
5063: x_return_status := FND_API.G_RET_STS_SUCCESS;
5064: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5065:
5066: pa_debug.set_curr_function( p_function => 'delete_task_elements',
5067: p_debug_mode => l_debug_mode );
5068:
5226:
5227: BEGIN
5228: x_msg_count := 0;
5229: x_return_status := FND_API.G_RET_STS_SUCCESS;
5230: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5231:
5232: IF l_debug_mode = 'Y' THEN
5233: pa_debug.set_curr_function( p_function => 'Get_Task_Element_Attributes',
5234: p_debug_mode => l_debug_mode );
5638:
5639: BEGIN
5640: x_msg_count := 0;
5641: x_return_status := FND_API.G_RET_STS_SUCCESS;
5642: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5643:
5644:
5645: -- Check for business rules violations
5646:
6078: BEGIN
6079:
6080: x_msg_count := 0;
6081: x_return_status := FND_API.G_RET_STS_SUCCESS;
6082: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6083:
6084:
6085: -- Check for business rules violations
6086:
6566: BEGIN
6567:
6568: x_msg_count := 0;
6569: x_return_status := FND_API.G_RET_STS_SUCCESS;
6570: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6571:
6572: IF l_debug_mode = 'Y' THEN
6573: pa_debug.set_curr_function( p_function => 'maintain_plannable_tasks',
6574: p_debug_mode => l_debug_mode );