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_PROJ_TASK_STRUC_PUB dependencies on PA_PROJECT_PUB

Line 985: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2732895

981: ;
982: l_dummy_num number;
983: /* Bug 2736392 End */
984:
985: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2732895
986:
987: --bug 2824612
988: l_wq_planned_quantity NUMBER;
989: l_task_type_id NUMBER;

Line 2090: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

2086: x_msg_data => l_msg_data
2087: );
2088: exception
2089: when others then
2090: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2091: p_procedure_name => 'CREATE_PROJECT',
2092: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
2093: raise fnd_api.g_exc_error;
2094: end;

Line 2110: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

2106: ,x_msg_data => l_msg_data
2107: );
2108: exception
2109: when others then
2110: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2111: p_procedure_name => 'CREATE_PROJECT',
2112: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
2113: raise fnd_api.g_exc_error;
2114: end;

Line 2422: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2856033

2418: l_wq_planned_quantity NUMBER;
2419: l_task_type_id NUMBER;
2420: --bug 2824612
2421:
2422: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2856033
2423: l_process_code VARCHAR2(30);
2424:
2425: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE; -- Bug 3091798
2426:

Line 3366: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

3362: x_msg_data => l_msg_data
3363: );
3364: exception
3365: when others then
3366: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3367: p_procedure_name => 'CREATE_PROJECT',
3368: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
3369: raise fnd_api.g_exc_error;
3370: end;

Line 3425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

3421: ,x_msg_data => l_msg_data
3422: );
3423: exception
3424: when others then
3425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3426: p_procedure_name => 'CREATE_PROJECT',
3427: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
3428: raise fnd_api.g_exc_error;
3429: end;

Line 4384: -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created

4380: -- History
4381: --
4382: -- 25-MAY-02 MAansari -Created
4383: --
4384: -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created
4385: -- by calling copy structure api. Copy structure api copies template's tasks to pro_elements though there
4386: -- are no pa_TASKs for the new project. However pa_tasks and pa_proj_elements must be in syn. To d this we need to firts remove
4387: -- tasks from pa_proj_elements as they were erroneously created by COPY_STRUCTURE and then call create_default_structure
4388: -- to syn up pa_pro_elements with pa_tasks.

Line 4483: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

