DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 5235: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

5231: l_element_version_id_tbl(l_element_version_id_tbl.count) := i.task_ver_id;
5232: END LOOP;
5233:
5234: BEGIN
5235: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5236: p_context => 'WORKPLAN'
5237: ,p_task_or_res => 'TASKS'
5238: ,p_element_version_id_tbl => l_element_version_id_tbl
5239: ,x_return_status => x_return_status

Line 5246: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));

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;
5249: IF x_return_status = FND_API.G_RET_STS_ERROR then
5250: RAISE FND_API.G_EXC_ERROR;

Line 5475: --moved PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions into plsql block

5471: THEN
5472: l_element_version_id_tbl.extend(1);
5473: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
5474: --Smukka Bug No. 3474141 Date 03/01/2004
5475: --moved PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions into plsql block
5476: BEGIN
5477: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5478: p_context => 'WORKPLAN'
5479: ,p_task_or_res => 'TASKS'

Line 5477: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

5473: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
5474: --Smukka Bug No. 3474141 Date 03/01/2004
5475: --moved PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions into plsql block
5476: BEGIN
5477: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5478: p_context => 'WORKPLAN'
5479: ,p_task_or_res => 'TASKS'
5480: ,p_element_version_id_tbl => l_element_version_id_tbl
5481: -- ,p_maintain_reporting_lines => 'Y'

Line 5489: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));

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;
5492: IF x_return_status = FND_API.G_RET_STS_ERROR then
5493: RAISE FND_API.G_EXC_ERROR;

Line 8285: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */

8281: end if;
8282: --bug 3802976
8283:
8284: /*Smukka Bug No. 3474141 Date 03/01/2004 */
8285: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
8286: BEGIN
8287: IF l_update_effort_flag = 'Y'
8288: THEN
8289: pa_fp_planning_transaction_pub.update_planning_transactions

Line 8289: pa_fp_planning_transaction_pub.update_planning_transactions

8285: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
8286: BEGIN
8287: IF l_update_effort_flag = 'Y'
8288: THEN
8289: pa_fp_planning_transaction_pub.update_planning_transactions
8290: (
8291: p_context => 'WORKPLAN'
8292: -- ,p_maintain_reporting_lines => 'Y'
8293: ,p_struct_elem_version_id => l_parent_struc_ver_id

Line 8307: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));

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;
8310:
8311: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 9109: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

9105: when context is other than 'DEL_STRUCT'
9106: */
9107: IF (p_calling_module <> 'DEL_STRUCT') THEN
9108: BEGIN
9109: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
9110: p_context => 'WORKPLAN'
9111: ,p_task_or_res => 'TASKS'
9112: ,p_element_version_id_tbl => l_element_version_id_tbl
9113: -- ,p_maintain_reporting_lines => 'Y'

Line 9121: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));

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;
9124: IF x_return_status = FND_API.G_RET_STS_ERROR then
9125: RAISE FND_API.G_EXC_ERROR;

Line 9483: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

9479: -- 2) do not call delete planning txn api when deleting entire structure version.
9480: IF l_call_del_plan_txn = 'Y'
9481: THEN
9482: BEGIN
9483: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
9484: p_context => 'WORKPLAN'
9485: ,p_task_or_res => 'TASKS'
9486: ,p_element_version_id_tbl => l_element_version_id_tbl
9487: ,x_return_status => x_return_status

Line 9494: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));

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;
9497: IF x_return_status = FND_API.G_RET_STS_ERROR then
9498: RAISE FND_API.G_EXC_ERROR;