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_PROJECT_PUB dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 4523: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );

4519: -- Bug 4146369 : Added following condition so that the error comes if user has passed tasks
4520: -- and when both the structures are disbaled in the source project.
4521: -- If we do not raise error here, then user will get Invalid Paramters passed error
4522: -- which will not make much sense to users.
4523: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );
4524: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );
4525:
4526: IF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i)
4527: THEN

Line 4524: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );

4520: -- and when both the structures are disbaled in the source project.
4521: -- If we do not raise error here, then user will get Invalid Paramters passed error
4522: -- which will not make much sense to users.
4523: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );
4524: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );
4525:
4526: IF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i)
4527: THEN
4528: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 5128: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

5124: --Set the global variable G_OP_VALIDATE_FLAG before going for dependence validation.
5125:
5126: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'
5127: THEN
5128: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
5129: ELSE
5130: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5131: END IF;
5132:

Line 5330: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_in_rec.created_from_project_id);

5326: -- 3700247, added code to check for source template/project deliverable is enabled or not
5327: -- if deliverable is enabled for source, call enable_deliverable api to enable deliverable for target project
5328: -- if deliverable is not enabled for source and for target deliverables are loaded, throw error message
5329:
5330: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_in_rec.created_from_project_id);
5331:
5332: IF l_debug_mode = 'Y' THEN
5333: pa_debug.g_err_stage := 'Deliverable Enabled ['||G_DLVR_STRUCTURE_ENABLED||']';
5334: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

Line 6097: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --p_pa_project_id 3106457

6093:
6094: /*
6095:
6096: l_process_code :=
6097: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --p_pa_project_id 3106457
6098: ,p_structure_type => l_str_type ); --p_structure_type 3746912
6099: IF nvl(l_process_code,'-1') = 'WUP' THEN
6100: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798
6101: ,p_structure_type => l_str_type ); --p_structure_type 3746912

Line 6100: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798

6096: l_process_code :=
6097: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --p_pa_project_id 3106457
6098: ,p_structure_type => l_str_type ); --p_structure_type 3746912
6099: IF nvl(l_process_code,'-1') = 'WUP' THEN
6100: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798
6101: ,p_structure_type => l_str_type ); --p_structure_type 3746912
6102:
6103: PA_UTILS.ADD_MESSAGE
6104: (p_app_short_name => 'PA',

Line 6114: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798

6110:
6111: RAISE FND_API.G_EXC_ERROR;
6112:
6113: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
6114: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- bug 3106457 p_pa_project_id -- Bug 3091798
6115: ,p_structure_type => l_str_type ); --p_structure_type 3746912
6116:
6117: PA_UTILS.ADD_MESSAGE
6118: (p_app_short_name => 'PA',

Line 6131: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

6127: END IF;
6128:
6129: */
6130:
6131: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
6132: p_project_id => l_project_id
6133: , p_structure_type => l_str_type
6134: , p_structure_version_id => null
6135: , p_context => 'UPDATE_AMG'

Line 6909: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);

6905:
6906: l_task_in_rec.gen_etc_source_code := p_gen_etc_source_code; -- added for bug#13864323
6907:
6908: --Bug 6410745 Changes done to set default value for financial task flag.
6909: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
6910: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id);
6911:
6912: IF l_shared = 'Y'
6913: THEN

Line 6910: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id);

6906: l_task_in_rec.gen_etc_source_code := p_gen_etc_source_code; -- added for bug#13864323
6907:
6908: --Bug 6410745 Changes done to set default value for financial task flag.
6909: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
6910: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id);
6911:
6912: IF l_shared = 'Y'
6913: THEN
6914: If l_Share_Code = 'SHARE_PARTIAL' then

Line 7080: l_str_ver_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id,l_structure_type);

7076: END IF;
7077: RAISE FND_API.G_EXC_ERROR;
7078: --bug 3098668
7079: ELSE
7080: l_str_ver_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id,l_structure_type);
7081: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(p_structure_version_id);
7082: IF (struct_ver_updatable IS NULL OR
7083: struct_ver_updatable = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
7084: struct_ver_updatable = 'N' OR

Line 7081: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(p_structure_version_id);

7077: RAISE FND_API.G_EXC_ERROR;
7078: --bug 3098668
7079: ELSE
7080: l_str_ver_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id,l_structure_type);
7081: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(p_structure_version_id);
7082: IF (struct_ver_updatable IS NULL OR
7083: struct_ver_updatable = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
7084: struct_ver_updatable = 'N' OR
7085: NVL( l_str_ver_type, 'N' ) = 'N' )

