APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on FND_PROFILE

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

1001:
1002:
1003: BEGIN
1004:
1005: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1006:
1007: IF l_debug_mode = 'Y' THEN
1008:
1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;

Line 3368: l_wbs_update_option := nvl(FND_PROFILE.value('PA_PROCESS_WBS_UPDATES'),'STANDARD');

3364: -- End Bug # 4611527.
3365:
3366: END IF;
3367:
3368: l_wbs_update_option := nvl(FND_PROFILE.value('PA_PROCESS_WBS_UPDATES'),'STANDARD');
3369: IF l_wbs_update_option = 'ONLINE' THEN
3370: return 'ONLINE';
3371: ELSE
3372: l_threshold_task_cnt := nvl(FND_PROFILE.value('PA_PROC_WBS_UPD_THRESHOLD'),50);

Line 3372: l_threshold_task_cnt := nvl(FND_PROFILE.value('PA_PROC_WBS_UPD_THRESHOLD'),50);

3368: l_wbs_update_option := nvl(FND_PROFILE.value('PA_PROCESS_WBS_UPDATES'),'STANDARD');
3369: IF l_wbs_update_option = 'ONLINE' THEN
3370: return 'ONLINE';
3371: ELSE
3372: l_threshold_task_cnt := nvl(FND_PROFILE.value('PA_PROC_WBS_UPD_THRESHOLD'),50);
3373: IF p_task_count > l_threshold_task_cnt THEN
3374: return 'CONCURRENT';
3375: ELSE
3376: return 'ONLINE';

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

3559: BEGIN
3560:
3561: x_msg_count := 0;
3562: x_return_status := FND_API.G_RET_STS_SUCCESS;
3563: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3564:
3565: IF l_debug_mode = 'Y' THEN
3566: pa_debug.set_curr_function( p_function => 'GET_CONC_REQUEST_DETAILS',
3567: p_debug_mode => l_debug_mode );

Line 4692: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN

4688: elsif (l_proc_upd_flag = 'Y') then
4689:
4690: if (p_structure_type = 'WORKPLAN') then
4691: -- Bug 5999999
4692: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4693:
4694: if l_str_sharing_code in ('SHARE_FULL' , 'SHARE_PARTIAL') then
4695:
4696: l_message_name := 'PA_PS_VD_SH_UPD_WBS_PRC_REQ';

Line 4709: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN

4705: END IF;
4706:
4707: elsif (p_structure_type = 'FINANCIAL') then
4708:
4709: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'AUTOMATIC') = 'AUTOMATIC' THEN
4710:
4711: if l_str_sharing_code in ('SHARE_FULL' , 'SHARE_PARTIAL') then
4712:
4713: l_message_name := 'PA_PS_VD_SH_UPD_WBS_PRC_REQ';

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

4791: savepoint lock_unlock_wp_str;
4792:
4793: x_msg_count := 0;
4794: x_return_status := FND_API.G_RET_STS_SUCCESS;
4795: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

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

4888: savepoint lock_unlock_wp_str2;
4889:
4890: x_msg_count := 0;
4891: x_return_status := FND_API.G_RET_STS_SUCCESS;
4892: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

Line 5236: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'MANUAL') = 'AUTOMATIC' THEN --Bug 11803799

5232:
5233: l_dummy VARCHAR2(1);
5234:
5235: BEGIN
5236: IF NVL(FND_PROFILE.value('PA_ROLLUP_PROGRAM_AMOUNTS'),'MANUAL') = 'AUTOMATIC' THEN --Bug 11803799
5237: return lookup_code;
5238: ELSE
5239: OPEN c1;
5240: FETCH c1 into l_dummy;