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 4437: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );

4433: -- Bug 4146369 : Added following condition so that the error comes if user has passed tasks
4434: -- and when both the structures are disbaled in the source project.
4435: -- If we do not raise error here, then user will get Invalid Paramters passed error
4436: -- which will not make much sense to users.
4437: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );
4438: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );
4439:
4440: IF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i)
4441: THEN

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

4434: -- and when both the structures are disbaled in the source project.
4435: -- If we do not raise error here, then user will get Invalid Paramters passed error
4436: -- which will not make much sense to users.
4437: l_bug_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_workplan_enabled( l_project_in_rec.created_from_project_id );
4438: l_bug_fp_enabled := PA_PROJECT_STRUCTURE_UTILS.check_financial_enabled( l_project_in_rec.created_from_project_id );
4439:
4440: IF l_bug_wp_enabled = 'N' AND l_bug_fp_enabled = 'N' AND p_tasks_in.exists(i)
4441: THEN
4442: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

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

5009: --Set the global variable G_OP_VALIDATE_FLAG before going for dependence validation.
5010:
5011: IF NVL(PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED,'N') = 'Y'
5012: THEN
5013: l_d_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
5014: ELSE
5015: l_d_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID( l_project_id, 'WORKPLAN');
5016: END IF;
5017:

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

5199: -- 3700247, added code to check for source template/project deliverable is enabled or not
5200: -- if deliverable is enabled for source, call enable_deliverable api to enable deliverable for target project
5201: -- if deliverable is not enabled for source and for target deliverables are loaded, throw error message
5202:
5203: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_in_rec.created_from_project_id);
5204:
5205: IF l_debug_mode = 'Y' THEN
5206: pa_debug.g_err_stage := 'Deliverable Enabled ['||G_DLVR_STRUCTURE_ENABLED||']';
5207: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

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

5872:
5873: /*
5874:
5875: l_process_code :=
5876: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --p_pa_project_id 3106457
5877: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5878: IF nvl(l_process_code,'-1') = 'WUP' THEN
5879: 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
5880: ,p_structure_type => l_str_type ); --p_structure_type 3746912

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

5875: l_process_code :=
5876: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --p_pa_project_id 3106457
5877: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5878: IF nvl(l_process_code,'-1') = 'WUP' THEN
5879: 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
5880: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5881:
5882: PA_UTILS.ADD_MESSAGE
5883: (p_app_short_name => 'PA',

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

5889:
5890: RAISE FND_API.G_EXC_ERROR;
5891:
5892: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
5893: 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
5894: ,p_structure_type => l_str_type ); --p_structure_type 3746912
5895:
5896: PA_UTILS.ADD_MESSAGE
5897: (p_app_short_name => 'PA',

Line 5910: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

5906: END IF;
5907:
5908: */
5909:
5910: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
5911: p_project_id => l_project_id
5912: , p_structure_type => l_str_type
5913: , p_structure_version_id => null
5914: , p_context => 'UPDATE_AMG'

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

6678: G_tasks_in_tbl(G_tasks_tbl_count).gen_etc_source_code := p_gen_etc_source_code;
6679: -- set the new params - bug #3654243 -------------------------------------------------
6680:
6681: --Bug 6410745 Changes done to set default value for financial task flag.
6682: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
6683: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id);
6684:
6685: IF l_shared = 'Y'
6686: THEN

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

6679: -- set the new params - bug #3654243 -------------------------------------------------
6680:
6681: --Bug 6410745 Changes done to set default value for financial task flag.
6682: l_shared := PA_PROJECT_STRUCTURE_UTILS.Check_Sharing_Enabled(l_project_id);
6683: l_Share_Code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_project_id);
6684:
6685: IF l_shared = 'Y'
6686: THEN
6687: If l_Share_Code = 'SHARE_PARTIAL' then

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

6833: END IF;
6834: RAISE FND_API.G_EXC_ERROR;
6835: --bug 3098668
6836: ELSE
6837: l_str_ver_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id,l_structure_type);
6838: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(p_structure_version_id);
6839: IF (struct_ver_updatable IS NULL OR
6840: struct_ver_updatable = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
6841: struct_ver_updatable = 'N' OR

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

6834: RAISE FND_API.G_EXC_ERROR;
6835: --bug 3098668
6836: ELSE
6837: l_str_ver_type := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id,l_structure_type);
6838: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(p_structure_version_id);
6839: IF (struct_ver_updatable IS NULL OR
6840: struct_ver_updatable = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR
6841: struct_ver_updatable = 'N' OR
6842: NVL( l_str_ver_type, 'N' ) = 'N' )

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