4479: -- is checked
4480:
4481: /*PROCEDURE get_task_above(
4482: p_task_id IN NUMBER
4483: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
4484: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
4485: ,x_task_id_above OUT NUMBER
4486: ,x_return_status OUT VARCHAR2
4487: ) IS

Line 4484: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

4480:
4481: /*PROCEDURE get_task_above(
4482: p_task_id IN NUMBER
4483: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
4484: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
4485: ,x_task_id_above OUT NUMBER
4486: ,x_return_status OUT VARCHAR2
4487: ) IS
4488:

Line 5844: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

5840: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
5841: ,p_project_id IN NUMBER
5842: ,p_structure_version_id IN NUMBER
5843: ,p_pm_product_code IN VARCHAR2 := 'JUNK_CHARS'
5844: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
5845: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5846: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5847: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
5848:

Line 6051: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project

6047: END create_tasks_versions_only;
6048:
6049:
6050: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS
6051: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project
6052:
6053: PROCEDURE recalc_task_weightings(
6054: p_tasks_in IN pa_project_pub.task_out_tbl_type
6055: ,p_task_version_id IN NUMBER

Line 6054: p_tasks_in IN pa_project_pub.task_out_tbl_type

6050: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS
6051: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project
6052:
6053: PROCEDURE recalc_task_weightings(
6054: p_tasks_in IN pa_project_pub.task_out_tbl_type
6055: ,p_task_version_id IN NUMBER
6056: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6057: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6058: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 10849: --IF pa_project_pub.G_structure_in_rec.structure_version_name is NOT NULL AND pa_project_pub.G_structure_in_rec.structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN

10845: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
10846: and lookup_code = 'WORKPLAN';
10847:
10848: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
10849: --IF pa_project_pub.G_structure_in_rec.structure_version_name is NOT NULL AND pa_project_pub.G_structure_in_rec.structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
10850: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
10851: --ELSE
10852: l_name := substr(l_project_name, 1, 240);
10853: --END IF;

Line 10850: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;

10846: and lookup_code = 'WORKPLAN';
10847:
10848: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
10849: --IF pa_project_pub.G_structure_in_rec.structure_version_name is NOT NULL AND pa_project_pub.G_structure_in_rec.structure_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
10850: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
10851: --ELSE
10852: l_name := substr(l_project_name, 1, 240);
10853: --END IF;
10854: -- Bug 3717026 End

Line 11081: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'

11077: and pst.structure_type in ('WORKPLAN','FINANCIAL');
11078:
11079: --bug 3138959
11080: IF l_shared = 'N' AND l_workplan_enabled = 'Y' -- For Split structures
11081: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'
11082: THEN
11083: FOR cur_pa_struct_rec in cur_pa_struct LOOP
11084: IF cur_pa_struct_rec.structure_type_id = 6 --Financial
11085: THEN

Line 12282: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'

12278: --User adding tasks under WORKPLAN structure from AMG, financial plan should be copied over.
12279:
12280: IF PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( l_struc_version_id, 'FINANCIAL' ) = 'Y'
12281: AND l_shared = 'N' AND l_workplan_enabled = 'Y' -- For Split structures
12282: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'
12283: THEN
12284: --Copy financial tasks
12285:
12286: INSERT INTO pa_proj_element_versions(

Line 13164: p_tasks_in IN pa_project_pub.task_out_tbl_type

13160: END get_task_version_id;
13161:
13162:
13163: PROCEDURE rollup_dates(
13164: p_tasks_in IN pa_project_pub.task_out_tbl_type
13165: ,p_task_version_id IN NUMBER := null
13166: ,p_structure_version_id IN NUMBER
13167: ,p_project_id IN NUMBER
13168: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 13203: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.

13199:
13200: ELSIF ( p_tasks_in(i).pa_task_id IS NOT NULL AND p_tasks_in(i).pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND
13201: ( p_tasks_in(i).task_version_id IS NULL OR p_tasks_in(i).task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) AND p_structure_version_id IS NOT NULL
13202: THEN
13203: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13204: --in this case we have to pick this from databse.
13205: get_task_version_id(
13206: p_project_id => p_project_id
13207: ,p_task_id => p_tasks_in(i).pa_task_id

Line 13253: This API is called from pa_project_pub.create_project and does the

13249: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Bug3044915
13250: END rollup_dates;
13251:
13252: /*==================================================================
13253: This API is called from pa_project_pub.create_project and does the
13254: processing to create the structure information for the tasks.
13255: Included the api for Post FP K one off. Bug 2931183
13256: This API is called from pa_project_pub.update_project which passes
13257: the structure version id through p_structure_version_id parameter.

Line 13256: This API is called from pa_project_pub.update_project which passes

13252: /*==================================================================
13253: This API is called from pa_project_pub.create_project and does the
13254: processing to create the structure information for the tasks.
13255: Included the api for Post FP K one off. Bug 2931183
13256: This API is called from pa_project_pub.update_project which passes
13257: the structure version id through p_structure_version_id parameter.
13258: The complete WBS is passed to this API in p_tasks_in_tbl. Depending
13259: on whether the task is an existing task or a new task, task creation
13260: or task updation is performed.

Line 13272: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type

13268: ,p_project_id IN pa_projects_all.project_id%TYPE
13269: ,p_source_project_id IN pa_projects_all.project_id%TYPE
13270: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
13271: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
13272: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type
13273: ,p_create_task_version_only IN VARCHAR2
13274: ,p_wp_str_exists IN VARCHAR2
13275: ,p_is_wp_separate_from_fn IN VARCHAR2
13276: ,p_is_wp_versioning_enabled IN VARCHAR2

Line 13283: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type

13279: -- PA L Changes 3010538
13280: ,p_process_mode IN VARCHAR2
13281: -- Bug 3075609. To identify create task version only context.
13282: ,p_create_task_versions_only IN VARCHAR2
13283: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type
13284: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13285: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13286: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
13287: AS

Line 13459: l_task_in_rec pa_project_pub.task_in_rec_type;

13455: -- structure version or be creating a new structure version. We need
13456: -- to differentiate the two scenarios.
13457:
13458: -- rec that contains all tasks information.
13459: l_task_in_rec pa_project_pub.task_in_rec_type;
13460:
13461: -- proj element level variables
13462: l_task_id pa_tasks.task_id%TYPE; -- task id of the current task being processed in loop
13463: l_parent_task_id pa_tasks.parent_task_id%TYPE; -- parent task id of the current task being processed in loop

Line 13605: l_taskin_rec pa_project_pub.task_in_rec_type;

13601: l_proj_elements_info cur_proj_elements_info%ROWTYPE; */
13602: /** changes end for bug 4120380 by aditi **/
13603: l_task_cur_rec l_task_cur%rowtype;
13604:
13605: l_taskin_rec pa_project_pub.task_in_rec_type;
13606: l_taskout_rec pa_project_pub.task_out_rec_type;
13607:
13608: l_i NUMBER;
13609: --Added by rtarway for BUG 4059962