Line 7150: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_pa_project_id);

7146:
7147: IF p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7148: THEN
7149: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
7150: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_pa_project_id);
7151: ELSE
7152: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
7153: END IF;
7154: ELSE

Line 7489: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- bug 3106457 p_pa_project_id

7485:
7486: ELSE
7487: /* Ends added for Bug# 7264422 */
7488:
7489: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7490: ,p_structure_version_id => l_structure_version_id); -- bug 3106457 p_structure_version_id ) ;
7491:
7492: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7493: IF p_process_mode = 'ONLINE' THEN

Line 7789: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

7785: ELSIF p_structure_type = 'FINANCIAL' THEN -- Obtain the structure version id. Bug 3106457.
7786: IF p_task_version_id IS NULL
7787: OR p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3174639
7788: THEN
7789: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
7790: ELSE
7791: open cur_str_ver(p_task_version_id);
7792: fetch cur_str_ver into l_structure_version_id;
7793: close cur_str_ver;

Line 7828: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --Bug 3091798.

7824:
7825: /*
7826:
7827: l_process_code :=
7828: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --Bug 3091798.
7829: ,p_structure_type => p_structure_type );
7830:
7831: IF nvl(l_process_code,'-1') = 'WUP' THEN
7832: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798

Line 7832: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798

7828: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --Bug 3091798.
7829: ,p_structure_type => p_structure_type );
7830:
7831: IF nvl(l_process_code,'-1') = 'WUP' THEN
7832: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798
7833: ,p_structure_type => p_structure_type );
7834:
7835: PA_UTILS.ADD_MESSAGE
7836: (p_app_short_name => 'PA',

Line 7845: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id --Bug 3091798

7841:
7842: RAISE FND_API.G_EXC_ERROR;
7843:
7844: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
7845: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id --Bug 3091798
7846: ,p_structure_type => p_structure_type );
7847:
7848: PA_UTILS.ADD_MESSAGE
7849: (p_app_short_name => 'PA',

Line 7861: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

7857: END IF;
7858:
7859: */
7860:
7861: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
7862: p_project_id => l_project_id
7863: , p_structure_type => p_structure_type
7864: , p_structure_version_id => null
7865: , p_context => 'UPDATE_AMG'

Line 7936: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id --Bug 3106457 p_pa_project_id

7932:
7933: -- Bug 7390781
7934: IF (nvl(p_structure_updates_flag, 'Y') = 'Y') THEN
7935:
7936: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id --Bug 3106457 p_pa_project_id
7937: ,p_structure_version_id => l_structure_version_id ) ;
7938:
7939: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7940: IF p_process_mode = 'ONLINE' THEN

Line 10957: pa_debug.g_err_stage := 'Calling PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable' || p_structure_in.structure_version_id;

10953: END IF;
10954: --end bug 4619824
10955:
10956: IF l_debug_mode = 'Y' THEN
10957: pa_debug.g_err_stage := 'Calling PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable' || p_structure_in.structure_version_id;
10958: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10959: END IF;
10960:
10961: IF ( l_structure_version_id IS NOT NULL AND l_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

Line 10968: l_prev_locked_status := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id);

10964: --bug 4538849
10965:
10966: -- Begin Bug # 4582750.
10967:
10968: l_prev_locked_status := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id);
10969:
10970: if ( l_prev_locked_status = 'O' ) then
10971:
10972: -- End Bug # 4582750.

Line 10986: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||

10982:
10983: if (p_update_mode = 'PA_UPD_WBS_ATTR') and (p_pm_product_code <> 'WORKPLAN') then -- Bug # 4758888.
10984:
10985: IF l_debug_mode = 'Y' THEN
10986: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||
10987: 'p_project_in.pa_project_id='||p_project_in.pa_project_id||
10988: '-l_structure_version_id='||l_structure_version_id;
10989: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10990: END IF;

Line 10992: pa_project_structure_utils.lock_unlock_wp_str_autonomous

