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 14: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,

10: PROCEDURE handle_task_number_change
11: ( p_project_id IN NUMBER,
12: p_task_id IN NUMBER,
13: p_in_task_number IN VARCHAR2,
14: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,
15: p_structure_id IN NUMBER ,
16: p_debug_mode IN VARCHAR2 := 'N',
17: p_return_status OUT NOCOPY VARCHAR2
18: ) IS

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

1197: ;
1198: l_dummy_num number;
1199: /* Bug 2736392 End */
1200:
1201: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2732895
1202:
1203: --bug 2824612
1204: l_wq_planned_quantity NUMBER;
1205: l_task_type_id NUMBER;

Line 1889: (l_versioned = 'N') AND NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' AND -- Check roll up flag to defer roll ups 14556729

1885:
1886: IF (PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id) = 'Y') AND
1887: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1888: /* (PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id) = 'N') AND */
1889: (l_versioned = 'N') AND NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' AND -- Check roll up flag to defer roll ups 14556729
1890: (PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN') = 'Y') THEN
1891: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
1892: p_structure_version_id => l_parent_struc_ver_id
1893: ,p_element_version_id => l_task_version_id

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

2302: x_msg_data => l_msg_data
2303: );
2304: exception
2305: when others then
2306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2307: p_procedure_name => 'CREATE_PROJECT',
2308: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
2309: raise fnd_api.g_exc_error;
2310: end;

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

2322: ,x_msg_data => l_msg_data
2323: );
2324: exception
2325: when others then
2326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2327: p_procedure_name => 'CREATE_PROJECT',
2328: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
2329: raise fnd_api.g_exc_error;
2330: end;

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

2635: l_wq_planned_quantity NUMBER;
2636: l_task_type_id NUMBER;
2637: --bug 2824612
2638:
2639: l_tasks_out pa_project_pub.task_out_tbl_type ; --dummy variables. --bug 2856033
2640: l_process_code VARCHAR2(30);
2641:
2642: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE; -- Bug 3091798
2643:

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

3580: x_msg_data => l_msg_data
3581: );
3582: exception
3583: when others then
3584: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3585: p_procedure_name => 'CREATE_PROJECT',
3586: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
3587: raise fnd_api.g_exc_error;
3588: end;

