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_RELATIONSHIP_PVT dependencies on FND_MSG_PUB

Line 391: x_msg_count := FND_MSG_PUB.count_msg;

387: END IF;
388:
389: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
390:
391: x_msg_count := FND_MSG_PUB.count_msg;
392: if x_msg_count = 1 then
393: pa_interface_utils_pub.get_messages
394: (p_encoded => FND_API.G_TRUE,
395: p_msg_index => 1,

Line 429: x_msg_count := FND_MSG_PUB.count_msg;

425:
426:
427: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
428:
429: x_msg_count := FND_MSG_PUB.count_msg;
430: if x_msg_count = 1 then
431: pa_interface_utils_pub.get_messages
432: (p_encoded => FND_API.G_TRUE,
433: p_msg_index => 1,

Line 459: x_msg_count := FND_MSG_PUB.count_msg;

455: pa_debug.debug('new workplan attr for task => '||l_pev_schedule_id);
456: END IF;
457:
458: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
459: x_msg_count := FND_MSG_PUB.count_msg;
460: if x_msg_count = 1 then
461: pa_interface_utils_pub.get_messages
462: (p_encoded => FND_API.G_TRUE,
463: p_msg_index => 1,

Line 651: x_msg_count := FND_MSG_PUB.count_msg;

647: WHEN FND_API.G_EXC_ERROR THEN
648: IF (p_commit = FND_API.G_TRUE) THEN
649: ROLLBACK to create_relationship_pvt;
650: END IF;
651: x_msg_count := FND_MSG_PUB.count_msg;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: WHEN OTHERS THEN
654: IF (p_commit = FND_API.G_TRUE) THEN
655: ROLLBACK to create_relationship_pvt;

Line 658: x_msg_count := FND_MSG_PUB.count_msg;

654: IF (p_commit = FND_API.G_TRUE) THEN
655: ROLLBACK to create_relationship_pvt;
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: x_msg_count := FND_MSG_PUB.count_msg;
659: --put message
660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
661: p_procedure_name => 'Create_Relationship',
662: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: x_msg_count := FND_MSG_PUB.count_msg;
659: --put message
660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
661: p_procedure_name => 'Create_Relationship',
662: p_error_text => SUBSTRB(SQLERRM,1,240));
663: RAISE;
664: END;

Line 845: x_msg_count := FND_MSG_PUB.count_msg;

841: WHEN FND_API.G_EXC_ERROR THEN
842: IF (p_commit = FND_API.G_TRUE) THEN
843: ROLLBACK to update_relationship_pvt;
844: END IF;
845: x_msg_count := FND_MSG_PUB.count_msg;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: WHEN OTHERS THEN
848: IF (p_commit = FND_API.G_TRUE) THEN
849: ROLLBACK to update_relationship_pvt;

Line 852: x_msg_count := FND_MSG_PUB.count_msg;

848: IF (p_commit = FND_API.G_TRUE) THEN
849: ROLLBACK to update_relationship_pvt;
850: END IF;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: x_msg_count := FND_MSG_PUB.count_msg;
853: --put message
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
855: p_procedure_name => 'Update_relationship',
856: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

850: END IF;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: x_msg_count := FND_MSG_PUB.count_msg;
853: --put message
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
855: p_procedure_name => 'Update_relationship',
856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: RAISE;
858: END UPDATE_RELATIONSHIP;

Line 979: x_msg_count := FND_MSG_PUB.count_msg;

975: x_msg_data => l_msg_data);
976: END IF;
977:
978: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
979: x_msg_count := FND_MSG_PUB.count_msg;
980: IF x_msg_count = 1 then
981: pa_interface_utils_pub.get_messages
982: (p_encoded => FND_API.G_TRUE,
983: p_msg_index => 1,

Line 1001: x_msg_count := FND_MSG_PUB.count_msg;

997: WHEN FND_API.G_EXC_ERROR THEN
998: IF (p_commit = FND_API.G_TRUE) THEN
999: ROLLBACK to delete_relationship_pvt;
1000: END IF;
1001: x_msg_count := FND_MSG_PUB.count_msg;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: WHEN OTHERS THEN
1004: IF (p_commit = FND_API.G_TRUE) THEN
1005: ROLLBACK to delete_relationship_pvt;

Line 1008: x_msg_count := FND_MSG_PUB.count_msg;

1004: IF (p_commit = FND_API.G_TRUE) THEN
1005: ROLLBACK to delete_relationship_pvt;
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: --put message
1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
1011: p_procedure_name => 'Delete_relationship',
1012: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: --put message
1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
1011: p_procedure_name => 'Delete_relationship',
1012: p_error_text => SUBSTRB(SQLERRM,1,240));
1013: RAISE;
1014: END DELETE_RELATIONSHIP;

Line 1235: x_msg_count := FND_MSG_PUB.count_msg;

1231: ,x_msg_data => l_msg_data
1232: );
1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: x_msg_count := FND_MSG_PUB.count_msg;
1236: IF x_msg_count = 1 then
1237: pa_interface_utils_pub.get_messages
1238: (p_encoded => FND_API.G_TRUE,
1239: p_msg_index => 1,

Line 1279: x_msg_count := FND_MSG_PUB.count_msg;

1275: ,p_status_code => null /* not applicable for intra dependency */
1276: );
1277:
1278: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1279: x_msg_count := FND_MSG_PUB.count_msg;
1280: IF x_msg_count = 1 then
1281: pa_interface_utils_pub.get_messages
1282: (p_encoded => FND_API.G_TRUE,
1283: p_msg_index => 1,

Line 1308: x_msg_count := FND_MSG_PUB.count_msg;

1304: ,x_msg_data => l_msg_data
1305: );
1306:
1307: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1308: x_msg_count := FND_MSG_PUB.count_msg;
1309: IF x_msg_count = 1 then
1310: pa_interface_utils_pub.get_messages
1311: (p_encoded => FND_API.G_TRUE,
1312: p_msg_index => 1,

Line 1384: x_msg_count := FND_MSG_PUB.count_msg;

1380: ,p_status_code => l_status_code
1381: );
1382:
1383: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1384: x_msg_count := FND_MSG_PUB.count_msg;
1385: IF x_msg_count = 1 then
1386: pa_interface_utils_pub.get_messages
1387: (p_encoded => FND_API.G_TRUE,
1388: p_msg_index => 1,

Line 1423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1419: if p_commit = FND_API.G_TRUE then
1420: rollback to create_dependency_pvt;
1421: end if;
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1424: p_procedure_name => 'CREATE_DEPENDENCY',
1425: p_error_text => SUBSTRB(SQLERRM,1,240));
1426: when OTHERS then
1427: if p_commit = FND_API.G_TRUE then