Line 13606: l_taskout_rec pa_project_pub.task_out_rec_type;

13602: /** changes end for bug 4120380 by aditi **/
13603: l_task_cur_rec l_task_cur%rowtype;
13604:
13605: l_taskin_rec pa_project_pub.task_in_rec_type;
13606: l_taskout_rec pa_project_pub.task_out_rec_type;
13607:
13608: l_i NUMBER;
13609: --Added by rtarway for BUG 4059962
13610: l_financial_task_flag VARCHAR2(1);

Line 13940: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.

13936: and are not present in the published versions should be deleted right away and the MSP should not show any message.
13937:
13938: Analysis:
13939: ---------
13940: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.
13941: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
13942: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
13943: pa_project_pub.execute_update_project are called.
13944:

Line 13942: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and

13938: Analysis:
13939: ---------
13940: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.
13941: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
13942: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
13943: pa_project_pub.execute_update_project are called.
13944:
13945: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
13946:

Line 13943: pa_project_pub.execute_update_project are called.

13939: ---------
13940: This is happening due to value 'M' being returned from the PA_PROJECT_PUB.check_task_mfd APIs OUT param p_check_task_mfd_flag.
13941: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
13942: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
13943: pa_project_pub.execute_update_project are called.
13944:
13945: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
13946:
13947: Inside this API the following code is used to derive the value for task_unpub_ver_status_code column.

Line 13945: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.

13941: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
13942: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
13943: pa_project_pub.execute_update_project are called.
13944:
13945: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
13946:
13947: Inside this API the following code is used to derive the value for task_unpub_ver_status_code column.
13948: This is correct. But after this piece of code all the passed in tasks are processed in a loop. In the
13949: loop the same variable l_task_unpub_ver_status_code is used to get the other tasks status. Hence the

Line 14135: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND

14131: -- In the following conditions we will be recalculating the weightages completely. So we need to
14132: -- take care of the rest of the scenarios. Where we need not take care we will just set the task
14133: -- weightage to 0.
14134: IF NOT (
14135: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14136: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14137: ) OR
14138: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14139: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

Line 14138: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

14134: IF NOT (
14135: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14136: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14137: ) OR
14138: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14139: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14140: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14141: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14142: ) OR

Line 14139: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

14135: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14136: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14137: ) OR
14138: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14139: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14140: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14141: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14142: ) OR
14143: (

Line 14140: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND

14136: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14137: ) OR
14138: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14139: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14140: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14141: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14142: ) OR
14143: (
14144: nvl(l_task_weight_basis_code,'-1') = 'MANUAL' AND

Line 14301: IF (PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR') THEN --bug 4534919

14297: ,p_attribute5 => '');
14298: RAISE Invalid_Arg_Exc_WP;
14299: END IF;
14300: --rtarway, for DHI ER, BUG 4413568
14301: IF (PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
14302: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14303: p_msg_name => 'PA_WBS_CANT_CHANGE');
14304: RAISE Invalid_Arg_Exc_WP;
14305: END IF;

Line 14888: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

14884: END IF;
14885:
14886: END;
14887: --rtarway, added for BUG 4106154
14888: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14889: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14890: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
14891: --Added by rtarway for BUG 4321313
14892: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'

Line 14889: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

14885:
14886: END;
14887: --rtarway, added for BUG 4106154
14888: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14889: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14890: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
14891: --Added by rtarway for BUG 4321313
14892: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'
14893: )

Line 14890: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND

14886: END;
14887: --rtarway, added for BUG 4106154
14888: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14889: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14890: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
14891: --Added by rtarway for BUG 4321313
14892: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'
14893: )
14894: THEN

Line 15629: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919

15625: -- the number of tasks in the create project context)
15626: IF (l_parent_task_version_id <> l_db_parent_task_version_id)
15627: THEN
15628: --rtarway, for DHI ER, BUG 4413568
15629: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
15630: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15631: p_msg_name => 'PA_WBS_CANT_CHANGE');
15632: RAISE Invalid_Arg_Exc_WP;
15633: END IF;

Line 15973: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919