Line 3610: if (l_structure_version_id is not null AND NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' ) then

3606: IF (p_structure_type = 'WORKPLAN' OR
3607: nvl(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN( p_project_id ),'N') = 'N')
3608: THEN
3609: /* 14556729:Added for Huawei changes for update update flow */
3610: if (l_structure_version_id is not null AND NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' ) then
3611: FOR l_task_cur_rec in l_task_cur(p_project_id, l_structure_version_id) LOOP
3612:
3613: -- Bug 7437034 (Initialize l_hidden_assgn to N for each iteration)
3614: l_hidden_assgn := 'N';

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

3642: ,x_msg_data => l_msg_data
3643: );
3644: exception
3645: when others then
3646: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3647: p_procedure_name => 'CREATE_PROJECT',
3648: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
3649: raise fnd_api.g_exc_error;
3650: end;

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

4601: -- History
4602: --
4603: -- 25-MAY-02 MAansari -Created
4604: --
4605: -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created
4606: -- by calling copy structure api. Copy structure api copies template's tasks to pro_elements though there
4607: -- 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
4608: -- tasks from pa_proj_elements as they were erroneously created by COPY_STRUCTURE and then call create_default_structure
4609: -- to syn up pa_pro_elements with pa_tasks.

Line 4704: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

4700: -- is checked
4701:
4702: /*PROCEDURE get_task_above(
4703: p_task_id IN NUMBER
4704: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
4705: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
4706: ,x_task_id_above OUT NUMBER
4707: ,x_return_status OUT VARCHAR2
4708: ) IS

Line 4705: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

4701:
4702: /*PROCEDURE get_task_above(
4703: p_task_id IN NUMBER
4704: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
4705: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
4706: ,x_task_id_above OUT NUMBER
4707: ,x_return_status OUT VARCHAR2
4708: ) IS
4709:

Line 6065: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

6061: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
6062: ,p_project_id IN NUMBER
6063: ,p_structure_version_id IN NUMBER
6064: ,p_pm_product_code IN VARCHAR2 := 'JUNK_CHARS'
6065: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
6066: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6067: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6068: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
6069:

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

6296: END create_tasks_versions_only;
6297:
6298:
6299: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS
6300: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project
6301:
6302: PROCEDURE recalc_task_weightings(
6303: p_tasks_in IN pa_project_pub.task_out_tbl_type
6304: ,p_task_version_id IN NUMBER

Line 6303: p_tasks_in IN pa_project_pub.task_out_tbl_type

6299: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS
6300: --The API is called from PA_PROJECT_PUB.create_project and PA_PROJECT_PUB.update_project
6301:
6302: PROCEDURE recalc_task_weightings(
6303: p_tasks_in IN pa_project_pub.task_out_tbl_type
6304: ,p_task_version_id IN NUMBER
6305: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6306: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6307: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

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

11160: where lookup_type = 'PA_STRUCTURE_TYPE_CLASS'
11161: and lookup_code = 'WORKPLAN';
11162:
11163: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
11164: --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
11165: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
11166: --ELSE
11167: l_name := substr(l_project_name, 1, 240);
11168: --END IF;

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

11161: and lookup_code = 'WORKPLAN';
11162:
11163: -- Bug 3717026 Begin, commented as the structure name should be same as the project name.
11164: --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
11165: --l_name := pa_project_pub.G_structure_in_rec.structure_version_name;
11166: --ELSE
11167: l_name := substr(l_project_name, 1, 240);
11168: --END IF;
11169: -- Bug 3717026 End

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

11392: and pst.structure_type in ('WORKPLAN','FINANCIAL');
11393:
11394: --bug 3138959
11395: IF l_shared = 'N' AND l_workplan_enabled = 'Y' -- For Split structures
11396: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'
11397: THEN
11398: FOR cur_pa_struct_rec in cur_pa_struct LOOP
11399: IF cur_pa_struct_rec.structure_type_id = 6 --Financial
11400: THEN

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

12605: --User adding tasks under WORKPLAN structure from AMG, financial plan should be copied over.
12606:
12607: IF PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version( l_struc_version_id, 'FINANCIAL' ) = 'Y'
12608: AND l_shared = 'N' AND l_workplan_enabled = 'Y' -- For Split structures
12609: AND pa_project_pub.G_structure_in_rec.structure_type = 'WORKPLAN'
12610: THEN
12611: --Copy financial tasks
12612:
12613: INSERT INTO pa_proj_element_versions(

Line 13493: p_tasks_in IN pa_project_pub.task_out_tbl_type

13489: END get_task_version_id;
13490:
13491:
13492: PROCEDURE rollup_dates(
13493: p_tasks_in IN pa_project_pub.task_out_tbl_type
13494: ,p_task_version_id IN NUMBER := null
13495: ,p_structure_version_id IN NUMBER
13496: ,p_project_id IN NUMBER
13497: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

13528:
13529: 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
13530: ( 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
13531: THEN
13532: --PA_PROJECT_PUB.update_project does not populate task versions for the tasks being updated.
13533: --in this case we have to pick this from databse.
13534: get_task_version_id(
13535: p_project_id => p_project_id
13536: ,p_task_id => p_tasks_in(i).pa_task_id

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

13592:
13593: END rollup_dates;
13594:
13595: /*==================================================================
13596: This API is called from pa_project_pub.create_project and does the
13597: processing to create the structure information for the tasks.
13598: Included the api for Post FP K one off. Bug 2931183
13599: This API is called from pa_project_pub.update_project which passes
13600: the structure version id through p_structure_version_id parameter.

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

13595: /*==================================================================
13596: This API is called from pa_project_pub.create_project and does the
13597: processing to create the structure information for the tasks.
13598: Included the api for Post FP K one off. Bug 2931183
13599: This API is called from pa_project_pub.update_project which passes
13600: the structure version id through p_structure_version_id parameter.
13601: The complete WBS is passed to this API in p_tasks_in_tbl. Depending
13602: on whether the task is an existing task or a new task, task creation
13603: or task updation is performed.

Line 13615: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type

13611: ,p_project_id IN pa_projects_all.project_id%TYPE
13612: ,p_source_project_id IN pa_projects_all.project_id%TYPE
13613: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
13614: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
13615: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type
13616: ,p_create_task_version_only IN VARCHAR2
13617: ,p_wp_str_exists IN VARCHAR2
13618: ,p_is_wp_separate_from_fn IN VARCHAR2
13619: ,p_is_wp_versioning_enabled IN VARCHAR2

Line 13626: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type

13622: -- PA L Changes 3010538
13623: ,p_process_mode IN VARCHAR2
13624: -- Bug 3075609. To identify create task version only context.
13625: ,p_create_task_versions_only IN VARCHAR2
13626: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type
13627: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13628: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13629: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
13630: AS

Line 13806: l_task_in_rec pa_project_pub.task_in_rec_type;

13802: -- structure version or be creating a new structure version. We need
13803: -- to differentiate the two scenarios.
13804:
13805: -- rec that contains all tasks information.
13806: l_task_in_rec pa_project_pub.task_in_rec_type;
13807:
13808: -- proj element level variables
13809: l_task_id pa_tasks.task_id%TYPE; -- task id of the current task being processed in loop
13810: l_parent_task_id pa_tasks.parent_task_id%TYPE; -- parent task id of the current task being processed in loop

Line 13952: l_taskin_rec pa_project_pub.task_in_rec_type;

13948: l_proj_elements_info cur_proj_elements_info%ROWTYPE; */
13949: /** changes end for bug 4120380 by aditi **/
13950: l_task_cur_rec l_task_cur%rowtype;
13951:
13952: l_taskin_rec pa_project_pub.task_in_rec_type;
13953: l_taskout_rec pa_project_pub.task_out_rec_type;
13954:
13955: l_i NUMBER;
13956: --Added by rtarway for BUG 4059962

Line 13953: l_taskout_rec pa_project_pub.task_out_rec_type;

13949: /** changes end for bug 4120380 by aditi **/
13950: l_task_cur_rec l_task_cur%rowtype;
13951:
13952: l_taskin_rec pa_project_pub.task_in_rec_type;
13953: l_taskout_rec pa_project_pub.task_out_rec_type;
13954:
13955: l_i NUMBER;
13956: --Added by rtarway for BUG 4059962
13957: l_financial_task_flag VARCHAR2(1);

Line 14445: 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.

14441: and are not present in the published versions should be deleted right away and the MSP should not show any message.
14442:
14443: Analysis:
14444: ---------
14445: 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.
14446: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
14447: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
14448: pa_project_pub.execute_update_project are called.
14449:

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

14443: Analysis:
14444: ---------
14445: 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.
14446: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
14447: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
14448: pa_project_pub.execute_update_project are called.
14449:
14450: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
14451:

Line 14448: pa_project_pub.execute_update_project are called.

14444: ---------
14445: 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.
14446: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
14447: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
14448: pa_project_pub.execute_update_project are called.
14449:
14450: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
14451:
14452: Inside this API the following code is used to derive the value for task_unpub_ver_status_code column.

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

14446: This was happening due to the value 'PUBLISHED' was populated in the task_unpub_ver_status_code column.
14447: When ever a task is created in MSP and sent to oracle projects the pa_project_pub.load_project and
14448: pa_project_pub.execute_update_project are called.
14449:
14450: The pa_project_pub.execute_update_project -> update_project API ...> PA_PROJ_TASK_STRUC_PUB.PROCESS_TASK_STRUCTURE_BULK is called.
14451:
14452: Inside this API the following code is used to derive the value for task_unpub_ver_status_code column.
14453: This is correct. But after this piece of code all the passed in tasks are processed in a loop. In the
14454: loop the same variable l_task_unpub_ver_status_code is used to get the other tasks status. Hence the

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

14636: -- In the following conditions we will be recalculating the weightages completely. So we need to
14637: -- take care of the rest of the scenarios. Where we need not take care we will just set the task
14638: -- weightage to 0.
14639: IF NOT (
14640: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14641: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14642: ) OR
14643: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14644: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

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

14639: IF NOT (
14640: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14641: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14642: ) OR
14643: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14644: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14645: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14646: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14647: ) OR