Line 1431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1427: if p_commit = FND_API.G_TRUE then
1428: rollback to create_dependency_pvt;
1429: end if;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1432: p_procedure_name => 'CREATE_DEPENDENCY',
1433: p_error_text => SUBSTRB(SQLERRM,1,240));
1434: raise;
1435: END Create_Dependency;

Line 1559: x_msg_count := FND_MSG_PUB.count_msg;

1555: ,x_return_status => l_return_status
1556: );
1557:
1558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1559: x_msg_count := FND_MSG_PUB.count_msg;
1560: IF x_msg_count = 1 then
1561: pa_interface_utils_pub.get_messages
1562: (p_encoded => FND_API.G_TRUE,
1563: p_msg_index => 1,

Line 1596: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1592: if p_commit = FND_API.G_TRUE then
1593: rollback to update_dependency_pvt;
1594: end if;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1597: p_procedure_name => 'UPDATE_DEPENDENCY',
1598: p_error_text => SUBSTRB(SQLERRM,1,240));
1599: when OTHERS then
1600: if p_commit = FND_API.G_TRUE then

Line 1604: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1600: if p_commit = FND_API.G_TRUE then
1601: rollback to update_dependency_pvt;
1602: end if;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1605: p_procedure_name => 'UPDATE_DEPENDENCY',
1606: p_error_text => SUBSTRB(SQLERRM,1,240));
1607: raise;
1608: END Update_Dependency;

Line 1740: x_msg_count := FND_MSG_PUB.count_msg;

