DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_TASK_PUB1

Line 217: PA_TASK_PUB1.Create_Schedule_Version(

213:
214:
215: IF NVL( p_struc_type, 'WORKPLAN' ) = 'WORKPLAN'
216: THEN
217: PA_TASK_PUB1.Create_Schedule_Version(
218: p_element_version_id => x_struc_version_id
219: ,p_scheduled_start_date => SYSDATE
220: ,p_scheduled_end_date => SYSDATE
221: ,x_pev_schedule_id => x_pev_schedule_id

Line 546: PA_TASK_PUB1.Create_Schedule_Version(

542: OPEN cur_ver_sch_attr_rec(x_task_version_id);
543: FETCH cur_ver_sch_attr_rec INTO l_ver_sch_attr_rec;
544: CLOSE cur_ver_sch_attr_rec;
545:
546: PA_TASK_PUB1.Create_Schedule_Version(
547: p_element_version_id => x_task_version_id
548: ,p_scheduled_start_date => SYSDATE
549: ,p_scheduled_end_date => SYSDATE
550: ,p_attribute_category => l_ver_sch_attr_rec.attribute_category

Line 1293: PA_TASK_PUB1.create_task(

1289: IF p_create_task_version_only = 'N'
1290: THEN
1291:
1292: --For each project create 1 task
1293: PA_TASK_PUB1.create_task(
1294: p_calling_module => p_calling_module
1295: ,p_init_msg_list => l_init_msg_list
1296: ,p_object_type => 'PA_TASKS'
1297: ,p_project_id => p_project_id

Line 1939: PA_TASK_PUB1.Create_Schedule_Version(

1935: END IF;
1936: --Bug 6153503 end
1937: --End add rtarway, 3908013
1938:
1939: PA_TASK_PUB1.Create_Schedule_Version(
1940: p_element_version_id => l_task_version_id
1941: ,p_init_msg_list => l_init_msg_list
1942: ,p_scheduled_start_date => l_scheduled_start_date
1943: ,p_scheduled_end_date => l_scheduled_finish_date

Line 2073: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

2069: l_del_task_ver_ids(l_del_task_ver_ids.count):= x_task_version_id;
2070: end if;
2071: end if;
2072:
2073: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
2074:
2075: begin
2076: pa_task_pub1.call_add_planning_txns(
2077: p_tasks_ver_ids => l_add_task_ver_ids,

Line 2076: pa_task_pub1.call_add_planning_txns(

2072:
2073: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
2074:
2075: begin
2076: pa_task_pub1.call_add_planning_txns(
2077: p_tasks_ver_ids => l_add_task_ver_ids,
2078: p_planned_effort => l_add_planned_effort,
2079: p_project_id => p_project_id,
2080: p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 2092: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

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;
2095:
2096: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 2154: -- 18-MAY-2004 Rakesh Raghavan Modified call to API: pa_task_pub1.update_task_det_sch_info().

2150: -- History
2151: --
2152: -- 25-APR-02 MAansari -Created
2153: -- 05-APR-2004 Rakesh Raghavan Progress Management Changes. Bug # 3420093.
2154: -- 18-MAY-2004 Rakesh Raghavan Modified call to API: pa_task_pub1.update_task_det_sch_info().
2155:
2156: PROCEDURE update_task_structure
2157: (
2158: p_calling_module IN VARCHAR2 := 'FORMS'

Line 2448: --pa_task_pub1.call_add_planning_txns

2444:
2445: --Bug 5256359. Changed the type of these pl-sql tbls to SYSTEM.pa_xxx_tbl_type from PA_xxx_1000_xxx.
2446:
2447: --New tbls (suffixed with _prm), created below will be used as parameters in the call to
2448: --pa_task_pub1.call_add_planning_txns
2449:
2450: l_add_task_ver_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2451: l_add_planned_effort SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2452: l_add_start_date SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 2620: PA_TASK_PUB1.Update_Task(

2616: END IF;
2617: --End add by rtarway for BUG 3666023
2618:
2619:
2620: PA_TASK_PUB1.Update_Task(
2621: p_calling_module => p_calling_module
2622: ,p_init_msg_list => l_init_msg_list
2623: --rtarway for BUG 3666023
2624: --,p_task_id => p_task_id

Line 2650: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);

2646: ,x_return_status => l_return_status
2647: ,x_msg_count => l_msg_count
2648: ,x_msg_data => l_msg_data
2649: );
2650: --dbms_output.put_line('Before calling PA_TASK_PUB1.Update_Task l_return_status'||l_return_status);
2651:
2652: IF l_return_status <> 'S'
2653: THEN
2654: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'

Line 2935: PA_TASK_PUB1.move_task_version(

2931: END IF ;
2932:
2933: -- PA L Changes 3010538
2934:
2935: PA_TASK_PUB1.move_task_version(
2936: p_calling_module => p_calling_module
2937: ,p_init_msg_list => l_init_msg_list
2938: ,p_structure_version_id => l_structure_version_id
2939: ,p_task_version_id => l_task_version_id

Line 3203: PA_TASK_PUB1.Update_Schedule_Version(

3199: --End add rtarway, 3908013
3200:
3201:
3202:
3203: PA_TASK_PUB1.Update_Schedule_Version(
3204: p_calling_module => p_calling_module
3205: ,p_init_msg_list => l_init_msg_list
3206: ,p_pev_schedule_id => l_pev_schedule_id
3207: ,p_calendar_id => p_calendar_id

Line 3332: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

3328: end if;
3329: end loop;
3330: end if;
3331:
3332: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
3333: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns
3334: --for set of 1000 records.
3335: rec_count:=0;
3336: for i in 1..l_add_task_ver_ids.count loop

Line 3333: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns

3329: end loop;
3330: end if;
3331:
3332: -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
3333: --Bug 5256359. Introduced the loop to call pa_task_pub1.call_add_planning_txns
3334: --for set of 1000 records.
3335: rec_count:=0;
3336: for i in 1..l_add_task_ver_ids.count loop
3337:

Line 3352: pa_task_pub1.call_add_planning_txns(

3348:
3349: if rec_count=1000 OR
3350: i=l_add_task_ver_ids.count then
3351: begin
3352: pa_task_pub1.call_add_planning_txns(
3353: p_tasks_ver_ids => l_add_task_ver_ids_prm,
3354: p_planned_effort => l_add_planned_effort_prm,
3355: p_project_id => p_project_id,
3356: p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 3368: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

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;
3371:
3372: l_add_task_ver_ids_prm := PA_NUM_1000_NUM();

Line 3436: as PA_TASK_PUB1.update_task_det_sch_info() should be called for both versioning enabled

3432:
3433: -- Progress Management Changes. Bug # 3420093.
3434:
3435: /* Commenting out the condition to check if workplan versioning is enabled for the project
3436: as PA_TASK_PUB1.update_task_det_sch_info() should be called for both versioning enabled
3437: and versioning disabled projects. */
3438:
3439: /* if (PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id) = 'Y') then */
3440:

Line 3441: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */

3437: and versioning disabled projects. */
3438:
3439: /* if (PA_PROJ_TASK_STRUC_PUB.IS_WP_VERSIONING_ENABLED(p_project_id) = 'Y') then */
3440:
3441: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */
3442:
3443: if p_calling_module <> 'FORMS' then
3444:
3445: pa_task_pub1.update_task_det_sch_info(

Line 3445: pa_task_pub1.update_task_det_sch_info(

3441: /* Calling API: pa_task_pub1.update_task_det_sch_info() only if calling module is not 'FORMS'. */
3442:
3443: if p_calling_module <> 'FORMS' then
3444:
3445: pa_task_pub1.update_task_det_sch_info(
3446: p_calling_module => p_calling_module
3447: ,p_task_ver_id => l_task_version_id
3448: ,p_project_id => p_project_id
3449: ,p_planned_effort => p_planned_effort

Line 3591: PA_TASK_PUB1.Delete_Task_Version(

3587: END IF;
3588:
3589: IF l_task_version_id > 0
3590: THEN
3591: PA_TASK_PUB1.Delete_Task_Version(
3592: p_calling_module => p_calling_module
3593: ,p_structure_type => p_structure_type --bug 3301192
3594: ,p_task_version_id => l_task_version_id
3595: ,p_record_version_number => l_record_version_number

Line 4182: PA_TASK_PUB1.Create_Schedule_Version(

4178: END LOOP;
4179: --Now create the schedule versions for the workplan structure version and task versions.
4180: FOR cur_pa_proj_elem_vers_rec2 IN cur_pa_proj_elem_vers2 LOOP
4181: x_pev_schedule_id := null;
4182: PA_TASK_PUB1.Create_Schedule_Version(
4183: p_element_version_id => cur_pa_proj_elem_vers_rec2.element_version_id
4184: ,p_scheduled_start_date => SYSDATE
4185: ,p_scheduled_end_date => SYSDATE
4186: ,x_pev_schedule_id => x_pev_schedule_id

Line 4200: PA_TASK_PUB1.Create_Schedule_Version(

4196: raise api_error;
4197: END IF;
4198: FOR cur_pa_proj_elem_vers_rec3 IN cur_pa_proj_elem_vers3(cur_pa_proj_elem_vers_rec2.element_version_id) LOOP
4199: x_pev_schedule_id := null;
4200: PA_TASK_PUB1.Create_Schedule_Version(
4201: p_element_version_id => cur_pa_proj_elem_vers_rec3.element_version_id
4202: ,p_scheduled_start_date => SYSDATE
4203: ,p_scheduled_end_date => SYSDATE
4204: ,x_pev_schedule_id => x_pev_schedule_id

Line 4911: PA_TASK_PUB1.Create_Schedule_Version(

4907: , X_SOURCE_OBJECT_ID => p_project_id
4908: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
4909: );
4910:
4911: PA_TASK_PUB1.Create_Schedule_Version(
4912: p_element_version_id => x_structure_version_id
4913: ,p_scheduled_start_date => SYSDATE
4914: ,p_scheduled_end_date => SYSDATE
4915: ,x_pev_schedule_id => x_pev_schedule_id

Line 5171: PA_TASK_PUB1.Create_Schedule_Version(

5167: , X_SOURCE_OBJECT_ID => p_project_id
5168: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
5169: );
5170:
5171: PA_TASK_PUB1.Create_Schedule_Version(
5172: p_element_version_id => x_structure_version_id
5173: ,p_scheduled_start_date => SYSDATE
5174: ,p_scheduled_end_date => SYSDATE
5175: ,x_pev_schedule_id => x_pev_schedule_id

Line 5315: PA_TASK_PUB1.Create_Schedule_Version(

5311: , X_SOURCE_OBJECT_ID => p_project_id
5312: , X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
5313: );
5314:
5315: PA_TASK_PUB1.Create_Schedule_Version(
5316: p_element_version_id => x_structure_version_id
5317: ,p_scheduled_start_date => SYSDATE
5318: ,p_scheduled_end_date => SYSDATE
5319: ,x_pev_schedule_id => x_pev_schedule_id

Line 6050: --The following API is added to re-calculate task weights to call PA_TASK_PUB1.CALC_TASK_WEIGHTS

6046:
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

Line 6114: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

6110: END IF;
6111: j := j + 1;
6112: IF NVL( l_recalculate_flag, 'N' ) = 'Y' AND j >= 1000
6113: THEN
6114: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
6115: l_outline_level.extend;
6116: l_outline_level(l_outline_level.count) := null;
6117:
6118: /*--bug 2856033

Line 6143: PA_TASK_PUB1.Calc_Task_Weights(

6139: end if;
6140: --bug 2856033
6141: */
6142:
6143: PA_TASK_PUB1.Calc_Task_Weights(
6144: p_element_versions => l_tasks_ver_ids
6145: ,p_outline_level => l_outline_level
6146: ,p_top_sub_count => l_total_top_tasks
6147: ,x_return_status => l_return_status

Line 6198: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

6194:
6195: IF NVL( l_recalculate_flag, 'N' ) = 'Y'
6196: THEN
6197:
6198: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
6199: l_outline_level.extend;
6200: l_outline_level(l_outline_level.count) := null;
6201:
6202: /*--bug 2856033

Line 6228: PA_TASK_PUB1.Calc_Task_Weights(

6224: --bug 2856033
6225: */
6226:
6227:
6228: PA_TASK_PUB1.Calc_Task_Weights(
6229: p_element_versions => l_tasks_ver_ids
6230: ,p_outline_level => l_outline_level
6231: ,p_top_sub_count => l_total_top_tasks
6232: ,x_return_status => l_return_status

Line 9891: PA_TASK_PUB1.Create_Schedule_Version(

9887: ,'PA_PROJECTS'
9888: );
9889:
9890: --bug 3912603, insert records into pa_proj_elem_ver_Schedule, Satish, start
9891: PA_TASK_PUB1.Create_Schedule_Version(
9892: p_element_version_id => l_new_wp_ver_id
9893: ,p_scheduled_start_date => SYSDATE
9894: ,p_scheduled_end_date => SYSDATE
9895: ,x_pev_schedule_id => x_pev_schedule_id

Line 13220: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights

13216: i := p_tasks_in.next(i);
13217: j := j + 1;
13218: END LOOP;
13219: END IF;
13220: --To avoid no_data_found when this array is read in PA_TASK_PUB1.Cal_Task_weights
13221: --l_tasks_ver_ids.extend;
13222: --l_tasks_ver_ids(l_tasks_ver_ids.count) := null;
13223: ELSE
13224: l_tasks_ver_ids(1) := p_task_version_id;

Line 14389: -- before calling api PA_TASK_PUB1.update_task

14385: -- carrying_out_organization_id, pm_task_reference, address_id, task_manager_person_id
14386: -- 2. l_parent_task_id
14387: -- 3. l_task_id -- the task that is being processed.
14388: -- l_proj_elem_rvn of record of pa_proj_elements to be updated
14389: -- before calling api PA_TASK_PUB1.update_task
14390:
14391: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
14392: l_task_in_rec.pa_task_id IS NULL -- new tasks to be crated
14393: THEN

Line 14750: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';

14746: THEN
14747: IF p_create_task_version_only = 'N' THEN
14748:
14749: IF l_debug_mode = 'Y' THEN
14750: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';
14751: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
14752: END IF;
14753:
14754: PA_TASK_PUB1.create_task(

Line 14754: PA_TASK_PUB1.create_task(

14750: pa_debug.g_err_stage := 'Calling API PA_TASK_PUB1.create_task';
14751: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
14752: END IF;
14753:
14754: PA_TASK_PUB1.create_task(
14755: p_api_version => p_api_version_number
14756: ,p_commit => p_commit
14757: ,p_validate_only => FND_API.G_FALSE
14758: ,p_calling_module => p_calling_module

Line 14834: PA_TASK_PUB1.Update_Task(

14830: l_status_code := l_task_in_rec.STATUS_CODE;
14831: end if;
14832: -- Bug 6717386
14833:
14834: PA_TASK_PUB1.Update_Task(
14835: p_calling_module => 'AMG'
14836: ,p_init_msg_list => FND_API.G_FALSE
14837: ,p_task_id => l_task_in_rec.pa_task_id
14838: ,p_task_number => l_task_in_rec.pa_task_number

Line 16148: END IF; /* Before calling PA_TASK_PUB1 Create_Schedule_Version or Update_Schedule_Version*/

16144: END IF;
16145: --end bug 3035902 maansari
16146:
16147:
16148: END IF; /* Before calling PA_TASK_PUB1 Create_Schedule_Version or Update_Schedule_Version*/
16149:
16150: -- set the following after calling Create_Schedule_Version or Update_Schedule_Version
16151: -- px_tasks_out_tbl(i).return_status
16152:

Line 16156: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version

16152:
16153: IF l_task_in_rec.pa_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR
16154: l_task_in_rec.pa_task_id IS NULL -- Create Task Context
16155: THEN
16156: -- set the following after calling api PA_TASK_PUB1.Create_Schedule_Version
16157: -- px_tasks_out_tbl(i).return_status
16158:
16159: -- Create a schedule version for the task version only if the workplan
16160: -- structure is involved.

Line 16167: PA_TASK_PUB1.Create_Schedule_Version(

16163: pa_debug.g_err_stage := 'Calling API create schedule version';
16164: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16165: END IF;
16166:
16167: PA_TASK_PUB1.Create_Schedule_Version(
16168: p_element_version_id => l_task_version_id
16169: ,p_init_msg_list => FND_API.G_FALSE
16170: ,p_scheduled_start_date => l_scheduled_start_date
16171: ,p_scheduled_end_date => l_scheduled_finish_date

Line 16300: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version

16296: --rtarway, 4099429 end
16297:
16298:
16299: ELSE -- in update task case
16300: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version
16301: -- px_tasks_out_tbl(i).return_status
16302:
16303:
16304: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api

Line 16304: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api

16300: -- set the following after calling api PA_TASK_PUB1.Update_Schedule_Version
16301: -- px_tasks_out_tbl(i).return_status
16302:
16303:
16304: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api
16305: --if tasks are updated in bulk.
16306: --This should set for every single task.
16307: PA_TASK_PUB1.Update_Schedule_Version(
16308: p_calling_module => p_calling_module

Line 16307: PA_TASK_PUB1.Update_Schedule_Version(

16303:
16304: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --bug 4145893 do not call PJI.plan_update api
16305: --if tasks are updated in bulk.
16306: --This should set for every single task.
16307: PA_TASK_PUB1.Update_Schedule_Version(
16308: p_calling_module => p_calling_module
16309: ,p_init_msg_list => FND_API.G_FALSE
16310: ,p_pev_schedule_id => l_ver_sch_attr_rec.pev_schedule_id
16311: ,p_calendar_id => l_task_in_rec.calendar_id

Line 16369: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;

16365:
16366: );
16367:
16368: --bug 4149392
16369: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;
16370: --end bug 4149392
16371:
16372: px_tasks_out_tbl(i).return_status := x_return_status;
16373:

Line 16452: pa_task_pub1.update_task_det_sch_info(

16448: -- End addition for bug 6458891
16449:
16450: --Added by rtarway for BUG 39198900
16451: IF p_calling_module <> 'FORMS' and l_update_task_det_flag = 'Y' THEN /* Added flag check for Bug 6458891 */
16452: pa_task_pub1.update_task_det_sch_info(
16453: p_calling_module => p_calling_module
16454: ,p_task_ver_id => l_task_version_id
16455: ,p_project_id => p_project_id
16456: ,p_planned_effort => l_task_in_rec.planned_effort

Line 17066: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

17062: -- end loop;
17063: -- end if;--Bug3802469, rtarway
17064: -- end if;
17065: --
17066: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
17067: --
17068: --
17069: -- begin
17070: -- --BUG 3802469, rtarway , if the tasks table is empty, l_add_task_ver_ids will not be populated.

Line 17074: -- pa_task_pub1.call_add_planning_txns(

17070: -- --BUG 3802469, rtarway , if the tasks table is empty, l_add_task_ver_ids will not be populated.
17071: -- --Check needed before calling call_add_planning_txns, to see if l_add_task_ver_ids is empty
17072: -- if ( l_add_task_ver_ids IS NOT NULL AND l_add_task_ver_ids.count > 0)
17073: -- then
17074: -- pa_task_pub1.call_add_planning_txns(
17075: -- p_tasks_ver_ids => l_add_task_ver_ids,
17076: -- p_planned_effort => l_add_planned_effort,
17077: -- p_project_id => p_project_id,
17078: -- p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 17093: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

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;
17096: --
17097: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 17156: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.

17152: -- end if;
17153: -- end loop;
17154: -- end if;
17155: --
17156: -- -- Calling pa_task_pub1.call_add_planning_txns for lowest level tasks.
17157: --
17158: -- begin
17159: -- --BUG3802469, rtarway, see comments above
17160: -- if ( l_add_task_ver_ids IS NOT NULL and l_add_task_ver_ids.count > 0)

Line 17162: -- pa_task_pub1.call_add_planning_txns(

17158: -- begin
17159: -- --BUG3802469, rtarway, see comments above
17160: -- if ( l_add_task_ver_ids IS NOT NULL and l_add_task_ver_ids.count > 0)
17161: -- then
17162: -- pa_task_pub1.call_add_planning_txns(
17163: -- p_tasks_ver_ids => l_add_task_ver_ids,
17164: -- p_planned_effort => l_add_planned_effort,
17165: -- p_project_id => p_project_id,
17166: -- p_structure_version_id => l_structure_version_id, --replace p_structure_version_id, bug 3838186

Line 17181: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));

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;
17184: --
17185: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

Line 18990: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --4149392 fixed during fixing 4186512

18986: -- Bug 3762882 : This code should be commented as FP is also
18987: -- pushing actuals for resource assignments so we should not push it for tasks here.
18988: -- BEGIN Bug 4284444 : Commented
18989:
18990: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --4149392 fixed during fixing 4186512
18991:
18992: --bug 4019845
18993: IF (l_publish_flag = 'Y') THEN
18994: --*******************************************

Line 19035: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null; --set the flag so that PJI rolls up data on the working version.

19031:
19032: IF l_debug_mode = 'Y' THEN
19033: pa_debug.write(G_PKG_NAME, 'Calling PLAN_UPDATE in PUBLISH mode for working version', 3);
19034: END IF;
19035: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null; --set the flag so that PJI rolls up data on the working version.
19036:
19037: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
19038: p_plan_version_id => l_plan_version_id, --bug 4587145
19039: x_return_status => x_return_status);

Line 19045: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --Set the flag back to 'N' to bypass any PJI rollup api call untill explicit plan_update gets called.

19041: IF l_debug_mode = 'Y' THEN
19042: pa_debug.write(G_PKG_NAME,'After PLAN_UPDATE in PUBLISH mode for working verison x_return_status='||
19043: x_return_status,l_debug_level3);
19044: END IF;
19045: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := 'N'; --Set the flag back to 'N' to bypass any PJI rollup api call untill explicit plan_update gets called.
19046: EXCEPTION
19047: WHEN OTHERS THEN
19048: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TASK_STRUC_PUB',
19049: p_procedure_name => 'PROCESS_WBS_UPDATES',

Line 19657: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;

19653: END IF;
19654:
19655: --bug 4149392
19656:
19657: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := NULL;
19658: BEGIN
19659:
19660: --bug 4587145
19661: BEGIN

Line 19913: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;

19909:
19910: --bug 4186512
19911: --set the PJI global flag to NULL before calling pji wbsmant for
19912: --indent/outdent/copy/move
19913: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
19914:
19915: BEGIN -- Bug 4284444
19916: --both working version
19917: IF l_debug_mode = 'Y' THEN

Line 20193: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;

20189:
20190: -- Begin Bug # 4611373.
20191: --set the PJI global flag to NULL before calling pji wbsmant for
20192: --indent/outdent/copy/move
20193: PA_TASK_PUB1.G_CALL_PJI_ROLLUP := null;
20194:
20195: BEGIN
20196: --both working version
20197: IF l_debug_mode = 'Y' THEN