Line 14644: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

14640: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' AND
14641: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14642: ) OR
14643: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14644: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14645: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14646: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14647: ) OR
14648: (

Line 14645: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND

14641: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14642: ) OR
14643: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
14644: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
14645: PA_PROJECT_PUB.G_Published_version_exists = 'N' AND
14646: nvl(l_task_weight_basis_code,'-1') <> 'MANUAL'
14647: ) OR
14648: (
14649: nvl(l_task_weight_basis_code,'-1') = 'MANUAL' AND

Line 14739: IF (NVL(PA_PROJECT_PUB.G_MASS_ADD_TASKS,'N') ='N' ) THEN -- Added for Huawei 14556729 for add flow

14735: where pstype.proj_element_id = pelem.parent_structure_id
14736: and pstype.structure_type_id = types.structure_type_id
14737: and types.structure_type = p_structure_type);
14738: BEGIN
14739: IF (NVL(PA_PROJECT_PUB.G_MASS_ADD_TASKS,'N') ='N' ) THEN -- Added for Huawei 14556729 for add flow
14740: IF (l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14741: l_task_in_rec.pa_task_id IS NULL )
14742: THEN
14743: IF l_task_in_rec.pm_task_reference = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR

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

14804: ,p_attribute5 => '');
14805: RAISE Invalid_Arg_Exc_WP;
14806: END IF;
14807: --rtarway, for DHI ER, BUG 4413568
14808: IF (PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
14809: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
14810: p_msg_name => 'PA_WBS_CANT_CHANGE');
14811: RAISE Invalid_Arg_Exc_WP;
14812: END IF;

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