1736: ,p_pm_product_code => null
1737: ,x_return_status => l_return_status );
1738:
1739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1740: x_msg_count := FND_MSG_PUB.count_msg;
1741: IF x_msg_count = 1 then
1742: pa_interface_utils_pub.get_messages
1743: (p_encoded => FND_API.G_TRUE,
1744: p_msg_index => 1,

Line 1776: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1772: if p_commit = FND_API.G_TRUE then
1773: rollback to delete_dependency_pvt;
1774: end if;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1777: p_procedure_name => 'DELETE_DEPENDENCY',
1778: p_error_text => SUBSTRB(SQLERRM,1,240));
1779: when OTHERS then
1780: if p_commit = FND_API.G_TRUE then

Line 1784: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1780: if p_commit = FND_API.G_TRUE then
1781: rollback to delete_dependency_pvt;
1782: end if;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1785: p_procedure_name => 'DELETE_DEPENDENCY',
1786: p_error_text => SUBSTRB(SQLERRM,1,240));
1787: raise;
1788: END Delete_Dependency;

Line 2314: x_msg_count := FND_MSG_PUB.count_msg;

2310: ,x_msg_data => x_msg_data
2311: );
2312:
2313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2314: x_msg_count := FND_MSG_PUB.count_msg;
2315: IF x_msg_count = 1 then
2316: pa_interface_utils_pub.get_messages
2317: (p_encoded => FND_API.G_TRUE,
2318: p_msg_index => 1,

Line 2358: x_msg_count := FND_MSG_PUB.count_msg;

2354: ,x_msg_data => x_msg_data
2355: );
2356:
2357: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2358: x_msg_count := FND_MSG_PUB.count_msg;
2359: IF x_msg_count = 1 then
2360: pa_interface_utils_pub.get_messages
2361: (p_encoded => FND_API.G_TRUE,
2362: p_msg_index => 1,

Line 2382: x_msg_count := FND_MSG_PUB.count_msg;

2378: x_return_status := FND_API.G_RET_STS_SUCCESS;
2379:
2380: EXCEPTION -- 4537865
2381: WHEN FND_API.G_EXC_ERROR THEN
2382: x_msg_count := FND_MSG_PUB.count_msg;
2383: x_return_status := FND_API.G_RET_STS_ERROR;
2384: WHEN OTHERS THEN
2385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2386: x_msg_count := FND_MSG_PUB.count_msg;

Line 2386: x_msg_count := FND_MSG_PUB.count_msg;

2382: x_msg_count := FND_MSG_PUB.count_msg;
2383: x_return_status := FND_API.G_RET_STS_ERROR;
2384: WHEN OTHERS THEN
2385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2386: x_msg_count := FND_MSG_PUB.count_msg;
2387: --put message
2388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2389: p_procedure_name => 'Copy_Intra_Dependency',
2390: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2384: WHEN OTHERS THEN
2385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2386: x_msg_count := FND_MSG_PUB.count_msg;
2387: --put message
2388: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2389: p_procedure_name => 'Copy_Intra_Dependency',
2390: p_error_text => SUBSTRB(SQLERRM,1,240));
2391: RAISE;
2392:

Line 2464: x_msg_count := FND_MSG_PUB.count_msg;

2460: ,x_msg_data => x_msg_data
2461: );
2462:
2463: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2464: x_msg_count := FND_MSG_PUB.count_msg;
2465: IF x_msg_count = 1 then
2466: pa_interface_utils_pub.get_messages
2467: (p_encoded => FND_API.G_TRUE,
2468: p_msg_index => 1,

Line 2556: x_msg_count := FND_MSG_PUB.count_msg;

2552: );
2553: -- 4537865 : This is wrong.Check shud be made against x_return_status :
2554: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2555: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2556: x_msg_count := FND_MSG_PUB.count_msg;
2557: IF x_msg_count = 1 then
2558: pa_interface_utils_pub.get_messages
2559: (p_encoded => FND_API.G_TRUE,
2560: p_msg_index => 1,

Line 2577: x_msg_count := FND_MSG_PUB.count_msg;

2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574: --
2575: EXCEPTION -- 4537865
2576: WHEN FND_API.G_EXC_ERROR THEN
2577: x_msg_count := FND_MSG_PUB.count_msg;
2578: x_return_status := FND_API.G_RET_STS_ERROR;
2579: WHEN OTHERS THEN
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2581: x_msg_count := FND_MSG_PUB.count_msg;

Line 2581: x_msg_count := FND_MSG_PUB.count_msg;

2577: x_msg_count := FND_MSG_PUB.count_msg;
2578: x_return_status := FND_API.G_RET_STS_ERROR;
2579: WHEN OTHERS THEN
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2581: x_msg_count := FND_MSG_PUB.count_msg;
2582: --put message
2583: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2584: p_procedure_name => 'Copy_Inter_Project_Dependency',
2585: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2583: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2579: WHEN OTHERS THEN
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2581: x_msg_count := FND_MSG_PUB.count_msg;
2582: --put message
2583: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2584: p_procedure_name => 'Copy_Inter_Project_Dependency',
2585: p_error_text => SUBSTRB(SQLERRM,1,240));
2586: RAISE;
2587:

