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_TASK_PVT1 dependencies on PA_TASK_PVT1

Line 1: PACKAGE BODY PA_TASK_PVT1 AS

1: PACKAGE BODY PA_TASK_PVT1 AS
2: /* $Header: PATSK1VB.pls 120.8.12010000.4 2008/11/27 15:05:46 rthumma ship $ */
3:
4: -- API name : Create_Task
5: -- Type : Private procedure

Line 378: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK begin');

374:
375: --dbms_output.put_line(( 'Inside CREATE_TASK private API' );
376:
377: IF (p_debug_mode = 'Y') THEN
378: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK begin');
379: END IF;
380:
381: IF (p_commit = FND_API.G_TRUE) THEN
382: savepoint CREATE_TASK_PRIVATE;

Line 1336: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_msg_count := FND_MSG_PUB.count_msg;
1335: --put message
1336: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
1337: p_procedure_name => 'Create_Task',
1338: p_error_text => SUBSTRB(SQLERRM,1,240));
1339: RAISE;
1340:

Line 1772: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK begin');

1768:
1769: BEGIN
1770:
1771: IF (p_debug_mode = 'Y') THEN
1772: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK begin');
1773: END IF;
1774:
1775: IF (p_commit = FND_API.G_TRUE) THEN
1776: savepoint UPDATE_TASK_PRIVATE;

Line 2086: /* PA_TASK_PVT1.UPDATE_WORKING_VER_WEIGHT(

2082: -- Bug 3075609. We'll update after the task type id is updated for the task.
2083: l_update_working_ver_weight := 'Y';
2084: --set working versions weighting to 0
2085: --pro-rate peer tasks
2086: /* PA_TASK_PVT1.UPDATE_WORKING_VER_WEIGHT(
2087: p_task_id => p_task_id
2088: ,p_weighting => 0
2089: ,x_return_status => l_return_status
2090: ,x_msg_count => l_msg_count

Line 2713: PA_TASK_PVT1.UPDATE_WORKING_VER_WEIGHT(

2709:
2710: -- Bug 3075609. Moved here so that the processing is done after the
2711: -- task type for the task is updated.
2712: IF nvl(l_update_working_ver_weight,'N') = 'Y' THEN
2713: PA_TASK_PVT1.UPDATE_WORKING_VER_WEIGHT(
2714: p_task_id => p_task_id
2715: ,p_weighting => 0
2716: ,x_return_status => l_return_status
2717: ,x_msg_count => l_msg_count

Line 2979: PA_TASK_PVT1.set_new_tasks_to_TBD(

2975: raise FND_API.G_EXC_ERROR;
2976: END IF;
2977: END IF;
2978:
2979: PA_TASK_PVT1.set_new_tasks_to_TBD(
2980: p_project_id => l_project_id
2981: ,p_task_id => p_task_id
2982: ,p_task_status => l_STATUS_CODE
2983: ,x_return_status => l_return_status

Line 3044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

3040: END IF;
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: x_msg_count := FND_MSG_PUB.count_msg;
3043: --put message
3044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3045: p_procedure_name => 'update_Task',
3046: p_error_text => SUBSTRB(SQLERRM,1,240));
3047: RAISE;
3048: END Update_Task;

Line 3228: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK_VERSION begin');

3224: BEGIN
3225:
3226: --my_error_msg( 'In create_task_version pvt API' );
3227: IF (p_debug_mode = 'Y') THEN
3228: pa_debug.debug('PA_TASK_PVT1.CREATE_TASK_VERSION begin');
3229: END IF;
3230:
3231: IF (p_commit = FND_API.G_TRUE) THEN
3232: savepoint CREATE_TASK_VER_PRIVATE;

Line 3702: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

3698: END IF;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: x_msg_count := FND_MSG_PUB.count_msg;
3701: --put message
3702: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3703: p_procedure_name => 'create_Task_version',
3704: p_error_text => SUBSTRB(SQLERRM,1,240));
3705: RAISE;
3706:

Line 3981: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK_VERSION begin');

3977: --bug 2673570
3978:
3979: BEGIN
3980: IF (p_debug_mode = 'Y') THEN
3981: pa_debug.debug('PA_TASK_PVT1.UPDATE_TASK_VERSION begin');
3982: END IF;
3983:
3984: IF (p_commit = FND_API.G_TRUE) THEN
3985: savepoint UPDATE_TASK_VER_PRIVATE;

Line 4554: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

4550: END IF;
4551:
4552: --hsiu added
4553: --for task weighting
4554: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
4555: p_task_version_id => l_old_parent_id
4556: ,x_return_status => l_return_status
4557: ,x_msg_count => l_msg_count
4558: ,x_msg_data => l_msg_data

Line 4574: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

4570: x_msg_data := l_data;
4571: END IF;
4572:
4573: --bug 2673570
4574: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
4575: p_task_version_id => p_task_version_id
4576: ,x_return_status => l_return_status
4577: ,x_msg_count => l_msg_count
4578: ,x_msg_data => l_msg_data

Line 4782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

4778: END IF;
4779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4780: x_msg_count := FND_MSG_PUB.count_msg;
4781: --put message
4782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
4783: p_procedure_name => 'update_Task_version',
4784: p_error_text => SUBSTRB(SQLERRM,1,240));
4785: RAISE;
4786: END update_task_version;

Line 5167: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VERSION begin');

5163: */
5164: -- 4201927 end
5165:
5166: IF (p_debug_mode = 'Y') THEN
5167: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VERSION begin');
5168: END IF;
5169:
5170: IF (p_commit = FND_API.G_TRUE) THEN
5171: savepoint DELETE_TASK_VER_PRIVATE;