15412: END IF;
15413:
15414: END;
15415: --rtarway, added for BUG 4106154
15416: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
15417: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
15418: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
15419: --Added by rtarway for BUG 4321313
15420: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'

Line 15417: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

15413:
15414: END;
15415: --rtarway, added for BUG 4106154
15416: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
15417: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
15418: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
15419: --Added by rtarway for BUG 4321313
15420: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'
15421: )

Line 15418: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND

15414: END;
15415: --rtarway, added for BUG 4106154
15416: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
15417: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
15418: PA_PROJECT_PUB.G_Published_version_exists = 'Y' AND
15419: --Added by rtarway for BUG 4321313
15420: PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_in_rec.pa_task_id)='Y'
15421: )
15422: THEN

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

16203: -- the number of tasks in the create project context)
16204: IF (l_parent_task_version_id <> l_db_parent_task_version_id)
16205: THEN
16206: --rtarway, for DHI ER, BUG 4413568
16207: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
16208: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16209: p_msg_name => 'PA_WBS_CANT_CHANGE');
16210: RAISE Invalid_Arg_Exc_WP;
16211: END IF;

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

16547: -- Set the following variables after calling PA_RELATIONSHIP_PUB.Create_Relationship
16548: -- px_tasks_out_tbl(i).return_status
16549: --rtarway, for DHI ER, BUG 4413568
16550: /*
16551: IF ( PA_PROJECT_PUB.G_TASK_STR_UPDATE_MODE = 'PA_UPD_TASK_ATTR' ) THEN --bug 4534919
16552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16553: p_msg_name => 'PA_WBS_CANT_CHANGE');
16554: RAISE Invalid_Arg_Exc_WP;
16555: END IF;

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

16838: );
16839:
16840: EXCEPTION
16841: WHEN OTHERS THEN
16842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16843: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16844: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
16845: raise fnd_api.g_exc_error;
16846: END;

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

17271: --END IF;
17272:
17273: IF p_structure_type = 'FINANCIAL'
17274: THEN
17275: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
17277: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17279: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )

Line 17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR

17272:
17273: IF p_structure_type = 'FINANCIAL'
17274: THEN
17275: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
17277: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17279: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
17280: THEN

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

17273: IF p_structure_type = 'FINANCIAL'
17274: THEN
17275: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
17277: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17279: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
17280: THEN
17281: pa_fp_refresh_elements_pub.set_process_flag_proj(

Line 17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

17274: THEN
17275: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
17277: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17279: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
17280: THEN
17281: pa_fp_refresh_elements_pub.set_process_flag_proj(
17282: p_project_id => p_project_id

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

17275: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' OR
17276: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'Y' OR
17277: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17278: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17279: PA_PROJECT_PUB.G_Published_version_exists = 'N' ) )
17280: THEN
17281: pa_fp_refresh_elements_pub.set_process_flag_proj(
17282: p_project_id => p_project_id
17283: ,p_request_id => null

Line 17307: IF p_is_wp_versioning_enabled = 'N' and NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' THEN

17303: -- Call task status rollup with element version id as null so that rollup
17304: -- happens for the entire version. Status rollup needs to be done only if
17305: -- versioning is not enabled.
17306: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
17307: IF p_is_wp_versioning_enabled = 'N' and NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' THEN
17308:
17309: IF l_debug_mode = 'Y' THEN
17310: pa_debug.g_err_stage := 'Calling API Task status rollup';
17311: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);

Line 17343: IF ( px_tasks_out_tbl IS NOT NULL AND px_tasks_out_tbl.count > 0 and NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N')

17339: END IF;
17340: --Bug3802469, rtarway, this should not be called if px_tasks_out_tbl is empty, this will be empty,
17341: --if no tasks are passed , this will be empty,
17342: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
17343: IF ( px_tasks_out_tbl IS NOT NULL AND px_tasks_out_tbl.count > 0 and NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N')
17344: THEN
17345: PA_PROJ_TASK_STRUC_PUB.rollup_dates(
17346: p_tasks_in => px_tasks_out_tbl
17347: ,p_task_version_id => null

Line 17398: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /added for bug#15926171 /

17394: END IF ;
17395:
17396: END IF; -- p_is_wp_separate_from_fn = 'N' OR (p_is_wp_separate_from_fn = 'Y' and p_structure_type = 'WORKPLAN')
17397:
17398: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added for bug#15926171 */
17399: THEN
17400: -- PA L Changes 3010538
17401: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17402: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND

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