Line 2767: x_msg_count := FND_MSG_PUB.count_msg;

2763: ,x_msg_count => x_msg_count
2764: ,x_msg_data => x_msg_data
2765: );
2766: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2767: x_msg_count := FND_MSG_PUB.count_msg;
2768: IF x_msg_count = 1 then
2769: pa_interface_utils_pub.get_messages
2770: (p_encoded => FND_API.G_TRUE,
2771: p_msg_index => 1,

Line 2833: x_msg_count := FND_MSG_PUB.count_msg;

2829: -- ,x_msg_data => x_msg_data
2830: );
2831:
2832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2833: x_msg_count := FND_MSG_PUB.count_msg;
2834: /* IF x_msg_count = 1 then
2835: pa_interface_utils_pub.get_messages
2836: (p_encoded => FND_API.G_TRUE,
2837: p_msg_index => 1,

Line 2912: x_msg_count := FND_MSG_PUB.count_msg;

2908: -- ,x_msg_data => x_msg_data
2909: );
2910:
2911: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2912: x_msg_count := FND_MSG_PUB.count_msg;
2913: /* IF x_msg_count = 1 then
2914: pa_interface_utils_pub.get_messages
2915: (p_encoded => FND_API.G_TRUE,
2916: p_msg_index => 1,

Line 2937: x_msg_count := FND_MSG_PUB.count_msg;

2933: ,x_msg_data => x_msg_data
2934: );
2935:
2936: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2937: x_msg_count := FND_MSG_PUB.count_msg;
2938: Close Update_Publ_Ver;
2939: Raise FND_API.G_EXC_ERROR;
2940: END IF;
2941: */

Line 2963: x_msg_count := FND_MSG_PUB.count_msg;

2959: ,x_msg_data => x_msg_data
2960: );
2961:
2962: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2963: x_msg_count := FND_MSG_PUB.count_msg;
2964: IF x_msg_count = 1 Then
2965: pa_interface_utils_pub.get_messages
2966: (p_encoded => FND_API.G_TRUE,
2967: p_msg_index => 1,

Line 2981: x_msg_count := FND_MSG_PUB.count_msg;

2977: Close Delete_Publ_Ver;
2978: */
2979: EXCEPTION -- 4537865
2980: WHEN FND_API.G_EXC_ERROR THEN
2981: x_msg_count := FND_MSG_PUB.count_msg;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: WHEN OTHERS THEN
2984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2985: x_msg_count := FND_MSG_PUB.count_msg;

Line 2985: x_msg_count := FND_MSG_PUB.count_msg;

2981: x_msg_count := FND_MSG_PUB.count_msg;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: WHEN OTHERS THEN
2984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2985: x_msg_count := FND_MSG_PUB.count_msg;
2986: --put message
2987: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2988: p_procedure_name => 'Copy_Intra_Dependency',
2989: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2987: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2983: WHEN OTHERS THEN
2984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2985: x_msg_count := FND_MSG_PUB.count_msg;
2986: --put message
2987: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2988: p_procedure_name => 'Copy_Intra_Dependency',
2989: p_error_text => SUBSTRB(SQLERRM,1,240));
2990: RAISE;
2991:

Line 3094: x_msg_count := FND_MSG_PUB.count_msg;