6903:
6904: IF p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6905: THEN
6906: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
6907: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(p_pa_project_id);
6908: ELSE
6909: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
6910: END IF;
6911: ELSE

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

7241:
7242: ELSE
7243: /* Ends added for Bug# 7264422 */
7244:
7245: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- bug 3106457 p_pa_project_id
7246: ,p_structure_version_id => l_structure_version_id); -- bug 3106457 p_structure_version_id ) ;
7247:
7248: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7249: IF p_process_mode = 'ONLINE' THEN

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

7541: ELSIF p_structure_type = 'FINANCIAL' THEN -- Obtain the structure version id. Bug 3106457.
7542: IF p_task_version_id IS NULL
7543: OR p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3174639
7544: THEN
7545: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
7546: ELSE
7547: open cur_str_ver(p_task_version_id);
7548: fetch cur_str_ver into l_structure_version_id;
7549: close cur_str_ver;

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

7580:
7581: /*
7582:
7583: l_process_code :=
7584: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --Bug 3091798.
7585: ,p_structure_type => p_structure_type );
7586:
7587: IF nvl(l_process_code,'-1') = 'WUP' THEN
7588: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798

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

7584: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id --Bug 3091798.
7585: ,p_structure_type => p_structure_type );
7586:
7587: IF nvl(l_process_code,'-1') = 'WUP' THEN
7588: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id -- Bug 3091798
7589: ,p_structure_type => p_structure_type );
7590:
7591: PA_UTILS.ADD_MESSAGE
7592: (p_app_short_name => 'PA',

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

7597:
7598: RAISE FND_API.G_EXC_ERROR;
7599:
7600: ELSIF nvl(l_process_code,'-1') = 'WUE' THEN
7601: l_request_id := PA_PROJECT_STRUCTURE_UTILS.GET_CONC_REQUEST_ID(p_project_id => l_project_id --Bug 3091798
7602: ,p_structure_type => p_structure_type );
7603:
7604: PA_UTILS.ADD_MESSAGE
7605: (p_app_short_name => 'PA',

Line 7617: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

7613: END IF;
7614:
7615: */
7616:
7617: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
7618: p_project_id => l_project_id
7619: , p_structure_type => p_structure_type
7620: , p_structure_version_id => null
7621: , p_context => 'UPDATE_AMG'

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

7688:
7689: -- Bug 7390781
7690: IF (nvl(p_structure_updates_flag, 'Y') = 'Y') THEN
7691:
7692: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id --Bug 3106457 p_pa_project_id
7693: ,p_structure_version_id => l_structure_version_id ) ;
7694:
7695: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
7696: IF p_process_mode = 'ONLINE' THEN

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

10663: END IF;
10664: --end bug 4619824
10665:
10666: IF l_debug_mode = 'Y' THEN
10667: pa_debug.g_err_stage := 'Calling PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable' || p_structure_in.structure_version_id;
10668: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10669: END IF;
10670:
10671: IF ( l_structure_version_id IS NOT NULL AND l_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

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

10674: --bug 4538849
10675:
10676: -- Begin Bug # 4582750.
10677:
10678: l_prev_locked_status := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id);
10679:
10680: if ( l_prev_locked_status = 'O' ) then
10681:
10682: -- End Bug # 4582750.

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

10692:
10693: if (p_update_mode = 'PA_UPD_WBS_ATTR') and (p_pm_product_code <> 'WORKPLAN') then -- Bug # 4758888.
10694:
10695: IF l_debug_mode = 'Y' THEN
10696: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||
10697: 'p_project_in.pa_project_id='||p_project_in.pa_project_id||
10698: '-l_structure_version_id='||l_structure_version_id;
10699: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10700: END IF;

Line 10702: pa_project_structure_utils.lock_unlock_wp_str_autonomous

10698: '-l_structure_version_id='||l_structure_version_id;
10699: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10700: END IF;
10701:
10702: pa_project_structure_utils.lock_unlock_wp_str_autonomous
10703: (p_project_id => p_project_in.pa_project_id
10704: ,p_structure_version_id => p_structure_in.structure_version_id
10705: ,p_lock_status_code => 'LOCKED'
10706: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

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

10708: ,x_msg_count => l_x_msg_count
10709: ,x_msg_data => l_x_msg_data);
10710:
10711: IF l_debug_mode = 'Y' THEN
10712: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str_autonomous for LOCKING'||
10713: 'l_x_return_status='||l_x_return_status;
10714: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10715: END IF;
10716:

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