17397:
17398: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added for bug#15926171 */
17399: THEN
17400: -- PA L Changes 3010538
17401: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17402: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17403: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17404: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17405: THEN

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

17398: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' /*added for bug#15926171 */
17399: THEN
17400: -- PA L Changes 3010538
17401: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17402: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17403: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17404: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17405: THEN
17406: -- Changed p_structure_version_id to l_structure_version_id Bug 3035902.

Line 17403: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND

17399: THEN
17400: -- PA L Changes 3010538
17401: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17402: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17403: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17404: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17405: THEN
17406: -- Changed p_structure_version_id to l_structure_version_id Bug 3035902.
17407: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_project_id

Line 17404: PA_PROJECT_PUB.G_Published_version_exists = 'N')

17400: -- PA L Changes 3010538
17401: IF ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'N' ) OR
17402: ( PA_PROJECT_PUB.G_IS_WP_VERSIONING_ENABLED = 'Y' AND
17403: PA_PROJECT_PUB.G_IS_WP_SEPARATE_FROM_FN = 'N' AND
17404: PA_PROJECT_PUB.G_Published_version_exists = 'N')
17405: THEN
17406: -- Changed p_structure_version_id to l_structure_version_id Bug 3035902.
17407: l_update_wbs_flag := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(p_project_id => p_project_id
17408: ,p_structure_version_id => l_structure_version_id ) ;

Line 17467: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN

17463: END IF;
17464: --Amit : Bug 3964548 Begin
17465: -- added IF condition for Huawei enhancement - bug 13923366 by skkoppul
17466: -- skip unnecessary processing during bulk update mode
17467: IF NVL(PA_PROJECT_PUB.G_MASS_UPDATE_TASKS,'N') = 'N' THEN
17468:
17469: IF l_debug_mode = 'Y' THEN
17470: Pa_Debug.g_err_stage:= 'Calling FP add_planning Txn APIs';
17471: Pa_Debug.WRITE(G_PKG_NAME,Pa_Debug.g_err_stage,l_debug_level3);

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

17494: ,x_msg_data => l_msg_data
17495: );
17496: EXCEPTION
17497: WHEN OTHERS THEN
17498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17499: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17500: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
17501: raise fnd_api.g_exc_error;
17502: END;

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

17632: ,x_msg_data => l_msg_data
17633: );
17634: EXCEPTION
17635: WHEN OTHERS THEN
17636: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17637: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17638: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17639: raise fnd_api.g_exc_error;
17640: END;

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

17665: ,x_msg_data => l_msg_data
17666: );
17667: EXCEPTION
17668: WHEN OTHERS THEN
17669: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17670: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17671: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17672: raise fnd_api.g_exc_error;
17673: END;

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

17739: -- null;--BUG 3802469, rtarway
17740: -- end if;
17741: -- exception
17742: -- when others then
17743: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17744: -- p_procedure_name => 'CREATE_PROJECT',
17745: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17746: -- raise fnd_api.g_exc_error;
17747: -- end;

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

17766: -- null;
17767: -- end if;
17768: -- exception
17769: -- when others then
17770: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17771: -- p_procedure_name => 'CREATE_PROJECT',
17772: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17773: -- raise fnd_api.g_exc_error;
17774: -- end;

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

17827: -- null;
17828: -- end if;
17829: -- exception
17830: -- when others then
17831: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17832: -- p_procedure_name => 'CREATE_PROJECT',
17833: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17834: -- raise fnd_api.g_exc_error;
17835: -- end;

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

17853: -- null;
17854: -- end if;
17855: -- exception
17856: -- when others then
17857: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17858: -- p_procedure_name => 'CREATE_PROJECT',
17859: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17860: -- raise fnd_api.g_exc_error;
17861: -- end;

Line 21751: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='N') THEN

21747: p_msg_name => 'PA_INV_PARAM_PASSED');
21748: RAISE Invalid_Arg_Exc_WP;
21749: END IF;
21750: --Defer the Structure Update when G_Rollup_Defer is Y.
21751: IF (NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N')='N') THEN
21752: Update pa_proj_elem_ver_structure
21753: Set process_update_wbs_flag = p_update_wbs_flag
21754: Where project_id = p_project_id
21755: And element_version_id = p_structure_version_id;