3090: ,x_return_status => x_return_status
3091: ,x_msg_count => x_msg_count
3092: ,x_msg_data => x_msg_data);
3093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3094: x_msg_count := FND_MSG_PUB.count_msg;
3095: IF x_msg_count = 1 THEN
3096: pa_interface_utils_pub.get_messages
3097: (p_encoded => FND_API.G_TRUE,
3098: p_msg_index => 1,

Line 3138: x_msg_count := FND_MSG_PUB.count_msg;

3134: ,x_return_status => x_return_status
3135: ,x_msg_count => x_msg_count
3136: ,x_msg_data => x_msg_data);
3137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3138: x_msg_count := FND_MSG_PUB.count_msg;
3139: IF x_msg_count = 1 THEN
3140: pa_interface_utils_pub.get_messages
3141: (p_encoded => FND_API.G_TRUE,
3142: p_msg_index => 1,

Line 3231: x_msg_count := FND_MSG_PUB.count_msg;

3227: pa_debug.debug('new workplan attr for task after call to PA_TASK_PUB1.Create_Schedule_Version=> '||x_pev_schedule_id);
3228: END IF;
3229: --
3230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3231: x_msg_count := FND_MSG_PUB.count_msg;
3232: IF x_msg_count = 1 THEN
3233: pa_interface_utils_pub.get_messages
3234: (p_encoded => FND_API.G_TRUE,
3235: p_msg_index => 1,

Line 3283: x_msg_count := FND_MSG_PUB.count_msg;

3279: ,p_comments => p_comment --Bug No 3668113
3280: ,p_status_code => null
3281: );
3282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3283: x_msg_count := FND_MSG_PUB.count_msg;
3284: IF x_msg_count = 1 THEN
3285: pa_interface_utils_pub.get_messages
3286: (p_encoded => FND_API.G_TRUE,
3287: p_msg_index => 1,

Line 3320: x_msg_count := FND_MSG_PUB.count_msg;

3316: x_msg_data => x_msg_data
3317: );
3318:
3319: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3320: x_msg_count := FND_MSG_PUB.count_msg;
3321: IF x_msg_count = 1 THEN
3322: pa_interface_utils_pub.get_messages
3323: (p_encoded => FND_API.G_TRUE,
3324: p_msg_index => 1,

Line 3380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

3376:
3377: -- End fix for Bug # 4485908.
3378:
3379: WHEN OTHERS THEN
3380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3381: p_procedure_name => 'Insert_Subproject_Association',
3382: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
3383: RAISE FND_API.G_EXC_ERROR;
3384: END;

Line 3411: x_msg_count := FND_MSG_PUB.count_msg;

3407: x_lnk_task_elem_ver_id := NULL ;
3408: x_object_relationship_id := NULL ;
3409: x_pev_schedule_id := NULL;
3410:
3411: x_msg_count := FND_MSG_PUB.count_msg;
3412: x_return_status := FND_API.G_RET_STS_ERROR;
3413: WHEN OTHERS THEN
3414: IF (p_commit = FND_API.G_TRUE) THEN
3415: ROLLBACK to Insert_Subproject_Association;

Line 3424: x_msg_count := FND_MSG_PUB.count_msg;

3420: x_object_relationship_id := NULL ;
3421: x_pev_schedule_id := NULL;
3422:
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: x_msg_count := FND_MSG_PUB.count_msg;
3425: --put message
3426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3427: p_procedure_name => 'Insert_Subproject_Association',
3428: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

3422:
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: x_msg_count := FND_MSG_PUB.count_msg;
3425: --put message
3426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3427: p_procedure_name => 'Insert_Subproject_Association',
3428: p_error_text => SUBSTRB(SQLERRM,1,240));
3429: RAISE;
3430: END Insert_Subproject_Association;

Line 3833: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.

3829: --bug 3983361
3830: IF p_validation_level > 0 THEN
3831: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3832:
3833: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.
3834:
3835: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3836:
3837: end if; -- Fix for Bug # 4256435.

Line 3915: x_msg_count := FND_MSG_PUB.count_msg;

3911: ,x_msg_data => x_msg_data
3912: );
3913: --
3914: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3915: x_msg_count := FND_MSG_PUB.count_msg;
3916: IF x_msg_count = 1 then
3917: pa_interface_utils_pub.get_messages
3918: (p_encoded => FND_API.G_TRUE,
3919: p_msg_index => 1,

Line 3983: x_msg_count := FND_MSG_PUB.count_msg;

3979: ,x_msg_data => x_msg_data
3980: );
3981: --
3982: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3983: x_msg_count := FND_MSG_PUB.count_msg;
3984: IF x_msg_count = 1 then
3985: pa_interface_utils_pub.get_messages
3986: (p_encoded => FND_API.G_TRUE,
3987: p_msg_index => 1,

Line 4050: x_msg_count := FND_MSG_PUB.count_msg;

4046: ,x_msg_data => x_msg_data
4047: );
4048: --
4049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4050: x_msg_count := FND_MSG_PUB.count_msg;
4051: IF x_msg_count = 1 then
4052: pa_interface_utils_pub.get_messages
4053: (p_encoded => FND_API.G_TRUE,
4054: p_msg_index => 1,

Line 4118: x_msg_count := FND_MSG_PUB.count_msg;

4114: ,x_msg_count => x_msg_count
4115: ,x_msg_data => x_msg_data
4116: );
4117: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4118: x_msg_count := FND_MSG_PUB.count_msg;
4119: IF x_msg_count = 1 then
4120: pa_interface_utils_pub.get_messages
4121: (p_encoded => FND_API.G_TRUE,
4122: p_msg_index => 1,

Line 4239: x_msg_count := FND_MSG_PUB.count_msg;

4235: ,x_msg_count => x_msg_count
4236: ,x_msg_data => x_msg_data);
4237:
4238: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4239: x_msg_count := FND_MSG_PUB.count_msg;
4240: IF x_msg_count = 1 then
4241: pa_interface_utils_pub.get_messages
4242: (p_encoded => FND_API.G_TRUE,
4243: p_msg_index => 1,

Line 4267: x_msg_count := FND_MSG_PUB.count_msg;

4263: WHEN FND_API.G_EXC_ERROR THEN
4264: IF (p_commit = FND_API.G_TRUE) THEN
4265: ROLLBACK to Create_Subproject_Ass_pvt;
4266: END IF;
4267: x_msg_count := FND_MSG_PUB.count_msg;
4268: x_return_status := FND_API.G_RET_STS_ERROR;
4269: WHEN OTHERS THEN
4270: IF (p_commit = FND_API.G_TRUE) THEN
4271: ROLLBACK to Create_Subproject_Ass_pvt;

Line 4274: x_msg_count := FND_MSG_PUB.count_msg;

4270: IF (p_commit = FND_API.G_TRUE) THEN
4271: ROLLBACK to Create_Subproject_Ass_pvt;
4272: END IF;
4273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4274: x_msg_count := FND_MSG_PUB.count_msg;
4275: --put message
4276: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4277: p_procedure_name => 'Create_Subproject_Association',
4278: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4276: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

4272: END IF;
4273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4274: x_msg_count := FND_MSG_PUB.count_msg;
4275: --put message
4276: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4277: p_procedure_name => 'Create_Subproject_Association',
4278: p_error_text => SUBSTRB(SQLERRM,1,240));
4279: RAISE;
4280: END Create_Subproject_Association;