10988: '-l_structure_version_id='||l_structure_version_id;
10989: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10990: END IF;
10991:
10992: pa_project_structure_utils.lock_unlock_wp_str_autonomous
10993: (p_project_id => p_project_in.pa_project_id
10994: ,p_structure_version_id => p_structure_in.structure_version_id
10995: ,p_lock_status_code => 'LOCKED'
10996: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 11002: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||

10998: ,x_msg_count => l_x_msg_count
10999: ,x_msg_data => l_x_msg_data);
11000:
11001: IF l_debug_mode = 'Y' THEN
11002: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||
11003: 'l_x_return_status='||l_x_return_status;
11004: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11005: END IF;
11006:

Line 11053: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(l_structure_version_id);

11049: END IF;
11050:
11051: end if;
11052:
11053: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(l_structure_version_id);
11054:
11055: IF l_debug_mode = 'Y' THEN
11056: pa_debug.g_err_stage := 'struct_ver_updatable='||struct_ver_updatable;
11057: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 11085: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then

11081: ELSIF (struct_ver_updatable = 'Y') THEN
11082: -- structure version is locked by another user check must be done in both update modes. bug 4519809
11083: --IF (p_update_mode = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
11084: --Check if str version is locked by another user
11085: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then
11086: --if yes, raise error.
11087: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
11088: p_msg_name => 'PA_STR_LOCKED_BY_OTHER');
11089: RAISE FND_API.G_EXC_ERROR;

Line 18002: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

17998: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17999: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18000: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18001: THEN
18002: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18003: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18004: ,p_structure_version_id => l_structure_version_id ) ;
18005: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18006: IF p_project_in.process_mode = 'ONLINE' THEN

Line 18003: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id

17999: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18000: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18001: THEN
18002: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18003: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18004: ,p_structure_version_id => l_structure_version_id ) ;
18005: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18006: IF p_project_in.process_mode = 'ONLINE' THEN
18007: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

Line 18520: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

18516: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18517: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18518: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18519: THEN
18520: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18521: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18522: ,p_structure_version_id => l_structure_version_id ) ;
18523: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18524: IF p_project_in.process_mode = 'ONLINE' THEN

Line 18521: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id

18517: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18518: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18519: THEN
18520: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18521: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18522: ,p_structure_version_id => l_structure_version_id ) ;
18523: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18524: IF p_project_in.process_mode = 'ONLINE' THEN
18525: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

Line 22238: --Note that API pa_project_structure_utils.lock_unlock_wp_str IS NOT autonomosu transaction.

22234: ------ 3435905 : FP M : Deliverables Changes For AMG END-----------
22235:
22236:
22237: -- Bug # 4582750.
22238: --Note that API pa_project_structure_utils.lock_unlock_wp_str IS NOT autonomosu transaction.
22239:
22240: IF p_update_mode = 'PA_UPD_WBS_ATTR' AND l_prev_locked_status IS NOT NULL AND l_prev_locked_status = 'N'
22241: and (p_pm_product_code <> 'WORKPLAN') -- Bug # 4758888.
22242: AND p_structure_in.structure_version_id IS NOT NULL

Line 22247: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||

22243: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22244: THEN
22245:
22246: IF l_debug_mode = 'Y' THEN
22247: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||
22248: 'p_project_in.pa_project_id='||p_project_in.pa_project_id||
22249: '-l_structure_version_id='||l_structure_version_id;
22250: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
22251: END IF;

Line 22253: pa_project_structure_utils.lock_unlock_wp_str

22249: '-l_structure_version_id='||l_structure_version_id;
22250: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
22251: END IF;
22252:
22253: pa_project_structure_utils.lock_unlock_wp_str
22254: (p_project_id => p_project_in.pa_project_id
22255: ,p_structure_version_id => p_structure_in.structure_version_id
22256: ,p_lock_status_code => 'UNLOCKED'
22257: ,p_calling_module => 'PA_UPD_WBS_ATTR'

Line 22263: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||

22259: ,x_msg_count => l_x_msg_count
22260: ,x_msg_data => l_x_msg_data);
22261:
22262: IF l_debug_mode = 'Y' THEN
22263: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||
22264: 'l_x_return_status='||l_x_return_status;
22265: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
22266: END IF;
22267:

Line 22314: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22310: AND p_structure_in.structure_version_id IS NOT NULL
22311: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22312: then
22313:
22314: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22315: (p_project_id => p_project_in.pa_project_id
22316: , p_structure_version_id => p_structure_in.structure_version_id
22317: , p_lock_status_code => 'UNLOCKED'
22318: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 22359: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22355: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22356: then
22357:
22358:
22359: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22360: (p_project_id => p_project_in.pa_project_id
22361: , p_structure_version_id => p_structure_in.structure_version_id
22362: , p_lock_status_code => 'UNLOCKED'
22363: ,p_calling_module => 'PA_UPD_WBS_ATTR'

Line 22404: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22400: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22401: then
22402:
22403:
22404: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22405: (p_project_id => p_project_in.pa_project_id
22406: , p_structure_version_id => p_structure_in.structure_version_id
22407: , p_lock_status_code => 'UNLOCKED'
22408: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 22456: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22452: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22453: then
22454:
22455:
22456: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22457: (p_project_id => p_project_in.pa_project_id
22458: , p_structure_version_id => p_structure_in.structure_version_id
22459: , p_lock_status_code => 'UNLOCKED'
22460: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 22511: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22507: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22508: then
22509:
22510:
22511: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22512: (p_project_id => p_project_in.pa_project_id
22513: , p_structure_version_id => p_structure_in.structure_version_id
22514: , p_lock_status_code => 'UNLOCKED'
22515: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 23942: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);

23938: --BUG 3919800, p_structure_version_id to l_structure_version_id, rtarway
23939: IF l_structure_version_id IS NULL
23940: OR l_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3174639
23941: THEN
23942: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
23943: ELSE
23944: l_structure_version_id := p_structure_version_id;
23945: END IF;
23946: -- --dbms_output.put_line('BEFORE CALLING UPDATE_task_structure');

Line 24526: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- Bug 3106457 p_pa_project_id

24522: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
24523: PA_PROJECT_PUB.G_Published_version_exists = 'N')
24524: THEN
24525:
24526: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
24527: ,p_structure_version_id => l_structure_version_id ) ; -- Bug 3106457
24528: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
24529: IF p_process_mode = 'ONLINE' THEN
24530:

Line 24595: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LAST_UPDATED_WORKING_VER(l_d_task_id);

24591:
24592: END IF;
24593: /*
24594: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
24595: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LAST_UPDATED_WORKING_VER(l_d_task_id);
24596: ELSE
24597: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
24598: END IF;
24599: */ --we dont need this. The structure version id is derived.

Line 28212: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_pa_project_id

28208: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
28209: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
28210: -- THEN
28211:
28212: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_pa_project_id
28213: ,p_structure_version_id => p_published_struct_ver_id ) ;
28214: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
28215: IF p_process_mode = 'ONLINE' THEN
28216:

Line 30338: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);

30334: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);
30335: END IF;
30336:
30337: IF G_DLVR_STRUCTURE_ENABLED IS NULL THEN
30338: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);
30339:
30340: IF p_debug_mode = 'Y' THEN
30341: pa_debug.g_err_stage := 'Deliverable Enabled ['||G_DLVR_STRUCTURE_ENABLED||']';
30342: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

Line 30358: l_dlvr_enabled := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);

