DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 813: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */

809: -- Added by skannoji
810: -- added for doosan customer to add the planning transaction
811: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_structure_version_id, 'WORKPLAN') = 'Y') THEN
812: /*Smukka Bug No. 3474141 Date 03/01/2004 */
813: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
814: BEGIN
815: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
816: (
817: p_context => 'WORKPLAN'

Line 815: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions

811: IF ( PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(x_structure_version_id, 'WORKPLAN') = 'Y') THEN
812: /*Smukka Bug No. 3474141 Date 03/01/2004 */
813: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
814: BEGIN
815: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions
816: (
817: p_context => 'WORKPLAN'
818: ,p_project_id => l_project_id
819: ,p_struct_elem_version_id => x_structure_version_id

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

824: EXCEPTION
825: WHEN OTHERS THEN
826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_PVT1',
827: p_procedure_name => 'CREATE_STRUCTURE_VERSION',
828: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions:'||SQLERRM,1,240));
829: RAISE FND_API.G_EXC_ERROR;
830: END;
831: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
832: RAISE FND_API.G_EXC_ERROR;

Line 15050: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */

15046: CLOSE sel_struc_ver;
15047:
15048: --add financial planning
15049: /*Smukka Bug No. 3474141 Date 03/01/2004 */
15050: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
15051: BEGIN
15052: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
15053: p_context => 'WORKPLAN'
15054: ,p_project_id => p_project_id

Line 15052: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(

15048: --add financial planning
15049: /*Smukka Bug No. 3474141 Date 03/01/2004 */
15050: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
15051: BEGIN
15052: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
15053: p_context => 'WORKPLAN'
15054: ,p_project_id => p_project_id
15055: ,p_struct_elem_version_id => l_structure_version_id
15056: ,x_return_status => l_return_status

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

15059: EXCEPTION
15060: WHEN OTHERS THEN
15061: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_PVT1',
15062: p_procedure_name => 'update_structures_setup_attr',
15063: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions:'||SQLERRM,1,240));
15064: RAISE FND_API.G_EXC_ERROR;
15065: END;
15066: --Check if there is any error.
15067: l_msg_count := FND_MSG_PUB.count_msg;

Line 17040: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */

17036:
17037: --add planning transaction to the shared structure version
17038: --add financial planning
17039: /*Smukka Bug No. 3474141 Date 03/01/2004 */
17040: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
17041: BEGIN
17042: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
17043: p_context => 'WORKPLAN'
17044: ,p_project_id => p_project_id

Line 17042: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(

17038: --add financial planning
17039: /*Smukka Bug No. 3474141 Date 03/01/2004 */
17040: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
17041: BEGIN
17042: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
17043: p_context => 'WORKPLAN'
17044: ,p_project_id => p_project_id
17045: ,p_struct_elem_version_id => l_structure_version_id
17046: ,x_return_status => l_return_status

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

17049: EXCEPTION
17050: WHEN OTHERS THEN
17051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_PVT1',
17052: p_procedure_name => 'update_structures_setup_attr',
17053: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions:'||SQLERRM,1,240));
17054: RAISE FND_API.G_EXC_ERROR;
17055: END;
17056: --Check if there is any error.
17057: l_msg_count := FND_MSG_PUB.count_msg;

Line 17431: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */

17427: CLOSE sel_struc_ver;
17428:
17429: --add financial planning
17430: /*Smukka Bug No. 3474141 Date 03/01/2004 */
17431: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
17432: BEGIN
17433: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
17434: p_context => 'WORKPLAN'
17435: ,p_project_id => p_project_id

Line 17433: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(

17429: --add financial planning
17430: /*Smukka Bug No. 3474141 Date 03/01/2004 */
17431: /*moved PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions into plsql block */
17432: BEGIN
17433: PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions(
17434: p_context => 'WORKPLAN'
17435: ,p_project_id => p_project_id
17436: ,p_struct_elem_version_id => l_structure_version_id
17437: ,x_return_status => l_return_status

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

17440: EXCEPTION
17441: WHEN OTHERS THEN
17442: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_STRUCTURE_PVT1',
17443: p_procedure_name => 'update_structures_setup_attr',
17444: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions:'||SQLERRM,1,240));
17445: RAISE FND_API.G_EXC_ERROR;
17446: END;
17447: --Check if there is any error.
17448: l_msg_count := FND_MSG_PUB.count_msg;