Line 4404: x_msg_count := FND_MSG_PUB.count_msg;

4400: WHEN FND_API.G_EXC_ERROR THEN
4401: IF (p_commit = FND_API.G_TRUE) THEN
4402: ROLLBACK to update_subproject_ass_pvt;
4403: END IF;
4404: x_msg_count := FND_MSG_PUB.count_msg;
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406: WHEN OTHERS THEN
4407: IF (p_commit = FND_API.G_TRUE) THEN
4408: ROLLBACK TO update_subproject_ass_pvt;

Line 4411: FND_MSG_PUB.add_exc_msg(

4407: IF (p_commit = FND_API.G_TRUE) THEN
4408: ROLLBACK TO update_subproject_ass_pvt;
4409: END IF;
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4411: FND_MSG_PUB.add_exc_msg(
4412: p_pkg_name => 'PA_RELATIONSHIPS_PVT1',
4413: p_procedure_name => 'update_subproject_association',
4414: p_error_text => SUBSTRB(SQLERRM,1,240));
4415: ROLLBACK TO update_subproject_association;

Line 4652: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

4648:
4649: -- End fix for Bug # 4485908.
4650:
4651: WHEN OTHERS THEN
4652: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4653: p_procedure_name => 'Delete_SubProject_Association',
4654: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
4655: RAISE FND_API.G_EXC_ERROR;
4656: END;

Line 4680: x_msg_count := FND_MSG_PUB.count_msg;

4676: ,x_return_status => x_return_status
4677: );
4678: --
4679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4680: x_msg_count := FND_MSG_PUB.count_msg;
4681: IF x_msg_count = 1 then
4682: pa_interface_utils_pub.get_messages
4683: (p_encoded => FND_API.G_TRUE,
4684: p_msg_index => 1,

Line 4717: x_msg_count := FND_MSG_PUB.count_msg;

4713: x_msg_count => x_msg_count,
4714: x_msg_data => x_msg_data);
4715: --
4716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4717: x_msg_count := FND_MSG_PUB.count_msg;
4718: IF x_msg_count = 1 then
4719: pa_interface_utils_pub.get_messages
4720: (p_encoded => FND_API.G_TRUE,
4721: p_msg_index => 1,

Line 4766: x_msg_count := FND_MSG_PUB.count_msg;

4762: , x_msg_data => x_msg_data);
4763:
4764: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4765:
4766: x_msg_count := FND_MSG_PUB.count_msg;
4767:
4768: if x_msg_count = 1 then
4769:
4770: pa_interface_utils_pub.get_messages