15969: -- Set the following variables after calling PA_RELATIONSHIP_PUB.Create_Relationship
15970: -- px_tasks_out_tbl(i).return_status
15971: --rtarway, for DHI ER, BUG 4413568
15972: /*
15973: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
15974: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15975: p_msg_name => 'PA_WBS_CANT_CHANGE');
15976: RAISE Invalid_Arg_Exc_WP;
15977: END IF;

Line 16265: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',

16261: );
16262:
16263: EXCEPTION
16264: WHEN OTHERS THEN
16265: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16266: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16267: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
16268: raise fnd_api.g_exc_error;
16269: END;

Line 16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR

16624: --END IF;
16625:
16626: IF p_structure_type = 'FINANCIAL'
16627: THEN
16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )

Line 16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR

16625:
16626: IF p_structure_type = 'FINANCIAL'
16627: THEN
16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
16633: THEN

Line 16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

16626: IF p_structure_type = 'FINANCIAL'
16627: THEN
16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
16633: THEN
16634: pa_fp_refresh_elements_pub.set_process_flag_proj(

Line 16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

16627: THEN
16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
16633: THEN
16634: pa_fp_refresh_elements_pub.set_process_flag_proj(
16635: p_project_id => p_project_id

Line 16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )

16628: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
16629: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
16630: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16631: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16632: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
16633: THEN
16634: pa_fp_refresh_elements_pub.set_process_flag_proj(
16635: p_project_id => p_project_id
16636: ,p_request_id => null

Line 16751: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR

16747: END IF; -- p_is_wp_separate_from_fn = 'N' OR (p_is_wp_separate_from_fn = 'Y' and p_structure_type = 'WORKPLAN')
16748:
16749: -- PA L Changes 3010538
16750:
16751: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
16752: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16753: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16754: PA_PROJECT_PUB.G_Published_version_exists = 'N')
16755: THEN

Line 16752: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

16748:
16749: -- PA L Changes 3010538
16750:
16751: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
16752: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16753: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16754: PA_PROJECT_PUB.G_Published_version_exists = 'N')
16755: THEN
16756:

Line 16753: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

16749: -- PA L Changes 3010538
16750:
16751: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
16752: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16753: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16754: PA_PROJECT_PUB.G_Published_version_exists = 'N')
16755: THEN
16756:
16757: -- Changed p_structure_version_id to l_structure_version_id Bug 3035902.

Line 16754: PA_PROJECT_PUB.G_Published_version_exists = 'N')

16750:
16751: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
16752: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
16753: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
16754: PA_PROJECT_PUB.G_Published_version_exists = 'N')
16755: THEN
16756:
16757: -- Changed p_structure_version_id to l_structure_version_id Bug 3035902.
16758: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_project_id

Line 16846: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',

16842: ,x_msg_data => l_msg_data
16843: );
16844: EXCEPTION
16845: WHEN OTHERS THEN
16846: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16847: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16848: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
16849: raise fnd_api.g_exc_error;
16850: END;

Line 16984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',

16980: ,x_msg_data => l_msg_data
16981: );
16982: EXCEPTION
16983: WHEN OTHERS THEN
16984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16985: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16986: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
16987: raise fnd_api.g_exc_error;
16988: END;

Line 17017: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',

17013: ,x_msg_data => l_msg_data
17014: );
17015: EXCEPTION
17016: WHEN OTHERS THEN
17017: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17018: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17019: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17020: raise fnd_api.g_exc_error;
17021: END;

Line 17091: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

17087: -- null;--BUG 3802469, rtarway
17088: -- end if;
17089: -- exception
17090: -- when others then
17091: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17092: -- p_procedure_name => 'CREATE_PROJECT',
17093: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17094: -- raise fnd_api.g_exc_error;
17095: -- end;

Line 17118: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

17114: -- null;
17115: -- end if;
17116: -- exception
17117: -- when others then
17118: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17119: -- p_procedure_name => 'CREATE_PROJECT',
17120: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17121: -- raise fnd_api.g_exc_error;
17122: -- end;

Line 17179: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

17175: -- null;
17176: -- end if;
17177: -- exception
17178: -- when others then
17179: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17180: -- p_procedure_name => 'CREATE_PROJECT',
17181: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17182: -- raise fnd_api.g_exc_error;
17183: -- end;

Line 17205: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',

17201: -- null;
17202: -- end if;
17203: -- exception
17204: -- when others then
17205: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17206: -- p_procedure_name => 'CREATE_PROJECT',
17207: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17208: -- raise fnd_api.g_exc_error;
17209: -- end;