Line 5244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

5240: ,x_msg_count => x_msg_count
5241: ,x_msg_data => x_msg_data);
5242: EXCEPTION
5243: WHEN OTHERS THEN
5244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5245: p_procedure_name => 'delete_Task_version',
5246: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5247: RAISE FND_API.G_EXC_ERROR;
5248: END;

Line 5487: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

5483: ,x_msg_count => x_msg_count
5484: ,x_msg_data => x_msg_data);
5485: EXCEPTION
5486: WHEN OTHERS THEN
5487: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5488: p_procedure_name => 'delete_Task_version',
5489: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5490: RAISE FND_API.G_EXC_ERROR;
5491: END;

Line 5735: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

5731: FETCH get_subproj_relation INTO get_subproj_relation_rec;
5732: IF get_subproj_relation%FOUND --bug 4573340
5733: THEN
5734: IF l_debug_mode = 'Y' THEN
5735: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
5736: ||get_subproj_relation_rec.object_relationship_id, 3);
5737: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
5738: ||get_subproj_relation_rec.record_version_number, 3);
5739:

Line 5737: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

5733: THEN
5734: IF l_debug_mode = 'Y' THEN
5735: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
5736: ||get_subproj_relation_rec.object_relationship_id, 3);
5737: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
5738: ||get_subproj_relation_rec.record_version_number, 3);
5739:
5740: END IF;
5741:

Line 5759: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

5755: ,x_msg_data => l_msg_data
5756: );
5757:
5758: IF l_debug_mode = 'Y' THEN
5759: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
5760: END IF;
5761:
5762: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5763: x_msg_count := FND_MSG_PUB.count_msg;

Line 5975: p_pkg_name => 'PA_TASK_PVT1',