Line 4818: x_msg_count := FND_MSG_PUB.count_msg;

4814: ,x_msg_count => x_msg_count
4815: ,x_msg_data => x_msg_data);
4816:
4817: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4818: x_msg_count := FND_MSG_PUB.count_msg;
4819: IF x_msg_count = 1 then
4820: pa_interface_utils_pub.get_messages
4821: (p_encoded => FND_API.G_TRUE,
4822: p_msg_index => 1,

Line 4855: x_msg_count := FND_MSG_PUB.count_msg;

4851: WHEN FND_API.G_EXC_ERROR THEN
4852: IF (p_commit = FND_API.G_TRUE) THEN
4853: ROLLBACK to delete_subproject_ass_pvt;
4854: END IF;
4855: x_msg_count := FND_MSG_PUB.count_msg;
4856: x_return_status := FND_API.G_RET_STS_ERROR;
4857: WHEN OTHERS THEN
4858: IF (p_commit = FND_API.G_TRUE) THEN
4859: ROLLBACK to delete_subproject_ass_pvt;

Line 4862: x_msg_count := FND_MSG_PUB.count_msg;

4858: IF (p_commit = FND_API.G_TRUE) THEN
4859: ROLLBACK to delete_subproject_ass_pvt;
4860: END IF;
4861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4862: x_msg_count := FND_MSG_PUB.count_msg;
4863: --put message
4864: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
4865: p_procedure_name => 'Delete_SubProject_Association',
4866: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4864: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

4860: END IF;
4861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4862: x_msg_count := FND_MSG_PUB.count_msg;
4863: --put message
4864: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
4865: p_procedure_name => 'Delete_SubProject_Association',
4866: p_error_text => SUBSTRB(SQLERRM,1,240));
4867: RAISE;
4868: END Delete_SubProject_Association;

Line 5064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5060:
5061: -- End fix for Bug # 4485908.
5062:
5063: WHEN OTHERS THEN
5064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5065: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5066: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5067: RAISE FND_API.G_EXC_ERROR;
5068: END;

Line 5093: x_msg_count := FND_MSG_PUB.count_msg;

5089: WHEN FND_API.G_EXC_ERROR THEN
5090: IF (p_commit = FND_API.G_TRUE) THEN
5091: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;
5092: END IF;
5093: x_msg_count := FND_MSG_PUB.count_msg;
5094: x_return_status := FND_API.G_RET_STS_ERROR;
5095: WHEN OTHERS THEN
5096: IF (p_commit = FND_API.G_TRUE) THEN
5097: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;

Line 5100: x_msg_count := FND_MSG_PUB.count_msg;

5096: IF (p_commit = FND_API.G_TRUE) THEN
5097: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;
5098: END IF;
5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5100: x_msg_count := FND_MSG_PUB.count_msg;
5101: --put message
5102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5103: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5104: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5098: END IF;
5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5100: x_msg_count := FND_MSG_PUB.count_msg;
5101: --put message
5102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5103: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5104: p_error_text => SUBSTRB(SQLERRM,1,240));
5105: RAISE;
5106: END Copy_OG_Lnk_For_Subproj_Ass;

