[Home] [Help]
41240:
41241: IF (l_assign_id IS NOT NULL) THEN
41242: l_assign_ids.extend(1);
41243: l_assign_ids(1) := l_assign_id;
41244: pa_fp_planning_transaction_pub.delete_planning_transactions
41245: (
41246: p_context => 'WORKPLAN'
41247: ,p_task_or_res => 'ASSIGNMENT'
41248: ,p_resource_assignment_tbl => l_assign_ids
41254: EXCEPTION
41255: WHEN OTHERS THEN
41256: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
41257: p_procedure_name => 'BULK_INDENT_TASKS_LITE',
41258: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
41259: RAISE FND_API.G_EXC_ERROR;
41260: END;
41261:
41262: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
42741: --now call call delete planning for task version id.
42742: l_task_ver_ids2.extend(1); /* Venky */
42743: l_task_ver_ids2(1) := p_task_version_id;
42744: /*Smukka Bug No. 3474141 Date 03/01/2004 */
42745: /*moved pa_fp_planning_transaction_pub.delete_planning_transactions into plsql block */
42746: DECLARE
42747: --p1 bug 3888432
42748: l_assign_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
42749: CURSOR get_assignment_id(c_task_ver_id NUMBER) IS
42759:
42760: IF (l_assign_id IS NOT NULL) THEN
42761: l_assign_ids.extend(1);
42762: l_assign_ids(1) := l_assign_id;
42763: pa_fp_planning_transaction_pub.delete_planning_transactions
42764: (
42765: p_context => 'WORKPLAN'
42766: ,p_task_or_res => 'ASSIGNMENT'
42767: -- ,p_element_version_id_tbl => l_task_ver_ids2
42775: EXCEPTION
42776: WHEN OTHERS then
42777: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
42778: p_procedure_name => 'BULK_OUTDENT_TASKS_LITE',
42779: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
42780: RAISE FND_API.G_EXC_ERROR;
42781: END;
42782: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
42783: x_msg_count := FND_MSG_PUB.count_msg;