5971:
5972: WHEN OTHERS THEN
5973:
5974: fnd_msg_pub.add_exc_msg(
5975: p_pkg_name => 'PA_TASK_PVT1',
5976: p_procedure_name => 'Delete_Task_Version',
5977: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
5978:
5979: RAISE FND_API.G_EXC_ERROR;

Line 6014: p_pkg_name => 'PA_TASK_PVT1',

6010:
6011: WHEN OTHERS THEN
6012:
6013: fnd_msg_pub.add_exc_msg(
6014: p_pkg_name => 'PA_TASK_PVT1',
6015: p_procedure_name => 'Delete_Task_Version',
6016: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
6017:
6018: RAISE FND_API.G_EXC_ERROR;

Line 6172: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

6168: --hsiu
6169: --added for task weighting
6170: --IF (PA_PROGRESS_UTILS.GET_TASK_WEIGHTING_BASIS( x_project_id ) ='MANUAL') THEN --bug 3051413 --commenting this line for bug 3058051 issue # 1.
6171:
6172: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
6173: p_task_version_id => l_old_parent_ver_id
6174: ,x_return_status => l_return_status
6175: ,x_msg_count => l_msg_count
6176: ,x_msg_data => l_msg_data

Line 6257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

6253: END IF;
6254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6255: x_msg_count := FND_MSG_PUB.count_msg;
6256: --put message
6257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
6258: p_procedure_name => 'delete_Task_version',
6259: p_error_text => SUBSTRB(SQLERRM,1,240));
6260: RAISE;
6261: END delete_task_version;

Line 6471: pa_debug.debug('PA_TASK_PVT1.CREATE_SCHEDULE_VERSION begin');

6467: l_ext_remain_duration NUMBER;
6468: l_ext_sch_duration NUMBER;
6469: BEGIN
6470: IF (p_debug_mode = 'Y') THEN
6471: pa_debug.debug('PA_TASK_PVT1.CREATE_SCHEDULE_VERSION begin');
6472: END IF;
6473:
6474: IF (p_commit = FND_API.G_TRUE) THEN
6475: savepoint CREATE_SCH_VER_PRIVATE;

Line 7104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

7100: END IF;
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: x_msg_count := FND_MSG_PUB.count_msg;
7103: --put message
7104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
7105: p_procedure_name => 'create_schedule_version',
7106: p_error_text => SUBSTRB(SQLERRM,1,240));
7107: RAISE;
7108:

Line 7363: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION begin',3);

7359:
7360: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
7361:
7362: IF (l_debug_mode = 'Y') THEN
7363: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION begin',3);
7364: END IF;
7365:
7366: IF (p_commit = FND_API.G_TRUE) THEN
7367: savepoint UPDATE_SCH_VER_PRIVATE;

Line 7371: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'Performing validations',3);

7367: savepoint UPDATE_SCH_VER_PRIVATE;
7368: END IF;
7369:
7370: IF (l_debug_mode = 'Y') THEN
7371: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'Performing validations',3);
7372: END IF;
7373:
7374: OPEN cur_val;
7375: FETCH cur_val into cur_val_rec;

Line 7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);

7474: cur_val_rec.proj_element_id, cur_val_rec.element_version_id);
7475: --end bug 4620492
7476:
7477: IF (l_debug_mode = 'Y') THEN
7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);

Line 7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);

7475: --end bug 4620492
7476:
7477: IF (l_debug_mode = 'Y') THEN
7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
7483: END IF;

Line 7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);

7476:
7477: IF (l_debug_mode = 'Y') THEN
7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
7483: END IF;
7484:

Line 7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);

7477: IF (l_debug_mode = 'Y') THEN
7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
7483: END IF;
7484:
7485: --For bug 2638649

Line 7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);

7478: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'l_task_has_sub_proj_flag='||l_task_has_sub_proj_flag,3);
7479: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'p_calling_module='||p_calling_module,3);
7480: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_START_DATE='|| cur_val_rec.scheduled_START_DATE,3);
7481: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.scheduled_FINISH_DATE='||cur_val_rec.scheduled_FINISH_DATE,3);
7482: pa_debug.write('PA_TASK_PVT1.UPDATE_SCHEDULE_VERSION', 'cur_val_rec.PLANNED_EFFORT='||cur_val_rec.PLANNED_EFFORT,3);
7483: END IF;
7484:
7485: --For bug 2638649
7486: IF ( p_scheduled_start_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE AND p_scheduled_start_date IS NOT NULL )

Line 8305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8301: );
8302: END IF;
8303: EXCEPTION
8304: WHEN OTHERS THEN
8305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8306: p_procedure_name => 'update_schedule_version',
8307: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
8308: RAISE FND_API.G_EXC_ERROR;
8309: END;