Line 5322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5318:
5319: -- End fix for Bug # 4485908.
5320:
5321: WHEN OTHERS THEN
5322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5323: p_procedure_name => 'Insert_Subproject_Association',
5324: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5325: RAISE FND_API.G_EXC_ERROR;
5326: END;

Line 5350: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5346:
5347: -- End fix for Bug # 4485908.
5348:
5349: WHEN OTHERS THEN
5350: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5351: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5352: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5353: RAISE FND_API.G_EXC_ERROR;
5354: END;

Line 5403: x_msg_count := FND_MSG_PUB.count_msg;

5399: WHEN FND_API.G_EXC_ERROR THEN
5400: IF (p_commit = FND_API.G_TRUE) THEN
5401: ROLLBACK to Move_CI_Lnk_For_subproj_step2;
5402: END IF;
5403: x_msg_count := FND_MSG_PUB.count_msg;
5404: x_return_status := FND_API.G_RET_STS_ERROR;
5405: WHEN OTHERS THEN
5406: IF (p_commit = FND_API.G_TRUE) THEN
5407: ROLLBACK to Move_CI_Lnk_For_subproj_step2;

Line 5410: x_msg_count := FND_MSG_PUB.count_msg;

5406: IF (p_commit = FND_API.G_TRUE) THEN
5407: ROLLBACK to Move_CI_Lnk_For_subproj_step2;
5408: END IF;
5409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5410: x_msg_count := FND_MSG_PUB.count_msg;
5411: --put message
5412: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5413: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5414: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5412: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5408: END IF;
5409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5410: x_msg_count := FND_MSG_PUB.count_msg;
5411: --put message
5412: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5413: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5414: p_error_text => SUBSTRB(SQLERRM,1,240));
5415: RAISE;
5416: END Move_CI_Lnk_For_subproj_step2;

Line 5503: x_msg_count := FND_MSG_PUB.count_msg;

5499: WHEN FND_API.G_EXC_ERROR THEN
5500: IF (p_commit = FND_API.G_TRUE) THEN
5501: ROLLBACK to Move_CI_Lnk_For_subproj_step1;
5502: END IF;
5503: x_msg_count := FND_MSG_PUB.count_msg;
5504: x_return_status := FND_API.G_RET_STS_ERROR;
5505: WHEN OTHERS THEN
5506: IF (p_commit = FND_API.G_TRUE) THEN
5507: ROLLBACK to Move_CI_Lnk_For_subproj_step1;

Line 5510: x_msg_count := FND_MSG_PUB.count_msg;

5506: IF (p_commit = FND_API.G_TRUE) THEN
5507: ROLLBACK to Move_CI_Lnk_For_subproj_step1;
5508: END IF;
5509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5510: x_msg_count := FND_MSG_PUB.count_msg;
5511: --put message
5512: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5513: p_procedure_name => 'Move_CI_Lnk_For_subproj_step1',
5514: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5512: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5508: END IF;
5509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5510: x_msg_count := FND_MSG_PUB.count_msg;
5511: --put message
5512: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5513: p_procedure_name => 'Move_CI_Lnk_For_subproj_step1',
5514: p_error_text => SUBSTRB(SQLERRM,1,240));
5515: RAISE;
5516: END Move_CI_Lnk_For_subproj_step1;

Line 5643: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5639: if p_commit = FND_API.G_TRUE then
5640: rollback to UPDATE_PARENT_WBS_FLAG_DIRTY;
5641: end if;
5642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5643: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5644: p_procedure_name => 'UPDATE_PARENT_WBS_FLAG_DIRTY',
5645: p_error_text => SUBSTRB(SQLERRM,1,240));
5646: when OTHERS then
5647: if p_commit = FND_API.G_TRUE then

Line 5651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5647: if p_commit = FND_API.G_TRUE then
5648: rollback to UPDATE_PARENT_WBS_FLAG_DIRTY;
5649: end if;
5650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5651: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5652: p_procedure_name => 'UPDATE_PARENT_WBS_FLAG_DIRTY',
5653: p_error_text => SUBSTRB(SQLERRM,1,240));
5654: raise;
5655: END UPDATE_PARENT_WBS_FLAG_DIRTY;