10731:
10732: end if;
10733: --end bug 4538849
10734:
10735: struct_ver_updatable := PA_PROJECT_STRUCTURE_UTILS.is_structure_version_updatable(l_structure_version_id);
10736:
10737: IF l_debug_mode = 'Y' THEN
10738: pa_debug.g_err_stage := 'struct_ver_updatable='||struct_ver_updatable;
10739: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

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

10763: ELSIF (struct_ver_updatable = 'Y') THEN
10764: -- structure version is locked by another user check must be done in both update modes. bug 4519809
10765: --IF (p_update_mode = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
10766: --Check if str version is locked by another user
10767: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then
10768: --if yes, raise error.
10769: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10770: p_msg_name => 'PA_STR_LOCKED_BY_OTHER');
10771: RAISE FND_API.G_EXC_ERROR;

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

17613: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN
17617: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
17618: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
17619: ,p_structure_version_id => l_structure_version_id ) ;
17620: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
17621: IF p_project_in.process_mode = 'ONLINE' THEN

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

17614: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17615: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17616: THEN
17617: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
17618: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
17619: ,p_structure_version_id => l_structure_version_id ) ;
17620: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
17621: IF p_project_in.process_mode = 'ONLINE' THEN
17622: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

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

18130: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN
18134: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18135: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18136: ,p_structure_version_id => l_structure_version_id ) ;
18137: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18138: IF p_project_in.process_mode = 'ONLINE' THEN

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