Line 8347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8343: END IF;
8344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8345: x_msg_count := FND_MSG_PUB.count_msg;
8346: --put message
8347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8348: p_procedure_name => 'update_schedule_version',
8349: p_error_text => SUBSTRB(SQLERRM,1,240));
8350: RAISE;
8351: END Update_Schedule_Version;

Line 8419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8415: END IF;
8416: EXCEPTION
8417: WHEN OTHERS THEN
8418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8420: p_procedure_name => 'Inherit_task_type_attr',
8421: p_error_text => SUBSTRB(SQLERRM,1,240));
8422: raise;
8423: END Inherit_task_type_attr;

Line 8489: pa_debug.debug('PA_TASK_PVT1.Update_Task_Weighting begin');

8485:
8486:
8487: BEGIN
8488: IF (p_debug_mode = 'Y') THEN
8489: pa_debug.debug('PA_TASK_PVT1.Update_Task_Weighting begin');
8490: END IF;
8491:
8492: IF (p_commit = FND_API.G_TRUE) THEN
8493: savepoint update_task_weighting_pvt;

Line 8546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8542: END IF;
8543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8544: x_msg_count := FND_MSG_PUB.count_msg;
8545: --put message
8546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8547: p_procedure_name => 'Update_Task_Weighting',
8548: p_error_text => SUBSTRB(SQLERRM,1,240));
8549: RAISE;
8550: END UPDATE_TASK_WEIGHTING;

Line 8658: PA_TASK_PVT1.Update_Task_Weighting(

8654: l_current_rec_ver_number := l_record_version_number;
8655: -- end anlee
8656:
8657: --update task weighting
8658: PA_TASK_PVT1.Update_Task_Weighting(
8659: p_object_relationship_id => l_object_relationship_id
8660: ,p_weighting_percentage => l_weighting
8661: ,p_record_version_number => l_record_version_number
8662: ,x_return_status => l_return_status

Line 8693: PA_TASK_PVT1.Update_Task_Weighting(

8689:
8690: l_remainder := 100 - l_current_sum;
8691: if(l_remainder > 0) AND l_progress_allowed = 'Y' then
8692: --update task weighting
8693: PA_TASK_PVT1.Update_Task_Weighting(
8694: p_object_relationship_id => l_current_obj_rel_id
8695: ,p_weighting_percentage => l_current_weighting + l_remainder
8696: ,p_record_version_number => l_current_rec_ver_number + 1
8697: ,x_return_status => l_return_status

Line 8729: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8725: WHEN OTHERS THEN
8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8727: x_msg_count := FND_MSG_PUB.count_msg;
8728: --put message
8729: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8730: p_procedure_name => 'RECALC_TASKS_WEIGHTING',
8731: p_error_text => SUBSTRB(SQLERRM,1,240));
8732: RAISE;
8733: END RECALC_TASKS_WEIGHTING;

Line 8793: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8789: x_return_status := FND_API.G_RET_STS_SUCCESS;
8790: EXCEPTION
8791: WHEN OTHERS THEN
8792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8793: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8794: p_procedure_name => 'update_task_ver_delete_status',
8795: p_error_text => SUBSTRB(SQLERRM,1,240));
8796: raise;
8797: END update_task_ver_delete_status;

Line 9030: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL begin');

9026:
9027: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
9028:
9029: IF (p_debug_mode = 'Y') THEN
9030: pa_debug.debug('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL begin');
9031: END IF;
9032:
9033: IF (p_commit = FND_API.G_TRUE) THEN
9034: savepoint DELETE_TASK_VER_WO_VAL;

Line 9119: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9115: ,x_msg_count => x_msg_count
9116: ,x_msg_data => x_msg_data);
9117: EXCEPTION
9118: WHEN OTHERS THEN
9119: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9120: p_procedure_name => 'delete_Task_ver_wo_val',
9121: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9122: RAISE FND_API.G_EXC_ERROR;
9123: END;

Line 9269: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

9265: FETCH get_subproj_relation INTO get_subproj_relation_rec;
9266: IF get_subproj_relation%FOUND --bug 4573340
9267: THEN
9268: IF l_debug_mode = 'Y' THEN
9269: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
9270: ||get_subproj_relation_rec.object_relationship_id, 3);
9271: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
9272: ||get_subproj_relation_rec.record_version_number, 3);
9273:

Line 9271: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

9267: THEN
9268: IF l_debug_mode = 'Y' THEN
9269: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
9270: ||get_subproj_relation_rec.object_relationship_id, 3);
9271: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
9272: ||get_subproj_relation_rec.record_version_number, 3);
9273:
9274: END IF;
9275:

Line 9293: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

9289: ,x_msg_data => l_msg_data
9290: );
9291:
9292: IF l_debug_mode = 'Y' THEN
9293: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
9294: END IF;
9295:
9296:
9297: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 9492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9488: ,x_msg_count => x_msg_count
9489: ,x_msg_data => x_msg_data);
9490: EXCEPTION
9491: WHEN OTHERS THEN
9492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9493: p_procedure_name => 'delete_Task_ver_wo_val',
9494: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9495: RAISE FND_API.G_EXC_ERROR;
9496: END;

Line 9591: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

9587:
9588: --hsiu
9589: --added for task weighting
9590: IF (p_calling_module <> 'DEL_STRUCT') THEN
9591: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
9592: p_task_version_id => l_old_parent_ver_id
9593: ,x_return_status => l_return_status
9594: ,x_msg_count => l_msg_count
9595: ,x_msg_data => l_msg_data

Line 9664: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9660: END IF;
9661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9662: x_msg_count := FND_MSG_PUB.count_msg;
9663: --put message
9664: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9665: p_procedure_name => 'delete_Task_ver_wo_val',
9666: p_error_text => SUBSTRB(SQLERRM,1,240));
9667: RAISE;
9668: END delete_task_ver_wo_val;

Line 9750: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(

9746: where object_id_to1 = l_working_ver_id
9747: and relationship_type = 'S'
9748: and object_type_to = 'PA_TASKS';
9749: --pro-rate peer task weightings
9750: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
9751: p_task_version_id => l_working_parent_id
9752: ,x_return_status => x_return_status
9753: ,x_msg_count => x_msg_count
9754: ,x_msg_data => x_msg_data

Line 9769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9765: WHEN FND_API.G_EXC_ERROR THEN
9766: x_return_status := FND_API.G_RET_STS_ERROR;
9767: WHEN OTHERS THEN
9768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9770: p_procedure_name => 'UPDATE_WORKING_VER_WEIGHT',
9771: p_error_text => SUBSTRB(SQLERRM,1,240));
9772: RAISE;
9773: END UPDATE_WORKING_VER_WEIGHT;

Line 9967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9963: WHEN FND_API.G_EXC_ERROR THEN
9964: x_return_status := FND_API.G_RET_STS_ERROR;
9965: WHEN OTHERS THEN
9966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9968: p_procedure_name => 'set_new_tasks_to_TBD',
9969: p_error_text => SUBSTRB(SQLERRM,1,240));
9970: RAISE;
9971: END set_new_tasks_to_TBD;

Line 10016: pa_debug.debug('PA_TASK_PVT1.Update_Dates_To_All_Versions begin');

10012: START WITH OBJECT_ID_TO1 = c_elem_ver_id ;
10013:
10014: BEGIN
10015: IF (p_debug_mode = 'Y') THEN
10016: pa_debug.debug('PA_TASK_PVT1.Update_Dates_To_All_Versions begin');
10017: END IF;
10018:
10019: IF (p_commit = FND_API.G_TRUE) THEN
10020: savepoint UPDATE_SCH_VER_PRIVATE_DATES;

Line 10079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

10075: END IF;
10076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10077: x_msg_count := FND_MSG_PUB.count_msg;
10078: --put message
10079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10080: p_procedure_name => 'Update_Dates_To_All_Versions',
10081: p_error_text => SUBSTRB(SQLERRM,1,240));
10082: RAISE;
10083: END Update_Dates_To_All_Versions;

Line 10106: END PA_TASK_PVT1;

10102:
10103: END rollup_all_working_ver;
10104: */
10105:
10106: END PA_TASK_PVT1;