30354: -- error message is thrown. So, removing the below code , which enables the structure for the target project in
30355: -- above condition.
30356:
30357: /*
30358: l_dlvr_enabled := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);
30359:
30360: IF p_debug_mode = 'Y' THEN
30361: pa_debug.g_err_stage := 'Deliverable Enabled ['||l_dlvr_enabled||']';
30362: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

Line 34124: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

34120: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34121: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34122: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
34123: THEN
34124: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34125: END IF;
34126: END IF;
34127: ELSIF(p_wp_structure_version_id IS NOT NULL AND p_wp_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
34128: THEN

Line 34479: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

34475: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34476: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34477: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
34478: THEN
34479: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34480: END IF;
34481: END IF;
34482: END IF;
34483: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

Line 34826: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);

34822: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34823: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34824: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34825: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34826: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34827: END IF;
34828: END IF;
34829: END IF;
34830: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

Line 35197: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then

35193: RAISE FND_API.G_EXC_ERROR;
35194: END IF;
35195: --
35196: --Bug 3768875
35197: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35198: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35199: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35200: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35201: RAISE FND_API.G_EXC_ERROR;

Line 35198: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN

35194: END IF;
35195: --
35196: --Bug 3768875
35197: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35198: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35199: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35200: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35201: RAISE FND_API.G_EXC_ERROR;
35202: End If;

Line 35456: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then

35452: RAISE FND_API.G_EXC_ERROR;
35453: END IF;
35454: --
35455: --Bug 3769089
35456: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35457: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35459: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35460:

Line 35457: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN

35453: END IF;
35454: --
35455: --Bug 3769089
35456: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35457: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35459: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35460:
35461: RAISE FND_API.G_EXC_ERROR;

Line 35717: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then

35713: RAISE FND_API.G_EXC_ERROR;
35714: END IF;
35715: --
35716: --Bug 3769079
35717: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35718: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35719: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35720: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35721: RAISE FND_API.G_EXC_ERROR;

Line 35718: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN

35714: END IF;
35715: --
35716: --Bug 3769079
35717: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35718: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35719: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35720: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35721: RAISE FND_API.G_EXC_ERROR;
35722: End If;

Line 36183: AND (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id, 'FINANCIAL') = 'Y')

36179: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
36180:
36181: -- If this passed task belongs to a Split - Fin. Only structure
36182: IF nvl(l_wp_str_exists,'N') = 'N'
36183: AND (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id, 'FINANCIAL') = 'Y')
36184: THEN
36185: -- Its ok to delete this task
36186: l_check_task_mfd_flag := 'Y' ;
36187: -- Begin Bug 9480442

Line 36189: ELSIF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id,'FINANCIAL') = 'Y') AND NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') = 'SPLIT_MAPPING'

36185: -- Its ok to delete this task
36186: l_check_task_mfd_flag := 'Y' ;
36187: -- Begin Bug 9480442
36188: -- Logic to handle the deletion of task from Financial Plans in a project that also contains WBS(NSTBM structure projects)
36189: ELSIF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id,'FINANCIAL') = 'Y') AND NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') = 'SPLIT_MAPPING'
36190: THEN
36191: l_check_task_mfd_flag := 'Y' ;
36192: -- End Bug 9480442
36193: -- If this passed task belongs to a WP structure (be it shared or be it split)

Line 36194: ELSIF PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id,'WORKPLAN') = 'Y'

36190: THEN
36191: l_check_task_mfd_flag := 'Y' ;
36192: -- End Bug 9480442
36193: -- If this passed task belongs to a WP structure (be it shared or be it split)
36194: ELSIF PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id,'WORKPLAN') = 'Y'
36195: THEN
36196: IF l_versioning_enabled = 'Y'
36197: AND l_pub_ver_exists = 'Y'
36198: THEN

Line 36455: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id, p_structure_version_id) <> 'Y' THEN

36451: END IF;
36452:
36453: END IF;
36454:
36455: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id, p_structure_version_id) <> 'Y' THEN
36456: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
36457: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
36458:
36459: RAISE FND_API.G_EXC_ERROR;

Line 36518: l_process_code := PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id

36514: RAISE FND_API.G_EXC_ERROR;
36515: END IF;
36516:
36517: --Bug# 5973460
36518: l_process_code := PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id
36519: ,p_structure_version_id => p_structure_version_id );
36520:
36521: IF l_process_code = 'PUE'
36522: THEN

Line 36532: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id

36528: --Bug# 5973460
36529:
36530: -- check the process_update_wbs_flag
36531:
36532: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
36533: ,p_structure_version_id => p_structure_version_id ) ;
36534:
36535: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
36536:

Line 36537: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

36533: ,p_structure_version_id => p_structure_version_id ) ;
36534:
36535: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
36536:
36537: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
36538: p_project_id => l_project_id
36539: , p_structure_version_id => p_structure_version_id
36540: , p_context => 'UPDATE_AMG'
36541: , x_message_name => l_message_name

Line 36880: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);

36876: raise FND_API.G_EXC_ERROR;
36877: end if;
36878:
36879: -- Get the current attributes of the project.
36880: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36881: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36882: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36883: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36884:

Line 36881: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);

36877: end if;
36878:
36879: -- Get the current attributes of the project.
36880: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36881: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36882: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36883: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36884:
36885: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.

Line 36882: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);

36878:
36879: -- Get the current attributes of the project.
36880: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36881: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36882: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36883: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36884:
36885: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.
36886: if ((p_sys_program_flag = 'Y') or (p_sys_program_flag = 'N')) then

Line 36883: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);

36879: -- Get the current attributes of the project.
36880: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36881: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36882: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36883: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36884:
36885: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.
36886: if ((p_sys_program_flag = 'Y') or (p_sys_program_flag = 'N')) then
36887: l_sys_program_flag := p_sys_program_flag;

Line 37323: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

37319: -- If the responsibility does not allow a function to be executed the API
37320: -- will error out as the user does not have access.
37321: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37322: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
37323: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37324: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37325: (p_api_version_number => p_api_version
37326: , p_responsibility_id => FND_GLOBAL.RESP_ID
37327: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

Line 37359: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

37355: end if;
37356:
37357: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37358: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
37359: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37360: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37361: (p_api_version_number => p_api_version
37362: , p_responsibility_id => FND_GLOBAL.RESP_ID
37363: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

Line 37396: if (pa_project_structure_utils.check_workplan_enabled(l_sub_project_id) = 'N') then

37392:
37393: -- Check if the sub-project has the appropriate structure type enabled.
37394: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37395: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN') then
37396: if (pa_project_structure_utils.check_workplan_enabled(l_sub_project_id) = 'N') then
37397:
37398: open l_cur_proj_name(l_sub_project_id);
37399: fetch l_cur_proj_name into l_project_name;
37400: close l_cur_proj_name;

Line 37410: if (pa_project_structure_utils.check_financial_enabled(l_sub_project_id) = 'N') then

37406: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.
37407:
37408: end if;
37409: elsif (p_program_links_tbl(l_count).structure_type = 'FINANCIAL') then
37410: if (pa_project_structure_utils.check_financial_enabled(l_sub_project_id) = 'N') then
37411:
37412: open l_cur_proj_name(l_sub_project_id);
37413: fetch l_cur_proj_name into l_project_name;
37414: close l_cur_proj_name;

Line 37939: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

37935: -- If the responsibility does not allow a function to be executed the API
37936: -- will error out as the user does not have access.
37937: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37938: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
37939: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37940: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37941: (p_api_version_number => p_api_version
37942: , p_responsibility_id => FND_GLOBAL.RESP_ID
37943: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

Line 37976: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

37972: end if;
37973:
37974: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37975: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
37976: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37977: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37978: (p_api_version_number => p_api_version
37979: , p_responsibility_id => FND_GLOBAL.RESP_ID
37980: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

Line 38464: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

38460: -- Actions performed using the APIs are subject to function security.
38461: -- If the responsibility does not allow a function to be executed the API
38462: -- will error out as the user does not have access.
38463: if (p_structure_type = 'WORKPLAN'
38464: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
38465: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
38466: (p_api_version_number => p_api_version
38467: , p_responsibility_id => FND_GLOBAL.RESP_ID
38468: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

Line 38496: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then

38492: end if;
38493: end if;
38494:
38495: if (p_structure_type = 'FINANCIAL'
38496: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
38497: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
38498: (p_api_version_number => p_api_version
38499: , p_responsibility_id => FND_GLOBAL.RESP_ID
38500: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

Line 38653: l_published_version := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_pa_project_id);

38649:
38650:
38651: BEGIN
38652:
38653: l_published_version := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_pa_project_id);
38654:
38655: OPEN c_prev_published_version(p_pa_project_id);
38656: FETCH c_prev_published_version INTO l_prev_published_version;
38657: CLOSE c_prev_published_version;

Line 38779: --IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'

38775: OPEN get_project_details_csr (p_project_id);
38776: FETCH get_project_details_csr INTO l_project_details_rec;
38777: CLOSE get_project_details_csr;
38778:
38779: --IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'
38780: IF NVL(l_project_details_rec.structure_sharing_code,' ') <> 'SHARE_FULL'
38781: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id),'N') = 'Y' THEN
38782: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
38783: p_msg_name => 'PA_CANT_USE_LITE_API');

Line 38807: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);

38803: PA_PROJECT_PUB.G_BULK_UPDATE_MODE := p_bulk_update_mode;
38804:
38805: -- Set the G_ROLLUP_FLAG based on profile options
38806: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
38807: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
38808: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38809: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'UPDATE',l_msg_data,l_return_status);
38810: IF l_return_status <> 'S'
38811: THEN

Line 39102: --IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'

39098: l_incremental_add_tasks := 'N';
39099: END IF;
39100: CLOSE check_tasks_exists_csr;
39101:
39102: --IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'
39103: IF NVL(l_project_details_rec.structure_sharing_code,' ') <> 'SHARE_FULL'
39104: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id),'N') = 'Y' THEN
39105: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39106: p_msg_name => 'PA_CANT_USE_LITE_API');

Line 39121: PA_PROJECT_PUB.G_STRUC_VERSION_ID := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);

39117: PA_PROJECT_PUB.G_STRUC_ELEMENT_ID := NULL;
39118: PA_PROJECT_PUB.G_PROJECT_TYPE := l_project_details_rec.project_type;
39119: PA_PROJECT_PUB.G_IS_SUB_PROJ_ASSOCIATED := NULL;
39120: PA_PROJECT_PUB.G_BULK_ADD_MODE := p_bulk_add_mode;
39121: PA_PROJECT_PUB.G_STRUC_VERSION_ID := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
39122: PA_PROJECT_PUB.G_FP_DFF_TBL.delete;
39123:
39124: -- Set the G_ROLLUP_FLAG based on profile options
39125: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

Line 39725: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'

39721:
39722: raise;
39723: end;
39724:
39725: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id),' ') <> 'SHARE_FULL'
39726: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id),'N') = 'Y' THEN
39727: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
39728: p_msg_name => 'PA_CANT_USE_LITE_API');
39729: RAISE FND_API.G_EXC_ERROR;

Line 39801: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);

39797: End If;
39798:
39799: End If; /* End if calling module is self service*/
39800:
39801: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
39802: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
39803:
39804: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