18131: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
18132: PA_PROJECT_PUB.G_Published_version_exists = 'N')
18133: THEN
18134: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
18135: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
18136: ,p_structure_version_id => l_structure_version_id ) ;
18137: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
18138: IF p_project_in.process_mode = 'ONLINE' THEN
18139: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES(p_calling_context => 'ONLINE_UPDATE'

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

21774: ------ 3435905 : FP M : Deliverables Changes For AMG END-----------
21775:
21776:
21777: -- Bug # 4582750.
21778: --Note that API pa_project_structure_utils.lock_unlock_wp_str IS NOT autonomosu transaction.
21779:
21780: IF p_update_mode = 'PA_UPD_WBS_ATTR' AND l_prev_locked_status IS NOT NULL AND l_prev_locked_status = 'N'
21781: and (p_pm_product_code <> 'WORKPLAN') -- Bug # 4758888.
21782: AND p_structure_in.structure_version_id IS NOT NULL

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

21783: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21784: THEN
21785:
21786: IF l_debug_mode = 'Y' THEN
21787: pa_debug.g_err_stage := 'Before calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||
21788: 'p_project_in.pa_project_id='||p_project_in.pa_project_id||
21789: '-l_structure_version_id='||l_structure_version_id;
21790: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
21791: END IF;

Line 21793: pa_project_structure_utils.lock_unlock_wp_str

21789: '-l_structure_version_id='||l_structure_version_id;
21790: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
21791: END IF;
21792:
21793: pa_project_structure_utils.lock_unlock_wp_str
21794: (p_project_id => p_project_in.pa_project_id
21795: ,p_structure_version_id => p_structure_in.structure_version_id
21796: ,p_lock_status_code => 'UNLOCKED'
21797: ,p_calling_module => 'PA_UPD_WBS_ATTR'

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

21799: ,x_msg_count => l_x_msg_count
21800: ,x_msg_data => l_x_msg_data);
21801:
21802: IF l_debug_mode = 'Y' THEN
21803: pa_debug.g_err_stage := 'After calling pa_project_structure_utils.lock_unlock_wp_str for UNLOCKING'||
21804: 'l_x_return_status='||l_x_return_status;
21805: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
21806: END IF;
21807:

Line 21854: pa_project_structure_utils.lock_unlock_wp_str_autonomous

21850: AND p_structure_in.structure_version_id IS NOT NULL
21851: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21852: then
21853:
21854: pa_project_structure_utils.lock_unlock_wp_str_autonomous
21855: (p_project_id => p_project_in.pa_project_id
21856: , p_structure_version_id => p_structure_in.structure_version_id
21857: , p_lock_status_code => 'UNLOCKED'
21858: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 21899: pa_project_structure_utils.lock_unlock_wp_str_autonomous

21895: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21896: then
21897:
21898:
21899: pa_project_structure_utils.lock_unlock_wp_str_autonomous
21900: (p_project_id => p_project_in.pa_project_id
21901: , p_structure_version_id => p_structure_in.structure_version_id
21902: , p_lock_status_code => 'UNLOCKED'
21903: ,p_calling_module => 'PA_UPD_WBS_ATTR'

Line 21944: pa_project_structure_utils.lock_unlock_wp_str_autonomous

21940: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21941: then
21942:
21943:
21944: pa_project_structure_utils.lock_unlock_wp_str_autonomous
21945: (p_project_id => p_project_in.pa_project_id
21946: , p_structure_version_id => p_structure_in.structure_version_id
21947: , p_lock_status_code => 'UNLOCKED'
21948: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 21996: pa_project_structure_utils.lock_unlock_wp_str_autonomous

21992: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
21993: then
21994:
21995:
21996: pa_project_structure_utils.lock_unlock_wp_str_autonomous
21997: (p_project_id => p_project_in.pa_project_id
21998: , p_structure_version_id => p_structure_in.structure_version_id
21999: , p_lock_status_code => 'UNLOCKED'
22000: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

Line 22051: pa_project_structure_utils.lock_unlock_wp_str_autonomous

22047: AND p_structure_in.structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22048: then
22049:
22050:
22051: pa_project_structure_utils.lock_unlock_wp_str_autonomous
22052: (p_project_id => p_project_in.pa_project_id
22053: , p_structure_version_id => p_structure_in.structure_version_id
22054: , p_lock_status_code => 'UNLOCKED'
22055: ,p_calling_module => 'PA_UPD_WBS_ATTR_UN' /*Bug#6414944*/

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

23326: --BUG 3919800, p_structure_version_id to l_structure_version_id, rtarway
23327: IF l_structure_version_id IS NULL
23328: OR l_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug 3174639
23329: THEN
23330: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
23331: ELSE
23332: l_structure_version_id := p_structure_version_id;
23333: END IF;
23334: -- --dbms_output.put_line('BEFORE CALLING UPDATE_task_structure');

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

23908: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
23909: PA_PROJECT_PUB.G_Published_version_exists = 'N')
23910: THEN
23911:
23912: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id -- Bug 3106457 p_pa_project_id
23913: ,p_structure_version_id => l_structure_version_id ) ; -- Bug 3106457
23914: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
23915: IF p_process_mode = 'ONLINE' THEN
23916:

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

23976:
23977: END IF;
23978: /*
23979: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_pa_project_id) = 'Y') THEN
23980: l_d_struct_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LAST_UPDATED_WORKING_VER(l_d_task_id);
23981: ELSE
23982: l_d_struct_ver_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(p_pa_project_id, 'WORKPLAN');
23983: END IF;
23984: */ --we dont need this. The structure version id is derived.

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

27591: -- PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
27592: -- PA_PROJECT_PUB.G_Published_version_exists = 'N')
27593: -- THEN
27594:
27595: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_pa_project_id
27596: ,p_structure_version_id => p_published_struct_ver_id ) ;
27597: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
27598: IF p_process_mode = 'ONLINE' THEN
27599:

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

29709: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);
29710: END IF;
29711:
29712: IF G_DLVR_STRUCTURE_ENABLED IS NULL THEN
29713: G_DLVR_STRUCTURE_ENABLED := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);
29714:
29715: IF p_debug_mode = 'Y' THEN
29716: pa_debug.g_err_stage := 'Deliverable Enabled ['||G_DLVR_STRUCTURE_ENABLED||']';
29717: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

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

