[Home] [Help]
329: IF g1_debug_mode = 'Y' THEN
330: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'Case 2 : task_id is passed or task_ref is passed and object_type and object_id is not passed', x_Log_Level=> 3);
331: END IF;
332:
333: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
334: ( p_pa_project_id => l_project_id_out
335: , p_structure_type => p_structure_type
336: , p_pa_task_id => p_task_id
337: , p_pm_task_reference => p_pm_task_reference
373: IF p_object_type = 'PA_TASKS' THEN
374: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
375: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
376:
377: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
378: ( p_pa_project_id => l_project_id_out
379: , p_structure_type => p_structure_type
380: , p_pa_task_id => p_task_id
381: , p_pm_task_reference => p_pm_task_reference
390: END IF;
391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)
392: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
393:
394: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
395: ( p_pa_project_id => l_project_id_out
396: , p_structure_type => p_structure_type
397: , p_pa_task_id => p_object_id
398: , p_pm_task_reference => p_pm_task_reference
446: --Added by rtarway for BUG 3872176
447: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)
448: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN
449:
450: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
451: ( p_pa_project_id => l_project_id_out
452: , p_structure_type => p_structure_type
453: , p_pa_task_id => p_task_id
454: , p_pm_task_reference => p_pm_task_reference
1083:
1084: --Uncommented the following code as the fix of Bug 5632178
1085: /* Moved from below for Advanced Project Security Changes. Bug 2471668*/
1086:
1087: PA_PROJECT_PVT.Convert_pm_projref_to_id
1088: ( p_pm_project_reference => p_pm_project_reference
1089: , p_pa_project_id => p_project_id
1090: , p_out_project_id => l_project_id_out
1091: , p_return_status => l_return_status
1146:
1147: -- VALUE LAYER -----------------------------------------------------------------------
1148:
1149: /* Moved up for Advanced project security changes . Bug 2471668
1150: PA_PROJECT_PVT.Convert_pm_projref_to_id
1151: ( p_pm_project_reference => p_pm_project_reference
1152: , p_pa_project_id => p_project_id
1153: , p_out_project_id => l_project_id_out
1154: , p_return_status => l_return_status
1192:
1193: l_task_id_out := 0;
1194:
1195: ELSE
1196: -- 5262740 Converted PA_PROJECT_PVT.Convert_pm_taskref_to_id to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
1197: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
1198: ( p_pa_project_id => l_project_id_out
1199: , p_pa_task_id => p_task_id
1200: , p_pm_task_reference => p_pm_task_reference
1193: l_task_id_out := 0;
1194:
1195: ELSE
1196: -- 5262740 Converted PA_PROJECT_PVT.Convert_pm_taskref_to_id to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
1197: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
1198: ( p_pa_project_id => l_project_id_out
1199: , p_pa_task_id => p_task_id
1200: , p_pm_task_reference => p_pm_task_reference
1201: , p_out_task_id => l_task_id_out
3018: END IF;
3019:
3020: --Moved from below for project security changes. --Bug 2471668
3021:
3022: PA_PROJECT_PVT.Convert_pm_projref_to_id
3023: ( p_pm_project_reference => p_pm_project_reference
3024: , p_pa_project_id => p_project_id
3025: , p_out_project_id => l_project_id_out
3026: , p_return_status => l_return_status
3393:
3394: -- Set the G_ROLLUP_FLAG based on profile options
3395: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
3396: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3397: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'PROGRESS',x_msg_data,x_return_status);
3398: IF x_return_status <> 'S'
3399: THEN
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3398: IF x_return_status <> 'S'
3399: THEN
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'PROGRESS');
3403: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,p_structure_version_id,'PROGRESS');
3404: END IF;
3405: END IF;
3406:
3399: THEN
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'PROGRESS');
3403: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,p_structure_version_id,'PROGRESS');
3404: END IF;
3405: END IF;
3406:
3407: FOR i in p_task_id_tbl.FIRST..p_task_id_tbl.LAST LOOP
3409: l_structure_version_id_tbl.extend(1);
3410: l_project_id_tbl(i) := p_project_id;
3411: l_structure_version_id_tbl(i) :=p_structure_version_id;
3412: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3413: PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_project_id,p_task_id_tbl(i),p_structure_version_id,'PROGRESS');
3414: END IF;
3415: END LOOP;
3416:
3417:
3470: ,x_msg_data
3471: );
3472:
3473: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3474: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3475: END IF;
3476: EXCEPTION
3477: WHEN FND_API.G_EXC_ERROR THEN
3478: x_return_status := FND_API.G_RET_STS_ERROR ;
3476: EXCEPTION
3477: WHEN FND_API.G_EXC_ERROR THEN
3478: x_return_status := FND_API.G_RET_STS_ERROR ;
3479: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3480: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3481: END IF;
3482: FND_MSG_PUB.Count_And_Get
3483: ( p_count => x_msg_count ,
3484: p_data => x_msg_data );
3489: ( p_pkg_name => G_PKG_NAME
3490: , p_procedure_name => 'UPDATE_PROGRESS_BULK' );
3491: END IF;
3492: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3493: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3494: END IF;
3495: FND_MSG_PUB.Count_And_Get
3496: ( p_count => x_msg_count ,
3497: p_data => x_msg_data );