Line 39802: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);

39798:
39799: End If; /* End if calling module is self service*/
39800:
39801: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
39802: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
39803:
39804: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
39806:

Line 39804: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');

39800:
39801: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
39802: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
39803:
39804: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
39806:
39807: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
39808: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);

Line 39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');

39801: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(p_ref_project_id);
39802: l_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_ref_project_id);
39803:
39804: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN');
39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
39806:
39807: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
39808: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
39809: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);

Line 39809: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);

39805: l_fin_type := PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL');
39806:
39807: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_ref_project_id);
39808: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_ref_project_id);
39809: l_check_third_party_flag := PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(p_ref_project_id);
39810:
39811: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
39812: l_task_version_id := p_task_version_id_tbl(1);
39813:

Line 40235: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id),' ') <> 'SHARE_FULL'

40231:
40232: raise;
40233: end;
40234:
40235: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id),' ') <> 'SHARE_FULL'
40236: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id),'N') = 'Y' THEN
40237: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
40238: p_msg_name => 'PA_CANT_USE_LITE_API');
40239: RAISE FND_API.G_EXC_ERROR;

Line 40454: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

40450: CLOSE get_parent_version_id;
40451:
40452: --bug 3069306
40453: --if financial task, check if changing parent ok
40454: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
40455: OPEN get_top_task_ver_id(l_parent_ver_id);
40456: FETCH get_top_task_ver_id into l_new_par_ver_id;
40457: CLOSE get_top_task_ver_id;
40458:

Line 40493: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

40489: --end bug 4099488
40490: ELSE
40491: --bug 3069306
40492: --if financial task, check if changing parent ok
40493: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
40494: OPEN get_top_task_ver_id(ref_elem_ver_id);
40495: FETCH get_top_task_ver_id into l_new_par_ver_id;
40496: CLOSE get_top_task_ver_id;
40497:

Line 40532: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)

40528: END IF;
40529: --end bug 4099488
40530: END IF;
40531:
40532: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
40533: IN ('SHARE_PARTIAL')
40534: Then
40535:
40536: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 40971: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

40967:
40968:
40969: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
40970: l_project_id);
40971: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
40972: l_project_id);
40973:
40974: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --indent in corresponding task in pa_tasks
40975:

Line 41044: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

41040: END IF;
41041: END IF;
41042: CLOSE cur_struc_type;
41043:
41044: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
41045:
41046: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
41047:
41048: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(

Line 41046: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then

41042: CLOSE cur_struc_type;
41043:
41044: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
41045:
41046: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
41047:
41048: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
41049: p_structure_version_id => P_Structure_Version_ID
41050: ,p_dirty_flag => 'Y' --bug 3902282

Line 41130: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

41126:
41127: END IF;
41128:
41129: --bug 3053281 --set flag if not (manual and workplan only)
41130: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
41131: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
41132:
41133: --3035902: process update flag changes
41134: OPEN get_task_type_id(src_proj_element_id);

Line 41187: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'

41183: --3035902: end process update flag changes
41184:
41185: --ideally the following calls should have been cached. but due to time constraints
41186: --we need to write the code this way in multiple places.
41187: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'
41188: THEN
41189: IF ( l_versioned = 'N' ) OR ( l_versioned = 'Y' and l_shared = 'Y' and l_published_version = 'N' ) THEN
41190: --Indent
41191: pa_fp_refresh_elements_pub.set_process_flag_proj(

Line 41691: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id),' ') <> 'SHARE_FULL'