29729: -- error message is thrown. So, removing the below code , which enables the structure for the target project in
29730: -- above condition.
29731:
29732: /*
29733: l_dlvr_enabled := Pa_Project_Structure_Utils.Check_Deliverable_Enabled(l_project_id);
29734:
29735: IF p_debug_mode = 'Y' THEN
29736: pa_debug.g_err_stage := 'Deliverable Enabled ['||l_dlvr_enabled||']';
29737: pa_debug.write(g_pkg_name,pa_debug.g_err_stage,3);

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

33495: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33496: l_wp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33497: IF (l_wp_structure_version_id = -1 OR l_wp_structure_version_id = NULL)
33498: THEN
33499: l_wp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
33500: END IF;
33501: END IF;
33502: ELSIF(p_wp_structure_version_id IS NOT NULL AND p_wp_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
33503: THEN

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

33850: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
33851: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
33852: IF (l_wkp_structure_version_id = -1 OR l_wkp_structure_version_id = NULL)
33853: THEN
33854: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
33855: END IF;
33856: END IF;
33857: END IF;
33858: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

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

34197: IF (l_wkp_task_id IS NOT NULL AND l_wkp_structure_version_id IS NULL ) THEN
34198: IF (PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS(l_project_id) = 'Y') THEN
34199: l_wkp_structure_version_id := PA_PROJ_ELEMENTS_UTILS.LATEST_PUBLISHED_VER_ID(l_project_id, 'WORKPLAN');
34200: IF (l_wkp_structure_version_id IS NULL OR l_wkp_structure_version_id = -1) THEN
34201: l_wkp_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(l_project_id);
34202: END IF;
34203: END IF;
34204: END IF;
34205: l_wkp_task_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID

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

34547: RAISE FND_API.G_EXC_ERROR;
34548: END IF;
34549: --
34550: --Bug 3768875
34551: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34552: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34553: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34554: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34555: RAISE FND_API.G_EXC_ERROR;

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

34548: END IF;
34549: --
34550: --Bug 3768875
34551: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34552: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34553: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34554: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34555: RAISE FND_API.G_EXC_ERROR;
34556: End If;

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

34805: RAISE FND_API.G_EXC_ERROR;
34806: END IF;
34807: --
34808: --Bug 3769089
34809: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34810: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34812: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34813:

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

34806: END IF;
34807: --
34808: --Bug 3769089
34809: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
34810: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
34811: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
34812: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
34813:
34814: RAISE FND_API.G_EXC_ERROR;

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

35066: RAISE FND_API.G_EXC_ERROR;
35067: END IF;
35068: --
35069: --Bug 3769079
35070: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35071: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35072: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35073: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35074: RAISE FND_API.G_EXC_ERROR;

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

35067: END IF;
35068: --
35069: --Bug 3769079
35070: If PA_PROJECT_STRUCTURE_UTILS.Check_Project_exists(l_project_id) = 'Y' Then
35071: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id,p_structure_version_id) <> 'Y' THEN
35072: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35073: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35074: RAISE FND_API.G_EXC_ERROR;
35075: End If;

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

35532: l_pub_ver_exists := PA_PROJ_TASK_STRUC_PUB.Published_version_exists( l_project_id );
35533:
35534: -- If this passed task belongs to a Split - Fin. Only structure
35535: IF nvl(l_wp_str_exists,'N') = 'N'
35536: AND (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id, 'FINANCIAL') = 'Y')
35537: THEN
35538: -- Its ok to delete this task
35539: l_check_task_mfd_flag := 'Y' ;
35540:

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

35538: -- Its ok to delete this task
35539: l_check_task_mfd_flag := 'Y' ;
35540:
35541: -- If this passed task belongs to a WP structure (be it shared or be it split)
35542: ELSIF PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(l_structure_version_id,'WORKPLAN') = 'Y'
35543: THEN
35544: IF l_versioning_enabled = 'Y'
35545: AND l_pub_ver_exists = 'Y'
35546: THEN

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

35799: END IF;
35800:
35801: END IF;
35802:
35803: If PA_PROJECT_STRUCTURE_UTILS.Check_Structure_Ver_Exists(l_project_id, p_structure_version_id) <> 'Y' THEN
35804: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
35805: p_msg_name => 'PA_INV_STRUCUTRE_VER_ID');
35806:
35807: RAISE FND_API.G_EXC_ERROR;

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

35862: RAISE FND_API.G_EXC_ERROR;
35863: END IF;
35864:
35865: --Bug# 5973460
35866: l_process_code := PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_CODE(p_project_id => l_project_id
35867: ,p_structure_version_id => p_structure_version_id );
35868:
35869: IF l_process_code = 'PUE'
35870: THEN

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

35876: --Bug# 5973460
35877:
35878: -- check the process_update_wbs_flag
35879:
35880: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => l_project_id
35881: ,p_structure_version_id => p_structure_version_id ) ;
35882:
35883: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
35884:

Line 35885: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(

35881: ,p_structure_version_id => p_structure_version_id ) ;
35882:
35883: IF nvl(l_update_wbs_flag,'N') = 'Y' THEN
35884:
35885: PA_PROJECT_STRUCTURE_UTILS.GET_PROCESS_STATUS_MSG(
35886: p_project_id => l_project_id
35887: , p_structure_version_id => p_structure_version_id
35888: , p_context => 'UPDATE_AMG'
35889: , x_message_name => l_message_name

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

36224: raise FND_API.G_EXC_ERROR;
36225: end if;
36226:
36227: -- Get the current attributes of the project.
36228: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36229: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36230: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36231: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36232:

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

36225: end if;
36226:
36227: -- Get the current attributes of the project.
36228: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36229: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36230: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36231: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36232:
36233: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.

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

36226:
36227: -- Get the current attributes of the project.
36228: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36229: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36230: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36231: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36232:
36233: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.
36234: if ((p_sys_program_flag = 'Y') or (p_sys_program_flag = 'N')) then

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

36227: -- Get the current attributes of the project.
36228: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(l_project_id);
36229: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(l_project_id);
36230: l_delv_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_deliverable_enabled(l_project_id);
36231: l_share_code := PA_PROJECT_STRUCTURE_UTILS.Get_Structure_sharing_code(l_project_id);
36232:
36233: -- Check if valid values are passed into the parameters: p_sys_program_flag, p_allow_multi_program_rollup, else use the current values.
36234: if ((p_sys_program_flag = 'Y') or (p_sys_program_flag = 'N')) then
36235: l_sys_program_flag := p_sys_program_flag;

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

36665: -- If the responsibility does not allow a function to be executed the API
36666: -- will error out as the user does not have access.
36667: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
36668: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
36669: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
36670: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
36671: (p_api_version_number => p_api_version
36672: , p_responsibility_id => FND_GLOBAL.RESP_ID
36673: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

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

36701: end if;
36702:
36703: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
36704: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
36705: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
36706: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
36707: (p_api_version_number => p_api_version
36708: , p_responsibility_id => FND_GLOBAL.RESP_ID
36709: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

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

36738:
36739: -- Check if the sub-project has the appropriate structure type enabled.
36740: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
36741: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN') then
36742: if (pa_project_structure_utils.check_workplan_enabled(l_sub_project_id) = 'N') then
36743:
36744: open l_cur_proj_name(l_sub_project_id);
36745: fetch l_cur_proj_name into l_project_name;
36746: close l_cur_proj_name;

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

36752: l_parent_sub_flag := 'S'; -- Indicates that the error is for the sub-project.
36753:
36754: end if;
36755: elsif (p_program_links_tbl(l_count).structure_type = 'FINANCIAL') then
36756: if (pa_project_structure_utils.check_financial_enabled(l_sub_project_id) = 'N') then
36757:
36758: open l_cur_proj_name(l_sub_project_id);
36759: fetch l_cur_proj_name into l_project_name;
36760: close l_cur_proj_name;

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

37279: -- If the responsibility does not allow a function to be executed the API
37280: -- will error out as the user does not have access.
37281: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37282: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
37283: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37284: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37285: (p_api_version_number => p_api_version
37286: , p_responsibility_id => FND_GLOBAL.RESP_ID
37287: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

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

37316: end if;
37317:
37318: if (l_exp_error_flag = 'N' and l_unexp_error_flag = 'N') then -- Indicates no errors thus far in the loop iteration.
37319: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
37320: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37321: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37322: (p_api_version_number => p_api_version
37323: , p_responsibility_id => FND_GLOBAL.RESP_ID
37324: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

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

37803: -- Actions performed using the APIs are subject to function security.
37804: -- If the responsibility does not allow a function to be executed the API
37805: -- will error out as the user does not have access.
37806: if (p_structure_type = 'WORKPLAN'
37807: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37808: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37809: (p_api_version_number => p_api_version
37810: , p_responsibility_id => FND_GLOBAL.RESP_ID
37811: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'

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

37835: end if;
37836: end if;
37837:
37838: if (p_structure_type = 'FINANCIAL'
37839: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37840: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37841: (p_api_version_number => p_api_version
37842: , p_responsibility_id => FND_GLOBAL.RESP_ID
37843: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'

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

37992:
37993:
37994: BEGIN
37995:
37996: l_published_version := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_pa_project_id);
37997:
37998: OPEN c_prev_published_version(p_pa_project_id);
37999: FETCH c_prev_published_version INTO l_prev_published_version;
38000: CLOSE c_prev_published_version;