DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 5742: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

5738: l_calling_context := 'PA_DELETE_TASKS';
5739: END IF;
5740:
5741: BEGIN
5742: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5743: p_context => 'WORKPLAN'
5744: ,p_calling_context => l_calling_context -- Bug 9535723
5745: ,p_task_or_res => 'TASKS'
5746: ,p_element_version_id_tbl => l_element_version_id_tbl

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

5750: EXCEPTION
5751: WHEN OTHERS THEN
5752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5753: p_procedure_name => 'delete_Task_version',
5754: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5755: RAISE FND_API.G_EXC_ERROR;
5756: END;
5757: IF x_return_status = FND_API.G_RET_STS_ERROR then
5758: RAISE FND_API.G_EXC_ERROR;

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

5979: THEN
5980: l_element_version_id_tbl.extend(1);
5981: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
5982: --Smukka Bug No. 3474141 Date 03/01/2004
5983: --moved PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions into plsql block
5984: BEGIN
5985: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5986: p_context => 'WORKPLAN'
5987: ,p_task_or_res => 'TASKS'

Line 5985: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

5981: l_element_version_id_tbl(1) := cur_child_tasks_rec.object_id_to1;
5982: --Smukka Bug No. 3474141 Date 03/01/2004
5983: --moved PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions into plsql block
5984: BEGIN
5985: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
5986: p_context => 'WORKPLAN'
5987: ,p_task_or_res => 'TASKS'
5988: ,p_element_version_id_tbl => l_element_version_id_tbl
5989: -- ,p_maintain_reporting_lines => 'Y'

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

5993: EXCEPTION
5994: WHEN OTHERS THEN
5995: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5996: p_procedure_name => 'delete_Task_version',
5997: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5998: RAISE FND_API.G_EXC_ERROR;
5999: END;
6000: IF x_return_status = FND_API.G_RET_STS_ERROR then
6001: RAISE FND_API.G_EXC_ERROR;

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

9027: end if;
9028: --bug 3802976
9029:
9030: /*Smukka Bug No. 3474141 Date 03/01/2004 */
9031: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
9032: BEGIN
9033: IF l_update_effort_flag = 'Y'
9034: THEN
9035: pa_fp_planning_transaction_pub.update_planning_transactions

Line 9035: pa_fp_planning_transaction_pub.update_planning_transactions

9031: /*moved pa_fp_planning_transaction_pub.update_planning_transactions into plsql block */
9032: BEGIN
9033: IF l_update_effort_flag = 'Y'
9034: THEN
9035: pa_fp_planning_transaction_pub.update_planning_transactions
9036: (
9037: p_context => 'WORKPLAN'
9038: -- ,p_maintain_reporting_lines => 'Y'
9039: ,p_struct_elem_version_id => l_parent_struc_ver_id

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

9049: EXCEPTION
9050: WHEN OTHERS THEN
9051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9052: p_procedure_name => 'update_schedule_version',
9053: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
9054: RAISE FND_API.G_EXC_ERROR;
9055: END;
9056:
9057: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 9857: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

9853: when context is other than 'DEL_STRUCT'
9854: */
9855: IF (p_calling_module <> 'DEL_STRUCT') THEN
9856: BEGIN
9857: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
9858: p_context => 'WORKPLAN'
9859: ,p_task_or_res => 'TASKS'
9860: ,p_element_version_id_tbl => l_element_version_id_tbl
9861: -- ,p_maintain_reporting_lines => 'Y'

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

9865: EXCEPTION
9866: WHEN OTHERS THEN
9867: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9868: p_procedure_name => 'delete_Task_ver_wo_val',
9869: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9870: RAISE FND_API.G_EXC_ERROR;
9871: END;
9872: IF x_return_status = FND_API.G_RET_STS_ERROR then
9873: RAISE FND_API.G_EXC_ERROR;

Line 10240: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(

10236: -- 2) do not call delete planning txn api when deleting entire structure version.
10237: IF l_call_del_plan_txn = 'Y'
10238: THEN
10239: BEGIN
10240: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions(
10241: p_context => 'WORKPLAN'
10242: ,p_task_or_res => 'TASKS'
10243: ,p_element_version_id_tbl => l_element_version_id_tbl
10244: ,x_return_status => x_return_status

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

10247: EXCEPTION
10248: WHEN OTHERS THEN
10249: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10250: p_procedure_name => 'delete_Task_ver_wo_val',
10251: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
10252: RAISE FND_API.G_EXC_ERROR;
10253: END;
10254: IF x_return_status = FND_API.G_RET_STS_ERROR then
10255: RAISE FND_API.G_EXC_ERROR;