41687: raise;
41688: end;
41689:
41690:
41691: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id),' ') <> 'SHARE_FULL'
41692: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id),'N') = 'Y' THEN
41693: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
41694: p_msg_name => 'PA_CANT_USE_LITE_API');
41695: RAISE FND_API.G_EXC_ERROR;

Line 41893: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN

41889: FETCH get_parent_version_id into l_parent_ver_id;
41890: CLOSE get_parent_version_id;
41891:
41892: --if financial task, check if changing parent ok
41893: IF (PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y') THEN
41894: OPEN get_top_task_ver_id(l_parent_ver_id);
41895: FETCH get_top_task_ver_id into l_new_par_ver_id;
41896: CLOSE get_top_task_ver_id;
41897:

Line 41923: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)

41919: END IF;
41920:
41921: -- Added for FP_M changes. Bug 3305199 : Bhumesh xxx
41922:
41923: If PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id)
41924: IN ('SHARE_PARTIAL')
41925: Then
41926:
41927: PA_TASKS_MAINT_UTILS.CHECK_MOVE_FINANCIAL_TASK_OK (

Line 42488: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(

42484:
42485:
42486: l_versioned := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(
42487: l_project_id);
42488: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(
42489: l_project_id);
42490:
42491: l_fin_task_flag := PA_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(src_proj_element_id); --outdent in corresponding task in pa_tasks
42492:

Line 42559: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then

42555: CLOSE cur_struc_type;
42556:
42557: -- Added for date rollup; workplan only
42558:
42559: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
42560:
42561: -- Added for FP_M changes Bug 3305199 : Bhumesh
42562: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
42563:

Line 42562: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then

42558:
42559: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'WORKPLAN') = 'Y' then
42560:
42561: -- Added for FP_M changes Bug 3305199 : Bhumesh
42562: If PA_Project_Structure_Utils.Check_Third_Party_Sch_Flag(P_Project_ID) = 'Y' Then
42563:
42564: PA_PROJECT_STRUCTURE_PVT1.update_sch_dirty_flag(
42565: p_structure_version_id => P_Structure_Version_ID
42566: ,p_dirty_flag => 'Y' --bug 3902282

Line 42649: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

42645: END IF;
42646:
42647: --bug 3010538 ( outdent )
42648: --bug 3053281 --set flag if not (manual and workplan only)
42649: l_wp_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
42650: l_weighting_basis_Code := PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS(p_project_id);
42651: --3035902: process update flag changes
42652: OPEN get_task_type_id(src_proj_element_id);
42653: FETCH get_task_type_id INTO l_task_type_id;

Line 42703: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'

42699: --3035902: end process update flag changes
42700:
42701: --ideally the following calls should have been cached. but due to time constraints
42702: --we need to write the code this way in multiple places.
42703: IF PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id, 'FINANCIAL') = 'Y'
42704: THEN
42705: IF ( l_versioned = 'N' ) OR ( l_versioned = 'Y' and l_shared = 'Y' and l_published_version = 'N' ) THEN
42706:
42707: --Outdent

Line 42906: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_pa_project_id),' ') <> 'SHARE_FULL'

42902:
42903: l_structure_type:=p_structure_type;
42904: l_process_mode:=p_process_mode;
42905:
42906: IF NVL(PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_pa_project_id),' ') <> 'SHARE_FULL'
42907: OR NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id),'N') = 'Y' THEN
42908: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
42909: p_msg_name => 'PA_CANT_USE_LITE_API');
42910: RAISE FND_API.G_EXC_ERROR;

Line 42914: l_structure_version_id :=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_pa_project_id);

42910: RAISE FND_API.G_EXC_ERROR;
42911: END IF;
42912:
42913: PA_PROJECT_PUB.G_PROJECT_ID:=p_pa_project_id;
42914: l_structure_version_id :=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_pa_project_id);
42915:
42916: -- Set the G_ROLLUP_FLAG based on profile options
42917: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
42918: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN