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 2096: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.

2092: p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
2093: raise fnd_api.g_exc_error;
2094: end;
2095:
2096: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
2097:
2098: begin
2099: pa_fp_planning_transaction_pub.delete_planning_transactions
2100: (

Line 2099: pa_fp_planning_transaction_pub.delete_planning_transactions

2095:
2096: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
2097:
2098: begin
2099: pa_fp_planning_transaction_pub.delete_planning_transactions
2100: (
2101: p_context => 'WORKPLAN'
2102: ,p_task_or_res => 'TASKS'
2103: ,p_element_version_id_tbl => l_del_task_ver_ids

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

2108: exception
2109: when others then
2110: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
2111: p_procedure_name => 'CREATE_PROJECT',
2112: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
2113: raise fnd_api.g_exc_error;
2114: end;
2115:
2116: /* Bug # 3420093 - Adding Progress Management modifications to create_task flow. */

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

3406: END LOOP;
3407: END IF;
3408: -- End of bug 7358214
3409:
3410: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
3411:
3412: IF l_del_task_ver_ids.exists(1) THEN -- Bug 7358214
3413: begin
3414: pa_fp_planning_transaction_pub.delete_planning_transactions

Line 3414: pa_fp_planning_transaction_pub.delete_planning_transactions

3410: -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
3411:
3412: IF l_del_task_ver_ids.exists(1) THEN -- Bug 7358214
3413: begin
3414: pa_fp_planning_transaction_pub.delete_planning_transactions
3415: (
3416: p_context => 'WORKPLAN'
3417: ,p_task_or_res => 'TASKS'
3418: ,p_element_version_id_tbl => l_del_task_ver_ids

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

3423: exception
3424: when others then
3425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
3426: p_procedure_name => 'CREATE_PROJECT',
3427: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
3428: raise fnd_api.g_exc_error;
3429: end;
3430: END IF ; --bug 7358214
3431: /* Bug # 3420093 - Adding Progress Management modifications to update_task flow. */

Line 5333: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions

5329: raise FND_API.G_EXC_ERROR;
5330: END IF;
5331: -- Bug 4574032 Begin
5332: BEGIN
5333: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
5334: (
5335: p_context => 'WORKPLAN'
5336: ,p_project_id => p_project_id
5337: ,p_struct_elem_version_id => x_structure_version_id

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

5342: EXCEPTION
5343: WHEN OTHERS THEN
5344: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TASK_STRUC_PUB',
5345: p_procedure_name => 'CREATE_UPDATE_STRUCT_VER',
5346: p_error_text => SUBSTRB('call of pa_fp_planning_transaction_pub.add_planning_transactions failed. sqlerrm= :'||SQLERRM,1,240));
5347: raise fnd_api.g_exc_error;
5348: END;
5349: IF l_return_status <> 'S' THEN
5350: raise FND_API.G_EXC_ERROR;

Line 10299: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions

10295: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions ', l_debug_level3);
10296: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions p_dest_project_id '||p_dest_project_id, l_debug_level3);
10297: Pa_Debug.WRITE(G_PKG_NAME, 'Calling add_planning_transactions l_new_wp_ver_id '||l_new_wp_ver_id, l_debug_level3);
10298: END IF;
10299: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
10300: (
10301: p_context => 'WORKPLAN'
10302: ,p_project_id => p_dest_project_id
10303: ,p_struct_elem_version_id => l_new_wp_ver_id

Line 16249: pa_fp_planning_transaction_pub.add_planning_transactions(

16245: if (l_add_task_ver_ids.count = 1000) then
16246: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN
16247: BEGIN
16248:
16249: pa_fp_planning_transaction_pub.add_planning_transactions(
16250: p_context => 'WORKPLAN'
16251: ,p_project_id => p_project_id
16252: ,p_struct_elem_version_id => l_structure_version_id
16253: ,p_task_elem_version_id_tbl => l_add_task_ver_ids

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

16263: EXCEPTION
16264: WHEN OTHERS THEN
16265: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16266: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16267: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.add_planning_transactions:'||SQLERRM,1,240));
16268: raise fnd_api.g_exc_error;
16269: END;
16270:
16271: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 16831: pa_fp_planning_transaction_pub.add_planning_transactions(

16827: IF ((p_structure_type = 'WORKPLAN' AND p_is_wp_separate_from_fn = 'Y') OR p_is_wp_separate_from_fn = 'N' ) THEN
16828: -- 4198962 Moved call of add_planning_transactions before population of l_del_task_ver_ids
16829: IF l_add_task_ver_ids.exists(1) AND l_structure_version_id IS NOT NULL THEN
16830: BEGIN
16831: pa_fp_planning_transaction_pub.add_planning_transactions(
16832: p_context => 'WORKPLAN'
16833: ,p_project_id => p_project_id
16834: ,p_struct_elem_version_id => l_structure_version_id
16835: ,p_task_elem_version_id_tbl => l_add_task_ver_ids

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

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

Line 16974: pa_fp_planning_transaction_pub.delete_planning_transactions(

16970:
16971: if (l_del_task_ver_ids.count = 1000) then
16972: IF l_del_task_ver_ids.exists(1) THEN
16973: BEGIN
16974: pa_fp_planning_transaction_pub.delete_planning_transactions(
16975: p_context => 'WORKPLAN'
16976: ,p_task_or_res => 'TASKS'
16977: ,p_element_version_id_tbl => l_del_task_ver_ids
16978: ,x_return_status => l_return_status

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

16982: EXCEPTION
16983: WHEN OTHERS THEN
16984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
16985: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
16986: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
16987: raise fnd_api.g_exc_error;
16988: END;
16989:
16990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 17007: pa_fp_planning_transaction_pub.delete_planning_transactions(

17003: -- 4198962 Moved call of add_planning_transactions before population of l_del_task_ver_ids
17004:
17005: IF l_del_task_ver_ids.exists(1) THEN
17006: BEGIN
17007: pa_fp_planning_transaction_pub.delete_planning_transactions(
17008: p_context => 'WORKPLAN'
17009: ,p_task_or_res => 'TASKS'
17010: ,p_element_version_id_tbl => l_del_task_ver_ids
17011: ,x_return_status => l_return_status

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

17015: EXCEPTION
17016: WHEN OTHERS THEN
17017: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PUB',
17018: p_procedure_name => 'PROCESS_TASK_STRUCTURE_BULK',
17019: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.delete_planning_transactions:'||SQLERRM,1,240));
17020: raise fnd_api.g_exc_error;
17021: END;
17022:
17023: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

17093: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17094: -- raise fnd_api.g_exc_error;
17095: -- end;
17096: --
17097: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
17098: --
17099: -- begin
17100: -- --BUG 3802469, rtarway , if the tasks table is empty, l_del_task_ver_ids will not be populated.
17101: -- --Check needed before calling delete_planning_transactions, to see if l_del_task_ver_ids is empty

Line 17104: -- pa_fp_planning_transaction_pub.delete_planning_transactions

17100: -- --BUG 3802469, rtarway , if the tasks table is empty, l_del_task_ver_ids will not be populated.
17101: -- --Check needed before calling delete_planning_transactions, to see if l_del_task_ver_ids is empty
17102: -- if ( l_del_task_ver_ids IS NOT NULL AND l_del_task_ver_ids.count > 0)
17103: -- then
17104: -- pa_fp_planning_transaction_pub.delete_planning_transactions
17105: -- (
17106: -- p_context => 'WORKPLAN'
17107: -- ,p_task_or_res => 'TASKS'
17108: -- ,p_element_version_id_tbl => l_del_task_ver_ids

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

17116: -- exception
17117: -- when others then
17118: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17119: -- p_procedure_name => 'CREATE_PROJECT',
17120: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17121: -- raise fnd_api.g_exc_error;
17122: -- end;
17123: --
17124: --/* Bug # 3420093 - Adding Progress Management modifications to create_project flow. */

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

17181: -- p_error_text => substrb('PA_TASK_PUB1.CALL_ADD_PLANNING_TXNS:'||sqlerrm,1,240));
17182: -- raise fnd_api.g_exc_error;
17183: -- end;
17184: --
17185: -- -- Calling pa_fp_planning_transaction_pub.delete_planning_transactions for higher level tasks.
17186: --
17187: -- begin
17188: -- --BUG3802469, rtarway, see comments above
17189: -- if ( l_del_task_ver_ids IS NOT NULL and l_del_task_ver_ids.count > 0)

Line 17191: -- pa_fp_planning_transaction_pub.delete_planning_transactions

17187: -- begin
17188: -- --BUG3802469, rtarway, see comments above
17189: -- if ( l_del_task_ver_ids IS NOT NULL and l_del_task_ver_ids.count > 0)
17190: -- then
17191: -- pa_fp_planning_transaction_pub.delete_planning_transactions
17192: -- (
17193: -- p_context => 'WORKPLAN'
17194: -- ,p_task_or_res => 'TASKS'
17195: -- ,p_element_version_id_tbl => l_del_task_ver_ids

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

17203: -- exception
17204: -- when others then
17205: -- fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_project_pub',
17206: -- p_procedure_name => 'CREATE_PROJECT',
17207: -- p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.DELETE_PLANNING_TRANSACTIONS:'||SQLERRM,1,240));
17208: -- raise fnd_api.g_exc_error;
17209: -- end;
17210:
17211: --/* Bug # 3420093 - Adding Progress Management modifications to update_project flow. */