[Home] [Help]
108: END IF;
109:
110: p_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: PA_PROJECT_PVT.Convert_pm_projref_to_id
113: ( p_pm_project_reference => p_pm_project_reference
114: , p_pa_project_id => p_project_id
115: , p_out_project_id => l_project_id_out
116: , p_return_status => l_return_status );
137:
138: Analysis:
139:
140: This error was also coming up from the Convert_pm_taskref_to_id_all API. There was a call to the
141: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all API in the flow. MSP calls the PA_PROJECT_PUB.check_task_mfd API
142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK
143: API and that in turn calls the pa_project_check_pvt.Check_Delete_Task_OK_pvt API.
144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the
140: This error was also coming up from the Convert_pm_taskref_to_id_all API. There was a call to the
141: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all API in the flow. MSP calls the PA_PROJECT_PUB.check_task_mfd API
142: to determine whether a task can be deleted at all or not. This in turn calls the pa_project_pub.Check_Delete_Task_OK
143: API and that in turn calls the pa_project_check_pvt.Check_Delete_Task_OK_pvt API.
144: In this API the call to PA_PROJECT_PVT.Convert_pm_taskref_to_id_all the structure type is also passed as shown below.
145: As the structure type 'FINANCIAL' was passed the Convert_pm_taskref_to_id_all API was looking for the task in the
146: PA_TASKS table in the cursor l_task_id_csr. As this was not returning any rows the above error is thrown. The task
147: is there but due to the structure type 'WORKPLAN' it is residing in the elements tables as it is not yet published as well.
148: Ideally we should pass 'WORKPLAN' as the structure type. This is being done in the PA_PROJECT_PUB.DELETE_TASK API.
175: --Change the flow to WORKPLAN
176: l_structure_type := 'WORKPLAN';
177: END IF;
178:
179: PA_PROJECT_PVT.Convert_pm_taskref_to_id_all
180: ( p_pa_project_id => l_project_id_out
181: , p_pa_task_id => p_task_id
182: , p_pm_task_reference => p_pm_task_reference
183: , p_structure_type => l_structure_type
234: );
235: --Project Structure changes done for bug 2765115
236:
237: /*
238: PA_PROJECT_PVT.Convert_pm_projref_to_id
239: ( p_pm_project_reference => p_pm_project_reference
240: , p_pa_project_id => p_project_id
241: , p_out_project_id => l_project_id_out
242: , p_return_status => l_return_status );
295: null; --in this case there wont be any task in pa_task
296: ELSE
297:
298: /* Commented below code and moved it above the call to PA_PROJ_TASK_STRUC_PUB.get_version_ids for bug 4738608
299: PA_PROJECT_PVT.Convert_pm_taskref_to_id
300: ( p_pa_project_id => l_project_id_out
301: , p_pa_task_id => p_task_id
302: , p_pm_task_reference => p_pm_task_reference
303: , p_out_task_id => l_task_id_out
366: THEN
367: p_delete_task_ok_flag := 'N';
368:
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
370: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
371: THEN
372: pa_interface_utils_pub.map_new_amg_msg
373: ( p_old_message_code => 'PA_CHECK_DELETE_TASK_FAILED'
374: ,p_msg_attribute => 'CHANGE'
395: --Project Structure changes done for bug 2765115
396: /* ELSIF l_err_code < 0
397: THEN
398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
399: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
400: THEN
401: pa_interface_utils_pub.map_new_amg_msg
402: ( p_old_message_code => 'PA_CHECK_DELETE_TASK_FAILED'
403: ,p_msg_attribute => 'CHANGE'
551: END IF;
552:
553: p_return_status := FND_API.G_RET_STS_SUCCESS;
554:
555: PA_PROJECT_PVT.Convert_pm_projref_to_id
556: ( p_pm_project_reference => p_pm_project_reference
557: , p_pa_project_id => p_project_id
558: , p_out_project_id => l_project_id_out
559: , p_return_status => l_return_status );
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
571:
572: PA_PROJECT_PVT.Convert_pm_taskref_to_id
573: ( p_pa_project_id => l_project_id_out
574: , p_pa_task_id => p_task_id
575: , p_pm_task_reference => p_pm_task_reference
576: , p_out_task_id => l_task_id_out
613: IF l_err_code > 0
614: THEN
615: p_add_subtask_ok_flag := 'N';
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
617: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
618: THEN
619: pa_interface_utils_pub.map_new_amg_msg
620: ( p_old_message_code => 'PA_CHECK_ADD_SUBTASK_FAILED'
621: ,p_msg_attribute => 'CHANGE'
642:
643: ELSIF l_err_code < 0
644: THEN
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
647: THEN
648: pa_interface_utils_pub.map_new_amg_msg
649: ( p_old_message_code => 'PA_CHECK_ADD_SUBTASK_FAILED'
650: ,p_msg_attribute => 'CHANGE'
792: END IF;
793:
794: p_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796: PA_PROJECT_PVT.Convert_pm_projref_to_id
797: ( p_pm_project_reference => p_pm_project_reference
798: , p_pa_project_id => p_project_id
799: , p_out_project_id => l_project_id_out
800: , p_return_status => l_return_status );
1051:
1052: p_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054:
1055: PA_PROJECT_PVT.Convert_pm_projref_to_id
1056: ( p_pm_project_reference => p_pm_project_reference
1057: , p_pa_project_id => p_project_id
1058: , p_out_project_id => l_project_id_out
1059: , p_return_status => l_return_status
1084: IF l_err_code > 0
1085: THEN
1086: p_delete_project_ok_flag := 'N';
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1088: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
1089: THEN
1090: pa_interface_utils_pub.map_new_amg_msg
1091: ( p_old_message_code => 'PA_CHECK_DEL_PROJECT_FAILED'
1092: ,p_msg_attribute => 'CHANGE'
1113:
1114: ELSIF l_err_code < 0
1115: THEN
1116: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1117: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
1118: THEN
1119: pa_interface_utils_pub.map_new_amg_msg
1120: ( p_old_message_code => 'PA_CHECK_DEL_PROJECT_FAILED'
1121: ,p_msg_attribute => 'CHANGE'
1254:
1255: p_return_status := FND_API.G_RET_STS_SUCCESS;
1256:
1257:
1258: PA_PROJECT_PVT.Convert_pm_projref_to_id
1259: ( p_pm_project_reference => p_pm_project_reference
1260: , p_pa_project_id => p_project_id
1261: , p_out_project_id => l_project_id_out
1262: , p_return_status => l_return_status
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1275: ( p_pa_project_id => l_project_id_out
1276: , p_pa_task_id => p_task_id
1277: , p_pm_task_reference => p_pm_task_reference
1278: , p_out_task_id => l_task_id_out
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290:
1291: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1292: ( p_pa_project_id => l_project_id_out
1293: , p_pa_task_id => p_new_parent_task_id
1294: , p_pm_task_reference => p_pm_new_parent_task_reference
1295: , p_out_task_id => l_parent_task_id_out
1456:
1457: p_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459:
1460: PA_PROJECT_PVT.Convert_pm_projref_to_id
1461: ( p_pm_project_reference => p_pm_project_reference
1462: , p_pa_project_id => p_project_id
1463: , p_out_project_id => l_project_id_out
1464: , p_return_status => l_return_status
1488: THEN
1489: p_change_project_org_ok_flag := 'N';
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1491: THEN
1492: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1493: THEN
1494: pa_interface_utils_pub.map_new_amg_msg
1495: ( p_old_message_code => 'PA_PR_CANT_CHG_PROJ_TYPE'
1496: ,p_msg_attribute => 'CHANGE'
1518: ELSIF l_err_code < 0
1519: THEN
1520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1521: THEN
1522: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1523: THEN
1524: pa_interface_utils_pub.map_new_amg_msg
1525: ( p_old_message_code => 'PA_PR_CANT_CHG_PROJ_TYPE'
1526: ,p_msg_attribute => 'CHANGE'
1661:
1662: p_return_status := FND_API.G_RET_STS_SUCCESS;
1663:
1664:
1665: PA_PROJECT_PVT.Convert_pm_projref_to_id
1666: ( p_pm_project_reference => p_pm_project_reference
1667: , p_pa_project_id => p_project_id
1668: , p_out_project_id => l_project_id_out
1669: , p_return_status => l_return_status
1809:
1810: p_return_status := FND_API.G_RET_STS_SUCCESS;
1811:
1812:
1813: PA_PROJECT_PVT.Convert_pm_projref_to_id
1814: ( p_pm_project_reference => p_pm_project_reference
1815: , p_pa_project_id => p_project_id
1816: , p_out_project_id => l_project_id_out
1817: , p_return_status => l_return_status
1824: THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:
1828: PA_PROJECT_PVT.Convert_pm_taskref_to_id
1829: ( p_pa_project_id => l_project_id_out
1830: , p_pa_task_id => p_task_id
1831: , p_pm_task_reference => p_pm_task_reference
1832: , p_out_task_id => l_task_id_out
1867: THEN
1868: p_task_number_change_Ok_flag := 'N';
1869: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1870: THEN
1871: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1872: THEN
1873: pa_interface_utils_pub.map_new_amg_msg
1874: ( p_old_message_code => 'PA_CHANGE_TASK_NUM_OK_FAILED'
1875: ,p_msg_attribute => 'CHANGE'
1898: THEN
1899:
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
1903: THEN
1904: pa_interface_utils_pub.map_new_amg_msg
1905: ( p_old_message_code => 'PA_CHANGE_TASK_NUM_OK_FAILED'
1906: ,p_msg_attribute => 'CHANGE'
2899: --
2900: --
2901: --History:
2902: -- 31-JUL-1996 R. Krishnamurthy Created
2903: -- 03-DEC-1996 L. de Werker Moved from pa_project_pub to pa_project_pvt
2904: -- 12-JUL-2000 Mohnish
2905: -- added code for ROLE BASED SECURITY:
2906: -- added the call to PA_PROJECT_PARTIES_PUB.UPDATE_PROJECT_PARTY
2907: -- 19-JUL-2000 Mohnish incorporated PA_PROJECT_PARTIES_PUB API changes