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_PROJ_TASK_STRUC_PUB dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 2312: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

2308: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
2309: raise fnd_api.g_exc_error;
2310: end;
2311:
2312: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
2313:
2314: begin
2315: pa_fp_planning_transaction_pub.delete_planning_transactions
2316: (

Line 2315: pa_fp_planning_transaction_pub.delete_planning_transactions

2311:
2312: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
2313:
2314: begin
2315: pa_fp_planning_transaction_pub.delete_planning_transactions
2316: (
2317: p_context => 'WORKPLAN'
2318: ,p_task_or_res => 'TASKS'
2319: ,p_element_version_id_tbl => l_del_task_ver_ids

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

2324: exception
2325: when others then
2326: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2327: p_procedure_name => 'CREATE_PROJECT',
2328: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
2329: raise fnd_api.g_exc_error;
2330: end;
2331:
2332: /* Bug # 3420093 - Adding Progress Management modifications to create_task flow. */

Line 3631: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

3627: END IF; -- Huawei changes ends
3628: END IF;
3629: -- End of bug 7358214
3630:
3631: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
3632:
3633: IF l_del_task_ver_ids.exists(1) THEN -- Bug 7358214
3634: begin
3635: pa_fp_planning_transaction_pub.delete_planning_transactions

Line 3635: pa_fp_planning_transaction_pub.delete_planning_transactions

3631: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
3632:
3633: IF l_del_task_ver_ids.exists(1) THEN -- Bug 7358214
3634: begin
3635: pa_fp_planning_transaction_pub.delete_planning_transactions
3636: (
3637: p_context => 'WORKPLAN'
3638: ,p_task_or_res => 'TASKS'
3639: ,p_element_version_id_tbl => l_del_task_ver_ids

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

3644: exception
3645: when others then
3646: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3647: p_procedure_name => 'CREATE_PROJECT',
3648: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
3649: raise fnd_api.g_exc_error;
3650: end;
3651: END IF ; --bug 7358214
3652: /* Bug # 3420093 - Adding Progress Management modifications to update_task flow. */

Line 5554: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions

5550: raise FND_API.G_EXC_ERROR;
5551: END IF;
5552: -- Bug 4574032 Begin
5553: BEGIN
5554: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
5555: (
5556: p_context => 'WORKPLAN'
5557: ,p_project_id => p_project_id
5558: ,p_struct_elem_version_id => x_structure_version_id

Line 5567: p_error_text => SUBSTRB('call of pa_fp_planning_transaction_pub.add_planning_transactions failed. sqlerrm= :'||SQLERRM,1,240));

5563: EXCEPTION
5564: WHEN OTHERS THEN
5565: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TASK_STRUC_PUB',
5566: p_procedure_name => 'CREATE_UPDATE_STRUCT_VER',
5567: p_error_text => SUBSTRB('call of pa_fp_planning_transaction_pub.add_planning_transactions failed. sqlerrm= :'||SQLERRM,1,240));
5568: raise fnd_api.g_exc_error;
5569: END;
5570: IF l_return_status <> 'S' THEN
5571: raise FND_API.G_EXC_ERROR;

Line 10593: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions

10589: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions ', l_debug_level3);
10590: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions p_dest_project_id '||p_dest_project_id, l_debug_level3);
10591: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions l_new_wp_ver_id '||l_new_wp_ver_id, l_debug_level3);
10592: END IF;
10593: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
10594: (
10595: p_context => 'WORKPLAN'
10596: ,p_project_id => p_dest_project_id
10597: ,p_struct_elem_version_id => l_new_wp_ver_id

Line 16826: pa_fp_planning_transaction_pub.add_planning_transactions(

16822: if (l_add_task_ver_ids.count = 1000) then
16823: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN
16824: BEGIN
16825:
16826: pa_fp_planning_transaction_pub.add_planning_transactions(
16827: p_context => 'WORKPLAN'
16828: ,p_project_id => p_project_id
16829: ,p_struct_elem_version_id => l_structure_version_id
16830: ,p_task_elem_version_id_tbl => l_add_task_ver_ids

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

16840: EXCEPTION
16841: WHEN OTHERS THEN
16842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16843: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16844: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
16845: raise fnd_api.g_exc_error;
16846: END;
16847:
16848: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 17483: pa_fp_planning_transaction_pub.add_planning_transactions(

17479: IF ((p_structure_type = 'WORKPLAN' AND p_is_wp_separate_from_fn = 'Y') OR p_is_wp_separate_from_fn = 'N' ) THEN
17480: -- 4198962 Moved call of add_planning_transactions before population of l_del_task_ver_ids
17481: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN
17482: BEGIN
17483: pa_fp_planning_transaction_pub.add_planning_transactions(
17484: p_context => 'WORKPLAN'
17485: ,p_project_id => p_project_id
17486: ,p_struct_elem_version_id => l_structure_version_id
17487: ,p_task_elem_version_id_tbl => l_add_task_ver_ids

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

17496: EXCEPTION
17497: WHEN OTHERS THEN
17498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17499: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17500: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
17501: raise fnd_api.g_exc_error;
17502: END;
17503:
17504: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 17626: pa_fp_planning_transaction_pub.delete_planning_transactions(

17622:
17623: if (l_del_task_ver_ids.count = 1000) then
17624: IF l_del_task_ver_ids.exists(1) THEN
17625: BEGIN
17626: pa_fp_planning_transaction_pub.delete_planning_transactions(
17627: p_context => 'WORKPLAN'
17628: ,p_task_or_res => 'TASKS'
17629: ,p_element_version_id_tbl => l_del_task_ver_ids
17630: ,x_return_status => l_return_status

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

17634: EXCEPTION
17635: WHEN OTHERS THEN
17636: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17637: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17638: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17639: raise fnd_api.g_exc_error;
17640: END;
17641:
17642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 17659: pa_fp_planning_transaction_pub.delete_planning_transactions(

17655: -- 4198962 Moved call of add_planning_transactions before population of l_del_task_ver_ids
17656:
17657: IF l_del_task_ver_ids.exists(1) THEN
17658: BEGIN
17659: pa_fp_planning_transaction_pub.delete_planning_transactions(
17660: p_context => 'WORKPLAN'
17661: ,p_task_or_res => 'TASKS'
17662: ,p_element_version_id_tbl => l_del_task_ver_ids
17663: ,x_return_status => l_return_status

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

17667: EXCEPTION
17668: WHEN OTHERS THEN
17669: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17670: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17671: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17672: raise fnd_api.g_exc_error;
17673: END;
17674:
17675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 17749: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

17745: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17746: -- raise fnd_api.g_exc_error;
17747: -- end;
17748: --
17749: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
17750: --
17751: -- begin
17752: -- --BUG 3802469, rtarway , if the tasks table is empty, l_del_task_ver_ids will not be populated.
17753: -- --Check needed before calling delete_planning_transactions, to see if l_del_task_ver_ids is empty

Line 17756: -- pa_fp_planning_transaction_pub.delete_planning_transactions

17752: -- --BUG 3802469, rtarway , if the tasks table is empty, l_del_task_ver_ids will not be populated.
17753: -- --Check needed before calling delete_planning_transactions, to see if l_del_task_ver_ids is empty
17754: -- if ( l_del_task_ver_ids IS NOT NULL AND l_del_task_ver_ids.count > 0)
17755: -- then
17756: -- pa_fp_planning_transaction_pub.delete_planning_transactions
17757: -- (
17758: -- p_context => 'WORKPLAN'
17759: -- ,p_task_or_res => 'TASKS'
17760: -- ,p_element_version_id_tbl => l_del_task_ver_ids

Line 17772: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));

17768: -- exception
17769: -- when others then
17770: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17771: -- p_procedure_name => 'CREATE_PROJECT',
17772: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17773: -- raise fnd_api.g_exc_error;
17774: -- end;
17775: --
17776: --/* Bug # 3420093 - Adding Progress Management modifications to create_project flow. */

Line 17837: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

17833: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17834: -- raise fnd_api.g_exc_error;
17835: -- end;
17836: --
17837: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
17838: --
17839: -- begin
17840: -- --BUG3802469, rtarway, see comments above
17841: -- if ( l_del_task_ver_ids IS NOT NULL and l_del_task_ver_ids.count > 0)

Line 17843: -- pa_fp_planning_transaction_pub.delete_planning_transactions

17839: -- begin
17840: -- --BUG3802469, rtarway, see comments above
17841: -- if ( l_del_task_ver_ids IS NOT NULL and l_del_task_ver_ids.count > 0)
17842: -- then
17843: -- pa_fp_planning_transaction_pub.delete_planning_transactions
17844: -- (
17845: -- p_context => 'WORKPLAN'
17846: -- ,p_task_or_res => 'TASKS'
17847: -- ,p_element_version_id_tbl => l_del_task_ver_ids

Line 17859: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));

17855: -- exception
17856: -- when others then
17857: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17858: -- p_procedure_name => 'CREATE_PROJECT',
17859: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17860: -- raise fnd_api.g_exc_error;
17861: -- end;
17862:
17863: --/* Bug # 3420093 - Adding Progress Management modifications to update_project flow. */